Cập nhật báo cáo

Chuyển dữ liệu báo cáo từ VTTECHDEMO sang Client - VTT_Report_Sheet - VTT_Report_Teamplate_Group - VTT_Report_Template

// Copy  và  từ DEMO sang Client
TRUNCATE TABLE  [VTT_Report_Sheet] 
INSERT INTO  [VTT_Report_Sheet] ([ID],[Name],[Value],[Created],[Created_By],[Modified],[Modified_By],[State],[Tag],[Description],[Description_Code],[type])
SELECT  [ID],[Name],[Value],[Created],[Created_By],[Modified],[Modified_By],[State],[Tag],[Description],[Description_Code],[type]
FROM VTTECHDEMO.[dbo].[VTT_Report_Sheet] WHERE State=1
	 
TRUNCATE TABLE  [VTT_Report_Teamplate_Group]
INSERT INTO VTT_Report_Teamplate_Group ([ID],[Title],[Index],[ColorTextClass],[Created],[Created_By],[Modified],[State],[Description],[IsActive],[LangKey])
SELECT ID, [Title],[Index],[ColorTextClass],[Created],[Created_By],GETDATE(),[State],[Description],[IsActive], [LangKey]
FROM VTTECHDEMO.[dbo].[VTT_Report_Teamplate_Group] WHERE State=1 

//  
SELECT *
INTO #DTTemplate
FROM VTTECHDEMO.[dbo].VTT_Report_Template WHERE State=1  
DECLARE @Template NVARCHAR(1000), @ID INT 

WHILE((SELECT COUNT(ID) FROM #DTTemplate)>0)
BEGIN
	SET @Template = ISNULL((SELECT TOP 1 ISNULL(Teamplate,'') FROM #DTTemplate ),0)
	SET @ID = ISNULL((SELECT TOP 1 ISNULL(ID,0) FROM #DTTemplate ),0)

	IF(ISNULL((SELECT COUNT(V.ID) FROM VTT_Report_Template V WHERE V.ID=@ID),0)=0) --NẾU CHƯA CÓ BÁO CÁO -> INSERT
	BEGIN
		INSERT INTO VTT_Report_Template ([ID],[ReportGroupID],[Title],[Teamplate],[Index],[Created],[Created_By],[Modified],[Modified_By],[State],[UseBranch],[UseDate],[Description],[UseWare],[UseMultiBranch],[UseAllBranch],[AllowRangeDate],[UseSource],[UseStaff],[UsePage],[UseServiceCare],[UseTag],[IsActive],NumDateDefault)
		SELECT TOP 1 [ID],[ReportGroupID],[Title],[Teamplate],[Index],[Created],[Created_By],GETDATE(),[Modified_By],[State],[UseBranch],[UseDate],[Description],[UseWare],[UseMultiBranch],[UseAllBranch],[AllowRangeDate],[UseSource],[UseStaff],[UsePage],[UseServiceCare],[UseTag],0,NumDateDefault
		FROM #DTTemplate
	END ELSE -- ĐÃ CÓ BÁO CÁO
	BEGIN
		IF(ISNULL((SELECT COUNT(V.ID) FROM VTT_Report_Template V WHERE V.Teamplate = @Template),0)=0) -- NẾU CÓ BÁO CÁO VÀ KHÁC TEMPLATE -> CẬP NHẬT DATA -> BẬT ACTIVE = 0
		BEGIN
			UPDATE VTT_Report_Template 
			SET IsActive = 0, Teamplate = @Template, Modified = GETDATE()
			WHERE ID = @ID
		END
	END

	DELETE TOP (1) FROM #DTTemplate
END 
DROP TABLE #DTTemplate

UPDATE T
SET T.ReportGroupID = VT.ReportGroupID, T.Title = VT.Title, T.Description = VT.Description ,T.State=VT.State
FROM VTT_Report_Template T
INNER JOIN VTTECHDEMO.dbo.VTT_Report_Template VT ON VT.ID = T.ID

Nếu có Template Group Report mới phải thêm ID group vào VTT_Option của Client: Type = sys_groupreport