Order information display method and device
By preconfiguring the full-process mapping relationship of orders and database/server cluster calls, the display interface is generated, and the problem of inefficient abnormal monitoring in warehousing management is solved, and efficient monitoring and low-cost development of order management is achieved.
Patent Information
- Application Number
- CN202310575312.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-05-19
- Publication Date
- 2024-11-22
AI Technical Summary
In the prior art, abnormal monitoring in warehousing management is inefficient, order problems cannot be located and processed in a timely manner, and the full process interface of the monitoring front-end cannot view the specific information of each link, resulting in high development costs.
By preconfiguring the mapping relationship of the entire order process, receiving order display requests, calling the corresponding database and server clusters, generating display interfaces including normal, abnormal and unexecuted links, using the database language and service interface to obtain the data to be displayed, and automatically display each one The links and abnormal information to which the order belongs.
It improves the order management efficiency of warehousing management, realizes accurate monitoring of abnormal orders, adapts to various warehousing scenarios, reduces development costs, and improves code reuse rate.
Smart Images

Figure CN119005850A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of smart industrial technology, and in particular to a method and device for displaying order information. Background Art
[0002] During the warehouse management process, it is necessary to monitor the entire order process, determine the current link of the order (including initialization, item positioning, task issuance, picking, review, packaging, delivery, etc.) and whether there are any stuck orders, analyze the reasons for the stuck orders and handle them in a timely manner to ensure the normal operation of the warehouse.
[0003] In the existing abnormal monitoring process, business personnel are usually required to report abnormal orders to monitoring personnel. The monitoring personnel analyze the data of each link of the abnormal order one by one according to the order identification to determine the abnormal information of the order.
[0004] In the process of implementing the present invention, the inventors found that there are at least the following problems in the prior art:
[0005] On the one hand, business personnel usually report that abnormal orders in the previous or current link have been stuck for a long time. It is time-consuming for monitoring personnel to analyze each link one by one, which will lead to low efficiency of abnormal monitoring and failure to locate and deal with problems in time, resulting in chaotic warehouse management. On the other hand, the full-process interface displayed on the monitoring front end can only view the current link of the order, and cannot view the query interface corresponding to each link. Due to the different data types, different interfaces and display forms need to be developed to view the specific information of the link, and the development cost is high. Summary of the invention
[0006] In view of this, an embodiment of the present invention provides a method and device for displaying order information, which can automatically display the links to which each order belongs and the abnormal information of the order, so that the staff can handle it in time, ensure the normal operation of the warehouse, improve the order management efficiency of the warehouse, realize accurate monitoring of abnormal orders, adapt to various warehousing scenarios, have a high code reuse rate, and reduce development costs.
[0007] To achieve the above object, according to one aspect of an embodiment of the present invention, a method for displaying order information is provided, comprising:
[0008] Receiving a display request for one or more orders; wherein the display request includes an order identifier;
[0009] According to the order identifier, the database and / or server cluster corresponding to each link of the order identifier is determined through a pre-configured mapping relationship of the entire order process, and the database and / or server cluster are called to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface;
[0010] According to the format to be displayed, the display interface including the abnormal link is generated using the data to be displayed.
[0011] Optionally, the database language includes SQL language, the interface type of the service interface includes dubbo interface, http interface or webservice interface; the calling of the database and / or server cluster to display data corresponding to the display request includes:
[0012] Determine the database and / or server cluster corresponding to each link of the order identification according to the order type corresponding to the order identification and the mapping relationship;
[0013] The database is queried using the SQL language, and / or, communication between the server and the server cluster is established using the dubbo interface, the http interface or the webservice interface to obtain the data to be displayed corresponding to the order identifier.
[0014] Optionally, the mapping relationship between the link and the database includes a database link, an SQL template, a parameter template, and a link parameter-parameter table; and querying the database using the SQL language includes:
[0015] According to the parameter template, the SQL template and the corresponding relationship between the link parameter and the parameter table are combined to generate an SQL statement for the corresponding link;
[0016] While in communication with the database link, the SQL statement is executed to query the database.
[0017] Optionally, the mapping relationship between the link and the server cluster includes a server IP and a server IP weight; and the using of the dubbo interface to establish communication between the server and the server cluster includes:
[0018] Determine the target server IP of the dubbo interface according to the server IP weight of each server IP of the server cluster;
[0019] Assemble the interface name and the method name to obtain the calling address of the dubbo interface for external calls;
[0020] Access the target server IP through the calling address.
[0021] Optionally, the mapping relationship between the link and the server cluster includes a server address; and the establishing communication between the server and the server cluster by using the http interface or the webservice interface includes:
[0022] Utilize the http interface or the webservice interface to establish communication between the service end and the server address.
[0023] Optionally, the mapping relationship between the link and the database and / or the server cluster further includes link parameter-standard boundary value; and the acquiring the data to be displayed corresponding to the order identifier includes:
[0024] Obtaining parameter values and standard boundary values of link parameters corresponding to the parameter template;
[0025] Comparing the parameter value of the link parameter with the standard boundary value of the link parameter, and determining the state code of the link parameter corresponding to the parameter template as the parameter state of the link parameter;
[0026] The data to be displayed is determined according to the acquired parameter values and parameter states of the link parameters of all links corresponding to the order identifier.
[0027] Optionally, the display interface further includes normal links and unexecuted links generated using the data to be displayed.
[0028] Optionally, it also includes:
[0029] Determine that the link with the status code of all parameter status being 1 is a normal link;
[0030] When the status code of any of the parameter states is 0, determining the corresponding link as an abnormal link;
[0031] Determine the link where the data to be displayed is empty as an unexecuted link;
[0032] Different display colors or display patterns are respectively assigned to the normal link, the abnormal link and the unexecuted link to generate the display interface.
[0033] Optionally, the display color of the normal link is green, and the display pattern is a diagonal line; the display color of the abnormal link is red, and the display pattern is a horizontal line; the display color of the unexecuted link is gray, and the display pattern is blank.
[0034] Optionally, it also includes:
[0035] Receiving a touch request for the abnormal link;
[0036] In response to the touch request, the parameter value of the link parameter whose status code is 0 in the abnormal link is displayed.
[0037] According to another aspect of an embodiment of the present invention, there is provided a device for displaying order information, comprising:
[0038] A receiving module, configured to receive a display request for one or more orders; wherein the display request includes an order identifier;
[0039] A calling module is used to determine the database and / or server cluster corresponding to each link of the order identification according to the order identification and through a pre-configured mapping relationship of the entire order process, and call the database and / or server cluster to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface;
[0040] A display module is used to generate a display interface including an abnormal link according to the format to be displayed and using the data to be displayed.
[0041] According to another aspect of an embodiment of the present invention, there is provided an electronic device for displaying order information, including:
[0042] one or more processors;
[0043] a storage device for storing one or more programs,
[0044] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for displaying order information provided by the present invention.
[0045] According to another aspect of an embodiment of the present invention, a computer-readable medium is provided, on which a computer program is stored, and when the program is executed by a processor, the method for displaying order information provided by the present invention is implemented.
[0046] An embodiment of the above invention has the following advantages or beneficial effects: because the mapping relationship between each link of the entire order process and the database and server cluster is pre-configured, when receiving the display request of the order, the corresponding database language is directly used to call the data to be displayed from the database, or the service interface is used to call the data to be displayed from the server cluster, and a display interface including normal links, abnormal links and unexecuted links is generated for users to view. Therefore, the technical problems of low efficiency of abnormal monitoring, inability to locate and handle problems in time, chaotic warehouse management and high development cost are overcome, and the abnormal information of each order link and order can be automatically displayed, so that the staff can handle it in time, ensure the normal operation of the warehouse, improve the order management efficiency of the warehouse, realize accurate monitoring of abnormal orders, adapt to various warehousing scenarios, high code reuse rate and reduce the technical effect of development cost.
[0047] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.
[0049] Figure 1 is a schematic diagram of the main process of the method for displaying order information according to an embodiment of the present invention;
[0050] Figure 2 It is a schematic diagram of the main process of the method for configuring the mapping relationship of the entire order process according to an embodiment of the present invention;
[0051] Figure 3 is a schematic diagram of the main process of a method for obtaining data to be displayed according to an embodiment of the present invention;
[0052] Figure 4 is a schematic diagram of a display interface according to an embodiment of the present invention;
[0053] Figure 5 is a schematic diagram of a display interface according to yet another embodiment of the present invention;
[0054] Figure 6 is a schematic diagram of main modules of a display device for order information according to an embodiment of the present invention;
[0055] Figure 7 An exemplary system architecture diagram showing a method for displaying order information or a device for displaying order information suitable for use in an embodiment of the present invention is shown;
[0056] Figure 8 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION
[0057] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.
[0058] It should be noted that the acquisition, storage and application of user personal information involved in the technical solution of the present disclosure are in compliance with the provisions of relevant laws and regulations and do not violate public order and good morals.
[0059] SQL: Structured Query Language is a database query and programming language used to access data, query, update and manage relational database systems. SQL statements are a language for operating databases.
[0060] MySQL: A relational database management system that stores data in different tables, has high speed and flexibility, and is accessed using the SQL language.
[0061] rpc: Remote Procedure Call, which is relative to local calls and can be understood as a method of calling a remote machine that requires network communication.
[0062] dubbo: is an open source, high-performance, lightweight open source Java RPC framework that enables applications to implement service output and input functions through high-performance RPC.
[0063] Web server: A website server is a program that resides on a certain type of computer on the Internet. It can process requests from web clients such as browsers and return responses, placing data files for download.
[0064] http: Hyper Text Transfer Protocol, which is based on the http protocol for communication and calls the required data.
[0065] Webservice: communicates based on the soap protocol (http+xml) and calls the required data.
[0066] The existing monitoring front-end can only view the full process interface of the order and locate the link where the order is currently located. When judging whether the order is abnormal, it is necessary to extract the data of each link from the database for analysis one by one. The tracking efficiency of the problem is low and the processing is not timely, which affects the efficiency of warehouse supervision. In addition, due to the different data types and data operations in different links (for example, the positioning link is the search for the location data of the item, the task issuance link is the generation and allocation of the picking task, and the review link is the comparison between the actual picked items and the picking task, etc.), if you want to view the query interface of each link, you must develop different data interfaces (to obtain the data of the link where the order is located) and display interfaces for different links. The scripts of each link cannot be reused with each other, and the development cost is extremely high.
[0067] Figure 1 is a schematic diagram of the main process of the method for displaying order information according to an embodiment of the present invention, such as Figure 1 As shown, the method for displaying order information of the present invention includes the following steps:
[0068] Step S101, receiving a display request for one or more orders; wherein the display request includes an order identifier.
[0069] In the embodiment of the present invention, the server receives a display request for an order, where the order identifier is an order number. For example, the display request is to display the status of each link of the order with order numbers x0000000001, x000000010, x200003001, and x498882021.
[0070] Furthermore, the display request also includes displaying data of each link of the order with order numbers x0000000001, x000000010, x200003001, and x498882021, including order number, order time, item sku, item quantity, item status, abnormal information, etc.
[0071] In an embodiment of the present invention, the display request may further include a format to be displayed. When the display request does not include the format to be displayed, the display is directly performed in the default display format. When the display request includes the format to be displayed, the format to be displayed may include the display form of each order link in different states, for example, normal links are marked in green, abnormal links are marked in red, unexecuted links are marked in gray, etc. Technical personnel in this field may make selective settings as needed.
[0072] Step S102, according to the order identifier, through the pre-configured mapping relationship of the entire order process, determine the database and / or server cluster corresponding to each link of the order identifier, and call the database and / or server cluster to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface.
[0073] In an embodiment of the present invention, the server pre-configures a mapping relationship between each link of placing an order of different order types and the corresponding link data source. The link data source can be a database and / or a server cluster, so that when a display request is subsequently processed, the corresponding database language is used to query the database according to the order identifier, and / or the server cluster is accessed using the corresponding service interface to call the data to be displayed corresponding to the display request.
[0074] In the embodiment of the present invention, Figure 2 As shown, the configuration method of the mapping relationship of the entire order process of the present invention includes the following steps:
[0075] Step S201, for each order type, sort out each link of the entire order process.
[0076] In the embodiment of the present invention, for each order type, the entire order process is sorted out to determine the various links included in the entire order process of different order types. Order types include outbound orders, inbound orders, in-warehouse transfer orders, etc. The various links of outbound orders include initialization-item positioning-generation of picking tasks-issuance of picking tasks-picking-review-packing-outbound, the various links of inbound orders include initialization-storage positioning-generation of inbound tasks-issuance of inbound tasks-inbound, and the various links of in-warehouse transfer orders include initialization-starting point positioning-end point positioning-generation of transfer tasks-issuance of transfer tasks-transfer.
[0077] It should be noted that order types such as outbound orders, inbound orders, and in-warehouse transfer orders are only examples. There are many types of orders in actual warehousing production, which can be sorted and configured as needed.
[0078] Step S202, determining the link name and sequence identifier of each link.
[0079] In an embodiment of the present invention, for each order type, the link name and sequence identifier of each link in the entire order process are determined. For example, taking the outbound order as an example, the link names of each link in the entire order process are initialization link, item positioning link, picking task generation link, picking task issuance link, picking link, review link, packaging link, and outbound link. The sequence identifier of the initialization link is OUT①, the sequence identifier of the item positioning link is OUT②, the sequence identifier of the picking task generation link is OUT③, the sequence identifier of the picking task issuance link is OUT④, the sequence identifier of the picking link is OUT⑤, the sequence identifier of the review link is OUT⑥, the sequence identifier of the packaging link is OUT⑦, and the sequence identifier of the outbound link is OUT⑧.
[0080] Step S203, determining the mapping relationship between each link and the corresponding database and / or server cluster according to the data storage location of each link; wherein the mapping relationship includes the database link and the corresponding query language of the database, the server cluster address and the corresponding service interface of the server cluster.
[0081] In the embodiment of the present invention, the query language of the database includes the SQL language, and the interface type of the service interface of the server cluster includes the rpc interface, wherein the rpc interface may be a dubbo interface (or Jeff interface), an http interface, or a webservice interface, etc. It should be noted that the query language of the database and the interface type of the service interface may be selectively set according to the actual data storage scenario, and the SQL language, dubbo interface, http interface, or webservice interface, etc., herein are only examples.
[0082] In the embodiment of the present invention, the data storage location can be a database or a server cluster. Among them, the SQL language is connected to the local database to obtain data of each link from the local database; the dubbo interface is connected to the server cluster including multiple database servers to obtain data of each link from the database server; the http interface or webservice interface is connected to the server cluster including multiple web servers to obtain data of each link from the web server.
[0083] In an embodiment of the present invention, the mapping relationship between each link and the database includes the link name, database name, database link, SQL template, parameter template, link parameter-parameter table correspondence, link parameter-standard boundary value. The database link is a combination of a domain name and a port, or a combination of an IP and a port. The SQL template is a template for generating SQL statements. The parameter template is the parameter value and parameter status of the parameter to be displayed, and can be selectively set in advance as needed. The link parameter-parameter table correspondence stores the link parameters of each link, and the table name of the parameter table where each link parameter is located. The link parameter-standard boundary value stores the standard boundary values of the link parameters of each link. Among them, the standard boundary value can be a value or an interval. Specifically:
[0084] The link name is "Item Location". The database name is MySQL database. Accordingly, the database link of the domain name and port combination can be abbc:mysql: / / mysql-cn-abdlec-dfb.rds.com:3358 / ts_manager, or the database link of the ip and port combination can be: abbc:mysql: / / 192.108.110.50:3358 / ts_manager. The SQL template can be select***from###where&&&, "***" is the link parameter, "###" is the table name of the parameter table corresponding to the link parameter "***", and "&&&" is the filtering condition. The parameters that need to be displayed in the parameter template include order number, order time, item sku, item quantity, item location, item location status, etc. For example, the generated SQL statement is "select order_no, time, sku, qty, status from locate_info where order_no = {x000000001, x000000010, x200003001, x498882021}", which means to obtain the order number, order time, item sku, item quantity, item location (K5) and other data of the orders with order numbers x000000001, x000000010, x200003001, x498882021 from the parameter table locate_info. The link parameter-standard boundary value includes the interval range of the item location A1-G10.
[0085] In the embodiment of the present invention, the mapping relationship between each link and the server cluster corresponding to the service interface of different interface types includes different contents, wherein:
[0086] For the dubbo interface, the mapping relationship between each link and the server cluster includes the link name, interface name, interface name, method name, server IP of each database server included in the server cluster, service provider name, parameter template, connection timeout, read timeout, link parameter-parameter table correspondence, link parameter-standard boundary value. The interface name corresponds to the link name. The method name is used in combination with the interface name to provide a call address for external calls. One server IP in the server cluster corresponds to one server IP weight, which can be selectively set in advance as needed. The service provider name is the corresponding service provider. The parameter template, link parameter-parameter table, and link parameter-standard boundary value are the same as above. The connection timeout is used to count the timeout time when the server connects to the server cluster, so as to reconnect, prevent invalid waiting when the server cluster does not respond for a long time, and improve the user's display experience. The read timeout is used to count the timeout time when the server cluster does not respond for a long time when the server reads data from the server cluster, prevent invalid waiting, and improve the user's display experience. Specifically:
[0087] The link name is "Item Location". The interface name of the dubbo interface can be "Get Location Information". The interface name can be "com.xx.outboun.OrderLocate". The method name can be "getLocatInfo". The server IP can be "192.168.198.50". The service provider name can be outboundService. The connection timeout can be 5s. The read timeout can be 5s.
[0088] For the http interface, the mapping relationship between each link and the server cluster includes the link name, interface name, server address of each web server included in the server cluster, parameter template, request method, connection timeout, read timeout, link parameter-parameter table correspondence, link parameter-standard boundary value. The interface name corresponds to the link name. The server address is the url address of the web server. The request method is the method of reading and writing data by the http interface, including post, get and other methods. The connection timeout, read timeout, link parameter-parameter table correspondence, link parameter-standard boundary value are the same as above. Specifically:
[0089] The link name is "Item Location". The interface name of the http interface can be "Get Outbound Location Information". The server address can be "http: / / www.xxx.com / getLocateInfo". The request method can be "post".
[0090] For the webservice interface, the mapping relationship between each link and the server cluster includes the link name, interface name, server address of each web server included in the server cluster, parameter template, request method, connection timeout, read timeout, correspondence between link parameters and parameter table, and link parameters and standard boundary values, which is similar to the http interface.
[0091] In the embodiment of the present invention, the mapping relationship of each link may optionally also include the user name, password, and token of the user login, so as to verify the user information of the front end and prevent the leakage of warehouse information.
[0092] It should be noted that the databases and server clusters listed in the present invention are only examples. The actual warehouse data management can be expanded as needed, and the corresponding databases, query languages, server clusters and service interfaces can be selectively set. An entire order process can correspond to one database, and one entire order process can correspond to one server cluster. Alternatively, an entire order process can correspond to multiple databases, and one entire order process can correspond to multiple server clusters. Alternatively, an entire order process can correspond to any combination of multiple databases and multiple server clusters.
[0093] In an embodiment of the present invention, the database and / or server cluster of each link of the whole order process of different types of orders are configured through the configuration method of the mapping relationship of the whole order process of the present invention, so that in the subsequent data acquisition process, the corresponding database language is used to obtain the data to be displayed from the database and / or the corresponding service interface is used to obtain the data from the server cluster. The code reuse rate corresponding to the configuration method is extremely high. During the reuse process, it is only necessary to configure the mapping relationship using the configuration method of the mapping relationship of the whole order process of the present invention, and then the corresponding data can be called for display according to the configuration information, which can adapt to the data management of various warehousing scenarios and greatly reduce the development cost.
[0094] In the embodiment of the present invention, Figure 3 As shown, the method for obtaining data to be displayed of the present invention comprises the following steps:
[0095] Step S301, determining the database and / or server cluster corresponding to each link of the order identification according to the order type corresponding to the order identification and the mapping relationship.
[0096] In an embodiment of the present invention, since each link of different types of orders corresponds to different databases and / or server clusters, it is necessary to use the corresponding database language or service interface to obtain the data of the corresponding link. Therefore, after receiving the request to be displayed, the order type of each order is determined according to the order identifier included in the request to be displayed, and the links included in each order and the corresponding data storage location are clarified.
[0097] Step S302, determine whether the data storage location is a database, if yes, go to step S306; if not, go to step S303.
[0098] Step S303, determine whether the service interface is a dubbo interface, if yes, go to step S305; if not, go to step S304.
[0099] Step S304, using the http interface or the webservice interface, establish communication between the server and the server address corresponding to the http interface or the webservice interface, obtain the data to be displayed corresponding to the order identifier, and go to step S307.
[0100] In the embodiment of the present invention, the server accesses the server address corresponding to the http interface or the webservice interface through the http interface or the webservice interface.
[0101] Step S305, using the dubbo interface, establish communication between the server and the server IP corresponding to the dubbo interface, obtain the data to be displayed corresponding to the order identifier, and go to step S307.
[0102] Step S3051, determining the target server IP of the dubbo interface according to the server IP weight of each server IP of the server cluster.
[0103] Step S3052, assemble the interface name and the method name to obtain the calling address of the dubbo interface for external calls.
[0104] In the embodiment of the present invention, for example, the interface name "com.xx.outboun.OrderLocate" and the method name "getLocatInfo" are assembled to obtain the calling address com.xx.outboun.OrderLocate.getLocatInfo of the dubbo interface external call.
[0105] Step S3053, access the target server IP through the calling address.
[0106] Step S306, query the database using the database language to obtain the to-be-displayed data corresponding to the order identifier, and then go to step S307.
[0107] In the embodiment of the present invention, the SQL language used by the database is taken as an example to illustrate the process of querying the database using the database language.
[0108] Step S3061, according to the parameter template, combine the SQL template and the correspondence between the link parameter and the parameter table to generate an SQL statement for the corresponding link.
[0109] Step S3062, when communicating with the database link, executing the SQL statement to query the database.
[0110] Step S307, obtaining parameter values and standard boundary values of link parameters corresponding to the parameter template.
[0111] Step S308, comparing the parameter value of the link parameter with the standard boundary value of the link parameter, and determining the state code of the link parameter corresponding to the parameter template as the parameter state of the link parameter.
[0112] In the embodiment of the present invention, the status code can be used to represent the value of the parameter status. The status code of 1 indicates that the parameter status of the link parameter is normal, the status code of 0 indicates that the parameter status of the link parameter is abnormal, and the status code of null indicates that the parameter status of the link parameter is not executed.
[0113] Further, when the standard boundary value is a value, the standard boundary value is the upper threshold or lower threshold of the link parameter. According to the judgment standard of the link parameter, it is determined whether the parameter value of the link parameter is greater than or equal to the upper threshold or less than or equal to the lower threshold. When the parameter value of the link parameter is greater than or equal to the upper threshold, or less than or equal to the lower threshold, the status code of the link parameter is determined to be 0; when the parameter value of the link parameter is less than the upper threshold, or greater than the lower threshold, the status code of the link parameter is determined to be 1.
[0114] Alternatively, when the standard boundary value is an interval, it is determined whether the parameter value of the link parameter is within the interval. When the parameter value of the link parameter is not within the interval, the status code of the link parameter is determined to be 0; when the parameter value of the link parameter is within the interval, the status code of the link parameter is determined to be 1. For example, the parameter value of the item position is K5, and the standard boundary value of the item position is within the interval range A1-G10. Since the parameter value K5 is not within the interval range A1-G10, the status code of the item position is 0.
[0115] Step S309: determining the data to be displayed according to the acquired parameter values and parameter states of the link parameters of all links corresponding to the order identifier.
[0116] In the embodiment of the present invention, after obtaining the parameter values and parameter states of the link parameters of all links of the order corresponding to the order identifier, the to-be-displayed data corresponding to the order identifier is obtained.
[0117] In an embodiment of the present invention, through the method for obtaining data to be displayed of the present invention, according to the data storage location of each link of the order, the corresponding database, server cluster or web server is accessed using the database language and / or service interface to obtain the parameter value and standard boundary value of the link parameter of each link, the parameter value is compared with the standard boundary value, the parameter status of the link parameter of each link is determined, and the parameter value and parameter status of the link parameter of each link corresponding to the order identifier are combined to obtain the data to be displayed, so that the entire order process of each order can be accurately monitored subsequently, abnormal orders can be located and processed in time, the normal operation of the warehouse can be guaranteed, and the efficiency of warehouse management can be improved.
[0118] Step S103: generating a display interface including an abnormal link according to the format to be displayed and using the data to be displayed.
[0119] In the embodiment of the present invention, the display interface also includes normal links and unexecuted links generated using the data to be displayed.
[0120] In an embodiment of the present invention, when the status code of all parameter states of a link is 1, the link is determined to be a normal link; when the status code of any parameter state of a link is 0, the link is determined to be an abnormal link; when the data to be displayed of a link is empty, the link is determined to be an unexecuted link.
[0121] Furthermore, in response to a touch request for an abnormal link, the parameter value and standard boundary value of the link parameter whose status code is 0 in the abnormal link may be displayed.
[0122] In the embodiment of the present invention, the format to be displayed can be a display diagram or a display table. The display diagram includes the link name of each link and a display pattern representing the link status of each link. The display pattern is a slash indicating that the link status is a normal link, the display pattern is a horizontal line indicating that the link status is an abnormal link, and the display pattern is blank indicating that the link status is an unexecuted link. Figure 4 As shown, the order initialization link, item positioning link, picking task generation link and picking task issuance link of the order with order number x000000001 are normal, the picking link is abnormal, the review link, packaging link and outbound link have not been executed yet, in response to the picking link.
[0123] Alternatively, the display diagram includes the link name of each link and the display color representing the link status of each link. The display color is green, indicating that the link status is a normal link, the display color is red, indicating that the link status is an abnormal link, and the display color is gray, indicating that the link status is an unexecuted link.
[0124] In the embodiment of the present invention, Figure 5As shown, the display table includes the link name of each link and the display pattern representing the link status of each link.
[0125] In an embodiment of the present invention, as described above, the user can initiate a display request at the front end, freely select the order link to be displayed, and the server obtains the data to be displayed of the corresponding link according to the user's display request for display. Alternatively, according to the actual usage scenario, a portion of display reports with higher monitoring frequency (identified by report ID and report name) can be pre-configured as the default report, and the various links required for the default report can be combined and displayed. Subsequently, the user can select the report ID or report name of the pre-configured default report, and the server automatically verifies whether the data of each link is complete. If it is complete, the corresponding display report is directly generated for viewing; if it is incomplete, the mapping relationship of the present invention can be used to obtain the corresponding data to be displayed to generate a display report. Among them, the default report corresponds to the default display format.
[0126] Furthermore, when configuring the default report, including the report ID, report name, report fields, etc., the report fields match the link parameters of each link, and the mapping relationship between the report fields and the corresponding links is stored under the report ID. When the user selects, directly go to the mapping relationship under the report ID to obtain the data to be displayed and generate the display report. For example, the report name can be the order full process report, and the data mapping relationship of each link of the order is configured to generate a display report.
[0127] In the embodiment of the present invention, the report name may also be an abnormal report, and the server searches for the data to be displayed in all abnormal links to generate an abnormal report.
[0128] In an embodiment of the present invention, by receiving a display request for one or more orders; wherein the display request includes an order identifier; according to the order identifier, the database and / or server cluster corresponding to each link of the order identifier is determined through a pre-configured mapping relationship of the entire order process, and the database and / or server cluster are called to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface; according to the format to be displayed, a display interface including abnormal links is generated using the data to be displayed, and other steps can be performed to automatically display abnormal information of each link and order to which the order belongs, so that the staff can handle it in time, ensure the normal operation of the warehouse, improve the order management efficiency of the warehouse, realize accurate monitoring of abnormal orders, adapt to various warehousing scenarios, have a high code reuse rate, and reduce development costs.
[0129] Figure 6 is a schematic diagram of the main modules of the display device for order information according to an embodiment of the present invention, such as Figure 6 As shown, the display device 600 of order information of the present invention includes:
[0130] The receiving module 601 is used to receive a display request for one or more orders; wherein the display request includes an order identifier.
[0131] The calling module 602 is used to determine the database and / or server cluster corresponding to each link of the order identifier according to the order identifier through a pre-configured mapping relationship of the entire order process, and call the database and / or server cluster to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface.
[0132] The display module 603 is used to generate a display interface including an abnormal link according to the format to be displayed and using the data to be displayed.
[0133] In an embodiment of the present invention, through modules such as a receiving module, a calling module and a display module, the abnormal information of each order link and the order can be automatically displayed, so that the staff can handle it in time, ensure the normal operation of the warehouse, improve the order management efficiency of the warehouse, realize accurate monitoring of abnormal orders, adapt to various warehousing scenarios, have a high code reuse rate, and reduce development costs.
[0134] Figure 7 An exemplary system architecture diagram showing an order information display method or an order information display device suitable for use in an embodiment of the present invention is shown in FIG. Figure 7 As shown, an exemplary system architecture of the method for displaying order information or the device for displaying order information according to an embodiment of the present invention includes:
[0135] like Figure 7 As shown, system architecture 700 may include terminal devices 701, 702, 703, network 704 and server 705. Network 704 is used to provide a medium for communication links between terminal devices 701, 702, 703 and server 105. Network 704 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.
[0136] The user can use the terminal devices 701, 702, 703 to interact with the server 705 through the network 704 to receive or send messages, etc. Various communication client applications can be installed on the terminal devices 701, 702, 703, such as warehousing applications, shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc.
[0137] The terminal devices 701 , 702 , and 703 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers.
[0138] The server 705 may be a server that provides various services, such as a background management server that provides support for warehouse websites browsed by users using the terminal devices 701, 702, and 703. The background management server may analyze and process the received data such as the display request of order information, and feed back the processing results (such as the display interface of order information) to the terminal devices 701, 702, and 703.
[0139] It should be noted that the method for displaying order information provided in the embodiment of the present invention is generally executed by the server 705 , and accordingly, the device for displaying order information is generally set in the server 705 .
[0140] It should be understood that Figure 7 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.
[0141] Figure 8 is a schematic diagram of a computer system of a terminal device or server suitable for implementing an embodiment of the present invention, such as Figure 8 As shown, the computer system 800 of the terminal device or server of the embodiment of the present invention includes:
[0142] A central processing unit (CPU) 801 can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 802 or a program loaded from a storage section 808 into a random access memory (RAM) 803. Various programs and data required for the operation of the system 800 are also stored in the RAM 803. The CPU 801, the ROM 802, and the RAM 803 are connected to each other via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.
[0143] The following components are connected to the I / O interface 805: an input section 806 including a keyboard, a mouse, etc.; an output section 807 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 808 including a hard disk, etc.; and a communication section 809 including a network interface card such as a LAN card, a modem, etc. The communication section 809 performs communication processing via a network such as the Internet. A drive 810 is also connected to the I / O interface 805 as needed. A removable medium 811, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 810 as needed, so that a computer program read therefrom is installed into the storage section 808 as needed.
[0144] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 809, and / or installed from the removable medium 811. When the computer program is executed by the central processing unit (CPU) 801, the above-mentioned functions defined in the system of the present invention are executed.
[0145] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.
[0146] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0147] The modules involved in the embodiments of the present invention may be implemented in software or hardware. The modules described may also be arranged in a processor, for example, they may be described as: a processor including a receiving module, a calling module and a display module. The names of these modules do not constitute a limitation on the modules themselves in certain cases. For example, the calling module may also be described as "according to the order identifier, through the pre-configured mapping relationship of the entire order process, the database and / or server cluster corresponding to each link of the order identifier is determined, and the module of the data to be displayed corresponding to the database and / or server cluster and the display request is called".
[0148] As another aspect, the present invention also provides a computer-readable medium, which may be included in the device described in the above embodiment; or it may exist independently and not be assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device includes: receiving a display request for one or more orders; wherein the display request includes an order identifier; according to the order identifier, through the pre-configured mapping relationship of the entire order process, determining the database and / or server cluster corresponding to each link of the order identifier, calling the database and / or server cluster and the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface; according to the format to be displayed, using the data to be displayed to generate a display interface including abnormal links.
[0149] According to the technical solution of the embodiment of the present invention, the pre-configuration and dynamic display of the full-process monitoring interface can be realized, including normal, abnormal, unexecuted and other link information, without the need for interface development. The method code and interface have a high reuse rate, and the full-process information of the order is fully displayed, so that the warehouse personnel can see it at a glance, realize accurate monitoring of the order, and reduce development costs.
[0150] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.
Claims
1. A method for displaying order information, characterized in that: include: Receiving a display request for one or more orders; wherein the display request includes an order identifier; According to the order identifier, the database and / or server cluster corresponding to each link of the order identifier is determined through a pre-configured mapping relationship of the entire order process, and the database and / or server cluster are called to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface; According to the format to be displayed, the display interface including the abnormal link is generated using the data to be displayed.
2. The method according to claim 1, characterized in that: The database language includes SQL language, and the interface type of the service interface includes dubbo interface, http interface or webservice interface; The calling of the database and / or server cluster for the data to be displayed corresponding to the display request includes: Determine the database and / or server cluster corresponding to each link of the order identification according to the order type corresponding to the order identification and the mapping relationship; The database is queried using the SQL language, and / or, communication between the server and the server cluster is established using the dubbo interface, the http interface or the webservice interface to obtain the data to be displayed corresponding to the order identifier.
3. The method according to claim 2, characterized in that The mapping relationship between the link and the database includes a database link, an SQL template, a parameter template, and a link parameter-parameter table; the querying of the database using the SQL language includes: According to the parameter template, the SQL template and the corresponding relationship between the link parameter and the parameter table are combined to generate an SQL statement for the corresponding link; While in communication with the database link, the SQL statement is executed to query the database.
4. The method according to claim 2, characterized in that: The mapping relationship between the link and the server cluster includes the server IP and the server IP weight; the use of the dubbo interface to establish communication between the server and the server cluster includes: Determine the target server IP of the dubbo interface according to the server IP weight of each server IP of the server cluster; Assemble the interface name and the method name to obtain the calling address of the dubbo interface for external calls; Access the target server IP through the calling address.
5. The method according to claim 2, characterized in that: The mapping relationship between the link and the server cluster includes a server address; the use of the http interface or the webservice interface to establish communication between the server and the server cluster includes: Utilize the http interface or the webservice interface to establish communication between the service end and the server address.
6. The method according to claim 3, 4 or 5, characterized in that: The mapping relationship between the link and the database and / or the server cluster also includes link parameter-standard boundary value; the obtaining of the to-be-displayed data corresponding to the order identifier includes: Obtaining parameter values and standard boundary values of link parameters corresponding to the parameter template; Comparing the parameter value of the link parameter with the standard boundary value of the link parameter, and determining the state code of the link parameter corresponding to the parameter template as the parameter state of the link parameter; The data to be displayed is determined according to the acquired parameter values and parameter states of the link parameters of all links corresponding to the order identifier.
7. The method according to claim 1, characterized in that The display interface also includes normal links and unexecuted links generated using the data to be displayed.
8. The method according to claim 7, characterized in that Also includes: Determine that the link with the status code of all parameter status being 1 is a normal link; When the status code of any of the parameter states is 0, determining the corresponding link as an abnormal link; Determine the link where the data to be displayed is empty as an unexecuted link; Different display colors or display patterns are respectively assigned to the normal link, the abnormal link and the unexecuted link to generate the display interface.
9. The method according to claim 7, characterized in that: The display color of the normal link is green and the display pattern is a diagonal line; the display color of the abnormal link is red and the display pattern is a horizontal line; the display color of the unexecuted link is gray and the display pattern is blank.
10. The method according to claim 8, characterized in that Also includes: Receiving a touch request for the abnormal link; In response to the touch request, the parameter value of the link parameter whose status code is 0 in the abnormal link is displayed.
11. A display device for order information, characterized in that: include: A receiving module, configured to receive a display request for one or more orders; wherein the display request includes an order identifier; A calling module is used to determine the database and / or server cluster corresponding to each link of the order identification according to the order identification and through a pre-configured mapping relationship of the entire order process, and call the database and / or server cluster to obtain the data to be displayed corresponding to the display request; wherein the database is queried through a database language, and the server cluster is accessed through a service interface; A display module is used to generate a display interface including an abnormal link according to the format to be displayed and using the data to be displayed.
12. An electronic device for displaying order information, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 10.
13. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 10 is implemented.
