id=$id;
$this->fetch_datas();
} // end of member function __construct
public function get_isbd() {
return $this->isbd;
}
public function get_public() {
return $this->public;
}
public function get_data() {
return $this->map;
}
public function fetch_datas() {
global $dbh,$msg;
$this->map=array();
$this->isbd="";
$this->public="";
if(!$this->id) return;
$req="select map_echelle_num, map_projection_num, map_ref_num, map_equinoxe
from notices where notice_id=".$this->id;
$res=pmb_mysql_query($req);
if (pmb_mysql_num_rows($res)) {
if($r=pmb_mysql_fetch_object($res)){
$this->map['id']=$r->map_id;
$this->map['echelle_num']=$r->map_echelle_num;
$this->map['projection_num']=$r->map_projection_num;
$this->map['ref_num']=$r->map_ref_num;
$this->map['equinoxe']=$r->map_equinoxe;
if($this->map['echelle_num']){
$req_echelle = "SELECT map_echelle_name FROM map_echelles where map_echelle_id =".$this->map['echelle_num'];
$res_echelle=pmb_mysql_query($req_echelle);
if (pmb_mysql_num_rows($res_echelle)) {
$r_echelle=pmb_mysql_fetch_object($res_echelle);
$this->map['echelle']=$r_echelle->map_echelle_name;
$this->isbd.=$this->map['echelle'];
$this->public.="
".$msg["map_notice_echelle"]."
".$this->map['echelle']."
";
}
}
if($this->map['projection_num']){
$req_projection = "SELECT map_projection_name FROM map_projections where map_projection_id =".$this->map['projection_num'];
$res_projection=pmb_mysql_query($req_projection);
if (pmb_mysql_num_rows($res_projection)) {
$r_projection=pmb_mysql_fetch_object($res_projection);
$this->map['projection']=$r_projection->map_projection_name;
if($this->isbd) $this->isbd.=" ; ";
$this->isbd.=$this->map['projection'];
$this->public.="
".$msg["map_notice_projection"]."
".$this->map['projection']."
";
}
}
if($this->map['ref_num']){
$req_ref = "SELECT map_ref_name FROM map_refs where map_ref_id =".$this->map['ref_num'];
$res_ref=pmb_mysql_query($req_ref);
if (pmb_mysql_num_rows($res_ref)) {
$r_ref=pmb_mysql_fetch_object($res_ref);
$this->map['ref']=$r_ref->map_ref_name;
if($this->isbd) $this->isbd.=". ";
$this->isbd.=$this->map['ref'];
$this->public.="
";
if($this->isbd)$this->isbd=". - ".$this->isbd;
}
}
}
public function get_form() {
global $dbh,$msg;
global $map_edition_tpl;
global $map_edition_all_tpl;
$form_map="";
$map_edition_tpl="
!!map_echelle_list!!
!!map_projection_list!!
!!map_ref_list!!
";
$form_map=$map_edition_tpl;
$requete = "SELECT map_echelle_id, map_echelle_name FROM map_echelles ORDER BY map_echelle_name ";
$projections=gen_liste($requete,"map_echelle_id","map_echelle_name","f_map_echelle","",$this->map['echelle_num'],0,"",0,$msg['map_echelle_vide']);
$form_map=str_replace("!!map_echelle_list!!",$projections,$form_map);
$requete = "SELECT map_projection_id, map_projection_name FROM map_projections ORDER BY map_projection_name ";
$projections=gen_liste($requete,"map_projection_id","map_projection_name","f_map_projection","",$this->map['projection_num'],0,"",0,$msg['map_projection_vide']);
$form_map=str_replace("!!map_projection_list!!",$projections,$form_map);
$requete = "SELECT map_ref_id, map_ref_name FROM map_refs ORDER BY map_ref_name ";
$refs=gen_liste($requete,"map_ref_id","map_ref_name","f_map_ref","",$this->map['ref_num'],0,"",0,$msg['map_ref_vide']);
$form_map=str_replace("!!map_ref_list!!",$refs,$form_map);
$form_map=str_replace("!!map_equinoxe_value!!",$this->map['equinoxe'],$form_map);
$form_map=str_replace("!!id!!",$this->id,$form_map);
return $form_map;
}
public function save_form() {
global $dbh;
global $f_map_echelle;
global $f_map_projection;
global $f_map_ref;
global $f_map_equinoxe;
$req = "update notices SET
map_echelle_num=$f_map_echelle,
map_projection_num=$f_map_projection,
map_ref_num=$f_map_ref,
map_equinoxe='$f_map_equinoxe'
where notice_id=".$this->id;
pmb_mysql_query($req);
$this->fetch_datas();
}
} // end of class