relation grouping,summation of a column value, inline editing
HIDE CODE
SHOW 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
Employees - Single click cell to edit! Save by Enter only
#
Lastname
Firstname
Extension
Email
Officecode
Reportsto
Jobtitle
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16392
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
Warning: Undefined array key "employees.city" in /var/www/html/xcrud/demo/xcrud_1_7/xcrud/xcrud.php on line 16427
(2 items)roup-level="1" data-group-value="Paris" class="xcrud-row xcrud-grouping-row">
