// 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')); } $status_array = array(); /*$texto_query = "select op.products_id,products_name,p.products_weight kgs,sum(op.products_quantity) products_quantity " . "from orders_products op join orders o on op.orders_id=o.orders_id ". "join products p on op.products_id=p.products_id "; */ $texto_query = "select od.product_id products_id,od.product_name products_name, " . "od.product_weight kgs,sum(od.product_quantity) products_quantity ". "from ps_orders o join ps_order_detail od on (o.id_order=od.id_order) ". "join ps_cart dd on (dd.id_cart=o.id_cart) "; if (strlen($_POST['pedidos']) > 0) { $texto_query .="where o.id_order in (".$_POST['pedidos'].") "; } else { $texto_query .="where dd.tramo_date between '" . $_POST['fecIni'] . "' and '" . $_POST['fecFin'] . "' "; } //$texto_query .= " and products_name not like '%GRANDE%' and products_name not like '%FAMILIAR%' "; $texto_query .= "and o.current_state in (2,3,4,5,14,16) "; $texto_query .= "group by 1 order by 2"; $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/procProductosTotales.php:36 Stack trace: #0 {main} thrown in /var/www/vhosts/ncm.loading.net/admin1.ncm.loading.net/procProductosTotales.php on line 36