db->select('id') ->where_in('id', array_values(array_unique($ids))) ->where('is_active', 1) ->where('allow_posting', 1); if ($this->db->field_exists('company_id', 'accounts')) { $companyId = isset($this->companycontext) ? (int)$this->companycontext->id() : (int)$this->session->userdata('company_id'); $this->db->where('company_id', $companyId); } $rows = $this->db->get('accounts')->result_array(); return array_map('intval', array_column($rows, 'id')); } }