Ejemplo n.º 1
0
 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();
 }