[xcrud]
$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();
[/xcrud]
Employees – Single click cell to edit! Save by Enter only
# | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | ||
---|---|---|---|---|---|---|---|---|
London (1 items) | ||||||||
1 | Patterson | 123 | wpatterson@classicmodelca.com | London | 1056 | Sales Manager (APAC) | ||
NYC (2 items) | ||||||||
2 | Bondur | Gerard2 | x540 | gbondur@classicmodelcars.com | NYC | 1050 | Sale Manager (EMEA) | |
9 | Vanauf | George N | x4102 | gvanauf@classicmodelcars.com | NYC | 1143 | Sales Rep | |
San Francisco 2 (2 items) | ||||||||
3 | Bow | Anthony8 | x5428 | abow@classicmodelcars | San Francisco 2 | 1056 | Sales Manager (NA) | |
5 | Thompson | Leslie | x4065 | lthompson@classicmodelcars.com | San Francisco 2 | 1143 | Sales Rep 3 | |
Tokyo (1 items) | ||||||||
4 | Jennings | Leslie | x540 | ljennings@classicmodelcars.com | Tokyo | 1143 | Sales Rep 2 | |
Boston (2 items) | ||||||||
6 | Firrelli | Julie | x2173 | jfirrelli@classicmodelcars.com | Boston | 1143 | Sales Rep | |
7 | Patterson | Steve | x4334 | spatterson@classicmodelcars.com | Boston | 1143 | Sales Rep | |
(1 items) | ||||||||
8 | Tseng | Foon Yue | o224 | ftseng@classicmodelcars.com | 1143 | Sales Rep | ||
Paris (1 items) | ||||||||
10 | Bondur | Loui | x6493 | lbondur@classicmodelcars.com | Paris | 1102 | Sales Rep |