CN102135959A - Statement balance checking method and server - Google Patents
Statement balance checking method and server Download PDFInfo
- Publication number
- CN102135959A CN102135959A CN2010100016707A CN201010001670A CN102135959A CN 102135959 A CN102135959 A CN 102135959A CN 2010100016707 A CN2010100016707 A CN 2010100016707A CN 201010001670 A CN201010001670 A CN 201010001670A CN 102135959 A CN102135959 A CN 102135959A
- Authority
- CN
- China
- Prior art keywords
- data
- balance
- empty body
- remaining sum
- entity
- 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
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a statement balance checking method and a server. In the method, balance data called by a virtual balance statement is searched from an entity database table; when the entity does not settle the balance data, the balance data to be called by the virtual balance statement is calculated and returned to the virtual balance statement according to a service calculation rule, so that the problem that the virtual balance statement cannot be calculated due to the fact that the entity does not settle the balance data to be called by the virtual balance statement is avoided, and the virtual balance statement can search later balance data of the entity in real time; when different virtual statements call later balance data of the entity, the service calculation rule for calculating the balance data is not required to be changed, logics for calling data is easy, interfaces are uniform, and multiple entity later balance searching by different virtual statements can be fulfilled.
Description
Technical field
The present invention relates to field of computer technology, particularly a kind of inquiry into balance method and server of form.
Background technology
Corporation de facto is called for short entity, is the tissue that is separated as decision unit and with its hetero-organization or individual or the part of tissue.Empty soma is called for short empty body, the relative a kind of Virtual Organization of solid tissue that is and handles detailed business.An empty body can be hung a plurality of solid tissues down, is a kind of Statistical Criteria of the detailed business datum statistical report form of corporation de facto.
At present, during void decorum meter form, the balance data of certain accounting period in the entity form will be showed and call to empty body form often, generate empty body remaining sum report data according to these balance data, when empty body report query solid data, client sends to server with empty body form, server is in the entity data bak table, obtain and generate the balance data that empty body remaining sum report data will call, the balance data of obtaining is returned to empty body remaining sum form use, thereby generate empty body remaining sum report data.
In research and practice process to prior art, the present inventor finds, the business of a plurality of entities that empty body is hung down is often asynchronous, its closing date is not also often in same accounting period, during void decorum meter remaining sum form, when empty body is wanted the balance data of query entity certain accounting period, in this accounting period, there is the balance data (data of having settled accounts also are remaining sum in earlier stage) of settling accounts out in the corporation de facto of having settled accounts, Jie Zhang corporation de facto does not settle accounts out balance data (Jie Zhang balance data is not the later stage remaining sum yet), in this case, empty body form can't call the not later stage remaining sum of the entity of checkout, and empty body can't correctly be added up and obtain report data.
Summary of the invention
It is a kind of by computational entity later stage balance data that the embodiment of the invention provides, and supports the inquiry into balance method of form of empty body report query later stage remaining sum and a kind of inquiry into balance server of corresponding form.
In view of this, the embodiment of the invention provides:
A kind of inquiry into balance method of form comprises: the empty body remaining sum form that obtains client;
In the entity data bak table, search and generate the balance data that empty body remaining sum report data will call;
Judge whether entity settles accounts out the balance data that the empty body remaining sum of described generation report data will call;
If then obtain the balance data that the empty body remaining sum of the described generation report data settled accounts out will call;
If not, then obtain the professional computation rule of the balance data that the empty body remaining sum of described generation report data will call,, calculate the balance data that the empty body remaining sum of described generation report data will call according to the data in the entity data bak table;
Return the balance data that the empty body remaining sum of described generation report data will call.
A kind of inquiry into balance server of form comprises: empty body form acquisition module is used to obtain empty body remaining sum form;
The data search module is used for searching the balance data that the empty body remaining sum report data of generation will call at the entity data bak table;
Judge module is used to judge whether entity settles accounts out the balance data that the empty body remaining sum of described generation report data will call;
Data acquisition module is used for being judged as when being at judge module, obtains the balance data of having settled accounts out;
The data configuration module is used for obtaining the professional computation rule of balance data when judge module is judged as not, according to the data of entity data bak table, calculates the balance data that the empty body remaining sum of described generation report data will call;
Data are returned module, are used to return the balance data that the empty body remaining sum of described generation report data will call.
The embodiment of the invention is by obtaining empty body remaining sum form, in the entity data bak table, search the balance data that empty body remaining sum form will call, when entity is not settled accounts the balance data that empty body form will call, professional computation rule according to balance data, calculate the balance data that empty body remaining sum form will call and return the balance data that empty body form will call, avoided entity not settle accounts the balance data that empty body form will call and the situation that can't add up empty body form, realized to inquire about in real time and calling the later stage balance data of entity, different empty body forms call the entity later stage during balance data, need not to change the professional computation rule that calculates balance data, call the simple and interface unification of logic of data, satisfied repeatedly query entity later stage balance data of different empty body forms.
Description of drawings
In order to be illustrated more clearly in the technical scheme of the embodiment of the invention, to do to introduce simply to calling the accompanying drawing that will use among the embodiment below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the inquiry into balance method flow diagram of the form that provides of the embodiment of the invention one;
Fig. 2 is the inquiry into balance method flow diagram of the form that provides of the embodiment of the invention two;
Fig. 3 is the structural representation of the inquiry into balance server of the form that provides of the embodiment of the invention three;
Fig. 4 is the schematic flow sheet of inquiry into balance method of the form of application scenarios of the present invention;
Fig. 5 is the synoptic diagram of entity data bak table in the application scenarios of the present invention;
Fig. 6 is the synoptic diagram of View Algorithm layer balance data in the application scenarios of the present invention.
Embodiment
The embodiment of the invention provides a kind of inquiry into balance method of form, by obtaining empty body remaining sum form, in the entity data bak table, search the balance data that empty body remaining sum form will call, when entity is not settled accounts the balance data that empty body form will call, professional computation rule according to balance data, calculate the balance data that empty body remaining sum form will call and return the balance data that empty body form will call, the embodiment of the invention also provides the inquiry into balance server of corresponding form.Below be elaborated respectively.
The inquiry into balance method basic procedure of the form of first embodiment of the invention can be with reference to figure 1,
During empty decorum meter remaining sum form, server generates empty body remaining sum report data will call balance data in the entity data bak table, generates empty body remaining sum report data according to the balance data of entity data bak.When receiving empty body remaining sum form, know from empty body remaining sum form which entity balance data empty body remaining sum form will inquire about.The balance data that the empty body remaining sum of corresponding location lookup form will call in the entity data bak table.
If the accounting period of the balance data of empty body inquiry, entity was settled accounts out the balance data that empty body form will call so, can inquire corresponding balance data in database, enters step 103 before entity checkout day.If the accounting period of the balance data of empty body inquiry, entity was not settled accounts out the balance data that empty body form will call so, can not inquire corresponding balance data in database, enters step 104 after entity checkout day.
Professional computation rule is computing formula or the data processing method that is stored in advance in the database, entity calculates corresponding balance data according to professional computation rule, different balance data has different professional computation rules, according to the balance data that empty body will be inquired about, select the corresponding service computation rule.Professional computation rule calculates the balance data that empty body remaining sum form will call according to the data of storing in the database table.
The balance data that step 103 or step 104 are obtained returns to empty body remaining sum form, uses for empty body form.
The embodiment of the invention is by obtaining empty body remaining sum form, in the entity data bak table, search the balance data that empty body remaining sum form will call, when entity is not settled accounts the balance data that empty body form will call, professional computation rule according to balance data, calculate the balance data that empty body remaining sum form will call and return the balance data that empty body form will call, avoided entity not settle accounts the balance data that empty body form will call and the situation that can't add up empty body form, realized to inquire about in real time and calling the later stage balance data of entity, different empty body forms call the entity later stage during balance data, need not to change the professional computation rule that calculates balance data, call the simple and interface unification of logic of data, satisfied repeatedly query entity later stage remaining sum of different empty body forms.
For clearer detailed explanation technical scheme of the present invention, the embodiment of the invention two provides a kind of method of bills data inquiry.
Step 202, server are searched the balance data that empty body remaining sum form will call in the entity data bak table.
By the balance data of knowing that empty body remaining sum form will be inquired about, corresponding location lookup balance data in the entity data bak table.
Be meant that the seething business activities of enterprise are divided into the interval that several equate accounting period, on the basis of successive reaction, carry out accounting and prepare statement by stages, business activities achievement during the enterprise of reaction regularly is a certain, for example to inquire about the balance data in March, 2009, so, be exactly this balance data accounting period in March, 2009.
If the accounting period of the balance data of empty body inquiry, entity was settled accounts out the balance data that empty body form will call so, can inquire corresponding balance data in database, enters step 205 before entity checkout order.If the accounting period of the balance data of empty body inquiry, entity was not settled accounts out the balance data that empty body form will call so, can not inquire corresponding balance data in database, enters step 206 after entity checkout day.
Professional computation rule is the general rule of entity striking a balance data, is generally the formula that calculates balance data.Can in entity data bak, directly obtain.Different balance data has different professional computation rules, for example, beginning balance during the inquiry current period, then in database, obtain the current period during the professional computation rule of beginning balance be: during the credit amount that writes down of the fiscal period of the debit's amount of fiscal period beginning balance+record of beginning balance=-.
According to the data of obtaining from database table, the professional computation rule of the data of being inquired about by empty body remaining sum form is handled.Just can calculate the balance data that empty body remaining sum form will call.
The balance data that step 205 or step 209 are obtained returns to empty body form, calls and shows for empty body form.Again the balance data that obtains is returned to client, for client shows.
The embodiment of the invention is by obtaining empty body remaining sum form, in the entity data bak table, search the balance data that empty body remaining sum form will call, when entity is not settled accounts the balance data that empty body form will call, professional computation rule according to balance data, calculate the balance data that empty body remaining sum form will call and return the balance data that empty body form will call, avoided entity not settle accounts the balance data that empty body form will call and the situation that can't add up empty body form, realized to inquire about in real time and calling the later stage balance data of entity, different empty body forms call the entity later stage during balance data, need not to change the professional computation rule that calculates balance data, call the simple and interface unification of logic of data, satisfied repeatedly query entity later stage remaining sum of different empty body forms.
Consult Fig. 3, the embodiment of the invention three provides a kind of server of bills data inquiry, and the server of this bills data inquiry comprises:
Empty body form acquisition module 31 is used to obtain empty body remaining sum form; Client sends to server with empty body remaining sum form, obtains empty body data that form queries the balance by the empty body form acquisition module 31 of server, calls and inquires about for empty body remaining sum form.
If the accounting period of the balance data of empty body inquiry is before entity checkout order, entity is settled accounts out the balance data that empty body form will call so, in database, can inquire corresponding balance data, if the accounting period of the balance data of empty body inquiry is after entity checkout day, entity is not settled accounts out the balance data that empty body form will call so, can not inquire corresponding balance data in database.
Data are returned module 36, are used for the balance data that the empty body form of return data constructing module 35 or data acquisition module 34 will call.
Preferably, judge module 33 also comprises:
Accounting period, acquiring unit 331, were used to obtain the accounting period of the balance data that empty body form will call;
Be meant that the seething business activities of enterprise are divided into the interval that several equate accounting period, on the basis of successive reaction, carry out accounting and prepare statement by stages, business activities achievement during the enterprise of reaction regularly is a certain, for example to inquire about the balance data in March, 2009, so, be exactly this balance data accounting period in March, 2009.
If the accounting period of the balance data of empty body inquiry, entity was settled accounts out the balance data that empty body form will call so, can inquire corresponding balance data in database before entity checkout day, clearing judging unit 332 is judged as and is; If the accounting period of the balance data of empty body inquiry, entity was not settled accounts out the balance data that empty body form will call so, can not inquire corresponding balance data in database after entity checkout order, clearing judging unit 332 is judged as not.
Preferably, data configuration module 35 also comprises:
Business rule query unit 351 is used for obtaining professional computation rule in entity data bak when clearing judging unit 332 is judged as not.Professional computation rule is the general rule of entity striking a balance data, is generally the formula that calculates balance data.Business rule query unit 351 can directly be obtained in entity data bak.Different balance data has different professional computation rules, for example, beginning balance during the inquiry current period, then in database, obtain the current period during the professional computation rule of beginning balance be: during the credit amount that writes down of the fiscal period of the debit's amount of fiscal period beginning balance+record of beginning balance=-.
Data capture unit 352 is used for obtaining the data of the entity form that professional computation rule calls.Concrete, data capture unit 352 is according to the professional computation rule of the balance data of obtaining.Obtain the data in the entity form that professional computation rule calls.If professional computation rule is: during the credit amount that writes down of the fiscal period of the debit's amount of fiscal period beginning balance+record of beginning balance=-.From database table, obtain the debit's amount of fiscal period beginning balance, record and the credit amount of fiscal period record so for a long time.
Late time data acquiring unit 354 is used to obtain the balance data that empty body remaining sum form will call.
For the ease of understanding, with concrete application scenarios the foregoing description is described in detail below:
Application scenarios: the subject balance table with the financial statement the inside is an example, with the algorithm of View Algorithm as structure later stage balance data.Referring to Fig. 4, be the method flow synoptic diagram that to use scene.
Step 401, empty body form acquisition module 31 obtains empty body remaining sum form;
Step 402, data search module 32 are searched the balance data that empty body remaining sum form will call in the entity data bak table; The balance data that empty body will call is to be accounting period that 200904 accumulative total is borrowed or lent money.
Be 200904 the accounting period that step 403, judge module 33 are obtained the balance data that empty body form will call;
Step 404 referring to Fig. 5, is the balance data form that should use entity in the scene, judge module 33 judges that described accounting period is whether after entity Settlement Date 200903, in database, can not inquire corresponding balance data, enter step 405, begin to carry out the data configuration of View Algorithm.
The query the balance professional computation rule of data of step 405, data configuration module 35, professional computation rule is: 200904 accumulative totals borrowed for=200904 current periods borrowed+200903 accumulative totals to borrow, and 200904 accumulative totals were borrowed for=200904 current periods and are borrowed+200903 accumulative totals and borrow;
It is that 200,200903 accumulative totals borrow is that to borrow 700,200904 current periods be that 100,200903 accumulative totals borrow be 500 that step 406, data configuration module 35 obtain that 200904 current periods of data early stage in the entity form that professional computation rule calls borrow;
Step 407, data configuration module 35 is handled data in described early stage according to professional computation rule, 200904 accumulative totals borrowed for=200904 current periods borrowed+200903 accumulative totals to borrow=200+700=900, and 200904 accumulative totals were borrowed for=200904 current periods and borrowed+200903 accumulative total loan=100+500=600.
It is that 200904 accumulative total is borrowed or lent money and is respectively 900 and 600 that step 408, data configuration module 35 obtain balance data that empty body remaining sum form will call.Referring to Fig. 6, be the balance data synoptic diagram that to use View Algorithm layer in the scene.
Step 409, data are returned module 36 and are returned the balance data that the empty body form that obtains will call.Return to empty body remaining sum form with 900 and 600, show and call for empty body remaining sum form.
Step 410 returns to client, the confession client shows with 900 and 600.
The embodiment of the invention is by obtaining empty body remaining sum form, in the entity data bak table, search the balance data that empty body remaining sum form will call, when entity is not settled accounts the balance data that empty body form will call, professional computation rule according to balance data, calculate the balance data that empty body remaining sum form will call and return the balance data that empty body form will call, avoided entity not settle accounts the balance data that empty body form will call and the situation that can't add up empty body form, realized to inquire about in real time and calling the later stage balance data of entity, different empty body forms call the entity later stage during balance data, need not to change the professional computation rule that calculates balance data, call the simple and interface unification of logic of data, satisfied repeatedly query entity later stage remaining sum of different empty body forms.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to finish by program, described program can be stored in a kind of computer-readable recording medium, ROM (read-only memory) for example, disk or CD etc.
More than the inquiry into balance method and the server of the form that the embodiment of the invention provided is described in detail, 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 (8)
1. the inquiry into balance method of a form is characterized in that, comprising:
Obtain the empty body remaining sum form of client;
In the entity data bak table, search and generate the balance data that empty body remaining sum report data will call;
Judge whether entity settles accounts out the balance data that the empty body remaining sum of described generation report data will call;
If then obtain the balance data that the empty body remaining sum of the described generation report data settled accounts out will call;
If not, then obtain the professional computation rule of the balance data that the empty body remaining sum of described generation report data will call,, calculate the balance data that the empty body remaining sum of described generation report data will call according to the data in the entity data bak table;
Return the balance data that the empty body remaining sum of described generation report data will call.
2. the inquiry into balance method of form as claimed in claim 1 is characterized in that, described judge entity whether settle accounts out tell and generate the balance data that empty body remaining sum report data will call and comprise:
Obtain the accounting period of the balance data that the empty body report data of described generation will call;
Judge that described accounting period is whether at entity before Settlement Date.
3. the inquiry into balance method of form as claimed in claim 1 is characterized in that, and is described according to the data in the entity data bak table, calculates the balance data that the empty body remaining sum of described generation report data called and comprises:
Obtain the data in the entity data bak table that professional computation rule calls;
Handle data in the described entity data bak table according to professional computation rule;
Obtain the balance data that the empty body remaining sum of described generation report data will call.
4. the inquiry into balance method of form as claimed in claim 1 is characterized in that, returns after balance data that empty body remaining sum form called gives empty body remaining sum form described, also comprises:
According to the balance data that the data of the empty body remaining sum of described generation form will be called, generate empty body remaining sum form;
Return the balance data that the empty body remaining sum of described generation report data will call and give client.
5. the inquiry into balance method of form as claimed in claim 3 is characterized in that, described professional computation rule is striking a balance data computing formula or the processing rule that entity presets.
6. the inquiry into balance server of a form is characterized in that, comprising:
Empty body form acquisition module is used to obtain empty body remaining sum form;
The data search module is used for searching the balance data that the empty body remaining sum report data of generation will call at the entity data bak table;
Judge module is used to judge whether entity settles accounts out the balance data that the empty body remaining sum of described generation report data will call;
Data acquisition module is used for being judged as when being at judge module, obtains the balance data of having settled accounts out;
The data configuration module is used for obtaining the professional computation rule of balance data when judge module is judged as not, according to the data of entity data bak table, calculates the balance data that the empty body remaining sum of described generation report data will call;
Data are returned module, are used to return the balance data that the empty body remaining sum of described generation report data will call.
7. the inquiry into balance method of form as claimed in claim 6 is characterized in that, described judge module comprises:
Accounting period, acquiring unit was used to obtain accounting period of the balance data that the empty body remaining sum of described generation report data will call;
The clearing judging unit is used to judge that described accounting period is whether at entity before Settlement Date.
8. the inquiry into balance method of form as claimed in claim 6 is characterized in that, described data configuration module comprises:
The business rule query unit is used to obtain the professional computation rule of balance data;
Data capture unit is used to obtain the data of the entity data bak table that professional computation rule calls;
Data processing unit is used for handling according to professional computation rule the data of described entity data bak table;
The late time data acquiring unit is used to obtain the balance data that the empty body remaining sum of described generation report data will call.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010100016707A CN102135959A (en) | 2010-01-21 | 2010-01-21 | Statement balance checking method and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010100016707A CN102135959A (en) | 2010-01-21 | 2010-01-21 | Statement balance checking method and server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102135959A true CN102135959A (en) | 2011-07-27 |
Family
ID=44295747
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010100016707A Pending CN102135959A (en) | 2010-01-21 | 2010-01-21 | Statement balance checking method and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102135959A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113628053A (en) * | 2021-09-03 | 2021-11-09 | 中电金信软件有限公司 | Transaction balance calculation method and device |
-
2010
- 2010-01-21 CN CN2010100016707A patent/CN102135959A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113628053A (en) * | 2021-09-03 | 2021-11-09 | 中电金信软件有限公司 | Transaction balance calculation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108446975B (en) | Quota management method and device | |
| WO2018228408A1 (en) | Method and apparatus for settling transaction, server, and storage medium | |
| CN103999049B (en) | Method and apparatus for predicting virtual machine demand | |
| RU2019117950A (en) | METHOD AND EQUIPMENT FOR CANCELLATION OF ASSETS TRANSFER AND ELECTRONIC DEVICE | |
| CN109840837B (en) | Financial data processing method and device, computer readable medium and electronic equipment | |
| CN104951446A (en) | Big data processing method and platform | |
| CN109711989A (en) | Refund transaction data processing method, device, computer equipment and storage medium | |
| KR20170134601A (en) | Data processing method and apparatus | |
| CN109324905A (en) | Database operation method, device, electronic equipment and storage medium | |
| WO2012177910A1 (en) | Paying non-settlement transactions | |
| CN107025137A (en) | A kind of resource query method and device | |
| CN108615184A (en) | A kind of method and device of book keeping operation | |
| CN111125535A (en) | Financial product recommendation method and device | |
| CN109002359A (en) | A kind of dispatching method and relevant apparatus of calculate node server | |
| CN109034493A (en) | A kind of account balance prediction technique and device | |
| CN109670957A (en) | The processing method and processing device of fictitious assets data | |
| CN108459965A (en) | A kind of traceable generation method of software of combination user feedback and code dependence | |
| CN112035681B (en) | Method and device for determining credit card rate information based on knowledge graph | |
| CN111311215A (en) | E-commerce platform settlement method and device, storage medium and settlement equipment | |
| CN110427389A (en) | A kind of data processing and querying method for block chain digital cash | |
| CN102135959A (en) | Statement balance checking method and server | |
| CN105468726B (en) | Method for computing data and system based on local computing and distributed computing | |
| WO2015049515A1 (en) | Improvements relating to distributed resource management in real-time systems | |
| WO2018132118A1 (en) | Systems and methods for flexible streaming aggregation for electronic transaction analysis | |
| CN108665113A (en) | Index prediction technique 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 |
Application publication date: 20110727 |