IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-details' AND [ControlName] IS NULL)
BEGIN
INSERT INTO [KaaSCtlMaster](
[ComponentName],
[ControlName],
[FriendlyName],
[IsVisible],
[ParentId],
[Deleted])
VALUES (
'current-client-details',
null,
'Current Client Details',
0,
0,
0)
END
GO
--KCL Master
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'change-matter-security-permissions' AND [ControlName] IS NULL)
BEGIN
INSERT INTO [KaaSCtlMaster](
[ComponentName],
[ControlName],
[FriendlyName],
[IsVisible],
[ParentId],
[Deleted])
VALUES ('change-matter-security-permissions',
null,
'Change Matter Security Permissions',
0,
0,
0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-billing' AND [ControlName] IS NULL)
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName],
[ControlName],
[FriendlyName],
[IsVisible],
[ParentId],
[Deleted])
VALUES ('current-client-billing',
null,
'Current Client Billing',
0,
0,
0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'general-tab' AND [ControlName] = 'btnSaveGeneral')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('general-tab','btnSaveGeneral', 'Current Client Details - General', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'bank-details-tab' AND [ControlName] = 'btnSaveBankDetails')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('bank-details-tab','btnSaveBankDetails', 'Current Client Details - Bank Details', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'billing-details-tab' AND [ControlName] = 'btnSaveBillingDetails')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('billing-details-tab','btnSaveBillingDetails', 'Current Client Details - Billing Details', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnSaveCategories')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnSaveCategories', 'Current Client Details - Categories', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnSaveCorporate')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnSaveCorporate', 'Current Client Details - Corporate', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnSaveCrossRef')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnSaveCrossRef', 'Current Client Details - Cross Reference', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'legal-details-tab' AND [ControlName] = 'btnSaveLegalDetails')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('legal-details-tab','btnSaveLegalDetails', 'Current Client Details - Legal Details', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'matters-tab' AND [ControlName] = 'btnSaveMatters')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('matters-tab','btnSaveMatters', 'Current Client Details - Matters', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'notes-tab' AND [ControlName] = 'btnSaveNotes')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('notes-tab','btnSaveNotes', 'Current Client Details - Notes', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'permission-tab' AND [ControlName] = 'btnSavePermission')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('permission-tab','btnSavePermission', 'Current Client Details - Permission', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'personal-tab' AND [ControlName] = 'btnSavePersonal')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('personal-tab','btnSavePersonal', 'Current Client Details - Personal', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactInsert')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactInsert', 'Current Client Details - Client Contact', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactChange')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactChange', 'Current Client Details - Client Contact', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactDelete')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactDelete', 'Current Client Details - Client Contact', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefInsert')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefInsert', 'Current Client Details - Cross Reference', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefChange')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefChange', 'Current Client Details - Cross Reference', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefDelete')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefDelete', 'Current Client Details - Cross Reference', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesInsert')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesInsert', 'Current Client Details - Categories', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesChange')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesChange', 'Current Client Details - Categories', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesDelete')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesDelete', 'Current Client Details - Categories', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerInsert')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerInsert', 'Current Client Details - Corporate', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerChange')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerChange', 'Current Client Details - Corporate', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerDelete')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerDelete', 'Current Client Details - Corporate', 0, 1, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-detail-permission-tab' AND [ControlName] = 'mat-tab-label-0-10')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('current-client-detail-permission-tab','mat-tab-label-0-10', 'Current Client Details - Permission Tab', 0, 2, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-detail-billing-tab' AND [ControlName] = 'dvCurrentClientDetailsManageBilling')
BEGIN
INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('current-client-detail-billing-tab','dvCurrentClientDetailsManageBilling', 'Current Client Details - Billing Tab', 0, 3, 0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000033' AND [MasterId] = 1)
BEGIN
INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000033',1)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000012' AND [MasterId] = 2)
BEGIN
INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000012',2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000006' AND [MasterId] = 3)
BEGIN
INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000006',3)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'StatuteWarning')
BEGIN
INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('StatuteWarning',0)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'StatuteActionCode')
BEGIN
INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('StatuteActionCode','')
END
GO
--Sprint 6 Scritps
IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'ClientLabel')
BEGIN
INSERT INTO
[Settings]
(
[KeyName],
[KeyValue]
)
VALUES
(
'ClientLabel',
'Client'
)
END
GO
IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'MatterLabel')
BEGIN
INSERT INTO
[Settings]
(
[KeyName],
[KeyValue]
)
VALUES
(
'MatterLabel',
'Matter'
)
END
GO
IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'AssociateLabel')
BEGIN
INSERT INTO
[Settings]
(
[KeyName],
[KeyValue]
)
VALUES
(
'AssociateLabel',
'Associate'
)
END
GO
IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'CaseLabel')
BEGIN
INSERT INTO
[Settings]
(
[KeyName],
[KeyValue]
)
VALUES
(
'CaseLabel',
'Case'
)
END
GO
IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'DocumentNamingMethod')
BEGIN
INSERT INTO
[Settings]
(
[KeyName],
[KeyValue]
)
VALUES
(
'DocumentNamingMethod',
'D'
)
END
GO
-- INSERT SCRIPTS FOR APP REDIRECTION
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_DASHBOARD' AND [UrlLink] = '/tasks/task-dashboard')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Task Dashboard','/tasks/task-dashboard','TASK_DASHBOARD')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_MY' AND [UrlLink] = '/tasks/main/my-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('My Tasks','/tasks/main/my-tasks','TASK_MY')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_TEAM' AND [UrlLink] = '/tasks/main/team-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Team Tasks','/tasks/main/team-tasks','TASK_TEAM')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_OVERDUE' AND [UrlLink] = '/tasks/main/overdue-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Overdue Tasks','/tasks/main/overdue-tasks','TASK_OVERDUE')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_DAY' AND [UrlLink] = '/tasks/main/days-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Days Tasks','/tasks/main/days-tasks','TASK_DAY')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_NEXT_WEEK' AND [UrlLink] = '/tasks/main/next-weeks-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Next Week Tasks','/tasks/main/next-weeks-tasks','TASK_NEXT_WEEK')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_NEXT_MONTH' AND [UrlLink] = '/tasks/main/next-months-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Next Month Tasks','/tasks/main/next-months-tasks','TASK_NEXT_MONTH')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_OUTSTANDING' AND [UrlLink] = '/tasks/main/outstanding-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Outstanding Tasks','/tasks/main/outstanding-tasks','TASK_OUTSTANDING')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_LAST_WEEK' AND [UrlLink] = '/tasks/main/last-weeks-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Last Weeks Tasks','/tasks/main/last-weeks-tasks','TASK_LAST_WEEK')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_LAST_MONTH' AND [UrlLink] = '/tasks/main/last-months-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Last Month Tasks','/tasks/main/last-months-tasks','TASK_LAST_MONTH')
END
GO
IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_ALL' AND [UrlLink] = '/tasks/main/all-tasks')
BEGIN
INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('All Tasks','/tasks/main/all-tasks','TASK_ALL')
END
GO
-- DATAPUMP FOR CUSTOM FILTER HEADER OPTIONS
-- FIRST REMOVE EXISTING RECORDS
IF OBJECT_ID(N'CustomFilterColumndetails',N'U') IS NOT NULL
BEGIN
TRUNCATE TABLE CustomFilterColumndetails
END
GO
-- INSERT WITH NEW DATA
IF OBJECT_ID(N'CustomFilterColumndetails',N'U') IS NOT NULL
BEGIN
INSERT INTO CustomFilterColumndetails
-- Action Type Case Diary
SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Priority Case Diary
SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Flag Case Diary
SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION
SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Released MyInvoice
SELECT 'Yes' AS [name], 'Y' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Released' AS [ColumnName] , 'MyInvoice' AS [PageName] UNION
SELECT 'No' AS [name], 'N' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Released' AS [ColumnName] , 'MyInvoice' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Released MyInvoice
SELECT 'Equals 0' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'BillNo' AS [ColumnName] , 'MyInvoice' AS [PageName] UNION
SELECT 'Not equals 0' AS [name], '1' AS [Code],1 AS [isSelected],1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'BillNo' AS [ColumnName] , 'MyInvoice' AS [PageName]
INSERT INTO CustomFilterColumndetails
SELECT 'Request' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION
SELECT 'Released' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION
SELECT 'Approved' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION
SELECT 'Returned' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName]
-- My Task Default Options starts here
INSERT INTO CustomFilterColumndetails
-- Action Type Tasks
SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Priority Tasks
SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Flag Tasks
SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION
SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName]
-- My Task Default Options ends here
-- Team Task Default Options starts here
INSERT INTO CustomFilterColumndetails
-- Action Type Tasks
SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Priority Tasks
SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName]
INSERT INTO CustomFilterColumndetails
-- Action Flag Tasks
SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION
SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName]
--Team Task Default Options ends here
INSERT INTO CustomFilterColumndetails
SELECT 'Email Files' AS [name], '.eml,EML,MSG' AS [Code] ,1 AS [isSelected] ,0 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/outlook.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Images Files' AS [name], '.jpg,JPG,PNG,BMP,gif,tif,PSD,HEI,ICO,JPE' AS [Code] ,1 AS [isSelected] ,1 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/IMAGE.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'PDF Files' AS [name], '.pdf,PDF' AS [Code] ,1 AS [isSelected] ,2 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/pdf.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Text Files' AS [name], '.txt,TXT,LOG,TEX,RTF' AS [Code] ,1 AS [isSelected] ,3 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/TEXT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Documents' AS [name], 'docx,DOC,ODS,ODT' AS [Code] ,1 AS [isSelected] ,4 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/DOCUMENT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Excel Files' AS [name], 'CSV,XLS,xlsx' AS [Code] ,1 AS [isSelected] ,5 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/excelv1.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Audio Files' AS [name], 'MP3,WAV,M4A' AS [Code] ,1 AS [isSelected] ,6 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/WAVIcon.jpg' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Presentation Documents' AS [name], 'pptx,PPT,ODP,PPS' AS [Code] ,1 AS [isSelected] ,7 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/PPT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Compressed Files' AS [name], 'ZIP' AS [Code] ,1 AS [isSelected] ,8 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Video Files' AS [name], 'MP4,MOV' AS [Code] ,1 AS [isSelected] ,9 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Android Apps' AS [name], 'APK' AS [Code] ,1 AS [isSelected] ,10 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Web Files' AS [name], 'htm,XML,MHT,SWF' AS [Code] ,1 AS [isSelected] ,11 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Graphics Documents' AS [name], 'CGM,DWG,EPS,PS,SVG,VSD' AS [Code] ,1 AS [isSelected] ,12 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'DB Files' AS [name], 'FOL,SQL' AS [Code] ,1 AS [isSelected] ,13 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION
SELECT 'Calendar Files' AS [name], 'ICS' AS [Code] ,1 AS [isSelected] ,14 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName]
END
GO
--- Custom Filter Defined Script End
--Added for Default Partner in settings
IF NOT EXISTS (SELECT 1 FROM [dbo].[Settings] WHERE KeyName = 'TransactNewCaseDefaultPartner')
BEGIN
insert into [dbo].[Settings] values('TransactNewCaseDefaultPartner','');
END
GO
-- MAIL TEMPLATE FOR INVITE NEW USERS TO CLIENT PORTAL
IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'Invite_New_Client_User')
BEGIN
INSERT INTO [dbo].[PortalNotificationTemplate]
([TemplateType],
[TemplateSubject],
[TemplateBody])
VALUES(
'Invite_New_Client_User',
'Client Portal - Account Registration',
'
$TenantFirmName$
Hi,
You have been successfully registered on Client Portal
To complete your registration please use the below link.
You will be able to login to the portal after you enter all the required details.
'
)
END
GO
-- OTP TEMPLATE FOR 2FA IN CLIENT PORTAL
IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'SMS_OTP_VERIFICATION')
BEGIN
INSERT INTO [dbo].[PortalNotificationTemplate]
([TemplateType],
[TemplateBody])
VALUES(
'SMS_OTP_VERIFICATION',
'OTP for Client Portal login is %token. This OTP will be valid for %time minutes.'
)
END
GO
IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'SMS_OTP_RESET_PASSWORD')
BEGIN
INSERT INTO [dbo].[PortalNotificationTemplate]
([TemplateType],
[TemplateBody])
VALUES(
'SMS_OTP_RESET_PASSWORD',
'The OTP to reset your password for Client Portal is {0}'
)
END
GO
-- Mail template to 2FA and Reset
IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'MAIL_OTP_VERIFICATION')
BEGIN
INSERT INTO [dbo].[PortalNotificationTemplate]
([TemplateType],
[TemplateSubject],
[TemplateBody])
VALUES(
'MAIL_OTP_VERIFICATION',
'Client Portal - OTP for 2FA',
'Hi $UserName$,
The OTP for Client Portal login is
$PasswordResetOTP$
This OTP will be valid for $PasswordResetOTPExpirationTime$ minutes.
Thank You '
)
END
GO
IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'MAIL_OTP_RESET_PASSWORD')
BEGIN
INSERT INTO [dbo].[PortalNotificationTemplate]
([TemplateType],
[TemplateSubject],
[TemplateBody])
VALUES(
'MAIL_OTP_RESET_PASSWORD',
'Client Portal - OTP for Password Reset',
'Hi $UserName$,
The OTP to reset your password for Client Portal is
$PasswordResetOTP$
Generated at $PasswordResetOTPCreationTime$ (UTC), and valid up to $PasswordResetOTPExpirationTime$ (UTC).
Thank You '
)
END
GO
-- INSERT SCRIPT FOR SAM NOTIFICATIONS
IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'NoOfDaysNotificationFetch')
BEGIN
INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('NoOfDaysNotificationFetch','7')
END
GO
--INSERT SCRIPT FOR DEFAULT CASE DIARY VIEW
IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage]
WHERE [FilterOrder] = -1 AND [PageName]='CaseDiary')
BEGIN
INSERT INTO [dbo].[CustomFilterbyUserandPage]
([HandlerCode]
,[PageName]
,[FilterName]
,[CreatedDate]
,[FilterOrder]
,[GridViewState]
)
VALUES(
'STANDARD'
,'CaseDiary'
,'Standard_View'
,GETUTCDATE()
,-1
,'[{"ColumnName":"CompleteORGenerated","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"ActionType","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"PriorityValue","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"DelegationStatus","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"Attachments","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"Date","ShowColumn":true,"ColumnWidth":85},{"ColumnName":"DueDate","ShowColumn":false,"ColumnWidth":85},{"ColumnName":"CreationDate","ShowColumn":false,"ColumnWidth":85},{"ColumnName":"Time","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"FNCode","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"TeamCode","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"Synopsis","ShowColumn":true},{"ColumnName":"Subject","ShowColumn":false},{"ColumnName":"Text1","ShowColumn":false},{"ColumnName":"ActionCode","ShowColumn":true,"ColumnWidth":80},{"ColumnName":"ActionId","ShowColumn":false,"ColumnWidth":70},{"ColumnName":"Flag","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"NeedsAttention","ShowColumn":true,"ColumnWidth":30}]'
)
END
GO
IF EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EmailAzureAppClientId')
BEGIN
UPDATE [Settings] SET [KeyName] = 'AzureAppClientId' WHERE [KeyName] = 'EmailAzureAppClientId'
END
GO
IF EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EmailAzureAppClientSecret')
BEGIN
UPDATE [Settings] SET [KeyName] = 'AzureAppClientSecret' WHERE [KeyName] = 'EmailAzureAppClientSecret'
END
GO
-- INSERT SCRIPT FOR DEFAULT ACION CODE FOR TRANSACT NOTES
IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'TransactActionCode')
BEGIN
INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('TransactActionCode','ADMNT')
END
GO
-- NEW ACTION TYPE FOR REQUESTED DOCUMENT - FRAMEWORK CHANGE BY PINO
INSERT
INTO [dbo].[DiaryDelActionType]
([ActionType],
[ActionTypeDescription])
SELECT [NEW].[ActionType],
[NEW].[ActionTypeDescription]
FROM (SELECT CONVERT(NCHAR(1),
'L') AS [ActionType],
CONVERT(NVARCHAR(40),
'Requested Documents') AS [ActionTypeDescription]) [NEW]
LEFT OUTER JOIN [dbo].[DiaryDelActionType] [DDAT]
ON [DDAT].[ActionType] = [NEW].[ActionType]
WHERE [DDAT].[ActionType] IS NULL
GO
-- MY TASK - DEFAULT COLUMN LIST
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterbyUserandPage] AS [CF]
WHERE [CF].[HandlerCode] = 'STANDARD'
AND [CF].[PageName] = 'MyTask')
BEGIN
INSERT INTO [CustomFilterbyUserandPage] VALUES ('STANDARD','MyTask','Standard_View','2021-12-21 08:32:19.320','','','',0,-1,
'[{"ColumnName":"CompleteOrGeneratedD","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":0},{"ColumnName":"ActionType","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":1},
{"ColumnName":"DelegationStatus","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":2},{"ColumnName":"PriorityValue","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":3},
{"ColumnName":"Date1","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":4},{"ColumnName":"Time","ShowColumn":true,"ColumnWidth":60,"ColumnIndex":5},
{"ColumnName":"CaseCode","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":6},{"ColumnName":"Handler","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":7},
{"ColumnName":"Team","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":8},{"ColumnName":"ClientCase","ShowColumn":true,"ColumnIndex":9},
{"ColumnName":"Synopsis","ShowColumn":true,"ColumnIndex":10},{"ColumnName":"Flag","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":11},
{"ColumnName":"ActionId","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":12},{"ColumnName":"ActionCode","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":13},
{"ColumnName":"Action","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":14},{"ColumnName":"ActionStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":15},
{"ColumnName":"FileColour","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":16},{"ColumnName":"CaseFe","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":17},
{"ColumnName":"ClientName","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":18},{"ColumnName":"CreationDate","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":19},
{"ColumnName":"DelegatedFE","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":20},{"ColumnName":"DelType","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":21},
{"ColumnName":"DelDate","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":22},{"ColumnName":"DDStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":23},
{"ColumnName":"DStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":24},{"ColumnName":"DraftBillNo","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":25},
{"ColumnName":"DueDate","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":26},{"ColumnName":"DueTime","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":27},
{"ColumnName":"Duration","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":28},{"ColumnName":"FeeEarner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":29},
{"ColumnName":"FNCode","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":30},{"ColumnName":"From","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":31},
{"ColumnName":"Highlighted","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":32},{"ColumnName":"MatterDescription","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":33},
{"ColumnName":"OldRef","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":34},{"ColumnName":"Owner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":35},
{"ColumnName":"Partner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":36},{"ColumnName":"ProcessStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":37},
{"ColumnName":"ProcessType","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":38},{"ColumnName":"User1","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":39},
{"ColumnName":"User2","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":40},{"ColumnName":"Secretary","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":41},
{"ColumnName":"WorkFlow","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":42},{"ColumnName":"WorkProcess","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":43},
{"ColumnName":"YourRef","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":44}]')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'CaseDiary'
AND [CF].[Name] = 'Not Completed')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Not Completed','N',1,0,0,'','Action Status','CaseDiary')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'CaseDiary'
AND [CF].[Name] = 'Documents(s) Generated')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Documents(s) Generated','G',1,1,0,'','Action Status','CaseDiary')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'CaseDiary'
AND [CF].[Name] = 'Completed')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Completed','GC',1,2,0,'','Action Status','CaseDiary')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'MyTask'
AND [CF].[Name] = 'Not Completed')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Not Completed','N',1,0,0,'','Action Status','MyTask')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'MyTask'
AND [CF].[Name] = 'Documents(s) Generated')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Documents(s) Generated','G',1,1,0,'','Action Status','MyTask')
END
IF NOT EXISTS (SELECT TOP 1 1
FROM [CustomFilterColumndetails] AS [CF]
WHERE [CF].[ColumnName] = 'Action Status'
AND [CF].[PageName] = 'MyTask'
AND [CF].[Name] = 'Completed')
BEGIN
INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName)
VALUES('Completed','C',1,0,0,'','Action Status','MyTask')
END
GO
--Insert Report Credential
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_accountreports_Credential_Count',
3)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_accountreports_Credential_0',
'gESYD4OOetogwRlvcVmlDTYfGBIidB6xt_____rhVwzNlp1phFap2godJ9WLxUYpDu6s3PY20CgE3f_____-----hgWn03wUpC9')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_accountreports_Credential_1',
'lr3yd_____ARAWnTuXcxy-----tHhdbWGMIFU-----ZKoa6O7CuL9xZtUiaaYgOytDv5VEH_____ZSfAAhZCjld-----')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_2')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_accountreports_Credential_2',
'UuHNcgMS1mwQ=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_systemreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_systemreports_Credential_0',
'U6Vj8ZFqhxUzEI2-----twsbxmeGGyIt1E349gH4AgQHBVFsglTB75l_____3HWdcML14WWPFasi76ZL18k4k3MGqhUd-----')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_systemreports_Credential_1',
'n0Dind23r_____eafPN0BvFd320jr0DrzXQT0o7ipKBbQCqS99NOFw6DvFksY9SP5YhafqDzs8M_____lIAf25GofgsJD8=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4systemreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4systemreports_Credential_0',
'V7RiBzSfut1XBlounprY5MT4vhgHXEDFmzoFaaMOYLYIncW5DIBQgWFZW-----FM4JdHNWFnlw_____ONOZztdqW0qtFTfvEwuA8')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4systemreports_Credential_1',
'oVX1ou_____g5XwDXvLIECTrkWVmC0oYOBbrgpNDlgeXo47doQiwqD44Olpxc6qe6_____7OZI_____awgZH7whrNVk=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_partnerreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_partnerreports_Credential_0',
'7Ybgu6xgxGJI2iJcuSYjZH7iVKeRP1_____dP8xbhAiqY6LMvwfKjaMYE98u4sBndZDObprQIfAVC-----FJKrIcb_____70698V')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_partnerreports_Credential_1',
'hKPaq53HJh3Yd03oYkzlGPPEJy-----YnfpLbXEKKp8HCbIgTSwybjBK-----iInIorPc_____sT0u65Q1TwRrMgmxN3cmQ=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4partnerreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4partnerreports_Credential_0',
'7AQfei3DTAPQe9Ul60OkjqORGLW82y7f0Bd_____dVDO4Kz3DF1hqOUssmKesXefUGz3IEJlmtMsy_____h4lTFJFPS5GmbSOUWG')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_sam4partnerreports_Credential_1',
'_____DiP45h59bBrFWXSK9v4B12chE3h9JhnrDIwpHrbLPpFCz9SaDkGd2kxtfvcDZcUKWCMATK-----6Qvq3B0=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_clientreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_clientreports_Credential_0',
'38oPIN1e5Ix06jTUmAb0W799CsRA2Ls5uftPge77HBh-----w4zKTkNP-----Q7wLNgzyJonNvM8HXsgn7DF1fm8w2O1Fx9XKDR')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_clientreports_Credential_1',
'gGCfG08IXyKuXdMqv3P8rIvIOSnTn6cLvQGJSZjM1gDFem6OtxxLY4----------IfNA1OafodLdroLz5-----ylHyq0=')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_Count')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_billingreports_Credential_Count',
2)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_0')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_billingreports_Credential_0',
'sjqcXtHw-----hVDaU0RF2GfQcpqOzFsKPn8eaRflLwrf0onGVvVH42vnRLElcdvubo50Y-----QWQERiRgf7yfOeTFX55DIES3X')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_1')
BEGIN
INSERT INTO [Settings](
[keyname],
[keyvalue])
VALUES (
'KaaS_billingreports_Credential_1',
'ykg_____1PbC1NTuu8S3McczeXHuzxdqwow95ErPTewVMos5Ze2PO_____Vxqw8tPf-----iYwTWLwIkUgHxQuZL2Ew=')
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Black Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='black-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Black Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Blue Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='blue-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Blue Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Clear Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='clear-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Clear Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Green Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='green-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Green Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Orange Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='orange-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Orange Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Red Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='red-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Red Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [name]='Yellow Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag')
BEGIN
UPDATE [dbo].[CustomFilterColumndetails]
SET [Iconpath]='yellow-fg-svg', [IsIconAvailable]= 1
WHERE [name]='Yellow Flag'
AND PageName = 'MyTask'
AND ColumnName = 'Action Flag'
END
GO
-- DATAPUMP FOR CONTROL GROUPS AND PERMISSIONS
-- FIRST REMOVE EXISTING RECORDS
IF OBJECT_ID(N'KaasControlMaster',N'U') IS NOT NULL
BEGIN
TRUNCATE TABLE KaasControlMaster
END
GO
-- INSERT WITH NEW DATA
IF OBJECT_ID(N'KaasControlMaster',N'U') IS NOT NULL
BEGIN
INSERT INTO KaasControlMaster VALUES
('Access change WF in Case Diary', 'Fuse', 'array', 'template-library', 1, 2),
('Access Firm Phone Log', 'Fuse', 'array', 'phone-log', 1, 2),
('Access to Know Your Client', 'Fuse', 'array', 'KYC', 1, 2),
('Accounts User', 'Ribbon', 'array', 'Draft Invoice', 1, 2),
('Accounts User', 'Ribbon', 'array', 'Request Payment', 1, 2),
('Accounts User', 'Fuse', 'array', 'account-ledger', 1, 2),
('Accounts User', 'Fuse', 'array', 'my-cheques', 1, 2),
('Accounts User', 'Fuse', 'array', 'my-invoice', 1, 2),
('Accounts User', 'KnowyourclientComponent', 'material', 'financial_tab', 1, 2),
('AML Approval', 'ClientGeneralTabComponent', 'material', 'check_money_laundering_current_client_details', 1, 0),
('AML Approval', 'AMLComponent', 'material', 'check_money_laundering_aml', 1, 2),
('AML Approval', 'AMLComponent', 'material', 'aml_approved_date', 1, 0),
('Approve Invoice', 'DraftinvoiceComponent', 'element', 'btn_approve', 1, 2),
('Bank Details', 'AddEditAssociatesComponent', 'material', 'bank_details_tab_case_associate', 1, 1),
('Bank Details', 'CurrentClientDetailsComponent', 'material', 'bank_details_tab_current_client_details', 1, 1),
('Bank Details', 'ClientGeneralComponent', 'material', 'bank_details_tab_case_associate_name', 1, 1),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'client_charge_out_rate_indicator', 1, 0),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'dev', 'client_charge_out_rate_grid', 1, 0),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'toolbar', 'client_charge_out_rate_edit_btn_tool', 1, 2),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'context', 'client_charge_out_rate_edit_btn_context', 1, 2),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'client_charge_out_rate_retired_check', 1, 0),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'matter_charge_out_rate_indicator', 1, 0),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'dev', 'matter_charge_out_rate_grid', 1, 0),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'toolbar', 'matter_charge_out_rate_edit_btn_tool', 1, 2),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'context', 'matter_charge_out_rate_edit_btn_context', 1, 2),
('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'matter_charge_out_rate_retired_check', 1, 0),
('Change Day Book Handler', 'MyDayBookTableComponent', 'customDropDown', 'select_day_book_handler', 1, 0),
('Change Matter Security Permissions', 'ClientPermissionTabComponent', 'material', 'client_permission_tab', 1, 2),
('Change Matter Security Permissions', 'MatterPermissionTabComponent', 'material', 'matter_permission_tab', 1, 2),
('Delete Phone Log', 'Ribbon', 'array', 'Phone_log_delete', 1, 2),
('Discharge Undertaking', 'Ribbon', 'array', 'dischartUndertakings', 1, 0),
('Document Assist', 'Ribbon', 'array', 'document_assists', 1, 0),
('Maintain Associate Types', 'AssociatesComponent', 'context', 'associates_type_context_menu', 1, 2),
('Maintain Client and Case details', 'CurrentClientDetailsComponent', 'element', 'client_btn_save', 1, 2),
('Maintain Client and Case details', 'CurrentCaseDetailsComponent', 'element', 'matter_btn_save', 1, 2),
('Maintain Undertakings', 'AddEditUndertakingsComponent', 'element', 'undertaking_save_btn', 1, 2),
('Maintain Undertakings', 'Ribbon', 'array', 'addUndertakings', 1, 0),
('Maintain Undertakings', 'Ribbon', 'array', 'editUndertakings', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'material', 'archive_closed_check', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_actual_destroy_date', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_expected_destroy_date', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'customSelect', 'archive_destroy_by', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_box_bar_code', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_date_file_closed', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_file_bar_code', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'customSelect', 'archive_location_dropdown', 1, 0),
('Precedents', 'CaseDiaryMenuComponent', 'subMenu', 'precedent_id', 1, 0),
('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_location', 1, 0),
('Strong Room', 'Fuse', 'array', 'caseFileManager', 1, 2),
('Strong Room', 'Fuse', 'array', 'strongroom', 1, 2),
('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'CF', 1, 2),
('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'DF', 1, 2),
('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'RPF', 1, 2),
('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'WF', 1, 2),
('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'AF', 1, 2),
('Strong Room Maintenance', 'Ribbon', 'array', 'addFile', 1, 2),
('Strong Room Maintenance', 'Ribbon', 'array', 'changeFile', 1, 2),
('Strong Room Maintenance', 'Ribbon', 'array', 'deleteFile', 1, 2),
('Strong Room Maintenance', 'Ribbon', 'array', 'replaceFile', 1, 2),
('Strong Room Maintenance', 'Ribbon', 'array', 'withdrawFile', 1, 2),
('System Reports', 'Fuse', 'array', 'system-reports', 1, 2),
('Uncomplete Actions', 'EditCasediaryComponent', 'dev', 'complete_Check_Id', 1, 0),
('Undertakings', 'Fuse', 'array', 'undertakings', 1, 2),
('Undertakings', 'Fuse', 'array', 'firm-undertaking ', 1, 2),
('User Defined Reports', 'Fuse', 'array', 'user-reports', 1, 2),
('Action Flow Setup', 'Fuse', 'array', 'Workflow', 1, 2);
END
GO
-- DATAPUMP FOR CONTROL GROUPS AND MASTER IDS
-- FIRST REMOVE EXISTING RECORDS
IF OBJECT_ID(N'KaasGroupControlsMap ',N'U') IS NOT NULL
BEGIN
TRUNCATE TABLE KaasGroupControlsMap
END
GO
-- INSERT WITH NEW DATA
IF OBJECT_ID(N'KaasGroupControlsMap ',N'U') IS NOT NULL
BEGIN
INSERT INTO KaasGroupControlsMap SELECT ctlGrp.id, ctlMaster.ControlMasterId FROM KHCtlGroups ctlGrp
JOIN KaasControlMaster ctlMaster on ctlGrp.GroupName = ctlMaster.ControlGroupName;
END
GO
--Added for Document Upload retry count in Mobile
IF NOT EXISTS (SELECT 1 FROM [dbo].[Settings] WHERE KeyName = 'UploadRetryCount')
BEGIN
insert into [dbo].[Settings] values('UploadRetryCount','3');
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [ColumnName]='HasAttachment'
AND PageName = 'DocumentManager')
BEGIN
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Yes','Y',1,1,0,'','HasAttachment','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('No','N',1,2,0,'','HasAttachment','DocumentManager')
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [ColumnName]='Document Source'
AND PageName = 'DocumentManager')
BEGIN
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Capture','Capture',1,1,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Captured','Captured',1,2,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Case','Case',1,3,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Dictation','Dictation',1,4,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('IManage','IManage',1,5,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Received E-mail','Received E-mail',1,5,0,'','Document Source','DocumentManager')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Sent E-mail','Sent E-mail',1,6,0,'','Document Source','DocumentManager')
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [ColumnName]='DraftNo'
AND PageName = 'MyInvoice')
BEGIN
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Equals 0',0,1,0,0,'','DraftNo','MyInvoice')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Not equals 0',1,1,1,0,'','DraftNo','MyInvoice')
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [ColumnName]='Type'
AND PageName = 'MyInvoice')
BEGIN
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('C','C',1,0,0,'','Type','MyInvoice')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('I','I',1,1,0,'','Type','MyInvoice')
END
GO
IF NOT EXISTS
(SELECT TOP 1 1
FROM [dbo].[CustomFilterColumndetails]
WHERE [ColumnName]='OpenInvoice'
AND PageName = 'MyInvoice')
BEGIN
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('Yes','Y',1,0,0,'','OpenInvoice','MyInvoice')
INSERT INTO [dbo].[CustomFilterColumndetails]
VALUES ('No','N',1,1,0,'','OpenInvoice','MyInvoice')
END
GO
IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage]
WHERE [FilterOrder] = -1 AND [PageName]='MyInvoice')
BEGIN
INSERT INTO [dbo].[CustomFilterbyUserandPage]
([HandlerCode]
,[PageName]
,[FilterName]
,[CreatedDate]
,[FilterOrder]
,[GridViewState]
)
VALUES(
'STANDARD'
,'MyInvoice'
,'Standard_View'
,GETUTCDATE()
,-1
,'[{"ColumnName":"MATTER","ShowColumn":true,"ColumnWidth":95,"ColumnIndex":0},{"ColumnName":"BILLDATE","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":1},{"ColumnName":"ADDRESSEE","ShowColumn":true,"ColumnWidth":250,"ColumnIndex":2},{"ColumnName":"ADDRESS","ShowColumn":true,"ColumnIndex":3},{"ColumnName":"FeCode","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":4},{"ColumnName":"TYPE","ShowColumn":true,"ColumnWidth":50,"ColumnIndex":5},{"ColumnName":"TOTAL","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":6},{"ColumnName":"DRAFTNO","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":7},{"ColumnName":"INVOICENO","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":8},{"ColumnName":"OpenInvoice","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":9},{"ColumnName":"Released","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":10}]'
)
END
GO
IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage]
WHERE [FilterOrder] = -1 AND [PageName]='DocumentManager')
BEGIN
INSERT INTO [dbo].[CustomFilterbyUserandPage]
([HandlerCode]
,[PageName]
,[FilterName]
,[CreatedDate]
,[FilterOrder]
,[GridViewState]
)
VALUES(
'STANDARD'
,'DocumentManager'
,'Standard_View'
,GETUTCDATE()
,-1
,'[{"ColumnName":"Type","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":0},{"ColumnName":"Attachments","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":1},{"ColumnName":"IsInDocFolder","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":2},{"ColumnName":"Document","ShowColumn":true,"ColumnWidth":180,"ColumnIndex":3},{"ColumnName":"CurrentVersion","ShowColumn":true,"ColumnWidth":60,"ColumnIndex":4},{"ColumnName":"DiaryDate","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":5},{"ColumnName":"DocumentDate","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":6},{"ColumnName":"DocumentClassDescription","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":7},{"ColumnName":"DocumentSource","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":8},{"ColumnName":"EmailAddress","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":9},{"ColumnName":"AddressTo","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":10},{"ColumnName":"Subject","ShowColumn":true,"ColumnIndex":11},{"ColumnName":"FilePath","ShowColumn":true,"ColumnWidth":180,"ColumnIndex":12},{"ColumnName":"TrackReference","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":13},{"ColumnName":"ActionId","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":14},{"ColumnName":"DiaryTime","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":15},{"ColumnName":"DocumentTime","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":16},{"ColumnName":"SigningStatus","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":17}]'
)
END
GO
IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage]
WHERE [FilterOrder] = -1 AND [PageName]='Matter')
BEGIN
INSERT INTO [dbo].[CustomFilterbyUserandPage]
([HandlerCode]
,[PageName]
,[FilterName]
,[CreatedDate]
,[FilterOrder]
,[GridViewState]
)
VALUES(
'STANDARD'
,'Matter'
,'Standard_View'
,GETUTCDATE()
,-1
,'[{"ColumnName":"Code","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":0},{"ColumnName":"LastAccessed","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":1},{"ColumnName":"FileColour","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":2},{"ColumnName":"Name","ShowColumn":true,"ColumnWidth":150,"ColumnIndex":3},{"ColumnName":"Description","ShowColumn":true,"ColumnWidth":200,"ColumnIndex":4},{"ColumnName":"FeeEarner","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":5},{"ColumnName":"Started","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":6},{"ColumnName":"OldRef","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":7},{"ColumnName":"YourRef","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":8},{"ColumnName":"Dept","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":9},{"ColumnName":"WorkType","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":10},{"ColumnName":"Address","ShowColumn":false,"ColumnWidth":120,"ColumnIndex":11},{"ColumnName":"CaseStatusDesc","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":12},{"ColumnName":"CloseDate","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":13},{"ColumnName":"Closed","ShowColumn":false,"ColumnWidth":55,"ColumnIndex":14},{"ColumnName":"Email","ShowColumn":false,"ColumnWidth":150,"ColumnIndex":15},{"ColumnName":"FeeCode","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":16},{"ColumnName":"FileNum","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":17},{"ColumnName":"PhoneNumber","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":18},{"ColumnName":"User1","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":19},{"ColumnName":"User2","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":20}]'
)
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'DesktopAddinExpirationTime')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'DesktopAddinExpirationTime',
10)
END
GO
-- Legalsearch Folio No v4.5.0.x
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'UDF_ForFolio' )
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'UDF_ForFolio',
'u.folio;u.folio.no')
END
GO
----SAM Menu's Insert Script
IF OBJECT_ID(N'AccountMasterMenu ',N'U') IS NOT NULL
BEGIN
TRUNCATE TABLE [dbo].[AccountMasterMenu];
END
GO
IF OBJECT_ID(N'AccountMasterMenu ',N'U') IS NOT NULL
BEGIN
SET IDENTITY_INSERT [dbo].[AccountMasterMenu] ON
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (1, N'Dashboard', 0, N'sam/dashboard', N'Dashboard', N'DASHBOARD', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (2, N'Home', 1, N'sam/dashboard', N'HomeIcon', N'VIEW_DASHBOARD', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (3, N'Client/Case/Suppliers', 0, N'sam/common/clientContacts', N'ClientCaseSupplier', N'CLIENT_CASE', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (4, N'Clients', 3, N'sam/common/clientContacts', N'Client', N'CLIENTS', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (5, N'Matters', 3, N'sam/browsematter/matters', N'Matters', N'MATTERS', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (6, N'New Matter', 3, N'sam/new-case-wizard/new-case', N'NewMatter', N'NEW_MATTER', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (7, N'Payments', 0, N'sam/approve-cheque-requisitions/approveCheque', N'Payment', N'PAYMENTS', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (8, N'Maintenance', 0, N'sam/system-options/systemOptions', N'Maintenance', N'MAINTENANCE', 1, 8, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (9, N'System Options', 8, N'sam/system-options/systemOptions', N'SystemOptions', N'SYSTEM_OPTIONS', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (10, N'User Access', 8, N'sam/user-menu-access/permissionList', N'UserAccess', N'USER_ACCESS', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (11, N'Close Matter', 3, N'sam/closematter/matters', N'Matters', N'SAM-CLOSE-MATTER', 0, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (12, N'Move Matter', 3, N'sam/move-matter/mattersList', N'Matters', N'SAM-MOVE-MATTER', 0, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (13, N'Mail Category', 3, N'sam/cateogory-mail/categoryMail', N'MailCategory', N'SAM-MAIL-CATEGORY', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (14, N'Suppliers', 3, N'sam/samCommon/browseSuppliers', N'Supplier', N'SAM-SUPPLIERS', 1, 7, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (15, N'Closed Matter Enquiry', 3, N'sam/archive-enquiry', N'ClosedEnquiry', N'SAM-ARCHIVE-ENQUIRY', 1, 10, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (16, N'File Manager', 3, N'strong-room/strong-room-list', N'FileManager', N'FILE_MANAGER', 1, 8, 1, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (17, N'Matter Interest Calculator', 3, N'error/under-construction', N'MatterInterestCalculator', N'MATTER_INT_CALC', 1, 9, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (18, N'KPI Parameters', 8, N'error/under-construction', N'Kpi', N'KPI_PARAMETERS', 1, 3, 0, 1)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (19, N'Code Maintenance', 8, N'sam/maintenance/code-maintenance', N'CodeMaintenance', N'CODE-MAINTENANCE', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (22, N'Approve Payment Requests', 7, N'sam/approve-cheque-requisitions/approveCheque', N'ApprovePaymentRequest', N'APPROVE_PAYMENT_REQ', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (24, N'Payments', 7, N'sam/payments/browsePayments', N'Payment', N'SAM_PAYMENTS', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (25, N'Multi Payments', 7, N'sam/multiple-cheque/multipleCheque', N'MultiPayments', N'MULTI_PAYMENTS', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (26, N'Transfer for Costs', 7, N'sam/transferForCost/transferForCostList', N'TransferForCost', N'TRANSFER_COST', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (27, N'Creditors Payment List', 7, N'sam/creditors-payment/creditorsPaymentList', N'CreditorsPaymentList', N'CREDITORS_PAYMENT', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (29, N'Pick-up Pre-Billed Outlay Transfers', 7, N'sam/pick-up-pre-billed-outlay-transfers/possibleOutlayTransfers', N'PickupPreBilledTransfer', N'PICKUP_PREBILLED', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (30, N'Postings', 0, N'sam/receipts/receiptList', N'Posting', N'POSTINGS', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (32, N'Receipts', 30, N'sam/receipts/receiptList', N'Receipt', N'RECEIPTS', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (33, N'Bank Transfers', 30, N'sam/bank-transfer/bankTransferList', N'BankTransfer', N'BANK-TRANSFERS', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (34, N'Purchase Bills', 30, N'sam/purchase-bills/purchaseBillList', N'PurchaseBill', N'PURCHASE-BILLS', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (35, N'Journals', 30, N'sam/journal/journalList', N'Journal', N'JOURNALS', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (40, N'Memorized Transactions', 30, N'sam/memorise/browseMemorise', N'MemorisedTransaction', N'MEMO-TRANSACTIONS', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (41, N'Accurals/Prepayments', 30, N'sam/accruals-prepayment/accruals', N'PrePayment', N'ACCURALSPREPAYMENTS', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (43, N'Unposted Batches', 30, N'sam/browseBatches/browseUnpostedBatches', N'UnpostedBatches', N'UNPOSTEDBATCHES', 1, 7, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (44, N'Query Batches', 30, N'sam/browsePostedBatches/browsePostedBatches', N'QueryBatches', N'POSTEDBATCHES', 1, 8, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (45, N'Period End', 30, N'sam/period-end/periodEnd', N'PeriodEnd', N'PERIODEND', 1, 9, 0, 1)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (46, N'Year End', 30, N'sam/year-end-proc/updateSysOpt', N'YearEnd', N'YEARRND', 1, 10, 0, 1)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (47, N'Update Debt Ledger Postings', 30, N'sam/DebtLodgement/Debt', N'UpdateDebtLedger', N'UPDATEDEBTLEDGER', 1, 11, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (48, N'Bank Reconciliation', 0, N'sam/bank-reconciliation/start-bank-reconciliation', N'BankReconciliation', N'BANKRECONCILIATION', 1, 9, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (49, N'Initiate Bank Reconciliation', 48, N'sam/bank-reconciliation/start-bank-reconciliation', N'InitateBankRecon', N'STARTBR', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (50, N'Reconcile', 48, N'sam/bank-reconciliation/reconcile', N'Reconcile', N'RECONCILE', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (51, N'Reconciliation Statements', 48, N'sam/bank-reconciliation/browse-bank-reconciliation-statement', N'ReconciliationStatement', N'RECONCILESTATEMENTS', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (52, N'Enquiry', 48, N'sam/bank-reconciliation/bank-reconciliation-enquiry', N'Enquiry', N'ENQUIRY', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (53, N'Undo Reconciliation', 48, N'sam/bank-reconciliation/undo-reconciliation', N'UndoReconciliation', N'UNDORECONCILIATION', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (54, N'Opening Position Set-up', 48, N'sam/bank-reconciliation/browse-previous-reconciliation-details', N'OpeningPositionSetup', N'OPENPOSITION', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (55, N'Clear Down Balances Transactions', 48, N'sam/bank-reconciliation/clear-bank-transaction', N'ClearDownTransaction', N'CLEARBANK', 1, 7, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (56, N'Invoices', 0, N'sam/issueInvoice/Invoice', N'Invoice', N'INVOICES', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (58, N'Invoice Approval', 56, N'sam/approve-billing/billing', N'InvoiceApproval', N'DRAFT_INVOICE', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (59, N'Invoices', 56, N'sam/issueInvoice/Invoice', N'Invoice', N'ISSUE_INVOICE', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (60, N'Ledgers', 0, N'sam/ledger/matterledger', N'Ledger', N'LEDGER', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (61, N'Matter Ledger', 60, N'sam/ledger/matterledger', N'MatterLedgerIcon', N'MATTER_LEDGER', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (62, N'Matter Debtors Ledger', 60, N'sam/ledger/debtorledgerbymatter', N'MatterLedger', N'MATTER_DEBT_LEDGER', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (63, N'Debtors Ledger', 60, N'sam/debtorsledger/debtors-ledger-by-client', N'DebtorsLedger', N'DEBTORS_LEDGER', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (64, N'Creditors Ledger', 60, N'sam/supplier/supplier-ledger', N'CreditorsLedgerIcon', N'CREDITORS_LEDGER', 1, 4, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (65, N'Nominal Accounts', 60, N'sam/nominal/nominalLedger', N'NominalAccounts', N'NOMINAL_LEDGER', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (66, N'Query Posting', 60, N'sam/query-posting/postedBatchList', N'MatterLedger', N'QUERY_POSTING', 1, 6, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (67, N'Outstanding Invoices', 60, N'sam/ledger/outstandingDebtors', N'OutstandingInvoices', N'OUTSTANDING_DEBTORS', 1, 7, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (68, N'UnAllocated Payments', 60, N'sam/ledger/unallocatedPayments', N'UnallocatedPayments', N'UNALLOCATEDPAYMENTS', 1, 8, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (69, N'UnAllocated Receipts', 60, N'sam/ledger/unallocatedReceipts', N'UnallocatedReceipts', N'UNALLOCATEDRECEIPTS', 1, 9, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (70, N'Debit Client A/C''s', 60, N'sam/ledger/debitClientAc', N'DebitAccount', N'DEBITCLIENTACC', 1, 10, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (71, N'Office Credit A/C''s', 60, N'sam/ledger/officeCreditAcc', N'CreditAccount', N'OFFICECREDITACC', 1, 11, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (72, N'Reports', 0, N'sam/accountreports/reports/accounts-reports', N'Reports', N'MY_REPORTS', 1, 7, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (73, N'Accounts Reports', 72, N'sam/accountreports/reports/accounts-reports', N'AccountReport', N'ACCOUNT_REPORTS', 1, 1, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (74, N'User Reports', 72, N'sam/accountreports/reports/user-reports', N'UserReport', N'USER_REPORTS', 1, 2, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (75, N'Billing Reports', 72, N'sam/accountreports/reports/billing-reports', N'BillingReport', N'BILLING_REPORTS', 1, 3, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (76, N'Nominal Accounts', 8, N'sam/nominal/browseNominalAccounts', N'NominalAccMaintenence', N'NOMINAL_ACCOUNTS', 1, 5, 0, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (77, N'Nominal Reporting Sequence', 8, N'error/under-construction', N'NominalReportingSeq', N'NOMINAL_REP_SEQ', 1, 6, 0, 1)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (78, N'EFT Logs', 8, N'error/under-construction', N'EftLogs', N'EFT_LOGS', 1, 7, 1, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (79, N'Interest Rates', 8, N'error/under-construction', N'InterestRates', N'INTEREST_RATES', 1, 8, 1, 0)
INSERT [dbo].[AccountMasterMenu] ([MenuId], [MenuName], [MenuParentId], [MenuRoute], [MenuIconName], [MenuCode], [MenuIsActive], [MenuOrder], [MenuOpenNewTab], [MenuOpenDialogBox]) VALUES (80, N'Electronic Fund Transfer', 7, N'sam/eft/eftList', N'MyPaymentRequests', N'EFT', 1, 7, 0, 0)
SET IDENTITY_INSERT [dbo].[AccountMasterMenu] OFF
END
GO
-- Setting Default Prebilled Outlay for draft invoice by default to true
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'DefaultPrebilledOutlay')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'DefaultPrebilledOutlay',
'Y')
END
GO
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'GraphAPIFromEmailName')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'GraphAPIFromEmailName',
'Keyhouse365 Admin')
END
GO
-- Setting EFT Default On as true
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTDefaultON')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTDefaultON',
'Y')
END
GO
-- Setting EFT Email to Send as true by default
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTEmailToSend')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTEmailToSend',
'Y')
END
GO
-- Setting Default EFT Transaction Limit as 0.00
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTTransactionLimit')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTTransactionLimit',
0.00)
END
GO
-- Setting Default EFT Number Of Transaction Limit as 0
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTNoOfTransactionLimit')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTNoOfTransactionLimit',
0)
END
GO
-- Setting Default EFT Email Subject
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTEmailSubject')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTEmailSubject',
'')
END
GO
-- Setting Default EFT Email Message
IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EFTEmailMessage')
BEGIN
INSERT INTO [Settings](
[KeyName],
[KeyValue])
VALUES (
'EFTEmailMessage',
'')
END
GO