CN111242751B - Express order updating method, device, equipment and storage medium - Google Patents
Express order updating method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111242751B CN111242751B CN202010164818.2A CN202010164818A CN111242751B CN 111242751 B CN111242751 B CN 111242751B CN 202010164818 A CN202010164818 A CN 202010164818A CN 111242751 B CN111242751 B CN 111242751B
- Authority
- CN
- China
- Prior art keywords
- order
- file
- express
- updating
- attribute value
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention relates to the field of logistics management and discloses a method, a device, equipment and a storage medium for updating a express order. The express order updating method comprises the following steps: acquiring order data of each express order generated by the front end every preset order updating time length; generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk; reading the order data in the CSV file from the network attached storage disk; and updating the read order data into an order source file in a back-end database. According to the invention, the CSV file for transfer backup is generated, so that the frequency of directly inserting the source file is reduced, and the accuracy of updating the express order is improved.
Description
Technical Field
The present invention relates to the field of logistics management, and in particular, to a method, an apparatus, a device, and a storage medium for updating a express mail order.
Background
With the development of the internet, electronic commerce increasingly shows great development potential and is widely applied to various industries. The method improves the ways of economic behaviors such as shopping and consumption of people in the morning, and simultaneously combines the rapid development of logistics, so that the speed and the richness of obtaining services and products by people are increased. At the same time, the increase in users in turn increases the service scope of electronic commerce. Therefore, more and more types of products are stepping into the field of electronic commerce.
When a platform of a company reaches a certain scale, more and more data are related to an order, whether the order is shipped, logistics information corresponding to the order, and the like, and the company needs to count and update the information in time. However, directly inputting a large amount of data into the system at one time may cause delays to the system and there is some duplication of orders. So that the subsequent fee is settled, and the subsequent fee is in error with other platforms for docking and the like.
Disclosure of Invention
The invention mainly aims to solve the technical problem of poor updating accuracy in the updating process of the express order.
The first aspect of the present invention provides a method for updating a express order, where the method for updating the express order includes:
acquiring order data of each express order generated by the front end every preset order updating time length;
generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk;
reading the order data in the CSV file from the network attached storage disk;
and updating the read order data into an order source file in a back-end database.
Optionally, in a first implementation manner of the first aspect of the present invention, the order data includes: order status, unique key attribute value, and order attribute value, different express orders being distinguished by the unique key attribute value of the order, the order update comprising: order status update and order attribute value update, the order source file comprising: order status source files and order attribute value source files.
Optionally, in a second implementation manner of the first aspect of the present invention, generating a blank CSV file corresponding to the update of the present order, and writing the order data into the CSV file according to the order of generating each express order, and storing the order data into a network-attached storage disk includes:
generating a blank CSV file corresponding to the update of the current order, and writing the order data into the CSV file according to the generation sequence of each express order;
when the CSV file writing operation is finished, generating an identification file corresponding to the CSV file;
and associating the CSV file with the identification file and storing the CSV file and the identification file in a network attached storage disk, wherein the order state and the order attribute value are respectively stored in different CSV files.
Optionally, in a third implementation manner of the first aspect of the present invention, the reading the order data in the CSV file from the network attached storage disk includes:
judging whether the identification file exists in the network additional storage disk or not;
if yes, reading an order state or an order attribute value in the CSV file corresponding to the identification file.
Optionally, in a fourth implementation manner of the first aspect of the present invention, the updating the read order data to an order source file in a back-end database includes:
traversing the order attribute value source file by taking the unique key attribute value in the read order attribute value as a keyword, and outputting a traversing result corresponding to each express order;
if the traversing result is null, writing the read order attribute value into the order attribute value source file;
if the traversing result is non-empty, updating the read order attribute value into the order attribute value source file to replace the historical order attribute value in the order attribute value source file.
Optionally, in a fifth implementation manner of the first aspect of the present invention, the updating the read order data to an order source file in a back-end database includes:
traversing the order state source file by taking the read order state as a keyword, and outputting traversing results corresponding to all express orders;
and if the traversing result is null, writing the read order state into the order state source file.
Optionally, in a sixth implementation manner of the first aspect of the present invention, after the updating the read order data into an order source file in a back-end database, the method further includes:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
generating a corresponding blank order report according to the report configuration information;
and reading corresponding order data from the order source file according to the report field of the order report and the statistical rule, and writing the corresponding order data into the order report.
A second aspect of the present invention provides a express order update apparatus, including:
the acquisition module is used for acquiring order data of each express order generated by the front end every preset order updating time;
the generating module is used for generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generating sequence of each express order, and storing the order data into a network additional storage disk;
the reading module is used for reading the order data in the CSV file from the network additional storage disk;
and the updating module is used for updating the read order data into an order source file in the back-end database.
Optionally, in a first implementation manner of the second aspect of the present invention, the generating module is specifically configured to:
generating a blank CSV file corresponding to the update of the current order, and writing the order data into the CSV file according to the generation sequence of each express order;
when the CSV file writing operation is finished, generating an identification file corresponding to the CSV file;
and associating the CSV file with the identification file and storing the CSV file and the identification file in a network attached storage disk, wherein the order state and the order attribute value are respectively stored in different CSV files.
Optionally, in a second implementation manner of the second aspect of the present invention, the reading module is specifically configured to:
judging whether the identification file exists in the network additional storage disk or not;
if yes, reading an order state or an order attribute value in the CSV file corresponding to the identification file.
Optionally, in a third implementation manner of the second aspect of the present invention, the update module is specifically configured to:
traversing the order attribute value source file by taking the unique key attribute value in the read order attribute value as a keyword, and outputting a traversing result corresponding to each express order;
if the traversing result is null, writing the read order attribute value into the order attribute value source file;
if the traversing result is non-empty, updating the read order attribute value into the order attribute value source file to replace the historical order attribute value in the order attribute value source file.
Optionally, in a fourth implementation manner of the second aspect of the present invention, the replacing unit is specifically configured to:
traversing the order state source file by taking the read order state as a keyword, and outputting traversing results corresponding to all express orders;
and if the traversing result is null, writing the read order state into the order state source file.
Optionally, in a fifth implementation manner of the second aspect of the present invention, the express order update device further includes a report module, where the report module is specifically configured to:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
generating a corresponding blank order report according to the report configuration information;
and reading corresponding order data from the order source file according to the report field of the order report and the statistical rule, and writing the corresponding order data into the order report.
A third aspect of the present invention provides a express order update apparatus, comprising: a memory and at least one processor, the memory having instructions stored therein, the memory and the at least one processor being interconnected by a line; the at least one processor invokes the instructions in the memory to cause the express order update apparatus to perform the express order update method described above.
A fourth aspect of the present invention provides a computer readable storage medium having instructions stored therein which, when run on a computer, cause the computer to perform the above-described method of updating a express order.
The traditional order updating is based on directly inserting order data in a front-end database into order source files in a back-end database, and the invention adds CSV files for transfer on a network additional storage disk on the original basis so as to reduce the probability of errors caused by directly inserting the order source files into the final storage. Network attached storage disk is connected to network, centralized network file access mechanism and sharing can be used to cope with the unfeasible system limitation. After the CSV file is generated, an identification file for identification is also generated, and order data in the CSV file is read only after the identification file is generated, so that the CSV file is prevented from being read without being generated, and the occurrence of data loss is reduced. When updating the source file containing the order state and the order attribute value, whether the order data is the latest order data is also judged according to the acquisition event of the order data, so that the occurrence of the situation that errors are covered by old data is reduced. The invention can be flexibly configured, and dynamically generates the report for subsequent analysis of order data, so as to improve the report generation and analysis efficiency.
Drawings
FIG. 1 is a diagram of a first embodiment of a method for updating a express order according to an embodiment of the present invention;
FIG. 2 is a diagram of a second embodiment of a method for updating a express order in an embodiment of the present invention;
FIG. 3 is a diagram of a third embodiment of a method for updating a express order in an embodiment of the present invention;
FIG. 4 is a diagram of a fourth embodiment of a method for updating a express order in an embodiment of the present invention;
FIG. 5 is a diagram of a fifth embodiment of a method for updating a express order in an embodiment of the present invention;
FIG. 6 is a diagram of an embodiment of a device for updating a express order in accordance with an embodiment of the present invention;
FIG. 7 is a diagram of a device for updating a express order according to another embodiment of the present invention;
FIG. 8 is a diagram of an embodiment of a device for updating a express order in an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a method, a device, equipment and a storage medium for updating a express order. The invention adds CSV file on network additional storage disk to reduce error probability caused by directly inserting final stored order source file. Network attached storage disk is connected to network, centralized network file access mechanism and sharing can be used to cope with the unfeasible system limitation. After the CSV file is generated, an identification file for identification is also generated, and order data in the CSV file is read only after the identification file is generated, so that the CSV file is prevented from being read without being generated, and the occurrence of data loss is reduced. When updating the source file containing the order state and the order attribute value, whether the order data is the latest order data is also judged according to the acquisition event of the order data, so that the occurrence of the situation that errors are covered by old data is reduced. The invention can be flexibly configured, and dynamically generates the report for subsequent analysis of order data, so as to improve the report generation and analysis efficiency.
The terms "first," "second," "third," "fourth" and the like in the description and in the claims and in the above drawings, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," or any other variation 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 or inherent to such process, method, article, or apparatus.
For ease of understanding, a specific flow of an embodiment of the present invention is described below with reference to fig. 1, where an embodiment of a method for updating a express order in an embodiment of the present invention includes:
101. acquiring order data of each express order generated by the front end every preset order updating time length;
in this embodiment, the front end is a storage folder, a network disk, a database, etc. containing order data. Two different databases are illustrated.
The first is an order system, after a user makes an order, the user is checked first to determine the identity of the user, and the user is company A. Then a specific order number is generated for the order, and the order number rule is various, wherein the naming rule is year, month and day (8 bits) +order number with self-increasing number (5 bits), and the generated order number is 2010012012345. Meanwhile, according to the information filled by the user, determining that the payment mode is 'moon knot'. Finally, the order state corresponding to the order is generated as the order just generated, and the order is 'to be sent'.
And the second is the greenplus database. The architecture of greenplus employs MPP (massively parallel processing). In an MPP system, each SMP node may also run its own operating system, database, etc. Therefore, greemplum has greater advantages in the aspect of processing mass databases, and can rapidly complete the processing such as the retrieval of the databases. After the goods B corresponding to the order number '2010012012345' is sent out from the warehouse and reaches the transfer point C, the order information can be input into the Greemplum database in a code scanning or manual input mode, and the order state in the order information is changed into 'in-transit'.
The updating time length for acquiring the two initial databases is preset. Because the order information data of the transfer point may have a specific time to be recorded, for example, when 100 pieces are accumulated, the time for acquiring the greenplus database can be longer than that of the order system. In addition, since the goods may enter the shipping stage soon after the order is created, the order information acquisition time interval of the order system is very short, otherwise, the order data of the Greemplum database is covered by the information of the subsequent order system, and the update error condition occurs, so the former is set to acquire once in two hours and the latter is set to acquire once in 5 minutes.
102. Generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk;
in this embodiment, the configuration information of the order table of the CSV file to be generated is preconfigured.
The order table configuration information may be stored in the form of a configuration file, such as a css file. The order table configuration information may also include field tags and extraction formulas corresponding to the field tags. The previous order information is "A company-2010012012345-in-transit-month knot", a blank csv file is created through import, and then field tags and corresponding extraction formulas in the order table configuration information are imported.
An order data is described as "A company-2010012012345-in-transit-month" for example. In the front end, the order information is { "2010012012345", "company a", "month knot", "in-transit" }. The current field label is "order number", so the extraction formula is ≡2 \d {12}, the character string of the current order information is traversed, the character string '2010012012345' is obtained to conform to the extraction formula, and the character string is extracted. After extraction, the character string is written into the position corresponding to the field label. In this way, the CSV file with the order data written is finally obtained.
The above is just one preferred way of embodiment, and the order data may also be written directly or otherwise into the CSV file when no configuration information is present.
103. Reading the order data in the CSV file from the network attached storage disk;
and scanning the network attached storage disk, searching and judging whether the CSV file to be read exists. If yes, order data in the CSV file is read.
104. And updating the read order data into an order source file in a back-end database.
And updating the read order data to an order source file stored in a back-end database. The first generated CSV file can be directly written into a back-end database as an order source file.
There are two ways of updating, one is direct writing, and the other is to replace the order attribute value in the source file with the order data. Traversing the source file, and judging whether the unique attribute value of the order attribute value is consistent with the unique attribute value of the order attribute value in the source file according to the unique attribute value in the order data. If the order attribute values are consistent, the order attribute values in the source file are replaced by the order data.
The invention adds CSV files for transfer on the network additional storage disk based on the traditional order update to reduce the probability of errors caused by directly inserting the finally stored order source file. In addition, the network-attached storage disk is connected to the network, and a centralized network file access mechanism and sharing can be adopted to cope with the unfulfilled system limitation.
Referring to fig. 2, another embodiment of a method for updating a express order according to an embodiment of the present invention includes:
201. acquiring order data of each express item order generated by a front end every preset order updating time length, wherein the order data comprises an order state, an order unique key attribute value and an order attribute value, and different express item orders are distinguished through the unique key attribute values of the orders;
order data is divided into two types, one is order status and one is order attribute value, each express order has a specific unique key attribute value, so that different express orders are distinguished by unique key attribute values in the order file.
The order status is mainly the current shipping status of the express order, such as "pick up," "ship, reach xxx location," signed up.
The order attribute value is the basic attribute of the express order, such as sender, recipient, address.
202. Generating blank CSV files corresponding to the current order update, and writing the order data into the CSV files according to the generation sequence of each express order, wherein the order update comprises order state update and order attribute value update, and the order state and the order attribute value are respectively stored into different CSV files;
in this embodiment, the configuration information of the order table of the CSV file to be generated is preconfigured.
A blank csv file is created through import, and then field tags and corresponding extraction formulas in the order table configuration information are imported.
An order data is described as "A company-2010012012345-in-transit-month" for example. The order data in the front end is traversed in accordance with the order of generation. The current read order information is { "2010012012345," "company A," "moon," "in-transit" }, the field label is "order number," and the corresponding extraction formula is ≡2 \d {12}. The extraction formula is used to extract the character string "2010012012345" and write the character string to the location corresponding to the field tag. In this way, the CSV file with the order data written is finally obtained.
To facilitate subsequent updates to the order status source file and the order attribute value source file, respectively, the CSV files are divided into two types, wherein the order status and the order attribute value are divided into different CSV files, and the unique order attribute value exists in both CSV files.
203. When the CSV file writing operation is finished, generating an identification file corresponding to the CSV file;
in this embodiment, flg files are used as the identification files. flg file is a file with low popularity, which rarely appears in most files, and the purpose of using the file as an identification file is to reduce the possibility of being called or modified by other software because the file is used less, so as to improve the accuracy of identification.
204. Associating the CSV file with the identification file and storing the CSV file and the identification file in a network attached storage disk;
and storing the generated CSV file and the corresponding flg file in a network attached storage disk.
In order to facilitate determining whether a corresponding CSV file is generated according to the flg file, the flg file and the CSV file may be named the same. Writing relevant information of the CSV file into the flg file can also be adopted to correlate the CSV file and the flg file.
205. Judging whether the identification file exists in the network additional storage disk or not;
searching a folder or a network attached disk where the flg file is located to judge whether the flg file is generated or not.
206. If yes, reading an order state or an order attribute value in the CSV file corresponding to the identification file;
the file name of the flg file is 20100120xxx, then the file name of the CSV file is 20100120xxx according to the file name of the flg file, the corresponding CSV file is searched, and finally the file is read.
207. And updating the read order data into an order source file in a back-end database.
In this embodiment, after the CSV file is generated, a flg for identification is also generated, and only after the flg file is generated, order data in the CSV file is read, so that the CSV file is prevented from being read without generating, and thus the occurrence of data loss is reduced.
Referring to fig. 3, a second embodiment of a method for updating a express order according to an embodiment of the present invention includes:
301. acquiring order data of each express order generated by the front end every preset order updating time length;
302. generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk;
303. reading the order data in the CSV file from the network attached storage disk;
304. traversing the order attribute value source file by taking the unique key attribute value in the read order attribute value as a keyword, and outputting a traversing result corresponding to each express order;
in this embodiment, the unique attribute value is an order number.
After determining the CSV file to be read according to the flg file, sequentially extracting order information from the CSV file corresponding to the field label 'order number'. The first order number is "2010012012345", so in the source file, it is determined whether there is an order attribute value with the same order number based on "2010012012345".
305. If the traversing result is null, writing the read order attribute value into the order attribute value source file;
if the traversing result is null, the order data is considered not to appear in the source file, so that the corresponding order data is written into the order source file;
when the goods B are not sent, the order data in the CSV file is [ "A company", "2010012012345", "month knot" ]. Since the order was just created, there is no record in the second data table.
The order data [ "A company", "2010012012345", "" month knot "] is directly written into the source file, and the accurate update of the data can be completed.
306. If the traversing result is non-empty, updating the read order attribute value into the order attribute value source file to replace the historical order attribute value in the order attribute value source file;
for example, the user requests to modify payment mode during the cargo transportation process, and after the cargo arrives at the transfer point C, the order data in the CSV file is read as [ "a company", "2010012012345", "paid" ]. Since the order has been created when not placed, there are order attribute values in the order attribute value source file that have the same order number.
And (3) after finding that the search result is 1 through the unique attribute value, writing the order attribute value in the order data into the source file, and deleting the historical order attribute value in the source file at the same time, thereby completing the updating of the order number.
The present embodiment specifically describes updating order attribute value source files. The order state and the attribute value of the order are divided, so that the repeated modification times of the order are reduced. In the past, when a certain order is modified, all data of the order need to be modified, such as the state of the order is modified, but all express orders are replaced completely, in this process, the attribute values of partial order express items may be lost and modified, and there is a difference from the prior art. In this way, therefore, the accuracy of the update of the express order source file is improved.
Referring to fig. 4, a fourth embodiment of a method for updating a express order according to an embodiment of the present invention includes:
401. acquiring order data of each express order generated by the front end every preset order updating time length;
402. generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk;
403. reading the order data in the CSV file from the network attached storage disk;
404. traversing the order state source file by taking the order state as a keyword, and outputting traversing results corresponding to all express orders;
in this embodiment, the order status source file preferably has unique key attribute values for the order and corresponding order status. The unique key attribute value can be used as a basis for associating the order state with the express order, and the unique key attribute value and the express order can be associated in a mapping function mode, so that the association between the order state and each order can be realized.
And traversing and searching the order state source file by taking the read order state as a keyword. Since each express order has its own unique key attribute value, for express items with the same unique key attribute value
And outputting the traversing result corresponding to each express order.
405. If the traversing result is null, writing the read order state into the order state source file;
in this embodiment, the read order status is "signed" and in the order source file, the unique key attribute value, in this embodiment the order number, is "2010012012345" and the express order has no data with the order status of "signed".
The order status "signed in" is thus written into the order status source file along with the corresponding "2010012012345".
If the traversing result is not null and the express order of the '2010012012345' has the data with the order state of 'signed', the order state source file is not updated any more.
In this embodiment, the order status is used as a keyword to search whether the same order express item has a corresponding order status, and if not, the order status is written into the source file. Thus, in the order status source file, the status changes for each express order can be detailed. Corresponding time can be added into the order state source file, so that a dynamic order state record can be made for the express order.
Referring to fig. 5, a fifth embodiment of a method for updating a express order according to an embodiment of the present invention includes:
501. acquiring order data of each express order generated by the front end every preset order updating time length;
502. generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk;
503. reading the order data in the CSV file from the network attached storage disk;
504. updating the read order data to an order source file in a back-end database;
505. acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
506. acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
similar to the creation of the CSV file, the configuration information of the report is preset.
The report field is needed to determine which data in the source file is needed for the report. If the report field corresponds to the company name, the data corresponding to the company name in the order attribute value in the source file is required by the report. And the statistical rule of the report field value is mainly used for counting the field value. If the field corresponds to "company a" having two pieces of data and "company B" having one piece of data, the field value of "company a" is 2 and the field value of "company B" is 1.
The configuration information may be stored in the form of a file, template, or the like.
507. Generating a corresponding blank order report according to the report configuration information;
a blank report is created, and the configuration information is loaded on the basis, so that an initial report is generated. And according to the configuration information, a report field label appears in the initial report.
508. And reading corresponding order data from the order source file according to the report field of the order report and the statistical rule, and writing the corresponding order data into the order report.
The statistical rule may be to count company names and the number of occurrences more than 5, and draw a graph with these company names and the number of occurrences, and so on.
The required order data can be obtained from the order source file through the report fields and the statistical rules, and the corresponding order report is generated, so that the resource adjustment of the user who places orders in the near term at high frequency is convenient to follow-up, and the working efficiency is improved.
The embodiment provides a report generation method based on an order source file. The source file is only one summary of all orders, and when a corresponding report needs to be generated, certain extraction is also needed to be carried out on the information data in the report, so that the report can be flexibly and rapidly generated according to the source file.
The method for updating a express order in the embodiment of the present invention is described above, and the express order updating device in the embodiment of the present invention is described below, referring to fig. 6, where an embodiment of the express order updating device in the embodiment of the present invention includes:
the acquiring module 601 is configured to acquire order data of each express order generated by the front end every preset order update duration;
the generating module 602 is configured to generate a blank CSV file corresponding to the update of the current order, and write the order data into the CSV file according to the generating sequence of each express order, and store the order data into a network attached storage disk;
a reading module 603, configured to read the order data in the CSV file from the network attached storage disk;
and the updating module 604 is used for updating the read order data into an order source file in a back-end database.
The traditional order updating is based on directly inserting order data in a front-end database into order source files in a back-end database, and the invention adds CSV files for transfer on a network additional storage disk on the original basis so as to reduce the probability of errors caused by directly inserting the order source files into the final storage. Network attached storage disk is connected to network, centralized network file access mechanism and sharing can be used to cope with the unfeasible system limitation.
Referring to fig. 7, another embodiment of a express order update apparatus according to an embodiment of the present invention includes:
the acquiring module 701 is configured to acquire order data of each express order generated by the front end every preset order update duration;
the generating module 702 is configured to generate a blank CSV file corresponding to the update of the current order, and write the order data into the CSV file according to the generating order of each express order, and store the order data into a network attached storage disk;
a reading module 703, configured to read the order data in the CSV file from the network attached storage disk;
and the updating module 704 is used for updating the read order data into an order source file in a back-end database.
Optionally, the generating module 702 is specifically configured to:
generating a blank CSV file corresponding to the update of the current order, and writing the order data into the CSV file according to the generation sequence of each express order;
when the CSV file writing operation is finished, generating an identification file corresponding to the CSV file;
and associating the CSV file with the identification file and storing the CSV file and the identification file in a network attached storage disk, wherein the order state and the order attribute value are respectively stored in different CSV files.
The optional reading module 703 is specifically configured to:
judging whether the identification file exists in the network additional storage disk or not;
if yes, reading an order state or an order attribute value in the CSV file corresponding to the identification file.
Optionally, the update module 704 includes an attribute value update unit 7041 and a state update unit 7042, where the attribute value update unit is specifically configured to:
traversing the order attribute value source file by taking the read unique key attribute value as a keyword, and outputting a traversing result corresponding to each express order;
if the traversing result is null, writing the read order attribute value into the order attribute value source file;
if the traversing result is non-empty, updating the read order attribute value into the order attribute value source file to replace the historical order attribute value in the order attribute value source file.
Optionally, the status updating unit 7042 is specifically configured to:
traversing the order state source file by taking the read order state as a keyword, and outputting traversing results corresponding to all express orders;
and if the traversing result is null, writing the read order state into the order state source file.
Optionally, the express order updating device further includes a report module 705, where the report module 705 is specifically configured to:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
generating a corresponding blank order report according to the report configuration information;
and reading corresponding order data from the order source file according to the report field of the order report and the statistical rule, and writing the corresponding order data into the order report.
In this embodiment, after the CSV file is generated, an identification file for identification is also generated, and only after the identification file is generated, order data in the CSV file is read, so that the CSV file is prevented from being read without being generated, and thus the occurrence of data loss is reduced. And the order update is divided into two forms, namely order attribute value update and order state update, and the order attribute value update and the order state update are associated by a unique key attribute value. The update of the order attribute value can directly display the basic attribute of the current express order, the order state source file can display the logistics state of the current express order, the order data is written in two parts, the pressure of repeated writing is shared, and the possibility of error is reduced.
The express order updating device in the embodiment of the present invention is described in detail above in terms of the modularized functional entity in fig. 6 and fig. 7, and the express order updating apparatus in the embodiment of the present invention is described in detail below in terms of hardware processing.
Fig. 8 is a schematic diagram of a configuration of a express order update apparatus according to an embodiment of the present invention, where the express order update apparatus 800 may have a relatively large difference due to configuration or performance, and may include one or more processors (central processing units, CPU) 810 (e.g., one or more processors) and a memory 820, and one or more storage media 830 (e.g., one or more mass storage devices) storing application programs 833 or data 832. Wherein the memory 720 and the storage medium 830 may be transitory or persistent. The program stored on the storage medium 830 may include one or more modules (not shown), each of which may include a series of instruction operations in the express order update apparatus 800. Still further, the processor 810 may be arranged to communicate with the storage medium 830 and execute a series of instruction operations in the storage medium 830 on the express order update device 500.
The express order update apparatus 800 may also include one or more power supplies 840, one or more wired or wireless network interfaces 850, one or more input/output interfaces 870, and/or one or more operating systems 831, such as Windows Serve, mac OS X, unix, linux, freeBSD, and the like. Those skilled in the art will appreciate that the express order update apparatus structure illustrated in FIG. 8 does not constitute a definition of an express order update apparatus and may include more or fewer components than illustrated, or may combine certain components, or a different arrangement of components.
The present invention also provides a computer readable storage medium, which may be a non-volatile computer readable storage medium, or a volatile computer readable storage medium, having stored therein instructions that, when executed on a computer, cause the computer to perform the steps of the express order update method.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (random access memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for updating a express order, the method comprising:
acquiring order data of each express order generated by the front end every preset order updating time length; the front end includes: a folder, a network disk and a database containing the order data; the database comprises: an order system and a greenplus database; presetting and acquiring the updating time length of the database;
generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generation sequence of each express order, and storing the order data into a network additional storage disk; when order form configuration information exists, pre-configuring the order form configuration information of the CSV file to be generated; the order form configuration information includes: the field label and the extraction formula corresponding to the field label;
reading the order data in the CSV file from the network attached storage disk;
and updating the read order data into an order source file in a back-end database.
2. The method of claim 1, wherein the order data comprises: the order status is distinguished from the order attribute value by the unique key attribute value of the order, and the order update comprises: order status update and order attribute value update, the order source file comprising: order status source files and order attribute value source files.
3. The method for updating a express order according to claim 2, wherein generating a blank CSV file corresponding to the update of the present order, writing the order data into the CSV file according to the order of generating each express order, and storing the order data in a network attached storage disk comprises:
generating a blank CSV file corresponding to the update of the current order, and writing the order data into the CSV file according to the generation sequence of each express order;
when the CSV file writing operation is finished, generating an identification file corresponding to the CSV file;
and associating the CSV file with the identification file and storing the CSV file and the identification file in a network attached storage disk, wherein the order state and the order attribute value are respectively stored in different CSV files.
4. A method of updating a express order according to claim 3, wherein said reading said order data in said CSV file from said network attached storage disk comprises:
judging whether the identification file exists in the network additional storage disk or not;
if yes, reading an order state or an order attribute value in the CSV file corresponding to the identification file.
5. The method of claim 4, wherein updating the read order data into the order source file in the back-end database comprises:
traversing the order attribute value source file by taking the unique key attribute value in the read order attribute value as a keyword, and outputting a traversing result corresponding to each express order;
if the traversing result is null, writing the read order attribute value into the order attribute value source file;
if the traversing result is non-empty, updating the read order attribute value into the order attribute value source file to replace the historical order attribute value in the order attribute value source file.
6. The method of claim 4, wherein updating the read order data into the order source file in the back-end database comprises:
traversing the order state source file by taking the read order state as a keyword, and outputting traversing results corresponding to all express orders;
and if the traversing result is null, writing the read order state into the order state source file.
7. The method of any of claims 1-6, further comprising, after said updating the read order data into an order source file in a back-end database:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of report field values;
generating a corresponding blank order report according to the report configuration information;
and reading corresponding order data from the order source file according to the report field of the order report and the statistical rule, and writing the corresponding order data into the order report.
8. A express order update apparatus, characterized in that the express order update apparatus comprises:
the acquisition module is used for acquiring order data of each express order generated by the front end every preset order updating time; the front end includes: a folder, a network disk and a database containing the order data; the database comprises: an order system and a greenplus database; presetting and acquiring the updating time length of the database;
the generating module is used for generating a blank CSV file corresponding to the update of the current order, writing the order data into the CSV file according to the generating sequence of each express order, and storing the order data into a network additional storage disk; when order form configuration information exists, pre-configuring the order form configuration information of the CSV file to be generated; the order form configuration information includes: the field label and the extraction formula corresponding to the field label;
the reading module is used for reading the order data in the CSV file from the network additional storage disk;
and the updating module is used for updating the read order data into an order source file in a back-end database.
9. A express order update apparatus, characterized in that the express order update apparatus comprises: a memory and at least one processor, the memory having instructions stored therein, the memory and the at least one processor being interconnected by a line;
the at least one processor invoking the instructions in the memory to cause the express order update apparatus to perform the express order update method of any of claims 1-7.
10. A computer readable storage medium having stored thereon a computer program, which when executed by a processor implements a method of updating a express order according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010164818.2A CN111242751B (en) | 2020-03-11 | 2020-03-11 | Express order updating method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010164818.2A CN111242751B (en) | 2020-03-11 | 2020-03-11 | Express order updating method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111242751A CN111242751A (en) | 2020-06-05 |
| CN111242751B true CN111242751B (en) | 2023-08-01 |
Family
ID=70873208
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010164818.2A Active CN111242751B (en) | 2020-03-11 | 2020-03-11 | Express order updating method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111242751B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111882265A (en) * | 2020-06-29 | 2020-11-03 | 深圳市法本信息技术股份有限公司 | Cross-border e-commerce automatic customs declaration method and automatic customs declaration robot |
| CN113807923B (en) * | 2021-09-23 | 2024-02-09 | 杭州右文网络科技有限公司 | Order processing method and device, electronic equipment and readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015081815A1 (en) * | 2013-12-05 | 2015-06-11 | 北京奇虎科技有限公司 | Logistics status information monitoring method, device, and system |
| CN108038767A (en) * | 2017-12-26 | 2018-05-15 | 广州供电局有限公司 | Electric business order asynchronous distribution system and method based on message queue |
| CN110020925A (en) * | 2019-04-15 | 2019-07-16 | 北京闪送科技有限公司 | Order processing method, apparatus, equipment and storage medium |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10262377B2 (en) * | 2013-09-13 | 2019-04-16 | Mace Engineering Group Pty Ltd. | Sales order data collection and management system |
| CN106327306B (en) * | 2016-08-29 | 2020-05-29 | 深圳前海浩方科技有限公司 | Order life cycle presentation method and system |
| CN109828964B (en) * | 2019-02-19 | 2021-11-26 | 北京奇艺世纪科技有限公司 | Data import method and device and electronic equipment |
| CN110309206B (en) * | 2019-07-10 | 2022-06-10 | 中国联合网络通信集团有限公司 | Order information acquisition method and system |
| CN110377666B (en) * | 2019-07-26 | 2023-03-31 | 浪潮软件股份有限公司 | Method for synchronizing data between different source databases based on CMSP message middleware |
| CN110674109B (en) * | 2019-09-06 | 2024-02-06 | 中国平安财产保险股份有限公司 | Data importing method, system, computer equipment and computer readable storage medium |
-
2020
- 2020-03-11 CN CN202010164818.2A patent/CN111242751B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015081815A1 (en) * | 2013-12-05 | 2015-06-11 | 北京奇虎科技有限公司 | Logistics status information monitoring method, device, and system |
| CN108038767A (en) * | 2017-12-26 | 2018-05-15 | 广州供电局有限公司 | Electric business order asynchronous distribution system and method based on message queue |
| CN110020925A (en) * | 2019-04-15 | 2019-07-16 | 北京闪送科技有限公司 | Order processing method, apparatus, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111242751A (en) | 2020-06-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8180779B2 (en) | System and method for using external references to validate a data object's classification / consolidation | |
| US20200218737A1 (en) | Method, system and program product for matching of transaction records | |
| US7848970B2 (en) | System and method for synchronizing ledger accounts by company group | |
| US20170147979A1 (en) | Augmented Aggregation of Emailed Product Order and Shipping Information | |
| US6662189B2 (en) | Method of performing data mining tasks for generating decision tree and apparatus therefor | |
| US20030171942A1 (en) | Contact relationship management system and method | |
| US7493323B2 (en) | Document group analyzing apparatus, a document group analyzing method, a document group analyzing system, a program, and a recording medium | |
| EP1990740A1 (en) | Schema matching for data migration | |
| CN108647357B (en) | Data query method and device | |
| US7664704B2 (en) | Clearing receivables with improved search | |
| CN111459985A (en) | Identification information processing method and device | |
| Agarwal et al. | Approximate incremental big-data harmonization | |
| CN106126630A (en) | The collection of a kind of business object, searching method and device | |
| CN111242751B (en) | Express order updating method, device, equipment and storage medium | |
| US10296622B1 (en) | Item attribute generation using query and item data | |
| CN110659282B (en) | Data route construction method, device, computer equipment and storage medium | |
| US20190130050A1 (en) | Dynamically generating normalized master data | |
| US20190129981A1 (en) | Asynchronous distributed data cleansing | |
| US20230205755A1 (en) | Methods and systems for improved search for data loss prevention | |
| CN100517334C (en) | Method and apparatus for representing a group hierarchy structure in a relational database | |
| US20240062235A1 (en) | Systems and methods for automated processing and analysis of deduction backup data | |
| US20070112752A1 (en) | Combination of matching strategies under consideration of data quality | |
| CN108304291B (en) | Test input information retrieval apparatus and method | |
| CN111125499A (en) | Data query method and device | |
| JP6634938B2 (en) | Analysis support method, analysis support program, and analysis support device |
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 |