0) { $fechaEntrega=$_POST['fecha']; } else { $fechaEntrega=date('Y-m-d',strtotime('-1 day')); } //echo date('d-m-Y',strtotime($fechaEntrega." +60 days")); //nombre del producto seleccionado $texto_query = "select name products_name " . "from ps_product_lang ". "where id_product = '".$_POST['codProducto']."' and name not like '%*%'"; $status_query = tep_db_query($texto_query); $status_values = tep_db_fetch_array($status_query); $nombrePr = $status_values['products_name']; $grabaReg = true; $_POST['cantidadUrg']=1; if ($_POST['cantidadGrUrg']<>0) { /* Busco el código de producto para Grande*/ $texto_query = "select id_product products_id " . "from ps_product_lang ". "where name like '".$nombrePr."%' ". "and name like '%GRANDE%' "; $status_query = tep_db_query($texto_query); if (tep_db_num_rows($status_query)>0) { $status_values = tep_db_fetch_array($status_query); $prGR = $status_values['products_id']; } else { $grabaReg = false; } } $status_array = array(); //La categoría 70 es la de Gourmet. Es para que no se repitan los platos /*$status_query = tep_db_query("select p.products_id,products_name from products_description pd join products p on (p.products_id=pd.products_id) join products_to_categories ptc on (ptc.products_id=p.products_id and ptc.categories_id<>'70') where (products_status=1 or products_name like '%Dukan(P%') order by products_name"); */ $status_query = tep_db_query("select pl.id_product products_id,name products_name from ps_product_lang pl join ps_product p on pl.id_product=p.id_product where name not like '%*%' and name not like '%DUKAN%' and name not like '%PACK%' order by name"); $status_array[] = array('id' => '0', 'text' => 'Selecciona un Producto'); while ($status_values = tep_db_fetch_array($status_query)) { $status_array[] = array('id' => $status_values['products_id'], 'text' => $status_values['products_name']); } $quien_array = array(); $quien_query = tep_db_query("select idEmpleado,nombre from ps_osc_empleados where habilitado='1' order by 2"); $quien_array[] = array('id' => '0', 'text' => 'Selecciona Empleado'); while ($quien_values = tep_db_fetch_array($quien_query)) { $quien_array[] = array('id' => $quien_values['idEmpleado'], 'text' => $quien_values['nombre']); } ?> Etiquetas 'S') { ?> 'S') { if (strlen($_POST['fecIni'])==0 or strlen($_POST['fecFin'])==0) { $_POST['fecIni'] = date('Y-m-d',strtotime('now +1 DAY')); $_POST['fecFin'] = date('Y-m-d',strtotime('now +1 DAY')); $_POST['fecha'] = date('Y-m-d'); } ?>

Etiquetas de Platos



Plato: 

Bandejas   Cajas
Sueltos
Urgentes

 



0) { $texto_query = "select 0000 orders_id,pd.id_product products_id,name products_name,ingredientes,description modoPreparacion,'' vidaUtil,DATE_ADD(NOW(), INTERVAL 1 DAY) shipdate,1 total, ". "weight products_weight,energia,proteinas,hidratos,grasas,alergenos, " . "grasasSaturadas,azucares,sodio ". "from ps_product_lang pd join ps_product p on pd.id_product= p.id_product " . "where pd.id_product=".$_POST['codProducto']; } else { $texto_query = "select op.orders_id,op.products_id,op.products_name,ingredientes,modoPreparacion,vidaUtil,shipdate,sum(op.products_quantity) total,pesoNeto, ". "conservacion,products_weight,energia,proteinas,hidratosCarbono,grasasTotales,alergenos, " . "grasasSaturadas,azucares,sodio ". "from orders_products op join orders o on op.orders_id=o.orders_id ". "join products_description p on (op.products_id=p.products_id) " . "join products pp on pp.products_id = op.products_id "; if (strlen($_POST['pedidos']) > 0) { $texto_query .="where o.orders_id in (".$_POST['pedidos'].") "; } else { $texto_query .="where o.shipdate between '" . $_POST['fecIni'] . "' and '" . $_POST['fecFin'] . "' and o.orders_status<>9 "; } $texto_query .= "group by 1,2 order by 1"; } $status_query = tep_db_query($texto_query); //echo $texto_query; while ($status_values = tep_db_fetch_array($status_query)) { for ( $i = 1 ; $i <= $status_values['total'] ; $i ++) { //Averiguo si el producto actual es un menú $texto_query2 = "select menu_id,m.products_id,products_name " . "from menus_to_products m join products_description p on m.products_id = p.products_id " . "where m.products_id=".$status_values['products_id']; //$status_query2 = tep_db_query($texto_query2); if (1==0 or tep_db_num_rows($status_query2)>0) { $status_values2 = tep_db_fetch_array($status_query2); $texto_query1 = "select m.products_id,products_name,m.products_quantity total,ingredientes,modoPreparacion,vidaUtil,registroSanitario," . "pesoNeto,conservacion,products_weight,energia,proteinas,hidratosCarbono,grasasTotales,alergenos, " . "grasasSaturadas,azucares,sodio ". "from menus m join products_description pd on (m.products_id=pd.products_id) ". "join products p on pd.products_id=p.products_id ". "where menu_id=".$status_values2['menu_id']; //echo $texto_query1; $status_query1 = tep_db_query($texto_query1); while ($status_values1 = tep_db_fetch_array($status_query1)) { for ( $i = 1 ; $i <= ($status_values1['total']*$status_values['total']) ; $i ++) { ?>
le width=100% align="center">


/> Ingredientes: 1) { echo ' Alérgenos: '.stripslashes($status_values1['alergenos']).''; } ?> | Modo de Preparación: | Peso N: g. | Lote:  (Fecha Caducidad:) [V.Nutric. por 100 g. Energ: kcal. Pr: g. HC: g. Gr: g. GrSat: g. Az: g. Sd: g.] NRS:26.020247/SE
'.substr($traza,1,12).''; ?>
958) { //Para los postres $cant = $_POST['cantidad']; $cantUrg = $_POST['cantidadUrg']; $cantUrg=1; for ( $i = 1 ; $i <= ($cant-$cantUrg); $i ++) { $texto_query = "select p.products_id,products_name,ingredientes,modoPreparacion,vidaUtil,".$fechaEntrega." shipdate,1 total,pesoNeto, ". "conservacion,products_weight,energia,proteinas,hidratosCarbono,grasasTotales,alergenos, " . "grasasSaturadas,azucares,sodio ". "from products_description pd join products p on (p.products_id=pd.products_id) " . "where p.products_id='".$status_values['products_id']."'"; $status_query = tep_db_query($texto_query); $status_values = tep_db_fetch_array($status_query); ?>
'.substr($traza,1,12).''; ?>

Ingredientes: 1) { echo ' Alérgenos: '.stripslashes($status_values['alergenos']).''; } ?> | Modo de Preparación: | Peso N: g. | Lote: [V.Nutric. por 100 g. Energ: kcal. Pr: g. HC: g. Gr: g. GrSat: g. Az: g. Sd: g.] NRS:26.020247/SE
0) { $cant=1; $cantUrg=0; $codProd = $_POST['codProducto']; $nEtiquetas = 1; } elseif ($_POST['cantidadGrUrg']>0) { $cant=0; $cantUrg=1; $codProd = $prGR; $nEtiquetas = 1; } $cantUrg=1; $nEtiquetas = 1; for ( $i = 1 ; $i <= ($nEtiquetas); $i ++) { $texto_query = "select p.id_product products_id,name products_name,ingredientes,description modoPreparacion,'' vidaUtil,DATE_ADD(NOW(), INTERVAL 1 DAY) shipdate,1 total, ". "weight products_weight,energia,proteinas,hidratos,grasas,alergenos, " . "grasasSaturadas,azucares,sodio ". "from ps_product_lang pd join ps_product p on (p.id_product=pd.id_product) " . "where p.id_product='".$codProd."'"; $status_query = tep_db_query($texto_query); $status_values = tep_db_fetch_array($status_query); if ($_POST['cajas']) { $texto= $_POST['cajas'].'c '; } elseif ($_POST['bandejas']) { $texto= $_POST['bandejas'].'b '; } if ($_POST['sueltos']) { $texto.= " ". $_POST['sueltos'].'s '; } if ($_POST['urgentes']) { $texto.= " ". $_POST['urgentes'].'U '; } if (tep_db_num_rows($status_query)>0) { ?>

'.$texto.strrev(date("dmY")); ?>