"aff_text_empr","list"=>"aff_list_empr","query_list"=>"aff_query_list_empr","query_auth"=>"aff_query_auth_empr","date_box"=>"aff_date_box_empr","comment"=>"aff_comment_empr","external"=>"aff_external_empr","url"=>"aff_url_empr","resolve"=>"aff_resolve_empr"); $aff_list_empr_search=array("text"=>"aff_text_empr_search","list"=>"aff_list_empr_search","query_list"=>"aff_query_list_empr_search","query_auth"=>"aff_query_auth_empr_search","date_box"=>"aff_date_box_empr_search","comment"=>"aff_comment_empr_search","external"=>"aff_external_empr_search","url"=>"aff_url_empr_search","resolve"=>"aff_resolve_empr_search"); $aff_filter_list_empr=array("text"=>"aff_filter_text_empr","list"=>"aff_filter_list_empr","query_list"=>"aff_filter_query_list_empr","query_auth"=>"aff_filter_query_auth_empr","date_box"=>"aff_filter_date_box_empr","comment"=>"aff_filter_comment_empr","external"=>"aff_filter_external_empr","url"=>"aff_filter_resolve_empr","resolve"=>"aff_filter_resolve_empr"); $chk_list_empr=array("text"=>"chk_text_empr","list"=>"chk_list_empr","query_list"=>"chk_query_list_empr","query_auth"=>"chk_query_auth_empr","date_box"=>"chk_date_box_empr","comment"=>"chk_comment_empr","external"=>"chk_external_empr","url"=>"chk_url_empr","resolve"=>"chk_resolve_empr"); $val_list_empr=array("text"=>"val_text_empr","list"=>"val_list_empr","query_list"=>"val_query_list_empr","query_auth"=>"val_query_auth_empr","date_box"=>"val_date_box_empr","comment"=>"val_comment_empr","external"=>"val_external_empr","url"=>"val_url_empr","resolve"=>"val_resolve_empr"); $type_list_empr=array("text"=>$msg["parperso_text"],"list"=>$msg["parperso_choice_list"],"query_list"=>$msg["parperso_query_choice_list"],"query_auth"=>$msg["parperso_authorities"],"date_box"=>$msg["parperso_date"],"comment"=>$msg["parperso_comment"],"external"=>$msg["parperso_external"],"url"=>$msg["parperso_url"],"resolve"=>$msg["parperso_resolve"]); $options_list_empr=array("text"=>"options_text.php","list"=>"options_list.php","query_list"=>"options_query_list.php","query_auth"=>"options_query_authorities.php","date_box"=>"options_date_box.php","comment"=>"options_comment.php","external"=>"options_external.php","url"=>"options_url.php","resolve"=>"options_resolve.php"); // formulaire de saisie des param perso des autorités function aff_query_auth_empr($field,&$check_scripts,$script="") { global $charset; global $_custom_prefixe_; global $msg,$lang; if($field["OPTIONS"][0]["METHOD"]["0"]["value"]==1) { $text_name=$field[NAME]."_id"; $hidden_name=$field[NAME]; } else { $text_name=$field[NAME]; $hidden_name=$field[NAME]."_id"; } //pré-remplissage $param = $text_name; global $$param; switch($field["OPTIONS"][0]["DATA_TYPE"]["0"]["value"]) { case 1:$what="auteur";$completion='authors';break;//auteurs case 2:$what="categorie";$completion="categories_mul";break;//categories case 3:$what="editeur";$completion="publishers";break;//Editeurs case 4:$what="collection";$completion="collections";break;//collection case 5:$what="subcollection";$completion="subcollections";break;// subcollection case 6:$what="serie";$completion="serie";break;//Titre de serie case 7:$what="indexint";$completion="indexint"; break;// Indexation decimale case 8:$what="titre_uniforme";$completion="titre_uniforme"; break;// titre uniforme } $values=$field[VALUES]; $options=$field[OPTIONS][0]; if ($values=="") $values=array(); $caller = get_form_name(); $id_thes_unique=$field["OPTIONS"][0]["ID_THES"]["0"]["value"]; $n=count($values); $ret=""; if (($n==0)||($options[MULTIPLE][0][value]!="yes")) $n=1; if ($options[MULTIPLE][0][value]=="yes") { $readonly=''; $ret.=" "; } $ret.="\n
"; $readonly=''; $val_dyn=3; for ($i=0; $i<$n; $i++) { $id=$values[$i]; $isbd=""; if($id){ switch($field["OPTIONS"][0]["DATA_TYPE"]["0"]["value"]) { case 1:// auteur $aut = new auteur($id); $isbd=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 2:// categories $isbd=html_entity_decode(categories::listAncestorNames($id,$lang),ENT_QUOTES, $charset); break; case 3:// Editeur $aut = new editeur($id); $isbd=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 4:// collection $aut = new collection($id); $isbd=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 5:// subcollection $aut = new subcollection($id); $isbd=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 6:// Titre de serie $aut = new serie($id); $isbd=html_entity_decode($aut->name,ENT_QUOTES, $charset); break; case 7:// Indexation decimale $aut = new indexint($id); $isbd=html_entity_decode($aut->display,ENT_QUOTES, $charset); break; case 8:// titre uniforme $aut = new titre_uniforme($id); $isbd=html_entity_decode($aut->libelle,ENT_QUOTES, $charset); break; } } $ret.="\n"; $ret.=""; $ret.="\n"; if (($i==0)) { if ($options[MULTIPLE][0][value]=="yes") { $ret.=""; $ret.=" "; }else { $ret.=""; } } $ret.="
"; } $ret.="
"; return $ret; } function aff_query_auth_empr_search($field,&$check_scripts,$varname) { global $msg,$lang, $categ,$charset; if($field["OPTIONS"][0]["METHOD"]["0"]["value"]==1) { $text_name=$field[NAME]."_id"; $hidden_name=$field[NAME]; } else { $text_name=$field[NAME]; $hidden_name=$field[NAME]."_id"; } $id=$field[VALUES][0]; //pré-remplissage $param = $text_name; global $$param; switch($field["OPTIONS"][0]["DATA_TYPE"]["0"]["value"]) { case 1:$what="auteur";$completion='authors';break;//auteurs case 2:$what="categorie";$completion="categories_mul";break;//categories case 3:$what="editeur";$completion="publishers";break;//Editeurs case 4:$what="collection";$completion="collections";break;//collection case 5:$what="subcollection";$completion="subcollections";break;// subcollection case 6:$what="serie";$completion="serie";break;//Titre de serie case 7:$what="indexint";$completion="indexint"; break;// Indexation decimale case 8:$what="titre_uniforme";$completion="titre_uniforme"; break;// titre uniforme } $libelle=""; if($id){ switch($field["OPTIONS"][0]["DATA_TYPE"]["0"]["value"]) { case 1: $aut = new auteur($id); $isbd=$aut->isbd_entry; break; case 2: $isbd=categories::listAncestorNames($id,$lang); print $isbd; break; case 3: $aut=new editeur($id); $isbd=$aut->isbd_entry; break; case 4: $aut = new collection($id); $isbd=$aut->isbd_entry; break; case 5: $aut = new subcollection($id); $isbd=$aut->isbd_entry; break; case 6: $aut = new serie($id); $isbd=$aut->name; break; case 7: $aut = new indexint($id); $isbd=$aut->display; break; case 8: $aut = new titre_uniforme($id); $isbd=$aut->libelle; break; } $libelle=html_entity_decode($isbd,ENT_QUOTES, $charset); } $ret=""; switch ($categ) { case "planificateur" : $form_name = "planificateur_form"; break; default : $form_name = "formulaire"; break; } $val_dyn=3; $ret.="\n"; $ret.=""; $ret.=""; $ret.=""; if ($field[MANDATORY]=="yes") $check_scripts.="if (document.".$form_name.".".$field[NAME].".value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS][0][value])."\");\n"; return $ret; } // Sauvegarde du formulaire function chk_query_auth_empr($field,&$check_message) { global $charset; global $msg; $name=$field[NAME]; $options=$field[OPTIONS][0]; global $$name; $val=array(); $nn="n_".$name; global $$nn; $n=$$nn; for ($i=0; $i<$n; $i++) { $v=$field["NAME"]."_".$i; global $$v; if ($$v!="") { $val[]=$$v; }elseif($options["INSERTAUTHORIZED"][0]["value"]=="yes"){ $v2="f_".$v; global $$v2; if ($$v2!="") { $val[]=$$v2; } } } if (count($val)==0) unset($val); if ($field[MANDATORY]==1) { if ((!isset($val))||((count($val)==1)&&($val[0]==""))) { $check_message=sprintf($msg["parperso_field_is_needed"],$field[ALIAS]); return 0; } } $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } // affichage de l'autorité function val_query_auth_empr($field) { global $lang,$pmb_perso_sep,$charset; $name=$field[NAME]; $options=$field[OPTIONS][0]; $isbd_s=array(); if(!$field[VALUES])return ""; foreach($field[VALUES] as $id){ if($id) switch($field["OPTIONS"][0]["DATA_TYPE"]["0"]["value"]) { case 1:// auteur $aut = new auteur($id); $isbd_s[]=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 2:// categories $isbd_s[]=html_entity_decode(categories::listAncestorNames($id,$lang),ENT_QUOTES, $charset); break; case 3:// Editeur $aut = new editeur($id); $isbd_s[]=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 4:// collection $aut = new collection($id); $isbd_s[]=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 5:// subcollection $aut = new subcollection($id); $isbd_s[]=html_entity_decode($aut->isbd_entry,ENT_QUOTES, $charset); break; case 6:// Titre de serie $aut = new serie($id); $isbd_s[]=html_entity_decode($aut->name,ENT_QUOTES, $charset); break; case 7:// Indexation decimale $aut = new indexint($id); $isbd_s[]=html_entity_decode($aut->display,ENT_QUOTES, $charset); break; case 8:// titre uniforme $aut = new titre_uniforme($id); $isbd_s[]=html_entity_decode($aut->libelle,ENT_QUOTES, $charset); break; } } $aff=implode($pmb_perso_sep,$isbd_s); return $aff; } function chk_datatype($field,$values,&$check_datatype_message) { global $chk_type_list; global $msg; //Nettoyage des valeurs vides if(isset($values)) { $chk_values = array(); foreach ($values as $val) { if ($val != "") $chk_values[] = $val; } $values = $chk_values; } if (((!isset($values))||((count($values)==1)&&($values[0]=="")))&&($field[MANDATORY]!=1)) return $values; for ($i=0; $i=20) { $pos=strrpos(substr($valeur,0,20)," "); if ($pos) { $valeur=substr($valeur,0,$pos+1)."..."; } else $valeur=substr($valeur,0,20)."..."; } return $valeur; } function aff_date_box_empr($field,&$check_scripts) { global $charset; global $msg; global $base_path; $values=$field[VALUES]; $d=explode("-",$values[0]); $options=$field[OPTIONS][0]; if ((!@checkdate($d[1],$d[2],$d[0]))&&(!$options["DEFAULT_TODAY"][0]["value"])) { $val=date("Y-m-d",time()); $val_popup=date("Ymd",time()); } else if ((!@checkdate($d[1],$d[2],$d[0]))&&($options["DEFAULT_TODAY"][0]["value"])) { $val_popup=""; $val=""; } else { $val_popup=$d[0].$d[1].$d[2]; $val=$values[0]; } $ret="   "; if ($field[MANDATORY]==1) { $caller = get_form_name(); $check_scripts.="if (document.forms[\"".$caller."\"].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n"; } return $ret; } function aff_date_box_empr_search($field,&$check_scripts,$varname) { global $charset; global $msg; $values=$field[VALUES]; $d=explode("-",$values[0]); if (!@checkdate($d[1],$d[2],$d[0])) { $val=date("Y-m-d",time()); $val_popup=date("Ymd",time()); } else { $val_popup=$d[0].$d[1].$d[2]; $val=$values[0]; } $ret=" "; return $ret; } function chk_date_box_empr($field,&$check_message) { $name=$field[NAME]; global $$name; $val=$$name; $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } function val_date_box_empr($field,$value) { global $charset; if ($value[0]=="0000-00-00") $value[0]=""; if ($value) $value=format_output($field,$value); return $value[0]; } function aff_text_empr($field,&$check_scripts) { global $charset; global $msg; $options=$field[OPTIONS][0]; $values=$field[VALUES]; $afield_name = $field["ID"]; $ret = ""; $count = 0; if (!$values) { $values = array(""); } foreach ($values as $avalues) { $ret.=""; if ($options[REPEATABLE][0][value] && !$count) $ret.=''; $ret.="
"; $count++; } if ($options[REPEATABLE][0][value]) { $ret.=''; //$ret.=''; $ret .= '
'; $ret.=""; } if ($field[MANDATORY]==1) { $caller = get_form_name(); $check_scripts.="if (document.forms[\"".$caller."\"].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n"; } return $ret; } function aff_text_empr_search($field,&$check_scripts,$varname) { global $charset; global $msg; $options=$field[OPTIONS][0]; $values=$field[VALUES]; $ret=""; return $ret; } function chk_text_empr($field,&$check_message) { $name=$field[NAME]; global $$name; $val=$$name; $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } function val_text_empr($field,$value) { global $charset,$pmb_perso_sep; $value=format_output($field,$value); if (!$value) $value=array(); if($field["OPTIONS"][0]["ISHTML"][0]["value"]){ return array("ishtml" => true, "value"=>implode($pmb_perso_sep,$value), "withoutHTML" =>implode($pmb_perso_sep,$value)); }else{ return implode($pmb_perso_sep,$value); } } function aff_comment_empr($field,&$check_scripts) { global $charset; global $msg; $options=$field[OPTIONS][0]; $values=$field[VALUES]; $ret=""; if ($field[MANDATORY]==1) { $caller = get_form_name(); $check_scripts.="if (document.forms[\"".$caller."\"].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n"; } return $ret; } function aff_comment_empr_search($field,&$check_scripts,$varname) { global $charset; global $msg; $options=$field[OPTIONS][0]; $values=$field[VALUES]; $ret=""; return $ret; } function chk_comment_empr($field,&$check_message) { $name=$field[NAME]; global $$name; $val=$$name; $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } function val_comment_empr($field,$value) { global $charset; $value=format_output($field,$value); if($field["OPTIONS"][0]["ISHTML"][0]["value"]){ return array("ishtml" => true, "value"=>$value[0], "withoutHTML" =>$value[0]); }else{ return $value[0]; } } function aff_list_empr($field,&$check_scripts,$script="") { global $charset; global $_custom_prefixe_; $_custom_prefixe_=$field["PREFIX"]; $options=$field[OPTIONS][0]; $values=$field[VALUES]; if ($values=="") $values=array(); if ($options["AUTORITE"][0]["value"]!="yes") { if ($options["CHECKBOX"][0]["value"]=="yes"){ if ($options[MULTIPLE][0][value]=="yes") $type = "checkbox"; else $type = "radio"; $ret=""; if (($options[UNSELECT_ITEM][0][VALUE]!="")&&($options[UNSELECT_ITEM][0][value]!="")) { $ret.= " ".$options[UNSELECT_ITEM][0][value].""; } $requete="select ".$_custom_prefixe_."_custom_list_value, ".$_custom_prefixe_."_custom_list_lib from ".$_custom_prefixe_."_custom_lists where ".$_custom_prefixe_."_custom_champ=".$field[ID]." order by ordre"; $resultat=mysql_query($requete); if ($resultat) { $i=0; while ($r=mysql_fetch_array($resultat)) { $ret.= " ".$r[$_custom_prefixe_."_custom_list_lib"].""; $i++; } } }else{ $ret="\n"; } }else { $caller = get_form_name(); if ($values) { $values_received=$values; $values=array(); $libelles=array(); $requete="select ".$_custom_prefixe_."_custom_list_value, ".$_custom_prefixe_."_custom_list_lib from ".$_custom_prefixe_."_custom_lists where ".$_custom_prefixe_."_custom_champ=".$field[ID]." order by ordre"; $resultat=mysql_query($requete); $i=0; while ($r=mysql_fetch_array($resultat)) { $as=array_search($r[$_custom_prefixe_."_custom_list_value"],$values_received); if (($as!==null)&&($as!==false)) { $values[$i]=$r[$_custom_prefixe_."_custom_list_value"]; $libelles[$i]=$r[$_custom_prefixe_."_custom_list_lib"]; $i++; } } } else { //Recherche de la valeur par défaut if ($options[DEFAULT_VALUE][0][value]) { $requete="select ".$_custom_prefixe_."_custom_list_value, ".$_custom_prefixe_."_custom_list_lib from ".$_custom_prefixe_."_custom_lists where ".$_custom_prefixe_."_custom_champ=".$field[ID]." and ".$_custom_prefixe_."_custom_list_value=".$options[DEFAULT_VALUE][0][value]." order by ordre"; $resultat=mysql_query($requete); while ($r=mysql_fetch_array($resultat)) { $values[0]=$r[$_custom_prefixe_."_custom_list_value"]; $libelles[0]=$r[$_custom_prefixe_."_custom_list_lib"]; } } } $readonly=''; $n=count($values); if(($options[MULTIPLE][0][value]=="yes") ) $val_dyn=1; else $val_dyn=0; if (($n==0)||($options[MULTIPLE][0][value]!="yes")) $n=1; if ($options[MULTIPLE][0][value]=="yes") { $readonly=''; $ret.=" "; } $ret.="\n
"; $readonly=''; for ($i=0; $i<$n; $i++) { $ret.="\n"; $ret.=""; $ret.=" \n"; if (($i==0)&&($options[MULTIPLE][0][value]=="yes")) { $ret.=" "; } $ret.="
"; } $ret.="
"; } return $ret; } function aff_list_empr_search($field,&$check_scripts,$varname,$script="") { global $charset; $_custom_prefixe_=$field["PREFIX"]; $options=$field[OPTIONS][0]; $values=$field[VALUES]; if ($values=="") $values=array(); $ret="\n"; return $ret; } function aff_empr_search($field) { $table = array(); $table['label'] = $field['TITRE']; $table['name'] = $field['NAME']; $table['type'] =$field['DATATYPE']; $_custom_prefixe_=$field['PREFIX']; $requete="select ".$_custom_prefixe_."_custom_list_value, ".$_custom_prefixe_."_custom_list_lib from ".$_custom_prefixe_."_custom_lists where ".$_custom_prefixe_."_custom_champ=".$field[ID]." order by ordre"; $resultat=mysql_query($requete); if ($resultat) { while ($r=mysql_fetch_array($resultat)) { $value['value_id']=$r[$_custom_prefixe_."_custom_list_value"]; $value['value_caption']=$r[$_custom_prefixe_."_custom_list_lib"]; $table['values'][]=$value; } }else{ $table['values'] = array(); } return $table; } function chk_list_empr($field,&$check_message) { global $charset; global $msg; $name=$field[NAME]; $options=$field[OPTIONS][0]; global $$name; if ($options["AUTORITE"][0]["value"]!="yes") { $val=$$name; } else { $val=array(); $nn="n_".$name; global $$nn; $n=$$nn; for ($i=0; $i<$n; $i++) { $v=$field["NAME"]."_".$i; global $$v; if ($$v!="") { $val[]=$$v; } } if (count($val)==0) unset($val); } if ($field[MANDATORY]==1) { if ((!isset($val))||((count($val)==1)&&($val[0]==""))) { $check_message=sprintf($msg["parperso_field_is_needed"],$field[ALIAS]); return 0; } } $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } function val_list_empr($field,$val) { global $charset,$pmb_perso_sep; global $options_; $_custom_prefixe_=$field["PREFIX"]; if ($val=="") return ""; if (!$options_[$_custom_prefixe_][$field[ID]]) { $requete="select ".$_custom_prefixe_."_custom_list_value, ".$_custom_prefixe_."_custom_list_lib from ".$_custom_prefixe_."_custom_lists where ".$_custom_prefixe_."_custom_champ=".$field[ID]." order by ordre"; $resultat=mysql_query($requete); if ($resultat) { $i=0; while ($r=mysql_fetch_array($resultat)) { $options_[$_custom_prefixe_][$field[ID]][$r[$_custom_prefixe_."_custom_list_value"]]=$r[$_custom_prefixe_."_custom_list_lib"]; $i++; } } } if (!is_array($options_[$_custom_prefixe_][$field[ID]])) return ""; $exec_func_array_flip = true; foreach ($val as $key=>$value) { if ($value == "") $exec_func_array_flip = false; } if ($exec_func_array_flip) $val_r=array_flip($val); else $val_r=array(); $val_c=array_intersect_key($options_[$_custom_prefixe_][$field[ID]],$val_r); if ($val_c=="") $val_c=array(); $val_=implode($pmb_perso_sep,$val_c); return $val_; } function aff_query_list_empr($field,&$check_scripts,$script="") { global $charset; global $_custom_prefixe_; $values=$field[VALUES]; $options=$field[OPTIONS][0]; if ($values=="") $values=array(); if ($options["AUTORITE"][0]["value"]!="yes") { if ($options["CHECKBOX"][0]["value"]=="yes"){ if ($options[MULTIPLE][0][value]=="yes") $type = "checkbox"; else $type = "radio"; $resultat=mysql_query($options[QUERY][0][value]); if ($resultat) { $i=0; $ret=""; $limit = $options[CHECKBOX_NB_ON_LINE][0][value]; if($limit==0) $limit = 4; while ($r=mysql_fetch_array($resultat)) { if ($i>0 && $i%$limit == 0)$ret.=""; $ret.= ""; $i++; } $ret.="
 ".$r[1]."
"; } } else { $options=$field[OPTIONS][0]; $ret="\n"; } else { $caller = get_form_name(); if ($values) { $values_received=$values; $values_received_bis=$values; $values=array(); $libelles=array(); $resultat=mysql_query($options[QUERY][0][value]); $i=0; while ($r=mysql_fetch_row($resultat)) { $as=array_search($r[0],$values_received); if (($as!==null)&&($as!==false)) { $values[$i]=$r[0]; $libelles[$i]=$r[1]; $i++; unset($values_received_bis[$as]); } } if ($options["INSERTAUTHORIZED"][0]["value"]=="yes") { foreach ($values_received_bis as $key=>$val) { $values[$i]=""; $libelles[$i]=$val; $i++; } } } $n=count($values); if(($options[MULTIPLE][0][value]=="yes") ) $val_dyn=1; else $val_dyn=0; if (($n==0)||($options[MULTIPLE][0][value]!="yes")) $n=1; if ($options[MULTIPLE][0][value]=="yes") { // $readonly="f_perso.setAttribute('readonly','');"; // if($options["INSERTAUTHORIZED"][0]["value"]=="yes"){ // $readonly=""; // } $readonly=''; $ret.=" "; } $ret.="\n
"; // $readonly="readonly"; // if($options["INSERTAUTHORIZED"][0]["value"]=="yes"){ // $readonly=""; // } $readonly=''; for ($i=0; $i<$n; $i++) { $ret.="\n"; $ret.=""; $ret.=" \n"; if (($i==0)&&($options[MULTIPLE][0][value]=="yes")) { $ret.=" "; } $ret.="
"; } $ret.="
"; } return $ret; } function aff_query_list_empr_search($field,&$check_scripts,$varname,$script="") { global $charset; $values=$field[VALUES]; if ($values=="") $values=array(); $options=$field[OPTIONS][0]; $ret="\n"; return $ret; } function chk_query_list_empr($field,&$check_message) { global $charset; global $msg; $name=$field[NAME]; $options=$field[OPTIONS][0]; global $$name; if ($options["AUTORITE"][0]["value"]!="yes") { $val=$$name; } else { $val=array(); $nn="n_".$name; global $$nn; $n=$$nn; for ($i=0; $i<$n; $i++) { $v=$field["NAME"]."_".$i; global $$v; if ($$v!="") { $val[]=$$v; }elseif($options["INSERTAUTHORIZED"][0]["value"]=="yes"){ $v2="f_".$v; global $$v2; if ($$v2!="") { $val[]=$$v2; } } } if (count($val)==0) unset($val); } if ($field[MANDATORY]==1) { if ((!isset($val))||((count($val)==1)&&($val[0]==""))) { $check_message=sprintf($msg["parperso_field_is_needed"],$field[ALIAS]); return 0; } } $check_datatype_message=""; $val_1=chk_datatype($field,$val,$check_datatype_message); if ($check_datatype_message) { $check_message=$check_datatype_message; return 0; } $$name=$val_1; return 1; } function val_query_list_empr($field,$val) { global $charset,$pmb_perso_sep; if ($val=="") return ""; $val_c=""; if (($field["OPTIONS"][0]["FIELD0"][0]["value"])&&($field["OPTIONS"][0]["FIELD1"][0]["value"])&&($field["OPTIONS"][0]["OPTIMIZE_QUERY"][0]["value"]=="yes")) { $val_ads=array_map("addslashes",$val); $requete="select * from (".$field[OPTIONS][0][QUERY][0][value].") as sub1 where ".$field["OPTIONS"][0]["FIELD0"][0]["value"]." in (BINARY '".implode("',BINARY '",$val_ads)."')"; $resultat=mysql_query($requete); if ($resultat && mysql_num_rows($resultat)) { while ($r=mysql_fetch_row($resultat)) { $val_c[]=$r[1]; } } } else { $resultat=mysql_query($field[OPTIONS][0][QUERY][0][value]); if($resultat && mysql_num_rows($resultat)){ while ($r=mysql_fetch_row($resultat)) { $options_[$r[0]]=$r[1]; } } for ($i=0; $i\n"; } $resultat=mysql_query($options[QUERY][0][value]); while ($r=mysql_fetch_row($resultat)) { $ret.="