// error_reporting(E_ALL & ~E_NOTICE);
error_reporting(E_ALL);
set_time_limit(60);
include('includes/configure.php');
// Codigo de barras
require("codigoBarras/php-barcode.php");
function getvar($name){
global $_GET, $_POST;
if (isset($_GET[$name])) return $_GET[$name];
else if (isset($_POST[$name])) return $_POST[$name];
else return false;
}
if (get_magic_quotes_gpc()){
$code=stripslashes(getvar('code'));
} else {
$code=getvar('code');
}
//if (!$code) $code='123456789012';
// Fin código de barras
//Detectar pedidos duplicados
$texto_query = "select DATE_FORMAT(o.date_upd,'%Y%m%d%h%i'),o.id_customer,count(*) cuenta ".
"from ps_orders o join ps_cart dd on (dd.id_cart=o.id_cart) " .
"where dd.tramo_date=date(adddate(now(),INTERVAL 1 day)) ".
"and current_state in (2,3,4,5,14,16) ".
"group by 1,2 ".
"having cuenta>1 ";
//echo $texto_query;
$status_query = tep_db_query($texto_query);
$primero=true;
echo '';
while ($status_values = tep_db_fetch_array($status_query)) {
if ($primero) {
echo 'Posibles Pedidos Duplicados para MAÑANA del cliente:';
$primero=false;
}
echo $status_values['id_customer'].'-';
}
echo '';
?>
www.nococinomas.es
if ($_POST['procesar']<>'S') { ?>
Listado de Pedidos para Sala de nococinomas.es
Las fechas que debes especificar son del Día de Entrega del pedido. Pueden ser la misma para un mismo día
} else {
$status_array = array();
$texto_query = "SELECT distinct CONCAT(ad.firstname,' ',ad.lastname) delivery_name,o.id_order orders_id, o.id_customer customers_id,od.product_id products_id, " .
"ad.phone_mobile customers_telephone,osl.name orders_status_name,CONCAT(cu.firstname,' ',cu.lastname) customers_name,id_state, ".
"od.product_name products_name, round(product_quantity,2) products_quantity,dd.tramo_date shipdate, ".
"concat(tramo_from,'-',tramo_until) prefEntrega,id_reference, " .
" o.total_products_wt,o.total_shipping_tax_incl,o.total_paid_tax_incl,round(unit_price_tax_incl,2) unit_price_tax_incl ".
"FROM ps_order_detail od JOIN ps_orders o ON od.id_order = o.id_order " .
"join ps_address ad on o.id_address_delivery=ad.id_address ".
"join ps_cart dd on (dd.id_cart=o.id_cart) " .
"join ps_order_state_lang osl on (osl.id_order_state = o.current_state and osl.id_lang=1) " .
"join ps_carrier car on (car.id_carrier=o.id_carrier) " .
"join ps_customer cu on o.id_customer=cu.id_customer ";
if (strlen($_POST['pedidos'])>0) {
$texto_query .= "WHERE o.id_order in (".$_POST['pedidos'].") and (o.current_state in (2,3,4,5,14,16)) "; //Cancelado y Pago Virtual
} else {
$texto_query .= "WHERE dd.tramo_date between '" . $_POST['fecIni'] . "' and '" . $_POST['fecFin'] . "' and (o.current_state in (2,3,4,5,14,16)) ";
}
$texto_query .= "order by dd.tramo_date,o.id_order,od.product_name";
//echo $texto_query;
$status_query = tep_db_query($texto_query);
//echo $texto_query;
?>
$pedido = '0';
$esPrimeraPagina = true;
$numPlatos = 0;
while ($status_values = tep_db_fetch_array($status_query)) {
//echo 'pasa1';
if ($pedido<>$status_values['orders_id']) { //Para que la cabecera aparezca una sóla vez
if ($pedido<>'0') { //Pongo los totales de cada pedido
?>
Subtotal:
echo $total_products_wt; ?>
Transporte:
echo $total_shipping_tax_incl; ?>
Total Final:
echo $total_paid_tax_incl; ?>
>> Para ver más detalles de tu pedido: http://www.nococinomas.es/historial-compra
}
$pedido = $status_values['orders_id'];
if (!$esPrimeraPagina and $_POST['saltoPagina']) {
if (!$esPrimeraPagina) {echo '* '.$numPlatos. ' platos';}
$numPlatos = 0;
?>
}
$esPrimeraPagina = false;
?>
$traza = zerofill($pedido.'9',13);
barcode_print($traza,getvar('encoding'),'2','html'); ?>
Albarán Fecha de Entrega: echo $status_values['shipdate']; ?>
if ($status_values['id_reference']=='1') { //Carlos
?>
** ENTREGA EN MADRID **
} elseif ($status_values['id_reference']=='17' or $status_values['id_reference']=='31' or $status_values['id_reference']=='33') {
?>
** ENTREGA EN SEVILLA **
} elseif ($status_values['id_reference']=='34') {
?>
** GLS ASM **
}
if ($status_values['customers_id']=='23660' or $status_values['customers_id']=='25027' or $status_values['customers_id']=='26210') {
echo('IMPORTANTE: No entregar con Seur');
}
?>
91 091 11 74
soporte@nococinomas.es
Nº de Pedido: echo $status_values['orders_id']; ?>
Nombre Cliente: echo $status_values['customers_name']; ?>
if ($status_values['customers_name']<>$status_values['delivery_name']) { ?>
Persona que recepciona: echo $status_values['delivery_name'];
}
?>
Estado del Pedido: echo $status_values['orders_status_name']; ?>
Horario de Entrega:
echo $status_values['prefEntrega'];
?>
$texto_query1 = "select message ".
"from ps_customer_message cm join ps_customer_thread ct on (cm.id_customer_thread=ct.id_customer_thread) ".
"where ct.id_order='".$status_values['orders_id']."' ".
"and cm.private=1 ".
"order by cm.date_upd desc ";
//echo $texto_query1;
$status_query1 = tep_db_query($texto_query1);
$comentariosACocina='';
while ($status_values1 = tep_db_fetch_array($status_query1)) {
$comentariosACocina .= $status_values1['message'].' | ';
}
if (strlen($comentariosACocina)>0) { ?>
$numPlatos += $status_values['products_quantity'];
//Averiguo si el producto actual es un menú
$texto_query1 = "select p.id_product_item products_id,pl.name products_name,p.quantity products_quantity,pr.weight products_weight " .
"from ps_pack p join ps_product pr on p.id_product_item=pr.id_product ".
"join ps_product_lang pl on (p.id_product_item=pl.id_product and pl.id_lang=1) ".
"where p.id_product_pack=".$status_values['products_id'].' '.
"order by products_name";
//echo $texto_query1;
$status_query1 = tep_db_query($texto_query1);
if (tep_db_num_rows($status_query1)>0) {
$numPlatos -= $status_values['products_quantity']; //Como se trata de un pack, debo quitarlo ya que lo sumé previamente
while ($status_values1 = tep_db_fetch_array($status_query1)) {
?>