[go: up one dir, main page]

CN107818098A - A kind of processing method of report data, device and electronic equipment - Google Patents

A kind of processing method of report data, device and electronic equipment Download PDF

Info

Publication number
CN107818098A
CN107818098A CN201610818135.8A CN201610818135A CN107818098A CN 107818098 A CN107818098 A CN 107818098A CN 201610818135 A CN201610818135 A CN 201610818135A CN 107818098 A CN107818098 A CN 107818098A
Authority
CN
China
Prior art keywords
data
report
processing
result
source
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
Application number
CN201610818135.8A
Other languages
Chinese (zh)
Inventor
刘悦韡
赵燕标
肖卓
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Alibaba Group Holding Ltd
Original Assignee
Alibaba Group Holding Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201610818135.8A priority Critical patent/CN107818098A/en
Publication of CN107818098A publication Critical patent/CN107818098A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing

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)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

A kind of processing method of report data of disclosure, including:Receive the operational order for the data segment input for being directed to source form in report page;Obtain processing parameter corresponding to the data segment;According to the configuration information of purpose form in the processing parameter, and the report page, judge whether the purpose form establishes incidence relation with the source form, if so, obtaining result according to the processing parameter and the data of the purpose form.The realization of the processing method of the report data is simple, and the operation that user participates in is less, improves interactive experience of the user to form, while reduces and due to mistake caused by user's operational error, improve the efficiency that user handles form.

Description

A kind of processing method of report data, device and electronic equipment
Technical field
The application is related to data processing field, and in particular to a kind of processing method of report data.The application is related to simultaneously A kind of processing unit of report data, and a kind of electronic equipment.
Background technology
With the rapid development of IT technology, form plateform system is used as one kind by computer technology and accounting compiling and assembling side Method it is designed in conjunction go out dedicated for report data processing software systems, also obtained quick development and popularization.Form is put down Platform system can help enterprise or user obtains, shown, filtering and analyze data, and according to enterprise or the need of user Ask, data message is presented to enterprise or user in a manner of form or figure, currently the form plateform system of most main flow is The Excel softwares of Microsoft's exploitation.
In the prior art, by taking the Excel softwares of Microsoft as an example, have on a report page Table A, Table B and Table C tri- open form, and the data row B1 in the data row A1 in Table A and Table B has incidence relation, and Table The data row C2 in data row B1 and Table C in B has incidence relation;If user wants to check Table A data row Some value α in A1, the corresponding value α in the data row B1 of data row A1 associations, and further pass through data row B2's Value β checks corresponding value β in the data row C2 that data row B2 is associated.Value α of the user manually in data row A1 is then needed, α is searched in data row B1 in Table B, after finding α in data row B1, the value in the data row B2 according to corresponding to α β, and finally find β in the data row C2 in Table C.
The defects of obvious be present in the processing method for the report data that above-mentioned prior art provides.
The processing method for the report data that prior art provides, user need manual to input phase in form to be found Answer data to be searched, obtain target data, search procedure is relatively complicated, further, since in search procedure user operation compared with It is more, it is easy to occur due to mistake caused by the operational error of user.
The content of the invention
The application provides a kind of processing method of report data, to solve cumbersome existing for prior art and easily go out The problem of wrong.
The application is related to a kind of processing unit of report data, and a kind of electronic equipment simultaneously.
The application provides a kind of processing method of report data, including:
Receive the operational order for the data segment input for being directed to source form in report page;
Obtain processing parameter corresponding to the data segment;
According to the configuration information of purpose form in the processing parameter, and the report page, the purpose report is judged Whether table establishes incidence relation with the source form, if so, being carried out according to the processing parameter and the data of the purpose form Data processing, obtain result.
Optionally, it is described to carry out data processing according to the processing parameter and the data of the purpose form, handled After result step performs, following steps are performed:
The respective result of purpose form is shown in the purpose form.
Optionally, the configuration information includes:
The row that associated data arranges in the report mark of the association form of current form, the association form identify, current report Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established in table with associated data row.
Optionally, the processing parameter obtains according to the configuration information of the source form.
Optionally, include in the processing parameter:
What the data segment, the report mark of the source form, the data segment corresponding data in the source form arranged Row mark, and/or data type.
Optionally, it is described to carry out data processing according to the processing parameter and the data of the purpose form, handled After result step performs, following step is performed:
According to the configuration information of purpose form corresponding to the result, secondary place corresponding to the result is obtained Manage parameter;
According to the after-treatment parameter, and in the report page purpose form and/or the source form configuration Information, judge that purpose form and/or source form purpose form corresponding with the result are in the report page It is no to establish incidence relation, if so, being established according to the after-treatment parameter and purpose form corresponding with the result The purpose form of incidence relation and/or the data of source form carry out data processing, obtain after-treatment result.
Optionally, association is established according to the after-treatment parameter and purpose form corresponding with the result to close The purpose form of system and/or the data of source form carry out data processing, after obtaining the execution of after-treatment result step, under execution State step:
Show that the purpose form and/or the source form are respective in the purpose form and/or the source form After-treatment result.
Optionally, the configuration information according to purpose form in the processing parameter, and the report page, judge Whether the purpose form establishes incidence relation with the source form, realizes in the following way:
For each purpose form, following sub-steps are performed:
According to the report mark of the source form included in the processing parameter, and the association report of the purpose form The report mark of table, judge the source form whether be the purpose form association form, if so, performing next step;
Identified according to the data segment row that corresponding data arranges in the source form, and the association of the purpose form The row mark that associated data arranges in form, judge whether data segment corresponding data row in the source form are the purpose Associated data arranges in the association form of form, if so, performing next step.
Optionally, if it is described judge the source form whether be the purpose form association form sub-step judgement knot Fruit is no, then returns to the operational order step for performing the data segment input for receiving and being directed to source form in report page.
Optionally, if described judge whether data segment corresponding data row in the source form are the purpose form Association form in associated data row sub-step judged result be it is no, then return perform it is described receive be directed to report page in source The operational order step of the data segment input of form.
Optionally, the configuration information according to purpose form in the processing parameter, and the report page, judge Whether the purpose form and the source form are established after incidence relation step performs, and it is described according to the processing parameter and The data of the purpose form carry out data processing, before obtaining the execution of result step, perform following step:
Judge the data type of the data segment and purpose form included in the processing parameter data type whether Unanimously, if so, performing next step.
Optionally, if the data type of the data segment for judging to include in the processing parameter and the purpose form The judged result of data type whether consistent step input be it is no, then by the data type conversion of the processing parameter for it is described The consistent data type of the data type of purpose form.
Optionally, if the configuration information according to purpose form in the processing parameter, and the report page, sentence The disconnected purpose form is no with the judged result whether the source form establishes incidence relation step, then returns and connect described in performing The operational order step narrowed to the data segment input of source form in report page.
Optionally, the operational order includes:Choose the operational order of the data segment.
The application also provides a kind of processing unit of report data, including:
Operational order receiving unit, the operational order of the data segment input of source form in report page is directed to for receiving;
Processing parameter acquiring unit, for obtaining processing parameter corresponding to the data segment;
Incidence relation judging unit, for being matched somebody with somebody according to purpose form in the processing parameter, and the report page Confidence ceases, and judges whether the purpose form establishes incidence relation with the source form, if so, operation result obtains list Member;
The result obtaining unit, for carrying out data according to the processing parameter and the data of the purpose form Processing, obtain result.
Optionally, the processing unit of the report data, including:
Result display unit, for showing the respective result of purpose form in the purpose form.
Optionally, the configuration information includes:
The row that associated data arranges in the report mark of the association form of current form, the association form identify, current report Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established in table with associated data row.
Optionally, the processing parameter obtains according to the configuration information of the source form.
Optionally, include in the processing parameter:
What the data segment, the report mark of the source form, the data segment corresponding data in the source form arranged Row mark, and/or data type.
Optionally, the processing unit of the report data, including:
After-treatment parameters unit is obtained, for the configuration information of the purpose form according to corresponding to the result, is obtained Take after-treatment parameter corresponding to the result;
Secondary incidence relation judging unit, for according to the after-treatment parameter, and purpose in the report page The configuration information of form and/or the source form, judge in the report page purpose form and/or the source form with it is described Whether purpose form establishes incidence relation corresponding to result, if so, operation after-treatment result obtaining unit;
The after-treatment result obtaining unit, for according to the after-treatment parameter and with the result pair The data of purpose form and/or source form that the purpose form answered establishes incidence relation carry out data processing, obtain after-treatment As a result.
Optionally, the processing unit of the report data, including:
After-treatment result display unit, for showing the purpose in the purpose form and/or the source form Form and/or the respective after-treatment result of the source form.
The application also provides a kind of electronic equipment, including:
Memory, and processor;
The memory is used to store computer executable instructions, and the processor can perform for performing the computer Instruction:
Receive the operational order for the data segment input for being directed to source form in report page;
Obtain processing parameter corresponding to the data segment;
According to the configuration information of purpose form in the processing parameter, and the report page, the purpose report is judged Whether table establishes incidence relation with the source form, if so, being carried out according to the processing parameter and the data of the purpose form Data processing, obtain result.
Compared with prior art, the application has advantages below:
The processing method for the report data that the application provides, including:Receive the data segment for being directed to source form in report page The operational order of input;Obtain processing parameter corresponding to the data segment;According to the processing parameter, and the report page The configuration information of middle purpose form, judges whether the purpose form establishes incidence relation with the source form, if so, according to institute The data for stating processing parameter and the purpose form carry out data processing, obtain result.
The processing method for the report data that the application provides, by receiving user for source form in report page The operational order of data segment input, obtains processing parameter corresponding to the data segment, with reference to purpose form in the report page Configuration information, judge whether the purpose form and the source form establish incidence relation, if the purpose form with it is described Source form establishes incidence relation, then carries out data processing according to the processing parameter and the data of the purpose form, so as to Obtain result corresponding to the operational order of user's input.The processing method of the report data, user need to only be directed to The data segment of source form is entered the operating instructions in report page, you can processing parameter corresponding to the data segment is substituted into the report Purpose form is handled in the table page, and obtains respective handling result, is realized simply, and the operation that user participates in is less, carries Interactive experience of the user to form has been risen, while has been reduced due to mistake caused by user's operational error, has improved user's processing The efficiency of form.
Brief description of the drawings
Accompanying drawing 1 is a kind of process chart of the processing method embodiment for report data that the application provides;
Accompanying drawing 2 is a kind of schematic diagram of form of the application offer before treatment;
Accompanying drawing 3 is the schematic diagram of another form of the application offer before treatment;
Accompanying drawing 4 is the schematic diagram of the third form of the application offer before treatment;
Accompanying drawing 5 is the schematic diagram after a kind of report form processing that the application provides;
Accompanying drawing 6 is the schematic diagram after another report form processing that the application provides;
Accompanying drawing 7 is the schematic diagram after the third report form processing that the application provides;
Accompanying drawing 8 is a kind of schematic diagram of the processing unit embodiment for report data that the application provides;
Accompanying drawing 9 is the schematic diagram for a kind of electronic equipment embodiment that the application provides.
Embodiment
Many details are elaborated in the following description in order to fully understand the application.But the application can be with Much it is different from other modes described here to implement, those skilled in the art can be in the situation without prejudice to the application intension Under do similar popularization, therefore the application is not limited by following public specific implementation.
The application provides a kind of processing method of report data, and the application also provides a kind of processing unit of report data, And a kind of electronic equipment.The accompanying drawing of the embodiment provided below in conjunction with the application is described in detail one by one, and right Each step of method illustrates.
A kind of processing method embodiment for report data that the application provides is as follows:
Referring to the drawings 1, a kind of handling process of the processing method embodiment of the report data provided it illustrates the application Figure, referring to the drawings 2, it illustrates a kind of form schematic diagram before treatment that the application provides, referring to the drawings 3, it illustrates The schematic diagram of another form that the application provides before treatment, referring to the drawings 4, it illustrates the third report that the application provides The schematic diagram of table before treatment, referring to the drawings 5, it illustrates the schematic diagram after a kind of report form processing of the application offer, reference Accompanying drawing 6, it illustrates the schematic diagram after another report form processing of the application offer, and referring to the drawings 7, it illustrates the application to carry Schematic diagram after the third report form processing supplied.
It is please 1 true with reference to the accompanying drawings in addition, the relation between each step of the processing method embodiment of the report data It is fixed.
Step S101, receive the operational order for the data segment input for being directed to source form in report page.
Form described in the embodiment of the present application, including form and chart for Dynamic Announce data.The report page is used Two forms at least be present in displaying form, the report page described in the present embodiment.In actual applications, form plateform system Only render when the chart in the form of front opening, example corresponding to generation, for the form being not turned on, chart therein will not It is rendered, i.e., will not generates corresponding example, therefore, in the specific implementation, can be by detecting the example of generation to obtain State all forms in report page.
The source form refers to be currently used in the form for receiving the operational order in the report page, the source form Can be any one form in the report page, i.e., it is defeated can be directed to any one form in the report page by user Enter the operational order.The data segment of the source form, can be any one in the source form or multiple data, Can be any a line in the source form either multirow data or any one row or multi-column data.For example, accompanying drawing 2 Data " 17 " in shown Table A, or, data in Table A " 6,14,17 ", or, the data in Table B " 17, machine table, 18, local ", or, the data " 17 " in the Table A shown in accompanying drawing 3, or, shown in accompanying drawing 4 Data " report_id=17 " in Chart D.
The operational order, refer to the command adapted thereto that user is operated to the data segment of the source form, for example, user By pressing the operational order of the mobile data segment for choosing source form sent after left mouse button, or user for source form The double-click instruction that data segment is sent.
In this step, the operational order that user is directed to the data segment input of source form in the report page is received.Avoid User hand input-data is handled, and is provided users with the convenient;Meanwhile the present embodiment can be selected by the operational order Described in source form one or more data as the data segment, either choose a line or multirow of the source form Data are either chosen the one of the source form to arrange or multi-column data are as the data segment, more entirely as the data segment Face.
Step S102, obtain processing parameter corresponding to the data segment.
In the present embodiment, each form in the report page is equipped with respective configuration information.The configuration Information includes:The row that associated data arranges in the report mark of the association form of current form, the association form identify, current report Row mark, Processing Algorithm and the data type of the data row of incidence relation are established in table with associated data row.
The association form, refer to the form that incidence relation is established with current form, for example, Table B and Table A are built Vertical incidence relation, then Table B are Table A association form, and Table A are also Table B association form.
The associated data row, refer to the data row that incidence relation is specifically established in the association form.For example, Table The data row B1 in data row A1 and Table B in A establishes incidence relation, then data row A1 is data row B1 associated data Row, data row B1 also arrange for data row A1 associated data.
The Processing Algorithm, refer to carry out data in form the specific algorithm used when processing calculates, each form Processing Algorithm can be configured by User Defined, in actual applications can be according to the actual requirements for each form configuration phase The Processing Algorithm answered, for example, common Processing Algorithm has the algorithm for filtering data:Be equal to, be not equal to, being more than, more than etc. In with less than.
The data type, refer to the type of data format of data in each form, for example, common data type has “num”、“string”。
In the specific implementation, the configuration information of the form can be shown by array, and the type of value is one by Map The array of composition, five fields are set in each Map, correspond to the association form in the configuration information respectively, associated data arranges, Data row, Processing Algorithm and data type.
For example, the data row B1 in Table A data row A1 and Table B establishes incidence relation, then Table A number It is believed that breath:
Table A.association=
[{ association form targetTable:Table B, associated data row targetColumn:B1, data row column: A1, Processing Algorithm operators:'=', data type type:'string'}]
In addition, the data row A1 in Table B data row B1 and Table A establishes incidence relation, and with Table C Data row C1 establish incidence relation;Meanwhile Table B data row B2 is established with the data row C2 in Table C and associated It is, then Table B configuration information:
Table B.association=
[{targetTable:Table A, targetColumn:A1, column:B1, operators:'=', type:' String'},
{targetTable:Table C, targetColumn:C1, column:B1, operators:'=', type:' String'},
{targetTable:Table C, targetColumn:C2, column:B2, operators:'>', type:' num'}]
Above-mentioned steps S101 receives the operational order that user is directed to the data segment input of source form in the report page, this In step, processing parameter corresponding to the data segment is obtained.In the specific implementation, processing parameter corresponding to the data segment, can Obtained with the configuration information of the form (i.e. described source form) belonged to according to the data segment.Specifically, the processing parameter In include:What the data segment, the report mark of the source form, the data segment corresponding data in the source form arranged Row mark.
For example, the data segment " 17 " that the operational order of user is chosen, the form Table A's belonged to according to data segment " 17 " Configuration information association.Table A=[{ association form targetTable:Table B, associated data row targetColumn:B1, data row column:A1, Processing Algorithm operators:'=', data type type:' String'}], processing parameter corresponding to acquisition data segment " 17 " is:
{ data row column:A1, data segment data:17, form table:A}.
In the present embodiment, after getting processing parameter corresponding to the data segment, broadcast model can be used, by the place The all purposes form that reason parameter is sent in the form of broadcasting in the report page is (except the source is reported in the report page All forms outside table).For example, the form in report page has:Table A, Table B and Chart C, divided by calling The broadcasting method of processing parameter is sent out, by processing parameter { data row column corresponding to data segment " 17 ":A1, data segment data: 17, form table:A }, it is respectively sent to Table B and Chart C.
In actual applications, a variety of concrete implementation modes can be used, realize the transmission of the processing parameter.Realize institute The various forms of changes of the transmission of processing parameter are stated, all the simply change of specific implementation, all without departing from the core of the application The heart, therefore all within the protection domain of the application.
Step S103, according to the configuration information of purpose form in the processing parameter, and the report page, judge institute State whether purpose form establishes incidence relation with the source form.
In this step, according to purpose in processing parameter, and the report page corresponding to the data segment of the source form The configuration information of form, judges whether the purpose form establishes incidence relation with the source form, if so, performing following step S104, the processing parameter and the data of the purpose form are substituted into the configuration information of the purpose form to the processing included Algorithm is calculated, and obtains result;If it is not, not dealing with then, or return and perform above-mentioned steps S101, receive user's pin The next operational order inputted to the data segment of the source form of the report page.
In the specific implementation, this step is according to the configuration of purpose form in the processing parameter, and the report page Information, judges whether the purpose form establishes incidence relation with the source form, can realize in the following way:
For each purpose form, following sub-steps are performed:
1) according to the report mark of the source form included in the processing parameter, and the association of the purpose form The report mark of form, judge the source form whether be the purpose form association form;
If so, performing following sub-steps 2);
If it is not, not dealing with then, or return and perform above-mentioned steps S101, receive the source that user is directed to the report page Next operational order of the data segment input of form.
For example, processing parameter corresponding to data segment " 17 " is:{ data row column:A1, data segment data:17, form table:A};The report mark of purpose form Table B association form includes:Table A、Table C;It then can determine that source is reported Table Table A are purpose form Table B association form.
2) identified according to the data segment row that corresponding data arranges in the source form, and the pass of the purpose form Join the row mark that associated data arranges in form, judge whether data segment corresponding data row in the source form are the mesh Form association form in associated data arrange;
If so, performing following step S104, the processing parameter and the data of the purpose form are substituted into the purpose The Processing Algorithm included in the configuration information of form is calculated, and obtains result;
If it is not, not dealing with then, or return and perform above-mentioned steps S101, receive the source that user is directed to the report page Next operational order of the data segment input of form.
For example, processing parameter corresponding to data segment " 17 " is:{ data row column:A1, data segment data:17, form table:A};The row mark of data row B1 associated data row includes in purpose form Table B:Table A、Table C;Then It can determine that the associated data row that the data row A1 in the form Table A of source is data row B1 in purpose form Table B.
In actual applications, a variety of concrete implementation modes can be used, realize the purpose form and the source form Whether the judgement of incidence relation is established.Realize whether the purpose form and the source form establish each of the judgement of incidence relation The change of kind form, all simply changes of specific implementation, all without departing from the core of the application, therefore all in the guarantor of the application Within the scope of shield.
Step S104, the processing parameter and the data of the purpose form are substituted into the configuration information of the purpose form In the Processing Algorithm that includes calculated, obtain result.
The premise that this step is carried out is in above-mentioned steps S103, according to the processing parameter, and the form page The configuration information of purpose form in face, judges whether the purpose form establishes the judged result of incidence relation with the source form It is yes, in this step, the processing parameter and the data of the purpose form is substituted into the configuration information of the purpose form Comprising Processing Algorithm calculated, obtain the result.
For example, as shown in Figure 2, the data of the data row id and purpose form Table B in the form Table A of source arrange Report_id establishes incidence relation, then by the number in data segment " 17 " and purpose form Table B data row report_id Calculated according to filter algorithm " being equal to " is substituted into, the result after filtering is:Purpose form Table B data row Report_id intermediate values are 17 data.
As shown in Figure 3, the data in the data row id in source form Table A and purpose form ChartC arrange Report_id establishes incidence relation, then by the number in data segment " 17 " and purpose form ChartC data row report_id According to substitution filter algorithm " being equal to " is calculated, and the result after filtering is:Purpose form ChartC data row Report_id intermediate values are 17 data.
As shown in Figure 4, the data row report_id in source form ChartD and purpose form ChartE data row id Incidence relation is established, then by the data in data segment " 17 " and purpose form ChartE data row id, substitutes into filter algorithm " etc. In " calculated, the result after filtering is:Purpose form ChartE data row id intermediate values are 17 data.
In actual applications, the data type of data can in source form described in the report page and the purpose form To be selected by User Defined, therefore, the data of the data type of data and data in the purpose form in the source form Type may be inconsistent, for such case, when it is implemented, before the execution of this step, performs data type and judges operation, Operation is judged by the data type to judge the data type of data and data in the purpose form in the source form Data type it is whether consistent, the data type judges that operation is implemented as follows:
Judge the data type of the data segment and purpose form included in the processing parameter data type whether Unanimously;
If consistent, this step is performed, the processing parameter and the data of the purpose form are substituted into the purpose report The Processing Algorithm included in the configuration information of table is calculated, and obtains the result;
If it is inconsistent, do not deal with, i.e., cannot corresponding result.
In addition, the data type is judged in operation, when the data type of data in the source form and the mesh Form in data data type it is inconsistent when, can also by the data type conversion of the processing parameter be and the purpose The consistent data type of the data type of form.
Step S105, the respective result of purpose form is shown in the purpose form.
The result obtained is calculated according to above-mentioned steps S104, in this step, is shown in the purpose form The respective result of purpose form.
For example, as shown in Figure 2, the data of the data row id and purpose form Table B in the form Table A of source arrange Report_id establishes incidence relation, then by the number in data segment " 17 " and purpose form Table B data row report_id According to, substitute into filter algorithm " being equal to " and calculated, the data row that the result after filtering is purpose form Table B Report_id intermediate values are 17 data, as shown in Figure 5, result are shown in Table B data row report_id.
As shown in Figure 3, the data in the data row id in source form Table A and purpose form ChartC arrange Report_id establishes incidence relation, then by the number in data segment " 17 " and purpose form ChartC data row report_id According to substitution filter algorithm " being equal to " is calculated, and the result after filtering is purpose form ChartC data row report_ Id intermediate values are 17 data, as shown in Figure 6, result are shown in ChartC data row report_id.
As shown in Figure 4, the data row report_id in source form ChartD and purpose form ChartE data row id Incidence relation is established, then by the data in data segment " 17 " and purpose form ChartE data row id, substitutes into filter algorithm " etc. In " calculated, the data that the data row id intermediate values that the result after filtering is purpose form ChartE are 17, such as accompanying drawing 7 It is shown, show result in ChartE data row id.
In addition, in the specific implementation, after above-mentioned steps S104 execution, secondary filter operation is can also carry out, according to Above-mentioned steps S104 calculates the result obtained, using the result as after-treatment parameter, utilizes described two Secondary processing parameter carries out secondary filter.The secondary filter operation is implemented as follows:
1) according to corresponding to the result purpose form configuration information, obtain secondary corresponding to the result Processing parameter;
2) according to the after-treatment parameter, and purpose form and/or the source form are matched somebody with somebody in the report page Confidence ceases, and judges purpose form and/or source form purpose form corresponding with the result in the report page Whether incidence relation is established;
If so, performing following step 3);
If it is not, do not deal with then.
3) the after-treatment parameter and purpose form corresponding with the result are established to the mesh of incidence relation Form and/or source form data, substitute into the purpose report that corresponding with result purpose form establishes incidence relation The Processing Algorithm included in the configuration information of table and/or source form is calculated, and obtains after-treatment result.
4) the purpose form and/or the source form are shown in the purpose form and/or the source form each After-treatment result.
In actual applications, a variety of concrete implementation modes can be used, realize the secondary filter operation.Described in realization The various forms of changes of secondary filter operation, all simply changes of specific implementation, all without departing from the core of the application, because This is all within the protection domain of the application.
It is similar with the operation of above-mentioned secondary filter, obtained when it is implemented, can also operate to calculate in the secondary filter After-treatment result on the basis of, using the after-treatment result as processing parameter three times, entered using processing parameter three times Row filters three times.Similar, it might even be possible to more frequently filtered on the basis of the filtering three times, obtain corresponding place Manage result, the core without departing from the application, therefore all within the protection domain of the application.
In summary, the processing method for the report data that the application provides, user is received first and is directed to report page The operational order of the data segment input of middle source form, and processing parameter corresponding to the data segment is obtained, with reference to the form page The configuration information of purpose form in face, judges whether the purpose form establishes incidence relation with the source form, if the mesh Form and the source form establish incidence relation, the processing parameter and the data of the purpose form are substituted into the mesh Form configuration information in the Processing Algorithm that includes calculated, so as to obtain corresponding to the operational order of user's input Result.The processing method of the report data, user need to only be directed to the data segment input operation of source form in report page Instruction, you can processing parameter corresponding to the data segment is substituted into purpose form in the report page and handled, and is obtained Respective handling result, realize simply, and the operation that user participates in is less, improves interactive experience of the user to form, subtracts simultaneously Lack and due to mistake caused by user's operational error, improved the efficiency that user handles form.
A kind of processing unit embodiment for report data that the application provides is as follows:
In the above-described embodiment, there is provided a kind of processing method of report data, corresponding, the application also carries A kind of processing unit of report data has been supplied, has been illustrated below in conjunction with the accompanying drawings.
Referring to the drawings 8, a kind of schematic diagram of the processing unit embodiment of the report data provided it illustrates the application.
Because device embodiment is substantially similar to embodiment of the method, so describing fairly simple, related part please join The corresponding explanation of the embodiment of the method for above-mentioned offer is provided.Device embodiment described below is only schematical.
The application provides a kind of processing unit of report data, including:
Operational order receiving unit 801, the operation that the data segment input of source form in report page is directed to for receiving refer to Order;
Processing parameter acquiring unit 802, for obtaining processing parameter corresponding to the data segment;
Incidence relation judging unit 803, for according to purpose form in the processing parameter, and the report page Configuration information, judges whether the purpose form establishes incidence relation with the source form, if so, operation result obtains list Member 804;
The result obtaining unit 804, for according to the processing parameter and the progress of the data of the purpose form Data processing, obtain result.
Optionally, the processing unit of the report data, including:
Result display unit, for showing the respective result of purpose form in the purpose form.
Optionally, the configuration information includes:
The row that associated data arranges in the report mark of the association form of current form, the association form identify, current report Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established in table with associated data row.
Optionally, the processing parameter obtains according to the configuration information of the source form.
Optionally, include in the processing parameter:
What the data segment, the report mark of the source form, the data segment corresponding data in the source form arranged Row mark, and/or data type.
Optionally, the processing unit of the report data, including:
After-treatment parameters unit is obtained, for the configuration information of the purpose form according to corresponding to the result, is obtained Take after-treatment parameter corresponding to the result;
Secondary incidence relation judging unit, for according to the after-treatment parameter, and purpose in the report page The configuration information of form and/or the source form, judge in the report page purpose form and/or the source form with it is described Whether purpose form establishes incidence relation corresponding to result, if so, operation after-treatment result obtaining unit;
The after-treatment result obtaining unit, for according to the after-treatment parameter and with the result pair The data of purpose form and/or source form that the purpose form answered establishes incidence relation carry out data processing, obtain after-treatment As a result.
Optionally, the processing unit of the report data, including:
After-treatment result display unit, for showing the purpose in the purpose form and/or the source form Form and/or the respective after-treatment result of the source form.
Optionally, the incidence relation judging unit 803, including:
Form judgment sub-unit is associated, for the report mark according to the source form included in the processing parameter, And the purpose form association form report mark, judge the source form whether be the purpose form association report Table, if so, operation associated data row judgment sub-unit;
The associated data row judgment sub-unit, for according to the data segment in the source form corresponding data arrange The row mark that associated data arranges in row mark, and the association form of the purpose form, judges the data segment in the source In form corresponding data row whether be the purpose form association form in associated data arrange, if so, operation it is described processing knot Fruit obtaining unit 804;
For each purpose form, run the association form judgment sub-unit and associated data row judge that son is single Member.
Optionally, if the judged result of the association form judgment sub-unit output is no, the operational order is run Receiving unit 801.
Optionally, if the judged result of associated data row judgment sub-unit output is no, run the operation and refer to Make receiving unit 801.
Optionally, the processing unit of the report data, including:
Data type judging unit, for the data type of data segment and the mesh for judging to include in the processing parameter Form data type it is whether consistent, if so, running the result obtaining unit 804.
Optionally, if the judged result of data type judging unit output is no, the conversion of service data type is single Member;
Wherein, the data type conversion unit, for being and the mesh by the data type conversion of the processing parameter Form the consistent data type of data type.
Optionally, if the judged result of the incidence relation judging unit 803 output is no, the operational order is run Receiving unit 801.
Optionally, the operational order includes:
Choose the operational order of the data segment.
The a kind of electronic equipment embodiment that the application provides is as follows:
In the above-described embodiment, there is provided a kind of processing method of report data, in addition, present invention also provides one kind For the electronic equipment for the processing method for realizing the report data, illustrate below in conjunction with the accompanying drawings.
Referring to the drawings 9, the schematic diagram of a kind of electronic equipment provided it illustrates the present embodiment.
The electronic equipment embodiment that the application provides describes fairly simple, and related part refers to above-mentioned offer The report data processing method embodiment corresponding explanation.Embodiment described below is only schematical.
The application provides a kind of electronic equipment, including:
Memory 901, and processor 902;
The memory 901 is used to store computer executable instructions, and the processor 902 is used to perform the computer Executable instruction:
Receive the operational order for the data segment input for being directed to source form in report page;
Obtain processing parameter corresponding to the data segment;
According to the configuration information of purpose form in the processing parameter, and the report page, the purpose report is judged Whether table establishes incidence relation with the source form, if so, being carried out according to the processing parameter and the data of the purpose form Data processing, obtain result.
Optionally, it is described to carry out data processing according to the processing parameter and the data of the purpose form, handled After object command performs, the processor 902 is additionally operable to perform following computer executable instructions:
The respective result of purpose form is shown in the purpose form.
Optionally, the configuration information includes:
The row that associated data arranges in the report mark of the association form of current form, the association form identify, current report Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established in table with associated data row.
Optionally, the processing parameter obtains according to the configuration information of the source form.
Optionally, include in the processing parameter:
What the data segment, the report mark of the source form, the data segment corresponding data in the source form arranged Row mark, and/or data type.
Optionally, it is described to carry out data processing according to the processing parameter and the data of the purpose form, handled After object command performs, the processor 902 is additionally operable to perform following computer executable instructions:
According to the configuration information of purpose form corresponding to the result, secondary place corresponding to the result is obtained Manage parameter;
According to the after-treatment parameter, and in the report page purpose form and/or the source form configuration Information, judge that purpose form and/or source form purpose form corresponding with the result are in the report page It is no to establish incidence relation, if so, being established according to the after-treatment parameter and purpose form corresponding with the result The purpose form of incidence relation and/or the data of source form carry out data processing, obtain after-treatment result.
Optionally, described established according to the after-treatment parameter and purpose form corresponding with the result is closed The purpose form of connection relation and/or the data of source form carry out data processing, after obtaining after-treatment object command execution, institute Processor 902 is stated to be additionally operable to perform following computer executable instructions:
Show that the purpose form and/or the source form are respective in the purpose form and/or the source form After-treatment result.
Optionally, the configuration information according to purpose form in the processing parameter, and the report page, judge Whether the purpose form establishes incidence relation with the source form, realizes in the following way:
For each purpose form, following sub-steps are performed:
According to the report mark of the source form included in the processing parameter, and the association report of the purpose form The report mark of table, judge the source form whether be the purpose form association form, if so, performing next step;
Identified according to the data segment row that corresponding data arranges in the source form, and the association of the purpose form The row mark that associated data arranges in form, judge whether data segment corresponding data row in the source form are the purpose Associated data arranges in the association form of form, if so, performing next step.
Optionally, if it is described judge the source form whether be the purpose form association form sub-step judgement knot Fruit is no, then returns to the operational order step for performing the data segment input for receiving and being directed to source form in report page.
Optionally, if described judge whether data segment corresponding data row in the source form are the purpose form Association form in associated data row sub-step judged result be it is no, then return perform it is described receive be directed to report page in source The operational order step of the data segment input of form.
Optionally, the configuration information according to purpose form in the processing parameter, and the report page, judge Whether the purpose form and the source form are established after incidence relation instruction performs, and it is described according to the processing parameter and The data of the purpose form carry out data processing, and before obtaining result instruction execution, the processor 902 is additionally operable to hold The following computer executable instructions of row:
Judge the data type of the data segment and purpose form included in the processing parameter data type whether Unanimously, if so, performing next step.
Optionally, if the data type of the data segment for judging to include in the processing parameter and the purpose form The judged result of data type whether consistent step input be it is no, then by the data type conversion of the processing parameter for it is described The consistent data type of the data type of purpose form.
Optionally, if the configuration information according to purpose form in the processing parameter, and the report page, sentence The disconnected purpose form is no with the judged result whether the source form establishes incidence relation step, then returns and connect described in performing The operational order step narrowed to the data segment input of source form in report page.
Optionally, the operational order includes:
Choose the operational order of the data segment.
Although the application is disclosed as above with preferred embodiment, it is not for limiting the application, any this area skill Art personnel are not being departed from spirit and scope, can make possible variation and modification, therefore the guarantor of the application Shield scope should be defined by the scope that the application claim is defined.
In a typical configuration, computing device includes one or more processors (CPU), input/output interface, net Network interface and internal memory.
Internal memory may include computer-readable medium in volatile memory, random access memory (RAM) and/or The forms such as Nonvolatile memory, such as read-only storage (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium Example.
1st, computer-readable medium can be by any side including permanent and non-permanent, removable and non-removable media Method or technology realize that information stores.Information can be computer-readable instruction, data structure, the module of program or other numbers According to.The example of the storage medium of computer includes, but are not limited to phase transition internal memory (PRAM), static RAM (SRAM), dynamic random access memory (DRAM), other kinds of random access memory (RAM), read-only storage (ROM), Electrically Erasable Read Only Memory (EEPROM), fast flash memory bank or other memory techniques, read-only optical disc are read-only Memory (CD-ROM), digital versatile disc (DVD) or other optical storages, magnetic cassette tape, tape magnetic rigid disk storage or Other magnetic storage apparatus or any other non-transmission medium, the information that can be accessed by a computing device available for storage.According to Herein defines, and computer-readable medium does not include non-temporary computer readable media (transitory media), such as modulates Data-signal and carrier wave.
2nd, it will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program production Product.Therefore, the application can use the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware Form.Moreover, the application can use the computer for wherein including computer usable program code in one or more can use The computer program product that storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.) Form.

Claims (22)

  1. A kind of 1. processing method of report data, it is characterised in that including:
    Receive the operational order for the data segment input for being directed to source form in report page;
    Obtain processing parameter corresponding to the data segment;
    According to the configuration information of purpose form in the processing parameter, and the report page, judge the purpose form with Whether the source form establishes incidence relation, if so, carrying out data according to the processing parameter and the data of the purpose form Processing, obtain result.
  2. 2. the processing method of report data according to claim 1, it is characterised in that it is described according to the processing parameter and The data of the purpose form carry out data processing, after obtaining the execution of result step, perform following steps:
    The respective result of purpose form is shown in the purpose form.
  3. 3. the processing method of report data according to claim 1, it is characterised in that the configuration information includes:
    The row that associated data arranges in the report mark of the association form of current form, the association form identify, in current form Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established with associated data row.
  4. 4. the processing method of report data according to claim 3, it is characterised in that the processing parameter is according to the source The configuration information of form obtains.
  5. 5. the processing method of report data according to claim 4, it is characterised in that include in the processing parameter:
    The data segment, the report mark of the source form, the data segment row mark that corresponding data arranges in the source form Knowledge, and/or data type.
  6. 6. the processing method of report data according to claim 5, it is characterised in that it is described according to the processing parameter and The data of the purpose form carry out data processing, after obtaining the execution of result step, perform following step:
    According to the configuration information of purpose form corresponding to the result, obtain after-treatment corresponding to the result and join Number;
    According to the after-treatment parameter, and the configuration information of purpose form and/or the source form in the report page, Judge whether purpose form and/or source form purpose form corresponding with the result are established in the report page Incidence relation, closed if so, establishing association according to the after-treatment parameter and purpose form corresponding with the result The purpose form of system and/or the data of source form carry out data processing, obtain after-treatment result.
  7. 7. the processing method of report data according to claim 6, it is characterised in that described to join according to the after-treatment The data of purpose form and/or source form that number and purpose form corresponding with the result establish incidence relation are carried out Data processing, after obtaining the execution of after-treatment result step, perform following step:
    Show that the purpose form and/or the source form are respective secondary in the purpose form and/or the source form Result.
  8. 8. the processing method of report data according to claim 5, it is characterised in that it is described according to the processing parameter, And in the report page purpose form configuration information, judge that the purpose form associates with whether the source form is established Relation, realize in the following way:
    For each purpose form, following sub-steps are performed:
    According to the report mark of the source form included in the processing parameter, and the association form of the purpose form Report mark, judge the source form whether be the purpose form association form, if so, performing next step;
    Identified according to the data segment row that corresponding data arranges in the source form, and the association form of the purpose form The row mark of middle associated data row, judge whether data segment corresponding data row in the source form are the purpose form Association form in associated data arrange, if so, performing next step.
  9. 9. the processing method of report data according to claim 8, it is characterised in that if described judge that the source form is The judged result of the no association form sub-step for the purpose form is no, then returns to the execution reception and be directed to report page The operational order step of the data segment input of middle source form.
  10. 10. the processing method of report data according to claim 8, it is characterised in that if described judge the data segment In the source form corresponding data row whether be the purpose form association form in associated data row sub-step judgement As a result it is no, then returns to the operational order step for performing the data segment input for receiving and being directed to source form in report page.
  11. 11. the processing method of report data according to claim 5, it is characterised in that it is described according to the processing parameter, And in the report page purpose form configuration information, judge that the purpose form associates with whether the source form is established After relationship step performs, and it is described according to the processing parameter and the progress data processing of the data of the purpose form, obtain Before result step performs, following step is performed:
    Whether the data type for the data segment for judging to include in the processing parameter is consistent with the data type of the purpose form, If so, perform next step.
  12. 12. the processing method of report data according to claim 11, it is characterised in that if described judge the processing ginseng The judged result of the data type of the data segment included in number whether consistent step input with the data type of the purpose form It is no, then is the data type consistent with the data type of the purpose form by the data type conversion of the processing parameter.
  13. 13. the processing method of report data according to claim 1, it is characterised in that if described join according to the processing Number, and in the report page purpose form configuration information, judge whether the purpose form is established with the source form The judged result of incidence relation step is no, then returns and perform the data segment input for receiving and being directed to source form in report page Operational order step.
  14. 14. the processing method of report data according to claim 1, it is characterised in that the operational order includes:
    Choose the operational order of the data segment.
  15. A kind of 15. processing unit of report data, it is characterised in that including:
    Operational order receiving unit, the operational order of the data segment input of source form in report page is directed to for receiving;
    Processing parameter acquiring unit, for obtaining processing parameter corresponding to the data segment;
    Incidence relation judging unit, for matching somebody with somebody confidence according to purpose form in the processing parameter, and the report page Breath, judges whether the purpose form establishes incidence relation with the source form, if so, operation result obtaining unit;
    The result obtaining unit, for being carried out according to the processing parameter and the data of the purpose form at data Reason, obtain result.
  16. 16. the processing unit of report data according to claim 15, it is characterised in that including:
    Result display unit, for showing the respective result of purpose form in the purpose form.
  17. 17. the processing unit of report data according to claim 16, it is characterised in that the configuration information includes:
    The row that associated data arranges in the report mark of the association form of current form, the association form identify, in current form Row mark, Processing Algorithm and/or the data type of the data row of incidence relation are established with associated data row.
  18. 18. the processing unit of report data according to claim 17, it is characterised in that the processing parameter is according to The configuration information of source form obtains.
  19. 19. the processing unit of report data according to claim 18, it is characterised in that included in the processing parameter Have:
    The data segment, the report mark of the source form, the data segment row mark that corresponding data arranges in the source form Knowledge, and/or data type.
  20. 20. the processing unit of report data according to claim 19, it is characterised in that including:
    After-treatment parameters unit is obtained, for the configuration information of the purpose form according to corresponding to the result, obtains institute State after-treatment parameter corresponding to result;
    Secondary incidence relation judging unit, for according to the after-treatment parameter, and purpose form in the report page And/or the configuration information of the source form, judge purpose form and/or the source form and the processing in the report page As a result whether corresponding purpose form establishes incidence relation, if so, operation after-treatment result obtaining unit;
    The after-treatment result obtaining unit, for according to the after-treatment parameter and corresponding with the result The data of purpose form and/or source form that purpose form establishes incidence relation carry out data processing, obtain after-treatment result.
  21. 21. the processing unit of report data according to claim 20, it is characterised in that including:
    After-treatment result display unit, for showing the purpose form in the purpose form and/or the source form And/or the respective after-treatment result of source form.
  22. 22. a kind of electronic equipment, it is characterised in that including:
    Memory, and processor;
    The memory is used to store computer executable instructions, and the processor is used to perform the executable finger of the computer Order:
    Receive the operational order for the data segment input for being directed to source form in report page;
    Obtain processing parameter corresponding to the data segment;
    According to the configuration information of purpose form in the processing parameter, and the report page, judge the purpose form with Whether the source form establishes incidence relation, if so, carrying out data according to the processing parameter and the data of the purpose form Processing, obtain result.
CN201610818135.8A 2016-09-12 2016-09-12 A kind of processing method of report data, device and electronic equipment Pending CN107818098A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610818135.8A CN107818098A (en) 2016-09-12 2016-09-12 A kind of processing method of report data, device and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610818135.8A CN107818098A (en) 2016-09-12 2016-09-12 A kind of processing method of report data, device and electronic equipment

Publications (1)

Publication Number Publication Date
CN107818098A true CN107818098A (en) 2018-03-20

Family

ID=61601106

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610818135.8A Pending CN107818098A (en) 2016-09-12 2016-09-12 A kind of processing method of report data, device and electronic equipment

Country Status (1)

Country Link
CN (1) CN107818098A (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101639855A (en) * 2009-09-02 2010-02-03 华为技术有限公司 Report inquiry method and device thereof
CN102567792A (en) * 2010-12-17 2012-07-11 金蝶软件(中国)有限公司 Penetration method and penetration system
CN102867068A (en) * 2012-09-28 2013-01-09 用友软件股份有限公司 Report penetration device and report penetration method for online analytical processing system
US8380742B2 (en) * 2006-10-10 2013-02-19 Microsoft Corporation Integration of database reporting with ERP systems
CN103488692A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data query system and data query method
CN104516916A (en) * 2013-09-29 2015-04-15 华为技术有限公司 Method and device for analyzing network report incidence relation
CN105046415A (en) * 2015-06-29 2015-11-11 用友优普信息技术有限公司 Document joint-check method and document joint-check device

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8380742B2 (en) * 2006-10-10 2013-02-19 Microsoft Corporation Integration of database reporting with ERP systems
CN101639855A (en) * 2009-09-02 2010-02-03 华为技术有限公司 Report inquiry method and device thereof
CN102567792A (en) * 2010-12-17 2012-07-11 金蝶软件(中国)有限公司 Penetration method and penetration system
CN102867068A (en) * 2012-09-28 2013-01-09 用友软件股份有限公司 Report penetration device and report penetration method for online analytical processing system
CN103488692A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data query system and data query method
CN104516916A (en) * 2013-09-29 2015-04-15 华为技术有限公司 Method and device for analyzing network report incidence relation
CN105046415A (en) * 2015-06-29 2015-11-11 用友优普信息技术有限公司 Document joint-check method and document joint-check device

Similar Documents

Publication Publication Date Title
CN111917878B (en) Message processing method, device, equipment and storage medium
CN102930023B (en) Knowledge based engineering data quality solution
WO2020037918A1 (en) Risk control strategy determining method based on predictive model, and related device
US12393843B2 (en) Human-machine multi-turn conversation method and system for human-machine interaction, and intelligent apparatus
WO2019236277A1 (en) Automatically generating conversational services from a computing application
CN110378749A (en) Appraisal procedure, device, terminal device and the storage medium of user data similitude
CN111813910A (en) Method, system, terminal device and computer storage medium for updating customer service problem
CN109002515A (en) A kind of method and apparatus of intelligent response
WO2014052500A1 (en) Method and apparatus for providing a critical thinking exercise
Li et al. Deceptive semantic shortcuts on reasoning chains: How far can models go without hallucination?
TWI798652B (en) A method and system for automatically generating a data collection module
KR20230015872A (en) Human-computer interaction method and apparatus, storage medium and electronic device
CN109814960A (en) A kind of page returning method, device, electronic equipment and storage medium
CN112463986A (en) Information storage method and device
CN107480036A (en) Automatic test approach, device, storage medium and the terminal of iOS Mobile solutions
CN111382252A (en) Question category determination method, device, equipment and medium based on user request
CN117131179A (en) A dialogue processing method, device, storage medium and electronic equipment
CN105335466A (en) Audio data retrieval method and apparatus
CN116643755B (en) Code generation method, code generation device, visualization platform and electronic device
CN112470216A (en) Voice application platform
CN103699590A (en) Method and server for providing graphic tutorial problem solution
CN107423105A (en) A kind of automatic generation method of interface document
CN120653405A (en) Multi-agent arrangement method, equipment and storage medium based on service grid
CN107818098A (en) A kind of processing method of report data, device and electronic equipment
CN119151009A (en) Data processing method and device based on data form and electronic equipment

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

Application publication date: 20180320

RJ01 Rejection of invention patent application after publication