<?php $hour_begin = 7; $hour_end = 13; print "<h1>" . TimeFormatDay($time) . "</h1>"; print "\n<p class=\"menu_bar\">\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time - 31536000) . "\"><< " . Date("Y", $time - 31536000) . "</a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time - 604800) . "\"><< " . TimeFormat($time - 604800) . "</a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time - 86400) . "\">< " . TimeFormat($time - 86400) . "</a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . time() . "\">Today</a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time + 86400) . "\">" . TimeFormat($time + 86400) . " ></a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time + 604800) . "\">" . TimeFormat($time + 604800) . " >></a>\n<a class=\"menu_tab\" href=\"index2.php?page=datebook_view_day&time=" . ($time + 31536000) . "\">" . Date("Y", $time + 31536000) . " >></a>\n</p>"; $startday_day = date("j", $time); $startday_month = date("n", $time); $startday_year = date("Y", $time); $startday = mktime($hour_begin, 0, 0, $startday_month, $startday_day, $startday_year); $endday = $startday + 86400; // Invoices issued today $sql_invoices = "SELECT invoice_id, invoice_ref, invoice_paid, invoice_due, proj_name, proj_num, proj_id FROM intranet_timesheet_invoice, intranet_projects WHERE invoice_date BETWEEN '{$startday}' AND '{$endday}' AND invoice_project = proj_id ORDER BY invoice_ref"; $result_invoices = mysql_query($sql_invoices, $conn) or die(mysql_error()); if (mysql_num_rows($result_invoices) > 0 and $user_usertype_current > 2) { print "<h2>Invoices Issued Today</h2>"; print "<table summary=\"Invoices due on " . TimeFormat($time) . "\">"; while ($array_invoices = mysql_fetch_array($result_invoices)) { $invoice_id = $array_invoices['invoice_id']; $invoice_ref = $array_invoices['invoice_ref']; $invoice_paid = $array_invoices['invoice_paid']; $invoice_due = $array_invoices['invoice_due']; $proj_name = $array_invoices['proj_name']; $proj_num = $array_invoices['proj_num']; $proj_id = $array_invoices['proj_id']; if ($invoice_due < time() and $invoice_paid == 0) { $highlight = "background-color: #{$settings_alertcolor}"; } else { $highlight = NULL; } print "<tr><td style=\"width: 100px; {$highlight}\"><a href=\"index2.php?page=timesheet_invoice_view&invoice_id={$invoice_id}\">{$invoice_ref}</a>";
if ($techmessage != "" and $settings_showtech == "1" and $usertype_status == "admin") { $timesheetaction = $timesheetaction . "<div class=\"warning\"><p><strong>Support Messages</strong></p><p>{$techmessage}</p></div>"; } // This includes the "outstanding" section, which alerts users to outstanding actions. if ($alertmessage == NULL) { include "inc_files/inc_outstanding.php"; } if ($useraction == "defineuser") { include "inc_files/inc_alertuser.php"; } if ($timesheetaction && $_COOKIE[timesheethide] < time() && $hidealerts != "yes") { echo "<div>" . $timesheetaction . "</div>"; } // Check for any upcoming holidays if ($_GET[page] == NULL) { $today = TimeFormatDay(time()); echo "<h1>{$today}</h1>"; ListHolidays(); } if ($useraction != "defineuser") { // Add the project title, if there is one either through POST or GET if ($proj_title) { echo $proj_title; } // Include the relevant page if the $_GET[page] variable is not blank, otherwise deliver the default page if ($page_redirect != NULL) { $inc_file = "inc_files/inc_" . $page_redirect . ".php"; } elseif ($_GET[page] != NULL) { $inc_file = "inc_files/inc_" . $_GET[page] . ".php"; } elseif ($_POST[page] != NULL) { $inc_file = "inc_files/inc_" . $_POST[page] . ".php";
function ListHolidays() { global $conn; echo "<h2>Upcoming Holidays</h2>"; $nowtime = time() - 43200; $sql5 = "SELECT user_id, user_name_first, user_name_second, holiday_date, holiday_timestamp, holiday_paid, holiday_length, holiday_approved FROM intranet_user_details, intranet_user_holidays WHERE holiday_user = user_id AND holiday_timestamp BETWEEN {$nowtime} AND " . ($nowtime + 2 * 604800) . " ORDER BY holiday_timestamp, user_name_second"; $result5 = mysql_query($sql5, $conn) or die(mysql_error()); if (mysql_num_rows($result5) > 0) { $current_date = 0; $holidaymessage = $holidaymessage . "<table>"; while ($array5 = mysql_fetch_array($result5)) { if ($current_id != $user_id and $current_id > 0) { $holidaymessage = $holidaymessage . "</td></tr>"; } $user_id = $array5['user_id']; $user_name_first = $array5['user_name_first']; $user_name_second = $array5['user_name_second']; $holiday_timestamp = $array5['holiday_timestamp']; $holiday_length = $array5['holiday_length']; $holiday_paid = $array5['holiday_paid']; $holiday_date = $array5['holiday_date']; $holiday_approved = $array5['holiday_approved']; $calendar_link = "index2.php?page=holiday_approval&year=" . date("Y", $holiday_timestamp) . "#Week" . date("W", $holiday_timestamp); if ($holiday_approved == NULL) { $holiday_approved1 = "<span style=\"color: red;\">"; $holiday_approved2 = "</span>"; } else { unset($holiday_approved1); unset($holiday_approved2); } if ($current_date != $holiday_date) { $holidaymessage = $holidaymessage . "<tr><td>" . TimeFormatDay($holiday_timestamp) . "</td><td>"; } else { $holidaymessage = $holidaymessage . ", "; } if ($holiday_length < 1) { $holiday_length = " (Half Day)"; } else { unset($holiday_length); } $holidaymessage = $holidaymessage . "<a href=\"{$calendar_link}\">" . $holiday_approved1 . $user_name_first . " " . $user_name_second . $holiday_length . $holiday_approved2 . "</a>"; $current_date = $holiday_date; } $holidaymessage = $holidaymessage . "</td></tr></table>"; } echo $holidaymessage; }