id_source = $id+0; if(!$this->id_source){ $this->libelle_source =''; } else { $req="select libelle_source from suggestions_source where id_source='".$this->id_source."'"; $res = pmb_mysql_query($req); $src = pmb_mysql_fetch_object($res); $this->libelle_source = $src->libelle_source; } } /* * Gestion des actions */ public function proceed($action){ switch($action){ case 'save': $this->save(); $this->show_form(); break; case 'modif': case 'add': $this->show_edit_form(); break; case 'del': $ko = $this->delete(); if(!$ko) $this->show_form(); break; default: $this->show_form(); break; } } /* * Formulaire d'ajout/modification */ public function show_edit_form(){ global $src_form, $msg, $charset; if(!$this->id_source){ $src_form = str_replace('!!form_title!!',$msg['acquisition_ajout_src'],$src_form); $src_form = str_replace('!!libelle!!','',$src_form); $src_form = str_replace('!!bouton_sup!!','',$src_form); $src_form = str_replace('!!id!!','',$src_form); } else { $src_form .= ""; $src_form = str_replace('!!id!!',$this->id_source,$src_form); $src_form = str_replace('!!form_title!!',$msg['acquisition_modif_src'],$src_form); $src_form = str_replace('!!libelle!!',htmlentities($this->libelle_source, ENT_QUOTES, $charset),$src_form); $btn_sup = " "; $tab_src =array(); $req = "select * from suggestions_source order by libelle_source"; $res=pmb_mysql_query($req,$dbh); while ($row = pmb_mysql_fetch_object($res)){ $tab_src[$row->id_source] = $row->libelle_source; } if(count($tab_src) == 0){ $display .= "".$msg['acquisition_no_src_available'].""; } $parity=1; foreach($tab_src as $id_src=>$lib_src) { if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=src&act=modif&id_src=$id_src';\" "; $display .= "".htmlentities($lib_src, ENT_QUOTES, $charset).""; $display .= ""; } $display .= " "; print $display; } /* * Création/Modification */ public function save(){ global $dbh, $libelle; if(!$this->id_source){ $req = "insert into suggestions_source set libelle_source='".$libelle."'"; } else { $req="update suggestions_source set libelle_source='".$libelle."' where id_source='".$this->id_source."'"; } pmb_mysql_query($req,$dbh); } //Suppression d'une source public function delete(){ global $msg; $error = false; if($this->hasSuggestions()){ error_message($msg[321],$msg['acquisition_sugg_source_used'],1, 'admin.php?categ=acquisition&sub=src'); $error=true; } else { $req="delete from suggestions_source where id_source='".$this->id_source."'"; pmb_mysql_query($req); } return $error; } //Vérifie si la source de suggestions est utilisee dans les suggestions public function hasSuggestions(){ $q = "select count(1) from suggestions where sugg_source = '".$this->id_source."' "; $r = pmb_mysql_query($q); return pmb_mysql_result($r, 0, 0); } } ?>