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/classes/services/queryBuilders/

Edit File: SubmissionQueryBuilder.inc.php

<?php

/**
 * @file classes/services/QueryBuilders/SubmissionQueryBuilder.php
 *
 * Copyright (c) 2014-2021 Simon Fraser University
 * Copyright (c) 2000-2021 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class SubmissionQueryBuilder
 * @ingroup query_builders
 *
 * @brief Submission list Query builder
 */

namespace APP\Services\QueryBuilders;

use Illuminate\Database\Capsule\Manager as Capsule;

class SubmissionQueryBuilder extends \PKP\Services\QueryBuilders\PKPSubmissionQueryBuilder {

/** @var int|array Issue ID(s) */
	protected $issueIds = null;

/** @var int|array Section ID(s) */
	protected $sectionIds = null;

/**
	 * Set issue filter
	 *
	 * @param int|array $issueIds
	 *
	 * @return \APP\Services\QueryBuilders\SubmissionQueryBuilder
	 */
	public function filterByIssues($issueIds) {
		if (!is_null($issueIds) && !is_array($issueIds)) {
			$issueIds = [$issueIds];
		}
		$this->issueIds = $issueIds;
		return $this;
	}

/**
	 * Set section filter
	 *
	 * @param int|array $sectionIds
	 *
	 * @return \APP\Services\QueryBuilders\SubmissionQueryBuilder
	 */
	public function filterBySections($sectionIds) {
		if (!is_null($sectionIds) && !is_array($sectionIds)) {
			$sectionIds = [$sectionIds];
		}
		$this->sectionIds = $sectionIds;
		return $this;
	}

/**
	 * Execute additional actions for app-specific query objects
	 * @return object Query object
	 */
	public function appGet($q) {

if (!empty($this->issueIds)) {
			$issueIds = $this->issueIds;
			$q->leftJoin('publications as issue_p', 'issue_p.submission_id', '=', 's.submission_id')
				->leftJoin('publication_settings as issue_ps','issue_p.publication_id','=','issue_ps.publication_id')
				->where(function($q) use ($issueIds) {
					$q->where('issue_ps.setting_name', '=', 'issueId');
					$q->whereIn('issue_ps.setting_value', $issueIds);
				});
		}

if (!empty($this->sectionIds)) {
			$sectionIds = $this->sectionIds;
			$q->leftJoin('publications as section_p', 'section_p.submission_id', '=', 's.submission_id')
				->whereIn('section_p.section_id', $sectionIds);
		}

return $q;
	}
}