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;
}
