DEMO SITE v1.7.31

Column Grouping 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: 162 (1 items)
112-3456___8 View Edit
total8
- Customernumber: 161 (3 items)
2BR4784948 View Edit
3KG64412512692.1955 View Edit
4NI90821412692.1955 View Edit
total25392.391
- Customernumber: 167 (1 items)
5GN22884612692.1955 View Edit
total12692.1955
- Customernumber: 171 (2 items)
6GB87803818997.89 View Edit
7IL10442542783.81 View Edit
total61781.7
- Customernumber: 172 (2 items)
883-2091___1960.8 View Edit
9EH20858933383.14 View Edit
total35343.94
- Customernumber: 173 (1 items)
10GP54569811843.45 View Edit
total11843.45
Add Export into CSV Print Search