CN107329944A - Report form generation method, device and electronic equipment - Google Patents
Report form generation method, device and electronic equipment Download PDFInfo
- Publication number
- CN107329944A CN107329944A CN201710538787.0A CN201710538787A CN107329944A CN 107329944 A CN107329944 A CN 107329944A CN 201710538787 A CN201710538787 A CN 201710538787A CN 107329944 A CN107329944 A CN 107329944A
- Authority
- CN
- China
- Prior art keywords
- report
- detailed
- pattern
- progress
- daily paper
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The present invention provides a kind of report form generation method, device and electronic equipment, and this method includes：Inquiry database obtains report data corresponding with the mission bit stream obtained, is stored with different data structures；The detailed pattern of multiple forms and multiple form progress patterns are set；The detailed form of daily paper is set, report data subregion is write to different detailed cells, form detail pattern corresponding with each detailed cell is chosen respectively from the detailed pattern of multiple forms；Daily paper progress report is set, report data subregion is write into different scheduling unit lattice, form progress pattern corresponding with each scheduling unit lattice is chosen respectively from multiple form progress patterns.The report generation scheme is stored report data with different data structures by being taken on demand, reduces the inquiry of multilist connection table and I/O operation.And different patterns are set for each region, become apparent from processing logic.The report generation scheme can it is readability it is strong, the speed of service is fast and performance consumption is small.
Description
Technical field
The present invention relates to field of computer technology, set in particular to a kind of report form generation method, device and electronics
It is standby.
Background technology
Form is the instrument that a kind of conventional offer data are calculated and analyzed.In some enterprises or mechanism function, often need
Substantial amounts of form is used, such as bank, the tax bureau.Therefore the reporting system of automatic report generation arises at the historic moment.Existing skill
Report form processing mode often joins table inquiry mode using multilist in art, and inquiry velocity is slow, and there is report style confusion etc.
Problem.Therefore, urgently occurs a kind of efficient report form generation method at present.
The content of the invention
In view of this, it is an object of the invention to provide a kind of report form generation method, device and electronic equipment, with solution
State problem.
The embodiment of the present invention provides a kind of report form generation method, and methods described includes：
Inquiry database obtains report data corresponding with the mission bit stream obtained, and by the report data with different
Data structure is stored；
The detailed pattern of multiple forms and multiple form progress patterns are set；
The detailed form of daily paper is set, the report data subregion of storage is write to the difference of the detailed form of the daily paper
Detailed cell, choose form detail corresponding with each institute's manifest element lattice respectively from the detailed pattern of the multiple form
Pattern；
Daily paper progress report is set, the report data subregion of storage is write to the difference of the daily paper progress report
Scheduling unit lattice, choose form progress corresponding with each scheduling unit lattice respectively from the multiple form progress pattern
Pattern.
Further, the mission bit stream includes task ID and task name, and methods described also includes：
The task ID and the task name are stored with map structures, so that the daily paper progress report is called.
Further, the detailed form of the daily paper and the daily paper progress report are generated and shown by following steps：
Timing function is called to generate timed task program；
Process manager is configured, the timed task program operation port is set；
The timed task program is run regularly to generate the detailed form of the daily paper and the daily paper progress report；
The detailed form of the daily paper of generation and the daily paper progress report are shown.
Further, the report data includes user data, summary data and date array, and the setting daily paper is bright
Thin form, the report data subregion of storage is write the different detailed cells of the detailed form of the daily paper, from institute
The step of choosing form detail pattern corresponding with each institute's manifest element lattice respectively in the detailed pattern of multiple forms is stated, including：
The detailed form of daily paper is set, the detailed form of the daily paper is divided into multiple different detailed cells；
By in the corresponding user name write-in institute manifest element lattice of the user data, the corresponding seat of the user name is recorded
Scale value, and choose from the detailed pattern of the multiple form detailed report style corresponding with the detailed cell；
By the date write-in institute manifest element lattice in the date array, the date corresponding coordinate value is recorded,
And form detail pattern corresponding with the detailed cell is chosen from the detailed pattern of the multiple form；
According to the corresponding coordinate value of the user name and the date corresponding coordinate value, the summary number of the user is found
According to coordinate value, and the summary data is write into the corresponding detailed cell of the coordinate value, and detailed from the multiple form
Form detail pattern corresponding with the detailed cell is chosen in pattern.
Further, the setting daily paper progress report, the daily paper is write by the report data subregion of storage
The different scheduling unit lattice of progress report, choose and each scheduling unit lattice respectively from the multiple form progress pattern
The step of corresponding form progress pattern, including：
Daily paper progress report is set, the daily paper progress report is divided into multiple different scheduling unit lattice；
The corresponding user name of the user data is write in the scheduling unit lattice, the corresponding seat of the user name is recorded
Scale value, and the selection progress report pattern corresponding with the scheduling unit lattice from the multiple form progress pattern；
Date in the date array is write into the scheduling unit lattice, the corresponding maximum of user under the date is found
It is time-consuming, the date corresponding coordinate value is recorded, and chosen and the scheduling unit lattice pair from the multiple form progress pattern
The progress report pattern answered；
According to the corresponding coordinate value of the user name, the date corresponding coordinate value and described maximum time-consuming acquisition use
The coordinate value of the summary data at family, and the summary data is write into the corresponding scheduling unit lattice of the coordinate value, and from described many
Progress report pattern corresponding with the scheduling unit lattice is chosen in individual form progress pattern.
Another embodiment of the present invention also provides a kind of report generation device, the report generation device include acquisition module,
Pattern setup module, the first setup module and the second setup module；
The acquisition module obtains report data corresponding with the mission bit stream obtained for inquiring about database, and will be described
Report data is stored with different data structures；
The pattern setup module is used to set the detailed pattern of multiple forms and multiple form progress patterns；
First setup module is used to set the detailed form of daily paper, and the report data subregion of storage is write into institute
The different detailed cells of the detailed form of daily paper are stated, are chosen and each detail respectively from the detailed pattern of the multiple form
The detailed pattern of the corresponding form of cell；
Second setup module is used to set daily paper progress report, and the report data subregion of storage is write into institute
The different scheduling unit lattice of daily paper progress report are stated, are chosen and each progress respectively from the multiple form progress pattern
The corresponding form progress pattern of cell.
Further, the mission bit stream includes task ID and task name, and the report generation device also includes storage mould
Block；
The memory module is used to be stored the task ID and the task name with map structures, for the day
Report program is called.
Further, the report generation device also includes calling module, configuration module, operation module and display mould
Block；
The calling module is used to call timing function to generate timed task program；
The configuration module is used to configure process manager, sets the timed task program operation port；
The operation module is used to running the timed task program regularly to generate the detailed form of the daily paper and described
Daily paper progress report；
The display module is used to be shown the detailed form of the daily paper of generation and the daily paper progress report.
Another embodiment of the present invention also provides a kind of electronic equipment, including：
Memory, be stored with the database including report data；
Processor；And
Report generation device, the report generation device is installed in the memory and including one or more by described
The software function module of computing device.
Another embodiment of the present invention also provides a kind of storage medium, is stored thereon with computer program, the computer journey
The step of above-mentioned report form generation method is realized when sequence is executed by processor.
Report form generation method provided in an embodiment of the present invention, device and electronic equipment, by being taken on demand, first by form number
It is investigated that finding out and being stored with different data structures, the inquiry of multilist connection table is reduced, and by setting different data knots
Structure is simultaneously prestored, and the report data that can be multiplexed can be used in the detailed form of daily paper and daily paper progress report, reduce IO
Operation.And report data is subjected to subregion write-in, is that each region sets different patterns, so that processing logic is more clear
It is clear.The report generation scheme that the present invention is provided can it is readability it is strong, the speed of service is fast and performance consumption is small.
To enable the above objects, features and advantages of the present invention to become apparent, preferred embodiment cited below particularly, and coordinate
Appended accompanying drawing, is described in detail below.
Brief description of the drawings
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below will be attached to what is used required in embodiment
Figure is briefly described, it will be appreciated that the following drawings illustrate only certain embodiments of the present invention, therefore is not construed as pair
The restriction of scope, for those of ordinary skill in the art, on the premise of not paying creative work, can also be according to this
A little accompanying drawings obtain other related accompanying drawings.
The schematic block diagram for a kind of electronic equipment that Fig. 1 provides for present pre-ferred embodiments.
A kind of flow chart for report form generation method that Fig. 2 provides for present pre-ferred embodiments.
The flow chart of step S105 sub-step in Fig. 3 Fig. 2.
The flow chart of step S107 sub-step in Fig. 4 Fig. 2.
Another flow chart for the report form generation method that Fig. 5 provides for present pre-ferred embodiments.
The functional block diagram for the report generation device that Fig. 6 provides for present pre-ferred embodiments.
Another functional block diagram for the report generation device that Fig. 7 provides for present pre-ferred embodiments.
Icon：100- electronic equipments；110- report generation devices；111- acquisition modules；112- pattern setup modules；113-
First setup module；The setup modules of 114- second；115- memory modules；116- calling modules；117- configuration modules；118- is run
Module；119- display modules；120- processors；130- memories.
Embodiment
Below in conjunction with accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Ground is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.Generally exist
The component of the embodiment of the present invention described and illustrated in accompanying drawing can be arranged and designed with a variety of configurations herein.Cause
This, the detailed description of the embodiments of the invention to providing in the accompanying drawings is not intended to limit claimed invention below
Scope, but it is merely representative of the selected embodiment of the present invention.Based on embodiments of the invention, those skilled in the art are not doing
The every other embodiment obtained on the premise of going out creative work, belongs to the scope of protection of the invention.
It should be noted that：Similar label and letter represents similar terms in following accompanying drawing, therefore, once a certain Xiang Yi
It is defined in individual accompanying drawing, then it further need not be defined and explained in subsequent accompanying drawing.Meanwhile, the present invention's
In description, unless otherwise clearly defined and limited, term " installation ", " setting ", " connection " should be interpreted broadly, for example, can
To be to be fixedly connected or be detachably connected, or it is integrally connected；Can be mechanical connection or electrical connection；Can
It to be to be joined directly together, can also be indirectly connected to by intermediary, can be the connection of two element internals.For this area
For those of ordinary skill, the concrete meaning of above-mentioned term in the present invention can be understood with concrete condition.
Referring to Fig. 1, being the schematic block diagram of a kind of electronic equipment 100 provided in an embodiment of the present invention.In this reality
Apply in example, the electronic equipment 100 includes report generation device 110, processor 120 and memory 130.Wherein, the storage
Direct or indirect electric connection between device 130 and the processor 120, to realize the transmission or interaction of data.The form
Generating means 110 can be stored in the memory 130 or be solidificated in including at least one described in the form of software or firmware
Software function module in the operating system of electronic equipment 100.The processor 120 is used to perform to deposit in the memory 130
The executable module of storage, such as software function module or computer program that described report generation device 110 includes.
Referring to Fig. 2, being a kind of report form generation method applied to above-mentioned electronic equipment 100 provided in an embodiment of the present invention
Flow chart.It should be noted that, the method that the present invention is provided is not using Fig. 2 and particular order as described below as limitation.Below
Each step shown in Fig. 2 will be described in detail.
Step S101, inquiry database obtains the corresponding report data of mission bit stream with acquisition, and by the form number
Data structures different according to this are stored.
Step S103, sets the detailed pattern of multiple forms and multiple form progress patterns.
When implementing, for report generation work firstly the need of the task that creates, the mission bit stream of the task includes task
ID and task name, mark this report generation to work with task ID and task name.Also, by task ID and task name with map
Structure is stored, so that subsequent processes can be directly invoked, and to reduce I/O operation, improves operational efficiency.
Report data content in form is the core content in reporting system.Report data source is varied, can be with
Inputted by user, database can also be derived from, could also be from data file or other systems.The mission bit stream, which is carried, to be needed
Information is sought, that is, creates the report data information needed for form.In the present embodiment, data are prestored in the electronic equipment 100
Storehouse, the database preserves multiclass report data.After mission bit stream is obtained, the demand information that can be carried according to mission bit stream is looked into
The database is ask to obtain report data corresponding with the mission bit stream.Alternatively, in the present embodiment, the report data
Can include grouped data group Temps, packet associated data user group Temps, user data user Temps,
Meet the summary data summarys and date array monthDays of querying condition.Wherein, user data user Temps include
User name and the corresponding ID of user name.
In the present embodiment, different data structures can be set according to different demands, the form number that inquiry is obtained
Data structures different according to this are stored.For example, a group item screening can be carried out, grouped data is stored in groups arrays, will be reported
Table data are converted to the map structures deposit usersId using Id as key assignments, or are converted to the map structures deposit using OaUid as key assignments
usersOId.Date array is converted into DateWeek Array for structural body monthDays.Alternatively, in the present embodiment, it is necessary to
It is default that the detailed pattern of form and form progress pattern are set.Alternatively, with reference to excel own characteristics, set multiple forms detailed
Pattern and multiple form progress patterns.For example, the detailed pattern 1,2,3,4 of settable form, and form progress pattern 1,2,3,
4.It should be appreciated that the detailed pattern of the form set in the present embodiment and form progress pattern can be expanded according to the actual requirements
Exhibition, the present embodiment is simultaneously not specifically limited.In the present embodiment, the detailed pattern of form and form progress pattern are set,
Detail of the user in terms of the form of expression and page formatting can be met.Form is carried out in the coding phase by the pattern of determination to open
Hair, need not or seldom oneself be gone to adjust or design in the later stage using middle user, and the operational capacity to user is required than relatively low, letter
It is single easy-to-use.
Step S105, sets the detailed form of daily paper, and it is detailed that the report data subregion of storage is write into the daily paper
The different detailed cells of form, choose corresponding with each institute's manifest element lattice respectively from the detailed pattern of the multiple form
The detailed pattern of form.
Alternatively, referring to Fig. 3, in the present embodiment, step S105 can include step S1051, step S1053, step
Rapid S1055 and the sub-steps of step S1057 tetra-.
Step S1051, sets the detailed form of daily paper, and the detailed form of the daily paper is divided into multiple different detailed units
Lattice.
Step S1053, the corresponding user name of the user data is write in institute's manifest element lattice, the user is recorded
The corresponding coordinate value of name, and choose from the detailed pattern of the multiple form form detail sample corresponding with the detailed cell
Formula.
In the present embodiment, the detailed form of daily paper is divided into multiple different detailed cells in advance, to different bright
Thin cell is using the way to manage divided and rule.Alternatively, in the present embodiment, the grouped data group is traveled through
The Temps and packet associated data user group Temps, selects the user data under correspondence group item, and by the user
In detailed cell in multiple detailed cells that the corresponding user name of data and group name write-in are marked off, and record
The corresponding coordinate value map nameXY of the user name, i.e., using userName as key, the corresponding coordinate of user name is value deposit map's
In nameXY.In addition, before user name write-in is carried out, it is necessary first to which whether the corresponding detailed cell of checking is empty, if
It is empty then write user name corresponding in empty detailed cell.It should be appreciated that in the present embodiment, the user of selected taking-up
Data can also be the corresponding user data of multiple users, in that case, by the corresponding multiple user's statuses of user data
Do not write in multiple detailed cells, and record the coordinate value of the corresponding detailed cell of each user name.
Alternatively, in the present embodiment, the detailed pattern of corresponding form is set to write the detailed cell of user name.Can
Selection of land, chooses form corresponding with the detailed cell of write-in user name bright from the detailed pattern of the multiple forms set
The detailed pattern 1 of thin pattern, such as form.
Step S1055, institute's manifest element lattice are write by the date in the date array, record the date correspondence
Coordinate value, and choose from the detailed pattern of the multiple form form detail pattern corresponding with the detailed cell.
Step S1057, according to the corresponding coordinate value of the user name and the date corresponding coordinate value, finds the use
The coordinate value of the summary data at family, and the summary data is write into the corresponding detailed cell of the coordinate value, and from described many
Form detail pattern corresponding with the detailed cell is chosen in the detailed pattern of individual form.
In the present embodiment, the date array monthDays is traveled through, by the day in the date array monthDays
One or more of multiple detailed cells that phase write-in division is obtained detailed cell, and record date corresponding seat
Scale value map dateXY, for example, using Date as key, the corresponding coordinates of Date are stored in the DateXY of map structures for value.And from setting
The detailed pattern of form corresponding with the detailed cell for writing the date is chosen in the detailed pattern of good multiple forms, such as form is bright
Thin pattern 2.
The summary data summarys is traveled through, and according to the corresponding coordinate value map nameXY of the user name recorded
And date corresponding coordinate value map dateXY find the corresponding coordinate value of summary data, such as according to userOId
[s.Uid] obtains the corresponding coordinate value of user name, and date corresponding coordinate value is obtained according to s.LogTime.By summary data
In the corresponding detailed cell of coordinate value that finds of summarys slittings write-in, and stored, for example with
RequirementId is key, and the entitled value of task is stored in the requirementNameM of map structures.And be write-in summary data
Detailed cell the detailed pattern of corresponding form, the detailed pattern 3 of such as form are set.In addition, in the specific implementation, also taking an examination
Consider may default summary data situation.Therefore, nameXY arrays and DateXY arrays can be traveled through, corresponding detail form is searched
Whether summary data is had been written into first lattice, if default summary data part, write the printed words " do not handed over " for example to corresponding bright
In thin cell, and the detailed pattern of corresponding form, the detailed pattern 4 of such as form are set for the detailed cell.So far, daily paper
The product process of detailed form terminates.
Step S107, sets daily paper progress report, and the report data subregion of storage is write into the daily paper progress
The different scheduling unit lattice of form, choose corresponding with each scheduling unit lattice respectively from the multiple form progress pattern
Form progress pattern.
Alternatively, referring to Fig. 4, in the present embodiment, step S107 can include step S1071, step S1073, step
Rapid S1075 and the sub-steps of step S1077 tetra-.
Step S1071, sets daily paper progress report, the daily paper progress report is divided into multiple different scheduling units
Lattice.
Step S1073, the corresponding user name of the user data is write in the scheduling unit lattice, the user is recorded
The corresponding coordinate value of name, and the selection progress report sample corresponding with the scheduling unit lattice from the multiple form progress pattern
Formula.
In the present embodiment, daily paper progress report is divided into multiple different scheduling unit lattice in advance, similarly, to difference
Scheduling unit lattice using the way to manage divided and rule.Alternatively, in the present embodiment, the grouped data group is traveled through
The Temps and packet associated data user group Temps, selects the user data under correspondence group item.By the user selected
One or more of multiple scheduling unit lattice that the corresponding user name write-in of data is marked off scheduling unit lattice.And it is write-in
The scheduling unit lattice of user name set form progress pattern.Alternatively, can be from the multiple form progress patterns pre-set
Choose, for example, may be configured as form progress pattern 1.Also, record the corresponding coordinate value map nameXYPlan of user name, example
Such as using userName as key, the corresponding coordinate of user name is stored in map nameXYPlan for value.Alternatively, in the present embodiment
The ID counted will be needed to be stored in user's array nameOauidString of unified slice structures, so as to follow-up direct
Call.Also, the corresponding group name of user is written in corresponding scheduling unit lattice, and form progress pattern 1 is set.It should manage
Solution, before user name write-in is carried out, it is necessary first to which whether be empty, if it is empty then carry out user if verifying corresponding scheduling unit lattice
The action of name write-in.
Step S1075, writes the scheduling unit lattice by the date in the date array, finds user under the date
It is corresponding maximum time-consuming, the date corresponding coordinate value is recorded, and choose to enter with this from the multiple form progress pattern
Spend the corresponding progress report pattern of cell.
Step S1077, according to the corresponding coordinate value of the user name, the date corresponding coordinate value and the maximum consumption
When obtain the user summary data coordinate value, and the summary data is write into the corresponding scheduling unit lattice of the coordinate value,
And progress report pattern corresponding with the scheduling unit lattice is chosen from the multiple form progress pattern.
Alternatively, in the present embodiment, inverted order travels through the date array monthDays, according to user's array
NameOauidString and date date, finds user in user's array nameOauidString under the date most
Take greatly, i.e. maximum functional duration.Date in the date array monthDays (is refine to the maximum that finds out to take
Hourage) write-in divided in one or more of obtained multiple scheduling unit lattice scheduling unit lattice.And record day
Phase corresponding coordinate value map DateXYPlan, for example, using Date as key, the corresponding coordinates of Date are value deposit map structures
DateXYPlan.And form corresponding with the scheduling unit lattice for writing the date is chosen from the multiple form progress patterns set
Progress pattern, such as form progress pattern 2.
The summary data is traveled through, and according to the corresponding coordinate value map nameXYPlan of the user name recorded, date
Corresponding coordinate value map DateXYPlan and the maximum found out take and find the corresponding coordinate of summary data, i.e. basis
UserOId [s.Uid] obtains the corresponding coordinate value of user name, and date corresponding coordinate value is obtained according to s.LogTime.And by institute
Summary data slitting is stated to write in the corresponding scheduling unit lattice of the coordinate, such as using name+date as key, DateUserH structures
Body is stored in the userDateMap of map structures for value.And the scheduling unit lattice for write-in summary data set form progress pattern,
It for example may be configured as form progress pattern 3.Meanwhile, can be by changing the values of DateUserH structures, so as to different demands
Color pattern is controlled.
In addition, in the specific implementation, it is also contemplated that may default summary data situation.Therefore, it can travel through
NameXYPlan arrays and DateXYPlan arrays, search in corresponding scheduling unit lattice whether have been written into summary data, if lacking
Summary data part is saved, then writes the printed words " do not handed over " for example into corresponding scheduling unit lattice, and is set for the scheduling unit lattice
Put corresponding form progress pattern, such as form progress pattern 4.So far, the product process of daily paper progress report terminates.
In the present embodiment, time management can be carried out to the generation and display of the detailed form of daily paper and daily paper progress report,
Alternatively, referring to Fig. 5, the generation and display of the daily paper detail form and the daily paper progress report can be held according to the following steps
OK：
Step S201, calls timing function to generate timed task program.
Step S203, configures process manager, sets the timed task program operation port.
Step S205, runs the timed task program regularly to generate the detailed form of the daily paper and the daily paper progress
Form.
Step S207, the detailed form of the daily paper of generation and the daily paper progress report are shown.
Alternatively, in the present embodiment, locked using (cron/sync/runtime) in go language with timing control processing procedure
The run time of sequence, such as by program runtime control in 6 points of every afternoon.On linux, in version synchronization to most
Newest code is pulled after redaction, the timed task of the detailed form of export daily paper and daily paper progress report is carried out setting up it
Afterwards, generation timed task Programm yncProgram.Process manager Supervisor is configured on linux machines, and institute is set
State the port of timed task program operation and other configuration informations.The timed task program can be run regularly to generate institute
State the detailed form of daily paper and the daily paper progress report.
After timing generates the detailed form of corresponding daily paper and daily paper progress report, backstage code can run aobvious to provide
Show the detailed form of daily paper and daily paper progress report that interface has been generated to show, so that administrative staff are downloaded and use.
Referring to Fig. 6, being a kind of functional block diagram of report generation device 110 provided in an embodiment of the present invention.It is described
Report generation device 110 includes acquisition module 111, pattern setup module 112, the first setup module 113 and second and sets mould
Block 114.
The acquisition module 111 obtains report data corresponding with the mission bit stream obtained for inquiring about database, and will
The report data is stored with different data structures.Specifically, the acquisition module 111 can be used for performing shown in Fig. 2
Step S101, specific operating method refers to step S101 detailed description.
The pattern setup module 112 is used to set the detailed pattern of multiple forms and multiple form progress patterns.Specifically,
The pattern setup module 112 can be used for performing the step S103 shown in Fig. 2, and specific operating method refers to step S103's
It is described in detail.
First setup module 113 is used to set the detailed form of daily paper, and the report data subregion of storage is write
Enter the different detailed cells of the detailed form of the daily paper, chosen respectively from the detailed pattern of the multiple form with it is each described
The detailed pattern of the corresponding form of detailed cell.Specifically, first setup module 113 can be used for performing the step shown in Fig. 2
Rapid S105, specific operating method refers to step S105 detailed description.
Second setup module 114 is used to set daily paper progress report, and the report data subregion of storage is write
Enter the different scheduling unit lattice of the daily paper progress report, from the multiple form progress pattern respectively choose with it is each described
The corresponding form progress pattern of scheduling unit lattice.Specifically, second setup module 114 can be used for performing the step shown in Fig. 2
Rapid S107, specific operating method refers to step S107 detailed description.
Alternatively, in the present embodiment, the mission bit stream includes task ID and task name, the report generation device
110 also include memory module 115.The memory module 115 is used to carry out the task ID and the task name with map structures
Storage, so that the daily paper program is called.
Alternatively, referring to Fig. 7, in the present embodiment, the report generation device 110 also includes calling module 116, matched somebody with somebody
Put module 117, operation module 118 and display module 119.
The calling module 116 is used to call timing function to generate timed task program.Specifically, the calling module 116
Available for the step S201 performed shown in Fig. 5, specific operating method refers to step S201 detailed description.
The configuration module 117 is used to configure process manager, sets the timed task program operation port.Specifically
Ground, the configuration module 117 can be used for performing the step S203 shown in Fig. 5, and specific operating method refers to step S203's
It is described in detail.
The operation module 118 is used to run the timed task program regularly to generate the detailed form of the daily paper and institute
State daily paper progress report.Specifically, the operation module 118 can be used for performing the step S205 shown in Fig. 5, specific operation side
Method refers to step S205 detailed description.
The display module 119 is used to be shown the detailed form of the daily paper of generation and the daily paper progress report
Show.Specifically, the display module 119 can be used for performing the step S207 shown in Fig. 5, and specific operating method refers to step
S207 detailed description.
In addition, another preferred embodiment of the invention also provides a kind of storage medium, computer program is stored thereon with, it is described
Computer program realizes above-mentioned report form generation method when being performed by processor 120 the step of.
In summary, the present invention provides a kind of report form generation method, device and electronic equipment, is obtained by inquiring about database
Report data corresponding with the mission bit stream of acquisition, and report data is stored with different data structures.Pre-set
The detailed pattern of multiple forms and multiple form progress patterns, the detailed form of daily paper is write not by the report data subregion of storage
With detailed cell in, and choose from the detailed pattern of multiple forms form detail sample corresponding with each detailed cell respectively
Formula.Also, in the different scheduling unit lattice that the report data subregion of storage is write to daily paper progress report, and from multiple reports
Form progress pattern corresponding with each scheduling unit lattice is chosen in table progress pattern respectively.The report generation scheme that the present invention is provided
By being taken on demand, first report data is found out and stored with different data structures, reduce the inquiry of multilist connection table,
And by setting different data structures and being prestored, the report data that can be multiplexed can enter in the detailed form of daily paper and daily paper
Used in degree form, reduce I/O operation.And report data is subjected to subregion write-in, is that each region sets different samples
Formula, so that processing logic becomes apparent from.The report generation scheme can it is readability it is strong, the speed of service is fast and performance consumption is small.
, can also be by other in embodiment provided herein, it should be understood that disclosed apparatus and method
Mode realize.Device embodiment described above is only schematical, for example, the flow chart and block diagram in accompanying drawing are shown
Devices in accordance with embodiments of the present invention, architectural framework in the cards, function and the behaviour of method and computer program product
Make.At this point, each square frame in flow chart or block diagram can represent a part for a module, program segment or code, institute
The part for stating module, program segment or code includes one or more executable instructions for being used to realize defined logic function.
It should also be noted that in some implementations as replacement, the function of being marked in square frame can also be with different from accompanying drawing
The order marked occurs.For example, two continuous square frames can essentially be performed substantially in parallel, they sometimes can also be by
Opposite order is performed, and this is depending on involved function.It is also noted that each square frame in block diagram and/or flow chart,
And the combination of the square frame in block diagram and/or flow chart, can be with function or action as defined in performing it is special based on hardware
System realize, or can be realized with the combination of specialized hardware and computer instruction.
It should be noted that herein, term " comprising ", "comprising" or its any other variant are intended to non-row
His property is included, so that process, method, article or equipment including a series of key elements not only include those key elements, and
And also including other key elements being not expressly set out, or also include for this process, method, article or equipment institute inherently
Key element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that including institute
Also there is other identical element in process, method, article or the equipment of stating key element.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.It should be noted that：Similar label and letter exists
Similar terms is represented in following accompanying drawing, therefore, once being defined in a certain Xiang Yi accompanying drawing, is then not required in subsequent accompanying drawing
It is further defined and explained.
The foregoing is only a specific embodiment of the invention, but protection scope of the present invention is not limited thereto, any
Those familiar with the art the invention discloses technical scope in, change or replacement can be readily occurred in, should all be contained
Cover within protection scope of the present invention.Therefore, protection scope of the present invention should be based on the protection scope of the described claims.
Claims (10)
1. a kind of report form generation method, it is characterised in that methods described includes：
Inquiry database obtains report data corresponding with the mission bit stream obtained, and by the report data with different data
Structure is stored；
The detailed pattern of multiple forms and multiple form progress patterns are set；
The detailed form of daily paper is set, the report data subregion of storage is write into the different bright of the detailed form of the daily paper
Thin cell, chooses the detailed sample of form corresponding with each institute's manifest element lattice respectively from the detailed pattern of the multiple form
Formula；
Daily paper progress report is set, and the report data subregion of storage is write into the different of daily paper progress report enters
Cell is spent, form progress sample corresponding with each scheduling unit lattice is chosen respectively from the multiple form progress pattern
Formula.
2. report form generation method according to claim 1, it is characterised in that the mission bit stream includes task ID and task
Name, methods described also includes：
The task ID and the task name are stored with map structures, so that the daily paper progress report is called.
3. report form generation method according to claim 1, it is characterised in that the detailed form of the daily paper and the daily paper enter
Form is spent to generate and show by following steps：
Timing function is called to generate timed task program；
Process manager is configured, the timed task program operation port is set；
The timed task program is run regularly to generate the detailed form of the daily paper and the daily paper progress report；
The detailed form of the daily paper of generation and the daily paper progress report are shown.
4. report form generation method according to claim 1, it is characterised in that the report data includes user data, total
Data and date array are tied, the report data subregion of storage is write the day by the detailed form of the setting daily paper
The different detailed cells of the detailed form of report, choose and each institute's manifest element respectively from the detailed pattern of the multiple form
The step of corresponding form of lattice detailed pattern, including：
The detailed form of daily paper is set, the detailed form of the daily paper is divided into multiple different detailed cells；
By in the corresponding user name write-in institute manifest element lattice of the user data, the corresponding coordinate of the user name is recorded
Value, and choose from the detailed pattern of the multiple form form detail pattern corresponding with the detailed cell；
By the date write-in institute manifest element lattice in the date array, the date corresponding coordinate value is recorded, and from
Form detail pattern corresponding with the detailed cell is chosen in the detailed pattern of the multiple form；
According to the corresponding coordinate value of the user name and the date corresponding coordinate value, the summary data of the user is found
Coordinate value, and the summary data is write into the corresponding detailed cell of the coordinate value, and from the detailed pattern of the multiple form
Middle selection form detail pattern corresponding with the detailed cell.
5. report form generation method according to claim 4, it is characterised in that the setting daily paper progress report, will be stored
The report data subregion write the different scheduling unit lattice of the daily paper progress report, from the multiple form progress
The step of form progress pattern corresponding with each scheduling unit lattice being chosen in pattern respectively, including：
Daily paper progress report is set, the daily paper progress report is divided into multiple different scheduling unit lattice；
The corresponding user name of the user data is write in the scheduling unit lattice, the corresponding coordinate of the user name is recorded
Value, and the selection progress report pattern corresponding with the scheduling unit lattice from the multiple form progress pattern；
Date in the date array is write into the scheduling unit lattice, the corresponding maximum consumption of user under the date is found
When, the date corresponding coordinate value is recorded, and choose corresponding with the scheduling unit lattice from the multiple form progress pattern
Progress report pattern；
According to the corresponding coordinate value of the user name, the date corresponding coordinate value and the maximum time-consuming acquisition user
The coordinate value of summary data, and the summary data is write into the corresponding scheduling unit lattice of the coordinate value, and from the multiple report
Progress report pattern corresponding with the scheduling unit lattice is chosen in table progress pattern.
6. a kind of report generation device, it is characterised in that the report generation device include acquisition module, pattern setup module,
First setup module and the second setup module；
The acquisition module is used to inquiring about database and obtains the corresponding report data of mission bit stream with acquisition, and by the form
Data are stored with different data structures；
The pattern setup module is used to set the detailed pattern of multiple forms and multiple form progress patterns；
First setup module is used to set the detailed form of daily paper, and the report data subregion of storage is write into the day
The different detailed cells of the detailed form of report, choose and each institute's manifest element respectively from the detailed pattern of the multiple form
The detailed pattern of the corresponding form of lattice；
Second setup module is used to set daily paper progress report, and the report data subregion of storage is write into the day
The different scheduling unit lattice of progress report are reported, are chosen and each scheduling unit respectively from the multiple form progress pattern
The corresponding form progress pattern of lattice.
7. report generation device according to claim 6, it is characterised in that the mission bit stream includes task ID and task
Name, the report generation device also includes memory module；
The memory module is used to be stored the task ID and the task name with map structures, so that the daily paper enters
Degree table is called.
8. report generation device according to claim 6, it is characterised in that the report generation device also includes calling mould
Block, configuration module, operation module and display module；
The calling module is used to call timing function to generate timed task program；
The configuration module is used to configure process manager, sets the timed task program operation port；
The operation module is used to run the timed task program regularly to generate the detailed form of the daily paper and the daily paper
Progress report；
The display module is used to be shown the detailed form of the daily paper of generation and the daily paper progress report.
9. a kind of electronic equipment, it is characterised in that including：
Memory, be stored with the database including report data；
Processor；And
Report generation device, the report generation device is installed in the memory and including one or more by the processing
The software function module that device is performed.
10. a kind of storage medium, it is characterised in that be stored thereon with computer program, the computer program is held by processor
The step of report form generation method described in claim 1-5 any one is realized during row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710538787.0A CN107329944A (en) | 2017-07-04 | 2017-07-04 | Report form generation method, device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710538787.0A CN107329944A (en) | 2017-07-04 | 2017-07-04 | Report form generation method, device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107329944A true CN107329944A (en) | 2017-11-07 |
Family
ID=60195728
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710538787.0A Pending CN107329944A (en) | 2017-07-04 | 2017-07-04 | Report form generation method, device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107329944A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020099717A1 (en) * | 2001-01-24 | 2002-07-25 | Gordon Bennett | Method for report generation in an on-line transcription system |
| CN101847227A (en) * | 2009-03-24 | 2010-09-29 | 鸿富锦精密工业（深圳）有限公司 | Product test management system and method |
| CN102819564A (en) * | 2012-07-05 | 2012-12-12 | 无锡中科泛在信息技术研发中心有限公司 | Method for generating report forms by limited table element combination |
| CN103218448A (en) * | 2013-04-26 | 2013-07-24 | 中国农业银行股份有限公司 | Self-service report generating method, device and system |
| CN104240043A (en) * | 2014-10-10 | 2014-12-24 | 国家电网公司 | Full-service centralized management service platform for electric power customer service based on number 95598 |
| CN104951189A (en) * | 2015-07-08 | 2015-09-30 | 北京恒华伟业科技股份有限公司 | Scheme report generation method and device |
-
2017
- 2017-07-04 CN CN201710538787.0A patent/CN107329944A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020099717A1 (en) * | 2001-01-24 | 2002-07-25 | Gordon Bennett | Method for report generation in an on-line transcription system |
| CN101847227A (en) * | 2009-03-24 | 2010-09-29 | 鸿富锦精密工业（深圳）有限公司 | Product test management system and method |
| CN102819564A (en) * | 2012-07-05 | 2012-12-12 | 无锡中科泛在信息技术研发中心有限公司 | Method for generating report forms by limited table element combination |
| CN103218448A (en) * | 2013-04-26 | 2013-07-24 | 中国农业银行股份有限公司 | Self-service report generating method, device and system |
| CN104240043A (en) * | 2014-10-10 | 2014-12-24 | 国家电网公司 | Full-service centralized management service platform for electric power customer service based on number 95598 |
| CN104951189A (en) * | 2015-07-08 | 2015-09-30 | 北京恒华伟业科技股份有限公司 | Scheme report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Ellis et al. | Officetalk-D: An experimental office information system | |
| CN105487864B (en) | The method and apparatus of Code automatic build | |
| US20070240099A1 (en) | Flexible attribute management in workflow processing systems | |
| Kanoun et al. | Reliability growth of fault-tolerant software | |
| EP2738675B1 (en) | System and method for efficient resource management of a signal flow programmed digital signal processor code | |
| CN107544886A (en) | A kind of block process dispatching method and device | |
| US10860989B2 (en) | Support for maintenance of a fleet of vehicles with intuitive display of repair analytics | |
| CN108694448A (en) | PHM platforms | |
| Lastusilta | GAMS MINLP solver comparisons and some improvements to the AlphaECP algorithm | |
| Pillai et al. | Performance monitoring in R&D projects | |
| CN107329944A (en) | Report form generation method, device and electronic equipment | |
| CN101354760A (en) | System and method for operating non-linear non-fixed layer type work flow | |
| Bennett et al. | What Every Engineer Should Know about Microcomputers: Hardware/Software Design: a Step-by-step Example | |
| CN110471730A (en) | Methods of exhibiting, system, big screen system and medium based on Echarts | |
| Kutzias et al. | Comparative Analysis of Process Models for Data Science Projects. | |
| Aleksy et al. | Case study on utilizing mobile applications in industrial field service | |
| CN112561500A (en) | Salary data generation method, device, equipment and medium based on user data | |
| CN112559641A (en) | Processing method and device of pull chain table, readable storage medium and electronic equipment | |
| Lewis et al. | Guided design search in the interval-bounded sailor assignment problem | |
| CN112764396B (en) | Configuration method and device | |
| CN109388385A (en) | Method and apparatus for application and development | |
| US11755429B2 (en) | Method, electronic device, and program product for presenting I/O write records | |
| CN106250493A (en) | A kind of data processing method and device | |
| Blunt et al. | A general model for simulating information storage and retrieval systems | |
| CN106570161A (en) | Data processing method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171107 |
|
| RJ01 | Rejection of invention patent application after publication |