SELECT vtiger_rutas.rutasid AS 'rutasid',
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_rutas.tiporuta AS 'tiporuta',
vtiger_rutascf.cf_2797 AS 'Operador_Logistico',
vtiger_rutascf.cf_2961 AS 'Regional',
vtiger_rutascf.cf_2902 AS 'tmpRuta',
vtiger_rutasgrouprel.groupname AS 'AsignadoAGrupo',
vtiger_rutascf.cf_2963 AS 'TipoOperacion',
vtiger_rutascf.cf_3487 AS 'UnidadOperacionLogistica',
vtiger_rutascf.cf_3489 AS 'mediooperacion',
vtiger_rutascf.cf_3485 AS 'RutaTipoDistancia',
vtiger_crmentity.createdtime AS 'FechaCreacion',
DATE_FORMAT(vtiger_crmentity.createdtime, '%Y%m') AS `agno_mes`,
DATE_FORMAT(vtiger_crmentity.createdtime, '%Y%m%d') AS `agno_mes_dia`,
yearweek(vtiger_crmentity.createdtime, 0) AS `agno_semana`
JOIN vtiger_rutascf on (vtiger_rutascf.rutasid = vtiger_rutas.rutasid)
WHERE vtiger_crmentity.deleted != 1
ORDER BY vtiger_rutas.nombre_ruta;
|