Column Grouping Bootstrap 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: 129 (1 items) | |||
1 | ID449593 | 200 | View Edit |
total | 200 | ||
- Customernumber: 131 (3 items) | |||
2 | CL442705 | 200 | View Edit |
3 | MA724562 | 160 | View Edit |
4 | NB445135 | 160 | View Edit |
total | 520 | ||
- Customernumber: 141 (6 items) | |||
5 | AU364101 | 160 | View Edit |
6 | DB583216 | 160 | View Edit |
7 | DL460618 | 160 | View Edit |
8 | HJ32686 | 160 | View Edit |
9 | ID10962 | 160 | View Edit |
10 | IN446258 | 65071.26 | View Edit |
total | 65871.26 |