<?php
session_start();
require "../database/connect.php";
require "../database/employees.php";
$empID = $HTTP_GET_VARS["empID"];
$result = loadEmployeeAvailable($empID);
echo "<availability>";
for ($i = 0; $i < count($result); $i++) {
echo "<jobshift name='" . $result[$i]->shift . "' day='" . $result[$i]->day . "'>" . $result[$i]->value . "</jobshift>";
}
echo "</availability>";
require "../database/disconnect.php";
function loadRandomEmployees()
{
$shifts = loadJobShifts();
$query = "SELECT * FROM ss_employees ORDER BY RAND()";
$result = mysql_query($query);
$num = mysql_numrows($result);
for ($i = 0; $i < $num; $i++) {
$e[$i] = new Employee();
$e[$i]->id = mysql_result($result, $i, "emp_id");
$e[$i]->jobs = loadEmployeeJobs($e[$i]->id);
$e[$i]->shifts = loadEmployeeAvailable($e[$i]->id);
$e[$i]->name = mysql_result($result, $i, "emp_first_name");
if (strlen($e[$i]->name) > 8) {
$e[$i]->name = substr($e[$i]->name, 0, 8);
}
$tmp = mysql_result($result, $i, "emp_last_name");
if ($tmp > "") {
$e[$i]->name .= ", " . substr($tmp, 0, 1);
}
$e[$i]->hours = mysql_result($result, $i, "emp_hours");
$e[$i]->availableHours = $e[$i]->hours;
//load available shifts
for ($j = 0; $j < count($shifts); $j++) {
$e[$i]->shifts[$shifts[$j]->name] = array();
for ($k = 1; $k <= 7; $k++) {
$e[$i]->shifts[$shifts[$j]->name][$k] = 0;
}
}
$query = "SELECT * FROM ss_employeeavailable WHERE eav_emp_id = '" . $e[$i]->id . "'";
$result2 = mysql_query($query);
$num2 = mysql_numrows($result2);
for ($j = 0; $j < $num2; $j++) {
$shiftName = mysql_result($result2, $j, "eav_jsh_name");
$day = mysql_result($result2, $j, "eav_day");
$e[$i]->shifts[$shiftName][$day] = 1;
}
}
return $e;
}
