<?php
#########################################################################
#                            csv .php                                   #
#                                                                       #
#            script  de constitution du fichiers CSV                    #
#            du résumé des réservations                                 #
#            Dernière modification : 22/04/2005                         #
#                                                                       #
#                                                                       #
#########################################################################
/*
 * Copyright 2003-2005 Laurent Delineau
 *
 * This file is part of GRR.
 *
 * GRR is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * GRR is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with GRR; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */

extract($_GET, EXTR_OVERWRITE);
extract($_POST, EXTR_OVERWRITE);
include "connect.inc.php";
include "config.inc.php";
include "functions.inc.php";
include "$dbsys.inc.php";
    #Paramètres de connection
require_once("./settings.inc.php");
    #Chargement des valeurs de la table settings
if (!loadSettings())
    die("Erreur chargement settings");

    #Fonction relative à la session
require_once("./session.inc.php");
    #Si il n'y a pas de session crée et que l'identification est requise, on déconnecte l'utilisateur.
if ((!resumeSession())and ($authentification_obli==1)) {
    header("Location: ./logout.php?auto=1");
    die();
};
    #Renseigne les droits de l'utilisateur, si les droits sont insufisants, l'utilisateur est deconnecté.
if(authGetUserLevel(getUserName(),-1) < 2)
{
    header("Location: ./logout.php?auto=1");
    exit();
}

header("Content-Type: application/csv-tab-delimited-table");
header("Content-disposition: filename=rapport.csv");

// Paramètres langage
include "language.inc.php";

   #Si nous ne savons pas la date, nous devons la créer
if(!isset($day) or !isset($month) or !isset($year))
{
    $day   = date("d");
    $month = date("m");
    $year  = date("Y");
}
    #Récupération des informations relatives au serveur.
if (isset($_SERVER['HTTP_REFERER'])) $back = $_SERVER['HTTP_REFERER'];
    #Renseigne les droits de l'utilisateur, si les droits sont insufisants, l'utilisateur est avertit.

#   La requête SQL va contenir les colonnes suivantes:
# Col Index  Description:
#   1  [0]   Entry ID, Non affiché
#   2  [1]   Date de début (Unix)
#   3  [2]   Date de fin (Unix)
#   4  [3]   Descrition brêve,(HTML)
#   5  [4]   Description,(HTML)
#   6  [5]   Type
#   7  [6]   Créer par (nom ou IP), (HTML)
#   8  [7]   Timestamp (création), (Unix)
#   9  [8]   Area (HTML)
#  10  [9]   Room (HTML)
#  11  [10]  Room description
    $sql = "SELECT e.id, e.start_time, e.end_time, e.name, e.description, "
        . "e.type, e.create_by, "
        .  sql_syntax_timestamp_to_unix("e.timestamp")
        . ", a.area_name, r.room_name, r.description"
        . " FROM grr_entry e, grr_area a, grr_room r"
        . " WHERE e.room_id = r.id AND r.area_id = a.id"
        . " AND e.start_time < $report_end AND e.end_time > $report_start";
    if (!empty($areamatch))
        $sql .= " AND" .  sql_syntax_caseless_contains("a.area_name", $areamatch);
    if (!empty($roommatch))
        $sql .= " AND" .  sql_syntax_caseless_contains("r.room_name", $roommatch);
    if (!empty($namematch))
        $sql .= " AND" .  sql_syntax_caseless_contains("e.name", $namematch);
    if (!empty($descrmatch))
        $sql .= " AND" .  sql_syntax_caseless_contains("e.description", $descrmatch);
    if (!empty($loginmatch))
        $sql .= " AND" .  sql_syntax_caseless_contains("e.create_by", $loginmatch);

    #Trié par: Area, room, debut, date/heure.
    $sql .= " ORDER BY 9,10,2";
    $res = sql_query($sql);
    if (! $res) fatal_error(0, sql_error());
    $nmatch = sql_count($res);
    if ($nmatch == 0)
    {
        echo "<P><B>" . unhtmlentities($vocab["nothing_found"]) . "</B>\r\n";
        sql_free($res);
    }
    else
    {
                echo unhtmlentities($vocab["summarize_by"]);
        if ($sumby=="c")
            echo unhtmlentities($vocab["sum_by_creator"])." : $day $month $year;";
        else
            echo unhtmlentities($vocab["sum_by_descrip"])." : $day $month $year;";
        if ($areamatch != null or $roommatch != null or $namematch != null or $descrmatch != null)
        {
            echo unhtmlentities($vocab["enrecherchant"]);
            echo "$areamatch $roommatch $namematch $descrmatch - $From_day/$From_month/$From_year -> $To_day/$To_month/$To_year";
        }
        echo "\r\n";
        echo unhtmlentities($vocab["createdby"]).";".unhtmlentities($vocab["areas"]).";".unhtmlentities($vocab["room"]).";".unhtmlentities($vocab["description"]).";".unhtmlentities($vocab["time"])." - ".unhtmlentities($vocab["duration"]).";".unhtmlentities($vocab["match_entry"]).";".unhtmlentities($vocab["match_descr"]).";".unhtmlentities($vocab["lastupdate"]).";\n";
    }
for ($i = 0; ($row = sql_row($res, $i)); $i++)
        {
    #Affichage de "crée par" et de la date de la dernière mise à jour
    echo htmlspecialchars($row[6]) . ";";
    #Area
    echo htmlspecialchars($row[8]) . ";";
    #Ressource
    echo htmlspecialchars($row[9]) . ";";
    #Description de la ressource
    echo htmlspecialchars($row[10]) . ";";
    #Affichage de l'heure et de la durée de réservation
    echo describe_span($row[1], $row[2],$dformat) . ";";
    #Destination
    echo htmlspecialchars($row[3]) . ";";
    #Description de la réservation
    $texte=str_replace(CHR(10)," ",$row[4]);
    $texte=str_replace(CHR(13)," ",$texte);
    echo ltrim(rtrim(htmlspecialchars($texte))) . ";";

    #Date derniere modif
    echo date_time_string($row[7],$dformat) . ";";
    echo "\r\n";

        }
?>