UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+data.detail_list.[0].arrival_city_name +''-''+(IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.detail_list.[0].flight_segment_number) >  1,''-''+data.detail_list.[0].flight_segment_number,'''')' WHERE FENTRYID IN (1797014402722247682,1859490538894745600);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+data.orders.[0].arrival_city_name +''-''+(IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.orders.[0].flight_segment_number) >  1,''-''+data.orders.[0].flight_segment_number,'''')' WHERE FENTRYID IN (1804291042271422464,1859490364428384256);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].to_city_name' WHERE FENTRYID=1800025760430721060;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+data.detail_list.[0].to_city_name+''-'' +(IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签单'',''G'',''T'')))' WHERE FENTRYID IN (1800025760430721033,1859491147236597760);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+data.orders.[0].to_city_name+''-''+(IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签单'',''G'',''T'')))' WHERE FENTRYID IN (1804382278080651266,1859490858852939776);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].from_city_name' WHERE FENTRYID = 1800025760430721059;
