﻿----------------------------------------- AK 2025-12-18 --------------------
UPDATE SystemMenu SET name=N'Settlements', Arabic_Name=N'تسويات' WHERE SystemMenuCode=1129
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1224,N'Invoice Collection',N'تحصيل الفواتير',1129,N'/GenerlLedger/InvoiceCollection',N'Index',N'fa fa-thumb-tack',N'get',2,1,1)
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1225,N'Invoice Payment',N'سداد الفواتير',1129,N'/GenerlLedger/InvoicePayment',N'Index',N'fa fa-thumb-tack',N'get',3,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1224,18)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1225,18)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23216,N'تحصيل الفواتير',N'Invoice Collection',1224,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23217,N'عرض تحصيل الفواتير',N'View Invoice Collection',1224,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23218,N'إضافة تحصيل الفواتير',N'Add Invoice Collection',1224,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23219,N'تعديل تحصيل الفواتير',N'Edit Invoice Collection',1224,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23220,N'حذف تحصيل الفواتير',N'Delete Invoice Collection',1224,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23221,N'حفظ تحصيل الفواتير',N'Save Invoice Collection',1224,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23222,N'سداد الفواتير',N'Invoice Payment',1225,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23223,N'عرض سداد الفواتير',N'View Invoice Payment',1225,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23224,N'إضافة سداد الفواتير',N'Add Invoice Payment',1225,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23225,N'تعديل سداد الفواتير',N'Edit Invoice Payment',1225,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23226,N'حذف سداد الفواتير',N'Delete Invoice Payment',1225,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23227,N'حفظ سداد الفواتير',N'Save Invoice Payment',1225,2)
GO
-----------------------------------------END AK 2025-12-18 --------------------
----------------------------------------- SHEHAB 2025-12-22 --------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (1220, N'Rehire Employee Request', N'طلب اعادة تعيين موظف', 495, N'/WorkFlow/RehireEmployeeRequest', N'Index', N'fa-solid fa-rotate', N'get', 10, 1, 1)
GO
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (1220, 1)
GO

GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15589, N'طلب اعادة تعيين موظف', N'Rehire Employee Request', 1220, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15590, N'اضافة طلب اعادة تعيين موظف', N'Add Rehire Employee Request', 1220, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15591, N'تعديل  طلب اعادة تعيين موظف', N'Edit Rehire Employee Request', 1220, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15592, N'حذف طلب اعادة تعيين موظف', N'Delete Rehire Employee Request', 1220, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15593, N'عرض طلب اعادة تعيين موظف', N'Rehire Employee Request View', 1220, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15594, N'حفظ طلب اعادة تعيين موظف', N'Save Rehire Employee Request', 1220, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15595, N'الغاء طلب اعادة تعيين موظف', N'Cancel Rehire Employee Request', 1220, 2)
GO

INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment], [WorkedByDefaultContract], [CategoryCode], [RequestTypeGroupCode], [SendEmailNotification], [AsyncWhatsAppMessage], [RequsetPrint], [SignatureRefusedComentMandatory], [IsApi], [IsMasterRequest], [NotifSignCountAction], [NotifSignCountController], [NotifSignCountArea], [IsEnableSSL], [WorkedByAssignmentContract], [IsMobile], [SignatureApprovedCommentMandatory], [EmployeeFilter], [IsAffectOnHR], [IsRequestClosed], [IsSignatureClosed], [MonthlyCloseActionBy], [MonthlyCloseActionDate], [MonthlyCloseDate], [SendNotifToEmployee], [Hint], [HintEn]) 
VALUES (69, N'طلب اعادة تعيين موظف', N'Rehire Employee Request', 0, N'sstdev65@gmail.com', N'sstdev65@gmail.com', N'klirudtwcelnpxdn', N'smtp.gmail.com', 587, N'SST System', NULL, NULL, 1, 1, 0, 0, 0, 1, 2, 1, 1, 1, 0, 1, 1, N'index', N'RehireEmployeeRequestSignature', N'WorkFlow', 1, 1, 0, 0, NULL, 0, 0, 0, NULL, NULL, NULL, 1, NULL, NULL)
GO


SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(508,N'Rehire Employee Request Sending',N'ارسال طلب اعادة تعيين موظف ',0,1,69, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(509,N'Rehire Employee Request Accept',N'الموافقة على طلب اعادة تعيين موظف ',0,1,69, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(510,N'Rehire Employee Request Refuse',N'رفض طلب اعادة تعيين موظف ',0,1,69, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(511,N'Rehire Employee Request Inverse',N'ارجاع طلب اعادة تعيين موظف ',0,1,69, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(512,N'Send Refuse Notification After End of Track',N'إشعار بالرفض بعد نهاية المسار',0,1,69, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(513,N'Send Approval Notification After Track',N'إرسال إشعار بالموافقة بعد نهاية المسار',0,1,69, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT[dbo].[EmailTemplate]( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(N'Rehire Employee Request Sending',N'ارسال طلب اعادة تعيين موظف',508,N'ارسال',N'ارسال',1,NULL)
INSERT INTO [dbo].[EmailTemplate]([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) 
VALUES (N'Rehire Employee Request Accept', N'الموافقة على طلب اعادة تعيين موظف', 509, N'الموافقة على', N'الموافقة على', 1, NULL)
INSERT[dbo].[EmailTemplate]( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Rehire Employee Request Refuse',N'رفض طلب اعادة تعيين موظف',510,N'رفض',N'رفض',1,NULL)
INSERT[dbo].[EmailTemplate]( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Rehire Employee Request Inverse',N'ارجاع طلب اعادة تعيين موظف',511,N'ارجاع',N'ارجاع',1,NULL)
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (1223, N'Rehire Employee Request Signature', N'اعتماد طلب اعادة تعيين موظف ', 500, N'/WorkFlow/RehireEmployeeRequestSignature', N'Index', N'fas fa-file-signature', N'get', 10, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (1223, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15596, N'اعتماد طلب اعادة تعيين موظف', N'Rehire Employee Request Signature', 1223, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15597, N'عرض اعتماد طلب اعادة تعيين موظف', N'View Rehire Employee Request Signature', 1223, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15598, N'تعديل اعتماد طلب اعادة تعيين موظف', N'Edit Rehire Employee Request Signature', 1223, 2)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15599, N'حفظ اعتماد طلب  عادة تعيين موظف', N'Save Rehire Employee Request Signature', 1223, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15600, N'حفظ اعتمادات طلبات اعادة تعيين موظف', N'Save Rehire Employee Requests Signatures', 1223, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15601, N'سجل طلبات اعادة التعيين للموظف', N'Rehire Employee Request Employee History', 1223, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15602, N'اختيار كل الطلبات', N'Choose All Requests', 1223, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15603, N'إرجاع طلب اعادة تعيين موظف', N'Inverse Rehire Employee Request Signature', 1223, 2)
GO

INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2022, 10, 15597,69)
GO
INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2023, 13, 15599,69)
GO
INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2024, 8, 15598,69)
GO
INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2025, 9, 15597,69)
GO
INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2026, 11, 15599,69)
GO
INSERT [dbo].SecurityPrivilegeEndPointsDetails ([ID], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (2027, 12, 15595,69)
GO

-----------------------------------------END SHEHAB 2025-12-22 -------