use citibytes\exceptions\QueryFailedException;
use citibytes\exceptions\DatabaseConnectionException;
$city = $_REQUEST["city"];
$email = $_REQUEST["email"];
if (empty($city) === TRUE || empty($email) === TRUE) {
$error_json = array("status" => "error", "error" => "Empty Input Parameters");
echo json_decode($error_json);
return;
}
try {
$connection = MysqlUtils::getConnection();
$approved_pincode_requests = new ApprovedPincodeRequests();
$approved_pincodes = $approved_pincode_requests->getApprovedPincodes($connection, $email, $city);
$pending_pincode_requests = new PendingPincodeRequests();
$unapproved_pincodes = $pending_pincode_requests->getUnApprovedPincodes($connection, $email, $city);
$city_pincodes = new CityPincodes($city);
$all_pincodes = $city_pincodes->getAllPincodes($connection);
foreach ($approved_pincodes as $approved_pincode) {
unset($all_pincodes[$approved_pincode]);
}
foreach ($unapproved_pincodes as $unapproved_pincode) {
unset($all_pincodes[$unapproved_pincode]);
}
$count = count($all_pincodes);
echo json_encode(array("status" => "success", "count" => $count, "pincodes" => $all_pincodes));
} catch (DatabaseConnectionException $e) {
$failure_json = array("status" => "error", "error" => "Database Unavailable");
echo json_encode($failure_json);
return;
} catch (QueryFailedException $e) {
$failure_json = array("status" => "error", "error" => "Unable to get pending pincode requests");
<?php require_once "config.php"; use citibytes\CityPincodes; $city_name = $_REQUEST["city"]; $city_pincodes = new CityPincodes($city_name); $city_pincodes->import();
use citibytes\exceptions\DatabaseConnectionException;
$city = $_REQUEST["city"];
$email = $_REQUEST["email"];
if (empty($city) === TRUE || empty($email) === TRUE) {
$error_json = array("status" => "error", "error" => "Empty Input Parameters");
echo json_decode($error_json);
return;
}
try {
$connection = MysqlUtils::getConnection();
$approved_pincode_requests = new ApprovedPincodeRequests();
$approved_pincodes = $approved_pincode_requests->getApprovedPincodes($connection, $email, $city);
//No pincodes with approval pending
if (empty($approved_pincodes) === TRUE) {
$output_json = array("status" => "success", "count" => 0);
echo json_encode($output_json);
return;
}
$city_pincodes = new CityPincodes($city);
$pincode_info = $city_pincodes->batchGetPincodeInfo($connection, $approved_pincodes);
echo json_encode(array("status" => "success", "count" => count($pincode_info), "pincodes" => $pincode_info));
} catch (DatabaseConnectionException $e) {
$failure_json = array("status" => "error", "error" => "Database Unavailable");
echo json_encode($failure_json);
return;
} catch (QueryFailedException $e) {
$failure_json = array("status" => "error", "error" => "Unable to get pending pincode requests");
echo json_encode($failure_json);
return;
}
mysqli_close($connection);
