public function getBusinessCollectedThisWeek() { $domain_name = $this->_domain_name; $first_day_of_week = DateUtils::getFirstDayOfWeek(); $first_day_of_week = $first_day_of_week->format('c'); $last_day_of_week = DateUtils::getLastDayOfWeek(); $last_day_of_week = $last_day_of_week->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 >= '{$first_day_of_week}' " . "AND created_time <= '{$last_day_of_week}' "; $result = $this->query($query); return $result; }
public static function getWeeklyAnalytics($connection, $city) { //$today storing the datetime of start of today $monday = DateUtils::getFirstDayOfWeek(); $monday = $monday->format("Y-m-d H:i:s"); $sunday = DateUtils::getLastDayOfWeek(); $sunday = $sunday->format("Y-m-d H:i:s"); $query = "SELECT pincode,COUNT(*) as business_collected " . "FROM\t analytics_pincode " . "WHERE\t city='{$city}' AND " . "create_ts >= '{$monday}' AND create_ts <= '{$sunday}' " . "GROUP BY pincode " . "ORDER BY business_collected DESC"; $result = mysqli_query($connection, $query); if ($result === FALSE) { error_log($query); throw new QueryFailedException("Query failed"); } $pincode_analytics = array(); $row_count = mysqli_num_rows($result); if ($row_count === 0) { return $pincode_analytics; } while ($row = mysqli_fetch_assoc($result)) { array_push($pincode_analytics, $row); } return $pincode_analytics; }
public static function getBusinessIdCollectedThisWeek($connection, $city, $email_id) { $monday = DateUtils::getFirstDayOfWeek(); $monday = $monday->format("Y-m-d"); $sunday = DateUtils::getLastDayOfWeek(); $sunday = $sunday->format("Y-m-d"); $query = "SELECT business_id " . "FROM analytics_employee " . "WHERE city='{$city}' " . "AND\t\t date >= '{$monday}' " . "AND\t\t date <= '{$sunday}' " . "AND\t\t email_id='{$email_id}' "; $result = mysqli_query($connection, $query); if ($result === FALSE) { error_log($query); throw new QueryFailedException("Query failed"); } $collected_business = array(); while ($row = mysqli_fetch_assoc($result)) { array_push($collected_business, $row["business_id"]); } return $collected_business; }