CN112541750A - 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
- CN112541750A CN112541750A CN202011424046.8A CN202011424046A CN112541750A CN 112541750 A CN112541750 A CN 112541750A CN 202011424046 A CN202011424046 A CN 202011424046A CN 112541750 A CN112541750 A CN 112541750A
- Authority
- CN
- China
- Prior art keywords
- payment information
- payment
- order
- merchant
- data processing
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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—Managing shopping lists, e.g. compiling or processing purchase lists
- G06Q30/0635—Managing shopping lists, e.g. compiling or processing purchase lists replenishment orders; recurring orders
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
本公开提供了一种数据处理方法、装置、设备及计算机可读存储介质，方法包括：从预设的数据库中获取预设时间间隔内各商户对应的第一支付信息，以及支付公司提供的预设时间间隔内各商户对应的第二支付信息，对所述第一支付信息以及所述第二支付信息进行比对操作，获得比对结果，根据所述比对结果对所述第一支付信息进行修正操作，获得修正后的目标支付信息。无需人工参与对账，有效解决了人工对账数据核对困难且出错率较高的问题。此外，通过采用这种数据处理方法，可以将数据存储在预设的数据库中，并且在该数据库中进行数据比对，从而不需要进行大量的数据查找工作，显著提升了对账环节的处理效率。
The present disclosure provides a data processing method, apparatus, device, and computer-readable storage medium. The method includes: obtaining first payment information corresponding to each merchant within a preset time interval from a preset database, and pre-payment information provided by a payment company. Set the second payment information corresponding to each merchant within the time interval, perform a comparison operation on the first payment information and the second payment information, obtain a comparison result, and compare the first payment information according to the comparison result. Perform a correction operation to obtain the corrected target payment information. There is no need to manually participate in reconciliation, which effectively solves the problem of difficulty in manual reconciliation data verification and a high error rate. In addition, by using this data processing method, data can be stored in a preset database, and data comparison can be performed in the database, so that a large amount of data search work is not required, and the processing efficiency of the reconciliation link is significantly 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 the mobile internet technology, the electronic business industry is continuously expanded, online payment is produced, and the importance of account checking is more and more shown. The account checking refers to checking accounts, the merchant and the payment company confirm the transaction details in a certain period, the generated account is downloaded by the merchant, and the payment of the merchant is paid to the merchant.
In the prior art, a large amount of data needs to be searched during account checking, and account leveling processing needs to be manually performed when account checking results are different.
However, when the reconciliation is performed by adopting the above method, the manual processing error rate is high, the data checking is difficult, and the reconciliation process is long.
Disclosure of Invention
The embodiment of the disclosure provides a data processing method, a data processing device, data processing equipment and a computer readable storage medium, and solves the technical problems that in the prior art, the manual account checking error rate is high, data checking is difficult and the account checking process is long.
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 and second payment information corresponding to each merchant in the preset time interval provided by a payment company from a preset database, wherein the first payment information comprises an order which is paid by a user through a preset payment interface corresponding to an identified merchant and a corresponding first payment amount, and the second payment information is the order actually received by the payment company and a corresponding second payment amount;
comparing the first payment information with 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.
Further, in the method, the performing a correction operation on the first payment information according to the comparison result includes:
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 order quantity in the first payment information exceeds the order quantity in the second payment information, determining a first order to be processed which exists in the first payment information and does not exist in the second payment information, deleting the first order to be processed and the payment amount corresponding to the first order to be processed, and obtaining the target payment information;
if the order quantity in the first payment information is less than the order quantity in the second payment information, determining a second order to be processed which exists in the second payment information and does not exist in the first payment information, and adding the second order to be processed and the payment amount corresponding to the second order to be processed into 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 that of orders in the second payment information, modifying 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 method as described above, after performing a correction operation on the first payment information according to the reconciliation result and obtaining corrected target payment information, further includes:
generating a reconciliation file according to the target payment information;
and uploading the account checking file to a preset server so that the merchant downloads the account checking file from the server for viewing according to the requirement.
Further, the method, before acquiring the first payment information corresponding to each merchant within the preset time interval, further includes:
acquiring a registration request sent by each merchant, wherein the registration request comprises a merchant identifier;
and after the registration is completed according to the registration request, sending a payment interface corresponding to the merchant identification to each merchant.
Further, the method, after performing a correction operation on the first payment information according to the comparison result and obtaining corrected target payment information, further includes:
deleting the first payment information and the second payment information stored in the database.
In a second aspect, an embodiment of the present disclosure provides a data processing apparatus, including:
the system comprises an acquisition module, a processing module and a processing module, 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 a payment company, the first payment information comprises an order which is paid by a user through a preset payment interface corresponding to the identified merchant and a corresponding first payment amount, and the second payment information is the order actually received by the payment company and a corresponding second payment amount;
the comparison module is used for comparing the first payment information with the second payment information to obtain a comparison result;
and the correction module is used for performing correction operation on the first payment information according to the comparison result to obtain corrected target payment information.
Further, in the apparatus described above, the modification module is specifically configured to:
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 order quantity in the first payment information exceeds the order quantity in the second payment information, determining a first order to be processed which exists in the first payment information and does not exist in the second payment information, deleting the first order to be processed and the payment amount corresponding to the first order to be processed, and obtaining the target payment information;
if the order quantity in the first payment information is less than the order quantity in the second payment information, determining a second order to be processed which exists in the second payment information and does not exist in the first payment information, and adding the second order to be processed and the payment amount corresponding to the second order to be processed into 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 that of orders in the second payment information, modifying 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 generating 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 a merchant can download the account checking file from the server for checking according to the requirement.
Further, in the apparatus 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 identifier to each merchant after the registration is finished 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 of the first aspect.
In a fourth aspect, the present disclosure provides a computer-readable storage medium, in which computer-executable instructions are stored, and when the computer-executable instructions are executed by a processor, the computer-executable instructions are used to implement the data processing method according to the first aspect.
The embodiment of the disclosure provides a data processing method, a data processing device, a data processing apparatus and a computer-readable storage medium, wherein 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 are acquired 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. Adopt preset database to carry out data storage promptly to carry out data comparison in this database, and carry out tie account automatically according to the comparison result and handle, whole reconciliation process all need not artifical the participation, has effectively solved the problem that artifical reconciliation data was checked the difficulty and the error rate is higher. In addition, by adopting the data processing method, the data can be stored in the preset database, and the account checking process can be realized in the preset database, so that a large amount of data searching work is not needed, and the processing efficiency of the account checking link is obviously improved.
It should be understood that what is described in the summary section above is not intended to limit key or critical features of the embodiments of the disclosure, nor is it intended 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 technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present disclosure, and for those skilled in the art, other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic diagram of an application scenario on which an embodiment of the present disclosure is based;
fig. 2 is a flowchart of a data processing method according to a first embodiment of the disclosure;
fig. 3 is a flowchart of a data processing method according to a second embodiment of the disclosure;
fig. 4 is a schematic structural 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 are shown in the 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 rather are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims of the embodiments of the disclosure and in the drawings described above, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the disclosure described herein are, for example, capable of operation in sequences other than those illustrated or otherwise 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. Consequently, after online payment, the payment information needs to be reconciled. In the prior art, a large amount of data needs to be searched during account checking, and account leveling processing needs to be manually performed when account checking results are different. However, the manual processing has a high error rate, the data checking is difficult, and the reconciliation process is long.
Aiming at the problems, the inventor finds out through research that the preset database can be used for data storage, data comparison is carried out in the database, account balancing processing is automatically carried out according to comparison results, the whole account balancing process does not need manual participation, and the problems that manual account balancing 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 the preset database, and the account checking process can be realized in the preset database, so that a large amount of data searching work is not needed, and the processing efficiency of the account checking link is obviously improved.
Fig. 1 is a schematic diagram of an application scenario based on 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 the server 2 is provided with a database and a data processing device corresponding to the database.
The user terminal 1 may be any terminal capable of accessing to a network, and includes but is not limited to a mobile phone, a desktop computer, an intelligent home device, a tablet computer, and other hardware devices that can be used to send first payment information that completes payment through a preset payment interface corresponding to the recognized merchant to the server.
The server 2 may be a server that is preset with a database and a data processing device corresponding thereto, the preset database may be a ClickHouse database, 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 and the second payment information 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 be specifically any terminal capable of accessing a network, and includes, but is not limited to, a mobile phone, a desktop computer, an intelligent home device, a tablet computer, and other hardware devices that can be used to send second payment information corresponding to each merchant provided by the payment company to the server.
Example one
Fig. 2 is a flowchart of a data processing method according to a first embodiment of the disclosure, and as shown in fig. 2, the data processing method according to the first embodiment includes the following steps:
It should be noted that the execution subject of the data processing method provided in this embodiment is the aforementioned data processing apparatus, and the data processing apparatus may be a data processing apparatus preset in a server.
In this embodiment, the reconciliation is a process of comparing and correcting the payment information within the preset time interval between each merchant and the payment company, so in order to compare and correct the payment information, the data processing device may first obtain, from a preset database, first payment information corresponding to each merchant within the preset time interval and second payment information corresponding to each merchant within the preset time interval provided by the payment company. Specifically, the first payment information may include an order that the user completes payment through a preset payment interface corresponding to the merchant and a corresponding first payment amount, and the second payment information is an order actually received by the payment company and a corresponding second payment amount.
For example, when the user pays, the user may use the terminal device to identify a preset payment interface corresponding to the merchant for payment, and after the user pays, the data processing device receives the order information sent by the terminal device and the corresponding first payment amount, and stores the order information and the corresponding first payment amount in a preset database. Correspondingly, the data processing device also receives the order which is sent by the payment company terminal and actually received by the payment company and the corresponding second payment amount, and stores the order in the preset database. When the account is checked, 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 intervals, 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 and sent by the data processing device after the merchant completes 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 between each merchant and the payment company within the preset time interval, 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 the order in which the user completes payment through the preset payment interface corresponding to the identified merchant with the 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 first compare the order in which the user completes payment through the preset payment interface corresponding to the identified merchant with the order actually received by the payment company according to the order information. After the comparison is finished, the comparison result of the order can be obtained, and the comparison result can be that no redundant order exists or that redundant order exists. And then, the data processing device compares the first payment amount of which the user finishes payment through the preset payment interface corresponding to the identification merchant with the second payment amount actually received by the payment company, and after the comparison is finished, the 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, correcting 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 the actual payment information, and the actual payment information is required for reconciliation, the data processing apparatus needs to perform a correction operation on the first payment information according to the comparison result and obtain the corrected target payment information in order to make the first payment information and the second payment information consistent with each other. Specifically, the data processing apparatus may perform a 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.
In the data processing method provided by this embodiment, 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, which are provided by a payment company, are acquired 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. Because the whole account checking process does not need manual participation, the problems that manual account checking data is 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 account checking link is obviously improved.
Example two
Fig. 3 is a flowchart of a data processing method provided in the second embodiment of the present disclosure, and as shown in fig. 2, the data processing method provided in this embodiment is further refined in step 103 on the basis of the first embodiment of the present disclosure, and then the data processing method provided in this embodiment includes the following steps:
And 204, if the first payment amount is different from the second payment amount and the number of the orders in the first payment information is the same as the number of the 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 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 actual payment information is required to be used as the standard in reconciliation, in order to make the first payment information and the second payment information consistent and obtain 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 order and the corresponding first payment amount of the order, which are paid by the user through the preset payment interface corresponding to the merchant and are the same as the order actually received by the payment company and the corresponding second payment amount of the order, it is indicated that the first payment information corresponding to the merchant is consistent with the second payment information provided by the payment company, the data processing device will use the first payment information as target payment information, and the payment company can pay the merchant money according to the target payment information.
If the order quantity in the first payment information exceeds the order quantity in the second payment information, namely the order quantity of the user completing payment through the preset payment interface corresponding to the merchant is larger than the order quantity actually received by the payment company, the fact that the first payment information corresponding to the merchant has an invalid order is indicated. In order to make the first payment information consistent with the second payment information, the data processing apparatus may determine a first to-be-processed order existing in the first payment information and not existing in the second payment information, delete the first to-be-processed order and a payment amount corresponding to the first to-be-processed order, and use the payment information from which the first to-be-processed order and the payment amount corresponding to the first to-be-processed order are deleted as target payment information, and the payment company may pay the merchant with the due amount according to the target payment information.
If the order number in the first payment information is less than the order number in the second payment information, that is, the order number of the user completing payment through the preset payment interface corresponding to the merchant is less than the order number actually received by the payment company, it indicates that the first payment information corresponding to the merchant lacks an effective order. In order to reconcile the first payment information with the second payment information, the data processing apparatus may determine a second to-be-processed order that exists in the second payment information and does not exist in the first payment information, and add the second to-be-processed order and a payment amount corresponding thereto to the first payment information. And the payment information added with the second to-be-processed order and the payment amount corresponding to the second to-be-processed order is used as target payment information, and the payment company can pay the payment of the corresponding merchant to the merchant according to the target payment information.
And if the first payment amount is different from the second payment amount and the number of the orders in the first payment information is the same as the number of the orders in the second payment information, namely the number of the orders which are paid by the user through the preset payment interface corresponding to the identified merchant is the same as the number of the orders actually received by the payment company. However, if the payment amount paid by the user through the preset payment interface corresponding to the merchant is different from the payment amount actually received by the payment company, it is indicated that the wrong payment amount exists 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 apparatus may correct the first payment amount of each order in the first payment information according to the second payment information, and may use the payment information in which the first payment amount of each order in the first payment information is corrected according to the second payment information as target payment information, and the payment company may pay the corresponding merchant money to the merchant according to the target payment information.
In the data processing method provided by this embodiment, the first payment information is corrected according to the comparison result between the first payment information and the second payment information, so as to obtain corrected target payment information. Because the comparison results are different, the first payment information is corrected by adopting different correction methods, the consistency of the first payment information and the second payment information is ensured, and the accuracy of the account payable of the payment company to the merchant is further ensured.
On the basis of any of the foregoing embodiments, to further explain 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; and uploading the account checking file to a preset server so that the merchant downloads the account checking file from the server for viewing according to the requirement.
In this embodiment, in order to facilitate the merchant to know the account checking condition, the data processing apparatus may generate an account checking file according to the target payment information after obtaining the target payment information, and upload the account checking file to a preset server. Therefore, the merchant can download the account checking file from the server for checking according to the requirement. Specifically, the reconciliation file may include the revised payment order and the corresponding payment amount.
Through the mode, the merchant can download and check the account checking file according to the requirement, so that the account checking condition can be known, the problem of the payment information can be known, and the similar problem is prevented from happening again.
Further, on the basis of any of the above embodiments, before the step 101, the method further includes: acquiring a registration request sent by each merchant, wherein the registration request comprises a merchant identifier; and after the 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 with the second payment information provided by the payment company and corrected. 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 may send a payment interface corresponding to each merchant identifier to each merchant, and information generated when the user completes payment by identifying the payment interface corresponding to each merchant is the first payment information corresponding to each merchant.
Through the mode, 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 of the above embodiments, after the step 103, the method further includes: deleting the first payment information and the second payment information stored in the database.
In this embodiment, in order to avoid the situation that new payment information cannot be stored due to excessive database data, the data processing device 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, through the method, the memory of the database can be always in a vacant state, the situation that new data cannot be stored is avoided, meanwhile, the running speed of the database can be increased, and the account checking 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 third embodiment includes: an acquisition module 31, a comparison module 32 and a correction module 33. The obtaining module 31 is configured to obtain, 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 that a user completes payment through a preset payment interface corresponding to an identified merchant and a corresponding first payment amount, and the second payment information is the order actually received by the payment company and a corresponding second payment amount. The comparison module 32 is configured to perform a comparison operation on the first payment information and the second payment information to obtain a comparison result. And the correcting module 33 is configured to perform a correcting operation on the first payment information according to the comparison result, so as to obtain corrected target payment information.
The data processing apparatus provided in this embodiment obtains, 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, compares the first payment information with the second payment information to obtain a comparison result, and performs a correction operation on the first payment information according to the comparison result to obtain corrected target payment information. Because the whole account checking process does not need manual participation, the problems that manual account checking data is 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 account checking link is obviously improved.
In an optional embodiment, the modification 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 order quantity in the first payment information exceeds the order quantity in the second payment information, determining a first order to be processed which exists in the first payment information and does not exist in the second payment information, deleting the first order to be processed and the payment amount corresponding to the first order to be processed, and obtaining the target payment information. If the order quantity in the first payment information is less than the order quantity 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 into 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 that of orders in the second payment information, modifying 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 optional embodiment, the data processing apparatus further includes: a generation module 34 and a transmission module 35. The generating module 34 is configured to generate a reconciliation file 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 can download the reconciliation file from the server for viewing according to a requirement.
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 sending module 36. The sending module 36 is configured to send a payment interface corresponding to the merchant identifier to each merchant after completing registration according to the registration request.
In an optional embodiment, the data processing apparatus further includes: and a deletion module 37. The deleting module 37 is configured to delete the first payment information and the second payment information stored in the database.
Example four
Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure, and as shown in fig. 5, the present disclosure further provides an electronic device 400, including: a memory 401 and a processor 402.
The memory 401 stores programs. In particular, the program may include program code comprising computer-executable instructions. Memory 401 may comprise high-speed RAM memory, and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.
A processor 402 for executing the programs stored in the memory 401.
Wherein the 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 one of the embodiments of the present disclosure. The related descriptions and effects corresponding to the steps in the drawings can be correspondingly understood, and redundant description is not repeated here.
In this embodiment, the memory 401 and the processor 402 are connected by a bus. The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended ISA (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown in FIG. 5, but this is not intended to represent only one bus or type of bus.
EXAMPLE five
The embodiments of the present disclosure also provide a computer-readable storage medium, on which a computer program is stored, where the computer program is executed by a processor to implement the data processing method provided in any one 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 ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of modules is merely a division of logical functions, and an actual implementation may have another division, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or modules, and may be in an electrical, mechanical or other form.
Modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on 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 the present embodiment.
In addition, functional modules in the embodiments of the present disclosure may be integrated into one processing module, or each module may exist alone physically, or two or more modules are integrated into one module. The integrated module can be realized in a hardware form, and can also be realized in a form of hardware and a software functional module.
Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes 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 codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. 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. A 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.
Further, while 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. Under 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 limitations on the scope of the 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 disclosed as example forms of implementing the claims.
Claims (12)
1. A data processing method, comprising:
acquiring 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 from a preset database, wherein the first payment information comprises an order which is paid by a user through a preset payment interface corresponding to an identified merchant and a corresponding first payment amount, and the second payment information is the order actually received by the payment company and a corresponding second payment amount;
comparing the first payment information with 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.
2. The method according to claim 1, wherein the modifying the first payment information according to the comparison result comprises:
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 order quantity in the first payment information exceeds the order quantity in the second payment information, determining a first order to be processed which exists in the first payment information and does not exist in the second payment information, deleting the first order to be processed and the payment amount corresponding to the first order to be processed, and obtaining the target payment information;
if the order quantity in the first payment information is less than the order quantity in the second payment information, determining a second order to be processed which exists in the second payment information and does not exist in the first payment information, and adding the second order to be processed and the payment amount corresponding to the second order to be processed into 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 that of orders in the second payment information, modifying the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
3. The method according to claim 1 or 2, wherein the performing a correction operation on the first payment information according to the reconciliation result to obtain corrected target payment information further comprises:
generating a reconciliation file according to the target payment information;
and uploading the account checking file to a preset server so that the merchant downloads the account checking file from the server for viewing according to the requirement.
4. The method according to claim 1 or 2, wherein before the obtaining the first payment information corresponding to each merchant in the preset time interval, the method further comprises:
acquiring a registration request sent by each merchant, wherein the registration request comprises a merchant identifier;
and after the registration is completed according to the registration request, sending a payment interface corresponding to the merchant identification to each merchant.
5. The method according to claim 1 or 2, wherein the modifying the first payment information according to the comparison result, and after obtaining modified target payment information, further comprises:
deleting the first payment information and the second payment information stored in the database.
6. A data processing apparatus, comprising:
the system comprises an acquisition module, a processing module and a processing module, 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 a payment company, the first payment information comprises an order which is paid by a user through a preset payment interface corresponding to the identified merchant and a corresponding first payment amount, and the second payment information is the order actually received by the payment company and a corresponding second payment amount;
the comparison module is used for comparing the first payment information with the second payment information to obtain a comparison result;
and the correction module is used for performing correction operation on the first payment information according to the comparison result to obtain corrected target payment information.
7. The apparatus of claim 6, wherein the modification module is specifically configured to:
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 order quantity in the first payment information exceeds the order quantity in the second payment information, determining a first order to be processed which exists in the first payment information and does not exist in the second payment information, deleting the first order to be processed and the payment amount corresponding to the first order to be processed, and obtaining the target payment information;
if the order quantity in the first payment information is less than the order quantity in the second payment information, determining a second order to be processed which exists in the second payment information and does not exist in the first payment information, and adding the second order to be processed and the payment amount corresponding to the second order to be processed into 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 that of orders in the second payment information, modifying the first payment amount of each order in the first payment information according to the second payment information to obtain the target payment information.
8. The apparatus of claim 6 or 7, further comprising:
the generating 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 a merchant can download the account checking file from the server for checking according to the requirement.
9. The apparatus according to claim 6 or 7, wherein 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 identifier to each merchant after the registration is finished according to the registration request.
10. The apparatus of claim 6 or 7, further comprising:
and the deleting module is used for deleting the first payment information and the second payment information stored in the database.
11. An electronic device, comprising: a memory, a processor;
a memory: a memory for storing the processor-executable instructions;
wherein the processor is operable to invoke program instructions in the memory to perform the data processing method of any of claims 1 to 5.
12. A computer-readable storage medium, having stored thereon computer-executable instructions for implementing the data processing method of any one of claims 1-5 when executed by a processor.
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 true CN112541750A (en) | 2021-03-23 |
| CN112541750B 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) |
Cited By (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 (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090240620A1 (en) * | 2008-03-24 | 2009-09-24 | Propay Usa, Inc. | Secure payment system |
| 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 |
-
2020
- 2020-12-08 CN CN202011424046.8A patent/CN112541750B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090240620A1 (en) * | 2008-03-24 | 2009-09-24 | Propay Usa, Inc. | Secure payment system |
| 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 |
|---|
| SOUVIK ROY等: "Online payment system using steganography and visual cryptography", 《2014 IEEE STUDENTS\' CONFERENCE ON ELECTRICAL, ELECTRONICS AND COMPUTER SCIENCE》, pages 1 - 5 * |
| 郭旭 等: ""军卫一号"与第三方支付平台的对账系统设计", 《中国数字医学》, vol. 15, no. 03, pages 60 - 62 * |
Cited By (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112541750B (en) | 2023-06-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102193502B1 (en) | Method and device for obtaining a payment threshold | |
| CN108959374B (en) | Data storage method and device and electronic equipment | |
| KR102195350B1 (en) | Method and apparatus for detecting fund transaction path during electronic payment process | |
| CN110046944A (en) | Invoice creation method and device, electronic equipment based on block chain | |
| CN114170023A (en) | Method and device for testing fund transaction operation platform system | |
| CN112256672B (en) | Database change approval method and device | |
| CN113704123A (en) | Interface test method, device, equipment and storage medium | |
| CN112541750A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN114971605B (en) | A verification processing method, device, computer equipment and medium for offline payment | |
| CN111625458A (en) | Service system testing method, device and equipment | |
| CN110111188B (en) | Business handling method and equipment | |
| CN113129086A (en) | Value-added tax deduction method, device, system, equipment and medium | |
| CN116302889A (en) | Performance test method and device for functional module and server | |
| CN111737262B (en) | Data processing method and device | |
| CN114092221A (en) | Data processing method, apparatus, equipment and computer storage medium | |
| CN114254991A (en) | Method, device and device for reporting target object | |
| CN114648349A (en) | Method, device, electronic device and storage medium for using virtual resources | |
| CN111563183A (en) | Automatic generation method and device of visit record, computing equipment and storage medium | |
| CN111611170A (en) | Test method and device | |
| CN112035432A (en) | Data replacement and migration method, device and computer equipment | |
| CN114282978B (en) | Order price modification method, system and electronic equipment for test platform | |
| CN110618937A (en) | Software evaluation method, device and equipment | |
| CN112346973B (en) | Test method, device, equipment and storage medium | |
| CN112035358B (en) | Method, device and equipment for determining detection information | |
| US20240185196A1 (en) | Reduced memory resources for proactive monitoring of electronic transactions |
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 |