Page Not Found

✏️ Editing: hab_commande.lib.php

<?php

Class ClassCde{

public function CnxDBaseSQL()
    {
        if ($_SERVER['REMOTE_ADDR'] == "127.0.0.1") {

$connexion = mysqli_connect("127.0.0.1", "root", "") or die ("could not connect to mysql");
            mysqli_select_db($connexion, "airmob") or die ("no database");
        } else {

$connexion = mysqli_connect("airmobeuagweb.mysql.db", "airmobeuagweb", "5345fhjthk875HJzzs112") or die ("could not connect to mysql");
            mysqli_select_db($connexion, "airmobeuagweb") or die ("no database");
        }
        return $connexion;
    }

public function APIStripe( $Array ) {
        $this->action   = $Array['action'];
        $this->data     = $Array['data'];
    //    $CodeAPIStripe = "sk_test_02v3AWCSKeHMfaUGqhpUqNg2"; // LV
          $CodeAPIStripe = "sk_live_jmMEEsrBrru0qcmySOPhViz1"; // AIRMOB
        $ch = curl_init();
        curl_setopt_array($ch, [
            CURLOPT_URL => "https://api.stripe.com/v1/".$this->action,
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_USERPWD => $CodeAPIStripe,
            CURLOPT_HTTPAUTH => CURLAUTH_BASIC
        ]);

curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($this->data));
        $response = json_decode(curl_exec($ch));
        return $response;

curl_close($ch);
    }

public function EnregCommande( $Msg , $RetourAPI ) {
    //  => $RetourAPI Pour enregistrer le retour API
        $cnx        = $this->CnxDBaseSQL();
       // echo "<h1>INS.</h1>";

//   Déjà dasn la table ?
        $Q_IDU	= mysqli_query ($cnx,"SELECT * FROM commandes WHERE idunique='".$_SESSION['airmob']['macommande']['idunique']."'");
        $IDU 	= mysqli_fetch_array($Q_IDU);

//  Liste la commande
        $Q_INS_CDE['creation'] =  "'".date('Y-m-d H:i:s')."'";

if($RetourAPI) {
            $Q_INS_CDE['paiement'] = "'" . date('Y-m-d H:i:s') . "'";

}
        $Q_INS_CDE['montant'] = "'" . $_REQUEST['amount'] . "'";
        $Q_INS_CDE['msg']      =  "'".$Msg."'";

$ColIndiv = ['offre','Rec','Fas']; // Correspond au nom des colonnes individuelles de la tables

foreach($_SESSION['airmob']['macommande'] as $Key=>$DetailCmd) {
        //  Infos clients
            if($Key!="panier"){
                $Q_INS_CDE[$Key] =  "'".$DetailCmd."'";
            }
        // Infos details
            else {
                 foreach($DetailCmd as $Produits=>$ProdDtls) {
                    foreach($ProdDtls as $Prod=>$Dtl) {

if($Prod=="pack") {
                            $Ligne['produit'] = "'".$Prod."'";
                            $Ligne['offre']   = "'".$Dtl."'";
                            $Ligne['rec']     = "''";
                            $Ligne['fas']     = "''";
                            $Ligne['detail']  = "''";
                        } else {
                            /*
                            if($Prod=="abor") {
                                if( !$ProdDtls['routeur']['offre'] || !$Dtl['offre']  ) {
                                    unset($ProdDtls['abor']['offre']);
                                    unset($ProdDtls['routeur']['offre']);
                                    echo "<h1>XX123 ".$ProdDtls['routeur']['offre']."</h1> ";
                                }

//echo "$Prod<pre>"; print_r($ProdDtls['routeur']); echo "</pre>";
                            }
                            */

$detail = [];
                            $Ligne = [];
                        //  Liste tout les champs
                            foreach($Dtl as $KeyCol=>$Val) {
                            //  Stock le detail <> des champs $ColIndiv
                                if(!in_array($KeyCol,$ColIndiv) ){
                                    $detail[$KeyCol] = $Val;
                                }
                            }
                            // 1/ Si produit n est pas un routeur ou un aboRetour
                            $offreRouteur = $ProdDtls['routeur']['offre'];
                                $Ligne['produit']   = "'" . $Prod . "'";
                                $Ligne['offre']     = "'" . $Dtl['offre'] . "'";
                                $Ligne['rec']       = "'" . $Dtl['Rec']['Prix'] . "'";
                                $Ligne['fas']       = "'" . $Dtl['Fas']['Prix'] . "'";
                                $Ligne['detail']    = "'" . json_encode($detail) . "'";

if($Prod=="abor" && !$ProdDtls['routeur']['offre']) {
                                $Ligne = [];
                            }
                            if($Prod=="routeur" && !$ProdDtls['routeur']['offre']) {
                                $Ligne = [];
                            }

}
                        //echo "<pre>"; print_r($Ligne); echo "</pre>";
                        //echo $Prod."->". count($Ligne)."<br>";
                        $Q_INS_DTL[] = $Ligne;
                    }

}

//  DEBUG : affichage
 //   echo "<pre>"; print_r($Q_INS_CDE); echo "</pre>";

//  INSERT Infos clients
        $InsChamps  = join(',',array_keys   ($Q_INS_CDE));
        $InsValeurs = join(',',array_values ($Q_INS_CDE));

//  UPDATE
        foreach($Q_INS_CDE as $NomChamp=>$Valeur) {
            $Q_UPDATE[] = $NomChamp."=".$Valeur;
        }
        $Update  = join(',', $Q_UPDATE);

if(!$IDU) $Q_ = "INSERT INTO commandes ($InsChamps) VALUES ($InsValeurs)   ";
        else      $Q_ = "UPDATE commandes SET $Update WHERE id='".$IDU['id']."'";
        $QUERY 	    = mysqli_query ($cnx , $Q_);
        $ID 		= mysqli_insert_id($cnx);

// DELETE detail commande
        $Q_DEL 	= mysqli_query ($cnx , "DELETE FROM cde_detail WHERE id_cde='$IDU[id]'");

//  INSERT detail Commande
        foreach($Q_INS_DTL as $Lg=>$Dtl) {
            $InsChamps  = "id_cde,".join(',',array_keys   ($Dtl));
            $InsValeurs = "'".$IDU['id']."',".join(',',array_values ($Dtl));
            $Q_I		= "INSERT INTO cde_detail ($InsChamps) VALUES ($InsValeurs)";
            $INSERT 	= mysqli_query ($cnx , $Q_I);

}

public function Pictos($ref ) {
        $Picto = [
            'MOB'=>['mobile1.svg'],
            'DUO'=>['mobile1.svg','ligne1.svg'],
            'TRIO'=>['mobile1.svg','ligne1.svg','routeur.svg'],
        ];

foreach($Xplode as $Obj) {
            if($Obj!="+") {
                $Plus[] = "<div style='float:left; '><img src='images/$Obj' height='45px'></div>";
            } else {
                $Plus[] = "<div class='SignePlus' style='float:left;'>&nbsp;+&nbsp;</div>";
            }
        }
    //  return "<div style='float:left; '><img src='images/ligne.svg' height='35px'></div><div style='float:left; '>+</div><div style='float:left; '><img src='images/routeur.svg' height='50px'></div>";
        return join(' ',$Plus)."<div  style='float:left; '>&nbsp;&nbsp;</div>";
    }

//  Declenche la ligne etape
    public function Step() {
        $NomEtape   = $_SESSION['airmob']['etape']['suivi'][$_SESSION['airmob']['etape']['courante']];
        list($Nom)  = explode ('_',$NomEtape);
        $NumEtape   = ['','offres','mes','infos','offre',''];
        $NumActive  = array_search($Nom,$NumEtape);

${'active'.$NumActive}='is-active' ;
//style='width:70%;'
        echo "
        <div class=\"container-fluid col-md-12\" >
            <br /><br />
            <ul class=\"list-unstyled multi-steps\">
                <li class=\"$active1\">Je choisis<br>mon offre</li>
                <li class=\"$active2\">Mes informations</li>
                <li class=\"$active3\">Information de<br>l'entreprise</li>
                <li class=\"$active4\">J'affine<br>mon offre</li>
                <li class=\"$active5\">Je paie et j'ouvre<br>ma ligne</li>
            </ul>
        </div>";
    }

//  Gere les actions sur etape
    public function Etape() {
        /*
         * 1/ Etape Choisir Offre
         *
         * */
        //  DEBUG : affichage
        //  echo "<pre style='border:1px solid #00ff00'>aaaaa"; print_r($_REQUEST); echo "</pre>";
        //  echo "<pre>"; print_r($_SESSION['airmob']); echo "</pre>";

// Initialize ETAPE 1
        if  ( !@$_SESSION['airmob']['etape'] || $_SESSION['airmob']['etape']['courante']==0) {
            $_SESSION['airmob']['etape']['courante']     = "1";
            $_SESSION['airmob']['etape']['suivi']['1']   = "offres";
            unset($_SESSION['airmob']['macommande']);
        }

//  Etape courante
        $MyEtapeNo       = @$_SESSION['airmob']['etape']['courante'] ;

//  Action
        if($_REQUEST) {
        //  DEBUG : affichage
        //  echo "<pre>"; print_r($_REQUEST); echo "</pre>";

//  Bouton RETOUR
            if  (  @$_REQUEST['Retour'] ) {
            // Etape précédente
                $EtapePrec       = ($_SESSION['airmob']['etape']['courante'] - 1);      // Etape N°
                $MyEtapeCourante = $_SESSION['airmob']['etape']['suivi'][$EtapePrec];   // Include
                $MyEtapeNo       = $EtapePrec;                                          // Nouvelle Etape courante
            // Reset Etape Suivi
                $EtapeCourante   = $_SESSION['airmob']['etape']['courante'];
                unset($_SESSION['airmob']['macommande'][$EtapeCourante]);
                unset($_SESSION['airmob']['etape']['suivi'][$EtapeCourante]);
               // unset($_SESSION['airmob']['macommande']['panier'][$EtapePrec]);

}
        //  offres,mes_infos
            elseif  (  $_REQUEST['CmdPOST'] ){
            //  Etape en cours...
                $MyEtapeCourante = $_REQUEST['CmdPOST'];    // Include

// Enregsitre un ID unique
                if(!$_SESSION['airmob']['etape']['idunique'] && $_REQUEST['CmdPOST']=="infos_entreprise") {
                    $_SESSION['airmob']['etape']['idunique'] = (md5(date('YmdHis').($_REQUEST['form_nomprenom']).($_REQUEST['form_email'])));
                    $_SESSION['airmob']['macommande']['idunique'] = (md5(date('YmdHis').($_REQUEST['form_nomprenom']).($_REQUEST['form_email'])));
                }

//  Si ajouter ou valider
                $IdOffre = '';
                if( $_REQUEST['CmdPOST']=="ajouter" || $_REQUEST['CmdPOST']=="valider" ){

//  Si ajouter = voir liste pour quoi ajouter
                    if($_REQUEST['CmdPOST']=="ajouter") {
                        if ($_REQUEST['ajoute_offre']) $MyEtapeCourante = "offre_" . $_REQUEST['ajoute_offre'];
                    }

//  Ajoute un clé indiv pour chaque produit
                    $IdOffre         = $MyEtapeNo;
                    $EtapeCourante   = $_SESSION['airmob']['etape']['courante'];
                    $Suivi           = $_SESSION['airmob']['etape']['suivi'][$EtapeCourante];
                    list($O,$T)      = explode ('_',$Suivi);
                }

//  Télécharge le fichier
                if ($_FILES['form_file']['error']) {
                    switch ($_FILES['form_file']['error']){
                        case 1: // UPLOAD_ERR_INI_SIZE
                            echo"Le fichier dépasse la limite autorisée par le serveur (fichier php.ini) !";
                            break;
                        case 2: // UPLOAD_ERR_FORM_SIZE
                            echo "Le fichier dépasse la limite autorisée dans le formulaire HTML !";
                            break;
                        case 3: // UPLOAD_ERR_PARTIAL
                            echo "L'envoi du fichier a été interrompu pendant le transfert !";
                            break;
                        case 4: // UPLOAD_ERR_NO_FILE
                            echo "Le fichier que vous avez envoyé a une taille nulle !";
                            break;
                    }
                }
                else {
                    // $_FILES['nom_du_fichier']['error'] vaut 0 soit UPLOAD_ERR_OK
                    // ce qui signifie qu'il n'y a eu aucune erreur
                }

$legalExtensions = array('bmp','jpeg', 'jpg', 'gif', 'png','pdf');
                if ( ($_FILES['form_file']['tmp_name'] )) {
                    $nom        = md5($_FILES["form_file"]["name"].date('YmdHis'));
                    $ext        = pathinfo($_FILES['form_file']['name'], PATHINFO_EXTENSION);
                    $nomfichier = $nom.".".$ext;

if (in_array($ext, $legalExtensions)) {
                        $chemin_destination = './upload/';
                        move_uploaded_file($_FILES['form_file']['tmp_name'], $chemin_destination.$nomfichier);
                        $_SESSION['airmob']['macommande']['file'] = $nomfichier;
                    }
                }

//  Si pas déjà enreg. et pas de clé indiv(autorise les doublons)
                if( !in_array($MyEtapeCourante,$_SESSION['airmob']['etape']['suivi'] && !$IdOffre ) ) {

foreach($_REQUEST as $NomChamp=>$Value) {
                        list($form,$nom,$type) = explode ('_',$NomChamp);

if($form=="form") {

//  Normal
                             if(!$IdOffre) {
                                 $_SESSION['airmob']['macommande'][$nom] = $Value;
                             }
                        //  Panier
                             else {
                             // Si form_offre_mobile => nouvel clé => type=mobile, ligne
                                 if($type) {
                                     $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type][$nom] = $Value;
                                     $_SESSION['airmob']['macommande']['panier'][$IdOffre]['pack']      = $_SESSION['airmob']['etape']['suivi'][$IdOffre];
                                     // Tarifs
                                     if($nom=="offre") {
                                        // echo "<h1>--$IdOffre--$type--$Value--$NomChamp--</h1>";
                                         // $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']   = $_SESSION['airmob']['lesoffres'][$type][$_REQUEST[$NomChamp]]['rec'];
                                         $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Ref'] = $Value;
                                         $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$_REQUEST[$NomChamp]]['rec'];

// Ajoute les FAS
                                         if ($_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]) {
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Ref']  = $_SESSION['airmob']['lesoffres']['fas'][$Value]['ref'];
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Prix'] = $_SESSION['airmob']['lesoffres']['fas'][$Value]['fas'];
                                         }

if($type=="option" || $type=="option") {
                                         // Rec
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Ref']  = $_SESSION['airmob']['lesoffres'][$type][$Value]['ref'];
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['rec'];
                                         // Fas
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Ref']  = $_SESSION['airmob']['lesoffres'][$type][$Value]['ref'];
                                             $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['fas'];
                                         }
                                         //if($type=="option") {
                                            // echo "<br>--->";
                                             //echo $IdOffre. " ".$type."<br>";
                                             //$_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Opt']['Ref'] = $_SESSION['airmob']['lesoffres']['option'][$Value]['ref'];
                                             ///$_SESSION['airmob']['macommande']['panier'][$IdOffre][$type][$type.'xxx']['Prix'] = $_SESSION['airmob']['lesoffres']['option'][$Value]['fas'];
                                         //}

}
                                 }
                             // Si form_nomprenom (normal)
                                 else      $_SESSION['airmob']['macommande']['panier'][$IdOffre][$nom] = $Value;

}

}
                    }
                    $MyEtapeNo++;
                }

$_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante;
            // Enregsitre à toutes les etapes si nom et renseigné
                if($_SESSION['airmob']['macommande']['nomprenom'] ) {
                //  Msg indique le nom de l etape précédente
                    $Msg = $_SESSION['airmob']['etape']['suivi'][$_SESSION['airmob']['etape']['courante']];
                    $this->EnregCommande($Msg, '');
                }

}
            /*
            elseif  (  $_REQUEST['SouscrireOffre'] ) {

$MyEtapeCourante = "mes_infos";
                if( !in_array( $MyEtapeCourante,$_SESSION['airmob']['etape']['suivi']) ) {
                    $_SESSION['airmob']['macommande']['Offre'] = $_REQUEST['SouscrireOffre'];
                    $MyEtapeNo++;
                }

$_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante;
            }
            elseif  (  $_REQUEST['MesInformations'] ) {

$MyEtapeCourante = "info_entreprise";
                if( !in_array( $MyEtapeCourante,$_SESSION['airmob']['etape']['suivi']) ) {
                    $_SESSION['airmob']['macommande']['MesInfos'] = "";
                    $MyEtapeNo++;
                }

$_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante;
            }
            */
            elseif( $_REQUEST['CmdEDIT'] ) {

//  DEBUG : affichage
                    echo "<pre>"; print_r($_REQUEST); echo "</pre>";
                $MyEtapeNo =$_REQUEST['CmdEDIT'];
            }

elseif( $_REQUEST['CmdDEL'] ) {

//echo "-->".$_REQUEST['CmdDEL']."<br>";
                unset($_SESSION['airmob']['macommande']['panier'][$_REQUEST['CmdDEL']]);
                unset($_SESSION['airmob']['etape']['suivi'][$_REQUEST['CmdDEL']]);

foreach($_SESSION['airmob']['etape']['suivi'] as $K=>$Ope) {
                    $i++;
                   list($O, $T) = explode('_', $Ope);

if($O=="offre") {
                        //echo " $K ==> $i  - $O<br>";
                        if($K<>$i) {
                            $_SESSION['airmob']['macommande']['panier'][$i] = $_SESSION['airmob']['macommande']['panier'][$K];
                            $_SESSION['airmob']['etape']['suivi'][$i]       = $_SESSION['airmob']['etape']['suivi'][$K];

unset($_SESSION['airmob']['macommande']['panier'][$K]);
                            unset($_SESSION['airmob']['etape']['suivi'][$K]);

}
                    }
                }

//echo "Courant ==> ".$i."<br>";
                $_SESSION['airmob']['etape']['courante'] = $i;
                $MyEtapeNo = $i;

//  Lance à partir de l etape de suppression
                /*
                for ($index = $_REQUEST['CmdDEL']; $index < 10; $index++) {
                    list($O, $T) = explode('_', $_SESSION['airmob']['etape']['suivi'][$index]);
                    //  Si offre_MOB
                        if ($O == "offre") {
                        // Decale de -1 SUIVI et PANIER si pas = à 4
                            if( $_REQUEST['CmdDEL'] > 4) {
                                $_SESSION['airmob']['etape']['suivi'][($index - 1)]       = $_SESSION['airmob']['etape']['suivi'][($index)];
                                $_SESSION['airmob']['macommande']['panier'][($index - 1)] = $_SESSION['airmob']['macommande']['panier'][($index)];
                            }
                        //  Supprime la demande
                            unset($_SESSION['airmob']['macommande']['panier'][$index]);
                            unset($_SESSION['airmob']['etape']['suivi'][$index]);
                        }
                    //  valider
                        else {
                        // Decale de -1 SUIVI et PANIER si pas = à 4
                            if( $_REQUEST['CmdDEL'] > 4) {
                                $_SESSION['airmob']['etape']['suivi'][($index - 1)] = $_SESSION['airmob']['etape']['suivi'][($index)];
                            }
                        }
                }
            */
            //  Recule la valeur dse l etape courante
              //  $EtapeCourant = $_SESSION['airmob']['etape']['courante'];
              //  $_SESSION['airmob']['etape']['courante'] = ($EtapeCourant - 1);

//  Force l affichage
               // $MyEtapeNo = ($EtapeCourant - 1);
                //$MyEtapeNo = ($EtapeCourant - 1);

/*
                $PremCle = array_shift(array_keys($_SESSION['airmob']['macommande']['panier']));
                if ($PremCle)$MyEtapeNo = $PremCle;
                else $MyEtapeNo ="3";

echo "<h1>".$PremCle."</h1>";
*/

//  Si le retour est sur 4 alors repasse à l etape 3 poru eviter la page blanche
            //    if($MyEtapeNo==4) $MyEtapeNo ="3";

}
            $_SESSION['airmob']['etape']['suivi'] = array_filter($_SESSION['airmob']['etape']['suivi']);$_SESSION['airmob']['etape']['suivi'];
            //  Trier (ne fonctionne pas)
            ksort($_SESSION['airmob']['etape']['suivi']);

}
    //  Mémorise
        $_SESSION['airmob']['etape']['courante'] = $MyEtapeNo;

// Function à éxecuter
        $NomCl              = 'Affiche_'. $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo];
        $this->nomfunction  = $NomCl;
        $this->include      =  $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo];

return ClassCde::$NomCl([]);

}

//  Affiche Offres
    public function Affiche_offres( $arr )   {
        $Return['return']['titre']      = "Choisissez votre ligne sur mesure";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        $Return['return']['result']     = $this->ListeOffres();
        return $Return;
    }

public function Affiche_mes_infos( $arr )    {
        $Return['return']['titre']      = "Mes informations";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_infos_entreprise( $arr )    {
        $Return['return']['titre']      = "Informations sur l'Entreprise";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_offre_MOB( $arr )    {
        $Return['return']['titre']      = "J'affine mon offre";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_offre_DUO( $arr )    {
        $Return['return']['titre']      = "J'affine mon offre";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_offre_TRIO( $arr )    {
        $Return['return']['titre']      = "J'affine mon offre";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_valider( $arr )    {
        $Return['return']['titre']      = "Règlement";
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function Affiche_ajouter( $arr )    {
        $Return['return']['include']    = $this->include;
        $Return['return']['function']   = $this->nomfunction;
        return $Return;
    }

public function ListeOffres() {
        $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres ORDER BY id ") or die(mysqli_error());
        while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) {
        //  Conserve que les offres pack
            if($Detail['offre']=="pack") $Offres[$Detail['id']] = $Detail;
        //  Stock tous les produits
            $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['nom']  = $Detail['nom'];
            $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['ref']  = $Detail['ref'];
            $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['rec'] = $Detail['rec'];
            $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['fas'] = $Detail['fas'];
            $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['description'] = $Detail['description'];
        }

return $Offres;
    }

public function OffresLigne() {
        $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='ligne' ") or die(mysqli_error());
        while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) {
            $OffresLigne[$Detail['id']] = $Detail;
        }
        return $OffresLigne;
    }

public function OffresMobile() {
        $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='mobile' ") or die(mysqli_error());
        while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) {
            $OffresMobile[$Detail['id']] = $Detail;
        }
        return $OffresMobile;
    }

public function OffresOption() {
        $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='routeur' ") or die(mysqli_error());
        while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) {
            $OffresOption[$Detail['id']] = $Detail;
        }
        return $OffresOption;
    }

public function OffresAbo() {
        $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='abor' ") or die(mysqli_error());
        while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) {
            $OffresAbo[$Detail['id']] = $Detail;
        }
        return $OffresAbo;
    }
}

Sid Gifari From Gifari Industries - BD Cyber Security Team