select
flt_no as fltNo,
flt_date as fltDate,
create_pnr_office_id as createPnrOfficeId,
pnr_create_date as pnrCreateDate,
gds,
bkd_cnt as bkdCnt,
tkt_cnt as tktCnt,
rfd_cnt as rfdCnt,
void_cnt as voidCnt,
issue_ratio as issueRatio,
SPLIT_PART(segment, '-', 1) as origin,
SPLIT_PART(segment, '-', 2) as dest
from inter.mid_pnr_waste_seats
where flt_date in('2023-07-22')
and ( exists (select * from inter.mid_bas_rm_dist where inter.mid_bas_rm_dist.valid_start_date<= flt_date and inter.mid_bas_rm_dist.valid_end_date>= flt_date and inter.mid_bas_rm_dist.dep_code=SPLIT_PART(segment, '-', 1) and inter.mid_bas_rm_dist.arr_code= SPLIT_PART(segment, '-', 2) and inter.mid_bas_rm_dist.rm_dist in ('欧洲区' , '测试区' , 'test区1' , '亚洲区' , '俄中东区'))) and SPLIT_PART(segment, '-', 1) in (select dep_code from inter.mid_bas_rm_dist where inter.mid_bas_rm_dist.valid_start_date<= flt_date and inter.mid_bas_rm_dist.valid_end_date>= flt_date and inter.mid_bas_rm_dist.rm_dist in ('欧洲区' , '测试区' , 'test区1' , '亚洲区' , '俄中东区'))and SPLIT_PART(segment, '-', 2) in (select arr_code from inter.mid_bas_rm_dist where inter.mid_bas_rm_dist.valid_start_date<= flt_date and inter.mid_bas_rm_dist.valid_end_date>= flt_date and inter.mid_bas_rm_dist.rm_dist in ('欧洲区' , '测试区' , 'test区1' , '亚洲区' , '俄中东区'))
最新发布