"; //Pour la sélection par "country" /*$q="SELECT num_noeud, libelle_categorie FROM noeuds join categories on num_noeud=id_noeud and num_parent!=42 WHERE libelle_categorie NOT LIKE '~%' AND langue = 'en_UK' ORDER BY libelle_categorie"; $r=mysql_query($q,$dbh); $unc_aff.=""; //Pour la sélection par "applicable NYC provisions" $q="select notices_custom_list_value,notices_custom_list_lib from notices_custom_lists where notices_custom_champ='10' order by ordre"; $r=mysql_query($q,$dbh); $unc_aff.="";*/ //Pour la selection par "country" avec liste de checkbox $q="SELECT num_noeud, libelle_categorie FROM noeuds join categories on num_noeud=id_noeud and num_parent!=42 WHERE libelle_categorie NOT LIKE '~%' AND langue = 'en_UK' ORDER BY libelle_categorie"; $r=mysql_query($q,$dbh); $unc_aff.=""; //Pour la sélection par "applicable NYC provisions" $q="select notices_custom_list_value,notices_custom_list_lib from notices_custom_lists where notices_custom_champ='10' order by ordre"; $r=mysql_query($q,$dbh); $unc_aff.=""; //Pour la sélection "Search in attachments" $unc_aff.="

"; $unc_aff.="

"; $unc_aff.="

"; $unc_aff.="
    " ; if (mysql_num_rows($r)) { while (($row = mysql_fetch_object($r))) { $checked=''; if (in_array($row->num_noeud, $unc_country)) { $checked="checked='checked' "; } $unc_aff.= "
  • "; } } $unc_aff.="

"; $unc_aff.="
    " ; if (mysql_num_rows($r)) { while (($row = mysql_fetch_object($r))) { $checked=''; if (in_array($row->notices_custom_list_value,$unc_applicable)) { $checked="checked='checked' "; } $unc_aff.= "
  • "; } } $unc_aff.="
libelle_categorie; } } if (count($app)) $ret.="Country : ".implode(' or ',$app); $app=array(); if ($provision) { $requete="select cms_editorial_custom_integer from cms_editorial_custom_values where cms_editorial_custom_origine=$provision"; $r=mysql_query($requete); if (mysql_num_rows($r)) $unc_applicable=array(mysql_result($r,0,0)); } if (count($unc_applicable)) { $q="select notices_custom_list_lib from notices_custom_lists where notices_custom_champ='10' and notices_custom_list_value in (".implode(',',$unc_applicable).") "; $r=mysql_query($q,$dbh); if (mysql_num_rows($r)) { while($row=mysql_fetch_object($r)) $app[] = $row->notices_custom_list_lib; } } if($ret && $app) $ret.=", "; if (count($app)) $ret.="Applicable NYC provision : ".implode(' or ',$app); if ($ret && $unc_docnum) $ret.=". "; if ($unc_docnum) $ret.="Attachment : ".implode(' or ',$unc_docnum); if ($type_date && $ret) $ret .= ", "; if ($type_date*1 == 1) $ret .= "By date : ".$date_decision; if ($type_date*1 == 2) $ret .= "By year : ".$date_decisiony; if ($type_date*1 == 3) $ret .= "By period : from ".$date_decision1." to ".$date_decision2; return $ret; } function search_other_function_post_values() { global $unc_country,$unc_applicable,$jurisdiction,$provision,$unc_docnum,$type_date,$date_decision,$date_decisiony,$date_decision1,$date_decision2; $retour=''; if (is_array($unc_country) && count($unc_country)) { foreach($unc_country as $v) { $retour.= "\n"; } } if (is_array($unc_applicable) && count($unc_applicable)) { foreach($unc_applicable as $v) { $retour.= "\n"; } } if ($jurisdiction*1) { $retour.= "\n"; } if ($provision*1) { $retour.= "\n"; } if (is_array($unc_docnum) && count($unc_docnum)) { foreach($unc_docnum as $v) { $retour.= "\n"; } } if ($type_date*1) { $retour .= "\n "; } if ($date_decisiony*1) { $retour .= "\n"; } return $retour; }