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: 163 (1 items)
1KG6441258 View Edit
total58
- Customernumber: 161 (1 items)
2NI90821428 View Edit
total28
- Customernumber: 167 (1 items)
3GN228846128 View Edit
total28
- Customernumber: 171 (2 items)
4GB878038hhh28 View Edit
5IL10442528 View Edit
total56
- Customernumber: 17277 (1 items)
683-2091___28 View Edit
total28
- Customernumber: 172 (1 items)
7EH20858928 View Edit
total28
- Customernumber: 173 (2 items)
8GP54569828 View Edit
9IG46239720355.24 View Edit
total20383.24
- Customernumber: 175 (1 items)
10IO44891324879.08 View Edit
total24879.08
Add Export into CSV Print Search