CN101320388A - Method and apparatus for filtering documents according to documents state - Google Patents
Method and apparatus for filtering documents according to documents state Download PDFInfo
- Publication number
- CN101320388A CN101320388A CNA2008101265945A CN200810126594A CN101320388A CN 101320388 A CN101320388 A CN 101320388A CN A2008101265945 A CNA2008101265945 A CN A2008101265945A CN 200810126594 A CN200810126594 A CN 200810126594A CN 101320388 A CN101320388 A CN 101320388A
- Authority
- CN
- China
- Prior art keywords
- document
- status
- filtration
- metadata
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for filtering a bill according to the status of the bill, which comprises the following steps: first, the label parameter of the bill status field is obtained from a preset bill metadata sheet; the label parameter is used to label the corresponding filter status of the bill status field; when the value of the label parameter is an effective value, the filter status information of the bill status field is obtained from a preset bill filter status sheet; the filter status information includes a filter status type and the metadata expression of the filter status type; the filter status type is added to a bill filter interface; finally, the filter status type selected by the user on the bill filter interface is obtained, and the corresponding metadata expression of the filter status type is taken as the filter condition. The method can reduce the development and maintenance cost of source code revision, and effectively improve the filter performance.
Description
Technical field
The present invention relates to the database processing field, particularly relate to and a kind ofly filter the method for document and filter the device of document according to document status according to document status.
Background technology
Enterprise resource planning (Enterprise Resource Planning, ERP), be meant and be based upon on the infotech basis, all resources (logistics, cash flow, information flow or human resources) to enterprise are integrated integrated management, adopt information-based means to realize enterprise's supply and marketing chain management, thereby reach the purpose that each link on the supply chain is realized scientific management.In ERP system, need to generate various types of documents as business voucher, can be by duplicating the single document that generates of order, invoice or outbound, for example invoice for sales can generate by duplicating sales order.Document status refers to the residing state of document, for example, " settling accounts ", " not clearing ", " pending accounts " or " paid " etc., according to described document status, the user can filter document, to pick out qualified document according to different demands.Simultaneously, document status can increase or reduce along with the continuous increase of user's request, and this variation will cause common software can't satisfy the demand that the user filters document status, and the code that needs generally speaking to revise common software meets the different needs.
In the prior art, have a kind of under the situation of newly-increased or minimizing document status, carry out the method that document filters according to document status, its implementation procedure is: at first on the design platform document status field on the document is being increased or deletion action, then according to described content of operation, revise the backstage code of document filtering interface by the developer, in code, increase the operation information of described increase or deletion document status, to upgrade the document filtering interface, supply the user according to different demands then, select document status that document is filtered on the document filtering interface, the document status of selecting according to the user realizes the filtration of document at last.
But also there is shortcoming in this method, when each document status need change, all needs to revise the backstage code of document filtering interface, to satisfy the document status filtration needs after document status changes; Modification to the backstage code makes exploitation relative higher with the cost of safeguarding, further, because frequently revise the operation of code, also can bring the decline of document status strainability.
In a word, need the urgent technical matters that solves of those skilled in the art to be exactly at present: the proposition how can innovate is a kind of can to reduce cost of development, effectively promotes the method according to document status filtration document of strainability.
Summary of the invention
Technical matters to be solved by this invention provides a kind of method of filtering document according to document status, can reduce cost of development, effectively promotes strainability.
The present invention also provides a kind of device according to document status filtration document, in order to guarantee said method realization and application in practice.
In order to address the above problem, the invention discloses a kind of method of filtering document according to document status, comprising:
From the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
When the value of described identification parameter is an effective value, filter the state table from the document that presets, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Described filtration Status Type is added on the document filtering interface;
Obtain the filtration Status Type that the user selects on described document filtering interface, and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered.
Preferably, described with described filtration Status Type metadata corresponding expression formula as filtercondition, the step that document to be filtered is filtered comprises:
Read the metadata of described filtration Status Type and express formula;
Replace the conditional-variable in the described metadata expression formula, generate peek SQL;
According to described peek SQL document to be filtered is filtered.
Preferably, described document to be filtered is filtered after, also comprise:
Form with the interface shows the document filter result.
Preferably, described document status is the audit state, and described document status field is person approving's field.
Preferably, described audit state comprises all, has examined or not audit.
Preferably, described method is applied in the ERP system.
The embodiment of the invention also discloses a kind of device, comprise according to document status filtration document
First acquisition module, be used for from described document metadata table, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
Second acquisition module, be used for when the value of described identification parameter is an effective value, filter the state table from described document, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type expression formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Add module, be used for adding described filtration Status Type to the document filtering interface;
The 3rd acquisition module is used to obtain the filtration Status Type that the user selects on described document filtering interface;
First filtering module is used for described filtration Status Type metadata corresponding expression formula as filtercondition document to be filtered being filtered.
Preferably, described document filtering module comprises:
Reading submodule, the metadata that is used to read described filtration Status Type is expressed formula;
Replace submodule, be used for replacing the conditional-variable of described metadata expression formula, generate peek SQL;
Second filters submodule, is used for according to described peek SQL document to be filtered being filtered.
Preferably, also comprise:
Display module is used for showing the document filter result with the form at interface.
Preferably, described document status is the audit state, and described document status field is person approving's field.
Compared with prior art, the present invention has the following advantages:
The present invention is by from the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, when the value of described identification parameter is an effective value, filter the state table from the document that presets again, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type expression formula, then described filtration Status Type is added on the document filtering interface; Obtain the filtration Status Type that the user selects at last on described document filtering interface, and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered.The present invention is by filtering the filtration status information of obtaining document status the state table from document metadata table and the document that presets, can be reduced in the development and maintenance cost that to revise source code when filtering document, further, because document status information loads and resolves by unified method, can also effectively promote the strainability of document.
Description of drawings
Fig. 1 is a kind of process flow diagram that filters the method embodiment 1 of document according to document status of the present invention;
Fig. 2 is a kind of process flow diagram that filters the method embodiment 2 of document according to document status of the present invention;
Fig. 3 is the synoptic diagram of a document design interface in the object lesson of the present invention;
Fig. 4 is the synoptic diagram of document filtering interface one in the object lesson of the present invention;
Fig. 5 is the synoptic diagram of document filtering interface two in the object lesson of the present invention;
Fig. 6 is an interface synoptic diagram of document filter result in the object lesson of the present invention;
Fig. 7 is a kind of structured flowchart that filters the device embodiment of document according to document status of the present invention;
Fig. 8 is a kind of structured flowchart that filters the device preferred embodiment of document according to document status of the present invention;
Fig. 9 uses the process flow diagram that preferred embodiment shown in Figure 8 filters document.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The present invention can be used in numerous general or special purpose calculation element environment or the configuration.For example: personal computer, server computer, handheld device or portable set, plate equipment, multiprocessor device, comprise distributed computing environment of above any device or equipment or the like.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in distributed computing environment, put into practice the present invention, in these distributed computing environment, by by communication network connected teleprocessing equipment execute the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
One of core idea of the embodiment of the invention is, at first from the document metadata table that presets, obtain the identification parameter of document status field, and when the value of described identification parameter is an effective value, filter the state table from the document that presets, obtain the filtration status information of described document status field again, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type expression formula, then described filtration Status Type is added on the document filtering interface; Obtain the filtration Status Type that the user selects at last on described document filtering interface, and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered.The present invention is by filtering state table from document metadata table and the document that presets, can obtain the identification parameter of document status field, and the filtration status information of described document status field, can make the user select to add to document status on the document filtering interface as required, thereby realize purpose according to the document status filtration document of user's selection, thereby need revise the development and maintenance cost that source code brings when being reduced in document status and changing, further, because document status information loads and resolves by unified method, can also effectively promote the strainability of document.
With reference to figure 1, show and of the present inventionly a kind ofly filter the process flow diagram of the method embodiment 1 of document according to document status, can may further comprise the steps:
Step 101: from the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
Step 102: when the value of described identification parameter is an effective value, filter the state table from the document that presets, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Step 103: described filtration Status Type is added on the document filtering interface;
Step 104: obtain the filtration Status Type that the user selects on described document filtering interface, and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered.
Need to prove, in the present embodiment, described method can be applied in the ERP system, also can be applied to other transaction processing system, described document status can be the audit state, described document status field can be person approving's field, described audit state can comprise all, examine or do not examined state, certainly, those skilled in the art can know easily, described document status can also be " settling accounts ", " not clearing " or states such as " pending accounts ", and therefore, the present invention does not make particular determination to the particular content of document status;
As can be seen, in the present embodiment, document metadata table that presets by use and document filter the filtration status information of state table, can make user's maintenance cost to code when realizing individual demand reach zero; Simultaneously, in the process of filtering document, when needing to realize user's individual demand, also can be easy to the data in described document metadata table and the document filtration state table are safeguarded, thereby satisfy the different new demand of user; Further, can also make the user increase newly, delete and revise described document metadata table and document filters data message in the state table, can be under the situation that document status increases or reduces, also can be under the situation of not changing source code, reduced development and maintenance cost, further, because document status information loads and resolves by unified method, can also promote the performance that document filters.
With reference to figure 2, show and of the present inventionly a kind ofly filter the process flow diagram of the method embodiment 2 of document according to document status, can may further comprise the steps:
Step 201: from the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
In this step, described document metadata table can be used to write down the identification parameter of document mode field, can also be used to write down the transaction types of document, perhaps other attributive character of document status field, for example, the title of document status field is described, described document metadata table can be set up in advance, when document status need increase newly or reduce, can insert the data message of document status field in described document metadata table, described data message meets the data layout requirement of described document metadata table;
Step 202: when the value of described identification parameter is an effective value, filter the state table, obtain the filtration status information of described document status field from the document that presets;
Need to prove, described filtration status information can comprise the filtration Status Type, and the metadata of described filtration Status Type is expressed formula, described document filters state table can be used to write down the filtration status information corresponding with described identification parameter, described document metadata table filters state table with document can be related by described identification parameter, described document filters in the state table, can write down the filtration status information of the document filtration state of described identification parameter correspondence;
Step 203: described filtration Status Type is added on the document filtering interface;
According to the filtration status information that gets access in the step 202, can be with described filtration Status Type, add on the document filtering interface in the mode of control, can present to the user easily with the mode of combobox, when needed, also can on described document filtering interface, increase a plurality of controls, make the user can when described document filtering interface is selected to filter document, need the document status of foundation, thereby realize the purpose that the selected document status of foundation is filtered document;
Step 204: obtain the filtration Status Type that the user selects on described document filtering interface;
After adding described filtration state to the document filtering interface, the user can select according to different document status on the described document filtering interface, the purpose of this step be exactly obtain user-selected need be as the document status of filtercondition, think that next step filters document to be filtered to prepare;
Step 205: and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered;
Preferably, this step can realize by following substep:
Substep 2051: the metadata that reads described filtration Status Type is expressed formula;
At first read with the corresponding metadata of described filtration Status Type and express formula,
Substep 2052: replace the conditional-variable in the described metadata expression formula, the Structured Query Language (SQL) of generation peek (Structured Query Language, SQL);
With the conditional-variable in the described metadata expression formula, filter the concrete data of state with described document and replace, can generate peek SQL;
Substep 2053: document to be filtered is filtered according to described peek SQL;
The peek SQL that generates in the substep 2052 is filtered document to be filtered, just can filter out the document that meets filtercondition according to user's selection demand;
Step 206: the form with the interface shows the document filter result.
Preferably, present embodiment can also comprise the document filter result is showed the user with the form at interface, show that wherein content can comprise the document numbering, information such as the state of document, by filter result is shown to the user, whether the document that can also the described document status of test basis filters out meets the requirements.
For aforesaid each method embodiment, for simple description, so it all is expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not subjected to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
For making those skilled in the art understand the present invention better, the present invention is further described below in conjunction with object lesson that the present invention uses in practice.
Steps A 1: on the document design interface, increase a field: the person approving, audit state packet filter as document, and the data message of described document status field added in the document metadata table that presets, described document metadata table is used to write down the identification parameter of document mode field;
With reference to shown in Figure 3, show the synoptic diagram of a document design interface in the object lesson of the present invention, if the person approving's field on the document design interface has value, represent that then this list examines, otherwise this singly is in the state of audit;
Need to prove, described document metadata table not only can be used to write down the identification parameter of document mode field, can also be used to write down the transaction types of document, perhaps other attributive character of document status field, for example, the title of document status field is described, in the present example, and shown in second row of described document metadata table in can following Table I CClassTableInfo:
FClassTypeID | FCaption_CHS | FFieldName | FTableName | | FSRCTableName | FConditionExt | |
200000000 | The person approving | FChecker | t_BOS200000000 | FUserID | t_User | 1000000 | |
200000000 | Check and write off | FWriteOf | t_BOS200000000 | 1000001 | |||
200000000 | Keep accounts | FAccount | t_BOS200000000 | 1000002 | |||
200000000 | Close | FClose | t_BOS200000000 | 1000003 | |||
1007109 | Sell | FSalesMethod | t_BOS200000000 | 1000006 |
Wherein, field and the data declaration among the last Table I CClassTableInfo is as follows:
FClassTypeID: described FClassTypeID represents the transaction types of document, and this field value is a bill type, and for example, the transaction types of import order is: 1007100; The transaction types of sales order is 1007109, or the like; The second row field value is that 200000000 meaning is in the last table: person approving's field is that to belong to transaction types be 200000000 document;
FCaption_CHS: described field FCaption_CHS is that the title of document filtered fields under simplified environment described, for example, and " person approving ", " checking and writing off " etc.;
FFieldName: which field is the concrete data that described field FFieldName is used to identify the document filtered fields be kept at;
FTableName: which table is the concrete data that described field FTableName is used to identify the document filtered fields be kept at; For example, last table the second capable in content implication in FFieldName and the FTableName field be: the data of person approving's field are kept among the field FChecker of table t_BOS200000000;
FSRCFieldName: described field FSRCFieldName is used to identify the Data Source of document filtered fields; The implication of this field was during last table the second was capable: the Data Source of person approving's field is the FUserID field among the table t_User;
FConditionExt: described field FConditionExt is the identification parameter of document status field, can identify the pairing filtration state ID of this field, and described identification parameter is corresponding with the field FID that the document that presets filters in the state table;
Be understandable that, also can increase other document status in the table, as above the closed condition shown in the table, check and write off state, record keeping state or marketing method etc.;
Need to prove, when newly-increased document filters the data message of state in the described document metadata table, also filter the corresponding states of inserting person approving's field in the state table simultaneously to described document, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
In practice, described document filter state table can following Table I CClassCondition shown in:
FID | FName_CHS | FDataSource_CHS |
1000000 | The audit state | All; None ~ examine; Isnull (@Field, 0)>0 ~ not audit; Isnull (@Field, 0)<=0 |
1000001 | Check and write off state | All; None ~ do not check and write off; Isnull (, 0)=0 ~ check and write off fully; Isnull (@Field, 0)=1 ~ partly check and write off; Isnull (@Field, 0)=2 |
1000002 | Account status, for example | Do not do account; Isnull (@Field, 0)<=0 ~ does account; Isnull (@Field, 0)>0 ~ all; None |
1000003 | Closed condition | Do not close; @Field<2 ~ close; @Field=2 ~ all; None |
1000006 | Marketing method | Sell on credit; Isnull (@Field, 0)=101 ~ cash sale; Isnull (@Field, 0)=100 ~ instalment sale; Isnull (@Field, 0)=102 ~ entrust and sell on a commission basis; Isnull (@Field, 0)=103 ~ directly transportation and sales are sold; Isnull (@Field, 0)=20296 ~ be commissioned and sell on a commission basis; Isnull (@Field, 0)=20297 ~ retail; Isnull (@Field, 0)=20298 ~ all; None |
In the present example, what be applied to is the data in last Table I CClassCondition second row, as follows to wherein explanation of field:
FID: the content of described field FID is the identification parameter that described document filters state, and not described document filters the unique identification of state;
FName_CHS: the title that the described document of the content representation of described field FName_CHS filters state, in the present example, described name is called the audit state;
FDataSource_CHS: the content of described field FDataSource_CHS is the filtration Status Type of document, and in the present example, the audit of document has three kinds of states: examined all, and not audit; Isnull (, 0)>0th wherein, the metadata of described filtration Status Type is expressed formula;
Steps A 2: from the document metadata table that presets, obtain the identification parameter of described document status field;
In the present example, need be according to the transaction types 200000000 of document, the identification parameter of the person approving's field that provides in the acquisition steps A 1, described identification parameter is specifically as follows FconditionExt;
Steps A 3: when the value of described identification parameter is an effective value, filter the state table from the document that presets, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula;
In this step, whether the value of at first judging described identification parameter FconditionExt is an effective value, wherein, the described value of FconditionExt that effectively can be understood as is greater than zero, certainly, those skilled in the art can know judge with additive method whether the value of described FconditionExt is that effective value does not influence realization of the present invention, so the present invention is not to judging that whether described identification parameter is that the method for an effective value is made qualification; When the value of described identification parameter greater than zero the time, represent that then this field need be as the state packet filter field of document; According to the value of FConditionExt, filter the filtration status information of obtaining FID=FConditionExt the state table ICClassCondition then from document;
Need to prove that described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula;
Steps A 4: described filtration Status Type is added on the document filtering interface;
Data according to field FDataSource_CHS, can know, described filtration Status Type has all, has examined and not audit, filters Status Type with three kinds and adds on the document filtering interface in the mode of combobox control, selects as required to use for the user; With reference to figure 4, show the synoptic diagram of document filtering interface one in the object lesson of the present invention; With reference to figure 5, show the synoptic diagram of document filtering interface two in the object lesson of the present invention simultaneously, in Fig. 5, can add the document status that needs in the mode of a plurality of combobox controls;
Steps A 5: obtain the filtration Status Type that the user selects on described document filtering interface;
After adding to described filtration Status Type on the document filtering interface, the user can select document status on described document filtering interface, and in the present example, with reference to figure 4, user-selected document status is " examining ";
Steps A 6: as filtercondition, document to be filtered is filtered with described filtration Status Type metadata corresponding expression formula;
Preferably, the realization of this step can comprise following substep:
Substep A61: the metadata that reads described filtration Status Type is expressed formula;
After the user has selected the document status of " examining ", click [determining] button, then read described " examining " corresponding metadata expression formula isnull (, 0)>0;
Substep A62: replace the conditional-variable in the described metadata expression formula, generate peek SQL;
Replace Bian Liang @Field with the field FChecker among the table t_BOS200000000, peek SQL just is:
select*from_t BOS200000000 where isnull(FChecker,0)>0;
Substep A63: document to be filtered is filtered according to described peek SQL;
Obtain peeking behind the SQL, obtaining person approving's field according to described peek SQL from database is not the data of empty (being that person approving's field has value), thereby the document that will examine from document to be filtered filters out;
Steps A 7: the form with the interface shows the document filter result.
Filter after the document, can the document filtering result be shown to the user with the form at interface, pass through display result, can also verify further whether the process of filtering meets customer requirements, with reference to shown in Figure 6, show an interface synoptic diagram of document filter result in the object lesson of the present invention, be illustrated as three documents having examined, the document numbering is respectively: 00000010,00000011 and 00000012; As can be seen, it is the Administrator audit that document is numbered 00000010 document from the data message of document, and it is the CEO audit that document is numbered 00000011 document, and it is the SCM audit that document is numbered 00000012 document.
In sum, the present invention is by the identification parameter in the document metadata table that presets, with preset document and filter state table and carry out related, can make the user under the situation that document status changes, the filtration Status Type that described document is filtered in the state table adds on the document filtering interface, described filtration types can for " all; Examine; Audit " etc. content, the metadata expression formula that described document filters in the state table can also be used as filtercondition, document to be filtered is filtered according to document status, wherein, described metadata express formula can for be similar to " None~; Isnull (@Field, 0)>0~; Isnull (@Field, 0)<=0 " statement is described; the present invention removes to generate filtercondition by the filtration Status Type that the foundation user selects; and document to be filtered filtered, further, give the user with filter result by interface display; not only reduced the development and maintenance cost that need revise source code when document status changes; further, because document status information loads and resolves by unified method, also promoted the performance that document filters.
With reference to figure 7, show and of the present inventionly a kind ofly filter the process flow diagram of the device embodiment of document according to document status, can comprise with lower module:
Add module 703, be used for adding described filtration Status Type to the document filtering interface;
The 3rd acquisition module 704 is used to obtain the filtration Status Type that the user selects on described document filtering interface;
In the present embodiment, first acquisition module is by from the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, second acquisition module can filter state table and obtain the filtration Status Type that document filters state by the document that presets, and the metadata of described filtration Status Type is expressed formula, the user can make amendment to the data in described document metadata table and the document filtration state table, and the document that obtains wherein filters status information, thereby realizes the purpose of document being filtered according to described document status.
As can be seen, the user can be by revising the data message in two tables, document status is made amendment, increase newly and deletion action; And the filtration Status Type in the table that will get access to, mode with drop-down list is presented on the document filtering interface, select for the user, and the document status that the user is selected is as filtercondition, so that document is filtered, and the document information that filters out showed the user with the form at interface, can need not to revise source code just can be under the situation that document status changes, document is filtered, reduced development and maintenance cost, further, because document status information loads and resolves by unified method, can also promote the performance that document filters.
With reference to figure 8, show and of the present inventionly a kind ofly filter the structured flowchart of the device preferred embodiment of document according to document status, described device specifically can comprise with lower module:
Add module 803, be used for adding described filtration Status Type to the document filtering interface;
The 3rd acquisition module 804 is used to obtain the filtration Status Type that the user selects on described document filtering interface;
Preferably, described first filtering module specifically can comprise:
Reading submodule 8051, the metadata that is used to read described filtration Status Type is expressed formula;
Replace submodule 8052, be used for replacing the conditional-variable of described metadata expression formula, generate peek SQL;
Second filters submodule 8053, is used for according to described peek SQL document to be filtered being filtered;
Preferably, present embodiment can also comprise:
With reference to figure 9, show and use the process flow diagram that preferred embodiment shown in Figure 8 carries out the document filtration, can may further comprise the steps:
Step 901: first acquisition module is from described document metadata table, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
Step 902: when the value of described identification parameter is an effective value, second acquisition module filters the state table from described document, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Step 903: add module described filtration Status Type is added on the document filtering interface;
Step 904: the 3rd acquisition module obtains the filtration Status Type that the user selects on described document filtering interface;
Step 905: reading submodule reads the metadata of described filtration Status Type and expresses formula;
Step 906: the replacement submodule is replaced the conditional-variable in the described metadata expression formula, generates peek SQL;
Step 907: second filters submodule filters document to be filtered according to described peek SQL;
Step 908: display module shows the document filter result with the form at interface.
Need to prove that each embodiment in this instructions all adopts the mode of going forward one by one to describe, what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For device class embodiment, because it is similar substantially to method embodiment, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
Need to prove, in this article, relational terms such as first and second grades only is used for an entity or operation are made a distinction with another entity or operation, and not necessarily requires or hint and have the relation of any this reality or in proper order between these entities or the operation.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby make and comprise that process, method, article or the equipment of a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or also be included as this process, method, article or equipment intrinsic key element.Do not having under the situation of more restrictions, the key element that limits by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
More than a kind ofly filter the method for document and be described in detail provided by the present invention according to the device that document status is filtered document according to document status, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1, a kind of method of filtering document according to document status is characterized in that, comprising:
From the document metadata table that presets, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
When the value of described identification parameter is an effective value, filter the state table from the document that presets, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type is expressed formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Described filtration Status Type is added on the document filtering interface;
Obtain the filtration Status Type that the user selects on described document filtering interface, and with described filtration Status Type metadata corresponding expression formula as filtercondition, document to be filtered is filtered.
2, the method for claim 1 is characterized in that, described with described filtration Status Type metadata corresponding expression formula as filtercondition, the step that document to be filtered is filtered comprises:
Read the metadata of described filtration Status Type and express formula;
Replace the conditional-variable in the described metadata expression formula, generate peek SQL;
According to described peek SQL document to be filtered is filtered.
3, the method for claim 1 is characterized in that, described document to be filtered is filtered after, also comprise:
Form with the interface shows the document filter result.
4, the method for claim 1 is characterized in that, described document status is the audit state, and described document status field is person approving's field.
5, method as claimed in claim 4 is characterized in that, described audit state comprises all, examined or not audit.
6, as the described method of the arbitrary claim of claim 1-5, it is characterized in that described method is applied in the ERP system.
7, a kind of device according to document status filtration document is characterized in that, comprising:
First acquisition module, be used for from described document metadata table, obtain the identification parameter of document status field, described identification parameter is used to identify the filtration state of described document status field correspondence, and described document metadata table is used to write down the identification parameter of document mode field;
Second acquisition module, be used for when the value of described identification parameter is an effective value, filter the state table from described document, obtain the filtration status information of described document status field, described filtration status information comprises the filtration Status Type, and the metadata of described filtration Status Type expression formula, described document filters state table and is used to write down the filtration status information corresponding with described identification parameter, and described document metadata table is related by described identification parameter with document filtration state table;
Add module, be used for adding described filtration Status Type to the document filtering interface;
The 3rd acquisition module is used to obtain the filtration Status Type that the user selects on described document filtering interface;
First filtering module is used for described filtration Status Type metadata corresponding expression formula as filtercondition document to be filtered being filtered.
8, device as claimed in claim 7 is characterized in that, described document filtering module comprises:
Reading submodule, the metadata that is used to read described filtration Status Type is expressed formula;
Replace submodule, be used for replacing the conditional-variable of described metadata expression formula, generate peek SQL;
Second filters submodule, is used for according to described peek SQL document to be filtered being filtered.
9, device as claimed in claim 7 is characterized in that, also comprises:
Display module is used for showing the document filter result with the form at interface.
10, device as claimed in claim 7 is characterized in that, described document status is the audit state, and described document status field is person approving's field.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008101265945A CN101320388A (en) | 2008-07-18 | 2008-07-18 | Method and apparatus for filtering documents according to documents state |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008101265945A CN101320388A (en) | 2008-07-18 | 2008-07-18 | Method and apparatus for filtering documents according to documents state |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101320388A true CN101320388A (en) | 2008-12-10 |
Family
ID=40180437
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA2008101265945A Pending CN101320388A (en) | 2008-07-18 | 2008-07-18 | Method and apparatus for filtering documents according to documents state |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101320388A (en) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103324891A (en) * | 2013-05-10 | 2013-09-25 | 四川省林业调查规划院 | Stand growth and yield model dynamic management method based on encryption technique |
CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
CN103903137A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Automatic payment and account-checking method and system |
CN104239578A (en) * | 2014-10-10 | 2014-12-24 | 北京国双科技有限公司 | Data table processing method and device |
CN105303369A (en) * | 2015-11-03 | 2016-02-03 | 用友网络科技股份有限公司 | Multi-business-source-bill merging bill-pulling device and method |
CN105787633A (en) * | 2014-12-26 | 2016-07-20 | 远光软件股份有限公司 | System and method for processing concurrent examining and approving flow |
WO2017071525A1 (en) * | 2015-10-30 | 2017-05-04 | 北京国双科技有限公司 | Data storage method and apparatus and data query method and apparatus |
CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件(中国)有限公司 | Account table querying method and device |
CN110515970A (en) * | 2019-08-07 | 2019-11-29 | 金蝶软件(中国)有限公司 | Method for processing business, device, computer equipment and storage medium |
-
2008
- 2008-07-18 CN CNA2008101265945A patent/CN101320388A/en active Pending
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103903137A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Automatic payment and account-checking method and system |
CN103903137B (en) * | 2012-12-26 | 2017-12-22 | 远光软件股份有限公司 | It is a kind of automatically to pay account checking method and system |
CN103324891A (en) * | 2013-05-10 | 2013-09-25 | 四川省林业调查规划院 | Stand growth and yield model dynamic management method based on encryption technique |
CN103761219B (en) * | 2014-02-20 | 2017-08-25 | 西双版纳恒创信息科技有限公司 | A kind of dynamic creation method of form |
CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
CN104239578A (en) * | 2014-10-10 | 2014-12-24 | 北京国双科技有限公司 | Data table processing method and device |
CN104239578B (en) * | 2014-10-10 | 2017-11-14 | 北京国双科技有限公司 | The treating method and apparatus of tables of data |
CN105787633A (en) * | 2014-12-26 | 2016-07-20 | 远光软件股份有限公司 | System and method for processing concurrent examining and approving flow |
WO2017071525A1 (en) * | 2015-10-30 | 2017-05-04 | 北京国双科技有限公司 | Data storage method and apparatus and data query method and apparatus |
CN106649368A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Data storage method and device and data query method and device |
CN105303369A (en) * | 2015-11-03 | 2016-02-03 | 用友网络科技股份有限公司 | Multi-business-source-bill merging bill-pulling device and method |
CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件(中国)有限公司 | Account table querying method and device |
CN106951430B (en) * | 2016-12-28 | 2019-12-06 | 金蝶软件(中国)有限公司 | Account table query method and device |
CN110515970A (en) * | 2019-08-07 | 2019-11-29 | 金蝶软件(中国)有限公司 | Method for processing business, device, computer equipment and storage medium |
CN110515970B (en) * | 2019-08-07 | 2022-09-09 | 金蝶软件(中国)有限公司 | Service processing method, device, computer equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Bock et al. | Low-code platform | |
CN101320388A (en) | Method and apparatus for filtering documents according to documents state | |
CN101794226B (en) | Service software construction method and system adapting to multiple business abstraction levels | |
US11823072B2 (en) | Customer behavior predictive modeling | |
US8886654B2 (en) | Infrastructure and architecture for development and execution of predictive models | |
US8555248B2 (en) | Business object change management using release status codes | |
CN101546311B (en) | Data processing method and data processing device for recycle bin | |
CN103827908A (en) | Systems and methods for a large-scale credit data processing architecture | |
US20110112973A1 (en) | Automation for Governance, Risk, and Compliance Management | |
CN107357593A (en) | Source code file construction method, device, electric terminal and readable storage medium storing program for executing | |
CN102436473A (en) | Menu management device and menu management method | |
Ernst et al. | Technical Debt in Practice: How to Find It and Fix It | |
CN101770469A (en) | Page based data query method and system thereof | |
CN110782217A (en) | Workflow engine management system | |
CN105677427A (en) | Module upgrading method and device | |
US20140278820A1 (en) | Managing the Topology of Software Licenses in Heterogeneous and Virtualized Environments | |
WO2009072818A2 (en) | Total product development and management system and product modeling method for the same | |
CN113656408A (en) | Full-life-cycle management method and system for aviation material based on RFID combined block chain technology | |
CN112348298A (en) | Designer management method, designer management device, electronic terminal and storage medium | |
CN106547832A (en) | A kind of information Compilation Method and device | |
Pomerantz et al. | Re-modeling ILS acquisitions data to financially transition from print to digital formats | |
JP2024053726A (en) | Environmental load information management device and environmental load information management method | |
Müller | Supporting change in business process models using pattern-based constraints | |
Zoder | Analytical master data management 2.0 | |
CN114281305A (en) | Service function point identification method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Open date: 20081210 |