﻿GO
UPDATE SecurityPrivilege SET DescriptionAR=N'انشاء قيود اليومية للسندات', DescriptionEN=N'Creae journal entries for vouchers' WHERE ID=23066
Go
UPDATE SecurityPrivilege SET DescriptionAR=N'عرض انشاء قيود اليومية للسندات', DescriptionEN=N'View creae journal entries for vouchers' WHERE ID=23067
Go
UPDATE SecurityPrivilege SET DescriptionAR=N'حفظ انشاء قيود اليومية للسندات', DescriptionEN=N'Save creae journal entries for vouchers' WHERE ID=23068
Go
UPDATE SecurityPrivilege SET DescriptionAR=N'الغاء قيود اليومية للسندات', DescriptionEN=N'Cancel journal entries for vouchers' WHERE ID=23071
GO
UPDATE SecurityPrivilege SET DescriptionAR=N'عرض الغاء قيود اليومية للسندات', DescriptionEN=N'View cancel journal entries for vouchers' WHERE ID=23072
GO
UPDATE SecurityPrivilege SET DescriptionAR=N'حفظ الغاء قيود اليومية للسندات', DescriptionEN=N'Save cancel journal entries for vouchers' WHERE ID=23073
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1139,N'Posting journal entries',N'ترحيل قيود اليومية',1125,N'/GenerlLedger/JournalHeaderPosting',N'Index',N'fa fa-thumb-tack',N'get',4,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1139,18)
Go
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23192,N'ترحيل قيود اليومية',N'Posting journal entries',1139,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23193,N'عرض ترحيل قيود اليومية',N'View Posting journal Entries',1139,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23194,N'ترحيل كل القيود',N'Posting All Entries',1139,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23195,N'الغاء ترحيل كل القيود',N'Cancel Posting All Entries',1139,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23196,N'ترحيل',N'Posting',1139,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23197,N'الغاء ترحيل',N'Cancel Posting',1139,2)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2224,N'GenerlLedger',N'JournalHeaderPosting',N'Index',0,N'get',23192)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2225,N'GenerlLedger',N'JournalHeaderPosting',N'JournalHeaderPosting_Read',0,N'post',23193)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2226,N'GenerlLedger',N'JournalHeaderPosting',N'PostAll',0,N'post',23194)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2227,N'GenerlLedger',N'JournalHeaderPosting',N'CancelAll',0,N'post',23195)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2228,N'GenerlLedger',N'JournalHeaderPosting',N'PostSelected',0,N'post',23196)
GO
INSERT INTO [SecurityPrivilegeActions](ID,AreaName,ControllerName,ActionName,ActionType,HTTPMethod,SecurityPrivilegeID) VALUES (2229,N'GenerlLedger',N'JournalHeaderPosting',N'CancelSelected',0,N'post',23197)
GO
----------------------------------------- Hammad 2025-01-06 -----------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WF_AddSalaryAdvanceRequest', N'Add Salary Advance Request', N'إضافة طلب تصفية راتب', N'true', 2, 21, 1, 1, NULL, NULL, 0, N' إضافة طلب تصفية راتب')
GO
----------------------------------------- Hammad 2025-01-06 -----------------
----------------------------------------- Ali 2025-01-06 -----------------

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])
VALUES (68,N'طلب تصفية راتب ',N'Salary Advance Request', 0, N'sst.sentmail@gmail.com', N'sst.sentmail@gmail.com', N'mwtjgyjxrrgczlfr', N'smtp.gmail.com', 587, N'SST System', NULL, NULL, 1, 1, 0, 0, 0, 1, 2, 1, 0, 1, 0, 1, 1, N'index', N'SalaryAdvanceRequestSignature', N'WorkFlow', 1, 1, 0, 0)
GO

SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(492,N'Salary Advance Request Sending',N'ارسال طلب تصفية راتب',0,1,68, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(493,N'Salary Advance Request Accept',N'الموافقة على طلب تصفية راتب',0,1,68, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(494,N'Salary Advance Request Refuse',N'رفض طلب تصفية راتب',0,1,68, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(495,N'Salary Advance Request Inverse',N'ارجاع طلب تصفية راتب',0,1,68, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4409,N'Salary Advance Request Sending',N'ارسال طلب تصفية راتب',492,N'ارسال',N'ارسال',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4410,N'Salary Advance Request Accept',N'الموافقة على طلب تصفية راتب',493,N'الموافقة على',N'الموافقة على',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4411,N'Salary Advance Request Refuse',N'رفض طلب تصفية راتب',494,N'رفض',N'رفض',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4412,N'Salary Advance Request Inverse',N'ارجاع طلب تصفية راتب',495,N'ارجاع',N'ارجاع',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1140,N'Salary Advance Request Signature',N'اعتماد طلب تصفية راتب',497,N'/WorkFlow/SalaryAdvanceRequestSignature',N'Index','fa fa-thumb-tack',N'get',9,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1140,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15523,N'اعتماد طلب تصفية راتب',N'Salary Advance Request Signature',1140,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15524,N'عرض اعتماد طلب تصفية راتب',N'View Salary Advance Request Signature',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15525,N'تعديل اعتماد طلب تصفية راتب',N'Edit Salary Advance Request Signature',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15526,N'حفظ اعتماد طلب تصفية راتب',N'Save Salary Advance Request Signature',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15527,N'حفظ متعدد للاعتماد',N'Multiple Save',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15528,N'عرض سجل الموظف',N'View Employee History',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15529,N'ارجاع الطلب',N'Inverse Request',1140,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15530,N'اختيار كل الطلبات',N'Choose All Requests',1140,2)
Go

--------------------------End 2025-01-06-----------------------------

----------------------------------------- MN 2025-01-06 -----------------

CREATE TABLE OrientationsFilesSubtitle (
    FileTranslationCode INT PRIMARY KEY IDENTITY(1,1), 
    OrientationFileCode INT NOT NULL,                             
    FileName NVARCHAR(MAX) NOT NULL,                   
    LanguageId INT NOT NULL,                           
    FOREIGN KEY (OrientationFileCode) REFERENCES OrientationFiles(OrientationFileCode) 
);

--------------------------End 2025-01-06-----------------------------
