Guest User

Untitled

a guest
Jan 11th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. SELECT IFNULL(s.id_servicio,'Total') AS
  2. id_servicio,IFNULL(s.fecha_servicio,'General') AS
  3. fecha_servicio,c.nombre_conductor,c.apellido_conductor,
  4. d.nombre_distrito,u.nombre_urbanizacion,SUM(s.precio) AS
  5. precio,ds.nombre_tipo FROM servicios s
  6. INNER JOIN distrito d ON s.id_distrito = d.id_distrito
  7. INNER JOIN urbanizacion u ON s.id_urbanizacion = u.id_urbanizacion
  8. INNER JOIN conductor c ON s.id_conductor = c.id_conductor
  9. INNER JOIN detalle_servicio ds ON s.tipo_servicio = ds.tipo_servicio
  10. WHERE c.id_conductor = $i_conductor AND s.fecha_servicio BETWEEN
  11. '$i_fecha_inicio_format2' AND '$i_fecha_fin_format2' GROUP BY
  12. s.fecha_servicio,s.id_servicio ASC WITH ROLLUP
  13.  
  14. <https://i.stack.imgur.com/nwk4B.png>
Add Comment
Please, Sign In to add comment