protected function isModerator() { if ($this->rights === false) { $this->rights = (int) $this->db->join('slack_user', 'u.id = su.user_id')->get_field('user', 'rights', 'su.slack_id = ?', $this->user); } return $this->rights > 0; }
/** * @param DatabaseInstance $sql * @return mixed */ protected function fetch_data(DatabaseInstance $sql) { $condition = ''; $params = array(); $id = (int) $this->get('id'); $name = (string) $this->get('name'); $filter = (string) $this->get('filter'); if ($id) { $condition = 'at.id = ?'; $params[] = $id; } elseif ($name) { $condition = 'at.name = ? or atv.name = ?'; $name = trim($name); $params[] = $name; $params[] = $name; } elseif ($filter) { $condition = 'at.name like ? or atv.name like ?'; $filter = '%' . str_replace('\\', '\\\\', trim($filter)) . '%'; $params[] = $filter; $params[] = $filter; } $sql->join('art_tag_variant', 'atv.id_tag = at.id'); $sql->group('at.id'); return $sql->get_table($this->table, $this->fields, $condition, $params); }
protected function remove_meta($item_type, $id_item, $meta_type, $meta = null) { if ($meta === null) { $this->db->delete('meta', 'item_type = ? and id_item = ? and meta_type = ?', array($item_type, $id_item, $meta_type)); } else { $this->db->delete('meta', 'item_type = ? and id_item = ? and meta_type = ? and meta = ?', array($item_type, $id_item, $meta_type, $meta)); } }
/** * @param DatabaseInstance $sql * @return mixed */ protected function fetch_data(DatabaseInstance $sql) { $condition = ''; $params = array(); $id = (int) $this->get('id'); $name = (string) $this->get('name'); $filter = (string) $this->get('filter'); if ($id) { $condition = 'id = ?'; $params[] = $id; } elseif ($name) { $condition = 'name = ?'; $params[] = trim($name); } elseif ($filter) { $condition = 'name like ?'; $params[] = '%' . trim($filter) . '%'; } return $sql->get_table($this->table, $this->fields, $condition, $params); }