ReviewFilesDAO.inc.php

<?php
 
class ReviewFilesDAO extends DAO {
 
   function grant($reviewId, $fileId) {
      $this->update(
         'INSERT INTO review_files
         (review_id, file_id)
         VALUES
         (?, ?)',
         array(
            (int) $reviewId,
            (int) $fileId
         )
      );
   }
 
   function revoke($reviewId, $fileId) {
      $this->update(
         'DELETE FROM review_files WHERE review_id = ? AND file_id = ?',
         array(
            (int) $reviewId,
            (int) $fileId
         )
      );
   }
 
   function revokeByReviewId($reviewId) {
      $this->update(
         'DELETE FROM review_files WHERE review_id = ?',
         (int) $reviewId
      );
   }
 
   function check($reviewId, $fileId) {
      $result = $this->retrieve(
         'SELECT * FROM review_files WHERE review_id = ? AND file_id = ?',
         array((int) $reviewId, (int) $fileId)
      );
 
      $returner = $result->RecordCount();
      $result->Close();
      return $returner;
   }
}