|
SELECT rutacf.cf_2961 AS Regional,
pac.identificador_paciente AS identificador_paciente,
ac.epsconsolidada AS epsconsolidada,
os.ordenesservicioid AS ordenesservicioid,
os.fecha_orden AS fecha_orden,
os.departamento AS departamento,
os.asunto_orden AS asunto_orden,
os.autorizacion AS autorizacion,
os.numero_orden AS numero_orden,
os.equiposrecoger AS equiposrecoger,
os.paciente AS paciente,
os.estado_orden AS estado_orden,
os.tipo_orden AS tipo_orden,
os.tipo_entrega AS tipo_entrega,
os.equipos_remisionados AS equipos_remisionados,
os.entidadpadrename AS entidadpadrename,
os.horamanual AS horamanual,
os.obsrevision AS obsrevision,
os.fechahoraaviso AS fechahoraaviso,
os.obsprogramacion AS obsprogramacion,
os.obsterminacion AS obsterminacion,
os.ordernew AS ordernew,
os.causasfallida AS causasfallida,
os.razonanulado AS razonanulado,
os.comentarios AS comentarios,
os.obsaudit AS obsaudit,
os.planilla_trabajo AS planilla_trabajo,
os.visita AS visitaid,
os.programacion AS programacion,
emp.razonsocial AS empresa,
pac.docid AS docid,
os.prioridadservicio AS prioridadservicio,
os.horaatndesde AS horaatndesde,
os.horaatnhasta AS horaatnhasta,
os.validaciontiempo AS validaciontiempo,
os.ciudad AS ciudad,
os.formacreacion AS formacreacion,
os.origensolicitud AS origensolicitud,
os.ubicacionpac AS ubicacionpac,
os.estadoauditoria AS estadoauditoria,
us.user_name AS Revisor_Usuario,
us2.user_name AS Auditor_Usuario,
us3.user_name AS Creador_Usuario,
os.fechareal AS fechareal,
crminfo.createdtime AS createdtime,
vtiger_tipo_orden.familia_os AS familia_os,
ubic.localidad AS localidad,
planilla_grouprel.groupname AS groupname_planilla,
ubic.zona AS zona,
os.fecha_auditoria AS fecha_auditoria,
#01 (SELECT vtiger_rutas.nombre_ruta
FROM vtiger_rutas
WHERE (vtiger_rutas.rutasid = rutacf.rutasid)) AS nombreruta,
rutacf.cf_2797 AS OperadorLogistico,
rutacf.cf_2963 AS TipoOperacion,
rutacf.cf_3487 AS UnidadOperacionLogistica,
rutacf.cf_3489 AS MedioOperacion,
vi.visita AS visita,
dayname(os.fecha_orden) AS dia_nombre,
date_format(os.fecha_orden, '%Y%m') AS agno_mes,
date_format(os.fecha_orden, '%Y%m%d') AS agno_mes_dia,
yearweek(os.fecha_orden, 0) AS agno_semana,
vtiger_ordenesserviciocf.cf_1418 AS SubEstadoOS,
os.motivo_anulacion,
vtiger_ordenesserviciocf.cf_3600 AS PeriodoLectura,
vtiger_ordenesserviciocf.cf_3606 AS ClasificacionAdherencia,
vtiger_ordenesserviciocf.cf_3608 AS ClasificacionIAHSegunLectura
LEFT JOIN vtiger_users us3 on((us3.id = crminfo.smcreatorid)))
| 
