Field Grouping NEW Bootstrap 4.5 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: 141144146 (1 items) | ||||
1 | IN446258 | 66071.55 | View Edit | |
total | 66071.55 | |||
Customernumber: 141 (5 items) | ||||
2 | JE105477PAUL | 120166.58 | View Edit | |
3 | JN355280 | 49539.37 | View Edit | |
4 | JN722010 | 40206.2 | View Edit | |
5 | MF629602 | 20009.53 | View Edit | |
6 | NU627706 | 26155.91 | View Edit | |
total | 256077.59 | |||
Customernumber: 144 (2 items) | ||||
7 | IR846303 | 36005.71 | View Edit | |
8 | LA685678 | 7674.94 | View Edit | |
total | 43680.65 | |||
Customernumber: 145 (2 items) | ||||
9 | CN328545 | 4710.73 | View Edit | |
10 | ED39322MARK | 28211.7 | View Edit | |
total | 32922.43 |