Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT tic_cab.fecha,
- COUNT(DISTINCT(tic_cab.ticket_id))::int AS operaciones,
- SUM(tic_lin.unidades)::int AS unidades,
- SUM( (tic_lin.total_linea / nullif((1.0 + (tic_lin.iva::numeric / 100.0)), 0.0))::numeric(20,2) ) AS total,
- SUM( (COALESCE(tic_lin.rentabilidad_oferta, tic_lin.total_linea)
- / nullif((1.0 + (tic_lin.iva::numeric / 100.0)), 0.0))::numeric(20,2) ) AS rent_total
- FROM t001.ticket_cabecera AS tic_cab
- JOIN t001.ticket_linea AS tic_lin ON tic_lin.id_ticket = tic_cab.ticket_id
- JOIN articulo AS art ON art.articulo_id = tic_lin.id_articulo
- JOIN modelo AS mo ON mo.modelo_id = art.id_modelo
- LEFT JOIN (SELECT sdev.id_ticket,
- lin.id_linea
- FROM devolucion_cabecera sdev
- JOIN devolucion_linea lin ON lin.id_devolucion = sdev.devolucion_id
- WHERE sdev.id_tienda = 001
- AND lin.documento_origen_tipo = 'RESERVA') devres ON devres.id_ticket = tic_lin.id_ticket
- AND devres.id_linea = tic_lin.linea_id
- WHERE fecha BETWEEN '2014-05-19' AND '2014-05-19'
- AND devres IS NULL
- GROUP BY tic_cab.fecha
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement