public function getBusinessCollectedThisMonth() { $domain_name = $this->_domain_name; $first_day_of_month = DateUtils::getFirstDayOfMonth(); $first_day_of_month = $first_day_of_month->format('c'); $last_day_of_month = DateUtils::getLastDayOfMonth(); $last_day_of_month = $last_day_of_month->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_month}' " . "AND created_time <= '{$last_day_of_month}' "; $result = $this->query($query); return $result; }
public static function getMonthlyAnalytics($connection, $city) { $first_day = DateUtils::getFirstDayOfMonth(); $first_day = $first_day->format("Y-m-d H:i:s"); $last_day = DateUtils::getLastDayOfMonth(); $last_day = $last_day->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 >= '{$first_day}' AND create_ts <= '{$last_day}' " . "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 getBusinessIdCollectedThisMonth($connection, $city, $email_id) { $first_day = DateUtils::getFirstDayOfMonth(); $first_day = $first_day->format("Y-m-d"); $last_day = DateUtils::getLastDayOfMonth(); $last_day = $last_day->format("Y-m-d"); $query = "SELECT business_id " . "FROM analytics_employee " . "WHERE city='{$city}' " . "AND\t\t date >= '{$first_day}' " . "AND\t\t date <= '{$last_day}' " . "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; }