CN109739934B - Difference set account checking method, medium, computer equipment and system - Google Patents
Difference set account checking method, medium, computer equipment and system Download PDFInfo
- Publication number
- CN109739934B CN109739934B CN201910017308.XA CN201910017308A CN109739934B CN 109739934 B CN109739934 B CN 109739934B CN 201910017308 A CN201910017308 A CN 201910017308A CN 109739934 B CN109739934 B CN 109739934B
- Authority
- CN
- China
- Prior art keywords
- order
- information
- order number
- reconciliation
- order data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Abstract
The invention discloses a differential reconciliation method, a medium, computer equipment and a system, wherein the method comprises the following steps: acquiring and storing first order data; reading first order data, performing format conversion to generate first standardized information, and storing the first standardized information to a Redis database; receiving an account checking request instruction, and generating an account checking request message so as to feed back a bill downloading address through a payment channel; downloading the statement of account file, analyzing to obtain second order data, and performing format conversion to generate second standardized information; storing the second standardized information into a Redis database, and extracting order numbers of each second standardized information to generate a channel order number set; generating a local order number set, and performing difference set calculation to obtain a difference order number set; the method and the device can realize rapid reading and analysis of mass data, improve account checking efficiency, reduce pressure of the database and ensure normal operation of the system when processing the mass data.
Description
Technical Field
The invention relates to the technical field of bill checking, in particular to a differential reconciliation method, medium, computer equipment and system.
Background
In the conventional reconciliation method, batch circulation is mostly carried out on data tables in a local database, then the same single number is searched and compared from a temporary table one by one, then marking processing is carried out on the data and the single-side data which are not compared, and then the temporary table and the local database are traversed to obtain marking abnormal data.
However, when the reconciliation method is used for processing the high-level data, a large amount of reconciliation time is often needed due to the huge data volume of the reconciliation data, the reconciliation efficiency is low, and the pressure of the database is high due to the reconciliation method, so that the service of the database is easily stopped due to the overlarge data volume.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the art described above. Therefore, one objective of the present invention is to provide a differential reconciliation method, which can realize fast reading and analysis of mass data, perform differential reconciliation on a plurality of order data in a standardized form, improve reconciliation efficiency, reduce database pressure, and ensure normal operation of a system when processing mass data.
A second object of the invention is to propose a computer-readable storage medium.
A third object of the invention is to propose a computer device.
A fourth object of the present invention is to provide a differential reconciliation system.
In order to achieve the above object, an embodiment of a first aspect of the present invention provides a differential reconciliation method, including the following steps: acquiring first order data and storing the first order data into a reconciliation library, wherein the first order data comprises a user ID, a payment channel and transaction information; reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key; receiving an account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; downloading an account checking file according to the bill downloading address, analyzing the account checking file to obtain second order data, and performing format conversion on the second order data to generate second standardized information; storing the second standardized information into the Redis database according to the order number and the channel mark in the second order data as a key, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set; and performing order number extraction on each piece of first standardized information in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information.
The difference set reconciliation method comprises the following steps of: firstly, acquiring first order data and storing the first order data into a reconciliation library, wherein the first order data comprises a user ID, a payment channel and transaction information; then, reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key; then, receiving an account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; then, downloading the account checking file according to the bill downloading address, analyzing the bill file to obtain second order data, and performing format conversion on the second order data to generate second standardized information; then, storing second standardized information into a Redis database according to the order number and the channel mark in the second order data as keys, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set; then, extracting order numbers of each first piece of standardized information in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information; therefore, mass data can be rapidly read and analyzed, difference account checking is carried out on a plurality of order data in a standardized mode, account checking efficiency is improved, meanwhile, the pressure of a database is reduced, and normal operation of a system during mass data processing is guaranteed.
In addition, the difference set reconciliation method proposed according to the above embodiment of the present invention may further have the following additional technical features:
optionally, the method further includes querying each first standardized message in the Redis database according to the order number in the differential order number set and the local flag being key to obtain the transaction information in the successful state, and writing order data corresponding to the transaction information in the successful state into the error record table.
Optionally, the method further comprises changing the transaction information in the success state into failure transaction information according to the order number in the error record table.
Optionally, the first standardized information and the second standardized information are json format character strings.
To achieve the above object, a second embodiment of the present invention provides a computer-readable storage medium, on which a difference set reconciliation program is stored, which, when executed by a processor, implements the difference set reconciliation method described above.
To achieve the above object, a third embodiment of the present invention provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the difference reconciliation method as described above.
In order to achieve the above object, a fourth aspect of the present invention provides a differential reconciliation system, including: the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first order data, and the first order data comprises a user ID, a payment channel and transaction information; the storage module is used for storing the first order data to the reconciliation library; the reading module is used for reading first order data in the reconciliation library; the format conversion module is used for carrying out format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key; the receiving module is used for receiving the account checking request instruction; the message generation module is used for generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; the analysis module is used for downloading the statement of account file according to the statement of account downloading address and analyzing the statement of account file to obtain second order data; the format conversion module is also used for carrying out format conversion on the second order data to generate second standardized information, and storing the second standardized information into a Redis database according to the order number and the channel mark in the second order data as a key; the extraction module is used for carrying out order number extraction on each piece of second standardized information in the Redis database to generate a channel order number set and carrying out order number extraction on each piece of first standardized information in the Redis database to generate a local order number set; and the account checking module is used for carrying out difference set calculation on the channel order number set and the local order number set so as to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information.
The difference set reconciliation system according to the embodiment of the invention comprises: the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first order data, and the first order data comprises a user ID, a payment channel and transaction information; the storage module is used for storing the first order data to the reconciliation library; the reading module is used for reading first order data in the reconciliation library; the format conversion module is used for carrying out format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to the order number and the local mark in the transaction information as a key; the receiving module is used for receiving the account checking request instruction; the message generation module is used for generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; the analysis module is used for downloading the statement bill file according to the bill downloading address and analyzing the statement bill file to obtain second order data; the format conversion module is also used for carrying out format conversion on the second order data to generate second standardized information, and storing the second standardized information into a Redis database according to the order number and the channel mark in the second order data as a key; the extraction module is used for carrying out order number extraction on each piece of second standardized information in the Redis database to generate a channel order number set and carrying out order number extraction on each piece of first standardized information in the Redis database to generate a local order number set; the account checking module is used for carrying out difference set calculation on the channel order number set and the local order number set so as to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information; therefore, mass data can be rapidly read and analyzed, difference account checking is carried out on a plurality of order data in a standardized mode, account checking efficiency is improved, meanwhile, the pressure of a database is reduced, and normal operation of a system during mass data processing is guaranteed.
In addition, the difference set reconciliation system provided by the above embodiment of the invention can also have the following additional technical features:
optionally, the reconciliation module is further configured to, according to the order number in the difference order number set and the local flag being a key, query each piece of first standardized information in the Redis database to obtain transaction information in a successful state, and write order data corresponding to the transaction information in the successful state into the error record table.
Optionally, the reconciliation module is further configured to change the transaction information in the successful state into the failed transaction information according to the order number in the error record table.
Optionally, the first standardized information and the second standardized information are json format character strings.
Drawings
Fig. 1 is a flow chart illustrating a difference set reconciliation method according to an embodiment of the invention;
fig. 2 is a schematic flow chart of a difference set reconciliation method according to another embodiment of the invention;
fig. 3 is a block diagram of a difference set reconciliation system according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
In the existing reconciliation method, the processing efficiency of the large-scale data is low, the pressure of the processing mode on the database is high, and the service of the database is easily stopped, and the difference set reconciliation method comprises the following steps: firstly, acquiring first order data and storing the first order data into a reconciliation library, wherein the first order data comprises a user ID, a payment channel and transaction information; then, reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key; then, receiving an account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; then, downloading the account checking file according to the bill downloading address, analyzing the bill file to obtain second order data, and performing format conversion on the second order data to generate second standardized information; then, storing second standardized information into a Redis database according to the order number and the channel mark in the second order data as a key, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set; then, extracting order numbers of each first piece of standardized information in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information; therefore, mass data can be rapidly read and analyzed, difference account checking is carried out on a plurality of order data in a standardized mode, account checking efficiency is improved, meanwhile, the pressure of a database is reduced, and normal operation of a system during mass data processing is guaranteed.
In order to better understand the above technical solutions, exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
In order to better understand the technical scheme, the technical scheme is described in detail in the following with reference to the attached drawings of the specification and specific embodiments.
Fig. 1 is a schematic flow chart of a difference set reconciliation method according to an embodiment of the present invention, and as shown in fig. 1, the difference set reconciliation method includes:
s101, first order data are obtained and stored in a reconciliation library, wherein the first order data comprise a user ID, a payment channel and transaction information.
That is, the first order data is acquired, and after the first order data is acquired, the first order data is stored in the reconciliation library.
As an example, the database includes a plurality of merchant IDs and order information corresponding to payment channels corresponding to the merchant IDs, so that first order data is acquired through an sql script, specifically, first, order information of a merchant "a001" and a payment channel "payment treasure" is copied according to an acquisition instruction through the sql script, and then, the copied order information is stored in an account checking library as the first order data; the sql script refers to a command set formed by combining sql statements, and the sql statements may be: select from, update table set, delete from, etc., and the specific writing of the sql statement is not limited herein.
S102, reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database by taking an order number and a local mark in the transaction information as a key.
That is to say, the reconciliation library is read to extract the first order data therein, then the format of the first order data is converted to generate the first standardized information, and the first standardized information is stored in the Redis database by taking the order number and the local mark in the transaction information as a key, so that the format standardization setting is performed on the first order data, the reconciliation efficiency in the process of processing the mass data can be accelerated, and the operating pressure of the server can be reduced.
As an example, the first standardized information is a json-format string, where json format is a lightweight data exchange format that stores and represents data in a text format that is completely independent of programming language based on a subset of ECMAScript (js Specification set by the European computer Association). The method is easy for machine analysis and generation, and can effectively improve the network transmission efficiency, thereby further accelerating the account checking efficiency of the difference account checking method.
As an example, first order data of the reconciliation library is read, each piece of order information in the first order data is converted into a json format character string, and then each order is stored into the Redis database one by one with an order number + local as a key.
S103, receiving the account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that the server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message.
That is, account checking request instructions sent by different users are received, corresponding account checking request messages are generated according to the account checking request instructions, the payment channels and the user IDs, and then the account checking request messages are sent to the corresponding payment channels, so that the payment channels can feed back bill downloading addresses after receiving the account checking request messages.
The reconciliation request instruction can be automatically generated by the system according to preset logic or generated by the user according to the self query requirement.
As an example, when a user needs to query a bill of a merchant ID, the user ID, a payment channel corresponding to the bill to be queried, and a time interval during which the bill to be queried is generated are input through an external device, a corresponding reconciliation request instruction is generated, and the reconciliation request instruction is sent to a platform.
As another example, the platform presets the reconciliation frequency, specifically, when the reconciliation frequency is checking daily, and is 0 am every day, the platform generates a reconciliation request instruction according to each user ID and a payment channel included in each user ID, generates a corresponding reconciliation request message after the reconciliation request instruction is generated, and sends the reconciliation request message to a corresponding payment channel, so that each payment channel returns a bill download address after receiving the reconciliation request message.
And S104, downloading the statement bill file according to the bill downloading address, analyzing the statement bill file to obtain second order data, and performing format conversion on the second order data to generate second standardized information.
That is to say, the bill file is downloaded, and after the download is completed, the bill file is analyzed to obtain second order data, wherein the second order data includes each transaction information, the user ID and the payment channel requested in the statement checking request message, and then after the second order data is obtained through analysis, the format of the second order data is converted to generate second standardized information; therefore, the second order data are subjected to standardized processing, and the account checking efficiency of the difference account checking method in the process of processing mass data is further improved.
As an example, the bill is downloaded according to a bill downloading address returned by a payment channel, after the downloading is completed, the bill file is analyzed line by line to obtain each piece of order information therein, and format conversion is performed on each piece of order information to convert the order information into a json format character string, so that the account checking efficiency of the difference account checking method for processing the mass data is improved.
S105, storing the second standardized information into a Redis database according to the order number and the channel mark in the second order data as a key, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set.
That is, after the standardized format conversion is performed on each piece of order information in the second order data, the order number and the channel mark in the second order data are taken as a key, the second standardized information is stored in the Redis database, and the order number extraction is performed on each piece of second standardized information in the Redis database to generate a channel order number set.
As an example, after completing the conversion of the second order data and generating the second standardized information, storing each piece of order information in the Redis database by taking "order number + channel" as key, then parsing the order number in each piece of order information in the second standardized information and saving to the list "orders", and storing the order number in the Redis database by taking "key, list", wherein the key is "ids _ channel"; thus, the process of extracting the order number in the second standardized information to generate the channel order number set is completed.
S106, extracting the order number of each first standardized message in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized message but does not exist in the second standardized message.
That is, the first standardized information stored in the Redis database is read to obtain the order numbers contained in each piece of the first standardized information, and a local order number set is generated from the extracted order numbers, and then, a difference set calculation is performed on the channel order number set and the local order number set to obtain a difference order number set that exists in the first standardized information but does not exist in the second standardized information.
As an example, an order number in the first standardized information in the reconciliation library is read into a memory and is stored into a Redis database in a "key, list" manner, wherein the key is "ids _ local"; then, by the sdiff method in Redis, performing difference set calculation on the set "ids _ local" and the set "ids _ channel" to find out a difference set of difference order numbers between the order numbers in the first standardized information and the order numbers in the second standardized information, and storing the order numbers in the first standardized order which do not exist in the second standardized information into a difference order number difference set "difference _ set"; therefore, the purpose of quickly checking bills of the first standardized information and the second standardized information through difference calculation is achieved.
As shown in fig. 2, in some embodiments, in order to make the difference set reconciliation method provided in the embodiment of the present invention more fit with the use requirements of the user, and further enhance the reconciliation effect of the difference set reconciliation method, the difference set reconciliation method provided in the embodiment of the present invention further includes:
s107, inquiring each first standardized message in the Redis database to obtain the transaction information in the successful state according to the order number and the local mark in the difference order number set as a key, and writing order data corresponding to the transaction information in the successful state into an error record table.
And S108, changing the transaction information in the successful state into failure transaction information according to the order number in the error record table.
That is, after forming the difference order number difference set "difference _ set", with the order number and the local flag in the difference order number difference set "difference _ set" as key, querying the first standardized information in the Redis database to obtain the order number corresponding to the transaction information of which the transaction information is in the successful state in the first standardized information by the order number in the difference order number difference set "difference _ set", writing the order data corresponding to the transaction information in the successful state into the error record table, and then changing the transaction information in the successful state into failed transaction information according to the order number in the error record table; it should be noted that before the transaction information in the successful state is changed into the failed transaction information, the difference result may be further audited according to the order information to find the cause of the error, where the auditing action may be manual auditing or automatic auditing according to a preset auditing policy of the system.
As an example, after forming the difference order number difference set "difference _ set", the Redis database is queried with "order number + local" as key to obtain the transaction information in the first standardized information corresponding to the order number in the difference order number difference set in the Redis database, and the transaction information in the success state is intercepted, and the transaction information in the success state is written into the error record table, and then the transaction information in the account base is updated with the order number in the difference order number difference set "difference _ set" as condition to change the transaction information in the success state to the failure state.
In summary, the difference set reconciliation method according to the embodiment of the invention includes the following steps: firstly, acquiring first order data and storing the first order data into a reconciliation library, wherein the first order data comprises a user ID, a payment channel and transaction information; reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key; then, receiving an account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel feeds back a bill downloading address according to the account checking request message; then, downloading the account checking file according to the bill downloading address, analyzing the bill file to obtain second order data, and performing format conversion on the second order data to generate second standardized information; then, storing second standardized information into a Redis database according to the order number and the channel mark in the second order data as keys, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set; then, extracting order numbers of each first piece of standardized information in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information; therefore, mass data can be rapidly read and analyzed, difference account checking is carried out on a plurality of order data in a standardized mode, account checking efficiency is improved, meanwhile, the pressure of a database is reduced, and normal operation of a system during mass data processing is guaranteed.
In order to implement the above embodiment, an embodiment of the present invention further provides a computer-readable storage medium, on which a difference set reconciliation program is stored, which, when executed by a processor, implements the above-mentioned difference set reconciliation method.
In order to implement the foregoing embodiments, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and is characterized in that when the processor executes the program, the difference set reconciliation method as described above is implemented.
In order to implement the foregoing embodiment, an embodiment of the present invention further provides a differential reconciliation system, as shown in fig. 3, where the differential reconciliation system includes: the system comprises an acquisition module 10, a storage module 20, a reading module 30, a format conversion module 40, a receiving module 50, a message generation module 60, an analysis module 70, an extraction module 80 and a reconciliation module 90.
The obtaining module 10 is configured to obtain first order data, where the first order data includes a user ID, a payment channel, and transaction information.
The storage module 20 is used for storing the first order data into the reconciliation library;
a reading module 30, configured to read first order data in the reconciliation library;
the format conversion module 40 is used for performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to the order number and the local mark in the transaction information as a key;
a receiving module 50, configured to receive an account checking request instruction;
a message generating module 60, configured to generate an account checking request message according to the account checking request instruction, the payment channel, and the user ID, so that a server corresponding to the payment channel feeds back a bill downloading address according to the account checking request message;
the analysis module 70 is configured to download the statement bill file according to the bill download address, and analyze the statement bill file to obtain second order data;
the format conversion module 40 is further configured to perform format conversion on the second order data to generate second standardized information, and store the second standardized information into a Redis database according to an order number and a channel identifier in the second order data as a key;
the extraction module 80 is configured to extract an order number from each piece of second standardized information in the Redis database to generate a channel order number set, and extract an order number from each piece of first standardized information in the Redis database to generate a local order number set;
a reconciliation module 90 for performing a difference set calculation on the channel order number set and the local order number set to obtain a difference order number set that exists in the first standardized information but does not exist in the second standardized information.
In some embodiments, in order to make the difference set reconciliation method provided in the embodiments of the present invention more fit with the use requirements of the user and further enhance the reconciliation effect of the difference set reconciliation method, the reconciliation module 90 is further configured to query each first standardized message in the Redis database according to the order number and the local flag in the difference order number set as a key to obtain the transaction information in the successful state, and write the order data corresponding to the transaction information in the successful state into the error record table; and changing the transaction information in the success state into failure transaction information according to the order number in the error record table.
In some embodiments, in order to further improve the tie-out efficiency of the difference tie-out system when processing a large amount of data, the first standardized information and the second standardized information are json format character strings.
It should be noted that the above description about the difference set reconciliation method in fig. 1 is also applicable to the difference set reconciliation system, and is not repeated herein.
To sum up, the difference set reconciliation system according to the embodiment of the present invention includes: the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first order data, and the first order data comprises a user ID, a payment channel and transaction information; the storage module is used for storing the first order data to the reconciliation library; the reading module is used for reading first order data in the reconciliation library; the format conversion module is used for carrying out format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to the order number and the local mark in the transaction information as a key; the receiving module is used for receiving the account checking request instruction; the message generating module is used for generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message; the analysis module is used for downloading the statement bill file according to the bill downloading address and analyzing the statement bill file to obtain second order data; the format conversion module is also used for carrying out format conversion on the second order data to generate second standardized information, and storing the second standardized information into a Redis database according to the order number and the channel mark in the second order data as a key; the extraction module is used for carrying out order number extraction on each piece of second standardized information in the Redis database to generate a channel order number set and carrying out order number extraction on each piece of first standardized information in the Redis database to generate a local order number set; the account checking module is used for carrying out difference set calculation on the channel order number set and the local order number set so as to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information; therefore, mass data can be quickly read and analyzed, difference reconciliation is carried out on a plurality of order data in a standardized form, the reconciliation efficiency is improved, meanwhile, the pressure of a database is reduced, and the normal operation of the system during mass data processing is ensured.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It should be noted that in the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including the preferred embodiment and all changes and modifications that fall within the scope of the invention.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
In the description of the present invention, it is to be understood that the terms "first", "second", and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or to imply that the number of technical features indicated are in fact significant. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless specifically defined otherwise.
In the present invention, unless otherwise explicitly stated or limited, the terms "mounted," "connected," "fixed," and the like are to be construed broadly, e.g., as being permanently connected, detachably connected, or integral; can be mechanically or electrically connected; either directly or indirectly through intervening media, either internally or in any other relationship. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
In the present invention, unless otherwise expressly stated or limited, the first feature "on" or "under" the second feature may be directly contacting the first and second features or indirectly contacting the first and second features through an intermediate. Also, a first feature "on," "over," and "above" a second feature may be directly or diagonally above the second feature, or may simply indicate that the first feature is at a higher level than the second feature. A first feature being "under," "below," and "beneath" a second feature may be directly under or obliquely under the first feature, or may simply mean that the first feature is at a lesser elevation than the second feature.
In the description of the specification, reference to the description of "one embodiment," "some embodiments," "an example," "a specific example," or "some examples" or the like means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the terminology used in the description presented above should not be understood as necessarily referring to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (10)
1. A differential reconciliation method is characterized by comprising the following steps:
acquiring first order data and storing the first order data into a reconciliation library, wherein the first order data comprises a user ID, a payment channel and transaction information;
reading first order data in the reconciliation library, performing format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to an order number and a local mark in the transaction information as a key;
receiving an account checking request instruction, and generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message;
downloading an account checking file according to the bill downloading address, analyzing the account checking file to obtain second order data, and performing format conversion on the second order data to generate second standardized information;
storing the second standardized information into the Redis database according to the order number and the channel mark in the second order data as a key, and extracting the order number of each second standardized information in the Redis database to generate a channel order number set;
performing order number extraction on each piece of first standardized information in the Redis database to generate a local order number set, and performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information;
wherein, obtaining the first order data comprises:
and copying corresponding order information in a database according to the acquisition instruction through an sql script to use the copied order information as first order data, wherein the database comprises a plurality of merchant IDs and order information corresponding to payment channels corresponding to the merchant IDs.
2. The difference set reconciliation method of claim 1 further comprising:
and inquiring each first standardized message in the Redis database according to the order number and the local mark in the difference order number set as a key to obtain the transaction information in the successful state, and writing order data corresponding to the transaction information in the successful state into an error record table.
3. The difference set reconciliation method of claim 2 further comprising:
and changing the transaction information in the successful state into failure transaction information according to the order number in the error record table.
4. The difference set reconciliation method of any of claims 1-3 wherein the first normalized information and the second normalized information are json format strings.
5. A computer-readable storage medium, having stored thereon a difference set reconciliation program which, when executed by a processor, implements a difference set reconciliation method as defined in any one of claims 1-4.
6. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor, when executing the program, implements the difference reconciliation method according to any one of claims 1 to 4.
7. A differential reconciliation system, comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first order data, and the first order data comprises a user ID, a payment channel and transaction information;
the storage module is used for storing the first order data to a reconciliation library;
the reading module is used for reading the first order data in the reconciliation library;
the format conversion module is used for carrying out format conversion on the first order data to generate first standardized information, and storing the first standardized information into a Redis database according to the order number and the local mark in the transaction information as a key;
the receiving module is used for receiving the account checking request instruction;
the message generation module is used for generating an account checking request message according to the account checking request instruction, the payment channel and the user ID so that a server corresponding to the payment channel can feed back a bill downloading address according to the account checking request message;
the analysis module is used for downloading the reconciliation document according to the bill downloading address and analyzing the reconciliation document to obtain second order data;
the format conversion module is further used for carrying out format conversion on the second order data to generate second standardized information, and storing the second standardized information into the Redis database according to an order number and a channel mark in the second order data as a key;
the extraction module is used for carrying out order number extraction on each piece of second standardized information in the Redis database to generate a channel order number set and carrying out order number extraction on each piece of first standardized information in the Redis database to generate a local order number set;
a reconciliation module for performing difference set calculation on the channel order number set and the local order number set to obtain a difference order number set which exists in the first standardized information but does not exist in the second standardized information;
wherein acquiring the first order data comprises:
and copying corresponding order information in a database according to the acquisition instruction through an sql script to use the copied order information as first order data, wherein the database comprises a plurality of merchant IDs and order information corresponding to payment channels corresponding to the merchant IDs.
8. The difference set reconciliation system of claim 7, wherein the reconciliation module is further configured to, according to the order number in the difference order number set and a key of the local flag, query each piece of first standardized information in the Redis database to obtain the transaction information in the successful state, and write order data corresponding to the transaction information in the successful state into the error log table.
9. The difference set reconciliation system of claim 8 wherein the reconciliation module is further configured to change the transaction information in the successful state to the failed transaction information based on the order number in the error log table.
10. The difference set reconciliation system of any of claims 7-9 wherein the first normalized information and the second normalized information are json format strings.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910017308.XA CN109739934B (en) | 2019-01-08 | 2019-01-08 | Difference set account checking method, medium, computer equipment and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910017308.XA CN109739934B (en) | 2019-01-08 | 2019-01-08 | Difference set account checking method, medium, computer equipment and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109739934A CN109739934A (en) | 2019-05-10 |
| CN109739934B true CN109739934B (en) | 2023-03-24 |
Family
ID=66363940
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910017308.XA Active CN109739934B (en) | 2019-01-08 | 2019-01-08 | Difference set account checking method, medium, computer equipment and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109739934B (en) |
Families Citing this family (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110188103A (en) * | 2019-05-27 | 2019-08-30 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110197424A (en) * | 2019-05-31 | 2019-09-03 | 上海银行股份有限公司 | Reconciliation plateform system based on Redis |
| CN110188136A (en) * | 2019-06-10 | 2019-08-30 | 四川长虹电器股份有限公司 | A kind of modularization reconciliation system and its account checking method based on bank-corporate express |
| CN110298740A (en) * | 2019-06-24 | 2019-10-01 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110544080A (en) * | 2019-07-03 | 2019-12-06 | 威富通科技有限公司 | payment reconciliation method and server |
| CN110443690A (en) * | 2019-08-15 | 2019-11-12 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of variance data reconciliation |
| CN110599318A (en) * | 2019-08-29 | 2019-12-20 | 凡普数字技术有限公司 | Account checking method, account checking device and storage medium |
| CN110751550B (en) * | 2019-10-12 | 2022-09-13 | 未鲲(上海)科技服务有限公司 | Account checking method and device, computer equipment and storage medium |
| CN111125117A (en) * | 2019-12-27 | 2020-05-08 | 中国银行股份有限公司 | Account checking processing method and device |
| CN111199373A (en) * | 2019-12-30 | 2020-05-26 | 上海东普信息科技有限公司 | Logistics order management method, storage medium and electronic equipment |
| CN111476672B (en) * | 2020-04-16 | 2023-07-14 | 中国大地财产保险股份有限公司 | Data processing method, device, equipment and readable storage medium |
| CN112671821B (en) * | 2020-08-17 | 2023-04-18 | 紫光云技术有限公司 | Cloud computing network equipment configuration difference comparison method |
| CN112069260A (en) * | 2020-09-09 | 2020-12-11 | 中国人民银行清算总中心 | Data storage and account checking method and system |
| CN112270537B (en) * | 2020-10-29 | 2022-01-25 | 广东通莞科技股份有限公司 | Multi-channel bill storage method, system and storage medium |
| CN112258191A (en) * | 2020-12-22 | 2021-01-22 | 深圳市深圳通有限公司 | Data reconciliation method, device, equipment and storage medium |
| CN113065927A (en) * | 2021-04-13 | 2021-07-02 | 北京健康之家科技有限公司 | Account checking method and device, electronic equipment and computer readable storage medium |
| CN113269554B (en) * | 2021-05-12 | 2022-11-18 | 河北幸福消费金融股份有限公司 | Data comparison method, system and storage medium |
| CN113469797A (en) * | 2021-06-30 | 2021-10-01 | 深圳汇商通盈科技有限公司 | Account checking method and device, electronic equipment and storage medium |
| CN113554440A (en) * | 2021-09-18 | 2021-10-26 | 深圳市深圳通有限公司 | Data reconciliation method, device, equipment and storage medium |
| CN114356454A (en) * | 2022-01-06 | 2022-04-15 | 京东科技控股股份有限公司 | Account checking data processing method, account checking data processing device, account checking data storage medium and program product |
| CN114385367B (en) * | 2022-01-14 | 2022-11-01 | 黑龙江省政务大数据中心 | Resource management system based on cloud management platform |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180089647A1 (en) * | 2016-09-27 | 2018-03-29 | Mastercard International Incorporated | System and method for electronically providing electronic transaction records |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN107909495A (en) * | 2017-12-22 | 2018-04-13 | 泰康保险集团股份有限公司 | A kind of account checking method, system, medium, electronic equipment |
| CN108985888B (en) * | 2018-07-02 | 2022-04-12 | 上海瀚之友信息技术服务有限公司 | Account checking system and account checking method |
-
2019
- 2019-01-08 CN CN201910017308.XA patent/CN109739934B/en active Active
Non-Patent Citations (1)
| Title |
|---|
| redis实现对账(集合比较)功能;san.hang;《CSDN博客》;20180620;第1页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109739934A (en) | 2019-05-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109739934B (en) | Difference set account checking method, medium, computer equipment and system | |
| US11163744B2 (en) | Test data generation and scale up for database testing using unique common factor sequencing | |
| CN108932257B (en) | Multi-dimensional data query method and device | |
| CN110443552B (en) | Method and device for automatically transmitting product main data information | |
| US20180260312A1 (en) | Test selection for application commit | |
| CN111078657A (en) | Service log query method, system, medium and equipment of distributed system | |
| CN110275861A (en) | Date storage method and device, storage medium, electronic device | |
| CN108595324A (en) | Test cases reuse management method and system | |
| CN201402459Y (en) | Test case management device | |
| CN107783974B (en) | Data processing system and method | |
| US20120290560A1 (en) | Mechanism for efficiently querying application binary interface/application programming interface-related information | |
| CN109299352B (en) | Method and device for updating website data in search engine and search engine | |
| CN107609151A (en) | The method that XBRL instance documents caching is realized based on Redis | |
| CN112965912B (en) | Interface test case generation method and device and electronic equipment | |
| CN110442371A (en) | A kind of method, apparatus of release code, medium and computer equipment | |
| CN109947739B (en) | Data source management method and device | |
| CN115757479A (en) | Database query optimization method, machine-readable storage medium and computer device | |
| CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model | |
| CN111352824B (en) | Test method and device and computer equipment | |
| CN109241515B (en) | Method and device for generating report file | |
| CN110928946A (en) | Document editing method and device and terminal equipment | |
| US8423532B1 (en) | Managing data indexed by a search engine | |
| CN114154944B (en) | Business auditing method, equipment and computer readable storage medium | |
| CN110795297B (en) | Electronic equipment testing method and device | |
| CN111639478B (en) | Automatic data auditing method and system based on EXCEL document |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |