private function post_credit_card() { if ($this->get_request_method() != 'POST') { $this->response($this->get_request_method(), 406); } //Recebe um Json como argumento para o parâmetro 'json'. $json = $this->_request['json']; //Converte o Json em um array, os indices do array são iguais às chaves do Json. Ex.: {"id":1,"outroValor": "string"}. $vector = json_decode($json, TRUE); // variaveis $id = $vector['Id']; $id_user = $vector['IdUser']; $name = $vector['Name']; $number = $vector['Number']; $flag = $vector['Flag']; $month = $vector['MonthValidate']; $year = $vector['YearValidate']; $status = $vector['Status']; if ($status == "True") { $status = 1; } else { $status = 0; } $response = array(); if ($status == 1) { $this->validate_credit_card($number, $response); } if ($id == 0) { $sql_select = select_credit_card_num($id_user, $number); if ($query_select = mysqli_query($this->db, $sql_select)) { if (mysqli_num_rows($query_select) > 0) { $response['Error'] = 'Cartão de crédito já cadastrado!'; $this->response(json_encode($response), 200); } else { // insert $sql = insert_credit_card($id_user, $name, $number, $flag, $month, $year, $status); if ($query = mysqli_query($this->db, $sql)) { // pega o id do insert $response['Id'] = (string) mysqli_insert_id($this->db); $this->response(json_encode($response), 200); } else { $response['Error'] = mysqli_error($this->db); $this->response(json_encode($response), 200); } } } } else { //update $sql = update_credit_card($id, $id_user, $name, $number, $flag, $month, $year, $status); if ($query = mysqli_query($this->db, $sql)) { // retorna o id que ja foi passado $response['Id'] = $id; $this->response(json_encode($response), 200); } else { $response['Error'] = mysqli_error($this->db); $this->response(json_encode($response), 200); } } }
$last_name = COM_applyFilter($_POST['last_name']); $company = COM_applyFilter($_POST['company']); $address_line1 = COM_applyFilter($_POST['address_line1']); $address_line2 = COM_applyFilter($_POST['address_line2']); $city = COM_applyFilter($_POST['city']); $state = COM_applyFilter($_POST['state']); $zip = COM_applyFilter($_POST['zip']); $country = COM_applyFilter($_POST['country']); $card_number = COM_applyFilter($_POST['card_number']); $card_exp_month = COM_applyFilter($_POST['card_exp_month']); $card_exp_year = COM_applyFilter($_POST['card_exp_year']); $card_type = COM_applyFilter($_POST['card_type']); $issue_number = COM_applyFilter($_POST['issue_number']); $start_month = COM_applyFilter($_POST['start_month']); $start_year = COM_applyFilter($_POST['start_year']); $error = update_credit_card($id, $first_name, $middle_name, $last_name, $company, $address_line1, $address_line2, $city, $state, $zip, $country, $card_number, $card_exp_month, $card_exp_year, $card_type, $issue_number, $start_month, $start_year, isset($_POST['default']) ? true : false); } else { if (isset($_POST['add_credit_card'])) { $first_name = COM_applyFilter($_POST['first_name']); $middle_name = COM_applyFilter($_POST['middle_name']); $last_name = COM_applyFilter($_POST['last_name']); $company = COM_applyFilter($_POST['company']); $address_line1 = COM_applyFilter($_POST['address_line1']); $address_line2 = COM_applyFilter($_POST['address_line2']); $city = COM_applyFilter($_POST['city']); $state = COM_applyFilter($_POST['state']); $zip = COM_applyFilter($_POST['zip']); $country = COM_applyFilter($_POST['country']); $card_number = COM_applyFilter($_POST['card_number']); $card_exp_month = COM_applyFilter($_POST['card_exp_month']); $card_exp_year = COM_applyFilter($_POST['card_exp_year']);