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: 119 (2 items) | ||||
1 | lk | 1 | View Edit | |
2 | NG94694 | 1 | View Edit | |
total | 2 | |||
Customernumber: 1212 (1 items) | ||||
3 | DB889831ww | 50218.95 | View Edit | |
total | 50218.95 | |||
Customernumber: 121 (2 items) | ||||
4 | KI831359 | 17876.32 | View Edit | |
5 | MA302151 | 34638.14 | View Edit | |
total | 52514.46 | |||
Customernumber: 124 (5 items) | ||||
6 | AE215433 | 101244.59 | View Edit | |
7 | BG255406 | 85410.87 | View Edit | |
8 | CQ287967 | 11044.3 | View Edit | |
9 | ET64396 | 83598.04 | View Edit | |
10 | HI366474 | 47142.7 | View Edit | |
total | 328440.5 |