Tabulator Grouping (level 2) Bootstrap 4.5 theme
Tabulator Group by two fields
HIDE CODE
<?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();
?>
Fatal error: Uncaught mysqli_sql_exception: Table 'suppsales_charts.payments' doesn't exist in D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php:61 Stack trace: #0 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php(61): mysqli->query('SHOW COLUMNS FR...', 1) #1 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud.php(4896): Xcrud_db->query('SHOW COLUMNS FR...') #2 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud.php(1992): Xcrud->_get_table_info() #3 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\pages\tabulator_grouping_level2.php(33): Xcrud->render() #4 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\html\template.php(82): include('D:\\aaa_iVzuvi\\t...') #5 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\index.php(31): include('D:\\aaa_iVzuvi\\t...') #6 {main} thrown in D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php on line 61