﻿--------------------------------------Hammad 2019-10-23---------------------------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Reports](
	[ReportCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[ReportName] [nvarchar](150) NOT NULL,
	[AppModuleCode] [int] NOT NULL,
 CONSTRAINT [PK_Reports] PRIMARY KEY CLUSTERED 
(
	[ReportCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Reports] ON 

INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AppModuleCode]) VALUES (1, N'OverTime', N'الوقت الإضافى', N'WF_OverTimeReport.trdx', 1)
SET IDENTITY_INSERT [dbo].[Reports] OFF




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (233, N'Reports setting', N' اعداد التقارير  ', 208, N'ReportsSetting', N'Index', NULL, N'get', 6, 1, 0)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (234, N' Work Flow Reports ', N'تقارير سير العمل', 94, N'/WorkFlow/WorkFlowReports', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)
Go


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1177, N' اعداد التقارير  ', N'Reports setting', 233, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1178, N'إضافة اعداد التقارير', N'Add Reports setting', 233, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1179, N'تعديل اعداد التقارير', N'Edit Reports setting', 233, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1180, N'حذف اعداد التقارير', N'Delete Reports setting', 233, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1181, N'حفظ اعداد التقارير', N'Save Reports setting', 233, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1182, N'عرض اعداد التقارير', N'View Reports setting', 233, 2)


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3436, N'تقارير سير العمل', N' Work Flow Reports ', 234, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3437, N'عرض تقارير سير العمل', N'View  Work Flow Reports ', 234, 2)

Go

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 233, 6)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 234, 1)
Go

INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1177)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1178)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1179)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1180)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1181)
INSERT [dbo].[SecurityUserDetail] ( [SecurityUserID], [PrivilegeID]) VALUES ( 1, 1182)
Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WF_NonSaudiPositionInResidence', N'Non Saudi Position In Residence For Report', N'الغير سعودي  المهنة في الاقامة للتقرير       ', N'false', 2, 2, 1, 1, NULL, NULL, 7)
 Go
--------------------------------------End 2019-10-23---------------------------
--------------------------------------Sayed 2019-10-24---------------------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFShowProposedSalary',N'Show Proposed Salary',N'عرض الراتب المقترح',N'true',2,2,1,1,Null,Null,14)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (334, N'Location', N'الفروع', 52, N'/BasicData/Location', N'Index', N'fa fa-sitemap', N'get', 6, 1, 1)
GO
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1183, N'الفروع', N'Locations', 334, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1184, N'عرض الفروع', N'View Locations', 334, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1185, N'تعديل بيانات الفروع', N'View Location Data', 334, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1186, N'حفظ بيانات الفروع', N'Save Location Data', 334, 2)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON

INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4493, 334, 1)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO
alter table [dbo].[Location] 
add LocationLogo nvarchar(150)
Go
--------------------------------------End 2019-10-24---------------------------