output_presenter.py 116 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741
  1. import json
  2. import logging
  3. import math
  4. from urllib.parse import urlparse
  5. from constants import DEVICE_INVALID_MESSAGE
  6. logger = logging.getLogger(__name__)
  7. # Builds AI-safe MCP results for the explicitly supported tool set.
  8. class OutputPresenter:
  9. TABLE_TOOLS = frozenset((
  10. 'query_order_exact',
  11. 'query_track',
  12. 'query_customs_declaration_files',
  13. 'query_outbound_list',
  14. 'query_customer_list',
  15. ))
  16. PAYMENT_FOLLOWUP_TOOLS = frozenset(('query_customer_payment_followup',))
  17. PAYMENT_DETAIL_TOOLS = frozenset((
  18. 'query_customer_unverified_bill_details',
  19. ))
  20. PAYMENT_RECORD_TOOLS = frozenset(('query_customer_payment_records',))
  21. RECEIVABLE_COST_TOOLS = frozenset((
  22. 'query_order_receivable_cost_details',
  23. ))
  24. RECEIVABLE_LIST_TOOLS = frozenset(('query_receivable_cost_list',))
  25. RECEIVABLE_FILTER_TOOLS = frozenset((
  26. 'list_receivable_cost_filter_options',
  27. ))
  28. PAYABLE_COST_TOOLS = frozenset(('query_payable_cost_list',))
  29. PAYABLE_FILTER_TOOLS = frozenset(('list_payable_cost_filter_options',))
  30. PAYABLE_EXPORT_TOOLS = frozenset(('export_payable_cost_list',))
  31. DESTINATION_TRAILER_TOOLS = frozenset(('query_destination_trailer_list',))
  32. ORDER_ABNORMAL_TOOLS = frozenset(('query_order_abnormal_list',))
  33. RECEIVE_VOLUME_TOOLS = frozenset(('query_receive_volume_list',))
  34. GOODS_INFO_TOOLS = frozenset(('query_goods_info',))
  35. GOODS_TAX_TOOLS = frozenset(('trial_goods_tax',))
  36. CONTAINER_TIMELINESS_TOOLS = frozenset(('query_container_timeliness_list',))
  37. HEADHAUL_DOCUMENT_TOOLS = frozenset(('query_headhaul_document_list',))
  38. HEADHAUL_PREPARE_TOOLS = frozenset(('prepare_headhaul_document_upload',))
  39. HEADHAUL_SAVE_TOOLS = frozenset(('save_headhaul_document',))
  40. HEADHAUL_DELETE_TOOLS = frozenset(('delete_headhaul_document',))
  41. FREIGHTOWER_TRACK_TOOLS = frozenset(('query_freightower_track',))
  42. DETAIL_TOOLS = frozenset(('query_outbound_detail',))
  43. ORDER_DETAIL_TOOLS = frozenset(('query_order_detail',))
  44. OPTION_TOOLS = frozenset((
  45. 'list_order_filter_options',
  46. 'list_outbound_filter_options',
  47. 'list_pending_outbound_export_filter_options',
  48. 'list_customer_filter_options',
  49. 'list_destination_trailer_filter_options',
  50. 'list_order_abnormal_filter_options',
  51. 'list_receive_volume_filter_options',
  52. 'list_headhaul_document_filter_options',
  53. ))
  54. EXPORT_TOOLS = frozenset((
  55. 'export_pending_outbound_orders',
  56. 'export_out_of_province_port_data',
  57. 'export_receivable_cost_list',
  58. 'export_pallet_data',
  59. 'export_container_timeliness_report',
  60. ))
  61. TASK_TOOLS = frozenset(('query_export_task',))
  62. SAFE_TOOLS = (
  63. TABLE_TOOLS | DETAIL_TOOLS | ORDER_DETAIL_TOOLS | PAYMENT_FOLLOWUP_TOOLS
  64. | PAYMENT_DETAIL_TOOLS | PAYMENT_RECORD_TOOLS | RECEIVABLE_COST_TOOLS
  65. | RECEIVABLE_LIST_TOOLS | RECEIVABLE_FILTER_TOOLS
  66. | PAYABLE_COST_TOOLS | PAYABLE_FILTER_TOOLS | PAYABLE_EXPORT_TOOLS
  67. | DESTINATION_TRAILER_TOOLS
  68. | ORDER_ABNORMAL_TOOLS
  69. | RECEIVE_VOLUME_TOOLS
  70. | GOODS_INFO_TOOLS
  71. | GOODS_TAX_TOOLS
  72. | CONTAINER_TIMELINESS_TOOLS
  73. | HEADHAUL_DOCUMENT_TOOLS
  74. | HEADHAUL_PREPARE_TOOLS
  75. | HEADHAUL_SAVE_TOOLS
  76. | HEADHAUL_DELETE_TOOLS
  77. | FREIGHTOWER_TRACK_TOOLS
  78. | OPTION_TOOLS | EXPORT_TOOLS | TASK_TOOLS
  79. )
  80. ORDER_DETAIL_SECTIONS = {
  81. 'overview': '订单概览',
  82. 'packages': '箱单信息',
  83. 'package_items': '箱单商品',
  84. 'dw_auth': 'DW授权信息',
  85. 'attachments': '附件信息',
  86. 'inbound': '入库信息',
  87. 'checks': '查验信息',
  88. 'tracks': '订单轨迹',
  89. 'operation_logs': '操作日志',
  90. 'cost_logs': '应收与结算日志',
  91. 'delivery': '派送信息',
  92. 'all': '全部',
  93. }
  94. ORDER_DETAIL_FIELDS = {
  95. 'overview': {
  96. 'order_info': {
  97. 'order_number': '订单号', 'reference_number': '客户参考号',
  98. 'customer_name': '客户名称', 'departure_country': '起运国',
  99. 'destination_country': '目的国', 'package_method': '包装类型',
  100. 'product_name': '物流产品', 'forecast_pwv': '预报件重体',
  101. 'inbound_pwv': '入库件重体',
  102. 'receivable_charge_weight': '应收计费重/体积',
  103. 'settlement_charge_weight': '结算计费重/体积',
  104. 'declaration_type': '报关类型', 'pre_recording': '是否需要预录单',
  105. 'idcard_name': '企业/个人姓名',
  106. 'idcard_number': '社会信用代码/身份证号',
  107. 'outbound_number': '排舱单号', 'container_mode': '直送柜/拼柜',
  108. 'track_map_available': '是否可查看轨迹地图', 'insurance': '购买保险',
  109. 'delivery_way': '派送方式', 'return_shipping_surcharge': '退运附加',
  110. 'work_order_count': '工单数量', 'bill_remark': '账单备注',
  111. 'remark': '订单备注',
  112. },
  113. 'freight_info': {
  114. 'estimated_inbound_time': '预计入库时间', 'cargo_type': '货物类型',
  115. 'pickup_way': '交货方式', 'warehouse': '交货仓库',
  116. 'pickup_address': '提货地址', 'pickup_contact': '提货联系人',
  117. 'pickup_phone': '提货联系电话', 'delivery_type': '派送类型',
  118. 'delivery_address': '派送地址', 'delivery_remark': '派送备注',
  119. 'oversea_warehouse': '海外仓',
  120. },
  121. 'package_summary': {
  122. 'box_count': '箱数', 'total_weight': '重量', 'weight_unit': '重量单位',
  123. 'total_volume': '体积', 'sku_count': 'SKU数量',
  124. 'clearance_total_price': '清关总价', 'clearance_currency': '清关币种',
  125. 'purchase_total_price': '采购总价', 'purchase_currency': '采购币种',
  126. },
  127. 'trader_info': {
  128. 'exporter': '出口商', 'importer': '进口商',
  129. 'coo_required': '是否做产地证',
  130. },
  131. },
  132. 'packages': {
  133. 'shipment_id': 'SHIPMENT ID', 'reference_id': 'REFERENCE ID',
  134. 'sku_summary': 'SKU', 'product_name_summary': '商品名',
  135. 'box_quantity': '箱数', 'box_length_cm': '单箱长(CM)',
  136. 'box_width_cm': '单箱宽(CM)', 'box_height_cm': '单箱高(CM)',
  137. 'gross_weight_kg': '单箱毛重量(KG)', 'net_weight_kg': '单箱净重量(KG)',
  138. 'is_over_length': '长度是否超限', 'is_over_width': '宽度是否超限',
  139. 'is_over_height': '高度是否超限', 'is_over_weight': '重量是否超限',
  140. },
  141. 'package_items': {
  142. 'shipment_id': 'SHIPMENT ID', 'reference_id': 'REFERENCE ID',
  143. 'box_specification': '箱规', 'box_specification_unit': '箱规单位',
  144. 'package_gross_weight_kg': '箱单单箱毛重(KG)',
  145. 'package_net_weight_kg': '箱单单箱净重(KG)',
  146. 'inspection_result': '查验结果', 'exception_reason': '异常原因',
  147. 'inspection_photo_count': '查验图片数量', 'sku': 'SKU',
  148. 'units_per_box': '单箱个数', 'declaration_type': '报关类型',
  149. 'box_number': '箱号', 'item_gross_weight_kg': '商品单箱毛重量(KG)',
  150. 'item_net_weight_kg': '商品单箱净重量(KG)', 'chinese_name': '中文品名',
  151. 'english_name': '英文名称', 'brand_type': '品牌类型', 'brand': '品牌',
  152. 'model': '型号', 'material_cn': '材质(CN)', 'material_en': '材质(EN)',
  153. 'purpose_cn': '用途', 'goods_attributes': '商品属性',
  154. 'declaration_hs_code': '报关编码', 'clearance_hs_code': '清关编码',
  155. 'material_ratio': '材质占比', 'clearance_unit_price': '清关单价',
  156. 'clearance_currency': '清关币种', 'purchase_unit_price': '采购单价',
  157. 'purchase_currency': '采购币种', 'product_image_count': '商品图片数量',
  158. 'remark': '备注',
  159. },
  160. 'dw_auth': {
  161. 'fba_id': 'FBAID', 'dw_start': 'DW开始时间', 'dw_end': 'DW结束时间',
  162. 'dw_display': 'DW', 'authorization_status': '客户授权状态',
  163. },
  164. 'attachments': {
  165. 'category': '附件分类', 'file_name': '文件名称',
  166. 'file_extension': '文件类型', 'is_image': '是否图片',
  167. 'preview_url': '预览链接', 'download_url': '下载链接',
  168. 'cost_name': '收费项目',
  169. },
  170. 'inbound_summary': {
  171. 'inbound_status': '入库状态', 'inbound_time': '入库时间',
  172. 'inbound_operator': '操作人', 'warehouse': '仓库',
  173. 'abnormal_reason': '异常原因', 'inbound_photo_count': '入库图片数量',
  174. 'forecast_pwv_summary': '预报件重体', 'inbound_pwv_summary': '入库件重体',
  175. },
  176. 'inbound': {
  177. 'has_label': '是否贴标', 'shipment_id': 'SHIPMENT ID',
  178. 'inbound_quantity': '入库件数',
  179. 'measurement_photo_count': '测量图片数量',
  180. 'box_specification': '入库箱规', 'weight_mode': None, 'weight': None,
  181. 'weight_unit': '重量单位', 'is_over_length': '长度是否超限',
  182. 'is_over_width': '宽度是否超限', 'is_over_height': '高度是否超限',
  183. 'is_over_weight': '重量是否超限', 'operated_at': '操作时间',
  184. },
  185. 'checks': {
  186. 'shipment_id': '货件编号', 'sku': 'SKU', 'box_number': '箱号',
  187. 'box_quantity': '箱数', 'box_specification': '箱规',
  188. 'inspection_result': '查验结果',
  189. 'inspection_photo_count': '查验图片数量', 'remark': '备注',
  190. 'inspector': '查验人', 'inspected_at': '查验时间',
  191. },
  192. 'tracks': {
  193. 'track_type': '轨迹类型', 'status': '轨迹节点', 'location': '轨迹地点',
  194. 'occurred_at': '时间', 'tracking_number': '跟踪号',
  195. 'shipment_id': 'SHIPMENT ID', 'content': '轨迹内容',
  196. },
  197. 'operation_logs': {
  198. 'operated_at': '操作时间', 'content': '操作内容', 'operator': '操作人',
  199. },
  200. 'cost_logs': {
  201. 'operated_at': '操作时间', 'content': '操作内容', 'operator': '操作人',
  202. },
  203. 'delivery_summary': {
  204. 'master_tracking_number': '主跟踪号', 'sub_order_count': '子单数量',
  205. },
  206. 'delivery': {'sub_tracking_number': '子跟踪号'},
  207. }
  208. ORDER_DETAIL_STATUS_FIELDS = {
  209. 'stage': '阶段', 'label': '节点', 'state': '状态',
  210. 'occurred_at': '时间', 'time_kind': '时间类型',
  211. }
  212. ORDER_DETAIL_STATES = {
  213. 'completed': '已完成', 'in_progress': '进行中',
  214. 'pending': '待完成', 'hidden': '不展示',
  215. }
  216. ORDER_DETAIL_TIME_KINDS = {
  217. 'actual': '实际', 'estimated': '预计', 'empty': '暂无',
  218. }
  219. TABLE_COLUMNS = {
  220. 'query_order_exact': {
  221. 'order_number': ('订单号',),
  222. 'reference_number': ('客户参考号',),
  223. 'status_txt_name': ('状态',),
  224. 'check_status_txt_name': ('是否已查验',),
  225. 'customer_name': ('客户名称',),
  226. 'customer_account_type_name': ('客户属性',),
  227. 'inbound_date': ('入库时间',),
  228. 'wo_num': ('未完成工单',),
  229. 'product_name': ('物流产品',),
  230. 'inbound_pieces': ('件数',),
  231. 'inbound_volume': ('体积(CBM)',),
  232. 'inbound_weight': ('重量(KG)',),
  233. 'pro_cn_name': ('品名',),
  234. 'export_declaration_type': ('报关方式',),
  235. 'merge_declare_number': ('合并报关单号',),
  236. 'delivery_address': ('派送地址',),
  237. 'container_code': ('柜号',),
  238. 'out_status_txt': ('排舱单状态',),
  239. 'hinge_of_destination': ('目的港',),
  240. 'etd': ('ETD',),
  241. 'atd': ('ATD',),
  242. 'eta': ('ETA',),
  243. 'ata': ('ATA',),
  244. 'release_time': ('清关放行时间',),
  245. 'oversea_inbound_date': ('海外入库时间',),
  246. 'appt_time': ('APPT时间',),
  247. 'est_loading_time': ('预计装柜时间',),
  248. 'pickup_time': ('海外提柜时间',),
  249. 'delivery_way_title': ('派送方式',),
  250. 'tracking_number': ('快递单号', '承运商跟踪号码'),
  251. 'shipment_id': ('Shipment ID',),
  252. 'goods_attribute': ('商品属性',),
  253. 'sku': ('SKU',),
  254. 'sales_user': ('商务经理',),
  255. 'service_user': ('客户经理',),
  256. 'department_name': ('事业部',),
  257. 'remark': ('订单备注',),
  258. 'importer_name': ('进口商',),
  259. 'warehouse_name': ('交货仓库',),
  260. 'paid_status_name': ('付款状态',),
  261. },
  262. 'query_track': {
  263. 'status': ('轨迹节点', '轨迹状态,如:开始集港、离港放行、清关、配送等'),
  264. 'location': ('轨迹地点', '发生地点'),
  265. 'time': ('时间', '轨迹发生时间(已转换为用户时区)'),
  266. 'content': ('轨迹内容', '详细描述'),
  267. 'tracking_number': ('跟踪号', '快递单号'),
  268. 'shipment_id': ('Shipment ID', '包裹ID'),
  269. },
  270. 'query_customs_declaration_files': {
  271. 'outbound_number': ('排舱单号',),
  272. 'order_number': ('订单号',),
  273. 'file_name': ('文件名',),
  274. 'file_type': ('文件类型',),
  275. 'file_url': ('文件链接',),
  276. },
  277. 'query_outbound_list': {
  278. 'outbound_number': ('排舱单号',),
  279. 'direct_send': ('直送柜',),
  280. 'remark': ('备注',),
  281. 'cargo_type': ('超长超重',),
  282. 'warehouse_name': ('集货仓库',),
  283. 'status': ('状态',),
  284. 'so_number': ('SO号',),
  285. 'container_code': ('柜号',),
  286. 'seal_number': ('封条号',),
  287. 'container_type': ('柜型',),
  288. 'cabinet_type': ('整拼类型',),
  289. 'shipping_method': ('运输方式',),
  290. 'total_volume': ('体积(CBM)',),
  291. 'total_weight': ('重量(KG)',),
  292. 'ship_schedule': ('船期',),
  293. 'closing_time': ('截关时间',),
  294. 'est_loading_time': ('预计装柜时间',),
  295. 'operator': ('操作人',),
  296. 'operation_modes': ('拖报清方式',),
  297. 'handle_method': ('操作方式',),
  298. 'operation_time': ('操作时间',),
  299. 'ship_company': ('船司',),
  300. 'vessel_name': ('船名航次',),
  301. 'route': ('航线',),
  302. 'cutoff_time_si': ('截SI时间',),
  303. 'clearance_port': ('清关口岸',),
  304. 'clearance_port_eta': ('清关口岸ETA',),
  305. 'loading_port': ('起运港',),
  306. 'destination_port': ('目的港',),
  307. 'wharf_name': ('到港码头',),
  308. 'transit_port': ('中转港',),
  309. 'etd': ('ETD',),
  310. 'eta': ('ETA',),
  311. 'ata': ('ATA',),
  312. 'clearance_release_time': ('清关放行时间',),
  313. 'overseas_warehouse': ('海外仓',),
  314. 'providers_name': ('拖车行',),
  315. 'has_fda': ('是否含FDA认证商品',),
  316. 'has_cpsc': ('是否含CPSC商品',),
  317. 'has_food': ('是否含食品',),
  318. },
  319. 'query_outbound_detail': {
  320. 'order_number': ('订单号',),
  321. 'cargo_type': ('超长超重',),
  322. 'customs_files': ('报关资料',),
  323. 'reference_number': ('客户参考号',),
  324. 'customer_name': ('客户名称',),
  325. 'declaration_type': ('报关方式',),
  326. 'merge_declare_number': ('合并报关单号',),
  327. 'order_remark': ('订单备注',),
  328. 'bl_number': ('提单号',),
  329. 'container_code': ('柜号',),
  330. 'customer_service': ('客户经理',),
  331. 'est_inbound_date': ('预计入库时间',),
  332. 'inbound_date': ('实际入库时间',),
  333. 'status': ('状态',),
  334. 'pieces': ('预报件数 / 入库件数',),
  335. 'weight': ('预报实重(KG) / 入库实重(KG)',),
  336. 'volume': ('预报体积(m³) / 入库体积(m³)',),
  337. 'pickup_place': ('交货地',),
  338. 'product_name': ('物流产品',),
  339. 'goods_name': ('品名',),
  340. 'closing_time': ('截关时间',),
  341. 'clearance_remark': ('报关备注',),
  342. 'import_clearance_remark': ('清关备注',),
  343. 'delivery_address': ('派送地址',),
  344. 'delivery_type': ('派送类型',),
  345. 'delivery_way': ('派送方式',),
  346. 'channel': ('派送渠道',),
  347. 'country_name': ('目的国',),
  348. 'importer_name': ('进口商',),
  349. 'vat_type': ('清关税号',),
  350. 'packing_type': ('货物类型',),
  351. 'is_abnormal': ('是否问题件',),
  352. 'package_method': ('包装类型',),
  353. 'order_reply': ('到货回复',),
  354. 'is_must_load': ('订单是否必装',),
  355. 'has_fda': ('是否含FDA认证商品',),
  356. 'has_cpsc': ('是否含CPSC商品',),
  357. 'has_food': ('是否含食品',),
  358. },
  359. 'query_customer_list': {
  360. 'customer_name': ('客户名称',),
  361. 'customer_code': ('客户代码',),
  362. 'create_time': ('开户时间',),
  363. 'business_type': ('业务类型',),
  364. 'customer_attribute': ('客户属性',),
  365. 'customer_source': ('客户来源',),
  366. 'first_inbound_date': ('首次成交时间',),
  367. 'last_inbound_date': ('最后一次走货时间',),
  368. 'active_status': ('活跃状态',),
  369. 'contract_status': ('合同状态',),
  370. 'contract_validity': ('合同有效期',),
  371. 'credit_limit': ('信用额度',),
  372. 'currency_code': ('结算币种',),
  373. 'billing_modes': ('结算模式(分业务类型)',),
  374. 'sales_name': ('商务经理',),
  375. 'merchandiser_name': ('客户经理',),
  376. 'department_name': ('事业部',),
  377. },
  378. }
  379. PAYMENT_FOLLOWUP_COLUMNS = {
  380. 'customer_name': '客户名称',
  381. 'settlement_currency': '结算币种',
  382. 'billed_unverified_amount': '已出账未核销金额',
  383. 'unbilled_amount': '未出账金额',
  384. 'overdue_unpaid_amount': '逾期未回款金额',
  385. 'billed_unverified_amount_cny': '已出账未核销金额(人民币)',
  386. 'unbilled_amount_cny': '未出账金额(人民币)',
  387. 'overdue_unpaid_amount_cny': '逾期未回款金额(人民币)',
  388. 'unverified_receivable_monthly_summary': '未回款月份汇总',
  389. 'receipt_unverified_amount': '收款单未核销金额',
  390. 'current_balance': '当前余额',
  391. 'credit_limit': '信用额度',
  392. 'bad_debt_total': '坏账合计',
  393. 'contract_status': '合同状态',
  394. }
  395. PAYMENT_FOLLOWUP_DETAIL_COLUMNS = {
  396. 'bill_month': '账单月份',
  397. 'bill_no': '账单号',
  398. 'business_type': '业务类型',
  399. 'settlement_mode': '结算模式',
  400. 'unverified_amount': '未核销金额',
  401. 'customer_receivable_date': '客户应收款日期',
  402. }
  403. PAYMENT_RECORD_COLUMNS = {
  404. 'customer_name': '客户名称',
  405. 'payment_reference': '收款水单号',
  406. 'original_received_amount': '原币到账金额',
  407. 'actual_received_amount': '实际收款金额',
  408. 'receive_date': '收款日期',
  409. 'verified_amount': '已核销金额',
  410. 'unverified_amount': '未核销金额',
  411. 'payment_approval_status': '收款审核状态',
  412. }
  413. RECEIVABLE_COST_COLUMNS = {
  414. 'order_number': '订单号',
  415. 'customer_name': '客户名称',
  416. 'cost_name': '费用项',
  417. 'cost_customer_name': '费用客户',
  418. 'charge_weight': '计费重',
  419. 'unit_price': '计费单价',
  420. 'quote_currency': '原币币种',
  421. 'receivable_original_amount': '应收原币',
  422. 'receivable_amount_cny': '应收金额(CNY)',
  423. 'settlement_amount_cny': '结算金额(CNY)',
  424. 'cost_confirmation_status': '费用确认状态',
  425. 'closing_status': '关账状态',
  426. 'verification_status': '核销状态',
  427. }
  428. RECEIVABLE_COST_SUMMARY = {
  429. 'order_total_receivable_cny': '订单总应收(CNY)',
  430. 'order_total_settlement_cny': '订单总结算(CNY)',
  431. 'special_approval_amount_cny': '特批金额(CNY)',
  432. 'settlement_gross_profit_cny': '结算毛利(CNY)',
  433. }
  434. RECEIVABLE_LIST_COLUMNS = {
  435. 'main_customer_name': '主客户',
  436. 'sub_customer_name': '子客户',
  437. 'customer_attribute': '客户属性',
  438. 'department_name': '事业部',
  439. 'document_type': '单据类型',
  440. 'warehouse_name': '仓库',
  441. 'business_number': '业务单号',
  442. 'reference_number': '参考号',
  443. 'cost_name': '费用项',
  444. 'original_amount': '原币金额',
  445. 'total_amount': '总金额',
  446. 'billed_amount': '已出账金额',
  447. 'unbilled_amount': '未出账金额',
  448. 'bill_number': '账单编号',
  449. 'verification_status': '核销状态',
  450. 'receipt_number': '收款水单号',
  451. 'receipt_date': '收款日期',
  452. 'sales_name': '商务经理',
  453. 'merchandiser_name': '客户经理',
  454. 'drainage_user_name': '引流人',
  455. 'first_leg_order_status': '头程订单状态',
  456. 'settlement_mode': '结算模式',
  457. 'cost_occurred_at': '费用发生时间',
  458. 'business_occurred_at': '业务发生时间',
  459. }
  460. PAYABLE_COST_COLUMNS = {
  461. 1: (
  462. ('number', '单号'), ('so_number', 'SO号'), ('container_code', '柜号'),
  463. ('bl_number', '提单号'), ('sub_number', '订单号'),
  464. ('business_node_name', '业务节点'), ('providers_name', '物流商'),
  465. ('cost_name', '费用名称'), ('payable_cost_q', '金额'), ('currency', '币种'),
  466. ('company_money_q', '本位币金额'), ('yf_lock', '应付锁定'),
  467. ('trade_date', '费用发生时间'), ('verify_status_text', '核销状态'),
  468. ('remark', '备注'), ('bill_no', '账单编号'), ('payment_order_number', '付款单号'),
  469. ),
  470. 2: (
  471. ('number', '单号'), ('sub_number', '跟踪单号'), ('workorder_number', '工单号'),
  472. ('order_type_name', '单据类型'), ('providers_name', '物流商'),
  473. ('cost_name', '费用名称'), ('payable_cost_q', '应付原币金额'),
  474. ('currency', '应付原币币种'), ('company_money_q', '本位币金额%s'),
  475. ('yf_lock', '应付锁定'), ('business_date', '业务发生时间'),
  476. ('trade_date', '费用发生时间'), ('create_date', '操作时间'),
  477. ('verify_status_text', '核销状态'), ('remark', '备注'),
  478. ('bill_no', '账单编号'), ('payment_order_number', '付款单号'),
  479. ),
  480. 3: (
  481. ('number', '单号'), ('order_status_text', '包裹状态'),
  482. ('providers_name', '物流商'), ('business_node_name', '费用业务节点'),
  483. ('cost_name', '费用名称'), ('detail_price', '计费单价'),
  484. ('charge_weight', '计费重'), ('quote_cost', '计费金额'),
  485. ('payable_cost_q', '实际应付金额'), ('quote_currency', '原币币种'),
  486. ('company_money_q', '计费本位币金额'), ('yf_lock', '应付锁定'),
  487. ('bill_no', '账单编号'), ('payment_order_number', '付款单号'),
  488. ('trade_date', '费用发生时间'), ('verify_status_text', '核销状态'),
  489. ('remark', '财务备注'), ('create_user_name', '操作人'), ('create_date', '录入时间'),
  490. ),
  491. 4: (
  492. ('number', '订单号'), ('business_bill_no', '货代账单号'),
  493. ('providers_name', '物流商'), ('cost_name', '费用名称'),
  494. ('payable_cost_q', '金额'), ('currency', '币种'),
  495. ('company_money_q', '本位币金额'), ('department_name', '事业部'),
  496. ('yf_lock', '应付锁定'), ('trade_date', '费用发生时间'),
  497. ('verify_status_text', '核销状态'), ('business_node_name', '业务节点'),
  498. ('remark', '备注'), ('bill_no', '应付账单编号'),
  499. ('payment_order_number', '付款单号'),
  500. ),
  501. 5: (
  502. ('order_type_name', '单据类型'), ('number', '订单号'), ('warehouse_name', '仓库'),
  503. ('business_node_name', '业务节点'), ('providers_name', '物流商'),
  504. ('cost_name', '费用名称'), ('payable_cost_q', '金额'), ('currency', '币种'),
  505. ('company_money_q', '本位币金额'), ('yf_lock', '应付锁定'),
  506. ('trade_date', '费用发生时间'), ('verify_status_text', '核销状态'),
  507. ('remark', '备注'), ('bill_no', '账单编号'), ('payment_order_number', '付款单号'),
  508. ),
  509. 7: (
  510. ('number', '订单号'), ('ep_order_status_text', '订单状态'),
  511. ('business_node_name', '业务节点'), ('providers_name', '物流商'),
  512. ('cost_name', '费用名称'), ('detail_price', '计费单价'),
  513. ('charge_weight', '计费重'), ('quote_cost', '计费金额'),
  514. ('payable_cost_q', '实际应付金额'), ('quote_currency', '原币币种'),
  515. ('company_money_q', '本位币金额'), ('trade_date', '费用发生时间'),
  516. ('remark', '备注'), ('verify_status_text', '核销状态'),
  517. ('bill_no', '账单编号'), ('payment_order_number', '付款单号'),
  518. ('create_user_name', '操作人'), ('create_date', '录入时间'),
  519. ),
  520. }
  521. PAYABLE_AMOUNT_KEYS = frozenset((
  522. 'detail_price', 'charge_weight', 'quote_cost', 'payable_cost_q', 'company_money_q',
  523. ))
  524. PAYMENT_FOLLOWUP_MONTHLY_COLUMNS = {
  525. 'receivable_month': '应收月份',
  526. 'unverified_amount': '未核销金额',
  527. 'is_overdue': '是否逾期',
  528. }
  529. DESTINATION_TRAILER_COLUMNS = {
  530. 'progress': (
  531. ('bl_number', '提单号'), ('container_code', '柜号'),
  532. ('container_type', '柜型'), ('warehouse_name', '仓库名称'),
  533. ('providers_name', '拖车行'), ('trailer_status', '提柜状态'),
  534. ('latest_remark', '最新操作备注'), ('is_direct_send', '直送'),
  535. ('cabinet_type', '整拼类型'), ('vessel_name', '船名航次'),
  536. ('route', '航线'), ('clearance_check', '清关查验'),
  537. ('etd', 'ETD'), ('atd', 'ATD'), ('eta', 'ETA'), ('ata', 'ATA'),
  538. ('loading_port', '起运港'), ('destination_port', '目的港'),
  539. ('wharf_name', '到港码头'), ('appt_time', 'APPT时间'),
  540. ('delivery_end_time', '卡车实际派送时间'),
  541. ('est_pickup_time', '预计提柜时间'),
  542. ('pickup_time', '实际提柜时间'), ('inbound_date', '到仓时间'),
  543. ('container_return_time', '还柜时间'),
  544. ('pickup_prescription', '提柜时效'),
  545. ('return_prescription', '还柜时效'),
  546. ('wharf_wait_time', '码头等待时间'),
  547. ('amazon_wait_time', '亚马逊等待时间'),
  548. ('bill_status', '应付费用状态'),
  549. ),
  550. 'do': (
  551. ('trailer_number', '拖车单号'), ('outbound_number', '出库单号'),
  552. ('container_code', '柜号'), ('container_type', '柜型'),
  553. ('bl_number', '提单号'), ('is_direct_send', '是否直送'),
  554. ('original_do_file', '原DO单'), ('new_do_file', '新DO单'),
  555. ('email_subject', '邮件主题'), ('email_from', '邮件发送人'),
  556. ('received_at', '邮件接收时间'),
  557. ),
  558. }
  559. DESTINATION_TRAILER_FILE_KEYS = frozenset(('original_do_file', 'new_do_file'))
  560. DESTINATION_TRAILER_PROGRESS_STAGES = frozenset((
  561. '待安排拖车', '待提柜', '待还柜(海)', '已还柜(海)', '已提货(空)',
  562. ))
  563. ORDER_ABNORMAL_COLUMNS = (
  564. ('order_number', '订单号'), ('customer_name', '客户'),
  565. ('product_name', '物流产品'), ('abnormal_status', '问题件状态'),
  566. ('abnormal_type', '问题件类型'), ('abnormal_desc', '问题件描述'),
  567. ('outbound_status', '排舱单状态'), ('inbound_date', '入库时间'),
  568. ('marker_name', '标记人'),
  569. )
  570. ORDER_ABNORMAL_STATUSES = frozenset((
  571. '待处理', '放行待审核', '包裹放行', '退件待审核', '退件驳回', '已退件',
  572. ))
  573. GOODS_INFO_COLUMNS = (
  574. ('sku', 'SKU'), ('departure_country', '起运国'),
  575. ('destination_country', '目的国'), ('goods_attr', '商品属性'),
  576. ('cn_name', '中文名称'), ('en_name', '英文名称'),
  577. ('declaration_hscode', '报关编码'), ('clearance_hscode', '清关编码'),
  578. ('tax_rate', '税率'), ('is_inspection_fee', '木制/竹制品商检费'),
  579. ('is_fda_declaration', 'FDA申报'), ('product_surcharge', '产品附加费'),
  580. ('tax_surcharge', '关税附加费'), ('is_epa_declaration', 'EPA申报'),
  581. ('is_act_declaration', 'LACY ACT申报'), ('is_dot_declaration', 'DOT申报'),
  582. ('is_cpsc_declaration', 'CPSC申报'), ('brand_type', '品牌类型'),
  583. ('brand', '品牌'), ('goods_type', '型号'),
  584. ('material_cn', '材质(CN)'), ('material_en', '材质(EN)'),
  585. ('purpose_cn', '用途(CN)'), ('purpose_en', '用途(EN)'),
  586. )
  587. RECEIVE_VOLUME_COLUMNS = (
  588. ('order_number', '订单号'), ('customer_name', '客户名称'),
  589. ('packing_type', '货物类型'), ('inbound_volume', '入库体积'),
  590. ('inbound_date', '入库时间'), ('sales_name', '商务经理'),
  591. ('merchandiser_name', '客户经理'), ('department_name', '事业部'),
  592. ('product_name', '物流产品'),
  593. )
  594. HEADHAUL_DOCUMENT_COLUMNS = (
  595. ('document_type_name', '文档类型'),
  596. ('entry_no_text', '录入单号快照'),
  597. ('original_name', '文件名'),
  598. ('safe_url', '安全链接'),
  599. ('operator_name', '操作人'),
  600. ('operate_time', '操作时间'),
  601. )
  602. CONTAINER_TIMELINESS_COLUMNS = (
  603. ('ship_company', '船公司'), ('bl_number', '提单号'),
  604. ('container_code', '柜号'), ('container_type', '柜型'),
  605. ('is_direct_send_name', '是否直送'), ('shipping_method', '运输方式'),
  606. ('route', '航线'), ('vessel_name', '航名航次'),
  607. ('wharf_name', '到港码头'), ('providers_name', '拖车行'),
  608. ('dt_status_name', '柜子状态'), ('warehouse_name', '交货仓库'),
  609. ('order_total', '件数'), ('total_volume', '体积'),
  610. ('total_weight', '重量'), ('loading_name', '起运港'),
  611. ('destination_name', '目的港'), ('delivery_address', '派送地址'),
  612. ('has_throw_off_name', '甩柜'), ('throw_off_time', '甩柜时间'),
  613. ('ed_check_name', '报关查验'), ('ed_check_time', '报关查验时间'),
  614. ('qg_check_name', '清关查验'), ('check_time', '清关查验时间'),
  615. ('in_inspection_site', '进查验场时间'),
  616. ('out_inspection_site', '出查验场时间'),
  617. ('is_close_area_name', '封闭区'), ('start_close_area', '进封闭区时间'),
  618. ('end_close_area', '出封闭区时间'), ('outbound_date', '出库时间'),
  619. ('export_release_time', '出口报关放行时间'),
  620. ('etd', '干线预计出发时间'), ('eta', '干线预计到达时间'),
  621. ('gxyjsx', '干线预计时效'), ('departure_time', '干线实际出发时间'),
  622. ('arrival_time', '干线实际到达时间'), ('gxsjsx', '干线实际时效'),
  623. ('hcsx', '航程时效'), ('start_clearance_time', '开始清关时间'),
  624. ('import_release_time', '海外清关放行时间'),
  625. ('wharf_wait_time', '码头等待时间'), ('pickup_time', '码头提柜时间'),
  626. ('second_pickup_time', '二次提柜时间'), ('tgsx', '提柜时效'),
  627. ('max_appointment_delivery_time', 'APPT时间'),
  628. ('delivery_end_time', '卡车实际派送时间'),
  629. ('oversea_warehouse_name', '海外仓库名称'),
  630. ('inbound_date', '到仓时间'), ('inbound_time', '海外仓入库时间'),
  631. ('container_return_date', '还空柜时间'), ('hksx', '还空时效'),
  632. ('amazon_wait_time', '亚马逊等待时间'),
  633. ('inner_remark', '内部备注'), ('financial_remark', '财务备注'),
  634. )
  635. OUTBOUND_DETAIL_SUMMARY = {
  636. 'bl_number': '提单号',
  637. 'container_code': '柜号',
  638. 'container_type': '柜型',
  639. 'total_volume': '总体积',
  640. 'total_weight': '总重量',
  641. 'total_pieces': '总件数',
  642. 'sku': 'SKU',
  643. 'buy_declaration_count': '买单报关数量',
  644. 'general_declaration_count': '一般贸易报关数量',
  645. 'must_load': '必装单量/体积',
  646. 'backup_load': '备装单量/体积',
  647. }
  648. FIELD_LABELS = {
  649. 'query_order_exact': {
  650. 'order_number': '订单号',
  651. 'order_numbers': '订单号',
  652. 'reference_number': '客户参考号',
  653. 'reference_numbers': '客户参考号',
  654. 'tracking_number': '快递单号',
  655. 'tracking_numbers': '快递单号',
  656. 'outbound_number': '排舱单号',
  657. 'outbound_numbers': '排舱单号',
  658. 'container_code': '柜号',
  659. 'container_codes': '柜号',
  660. 'so_number': 'SO号',
  661. 'so_numbers': 'SO号',
  662. 'shipment_id': 'Shipment ID',
  663. 'receiver_country': '收货国家',
  664. 'product_ids': '物流产品',
  665. 'customer_ids': '客户',
  666. 'sales_id': '销售人员',
  667. 'warehouse_ids': '仓库',
  668. 'department_id': '事业部',
  669. 'inbound_date_start': '入库开始日期',
  670. 'inbound_date_end': '入库结束日期',
  671. 'outbound_date_start': '出库开始日期',
  672. 'outbound_date_end': '出库结束日期',
  673. 'page': '页码',
  674. 'limit': '每页数量',
  675. },
  676. 'query_track': {
  677. 'order_id': '订单ID',
  678. 'order_number': '订单号',
  679. 'tracking_number': '快递单号',
  680. 'page': '页码',
  681. 'limit': '每页数量',
  682. },
  683. 'query_customs_declaration_files': {
  684. 'outbound_numbers': '排舱单号',
  685. 'order_numbers': '订单号',
  686. 'page': '页码',
  687. 'limit': '每页数量',
  688. },
  689. 'query_outbound_list': {
  690. 'outbound_numbers': '排舱单号',
  691. 'order_numbers': '订单号',
  692. 'container_codes': '柜号',
  693. 'so_numbers': 'SO号',
  694. 'bl_numbers': '提单号',
  695. 'outbound_status': '排舱状态',
  696. 'shipping_method': '运输方式',
  697. 'warehouse_id': '集货仓库',
  698. 'is_direct_send': '是否直送柜',
  699. 'page': '页码',
  700. 'limit': '每页数量',
  701. },
  702. 'query_outbound_detail': {
  703. 'outbound_number': '排舱单号',
  704. 'page': '页码',
  705. 'limit': '每页数量',
  706. },
  707. 'query_order_detail': {
  708. 'order_number': '订单号', 'section': '详情模块',
  709. 'page': '页码', 'limit': '每页数量',
  710. },
  711. 'list_order_filter_options': {
  712. 'filter_type': '筛选项类型',
  713. 'keyword': '关键词',
  714. 'page': '页码',
  715. 'limit': '每页数量',
  716. },
  717. 'list_outbound_filter_options': {
  718. 'filter_type': '筛选类别',
  719. 'keyword': '显示名称',
  720. 'page': '页码',
  721. 'limit': '每页数量',
  722. },
  723. 'list_pending_outbound_export_filter_options': {
  724. 'filter_type': '筛选项类型',
  725. 'product_type_id': '产品分类',
  726. 'keyword': '关键词',
  727. 'page': '页码',
  728. 'limit': '每页数量',
  729. },
  730. 'query_customer_list': {
  731. 'customer_id': '客户名称',
  732. 'department_id': '事业部',
  733. 'sales_id': '商务经理',
  734. 'merchandiser_id': '客户经理',
  735. 'page': '页码',
  736. 'limit': '每页数量',
  737. },
  738. 'query_customer_payment_followup': {
  739. 'customer_id': '客户名称',
  740. 'department_id': '事业部',
  741. 'sales_id': '商务经理',
  742. 'merchandiser_id': '客户经理',
  743. 'has_unverified_receivable_only': '只看有应收未核销费用的客户',
  744. 'page': '页码',
  745. 'limit': '每页数量',
  746. },
  747. 'query_customer_unverified_bill_details': {
  748. 'customer_id': '客户名称',
  749. 'page': '页码',
  750. 'limit': '每页数量',
  751. },
  752. 'list_customer_filter_options': {
  753. 'filter_type': '筛选项类型',
  754. 'keyword': '关键词',
  755. 'page': '页码',
  756. 'limit': '每页数量',
  757. },
  758. 'export_pending_outbound_orders': {
  759. 'number': '单号',
  760. 'product_type_id': '产品分类',
  761. 'product_id': '物流产品',
  762. 'order_warehouse_id': '集货仓库',
  763. 'receiver_country': '目的国',
  764. 'is_remove': '是否装柜剔除',
  765. 'address': '派送地址',
  766. 'inbound_date': '入库时间',
  767. 'status': '订单状态',
  768. 'merge_declare_number': '合并报关单号',
  769. 'importer_id': '进口商',
  770. 'packing_type': '货物类型',
  771. 'is_battery': '带电属性',
  772. 'is_magnetic': '带磁属性',
  773. 'is_wood': '带木属性',
  774. 'is_other': '其他商品属性',
  775. 'is_fda': 'FDA产品属性',
  776. 'is_toy': '玩具属性',
  777. 'is_ultra_limit': '超长超重属性',
  778. 'is_sensitive': '敏感货属性',
  779. 'is_food': '食品属性',
  780. 'no_property': '无属性',
  781. },
  782. 'export_out_of_province_port_data': {
  783. 'outbound_numbers': '排舱单号',
  784. 'container_codes': '柜号',
  785. 'bl_numbers': '提单号',
  786. 'so_numbers': 'SO号',
  787. 'file_type': '资料类型',
  788. },
  789. 'export_pallet_data': {
  790. 'container_codes': '柜号',
  791. 'bl_numbers': '提单号',
  792. 'inbound_time_start': '海外仓入库时间开始',
  793. 'inbound_time_end': '海外仓入库时间结束',
  794. },
  795. 'query_container_timeliness_list': {
  796. 'container_codes': '柜号',
  797. 'bl_numbers': '提单号',
  798. 'departure_time_start': '干线实际出发时间开始',
  799. 'departure_time_end': '干线实际出发时间结束',
  800. 'page': '页码',
  801. 'limit': '每页数量',
  802. },
  803. 'export_container_timeliness_report': {
  804. 'container_codes': '柜号',
  805. 'bl_numbers': '提单号',
  806. 'departure_time_start': '干线实际出发时间开始',
  807. 'departure_time_end': '干线实际出发时间结束',
  808. },
  809. 'query_headhaul_document_list': {
  810. 'document_type_id': '文档类型',
  811. 'original_name': '文件名',
  812. 'declaration_numbers': '报关单号',
  813. 'sys_bl_numbers': '系统提单号',
  814. 'container_codes': '柜号',
  815. 'order_numbers': '订单号',
  816. 'clearance_numbers': '清关单号',
  817. 'customer_names': '客户',
  818. 'so_numbers': 'SO号',
  819. 'bl_numbers': '提单号',
  820. 'trailer_numbers': '拖车单',
  821. 'truck_bol_numbers': '卡车单号',
  822. 'provider_names': '供应商',
  823. 'importer_names': '进口商',
  824. 'page': '页码',
  825. 'limit': '每页数量',
  826. },
  827. 'list_headhaul_document_filter_options': {
  828. 'filter_type': '筛选类别',
  829. 'keyword': '显示名称',
  830. 'page': '页码',
  831. 'limit': '每页数量',
  832. },
  833. 'prepare_headhaul_document_upload': {
  834. 'document_type_id': '文档类型',
  835. },
  836. 'save_headhaul_document': {
  837. 'document_type_id': '文档类型',
  838. 'ticket_ref': '上传凭证',
  839. 'link_url': '外链',
  840. 'entries': '录入单号',
  841. },
  842. 'delete_headhaul_document': {
  843. 'document_ref': '文档身份',
  844. },
  845. 'export_receivable_cost_list': {
  846. 'reference_numbers': '参考号',
  847. 'tracking_numbers': '跟踪号',
  848. 'order_numbers': '订单号',
  849. 'bill_numbers': '账单编号',
  850. 'business_date_start': '业务发生开始日期',
  851. 'business_date_end': '业务发生结束日期',
  852. 'customer_id': '主客户',
  853. 'sub_customer_id': '子客户',
  854. 'billing_status': '出账状态',
  855. 'verification_status': '核销状态',
  856. 'document_type': '单据类型',
  857. 'cost_type_id': '费用项',
  858. },
  859. 'query_export_task': {
  860. 'task_ref': '导出任务引用',
  861. },
  862. 'query_freightower_track': {
  863. 'bl_number': '提单号',
  864. 'container_code': '柜号',
  865. },
  866. }
  867. ERROR_MESSAGES = {
  868. 'MCP_1101': '设备配置已失效,请重新生成配置',
  869. 'MCP_1102': '设备会话已过期,请重新连接',
  870. 'MCP_1103': '员工账号不可用,请联系管理员',
  871. 'MCP_1104': '身份信息已失效,请重新登录或重新生成设备配置',
  872. 'MCP_1201': '工具当前不可用',
  873. 'MCP_1202': '工具当前不可用',
  874. 'MCP_1301': '没有权限使用此工具',
  875. 'MCP_1501': '目标数据不可用',
  876. 'MCP_1502': '结果过多,请缩小查询范围',
  877. 'MCP_1601': '没有可导出的数据',
  878. 'MCP_9001': '工具调用失败,请稍后重试',
  879. }
  880. TAX_TRIAL_MESSAGES = frozenset((
  881. '未找到已审核商品',
  882. '匹配到多条商品,请核对起运国和目的国',
  883. '该商品没有应收清关编码,无法试算',
  884. '关税试算失败,请稍后重试',
  885. ))
  886. NON_RETRYABLE_CODES = frozenset((
  887. 'MCP_1101',
  888. 'MCP_1102',
  889. 'MCP_1103',
  890. 'MCP_1104',
  891. 'MCP_1201',
  892. 'MCP_1202',
  893. 'MCP_1301',
  894. 'MCP_1401',
  895. 'MCP_1501',
  896. 'MCP_1502',
  897. 'MCP_1601',
  898. ))
  899. def handles(self, tool_name):
  900. return isinstance(tool_name, str) and tool_name in self.SAFE_TOOLS
  901. # Convert a backend envelope into text and structured display data.
  902. def present(self, tool_name, tool_result):
  903. if not self.handles(tool_name) or not isinstance(tool_result, dict):
  904. return self._format_error()
  905. code = str(tool_result.get('code') or '').strip()
  906. meta = self._build_meta(tool_result.get('meta'))
  907. if code not in ('MCP_0000', '0'):
  908. return self._business_error(
  909. tool_name,
  910. code or 'MCP_9001',
  911. tool_result.get('msg'),
  912. meta,
  913. )
  914. data = tool_result.get('data')
  915. if not isinstance(data, dict):
  916. return self._format_error(meta)
  917. if tool_name in self.DETAIL_TOOLS:
  918. return self._present_outbound_detail(
  919. tool_name,
  920. data,
  921. tool_result.get('meta'),
  922. meta,
  923. )
  924. if tool_name in self.ORDER_DETAIL_TOOLS:
  925. return self._present_order_detail(data, tool_result.get('meta'), meta)
  926. if tool_name in self.PAYMENT_FOLLOWUP_TOOLS:
  927. return self._present_customer_payment_followup(
  928. data, tool_result.get('meta'), meta
  929. )
  930. if tool_name in self.PAYMENT_DETAIL_TOOLS:
  931. return self._present_customer_unverified_bill_details(
  932. data, tool_result.get('meta'), meta
  933. )
  934. if tool_name in self.PAYMENT_RECORD_TOOLS:
  935. return self._present_customer_payment_records(
  936. data, tool_result.get('meta'), meta
  937. )
  938. if tool_name in self.RECEIVABLE_COST_TOOLS:
  939. return self._present_order_receivable_cost_details(
  940. data, tool_result.get('meta'), meta
  941. )
  942. if tool_name in self.RECEIVABLE_LIST_TOOLS:
  943. return self._present_receivable_cost_list(
  944. data, tool_result.get('meta'), meta
  945. )
  946. if tool_name in self.RECEIVABLE_FILTER_TOOLS:
  947. return self._present_receivable_cost_filter_options(
  948. data, tool_result.get('meta'), meta
  949. )
  950. if tool_name in self.PAYABLE_COST_TOOLS:
  951. return self._present_payable_cost_list(
  952. data, tool_result.get('meta'), meta
  953. )
  954. if tool_name in self.PAYABLE_FILTER_TOOLS:
  955. return self._present_receivable_cost_filter_options(
  956. data, tool_result.get('meta'), meta
  957. )
  958. if tool_name in self.DESTINATION_TRAILER_TOOLS:
  959. return self._present_destination_trailer_list(
  960. data, tool_result.get('meta'), meta
  961. )
  962. if tool_name in self.ORDER_ABNORMAL_TOOLS:
  963. return self._present_order_abnormal_list(
  964. data, tool_result.get('meta'), meta
  965. )
  966. if tool_name in self.RECEIVE_VOLUME_TOOLS:
  967. return self._present_receive_volume_list(
  968. data, tool_result.get('meta'), meta
  969. )
  970. if tool_name in self.GOODS_INFO_TOOLS:
  971. return self._present_goods_info(
  972. data, tool_result.get('meta'), meta
  973. )
  974. if tool_name in self.GOODS_TAX_TOOLS:
  975. return self._present_goods_tax(data, meta)
  976. if tool_name in self.CONTAINER_TIMELINESS_TOOLS:
  977. return self._present_container_timeliness_list(
  978. data, tool_result.get('meta'), meta
  979. )
  980. if tool_name in self.HEADHAUL_DOCUMENT_TOOLS:
  981. return self._present_headhaul_document_list(
  982. data, tool_result.get('meta'), meta
  983. )
  984. if tool_name in self.HEADHAUL_PREPARE_TOOLS:
  985. return self._present_headhaul_prepare(data, meta)
  986. if tool_name in self.HEADHAUL_SAVE_TOOLS:
  987. return self._present_headhaul_save(data, meta)
  988. if tool_name in self.HEADHAUL_DELETE_TOOLS:
  989. return self._present_headhaul_delete(data, meta)
  990. if tool_name in self.FREIGHTOWER_TRACK_TOOLS:
  991. return self._present_freightower_track(data, meta)
  992. if tool_name in self.TABLE_TOOLS:
  993. return self._present_table(
  994. tool_name,
  995. data,
  996. tool_result.get('meta'),
  997. meta,
  998. )
  999. if tool_name in self.OPTION_TOOLS:
  1000. if tool_name == 'list_customer_filter_options':
  1001. return self._present_customer_options(
  1002. data, tool_result.get('meta'), meta
  1003. )
  1004. return self._present_options(data, tool_result.get('meta'), meta)
  1005. if tool_name in self.EXPORT_TOOLS:
  1006. return self._present_export_submission(data, meta)
  1007. if tool_name in self.PAYABLE_EXPORT_TOOLS:
  1008. return self._present_export_submission(data, meta)
  1009. return self._present_export_task(data, meta)
  1010. def _present_order_detail(self, data, raw_meta, meta):
  1011. if set(data) != {'section', 'order_number', 'payload'}:
  1012. return self._format_error(meta)
  1013. section = data.get('section')
  1014. order_number = data.get('order_number')
  1015. payload = data.get('payload')
  1016. if (
  1017. section not in self.ORDER_DETAIL_SECTIONS
  1018. or not isinstance(order_number, str) or not order_number.strip()
  1019. or not isinstance(payload, dict)
  1020. ):
  1021. return self._format_error(meta)
  1022. content = {
  1023. '订单号': order_number.strip(),
  1024. '详情模块': self.ORDER_DETAIL_SECTIONS[section],
  1025. }
  1026. if section == 'all':
  1027. all_content = self._present_order_detail_all(payload)
  1028. if all_content is None:
  1029. return self._format_error(meta)
  1030. content.update(all_content)
  1031. elif section == 'overview':
  1032. expected = {
  1033. 'status_nodes', 'order_info', 'freight_info',
  1034. 'package_summary', 'trader_info',
  1035. }
  1036. if set(payload) != expected or not isinstance(payload['status_nodes'], list):
  1037. return self._format_error(meta)
  1038. nodes = []
  1039. for row in payload['status_nodes']:
  1040. translated = self._translate_exact(row, self.ORDER_DETAIL_STATUS_FIELDS)
  1041. if translated is None:
  1042. return self._format_error(meta)
  1043. state = row.get('state')
  1044. time_kind = row.get('time_kind')
  1045. if state not in self.ORDER_DETAIL_STATES or time_kind not in self.ORDER_DETAIL_TIME_KINDS:
  1046. return self._format_error(meta)
  1047. translated['状态'] = self.ORDER_DETAIL_STATES[state]
  1048. translated['时间类型'] = self.ORDER_DETAIL_TIME_KINDS[time_kind]
  1049. nodes.append(translated)
  1050. content['状态节点'] = nodes
  1051. for raw_key, chinese_key in (
  1052. ('order_info', '订单信息'), ('freight_info', '货运信息'),
  1053. ('package_summary', '箱单汇总'), ('trader_info', '进出口商'),
  1054. ):
  1055. translated = self._translate_exact(
  1056. payload.get(raw_key),
  1057. self.ORDER_DETAIL_FIELDS['overview'][raw_key],
  1058. )
  1059. if translated is None:
  1060. return self._format_error(meta)
  1061. content[chinese_key] = translated
  1062. elif section == 'inbound':
  1063. if set(payload) != {'summary', 'records'}:
  1064. return self._format_error(meta)
  1065. summary = self._translate_exact(
  1066. payload.get('summary'), self.ORDER_DETAIL_FIELDS['inbound_summary']
  1067. )
  1068. records = self._translate_order_detail_rows(section, payload.get('records'))
  1069. if summary is None or records is None:
  1070. return self._format_error(meta)
  1071. content['入库概况'] = summary
  1072. content['明细'] = records
  1073. pagination = self._order_detail_pagination(raw_meta)
  1074. if pagination is None:
  1075. return self._format_error(meta)
  1076. content['分页'] = pagination
  1077. elif section == 'delivery':
  1078. if set(payload) != {'summary', 'records'}:
  1079. return self._format_error(meta)
  1080. summary = self._translate_exact(
  1081. payload.get('summary'), self.ORDER_DETAIL_FIELDS['delivery_summary']
  1082. )
  1083. records = self._translate_order_detail_rows(section, payload.get('records'))
  1084. if summary is None or records is None:
  1085. return self._format_error(meta)
  1086. content['派送汇总'] = summary
  1087. content['明细'] = records
  1088. pagination = self._order_detail_pagination(raw_meta)
  1089. if pagination is None:
  1090. return self._format_error(meta)
  1091. content['分页'] = pagination
  1092. else:
  1093. if set(payload) != {'records'}:
  1094. return self._format_error(meta)
  1095. records = self._translate_order_detail_rows(section, payload.get('records'))
  1096. pagination = self._order_detail_pagination(raw_meta)
  1097. if records is None or pagination is None:
  1098. return self._format_error(meta)
  1099. content['明细'] = records
  1100. content['分页'] = pagination
  1101. text = json.dumps(content, ensure_ascii=False, indent=2)
  1102. return self._success_result(content, text, meta)
  1103. def _present_order_detail_all(self, payload):
  1104. expected_sections = set(self.ORDER_DETAIL_SECTIONS) - {'all'}
  1105. if set(payload) != expected_sections:
  1106. return None
  1107. overview = payload.get('overview')
  1108. if not isinstance(overview, dict) or set(overview) != {
  1109. 'status_nodes', 'order_info', 'freight_info', 'package_summary', 'trader_info',
  1110. } or not isinstance(overview['status_nodes'], list):
  1111. return None
  1112. overview_content = {'状态节点': []}
  1113. for row in overview['status_nodes']:
  1114. translated = self._translate_exact(row, self.ORDER_DETAIL_STATUS_FIELDS)
  1115. if translated is None:
  1116. return None
  1117. state = row.get('state')
  1118. time_kind = row.get('time_kind')
  1119. if state not in self.ORDER_DETAIL_STATES or time_kind not in self.ORDER_DETAIL_TIME_KINDS:
  1120. return None
  1121. translated['状态'] = self.ORDER_DETAIL_STATES[state]
  1122. translated['时间类型'] = self.ORDER_DETAIL_TIME_KINDS[time_kind]
  1123. overview_content['状态节点'].append(translated)
  1124. for raw_key, chinese_key in (
  1125. ('order_info', '订单信息'), ('freight_info', '货运信息'),
  1126. ('package_summary', '箱单汇总'), ('trader_info', '进出口商'),
  1127. ):
  1128. translated = self._translate_exact(
  1129. overview.get(raw_key), self.ORDER_DETAIL_FIELDS['overview'][raw_key]
  1130. )
  1131. if translated is None:
  1132. return None
  1133. overview_content[chinese_key] = translated
  1134. result = {'订单概览': overview_content}
  1135. for section, label in self.ORDER_DETAIL_SECTIONS.items():
  1136. if section in ('overview', 'all'):
  1137. continue
  1138. translated = self._present_order_detail_all_section(section, payload.get(section))
  1139. if translated is None:
  1140. return None
  1141. result[label] = translated
  1142. return result
  1143. def _present_order_detail_all_section(self, section, payload):
  1144. if not isinstance(payload, dict) or 'pagination' not in payload:
  1145. return None
  1146. pagination = self._order_detail_pagination(payload.get('pagination'))
  1147. if pagination is None:
  1148. return None
  1149. if section == 'inbound':
  1150. if set(payload) != {'summary', 'records', 'pagination'}:
  1151. return None
  1152. summary = self._translate_exact(
  1153. payload.get('summary'), self.ORDER_DETAIL_FIELDS['inbound_summary']
  1154. )
  1155. records = self._translate_order_detail_rows(section, payload.get('records'))
  1156. if summary is None or records is None:
  1157. return None
  1158. return {'入库概况': summary, '明细': records, '分页': pagination}
  1159. if section == 'delivery':
  1160. if set(payload) != {'summary', 'records', 'pagination'}:
  1161. return None
  1162. summary = self._translate_exact(
  1163. payload.get('summary'), self.ORDER_DETAIL_FIELDS['delivery_summary']
  1164. )
  1165. records = self._translate_order_detail_rows(section, payload.get('records'))
  1166. if summary is None or records is None:
  1167. return None
  1168. return {'派送汇总': summary, '明细': records, '分页': pagination}
  1169. if set(payload) != {'records', 'pagination'}:
  1170. return None
  1171. records = self._translate_order_detail_rows(section, payload.get('records'))
  1172. if records is None:
  1173. return None
  1174. return {'明细': records, '分页': pagination}
  1175. def _translate_order_detail_rows(self, section, records):
  1176. if not isinstance(records, list):
  1177. return None
  1178. mapping = self.ORDER_DETAIL_FIELDS.get(section)
  1179. if not isinstance(mapping, dict):
  1180. return None
  1181. translated_rows = []
  1182. for row in records:
  1183. translated = self._translate_exact(row, mapping)
  1184. if translated is None:
  1185. return None
  1186. if section == 'inbound':
  1187. mode = row.get('weight_mode')
  1188. if mode not in ('single_box', 'total'):
  1189. return None
  1190. translated[
  1191. '单箱入库重量' if mode == 'single_box' else '总重量KG'
  1192. ] = row.get('weight', '')
  1193. translated_rows.append(translated)
  1194. return translated_rows
  1195. @staticmethod
  1196. def _translate_exact(value, mapping):
  1197. if not isinstance(value, dict) or set(value) != set(mapping):
  1198. return None
  1199. result = {}
  1200. for key, label in mapping.items():
  1201. if label is None:
  1202. continue
  1203. item = value.get(key, '')
  1204. if isinstance(item, (dict, list)):
  1205. return None
  1206. result[label] = '' if item is None else item
  1207. return result
  1208. @staticmethod
  1209. def _order_detail_pagination(raw_meta):
  1210. if not isinstance(raw_meta, dict):
  1211. return None
  1212. if not all(key in raw_meta for key in ('page', 'limit', 'has_more')):
  1213. return None
  1214. page = raw_meta.get('page')
  1215. limit = raw_meta.get('limit')
  1216. has_more = raw_meta.get('has_more')
  1217. if isinstance(page, bool) or not isinstance(page, int) or page < 1:
  1218. return None
  1219. if isinstance(limit, bool) or not isinstance(limit, int) or limit < 1:
  1220. return None
  1221. if not isinstance(has_more, bool):
  1222. return None
  1223. return {'页码': page, '每页数量': limit, '是否还有更多': has_more}
  1224. # Map local tool exceptions without exposing internal error details.
  1225. def present_exception(self, tool_name, exception):
  1226. if not self.handles(tool_name):
  1227. return self._format_error()
  1228. message = str(exception or '').strip()
  1229. if isinstance(exception, ValueError):
  1230. label = self._find_field_label(tool_name, message)
  1231. return self._error_result(
  1232. 'MCP_1401',
  1233. self._parameter_message(label),
  1234. False,
  1235. )
  1236. if message == DEVICE_INVALID_MESSAGE:
  1237. return self._error_result('MCP_1101', DEVICE_INVALID_MESSAGE, False)
  1238. if message.lower().startswith('tool disabled'):
  1239. return self._error_result('MCP_1202', '工具当前不可用', False)
  1240. return self._error_result(
  1241. 'MCP_9001',
  1242. '工具调用失败,请稍后重试',
  1243. True,
  1244. )
  1245. def _present_table(self, tool_name, data, raw_meta, meta):
  1246. columns = data.get('columns')
  1247. records = data.get('records')
  1248. if not isinstance(columns, list) or not columns or not isinstance(records, list):
  1249. return self._format_error(meta)
  1250. allowed_columns = self.TABLE_COLUMNS.get(tool_name)
  1251. if not isinstance(allowed_columns, dict):
  1252. return self._format_error(meta)
  1253. if tool_name == 'query_customer_list':
  1254. expected = list(allowed_columns.keys())
  1255. actual = [
  1256. column.get('key') if isinstance(column, dict) else None
  1257. for column in columns
  1258. ]
  1259. if actual != expected or self._customer_pagination(raw_meta) is None:
  1260. return self._format_error(meta)
  1261. headers = []
  1262. keys = []
  1263. for column in columns:
  1264. if not isinstance(column, dict):
  1265. return self._format_error(meta)
  1266. key = column.get('key')
  1267. label = column.get('name')
  1268. if not isinstance(key, str) or not key.strip():
  1269. return self._format_error(meta)
  1270. if not isinstance(label, str) or not label.strip():
  1271. return self._format_error(meta)
  1272. key = key.strip()
  1273. definition = allowed_columns.get(key)
  1274. if not isinstance(definition, tuple) or not definition:
  1275. return self._format_error(meta)
  1276. keys.append(key)
  1277. header = {'label': definition[0]}
  1278. if len(definition) > 1:
  1279. header['description'] = definition[1]
  1280. headers.append(header)
  1281. rows = []
  1282. for record in records:
  1283. if not isinstance(record, dict):
  1284. return self._format_error(meta)
  1285. if tool_name == 'query_customer_list' and set(record) != set(keys):
  1286. return self._format_error(meta)
  1287. row = []
  1288. for key in keys:
  1289. value = '' if record.get(key) is None else record.get(key, '')
  1290. if tool_name == 'query_customer_list' and key == 'billing_modes':
  1291. value = self._customer_billing_modes(value)
  1292. if value is None:
  1293. return self._format_error(meta)
  1294. elif tool_name == 'query_customer_list' and isinstance(value, (dict, list)):
  1295. return self._format_error(meta)
  1296. row.append(value)
  1297. rows.append(row)
  1298. content = {
  1299. 'summary': self._safe_text(data.get('summary')),
  1300. 'headers': headers,
  1301. 'rows': rows,
  1302. }
  1303. if tool_name == 'query_customer_list':
  1304. content['display_rules'] = {
  1305. 'mode': 'complete',
  1306. 'allow_summary': False,
  1307. 'allow_omit_records': False,
  1308. 'allow_omit_empty_fields': False,
  1309. 'allow_rename_fields': False,
  1310. 'preserve_record_order': True,
  1311. 'required_field_count': len(headers),
  1312. 'returned_record_count': len(rows),
  1313. 'required_value_count': len(headers) * len(rows),
  1314. 'instruction': '最终回复必须逐条展示全部记录及全部17个字段,不得摘要、省略或改写',
  1315. }
  1316. tips = self._safe_tips(data.get('tips'))
  1317. if tips:
  1318. content['tips'] = tips
  1319. pagination = self._build_pagination(raw_meta)
  1320. if pagination:
  1321. content['pagination'] = pagination
  1322. return self._success_result(
  1323. content,
  1324. self._render_table(
  1325. content,
  1326. require_complete=tool_name == 'query_customer_list',
  1327. ),
  1328. meta,
  1329. )
  1330. def _present_customer_payment_followup(self, data, raw_meta, meta):
  1331. if set(data) != {'columns', 'records'}:
  1332. return self._format_error(meta)
  1333. columns = data.get('columns')
  1334. records = data.get('records')
  1335. pagination = self._customer_pagination(raw_meta)
  1336. expected_keys = list(self.PAYMENT_FOLLOWUP_COLUMNS)
  1337. if not isinstance(columns, list) or not isinstance(records, list):
  1338. return self._format_error(meta)
  1339. actual_keys = []
  1340. for column in columns:
  1341. if (
  1342. not isinstance(column, dict)
  1343. or set(column) != {'key', 'name'}
  1344. or not isinstance(column.get('key'), str)
  1345. or not isinstance(column.get('name'), str)
  1346. or not column.get('name').strip()
  1347. ):
  1348. return self._format_error(meta)
  1349. actual_keys.append(column['key'])
  1350. if actual_keys != expected_keys or pagination is None:
  1351. return self._format_error(meta)
  1352. amount_keys = {
  1353. 'billed_unverified_amount', 'unbilled_amount',
  1354. 'overdue_unpaid_amount', 'billed_unverified_amount_cny',
  1355. 'unbilled_amount_cny', 'overdue_unpaid_amount_cny',
  1356. 'receipt_unverified_amount', 'current_balance',
  1357. 'credit_limit', 'bad_debt_total',
  1358. }
  1359. text_keys = {'customer_name', 'settlement_currency', 'contract_status'}
  1360. rows = []
  1361. for record in records:
  1362. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1363. return self._format_error(meta)
  1364. row = []
  1365. for key in expected_keys:
  1366. value = record[key]
  1367. if key in amount_keys:
  1368. if (
  1369. isinstance(value, bool)
  1370. or not isinstance(value, (int, float))
  1371. or not math.isfinite(float(value))
  1372. ):
  1373. return self._format_error(meta)
  1374. elif key in text_keys:
  1375. if not isinstance(value, str):
  1376. return self._format_error(meta)
  1377. else:
  1378. value = self._payment_followup_monthly_summaries(value)
  1379. if value is None:
  1380. return self._format_error(meta)
  1381. row.append(value)
  1382. rows.append(row)
  1383. headers = [
  1384. {'label': self.PAYMENT_FOLLOWUP_COLUMNS[key]}
  1385. for key in expected_keys
  1386. ]
  1387. content = {
  1388. 'headers': headers,
  1389. 'rows': rows,
  1390. 'pagination': pagination,
  1391. 'display_rules': {
  1392. 'mode': 'complete',
  1393. 'allow_summary': False,
  1394. 'allow_omit_records': False,
  1395. 'allow_omit_empty_fields': False,
  1396. 'allow_rename_fields': False,
  1397. 'preserve_record_order': True,
  1398. 'required_field_count': len(headers),
  1399. 'returned_record_count': len(rows),
  1400. 'required_value_count': len(headers) * len(rows),
  1401. 'instruction': '最终回复必须逐条展示全部客户、全部字段和全部未回款月份汇总',
  1402. },
  1403. }
  1404. return self._success_result(
  1405. content,
  1406. self._render_table(content, require_complete=True),
  1407. meta,
  1408. )
  1409. def _payment_followup_monthly_summaries(self, summaries):
  1410. if not isinstance(summaries, list):
  1411. return None
  1412. expected = set(self.PAYMENT_FOLLOWUP_MONTHLY_COLUMNS)
  1413. translated = []
  1414. for summary in summaries:
  1415. if not isinstance(summary, dict) or set(summary) != expected:
  1416. return None
  1417. amount = summary.get('unverified_amount')
  1418. if (
  1419. isinstance(amount, bool)
  1420. or not isinstance(amount, (int, float))
  1421. or not math.isfinite(float(amount))
  1422. ):
  1423. return None
  1424. if (
  1425. not isinstance(summary.get('receivable_month'), str)
  1426. or not isinstance(summary.get('is_overdue'), bool)
  1427. ):
  1428. return None
  1429. item = {}
  1430. for key, label in self.PAYMENT_FOLLOWUP_MONTHLY_COLUMNS.items():
  1431. value = summary[key]
  1432. item[label] = value
  1433. translated.append(item)
  1434. return translated
  1435. def _present_customer_unverified_bill_details(self, data, raw_meta, meta):
  1436. if set(data) != {'columns', 'records'}:
  1437. return self._format_error(meta)
  1438. columns = data.get('columns')
  1439. records = data.get('records')
  1440. pagination = self._customer_pagination(raw_meta)
  1441. expected_keys = list(self.PAYMENT_FOLLOWUP_DETAIL_COLUMNS)
  1442. if not isinstance(columns, list) or not isinstance(records, list):
  1443. return self._format_error(meta)
  1444. actual_keys = []
  1445. for column in columns:
  1446. if (
  1447. not isinstance(column, dict)
  1448. or set(column) != {'key', 'name'}
  1449. or not isinstance(column.get('key'), str)
  1450. or not isinstance(column.get('name'), str)
  1451. or not column.get('name').strip()
  1452. ):
  1453. return self._format_error(meta)
  1454. actual_keys.append(column['key'])
  1455. if actual_keys != expected_keys or pagination is None:
  1456. return self._format_error(meta)
  1457. translated = self._payment_followup_details(records)
  1458. if translated is None:
  1459. return self._format_error(meta)
  1460. headers = [
  1461. {'label': self.PAYMENT_FOLLOWUP_DETAIL_COLUMNS[key]}
  1462. for key in expected_keys
  1463. ]
  1464. rows = [[item[header['label']] for header in headers] for item in translated]
  1465. content = {'headers': headers, 'rows': rows, 'pagination': pagination}
  1466. return self._success_result(content, self._render_table(content), meta)
  1467. def _payment_followup_details(self, details):
  1468. expected = set(self.PAYMENT_FOLLOWUP_DETAIL_COLUMNS)
  1469. translated = []
  1470. for detail in details:
  1471. if not isinstance(detail, dict) or set(detail) != expected:
  1472. return None
  1473. amount = detail.get('unverified_amount')
  1474. if (
  1475. isinstance(amount, bool)
  1476. or not isinstance(amount, (int, float))
  1477. or not math.isfinite(float(amount))
  1478. ):
  1479. return None
  1480. item = {}
  1481. for key, label in self.PAYMENT_FOLLOWUP_DETAIL_COLUMNS.items():
  1482. value = detail[key]
  1483. if key != 'unverified_amount' and not isinstance(value, str):
  1484. return None
  1485. item[label] = value
  1486. translated.append(item)
  1487. return translated
  1488. def _present_customer_payment_records(self, data, raw_meta, meta):
  1489. if set(data) != {'columns', 'records'}:
  1490. return self._format_error(meta)
  1491. columns = data.get('columns')
  1492. records = data.get('records')
  1493. pagination = self._customer_pagination(raw_meta)
  1494. expected_keys = list(self.PAYMENT_RECORD_COLUMNS)
  1495. if not isinstance(columns, list) or not isinstance(records, list):
  1496. return self._format_error(meta)
  1497. actual_keys = []
  1498. for column in columns:
  1499. if (
  1500. not isinstance(column, dict)
  1501. or set(column) != {'key', 'name'}
  1502. or not isinstance(column.get('key'), str)
  1503. or not isinstance(column.get('name'), str)
  1504. or not column.get('name').strip()
  1505. ):
  1506. return self._format_error(meta)
  1507. actual_keys.append(column['key'])
  1508. if actual_keys != expected_keys or pagination is None:
  1509. return self._format_error(meta)
  1510. amount_keys = {
  1511. 'original_received_amount', 'actual_received_amount',
  1512. 'verified_amount', 'unverified_amount',
  1513. }
  1514. rows = []
  1515. for record in records:
  1516. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1517. return self._format_error(meta)
  1518. row = []
  1519. for key in expected_keys:
  1520. value = record[key]
  1521. if key in amount_keys:
  1522. if (
  1523. isinstance(value, bool)
  1524. or not isinstance(value, (int, float))
  1525. or not math.isfinite(float(value))
  1526. ):
  1527. return self._format_error(meta)
  1528. elif not isinstance(value, str):
  1529. return self._format_error(meta)
  1530. row.append(value)
  1531. rows.append(row)
  1532. headers = [
  1533. {'label': self.PAYMENT_RECORD_COLUMNS[key]}
  1534. for key in expected_keys
  1535. ]
  1536. content = {'headers': headers, 'rows': rows, 'pagination': pagination}
  1537. return self._success_result(content, self._render_table(content), meta)
  1538. def _present_order_receivable_cost_details(self, data, raw_meta, meta):
  1539. if set(data) != {'summary', 'columns', 'records'}:
  1540. return self._format_error(meta)
  1541. columns = data.get('columns')
  1542. records = data.get('records')
  1543. summary = data.get('summary')
  1544. pagination = self._customer_pagination(raw_meta)
  1545. expected_keys = list(self.RECEIVABLE_COST_COLUMNS)
  1546. expected_summary = list(self.RECEIVABLE_COST_SUMMARY)
  1547. if (
  1548. not isinstance(columns, list)
  1549. or not isinstance(records, list)
  1550. or not isinstance(summary, dict)
  1551. or set(summary) != set(expected_summary)
  1552. ):
  1553. return self._format_error(meta)
  1554. actual_keys = []
  1555. for column in columns:
  1556. if (
  1557. not isinstance(column, dict)
  1558. or set(column) != {'key', 'name'}
  1559. or not isinstance(column.get('key'), str)
  1560. or not isinstance(column.get('name'), str)
  1561. or not column.get('name').strip()
  1562. ):
  1563. return self._format_error(meta)
  1564. actual_keys.append(column['key'])
  1565. if actual_keys != expected_keys or pagination is None:
  1566. return self._format_error(meta)
  1567. summary_row = []
  1568. for key in expected_summary:
  1569. value = summary[key]
  1570. if (
  1571. isinstance(value, bool)
  1572. or not isinstance(value, (int, float))
  1573. or not math.isfinite(float(value))
  1574. ):
  1575. return self._format_error(meta)
  1576. summary_row.append(value)
  1577. numeric_keys = {
  1578. 'charge_weight', 'unit_price', 'receivable_original_amount',
  1579. 'receivable_amount_cny', 'settlement_amount_cny',
  1580. }
  1581. rows = []
  1582. for record in records:
  1583. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1584. return self._format_error(meta)
  1585. row = []
  1586. for key in expected_keys:
  1587. value = record[key]
  1588. if key in numeric_keys:
  1589. if (
  1590. isinstance(value, bool)
  1591. or not isinstance(value, (int, float))
  1592. or not math.isfinite(float(value))
  1593. ):
  1594. return self._format_error(meta)
  1595. elif not isinstance(value, str):
  1596. return self._format_error(meta)
  1597. row.append(value)
  1598. rows.append(row)
  1599. headers = [
  1600. {'label': self.RECEIVABLE_COST_COLUMNS[key]}
  1601. for key in expected_keys
  1602. ]
  1603. content = {
  1604. 'summary': {
  1605. 'headers': [
  1606. {'label': self.RECEIVABLE_COST_SUMMARY[key]}
  1607. for key in expected_summary
  1608. ],
  1609. 'row': summary_row,
  1610. },
  1611. 'headers': headers,
  1612. 'rows': rows,
  1613. 'pagination': pagination,
  1614. }
  1615. return self._success_result(
  1616. content, self._render_order_receivable_cost_details(content), meta
  1617. )
  1618. @classmethod
  1619. def _render_order_receivable_cost_details(cls, content):
  1620. lines = ['订单汇总:']
  1621. summary = content['summary']
  1622. for header, value in zip(summary['headers'], summary['row']):
  1623. lines.append('- {0}: {1}'.format(header['label'], value))
  1624. lines.append('费用明细:')
  1625. lines.append(cls._render_table({
  1626. 'headers': content['headers'],
  1627. 'rows': content['rows'],
  1628. }))
  1629. return '\n'.join(lines)
  1630. def _present_receivable_cost_list(self, data, raw_meta, meta):
  1631. if set(data) != {'columns', 'records'}:
  1632. return self._format_error(meta)
  1633. columns = data.get('columns')
  1634. records = data.get('records')
  1635. pagination = self._customer_pagination(raw_meta)
  1636. expected_keys = list(self.RECEIVABLE_LIST_COLUMNS)
  1637. if (
  1638. not isinstance(columns, list)
  1639. or not isinstance(records, list)
  1640. or len(columns) != len(expected_keys)
  1641. or pagination is None
  1642. ):
  1643. return self._format_error(meta)
  1644. for column, key in zip(columns, expected_keys):
  1645. if column != {
  1646. 'key': key,
  1647. 'name': self.RECEIVABLE_LIST_COLUMNS[key],
  1648. }:
  1649. return self._format_error(meta)
  1650. amount_keys = {
  1651. 'original_amount', 'total_amount', 'billed_amount', 'unbilled_amount',
  1652. }
  1653. rows = []
  1654. for record in records:
  1655. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1656. return self._format_error(meta)
  1657. row = []
  1658. for key in expected_keys:
  1659. value = record[key]
  1660. if key in amount_keys:
  1661. if not self._valid_amount_cell(value):
  1662. return self._format_error(meta)
  1663. elif not isinstance(value, str):
  1664. return self._format_error(meta)
  1665. row.append(value)
  1666. rows.append(row)
  1667. headers = [
  1668. {'label': self.RECEIVABLE_LIST_COLUMNS[key]}
  1669. for key in expected_keys
  1670. ]
  1671. content = {'headers': headers, 'rows': rows, 'pagination': pagination}
  1672. return self._success_result(content, self._render_table(content), meta)
  1673. def _present_payable_cost_list(self, data, raw_meta, meta):
  1674. if set(data) != {'business_type', 'company_currency', 'columns', 'records'}:
  1675. return self._format_error(meta)
  1676. business_type = data.get('business_type')
  1677. company_currency = data.get('company_currency')
  1678. if (
  1679. isinstance(business_type, bool)
  1680. or not isinstance(business_type, int)
  1681. or business_type not in self.PAYABLE_COST_COLUMNS
  1682. or not isinstance(company_currency, str)
  1683. or not company_currency.strip()
  1684. ):
  1685. return self._format_error(meta)
  1686. pagination = self._customer_pagination(raw_meta)
  1687. columns = data.get('columns')
  1688. records = data.get('records')
  1689. expected = list(self.PAYABLE_COST_COLUMNS[business_type])
  1690. if business_type == 2:
  1691. expected = [
  1692. (key, name.replace('%s', company_currency.strip().upper()))
  1693. for key, name in expected
  1694. ]
  1695. if (
  1696. not isinstance(columns, list)
  1697. or not isinstance(records, list)
  1698. or len(columns) != len(expected)
  1699. or pagination is None
  1700. ):
  1701. return self._format_error(meta)
  1702. for column, (key, name) in zip(columns, expected):
  1703. if column != {'key': key, 'name': name}:
  1704. return self._format_error(meta)
  1705. rows = []
  1706. expected_keys = [key for key, _ in expected]
  1707. for record in records:
  1708. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1709. return self._format_error(meta)
  1710. row = []
  1711. for key in expected_keys:
  1712. value = record[key]
  1713. if key in self.PAYABLE_AMOUNT_KEYS:
  1714. if (
  1715. isinstance(value, bool)
  1716. or not isinstance(value, (int, float))
  1717. or not math.isfinite(float(value))
  1718. ):
  1719. return self._format_error(meta)
  1720. elif not isinstance(value, str):
  1721. return self._format_error(meta)
  1722. row.append(value)
  1723. rows.append(row)
  1724. headers = [{'label': name} for _, name in expected]
  1725. content = {
  1726. 'business_type': business_type,
  1727. 'headers': headers,
  1728. 'rows': rows,
  1729. 'pagination': pagination,
  1730. }
  1731. return self._success_result(content, self._render_table(content), meta)
  1732. def _present_destination_trailer_list(self, data, raw_meta, meta):
  1733. if set(data) != {'trailer_stage', 'columns', 'records'}:
  1734. return self._format_error(meta)
  1735. trailer_stage = data.get('trailer_stage')
  1736. if trailer_stage == 'DO单制作':
  1737. expected = list(self.DESTINATION_TRAILER_COLUMNS['do'])
  1738. elif trailer_stage in self.DESTINATION_TRAILER_PROGRESS_STAGES:
  1739. expected = list(self.DESTINATION_TRAILER_COLUMNS['progress'])
  1740. else:
  1741. return self._format_error(meta)
  1742. pagination = self._customer_pagination(raw_meta)
  1743. columns = data.get('columns')
  1744. records = data.get('records')
  1745. if (
  1746. not isinstance(columns, list)
  1747. or not isinstance(records, list)
  1748. or len(columns) != len(expected)
  1749. or pagination is None
  1750. ):
  1751. return self._format_error(meta)
  1752. for column, (key, name) in zip(columns, expected):
  1753. if column != {'key': key, 'name': name}:
  1754. return self._format_error(meta)
  1755. rows = []
  1756. expected_keys = [key for key, _ in expected]
  1757. for record in records:
  1758. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1759. return self._format_error(meta)
  1760. row = []
  1761. for key in expected_keys:
  1762. value = record[key]
  1763. if key in self.DESTINATION_TRAILER_FILE_KEYS:
  1764. if value != '' and not self._valid_http_url(value):
  1765. return self._format_error(meta)
  1766. elif not isinstance(value, str):
  1767. return self._format_error(meta)
  1768. row.append(value)
  1769. rows.append(row)
  1770. headers = [{'label': name} for _, name in expected]
  1771. content = {
  1772. 'trailer_stage': trailer_stage,
  1773. 'headers': headers,
  1774. 'rows': rows,
  1775. 'pagination': pagination,
  1776. }
  1777. return self._success_result(content, self._render_table(content), meta)
  1778. def _present_order_abnormal_list(self, data, raw_meta, meta):
  1779. if set(data) != {'abnormal_status', 'columns', 'records'}:
  1780. return self._format_error(meta)
  1781. abnormal_status = data.get('abnormal_status')
  1782. if abnormal_status not in self.ORDER_ABNORMAL_STATUSES:
  1783. return self._format_error(meta)
  1784. expected = list(self.ORDER_ABNORMAL_COLUMNS)
  1785. pagination = self._customer_pagination(raw_meta)
  1786. columns = data.get('columns')
  1787. records = data.get('records')
  1788. if (
  1789. not isinstance(columns, list)
  1790. or not isinstance(records, list)
  1791. or len(columns) != len(expected)
  1792. or pagination is None
  1793. ):
  1794. return self._format_error(meta)
  1795. for column, (key, name) in zip(columns, expected):
  1796. if column != {'key': key, 'name': name}:
  1797. return self._format_error(meta)
  1798. rows = []
  1799. expected_keys = [key for key, _ in expected]
  1800. for record in records:
  1801. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1802. return self._format_error(meta)
  1803. row = []
  1804. for key in expected_keys:
  1805. value = record[key]
  1806. if not isinstance(value, str):
  1807. return self._format_error(meta)
  1808. row.append(value)
  1809. rows.append(row)
  1810. headers = [{'label': name} for _, name in expected]
  1811. content = {
  1812. 'abnormal_status': abnormal_status,
  1813. 'headers': headers,
  1814. 'rows': rows,
  1815. 'pagination': pagination,
  1816. }
  1817. return self._success_result(content, self._render_table(content), meta)
  1818. def _present_goods_tax(self, data, meta):
  1819. expected = {
  1820. 'estimated_tax', 'sku', 'departure_country', 'destination_country',
  1821. }
  1822. if set(data) != expected:
  1823. return self._format_error(meta)
  1824. amount = data.get('estimated_tax')
  1825. sku = data.get('sku')
  1826. departure = data.get('departure_country')
  1827. destination = data.get('destination_country')
  1828. if (
  1829. isinstance(amount, bool) or not isinstance(amount, (int, float))
  1830. or not math.isfinite(float(amount))
  1831. or not isinstance(sku, str) or not sku.strip()
  1832. or not self._country_code(departure)
  1833. or not self._country_code(destination)
  1834. ):
  1835. return self._format_error(meta)
  1836. content = {
  1837. 'estimated_tax': amount,
  1838. 'sku': sku,
  1839. 'departure_country': departure,
  1840. 'destination_country': destination,
  1841. }
  1842. text = '预计关税金额: {0}'.format(amount)
  1843. return self._success_result(content, text, meta)
  1844. @staticmethod
  1845. def _country_code(value):
  1846. return (
  1847. isinstance(value, str)
  1848. and value.isalpha()
  1849. and value.isupper()
  1850. and 2 <= len(value) <= 3
  1851. )
  1852. def _present_goods_info(self, data, raw_meta, meta):
  1853. if set(data) != {'columns', 'records'}:
  1854. return self._format_error(meta)
  1855. expected = list(self.GOODS_INFO_COLUMNS)
  1856. pagination = self._customer_pagination(raw_meta)
  1857. columns = data.get('columns')
  1858. records = data.get('records')
  1859. if (
  1860. not isinstance(columns, list)
  1861. or not isinstance(records, list)
  1862. or len(columns) != len(expected)
  1863. or pagination is None
  1864. ):
  1865. return self._format_error(meta)
  1866. for column, (key, name) in zip(columns, expected):
  1867. if column != {'key': key, 'name': name}:
  1868. return self._format_error(meta)
  1869. rows = []
  1870. expected_keys = [key for key, _ in expected]
  1871. for record in records:
  1872. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1873. return self._format_error(meta)
  1874. row = []
  1875. for key in expected_keys:
  1876. value = record[key]
  1877. if not isinstance(value, str):
  1878. return self._format_error(meta)
  1879. row.append(value)
  1880. rows.append(row)
  1881. headers = [{'label': name} for _, name in expected]
  1882. content = {
  1883. 'headers': headers,
  1884. 'rows': rows,
  1885. 'pagination': pagination,
  1886. }
  1887. return self._success_result(content, self._render_table(content), meta)
  1888. def _present_receive_volume_list(self, data, raw_meta, meta):
  1889. if set(data) != {'columns', 'records'}:
  1890. return self._format_error(meta)
  1891. expected = list(self.RECEIVE_VOLUME_COLUMNS)
  1892. pagination = self._customer_pagination(raw_meta)
  1893. columns = data.get('columns')
  1894. records = data.get('records')
  1895. if (
  1896. not isinstance(columns, list)
  1897. or not isinstance(records, list)
  1898. or len(columns) != len(expected)
  1899. or pagination is None
  1900. ):
  1901. return self._format_error(meta)
  1902. for column, (key, name) in zip(columns, expected):
  1903. if column != {'key': key, 'name': name}:
  1904. return self._format_error(meta)
  1905. rows = []
  1906. expected_keys = [key for key, _ in expected]
  1907. for record in records:
  1908. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1909. return self._format_error(meta)
  1910. row = []
  1911. for key in expected_keys:
  1912. value = record[key]
  1913. if key == 'inbound_volume':
  1914. if not self._valid_volume_cell(value):
  1915. return self._format_error(meta)
  1916. row.append(value)
  1917. continue
  1918. if not isinstance(value, str):
  1919. return self._format_error(meta)
  1920. row.append(value)
  1921. rows.append(row)
  1922. headers = [{'label': name} for _, name in expected]
  1923. content = {
  1924. 'headers': headers,
  1925. 'rows': rows,
  1926. 'pagination': pagination,
  1927. }
  1928. return self._success_result(content, self._render_table(content), meta)
  1929. def _present_container_timeliness_list(self, data, raw_meta, meta):
  1930. if set(data) != {'columns', 'records'}:
  1931. return self._format_error(meta)
  1932. expected = list(self.CONTAINER_TIMELINESS_COLUMNS)
  1933. pagination = self._customer_pagination(raw_meta)
  1934. columns = data.get('columns')
  1935. records = data.get('records')
  1936. if (
  1937. not isinstance(columns, list)
  1938. or not isinstance(records, list)
  1939. or len(columns) != len(expected)
  1940. or pagination is None
  1941. ):
  1942. return self._format_error(meta)
  1943. for column, (key, name) in zip(columns, expected):
  1944. if column != {'key': key, 'name': name}:
  1945. return self._format_error(meta)
  1946. rows = []
  1947. expected_keys = [key for key, _ in expected]
  1948. for record in records:
  1949. if not isinstance(record, dict) or set(record) != set(expected_keys):
  1950. return self._format_error(meta)
  1951. row = []
  1952. for key in expected_keys:
  1953. value = record[key]
  1954. if not isinstance(value, str):
  1955. return self._format_error(meta)
  1956. row.append(value)
  1957. rows.append(row)
  1958. headers = [{'label': name} for _, name in expected]
  1959. content = {
  1960. 'headers': headers,
  1961. 'rows': rows,
  1962. 'pagination': pagination,
  1963. }
  1964. return self._success_result(content, self._render_table(content), meta)
  1965. def _present_headhaul_document_list(self, data, raw_meta, meta):
  1966. if set(data) != {'columns', 'records'}:
  1967. return self._format_error(meta)
  1968. expected = list(self.HEADHAUL_DOCUMENT_COLUMNS)
  1969. pagination = self._customer_pagination(raw_meta)
  1970. columns = data.get('columns')
  1971. records = data.get('records')
  1972. if (
  1973. not isinstance(columns, list)
  1974. or not isinstance(records, list)
  1975. or len(columns) != len(expected)
  1976. or pagination is None
  1977. ):
  1978. return self._format_error(meta)
  1979. for column, (key, name) in zip(columns, expected):
  1980. if column != {'key': key, 'name': name}:
  1981. return self._format_error(meta)
  1982. rows = []
  1983. expected_keys = [key for key, _ in expected]
  1984. for record in records:
  1985. if not isinstance(record, dict):
  1986. return self._format_error(meta)
  1987. if set(record) != set(expected_keys + ['document_ref']):
  1988. return self._format_error(meta)
  1989. document_ref = record.get('document_ref')
  1990. if not isinstance(document_ref, str) or not document_ref.strip():
  1991. return self._format_error(meta)
  1992. if not document_ref.startswith('mhdd_'):
  1993. return self._format_error(meta)
  1994. row = []
  1995. for key in expected_keys:
  1996. value = record[key]
  1997. if key == 'safe_url':
  1998. if value != '' and not self._valid_http_url(value):
  1999. return self._format_error(meta)
  2000. row.append(value)
  2001. continue
  2002. if not isinstance(value, str):
  2003. return self._format_error(meta)
  2004. row.append(value)
  2005. row.append(document_ref.strip())
  2006. rows.append(row)
  2007. headers = [{'label': name} for _, name in expected]
  2008. headers.append({'label': '文档身份'})
  2009. content = {
  2010. 'headers': headers,
  2011. 'rows': rows,
  2012. 'pagination': pagination,
  2013. }
  2014. return self._success_result(content, self._render_table(content), meta)
  2015. def _present_headhaul_prepare(self, data, meta):
  2016. expected = {
  2017. 'upload_token', 'upload_url', 'expires_in',
  2018. }
  2019. if set(data) != expected:
  2020. return self._format_error(meta)
  2021. upload_token = data.get('upload_token')
  2022. upload_url = data.get('upload_url')
  2023. expires_in = data.get('expires_in')
  2024. if (
  2025. not isinstance(upload_token, str) or not upload_token.strip()
  2026. or not isinstance(upload_url, str)
  2027. or upload_url != '/mcp/upload-headhaul-document'
  2028. or isinstance(expires_in, bool)
  2029. or not isinstance(expires_in, int)
  2030. or expires_in <= 0
  2031. ):
  2032. return self._format_error(meta)
  2033. from services.headhaul_document_app import public_upload_url
  2034. posted_url = public_upload_url()
  2035. content = {
  2036. 'upload_token': upload_token.strip(),
  2037. 'upload_url': posted_url,
  2038. 'expires_in': expires_in,
  2039. }
  2040. result_meta = dict(meta)
  2041. result_meta['upload_token'] = upload_token.strip()
  2042. text = (
  2043. '请把对话窗口里已添加的文件 POST 到上传地址,并带上上传令牌。'
  2044. '不要使用选文件框,也不要把文件放进工具参数。'
  2045. '上传地址:{0}'
  2046. ).format(posted_url)
  2047. return self._success_result(content, text, result_meta)
  2048. def _present_headhaul_save(self, data, meta):
  2049. if set(data) != {'document_ref'}:
  2050. return self._format_error(meta)
  2051. document_ref = data.get('document_ref')
  2052. if (
  2053. not isinstance(document_ref, str)
  2054. or not document_ref.strip()
  2055. or not document_ref.startswith('mhdd_')
  2056. ):
  2057. return self._format_error(meta)
  2058. content = {'文档身份': document_ref.strip(), '结果': '已保存'}
  2059. return self._success_result(content, '头程文档已保存', meta)
  2060. def _present_headhaul_delete(self, data, meta):
  2061. if set(data) != {'result'}:
  2062. return self._format_error(meta)
  2063. result = data.get('result')
  2064. if result != '已删除':
  2065. return self._format_error(meta)
  2066. content = {'结果': '已删除'}
  2067. return self._success_result(content, '头程文档已删除', meta)
  2068. @staticmethod
  2069. def _valid_volume_cell(value):
  2070. return (
  2071. not isinstance(value, bool)
  2072. and isinstance(value, (int, float))
  2073. and math.isfinite(float(value))
  2074. )
  2075. @staticmethod
  2076. def _valid_amount_cell(value):
  2077. if not isinstance(value, dict) or set(value) != {'amount', 'currency'}:
  2078. return False
  2079. amount = value.get('amount')
  2080. return (
  2081. not isinstance(amount, bool)
  2082. and isinstance(amount, (int, float))
  2083. and math.isfinite(float(amount))
  2084. and isinstance(value.get('currency'), str)
  2085. )
  2086. def _present_receivable_cost_filter_options(self, data, raw_meta, meta):
  2087. if set(data) != {'records'}:
  2088. return self._format_error(meta)
  2089. records = data.get('records')
  2090. pagination = self._customer_pagination(raw_meta)
  2091. if not isinstance(records, list) or pagination is None:
  2092. return self._format_error(meta)
  2093. rows = []
  2094. for record in records:
  2095. if not isinstance(record, dict) or set(record) != {
  2096. 'value', 'label', 'code',
  2097. }:
  2098. return self._format_error(meta)
  2099. value = record.get('value')
  2100. label = record.get('label')
  2101. code = record.get('code')
  2102. if (
  2103. isinstance(value, bool) or not isinstance(value, int)
  2104. or not isinstance(label, str) or not label.strip()
  2105. or not isinstance(code, str)
  2106. ):
  2107. return self._format_error(meta)
  2108. rows.append([value, label.strip(), code.strip()])
  2109. content = {
  2110. 'headers': [
  2111. {'label': '可传值'}, {'label': '显示名称'}, {'label': '业务编码'},
  2112. ],
  2113. 'rows': rows,
  2114. 'pagination': pagination,
  2115. }
  2116. return self._success_result(content, self._render_table(content), meta)
  2117. @staticmethod
  2118. def _customer_billing_modes(value):
  2119. if not isinstance(value, list):
  2120. return None
  2121. result = []
  2122. business_types = set()
  2123. for item in value:
  2124. if not isinstance(item, dict) or set(item) != {
  2125. 'business_type', 'settlement_mode',
  2126. }:
  2127. return None
  2128. business_type = item.get('business_type')
  2129. settlement_mode = item.get('settlement_mode')
  2130. if (
  2131. not isinstance(business_type, str) or not business_type.strip()
  2132. or not isinstance(settlement_mode, str) or not settlement_mode.strip()
  2133. or business_type in business_types
  2134. ):
  2135. return None
  2136. business_types.add(business_type)
  2137. result.append({
  2138. '业务类型': business_type.strip(),
  2139. '结算模式': settlement_mode.strip(),
  2140. })
  2141. return result
  2142. def _present_customer_options(self, data, raw_meta, meta):
  2143. if set(data) != {'records'}:
  2144. return self._format_error(meta)
  2145. records = data.get('records')
  2146. pagination = self._customer_pagination(raw_meta)
  2147. if not isinstance(records, list) or pagination is None:
  2148. return self._format_error(meta)
  2149. rows = []
  2150. for record in records:
  2151. if not isinstance(record, dict) or set(record) != {'value', 'label', 'code'}:
  2152. return self._format_error(meta)
  2153. value = record.get('value')
  2154. label = record.get('label')
  2155. code = record.get('code')
  2156. if (
  2157. isinstance(value, bool) or not isinstance(value, int) or value < 1
  2158. or not isinstance(label, str) or not label.strip()
  2159. or not isinstance(code, str)
  2160. ):
  2161. return self._format_error(meta)
  2162. rows.append([value, label.strip(), code.strip()])
  2163. content = {
  2164. 'headers': [
  2165. {'label': '可传值'}, {'label': '显示名称'}, {'label': '业务编码'},
  2166. ],
  2167. 'rows': rows,
  2168. 'pagination': pagination,
  2169. }
  2170. return self._success_result(content, self._render_table(content), meta)
  2171. @staticmethod
  2172. def _customer_pagination(raw_meta):
  2173. if not isinstance(raw_meta, dict):
  2174. return None
  2175. required = {'page', 'limit', 'has_more'}
  2176. if (
  2177. not required.issubset(raw_meta)
  2178. or not set(raw_meta).issubset(required | {'request_id'})
  2179. ):
  2180. return None
  2181. page = raw_meta.get('page')
  2182. limit = raw_meta.get('limit')
  2183. has_more = raw_meta.get('has_more')
  2184. if (
  2185. isinstance(page, bool) or not isinstance(page, int)
  2186. or page < 1 or page > 100
  2187. or isinstance(limit, bool) or not isinstance(limit, int)
  2188. or limit < 1 or limit > 100
  2189. or not isinstance(has_more, bool)
  2190. ):
  2191. return None
  2192. return {'page': page, 'limit': limit, 'has_more': has_more}
  2193. def _present_outbound_detail(self, tool_name, data, raw_meta, meta):
  2194. summary = data.get('summary')
  2195. columns = data.get('columns')
  2196. records = data.get('records')
  2197. if not isinstance(summary, dict):
  2198. return self._format_error(meta)
  2199. if not isinstance(columns, list) or not columns or not isinstance(records, list):
  2200. return self._format_error(meta)
  2201. if any(key not in summary for key in self.OUTBOUND_DETAIL_SUMMARY):
  2202. return self._format_error(meta)
  2203. allowed_columns = self.TABLE_COLUMNS.get(tool_name)
  2204. headers = []
  2205. keys = []
  2206. for column in columns:
  2207. if not isinstance(column, dict):
  2208. return self._format_error(meta)
  2209. key = column.get('key')
  2210. definition = allowed_columns.get(key) if isinstance(key, str) else None
  2211. if not isinstance(definition, tuple) or not definition:
  2212. return self._format_error(meta)
  2213. keys.append(key)
  2214. headers.append({'label': definition[0]})
  2215. rows = []
  2216. for record in records:
  2217. if not isinstance(record, dict):
  2218. return self._format_error(meta)
  2219. row = []
  2220. for key in keys:
  2221. value = '' if record.get(key) is None else record.get(key, '')
  2222. if key == 'customs_files':
  2223. if not isinstance(value, list):
  2224. return self._format_error(meta)
  2225. files = []
  2226. for item in value:
  2227. if not isinstance(item, dict):
  2228. return self._format_error(meta)
  2229. files.append({
  2230. '文件名称': item.get('file_name', ''),
  2231. '文件类型': item.get('file_type', ''),
  2232. '文件链接': item.get('file_url', ''),
  2233. })
  2234. value = files
  2235. row.append(value)
  2236. rows.append(row)
  2237. summary_keys = list(self.OUTBOUND_DETAIL_SUMMARY.keys())
  2238. content = {
  2239. 'summary': {
  2240. 'headers': [
  2241. {'label': self.OUTBOUND_DETAIL_SUMMARY[key]}
  2242. for key in summary_keys
  2243. ],
  2244. 'row': [summary.get(key, '') for key in summary_keys],
  2245. },
  2246. 'details': {
  2247. 'headers': headers,
  2248. 'rows': rows,
  2249. },
  2250. }
  2251. tips = self._safe_tips(data.get('tips'))
  2252. if tips:
  2253. content['details']['tips'] = tips
  2254. pagination = self._build_pagination(raw_meta)
  2255. if pagination:
  2256. content['details']['pagination'] = pagination
  2257. return self._success_result(
  2258. content,
  2259. self._render_outbound_detail(content),
  2260. meta,
  2261. )
  2262. @classmethod
  2263. def _render_outbound_detail(cls, content):
  2264. lines = ['排舱汇总:']
  2265. summary = content['summary']
  2266. for header, value in zip(summary['headers'], summary['row']):
  2267. lines.append('- {0}: {1}'.format(header['label'], value))
  2268. lines.append('订单明细:')
  2269. details = content['details']
  2270. lines.append('表头共 {0} 列:'.format(len(details['headers'])))
  2271. for index, header in enumerate(details['headers'], start=1):
  2272. lines.append('{0}. {1}'.format(index, header['label']))
  2273. for index, row in enumerate(details['rows'], start=1):
  2274. lines.append('记录 {0}:'.format(index))
  2275. for header, value in zip(details['headers'], row):
  2276. if isinstance(value, (dict, list)):
  2277. value = json.dumps(value, ensure_ascii=False)
  2278. lines.append('- {0}: {1}'.format(header['label'], value))
  2279. tips = details.get('tips') or []
  2280. if tips:
  2281. lines.append('提示:{0}'.format(';'.join(tips)))
  2282. return '\n'.join(lines)
  2283. def _present_options(self, data, raw_meta, meta):
  2284. records = data.get('records')
  2285. if not isinstance(records, list):
  2286. return self._format_error(meta)
  2287. rows = []
  2288. for record in records:
  2289. if not isinstance(record, dict):
  2290. return self._format_error(meta)
  2291. rows.append([
  2292. record.get('value', ''),
  2293. self._safe_text(record.get('label')),
  2294. self._safe_text(record.get('code')),
  2295. ])
  2296. content = {
  2297. 'headers': [
  2298. {'label': '可传值'},
  2299. {'label': '显示名称'},
  2300. {'label': '业务编码'},
  2301. ],
  2302. 'rows': rows,
  2303. }
  2304. pagination = self._build_pagination(raw_meta)
  2305. if pagination:
  2306. content['pagination'] = pagination
  2307. return self._success_result(content, self._render_table(content), meta)
  2308. def _present_export_submission(self, data, meta):
  2309. expected = {'task_ref', 'status', 'retry_after_seconds'}
  2310. if set(data) != expected:
  2311. return self._format_error(meta)
  2312. task_ref = data.get('task_ref')
  2313. retry_after = data.get('retry_after_seconds')
  2314. if (
  2315. not isinstance(task_ref, str) or not task_ref.strip()
  2316. or data.get('status') != 'queued'
  2317. or isinstance(retry_after, bool)
  2318. or not isinstance(retry_after, int)
  2319. or retry_after <= 0
  2320. ):
  2321. return self._format_error(meta)
  2322. task = {
  2323. 'task_ref': task_ref.strip(),
  2324. 'status': 'queued',
  2325. 'retry_after_seconds': retry_after,
  2326. }
  2327. content = {
  2328. 'message': '导出任务已提交',
  2329. 'task': task,
  2330. }
  2331. text = (
  2332. '导出任务已提交\n'
  2333. '- 任务引用: {0}\n'
  2334. '- 建议 {1} 秒后单独查询任务状态'
  2335. ).format(task['task_ref'], retry_after)
  2336. return self._success_result(content, text, meta)
  2337. def _present_export_task(self, data, meta):
  2338. task_ref = data.get('task_ref')
  2339. status = data.get('status')
  2340. if (
  2341. not isinstance(task_ref, str)
  2342. or not task_ref.strip()
  2343. or status not in ('queued', 'running', 'completed', 'failed')
  2344. ):
  2345. return self._format_error(meta)
  2346. task = {'task_ref': task_ref.strip(), 'status': status}
  2347. if status in ('queued', 'running'):
  2348. if set(data) != {'task_ref', 'status', 'retry_after_seconds'}:
  2349. return self._format_error(meta)
  2350. retry_after = data.get('retry_after_seconds')
  2351. if (
  2352. isinstance(retry_after, bool)
  2353. or not isinstance(retry_after, int)
  2354. or retry_after <= 0
  2355. ):
  2356. return self._format_error(meta)
  2357. task['retry_after_seconds'] = retry_after
  2358. label = '等待中' if status == 'queued' else '生成中'
  2359. content = {'message': '导出任务{0}'.format(label), 'task': task}
  2360. text = (
  2361. '导出任务{0}\n- 任务引用: {1}\n- 建议 {2} 秒后再次查询'
  2362. ).format(label, task['task_ref'], retry_after)
  2363. return self._success_result(content, text, meta)
  2364. if status == 'failed':
  2365. if set(data) != {'task_ref', 'status'}:
  2366. return self._format_error(meta)
  2367. content = {'message': '导出任务失败,请重新提交', 'task': task}
  2368. text = '导出任务失败,请重新提交'
  2369. return self._success_result(content, text, meta)
  2370. if set(data) != {'task_ref', 'status', 'files'}:
  2371. return self._format_error(meta)
  2372. files = data.get('files')
  2373. if not isinstance(files, list) or not files:
  2374. return self._format_error(meta)
  2375. safe_files = []
  2376. for item in files:
  2377. if not isinstance(item, dict) or set(item) != {'label', 'url'}:
  2378. return self._format_error(meta)
  2379. label = item.get('label')
  2380. url = item.get('url')
  2381. if (
  2382. not isinstance(label, str) or not label.strip()
  2383. or not self._valid_http_url(url)
  2384. ):
  2385. return self._format_error(meta)
  2386. safe_files.append({'label': label.strip(), 'url': url.strip()})
  2387. content = {
  2388. 'message': '文件已生成',
  2389. 'task': task,
  2390. 'files': safe_files,
  2391. }
  2392. lines = ['文件已生成']
  2393. for item in safe_files:
  2394. lines.append('- {0}: {1}'.format(item['label'], item['url']))
  2395. return self._success_result(content, '\n'.join(lines), meta)
  2396. def _valid_http_url(self, value):
  2397. if not isinstance(value, str) or not value.strip():
  2398. return False
  2399. if value != value.strip() or '\\' in value or any(
  2400. character.isspace() or ord(character) < 32 or ord(character) == 127
  2401. for character in value
  2402. ):
  2403. return False
  2404. try:
  2405. parsed = urlparse(value)
  2406. port = parsed.port
  2407. return (
  2408. parsed.scheme in ('http', 'https')
  2409. and bool(parsed.hostname)
  2410. and parsed.username is None
  2411. and parsed.password is None
  2412. and (port is None or 0 < port <= 65535)
  2413. )
  2414. except ValueError:
  2415. return False
  2416. def _business_error(self, tool_name, code, raw_message, meta):
  2417. message = str(raw_message or '').strip()
  2418. if tool_name == 'trial_goods_tax' and message in self.TAX_TRIAL_MESSAGES:
  2419. safe_code = code if code in self.ERROR_MESSAGES else 'MCP_9001'
  2420. retryable = safe_code not in self.NON_RETRYABLE_CODES
  2421. return self._error_result(safe_code, message, retryable, meta)
  2422. if code not in self.ERROR_MESSAGES and code != 'MCP_1401':
  2423. logger.warning(
  2424. 'Unknown MCP business error code',
  2425. extra={
  2426. 'request_id': meta.get('request_id', ''),
  2427. 'tool_code': tool_name,
  2428. 'backend_code': code,
  2429. 'response_code': 'MCP_9001',
  2430. 'diagnostic_reason': 'UNEXPECTED_EXCEPTION',
  2431. },
  2432. )
  2433. code = 'MCP_9001'
  2434. if code == 'MCP_1401':
  2435. label = self._find_field_label(tool_name, raw_message)
  2436. message = self._parameter_message(label)
  2437. elif tool_name in self.FREIGHTOWER_TRACK_TOOLS:
  2438. allowed = str(raw_message or '').strip()
  2439. if allowed not in (
  2440. '暂时没有飞驼轨迹',
  2441. '未找到本公司排舱单',
  2442. '匹配到多票排舱单,请同时提供提单号和柜号',
  2443. '未找到飞驼轨迹订单',
  2444. '飞驼查询超时',
  2445. '飞驼查询失败',
  2446. ):
  2447. message = self.ERROR_MESSAGES.get(code, self.ERROR_MESSAGES['MCP_9001'])
  2448. else:
  2449. message = allowed
  2450. else:
  2451. message = self.ERROR_MESSAGES[code]
  2452. retryable = code not in self.NON_RETRYABLE_CODES
  2453. return self._error_result(code, message, retryable, meta)
  2454. def _find_field_label(self, tool_name, raw_message):
  2455. message = str(raw_message or '')
  2456. fields = self.FIELD_LABELS.get(tool_name, {})
  2457. for field in sorted(fields, key=len, reverse=True):
  2458. if field in message:
  2459. return fields[field]
  2460. return ''
  2461. @staticmethod
  2462. def _parameter_message(label):
  2463. return '{0}参数不正确'.format(label) if label else '工具参数不正确,请检查后重试'
  2464. @staticmethod
  2465. def _build_meta(raw_meta):
  2466. if not isinstance(raw_meta, dict):
  2467. return {}
  2468. request_id = raw_meta.get('request_id')
  2469. if not isinstance(request_id, str) or not request_id.strip():
  2470. return {}
  2471. return {'request_id': request_id.strip()}
  2472. @staticmethod
  2473. def _build_pagination(raw_meta):
  2474. if not isinstance(raw_meta, dict):
  2475. return {}
  2476. return {
  2477. key: raw_meta[key]
  2478. for key in ('page', 'limit', 'has_more', 'total')
  2479. if key in raw_meta
  2480. }
  2481. @staticmethod
  2482. def _safe_text(value):
  2483. if value is None:
  2484. return ''
  2485. return str(value).strip()
  2486. @classmethod
  2487. def _safe_tips(cls, value):
  2488. if not isinstance(value, list):
  2489. return []
  2490. return [cls._safe_text(item) for item in value if cls._safe_text(item)]
  2491. @classmethod
  2492. def _render_table(cls, content, require_complete=False):
  2493. headers = content.get('headers') or []
  2494. rows = content.get('rows') or []
  2495. lines = []
  2496. if require_complete:
  2497. lines.append('完整客户数据,禁止摘要、合并、隐藏字段或省略空字段。')
  2498. lines.append(
  2499. '本页记录数:{0};每条字段数:{1};应展示字段值总数:{2}。'.format(
  2500. len(rows), len(headers), len(rows) * len(headers)
  2501. )
  2502. )
  2503. summary = cls._safe_text(content.get('summary'))
  2504. if summary:
  2505. lines.append(summary)
  2506. lines.append('表头共 {0} 列:'.format(len(headers)))
  2507. for index, header in enumerate(headers, start=1):
  2508. lines.append('{0}. {1}'.format(index, header['label']))
  2509. for index, row in enumerate(rows, start=1):
  2510. lines.append('记录 {0}:'.format(index))
  2511. for header, value in zip(headers, row):
  2512. if isinstance(value, (dict, list)):
  2513. value = json.dumps(value, ensure_ascii=False)
  2514. lines.append('- {0}: {1}'.format(header['label'], value))
  2515. tips = content.get('tips') or []
  2516. if tips:
  2517. lines.append('提示:{0}'.format(';'.join(tips)))
  2518. if require_complete:
  2519. lines.append(
  2520. '展示完整性校验:已提供{0}条客户的全部{1}个字段。'.format(
  2521. len(rows), len(headers)
  2522. )
  2523. )
  2524. return '\n'.join(lines)
  2525. return self._success_result(content, '\n'.join(lines), meta)
  2526. def _present_freightower_track(self, data, meta):
  2527. if set(data) != {'schedule', 'ports', 'tracks'}:
  2528. return self._format_error(meta)
  2529. schedule = data.get('schedule')
  2530. ports = data.get('ports')
  2531. tracks = data.get('tracks')
  2532. schedule_keys = (
  2533. 'bl_number', 'container_code', 'vessel', 'voyage', 'etd', 'eta',
  2534. )
  2535. if (
  2536. not isinstance(schedule, dict)
  2537. or set(schedule) != set(schedule_keys)
  2538. or not isinstance(ports, list)
  2539. or not isinstance(tracks, list)
  2540. ):
  2541. return self._format_error(meta)
  2542. labels = {
  2543. 'bl_number': '提单号',
  2544. 'container_code': '柜号',
  2545. 'vessel': '船名',
  2546. 'voyage': '航次',
  2547. 'etd': '预计离港',
  2548. 'eta': '预计到达',
  2549. }
  2550. safe_schedule = {}
  2551. for key in schedule_keys:
  2552. value = schedule.get(key)
  2553. if not isinstance(value, str):
  2554. return self._format_error(meta)
  2555. safe_schedule[labels[key]] = value
  2556. safe_ports = []
  2557. for port in ports:
  2558. if not isinstance(port, dict) or set(port) != {
  2559. 'place_type', 'port_name', 'eta', 'ata',
  2560. }:
  2561. return self._format_error(meta)
  2562. if port['place_type'] not in ('中转港', '目的港', '交货地'):
  2563. return self._format_error(meta)
  2564. for key in ('port_name', 'eta', 'ata'):
  2565. if not isinstance(port[key], str):
  2566. return self._format_error(meta)
  2567. safe_ports.append({
  2568. '地点类型': port['place_type'],
  2569. '港口': port['port_name'],
  2570. '预计到达': port['eta'],
  2571. '实际到达': port['ata'],
  2572. })
  2573. safe_tracks = []
  2574. for track in tracks:
  2575. if not isinstance(track, dict) or set(track) != {
  2576. 'time', 'location', 'content', 'event_code',
  2577. }:
  2578. return self._format_error(meta)
  2579. for key in ('time', 'location', 'content', 'event_code'):
  2580. if not isinstance(track[key], str):
  2581. return self._format_error(meta)
  2582. safe_tracks.append({
  2583. '时间': track['time'],
  2584. '地点': track['location'],
  2585. '内容': track['content'],
  2586. '状态代码': track['event_code'],
  2587. })
  2588. content = {
  2589. '船期': safe_schedule,
  2590. '港口': safe_ports,
  2591. '轨迹': safe_tracks,
  2592. }
  2593. lines = ['飞驼船期']
  2594. for label, value in safe_schedule.items():
  2595. lines.append('- {0}: {1}'.format(label, value))
  2596. lines.append('港口')
  2597. if not safe_ports:
  2598. lines.append('- 无')
  2599. for port in safe_ports:
  2600. lines.append(
  2601. '- {0} {1} 预计到达 {2} 实际到达 {3}'.format(
  2602. port['地点类型'], port['港口'], port['预计到达'], port['实际到达'],
  2603. )
  2604. )
  2605. lines.append('轨迹')
  2606. if not safe_tracks:
  2607. lines.append('- 无')
  2608. for track in safe_tracks:
  2609. lines.append(
  2610. '- {0} {1} {2} {3}'.format(
  2611. track['时间'], track['地点'], track['内容'], track['状态代码'],
  2612. )
  2613. )
  2614. return self._success_result(content, '\n'.join(lines), meta)
  2615. @staticmethod
  2616. def _success_result(content, text, meta):
  2617. return {
  2618. 'structured_content': content,
  2619. 'text': text,
  2620. 'is_error': False,
  2621. 'meta': meta,
  2622. }
  2623. @staticmethod
  2624. def _error_result(code, message, retryable, meta=None):
  2625. return {
  2626. 'structured_content': {
  2627. 'code': code,
  2628. 'message': message,
  2629. 'retryable': retryable,
  2630. },
  2631. 'text': '{0}: {1}'.format(code, message),
  2632. 'is_error': True,
  2633. 'meta': meta or {},
  2634. }
  2635. @classmethod
  2636. def _format_error(cls, meta=None):
  2637. return cls._error_result(
  2638. 'MCP_9001',
  2639. '工具返回格式异常',
  2640. True,
  2641. meta,
  2642. )