// 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'); } if (strlen($_POST['fechaEntrega2'])==0) { $_POST['fechaEntrega2'] = 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,cus.email email,phone_mobile ". "from ps_orders o " . "join ps_carrier car on (o.id_carrier=car.id_carrier)". "join ps_customer cus on (o.id_customer=cus.id_customer)". "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 between '".$_POST['fechaEntrega']."' and '".$_POST['fechaEntrega2']."' ". "and car.id_reference=1 ". "and o.current_state in (2,3,4,5,14,16) ". "and tramo_date > date_add(now(),INTERVAL -21 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'); ?>
|
Óptimo Route - Direcciones de entrega por DIA para Madrid Cross - NoCocinoMas.es if ($_POST['procesar']=='S' and $mensajeAlerta == "") { ?>
|