DEMO SITE v1.7.31

Grouping Level 2NEW
1.7.29
Bootstrap 4.5 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

Add
#ChecknumberAmount
Actions
+ Customernumber: 158 (1 items)
+ Amount: 7 (1 items)
112-123456_7 View Edit
+ Customernumber: 161 (4 items)
+ Amount: 7 (2 items)
2BR35238477 View Edit
3BR4784947 View Edit
+ Amount: 12692.1955 (2 items)
4KG64412512692.1955 View Edit
5NI90821412692.1955 View Edit
+ Customernumber: 167 (1 items)
+ Amount: 12692.1955 (1 items)
6GN22884612692.1955 View Edit
+ Customernumber: 171 (2 items)
+ Amount: 18997.89 (1 items)
7GB87803818997.89 View Edit
+ Amount: 42783.81 (1 items)
8IL10442542783.81 View Edit
+ Customernumber: 172 (2 items)
+ Amount: 1960.8 (1 items)
983-2091___1960.8 View Edit
+ Amount: 51209.58 (1 items)
10CE5175151209.58 View Edit
showing_records 1 to 10 of 635
Search