﻿---------------------------Ali 2022-07-28---------------------
 update SystemMenu set Arabic_Name=N'إعداد القياس' where SystemMenuCode=637
  Go
  update SystemMenu set Arabic_Name=N'تخصيص إعداد القياس' where SystemMenuCode=643
  Go
---------------------------End 2022-07-28---------------------
---------------------------Hammad 2022-07-31------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFOvertimeFinalFromTimeAttandanceOnly', N'Overtime Final FromTime Attandance Only', N' الإعتماد على الوقت الإضافى الفعلى فقط فى الإعتماد النهائى', N'false', 2, 19, 1, 1, NULL, NULL, 3)
GO
---------------------------End 2022-07-31------------------
---------------------------Hammad 2022-07-31------------------

DECLARE @OverTimeRequestId int
DECLARE @StartPeriodTransaction int
SET @StartPeriodTransaction=(select ConfigValue from ConfigParameter where ConfigKey='WFStartPeriodTransaction')

DECLARE RequestCursor CURSOR FOR  
SELECT OverTimeRequestId  from WF_OverTimeRequest

OPEN RequestCursor  

FETCH NEXT FROM RequestCursor INTO @OverTimeRequestId 
WHILE @@FETCH_STATUS = 0  
BEGIN    
 declare @requestDay int =(select Day(RequestDate) from WF_OverTimeRequest where OverTimeRequestId=@OverTimeRequestId)
    declare @requestDate dateTime=(select RequestDate from WF_OverTimeRequest where OverTimeRequestId=@OverTimeRequestId)
 IF @requestDay < @StartPeriodTransaction
   BEGIN
   set  @requestDate = DATEADD(month,-1, @requestDate) 
   update WF_OverTimeRequest set Period=month(@requestDate) , PYear=year(@requestDate) where OverTimeRequestId=@OverTimeRequestId
   END
 ELSE
  BEGIN
   update WF_OverTimeRequest set Period=month(@requestDate) , PYear=year(@requestDate) where OverTimeRequestId=@OverTimeRequestId
  END
   
FETCH NEXT FROM RequestCursor INTO @OverTimeRequestId
END  
CLOSE RequestCursor   
DEALLOCATE RequestCursor 
go




DECLARE @CompensationRequestForADayOfRestId int
DECLARE @StartPeriodTransaction int
SET @StartPeriodTransaction=(select ConfigValue from ConfigParameter where ConfigKey='WFStartPeriodTransaction')

DECLARE Request_Cursor CURSOR FOR  
SELECT CompensationRequestForADayOfRestId  from WF_CompensationRequestForADayOfRest 

OPEN Request_Cursor  

FETCH NEXT FROM Request_Cursor INTO @CompensationRequestForADayOfRestId  
WHILE @@FETCH_STATUS = 0  
BEGIN    
 declare @requestDay int =(select Day(RequestDate) from WF_CompensationRequestForADayOfRest where CompensationRequestForADayOfRestId=@CompensationRequestForADayOfRestId)
    declare @requestDate dateTime=(select RequestDate from WF_CompensationRequestForADayOfRest where CompensationRequestForADayOfRestId=@CompensationRequestForADayOfRestId)
 IF @requestDay < @StartPeriodTransaction
   BEGIN
   set  @requestDate = DATEADD(month,-1, @requestDate) 
   update WF_CompensationRequestForADayOfRest set Period=month(@requestDate) , PYear=year(@requestDate) where CompensationRequestForADayOfRestId=@CompensationRequestForADayOfRestId
   END
 ELSE
  BEGIN
   update WF_CompensationRequestForADayOfRest set Period=month(@requestDate) , PYear=year(@requestDate) where CompensationRequestForADayOfRestId=@CompensationRequestForADayOfRestId
  END
   
FETCH NEXT FROM Request_Cursor INTO @CompensationRequestForADayOfRestId 
END  
CLOSE Request_Cursor   
DEALLOCATE Request_Cursor 
go

---------------------------End 2022-07-31------------------