public function get_data_empr($id_empr) { global $dbh, $pmb_gestion_financiere, $pmb_gestion_abonnement, $pmb_gestion_tarif_prets, $pmb_gestion_amende; $empr = get_info_empr($id_empr); $i = count($this->data["empr_list"]); $this->data["empr_list"][$i]["name"] = $empr->nom; $this->data["empr_list"][$i]["fistname"] = $empr->prenom; $this->data["empr_list"][$i]["cb"] = $empr->cb; $this->data["empr_list"][$i]["aff_date_adhesion"] = $empr->aff_date_adhesion; $this->data["empr_list"][$i]["aff_date_expiration"] = $empr->aff_date_expiration; $this->data["empr_list"][$i]["categorie"] = $empr->cat_l; if ($pmb_gestion_financiere) { $this->data["empr_list"][$i]["compte_abonnement"]["solde"] = ""; $this->data["empr_list"][$i]["compte_abonnement"]["novalid"] = ""; // abonnement if ($pmb_gestion_abonnement) { $cpt_id = comptes::get_compte_id_from_empr($id_empr, 1); $cpt = new comptes($cpt_id); $solde = $cpt->update_solde(); $novalid = $cpt->summarize_transactions("", "", 0, 0); $this->data["empr_list"][$i]["compte_abonnement"]["solde"] = $solde; $this->data["empr_list"][$i]["compte_abonnement"]["novalid"] = $novalid; } // prets $this->data["empr_list"][$i]["compte_pret"]["solde"] = ""; $this->data["empr_list"][$i]["compte_pret"]["novalid"] = ""; if ($pmb_gestion_tarif_prets) { $cpt_id = comptes::get_compte_id_from_empr($id_empr, 3); $cpt = new comptes($cpt_id); $solde = $cpt->update_solde(); $novalid = $cpt->summarize_transactions("", "", 0, 0); $this->data["empr_list"][$i]["compte_pret"]["solde"] = $solde; $this->data["empr_list"][$i]["compte_pret"]["novalid"] = $novalid; } // amendes $this->data["empr_list"][$i]["compte_amende"]["solde"] = ""; $this->data["empr_list"][$i]["compte_amende"]["novalid"] = ""; if ($pmb_gestion_amende) { $cpt_id = comptes::get_compte_id_from_empr($id_empr, 2); $cpt = new comptes($cpt_id); $solde = $cpt->update_solde(); $novalid = $cpt->summarize_transactions("", "", 0, 0); $this->data["empr_list"][$i]["compte_amende"]["solde"] = $solde; $this->data["empr_list"][$i]["compte_amende"]["novalid"] = $novalid; } // Autre compte $this->data["empr_list"][$i]["compte_autre"]["solde"] = ""; $this->data["empr_list"][$i]["compte_autre"]["novalid"] = ""; $transactype = new transactype_list(); if ($transactype->get_count()) { $cpt_id = comptes::get_compte_id_from_empr($id_empr, 4); $cpte = new comptes($cpt_id); $solde = $cpt->update_solde(); $novalid = $cpt->summarize_transactions("", "", 0, 0); $this->data["empr_list"][$i]["compte_autre"]["solde"] = $solde; $this->data["empr_list"][$i]["compte_autre"]["novalid"] = $novalid; } } return $this->data["empr_list"][$i]; }
function aff_pret_groupes() { global $msg, $id_empr, $lvl, $dbh; global $opac_pret_prolongation, $opac_pret_duree_prolongation, $allow_prol; global $dest, $worksheet, $line; global $heading_blue, $heading_10, $heading_12; $req_groupes = "SELECT * from groupe where resp_groupe={$id_empr} order by libelle_groupe"; $res = pmb_mysql_query($req_groupes); while ($r_goupe = pmb_mysql_fetch_object($res)) { if ($lvl == "late") { $titre_goup = sprintf($msg['empr_group_late'], $r_goupe->libelle_groupe); $class_aff_expl = "class='liste-expl-empr-late'"; $critere_requete = " AND pret_retour < '" . date('Y-m-d') . "' ORDER BY location_libelle, empr_nom, empr_prenom, pret_retour"; } else { $titre_goup = sprintf($msg['empr_group_loans'], $r_goupe->libelle_groupe); $class_aff_expl = "class='liste-expl-empr-all'"; $critere_requete = " ORDER BY location_libelle, empr_nom, empr_prenom, pret_retour"; } $sql = "SELECT notices_m.notice_id as num_notice_mono, bulletin_id, IF(pret_retour>sysdate(),0,1) as retard, expl_id, empr.id_empr as emprunteur, "; $sql .= "date_format(pret_retour, '" . $msg["format_date_sql"] . "') as aff_pret_retour, pret_retour, "; $sql .= "date_format(pret_date, '" . $msg["format_date_sql"] . "') as aff_pret_date, "; $sql .= "trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if(mention_date, concat(' (',mention_date,')') ,if (date_date, concat(' (',date_format(date_date, '" . $msg["format_date_sql"] . "'),')') ,'')))) as tit, if(notices_m.notice_id, notices_m.notice_id, notices_s.notice_id) as not_id, tdoc_libelle, location_libelle "; $sql .= "FROM (((exemplaires LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) "; $sql .= " LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) "; $sql .= " LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id), "; $sql .= " docs_type, docs_location , pret, empr,empr_groupe "; $sql .= "WHERE expl_typdoc = idtyp_doc and pret_idexpl = expl_id and empr.id_empr = pret.pret_idempr and empr_groupe.empr_id = empr.id_empr and expl_location = idlocation and groupe_id=" . $r_goupe->id_groupe; $sql .= $critere_requete; $req = pmb_mysql_query($sql) or die("Erreur SQL !<br />" . $sql . "<br />" . pmb_mysql_error()); $nb_elements = pmb_mysql_num_rows($req); if ($nb_elements) { if (!$dest) { echo "<br>"; echo "<h3><span>" . $titre_goup . "</span></h3>"; echo "<table {$class_aff_expl} width='100%'>"; echo "<tr>"; if ($lvl != "late") { echo "<th><center>" . $msg["empr_late"] . "</center></th>"; } echo " <th>" . $msg["extexpl_emprunteur"] . "</th>\n\t\t\t\t\t <th>" . $msg["title"] . "</th>\t\t\t\t\t\n\t\t\t\t\t <th>" . $msg["typdoc_support"] . "</th>\t\t\t\t\t \n\t\t\t\t\t <th><center>" . $msg["date_loan"] . "</center></th>\n\t\t\t\t\t <th><center>" . $msg["date_back"] . "</center></th>"; echo "</tr>"; $odd_even = 1; $loc_cours = ""; while ($data = pmb_mysql_fetch_array($req)) { if ($loc_cours != $data['location_libelle']) { $loc_cours = $data['location_libelle']; echo "<tr class='tb_pret_location_row'>\n\t\t\t\t\t\t\t\t<td colspan='" . ($lvl != "late" ? "6" : "5") . "'>" . $msg["expl_header_location_libelle"] . " : " . $loc_cours . "</td>\n\t\t\t\t\t\t\t</tr>"; } $id_expl = $data['expl_cb']; // on affiche les résultats if ($odd_even == 0) { $pair_impair = "odd"; $odd_even = 1; } else { if ($odd_even == 1) { $pair_impair = "even"; $odd_even = 0; } } if ($data['num_notice_mono']) { $tr_javascript = " class='{$pair_impair}' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./index.php?lvl=notice_display&id=" . $data['num_notice_mono'] . "&seule=1';\" style='cursor: pointer' "; } else { $tr_javascript = " class='{$pair_impair}' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./index.php?lvl=bulletin_display&id=" . $data['bulletin_id'] . "';\" style='cursor: pointer' "; } $deb_ligne = "<tr {$tr_javascript}>"; echo $deb_ligne; /* test de date de retour dépassée */ if ($lvl != "late") { if ($data['retard']) { echo "<td class='expl-empr-retard'><center><b>×</b></center></td>"; } else { echo "<td> </td>"; } } $empr = get_info_empr($data['emprunteur']); echo "<td>" . $empr['nom'] . " " . $empr['prenom'] . "</td>"; echo "<td>" . $data['tit'] . "</td>"; echo "<td>" . $data["tdoc_libelle"] . "</td>"; echo "<td><center>" . $data['aff_pret_date'] . "</center></td>"; if ($data['retard']) { echo "<td class='expl-empr-retard'><center>" . $data['aff_pret_retour'] . "</center></td>"; } else { echo "<td><center>" . $data['aff_pret_retour'] . "</center></td>"; } echo "</tr>\n"; } // fin du while echo "</table>"; } else { $line += 2; $x = 0; //Titre $worksheet->write($line, $x, $titre_goup, $heading_blue); $worksheet->merge_cells($line, $x, $line, $x + 6); //Entêtes $line += 2; $x = 0; if ($lvl != "late") { $worksheet->write($line, $x, $msg["empr_late"], $heading_10); $x++; } $worksheet->write($line, $x, $msg["extexpl_emprunteur"], $heading_10); $worksheet->write($line, $x + 1, $msg["title"], $heading_10); $worksheet->write($line, $x + 2, $msg["typdoc_support"], $heading_10); $worksheet->write($line, $x + 3, $msg["date_loan"], $heading_10); $worksheet->write($line, $x + 4, $msg["date_back"], $heading_10); //Valeurs $loc_cours = ""; while ($data = pmb_mysql_fetch_array($req)) { $x = 0; $line++; if ($loc_cours != $data['location_libelle']) { $loc_cours = $data['location_libelle']; $worksheet->write($line, $x, $msg["expl_header_location_libelle"] . " : " . $loc_cours, $heading_12); $line++; } if ($lvl != "late") { if ($data['retard']) { $worksheet->write($line, $x, "x"); } $x++; } $empr = get_info_empr($data['emprunteur']); $worksheet->write($line, $x, $empr['nom'] . " " . $empr['prenom']); $worksheet->write($line, $x + 1, $data['tit']); $worksheet->write($line, $x + 2, $data["tdoc_libelle"]); $worksheet->write($line, $x + 3, $data['aff_pret_date']); $worksheet->write($line, $x + 4, $data['aff_pret_retour']); } } } } }
<?php // +-------------------------------------------------+ // © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net) // +-------------------------------------------------+ // $Id: main.inc.php,v 1.2 2015-04-03 11:16:26 jpermanne Exp $ if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) { die("no access"); } require_once './circ/print_pret/func.inc.php'; $empr = get_info_empr($id_empr); //global $biblio_name, $biblio_logo, $biblio_adr1, $biblio_adr2, $biblio_cp, $biblio_town, $biblio_state, $biblio_country, $biblio_phone, $biblio_email, $biblio_website ; $xml_bibli = "<text style=\"header\">" . htmlspecialchars($biblio_name, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($biblio_adr1, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($biblio_town, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($biblio_phone, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($biblio_email, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\"></text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($msg['fpdf_edite'] . " " . formatdate(date("Y-m-d", time())), ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\"></text>"; $xml_bibli .= "<text style=\"t1\">Emprunteur: </text>"; $xml_bibli .= "<text style=\"p1\">" . htmlspecialchars($empr->nom . " " . $empr->prenom, ENT_QUOTES, $charset) . "</text>"; $xml_bibli .= "<text style=\"p1\"></text>"; function print_expl($cb_doc) { global $charset; $expl = get_info_expl($cb_doc); $xml_expl .= "<text style=\"p1\"></text>"; $titre = substr($expl->tit, 0, 25); $xml_expl .= "<text style=\"t1_s\">" . htmlspecialchars($titre, ENT_QUOTES, $charset) . "</text>"; $xml_expl .= "<text style=\"t1\" x=\"360\">" . htmlspecialchars($expl->aff_pret_retour, ENT_QUOTES, $charset) . "</text>";