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: 141 (1 items) | |||
1 | MC46946 | 63843.54 | View Edit |
total | 63843.54 | ||
- Customernumber: 144 (1 items) | |||
2 | LA685678 | 63843.55 | View Edit |
total | 63843.55 | ||
- Customernumber: 145 (2 items) | |||
3 | CN328545 | 4710.73 | View Edit |
4 | HR182688 | 20564.86 | View Edit |
total | 25275.59 | ||
- Customernumber: 146 (2 items) | |||
5 | FP549817 | 40978.53 | View Edit |
6 | FU793410 | 49614.72 | View Edit |
total | 90593.25 | ||
- Customernumber: 298 (1 items) | |||
7 | LJ160635 | 30000 | View Edit |
total | 30000 | ||
- Customernumber: 148 (3 items) | |||
8 | BI507030 | 44380.15 | View Edit |
9 | DD635282 | 2611.84 | View Edit |
10 | KM172879 | 105743 | View Edit |
total | 152734.99 |