CN108874760A - Report file generation method, device, computer equipment and storage medium - Google Patents
Report file generation method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN108874760A CN108874760A CN201810500758.XA CN201810500758A CN108874760A CN 108874760 A CN108874760 A CN 108874760A CN 201810500758 A CN201810500758 A CN 201810500758A CN 108874760 A CN108874760 A CN 108874760A
- Authority
- CN
- China
- Prior art keywords
- template
- report
- field name
- file
- 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.)
- Granted
Links
Classifications
-
- 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)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The embodiment of the invention provides a kind of report file generation method, device, computer equipment and storage mediums.This method includes the authority information for obtaining active user;The type of the corresponding report template of report file generated needed for being obtained according to the authority information;List data is obtained according to the type of the report template;The list data is filled to the report template, to generate report file.Implement the embodiment of the present invention, is conducive to promote report making efficiency, and improve data accuracy.
Description
Technical field
The present invention relates to field of computer data processing more particularly to a kind of report file generation methods, device, computer
Equipment and computer readable storage medium.
Background technique
With becoming increasingly popular for computer information technology, data sheet is supplied to user's number of concern in table form
According to, and for some analysis results that these data generate.Statement form has for other data offer forms
The features such as simplicity, intuitive and specification, it is widely used in all trades and professions.
In the prior art, the production of data sheet is completed usually in the form of manual, can for the report with same attribute
To be used for multiple files, but different files have different needs the data in report, in this way the process in production report
Middle needs are repeatedly adjusted manually.To cause report making low efficiency, data accuracy is low the problems such as.
Summary of the invention
The embodiment of the invention provides a kind of report file generation method, device, computer equipment and storage mediums, it is intended to
Solve report making low efficiency, the problems such as data accuracy is low.
In a first aspect, the embodiment of the invention provides a kind of report file generation methods comprising:
Obtain the authority information of active user;
The type of the corresponding report template of report file generated needed for being obtained according to the authority information;
List data is obtained according to the type of the report template;
The list data is filled to the report template, to generate report file.
Second aspect, the embodiment of the invention provides a kind of report file generating means comprising:
Authority acquiring unit, for obtaining the authority information of active user;
First acquisition unit, the corresponding report template of report file for being generated needed for being obtained according to the authority information
Type;
Second acquisition unit, for obtaining list data according to the type of the report template;
First generation unit, for filling the list data to the report template, to generate report file.
The third aspect, the embodiment of the present invention provide a kind of computer equipment again comprising memory, processor and storage
On the memory and the computer program that can run on the processor, wherein the processor executes described program
The above-mentioned report file generation method of Shi Shixian.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, wherein the computer can
It reads storage medium and is stored with computer program, the computer program includes program instruction, and described program instruction is when by processor
The processor is set to execute above-mentioned report file generation method when execution.
The embodiment of the present invention provides a kind of report file generation method, device, computer equipment and computer-readable storage
Medium.This method includes the authority information for obtaining active user;The report file generated needed for being obtained according to the authority information
The type of corresponding report template;List data is obtained according to the type of the report template;By the list data fill to
The report template, to generate report file.Implement the embodiment of the present invention, is conducive to promote report making efficiency, and improve
Data accuracy.
Detailed description of the invention
Technical solution in order to illustrate the embodiments of the present invention more clearly, below will be to needed in embodiment description
Attached drawing is briefly described, it should be apparent that, drawings in the following description are some embodiments of the invention, general for this field
For logical technical staff, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow diagram for report file generation method that one embodiment of the invention provides;
Fig. 2 is a kind of sub-process schematic diagram for report file generation method that one embodiment of the invention provides;
Fig. 3 is a kind of sub-process schematic diagram for report file generation method that one embodiment of the invention provides;
Fig. 4 is a kind of flow diagram for report file generation method that one embodiment of the invention provides;
Fig. 5 is a kind of flow diagram for report file generation method that one embodiment of the invention provides;
Fig. 6 is a kind of schematic block diagram for report file generating means that one embodiment of the invention provides;
The schematic frame of first acquisition unit in a kind of report file generating means that Fig. 7 provides for one embodiment of the invention
Figure;
The schematic frame of second acquisition unit in a kind of report file generating means that Fig. 8 provides for one embodiment of the invention
Figure;
Fig. 9 is a kind of another schematic block diagram for report file generating means that one embodiment of the invention provides;
Figure 10 is a kind of another schematic block diagram for report file generating means that one embodiment of the invention provides;
Figure 11 is a kind of schematic block diagram for computer equipment that one embodiment of the invention provides.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and/or component, but one or more other spies are not precluded
Sign, entirety, step, operation, the presence or addition of element, component and/or its set.
It is also understood that mesh of the term used in this description of the invention merely for the sake of description specific embodiment
And be not intended to limit the present invention.As description of the invention and it is used in the attached claims, unless on
Other situations are hereafter clearly indicated, otherwise " one " of singular, "one" and "the" are intended to include plural form.
Fig. 1 is please referred to, for a kind of flow diagram for report file generation method that one embodiment of the invention provides.Institute
Stating report file generation method includes but is not limited to step S110-S140.
S110 obtains the authority information of active user.
Specifically referring to figure 2., a kind of sub-process of the report file generation method provided for one embodiment of the invention is shown
It is intended to.Further, the authority information for obtaining active user specifically may include step S111-S112.
S111 obtains the corresponding user identifier of active user.
Wherein, user identifier can be to look at the login account used when report, terminal number of current computer etc..
S112 obtains the authority information of active user according to the user identifier and preset permissions mapping table.
Wherein, preset permissions mapping table stores the mapping relations of user identifier and authority information.For example, by pre-
If permissions mapping table can determine that the corresponding authority information of the login account of " 100 " beginning is that " M7 ", login account are
The corresponding authority information of " 200 " beginning is " M8 " etc..
Assuming that the user identifier is login account, which is " 100001 ", according to the login account and in advance
If permissions mapping relationship, it may be determined that the corresponding authority information of active user be " M7 ".
S120, the type of the corresponding report template of report file generated needed for being obtained according to the authority information.
Specifically, report template includes the information such as template field name, and each template field name is correspondingly provided with for filling table
The filling frame of lattice data.Wherein, template field name can be one or more, such as template field name may include name,
Department, age, achievement etc..Corresponding, the template field name of each type is correspondingly provided with one or more for filling out
Fill the filling frame of list data.Different templates field name corresponds to different filling frames, can be true according to template field name and filling frame
Determine the positional relationship of list data.Report template specifically can refer to table 1.
Table 1
Template field name | Fill frame | Fill frame | Fill frame | Fill frame |
Name | Zhang San | Li Si | King five | Zhao six |
Department | One | Two | Three | Three |
Age | 24 | 26 | 28 | 30 |
Achievement | 100000 | 200000 | 300000 | 400000 |
Wherein, the type of report template may include one or more, the corresponding template of different types of report template
Field name is different.For example, it is assumed that the type of report template includes the first report template and the second report template, then the first report
The corresponding template field name of template template field name corresponding from the second report template is different.Such as first report template it is corresponding
Template field name may include name, department and age, and the corresponding template field name of the second report template may include name, portion
Door, age and achievement.
In specific implementation, different rights information corresponds to different types of report template.Such as authority information " M7 " can be right
The first report template is answered, authority information " M8 " can correspond to the second report template.That is the corresponding template field name of authority information " M7 "
Specifically include name, department and age;That is the corresponding template field name of authority information " M8 " specifically includes name, department, year
Age and achievement.
Implement the embodiment of the present invention, by obtaining the authority information of user, and then report template is determined according to authority information
Type, realize and template field name type determined by authority information, realize the automatic configuration of report permission.
S130 obtains list data according to the type of the report template.
In specific implementation, list data be can store in preassigned database, file or application program, list data
It can store in one or more specified data library, file or application program.For example, list data can store in multiple
Excel file in.
By Window OLE (Object Link and Embed, Object link and embedded) control or directly adopt
Stream socket reads and writes the achievable operation for obtaining list data of Excel file.Or by Java Excel API with deposit
The Excel file for containing list data is operated, to complete to obtain the operation of list data.
Specifically referring to figure 3., a kind of sub-process of the report file generation method provided for one embodiment of the invention is shown
It is intended to.Further, the list data includes data field name and data field value, described according to the report template
Type obtains list data, including step S131-S133.
S131 obtains the corresponding template field name of report template according to the type of the report template.
In specific implementation, the type of report template may include one or more, and different types of report template is corresponding
Template field name it is different.For example, the type of report template be the first template type, corresponding template field name include name,
Department and age.
S132 is obtained and the matched data field name of the template field famous prime minister.
Further, the acquisition specifically can be in the following way with the matched data field name of the template field famous prime minister
It realizes:Judge whether the data field name matches with template field name;If the data field name and the template field
Name matches, then obtains the data field name.
Further, judging whether the data field name matches with template field name specifically can be real in the following way
It is existing:Data field name is input to preset template field name mapping library, is judged whether there is corresponding with data field name
Output is as a result, output corresponding with data field name is as a result, then determine the data field name and institute if it exists
State the matching of template field name.
In specific implementation, which includes multiple template field name mapping relations, template word
Section name mapping relations be many-to-one mapping relations, such as template field name mapping relations be specifically as follows " age ", " age ",
" age " is directed to " age ".If " age ", " age " or " age " is input to preset template field name mapping library,
Corresponding output result is " age ", that is, there is output corresponding with data field name as a result, determining the data field
Name is matched with the template field name.
S133 obtains data field value according to the data field name.
Specifically, data field name is corresponding with one or more data field value.Such as data field name " age " is right
The data field value answered can have " 24 ", " 26 ", " 28 ", " 30 " etc..If template field name includes " age ", number can determine
Match according to field name " age " with template field name, and then according to data field name " age ", obtains its corresponding data field
Value.
S140 fills the list data to the report template, to generate report file.
In specific implementation, it is assumed that the corresponding data field of accessed list data is entitled " name ", corresponding data
Field value is " Zhang San ", " Li Si ", " king five " and " Zhao six ".Then by data field value be " Zhang San ", " Li Si ", " king five " with
And " Zhao six " filling corresponding filling frame of template field name " name " into the report template, it can be completed the table number
According to filling to the report template, report file is generated.
Implement the embodiment of the present invention, by will acquire report template and obtain list data independent process, can avoid occurring
The case where causing a large amount of modifications of list data because of report template modification, reduces the number being modified to code, reduces
Workload is conducive to promote working efficiency.
Referring to figure 4., a kind of flow diagram of the report file generation method provided for one embodiment of the invention.Into
One step, it is described to fill the list data to the report template, after generating report file, the method also includes
Step S210-S240.
The report file is converted to html file by S210.
In specific implementation, the form document, which is converted to web page form, to be realized by DOM technology.Wherein, DOM is
The abbreviation of XML Document Object Model.It is the interface of XML document and html document, wherein including a series of generations
The program object of Table X ML document difference component.Using the attribute and method of these objects, and (such as using scripting language
VBScript or JavaScript etc.) it is compiled into after script, it can be achieved that report file is converted to html file.The html file
It is uploaded in server.
S220 parses the html file, to generate web page form.
Wherein, parsing the html file can be complete by the HTMLParser (html parser) built in all kinds of browsers
At, it is logical that html file is parsed, produce web page form.Wherein, which can be shown in display circle of browser
In face.
S230 generates the tick boxes for selecting the template field name according to the template field name of the report template.
Wherein, each template field name corresponds to unique tick boxes.The tick boxes are checked, then in the webpage
The template field name and the corresponding form field value of template field name are shown in table.
Specifically referring to figure 5., a kind of sub-process of the report file generation method provided for one embodiment of the invention is shown
It is intended to.Further, the hook generated according to the template field name of the report template for selecting the template field name
After selecting frame, the method also includes step S231-S233.
S231 obtains the number of clicks of the tick boxes.
In specific implementation, the number of clicks for obtaining the tick boxes is specially to obtain the template field in preset time period
The corresponding number of clicks of name, such as can be the number of clicks of the template field name in the past one month of acquisition.
S232 determines putting in order for the tick boxes according to the number of clicks.
In specific implementation, it can determine that the arrangement of the tick boxes is suitable according to sequence from large to small according to the number of clicks
Sequence, the bigger arrangement cis-position of number of clicks are more forward.For example, it is assumed that the click of the corresponding tick boxes of template field entitled " name "
Number is 300 times, and the number of clicks of the corresponding tick boxes of template field entitled " department " is 100 times, template field entitled " year
The number of clicks of age " corresponding tick boxes is 200 times.According to the sequence of number of clicks from large to small, it may be determined that template field name
Put in order as " name "-" age "-" department ".
S233 arranges the tick boxes according to described put in order.
Implement the embodiment of the present invention has by being ranked up according to number of clicks to the corresponding tick boxes of template field name
Click conducive to user and choose operation, user experience can be promoted.
The web page form and the tick boxes are shown in display interface by S240.
Specifically, which can be the web interface of browser, by showing tick boxes and web page form
In web interface, user can be facilitated quickly to check report content, and the quickly screening to report content.
The embodiment of the invention also provides a kind of report file generating means, before the report file generating means are for executing
State any embodiment of report file generation method.
Fig. 6 is please referred to, for a kind of schematic frame for report file generating means 100 that one embodiment of the invention provides
Figure.The report file generating means 100 include authority acquiring unit 110, first acquisition unit 120, second acquisition unit 130 with
And first generation unit 140.
Authority acquiring unit 110, for obtaining the authority information of active user.
Fig. 7 specifically is please referred to, permission obtains in a kind of report file generating means 100 provided for one embodiment of the invention
Take the schematic block diagram of unit 110.Further, the authority acquiring unit 110 includes third acquiring unit 111 and the 4th
Acquiring unit 112.
Third acquiring unit 111, for obtaining the corresponding user identifier of active user.
Wherein, user identifier can be to look at the login account used when report, terminal number of current computer etc..
4th acquiring unit 112, for obtaining current use according to the user identifier and preset permissions mapping table
The authority information at family.
Wherein, preset permissions mapping table stores the mapping relations of user identifier and authority information.For example, by pre-
If permissions mapping table can determine that the corresponding authority information of the login account of " 100 " beginning is that " M7 ", login account are
The corresponding authority information of " 200 " beginning is " M8 " etc..
Assuming that the user identifier is login account, which is " 100001 ", according to the login account and in advance
If permissions mapping relationship, it may be determined that the corresponding authority information of active user be " M7 ".
First acquisition unit 120, the corresponding report of report file for being generated needed for being obtained according to the authority information
The type of template.
Specifically, report template includes the information such as template field name, and each template field name is correspondingly provided with for filling table
The filling frame of lattice data.Wherein, template field name can be one or more, such as template field name may include name,
Department, age, achievement etc..Corresponding, the template field name of each type is correspondingly provided with one or more for filling out
Fill the filling frame of list data.Different templates field name corresponds to different filling frames, can be true according to template field name and filling frame
Determine the positional relationship of list data.Report template specifically can refer to table 1.
Wherein, the type of report template may include one or more, the corresponding template of different types of report template
Field name is different.For example, it is assumed that the type of report template includes the first report template and the second report template, then the first report
The corresponding template field name of template template field name corresponding from the second report template is different.Such as first report template it is corresponding
Template field name may include name, department and age, and the corresponding template field name of the second report template may include name, portion
Door, age and achievement.
In specific implementation, different rights information corresponds to different types of report template.Such as authority information " M7 " can be right
The first report template is answered, authority information " M8 " can correspond to the second report template.That is the corresponding template field name of authority information " M7 "
Specifically include name, department and age;That is the corresponding template field name of authority information " M8 " specifically includes name, department, year
Age and achievement.
Implement the embodiment of the present invention, by obtaining the authority information of user, and then report template is determined according to authority information
Type, realize and template field name type determined by authority information, realize the automatic configuration of report permission.
Second acquisition unit 130, for obtaining list data according to the type of the report template.
In specific implementation, list data be can store in preassigned database, file or application program, list data
It can store in one or more specified data library, file or application program.For example, list data can store in multiple
Excel file in.
By Window OLE (Object Link and Embed, Object link and embedded) control or directly adopt
Stream socket reads and writes the achievable operation for obtaining list data of Excel file.Or by Java Excel API with deposit
The Excel file for containing list data is operated, to complete to obtain the operation of list data.
Fig. 8 specifically is please referred to, second obtains in a kind of report file generating means 100 provided for one embodiment of the invention
Take the schematic block diagram of unit 130.Further, the second acquisition unit 130 includes that the 5th acquiring unit the 131, the 6th obtains
Take unit 132 and the 7th acquiring unit 133.
5th acquiring unit 131, for obtaining the corresponding template field of report template according to the type of the report template
Name.
In specific implementation, the type of report template may include one or more, and different types of report template is corresponding
Template field name it is different.For example, the type of report template be the first template type, corresponding template field name include name,
Department and age.
6th acquiring unit 132, for obtaining and the matched data field name of the template field famous prime minister.
Further, the 6th acquiring unit 132 has when obtaining data field name matched with the template field famous prime minister
Body is used for:Judge whether the data field name matches with template field name;If the data field name and the template word
Section name matches, then obtains the data field name.
Further, the 6th acquiring unit 132 is when judging whether the data field name matches with template field name
It is specifically used for:Data field name is input to preset template field name mapping library, is judged whether there is and data field famous prime minister
Corresponding output is as a result, output corresponding with data field name is as a result, then determine the data field if it exists
Name is matched with the template field name.
In specific implementation, which includes multiple template field name mapping relations, template word
Section name mapping relations be many-to-one mapping relations, such as template field name mapping relations be specifically as follows " age ", " age ",
" age " is directed to " age ".If " age ", " age " or " age " is input to preset template field name mapping library,
Corresponding output result is " age ", that is, there is output corresponding with data field name as a result, determining the data field
Name is matched with the template field name.
7th acquiring unit 133, for obtaining data field value according to the data field name.
Specifically, data field name is corresponding with one or more data field value.Such as data field name " age " is right
The data field value answered can have " 24 ", " 26 ", " 28 ", " 30 " etc..If template field name includes " age ", number can determine
Match according to field name " age " with template field name, and then according to data field name " age ", obtains its corresponding data field
Value.
First generation unit 140, for filling the list data to the report template, to generate report file.
In specific implementation, it is assumed that the corresponding data field of accessed list data is entitled " name ", corresponding data
Field value is " Zhang San ", " Li Si ", " king five " and " Zhao six ".Then by data field value be " Zhang San ", " Li Si ", " king five " with
And " Zhao six " filling corresponding filling frame of template field name " name " into the report template, it can be completed the table number
According to filling to the report template, report file is generated.
Implement the embodiment of the present invention, by will acquire report template and obtain list data independent process, can avoid occurring
The case where causing a large amount of modifications of list data because of report template modification, reduces the number being modified to code, reduces
Workload is conducive to promote working efficiency.
Fig. 9 is please referred to, for a kind of schematic frame for report file generating means 100 that one embodiment of the invention provides
Figure.Further, the report file generating means 100 further include converting unit 210, resolution unit 220, the second generation unit
230 and display unit 240.
Converting unit 210, for the report file to be converted to html file.
In specific implementation, the form document, which is converted to web page form, to be realized by DOM technology.Wherein, DOM is
The abbreviation of XML Document Object Model.It is the interface of XML document and html document, wherein including a series of generations
The program object of Table X ML document difference component.Using the attribute and method of these objects, and (such as using scripting language
VBScript or JavaScript etc.) it is compiled into after script, it can be achieved that report file is converted to html file.The html file
It is uploaded in server.
Resolution unit 220, for parsing the html file, to generate web page form.
Wherein, parsing the html file can be complete by the HTMLParser (html parser) built in all kinds of browsers
At, it is logical that html file is parsed, produce web page form.Wherein, which can be shown in display circle of browser
In face.
Second generation unit 230 is generated according to the template field name of the report template for selecting the template field
The tick boxes of name.
Wherein, each template field name corresponds to unique tick boxes.The tick boxes are checked, then in the webpage
The template field name and the corresponding form field value of template field name are shown in table.
Figure 10 specifically is please referred to, is a kind of the another of report file generating means 100 that one embodiment of the invention provides
Schematic block diagram.Further, described device 100 further includes the 8th acquiring unit 231, determination unit 232 and arrangement units
233。
8th acquiring unit 231, for obtaining the number of clicks of the tick boxes.
In specific implementation, the number of clicks for obtaining the tick boxes is specially to obtain the template field in preset time period
The corresponding number of clicks of name, such as can be the number of clicks of the template field name in the past one month of acquisition.
Determination unit 232, for determining putting in order for the tick boxes according to the number of clicks.
In specific implementation, it can determine that the arrangement of the tick boxes is suitable according to sequence from large to small according to the number of clicks
Sequence, the bigger arrangement cis-position of number of clicks are more forward.For example, it is assumed that the click of the corresponding tick boxes of template field entitled " name "
Number is 300 times, and the number of clicks of the corresponding tick boxes of template field entitled " department " is 100 times, template field entitled " year
The number of clicks of age " corresponding tick boxes is 200 times.According to the sequence of number of clicks from large to small, it may be determined that template field name
Put in order as " name "-" age "-" department ".
Arrangement units 233 arrange the tick boxes for putting in order according to.
Implement the embodiment of the present invention has by being ranked up according to number of clicks to the corresponding tick boxes of template field name
Click conducive to user and choose operation, user experience can be promoted.
Display unit 240, for the web page form and the tick boxes to be shown in display interface.
Specifically, which can be the web interface of browser, by showing tick boxes and web page form
In web interface, user can be facilitated quickly to check report content, and the quickly screening to report content.
Above-mentioned apparatus 100 can be implemented as a kind of form of computer program, and computer program can be as shown in figure 11
Computer equipment on run.
Figure 11 is please referred to, Figure 11 is a kind of schematic block diagram of computer equipment provided in an embodiment of the present invention.The calculating
500 equipment of machine equipment can be terminal.The terminal can be smart phone, tablet computer, laptop, desktop computer, a
Personal digital assistant and wearable device etc. have the electronic equipment of communication function.
The computer equipment 500 includes processor 520, memory and the network interface connected by system bus 510
550, wherein memory may include non-volatile memory medium 530 and built-in storage 540.
The non-volatile memory medium 530 can storage program area 531 and computer program 532.The computer program 532
It is performed, processor 520 may make to execute a kind of report file generation method.
The processor 520 supports the operation of entire computer equipment 500 for providing calculating and control ability.
The built-in storage 540 provides environment for the operation of the computer program in non-volatile memory medium, the computer
When program is executed by processor 520, processor 520 may make to execute a kind of report file generation method.
The network interface 550 such as sends the task dispatching of distribution for carrying out network communication.Those skilled in the art can manage
Solution, the schematic block diagram of the computer equipment are only the block diagram of part-structure relevant to the present invention program, composition pair
The restriction for the computer equipment 500 that the present invention program is applied thereon, specific computer equipment 500 may include than in figure
Shown more or fewer components perhaps combine certain components or with different component layouts.
Wherein, the processor 520 is for running program code stored in memory, to implement function such as:
Obtain the authority information of active user;
The type of the corresponding report template of report file generated needed for being obtained according to the authority information;
List data is obtained according to the type of the report template;
The list data is filled to the report template, to generate report file.
In one embodiment, processor 520 is specifically held when executing the step of the authority information for obtaining active user
Row following steps:
Obtain the corresponding user identifier of active user;
According to the user identifier and preset permissions mapping table, the authority information of active user is obtained.It is real one
It applies in example, processor 520 includes data field name and data field value executing the list data, described according to the report
When the type of table template obtains the step of list data, following steps are specifically executed:
The corresponding template field name of report template is obtained according to the type of the report template;
It obtains and the matched data field name of the template field famous prime minister;
Data field value is obtained according to the data field name.
In one embodiment, processor 520 described fills the list data to the report template, with life executing
After the step of report file, following steps are specifically executed:
The report file is converted into html file;
The html file is parsed, to generate web page form;
The tick boxes for selecting the template field name are generated according to the template field name of the report template;
The web page form and the tick boxes are shown in display interface.
In one embodiment, processor 520 is used in described generated according to the template field name of the report template of execution
After the step of selecting the tick boxes of the template field name, following steps are specifically executed:
Obtain the number of clicks of the tick boxes;
Putting in order for the tick boxes is determined according to the number of clicks;
The tick boxes are arranged according to described put in order.
It should be appreciated that in embodiments of the present invention, processor 520 can be central processing unit (Central
Processing Unit, CPU), which can also be other general processors, digital signal processor (Digital
Signal Processor, DSP), specific integrated circuit (Application Specific Integrated Circuit,
ASIC), ready-made programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic
Device, discrete gate or transistor logic, discrete hardware components etc..Wherein, general processor can be microprocessor or
Person's processor is also possible to any conventional processor etc..
It will be understood by those skilled in the art that the schematic block diagram of the computer equipment 500 is not constituted and is set to computer
Standby 500 restriction may include perhaps combining certain components or different component cloth than illustrating more or fewer components
It sets.
A kind of computer readable storage medium is provided in another embodiment of the invention, the computer readable storage medium
It is stored with computer program, wherein computer program includes program instruction.Described program instruction is realized such as when being executed by processor
Lower step:
Obtain the authority information of active user;
The type of the corresponding report template of report file generated needed for being obtained according to the authority information;
List data is obtained according to the type of the report template;
The list data is filled to the report template, to generate report file.
In one embodiment, described program instruction is executed by processor to realize the authority information for obtaining active user
Step when, be implemented as follows step:
Obtain the corresponding user identifier of active user;
According to the user identifier and preset permissions mapping table, the authority information of active user is obtained.It is real one
It applies in example, described program instruction is executed by processor to realize that the list data includes data field name and data field
Value, it is described according to the type of the report template obtain list data step when, be implemented as follows step:
The corresponding template field name of report template is obtained according to the type of the report template;
It obtains and the matched data field name of the template field famous prime minister;
Data field value is obtained according to the data field name.
In one embodiment, described program instruction is executed by processor to realize the template according to the report template
After field name generates the step of tick boxes for selecting the template field name, it is implemented as follows step:
The report file is converted into html file;
The html file is parsed, to generate web page form;
The tick boxes for selecting the template field name are generated according to the template field name of the report template;
The web page form and the tick boxes are shown in display interface.
In one embodiment, described program instruction is executed by processor to realize the template according to the report template
After field name generates the step of tick boxes for selecting the template field name, it is implemented as follows step:
Obtain the number of clicks of the tick boxes;
Putting in order for the tick boxes is determined according to the number of clicks;
The tick boxes are arranged according to described put in order.
The computer readable storage medium can be USB flash disk, mobile hard disk, read-only memory (ROM, Read-
OnlyMemory), the various media that can store program code such as magnetic or disk.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware
With the interchangeability of software, each exemplary composition and step are generally described according to function in the above description.This
A little functions are implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Specially
Industry technical staff can use different methods to achieve the described function each specific application, but this realization is not
It is considered as beyond the scope of this invention.It is apparent to those skilled in the art that for convenience of description and simple
Clean, the device of foregoing description and the specific work process of unit can refer to corresponding processes in the foregoing method embodiment, herein
It repeats no more.
In several embodiments provided by the present invention, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary.For example, the division of each unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation.Such as more than one unit or assembly can
To combine or be desirably integrated into another system, or some features can be ignored or not executed.
The steps in the embodiment of the present invention can be sequentially adjusted, merged and deleted according to actual needs.This hair
Unit in bright embodiment device can be combined, divided and deleted according to actual needs.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and when sold or used as an independent product,
It can store in a computer readable storage medium.Based on this understanding, technical solution of the present invention substantially or
Person says that all or part of the part that contributes to existing technology or the technical solution can body in the form of software products
Reveal and, which is stored in a storage medium, including some instructions are with so that a computer is set
Standby (can be personal computer, terminal or the network equipment etc.) execute each embodiment the method for the present invention whole or
Part steps.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can readily occur in various equivalent modifications or replace
It changes, these modifications or substitutions should be covered by the protection scope of the present invention.Therefore, protection scope of the present invention should be with right
It is required that protection scope subject to.
Claims (10)
1. a kind of report file generation method, which is characterized in that including:
Obtain the authority information of active user;
The type of the corresponding report template of report file generated needed for being obtained according to the authority information;
List data is obtained according to the type of the report template;
The list data is filled to the report template, to generate report file.
2. the method as described in claim 1, which is characterized in that the authority information for obtaining active user, including:
Obtain the corresponding user identifier of active user;
According to the user identifier and preset permissions mapping table, the authority information of active user is obtained.
3. the method as described in claim 1, which is characterized in that the list data includes data field name and data field
Value, it is described that list data is obtained according to the type of the report template, including:
The corresponding template field name of report template is obtained according to the type of the report template;
It obtains and the matched data field name of the template field famous prime minister;
Data field value is obtained according to the data field name.
4. the method as described in claim 1, which is characterized in that it is described to fill the list data to the report template,
After generating report file, further include:
The report file is converted into html file;
The html file is parsed, to generate web page form;
The tick boxes for selecting the template field name are generated according to the template field name of the report template;
The web page form and the tick boxes are shown in display interface.
5. method as claimed in claim 4, which is characterized in that described generated according to the template field name of the report template is used
After the tick boxes for selecting the template field name, further include:
Obtain the number of clicks of the tick boxes;
Putting in order for the tick boxes is determined according to the number of clicks;
The tick boxes are arranged according to described put in order.
6. a kind of report file generating means, which is characterized in that described device includes:
Authority acquiring unit, for obtaining the authority information of active user;
First acquisition unit, the class of the corresponding report template of report file for being generated needed for being obtained according to the authority information
Type;
Second acquisition unit, for obtaining list data according to the type of the report template;
First generation unit, for filling the list data to the report template, to generate report file.
7. device as claimed in claim 6, which is characterized in that the authority acquiring unit includes:
Third acquiring unit, for obtaining the corresponding user identifier of active user;
4th acquiring unit, for obtaining the power of active user according to the user identifier and preset permissions mapping table
Limit information.
8. device as claimed in claim 6, which is characterized in that the second acquisition unit includes:
5th obtains unit, for obtaining the corresponding template field name of report template according to the type of the report template;
6th acquiring unit, for obtaining and the matched data field name of the template field famous prime minister;
7th acquiring unit, for obtaining data field value according to the data field name.
9. a kind of computer equipment, including memory, processor and it is stored on the memory and can be on the processor
The computer program of operation, which is characterized in that the processor is realized when executing described program as any in claim 1 to 5
The report file generation method of item.
10. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has computer journey
Sequence, the computer program include program instruction, and described program instruction executes the processor such as
The described in any item report file generation methods of claim 1-5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810500758.XA CN108874760B (en) | 2018-05-23 | 2018-05-23 | Report file generation method, report file generation device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810500758.XA CN108874760B (en) | 2018-05-23 | 2018-05-23 | Report file generation method, report file generation device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108874760A true CN108874760A (en) | 2018-11-23 |
CN108874760B CN108874760B (en) | 2023-08-11 |
Family
ID=64333081
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810500758.XA Active CN108874760B (en) | 2018-05-23 | 2018-05-23 | Report file generation method, report file generation device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108874760B (en) |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109584091A (en) * | 2018-12-12 | 2019-04-05 | 泰康保险集团股份有限公司 | Insure the generation method and device of image file |
CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技(中国)有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
CN109858001A (en) * | 2019-01-11 | 2019-06-07 | 平安科技(深圳)有限公司 | A kind of report form generation method, system, electronic equipment and medium |
CN109920506A (en) * | 2019-01-23 | 2019-06-21 | 平安科技(深圳)有限公司 | Medical care statistics report-generating method, device, equipment and storage medium |
CN110059305A (en) * | 2019-03-04 | 2019-07-26 | 广州市辉海计算机科技有限公司 | Method and apparatus derived from data |
CN110532533A (en) * | 2019-07-10 | 2019-12-03 | 平安科技(深圳)有限公司 | Table precision configuration method, device, computer equipment and storage medium |
CN110750972A (en) * | 2019-08-30 | 2020-02-04 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Scheduling report information acquisition method and system |
CN110807056A (en) * | 2019-10-28 | 2020-02-18 | 长城计算机软件与系统有限公司 | Excel-based report processing method, Excel-based report processing device, Excel-based report processing medium and electronic equipment |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN111191429A (en) * | 2019-09-27 | 2020-05-22 | 深圳逻辑汇科技有限公司 | System and method for automatic filling of data table |
CN111460773A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Data processing method, device and system, electronic equipment and storage medium |
CN112632165A (en) * | 2020-12-22 | 2021-04-09 | 平安普惠企业管理有限公司 | Page form export EXCEL method and device, computer equipment and storage medium |
CN113761856A (en) * | 2021-01-21 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Data processing method and device |
CN116091015A (en) * | 2023-04-07 | 2023-05-09 | 中瑞方胜人力资源科技(北京)有限公司 | Payroll system, payroll method, electronic device, and storage medium |
CN117113960A (en) * | 2023-09-05 | 2023-11-24 | 北京数聚智连科技股份有限公司 | Method and device for generating service data form, electronic equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101166118A (en) * | 2007-09-30 | 2008-04-23 | 华为技术有限公司 | A method for processing user configuration information and service report system |
CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
CN107977351A (en) * | 2017-12-28 | 2018-05-01 | 平安科技(深圳)有限公司 | Electronic report forms generation method, device, computer equipment and storage medium |
-
2018
- 2018-05-23 CN CN201810500758.XA patent/CN108874760B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101166118A (en) * | 2007-09-30 | 2008-04-23 | 华为技术有限公司 | A method for processing user configuration information and service report system |
CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
CN107977351A (en) * | 2017-12-28 | 2018-05-01 | 平安科技(深圳)有限公司 | Electronic report forms generation method, device, computer equipment and storage medium |
Cited By (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109584091A (en) * | 2018-12-12 | 2019-04-05 | 泰康保险集团股份有限公司 | Insure the generation method and device of image file |
CN109584091B (en) * | 2018-12-12 | 2021-04-20 | 泰康保险集团股份有限公司 | Generation method and device of insurance image file |
CN109766534B (en) * | 2018-12-19 | 2021-04-16 | 益萃网络科技(中国)有限公司 | Report generation method and device, computer equipment and readable storage medium |
CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技(中国)有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
CN109858001A (en) * | 2019-01-11 | 2019-06-07 | 平安科技(深圳)有限公司 | A kind of report form generation method, system, electronic equipment and medium |
CN109920506A (en) * | 2019-01-23 | 2019-06-21 | 平安科技(深圳)有限公司 | Medical care statistics report-generating method, device, equipment and storage medium |
CN109920506B (en) * | 2019-01-23 | 2024-03-08 | 平安科技(深圳)有限公司 | Medical statistics report generation method, device, equipment and storage medium |
CN110059305A (en) * | 2019-03-04 | 2019-07-26 | 广州市辉海计算机科技有限公司 | Method and apparatus derived from data |
CN110532533A (en) * | 2019-07-10 | 2019-12-03 | 平安科技(深圳)有限公司 | Table precision configuration method, device, computer equipment and storage medium |
CN110532533B (en) * | 2019-07-10 | 2024-05-07 | 平安科技(深圳)有限公司 | Form precision collocation method, device, computer equipment and storage medium |
CN110750972A (en) * | 2019-08-30 | 2020-02-04 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Scheduling report information acquisition method and system |
CN111191429A (en) * | 2019-09-27 | 2020-05-22 | 深圳逻辑汇科技有限公司 | System and method for automatic filling of data table |
CN110807056A (en) * | 2019-10-28 | 2020-02-18 | 长城计算机软件与系统有限公司 | Excel-based report processing method, Excel-based report processing device, Excel-based report processing medium and electronic equipment |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN111460773A (en) * | 2020-03-30 | 2020-07-28 | 京东数字科技控股有限公司 | Data processing method, device and system, electronic equipment and storage medium |
CN112632165A (en) * | 2020-12-22 | 2021-04-09 | 平安普惠企业管理有限公司 | Page form export EXCEL method and device, computer equipment and storage medium |
CN113761856A (en) * | 2021-01-21 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Data processing method and device |
CN116091015A (en) * | 2023-04-07 | 2023-05-09 | 中瑞方胜人力资源科技(北京)有限公司 | Payroll system, payroll method, electronic device, and storage medium |
CN117113960A (en) * | 2023-09-05 | 2023-11-24 | 北京数聚智连科技股份有限公司 | Method and device for generating service data form, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108874760B (en) | 2023-08-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108874760A (en) | Report file generation method, device, computer equipment and storage medium | |
CN108363602B (en) | Intelligent UI (user interface) layout method and device, terminal equipment and storage medium | |
CN109683953B (en) | Method and device for processing configuration file based on visual interface | |
WO2017088509A1 (en) | Page customization method and device | |
CN110597511B (en) | Page automatic generation method, system, terminal equipment and storage medium | |
CN107977351A (en) | Electronic report forms generation method, device, computer equipment and storage medium | |
US20110302267A1 (en) | Web Site Implementation by Mapping Expression Evaluation | |
CN106990970B (en) | MVC-based dynamic page generation method and system | |
CN107562459B (en) | Management system, interface generating/displaying/operating method, medium, and terminal | |
CN113076104A (en) | Page generation method, device, equipment and storage medium | |
CN108279882B (en) | Framework generation method, device, equipment and computer readable medium | |
Bahar et al. | An interactive website for analytical method comparison and bias estimation | |
CN108875048B (en) | Report generation method and device, electronic equipment and readable storage medium | |
CN111061464A (en) | Analysis code generation method, device, equipment and storage medium | |
CN114035793A (en) | Page generation method, page generation device, equipment and storage medium | |
US20130218933A1 (en) | Consistent selective sub-hierarchical serialization and node mapping | |
CN112114787A (en) | Report generation method and device and storage medium | |
CN110704394B (en) | Report configuration modification method and device | |
CN115328759A (en) | Form verification method and device | |
CN106933552B (en) | Data processing method and front-end code generating device | |
CN114491354A (en) | Page generation method and device and computer readable storage medium | |
CN109582654A (en) | PDF document compression method, device, computer equipment and storage medium | |
CN107562461B (en) | Feature calculation system, feature calculation method, storage medium, and electronic device | |
CN116168403A (en) | Medical data classification model training method, classification method, device and related medium | |
CN115577689A (en) | Table component generation method, device, equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |