CHIEFSOFT\ameye
154 lines
3.6 KiB
PHP
154 lines
3.6 KiB
PHP
<?php
|
|
/**
|
|
* @file classes/decision/DAO.php
|
|
*
|
|
* Copyright (c) 2014-2022 Simon Fraser University
|
|
* Copyright (c) 2000-2022 John Willinsky
|
|
* Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
|
|
*
|
|
* @class DAO
|
|
*
|
|
* @brief Read and write decisions to the database.
|
|
*/
|
|
|
|
namespace PKP\decision;
|
|
|
|
use APP\decision\Decision;
|
|
use Illuminate\Support\Collection;
|
|
use Illuminate\Support\Facades\App;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\LazyCollection;
|
|
use PKP\core\EntityDAO;
|
|
use PKP\core\traits\EntityWithParent;
|
|
|
|
/**
|
|
* @template T of Decision
|
|
* @extends EntityDAO<T>
|
|
*/
|
|
class DAO extends EntityDAO
|
|
{
|
|
use EntityWithParent;
|
|
|
|
/** @copydoc EntityDAO::$schema */
|
|
public $schema = \PKP\services\PKPSchemaService::SCHEMA_DECISION;
|
|
|
|
/** @copydoc EntityDAO::$table */
|
|
public $table = 'edit_decisions';
|
|
|
|
/** @copydoc EntityDAO::$settingsTable */
|
|
public $settingsTable = '';
|
|
|
|
/** @copydoc EntityDAO::$primaryKeyColumn */
|
|
public $primaryKeyColumn = 'edit_decision_id';
|
|
|
|
/** @copydoc EntityDAO::$primaryTableColumns */
|
|
public $primaryTableColumns = [
|
|
'id' => 'edit_decision_id',
|
|
'dateDecided' => 'date_decided',
|
|
'decision' => 'decision',
|
|
'editorId' => 'editor_id',
|
|
'reviewRoundId' => 'review_round_id',
|
|
'round' => 'round',
|
|
'stageId' => 'stage_id',
|
|
'submissionId' => 'submission_id',
|
|
];
|
|
|
|
/**
|
|
* Get the parent object ID column name
|
|
*/
|
|
public function getParentColumn(): string
|
|
{
|
|
return 'submission_id';
|
|
}
|
|
|
|
/**
|
|
* Instantiate a new DataObject
|
|
*/
|
|
public function newDataObject(): Decision
|
|
{
|
|
return App::make(Decision::class);
|
|
}
|
|
|
|
/**
|
|
* Get the number of decisions matching the configured query
|
|
*/
|
|
public function getCount(Collector $query): int
|
|
{
|
|
return $query
|
|
->getQueryBuilder()
|
|
->count();
|
|
}
|
|
|
|
/**
|
|
* Get a list of ids matching the configured query
|
|
*
|
|
* @return Collection<int,int>
|
|
*/
|
|
public function getIds(Collector $query): Collection
|
|
{
|
|
return $query
|
|
->getQueryBuilder()
|
|
->select($this->table . '.' . $this->primaryKeyColumn)
|
|
->pluck($this->table . '.' . $this->primaryKeyColumn);
|
|
}
|
|
|
|
/**
|
|
* Get a collection of decisions matching the configured query
|
|
* @return LazyCollection<int,T>
|
|
*/
|
|
public function getMany(Collector $query): LazyCollection
|
|
{
|
|
$rows = $query
|
|
->getQueryBuilder()
|
|
->get();
|
|
|
|
return LazyCollection::make(function () use ($rows) {
|
|
foreach ($rows as $row) {
|
|
yield $row->edit_decision_id => $this->fromRow($row);
|
|
}
|
|
});
|
|
}
|
|
|
|
/**
|
|
* @copydoc EntityDAO::fromRow()
|
|
*/
|
|
public function fromRow(object $row): Decision
|
|
{
|
|
return parent::fromRow($row);
|
|
}
|
|
|
|
/**
|
|
* @copydoc EntityDAO::insert()
|
|
*/
|
|
public function insert(Decision $decision): int
|
|
{
|
|
return parent::_insert($decision);
|
|
}
|
|
|
|
/**
|
|
* @copydoc EntityDAO::update()
|
|
*/
|
|
public function update(Decision $decision)
|
|
{
|
|
parent::_update($decision);
|
|
}
|
|
|
|
/**
|
|
* @copydoc EntityDAO::delete()
|
|
*/
|
|
public function delete(Decision $decision)
|
|
{
|
|
parent::_delete($decision);
|
|
}
|
|
|
|
/**
|
|
* Reassign all decisions from one editor to another
|
|
*/
|
|
public function reassignDecisions(int $fromEditorId, int $toEditorId)
|
|
{
|
|
DB::table($this->table)
|
|
->where('editor_id', '=', $fromEditorId)
|
|
->update(['editor_id' => $toEditorId]);
|
|
}
|
|
}
|