CN112541750B - Data processing method, device, equipment and computer readable storage medium - Google Patents
Data processing method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN112541750B CN112541750B CN202011424046.8A CN202011424046A CN112541750B CN 112541750 B CN112541750 B CN 112541750B CN 202011424046 A CN202011424046 A CN 202011424046A CN 112541750 B CN112541750 B CN 112541750B
- Authority
- CN
- China
- Prior art keywords
- payment information
- payment
- merchant
- order
- orders
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/085—Payment architectures involving remote charge determination or related payment systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Abstract
The present disclosure provides a data processing method, apparatus, device, and computer readable storage medium, the method comprising: and acquiring first payment information corresponding to each merchant in a preset time interval from a preset database, and second payment information corresponding to each merchant in the preset time interval provided by a payment company, comparing the first payment information and the second payment information to obtain a comparison result, and correcting the first payment information according to the comparison result to obtain corrected target payment information. The method and the device have the advantages that manual account checking is not needed, and the problems that manual account checking data are difficult to check and the error rate is high are effectively solved. In addition, by adopting the data processing method, the data can be stored in a preset database, and the data comparison is carried out in the database, so that a large amount of data searching work is not needed, and the processing efficiency of the reconciliation link is remarkably improved.
Description
Technical Field
The embodiments of the present disclosure relate to the field of information technologies, and in particular, to a data processing method, apparatus, device, and computer readable storage medium.
Background
With the development of mobile internet technology, electronic commerce has been expanding, and online payment has become increasingly important for reconciliation. Checking accounts refers to checking accounts, confirming transaction details in a certain period by a merchant and a payment company, generating a statement for the merchant to download, and paying the merchant for payment.
In the prior art, a large amount of data needs to be searched during checking, and when the checking results are different, the checking process needs to be performed manually.
However, when checking out is performed in the above-described manner, the manual processing error rate is high, the data checking is difficult, and the checking out process is long.
Disclosure of Invention
The embodiment of the disclosure provides a data processing method, a device, equipment and a computer readable storage medium, and the method solves the technical problems of high manual checking error rate, difficult data checking and long checking process in the prior art.
In a first aspect, an embodiment of the present disclosure provides a data processing method, including:
acquiring first payment information corresponding to each merchant in a preset time interval from a preset database, and second payment information corresponding to each merchant in the preset time interval provided by a payment company, wherein the first payment information comprises an order for a user to finish payment through identifying a preset payment interface corresponding to the merchant and a first payment amount corresponding to the order, and the second payment information is the order actually received by the payment company and a second payment amount corresponding to the order;
Comparing the first payment information and the second payment information to obtain a comparison result;
and carrying out correction operation on the first payment information according to the comparison result to obtain corrected target payment information.
Further, according to the method as described above, the correcting operation for the first payment information according to the comparison result includes:
if the first payment information is the same as the second payment information, the first payment information is used as the target payment information;
if the number of orders in the first payment information exceeds the number of orders in the second payment information, determining a first to-be-processed order which exists in the first payment information and does not exist in the second payment information, deleting the first to-be-processed order and the payment amount corresponding to the first to-be-processed order, and obtaining the target payment information;
if the number of orders in the first payment information is smaller than the number of orders in the second payment information, determining a second to-be-processed order which exists in the second payment information and does not exist in the first payment information, and adding the second to-be-processed order and the payment amount corresponding to the second to-be-processed order to the first payment information to obtain the target payment information;
And if the first payment amount is different from the second payment amount and the number of orders in the first payment information is the same as the number of orders in the second payment information, correcting the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
Further, in the method as described above, after the correcting operation is performed on the first payment information according to the reconciliation result, the method further includes:
generating a reconciliation file according to the target payment information;
uploading the reconciliation file to a preset server, so that merchants can download the reconciliation file from the server for viewing according to requirements.
Further, in the method as described above, before the obtaining the first payment information corresponding to each merchant in the preset time interval, the method further includes:
acquiring registration requests sent by all merchants, wherein the registration requests comprise merchant identifications;
and after registration is completed according to the registration request, sending a payment interface corresponding to the merchant identification to each merchant.
Further, in the method as described above, after the correcting operation is performed on the first payment information according to the comparison result, the method further includes:
And deleting the first payment information and the second payment information stored in the database.
In a second aspect, embodiments of the present disclosure provide a data processing apparatus, including:
the system comprises an acquisition module, a payment company and a payment company, wherein the acquisition module is used for acquiring first payment information corresponding to each merchant in a preset time interval from a preset database and second payment information corresponding to each merchant in the preset time interval provided by the payment company, the first payment information comprises an order for a user to finish payment through identifying a preset payment interface corresponding to the merchant and a first payment amount corresponding to the order, and the second payment information is the order actually received by the payment company and a second payment amount corresponding to the order;
the comparison module is used for comparing the first payment information and the second payment information to obtain a comparison result;
and the correction module is used for carrying out correction operation on the first payment information according to the comparison result to obtain corrected target payment information.
Further, in the apparatus as described above, the correction module is specifically configured to:
if the first payment information is the same as the second payment information, the first payment information is used as the target payment information;
If the number of orders in the first payment information exceeds the number of orders in the second payment information, determining a first to-be-processed order which exists in the first payment information and does not exist in the second payment information, deleting the first to-be-processed order and the payment amount corresponding to the first to-be-processed order, and obtaining the target payment information;
if the number of orders in the first payment information is smaller than the number of orders in the second payment information, determining a second to-be-processed order which exists in the second payment information and does not exist in the first payment information, and adding the second to-be-processed order and the payment amount corresponding to the second to-be-processed order to the first payment information to obtain the target payment information;
and if the first payment amount is different from the second payment amount and the number of orders in the first payment information is the same as the number of orders in the second payment information, correcting the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
Further, the apparatus as described above, further comprising:
The generation module is used for generating a reconciliation file according to the target payment information;
and the transmission module is used for uploading the account checking file to a preset server so that merchants can download the account checking file from the server for viewing according to requirements.
Further, in the apparatus as described above, the obtaining module is further configured to obtain a registration request sent by each merchant, where the registration request includes a merchant identifier;
the data processing apparatus further includes:
and the sending module is used for sending a payment interface corresponding to the merchant identification to each merchant after registration is completed according to the registration request.
Further, the apparatus as described above, further comprising:
and the deleting module is used for deleting the first payment information and the second payment information stored in the database.
In a third aspect, an embodiment of the present disclosure provides an electronic device, including: a memory, a processor;
a memory: a memory for storing the processor-executable instructions;
wherein the processor is configured to invoke program instructions in the memory to perform the data processing method according to the first aspect.
In a fourth aspect, embodiments of the present disclosure provide a computer-readable storage medium having stored therein computer-executable instructions which, when executed by a processor, are adapted to carry out the data processing method according to the first aspect.
The embodiment of the disclosure provides a data processing method, a device, equipment and a computer readable storage medium, wherein the first payment information corresponding to each merchant in a preset time interval and the second payment information corresponding to each merchant in the preset time interval provided by a payment company are obtained from a preset database, the first payment information and the second payment information are compared to obtain a comparison result, and the first payment information is corrected according to the comparison result to obtain corrected target payment information. The data storage is performed by adopting the preset database, the data comparison is performed in the database, the account checking processing is automatically performed according to the comparison result, the whole account checking process does not need to be manually participated, and the problems that the manual account checking data checking is difficult and the error rate is high are effectively solved. In addition, by adopting the data processing method, the data can be stored in a preset database, and the checking process is realized in the preset database, so that a large amount of data searching work is not needed, and the processing efficiency of the checking link is obviously improved.
It should be understood that what is described in the foregoing summary is not intended to limit the critical or essential features of the embodiments of the disclosure nor to limit the scope of the disclosure. Other features of the present disclosure will become apparent from the following description.
Drawings
In order to more clearly illustrate the embodiments of the present disclosure or the solutions in the prior art, a brief description will be given below of the drawings that are needed in the embodiments or the description of the prior art, it being obvious that the drawings in the following description are some embodiments of the present disclosure, and that other drawings may be obtained from these drawings without inventive effort to a person of ordinary skill in the art.
Fig. 1 is a schematic diagram of an application scenario on which an embodiment of the present disclosure is based;
FIG. 2 is a flow chart of a data processing method according to a first embodiment of the present disclosure;
FIG. 3 is a flowchart of a data processing method according to a second embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a data processing apparatus according to a third embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure have been shown in the accompanying drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
The terms "first," "second," "third," "fourth" and the like in the description and in the claims of embodiments of the disclosure and in the above-described figures, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the disclosed embodiments described herein may be capable of being practiced otherwise than as specifically illustrated and described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
With the development of mobile internet technology, online payment is made possible. Accordingly, after the online payment, the payment information needs to be checked out. In the prior art, a large amount of data needs to be searched during checking, and when the checking results are different, the checking process needs to be performed manually. However, the manual process has a high error rate, data collation is difficult, and the reconciliation process is long.
According to the problems, the inventor finds that a preset database can be adopted for data storage, data comparison is carried out in the database, and automatic account-checking processing is carried out according to the comparison result, so that the whole account-checking process does not need to be manually participated, and the problems that manual account-checking data are difficult to check and the error rate is high are effectively solved. In addition, by adopting the data processing method, the data can be stored in a preset database, and the checking process is realized in the preset database, so that a large amount of data searching work is not needed, and the processing efficiency of the checking link is obviously improved.
Fig. 1 is a schematic diagram of an application scenario according to an embodiment of the present disclosure, as shown in fig. 1, the network architecture shown in fig. 1 may specifically include a merchant side terminal 1, a server 2, and a payment company side terminal 3, where a database and a corresponding data processing device are disposed in the server 2.
The user terminal 1 may specifically be any terminal capable of accessing to a network, which includes, but is not limited to, a mobile phone, a desktop computer, an intelligent home device, a tablet computer, and other hardware devices that may be used to send first payment information for completing payment by identifying a preset payment interface corresponding to a merchant to a server.
The server 2 may be specifically a server preset with a database and a data processing device corresponding to the database, where the preset database may be specifically a clickHouse database, where the database is used to store first payment information corresponding to each merchant and second payment information provided by a payment company, and the data processing device is used to compare the first payment information corresponding to each merchant with the second payment information corresponding to each merchant provided by the payment company, and perform a correction operation on the first payment information according to a comparison result.
The payment company side terminal 3 may specifically be any terminal capable of accessing to a network, which includes, but is not limited to, a mobile phone, a desktop computer, a smart home device, a tablet computer, and other hardware devices that may be used to send second payment information corresponding to each merchant provided by a payment company to a server.
Example 1
Fig. 2 is a flowchart of a data processing method according to an embodiment of the present disclosure, and as shown in fig. 2, the data processing method according to the present embodiment includes the following steps:
It should be noted that, the execution body of the data processing method provided in this embodiment is the foregoing data processing apparatus, and the data processing apparatus may be a data processing apparatus preset in a server.
In this embodiment, since the accounting is a process of comparing and correcting the payment information of each merchant with the payment company in the preset time interval, in order to compare and correct the payment information, the data processing apparatus may first obtain the first payment information corresponding to each merchant in the preset time interval and the second payment information corresponding to each merchant in the preset time interval provided by the payment company from the preset database. Specifically, the first payment information may include an order for the user to complete payment and a first payment amount corresponding to the order by identifying a preset payment interface corresponding to the merchant, and the second payment information is an order actually received by the payment company and a second payment amount corresponding to the order.
For example, when the user pays, the terminal device may be used to identify a preset payment interface corresponding to the merchant to pay, and when the user pays, the data processing device receives the order information sent by the terminal device and the first payment amount corresponding to the order information, and stores the order information and the first payment amount in a preset database. Accordingly, the data processing device also receives the order actually received by the payment company and the corresponding second payment amount sent by the payment company terminal, and stores the order and the corresponding second payment amount in a preset database. When checking account, the data processing device can acquire the first payment information and the second payment information from the preset database.
The preset time interval may be 24 hours, 36 hours, 48 hours, or other suitable time interval, which is not limited in this embodiment.
In addition, the preset payment interface corresponding to the merchant is the payment interface corresponding to the merchant identifier sent by the received data processing device after the merchant finishes registration.
And 102, comparing the first payment information with the second payment information to obtain a comparison result.
In this embodiment, in order to accurately correct the payment information in the preset time interval between each merchant and the payment company, the data processing device may perform a comparison operation on the first payment information and the second payment information, and obtain a comparison result. Specifically, the data processing device may compare an order in which the user completes payment through a preset payment interface corresponding to the identified merchant with an order actually received by the payment company, and obtain an order comparison result, or compare a first payment amount in which the user completes payment through the preset payment interface corresponding to the identified merchant with a second payment amount actually received by the payment company, and obtain a payment amount comparison result.
For example, the data processing device may compare the order that the user completes the payment through identifying the preset payment interface corresponding to the merchant with the order actually received by the payment company according to the order information. After the comparison, the comparison result of the order can be obtained, and the comparison result can be that no redundant order exists or redundant order exists. And then, the data processing device compares the first payment amount of the user for completing the payment through the preset payment interface corresponding to the identified merchant with the second payment amount actually received by the payment company, and after the comparison is finished, a comparison result of the payment amounts can be obtained, wherein the comparison result can be that the payment amounts are consistent or the payment amounts are inconsistent.
And 103, carrying out correction operation on the first payment information according to the comparison result to obtain corrected target payment information.
In this embodiment, since the second payment information provided by the payment company is actual payment information, and the actual payment information is required to be used for reconciliation, in order to match the first payment information with the second payment information, the data processing apparatus needs to perform a correction operation on the first payment information according to the comparison result and obtain corrected target payment information. Specifically, the data processing apparatus may perform the correction operation on the first payment information by deleting or adding an order in the first payment information, or modifying a payment amount in the first payment information.
According to the data processing method provided by the embodiment, the first payment information corresponding to each merchant in the preset time interval and the second payment information corresponding to each merchant in the preset time interval provided by the payment company are obtained from the preset database, comparison operation is carried out on the first payment information and the second payment information, a comparison result is obtained, correction operation is carried out on the first payment information according to the comparison result, and corrected target payment information is obtained. Because the whole checking process does not need to be manually participated, the problems that the checking of the manual checking data is difficult and the error rate is high are effectively solved. In addition, by adopting the data processing method, the data can be stored in a preset database, and the data comparison is carried out in the database, so that a large amount of data searching work is not needed, and the processing efficiency of the reconciliation link is remarkably improved.
Example two
Fig. 3 is a flowchart of a data processing method according to a second embodiment of the present disclosure, as shown in fig. 2, where, based on the first embodiment of the present disclosure, step 103 is further refined, the data processing method according to the present embodiment includes the following steps:
In this embodiment, after the data processing apparatus performs a comparison operation on the first payment information and the second payment information, and obtains a comparison result. Since the second payment information provided by the payment company is the actual payment information, and the accounting needs to be based on the actual payment information, in order to make the first payment information coincide with the second payment information, thereby obtaining the target payment information, the data processing device needs to perform a correction operation on the first payment information according to the comparison result.
Specifically, if the user completes the order of payment and the corresponding first payment amount thereof through identifying the preset payment interface corresponding to the merchant, and the order actually received by the payment company and the corresponding second payment amount thereof are the same, it is indicated that the first payment information corresponding to the merchant is consistent with the second payment information provided by the payment company, and the data processing device takes the first payment information as target payment information, and the payment company can pay the payment of the merchant to be paid according to the target payment information.
If the number of orders in the first payment information exceeds the number of orders in the second payment information, namely the number of orders for which the user finishes payment through identifying a preset payment interface corresponding to the merchant is more than the number of orders actually received by the payment company, the invalid orders exist in the first payment information corresponding to the merchant. In order to make the first payment information consistent with the second payment information, the data processing device may determine a first to-be-processed order that exists in the first payment information and does not exist in the second payment information, delete the first to-be-processed order and a corresponding payment amount thereof, and use the payment information after deleting the first to-be-processed order and the corresponding payment amount thereof as target payment information, and the payment company may pay the payment of the business to be paid according to the target payment information.
If the number of orders in the first payment information is smaller than the number of orders in the second payment information, namely the number of orders for which the user finishes payment through identifying a preset payment interface corresponding to the merchant is smaller than the number of orders actually received by the payment company, the fact that the first payment information corresponding to the merchant lacks effective orders is indicated. In order to reconcile the first payment information with the second payment information, the data processing apparatus may determine a second pending order that is present in the second payment information and that is not present in the first payment information, and add the second pending order and its corresponding payment amount to the first payment information. And taking the payment information added with the second pending order and the corresponding payment amount as target payment information, and the payment company can pay the payment of the business to be paid to the business according to the target payment information.
If the first payment amount is different from the second payment amount, and the number of orders in the first payment information is the same as the number of orders in the second payment information, namely the number of orders for which the user finishes payment through a preset payment interface corresponding to the identification merchant is the same as the number of orders actually received by the payment company. However, the user recognizes the payment amount of the payment completed through the preset payment interface corresponding to the merchant, and if the payment amount is different from the payment amount actually received by the payment company, the user indicates that the first payment information corresponding to the merchant has the wrong payment amount. In order to make the first payment information coincide with the second payment information, the data processing device may correct the first payment amount of each order in the first payment information according to the second payment information, and use the payment information obtained by correcting the first payment amount of each order in the first payment information according to the second payment information as target payment information, and the payment company may pay the merchant to be paid according to the target payment information.
According to the data processing method provided by the embodiment, the first payment information is corrected through the comparison result of the first payment information and the second payment information, and corrected target payment information is obtained. Because the comparison results are different, different correction methods are adopted for correcting the first payment information, the consistency of the first payment information and the second payment information is ensured, and the accuracy of payment to the merchant by the payment company is further ensured.
In order to further describe the data processing method of the present disclosure, after step 103 in the first embodiment, the method further includes: generating a reconciliation file according to the target payment information; uploading the reconciliation file to a preset server, so that merchants can download the reconciliation file from the server for viewing according to requirements.
In this embodiment, in order to facilitate the merchant to know the account checking situation, after obtaining the target payment information, the data processing apparatus may generate an account checking file according to the target payment information, and upload the account checking file to a preset server. So that the merchant can download the reconciliation document from the server for viewing as required. Specifically, the reconciliation file may include the corrected payment order and the corresponding payment amount.
Through the mode, merchants can download and view the reconciliation file according to requirements, so that the reconciliation situation can be known, the problem of payment information can be further known, and similar problems are prevented from happening again.
Further, on the basis of any one of the above embodiments, before step 101, the method further includes: acquiring registration requests sent by all merchants, wherein the registration requests comprise merchant identifications; and after registration is completed according to the registration request, sending a payment interface corresponding to the merchant identification to each merchant.
In this embodiment, in order to implement the reconciliation process, the first payment information corresponding to each merchant needs to be compared and corrected with the second payment information provided by the payment company. Therefore, in order to obtain the first payment information corresponding to each merchant, the data processing apparatus may first obtain a registration request sent by each merchant, and specifically, the registration request may include a merchant identifier.
After each merchant completes registration according to the registration request, the data processing device can send a payment interface corresponding to each merchant identifier to each merchant, and information generated by the user by identifying the payment interface corresponding to each merchant to complete payment is first payment information corresponding to each merchant.
By means of the method, the data processing device can accurately distinguish the first payment information corresponding to each merchant through the merchant identification, and the situation of data acquisition errors caused by excessive first payment information of each merchant is avoided.
Further, on the basis of any one of the above embodiments, after step 103, the method further includes: and deleting the first payment information and the second payment information stored in the database.
In this embodiment, in order to avoid a situation in which new payment information cannot be stored due to excessive database data, the data processing apparatus may delete the first payment information and the second payment information stored in the database after obtaining the corrected target payment information.
According to the data processing method provided by the embodiment, after the corrected target payment information is obtained, the first payment information and the second payment information stored in the database are deleted, so that the memory of the database can be always in a vacant state, the condition that new data cannot be stored is avoided, meanwhile, the running speed of the database can be improved, and the reconciliation efficiency is further improved.
Example III
Fig. 4 is a schematic structural diagram of a data processing apparatus according to a third embodiment of the present disclosure, and as shown in fig. 4, the data processing apparatus according to the present embodiment includes: an acquisition module 31, a comparison module 32 and a correction module 33. The acquiring module 31 is configured to acquire, from a preset database, first payment information corresponding to each merchant in a preset time interval, and second payment information corresponding to each merchant in the preset time interval provided by a payment company, where the first payment information includes an order for a user to complete payment by identifying a preset payment interface corresponding to the merchant and a first payment amount corresponding to the order, and the second payment information is an order actually received by the payment company and a second payment amount corresponding to the order. And the comparison module 32 is configured to perform a comparison operation on the first payment information and the second payment information, so as to obtain a comparison result. And the correction module 33 is configured to perform correction operation on the first payment information according to the comparison result, so as to obtain corrected target payment information.
According to the data processing device provided by the embodiment, the first payment information corresponding to each merchant in the preset time interval and the second payment information corresponding to each merchant in the preset time interval provided by the payment company are obtained from the preset database, comparison operation is carried out on the first payment information and the second payment information, a comparison result is obtained, correction operation is carried out on the first payment information according to the comparison result, and corrected target payment information is obtained. Because the whole checking process does not need to be manually participated, the problems that the checking of the manual checking data is difficult and the error rate is high are effectively solved. In addition, by adopting the data processing method, the data can be stored in a preset database, and the data comparison is carried out in the database, so that a large amount of data searching work is not needed, and the processing efficiency of the reconciliation link is remarkably improved.
In an alternative embodiment, the correction module 33 is specifically configured to: and if the first payment information is the same as the second payment information, taking the first payment information as the target payment information. If the number of orders in the first payment information exceeds the number of orders in the second payment information, determining a first to-be-processed order which exists in the first payment information and does not exist in the second payment information, deleting the first to-be-processed order and the payment amount corresponding to the first to-be-processed order, and obtaining the target payment information. If the number of orders in the first payment information is smaller than the number of orders in the second payment information, determining a second to-be-processed order which exists in the second payment information and does not exist in the first payment information, and adding the second to-be-processed order and the payment amount corresponding to the second to-be-processed order to the first payment information to obtain the target payment information. And if the first payment amount is different from the second payment amount and the number of orders in the first payment information is the same as the number of orders in the second payment information, correcting the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
In an alternative embodiment, the data processing apparatus further includes: the generation module 34 and the transmission module 35. The generating module 34 is configured to generate a reconciliation document according to the target payment information. And the transmission module 35 is configured to upload the reconciliation file to a preset server, so that a user downloads the reconciliation file from the server according to the requirement for viewing.
In an optional embodiment, the obtaining module 31 is further configured to obtain a registration request sent by each merchant, where the registration request includes a merchant identifier. The data processing apparatus further includes: a transmitting module 36. The sending module 36 is configured to send a payment interface corresponding to the merchant identifier to each merchant after registration is completed according to the registration request.
In an alternative embodiment, the data processing apparatus further includes: the module 37 is deleted. Wherein, the deleting module 37 is configured to delete the first payment information and the second payment information stored in the database.
Example IV
Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure, as shown in fig. 5, and the present disclosure further provides an electronic device 400, including: a memory 401 and a processor 402.
A memory 401 for storing programs. In particular, the program may include program code comprising computer-executable instructions. Memory 401 may comprise high-speed RAM memory or may also include non-volatile memory (non-volatile memory), such as at least one disk memory.
A processor 402 for executing a program stored in the memory 401.
Wherein a computer program is stored in the memory 401 and configured to be executed by the processor 402 to implement the data processing method provided by any of the embodiments of the present disclosure. The related descriptions and effects corresponding to the steps in the drawings can be understood correspondingly, and are not repeated here.
In this embodiment, the memory 401 and the processor 402 are connected through a bus. The bus may be an industry standard architecture (Industry Standard Architecture, abbreviated ISA) bus, an external device interconnect (Peripheral Component, abbreviated PCI) bus, or an extended industry standard architecture (Extended Industry Standard Architecture, abbreviated EISA) bus, among others. The buses may be classified as address buses, data buses, control buses, etc. For ease of illustration, only one thick line is shown in fig. 5, but not only one bus or one type of bus.
Example five
The embodiments of the present disclosure also provide a computer-readable storage medium having stored thereon a computer program that is executed by a processor to implement the data processing method provided by any of the embodiments of the present disclosure.
In the several embodiments provided in the present disclosure, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of modules is merely a logical function division, and there may be additional divisions of actual implementation, e.g., multiple modules or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or modules, which may be in electrical, mechanical, or other forms.
The modules illustrated as separate components may or may not be physically separate, and components shown as modules may or may not be physical modules, i.e., may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in each embodiment of the present disclosure may be integrated into one processing module, or each module may exist alone physically, or two or more modules may be integrated into one module. The integrated modules may be implemented in hardware or in hardware plus software functional modules.
Program code for carrying out methods of the present disclosure may be written in any combination of one or more programming languages. These program code may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus such that the program code, when executed by the processor or controller, causes the functions/operations specified in the flowchart and/or block diagram to be implemented. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
Moreover, although operations are depicted in a particular order, this should be understood as requiring that such operations be performed in the particular order shown or in sequential order, or that all illustrated operations be performed, to achieve desirable results. In certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single implementation. Conversely, various features that are described in the context of a single implementation can also be implemented in multiple implementations separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.
Claims (10)
1. A method of data processing, comprising:
Acquiring first payment information corresponding to each merchant in a preset time interval from a preset database, and second payment information corresponding to each merchant in the preset time interval provided by a payment company, wherein the first payment information comprises an order for a user to finish payment through identifying a preset payment interface corresponding to the merchant and a first payment amount corresponding to the order, and the second payment information is the order actually received by the payment company and a second payment amount corresponding to the order;
comparing the first payment information and the second payment information to obtain a comparison result;
performing correction operation on the first payment information according to the comparison result to obtain corrected target payment information;
and performing correction operation on the first payment information according to the comparison result, including:
if the first payment information is the same as the second payment information, the first payment information is used as the target payment information;
if the number of orders in the first payment information exceeds the number of orders in the second payment information, determining a first to-be-processed order which exists in the first payment information and does not exist in the second payment information, deleting the first to-be-processed order and the payment amount corresponding to the first to-be-processed order, and obtaining the target payment information;
If the number of orders in the first payment information is smaller than the number of orders in the second payment information, determining a second to-be-processed order which exists in the second payment information and does not exist in the first payment information, and adding the second to-be-processed order and the payment amount corresponding to the second to-be-processed order to the first payment information to obtain the target payment information;
and if the first payment amount is different from the second payment amount and the number of orders in the first payment information is the same as the number of orders in the second payment information, correcting the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
2. The method according to claim 1, wherein the performing a correction operation on the first payment information according to the comparison result, after obtaining corrected target payment information, further includes:
generating a reconciliation file according to the target payment information;
uploading the reconciliation file to a preset server, so that merchants can download the reconciliation file from the server for viewing according to requirements.
3. The method of claim 1, further comprising, prior to obtaining the first payment information corresponding to each merchant within the preset time interval:
acquiring registration requests sent by all merchants, wherein the registration requests comprise merchant identifications;
and after registration is completed according to the registration request, sending a payment interface corresponding to the merchant identification to each merchant.
4. The method according to claim 1, wherein the performing a correction operation on the first payment information according to the comparison result, after obtaining corrected target payment information, further includes:
and deleting the first payment information and the second payment information stored in the database.
5. A data processing apparatus, comprising:
the system comprises an acquisition module, a payment company and a payment company, wherein the acquisition module is used for acquiring first payment information corresponding to each merchant in a preset time interval from a preset database and second payment information corresponding to each merchant in the preset time interval provided by the payment company, the first payment information comprises an order for a user to finish payment through identifying a preset payment interface corresponding to the merchant and a first payment amount corresponding to the order, and the second payment information is the order actually received by the payment company and a second payment amount corresponding to the order;
The comparison module is used for comparing the first payment information and the second payment information to obtain a comparison result;
the correction module is used for carrying out correction operation on the first payment information according to the comparison result to obtain corrected target payment information;
the correction module is specifically configured to:
if the first payment information is the same as the second payment information, the first payment information is used as the target payment information;
if the number of orders in the first payment information exceeds the number of orders in the second payment information, determining a first to-be-processed order which exists in the first payment information and does not exist in the second payment information, deleting the first to-be-processed order and the payment amount corresponding to the first to-be-processed order, and obtaining the target payment information;
if the number of orders in the first payment information is smaller than the number of orders in the second payment information, determining a second to-be-processed order which exists in the second payment information and does not exist in the first payment information, and adding the second to-be-processed order and the payment amount corresponding to the second to-be-processed order to the first payment information to obtain the target payment information;
And if the first payment amount is different from the second payment amount and the number of orders in the first payment information is the same as the number of orders in the second payment information, correcting the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
6. The apparatus as recited in claim 5, further comprising:
the generation module is used for generating a reconciliation file according to the target payment information;
and the transmission module is used for uploading the account checking file to a preset server so that merchants can download the account checking file from the server for viewing according to requirements.
7. The apparatus of claim 5, wherein the obtaining module is further configured to obtain a registration request sent by each merchant, the registration request including a merchant identifier;
the data processing apparatus further includes:
and the sending module is used for sending a payment interface corresponding to the merchant identification to each merchant after registration is completed according to the registration request.
8. The apparatus as recited in claim 5, further comprising:
and the deleting module is used for deleting the first payment information and the second payment information stored in the database.
9. An electronic device, comprising: a memory, a processor;
a memory: a memory for storing the processor-executable instructions;
wherein the processor is configured to invoke program instructions in the memory to perform the data processing method according to any of claims 1-4.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein computer executable instructions which, when executed by a processor, are adapted to implement the data processing method according to any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011424046.8A CN112541750B (en) | 2020-12-08 | 2020-12-08 | Data processing method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011424046.8A CN112541750B (en) | 2020-12-08 | 2020-12-08 | Data processing method, device, equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112541750A CN112541750A (en) | 2021-03-23 |
| CN112541750B true CN112541750B (en) | 2023-06-30 |
Family
ID=75019530
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011424046.8A Active CN112541750B (en) | 2020-12-08 | 2020-12-08 | Data processing method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112541750B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113065927A (en) * | 2021-04-13 | 2021-07-02 | 北京健康之家科技有限公司 | Account checking method and device, electronic equipment and computer readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243528A (en) * | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN105787109A (en) * | 2016-03-22 | 2016-07-20 | 农信银资金清算中心有限责任公司 | Account checking method and device of payment and clearing system |
| CN109636634A (en) * | 2018-12-13 | 2019-04-16 | 泰康保险集团股份有限公司 | A kind of automatic account checking method and device |
| CN110738477A (en) * | 2019-08-22 | 2020-01-31 | 威富通科技有限公司 | reconciliation method, device, computer equipment and storage medium |
| CN111899011A (en) * | 2020-07-29 | 2020-11-06 | 广州海鹚网络科技有限公司 | Medical bill reconciliation system, computer equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090240620A1 (en) * | 2008-03-24 | 2009-09-24 | Propay Usa, Inc. | Secure payment system |
-
2020
- 2020-12-08 CN CN202011424046.8A patent/CN112541750B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243528A (en) * | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN105787109A (en) * | 2016-03-22 | 2016-07-20 | 农信银资金清算中心有限责任公司 | Account checking method and device of payment and clearing system |
| CN109636634A (en) * | 2018-12-13 | 2019-04-16 | 泰康保险集团股份有限公司 | A kind of automatic account checking method and device |
| CN110738477A (en) * | 2019-08-22 | 2020-01-31 | 威富通科技有限公司 | reconciliation method, device, computer equipment and storage medium |
| CN111899011A (en) * | 2020-07-29 | 2020-11-06 | 广州海鹚网络科技有限公司 | Medical bill reconciliation system, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| "军卫一号"与第三方支付平台的对账系统设计;郭旭 等;《中国数字医学》;第15卷(第03期);第60-62页 * |
| Souvik Roy等.Online payment system using steganography and visual cryptography.《2014 IEEE Students' Conference on Electrical, Electronics and Computer Science》.2014,第1-5页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112541750A (en) | 2021-03-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2015088853A1 (en) | Launching a client application based on a message | |
| CN111071094B (en) | Charging method and device | |
| CN109285069B (en) | Resource transfer method, device and server | |
| CN109615384B (en) | Method, device and server for generating timeliness check rule | |
| CN112541750B (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN111027984A (en) | Business order processing method and system, electronic equipment and computer storage medium | |
| CN114170023A (en) | Method and device for testing fund transaction operation platform system | |
| CN112907344A (en) | Accounting data processing method and device, electronic equipment and storage medium | |
| CN111222972A (en) | Account checking and clearing method and device | |
| CN116167860A (en) | Account checking processing method and device, electronic equipment and storage medium | |
| CN111651494A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN115600972A (en) | Method, device, equipment and storage medium for verifying and selling of bad assets | |
| CN115357012A (en) | Method for leasing vehicle diagnosis equipment | |
| CN111680066B (en) | Information processing method, information processing device, storage medium and electronic equipment | |
| CN111324537A (en) | Test script-based test method and device and computer equipment | |
| CN112115518A (en) | Service data checking method and device | |
| CN108255629B (en) | Breakpoint data obtaining method and terminal equipment | |
| CN113449023A (en) | Service processing method and device and electronic equipment | |
| KR101737575B1 (en) | Method and device for verifying data based on sql sentences generated automatically | |
| CN113781034B (en) | Billing and checking method based on cache | |
| CN109829750A (en) | Public transport exchange information processing method, device and computer equipment | |
| CN113766442B (en) | Telephone traffic resource sharing method and device, computing equipment and storage medium | |
| CN112613967B (en) | Business transaction data processing method and device, computer equipment and storage medium | |
| CN117094798A (en) | Processing method, device, equipment and storage medium for online transaction | |
| CN115393058A (en) | Transaction processing method, system, storage medium and electronic equipment |
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 |