File size: 1,522 Bytes
e4f4821 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 | <?php
namespace Kanboard\Model;
use Kanboard\Core\Base;
class PredefinedTaskDescriptionModel extends Base
{
const TABLE = 'predefined_task_descriptions';
public function getAll($projectId)
{
return $this->db->table(self::TABLE)->eq('project_id', $projectId)->findAll();
}
public function getList($projectId)
{
return array('' => t('None')) + $this->db->hashtable(self::TABLE)->eq('project_id', $projectId)->getAll('id', 'title');
}
public function getById($projectId, $id)
{
return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->findOne();
}
public function getDescriptionById($projectId, $id)
{
return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->findOneColumn('description');
}
public function create($projectId, $title, $description)
{
return $this->db->table(self::TABLE)->persist(array(
'project_id' => $projectId,
'title' => $title,
'description' => $description,
));
}
public function update($projectId, $id, $title, $description)
{
return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->update(array(
'title' => $title,
'description' => $description,
));
}
public function remove($projectId, $id)
{
return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->remove();
}
}
|