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