select
year(`vtiger_planillastrabajo`.`fecha_fin`) AS `Anno`,
month(`vtiger_planillastrabajo`.`fecha_fin`) AS `MES`,
month(`vtiger_planillastrabajo`.`fecha_fin`) AS `SEMANA`,
weekday(dayofmonth(`vtiger_planillastrabajo`.`fecha_fin`)) AS `NombreDia`,
`vtiger_planillastrabajo`.`camion` AS `camion`,
`vtiger_planillastrabajo`.`planillastrabajoid` AS `planillastrabajoid`,
`vtiger_planillastrabajo`.`identificador` AS `identificador`,
`vtiger_planillastrabajo`.`turno_planilla` AS `turno_planilla`,
`vtiger_planillastrabajo`.`estado_planilla` AS `estado_planilla`,
`vtiger_planillastrabajo`.`fecha_fin` AS `fecha_fin`,
`vtiger_planillastrabajo`.`ruta` AS `ruta`,
`vtiger_planillastrabajo`.`userconductor` AS `userconductor`,
`vtiger_planillastrabajo`.`tipoplanilla` AS `tipoplanilla`,
0 AS `CapacidadProgramada`,
dayname(`vtiger_planillastrabajo`.`fecha_fin`) AS `dia`,
0 AS `VisitasUrgencia`,
0 AS `VisitasNormal`,
0 AS `VisitasEmergencia`,
0 AS `Visitas`,
0 AS `PuntosNormal`,
0 AS `PuntosUrgencia`,
0 AS `Puntos`,
`vtiger_planillastrabajo`.`totalcashreported` AS `totalcashreported`,
`vtiger_planillastrabajo`.`totalcashaudit` AS `totalcashaudit`,
`vtiger_planillastrabajo`.`totalcashrevision` AS `totalcashrevision`,
`vtiger_planillastrabajo`.`recibossinauditar` AS `recibossinauditar`,
`vtiger_planillastrabajo`.`ossinrevisar` AS `ossinrevisar`,
`vtiger_planillastrabajo`.`activoscargados` AS `activoscargados`,
`vtiger_planillastrabajo`.`pendingrecibos` AS `pendingrecibos`,
`vtiger_planillastrabajo`.`pendingorders` AS `pendingorders`,
`vtiger_planillastrabajo`.`equiposcargados` AS `equiposcargados`,
`vtiger_planillastrabajo`.`equiposdescargados` AS `equiposdescargados`,
0 AS `Horas`,
`vtiger_rutascf`.`cf_2797` AS `OperadorLogistico`,
`vtiger_rutascf`.`cf_2961` AS `Regional`,
`vtiger_rutascf`.`cf_2902` AS `tmpRuta`,
`vtiger_rutasgrouprel`.`groupname` AS `GrupoPlanilla`,
`vtiger_rutascf`.`cf_2963` AS `TipoOperacion`,
`vtiger_rutas`.`nombre_ruta` AS `nombre_ruta`,
`vtiger_rutas`.`turno_ruta` AS `turno_ruta`,
`vtiger_rutas`.`estado_ruta` AS `estado_ruta`,
`vtiger_rutas`.`zonas` AS `zonas`,
`vtiger_planillastrabajocf`.`cf_1512` AS `Peajes`,
`vtiger_planillastrabajocf`.`cf_1514` AS `Gasolina`,
`vtiger_planillastrabajocf`.`cf_1520` AS `Recaudo`,
`vtiger_planillastrabajocf`.`cf_1723` AS `Filtros`,
`vtiger_planillastrabajocf`.`cf_1518` AS `KMFin`,
`vtiger_planillastrabajocf`.`cf_1516` AS `KMIni`,
`vtiger_planillastrabajocf`.`cf_1591` AS `HoraIni`,
`vtiger_planillastrabajocf`.`cf_1593` AS `HoraFin`,
`vtiger_empleados`.`identificador_empleado` AS `Conductor`,
`vtiger_empleados_1`.`identificador_empleado` AS `Auxiliar`
from
(
(`vtiger_rutascf` `vtiger_rutascf_1`
join
(
`vtiger_rutas`
join
(
`vtiger_rutascf`
join
(
(`vtiger_empleados`
join
(
`vtiger_planillastrabajocf`
join
`vtiger_planillastrabajo`
on((`vtiger_planillastrabajocf`.`planillastrabajoid` = `vtiger_planillastrabajo`.`planillastrabajoid`))
)
join
`vtiger_empleados` `vtiger_empleados_1`
on((`vtiger_planillastrabajo`.`auxiliarcamion` = `vtiger_empleados_1`.`empleadosid`))
)
)
on((`vtiger_rutas`.`rutasid` = `vtiger_planillastrabajo`.`ruta`))
)
on((`vtiger_rutascf_1`.`rutasid` = `vtiger_planillastrabajo`.`ruta`)))
join
on((`vtiger_planillastrabajo`.`ruta` = `vtiger_rutasgrouprel`.`rutasid`))
)
where
(
(`vtiger_rutas`.`estado_ruta` = 'Activa')
and
(
`vtiger_planillastrabajo`.`fecha_fin` >=
(
curdate() - interval 60 day
)
)
)
order by
`vtiger_rutas`.`nombre_ruta`
|