public function addStudentRequestAction() { $student_id = $_GET["student_id"]; $request_id = $_GET["request_id"]; $tableList = $_GET["tableList"]; $request = new Request(); $request->setRequestId($request_id); $request->setStudentId($student_id); $request->setRequestDate(date("Y-m-d")); $resourcesArray = array(); //$tableList =json_decode($tableList); $cout = 0; for ($x = 0; $x < count($tableList); $x += 1) { $cout++; $requestResource = new RequestResource(); $requestResource->setRequestId($request_id); $requestResource->setResourceId($tableList[$x][0]); $requestResource->setQty($tableList[$x][2]); $requestResource->setItemBorrowingDate($tableList[$x][3]); $requestResource->setReturnDate($tableList[$x][4]); $resourcesArray[] = $requestResource; } $status = StudentRequestDBaccess::addStudentRequest($request, $resourcesArray); $v = $resourcesArray[0]; return new JsonResponse(['status' => $status]); }
public static function addRequestResource($con, RequestResource $requestResource) { try { $sql = $con->prepare("INSERT INTO RequestResource VALUES(?,?,?,?,?,?,?)"); $requestId = $requestResource->getRequestId(); $resourceId = $requestResource->getResourceId(); $qty = $requestResource->getQty(); $borrowingDate = $requestResource->getItemBorrowingDate(); $issueDate = date('Y-m-d'); $returnDate = $requestResource->getReturnDate(); $status = 1; $sql->bind_param("ssisssi", $requestId, $resourceId, $qty, $borrowingDate, $issueDate, $returnDate, $status); if ($sql->execute() == TRUE) { return true; } else { return false; } } catch (Exception $w) { return false; } }
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; }
public function approvalAction() { $tableList = $_GET["resourceTable"]; $resourcesArray = array(); echo "<br/>"; for ($x = 0; $x < count($tableList) - 1; $x += 1) { $requestResource = new en\RequestResource(); $requestResource->setRequestId($tableList[$x][0]); $requestResource->setResourceId($tableList[$x][1]); $requestResource->setItemBorrowingDate($tableList[$x][2]); $requestResource->setStatus($tableList[$x][6]); $resourcesArray[$x] = $requestResource; } $status = cont\ResourceDBaccess::updateRequestResources($resourcesArray); $v = $resourcesArray[0]; return new JsonResponse(['status' => $status]); }