Exemple #1
0
    case "aff_refus":
        //on affiche l'écran de saisie du refus
        echo "<h1>" . $msg[transferts_circ_menu_titre] . " > " . $msg[transferts_circ_menu_envoi] . "</h1>";
        echo affiche_liste_valide($transferts_validation_liste_refus, $transferts_validation_liste_valide_ligne, "SELECT num_notice, num_bulletin, " . "expl_cb as val_ex, lender_libelle, transferts.date_creation as val_date_creation, " . "motif as val_motif, location_libelle as val_dest, empr_cb as val_empr  " . "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 " . "id_transfert IN (!!liste_numeros!!) " . "AND etat_demande=1", "circ.php?categ=trans&sub=" . $sub);
        break;
    case "refus":
        //on enregistre les refus
        $obj_transfert->enregistre_refus($liste_transfert, $motif_refus);
        $action = "";
        break;
}
if ($action == "") {
    get_cb_expl($msg[transferts_circ_menu_titre] . " > " . $msg[transferts_circ_menu_envoi], $msg[661], $msg[transferts_circ_envoi_exemplaire], "./circ.php?categ=trans&sub=" . $sub . "&f_destination=" . $f_destination . "&nb_per_page=" . $nb_per_page, 0);
    if ($form_cb_expl != "") {
        //enregistrement de l'envoi
        $res_env = $obj_transfert->enregistre_envoi_cb($form_cb_expl);
        if ($res_env == false) {
            // l'envoi n'est pas valide
            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 = "&nbsp;" . $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;