The content of the invention
The purpose of the present invention is the defect for prior art, there is provided a kind of sequence information maintaining method, is taken for userDisappear or overtime order is processed according to setting mechanism, can rationally realize in the case where both customer and electric business demand is taken into accountThe business function cancelled an order, and carry out management and control according to the time to cancelling an order, exceed setting time for the time is cancelledThe order of threshold value performs deletion action automatically, the permanent occupancy to memory space has been avoided, has caused storage resource to waste.
In view of this, a kind of sequence information maintaining method is embodiments provided, including：
Obtain the information of the generation time of online order information；The online order information includes business in order ID, orderThe commodity ID of product, lot-size, commodity price data, ID, information of receiving, storefront information, order picking temporal information andOrder status information；
Monitoring current time and the interval of the very first time between the generation time；
When the very first time, interval was more than default very first time threshold value, cancellation of order instruction is generated；The orderCancelling instruction includes the order ID；
Pending online order information is determined according to the order ID, is treated according to cancellation of order instruction changeThe order status information of the online order information of process, by the order status information cancellation state is changed to, and records orderThe cancellation time；
The online order information that the order status information is cancellation state is obtained, online order list has been cancelled in generation；
Monitoring current time and the cancellation of order time for having cancelled each online order information in online order listBetween the second time interval；
When second time interval of the online order information that order ID is the first order ID is more than default secondBetween threshold value when, generation cancel an order deletion instruction, it is described cancel an order deletion instruction include the first order ID；
According to the deletion instruction of cancelling an order, remove first order in online order list in described cancellationThe corresponding online order information of ID.
Preferably, before the information of the generation time of the acquisition online order information, methods described also includes：
The sequence information that the terminal unit the reception server sends, the sequence information includes the order ID, orderThe commodity ID of middle commodity, lot-size, commodity price data, ID, information of receiving, storefront information and order picking time letterBreath；
Pretreatment is carried out to the sequence information, adds order status information, generation to order online in the sequence informationSingle information, in being stored in online order data list, and records the generation time of the online order information；The order shapeState information is goods state to be matched somebody with somebody.
Preferably, methods described also includes：
Obtain the corresponding work weighted datas of each employee ID of the StoreFront；
The employee ID of the responsibility employee of online order information, builds according to each employee ID corresponding work weighted datasFound and record the related information of the order ID and the employee ID of the responsibility employee；
Receive the responsibility employee and complete information with goods by what the terminal unit was input into, it is described to complete packet with goodsInclude the order ID；
According to it is described complete information updating with goods described in online order information order status information, by the order statusInformation is changed to goods completion statuses.
It is further preferred that methods described also includes：
Picking confirmation is received, according to the picking confirmation, the online order information is processed, generatedComplete sequence information and to be stored in complete in order data list；And delete institute in the online order data listState online order information.
Preferably, in the order status information for completing online order information described in information updating described in the basis with goods,The order status information is changed to before goods completion statuses, methods described also includes：
The cancellation of order instruction of user terminal receiving user's input；
Cancellation of order information is generated according to cancellation of order instruction and is sent to the server；The cancellation of order informationAt least include the ID and order ID；
Corresponding online order information is inquired about in the online order information according to the order ID, and inquiry is obtainedOnline order information in ID match with the ID in the cancellation of order information；
When matching consistent, the cancellation of order instruction is generated.
Preferably, the corresponding work weighted datas of each employee ID for obtaining the StoreFront are specifically included：
Multiple employee ID of the storefront information association are determined according to the storefront information of the StoreFront；
The order ID of the whole pending order related to the employee ID is inquired about according to the employee ID；It is described pendingOrder is online order that order status information is goods state to be matched somebody with somebody；
Pending quantity on order is counted according to the order ID of the pending order；
The work weighted data is generated according to the pending quantity on order.
Preferably, it is described the work weighted data is generated according to the pending quantity on order to specifically include：
The commodity ID and lot-size of each pending order are determined according to the order ID of the pending order；
The weighted value of the pending order is determined according to the commodity ID and lot-size of each pending order；
Weighted value and the pending quantity on order to the pending order is weighted process and generates the workWeighted data.
Sequence information maintaining method provided in an embodiment of the present invention, cancels for user or overtime order is according to setting mechanismProcessed, the business function cancelled an order can be rationally realized in the case where both customer and electric business demand is taken into account, and it is rightCancel an order and carry out management and control according to the time, deletion behaviour has been performed automatically more than the order of setting time threshold value for the time is cancelledMake, the permanent occupancy to memory space has been avoided, has caused storage resource to waste.
Specific embodiment
Order processing is the emphasis in one of core business of e-commerce website, i.e. emphasis.The quality of its result,Customer experience is directly connected in operation, that is, is related to user and is placed an order, customer's turn-head-rate is equally provided in enterprises to enterpriseGold is used, and turnover is suffered from, and warehouse logisticses suffer from particularly important effect.And with the popularization and development of ecommerce, timesThe sales volume of increasing also brings challenge to the data storage management of order.For this purpose, the present invention is for picking under on-line selling, lineOperation mode proposes a kind of sequence information maintaining method, sequence information ground data storage can be tieed up based on order statusPillar is managed, and improves the service efficiency of storage resource, has taken into account the demand of both customer and electric business for data management.
Below by drawings and Examples, technical scheme is described in further detail.
Fig. 1 is sequence information maintaining method flow chart provided in an embodiment of the present invention, as shown in figure 1, including：
Step 100, the sequence information that terminal unit the reception server sends；
Specifically, after user is placed an order by user side, can be generated according to the ordering information of user order in the serverSingle information, and sequence information is distributed by StoreFront based on rule set in advance.Sequence information can be included in order ID, orderThe commodity ID of commodity, lot-size, commodity price data, ID, information of receiving, storefront information and order picking time letterBreath.
Step 110, to sequence information pretreatment is carried out, and adds order status information, generation to order online in sequence informationSingle information, in being stored in online order data list, and records the generation time of online order information；
Specifically, after user is placed an order by user side, can be generated according to the ordering information of user order in the serverSingle information, and sequence information is distributed by StoreFront based on rule set in advance.The terminal unit of StoreFront enters for sequence informationRow pretreatment, generates online order information, while the generation time of online order information is recorded, subsequently to carry out the process limitedOn monitoring.
Step 120, obtains the information of the generation time of online order information；
Specifically, online order information includes commodity ID, lot-size, the commodity price number of commodity in order ID, orderAccording to, ID, information of receiving, storefront information, order picking temporal information and order status information.
Server background carries out the monitoring in process limited for each online order information.
Step 130, monitoring current time and the interval of the very first time between the generation time；
Specifically, after online order information is generated, show that the order has been assigned to shop, then can be according to thisThe individual time, as starting time, carrys out the time limit of closed indent process.
Can be determined and the starting time according to current time, that is, generate the time interval between online order information timeIt is over time limit as determining whether.
Because herein the time limit of described order processing is the time limit for limiting picking after user places an order, accordingly it is also possible toIn subsequent step 240, the time completed with goods to order, as starting time, carrys out the time limit of closed indent process.
Step 140, when the very first time, interval was more than default very first time threshold value, generates cancellation of order instruction；
Specifically, cancellation of order instruction includes order ID.
With a specific example explanation：
Client is carried out after line places an order by the application of mobile terminal, and sequence information goes to shop, generates online order letterBreath, or completed with goods via shop employee.In 7 days after this, client does not go to StoreFront picking, and server then canCancellation of order instruction is generated to this order.
Step 150, according to order ID pending online order information is determined, pending according to cancellation of order instruction changeOnline order information order status information, order status information is changed to into cancellation state, and record the cancellation of order time；
Specifically, the state of the order can be instructed the state for being changed to cancel according to cancellation of order.
Step 160, obtains the online order information that order status information is cancellation state, and online order row have been cancelled in generationTable；
Specifically, the order status information of each order of server initiative recognition, by status information be cancellation stateLine sequence information is added to and cancel in online order list.
The initiative recognition of server can be real-time, i.e., in the order status information of pending online order informationThe crawl with order data is just identified when state is modified；Can also be timing acquisition, such as per hour or per halfHour updates a secondary data.
Step 170, monitors current time and cancels the cancellation of order of each online order information in online order listThe second time interval between time；
Specifically, when order is cancelled the time more than setting time, such as 30 days, i.e., the data of the order are no longer retained.
If being not above setting time when order is cancelled the time, the online order cancelled can also be looked intoAsk operation.Specifically, can be inquired about by information such as order ID, IDs cancelling an order.
Additionally, for the online order information cancelled in online order list can also carry out the operation of manual deletion.Can be realized by way of batch deletion or single deletion.
When batch is deleted, service background can by user interface, to cancelling online order list in check box enterRow multiselect deletes order, and after deleting success, these orders will be deleted from data base.
During single deletion, on a user interface, by choosing every online order letter in online order list is cancelledCorresponding deletion button is ceased, clicking operation can be carried out to the deletion button by user interface, the order is deleted, deleted intoThe order data will be deleted from data base after work(.
Step 180, when the second time interval of the online order information that order ID is the first order ID is more than default theDuring two time thresholds, generation is cancelled an order and deletes instruction；
Specifically, the cancellation time cancelled an order when one has been over default time interval, such as 30 days, thenSystem directly generates deletion instruction, deletes the sequence information.The order ID of deleted order is included in instruction is deleted.
Step 190, according to cancelling an order instruction is deleted, and ID pair, the first order is removed in online order list is cancelledThe online order information answered.
Said process realizes the flow process for performing automatically that the sequence information based on Preset Time management and control is safeguarded.EntirelyFlow process is implemented in server end.
Additionally, the cancellation of order, or by the Client-initiated that places an order.
Namely the cancellation of order in step 150 is instructed, and also there is another production method.
Specifically, before step 150, the cancellation of order instruction of user terminal receiving user's input, according to cancellation of orderInstruction generates cancellation of order information and is sent to server；At least include ID and order ID in cancellation of order information；ServiceDevice inquires about corresponding online order information according to order ID in online order information, and to inquiring about the online order information for obtainingIn ID match with the ID in cancellation of order information；When matching consistent, cancellation of order instruction is generated.
Said process is that the implementation procedure that user actively cancels an order, the mistake if user places an order, or user change masterMeaning is not desired to buy commodity, can be operated as procedure described above.
But in order to avoid causing too big manpower and materials to lose to electric business, the process is preferred, can only assign in orderDistribute leaflets are processed before completing or order status information is changed to match somebody with somebody and could initiate before goods completion statuses.Once order is completeInto distribute leaflets or complete with goods, again cancellation of order cannot have been initiated by user.
Sequence information maintaining method provided in an embodiment of the present invention, cancels for user or overtime order is according to setting mechanismProcessed, the business function cancelled an order can be rationally realized in the case where both customer and electric business demand is taken into account, and it is rightCancel an order and carry out management and control according to the time, deletion behaviour has been performed automatically more than the order of setting time threshold value for the time is cancelledMake, the permanent occupancy to memory space has been avoided, has caused storage resource to waste.
The process that online order carries out assigning distribute leaflets process is illustrated below.
After step 110, can also include for online order carries out assigning the process that distribute leaflets are processed.Concrete such as Fig. 2It is shown, comprise the steps：
Step 210, obtains the corresponding work weighted datas of each employee ID of StoreFront；
Specifically, in the present embodiment, work weighted data is can be for quantifying to weigh employee's current work loadData.Work weighted data can be obtained by following process.
First, multiple employee ID that storefront information is associated are determined according to the storefront information of StoreFront；Secondly looked into according to employee IDAsk the order ID of the whole pending order related to employee ID；Pending order herein refers to order status information to wait to match somebody with somebodyThe online order of goods state；Again, pending quantity on order is counted according to the order ID of pending order；Finally, according to waiting to locateReason quantity on order generation work weighted data.
In this process, the weighted data that works is determined by the quantity of the pending order of employee, that is to say, that oneThe pending order of individual employee is more, represents that his current work weight is bigger.
Further, the generation of work weighted data can also be while consider each in addition to considering pending quantity on orderThe commodity and commodity amount of pending order.So can more reasonably carry out task assignment.Such as two employees A and B, whereinThe pending order that the pending order of A has 2, B has 3, in the pending order of A, and every order includes 10 commodity, andEvery order only has 2 commodity in the pending order of B, if only considering work weighted data with pending quantity on order,Obviously do not consider that commodity that pending order includes and lot-size are more rigorous, reasonable simultaneously.
Therefore in a preferred embodiment, the method for work weighted data is generated as shown in figure 3, comprising the steps：
Step 211, according to the order ID of pending order the commodity ID and lot-size of each pending order are determined；
Step 212, according to the commodity ID and lot-size of each pending order the weighted value of pending order is determined；
Specifically, a weight can be given to commodity according to the difference of commodity, is then somebody's turn to do according to commodity ID correspondencesWeight, using the product of the weight and the lot-size of the commodity as a commodity in order weighted value.If order includesVarious commodity, then using the weighted value sum of various commodity as pending order weighted value.
Step 213, the weighted value and pending quantity on order to pending order is weighted process and generates work weightData.
Specifically, the pending order of whole of each employee is weighted, you can obtain the right to work tuple of the employeeAccording to.
Step 220, according to the employee of the responsibility employee of the corresponding work weighted data online order information of each employee IDID, sets up and records the related information of order ID and the employee ID of responsibility employee；
After this, order is generated to order and assigns information, and based on related information, according to the user of responsibility employeeID is sent to the user terminal of responsibility employee.The user terminal of responsibility employee is assigned information and is shown to the order for receivingShow.Information is assigned by order, the responsibility employee order can be pointed out to be assigned to him to be carried out with goods process.Order splittingAt least include order ID in information.
Step 230, receives responsibility employee and completes information with goods by what terminal unit was input into, and completing information with goods includes orderingSingle ID；
Specifically, responsibility employee can complete information by terminal unit input after completing with goods with goods, so as to beTo recording with goods deadline and action in system.
In a preferred embodiment, can be generated according to order picking temporal information and complete pre-warning time with goods, such as be set8 hours before being set to the order picking time, or 4 hours before.
If when arrival completes pre-warning time with goods, system is also not received by completing information with goods, then generate early warningInformation, to point out the responsibility employee order to reach the picking time, needs are paid close attention to and to be had first carry out with goods.
Step 240, according to the order status information that information updating online order information is completed with goods, by order status informationIt is changed to goods completion statuses；
Specifically, confirm whether the order is complete by storefront management person or employee are by checking order status informationInto with goods.
In the process to online order information, sequence information can be carried out at classification based on different order status informationsReason.
Then it is to wait to match somebody with somebody in order status information such as when the goods order inquiries information to be matched somebody with somebody for receiving storefront management person's inputMatch query is carried out in the online order information of goods state；When goods order inquiries the to be matched somebody with somebody letter for receiving storefront management person's inputBreath, then carry out match query in order status information is the online order information with goods completion statuses.
Step 250, receives picking confirmation, according to picking confirmation, online order information is processed, and generatesComplete sequence information and to be stored in complete in order data list.
The action of picking under user completes line, storefront management person or employee are input into picking confirmation in terminal unit.Picking confirmation is included by the information of order ID.Determine the order for completing so as to pass through order ID.
Step 260, deletes online order information in online order data list.
Step 250 and step 260 can be while carrying out.
After step 250, can also to completing order data list in data deleted, backed up etc. behaviourMake.
Such as, need periodically to completing order data list in data back up.It is real by setting BACKUP TIMEThe automated back-up of existing system.
Simultaneously action-item can be set, it is determined that whether deleting the data that backup is completed.
Certainly, the action deleted and back up can be produced by the operation of terminal unit by the manager of StoreFront's.
The sequence information for being assigned to the whole process that order processing is completed from order is completed by said process to process.Based on said process, when order is assigned, the duty of order can be automatically distributed according to employee's current work load amount of service StoreFrontAppoint employee, greatly reduce the work of storefront management person, shorten the time of order processing, improve work efficiency.
Professional should further appreciate that, with reference to each example of the embodiments described herein descriptionUnit and algorithm steps, can with electronic hardware, computer software or the two be implemented in combination in, it is hard in order to clearly demonstrateThe interchangeability of part and software, according to function has generally described the composition and step of each example in the above description.These functions are performed with hardware or software mode actually, depending on the application-specific and design constraint of technical scheme.Professional and technical personnel can use different methods to realize described function to each specific application, but this realizationIt is not considered that beyond the scope of this invention.
Can be with hardware, computing device with reference to the method for the embodiments described herein description or the step of algorithmSoftware module, or the combination of the two is implementing.Software module can be placed in random access memory (RAM), internal memory, read only memory(ROM), electrically programmable ROM, electrically erasable ROM, depositor, hard disk, moveable magnetic disc, CD-ROM or technical fieldIn any other form of storage medium well known to interior.
Above-described specific embodiment, has been carried out further to the purpose of the present invention, technical scheme and beneficial effectDescribe in detail, should be understood that the specific embodiment that the foregoing is only the present invention, be not intended to limit the present inventionProtection domain, all any modification, equivalent substitution and improvements within the spirit and principles in the present invention, done etc. all should includeWithin protection scope of the present invention.