Mobile end BI middleware technology based on application container
Technical Field
The invention relates to the technical field of BI (business information technology), in particular to a mobile terminal BI middleware technology based on an application container.
Background
With the popularity of smartphones, mobile offices are emerging. For convenience of people's office, various micro-applications for office have been developed. The portable office is convenient, and the portable office becomes an office mode expected by various industries, wherein the report forms are common office modes and are mainly used for reflecting data, so that the operations of statistics, viewing, calculation and the like of people are facilitated.
When the traditional report is checked, the access is carried out by using a PC end most of the time, and the access mode is not portable and inflexible. In order to solve the problems, the report view of the mobile terminal is developed, and various problems of the view of the PC terminal can be solved; however, the existing mobile terminal is not perfect enough to view the report, so that the user experience is poor, meanwhile, the viewing efficiency of the report is low, and the report cannot adapt to the large environment of the existing intelligent data coping, so that middleware is designed between the server and the mobile terminal to view the report, and more functions are set in the middleware, so that the report viewing becomes easy and convenient.
Disclosure of Invention
The invention aims to provide a mobile terminal BI middleware technology based on an application container.
To achieve the purpose, the invention adopts the following technical scheme:
providing a mobile terminal BI middleware technology based on an application container, wherein the middleware comprises middleware, and bridging is built between the application container and a report server; checking user data in the report form through bridging, synchronizing the user data of the report form into a local project library, and mapping the third party application user and the report form user;
setting a user mapping module, acquiring logged-in user information through an interface provided by an application container, distributing the logged-in user to a default group, and mapping the default group with report users in a report Server to realize mapping between the logged-in user and the users in the report Server;
the group and the report users are in one-to-one correspondence, different users are distributed into different groups, the authorities of the different groups are set, the same group corresponds to the same report user, and the authorities are the same;
setting a report request transfer module, after a user logs in, taking report user data according to the mapping, and splicing the URL of the accessed report through the function of accessing the report by the bill of the report to realize the function of checking the report;
setting a browsing history interface, after a user successfully accesses one report, storing accessed report data into history data of the user, wherein a database adopts an independent database, and when clicking a report in a history list, the report can be correspondingly displayed;
setting a report collection interface, wherein a user is interested in a certain workbook or report, clicking collection identification of the workbook or report page, and storing the workbook or report in a collection library of the user; clicking the collected report forms to display the report forms;
and setting a background management function for maintaining the mapping between the users and the groups, and maintaining the mapping aspects of the groups and the report users.
Further, the step of setting the user mapping module is as follows:
step one: logging in the user information and identifying through big data, recording the comparison information characteristics of the user information after comparison as a, setting x default groups, and endowing the x default groups with specific characteristics;
step two: comparing the characteristics of the comparison information a with the specific characteristics of the x default groups one by one, and displaying the comparison matching percentage;
step three: comparing the x percentages, taking out the maximum value, and corresponding the comparison information a with a default group n of the percentages;
step four: assigning the user information to a default group n;
step five: and respectively assigning rights to the x default groups, and respectively assigning corresponding rights to users in the x default groups.
Further, the step of setting the report request transfer module is as follows:
step one: after the report Server modifies the configuration of the report checked by the bill, a report request needs to be called to acquire the bill;
step two: splicing the acquired bill with the report server address and parameters to splice a URL;
step three: and giving the URL to a front-end page, accessing the front-end page by using the page, and displaying a report.
Further, when the report is displayed, the report is determined by calling a RestAPI of the report, when the RestAPI is called, a user name of the report is used, a password firstly acquires a token, the token is transmitted in a parameter form, and the workbook and the report data are acquired in a stream form; acquiring XML format data, analyzing the data through XML, finally packaging the data into classes, and returning to a front-end display page; each call needs to be taken from the report Server to the data, so that the real-time property of the data is ensured.
Further, the step of setting the browsing history interface is as follows:
step one: setting up a corresponding small database g1 for user information when a user logs in;
step two: when a user clicks and accesses a report, the accessed report data is set as n (n=1, 2, n) and is input into a small database g1;
step three: the report is endowed with marks m (m=1, 2, m), corresponding links are carried out on the report m and the report data n, the accessed report m data is input into a small database g1, and a history list is formed and displayed at the front end.
Further, in the user mapping module, a first login detection module is set, if the user does not exist in the middleware database during login, the user is allocated to a group x1 by default, x1 is a default report user, and the api of the report is called according to the user name password of the default report, the workbook data is taken, and the workbook data is displayed on a foreground page.
Furthermore, the background management is divided into 3 modules, namely 'report user management', 'group management', 'view management', and 'view management', wherein the view names can be modified, and the modified contents are local view names and display names.
Further, the report user management module maintains the password of the report user in a local library, when an API (application program interface) is used or the report library is queried, the report user name can be obtained, the password can not be obtained, the user name password of the report can be taken to a token when the view and the workbook list are displayed, and the related data of the report can be queried by calling a RestAPI after the password is transmitted to the token;
the group management module is used as an intermediate bridge for mapping the users and the report users, mainly maintains the user names and the report user names in the group management, and report user options in the group are displayed by inquiring the report user names and cannot be modified at will;
the view management module starts the aliases from the view names acquired from the report server and displays the aliases of the report when the page is displayed; the thumbnail of the report is obtained from the report server by default, and is uploaded to the local thumbnail through view management to replace the original view thumbnail.
Further, after the view data is displayed to the foreground, when a user clicks a certain Zhang Shitu, the user firstly obtains a corresponding bill according to the name of the report user, after the bill is obtained, the data such as IP of the bill and the report Server are added, some parameters needing to control the style are spliced, and the path after splicing is returned to the front-end page.
Furthermore, the middleware is matched with a third party application, and user data is transmitted to the middleware so as to carry out mapping maintenance with the report; in the code of the middleware, parameters are received, and user data is captured.
The invention has the beneficial effects that:
through the mobile terminal report middleware, the mobile terminal report middleware can be integrated with a report conveniently, report data of the report can be directly checked through a mobile phone, and mobile office of a client is facilitated.
1. The method overcomes the defect of mobile BI products in an open platform (or third party application).
2. And integrating the report service into the mobile micro-application ecology, and improving the ecology of report service users.
3. And opening the micro application or applet mobile entry of the original report server enterprise user, and unifying the entry.
4. And seamlessly integrating the user rights of the third-party application user and the report server, and improving user experience without secondary authentication for user access.
5. Perfect mobile terminal adaptation, original report interaction function is reserved, and horizontal screen mode report browsing is supported.
6. The multi-terminal access requirements of the private cloud and the public cloud of the report user are supported, and the non-sensing cloud access can be realized.
7. And (3) moving: and the user directly checks the report forms through the mobile phone.
8. Real-time: providing more realistic data in a shorter time
9. Self-help: time and cost are saved
10. Expanding: the middleware is a report and intermediate service, has strong expansibility, can change the report and the thumbnail, and then is displayed on the mobile terminal, and can change the name of the report and then is displayed on the mobile terminal.
Drawings
In order to more clearly illustrate the technical solution of the embodiments of the present invention, the drawings that are required to be used in the embodiments of the present invention will be briefly described below.
FIG. 1 is a mapping diagram of the present invention;
FIG. 2 is a report accessing flowchart of the present invention.
Detailed Description
The technical scheme of the invention is further described below by the specific embodiments with reference to the accompanying drawings.
Wherein the drawings are for illustrative purposes only and are shown in schematic, non-physical, and not intended to be limiting of the present patent; for the purpose of better illustrating embodiments of the invention, certain elements of the drawings may be omitted, enlarged or reduced in size and do not represent the actual product dimensions.
Referring to FIG. 1 and FIG. 2, the application container-based mobile end BI middleware technology includes middleware that bridges between the application container and the report server; checking user data in the report form through bridging, synchronizing the user data of the report form into a local project library, and mapping the third party user and the report form user;
setting a user mapping module, acquiring logged-in user information through an interface provided by an application container, distributing the logged-in user to a default group, and mapping the default group with report users in a report Server to realize mapping between the logged-in user and the users in the report Server;
the group and the report users are in one-to-one correspondence, different users are distributed into different groups, the authorities of the different groups are set, the same group corresponds to the same report user, and the authorities are the same;
setting a report request transfer module, after a user logs in, taking report user data according to the mapping, and splicing the URL of the accessed report through the function of accessing the report by the bill of the report to realize the function of checking the report;
setting a browsing history interface, after a user successfully accesses a report, storing accessed report data into history data of the user, wherein a database adopts an independent database, and when clicking a report in a history list, the report can be correspondingly displayed;
setting a report collection interface, wherein a user is interested in a certain workbook or report, clicking collection identification of a workbook or report page, storing the workbook or report in a collection library of the user, and when the user is in the same state as a history list, clicking the collected workbook in a display page collected by the user, and entering the workbook to list all reports under the workbook; clicking the collected report forms to display the report forms;
and setting a background management function for maintaining the mapping between the users and the groups, and maintaining the mapping aspects of the groups and the report users.
The step of setting the user mapping module is as follows:
step one: logging in the user information and identifying through big data, recording the comparison information characteristics of the user information after comparison as a, setting x default groups, and endowing the x default groups with specific characteristics;
step two: comparing the characteristics of the comparison information a with the specific characteristics of the x default groups one by one, and displaying the comparison matching percentage;
step three: comparing the x percentages, taking out the maximum value, and corresponding the comparison information a with a default group n of the percentages;
step four: assigning the user information to a default group n;
step five: and respectively assigning rights to the x default groups, and respectively assigning corresponding rights to users in the x default groups.
The report request transfer module is set as follows:
step one: after the report Server modifies the configuration of the report checked by the bill, a report request needs to be called to acquire the bill;
step two: splicing the acquired bill with the report server address and parameters to splice a URL;
step three: and giving the URL to a front-end page, accessing the front-end page by using the page, and displaying a report.
When the report is displayed, the report is decided by calling a RestAPI of the report, when the RestAPI is called, a user name of the report is used, a password firstly acquires a token, the token is transmitted in a parameter form, and the workbook and report data are acquired in a stream form; acquiring XML format data, analyzing the data through XML, finally packaging the data into classes, and returning to a front-end display page; each call needs to be taken from the report Server to the data, so that the real-time property of the data is ensured.
The steps of setting the browsing history interface are as follows:
step one: setting up a corresponding small database g1 for user information when a user logs in;
step two: when a user clicks and accesses a report, the accessed report data is set as n (n=1, 2, n) and is input into a small database g1;
step three: the report is endowed with marks m (m=1, 2, m), corresponding links are carried out on the report m and the report data n, the accessed report m data is input into a small database g1, and a history list is formed and displayed at the front end.
In the user mapping module, a first login detection module is set, if the user does not exist in the middleware database during login, the user is distributed to a group x1 by default, x1 is a default report user, and the api of the report is called according to a user name password of the default report, the workbook data is taken, and the workbook data is displayed on a foreground page.
The background management is divided into 3 modules, namely 'report user management', 'group management', 'view management', and 'view management' can modify view names, and the modification content is local view names and display names.
The report user management module is used for maintaining the passwords of the report user in a local library, acquiring the report user name when using an API or inquiring the report library, acquiring no passwords, taking a token only by the user name passwords of the report when displaying the view and the workbook list, calling a RestAPI after the passwords are transmitted into the token, and inquiring related data of the report;
the group management module is used as an intermediate bridge for mapping the users and the report users, mainly maintains the user names and the report user names in the group management, and report user options in the group are displayed by inquiring the report user names and cannot be modified at will;
the view management module starts the aliases from the view names acquired from the report server and displays the aliases of the report when the page is displayed; the thumbnail of the report is obtained from the report server by default, and is uploaded to the local thumbnail through view management to replace the original view thumbnail.
After the view data are displayed on the foreground, when a user clicks a certain Zhang Shitu, the user firstly takes a corresponding bill according to the name of the report user, after the bill is obtained, the bill, IP (Internet protocol) and other data of the report Server are added, some parameters needing to control the style are spliced, and the path after splicing is returned to the front-end page.
The middleware is matched with a third party application, user data is transmitted to the middleware, and mapping maintenance can be carried out on the user data and the report; in the code of the middleware, parameters are received, and user data is captured
The foregoing is merely illustrative of the structures of this invention and various modifications, additions and substitutions for those skilled in the art can be made to the described embodiments without departing from the scope of the invention or from the scope of the invention as defined in the accompanying claims.