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;