 
 ---------------------------Ali 2020-12-23------------------------------
 ALTER TABLE [dbo].[WF_LoanTypeDetials] 
  ADD  DisplayMonthToStartLoanDeduct bit not null
  DEFAULT ((0))


  delete from [ConfigParameter]
  where  [ConfigKey]='WFDisplayMonthToStartLoanDeduct'
 ---------------------------End 2020-12-23--------------------------------
 ---------------------------Hammad 2020-12-23--------------------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'IntegrateWFWithRecruitment', N'Integrate WF With Recruitment', N'تكامل سير العمل مع التوظيف', N'false', 1, 13, 1, 1, NULL, NULL, NULL)
 GO

 ALTER TABLE dbo.WF_NewHireRequest ADD
	ForeignerUserCode int NULL
GO
  ---------------------------End 2020-12-23-----------------------------

  --------------------------Mahmoud Elsayed 2020-12-23 ---------------------------
  WF_TypeResidencyFeesARHeaders
 
SELECT '29' AS [RequestTypeCode],  [1], [2], [3], [4]  ,[5]  
FROM  (SELECT [TypeResidencyFeeCode], [Arabic_Name]   
    FROM [dbo].[WF_TypeResidencyFees]) AS SourceTable  
PIVOT  
(  
max ( [Arabic_Name])  
FOR [TypeResidencyFeeCode] IN ( [1], [2], [3], [4]  ,[5] )  
) AS PivotTable;
GO
WF_TypeResidencyFeesEnHeaders
 
SELECT        '29' AS [RequestTypeCode], [1], [2], [3], [4], [5]
FROM            (SELECT        [TypeResidencyFeeCode], [Name]
                           FROM            [dbo].[WF_TypeResidencyFees]) AS SourceTable PIVOT (max([Name])
						   FOR [TypeResidencyFeeCode] IN ([1], [2], [3], [4], [5])) AS PivotTable;

-------------------------End 2020-12-23-------------------------------------------
--------------------------Khaled 2020-12-23-------------------------------------
CREATE procedure [dbo].[Inv_ItemBalance]
as
SELECT       1 as id, Inv.StoreTransactionMaster.StoreTransactionMasterCode, Inv.StoreTransactionMaster.TransactionDate, Inv.StoreTransactionMaster.TransactionTypeCode, Inv.TransactionType.Name, Inv.TransactionType.Arabic_Name, 
                         Inv.StoreTransactionMaster.DescriptionEn, Inv.StoreTransactionMaster.DescriptionAr, Inv.StoreTransactionMaster.SupplierCode, Inv.Supplier.Name AS SupplierName, Inv.Supplier.Arabic_Name AS SupplierAraName, 
                         Inv.StoreTransactionMaster.TransactionStoreCode, Inv.Store.Name AS StoreName, Inv.Store.Arabic_Name AS StoreAraName, Inv.StoreTransactionDetail.ItemCode,inv.ItemCard.ItemCardSerial, Inv.ItemCard.Name AS ItemName, 
                         Inv.ItemCard.Arabic_Name AS ItemAraName, Inv.ItemCard.DescriptionEn AS ItemDesc, Inv.ItemCard.DescriptionAr AS ItemAraDesc, Inv.StoreTransactionDetail.UnitCode, dbo.INV_ItemUnits.Name AS UnitName, 
                         dbo.INV_ItemUnits.Arabic_Name AS UnitAraName, Inv.StoreTransactionDetail.Quantity * Inv.StoreTransactionDetail.Indicator AS Qty, Inv.StoreTransactionDetail.UnitPrice, Inv.StoreTransactionDetail.ExpireDate, 
                         Inv.StoreTransactionDetail.NoteEn, Inv.StoreTransactionDetail.NoteAr
FROM            Inv.StoreTransactionMaster INNER JOIN
                         Inv.StoreTransactionDetail ON Inv.StoreTransactionMaster.StoreTransactionMasterCode = Inv.StoreTransactionDetail.StoreTransactionMasterCode INNER JOIN
                         Inv.Store ON Inv.StoreTransactionDetail.StoreCode = Inv.Store.StoreCode INNER JOIN
                         Inv.TransactionType ON Inv.StoreTransactionMaster.TransactionTypeCode = Inv.TransactionType.TransactionTypeCode INNER JOIN
                         dbo.INV_ItemUnits ON Inv.StoreTransactionDetail.UnitCode = dbo.INV_ItemUnits.UnitCode INNER JOIN
                         Inv.ItemCard ON Inv.StoreTransactionDetail.ItemCode = Inv.ItemCard.ItemCardSerial LEFT OUTER JOIN
                         Inv.Supplier ON Inv.StoreTransactionMaster.SupplierCode = Inv.Supplier.SupplierCode
GO
-------------------------------End 2020-12-23-------------------------------
-------------------------------Sayed 2020-12-23--------------------------
  update [dbo].[SystemMenu] set [Name]='Stages  Apply For Job' where [SystemMenuCode]=74
  update [dbo].[SystemMenu] set [Name]='Enter Stages Apply Result' where [SystemMenuCode]=76
  GO
  -----------------------------End 2020-12-23----------------------------