'' "; */ $texto_query0 = "select max(date_delivery) fecha ". "from ps_orders o join ps_carrier c on (o.id_carrier=c.id_carrier and c.id_reference=2) join ps_deliverydays_cart d on (d.id_cart=o.id_cart) ". "join ps_remesas r on o.remesa=r.nombre ". "where remesa <>'' " . "and upper(payment) like '%EFECTIVO%' "; $status_query0 = tep_db_query($texto_query0); $status_values0 = tep_db_fetch_array($status_query0); $datetime1 = strtotime($status_values0['fecha']); $datetime2 = strtotime(date('Y-m-d')); $diasDif = ($datetime2-$datetime1)/(60*60*24); if ($diasDif>=15) { tep_mail('nococinomas.es', 'info@nococinomas.es', 'NCM: proceso de Remesas NO Ejecutado', 'Hay remesas pendientes de comprobar', 'soporte@nococinomas.es','soporte@nococinomas.es'); tep_mail('nococinomas.es', 'desiree@nococinomas.es', 'NCM: proceso de Remesas NO Ejecutado', 'Hay remesas pendientes de comprobar', 'soporte@nococinomas.es','soporte@nococinomas.es'); } else { tep_mail('nococinomas.es', 'info@nococinomas.es', 'NCM: proceso de Remesas OK', '', 'soporte@nococinomas.es','soporte@nococinomas.es'); } if ($_GET['remesa']<>'' and strlen($_POST['fecIni'])==0) { tep_db_query("insert into ps_remesas(id,nombre,comprobado) values('','".$_GET['remesa']."',1)"); } If (strlen($_POST['fecIni'])>0) { $fecIni= $_POST['fecIni']; } elseif (strlen($_GET['fecIni'])>0) { $fecIni= $_GET['fecIni']; } else { $fecIni = date('Y-m-d',strtotime('now -90 DAY')); } If (strlen($_POST['fecFin'])>0) { $fecFin= $_POST['fecFin']; } elseif (strlen($_GET['fecFin'])>0) { $fecFin= $_GET['fecFin']; } else { $fecFin = date('Y-m-d',strtotime('now')); } $status_array = array(); /* $texto_query = "select remesa,max(date_delivery) fecha,round(sum(total_paid_real),2) total,comprobado ". "from orders o left join remesas r on o.remesa=r.nombre ". "where payment_method like '%efect%' ". "and shipdate between '" . $fecIni . "' and '" . $fecFin . "' " . "and idRepartidor=0 " . "and remesa<>'' " . "group by 1 ". "order by 1 desc "; */ $texto_query = "select remesa,max(date_delivery) fecha,round(sum(total_paid_real),2) total,comprobado ". "from ps_orders o join ps_carrier c on (o.id_carrier=c.id_carrier and c.id_reference=2) join ps_deliverydays_cart d on (d.id_cart=o.id_cart) ". "left join ps_remesas r on o.remesa=r.nombre ". "where remesa <>'' " . "and date_delivery between '" . $fecIni . "' and '" . $fecFin . "' " . "and upper(payment) like '%EFECTIVO%' ". "group by 1 ". "order by 1 desc "; $status_query = tep_db_query($texto_query); //echo $texto_query; ?> Fatal error: Uncaught Error: Undefined constant "HTML_PARAMS" in /var/www/vhosts/ncm.loading.net/admin1.ncm.loading.net/oc1/procRemesas.php:78 Stack trace: #0 {main} thrown in /var/www/vhosts/ncm.loading.net/admin1.ncm.loading.net/oc1/procRemesas.php on line 78