query->from($this->site_nav_table); if (!empty($params['uniacid'])) { $this->query->where('uniacid', $params['uniacid']); } if (!empty($params['position'])) { $this->query->where('position', $params['position']); } if (!empty($params['status'])) { $this->query->where('status', $params['status']); } if (!empty($params['multiid'])) { $this->query->where('multiid', $params['multiid']); } $this->query->orderby(array('displayorder' => 'DESC', 'id' => 'ASC')); return $this->query->getall(); } }