Пример #1
0
// $Id: all.inc.php,v 1.54 2015-10-29 10:56:12 jpermanne Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
    die("no access");
}
//Récupération des variables postées, on en aura besoin pour les liens
$page = $_SERVER[SCRIPT_NAME];
if ($dest == "TABLEAU") {
    //Export excel
    $fname = str_replace(" ", "", microtime());
    $fname = str_replace("0.", "", $base_path . "/temp/" . $fname);
    require_once "{$class_path}/writeexcel/class.writeexcel_workbook.inc.php";
    require_once "{$class_path}/writeexcel/class.writeexcel_worksheet.inc.php";
    $workbook = new writeexcel_workbook($fname);
    $worksheet = $workbook->addworksheet();
    //formats
    $workbook->set_custom_color(12, 00, 204, 255);
    $heading_blue = $workbook->addformat(array('fg_color' => 12));
    $heading_10 = $workbook->addformat(array('bold' => 1, 'size' => 10));
    $heading_12 = $workbook->addformat(array('bold' => 1, 'size' => 12));
} else {
    echo "<form action='empr.php' method='post' name='FormEmpr'>";
    echo "<input name='lvl' value='all' type='hidden'>";
    echo "<input name='prolonge_id' value='0' type='hidden'>";
    // Si click bouton de prolongation, et prolongation autorisée
    if ($prolonge_id > 0 && $opac_pret_prolongation == 1) {
        //Il faut prolonger un livre
        $prolongation = TRUE;
        //on recupere les informations du pret
        $query = "select cpt_prolongation, pret_date, pret_retour, expl_location from pret, exemplaires";
        $query .= " where pret_idexpl=expl_id";
        $query .= " and pret_idexpl=" . $prolonge_id . " limit 1";