CN116431664A - Business report display method and device, electronic equipment and storage medium - Google Patents
Business report display method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116431664A CN116431664A CN202310399215.4A CN202310399215A CN116431664A CN 116431664 A CN116431664 A CN 116431664A CN 202310399215 A CN202310399215 A CN 202310399215A CN 116431664 A CN116431664 A CN 116431664A
- Authority
- CN
- China
- Prior art keywords
- report
- information
- query
- target
- business
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000013500 data storage Methods 0.000 claims abstract description 42
- 238000012790 confirmation Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000009877 rendering Methods 0.000 claims abstract description 17
- 230000004044 response Effects 0.000 claims abstract description 17
- 238000004590 computer program Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 5
- 230000004927 fusion Effects 0.000 claims description 4
- 238000011161 development Methods 0.000 abstract description 10
- 230000006870 function Effects 0.000 description 25
- 238000004891 communication Methods 0.000 description 6
- 238000012827 research and development Methods 0.000 description 6
- 238000001514 detection method Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000013461 design Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000001133 acceleration Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 230000005484 gravity Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000010295 mobile communication Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000005236 sound signal Effects 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013501 data transformation Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000011068 loading method Methods 0.000 description 1
- 238000013486 operation strategy Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000010897 surface acoustic wave method Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method, a device, electronic equipment and a storage medium for displaying a business report; displaying a report type selection page comprising a report type selection control through a display module, displaying a condition setting page comprising a condition setting control and a query confirmation control and determining a target query data source in response to operation of the report type selection control, generating report query parameter information in response to operation of the condition setting control and operation of the query confirmation control, determining report content information and report display style information through a report query interface based on the report query parameter information and the target query data source, transmitting the report content information and the report display style information from a data storage module through a page rendering interface, processing the report content information according to the report display style information at the display module, and generating and displaying a target business report; human resources can be saved, and the development efficiency of the business report query function is improved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for displaying a business report, an electronic device, and a storage medium.
Background
With the current rapid development of economy and technology, many different types of services, such as loan services, financial services, etc., are often carried in financial-type applications. And different services may also be provided with the function of business report queries.
At present, the main method adopted when setting the service report inquiry function for different types of services in the same application program is that a developer designs and develops the service report inquiry function of the type of services independently according to the requirements of the different types of services. However, by adopting the scheme, the service report query function of different types of services cannot achieve program multiplexing and configuration, and the scheme is very dependent on human resources of developers, so that the development efficiency of the service report query function is not improved.
Disclosure of Invention
The embodiment of the invention provides a business report display method, a business report display device, electronic equipment and a storage medium, which can reduce the dependence on manpower, save the manpower resources of developers and improve the development efficiency of a business report query function on the basis of ensuring the availability of the business report query function.
The embodiment of the invention provides a service report displaying method, which comprises the following steps:
displaying a report type selection page through a display module, wherein the report type selection page comprises a report type selection control;
responding to report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module;
responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control, and generating report query parameter information;
determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
and in the display module, processing the report content information according to the report display style information, generating a target business report, and displaying the target business report.
Correspondingly, the embodiment of the invention provides a service report display device, which comprises:
the first page display unit is used for displaying a report type selection page through the display module, wherein the report type selection page comprises a report type selection control;
the second page display unit is used for responding to the report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in the data storage module;
the information generating unit is used for responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control to generate report query parameter information;
the information query unit is used for determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
the information transmission unit is used for transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
And the report display unit is used for processing the report content information according to the report display style information in the display module, generating a target business report and displaying the target business report.
Correspondingly, the embodiment of the invention also provides electronic equipment, which comprises a memory and a processor; the memory stores an application program, and the processor is configured to run the application program in the memory, so as to execute steps in any one of the business report display methods provided by the embodiments of the present invention.
Correspondingly, the embodiment of the invention also provides a computer readable storage medium which stores a plurality of instructions, wherein the instructions are suitable for being loaded by a processor to execute the steps in any business report display method provided by the embodiment of the invention.
In addition, the embodiment of the invention also provides a computer program product, which comprises a computer program or instructions, wherein the computer program or instructions realize the steps in any business report display method provided by the embodiment of the invention when being executed by a processor.
By adopting the scheme of the embodiment of the invention, the report type selection page can be displayed through a display module, the report type selection page comprises a report type selection control, a condition setting page is displayed in response to report type selection operation aiming at the report type selection control, and a target query data source is determined, the condition setting page comprises a condition setting control and a query confirmation control, the target query data source is stored in a data storage module, a report query parameter information is generated in response to query condition setting operation on the condition setting control and triggering operation on the query confirmation control, report content information and report display style information are determined from the data storage module through a preset report query interface based on the report query parameter information and the target query data source, the report content information and the report display style information are transmitted to the display module through a preset page rendering interface, and in the display module, a target report is generated according to the report display style information; in the embodiment of the invention, different report types are corresponding to the query data sources, and the generation of the target business report does not need to develop an independent program interface according to the report types, but is realized based on the preset report query interface and page rendering interface uniformly, so that the dependence on manpower can be reduced, the manpower resources of developers are saved, and the development efficiency of the business report query function is improved on the basis of ensuring the availability of the business report query function.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic view of a scenario of a business report display method provided by an embodiment of the present invention;
FIG. 2 is a flowchart of a method for displaying a business report according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a report type selection page provided by an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a service report display device according to an embodiment of the present invention;
FIG. 5 is another schematic diagram of a business report display device according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. 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 fall within the scope of the invention.
The embodiment of the invention provides a service report display method, a device, electronic equipment and a computer readable storage medium. Specifically, the embodiment of the invention provides a service report display method suitable for a service report display device, and the service report display device can be integrated in electronic equipment.
The electronic device may be a terminal or the like, including but not limited to a mobile terminal and a fixed terminal, for example, a mobile terminal including but not limited to a smart phone, a smart watch, a tablet computer, a notebook computer, a smart car, etc., wherein the fixed terminal includes but not limited to a desktop computer, a smart television, etc.
The electronic device may be a server, which may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server that provides cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN (Content Delivery Network ), and basic cloud computing services such as big data and artificial intelligence platform, but is not limited thereto.
The business report display method of the embodiment of the invention can be realized by a server or a terminal and the server together.
The method for displaying the business report is taken as an example for jointly realizing the business report by the terminal and the server, and the method is described below.
As shown in fig. 1, the service report display system provided by the embodiment of the invention includes a terminal 10, a server 20, and the like; the terminal 10 and the server 20 are connected through a network, for example, a wired or wireless network connection, etc., wherein the terminal 10 may exist as a terminal provided with a display module.
The terminal 10 may be configured to display, through a display module, a report type selection page, where the report type selection page includes a report type selection control, display a condition setting page in response to a report type selection operation for the report type selection control, and determine a target query data source, where the condition setting page includes a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module, and generate report query parameter information in response to a query condition setting operation for the condition setting control and a trigger operation for the query confirmation control.
The server 20 may be provided with a data storage module, configured to determine, based on the report query parameter information and the target query data source, report content information and report display style information from the data storage module through a preset report query interface, and transmit, from the data storage module, the report content information and the report display style information to the display module through a preset page rendering interface.
The terminal 10 may be configured to process the report content information in the display module according to the report display style information, generate a target service report, and display the target service report.
The following will describe in detail. The following description of the embodiments is not intended to limit the preferred embodiments.
The embodiment of the invention will be described from the viewpoint of a business report display device, which can be integrated in a terminal and/or a server in particular.
As shown in fig. 2, the specific flow of the business report displaying method of this embodiment may be as follows:
201. and displaying a report type selection page through a display module, wherein the report type selection page comprises a report type selection control.
The display module is a module related to display in the service report display device, including but not limited to a display screen, a controller of the display screen, and the like.
Optionally, the report type selection page may be used by the user to select the type of the business report to be displayed. For example, the report type selection page may be as shown at 301 in FIG. 3. The user can select the report type selection control triggering the trade report according to the actual demand, or can select the report type selection control triggering the order report.
The report type selection control corresponds to different report types. For example, a statement type selection control named "trade statement" corresponds to the trade statement type. Specifically, the report type selection control and the report type corresponding to the report type selection control can be set by a technician according to actual requirements, and the embodiment of the invention is not limited to the setting.
In daily life, the operation statistics report of the merchant end of the open bank is currently realized by adopting a traditional development mode to walk a conventional data type research and development flow, for example, aiming at each API product such as a vehicle fusion owner credit API, a MAX card API, a financial cooperation API and the like, the research and development flow of big data, development resource scheduling, version date release and the like is related through demand analysis, front and back end development and online adjustment, and the method has the following defects:
The online operation can take 1 to 2 months, the customer experience is poor, the delivery timeliness is low, and the requirements of closed-loop data analysis and quick adjustment operation strategies of Internet head merchants and viewing of marketing campaign operation effects cannot be met.
At present, a set of authority control components, a set of front-end and back-end joint debugging mechanism and a set of front-end patterns which are independently developed are independently designed aiming at each API product, and multiplexing and collocation cannot be achieved.
The applicant finds through analysis that the operation report style of the merchant is generally a list display page and downloadable excel, the mode is basically fixed, only the header fields are different, the display order is different, the ordering rule is different, and aiming at the same point of the report, the unified processing of the same set of codes is not realized at present, and the problem of partial code redundancy exists.
After the data warehouse is subjected to big data acquisition and processing, new hive to db is created to pull the merchant operation data in the data warehouse into an open bank big data system database for storage.
Wherein hive is a data warehouse tool based on Hadoop for data extraction, transformation and loading, which is a mechanism that can store, query and analyze large-scale data stored in Hadoop.
By the business report display method provided by the embodiment of the invention, the previous mode that the report needs to be scheduled and developed at the front end and the rear end according to each report requirement can be abandoned, and parameters such as the table name, the field English name, the Chinese name, the ordering field, the ordering rule, whether the list is hidden or not and the like are only required to be configured at the rear end of an open bank, so that a official report can be generated by one key for a merchant to check and support real-time adjustment, and the autonomy of a product manager on the product design is enhanced.
202. And responding to report type selection operation aiming at the report type selection control, displaying a condition setting page, and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module.
Specifically, the condition setting page is a page on which a user sets a query condition corresponding to data in a business report to be generated. For example, the condition settings page may be as shown at 302 in FIG. 3.
Optionally, the condition setting control may be used by the user to trigger setting of the data query condition. For example, the user may set one or more conditions to search for data required for the business report.
The query confirmation control may be a control named "click query" in 302 of fig. 3. It will be appreciated that the form of the query validation control, the content displayed therein, etc. may be set by the skilled artisan, and the embodiments of the invention are not limited in this regard.
In the embodiment of the invention, the data storage module may store the query data source in advance. The target person query data source is the query data source determined according to the data query conditions set by the user through the condition setting control.
203. And generating report query parameter information in response to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control.
In some optional embodiments, the condition setting control includes at least one service report parameter setting control, and the step of generating report query parameter information "in response to a query condition setting operation on the condition setting control and a triggering operation on the query confirmation control may specifically include:
responding to the parameter setting operation of the business report parameter setting control, and determining report parameters corresponding to the parameter setting operation;
and responding to the triggering operation of the query confirmation control, and taking the report parameters as report query parameter information.
204. And determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source.
In some optional embodiments, the step of determining, based on the report query parameter information and the target query data source, report content information and report display style information from the data storage module through a preset report query interface may specifically include:
determining a target storage position corresponding to the target query data source in the data storage module based on the target query data source;
accessing the target storage position through a preset report query interface according to the report query parameter information to obtain report identification information;
and inquiring the target storage position through the report inquiry interface based on the report identification information to obtain report content associated information and report display style information.
Optionally, the report query interface includes a report identification information query interface and a report associated information query interface, and the step of accessing the target storage location through a preset report query interface according to the report query parameter information to obtain report identification information specifically may include:
Accessing the target storage position through the report identification information query interface according to the report query parameter information to obtain report identification information;
correspondingly, the step of inquiring the target storage position through the report inquiry interface based on the report identification information to obtain report content associated information and report display style information includes:
and inquiring the target storage position through the report related information inquiring interface based on the report identification information to obtain report content related information and report display style information.
Only 3 interfaces need to be written in the technical realization of report content inquiry: the method comprises the steps of inquiring an interface of a table name (obtaining a unique code of a bottom table and the table name), inquiring an interface of a table header and a parameter entering condition (inquiring a field name of a related table header and a paging front-end component style according to the unique code of the table), inquiring an interface of a general paging (executing the spliced sql inquiry data and returning the data to a front-end rendering page). Wherein, the front end and the back end can be realized by only one set of codes.
In some optional embodiments, the step of "inquiring the target storage location through the report inquiry interface based on the report identification information to obtain report content related information and report display style information" may specifically include:
Determining the table name information of a data table corresponding to the target business report based on the report identification information and the corresponding relation between the preset target business report and the data table;
determining field information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the data table field;
determining query condition information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the query condition of the data table;
generating target query information according to the table name information, the field information and the query condition information;
and inquiring the target storage position through the report inquiry interface according to the target inquiry information to obtain report content associated information and report display style information.
Inquiring the table name splicing sql of the data to be inquired into the obp _auto_report table by the unique code of the obp _auto_report table as [ select from table _name ];
inquiring the header field splicing sql of the table to be inquired into data by the unique code of the obp _auto_report table in the obp _auto_report_field table as [ select column 1, column 2 from table_name ];
Inquiring the inquiry condition of the report configuration in obp _auto_report_condition table through the unique code of obp _auto_report table, entering the parameters according to the specific inquiry condition transmitted from the front end, comparing through unique_code, and if the parameters are equal, indicating that the conditions need to be spliced to sql;
according to the type of page_type in the configured condition: a value of "1" indicates that the input box directly concatenates sql to "="; if Page_type is "2", it is indicated that the page condition is a date component; then the value is taken through the data_type, the data_type is equal to 1 as the starting date, the splicing sql "> =", the 2 as the ending date and the splicing sql as "<=";
each condition splice uses # { }, and the execution of sql by mybatis is a precompiled mode, and finally sql is [ select colum1, colum2 from table_name window colum1 = # { value1} and colum2> = # { value2} and colum2< = { value3} ].
The generating target query information according to the table name information, the field information and the query condition information includes:
and processing the table name information, the field information and the query condition information by a preset fusion logic to generate target query information.
205. And transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface.
206. And in the display module, processing the report content information according to the report display style information, generating a target business report, and displaying the target business report.
In some alternative embodiments, step "display the target business report" includes:
displaying the target business report on a business report display page, wherein the business report display page comprises a report downloading control;
correspondingly, the method for displaying the business report provided by the embodiment of the invention can further comprise the following steps:
and responding to the triggering operation of the report downloading control, and storing the target business report as a file format.
The business report of the official network is automatically generated by using a collocation mode, the research and development time of the business report can be shortened from 1 to 2 months to 1 day, simple requirements can be self-collocation by a product manager, the quick online of the business report can be realized without occupying research and development resources, the advantages of automation, intellectualization and extremely rapid are achieved after improvement, and the research and development efficiency and the business experience are greatly improved.
Meanwhile, the report generation technology can be utilized to popularize and try out in an open bank operation post-management or other application systems, and the design concept and the technology of automatic page generation in the scheme can be adopted for service request interfaces such as query class and downloading and the like which relate to single-table query or non-complex links in the system, so that the overall research and development efficiency can be greatly improved.
As can be seen from the foregoing, in the embodiment of the present invention, a report type selection page may be displayed through a display module, where the report type selection page includes a report type selection control, a condition setting page is displayed in response to a report type selection operation for the report type selection control, and a target query data source is determined, where the condition setting page includes a condition setting control and a query confirmation control, the target query data source is stored in a data storage module, and in response to a query condition setting operation for the condition setting control and a triggering operation for the query confirmation control, report query parameter information is generated, and based on the report query parameter information and the target query data source, report content information and report display style information are determined from the data storage module through a preset report query interface, and are transmitted from the data storage module to the display module through a preset page rendering interface, where the report content information is processed according to the report display style information, and a target report service is generated, and the target report service is displayed; in the embodiment of the invention, different report types are corresponding to the query data sources, and the generation of the target business report does not need to develop an independent program interface according to the report types, but is realized based on the preset report query interface and page rendering interface uniformly, so that the dependence on manpower can be reduced, the manpower resources of developers are saved, and the development efficiency of the business report query function is improved on the basis of ensuring the availability of the business report query function.
In order to better implement the method, correspondingly, the embodiment of the invention also provides a service report display device.
Referring to fig. 4, the apparatus includes:
a first page display unit 401, configured to display a report type selection page through a display module, where the report type selection page includes a report type selection control;
a second page display unit 402, configured to display a condition setting page in response to a report type selection operation for the report type selection control, and determine a target query data source, where the condition setting page includes a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module;
an information generating unit 403, configured to generate report query parameter information in response to a query condition setting operation on the condition setting control and a triggering operation on the query confirmation control;
the information query unit 404 is configured to determine report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
the information transmission unit 405 is configured to transmit, from the data storage module, the report content information and the report display style information to the display module through a preset page rendering interface;
And the report display unit 406 is configured to process the report content information according to the report display style information in the display module, generate a target service report, and display the target service report.
In some optional embodiments, the information query unit 404 is configured to determine, based on the target query data source, a target storage location corresponding to the target query data source in the data storage module;
accessing the target storage position through a preset report query interface according to the report query parameter information to obtain report identification information;
and inquiring the target storage position through the report inquiry interface based on the report identification information to obtain report content associated information and report display style information.
In some optional embodiments, the information query unit 404 is configured to access, according to the report query parameter information, the target storage location through the report identification information query interface, to obtain report identification information;
and inquiring the target storage position through the report related information inquiring interface based on the report identification information to obtain report content related information and report display style information.
In some optional embodiments, the information query unit 404 is configured to determine table name information of a data table corresponding to the target service report based on the report identifier information and a corresponding relationship between a preset target service report and the data table;
determining field information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the data table field;
determining query condition information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the query condition of the data table;
generating target query information according to the table name information, the field information and the query condition information;
and inquiring the target storage position through the report inquiry interface according to the target inquiry information to obtain report content associated information and report display style information.
In some optional embodiments, the information query unit 404 is configured to process the table name information, the field information, and the query condition information with preset fusion logic to generate target query information.
In some optional embodiments, the condition setting control includes at least one service report parameter setting control, and the information generating unit 403 is configured to determine, in response to a parameter setting operation on the service report parameter setting control, a report parameter corresponding to the parameter setting operation;
and responding to the triggering operation of the query confirmation control, and taking the report parameters as report query parameter information.
In some optional embodiments, the report display unit 406 is configured to display the target business report on a business report display page, where the business report display page includes a report download control;
as shown in fig. 5, the service report display device provided by the embodiment of the present invention further includes a report downloading unit 407, configured to store the target service report as a file format in response to a triggering operation for the report downloading control.
According to the method, a report type selection page can be displayed through a display module through a business report display device, the report type selection page comprises a report type selection control, a condition setting page is displayed in response to report type selection operation aiming at the report type selection control, and a target query data source is determined, the condition setting page comprises a condition setting control and a query confirmation control, the target query data source is stored in a data storage module, report query parameter information is generated in response to query condition setting operation of the condition setting control and triggering operation of the query confirmation control, report content information and report display style information are determined from the data storage module through a preset report query interface based on the report query parameter information and the target query data source, the report content information and the report display style information are transmitted to the display module through a preset page rendering interface, and in the display module, the report content information is processed according to the report display style information, and the target business report is generated, and the target business is displayed; in the embodiment of the invention, different report types are corresponding to the query data sources, and the generation of the target business report does not need to develop an independent program interface according to the report types, but is realized based on the preset report query interface and page rendering interface uniformly, so that the dependence on manpower can be reduced, the manpower resources of developers are saved, and the development efficiency of the business report query function is improved on the basis of ensuring the availability of the business report query function.
In addition, the embodiment of the present invention further provides an electronic device, which may be a terminal or a server, as shown in fig. 6, and shows a schematic structural diagram of the electronic device according to the embodiment of the present invention, specifically:
the electronic device may include Radio Frequency (RF) circuitry 601, memory 602 including one or more computer readable storage media, input unit 603, display unit 604, sensor 605, audio circuitry 606, wireless fidelity (WiFi, wireless Fidelity) module 607, processor 608 including one or more processing cores, and power supply 609. It will be appreciated by those skilled in the art that the electronic device structure shown in fig. 6 is not limiting of the electronic device and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
Wherein:
the RF circuit 601 may be used for receiving and transmitting signals during a message or a call, and in particular, after receiving downlink information of a base station, the downlink information is processed by one or more processors 608; in addition, data relating to uplink is transmitted to the base station. Typically, RF circuitry 601 includes, but is not limited to, an antenna, at least one amplifier, a tuner, one or more oscillators, a subscriber identity module (SIM, subscriber Identity Module) card, a transceiver, a coupler, a low noise amplifier (LNA, low Noise Amplifier), a duplexer, and the like. In addition, the RF circuitry 601 may also communicate with networks and other devices through wireless communications. The wireless communication may use any communication standard or protocol including, but not limited to, global system for mobile communications (GSM, global System of Mobile communication), general packet radio service (GPRS, general Packet Radio Service), code division multiple access (CDMA, code Division Multiple Access), wideband code division multiple access (WCDMA, wideband Code Division Multiple Access), long term evolution (LTE, long Term Evolution), email, short message service (SMS, short Messaging Service), and the like.
The memory 602 may be used to store software programs and modules that are stored in the memory 602 for execution by the processor 608 to perform various functional applications and data processing. The memory 602 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 created according to the use of the electronic device (such as audio data, phonebooks, etc.), and the like. In addition, the memory 602 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device. Accordingly, the memory 602 may also include a memory controller to provide access to the memory 602 by the processor 608 and the input unit 603.
The input unit 603 may be used to receive input numeric or character information and to generate keyboard, mouse, joystick, optical or trackball signal inputs related to user settings and function control. In particular, in one particular embodiment, the input unit 603 may include a touch-sensitive surface, as well as other input devices. The touch-sensitive surface, also referred to as a touch display screen or a touch pad, may collect touch operations thereon or thereabout by a user (e.g., operations thereon or thereabout by a user using any suitable object or accessory such as a finger, stylus, etc.), and actuate the corresponding connection means according to a predetermined program. Alternatively, the touch-sensitive surface may comprise two parts, a touch detection device and a touch controller. The touch detection device detects the touch azimuth of a user, detects a signal brought by touch operation and transmits the signal to the touch controller; the touch controller receives touch information from the touch detection device and converts it into touch point coordinates, which are then sent to the processor 608, and can receive commands from the processor 608 and execute them. In addition, touch sensitive surfaces may be implemented in a variety of types, such as resistive, capacitive, infrared, and surface acoustic waves. The input unit 603 may comprise other input devices in addition to a touch sensitive surface. In particular, other input devices may include, but are not limited to, one or more of a physical keyboard, function keys (such as volume control keys, switch keys, etc.), a trackball, mouse, joystick, etc.
The display unit 604 may be used to display information entered by a user or provided to a user as well as various graphical user interfaces of the electronic device, which may be composed of graphics, text, icons, video, and any combination thereof. The display unit 604 may include a display panel, which may be optionally configured in the form of a liquid crystal display (LCD, liquid Crystal Display), an Organic Light-Emitting Diode (OLED), or the like. Further, the touch-sensitive surface may overlay a display panel, and upon detection of a touch operation thereon or thereabout, the touch-sensitive surface is passed to the processor 608 to determine the type of touch event, and the processor 608 then provides a corresponding visual output on the display panel based on the type of touch event. Although in fig. 6 the touch sensitive surface and the display panel are implemented as two separate components for input and output functions, in some embodiments the touch sensitive surface may be integrated with the display panel to implement the input and output functions.
The electronic device may also include at least one sensor 605, such as a light sensor, a motion sensor, and other sensors. In particular, the light sensor may include an ambient light sensor that may adjust the brightness of the display panel according to the brightness of ambient light, and a proximity sensor that may turn off the display panel and/or backlight when the electronic device is moved to the ear. As one of the motion sensors, the gravity acceleration sensor can detect the acceleration in all directions (generally three axes), and can detect the gravity and the direction when the mobile phone is stationary, and can be used for applications of recognizing the gesture of the mobile phone (such as horizontal and vertical screen switching, related games, magnetometer gesture calibration), vibration recognition related functions (such as pedometer and knocking), and the like; other sensors such as gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc. that may also be configured with the electronic device are not described in detail herein.
WiFi belongs to a short-distance wireless transmission technology, and the electronic equipment can help a user to send and receive emails, browse webpages, access streaming media and the like through the WiFi module 607, so that wireless broadband Internet access is provided for the user. Although fig. 6 shows a WiFi module 607, it is understood that it does not belong to the necessary constitution of the electronic device, and can be omitted entirely as needed within the scope of not changing the essence of the invention.
The processor 608 is a control center of the electronic device that utilizes various interfaces and lines to connect the various parts of the overall handset, perform various functions of the electronic device and process data by running or executing software programs and/or modules stored in the memory 602, and invoking data stored in the memory 602. Optionally, the processor 608 may include one or more processing cores; preferably, the processor 608 may integrate an application processor that primarily handles operating systems, user interfaces, applications, etc., with a modem processor that primarily handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 608.
The electronic device also includes a power supply 609 (e.g., a battery) for powering the various components, which may be logically connected to the processor 608 via a power management system so as to perform functions such as managing charge, discharge, and power consumption via the power management system. The power supply 609 may also include one or more of any components, such as a direct current or alternating current power supply, a recharging system, a power failure detection circuit, a power converter or inverter, a power status indicator, and the like.
Although not shown, the electronic device may further include a camera, a bluetooth module, etc., which will not be described herein. Specifically, in this embodiment, the processor 608 in the electronic device loads executable files corresponding to the processes of one or more application programs into the memory 602 according to the following instructions, and the processor 608 executes the application programs stored in the memory 602, so as to implement various functions as follows:
displaying a report type selection page through a display module, wherein the report type selection page comprises a report type selection control;
responding to report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module;
Responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control, and generating report query parameter information;
determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
and in the display module, processing the report content information according to the report display style information, generating a target business report, and displaying the target business report.
Those of ordinary skill in the art will appreciate that all or a portion of the steps of the various methods of the above embodiments may be performed by instructions, or by instructions controlling associated hardware, which may be stored in a computer-readable storage medium and loaded and executed by a processor.
To this end, an embodiment of the present invention provides a computer readable storage medium having stored therein a plurality of instructions capable of being loaded by a processor to perform the steps of any one of the business report display methods provided by the embodiments of the present invention. For example, the instructions may perform the steps of:
Displaying a report type selection page through a display module, wherein the report type selection page comprises a report type selection control;
responding to report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module;
responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control, and generating report query parameter information;
determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
and in the display module, processing the report content information according to the report display style information, generating a target business report, and displaying the target business report.
The specific implementation of each operation above may be referred to the previous embodiments, and will not be described herein.
Wherein the computer-readable storage medium may comprise: read Only Memory (ROM), random access Memory (RAM, random Access Memory), magnetic or optical disk, and the like.
The steps in any business report display method provided by the embodiment of the present invention can be executed due to the instructions stored in the computer readable storage medium, so that the beneficial effects that any business report display method provided by the embodiment of the present invention can be achieved, and detailed descriptions of the previous embodiments are omitted herein.
According to one aspect of the present application, there is also provided a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The processor of the electronic device reads the computer instructions from the computer-readable storage medium and executes the computer instructions to cause the electronic device to perform the methods provided in the various alternative implementations of the embodiments described above.
The foregoing describes in detail a method, apparatus, electronic device and storage medium for displaying a business report according to the embodiments of the present invention, and specific examples are applied to illustrate the principles and embodiments of the present invention, where the foregoing description of the embodiments is only for helping to understand the method and core ideas of the present invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in light of the ideas of the present invention, the present description should not be construed as limiting the present invention.
Claims (11)
1. A business report display method is characterized by comprising the following steps:
displaying a report type selection page through a display module, wherein the report type selection page comprises a report type selection control;
responding to report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in a data storage module;
responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control, and generating report query parameter information;
determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
and in the display module, processing the report content information according to the report display style information, generating a target business report, and displaying the target business report.
2. The business report displaying method according to claim 1, wherein the determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source comprises:
determining a target storage position corresponding to the target query data source in the data storage module based on the target query data source;
accessing the target storage position through a preset report query interface according to the report query parameter information to obtain report identification information;
and inquiring the target storage position through the report inquiry interface based on the report identification information to obtain report content associated information and report display style information.
3. The business report display method according to claim 2, wherein the report query interface includes a report identification information query interface and a report associated information query interface, the accessing the target storage location through a preset report query interface according to the report query parameter information, to obtain report identification information, includes:
accessing the target storage position through the report identification information query interface according to the report query parameter information to obtain report identification information;
The step of inquiring the target storage position through the report inquiry interface based on the report identification information to obtain report content associated information and report display style information comprises the following steps:
and inquiring the target storage position through the report related information inquiring interface based on the report identification information to obtain report content related information and report display style information.
4. The business report display method according to claim 2, wherein the inquiring the target storage location through the report inquiry interface based on the report identification information to obtain report content related information and report display style information comprises:
determining the table name information of a data table corresponding to the target business report based on the report identification information and the corresponding relation between the preset target business report and the data table;
determining field information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the data table field;
determining query condition information of a data table corresponding to the target business report based on the report identification information and a corresponding relation between a preset target business report and the query condition of the data table;
Generating target query information according to the table name information, the field information and the query condition information;
and inquiring the target storage position through the report inquiry interface according to the target inquiry information to obtain report content associated information and report display style information.
5. The method for displaying a business report according to claim 4, wherein generating target query information according to the table name information, the field information and the query condition information comprises:
and processing the table name information, the field information and the query condition information by a preset fusion logic to generate target query information.
6. The business report display method of claim 1, wherein the condition setting control comprises at least one business report parameter setting control, and wherein generating report query parameter information in response to a query condition setting operation on the condition setting control and a triggering operation on the query confirmation control comprises:
responding to the parameter setting operation of the business report parameter setting control, and determining report parameters corresponding to the parameter setting operation;
and responding to the triggering operation of the query confirmation control, and taking the report parameters as report query parameter information.
7. The business report displaying method according to claim 1, wherein the displaying the target business report includes:
displaying the target business report on a business report display page, wherein the business report display page comprises a report downloading control;
the method further comprises the steps of:
and responding to the triggering operation of the report downloading control, and storing the target business report as a file format.
8. A business report display device, comprising:
the first page display unit is used for displaying a report type selection page through the display module, wherein the report type selection page comprises a report type selection control;
the second page display unit is used for responding to the report type selection operation aiming at the report type selection control, displaying a condition setting page and determining a target query data source, wherein the condition setting page comprises a condition setting control and a query confirmation control, and the target query data source is stored in the data storage module;
the information generating unit is used for responding to the query condition setting operation of the condition setting control and the triggering operation of the query confirmation control to generate report query parameter information;
The information query unit is used for determining report content information and report display style information from the data storage module through a preset report query interface based on the report query parameter information and the target query data source;
the information transmission unit is used for transmitting the report content information and the report display style information from the data storage module to the display module through a preset page rendering interface;
and the report display unit is used for processing the report content information according to the report display style information in the display module, generating a target business report and displaying the target business report.
9. An electronic device comprising a memory and a processor; the memory stores an application program, and the processor is configured to run the application program in the memory to perform the steps in the business report display method of any one of claims 1 to 7.
10. A computer readable storage medium storing a plurality of instructions adapted to be loaded by a processor to perform the steps in the business report display method of any of claims 1 to 7.
11. A computer program product comprising computer programs or instructions which when executed by a processor implement the steps of the business report display method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310399215.4A CN116431664A (en) | 2023-04-04 | 2023-04-04 | Business report display method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310399215.4A CN116431664A (en) | 2023-04-04 | 2023-04-04 | Business report display method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116431664A true CN116431664A (en) | 2023-07-14 |
Family
ID=87079360
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310399215.4A Pending CN116431664A (en) | 2023-04-04 | 2023-04-04 | Business report display method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116431664A (en) |
-
2023
- 2023-04-04 CN CN202310399215.4A patent/CN116431664A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108512695B (en) | Method and device for monitoring application blockage | |
| CN106970790B (en) | Application program creating method, related equipment and system | |
| US11798107B2 (en) | Scenario-based application recommendation method and apparatus | |
| US10304461B2 (en) | Remote electronic service requesting and processing method, server, and terminal | |
| CN108156508B (en) | Barrage information processing method and device, mobile terminal, server and system | |
| CN111178012A (en) | Form rendering method, device and equipment and storage medium | |
| CN113420051B (en) | Data query method and device, electronic equipment and storage medium | |
| CN113313804B (en) | Image rendering method and device, electronic equipment and storage medium | |
| CN108984374B (en) | Method and system for testing database performance | |
| CN112749074B (en) | Test case recommending method and device | |
| CN114115895A (en) | Code query method and device, electronic equipment and storage medium | |
| CN108268232B (en) | Picture display method, device, system and storage medium | |
| CN111359210B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN114510417A (en) | Image rendering effect testing method and device, electronic equipment and storage medium | |
| CN116431664A (en) | Business report display method and device, electronic equipment and storage medium | |
| CN109189576B (en) | Redis-based request processing method, server and computer-readable storage medium | |
| CN113886070A (en) | Device information management method, device and computer readable storage medium | |
| CN106681845B (en) | Method and device for managing communication messages | |
| CN111191998A (en) | Item processing method and device | |
| CN112328304B (en) | Script adaptation method, system, equipment and computer storage medium | |
| CN115237317B (en) | Data display method and device, electronic equipment and storage medium | |
| CN115640081A (en) | Business case decision method and device, electronic equipment and storage medium | |
| CN116069382A (en) | Transaction device configuration method, device, electronic device and storage medium | |
| CN117408232A (en) | Method and device for generating PDF format file of webpage, electronic equipment and storage medium | |
| CN117376120A (en) | Channel-configurable message pushing method, system, device and 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 |