// ---------------------------------------------------------------------------------------------------------- // Support script generating Pivot table for PivotTable.html example // ------------------------------------------------------------------------------------------------------ // Custom calculation function to calculate individual cells in pivot table TCalc.prototype.GSum = function(R,RV,C,CV,D){ var G = Grids[0], sum = 0; for(var r=G.GetFirst();r;r=G.GetNext(r)) { if(!r.Deleted && r[R]==RV && r[C]==CV) sum+=r[D]; } return sum; } // ------------------------------------------------------------------------------------------------------ // Main function to create pivot table function CreatePivotTable(){ var G = Grids[0]; var R = G.GetRowById("Rows").Cols.split(","); // Rows var C = G.GetRowById("Cols").Cols.split(","); // Columns var D = G.GetRowById("Data").Cols.split(","); // Data if(!R[0] || !C[0] || !D[0]) return; // Error - incomplete setting // --- init --- var L = ""; L+=""; // --- Cols --- var A = {}, C0 = []; for(var r=G.GetFirst();r;r=G.GetNext(r)) if(!r.Deleted) A[G.GetValue(r,C[0])]=1; // finds all different values for(var a in A) C0[C0.length] = a; // puts all values to array if(!C0.length) return // Error - no values C0.sort(); // sorts the array L += ""; L += ""; for(var i=0;i"; L += ""; L += ""; L += "

"; } L += ""; var T = Grids["Pivot"]; if(T){ T.Data.Data.Data = L; T.Reload(); } else { var IO = new TDataIO; IO.Data.Data = L; T = TreeGrid(IO,"Grid2"); } } // ------------------------------------------------------------------------------------------------------ // Creates pivot table after the source is displayed Grids.OnRenderFinish = function(G){ if(G.id=="PivotSource") CreatePivotTable(); } // ------------------------------------------------------------------------------------------------------ // Called after a user changed some value in Pivot source Grids.OnAfterValueChanged = function(G,row,col){ var G = Grids["Pivot"]; if(!G || G.Loading || G.Rendering) return; // --- changed pivot => recreate --- if(row.Space!=null || col=="A" || col=="B" || col=="C") CreatePivotTable(); // --- updates only calculation --- else G.Calculate(1); } // ------------------------------------------------------------------------------------------------------ function Recreate(){ var G = Grids["Pivot"]; if(!G || G.Loading || G.Rendering) return; CreatePivotTable(); } Grids.OnRowAdd = Recreate; Grids.OnRowDelete = Recreate; Grids.OnRowUndelete = Recreate; // ------------------------------------------------------------------------------------------------------