Relation Field Grouping Semantic UI 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
# | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | ||
---|---|---|---|---|---|---|---|---|
Officecode: Sydney (1 items) | ||||||||
1 | Bonduraaaaaaa | Gerard2 | x540 | gbondur@classicmodelcars.com | Sydney | 1050 | Sale Manager (EMEA) | View Edit Remove |
Officecode: San Francisco (2 items) | ||||||||
2 | Bow | Anthony8 | x5428 | abow@classicmodelcars.com | San Francisco | 1056 | Sales Manager (NA) | View Edit Remove |
4 | Thompson | Leslie | x4065 | lthompson@classicmodelcars.com | San Francisco | 1143 | Sales Rep 3 | View Edit Remove |
Officecode: Tokyo (1 items) | ||||||||
3 | Jennings | Leslie | x540 | ljennings@classicmodelcars.com | Tokyo | 1143 | Sales Rep 20 | View Edit Remove |
Officecode: Boston (2 items) | ||||||||
5 | Firrelli | Julie | x2173 | jfirrelli@classicmodelcars.com | Boston | 1143 | Sales Rep | View Edit Remove |
6 | Patterson | Steve | x4334 | spatterson@classicmodelcars.com | Boston | 1143 | Sales Rep | View Edit Remove |
Officecode: (1 items) | ||||||||
7 | Tseng | Foon Yue | o224 | ftseng@classicmodelcars.com | 1143 | Sales Rep | View Edit Remove | |
Officecode: NYC (1 items) | ||||||||
8 | Vanauf | George N | x4102 | gvanauf@classicmodelcars.com | NYC | 1143 | Sales Rep | View Edit Remove |
Officecode: Paris (2 items) | ||||||||
9 | Bondur | Loui | x6493 | lbondur@classicmodelcars.com | Paris | 1102 | Sales Rep | View Edit Remove |
10 | Hernandez | Gerard | x2028 | ghernande@classicmodelcars.com | Paris | 1102 | Sales Rep | View Edit Remove |