CN113435974A

CN113435974A - Order filtering method and system

Info

Publication number: CN113435974A
Application number: CN202110713905.3A
Authority: CN
Inventors: 王鹏飞; 羊凯强; 王佔晋
Original assignee: Hangzhou Tuia Network Technology Co ltd
Current assignee: Hangzhou Tuia Network Technology Co ltd
Priority date: 2021-06-25
Filing date: 2021-06-25
Publication date: 2021-09-24

Abstract

The utility model relates to an order filtering method and system, which divides the whole order filtering process into double-layer rules, filters orders in two different stages of order placing stage and order examining stage, is more flexible than single order filtering logic, and the order placing rule and the filtering rule can self-define the conditions of the personal demand of the advertiser and the putting demand of goods, can realize the customized filtering conditions, and automatically filters the orders which are not needed by the advertiser.

Description

Order filtering method and system

Technical Field

The present application relates to the field of order processing technologies, and in particular, to an order filtering method and system.

Background

One type of e-commerce refers to a shop promotion form of payment type in an e-commerce platform, and the second type of e-commerce refers to a business process which is realized by showing a goods delivery payment type single product promotion form on a news information platform in an information flow form, generally promoting a single product page in an account opening form, actively promoting by putting on the shelf goods, ordering by customers, signing for a receipt and the like.

In recent years, with the vigorous development of smart phones, mobile phone users are growing, and two types of e-commerce with mobile phone consultation application programs as a main platform are increasing. However, there is usually a lot of order information in the e-commerce order of the second category, such as wrong name and address information or an order of a malicious system. Therefore, the method not only causes great pressure on the memory of the ordering system, but also causes low advertisement conversion rate and is not beneficial to the healthy advertisement delivery.

In addition, some advertisers have different requirements for orders, and the existing order filtering method cannot filter orders according to the requirements of the advertisers.

Disclosure of Invention

Accordingly, there is a need for an order filtering method and system for solving the problem that the conventional order filtering method cannot filter orders according to the needs of advertisers.

The application provides an order filtering method and system, wherein the method comprises the following steps:

when an order placing request sent by a user side is received, obtaining order information contained in the order placing request, and judging whether the order placing request hits an order placing rule or not according to the order information contained in the order placing request;

if the order placing request does not hit the order placing rule, generating a temporary order according to order information contained in the order placing request, and returning an order placing success message to a user side;

judging whether the temporary order hits a filtering rule or not;

if the temporary order hits the filtering rule, marking an invalid mark on the temporary order, and terminating the subsequent steps;

if the temporary order does not hit the filtering rule, converting the temporary order into a formal order;

and storing the formal order into a MySQL database.

Drawings

Fig. 1 is a flowchart illustrating an order filtering method according to an embodiment of the present application.

Fig. 2 is a schematic structural diagram of an order filtering system according to an embodiment of the present application.

Reference numerals:

100-order filtering server; 200-elastic search cluster; 300-MySQL database;

400-Canal middleware

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The application provides an order filtering method.

The order filtering method provided by the application is not limited to the execution subject. Optionally, an executive body of the order filtering method provided by the present application may be an order filtering system. And the order filtering system is in butt joint with the user terminal. Specifically, the executing entity of the order filtering method provided by the present application may be the order filtering server 100 in the order filtering system. The order filtering server 100 may be built in an order placing system, and may be used to complete the order placing operation in cooperation with the user terminal and perform the filtering operation on the order placed by the user terminal. The order filtering server 100 and the user terminal can communicate through Bluetooth or through 4G/5G network.

As shown in fig. 1, in an embodiment of the present application, the order filtering method includes:

s100, when an order placing request sent by a user side is received, order information contained in the order placing request is obtained, and whether the order placing request hits an order placing rule or not is judged according to the order information contained in the order placing request.

And S210, if the order placing request does not hit the order placing rule, generating a temporary order according to order information contained in the order placing request, and returning a message of successful order placing to the user side.

And S300, judging whether the temporary order hits the filtering rule or not.

S410, if the temporary order hits the filtering rule, marking an invalid mark on the temporary order, and terminating the subsequent steps.

S420, if the temporary order misses the filtering rule, converting the temporary order into a formal order.

S500, storing the formal order into the MySQL database 300.

Specifically, the embodiment adopts a design mode of the responsibility chain, all rules which need to be moved are placed on one responsibility chain in the order filtering process, and the rule filtering is sequentially executed according to the arrangement sequence of the rules in the responsibility chain. The "order placement rule-filtering rule" is a chain of responsibility, that is, the order is filtered according to the order placement rule, and then the order is further filtered according to the filtering rule.

Aiming at the data hitting a certain rule, the order filtering system can arrange the user hitting the certain rule and the corresponding rule information and then perform log printing. The order filtering system may interface with a remote big data server. The big data server is communicatively connected to the order filtering server 100. The big data server can regularly acquire log contents and pull and place the log contents into big data analysis tools such as hdfs (Hadoop distributed file system) and the like to form a report, and advertisement operation can help an advertiser to carry out better commodity release by using data indexes in the report.

When the temporary order is converted into a formal order, the order information data contained in the temporary order is arranged and packaged to form the formal order, the formal order is placed into the MySQL database 300, and then the temporary order is deleted.

In the embodiment, the whole order filtering process is divided into two layers of rules, orders are filtered in two different stages of the order placing stage and the order examining stage, the order filtering logic is more flexible than that of a single order, the order placing rule and the filtering rule can customize conditions of personal requirements of advertisers and delivery requirements of commodities, customized filtering conditions can be realized, and the orders which are not needed by the advertisers are automatically filtered.

In an embodiment of the present application, after the S100, the method further includes:

and S220, if the ordering request hits the ordering rule, returning a message of rejecting ordering to the user side.

Specifically, if the order placing request hits the order placing rule, the user cannot submit the form. And returning a message of rejecting ordering to the user terminal. The ordering rule is set to remove some invalid orders. Configuring the relevant ordering rules proves that it is completely unnecessary to hit the user information of the relevant ordering rules. For example, the hard requirements for the card-opening activity of an operator are 18-65 years old. The advertiser configures the rules in the sense that user information outside this age stage is not available to the operator. The order filtering system directly rejects the user to submit the form when the order information included in the order request indicates that the user's identification card is 16 years old.

In the embodiment, the order-hitting rule is set to return the order-refusing message to the user side, so that a large number of invalid orders which do not accord with the hard order-placing rule can be filtered out in the primary filtering stage, the filtering efficiency is improved, the subsequent filtering by using the filtering rule is easier, and the pressure of the server is lower.

In an embodiment of the present application, before S500 and after S420, the method further includes:

and S430, judging whether the formal order hits the order kicking rule.

And S440, if the official order hits the order kicking rule, marking the official order with a risk mark, and executing the subsequent steps.

Specifically, the present embodiment also adds a kicking rule in the chain of responsibility. In this embodiment, the responsibility chain is changed to "order-placement rule-filtering rule-order-kicking rule".

The order is not hit on the order placing rule and the filtering rule, a filtering link of the order kicking rule is reached, the order is basically valid at this time, but if the order kicking rule is hit, the order is marked, which means that the order is possibly at risk, and an advertiser adopts manual confirmation or a mode of contacting a customer by telephone to confirm the order validity in an order checking link to determine whether the order is finally delivered.

In summary, the order-placing rule may prevent the user from submitting the form if the order-placing rule is hit, and the filtering capability is strongest. The filtering rules can stop the order in the state of the temporary order and can not be converted into the formal order, and the filtering capability is moderate. The order kicking rule can maintain the order in a formal order state, only risk marks are marked, the filtering capacity is minimum, and only an alarm function is realized.

In an embodiment of the application, the ordering rule includes one or a combination of a plurality of first conditions, the first condition is that the identification number is not matched with the name of the user, the age of the user is greater than 55 years, the age of the user is less than 16 years, and the receiving address is within a range of a preset area.

The S100 includes:

s110, judging whether the order information contained in the order placing request hits at least one first type condition.

S120, if the order information contained in the order placing request hits at least one first type condition, determining that the order placing request hits an order placing rule.

In particular, the foregoing has mentioned that the ordering rules are set to remove some invalid orders. Configuring the relevant ordering rules proves that the user information that hits the relevant ordering rules is simply not required.

In this embodiment, the ordering rule is a first type of condition or a combination of a plurality of first type of conditions. For example, the ordering rule may be composed of a combination of two first-class conditions, the user age being greater than 55 years old and the user age being less than 16 years old. Then when the user age in the order information of a placement request is 15 years old, the placement rule is hit and the order filtering system directly rejects the user to submit the form.

In an embodiment of the application, the filtering rule includes a second type condition or a combination of a plurality of second type conditions, where the second type condition is one of the ordered quantity is greater than a preset ordered quantity, the receiving address contains a third party platform account, the character length of the receiving address is less than a preset character length, and the receiving address does not contain any Chinese text.

The S300 includes:

s311, judging whether the temporary order hits at least one second type condition.

S312, if the temporary order hits at least one second type condition, determining the temporary order hit filtering rule.

In particular, the configuration of the filter rules means that the ad-hoc order advertiser may not be required, but still has the possibility of conversion into a formal order. In the embodiment, the personal requirement of the customized advertiser is the second type of condition, and the filtering rule is formed by the combination of the second type of condition. That is, the second type of condition is the advertiser's custom condition. For example, if an advertiser finds that the sign-in rate of a city is low through historical data, the advertiser will establish a filtering rule related to the delivery address, and when the delivery address is specified as the city, the filtering rule is automatically hit. And the order hit the filtering rule is still in a temporary order state and can not be converted into a formal order. At the moment, whether the order is to be delivered or not is confirmed by the customer service and the user, and the temporary order is converted into the formal order by manually confirming the order effectiveness after the follow-up user confirms the delivery.

The preset order placing quantity can be 5, if the order placing quantity is larger than 5, the system judges that the user maliciously brushes the order and hits the filtering rules of the preset order placing quantity.

If the receiving address contains the third-party platform account, the system judges that the advertisement drainage behavior exists, and the receiving address is hit to the filtering rule containing the third-party platform account.

The preset character length may be 3, and if the character length of the receiving address is smaller than 3, the system determines that the receiving address is too short to deliver the goods, and the system is suspected to give an order maliciously and hit the filtering rule that the character length of the receiving address is too short.

If the receiving address does not contain Chinese, the order filtering system judges that the receiving address is not domestic and can not deliver goods, and is suspected of being maliciously placed abroad, and hits the filtering rule that the receiving address does not contain Chinese.

Specifically, as long as an arbitrary filtering rule is hit, the order filtering system marks the temporary order with an invalid mark, and terminates the subsequent steps.

In an embodiment of the application, the list kicking rule includes a third condition or a combination of a plurality of third conditions, and the third condition is that the list leaving time is less than one of the preset leaving time and the total number of the lists corresponding to the mobile phone number of the user is greater than the upper limit of the preset list leaving amount.

The S430 includes:

and S431, judging whether the formal order hits at least one third type condition.

S432, if the formal order hits at least one third type condition, determining the order kicking rule hit by the formal order.

Specifically, as mentioned above, if an order does not hit the order placing rule and the filtering rule, the step of the order kicking rule is reached, and the order is in a formal order state successfully at this time, which belongs to a relatively stable state.

It is understood that the third type of condition setting is all operations of some suspected risk behaviors.

In an embodiment of the present application, after the S500, the method further includes:

s600, sending a data synchronization request to the Canal middleware 400 to control the Canal middleware 400 to pull the Binary log file of the formal order from the MySQL database 300.

S700, analyzing the Binary log file of the formal order and then synchronizing the analyzed Binary log file into the ELASTIC search cluster 200.

Specifically, the basis of data replication between different MySQL databases 300 is a Binary log file Binary log. Once the binary log is enabled, one MySQL database 300 is used as a Master database, all operations in the database of the MySQL database are recorded in the binary log in an event mode, the other databases are used as Slave databases, the Slave databases are communicated with a Master server through an I/O thread, changes of the Master binary log file are monitored, if the Master binary log file is found to be changed, the changes are copied into a relay log of the Slave databases, and then an SQL thread of the Slave executes relevant events into the Slave databases, so that consistency between the Slave databases and the Master database is achieved, and Master-Slave copying is achieved.

Connecting an I/O thread on the Slave to a Master, and requesting to acquire log contents after a specified position (or the initial log) of a specified log file;

and after receiving the request of the I/O thread from the Slave, the Master reads the log information behind the specified position of the specified log file according to the request information through the I/O thread in charge of copying, and returns the log information to the I/O thread at the Slave end. The returned information comprises the name of the information returned at this time in the Binary Log file of the Master end and the position of the information returned at this time in the Binary Log, besides the information contained in the Log;

after receiving the information, the I/O thread of the Slave writes the received Log content into the tail end of a Relay Log file (mysql-Relay-bin. xxxxxx) of the Slave end in sequence, and records the read file name and position of the bin-Log of the Master end into a Master-info file, so that the Master can be clearly informed when reading next time, that is, the Master needs to acquire the Log content from which position of a certain bin-Log starts to go backwards, and please send the Log content to me.

After the SQL thread of the Slave detects that the content is newly added in the Relay Log, the content in the Log file is immediately analyzed into executable Query statements which are actually executed at the Master end, and the Query statements are executed by the Slave. Thus, in fact, the same Query is executed at the Master end and the Slave end, so that the data at the two ends are identical.

Described above are master-Slave copies of the MySQL database 300 and the Slave library. The Canal middleware 400 is introduced in the application, and the Canal middleware 400 can disguise itself as a Slave library of the Slave of the MySQL database 300, so that the dump protocol of the Slave is realized to pull data. And then synchronized into the ELasticsearch cluster 200.

Therefore, when the order placing rule, the filtering rule or the order kicking rule is verified, the interface of the ELasticissearch cluster 200 can be directly requested, the data volume related to the order placing rule, the filtering rule or the order kicking rule can be directly pulled from the ELasticissearch cluster 200, and the query speed is high.

For example, if the filtering rule is that the number of placed orders within 90 days is greater than the preset number of placed orders 5, the placement filtering system will pull the number of placed orders of the user within 90 days directly from the ELasticsearch cluster 200, and if the number of placed orders is greater than 5, the filtering rule is considered to be hit.

In an embodiment of the present application, when determining whether the temporary order hits the filtering rule, data related to each first type condition and order information included in the order placing request is directly pulled from the ELasticsearch cluster 200 for determination.

When judging whether the temporary order hits the filtering rule, directly pulling the data of the temporary order related to each second type condition from the ELasticsearch cluster 200 for judgment.

And when judging whether the formal order hits the order kicking rule, directly pulling the data of the temporary order related to each third condition from the ELasticissearch cluster 200 for judgment.

Specifically, the binary log of the relevant order table is pulled by controlling the Canal middleware 400, the data of the order is synchronized into the elistic search cluster 200, and all the queries of the relevant complex conditions included in all the rules go through the elistic search cluster 200 query, so that the execution efficiency of rule hit judgment is ensured.

Currently, when the data in the MySQL database 300 and the data in the ELasticsearch cluster 200 are inconsistent in a short time, the delay of the time is usually within 1S, and the data synchronization is realized after 1S delay, so that the delay is low.

In an embodiment of the application, the filter rule further comprises a fourth type of condition. The fourth type of condition is an operator related condition. The S300 includes:

s321, screening out a third type of condition from all the conditions, and judging whether the temporary order hits at least one second type of condition.

S322, if the temporary order hits at least one second type condition, determining the temporary order hit filtering rule, and executing the subsequent step of marking the temporary order with an invalid mark.

S323, if the temporary order does not hit any second type of condition, further determining whether the temporary order hits a fourth type of condition within a preset time period.

S324, if the temporary order does not hit the fourth type condition within the preset time period, a step of converting the temporary order into a formal order is executed.

Specifically, the present embodiment also adds a fourth type of condition, i.e., a condition related to the operator. The fourth condition may be that the mobile phone number is off or stopped. If yes, directly marking an invalid mark and terminating the subsequent steps. If not, it is then determined whether a condition associated with the operator, i.e., a fourth type of condition, is met.

The concept of a preset time period is introduced here to give fault tolerance. In this embodiment, the order filtering system interfaces with the operator. For example, if the preset time period is 5 minutes, it is determined whether the non-operator condition is hit, that is, whether the second type of condition is hit, for example, whether the number of placed orders is greater than 5, whether the receiving address contains a third party platform, and the like. If the second type of condition is hit, directly executing S410, marking the temporary order with an invalid mark, and terminating the subsequent steps.

If any one of the second type of conditions is not hit, further determining whether a fourth type of condition is hit, for example, determining whether the verification code sent by the operator is received within 5 minutes, if the verification code sent by the operator is not received within 5 minutes, indicating that the mobile phone of the user is in a power-off or shutdown state, executing S410, marking an invalid mark on the temporary order, and terminating the subsequent steps.

If the verification code sent by the operator is received within 5 minutes, S420 is executed to convert the temporary order into a formal order.

As shown in fig. 2, in an embodiment of the present application, the present application further provides an order filtering system, which includes an order filtering server 100, an ELasticsearch cluster 200, a MySQL database 300, and a Canal middleware 400. An order filtering server 100 for the order filtering method mentioned in the foregoing. The ELasticsearch cluster 200 is communicatively connected to the order filtering server 100. The MySQL database 300. And the order filtering server is in communication connection with the order filtering server. The Canal middleware 400 is communicatively connected to the order filtering server. The Canal middleware 400 is also communicatively coupled to the ELasticsearch cluster 200. The Canal middleware 400 is also in communication connection with the MySQL database 300 respectively.

In summary, the order filtering method and system provided by the application have the following beneficial effects:

1) the whole wind control rule is divided into three layers, orders can be filtered in different stages, and the method is more flexible and more elastic than a single filtering logic.

2) Whether the order placing rule, the filtering rule or the order kicking rule, each rule supports the permutation and combination of a plurality of conditions. The total 7 major categories are divided into addresses, identification numbers, mobile phone numbers, names, areas, others, messages and the like. Meanwhile, a plurality of small categories are supported and configured below each primary large category, and the large category is divided into 6 small categories by taking the large category of the mobile phone number as an example: the state of placing an order on the mobile phone number, the amount of placing an order (mobile phone number statistics), the amount of placing an order (the same commodity with the same mobile phone number), the amount of placing an order (the same merchant with the same mobile phone number), and the mobile phone number hit for many times. Wherein each small category is a rule, and different small categories are independent before each other. The advertiser can customize the rules according to the delivery requirement of the advertiser to carry out filtering.

3) The ELASTIC search cluster 200 is a storage engine which can support large data magnitude through inverted index, and the query efficiency of the large data magnitude scene is improved in a mode that the information of the order is synchronized to the ELASTIC search cluster 200 through the Canal middleware 400.

The technical features of the embodiments described above may be arbitrarily combined, the order of execution of the method steps is not limited, and for simplicity of description, all possible combinations of the technical features in the embodiments are not described, however, as long as there is no contradiction between the combinations of the technical features, the combinations of the technical features should be considered as the scope of the present description.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. An order filtering method, characterized in that the method comprises:

judging whether the temporary order hits a filtering rule or not;

and storing the formal order into a MySQL database.

2. The order filtering method according to claim 1, wherein said method further comprises:

and if the ordering request hits the ordering rule, returning a message of rejecting ordering to the user side.

3. The order filtering method according to claim 2, wherein before storing the official order in a MySQL database, the method further comprises:

judging whether the formal order hits an order kicking rule or not;

and if the formal order hits the order kicking rule, marking the risk mark on the formal order and executing the subsequent steps.

4. The order filtering method according to claim 3, wherein the order placing rule comprises one or a combination of a plurality of first conditions, wherein the first condition is one of the identification number not matching with the user name, the user age being more than 55 years old, the user age being less than 16 years old, and the receiving address being within a range of a preset area;

judging whether the order placing request hits an order placing rule according to order information contained in the order placing request comprises the following steps:

judging whether order information contained in the order placing request hits at least one first type condition;

and if the order information contained in the order placing request hits at least one first type condition, determining that the order placing request hits an order placing rule.

5. The order filtering method according to claim 4, wherein the filtering rule includes one or a combination of a second type of condition, the second type of condition is one of the ordered quantity is greater than the preset ordered quantity, the receiving address contains a third party platform account, the character length of the receiving address is less than the preset character length, and the receiving address does not contain any Chinese text;

judging whether the temporary order hits the filtering rule comprises the following steps:

judging whether the temporary order hits at least one second type condition;

and if the temporary order hits at least one second type condition, determining the temporary order hit filtering rule.

6. The order filtering method according to claim 5, wherein the kicking order rule comprises a third type condition or a combination of a plurality of third type conditions, the third type condition is one of the order placing page staying time is less than the preset staying time, and the total order placing quantity corresponding to the mobile phone number of the user is greater than the preset upper limit of the order placing quantity;

the rule for judging whether the official order hits the kicking order comprises the following steps:

judging whether the formal order hits at least one third type condition;

and if the formal order hits at least one third type of condition, determining the order kicking rule hit by the formal order.

7. The order filtering method according to claim 6, further comprising, after storing the official order in a MySQL database:

sending a data synchronization request to the Canal middleware to control the Canal middleware to pull the Binary log file of the formal order from the MySQL database;

and analyzing the Binary log file of the formal order and then synchronizing the analyzed Binary log file into an elastic search cluster.

8. The order filtering method according to claim 7, wherein when judging whether the temporary order hits the filtering rule, directly pulling data, which is included in the order placing request and is related to each first type condition, from an ELasticsearch cluster for judgment;

when judging whether the temporary order hits the filtering rules, directly pulling data related to each second type of condition from the ELASTIC search cluster to judge;

and when judging whether the formal order hits the order kicking rule, directly pulling the data of the temporary order and each third condition from the ELasticissearch cluster for judgment.

9. The order filtering method according to claim 4, wherein said filtering rule further comprises a fourth type of condition, said fourth type of condition is a condition related to an operator, and said determining whether said temporary order hits said filtering rule comprises:

screening out a third type of condition from all conditions, and judging whether the temporary order hits at least one second type of condition;

if the temporary order hits at least one second type condition, determining the temporary order hit filtering rule, and executing the subsequent step of marking the temporary order with an invalid mark;

if the temporary order does not hit any second type of condition, further judging whether the temporary order hits a fourth type of condition within a preset time period;

and if the temporary order does not hit the fourth type of condition within a preset time period, executing a step of converting the temporary order into a formal order.

10. An order filtering system, comprising:

an order filtering server for performing the order filtering method of any one of claims 1 to 9;

the elastic search cluster is in communication connection with the order filtering server;

the MySQL database is in communication connection with the order filtering server;

the Canal middleware is in communication connection with the order filtering server; the Canal middleware is also in communication connection with the ELasticissearch cluster and the MySQL database respectively.