public function get_all_offers_pending(){
$db = \Config\Database::connect();
$builder = $db->table('company_offers as co');
$query = $builder->select('*')
->join('companies as c', 'c.company_id = co.company_id')
->join('company_contact_info as cci', 'cci.company_id = co.company_id')
->join('sectors as s','s.sector_id = c.sector')
->where('co.offer_status =', 'pending')
->get();
return $query->getResult();
}