gistfile1.txt

    // TagRepository
    public function search(TagSearchData $search, Array $params = null)
    {   
        $where = Arr::extract($search->asArray(), ['tag', 'type','role']);
        if ($search->parent) {
            $where['parent_id'] = $search->parent;
        }   

        if ($search->role) {
            $where['role'] = $search->role;
        }

        // Start the query, removing empty values
        $query = $this->selectQuery(array_filter($where));

        if ($search->q) {
            // Tag text searching
            $query->where('tag', 'LIKE', "%{$search->q}%");
        }   

        if (!empty($params['orderby'])) {
            $query->order_by($params['orderby'], Arr::get($params, 'order'));
        }   

        if (!empty($params['offset'])) {
            $query->offset($params['offset']);
        }   
        if (!empty($params['limit'])) {
            $query->limit($params['limit']);
        }   

        $results = $query->execute($this->db);

        return $this->getCollection($results->as_array());
    }