CN109918067A - Report Customization method, apparatus, client and storage medium - Google Patents
Report Customization method, apparatus, client and storage medium Download PDFInfo
- Publication number
- CN109918067A CN109918067A CN201910064679.3A CN201910064679A CN109918067A CN 109918067 A CN109918067 A CN 109918067A CN 201910064679 A CN201910064679 A CN 201910064679A CN 109918067 A CN109918067 A CN 109918067A
- Authority
- CN
- China
- Prior art keywords
- report
- gauge outfit
- data
- server
- client
- 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
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000003860 storage Methods 0.000 title claims abstract description 20
- 238000012545 processing Methods 0.000 claims abstract description 75
- 230000009471 action Effects 0.000 claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 20
- 230000015654 memory Effects 0.000 claims description 19
- 238000004891 communication Methods 0.000 claims description 8
- 230000006870 function Effects 0.000 description 18
- 238000010586 diagram Methods 0.000 description 7
- 230000005540 biological transmission Effects 0.000 description 5
- 230000007774 longterm Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000007792 addition Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 238000010295 mobile communication Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Landscapes
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of Report Customization method, comprising: data-driven model is generated according to the gauge outfit title that report is included, wherein the gauge outfit title is associated with the field of the database in server；The trigger action of the corresponding report is received, and the data-driven model is updated according to the trigger action；The updated data-driven model is sent to server, wherein the server selects corresponding processing data according to the updated data-driven model；And the processing data that the server is sent are received, and the processing data are shown in the report.The present invention also provides a kind of Report Customization device, client and storage mediums.The present invention can satisfy the business need that user customizes data sheet.
Description
Technical field
The present invention relates to technical field of information processing, and in particular to a kind of Report Customization method, apparatus, client and storage
Medium.
Background technique
Custom form in the industry is usually production method drive by DOM at present, the report customization efficiency that DOM drives compared with
Low, scalability is poor, realizes complicated, it is difficult to safeguard.
Summary of the invention
In view of the foregoing, it is necessary to propose a kind of Report Customization method, apparatus, client and storage medium, Ke Yiman
Business need of the sufficient user for Report Customization.
The first aspect of the present invention provides a kind of Report Customization method, is applied in client, the client and service
Device communication connection, which comprises
Data-driven model is generated according to the gauge outfit title that report is included, wherein in the gauge outfit title and server
The field of database is associated with；
The trigger action of the corresponding report is received, and the data-driven model is updated according to the trigger action；
The updated data-driven model is sent to server, wherein the server is according to described updated
Data-driven model selects corresponding processing data；And
The processing data that the server is sent are received, and the processing data are shown in the report.
Preferably, the trigger action includes increasing gauge outfit, deleting gauge outfit and selection gauge outfit.
Preferably, when the trigger action is to increase the operation of gauge outfit, a gauge outfit is increased newly in the report, according to new
The gauge outfit of increasing updates the data-driven model；
When the trigger action is to delete the operation of gauge outfit, corresponding gauge outfit in the report is deleted, to update institute
State data-driven model；
When the trigger action is to select the operation of gauge outfit, the corresponding gauge outfit of the report of display is selected, and by institute
It states gauge outfit title corresponding to data-driven model and is updated to selected gauge outfit, to update the data-driven model.
Preferably, the method also includes:
Hereof by the incidence relation storage between the field of the database in the gauge outfit title and server,
In, the file is JSON or XML file.
Preferably, described to send the updated data-driven model to server, wherein the server is according to institute
Stating the corresponding processing data of updated data-driven model selection includes:
By in the corresponding data-driven model JSON or XML file be transmitted to the server；
The server executes corresponding query actions after parsing to the file；
The server sends processing data that inquiry obtains to the client.
Preferably, the method also includes:
By the client transmissions to gauge outfit title and the field of report in the file of the server end carry out it is corresponding with
Generate one or more relationships pair.
Preferably, the processing data for receiving the server and sending, and the processing data are shown in institute
It states in report and includes:
The processing data that the server is sent are received, and the processing data are parsed；
Obtain the data for the relationship pair that every a line record is corresponding in the report, and the pass that every a line record is corresponding
The value of system pair is shown in the report.
The second aspect of the present invention provides a kind of Report Customization device, and described device includes:
Generation module, the gauge outfit title for being included according to report generates data-driven model, wherein the gauge outfit name
Title is associated with the field of the database in server；
Receiving module updates the number for receiving the trigger action of the corresponding report, and according to the trigger action
According to driving model；
Sending module, for sending the updated data-driven model to server, wherein the server according to
The updated data-driven model selects corresponding processing data；And
Display module, the processing data sent for receiving the server, and the processing data are shown in
In the report.
The third aspect of the present invention provides a kind of client, and the client includes processor and memory, the processing
Device is for realizing the Report Customization method when executing the computer program stored in the memory.
The fourth aspect of the present invention provides a kind of computer readable storage medium, deposits on the computer readable storage medium
Computer program is contained, the computer program realizes the Report Customization method when being executed by processor.
Report Customization method, apparatus, electronic equipment and storage medium of the present invention, by writing data in client
Driving model realize table dynamic additions and deletions, can voluntarily be claimed allocation list first place according to business demand, retransmit to server end into
Row data processing, returns to processing data result after being disposed, carry out Dynamic Display by client end data-driven report.It realizes
Meet user for the business need of Report Customization, and maintenance personnel is not necessarily to carry out extra maintenance according to data variation,
Reduce maintenance cost.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of invention for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is the application environment architecture diagram for the Report Customization method that the embodiment of the present invention one provides.
Fig. 2 is the flow chart for the Report Customization method that the embodiment of the present invention one provides.
Fig. 3 is the functional block diagram of Report Customization device provided by Embodiment 2 of the present invention.
Fig. 4 is the schematic diagram for the client that the embodiment of the present invention three provides.
The present invention that the following detailed description will be further explained with reference to the above drawings.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying example, the present invention will be described in detail.It should be noted that in the absence of conflict, the embodiment of the present invention and embodiment
In feature can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, described embodiment is only
It is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill
Personnel's every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical.Term as used herein in the specification of the present invention is intended merely to description tool
The purpose of the embodiment of body, it is not intended that in the limitation present invention.
Description and claims of this specification and term " first " in above-mentioned attached drawing, " second " and " third " etc. are
For distinguishing different objects, not for description particular order.In addition, term " includes " and their any deformations, it is intended that
Non-exclusive include in covering.Such as the process, method, system, product or equipment for containing a series of steps or units do not have
It is defined in listed step or unit, but optionally further comprising the step of not listing or unit, or optionally further comprising
For the intrinsic other step or units of these process, methods, product or equipment.
The Report Customization method application of the embodiment of the present invention is in the client.The client for needing into Report Customization
End can integrate Report Customization function provided by method of the invention, or installation on the client directly for realizing this
The client of the method for invention.For another example, method provided by the present invention can also be with Software Development Kit (Software
Development Kit, SDK) form operate in the equipment such as server, Report Customization function is provided in the form of SDK
Report Customization function can be realized by the interface provided in interface, client or other equipment.
Embodiment one
As shown in fig.1, the application environment architecture diagram for Report Customization method provided for the embodiment of the present invention one.
Report Customization method of the invention is applied in the environment of client 1 and the composition of server 2.1 He of client
It is communicated to connect between server 2 by wired or wireless network.The cable network can be any type of traditional wire communication,
Such as internet, local area network.The wireless network can be any type of conventional wireless communication, such as radio, Wireless Fidelity
(Wireless Fidelity, WIFI), honeycomb, satellite, broadcast etc..Wireless communication technique may include, but be not limited to, the whole world
Mobile communication system (Global System for Mobile Communications, GSM), General Packet Radio Service
(General Packet Radio Service, GPRS), CDMA (Code Division Multiple Access,
CDMA), wideband code division multiple access (W-CDMA), CDMA2000, IMT single carrier (IMT Single Carrier), enhanced data
Rate GSM evolution (Enhanced Data Rates for GSM Evolution, EDGE), Long Term Evolution (Long-
Term Evolution, LTE), senior long term evolution technology, time-division Long Term Evolution (Time-Division LTE, TD-
LTE), the 5th third-generation mobile communication technology (5G), high performance radio local area network (High Performance Radio Local
Area Network, HiperLAN), high performance radio wide area network (High Performance Radio Wide Area
Network, HiperWAN), local multiple spot distribute business (Local Multipoint Distribution Service,
LMDS), full micro-wave access global inter communication (Worldwide Interoperability for Microwave Access,
WiMAX), ZigBee protocol (ZigBee), bluetooth, orthogonal frequency division multiplexi (Flash Orthogonal Frequency-
Division Multiplexing, Flash-OFDM), large capacity space-division multiple access (High Capacity Spatial
Division Multiple Access, HC-SDMA), Universal Mobile Telecommunications System (Universal Mobile
Telecommunications System, UMTS), Universal Mobile Telecommunications System time division duplex (UMTS Time-Division
Duplexing, UMTS-TDD), evolved high-speed packet access (Evolved High Speed Packet Access, HSPA
+), TD SDMA (Time Division Synchronous Code Division Multiple Access,
TD-SCDMA), evolution data optimization (Evolution-Data Optimized, EV-DO), Digital Enhanced Cordless Communications
(Digital Enhanced Cordless Telecommunications, DECT) and other.
The client 1 may include personal computer (Personal Computer, PC), personal digital assistant
(Personal Digital Assistant, PDA), radio hand-held equipment, tablet computer (Tablet Computer), intelligence
Mobile phone etc..Above-mentioned client 1 is only citing, and non exhaustive, including but not limited to above-mentioned mobile terminal.The client 1 can be with
Human-computer interaction is carried out by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user.
The client 1 includes display screen, and the display screen can have touch function, such as liquid crystal (Liquid
Crystal Display, LCD) display screen or Organic Light Emitting Diode (Organic Light-Emitting Diode, OLED)
Display screen.The display screen is for showing the contents such as report.
The server 2 is that one kind can be automatic to carry out numerical value calculating and/or letter according to the instruction for being previously set or storing
The equipment of processing is ceased, hardware includes but is not limited to microprocessor, specific integrated circuit (application program lication
Specific Integrated Circuit, ASIC), programmable gate array (Field-Programmable Gate
Array, FPGA), digital processing unit (Digital Signal Processor, DSP), embedded device etc..
Embodiment two
Fig. 2 is the flow chart for the Report Customization method that the embodiment of the present invention one provides.The process according to different requirements,
Execution sequence in figure can change, and certain steps can be omitted.
Step S01 generates data-driven model according to the gauge outfit title that report is included, wherein the gauge outfit title and number
According to the field association in library.
It is to be appreciated that user can obtain the webpage comprising report from server end by the browser of client.It is described
Report may include one or more gauge outfits, and each gauge outfit may include one or more cells, and every a line may include corresponding institute
The cell of gauge outfit quantity is stated, the cell constitutes the content of the row, column of the report.The data of the cell can be right
It should be the content of the formats such as numeric type, character type, date type, time type.
Preferably, gauge outfit can be indicated by TH for HTML, each gauge outfit has a gauge outfit title, specifically,
It is configured in HTML by the name attribute of TH；Every a line can be indicated by HR；Each cell can by TD come
It indicates.It is to be appreciated that unique or different gauge outfit title is all had it includes different gauge outfits for a report, with
Facilitate and is distinguished.
In present embodiment, one or more gauge outfit titles that the report includes can be obtained to generate the data-driven
Model.The gauge outfit title of the report can be bound with the database of server end.For example, the report may include the first table
First place claims and sensitive gauge outfit title, may include the first field, the second field and third field in the database of server end, wherein
First field, the second field and third field can be located in identical or different tables of data.First gauge outfit in the report
Title can be bound with first field, and the second gauge outfit title can be bound with second field.It is real one
It applies in mode, the binding relationship between the gauge outfit title and the server end of the report can be stored in file, such as JSON
Or in XML file.
It is to be appreciated that the gauge outfit level of the report may include one or more layers.It also include the table in the file
Hierarchical relationship corresponding to head.When the gauge outfit of the report include multilayer when, that is, indicate the gauge outfit may include a parent table head and
One or more sublist heads, each sublist head may include one or more secondary sublist heads again.
Step S02 receives the trigger action of the corresponding report, and updates the data-driven according to the trigger action
Model.
When carrying out editor's movement to the report, corresponding trigger action can produce, wherein editor movement can wrap
Include but be not limited to increase gauge outfit, delete gauge outfit, selection gauge outfit etc., the client can be according to the editor of user movement generation
Trigger action.Specifically, increase gauge outfit, delete the settable corresponding operation buttons such as gauge outfit, selection gauge outfit, such as work as operation button
When being clicked, that is, it can produce corresponding trigger action.
Preferably, can be updated according to the trigger action to the data-driven model.The trigger action includes
Increase gauge outfit, delete gauge outfit and selection gauge outfit.
When the trigger action is to increase the operation of gauge outfit, a gauge outfit can be increased newly in the report.In an embodiment party
In formula, when a newly-increased gauge outfit, can the newly-increased gauge outfit be bound or be associated with the field that server end is stored, such as
The newly-increased gauge outfit is bound with the third field.Preferably, client can prompt to use when increasing the gauge outfit newly
Whether family needs to carry out the operation of data binding, or shows combobox at the newly-increased gauge outfit, wherein the combobox
The field contents that middle display can be bound.The value of the gauge outfit can be realized by the customized of user.Table is increased newly in the report
When head, the gauge outfit title of the newly-increased gauge outfit can be added in the data-driven model.
It is to be appreciated that it is right that the client can obtain the trigger action institute when the gauge outfit includes multiple levels
The level for the gauge outfit answered, and corresponding parent table head can be obtained according to the gauge outfit of triggering, it later can be new under the parent table head
Increase a sublist head, the newly-increased sublist head and the gauge outfit of the triggering are coordination, are located on the same floor in grade.For example, institute
It states and contains second gauge outfit under the first gauge outfit, when second gauge outfit triggers the operation of newly-increased gauge outfit, institute can be obtained
The parent table head of the second gauge outfit is stated, as described first gauge outfit, at this point, one the 4th gauge outfit can be increased newly under first gauge outfit,
Described in the second gauge outfit and the 4th gauge outfit be located at identical level.Later can the gauge outfit of basis update the data-driven model.
When the trigger action is to delete the operation of gauge outfit, corresponding gauge outfit in the report can be deleted.When the table
When head is deleted, gauge outfit title corresponding in the data-driven model can be deleted, and then reach the update data and drive
The purpose of movable model.
When the trigger action is to select the operation of gauge outfit, the corresponding gauge outfit of the display report may be selected.When described
When corresponding gauge outfit is selected in report, gauge outfit title corresponding to the data-driven model can be updated to selected table
Head, and then achieve the purpose that update the data-driven model.
It is to be appreciated that in one embodiment, choice box can be shown in the browser of the client, user can be in institute
The lookup that gauge outfit value is carried out in choice box is stated, including but not limited to accurate lookup, fuzzy search (such as Wildcard searches).It is looking into
It looks for and corresponding gauge outfit may be selected in the result.In another embodiment, it can also be shown down in the browser of the client
Frame is drawn, all gauge outfits that the report includes can be shown in the combobox, the combobox can be single choice or multiselect.When
When selecting corresponding gauge outfit in the combobox, the data-driven model can be updated to corresponding to selected gauge outfit
Gauge outfit title.
In one embodiment, the data-driven model further includes time attribute.Due in the gauge outfit there may be
There may be the data that one or more columns per page has time attribute in the cell of time type or the gauge outfit.At this point, described
It can show that selection of time frame, the selection of time frame can be used for being arranged a period, the period in the browser of client
Can have time started and end time.When having selected the corresponding period in the selection of time frame, the period is
It can be used as the time attribute of the data-driven model.The time attribute of the data-driven model also can be transmitted to server
End.
Step S03 sends the updated data-driven model to server, wherein the server is according to
Data-driven model selects corresponding processing data.
It is to be appreciated that the updated data-driven model can be transmitted after the data-driven model updates
To the server end, corresponding processing data are selected according to the data-driven model by the server end, to obtain
The processing data of the corresponding data-driven model.
In present embodiment, the processing data can be numeric type, character type, day in the format that the server end stores
Phase type, time type etc..
Preferably, the client JSON of the corresponding data-driven model or XML file can be transmitted to it is described
Server end executes corresponding query actions, and can obtain inquiry after being parsed by the server end to the file
Processing data be back to client.
In one embodiment, when the data-driven model includes the time attribute, the server end also root
Operation is filtered to the processing data according to the time attribute, satisfactory processing data are returned into client.
For example, the time attribute can correspond to the third field, therefore, the server end can be selected from the processing data
Processing data in the third field within the period.
Step S04 receives the processing data that the server is sent, and the processing data is shown in the report
In table.
Specifically, the gauge outfit title and field by the client transmissions to report in the file of the server end carry out
It corresponds to form one or more relationships pair, i.e., contains one or more relationships pair in the described file.For example, first table
It is referred to as the first relationship pair that first place is correspondingly arranged with first field, and the second gauge outfit title is corresponding with second field to be set
It is set to the second relationship pair, the third gauge outfit title and the third field are correspondingly arranged as third relationship pair.The server
The corresponding relationship that the processing data are included according to the file can be returned to client by the row record of report by end.That is institute
Stating server end and returning in the processing data of the client may include one or more rows records, each row record includes
The cell data of each gauge outfit of the corresponding report.It is to be appreciated that can have corresponding one in each row record
The cell data of gauge outfit are sky, at this point, the server end returns to corresponding relationship in the processing data of the client
To may be configured as sky.
After the client receives the processing data, the processing data can be parsed, to obtain every a line
The data of the corresponding relationship pair of record, and the value that every a line can be recorded to corresponding relationship pair is shown in the report,
And then achieve the purpose that update, report customization.
In conclusion Report Customization method provided by the invention, the gauge outfit title including being included according to report generates number
According to driving model, wherein the gauge outfit title is associated with the field of the database in server；Receive the touching of the corresponding report
Hair operation, and the data-driven model is updated according to the trigger action；Send the updated data-driven model extremely
Server, wherein the server selects corresponding processing data according to the updated data-driven model；And receive institute
The processing data of server transmission are stated, and the processing data are shown in the report.The present invention provides one kind
For the data driven mode of report customization, the dynamic additions and deletions that data-driven model realizes table are write in front end, can be according to business
Demand voluntarily claims allocation list first place, retransmits to server end and carries out data processing, and processing data result is returned after being disposed,
Dynamic Display is carried out by client end data-driven report.
The above is only a specific embodiment of the invention, but scope of protection of the present invention is not limited thereto, for
For those skilled in the art, without departing from the concept of the premise of the invention, improvement, but these can also be made
It all belongs to the scope of protection of the present invention.
Below with reference to Fig. 3 and Fig. 4, respectively to the functional module and hardware knot of the client of the above-mentioned Report Customization method of realization
Structure is introduced.
Embodiment three
Fig. 3 is the functional block diagram in Report Customization device preferred embodiment of the present invention.
In some embodiments, the Report Customization device 30 is run in client.The Report Customization device 30 can
To include multiple functional modules as composed by program code segments.The program of each program segment in the Report Customization device 30
Code can store in memory, and as performed by least one processor, with execution (being detailed in Fig. 2 and its associated description) report
Table customizes function.
In the present embodiment, function of the Report Customization device 30 according to performed by it can be divided into multiple functions
Module.The functional module may include: generation module 301, receiving module 302, sending module 303 and display module 304.This
Inventing so-called module and referring to a kind of performed by least one processor and can complete a series of of fixed function
Computer program code segments, storage is in memory.It in some embodiments, will be in subsequent embodiment about the function of each module
Middle detailed description.
The generation module 301 is used for the gauge outfit title for being included according to report and generates data-driven model, wherein described
Gauge outfit title is associated with the field in database.
It is to be appreciated that user can obtain the webpage comprising report from server end by the browser of client.It is described
Report may include one or more gauge outfits, and each gauge outfit may include one or more cells, and every a line may include corresponding institute
The cell of gauge outfit quantity is stated, the cell constitutes the content of the row, column of the report.The data of the cell can be right
It should be the content of the formats such as numeric type, character type, date type, time type.
Preferably, gauge outfit can be indicated by TH for HTML, each gauge outfit has a gauge outfit title, specifically,
It is configured in HTML by the name attribute of TH；Every a line can be indicated by HR；Each cell can by TD come
It indicates.It is to be appreciated that unique or different gauge outfit title is all had it includes different gauge outfits for a report, with
Facilitate and is distinguished.
In present embodiment, one or more gauge outfit titles that the report includes can be obtained to generate the data-driven
Model.The gauge outfit title of the report can be bound with the database of server end.For example, the report may include the first table
First place claims and sensitive gauge outfit title, may include the first field, the second field and third field in the database of server end, wherein
First field, the second field and third field can be located in identical or different tables of data.First gauge outfit in the report
Title can be bound with first field, and the second gauge outfit title can be bound with second field.It is real one
It applies in mode, the binding relationship between the gauge outfit title and the server end of the report can be stored in file, such as JSON
Or in XML file.
It is to be appreciated that the gauge outfit level of the report may include one or more layers.It also include the table in the file
Hierarchical relationship corresponding to head.When the gauge outfit of the report include multilayer when, that is, indicate the gauge outfit may include a parent table head and
One or more sublist heads, each sublist head may include one or more secondary sublist heads again.
The receiving module 302 is used to receive the trigger action of the corresponding report, and is updated according to the trigger action
The data-driven model.
When carrying out editor's movement to the report, corresponding trigger action can produce, wherein editor movement can wrap
Include but be not limited to increase gauge outfit, delete gauge outfit, selection gauge outfit etc., the client can be according to the editor of user movement generation
Trigger action.Specifically, increase gauge outfit, delete the settable corresponding operation buttons such as gauge outfit, selection gauge outfit, such as work as operation button
When being clicked, that is, it can produce corresponding trigger action.
Preferably, can be updated according to the trigger action to the data-driven model.The trigger action includes
Increase gauge outfit, delete gauge outfit and selection gauge outfit.
When the trigger action is to increase the operation of gauge outfit, a gauge outfit can be increased newly in the report.In an embodiment party
In formula, when a newly-increased gauge outfit, can the newly-increased gauge outfit be bound or be associated with the field that server end is stored, such as
The newly-increased gauge outfit is bound with the third field.Preferably, client can prompt to use when increasing the gauge outfit newly
Whether family needs to carry out the operation of data binding, or shows combobox at the newly-increased gauge outfit, wherein the combobox
The field contents that middle display can be bound.The value of the gauge outfit can be realized by the customized of user.Table is increased newly in the report
When head, the gauge outfit title of the newly-increased gauge outfit can be added in the data-driven model.
It is to be appreciated that it is right that the client can obtain the trigger action institute when the gauge outfit includes multiple levels
The level for the gauge outfit answered, and corresponding parent table head can be obtained according to the gauge outfit of triggering, it later can be new under the parent table head
Increase a sublist head, the newly-increased sublist head and the gauge outfit of the triggering are coordination, are located on the same floor in grade.For example, institute
It states and contains second gauge outfit under the first gauge outfit, when second gauge outfit triggers the operation of newly-increased gauge outfit, institute can be obtained
The parent table head of the second gauge outfit is stated, as described first gauge outfit, at this point, one the 4th gauge outfit can be increased newly under first gauge outfit,
Described in the second gauge outfit and the 4th gauge outfit be located at identical level.Later can the gauge outfit of basis update the data-driven model.
When the trigger action is to delete the operation of gauge outfit, corresponding gauge outfit in the report can be deleted.When the table
When head is deleted, gauge outfit title corresponding in the data-driven model can be deleted, and then reach the update data and drive
The purpose of movable model.
When the trigger action is to select the operation of gauge outfit, the corresponding gauge outfit of the display report may be selected.When described
When corresponding gauge outfit is selected in report, gauge outfit title corresponding to the data-driven model can be updated to selected table
Head, and then achieve the purpose that update the data-driven model.
It is to be appreciated that in one embodiment, choice box can be shown in the browser of the client, user can be in institute
The lookup that gauge outfit value is carried out in choice box is stated, including but not limited to accurate lookup, fuzzy search (such as Wildcard searches).It is looking into
It looks for and corresponding gauge outfit may be selected in the result.In another embodiment, it can also be shown down in the browser of the client
Frame is drawn, all gauge outfits that the report includes can be shown in the combobox, the combobox can be single choice or multiselect.When
When selecting corresponding gauge outfit in the combobox, the data-driven model can be updated to corresponding to selected gauge outfit
Gauge outfit title.
In one embodiment, the data-driven model further includes time attribute.Due in the gauge outfit there may be
There may be the data that one or more columns per page has time attribute in the cell of time type or the gauge outfit.At this point, described
It can show that selection of time frame, the selection of time frame can be used for being arranged a period, the period in the browser of client
Can have time started and end time.When having selected the corresponding period in the selection of time frame, the period is
It can be used as the time attribute of the data-driven model.The time attribute of the data-driven model also can be transmitted to server
End.
The sending module 303 is for sending the updated data-driven model to server, wherein the service
Device selects corresponding processing data according to the data-driven model.
It is to be appreciated that the updated data-driven model can be transmitted after the data-driven model updates
To the server end, corresponding processing data are selected according to the data-driven model by the server end, to obtain
The processing data of the corresponding data-driven model.
In present embodiment, the processing data can be numeric type, character type, day in the format that the server end stores
Phase type, time type etc..
Preferably, the client JSON of the corresponding data-driven model or XML file can be transmitted to it is described
Server end executes corresponding query actions, and can obtain inquiry after being parsed by the server end to the file
Processing data be back to client.
In one embodiment, when the data-driven model includes the time attribute, the server end also root
Operation is filtered to the processing data according to the time attribute, satisfactory processing data are returned into client.
For example, the time attribute can correspond to the third field, therefore, the server end can be selected from the processing data
Processing data in the third field within the period.
The display module 304 is used to receive the processing data that the server is sent, and by the processing data
It is shown in the report.
Specifically, the gauge outfit title and field by the client transmissions to report in the file of the server end carry out
It corresponds to generate one or more relationships pair, i.e., contains one or more relationships pair in the described file.For example, first table
It is referred to as the first relationship pair that first place is correspondingly arranged with first field, and the second gauge outfit title is corresponding with second field to be set
It is set to the second relationship pair, the third gauge outfit title and the third field are correspondingly arranged as third relationship pair.The server
The corresponding relationship that the processing data are included according to the file can be returned to client by the row record of report by end.That is institute
Stating server end and returning in the processing data of the client may include one or more rows records, each row record includes
The cell data of each gauge outfit of the corresponding report.It is to be appreciated that can have corresponding one in each row record
The cell data of gauge outfit are sky, at this point, the server end returns to corresponding relationship in the processing data of the client
To may be configured as sky.
After the client receives the processing data, the processing data can be parsed, to obtain every a line
The data of the corresponding relationship pair of record, and the value that every a line can be recorded to corresponding relationship pair is shown in the report,
And then achieve the purpose that update, report customization.
In conclusion Report Customization device 30 of the present invention, including generation module 301, receiving module 302, transmission
Module 303 and display module 304.The generation module 301 is used for the gauge outfit title for being included according to report and generates data-driven
Model, wherein the gauge outfit title is associated with the field of the database in server；The receiving module 302 is for receiving correspondence
The trigger action of the report, and the data-driven model is updated according to the trigger action；The sending module 303 is used for
The updated data-driven model is sent to server, wherein the server is according to the updated data-driven
Model selects corresponding processing data；And the display module 304 is used to receive the processing data that the server is sent,
And the processing data are shown in the report.The present invention provides a kind of data driven mode for report customization,
The dynamic additions and deletions that data-driven model realizes table are write in front end, can voluntarily be claimed allocation list first place according to business demand, be retransmited
Data processing is carried out to server end, processing data result is returned after being disposed, is carried out by client end data-driven report
Dynamic Display.
The above-mentioned integrated unit realized in the form of software function module, can store and computer-readable deposit at one
In storage media.Above-mentioned software function module is stored in a storage medium, including some instructions are used so that a computer
It is each that equipment (can be personal computer, double screen equipment or the network equipment etc.) or processor (processor) execute the present invention
The part of a embodiment the method.
Fig. 4 is the schematic diagram for the client that the embodiment of the present invention four provides.
The client 1 includes: memory 41, at least one processor 42, is stored in the memory 41 and can be
The computer program 43 and at least one communication bus 44 run at least one described processor 42.
At least one described processor 42 realizes above-mentioned Report Customization embodiment of the method when executing the computer program 43
In step.
Illustratively, the computer program 43 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 41, and are executed by least one described processor 42, to complete this hair
It is bright.One or more of module/units can be the series of computation machine program instruction section that can complete specific function, described
Instruction segment is for describing implementation procedure of the computer program 43 in the client 1.
The client 1 can be mobile phone, tablet computer, personal digital assistant (Personal Digital
Assistant, PDA) etc. application program is installed equipment.It will be understood by those skilled in the art that the schematic diagram 4 is only
The example of client 1 does not constitute the restriction to client 1, may include than illustrating more or fewer components, or combination
Certain components or different components, for example, the client 1 can also include input-output equipment, it is network access equipment, total
Line etc..
At least one described processor 42 can be central processing unit (Central Processing Unit, CPU),
It can also be other general processors, digital signal processor (Digital Signal Processor, DSP), dedicated integrated
Circuit (Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..The processor 42 can be microprocessor or the processor 42 is also possible to any conventional place
Device etc. is managed, the processor 42 is the control centre of the client 1, utilizes various interfaces and the entire client 1 of connection
Various pieces.
The memory 41 can be used for storing the computer program 43 and/or module/unit, and the processor 42 passes through
Operation executes the computer program and/or module/unit being stored in the memory 41, and calls and be stored in memory
Data in 41 realize the various functions of the client 1.The memory 41 can mainly include storing program area and storage number
According to area, wherein storing program area can application program needed for storage program area, at least one function (for example sound plays function
Energy, image player function etc.) etc.；Storage data area, which can be stored, uses created data (such as audio number according to client 1
According to, phone directory etc.) etc..In addition, memory 41 may include high-speed random access memory, it can also include non-volatile memories
Device, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure
Digital, SD) card, flash card (Flash Card), at least one disk memory, flush memory device or other volatibility are solid
State memory device.
If the integrated module/unit of the client 1 is realized in the form of SFU software functional unit and as independent production
Product when selling or using, can store in a computer readable storage medium.Based on this understanding, the present invention realizes
All or part of the process in above-described embodiment method can also instruct relevant hardware to complete by computer program,
The computer program can be stored in a computer readable storage medium, and the computer program is being executed by processor
When, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, described
Computer program code can be source code form, object identification code form, executable file or certain intermediate forms etc..The meter
Calculation machine readable medium may include: can carry the computer program code any entity or device, recording medium, USB flash disk,
Mobile hard disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory
Device (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It needs to illustrate
It is that the content that the computer-readable medium includes can be fitted according to the requirement made laws in jurisdiction with patent practice
When increase and decrease, such as in certain jurisdictions, according to legislation and patent practice, computer-readable medium does not include electric carrier wave letter
Number and telecommunication signal.
In several embodiments provided by the present invention, it should be understood that arriving, disclosed electronic equipment and method can be with
It realizes by another way.For example, electronic equipment embodiment described above is only schematical, for example, the list
The division of member, only a kind of logical function partition, there may be another division manner in actual implementation.
It, can also be in addition, each functional unit in each embodiment of the present invention can integrate in same treatment unit
It is that each unit physically exists alone, can also be integrated in same unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds software function module.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.This
Outside, it is clear that one word of " comprising " is not excluded for other units or, odd number is not excluded for plural number.The multiple units stated in system claims
Or device can also be implemented through software or hardware by a unit or device.The first, the second equal words are used to indicate name
Claim, and does not indicate any particular order.
Finally it should be noted that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although reference
Preferred embodiment describes the invention in detail, those skilled in the art should understand that, it can be to of the invention
Technical solution is modified or equivalent replacement, without departing from the spirit of the technical scheme of the invention range.
Claims (10)
1. a kind of Report Customization method is applied in client, the client is connect with server communication, which is characterized in that
The described method includes:
Data-driven model is generated according to the gauge outfit title that report is included, wherein the data in the gauge outfit title and server
The field in library is associated with；
The trigger action of the corresponding report is received, and the data-driven model is updated according to the trigger action；
The updated data-driven model is sent to server, wherein the server is according to the updated data
Driving selects corresponding processing data；And
The processing data that the server is sent are received, and the processing data are shown in the report.
2. Report Customization method as described in claim 1, which is characterized in that the trigger action includes increasing gauge outfit, deleting
Gauge outfit and selection gauge outfit.
3. Report Customization method as claimed in claim 2, it is characterised in that:
When the trigger action is to increase the operation of gauge outfit, a gauge outfit is increased newly in the report, more according to newly-increased gauge outfit
The new data-driven model；
When the trigger action is to delete the operation of gauge outfit, corresponding gauge outfit in the report is deleted, to update the number
According to driving model；
When the trigger action is to select the operation of gauge outfit, the corresponding gauge outfit of the report of display is selected, and by the number
It is updated to selected gauge outfit according to gauge outfit title corresponding to driving model, to update the data-driven model.
4. Report Customization method as described in claim 1, which is characterized in that the method also includes:
Hereof by the incidence relation storage between the field of the database in the gauge outfit title and server, wherein institute
Stating file is JSON or XML file.
5. Report Customization method as claimed in claim 4, which is characterized in that described to send the updated data-driven mould
Type is to server, wherein the server selects the corresponding processing data to include: according to the updated data-driven model
By in the corresponding data-driven model JSON or XML file be transmitted to the server；
The server executes corresponding query actions after parsing to the file；
The server sends processing data that inquiry obtains to the client.
6. Report Customization method as described in claim 1, which is characterized in that the method also includes: the client is passed
Be defeated by the gauge outfit title of report in the file of the server end and field carry out it is corresponding to generate one or more relationships pair.
7. Report Customization method as claimed in claim 6, which is characterized in that the place for receiving the server and sending
Data are managed, and the processing data are shown in the report and include:
The processing data that the server is sent are received, and the processing data are parsed；
Obtain the data for the relationship pair that every a line record is corresponding in the report, and the relationship pair that every a line record is corresponding
Value be shown in the report.
8. a kind of Report Customization device, which is characterized in that described device includes:
Generation module, gauge outfit title for being included according to report generate data-driven model, wherein the gauge outfit title with
The field of database in server is associated with；
Receiving module for receiving the trigger action of the corresponding report, and updates the data according to the trigger action and drives
Movable model；
Sending module, for sending the updated data-driven model to server, wherein the server is according to
Updated data-driven model selects corresponding processing data；And
Display module, the processing data sent for receiving the server, and described in the processing data are shown in
In report.
9. a kind of client, which is characterized in that the client includes processor and memory, and the processor is for executing institute
Report Customization method as claimed in any of claims 1 to 7 in one of claims is realized when stating the computer program stored in memory.
10. a kind of computer readable storage medium, computer program, feature are stored on the computer readable storage medium
It is, the computer program realizes Report Customization side as claimed in any of claims 1 to 7 in one of claims when being executed by processor
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910064679.3A CN109918067B (en) | 2019-01-23 | 2019-01-23 | Report customization method, device, client and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910064679.3A CN109918067B (en) | 2019-01-23 | 2019-01-23 | Report customization method, device, client and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109918067A true CN109918067A (en) | 2019-06-21 |
| CN109918067B CN109918067B (en) | 2024-05-03 |
Family
ID=66960654
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910064679.3A Active CN109918067B (en) | 2019-01-23 | 2019-01-23 | Report customization method, device, client and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109918067B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114417802A (en) * | 2022-03-22 | 2022-04-29 | 创意信息技术股份有限公司 | Intelligent report generation system |
| CN114564270A (en) * | 2022-03-03 | 2022-05-31 | 平安国际融资租赁有限公司 | List component rendering method, list component rendering method, page front-end display method, device, equipment and medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN101833580A (en) * | 2010-05-12 | 2010-09-15 | 中兴通讯股份有限公司 | Report inquiring system and data acquisition method and device thereof |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| CN103092890A (en) * | 2011-11-08 | 2013-05-08 | 苏州中茵泰格科技有限公司 | System and method for automatic generation and sending of reports |
| US20140304582A1 (en) * | 2013-03-14 | 2014-10-09 | Palantir Technologies, Inc. | Mobile reports |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN106815270A (en) * | 2015-12-02 | 2017-06-09 | 大唐移动通信设备有限公司 | A kind of method and device for servicing dynamic management |
| CN107808005A (en) * | 2017-11-14 | 2018-03-16 | 广州品唯软件有限公司 | Processing method, device and the storage medium of human resource data |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
-
2019
- 2019-01-23 CN CN201910064679.3A patent/CN109918067B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN101833580A (en) * | 2010-05-12 | 2010-09-15 | 中兴通讯股份有限公司 | Report inquiring system and data acquisition method and device thereof |
| CN103092890A (en) * | 2011-11-08 | 2013-05-08 | 苏州中茵泰格科技有限公司 | System and method for automatic generation and sending of reports |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| US20140304582A1 (en) * | 2013-03-14 | 2014-10-09 | Palantir Technologies, Inc. | Mobile reports |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN106815270A (en) * | 2015-12-02 | 2017-06-09 | 大唐移动通信设备有限公司 | A kind of method and device for servicing dynamic management |
| CN107808005A (en) * | 2017-11-14 | 2018-03-16 | 广州品唯软件有限公司 | Processing method, device and the storage medium of human resource data |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
Non-Patent Citations (1)
| Title |
|---|
| 陈叶能 等: "基于ActiveX的EIP动态报表系统", 兵工自动化, vol. 26, no. 05, 15 May 2007 (2007-05-15), pages 86 - 88 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114564270A (en) * | 2022-03-03 | 2022-05-31 | 平安国际融资租赁有限公司 | List component rendering method, list component rendering method, page front-end display method, device, equipment and medium |
| CN114564270B (en) * | 2022-03-03 | 2024-02-06 | 平安国际融资租赁有限公司 | List component rendering and front-end display method, device, equipment and medium of page |
| CN114417802A (en) * | 2022-03-22 | 2022-04-29 | 创意信息技术股份有限公司 | Intelligent report generation system |
| CN114417802B (en) * | 2022-03-22 | 2022-06-10 | 创意信息技术股份有限公司 | Intelligent report generation system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109918067B (en) | 2024-05-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102061364B1 (en) | Adjusting user interface screen order and composition | |
| CN103336813B (en) | A kind of Internet of Things data integrated management scheme based on middleware framework | |
| CN109634598A (en) | A kind of page display method, device, equipment and storage medium | |
| CN101978347B (en) | Method and device for describing multiple user interface views of application program | |
| CN103081365B (en) | Mobile terminal and for control its table data output method based on multi-touch | |
| CN102194003A (en) | Web page popup window method and device | |
| CN109948046A (en) | Information push method, device, mobile terminal and storage medium | |
| CN103370689A (en) | Cross-environment application compatibility | |
| CN109597976A (en) | A kind of document edit method and device | |
| CN101013954A (en) | Graphical user interface for generic listing of managed objects | |
| CN107818074A (en) | A kind of generation method of data report, device and electronic equipment | |
| CN105912710A (en) | File management method and terminal | |
| CN109902255A (en) | Page mixing browsing record generation method, device, equipment and storage medium | |
| CN108804158A (en) | Application call method, the control method of terminal device, terminal device and computer readable storage medium | |
| CN102687105A (en) | System and methods for a run time configurable user interface controller | |
| US8074234B2 (en) | Web service platform for keyword technologies | |
| CN109918067A (en) | Report Customization method, apparatus, client and storage medium | |
| CN103077022A (en) | Visual operation configuration method and device for operation flow | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN108924030A (en) | Electronic device, the method for dynamically configuration message exhibition method and storage medium | |
| CN106020793A (en) | A method for rapid form building in an iOS platform application development process | |
| CN110399576A (en) | Page switching method, device, readable medium and electronic equipment | |
| EP4058907A1 (en) | Modularizing and embedding supplemental textual and visual content in different environments | |
| CN108959294A (en) | A kind of method and apparatus accessing search engine | |
| CN101237449B (en) | Method and system for access to IMS database |
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 |