function saveName($jsonObject) { $name = $jsonObject->name; $id = $jsonObject->id; $request = "UPDATE company SET name = \"{$name}\" WHERE id = {$id}"; mysql_query($request); if (mysql_error() == '') { return loadCompany($jsonObject); } else { $status = new Errormessage(); $status->addFailure("name", "The name '" . $name . "' is in use.<br> Enter a valid name, please."); return $status; } }
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; } }
function saveName($jsonObject) { $name = $jsonObject->newName; $id = $jsonObject->id; $request = "UPDATE department SET name = '" . $name . "' WHERE id = " . $id; mysql_query($request); if (mysql_error() == '') { return loadDepartment($jsonObject); } else { $status = new Errormessage(); $status->addFailure("name", "The name '" . $name . "' is in use.<br> Enter a valid name, please."); return $status; } }
function create($jsonObject) { $name = $jsonObject->name; $manager = $jsonObject->manager; $parent = $jsonObject->parent; $request = "INSERT INTO department (name, cid, did) VALUES ('" . $name . "', 1, " . $parent . ")"; mysql_query($request); if (mysql_error() == '') { $request = "SELECT * FROM department WHERE name = '" . $name . "'"; mysql_query($request); $result = mysql_query($request); $row = mysql_fetch_object($result); $id = $row->id; if ($manager != null) { $request = "UPDATE employee SET did = " . $id . ", manager = 1 WHERE id = " . $manager; mysql_query($request); } return loadDepartment($id); } else { $status = new Errormessage(); $status->addFailure("name", "The name '" . $name . "' is in use.<br> Enter a valid name, please."); return $status; } }