} 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;