/**
  * A method to get a meeting that is before the one that is provided as a parameter
  * @param Meeting $meeting the meeting after the one that should be returned
  * @return Meeting|null the previous meeting
  */
 public static function getPreviousMeeting($meeting)
 {
     # Get database connection
     $objPDO = PDOFactory::get();
     # Get project ID from session
     $projectId = HTTPSession::getInstance()->PROJECT_ID;
     # Get the previous meeting, which we can recognize by
     # 1. datetime of that meeting is less than meeting provided
     # 2. Meeting is not deleted, however can be cancelled, because we might look for a meeting that was cancelled
     # 3. Meeting is approved
     $strQuery = "SELECT id FROM Meeting WHERE project_id = :project_id\n                      AND datetime < (SELECT datetime FROM Meeting WHERE id = " . $meeting->getID() . ")\n                      AND is_deleted = 0\n                      AND is_approved = 1\n                      ORDER BY datetime DESC\n                      LIMIT 1";
     $objStatement = $objPDO->prepare($strQuery);
     $objStatement->bindValue(':project_id', $projectId, PDO::PARAM_INT);
     $objStatement->execute();
     # Define empty variable
     $prevMeeting = null;
     # Get the previous meeting if it exists
     if ($row = $objStatement->fetch(PDO::FETCH_ASSOC)) {
         $prevMeeting = new Meeting($row['id']);
     }
     # The previous meeting
     return $prevMeeting;
 }
 /**
  * A method to deny access if user is trying to cancel two meetings in a row
  * @param Meeting $meeting the meeting object
  * @param null $error if error should be displayed
  */
 protected function checkAuthTwoMeetingsInRow($meeting, $error = null)
 {
     # Two meetings in a row cannot be cancelled, if previous meeting was cancelled
     # then we cannot approve this meeting to be cancelled
     if ($meeting->getPreviousMeeting() instanceof Meeting && $meeting->getPreviousMeeting()->getIsCancelled() && !$error) {
         header('Location: ' . SITE_URL . 'meetings/cancel/' . $meeting->getID() . '/error');
     }
 }