|
SELECT `visitas`.`visitasid` AS `visitasid`,
`visitas`.`consecutivoempresa` AS `consecutivoempresa`,
`visitas`.`visita` AS `visita`,
`emp`.`razonsocial` AS `razonsocial`,
`visitas`.`paciente` AS `paciente`,
`visitas`.`programacion` AS `programacion`,
`visitas`.`origensolicitud` AS `origensolicitud`,
`visitas`.`estadovisita` AS `estadovisita`,
`visitas`.`docsolicitante` AS `docsolicitante`,
`visitas`.`tipo_entrega` AS `tipo_entrega`,
`visitas`.`planilla_trabajo` AS `planilla_trabajo`,
`visitas`.`recaudofinal` AS `recaudofinal`,
`visitasrel`.`groupname` AS `groupname`,
`visitas`.`fechavisita` AS `fechavisita`,
`visitas`.`tipo_visita` AS `tipo_visita`,
`crminfo`.`createdtime` AS `createdtime`,
date_format(`visitas`.`fechavisita`, '%Y%m') AS `agno_mes`,
date_format(`visitas`.`fechavisita`, '%Y%m%d') AS `agno_mes_dia`,
yearweek(`visitas`.`fechavisita`, 0) AS `agno_semana`,
dayname(`visitas`.`fechavisita`) AS `dia_nombre`,
`rutacf`.`cf_2961` AS `regional`,
`planillasrel`.`groupname` AS `groupnameplanilla`,
`visitas`.`nombreentidad` AS `entidadpadrename`,
`visitas`.`sucursal` AS `sucursal`,
`vtiger_account`.`epsconsolidada` AS `eps_Consolidada`,
`visitas`.`formacreacion` AS `formacreacion`,
`visitas`.`tipofirma` AS `tipofirma`,
`ruta`.`nombre_ruta` AS `nombre_ruta`,
`rutacf`.`cf_2797` AS `OperadorLogistico`,
`rutacf`.`cf_2963` AS `TipoOperacion`,
`rutacf`.`cf_3487` AS `UnidadOperacionLogistica`,
`rutacf`.`cf_3489` AS `MedioOperacion`,
`visitas`.`departamento` AS `departamento`,
`visitas`.`ciudad` AS `ciudad`,
`visitas`.`observacionvisita` AS `observacionvisita`,
`visitas`.`cf_1418` AS `MotivoFallida`,
`visitas`.`comenfallida` AS `comenfallida`,
`vtiger_pacientesii`.`identificador_paciente` AS `identificador_paciente`,
`vtiger_users`.`user_name` AS `creado_porusuario`,
`ubic`.`localidad` AS `localidad`,
`planilla`. `identificador`
LEFT JOIN ` vtiger_planillastrabajo` `planilla` on((`planilla`.`planillastrabajoid` = `visitas`.`planilla_trabajo`))) LEFT JOIN ` vtiger_rutascf` `rutacf` on((`planilla`.`ruta` = `rutacf`.`rutasid`))) LEFT JOIN ` vtiger_empresas` `emp` on((`visitas`.`empresa` = `emp`.`empresasid`))) LEFT JOIN ` vtiger_crmentity` `crminfo` on((`visitas`.`visitasid` = `crminfo`.`crmid`))) LEFT JOIN ` vtiger_rutas` `ruta` on((`rutacf`.`rutasid` = `ruta`.`rutasid`))) LEFT JOIN ` vtiger_pacientesii` on((`vtiger_pacientesii`.`pacientesiiid` = `visitas`.`paciente`))) LEFT JOIN ` vtiger_account` on((`vtiger_pacientesii`.`accountid` = `vtiger_account`.`accountid`))) LEFT JOIN ` vtiger_users` on((`vtiger_users`.`id` = `crminfo`.`smcreatorid`))) WHERE (`visitas`.`fechavisita` >= (curdate() - interval 90 DAY))
| 
