INNER JOIN sys_comprobante ON sys_comprobante.id_turno = tur.id_tur
INNER JOIN sys_comprobante_detalle ON sys_comprobante_detalle.idcomprobante = sys_comprobante.idcomprobante
INNER JOIN pro on pro.id_pro = sys_comprobante_detalle.idproducto
WHERE tur.est_tur = '".$est."' AND (sys_comprobante_detalle.mostrar = 1 or pro.bar = 0) AND tur.nro = '".$_POST['id_hab']."';
";
$result = mysql_query($sql, $pconnect);
while($fila = mysql_fetch_assoc($result)){
$total_turno = $fila['total'];
$idcomprobante = $fila['idcomprobante'];
$fec_in = $fila_comp['fec_in'];
}
// calculamos el dia y la hora para la fecha de entrada
$dia_act = traer_dia_producto($fec_in);
$hor_act = traer_hora_producto($fec_in);
// obtenemos el precio original
$sql = "
SELECT pro.val FROM tur
INNER JOIN hab ON hab.nro = tur.nro
INNER JOIN pro ON pro.tip = hab.tip
WHERE
tur.est_tur = 1 AND
tur.nro = '".$_POST['id_hab']."' AND
pro.bar = 0 AND
pro.promo_hab = 0 AND
pro.dia = '".$dia_act."' AND
pro.hor = '".$hor_act."'
LIMIT 1
<script src="js/jquery-ui-1.10.3.custom.js"></script>
</head>
<body>
<div>
<div style="float:left;">
<img src="img/logo_cb.png" width="100%" />
</div>
<div style="float:left;">
<!--<img src="img/hab_cb.png" width="100%" />-->
</div>
<div style="clear:both;"></div>
</div>
<?
$dia_producto = traer_dia_producto();
$hora_producto = traer_hora_producto();
$sql = "
SELECT pro.tip, tip_hab.tip, pro.pro, pro.val, pro.tie FROM pro
INNER JOIN tip_hab ON tip_hab.id_tip = pro.tip
WHERE pro.bar = 0 AND pro.dia = ".$dia_producto." AND pro.hor = ".$hora_producto."
";
$result = mysql_query($sql, $pconnect);
//echo "mysql_error: ".mysql_error();
?>
<div id="contenedor">
<?
