Tabulator Grouping (level 2)

Tabulator group by two fields.


public function tabulator_grouping_level_2()
{
  $xcrud = get_xcrud();
  $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->tabulator_active(true);
  $xcrud->tabulator_column_properties('checkNumber','editor:input');
  $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->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('amount','responsiveLayout:"collapse",align:"right",frozen:true,editor:"input", editor:true');
  

  $data['content'] = $xcrud->render();
  
  return view('demos', $data);
}

Payments

Search