<?php
#########################################################################
#                         view_entry.php                                #
#                                                                       #
#                  Interface de visualisation d'une réservation         #
#                                                                       #
#                  Dernière modification : 21/05/2005                   #
#                                                                       #
#########################################################################
/*
 * Copyright 2003-2005 Laurent Delineau
 * D'après http://mrbs.sourceforge.net/
 *
 * 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
 */
include "../include/validsession.inc";
include "connect.inc.php";
include "config.inc.php";
include "functions.inc.php";
include "$dbsys.inc.php";
// Settings
require_once("./settings.inc.php");
//Chargement des valeurs de la table settingS
if (!loadSettings())
    die("Erreur chargement settings");

// Session related functions
require_once("./session.inc.php");
// Resume session
if ((!resumeSession())and ($authentification_obli==1)) {
    header("Location: ./logout.php?auto=1");
    die();
};

// Paramètres langage
include "language.inc.php";

if (($authentification_obli==0) and (!isset($_SESSION['login']))) {
    $session_login = '';
    $type_session = "no_session";
} else {
    $session_login = $_SESSION['login'];
    $type_session = "with_session";
}

$statut_id = isset($_GET["statut_id"]) ? $_GET["statut_id"] : "-";
// Si l'utilisateur est administrateur, possibilité de modifier le statut de la réservation (en cours / libérée)
if (isset($_GET['ok'])) {
    $room_id = sql_query1("select room_id from grr_entry where id='".$id."'");
    if (isset($_SESSION['login']) and (authGetUserLevel($_SESSION['login'],$room_id) >= 3)) {
        $upd1 = "update grr_entry set statut_entry='-' where room_id = '".$room_id."'";
        if (sql_command($upd1) < 0) return 0;
        $upd2 = "update grr_entry set statut_entry='$statut_id' where id = '".$id."'";
        if (sql_command($upd2) < 0) return 0;
        header("Location: ".$_GET['back']."");
    }
}


$back = str_replace("&display_message=yes", "", $_SERVER['HTTP_REFERER']);

// Recherche des infos liée à la réservation
$sql = "
SELECT grr_entry.name,
       grr_entry.description,
       grr_entry.create_by,
       grr_room.room_name,
       grr_area.area_name,
       grr_entry.type,
       grr_entry.room_id,
       grr_entry.repeat_id,
    " . sql_syntax_timestamp_to_unix("grr_entry.timestamp") . ",
       (grr_entry.end_time - grr_entry.start_time),
       grr_entry.start_time,
       grr_entry.end_time,
       grr_area.id,
       grr_entry.statut_entry

FROM grr_entry, grr_room, grr_area
WHERE grr_entry.room_id = grr_room.id
  AND grr_room.area_id = grr_area.id
  AND grr_entry.id=$id
";

$res = sql_query($sql);
if (! $res) fatal_error(0, sql_error());

if(sql_count($res) < 1) fatal_error(0, $vocab['invalid_entry_id']);

$row = sql_row($res, 0);
sql_free($res);

$name         = htmlspecialchars($row[0]);
$description  = htmlspecialchars($row[1]);
$create_by    = htmlspecialchars($row[2]);
$room_name    = htmlspecialchars($row[3]);
$area_name    = htmlspecialchars($row[4]);
$type         = $row[5];
$room_id      = $row[6];
$repeat_id    = $row[7];
$updated      = time_date_string($row[8],$dformat);
$duration     = $row[9];
$start_date = time_date_string($row[10],$dformat);
$end_date = time_date_string($row[11],$dformat);
$area      = $row[12];
$statut_id = $row[13];

$rep_type = 0;


if((authGetUserLevel(getUserName(),-1) < 1) and ($authentification_obli==1))
{
    showAccessDenied($day, $month, $year, $area,$back);
    exit();
}
if(authUserAccesArea($session_login, $area)==0)
{
    showAccessDenied($day, $month, $year, $area,$back);
    exit();
}

#If we dont know the right date then make it up
if(!isset($day) or !isset($month) or !isset($year))
{
    $day   = date("d");
    $month = date("m");
    $year  = date("Y");
}
$date_now = mktime();

$page = isset($_GET["page"]) ? $_GET["page"] : NULL;

print_header($day, $month, $year, $area, $type_session);



// Nom, prénom et email du créateur de la réser
$sql = "select nom, prenom, email from grr_utilisateurs where login='$create_by'";
$res = sql_query($sql);
if ($res) $row_user_login = sql_row($res, 0);

if($repeat_id != 0)
{
    $res = sql_query("SELECT rep_type, end_date, rep_opt, rep_num_weeks
                        FROM grr_repeat WHERE id=$repeat_id");
    if (! $res) fatal_error(0, sql_error());

    if (sql_count($res) == 1)
    {
        $row = sql_row($res, 0);

        $rep_type     = $row[0];
        $rep_end_date = strftime($dformat,$row[1]);
        $rep_opt      = $row[2];
        $rep_num_weeks = $row[3];
    }
    sql_free($res);
}

toTimeString($duration, $dur_units);

$repeat_key = "rep_type_" . $rep_type;

# Now that we know all the data we start drawing it

?>

<H3><?php echo $name ?></H3>
 <table border=0>
   <tr>
    <td><b><?php echo $vocab["description"] ?></b></td>
    <td><?php    echo nl2br($description)  ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["room"]                           ?></b></td>
    <td><?php    echo  nl2br($area_name . " - " . $room_name) ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["start_date"] ?></b></td>
    <td><?php    echo $start_date         ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["duration"]            ?></b></td>
    <td><?php    echo $duration . " " . $dur_units ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["end_date"] ?></b></td>
    <td><?php    echo $end_date         ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["type"]   ?></b></td>
    <td><?php    echo empty($typel[$type]) ? "?$type?" : $typel[$type]  ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["createdby"] ?></b></td>
    <td><?php    echo "<a href='mailto:".$row_user_login[2]."'>".$row_user_login[1]." ".$row_user_login[0]."</a>";         ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["lastupdate"] ?></b></td>
    <td><?php    echo $updated            ?></td>
   </tr>
   <tr>
    <td><b><?php echo $vocab["rep_type"]  ?></b></td>
    <td><?php    echo $vocab[$repeat_key] ?></td>
   </tr>
<?php

if($rep_type != 0)
{
    $opt = "";
    if (($rep_type == 2) || ($rep_type == 6))
    {
        # Display day names according to language and preferred weekday start.
        for ($i = 0; $i < 7; $i++)
        {
            $daynum = ($i + $weekstarts) % 7;
            if ($rep_opt[$daynum]) $opt .= day_name($daynum) . " ";
        }
    }
    if ($rep_type == 6)
    {
        echo "<tr><td><b>$vocab[rep_num_weeks] $vocab[rep_for_nweekly]</b></td><td>$rep_num_weeks</td></tr>\n";
    }

    if($opt)
        echo "<tr><td><b>$vocab[rep_rep_day]</b></td><td>$opt</td></tr>\n";

    echo "<tr><td><b>$vocab[rep_end_date]</b></td><td>$rep_end_date</td></tr>\n";
}

?>
</table>
<br>
<p>
<?php
if ((getWritable($create_by, getUserName(),$id)) and verif_booking_date(getUserName(), $id, -1, $date_now)) { ?>
    <a href="edit_entry.php?id=<?php echo $id ?>&page=<?php echo $page; ?>"><?php echo $vocab["editentry"] ?></a>
    <?php
    if($repeat_id)
        echo " - <a href=\"edit_entry.php?id=$id&edit_type=series&day=$day&month=$month&year=$year&page=$page\">$vocab[editseries]</a>";
    ?>
    <BR>
    <A HREF="del_entry.php?id=<?php echo $id ?>&series=0&page=<?php echo $page; ?>" onClick="return confirm('<?php echo $vocab["confirmdel"] ?>');"><?php echo $vocab["deleteentry"] ?></A>
    <?php

    if($repeat_id)
        echo " - <A HREF=\"del_entry.php?id=$id&series=1&day=$day&month=$month&year=$year&page=$page\" onClick=\"return confirm('$vocab[confirmdel]');\">$vocab[deleteseries]</A>";

} ?>
<BR>
<a href="<?php echo $back ?>"><?php echo $vocab["returnprev"] ?></a>
<?php

// Si l'utilisateur est administrateur, possibilité de modifier le statut de la réservation (en cours / libérée)
if ( isset($_SESSION['login']) and (authGetUserLevel($_SESSION['login'],$room_id) >= 3))          {
    echo "<form name=\"form\" action=\"view_entry.php\" method=\"GET\">";
    echo "<br>
    <table border=\"1\" width=\"100%\"><tr><td align=\"center\" valign=\"middle\">
    <font size=\"+1\">".$vocab["signaler_reservation_en_cours"]."</font> : <input type=\"checkbox\" name=\"statut_id\" value=\"y\" ";
    if ($statut_id=='y') echo " checked ";
    echo " />
    <br><font size=\"-1\">".$vocab["une_seule_reservation_en_cours"]."</font>
    <center><input type=\"submit\" name=\"ok\" value=\"Envoyer\" /></center>
    </td></tr></table>\n";
    echo "<input type=\"hidden\" name=\"day\" value=\"".$day."\" />";
    echo "<input type=\"hidden\" name=\"month\" value=\"".$month."\" />";
    echo "<input type=\"hidden\" name=\"year\" value=\"".$year."\" />";
    echo "<input type=\"hidden\" name=\"page\" value=\"".$page."\" />";
    echo "<input type=\"hidden\" name=\"id\" value=\"".$id."\" />";
    echo "<input type=\"hidden\" name=\"back\" value=\"".$back."\" />";
    echo "</form>";
}

include "trailer.inc.php"; ?>