function writeJobShifts()
{
//global $jobShifts;
$jobShifts = loadJobShifts();
for ($i = 0; $i < count($jobShifts); $i++) {
echo "<tr><td>" . $jobShifts[$i]->name . "</td>";
echo "<td><input type='button' onclick='getID(\"jshID\").value=\"" . $jobShifts[$i]->name . "\";getID(\"jsh_name\").value=\"" . $jobShifts[$i]->name . "\";getID(\"jshBtn\").value=\"Edit\";getID(\"cancel\").style.display=\"\"' value='Edit'/> ";
echo "<input type='button' onclick='deleteJobShift(\"" . $jobShifts[$i]->name . "\")' value='Delete' /></td></tr>";
}
if (count($jobShifts) <= 0) {
echo "<tr><td>Please add a job shift</td></tr>";
}
}
<?php
session_start();
require "database/connect.php";
require "database/common.php";
require "database/employees.php";
require "database/jobs.php";
require "database/jobShifts.php";
require "database/schedule.php";
require "includes/common.php";
$pageTitle = "Manage Employees";
$javascript = "manageUsers.js";
require "includes/adminHeader.php";
$jobs = buildJobArray();
$shifts = loadJobShifts();
//add employee
if ($_POST["procedure"] == "ADD") {
$empID = addEmployee($_POST["first"], $_POST["last"], $_POST["jobs"], $_POST["hours"], $_POST["address"], $_POST["phone"], $_POST["email"]);
if ($_POST["loginID"] > "") {
saveLogin($empID, $_POST["loginID"], $_POST["loginPassword"]);
$body = "Your account has been created / edited.<br>Username: "******"loginID"] . "<br>Password: "******"loginPassword"];
//mail("*****@*****.**","Shift Scheduler Account Created", $body);
}
//add employee jobs
for ($i = 0; $i < count($jobs); $i++) {
if (isset($_POST["job" . $jobs[$i]->id]) && $_POST["job" . $jobs[$i]->id] > "0") {
saveEmployeeJob($empID, $jobs[$i]->id, $_POST["job" . $jobs[$i]->id]);
}
}
//save employee availability
for ($i = 0; $i < count($shifts); $i++) {
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;
}
