require_once "../config.php";
use citibytes\utils\MysqlUtils;
use citibytes\exceptions\DatabaseConnectionException;
use citibytes\exceptions\QueryFailedException;
use citibytes\ApprovedPincodeRequests;
use citibytes\CityPincodes;
$city = $_REQUEST["city"];
if (empty($city) === 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->getAllApprovedPincodes($connection, $city);
//No pincodes with approval pending
if (empty($approved_pincodes) === TRUE) {
$output_json = array("status" => "success", "count" => 0);
echo json_encode($output_json);
return;
}
echo json_encode(array("status" => "success", "count" => count($approved_pincodes), "content" => $approved_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");
echo json_encode($failure_json);
return;
