<?php
#########################################################################
#                            week_all.php                               #
#    Permet l'affichage des réservation d'une semaine                   #
#              pour toutes les ressources d'un domaine.                 #
#             Dernière modification : 23/06/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
 */
include "connect.inc.php";
include "config.inc.php";
include "functions.inc.php";
include "$dbsys.inc.php";
include "mincals.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";

// On affiche le lien "format imprimable" en bas de la page
$affiche_pview = '1';
if (!isset($_GET['pview'])) $_GET['pview'] = 0;

# Default parameters:
if (empty($debug_flag)) $debug_flag = 0;

if (empty($month) || empty($year) || !checkdate($month, 1, $year))
{
    $month = date("m");
    $year  = date("Y");
}


if (($authentification_obli==0) and (!isset($_SESSION['login']))) {
    $session_login = '';
    $session_statut = '';
    $type_session = "no_session";
} else {
    $session_login = $_SESSION['login'];
    $session_statut = $_SESSION['statut'];
    $type_session = "with_session";
}
$back = '';
if (isset($_SERVER['HTTP_REFERER'])) $back = $_SERVER['HTTP_REFERER'];

if (check_begin_end_bookings($day, $month, $year))
{
    showNoBookings($day, $month, $year, $area,$back,$type_session);
    exit();
}

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();
}

// Fonction de comparaison
// 3-value compare: Returns result of compare as "< " "= " or "> ".
function cmp3($a, $b)
{
    if ($a < $b) return "< ";
    if ($a == $b) return "= ";
    return "> ";
}

# print the page header
print_header($day, $month, $year, $area, $type_session);
if (empty($area))
    $area = get_default_area();
if (empty($room))
    $room = sql_query1("select min(id) from grr_room where area_id=$area");

$time = mktime(0, 0, 0, $month, $day, $year);

// date("w", $time) : jour de la semaine en partant de dimancche
// date("w", $time) - $weekstarts : jour de la semaine en partant du jour défini dans GRR
// Si $day ne correspond pas au premier jour de la semaine tel que défini dans GRR, on recule la date jusqu'au précédent début de semaine
// Evidemment, problème possible avec les changement été-hiver et hiver-été
if (($weekday = (date("w", $time) - $weekstarts + 7) % 7) > 0)
{
    $time -= $weekday * 86400;
}

// $day_week, $month_week, $year_week sont jours, semaines et années correspondant au premier jour de la semaine
$day_week   = date("d", $time);
$month_week = date("m", $time);
$year_week  = date("Y", $time);

//$date_start : date de début des réservation à extraire
$date_start = mktime($morningstarts,0,0,$month_week,$day_week,$year_week);

// Nombre de jours dans le mois
$days_in_month = date("t", $date_start);

if ($debug_flag)
    echo "$month_week $day_week ";

// $date_end : date de fin des réservation à extraire
$date_end = mktime($eveningends, $eveningends_minutes, 0, $month_week, $day_week+6, $year_week);

// Si format imprimable ($_GET['pview'] = 1), on n'affiche pas cette partie
if ($_GET['pview'] != 1) {
    # Table with areas, rooms, minicals.
    echo "\n<table width=\"100%\" cellspacing=15><tr><td>\n";
    $this_area_name = "";
    $this_room_name = "";

    if (isset($_SESSION['default_list_type']) or ($authentification_obli==1)) {
        $area_list_format = $_SESSION['default_list_type'];
    } else {
        $area_list_format = getSettingValue("area_list_format");
    }

    # show either a select box or the normal html list
    if ($area_list_format != "list") {
        echo make_area_select_html('week_all.php', $area, $year, $month, $day, $session_login); # from functions.inc.php
    # echo make_room_select_html('month.php', $area, $room, $year, $month, $day);
    } else {
        echo "\n<table cellspacing=15><tr><td>\n";
        echo make_area_list_html('week_all.php', $area, $year, $month, $day, $session_login); # from functions.inc.php
        echo "</td></tr></table>\n";
    }
    echo "</td>\n";

    #Draw the three month calendars
    minicals($year, $month, $day, $area, $room, 'week_all');
    echo "</tr></table>\n";
}

$this_area_name = sql_query1("select area_name from grr_area where id=$area");
$this_room_name = sql_query1("select room_name from grr_room where id=$room");
$this_room_name_des = sql_query1("select description from grr_room where id=$room");

# Don't continue if this area has no rooms:
if ($room <= 0)
{
    echo "<h1>".$vocab['no_rooms_for_area']."</h1>\n";
    include "trailer.inc.php";
    exit;
}

# Show Month, Year, Area, Room header:
if (($this_room_name_des) and ($this_room_name_des!="-1")) {
    $this_room_name_des = " (".$this_room_name_des.")";
} else {
    $this_room_name_des = "";
}
switch ($dateformat) {
    case "en":
    $dformat = "%A, %b %d";
    break;
    case "fr":
    $dformat = "%A %d %b";
    break;
}

 echo "<center><h2>".$vocab["week"]." : " . strftime($dformat, $date_start)." - ". strftime($dformat, $date_end)
  . "<br> $this_area_name - ".$vocab["all_rooms"]."</h2></center>\n";

#y? are year, month and day of the previous week.
#t? are year, month and day of the next week.

$i= mktime(0,0,0,$month_week,$day_week-7,$year_week);
$yy = date("Y",$i);
$ym = date("m",$i);
$yd = date("d",$i);

$i= mktime(0,0,0,$month_week,$day_week+7,$year_week);
$ty = date("Y",$i);
$tm = date("m",$i);
$td = date("d",$i);
// Si format imprimable ($_GET['pview'] = 1), on n'affiche pas cette partie
if ($_GET['pview'] != 1) {
    #Show Go to week before and after links
    echo "\n<table width=\"100%\"><tr><td>
      <a href=\"week_all.php?year=$yy&month=$ym&day=$yd&area=$area&room=$room\">
      &lt;&lt; ".$vocab["weekbefore"]."</a></td>
      <td>&nbsp;</td>
      <td align=right><a href=\"week_all.php?year=$ty&month=$tm&day=$td&area=$area&room=$room\">".
      $vocab['weekafter']." &gt;&gt;</a></td></tr></table>";
}

# Used below: localized "all day" text but with non-breaking spaces:
$all_day = ereg_replace(" ", "&nbsp;", $vocab["all_day"]);

#Get all meetings for this month in the room that we care about
# row[0] = Start time
# row[1] = End time
# row[2] = Entry ID
# row[3] = Entry name (brief description)
# row[4] = creator of the booking
$sql = "SELECT start_time, end_time, grr_entry.id, name, create_by, room_name,type
   FROM grr_entry inner join grr_room on grr_entry.room_id=grr_room.id
   WHERE start_time <= $date_end AND end_time > $date_start
   ORDER by start_time, end_time, grr_entry.id";

# Build an array of information about each day in the month.
# The information is stored as:
#  d[monthday]["id"][] = ID of each entry, for linking.
#  d[monthday]["data"][] = "start-stop" times of each entry.

$res = sql_query($sql);
if (! $res) echo sql_error();
else for ($i = 0; ($row = sql_row($res, $i)); $i++)
{
    $sql_creator = "SELECT prenom, nom FROM grr_utilisateurs WHERE login = '$row[4]'";
    $res_creator = sql_query($sql_creator);
    if ($res_creator) $row_user = sql_row($res_creator, 0);


    # Fill in data for each day during the month that this meeting covers.
    # Note: int casts on database rows for min and max is needed for PHP3.
    $t = max((int)$row[0], $date_start);
    $end_t = min((int)$row[1], $date_end);
    $day_num = date("j", $t);
    $month_num = date("m", $t);
    $year_num = date("Y", $t);
    //$midnight = mktime(0, 0, 0, $month_num, $day_num, $year);
    // bug changement heure été/hiver
    $midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
    $midnight2 = gmmktime(0, 0, 0, $month_num, $day_num, $year_num);

    if ($debug_flag)
        echo "<br>DEBUG: result $i, id $row[2], starts $row[0], ends $row[1], temps en heures : ".($row[1]- $row[0])/(60*60).", midnight : $midnight \n";

    while ($t < $end_t)
    {
        if ($debug_flag) echo "<br>DEBUG: Entry $row[2] day $day_num\n";
        $d[$day_num]["id"][] = $row[2];
        $d[$day_num]["who"][] = $row[3]." - ".$vocab["created_by"].$row_user[0]." ".$row_user[1];
        $d[$day_num]["who1"][] = $row[3];
        $d[$day_num]["room"][]=$row[5] ;
        $d[$day_num]["color"][]=$row[6];

        $midnight_tonight = $midnight + 86400;

        # Describe the start and end time, accounting for "all day"
        # and for entries starting before/ending after today.
        # There are 9 cases, for start time < = or > midnight this morning,
        # and end time < = or > midnight tonight.
        # Use ~ (not -) to separate the start and stop times, because MSIE
        # will incorrectly line break after a -.

        switch (cmp3($row[0], $midnight) . cmp3($row[1], $midnight_tonight))
        {
            case "> < ":         # Starts after midnight, ends before midnight
            case "= < ":         # Starts at midnight, ends before midnight
                $d[$day_num]["data"][] = date(hour_min_format(), $row[0]) . "~" . date(hour_min_format(), $row[1]);
                break;
            case "> = ":         # Starts after midnight, ends at midnight
                $d[$day_num]["data"][] = date(hour_min_format(), $row[0]) . "~24:00";
                break;
            case "> > ":         # Starts after midnight, continues tomorrow
                $d[$day_num]["data"][] = date(hour_min_format(), $row[0]) . "~===&gt;";
                break;
            case "= = ":         # Starts at midnight, ends at midnight
                $d[$day_num]["data"][] = $all_day;
                break;
            case "= > ":         # Starts at midnight, continues tomorrow
                $d[$day_num]["data"][] = $all_day . "====&gt;";
                break;
            case "< < ":         # Starts before today, ends before midnight
                $d[$day_num]["data"][] = "&lt;====~" . date(hour_min_format(), $row[1]);
                break;
            case "< = ":         # Starts before today, ends at midnight
                $d[$day_num]["data"][] = "&lt;====" . $all_day;
                break;
            case "< > ":         # Starts before today, continues tomorrow
                $d[$day_num]["data"][] = "&lt;====" . $all_day . "====&gt;";
                break;
        }


        # Only if end time > midnight does the loop continue for the next day.
        if ($row[1] <= $midnight_tonight) break;
        $day_num++;
        $t = $midnight = $midnight_tonight;
    }
}
if ($debug_flag)
{
    echo "<p>DEBUG: Array of month day data:<p><pre>\n";
    for ($i = 1; $i <= $days_in_month; $i++)
    {
        if (isset($d[$i]["id"]))
        {
            $n = count($d[$i]["id"]);
            echo "Day $i has $n entries:\n";
            for ($j = 0; $j < $n; $j++)
                echo "  ID: " . $d[$i]["id"][$j] .
                    " Data: " . $d[$i]["data"][$j] . "\n";
        }
    }
    echo "</pre>\n";
}

echo "\n<table border=2 width=\"100%\">\n<tr>";
# Weekday name header row:
echo "<th width=\"12.5%\">".$vocab["rooms"]."</th>\n";
for ($weekcol = 0; $weekcol < 7; $weekcol++)
{
    echo "<th width=\"12.5%\">" . day_name(($weekcol + $weekstarts)%7) . "</th>\n";
}
echo "</tr>\n";

# We need to know what all the rooms area called, so we can show them all
# pull the data from the db and store it. Convienently we can print the room
# headings and capacities at the same time

$sql = "select room_name, capacity, id, description from grr_room where area_id=$area order by 1";
$res = sql_query($sql);

# It might be that there are no rooms defined for this area.
# If there are none then show an error and dont bother doing anything
# else
if (! $res) fatal_error(0, sql_error());
if (sql_count($res) == 0)
{
    echo "<h1>".$vocab[no_rooms_for_area]."</h1>";
    sql_free($res);
} else {
  $li=0;
  for ($ir = 0; ($row = sql_row($res, $ir)); $ir++)
    {
    // Affichage de la première colonne (nom des ressources)
    echo "<tr><th>" . htmlspecialchars($row[0]) ."</th>\n";
    $li++;

    $t = $time;
    $t2 = $time;
    for ($k = 0; $k<=6; $k++)
      {
        $cday = date("j", $t2);
        $t2 += 86400;
        if ($li<=1) {
            // On inscrit le numéro du mois dans la deuxième ligne
            $num_day = strftime("%d", $t);
            $num_month = strftime("%m", $t);
            $num_year = strftime("%Y", $t);
            $t += 86400;
            echo "<td valign=top class=\"cell_month\">
            <div class=\"monthday\">
            <a title=\"".htmlspecialchars($vocab["see_all_the_rooms_for_the_day"])."\"href=\"day.php?year=$num_year&month=$num_month&day=$num_day&area=$area\">$num_day</a>
            </div>\n";
        } else {
            echo "<td valign=top class=\"cell_month\">";
        }
        # Anything to display for this day?
        if (isset($d[$cday]["id"][0])) {
            echo "<font size=-2>";
            $n = count($d[$cday]["id"]);
            # Show the start/stop times, 2 per line, linked to view_entry.
            # If there are 12 or fewer, show them, else show 11 and "...".
            for ($i = 0; $i < $n; $i++) {
                /*if ($i == 11 && $n > 12) {
                    echo " ...\n";
                    break;
                } */
                if ($d[$cday]["room"][$i]==$row[0]) {
                    #if ($i > 0 && $i % 2 == 0) echo "<br>"; else echo " ";
                    echo "\n<table width='100%'>";
                    tdcell($d[$cday]["color"][$i]);
                    echo "</font><b>". $d[$cday]["data"][$i]
                    . "<br></b>"
                    . "<a title=\"".htmlspecialchars($d[$cday]["who"][$i])."\" href=\"view_entry.php?id=" . $d[$cday]["id"][$i]."&page=month\">"
                    . htmlspecialchars($d[$cday]["who1"][$i])
                    . "</font>"
                    . "</a></td></table>";
                }
            }
            echo "</font>";
        }
        echo "&nbsp;</td>\n";
        if (++$weekcol == 5) $weekcol = 0;
      }
      echo "</tr>";
    }
}
echo "</table>\n";

include "trailer.inc.php";
?>