﻿----------------------------------------- AK 2026-03-26 -----------------------
UPDATE AppModule SET Name=N'Workflow' WHERE AppModuleCode=1
GO
UPDATE AppModule SET Name=N'AC' WHERE AppModuleCode=2
GO
UPDATE AppModule SET Name=N'PMS' WHERE AppModuleCode=8
GO
UPDATE AppModule SET Name=N'GL' WHERE AppModuleCode=18
GO
-----------------------------------------END AK 2026-03-26 --------------------
--------------------------Shehab 2026-03-24---------------------------

update WF_RequestType set IsSmartRequest = 1 where RequestTypeId in (27)
Go

--------------------------ENd 2026-03-24---------------------------
--------------------------Shehab 2026-03-26---------------------------

update WF_RequestType set isarchive = 1 where RequestTypeId = 19
update WF_RequestType set isarchive = 1 where RequestTypeId = 17
update WF_RequestType set isarchive = 1 where RequestTypeId = 13
GO
--------------------------ENd 2026-03-26---------------------------
--------------------------Shehab 2026-03-26---------------------------

update wf_requesttype set issmartrequest = 1 where RequestTypeId = 21

--------------------------ENd 2026-03-26---------------------------
--------------------------Ali 2026-03-29---------------------------
		GO		
CREATE TABLE [dbo].[SystemLanguages](
	[LanguageCode] [int] NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Direction] [nvarchar](20) NOT NULL,
	[Symbol] [nvarchar](20) NOT NULL,
	[IsActive] [bit] NOT NULL,
	[SecondDirection] [nvarchar](20) NULL,
 CONSTRAINT [PK_SystemLanguagess] PRIMARY KEY CLUSTERED 
(
	[LanguageCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[SystemLanguages] ([LanguageCode], [Name], [Direction], [Symbol], [IsActive], [SecondDirection]) VALUES (1, N'عربى', N'rtl', N'ar', 1, NULL)
INSERT [dbo].[SystemLanguages] ([LanguageCode], [Name], [Direction], [Symbol], [IsActive], [SecondDirection]) VALUES (2, N'English', N'ltr', N'en', 1, N'rtl')
INSERT [dbo].[SystemLanguages] ([LanguageCode], [Name], [Direction], [Symbol], [IsActive], [SecondDirection]) VALUES (3, N'frinch', N'ltr', N'fr', 0, NULL)
INSERT [dbo].[SystemLanguages] ([LanguageCode], [Name], [Direction], [Symbol], [IsActive], [SecondDirection]) VALUES (4, N'Ελληνικά', N'ltr', N'el', 0, NULL)
GO
ALTER TABLE [dbo].[SystemLanguages] ADD  CONSTRAINT [DF_SystemLanguagess_IsActive]  DEFAULT ((0)) FOR [IsActive]
GO
--------------------------ENd 2026-03-29---------------------------
----------------------------------------- AK 2026-03-31 -----------------------
ALTER TABLE dbo.DashboardCategoriesLabels ADD IsShowYearMonth bit NOT NULL CONSTRAINT DF_DashboardCategoriesLabels_IsShowYearMonth DEFAULT 0
GO
UPDATE dbo.DashboardCategoriesLabels SET IsShowYearMonth=1 WHERE DashboardCategoryLabelCode IN (20,21)
GO
-----------------------------------------END AK 2026-03-31 --------------------
----------------------------------------- AK 2026-04-01 -----------------------
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100023, N'502-PurchaseItems', N'502-مشتريات الأصناف', N'502-PurchaseItems.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'502-PurchaseItems-EN.rpt', NULL, NULL, N'502-PurchaseItems', 0, 0, 0, NULL, NULL, 0)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100024, N'503-Supplier Procurement', N'503-مشتريات الموردين', N'503-PurchaseSuppliers.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'503-PurchaseSuppliers-EN.rpt', NULL, NULL, N'503-PurchaseSuppliers', 0, 0, 0, NULL, NULL, 0)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100025, N'504-Purchase Invoices', N'504-فواتير المشتريات', N'504-PurchaseInvoiceTotal.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'504-PurchaseInvoiceTotal-EN.rpt', NULL, NULL, N'504-Purchase Invoices', 0, 0, 0, NULL, NULL, 0)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100026, N'703-SalesItems', N'703-مبيعات الأصناف', N'703-SalesItems.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'703-SalesItems-EN.rpt', NULL, NULL, N'703-SalesItems', 0, 0, 0, NULL, NULL, 0)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100027, N'704-SalesSuppliers', N'704-مبيعات الموردين', N'704-SalesSuppliers.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'704-SalesSuppliers-EN.rpt', NULL, NULL, N'704-SalesSuppliers', 0, 0, 0, NULL, NULL, 0)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode], [IsPredefined]) VALUES (100028, N'705-SalesInvoiceTotal', N'705-فواتير مبيعات إجمالية', N'705-SalesInvoiceTotal.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'705-SalesInvoiceTotal-EN.rpt', NULL, NULL, N'705-SalesInvoiceTotal', 0, 0, 0, NULL, NULL, 0)
GO
INSERT INTO [dbo].[ParameterReports] ([ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (18, 100023, 0, NULL, NULL, 16, 0)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100023, 17)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100024, 17)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100025, 17)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100026, 21)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100027, 21)
GO
INSERT [dbo].[ReportsAppModules] ([ReportCode], [AppModuleCode]) VALUES (100028, 21)
GO
-----------------------------------------END AK 2026-04-01 --------------------