search_class=new search(false);
if ($id) {
// on cherche à atteindre une notice existante
$this->id_equation = $id;
$this->getData();
} else {
// la notice n'existe pas
$this->id_equation = 0;
$this->getData();
}
}
// ---------------------------------------------------------------
// getData() : récupération infos
// ---------------------------------------------------------------
function getData() {
global $dbh;
global $msg;
if (!$this->id_equation) {
// pas d'identifiant. on retourne un tableau vide
$this->id_equation=0;
$this->num_classement = 1 ;
$this->nom_equation="";
$this->comment_equation="";
$this->requete="";
$this->proprio_equation=0;
$this->human_query = "" ;
} else {
$requete = "SELECT id_equation, num_classement, nom_equation,comment_equation,requete, proprio_equation FROM equations WHERE id_equation='".$this->id_equation."' " ;
$result = pmb_mysql_query($requete, $dbh) or die ($requete."
in equation.class.php : ".pmb_mysql_error());
if(pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->id_equation = $temp->id_equation ;
$this->num_classement = $temp->num_classement ;
$this->nom_equation = $temp->nom_equation ;
$this->comment_equation = $temp->comment_equation ;
$this->requete = $temp->requete ;
$this->proprio_equation = $temp->proprio_equation ;
$this->human_query = $this->search_class->make_serialized_human_query($this->requete) ;
} else {
// pas de bannette avec cette clé
$this->id_equation=0;
$this->num_classement = 1 ;
$this->nom_equation="";
$this->comment_equation="";
$this->requete="";
$this->proprio_equation=0;
$this->human_query = "" ;
}
}
}
// ---------------------------------------------------------------
// show_form : affichage du formulaire de saisie
// ---------------------------------------------------------------
function show_form() {
global $msg, $charset;
global $dsi_equation_form;
if($this->id_equation) {
$action = "./dsi.php?categ=equations&sub=$type&id_equation=$this->id_equation&suite=update";
$button_delete = "";
$libelle = $msg['dsi_equ_form_modif'];
$button_modif_requete = "id_equation.submit();\">";
$form_modif_requete = $this->make_hidden_search_form();
} else {
$action = "./dsi.php?categ=equations&sub=$type&id_equation=0&suite=update";
$libelle = $msg['dsi_equ_form_creat'];
$button_delete ='';
$button_modif_requete = "";
$form_modif_requete = "";
}
$dsi_equation_form = str_replace('!!libelle!!', $libelle, $dsi_equation_form);
$dsi_equation_form = str_replace('!!id_equation!!', $this->id_equation, $dsi_equation_form);
$dsi_equation_form = str_replace('!!action!!', $action, $dsi_equation_form);
$dsi_equation_form = str_replace('!!nom_equation!!', htmlentities($this->nom_equation,ENT_QUOTES, $charset), $dsi_equation_form);
$dsi_equation_form = str_replace('!!num_classement!!', show_classement_utilise ('EQU', $this->num_classement, 0), $dsi_equation_form);
$dsi_equation_form = str_replace('!!comment_equation!!', htmlentities($this->comment_equation,ENT_QUOTES, $charset), $dsi_equation_form);
$dsi_equation_form = str_replace('!!requete!!', htmlentities($this->requete,ENT_QUOTES, $charset), $dsi_equation_form);
$dsi_equation_form = str_replace('!!requete_human!!', $this->search_class->make_serialized_human_query($this->requete), $dsi_equation_form);
if ($this->proprio_equation==0)
$dsi_equation_form = str_replace('!!proprio_equation!!', htmlentities($msg['dsi_equ_no_proprio'],ENT_QUOTES, $charset), $dsi_equation_form);
else
$dsi_equation_form = str_replace('!!proprio_equation!!', "Choix de proprio à faire", $dsi_equation_form);
$dsi_equation_form = str_replace('!!delete!!', $button_delete, $dsi_equation_form);
$dsi_equation_form = str_replace('!!bouton_modif_requete!!', $button_modif_requete, $dsi_equation_form);
$dsi_equation_form = str_replace('!!form_modif_requete!!', $form_modif_requete, $dsi_equation_form);
return $dsi_equation_form;
}
// ---------------------------------------------------------------
// delete() : suppression
// ---------------------------------------------------------------
function delete() {
global $dbh;
global $msg;
if (!$this->id_equation)
// impossible d'accéder à cette équation
return $msg[409];
$requete = "delete from bannette_equation WHERE num_equation='$this->id_equation'";
$res = pmb_mysql_query($requete, $dbh);
$requete = "delete from equations WHERE id_equation='$this->id_equation'";
$res = pmb_mysql_query($requete, $dbh);
$query = pmb_mysql_query("DELETE bannettes FROM bannettes LEFT JOIN empr ON proprio_bannette = id_empr WHERE id_empr IS NULL AND proprio_bannette !=0");
$query = pmb_mysql_query("DELETE equations FROM equations LEFT JOIN empr ON proprio_equation = id_empr WHERE id_empr IS NULL AND proprio_equation !=0 ");
$query = pmb_mysql_query("DELETE bannette_equation FROM bannette_equation LEFT JOIN bannettes ON num_bannette = id_bannette WHERE id_bannette IS NULL ");
$query = pmb_mysql_query("DELETE bannette_equation FROM bannette_equation LEFT JOIN equations on num_equation=id_equation WHERE id_equation is null");
$query = pmb_mysql_query("DELETE bannette_abon FROM bannette_abon LEFT JOIN empr on num_empr=id_empr WHERE id_empr is null");
$query = pmb_mysql_query("DELETE bannette_abon FROM bannette_abon LEFT JOIN bannettes ON num_bannette=id_bannette WHERE id_bannette IS NULL ");
}
// ---------------------------------------------------------------
// update
// ---------------------------------------------------------------
function update($temp) {
global $dbh;
global $msg;
if ($this->id_equation) {
// update
$req = "UPDATE equations set ";
$clause = " WHERE id_equation='".$this->id_equation."'";
} else {
$req = "insert into equations set ";
$clause = "";
}
$req.="num_classement='$temp->num_classement',";
$req.="nom_equation='".trim($temp->nom_equation)."',";
$req.="comment_equation='".trim($temp->comment_equation)."',";
$req.="requete='$temp->requete',";
$req.="proprio_equation='$temp->proprio_equation'";
$req.=$clause ;
$res = pmb_mysql_query($req, $dbh);
if (!$this->id_equation) $this->id_equation = pmb_mysql_insert_id() ;
}
// pour maj de requete d'équation
function make_hidden_search_form($url="", $priv_pro="PUB", $id_empr=0) {
global $search;
global $charset;
global $page;
$url = "./catalog.php?categ=search&mode=6" ;
// remplir $search
$this->search_class->unserialize_search($this->requete);
$r="";
return $r;
}
} # fin de définition de la classe equation