function loadEmployee($id)
{
// name
$request = "SELECT * FROM employee WHERE id = {$id}";
$result = mysql_query($request);
$row = mysql_fetch_object($result);
$name = $row->name;
$address = $row->address;
$salary = $row->salary;
$did = $row->did;
$departments = array();
$request = "SELECT * FROM department";
$result = mysql_query($request);
while ($row = mysql_fetch_object($result)) {
$department["id"] = $row->id;
$department["name"] = $row->name;
if ($row->id == $did) {
$department["parent"] = true;
} else {
$department["parent"] = false;
}
$departments[] = $department;
}
// create employee object
$employee = new Employee();
$employee->setId($id);
$employee->setName($name);
$employee->setAddress($address);
$employee->setSalary($salary);
$employee->setDepartments($departments);
// return employee object
return $employee;
}
public function constructReturnArr($res)
{
$arr = array();
$i = 0;
while ($row = mysql_fetch_assoc($res)) {
$emp = new Employee();
$emp->setName($row['name']);
$emp->setCode($row['code']);
$emp->setSalary($row['salary']);
$emp->setGrade($row['grade']);
$arr[$i] = $emp;
$i++;
}
$this->getConnection()->releaseRes($res);
return $arr;
}
function loadEmployee($jsonObject)
{
$id = $jsonObject->id;
// name
$request = "SELECT * FROM employee WHERE id = {$id}";
$result = mysql_query($request);
$row = mysql_fetch_object($result);
$name = $row->name;
$address = $row->address;
$salary = $row->salary;
// create department object
$employee = new Employee();
$employee->setName($name);
$employee->setAddress($address);
$employee->setSalary($salary);
// return department object
return $employee;
}
