// error_reporting(E_ALL & ~E_NOTICE); error_reporting(E_ALL); include('includes/configure.php'); //-------------------------------------------------------------------------------------- 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')); } if (strlen($_POST['fecIniBarcelona'])==0 or strlen($_POST['fecFinBarcelona'])==0) { if (date('N')==1 or date('N')==2) { $_POST['fecIniBarcelona'] = date('Y-m-d',strtotime('now +2 DAY')); $_POST['fecFinBarcelona'] = date('Y-m-d',strtotime('now +2 DAY')); } else if (date('N')==3) { //para el viernes y sábado $_POST['fecIniBarcelona'] = date('Y-m-d',strtotime('now +2 DAY')); $_POST['fecFinBarcelona'] = date('Y-m-d',strtotime('now +3 DAY')); } else if (date('N')==4) { //serán los del lunes y martes $_POST['fecIniBarcelona'] = '2000-01-01'; $_POST['fecFinBarcelona'] = '2000-01-01'; } else if (date('N')==5) { //serán los del lunes y martes $_POST['fecIniBarcelona'] = date('Y-m-d',strtotime('now +4 DAY')); $_POST['fecFinBarcelona'] = date('Y-m-d',strtotime('now +4 DAY')); } else if (date('N')==6) { $_POST['fecIniBarcelona'] = date('Y-m-d',strtotime('now +4 DAY')); $_POST['fecFinBarcelona'] = date('Y-m-d',strtotime('now +4 DAY')); } else if (date('N')==7) { $_POST['fecIniBarcelona'] = date('Y-m-d',strtotime('now +3 DAY')); $_POST['fecFinBarcelona'] = date('Y-m-d',strtotime('now +3 DAY')); } } $texto_query = "select distinct tramo_date date_delivery,o.id_order,c.firstname,c.lastname,postcode ". "from ps_order_detail od join ps_orders o on (od.id_order=o.id_order) ". "join ps_customer c on (o.id_customer=c.id_customer) ". "join ps_address a on (o.id_address_delivery=a.id_address) ". "join ps_cart ca on ca.id_cart=o.id_cart ". "WHERE tramo_date = '".$_POST['fecIni']."' ". "and od.product_name not like '%Keto%' ". "and current_state in (2,3,4,5,14,16) ". "and 1 = (select count(*) from ps_orders oo where o.id_customer=oo.id_customer) ". "order by 1,2"; //echo $texto_query; $status_query = tep_db_query($texto_query); ?>
|
Entregar Libritos Keto (clientes nuevos que no piden keto) if ($_POST['procesar']=='S' and $mensajeAlerta == "") { ?>
|