public function getDetail()
{
$db = new DBConnection();
if ($db->connect()) {
if ($this->entity_type == 'Member') {
$member = new Member();
foreach ($this->entity as $property => $value) {
$member->{$property}($value);
}
$query = "SELECT * FROM member WHERE s_ID = '" . $member->getStudentId() . "'";
$result = $db->executeQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
$member->setFirstName($row[1]);
$member->setLastName($row[2]);
$member->setDeptName($row[3]);
$member->setRegisterDate($row[4]);
$member->setEmail($row[5]);
$member->setMobile($row[6]);
}
$db->closeConnection();
return $member;
} elseif ($this->entity_type == 'Resource') {
$resource = new Resource();
foreach ($this->entity as $property => $value) {
$resource->{$property}($value);
}
$query = "SELECT * FROM resource WHERE r_ID='" . $resource->getResourceId() . "'";
$result = $db->executeQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
$resource->setResourceId($row[1]);
$resource->setValue($row[2]);
$resource->setDescription($row[3]);
$resource->setOfficerId($row[4]);
}
$db->closeConnection();
return $resource;
} elseif ($this->entity_type == 'ResourceAllocation') {
$resourceAlloc = new ResourceAllocation();
foreach ($this->entity as $property => $value) {
$resourceAlloc->{$property}($value);
}
$query = "SELECT * FROM resource_alloc WHERE r_ID ='" . $resourceAlloc->getResourceId() . "' AND s_ID = '" . $resourceAlloc->getMemberId() . "'";
$result = $db->executeQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
$resourceAlloc->setComments($row[2]);
$resourceAlloc->setIssuedDate($row[3]);
$resourceAlloc->setDueDate($row[4]);
}
$db->closeConnection();
return $resourceAlloc;
}
} else {
echo "Cannot connect to database";
}
}
