public function upd_resa() { global $wpdb; if (isset($_POST["pl_adulte_upd"]) && isset($_POST["pl_enfant_upd"])) { if (!is_numeric($_POST["post_id_upd"])) { $upd = z; } else { if ($_POST["pl_adulte_upd"] == 0 && $_POST["pl_enfant_upd"] == 0) { $upd = 2; } else { $post_id = $_POST["post_id_upd"]; $current_user = wp_get_current_user(); $id_user = $current_user->ID; $user_rank = $user->roles[0]; $nb_place_dispo = get_post_meta($post_id, '_nb_place', true); $query2 = $wpdb->get_results("SELECT * FROM cjm_reservation WHERE id_evenement = {$post_id} AND id_participant = {$id_user}"); $ancien_nb_place = $query2[0]->nbplace + $query2[0]->nbplace_enf; $prix_total = getPrixTotal($post_id, intval($_POST["pl_adulte_upd"]), intval($_POST["pl_enfant_upd"]), $user_rank); if ($nb_place_dispo + $ancien_nb_place < $_POST["pl_adulte_upd"] + $_POST["pl_enfant_upd"]) { $upd = 3; } else { if (get_post_meta($post_id, '_etat_resa', true) == 'file_attente') { $bool = 1; } else { $bool = 0; } $query = $wpdb->update(cjm_reservation, array('nbplace' => esc_attr($_POST["pl_adulte_upd"]), 'nbplace_enf' => esc_attr($_POST["pl_enfant_upd"]), 'paiement' => 0, 'prix_total' => $prix_total, 'liste_attente' => $bool, 'date_resa' => date("d-m-Y H:i:s")), array('id_participant' => $id_user, 'id_evenement' => $_POST["post_id_upd"])); if ($query == 1) { $nb_place_maj = $nb_place_dispo + $ancien_nb_place - intval(esc_attr($_POST["pl_adulte_upd"])) - intval(esc_attr($_POST["pl_enfant_upd"])); $query = update_post_meta($post_id, '_nb_place', $nb_place_maj); } if ($query == 1) { $isSent = MailSender::send_email_ins_modif($current_user->user_login, true, $post_id); } $upd = 1; } } } echo json_encode($upd); } wp_die(); }