option_visibilite=$option_visibilite; $this->prefix=$prefix; $this->base_url=$base_url; $_custom_prefixe_=$prefix; //Lecture des champs $this->no_special_fields=0; $this->t_fields=array(); if(!isset(self::$st_fields[$this->prefix])){ $requete="select idchamp, name, titre, type, datatype, obligatoire, options, multiple, search, export, exclusion_obligatoire, pond, opac_sort, comment from ".$this->prefix."_custom order by ordre"; $resultat=pmb_mysql_query($requete); if (pmb_mysql_num_rows($resultat)==0){ self::$st_fields[$this->prefix] = false; }else { while ($r=pmb_mysql_fetch_object($resultat)) { self::$st_fields[$this->prefix][$r->idchamp]["DATATYPE"]=$r->datatype; self::$st_fields[$this->prefix][$r->idchamp]["NAME"]=$r->name; self::$st_fields[$this->prefix][$r->idchamp]["TITRE"]=$r->titre; self::$st_fields[$this->prefix][$r->idchamp]["TYPE"]=$r->type; self::$st_fields[$this->prefix][$r->idchamp]["OPTIONS"][0]=_parser_text_no_function_("\n".$r->options, "OPTIONS"); if(!isset(self::$st_fields[$this->prefix][$r->idchamp]["OPTIONS"][0]["REPEATABLE"][0]["value"])) { self::$st_fields[$this->prefix][$r->idchamp]["OPTIONS"][0]["REPEATABLE"][0]["value"] = 0; } self::$st_fields[$this->prefix][$r->idchamp]["MANDATORY"]=$r->obligatoire; self::$st_fields[$this->prefix][$r->idchamp]["OPAC_SHOW"]=$r->multiple; self::$st_fields[$this->prefix][$r->idchamp]["SEARCH"]=$r->search; self::$st_fields[$this->prefix][$r->idchamp]["EXPORT"]=$r->export; self::$st_fields[$this->prefix][$r->idchamp]["EXCLUSION"]=$r->exclusion_obligatoire; self::$st_fields[$this->prefix][$r->idchamp]["POND"]=$r->pond; self::$st_fields[$this->prefix][$r->idchamp]["OPAC_SORT"]=$r->opac_sort; self::$st_fields[$this->prefix][$r->idchamp]["COMMENT"]=$r->comment; } } } if(self::$st_fields[$this->prefix] == false){ $this->no_special_fields=1; }else{ $this->t_fields=self::$st_fields[$this->prefix]; } } //Affichage de l'écran de gestion des paramètres perso (la liste de tous les champs définis) public function show_field_list() { global $type_list_empr; global $datatype_list; global $form_list; global $msg; $res=""; $requete="select idchamp, name, titre, type, datatype, multiple, obligatoire, ordre ,search, export,exclusion_obligatoire, opac_sort, comment from ".$this->prefix."_custom order by ordre"; $resultat=pmb_mysql_query($requete); /*if(!$resultat) { echo "ya pas de res : ".pmb_mysql_num_rows($resultat)."
"; } echo "nombre : ".pmb_mysql_num_rows($resultat)."
";*/ if (pmb_mysql_num_rows($resultat)==0) { $res=$msg["parperso_no_field"]."
"; $form_list=str_replace("!!liste_champs_perso!!",$res,$form_list); $form_list=str_replace("!!base_url!!",$this->base_url,$form_list); return $form_list; } else { $res="\n"; $res.=""; if($this->option_visibilite["multiple"] == "block") $res.= "" ; if($this->option_visibilite["opac_sort"] == "block") $res.= "" ; if($this->option_visibilite["obligatoire"] == "block") $res.= "" ; if($this->option_visibilite["search"] == "block") $res.= "" ; if($this->option_visibilite["export"] == "block") $res.= "" ; if($this->option_visibilite["exclusion"] == "block") $res.= "\n" ; else $res .= "\n"; $parity=1; $n=0; while ($r=pmb_mysql_fetch_object($resultat)) { if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity+=1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" "; $action_td=" onmousedown=\"document.location='".$this->base_url."&action=edit&id=$r->idchamp';\" "; $res.=""; $res.=""; $res.=""; if($this->option_visibilite["multiple"] == "block") { $res.=""; } if($this->option_visibilite["opac_sort"] == "block") { $res.=""; } if($this->option_visibilite["obligatoire"] == "block") { $res.=""; } if($this->option_visibilite["search"] == "block") { $res.=""; } if($this->option_visibilite["export"] == "block") { $res.=""; } if($this->option_visibilite["exclusion"] == "block"){ $res.=""; } $res.="\n"; } $res.="
".$msg["parperso_field_name"]."".$msg["parperso_field_title"]."".$msg["parperso_input_type"]."".$msg["parperso_data_type"]."".((strpos($this->prefix,"gestfic")!==false) ? $msg["parperso_fiche_visibility"] : $msg["parperso_opac_visibility"])."".$msg["parperso_opac_sort"]."".$msg["parperso_mandatory"]."".$msg["parperso_field_search_tableau"]."".$msg["parperso_exportable"]."".$msg["parperso_exclusion_entete"]."
"; $res.=""; $res.="".$r->name."".$r->titre."".$type_list_empr[$r->type]."".$datatype_list[$r->datatype].""; if ($r->multiple==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.=""; if ($r->opac_sort==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.=""; if ($r->obligatoire==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.=""; if ($r->search==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.=""; if ($r->export==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.=""; if ($r->exclusion_obligatoire==1) $res.=$msg["40"]; else $res.=$msg["39"]; $res.="
"; $form_list=str_replace("!!liste_champs_perso!!",$res,$form_list); $form_list=str_replace("!!base_url!!",$this->base_url,$form_list); return $form_list; } } public function gen_liste_field($select_name="p_perso_liste",$selected_id=0,$msg_no_select) { global $msg; $onchange=""; $requete="select idchamp, name, titre, type, datatype, multiple, obligatoire, ordre ,search, export,exclusion_obligatoire, opac_sort from ".$this->prefix."_custom order by ordre"; return gen_liste ($requete, "idchamp", "titre", $select_name, $onchange, $selected_id, 0, $msg["parperso_no_field"], 0,$msg_no_select, 0) ; } //Affichage du formulaire d'édition d'un champ perso public function show_edit_form($idchamp=0) { global $charset; global $type_list_empr; global $datatype_list; global $form_edit; global $include_path; global $msg, $thesaurus_liste_trad; if ($idchamp!=0 and $idchamp!="") { $requete="select idchamp, name, titre, type, datatype, options, multiple, obligatoire, ordre, search, export, exclusion_obligatoire, pond, opac_sort, comment from ".$this->prefix."_custom where idchamp=$idchamp"; $resultat=pmb_mysql_query($requete) or die(pmb_mysql_error()); $r=pmb_mysql_fetch_object($resultat); $name=$r->name; $titre = $r->titre; $type=$r->type; $datatype=$r->datatype; $options=htmlentities($r->options,ENT_QUOTES,$charset); $multiple=$r->multiple; $obligatoire=$r->obligatoire; $ordre=$r->ordre; $search=$r->search; $export=$r->export; $exclusion=$r->exclusion_obligatoire; $pond=$r->pond; $opac_sort=$r->opac_sort; $comment=$r->comment; $form_edit=str_replace("!!form_titre!!",sprintf($msg["parperso_field_edition"],$name),$form_edit); $form_edit=str_replace("!!action!!","update",$form_edit); if ($r->options!="") { $param=_parser_text_no_function_("\n".$r->options, "OPTIONS"); $form_edit=str_replace("!!for!!",$param["FOR"],$form_edit); } else { $form_edit=str_replace("!!for!!","",$form_edit); } $form_edit=str_replace("!!supprimer!!"," ",$form_edit); } else { $name=''; $titre=''; $type=''; $datatype=''; $options=''; $multiple=''; $obligatoire=''; $ordre=''; $search=''; $export=''; $exclusion=''; $pond=''; $opac_sort=''; $comment=''; $form_edit=str_replace("!!form_titre!!",$msg["parperso_create_new_field"],$form_edit); $form_edit=str_replace("!!action!!","create",$form_edit); $form_edit=str_replace("!!for!!","",$form_edit); $form_edit=str_replace("!!supprimer!!","",$form_edit); } $onclick="openPopUp('".$include_path."/options_empr/options.php?name=&type='+this.form.type.options[this.form.type.selectedIndex].value+'&_custom_prefixe_=".$this->prefix."','options',550,600,-2,-2,'menubars=no,resizable=yes,scrollbars=yes');"; $form_edit=str_replace("!!onclick!!",$onclick,$form_edit); $form_edit=str_replace("!!idchamp!!",$idchamp,$form_edit); $form_edit=str_replace("!!name!!",$name,$form_edit); $trans = new translation($idchamp, $this->prefix."_custom", "titre", $thesaurus_liste_trad); $field_title = $trans->get_form($msg["parperso_field_title"], "titre", "titre", $titre, "saisie-30em"); $form_edit = str_replace("!!titre!!", $field_title, $form_edit); $form_edit=str_replace("!!pond!!",$pond,$form_edit); //Liste des types $t_list="\n"; $form_edit=str_replace("!!type_list!!",$t_list,$form_edit); //Liste des types de données $t_list="\n"; $form_edit=str_replace("!!datatype_list!!",$t_list,$form_edit); $form_edit=str_replace("!!options!!",$options,$form_edit); if ($multiple==1) $f_multiple="checked"; else $f_multiple=""; $form_edit=str_replace("!!multiple_checked!!",$f_multiple,$form_edit); if ($obligatoire==1) $f_obligatoire="checked"; else $f_obligatoire=""; $form_edit=str_replace("!!obligatoire_checked!!",$f_obligatoire,$form_edit); if ($search==1) $f_search="checked"; else $f_search=""; $form_edit=str_replace("!!search_checked!!",$f_search,$form_edit); if ($export==1) $f_export="checked"; else $f_export=""; $form_edit=str_replace("!!export_checked!!",$f_export,$form_edit); if ($exclusion==1) $f_exclusion="checked"; else $f_exclusion=""; $form_edit=str_replace("!!exclusion_checked!!",$f_exclusion,$form_edit); if ($opac_sort==1) $f_opac_sort="checked"; else $f_opac_sort=""; $form_edit=str_replace("!!opac_sort_checked!!",$f_opac_sort,$form_edit); $form_edit=str_replace("!!comment!!",$comment,$form_edit); foreach ( $this->option_visibilite as $key => $value ) { $form_edit=str_replace("!!".$key."_visible!!",$value,$form_edit); } if(strpos($this->prefix,"gestfic")!==false) $form_edit = str_replace("!!msg_visible!!",$msg['parperso_fiche_visibility'],$form_edit); else $form_edit = str_replace("!!msg_visible!!",$msg['parperso_opac_visibility'],$form_edit); $form_edit=str_replace("!!ordre!!",$ordre,$form_edit); $form_edit=str_replace("!!base_url!!",$this->base_url,$form_edit); echo $form_edit; } //Création d'une erreur si options non valides ou formulaires de création d'un champ mal rempli public function make_error($message) { global $msg; error_message_history($msg["540"],$message, 1); exit(); } //Validation du formulaire de création public function check_form() { global $action,$idchamp; global $name,$titre,$type,$_for,$multiple,$obligatoire,$exclusion,$msg,$search,$export,$pond,$opac_sort, $comment; //Vérification conformité du champ name if (!preg_match("/^[A-Za-z][A-Za-z0-9_]*$/",$name)) $this->make_error(sprintf($msg["parperso_check_field_name"],$name)); //On vérifie que le champ name ne soit pas déjà existant if ($action == "update") $requete="select idchamp from ".$this->prefix."_custom where name='$name' and idchamp<>$idchamp"; else $requete="select idchamp from ".$this->prefix."_custom where name='$name'"; $resultat=pmb_mysql_query($requete); if (pmb_mysql_num_rows($resultat) > 0) $this->make_error(sprintf($msg["parperso_check_field_name_already_used"],$name)); if ($titre=="") $titre=$name; if ($_for!=$type) $this->make_error($msg["parperso_check_type"]); if ($multiple=="") $multiple=0; if ($obligatoire=="") $obligatoire=0; if($search=="") $search=0; if($export=="") $export=0; if($exclusion=="") $exclusion=0; if($pond=="") $pond=1; if($opac_sort=="") $opac_sort=0; } //Validation des valeurs des champs soumis lors de la saisie d'une fichie emprunteur ou autre... public function check_submited_fields() { global $chk_list_empr,$charset; $nberrors=0; $this->error_message=""; if (!$this->no_special_fields) { reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { $check_message=""; $field=array(); $field["ID"]=$key; $field["NAME"]=$this->t_fields[$key]["NAME"]; $field["MANDATORY"]=$this->t_fields[$key]["MANDATORY"]; $field["ALIAS"]=$this->t_fields[$key]["TITRE"]; $field["OPTIONS"]=$this->t_fields[$key]["OPTIONS"]; $field["DATATYPE"]=$this->t_fields[$key]["DATATYPE"]; $field["PREFIX"]=$this->prefix; $field["SEARCH"]=$this->t_fields[$key]["SEARCH"]; $field["EXPORT"]=$this->t_fields[$key]["EXPORT"]; $field["EXCLUSION"]=$this->t_fields[$key]["EXCLUSION"]; $field["OPAC_SORT"]=$this->t_fields[$key]["OPAC_SORT"]; $field["COMMENT"]=$this->t_fields[$key]["COMMENT"]; global ${$val["NAME"]}; $field['VALUES'] = ${$val["NAME"]}; eval($chk_list_empr[$this->t_fields[$key]["TYPE"]]."(\$field,\$check_message);"); if ($check_message!="") { $nberrors++; $this->error_message.="

".$check_message."

"; } } } return $nberrors; } //Presence ou nom de valeurs lors de la saisie public function presence_submited_fields() { global $chk_list_empr,$charset; if (!$this->no_special_fields) { reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { $field_name = $this->t_fields[$key]["NAME"]; global ${$field_name}; $field = ${$field_name}; if ($field[0]) return true; } } return false; } //Presence ou nom de valeurs lors de la saisie dans les champs exclus public function presence_exclusion_fields() { global $chk_list_empr,$charset; //global $exclu_tab; $exclu_tab=array(); if (!$this->no_special_fields) { reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($this->t_fields[$key]["EXCLUSION"]) $exclu_tab[] = $this->t_fields[$key]; } if(is_array($exclu_tab)) { while (list($key,$val)=each($exclu_tab)) { $field_name = $exclu_tab[$key]["NAME"]; global ${$field_name}; $field = ${$field_name}; if ($field[0]) return true; } } return false; } return false; } // retourne la liste des valeurs des champs perso cherchable d'une notice public function get_fields_recherche($id) { $return_val=''; $this->get_values($id); foreach ( $this->values as $field_id => $vals ) { if($this->t_fields[$field_id]["SEARCH"] ) { foreach ( $vals as $value ) { $return_val.=$this->get_formatted_output(array($value),$field_id).' ';//Sa valeur } } } return stripslashes($return_val); } // retourne la liste des valeurs des champs perso cherchable d'une notice sous forme d'un tableau par champ perso public function get_fields_recherche_mot($id) { $return_val=array(); $this->get_values($id); foreach ( $this->values as $field_id => $vals ) { if($this->t_fields[$field_id]["SEARCH"] ) { foreach ( $vals as $value ) { $return_val[$field_id].=stripslashes($this->get_formatted_output(array($value),$field_id)).' ';//Sa valeur } } } return $return_val; } // retourne la liste des valeurs des champs perso cherchable d'une notice sous forme d'un tableau par champ perso public function get_fields_recherche_mot_array($id) { $return_val=array(); $this->get_values($id); foreach ( $this->values as $field_id => $vals ) { if($this->t_fields[$field_id]["SEARCH"] ) { foreach ( $vals as $value ) { $return_val[$field_id][]=stripslashes($this->get_formatted_output(array($value),$field_id)).' ';//Sa valeur } } } return $return_val; } //Enregistrement des champs perso soumis lors de la saisie d'une fichie emprunteur ou autre... public function rec_fields_perso($id) { //Enregistrement des champs personalisés $requete="delete from ".$this->prefix."_custom_values where ".$this->prefix."_custom_origine=$id"; pmb_mysql_query($requete); reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { $name=$val["NAME"]; global ${$name}; $value=${$name}; for ($i=0; $iprefix."_custom_values (".$this->prefix."_custom_champ,".$this->prefix."_custom_origine,".$this->prefix."_custom_".$val["DATATYPE"].",".$this->prefix."_custom_order) values($key,$id,'".$value[$i]."',$i)"; pmb_mysql_query($requete); } } } } public function read_form_fields_perso($name) { //Enregistrement des champs personalisés $return_val=''; reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($val["NAME"] == $name) { global ${$name}; $value=${$name}; for ($i=0; $iget_values($id); if (!$this->no_special_fields) { reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($val["NAME"] == $name){ for ($i=0; $ivalues[$key]); $i++) { $return_val.=$this->values[$key][$i]; } } } } return $return_val; } public function read_base_fields_perso_values($name,$id) { global $val_list_empr; global $charset; $perso=array(); //Récupération des valeurs stockées $this->get_values($id); if (!$this->no_special_fields) { reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($val["NAME"] == $name){ for ($i=0; $ivalues[$key]); $i++) { $perso[]=$this->values[$key][$i]; } } } } return $perso; } protected function _sort_values_by_format_values($a,$b) { if($a['order'] != $b['order']) { return ($a['order'] < $b['order']) ? -1 : 1; } if (strtolower(strip_tags($a['format_value'])) == strtolower(strip_tags($b['format_value']))) { return 0; } return (strtolower(strip_tags($a['format_value'])) < strtolower(strip_tags($b['format_value']))) ? -1 : 1; } protected function sort_values($fields) { $values = array(); foreach ($fields as $field_id=>$field_values) { uasort($field_values, array($this, '_sort_values_by_format_values')); $values[$field_id] = array(); foreach ($field_values as $value) { $values[$field_id][] = $value['value']; } } return $values; } //Récupération des valeurs stockées dans les base pour un emprunteur ou autre public function get_values($id) { //Récupération des valeurs stockées $this->values=$this->list_values=array(); if ((!$this->no_special_fields)&&($id)) { $requete="select ".$this->prefix."_custom_champ,".$this->prefix."_custom_origine,".$this->prefix."_custom_small_text, ".$this->prefix."_custom_text, ".$this->prefix."_custom_integer, ".$this->prefix."_custom_date, ".$this->prefix."_custom_float, ".$this->prefix."_custom_order from ".$this->prefix."_custom_values where ".$this->prefix."_custom_origine=".$id; $resultat=pmb_mysql_query($requete); if(pmb_mysql_num_rows($resultat)) { while ($r=pmb_mysql_fetch_array($resultat)) { $values[$r[$this->prefix."_custom_champ"]][]=array( 'value' => $r[$this->prefix."_custom_".$this->t_fields[$r[$this->prefix."_custom_champ"]]["DATATYPE"]], 'format_value' => $this->get_formatted_output(array($r[$this->prefix."_custom_".$this->t_fields[$r[$this->prefix."_custom_champ"]]["DATATYPE"]]),$r[$this->prefix."_custom_champ"],true), 'order' => $r[$this->prefix."_custom_order"] ); $this->list_values[]=$r[$this->prefix."_custom_".$this->t_fields[$r[$this->prefix."_custom_champ"]]["DATATYPE"]]; } $this->values = $this->sort_values($values); } } } //Affichage des champs à saisir dans le formulaire de modification/création d'un emprunteur ou autre public function show_editable_fields($id,$from_z3950=false) { global $aff_list_empr,$charset; $perso=array(); if (!$this->no_special_fields) { if(!$from_z3950){ $this->get_values($id); } $check_scripts=""; reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if(!isset($this->values[$key])) $this->values[$key] = array(); $t=array(); $t["ID"]=$key; $t["NAME"]=$val["NAME"]; $t["TITRE"]=$val["TITRE"]; $t["COMMENT"]=$val["COMMENT"]; if($t["COMMENT"]){ if(strlen($t["COMMENT"])>77) $comment_field=substr($t["COMMENT"], 0, 77)."..."; else $comment_field=$t["COMMENT"]; $comment_title=$t["COMMENT"]; $t["COMMENT_DISPLAY"]="".htmlentities($comment_field,ENT_QUOTES, $charset).""; } else { $t["COMMENT_DISPLAY"]=""; } $field=array(); $field["ID"]=$key; $field["NAME"]=$this->t_fields[$key]["NAME"]; $field["MANDATORY"]=$this->t_fields[$key]["MANDATORY"]; $field["SEARCH"]=$this->t_fields[$key]["SEARCH"]; $field["EXPORT"]=$this->t_fields[$key]["EXPORT"]; $field["EXCLUSION"]=$this->t_fields[$key]["EXCLUSION"]; $field["OPAC_SORT"]=$this->t_fields[$key]["OPAC_SORT"]; $field["COMMENT"]=$this->t_fields[$key]["COMMENT"]; $field["ALIAS"]=$this->t_fields[$key]["TITRE"]; $field["DATATYPE"]=$this->t_fields[$key]["DATATYPE"]; $field["OPTIONS"]=$this->t_fields[$key]["OPTIONS"]; $field["VALUES"]=$this->values[$key]; $field["PREFIX"]=$this->prefix; $field["ID_ORIGINE"]=$id; eval("\$aff=".$aff_list_empr[$this->t_fields[$key]['TYPE']]."(\$field,\$check_scripts);"); $t["AFF"]=$aff; $t["NAME"]=$field["NAME"]; $perso["FIELDS"][]=$t; } //Compilation des javascripts de validité renvoyés par les fonctions d'affichage $check_scripts=""; $perso["CHECK_SCRIPTS"]=$check_scripts; } else $perso["CHECK_SCRIPTS"]=""; return $perso; } //Affichage des champs en lecture seule pour visualisation d'un fiche emprunteur ou autre... public function show_fields($id) { global $val_list_empr; global $charset; $perso=array(); //Récupération des valeurs stockées pour l'emprunteur $this->get_values($id); if (!$this->no_special_fields) { //Affichage champs persos $c=0; reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { $t=array(); $t['TITRE']=''.htmlentities($val['TITRE'],ENT_QUOTES,$charset).' : '; $t['TITRE_CLEAN']=htmlentities($val['TITRE'],ENT_QUOTES,$charset); $t['OPAC_SHOW']=$val['OPAC_SHOW']; if(!isset($this->values[$key])) $this->values[$key] = array(); if(!isset(static::$fields[$this->prefix][$key])){ static::$fields[$this->prefix][$key]=array(); static::$fields[$this->prefix][$key]['ID']=$key; static::$fields[$this->prefix][$key]['NAME']=$this->t_fields[$key]['NAME']; static::$fields[$this->prefix][$key]['MANDATORY']=$this->t_fields[$key]['MANDATORY']; static::$fields[$this->prefix][$key]['SEARCH']=$this->t_fields[$key]['SEARCH']; static::$fields[$this->prefix][$key]['EXPORT']=$this->t_fields[$key]['EXPORT']; static::$fields[$this->prefix][$key]['EXCLUSION']=$this->t_fields[$key]['EXCLUSION']; static::$fields[$this->prefix][$key]['OPAC_SORT']=$this->t_fields[$key]['OPAC_SORT']; static::$fields[$this->prefix][$key]['COMMENT']=$this->t_fields[$key]['COMMENT']; static::$fields[$this->prefix][$key]['ALIAS']=$this->t_fields[$key]['TITRE']; static::$fields[$this->prefix][$key]['DATATYPE']=$this->t_fields[$key]['DATATYPE']; static::$fields[$this->prefix][$key]['OPTIONS']=$this->t_fields[$key]['OPTIONS']; static::$fields[$this->prefix][$key]['VALUES']=$this->values[$key]; static::$fields[$this->prefix][$key]['PREFIX']=$this->prefix; } $t['TYPE']=$this->t_fields[$key]['TYPE']; $aff=$val_list_empr[$this->t_fields[$key]['TYPE']](static::$fields[$this->prefix][$key],$this->values[$key]); if(is_array($aff) && $aff['ishtml'] == true){ $t['AFF'] = $aff['value']; if(isset($aff['details'])) { $t['DETAILS'] = $aff['details']; } } else { $t['AFF']=htmlentities($aff,ENT_QUOTES,$charset); } $t['NAME']=static::$fields[$this->prefix][$key]['NAME']; $t['ID']=static::$fields[$this->prefix][$key]['ID']; $perso['FIELDS'][]=$t; } } return $perso; } public function get_formatted_output($values,$field_id) { global $val_list_empr,$charset; if(!isset(static::$fields[$this->prefix][$field_id])){ static::$fields[$this->prefix][$field_id]=array(); static::$fields[$this->prefix][$field_id]["ID"]=$field_id; static::$fields[$this->prefix][$field_id]["NAME"]=$this->t_fields[$field_id]["NAME"]; static::$fields[$this->prefix][$field_id]["MANDATORY"]=$this->t_fields[$field_id]["MANDATORY"]; static::$fields[$this->prefix][$field_id]["SEARCH"]=$this->t_fields[$field_id]["SEARCH"]; static::$fields[$this->prefix][$field_id]["EXPORT"]=$this->t_fields[$field_id]["EXPORT"]; static::$fields[$this->prefix][$field_id]["EXCLUSION"]=$this->t_fields[$field_id]["EXCLUSION"]; static::$fields[$this->prefix][$field_id]["OPAC_SORT"]=$this->t_fields[$field_id]["OPAC_SORT"]; static::$fields[$this->prefix][$field_id]["COMMENT"]=$this->t_fields[$field_id]["COMMENT"]; static::$fields[$this->prefix][$field_id]["ALIAS"]=$this->t_fields[$field_id]["TITRE"]; static::$fields[$this->prefix][$field_id]["DATATYPE"]=$this->t_fields[$field_id]["DATATYPE"]; static::$fields[$this->prefix][$field_id]["OPTIONS"]=$this->t_fields[$field_id]["OPTIONS"]; static::$fields[$this->prefix][$field_id]["VALUES"]=$values; static::$fields[$this->prefix][$field_id]["PREFIX"]=$this->prefix; } $aff=$val_list_empr[$this->t_fields[$field_id]["TYPE"]](static::$fields[$this->prefix][$field_id],$values); if(is_array($aff)) return $aff['withoutHTML']; else return $aff; } //Appelé par sort_out_values protected function _sort_out_values_by_format_values($a,$b) { if($a['order'] != $b['order']) { return ($a['order'] < $b['order']) ? -1 : 1; } if (strtolower(strip_tags($a['format_value'])) == strtolower(strip_tags($b['format_value']))) { return 0; } return (strtolower(strip_tags($a['format_value'])) < strtolower(strip_tags($b['format_value']))) ? -1 : 1; } //Appelé dans get_out_values protected function sort_out_values() { $fields = $this->values; foreach ($fields as $name=>$field) { uasort($field['values'], array($this, '_sort_out_values_by_format_values')); $this->values[$name]['values'] = $field['values']; } } //Récupération des valeurs stockées dans les base pour un emprunteur ou autre public function get_out_values($id) { //défini dans des classes filles } //Suppression de la base des valeurs d'un emprunteur ou autre... public function delete_values($id) { $requete = "DELETE FROM ".$this->prefix."_custom_values where ".$this->prefix."_custom_origine=$id"; $res = pmb_mysql_query($requete); } //Gestion des actions en administration public function proceed() { global $action, $thesaurus_liste_trad; global $name,$titre,$type,$datatype,$_options,$multiple,$obligatoire,$search,$export,$exclusion,$ordre,$idchamp,$id,$pond,$opac_sort,$comment; switch ($action) { case "nouv": $this->show_edit_form(); break; case "edit": $this->show_edit_form($id); break; case "create": $this->check_form(); $requete="select max(ordre) from ".$this->prefix."_custom"; $resultat=pmb_mysql_query($requete); if (pmb_mysql_num_rows($resultat)!=0) $ordre=pmb_mysql_result($resultat,0,0)+1; else $ordre=1; $requete="insert into ".$this->prefix."_custom set name='$name', titre='$titre', type='$type', datatype='$datatype', options='$_options', multiple=$multiple, obligatoire=$obligatoire, ordre=$ordre, search=$search, export=$export, exclusion_obligatoire=$exclusion, opac_sort=$opac_sort, comment='$comment' "; pmb_mysql_query($requete); $idchamp = pmb_mysql_insert_id(); $trans = new translation($idchamp, $this->prefix."_custom", "titre", $thesaurus_liste_trad); $trans->update("titre"); echo $this->show_field_list(); onto_parametres_perso::reinitialize(); break; case "update": $this->check_form(); $requete="update ".$this->prefix."_custom set name='$name', titre='$titre', type='$type', datatype='$datatype', options='$_options', multiple=$multiple, obligatoire=$obligatoire, ordre=$ordre, search=$search, export=$export, exclusion_obligatoire=$exclusion, pond=$pond, opac_sort=$opac_sort, comment='$comment' where idchamp=$idchamp"; pmb_mysql_query($requete); $trans = new translation($idchamp, $this->prefix."_custom", "titre", $thesaurus_liste_trad); $trans->update("titre"); echo $this->show_field_list(); onto_parametres_perso::reinitialize(); break; case "up": $requete="select ordre from ".$this->prefix."_custom where idchamp=$id"; $resultat=pmb_mysql_query($requete); $ordre=pmb_mysql_result($resultat,0,0); $requete="select max(ordre) as ordre from ".$this->prefix."_custom where ordre<$ordre"; $resultat=pmb_mysql_query($requete); $ordre_max=@pmb_mysql_result($resultat,0,0); if ($ordre_max) { $requete="select idchamp from ".$this->prefix."_custom where ordre=$ordre_max limit 1"; $resultat=pmb_mysql_query($requete); $idchamp_max=pmb_mysql_result($resultat,0,0); $requete="update ".$this->prefix."_custom set ordre='".$ordre_max."' where idchamp=$id"; pmb_mysql_query($requete); $requete="update ".$this->prefix."_custom set ordre='".$ordre."' where idchamp=".$idchamp_max; pmb_mysql_query($requete); } echo $this->show_field_list(); break; case "down": $requete="select ordre from ".$this->prefix."_custom where idchamp=$id"; $resultat=pmb_mysql_query($requete); $ordre=pmb_mysql_result($resultat,0,0); $requete="select min(ordre) as ordre from ".$this->prefix."_custom where ordre>$ordre"; $resultat=pmb_mysql_query($requete); $ordre_min=@pmb_mysql_result($resultat,0,0); if ($ordre_min) { $requete="select idchamp from ".$this->prefix."_custom where ordre=$ordre_min limit 1"; $resultat=pmb_mysql_query($requete); $idchamp_min=pmb_mysql_result($resultat,0,0); $requete="update ".$this->prefix."_custom set ordre='".$ordre_min."' where idchamp=$id"; pmb_mysql_query($requete); $requete="update ".$this->prefix."_custom set ordre='".$ordre."' where idchamp=".$idchamp_min; pmb_mysql_query($requete); } echo $this->show_field_list(); break; case "delete": $requete="delete from ".$this->prefix."_custom where idchamp=$idchamp"; pmb_mysql_query($requete); $requete="delete from ".$this->prefix."_custom_values where ".$this->prefix."_custom_champ=$idchamp"; pmb_mysql_query($requete); $requete="delete from ".$this->prefix."_custom_lists where ".$this->prefix."_custom_champ=$idchamp"; pmb_mysql_query($requete); $trans = new translation($idchamp, $this->prefix."_custom", "titre", $thesaurus_liste_trad); $trans->delete(); echo $this->show_field_list(); onto_parametres_perso::reinitialize(); break; default: echo $this->show_field_list(); } } public function get_pond($id){ return $this->t_fields[$id]["POND"]; } public function get_ajax_list($name, $start) { global $charset,$dbh; $values=array(); reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($val['NAME'] == $name) { switch ($val['TYPE']) { case 'list' : $q="select ".$this->prefix."_custom_list_value, ".$this->prefix."_custom_list_lib from ".$this->prefix."_custom_lists where ".$this->prefix."_custom_champ=".$key." order by ordre"; $r=pmb_mysql_query($q,$dbh); if(pmb_mysql_num_rows($r)) { while ($row=pmb_mysql_fetch_row($r)) { $values[$row[0]]=$row[1]; } } break; case 'query_list' : $field['OPTIONS']=$val['OPTIONS']; $q=$field['OPTIONS'][0]['QUERY'][0]['value']; $r = pmb_mysql_query($q,$dbh); if(pmb_mysql_num_rows($r)) { while ($row=pmb_mysql_fetch_row($r)) { $values[$row[0]]=$row[1]; } } break; } break; } } if (count($values) && $start && $start!='%') { $filtered_values=array(); foreach($values as $k=>$v) { if (strtolower(substr($v,0,strlen($start)))==strtolower($start)) { $filtered_values[$k]=$v; } } return $filtered_values; } return $values; } public function get_field_form($id,$field_name,$values){ global $aff_list_empr_search,$charset; $field=array(); $field['ID']=$id; $field['NAME']=$this->t_fields[$id]['NAME']; $field['MANDATORY']=$this->t_fields[$id]['MANDATORY']; $field['ALIAS']=$this->t_fields[$id]['TITRE']; $field['COMMENT']=$this->t_fields[$id]['COMMENT']; $field['DATATYPE']=$this->t_fields[$id]['DATATYPE']; $field['OPTIONS']=$this->t_fields[$id]['OPTIONS']; $field['VALUES']=$values; $field['PREFIX']=$this->prefix; eval("\$r=".$aff_list_empr_search[$this->t_fields[$id]['TYPE']]."(\$field,\$check_scripts,\$field_name);"); return $r; } /** * @param integer $id l'identifiant de l'élément concerné par la valeur du champ personalisé * @param string $fieldName le nom du champ personalisé * @param mixed $value la valeur à inserer * @param string $prefix le préfix de la table des champs personalisé concerné, par défaut notices * @return boolean true si réussi, false sinon * * Importe la valeur d'un champ personalisé pour un élément concerné. * Gère les liste et vérifi le type de document. * Controle les URL et résolveur de lien. * * La valeur doit-être celle à ajouter. (Ne trouve pas l'éditeur concerné si lien vers éditeurs par exemple) */ static public function import($id,$fieldName,$value,$prefix="notices") { $tab = array(); $idchamp=0; $type=''; $datatype=''; $check_message=''; //on trouve l'id, le type de champ et le type des données $query='SELECT idchamp,type,datatype FROM '.$prefix.'_custom WHERE name="'.addslashes($fieldName).'" LIMIT 1'; $result=pmb_mysql_query($query) or die('Echec d\'execution de la requete '.$query.' : '.pmb_mysql_error()); if(pmb_mysql_num_rows($result)){ while($line=pmb_mysql_fetch_array($result,PMB_MYSQL_ASSOC)){ $idchamp=$line['idchamp']; $type=$line['type']; $datatype=$line['datatype']; } }else{ return false; } switch ($type){ case 'list': //Selection des valeurs si list $query = 'SELECT * FROM '.$prefix.'_custom_lists WHERE '.$prefix.'_custom_champ='.$idchamp; $result=pmb_mysql_query($query) or die('Echec d\'execution de la requete '.$query.' : '.pmb_mysql_error()); if(pmb_mysql_num_rows($result)){ while($line=pmb_mysql_fetch_array($result,PMB_MYSQL_ASSOC)){ $tab[$line[$prefix.'_custom_list_lib']] = $line[$prefix.'_custom_list_value']; } } if (!$tab[$value]) { if(in_array($value, $tab)){ //on passe la clé et pas le libellé foreach($tab as $tmpKey=>$tmpVal){ if($value==$tmpVal){ $value=$tmpKey; break; } } }else{ //Ajout dans _custom_list if($datatype=='integer' || $datatype=='float'){ if (!sizeof($tab)) { $val = 1; } else { $val = max($tab)+1; } }else{ $val = $value; } $query = 'INSERT INTO '.$prefix.'_custom_lists ('.$prefix.'_custom_champ,'.$prefix.'_custom_list_value,'.$prefix.'_custom_list_lib) VALUES ('.$idchamp.',"'.addslashes(trim($val)).'","'.addslashes(trim($value)).'")'; pmb_mysql_query($query) or die('Echec d\'execution de la requete '.$query.' : '.pmb_mysql_error()); $tab[$value] = $val; } } break; case 'date_box': case 'comment': case 'text': case 'query_list': case 'query_auth': case 'external': //rien à faire $tab[$value] = $value; break; case 'resolve': //ici on vérifi la présence d'un pipe dans le resolveur if(!preg_match('/\|/', $value)){ return false; } $tab[$value] = $value; break; case 'url': //ici on vérifi le format de l'url if(!preg_match('/^http:\/\/www\./', $value)){ return false; } $tab[$value] = $value; break; default: return false; break; } //on appele la fonction de nettoyage du type de donnée. $tab[$value]=call_user_func_array('chk_type_'.$datatype,array($tab[$value],&$check_message)); if($check_message){ print $check_message; return false; } //Ajout dans _custom_values $query='DELETE FROM '.$prefix.'_custom_values WHERE '.$prefix.'_custom_champ='.$idchamp.' AND '.$prefix.'_custom_origine='.$id.' AND '.$prefix.'_custom_'.$datatype.'="'.trim(addslashes($tab[$value])).'"'; pmb_mysql_query($query) or die('Echec d\'execution de la requete '.$query.' : '.pmb_mysql_error()); $query = 'INSERT INTO '.$prefix.'_custom_values ('.$prefix.'_custom_champ,'.$prefix.'_custom_origine,'.$prefix.'_custom_'.$datatype.') VALUES ('.$idchamp.','.$id.',"'.trim(addslashes($tab[$value])).'")'; pmb_mysql_query($query) or die('Echec d\'execution de la requete '.$query.' : '.pmb_mysql_error()); return true; } //Affichage des champs de recherche public function show_search_fields() { global $aff_list_empr_search,$charset; $perso=array(); $check_scripts=""; reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($this->t_fields[$key]["SEARCH"]) { $t=array(); $t["NAME"]=$val["NAME"]; $t["TITRE"]=$val["TITRE"]; $t["COMMENT"]=$val["COMMENT"]; $field=array(); $field["ID"]=$key; $field["NAME"]=$this->t_fields[$key]["NAME"]; $field_name=$field["NAME"]; $values = array(); if($val["NAME"] == $field_name) { global ${$field_name}; $value=${$field_name}; for ($i=0; $iprefix; $field["OPTIONS"]=$this->t_fields[$key]["OPTIONS"]; eval("\$aff=".$aff_list_empr_search[$this->t_fields[$key]['TYPE']]."(\$field,\$check_scripts,\$field_name);"); $t["AFF"]=$aff; $t["NAME"]=$field["NAME"]; $perso["FIELDS"][]=$t; } } return $perso; } //Lecture des champs de recherche public function read_search_fields_from_form() { $perso=array(); reset($this->t_fields); while (list($key,$val)=each($this->t_fields)) { if($this->t_fields[$key]["SEARCH"]) { $t=array(); $t["DATATYPE"]=$val["DATATYPE"]; $t["NAME"]=$val["NAME"]; $t["TITRE"]=$val["TITRE"]; $t["COMMENT"]=$val["COMMENT"]; $name = $this->t_fields[$key]["NAME"]; $values = array(); if($val["NAME"] == $name) { global ${$name}; $value=${$name}; for ($i=0; $it_fields)) { $field = $this->t_fields[$key]; $main_fields[] = array( 'var' => $field['NAME'], 'desc' => $field["TITRE"], 'children' => array( array( 'var' => $field['NAME'].".id", 'desc'=> $msg['frbr_entity_common_datasource_desc_custom_fields_id'], ), array( 'var' => $field['NAME'].".label", 'desc'=> $msg['frbr_entity_common_datasource_desc_custom_fields_label'], ), array( 'var' => $field['NAME'].".values", 'desc'=> $msg['frbr_entity_common_datasource_desc_custom_fields_values'], 'children' => array( array( 'var'=> $field['NAME'].".values[i].format_value", 'desc' => $msg['frbr_entity_common_datasource_desc_custom_fields_values_format_value'], ), array( 'var'=> $field['NAME'].".values[i].value", 'desc' => $msg['frbr_entity_common_datasource_desc_custom_fields_values_value'], ) ) ) ) ); } return $main_fields; } } ?>