DEMO SITE v1.7.20

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->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: 141144146 (1 items)
1IN44625866071.55 View Edit
total66071.55
Customernumber: 141 (5 items)
2JE105477PAUL120166.58 View Edit
3JN35528049539.37 View Edit
4JN72201040206.2 View Edit
5MF62960220009.53 View Edit
6NU62770626155.91 View Edit
total256077.59
Customernumber: 144 (2 items)
7IR84630336005.71 View Edit
8LA6856787674.94 View Edit
total43680.65
Customernumber: 145 (2 items)
9CN3285454710.73 View Edit
10ED39322MARK28211.7 View Edit
total32922.43
Search