DEMO SITE v1.7.15

Field Grouping NEW 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->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 
0 (1 items)
100
total0
14522 (1 items)
214522HR18268820564.86
total20564.86
146 (3 items)
3146FP54981740978.9
4146FU7934108949614.9
5146LJ16063539712.1
total130305.9
148 (2 items)
6148BI50703044000
8148ME4979703516.04
total47516.04
1489 (1 items)
71489DD6352822611.84
total2611.84
151 (2 items)
9151BF68665858793.53
10151GB85221520314.44
total79107.97
Add Export into CSV Print
Search