DEMO SITE v1.7.15

Relation Field Grouping NEW Bootstrap 4.5 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

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitle 
San Francisco (1 items)
1CastilloPamelafspcastilloclas@sodelcars.comSan Francisco1102Sales Rep1
Tokyo (3 items)
2BottLarryx2311lbott@classicmodelcars.comTokyo1102Sales Rep
7NishiMamix101mnishi@classicmodelcars.comTokyo1056Sales Rep
8KatoYoshimix102mgerard@classicmodelcars.comTokyo1621Sales Rep
RIO DE JANEIRO (1 items)
3JonesBarrysdfsdx102bjones@classicmodelcars.comRIO DE JANEIRO1105Sales Rep
Sydney (3 items)
4FixterAndyx101afixter@classicmodelcars.comSydney1088Sales Rep
5MarshPeterdsfdsx102pmarsh@classicmodelcars.comSydney1088Sales Rep
6KingTomx103tking@classicmodelcars.comSydney1088Sales Rep
Paris (1 items)
9GerardMartinx2312mgerard@classicmodelcars.comParis1102Sales Rep
(1 items)
10CIPOm@gmail.comVP Marketing
Search