|
id_facette."'\"/>
id_facette."'\"/>
|
".htmlentities($row->facette_name,ENT_QUOTES,$charset)." | ";
if($row->facette_critere > 1000) {
$authperso_query = "select authperso_name from authperso where id_authperso =".($row->facette_critere - 1000);
$authperso_result = pmb_mysql_query($authperso_query);
$lst .= "";
if (pmb_mysql_num_rows($authperso_result)) {
$authperso_row = pmb_mysql_fetch_object($authperso_result);
$lst .= $authperso_row->authperso_name;
}
$lst .= " | ";
} else {
$lst .= "".htmlentities($fields[$row->facette_critere],ENT_QUOTES,$charset)." | ";
}
$lst .= "".(sizeof($array_subfields)>1 ? htmlentities($array_subfields[$row->facette_ss_critere],ENT_QUOTES,$charset) : $msg["admin_opac_facette_ss_critere"])." |
".($row->facette_nb_result ? $row->facette_nb_result : htmlentities($msg["admin_opac_facette_illimite"],ENT_QUOTES,$charset))." |
".($row->facette_type_sort ? $msg['intit_gest_tri2'] : $msg['intit_gest_tri1'])." ".($row->facette_order_sort ? $msg['intit_gest_tri4'] : $msg['intit_gest_tri3'])." |
".($row->facette_visible_gestion ? 'X' : '')." |
".($row->facette_visible ? 'X' : '')." |
";
$tpl_vue_facettes = str_replace('!!id!!',$row->id_facette, $tpl_vue_facettes);
$i++;
}
$tpl_vue_facettes = str_replace('!!lst_facette!!', $lst, $tpl_vue_facettes);
$tpl_vue_facettes = str_replace('!!section!!', static::$table_name, $tpl_vue_facettes);
return $tpl_vue_facettes;
}
public static function facette_up($id){
$requete="select facette_order from ".static::$table_name." where id_facette=$id";
$resultat=pmb_mysql_query($requete);
$ordre=pmb_mysql_result($resultat,0,0);
$requete="select max(facette_order) as ordre from ".static::$table_name." 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 ".static::$table_name." where facette_order=$ordre_max limit 1";
$resultat=pmb_mysql_query($requete);
$id_facette_max=pmb_mysql_result($resultat,0,0);
$requete="update ".static::$table_name." set facette_order='".$ordre_max."' where id_facette=$id";
pmb_mysql_query($requete);
$requete="update ".static::$table_name." 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 ".static::$table_name." where id_facette=$id";
$resultat=pmb_mysql_query($requete);
$ordre=pmb_mysql_result($resultat,0,0);
$requete="select min(facette_order) as ordre from ".static::$table_name." 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 ".static::$table_name." where facette_order=$ordre_min limit 1";
$resultat=pmb_mysql_query($requete);
$id_facette_min=pmb_mysql_result($resultat,0,0);
$requete="update ".static::$table_name." set facette_order='".$ordre_min."' where id_facette=$id";
pmb_mysql_query($requete);
$requete="update ".static::$table_name." 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 ".static::$table_name." order by facette_name";
$result = pmb_mysql_query($query);
$i=1;
while($row = pmb_mysql_fetch_object($result)){
pmb_mysql_query("UPDATE ".static::$table_name." SET facette_order='".$i."' where id_facette=".$row->id_facette);
$i++;
}
}
public function fields_sort(){
global $msg;
$array_sort = array();
for($i=0;$i