<?php
$tabalpha = array('A', 'B', 'C' , 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
$desert = true;
$fermer = '<div class="Fermer"><p class="chiuso">Il n\'est plus possible de faire des commandes à cette heure-ci.</p><br /><br /><br /></div>';
function affichprod($req, $tb, $r = '', $type = '', $typecommande)
{
$req_plats = mysql_query($req) or die ("Erreur SQL > ".$req."<br />".mysql_error());
$ligne = mysql_fetch_assoc($req_plats);
$prix = number_format($ligne["prix"], 2, ',', ' ');
if (isset($_POST["tbautres"]))
$remarques = $_POST["tbautres"];
if ($r != '')
{
$remarques = $r;
$r = '';
}
if (@strlen($remarques) > 1)
$r .= '<br />('.stripslashes($remarques).')';
echo '<div class="spa2">
<table>
<caption class="SousTitre1">Votre commande :</caption>
<tr>
<th align="left">Produit</th>
<th align="left">Prix</th>
<th align="left">Quantité</th>
<th align="left"> </th>
</tr>
<tr>
<td id="tdprod"><span style="font-size:16px;color:#4b4c38;font-weight:bold;">'.stripslashes($ligne[$tb].''.$type).'</span><br /><span style="font-size:14px;color:#000000;">'.$r.'</span></td>
<td id="tdprix">'.$prix.' CHF</td>
<td><input type="text" name="tquant" onkeydown="javascript:chiffres(event);" maxlength="3" value="1" size="3" /></td>
<td><a href="#" onclick="javascript:document.Fajoutpanier.submit();" id="addlien"><img src="Images/Panier/panieractuNEW.png" alt="Ajouter" border="0" /></a>
<a href="javascript:javascript:history.go(-1)"><img src="Images/Panier/paniersupNEW.png" alt="Supprimer" border="0" /></a></td>
</tr>
</table>
<p class="PCentrer">
<input type="hidden" name="prod" value="'.stripslashes($ligne[$tb].''.$type.'--'.$r).'" />
<input type="hidden" name="prix" value="'.$prix.'" />
<input type="hidden" name="type" value="'.$typecommande.'" />
<input type="hidden" name="btajouterpanier" value="Ajouter" />
</p></div>';
}
if (isset($_POST["element"]))
{
if (is_numeric($_POST["element"]))
{
echo '<form name="Fajoutpanier" method="post" action="index.php?page=panier" onsubmit="javascript: return ajoutPanier();"> ';
switch ($_POST['t'])
{
case "viandesf" :
{
echo '<p class="PCentrer">
<span class="Titre">Viandes Froides</span>
<br /><br /></p>';
$sql = "SELECT id, nom_viande, description, prix
FROM tviandesf
WHERE id = ".$_POST["element"];
//Fermeture des viandes froides a partir de 14h00
if (date('H:i') > '14:00' && date('H:i') < '20:00')
echo $fermer;
else
affichprod($sql, "description", '', '', 'salades');
break;
}
case "platsj" :
{
echo '<p class="PCentrer">
<span class="Titre">Plats du jour</span>
<br /><br />';
$sql = "SELECT id, nom_plats, description, prix
FROM tplatsj
WHERE id = ".$_POST["element"];
//Fermeture des plats du jour a partir de 14h00
if (date('H:i') > '14:00' && date('H:i') < '20:00')
echo $fermer;
else
affichprod($sql, "description", '', '', 'platsc');
break;
}
case "platsch" :
{
echo '<p class="PCentrer">
<span class="Titre">Plats chauds</span>
<br /><br />';
$sql = "SELECT id, nom_plats, description, prix
FROM tplatsch
WHERE id = ".$_POST["element"];
//Fermeture des plats chauds a partir de 14h00
if (date('H:i') > '14:00' && date('H:i') < '20:00')
echo $fermer;
else
affichprod($sql, "description", '', '', 'platsc');
break;
}
case "sandwiches" :
{
echo '<p class="PCentrer">
<span class="Titre">Sandwiches</span>
<br /><br />';
$sql = "SELECT id, nom_sandwiche, prix
FROM tsandwiches
WHERE id = ".$_POST["element"];
$param = '';
if (isset($_POST["cbpain"]))
{
@$t = split('-', $_POST["cbpain"]);
$param .= $t[1].'<br />';
}
if (isset($_POST["cbcharcuteries"]))
{
foreach($_POST["cbcharcuteries"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbfromages"]))
{
foreach($_POST["cbfromages"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbgarnitures"]))
{
foreach($_POST["cbgarnitures"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbdivers"]))
{
foreach($_POST["cbdivers"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
$param = substr($param, 0, -6);
if (strlen($_POST["tbautres"]) > 0)
$param .= '<br /><br />'.$_POST["tbautres"];
affichprod($sql, "nom_sandwiche", $param, ' - Sandwiche', 'sand');
break;
}
case "salades" :
{
echo '<p class="PCentrer">
<span class="Titre">Salades</span>
<br /><br />';
$sql = "SELECT id, nom_salade, prix
FROM tsalades
WHERE id = ".$_POST["element"];
$param = '';
if (isset($_POST["cbpain"]))
{
@$t = split('-', $_POST["cbpain"]);
$param .= $t[1].'<br />';
}
if (isset($_POST["cbcharcuteries"]))
{
foreach($_POST["cbcharcuteries"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbfromages"]))
{
foreach($_POST["cbfromages"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbgarnitures"]))
{
foreach($_POST["cbgarnitures"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbdivers"]))
{
foreach($_POST["cbdivers"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
if (isset($_POST["cbsauces"]))
{
foreach($_POST["cbsauces"] as $v){
@$t = split('-', $v);
$param .= $t[1].'<br />';
}
}
$param = substr($param, 0, -6);
if (strlen($_POST["tbautres"]) > 0)
$param .= '<br /><br />'.$_POST["tbautres"];
affichprod($sql, "nom_salade", $param, ' - Salade', 'salades');
break;
}
case "boissons" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Boissons</span>
<br /><br />';
$sql = "SELECT id, nom_boisson, prix
FROM tboissons
WHERE id = ".$_POST["element"];
affichprod($sql, "nom_boisson", '', '', 'betd');
break;
}
case "pane" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Pain</span>
<br /><br />';
$sql = "SELECT id, nom_pane, prix
FROM tpane
WHERE id = ".$_POST["element"];
affichprod($sql, "nom_pane", '', '', 'pane');
break;
}
case "shoppates" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Pâtes et Risotto</span>
<br /><br />';
$sql = "SELECT id, nom_pasta, tipo_pasta, prix
FROM tpasta
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_pasta", '', '', 'pasta');
break;
}
case "shopcharcuteries" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Charcuteries</span>
<br /><br />';
$sql = "SELECT id, nom_salumi, tipo_salumi, prix
FROM tsalumi
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_salumi", '', '', 'betd');
break;
}
case "shopvin" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Vins et Alcools</span>
<br /><br />';
$sql = "SELECT id, nom_vino, tipo_vino, prix
FROM tvino
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_vino", '', '', 'betd');
break;
}
case "shophuile" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Huile et Vinaigres</span>
<br /><br />';
$sql = "SELECT id, nom_olio, tipo_olio, prix
FROM tolio
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_olio", '', '', 'betd');
break;
}
case "shopdivers" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Divers</span>
<br /><br />';
$sql = "SELECT id, nom_varie, tipo_varie, prix
FROM tvarie
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_varie", '', '', 'betd');
break;
}
case "shopepices" :
{
$desert = false;
echo '<p class="PCentrer">
<span class="Titre">Epices et Condiments</span>
<br /><br />';
$sql = "SELECT id, nom_spezie, tipo_spezie, prix
FROM tspezie
WHERE id = ".$_POST["element"];
affichprod($sql, "tipo_spezie", '', '', 'betd');
break;
}
case "sandperso" :
{
echo '<p class="PCentrer">
<span class="Titre">Sandwiches</span>
<br /><br />';
$base = 0;
$passed = false;
$r = '<br />('.$_POST["rbpain"].'<br />';
//Calcul des prix de base
if (isset($_POST["cbcharcuteries"])){
foreach($_POST["cbcharcuteries"] as $charc){
if ($charc == 'Culatello di Zibello' || $charc == 'Roastbeef'){
$base = 12;
$r .= $charc.'<br />';
}
else
{
$base = 10;
$r .= $charc.'<br />';
}
}
}
else
{
foreach($_POST["cbdivers"] as $divers){
if ($divers == 'Thon'){
$base = 8;
$thon = true;
}
else
{
$base = 8;
$garni = 3;
}
}
}
if (isset($_POST["cbcharcuteries"])){
if (count($_POST["cbcharcuteries"]) > 1){
$base += 1;
}
}
if (isset($_POST["cbfromages"])){
if (count($_POST["cbfromages"]) > 1){
$base += 1;
foreach($_POST["cbfromages"] as $frm)
$r .= $frm.'<br />';
}
else{
foreach($_POST["cbfromages"] as $frm){
if (isset($thon))
$base += 1;
$r .= $frm.'<br />';
}
}
}
if (isset($_POST["cbgarnitures"]))
{
foreach($_POST["cbgarnitures"] as $gar)
{
$r .= $gar.'<br />';
$base += 1;
}
}
if (isset($_POST["cbdivers"]) && count($_POST["cbdivers"]) > 4 && !isset($garni)){
$base += count($_POST["cbdivers"]) - 4;
foreach($_POST["cbdivers"] as $di)
$r .= $di.'<br />';
}
elseif (isset($_POST["cbcharcuteries"]) && isset($_POST["cbdivers"]))
{
foreach($_POST["cbdivers"] as $di)
$r .= $di.'<br />';
}
elseif (isset($garni))
{
if (count($_POST["cbdivers"]) >= $garni)
$base += count($_POST["cbdivers"]) - $garni;
foreach($_POST["cbdivers"] as $di)
$r .= $di.'<br />';
}
if (isset($_POST["autorizzazione"]))
{
if ($_POST["autorizzazione"] == "OUI"){
$r .= "Changement de pain autorisé<br />";
}
}
$r = substr($r, 0, -6);
$r .= ')';
$r = stripslashes($r);
echo '
<div class="spa2">
<table>
<caption class="SousTitre1">Votre commande :</caption>
<tr>
<th align="left">Produit</th>
<th align="left">Prix</th>
<th align="left">Quantité</th>
<th align="left"> </th>
</tr>
<tr>
<td id="tdprod"><span style="font-size:16px;color:#4b4c38;font-weight:bold;">Sandwiche</span><br /><span style="font-size:14px;color:#000000;">'.$r.'</span></td>
<td id="tdprix">'.number_format($base, 2, ',', ' ').' CHF</td>
<td><input type="text" name="tquant" onkeydown="javascript:chiffres(event);" maxlength="3" value="1" size="3" /></td>
<td><a href="#" onclick="javascript:document.Fajoutpanier.submit();" id="addlien"><img src="Images/Panier/panieractuNEW.png" border="0" /></a>
<a href="javascript:javascript:history.go(-1)"><img src="Images/Panier/paniersupNEW.png" alt="Supprimer" border="0" /></a>
</td>
</tr>
</table>
<p class="PCentrer">
<input type="hidden" name="prod" value="Sandwiche--'.$r.'" />
<input type="hidden" name="prix" value="'.number_format($base, 2, ',', ' ').'" />
<input type="hidden" name="type" value="sand" />
<input type="hidden" name="btajouterpanier" value="Ajouter" />
</p></div>';
break;
}
case "desserts" : {
echo '<p class="PCentrer">
<span class="Titre">Desserts</span>
<br /><br />';
$sql = "SELECT id, nom_plats, description, prix
FROM tdesert
WHERE id = ".$_POST["element"];
affichprod($sql, "description", '', '', 'betd');
$desert = false;
break;
}
case "saladeperso" :
{
echo '<p class="PCentrer">
<span class="Titre">Salades</span>
<br /><br />';
$base = 0;
$passed = false;
$r = '<br />';
//Calcul des prix de base
if (isset($_POST["cbgarnitures"]))
{
foreach($_POST["cbgarnitures"] as $gar)
{
$r .= $gar.'<br />';
$base += 1.5;
}
}
if (isset($_POST["cbcharcuteries"]))
{
foreach($_POST["cbcharcuteries"] as $cha)
{
$r .= $cha.'<br />';
$base += 5;
}
}
if (isset($_POST["cbfromages"])){
foreach($_POST["cbfromages"] as $fro){
if ($fro == 'Mozzarella di Bufala'){
$base += 6;
$r .= $fro.'<br />';
}
else
{
$base += 5;
$r .= $fro.'<br />';
}
}
}
if (isset($_POST["cbsauce"])){
foreach($_POST["cbsauce"] as $sau){
if ($sau == 'Sel'){
$base += 0;
$r .= $sau.'<br />';
}
else
{
$base += 1;
$r .= $sau.'<br />';
}
}
}
if (isset($_POST["cbdivers"])){
foreach($_POST["cbdivers"] as $div){
if ($div == 'Thon'){
$base += 6;
$r .= $div.'<br />';
}
else
{
$base += 1.5;
$r .= $div.'<br />';
}
}
}
$r = substr($r, 0, -6);
$r .= ')';
$r = stripslashes($r);
echo '
<div class="spa2">
<table>
<caption class="SousTitre1">Votre commande :</caption>
<tr>
<th align="left">Produit</th>
<th align="left">Prix</th>
<th align="left">Quantité</th>
<th align="left"> </th>
</tr>
<tr>
<td id="tdprod"><span style="font-size:16px;color:#4b4c38;font-weight:bold;">Salade</span><br /><span style="font-size:14px;color:#000000;">'.$r.'</span></td>
<td id="tdprix">'.number_format($base, 2, ',', ' ').' CHF</td>
<td><input type="text" name="tquant" onkeydown="javascript:chiffres(event);" maxlength="3" value="1" size="3" /></td>
<td><a href="#" onclick="javascript:document.Fajoutpanier.submit();" id="addlien"><img src="Images/Panier/panieractuNEW.png" border="0" /></a>
<a href="javascript:javascript:history.go(-1)"><img src="Images/Panier/paniersupNEW.png" alt="Supprimer" border="0" /></a>
</td>
</tr>
</table>
<p class="PCentrer">
<input type="hidden" name="prod" value="Salades--'.$r.'" />
<input type="hidden" name="prix" value="'.number_format($base, 2, ',', ' ').'" />
<input type="hidden" name="type" value="sand" />
<input type="hidden" name="btajouterpanier" value="Ajouter" />
</p></div>';
break;
}
}
}
}
?>