Relation Field Grouping NEW 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('officeCode'); //$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 | ||
---|---|---|---|---|---|---|---|---|
(8 items) | ||||||||
1 | dak | rgdfLoui | x6493 | csadasd@asdsa.com | 1102 | Sales Rep | ||
2 | bootstrapCastillo123 | Pamelas | 2759 | pcastillo@classicmodelcars.com | 1102 | Sales Rept | ||
3 | Bottledump | Larry54 | x2311 | 1102 | Sales Rep | |||
4 | Jones | Barry | x102 | bjones@classicmodelcars.com | 1102 | Sales Rep | ||
5 | Fixter123 | Andy | x101 | afixter@classicmodelcars.com | 1088 | Sales Rep | ||
6 | King | Tom6 | x103 | tking@classicmodelcars.com | 1088 | Sales Rep | ||
9 | Gerard | Martin | x2312 | mgerard@classicmodelcars.com | 1102 | Sales Rep | ||
10 | Chieni | Patrick | pchieni@gmail.com | VP Marketing | ||||
Tokyo (2 items) | ||||||||
7 | Nishi | Mami | x101 | mnishi@classicmodelcars.com | Tokyo | 1056 | Sales Rep | |
8 | Kato | Yoshimi | x102 | ykato@classicmodelcars.com | Tokyo | 1621 | Doctor |