Column Grouping

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
Actions
Customernumber: 10364 (1 items)
1OM314963 View Edit
total3
Customernumber: 103600 (1 items)
2OM314913 View Edit
total3
Customernumber: 11310 (1 items)
3HQ550240000 View Edit
total40000
Customernumber: 112 (1 items)
4HQ5502240000 View Edit
total40000
Customernumber: 113 (1 items)
5GG3145545870 View Edit
total45870
Customernumber: 114 (3 items)
6MA7655282261 View Edit
7NP603857565 View Edit
8NR2755244894 View Edit
total134720
Customernumber: 119 (2 items)
9DB93370419501.82 View Edit
10LN37344747924.19 View Edit
total67426.01
Search