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;
}
}
