" .
''.
"
";
break;
case "TABLEAUCSV":
// header ("Content-Type: text/html; charset=".$charset);
header("Content-Type: application/download\n");
header("Content-Disposition: atachement; filename=\"tableau.csv\"");
break;
case "EXPORT_NOTI":
// header ("Content-Type: text/html; charset=".$charset);
header("Content-Type: application/download\n");
header("Content-Disposition: atachement; filename=\"notices.doc\"");
break;
default:
header ("Content-Type: text/html; charset=".$charset);
print $std_header."";
print "";
echo window_title($database_window_title.$msg["1100"].$msg["1003"].$msg["1001"]);
print $menu_bar;
print $extra;
print $extra2;
if($use_shortcuts) {
include("$include_path/shortcuts/circ.sht");
}
print $edit_layout;
break;
}
switch($categ) {
// EDITIONS LIEES AUX NOTICES
case "notices":
switch($sub) {
case "resa" :
default :
include("./edit/notices.inc.php");
break;
}
break;
// EDITIONS LIEES AUX EMPRUNTEURS
case "empr":
$restrict="";
switch($sub) {
case "limite" :
$titre_page = $msg["1120"].": ".$msg["edit_titre_empr_abo_limite"];
$restrict = " ((to_days(empr_date_expiration) - to_days(now()) ) <= $pmb_relance_adhesion ) and empr_date_expiration >= now() ";
include("./edit/empr_list.inc.php");
break;
case "depasse" :
$titre_page = $msg["1120"].": ".$msg["edit_titre_empr_abo_depasse"];
$restrict = " empr_date_expiration < now() ";
include("./edit/empr_list.inc.php");
break;
case "cashdesk" :
$titre_page = $msg["1120"].": ".$msg["cashdesk_edition_menu"];
include("./edit/cashdesk.inc.php");
break;
case "categ_change" :
$titre_page = $msg["1120"].": ".$msg["edit_titre_empr_categ_change"];
if (($categ_action)&&($categ_action=="change_categ_empr")) {
for ($i=0; $i 0) || (age_max <> 0)) && (age_max >= age_min)) && (((DATE_FORMAT( curdate() , '%Y' )-empr_year) < age_min) || ((DATE_FORMAT( curdate() , '%Y' )-empr_year) > age_max))) ";
include("./edit/empr_list.inc.php");
break;
//--------------------LLIUREX 08/10/2015 --------------------
case "no_migrados":
$titre_page = $msg["1120"].": ".$msg["informe_no_migrados_cab"];
$sql="SELECT column_name from INFORMATION_SCHEMA.columns where table_schema='pmb' and table_name='empr' AND column_name='empr_Migrado'";
$existeMigrado=@mysql_query($sql, $dbh);
//Si el campo empr_Tipo no existe se crea
if (@mysql_num_rows($existeMigrado)==0){
$restrict= " (ISNULL(empr_NIA) || empr_NIA='')";
include("./edit/empr_list.inc.php");
}else{
$restrict= " ((ISNULL(empr_NIA) || empr_NIA='') ||(NOT ISNULL(empr_NIA) and empr_Migrado='N'))";
include("./edit/empr_list.inc.php");
}
break;
case "duplicados":
$titre_page = $msg["1120"].": ".$msg["informe_duplicados"];
include("./edit/empr_duplicados.inc.php");
break;
//--------------------LLIUREX 08/10/2015----------------------
default :
case "encours" :
$sub = "encours" ;
$titre_page = $msg["1120"].": ".$msg["1121"];
$restrict = " empr_date_expiration >= now() ";
include("./edit/empr_list.inc.php");
break;
}
if (($sub=="limite")||($sub=="depasse")) {
if (($action)&&($action=="print_all")) {
print "";
if ($empr_relance_adhesion==1) print "";
}
}
break ;
// EDITIONS LIEES AUX PERIODIQUES
case "serials":
switch($sub) {
/* en attente d'une gestion correcte du bulletinage, actuellement absente de la base de données.
case "manquant" :
echo "".$msg["1150"]." : ".$msg["1154"]."
";
include("./edit/serials_manq.inc.php");
break;
*/
case "collect" :
default :
$sub = "collect" ;
echo "".$msg["1150"]." : ".$msg["1151"]."
";
include("./edit/serials_coll.inc.php");
break;
}
break;
// EDITIONS DES STATISTIQUES
case "procs":
switch($dest) {
case "TABLEAUCSV":
default:
include_once("./edit/procs.inc.php");
break;
}
break;
// CODES A BARRES
case "cbgen":
switch($sub) {
default :
case "libre" :
$sub = "libre" ;
echo "".$msg["1140"]." : ".$msg["1141"]."
";
include("./edit/cbgenlibre.inc.php");
break;
}
break;
//LES TRANSFERTS
case "transferts" :
require_once ("./edit/transferts.inc.php");
break;
//STATISTIQUES DE L'OPAC
case "stat_opac" :
//echo "".$msg["opac_admin_menu"]." : ".$msg["stat_opac_menu"]."
";
include("./edit/stat_opac.inc.php");
break;
// Edition Template de notices
case "tpl" :
switch($sub) {
case "notice" :
default :
echo "".$msg["edit_tpl_menu"]." : ".$msg["edit_notice_tpl_menu"]."
";
include("./edit/notice_tpl.inc.php");
break;
}
break;
case "state" :
include($base_path."/edit/editions_state/main.inc.php");
break;
// EDITIONS LIEES AUX EXEMPLAIRES
default:
case "expl":
$categ = "expl" ;
switch($sub) {
case "ppargroupe" :
$critere_requete=" order by libelle_groupe, empr_nom, empr_prenom, pret_retour ";
include("./edit/expl_groupe.inc.php");
break;
case "rpargroupe" :
$critere_requete=" and pret_retour < curdate() order by libelle_groupe, empr_nom, empr_prenom, pret_retour ";
include("./edit/expl_groupe.inc.php");
break;
case "retard" :
$titre_page = $msg[1110]." : ".$msg[1112];
$critere_requete=" and pret_retour < curdate() order by empr_nom, empr_prenom ";
include("./edit/expl.inc.php");
break;
case "retard_par_date" :
$titre_page = $msg[1110]." : ".$msg['edit_expl_retard_par_date'];
$critere_requete=" and pret_retour < curdate() order by pret_retour, empr_nom, empr_prenom ";
include("./edit/expl.inc.php");
break;
case "owner" :
$critere_requete=" order by idlender, expl_cote, expl_cb ";
include("./edit/expl_owner.inc.php");
break;
case "relance" :
include("./edit/relance.inc.php");
break;
case 'short_loans' :
$titre_page = $msg['short_loans'];
$critere_requete=" and short_loan_flag='1' order by pret_retour ";
include("./edit/expl.inc.php");
break;
case 'unreturned_short_loans' :
$titre_page = $msg['short_loans'];
$critere_requete=" and short_loan_flag='1' and pret_date < curdate() and pret_retour >= curdate() order by pret_retour ";
include("./edit/expl.inc.php");
break;
case 'overdue_short_loans' :
$titre_page = $msg['short_loans'];
$critere_requete=" and short_loan_flag='1' and pret_retour < curdate() order by pret_retour ";
include("./edit/expl.inc.php");
break;
default :
case "encours" :
$sub = "encours" ;
$titre_page = $msg[1110]." : ".$msg[1111];
$critere_requete=" order by pret_retour ";
include("./edit/expl.inc.php");
break;
}
break;
}
switch($dest) {
case "TABLEAU":
case "TABLEAUCSV":
case "EXPORT_NOTI":
break;
case "TABLEAUHTML":
print $footer;
break;
default:
print $edit_layout_end;
print $footer;
print "" ;
break;
}
mysql_close($dbh);