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: 17277 (1 items)
+ Amount: 28 (1 items)
183-2091___28 View Edit
+ Customernumber: 172 (1 items)
+ Amount: 28 (1 items)
220-8589___28 View Edit
+ Customernumber: 173 (2 items)
+ Amount: 28 (1 items)
3GP54569828 View Edit
+ Amount: 20355.24 (1 items)
4IG46239720355.24 View Edit
+ Customernumber: 175 (3 items)
+ Amount: 24879.08 (1 items)
5IO44891324879.08 View Edit
+ Amount: 42044.77 (1 items)
6PI1521542044.77 View Edit
+ Amount: 28500.78 (1 items)
10CITI343434428500.78 View Edit
+ Customernumber: 177 (2 items)
+ Amount: 15183.63 (1 items)
7AU75083715183.63 View Edit
+ Amount: 47177.59 (1 items)
8CI38143547177.59 View Edit
+ Customernumber: 181 (1 items)
+ Amount: 22602.36 (1 items)
9CM56461222602.36 View Edit
showing_records 1 to 10 of 717
Search