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 
124 (1 items)
1124HR8657855639.66
total55639.66
128 (3 items)
2128FA46548224101.81
3128FH66823033820.62
4128IP3839017466.32
total65388.75
129 (3 items)
5129DM82614026248
6129ID44959323923.93
7129PI4299116537.85
total66709.78
131 (3 items)
8131CL44270522292.62
9131MA72456250025.35
10131NB44513535321.97
total107639.94
Search