CN111367940A - Unified development method of bank transaction report, client and server system - Google Patents
Unified development method of bank transaction report, client and server system Download PDFInfo
- Publication number
- CN111367940A CN111367940A CN202010149969.0A CN202010149969A CN111367940A CN 111367940 A CN111367940 A CN 111367940A CN 202010149969 A CN202010149969 A CN 202010149969A CN 111367940 A CN111367940 A CN 111367940A
- Authority
- CN
- China
- Prior art keywords
- report
- bank transaction
- data
- module
- template
- 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.)
- Pending
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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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/02—Banking, e.g. interest calculation or account maintenance
Abstract
The invention provides a unified development method of bank transaction reports, a client and a server system, wherein the server system comprises: the system comprises an SQL statement execution module, a report statistical data determination module, a report template and report generation parameter configuration module and a server main control program; the SQL sentence execution module is used for acquiring report data from a database according to the SQL sentences; the report statistical data determining module is used for performing statistical analysis on the report data and determining report statistical data; the report template and report generation parameter configuration module is used for configuring the report template and report generation parameters; and the server side main control program is used for calling the SQL statement execution module, the report statistical data determination module and the report template module to generate a bank transaction report. The invention can complete the rapid development of a bank transaction report by configuring the necessary SQL statement, report generation parameter and report template, thereby improving the generation efficiency of the bank transaction report.
Description
Technical Field
The invention relates to the technical field of bank transaction data processing, in particular to a unified development method of a bank transaction report, a client and a service end system.
Background
The bank transaction report is a business form which is generally screened from one or more tables of the database according to certain rules. The bank transaction report forms are always an important way for business departments to know data such as customer volume, transaction volume and the like, so that the requirements of the business departments on the bank transaction report forms are increasingly improved.
The most tedious and repeated work and time-consuming work of developers is to query a large amount of databases, write codes, output searched data according to the format of a report form and print and typeset the searched data. The codes compiled in this way not only have low development efficiency and poor program readability, but also have large workload of later maintenance. When the user's requirement changes, if the programmer does not understand the code to be modified deeply, it is likely to cause mistakes and omissions, and the modification cost is high.
Disclosure of Invention
The embodiment of the invention provides a service end system for uniformly developing bank transaction reports, which can complete the development of a bank transaction report by only configuring necessary SQL statements, report generation parameters and a report template, and comprises:
the system comprises an SQL statement execution module, a report statistical data determination module, a report template and report generation parameter configuration module and a server main control program;
the SQL sentence execution module is used for acquiring report data from a database according to the SQL sentences;
the report statistical data determining module is used for performing statistical analysis on the report data and determining report statistical data;
the report template and report generation parameter configuration module is used for configuring the report template and report generation parameters;
and the server side main control program is used for calling the SQL statement execution module, the report statistical data determination module and the report template module to generate a bank transaction report.
The embodiment of the present invention further provides a client for uniformly developing a bank transaction report, which is used for interacting with the system for uniformly developing a bank transaction report, and includes: the report configuration unit, the report data preview unit and the remote report generation unit;
the report configuration unit is used for configuring the SQL statement, the report generation parameter and the report template according to the service requirement and the report sample;
the report data previewing unit is used for visually previewing the correctness of the report data;
and the remote report generation unit is used for remotely calling a server main control program deployed on the bank transaction report unified development server system to generate a bank transaction report.
The embodiment of the invention also provides a unified development method of the bank transaction report, which comprises the following steps:
configuring SQL sentences, report generation parameters and report templates according to business requirements and report samples;
acquiring report data from a database according to the SQL statement;
carrying out statistical analysis on the report data to determine report statistical data;
and generating a bank transaction report according to the report statistical data, the report generation parameters and the report template.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can be operated on the processor, wherein the processor realizes the unified development method of the bank transaction report when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program for implementing the unified development method of the bank transaction report.
According to the unified development method for the bank transaction reports, the client and the server-side system provided by the embodiment of the invention, the SQL sentence is configured, the report data is obtained from the database, then the statistical analysis is carried out on the report data, the report statistical data is determined, the bank transaction reports can be quickly generated by combining the report statistical data with the report template and the report generation parameter, the report pattern can be seen in the early-stage demand communication stage of business personnel, the business change cost is reduced, only the SQL sentence, the report generation parameter and the report template need to be modified when the business is changed, and a new program does not need to be compiled again according to the business change, so that the traditional development mode of drawing the reports from head to tail by using a bottom code is abandoned, and the generation efficiency of the bank transaction reports is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a schematic diagram of a system for uniformly developing a bank transaction report according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a client for uniformly developing a bank transaction report according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a configuration SQL statement configured by a client for uniformly developing bank transaction statements according to an embodiment of the present invention.
Fig. 4 is a schematic diagram of report generation parameters configured by a client for unified development of bank transaction reports according to an embodiment of the present invention.
Fig. 5 is a report template diagram configured by a client for uniformly developing bank transaction reports according to an embodiment of the present invention.
Fig. 6 is a representation diagram of a bank transaction report generated by a system for unified development of a bank transaction report service according to an embodiment of the present invention.
Fig. 7 is a schematic diagram illustrating a unified development method of a bank transaction report according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
As shown in fig. 1, a schematic diagram of a system for uniformly developing a bank transaction report according to an embodiment of the present invention is shown, in which the system for uniformly developing a bank transaction report according to an embodiment of the present invention only needs to configure necessary SQL statements, report generation parameters, and a report template to complete the development of a bank transaction report, and the system for developing a bank transaction report according to an embodiment of the present invention includes:
the system comprises an SQL statement execution module 101, a report statistic data determination module 102, a report template and report generation parameter configuration module 103 and a server side main control program 104;
the SQL sentence execution module 101 is used for acquiring report data from a database according to the SQL sentence;
the report statistical data determining module 102 is configured to perform statistical analysis on the report data to determine report statistical data;
a report template and report generation parameter configuration module 103, configured to configure a report template and report generation parameters;
and the server-side main control program 104 is used for calling the SQL statement execution module, the report statistical data determination module and the report template module to generate a bank transaction report.
The business personnel can see the report form pattern in the early-stage demand communication stage, thereby reducing the business change cost, only needing to modify the SQL sentence, the report form generation parameter and the report form template when the business is changed, and not needing to modify the source program and compile the source code again according to the business change, thereby abandoning the traditional development mode of drawing the report form from head to tail by using a bottom layer code, and improving the generation efficiency of the bank transaction report form.
The current bank transaction report is generated independently according to the bank system and is related to the language used by the system code. The generated strategy is placed in executable codes, and when report modification is needed, a source program and a compiling source code are needed to be modified. Therefore, the generation of the report is generated by storing in the source code, and has the problems of non-configuration, high maintenance difficulty and the like. In order to solve the above problem, an embodiment of the present invention provides a system for uniformly developing a bank transaction report, including: the system comprises an SQL statement execution module, a report statistical data determination module, a report template and report generation parameter configuration module and a server main control program; the SQL sentence execution module is used for acquiring report data from a database according to the SQL sentences; the report statistical data determining module is used for performing statistical analysis on the report data and determining report statistical data; the report template and report generation parameter configuration module is used for configuring the report template and report generation parameters; and the server side main control program is used for calling the SQL statement execution module, the report statistical data determination module and the report template module to generate a bank transaction report.
When the system for uniformly developing a bank transaction report according to an embodiment of the present invention is implemented specifically, in an embodiment, the system may further include: and the monitoring module is used for monitoring the generation process of the bank transaction report and generating a monitoring log. In the embodiment, the report generation process can be monitored according to the level (DEBUG level to ERROR level) according to needs. The DEBUG level records the most detailed report generation log and is suitable for the development and test process; the ERROR level only records ERROR logs and is suitable for production maintenance.
When the system for uniformly developing a bank transaction report according to an embodiment of the present invention is implemented specifically, in an embodiment, the system may further include: and the API module is used for deploying the secondarily developed program to the server in a dynamic link library manner for the main control program of the server to call. In the embodiment, except for the standard configuration program, the server provides an API (application programming interface) for the developer to use, and the secondary development program is deployed on the server in a dynamic link library form and is called by the main control program.
In an embodiment of the invention, a system for unified development of bank transaction reports includes: preprocessing a property SQL statement and a query property SQL statement;
the SQL statement execution module may be specifically configured to: and acquiring report data from a database according to the query property SQL statement, and preprocessing the acquired report data before report generation according to the preprocessing property SQL statement. SQL sentences written by developers can be automatically executed under the calling of a server-side main control program, and a server-side system supports preprocessing property SQL sentences and inquiring property SQL sentences. The preprocessing property SQL statement is used for preprocessing data before report generation, and the query property SQL statement is used for searching and querying formal report data.
In one embodiment, in consideration of the diversity and variability of the report forms, in order to reduce the influence on the core code, the service-end system allows a developer to write a report form template (TXT format) by himself, and a main control program of the service-end system can flexibly make a bank transaction report form according to the style of the report form template. When the report template format is adjusted due to the change of the service requirement and the report sample, the developer can meet the requirement by modifying the corresponding report template.
In an embodiment of the invention, a system for uniformly developing a bank transaction report specifically implements a server main control program, which may be specifically used to:
calling an SQL statement execution module to acquire report data from a database, calling a report statistical data determination module to perform statistical analysis on the report data according to report generation parameters, determining report statistical data, calling a report template module, and configuring a report template and report generation parameters;
and inputting the report statistical data into a report template, and determining a bank transaction report by combining the report generation parameters.
The server side main control program is responsible for bottom layer logic processing, and the server side main control program generates a bank transaction report file according to development and configuration of a user. Compared with a client, the server-side system is relatively stable and has small change condition, which is very important for the safe and reliable operation of the whole platform.
As shown in fig. 2, an embodiment of the present invention is a schematic diagram of a client for uniformly developing a bank transaction report, and an embodiment of the present invention further provides a client for uniformly developing a bank transaction report, which is used for interacting with the system for uniformly developing a bank transaction report, and includes: a report configuration unit 201, a report data preview unit 202, and a remote report generation unit 203;
a report configuration unit 201, configured to configure an SQL statement, a report generation parameter, and a report template according to the service requirement and the report sample;
a report data preview unit 202, configured to visually preview correctness of report data;
and the remote report generating unit 203 is used for remotely calling a server main control program deployed in the system for uniformly developing bank transaction reports and serving the end to generate the bank transaction reports.
In specific implementation, the report configuration unit is configured to configure an SQL statement, a report generation parameter, and a report template according to a business requirement and a report sample, as shown in fig. 3, which is a schematic diagram of a configured SQL statement configured by a uniform development client for a bank transaction report according to an embodiment of the present invention, and the embodiment of the present invention can configure and edit the SQL statement at the client; as shown in fig. 4, a report generation parameter diagram configured by a bank transaction report unified development client according to an embodiment of the present invention is shown, the embodiment of the present invention may configure and edit the report generation parameter at the client, for example, the report generation parameter diagram at least includes: report coding, SQL serial number, variable name, variable type, key value variable name, key value variable value, accumulated variable name, quotation mark, currency code variable name, variable description and the like; as shown in fig. 5, which is a schematic diagram of a report template configured by a client for unified development of a bank transaction report according to an embodiment of the present invention, the embodiment of the present invention can configure and edit the report template at the client. In the embodiment, according to the service requirement and the report form sample, a developer can configure the SQL statement and the important report form generation parameter for generating the report form in a designer of the report form configuration unit of the client, and configure the report form template through a text editor of the report form configuration unit of the client, so that the development of the final report form at the client is completed. The developer does not need to care how various configured parameters and templates are transmitted and printed on the final bank transaction report, and the system for uniformly developing the bank transaction report and the service end system can complete the work, so that the workload of the developer is greatly reduced.
In a specific implementation, the report data preview unit 202 is used for visually previewing the correctness of the report data, in an embodiment, through a visual designer of the report data preview unit, a developer can click to preview and directly check whether the data of the bank transaction report is correct or not, and a main control program of a server system does not need to be really called to debug and process the data, which is very convenient for the developer, and can ensure that the data accuracy test can be quickly and conveniently performed in a development process.
In a specific implementation, the remote report generation unit 203 is configured to remotely invoke a server-side main control program deployed on a system for unified development of a bank transaction report on a server to generate the bank transaction report, and in an embodiment, a developer may remotely invoke a server-side main control program deployed on a server through a "report running" function provided by a remote report generation unit designer, so that a generation program of the bank transaction report is really run, and a trouble of switching between a Win platform and an AIX platform is avoided.
When the embodiment of the present invention is embodied in a unified development client for bank transaction reports, the unified development client may further include: and the multi-language translation unit is used for configuring the multi-language fields in the bank transaction report and additionally generating a multi-language bank transaction report according to the set language. In the embodiment, aiming at the characteristics of overseas reports (having two sets of bank transaction reports of Chinese and English), the multilingual translation unit is provided for the multilingual bank transaction reports. Developers do not need to write a set of programs for each multilingual bank transaction statement, and the developers only need to configure the multilingual fields in the statement. For example: the 'transaction state' field in the report is embodied as codes '0, 1 and 2', and a developer only needs to configure the Chinese meaning 'success, failure and Unknown transaction' and the English meaning 'Successful, Failed and Unknown' for the developer in the translation table.
When the embodiment of the present invention is embodied in a unified development client for bank transaction reports, the unified development client may further include: and the secondary development unit is used for calling and processing required data according to a report processing mechanism and a data structure interface provided by the API, packaging a program developed by secondary coding into a dynamic link library and deploying the dynamic link library on the bank transaction report unified development server system for calling the server main control program. In the embodiment, when some reports cannot be obtained simply through SQL statements, the server-side system provides an API interface for developers to use, the developers need to simply know the mechanism for processing the reports, and follow the data structure interface provided by the API to perform calling and required data processing, and then package the written programs into dynamic link libraries to be deployed on the server for the main control program to call. In practical application, the condition that a developer carries out secondary coding development is rare, after all, codes which can be directly seen through an interface are the most relieved, but when a burst state or a special bank transaction report cannot be developed through SQL statement configuration, the secondary development unit can just make up the problem, and the complete development of the bank transaction report in various types and the burst state is realized.
When the embodiment of the present invention is embodied in a unified development client for bank transaction reports, the unified development client may further include: and the authority management unit is used for setting authorities of the plurality of accounts according to the user types and performing authority division management.
The client is deployed on a common PC for report developers to use. And the developer configures the important parameters for generating the report through a visual interface. The simple configuration and explicit goals guarantee the final quality of the code. Generally, a developer only needs to have certain SQL statement writing capability to complete the development and design of the report.
By implementing the client and the server system for the unified development of the bank transaction report, which are provided by the embodiment of the invention, the CCreport platform system in a C/S design mode is adopted, and the server system is completely separated from the client. Developers can perform pure configuration programming at the client, and only need to concentrate on data accuracy, so that the traditional development mode of 'drawing' reports from beginning to end by using bottom layer codes is abandoned.
As shown in fig. 6, which is an illustration diagram of a representation of a bank transaction report generated by a system for uniformly developing a bank transaction report according to an embodiment of the present invention, a client and a system for uniformly developing a bank transaction report according to an embodiment of the present invention are developed based on a database, and support connection with a remote server; a developer uses a program written by a client to directly write into a server-side system and a database, and can run without compiling, so that some accidents in the process from design to deployment of the program are avoided. The generation of the bank transaction report form of the embodiment of the invention is independent of a platform and has a cross-platform function; the database may use any type of database; when the report demand is increased, the development of a bank transaction report can be completed only by configuring necessary SQL statements, report generation parameters and a report template, and the functions of simplicity, quickness and configurability are realized.
The embodiment of the invention also provides a unified development method of the bank transaction report, which is described in the following embodiment. The principle of solving the problems of the method is similar to that of a client and a server system for uniformly developing the bank transaction report, so the implementation of the method can be referred to that of the client and the server system for uniformly developing the bank transaction report, and repeated parts are not repeated.
As shown in fig. 7, a schematic diagram of a unified development method for bank transaction reports according to an embodiment of the present invention is shown, and an embodiment of the present invention further provides a unified development method for bank transaction reports, including:
step 701: configuring SQL sentences, report generation parameters and report templates according to business requirements and report samples;
step 702: acquiring report data from a database according to the SQL statement;
step 703: carrying out statistical analysis on the report data to determine report statistical data;
step 704: and generating a bank transaction report according to the report statistical data, the report generation parameters and the report template.
In a specific implementation of the method for uniformly developing a bank transaction report according to an embodiment of the present invention, the generating a bank transaction report according to the report statistic data, the report generating parameter, and the report template may include:
and inputting the report statistical data into a report template, and determining a bank transaction report by combining the report generation parameters.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can be operated on the processor, wherein the processor realizes the unified development method of the bank transaction report when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program for implementing the unified development method of the bank transaction report.
To sum up, the method for uniformly developing a bank transaction report, the client and the server-side system provided by the embodiment of the invention acquire report data from a database by configuring SQL statements, then perform statistical analysis on the report data to determine the report statistical data, and combine the report statistical data with a report template and a report generation parameter to quickly generate a bank transaction report. A report template is formed in the process of communicating with business personnel, and the business personnel can see the report style in the demand stage, so that the business change cost is reduced; the technical personnel can complete the development of a bank transaction report by only configuring necessary SQL sentences, report generation parameters and report templates according to the requirements. The embodiment of the invention realizes the effects of multi-platform support, configurable compiling-free, report data preview support, simple and convenient development process, support of various report templates and the like.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (13)
1. A system for uniformly developing bank transaction reports is characterized by comprising:
the system comprises an SQL statement execution module, a report statistical data determination module, a report template and report generation parameter configuration module and a server main control program;
the SQL sentence execution module is used for acquiring report data from a database according to the SQL sentences;
the report statistical data determining module is used for performing statistical analysis on the report data and determining report statistical data;
the report template and report generation parameter configuration module is used for configuring the report template and report generation parameters;
and the server side main control program is used for calling the SQL statement execution module, the report statistical data determination module and the report template module to generate a bank transaction report.
2. The system of unified development of bank transaction statements service end according to claim 1, further comprising: and the monitoring module is used for monitoring the generation process of the bank transaction report and generating a monitoring log.
3. The system of unified development of bank transaction statements service end according to claim 1, further comprising: and the API module is used for deploying the secondarily developed program to the server in a dynamic link library manner for the main control program of the server to call.
4. The system of unified development services for bank transaction statements according to claim 1, wherein SQL statements comprise: preprocessing a property SQL statement and a query property SQL statement;
the SQL statement execution module is specifically configured to: and acquiring report data from a database according to the query property SQL statement, and preprocessing the acquired report data before report generation according to the preprocessing property SQL statement.
5. The system of claim 1, wherein the server-side main control program is specifically configured to:
calling an SQL statement execution module to acquire report data from a database, calling a report statistical data determination module to perform statistical analysis on the report data according to report generation parameters, determining report statistical data, calling a report template module, and configuring a report template and report generation parameters;
and inputting the report statistical data into a report template, and determining a bank transaction report by combining the report generation parameters.
6. A client for uniformly developing bank transaction reports, which is used for interacting with the system for uniformly developing bank transaction reports according to claim 1, and comprises: the report configuration unit, the report data preview unit and the remote report generation unit;
the report configuration unit is used for configuring the SQL statement, the report generation parameter and the report template according to the service requirement and the report sample;
the report data previewing unit is used for visually previewing the correctness of the report data;
and the remote report generation unit is used for remotely calling a server main control program deployed on the bank transaction report unified development server system to generate a bank transaction report.
7. The unified banking transaction statement development client according to claim 6, further comprising: and the multi-language translation unit is used for configuring the multi-language fields in the bank transaction report and additionally generating a multi-language bank transaction report according to the set language.
8. The unified banking transaction statement development client according to claim 6, further comprising: and the secondary development unit is used for calling and processing required data according to a report processing mechanism and a data structure interface provided by the API, packaging a program developed by secondary coding into a dynamic link library and deploying the dynamic link library on the bank transaction report unified development server system for calling the server main control program.
9. The unified banking transaction statement development client according to claim 6, further comprising: and the authority management unit is used for setting authorities of the plurality of accounts according to the user types and performing authority division management.
10. A unified development method for bank transaction reports is characterized by comprising the following steps:
configuring SQL sentences, report generation parameters and report templates according to business requirements and report samples;
acquiring report data from a database according to the SQL statement;
carrying out statistical analysis on the report data to determine report statistical data;
and generating a bank transaction report according to the report statistical data, the report generation parameters and the report template.
11. The unified method for developing bank transaction reports as claimed in claim 10, wherein the generating bank transaction reports according to the report statistic data, the report generating parameters and the report template comprises:
and inputting the report statistical data into a report template, and determining a bank transaction report by combining the report generation parameters.
12. A computer device comprising a memory, a processor and a computer program stored on the memory and operable on the processor, the processor implementing the method for unified development of bank transaction statements according to claim 10 or 11 when executing the computer program.
13. A computer-readable storage medium storing a computer program for executing the method for uniformly developing a bank transaction report according to claim 10 or 11.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010149969.0A CN111367940A (en) | 2020-03-06 | 2020-03-06 | Unified development method of bank transaction report, client and server system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010149969.0A CN111367940A (en) | 2020-03-06 | 2020-03-06 | Unified development method of bank transaction report, client and server system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111367940A true CN111367940A (en) | 2020-07-03 |
Family
ID=71208654
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010149969.0A Pending CN111367940A (en) | 2020-03-06 | 2020-03-06 | Unified development method of bank transaction report, client and server system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111367940A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6233583B1 (en) * | 1998-09-10 | 2001-05-15 | International Business Machines Corporation | Report generator for use within a lotus notes database system |
| US6668253B1 (en) * | 1999-09-08 | 2003-12-23 | Reynolds & Reynolds Holdings, Inc. | Enterprise information management system and methods |
| CN101877098A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Bank credit and debit service report system and entry generating method thereof |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN106874247A (en) * | 2017-01-03 | 2017-06-20 | 北京神州绿盟信息安全科技股份有限公司 | A kind of report form generation method and device |
| CN108984496A (en) * | 2017-06-02 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating report |
| CN110019136A (en) * | 2017-12-28 | 2019-07-16 | 中国移动通信集团内蒙古有限公司 | Report generating system and report form generation method |
-
2020
- 2020-03-06 CN CN202010149969.0A patent/CN111367940A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6233583B1 (en) * | 1998-09-10 | 2001-05-15 | International Business Machines Corporation | Report generator for use within a lotus notes database system |
| US6668253B1 (en) * | 1999-09-08 | 2003-12-23 | Reynolds & Reynolds Holdings, Inc. | Enterprise information management system and methods |
| CN101877098A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Bank credit and debit service report system and entry generating method thereof |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN106874247A (en) * | 2017-01-03 | 2017-06-20 | 北京神州绿盟信息安全科技股份有限公司 | A kind of report form generation method and device |
| CN108984496A (en) * | 2017-06-02 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating report |
| CN110019136A (en) * | 2017-12-28 | 2019-07-16 | 中国移动通信集团内蒙古有限公司 | Report generating system and report form generation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102804147B (en) | Perform the code check executive system of the code check of ABAP source code | |
| EP2499565B1 (en) | Managing record format information | |
| US9218269B2 (en) | Testing multiple target platforms | |
| EP1027648B1 (en) | Apparatus for semi-automated generation and application of language conformity tests | |
| US20070266378A1 (en) | Source code generation method, apparatus, and program | |
| CN101996131A (en) | Automatic test method and automatic test platform for graphic user interface (GUI) based on x extensive makeup language (XML) packaging key word | |
| CN103577168A (en) | Test case creation system and method | |
| CN106919612B (en) | Processing method and device for online structured query language script | |
| US20150261507A1 (en) | Validating sql queries in a report | |
| CN106469140A (en) | A kind of report generating system and its method | |
| CN115599359A (en) | Code generation method, device, equipment and medium | |
| CN111367893A (en) | Method and device for database version iteration | |
| US11314489B1 (en) | Automated authoring of software solutions by first analyzing and resolving anomalies in a data model | |
| CN117370217A (en) | Automatic interface test result generation method based on python | |
| US20110023010A1 (en) | Reserved component container-based software development method and apparatus | |
| CN110659200B (en) | Method and system for comparing and analyzing source code and target code of aviation onboard software | |
| CN111367940A (en) | Unified development method of bank transaction report, client and server system | |
| CN113051262B (en) | Data quality inspection method, device, equipment and storage medium | |
| CN115904480A (en) | Code reconstruction method and device, electronic equipment and storage medium | |
| CN106033338A (en) | Method and device for importing and analyzing source code based on FOG data | |
| KR100656559B1 (en) | Program Automatic Generating Tools | |
| CN115373655B (en) | Information protocol code automatic generation method based on standardized template | |
| CN117331963B (en) | Data access processing method and device, electronic equipment and storage medium | |
| CN117667089A (en) | Front-end form generation method and device, storage medium and electronic equipment | |
| CN117032661A (en) | Real-time computing visualization development realization method and device and computer equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |