|
update menu set menu_status=1 where ModuleMenu_Id=2115
|
|
update menu set menu_status=1 where ModuleMenu_Id=2126
|
|
Delete menu where ModuleMenu_Id in (2115,2126)
|
|
GO
|
|
select * from menu where ModuleMenu_Id in (2115,2126)
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPANCClosureSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPANCClosureSummary',1,'THL','LPA Findings Closure Summary',2,'LPA Findings Closure Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPAFindingsReportSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPAFindingsReportSummary',1,'THL','LPA Findings Report Summary',2,'LPA Findings Report Summary',0,0,0)
|
|
END
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPAFindingsReportSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPAFindingsReportSummary',1,'THL','LPA Findings Report Summary',9,'LPA Findings Report Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPANCClosure')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPANCClosure',1,'THL','LPA Findings Closure Summary',2,'LPA Findings Closure Summary',0,0,0)
|
|
END
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPANCClosure')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPANCClosure',1,'THL','LPA Findings Closure Summary',9,'LPA Findings Closure Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPAFindingsClassificationSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPAFindingsClassificationSummary',1,'THL','LPA Findings Classification Summary',2,'LPA Findings Classification Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPAFindingsClassificationSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPAFindingsClassificationSummary',1,'THL','LPA Findings Classification Summary',9,'LPA Findings Classification Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPAExcusePerformanceReport')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPAExcusePerformanceReport',1,'THL','LPA Excuse Performance Report',2,'LPA Excuse Performance Report',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPAExcusePerformanceReport')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPAExcusePerformanceReport',1,'THL','LPA Excuse Performance Report',9,'LPA Excuse Performance Report',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPANCClosureSummary')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPANCClosureSummary',1,'THL','LPA Findings Closure Summary',9,'LPA Findings Closure Summary',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='THLLPAExcuseReport')
|
|
BEGIN
|
|
Insert into Sulabels values('THLLPAExcuseReport',1,'THL','LPA Excuse Report',2,'LPA Excuse Report',0,0,0)
|
|
END
|
|
GO
|
|
IF NOT EXISTS (SELECT 1 from sulabels where staticname ='ROLLPAExcuseReport')
|
|
BEGIN
|
|
Insert into Sulabels values('ROLLPAExcuseReport',1,'THL','LPA Excuse Report',9,'LPA Excuse Report',0,0,0)
|
|
END
|
|
GO
|
|
delete from menu where ModuleMenu_Id=2133
|
|
INSERT into menu Values('THLLPAFindingsReportSummary','THLLPAFindingsReportSummary',2,'?/AuditProReports/LPA_FindingsSummary','AuditPro/nc-report.png',2114,0,'',1,2133,8,1,0,1,'fas fa-border-style')
|
|
GO
|
|
delete from menu where ModuleMenu_Id=2134
|
|
INSERT into menu Values('THLLPANCClosureSummary','THLLPANCClosureSummary',2,'?/AuditProReports/LPA_FindingsClosureSummary','AuditPro/nc-report.png',2114,0,'',1,2134,9,1,0,1,'fas fa-border-style')
|
|
GO
|
|
delete from menu where ModuleMenu_Id=2135
|
|
INSERT into menu Values('THLLPAFindingsClassificationSummary','THLLPAFindingsClassificationSummary',2,'?/AuditProReports/LPA_FindingsClassificationSummary','AuditPro/nc-report.png',2114,0,'',1,2135,10,1,0,1,'fas fa-border-style')
|
|
GO
|
|
delete from menu where ModuleMenu_Id=2136
|
|
INSERT into menu Values('THLLPAExcusePerformanceReport','THLLPAExcusePerformanceReport',2,'?/AuditProReports/LPA_Excuse_Performance','AuditPro/nc-report.png',2114,0,'',1,2136,11,1,0,1,'fas fa-border-style')
|
|
GO
|
|
delete from menu where ModuleMenu_Id=2137
|
|
INSERT into menu Values('THLLPAExcuseReport','THLLPAExcuseReport',2,'?/AuditProReports/LPA_Excuse_Report','AuditPro/nc-report.png',2114,0,'',1,2137,12,1,0,1,'fas fa-border-style')
|
|
GO
|
|
delete from suModuleRoles where role_id=2913
|
|
Insert into suModuleRoles values(2,2913,'Report : LPA Findings Report Summary','Report : LPA Findings Report Summary','ROLLPAFindingsReportSummary','Reports',1)
|
|
Go
|
|
delete from suModuleRoles where role_id=2914
|
|
Insert into suModuleRoles values(2,2914,'Report : LPA Findings Closure Summary','Report : LPA Findings Closure Summary','ROLLPANCClosureSummary','Reports',1)
|
|
Go
|
|
delete from suModuleRoles where role_id=2915
|
|
Insert into suModuleRoles values(2,2915,'Report : LPA Findings Classification Summary','Report : LPA Findings Classification Summary','ROLLPAFindingsClassificationSummary','Reports',1)
|
|
Go
|
|
delete from suModuleRoles where role_id=2916
|
|
Insert into suModuleRoles values(2,2916,'Report : LPA Excuse Performance Report','Report : LPA Excuse Performance Report','ROLLPAExcusePerformanceReport','Reports',1)
|
|
Go
|
|
delete from suModuleRoles where role_id=2917
|
|
Insert into suModuleRoles values(2,2917,'Report : LPA Excuse Report','Report : LPA Excuse Report','ROLLPAExcuseReport','Reports',1)
|
|
Go
|
|
delete from MenuRoles where menu_id=2133 and role_id=2913
|
|
Insert INto MenuRoles values(2133,2913)
|
|
GO
|
|
delete from MenuRoles where menu_id=2134 and role_id=2914
|
|
Insert INto MenuRoles values(2134,2914)
|
|
GO
|
|
delete from MenuRoles where menu_id=2135 and role_id=2915
|
|
Insert INto MenuRoles values(2135,2915)
|
|
GO
|
|
delete from MenuRoles where menu_id=2136 and role_id=2916
|
|
Insert INto MenuRoles values(2136,2916)
|
|
GO
|
|
delete from MenuRoles where menu_id=2137 and role_id=2917
|
|
Insert INto MenuRoles values(2137,2917)
|
|
GO
|