CN113656517B - Account checking file processing method and device, electronic equipment and storage medium - Google Patents
Account checking file processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN113656517B CN113656517B CN202111034544.6A CN202111034544A CN113656517B CN 113656517 B CN113656517 B CN 113656517B CN 202111034544 A CN202111034544 A CN 202111034544A CN 113656517 B CN113656517 B CN 113656517B
- Authority
- CN
- China
- Prior art keywords
- file
- reconciliation
- account checking
- result
- account
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computing Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application provides a reconciliation document processing method, a reconciliation document processing device, electronic equipment and a storage medium. The method comprises the following steps: obtaining a reconciliation file through a zkey tool; analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result; generating sales account files of different provinces according to the account checking result, and sending the sales account files to corresponding province servers to instruct each province server to generate receipt files according to the sales account files; and acquiring a receipt file of each province server, and updating the sales state of the reconciliation file according to the receipt file of each province server. According to the automatic account checking method and device, automatic account checking in recharging and paying can be achieved, tedious manual account checking of financial staff is avoided, account checking efficiency is improved, and account checking accuracy is guaranteed.
Description
Technical Field
The present disclosure relates to computer technology, and in particular, to a method and apparatus for processing a reconciliation document, an electronic device, and a storage medium.
Background
With the more and more perfect online service, users can complete online recharging and charging through mobile phones or computers, and because a plurality of institutions, such as third-party payment institutions, different banks and the like, are involved in the online recharging and charging process, the online self-service recharging and charging accuracy is more required to be ensured.
However, the existing online self-service recharging and paying account checking mode is a manual account checking mode for financial staff, and the account checking mode is complex in process, low in efficiency and not guaranteed in account checking accuracy.
Disclosure of Invention
The application provides a method, a device, electronic equipment and a storage medium for processing account checking files, which are used for realizing automatic account checking in recharging and paying, avoiding tedious manual account checking of financial staff, improving account checking efficiency and ensuring account checking accuracy.
In a first aspect, an embodiment of the present application provides a method for processing a reconciliation document, including:
obtaining a reconciliation file through a zkey tool;
analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result;
generating sales account files of different provinces according to the account checking result, and sending the sales account files to corresponding province servers to instruct each province server to generate receipt files according to the sales account files;
and acquiring a receipt file of each province server, and updating the sales state of the reconciliation file according to the receipt file of each province server.
In an optional implementation manner, the analyzing the reconciliation file through the preset script of the zkey tool to obtain a reconciliation result includes:
Importing the reconciliation file into a distributed relational database;
and calling a reconciliation file in the distributed relational database through the zkey tool, and analyzing and processing the reconciliation file through a preset script of the zkey tool to obtain a reconciliation result.
In an optional implementation manner, the distributed relational database includes payment data in an online platform of a government enterprise, the reconciliation file includes payment data of a payment platform, and the analyzing the reconciliation file through a preset script of the zkeyle tool to obtain a reconciliation result includes:
matching and matching the payment data with the payment data through a preset script of the zkey tool;
if the payment data and the payment data are not matched, determining that the reconciliation result is abnormal;
and if the payment data and the payment data are matched, determining that the reconciliation result is normal.
In an alternative embodiment, the method comprises:
if the account checking result is abnormal, acquiring abnormal data in the comparison file;
and marking the abnormal data, or/and outputting first reminding information corresponding to the abnormal data.
In an optional implementation manner, the analyzing the reconciliation file through the preset script of the zkey tool to obtain a reconciliation result includes:
analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result;
and if the execution result of each process node in the plurality of process nodes is normal, determining the initial reconciliation result as the reconciliation result.
In an alternative embodiment, the method further comprises:
if the process node with the abnormal execution result exists in the plurality of process nodes, determining the process node with the abnormal execution result as a target process node;
and outputting second prompt information corresponding to the target process node.
In an alternative embodiment, the method further comprises:
generating a summary file according to the receipt file of each province server, wherein the summary file comprises total amount information to be received and real total amount information to be received;
and sending the summary file to a fund platform file server.
In a second aspect, an embodiment of the present application provides a reconciliation document processing apparatus, the apparatus comprising:
The account checking file acquisition module is used for acquiring an account checking file through the zkey tool;
the account checking result acquisition module is used for analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result;
the sales document sending module is used for generating sales documents of different provinces according to the reconciliation result, and sending the sales documents to the corresponding province servers so as to instruct each province server to generate a receipt document according to the sales documents;
and the updating module is used for acquiring the receipt file of each province server and updating the sales state of the reconciliation file according to the receipt file of each province server.
In an alternative embodiment, the accounting result obtaining module is specifically configured to:
importing the reconciliation file into a distributed relational database;
and calling a reconciliation file in the distributed relational database through the zkey tool, and analyzing and processing the reconciliation file through a preset script of the zkey tool to obtain a reconciliation result.
In an optional implementation manner, the distributed relational database includes payment data in an online platform of a government enterprise, the reconciliation file includes payment data of a payment platform, and the reconciliation result acquisition module includes:
The comparison unit is used for matching and comparing the payment data with the payment data through a preset script of the zkey tool;
the anomaly determination unit is used for determining that the reconciliation result is anomalous if the payment data and the payment data are not matched;
and the normal determining unit is used for determining that the reconciliation result is normal if the payment data and the payment data are matched.
In an optional embodiment, the reconciliation document processing apparatus further comprises:
the abnormal data acquisition module is used for acquiring abnormal data in the comparison file if the account checking result is abnormal;
and the exception handling module is used for carrying out marking processing on the exception data or/and outputting first reminding information corresponding to the exception data.
In an optional implementation manner, the reconciliation result obtaining module further includes:
the initial account checking result obtaining unit is used for analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result;
and the execution result detection unit is used for determining the initial reconciliation result as the reconciliation result if the execution result of each process node in the plurality of process nodes is normal.
In an optional embodiment, the reconciliation document processing apparatus further comprises:
the target process node determining module is used for determining the process node with the abnormal execution result as the target process node if the process node with the abnormal execution result exists in the plurality of process nodes;
and the second prompt information output module is used for outputting second prompt information corresponding to the target process node.
In an optional embodiment, the reconciliation document processing apparatus further comprises:
the summary file generation module is used for generating a summary file according to the receipt file of each province server, wherein the summary file comprises total amount information to be received and real total amount information to be received;
and the summary file sending module is used for sending the summary file to the fund platform file server.
In a third aspect, an embodiment of the present application provides an electronic device, including: a memory and a processor;
a memory for storing the processor-executable instructions;
wherein the processor is configured to perform the method provided by the above embodiments.
In a fourth aspect, embodiments of the present application provide a computer-readable storage medium having stored therein computer-executable instructions, which when executed by a processor, are configured to implement the method provided by the foregoing embodiments.
In a fifth aspect, embodiments of the present application provide a computer program product comprising a computer program which, when executed by a processor, implements the method provided by the above embodiments.
According to the method, the device, the electronic equipment and the storage medium for processing the account checking file, the account checking file is acquired through the zkeyle tool, the account checking file is analyzed and processed through the preset script of the zkeyle tool, and the account checking result is obtained. And generating sales account files of different provinces according to the account checking result, sending the sales account files to corresponding province servers to instruct each province server to generate receipt files according to the sales account files, finally obtaining the receipt files of each province server, and updating the sales account states of the account checking files according to the receipt files of each province server, so that each province server can perform sales account processing on data in the account checking files according to the account checking result and the actual conditions of various provinces, and updating the sales account states in real time according to feedback of the province servers, thereby improving the account checking efficiency and the account checking accuracy.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
Fig. 1 is an application environment schematic diagram of a reconciliation document processing method provided in an embodiment of the present application;
fig. 2 is a flow chart of a reconciliation document processing method provided in an embodiment of the present application;
fig. 3 is a flow chart of another method for processing a reconciliation document according to an embodiment of the disclosure;
FIG. 4 is an interface schematic diagram of a GUI design interface provided by embodiments of the present application;
FIG. 5 is an interface schematic diagram of another GUI design interface provided by embodiments of the present application;
FIG. 6 is an interface schematic diagram of yet another GUI design interface provided by embodiments of the present application;
FIG. 7 is a flow chart of step 203 provided according to the embodiment of FIG. 3;
FIG. 8 is an interface schematic diagram of yet another GUI design interface provided by embodiments of the present application;
fig. 9 is a schematic structural diagram of a reconciliation document processing device according to an embodiment of the present application;
fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Specific embodiments thereof have been shown by way of example in the drawings and will herein be described in more detail. These drawings and the written description are not intended to limit the scope of the inventive concepts in any way, but to illustrate the concepts of the present application to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present application as detailed in the accompanying claims.
With the more and more perfect online service, users can finish recharging and paying on line through mobile phones or computers, and because a plurality of institutions, such as third party payment institutions, different banks and the like, can be involved in the online recharging and paying process, the online self-service recharging and paying account checking accuracy is more required to be ensured.
However, when the online self-service recharging and paying is checked out at present, the financial staff usually checks out the account manually, and the checking out mode is complex in process, low in efficiency and not guaranteed in checking out accuracy.
Because the manual reconciliation can not meet the rapid time development, the application of the reconciliation system is developed, in the current application of the reconciliation system, the application is mainly divided into a plurality of modules, file acquisition, file analysis, reconciliation processing and the like, the file acquisition is mainly active acquisition or opposite party pushing, most banks or third party payment institutions all require an access party to provide SSH file transfer protocol (Secret File Transfer Protocol, SFTP)/file transfer protocol (File Transfer Protocol, FTP) service, the reconciliation file is pushed onto a server at regular time, the reconciliation file in the server is downloaded into a directory analyzed in a local zone through a computer programming language (java) program, analysis and warehousing of the file are completed, comparison processing is carried out with local order data, and finally difference processing of the reconciliation is carried out by taking an order of a bank or a third party payment mechanism as a benchmark. With the continuous increase of the traffic, the response speed of the database and the performance of the database server can be bottleneck to influence the normal business according to the existing reconciliation mode design.
Specifically, the existing account checking scheme mainly uses the timing task of java to acquire account checking files from an upstream channel, analyzes and stores programs line by line, processes the account checking files by using the java program to connect a database, compares the account checking files based on one data, and searches out difference records. Relevant data is processed in the checking process.
However, if the reconciliation data is huge, pressure is caused to reading and writing of the database, the influence on performance is large, the reconciliation logic is extremely troublesome to expand, and with the daily accumulation of the reconciliation data, the database can encounter great challenges, and under the condition of large traffic, the load of a reconciliation server and a database server is high, and the whole reconciliation process is influenced.
The embodiment of the application provides a method, a device, electronic equipment and a storage medium for processing account checking files, which aim to solve the technical problems in the prior art, and the method, the device, the electronic equipment and the storage medium for processing account checking files can realize an account checking scheme by adopting a zkeyle tool, can reduce the pressure of application measurement by utilizing the characteristic of an asynchronous operation database of the zkeyle, reduce database connection, facilitate expansion of account checking logic by adopting a flexible deployment mode, a convenient and easy-to-use flow design and a flexible data conversion process, and further improve account checking efficiency.
The following explains the terms of art related to the application examples:
zkeydle: is a data warehouse technology (Extract Transform Load, ETL) tool that allows you to manage data from different databases, describes what you want to do by providing a graphical development environment, supports distributed deployment compared to open-source keyles, supports visual script deployment as planned, script message pre-warning, and increases support for heaven components.
The distributed relational database (Distributed Relational Database Servic, DRDS) is an aleba-self-developed, highly compatible distributed relational database service middleware to MySQL protocol and syntax. The method is focused on solving the problem of the expansibility of the single-machine relational database, has the characteristics of light weight (no state), flexibility, stability, high efficiency and the like, and compared with the traditional database, the method is more outstanding in the aspects of distributed technology and database separation keys, has the characteristics of light weight, flexibility, stability, high efficiency and the like, and is used for storing reconciliation data.
The kvStore is compatible with an open source Redis protocol standard, provides a persistent memory database service, and meets the service requirements of high read-write performance scenes and capacity flexible change configuration based on a high-reliability dual-machine hot standby architecture and a seamless expandable cluster architecture.
The application environment of the reconciliation document processing method in the embodiment of the present application is described below, and as shown in fig. 1, the application environment may include a payment company, an online platform of a government enterprise, a DRDS database, a province system, and a fund platform.
The government enterprise online platform can respectively establish communication links with the payment company, the DRDS database, the province system and the fund platform so as to realize data transmission. The payment company, the government enterprise online platform, the DRDS database, the province system and the fund platform can be servers. The payment company can push the reconciliation document to the government enterprise online platform. The government enterprise online platform may push files to the funding platform. And the government enterprise online platform and the province system mutually transmit files. The government enterprise online platform may also write data to or extract data from the DRDS database.
The following describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 2 is a flow chart of a reconciliation document processing method provided in an embodiment of the present application, as shown in fig. 2, where the method provided in the embodiment includes:
101. and obtaining the reconciliation file through a zkey tool.
The execution body of the present embodiment may be, for example, an electronic device, or a terminal device, or a server, or other apparatus or device that may execute the present embodiment, without limitation. The embodiment is described with an execution body as a server, and may specifically be a server of an online platform of an enterprise in fig. 1.
In some embodiments, the government enterprise online platform may obtain, via the zkeyle tool, a reconciliation file pushed by the payment company to a file server of the government enterprise online platform. The reconciliation file may include payment data recorded by a payment company or a payment platform, such as payment data paid by a user to a merchant via a WeChat, a Payment device, a Union, or the like. In particular, the payment data may include payment amount, payment time, paymate, user information, and the like.
102. And analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result.
In some embodiments, the online government and enterprise platform may compare and analyze the payment data of the payment company with the payment data recorded in the online government and enterprise platform through a preset script of the zkeyle tool, specifically, the preset script may be used to compare the payment data of the payment company with the payment data recorded in the online government and enterprise platform in consistency, and if the payment data of the payment company is consistent with the payment data recorded in the online government and enterprise platform, it may be determined that the payment result is normal. If the payment data of the payment company is inconsistent with the payment data recorded in the government enterprise online platform, the reconciliation result can be determined to be abnormal.
In some embodiments, if the online platform of the government enterprise determines that the reconciliation result is abnormal, the abnormal data may be further analyzed, and the abnormal data may be recorded in the reconciliation result. Alternatively, the anomaly data may include a difference between payment data of a payment company and payment data recorded in an online platform of an enterprise, a payment company in which anomaly occurs, a region to which the anomaly data corresponds, a province, and the like.
103. And generating sales account files of different provinces according to the account checking result, and sending the sales account files to the corresponding province servers to instruct each province server to generate a receipt file according to the sales account files.
In some embodiments, the government enterprise online platform may generate BSS (business support system) sales documents of provinces according to the reconciliation result, and send the sales documents corresponding to each province to the province server of the corresponding province, so as to instruct each province server to generate a receipt document according to the sales documents received by the province server. The sales account file corresponding to the province can include data such as receivable amount of the province. The receipt file corresponding to the province may include data that may reflect the situation of the receivable amount and the actual receivable amount of the province, for example, a difference between the receivable amount and the actual receivable amount of the province, or a difference cause, etc.
As an example, the server in the province of sichuan may record in real time the actual amount of the province in the last month, then perform the posting process according to the actual amount and the last month of the accounts receivable in the posting document, and generate the receipt document according to the posting result, for example, the receipt document may include data such as the deviation between the actual amount and the accounts receivable in the last month, the degree of the deviation, and the like.
104. And acquiring the receipt file of each province server, and updating the sales state of the account checking file according to the receipt file of each province server.
In some real-time modes, the government enterprise online platform may send a request for acquiring the receipt file to each province server to instruct the province server to feed back the receipt file, thereby acquiring the receipt file of each province server, and then update the sales state of the reconciliation file according to the receipt file of each province server. Specifically, the data for reflecting the sales state of the reconciliation document may be updated and stored in a file server of the government enterprise online platform, or the data for reflecting the sales state of the reconciliation document may be displayed on a display of the government enterprise online platform and updated in real time.
In this embodiment, the reconciliation file is obtained through the zkeyle tool, and the reconciliation file is analyzed and processed through a preset script of the zkeyle tool to obtain a reconciliation result. And generating sales account files of different provinces according to the account checking result, sending the sales account files to corresponding province servers to instruct each province server to generate receipt files according to the sales account files, finally obtaining the receipt files of each province server, and updating the sales account states of the account checking files according to the receipt files of each province server, so that each province server can perform sales account processing on data in the account checking files according to the account checking result and the actual conditions of various provinces, and updating the sales account states in real time according to feedback of the province servers, thereby improving the account checking efficiency and the account checking accuracy. In addition, by adopting the zkeyle tool, the job timing task can be deployed visually, the reconciliation file can be imported into the database at fixed time, the zkeyle asynchronous operation database is used, the application testing pressure can be reduced, the database connection is reduced, the flexible deployment mode, the convenient and easy-to-use flow design and the flexible data conversion process are also beneficial to the expansion of the reconciliation logic, and the single-machine database capacity bottleneck and the database expansion difficulty are solved.
Fig. 3 is a flow chart of another method for processing a reconciliation file according to an embodiment of the present application, as shown in fig. 3, where the method provided in the embodiment includes:
201. and obtaining the reconciliation file through a zkey tool.
202. And importing the reconciliation file into a distributed relational database.
In some embodiments, the online platform of the government enterprise may use zkey to obtain a reconciliation file pushed to the file server by the payment company, and import the reconciliation file into a distributed relational database (hereinafter referred to as DRDS database), compare and analyze the data of the payment company with the payment data in the online platform of the government enterprise, process the abnormal data, obtain a reconciliation result, and load and replace the reconciliation result into the DRDS database, where the reconciliation data may be a table corresponding to the reconciliation result.
203. And calling a reconciliation file in the distributed relational database through the zkey tool, and analyzing and processing the reconciliation file through a preset script of the zkey tool to obtain a reconciliation result.
In some embodiments, the distributed relational database includes payment data in an online platform of the government enterprise, the reconciliation file includes payment data for a payment platform, and the specific embodiment of step 203 includes: matching and matching the payment data with the payment data through a preset script of the zkey tool, and if the payment data is not matched with the payment data, determining that the account checking result is abnormal; if the payment data and the payment data are matched, determining that the checking result is normal.
Alternatively, if the payment data and the payment data are not identical, it may be determined that the payment data and the payment data do not match; if the payment data and the payment data are consistent, it may be determined that the payment data and the payment data match.
Alternatively, if the difference between the payment data and the payment data is within a specified range, it may be determined that the payment data and the payment data match. Otherwise, determining that the payment data and the payment data do not match.
In the embodiment, the data of different platforms are compared for checking account, so that the accuracy of checking account can be ensured.
In some embodiments, if the accounting result is abnormal, obtaining abnormal data in the comparison file; and marking the abnormal data, or/and outputting first reminding information corresponding to the abnormal data.
As an example, the abnormal data may be highlighted and displayed, or displayed in a specific color or in a specific display manner.
As another example, the first alert information corresponding to the abnormal data may be specifically sent to the mobile terminal of the user to prompt the user that the reconciliation data is abnormal.
204. And generating sales account files of different provinces according to the account checking result, and sending the sales account files to the corresponding province servers to instruct each province server to generate a receipt file according to the sales account files.
As an example, as shown in fig. 4, a user may preset a script for a sales document generation process in a graphical user interface (Graphical User Interface, GUI) design interface of the zkey tool, where the script for the sales document generation process may correspond to a plurality of process nodes, such as process nodes for checking payment tasks, generating reconciliation data, generating BSS files, uploading files, and the like. When any one of the process nodes fails, a short message can be sent to the user to remind the user of the position of the failure point. Specifically, the specific process for generating the sales document may be: start (Start), set variable_automatic, judge payment task, check payment task, generate reconciliation data, generate BSS file, upload BSS file success, insert log, update task, success. If the payment task is checked, checking data is generated, a BSS file is generated, and a failure occurs on the file, for example, the payment task fails, checking data is generated, the BSS file fails, and the BSS file fails to be uploaded, a short message may be sent to remind the user, and the operation is stopped at the failed process node. The set variable_automatic may be a variable that sets the process node to be turned on or off, or the like.
The government enterprise online platform can adopt kvstore as a provincial switch, and different account checking schemes can be customized according to different provincials.
205. And acquiring the receipt file of each province server, and updating the sales state of the account checking file according to the receipt file of each province server.
As an example, as shown in fig. 5, a user may preset a script for updating a status process of a sales order according to a receipt file in a graphical GUI design interface of the zkeyle tool, where the script for updating the status process of the sales order according to the receipt file may correspond to a plurality of process nodes, such as process nodes for checking CBSS (centralized service support system) upload tasks, checking BSS upload tasks, downloading the receipt file, calling HTTP interface, calling abnormal order interface, etc. When any one of the process nodes fails, a short message can be sent to the user to remind the user of the position of the failure point. Specifically, the specific process of updating the sales status according to the receipt file may be as follows: starting (Start), setting variable_automatic, judging CBSS and BSS uploading tasks, checking CBSS uploading tasks, checking BSS uploading tasks, downloading receipt files, warehousing receipt files, checking receipt files, calling an HTTP interface, calling an abnormal order interface, obtaining success of the receipt tasks, inserting logs, updating tasks and success, wherein if the CBSS uploading tasks, the BSS uploading tasks, the receipt file downloading, the HTTP interface and the abnormal order interface are checked, a short message can be sent to remind a user, and the operation is stopped at a failed process node. The set variable_automatic may be a variable that sets each process node to be turned on or off. Wherein, the task of checking the CBSS uploading may be to check whether the CBSS file uploading is successful. Checking the BSS upload task may be checking whether the BSS file upload was successful.
206. And generating a summary file according to the receipt file of each province server, wherein the summary file comprises receivable total information and real receivable total information.
207. And sending the summarized file to a funding platform file server.
The fund platform file server can count and record nationwide payment data.
As an example, as shown in fig. 6, a user may preset a script related to a process of generating a summary file in a graphical GUI design interface of the zkeyle tool, where the summary file may also be called a fund platform file or a file required by a fund platform, and the script related to the process of generating the summary file may correspond to a plurality of process nodes, for example, a process node of checking a sales task, generating fund platform data, generating a fund platform file, uploading a file, and the like. When any one of the process nodes fails, a short message can be sent to the user to remind the user of the position of the failure point. Specifically, the specific process for generating the summary file may be: starting (Start), setting an uploading variable, judging an account sales task, generating fund platform data, generating a fund platform file, uploading a file, uploading log parameters, inserting a log, updating a task and success, wherein the account sales log can be checked if the account sales verification task fails, the data log can be generated if the fund platform data fails, the file log can be generated if the fund platform file fails, the file uploading log can be generated if the fund platform file fails, then a failed process node is sent to a user through a short message, and the operation is stopped at the failed process node. The determining the sales task may be for detecting whether the sales task is a normal sales or an abnormal sales.
In some embodiments, as shown in fig. 7, the specific embodiment of step 203 includes the following sub-steps:
2031. and analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result.
2032. If the execution result of each process node in the plurality of process nodes is normal, determining the initial account checking result as an account checking result.
2033. If the process node with the abnormal execution result exists in the plurality of process nodes, determining the process node with the abnormal execution result as the target process node.
2034. And outputting second prompt information corresponding to the target process node. As an example, as shown in fig. 8, a user may set a preset script in a graphical GUI design interface of the zkeyle tool, for example, when setting a preset script for performing an analysis process on a reconciliation file, a plurality of process nodes may be set graphically. When the preset script is executed, the preset script may be sequentially executed according to the corresponding plurality of proceeding nodes. When a certain process node fails, a second prompt message (such as a short message) can be sent to the mobile terminal of the user to remind the user, and if one process is grounded and no failure occurs, the next process node can be automatically entered. The process node may include file download parsing, copying data to a snapshot table, government order statistics and changing title table, reconciliation process, invoking hypertext transfer protocol (Hyper Text Transfer Protocol, HTTP) interface, etc., requesting httpfile. Wherein httpfile is a client programming toolkit. Specifically, the whole process of analyzing and processing the account document can be sequentially as follows: starting (Start), generating the subsequent required unified parameters, warehousing a task table, downloading and analyzing files, copying data to a snapshot table, counting government and enterprise orders and changing a title table, checking a process, requesting HttpClient, calling an HTTP interface, setting a variable 5, changing a title table record 2 and success. The file downloading analysis, data copying to a snapshot table, government and enterprise order statistics and title table changing, account checking flow, httpClien requesting, title table changing record 2 failure, and HTTP interface calling failure can send a short message to remind, the failure short message can be recorded in a log 2, then a variable is set according to the log 2 to copy the title table attribute, so that the title table recording is changed, the title table recording after changing is sent to a user through the short message, and then the operation is stopped.
Optionally, the first prompt information and the second prompt information include, but are not limited to, short message information, voice information, image information, and the like.
In this embodiment, the zkey is used to obtain the account checking file pushed to the file server by the payment company, and the account checking file is imported into the DRDS database, so that the data of the payment company and the payment data in the online platform of the government enterprise are compared and analyzed, and the abnormal data is processed. And then, the zkey is used for calling the reconciliation data after comparison in the DRDS database, a provincial BSS sales document is generated and pushed to each provincial document server, so that the provincial sales document can be obtained by sales of provincial departments, and the zkey is used for calling a sales interface to update the payment sales state. And finally, generating files (such as total amount to be received and total amount to be received) required by the fund platform according to provinces, and pushing the files to a fund platform file server. Therefore, the zkeyle tool and the DRDS database can be utilized to stably and orderly reconcile the payment data of each province, and the reconciliation efficiency is improved. The method comprises the steps of visually deploying jobs through a zkeyle tool, importing the reconciliation file into a DRDS at regular time, and using a zkeyle asynchronous operation database, so that the pressure of application measurement can be reduced, database connection is reduced, a flexible deployment mode, a convenient and easy-to-use flow design and a flexible data conversion process are also beneficial to the expansion of reconciliation logic. Meanwhile, the DRDS supports the characteristics of library division, table division, smooth capacity expansion, service lifting allocation, transparent read-write separation, distributed transaction and the like, reduces the pressure of a database server, and solves the problems of single-machine database capacity bottleneck and difficult database expansion.
Fig. 9 is a schematic structural diagram of a reconciliation document processing device provided in an embodiment of the present application, and as shown in fig. 9, the device includes:
the reconciliation document acquisition module 31 is configured to acquire a reconciliation document through the zkeyle tool.
And the account checking result obtaining module 32 is configured to analyze and process the account checking file through a preset script of the zkey tool to obtain an account checking result.
The sales document sending module 33 is configured to generate sales documents of different provinces according to the accounting result, and send the sales documents to the corresponding province servers, so as to instruct each province server to generate a receipt document according to the sales documents.
And the updating module 34 is configured to obtain the receipt file of each province server, and update the sales status of the reconciliation file according to the receipt file of each province server.
In some embodiments, the reconciliation result acquisition module 32 is specifically configured to:
and importing the reconciliation file into a distributed relational database.
And calling a reconciliation file in the distributed relational database through the zkey tool, and analyzing and processing the reconciliation file through a preset script of the zkey tool to obtain a reconciliation result.
In some embodiments, the distributed relational database includes payment data in an online platform of the government enterprise, the reconciliation file includes payment data for a payment platform, and the reconciliation result acquisition module 32 includes:
And the comparison unit is used for matching and comparing the payment data with the payment data through a preset script of the zkey tool.
And the abnormality determining unit is used for determining that the checking result is abnormal if the payment data and the payment data are not matched.
And the normal determining unit is used for determining that the checking result is normal if the payment data and the payment data are matched.
In some embodiments, the reconciliation document processing apparatus further comprises:
the abnormal data acquisition module is used for acquiring abnormal data in the comparison file if the account checking result is abnormal.
The exception handling module is used for carrying out marking processing on the exception data or/and outputting first reminding information corresponding to the exception data.
In some implementations, the reconciliation result acquisition module 32 further includes:
and the initial account checking result acquisition unit is used for analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result.
And the execution result detection unit is used for determining the initial account checking result as the account checking result if the execution result of each process node in the plurality of process nodes is normal.
In some embodiments, the reconciliation document processing apparatus further comprises:
And the target process node determining module is used for determining the process node with the abnormal execution result as the target process node if the process node with the abnormal execution result exists in the plurality of process nodes.
And the second prompt information output module is used for outputting second prompt information corresponding to the target process node.
In some embodiments, the reconciliation document processing apparatus further comprises:
and the summary file generation module is used for generating a summary file according to the receipt file of each province server, wherein the summary file comprises total amount information and real total amount information.
And the summary file sending module is used for sending the summary file to the fund platform file server.
For example, the present embodiment may refer to the above method embodiment, and the principle and technical effects thereof are similar, and will not be described again.
Fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application, and as shown in fig. 10, the electronic device includes a memory 43 and a processor 42.
A memory 43 for storing instructions executable by the processor 42.
The processor 42 is configured to perform the methods provided by the above embodiments.
The electronic device further comprises a receiver 40 and a transmitter 41. The receiver 40 is for receiving instructions and data transmitted from an external device, and the transmitter 41 is for transmitting instructions and data to the external device.
The electronic device may be a mobile phone, a computer, a tablet computer, etc.
Specifically, the electronic device may further include one or more of the following components: processing components, power components, multimedia components, input/output (I/O) interfaces. The processing assembly may correspond to the processor 42 of the above-described embodiment,
the processing component generally controls overall operation of the electronic device, such as operations associated with display and recording operations. The processing component may include one or more processors to execute instructions to perform all or part of the steps of the methods described above. Further, the processing component may include one or more modules that facilitate interactions between the processing component and other components. For example, the processing component may include a multimedia module to facilitate interaction between the multimedia component and the processing component.
The memory is configured to store various types of data to support operations at the electronic device. Examples of such data include instructions for any application or method operating on an electronic device, and the like. The memory may be implemented by any type of volatile or nonvolatile memory device or combination thereof, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, and the like.
The power supply assembly provides power to the various components of the electronic device. Power components may include a power management system, one or more power sources, and other components associated with generating, managing, and distributing power for electronic devices.
The multimedia assembly includes a screen between the electronic device and the user that provides an output interface. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from a user. The touch panel includes one or more touch sensors to sense touches, swipes, and gestures on the touch panel. The touch sensor may sense not only the boundary of a touch or slide action, but also the duration and pressure associated with the touch or slide operation.
The I/O interface provides an interface between the processing assembly and a peripheral interface module, which may be a keyboard, click wheel, button, etc. These buttons may include, but are not limited to: homepage button, volume button, start button, and lock button.
In an exemplary embodiment, a non-transitory computer readable storage medium is also provided, such as a memory, comprising instructions executable by a processor of an electronic device to perform the above-described method. For example, the non-transitory computer readable storage medium may be ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, etc.
The present application provides a computer-readable storage medium having stored therein computer-executable instructions which, when executed by a processor, are configured to implement the methods provided by the above embodiments.
Embodiments of the present application provide a computer program product comprising: a computer program stored in a readable storage medium, from which at least one processor of an electronic device can read, the at least one processor executing the computer program causing the electronic device to perform the solution provided by any one of the embodiments described above.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the application following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the application pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It is to be understood that the present application is not limited to the precise arrangements and instrumentalities shown in the drawings, which have been described above, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the application is limited only by the appended claims.
Claims (8)
1. A reconciliation document processing method, comprising:
obtaining a reconciliation file through a zkey tool;
analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result;
generating sales account files of different provinces according to the account checking result, and sending the sales account files to corresponding province servers to instruct each province server to generate receipt files according to the sales account files;
acquiring a receipt file of each province server, and updating the sales state of the reconciliation file according to the receipt file of each province server;
the step of analyzing and processing the account checking file through the preset script of the zkey tool to obtain an account checking result comprises the following steps:
analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result;
if the execution result of each process node in the plurality of process nodes is normal, determining the initial reconciliation result as the reconciliation result;
If the process node with the abnormal execution result exists in the plurality of process nodes, determining the process node with the abnormal execution result as a target process node;
and outputting second prompt information corresponding to the target process node.
2. The method according to claim 1, wherein the analyzing the reconciliation document by the preset script of the zkeyle tool to obtain a reconciliation result includes:
importing the reconciliation file into a distributed relational database;
and calling a reconciliation file in the distributed relational database through the zkey tool, and analyzing and processing the reconciliation file through a preset script of the zkey tool to obtain a reconciliation result.
3. The method according to claim 2, wherein the distributed relational database includes payment data in an online platform of a government enterprise, the reconciliation file includes payment data of a payment platform, and the analyzing the reconciliation file by a preset script of the zkeyle tool to obtain a reconciliation result includes:
matching and matching the payment data with the payment data through a preset script of the zkey tool;
If the payment data and the payment data are not matched, determining that the reconciliation result is abnormal;
and if the payment data and the payment data are matched, determining that the reconciliation result is normal.
4. A method according to claim 3, characterized in that the method comprises:
if the account checking result is abnormal, acquiring abnormal data in a comparison file;
and marking the abnormal data, or/and outputting first reminding information corresponding to the abnormal data.
5. The method according to any one of claims 1-4, further comprising:
generating a summary file according to the receipt file of each province server, wherein the summary file comprises total amount information to be received and real total amount information to be received;
and sending the summary file to a fund platform file server.
6. A reconciliation document processing apparatus, the apparatus comprising:
the account checking file acquisition module is used for acquiring an account checking file through the zkey tool;
the account checking result acquisition module is used for analyzing and processing the account checking file through a preset script of the zkey tool to obtain an account checking result;
the sales document sending module is used for generating sales documents of different provinces according to the reconciliation result, and sending the sales documents to the corresponding province servers so as to instruct each province server to generate a receipt document according to the sales documents;
The updating module is used for acquiring the receipt file of each province server and updating the sales state of the reconciliation file according to the receipt file of each province server;
the account checking result obtaining module comprises:
the initial account checking result obtaining unit is used for analyzing and processing the account checking file according to a plurality of process nodes corresponding to the preset script to obtain an initial account checking result;
the execution result detection unit is used for determining the initial reconciliation result as the reconciliation result if the execution result of each process node in the plurality of process nodes is normal;
the target process node determining module is used for determining the process node with the abnormal execution result as the target process node if the process node with the abnormal execution result exists in the plurality of process nodes;
and the second prompt information output module is used for outputting second prompt information corresponding to the target process node.
7. An electronic device, comprising: a memory and a processor;
a memory for storing the processor-executable instructions;
wherein the processor is configured to perform the method of any of claims 1-4.
8. A computer readable storage medium having stored therein computer executable instructions which when executed by a processor are adapted to carry out the method of any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111034544.6A CN113656517B (en) | 2021-09-03 | 2021-09-03 | Account checking file processing method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111034544.6A CN113656517B (en) | 2021-09-03 | 2021-09-03 | Account checking file processing method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113656517A CN113656517A (en) | 2021-11-16 |
| CN113656517B true CN113656517B (en) | 2023-06-06 |
Family
ID=78493521
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111034544.6A Active CN113656517B (en) | 2021-09-03 | 2021-09-03 | Account checking file processing method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113656517B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101887546A (en) * | 2010-06-28 | 2010-11-17 | 深圳市拜特科技股份有限公司 | Method for realizing audit verification of account, audit verification of account system and revenue audit system |
| CN102281521A (en) * | 2010-06-10 | 2011-12-14 | 中国电信股份有限公司 | Telecom charging operating network system and charging method thereof |
| WO2017020740A1 (en) * | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| CN206162712U (en) * | 2016-09-14 | 2017-05-10 | 广州地铁设计研究院有限公司 | Automatic fare collection suitable for intercity accessible district interconnection that pays of urban rail transit |
| CN107045703A (en) * | 2017-01-18 | 2017-08-15 | 银联国际有限公司 | Cross-border transaction clearance based on digital signature |
| CN107332713A (en) * | 2017-08-10 | 2017-11-07 | 上海新炬网络技术有限公司 | A kind of traffic failure engine of positioning implementation method based on script |
| CN109727108A (en) * | 2018-12-26 | 2019-05-07 | 金交恒通有限公司 | All-purpose card interconnects allocation settlement system |
| CN110060140A (en) * | 2019-03-15 | 2019-07-26 | 深圳壹账通智能科技有限公司 | Mass data account checking method, device, medium and computer equipment |
| CN112464049A (en) * | 2020-12-11 | 2021-03-09 | 中国联合网络通信集团有限公司 | Method, device and equipment for downloading detailed number list |
| CN112506978A (en) * | 2020-12-15 | 2021-03-16 | 中国联合网络通信集团有限公司 | Big data real-time processing method, device and equipment |
| CN112541752A (en) * | 2019-09-23 | 2021-03-23 | 北京轻享科技有限公司 | Expense processing method and device for vehicle rental platform, computer equipment and medium |
-
2021
- 2021-09-03 CN CN202111034544.6A patent/CN113656517B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102281521A (en) * | 2010-06-10 | 2011-12-14 | 中国电信股份有限公司 | Telecom charging operating network system and charging method thereof |
| CN101887546A (en) * | 2010-06-28 | 2010-11-17 | 深圳市拜特科技股份有限公司 | Method for realizing audit verification of account, audit verification of account system and revenue audit system |
| WO2017020740A1 (en) * | 2015-08-06 | 2017-02-09 | 阿里巴巴集团控股有限公司 | Inventory data reconciliation method and device |
| CN206162712U (en) * | 2016-09-14 | 2017-05-10 | 广州地铁设计研究院有限公司 | Automatic fare collection suitable for intercity accessible district interconnection that pays of urban rail transit |
| CN107045703A (en) * | 2017-01-18 | 2017-08-15 | 银联国际有限公司 | Cross-border transaction clearance based on digital signature |
| CN107332713A (en) * | 2017-08-10 | 2017-11-07 | 上海新炬网络技术有限公司 | A kind of traffic failure engine of positioning implementation method based on script |
| CN109727108A (en) * | 2018-12-26 | 2019-05-07 | 金交恒通有限公司 | All-purpose card interconnects allocation settlement system |
| CN110060140A (en) * | 2019-03-15 | 2019-07-26 | 深圳壹账通智能科技有限公司 | Mass data account checking method, device, medium and computer equipment |
| CN112541752A (en) * | 2019-09-23 | 2021-03-23 | 北京轻享科技有限公司 | Expense processing method and device for vehicle rental platform, computer equipment and medium |
| CN112464049A (en) * | 2020-12-11 | 2021-03-09 | 中国联合网络通信集团有限公司 | Method, device and equipment for downloading detailed number list |
| CN112506978A (en) * | 2020-12-15 | 2021-03-16 | 中国联合网络通信集团有限公司 | Big data real-time processing method, device and equipment |
Non-Patent Citations (2)
| Title |
|---|
| 一种专用充电平台方案的关键技术实现;周山虎 等;电气技术;第22卷(第3期);98-103 * |
| 人民银行与商业银行电子对账系统设计;葛电虹;华南金融电脑(第08期);44-45 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113656517A (en) | 2021-11-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11645710B2 (en) | Systems and methods of mobile banking reconciliation | |
| US9959330B2 (en) | Mechanism for updating OLAP system structure and OLTP system structure | |
| US20140282371A1 (en) | Systems and methods for creating or updating an application using a pre-existing application | |
| US20060218086A1 (en) | Payee aliasing | |
| AU2018241159B2 (en) | Contextual solicitation in a starter application | |
| US7752068B1 (en) | Synergy tracking tool | |
| US11709842B2 (en) | System and method for implementing a reporting engine framework | |
| US10877869B1 (en) | Method and system for implementing a code review tool | |
| CN108885630B (en) | Digital media content comparator | |
| CN113656517B (en) | Account checking file processing method and device, electronic equipment and storage medium | |
| CA3055847C (en) | Method, device, storage medium and client for page return | |
| CN111666166A (en) | Service providing method, device, equipment and storage medium | |
| JP2020004423A (en) | Server, information processing device, processing method and program | |
| CN107038216B (en) | Thesis duplicate checking method, device, equipment and storage medium | |
| US11704095B2 (en) | Dynamic API bot for robotic process automation | |
| CN115793924A (en) | Method, device and equipment for maintaining bank front-end dynamic menu | |
| US11023830B2 (en) | Processing a request in accordance with original rules and configurations | |
| US20160373402A1 (en) | Information Management and Notification System | |
| US11379500B2 (en) | Automated data integration, reconciliation, and self healing using machine learning | |
| US20240168800A1 (en) | Dynamically executing data source agnostic data pipeline configurations | |
| US20220318753A1 (en) | System and method for performing analysis and generating remediation estimations for user interfaces associated with software applications | |
| US20240193129A1 (en) | Consistency management of computing objects or files | |
| KR102195576B1 (en) | System and method for finacial service | |
| CN112419036A (en) | Accounting data processing system | |
| CN112419037A (en) | Accounting data processing system under full-flow automatic visualization |
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 |