CN109918067B - Report customization method, device, client and storage medium - Google Patents

Report customization method, device, client and storage medium Download PDF

Info

Publication number
CN109918067B
CN109918067B CN201910064679.3A CN201910064679A CN109918067B CN 109918067 B CN109918067 B CN 109918067B CN 201910064679 A CN201910064679 A CN 201910064679A CN 109918067 B CN109918067 B CN 109918067B
Authority
CN
China
Prior art keywords
header
report
server
client
driving model
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.)
Active
Application number
CN201910064679.3A
Other languages
Chinese (zh)
Other versions
CN109918067A (en
Inventor
石晓龙
黄望
饶鑫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Life Insurance Company of China Ltd
Original Assignee
Ping An Life Insurance Company of China Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Life Insurance Company of China Ltd filed Critical Ping An Life Insurance Company of China Ltd
Priority to CN201910064679.3A priority Critical patent/CN109918067B/en
Publication of CN109918067A publication Critical patent/CN109918067A/en
Application granted granted Critical
Publication of CN109918067B publication Critical patent/CN109918067B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Abstract

A report customization method, comprising: generating a data driving model according to a header name contained in the report, wherein the header name is associated with a field of a database in a server; receiving triggering operation corresponding to the report, and updating the data driving model according to the triggering operation; the updated data driving model is sent to a server, wherein the server selects corresponding processing data according to the updated data driving model; and receiving the processing data sent by the server and displaying the processing data in the report. The invention also provides a report customization device, a client and a storage medium. The invention can meet the business requirement of the user for customizing the data report.

Description

Report customization method, device, client and storage medium
Technical Field
The invention relates to the technical field of information processing, in particular to a report customization method, a report customization device, a client and a storage medium.
Background
At present, the customized form in the industry is usually manufactured by a DOM (document object model) drive, the DOM drive customized report has lower efficiency, poor expandability, complex realization and difficult maintenance.
Disclosure of Invention
In view of the foregoing, it is necessary to provide a report customization method, device, client and storage medium, which can meet the business requirement of the user for report customization.
The first aspect of the present invention provides a report customization method, which is applied to a client, wherein the client is in communication connection with a server, and the method comprises the following steps:
generating a data driving model according to a header name contained in the report, wherein the header name is associated with a field of a database in a server;
receiving triggering operation corresponding to the report, and updating the data driving model according to the triggering operation;
The updated data driving model is sent to a server, wherein the server selects corresponding processing data according to the updated data driving model; and
And receiving the processing data sent by the server and displaying the processing data in the report.
Preferably, the triggering operation includes adding a header, deleting a header, and selecting a header.
Preferably, when the triggering operation is an operation of adding a header, a header is newly added in the report, and the data driving model is updated according to the newly added header;
When the triggering operation is an operation of deleting the header, deleting the corresponding header in the report, thereby updating the data driving model;
When the triggering operation is the operation of selecting the header, selecting the header corresponding to the displayed report, and updating the header name corresponding to the data driving model to the selected header, thereby updating the data driving model.
Preferably, the method further comprises:
And storing the association relation between the header name and the field of the database in the server in a file, wherein the file is a JSON or XML file.
Preferably, the sending the updated data driving model to a server, where the selecting, by the server, the corresponding processing data according to the updated data driving model includes:
transmitting a corresponding JSON or XML file in the data driving model to the server;
The server analyzes the file and then executes corresponding query actions;
and the server sends the processing data obtained by query to the client.
Preferably, the method further comprises:
And the header names and fields of the report form in the file transmitted to the server by the client are corresponding to generate one or more relation pairs.
Preferably, the receiving the processing data sent by the server and displaying the processing data in the report includes:
receiving the processing data sent by the server and analyzing the processing data;
And acquiring data of the relation pair corresponding to each row of records in the report, and displaying the value of the relation pair corresponding to each row of records in the report.
A second aspect of the present invention provides a report customizing apparatus, the apparatus comprising:
the generation module is used for generating a data driving model according to the header names contained in the report, wherein the header names are associated with fields of a database in the server;
The receiving module is used for receiving triggering operation corresponding to the report and updating the data driving model according to the triggering operation;
the sending module is used for sending the updated data driving model to a server, wherein the server selects corresponding processing data according to the updated data driving model; and
And the display module is used for receiving the processing data sent by the server and displaying the processing data in the report.
A third aspect of the present invention provides a client comprising a processor and a memory, the processor being configured to implement the report customization method when executing a computer program stored in the memory.
A fourth aspect of the present invention provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the report customization method.
According to the report customization method, the report customization device, the electronic equipment and the storage medium, the dynamic addition and deletion of the table are realized by writing the data driving model in the client, the name of the table header can be configured according to the service requirement, the table header is sent to the server for data processing, the data processing result is returned after the processing is finished, and the data driving report of the client is dynamically displayed. The business requirement of a user on report customization is met, maintenance personnel do not need to carry out redundant maintenance according to data change, and the maintenance cost is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
Fig. 1 is an application environment architecture diagram of a report customization method according to an embodiment of the present invention.
Fig. 2 is a flowchart of a report customization method according to an embodiment of the present invention.
Fig. 3 is a functional block diagram of a report customization device according to a second embodiment of the present invention.
Fig. 4 is a schematic diagram of a client according to a third embodiment of the present invention.
The invention will be further described in the following detailed description in conjunction with the above-described figures.
Detailed Description
In order that the above-recited objects, features and advantages of the present invention will be more clearly understood, a more particular description of the invention will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings. It should be noted that, without conflict, the embodiments of the present invention and features in the embodiments may be combined with each other.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, and the described embodiments are merely some, rather than all, embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.
The terms first, second, third and the like in the description and in the claims of the invention and in the above-described figures, are used for distinguishing between different objects and not for describing a particular sequential order. Furthermore, the term "include" and any variations thereof is intended to cover a non-exclusive inclusion. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those listed steps or elements but may include other steps or elements not listed or inherent to such process, method, article, or apparatus.
The report customizing method of the embodiment of the invention is applied to the client. For the client needing report customization, the report customization function provided by the method of the invention can be directly integrated on the client, or the client for realizing the method of the invention can be installed. For example, the method provided by the invention can also be operated on devices such as a server in the form of a software development kit (Software Development Kit, SDK), an interface for report customization function is provided in the form of the SDK, and a client or other devices can realize the report customization function through the provided interface.
Example 1
Referring to fig. 1, an application environment architecture diagram for a report customization method according to an embodiment of the present invention is shown.
The report customization method is applied to an environment formed by the client 1 and the server 2. The client 1 and the server 2 are in communication connection through a wired or wireless network. The wired network may be of any type of conventional wired communication, such as the internet, a local area network. The wireless network may be of any type of conventional wireless communication, such as radio, wireless fidelity (WIRELESS FIDELITY, WIFI), cellular, satellite, broadcast, etc. Wireless communication technologies may include, but are not limited to, global system for mobile communications (Global System for Mobile Communications, GSM), general packet Radio Service (GENERAL PACKET Radio Service, GPRS), code Division multiple access (Code Division Multiple Access, CDMA), wideband code Division multiple access (W-CDMA), CDMA2000, IMT single carrier (IMT SINGLE CARRIER), enhanced data rates for GSM Evolution (ENHANCED DATA RATES for GSM Evolution, EDGE), long Term Evolution (Long Term Evolution, LTE), advanced Long Term Evolution (LTE), time Division Long Term Evolution (Time Division LTE, TD-LTE), fifth 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 multipoint dispatch Service (Local Multipoint Distribution Service, LMDS), worldwide interoperability for full microwave access (Worldwide Interoperability for Microwave Access, wiMAX), zigBee protocol (ZigBee), bluetooth, orthogonal frequency Division multiplexing technology (Flash Orthogonal Frequency-Division Multiplexing, UMTS-OFDM), large capacity space Division multiple access (HIGH CAPACITY SPATIAL Division Multiple Access, HC-SDMA), universal mobile telecommunication system (Universal Mobile Telecommunications System, UMTS), mobile telecommunication system (Universal Mobile Telecommunications System, time Division multiple access (UMTS), time Division duplex (Time Division duplex) (Time Division 35, time Division duplex access (HIGH SPEED PACKET ACCESS, HSPA), high performance Radio wide area network (High Performance Radio Wide Area Network, hiperWAN), local multi-point dispatch Service (UMTS), TD-SCDMA), evolution-Data Optimized (EV-DO), digital enhanced cordless telecommunications (DIGITAL ENHANCED Cordless Telecommunications, DECT), and others.
The client 1 may include a Personal Computer (Personal Computer, PC), a Personal digital assistant (Personal DIGITAL ASSISTANT, PDA), a wireless handheld device, a Tablet Computer (Tablet Computer), a smart phone, etc. The above described client 1 is only an example and not exhaustive, including but not limited to the above described mobile terminal. The client 1 may perform man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch pad, or a voice control device.
The client 1 includes a display screen, which may have a touch function, such as a Liquid crystal (Liquid CRYSTAL DISPLAY, LCD) display screen or an Organic Light-Emitting Diode (OLED) display screen. The display screen is used for displaying contents such as reports and the like.
The server 2 is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable gate array (Field-Programmable GATE ARRAY, FPGA), a digital Processor (DIGITAL SIGNAL Processor, DSP), an embedded device, and the like.
Example two
Fig. 2 is a flowchart of a report customization method according to an embodiment of the present invention. The order of execution in the flowcharts may be changed, and certain steps may be omitted, according to different needs.
And S01, generating a data driving model according to the header names contained in the report, wherein the header names are associated with fields in the database.
It will be appreciated that the user may obtain a web page containing a report from the server side through the browser of the client side. The report may include one or more headers, each header may include one or more cells, each row may include a corresponding number of cells of the header, the cells comprising the contents of the rows and columns of the report. The data of the cells can correspond to the content in the formats of numerical type, character type, date type, time type and the like.
Preferably, for HTML, the headers may be represented by TH, each header having a header name, specifically, being set by name attribute of TH in HTML; each row may be represented by HR; each cell may be represented by TD. It will be appreciated that for a report, it contains different headers each with a unique or different header name to facilitate differentiation.
In this embodiment, one or more header names included in the report may be obtained to generate the data-driven model. The header name of the report can be bound with a database at the server side. For example, the report may include a first header name and a sensitive header name, and the database at the server may include a first field, a second field, and a third field, where the first field, the second field, and the third field may be located in the same or different data tables. The first header name in the report may be bound to the first field, and the second header name may be bound to the second field. In an embodiment, the binding relationship between the header name of the report and the server may be stored in a file, such as a JSON or XML file.
It will be appreciated that the header level of the report may include one or more layers. The file also contains the hierarchical relationship corresponding to the header. When the header of the report includes multiple layers, it means that the header may include a parent header and one or more child headers, each of which may in turn include one or more secondary child headers.
And step S02, receiving triggering operation corresponding to the report, and updating the data driving model according to the triggering operation.
When the report is edited, a corresponding trigger operation may be generated, wherein the editing operation may include, but is not limited to, adding a header, deleting a header, selecting a header, etc., and the client may generate the trigger operation according to the editing operation of the user. Specifically, adding a header, deleting a header, selecting a header, etc. may set corresponding operation buttons, e.g., when the operation buttons are clicked, corresponding trigger operations may be generated.
Preferably, the data driven model may be updated according to the triggering operation. The triggering operation includes adding a header, deleting a header, and selecting a header.
When the triggering operation is an operation of adding a header, a header can be newly added in the report. In an embodiment, when a header is newly added, the newly added header may be bound or associated with a field stored in the server, for example, the newly added header is bound with the third field. Preferably, when the header is newly added, the client may prompt the user whether to perform the data binding operation, or display a drop-down frame at the newly added header, where the drop-down frame displays bindable field contents. The value of the header may be achieved through user customization. When the report newly adds the header, the header name of the newly added header can be added into the data driving model.
It can be understood that, when the header includes multiple levels, the client may acquire the level of the header corresponding to the trigger operation, and may acquire the corresponding parent header according to the triggered header, and then may newly add a child header under the parent header, where the newly added child header and the triggered header are in a parallel relationship and are located in the same level. For example, the second header is included under the first header, when the second header triggers the operation of adding the header newly, the parent header of the second header may be obtained, that is, the first header, and at this time, a fourth header may be added under the first header newly, where the second header and the fourth header are located at the same level. The data driven model may then be updated based on the header.
When the triggering operation is an operation of deleting the header, the corresponding header in the report can be deleted. When the header is deleted, the header name corresponding to the data driving model can be deleted, so that the purpose of updating the data driving model is achieved.
And when the triggering operation is the operation of selecting the header, the header corresponding to the report can be selected and displayed. When the corresponding header in the report is selected, the header name corresponding to the data driving model can be updated to the selected header, so that the purpose of updating the data driving model is achieved.
It will be appreciated that in one embodiment, a selection box may be displayed in the browser of the client, in which the user may perform a lookup of the header value, including but not limited to an exact lookup, a fuzzy lookup (e.g., a wild card lookup), etc. The corresponding header can be selected in the result of the search. In another embodiment, a drop-down frame may also be displayed in the browser of the client, where all headers included in the report may be displayed in the drop-down frame, and the drop-down frame may be single-selected or multi-selected. When the corresponding header is selected in the drop-down frame, the data driving model can be updated to the header name corresponding to the selected header.
In one embodiment, the data driven model further includes a time attribute. Since there may be time type cells in the header, or there may be one or more columns of data with time attributes in the header. At this time, a time selection box may be displayed in the browser of the client, which may be used to set a time period, which may have a start time and an end time. When the corresponding time period is selected in the time selection frame, the time period can be used as the time attribute of the data driving model. The time attribute of the data driven model may also be transmitted to the server side.
And step S03, the updated data driving model is sent to a server, wherein the server selects corresponding processing data according to the data driving model.
It can be understood that, after the data driving model is updated, the updated data driving model may be transmitted to the server, and the server selects corresponding processing data according to the data driving model, so as to obtain the processing data corresponding to the data driving model.
In this embodiment, the format in which the processing data is stored in the server may be a numeric type, a character type, a date type, a time type, or the like.
Preferably, the client may transmit the JSON or XML file of the corresponding data driven model to the server, and the server may parse the file and then execute the corresponding query action, and may return the processing data obtained by the query to the client.
In one embodiment, when the data-driven model includes the time attribute, the server side further performs a filtering operation on the processing data according to the time attribute, so as to return the processing data meeting the requirements to the client side. For example, the time attribute may correspond to the third field, and thus, the server side may select processing data located within the time period within the third field from the processing data.
And step S04, receiving the processing data sent by the server and displaying the processing data in the report.
Specifically, the header names and fields of the report form in the file transmitted to the server by the client are corresponding to form one or more relation pairs, that is, the file contains one or more relation pairs. For example, the first header name and the first field are set to a first relationship pair, the second header name and the second field are set to a second relationship pair, and the third header name and the third field are set to a third relationship pair. The server side can return the processing data to the client side according to the corresponding relation contained in the file and the line record of the report. That is, the processing data returned to the client by the server may include one or more row records, where each row record includes cell data corresponding to each header of the report. It may be understood that, in each row record, the cell data corresponding to a header may be empty, and at this time, the corresponding relationship pair in the processing data returned to the client by the server may be set to be empty.
After the client receives the processing data, the processing data can be analyzed to obtain the data of the relation pair corresponding to each row of records, and the value of the relation pair corresponding to each row of records can be displayed in the report, so that the purposes of updating and customizing the report are achieved.
In summary, the report customization method provided by the invention includes generating a data driving model according to a header name contained in a report, wherein the header name is associated with a field of a database in a server; receiving triggering operation corresponding to the report, and updating the data driving model according to the triggering operation; the updated data driving model is sent to a server, wherein the server selects corresponding processing data according to the updated data driving model; and receiving the processing data sent by the server and displaying the processing data in the report. The invention provides a data driving mode for a customized report, wherein the front end writes a data driving model to realize the dynamic addition and deletion of the table, can automatically configure the name of the table header according to service requirements, then sends the table header to a server end for data processing, returns a data processing result after the processing is finished, and dynamically displays the data driving report by a client end.
While the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention.
The following describes the functional modules and hardware structures of the client implementing the report customization method with reference to fig. 3 and fig. 4.
Example III
FIG. 3 is a functional block diagram of a report customization device according to a preferred embodiment of the present invention.
In some embodiments, the report customization means 30 runs in a client. The report customization means 30 may comprise a plurality of functional modules consisting of program code segments. Program code for each program segment in the report customization means 30 may be stored in memory and executed by at least one processor to perform (see fig. 2 and its associated description for details).
In this embodiment, the report customizing device 30 may be divided into a plurality of functional modules according to the functions performed by the report customizing device. The functional module may include: a generating module 301, a receiving module 302, a transmitting module 303 and a displaying module 304. The module referred to in the present invention refers to a series of computer program segments capable of being executed by at least one processor and of performing a fixed function, stored in a memory. In some embodiments, the function of each module will be described in detail in the following embodiments.
The generating module 301 is configured to generate a data driven model according to a header name contained in the report, where the header name is associated with a field in the database.
It will be appreciated that the user may obtain a web page containing a report from the server side through the browser of the client side. The report may include one or more headers, each header may include one or more cells, each row may include a corresponding number of cells of the header, the cells comprising the contents of the rows and columns of the report. The data of the cells can correspond to the content in the formats of numerical type, character type, date type, time type and the like.
Preferably, for HTML, the headers may be represented by TH, each header having a header name, specifically, being set by name attribute of TH in HTML; each row may be represented by HR; each cell may be represented by TD. It will be appreciated that for a report, it contains different headers each with a unique or different header name to facilitate differentiation.
In this embodiment, one or more header names included in the report may be obtained to generate the data-driven model. The header name of the report can be bound with a database at the server side. For example, the report may include a first header name and a sensitive header name, and the database at the server may include a first field, a second field, and a third field, where the first field, the second field, and the third field may be located in the same or different data tables. The first header name in the report may be bound to the first field, and the second header name may be bound to the second field. In an embodiment, the binding relationship between the header name of the report and the server may be stored in a file, such as a JSON or XML file.
It will be appreciated that the header level of the report may include one or more layers. The file also contains the hierarchical relationship corresponding to the header. When the header of the report includes multiple layers, it means that the header may include a parent header and one or more child headers, each of which may in turn include one or more secondary child headers.
The receiving module 302 is configured to receive a trigger operation corresponding to the report, and update the data driving model according to the trigger operation.
When the report is edited, a corresponding trigger operation may be generated, wherein the editing operation may include, but is not limited to, adding a header, deleting a header, selecting a header, etc., and the client may generate the trigger operation according to the editing operation of the user. Specifically, adding a header, deleting a header, selecting a header, etc. may set corresponding operation buttons, e.g., when the operation buttons are clicked, corresponding trigger operations may be generated.
Preferably, the data driven model may be updated according to the triggering operation. The triggering operation includes adding a header, deleting a header, and selecting a header.
When the triggering operation is an operation of adding a header, a header can be newly added in the report. In an embodiment, when a header is newly added, the newly added header may be bound or associated with a field stored in the server, for example, the newly added header is bound with the third field. Preferably, when the header is newly added, the client may prompt the user whether to perform the data binding operation, or display a drop-down frame at the newly added header, where the drop-down frame displays bindable field contents. The value of the header may be achieved through user customization. When the report newly adds the header, the header name of the newly added header can be added into the data driving model.
It can be understood that, when the header includes multiple levels, the client may acquire the level of the header corresponding to the trigger operation, and may acquire the corresponding parent header according to the triggered header, and then may newly add a child header under the parent header, where the newly added child header and the triggered header are in a parallel relationship and are located in the same level. For example, the second header is included under the first header, when the second header triggers the operation of adding the header newly, the parent header of the second header may be obtained, that is, the first header, and at this time, a fourth header may be added under the first header newly, where the second header and the fourth header are located at the same level. The data driven model may then be updated based on the header.
When the triggering operation is an operation of deleting the header, the corresponding header in the report can be deleted. When the header is deleted, the header name corresponding to the data driving model can be deleted, so that the purpose of updating the data driving model is achieved.
And when the triggering operation is the operation of selecting the header, the header corresponding to the report can be selected and displayed. When the corresponding header in the report is selected, the header name corresponding to the data driving model can be updated to the selected header, so that the purpose of updating the data driving model is achieved.
It will be appreciated that in one embodiment, a selection box may be displayed in the browser of the client, in which the user may perform a lookup of the header value, including but not limited to an exact lookup, a fuzzy lookup (e.g., a wild card lookup), etc. The corresponding header can be selected in the result of the search. In another embodiment, a drop-down frame may also be displayed in the browser of the client, where all headers included in the report may be displayed in the drop-down frame, and the drop-down frame may be single-selected or multi-selected. When the corresponding header is selected in the drop-down frame, the data driving model can be updated to the header name corresponding to the selected header.
In one embodiment, the data driven model further includes a time attribute. Since there may be time type cells in the header, or there may be one or more columns of data with time attributes in the header. At this time, a time selection box may be displayed in the browser of the client, which may be used to set a time period, which may have a start time and an end time. When the corresponding time period is selected in the time selection frame, the time period can be used as the time attribute of the data driving model. The time attribute of the data driven model may also be transmitted to the server side.
The sending module 303 is configured to send the updated data driving model to a server, where the server selects corresponding processing data according to the data driving model.
It can be understood that, after the data driving model is updated, the updated data driving model may be transmitted to the server, and the server selects corresponding processing data according to the data driving model, so as to obtain the processing data corresponding to the data driving model.
In this embodiment, the format in which the processing data is stored in the server may be a numeric type, a character type, a date type, a time type, or the like.
Preferably, the client may transmit the JSON or XML file of the corresponding data driven model to the server, and the server may parse the file and then execute the corresponding query action, and may return the processing data obtained by the query to the client.
In one embodiment, when the data-driven model includes the time attribute, the server side further performs a filtering operation on the processing data according to the time attribute, so as to return the processing data meeting the requirements to the client side. For example, the time attribute may correspond to the third field, and thus, the server side may select processing data located within the time period within the third field from the processing data.
The display module 304 is configured to receive the processing data sent by the server, and display the processing data in the report.
Specifically, the header names and fields of the report form in the file transmitted to the server by the client are corresponding to generate one or more relation pairs, that is, the file contains one or more relation pairs. For example, the first header name and the first field are set to a first relationship pair, the second header name and the second field are set to a second relationship pair, and the third header name and the third field are set to a third relationship pair. The server side can return the processing data to the client side according to the corresponding relation contained in the file and the line record of the report. That is, the processing data returned to the client by the server may include one or more row records, where each row record includes cell data corresponding to each header of the report. It may be understood that, in each row record, the cell data corresponding to a header may be empty, and at this time, the corresponding relationship pair in the processing data returned to the client by the server may be set to be empty.
After the client receives the processing data, the processing data can be analyzed to obtain the data of the relation pair corresponding to each row of records, and the value of the relation pair corresponding to each row of records can be displayed in the report, so that the purposes of updating and customizing the report are achieved.
In summary, the report customization device 30 of the present invention includes a generating module 301, a receiving module 302, a sending module 303, and a display module 304. The generating module 301 is configured to generate a data driving model according to a header name contained in the report, where the header name is associated with a field of a database in the server; the receiving module 302 is configured to receive a trigger operation corresponding to the report, and update the data driving model according to the trigger operation; the sending module 303 is configured to send the updated data driving model to a server, where the server selects corresponding processing data according to the updated data driving model; and the display module 304 is configured to receive the processing data sent by the server, and display the processing data in the report. The invention provides a data driving mode for a customized report, wherein the front end writes a data driving model to realize the dynamic addition and deletion of the table, can automatically configure the name of the table header according to service requirements, then sends the table header to a server end for data processing, returns a data processing result after the processing is finished, and dynamically displays the data driving report by a client end.
The integrated units implemented in the form of software functional modules described above may be stored in a computer readable storage medium. The software functional modules described above are stored in a storage medium and include instructions for causing a computer device (which may be a personal computer, a dual-screen device, or a network device, etc.) or processor (processor) to perform portions of the methods described in the various embodiments of the invention.
Fig. 4 is a schematic diagram of a client according to a fourth embodiment of the present invention.
The client 1 includes: a memory 41, at least one processor 42, a computer program 43 stored in the memory 41 and executable on the at least one processor 42, and at least one communication bus 44.
The at least one processor 42, when executing the computer program 43, implements the steps of the report customization method embodiment described above.
Illustratively, the computer program 43 may be partitioned into one or more modules/units that are stored in the memory 41 and executed by the at least one processor 42 to complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing a specific function for describing the execution of the computer program 43 in the client 1.
The client 1 may be a mobile phone, a tablet computer, a Personal digital assistant (Personal DIGITAL ASSISTANT, PDA), or the like, which is provided with an application program. It will be appreciated by those skilled in the art that the schematic diagram 4 is merely an example of the client 1, and does not constitute a limitation of the client 1, and may include more or less components than illustrated, or may combine certain components, or different components, e.g. the client 1 may further include input and output devices, network access devices, buses, etc.
The at least one Processor 42 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (DIGITAL SIGNAL Processor, DSP), application SPECIFIC INTEGRATED Circuit (ASIC), off-the-shelf Programmable gate array (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware components, or the like. The processor 42 may be a microprocessor or the processor 42 may be any conventional processor or the like, the processor 42 being a control center of the client 1, the various interfaces and lines being used to connect the various parts of the entire client 1.
The memory 41 may be used to store the computer program 43 and/or modules/units, and the processor 42 may implement the various functions of the client 1 by running or executing the computer program and/or modules/units stored in the memory 41 and invoking data stored in the memory 41. The memory 41 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program (such as a sound playing function, an image playing function, etc.) required for at least one function, and the like; the storage data area may store data (such as audio data, phonebook, etc.) created according to the use of the client 1, and the like. In addition, memory 41 may include high-speed random access memory, and may also include non-volatile memory, such as a hard disk, memory, plug-in hard disk, smart memory card (SMART MEDIA CARD, SMC), secure Digital (SD) card, flash memory card (FLASH CARD), at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device.
The modules/units integrated by the client 1 may be stored in a computer readable storage medium if implemented in the form of software functional units and sold or used as a stand alone product. Based on such understanding, the present invention may implement all or part of the flow of the method of the above embodiment, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, where the computer program, when executed by a processor, may implement the steps of each of the method embodiments described above. Wherein the computer program comprises computer program code which may be in source code form, object code form, executable file or some intermediate form etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), an electrical carrier signal, a telecommunications signal, a software distribution medium, and so forth. It should be noted that the computer readable medium contains content that can be appropriately scaled according to the requirements of jurisdictions in which such content is subject to legislation and patent practice, such as in certain jurisdictions in which such content is subject to legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunication signals.
In the several embodiments provided in the present invention, it should be understood that the disclosed electronic device and method may be implemented in other manners. For example, the above-described embodiments of the electronic device are merely illustrative, and for example, the division of the units is merely a logical function division, and there may be other manners of division when actually implemented.
In addition, each functional unit in the embodiments of the present invention may be integrated in the same processing unit, or each unit may exist alone physically, or two or more units may be integrated in the same unit. The integrated units can be realized in a form of hardware or a form of hardware and a form of software functional modules.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it will be obvious that the term "comprising" does not exclude other elements or that the singular does not exclude a plurality. A plurality of units or means recited in the system claims can also be implemented by means of software or hardware by means of one unit or means. The terms first, second, etc. are used to denote a name, but not any particular order.
Finally, it should be noted that the above-mentioned embodiments are merely for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications and equivalents may be made to the technical solution of the present invention without departing from the spirit and scope of the technical solution of the present invention.

Claims (7)

1. The report customization method is applied to a client, and the client is in communication connection with a server, and is characterized by comprising the following steps:
generating a data driving model according to a header name contained in the report, wherein the header name is associated with a field of a database in a server, and the data driving model further comprises a time attribute;
receiving triggering operation corresponding to the report, and updating the data driving model according to the triggering operation;
The updated data driving model is sent to a server, wherein the server selects corresponding processing data according to the updated data driving model, and the server also carries out filtering operation on the processing data according to the time attribute so as to return the processing data meeting the requirements to the client;
The method comprises the steps that a header name and a field of a report in a file transmitted to a server by a client are corresponding to generate one or more relation pairs, the one or more relation pairs are stored in the file, wherein the file is a JSON or XML file, the hierarchy of the header of the report comprises one or more layers, the file comprises the hierarchy relation corresponding to the header, when the hierarchy of the header of the report comprises multiple layers, the header comprises a father header and one or more child headers, each child header comprises one or more secondary child headers, when the header comprises multiple layers, the client acquires the hierarchy of the header corresponding to the triggering operation, acquires the corresponding father header according to the triggered header, then a child header is newly added under the father header, and the newly added child header and the triggered header are in parallel relation and are located in the same hierarchy;
receiving the processing data sent by the server and analyzing the processing data;
And acquiring data of the relation pair corresponding to each row of records in the report, and displaying the value of the relation pair corresponding to each row of records in the report.
2. The report customization method in accordance with claim 1, wherein the triggering operation includes adding a header, deleting a header, and selecting a header.
3. The report customization method as set forth in claim 2, wherein:
When the triggering operation is an operation of adding a header, a header is newly added in the report, and the data driving model is updated according to the newly added header;
When the triggering operation is an operation of deleting the header, deleting the corresponding header in the report, thereby updating the data driving model;
When the triggering operation is the operation of selecting the header, selecting the header corresponding to the displayed report, and updating the header name corresponding to the data driving model to the selected header, thereby updating the data driving model.
4. The report customization method of claim 1, wherein the sending the updated data-driven model to a server, wherein the server selecting corresponding process data according to the updated data-driven model includes:
transmitting a corresponding JSON or XML file in the data driving model to the server;
The server analyzes the file and then executes corresponding query actions;
and the server sends the processing data obtained by query to the client.
5. A report customization device, the device comprising:
The generation module is used for generating a data driving model according to the header names contained in the report, wherein the header names are associated with fields of a database in the server, and the data driving model further comprises time attributes;
The receiving module is used for receiving triggering operation corresponding to the report and updating the data driving model according to the triggering operation;
The sending module is used for sending the updated data driving model to a server, wherein the server selects corresponding processing data according to the updated data driving model, and the server also carries out filtering operation on the processing data according to the time attribute so as to return the processing data meeting the requirements to a client; and
The display module is used for corresponding the header names and fields of the report in the file transmitted to the server by the client to generate one or more relation pairs, storing the one or more relation pairs in the file, wherein the file is a JSON or XML file, the header level of the report comprises one or more layers, the file comprises a level relation corresponding to the header, when the header level of the report comprises multiple layers, the header comprises a father header and one or more son headers, each son header comprises one or more son headers, when the header comprises multiple layers, the client acquires the level of the header corresponding to the triggering operation, acquires the corresponding father header according to the triggered header, then adds a son header under the father header, and the added son header and the triggered header are in parallel relation and are positioned in the same level; receiving the processing data sent by the server and analyzing the processing data; and acquiring data of the relation pair corresponding to each row of records in the report, and displaying the value of the relation pair corresponding to each row of records in the report.
6. A client comprising a processor and a memory, wherein the processor is configured to implement the report customization method according to any of claims 1 to 4 when executing a computer program stored in the memory.
7. A computer readable storage medium having a computer program stored thereon, wherein the computer program when executed by a processor implements the report customization method according to any of claims 1 to 4.
CN201910064679.3A 2019-01-23 2019-01-23 Report customization method, device, client and storage medium Active CN109918067B (en)

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 CN109918067A (en) 2019-06-21
CN109918067B true 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)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114564270B (en) * 2022-03-03 2024-02-06 平安国际融资租赁有限公司 List component rendering and front-end display method, device, equipment and medium of page
CN114417802B (en) * 2022-03-22 2022-06-10 创意信息技术股份有限公司 Intelligent report generation system

Citations (9)

* Cited by examiner, † Cited by third party
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
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

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10037314B2 (en) * 2013-03-14 2018-07-31 Palantir Technologies, Inc. Mobile reports

Patent Citations (9)

* Cited by examiner, † Cited by third party
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
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)

* Cited by examiner, † Cited by third party
Title
基于ActiveX的EIP动态报表系统;陈叶能 等;兵工自动化;20070515;第26卷(第05期);第86-88页 *

Also Published As

Publication number Publication date
CN109918067A (en) 2019-06-21

Similar Documents

Publication Publication Date Title
US9778920B2 (en) Mobile design patterns
CN109725901B (en) Front-end code development method, device, equipment and computer storage medium
CN101308489B (en) Electronic table statement type size variable list
CN110297636B (en) Page automatic generation and parameter management method, system and device based on page configuration file
CN107818074A (en) A kind of generation method of data report, device and electronic equipment
CN109918067B (en) Report customization method, device, client and storage medium
US11677807B2 (en) System and method to standardize and improve implementation efficiency of user interface content
CN110888974A (en) Data visualization method and device
CN114385164A (en) Page generation and rendering method and device, electronic equipment and storage medium
CN113360211A (en) Loading display method based on control and related equipment
CN111338625B (en) Data processing method, system, terminal equipment and storage medium
CN113741860A (en) Data processing method and device based on RPA robot
CN108595173A (en) The generation method and device of user interface, electronic device and computer storage media
CN115495519A (en) Report data processing method and device
CN114968235A (en) Page form generation method and device, computer equipment and storage medium
JP2002108677A (en) Device for managing document and method for the same and storage medium
CN115114280A (en) Report generation processing method, device and equipment
CN110362805B (en) Content typesetting recommendation method and device and terminal equipment
CN112579664A (en) Processing method and device for chart linkage
KR102181579B1 (en) Method for providing patient information sticker service and dental insurance claim system therefor
WO2024077937A1 (en) Data generation method and apparatus, electronic device, and storage medium
CN104133872B (en) A kind of news list methods of exhibiting and device
US20240037325A1 (en) Ability to add non-direct ancestor columns in child spreadsheets
CN102171693B (en) Method, apparatus and computer program product for providing multi-dimensional manipulations to context models
CN116595088A (en) Graph data display method, system and computer readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant