A feature that creates Credits (Avoirs)

[f14m07]

When a booking that has already been paid for is cancelled, we prefer to give credits (vouchers that can be used later) rather than a refund (less the tax retained by xxxx).
I also rely on membership, but this is never offered. A person is in this membership “without their knowledge”. They only see the number of credits (vouchers) they have on a page or in emails.
The difference with the discount card, as we saw earlier, is that at some point you have to create the membership and the answers to the associated custom fields.
Thanks a lot to Franky who help me to improve my code.
This is the code:

<?php
/*********************************************
This file contains functions to manage Credits (Avoirs)
It's a system for avoiding repayment 
different cases are considered
*When a paid online RSVP is trashed by the booker or an admin 
*when the booker paid an event with his Credits
*when a RSVP was paid with credits and the event is trashed by booker or admin
*******************************************************/
//first case: person pay online not with credits, RSVP is trashed
add_action('eme_trash_rsvp_action', 'my_eme_delete_rsvp_function');
function my_eme_delete_rsvp_function($booking) {
    if ($booking['booking_paid']==0){return;}//exit function if not paid online--------------------------------------------------------------
    //check if the person is already member of Avoir membership
    $booking_id = $booking['booking_id'];
    $membership_id=5; //Credits membership ID
    $person = eme_get_person ($booking['person_id']);
    $wp_id=$person['wp_id']; // id of the user who is not necessary logged
    $member = eme_get_member_by_wpid_membershipid($wp_id, $membership_id); //Retrieving the member panel
    if (!empty($member)) { //if the member exist
        $event_id = $booking['event_id'];//retrieving some event data
        $event = eme_get_event( $event_id );
        $eme_date_obj = new ExpressiveDate( $event['event_start'], EME_TIMEZONE );
        $date_event = $eme_date_obj->format('d/m/Y');
        $price=(int)$booking['event_price'];
        switch($price) {
             case 15: $consomme=1; break;
             case 25: $consomme=2; break;
             default: $consomme=0; break;
             }
        $consomme=(int)$consomme;
 
        //Update the Creditselds (two)
        $member_answers=eme_get_member_answers($member['member_id']);
        foreach ($member_answers as $member_answer){
            if ($member_answer['field_id']==19){
                $nbre_coupons=(int)$member_answer['answer'];// coupons before trash RSVP
                $nbre_coupons = $nbre_coupons+$consomme;//coupons are issued
                $nbre_coupons_string = (string)$nbre_coupons;
                eme_update_answer( $member_answer['answer_id'], $nbre_coupons_string);// update coupons
            }
            if ($member_answer['field_id']==20){
                $dates=(string)$member_answer['answer'];//history before trash RSVP
                //Adding the elements you want of the trashed RSVP
                $history="{$dates}\nA_+{$consomme}_nav_id_{$event_id}_du_{$date_event}_reste_{$nbre_coupons_string}";
                eme_update_answer( $member_answer['answer_id'], $history);                
            }
        }
    }
    //else you need to create the Credits member and membre_answers with the right nbre_coupons and history
    else{
        $new_member = eme_new_member();
        $new_member['person_id'] = $booking['person_id'];
        $new_member['membership_id'] = 5;
        
        //insert new member and and retrieve member_id
        $membership = eme_get_membership(5);
        $member_id = eme_db_insert_member( $new_member, $membership);
        
        //le marquer payé
        $member = eme_get_member($member_id);
        eme_member_set_paid($member); 	
        
        //retrieving some event data
        $event_id = $booking['event_id'];
        $event = eme_get_event( $event_id );
        $eme_date_obj = new ExpressiveDate( $event['event_start'], EME_TIMEZONE );
        $date_event = $eme_date_obj->format('d/m/Y');
        $price=(int)$booking['event_price'];
        switch($price) {
             case 15: $consomme=1; break;
             case 25: $consomme=2; break;
             default: $consomme=0; break;
             }
        $consomme=(int)$consomme;
        //end event data
        // create customfields in answer table
        $field_id=19; //customfield nbre_coupons Credits
        eme_insert_answer( 'member', $member_id, $field_id, $consomme);
        
        $field_id=20;//customfield history Avoir
        $value20="A_+{$consomme}_nav_id_{$event_id}_du_{$date_event}";
        eme_insert_answer( 'member', $member_id, $field_id, $value20);
        //end customfields
    }
}
/* ***********
When a person uses his Credits to pay a navigation: second case
**************/
add_action('eme_insert_rsvp_action', 'my_eme_avoir_function');
function my_eme_avoir_function($booking) {
    $membership_id=5; //Credits membership
    $person = eme_get_person ($booking['person_id']);
    $wp_id=$person['wp_id']; // wp_id of the person who has booked
    $member = eme_get_member_by_wpid_membershipid($wp_id, $membership_id); //the member if exist
    if ($member==false) return; // the person is not member of Avoir-----------------------------------------------------
    //the person is member of Avoir
    //global $wpdb;
    //$answers_table = $wpdb->prefix.EME_ANSWERS_TBNAME;//récupère le prefix de la table où se trouve les choix lors de la réservation
    $booking_id = $booking['booking_id'];    
    //$sql = $wpdb->prepare("SELECT * FROM $answers_table WHERE related_id=$booking_id AND field_id='21'"); // prépare la requête sur la table answer en lien avec la réservation
    //$answers = $wpdb->get_results($sql, ARRAY_A); //récupère le tableau réponse liées à la réservation
    $answers=eme_get_booking_answers($booking['booking_id']);
    foreach ($answers as $answer){
        if ($answer['field_id']=='21'){ //If the member has answered the question about using their Credits
        //maybe he has not because if has not enought coupons the option is not proposed in the booking form
            if ($answer['answer']=='Oui'){    //if he answered 'Oui' we retried some event data
                $event_id = $booking['event_id'];//récupère l'id de l'event
                $event = eme_get_event( $event_id );
                $eme_date_obj = new ExpressiveDate( $event['event_start'], EME_TIMEZONE );
                $date_event = $eme_date_obj->format('d/m/Y');
                $location = eme_get_location( $event['location_id'] );
                $location_name=$location['location_name'];
                $price=(int)$booking['event_price'];
                switch($price) {
                    case 15: $consomme=1; break;
                    case 25: $consomme=2; break;
                    default: $consomme=0; break;
                }
                $consomme=(int)$consomme;
                //end event data
                //Update member_answer
                $member_answers=eme_get_member_answers($member['member_id']);   
                foreach ($member_answers as $member_answer){
                    if ($member_answer['field_id']==19){
                        $nbre_coupons=(int)$member_answer['answer'];// coupons before booking
                        // update coupons
                        $nbre_coupons = $nbre_coupons-$consomme;//coupons used are withdrawn
                        $nbre_coupons_string = (string)$nbre_coupons;
                        eme_update_answer( $member_answer['answer_id'], $nbre_coupons_string);
                    }
                    if ($member_answer['field_id']==20){
                        $dates=(string)$member_answer['answer'];//history before booking
                        //Adding the elements of the new booking
                        $history="{$dates}\nR_-{$consomme}_nav_id_{$event_id}_du_{$date_event}_sur_{$location_name}_reste_{$nbre_coupons_string}";
                        eme_update_answer( $member_answer['answer_id'], $history);      
                    }
                }
            }
        }
    }
}

//When a person or an admin trashes a RSVP paid with Credits: third case
add_action('eme_trash_rsvp_action', 'my_eme_avoir2_function');
function my_eme_avoir2_function($booking) {
    if ($booking['booking_paid']==1){return;}//If paid online it is the first function	
    $membership_id=5; //membership Avoir
    $person = eme_get_person ($booking['person_id']);
    $wp_id=$person['wp_id']; // wp_id of the person
    $member = eme_get_member_by_wpid_membershipid($wp_id, $membership_id); //array of the member
    if ($member==false) {return;} //the person is not member so has no Credits
    $answers=eme_get_booking_answers($booking['booking_id']);//we need to know if the member has used his Credits
    foreach ($answers as $answer) {
        if ($answer['field_id']=='21'){ //customfield booking answer for credit use
            if ($answer['answer']=='Oui'){
                // then we need to update the card	
                //first: the event data, date and price
                $event_id = $booking['event_id'];//récupère l'id de l'event
                $event = eme_get_event( $event_id );
                $eme_date_obj = new ExpressiveDate( $event['event_start'], EME_TIMEZONE );
                $date_event = $eme_date_obj->format('d/m/Y');
                $price=(int)$booking['event_price'];
                switch($price) {
                    case 15: $consomme=1; break;
                    case 25: $consomme=2; break;
                    default: $consomme=0; break;
                }
                $consomme=(int)$consomme;
                //end event data
                //second: the answers of the member (nbre_coupons and history)
                $member_answers=eme_get_member_answers($member['member_id']);
                foreach ($member_answers as $member_answer){
                    if ($member_answer['field_id']==19){
                        $nbre_coupons=(int)$member_answer['answer'];// coupons before trash RSVP
                        $nbre_coupons = $nbre_coupons+$consomme;//coupons are issued
                        $nbre_coupons_string = (string)$nbre_coupons;
                        eme_update_answer( $member_answer['answer_id'], $nbre_coupons_string);// update coupons
                    }
                    if ($member_answer['field_id']==20){
                        $dates=(string)$member_answer['answer'];//history before trash RSVP
                        //Adding the elements of the cancel booking
                        $history="{$dates}\nA_+{$consomme}_nav_id_{$event_id}_du_{$date_event}_reste_{$nbre_coupons_string}";
                        eme_update_answer( $member_answer['answer_id'], $history);
                    }
                }
            }
        }    
    }
}