static function route($action, &$object)
{
$PDOdb = new TPDOdb();
$sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code='" . $action . "'";
$Tab = $PDOdb->ExecuteAsArray($sql);
foreach ($Tab as $row) {
$route = new TRouting();
$route->load($PDOdb, $row->rowid);
$route->routeLines($object);
}
// mvt inverse pour annulation
$sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code_reverse='" . $action . "'";
$Tab = $PDOdb->ExecuteAsArray($sql);
foreach ($Tab as $row) {
$route = new TRouting();
$route->load($PDOdb, $row->rowid);
$route->routeLines($object, -1);
}
}
if (!empty($_REQUEST['TRouting'])) {
foreach ($_REQUEST['TRouting'] as $id_rem => &$rem) {
$r = new TRouting();
$r->load($PDOdb, $id_rem);
$r->set_values($rem);
$r->check_old = !empty($rem['check_old']) ? 1 : 0;
$r->fk_societe = GETPOST('TRouting_' . $r->getId() . '_fk_soc');
$r->fk_user = GETPOST('TRouting_' . $r->getId() . '_fk_user');
$r->save($PDOdb);
}
setEventMessage('Saved');
}
} else {
if ($action == 'delete') {
$r = new TRouting();
$r->load($PDOdb, GETPOST('id'));
$r->delete($PDOdb);
} else {
if ($action == 'add') {
$r = new TRouting();
$r->save($PDOdb);
}
}
}
/*
* View
*/
$page_name = "RoutingSetup";
llxHeader('', $langs->trans($page_name));
// Subheader
$linkback = '<a href="' . DOL_URL_ROOT . '/admin/modules.php">' . $langs->trans("BackToModuleList") . '</a>';
