CN107908659A - Data sheet collocation method, report platform and computer-readable recording medium - Google Patents
Data sheet collocation method, report platform and computer-readable recording medium Download PDFInfo
- Publication number
- CN107908659A CN107908659A CN201710967504.4A CN201710967504A CN107908659A CN 107908659 A CN107908659 A CN 107908659A CN 201710967504 A CN201710967504 A CN 201710967504A CN 107908659 A CN107908659 A CN 107908659A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- page
- terminal
- data sheet
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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
-
- 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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of data sheet collocation method, applied to report platform, the described method includes：When report platform receives the report configuring request that first terminal is sent based on the configuration page, the demand information and parameter information of configuration report are obtained based on the configuring request；Receive the Database Identification information that the first terminal is sent, the data source of data sheet to be configured is determined based on the Database Identification information, and data are extracted from the data source according to the default sentence that the first terminal is sent, draw form and/or chart with the data based on extraction；According to the report name generation data sheet of the demand information, the parameter information, the form and/or chart, and first terminal input.The invention also discloses a kind of report platform and computer-readable recording medium.The convenience and efficiency of data sheet configuration are improved in the present invention, and reduces the cost of data sheet configuration.
Description
Technical field
The present invention relates to data sheet field of configuration, more particularly to a kind of data sheet collocation method, report platform and meter
Calculation machine readable storage medium storing program for executing.
Background technology
Traditional data sheet configuration mode, is mainly realized according to the specific requirements customized development of user.Specifically
For, when the demand that business personnel has report to show, submit demand to be customized to report developer first and melt hair, open
After hair personnel's completion code writes test, give operation maintenance personnel deployment and reach the standard grade, last business personnel can just use corresponding report
Table.This mode, it is necessary to submit demand exploitation, test, O＆M, entirely realize that process is longer, development cost is higher, the construction cycle
Also grow.
In addition, when the data of business personnel have variation or the report that develops of discovery is improper need adjustment when, again
Need to develop, test for one time, the flow for O＆M of reaching the standard grade, seem excessively redundancy for the more demanding business scenario of timeliness,
It is not quick enough.
The content of the invention
It is a primary object of the present invention to provide a kind of data sheet collocation method, report platform and computer-readable storage
Medium, it is intended to solve existing data sheet configuration mode, report configuration operating process is cumbersome, and the cycle is longer, and cost is higher
Technical problem.
To achieve the above object, the present invention provides a kind of data sheet collocation method, applied to report platform, the data
Report collocation method includes：
, please based on the configuration when report platform receives the report configuring request that first terminal is sent based on the configuration page
Seek the demand information and parameter information for obtaining configuration report；
The Database Identification information that the first terminal is sent is received, is determined based on the Database Identification information to be configured
The data source of data sheet, and data are extracted from the data source according to the default sentence that the first terminal is sent, with base
Form and/or chart are drawn in the data of extraction；
Inputted according to the demand information, the parameter information, the form and/or chart, and the first terminal
Report name generation data sheet.
Alternatively, it is described according to the demand information, the parameter information, the form and/or chart, and described
After the step of report name generation data sheet of one terminal input, the method further includes：
Second terminal is received in the front end page of report platform to ask based on the exhibiting data reporting form that default application is sent
When, the web page frame of acquisition report platform from the background server of report platform；
Menu item is built in the front end page based on the web page frame of acquisition, and is existed according to the account identification of second terminal
The corresponding menu item data of the account identification is asked in background server；
The menu item data asked is compressed, to be back to front end page；
The page is built according to the menu item data in front end page, and the page of structure and the menu item are carried out
Association, to click on menu item when, jump to the page with display data report.
Alternatively, the front end page in report platform receives the datagram that second terminal is sent based on default application
During table displaying request, include from the background server of report platform the step of the web page frame of acquisition report platform：
When front end page receives the exhibiting data reporting form request that second terminal is sent based on default application, forward end clothes
The webpage of report platform is opened in device request of being engaged in, in authentication server second terminal is authenticated by the front-end server with
The account identification of the second terminal is obtained, and obtains report from the background server of report platform based on the account identification of acquisition
The web page frame of table platform is fed back；
Receive the web page frame of the report platform of the front-end server feedback.
Alternatively, it is described that menu item is built in the front end page based on the web page frame of acquisition, and according to second terminal
The account identification the step of corresponding menu item data of the account identification is asked in background server include：
The corresponding report request of account identification is sent to background server by forwarding server by front-end server, for
Background server obtains the corresponding report of the account identification, and the various menu item is ranked up according to clicking rate；
Menu item is built in the front end page based on the web page frame of acquisition, and menu item number is extracted in the report
According to being fed back.
Alternatively, the page includes parameter page and results page, it is described in front end page according to the menu item
Data build the page, and the page of structure and the menu item are associated, and to click on menu item when jumps to institute
After the page is stated with the step of display data report, the method further includes：
Menu item is shown in front end page；
When detecting click menu item button, judge whether the corresponding report content of the menu item has parameter；
If having parameter in the corresponding report of the menu item, parameter page is jumped to, and inquiry is based in parameter page
When button receives touch control operation, results page is ejected；
If the corresponding report content of the menu item does not have parameter, results page is shown.
Alternatively, if after the step of having parameter in the corresponding report of the menu item, jump to parameter page,
The method further includes：
When parameter adjustment instruction is received in parameter page, the parameter letter of second terminal input is obtained in front end page
Breath, and obtain the corresponding data content of the data sheet；
By the parameter information of acquisition and data content transmission to the background server, by background server according in data
Appearance obtains business datum in data source, and is transmitted to front end page after the business datum is compressed；
In results page of the front end page based on the business datum generation data sheet received.
Alternatively, the step of being transmitted to front end page after the compression by the business datum includes：
By background server by the data content of business datum compared with pre-stored data content；
When there is the data content with pre-stored data content matching in business datum, the data content is obscured
Processing；
Front end page will be transmitted to after data content compression after Fuzzy Processing.
Alternatively, it is described defeated according to the demand information, the parameter information, the chart, and the first terminal
After the step of report name generation data sheet entered, the method further includes：
Determine the exhibition method of data sheet；
If the exhibition method of data sheet shows for second terminal, the displaying based on second terminal is asked in second terminal
Show the data sheet；
If the exhibition method of data sheet shows for first terminal, the data are shown when starting first terminal webpage
Report, then determine whether the data sheet needs to send mail, if desired, data sheet is then changed into mail and is arranged to fixed
When send.
In addition, to achieve the above object, the present invention also provides a kind of report platform, the report platform include processor,
Memory and it is stored in the data sheet configurator that can be run on the memory and on the processor, the datagram
The step of data sheet collocation method as described above is realized when table configurator is performed by the processor.
In addition, to achieve the above object, it is described computer-readable the present invention also provides a kind of computer-readable recording medium
Data sheet configurator is stored with storage medium, the data sheet configurator is applied to data sheet configuration system,
The step of data sheet collocation method as described above is realized when the data sheet configurator is executed by processor.
Data sheet collocation method proposed by the present invention, applied to report platform, report platform receives first terminal base
When the report configuring request that the page is sent is configured, the demand information and parameter letter of configuration report are obtained based on the configuring request
Breath, when receiving the Database Identification information that the first terminal is sent, is determined to be configured based on the Database Identification information
The data source of data sheet, and data are extracted from the data source according to the default sentence that the first terminal is sent, with base
Draw form and/or chart in the data of extraction, finally according to the demand information, the parameter information, the form and/or
Chart, and the report name generation data sheet of first terminal input.In the present invention, the configuration to data sheet, is
Realized by report platform and first terminal, data obtained in data source according to default sentence, finally combine demand information and
Parameter information etc. carries out the configuration of report, improves the convenience and efficiency of data sheet configuration, and reduces data sheet
The cost of configuration.
Brief description of the drawings
Fig. 1 is the hardware architecture diagram of data sheet configuration system of the present invention；
Fig. 2 is the first hardware architecture diagram of present system framework；
Fig. 3 is the second hardware architecture diagram of present system framework；
Fig. 4 is the flow diagram of data sheet collocation method first embodiment of the present invention；
Fig. 5 is the flow diagram of data sheet collocation method second embodiment of the present invention；
Fig. 6 is the refinement flow diagram of step S40 in Fig. 5；
Fig. 7 is the refinement flow diagram of step S50 in Fig. 5；
Fig. 8 is the flow diagram of data sheet collocation method fourth embodiment of the present invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The solution of the embodiment of the present invention is mainly：Report platform receives what first terminal was sent based on the configuration page
During report configuring request, the demand information and parameter information of configuration report are obtained based on the configuring request, is receiving described the
During the Database Identification information that one terminal is sent, the data of data sheet to be configured are determined based on the Database Identification information
Source, and data are extracted from the data source according to the default sentence that the first terminal is sent, painted with the data based on extraction
Tabulate lattice and/or chart, finally according to the demand information, the parameter information, the form and/or chart, and it is described
The report name generation data sheet of first terminal input.To solve existing data sheet configuration mode, operating process is cumbersome,
The problem of cycle is longer, and cost is higher.
As shown in Figure 1, the report platform structure signal for the hardware running environment that Fig. 1, which is the embodiment of the present invention, to be related to
Figure.
Report of embodiment of the present invention platform can be PC, pocket computer etc. have display function equipment or
Server.
As shown in Figure 1, the report platform can include：Processor 1001, such as CPU, communication bus 1002, user interface
1003, network interface 1004, memory 1005.Wherein, communication bus 1002 is used for realization the connection communication between these components.
User interface 1003 can include display screen (Display), input unit such as keyboard (Keyboard), optional user interface
1003 can also include the wireline interface (such as connecting wired keyboard, wire mouse etc.) of standard, wave point (such as with
In connection Wireless Keyboard, wireless mouse).The wireline interface that network interface 1004 can optionally include standard (is used to be connected with
Gauze network), wave point (such as WI-FI interfaces, blue tooth interface, infrared interface, for connecting wireless network).Memory
1005 can be high-speed RAM memory or the memory (non-volatile memory) of stabilization, such as disk are deposited
Reservoir.Memory 1005 optionally can also be the storage device independently of aforementioned processor 1001.
Alternatively, equipment can also include camera, RF (Radio Frequency, radio frequency) circuit, sensor, audio
Circuit, WiFi module etc..
It will be understood by those skilled in the art that the report platform structure shown in Fig. 1 does not form the limit to report platform
It is fixed, it can include than illustrating more or fewer components, either combine some components or different components arrangement.
As shown in Figure 1, as in a kind of memory 1005 of computer-readable recording medium can include operating system, net
Network communication module, Subscriber Interface Module SIM and data sheet configurator.Wherein, operating system is management and control report platform
With the program of software resource, network communication module, Subscriber Interface Module SIM, sentence modification program and other programs or software are supported
Operation；Network communication module is used to managing and controlling network interface 1002；Subscriber Interface Module SIM is used to managing and controlling user
Interface 1003.
In the report platform shown in Fig. 1, the report platform is called in memory 1005 by processor 1001 and stored
Data sheet configurator, to realize following steps：
When receiving the report configuring request that first terminal is sent based on the configuration page, obtained and matched somebody with somebody based on the configuring request
Put the demand information and parameter information of report；
The Database Identification information that the first terminal is sent is received, is determined based on the Database Identification information to be configured
The data source of data sheet, and data are extracted from the data source according to the default sentence that the first terminal is sent, with base
Form and/or chart are drawn in the data of extraction；
Inputted according to the demand information, the parameter information, the form and/or chart, and the first terminal
Report name generation data sheet.
Further, it is described according to the demand information, the parameter information, the form and/or chart and described
After the step of report name generation data sheet of first terminal input, the method further includes the report platform and passes through place
Reason device 1001 calls the data sheet configurator stored in memory 1005, to realize following steps：
Second terminal is received in the front end page of report platform to ask based on the exhibiting data reporting form that default application is sent
When, the web page frame of acquisition report platform from the background server of report platform；
Menu item is built in the front end page based on the web page frame of acquisition, and is existed according to the account identification of second terminal
The corresponding menu item data of the account identification is asked in background server；
The menu item data asked is compressed, to be back to front end page；
The page is built according to the menu item data in front end page, and the page of structure and the menu item are carried out
Association, to click on menu item when, jump to the page with display data report.
Further, the data sheet that second terminal sent based on default application is received in the front end page of report platform
During displaying request, the method further includes the report platform and calls the data stored in memory 1005 by processor 1001
Report configurator, with realize from the background server of report platform obtain report platform web page frame the step of：
When front end page receives the exhibiting data reporting form request that second terminal is sent based on default application, forward end clothes
The webpage of report platform is opened in device request of being engaged in, in authentication server second terminal is authenticated by the front-end server with
The account identification of the second terminal is obtained, and obtains report from the background server of report platform based on the account identification of acquisition
The web page frame of table platform is fed back；
Receive the web page frame of the report platform of the front-end server feedback.
Further, the method further includes the report platform by being stored in the calling memory 1005 of processor 1001
Data sheet configurator, menu item is built in the front end page based on the web page frame of acquisition to realize, and according to the
The account identification of two terminals asks the step of account identification corresponding menu item data in background server：
The corresponding report request of account identification is sent to background server by forwarding server by front-end server, for
Background server obtains the corresponding report of the account identification, and the various menu item is ranked up according to clicking rate；
Menu item is built in the front end page based on the web page frame of acquisition, and menu item number is extracted in the report
According to being fed back.
Further, the page includes parameter page and results page, it is described in front end page according to the menu
Item data builds the page, and the page of structure and the menu item is associated, and to click on menu item when jumps to
After the page is with the step of display data report, the method further includes the report platform and is called by processor 1001
The data sheet configurator stored in memory 1005, to realize following steps：
Menu item is shown in front end page；
When detecting click menu item button, judge whether the corresponding report content of the menu item has parameter；
If having parameter in the corresponding report of the menu item, parameter page is jumped to, and inquiry is based in parameter page
When button receives touch control operation, results page is ejected；
If the corresponding report content of the menu item does not have parameter, results page is shown.
Further, if the step of having parameter in the corresponding report of the menu item, jump to parameter page it
Afterwards, the method further includes the report platform and calls the data sheet stored in memory 1005 configuration by processor 1001
Program, to realize following steps：
When parameter adjustment instruction is received in parameter page, the parameter letter of second terminal input is obtained in front end page
Breath, and obtain the corresponding data content of the data sheet；
By the parameter information of acquisition and data content transmission to the background server, by background server according in data
Appearance obtains business datum in data source, and is transmitted to front end page after the business datum is compressed；
In results page of the front end page based on the business datum generation data sheet received.
Further, the method further includes the report platform by being stored in the calling memory 1005 of processor 1001
Data sheet configurator, with realize by the business datum compress after be transmitted to front end page the step of：
By background server by the data content of business datum compared with pre-stored data content；
When there is the data content with pre-stored data content matching in business datum, the data content is obscured
Processing；
Front end page will be transmitted to after data content compression after Fuzzy Processing.
Further, it is described according to the demand information, the parameter information, the chart, and the first terminal
After the step of report name generation data sheet of input, the method further includes the report platform and passes through processor 1001
The data sheet configurator stored in memory 1005 is called, to realize following steps：
Determine the exhibition method of data sheet；
If the exhibition method of data sheet shows for second terminal, the displaying based on second terminal is asked in second terminal
Show the data sheet；
If the exhibition method of data sheet shows for first terminal, the data are shown when starting first terminal webpage
Report, then determine whether the data sheet needs to send mail, if desired, data sheet is then changed into mail and is arranged to fixed
When send.
The scheme that the present embodiment proposes, report platform call the datagram stored in memory 1005 by processor 1001
Table configurator, to realize following steps：When receiving the report configuring request that first terminal is sent based on the configuration page, it is based on
The configuring request obtains the demand information and parameter information of configuration report, is receiving the database mark of the first terminal transmission
When knowing information, the data source of data sheet to be configured is determined based on the Database Identification information, and according to the first terminal
The default sentence sent extracts data from the data source, and form and/or chart, final root are drawn with the data based on extraction
According to the demand information, the parameter information, the form and/or chart, and the report name of first terminal input
Generate data sheet.In the present invention, the configuration to data sheet, is to be realized by report platform and first terminal, according to default
Sentence obtains data in data source, and the final configuration that report is carried out with reference to demand information and parameter information etc., improves data
The convenience and efficiency of report configuration, and reduce the cost of data sheet configuration.
Hardware configuration based on problem existing in the prior art and above-mentioned report platform, the present invention build a system tray
Structure, the system architecture can support data sheet to configure and show, specifically, with reference to Fig. 2, the system tray in present invention implementation
Structure, including：
Report platform (the report platform includes front end page and report platform background server, wherein, report platform backstage
Server mainly provides the functions such as report configuration, the report displaying of terminal)；
PC ends (Personal Computer, personal computer, is represented with first terminal in this programme)；
Mobile phone terminal (is represented) in this programme with second terminal；
Weight discriminating server, to be best understood from, by taking wechat weight discriminating server as an example, user is looked forward to by handset Wechat
, it is necessary to be authenticated by wechat authentication server when industry number logs in, wechat authentication server confirms that the WeChat ID is the user of enterprise
Afterwards, the corresponding enterprise staff ID of WeChat ID can be returned and give report platform, report platform, which can return to the employee ID, the report of mandate
Table, is presented to user；
The authentication mode that SSO universal retrieval servers are report platform configuration administrators and PC end subscribers use, mobile phone are whole
When end logs in report platform for the first time, logged in because being not logged on that SSO universal retrieval servers can be directed into, user is defeated
After access customer name password login, you can normal use report platform configuration report and check PC ends report page；
Data source (MYSQLs, PostgreSQL database), the data source are that the database of page configuration is configured by database, report
Table platform obtains data to draw form or chart, report platform supports that configuration is multiple by accessing the data source of user configuration
Data source.
Further, with reference to Fig. 3, the system architecture it is optional including：
PMS-PRE (front-end server), the webpage of major deployments mobile phone terminal, in the network architecture applied to bank,
Front-end server docks public network, is communicated using http protocol and mobile phone terminal, and internal server uses RMB protocols, i.e., before
Server is held also to undertake the conversion work of HTTP and RMB agreements as protocol converter in addition to disposing webpage, mobile phone is whole
The JSON requests at end are forwarded to report platform background server, and after report platform background server returned data, PMS-PRE again will
Data change into HTTP message and issue front end page displaying；
PMS-CORE (forwarding server), is mainly used for mutually changing RMB and http protocol, this is also due to bank
Caused by the network architecture is more special, report platform background server supports http protocol, but RMB associations can only be walked inside bank
View, the forwarding server provide forwarding capability, RMB are changed into HTTP and issues report platform background server, by the HTTP of result
Change into RMB and issue PMS-PRE；
It should be noted that PMS-PRE and PMS-CORE are paired existing servers, can at the same time occur, be not required
When carrying out protocol conversion, it can delete at the same time.
In addition, in the present solution, each component in system architecture includes each program module, specifically：
1st, PMS-PRE is included：
(a) menu item structure module：The module is used to build the report menu item page, due to the different user of report platform
Possess different reports and check authority, report menu page is come dynamic generation according to user right；
(b) operation log reporting module：This module main users report of user operation log, is mainly used for generating report dish
During single-page, the sequence of menu frequency is clicked on according to user, the common menu of user come before, it is necessary to use the operation of user
Record data, it is therefore desirable to which operation log is reported by the module；
(c) parameter page structure module：This module mainly builds the report parameter page, since report platform provides user self-help
Parameter adjustment function, thus need according to included in report form, chart parameter, from backstage obtain corresponding parameter title,
The data such as type (supporting text, date, time, drop-down menu) and default value, dynamic construction parameter page；
(d) report displaying structure module：This module mainly builds report displayed page, and report configuration management is obtained from backstage
The report of member's configuration, builds report displayed page frame, and obtains form, the chart data that report includes, and calls what is increased income
HIGHCHART, GRI component draw corresponding form and chart；
(e) DBPDOP WEUI data interactions protocol component (front end)：Unified JSON interacting message modules are provided, to be upper
State business module service, for the data interaction between report platform front and back, including to received data carry out Gray code and
Decompression；
(f) DBPDOP WEUI common components：Report platform mobile phone terminal common component, including daily record, debugging, number are provided
According to functions such as coding, data compressions.
2nd, PMS-PRE/PMS-CORE, the main message forwarding capability provided between HTTP and RMB, comprising：
(a) wechat authentication module：PMS-PRE is deployed in, is mainly used for carrying out authentication communication with wechat enterprise number, acquisition is stepped on
Record employee ID；
(b) HTTP2RMB message conversion modules：The message conversion being responsible between HTTP and RMB.
3rd, report platform background server, it is main that mobile phone terminal back-end data query function, report platform configuration pipe are provided
Reason, report platform PC ends such as show at function, the database servers of the MYSQL as report platform in itself.Report platform backstage
Server is included with lower module：
(a) menu queries module：When mobile phone terminal menu builds the page, from report platform database, user couple is obtained
The report configuration information answered, including menu item names, parameter name, parameter type, parameter default, report include form,
Chart ID number, form, the data such as information the location of in report displaying of chart, and according to user's operation frequency from greatly to
Small orders menu items, then calling the compression of " DBPDOP WEUI data interactions protocol components (server-side) " module, (compression is mainly
It is relatively more into the network equipment crossed in view of data, in order to reduce the bandwidth occupancy of network transmission, speeding up data transmission) packing,
Return to foreground and draw the report menu item page；
(b) operation log processing module：It is mainly responsible for the User operation log that record front end page reports；
(c) table lookup module：When user clicks on inquiry button, when front end starts the drawing result page, meeting please to backstage
Ask the data (if report has comprising form) of corresponding form, the form that table lookup module is configured according to report Configuration Management Officer
SQL, obtains the business datum of form from database, changes into the data of JSON forms, then calls " DBPDOP WEUI numbers
According to interaction protocol component (server-side) " module compression packing, return to foreground and draw corresponding form；
(d) graph query module：When user clicks on inquiry button, when front end starts the drawing result page, meeting please to backstage
Ask the data (if report has comprising chart) of corresponding chart, the chart that table lookup module is configured according to report Configuration Management Officer
SQL, the business datum of chart is obtained from database, changes into different-format JSON data as defined in HIGHCHART of increasing income, so
The compression packing of " DBPDOP WEUI data interactions protocol components (server-side) " module is called afterwards, is returned to foreground and is drawn accordingly
Chart；
(e) DBPDOP WEUI data interactions protocol component (server-side)：Backstage and the universal communication module of front end page,
It is corresponding with DBPDOP WEUI data interactions protocol components (front end), data are compressed and are encoded；
(f) the WEUI Report Server Management page：Mainly it is supplied to report Configuration Management Officer to be used for wechat enterprise number mobile phone terminal report
The page of table management, can configure form, chart ID that report menu item names, report owning user group, report include and
Location information etc.；
(g) the PC ends Report Server Management page：The main page for being supplied to report Configuration Management Officer to be used for PC ends Report Server Management, can
To configure form, chart ID that report name, report owning user, report timed sending time, report include and residing
Positional information size etc.；
(h) the form configuration page：The main page for being supplied to report Configuration Management Officer to be used for form management, can be with allocation list
Data source, form SQL or code, the form of lattice need field shown etc., and provide preview function；
(i) the chart configuration page：The main page for being supplied to report Configuration Management Officer to be used for management through figures, can be with configuration diagram
Data source, chart SQL or the code of table, subtype (pie chart, curve map, area-graph etc.) etc., and preview function is provided；
(j) the parameter management page：The main page for being supplied to report Configuration Management Officer to be used for parameter management, can configure ginseng
Several classes of types, parameter display title, parameter default etc.；
(k) homepage is managed：The main portal page for being supplied to report Configuration Management Officer to be used for Report Server Management, can also match somebody with somebody
Put data source information, user's owning user group etc..
Hardware configuration based on above-mentioned report platform and system architecture, proposes each reality of data sheet collocation method of the present invention
Apply example.
With reference to Fig. 4, Fig. 4 is the flow diagram of data sheet collocation method first embodiment of the present invention.
In the present embodiment, the data sheet collocation method is applied to report platform, the data sheet collocation method
Including：
Step S10, when report platform receives the report configuring request that first terminal is sent based on the configuration page, based on institute
State demand information and parameter information that configuring request obtains configuration report；
Step S20, receives the Database Identification information that the first terminal is sent, true based on the Database Identification information
The data source of fixed data sheet to be configured, and number is extracted from the data source according to the default sentence that the first terminal is sent
According to data drafting form and/or chart based on extraction；
Step S30, according to the demand information, the parameter information, the form and/or chart, and described first
The report name generation data sheet of terminal input.
In the present embodiment, the report platform is chosen as the report platform described in Fig. 1, which is chosen as Fig. 2
The PC ends, data source are chosen as the data source described in Fig. 2.
In the present embodiment, before step S10, the described method includes：
Step A, first terminal show configuration interface, demand information input by user and parameter are received based on configuration interface
Information；
Step B, after configuration information and parameter information input by user is received, the configuration information and parameter are believed
Breath is sent to report platform as report configuring request.
The demand information represents data sheet needs which type of data shown, is shown in the form of form or chart, table
What kind of etc. be the order of lattice or chart in report be.During parameter information refers to report displaying, user can voluntarily adjust
Whole variable.
When report platform receives the report configuring request that first terminal is sent based on the configuration page, based on the configuration
Acquisition request configure report demand information and parameter information, get configuration report demand information and parameter information it
Afterwards, then the Database Identification information that the first terminal is sent based on configuration interface is received, which includes：Number
According to storehouse IP, port, user name, password and database name (DBNAME) etc., after receiving Database Identification information, based on institute
State the data source that Database Identification information determines data sheet to be configured.Report platform receives first terminal and is based on configuration interface again
The default sentence sent, the default sentence are chosen as SQL (Structured Query Language, structured query language)
Sentence, data are extracted according to the sentence from definite data source, and the data based on extraction draw form and/or chart.
After the completion of above-mentioned every terms of information obtains, you can according to the demand information, the parameter information, the form and/or chart, with
And the first terminal generates data sheet based on the report name that configuration interface inputs.
In addition, in the present solution, in order to improve the security that follow-up report is checked, the user that can be also set according to first terminal
The access rights of group control report, specifically, the account identification of user is added or removed in configuration interface and used by first terminal
Family group, to realize the setting of user group.So, after the completion of every terms of information configuration, report platform can be believed according to the demand
Breath, the parameter information, the form and/or chart, user group, and the report name generation number of first terminal input
According to report.
The data sheet collocation method that the present embodiment proposes, report platform receive first terminal and are based on configuration page transmission
Report configuring request when, based on the configuring request obtain configuration report demand information and parameter information, described in reception
During the Database Identification information that first terminal is sent, the data of data sheet to be configured are determined based on the Database Identification information
Source, and data are extracted from the data source according to the default sentence that the first terminal is sent, painted with the data based on extraction
Tabulate lattice and/or chart, finally according to the demand information, the parameter information, the form and/or chart, and it is described
The report name generation data sheet of first terminal input.In the present invention, the configuration to data sheet, be by report platform and
First terminal is realized, data are obtained in data source according to default sentence, is finally combined demand information and parameter information etc. and is carried out
The configuration of report, improves the convenience and efficiency of data sheet configuration, and reduces the cost of data sheet configuration.
Further, with reference to Fig. 5, propose data sheet collocation method of the present invention based on first embodiment second is implemented
Example.
The second embodiment of data sheet collocation method and the first embodiment of data sheet collocation method difference lies in,
After the step S30, the data sheet collocation method further includes：
Step S40, the data sheet that second terminal sent based on default application is received in the front end page of report platform
During displaying request, the web page frame of report platform is obtained from the background server of report platform；
Step S50, menu item is built based on the web page frame of acquisition in the front end page, and according to the account of second terminal
Family mark asks the corresponding menu item data of the account identification in background server；
Step S60, is compressed the menu item data asked, to be back to front end page；
Step S70, the page is built in front end page according to the menu item data, and by the page of structure and the dish
Individual event is associated, and to click on menu item when jumps to the page with display data report.
In the present embodiment, user opens the default link applied and clicked on and preset in application in second terminal, with hair
Exhibiting data reporting form is sent to ask to report platform, i.e., described exhibiting data reporting form request basis in default application by second terminal
User clicks on the link information of report platform to send.Wherein, second terminal is chosen as the mobile phone terminal described in Fig. 2, this implementation
In example, the default application is chosen as wechat application.
Report platform when front end page receives the exhibiting data reporting form request that second terminal is sent based on default application,
The web page frame of report platform can be obtained directly from the background server of report platform.By in this present embodiment, described second
Terminal is chosen as mobile phone terminal, and the default application is chosen as wechat application, for the security consideration of report displaying, with reference to figure
6, the step S40 includes：；
Step S41, when front end page receives the exhibiting data reporting form request that second terminal is sent based on default application,
Forward end server request open report platform webpage, by the front-end server in authentication server to second terminal into
Row is authenticated to obtain the account identification of the second terminal, and the background server based on the account identification of acquisition from report platform
The middle web page frame for obtaining report platform is fed back；
Step S42, receives the web page frame of the report platform of the front-end server feedback.
The authentication server is chosen as the wechat authentication server shown in Fig. 2.
That is, report platform is received second terminal in front end page and is asked based on the exhibiting data reporting form that default application is sent
When, as shown in Fig. 2, the webpage of report platform is opened in the request of report platform forward end server, front-end server receives report
Platform send request when, second terminal is authenticated to authentication server application, by authentication server to second terminal into
Row authentication, after authentication server authenticates successfully, feeds back the account identification of second terminal to the front-end server.Front end services
Device is chosen as the PMS-PRE shown in Fig. 3, background service of the front-end server according to the account identification of second terminal from report platform
The web page frame of report platform is obtained in device, and web page frame is fed back to the front end page of report platform, finally, report platform
The web page frame of the report platform of the front-end server feedback is received, and the web page frame is shown in front end page.
After report platform gets the web page frame, dish is built in the front end page based on the web page frame of acquisition
Individual event, and the corresponding menu item of the account identification can directly be asked in background server according to the account identification of second terminal
Data, further, show intelligent, with reference to Fig. 7, the step S50 includes to improve menu item：
Step S51, sends the corresponding report request of account identification to backstage by forwarding server by front-end server and takes
Business device, so that background server obtains the corresponding report of the account identification, and arranges the various menu item according to clicking rate
Sequence；
Step S52, menu item is built based on the web page frame of acquisition in the front end page, and is extracted in the report
Menu item data is fed back.
That is, after report platform gets the web page frame, account is first sent by forwarding server by front-end server
Family identifies corresponding report request to background server, so that background server obtains the corresponding report of the account identification, and
The various menu item is ranked up according to clicking rate, preferably the higher menu item of clicking rate, arrangement position is more forward, then base again
Menu item is built in the front end page in the web page frame of acquisition, and extracts menu item data in the report and carries out instead
Feedback, wherein, the forwarding server is chosen as the PMS-CORE in Fig. 3, so that background server is inquired about and obtains the account
Corresponding report is identified, and extracts menu item data in the report and is fed back, background server carries in the report
The menu item data taken include：Form ID, chart ID, parameter information (including parameter name, type, default value etc.).In addition, it is
The accuracy of background server feedback menu item data is improved, background server carries out the parameter information in menu item data
Go to reorder, then the menu item data for going to reorder fed back, further, background server feedback menu item data it
Before, packing can be also compressed to menu item data, to be fed back, so as to improve the efficiency of data transfer.
When report platform is getting menu item data, page is built according to the menu item data in front end page
Face, specifically, menu item connection is built according to the report name of feedback, and is determined that the account identification of second terminal has permission and checked
Each report, to build the page, in the present embodiment, the page of structure includes parameter page and results page, by the ginseng of structure
The number pages and results page are associated with the menu item, and to click on menu item when jumps to parameter page, and
Parameter page jumps to results page when clicking on inquiry button, and the page most built at last feeds back to second terminal.
It should be appreciated that in view of mobile phone terminal security is relatively low, the present embodiment combines wechat enterprise number to reduce peace
Full blast danger.Main thought is to employ wechat enterprise number authentication to carry out user management.Only in wechat enterprise number, add white
The user of list can just see the menu entries of report platform displaying, and user can only see one's own report, can not
See the report of other users, ensure secure user data.
Check that report displaying result is described in detail in the present embodiment with mobile phone terminal, it will be appreciated that when report is checked at PC ends
When showing result, it can equally realize.
Further, the 3rd embodiment of data sheet collocation method of the present invention is proposed based on second embodiment.
The 3rd embodiment of data sheet collocation method and the second embodiment of data sheet collocation method difference lies in,
The page includes parameter page and results page, and after the step S70, the data sheet collocation method further includes：
Step C, menu item is shown in front end page；
Step D, when detecting click menu item button, judges whether the corresponding report content of the menu item has ginseng
Number；
Step E, if having parameter in the corresponding report of the menu item, jumps to parameter page, and in parameter page base
When inquiry button receives touch control operation, results page is ejected；
Step F, if the corresponding report content of the menu item does not have parameter, shows results page.
In the present embodiment, after report platform generates menu item according to the account identification of second terminal, in front end page
Show the menu item, user clicks on the menu item button if detecting, whether first judges the corresponding report content of the menu item
There is parameter, if having parameter in the corresponding report of the menu item, jump to parameter page, and pressed based on inquiry in parameter page
When button receives touch control operation, results page is ejected, if not having, can directly show results page.
In the present embodiment, mobile phone terminal displaying is supported, user can check report whenever and wherever possible.
Further, after described " if having parameter in the corresponding report of the menu item, jumping to parameter page ", institute
The method of stating further includes：
Step G, when parameter adjustment instruction is received in parameter page, obtains second terminal input in front end page
Parameter information, and obtain the corresponding data content of the data sheet；
Step H, by the parameter information of acquisition and data content transmission to the background server, by background server according to
Data content obtains business datum in data source, and is transmitted to front end page after the business datum is compressed.
Specifically, described " being transmitted to front end page after the business datum is compressed " includes：
Step H1, by background server by the data content of business datum compared with pre-stored data content；
Step H2, when there is the data content with pre-stored data content matching in business datum, to the data content
Carry out Fuzzy Processing；
Step H3, will be transmitted to front end page after the data content compression after Fuzzy Processing.
Step I, in results page of the front end page based on the business datum generation data sheet received.
In the present embodiment, when parameter adjustment instruction is received in parameter page, second is first obtained in front end page
Terminal is based on parameter information input by user, and obtains the corresponding data content of the data sheet, and the data content includes
Data content in form, chart, after getting parameter information and data content, by the parameter information and data content of acquisition
The background server is transmitted to, business datum is obtained in data source according to data content by background server, and by described in
Be transmitted to front end page after business datum compression, in the present embodiment, background server get business datum data content it
Afterwards, by the data content of business datum compared with pre-stored data content, pre-stored data content include cell-phone number, identity card,
The sensitive data information such as bank's card number, mailbox, if detect in business datum exist with the data of pre-stored data content matching
Rong Shi, it is sensitive data to illustrate business datum, carries out Fuzzy Processing to the data content at this time, and specific Fuzzy Processing includes
Stamp is carried out to data content, or it is presupposed information that data content, which is changed, No. * display is such as changed to, subsequently by Fuzzy Processing
Front end page is transmitted to after data content compressed encoding afterwards.
In the present embodiment, report platform provides sensitive data and desensitizes automatically function, for automatic desensitization operation is carried out, avoids
User configuration is improper to cause sensitive data to be lost in, so as to improve the security of data processing.
In addition, in this implementation, after seeing menu item equivalent to user, the report menu to be checked is clicked in selection, according to need
Adjusting parameter is wanted, then checks report, i.e., when user has demand to change or finds that report is improper, it is not necessary to seek help from out again
Hair, simple configuration need to be only done on report platform and can be achieved demand change, and user's modification matches somebody with somebody and postpones and can look into real time
See report is amended as a result, being adjusted at any time, omit the development process of redundancy, accelerate business progress.
Further, with reference to Fig. 8, the 4th of data sheet collocation method of the present invention the is proposed based on first to 3rd embodiment
Embodiment.
The fourth embodiment of data sheet collocation method and the first of data sheet collocation method to the area of 3rd embodiment
It is not, after the step S30, the method further includes：
Step S80, determines the exhibition method of data sheet；
Step S90, if the exhibition method of data sheet shows for second terminal, the displaying request based on second terminal exists
Second terminal shows the data sheet；
Step S100, if the exhibition method of data sheet shows for first terminal, shows when starting first terminal webpage
Show the data sheet, then determine whether the data sheet needs to send mail, if desired, data sheet is then changed into mail
And it is arranged to timing and sends.
In the present embodiment, according to the demand information, the parameter information, the form and/or chart, Yi Jisuo
After the report name generation data sheet for stating first terminal input, also exhibition method can be set to report, specifically, by the
One terminal is configured in configuration interface, after the setup, determines the exhibition method of data sheet, if the exhibition of data sheet
The mode of showing is arranged to second terminal displaying, is shown labeled as second terminal, and the displaying subsequently based on second terminal is asked second
Data sheet described in terminal display, if the exhibition method of data sheet shows for first terminal, is starting first terminal webpage
When show the data sheet, then determine whether the data sheet needs to send mail, if desired, then change into data sheet
Mail simultaneously is arranged to periodically send.
In the present embodiment, report platform provides a variety of report display forms, including mail, webpage and terminal display.Mail
Support according to user configuration, periodically sent by the form of daily paper, monthly magazine, weekly, small Times.In order to adapt to the report exhibition of terminal
Show, Report Server Management flattening, by auto-sequencing menu, commonly use report preceding, and function of search in the page is provided, solve report
Menu searches problem.
In conclusion the data sheet collocation method in the embodiment of the present invention, has the following advantages：
The system capability that data are directly converted into chart is provided, user can show report without exploitation, reduce report
Table development cost and O＆M cost；
Data configuration is realized by SQL statement, there is provided unified configuration and a variety of methods of exhibiting, further reduce exploitation dimension
Protect cost；
Terminal display is provided, extends the usage scenario of user.And pass through wechat enterprise number, permission system and automatic desensitization
To ensure the security of data sheet.
The present invention further provides a kind of computer-readable recording medium.
Data sheet configurator is stored with the computer-readable recording medium, the data sheet configurator should
System is configured for data sheet described above, is realized when the data sheet configurator is executed by processor such as institute above
The step of data sheet collocation method stated.
Specific operating process has been described in detail above, and details are not described herein again.
It should be noted that herein, term " comprising ", "comprising" or its any other variation are intended to non-row
His property includes, so that process, method, article or device including a series of elements not only include those key elements, and
And the other key elements being not explicitly listed are further included, or further include as this process, method, article or device institute inherently
Key element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that including this
Also there are other identical element in the process of key element, method, article or device.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on such understanding, technical scheme substantially in other words does the prior art
Going out the part of contribution can be embodied in the form of software product, which is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions are used so that a station terminal equipment (can be mobile phone, computer, takes
Be engaged in device, air conditioner, or network equipment etc.) perform method described in each embodiment of the present invention.
It these are only the preferred embodiment of the present invention, be not intended to limit the scope of the invention, it is every to utilize this hair
The equivalent structure or equivalent flow shift that bright specification and accompanying drawing content are made, is directly or indirectly used in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
- A kind of 1. data sheet collocation method, it is characterised in that applied to report platform, the data sheet collocation method bag Include：When report platform receives the report configuring request that first terminal is sent based on the configuration page, obtained based on the configuring request Take the demand information and parameter information of configuration report；The Database Identification information that the first terminal is sent is received, data to be configured are determined based on the Database Identification information The data source of report, and data are extracted from the data source according to the default sentence that the first terminal is sent, with based on carrying The data taken draw form and/or chart；According to the demand information, the parameter information, the form and/or chart, and the report of first terminal input Table name generates data sheet.
- 2. data sheet collocation method as claimed in claim 1, it is characterised in that it is described according to the demand information, it is described Parameter information, the form and/or chart, and the first terminal input report name generation data sheet the step of it Afterwards, the method further includes：When the front end page of report platform receives the exhibiting data reporting form request that second terminal is sent based on default application, from The web page frame of report platform is obtained in the background server of report platform；Menu item is built in the front end page based on the web page frame of acquisition, and according to the account identification of second terminal on backstage The corresponding menu item data of the account identification is asked in server；The menu item data asked is compressed, to be back to front end page；The page is built according to the menu item data in front end page, and the page of structure and the menu item are closed Connection, to click on menu item when, jump to the page with display data report.
- 3. data sheet collocation method as claimed in claim 2, it is characterised in that the front end page in report platform connects When receiving the exhibiting data reporting form request that second terminal is sent based on default application, obtained from the background server of report platform The step of web page frame of report platform, includes：When front end page receives the exhibiting data reporting form request that second terminal is sent based on default application, forward end server The webpage of report platform is opened in request, second terminal is authenticated in authentication server to obtain by the front-end server The account identification of the second terminal, and report is obtained from the background server of report platform based on the account identification of acquisition and is put down The web page frame of platform is fed back；Receive the web page frame of the report platform of the front-end server feedback.
- 4. data sheet collocation method as claimed in claim 2, it is characterised in that it is described based on the web page frame of acquisition in institute Front end page structure menu item is stated, and the account identification pair is asked in background server according to the account identification of second terminal The step of menu item data answered, includes：The corresponding report request of account identification is sent to background server by forwarding server by front-end server, for backstage Server obtains the corresponding report of the account identification, and the various menu item is ranked up according to clicking rate；Based on the web page frame of acquisition the front end page build menu item, and in the report extract menu item data into Row feedback.
- 5. data sheet collocation method as claimed in claim 2, it is characterised in that the page includes parameter page and result The page, it is described that the page is built according to the menu item data in front end page, and by the page of structure and the menu item into Row association, after to click on menu item when jumps to the page with the step of display data report, the method is also Including：Menu item is shown in front end page；When detecting click menu item button, judge whether the corresponding report content of the menu item has parameter；If having parameter in the corresponding report of the menu item, parameter page is jumped to, and inquiry button is based in parameter page When receiving touch control operation, results page is ejected；If the corresponding report content of the menu item does not have parameter, results page is shown.
- 6. data sheet collocation method as claimed in claim 5, it is characterised in that if the corresponding report of the menu item After the step of inside having parameter, jumping to parameter page, the method further includes：When parameter adjustment instruction is received in parameter page, the parameter information of second terminal input is obtained in front end page, And obtain the corresponding data content of the data sheet；By the parameter information of acquisition and data content transmission to the background server, existed by background server according to data content Business datum is obtained in data source, and front end page is transmitted to after the business datum is compressed；In results page of the front end page based on the business datum generation data sheet received.
- 7. data sheet collocation method as claimed in claim 6, it is characterised in that passed after the compression by the business datum The step of transporting to front end page includes：By background server by the data content of business datum compared with pre-stored data content；When there is the data content with pre-stored data content matching in business datum, fuzzy place is carried out to the data content Reason；Front end page will be transmitted to after data content compression after Fuzzy Processing.
- 8. such as claim 1-7 any one of them data sheet collocation methods, it is characterised in that described to be believed according to the demand Breath, the parameter information, the chart, and the first terminal input report name generation data sheet the step of it Afterwards, the method further includes：Determine the exhibition method of data sheet；If the exhibition method of data sheet shows for second terminal, the displaying request based on second terminal is shown in second terminal The data sheet；If the exhibition method of data sheet shows for first terminal, the datagram is shown when starting first terminal webpage Table, then determine whether the data sheet needs to send mail, if desired, data sheet is then changed into mail and is arranged to timing Send.
- 9. a kind of report platform, it is characterised in that the report platform includes processor, memory and is stored in the memory Data sheet configurator that is upper and can running on the processor, the data sheet configurator are held by the processor Realized during row such as the step of data sheet collocation method described in any item of the claim 1 to 8.
- 10. a kind of computer-readable recording medium, it is characterised in that be stored with datagram on the computer-readable recording medium Table configurator, realizes such as claim 1 to 8 any one of them number when the data sheet configurator is executed by processor The step of according to report collocation method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710967504.4A CN107908659A (en) | 2017-10-17 | 2017-10-17 | Data sheet collocation method, report platform and computer-readable recording medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710967504.4A CN107908659A (en) | 2017-10-17 | 2017-10-17 | Data sheet collocation method, report platform and computer-readable recording medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107908659A true CN107908659A (en) | 2018-04-13 |
Family
ID=61840556
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710967504.4A Pending CN107908659A (en) | 2017-10-17 | 2017-10-17 | Data sheet collocation method, report platform and computer-readable recording medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107908659A (en) |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108804639A (en) * | 2018-06-04 | 2018-11-13 | 平安科技（深圳）有限公司 | Method for exhibiting data, electronic equipment and computer readable storage medium |
| CN108984499A (en) * | 2018-06-01 | 2018-12-11 | 北京五八信息技术有限公司 | Method for processing report data and device, electronic equipment and readable storage medium storing program for executing |
| CN109324757A (en) * | 2018-08-22 | 2019-02-12 | 深圳前海微众银行股份有限公司 | Block chain data capacity reduction method, device and storage medium |
| CN109522322A (en) * | 2018-11-28 | 2019-03-26 | 成都四方伟业软件股份有限公司 | Report level construction method and device |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
| CN110110316A (en) * | 2019-05-17 | 2019-08-09 | 贵州数据宝网络科技有限公司 | Intelligent report forms display systems |
| CN110287472A (en) * | 2019-06-28 | 2019-09-27 | 湖南御家科技有限公司 | Report configuration method, system, equipment and computer readable storage medium |
| CN110347974A (en) * | 2019-05-30 | 2019-10-18 | 重庆金融资产交易所有限责任公司 | Data processing method, device, computer equipment and storage medium |
| CN110413610A (en) * | 2019-06-19 | 2019-11-05 | 中国平安财产保险股份有限公司 | Improve method and system, the database server of business datum report export efficiency |
| CN110502730A (en) * | 2018-05-18 | 2019-11-26 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating mobile report |
| CN110688423A (en) * | 2019-09-06 | 2020-01-14 | 中国平安财产保险股份有限公司 | Data processing and displaying method, system, equipment and storage medium |
| CN110705243A (en) * | 2019-10-10 | 2020-01-17 | 深圳前海微众银行股份有限公司 | Web page table setting method, device, equipment and computer storage medium |
| CN110704394A (en) * | 2019-09-03 | 2020-01-17 | 苏宁云计算有限公司 | Report configuration modification method and device |
| CN110825745A (en) * | 2019-10-31 | 2020-02-21 | 口碑(上海)信息技术有限公司 | Page generation method and device |
| CN111079391A (en) * | 2019-12-31 | 2020-04-28 | 恩亿科(北京)数据科技有限公司 | Report generation method and device |
| CN111176767A (en) * | 2019-12-17 | 2020-05-19 | 深圳奇迹智慧网络有限公司 | Table data processing method and device, computer equipment and storage medium |
| CN111539011A (en) * | 2020-07-07 | 2020-08-14 | 北京联想协同科技有限公司 | Data hiding method and device and storage medium |
| CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
| CN111797350A (en) * | 2020-06-24 | 2020-10-20 | 北京字节跳动网络技术有限公司 | Data processing method and device and electronic equipment |
| CN112836148A (en) * | 2021-02-26 | 2021-05-25 | 腾讯科技（深圳）有限公司 | Report display method and device, storage medium and electronic equipment |
| CN113010591A (en) * | 2021-03-22 | 2021-06-22 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
| CN114118033A (en) * | 2021-10-13 | 2022-03-01 | 深圳追一科技有限公司 | Report generation method, device, equipment and storage medium |
| CN114676190A (en) * | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Data display method and device, computer equipment and storage medium |
| CN115146006A (en) * | 2022-08-22 | 2022-10-04 | 东方合智数据科技(广东)有限责任公司 | Report statistical method and related equipment for corrugated paper packaging industry |
| CN115293871A (en) * | 2022-10-08 | 2022-11-04 | 山东工程职业技术大学 | Multi-terminal financial data management method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN105426394A (en) * | 2015-10-18 | 2016-03-23 | 广州赛意信息科技股份有限公司 | Mobile report generation method and system based on cross-platform |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
| CN105760401A (en) * | 2014-12-19 | 2016-07-13 | 金蝶软件（中国）有限公司 | Report data interaction method and system based on mobile terminal |
| CN106293661A (en) * | 2015-05-22 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The generation of pictorial statement, generation processing method and processing device |
| CN106886883A (en) * | 2017-02-06 | 2017-06-23 | 黑龙江工业学院 | A kind of processing system of financial accounting form |
-
2017
- 2017-10-17 CN CN201710967504.4A patent/CN107908659A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105760401A (en) * | 2014-12-19 | 2016-07-13 | 金蝶软件（中国）有限公司 | Report data interaction method and system based on mobile terminal |
| CN106293661A (en) * | 2015-05-22 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The generation of pictorial statement, generation processing method and processing device |
| CN105426394A (en) * | 2015-10-18 | 2016-03-23 | 广州赛意信息科技股份有限公司 | Mobile report generation method and system based on cross-platform |
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
| CN106886883A (en) * | 2017-02-06 | 2017-06-23 | 黑龙江工业学院 | A kind of processing system of financial accounting form |
Cited By (37)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110502730A (en) * | 2018-05-18 | 2019-11-26 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating mobile report |
| CN108984499A (en) * | 2018-06-01 | 2018-12-11 | 北京五八信息技术有限公司 | Method for processing report data and device, electronic equipment and readable storage medium storing program for executing |
| CN108984499B (en) * | 2018-06-01 | 2022-05-31 | 北京五八信息技术有限公司 | Report data processing method and device, electronic equipment and readable storage medium |
| CN108804639A (en) * | 2018-06-04 | 2018-11-13 | 平安科技（深圳）有限公司 | Method for exhibiting data, electronic equipment and computer readable storage medium |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
| CN109324757A (en) * | 2018-08-22 | 2019-02-12 | 深圳前海微众银行股份有限公司 | Block chain data capacity reduction method, device and storage medium |
| CN109324757B (en) * | 2018-08-22 | 2021-05-21 | 深圳前海微众银行股份有限公司 | Block chain data capacity reduction method and device and storage medium |
| CN109522322A (en) * | 2018-11-28 | 2019-03-26 | 成都四方伟业软件股份有限公司 | Report level construction method and device |
| CN110110316A (en) * | 2019-05-17 | 2019-08-09 | 贵州数据宝网络科技有限公司 | Intelligent report forms display systems |
| CN110347974A (en) * | 2019-05-30 | 2019-10-18 | 重庆金融资产交易所有限责任公司 | Data processing method, device, computer equipment and storage medium |
| CN110347974B (en) * | 2019-05-30 | 2023-06-23 | 深圳市鼎为通信有限公司 | Data processing method, device, computer equipment and storage medium |
| CN110413610A (en) * | 2019-06-19 | 2019-11-05 | 中国平安财产保险股份有限公司 | Improve method and system, the database server of business datum report export efficiency |
| CN110413610B (en) * | 2019-06-19 | 2023-10-27 | 中国平安财产保险股份有限公司 | Method and system for improving export efficiency of business data report forms and database server |
| CN110287472B (en) * | 2019-06-28 | 2022-12-09 | 湖南水羊科技有限公司 | Report configuration method, system, equipment and computer readable storage medium |
| CN110287472A (en) * | 2019-06-28 | 2019-09-27 | 湖南御家科技有限公司 | Report configuration method, system, equipment and computer readable storage medium |
| CN110704394A (en) * | 2019-09-03 | 2020-01-17 | 苏宁云计算有限公司 | Report configuration modification method and device |
| CN110704394B (en) * | 2019-09-03 | 2023-06-30 | 苏宁云计算有限公司 | Report configuration modification method and device |
| CN110688423A (en) * | 2019-09-06 | 2020-01-14 | 中国平安财产保险股份有限公司 | Data processing and displaying method, system, equipment and storage medium |
| CN110705243A (en) * | 2019-10-10 | 2020-01-17 | 深圳前海微众银行股份有限公司 | Web page table setting method, device, equipment and computer storage medium |
| CN110825745A (en) * | 2019-10-31 | 2020-02-21 | 口碑(上海)信息技术有限公司 | Page generation method and device |
| CN110825745B (en) * | 2019-10-31 | 2023-03-07 | 口碑(上海)信息技术有限公司 | Page generation method and device |
| CN111176767B (en) * | 2019-12-17 | 2023-08-18 | 深圳奇迹智慧网络有限公司 | Table data processing method, apparatus, computer device and storage medium |
| CN111176767A (en) * | 2019-12-17 | 2020-05-19 | 深圳奇迹智慧网络有限公司 | Table data processing method and device, computer equipment and storage medium |
| CN111079391A (en) * | 2019-12-31 | 2020-04-28 | 恩亿科(北京)数据科技有限公司 | Report generation method and device |
| CN111079391B (en) * | 2019-12-31 | 2024-01-19 | 恩亿科(北京)数据科技有限公司 | Report generation method and device |
| CN111708992B (en) * | 2020-05-06 | 2023-07-14 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
| CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
| CN111797350A (en) * | 2020-06-24 | 2020-10-20 | 北京字节跳动网络技术有限公司 | Data processing method and device and electronic equipment |
| CN111539011A (en) * | 2020-07-07 | 2020-08-14 | 北京联想协同科技有限公司 | Data hiding method and device and storage medium |
| CN112836148A (en) * | 2021-02-26 | 2021-05-25 | 腾讯科技（深圳）有限公司 | Report display method and device, storage medium and electronic equipment |
| CN112836148B (en) * | 2021-02-26 | 2023-12-12 | 腾讯科技（深圳）有限公司 | Report display method and device, storage medium and electronic equipment |
| CN113010591A (en) * | 2021-03-22 | 2021-06-22 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
| CN113010591B (en) * | 2021-03-22 | 2024-04-19 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
| CN114118033A (en) * | 2021-10-13 | 2022-03-01 | 深圳追一科技有限公司 | Report generation method, device, equipment and storage medium |
| CN114676190A (en) * | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Data display method and device, computer equipment and storage medium |
| CN115146006A (en) * | 2022-08-22 | 2022-10-04 | 东方合智数据科技(广东)有限责任公司 | Report statistical method and related equipment for corrugated paper packaging industry |
| CN115293871A (en) * | 2022-10-08 | 2022-11-04 | 山东工程职业技术大学 | Multi-terminal financial data management method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107908659A (en) | Data sheet collocation method, report platform and computer-readable recording medium | |
| CN102812452B (en) | Be used for system, server, terminal, the method for display buffer webpage and record the computer readable recording medium storing program for performing of the method | |
| CN103152404B (en) | The multiple enterprises multi-user of the service-oriented information switching that swipes represents and exchange method | |
| US20160241589A1 (en) | Method and apparatus for identifying malicious website | |
| US20230308504A9 (en) | Method and system of application development for multiple device client platforms | |
| CN103744659A (en) | Method and device for card type management of application entries | |
| CN107908695A (en) | Operation system operation method, device, system and readable storage medium storing program for executing | |
| CN105701122A (en) | Log collection method, apparatus and system | |
| CN105718540A (en) | Data loading method and apparatus | |
| CN106202305A (en) | A kind of log processing method, device and Database Systems | |
| US11200220B2 (en) | Efficient storage of user personal attributes for service provisioning | |
| CN106789227B (en) | A kind of internet behavior analysis method and internet behavior analytical equipment | |
| CN106406844A (en) | A method and a device for realizing a communication interaction platform official account menu | |
| CN106527874A (en) | Page processing method and apparatus | |
| CN109726545B (en) | Information display method, equipment, computer readable storage medium and device | |
| CN109446648A (en) | Service of simulation method for building up and device | |
| CN105516337A (en) | Web site docking analysis method based on dynamic loading mechanism | |
| CN106169133A (en) | A kind of talent market commending system based on RESTful style | |
| US20160112572A1 (en) | Conference call management system | |
| CN107465601A (en) | Pushed information processing method and processing device | |
| CN109213782A (en) | Configuration, display methods, device and the communication equipment of search interface | |
| CN112000876B (en) | Information display method, terminal and server | |
| CN107707602A (en) | Data communication process terminal, method and computer-readable recording medium | |
| CN105338091A (en) | High-transmission-efficiency personalized information interface display method and apparatus | |
| CN108829844A (en) | A kind of information search method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180413 |