Ubuntu

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ end (array_keys($kk))) { if ($_SESSION['LPF']['Commande']['mnu_etape'] == $_SESSION['LPF']['Commande']['qte'] && $_SESSION['LPF']['Commande']['qte']>1) { $_SESSION['LPF']['Commande']['mnu_etape'] = $_SESSION['LPF']['Commande']['mnu_etape'] - 1; } } } } $NoMnu = $_SESSION['LPF']['Commande']['mnu_etape'] ; // 1 ETAPE - ENTREE if($_REQUEST['entree']) { $_SESSION['LPF']['Commande']['mnu'][$NoMnu]['E'] = addslashes($_REQUEST['entree']); // Enreg entree $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] = "plat"; // Etape suivante } // 2 ETAPE - PLAT if($_REQUEST['plat']) { $_SESSION['LPF']['Commande']['mnu'][$NoMnu]['P'] = addslashes($_REQUEST['plat']); // Enreg plat $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] = "dessert"; // Etape suivante } // 3 ETAPE - DESSERT if($_REQUEST['dessert']) { $_SESSION['LPF']['Commande']['mnu'][$NoMnu]['D'] = addslashes($_REQUEST['dessert']); // Enreg dessert // Si plusieurs menus recommence la selection à entree if( $_SESSION['LPF']['Commande']['mnu_etape'] < $_SESSION['LPF']['Commande']['qte'] ) { $_SESSION['LPF']['Commande']['mnu_etape'] = $_SESSION['LPF']['Commande']['mnu_etape']+1; $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] = "entree"; } // Fin de 1 ou plusieurs menus Si fin mnu_etape = qte à l etape dessert envoi sur les vins if($NoMnu == $_SESSION['LPF']['Commande']['qte']){ $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] ="vin"; } } // 4 ETAPE - VIN if($_REQUEST['vin']) { $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1]="vin"; ; //$_SESSION['LPF']['Commande']['mnu'][0]['V'] = $_REQUEST['vin']; list($type,$nom,$prix) = explode ('|',$_REQUEST['vin']); // Enreg vin $_SESSION['LPF']['Commande']['mnu']['V']['TYPE'] = $type; $_SESSION['LPF']['Commande']['mnu']['V']['NOM'] = $nom; $_SESSION['LPF']['Commande']['mnu']['V']['PRIX'] = $prix; $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] = "recap"; // Etape suivante } // Allergies if($_REQUEST['allergies']) { $_SESSION['LPF']['Commande']['allergies']['reponse'] = $_REQUEST['allergies']; $_SESSION['LPF']['Commande']['allergies'] ['detail'] = $_REQUEST['allergie_comm']; $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] ="vin"; } } // Charge le form de selection public function ChargeSelection() { include "rubriques/selection.php"; } // NOTE : Affiche le titre pour la SELECTION / Entree Plat Dessert Vin public function SelectionTitre() { $Etape = $_SESSION['LPF']['Etape']; if( $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1]<>'vin' ) { echo "

Menu " . $_SESSION['LPF']['Commande']['mnu_etape'] . " (" . Type[$_SESSION['LPF']['Commande']['mnu_suite'][$Etape + 1]] . ")

"; if ($_SESSION['LPF']['Commande']['TYPE']=="choix" && $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1]=="plat") echo "Servis avec des légumes printaniers"; } else { echo "

Notre sélection de vin pour votre menu ?

L’ensemble de notre cave est disponible à tarifs réduit pour les ventes à emporter.
N’hésitez pas à demander la carte complète ainsi que des conseils.
Ci-dessousquelques exemples...

"; } echo "

"; } // NOTE :Affiche les choix disponible lors de la SELECTION / Entree Plat Dessert Vin public function SelectionMenu() { $Etape = $_SESSION['LPF']['Etape']; // entree, plat, dessert (vide = passe au vin) if( $_SESSION['LPF']['Commande']['mnu_suite'][$Etape+1] ) { $q = $_SESSION['LPF']['Commande']['mnu_suite'][$Etape + 1]; $this->AfficheChoix($q); } // vin else { $this->AfficheChoix("vin"); } } // NOTE :Créé les bouton pour les choix disponible lors de la SELECTION / Entree Plat Dessert Vin public function AfficheChoix( $quoi ) { $cnx = $this->CnxMYSQL(); $i = 0; if($quoi=="menus") { // Si menu de fete à la date selectionnée $QFete = mysqli_query($cnx, "SELECT * FROM menus WHERE type_menu='fete' && active='1' && date='".$_SESSION['LPF']['Commande']['Retrait_date']."'"); $ColFete = mysqli_fetch_array($QFete, MYSQLI_ASSOC); if($ColFete['id']) $WHERE = "id='".$ColFete['id']."'"; else $WHERE = "active='1'"; $QW = mysqli_query($cnx, "SELECT * FROM menus WHERE $WHERE "); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $i++; $x= "0.".($i)."s"; $Val = $Col['type_menu']."|".$Col['nom']."|".$Col['prix']; $Nom = $Col['nom']." - ".$Col['prix']." €"; echo ''; } } elseif($quoi=="entree" || $quoi=="plat" || $quoi=="dessert" || $quoi=="vin") { if($quoi=="vin") $ORDER = "ORDER BY prix desc"; else $ORDER =""; $QW = mysqli_query($cnx, "SELECT * FROM choix WHERE type='$quoi' $ORDER "); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $i++; $x= "0.".($i)."s"; $Val = $quoi."|".$Col['nom']."|".$Col['prix']; if($quoi=="vin" && $Col['prix']>0) $Nom = $Col['nom']." - ".$Col['prix']." €"; else $Nom = $Col['nom']; echo ''; } } else { } //return $Choix; } // NOTE : Recapitualitf des menus fin de selection public function Recapitulatif() { $QTE = $_SESSION['LPF']['Commande']['qte']; $TYPE = $_SESSION['LPF']['Commande']['TYPE']; $NOM = $_SESSION['LPF']['Commande']['NOM']; $DATE = $_SESSION['LPF']['Commande']['Retrait_date']; $HEURE = $_SESSION['LPF']['Commande']['Retrait_heure']; //echo uniqid();; ($QTE >1) ? $ajout_s = "s" : $ajout_s = "" ; echo "
Vous avez sélectionnez :
".$QTE." menu".$ajout_s." ".$NOM."
"; echo "A retirer sur place le :
".date("d/m/Y", strtotime($DATE))." à ".$HEURE; //foreach(Type as $Type=>$b) { // $Type = substr(strtoupper($Type),0,1); // echo "-".$Type."-
"; foreach($_SESSION['LPF']['Commande']['mnu'] as $No_Menu=>$Dtl) { if($Dtl['E']) { list($te,$ne,$pe)=explode ('|',$Dtl['E']); $RecapCmd['E'][] = $ne;} if($Dtl['P']) { list($tp,$np,$pp)=explode ('|',$Dtl['P']); $RecapCmd['P'][] = $np;} if($Dtl['D']) { list($td,$nd,$pd)=explode ('|',$Dtl['D']); $RecapCmd['D'][] = $nd;} } // } // Array echo "
"; if($TYPE=="choix") { echo "

Entrée(s)

"; echo "
  • " . join('
  • ', $RecapCmd['E']) . '
    • '; echo "
    "; echo "

    Plat(s)

    "; echo "
  • " . join('
  • ', $RecapCmd['P']) . '
    • '; echo "
    "; echo "

    Dessert(s)

    "; echo "
  • " . join('
  • ', $RecapCmd['D']) . '
    • '; } else { echo "
    "; echo "
    Vous nous avez indiqué "; echo " "; if($_SESSION['LPF']['Commande']['allergies']['reponse']=="non") echo "ne pas être allérgique."; elseif($_SESSION['LPF']['Commande']['allergies']['reponse']=="oui") echo "être allérgique. en précisant :
    " .$_SESSION['LPF']['Commande']['allergies']['detail'].""; echo "
    "; } echo "
    "; if($_SESSION['LPF']['Commande']['mnu']['V']) { echo "
    Pour accompagner votre repas vous avez choisi le vin :
    "; echo "
  • ".$_SESSION['LPF']['Commande']['mnu']['V']['NOM']."
    • "; } $_SESSION['LPF']['Commande']['Stripe'] = ($this->Calcul()*100); echo "
    "; echo "

    Le total de votre commande
    est de ".$this->Calcul()." €

    "; echo "
    "; echo "
    "; } // NOTE: Recapitulatif Commandes public function Recapitulatif_Cmd( $LstCmd ){ $TD =""; foreach($LstCmd['1'] as $Date=>$Dtl1) { $Date = substr($Date,8,2)."/" .substr($Date,5,2)."/" .substr($Date,0,4); $TD .=""; foreach($Dtl1 as $Heure=>$Dtl1a) { foreach($Dtl1a as $no=>$Dtl2) { ($Dtl2['pu_vin']>0) ? $Vin=" + VIN" : $Vin=""; if( $Dtl2['paiement'] ) { ($Dtl2['paiement'] == "paiement_ok") ? $Paye = "Paiement accepté" : $Paye = "Paiement refusé"; } else { $Paye =""; } $Demande = substr($Dtl2['demande'],8,2)."/" .substr($Dtl2['demande'],5,2)."/" .substr($Dtl2['demande'],0,4); $CalcM = $Dtl2['qte']*$Dtl2['pu_mnu']+$Dtl2['pu_vin']; $TD .= ""; $TD .= ""; $TD .= ""; $TD .= ""; $TD .= ""; if( $Dtl2['allergie']!='""' && $Dtl2['allergie']<>'null') { $TD .= ""; } else { $TD .= ""; } $TD .= ""; } } $TD .="
    Commande à retirer le ".$Date." ".substr($Heure,0,5)."
    Cmd enregistrée le $Demande    		".$Dtl2['idu']."
    Client : ".$Dtl2['nom']."
    Email : ".$Dtl2['mobile']." / Tél. ".$Dtl2['email']."    		$Paye
  • ".$Dtl2['qte']." x Menu. ".$Dtl2['menu']."$Vin
    		• $CalcM Euros
    "; $Menu = json_decode($Dtl2['detail'],TRUE); $TD .= "
      "; if ($Menu[1]['E'] ) { $TD .= "Entrée(s)"; foreach ($Menu as $MnuNo => $DMnu) { list($a, $b, $c) = explode('|', $DMnu['E']); if ($b) $TD .= "
    • " . $b . "
      • "; } $TD .= "Plats(s)"; foreach ($Menu as $MnuNo => $DMnu) { list($a, $b, $c) = explode('|', $DMnu['P']); if ($b) $TD .= "
    • " . $b . "
      • "; } $TD .= "Dessert(s)"; foreach ($Menu as $MnuNo => $DMnu) { list($a, $b, $c) = explode('|', $DMnu['D']); if ($b) $TD .= "
    • " . $b . "
      • "; } $TD .= "
      "; } $TD .= "Vin"; $TD .= "
    • " . $Menu['V']['NOM'] . "
      • "; $TD .= "
    "; $TD .= "
    ALLERGIE (Avertissement Client) : ".$Dtl2['allergie']."Aucune allergie mentionnée
    "; } return $TD; } // NOTE : Enregistre la commande public function EnregCmd( $REQ ) { $cnx = $this->CnxMYSQL(); if( !$REQ ) { $demande = date('Y-m-d H:i:s'); $nom = $REQ['nomprenom']; $tel = $REQ['telephone']; $mel = $REQ['email']; $qte = $_SESSION['LPF']['Commande']['qte']; $mnu = $_SESSION['LPF']['Commande']['NOM']; $pum = $_SESSION['LPF']['Commande']['PRIX']; $puv = $_SESSION['LPF']['Commande']['mnu']['V']['PRIX']; $dtl = json_encode($_SESSION['LPF']['Commande']['mnu']); $allergie = json_encode($_SESSION['LPF']['Commande']['allergies']['detail']); $retrait = $_SESSION['LPF']['Commande']['Retrait_date'] . " " . str_replace('h', ':', $_SESSION['LPF']['Commande']['Retrait_heure']); $total = $_SESSION['LPF']['Commande']['Stripe']; $QF = mysqli_query($cnx, "SELECT id FROM lpf_cmd WHERE 1 ORDER BY id desc LIMIT 1"); $Col = mysqli_fetch_array($QF, MYSQLI_ASSOC); $c = ($Col['id'] + 1); $idc = "BC".date('ymdhi') . $this->MyMefNum000(['num' => $c, 'x' => '5']);; $INSERT = mysqli_query($cnx, "INSERT INTO lpf_cmd (idu,demande,nom,mobile,email,qte,menu,pu_mnu,pu_vin,detail,allergie,retrait,total,paiement,idtransaction,confirm) VALUE ('" . $idc . "','" . $demande . "','" . $nom . "','" . $tel . "','" . $mel . "','" . $qte . "','" . $mnu . "','" . $pum . "','" . $puv . "','" . $dtl . "','" . $allergie . "','" . $retrait . "','" . $total . "','','',NULL)"); $IDnew = mysqli_insert_id($cnx); } else { $bdc = $REQ['nocmd']; $nom = $REQ['nomprenom']; $tel = $REQ['telephone']; $mel = $REQ['email']; $UPDATE = mysqli_query ($cnx , "UPDATE lpf_cmd SET nom='".$nom."',mobile='".$tel."',email='".$mel."' WHERE idu='".$bdc."'"); } echo mysqli_error($cnx); if( mysqli_error($cnx) ) $valide="KO"; else $valide="OK"; return ['valide'=>$valide,'no'=>$idc]; } // NOTE Enregistre le paiement et envoi un email // body: 'action=enregpaye&nocmd='+nobdc+'&etat='+etat+'&id='+id public function EnregPaye($REQ) { $cnx = $this->CnxMYSQL(); // Info du BDC $QF = mysqli_query($cnx, "SELECT * FROM lpf_cmd WHERE idu='".$REQ['nocmd']."'"); $Bdc = mysqli_fetch_array($QF, MYSQLI_ASSOC); $return = ""; // PAIEMENT OK + trouvé dans la base if($Bdc['id']) { if($REQ['etat']=="paiement_ok") { $LPF = $this->Gestion(); $LstCmd = $this->LstCmd( "id" , $REQ['nocmd'] ); $Body = "Merci pour votre commande.
    ".$this->Recapitulatif_Cmd($LstCmd);; $param = ['exp' => $LPF['email'], 'dest' => $Bdc['email'], 'subject' => 'Les PTITS FAYOTS (Votre commande)', 'body' => $Body]; $RMail = $this->MyMail($param); } if ($RMail) $confirm = ",confirm='".date('Y-m-d H:i:s')."'"; else $confirm = ""; $UPDATE = mysqli_query($cnx, "UPDATE lpf_cmd SET idtransaction='" . $REQ['id'] . "',paiement='" . $REQ['etat'] . "' $confirm WHERE idu='" . $REQ['nocmd'] . "'"); if (mysqli_error($cnx)) $valide = "KO"; else $valide = "OK"; } else { } return ['valide'=>$valide]; } // ADMIN - Affiche les menus sur l accueil de l admin public function Accueil_Menu() { $cnx = $this->CnxMYSQL(); $QW = mysqli_query($cnx, "SELECT * FROM menus WHERE 1 ORDER BY id "); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { ($Col['active']=="1") ? $img= "" : $img= ""; ($Col['active']=="1" && $Col['date']) ? $date = substr($Col['date'],8,2)."/".substr($Col['date'],5,2)."/".substr($Col['date'],0,4) : $date =""; echo "
    ".$img." ".strtoupper($Col['nom'])." $date
    "; } } // ADMIN - Affiche compteurs ENtrees, plats, dessers public function Accueil_Compo() { $cnx = $this->CnxMYSQL(); $Cpte = []; $QW = mysqli_query($cnx, "SELECT * FROM choix WHERE 1 ORDER BY id "); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $Cpte[$Col['type']]++; } echo ""; foreach(Type as $k=>$Obj) { if(!$Cpte[$k]) $Cpte[$k] ="0"; ///echo "
    "; echo ""; echo ""; echo ""; } echo "
    "; echo " ".ucwords($Obj)."s
    "; echo "    		".$Cpte[$k]."
    "; } private function QueryCmd($quand ,$id) { if($quand=="j") $QW = "SELECT * FROM lpf_cmd WHERE paiement='paiement_ok' && retrait LIKE '".date('Y-m-d')."%' ORDER BY retrait "; if($quand=="p") $QW = "SELECT * FROM lpf_cmd WHERE paiement='paiement_ok' && retrait >= '".date('Y-m-d 23:59:59')."' ORDER BY retrait "; if($quand=="t") $QW = "SELECT * FROM lpf_cmd WHERE 1 ORDER BY retrait "; if($quand=="id") $QW = "SELECT * FROM lpf_cmd WHERE idu='".$id."' ORDER BY retrait "; return $QW; } // NOTE : ADMIN - Affiche les commandes public function LstCmd( $quand , $id ) { $cnx = $this->CnxMYSQL(); $query = $this->QueryCmd($quand ,$id ); $QW = mysqli_query($cnx, $query); $CpteCmd = $QW->num_rows; while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { list ($Dr,$Hr) = explode (' ',$Col['retrait']); $Cmd[$Dr][$Hr][] = $Col; } // Nbre de commande , Détail return [$CpteCmd,$Cmd]; } // ADMIN - Actions liees à la composition Entree, plat, dessert public function EnregType() { $cnx = $this->CnxMYSQL(); // Ajout if($_REQUEST['btn_ajout']<>'' && !$_REQUEST['btn_modif']) { if(!$_REQUEST['prix_ajout']) $_REQUEST['prix_ajout'] ="0"; $INSERT = mysqli_query ($cnx , "INSERT INTO choix (menu,type,nom,prix) VALUE ('1','".$_REQUEST['type']."','".addslashes(($_REQUEST['btn_ajout']))."','".$_REQUEST['prix_ajout']."')"); $IDnew = mysqli_insert_id($cnx); if (mysqli_error($cnx)) { return ['valide'=>'KO','msg'=>'']; } else { return ['valide'=>'OK','msg'=>'']; } } // Modif if($_REQUEST['btn_modif']>'0') { $id = $_REQUEST['btn_modif']; $UPDATE = mysqli_query ($cnx , "UPDATE choix SET nom='".addslashes($_REQUEST['nom'][$id])."',prix='".$_REQUEST['prix'][$id]."' WHERE id='".$_REQUEST['btn_modif']."'"); if (mysqli_error($cnx)) { return ['valide'=>'KO','msg'=>'']; } else { return ['valide'=>'OK','msg'=>'']; } } // suppr if($_REQUEST['btn_suppr']>0) { $UPDATE = mysqli_query ($cnx , "DELETE FROM choix WHERE id='".$_REQUEST['btn_suppr']."' "); return ['valide'=>'OK','msg'=>'']; } } // ADMIN - Enregistre la config du menu public function EnregMenu() { //echo "
    "; print_r($_REQUEST); echo "
    "; $cnx = $this->CnxMYSQL(); $Detail = [ "entree"=>$_REQUEST['ENTREE'], "plat"=>$_REQUEST['PLAT'], "dessert"=>$_REQUEST['DESSERT'], ]; $Detail = json_encode($Detail); ($_REQUEST['visible_mnu']=="on") ? $active="1" : $active="0" ; // Fete (desactive tout) /* if($_REQUEST['no_menu']=="3") { if( $active=="1" ) { echo "

    =>Menu fete

    "; $UPDATE = mysqli_query($cnx, "UPDATE menus SET active='0' WHERE 1"); $Qdate = ",date='" . $_REQUEST['date'] . "'"; } else { $UPDATE = mysqli_query($cnx, "UPDATE menus SET active='1' WHERE 1"); $Qdate = ",date='" . $_REQUEST['date'] . "'"; } } */ if($_REQUEST['no_menu']=="3") $Qdate = ",date='" . $_REQUEST['date'] . "'"; // nbre_jour='".$_REQUEST['nbre_jour']."', $UPDATE = mysqli_query ($cnx , "UPDATE menus SET nom='".$_REQUEST['nom_menu']."', prix='".$_REQUEST['tarif_menu']."',active='".$active."',detail='".$Detail."',description='".$_REQUEST['description']."' $Qdate WHERE id='".$_REQUEST['no_menu']."'"); echo mysqli_error($cnx); if (mysqli_error($cnx)) { return ['valide'=>'KO','msg'=>'']; } else { (!$active) ? $note="Ce menu n'est plus visible sur votre site marchand." : $note ="Ce menu est visible sur votre site marchant"; return ['valide'=>'OK','msg'=>'']; } //echo "
    ---------"; print_r($_REQUEST); echo "
    "; } // ADMIN - Enregistre les parametre de gestions public function EnregGestion() { $cnx = $this->CnxMYSQL(); // Controle l heure if($_REQUEST['deb']>$_REQUEST['fin']) { return ['valide'=>'KO','msg'=>'']; } else if(count($_REQUEST['Jrs'])==0) { return ['valide'=>'KO','msg'=>'']; } else { // Prépare les jrs foreach($_REQUEST['Jrs'] as $J=>$none) { $Jrs[] = $J; } $jours = implode(';',$Jrs); $UPDATE = mysqli_query ($cnx , "UPDATE config SET ouvre_jrs='".$jours."',ouvre_d='".$_REQUEST['deb']."',ouvre_f='".$_REQUEST['fin']."',nbre_prod='".$_REQUEST['nbre_prod']."' WHERE id='1'"); if (mysqli_error($cnx)) { return ['valide'=>'KO','msg'=>'']; } else { return ['valide'=>'OK','msg'=>'']; } } } // ADMIN - Affiche les infos d un menu public function Menu( $no ) { $cnx = $this->CnxMYSQL(); // Infos menus $QF = mysqli_query($cnx, "SELECT * FROM menus WHERE id='$no'"); $ColM = mysqli_fetch_array($QF, MYSQLI_ASSOC); $Menu[] = $ColM; $Dtl = json_decode($ColM['detail'],TRUE); // Affcihe les choix possibles $QW = mysqli_query($cnx, "SELECT * FROM choix WHERE menu='$no'"); while ($ColC = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $Menu[$ColC['type']][$ColC['id']] = $ColC; $Menu[$ColC['type']][$ColC['id']]['selection'] = $Dtl[$ColC['type']][$ColC['id']]; } return $Menu; } // ADMIN - Comtpe les commandes public function ComtpeCmd() { $cnx = $this->CnxMYSQL(); $Cmd['OK']['all'] = "0"; $Cmd['OK']['j'] = "0"; $Cmd['OK']['p'] = "0"; $Cmd['KO']['all'] = "0"; $Cmd['KO']['j'] = "0"; $Cmd['KO']['p'] = "0"; $QW = mysqli_query($cnx, "SELECT * FROM lpf_cmd WHERE 1"); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { list ($Dr,$Hr) = explode (' ',$Col['retrait']); // OK if( $Col['paiement']=='paiement_ok' ) { $Cmd['OK']['all']++; if ($Dr == date('Y-m-d')) $Cmd['OK']['j']++; // if ($Dr > date('Y-m-d') ) $Cmd['OK']['p']++; $_SESSION['LPF']['TotalCmdDate'][$Dr] += $Col['qte']; // Compte le nombre de qté par date } else { $Cmd['KO']['all']++; if ($Dr == date('Y-m-d')) $Cmd['KO']['j']++; if ($Dr > date('Y-m-d') ) $Cmd['KO']['p']++; } } return $Cmd; } // Extrait les tarifs de menus public function Menu_tarifs() { $cnx = $this->CnxMYSQL(); $QW = mysqli_query($cnx, "SELECT * FROM menus WHERE 1"); while ($Col = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { // Comptabilise menu active et > 0 € if($Col['active']==1 && $Col['prix']>0) { $Mnu[$Col['prix']] = $Col['prix']; } } return $Mnu; } // Affiche public function Composition( $type ) { $cnx = $this->CnxMYSQL(); $QW = mysqli_query($cnx, "SELECT * FROM choix WHERE type='$type' ORDER BY prix desc"); while ($ColC = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $Type[$ColC['id']] = $ColC; } return $Type; } // Gestion public function Gestion() { $cnx = $this->CnxMYSQL(); $QW = mysqli_query($cnx, "SELECT * FROM config WHERE id='1'"); while ($ColC = mysqli_fetch_array( $QW,MYSQLI_ASSOC )) { $MyGest = $ColC; } return $MyGest; } // NOTE : SELECTION Affiche la liste avec les date possible de retrait public function ChoixRetrait() { // Horaires $Horaires = $this->Gestion(); // Extrait Nbre_prod $CompteCmd = $this->ComtpeCmd(); $Xj = explode (';',$Horaires['ouvre_jrs']); $D = substr($Horaires['ouvre_d'],0,2); $F = substr($Horaires['ouvre_f'],0,2); echo "
    "; echo "
    "; echo ""; echo "
    "; echo "
    "; echo ""; echo "
    "; echo "
    "; } // ADMIN - Affiche horaire public function Accueil_horaires() { $Horaires = $this->Gestion(); $Horaire = "".$Horaires['ouvre_jrs']."
    de ".substr($Horaires['ouvre_d'],0,5)." à ".substr($Horaires['ouvre_f'],0,5)."    "; $RepasJour = $Horaires['nbre_prod']; return [$Horaire,$RepasJour]; } // ACCUEIL & ADMIN - Affiche horaire public function Accueil_Msg() { $Horaires = $this->Gestion(); $Tarifs = $this->Menu_tarifs() ; sort( $Tarifs); //$Xj = explode (';',$Horaires['ouvre_jrs']); list($Hd,$Md) = explode (':',$Horaires['ouvre_d']); list($Hf,$Mf) = explode (':',$Horaires['ouvre_f']); if( $Md=="00" ) $Hdeb=$Hd."h"; else $Hdeb=$Hd."h".$Md;; if( $Mf=="00" ) $Hfin=$Hf."h"; else $Hfin=$Hf."h".$Mf;; $Xj = str_replace(';',', ',$Horaires['ouvre_jrs']); // $MsgA = "Nos menu à emporter à ".$Tarifs[0]."€ et ".end($Tarifs)."€ (du ".$Xj[0]." au ".end($Xj)." de ".$Hdeb." à ".$Hfin.")"; $MsgA = "Nos menus à emporter à ".$Tarifs[0]."€ et ".end($Tarifs)."€"; //$MsgB = "Nous proposons de venir retirer votre commande du ".$Xj[0]." au ".end($Xj)." entre ".$Hdeb." et ".$Hfin."."; $MsgB = "Nous proposons de venir retirer votre commande le ".strtolower($Xj)." entre ".$Hdeb." et ".$Hfin."."; $MsgC = "Nous vous proposons des menus à emporter
    à venir retirer au restaurant
    le ".strtolower($Xj)."
    de ".$Hdeb." à ".$Hfin.""; return [$MsgA,$MsgB,$MsgC]; } // Montant global Qte * Prix menu + Vin public function Calcul() { $Calc = ($_SESSION['LPF']['Commande']['PRIX']*$_SESSION['LPF']['Commande']['qte'])+$_SESSION['LPF']['Commande']['mnu']['V']['PRIX']; return number_format ($Calc,2); } public function MyMefNum000( $array ) { $Num = $array['num']; $NbreDigit = $array['x']; $NewNo = substr($Num,-$NbreDigit)+1; return str_repeat("0", abs(strlen($Num)-$NbreDigit) ).$Num; } // Confirme par email public function MyMail ($param) { $Exp = $param['exp']; //$Dest = join(',',$param['dest']); $Dest = $param['dest']; $subject = utf8_decode($param['subject']); $message = utf8_decode($param['body']); $headers[] = 'MIME-Version: 1.0'; $headers[] = 'Content-type: text/html; charset=iso-8859-1'; $headers[] = 'To:'.$Dest; $headers[] = 'From:'.$Exp; $success = mail($Exp , $subject, $message, implode("\r\n", $headers)); return $success; } } ?>