if (select count(*) from [kz_ReportTypeMaster] where [ReportTypeMasterId]=13)=0
BEGIN
SET IDENTITY_INSERT [dbo].[kz_ReportTypeMaster] ON
INSERT [dbo].[kz_ReportTypeMaster] ([ReportTypeMasterId], [ReportTypeName], [ScriptCSSLibrary], [ReportScript], [HeaderData], [FooterData]) VALUES (13, N'Tabulator', N'<link href="
https://unpkg.com/tabulato...@6.2.0/dist/css/tabulator.min.css" rel="stylesheet">
<script type="text/javascript" src="
https://unpkg.com/tabulato...@6.2.0/dist/js/tabulator.min.js"></script><script type="text/javascript" src="
https://oss.sheetjs.com/sheetjs/xlsx.full.min.js"></script><script src="
https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.4.0/jspdf.umd.min.js"></script>
<script src="
https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.20/jspdf.plugin.autotable.min.js"></script>', N'var Coldata = [];
for (r = 0; r < RawData.Reports[0].Header.length; r++) {
Coldata.push({''title'':RawData.Reports[0].Header[r],''field'':RawData.Reports[0].Header[r]});
}
var tabledata = [];
for (r = 0; r < RawData.Reports[0].Body.length; r++) {
var rowdata ={};
for (i = 0; i < RawData.Reports[0].Body[r].length; i++) {
rowdata[RawData.Reports[0].Header[i]] = RawData.Reports[0].Body[r][i];
}
tabledata.push(rowdata);
}
var table = new Tabulator("#kaizen_tableReportDiv", {
data:tabledata,
columns:Coldata ,
//setting start here
//setting end here
});', 0, 0)
SET IDENTITY_INSERT [dbo].[kz_ReportTypeMaster] OFF
END