修改功能 #436
v3.0: Support multi-keyword order name search
Start date:
10/16/2024
Due date:
10/16/2024
% Done:
100%
Estimated time:
4.00 h
Description
Background
- Improve efficiency
- 支持多个【order name】的模糊查询，优先7位数字，再次6位数字，规则如下
- 如果含有连续7个数字：先抽出【连续的7个数字】，并移除已抽出的【连续的7个数字】，再次抽出【连续的6个数字】，最后组成【逻辑或】查询
比如：【1234567654321123 BBB12345 223344】，抽出检索字段 = 【1234567】or【7654321】or【223344】 - 以上除外，按正规的字符串分割【逻辑或】查询：【全角或者半角逗号， 空格 ，换行符，Tab字符，并支持Excel横向或者纵向的字符Copy】
比如：【12345 BBB12345】，抽出检索字段 = 【12345】or【BBB12345】，意味着里面没有【连续的6个数字】，按常规的分割处理
- 如果含有连续7个数字：先抽出【连续的7个数字】，并移除已抽出的【连续的7个数字】，再次抽出【连续的6个数字】，最后组成【逻辑或】查询
- 适当减少【Product Type】和【Retailer】宽度，因为这里没有必要这么宽（可能根据屏幕自动调整的），省下的宽度全部留给【order name】
- Report and Solution
Others
Updated by Zhongbao Ye about 1 year ago
- Status changed from 进行中 to 已关闭
- % Done changed from 0 to 100
Output(2024/10/16) 居家
Task Detail 1: Commit ID: f1435004af5aaa92e37158c81acee6481d2e1d52,650fa25fa0ab714f60c5778311f6d759f94dcde8,6eebfc49e1648ef0ce34866db0922b4d7c6dc77f,b4cec42e81d15ce1b43537393ff5fb4e0a0af1e2- Support fuzzy query of multiple [order name], give priority to 6 digits, the rules are as follows
- If it contains 6 consecutive digits: only extract [6 consecutive digits] and form [logical OR] query
- Except for the above, split the [logical OR] query according to the regular string: [full-width or half-width comma, space, line break, Tab character, and support Excel horizontal or vertical character copy]
- Adjust the width of all filter fields, and appropriately increase the width of orderNo and orderName fields.
- Fixed Product type and Retailer column width to 200px