DEMO SITE v1.7.20

Field Grouping NEW Default 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

Add Export into CSV Print
Search
#ChecknumberAmount 
Customernumber: 209 (1 items)
1PH78593736069.26 View Edit
total36069.26
Customernumber: 211 (1 items)
2BJ53523045480.79 View Edit
total45480.79
Customernumber: 216 (1 items)
3MM34208640473.86 View Edit
total40473.86
Customernumber: 219 (2 items)
4BN178703452.75 View Edit
5BR9414804465.85 View Edit
total7918.6
Customernumber: 227 (2 items)
6MQ41396836164.46 View Edit
7NU2132653745.34 View Edit
total89909.8
Customernumber: 233 (1 items)
8II18000622997.45 View Edit
total22997.45
Customernumber: 239 (1 items)
9NQ86554780375.24 View Edit
total80375.24
Customernumber: 240 (1 items)
10IF24515746788.14 View Edit
total46788.14