CN108932293A - A kind of customized electronic receipt generation method based on visual configuration - Google Patents
A kind of customized electronic receipt generation method based on visual configuration Download PDFInfo
- Publication number
- CN108932293A CN108932293A CN201810546077.7A CN201810546077A CN108932293A CN 108932293 A CN108932293 A CN 108932293A CN 201810546077 A CN201810546077 A CN 201810546077A CN 108932293 A CN108932293 A CN 108932293A
- Authority
- CN
- China
- Prior art keywords
- configuration
- electronic receipt
- business form
- generation method
- method based
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The customized electronic receipt generation method based on visual configuration that the present invention provides a kind of, includes the following steps：Into preset raw data base, and confirm required business form configuration；The selection of table and respective column is carried out to corresponding business form, form intermediate list, required and associated attribute, the screening conditions of middle table are set simultaneously, new business form and corresponding SQL statement, persistence are generated to the configuration in S2 and save to form customizing form；Selection needs to generate the business form of electronic receipt；Attribute needed for being configured to selected business form；Electronic receipt is generated, and saves the SQL definition of electronic receipt.Method of the invention can carry out dynamic adjustment to electronic receipt, and it is customized to realize client, first encoding, and dynamic random calls, and without being realized by modification program, greatly save manpower, improve the function and value of product.
Description
Technical field
The invention belongs to data dynamic extraction technique fields, and in particular to a kind of customized electronics based on visual configuration
Receipt generation method.
Background technique
With popularizing for electronic system, it is the common type that called data is checked, enterprise that electronic receipt, which becomes people,
It can all be applied in public institution.But existing electronic receipt normal format is fixed, and cannot be increased and decreased.For example, bank is electric
The method that sub- receipt generates is typically all that first confirmation needs the receipt generated according to demand, then by SQL statement to original table
Single table or multilist conjunctive query are carried out, to carry out data cleansing, screening, rearranges, set, obtains desired data lattice
Formula, and persistence preservation is carried out, ultimately produce electronic receipt.But the mode of this data pick-up needs to write SQL in program
Sentence then needs to modify SQL statement when initial data structure changes；When needing newly-increased initial data to be extracted, usually
It needs to develop program again, to meet the needs extracted.In response to this, if in client's initial data often changes, extracts
Appearance is when needing to adjust at any time, it is necessary to constantly modify program, submission, test, determine version, publication, time and effort consuming, waste of manpower with
Time cost, while can also have unsafe hidden danger.
Summary of the invention
In order to solve the deficiencies in the prior art, the present invention provides a kind of customized electronic receipt based on visual configuration
Generation method.
The purpose of the present invention is achieved through the following technical solutions：
A kind of customized electronic receipt generation method based on visual configuration first generates business form according to raw data base,
Customized electronic receipt is generated by business form again, is specifically comprised the following steps：
S1, into preset raw data base, and the business form configuration needed for confirming；
S2, the selection that table and respective column are carried out to corresponding business form, form intermediate list, while the required of middle table is arranged
And associated attribute, screening conditions；
S3, the business form and corresponding SQL statement, persistence new to the configuration generation in S2 save to form customizing form；
S4, selection needs to generate the business form of electronic receipt in S3；
S5, required attribute is configured to selected business form；
S6, electronic receipt is generated, and saves the SQL definition of electronic receipt.
Preferably, business form is configured to single table configuration or multilist configuration in the S1.
Preferably, when business form is single table configuration in S1, matched for an original table in raw data base
It sets；When business form is that multilist configures in S1, configuration is associated for multiple tables in raw data base.
Preferably, it is characterised in that：Show that item includes but is not limited to table name, service attribute, table in the raw data base
Illustrate, column name, type, length, column explanation.
Preferably, required attribute includes but is not limited to column name, receipt row number, display order in receipt row in the S5.
The beneficial effects of the present invention are embodied in：Dynamic adjustment can be carried out to electronic receipt, it is customized to realize client, once
Coding, dynamic random call, and without being realized by modification program, greatly save manpower, improve the function and valence of product
Value, while product O&M cost is minimum, saves a large amount of business time for communication, improves work efficiency.
Detailed description of the invention
Fig. 1：The present invention generates the visual page configuration flow figure of customized business form.
Fig. 2：The present invention generates the visual page configuration flow figure of customized electronic receipt.
Fig. 3：Calling of the invention generates the flow chart of electronic receipt.
Specific embodiment
It is specifically described technical solution of the present invention with reference to embodiments, present invention discloses one kind to be based on visual configuration
Customized electronic receipt generation method.This method includes a visual page configuration device, and data automatic batch executes
Device and receipt show device, carry out the configuration of list and receipt by visual page configuration device first, are then based on back
Single progress data automatic batch execution on the basis of showing device.
The data automatic batch executes as shown in connection with fig. 3, includes the following steps：
S1, scheduler task are periodically executed the task by the task scheduling of database；
S2, judge execution date, same day data have been generated, skipped, and are terminated；It does not generate and then enters S3；
S3, traversal business form SQL, are put into temporary variable, execute the SQL statement, generate business form data, and persistence is protected
It deposits；
S4, traversal electronic receipt SQL, are put into temporary variable, execute the SQL statement, give birth to S5, at electronic receipt data, persistence
It saves；
S5, this execution end time and Time Of Next execution are modified, persistence saves.
Wherein the generation of business form configures as shown in Figure 1, the specific implementation steps are as follows in S3：
S101, visual configuration system is logged in, inputs user name, password, picture validation code and log in this system, the system is for example existing
Other systems it is consistent, for the first time in use, needing register account number.
S102, selection list, generate business form；This step is configuration system business function, realizes industry by this function
The configuration of business list；
S103, when selecting single table configuration, into this step；Single table configuration is configured just for an original table；
S104, selection need to generate the original table of business form, show item include but is not limited to table name, service attribute, table explanation,
Column name, type, length, column explanation.
S105, setting traffic table table name, screening conditions etc.；New table name, table explanation, business is arranged to business form to compile
Number, the column that need data conversion, the screening conditions for needing to screen column, configuration completes, saves；
S106, new business form and corresponding SQL statement are generated according to above-mentioned configuration, persistence saves；
S107, when selection multilist configuration, into this step；Multilist configuration, which is realized, is associated configuration to multiple tables；Selection needs
The displaying column for generating receipt, save, above-mentioned column name, key element of the table name as SQL statement, in the form of attribute tags after choosing
Data storage device is persisted to for S103 step, can choose the associated column of multiple tables, as screening conditions；
S108, multiple tables and corresponding column are selected, shows that item includes but is not limited to table name, service attribute, table explanation, column name, class
Type, length, column explanation；
S109, selection need associated column and configuration screening column condition, and new table name, table explanation, business is arranged to business form
It numbers, need the column of data conversion, need to screen the screening conditions of column, configuration is completed, and is saved；
S110, new business form and corresponding SQL statement are generated according to above-mentioned configuration, persistence saves；Finally complete business
The structure of list is defined and is saved with SQL statement.
Wherein the generation of electronic receipt configures as shown in Fig. 2, the specific implementation steps are as follows in S3：
S201, visual configuration system is logged in, inputs user name, password, picture validation code and log in this system, is using this for the first time
System needs register account number；
S202, option and installment electronic receipt, this function, which is realized, generates electronic receipt according to business form；
S203, selection business form, selection need to generate the business form of electronic receipt；
S204, configuration attribute column, definition column name define receipt row number, display order etc. in receipt row；
S205, the SQL definition for saving electronic receipt.
For bank electronic receipt, illustrate：By taking the common credit of client's small amount carrys out account receipt as an example, it is assumed that
Original table in core system is Table A, and Table A is that the common credit of small amount carrys out account transaction details record, and account Basic Information Table is table
B, it is table C that small amount general cargo note, which carrys out account business form, and it is table D that the common credit of small amount, which carrys out account electronic receipt record sheet,.
Wherein, Table A and table B are original table, it is assumed that Table A has, 2,3,4,5,6,7,8,9,10 10 arrange totally, and table B has 1,2,3
Totally 3 column.
S1, pass through the 1-9 column of the visual configuration page, selection Table A and table B and Table A, 3 column of table B；
S2, carry out account in the common credit of page configuration small amount, definition table name is table C, and screening conditions are the 1st column of Table A with table B's
2nd column are equal, and the 8th train value of Table A is greater than ' 2017-01-01 '；
S3, above-mentioned configuration item is saved, generates SQL statement：insert into C(1,2,3,4,5,6,7,8,9,10) select
A.1 1,A.2 2,A.3 3,A.4 4,A.5 5,A.6 6,A.7 7,A.8 8,A.9 9,B.3 10 where A.1=B.2
and A.8>'2017-01-01'.The SQL statement of the dynamic generation is the data rule for defining the common credit of client's small amount and carrying out account
Then.
S4, it is in view of the actual format of bank electronic receipt：
* * * * * receipt
Name：* * * account：**********
Transaction amount：* * * * exchange hour：*******
It needs that S3 list generated is carried out secondary treatment by the way of visual configuration, that is, carries out secondary visualization and match
It sets.
S5, selection table C selects therein first, third, the five, the six, the 7th to arrange component part as receipt.
S6, five column that S5 chooses are configured.Configuration information includes：Arrange corresponding Chinese display name, column are shown in the
Several rows, which column.
S7, above- mentioned information are saved, column relevant to electronic receipt is generated and table information are stored in the form of SQL attribute
In database.
Above step defines data create-rule.
Set forth below by storing process scheduler task, timing executes storing process, and the content which realizes is：
S8, it needs this to need to be implemented the time of scheduling from database selection, is continued to execute when meeting the requirements.
All form types that S9, traversal S3 are generated, execute the SQL statement that persistence saves, during the data of generation are used as
Between data be stored in middle table.
S10, traversal S7 receipt create-rule generated, execute the SQL statement that persistence saves, fetch from middle table
According to being saved in receipt table.The receipt data are returned with the behavior unit of receipt, every a line as the column in database table d, one
It is singly stored in a data.
Through the above steps, it can be achieved that transaction data of the timing acquisition data warehouse after audit, generation daily is any
The electronic receipt of format, and save as historical data and used for client's electronic receipt.
Certainly still there are many specific embodiments by the present invention, are just not listed one by one herein.It is all using equivalent replacement or
Equivalent transformation and all technical solutions formed, all fall within the scope of protection of present invention.
Claims (5)
1. a kind of customized electronic receipt generation method based on visual configuration, it is characterised in that：Include the following steps：
S1, into preset raw data base, and the business form configuration needed for confirming；
S2, the selection that table and respective column are carried out to corresponding business form, form intermediate list, while the required of middle table is arranged
And associated attribute, screening conditions；
S3, the business form and corresponding SQL statement, persistence new to the configuration generation in S2 save to form customizing form；
S4, selection needs to generate the business form of electronic receipt in S3；
S5, required attribute is configured to selected business form；
S6, electronic receipt is generated, and saves the SQL definition of electronic receipt.
2. a kind of customized electronic receipt generation method based on visual configuration as described in claim 1, it is characterised in that：
Business form is configured to single table configuration or multilist configuration in the S1.
3. a kind of customized electronic receipt generation method based on visual configuration as claimed in claim 3, it is characterised in that：
When business form is single table configuration in S1, configured for an original table in raw data base；When traffic table in S1
When single configuration for multilist, configuration is associated for multiple tables in raw data base.
4. a kind of customized electronic receipt generation method based on visual configuration as described in claim 1, it is characterised in that：
It is characterized in that：In the raw data base show item include but is not limited to table name, service attribute, table explanation, column name, type,
Length, column explanation.
5. a kind of customized electronic receipt generation method based on visual configuration as described in claim 1, it is characterised in that：
Required attribute includes but is not limited to column name, receipt row number, display order in receipt row in the S5.
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 true CN108932293A (en) | 2018-12-04 |
| CN108932293B 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) |
Citations (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 |
| CN104537069A (en) * | 2014-12-26 | 2015-04-22 | 远光软件股份有限公司 | Receipt configuration and application system and method |
| US20160086454A1 (en) * | 2014-09-23 | 2016-03-24 | Moneygram International, Inc. | Receipt Generation Service |
| 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
Patent Citations (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 |
| US20160086454A1 (en) * | 2014-09-23 | 2016-03-24 | Moneygram International, Inc. | Receipt Generation Service |
| CN104537069A (en) * | 2014-12-26 | 2015-04-22 | 远光软件股份有限公司 | Receipt configuration and application system and method |
| CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108932293B (en) | 2022-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Fukao | Explaining J apan's Unproductive Two Decades | |
| CN100541492C (en) | Use the data extensibility of external database table | |
| CN109766338A (en) | Self-defined report design method, electronic equipment, storage medium and system | |
| CN103544760A (en) | Queue system and queue method based on mobile terminal | |
| CN109299129A (en) | Data query method, apparatus, computer equipment and the storage medium of natural language | |
| CN101452485A (en) | Method and device for generating multidimensional cubic based on relational database | |
| CN102722537A (en) | Database test data generation method and system thereof | |
| CN109903097A (en) | A kind of user draws a portrait construction method and user draws a portrait construction device | |
| CN108960672B (en) | Quota and time-limited wind control method and device and computer readable storage medium | |
| CN103729448A (en) | Method and device for querying data | |
| CN111026758A (en) | Electronic ticket issuing method and device | |
| CN110807618A (en) | Dynamic scheduling method, device and equipment | |
| CN113537943A (en) | Universal workflow engine and construction method thereof | |
| CN109685636A (en) | Wage number generation method, device, system and computer storage medium | |
| CN108932293A (en) | A kind of customized electronic receipt generation method based on visual configuration | |
| CN101187929A (en) | Formula definition assembly for flexible mathematical aiming at large data of database table | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN102567796A (en) | Method and device for importing data | |
| CN101556680A (en) | Method for reusing transaction information in character front end and character front-end system | |
| CN106649590A (en) | Method and apparatus of processing storage space of database | |
| CN109298925A (en) | A kind of start by set date method, system and the relevant apparatus of periodic duty | |
| CN110008291B (en) | Data early warning method and device, storage medium and electronic equipment | |
| CN113962206A (en) | Report generation method and device | |
| CN111613312B (en) | Equipment operation condition comparison analysis method and device | |
| CN109388647B (en) | WEB-based data filling method and system |
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 |