'
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 
114 (2 items)
1114NR2755244894.25
2114teste 319501.82
total64396.07
121 (3 items)
3121FD3177901491.38
4121KI83135917876.32
5121MA30215134638.14
total54005.84
124 (5 items)
6124BG25540685410.87
7124CQ28796711044.3
8124ET6439683598.04
9124HI36647447142.7
10124HR8657855639.66
total282835.57
Search