DEMO SITE v1.7.26

Column Grouping Bootstrap 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->column_hide('customerNumber');
	$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

#ChecknumberAmount
Actions
Customernumber: 103 (3 items)
1HQ3363366074 View Edit
2JM5552056074 View Edit
3OM3149336074 View Edit
total18222
Customernumber: 112 (3 items)
486-48232456074 View Edit
555-022545432641.98 View Edit
6ND74857933347.88 View Edit
total72063.86
Customernumber: 114 (4 items)
7GG3145545864.03 View Edit
8MA76551582261.22 View Edit
9NP6038407565.08 View Edit
10NR2755244894.25 View Edit
total180584.58
Search Execution time: 0.006 sMemory usage: 0.18 MB