$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;
}
}
