//l'id de la transaction $tmpString = str_replace("!!trans_id!!", $transid, $tmpString); echo pmb_bidi($tmpString); break; case "redem": //enregistre la nouvelle demande //transfert::creer_transfert(2, "", $id_expl, 1, $dest_id, $date_retour, $motif); $obj_transfert->ajoute_demande($transid, $id_expl, $motif, $date_retour); $action = ""; break; } if ($action == "") { $rqt = "select id_transfert, num_expl from transferts,transferts_demande, pret where pret_idexpl=num_expl and id_transfert=num_transfert and etat_transfert=0 AND etat_demande=4"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res)) { while ($r = pmb_mysql_fetch_object($res)) { $liste_transfert[] = $r->id_transfert; } $obj_transfert->cloture_transferts(implode($liste_transfert, ',')); } //pas d'action donc affichage de la liste des transferts refusés echo "<h1>" . $msg[transferts_circ_menu_titre] . " > " . $msg[transferts_circ_menu_refuse] . "</h1>"; $filtres = " " . $msg["transferts_circ_reception_filtre_source"] . str_replace("!!nom_liste!!", "f_source", $transferts_liste_localisations_tous); $filtres = str_replace("!!liste_localisations!!", do_liste_localisation($f_source), $filtres); $req = "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert=num_transfert " . "INNER JOIN exemplaires ON num_expl=expl_id " . "INNER JOIN lenders ON idlender=expl_owner " . "INNER JOIN docs_location ON num_location_source=idlocation " . "LEFT JOIN resa ON resa_trans=id_resa " . "LEFT JOIN empr ON resa_idempr=id_empr " . "WHERE etat_transfert=0 " . "AND type_transfert=1 " . "AND etat_demande=4 " . "AND num_location_dest=" . $deflt_docs_location; //pour le site de l'utilisateur if ($f_source) { $req .= " AND num_location_source=" . $f_source; } echo affiche_liste($sub, $page, "SELECT num_notice, num_bulletin, id_transfert as val_id, " . "expl_cb as val_ex, lender_libelle, location_libelle as val_source, " . "transferts_demande.date_creation as val_date_creation, date_visualisee as val_date_refus," . "motif_refus as val_refusMotif, empr_cb as val_empr ", $req, $nb_per_page, $transferts_refus_form_global, $transferts_refus_tableau_definition, $transferts_refus_tableau_ligne, $transferts_refus_boutons_action, $transferts_refus_pas_de_resultats, "", $filtres, "&f_source=" . $f_source); }
echo $transferts_envoi_erreur; } else { // l'envoi est fait $aff = str_replace("!!cb_expl!!", $form_cb_expl, $transferts_envoi_OK); echo str_replace("!!new_location!!", $obj_transfert->new_location_libelle, $aff); } } $filtres = " " . $msg["transferts_circ_envoi_filtre_destination"] . str_replace("!!nom_liste!!", "f_destination", $transferts_liste_localisations_tous); $filtres = str_replace("!!liste_localisations!!", do_liste_localisation($f_destination), $filtres); if ($transferts_validation_actif == "1") { $req = "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert=num_transfert " . "INNER JOIN exemplaires ON num_expl=expl_id " . "INNER JOIN lenders ON idlender=expl_owner " . "INNER JOIN docs_location ON num_location_dest=idlocation " . "LEFT JOIN resa ON resa_trans=id_resa " . "LEFT JOIN empr ON resa_idempr=id_empr " . "WHERE etat_transfert=0 " . "AND etat_demande=1 " . "AND num_location_source=" . $deflt_docs_location; } else { $req = "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert=num_transfert " . "INNER JOIN exemplaires ON num_expl=expl_id " . "INNER JOIN lenders ON idlender=expl_owner " . "INNER JOIN docs_location ON num_location_dest=idlocation " . "LEFT JOIN resa ON resa_trans=id_resa " . "LEFT JOIN empr ON resa_idempr=id_empr " . "WHERE etat_transfert=0 " . "AND (etat_demande=0 " . "OR etat_demande=1) " . "AND num_location_source=" . $deflt_docs_location; } //pour le site de l'utilisateur //pour l'edition de la liste $url_edition = "./edit.php?categ=transferts&sub=envoi"; //on applique la seletion du filtre if ($f_destination) { $req .= " AND num_location_dest=" . $f_destination; $url_edition .= "&site_destination=" . $f_destination; } //le lien pour l'édition si on a le droit ... if (SESSrights & EDIT_AUTH) { $lien_edition = "<a href='" . $url_edition . "'>" . $msg[1100] . "</a>"; } else { $lien_edition = ""; } //on affiche la liste echo affiche_liste($sub, $page, "SELECT num_notice, num_bulletin, id_transfert as val_id, " . "expl_cb as val_ex, lender_libelle, transferts.date_creation as val_date_creation, " . "date_visualisee as val_date_accepte, motif as val_motif, location_libelle as val_dest, empr_cb as val_empr ", $req, $nb_per_page, $transferts_envoi_form_global, $transferts_envoi_tableau_definition, $transferts_envoi_tableau_ligne, $transferts_envoi_boutons_action, $transferts_envoi_pas_de_resultats, $lien_edition, $filtres, "&f_destination=" . $f_destination); }
//enregistrement de la reception $res_rcp = $obj_transfert->enregistre_reception_cb($form_cb_expl, $statut_reception, $section_reception, $info); $motif = $info[0]["motif"]; if ($res_rcp == false) { // reception pas valide echo $transferts_reception_erreur; } else { // reception est faite echo str_replace("!!cb_expl!!", $form_cb_expl, $transferts_reception_OK); $resa = new reservation(0, 0, 0, $form_cb_expl); if ($empr_resa = $resa->get_empr_info_cb()) { $motif = $obj_transfert->get_motif($res_rcp); echo str_replace("!!empr_link!!", $empr_resa, "<div class='row' align='center'><span class='erreur'>" . $msg["transferts_circ_reception_accepte_resa"] . "</span><br /><b>" . $msg["transferts_circ_reception_resa_par"] . " : !!empr_link!!</b></div>"); } if ($motif) { echo "<div class='row' align='center'><b>" . $motif . "</b></div>"; } } } // les filtres à afficher $filtres = " " . $msg["transferts_circ_reception_filtre_source"] . str_replace("!!nom_liste!!", "f_source", $transferts_liste_localisations_tous); $filtres = str_replace("!!liste_localisations!!", do_liste_localisation($f_source), $filtres); $req = "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert=num_transfert " . "INNER JOIN exemplaires ON num_expl=expl_id " . "INNER JOIN lenders ON idlender=expl_owner " . "INNER JOIN docs_location ON num_location_source=idlocation " . "LEFT JOIN resa ON resa_trans=id_resa " . "LEFT JOIN empr ON resa_idempr=id_empr " . "WHERE etat_transfert=0 " . "AND etat_demande=2 " . "AND num_location_dest=" . $deflt_docs_location; //pour le site de l'utilisateur //on applique le filtre sélectionner if ($f_source) { $req .= " AND num_location_source=" . $f_source; } //on affiche la liste echo affiche_liste($sub, $page, "SELECT " . "num_notice, num_bulletin, " . "id_transfert as val_id,lender_libelle, date_envoyee as val_date_envoi, " . "expl_cb as val_ex, transferts.date_creation as val_date_creation, " . "motif as val_motif, location_libelle as val_source, empr_cb as val_empr ", $req, $nb_per_page, $transferts_reception_form_global, $transferts_reception_tableau_definition, $transferts_reception_tableau_ligne, $transferts_reception_boutons_action, $transferts_reception_pas_de_resultats, "", $filtres, "&f_source=" . $f_source); }
if ($form_cb_expl != "") { //enregistre l'acceptation du transfert $res_val = $obj_transfert->enregistre_validation_cb($form_cb_expl); if ($res_val == false) { // la validation ne s'est pas faite ! echo $transferts_validation_acceptation_erreur; } else { // la validation est faite $aff = str_replace("!!cb_expl!!", $form_cb_expl, $transferts_validation_acceptation_OK); echo str_replace("!!new_location!!", $obj_transfert->new_location_libelle, $aff); } } $filtres = " " . $msg["transferts_circ_validation_filtre_destination"] . str_replace("!!nom_liste!!", "f_destination", $transferts_liste_localisations_tous); $filtres = str_replace("!!liste_localisations!!", do_liste_localisation($f_destination), $filtres); $req = "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert=num_transfert " . "INNER JOIN exemplaires ON num_expl=expl_id " . "INNER JOIN docs_statut ON expl_statut=idstatut " . "INNER JOIN lenders ON idlender=expl_owner " . "INNER JOIN docs_location ON num_location_dest=idlocation " . "LEFT JOIN resa ON resa_trans=id_resa " . "LEFT JOIN empr ON resa_idempr=id_empr " . "WHERE etat_transfert=0 " . "AND etat_demande=0 " . "AND num_location_source=" . $deflt_docs_location; //pour le site de l'utilisateur $url_edition = "./edit.php?categ=transferts&sub=validation"; // si une destination est sélectionnée if ($f_destination) { $req .= " AND num_location_dest=" . $f_destination; $url_edition .= "&site_destination=" . $f_destination; } //le lien pour l'édition si on a le droit ... if (SESSrights & EDIT_AUTH) { $lien_edition = "<a href='" . $url_edition . "'>" . $msg[1100] . "</a>"; } else { $lien_edition = ""; } //on affihce la liste echo affiche_liste($sub, $page, "SELECT num_notice, num_bulletin, " . "id_transfert as val_id, " . "expl_cb as val_ex, expl_cote as val_cote, CONCAT(statut_libelle,'###',expl_id) as val_statut, lender_libelle, transferts.date_creation as val_date_creation, " . "transferts.date_retour as val_date_retour, motif as val_motif, location_libelle as val_dest, empr_cb as val_empr ", $req, $nb_per_page, $transferts_validation_form_global, $transferts_validation_tableau_definition, $transferts_validation_tableau_ligne, $transferts_validation_boutons_action, $transferts_validation_pas_de_resultats, $lien_edition, $filtres, "&f_destination=" . $f_destination); }