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 
121 (1 items)
1121MA30215334638.14
total34638.14
124 (8 items)
2124AE2154333101244.59
3124BG25540685410.87
4124CQ28796711044.322
5124ET6439683598.04
6124HI36647447142.7
7124KI131716111654.4
8124LF21729943369.3
9124NT14174845084.38
total528548.602
128 (1 items)
10128DI92511810549.01
total10549.01
Search