} else {
$year_allowance = $user_holidays;
}
$holiday_paid_total = 0;
$holiday_unpaid = 0;
$holiday_total = 0;
$holiday_total_year = 0;
$study_leave_total = 0;
$jury_service_total = 0;
$sql_count = "SELECT * FROM intranet_user_holidays WHERE holiday_user = {$user_id} AND holiday_year <= {$year} AND holiday_timestamp > {$user_user_added} ORDER BY holiday_timestamp";
$result_count = mysql_query($sql_count, $conn);
while ($array_count = mysql_fetch_array($result_count)) {
$holiday_year = $array_count['holiday_year'];
$holiday_length = $array_count['holiday_length'];
$holiday_paid = $array_count['holiday_paid'];
$user_allowance = UserHolidays($user_id);
if ($holiday_year == $year) {
if ($holiday_paid == 1) {
$holiday_paid_total = $holiday_paid_total + $holiday_length;
} elseif ($holiday_paid == 2) {
$study_leave_total = $study_leave_total + $holiday_length;
} elseif ($holiday_paid == 3) {
$jury_service_total = $jury_service_total + $holiday_length;
} else {
$holiday_unpaid = $holiday_unpaid + $holiday_length;
}
$holiday_total_year = $holiday_total_year + $holiday_length;
} else {
//if ($holiday_paid == 1) { $holiday_paid_total = $holiday_paid_total + $holiday_length; }
}
if ($holiday_paid == 1) {
$pdf->Cell($bar_width_proj, 4, $proj_num, 0, 0, C, 1);
$pdf->SetFillColor(255, 255, 255);
$pdf->Cell(0.5, 4, '', 0, 0, C, 0);
$pdf->SetFillColor(150, 150, 150);
}
}
$pdf->Cell(0, 4, '', 0, 1, R);
}
// Now examine holidays taken and entitlement
$pdf->SetFont('Helvetica', '', 6);
$pdf->SetTextColor(0);
$pdf->Cell($name_width, 4, 'Holidays Remaining', 0, 0, R);
$pdf->SetDrawColor(255, 255, 255);
$pdf->SetLineWidth(0.5);
$pdf->SetFillColor(200, 200, 200);
$holidays_allowed = UserHolidays($user_id);
$pdf->Cell(0, 4, $holidays_allowed, 0);
$pdf->Cell(0, 6, '', 0, 1, L);
}
function HolidayCalendar($year)
{
global $pdf;
global $conn;
$pdf->addPage();
// New page with upcoming holidays, etc.
$page_title = "Holidays " . $year;
$pdf->SetFont('Helvetica', 'b', 24);
$pdf->SetTextColor($format_bg_r, $format_bg_g, $format_bg_b);
$pdf->MultiCell(0, 8, $page_title, 0, 1, L);
$pdf->Cell(0, 2, '', 0, 1);
$pdf->SetFont('Helvetica', 'b', 18);
echo "<h2>Bank Holidays</h2>";
$sql_bankholidays = "SELECT bankholiday_timestamp FROM intranet_user_holidays_bank WHERE bankholiday_timestamp > " . time() . " ORDER BY bankholiday_timestamp LIMIT 1";
$result_bankholidays = mysql_query($sql_bankholidays, $conn);
$array_bankholidays = mysql_fetch_array($result_bankholidays);
$bankholiday_timestamp = $array_bankholidays['bankholiday_timestamp'];
echo "<p>The next Bank Holiday is <a href=\"index2.php?page=datebook_view_day&time={$bankholiday_timestamp}\">" . TimeFormat($bankholiday_timestamp) . ".</a></p>";
$sql_holiday = "SELECT user_holidays, user_user_added, user_user_ended FROM intranet_user_details WHERE user_id = {$user_id} AND holiday_paid = 1 LIMIT 1";
$result_holiday = mysql_query($sql_holiday, $conn);
$array_holiday = mysql_fetch_array($result_holiday);
$user_holidays = $array_holiday['user_holidays'];
$user_user_added = $array_holiday['user_user_added'];
$user_user_ended = $array_holiday['user_user_ended'];
$beginning_of_year = mktime(0, 0, 0, 1, 1, $this_year);
$end_of_year = mktime(0, 0, 0, 1, 1, $this_year + 1);
echo "<h2>Holiday Request</h2>";
$holiday_remaining = UserHolidays($user_id, "yes");
if ($_POST[assess] == 1) {
echo "<fieldset><legend>Confirm Holiday Request</legend>";
$holiday_day_start = AssessDays($_POST[holiday_day_start]);
$holiday_day_back = AssessDays($_POST[holiday_day_back]);
$holiday_count = CheckHolidays($holiday_day_start, $holiday_day_back, "no", $user_id, $_POST[holiday_length], $paid);
$holiday_remaining = $holiday_remaining - $holiday_count;
//echo "<p>This will leave you with " . $holiday_remaining . " remaining holidays this year.</p>";
echo "<p><form action=\"index2.php?page=holiday_request\" method=\"post\"><input type=\"hidden\" name=\"action\" value=\"holiday_request\" /><input type=\"hidden\" name=\"assess\" value=\"2\" /><input type=\"hidden\" value=\"{$time_begin}\" name=\"holiday_begin\" /><input type=\"hidden\" value=\"{$_POST['holiday_length']}\" name=\"holiday_length\" /><input type=\"hidden\" value=\"{$time_back}\" name=\"holiday_back\" /><input type=\"hidden\" value=\"{$user_id}\" name=\"user_id\" /><input type=\"hidden\" value=\"{$paid}\" name=\"paid\" /><input type=\"submit\" value=\"Confirm\" /></p>";
echo "</fieldset>";
}
if ($_POST[assess] == 2) {
echo "<fieldset><legend>Holiday Request Confirmed</legend>";
echo "<p>You have requested the following days holiday:</p>";
$holiday_count = CheckHolidays($_POST[holiday_begin], $_POST[holiday_back], "yes", $user_id, $_POST[holiday_length], $paid);
$holiday_remaining = $user_holidays - $holiday_count;
