<?php session_start(); require "../database/connect.php"; require "../database/employees.php"; $empID = $HTTP_GET_VARS["empID"]; $jobs = loadEmployeeJobs($empID); echo "<jobs>"; for ($i = 0; $i < count($jobs); $i++) { echo "<job id='" . $jobs[$i]->jobID . "'>" . $jobs[$i]->priority . "</job>"; } echo "</jobs>"; 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; }