A data processing method and device

By updating the product data table in the warehouse system and processing requests from the front-end page, the problem of warehouse staff being unable to process expected arrival products in a timely manner is solved, achieving efficient and accurate product processing and maintenance.

CN114331261BActive Publication Date: 2025-01-17BEIJING JINGDONG ZHENSHI INFORMATION TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202111572931.5
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-21
Publication Date
2025-01-17
Estimated Expiration
2041-12-21

AI Technical Summary

Technical Problem

During warehouse operations, staff members are unable to process and maintain products expected to arrive in the warehouse in a timely manner, resulting in product damage, and the processing efficiency and accuracy based on product code or name are low.

Method used

By updating the product data table in the business system, receive the data query request from the front-end page, determine the target product data set based on the specified category information, display the product data, and after receiving the processing instructions, process the job type of the product data into a specific type.

Benefits of technology

It achieves timely processing and maintenance of products expected to arrive at the warehouse, prevents product damage, and improves processing efficiency and accuracy.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114331261B_ABST
    Figure CN114331261B_ABST
Patent Text Reader

Abstract

The present invention discloses a data processing method and device, and relates to the field of computer technology. A specific implementation of the method includes: updating product data in a first data table according to product data in a business system; receiving a data query request sent by a front-end page, and in the case where the data query request specifies category information, determining a target product data set in the first data table according to the category information specified by the data query request, wherein the product data in the target product data set contains the specified category information; displaying the product data in the target product data set to the front-end page; after receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page, processing the job type corresponding to part or all of the product data into a specific type. This implementation can timely process and maintain products expected to arrive at a grid station, prevent damage to the products, and improve processing efficiency and accuracy.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a data processing method and device. Background Art

[0002] In warehouse operations, it is necessary to process the operation types of some or all products that have arrived at the warehouse in the past few days as specific types of operations. The current solution is for staff to process by product code or product name, and products generally arrive at the warehouse in the early morning, which will result in users being unable to add products that are expected to arrive at the warehouse and unable to maintain specific types of products in time, affecting warehouse operations.

[0003] In the process of implementing the present invention, the inventors found that there are at least the following problems in the prior art:

[0004] Staff are unable to handle and maintain products expected to arrive at the warehouse in a timely manner, which can easily cause damage to the products, and the processing efficiency and accuracy based on product codes or product names are low. Summary of the invention

[0005] In view of this, an embodiment of the present invention provides a data processing method and device, which can timely process and maintain products expected to arrive at a warehouse, prevent damage to the products, and improve processing efficiency and accuracy.

[0006] To achieve the above objective, according to one aspect of an embodiment of the present invention, a data processing method is provided.

[0007] A data processing method comprises: updating product data in a first data table according to product data in a business system; receiving a data query request sent by a front-end page, and, when the data query request specifies category information, determining a target product data set in the first data table according to the category information specified by the data query request, wherein the product data in the target product data set contains the specified category information; displaying the product data in the target product data set to the front-end page; and processing the job type corresponding to the part or all of the product data as a specific type after receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page.

[0008] Optionally, updating the product data in the first data table according to the product data in the business system includes: obtaining, from a message queue of the business system, a product code that is periodically pushed by the business system after a preset time point; determining whether the product data in the first data table includes the pushed product code, and if so, querying the business system for category information corresponding to the pushed product code by calling an interface of the business system, and updating the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; otherwise, saving the product data in the business system that contains the pushed product code to the first data table.

[0009] Optionally, saving the product data containing the pushed product code in the business system to the first data table includes: querying the business system for category information corresponding to the pushed product code by calling an interface of the business system; if the category information corresponding to the pushed product code is queried, saving the product data containing the pushed product code in the business system and the category information corresponding to the pushed product code to the first data table, and obtaining the product data containing the product code in the first data table; if the category information corresponding to the pushed product code is not queried, saving the product data containing the pushed product code in the business system to the first data table, and obtaining the product data containing the product code in the first data table.

[0010] Optionally, determining the target product data set in the first data table according to the category information specified in the data query request includes: according to the category information specified in the data query request, querying the first data table for product data including the specified category information to obtain a first product data set; and filtering out product data whose corresponding job type is the specific type in the first product data set according to the product code to obtain the target product data set.

[0011] Optionally, filtering out product data whose corresponding job type in the first product data set is the specific type according to the product code includes: for each product data in the first product data set, determining whether the product code exists in a second data table; if so, filtering out the product data including the product code from the first product data set, wherein the second data table is a data table for storing product data whose job type is the specific type.

[0012] Optionally, processing the job type corresponding to the part or all of the product data into a specific type includes: storing the part or all of the product data in the second data table.

[0013] Optionally, it also includes: when the data query request specifies a product code, querying the first data table according to the product code specified in the data query request; when the specified product code exists in the first data table, displaying the product data including the specified product code on the front-end page; when the specified product code does not exist in the first data table, obtaining the product data including the specified product code from the business system by calling the interface of the business system, and displaying the product data including the specified product code on the front-end page.

[0014] Optionally, after displaying the product data including the specified product code on the front-end page, the method includes: after receiving a processing instruction for the product data including the specified product code sent by the front-end page, processing the job type corresponding to the product data including the specified product code into the specific type.

[0015] Optionally, processing the job type corresponding to the product data including the specified product code as the specific type includes: storing the product data including the specified product code in a second data table, the second data table being a data table for storing product data whose job type is the specific type.

[0016] According to another aspect of an embodiment of the present invention, a data processing device is provided.

[0017] A data processing device includes: a product data update module, which is used to update product data in a first data table according to product data in a business system; a target product data set determination module, which is used to receive a data query request sent by a front-end page, and when the data query request specifies category information, determine the target product data set in the first data table according to the category information specified by the data query request, wherein the product data in the target product data set contains the specified category information; a product data display module, which is used to display the product data in the target product data set to the front-end page; and a product data processing module, which is used to process the job type corresponding to part or all of the product data in the target product data set into a specific type after receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page.

[0018] Optionally, the product data update module is also used to: obtain from the message queue of the business system the product code that is periodically pushed by the business system after a preset time point; determine whether the product data in the first data table includes the pushed product code, and if so, query the category information corresponding to the pushed product code in the business system by calling the interface of the business system, and update the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; otherwise, save the product data in the business system containing the pushed product code to the first data table.

[0019] Optionally, the product data update module is also used to: query the category information corresponding to the pushed product code in the business system by calling the interface of the business system; if the category information corresponding to the pushed product code is queried, the product data including the pushed product code in the business system and the category information corresponding to the pushed product code are saved to the first data table, and the product data including the product code in the first data table is obtained; if the category information corresponding to the pushed product code is not queried, the product data including the pushed product code in the business system is saved to the first data table, and the product data including the product code in the first data table is obtained.

[0020] Optionally, the target product data set determination module is also used to: query the first data table for product data including the specified category information according to the category information specified in the data query request, to obtain a first product data set; and filter out the product data whose corresponding job type in the first product data set is the specific type according to the product code, to obtain the target product data set.

[0021] Optionally, the target product data set determination module is also used to: for each product data in the first product data set, determine whether the product code exists in a second data table; if so, filter out the product data including the product code from the first product data set, wherein the second data table is a data table for storing product data whose job type is the specific type.

[0022] Optionally, the product data processing module is further used to: store part or all of the product data into the second data table.

[0023] Optionally, it also includes a product code query module, which is used to: when the data query request specifies a product code, query the first data table according to the product code specified in the data query request; when the specified product code exists in the first data table, display the product data including the specified product code on the front-end page; when the specified product code does not exist in the first data table, obtain the product data including the specified product code from the business system by calling the interface of the business system, and display the product data including the specified product code on the front-end page.

[0024] Optionally, it also includes a product code processing module, which is used to: after receiving a processing instruction for the product data including the specified product code sent by the front-end page, process the job type corresponding to the product data including the specified product code into the specific type.

[0025] Optionally, the product code processing module is further used to: store the product data including the specified product code in a second data table, where the second data table is a data table for storing product data whose job type is the specific type.

[0026] According to yet another aspect of the embodiments of the present invention, an electronic device is provided.

[0027] An electronic device comprises: one or more processors; a memory for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement the data processing method provided in an embodiment of the present invention.

[0028] According to yet another aspect of an embodiment of the present invention, a computer readable medium is provided.

[0029] A computer readable medium stores a computer program, which, when executed by a processor, implements the data processing method provided by an embodiment of the present invention.

[0030] An embodiment of the above invention has the following advantages or beneficial effects: updating product data in the first data table according to product data in the business system; receiving a data query request sent by the front-end page, and in the case where the data query request specifies category information, determining the target product data set in the first data table according to the category information specified by the data query request, and the product data in the target product data set contains the specified category information; displaying the product data in the target product data set to the front-end page; after receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page, processing the job type corresponding to part or all of the product data into a specific type. It is possible to timely process and maintain products expected to arrive at the warehouse, prevent product damage, and improve processing efficiency and accuracy.

[0031] 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

[0032] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.

[0033] Figure 1 is a schematic diagram of main steps of a data processing method according to an embodiment of the present invention;

[0034] Figure 2 is a process intention for maintaining a specific type of merchandise in a warehouse according to an embodiment of the present invention;

[0035] Figure 3 is a schematic diagram of main modules of a data processing device according to an embodiment of the present invention;

[0036] Figure 4 is an exemplary system architecture diagram to which embodiments of the present invention may be applied;

[0037] Figure 5 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

[0038] 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.

[0039] Figure 1 It is a schematic diagram of main steps of a data processing method according to an embodiment of the present invention.

[0040] like Figure 1 As shown, a data processing method according to an embodiment of the present invention mainly includes the following steps S101 to S104.

[0041] Step S101: Update product data in the first data table according to product data in the business system.

[0042] The first data table is a data table containing product data of product codes pushed by the business system and category information corresponding to the pushed product codes.

[0043] Updating the product data in the first data table according to the product data in the business system may include: obtaining, from the message queue of the business system, the product code that is regularly pushed by the business system after a preset time point; determining whether the product data in the first data table includes the pushed product code, and if so, querying the business system for category information corresponding to the pushed product code by calling an interface of the business system, and updating the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; otherwise, saving the product data in the business system containing the pushed product code to the first data table.

[0044] Saving product data containing a pushed product code in a business system to a first data table may include: querying the business system for category information corresponding to the pushed product code by calling an interface of the business system; if the category information corresponding to the pushed product code is queried, saving the product data containing the pushed product code and the category information corresponding to the pushed product code in the business system to the first data table, and obtaining the product data containing the product code in the first data table; if the category information corresponding to the pushed product code is not queried, saving the product data containing the pushed product code in the business system to the first data table, and obtaining the product data containing the product code in the first data table.

[0045] Step S102: receiving a data query request sent by the front-end page, and in the case where the data query request specifies category information, determining a target product data set in the first data table according to the category information specified by the data query request, wherein the product data in the target product data set contains the specified category information.

[0046] Determining a target product data set in the first data table according to the category information specified in the data query request may include: according to the category information specified in the data query request, querying the first data table for product data including the specified category information to obtain the first product data set; and filtering out product data corresponding to a specific type of operation type in the first product data set according to the product code to obtain the target product data set.

[0047] Filtering out product data whose corresponding operation type in the first product data set is a specific type according to the product code may include: for each product data in the first product data set, determining whether the product code exists in the second data table; if so, filtering out the product data including the product code from the first product data set, wherein the second data table is a data table for storing product data whose operation type is a specific type.

[0048] Step S103: Display the product data in the target product data set on the front-end page.

[0049] Step S104: after receiving the processing instruction for part or all of the product data in the target product data set sent by the front-end page, the job type corresponding to part or all of the product data is processed into a specific type.

[0050] Processing the job type corresponding to part or all of the product data as a specific type may include: storing part or all of the product data in a second data table.

[0051] When a product code is specified in a data query request, the first data table is queried according to the product code specified in the data query request; when the specified product code exists in the first data table, the product data including the specified product code is displayed on the front-end page; when the specified product code does not exist in the first data table, the product data including the specified product code is obtained from the business system by calling an interface of the business system, and the product data including the specified product code is displayed on the front-end page.

[0052] After displaying the product data including the specified product code on the front-end page, it may include: after receiving a processing instruction for the product data including the specified product code sent by the front-end page, processing the job type corresponding to the product data including the specified product code into a specific type.

[0053] Among them, processing the job type corresponding to the product data including the specified product code as a specific type may include: storing the product data including the specified product code in a second data table, the second data table being a data table for storing product data whose job type is a specific type.

[0054] Figure 2 It is a process intention for maintaining a specific type of commodity in a warehouse according to an embodiment of the present invention, wherein the commodity is a product.

[0055] like Figure 2As shown, the data processing method in this embodiment, that is, the process of maintaining a specific type of goods in the warehouse can be executed by the warehouse back-end server (referred to as the warehouse back-end), the goods are sorted and packaged in the warehouse, and the first data table is a data table containing the commodity data of the commodity code pushed by the business system and the category information corresponding to the pushed commodity code, that is, Figure 2 The second data table is a data table for storing commodity data of a specific type of operation type, and the data table is a data table different from the first data table.

[0056] According to the commodity data in the business system, the commodity data in the first data table is updated. Specifically, the business system issues pre-arrangement data at a preset fixed time every day and pushes it to the message queue. The warehouse backend server consumes and obtains the commodity code from the message queue of the business system, wherein the pre-arrangement data includes one or more commodity codes. Determine whether the commodity data in the warehouse's database table (i.e., the first data table) includes the pushed commodity code. If so, query the business system for the category (i.e., category) information corresponding to the pushed commodity code by calling the interface of the business system, that is, query the business system by the commodity code through the interface. If the category information is queried, update the category information corresponding to the commodity code in the first data table according to the category information corresponding to the pushed commodity code in the business system. Specifically, the category information corresponding to the commodity code in the database table can be updated by updating / adding the corresponding commodity, category, update time and other information in the database table; otherwise, save the commodity data containing the pushed commodity code in the business system. To the first data table, specifically, by calling the interface of the business system, the category information corresponding to the pushed commodity code can be queried in the business system. If the category information corresponding to the pushed commodity code is queried, the commodity data including the pushed commodity code and the category information corresponding to the pushed commodity code in the business system are saved to the first data table, and the commodity data including the commodity code in the first data table is obtained, that is, the step of updating / adding the corresponding commodity, category, update time and other information in the database table. If the category information corresponding to the pushed commodity code is not queried, the commodity data including the pushed commodity code in the business system is saved to the first data table, and the commodity data including the commodity code in the first data table is obtained, that is, Figure 2 Newly added data in (excluding categories).

[0057] On the warehouse front page, you can query product data by category information, that is, add a specific type of product to the warehouse front page and select a category; or query product data by product code, that is, add a specific type of product to the warehouse front page and query the product code, so that the corresponding product data is displayed on the front page. Specifically, the data query request sent by the warehouse front page to the warehouse back end server can carry the specified category information or product code. In the case where the data query request specifies category information, the commodity data including the specified category information is queried in the first data table according to the category information specified in the data query request to obtain a first commodity data set. The first commodity data set is all commodity data queried according to the specified category information. When maintaining a specific type of commodity, the warehouse backend of the embodiment of the present invention will store the commodity data of the specific type of commodity operation in the second data table, that is, the commodity data of the maintained specific type of commodity operation exists in the first data table and the second data table at the same time. Therefore, at this time, the first commodity data set obtained by querying according to the category information may contain the commodity data of the maintained specific type of commodity operation, that is, the commodity data existing in the second data table; for each commodity code in the first commodity data set, it is determined whether the commodity code exists in the second data table (that is, the data table storing the commodity data of the operation type of the specific type). If so, the commodity data including the commodity code is filtered out from the first commodity data set, so that the warehouse front-end page can display all commodities that have been to the warehouse except for those that have been processed as the specific type stored in the database table, that is, the maintained commodities are eliminated according to the commodity code to avoid repeated maintenance. In the case where the data query request specifies a product code, the first data table is queried according to the product code specified in the data query request. If the specified product code exists in the first data table, the product data including the specified product code is displayed on the front-end page of the warehouse. If the specified product code does not exist in the first data table, the product data including the specified product code is obtained from the business system by calling the interface of the business system, and the product data including the specified product code is displayed on the front-end page. Before the product data is displayed, the product data can be updated to the first data table by updating / adding the corresponding product, category, update time and other information in the database table (corresponding to the query result of "yes", that is, the corresponding category information) or adding data (not including category) (corresponding to the query result of "no", that is, the corresponding category information). If the product code does not exist in the business system and the first data table, the front-end page prompts that there is no such product code.

[0058] The operation type corresponding to part or all of the commodity data is processed as a specific type on the front-end page. Specifically, when the data query request specifies category information, the user selects the commodity code corresponding to the commodity to be maintained on the front-end page and clicks Add, indicating that specific type commodity maintenance is required for part or all of the commodity data in the target commodity data set, and the front-end page sends a processing instruction (used to instruct maintenance of commodity data) to the warehouse back-end server. After receiving the processing instruction for part or all of the commodity data in the target commodity data set sent by the front-end page, the warehouse back-end server stores part or all of the commodity data in the second data table, thereby processing the operation type corresponding to the part or all of the commodity data as a specific type (specific type commodity operation) to maintain the unmaintained commodities as specific types of commodities. In the case where the data query request specifies the commodity code, the user selects the commodity code corresponding to the commodity to be maintained on the front-end page and clicks Add, indicating that the commodity data corresponding to the commodity code needs to be maintained for a specific type of commodity. The front-end page sends a processing instruction to the warehouse back-end server. After receiving the processing instruction for the commodity data including the specified commodity code sent by the front-end page, the warehouse back-end server stores the commodity data including the specified commodity code in the second data table, thereby processing the operation type corresponding to the commodity data including the specified commodity code as a specific type, so as to maintain the unmaintained commodity as a specific type of commodity. By processing the operation type of the commodity data by storing the commodity data in the second data table, it is possible to achieve flexible maintenance of specific types of commodities. For example, according to the needs of warehouse operations, when a certain commodity no longer needs to be maintained as an instruction commodity, it is only necessary to delete the commodity data from the second data table, and the operation type of the commodity data will be automatically restored from the specific type of commodity operation to the ordinary commodity operation. For commodity data that exists in the first data table and does not exist in the second data table, its operation type is an ordinary commodity operation.

[0059] Above Figure 2 The process can be applied to the scenario of maintaining direct-collection goods in the grid station. The specific operation type can be the direct-collection goods operation, and the general operation type can be the sowing goods operation. Among them, the grid station is a type of warehouse. The grid station is a transfer station connected to the central warehouse, which is responsible for setting the orders of all stores within the range. The grid station operation can be divided into two types of operation types: sowing goods (ordinary small goods) and direct-collection goods (large goods, frozen goods). Direct-collection goods are goods that require warehouse maintenance, such as frozen goods, seafood, etc. The goods corresponding to the sowing goods operation and the direct-collection goods operation occupy different commodity grids. Among them, the goods of the sowing goods operation occupy the sowing grid, and the goods of the direct-collection goods operation occupy the direct-collection grid. Different grids are sown to different operation lines during subsequent sowing in the warehouse.

[0060] Figure 3 4 is a schematic diagram of main modules of a data processing device according to an embodiment of the present invention.

[0061] like Figure 3 As shown, a data processing device 300 according to an embodiment of the present invention mainly includes: a product data updating module 301 , a target product data set determining module 302 , a product data display module 303 , and a product data processing module 304 .

[0062] In one embodiment, the product data update module is specifically used to: obtain the product code that is regularly pushed by the business system after a preset time point from the message queue of the business system; determine whether the product data in the first data table includes the pushed product code, and if so, query the category information corresponding to the pushed product code in the business system by calling the interface of the business system, and update the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; otherwise, save the product data in the business system containing the pushed product code to the first data table.

[0063] In one embodiment, the product data update module is specifically used to: query the category information corresponding to the pushed product code in the business system by calling the interface of the business system; if the category information corresponding to the pushed product code is queried, the product data including the pushed product code and the category information corresponding to the pushed product code in the business system are saved to the first data table, and the product data including the product code in the first data table are obtained; if the category information corresponding to the pushed product code is not queried, the product data including the pushed product code in the business system are saved to the first data table, and the product data including the product code in the first data table are obtained.

[0064] In one embodiment, the target product data set determination module is specifically used to: query the product data including the specified category information in the first data table according to the category information specified in the data query request to obtain the first product data set; filter out the product data corresponding to the specific type of operation type in the first product data set according to the product code to obtain the target product data set.

[0065] In one embodiment, the target product data set determination module is specifically used to: for each product code in the first product data set, determine whether the product code exists in the second data table; if so, filter out the product data including the product code from the first product data set, wherein the second data table is a data table for storing product data whose operation type is a specific type.

[0066] In one embodiment, the product data processing module is specifically used to store part or all of the product data into the second data table.

[0067] In one embodiment, a product code query module may also be included, which is used to: when a data query request specifies a product code, query the first data table according to the product code specified in the data query request; when the specified product code exists in the first data table, display the product data including the specified product code on the front-end page; when the specified product code does not exist in the first data table, obtain the product data including the specified product code from the business system by calling the interface of the business system, and display the product data including the specified product code on the front-end page.

[0068] In one embodiment, a product code processing module may also be included, which is used to: after receiving a processing instruction for product data including a specified product code sent by a front-end page, process the job type corresponding to the product data including the specified product code into a specific type.

[0069] In one embodiment, the product code processing module is specifically used to: store product data including a specified product code into a second data table, where the second data table is a data table for storing product data of a specific type of operation type.

[0070] In addition, the specific implementation content of the data processing device in the embodiment of the present invention has been described in detail in the above data processing method, so the repeated content will not be described again here.

[0071] Figure 4 An exemplary system architecture 400 is shown to which the data processing method or data processing device according to the embodiment of the present invention can be applied.

[0072] like Figure 4 As shown, system architecture 400 may include terminal devices 401, 402, 403, network 404 and server 405. Network 404 is used to provide a medium for communication links between terminal devices 401, 402, 403 and server 405. Network 404 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0073] Users can use terminal devices 401, 402, 403 to interact with server 405 through network 404 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 401, 402, 403, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only as examples).

[0074] The terminal devices 401 , 402 , and 403 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.

[0075] The server 405 may be a server that provides various services, such as a backend management server (only an example) that provides support for shopping websites browsed by users using the terminal devices 401, 402, and 403. The backend management server may analyze and process the received data such as product information query requests, and feed back the processing results (such as target push information, product information - only an example) to the terminal device.

[0076] It should be noted that the data processing method provided in the embodiment of the present invention is generally executed by the server 405 , and accordingly, the data processing device is generally disposed in the server 405 .

[0077] It should be understood that Figure 4 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.

[0078] Reference below Figure 5 , which shows a schematic diagram of the structure of a computer system 500 of a terminal device or a server suitable for implementing an embodiment of the present invention. Figure 5 The terminal device or server shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0079] like Figure 5 As shown, the computer system 500 includes a central processing unit (CPU) 501, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 502 or a program loaded from a storage part 508 into a random access memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the system 500 are also stored. The CPU 501, the ROM 502, and the RAM 503 are connected to each other via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.

[0080] The following components are connected to the I / O interface 505: an input section 506 including a keyboard, a mouse, etc.; an output section 507 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 508 including a hard disk, etc.; and a communication section 509 including a network interface card such as a LAN card, a modem, etc. The communication section 509 performs communication processing via a network such as the Internet. A drive 510 is also connected to the I / O interface 505 as needed. A removable medium 511, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 510 as needed, so that a computer program read therefrom is installed into the storage section 508 as needed.

[0081] 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 509, and / or installed from the removable medium 511. When the computer program is executed by the central processing unit (CPU) 501, the above-mentioned functions defined in the system of the present invention are executed.

[0082] 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.

[0083] 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.

[0084] The modules involved in the embodiments of the present invention may be implemented by software or hardware. The modules described may also be set in a processor, for example, it may be described as: a processor includes a product data update module, a target product data set determination module, a product data display module, and a product data processing module. The names of these modules do not constitute a limitation on the modules themselves in some cases. For example, the product data update module may also be described as "a module for updating product data in the first data table according to product data in the business system".

[0085] 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: updating the product data in the first data table according to the product data in the business system; receiving a data query request sent by a front-end page, and in the case where the data query request specifies category information, determining the target product data set in the first data table according to the category information specified by the data query request, and the product data in the target product data set contains the specified category information; displaying the product data in the target product data set to the front-end page; after receiving the processing instruction for part or all of the product data in the target product data set sent by the front-end page, processing the job type corresponding to part or all of the product data into a specific type.

[0086] According to the technical solution of the embodiment of the present invention, the product data in the first data table is updated according to the product data in the business system; a data query request sent by the front-end page is received, and when the data query request specifies category information, the target product data set in the first data table is determined according to the category information specified by the data query request, and the product data in the target product data set contains the specified category information; the product data in the target product data set is displayed to the front-end page; after receiving the processing instruction for part or all of the product data in the target product data set sent by the front-end page, the job type corresponding to part or all of the product data is processed as a specific type. It is possible to timely process and maintain products expected to arrive at the warehouse, prevent product damage, and improve processing efficiency and accuracy.

[0087] 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 data processing method, characterized in that: include: Update the product data in the first data table according to the product data in the business system; receiving a data query request sent by a front-end page, and, if the data query request specifies category information, determining a target product data set in the first data table according to the category information specified by the data query request, wherein product data in the target product data set includes the specified category information; Displaying the product data in the target product data set on the front-end page; After receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page, processing the job type corresponding to the part or all of the product data into a specific type; The updating of the product data in the first data table according to the product data in the business system includes: obtaining, from a message queue of the business system, a product code that is regularly pushed by the business system after a preset time point; and determining whether the product data in the first data table includes the pushed product code; If so, query the category information corresponding to the pushed product code in the business system by calling the interface of the business system, and update the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; Otherwise, by calling the interface of the business system, the category information corresponding to the pushed product code is queried in the business system; if the category information corresponding to the pushed product code is queried, the product data including the pushed product code in the business system and the category information corresponding to the pushed product code are saved to the first data table, and the product data including the product code in the first data table is obtained; if the category information corresponding to the pushed product code is not queried, the product data including the pushed product code in the business system is saved to the first data table, and the product data including the product code in the first data table is obtained.

2. The method according to claim 1, characterized in that The determining, according to the category information specified by the data query request, a target product data set in the first data table includes: According to the category information specified in the data query request, query the first data table for product data including the specified category information to obtain a first product data set; According to the product code, the product data corresponding to the specific type of operation in the first product data set is filtered out to obtain the target product data set.

3. The method according to claim 2, characterized in that The filtering out, according to the product code, product data corresponding to the specific type of operation in the first product data set includes: For the product code in each product data of the first product data set, determine whether the product code exists in the second data table. If so, filter out the product data including the product code from the first product data set, wherein the second data table is a data table for storing product data whose job type is the specific type.

4. The method according to claim 3, characterized in that The processing of the job type corresponding to the part or all of the product data into a specific type includes: The part or all of the product data is stored in the second data table.

5. The method according to claim 1, characterized in that Also includes: In the case where the data query request specifies a product code, querying the first data table according to the product code specified in the data query request; If the specified product code exists in the first data table, displaying product data including the specified product code on the front-end page; When the specified product code does not exist in the first data table, the product data including the specified product code is obtained from the business system by calling the interface of the business system, and the product data including the specified product code is displayed on the front-end page.

6. The method according to claim 5, characterized in that After displaying the product data including the specified product code on the front-end page, the method includes: After receiving the processing instruction for the product data including the designated product code sent by the front-end page, the job type corresponding to the product data including the designated product code is processed as the specific type.

7. The method according to claim 6, characterized in that The step of processing the job type corresponding to the product data including the designated product code into the specific type includes: The product data including the designated product code is stored in a second data table, which is a data table for storing product data whose job type is the specific type.

8. A data processing device, characterized in that: include: A product data updating module, used to update the product data in the first data table according to the product data in the business system; a target product data set determining module, configured to receive a data query request sent by a front-end page, and, if the data query request specifies category information, determine a target product data set in the first data table according to the category information specified by the data query request, wherein the product data in the target product data set contains the specified category information; A product data display module, used to display the product data in the target product data set on the front-end page; A product data processing module, configured to process the job type corresponding to part or all of the product data in the target product data set into a specific type after receiving a processing instruction for part or all of the product data in the target product data set sent by the front-end page; The updating of the product data in the first data table according to the product data in the business system includes: obtaining, from a message queue of the business system, a product code that is regularly pushed by the business system after a preset time point; and determining whether the product data in the first data table includes the pushed product code; If so, query the category information corresponding to the pushed product code in the business system by calling the interface of the business system, and update the category information corresponding to the product code in the first data table according to the category information corresponding to the pushed product code in the business system; Otherwise, by calling the interface of the business system, the category information corresponding to the pushed product code is queried in the business system; if the category information corresponding to the pushed product code is queried, the product data including the pushed product code in the business system and the category information corresponding to the pushed product code are saved to the first data table, and the product data including the product code in the first data table is obtained; if the category information corresponding to the pushed product code is not queried, the product data including the pushed product code in the business system is saved to the first data table, and the product data including the product code in the first data table is obtained.

9. An electronic device, 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 7.

10. A computer readable medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • File processing method and device, computer equipment and storage medium

    CN110069449A

  • Information display method and device

    CN113450170A