Relation Field Grouping Default theme
relation grouping,summation of a column value, inline editing
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table('employees');
$xcrud->table_name('Employees - Single click cell to edit! Save by Enter only');
$xcrud->validation_required('lastName',2)->validation_required('firstName',2)->validation_required('jobTitle');
$xcrud->validation_required('email');
$xcrud->validation_pattern('email','email')->validation_pattern('extension','alpha_numeric')->validation_pattern('officeCode','natural');
$xcrud->relation('officeCode','offices','officeCode','city');
$xcrud->limit(10);
$xcrud->group_by_columns(array('officeCode','city'));
//$xcrud->group_sum_columns('officeCode');
$xcrud->fields_inline('lastName,firstName,extension,email,officeCode,reportsTo,jobTitle');//set the fields to allow inline editing
$xcrud->inline_edit_save('enter_only');// Can be 'enter_only' or 'button_only' or 'enter_button_only'
$xcrud->set_logging(true);
echo $xcrud->render();
?>
Employees - Single click cell to edit! Save by Enter only
Add Export into CSV Print Search
| # | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | - Officecode: Paris (2 items) | |
|---|---|---|---|---|---|---|---|---|
| 1 | Firrelli | Jeff | x9273 | jeff.firrelli@myoffice.com | Paris | 1002 | VP Marketing | View Edit Remove |
| 3 | Bondur | Gerard | x5408 | gbondur@classicmodelcars.com | Paris | 1056 | Sale Manager (EMEA) | View Edit Remove |
| - Officecode: Boston (3 items) | ||||||||
| 2 | Patterson | William | x48711 | wpatterson@classicmodelcars.com | Boston | 1056 | Sales Manager (APAC) | View Edit Remove |
| 7 | Firrelli | Julie | x2173 | jfirrelli@classicmodelcars.com | Boston | 1143 | Sales Rep | View Edit Remove |
| 8 | Patterson | Steve | x4334 | spatterson@classicmodelcars.com | Boston | 1143 | Sales Rep | View Edit Remove |
| - Officecode: San Francisco (3 items) | ||||||||
| 4 | Bow | Anthony | x5428 | abow@classicmodelcars.com | San Francisco | 1056 | Sales Manager (NA) | View Edit Remove |
| 5 | Jennings | Leslie | x3291 | ljennings@classicmodelcars.com | San Francisco | 1143 | Sales Rep | View Edit Remove |
| 6 | Thompson | Leslie | x4065 | lthompson@classicmodelcars.com | San Francisco | 1143 | Sales Rep | View Edit Remove |
| - Officecode: NYC (2 items) | ||||||||
| 9 | Tsengchu | Foon Yue | o224 | ftseng@classicmodelcars.com | NYC | 1143 | Sales Rep | View Edit Remove |
| 10 | Vanauf | George | x4102 | gvanauf@classicmodelcars.com | NYC | 1143 | Sales Rep | View Edit Remove |
?>
