﻿
-------------------------------Ali 2022-03-16---

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(596,N'General Preparation',N'تهيئه عامه',583,N'/GenerlLedger/GeneralPreparation',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(596,18)
Go
  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (23050, N'التهيئه عامه', N'General Preparation', 596, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (23051, N'حفظ التهيئه عامه', N'Save General Preparation', 596, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1000,N'GenerlLedger',N'GeneralPreparation',N'Index',0,N'get',23050)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1001,N'GenerlLedger',N'GeneralPreparation',N'Save',0,N'post',23051)
Go
-------------------------------End 2022-03-16---
-------------------------------Ali 2022-03-17---

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ACC_HaveOldAccountChart',N'? Have Old Account Chart',N'هل لديك دليل حسابات قديم ؟',N'true',18,2,1,1,Null,Null,null)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ACC_NumberOfDecimals',N'Number of decimals',N'عدد العلامات العشريه',N'2',18,3,2,1,Null,Null,Null)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ACC_MonthOfBeginningYear',N'Month Of beginning year',N'شهر بداية السنه',N'1',18,4,2,1,Null,Null,Null)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ACC_OperatingYear',N'Operating Year',N'سنة بداية التشغيل',N'2022',18,5,2,1,Null,Null,Null)
Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFViewPrintRequestWithSign',N'View Print Request With Signationature',N'عرض طباعة الطلب بالاعتماد',N'true',1,41,1,1,Null,Null,Null)
Go

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WF_DisplayTrackApprovalMangerName',N'Display Track Approval Manger Name',N'عرض اسم المسؤول عن الاعتماد',N'false',2,2,1,1,Null,Null,50)
Go


-------------------------------End 2022-03-17---
-------------------------------Hammad 2022-03-17---
 
alter PROCEDURE [dbo].[Emp_GetEmployeeBalanceCheck] 
(
	@EmpCode int,
	@PYear	 int
)
AS
SELECT 

       [EmployeeCode]
	   ,[PYear]
	   ,[Open_Balanc]
	  ,[Annual01]
      ,[Annual02]
      ,[Annual03]
      ,[Annual04]
      ,[Annual05]
      ,[Annual06]
      ,[Annual07]
      ,[Annual08]
      ,[Annual09]
      ,[Annual10]
      ,[Annual11]
      ,[Annual12]

	  ,[Annual01]+[Annual02]+[Annual03]+[Annual04]+[Annual05]+[Annual06]+[Annual07]+
	  [Annual08]+[Annual09]+[Annual10]+[Annual11]+[Annual12] as Total_Annual

	  ,[DiscountAnnual01]
      ,[DiscountAnnual02]
      ,[DiscountAnnual03]
      ,[DiscountAnnual04]
      ,[DiscountAnnual05]
      ,[DiscountAnnual06]
      ,[DiscountAnnual07]
      ,[DiscountAnnual08]
      ,[DiscountAnnual09]
      ,[DiscountAnnual10]
      ,[DiscountAnnual11]
      ,[DiscountAnnual12]

	  ,[DiscountAnnual01]+[DiscountAnnual02]+[DiscountAnnual03]+[DiscountAnnual04]+
	  [DiscountAnnual05]+[DiscountAnnual06]+[DiscountAnnual07]+[DiscountAnnual08]+
	  [DiscountAnnual09]+[DiscountAnnual10]+[DiscountAnnual11]+[DiscountAnnual12] as Total_DiscountAnnual

      ,[ConsumeAnnual01]
      ,[ConsumeAnnual02]
      ,[ConsumeAnnual03]
      ,[ConsumeAnnual04]
      ,[ConsumeAnnual05]
      ,[ConsumeAnnual06]
      ,[ConsumeAnnual07]
      ,[ConsumeAnnual08]
      ,[ConsumeAnnual09]
      ,[ConsumeAnnual10]
      ,[ConsumeAnnual11]
      ,[ConsumeAnnual12]

	  ,[ConsumeAnnual01]+[ConsumeAnnual02]+[ConsumeAnnual03]+[ConsumeAnnual04]+
	  [ConsumeAnnual05]+[ConsumeAnnual06]+[ConsumeAnnual07]+[ConsumeAnnual08]+
	  [ConsumeAnnual09]+[ConsumeAnnual10]+[ConsumeAnnual11]+[ConsumeAnnual12] as Total_ConsumeAnnual

      ,[Mytotal]
      ,[Dayoff01]
      ,[Dayoff02]
      ,[Dayoff03]
      ,[Dayoff04]
      ,[Dayoff05]
      ,[Dayoff06]
      ,[Dayoff07]
      ,[Dayoff08]
      ,[Dayoff09]
      ,[Dayoff10]
      ,[Dayoff11]
      ,[Dayoff12]

	  ,[Dayoff01]+[Dayoff02]+[Dayoff03]+[Dayoff04]+[Dayoff05]+[Dayoff06]+[Dayoff07]+
	  [Dayoff08]+[Dayoff09]+[Dayoff10]+[Dayoff11]+[Dayoff12] as Total_Dayoff

      ,[DiscountDayoff01]
      ,[DiscountDayoff02]
      ,[DiscountDayoff03]
      ,[DiscountDayoff04]
      ,[DiscountDayoff05]
      ,[DiscountDayoff06]
      ,[DiscountDayoff07]
      ,[DiscountDayoff08]
      ,[DiscountDayoff09]
      ,[DiscountDayoff10]
      ,[DiscountDayoff11]
      ,[DiscountDayoff12]

	  ,[DiscountDayoff01]+[DiscountDayoff02]+[DiscountDayoff03]+[DiscountDayoff04]+[DiscountDayoff05]+[DiscountDayoff06]+[DiscountDayoff07]+
	  [DiscountDayoff08]+[DiscountDayoff09]+[DiscountDayoff10]+[DiscountDayoff11]+[DiscountDayoff12] as Total_DiscountDayoff

      ,[ConsumeDayoff01]
      ,[ConsumeDayoff02]
      ,[ConsumeDayoff03]
      ,[ConsumeDayoff04]
      ,[ConsumeDayoff05]
      ,[ConsumeDayoff06]
      ,[ConsumeDayoff07]
      ,[ConsumeDayoff08]
      ,[ConsumeDayoff09]
      ,[ConsumeDayoff10]
      ,[ConsumeDayoff11]
      ,[ConsumeDayoff12]

	  ,[ConsumeDayoff01]+[ConsumeDayoff02]+[ConsumeDayoff03]+[ConsumeDayoff04]+[ConsumeDayoff05]+[ConsumeDayoff06]+[ConsumeDayoff07]+
	  [ConsumeDayoff08]+[ConsumeDayoff09]+[ConsumeDayoff10]+[ConsumeDayoff11]+[ConsumeDayoff12] as Total_ConsumeDayoff

      ,[Holiday01]
      ,[Holiday02]
      ,[Holiday03]
      ,[Holiday04]
      ,[Holiday05]
      ,[Holiday06]
      ,[Holiday07]
      ,[Holiday08]
      ,[Holiday09]
      ,[Holiday10]
      ,[Holiday11]
      ,[Holiday12]

	   ,[Holiday01]+[Holiday02]+[Holiday03]+[Holiday04]+[Holiday05]+[Holiday06]+[Holiday07]+
	  [Holiday08]+[Holiday09]+[Holiday10]+[Holiday11]+[Holiday12] as Total_Holiday

	  ,[Fourth01]
      ,[Fourth02]
      ,[Fourth03]
      ,[Fourth04]
      ,[Fourth05]
      ,[Fourth06]
      ,[Fourth07]
      ,[Fourth08]
      ,[Fourth09]
      ,[Fourth10]
      ,[Fourth11]
      ,[Fourth12]

,[Fourth01]+[Fourth02]+[Fourth03]+[Fourth04]+[Fourth05]+[Fourth06]+[Fourth07]+
	  [Fourth08]+[Fourth09]+[Fourth10]+[Fourth11]+[Fourth12] as Total_Fourth


      ,[DiscountHoliday01]
      ,[DiscountHoliday02]
      ,[DiscountHoliday03]
      ,[DiscountHoliday04]
      ,[DiscountHoliday05]
      ,[DiscountHoliday06]
      ,[DiscountHoliday07]
      ,[DiscountHoliday08]
      ,[DiscountHoliday09]
      ,[DiscountHoliday10]
      ,[DiscountHoliday11]
      ,[DiscountHoliday12]

	 ,[DiscountHoliday01]+[DiscountHoliday02]+[DiscountHoliday03]+[DiscountHoliday04]+[DiscountHoliday05]+[DiscountHoliday06]+[DiscountHoliday07]+
	  [DiscountHoliday08]+[DiscountHoliday09]+[DiscountHoliday10]+[DiscountHoliday11]+[DiscountHoliday12] as Total_DiscountHoliday

	  ,[DiscountFourth01]
      ,[DiscountFourth02]
      ,[DiscountFourth03]
      ,[DiscountFourth04]
      ,[DiscountFourth05]
      ,[DiscountFourth06]
      ,[DiscountFourth07]
      ,[DiscountFourth08]
      ,[DiscountFourth09]
      ,[DiscountFourth10]
      ,[DiscountFourth11]
      ,[DiscountFourth12]

 ,[DiscountFourth01]+[DiscountFourth02]+[DiscountFourth03]+[DiscountFourth04]+[DiscountFourth05]+[DiscountFourth06]+[DiscountFourth07]+
	  [DiscountFourth08]+[DiscountFourth09]+[DiscountFourth10]+[DiscountFourth11]+[DiscountFourth12] as Total_DiscountFourth

      ,[ConsumeHoliday01]
      ,[ConsumeHoliday02]
      ,[ConsumeHoliday03]
      ,[ConsumeHoliday04]
      ,[ConsumeHoliday05]
      ,[ConsumeHoliday06]
      ,[ConsumeHoliday07]
      ,[ConsumeHoliday08]
      ,[ConsumeHoliday09]
      ,[ConsumeHoliday10]
      ,[ConsumeHoliday11]
      ,[ConsumeHoliday12]

	   ,[ConsumeHoliday01]+[ConsumeHoliday02]+[ConsumeHoliday03]+[ConsumeHoliday04]+[ConsumeHoliday05]+[ConsumeHoliday06]+[ConsumeHoliday07]+
	  [ConsumeHoliday08]+[ConsumeHoliday09]+[ConsumeHoliday10]+[ConsumeHoliday11]+[ConsumeHoliday12] as Total_ConsumeHoliday

	   ,[ConsumeFourth01]
      ,[ConsumeFourth02]
      ,[ConsumeFourth03]
      ,[ConsumeFourth04]
      ,[ConsumeFourth05]
      ,[ConsumeFourth06]
      ,[ConsumeFourth07]
      ,[ConsumeFourth08]
      ,[ConsumeFourth09]
      ,[ConsumeFourth10]
      ,[ConsumeFourth11]
      ,[ConsumeFourth12]


	   ,[ConsumeFourth01]+[ConsumeFourth02]+[ConsumeFourth03]+[ConsumeFourth04]+[ConsumeFourth05]+[ConsumeFourth06]+[ConsumeFourth07]+
	  [ConsumeFourth08]+[ConsumeFourth09]+[ConsumeFourth10]+[ConsumeFourth11]+[ConsumeFourth12] as Total_ConsumeFourth

	  --//Due Total 
	  ,[Annual01]+[Dayoff01]+[Holiday01]+[Fourth01] as Due_Total_1
	  ,[Annual02]+[Dayoff02]+[Holiday02]+[Fourth02] as Due_Total_2
	  ,[Annual03]+[Dayoff03]+[Holiday03]+[Fourth03] as Due_Total_3
	  ,[Annual04]+[Dayoff04]+[Holiday04]+[Fourth04] as Due_Total_4
	  ,[Annual05]+[Dayoff05]+[Holiday05]+[Fourth05] as Due_Total_5
	  ,[Annual06]+[Dayoff06]+[Holiday06]+[Fourth06]  as Due_Total_6
	  ,[Annual07]+[Dayoff07]+[Holiday07]+[Fourth07]  as Due_Total_7
	  ,[Annual08]+[Dayoff08]+[Holiday08]+[Fourth08] as Due_Total_8
	  ,[Annual09]+[Dayoff09]+[Holiday09]+[Fourth09] as Due_Total_9
	  ,[Annual10]+[Dayoff10]+[Holiday10]+[Fourth10] as Due_Total_10
	  ,[Annual11]+[Dayoff11]+[Holiday11]+[Fourth11]  as Due_Total_11
	  ,[Annual12]+[Dayoff12]+[Holiday12]+[Fourth12] as Due_Total_12

	  --//Consume Total 
	  ,[ConsumeAnnual01]+[ConsumeDayoff01]+[ConsumeHoliday01]+[ConsumeFourth01] as Consume_Total_1
	  ,[ConsumeAnnual02]+[ConsumeDayoff02]+[ConsumeHoliday02]+[ConsumeFourth02] as Consume_Total_2
	  ,[ConsumeAnnual03]+[ConsumeDayoff03]+[ConsumeHoliday03]+[ConsumeFourth03] as Consume_Total_3
	  ,[ConsumeAnnual04]+[ConsumeDayoff04]+[ConsumeHoliday04]+[ConsumeFourth04]  as Consume_Total_4
	  ,[ConsumeAnnual05]+[ConsumeDayoff05]+[ConsumeHoliday05]+[ConsumeFourth05]  as Consume_Total_5
	  ,[ConsumeAnnual06]+[ConsumeDayoff06]+[ConsumeHoliday06]+[ConsumeFourth06] as Consume_Total_6
	  ,[ConsumeAnnual07]+[ConsumeDayoff07]+[ConsumeHoliday07]+[ConsumeFourth07]  as Consume_Total_7
	  ,[ConsumeAnnual08]+[ConsumeDayoff08]+[ConsumeHoliday08]+[ConsumeFourth08] as Consume_Total_8
	  ,[ConsumeAnnual09]+[ConsumeDayoff09]+[ConsumeHoliday09]+[ConsumeFourth09] as Consume_Total_9
	  ,[ConsumeAnnual10]+[ConsumeDayoff10]+[ConsumeHoliday10]+[ConsumeFourth10] as Consume_Total_10
	  ,[ConsumeAnnual11]+[ConsumeDayoff11]+[ConsumeHoliday11]+[ConsumeFourth11] as Consume_Total_11
	  ,[ConsumeAnnual12]+[ConsumeDayoff12]+[ConsumeHoliday12]+[ConsumeFourth12] as Consume_Total_12


	   --//Discount Total 
	  ,[DiscountAnnual01]+[DiscountDayoff01]+[DiscountHoliday01]+[DiscountFourth01] as Discount_Total_1
	  ,[DiscountAnnual02]+[DiscountDayoff02]+[DiscountHoliday02] +[DiscountFourth02] as Discount_Total_2
	  ,[DiscountAnnual03]+[DiscountDayoff03]+[DiscountHoliday03]+[DiscountFourth03] as Discount_Total_3
	  ,[DiscountAnnual04]+[DiscountDayoff04]+[DiscountHoliday04]+[DiscountFourth04] as Discount_Total_4
	  ,[DiscountAnnual05]+[DiscountDayoff05]+[DiscountHoliday05]+[DiscountFourth05] as Discount_Total_5
	  ,[DiscountAnnual06]+[DiscountDayoff06]+[DiscountHoliday06]+[DiscountFourth06] as Discount_Total_6
	  ,[DiscountAnnual07]+[DiscountDayoff07]+[DiscountHoliday07]+[DiscountFourth07] as Discount_Total_7
	  ,[DiscountAnnual08]+[DiscountDayoff08]+[DiscountHoliday08]+[DiscountFourth08] as Discount_Total_8
	  ,[DiscountAnnual09]+[DiscountDayoff09]+[DiscountHoliday09]+[DiscountFourth09] as Discount_Total_9
	  ,[DiscountAnnual10]+[DiscountDayoff10]+[DiscountHoliday10]+[DiscountFourth10] as Discount_Total_10
	  ,[DiscountAnnual11]+[DiscountDayoff11]+[DiscountHoliday11]+[DiscountFourth11] as Discount_Total_11
	  ,[DiscountAnnual12]+[DiscountDayoff12]+[DiscountHoliday12]+[DiscountFourth12] as Discount_Total_12

	  ,[EndAnnualBalance]
      ,[EndDayoffBalance]
      ,[EndHolidayBalance]
      ,[EndTotalBalance]
      ,[AnnualBalance]
      ,[DayoffBalance]
      ,[HolidayBalance]

      ,[AnnualBalance01]
      ,[AnnualBalance02]
      ,[AnnualBalance03]
      ,[AnnualBalance04]
      ,[AnnualBalance05]
      ,[AnnualBalance06]
      ,[AnnualBalance07]
      ,[AnnualBalance08]
      ,[AnnualBalance09]
      ,[AnnualBalance10]
      ,[AnnualBalance11]
      ,[AnnualBalance12]

      ,[DayoffBalance01]
      ,[DayoffBalance02]
      ,[DayoffBalance03]
      ,[DayoffBalance04]
      ,[DayoffBalance05]
      ,[DayoffBalance06]
      ,[DayoffBalance07]
      ,[DayoffBalance08]
      ,[DayoffBalance09]
      ,[DayoffBalance10]
      ,[DayoffBalance11]
      ,[DayoffBalance12]

      ,[HolidayBalance01]
      ,[HolidayBalance02]
      ,[HolidayBalance03]
      ,[HolidayBalance04]
      ,[HolidayBalance05]
      ,[HolidayBalance06]
      ,[HolidayBalance07]
      ,[HolidayBalance08]
      ,[HolidayBalance09]
      ,[HolidayBalance10]
      ,[HolidayBalance11]
      ,[HolidayBalance12]

	  ,[FourthBalance01]
      ,[FourthBalance02]
      ,[FourthBalance03]
      ,[FourthBalance04]
      ,[FourthBalance05]
      ,[FourthBalance06]
      ,[FourthBalance07]
      ,[FourthBalance08]
      ,[FourthBalance09]
      ,[FourthBalance10]
      ,[FourthBalance11]
      ,[FourthBalance12]

      ,[PYB2]
      ,[PYB3]
      ,[PYB4]


	  ,[AnnualBalance01]+[DayoffBalance01]+[HolidayBalance01]+[FourthBalance01] as Total_Balance_1
	  ,[AnnualBalance02]+[DayoffBalance01]+[HolidayBalance02]+[FourthBalance02] as Total_Balance_2
	  ,[AnnualBalance03]+[DayoffBalance03]+[HolidayBalance03]+[FourthBalance03] as Total_Balance_3
	  ,[AnnualBalance04]+[DayoffBalance04]+[HolidayBalance04]+[FourthBalance04] as Total_Balance_4
	  ,[AnnualBalance05]+[DayoffBalance05]+[HolidayBalance05]+[FourthBalance05]as Total_Balance_5
	  ,[AnnualBalance06]+[DayoffBalance06]+[HolidayBalance06]+[FourthBalance06] as Total_Balance_6
	  ,[AnnualBalance07]+[DayoffBalance07]+[HolidayBalance07]+[FourthBalance07] as Total_Balance_7
	  ,[AnnualBalance08]+[DayoffBalance08]+[HolidayBalance08]+[FourthBalance08] as Total_Balance_8
	  ,[AnnualBalance09]+[DayoffBalance09]+[HolidayBalance09]+[FourthBalance09] as Total_Balance_9
	  ,[AnnualBalance10]+[DayoffBalance10]+[HolidayBalance10]+[FourthBalance10] as Total_Balance_10
	  ,[AnnualBalance11]+[DayoffBalance11]+[HolidayBalance11]+[FourthBalance11] as Total_Balance_11
	  ,[AnnualBalance12]+[DayoffBalance12]+[HolidayBalance12]+[FourthBalance12] as Total_Balance_12

           

	  FROM [dbo].[VacationDue]
where [dbo].[VacationDue].[EmployeeCode] = @EmpCode and [dbo].[VacationDue].[PYear] =@PYear
GO

-------------------------------End 2022-03-17---
-------------------------------Hammad 2022-03-17---
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (87, N'Compensation Balance', N'الرصيد التعويضي', N'VacBalanceSource')
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (88, N'Annual Vacation + Compensation', N'أجازة سنوية + الرصيد التعويضي', N'VacBalanceSource')
GO
-------------------------------End 2022-03-17---
-------------------------------AK 2022-03-17---
ALTER TABLE [SST.ERP_Client].[dbo].[Clients] ADD LoginBackgroundImage NVARCHAR(200) NULL
-------------------------------End 2022-03-17---
-------------------------------Hammad 2022-03-17---
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFNewEmployeeAttachement', N'Attachment mandatory  ', N'  المرفق إجبارى', N'false', 2, 3, 1, 1, NULL, NULL, 14)
GO
-------------------------------End 2022-03-17---
-------------------------------Mostafa 2022-03-17---
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNumberMonthsAppointment',N'Number Of Months From The Date of Appointment',N'عدد الشهور من تاريخ التعيين لتقديم طلب',N'0',2,3,2,1,Null,Null,50)
Go
-------------------------------End 2022-03-17---

