DEMO SITE v1.7.31

Column Grouping Default 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 Export into CSV Print
Search

#ChecknumberAmount
Actions
- Customernumber: 171 (1 items)
1GB878038hhh28 View Edit
total28
- Customernumber: 17277 (1 items)
283-2091___28 View Edit
total28
- Customernumber: 172 (1 items)
320-8589___28 View Edit
total28
- Customernumber: 173 (2 items)
4GP54569828 View Edit
5IG46239720355.24 View Edit
total20383.24
- Customernumber: 175 (2 items)
6IO44891324879.08 View Edit
7PI1521542044.77 View Edit
total66923.85
- Customernumber: 177 (2 items)
8AU75083715183.63 View Edit
9CI38143547177.59 View Edit
total62361.22
- Customernumber: 181 (1 items)
10CM56461222602.36 View Edit
total22602.36