Tabulator Grouping (level 2) Default theme
Tabulator Group by two fields
HIDE CODE
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | <?php $xcrud = Xcrud::get_instance(); $xcrud->table('payments'); $xcrud->label('checkNumber','Check No'); $xcrud->label('paymentDate','Payment Date'); $xcrud->label('customerNumber','Customer Number'); $xcrud->label('amount','Amount'); $xcrud->columns('paymentDate,customerNumber,checkNumber,amount'); $xcrud->column_width('checkNumber','35%'); $xcrud->column_width('paymentDate','25%'); $xcrud->column_width('action','30%'); //$xcrud->column_width('action','25%'); //$xcrud->column_tabulator_properties('amount','responsiveLayout:"collapse",align:"right",sorter:"date",editable:true,formatter:"star", formatterParams:{color:["#00dd00", "orange", "rgb(255,0,0)"]}'); $xcrud->tabulator_column_properties('checkNumber','editor:input'); //$xcrud->tabulator_column_properties('amount','responsiveLayout:"collapse",align:"right",frozen:true,editor:"input", editor:true'); $xcrud->tabulator_active(true); //groupBy:["customerNumber","paymentDate"] $xcrud->tabulator_main_properties('responsiveLayout:"collapse", movableColumns: true, headerVisible:true, width: "100%", height: "400px", groupStartOpen:true, placeholder:"No Data Available", tooltipsHeader:true, tooltips:true, groupBy:["customerNumber","paymentDate"]'); //'layout: "fitColumns", //$xcrud->columns('paymentDate', true); //groupBy:["customerNumber","paymentDate"], echo $xcrud->render();?> |
Payments
Add Export into CSV Print Search
Payment Date
124(8 items)
05.03.2005 00:00:00(1 item)
11.04.2003 00:00:00(1 item)
16.04.2005 00:00:00(1 item)
27.12.2004 00:00:00(1 item)
02.11.2004 00:00:00(1 item)
15.08.2003 00:00:00(1 item)
26.03.2004 00:00:00(1 item)
25.11.2003 00:00:00(1 item)
128(2 items)
28.01.2003 00:00:00(1 item)
18.10.2003 00:00:00(1 item)
?>
