UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'ROUND(NUMBER(orders.[0].mileage) / 1000,2)' WHERE FENTRYID = 1763191162937682955;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'ROUND((orders.[0].enterpriseAmount + orders.[0].personAmount)/100,2)' WHERE FENTRYID = 1763191162937682947;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'ROUND(NUMBER(orders.[0].enterpriseAmount) / 100,2)' WHERE FENTRYID = 1763117404944461827;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'ROUND(NUMBER(orders.[0].personAmount)/100,2)' WHERE FENTRYID = 1763191162937682948;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'orders.[0].amapOrderId +''-''+ IF(STRING(orders.[0].refundItems.[0].refundTime) = '''','''', (REPLACE(SUBSTRING(STRING(orders.[0].refundItems.[0].refundTime), 11,5) ,'':'','''')))' WHERE FENTRYID = 1859492297029541888;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'orders.[0].amapOrderId +''-''+ IF(STRING(orders.[0].refundItems.[0].refundTime) = '''','''', (REPLACE(SUBSTRING(STRING(orders.[0].refundItems.[0].refundTime), 11,5) ,'':'','''')))' WHERE FENTRYID = 1792830743831925762;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = '- orders.[0].refundItems.[0].enterpriseRefundAmount/100 - orders.[0].refundItems.[0].personRefundAmount/100' WHERE FENTRYID = 1792830743831925783;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = '- (orders.[0].refundItems.[0].enterpriseRefundAmount/100)' WHERE FENTRYID = 1792830743831925780;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = '-orders.[0].refundItems.[0].personRefundAmount/100' WHERE FENTRYID = 1792830743831925784;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'ROUND(NUMBER(orders.[0].mileage)  / 1000,2)' WHERE FENTRYID = 1792830743831925791;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'') )' WHERE FENTRYID = 1797014402722247688;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''已出票'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''已改签'',''已退票'') )' WHERE FENTRYID = 1810198097498774530;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) = ''2'', data.detail_list.[0].reason ,'' '')' WHERE FENTRYID = 1828208807789429760;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) = ''1'', data.detail_list.[0].reason ,'' '')' WHERE FENTRYID = 1828208807789429761;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'')))' WHERE FENTRYID = 1859490538894745600;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''40000'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''50302'',''50202'') )' WHERE FENTRYID = 1797014402722247694;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'NUMBER(data.detail_list.[0].ticket_fee_sp)  + NUMBER(data.detail_list.[0].upgrade_cost)' WHERE FENTRYID = 1797014402722247713;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付''  OR STRING(data.detail_list.[0].pay_type)  = ''混合支付''  OR STRING(data.detail_list.[0].pay_type)  = ''企业钱包支付'' ,1,2)' WHERE FENTRYID = 1797014402722247692;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].flight_travel_type) = ''0'',1,2)' WHERE FENTRYID = 1797014402722247689;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].flight_travel_type) = ''0'',2,4)' WHERE FENTRYID = 1797014402722247687;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].upgrade_final_status) = ''1'',''USED'', IF(STRING(data.detail_list.[0].upgrade_final_status) = ''2'',''REFOUND'',''UNUSED'') )' WHERE FENTRYID = 1799384232532282369;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].flight_travel_type) = ''0'',1,2)' WHERE FENTRYID = 1797014402722247690;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'')))' WHERE FENTRYID = 1797014402722247682;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(data.detail_list.[0].discount = ''全价'',100,NUMBER(REPLACE(data.detail_list.[0].discount,''折'','''')) * 10)' WHERE FENTRYID = 1799370088793934850;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].booking_member_number  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1859489987553484800;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1799930397468298285;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付'',1,2)' WHERE FENTRYID = 1799930397468298254;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付'',1,2)' WHERE FENTRYID = 1799930397468298287;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].order_status) =''预订成功'',''已确认'', IF(STRING(data.detail_list.[0].order_status) =''已完成''  OR STRING(data.detail_list.[0].order_status) =''已入住''  OR STRING(data.detail_list.[0].order_status) =''预订未到'',''已离店'', IF(STRING(data.detail_list.[0].order_status) =''已取消预订'',''已退订'','' '') ) )' WHERE FENTRYID = 1829630749532227584;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].booking_member_number  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1799930397468298242;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付'',1,2)' WHERE FENTRYID = 1800025760430721054;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签单'',''G'',''T'')))' 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'') )' WHERE FENTRYID = 1800025760430721036;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付'',1,2)' WHERE FENTRYID = 1800025760430721045;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.detail_list.[0].transaction_type) =''出票'',1, IF(STRING(data.detail_list.[0].transaction_type) =''改签'',2,3) )' WHERE FENTRYID = 1800025760430721046;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(STRING(data.detail_list.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.detail_list.[0].transaction_type)= ''改签单'',''G'',''T'')))' WHERE FENTRYID = 1859491147236597760;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].pay_type)= ''企业支付''  OR STRING(data.orders.[0].pay_type)= ''企业钱包支付''  OR STRING(data.orders.[0].pay_type)= ''混合支付'',''1'',''2'')' WHERE FENTRYID = 1803572580872051732;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].pay_type)= ''企业支付''  OR STRING(data.orders.[0].pay_type)= ''企业钱包支付''  OR STRING(data.orders.[0].pay_type)= ''混合支付'',''1'',''2'')' WHERE FENTRYID = 1803572580872051740;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].booking_member_number  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1803572580872051721;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].booking_member_number  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1859489563417075712;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')' WHERE FENTRYID = 1803572580872051724;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].pay_type)  = ''企业支付''  OR STRING(data.orders.[0].pay_type)  = ''混合支付''  OR STRING(data.orders.[0].pay_type)  = ''企业钱包支付'',1,2)' WHERE FENTRYID = 1804291042271422476;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].pay_type) = ''企业支付'' OR STRING(data.orders.[0].pay_type) =''企业钱包支付'' OR STRING(data.orders.[0].pay_type) =''混合支付'',1,2)' WHERE FENTRYID = 1804291042271422508;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].discount) = ''全价'',100,NUMBER(REPLACE(STRING(data.orders.[0].discount),''折'','''')) * 10)' WHERE FENTRYID = 1804291042271422497;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'NUMBER(data.orders.[0].ticket_fee_sp)  + NUMBER(data.orders.[0].upgrade_cost)' WHERE FENTRYID = 1804291042271422499;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].transaction_type) = ''0'',40000, IF(STRING(data.orders.[0].transaction_type) = ''1'',50302,50202) )' WHERE FENTRYID = 1804291042271422477;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].upgrade_final_status) = ''1'',''USED'', IF(STRING(data.orders.[0].upgrade_final_status) = ''2'',''REFOUND'',''UNUSED'') )' WHERE FENTRYID = 1804291042271422478;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'') )' WHERE FENTRYID = 1804291042271422507;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'')))' WHERE FENTRYID = 1859490364428384256;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].flight_travel_type) = ''0'',1,2)' WHERE FENTRYID = 1804291042271422475;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'')))' WHERE FENTRYID = 1804291042271422464;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].flight_travel_type) = ''0'',2,4)' WHERE FENTRYID = 1804291042271422474;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签单'',''G'',''T'')))' WHERE FENTRYID = 1804382278080651266;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签单'',''G'',''T'')))' WHERE FENTRYID = 1859490858852939776;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].transaction_type)= ''出票'',''O'',  IF(STRING(data.orders.[0].transaction_type)= ''改签单'',''G'',''T'') )' WHERE FENTRYID = 1804382278080651269;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].transaction_type) =''出票'',1, IF(STRING(data.orders.[0].transaction_type) =''改签'',2,3) )' WHERE FENTRYID = 1804382278080651278;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF(STRING(data.orders.[0].pay_type)  = ''企业支付'',1,2)' WHERE FENTRYID = 1804382278080651277;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF( STRING(data.[0].isApprove) =  ''0'',''0'',''1'')' WHERE FENTRYID = 1888630328688838662;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''202'' ,''2'', IF(STRING(data.list.[0].sub_bill_summary.[0].business_type)=''205'',''4'', IF(STRING(data.list.[0].sub_bill_summary.[0].business_type)=''201'',''1'', IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''204'',''5'', IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''203'',''6'','''') ) )  ) )' WHERE FENTRYID = 1915319632911577088;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN = 'IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''202'',''er_planecheckingbill'', IF(STRING(data.list.[0].sub_bill_summary.[0].business_type)=''205'',''er_planecheckingbill'', IF(STRING(data.list.[0].sub_bill_summary.[0].business_type)=''201'',''er_hotelcheckingbill'', IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''204'',''er_hotelcheckingbill'', IF( STRING(data.list.[0].sub_bill_summary.[0].business_type)=''203'',''er_traincheckingbill'','''') ) )  ) )' WHERE FENTRYID = 1915874160450946048;
