require_once "../config.php"; use citibytes\CityPincodes; use citibytes\UserProfile; use citibytes\utils\MysqlUtils; use citibytes\ApprovedPincodeRequests; use citibytes\PendingPincodeRequests; use citibytes\exceptions\QueryFailedException; use citibytes\exceptions\DatabaseConnectionException; $data = $_REQUEST["json"]; $data = stripslashes($data); $data = json_decode($data, TRUE); $email_id = $data["email_id"]; try { $connection = MysqlUtils::getConnection(); //DELETE item from approved_pincode_requests $approved_pincode_requests = new ApprovedPincodeRequests(); $approved_pincode_requests->delete($connection, $data); $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 Error"); echo json_encode($failure_json); return; } mysqli_close($connection);
$data = $_REQUEST["json"]; $data = stripslashes($data); $data = json_decode($data, TRUE); $is_approved = $_REQUEST["is_approved"] == 1 ? TRUE : FALSE; $email_id = $data["email_id"]; try { $connection = MysqlUtils::getConnection(); //Get the user's profile $user_profile = UserProfile::getProfile($connection, $email_id); $personal_number = $user_profile["personal_number"]; $data["personal_number"] = $personal_number; //DELETE item from pending_pincode_requests $pending_pincode_requests = new PendingPincodeRequests(); $pending_pincode_requests->delete($connection, $data); //If approved,save it in approved_pincode_requests domain if ($is_approved === TRUE) { $approved_pincode_requests = new ApprovedPincodeRequests(); $approved_pincode_requests->save($connection, $data); } $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 Error"); echo json_encode($failure_json); return; }
use citibytes\CityPincodes; use citibytes\utils\MysqlUtils; use citibytes\PendingPincodeRequests; use citibytes\ApprovedPincodeRequests; 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");