Column Grouping Default theme
simple column grouping,summation of a column value, inline editing
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table('payments');
$xcrud->unset_remove();
$xcrud->column_hide('customerNumber');
$xcrud->group_by_columns('customerNumber');//Allows only one field
$xcrud->group_sum_columns('amount');//Allows only one field
$xcrud->columns('customerNumber,checkNumber,amount');
$xcrud->fields_inline('customerNumber,checkNumber,paymentDate,amount');
echo $xcrud->render();
?>
Payments
| # | Checknumber | Amount | |
|---|---|---|---|
| - Customernumber: 171 (1 items) | |||
| 1 | GB878038hhh | 28 | View Edit |
| total | 28 | ||
| - Customernumber: 17277 (1 items) | |||
| 2 | 83-2091___ | 28 | View Edit |
| total | 28 | ||
| - Customernumber: 172 (1 items) | |||
| 3 | 20-8589___ | 28 | View Edit |
| total | 28 | ||
| - Customernumber: 173 (2 items) | |||
| 4 | GP545698 | 28 | View Edit |
| 5 | IG462397 | 20355.24 | View Edit |
| total | 20383.24 | ||
| - Customernumber: 175 (2 items) | |||
| 6 | IO448913 | 24879.08 | View Edit |
| 7 | PI15215 | 42044.77 | View Edit |
| total | 66923.85 | ||
| - Customernumber: 177 (2 items) | |||
| 8 | AU750837 | 15183.63 | View Edit |
| 9 | CI381435 | 47177.59 | View Edit |
| total | 62361.22 | ||
| - Customernumber: 181 (1 items) | |||
| 10 | CM564612 | 22602.36 | View Edit |
| total | 22602.36 | ||