WO2019157777A1

WO2019157777A1 - Routing sub-control reconciliation method and system

Info

Publication number: WO2019157777A1
Application number: PCT/CN2018/083064
Authority: WO
Inventors: 韦游领; 刘潜
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-02-13
Filing date: 2018-04-13
Publication date: 2019-08-22
Also published as: CN108280754B; CN108280754A

Abstract

The present application relates to a routing sub-control reconciliation method and system, the method comprising the following steps: step 1: acquiring a task name, and querying a merchant routing information table to acquire merchant information; step 2: querying a merchant management information table to acquire merchant configuration information; step 3: determining whether the merchant configuration information satisfies a timed task start time determining rule and, if so, then executing step 4; and if not, then finishing the present method; step 4: on the basis of the merchant configuration information, acquiring merchant reconciliation file interaction information and acquiring a merchant accounting book file; step 5: determining whether a local reconciliation file is saved normally in a database and, if so, then acquiring the local reconciliation file from the database, and executing step 7; and if not, then executing step 6; step 6: after the system continues to wait for a specific time, executing step 5; and step 7: extracting reconciliation elements and implementing reconciliation on the basis of the reconciliation elements of the merchant, and generating a reconciliation result file.

Description

Method and system for routing sub-control reconciliation

The present application claims the priority of the Chinese patent application filed on February 13, 2018, with the application number of 201101148432.5, entitled "A Method and System for Reconciliation Control of Routes", the entire contents of which are incorporated by reference. Combined in this application.

Technical field

The present application relates to the field of computer service technologies, and in particular, to a route control and reconciliation method and system.

Background technique

Reconciliation refers to the process of checking the transaction information of the previous liquidation cycle to confirm the consistency and correctness of the transaction information. The relevant figures, monetary funds, securities units or individuals of the accounting books should be checked against each other regularly to ensure that the accounts are consistent, the accounts are consistent, and the accounts are consistent.

With the development of the Internet and computers, many services have been traditionally converted from offline to online and offline operations through the network. The accounting reconciliation has also been automatically reconciled by traditional manual reconciliation and transferred to the network and computer.

At present, the reconciliation system on the market, for different accounting book accessors, the data interaction degree is too high and too complicated, which leads to the actual reconciliation solution can not meet the reconciliation requirements of different access parties. For example, different accessing parties have different ways of interacting with each other, different ways of adding encryption, different reconciliation elements, and different data requirements for reconciliation results, so that a reconciliation system must meet the above different requirements, and its data The degree of cross-coupling is too high. Such a highly coupled reconciliation method directly leads to great limitations of system service expansion and function expansion, and it cannot provide a fast and stable docking solution in time, which seriously affects the business expansion of the enterprise. In addition, such a highly coupled reconciliation method will also result in a lot of repetitive workload and is not conducive to operational management and event response.

Summary of the invention

Based on this, it is necessary to provide a method for routing and controlling reconciliation for the above technical problem, which establishes a plurality of routing information parameter tables, so that there is an indirect or indirect association between the tables and the tables, and the program is established by using the program. The relationship between the use and the table, through routing reconciliation, flexible combination of multiple routes to achieve sub-control reconciliation processing, and at the same time through the establishment of relevant routing control information to obtain the reconciliation period and reconciliation of different merchants in different transaction scenarios The data original format, the reconciliation start date, and the reconciliation elements and so on, so as to complete the reconciliation operation based on the aforementioned data and information.

According to an embodiment of the present application, a route sub-control reconciliation method is provided. The reconciliation task is started according to a reconciliation task startup time, and the reconciliation task includes the following steps:

Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;

Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date.

Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;

Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;

Step 5: According to the merchant configuration information, determine, according to the merchant configuration information, whether a local accounting book file related to the merchant is normally stored in a database, and if yes, obtain the local accounting book file from the database. And perform step 7; otherwise, perform step 6;

Step 6, after the system continues to wait for a certain period of time, return to step 5;

Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant, and generate a reconciliation result file. .

According to an embodiment of the present application, a route distribution control reconciliation system is provided, including a data extraction module, a data processing module, a file downloading module, a reconciliation module, and a system general module.

The data extraction module is configured to extract and/or acquire data in a table and a task, and perform query in other tables according to the extracted data, and extract corresponding information;

The data extraction module includes:

a query module for querying data in a table;

An extraction module for extracting and/or obtaining data and information in a form;

The data processing module is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;

The data processing module includes:

a judging module for judging whether a local accounting book file is stored in a database;

a parsing module for parsing accounting books;

The file downloading module is configured to download an accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component;

The reconciliation module is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;

The system universal module is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and the accounting book file;

The system universal module includes:

a scheduling module for scheduling all scheduled tasks and determining and initiating reconciliation tasks;

a timer module for performing all timing and timing operations;

A database used by the storage system to execute all of the data and instructions of this method.

According to an embodiment of the present application, there is provided a computer readable storage medium, wherein the computer readable storage medium stores a program for executing a route sorting reconciliation method, the program being executed by a processor , performing the steps of the method, including:

Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;

Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;

Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .

The beneficial effects of the present application are mainly: simplifying the processing and maintenance of the reconciliation operations of different access parties in different transaction scenarios, realizing different data interaction modes, avoiding high coupling of codes, improving technical compatibility, and efficiently and safely. Process and store the reconciliation result data, and realize the irrelevant migration of the reconciliation code and the database platform; at the same time, it is convenient for the user to perform data maintenance of the related routing information table to improve the user experience. In addition, by using the route control reconciliation method of the present application, cross-platform reconciliation support can be realized, and multi-mode hybrid reconciliation fast and secure access can be realized. By parameterizing and routing the reconciliations in different scenarios of different merchants, the merchant management can be configured and configurable, and the file information management parameters can be configured. At the same time, the reconciliation file dimensions and system parameter information can be configured.

DRAWINGS

1 is a schematic flow chart of a method for routing and controlling reconciliation according to an embodiment of the present application;

2 is a schematic flowchart of a timing task start time determination rule in a route control reconciliation reconciliation method according to an embodiment of the present application;

FIG. 3 is a schematic flowchart diagram of step S100 in a route control reconciliation reconciliation method according to an embodiment of the present application;

FIG. 4 is a schematic flowchart diagram of step S101 in a method for routing and controlling reconciliation according to an embodiment of the present application;

FIG. 5 is a schematic structural diagram of a route split control reconciliation system according to an embodiment of the present application; FIG.

6 is a schematic diagram of an operating environment of a system in which an application is installed, in accordance with an embodiment of the present application.

Detailed ways

The implementation of the technical solution will be further described in detail below with reference to the accompanying drawings.

It will be understood by those skilled in the art that the following description is to be construed as illustrative of the embodiments of the invention. The present application can be applied to other than the technical details exemplified below, as long as they do not depart from the principles and spirit of the present application.

In addition, in order to avoid limitation of the description of the present specification to the simplifications, in the description in the specification, some technical details that can be obtained in the prior art materials may be omitted, simplified, modified, etc., which is a technique in the art. It is understandable to the person and this does not affect the disclosure adequacy of this specification.

Hereinafter, embodiments for carrying out the present application will be described. Note that the description will be given in the following order: 1. Outline of the inventive concept; 2. A route sorting reconciliation method (Fig. 1 - Fig. 4); 3. A route sorting reconciliation reconciliation system (Fig. 5) 4. A system on which an application is installed, and a computer readable medium storing the application (FIG. 6) according to an embodiment of the present application.

1. Summary of the inventive concept

The application relies on Mongodb's text data storage function, Oracle's efficient read and write performance, redis cache lock, and MQ message middleware for the reconciliation of different accounting book access data. Combined with the technical framework PAFA5, a set of effective reconciliation control engine routing solutions using routing information is summarized.

Specifically, by establishing a plurality of routing information parameter tables, there is an indirect or indirect association between the tables and the tables, and a program is used to establish a usage relationship between the tables and the tables, and the plurality of flexible combinations are performed through routing reconciliation. Routing to achieve sub-control reconciliation processing, and at the same time establish relevant routing control information to obtain the reconciliation period, reconciliation data original format, reconciliation start date and reconciliation elements of different merchants in different transaction scenarios, etc. The aforementioned data and information to complete the reconciliation operation.

2. A routing control reconciliation method (Figure 1 - Figure 4)

In view of the problem that the system data interaction coupling degree in the prior art is too high, the actual reconciliation solution cannot meet the reconciliation requirements of different access parties, and the problem has a large limitation, the embodiment of the present application proposes to effectively reduce the data interaction. A routing and reconciliation method that supports coupling and supports cross-platform reconciliation and multi-mode hybrid reconciliation fast secure access scheme.

As shown in FIG. 1 , a routing control reconciliation method starts a reconciliation task according to a reconciliation task startup time, and the reconciliation task includes the following steps:

The system controls the reconciliation task startup time through the total scheduling task. Specifically, the system total scheduling task performs polling every 10 minutes to obtain basic parameters of all loaded timing tasks in the total scheduling task, wherein all timings are The basic parameters of the task include the task name, task execution mode, task reconciliation date, task startup time, task execution time, and file storage directory. The system polls to determine whether the scheduled reconciliation task in the scheduled task is started.

The total scheduling task determines the startup time of the reconciliation task, and specifically includes the following process:

The total scheduling task is started, the basic parameter table of the timed task is queried, the basic parameters of all the merchant reconciliation tasks are obtained from the basic parameter table of the timed task, and the reconciliation is determined according to the resumption of the reconciliation task in the basic parameters of the reconciliation task. Whether the task is started or not, if the time condition is met, the reconciliation task is started. The basic task parameter table includes a task name task start time and a task latest execution time of all the timed tasks; the basic parameters of the reconciliation task include all the merchant reconciliation task names, the reconciliation task start time, and the reconciliation The latest execution time of the task. It should be noted that the reconciliation task start time of all the reconciliation tasks of the merchants and the latest execution time of the reconciliation tasks are the same.

The basic task parameter table of the timing task provides basic parameters of all timing tasks.

S100, obtaining the task name in the reconciliation task, querying the merchant routing information table in the database according to the task name, acquiring the merchant information related to the reconciliation task, and executing S200;

It should be noted that the merchant routing information table is composed of different parameters. When a new merchant is created, different parameters of the merchant are combined, and corresponding parameters of the merchant are added into the merchant routing information table, and the table is mainly used for Record business information, and record all transaction channel numbers (transaction IDs), task names, and corresponding settlement rules for the merchant. The system can query the merchant information corresponding to the task name in the merchant routing information table by using the task name. The aforementioned merchant routing information table is stored in the form of a form file in a database of the system general module.

S200. Query the merchant management information table according to the merchant information, obtain the merchant configuration information, and execute S300.

The merchant management information table refers to a table containing all basic information of all merchants, including the merchant's reconciliation date, merchant description, clearing cycle, whether to perform order reconciliation, actual reconciliation mode, file interaction mode, and file download mode. And other information. The merchant configuration information refers to the reconciliation execution mode of the specific single merchant recorded in the merchant management information table, such as reconciliation date, merchant description, whether to perform order reconciliation, basic file download mode, actual reconciliation mode, and the like. . The merchant management information table is stored in a database of a general module of the system in the form of a form file.

The system matches the merchant information (including the merchant name, the merchant ID, the channel number, and the like) with the merchant management information table, finds the corresponding merchant from the merchant management information table, and obtains the configuration information of the merchant.

S300. Determine whether the merchant configuration information meets a reconciliation task startup time determination rule, and if yes, execute S400; otherwise, end the method;

According to the reconciliation date in the merchant configuration information, the reconciliation date is extracted, and according to the preset reconciliation task initiation time judging rule, it is determined whether the reconciliation date meets the startup condition, and if yes, S400 is executed, otherwise, S400 is performed; otherwise, If it does not match, the reconciliation will not be started, and the method will be terminated directly, waiting for the next poll.

It should be noted that the timing task start time judgment rule is a judgment rule preset by the system, and is used to determine whether the current date of the system should execute the reconciliation task. As shown in FIG. 2, the step S300 including the reconciliation task start time judging rule specifically includes the following steps:

a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set to a working day, and if so, execute b; otherwise, execute c;

b, determining whether the current date is a working day, and if so, executing S400; otherwise, ending the method;

c. Determine whether the current date is a working day, and if so, end the method; otherwise, execute S400.

S400. Query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;

The reconciliation file interaction routing information table includes specific downloading manners of reconciliation files in all transaction scenarios of all merchants, including merchant number, transaction ID, IP address, user name, password, port number, and target server address. The file reconciliation information refers to the specific reconciliation file download information of a single merchant in a single scenario, including the download address, port number, target server address, and file name of the reconciliation file. The reconciliation file interaction routing information table is stored in a database of a general module of the system in the form of a table.

The merchant number and the transaction ID in the system merchant configuration information, and the specific reconciliation file download information corresponding to the merchant in the scenario (ie, the reconciliation file interaction information) is found in the reconciliation file interaction routing information table, and according to the reconciliation The file interaction information is used to download the corresponding accounting book file (ie, the reconciliation file).

S500, determining, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, executing S700; otherwise, executing S600;

It should be noted that step S500 can be performed immediately after the execution of step S400 is completed.

Preferably, the step S500 and the subsequent steps are performed concurrently with the steps S100 to S400, and the system continuously polls the reconciliation task (every 5 minutes), and if the file is stored in the database, the S700 is continued; otherwise, After the system has been separated by a certain period of time, polling continues.

S600, the system continues to wait for a certain period of time, and returns to execute S500;

It should be noted that the certain time that the system waits may be any manually set time, which may be 5 seconds or 5 minutes, and the specific time is manually based on the needs of the system reconciliation and daily operation. Requires a preset. Preferably, the certain time during which the system continues to wait is set to 5 minutes. Preferably, if the local accounting book file is not stored in the database, the system continues to perform polling. If the latest execution time of the reconciliation task recorded in the timed task parameter table is polled, the reconciliation task has not been started yet. The timeout log is logged by the system, and the reconciliation task is no longer executed on that date.

S700. Obtain the local reconciliation file from the database, and execute S800.

S800. Extract the reconciliation element of the merchant from the merchant configuration information, perform reconciliation of the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file.

Among them, the reconciliation element of the merchant refers to the elements of the reconciliation, such as the name of the merchant, the transaction amount, and the bank account number, which are recorded in the merchant management information table for different reconciliation methods in different scenarios.

It should be noted that the present application uses a plurality of forms such as a basic task parameter list, a merchant routing information table, a merchant management information table, and a reconciliation routing information table (the foregoing table files are stored in a database of the system common module). To realize the configurability of information and parameters, each form is only contacted by some information such as merchant ID and transaction ID, and other elements are stored according to the functions of different forms. Therefore, in the post-maintenance, through flexible combination of parameters such as reconciliation mode and transaction scenario, multiple routes can be configured to implement sub-control reconciliation processing.

In this embodiment, as shown in FIG. 3 and FIG. 4, before the execution of the reconciliation task in the routing control reconciliation method, the following steps are further included:

S101. Start a general scheduling task.

Preferably, the total scheduling task is polled by the system at regular intervals, and concurrent execution is performed between the subsequent steps S1011-S1014.

Preferably, the total scheduled task is polled by the system every 10 minutes.

The system controls the start time of the reconciliation task through the total scheduling task. Specifically, the system general scheduling task performs polling every 10 minutes to obtain basic parameters of all loaded timing tasks in the total scheduling task, and according to the timing The scheduled task start time in the basic parameters of the task is used to start the corresponding scheduled task (such as file download task, reconciliation task, order warehousing task, etc.).

It should be noted that the above-mentioned total scheduling task is completed by a scheduling module in a general module of the system.

S102. Query a basic parameter table of the scheduled task, and obtain basic parameters of the reconciliation task;

The basic task parameter table includes the task name of all the timed tasks, the task execution mode, the task reconciliation date, the task startup time, the task execution time, and the file storage directory. The basic parameters of the reconciliation task include The reconciliation task name, the reconciliation task execution mode, the reconciliation task startup time, the reconciliation task latest execution time, and the reconciliation file storage directory.

It should be noted that the basic task parameter table of the timed task stores basic parameters of all the timed tasks, and includes basic parameters of the reconciliation tasks of all the merchants (the reconciliation task is one of the timing tasks). The reconciliation tasks of all merchants are different. However, in the basic parameters of the reconciliation tasks of all merchants, the reconciliation task startup time and the reconciliation task execution time are the same.

S103, according to the basic parameters of the reconciliation task, determine whether the current time of the system meets the reconciliation task startup time, and if so, execute S104; otherwise, execute S105;

The determining whether the current time of the system meets the recurring task startup time means that after obtaining the basic parameters of the reconciliation task, the system extracts the recurring task startup time parameter from the basic parameters of the reconciliation task, and the current time of the system and the pair The account task startup time is compared. If the current time meets the reconciliation task startup time, then S104 is performed; otherwise, S105 is performed.

S104. Start performing a reconciliation task.

S105, the system continues to wait, and is separated by a certain time, and returns to execute S101;

Preferably, the interval is a certain time of 5 minutes.

Preferably, as shown in FIG. 4, before step S101, the method further includes the following steps:

S1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;

Among them, the system polls the local accounting book warehousing task every 5 minutes, that is, the system starts and executes the local accounting book warehousing task every 5 minutes.

It should be noted that the interval of the above-mentioned local accounting book storage task may be 5 minutes or 10 minutes, and may be any time preset by a manual. For the present embodiment, 5 minutes is the preferred interval of the system.

S1012: Obtain merchant configuration information according to the merchant management information table.

S1013. Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;

According to the configuration information of the merchant, the system filters all transaction flow data in the local accounting book file in the database, and extracts relevant transaction flow data of the relevant merchant in the reconciliation task, and performs the data. The summary is stored in the database as a local reconciliation file that will be reconciled with the merchant accounting book file.

S1014. The data related to the merchant is summarized, and a local reconciliation file is generated and stored in the database.

After the local reconciliation file is completed, the system file storage result is recorded, so that the subsequent system queries whether the file is successfully stored. At the same time, the system will continue to poll at a certain time interval, start the scheduled local accounting book storage task, and download the local reconciliation file related to the merchant.

In an embodiment, in the foregoing method for routing and reconciliation reconciliation, before step 1, the following steps are further included:

Create a new business information management table and enter basic information and configuration information of all merchants.

In the embodiment, the step S400 in the routing control reconciliation method further includes the following steps:

S401: Extract the target server address of the merchant reconciliation file from the reconciliation file interaction information, download and obtain the merchant accounting book file, and execute S402;

S402. Parse the downloaded merchant account book file and store the file in the database.

The parsing module in the system data processing module is configured to parse the downloaded merchant account book file, and obtain the file name, the merchant name, the transaction ID, and the corresponding transaction pipeline data of the accounting book file after parsing.

In this embodiment, before the step 6 in the routing control reconciliation method, the method includes the following steps:

S601. Determine, according to the basic parameters of the reconciliation task, whether the current time of the system has exceeded the latest execution time of the reconciliation task. If yes, execute S602; otherwise, execute S600; the certain time is 5 minutes.

The system obtains the latest execution time of the reconciliation task by querying the basic task parameter list in the database, and compares the current time with the latest execution time, if the current time has exceeded the latest of the scheduled task. Execution time, the system records the timeout log (ie, S602), and the reconciliation task is no longer executed on the date; if the current time has not exceeded the latest execution time of the scheduled task, the system may continue to perform polling (ie, S603).

S602. Record a timeout log of the current reconciliation task, and end the method at the same time;

If the current time of the system has exceeded the latest execution time of the reconciliation task, it indicates that the local accounting book file has not been properly stored in the database. At this time, the system needs to record the error and abandon the reconciliation task. After the time, restart the new polling and reconciliation operations.

In an embodiment, after step 7 in the routing control reconciliation method, the method further includes the following steps:

S800. Acquire, according to the configuration information of the merchant, the merchant reconciliation processing logic control information, filter the data in the reconciliation result file according to the reconciliation processing logic control information, and generate a second reconciliation Result file.

After the system generates the reconciliation result file, the post-management personnel may need to perform data screening on the reconciliation result file based on different requirements. For this reason, the system provides a reconciliation processing logic control table for different post-management personnel. Different requirements, different reconciliation processing logic control information is specified, and the data is filtered to facilitate post-processing personnel to process data.

It should be noted that, in this embodiment, the interaction of the merchant files is basically through the MQ between the system components for message delivery, and the specific file download is implemented in the download component. Therefore, the tasks between the various modules of the system, such as file download tasks, reconciliation tasks, file warehousing tasks, and local file/bill generation tasks, can be executed concurrently so that the tasks of the system are independent of each other. Achieve high efficiency of the system, enabling the system to provide the best and fastest reconciliation solution.

3. A routing control reconciliation system (Figure 5)

Referring to FIG. 5, according to an embodiment of the present application, a route control reconciliation reconciliation system mainly includes a data extraction module 10, a data processing module 20, a file downloading module 30, a reconciliation module 40, and a system general module 50.

The data extraction module 10 includes:

a query module 101 for querying data in a table;

An extraction module 102 for extracting and/or obtaining data and information in a table;

The data processing module 20 is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;

The data processing module 20 includes:

a judging module 201 for judging whether a local accounting book file is stored in a database;

a parsing module 202 for parsing the accounting book;

The file downloading module 30 is configured to download the accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component 301;

The reconciliation module 40 is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;

The system general module 50 is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and the accounting book file;

The system universal module 50 includes:

a scheduling module 501 for scheduling all scheduled tasks and determining and initiating a reconciliation task;

a timer module 502 for performing all timing and timing operations;

A database 503 for storing all data of the method and accounting book files for the storage system.

Furthermore, various embodiments of the present application can also be implemented by a software module or computer readable instructions stored on one or more computer readable medium, where the computer readable instructions are when When executed, the various embodiments described herein are performed. Similarly, any combination of software modules, computer readable media, and hardware components are contemplated by the present application. The software modules can be stored on any type of computer readable storage medium such as RAM, EPROM, EEPROM, flash memory, registers, hard disk, CD-ROM, DVD, and the like.

4. An application-installed system according to an embodiment of the present application

Referring to Figure 6, there is shown an operating environment of a system in which an application is installed, in accordance with an embodiment of the present application.

In this embodiment, the system for installing the application is installed and runs in the electronic device. The electronic device may be a computing device such as a desktop computer, a notebook, a palmtop computer, or a server. The electronic device can include, but is not limited to, a memory, a processor, and a display. Figure 6 shows only the electronic device having the above components, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.

The memory may be an internal storage unit of the electronic device, such as a hard disk or memory of the electronic device, in some embodiments. The memory may also be an external storage device of the electronic device in other embodiments, such as a plug-in hard disk equipped on the electronic device, a smart memory card (SMC), and a secure digital (Secure Digital) , SD) card, flash card (Flash Card), etc. Further, the memory may also include both an internal storage unit of the electronic device and an external storage device. The memory is used to store application software installed on the electronic device and various types of data, such as program code of the system in which the application is installed. The memory can also be used to temporarily store data that has been output or is about to be output.

The processor may, in some embodiments, be a central processing unit (CPU), a microprocessor, or other data processing chip for executing program code or processing data stored in the memory, such as performing the Install the application's system, etc.

The display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch sensor, or the like in some embodiments. The display is for displaying information processed in the electronic device and a user interface for displaying visualizations, such as an application menu interface, an application icon interface, and the like. The components of the electronic device communicate with one another via a system bus.

Through the description of the above embodiments, those skilled in the art can clearly understand that the method in the foregoing embodiment can be implemented by means of software plus a necessary general hardware platform, and can also be implemented by hardware, but in many cases. The former is a better implementation. Based on such understanding, the technical solution of the present application in essence or the contribution to the prior art can be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic The disc, the optical disc, includes a plurality of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method described in the various embodiments of the present application.

That is, according to an embodiment of the present application, there is also provided a computer readable storage medium having stored thereon a program for performing a route sorting reconciliation, the program being processed by a processor When executed, the steps of routing control reconciliation according to an embodiment of the present application are performed.

It will be understood that the specific embodiments of the present invention have been described herein for the purpose of illustration, but the various modifications may be made without departing from the scope of the application. Those skilled in the art will appreciate that the operations and routines depicted in the flowchart steps or described herein can be varied in many ways. More specifically, the order of the steps may be rearranged, the steps may be performed in parallel, the steps may be omitted, other steps may be included, various combinations or omissions of routines may be made. Accordingly, the application is limited only by the accompanying claims.

Claims

A routing control reconciliation method is characterized in that, according to a reconciliation task startup time, a reconciliation task is started, and the reconciliation task comprises the following steps:

Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;

Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;

Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;

Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;

Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;

Step 6, after the system continues to wait for a certain period of time, return to step 5;

Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
The method for routing and reconciliation reconciliation according to claim 1, wherein the step of performing the reconciliation task further comprises the following steps:

Step 101: Query a basic parameter table of the timed task, and obtain basic parameters of the timed task;

The basic parameters of the timed task include the task name of all merchants, the task startup time, and the latest execution time of the task;

Step 103, according to the basic parameters of the timed task, determine whether the current time of the system meets the task start time, if yes, proceed to step 104; otherwise, the system continues to wait, and after a certain time interval, returns to step 101;

Step 104: Start performing a reconciliation task.
The method of reconciliation and reconciliation of a route according to claim 2, wherein before the step 101, the method further comprises the following steps:

Step 1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;

Step 1012: Obtain merchant configuration information according to the merchant management information table.

Step 1013: Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;

Step 1014, summarizing the data related to the merchant, and generating a local reconciliation file, and storing the data in the database.
The route control reconciliation method according to claim 2, wherein the step 3 comprises the following steps:

a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set as the working day, and if so, execute b; otherwise, execute c;

b. Determine whether the current date is a working day, and if yes, perform step 4; otherwise, end the method;

c. Determine whether the current date is a working day. If yes, end the method; otherwise, perform step 4.
The method for reconciliation of a route control according to claim 1, further comprising: creating a new merchant information management table, and inputting basic information and configuration information of all the merchants.
The method of routing control reconciliation according to claim 1, wherein the step 4 further comprises the following steps:

Extracting a target server address of the merchant reconciliation file from the merchant reconciliation file interaction information, and downloading a merchant accounting book file;

The downloaded merchant account book file is parsed and stored in the database.
The route sorting reconciliation method according to claim 2, characterized in that before the step 6, the following steps are included:

According to the basic parameters of the timed task, it is determined whether the current time of the system has exceeded the latest execution time of the task of the merchant reconciliation. If yes, the current reconciliation task is recorded in the timeout log, and the method is terminated. Otherwise, step 6 is performed.
The route control reconciliation method according to claim 2, wherein the certain time is 5 minutes.
The method of reconciliation and reconciliation of a route according to claim 1, wherein after the step 7, the method further comprises the following steps:

Obtaining the merchant reconciliation processing logic control information according to the merchant configuration information.
The routing control reconciliation method according to claim 9, wherein after the step 7, the method further comprises the following steps:

And filtering the data in the reconciliation result file according to the reconciliation processing logic control information, and generating a second reconciliation result file.
A route sub-control reconciliation system, characterized in that the system comprises a data extraction module, a data processing module, a file downloading module, a reconciliation module and a system general module.

The data extraction module is configured to extract and/or acquire data in a table and a task, and perform query in other tables according to the extracted data, and extract corresponding information;

The data extraction module includes:

a query module for querying data in a table;

An extraction module for extracting and/or obtaining data and information in a form;

The data processing module is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;

The data processing module includes:

a judging module for judging whether a local accounting book file is stored in a database;

a parsing module for parsing accounting books;

The file downloading module is configured to download an accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component;

The reconciliation module is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;

The system universal module is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and accounting book files;

The system universal module includes:

a scheduling module for scheduling all scheduled tasks and determining and initiating reconciliation tasks;

a timer module for performing all timing and timing operations;

A database used to store the data required by the system to perform this method, as well as accounting book files.
A computer readable storage medium, wherein the computer readable storage medium stores a program for executing a route sorting and reconciliation method, and when the program is executed by the processor, performing the steps of the method ,include:

Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;

Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;

Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;

Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;

Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;

Step 6, after the system continues to wait for a certain period of time, return to step 5;

Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
The computer readable storage medium of claim 12, further comprising the steps of: before initiating the reconciliation task:

Step 101: Query a basic parameter table of the timed task, and obtain basic parameters of the timed task;

The basic parameters of the timed task include the task name of all merchants, the task startup time, and the latest execution time of the task;

Step 103, according to the basic parameters of the timed task, determine whether the current time of the system meets the task start time, if yes, proceed to step 104; otherwise, the system continues to wait, and after a certain time interval, returns to step 101;

Step 104: Start performing a reconciliation task.
The computer readable storage medium according to claim 13, wherein before the step 101, the method further comprises the following steps:

Step 1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;

Step 1012: Obtain merchant configuration information according to the merchant management information table.

Step 1013: Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;

Step 1014, summarizing the data related to the merchant, and generating a local reconciliation file, and storing the data in the database.
The computer readable storage medium of claim 13, wherein the step 3 comprises the steps of:

a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set as the working day, and if so, execute b; otherwise, execute c;

b. Determine whether the current date is a working day, and if yes, perform step 4; otherwise, end the method;

c. Determine whether the current date is a working day. If yes, end the method; otherwise, perform step 4.
The computer readable storage medium according to claim 12, further comprising: before the step 1, the new merchant information management table is configured to input basic information and configuration information of all the merchants.
The computer readable storage medium of claim 12, wherein the step 4 further comprises the steps of:

Extracting a target server address of the merchant reconciliation file from the merchant reconciliation file interaction information, and downloading a merchant accounting book file;

The downloaded merchant account book file is parsed and stored in the database.
The computer readable storage medium according to claim 13, wherein before said step 6, the following steps are included:

According to the basic parameters of the timed task, it is determined whether the current time of the system has exceeded the latest execution time of the task of the merchant reconciliation. If yes, the current reconciliation task is recorded in the timeout log, and the method is terminated. Otherwise, step 6 is performed.
The computer readable storage medium of claim 13, wherein the certain time is 5 minutes.
The computer readable storage medium according to claim 12, wherein after the step 7, the method further comprises the steps of:

Obtaining, according to the merchant configuration information, the logic control information of the merchant reconciliation processing,

Based on the reconciliation processing logic control information, the data in the reconciliation result file is filtered and a second reconciliation result file is generated.