CN108932293B - Customized electronic receipt generation method based on visual configuration - Google Patents
Customized electronic receipt generation method based on visual configuration Download PDFInfo
- Publication number
- CN108932293B CN108932293B CN201810546077.7A CN201810546077A CN108932293B CN 108932293 B CN108932293 B CN 108932293B CN 201810546077 A CN201810546077 A CN 201810546077A CN 108932293 B CN108932293 B CN 108932293B
- Authority
- CN
- China
- Prior art keywords
- configuration
- electronic receipt
- column
- service
- selecting
- 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
- 238000000034 method Methods 0.000 title claims abstract description 21
- 230000000007 visual effect Effects 0.000 title claims abstract description 21
- 238000012216 screening Methods 0.000 claims abstract description 17
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 230000002045 lasting effect Effects 0.000 claims description 4
- 238000012795 verification Methods 0.000 claims description 3
- 238000013500 data storage Methods 0.000 claims description 2
- 230000002085 persistent effect Effects 0.000 description 5
- 238000013075 data extraction Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 238000000844 transformation Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a customized electronic receipt generation method based on visual configuration, which comprises the following steps: entering a preset original database, and confirming the configuration of the required business form; selecting a table and a corresponding column of the corresponding business form to form an intermediate form, setting required and associated attributes and screening conditions of the intermediate form, generating a new business form and a corresponding SQL statement for the configuration in S2, and persistently storing to form a user-defined form; selecting a business form needing to generate an electronic receipt; configuring required attributes for the selected service form; and generating an electronic receipt and storing the SQL definition of the electronic receipt. The method can dynamically adjust the electronic receipt, realizes the user-defined, one-time coding and dynamic random calling without modifying the program, greatly saves the labor and improves the function and the value of the product.
Description
Technical Field
The invention belongs to the technical field of dynamic data extraction, and particularly relates to a custom electronic receipt generation method based on visual configuration.
Background
With the popularization of electronic systems, electronic receipt is a common form for people to call and check data, and is applied to enterprises and public institutions. However, the conventional electronic receipt is usually fixed in format and cannot be increased or decreased. For example, the method for generating the bank electronic receipt generally comprises the steps of firstly confirming the receipt to be generated according to the requirement, then carrying out single-table or multi-table combined query on the original table through an SQL statement, thereby carrying out data cleaning, screening, rearranging and collecting to obtain the expected data format, carrying out persistent storage, and finally generating the electronic receipt. However, in this data extraction method, SQL statements are written in a program, and when the original data structure is changed, the SQL statements need to be modified; when new original data is required to be added for extraction, the program is usually required to be redeveloped to meet the extraction requirement. For the situation, if the original data of the client changes frequently and the extracted content needs to be adjusted at any time, the client needs to modify, submit, test, decide and release the program continuously, which is time-consuming, labor-consuming, time-consuming and time-consuming, and also has unsafe hidden trouble.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides a customized electronic receipt generation method based on visual configuration.
The purpose of the invention is realized by the following technical scheme:
a self-defined electronic receipt generating method based on visual configuration firstly generates a business form according to an original database and then generates a self-defined electronic receipt through the business form, and specifically comprises the following steps:
s1, entering a preset original database, and confirming the required configuration of the business form;
s2, selecting a table and a corresponding column of the corresponding business form to form an intermediate form, and setting required and associated attributes and screening conditions of the intermediate form;
s3, generating a new business form and a corresponding SQL statement for the configuration in S2, and persistently storing to form a user-defined form;
s4, selecting a business form needing to generate an electronic receipt in S3;
s5, configuring required attributes for the selected business form;
and S6, generating the electronic receipt, and storing the SQL definition of the electronic receipt.
Preferably, the service form configuration in S1 is a single-table configuration or a multi-table configuration.
Preferably, when the service form is configured as a single form in S1, configuring an original form in the original database; when the service form is configured in multiple tables in S1, performing association configuration for multiple tables in the original database.
Preferably, it is characterized in that: the presentation items in the original database include, but are not limited to, table name, service attribute, table description, column name, type, length, column description.
Preferably, the required attributes in S5 include, but are not limited to, column name, number of return row, and display order in return row.
The invention has the beneficial effects that: the electronic receipt can be dynamically adjusted, customer self-definition, one-time coding and dynamic random calling are achieved, and the electronic receipt is not required to be modified, so that manpower is greatly saved, the functions and the value of products are improved, the operation and maintenance cost of the products is extremely low, a large amount of service communication time is saved, and the working efficiency is improved.
Drawings
FIG. 1: the invention generates a visual page configuration flow chart of the user-defined business form.
FIG. 2: the invention generates a visual page configuration flow chart of the user-defined electronic receipt.
FIG. 3: the invocation of the present invention generates a flow chart of an electronic receipt.
Detailed Description
The technical scheme of the invention is specifically described in the following by combining with an embodiment, and the invention discloses a custom electronic receipt generation method based on visual configuration. The method comprises a visual page configuration device, an automatic data batch execution device and a receipt display device, wherein firstly, forms and receipts are configured through the visual page configuration device, and then automatic batch execution is performed on the basis of the receipt display device.
The automatic batch execution of the data is shown in fig. 3, and includes the following steps:
s1, scheduling the task, and executing the task regularly through the task plan of the database;
s2, judging the execution date, skipping if the data of the current day is generated, and ending; if not, go to S3;
s3, traversing the business form SQL, putting temporary variables, executing the SQL statement, generating business form data, and storing the business form data in a persistent mode;
s4, traversing the electronic receipt SQL, putting temporary variables, executing the SQL statement, generating S5, forming electronic receipt data, and storing in a persistent mode;
and S5, modifying the execution ending time and the next execution time, and performing persistent storage.
The generation configuration of the service form in S3 is shown in fig. 1, and the specific implementation steps are as follows:
s101, logging in a visual configuration system, inputting a user name, a password and a picture verification code to log in the system, wherein the system is consistent with other existing systems, and an account needs to be registered when the system is used for the first time.
S102, selecting a form to generate a business form; configuring a system service function, and realizing the configuration of a service form through the function;
s103, when the single-table configuration is selected, the step is started; the single-table configuration is only configured for one original table;
s104, selecting an original table needing to generate a business form, wherein the display items comprise but are not limited to table names, business attributes, table descriptions, column names, types, lengths and column descriptions.
S105, setting a business table name, screening conditions and the like; setting new table names, table descriptions, service numbers, columns needing data conversion and screening conditions of the columns needing screening for the service form, completing configuration and storing;
s106, generating a new business form and a corresponding SQL statement according to the configuration, and storing the new business form and the corresponding SQL statement in a lasting way;
s107, entering the step when multi-table configuration is selected; the multi-table configuration realizes the associated configuration of a plurality of tables; selecting a display column needing to generate a receipt, selecting and storing the display column, wherein the column name and the table name are used as key elements of an SQL statement, and are persisted to a data storage device in an attribute tag form for the step S103, and associated columns of a plurality of tables can be selected as screening conditions;
s108, selecting a plurality of tables and corresponding columns, wherein the display items comprise but are not limited to table names, service attributes, table descriptions, column names, types, lengths and column descriptions;
s109, selecting the columns needing to be associated and configuring screening column conditions, setting new table names, table descriptions, service numbers, columns needing data conversion and screening conditions of the columns needing to be screened for the service form, completing configuration and storing;
s110, generating a new business form and a corresponding SQL statement according to the configuration, and storing the new business form and the corresponding SQL statement in a lasting way; and finally, completing the structural definition of the business form and storing the business form by SQL statements.
The generation configuration of the electronic receipt in S3 is shown in fig. 2, and the specific implementation steps are as follows:
s201, logging in a visual configuration system, inputting a user name, a password and a picture verification code to log in the system, and using the system for the first time to register an account;
s202, selecting and configuring the electronic receipt, and generating the electronic receipt according to the business form by the function;
s203, selecting a business form, and selecting the business form needing to generate an electronic receipt;
s204, configuring an attribute column, defining a column name, defining a return row number, a return row in-row display sequence and the like;
and S205, storing the SQL definition of the electronic receipt.
The following description is made in detail by taking an electronic receipt of a bank as an example: taking the customer small amount common credit account receipt as an example, assume that the original table in the core system is table a, table a is a small amount common credit account receipt transaction detail record, the account basic information table is table B, the small amount common goods account receipt business form is table C, and the small amount common credit account receipt electronic receipt record table is table D.
Wherein, tables A and B are original tables, and it is assumed that tables A have 10 columns of 2,3,4,5,6,7,8,9 and 10, and tables B have 3 columns of 1,2 and 3.
S1, selecting a table A and a table B through a visual configuration page, and selecting columns 1-9 of the table A and 3 of the table B;
s2, configuring a small amount of common credit account on the page, defining the table name as a table C, and screening under the condition that the 1 st column of the table A is equal to the 2 nd column of the table B, and the 8 th column of the table A has a value larger than '2017-01-01';
s3, storing the configuration items, and generating an SQL statement: insert into C (1,2,3,4,5,6,7,8,9,10) select A.11, A.22, A.33, A.44, A.55, A.66, A.77, A.88, A.99, B.310 where A.1= B.2 and A.8> '2017-01-01'. The dynamically generated SQL statement defines the data rule for the small amount common credit account of the client.
S4, considering the actual format of the bank electronic receipt as:
(ii) receipt of
Name: account number: **********
Transaction amount: time of transaction: *******
The form generated in S3 needs to be secondarily processed in a visualization configuration manner, that is, secondarily visually configured.
S5, selecting the first, third, fifth, sixth and seventh columns in the table C as the components of the receipt.
And S6, configuring the five selected columns in S5. The configuration information includes: chinese display names and columns corresponding to the columns are displayed in the rows and columns.
S7, storing the information, and storing the column and table information related to the electronic receipt in the database in the form of SQL attributes.
The above steps define the data generation rules.
The following explains that the storage process is regularly executed by scheduling tasks through the storage process, and the storage process is realized by the following steps:
and S8, selecting the time needing to execute the scheduling from the database, and continuing to execute the scheduling when the requirement is met.
And S9, traversing all the form types generated by the S3, executing the SQL sentences which are stored in a persistent mode, and storing the generated data serving as intermediate data in an intermediate table.
And S10, traversing the receipt generation rule generated in S7, executing the persisted SQL statement, taking data from the intermediate table, and storing the data in the receipt table. The receipt data is in the form of receipt row units, each row is used as a column in the database table d, and a receipt is stored in a piece of data.
Through the steps, the transaction data of the data warehouse after being checked can be regularly acquired every day, the electronic receipt in any format is generated and stored as historical data for the electronic receipt of the client.
There are, of course, many other specific embodiments of the invention and these are not to be considered as limiting. All technical solutions formed by using equivalent substitutions or equivalent transformations fall within the scope of the claimed invention.
Claims (5)
1. A customized electronic receipt generation method based on visual configuration is characterized in that: the method comprises the following steps:
s1, entering a preset original database, and confirming the required configuration of the business form;
s2, selecting a table and a corresponding column of the corresponding business form to form an intermediate form, and setting required and associated attributes and screening conditions of the intermediate form;
s3, generating a new business form and a corresponding SQL statement for the configuration in S2, and persistently storing to form a user-defined form;
s4, selecting a business form needing to generate an electronic receipt in S3;
s5, configuring required attributes for the selected business form;
s6, generating an electronic receipt, and storing the SQL definition of the electronic receipt;
the generation of the service form in S3 includes the following steps:
s101, logging in a visual configuration system, inputting a user name, a password and a picture verification code to log in the system, wherein the visual configuration system is consistent with other existing systems and needs to register an account number when being used for the first time;
s102, selecting a form to generate a business form; configuring a system service function, and realizing the configuration of a service form through the function;
s103, when the single-table configuration is selected, the step is started; the single-table configuration is only configured for one original table;
s104, selecting an original table needing to generate a business form, wherein the display items comprise but are not limited to table names, business attributes, table descriptions, column names, types, lengths and column descriptions;
s105, setting a business table name, screening conditions and the like; setting new table names, table descriptions, service numbers, columns needing data conversion and screening conditions of the columns needing screening for the service form, completing configuration and storing;
s106, generating a new business form and a corresponding SQL statement according to the configuration, and storing the new business form and the corresponding SQL statement in a lasting way;
s107, entering the step when multi-table configuration is selected; the multi-table configuration realizes the associated configuration of a plurality of tables; selecting a display column needing to generate a receipt, selecting and storing the display column, wherein the column name and the table name are used as key elements of an SQL statement, and are persisted to a data storage device in an attribute tag form for the step S103, and associated columns of a plurality of tables can be selected as screening conditions;
s108, selecting a plurality of tables and corresponding columns, wherein the display items comprise but are not limited to table names, service attributes, table descriptions, column names, types, lengths and column descriptions;
s109, selecting the columns needing to be associated and configuring screening column conditions, setting new table names, table descriptions, service numbers, columns needing data conversion and screening conditions of the columns needing to be screened for the service form, completing configuration and storing;
s110, generating a new business form and a corresponding SQL statement according to the configuration, and storing the new business form and the corresponding SQL statement in a lasting way; and finally, completing the structural definition of the business form and storing the business form by SQL statements.
2. The method for generating customized electronic receipt based on visual configuration according to claim 1, wherein: the service form configuration in S1 is a single table configuration or a multi-table configuration.
3. The method for generating customized electronic receipt based on visual configuration according to claim 2, wherein: when the service form in the S1 is configured as a single form, configuring an original form in the original database; when the service form is configured in multiple tables in S1, performing association configuration for multiple tables in the original database.
4. The method for generating customized electronic receipt based on visual configuration according to claim 1, wherein: the method is characterized in that: the presentation items in the original database include, but are not limited to, table name, service attribute, table description, column name, type, length, column description.
5. The method for generating customized electronic receipt based on visual configuration according to claim 1, wherein: the required attributes in S5 include, but are not limited to, column name, number of return row, and display order within return row.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810546077.7A CN108932293B (en) | 2018-05-31 | 2018-05-31 | Customized electronic receipt generation method based on visual configuration |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810546077.7A CN108932293B (en) | 2018-05-31 | 2018-05-31 | Customized electronic receipt generation method based on visual configuration |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108932293A CN108932293A (en) | 2018-12-04 |
CN108932293B true CN108932293B (en) | 2022-03-22 |
Family
ID=64449463
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810546077.7A Active CN108932293B (en) | 2018-05-31 | 2018-05-31 | Customized electronic receipt generation method based on visual configuration |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108932293B (en) |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103995813A (en) * | 2013-02-20 | 2014-08-20 | 中国银联股份有限公司 | Method and system for generating electronic bill template |
US9430918B2 (en) * | 2014-09-23 | 2016-08-30 | Moneygram International, Inc. | Receipt generation service |
CN104537069B (en) * | 2014-12-26 | 2017-12-26 | 远光软件股份有限公司 | A kind of document configuration and application system and its method |
CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
-
2018
- 2018-05-31 CN CN201810546077.7A patent/CN108932293B/en active Active
Also Published As
Publication number | Publication date |
---|---|
CN108932293A (en) | 2018-12-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20100100562A1 (en) | Fully Parameterized Structured Query Language | |
CA2685296A1 (en) | System and method for categorizing credit card transaction data | |
US8626790B2 (en) | System and method for processing and analyzing dimension data | |
CN110532309B (en) | Generation method of college library user portrait system | |
CN110019754A (en) | A kind of method for building up of knowledge base, device and equipment | |
US10282353B2 (en) | Proactive duplicate identification | |
CN110633331B (en) | Method, system and related equipment for extracting data in relational database | |
CN112883042A (en) | Data updating and displaying method and device, electronic equipment and storage medium | |
CN101710320A (en) | Statistical index data processing method and device | |
CN112486997A (en) | Data processing method, device, equipment and storage medium | |
CN106844320B (en) | Financial statement integration method and equipment | |
CN101706829A (en) | Data storage method and device | |
CN108932293B (en) | Customized electronic receipt generation method based on visual configuration | |
CN114090634A (en) | Hotel data management method and device based on data warehouse | |
CN100538706C (en) | A kind of method and apparatus that shows electrical form | |
CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
JP5771476B2 (en) | Data management system and data management method | |
CN105589900A (en) | Data mining method based on multi-dimensional analysis | |
CN109600428B (en) | Method and device for automatically uploading attachment and matching association | |
CN107678856B (en) | Method and device for processing incremental information in business entity | |
US8856126B2 (en) | Simplifying grouping of data items stored in a database | |
CN109388647B (en) | WEB-based data filling method and system | |
US20130238748A1 (en) | Electronic distribution method, electronic distribution device and electronic distribution program | |
KR20200119108A (en) | Method for constructing database in WYSIWYG based website builder | |
CN105630997A (en) | Data parallel processing method, device and 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 | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210819 Address after: 215000 building 3, Fumin phase III plant, No. 818, Songjia Road, Guoxiang street, Wuzhong Economic Development Zone, Suzhou City, Jiangsu Province Applicant after: INSPUR FINANCIAL INFORMATION TECHNOLOGY Co.,Ltd. Address before: 215000 Building 1, 178 Tayun Road, Yuexi street, Wuzhong District, Suzhou City, Jiangsu Province Applicant before: SUZHOU INSPUR INTELLIGENT SOFTWARE Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |