One Hat Cyber Team

Your IP : 216.73.216.182

Server IP : 203.175.9.166

Server : Linux tanggamus.iixcp.rumahweb.net 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64

Server Software : LiteSpeed

PHP Version : 7.4.33

Buat File | Buat Folder

Dir : ~/home/cite5577/www/lib/pkp/classes/submission/

View File Name : ReviewFilesDAO.inc.php

<?php

/**
 * @file classes/submission/ReviewFilesDAO.inc.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.
 */
use Illuminate\Database\Capsule\Manager as Capsule;

class ReviewFilesDAO extends DAO {

	/**
	 * Grant a review file to a review.
	 * @param $reviewId int Review assignment ID
	 * @param $submissionFileId int Submission file ID
	 */
	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 $reviewId int Review assignment ID.
	 * @param $fileId int Review file ID.
	 */
	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 $reviewId int Review assignment ID.
	 */
	function revokeByReviewId($reviewId) {
		$this->update(
			'DELETE FROM review_files WHERE review_id = ?',
			[(int) $reviewId]
		);
	}

	/**
	 * Check review file availability
	 * @param $reviewId integer
	 * @param $submissionFileId int
	 * @return boolean
	 */
	function check($reviewId, $submissionFileId) {
		return Capsule::table('review_files')
			->where('review_id', (int) $reviewId)
			->where('submission_file_id', (int) $submissionFileId)
			->exists();
	}
}