DEMO SITE v1.7.31

Column Grouping Bootstrap 5 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
#ChecknumberAmount
Actions
- Customernumber: 151 (3 items)
1BF6866582.3456789034567896e97 View Edit
2GB85221520314.44 View Edit
3KI88457739964.63 View Edit
total2.3456789034568E+97
- Customernumber: 157 (1 items)
4HI61886135152.12 View Edit
total35152.12
- Customernumber: 161 (4 items)
5BR3523845500 View Edit
6BR47849450743.65 View Edit
7KG64412512692.19 View Edit
8NI90821438675.13 View Edit
total107610.97
- Customernumber: 166 (2 items)
9BQ32761338785.48 View Edit
10DC97930744160.92 View Edit
total82946.4
showing_records 1 to 10 of 595
Search