DEMO SITE v1.7.20

Field Grouping NEW Minimal 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: 119 (2 items)
1lk1 View Edit
2NG946941 View Edit
total2
Customernumber: 1212 (1 items)
3DB889831ww50218.95 View Edit
total50218.95
Customernumber: 121 (2 items)
4KI83135917876.32 View Edit
5MA30215134638.14 View Edit
total52514.46
Customernumber: 124 (5 items)
6AE215433101244.59 View Edit
7BG25540685410.87 View Edit
8CQ28796711044.3 View Edit
9ET6439683598.04 View Edit
10HI36647447142.7 View Edit
total328440.5
Add Export into CSV Print Search