summaryrefslogtreecommitdiff
path: root/app/Model/CustomFilter.php
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2016-05-28 19:48:22 -0400
committerFrederic Guillot <fred@kanboard.net>2016-05-28 19:48:22 -0400
commit14713b0ec7ed93ca45578da069ad4e19a7d8addf (patch)
tree79972d53f6091a1ddb17f64a6a05a5523f5d5168 /app/Model/CustomFilter.php
parent936376ffe74c583d3cb819e98f53a85137fdf8bc (diff)
Rename all models
Diffstat (limited to 'app/Model/CustomFilter.php')
-rw-r--r--app/Model/CustomFilter.php104
1 files changed, 0 insertions, 104 deletions
diff --git a/app/Model/CustomFilter.php b/app/Model/CustomFilter.php
deleted file mode 100644
index 9d409bd4..00000000
--- a/app/Model/CustomFilter.php
+++ /dev/null
@@ -1,104 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use Kanboard\Core\Base;
-
-/**
- * Custom Filter model
- *
- * @package model
- * @author Timo Litzbarski
- */
-class CustomFilter extends Base
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'custom_filters';
-
- /**
- * Return the list of all allowed custom filters for a user and project
- *
- * @access public
- * @param integer $project_id Project id
- * @param integer $user_id User id
- * @return array
- */
- public function getAll($project_id, $user_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->columns(
- User::TABLE.'.name as owner_name',
- User::TABLE.'.username as owner_username',
- self::TABLE.'.id',
- self::TABLE.'.user_id',
- self::TABLE.'.project_id',
- self::TABLE.'.filter',
- self::TABLE.'.name',
- self::TABLE.'.is_shared',
- self::TABLE.'.append'
- )
- ->asc(self::TABLE.'.name')
- ->join(User::TABLE, 'id', 'user_id')
- ->beginOr()
- ->eq('is_shared', 1)
- ->eq('user_id', $user_id)
- ->closeOr()
- ->eq('project_id', $project_id)
- ->findAll();
- }
-
- /**
- * Get custom filter by id
- *
- * @access private
- * @param integer $filter_id
- * @return array
- */
- public function getById($filter_id)
- {
- return $this->db->table(self::TABLE)->eq('id', $filter_id)->findOne();
- }
-
- /**
- * Create a custom filter
- *
- * @access public
- * @param array $values Form values
- * @return bool|integer
- */
- public function create(array $values)
- {
- return $this->db->table(self::TABLE)->persist($values);
- }
-
- /**
- * Update a custom filter
- *
- * @access public
- * @param array $values Form values
- * @return bool
- */
- public function update(array $values)
- {
- return $this->db->table(self::TABLE)
- ->eq('id', $values['id'])
- ->update($values);
- }
-
- /**
- * Remove a custom filter
- *
- * @access public
- * @param integer $filter_id
- * @return bool
- */
- public function remove($filter_id)
- {
- return $this->db->table(self::TABLE)->eq('id', $filter_id)->remove();
- }
-}