CN111242751A - Express order updating method, device, equipment and storage medium - Google Patents
Express order updating method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111242751A CN111242751A CN202010164818.2A CN202010164818A CN111242751A CN 111242751 A CN111242751 A CN 111242751A CN 202010164818 A CN202010164818 A CN 202010164818A CN 111242751 A CN111242751 A CN 111242751A
- Authority
- CN
- China
- Prior art keywords
- order
- file
- express
- updating
- data
- 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.)
- Granted
Links
Images
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 an express order. The express order updating method comprises the following steps: acquiring order data of each express order generated by a front end every preset order updating time; generating a blank CSV file corresponding to the order update, 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 disc; reading the order data in the CSV file from the network additional storage disk; and updating the read order data into an order source file in a back-end database. The invention reduces the times of directly inserting the source file by generating the CSV file for transferring and backing up, thereby improving the updating accuracy of the express order.
Description
Technical Field
The invention relates to the field of logistics management, in particular to a method, a device, equipment and a storage medium for updating an express order.
Background
With the development of the internet, electronic commerce increasingly shows huge development potential and is widely applied to various industries. The electronic morning improves the economic behaviors of people such as shopping and consumption, and simultaneously, the speed and the richness of obtaining services and products by people are increased by combining the rapid development of logistics. At the same time, the increase in users has in turn increased the range of services for e-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, data about orders are more and more, whether the orders are delivered or not, logistics information corresponding to the orders and the like are needed to be counted and updated by the company in time. However, directly inputting a large amount of data into the system at one time causes delay to the system, and there is a certain repetition of the order. Therefore, errors exist in subsequent expense settlement, butt joint with other platforms and the like.
Disclosure of Invention
The invention mainly aims to solve the technical problem of poor updating accuracy in the updating process of express orders.
The invention provides a method for updating an express order, which comprises the following steps:
acquiring order data of each express order generated by a front end every preset order updating time;
generating a blank CSV file corresponding to the order update, 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 disc;
reading the order data in the CSV file from the network additional 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: the order state, the unique key attribute value and the order attribute value, different express orders are distinguished through the unique key attribute value of the order, and the order updating comprises the following steps: order status update and order attribute value update, wherein the order source file comprises: the order state source file and the order attribute value source file.
Optionally, in a second implementation manner of the first aspect of the present invention, the generating a blank CSV file corresponding to the order update, and writing the order data into the CSV file according to the generation sequence of each express order and then storing the order data into a network attached storage disk includes:
generating a blank CSV file corresponding to the order update, 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 and the identification file and storing the CSV file and the identification file into a network additional storage disk, wherein the order state and the order attribute value are respectively stored into different CSV files.
Optionally, in a third implementation manner of the first aspect of the present invention, the reading, from the network attached storage disk, the order data in the CSV file includes:
judging whether the identification file exists in the network attachment storage disk or not;
and if so, reading the order state or the 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 into 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 values as a key word, and outputting a traversal result corresponding to each express order;
if the traversal result is null, writing the read order attribute value into the order attribute value source file;
and if the traversal result is not null, updating the order attribute value source file with the read order attribute value 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 into 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 a traversal result corresponding to each express order;
and if the traversal 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 the order source file in the back-end database, the method further includes:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of the report field values;
generating a corresponding blank order form according to the form configuration information;
and reading corresponding order data from the order source file and writing the order data into the order report according to the report field of the order report and the statistical rule.
A second aspect of the present invention provides an express order updating 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 order update, 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 disc;
a reading module, configured to read the order data in the CSV file from the network attached storage disk;
and the updating module is used for updating the read order data into an order source file in a 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 order update, 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 and the identification file and storing the CSV file and the identification file into a network additional storage disk, wherein the order state and the order attribute value are respectively stored into 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 attachment storage disk or not;
and if so, reading the order state or the 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 values as a key word, and outputting a traversal result corresponding to each express order;
if the traversal result is null, writing the read order attribute value into the order attribute value source file;
and if the traversal result is not null, updating the order attribute value source file with the read order attribute value 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 a traversal result corresponding to each express order;
and if the traversal 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 updating apparatus further includes a reporting module, where the reporting module is specifically configured to:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of the report field values;
generating a corresponding blank order form according to the form configuration information;
and reading corresponding order data from the order source file and writing the order data into the order report according to the report field of the order report and the statistical rule.
A third aspect of the present invention provides an express order updating apparatus, comprising: a memory having instructions stored therein and at least one processor, the memory and the at least one processor interconnected by a line; the at least one processor invokes the instructions in the memory to cause the dispatch order update apparatus to perform the dispatch order update method described above.
A fourth aspect of the present invention provides a computer-readable storage medium having stored therein instructions, which, when run on a computer, cause the computer to execute the above-described express order updating method.
The traditional order updating is based on directly inserting order data in a front-end database into an order source file in a back-end database, and the CSV file which is positioned on a network additional storage disc and used for transferring is added on the original basis so as to reduce the probability of errors caused by directly inserting the finally stored order source file. The network additional storage disk is connected on the network, and a centralized network file access mechanism and sharing can be adopted to deal with the system limitation which is not available. After the CSV file is generated, an identification file for identification is 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 after the CSV file is not generated, and the occurrence of data loss is reduced. When a source file containing an order state and an order attribute value is updated, whether the order data is the latest order data or not is judged according to the acquisition event of the order data, and the situation that the order data is covered by old data in a wrong way is reduced. The invention can also be flexibly configured and can dynamically generate the report for the subsequent order data analysis so as to improve the efficiency of generating and analyzing the report.
Drawings
FIG. 1 is a schematic diagram of a first embodiment of an update method for an express order according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a second embodiment of a method for updating an express order according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a third embodiment of an update method for an express order according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating a fourth embodiment of an update method for an express order according to an embodiment of the present invention;
FIG. 5 is a diagram illustrating a fifth embodiment of an update method for an express order according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of an embodiment of an apparatus for updating an express order according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of another embodiment of an apparatus for updating an express order according to an embodiment of the present invention;
fig. 8 is a schematic diagram of an embodiment of an express order updating device in the embodiment of the invention.
Detailed Description
The embodiment of the invention provides a method, a device, equipment and a storage medium for updating an express order. The traditional order updating is based on directly inserting order data in a front-end database into an order source file in a back-end database, and the CSV file which is positioned on a network additional storage disc and used for transferring is added on the original basis so as to reduce the probability of errors caused by directly inserting the finally stored order source file. The network additional storage disk is connected on the network, and a centralized network file access mechanism and sharing can be adopted to deal with the system limitation which is not available. After the CSV file is generated, an identification file for identification is 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 after the CSV file is not generated, and the occurrence of data loss is reduced. When a source file containing an order state and an order attribute value is updated, whether the order data is the latest order data or not is judged according to the acquisition event of the order data, and the situation that the order data is covered by old data in a wrong way is reduced. The invention can also be flexibly configured and can dynamically generate the report for the subsequent order data analysis so as to improve the efficiency of generating and analyzing the report.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, 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," or "having," and any variations thereof, are intended to cover non-exclusive inclusions, 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, a detailed flow of an embodiment of the present invention is described below, and referring to fig. 1, an embodiment of an express order updating method according to an embodiment of the present invention includes:
101. acquiring order data of each express order generated by a front end every preset order updating time;
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, in which after a user places an order, the user is checked to determine the identity of the user, namely company A. Then, a specific order number is generated for the order, and the order number rules are various, and here, the order number is "2010012012345" with the naming rule of year, month, day (8 bits) + self-increment number (5 bits). Meanwhile, according to the information filled by the user, the payment mode is determined to be 'moon knot'. Finally, as the order is just generated, the order state "to be delivered" corresponding to the order is generated.
And the second is the greenplus database. The architecture of greenplus employs MPP (massively parallel processing). In the MPP system, each SMP node may also run its own operating system, database, and the like. Therefore, greenplus has great advantages in processing massive databases and can quickly complete the processing of searching the databases and the like. 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 entered into the greenplus database in a code scanning or manual entry mode, and the order state in the greenplus database is changed to "in transit".
The updating time for obtaining the two initial databases is preset. Because order information data entry of the transit point may have specific time, if 100 pieces of order information are accumulated, entry is performed in a unified manner, the time for acquiring the greenplus database can be longer than that of an order system. In addition, since the goods may enter the delivery 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 greenplus database is covered by the information of the subsequent order system, and an update error occurs, so that the former is set to be acquired once in two hours, and the latter is set to be acquired once in 5 minutes.
102. Generating a blank CSV file corresponding to the order update, 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 disc;
in this embodiment, the order table configuration information of the CSV file to be generated is configured in advance.
The order form configuration information may be stored in the form of a configuration file, such as a cs file. The order table configuration information may also include field tags and extraction formulas corresponding to the field tags. The previous order information is 'company A-2010012012345-in transit-monthly', a blank csv file is created through import, and then field labels and corresponding extraction formulas in the order table configuration information are imported.
An example of one order data is "company a-2010012012345-mid-transit-month end". In the front end, the order information is { "2010012012345", "company a", "moon", "in transit" }. The current field label is 'order number', so the extraction formula is ^ 2 \ d {12}, and the character string of the current order information is traversed to obtain the character string '2010012012345', so the character string is extracted. And after extraction, writing the character string into the position corresponding to the field label. In this way, the CSV file in which the order data is written is finally obtained.
The above is only a preferred way in the embodiment, and when there is no configuration information, the order data may also be written into the CSV file directly or in other ways.
103. Reading the order data in the CSV file from the network additional storage disk;
and scanning the network additional storage disk, and searching and judging whether the CSV file is to be read. And if so, reading order data in the CSV file.
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 CSV file generated firstly can be used as an order source file to be directly written into a back-end database.
There are two updating ways, one is direct writing, and the other is replacing the order attribute value in the source file with the order data. And 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. And if the order attribute values are not consistent, replacing the order attribute values in the source file with the order data.
The invention adds the CSV file which is positioned on the network additional storage disk and used for transferring on the basis of the traditional order updating so as to reduce the probability of errors caused by directly inserting the finally stored order source file. In addition, the network additional storage disk is connected on the network, and a centralized network file access mechanism and sharing can be adopted to deal with the system limitation which is not available.
Referring to fig. 2, another embodiment of the method for updating an express order according to the embodiment of the present invention includes:
201. acquiring order data of each express order generated by a front end every preset order updating time, wherein the order data comprises an order state, an order unique key attribute value and an order attribute value, and different express orders are distinguished through the unique key attribute value of the order;
the order data is divided into two types, namely order state and order attribute value, each express order has a specific unique key attribute value, and therefore different express orders are distinguished by the unique key attribute value in the order file.
The order state is mainly the current transport state of the express order, such as 'pull' transport, arrival xxx and 'signed-in'.
The order attribute value is the basic attribute of the express order, such as sender, receiver and address.
202. Generating a blank CSV file corresponding to the order update, and writing the order data into the CSV file 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 order table configuration information of the CSV file to be generated is configured in advance.
And creating a blank csv file through import, and then importing the field tags and the corresponding extraction formulas in the configuration information of the order table.
An example of one order data is "company a-2010012012345-mid-transit-month end". And traversing the order data in the front end according to the generation sequence. The currently 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 the character string is written into the position corresponding to the field label. In this way, the CSV file in which the order data is written is finally obtained.
In order to facilitate subsequent updating of 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 in different CSV files, and the only 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, a flg file is used as the identification file. The flg file is a file with low popularity, the file rarely appears in most files, and the purpose of using the file as the identification file is also that the file is less used, so that the possibility of being called or modified by other software is reduced, and the identification accuracy is improved.
204. Associating the CSV file with the identification file and storing the CSV file and the identification file into a network additional storage disk;
and storing the generated CSV file and the corresponding flg file in a network additional storage disk.
In order to determine whether the corresponding CSV file is generated according to the flg file, the flg file and the CSV file may be named by the same name. The related information of the CSV file can also be written into the flg file to associate the CSV file with the flg file.
205. Judging whether the identification file exists in the network attachment storage disk or not;
and searching a folder or a network attached disk where the flg file is located to judge whether the flg file is generated.
206. If so, reading the order state or the order attribute value in the CSV file corresponding to the identification file;
the file name of the flg file is '20100120 xxx', then the file name of the CSV file is '20100120 xxx' according to the file name of the flg file, and 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, the order data in the CSV file is read, so that the CSV file is prevented from being read without being generated, and the occurrence of data loss is reduced.
Referring to fig. 3, a second embodiment of the method for updating an express order according to the embodiment of the present invention includes:
301. acquiring order data of each express order generated by a front end every preset order updating time;
302. generating a blank CSV file corresponding to the order update, 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 disc;
303. reading the order data in the CSV file from the network additional storage disk;
304. traversing the order attribute value source file by taking the unique key attribute value in the read order attribute values as a key word, and outputting a traversal result corresponding to each express order;
in this embodiment, the unique attribute value is the order number.
After the CSV file to be read is determined according to the flg file, order information is sequentially extracted from the CSV file corresponding to the field label 'order number'. The first order number is "2010012012345", so in the source file, according to "2010012012345", it is determined whether there is an order attribute value with the same order number.
305. If the traversal result is null, writing the read order attribute value into the order attribute value source file;
if the traversal result is null, the order data is not found in the source file, and therefore the corresponding order data is written into the order source file;
when the goods B are not delivered, the order data in the CSV file is [ "company a", "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 traversal result is not null, updating the order attribute value source file with the read order attribute value to replace the historical order attribute value in the order attribute value source file;
for example, the user requests to modify the payment method during the transportation of the goods, and when the goods arrive at the transit point C, the order data in the CSV file is read as [ "company a", "2010012012345", "pay-to-pay" ]. Since the order was already created when not placed, there are order attribute values in the order attribute value source file that have the same order number.
And writing the order attribute value in the order data into the source file after the search result is found to be 1 through the unique attribute value, and deleting the historical order attribute value in the source file, thereby completing the updating of the order number.
This embodiment describes updating the order attribute value source file. 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 needs to be modified, such as the order state, but all express orders are completely replaced, and in the process, the attribute values of part of express orders are lost and modified, and the difference exists between the attribute values and the attribute values. Therefore, by the method, the updating accuracy of the source file of the express order is improved.
Referring to fig. 4, a fourth embodiment of the method for updating an express order according to the embodiment of the present invention includes:
401. acquiring order data of each express order generated by a front end every preset order updating time;
402. generating a blank CSV file corresponding to the order update, 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 disc;
403. reading the order data in the CSV file from the network additional storage disk;
404. traversing the order state source file by taking the order state as a keyword, and outputting a traversal result corresponding to each express order;
in this embodiment, the order status source file preferably has a unique key attribute value of the order and a 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 order state and the express order can be associated in a mapping function mode, so that the order state and each order can be associated without limitation.
And traversing and retrieving 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, the express orders with the same unique key attribute value are aimed at
And outputting the traversal result corresponding to each express order.
405. If the traversal result is empty, writing the read order state into the order state source file;
in this embodiment, the read order status is "signed-in", and in the order source file, the unique key attribute value, in this embodiment, the order number, and the express order of "2010012012345" has no data with the order status of "signed-in".
The order status "signed in" is therefore written into the order status source file along with the corresponding "2010012012345".
If the traversal result is not null, the order status source file is not updated if the order of the express order of 2010012012345 has data with the order status of signed.
In this embodiment, the order status is used as a key to search whether the same order express 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 change for each express order can be specified. Corresponding time can be added into the order state source file, so that a dynamic order state record is made for the express order.
Referring to fig. 5, a fifth embodiment of the method for updating an express order according to the embodiment of the present invention includes:
501. acquiring order data of each express order generated by a front end every preset order updating time;
502. generating a blank CSV file corresponding to the order update, 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 disc;
503. reading the order data in the CSV file from the network additional storage disk;
504. updating the read order data into 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 the report field values;
506. acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of the report field values;
similar to creating a CSV file, the configuration information of the report is preset.
The report fields are needed to determine which data in the source file is a report. If the report field corresponds to the company name, the data of the order attribute value corresponding to the company name in the source file is required by the report. The statistical rule of the report field value is mainly used for counting the field value. If the field has two pieces of data corresponding to "company a" and one piece of data corresponding to "company B", the field value of "company a" is set to 2 and the field value of "company B" is set to 1.
The configuration information may be stored in the form of a file, template, etc.
507. Generating a corresponding blank order form according to the form configuration information;
a blank report is created and the configuration information is loaded based thereon, thereby generating an initial report. And according to the configuration information, report field tags appear in the initial report.
508. And reading corresponding order data from the order source file and writing the order data into the order report according to the report field of the order report and the statistical rule.
The statistical rule may be to count company names and occurrences whose number of occurrences is greater than 5, and to draw a graph with the company names and occurrences, and so on.
Through the report fields and the statistical rules, required order data can be obtained from the order source file, and a corresponding order report is generated, so that resource adjustment can be conveniently performed on a user who places an order with high frequency recently, 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 needs to be performed on information data in the report so as to flexibly and quickly generate the report according to the source file.
With reference to fig. 6, the method for updating an express order in the embodiment of the present invention is described above, and an express order updating apparatus in the embodiment of the present invention is described below, where an embodiment of the express order updating apparatus in the embodiment of the present invention includes:
an obtaining module 601, configured to obtain order data of each express order generated by a front end every preset order updating duration;
a generating module 602, configured to generate a blank CSV file corresponding to the order update, write the order data into the CSV file according to a generation sequence of each express order, and store the CSV file in 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;
an updating module 604, configured to update 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 an order source file in a back-end database, and the CSV file which is positioned on a network additional storage disc and used for transferring is added on the original basis so as to reduce the probability of errors caused by directly inserting the finally stored order source file. The network additional storage disk is connected on the network, and a centralized network file access mechanism and sharing can be adopted to deal with the system limitation which is not available.
Referring to fig. 7, another embodiment of the express order updating apparatus according to the embodiment of the present invention includes:
an obtaining module 701, configured to obtain order data of each express order generated by a front end every preset order update duration;
a generating module 702, configured to generate a blank CSV file corresponding to the order update, write the order data into the CSV file according to a generation sequence of each express order, and store the CSV file in 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;
an updating module 704, configured to update 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 order update, 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 and the identification file and storing the CSV file and the identification file into a network additional storage disk, wherein the order state and the order attribute value are respectively stored into different CSV files.
The optional reading module 703 is specifically configured to:
judging whether the identification file exists in the network attachment storage disk or not;
and if so, reading the order state or the order attribute value in the CSV file corresponding to the identification file.
Optionally, the updating module 704 includes an attribute value updating unit 7041 and a state updating unit 7042, where the attribute value updating 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 traversal result corresponding to each express order;
if the traversal result is null, writing the read order attribute value into the order attribute value source file;
and if the traversal result is not null, updating the order attribute value source file with the read order attribute value to replace the historical order attribute value in the order attribute value source file.
Optionally, the state updating unit 7042 is specifically configured to:
traversing the order state source file by taking the read order state as a keyword, and outputting a traversal result corresponding to each express order;
and if the traversal result is null, writing the read order state into the order state source file.
Optionally, the express order updating apparatus further includes a reporting module 705, where the reporting module 705 is specifically configured to:
acquiring report configuration information, wherein the report configuration information comprises report fields and statistical rules of the report field values;
generating a corresponding blank order form according to the form configuration information;
and reading corresponding order data from the order source file and writing the order data into the order report according to the report field of the order report and the statistical rule.
In this embodiment, after the CSV file is generated, an identifier file for identification is also generated, and only after the identifier file is generated, the 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 updating is divided into two modes of order attribute value updating and order state updating, and the unique key attribute value is used for carrying out association. The updating of the order attribute value can directly display the basic attribute of the current express order, the source file of the order state can display the logistics state of the current express order, the order data is written in by two parts, the pressure of repeated writing is shared, and the possibility of error occurrence is reduced.
Fig. 6 and 7 describe the express order updating apparatus in the embodiment of the present invention in detail from the perspective of the modular functional entity, and the express order updating device in the embodiment of the present invention is described in detail from the perspective of hardware processing.
Fig. 8 is a schematic structural diagram of an express order updating apparatus according to an embodiment of the present invention, where the express order updating apparatus 800 may generate relatively large differences due to different configurations or performances, and may include one or more processors (CPUs) 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 an application 833 or data 832. Memory 720 and storage medium 830 may be, among other things, transient storage or persistent storage. The program stored on the storage medium 830 may include one or more modules (not shown), each of which may include a series of instructional operations on the dispatch order update apparatus 800. Still further, the processor 810 may be configured to communicate with the storage medium 830 to execute a series of instructional operations on the storage medium 830 on the dispatch order updating device 500.
The quick 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 Server, Mac OS X, Unix, Linux, FreeBSD, etc. Those skilled in the art will appreciate that the configuration of the order update facility shown in FIG. 8 does not constitute a limitation of the order update facility, and may include more or fewer components than those shown, or some components in combination, 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, and which may also be a volatile computer readable storage medium, having stored therein instructions, which, when executed on a computer, cause the computer to perform the steps of the express order update method.
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.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
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 (10)
1. An express order updating method, characterized in that the express order updating method comprises:
acquiring order data of each express order generated by a front end every preset order updating time;
generating a blank CSV file corresponding to the order update, 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 disc;
reading the order data in the CSV file from the network additional storage disk;
and updating the read order data into an order source file in a back-end database.
2. An express order updating method as claimed in claim 1, wherein the order data comprises: the order state and the order attribute value, different express orders are distinguished through the unique key attribute value of the order, and the order updating comprises the following steps: order status update and order attribute value update, wherein the order source file comprises: the order state source file and the order attribute value source file.
3. The method for updating an express order according to claim 2, wherein the generating a blank CSV file corresponding to the current order update, and writing the order data into the CSV file and then storing the order data into a network attached storage disk according to the generation sequence of each express order comprises:
generating a blank CSV file corresponding to the order update, 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 and storing the CSV file and the identification file into a network additional storage disk, wherein the order state and the order attribute value are respectively stored into different CSV files.
4. An express order updating method as claimed in claim 3, wherein the reading the order data in the CSV file from the network attached storage disk comprises:
judging whether the identification file exists in the network attachment storage disk or not;
and if so, reading the order state or the order attribute value in the CSV file corresponding to the identification file.
5. An update method for an order for express mail as in claim 4 wherein said updating the read order data into an order source file in a back end database comprises:
traversing the order attribute value source file by taking the unique key attribute value in the read order attribute values as a key word, and outputting a traversal result corresponding to each express order;
if the traversal result is null, writing the read order attribute value into the order attribute value source file;
and if the traversal result is not null, updating the order attribute value source file with the read order attribute value to replace the historical order attribute value in the order attribute value source file.
6. An update method for an order for express mail as in claim 4 wherein said updating the read order data into an order source file in a back end database comprises:
traversing the order state source file by taking the read order state as a keyword, and outputting a traversal result corresponding to each express order;
and if the traversal result is null, writing the read order state into the order state source file.
7. An express order updating method as claimed in any one of claims 1-6, further comprising, after said updating of said 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 the report field values;
generating a corresponding blank order form according to the form configuration information;
and reading corresponding order data from the order source file and writing the order data into the order report according to the report field of the order report and the statistical rule.
8. An express order updating apparatus, comprising:
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 order update, 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 disc;
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. An express order updating apparatus, characterized by comprising: a memory having instructions stored therein and at least one processor, the memory and the at least one processor interconnected by a line;
the at least one processor invokes the instructions in the memory to cause the dispatch order update apparatus to perform the dispatch order update method of any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method for updating an order for express mail according to any one of claims 1 to 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 true CN111242751A (en) | 2020-06-05 |
| CN111242751B 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) |
Cited By (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 |
| CN113807923A (en) * | 2021-09-23 | 2021-12-17 | 杭州右文网络科技有限公司 | Order processing method and device, electronic equipment and readable storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150081485A1 (en) * | 2013-09-13 | 2015-03-19 | Mace Engineering Group Pty Ltd. | Sales Order Data Collection And Management System |
| WO2015081815A1 (en) * | 2013-12-05 | 2015-06-11 | 北京奇虎科技有限公司 | Logistics status information monitoring method, device, and system |
| CN106327306A (en) * | 2016-08-29 | 2017-01-11 | 东莞市浩云网迅供应链服务有限公司 | Order lifecycle presentation method and system |
| CN108038767A (en) * | 2017-12-26 | 2018-05-15 | 广州供电局有限公司 | Electric business order asynchronous distribution system and method based on message queue |
| CN109828964A (en) * | 2019-02-19 | 2019-05-31 | 北京奇艺世纪科技有限公司 | A kind of data lead-in method, device and electronic equipment |
| CN110020925A (en) * | 2019-04-15 | 2019-07-16 | 北京闪送科技有限公司 | Order processing method, apparatus, equipment and storage medium |
| CN110309206A (en) * | 2019-07-10 | 2019-10-08 | 中国联合网络通信集团有限公司 | Order information acquisition method and system |
| CN110377666A (en) * | 2019-07-26 | 2019-10-25 | 浪潮软件股份有限公司 | Based on the synchronous method of data between CMSP message-oriented middleware progress different source data library |
| CN110674109A (en) * | 2019-09-06 | 2020-01-10 | 中国平安财产保险股份有限公司 | Data import method, system, computer device and computer readable storage medium |
-
2020
- 2020-03-11 CN CN202010164818.2A patent/CN111242751B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150081485A1 (en) * | 2013-09-13 | 2015-03-19 | Mace Engineering Group Pty Ltd. | Sales Order Data Collection And Management System |
| WO2015081815A1 (en) * | 2013-12-05 | 2015-06-11 | 北京奇虎科技有限公司 | Logistics status information monitoring method, device, and system |
| CN106327306A (en) * | 2016-08-29 | 2017-01-11 | 东莞市浩云网迅供应链服务有限公司 | Order lifecycle presentation method and system |
| CN108038767A (en) * | 2017-12-26 | 2018-05-15 | 广州供电局有限公司 | Electric business order asynchronous distribution system and method based on message queue |
| CN109828964A (en) * | 2019-02-19 | 2019-05-31 | 北京奇艺世纪科技有限公司 | A kind of data lead-in method, device and electronic equipment |
| CN110020925A (en) * | 2019-04-15 | 2019-07-16 | 北京闪送科技有限公司 | Order processing method, apparatus, equipment and storage medium |
| CN110309206A (en) * | 2019-07-10 | 2019-10-08 | 中国联合网络通信集团有限公司 | Order information acquisition method and system |
| CN110377666A (en) * | 2019-07-26 | 2019-10-25 | 浪潮软件股份有限公司 | Based on the synchronous method of data between CMSP message-oriented middleware progress different source data library |
| CN110674109A (en) * | 2019-09-06 | 2020-01-10 | 中国平安财产保险股份有限公司 | Data import method, system, computer device and computer readable storage medium |
Cited By (3)
| 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 |
| CN113807923A (en) * | 2021-09-23 | 2021-12-17 | 杭州右文网络科技有限公司 | Order processing method and device, electronic equipment and readable storage medium |
| CN113807923B (en) * | 2021-09-23 | 2024-02-09 | 杭州右文网络科技有限公司 | Order processing method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111242751B (en) | 2023-08-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200218737A1 (en) | Method, system and program product for matching of transaction records | |
| US7305404B2 (en) | Data structure and management system for a superset of relational databases | |
| US7848970B2 (en) | System and method for synchronizing ledger accounts by company group | |
| US20080301042A1 (en) | System and method for categorizing credit card transaction data | |
| US20090013106A1 (en) | Flexible and error resistant data buffering and connectivity | |
| US7493323B2 (en) | Document group analyzing apparatus, a document group analyzing method, a document group analyzing system, a program, and a recording medium | |
| US20070239742A1 (en) | Determining data elements in heterogeneous schema definitions for possible mapping | |
| CN108647357B (en) | Data query method and device | |
| US20190130050A1 (en) | Dynamically generating normalized master data | |
| TWI453608B (en) | System and method for managing a large number of multiple data | |
| CN111242751B (en) | Express order updating method, device, equipment and storage medium | |
| CN114253939A (en) | Data model construction method and device, electronic equipment and storage medium | |
| CN108304291B (en) | Test input information retrieval apparatus and method | |
| CN111159230A (en) | Data resource map construction method and device, storage medium and terminal | |
| JP6160503B2 (en) | Information input system and program | |
| CN111190923A (en) | Electronic bill query method and device, storage medium and electronic equipment | |
| CN110147396B (en) | Mapping relation generation method and device | |
| US11556523B2 (en) | Calculating order dependency in configuration activation for complex scenarios | |
| CN115114297A (en) | Data lightweight storage and search method and device, electronic equipment and storage medium | |
| CN114416848A (en) | Data blood relationship processing method and device based on data warehouse | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| CN109492006B (en) | Mass data processing method and device based on Oracle | |
| CN112632115A (en) | BI-based data query method and system | |
| JP2017167843A (en) | Transaction detail management system and transaction detail management method | |
| US11551464B2 (en) | Line based matching of documents |
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 |