Need to integrate Tabulator Into Existing Live project

13 views
Skip to first unread message

Narendra

unread,
Nov 7, 2024, 1:35:06 AM11/7/24
to Kaizen
Dear Team

We need to integrate Tabulator into one of our live project which is running under version 1.1.10

Can we achieve the same by running any script assisted by you ??

Or Do we have to upgrade the kaizen to the latest compulsorily ??


--

Hardik Parekh

unread,
Nov 7, 2024, 2:45:19 AM11/7/24
to Kaizen Framework
run the folowing script in sql, it will add tabulator in report 


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
Reply all
Reply to author
Forward
0 new messages