Changeset View
Changeset View
Standalone View
Standalone View
plugins/tasklist/drivers/database/tasklist_database_driver.php
| Show First 20 Lines • Show All 326 Lines • ▼ Show 20 Lines | function list_tasks($filter, $lists = null) | ||||
| $sql_query[] = $this->rc->db->ilike($col, '%'.$filter['search'].'%'); | $sql_query[] = $this->rc->db->ilike($col, '%'.$filter['search'].'%'); | ||||
| $sql_add = 'AND (' . join(' OR ', $sql_query) . ')'; | $sql_add = 'AND (' . join(' OR ', $sql_query) . ')'; | ||||
| } | } | ||||
| if ($filter['since'] && is_numeric($filter['since'])) { | if ($filter['since'] && is_numeric($filter['since'])) { | ||||
| $sql_add .= ' AND changed >= ' . $this->rc->db->quote(date('Y-m-d H:i:s', $filter['since'])); | $sql_add .= ' AND changed >= ' . $this->rc->db->quote(date('Y-m-d H:i:s', $filter['since'])); | ||||
| } | } | ||||
| if ($filter['uid']) { | |||||
| $sql_add .= ' AND `uid` IN (' . implode(',', array_map(array($this->rc->db, 'quote'), $filter['uid'])) . ')'); | |||||
| } | |||||
| $tasks = array(); | $tasks = array(); | ||||
| if (!empty($list_ids)) { | if (!empty($list_ids)) { | ||||
| $result = $this->rc->db->query(sprintf( | $result = $this->rc->db->query(sprintf( | ||||
| "SELECT * FROM " . $this->db_tasks . " | "SELECT * FROM " . $this->db_tasks . " | ||||
| WHERE tasklist_id IN (%s) | WHERE tasklist_id IN (%s) | ||||
| AND del=0 | AND del=0 | ||||
| %s | %s | ||||
| ORDER BY parent_id, task_id ASC", | ORDER BY parent_id, task_id ASC", | ||||
| ▲ Show 20 Lines • Show All 503 Lines • Show Last 20 Lines | |||||