DEMO SITE v1.7.15

Field Grouping NEW Bootstrap 4.5 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->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

#CustomernumberChecknumberAmount 
177344 (1 items)
1177344CI3814353347177.59333
total47177.59333
175 (1 items)
2175CITI343434428500.78
total28500.78
209 (1 items)
3209BOAF8204435157.75
total35157.75
181 (1 items)
4181GQ1321445494.78
total5494.78
186 (2 items)
5186AE19228723602.9
6186KA60240734341.08
total57943.98
187 (3 items)
7187AM96879752825.29
8187BQ3906247159.11
9187KL12472648425.69
total148410.09
189 (1 items)
10189BO71161817359.53
total17359.53
Search