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
// ---------------------------------------------------------------
public function getData() {
global $msg;
$this->num_classement = 1 ;
$this->nom_equation="";
$this->comment_equation="";
$this->requete="";
$this->proprio_equation=0;
$this->human_query = "" ;
if ($this->id_equation) {
$query = "SELECT num_classement, nom_equation,comment_equation,requete, proprio_equation FROM equations WHERE id_equation='".$this->id_equation."' " ;
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$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) ;
}
}
}
// ---------------------------------------------------------------
// show_form : affichage du formulaire de saisie
// ---------------------------------------------------------------
public function show_form() {
global $msg, $charset;
global $dsi_equation_form;
if($this->id_equation) {
$action = "./dsi.php?categ=equations&sub=gestion&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=gestion&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;
}
public function set_properties_from_form() {
global $num_classement;
global $equ_human;
global $nom_bannette;
global $equation;
global $id_empr;
global $empr_nom, $empr_prenom;
$this->num_classement = $num_classement+0;
$this->nom_equation = trim(stripslashes($equ_human));
$this->comment_equation = $empr_nom." ".$empr_prenom.' -> '.trim(stripslashes($nom_bannette));
$this->requete = stripslashes($equation);
$this->proprio_equation = $id_empr+0;
}
// ---------------------------------------------------------------
// save
// ---------------------------------------------------------------
public function save() {
global $msg;
if ($this->id_equation) {
// update
$query = "UPDATE equations set ";
$clause = " WHERE id_equation='".$this->id_equation."'";
} else {
$query = "insert into equations set ";
$clause = "";
}
$query.="num_classement='$this->num_classement',";
$query.="nom_equation='".addslashes($this->nom_equation)."',";
$query.="comment_equation='".addslashes($this->comment_equation)."',";
$query.="requete='".addslashes($this->requete)."',";
$query.="proprio_equation='".$this->proprio_equation."'";
$query.=$clause ;
pmb_mysql_query($query);
if (!$this->id_equation) $this->id_equation = pmb_mysql_insert_id() ;
}
// ---------------------------------------------------------------
// delete() : suppression
// ---------------------------------------------------------------
public function delete() {
global $msg;
if (!$this->id_equation)
// impossible d'accéder à cette équation
return $msg[409];
$query = "delete from bannette_equation WHERE num_equation='$this->id_equation'";
pmb_mysql_query($query);
$query = "delete from equations WHERE id_equation='$this->id_equation'";
pmb_mysql_query($query);
}
// pour maj de requete d'équation
public function make_hidden_search_form($url="") {
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