"aff_text_empr","list"=>"aff_list_empr","query_list"=>"aff_query_list_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","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");
$chk_list_empr=array("text"=>"chk_text_empr","list"=>"chk_list_empr","query_list"=>"chk_query_list_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","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"],"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","date_box"=>"options_date_box.php","comment"=>"options_comment.php","external"=>"options_external.php","url"=>"options_url.php","resolve"=>"options_resolve.php");
function chk_datatype($field,$values,&$check_datatype_message) {
global $chk_type_list;
global $msg;
if (((!isset($values))||((count($values)==1)&&($values[0]=="")))&&($field[MANDATORY]!=1)) return $values;
for ($i=0; $i ".$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="".htmlentities($options[UNSELECT_ITEM][0][value],ENT_QUOTES,$charset)."\n";
}
$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[ITEMS][0][ITEM][$i][VALUE]=$r[$_custom_prefixe_."_custom_list_value"];
$options[ITEMS][0][ITEM][$i][value]=$r[$_custom_prefixe_."_custom_list_lib"];
$i++;
}
}
for ($i=0; $i\n";
}
$ret.= " \n";
}
}else {
// $caller="";
// switch ($_custom_prefixe_) {
// case "empr":
// $caller="empr_form";
// break;
// case "notices":
// $caller="notice";
// break;
// case "expl":
// $caller="expl";
// break;
// case "gestfic0": // a modifier lorsque il y aura du multi fiches!
// $caller="formulaire";
// break;
// }
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++;
}
}
}
$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.="";
$readonly='';
for ($i=0; $i<$n; $i++) {
$ret.="
";
}
return $ret;
}
function aff_list_empr_search($field,&$check_scripts,$varname) {
global $charset;
$_custom_prefixe_=$field["PREFIX"];
$options=$field[OPTIONS][0];
$values=$field[VALUES];
if ($values=="") $values=array();
$ret="".htmlentities($options[UNSELECT_ITEM][0][value],ENT_QUOTES,$charset)."\n";
}
$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[ITEMS][0][ITEM][$i][VALUE]=$r[$_custom_prefixe_."_custom_list_value"];
$options[ITEMS][0][ITEM][$i][value]=$r[$_custom_prefixe_."_custom_list_lib"];
$i++;
}
}
for ($i=0; $i\n";
}
$ret.= " \n";
return $ret;
}
function chk_list_empr($field,&$check_message) {
global $charset;
global $msg;
$name=$field[NAME];
global $$name;
$val=$$name;
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) {
while ($r=mysql_fetch_array($resultat)) {
$options_[$_custom_prefixe_][$field[ID]][$r[$_custom_prefixe_."_custom_list_value"]]=$r[$_custom_prefixe_."_custom_list_lib"];
}
}
}
if (!is_array($options_[$_custom_prefixe_][$field[ID]])) return "";
$val_r=array_flip($val);
$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="";
}
} else {
$options=$field[OPTIONS][0];
$ret="".htmlentities($options[UNSELECT_ITEM][0][value],ENT_QUOTES,$charset)."\n";
}
$resultat=mysql_query($options[QUERY][0][value]);
while ($r=mysql_fetch_row($resultat)) {
$ret.="\n";
}
}
$ret.= " \n";
} else {
// $caller="";
// switch ($_custom_prefixe_) {
// case "empr":
// $caller="empr_form";
// break;
// case "notices":
// $caller="notice";
// break;
// case "expl":
// $caller="expl";
// break;
// case "gestfic0": // a modifier lorsque il y aura du multi fiches!
// $caller="formulaire";
// break;
// }
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.="";
// $readonly="readonly";
// if($options["INSERTAUTHORIZED"][0]["value"]=="yes"){
// $readonly="";
// }
$readonly='';
for ($i=0; $i<$n; $i++) {
$ret.="
";
}
return $ret;
}
function aff_query_list_empr_search($field,&$check_scripts,$varname) {
global $charset;
$values=$field[VALUES];
if ($values=="") $values=array();
$options=$field[OPTIONS][0];
$ret="".htmlentities($options[UNSELECT_ITEM][0][value],ENT_QUOTES,$charset)."\n";
}
$resultat=mysql_query($options[QUERY][0][value]);
while ($r=mysql_fetch_row($resultat)) {
$ret.="\n";
}
$ret.= " \n";
return $ret;
}
function chk_query_list_empr($field,&$check_message) {
global $charset;
global $msg;
$name=$field[NAME];
global $$name;
$val=$$name;
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) {
while ($r=mysql_fetch_row($resultat)) {
$val_c[]=$r[1];
}
}
} else {
$resultat=mysql_query($field[OPTIONS][0][QUERY][0][value]);
while ($r=mysql_fetch_row($resultat)) {
$options_[$r[0]]=$r[1];
}
for ($i=0; $i";
if (!$options["HIDE"][0]["value"]) {
$ret.="
';
$ret.="";
}
if ($field[MANDATORY]==1) $check_scripts.="if (document.forms[0].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n";
return $ret;
}
function aff_url_empr_search($field,&$check_scripts,$varname) {
global $charset;
global $msg;
$options=$field[OPTIONS][0];
$values=$field[VALUES];
$ret=" $cut ? substr($val[0],0,$cut)."[...]" : $val[0] );
if( $ret != "") $ret.= " / ";
$ret .= "".htmlentities($lib,ENT_QUOTES,$charset)." ";
if( $without != "") $without.= " / ";
$without .= $lib;
}
return array("ishtml" => true, "value"=>$ret, "withoutHTML" =>$without);
}
function aff_resolve_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) {
$avalues = explode("|",$avalues);
$ret.="";
foreach($options[RESOLVE] as $elem){
$ret.= "
".htmlentities($elem[LABEL],ENT_QUOTES,$charset)." ";
}
$ret.="
";
if ($options[REPEATABLE][0][value] && !$count)
$ret.='
';
$ret.="";
}
if ($field[MANDATORY]==1) $check_scripts.="if (document.forms[0].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n";
return $ret;
}
function chk_resolve_empr($field,&$check_message) {
$name=$field[NAME];
global $$name;
$val=$$name;
$value = array();
for($i=0;$i1){
$id =$val[0];
foreach ($options[RESOLVE] as $res){
if($res[ID] == $val[1]){
$label = $res[LABEL];
$url= $res[value];
break;
}
}
$link = str_replace("!!id!!",$id,$url);
if( $ret != "") $ret.= " / ";
//$ret.= "".htmlentities($link,ENT_QUOTES,$charset)." ";
$ret.= htmlentities($label,ENT_QUOTES,$charset)." : $id ".htmlentities($values[0],ENT_QUOTES,$charset)."
";
$check_scripts.= "
if(document.forms[0].elements['".$field[NAME]."[]']) document.forms[0].elements['".$field[NAME]."[]'].value = dijit.byId('".$field[NAME]."').get('value');";
if ($field[MANDATORY]==1) $check_scripts.="if (document.forms[0].elements[\"".$field[NAME]."[]\"].value==\"\") return cancel_submit(\"".sprintf($msg["parperso_field_is_needed"],$field[ALIAS])."\");\n";
return $ret;
}
";
}else{
$without=implode($pmb_perso_sep,$value);
}
}
return array("ishtml" => true, "value"=>$ret,"withoutHTML"=> $without);
}
function aff_resolve_empr_search($field,&$check_scripts,$varname){
global $charset;
global $msg;
$options=$field[OPTIONS][0];
$values=$field[VALUES];
$ret="";
return $ret;
}
function aff_html_empr($field,&$check_scripts) {
global $charset;
global $msg;
global $cms_dojo_plugins_editor;
$options=$field[OPTIONS][0];
$values=$field[VALUES];
$ret="