" .
''.
"";
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;
case "serialcirc_diff":
switch($sub) {
case "export_empr" :
default :
$serialcirc_diff=new serialcirc_diff($id_serialcirc,$num_abt);
$fname = tempnam("./temp", "$fichier_temp_nom.xls");
$workbook = new writeexcel_workbook($fname);
$worksheet = &$workbook->addworksheet();
$worksheet->write(0,0,$titre_page);
$i=0;
$j=0;
$worksheet->write(0,0,$serialcirc_diff->serial_info['serial_name']);
$worksheet->write(0,1,$serialcirc_diff->serial_info['abt_name']);
$worksheet->write(2,0,$msg["serialcirc_print_empr_name"]);
$worksheet->write(2,1,$msg["relance_export_empr_surname"]);
$worksheet->write(2,2,$msg["relance_export_empr_mail"]);
$worksheet->write(2,3,$msg["serialcirc_print_empr_cb"]);
foreach($serialcirc_diff->diffusion as $diff){
if($diff['empr_type']==SERIALCIRC_EMPR_TYPE_empr){
$worksheet->write(($i+3),$j,$serialcirc_diff->empr_info[ $diff['empr']['id_empr']]['nom']);
$worksheet->write(($i+3),$j+1,$serialcirc_diff->empr_info[ $diff['empr']['id_empr']]['prenom']);
$worksheet->write(($i+3),$j+2,$serialcirc_diff->empr_info[ $diff['empr']['id_empr']]['mail']);
$worksheet->write(($i+3),$j+3,$serialcirc_diff->empr_info[ $diff['empr']['id_empr']]['cb']);
$i++;
}else{
$group_name= $diff['empr_name'];
if(count($diff['group'])){
foreach($diff['group'] as $empr){
$resp="";
if($empr['responsable']){
$resp=$msg["serialcirc_group_responsable"];
}
$worksheet->write(($i+3),$j,$empr['empr']['nom']);
$worksheet->write(($i+3),$j+1,$empr['empr']['prenom']);
$worksheet->write(($i+3),$j+2,$empr['empr']['mail']);
$worksheet->write(($i+3),$j+3,$empr['empr']['cb']);
$worksheet->write(($i+3),$j+4,$group_name);
$worksheet->write(($i+3),$j+5,$resp);
$i++;
}
}
}
}
$workbook->close();
$fh=fopen($fname, "rb");
fpassthru($fh);
unlink($fname);
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; $iopenPopUp('./pdf.php?pdfdoc=lettre_relance_adhesion&action=print_all&empr_location_id=$empr_location_id&empr_statut_edit=$empr_statut_edit&restricts=".rawurlencode(stripslashes($restrict))."', 'lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');";
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 "simple_circ" :
echo "".$msg["1150"]." : ".$msg["serial_simple_circ_edit"]."
";
include("./edit/serials_simple_circ.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 "serialcirc" :
echo "".$msg["edit_tpl_menu"]." : ".$msg["edit_serialcirc_tpl_menu"]."
";
include("./edit/serialcirc_tpl.inc.php");
break;
case "notice" :
default :
echo "".$msg["edit_tpl_menu"]." : ".$msg["edit_notice_tpl_menu"]."
";
include("./edit/notice_tpl.inc.php");
break;
case "bannette" :
echo "".$msg["edit_tpl_menu"]." : ".$msg["edit_bannette_tpl_menu"]."
";
include("./edit/bannette_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;
}
pmb_mysql_close($dbh);