CN107169050A - A kind of customized Web forms implementation method of pattern - Google Patents
A kind of customized Web forms implementation method of pattern Download PDFInfo
- Publication number
- CN107169050A CN107169050A CN201710280281.4A CN201710280281A CN107169050A CN 107169050 A CN107169050 A CN 107169050A CN 201710280281 A CN201710280281 A CN 201710280281A CN 107169050 A CN107169050 A CN 107169050A
- Authority
- CN
- China
- Prior art keywords
- user
- report
- pattern
- excel
- data
- 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
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/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of customized Web forms implementation method of pattern, inquiry content, time and the type of user's self-defined report according to demand;Template is provided and uploads interface, user freely configures report style in Excel, uploaded onto the server after configuration is good;Form is converted into Html to present in user browser, and the form export function of Excel forms is provided.The method have the advantages that:Data Layer and presentation layer are separated, developer need to only be responsible for data Layer, developed easy to maintenance;User can freely design Report layouts and pattern in Excel according to demand, impart the great free degree of user, and simple to operate;User can change report style at any time according to demand, flexibly and easily.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of customized Web forms implementation method of pattern.
Background technology
Form is mentioned, people are not strange to it, the regular traffic operating of major small enterprises all be unable to do without form.Enterprise
The condition of production, sales situation, profit situation of enterprise are understood by various forms, is that the production in enterprise's later stage and employee examine
Core provides foundation.
There is problems with existing form:Form only provides one or more of fixed data processing modes and form
Pattern, when computational methods and report style need to change, due to technical merit limitation, user can not operate, and can only have exploit person
Member completes, and form is difficult in maintenance.
With being continually changing for demand, the pattern of form is frequently necessary to change, and present part form provide only one kind
Or the report form template of several fixed patterns is for users to use, even if some reporting systems support user voluntarily to change report style,
But technical relatively strong, complex operation, domestic consumer is difficult to realize to change report style according to the demand of oneself.
The content of the invention
Present invention aims at provide one kind to be looked into according to user-defined inquiry content and query time progress data
Ask, form can freely be designed according to the demand of oneself according to user-defined formula progress Data Analysis Services, user
The Web form implementation methods of layout and pattern.
To achieve the above object, following technical scheme is employed:The method of the invention step is as follows:
Step 1, data query:Report name, query time and the report form type selected according to user, dynamic generation SQL
Sentence, performs SQL statement in database, returns to raw data set;
Described report form type includes preiodic type form and self-defined many interval segmented request forms;
The preiodic type form includes but is not limited to:First teams and groups form, second teams and groups form, third teams and groups' form, daily sheet, the moon
Form, year form etc.;
The self-defined interval query form includes but is not limited to:Apical segment form, crest segment form, flat section form, paddy section report
Table etc..
Step 2, data analysis is calculated:The corresponding formula of Data Entry needed for form is inquired, formula is parsed,
The raw data set is calculated using the formula parsed, form result data collection is generated;The result data collection is
The final result of report data;
Step 3, form is configured:An Excel file is automatically created, the result data collection is filled to Excel automatically
In, file is responsive to user browser, user freely designs the layout and pattern of form in Excel according to demand;
Step 4, form is presented:Corresponding data in result data set pair template file described in server by utilizing is carried out more
Newly, form is generated, the form of generation is converted into Html or Excel file, user browser is responsive to, form is completed and presents;
Form appearance form can be that other forms include but is not limited to:Picture format, PDF document etc..
Step 5, report style is changed:When user need to be modified to report form template, by primary template with Excel file shape
Formula is responsive to user browser, after user redesigns to pattern and layout of form etc. according to demand, preserves the new report of generation
Table template, uploads onto the server, and completes template modification.User need to be with the identity logs system of keeper, can after certification success
Carry out report modification.
Further, in step 2, the formula is formed by User Defined editor, is stored in the formula table of database,
The form according to selected by user, dynamic generation SQL statement inquires the formula that the form is related to automatically, carries out after Formula Parsing, right
The data that the initial data is concentrated are calculated, and generate result data collection.
Be related in described formula computing include add, subtract, multiplication and division, bracket, square etc.;
Further, in step 3, user initiates report query request, when system judges that report form template is not present, automatic wound
Build an Excel file, the result data collection filled into file, be responsive to user browser, user also can voluntarily under
Carry.
According to the Excel file of download, user quotes to the result data item in file, according to demand in Excel
The middle design for completing Report layouts and pattern;
The pattern includes position, color, font, font size, frame, chart etc.;
The chart includes column diagram, bar chart, line chart, area-graph, pie chart etc.;
User preserves the report form template configured, and uploading interface by template uploads, and completes form configuration.
In step 3, user freely designs the layout and pattern of form in Excel according to demand, described freely to refer to
User has taken data, can be according to the wish of oneself, the displaying pattern of arbitrarily devised form.
Compared with prior art, the invention has the advantages that:User can freely design according to demand form layout and
Pattern, truly meets the demand of User-defined report, while this method is simple to operate, improves the generation of form
Efficiency, and be easy to the management of form, safeguard and use.
Brief description of the drawings
Fig. 1 is the flow chart of the inventive method.
Fig. 2 is the database model diagram of the inventive method.
Fig. 3 is the data flow figure of the inventive method.
Fig. 4 is report query interface schematic diagram in the inventive method embodiment.
Fig. 5 is report data querying flow figure in the inventive method embodiment.
Fig. 6 is report data analysis calculation flow chart in the inventive method embodiment.
Fig. 7 is form configuration flow figure in the inventive method embodiment.
Fig. 8 is form presentation flow chart in the inventive method embodiment.
Fig. 9 is form maintenance process figure in the inventive method embodiment.
Embodiment
The present invention will be further described below in conjunction with the accompanying drawings:
Reference picture 1, the inventive method step is as follows:
101, data query:Form content, query time and the report form type selected according to user, dynamic generation SQL languages
Sentence, inquires the raw data set required for report generation from database;
102, data analysis is calculated:The corresponding formula of Data Entry needed for form is inquired, formula is parsed, profit
Raw data set is calculated with the formula parsed, form result data collection is generated;
103, intelligent decision reporting status:If form is not configured, into step 104,105, if form has been configured,
It is directly entered step 106;
104, an Excel file is automatically created, result data collection is filled into Excel, file is preserved, file is rung
User browser should be arrived;
105, form configuration:User receives Excel file, according to demand in Excel free pattern to form,
Layout etc. is designed, after report form template is designed, and uploading interface by template uploads, and completes report form template configuration;
106, report generation:Corresponding data in result data set pair template file described in server by utilizing is carried out more
Newly, form is generated;
107, judge whether to change report style, if being not required to change report style, into step 108, otherwise enter step
Rapid 109;
108, form is presented:The form of generation is converted into Html or Excel file, user browser is responsive to, completed
Form is presented;
109, report style modification:The original report template is responsive to browser by server in Excel file form, and is opened
Put template and upload interface, after user redesigns to formwork style and layout according to demand, upload onto the server, complete form mould
Plate is changed.
Reference picture 2, Fig. 2 is the database model diagram of the inventive method:
201, report name record sheet:For the title for all forms for storing user's addition;
202, report form formula record sheet:For storing data item and its calculation formula in form;
203, historgraphic data recording table:Initial data for storing data item in form, using the time of record as major key,
The time and all data item collectively constitute a record;
204, result of calculation blotter table:The report data result after finishing is calculated for storing.
The data flow figure for the customized Web forms of pattern that Fig. 3 provides for the present invention:
301, data are located in the historgraphic data recording table in database;
302, SQL statement is generated according to querying condition and performed, raw data set needed for returning to form is stored in server
In internal memory;
303, formula needed for form is inquired and parsed, analysis calculating, generation are carried out to raw data set using formula
Result data collection, the data set is stored in the result of calculation blotter table in database;
304, the form result of calculation in reading database result of calculation blotter table fills data to Excel moulds
In plate file;
305, form is converted into Html and is responsive to client browser;
306, form is converted into Excel file and is responsive to client browser.
Fig. 4 is report query interface schematic diagram in the embodiment of the present invention:
401, it is querying condition region, alternatively referred to as functional areas,
4011, it is preiodic type report query region, selects report name, on the input inquiry date, click on inquiry button and submit
Inquiry;
4012, it is inquiry operation area between self-defined area, selects report name, input inquiry time started and end time,
Click on inquiry button and submit inquiry;
4012, it is Excel forms export selection area, chooses check box to support Excel forms to export, the operation is to above-mentioned
Two kinds of report forms come into force.
Fig. 5 is a kind of flow chart of embodiment of step 101 data query in Fig. 1:
1011, extract the registration title in user's request, Query Dates, report form type and be used as querying condition;
1012, SQL query statement is generated according to querying condition;
1013, SQL statement is performed in database;
1014, return to inquired about raw data set.
Fig. 6 is a kind of flow chart of embodiment of step 102 data analysis calculating in Fig. 1:
1021, the calculation formula according to needed for report name inquires the form;
1022, calculation formula is parsed;
1023, analysis calculating is carried out to raw data set using the formula after parsing;
1024, generate calculation result data collection;
1025, result data collection is stored in the result of calculation blotter table in database.
Fig. 7 is step 104, a kind of flow chart of embodiment of 105 forms configuration in Fig. 1:
1041, automatically create an Excel file;
1042, result data collection is read out from database and is filled into newly-built Excel file;
1043, Excel file is responsive to user browser;
1051, user receives Excel file, and freely pattern, layout of form etc. are entered in Excel according to demand
Row design;
1052, interface is uploaded by template and uploaded, designed template file is uploaded onto the server, report form template is completed
Configuration.
Fig. 8 is a kind of flow chart of embodiment of step 108 form presentation in Fig. 1:
1081, the data item to form is updated, and generates form;
1082, according to user's request, form is converted into Html/Excel files;
1083, Html/Excel files are responsive to user browser, form is completed and presents.
Fig. 9 is a kind of flow chart of embodiment of step 109 form maintenance in Fig. 1:
1091, the original report template is responsive to browser in Excel file form;
1092, server opens template and uploads interface;
1093, pattern, the layout of user according to demand to template etc. is redesigned;
1094, the template after renewal uploads onto the server again, report modification is completed.
In summary, the customized Web forms implementation method of a kind of pattern that the present invention is provided, the advantage is that:Form
Configuration and completed using flow by server intelligently guiding, greatly reduce the use difficulty of form, operated when user uses
Simply;The template configuration of form is freely completed by user in Excel, and user can freely design the cloth of form according to demand
Office, pattern, add various form elements, realize Reporting Customization truly;A kind of pattern that the present invention is provided is certainly
The Web form implementation methods of definition, support user to be modified at any time to report form template, flexibly and easily.
Embodiment described above is only that the preferred embodiment of the present invention is described, not to the model of the present invention
Enclose and be defined, on the premise of design spirit of the present invention is not departed from, technical side of the those of ordinary skill in the art to the present invention
In various modifications and improvement that case is made, the protection domain that claims of the present invention determination all should be fallen into.
Claims (4)
1. a kind of customized Web forms implementation method of pattern, it is characterised in that methods described step is as follows:
Step 1, data query:Report name, query time and the report form type selected according to user, dynamic generation SQL statement,
SQL statement is performed in database, raw data set is returned;
Step 2, data analysis is calculated:The corresponding formula of Data Entry needed for form is inquired, formula is parsed, is utilized
The formula parsed is calculated the raw data set, generates form result data collection;The result data integrates as form
The final result of data item;
Step 3, form is configured:An Excel file is automatically created, the result data collection is filled into Excel automatically, will
File is responsive to user browser, and user freely designs the layout and pattern of form in Excel according to demand;
Step 4, form is presented:Corresponding data in result data set pair template file described in server by utilizing is updated,
Form is generated, the form of generation is converted into Html or Excel file, user browser is responsive to, form is completed and presents;
Step 5, report style is changed:When user need to be modified to report form template, primary template is rung in Excel file form
User browser should be arrived, after user redesigns to pattern and layout of form etc. according to demand, the new form mould of generation is preserved
Plate, uploads onto the server, and completes template modification.
2. the customized Web forms implementation method of a kind of pattern according to claim 1, it is characterised in that:In step 2,
The formula is formed by User Defined editor, is stored in the formula table of database, the form according to selected by user, dynamic generation
SQL statement, inquires the formula that the form is related to automatically, carries out after Formula Parsing, and the data that the initial data is concentrated are entered
Row is calculated, and generates result data collection.
3. the customized Web forms implementation method of a kind of pattern according to claim 1, it is characterised in that:In step 3,
User initiates report query request, when system judges that report form template is not present, an Excel file is automatically created, by the knot
Fruit data set is filled into file, is responsive to user browser, and user also can voluntarily download.
4. the customized Web forms implementation method of a kind of pattern according to claim 1, it is characterised in that:In step 3,
User freely designs the layout and pattern of form in Excel according to demand, described freely to refer to that user has taken number
According to can be according to the wish of oneself, the displaying pattern of arbitrarily devised form.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710280281.4A CN107169050A (en) | 2017-04-26 | 2017-04-26 | A kind of customized Web forms implementation method of pattern |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710280281.4A CN107169050A (en) | 2017-04-26 | 2017-04-26 | A kind of customized Web forms implementation method of pattern |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107169050A true CN107169050A (en) | 2017-09-15 |
Family
ID=59813121
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710280281.4A Pending CN107169050A (en) | 2017-04-26 | 2017-04-26 | A kind of customized Web forms implementation method of pattern |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107169050A (en) |
Cited By (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107992600A (en) * | 2017-12-13 | 2018-05-04 | 中国建设银行股份有限公司福建省分行 | A kind of method and computer equipment of intelligence generation data acquisition webpage |
CN108256111A (en) * | 2018-02-09 | 2018-07-06 | 东莞嘉泰钟表有限公司 | The unattended method for preserving the Excel reports containing form |
CN108345579A (en) * | 2018-02-11 | 2018-07-31 | 悦锦软件系统(上海)有限公司 | A kind of self-defined report logic engine and method |
CN108446381A (en) * | 2018-03-19 | 2018-08-24 | 武汉华大国家数字化学习工程技术有限公司 | A kind of data visualisation system and method based on Web |
CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
CN108959216A (en) * | 2017-09-20 | 2018-12-07 | 杭州弯流科技有限公司 | A kind of system of report exploitation |
CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
CN109491743A (en) * | 2018-11-05 | 2019-03-19 | 上海鋆创信息技术有限公司 | Visual Report Forms generation method, device, electronic equipment and storage medium |
CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
CN110019042A (en) * | 2019-04-15 | 2019-07-16 | 成都四方伟业软件股份有限公司 | Report file generation method, apparatus and system |
CN111488361A (en) * | 2020-04-17 | 2020-08-04 | 北京中启智源数字信息技术有限责任公司 | Cross report generation method and system |
CN112508719A (en) * | 2020-12-04 | 2021-03-16 | 中国人寿保险股份有限公司 | Report processing method and device |
CN112699647A (en) * | 2020-12-31 | 2021-04-23 | 杭州立思辰安科科技有限公司 | Implementation method for supporting custom report |
CN113486269A (en) * | 2021-05-25 | 2021-10-08 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device, and storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
CN105740219A (en) * | 2016-01-29 | 2016-07-06 | 浪潮软件集团有限公司 | Report self-defining method and device |
-
2017
- 2017-04-26 CN CN201710280281.4A patent/CN107169050A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
CN105740219A (en) * | 2016-01-29 | 2016-07-06 | 浪潮软件集团有限公司 | Report self-defining method and device |
Cited By (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108959216A (en) * | 2017-09-20 | 2018-12-07 | 杭州弯流科技有限公司 | A kind of system of report exploitation |
CN107992600A (en) * | 2017-12-13 | 2018-05-04 | 中国建设银行股份有限公司福建省分行 | A kind of method and computer equipment of intelligence generation data acquisition webpage |
CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
CN108256111A (en) * | 2018-02-09 | 2018-07-06 | 东莞嘉泰钟表有限公司 | The unattended method for preserving the Excel reports containing form |
CN108345579A (en) * | 2018-02-11 | 2018-07-31 | 悦锦软件系统(上海)有限公司 | A kind of self-defined report logic engine and method |
CN108345579B (en) * | 2018-02-11 | 2021-09-24 | 悦锦软件系统(上海)有限公司 | Self-defined report logic engine and method |
CN108446381A (en) * | 2018-03-19 | 2018-08-24 | 武汉华大国家数字化学习工程技术有限公司 | A kind of data visualisation system and method based on Web |
CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
CN109491743A (en) * | 2018-11-05 | 2019-03-19 | 上海鋆创信息技术有限公司 | Visual Report Forms generation method, device, electronic equipment and storage medium |
CN110019042A (en) * | 2019-04-15 | 2019-07-16 | 成都四方伟业软件股份有限公司 | Report file generation method, apparatus and system |
CN111488361A (en) * | 2020-04-17 | 2020-08-04 | 北京中启智源数字信息技术有限责任公司 | Cross report generation method and system |
CN112508719A (en) * | 2020-12-04 | 2021-03-16 | 中国人寿保险股份有限公司 | Report processing method and device |
CN112699647A (en) * | 2020-12-31 | 2021-04-23 | 杭州立思辰安科科技有限公司 | Implementation method for supporting custom report |
CN113486269A (en) * | 2021-05-25 | 2021-10-08 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device, and storage medium |
CN113486269B (en) * | 2021-05-25 | 2024-01-30 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107169050A (en) | A kind of customized Web forms implementation method of pattern | |
US10545976B2 (en) | Automated presentation of information using infographics | |
US7805400B2 (en) | Report generation using metadata | |
CN100412870C (en) | Gateway personalized recommendation service method and system introduced yuan recommendation engine | |
US20060195424A1 (en) | Generating business warehouse reports | |
JP2009518701A (en) | Website visit data set comparison | |
JP2007272814A (en) | System, method and program for advertisement distribution | |
CN103177308A (en) | Intelligent decision-making support system for project management | |
CN102207861A (en) | Method for expressing personalized information in business | |
CN104850955B (en) | The user information intelligent management and system of Network Environment | |
CN101661493A (en) | Interactive electronic technical manual browsing system | |
Theocharis et al. | Knowledge management systems in the public sector: Critical issues | |
CN102105875A (en) | System and method for providing a consolidated service for a homepage | |
CN110069450A (en) | Interactive electronic technical manual platform based on S1000D standard | |
CN201540571U (en) | Interactive electronic technical manual exploring system | |
Saxena et al. | Business intelligence | |
Gan et al. | Research on innovative design of product packaging based on big data technology | |
JP6130580B1 (en) | Personal plan creation system and personal plan creation program | |
ATE455331T1 (en) | NETWORK-BASED SYSTEM FOR MANAGING DOCUMENTS | |
BELAISSAOUI et al. | The End-user Continuance intention with an Open Source ERP: A proposal for an integrated model | |
Renfro | Economic database systems: further reflections on the state of the art | |
Holsheimer | Data mining by business users: integrating data mining in business processes | |
JP7522512B1 (en) | Intent sales support device | |
CN103425713A (en) | Anopheles on-line image-text sorting retrieval system and retrieval method thereof | |
Šimunić et al. | Tourism and e-business: The semantic paradigm as a precondition for success |
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 | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170915 |
|
WD01 | Invention patent application deemed withdrawn after publication |