DEMO SITE v1.7.31

Column Grouping 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
Actions
- Customernumber: 157 (1 items)
161-8861___1235152.1 View Edit
total35152.1
- Customernumber: 161 (4 items)
2BR3523845500 View Edit
3BR47849450743.65 View Edit
4KG64412512692.19 View Edit
5NI90821438675.13 View Edit
total107610.97
- Customernumber: 167 (2 items)
6ED74361512538.01 View Edit
7GN22884685024.46 View Edit
total97562.47
- Customernumber: 171 (2 items)
8GB87803818997.89 View Edit
9IL10442542783.81 View Edit
total61781.7
- Customernumber: 172 (1 items)
10AD8320911960.8 View Edit
total1960.8