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 
161 (1 items)
1161Test230
total230
5454161 (1 items)
25454161hNI90821438675.13
total38675.13
166444 (1 items)
3166444BQ327613dfgdfg38785.48
total38785.48
166 (1 items)
4166LA31862922474.17
total22474.17
167 (2 items)
5167ED74361512538.01
6167GN22884685024.46
total97562.47
171 (2 items)
7171GB87803818997.89
8171IL10442542783.81
total61781.7
177 (1 items)
9177AD8320911960.8
total1960.8
173 (1 items)
10173IG46239720355.24
total20355.24
Add Export into CSV Print
Search