public function getBusinessCollectedToday() { $domain_name = $this->_domain_name; $start_of_day = DateUtils::getStartOfToday(); $start_of_day = $start_of_day->format('c'); $end_of_day = DateUtils::getEndOfToday(); $end_of_day = $end_of_day->format('c'); $pincode = $this->_pincode; $query = "SELECT business_name,address_line_1,address_line_2, " . "latitude,longitude,status " . "FROM {$domain_name} " . "WHERE pincode='{$pincode}' " . "AND created_time >= '{$start_of_day}' " . "AND created_time <= '{$end_of_day}' "; $result = $this->query($query); return $result; }