Select Git revision
TaskGroup.php
Forked from
Stud.IP / Stud.IP
Source project has a limited visibility.
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
TaskGroup.php 3.89 KiB
<?php
namespace Courseware;
use DBManager;
use Statusgruppen;
use User;
/**
* Courseware's tasks.
*
* @author Ron Lucke <lucke@elan-ev.de>
* @license GPL2 or any later version
*
* @since Stud.IP 5.1
*
* @property int $id database column
* @property string $seminar_id database column
* @property string $lecturer_id database column
* @property int $target_id database column
* @property int $task_template_id database column
* @property int $solver_may_add_blocks database column
* @property string $title database column
* @property int $start_date database column
* @property int $end_date database column
* @property int $mkdate database column
* @property int $chdate database column
* @property \SimpleORMapCollection|Task[] $tasks has_many Task
* @property \User $lecturer belongs_to \User
* @property \Course $course belongs_to \Course
* @property \Courseware\StructuralElement $target belongs_to Courseware\StructuralElement
* @property \SimpleORMapCollection $tasks has_many Courseware\Task
*
* @SuppressWarnings(PHPMD.StaticAccess)
*/
class TaskGroup extends \SimpleORMap implements \PrivacyObject
{
protected static function configure($config = [])
{
$config['db_table'] = 'cw_task_groups';
$config['belongs_to']['lecturer'] = [
'class_name' => User::class,
'foreign_key' => 'lecturer_id',
];
$config['belongs_to']['course'] = [
'class_name' => \Course::class,
'foreign_key' => 'seminar_id',
];
$config['belongs_to']['target'] = [
'class_name' => StructuralElement::class,
'foreign_key' => 'target_id',
];
$config['has_many']['tasks'] = [
'class_name' => Task::class,
'assoc_foreign_key' => 'task_group_id',
'on_delete' => 'delete',
'on_store' => 'store',
'order_by' => 'ORDER BY mkdate',
];
parent::configure($config);
}
/**
* Export available data of a given user into a storage object
* (an instance of the StoredUserData class) for that user.
*
* @param StoredUserData $storage object to store data into
*/
public static function exportUserData(\StoredUserData $storage)
{
$task_groups = DBManager::get()->fetchAll('SELECT * FROM cw_task_groups WHERE lecturer_id = ?', [
$storage->user_id,
]);
if ($task_groups) {
$storage->addTabularData(_('Courseware Aufgaben'), 'cw_task_groups', $task_groups);
}
}
public function getSolvers(): iterable
{
$solvers = $this->tasks->pluck('solver');
return $solvers;
}
/**
* Returns all submitters of this TaskGroup.
*
* @returns iterable all the submitters of this TaskGroup.
*/
public function getSubmitters(): iterable
{
return DBManager::get()->fetchAll(
'SELECT solver_id, solver_type FROM cw_tasks WHERE task_group_id = ? AND submitted = 1',
[$this->getId()],
function ($row) {
switch ($row['solver_type']) {
case 'autor':
return \User::find($row['solver_id']);
case 'group':
return \Statusgruppen::find($row['solver_id']);
}
}
);
}
/**
* Returns the task of this TaskGroup given to $solver.
*
* @param User|Statusgruppen $solver
*
* @return Task|null
*/
public function findTaskBySolver($solver)
{
$row = DBManager::get()->fetchOne(
'SELECT id FROM cw_tasks WHERE task_group_id = ? AND solver_id = ? AND solver_type = ?',
[
$this->getId(),
$solver->getId(),
$solver instanceof User ? 'autor' : 'group',
]
);
return empty($row) ? null : Task::find($row['id']);
}
}