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: 14133454 (1 items)
1HJ32686100 View Edit
total100
Customernumber: 141 (9 items)
2ID1096220 View Edit
3IN44625820 View Edit
4JE1054771200 View Edit
5JN3552801200 View Edit
6JN722010100.11 View Edit
7KT5257863843.55 View Edit
8MC4694635420.74 View Edit
9MF62960220009.53 View Edit
10NU62770626155 View Edit
total147968.93
Search