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].check_in_names  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1799930397468298242;
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].check_in_names  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859489987553484800;
UPDATE t_er_trip_fieldmapentry SET fmapsourcefield='data.detail_list.[0].check_in_names',fmaptype='1',fmapdesign=' ' WHERE FEntryId=1799930397468298290;


UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].check_in_names  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')'  ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' '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].check_in_names  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859489563417075712;
UPDATE t_er_trip_fieldmapentry SET fmapsourcefield='data.orders.[0].check_in_names',fmaptype='1',fmapdesign=' ' WHERE FEntryId=1803572580872051744;