CN103150647B - Report file disposal route, server and system - Google Patents
Report file disposal route, server and system Download PDFInfo
- Publication number
- CN103150647B CN103150647B CN201310122129.5A CN201310122129A CN103150647B CN 103150647 B CN103150647 B CN 103150647B CN 201310122129 A CN201310122129 A CN 201310122129A CN 103150647 B CN103150647 B CN 103150647B
- Authority
- CN
- China
- Prior art keywords
- report
- report file
- excel
- user terminal
- check
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
The present invention discloses a kind of report file disposal route, server and system.Wherein in report file disposal route, utilize base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported.Receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
Description
Technical field
The present invention relates to computer realm, particularly a kind of report file disposal route, server and system.
Background technology
Along with China's financial market is to global open, financial company will face more risk and competitive pressure, so enterprise needs for decision-making level, administration and supervision authorities and financial regulation agencies provide more comprehensively report data.But it is ubiquitous that the IT construction of enterprise lags behind business demand, this just causes enterprise cannot find the data of needs when making some form from existing system, at this moment just needs to provide relevant report data in the manual mode of making a report on.For reducing manual workload of making a report on, improve and make a report on the quality of data, making a report on function needs to provide the functions such as data calculating, data check.
Fig. 1 is the schematic diagram of a report file disposal route embodiment in prior art.As shown in Figure 1:
Step 101, server end utilizes report form template and report data generating report forms file.
Wherein the content of Reports module is the table sample of form, and report data can obtain from database server according to report query parameter.
Step 102, the download request that server end sends according to user terminal, sends to user terminal by report file.
Step 103, user carries out data by user terminal and makes a report in report file.
Step 104, the report file reported is sent to server end by user terminal.
Step 105, the report file of server end to user terminal to send up is resolved, and obtains the data message in file, data message is updated to database.
Step 106, carries out report data calculating in the database of server end.
Step 107, carries out report data verification in the database of server end.
It can thus be appreciated that, in the prior art, to the calculating of report data and verification all in server end execution, therefore there is following defect:
1, because carry out data calculating and verification in server-side database, need to take more server resource, so when user concurrent amount increases, server stress is larger.
2, because carry out calculating and the verification of data at server end, so user just can know the result calculating and verify after submitting report file to, if there is mistake, user needs repeatedly to submit to modify and verify, Consumer's Experience is poor.
3, because user needs repeatedly to submit to, so add the treatment capacity that server carries out resolving, calculating, verify, cause server stress larger.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of report file disposal route, server and system.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
According to an aspect of the present invention, a kind of report file disposal route is provided, comprises:
Report form template and report data is utilized to generate base report file;
Utilize base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula;
According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported;
Receive the report file of user terminal to send up;
The report file of user terminal to send up is verified;
When verification succeeds, dissection process is carried out to the report file of user terminal to send up.
Have choosing, the step utilizing base report file generated to make a report on report file comprises:
Base report file is carried out initialization process, to generate the information page for depositing authorization information in base report file;
The computational logic of write is converted to Excel computing formula, by Excel computing formula write base report file;
The check logic of write is converted to Excel check formula, by Excel check formula write base report file;
The data type of input is allowed according to form configuration information setting unit lattice;
According to the lock-out state of form configuration information setting unit lattice, generate thus and make a report on report file.
There is choosing, the step that base report file carries out initialization process comprised:
Information generated page in base report file;
Information page is set to hidden state;
Write verification information in information page;
Locking information page.
Preferably, the step that the report file of user terminal to send up verifies is comprised:
In the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status;
If all the state of Excel check formula is success status, then perform the step of the report file of user terminal to send up being carried out to dissection process.
Preferably, the step that the report file of user terminal to send up verifies also is comprised:
The authorization information deposited in information extraction page;
Judge that whether authorization information is legal;
If authorization information is legal, then perform in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is the step of success status.
According to a further aspect in the invention, a kind of report file processing server is provided, comprises:
Base report generation unit, generates base report file for utilizing report form template and report data;
Make a report on report generation unit, for utilizing base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula;
First receiving element, for receiving the download request that user terminal sends;
Transmitting element, for the download request sent according to user terminal, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported;
Second receiving element, for receiving the report file of user terminal to send up;
Verification unit, for verifying the report file of user terminal to send up;
Resolution unit, for the check results according to verification unit, when verification succeeds, carries out dissection process to the report file of user terminal to send up.
Preferably, make a report on report generation unit specifically to comprise:
Initialization module, for base report file is carried out initialization process, to generate the information page for depositing authorization information in base report file;
Computing formula modular converter, for the computational logic of write is converted to Excel computing formula, by Excel computing formula write base report file;
Check formula modular converter, for the check logic of write is converted to Excel check formula, by Excel check formula write base report file;
Data type arranges module, for allowing the data type of input according to form configuration information setting unit lattice;
Lock-out state arranges module, for the lock-out state according to form configuration information setting unit lattice, generates thus and makes a report on report file.
Preferably, initialization module also comprises:
Information page generation module, for information generated page in base report file;
Information page arranges module, for information page is set to hidden state;
Authorization information writing module, for write verification information in information page;
Locking module, for locking information page.
Preferably, verification unit specifically comprises:
First identification module, for in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status, if all the state of Excel check formula is success status, then resolution unit is indicated to perform the operation report file of user terminal to send up being carried out to dissection process.
Preferably, verification unit also comprises:
Extraction module, for the authorization information deposited in information extraction page;
Second identification module, for judging that whether authorization information is legal; If authorization information is legal, then indicate the first identification module to perform in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is the operation of success status.
According to a further aspect in the invention, a kind of report file disposal system is provided, comprises report file processing server and user terminal, wherein:
Report file processing server, base report file is generated for utilizing report form template and report data, base report file generated is utilized to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula, according to the download request that user terminal sends, report file will be made a report on and send to user terminal, receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up;
User terminal, for sending download request to report file processing server, what receive the transmission of report file processing server makes a report on report file, utilize corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported, the report file reported is sent to report file processing server.
Preferably, report file processing server is the report file processing server that above-mentioned any embodiment relates to.
The present invention makes a report on report file by utilizing base report file generated, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported.Receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the schematic diagram of a report file disposal route embodiment in prior art.
Fig. 2 is the schematic diagram of a report file disposal route of the present invention embodiment.
Fig. 3 is that the present invention generates the schematic diagram making a report on a report file embodiment.
Fig. 4 is that base report file is carried out the schematic diagram of an initialization process embodiment by the present invention.
Fig. 5 is that the present invention carries out the schematic diagram of a verification embodiment to the report file of user terminal to send up.
Fig. 6 is the schematic diagram that computational logic is converted to an Excel computing formula embodiment by the present invention.
Fig. 7 is the present invention is the schematic diagram of an Excel check formula embodiment by verification logical transition.
Fig. 8 is the schematic diagram of a report file processing server of the present invention embodiment.
Fig. 9 is the schematic diagram making a report on a report generation unit embodiment.
Figure 10 is the schematic diagram of an initialization module of the present invention embodiment.
Figure 11 is the schematic diagram of a verification unit of the present invention embodiment.
Figure 12 is the schematic diagram of a report file disposal system of the present invention embodiment.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Illustrative to the description only actually of at least one exemplary embodiment below, never as any restriction to the present invention and application or use.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Unless specifically stated otherwise, otherwise positioned opposite, the numerical expression of the parts of setting forth in these embodiments and step and numerical value do not limit the scope of the invention.
Meanwhile, it should be understood that for convenience of description, the size of the various piece shown in accompanying drawing is not draw according to the proportionate relationship of reality.
May not discuss in detail for the known technology of person of ordinary skill in the relevant, method and apparatus, but in the appropriate case, described technology, method and apparatus should be regarded as a part of authorizing instructions.
In all examples with discussing shown here, any occurrence should be construed as merely exemplary, instead of as restriction.Therefore, other example of exemplary embodiment can have different values.
It should be noted that: represent similar terms in similar label and letter accompanying drawing below, therefore, once be defined in an a certain Xiang Yi accompanying drawing, then do not need to be further discussed it in accompanying drawing subsequently.
Fig. 2 is the schematic diagram of a report file disposal route of the present invention embodiment.Preferably, the method step of this embodiment can be performed by report file processing server.
Step 201, utilizes report form template and report data to generate base report file.
Step 202, utilizes base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.
Step 203, according to the download request that user terminal sends, will make a report on report file and send to user terminal.So that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported.
Step 204, receives the report file of user terminal to send up.
Step 205, verifies the report file of user terminal to send up.
Step 206, when verification succeeds, carries out dissection process to the report file of user terminal to send up.
Based on the report file disposal route that the above embodiment of the present invention provides, by utilizing base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported.Receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
Fig. 3 is that the present invention generates the schematic diagram making a report on a report file embodiment.As shown in Figure 3, the above-mentioned step utilizing base report file generated to make a report on report file comprises:
Step 301, carries out initialization process by base report file, to generate the information page for depositing authorization information in base report file.
Step 302, is converted to Excel computing formula by the computational logic of write, by Excel computing formula write base report file.
Step 303, is converted to Excel check formula by the check logic of write, by Excel check formula write base report file.
Step 304, allows the data type of input according to form configuration information setting unit lattice.
Step 305, according to the lock-out state of form configuration information setting unit lattice, generates thus and makes a report on report file.
Thus, the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula, thus be convenient to user terminal by Excel computing formula and Excel check formula write base report file.
Due to computational logic is converted to Excel computing formula, be Excel check formula by verification logical transition, thus be convenient to user terminal and directly utilize Excel instrument can complete correlation computations and verification, thus alleviate the business originally performed by server.
Fig. 4 is that base report file is carried out the schematic diagram of an initialization process embodiment by the present invention.As shown in Figure 4, above-mentioned step of base report file being carried out initialization process comprises:
Step 401, information generated page in base report file.
Such as, by POI(PointofInterest, point of interest) interface generates a new information page hereof.
Step 402, is set to hidden state by information page.
Step 403, write verification information in information page.
Such as, in information page, coordinate is write verification code in the cell of " A1 ".The create-rule of identifying code is: subject code+form code+baseline date+character string that is spliced into of querying condition, then generate after md5 encryption 128 character strings.
Step 404, locking information page.
By locking information page, and setting code, prevent user from modifying.
Preferably, above-mentioned the step that the report file of user terminal to send up verifies to be comprised:
In the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status.
If all the state of Excel check formula is success status, then perform the step of the report file of user terminal to send up being carried out to dissection process.
If there is status of fail, then mean in report file and occur mistake, now stop relevant treatment.
Preferably, before the state of Excel check formula is judged, also can verify the authorization information in information page further, thus the security of the information of raising.Fig. 5 is that the present invention carries out the schematic diagram of a verification embodiment to the report file of user terminal to send up.As shown in Figure 5:
Step 501, the authorization information deposited in information extraction page.
Step 502, judges that whether authorization information is legal.If authorization information is legal, then perform step 503; Otherwise perform step 505.
Step 503, in the report file reported on the subscriber terminal, judges whether the state of whole Excel check formula is success status.If all the state of Excel check formula is success status, then perform step 504; Otherwise perform step 505.
Step 504, performs the step of the report file of user terminal to send up being carried out to dissection process.Afterwards, other step of the present embodiment is no longer performed.
Step 505, termination.
Fig. 6 is the schematic diagram that computational logic is converted to an Excel computing formula embodiment by the present invention.Preferably, the above-mentioned computational logic by write is converted to the step of Excel computing formula and is:
Step 601, carries out lexical analysis.
Such as, by using ANTLR lexical analysis tool, the morphological rule file according to building carries out word identification.
Step 602, carries out grammatical analysis.
Such as, on the basis of the word identified, use ANTLR grammatical analysis instrument, generate a syntax tree according to Grammar Rule file.
Step 603, carries out semantic analysis.
Such as, the syntax tree generated by traversal, generates the computing formula meeting Excel rule.
Step 604, by cell corresponding in Excel computing formula write report file.
Fig. 7 is the present invention is the schematic diagram of an Excel check formula embodiment by verification logical transition.Preferably, the above-mentioned check logic by write is converted to the step of Excel check formula and is:
Step 701, carries out lexical analysis.
Such as, by using ANTLR lexical analysis tool, the morphological rule file according to building carries out word identification.
Step 702, carries out grammatical analysis.
Such as, on the basis of the word identified, use ANTLR grammatical analysis instrument, generate a syntax tree according to Grammar Rule file.
Step 703, carries out semantic analysis.
Such as, the syntax tree generated by traversal, generates the check formula meeting Excel rule.
Step 704, by Excel check formula write report file, is the checking formula that each conditional formats adds simultaneously in information page.
It should be noted that, because above-mentioned lexical analysis, grammatical analysis and semantic analysis are not inventive point place of the present invention, therefore do not launch here to describe.
Fig. 8 is the schematic diagram of a report file processing server of the present invention embodiment.As shown in Figure 8, report file processing server can comprise:
Base report generation unit 801, generates base report file for utilizing report form template and report data.
Make a report on report generation unit 802, for utilizing base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.
First receiving element 803, for receiving the download request that user terminal sends.
Transmitting element 804, for the download request sent according to user terminal, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported.
Second receiving element 805, for receiving the report file of user terminal to send up.
Verification unit 806, for verifying the report file of user terminal to send up.
Resolution unit 807, for the check results according to verification unit 806, when verification succeeds, carries out dissection process to the report file of user terminal to send up.
Based on the report file processing server that the above embodiment of the present invention provides, by utilizing base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported.Receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
Fig. 9 is the schematic diagram making a report on a report generation unit embodiment.As shown in Figure 9, make a report on report generation unit specifically to comprise:
Initialization module 901, for base report file is carried out initialization process, to generate the information page for depositing authorization information in base report file.
Computing formula modular converter 902, for the computational logic of write is converted to Excel computing formula, by Excel computing formula write base report file.
Check formula modular converter 903, for the check logic of write is converted to Excel check formula, by Excel check formula write base report file.
Data type arranges module 904, for allowing the data type of input according to form configuration information setting unit lattice.
Lock-out state arranges module 905, for the lock-out state according to form configuration information setting unit lattice, generates thus and makes a report on report file.
Figure 10 is the schematic diagram of an initialization module of the present invention embodiment.As shown in Figure 10, initialization module also comprises:
Information page generation module 1001, for information generated page in base report file.
Information page arranges module 1002, for information page is set to hidden state.
Authorization information writing module 1003, for write verification information in information page.
Locking module 1004, for locking information page.
Figure 11 is the schematic diagram of a verification unit of the present invention embodiment.Shown in Figure 11, verification unit specifically comprises:
First identification module 1101, for in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status, if all the state of Excel check formula is success status, then resolution unit 807 is indicated to perform the operation report file of user terminal to send up being carried out to dissection process.
Preferably, verification unit also comprises:
Extraction module 1102, for the authorization information deposited in information extraction page.
Second identification module 1103, for judging that whether authorization information is legal; If authorization information is legal, then indicate the first identification module 1101 to perform in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is the operation of success status.
Figure 12 is the schematic diagram of a report file disposal system of the present invention embodiment.As shown in figure 12, report file disposal system comprises report file processing server 1201 and user terminal 1202.Wherein:
Report file processing server 1201, base report file is generated for utilizing report form template and report data, base report file generated is utilized to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula, according to the download request that user terminal 1202 sends, report file will be made a report on and send to user terminal 1202, receive the report file that user terminal 1202 reports, the report file that user terminal 1202 reports is verified, when verification succeeds, dissection process is carried out to the report file that user terminal 1202 reports,
User terminal 1202, for sending download request to report file processing server 1201, what receive the transmission of report file processing server 1201 makes a report on report file, utilize corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported, the report file reported is sent to report file processing server 1201.
Based on the report file disposal system that the above embodiment of the present invention provides, base report file generated is utilized to make a report on report file by report file processing server, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula.According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported.Receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up.By subscriber terminal side is transplanted in the operations such as data calculating, data check, thus effectively alleviate the pressure of the calculating of server-side processes data, data check, improve Consumer's Experience.
For brevity, a user terminal is only gived in fig. 12.Those skilled in the art are scrutable, and multiple user terminal and report file processing server can be had to carry out alternately.
Preferably, report file processing server is the report file processing server that in Fig. 8-11, any embodiment relates to.
By implementing the present invention, following beneficial effect can be obtained:
1, the carrier made a report on using Excel as data of the present invention, so only need client computer to install the software can editing Excel file, does not need to install other any plug-in unit or clients, so can adapt to applied environment widely, uses simpler.
2, because data calculating, data check have been put in Excel file and have been carried out, use the resource of subscriber computer, so alleviate, server process data calculate, the pressure of data check.
3, because data calculate the computing formula employed in Excel file, so user is when carrying out data and making a report on, the data that complete that can be instant calculate.
4, because data check employs the conditional formats in Excel file, so verify unsanctioned formula by arranging the color of error data cells lattice for red, user is facilitated to find mistake.
Finally the relational language that the present invention relates to is made an explanation:
POI: be the project that the Java that increases income of Apache mono-reads and writes the Microsoft OLE2 assembly documents such as Excel, Word.This instrument can be used to carry out read-write operation to Excel.
ANTLR: current popular a kind of morphology and grammatical analysis analytical tool.This programme uses this instrument to carry out lexical analysis and the grammatical analysis of form computing formula and form check formula.
Data calculate: some data in form are calculated according to certain arithmetic logic by other data.The calculating process of these data is called that data calculate.
Data check: the logic rules that between some data in form, demand fulfillment is certain, such as: A=B+C, D>E etc., the process whether data in inspection form meet these logic rules is called data check.
Computing formula: a kind of class method language of independent research, can be used for describing report data computational logic.
Check formula: a kind of class method language of independent research, can be used for describing report data check logic.Morphology, the syntax rule of computing formula and check formula are consistent.
Form configuration information: a set of information description rule of independent research, for describing the information such as processing procedure, inquiry mode, ways of presentation of form.
One of ordinary skill in the art will appreciate that all or part of step realizing above-described embodiment can have been come by hardware, the hardware that also can carry out instruction relevant by program completes, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium mentioned can be ROM (read-only memory), disk or CD etc.
Description of the invention provides in order to example with for the purpose of describing, and is not exhaustively or limit the invention to disclosed form.Many modifications and variations are obvious for the ordinary skill in the art.Selecting and describing embodiment is in order to principle of the present invention and practical application are better described, and enables those of ordinary skill in the art understand the present invention thus design the various embodiments with various amendment being suitable for special-purpose.
Claims (10)
1. a report file disposal route, is characterized in that, comprising:
Report form template and report data is utilized to generate base report file;
Utilize base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula;
According to the download request that user terminal sends, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing be carried out to the data that user makes a report on, to obtain the report file reported;
Receive the report file of user terminal to send up;
The report file of user terminal to send up is verified;
When verification succeeds, dissection process is carried out to the report file of user terminal to send up;
Wherein the step that the report file of user terminal to send up verifies is comprised:
In the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status;
If all the state of Excel check formula is success status, then determine verification succeeds.
2. method according to claim 1, is characterized in that, the step utilizing base report file generated to make a report on report file comprises:
Base report file is carried out initialization process, to generate the information page for depositing authorization information in base report file;
The computational logic of write is converted to Excel computing formula, by Excel computing formula write base report file;
The check logic of write is converted to Excel check formula, by Excel check formula write base report file;
The data type of input is allowed according to form configuration information setting unit lattice;
According to the lock-out state of form configuration information setting unit lattice, generate thus and make a report on report file.
3. method according to claim 2, is characterized in that, the step that base report file carries out initialization process is comprised:
Information generated page in base report file;
Information page is set to hidden state;
Write verification information in information page;
Locking information page.
4. method according to claim 1, is characterized in that, also comprises the step that the report file of user terminal to send up verifies:
The authorization information deposited in information extraction page;
Judge that whether authorization information is legal;
If authorization information is legal, then perform in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is the step of success status.
5. a report file processing server, is characterized in that, report file processing server comprises:
Base report generation unit, generates base report file for utilizing report form template and report data;
Make a report on report generation unit, for utilizing base report file generated to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula;
First receiving element, for receiving the download request that user terminal sends;
Transmitting element, for the download request sent according to user terminal, report file will be made a report on and send to user terminal, so that user terminal utilizes corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported;
Second receiving element, for receiving the report file of user terminal to send up;
Verification unit, for verifying the report file of user terminal to send up;
Resolution unit, for the check results according to verification unit, when verification succeeds, carries out dissection process to the report file of user terminal to send up;
Wherein verification unit specifically comprises the first identification module, for in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status, if all the state of Excel check formula is success status, then determine verification succeeds.
6. server according to claim 5, is characterized in that, makes a report on report generation unit and specifically comprises:
Initialization module, for base report file is carried out initialization process, to generate the information page for depositing authorization information in base report file;
Computing formula modular converter, for the computational logic of write is converted to Excel computing formula, by Excel computing formula write base report file;
Check formula modular converter, for the check logic of write is converted to Excel check formula, by Excel check formula write base report file;
Data type arranges module, for allowing the data type of input according to form configuration information setting unit lattice;
Lock-out state arranges module, for the lock-out state according to form configuration information setting unit lattice, generates thus and makes a report on report file.
7. server according to claim 6, is characterized in that, initialization module also comprises:
Information page generation module, for information generated page in base report file;
Information page arranges module, for information page is set to hidden state;
Authorization information writing module, for write verification information in information page;
Locking module, for locking information page.
8. server according to claim 5, is characterized in that, verification unit also comprises:
Extraction module, for the authorization information deposited in information extraction page;
Second identification module, for judging that whether authorization information is legal; If authorization information is legal, then indicate the first identification module to perform in the report file reported on the subscriber terminal, judge whether the state of whole Excel check formula is the operation of success status.
9. a report file disposal system, is characterized in that, comprises report file processing server and user terminal, wherein:
Report file processing server, base report file is generated for utilizing report form template and report data, base report file generated is utilized to make a report on report file, wherein the computational logic of write is converted to Excel computing formula, the check logic of write is converted to Excel check formula, according to the download request that user terminal sends, report file will be made a report on and send to user terminal, receive the report file of user terminal to send up, the report file of user terminal to send up is verified, when verification succeeds, dissection process is carried out to the report file of user terminal to send up; In the report file wherein reported on the subscriber terminal, judge whether the state of whole Excel check formula is success status, if all the state of Excel check formula is success status, then determine verification succeeds;
User terminal, for sending download request to report file processing server, what receive the transmission of report file processing server makes a report on report file, utilize corresponding Excel computing formula and Excel check formula, computing is carried out to the data that user makes a report on, to obtain the report file reported, the report file reported is sent to report file processing server.
10. system according to claim 9, is characterized in that:
The report file processing server that report file processing server relates to any one of claim 5-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310122129.5A CN103150647B (en) | 2013-04-10 | 2013-04-10 | Report file disposal route, server and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310122129.5A CN103150647B (en) | 2013-04-10 | 2013-04-10 | Report file disposal route, server and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103150647A CN103150647A (en) | 2013-06-12 |
| CN103150647B true CN103150647B (en) | 2016-01-06 |
Family
ID=48548705
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310122129.5A Active CN103150647B (en) | 2013-04-10 | 2013-04-10 | Report file disposal route, server and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103150647B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106020747A (en) * | 2016-05-31 | 2016-10-12 | 中铁武汉电气化局集团有限公司 | Label information conversion method and device and printing method and system |
| CN107967246A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | Report computational methods and device |
| CN108345512A (en) * | 2018-03-19 | 2018-07-31 | 重庆金融资产交易所有限责任公司 | Data verification method, server and storage medium |
| CN108595404A (en) * | 2018-05-04 | 2018-09-28 | 日照职业技术学院 | A kind of processing method and processing system of accounting statement |
| CN110321538B (en) * | 2019-06-20 | 2023-11-03 | 北京小笨鸟信息技术有限公司 | Intelligent offline data filling system |
| CN111414742A (en) * | 2020-03-18 | 2020-07-14 | 苏宁云计算有限公司 | Method and device for self-service configuration of form template |
| CN111782718B (en) * | 2020-08-11 | 2023-12-29 | 支付宝(杭州)信息技术有限公司 | Plug-in data reporting system and data reporting method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101196903A (en) * | 2007-12-27 | 2008-06-11 | 上海全景数字技术有限公司 | Universal report forms production apparatus and method |
| CN101419628A (en) * | 2008-12-03 | 2009-04-29 | 浪潮集团山东通用软件有限公司 | Data general-purpose leading-in method based on excel file format |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040083449A1 (en) * | 2002-10-21 | 2004-04-29 | The Boeing Comapny | System and method for batch-feeding data |
-
2013
- 2013-04-10 CN CN201310122129.5A patent/CN103150647B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101196903A (en) * | 2007-12-27 | 2008-06-11 | 上海全景数字技术有限公司 | Universal report forms production apparatus and method |
| CN101419628A (en) * | 2008-12-03 | 2009-04-29 | 浪潮集团山东通用软件有限公司 | Data general-purpose leading-in method based on excel file format |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
Non-Patent Citations (1)
| Title |
|---|
| 复杂报表系统的开发;石晓珍;《电脑编程技巧与维护》;20061231;全文 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
| CN107122344B (en) * | 2017-05-24 | 2020-09-18 | 中国农业银行股份有限公司 | Report generation method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103150647A (en) | 2013-06-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103150647B (en) | Report file disposal route, server and system | |
| CN104391934B (en) | Data verification method and device | |
| US8949166B2 (en) | Creating and processing a data rule for data quality | |
| US7328428B2 (en) | System and method for generating data validation rules | |
| US20130304713A1 (en) | System and method for metadata level validation of custom setup objects | |
| CN103838672A (en) | Automated testing method and device for all-purpose financial statements | |
| US20180285394A1 (en) | System and Method for Data Integration | |
| US11290294B2 (en) | Collaboration hub with blockchain verification | |
| CN112070608B (en) | Information processing method, device, medium and electronic equipment | |
| CN112016138A (en) | Method and device for automatic safe modeling of Internet of vehicles and electronic equipment | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| CN104965781A (en) | Method and apparatus for generating test case | |
| CN115016978A (en) | Data verification method and device, computer storage medium and electronic equipment | |
| EP3851955A1 (en) | Systems and methods for software documentation and code generation management | |
| CN113238739A (en) | Plug-in development and data acquisition method, device, electronic equipment and medium | |
| US10606569B2 (en) | Declarative configuration elements | |
| CN115130130B (en) | Network disk file unlocking method and device, network disk and storage medium | |
| CN112015715A (en) | Industrial Internet data management service testing method and system | |
| US11573773B2 (en) | Methods and systems for correlating source code commitments and model result records during model development | |
| CN115268847A (en) | Block chain intelligent contract generation method and device and electronic equipment | |
| Maiti | Capturing, Eliciting, and Prioritizing (CEP) Non-Functional Requirements Metadata during the Early Stages of Agile Software Development | |
| Oh et al. | Automatic extraction of dependencies between web components and database resources in java web applications | |
| CN113297028A (en) | Script execution method and device, computer equipment and storage medium | |
| CN112381509A (en) | Management system for major special topic of national science and technology for creating major new drug | |
| Bunke | Security-Pattern Recognition and Validation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |