Column Grouping Tailwind CSS 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: 1 (1 items) | |||
| 1 | BO86400 | 123457 | View Edit |
| total | 123457 | ||
| - Customernumber: 10364 (1 items) | |||
| 2 | OM3149 | 605002 | View Edit |
| total | 605002 | ||
| - Customernumber: 103600 (1 items) | |||
| 3 | OM31491 | 605000 | View Edit |
| total | 605000 | ||
| - Customernumber: 11310 (1 items) | |||
| 4 | HQ5502 | 14190 | View Edit |
| total | 14190 | ||
| - Customernumber: 11221 (1 items) | |||
| 5 | HQ55023 | 99 | View Edit |
| total | 99 | ||
| - Customernumber: 112 (1 items) | |||
| 6 | HQ55022 | 99 | View Edit |
| total | 99 | ||
| - Customernumber: 113 (1 items) | |||
| 7 | GG31455 | 45870 | View Edit |
| total | 45870 | ||
| - Customernumber: 114 (3 items) | |||
| 8 | MA76552 | 82261 | View Edit |
| 9 | NP60385 | 7565 | View Edit |
| 10 | NR27552 | 44894 | View Edit |
| total | 134720 | ||