Waybill data storage, query and management method, device and equipment and storage medium
By identifying the master order in the e-commerce platform and linking the waybill data to the master order storage, the problem of duplicate data storage caused by multiple orders sharing the same waybill is solved, improving system efficiency and resource utilization.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- SHANGHAI XUNMENG INFORMATION TECH CO LTD
- Filing Date
- 2021-03-29
- Publication Date
- 2026-04-17
AI Technical Summary
In logistics scenarios, especially on e-commerce platforms, where multiple orders share the same waybill, existing technologies lead to the storage of a large amount of duplicate data, increasing database pressure and prolonging system response time, resulting in a waste of resources.
By receiving logistics data query requests for the current order, the master order is identified, and the logistics data of the waybill is associated with the master order storage. Data management and querying are only performed on the master order, reducing the duplicate data storage for sub-orders.
It enables efficient storage and retrieval of waybill data for multiple orders sharing the same waybill, reducing database pressure, improving system response time, and reducing resource waste.
Smart Images

Figure CN113011821B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of computer applications, and in particular to a method, apparatus, device, and storage medium for storing, querying, and managing waybill data. Background Technology
[0002] In logistics scenarios, especially on e-commerce platforms, multiple orders are often shipped and transported using the same waybill due to warehouse management and other issues. Currently, waybill data is linked to each order for complete recording and storage, resulting in a large amount of duplicate data and increasing the pressure on the database. Synchronizing this data in applications also increases system response time and wastes resources.
[0003] Therefore, how to store, manage, and query waybill data for multiple orders sharing the same waybill, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time, and reducing resource waste, is a technical problem that urgently needs to be solved in this field. Summary of the Invention
[0004] In order to overcome the defects of the above-mentioned related technologies, the present invention provides a method, apparatus, equipment and storage medium for storing, querying and managing waybill data, thereby storing, managing and querying waybill data of multiple orders sharing the same waybill, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time and reducing resource waste.
[0005] According to one aspect of the present invention, a method for querying waybill data is provided, comprising:
[0006] Receive a query request for logistics data of the current order, where the current order shares the same waybill with multiple other orders;
[0007] From the current order and multiple orders sharing the same waybill with the current order, query a master order, and store the logistics data of the waybill in association with the master order;
[0008] The logistics data of the waybill associated with the master order will be used as the query result.
[0009] In some embodiments of the present invention, the logistics data of the waybill is only associated with the master order storage.
[0010] In some embodiments of the present invention, multiple orders sharing the same waybill are associated with the identifier of the waybill, and the waybill is associated with the identifier of the master order.
[0011] In some embodiments of the present invention, among multiple orders sharing the same waybill, the first order that provides shipping information is designated as the master order.
[0012] In some embodiments of the present invention, when the master order is abnormal, a new master order is determined from among multiple orders that share the same waybill with the master order, and the logistics data of the waybill stored in association with the previous master order is associated with the current master order.
[0013] In some embodiments of the present invention, re-determining a master order from among multiple orders sharing the same waybill with the master order includes:
[0014] Among multiple orders that share the same waybill with the master order, the first order that provides shipping information will be designated as the new master order.
[0015] In some embodiments of the present invention, the logistics data of the waybill is updated in real time, and the logistics data of the waybill includes physical trajectory and predicted delivery time.
[0016] In some embodiments of the present invention, the query request is triggered by a user's query operation on the logistics data of the current order.
[0017] In some embodiments of the present invention, after using the logistics data of the waybill associated with the master order as the query result, the method further includes:
[0018] Provide a query results page to display the logistics data of the waybills associated with the main order;
[0019] The query results page provides order information for multiple orders that share the same waybill as the current order.
[0020] According to another aspect of the present invention, a method for storing waybill data is also provided, wherein multiple orders share the same waybill, the method comprising:
[0021] Receive shipping information for the current order;
[0022] Determine whether the current order's waybill is already associated with another order;
[0023] If not, mark the current order as the main order and store the waybill data associated with the main order;
[0024] If so, mark the current order as a secondary order;
[0025] Receive the logistics data of the waybill and associate the logistics data of the waybill with the master order storage.
[0026] According to another aspect of the present invention, a waybill data management method is also provided, wherein multiple orders share the same waybill, the waybill data management method comprising:
[0027] Receive shipping information for the current order;
[0028] Determine whether the current order's waybill is already associated with another order;
[0029] If not, mark the current order as the main order and store the waybill data associated with the main order;
[0030] If so, mark the current order as a secondary order;
[0031] Receive the logistics data of the waybill and associate the logistics data of the waybill with the main order storage;
[0032] Receive query requests for logistics data of the order to be queried;
[0033] The system queries a single main order for orders pending query and multiple orders sharing the same waybill with the orders pending query.
[0034] The logistics data of the waybill associated with the master order will be used as the query result.
[0035] According to another aspect of the present invention, a waybill data query device is also provided, comprising:
[0036] The first receiving module is configured to receive query requests for logistics data of the current order, wherein the current order shares the same waybill with multiple other orders;
[0037] The main order query module is configured to query a main order from the current order and multiple orders that share the same waybill with the current order, and the logistics data of the waybill is associated with the main order for storage;
[0038] The logistics data query module is configured to use the logistics data of the waybill associated with the main order as the query result.
[0039] According to another aspect of the present invention, a waybill data storage device is also provided, wherein multiple orders share the same waybill, and the waybill data management device includes:
[0040] The second receiving module is configured to receive the shipment message for the current order;
[0041] The judgment module is configured to determine whether the waybill for the current order is currently associated with another order;
[0042] The master order marking module is configured to mark the current order as a master order when the judgment module determines that it is not true, and to store the waybill data of the waybill as associated with the master order.
[0043] The sub-order marking module is configured to mark the current order as a sub-order when the judgment module determines that it is true.
[0044] The logistics data storage module is configured to receive the logistics data of the waybill and associate the logistics data of the waybill with the main order storage.
[0045] According to another aspect of the present invention, a waybill data management device is also provided, comprising:
[0046] The waybill data query device as described above; and
[0047] The waybill data storage device as described above.
[0048] According to another aspect of the present invention, an electronic device is also provided, the electronic device comprising: a processor; and a storage medium having a computer program stored thereon, the computer program being executed by the processor to perform the steps described above.
[0049] According to another aspect of the present invention, a storage medium is also provided, on which a computer program is stored, the computer program being executed by a processor to perform the steps described above.
[0050] Compared with the prior art, the advantages of this invention are:
[0051] This invention links the logistics data of a waybill to the storage of the master order, so that the logistics data of multiple orders sharing the same waybill can be queried through the master order. This enables the storage, management and querying of waybill data shared by multiple orders using the same waybill, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time and reducing resource waste. Attached Figure Description
[0052] The above and other features and advantages of the present invention will become more apparent from a detailed description of exemplary embodiments thereof with reference to the accompanying drawings.
[0053] Figure 1 A flowchart of a waybill data query method according to an embodiment of the present invention is shown.
[0054] Figure 2 A flowchart of a waybill data storage method according to an embodiment of the present invention is shown.
[0055] Figure 3 A flowchart of a waybill data management method according to an embodiment of the present invention is shown.
[0056] Figure 4 A block diagram of a waybill data query device according to an embodiment of the present invention is shown.
[0057] Figure 5 A block diagram of a waybill data storage device according to an embodiment of the present invention is shown.
[0058] Figure 6 A block diagram of a waybill data management device according to an embodiment of the present invention is shown.
[0059] Figure 7 The schematic diagram illustrates a computer-readable storage medium according to an exemplary embodiment of the present invention.
[0060] Figure 8 The schematic diagram illustrates an electronic device according to an exemplary embodiment of the present invention. Detailed Implementation
[0061] Exemplary embodiments will now be described more fully with reference to the accompanying drawings. However, these exemplary embodiments can be implemented in many forms and should not be construed as limited to the examples set forth herein; rather, they are provided so that the invention will be more comprehensive and complete, and will fully convey the concept of the exemplary embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0062] Furthermore, the accompanying drawings are merely illustrative of the invention and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and therefore repeated descriptions of them will be omitted. Some block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software, in one or more hardware modules or integrated circuits, or in different network and / or processor devices and / or microcontroller devices.
[0063] The flowchart shown in the attached diagram is merely an illustrative example and does not necessarily include all steps. For example, some steps may be broken down, while others may be combined or partially combined. Therefore, the actual execution order may change depending on the specific circumstances.
[0064] In various embodiments of the present invention, the waybill data storage, query and management method provided by the present invention is preferably applied to e-commerce platforms, but the application scenarios of the present invention are not limited thereto, and will not be elaborated here.
[0065] Figure 1 A flowchart of a waybill data query method according to an embodiment of the present invention is shown. The waybill data query method includes the following steps:
[0066] Step S110: Receive a query request for the logistics data of the current order, wherein the current order shares the same waybill with multiple orders.
[0067] Specifically, in scenarios such as e-commerce platforms, multiple orders often share the same waybill. Therefore, each order involves operations such as storing, querying, and managing logistics data. Step S110 can be receiving a query request for the logistics data of the current order triggered by user interaction. Step S110 can also be a logistics data query request automatically triggered by the system (e.g., periodically triggered, or triggered by calls to other services). This invention is not limited thereto.
[0068] Step S120: Query a master order from the current order and multiple orders that share the same waybill with the current order, and store the logistics data of the waybill in association with the master order.
[0069] Specifically, when multiple orders share the same waybill, this invention identifies a master order among the shared waybills and associates the waybill's logistics data with the master order's storage. This eliminates the need to associate and store the same logistics data for each non-master order (sub-order). In a preferred embodiment, the waybill's logistics data can be associated only with the master order's storage, thereby minimizing the storage of duplicate data and improving system query efficiency.
[0070] Specifically, multiple orders sharing the same waybill can be interconnected by associating the waybill's identifier. The waybill is associated with the identifier of the master order. The waybill can also be associated with the identifiers of all orders sharing it, and the master order among them can be marked. Therefore, the master order associated with the waybill can be queried using the waybill identifier associated with the current order. Thus, by achieving the association between orders and waybills, and marking the master order, the relationship between orders and waybills can be realized. Compared to the embodiment where sub-orders are directly associated with the master order, when the master order changes, it is not necessary to change the master order associated with each sub-order; only the master order associated with the waybill needs to be changed, making the change operation simple and quick.
[0071] Specifically, in some embodiments, the first order to provide shipping information among multiple orders sharing the same waybill can be designated as the master order. In other words, since the first order to provide shipping information is designated as the master order, all orders under a single waybill are master orders, and there are no subsequent orders to ship, thus no secondary orders. This facilitates unified implementation of waybill data storage and management for a single waybill, eliminating the need for separate management of single waybill orders and multiple orders under a single waybill.
[0072] In some embodiments of the present invention, there are situations where the main order is abnormal (such as order recalls or other abnormal order situations). To ensure that secondary orders can still query and obtain the logistics data of the waybill when the main order is abnormal, this embodiment provides a step of re-determining the main order. For example, when the main order is abnormal, a new main order is determined from multiple orders that share the same waybill with the main order, and the logistics data of the waybill associated with the previous main order is associated with the current main order. This achieves the migration of the waybill's logistics data, so that secondary orders can still query the logistics data of the same waybill from the database associated with the new main order.
[0073] In the above embodiments, a master order can be re-determined in the following way: for example, among multiple orders sharing the same waybill with the master order, the first order that provides shipping information is selected as the re-determined master order. This method is consistent with the initial determination of the master order, thereby facilitating the reuse of the master order determination service. In some variations, the master order can also be re-determined in other ways. For example, based on the probability of anomalies in the orders shipped by the sender, the order with the lowest anomaly probability can be selected as the re-determined master order. This method can reduce the probability of orders becoming abnormal again, thus requiring data migration and re-determining the master order, reducing system processing steps and improving system efficiency. Furthermore, the present invention does not limit the number of times the master order is re-determined. For example, whenever the current master order is abnormal (unable to update logistics data and / or predict logistics timeliness), the step of re-selecting the master order can be performed.
[0074] Step S130: Use the logistics data of the waybill associated with the master order as the query result.
[0075] Specifically, step S130 is equivalent to reading the logistics data of the waybill through the database associated with the main order, and then using it as the query result of the logistics data of the current order.
[0076] Specifically, step S130 can be implemented through a custom query interface. For example, a query interface can be defined to support order number queries. If it is a primary order, the result is obtained directly; if it is a secondary order, the result is obtained and displayed after associating it with the primary order through the tracking number.
[0077] In various embodiments of the present invention, the logistics data of the waybill is updated in real time and associated with the current master order storage. The logistics data of the waybill may include physical trajectory and predicted delivery time. The present invention can realize more meanings of logistics data, which will not be elaborated here.
[0078] Specifically, in one implementation of the present invention, the query request in step S110 can be triggered by a user's query operation on the logistics data of the current order. For example, when a user clicks / touches the query control for the logistics data of the current order, the acquisition of the current order's identifier and the generation of the corresponding query request are triggered. Further, to facilitate a user's intuitive understanding of the logistics data of multiple orders sharing the same waybill, after step S130 where the logistics data of the waybill associated with the main order is used as the query result, a query results page can be provided to display the logistics data of the waybill associated with the main order; the query results page also provides order information for multiple orders sharing the same waybill with the current order. Thus, a user can learn on the query results page of one order that the current logistics data is also the logistics data of other sub-orders, without needing to exit the current page and click / touch the query control for the logistics data of another order to query the logistics data of the same waybill.
[0079] This invention also provides a method for storing waybill data. See below. Figure 2 , Figure 2 A flowchart illustrating a waybill data storage method according to an embodiment of the present invention is shown. In this embodiment, multiple orders share the same waybill, and the waybill data storage method includes:
[0080] Step S210: Receive the shipment message for the current order.
[0081] Step S220: Determine whether the current order's waybill is currently associated with another order.
[0082] Specifically, multiple orders sharing the same waybill are associated with the waybill when providing shipping information. For example, multiple orders sharing the same waybill can be linked to the waybill's identifier when shipping, thus achieving mutual association. The waybill can be associated with the identifiers of all orders sharing it, and the main order among them can be marked.
[0083] If step S220 determines no, then step S230 is executed: mark the current order as the main order, and store the waybill data of the waybill as associated with the main order.
[0084] If step S220 determines that it is yes, then step S240 is executed: mark the current order as a secondary order.
[0085] Therefore, through steps S210 to S240 above, the first order to provide shipping information among multiple orders sharing the same waybill can be designated as the master order. In other words, since the first order to provide shipping information is designated as the master order, all orders based on a single waybill are master orders, and since no subsequent orders are shipped, there are no sub-orders. This facilitates unified storage and management of waybill data for a single waybill, eliminating the need for separate management of single waybill orders and multiple orders per waybill.
[0086] Step S250: Receive the logistics data of the waybill and associate the logistics data of the waybill with the master order storage.
[0087] In various embodiments of the present invention, the logistics data of the waybill is updated in real time and associated with the current master order storage. The logistics data of the waybill may include physical trajectory and predicted delivery time. The present invention can realize more meanings of logistics data, which will not be elaborated here. Specifically, in the waybill data storage method, when the master order is abnormal, a new master order can be determined, and the migration of the waybill's logistics data can be performed, as described in the previous embodiment.
[0088] This invention also provides a method for managing waybill data. See below. Figure 3 , Figure 3 A flowchart of a waybill data management method according to an embodiment of the present invention is shown. In this embodiment, multiple orders share the same waybill, and the waybill data management method includes:
[0089] Step S210: Receive the shipment message for the current order;
[0090] Step S220: Determine whether the current order's waybill is currently associated with another order;
[0091] If step S220 determines no, then step S230 is executed: mark the current order as the main order, and store the waybill data of the waybill associated with the main order;
[0092] If step S220 determines that it is yes, then step S240 is executed: mark the current order as a secondary order;
[0093] Step S250: Receive the logistics data of the waybill and associate the logistics data of the waybill with the master order storage;
[0094] Step S110: Receive a query request for logistics data of the order to be queried;
[0095] Step S120: Query a master order from the order to be queried and multiple orders that share the same waybill with the order to be queried;
[0096] Step S130: Use the logistics data of the waybill associated with the master order as the query result.
[0097] The waybill data storage and retrieval methods in the waybill data management approach can be categorized by... Figure 1 and Figure 2 The steps shown are implemented and will not be repeated here.
[0098] In the waybill data storage, query and management method provided by the present invention, by associating the logistics data of the waybill with the storage of the master order, the logistics data of multiple orders sharing the same waybill can be queried through the master order. Thus, the storage, management and query of waybill data of multiple orders sharing the same waybill are realized, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time and reducing resource waste.
[0099] The above are merely several specific implementations of the waybill data storage, query, and management method of the present invention. Each implementation can be implemented independently or in combination, and the present invention is not intended to limit it. Furthermore, the flowchart of the present invention is merely illustrative, and the execution order between the steps is not limited thereto. The splitting, merging, sequential exchange, and other synchronous or asynchronous execution methods of the steps are all within the protection scope of the present invention.
[0100] See below for details. Figure 4-6 , Figure 4 A block diagram of a waybill data query device according to an embodiment of the present invention is shown. Figure 5 A block diagram of a waybill data storage device according to an embodiment of the present invention is shown.
[0101] Figure 6 A block diagram of a waybill data management device according to an embodiment of the present invention is shown. Figures 4 to 6 In the embodiments shown, multiple orders share the same waybill.
[0102] like Figure 4 The waybill data query device 310 includes a first receiving module 311, a main order query module 312, and a logistics data query module 313.
[0103] The first receiving module 311 is configured to receive query requests for logistics data of the current order, wherein the current order shares the same waybill with multiple orders;
[0104] The main order query module 312 is configured to query a main order from the current order and multiple orders that share the same waybill with the current order, and the logistics data of the waybill is associated with the main order for storage;
[0105] The logistics data query module 313 is configured to use the logistics data of the waybill associated with the main order as the query result.
[0106] like Figure 5 The waybill data storage device 320 includes a second receiving module 321, a judgment module 322, a main order marking module 323, a secondary order marking module 324, and a logistics data storage module 325.
[0107] The second receiving module 321 is configured to receive the shipment message for the current order;
[0108] The judgment module 322 is configured to determine whether the waybill for the current order is currently associated with another order;
[0109] The master order marking module 323 is configured to mark the current order as a master order when the judgment module determines that it is not true, and to store the waybill data of the waybill as associated with the master order.
[0110] The secondary order marking module 324 is configured to mark the current order as a secondary order when the judgment module determines that it is true;
[0111] The logistics data storage module 325 is configured to receive the logistics data of the waybill and associate the logistics data of the waybill with the master order storage.
[0112] like Figure 6 The waybill data management device 300 may include, for example, Figure 4 The waybill data query device 310 shown and such Figure 5 The waybill data storage device 320 shown.
[0113] In the waybill data storage, query, and management device of the exemplary embodiment of the present invention, by associating the logistics data of the waybill with the master order storage, the logistics data of multiple orders sharing the same waybill can be queried through the master order. Thus, the storage, management, and query of waybill data of multiple orders sharing the same waybill are realized, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time, and reducing resource waste.
[0114] Figure 4-6 The diagrams illustratively illustrate the waybill data query device 310, waybill data storage device 320, and waybill data management device 300 provided by this invention. Without departing from the inventive concept, the splitting, merging, and addition of modules are all within the scope of protection of this invention. The waybill data query device 310, waybill data storage device 320, and waybill data management device 300 provided by this invention can be implemented by software, hardware, firmware, plugins, and any combination thereof; this invention is not limited thereto.
[0115] In exemplary embodiments of the present invention, a computer-readable storage medium is also provided, on which a computer program is stored, which, when executed by, for example, a processor, can implement the steps of the waybill data storage, retrieval, and management method described in any of the above embodiments. In some possible embodiments, various aspects of the present invention can also be implemented as a program product comprising program code, which, when run on a terminal device, causes the terminal device to perform the steps of the various exemplary embodiments of the present invention described in the above-described waybill data storage, retrieval, and management method section of this specification.
[0116] refer to Figure 7 As shown, a program product 700 for implementing the above-described method according to an embodiment of the present invention is described. It may employ a portable compact disc read-only memory (CD-ROM) and include program code, and may run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited thereto. In this document, the readable storage medium may be any tangible medium containing or storing a program that may be used by or in conjunction with an instruction execution system, apparatus, or device.
[0117] The program product may employ any combination of one or more readable media. A readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.
[0118] The computer-readable storage medium may include data signals propagated in baseband or as part of a carrier wave, carrying readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The readable storage medium may also be any readable medium other than a readable storage medium, capable of transmitting, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the readable storage medium may be transmitted using any suitable medium, including but not limited to wireless, wired, optical fiber, RF, etc., or any suitable combination thereof.
[0119] Program code for performing the operations of this invention can be written in any combination of one or more programming languages, including object-oriented programming languages such as Java and C++, and conventional procedural programming languages such as C or similar languages. The program code can execute entirely on the tenant's computing device, partially on the tenant's device, as a standalone software package, partially on the tenant's computing device and partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the tenant's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).
[0120] In an exemplary embodiment of the present invention, an electronic device is also provided, which may include a processor and a memory for storing executable instructions of the processor. The processor is configured to perform the steps of the waybill data storage, retrieval, and management method described in any of the above embodiments by executing the executable instructions.
[0121] Those skilled in the art will understand that various aspects of the present invention can be implemented as systems, methods, or program products. Therefore, various aspects of the present invention can be specifically implemented in the following forms: a completely hardware implementation, a completely software implementation (including firmware, microcode, etc.), or a combination of hardware and software aspects, collectively referred to herein as a "circuit," "module," or "system."
[0122] The following reference Figure 8 To describe an electronic device 500 according to this embodiment of the present invention. Figure 8 The electronic device 500 shown is merely an example and should not impose any limitations on the functionality and scope of use of the embodiments of the present invention.
[0123] like Figure 8 As shown, the electronic device 500 is presented in the form of a general-purpose computing device. The components of the electronic device 500 may include, but are not limited to: at least one processing unit 510, at least one storage unit 520, a bus 530 connecting different system components (including storage unit 520 and processing unit 510), a display unit 540, etc.
[0124] The storage unit stores program code that can be executed by the processing unit 510, causing the processing unit 510 to perform the steps described in the above-described method for storing, querying, and managing waybill data according to various exemplary embodiments of the present invention. For example, the processing unit 510 can perform actions such as... Figures 1 to 3 The steps shown in any one or more of the accompanying drawings.
[0125] The storage unit 520 may include a readable medium in the form of a volatile storage unit, such as a random access memory unit (RAM) 5201 and / or a cache storage unit 5202, and may further include a read-only memory unit (ROM) 5203.
[0126] The storage unit 520 may also include a program / utility 5204 having a set (at least one) program module 5205, such program module 5205 including but not limited to: an operating system, one or more application programs, other program modules and program data, each or some combination of these examples may include an implementation of a network environment.
[0127] Bus 530 can represent one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, a graphics acceleration port, a processing unit, or a local bus using any of the various bus structures.
[0128] Electronic device 500 can also communicate with one or more external devices 600 (e.g., keyboard, pointing device, Bluetooth device, etc.), and with one or more devices that enable tenants to interact with electronic device 500, and / or with any device that enables electronic device 500 to communicate with one or more other computing devices (e.g., router, modem, etc.). This communication can be performed via input / output (I / O) interface 550. Furthermore, electronic device 500 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 560. Network adapter 560 can communicate with other modules of electronic device 500 via bus 530. It should be understood that, although not shown in the figures, other hardware and / or software modules can be used in conjunction with electronic device 500, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0129] Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein can be implemented by software or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of the present invention can be embodied in the form of a software product. This software product can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, portable hard drive, etc.) or on a network, and includes several instructions to cause a computing device (such as a personal computer, server, or network device, etc.) to execute the above-described method for storing, querying, and managing waybill data according to the embodiments of the present invention.
[0130] Compared with the prior art, the advantages of this invention are:
[0131] This invention links the logistics data of a waybill to the storage of the master order, so that the logistics data of multiple orders sharing the same waybill can be queried through the master order. This enables the storage, management and querying of waybill data shared by multiple orders using the same waybill, thereby reducing the storage of duplicate data, reducing database pressure, improving system response time and reducing resource waste.
[0132] Other embodiments of the invention will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention that follow the general principles of the invention and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of the invention are indicated by the appended claims.
Claims
1. A method for querying waybill data, characterized in that, include: Receive a query request for logistics data of the current order, wherein the current order shares the same waybill with multiple orders, the multiple orders sharing the same waybill are associated with the identifier of the waybill, and the waybill is associated with the identifier of the main order; From the current order and multiple orders sharing the same waybill with the current order, query a master order, and store the logistics data of the waybill in association with the master order; The logistics data of the waybill associated with the main order will be used as the query result; The logistics data of the waybill is only associated with the main order storage; When the master order is abnormal, a new master order is determined from multiple orders that share the same waybill with the master order, and the logistics data of the waybill associated with the previous master order is associated with the current master order. Among the multiple orders sharing the same waybill with the master order, re-determining a master order includes: Among multiple orders that share the same waybill with the master order, the first order that provides shipping information will be designated as the new master order.
2. The waybill data query method as described in claim 1, characterized in that, Among multiple orders sharing the same waybill, the first order that provides shipping information will be designated as the master order.
3. The waybill data query method as described in claim 1 or 2, characterized in that, The logistics data of the waybill is updated in real time, and the logistics data of the waybill includes physical trajectory and predicted delivery time.
4. The waybill data query method as described in claim 1 or 2, characterized in that, The query request is triggered by the user's query operation on the logistics data of the current order.
5. The waybill data query method as described in claim 4, characterized in that, The step of using the logistics data of the waybill associated with the master order as the query result also includes: Provide a query results page to display the logistics data of the waybills associated with the main order; The query results page provides order information for multiple orders that share the same waybill as the current order.
6. A method for storing waybill data, characterized in that, Multiple orders share the same waybill, and the multiple orders sharing the same waybill are associated with the identifier of the waybill. The waybill is associated with the identifier of the main order. The waybill data storage method includes: Receive shipping information for the current order; Determine whether the current order's waybill is already associated with another order; If not, mark the current order as the main order and store the waybill data associated with the main order; If so, mark the current order as a secondary order; Receive the logistics data of the waybill and store the logistics data of the waybill only in relation to the main order; When the master order is abnormal, a new master order is determined from multiple orders that share the same waybill with the master order, and the logistics data of the waybill associated with the previous master order is associated with the current master order. Among the multiple orders sharing the same waybill with the master order, re-determining a master order includes: Among multiple orders that share the same waybill with the master order, the first order that provides shipping information will be designated as the new master order.
7. A method for managing waybill data, characterized in that, Multiple orders share the same waybill, and the multiple orders sharing the same waybill are associated with the identifier of the waybill. The waybill is associated with the identifier of the main order. The waybill data management method includes: Receive shipping information for the current order; Determine whether the current order's waybill is already associated with another order; If not, mark the current order as the main order and store the waybill data associated with the main order; If so, mark the current order as a secondary order; Receive the logistics data of the waybill and associate the logistics data of the waybill with the main order storage; Receive query requests for logistics data of the order to be queried; The system queries a single main order for orders pending query and multiple orders sharing the same waybill with the orders pending query. The logistics data of the waybill associated with the main order will be used as the query result; The logistics data of the waybill is only associated with the main order storage; When the master order is abnormal, a new master order is determined from multiple orders that share the same waybill with the master order, and the logistics data of the waybill associated with the previous master order is associated with the current master order. Among the multiple orders sharing the same waybill with the master order, re-determining a master order includes: Among multiple orders that share the same waybill with the master order, the first order that provides shipping information will be designated as the new master order.
8. A waybill data query device, characterized in that, include: The first receiving module is configured to receive query requests for logistics data of the current order. The current order shares the same waybill with multiple orders. The multiple orders sharing the same waybill are associated with the identifier of the waybill, and the waybill is associated with the identifier of the main order. The master order query module is configured to query a master order from the current order and multiple orders sharing the same waybill with the current order. The logistics data of the waybill is associated with the master order storage. When the master order is abnormal, a new master order is determined from the multiple orders sharing the same waybill with the master order, and the logistics data of the waybill associated with the previous master order is associated with the current master order storage. The process of determining a new master order from the multiple orders sharing the same waybill with the master order includes: taking the first order that provides shipping information from the multiple orders sharing the same waybill with the master order as the new master order. The logistics data query module is configured to use the logistics data of waybills associated with the main order as the query result, and the logistics data of the waybills is only associated with the main order storage.
9. A waybill data storage device, characterized in that, Multiple orders share the same waybill; the multiple orders sharing the same waybill are associated with the waybill's identifier; the waybill is associated with the main order's identifier; the waybill data management device includes: The second receiving module is configured to receive the shipment message for the current order; The judgment module is configured to determine whether the waybill for the current order is currently associated with another order; The master order marking module is configured to mark the current order as a master order and store the waybill data associated with the master order when the judgment module determines that it is not true; when the master order is abnormal, a new master order is determined from multiple orders that share the same waybill with the master order, and the logistics data of the waybill associated with the previous master order is associated with the current master order. The process of determining a new master order from multiple orders that share the same waybill with the master order includes: taking the first order that provides shipping information from the multiple orders that share the same waybill with the master order as the new master order. The sub-order marking module is configured to mark the current order as a sub-order when the judgment module determines that it is true. The logistics data storage module is configured to receive the logistics data of the waybill and store the logistics data of the waybill only in association with the main order.
10. A waybill data management device, characterized in that, include: The waybill data query device as described in claim 8; as well as The waybill data storage device as described in claim 9.
11. An electronic device, characterized in that, The electronic device includes: processor; A memory having a computer program stored thereon, the computer program being executed by the processor in one of the following ways: The waybill data query method as described in any one of claims 1 to 5; The waybill data storage method as described in claim 6; The waybill data management method as described in claim 7.
12. A storage medium, characterized in that, The storage medium stores a computer program, which, when executed by a processor, performs one of the following methods: The waybill data query method as described in any one of claims 1 to 5; The waybill data storage method as described in claim 6; The waybill data management method as described in claim 7.
Citation Information
Patent Citations
Method and system for searching child-mother piece and storage medium
CN109858995A