working in get_offers view and common util classes file