------------------------------- Hammad 2020-09-06 --------------------
ALTER TABLE dbo.WF_CompensationAllowanceTypes ADD
	ShiftCode int NULL
GO

------------------------------- End 2020-09-06 --------------------
------------------------------- A.Khaled 2020-09-06 --------------------------    
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(368,N'Suppliers',N'الموردين',358,NULL,NULL,'fa fa-thumb-tack',NULL,1,1,1)

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(369,N'Stores',N'المخازن',358,NULL,NULL,'fa fa-thumb-tack',NULL,2,1,1)

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(368,12)
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(369,12)
Go

UPDATE [dbo].[SystemMenu] SET [Name]=N'Supplier',[Arabic_Name]=N'المورد',[ParentID]=368  WHERE SystemMenuCode = (367)
UPDATE [dbo].[SystemMenu] SET [Name]=N'Supplier Group',[Arabic_Name]=N'مجموعة المورد',[ParentID]=368  WHERE SystemMenuCode = (360)
UPDATE [dbo].[SystemMenu] SET [Name]=N'Stores',[Arabic_Name]=N'المخازن',[ParentID]=358  WHERE SystemMenuCode = (369)
UPDATE [dbo].[SystemMenu] SET [ParentID]=368  WHERE SystemMenuCode IN (360)
UPDATE [dbo].[SystemMenu] SET [ParentID]=369  WHERE SystemMenuCode IN (359, 361, 362, 363, 364, 365, 366)

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14166, N'الموردين', N'Suppliers', 368, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14167, N'المخازن', N'Stores', 369, 1)
Go
------------------------------- End 2020-09-06 --------------------------
------------------------------- Hammad 2020-09-07 -----------------------
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) 
VALUES (60, N'Time Attendance', N'Time Attendance', N'WFCheckDayOffDependOn')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey])
 VALUES (61, N'Time Schedule', N'Time Scheduel', N'WFCheckDayOffDependOn')
 Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFCheckDayOffDependOn', N'Check DayOff Depend On', N'مراجعة يوم الراحة يعتمد على ', N'60', 2, 2, 6, 1, NULL, NULL, 21)
 Go
 ------------------------------- End 2020-09-07 -----------------------
 ------------------------------- Hammad 2020-09-08 --------------------
 INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (11, N'Inventory', N'المخازن')
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'InvOverdraft', N'Overdraft ?', N'السحب على المكشوف ؟', N'false', 11, 1, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'InvWorkByBarCode', N'Work By BarCode ?', N'العمل بالباركود ؟', N'false', 11, 2, 1, 1, NULL, NULL, NULL)
 GO

 INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode]) VALUES (11, 12)
 Go
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (370, N' Work Settings', N'إعدادات العمل', 358, N'/Inventory/SystemConfig', N'Index', N'fa fa-thumb-tack', N'get', 3, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (1225, N'إعدادات عمل المخازن', N'Inventory Config', 370, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1226, N'عرض إعدادات العمل', N'View Inventory Config', 370, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1227, N'حفظ إعدادات العمل', N'Save Inventory Config', 370, 2)

GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 370, 12)
GO
 ------------------------------- End 2020-09-08 --------------------
 ------------------------------- Hammad 2020-09-09 -----------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'InvTransStoreNeedApprove', N'Trans Store Need Approve ?', N'الحركة المخزنية تحتاج لموافقة ؟', N'false', 11, 3, 1, 1, NULL, NULL, NULL)

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'InvSubAccountLevelNo', N'Sub Account Level No', N'رقم مستوى الحساب الفرعى', N'4', 11, 4, 2, 1, NULL, NULL, NULL)
Go


Alter PROCEDURE [dbo].[GetStoreLevels]
    @id [int]
  
AS
BEGIN
    
   declare @tblStoreLevels table(
    		StoreCode int
    			
    	);
    
    	             with StoreLevels as(
    	             	select StoreCode from [Inv].[Store] where StoreCode = @id
    	             	union all
    	             	select store2.StoreCode from [Inv].[Store]  store2, StoreLevels  
    	             	where store2.ParentId = StoreLevels.StoreCode
    	             ) Insert into @tblStoreLevels select * from StoreLevels option (maxrecursion 0);

					 select * from @tblStoreLevels
    
END




GO



 ------------------------------- End 2020-09-09 -----------------
 ------------------------------- A.Khaled 2020-09-09 -------------------------- 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(371,N'Transaction Type',N'أنواع الحركات',369,N'/Inventory/TransactionType',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(371,12)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14168,N'أنواع الحركات',N'Transaction Type',371,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14169,N'عرض أنواع الحركات',N'View Transaction Type',371,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14170,N'إضافة أنواع الحركات',N'Add Transaction Type',371,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14171,N'تعديل أنواع الحركات',N'Edit Transaction Type',371,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14172,N'حذف أنواع الحركات',N'Delete Transaction Type',371,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14173,N'حفظ أنواع الحركات',N'Save Transaction Type',371,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (269, N'Inventory', N'TransactionType', N'Index', 0, N'get', 14168)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (270, N'Inventory', N'TransactionType', N'TransactionType_Read', 0, N'post', 14169)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (271, N'Inventory', N'TransactionType', N'Save', 1, N'get', 14170)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (272, N'Inventory', N'TransactionType', N'Save', 2, N'get', 14171)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (273, N'Inventory', N'TransactionType', N'Delete', 0, N'post', 14172)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (274, N'Inventory', N'TransactionType', N'Save', 0, N'post', 14173)
Go
------------------------------- End 2020-09-09 --------------------------
------------------------------- Hammad 2020-09-10 -----------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (372, N'Store  Privilege', N'صلاحيات  المخازن ', 369, N'/Inventory/StoreUserPrivilege', N'Index', N'fa fa-thumb-tack', N'get', 9, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14174, N'صلاحيات  المخازن', N'Store  Privilege', 372, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14175, N'عرض صلاحيات  المخازن', N'View Store  Privilege', 372, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14176, N'إضافة صلاحيات  المخازن', N'Add Store  Privilege', 372, 2)
Go

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 372, 12)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (275, N'Inventory', N'StoreUserPrivilege', N'Index', 0, N'get', 14174)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (276, N'Inventory', N'StoreUserPrivilege', N'StoreTree_Read', 0, N'get', 14175)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (277, N'Inventory', N'StoreUserPrivilege', N'Save', 0, N'post', 14176)
Go
------------------------------- End 2020-09-10 --------------------------
------------------------------- Ali 2020-09-13 --------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(373,N'TransactionTypePrivilege',N'صلاحيات أنواع الحركات',369,N'/Inventory/TransactionTypePrivilege',N'Index','fa fa-thumb-tack',N'get',10,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(373,12)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14177,N'صلاحيات أنواع الحركات',N'TransactionTypePrivilege',373,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14178,N'عرض صلاحيات أنواع الحركات',N'View TransactionTypePrivilege',373,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14179,N'إضافة صلاحيات أنواع الحركات',N'Add TransactionTypePrivilege',373,2)

Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (278, N'Inventory', N'TransactionTypePrivilege', N'Index', 0, N'get', 14177)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (279, N'Inventory', N'TransactionTypePrivilege', N'TransactionTypePrivilege_Read', 0, N'post', 14178)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (280, N'Inventory', N'TransactionTypePrivilege', N'Save', 2, N'post', 14179)
Go
------------------------------- End 2020-09-13 --------------------------
