Field Grouping NEW 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: 209 (1 items) | ||||
1 | PH785937 | 36069.26 | View Edit | |
total | 36069.26 | |||
Customernumber: 211 (1 items) | ||||
2 | BJ535230 | 45480.79 | View Edit | |
total | 45480.79 | |||
Customernumber: 216 (1 items) | ||||
3 | MM342086 | 40473.86 | View Edit | |
total | 40473.86 | |||
Customernumber: 219 (2 items) | ||||
4 | BN17870 | 3452.75 | View Edit | |
5 | BR941480 | 4465.85 | View Edit | |
total | 7918.6 | |||
Customernumber: 227 (2 items) | ||||
6 | MQ413968 | 36164.46 | View Edit | |
7 | NU21326 | 53745.34 | View Edit | |
total | 89909.8 | |||
Customernumber: 233 (1 items) | ||||
8 | II180006 | 22997.45 | View Edit | |
total | 22997.45 | |||
Customernumber: 239 (1 items) | ||||
9 | NQ865547 | 80375.24 | View Edit | |
total | 80375.24 | |||
Customernumber: 240 (1 items) | ||||
10 | IF245157 | 46788.14 | View Edit | |
total | 46788.14 |