Column Grouping 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
Add Export into CSV Print Search
# | Checknumber | Amount | |
---|---|---|---|
- Customernumber: 141 (7 items) | |||
1 | lDL4606180 | 490 | View Edit |
2 | 32-686 | 160 | View Edit |
3 | ID10962 | 1608 | View Edit |
4 | JN355280 | 1608 | View Edit |
5 | JN722010 | 1608 | View Edit |
6 | KT52578 | 63843.55 | View Edit |
7 | MC46946 | 35420.74 | View Edit |
total | 104738.29 | ||
- Customernumber: 144 (1 items) | |||
8 | LA685678 | 7674.94 | View Edit |
total | 7674.94 | ||
- Customernumber: 145 (2 items) | |||
9 | CN328545 | 4710.73 | View Edit |
10 | ED39322 | 28211.7 | View Edit |
total | 32922.43 |
?>