function saveEmployee($jsonObject)
{
$id = $jsonObject->id;
$name = $jsonObject->newName;
$address = $jsonObject->newAddress;
$salary = $jsonObject->newSalary;
$minimumSalary = getMinimumSalaryForEmployee($id);
$maximumSalary = getMaximumSalaryForEmployee($id);
if ($minimumSalary > $salary || $maximumSalary < $salary) {
$status = new Errormessage();
$status->addFailure("salary", "Enter a valid (" . $minimumSalary . " to " . $maximumSalary . ") salary, please.");
return $status;
}
$request = "UPDATE employee SET name = '" . $name . "', address = '" . $address . "', salary = '" . $salary . "' WHERE id = " . $id;
mysql_query($request);
$error = mysql_error();
if ($error == '' || $error == null) {
return loadEmployee($jsonObject);
} else {
$status = new Errormessage();
$status->addFailure("nameaddress", "Duplicate entry for name and address.<br>Enter a unique name and address combination,<br> please.");
return $status;
}
}
function create($jsonObject)
{
$name = $jsonObject->name;
$address = $jsonObject->address;
$salary = $jsonObject->salary;
$parent = $jsonObject->parent;
$manager = 0;
$minimumSalary = getMinimumSalaryForEmployee($parent, $manager);
$maximumSalary = getMaximumSalaryForEmployee($parent, $manager);
if ($minimumSalary > $salary || $maximumSalary < $salary) {
$status = new Errormessage();
$status->addFailure("salary", "Enter a valid (" . $minimumSalary . " to " . $maximumSalary . ") salary, please.");
return $status;
}
$request = "INSERT employee (name, address, salary, manager, cid, did) VALUES ('" . $name . "', '" . $address . "', " . $salary . ", " . $manager . ", 1, " . $parent . ")";
mysql_query($request);
$error = mysql_error();
if ($error == '' || $error == null) {
$request = "SELECT * FROM employee WHERE name = '" . $name . "'";
$result = mysql_query($request);
$row = mysql_fetch_object($result);
return loadEmployee($row->id);
} else {
$status = new Errormessage();
$status->addFailure("nameaddress", "Duplicate entry for name and address.<br>Enter a unique name and address combination,<br> please.");
return $status;
}
}
for ($i = 0; $i < count($shifts); $i++) {
for ($j = 1; $j <= 7; $j++) {
if (isset($_POST["shift" . $shifts[$i]->name . "-" . $j])) {
saveEmployeeAvailable($_POST["emp_id"], $shifts[$i]->name, $j, "1");
}
}
}
}
//delete job
if ($_POST["procedure"] == "Delete") {
deleteEmployee($_POST["emp_id"]);
}
//edit employee selected
if ($_POST["procedure"] == "Edit") {
$emp_id = $_POST["employees"];
loadEmployee($emp_id);
$btn_text = "Edit";
}
$staff = loadSortedEmployees();
?>
<br>
<div class="tabs">
<ul>
<li id="tab1" class="current"><span><a href="javascript:mcTabs.displayTab('tab1','panel1');" onMouseDown="return false;">Search</a></span></li>
<li id="tab2"><span><a href="javascript:mcTabs.displayTab('tab2','panel2');searchAllEmployees();resetChanges();" onMouseDown="return false;">All Employees</a></span></li>
</ul>
</div>
<div class="panel_wrapper" style="height:610px; overflow:auto">
require "includes/common.php";
$pageTitle = "Profile";
require "includes/userHeader.php";
//load emp_id
loadUser($_SESSION["id"]);
//save profile
if ($_POST["submitBtn"] == "Edit") {
updateProfile($empID, $_POST["first"], $_POST["last"], $_POST["address"], $_POST["phone1"] . $_POST["phone2"], $_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);
}
}
//load profile
loadEmployee($empID);
padBegin(6, 6);
?>
<table>
<tr>
<td align="right" nowrap>First Name</td>
<td><input name="first" id="first" type="text" value="<?php
echo $emp_first_name;
?>
" /></td>
</tr>
<tr>
<td align="right" nowrap>Last Name</td>
<td><input name="last" id="last" type="text" value="<?php
echo $emp_last_name;
