CHIEFSOFT\ameye
99 lines
2.4 KiB
PHP
99 lines
2.4 KiB
PHP
<?php
|
|
|
|
/**
|
|
* @file classes/submission/ReviewFilesDAO.php
|
|
*
|
|
* Copyright (c) 2014-2021 Simon Fraser University
|
|
* Copyright (c) 2003-2021 John Willinsky
|
|
* Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
|
|
*
|
|
* @class ReviewFilesDAO
|
|
*
|
|
* @ingroup submission
|
|
*
|
|
* @brief Operations for managing review round / submission file associations.
|
|
* These control which files are available for download by reviewers during review.
|
|
*/
|
|
|
|
namespace PKP\submission;
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class ReviewFilesDAO extends \PKP\db\DAO
|
|
{
|
|
/**
|
|
* Grant a review file to a review.
|
|
*
|
|
* @param int $reviewId Review assignment ID
|
|
* @param int $submissionFileId Submission file ID
|
|
*/
|
|
public function grant($reviewId, $submissionFileId)
|
|
{
|
|
$this->update(
|
|
'INSERT INTO review_files
|
|
(review_id, submission_file_id)
|
|
VALUES
|
|
(?, ?)',
|
|
[(int) $reviewId, (int) $submissionFileId]
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Revoke a review's association with a review file.
|
|
*
|
|
* @param int $reviewId Review assignment ID.
|
|
* @param int $fileId Review file ID.
|
|
*/
|
|
public function revoke($reviewId, $fileId)
|
|
{
|
|
$this->update(
|
|
'DELETE FROM review_files WHERE review_id = ? AND file_id = ?',
|
|
[(int) $reviewId, (int) $fileId]
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Revoke a review's association with all submission files.
|
|
*
|
|
* @param int $reviewId Review assignment ID.
|
|
*/
|
|
public function revokeByReviewId($reviewId)
|
|
{
|
|
$this->update(
|
|
'DELETE FROM review_files WHERE review_id = ?',
|
|
[(int) $reviewId]
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Revoke a review's association based on submission file id.
|
|
*/
|
|
public function revokeBySubmissionFileId(int $submissionFileId)
|
|
{
|
|
$this->update(
|
|
'DELETE FROM review_files WHERE submission_file_id = ?',
|
|
[(int) $submissionFileId]
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Check review file availability
|
|
*
|
|
* @param int $reviewId
|
|
* @param int $submissionFileId
|
|
*
|
|
* @return bool
|
|
*/
|
|
public function check($reviewId, $submissionFileId)
|
|
{
|
|
return DB::table('review_files')
|
|
->where('review_id', (int) $reviewId)
|
|
->where('submission_file_id', (int) $submissionFileId)
|
|
->exists();
|
|
}
|
|
}
|
|
|
|
if (!PKP_STRICT_MODE) {
|
|
class_alias('\PKP\submission\ReviewFilesDAO', '\ReviewFilesDAO');
|
|
}
|