<?
require_once('../conf/connection.php');


?>
<!DOCTYPE html>

<html dir="ltr" lang="en-US"><head><!-- Created by Artisteer v4.3.0.60745 -->
    
    <meta charset="utf-8">
    <title>STOCK DE MENU</title>
    <meta name="viewport" content="initial-scale = 1.0, maximum-scale = 1.0, user-scalable = no, width = device-width">

    <!--[if lt IE 9]><script src="https://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
    <link rel="stylesheet" href="../style.css" media="screen">
    <!--[if lte IE 7]><link rel="stylesheet" href="style.ie7.css" media="screen" /><![endif]-->
    <link rel="stylesheet" href="../style.responsive.css" media="all">


    <script src="../jquery.js"></script>
    <script src="../script.js"></script>
    <script src="../script.responsive.js"></script>



<style>
.art-content .art-postcontent-0 .layout-item-0 { margin-bottom: 10px;  }
.art-content .art-postcontent-0 .layout-item-1 { border-right-style:solid;border-right-width:1px;border-right-color:#C4C6BD; padding-right: 10px;padding-left: 10px;  }
.ie7 .art-post .art-layout-cell {border:none !important; padding:0 !important; }
.ie6 .art-post .art-layout-cell {border:none !important; padding:0 !important; }

.table { border:2px black solid;
 border-radius:10px;
 min-width:300px;
 min-height:300px;
 font-family: Helvetica,Arial;
}
</style>

</head>
<body>
<div id="art-main">
    <div class="art-sheet clearfix">
<nav class="art-nav">
    <ul class="art-hmenu">    
    <li><a>STOCK DE MENU</a></li>
    </ul> 
    </nav>
<div class="art-layout-wrapper">
                <div class="art-content-layout">
                    <div class="art-content-layout-row">
                      <div class="art-layout-cell art-content"><article class="art-post art-article">
                                
                                                
                                <div class="art-postcontent art-postcontent-0 clearfix"><div class="art-content-layout-wrapper layout-item-0">
<div class="art-content-layout">
    <div class="art-content-layout-row">
    <div class="art-layout-cell layout-item-1" style="width: 100%" >
        <table width="719" border="0">
  <tr>
    <td>
    <center>
    <h3><strong>RESTAURANT LA GUARIDA  
      </strong></h3>
      <p><strong>
        
          Stock "Menu del día"
          </center>
    </strong></p></td>
    </tr>
  <tr>
    <td>
      <div style="height:450px; width:100%;  overflow: auto;">
        <?
        $buscar='select * from platos where stock_plato >0 and estado_plato=1 and idgrupos=1';
		   $r=mysql_query($buscar,$conn) or die("Error en el query: ".mysql_error());
		   $n=mysql_num_rows($r);
		    //si hay registros los procesamos
			if($n>0)
			{
			?>
        <table  width="685" border="0">
          <tr bgcolor="#69BFE0" >
            <td width="256" bgcolor="#FFFFFF"><strong>Productos</strong></td>
            <td width="118" bgcolor="#FFFFFF"><strong>Cantidad</strong></td>
            <td width="136" bgcolor="#FFFFFF"><strong>Precio</strong></td>
            <td width="157" bgcolor="#FFFFFF">&nbsp;</td>
            </tr>
          <tr bgcolor="#69BFE0" >
            <td colspan="4" bgcolor="#FFFFFF">-----------------------------------------------------------------------------------------------------------------------------------------------------------------------</td>
            </tr>
          <?
				while($row=mysql_fetch_assoc($r))
				{ //Procesamos cada registro como una fila de tabla
					?>
          <tr>
            <?
					//$row["nomCampo"] estos nomCampo son los campos devueltos por el
					//query en la variable $r que procesa mysql_fetch_assoc
					?>
            <td><h4>
              <? $plato=$row["idplatos"];
					 $query="SELECT * FROM platos WHERE idplatos='$plato'";
 					 $rs_query=mysql_query($query);$nombre=mysql_result($rs_query,0,"descrip_plato");
                     echo $nombre;
					 
					  ?>
            </h4></td>
            <td align="right"><h4><? echo $row["stock_plato"] ?></h4></td>
            <td align="right"><h4><? echo $row["precio_plato"] ?></h4></td>
            <td align="right"><h4>&nbsp;</h4></td>
            </tr>
          <? }?>
          <tr>
            <td colspan="4"><h4>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</h4></td>
            </tr>
          </table>
        <? } 
			else
			{
				echo "No hubieron coincidencias!";
     
			} ?>
      </div>    </td>
    </tr>
  <tr>
    <td colspan="2" align="right">&nbsp;</td>
  </tr>
</table>
    </div>
    </div>
</div>
</div>
</div>


</article></div>
                    </div>
                </div>
            </div>

    </div>
    <p class="art-page-footer">
        <span id="art-footnote-links"><a href="http://www.virtualsurchile.cl" target="_blank">Informatica Francisco Arias E.I.R.L.</a></span>
    </p>
</div>


</body></html>