Relation Field Grouping

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

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitle
Actions
Officecode: London (2 items)
1Firrelli2Jox9273asdjo.firrelli2@myoffice.comLondon1002VP Marketing View Edit Remove
2Patterson123x4645wpatterson@classicmodelca.comLondon1056Sales Manager (APAC) View Edit Remove
Officecode: NYC (2 items)
3BondurGerard2x540gbondur@classicmodelcars.comNYC1050Sale Manager (EMEA) View Edit Remove
10VanaufGeorge Nx4102gvanauf@classicmodelcars.comNYC1143Sales Rep View Edit Remove
Officecode: San Francisco (2 items)
4BowAnthony8x5428abow@classicmodelcars.comSan Francisco1056Sales Manager (NA) View Edit Remove
6ThompsonLesliex4065lthompson@classicmodelcars.comSan Francisco1143Sales Rep 3 View Edit Remove
Officecode: Tokyo (1 items)
5JenningsLesliex540ljennings@classicmodelcars.comTokyo1143Sales Rep 2 View Edit Remove
Officecode: Boston (2 items)
7FirrelliJuliex2173jfirrelli@classicmodelcars.comBoston1143Sales Rep View Edit Remove
8PattersonStevex4334spatterson@classicmodelcars.comBoston1143Sales Rep View Edit Remove
Officecode: (1 items)
9TsengFoon Yueo224ftseng@classicmodelcars.com1143Sales Rep View Edit Remove
Search