[go: up one dir, main page]

CN110619499B - Order information processing method, system and readable storage medium - Google Patents

Order information processing method, system and readable storage medium Download PDF

Info

Publication number
CN110619499B
CN110619499B CN201910900878.3A CN201910900878A CN110619499B CN 110619499 B CN110619499 B CN 110619499B CN 201910900878 A CN201910900878 A CN 201910900878A CN 110619499 B CN110619499 B CN 110619499B
Authority
CN
China
Prior art keywords
order
commodity
orders
same
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201910900878.3A
Other languages
Chinese (zh)
Other versions
CN110619499A (en
Inventor
张书煜
陈雷
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Deeking Cloud Computing Co ltd
Original Assignee
Kingdee Deeking Cloud Computing Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Kingdee Deeking Cloud Computing Co ltd filed Critical Kingdee Deeking Cloud Computing Co ltd
Priority to CN201910900878.3A priority Critical patent/CN110619499B/en
Publication of CN110619499A publication Critical patent/CN110619499A/en
Application granted granted Critical
Publication of CN110619499B publication Critical patent/CN110619499B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/083Shipping
    • G06Q10/0835Relationships between shipper or supplier and carriers

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Quality & Reliability (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the invention provides an order information processing method, an order information processing system and a readable storage medium, which are used for quickly screening a reynolds order number set with the same logistics company, a commodity code set and a commodity quantity set from a target order set so as to realize quick integration of the same order in a scene of multiple varieties and multiple orders. The method provided by the embodiment of the invention comprises the following steps: receiving input screening conditions; screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order; and integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same.

Description

Order information processing method, system and readable storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a new order processing method, system, and readable storage medium.
Background
There are two main schemes for checking out electric commerce currently known: 1. picking up goods according to the order; 2. picking up goods in batches.
In the first scheme, information of commodities, logistics companies and the like is extracted in sequence according to each order, the information is returned to a front-end interface, and warehouse personnel pick the commodities according to the orders.
And in the second scheme, a plurality of orders are screened out according to the same commodity information, and the same commodity information is summarized and returned to the front-end user interface.
The application scenes of the two schemes are mainly that warehouse management personnel pick up single-type inconsistency, namely one order at a time to select commodities and complete one-time goods distribution, and the two schemes are suitable for the single-type picking scene with few varieties and few orders; the commodity sorting system is suitable for the single picking scene with few varieties and multiple orders.
However, for a scene of multiple varieties and multiple orders, there is no appropriate order processing method for rapidly acquiring the order number set of the duplicate order.
Disclosure of Invention
The embodiment of the invention provides an order information processing method, an order information processing system and a readable storage medium, which are used for quickly screening a duplicate order number set with the same logistics company, commodity code set and commodity quantity set from a target order set so as to realize quick integration of the same order under the scene of multiple varieties and multiple orders.
A first aspect of the embodiments of the present application provides an order information processing method, including:
receiving input screening conditions;
screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
and integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same.
The integrating the target order set by adopting a method of grouping summary, order information sequencing and near variable accumulation comprises the following steps:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
and sequencing the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information.
The integrating the target order set by adopting a method of grouping and summarizing, ordering order information and accumulating near-neighbor variables further comprises the following steps:
and performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information.
The target order set is integrated by adopting a method of grouping and summarizing, order information sequencing and accumulation of near-term variables, and the method further comprises the following steps:
in the second integrated order information, screening out order information subjected to over-recording and merging from the orders with the same order numbers and the same logistics companies;
and grouping and sequencing the orders with different order numbers and the same orders subjected to the over-registration and combination according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
The integrating the target order set by adopting a method of grouping and summarizing, ordering order information and accumulating near-neighbor variables further comprises the following steps:
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
A second aspect of the embodiments of the present application provides an order information processing system, including:
the receiving unit is used for receiving input screening conditions;
the screening unit is used for screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
and the integration unit is used for integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the duplicate orders, wherein logistics companies, commodity code sets and commodity quantity sets of the duplicate orders are the same.
Wherein, the integration unit is specifically configured to:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the duplicate orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
and sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information.
Wherein, the integration unit is specifically configured to:
and performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information.
Wherein, the integration unit is specifically configured to:
screening out order information subjected to over-registration merging from orders with the same order numbers and the logistics companies in the second integrated order information;
and grouping and sequencing the orders with different order numbers and the same orders subjected to the recording and merging execution according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
Wherein, the integration unit is specifically configured to:
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
A third aspect of the present embodiment provides a computer system, including a processor, where the processor is configured to implement the order information processing method provided by the first aspect of the present embodiment when executing a computer program stored in a memory.
A fourth aspect of the embodiments of the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program is used, when executed by a processor, to implement the order information processing method provided in the first aspect of the embodiments of the present application.
According to the technical scheme, the embodiment of the invention has the following advantages:
in the embodiment of the application, input screening conditions are received; screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order; and integrating the target order set by adopting a method of grouping and gathering, ordering order information and accumulating nearby variables to obtain an order number set of the duplicate orders, wherein logistics companies, commodity code sets and commodity quantity sets of the duplicate orders are the same. According to the embodiment of the application, the Reunion order number set with the same commodity quantity set of the logistics company can be quickly obtained through the methods of grouping and summarizing, ordering information and accumulating the near-neighbor variables, so that the Reunion order number set with the same commodity quantity set of the logistics company and the commodity code set can be quickly integrated under the scene of multiple varieties and multiple orders.
Drawings
Fig. 1 is a schematic diagram of an embodiment of an order information processing method in an embodiment of the present application;
fig. 2 is a schematic diagram of another embodiment of an order information processing method in the embodiment of the present application;
fig. 3 is a schematic diagram of an embodiment of an order information processing system in the embodiment of the present application.
Detailed Description
The embodiment of the invention provides an order information processing method and system, which are used for quickly screening a reynolds order number set with the same logistics company, a commodity code set and a commodity quantity set from a target order set so as to realize quick integration of the same order in a scene of multiple varieties and multiple orders.
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
For convenience of understanding, the order information processing method in the present application is described below, and referring to fig. 1, an embodiment of the order information processing method in the present application includes:
101. receiving input screening conditions;
in the present application, to realize fast integration of an order, order information needs to be obtained first, a large amount of order information is stored in a database in the present application in advance, and in order to obtain target order information, a target order needs to be screened from the database according to screening conditions, so that the present application needs to receive the screening conditions first and execute step 102 according to the screening conditions.
It should be noted that, in the present application, the input of the filtering condition may be the input of the filtering condition through a receiving interface of the order processing system, such as a receiving interface of a web page version order processing system, or a receiving interface in APP, and is not limited herein.
102. Screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
and when the order processing system receives the screening condition, screening the target order set in the database according to the screening condition to obtain the target order set.
Specifically, the screening condition may be date information, such as order information during the period from 7/month 1/2019 to 8/month 1/2019, or logistics company information, such as order information for screening cis-rich logistics and roundabout logistics, or commodity information, such as order information for screening commodity codes of commodity 1 and commodity 2, and the content of the screening condition is not particularly limited.
It should be noted that, in order to realize rapid integration of order information, each order in the present application at least includes key information such as an order number, a logistics company, a commodity code, and a quantity of a commodity, and in addition, may also include other information such as a commodity name and a commodity description, and is not limited herein.
103. And integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same.
And after a target order set is obtained, integrating the target order set by adopting a method of grouping summary, order information sequencing and near variable accumulation to obtain an order number set of the Leisha order, wherein logistics companies, commodity code sets and commodity quantity sets of the Leisha order are the same.
It is easy to understand that in the embodiment of the present application, grouping and summarizing are performed to summarize order information that is the same for some classification entries in a data list according to the classification entries; ordering information, namely performing corresponding ascending or descending order arrangement on the order information appointed in the data list according to appointed entry information; and accumulating the adjacent variables, namely accumulating certain adjacent order information in the data list according to a certain classification item under the condition that the specified classification items are the same.
Specifically, the process of how to integrate the target order set by adopting the methods of grouping and summarizing, ordering the order information and accumulating the near-neighbor variables to obtain the order number set of the duplicate order is described in detail in the following embodiments, and is not described herein again.
In the embodiment of the application, input screening conditions are received; screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order; and integrating the target order set by adopting a method of grouping and gathering, ordering order information and accumulating nearby variables to obtain an order number set of the duplicate orders, wherein logistics companies, commodity code sets and commodity quantity sets of the duplicate orders are the same. According to the embodiment of the application, the Reunion order number set with the same commodity quantity set of the logistics company can be quickly obtained through the methods of grouping and summarizing, ordering information and accumulating the near-neighbor variables, so that the Reunion order number set with the same commodity quantity set of the logistics company and the commodity code set can be quickly integrated under the scene of multiple varieties and multiple orders.
For step 103 in embodiment 1, the embodiment of fig. 2 is described in detail, please refer to fig. 2, and fig. 2 is a detailed step of the embodiment of fig. 1:
201. combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
for convenience of description, the embodiment of fig. 2 is described in detail below in conjunction with table 1, assuming that the target order set is shown in table 1.
TABLE 1
Figure BDA0002211775370000061
Figure BDA0002211775370000071
After the target order set shown in table 1 is obtained, the orders with the same order number, logistics company and commodity code in the target order set are merged and summarized to eliminate the duplicate orders with the same order number, logistics company and commodity code in the target order combination.
Specifically, in table 1, the order number is 4, the logistics company is roundabout, 2 orders with the product code of product 1 exist, the order number is 5, the logistics company is cis-rich, and 2 orders with the product code of product 2 exist, and they need to be merged and summarized respectively to obtain the order information in table 2.
TABLE 2
Figure BDA0002211775370000072
Figure BDA0002211775370000081
202. Expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
in order to facilitate the collection and processing of the information of the duplicate orders in the later period, each order in table 2 is expanded into entry information of a commodity code set and a commodity quantity set, specifically referring to table 3.
TABLE 3
Order number Commodity Co Ltd Goods code Number of goods Commodity code set Number of commodities collection
1 1 Shunfeng Commodity 1 1
2 2 Shunfeng Commodity 1 1
3 3 Shun Feng (Chinese character of 'shun Feng') Commodity 2 2
4 3 Shunfeng Commodity 1 1
5 4 Round tube Commodity 1 2
6 5 Shunfeng Commodity 1 1
7 5 Shunfeng Commodity 2 2
8 6 Round tube Commodity 1 2
9 7 Shunfeng Commodity 1 1
203. Sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information;
in order to facilitate the later summary of the duplicate order information, after table 3 is obtained, the orders with the same order number as the logistics company in table 3 are sorted in an ascending order or a descending order of the first letter of the commodity code, and first integrated order information is generated, as shown in table 4.
Specifically, the order number in table 3 is 3, the logistics company is shunfeng, the product codes are 2 orders of the product 1 and the product 2, wherein the product codes are ordered from top to bottom as the product 2 and the product 1, that is, the ordering is performed in an ascending order of the first letter of the product code, the order number in table 3 is 5, the logistics company is shunfeng, and the product codes are 2 orders of the product 1 and the product 2, wherein the product codes are ordered from top to bottom as the product 1 and the product 2, that is, the ordering is performed in a descending order of the first letter of the product code, and for unification, all orders with the same order number and the same logistics company are ordered in a descending order of the first letter of the product code to generate first integrated order information, which is specifically shown in table 4.
TABLE 4
Order number Commodity Co Ltd Commodity code Number of goods Commodity code set Number of commodities collection
1 1 Shunfeng Commodity 1 1
2 2 Shun Feng (Chinese character of 'shun Feng') Commodity 1 1
3 3 Shunfeng Commodity 1 1
4 3 Shunfeng Commodity 2 2
5 4 Round tube Commodity 1 2
6 5 Shun Feng (Chinese character of 'shun Feng') Commodity 1 1
7 5 Shunfeng Commodity 2 2
8 6 Round tube Commodity 1 2
9 7 Shun Feng (Chinese character of 'shun Feng') Commodity 1 1
204. Respectively performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information;
in order to facilitate statistics of the lei order number, after the order information in table 4 is obtained, entry-and-record merging is performed on orders with the same order number and the same logistics company and orders with different order numbers according to the commodity codes and the quantity of commodities to obtain data corresponding to a commodity code set and a commodity quantity set, and second integrated order information is generated, as shown in table 5.
TABLE 5
Figure BDA0002211775370000091
Figure BDA0002211775370000101
205. Screening out order information subjected to over-registration merging from orders with the same order numbers and the logistics companies in the second integrated order information;
in step 204, after the order with the same order number as the logistics company is subjected to the over-record combination, the order information subjected to the over-record combination is screened from table 5, specifically as shown in table 6, that is, the order information subjected to the over-record combination is screened from 2 orders with an order number of 3, a logistics company of shun feng, and product codes of 1 and 2, that is, the order information of the 4 th row is screened from the 3 rd row and the 4 th row in table 5, and similarly, the order information of the 7 th row is screened from the order information of the 6 th row and the 7 th row.
TABLE 6
Order number Commodity Co Ltd Commodity code Number of commodities Commodity code set Number of commodities collection
1 1 Shunfeng Commodity 1 1 Commodity 1 1
2 2 Shunfeng Commodity 1 1 Commodity 1 1
3 3 Shunfeng Commodity 2 2 Products 1 and 2 1,2
4 4 Round tube Commodity 1 2 Commodity 1 2
5 5 Shunfeng Commodity 2 2 Products 1 and 2 1,2
6 6 Round tube Commodity 1 2 Commodity 1 2
7 7 Shunfeng Commodity 1 1 Commodity 1 1
206. And grouping and sequencing the orders with different order numbers and the same orders subjected to the recording and merging execution according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
In order to further count the order numbers in the same order information, the order information in table 6, that is, the orders with different order numbers, and the orders with the order numbers after the over-record combination and the orders with the same logistics company may be grouped and sorted according to the same logistics company, the same product code set, and the same product quantity set, so as to generate third integrated order information, as shown in table 7.
Specifically, the orders in table 6 with the same logistics company, the same commodity code set, and the same commodity quantity set are divided into the same group, and the orders in different groups are sorted in ascending order or descending order according to the first letter of the field name of the logistics company, the commodity code set, and the commodity quantity set (from left to right), so as to generate the third integrated order information.
TABLE 7
Order number Logistics company Commodity code Number of commodities Commodity code set Number of commodities collection
1 1 Shunfeng Commodity 1 1 Commodity 1 1
2 2 Shunfeng Commodity 1 1 Commodity 1 1
7 7 Shunfeng Commodity 1 1 Commodity 1 1
3 3 Shunfeng Commodity 2 2 Products 1 and 2 1,2
5 5 Shunfeng Commodity 2 2 Products 1 and 2 1,2
4 4 Round tube Commodity 1 2 Commodity 1 2
6 6 Round tube Commodity 1 2 Commodity 1 2
207. And sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
After the third integrated order information in table 7 is obtained, sequentially traversing all the orders in the third integrated order information, and counting the number of identical orders and the order number sets of the logistics company, the product code set and the product number set by using a near-neighbor variable accumulation method, specifically, if the logistics company, the product code set and the product number set of the order No. 1,2 and 7 in table 7 are all the same, the logistics company, the product code set and the product number set of the order No. 3 and 5 are all the same, and the logistics company, the product code set and the product number set of the order No. 4 and 6 are all the same, sequentially performing statistics according to the near-neighbor variable accumulation method, so as to obtain the order information in table 8.
TABLE 8
Order number Commodity Co Ltd Commodity code set Number of commodities collection Number of orders Order number set
1 1 Shunfeng Commodity 1 1 1 1
2 2 Shunfeng Commodity 1 1 2 1,2
7 7 Shunfeng Commodity 1 1 3 1,2,7
3 3 Shunfeng Products 1 and 2 1,2 1 3
5 5 Shunfeng Products 1 and 2 1,2 2 3,5
4 4 Round tube Commodity 1 2 1 4
6 6 Round tube Commodity 1 2 2 4,6
For convenience of viewing, the order information with the same logistics company and the same commodity code set but the largest order quantity and order number set can be respectively screened from table 8 to obtain the identical order number sets with the same logistics company, the same commodity code set and the same commodity quantity set, and the screened order information is arranged in an ascending order or a descending order according to the size of the order quantity, specifically referring to table 9, where table 9 is the order information arranged in a descending order according to the size of the order quantity.
TABLE 9
Commodity Co Ltd Commodity code set Number of commodities collection Number of orders Order number set
1 Shun Feng (Chinese character of 'shun Feng') Commodity 1 1 3 1,2,7
2 Shunfeng Products 1 and 2 1,2 2 3,5
3 Round tube Commodity 1 2 2 4,6
It should be noted that, in the process of performing duplicate order statistics in the present application, through statistics of 2 information in the commodity code set and the commodity quantity set, it is very easy to obtain duplicate orders with the same commodity code set and the same commodity quantity set in a scene of multiple varieties (i.e. more commodity code sets) and multiple orders (more order number sets), according to the method of the present application, so as to facilitate later processing of orders, such as order placing and order picking.
In the embodiment of the application, the processes of grouping and summarizing, order information sequencing and near-neighbor variable accumulation methods are adopted for the target order set, and the implementability of the embodiment of the application is improved.
With reference to fig. 3, the order information processing method in the embodiment of the present application is described above, and the following description describes an order information processing system in the application, where an embodiment of the order information processing system in the embodiment of the present application includes:
a receiving unit 301, configured to receive an input screening condition;
a screening unit 302, configured to screen out a target order set according to the screening condition, where the target order set at least includes an order number, a logistics company, a product code, and product quantity information of each order;
and an integrating unit 303, configured to integrate the target order set by using a method of grouping and summarizing, ordering information, and accumulating nearby variables to obtain an order number set of the duplicate order, where a logistics company, a commodity code set, and a commodity quantity set of the duplicate order are the same.
The integration unit 303 is specifically configured to:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
expanding the item information of the commodity code set and the commodity quantity set of each combined and aggregated order;
and sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information.
The integration unit 303 is specifically configured to:
and performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information.
The integration unit 303 is specifically configured to:
in the second integrated order information, screening out order information subjected to over-recording and merging from the orders with the same order numbers and the same logistics companies;
and grouping and sequencing the orders with different order numbers and the same orders subjected to the over-registration and combination according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
The integration unit 303 is specifically configured to:
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
It should be noted that the functions of the units in the embodiment of the present application are similar to those described in the embodiment of fig. 1 to fig. 2, and are not described again here.
In the embodiment of the present application, the receiving unit 301 receives an input screening condition; according to the screening conditions, a target order set is screened out through a screening unit 302, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order; the target order set is integrated by an integration unit 303 through a method of grouping and summarizing, ordering information and accumulating nearby variables, so that an order number set of the Leido order is obtained, and logistics companies, commodity code sets and commodity quantity sets of the Leido order are the same. According to the embodiment of the application, the Reunion order number set with the same commodity quantity set of the logistics company can be quickly obtained through the methods of grouping and summarizing, ordering information and accumulating the near-neighbor variables, so that the Reunion order number set with the same commodity quantity set of the logistics company and the commodity code set can be quickly integrated under the scene of multiple varieties and multiple orders.
The order information processing system in the embodiment of the present invention is described above from the perspective of the modular functional entity, and the computer apparatus in the embodiment of the present invention is described below from the perspective of hardware processing:
the computer device is used for realizing the functions of an order information processing system, and one embodiment of the computer device in the embodiment of the invention comprises the following steps:
a processor and a memory;
the memory is used for storing the computer program, and the processor is used for realizing the following steps when executing the computer program stored in the memory:
receiving input screening conditions;
screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
and integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same.
In some embodiments of the present invention, the processor is specifically configured to implement the following steps:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
and sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information.
In some embodiments of the present invention, the processor may be further configured to:
and performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information.
In some embodiments of the present invention, the processor may be further configured to implement the following steps:
in the second integrated order information, screening out order information subjected to over-recording and merging from the orders with the same order numbers and the same logistics companies;
and grouping and sequencing the orders with different order numbers and the same orders subjected to the recording and merging execution according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
In some embodiments of the present invention, the processor may be further configured to implement the following steps:
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
It can be understood that, when the processor in the computer device described above executes the computer program, the functions of the units in the corresponding device embodiments may also be implemented, and are not described herein again. Illustratively, the computer program may be partitioned into one or more modules/units that are stored in the memory and executed by the processor to implement the invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution of the computer program in the order information processing system. For example, the computer program may be divided into units in the above-described order information processing system, and each unit may realize specific functions as described in the above-described corresponding order information processing system.
The computer device can be a desktop computer, a notebook, a palm computer, a cloud server and other computing devices. The computer device may include, but is not limited to, a processor, a memory. It will be appreciated by those skilled in the art that the processor, memory are merely examples of a computer apparatus and do not constitute a limitation of the computer apparatus, and may include more or fewer components, or combine certain components, or different components, for example, the computer apparatus may also include input output devices, network access devices, buses, and the like.
The Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable gate array (FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware component, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like which is the control center for the computer device and which connects the various parts of the overall computer device using various interfaces and lines.
The memory may be used to store the computer programs and/or modules, and the processor may implement various functions of the computer apparatus by executing or executing the computer programs and/or modules stored in the memory and calling data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the terminal, and the like. In addition, the memory may include high-speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
The present invention also provides a computer-readable storage medium for implementing the functions of an order information processing system, having a computer program stored thereon, which, when executed by a processor, the processor is operable to perform the steps of:
receiving input screening conditions;
screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
and integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same.
In some embodiments of the invention, the computer program stored on the computer-readable storage medium, when executed by the processor, may be specifically configured to perform the steps of:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the duplicate orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
and sequencing the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information.
In some embodiments of the invention, the computer program stored on the computer-readable storage medium, when executed by the processor, may be specifically configured to perform the steps of:
and performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets, and generating second integrated order information.
In some embodiments of the invention, the computer program stored on the computer-readable storage medium, when executed by the processor, may be specifically configured to perform the steps of:
in the second integrated order information, screening out order information subjected to over-recording and merging from the orders with the same order numbers and the same logistics companies;
and grouping and sequencing the orders with different order numbers and the same orders subjected to the over-registration and combination according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information.
In some embodiments of the invention, the computer program stored on the computer-readable storage medium, when executed by the processor, may be specifically configured to perform the steps of:
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
It will be appreciated that the integrated units, if implemented as software functional units and sold or used as a stand-alone product, may be stored in a corresponding one of the computer readable storage media. Based on such understanding, all or part of the flow of the method according to the above embodiments may be realized by a computer program, which may be stored in a computer readable storage medium and used by a processor to realize the steps of the above embodiments. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (4)

1. An order information processing method is characterized by comprising the following steps:
receiving input screening conditions;
screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
integrating the target order set by adopting a method of grouping and summarizing, ordering information and accumulating nearby variables to obtain an order number set of the Leido orders, wherein logistics companies, commodity code sets and commodity quantity sets of the Leido orders are the same;
the target order set is integrated by adopting a method of grouping and summarizing, order information sequencing and near-term variable accumulation, and the method comprises the following steps:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information;
respectively performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets and generate second integrated order information;
screening out order information subjected to over-registration merging from orders with the same order numbers and the logistics companies in the second integrated order information;
the orders with different order numbers and the same orders subjected to the recording and merging are grouped and sequenced according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information;
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the duplicate orders and the order number set which are the same as the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative method.
2. An order information processing system, comprising:
the receiving unit is used for receiving input screening conditions;
the screening unit is used for screening a target order set according to the screening conditions, wherein the target order set at least comprises an order number, a logistics company, a commodity code and commodity quantity information of each order;
the integration unit is used for integrating the target order set by adopting a method of grouping summary, order information sequencing and near variable accumulation to obtain an order number set of the Leido order, and the logistics company, the commodity code set and the commodity quantity set of the Leido order are the same;
the integration unit is specifically configured to:
combining and summarizing orders with the same order number, logistics company and commodity code in the target order set so as to eliminate the identical orders with the same order number, logistics company and commodity code in the target order set;
expanding each merged and aggregated order into item information of a commodity code set and a commodity quantity set;
sorting the orders with the same order number as the logistics company in the merged and aggregated orders according to the ascending order or the descending order of the first letter of the commodity code to generate first integrated order information;
respectively performing entry and combination on orders with the same order number as the logistics company and orders with different order numbers in the first integrated order information according to the commodity codes and the commodity quantity to obtain data of corresponding commodity code sets and commodity quantity sets and generate second integrated order information;
screening out order information subjected to over-registration merging from orders with the same order numbers and the logistics companies in the second integrated order information;
the orders with different order numbers and the same orders subjected to the recording and merging are grouped and sequenced according to the same logistics company, the same commodity code set and the same commodity quantity set to generate third integrated order information;
and sequentially traversing all orders in the third integrated order information, and counting the quantity of the identical orders and the order number set which are the same with the logistics company, the commodity code set and the commodity quantity set by adopting a near variable cumulative addition method.
3. A computer system comprising a processor, characterized in that the processor, when executing a computer program stored on a memory, is adapted to carry out the order information processing method according to claim 1.
4. A computer-readable storage medium, on which a computer program is stored, for implementing the order information processing method according to claim 1 when the computer program is executed by a processor.
CN201910900878.3A 2019-09-23 2019-09-23 Order information processing method, system and readable storage medium Active CN110619499B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910900878.3A CN110619499B (en) 2019-09-23 2019-09-23 Order information processing method, system and readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910900878.3A CN110619499B (en) 2019-09-23 2019-09-23 Order information processing method, system and readable storage medium

Publications (2)

Publication Number Publication Date
CN110619499A CN110619499A (en) 2019-12-27
CN110619499B true CN110619499B (en) 2022-08-23

Family

ID=68923964

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910900878.3A Active CN110619499B (en) 2019-09-23 2019-09-23 Order information processing method, system and readable storage medium

Country Status (1)

Country Link
CN (1) CN110619499B (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113298282B (en) * 2020-09-30 2024-11-05 阿里巴巴新加坡控股有限公司 Commodity object processing method, device and electronic equipment
CN112668959A (en) * 2020-12-16 2021-04-16 中冶建筑研究总院有限公司 Purchase information processing method and device, electronic equipment and readable storage medium
CN113538107A (en) * 2021-07-27 2021-10-22 畅销家(深圳)科技有限公司 Order information synchronization method and related equipment
CN113723893B (en) * 2021-09-15 2025-05-23 北京沃东天骏信息技术有限公司 Method and apparatus for processing orders
CN115271563A (en) * 2022-09-29 2022-11-01 合肥新晶集成电路有限公司 Management method of substitute product, target client and processor
CN115713430A (en) * 2022-11-30 2023-02-24 广州品唯软件有限公司 Method, system and related equipment for summarizing accounting entry data

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102158229A (en) * 2011-03-30 2011-08-17 上海北京大学微电子研究院 Offset voltage and charge injection elimination technology for ADC (analog-to-digital converter)
CN103632250A (en) * 2013-12-06 2014-03-12 湖南御家汇化妆品有限公司 Quick sales order sorting, grouping and screening method
CN109726965A (en) * 2019-01-04 2019-05-07 杭州卓凯科技有限公司 Net about goods vehicle service request queue is lined up processing method
CN109949141A (en) * 2017-12-20 2019-06-28 北京京东尚科信息技术有限公司 Financial settlement method, apparatus and system

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7058596B1 (en) * 1993-08-24 2006-06-06 Lykes Bros., Inc. System for managing customer orders and methods of implementation
US20080222098A1 (en) * 2007-03-06 2008-09-11 Bellsouth Intellectual Property Corporation Methods, systems, and computer program products for providing consolidated order information
CN107545381B (en) * 2016-06-24 2021-02-26 北京京东振世信息技术有限公司 Method for managing warehouse inventory and warehouse management system
CN106651257A (en) * 2016-12-14 2017-05-10 深圳市大东车慧科技股份有限公司 Logistics company transportation cost management system and usage method thereof
CN107169713A (en) * 2017-06-08 2017-09-15 北京惠赢天下网络技术有限公司 Efficient kinds of goods allocator, system and order management server based on standard container
CN110223011A (en) * 2019-05-22 2019-09-10 杭州海仓科技有限公司 Intelligent storage equipment scheduling method, system, storage medium and electronic equipment

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102158229A (en) * 2011-03-30 2011-08-17 上海北京大学微电子研究院 Offset voltage and charge injection elimination technology for ADC (analog-to-digital converter)
CN103632250A (en) * 2013-12-06 2014-03-12 湖南御家汇化妆品有限公司 Quick sales order sorting, grouping and screening method
CN109949141A (en) * 2017-12-20 2019-06-28 北京京东尚科信息技术有限公司 Financial settlement method, apparatus and system
CN109726965A (en) * 2019-01-04 2019-05-07 杭州卓凯科技有限公司 Net about goods vehicle service request queue is lined up processing method

Also Published As

Publication number Publication date
CN110619499A (en) 2019-12-27

Similar Documents

Publication Publication Date Title
CN110619499B (en) Order information processing method, system and readable storage medium
CN107545381B (en) Method for managing warehouse inventory and warehouse management system
CN106156791B (en) Business data classification method and device
CN104424339B (en) The method, apparatus and system of data analysis
CN107784070B (en) Method, device and equipment for improving data cleaning efficiency
CN103632250A (en) Quick sales order sorting, grouping and screening method
CN107203866B (en) Order processing method and device
CN112434089A (en) Frequent item mining method and device, server and readable storage medium
CN111667225A (en) Financial data processing method and device and computer system
CN106874503B (en) Method and device for acquiring recommended data
CN107808306A (en) Cutting method, electronic installation and the storage medium of business object based on tag library
CN110633331A (en) Method, system and related equipment for extracting data in relational database
CN109800340A (en) Trade mark registration recommended method and system
CN108038217B (en) Information recommendation method and device
CN113360839A (en) Commodity distribution method, commodity distribution device, electronic equipment and computer storage medium
US10762066B2 (en) Data processing system having an integration layer, aggregation layer, and analysis layer, data processing method for the same, program for the same, and computer storage medium for the same
CN114780606B (en) Big data mining method and system
CN113705625A (en) Method and device for identifying abnormal life guarantee application families and electronic equipment
CN108459891A (en) Achievement data screenshotss method, apparatus, equipment and the storage medium of financial APP
CN111833110A (en) Customer life cycle positioning method and device, electronic equipment and storage medium
CN117057760A (en) Enterprise catering management method and system based on small program
CN113886585A (en) Item recommendation method, computer device and computer-readable storage medium
CN113392105A (en) Service data processing method and terminal equipment
CN114723516A (en) User similarity calculation method and system based on form data
CN112070469A (en) Service handling duration optimization method, system, terminal device and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant