public static function getRequestResource(en\Request $request)
{
$request_id = $request->getRequestId();
$conn = cont\connection::getConnectionObject();
$con = $conn->getConnection();
$sql = $con->prepare("SELECT * FROM RequestResource WHERE request_id={$request_id}");
$sql->bind_param('s', $request_id);
$sql->execute();
$result = $sql->get_result();
//
$requestResources = array();
$res_num = 0;
while ($row = $result->fetch_assoc()) {
$requestResource = new en\RequestResource();
$requestResource->setResourceId($row[1]);
$requestResource->setItemBorrowingDate($row[2]);
$requestResource->setIssueDate($row[3]);
$requestResource->setReturnDate($row[4]);
$requestResource->setStatus($row[5]);
$requestResources[$res_num] = $requestResource;
$res_num++;
}
return $requestResources;
}
