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 
148 (3 items)
1148DD6352822611.84
2148KM172879105743
3148ME4979703516.04
total111870.88
151 (4 items)
4151BF68665858793.53
5151GB85221520314.44
6151IP56890658841.35
7151KI88457739964.63
total177913.95
157 (2 items)
8157HI61886135152.12
9157NN71198863357.13
total98509.25
161 (1 items)
10161BR3523842434.25
total2434.25
Search