Field Grouping

[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 Email 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

Search