[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 | ||
---|---|---|---|---|---|---|---|---|
Tokyo (2 items) | ||||||||
1 | Patterson | Mary | fdasfasdfa | Tokyo | 10090 | VP Sales | ||
6 | Jennings | Leslie | x540 | ljennings@classicmodelcars.com | Tokyo | 1143 | Sales Rep 2 | |
London (2 items) | ||||||||
2 | Firrelli | Jeffrey | x9273 | gbondur@classicmodelcars.com | London | 1002 | VP Marketing | |
3 | Patterson | 123 | x4645 | wpatterson@classicmodelca.com | London | 1056 | Sales Manager (APAC) | |
NYC (1 items) | ||||||||
4 | Bondur | Gerard2 | x540 | gbondur@classicmodelcars.com | NYC | 1050 | Sale Manager (EMEA) | |
San Francisco 2 (2 items) | ||||||||
5 | Bow | Anthony8 | x5428 | abow@classicmodelcars.com | San Francisco 2 | 1056 | Sales Manager (NA) | |
7 | Thompson | Leslie | x4065 | lthompson@classicmodelcars.com | San Francisco 2 | 1143 | Sales Rep 3 | |
Boston (2 items) | ||||||||
8 | Firrelli | Julie | x2173 | jfirrelli@classicmodelcars.com | Boston | 1143 | Sales Rep | |
9 | Patterson | Steve | x4334 | spatterson@classicmodelcars.com | Boston | 1143 | Sales Rep | |
(1 items) | ||||||||
10 | Tseng | Foon Yue | o224 | ftseng@classicmodelcars.com | 1143 | Sales Rep |