public static function addNewBusiness($connection, $business_id, $pincode, $city, $date)
{
$is_business_added = PincodeAnalytics::isBusinessAdded($connection, $business_id);
if ($is_business_added === TRUE) {
return TRUE;
}
$query = "INSERT INTO analytics_pincode " . "VALUES ('{$business_id}','{$pincode}','{$city}','{$date}') ";
$result = mysqli_query($connection, $query);
if ($result === FALSE) {
error_log($query);
throw new QueryFailedException("Query failed");
}
return TRUE;
}
if ($is_admin == TRUE) {
$success_json = array("status" => "success");
echo json_encode($success_json);
exit;
}
error_log('check ' . $json);
$business_id = $json_data["business_id"];
$city = $json_data["city"];
$pincode = $json_data["pincode"];
$email_id = $json_data["email_id"];
$duration = $json_data["duration"];
$iso_date = new \DateTime($json_data["date"]);
$date = $iso_date->format("Y-m-d");
$date_time = $iso_date->format("Y-m-d H:i:s");
try {
$connection = MysqlUtils::getConnection();
$result = EmployeeAnalytics::recordTimeSpentOnABusiness($connection, $email_id, $business_id, $city, $date, $duration);
$result = PincodeAnalytics::addNewBusiness($connection, $business_id, $pincode, $city, $date_time);
$success_json = array("status" => "success");
echo json_encode($success_json);
} catch (DatabaseConnectionException $e) {
$failure_json = array("status" => "error", "error" => "Database Unavailable");
echo json_encode($failure_json);
return;
} catch (QueryFailedException $e) {
error_log(mysqli_error($connection));
$failure_json = array("status" => "error", "error" => "Query execution failed");
echo json_encode($failure_json);
return;
}
mysqli_close($connection);
$city = $_REQUEST["city"];
if (empty($city) === TRUE || empty($period) === TRUE) {
$error_json = array("status" => "error", "error" => "Empty Input Parameters");
echo json_decode($error_json);
return;
}
try {
$connection = MysqlUtils::getConnection();
if ($period === "today") {
$analytics = PincodeAnalytics::getTodayAnalytics($connection, $city);
} elseif ($period === "weekly") {
$analytics = PincodeAnalytics::getWeeklyAnalytics($connection, $city);
} elseif ($period === "monthly") {
$analytics = PincodeAnalytics::getMonthlyAnalytics($connection, $city);
} elseif ($period === "tilldate") {
$analytics = PincodeAnalytics::getTillDateAnalytics($connection, $city);
}
//No pincodes collected
if (empty($analytics) === TRUE) {
$output_json = array("status" => "success", "count" => 0, "date" => getFormattedDate($period), "total_business_collected" => 0);
echo json_encode($output_json);
return;
}
$total_business_collected = calculateTotalBusinessCollected($analytics);
echo json_encode(array("status" => "success", "date" => getFormattedDate($period), "count" => count($analytics), "analytics" => $analytics, "total_business_collected" => $total_business_collected));
} catch (DatabaseConnectionException $e) {
$failure_json = array("status" => "error", "error" => "Database Unavailable");
echo json_encode($failure_json);
return;
} catch (QueryFailedException $e) {
error_log(mysqli_error($connection));
