CN107679822B - Automatic updating method of order state in ERP system, storage medium and computer equipment - Google Patents
Automatic updating method of order state in ERP system, storage medium and computer equipment Download PDFInfo
- Publication number
- CN107679822B CN107679822B CN201710787543.6A CN201710787543A CN107679822B CN 107679822 B CN107679822 B CN 107679822B CN 201710787543 A CN201710787543 A CN 201710787543A CN 107679822 B CN107679822 B CN 107679822B
- Authority
- CN
- China
- Prior art keywords
- order data
- order
- uploading
- uploaded
- server
- 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
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Marketing (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method, a device, a storage medium and computer equipment for automatically updating order states in an ERP system. And acquiring order data to be uploaded, and batching the order data to be uploaded. And starting the task queue, and inserting the batched order data into the task queue according to batches, so that the order data do not need to be uploaded by a single order, network energy consumption is reduced, and efficiency is improved. And uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform. And a multithreading mode is adopted to upload a batch of order data in the task queue in batches, so that network transmission is reduced, and the utilization rate of hardware resources is improved. And obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state in the ERP system according to the uploading result. Therefore, a user can inquire the order state in real time through the ERP system.
Description
Technical Field
The invention relates to the technical field of computers, in particular to an automatic updating method of order states in an ERP system, a storage medium and computer equipment.
Background
Currently, an ERP (enterprise resource planning) system includes various business functions such as finance, supply chain and manufacturing. Each service function has a large amount of data to process. For example, in a conventional e-commerce transaction, a buyer places an order on an e-commerce platform, a seller downloads the order to an ERP client for order processing, and the ERP client uploads the processed order to the e-commerce platform as a single order. The traditional mode can only finish uploading one order at a time, obviously, the mode is too inefficient, and during the period of the promotion activity of the e-commerce, a large number of orders suddenly and rapidly increase, and the requirement of a customer cannot be met at all only by uploading order information by a single order.
Disclosure of Invention
In view of the foregoing, it is necessary to provide a method, an apparatus, a storage medium, and a computer device for automatically updating an order status in an ERP system.
A method for automatically updating order status in an ERP system comprises the following steps:
acquiring order data to be uploaded;
batching the order data to be uploaded;
starting a task queue, and inserting the batched order data into the task queue according to batches;
uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform;
and acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
In one embodiment, the obtaining order data to be uploaded includes:
screening order data to be uploaded according to preset screening conditions at a preset time origin, and acquiring screened order data as a first batch of order data to be uploaded;
after a first preset time period, screening the order data to be uploaded generated in the first preset time period and the order data with the first uploading result as failure according to preset screening conditions, and acquiring the screened order data as a second order data to be uploaded;
and repeatedly screening the order data to be uploaded generated in the preset time period and the order data with the previous batch of uploading results as failures according to preset screening conditions after the next first preset time period, acquiring the order data passing the screening as the order data of the current batch to be uploaded, and uploading all the order data with the uploading results as failures from the preset time origin to the second preset time period until the second preset time period is reached.
In one embodiment, the batching the order data to be uploaded includes:
and batching the order data to be uploaded according to a preset quantity threshold value.
In one embodiment, the obtaining, by the server, an upload result of the order data from a third party platform and automatically updating an order state in the ERP system according to the upload result includes:
and acquiring an uploading result of the order data from the third-party platform through the server, and automatically updating the order state on an order state expansion table in the ERP system according to the uploading result, wherein the order state expansion table is obtained by vertically partitioning the order service table in advance through a database.
An ERP system, the system comprising: a client and a server:
the client is used for acquiring order data to be uploaded; batching the order data to be uploaded; starting a task queue, and inserting the batched order data into the task queue according to batches; uploading the order data in the task queue to a server in batches in a multithreading mode; and acquiring an uploading result of the order data from a third-party platform through the server and automatically updating the order state in the client according to the uploading result.
The server is used for receiving the order data uploaded by the client and uploading the order data to a third-party platform in batches in a multithreading mode; and acquiring an uploading result of the order data from a third-party platform, and forwarding the uploading result to the client.
In one embodiment, the client is further configured to obtain an uploading result of the order data from the third-party platform through the server, and automatically update an order state on an order state expansion table in an ERP system according to the uploading result, where the order state expansion table is obtained by performing vertical database partitioning on the order service table in advance.
An automatic updating device for order status in an ERP system, comprising:
the to-be-uploaded order data acquisition module is used for acquiring the to-be-uploaded order data;
the batching module is used for batching the order data to be uploaded;
the task queue inserting module is used for starting a task queue and inserting the batched order data into the task queue according to batches;
the multithreading module is used for uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform;
and the automatic updating module is used for acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
In one embodiment, the automatic updating module is further configured to obtain an uploading result of the order data from the third party platform through the server, and automatically update an order state on an order state expansion table in an ERP system according to the uploading result, where the order state expansion table is a table obtained by vertically partitioning the order service table in a database in advance.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring order data to be uploaded;
batching the order data to be uploaded;
starting a task queue, and inserting the batched order data into the task queue according to batches;
uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform;
and acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring order data to be uploaded;
batching the order data to be uploaded;
starting a task queue, and inserting the batched order data into the task queue according to batches;
uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform;
and acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
The method, the device, the storage medium and the computer equipment for automatically updating the order state in the ERP system acquire the order data to be uploaded and batch the order data to be uploaded. And then starting a task queue, and inserting the batched order data into the task queue according to the batches. Order data do not need to be uploaded by a single order, network energy consumption is reduced, and efficiency is improved. And uploading the order data in the task queue to a server in batches in a multithreading mode, and uploading the order data to a third-party platform by the server. And a multithreading mode is adopted to upload a batch of order data in the task queue in batches, so that network transmission is reduced, and the utilization rate of hardware resources is improved. And finally, obtaining an uploading result of the order data from the third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result. The active acquisition is not needed manually, so that the labor cost is reduced. Therefore, a user can inquire the order state in real time through the ERP system.
Drawings
FIG. 1 is a diagram of an exemplary implementation of a method for automatically updating order status in an ERP system;
FIG. 2 is an internal block diagram of a server in one embodiment;
FIG. 3 is a flow diagram of a method for automatically updating order status in an ERP system, according to one embodiment;
FIG. 4 is a flowchart of a method for obtaining order data to be uploaded in FIG. 3;
FIG. 5 is a schematic diagram of the ERP system interacting with a third party platform;
FIG. 6 is a schematic structural diagram of an automatic order status update apparatus in the ERP system in one embodiment;
fig. 7 is a schematic structural diagram of the to-be-uploaded order data acquisition module in fig. 6.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in detail below. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein, but rather should be construed as broadly as the present invention is capable of modification in various respects, all without departing from the spirit and scope of the present invention.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The method for automatically updating the order status in the ERP system provided by the embodiment of the invention can be applied to the environment shown in fig. 1. Referring to fig. 1, an ERP system client is run on a terminal 110, a server 120 is an ERP system server, and a third party platform is run on a terminal 130. The terminal 110, the server 120, and the terminal 130 are directly connected through a network. For example, the third party platform may be a third party e-commerce platform, a website for e-commerce transactions in Taobao, Kyoto, Sunning, the United states, and so on. Of course, other web sites for conducting e-commerce transactions are also included.
In an embodiment, as shown in fig. 2, there is further provided a server, where the server includes a processor, a nonvolatile storage medium, an internal memory, and a network interface, which are connected through a system bus, where the nonvolatile storage medium stores therein an operating system and an automatic order status updating apparatus in an ERP system, and the automatic order status updating apparatus in the ERP system is configured to execute an automatic order status updating method in the ERP system. The processor is used for improving the calculation and control capacity and supporting the operation of the whole server. The internal memory is used for providing an environment for the operation of an order status automatic updating device in an ERP system in a non-volatile storage medium, and the internal memory can store computer readable instructions, and when the computer readable instructions are executed by a processor, the processor can be used for executing an order status automatic updating method in the ERP system. The network interface is used for performing network communication with the third-party platform, for example, sending order data to the third-party platform or receiving order uploading status data returned by the third-party platform.
In an embodiment, as shown in fig. 3, an automatic order status updating method in an ERP system is provided, which is described by taking the application of the method to the ERP system client running on the terminal 110 in fig. 1 as an example, and includes:
step 310, obtaining order data to be uploaded.
When the buyer places an order on the E-commerce platform, the seller downloads the order at the client of the ERP system for order processing. Specifically, the ERP system client may call a communication interface with the e-commerce platform, so as to obtain and process order data. For example, the processing may be adding logistics information to the order placed by the customer, or the like. The order data to be uploaded is order data obtained after corresponding processing is carried out and screening is carried out according to preset screening conditions. The same order is generally set with 3 uploading opportunities to ensure that each order is uploaded to the maximum extent, and of course, other numbers of uploading opportunities can be set.
In step 320, the order data to be uploaded is batched.
Specifically, the ERP system client screens the processed order data, and batches the screened order data to be uploaded according to a preset quantity threshold.
Step 330, starting a task queue, and inserting the batched order data into the task queue according to the batches.
And starting a task queue by the client, and inserting the order data obtained after batching according to a preset quantity threshold into the task queue according to batches, namely, the order data in one batch is a task. A batch of order data corresponds to one task, and the tasks are sequentially inserted into the task queue.
And 340, uploading the order data in the task queue to a server in batches in a multithreading mode, so that the server uploads the order data to a third-party platform.
The client opens a plurality of threads according to the set thread number to simultaneously execute a plurality of tasks, and uploads the tasks in the task queue to the server in batch. The server then uploads the order data in each task to the third party platform.
And 350, acquiring an uploading result of the order data from the third-party platform through the server, and automatically updating the order state in the ERP system according to the uploading result.
After the server uploads the order data in each task to the third-party platform, the uploading of the order data (logistics information) is successful, the uploading result is successful, and after the uploading is successful, the third-party platform changes the order state from the order placement state to the delivery state. If the server fails in the process of uploading the order data in each task to the third-party platform, namely the third-party platform does not receive the order data, the order data uploading is failed, and the uploading result is failed. After the third-party platform updates the uploading result, the server acquires the uploading result from the third-party platform and then sends the uploading result to the client. And then, automatically updating the order state in the client of the ERP system according to the uploading result, namely reversely writing the order uploading result to an order business table if the order uploading result is successful or failed. The updating is automatically carried out, and manual active acquisition is not needed, so that the labor cost is reduced. Some condition may be set to trigger automatic updating, for example, setting a specific time interval. The order business table on the ERP system client accounts various detailed information about each order. The user of the ERP system client, namely the seller can inquire the latest uploading state of each order in the order business table in real time.
In this embodiment, order data to be uploaded is acquired, and the order data to be uploaded is batched. And then starting a task queue, and inserting the batched order data into the task queue according to the batches. Order data do not need to be uploaded by a single order, network energy consumption is reduced, and efficiency is improved. And uploading the order data in the task queue to a server in batches in a multithreading mode, and uploading the order data to a third-party platform by the server. And a multithreading mode is adopted to upload a batch of order data in the task queue in batches, so that network transmission is reduced, and the utilization rate of hardware resources is improved. And finally, obtaining an uploading result of the order data from the third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result. The active acquisition is not needed manually, so that the labor cost is reduced. Therefore, a user can inquire the order state in real time through the ERP system.
In one embodiment, as shown in fig. 4, obtaining order data to be uploaded comprises:
and step 312, screening the order data to be uploaded according to the preset screening conditions at the preset time origin, and acquiring the screened order data as the first batch of order data to be uploaded.
When the buyer places an order on the E-commerce platform, the seller downloads the order at the client of the ERP system for order processing. And setting a time origin for the ERP system, and screening all processed orders at the time origin according to preset screening conditions. Specifically, the time origin may be 0 minutes, and the filtering condition may be orders that have been placed and not uploaded, orders that have been picked (typically, after a pick check of the system) and not uploaded, orders that have been weighed and not uploaded, orders that have been placed (typically, after a generated sales shipment) and not uploaded, and so on. One prerequisite that the above conditions must satisfy is that: the order has printed the logistics list, that is, the order without printed logistics list will not be uploaded automatically in the system. And taking the order data meeting the screening condition as the first batch of order data to be uploaded to the server for uploading.
And step 314, after the first preset time period, screening the order data to be uploaded generated in the first preset time period and the order data with the first uploading result being failed according to preset screening conditions, and acquiring the order data passing the screening as second order data to be uploaded.
Specifically, the first preset time period may be 5 minutes or 10 minutes, but may be set to other values. For example, in the embodiment of the present invention, a first preset time period is taken as 5 minutes, after 5 minutes from the time origin, order data newly generated within 5 minutes of the first preset time period is first obtained, the order data is processed (for example, logistics information is added), screening is performed according to a screening condition, and then order data which fails in the first uploading is obtained. And forming a second batch of order data to be uploaded by the screened order data and the order data which fails to be uploaded for the first time together, and uploading the second batch of order data to be uploaded. Specifically, the order data which fails to be uploaded for the first time is obtained by querying an order service table on the client of the ERP system.
And step 316, repeatedly screening the order data to be uploaded and the previous batch of order data with failed uploading results generated in the preset time period according to preset screening conditions after the next first preset time period, acquiring the screened order data as the order data to be uploaded in the current batch, and uploading all the order data with failed uploading results from the preset time origin to the second preset time period until the second preset time period is reached.
After the second uploading, uploading the order data screened in the first preset time period every other first preset time period. Specifically, at the 10 th minute, order data newly generated between 5 minutes and 10 minutes in the first preset time period is acquired, the order data is processed (for example, logistics information is added), and then order data which fails to be uploaded for the second time is acquired. And forming a third batch of order data to be uploaded by the order data screened this time and the order data failed to be uploaded for the second time together, and uploading the third batch of order data to be uploaded. Specifically, the order data which fails to be uploaded for the second time is obtained by querying an order service table on the client of the ERP system. And uploading the order data screened in the first preset time period every other first preset time period until the second preset time period is reached. And at the time of reaching the second preset time period, acquiring all the order data with the uploading result of failure from the time origin to the second preset time period, wherein the order data with the uploading result of failure at the time of the second preset time period also includes the order data with the uploading result of failure at the time of the second preset time period. And uploading the orders which fail to be uploaded at the moment of a second preset time period in a unified way. Therefore, there are 3 uploading opportunities for each screened order that satisfies the conditions. If the order is not uploaded for 3 times successfully, the order is indicated to have some problems, and the order needs to be fed back to the seller to be processed by the seller.
Specifically, the second preset time period may be a double integer, i.e., 2 hours, 4 hours, 6 hours, and so on in the embodiment of the present invention. Of course, other times may be set. For example, if the time origin is 0 minute, the order data is uploaded every 5 minutes, and when 2 hours arrive, the uploading is performed first. All orders that failed the upload from 0 minutes to 2 hours (including 2 hours) were then consolidated for upload.
In this embodiment, each screened order meeting the conditions has 3 uploading opportunities, so that it is basically ensured that any order data meeting the screening conditions will not be missed. The 3 times of uploading respectively includes that when the order is screened for the first time at the time origin, the order which fails to be uploaded at the previous time is obtained for uploading again at the next time of uploading next time, and the third time is that when a second longer preset time period is reached, all the orders which fail to be uploaded from the time origin to the second preset time period are uploaded uniformly. If the order is not uploaded for 3 times successfully, the order is indicated to have some problems, and the order needs to be fed back to the seller to be processed by the seller.
In one embodiment, batching order data to be uploaded comprises: and batching the order data to be uploaded according to a preset quantity threshold value.
In this embodiment, all the order data that meets the conditions screened this time are used as the order data to be uploaded this time. And batching the order data to be uploaded according to a preset quantity threshold value. The preset number threshold may be set according to a network condition or the like. Specifically, a batch may be set to 100 orders, but may be set to other values. For example, if the order data to be uploaded at this time is 1000, the order data is batched into 10 batches according to 100 batches. A batch of order data corresponds to one task, and the tasks are sequentially inserted into the task queue.
In one embodiment, the obtaining, by the server, an upload result of the order data from the third-party platform and automatically updating the order status in the ERP system according to the upload result includes: and obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state on an order state expansion table in the ERP system according to the uploading result, wherein the order state expansion table is a table obtained by vertically partitioning the order service table in advance through a database.
And uploading the order information to a server of the ERP system at a client of the ERP system, and then uploading the order information to a third-party platform by the server, wherein the uploading result is successful, and otherwise, the uploading result is failed. And a client of the ERP system indirectly obtains an uploading result from a third-party platform through a server. And then, automatically updating the order state on the order state expansion table on the client of the ERP system according to the latest uploading result. The order business table on the client of the ERP system counts various detailed information about each order. The user of the ERP system client, namely the seller can inquire the latest uploading state of each order in the order business table in real time. The order business table in the ERP is designed to be redundant, even more than 100 fields can exist in the fields on the order business table, if the order data volume of a client is huge, database deadlock often occurs when an uploading state obtained from a third-party platform is rewritten to the order business table, rewriting failure is caused, and finally, the business of the client is abnormal. If such anomalies occur frequently, they are complained and, if severe, can lead to customer churn. Therefore, the order service table is vertically partitioned in advance by adopting a database vertical partitioning method, specifically, related fields can be separated according to service scenes, and an extended table relative to a main table, such as an order state extended table, is independently formed and is specially used for recording whether an order is successfully uploaded to a third-party platform; and the logistics information expansion table is specially used for recording the logistics information of the order. The separated expansion tables and the order business table are mutually associated and are associated through the main key.
Thus, when a plurality of users operate the same order in the order business table at the same time, the traditional method is that the first user obtains the lock of the order during the operation of the order in the order business table, so that other people cannot operate the order at the same time. Other users can only operate on the order after the user has completed the operation by obtaining the lock. After the vertical partition is performed, the same order can be operated by multiple users at the same time, specifically, only the operation needs to be performed in the extension table corresponding to the order, and all the users do not need to call the order service table for operation, so that the database deadlock cannot be caused. For example, the user who modifies the order uploading state only needs to operate in the order state expansion table, and the user who modifies the logistics information only needs to operate in the logistics information expansion table, and the users do not affect each other. Because the separated expansion table is associated with the order business table, the user can obtain the logistics information or the order state in real time by inquiring the order business table.
In this embodiment, the order service table is vertically partitioned in advance by using a database vertical partitioning method, so that multiple users can simultaneously operate the same order, specifically, only the operation needs to be performed in the extension table corresponding to the order, and all users do not need to call the order service table for operation, so that the database deadlock is not caused. Because the separated expansion table is associated with the order business table, the user can obtain the logistics information or the order state in real time by inquiring the order business table.
In one embodiment, a method for automatically updating an order status in an ERP system is further provided, where the method includes: and the server receives the order data uploaded by the client and uploads the order data to a third-party platform in batches in a multithreading mode.
In this embodiment, after receiving the order data from the ERP client, the ERP server uploads the order data to the third-party platform in batch in a multithreading manner. Specifically, a plurality of threads can be started simultaneously, and then the order data can be uploaded simultaneously. Network transmission is reduced, and the utilization rate of hardware resources is improved.
In one embodiment, an ERP system is provided, the method being illustrated as applied to an environment such as that shown in FIG. 1. As shown in fig. 5, the ERP system includes: client 510 and server 520:
a client 510, configured to obtain order data to be uploaded; batching order data to be uploaded; starting a task queue, and inserting the batched order data into the task queue according to batches; uploading order data in the task queue to a server in batches in a multithreading mode; and obtaining an uploading result of the order data from the third-party platform through the server and automatically updating the order state in the client according to the uploading result.
The server 520 is used for receiving the order data uploaded by the client and uploading the order data to a third-party platform in batches in a multithreading mode; and obtaining an uploading result of the order data from the third-party platform, and forwarding the uploading result to the client.
The upload logic from the ERP client to the ERP server to the e-commerce platform is depicted in fig. 5. The client side mainly utilizes multithreading to simultaneously execute a plurality of distributed uploading tasks, each uploading task has at most 100 orders, the orders are packed once and transmitted to the server side, the network cost of the back-and-forth transmission of the client side and the server side is saved, and the multithreading is also utilized to call an E-commerce platform interface for uploading after the server side organizes messages according to the platform again. After the uploading is successful, the third-party platform feeds the uploading result back to the ERP server, and the ERP server feeds the uploading result back to the ERP client. And the ERP client receives the uploading result and analyzes the message, and the uploading result is rewritten to a database on the ERP client.
In this embodiment, the ERP system client may invoke a communication interface with the e-commerce platform, so as to obtain and process the order data. And screening the processed order data, and batching the order data to be uploaded screened this time according to a preset quantity threshold value. And starting a task queue, and inserting the order data obtained after batching according to a preset quantity threshold value into the task queue according to batches, namely, the order data in one batch is a task. A batch of order data corresponds to one task, and the tasks are sequentially inserted into the task queue. And starting a plurality of threads according to the set thread number to simultaneously execute a plurality of tasks, and uploading the tasks in the task queue to the server in batch. The server then uploads the order data in each task to the third party platform.
After the server uploads the order data in each task to the third-party platform, the uploading of the order data (logistics information) is successful, the uploading result is successful, and after the uploading is successful, the third-party platform changes the order state from the order placement state to the delivery state. If the server fails in the process of uploading the order data in each task to the third-party platform, namely the third-party platform does not receive the order data, the order data uploading is failed, and the uploading result is failed. And then, automatically updating the order state in the client of the ERP system according to the uploading result, namely reversely writing the order uploading result to an order business table if the order uploading result is successful or failed. The updating is automatically carried out, and manual active acquisition is not needed, so that the labor cost is reduced.
In an embodiment, the client 510 is further configured to obtain an uploading result of the order data from the third party platform through the server 520, and automatically update the order status on an order status expansion table in the ERP system according to the uploading result, where the order status expansion table is a table obtained by vertically partitioning a database of an order service table in advance.
In this embodiment, the order service table is vertically partitioned in advance by using a database vertical partitioning method, so that multiple users can simultaneously operate the same order, specifically, only the operation needs to be performed in the extension table corresponding to the order, and all users do not need to call the order service table for operation, so that the database deadlock is not caused.
In one embodiment, as shown in fig. 6, there is further provided an automatic order status updating apparatus 600 in an ERP system, the apparatus including: a pending upload order data acquisition module 610, a batching module 620, a task queue insertion module 630, a multithreading module 640, and an automatic update module 650.
And an order data to be uploaded acquiring module 610, configured to acquire order data to be uploaded.
And a batching module 620 for batching the order data to be uploaded.
And a task queue inserting module 630, configured to start a task queue, and insert the batched order data into the task queue according to the batch.
And the multithreading module 640 is configured to upload the order data in the task queue to the server in batch in a multithreading manner, so that the server uploads the order data to the third-party platform.
And the automatic updating module 650 is configured to obtain an uploading result of the order data from the third-party platform through the server, and automatically update the order status in the ERP system according to the uploading result.
In one embodiment, as shown in fig. 7, the to-be-uploaded order data acquisition module 610 includes: a first to-be-uploaded order data module 612, a second to-be-uploaded order data module 614, and a repeat module 616.
The first to-be-uploaded order data module 612 is configured to screen, at a preset time origin, order data to be uploaded according to preset screening conditions, and obtain screened order data as the first to-be-uploaded order data.
And a second to-be-uploaded order data module 614, configured to, after the first preset time period, screen, according to preset screening conditions, order data to be uploaded and order data of which the first upload result is a failure, which are generated within the first preset time period, and obtain order data that passes the screening as second to-be-uploaded order data.
And a repeating module 616, configured to repeatedly perform, after a next first preset time period, screening, according to preset screening conditions, order data to be uploaded and order data of which a previous batch of uploading results are failed, which are generated within the preset time period, and acquiring the screened order data as the order data of a current batch to be uploaded, until a second preset time period is reached, and uploading all the order data of which the uploading results are failed, which are from the preset time origin to the second preset time period.
In one embodiment, the batching module 620 is further configured to batch the order data to be uploaded according to a preset quantity threshold.
In an embodiment, the automatic updating module 650 is further configured to obtain an uploading result of the order data from the third party platform through the server, and automatically update the order status on an order status expansion table in the ERP system according to the uploading result, where the order status expansion table is a table obtained by vertically partitioning a database of an order business table in advance.
In one embodiment, there is also provided a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
acquiring order data to be uploaded; batching order data to be uploaded; starting a task queue, and inserting the batched order data into the task queue according to batches; uploading order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform; and obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state in the ERP system according to the uploading result.
In one embodiment, the program further implements the following steps when executed by the processor: screening order data to be uploaded according to preset screening conditions at a preset time origin, and acquiring screened order data as a first batch of order data to be uploaded; after a first preset time period, screening the order data to be uploaded generated in the first preset time period and the order data with the first uploading result as failure according to preset screening conditions, and acquiring the order data passing the screening as second order data to be uploaded; and repeatedly screening the order data to be uploaded generated in the preset time period and the order data with the previous batch of uploading results as failures according to preset screening conditions after the next first preset time period, acquiring the screened order data as the order data to be uploaded in the current batch, and uploading all the order data with the uploading results as failures from the preset time origin to the second preset time period until the second preset time period is reached.
In one embodiment, the program further implements the following steps when executed by the processor: and batching the order data to be uploaded according to a preset quantity threshold value.
In one embodiment, the program further implements the following steps when executed by the processor: and obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state on an order state expansion table in the ERP system according to the uploading result, wherein the order state expansion table is a table obtained by vertically partitioning the order service table in advance through a database.
In one embodiment, the program further implements the following steps when executed by the processor: and the server receives the order data uploaded by the client and uploads the order data to a third-party platform in batches in a multithreading mode.
In one embodiment, there is also provided a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring order data to be uploaded; batching order data to be uploaded; starting a task queue, and inserting the batched order data into the task queue according to batches; uploading order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform; and obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state in the ERP system according to the uploading result.
In one embodiment, the processor further implements the following steps when executing the computer program: screening order data to be uploaded according to preset screening conditions at a preset time origin, and acquiring screened order data as a first batch of order data to be uploaded; after a first preset time period, screening the order data to be uploaded generated in the first preset time period and the order data with the first uploading result as failure according to preset screening conditions, and acquiring the order data passing the screening as second order data to be uploaded; and repeatedly screening the order data to be uploaded generated in the preset time period and the order data with the previous batch of uploading results as failures according to preset screening conditions after the next first preset time period, acquiring the screened order data as the order data to be uploaded in the current batch, and uploading all the order data with the uploading results as failures from the preset time origin to the second preset time period until the second preset time period is reached.
In one embodiment, the processor further implements the following steps when executing the computer program: and batching the order data to be uploaded according to a preset quantity threshold value.
In one embodiment, the processor further implements the following steps when executing the computer program: and obtaining an uploading result of the order data from the third-party platform through the server, and automatically updating the order state on an order state expansion table in the ERP system according to the uploading result, wherein the order state expansion table is a table obtained by vertically partitioning the order service table in advance through a database.
In one embodiment, the processor further implements the following steps when executing the computer program: and the server receives the order data uploaded by the client and uploads the order data to a third-party platform in batches in a multithreading mode.
It will be understood by those skilled in the art that all or part of the processes in the methods of the embodiments described above may be implemented by hardware related to instructions of a computer program, and the program may be stored in a non-volatile computer readable storage medium, and in the embodiments of the present invention, the program may be stored in a storage medium of a computer system and executed by at least one processor in the computer system, so as to implement the processes including the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for automatically updating order status in an ERP system comprises the following steps:
acquiring order data to be uploaded in an ERP system; the order data to be uploaded is determined after being screened by preset screening conditions, and the screening conditions are set on the premise that the logistics list is printed;
batching the order data to be uploaded;
starting a task queue, and inserting the batched order data into the task queue according to batches; wherein, the order data of a batch is a task;
uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform; the batch uploading to the server in a multithreading mode comprises the following steps: starting a plurality of threads according to the set thread number to simultaneously execute a plurality of tasks, and uploading the tasks in the task queue to a server in batch;
and acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
2. The method of claim 1, wherein the obtaining order data to be uploaded comprises:
screening order data to be uploaded according to preset screening conditions at a preset time origin, and acquiring screened order data as a first batch of order data to be uploaded;
after a first preset time period, screening the order data to be uploaded generated in the first preset time period and the order data with the first uploading result as failure according to preset screening conditions, and acquiring the screened order data as a second order data to be uploaded;
and repeatedly screening the order data to be uploaded generated in the preset time period and the order data with the previous batch of uploading results as failures according to preset screening conditions after the next first preset time period, acquiring the order data passing the screening as the order data of the current batch to be uploaded, and uploading all the order data with the uploading results as failures from the preset time origin to the second preset time period until the second preset time period is reached.
3. The method of claim 1, wherein batching the order data to be uploaded comprises:
and batching the order data to be uploaded according to a preset quantity threshold value.
4. The method according to claim 1, wherein the obtaining, by the server, the uploading result of the order data from a third party platform and automatically updating the order status in the ERP system according to the uploading result comprises:
and acquiring an uploading result of the order data from the third-party platform through the server, and automatically updating the order state on an order state expansion table in the ERP system according to the uploading result, wherein the order state expansion table is obtained by vertically partitioning the order service table in advance through a database.
5. An ERP system, characterized in that the system comprises: a client and a server:
the client is used for acquiring order data to be uploaded in the ERP system; the order data to be uploaded is determined after being screened by preset screening conditions, and the screening conditions are set on the premise that the logistics list is printed; batching the order data to be uploaded; starting a task queue, and inserting the batched order data into the task queue according to batches; wherein, the order data of a batch is a task; uploading the order data in the task queue to a server in batches in a multithreading mode; the batch uploading to the server in a multithreading mode comprises the following steps: starting a plurality of threads according to the set thread number to simultaneously execute a plurality of tasks, and uploading the tasks in the task queue to a server in batch; acquiring an uploading result of the order data from a third-party platform through a server and automatically updating the order state in the client according to the uploading result;
the server is used for receiving the order data uploaded by the client and uploading the order data to a third-party platform in batches in a multithreading mode; and acquiring an uploading result of the order data from a third-party platform, and forwarding the uploading result to the client.
6. The system according to claim 5, wherein the client is further configured to obtain an uploading result of the order data from the third party platform through the server, and automatically update an order status on an order status expansion table in an ERP system according to the uploading result, where the order status expansion table is a table obtained by vertically partitioning the order service table in advance in a database.
7. An automatic updating device for order status in an ERP system, which is characterized in that the device comprises:
the order data to be uploaded acquiring module is used for acquiring order data to be uploaded in the ERP system; the order data to be uploaded is determined after being screened by preset screening conditions, and the screening conditions are set on the premise that the logistics list is printed;
the batching module is used for batching the order data to be uploaded;
the task queue inserting module is used for starting a task queue and inserting the batched order data into the task queue according to batches; wherein, the order data of a batch is a task;
the multithreading module is used for uploading the order data in the task queue to a server in batches in a multithreading mode so that the server uploads the order data to a third-party platform; the batch uploading to the server in a multithreading mode comprises the following steps: starting a plurality of threads according to the set thread number to simultaneously execute a plurality of tasks, and uploading the tasks in the task queue to a server in batch;
and the automatic updating module is used for acquiring the uploading result of the order data from a third-party platform through the server and automatically updating the order state in the ERP system according to the uploading result.
8. The apparatus according to claim 7, wherein the automatic update module is further configured to obtain, by the server, an upload result of the order data from the third party platform, and automatically update, according to the upload result, an order status on an order status expansion table in an ERP system, where the order status expansion table is a table obtained by vertically partitioning the order service table in advance in a database.
9. A computer-readable storage medium on which a computer program is stored, which, when being executed by a processor, implements a method for automatic update of order status in an ERP system according to any one of claims 1 to 4.
10. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the computer program implements a method for automatic update of order status in an ERP system according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710787543.6A CN107679822B (en) | 2017-09-04 | 2017-09-04 | Automatic updating method of order state in ERP system, storage medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710787543.6A CN107679822B (en) | 2017-09-04 | 2017-09-04 | Automatic updating method of order state in ERP system, storage medium and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107679822A CN107679822A (en) | 2018-02-09 |
| CN107679822B true CN107679822B (en) | 2020-11-10 |
Family
ID=61135067
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710787543.6A Active CN107679822B (en) | 2017-09-04 | 2017-09-04 | Automatic updating method of order state in ERP system, storage medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107679822B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109710623A (en) * | 2018-12-10 | 2019-05-03 | 杭州爱聚科技有限公司 | A kind of intelligence order synchronous method |
| CN111861116A (en) * | 2020-06-16 | 2020-10-30 | 广东工业大学 | Passenger queuing method of automatic taxi driving system |
| CN112132652B (en) * | 2020-09-02 | 2022-11-29 | 苏宁云计算有限公司 | Order information acquisition method and device, computer equipment and storage medium |
| CN112416717A (en) * | 2020-11-27 | 2021-02-26 | 中国农业银行股份有限公司 | Batch execution result reporting method, device, equipment and medium |
| CN113824973A (en) * | 2021-08-04 | 2021-12-21 | 杭州星犀科技有限公司 | Multi-platform direct-push plug flow method, system, electronic device and storage medium |
| CN113987099B (en) * | 2021-11-02 | 2024-01-30 | 金云数据科技有限公司 | BIM technology-based method for automatically falling model to GIS |
| CN115526491B (en) * | 2022-09-28 | 2023-11-17 | 惠州市海葵信息技术有限公司 | Data processing method, equipment and storage medium for material demand planning |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8271336B2 (en) * | 1999-11-22 | 2012-09-18 | Accenture Global Services Gmbh | Increased visibility during order management in a network-based supply chain environment |
| JP2013175070A (en) * | 2012-02-27 | 2013-09-05 | Start Co Ltd | Task processing system |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| RU2312396C2 (en) * | 2005-03-24 | 2007-12-10 | Федеральный центр информатизации при Центральной избирательной комиссии Российской Федерации | Method for preparing and conducting a voting using an automated system |
| CA2594639C (en) * | 2007-07-24 | 2018-12-11 | Constellation Homebuilder Systems Inc. | System and method of real-time homebuilding scheduling |
| CN101369330A (en) * | 2008-10-08 | 2009-02-18 | 金蝶软件（中国）有限公司 | Documents processing method, apparatus and system |
| CN103139281B (en) * | 2011-12-05 | 2016-04-20 | 北大方正集团有限公司 | Personal printing system and control method thereof |
| CN102708490B (en) * | 2012-04-17 | 2015-09-30 | 福建三元达软件有限公司 | System and the order processing method of order processing is realized by communication |
| CN106296378B (en) * | 2016-07-26 | 2021-06-01 | 四川长虹电器股份有限公司 | XBRL-based intelligent financial cloud platform system, construction method and service implementation method |
| CN106296352A (en) * | 2016-08-04 | 2017-01-04 | 多点生活(中国)网络科技有限公司 | Order data treating method and apparatus |
-
2017
- 2017-09-04 CN CN201710787543.6A patent/CN107679822B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8271336B2 (en) * | 1999-11-22 | 2012-09-18 | Accenture Global Services Gmbh | Increased visibility during order management in a network-based supply chain environment |
| JP2013175070A (en) * | 2012-02-27 | 2013-09-05 | Start Co Ltd | Task processing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107679822A (en) | 2018-02-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679822B (en) | Automatic updating method of order state in ERP system, storage medium and computer equipment | |
| CN108153670B (en) | Interface testing method and device and electronic equipment | |
| EP2989543B1 (en) | Method and device for updating client | |
| US9424075B1 (en) | Dynamic virtual partitioning for delayed queues | |
| CN109901918B (en) | Method and device for processing overtime task | |
| US11381488B2 (en) | Centralized, scalable, resource monitoring system | |
| CN111026602A (en) | Health inspection scheduling management method and device of cloud platform and electronic equipment | |
| US20180302494A1 (en) | Analytics driven update notification | |
| CN108156030B (en) | Method and device for synchronizing configuration strategies | |
| WO2019148728A1 (en) | Electronic device, execution task assignment method for distributed system, and storage medium | |
| CN114090113B (en) | Method, device, equipment and storage medium for dynamically loading data source processing plug-in | |
| CN107678856B (en) | Method and device for processing incremental information in business entity | |
| US9806969B2 (en) | Infrastructure trending tool | |
| CN115373822A (en) | Task scheduling method, task processing method, device, electronic equipment and medium | |
| CN115757270A (en) | File version management system and method and computer equipment | |
| US9779431B1 (en) | Determining cost variations in a resource provider environment | |
| CN110489208B (en) | Virtual machine configuration parameter checking method, system, computer equipment and storage medium | |
| CN116244324B (en) | Task data relation mining method and device, electronic equipment and storage medium | |
| KR20210085516A (en) | Restaurant Order Ordering Management System Using Mobile Device | |
| CN112866359B (en) | Data chaining method and device, electronic equipment and storage medium | |
| CN111125223B (en) | Database connection pool updating method and device | |
| US11614993B1 (en) | System and method for restoring deleted objects and their assignments to other objects based on any deletion of the other objects | |
| CN114004580B (en) | Method, system, device and readable medium for server production cycle time management | |
| CN116384364A (en) | Automatic generation method, device, equipment and medium for data report | |
| CN115617390A (en) | Configuration information maintenance method, electronic equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |