$nbr_lignes = pmb_mysql_num_rows($res); $urlbase = "./admin.php?categ=opac&sub=stat§ion=view_list&act=final&id={$id}"; if ($force_exec) { $urlbase .= "&force_exec={$force_exec}"; } if ($nbr_lignes) { // récupération du résultat $row = pmb_mysql_fetch_row($res); $idp = $row[0]; $name = $row[1]; if (!$code) { $code = $row[2]; } $commentaire = $row[3]; //on remplace VUE par el nom de la table dynamique associée $num_vue = stat_query::get_vue_associee($id); $code = str_replace('VUE()', 'statopac_vue_' . $num_vue, $code); print "<br>\n\t\t<h3>" . htmlentities($msg["procs_execute"] . " " . $name, ENT_QUOTES, $charset) . "</h3>\n\t\t<br/>" . htmlentities($commentaire, ENT_QUOTES, $charset) . "<hr/>\n\t\t\t<input type='button' class='bouton' value='{$msg['62']}' onClick='document.location=\"./admin.php?categ=opac&sub=stat§ion=query&act=update_request&id_req={$id}\"' />"; if ($pmb_procs_force_execution && $force_exec || $PMBuserid == 1 && $force_exec) { print "<input type='button' id='procs_button_exec' class='bouton' value='" . htmlentities($msg["procs_force_exec"], ENT_QUOTES, $charset) . "' onClick='document.location=\"./admin.php?categ=opac&sub=stat§ion=view_list&act=exec_req&id_req={$id}&force_exec=1\"' />"; } else { print "<input type='button' id='procs_button_exec' class='bouton' value='{$msg['708']}' onClick='document.location=\"./admin.php?categ=opac&sub=stat§ion=view_list&act=exec_req&id_req={$id}\"' />"; } print "<br />"; $linetemp = explode(";", $code); for ($i = 0; $i < count($linetemp); $i++) { if (trim($linetemp[$i])) { $line[] = trim($linetemp[$i]); } } while (list($cle, $valeur) = each($line)) {
/** * Execution des différentes actions */ function proceed() { global $msg, $id_col, $col_name, $expr_col, $expr_filtre, $view_name, $view_comment, $id_view; global $id, $id_req, $move, $conso, $date_deb, $date_fin, $date_ech, $list_ck, $remove_data; if ($id) { $id_req = $id; } switch ($this->section) { case 'view_list': switch ($this->action) { case 'save_view': //Enregistrement/Insertion d'une vue $this->save_view($id_view, $view_name, $view_comment); print $this->do_form(); break; case 'suppr_view': //Suppression d'une vue $this->delete_view($id_view); print $this->do_form(); break; case 'consolide_view': if ($date_deb > $date_fin) { error_form_message($msg['stat_wrong_date_interval']); } elseif (!$list_ck) { error_form_message($msg['stat_no_view_selected']); } else { $consolidation = new consolidation($conso, $date_deb, $date_fin, $date_ech, $list_ck, $remove_data); $consolidation->make_consolidation(); } print $this->do_form(); break; case 'reinit': //Réinitialisation de la vue $this->reinitialiser_view($id_view); print $this->do_form(); break; //Actions liées aux requêtes //Actions liées aux requêtes case 'configure': case 'update_config': case 'update_request': case 'exec_req': case 'final': //Actions liées aux requêtes $stq = new stat_query($id_req, $this->action, $id_view); $stq->proceed(); break; case 'save_request': case 'suppr_request': $stq = new stat_query($id_req, $this->action, $id_view); $stq->proceed(); print $this->do_form(); break; default: print $this->do_form(); break; } break; case 'view_gestion': switch ($this->action) { case 'add_view': //ajout d'une vue //print $this->do_addview_form(); break; case 'update_view': //MaJ vue switch ($move) { case 'up': //Déplacer un élément dans la liste des colonnes $this->monter_element($id_col); break; case 'down': //Déplacer un élément dans la liste des colonnes $this->descendre_element($id_col); break; } break; case 'save_col': //Enregistrement/Insertion d'une colonne $this->save_col($id_col, $col_name, $expr_col, $expr_filtre, $id_view); break; case 'suppr_col': //Suppression d'une colonne $this->delete_col($id_col); break; } print $this->do_addview_form($id_view); break; case 'colonne': switch ($this->action) { case 'add_col': //ajout d'une colonne print $this->do_col_form(); break; case 'save_col': //Enregistrement/Insertion d'une colonne $this->save_col($id_col, $col_name, $expr_col, $expr_filtre, $id_view); print $this->do_addview_form($id_view); break; case 'update_col': //MaJ colonne print $this->do_col_form($id_col); break; case 'suppr_col': //Suppression d'une colonne $this->delete_col($id_col); print $this->do_addview_form($id_view); break; } break; case 'query': //Actions liées aux requêtes $stq = new stat_query($id_req, $this->action, $id_view); $stq->proceed(); break; case 'import': //Formulaire import de requete print $this->do_import_req_form($id_view); break; case 'importsuite': //Import de requete $this->do_import_req($id_view); break; default: break; } }