vw_sellos_rewards

sql

WITH tabla_dias AS (
                 SELECT dia.dia::date AS dia
                   FROM generate_series('2020-10-01'::date::timestamp with time zone, now()::date::timestamp with time zone, '1 day'::interval) dia(dia)
                )
         SELECT td.dia,
            se.id_sello,
            se.fecha_sello,
            se.id_cliente AS cliente_sello,
            se.telefono_cliente AS telef_cliente_sello,
            se.usuario_tap AS usuario_tap_sello,
            se.id_local AS id_local_sello,
            se.nombre_local AS nombre_local_sello,
            NULL::timestamp with time zone AS fecha_reward,
            NULL::integer AS id_reward,
            NULL::integer AS cliente_reward,
            NULL::text AS telef_cliente_reward,
            NULL::integer AS id_local_reward,
            NULL::character varying AS nombre_local_reward,
            NULL::integer AS reward_id,
            NULL::text AS description_reward
           FROM bi.vw_sellos se
             FULL JOIN tabla_dias td ON se.dia_sello::date = td.dia
        UNION
         SELECT td.dia,
            NULL::integer AS fecha_sello,
            NULL::timestamp with time zone AS id_sello,
            NULL::integer AS cliente_sello,
            NULL::text AS telef_cliente_sello,
            NULL::boolean AS usuario_tap_sello,
            NULL::integer AS id_local_sello,
            NULL::character varying AS nombre_local_sello,
            rw.fecha_reward,
            rw.id_reward,
            rw.id_cliente AS cliente_reward,
            rw.telefono_cliente AS telef_cliente_reward,
            rw.id_local AS id_local_reward,
            rw.nombre_local AS nombre_local_reward,
            rw.reward_id,
            rw.description_reward
           FROM bi.vw_rewards rw
             FULL JOIN tabla_dias td ON rw.dia_reward::date = td.dia