a:38:{s:6:"_token";s:40:"XDRr5T5rjL5zhI4k3YeANHvm0B3AavoGgA3Nmsm6";s:14:"dominio_prueba";s:5:"adama";s:16:"GrupoEmpresarial";i:1;s:6:"folder";s:6:"adama2";s:7:"dominio";s:5:"adama";s:6:"colorp";s:7:"#15803D";s:6:"colors";s:7:"#1f8d44";s:11:"websystemid";s:21:"8020193394,9000898257";s:10:"websimexid";s:3:"251";s:17:"filtro_contenedor";s:17:"graf_docontenedor";s:18:"mostrar_completado";s:2:"NO";s:15:"info_contenedor";s:2:"SI";s:10:"agrupacion";s:50:"GROUP BY PO.pedido, PO.numero_do, po_detalle.id ";s:13:"agrupacion_ex";s:43:"GROUP BY ex_po.consecutivo,ex_po.numero_do";s:12:"ordenamiento";s:22:"ORDER BY ex_po.id DESC";s:5:"orden";s:0:"";s:18:"columnas_a_mostrar";s:45:"fecha_descargue,fecha_retiro,fecha_devolucion";s:8:"timeline";s:4:"DESC";s:12:"filtro_oc_ws";N;s:12:"razon_social";s:5:"ADAMA";s:13:"campo_cliente";s:2:"SI";s:13:"ocultar_campo";s:2:"NO";s:14:"grafica_global";s:2:"NO";s:5:"color";s:5:"green";s:8:"segmento";i:0;s:15:"titulo_segmento";N;s:18:"control_contenedor";s:7:"[1,2,3]";s:25:"arribo_control_contenedor";i:1;s:20:"arribo_control_desde";N;s:10:"es_tercero";i:0;s:17:"companias_tercero";N;s:9:"companias";a:2:{i:0;i:251;i:1;i:632;}s:9:"_previous";a:1:{s:3:"url";s:38:"https://asercol.asercolgroup.com/rexpo";}s:6:"_flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}s:50:"login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d";i:267;s:4:"auth";a:1:{s:21:"password_confirmed_at";i:1793286612;}s:7:"ExSQLPO";s:22254:"Select ex_po.id, ex_po.consecutivo as numped, ex_po.notificaciones,(CASE when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 169)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)=0 AND ex_po.numero_do <> '' AND NOT EXISTS (SELECT 1 FROM ex_actividad a WHERE a.id_po = ex_po.id AND a.id_etapa IN (90, 20) AND a.inactivo = 0) then 'FCF55E' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=1)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 1)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)=0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 AND (ex_po.numero_do = "" OR ex_po.numero_do IS NULL ) then 'CFE85B' WHEN (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then '81DAF5' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 2)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'FF8000' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=177)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 177)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then '29F79C' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 178)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 -- AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then '95FC5E' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=20)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 20)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then 'D8D8D8' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 175)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'FAA3AC' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 164)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=5) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'FAFCAC' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 5)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'F78C72' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 176)<=NOW() AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then '72F794' END) AS COLOR,GROUP_CONCAT(DISTINCT (CASE when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 169)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)=0 AND ex_po.numero_do <> '' AND NOT EXISTS (SELECT 1 FROM ex_actividad a WHERE a.id_po = ex_po.id AND a.id_etapa IN (90, 20) AND a.inactivo = 0) then 'ENVIO DE BL' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=1)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 1)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)=0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 AND (ex_po.numero_do = "" OR ex_po.numero_do IS NULL ) then 'ORDEN DE CARGUE' WHEN (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then 'INGRESO A PLANTA VACIO' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 2)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'RESERVA CONFIRMADA' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=177)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 177)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then 'ELABORACION BL' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 178)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 -- AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then 'ENVIO DGD' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=20)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 20)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then 'ENVIO DOCUMENTOS AL CLIENTE' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 175)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'OC CON FLETES' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 164)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=5) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'OE CON DO' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 5)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'RESERVA SOLICITADA' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 176)<=NOW() AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'SOLICITUD INGRESO VACIO' END)) AS STATUS,po as ORDEN_DE_CARGUE,ex_po.numero_do as DO,ex_pais.nombre as PAIS_DESTINO,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=21) AS ZARPE_ESTIMADA,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=5) AS SOLICITUD_BOOKING,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=2) AS BOOKING_CONFIRMADO,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=90) AS Zarpe_Motonave,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=20) AS DOCUMENTOS_CLIENTES,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=17) AS ETA FROM ex_po left join ex_cliente on ex_cliente.id = ex_po.IdSupplier left join ex_incoterms on ex_incoterms.id = ex_po.IdIncoterms left join ex_moneda on ex_moneda.id = ex_po.IdMoneda left join ex_compania on ex_compania.id = ex_po.id_compania left join ex_puertos on ex_puertos.id = ex_po.IdPuertoOrigen left join ex_puertos ex_puertosd on ex_puertosd.id = ex_po.IdPuertoDestino left join ex_pais on ex_pais.id = ex_po.IdPaisOrigen left join ex_consegnee on ex_consegnee.id = ex_po.id_consegnee left join ex_linea on ex_linea.id = ex_po.IdLinea LEFT JOIN ex_po_contenedor ON ex_po_contenedor.id_po = ex_po.id /* LEFT JOIN ex_po_detalle ON ex_po_detalle.id_contenedor = ex_po_contenedor.id */ LEFT JOIN ex_terminales ON ex_terminales.id = ex_po.IdTerminal Where ex_po.id_grupo_empresarial=1 AND ex_po.inactivo <> 1 AND (SELECT COUNT(*) FROM ex_actividad a where a.id_po = ex_po.id AND a.id_etapa=90)=0 GROUP BY ex_po.consecutivo , ex_po.numero_do ORDER BY ex_po.id DESC";s:10:"ExSQLPOFIL";s:14028:"Select GROUP_CONCAT(DISTINCT (CASE when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 169)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)=0 AND ex_po.numero_do <> '' AND NOT EXISTS (SELECT 1 FROM ex_actividad a WHERE a.id_po = ex_po.id AND a.id_etapa IN (90, 20) AND a.inactivo = 0) then 'ENVIO DE BL' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=1)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 1)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)=0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 AND (ex_po.numero_do = "" OR ex_po.numero_do IS NULL ) then 'ORDEN DE CARGUE' WHEN (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then 'INGRESO A PLANTA VACIO' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 2)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'RESERVA CONFIRMADA' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=177)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 177)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=169)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then 'ELABORACION BL' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=178)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 178)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 AND (SELECT COUNT(*) FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa=90) = 0 -- AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL then 'ENVIO DGD' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=20)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 20)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=90)=0 AND (ex_po.numero_do <> "" OR ex_po.numero_do IS NOT NULL) /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NOT NULL */ then 'ENVIO DOCUMENTOS AL CLIENTE' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 175)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'OC CON FLETES' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=164)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 164)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=175)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=5) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=2) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'OE CON DO' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=5)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 5)<=NOW() AND (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=2)=0 AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=176) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'RESERVA SOLICITADA' when (SELECT COUNT(*) FROM ex_actividad a where ex_po.id=a.id_po AND a.id_etapa=176)>0 AND (SELECT Fecha FROM ex_actividad a WHERE a.inactivo<>1 and a.id_po=ex_po.id AND a.id_etapa= 176)<=NOW() AND (ex_po.numero_do <> "" AND ex_po.numero_do IS NOT NULL) AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=177) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=169)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=178)= 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=90) = 0 AND(SELECT COUNT(*) FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=20)= 0 /* AND (SELECT max(ec.fecha_ingreso_vacio) as Fecha_ingreso_vacio FROM ex_po ep LEFT JOIN ex_po_contenedor ec ON ec.id_po = ep.id WHERE ec.id_grupo_empresarial = 1 AND ep.po = ex_po.po) IS NULL */ then 'SOLICITUD INGRESO VACIO' END)) AS STATUS,fecha_po as FECHA_ORDEN,po as ORDEN_DE_CARGUE,consecutivo as PEDIDO_CLIENTE,ex_po.numero_do as DO,ex_consegnee.nombre as CONSIGNATARIO,ex_consegnee.direccion as DIRECCION_CONSIGNATARIO,MONTHNAME((SELECT a.fecha FROM ex_actividad a WHERE a.id_po =ex_po.id AND a.inactivo=0 AND a.id_etapa=17)) as MES,ex_pais.nombre as PAIS_DESTINO,(SELECT ttransito FROM ex_tarifas tar WHERE tar.id_origen = ex_po.IdPuertoOrigen and tar.id_pais= ex_po.IdPaisOrigen LIMIT 1 ) as TIEMPO_DE_TRANSITO,ex_material.pg as PG,ex_po_contenedor.contenedor as CONTENEDOR,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=21) AS ZARPE_ESTIMADA,ex_po_contenedor.tamano as TAMAÑO,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=5) AS SOLICITUD_BOOKING,ex_material.codigo as CODIGO,ex_material.nombre as MATERIAL,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=2) AS BOOKING_CONFIRMADO,ex_po_detalle.unidades as UNIDADES,ex_po_detalle.bulto as BULTO,ex_po_detalle.peso_neto as PESO_NETO,ex_material.un as UN,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=90) AS Zarpe_Motonave,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=20) AS DOCUMENTOS_CLIENTES,(SELECT fecha FROM ex_actividad act WHERE act.id_po= ex_po.id AND act.id_etapa=17) AS ETA,ex_po_detalle.can_real as UNIDADES_DESPACHADAS,ex_po_detalle.pallet as PALLET,ex_po_detalle.peso_bruto as PESO_BRUTO,ex_po_detalle.presentacion as PRESENTACION,ex_material.imo as IMO,ex_po_contenedor.sello as SELLOS FROM ex_po left join ex_cliente on ex_cliente.id = ex_po.IdSupplier left join ex_incoterms on ex_incoterms.id = ex_po.IdIncoterms left join ex_moneda on ex_moneda.id = ex_po.IdMoneda left join ex_compania on ex_compania.id = ex_po.id_compania left join ex_puertos on ex_puertos.id = ex_po.IdPuertoOrigen left join ex_puertos ex_puertosd on ex_puertosd.id = ex_po.IdPuertoDestino left join ex_pais on ex_pais.id = ex_po.IdPaisOrigen left join ex_consegnee on ex_consegnee.id = ex_po.id_consegnee left join ex_linea on ex_linea.id = ex_po.IdLinea LEFT JOIN ex_po_contenedor ON ex_po_contenedor.id_po = ex_po.id /* LEFT JOIN ex_po_detalle ON ex_po_detalle.id_contenedor = ex_po_contenedor.id */ LEFT JOIN ex_terminales ON ex_terminales.id = ex_po.IdTerminal left join ex_po_lotes ON ex_po_lotes.id_ex_po_contenedor = ex_po_contenedor.id LEFT JOIN ex_po_detalle ON ex_po_detalle.id_contenedor = ex_po_contenedor.id left join ex_material ON ex_material.id = ex_po_detalle.id_material left join asercolg_estadisticas.graf_datos ON graf_datos.numero_do = ex_po.numero_do left join asercolg_estadisticas.graf_transportadores ON graf_transportadores.codigo_transportador = graf_datos.codigo_transportador left join asercolg_estadisticas.graf_paises ON graf_paises.codigo_pais = graf_datos.procedencia left join asercolg_estadisticas.graf_docontenedor ON graf_docontenedor.numero_do = ex_po.numero_do Where ex_po.id_grupo_empresarial=1 AND ex_po.inactivo <> 1 AND (SELECT COUNT(*) FROM ex_actividad a where a.id_po = ex_po.id AND a.id_etapa=90)=0 GROUP BY ex_po.consecutivo , ex_po.numero_do ORDER BY ex_po.id DESC";}