DEMO SITE v1.7.32

Grouping Level 2NEW
1.7.29
Material Design theme

Grouping Rows to the second level

HIDE CODE
<?php
    $xcrud = Xcrud::get_instance();	
	$xcrud->table('payments');
	$xcrud->unset_remove();
	$xcrud->column_hide('customerNumber');
	$xcrud->group_table_collapsed(true);
	$xcrud->group_by_columns('customerNumber,amount');//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: 1 (1 items)
+ Amount: 123457 (1 items)
1BO86400123457 View Edit
+ Customernumber: 10364 (1 items)
+ Amount: 605002 (1 items)
2OM3149605002 View Edit
+ Customernumber: 103600 (1 items)
+ Amount: 605000 (1 items)
3OM31491605000 View Edit
+ Customernumber: 11310 (1 items)
+ Amount: 14190 (1 items)
4HQ550214190 View Edit
+ Customernumber: 11221 (1 items)
+ Amount: 99 (1 items)
5HQ5502399 View Edit
+ Customernumber: 112 (1 items)
+ Amount: 99 (1 items)
6HQ5502299 View Edit
+ Customernumber: 113 (1 items)
+ Amount: 45870 (1 items)
7GG3145545870 View Edit
+ Customernumber: 114 (3 items)
+ Amount: 82261 (1 items)
8MA7655282261 View Edit
+ Amount: 7565 (1 items)
9NP603857565 View Edit
+ Amount: 44894 (1 items)
10NR2755244894 View Edit
Search