DEMO SITE v1.7.15

Field Grouping NEW Minimal 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 
1312 (1 items)
11312MA72456212xxxxx50025.35
total50025.35
131 (1 items)
2131NB44513535321.97
total35321.97
141 (8 items)
3141DB58321636140.38
4141DL46061846895.48
5141HJ32686dd59830.55
6141ID10962116208.4
7141IN44625865071.26
8141JE105477120166.58
9141JN35528049539.37
10141aaaa40206.2
total534058.22
Add Export into CSV Print Search