Column Grouping Semantic UI 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: 103 (3 items) | ||||
| 1 | HQ336336 | 6074 | View Edit | |
| 2 | JM555205 | 6074 | View Edit | |
| 3 | OM314933 | 6074 | View Edit | |
| total | 18222 | |||
| Customernumber: 112 (3 items) | ||||
| 4 | 86-4823245 | 6074 | View Edit | |
| 5 | 55-0225454 | 32641.98 | View Edit | |
| 6 | ND748579 | 33347.88 | View Edit | |
| total | 72063.86 | |||
| Customernumber: 114 (4 items) | ||||
| 7 | GG31455 | 45864.03 | View Edit | |
| 8 | MA765515 | 82261.22 | View Edit | |
| 9 | NP603840 | 7565.08 | View Edit | |
| 10 | NR27552 | 44894.25 | View Edit | |
| total | 180584.58 | |||