";
$tpl_vue_facettes = str_replace('!!id!!',$row->id_facette, $tpl_vue_facettes);
$i++;
}
$tpl_vue_facettes = str_replace('!!lst_facette!!', $lst, $tpl_vue_facettes);
return $tpl_vue_facettes;
}
public static function facette_up($id){
$requete="select facette_order from facettes where id_facette=$id";
$resultat=pmb_mysql_query($requete);
$ordre=pmb_mysql_result($resultat,0,0);
$requete="select max(facette_order) as ordre from facettes where facette_order<$ordre";
$resultat=pmb_mysql_query($requete);
$ordre_max=@pmb_mysql_result($resultat,0,0);
if ($ordre_max) {
$requete="select id_facette from facettes where facette_order=$ordre_max limit 1";
$resultat=pmb_mysql_query($requete);
$id_facette_max=pmb_mysql_result($resultat,0,0);
$requete="update facettes set facette_order='".$ordre_max."' where id_facette=$id";
pmb_mysql_query($requete);
$requete="update facettes set facette_order='".$ordre."' where id_facette=".$id_facette_max;
pmb_mysql_query($requete);
}
}
public static function facette_down($id){
$requete="select facette_order from facettes where id_facette=$id";
$resultat=pmb_mysql_query($requete);
$ordre=pmb_mysql_result($resultat,0,0);
$requete="select min(facette_order) as ordre from facettes where facette_order>$ordre";
$resultat=pmb_mysql_query($requete);
$ordre_min=@pmb_mysql_result($resultat,0,0);
if ($ordre_min) {
$requete="select id_facette from facettes where facette_order=$ordre_min limit 1";
$resultat=pmb_mysql_query($requete);
$id_facette_min=pmb_mysql_result($resultat,0,0);
$requete="update facettes set facette_order='".$ordre_min."' where id_facette=$id";
pmb_mysql_query($requete);
$requete="update facettes set facette_order='".$ordre."' where id_facette=".$id_facette_min;
pmb_mysql_query($requete);
}
}
public static function facette_order_by_name(){
$query = "SELECT id_facette FROM facettes order by facette_name";
$result = pmb_mysql_query($query);
$i=1;
while($row = pmb_mysql_fetch_object($result)){
pmb_mysql_query("UPDATE facettes SET facette_order='".$i."' where id_facette=".$row->id_facette);
$i++;
}
}
public function fields_sort(){
global $msg;
$array_sort = array();
for($i=0;$itype]['FIELD']);$i++){
if($tmp= $msg[self::$fields[$this->type]['FIELD'][$i]['NAME']]){
$lib = $tmp;
}else{
$lib = self::$fields[$this->type]['FIELD'][$i]['NAME'];
}
$array_sort[self::$fields[$this->type]['FIELD'][$i]['ID']+0] = $lib;
}
asort($array_sort);
return $array_sort;
}
public function array_subfields($id){
global $msg,$charset;
$array_subfields = array();
if($id == 100) {
$result = pmb_mysql_query("select idchamp,titre from notices_custom order by titre asc");
while($row=pmb_mysql_fetch_object($result)){
$array_subfields[$row->idchamp] = $row->titre;
}
} elseif($id > 1000) {
$array_subfields[0] = $msg['facette_isbd'];
$result = pmb_mysql_query("select idchamp,titre from authperso_custom where num_type='".($id-1000)."' order by titre asc");
while($row=pmb_mysql_fetch_object($result)){
$array_subfields[$row->idchamp] = $row->titre;
}
} else {
$array = array();
for($i = 0; $i < count(self::$fields[$this->type]['FIELD']); $i++) {
if(self::$fields[$this->type]['FIELD'][$i]['ID']==$id) {
$isbd=self::$fields[$this->type]['FIELD'][$i]['ISBD'];
$array = self::$fields[$this->type]['FIELD'][$i]['TABLE'][0]['TABLEFIELD'];
break;
}
}
for($i=0;$i