DEMO SITE v1.7.24

Column Grouping 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->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 
Customernumber: 124 (7 items)
1AE215433101244.59 View Edit
2BG25540685410.87 View Edit
3ET6439683598.04 View Edit
4HI36647447142.7 View Edit
5HR8657855639.66 View Edit
7LF21729943369.3 View Edit
8NT14174845084.38 View Edit
total461489.54
Customernumber: 12496 (1 items)
6KI131716111654.4 View Edit
total111654.4
Customernumber: 128 (2 items)
9DI92511810549.01 View Edit
10FA46548224101.81 View Edit
total34650.82
Search