UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_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'')))' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' ' WHERE FENTRYID = 1804382278080651266;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签'',''G'',''T'') )' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' ' WHERE FENTRYID = 1804382278080651269;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_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'')))' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' ' WHERE FENTRYID = 1859490858852939776;



UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_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'')))' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' ' WHERE FENTRYID = 1800025760430721033;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签'',''G'',''T'') )' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' '  WHERE FENTRYID = 1800025760430721036;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_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'')))' ,FMAPSOURCEFIELDEXT = ' ',FMAPTYPEEXT= ' ', FMAPDESIGNEXT= ' ' WHERE FENTRYID = 1859491147236597760;


UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name+''-''+data.detail_list.[0].to_station_name+''-'' +(IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签'',''G'',''T'')))' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1800025760430721033;
UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name+''-''+data.detail_list.[0].to_station_name+''-'' +(IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签'',''G'',''T'')))' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859491147236597760;
UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name+''-''+data.orders.[0].to_station_name+''-''+(IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签'',''G'',''T'')))' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1804382278080651266;
UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name+''-''+data.orders.[0].to_station_name+''-''+(IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签'',''G'',''T'')))' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859490858852939776;
