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>';