// error_reporting(E_ALL & ~E_NOTICE); error_reporting(E_ALL); include('includes/configure.php'); //-------------------------------------------------------------------------------------- if (strlen($_POST['fechaEntrega'])==0) { $_POST['fechaEntrega'] = date('Y-m-d'); } $status_array = array(); $texto_query = "select o.id_order orders_id,postcode delivery_postcode,city delivery_city,CONCAT(ad.address1,' ',ad.address2) delivery_street_address,CONCAT(ifnull(message,''),' ',other) comentariosPedido,tramo_date shipdate,CONCAT(phone,' ',phone_mobile) customers_telephone,CONCAT(ad.firstname,' ',ad.lastname) delivery_name, concat(tramo_from,'-',tramo_until) prefEntrega,payment payment_method,o.id_customer customers_id, round(total_paid_tax_incl,2) total ". "from ps_orders o " . "join ps_carrier car on (o.id_carrier=car.id_carrier)". "left join ps_orders1 o1 on (o.id_order=o1.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) " . "left join ps_message mes on (o.id_order=mes.id_order) " . "where tramo_date = '".$_POST['fechaEntrega']."' ". "and car.id_reference in (19,32) " . "and o.current_state in (2,3,4,5,14,16) ". "and tramo_date > date_add(now(),INTERVAL -7 DAY) "; //Para evitar que se vean direcciones anteriores $texto_query .="order by shipdate,prefEntrega,delivery_postcode"; //echo $texto_query; $status_query = tep_db_query($texto_query); ?>
// php require(DIR_WS_INCLUDES . 'header.php'); ?>
|
Direcciones de entrega por DIA para NoCocinoMas.es if ($_POST['procesar']=='S' and $mensajeAlerta == "") { ?>
|