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