Files
notes/excalidraw/工作相关/需求-7.11.0 自动化数据统计.md
2026-03-01 01:43:46 +08:00

92 lines
7.9 KiB
Markdown
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
---
excalidraw-plugin: parsed
tags: [excalidraw]
---
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plugin settings under 'Saving'
# Excalidraw Data
## Text Elements
获取所有 ESOP 企业
id, enterpriseName, ecId, enterpriseCpId, enterProvince ^ejV7Ht3v
1. 通过 order_info 获取所有 ESOP 企业(ec_id)对应的 2试用工单、3业务受理工单、5业务暂停工单、8业务恢复工单。
【ecIdOrderMap】 ^D6IfXsdp
2. 通过 test_order_change_record 获取所有的试用阶段记录。
【testRecordsMapkey 是试用单号】 ^uiXAiLlW
3. 通过 bbossorder_info、OrderInfo、ProductIdInfo 获得订购ID、工单号、试用单号、是否首次开通、开通阶段、商用开始结束时间
【commercialOrderMapkey 是商用单号】 ^8Xd4CxVB
4. 通过 ep_product_info 获取试用结束未停服的工单号。
【trialFinishNotStopServicePreOrderNums】 ^C08OOsAc
6. 通过上方 order_info 的结果过滤出试用单,在 testorder_info 查询
【testOrderMap】 ^6cBcohEc
5. 通过 orderstatus_update_info 获取所有试用暂停恢复单,根据订购分组。
【pauseResumeMap】 ^E21P4ZlP
7. 通过上方,获得已完成的首次开通过的开通时间不为空的试用单到开通时间的映射。
【bizRequestToBusinessStartTimeMap】 ^2GCo3T7v
%%
## Drawing
```compressed-json
N4KAkARALgngDgUwgLgAQQQDwMYEMA2AlgCYBOuA7hADTgQBuCpAzoQPYB2KqATLZMzYBXUtiRoIACyhQ4zZAHoFAc0JRJQgEYA6bGwC2CgF7N6hbEcK4OCtptbErHALRY8RMpWdx8Q1TdIEfARcZgRmBShcZQUebQBGABZtAAYaOiCEfQQOKGZuAG1wMFAwMogSbgh9IwAhAGYoAEEABXiAERgmgDl6DgBZADVcADYAcVwAUXSyyFhEKsDsKI5l
YJnyzG5nEZ4ADn5ymG2AVkST7UTz+vieE8PIChJ1bluU++LISQRCZWlX+IAdgeEGsa3EqBSIOYUFIbAA1ggAMJsfBsUhVADE8QQOJxG0gmlw2HhyjhQg4xBRaIxElh1mYcFwgVyBIgADNCPh8ABlWDrCSCDxsmFwxEAdWekm4fE+EFFCIQfJgAvQQsqIPJfw44XyaHiILYTOwamO+pSULlZOEcAAksQ9agCgBdEHs8jZe3cDhCbkgwiUrBVXBpTX
CSk65iO0qzaDwCH1T4AX2hCAQxFeJxOAE49ol6jwUtmQYwWOwuPr9iWmKxON1OGJuHsePFdoDEtmPrHCMx2pkoOnuOyCGEQZpw8RJsFsrlHS6QUI4MRcAOM/rAWd6nt6id4tmRnmQUQOPDvb78Ee2CTB2hh/gwsUU8UY5BKhIEAArQaAgASUHq9BsvMELQFgUBslsaDOAWsqxmaqDOLuKSXNctxduUTzEC8aAnPU9TaNmgKdrhPCkSMJy7CC3y/P
8OGWrGYKqvR5QKoi1LolieK4kgY7EqS5KUuxtLoPSHCMsyOTgW6XK8vyIHqhm0KwoqkpYdKaCwSxymIsqqryqiGpylqkiRo6BpykaxKmq8Fogtai72nOrpyu6uCemuqA+n6coBsQQYSLgiRsgJxCmWe3mxmEN6oJ2uw8CM9TnNWZacK8IzFnKpa1hw9YcI2+onER2bZjwgLxOZ3a9v20V3qOcrjhSk7TpJTkLkuK7RUCm7biVJzNvUR4BqeaBeRe
cpoteHm1QgIIDpg4ESIA7cGAGvKgACRoAkOaoJMPIAPItKggCA8oAWHIADocCQ1CoJJTBwKQPYIN0bkzVd2D2pd12kLd91InaxDvbkTAtHCZh5TxRmUAAKmBVQrRtW27ftx1nRdV0A59d1hI92Tva9f2owO6Pfb9/0E0DbAg42bqcFAPKEEYEKFlTuQAGJuVy8HoXMYFNEQygVugwTslJmVMFA5gEDzvz89ARpsnouS4AGTBeiN56Gnd/gEFD80w
2tm3bXth2nedeMfV9mNPTjb34zdGPIsTNukGTFNgwxQhQGwABK4R0xCsJCDN41Kz+Px/AtqDxNodyPocL4VB5EDOJIIyEBDAAaH7ZgAihQPJp1n9SEPuHAjBQzhAfGiwIMsjGu5s2wjK2ILwdB7YobhaEgph2ER/EewHHK1Fh9w5EDwxqxMUpYrIqiHESNi3H4rxJL2YJs/CdA5BiUyLLC7GnLcrp8kGYpcqsQgqk95pAjaUqclVApwXCNquqvIa
xrWeazGQPZv2tS5HoEAq08mrHygZILoFwCcJ+jUwpoBfHMSuaBEyzCfJFNMHl4g7g7NuPYQJkrZQBNfBgNZyy5XyhHCiPAtw3BSGPcoPY+zBFXEOEcgdYwNUpFOLILVCjOVjIuZcLD1xnCuHcHMLYMqxmPMNEBEVygTURFNNhMdnw+QTu0EYtp2Rp2YMQOAFcFh0mhiCCBiFCrN22HhPY7cbh3C7lKAEKQ4j1GKqPQsdjOZSFDrRVAJxv6ggnhCA
J58hKcUXnXQkfFV5UnXlUUS4ld5sgPrJFUx9hRTxUo4jSmSdL30FCfGBL8oxvwsh/WANkAm/0cnwt0gDgGjX9OA4MgIYERlfqreRAgMGvE7NmJIiQUiuIIeWV4iQKrlCymQhsEJcy7kSCMFIVx/RVWYTVNhY4JzcJnHkWpcpBEdUwRuK4iRqH+KLF4mR4UxrSKvEo1h952HlDmuHCAkdUCACwEwA4/GoHRH5UgAB9AM7I2CoFhvrBGRtAAQ/9XIF
xBACQ/4AT+1AApeoAELdeCAFXowAFK6AFPdQAqsqAEAGeoR1ACFSoAdeVABgLviglJxSWACCzQAOgrUr2KSwARgaAFhNfFgAgBjOoABAZq72h2qQf5/RcBwEAIgMwVIbQwkO875vzhVMCBRwEFYK9bw0NsdGF2A4VIrRZi3FhLiXkqpYS2lJLGXMrZZyvFPKOD8txkKkVYrJVMxpr7GUASQUszZvgDms1ua82loLPekzRbi3wJLPm8TZYgnllEJW
pAGmgNjOiX4AYtYyvQHKn5fylXAtBeCjViMjrat1Si9FPBsXUuNZS6l5rLWEpZSSjl3K+UCuIE6pgoqJVslwO7L2Pt6bcH9k8yAx4EAhxouHSO0cyhoJKOoqoQhCBpyaIQAAMvgcUhiQIvIgqcCilioLxUjlcDu9i5Td3Un4vYFwUh7kBBuVxKRdheKHr4/xIJa7cBCbfMJ88uJL3qtEkKAGRJb0SZJZJMkj4P0Kbki+2TeCIbgwUjJRln4mQ6RH
d+VkKlfzsuSP+ez971I8o0sBfkIGgmzG00KOHKPoOiqPLMVCvFTNSvqJKIsUo5RmTKcirjyKDJWUwhAwjUDTU2Y1bZvC0Dzn2e1STXUTl3B4IRbMASrmdJuQou56zHkBp1hIOInyfkDhhACvNgLsCSDBAgAFSw/lqo2qi7FgA2NMAK3WgAG6MAKr6dreWWagN7PQwrmA9sADD/iIYCoEAPRm2K8WAHflV14MKDa1eWZ+VwXrOKts/Z1YjnnPCtc+
tdzWLvP+cC8F0LfyItiuiwgWLCWsXJdS/vamtNh0aS9dTVm+h2bcC8S8qNwaEBCzZKWMW7hRsxoMXG6misdRJooym8oabNb4Ay1ULLFnwhQFy/8gFdmHNOeri58F5XKsBb5TV874Wosxfi4llLfaB3e1YN11Ao7Bo6incPfUUcTiqLKHHN86A9hp2IIkJEmBBi1F3fEkxcozFZkSMehC8Qcy2M7le5D8Q6FnvqEWOhHjcexg/eHK4qQLS07p7TpI
36gm/sQ+BiAC8uJsiJCvMDcS6SQZ3tB6Sh98lqgQ2fW+l8b3EPPmhsXGHYzGTgbhsp+H4IE6qcRmpCn+HlFcu5a5TTqPBiaPR5XTGWI9JwoCUeZVyojK46gPCUiw18fIRCJIRZTlbiWWJ6qyijP1S2c1WcpHygHJU8csRJwNNEW00NQ340DMB7qrGfdEh8LmdQJoccUYbPKpBQSrtSaVVsAJWTYgQhlj2ltKXsFgB0/UAEXRgBaWNtO0Al+KksEp
ewSuLgAyFUAGmZgBCa0AAD6HyCVj+8wSwAYqpYpH4Aac1ADLfoAfXNABvpoAF9S+V6H0NkUQVh8DF8e01+Ls+2tSvS1miAmf5U57YHnvLBey/F9r4XivVeoA17r4tJvrf2+d+761l3v3sPmPhPh8lPrPgvivhvlvgYLviaAQIfg1k9nFqfq9m6l1h7oCNoIsvTnge8G6v1oNjhMZs0EGlUCGpNuGjNuQXSLGnKPGktsrKtl0hABthmltpftfj8rf
vfkdgWkXnli/mXm/tXsQMIQ3i3m3h3slgAbIcAaPuPpPl5jPnPkvmvpvvatvvAfvkgXAI1s1mge1uUP2h7B9h6mgD9kHH9j4jOkDiDout2AnEiHQjtDtMwE0NgIjsYjrKYoel4i3HmDjperGNekNi2ARERHej1HmPUBuFRLYUNgEj+mgH+tPGzhztxFzqBhOGzgkoLqyMLqknpI/IhlLjKKhqLvpAruUErjhhMpAJZCaARhHLZFaFrg6GHpAPrkA
iwXpq+M0gFAjmGLAoxmtt0tFIWHgoCIlLcA0SQnxjKH3A7vxqDK8Hek+s+iMOjj5KshJoZqnuUJwk1DwqHjrm1EIp1FHqcrhMTjbr9rIhbuOsng8ocVzCZugMkFnggHAACrdGwJXssI/mqtiivoAFTmDKgAsOaoqd7VZ3QEDMwBg9iSD1g0wexwA8hMBmBiBAwIDF7dBCD6DMDGGQDkAX4fEQBfHyo/F/FwiAkHYFoglYrglQkwnJZwn76InnTMA
olsBolGiYmkDYkIC4n4mEnEnJKdYWG8C9Y+oDZ+pDakGzYSCUHJTTYSy0EiT0GxiMGJrJqsHsEcCZoUlUk/I0n/H0nAkrSgnL4QnQmwm3bwn4BcnImol8gClYnmAimBBilEkkmgjvZDp+ykABy/aTqJGA5zpgALpg4JwjDYC1B6CSCTBeGzRIIiTI6xio5fpyjwT9LaBo4HjxF45qQjwLKpDFREQ8CJB7BLIHj0JfARl+LJHM6pGs587oCZHAYcI
5GNR5EC4SSFEuSwZVGlES7TzlE5LjmKhy7VGGSK5YbK7zFNGfytGa42ja5Oi67dHkaJ7diDGQLtBm5jGsFRQeTjLOJ9wjAJQrHcDE47GxicarEUKJAzHZg4JVi7HiaSbSZB6yYh67LnFKaXFHKiI3F4QpD3HWGPHjEQCKIHFjqgQUkjDaDmaABQcoAJ2mCq/BdeqKi+gAOeZfKAAndoAF+KiWkWgAFOrfb7b56MmACn5oAEfRt2+2eh/pZJ22EgK
F6FWFtFuFBFxFZFrWlF1FMIvFqqjFzFMIrFkpuQmBnqhBvq/qcoI2mpcF42oakAU2EaypWp82DBi2epfR6s6aRpnByFqF3ymF2F+afFhFpF5FVFwWYloKEl9qwW0l36gZn2wZoZ1h4Z06rw9h86scS6EgkwLYLQiQAAWvgC0N4Rmb4SjqcDWRjskIWXsMWaEchmVMhG+bWWVPsFppRIPE2TmePOCCztOWxB2ezkBpEhANzvxLkTVfkYORpRyCOWk
vBjUTfBOchjLrfLOWOQuX4NhiUvqHhs0erm0bGNUp0UBWRk9Pqf0RUAeaCNMCMe0uNXIitWeWlBRFmO+eRLefqMVCse7k2ICBpulDMcQowv7q8YhccXJmcVuRcYcq8NcXcBBVBdIgnrppeJNI9aQVUBcFnjZjCCuEIMwAChHo5oyeCtioyhynipFoAJwWgAdsYt6ABgSoACN+gWTI0NCAH2hJCAPabF0qFJYN8qENUQUA0NsNym8NX+esSNDKKN6
NWNzeeNBN/aYQJN2Q5NMl7qX2jMLkfWilipylgaUsFB6lVBpA6pkaql6JcsBly2y1xlm2HF6A1NuaeWkN9NMNcNVprNWKyN7KqNmNON+NfKhN/N4QpNQtnlZhQZI6IZiFE6/2vis6wOwVaiThO2YwKI9QEMgIgEaZRiCV7V2ZARn12B6VmVGE2V2xOBgyD6CyNZ+YSdjZAVdETOFVbZVVM8NI4SnOy8TVfZLVA5SSRRQ14ukUku/VlRXV6G85tRi
59Rk1q5GuRGG581b1ACS1RlVG/kkCzMx521Tx8oVuEc9ZSy1ZMxJ1vA+Y51Amp1xOCU7wBYfuayKeT1wepxgFg9AiTNoFamtxkFIwDxe5+mQNt4Gy0tFJ2B3FkW3+gAT7qAAx2oAAhGqKIB3yqKY+G+gAsHKABccoAF5e5WeKgADEpAPr6oqAAEZoACA6gWmgdM3sAAjgHDCBDGwLUNDUrFGHyMyFABDIQILS6ufjrRAC/ZZRhW/fXl/b/f/V8oA
x8iAxA1A7A+w/A8g6g+gwgFg/trg/g6wKZMQ4rWQxQ72hgdKWLR1nKcQX4kqapaqbxkrTpTLHpTqercwbfY0RrBwdQ7Q18phQw0w3/Yoaw3A2A5A4ltwxvogyg3ymg0YJg9g6Q3gwQ+I1EJI+Q2TZQy7YOt5e7b5X9TYXnRHEFdGeAPwqCHABiXTRCDGNAN8NkBQQFYcAwIQAgBQLUL2WvKXfPOyCU6UxsBANgCILvLaAOPoHyOkTVV2XXBU1U5J
DU1kPkzzs1UUxBgyAUaGi06QNU7U4iSLq3fLu3YM8M1kPU1kqWVOeUJU0M207U7M3kuM3OafIs607kO0/oJ7J3dtRMlMys1kDtOUtNcxCc7syMxLfKUpds8szc1kMzFKaLVc0s9M/oBlpo2o4818xI80EM2wBQN8LgCPf86c/oJMJSE0MC6CyEAnMyHCFQFk581C3CyixDOmRACFOU8wNgHCNyGnK8NQtgTbsTn1E+oRGcNfcUPKIS6iPgAAJrcB
XXIR4QLKFhDLtgE6aQQBGBsAGDcBxz0AEAByvAOHXMf61MHOjHbW4sTjlNkgkByU9ZZMqvEB8g/FS3lCav9AAkIAwu4CaDBD70at3SxI9Nxy1CogJykDKBEgAAULYwIvA+C7rbryEJwAAlGyN7MoL6MyIsI67gC68TpdNQlCLwBG5CAWX61K+i7JbfOc2LJwI6BbhyIAt7IGHdKsCK3KDkCa2a6E4hdgEQAYpYR7SCEaek1W2E+tu7BOqW1K3YB+
NXHkDyEaXAAa35Ma6awhVk8SGLIwLg6iAW2nji2EMEMsKMnGtDR7N8+mdPfBeawAgYJiTO2m/zL+dIqEM0LO6O0K/gNco+OAGgh1cENGEmCAEmEAA===
```
%%