﻿------------------------------------- Ali 2024-02-15 ------------------------------

CREATE TABLE [dbo].[ReportsGroups](
	[ReportGroupCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_ReportsGroups] PRIMARY KEY CLUSTERED 
(
	[ReportGroupCode] 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


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1044,N'Reports Group',N'مجموعة التقارير',208,N'/ReportsGroup',N'Index','fa fa-thumb-tack',N'get',13,1,0)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1044,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1401,N'مجموعة التقارير',N'Reports Group',1044,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1402,N'عرض مجموعة التقارير',N'View Reports Group',1044,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1403,N'إضافة مجموعة التقارير',N'Add Reports Group',1044,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1404,N'تعديل مجموعة التقارير',N'Edit Reports Group',1044,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1405,N'حذف مجموعة التقارير',N'Delete Reports Group',1044,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1406,N'حفظ مجموعة التقارير',N'Save Reports Group',1044,2)
Go
------------------------------------- End 2024-02-15 ------------------------------
------------------------------------- Hammad 2024-02-18 ------------------------------
ALTER TABLE dbo.Reports ADD
	DescriptionEn nvarchar(500) NULL
GO
------------------------------------- End 2024-02-18 ------------------------------

---------------------------------------MNegm 2024-02-20 ---------------------------

   
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1488,N'WorkFlow',N'PromotionRequestApi',N'Index',0,N'get',3133)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1489,N'WorkFlow',N'PromotionRequestApi',N'PromotionRequest_Read',0,N'post',3134)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1490,N'WorkFlow',N'PromotionRequestApi',N'Save',1,N'get',3135)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1491,N'WorkFlow',N'PromotionRequestApi',N'Save',2,N'get',3136)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1492,N'WorkFlow',N'PromotionRequestApi',N'Delete',0,N'post',3138)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1493,N'WorkFlow',N'PromotionRequestApi',N'Save',0,N'post',3137)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1494,N'WorkFlow',N'PromotionRequestApi',N'Cancel',0,N'post',3139)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1495,N'WorkFlow',N'PromotionRequestSignatureApi',N'Index',0,N'get',3140)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1496,N'WorkFlow',N'PromotionRequestSignatureApi',N'PromotionRequest_Read',0,N'post',3141)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1497,N'WorkFlow',N'PromotionRequestSignatureApi',N'Save',2,N'get',3142)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1498,N'WorkFlow',N'PromotionRequestSignatureApi',N'Save',0,N'post',3143)
GO

---------------------------------------End 2024-02-20 ------------------------------
---------------------------------------Ali 2024-02-21 ------------------------------

CREATE TABLE [dbo].[FingerAreaLogs](
	[FingerAreaLogId] [int] IDENTITY(1,1) NOT NULL,
	[FingerAreaProjectsCode] [int] NOT NULL,
	[FingerAreaUnitCode] [int] NOT NULL,
	[LoginId] [int] NOT NULL,
	[LogoutId] [int] NULL,
 CONSTRAINT [PK_FingerAreaLogs] PRIMARY KEY CLUSTERED 
(
	[FingerAreaLogId] 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
CREATE TABLE [dbo].[FingerAreaLogTasks](
	[FingerAreaLogTaskCode] [int] IDENTITY(1,1) NOT NULL,
	[FingerAreaLogId] [int] NOT NULL,
	[PositionTasksCode] [int] NULL,
 CONSTRAINT [PK_FingerAreaLogTasks] PRIMARY KEY CLUSTERED 
(
	[FingerAreaLogTaskCode] 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
---------------------------------------End 2024-02-21 ------------------------------
---------------------------------------Mostafa 2024-02-21 ------------------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (15465, N'تحميل طلب وقت إضافى', N'Upload OverTime Request', 64, 2)
GO
---------------------------------------End 2024-02-21 ------------------------------