CN111949682A - Compensation protocol generation method and device, computer equipment and storage medium - Google Patents
Compensation protocol generation method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111949682A CN111949682A CN202010628250.5A CN202010628250A CN111949682A CN 111949682 A CN111949682 A CN 111949682A CN 202010628250 A CN202010628250 A CN 202010628250A CN 111949682 A CN111949682 A CN 111949682A
- Authority
- CN
- China
- Prior art keywords
- compensation
- mapping information
- target
- information
- data
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000013507 mapping Methods 0.000 claims abstract description 158
- 230000003044 adaptive effect Effects 0.000 claims abstract description 6
- 238000004590 computer program Methods 0.000 claims description 13
- 238000004364 calculation method Methods 0.000 abstract description 12
- 238000010586 diagram Methods 0.000 description 7
- 238000012795 verification Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 5
- 239000000284 extract Substances 0.000 description 5
- 238000005259 measurement Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Economics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Remote Sensing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a compensation protocol generation method, a compensation protocol generation device, computer equipment and a storage medium. The method comprises the following steps: determining compensation terms for the target area; acquiring detailed codes of the mapping information corresponding to the compensation clause, and acquiring area information of the target area; acquiring target mapping information adaptive to the detail codes and the regional information from a mapping information database constructed in advance based on the detail codes and the regional information; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively; and obtaining compensation data aiming at the target area according to the target mapping information and the compensation clause, and generating a corresponding compensation protocol based on the compensation data. By adopting the method, when the compensation protocol needs to be generated, manual calculation and system redesign are not needed, so that the efficiency of generating the compensation protocol can be improved.
Description
Technical Field
The present application relates to the field of city update informatization technology, and in particular, to a compensation protocol generation method, apparatus, computer device, and storage medium.
Background
In the city updating project, after the collection of the removal project is completed, the removal compensation is required to be carried out on the removed person, and the compensation terms can be about the removal area, or various types of attachments, such as air conditioners, related greening and the like. Generally, the relocation compensation terms sometimes amount to tens or even hundreds of terms, and therefore need to be finally summarized to generate the relocation compensation agreement according to the specified format template.
At present, the generation of the relocation compensation protocol is mainly divided into two modes, an Excel mode and a protocol tool mode. The Excel mode is that mapping data is recorded through an Excel table, and then a compensation result is calculated through service personnel so as to generate a compensation protocol; the protocol tool mode is to utilize the protocol tool, utilize the compensation item development design system of the concrete project, input the surveying and mapping data, and export the money according to the system calculation logic, thereby generating the compensation protocol.
However, the current method of generating the compensation protocol by the Excel method has a large amount of manual calculation and is easy to make a calculation error, and for the method of generating the compensation protocol by the protocol tool method, the system needs to be redesigned only for a single compensation situation, if the protocol is adjusted. Therefore, both the Excel method and the protocol tool method cannot adapt to the variable situation of the urban update compensation protocol, and the efficiency of generating the compensation protocol is low.
Disclosure of Invention
In view of the above, it is necessary to provide a compensation protocol generation method, apparatus, computer device and storage medium for solving the above technical problems.
A compensation protocol generation method, the method comprising:
determining compensation terms for the target area;
obtaining detailed codes of mapping information corresponding to the compensation clause, and obtaining area information of the target area;
acquiring target mapping information adaptive to the detail codes and the region information from a mapping information database constructed in advance based on the detail codes and the region information; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively;
according to the target mapping information and the compensation clauses, obtaining compensation data aiming at the target area, and generating a corresponding compensation protocol based on the compensation data.
In one embodiment, the area information includes first address information; the acquiring, from a mapping information database constructed in advance, target mapping information adapted to the detail code and the area information based on the detail code and the area information includes: acquiring first address information of the target area, and extracting at least one first address keyword from the first address information; selecting a second address keyword matched with the first address keyword from the mapping information database; determining the target mapping information based on the detail code and second address information corresponding to the second address keyword.
In one embodiment, the region information includes first parcel number data; the acquiring, from a mapping information database constructed in advance, target mapping information adapted to the detail code and the area information based on the detail code and the area information includes: acquiring first parcel number data of the target area; selecting parcel number data which is the same as the first parcel number data from the mapping information database as second parcel number data; determining the target mapping information based on the detail code and the second parcel number data.
In one embodiment, the obtaining detailed code of mapping information in accordance with the compensation clause includes: acquiring a target compensation strategy matched with the compensation clause; determining the detail code based on the target compensation policy.
In one embodiment, the obtaining of the target compensation policy matching the compensation terms includes: acquiring a compensation strategy table; the compensation strategy table stores compensation strategies corresponding to various compensation terms; and if the compensation strategy table stores the compensation strategy matched with the compensation terms, extracting the compensation strategy matched with the compensation terms from the compensation strategy table and using the compensation strategy as the target compensation strategy.
In one embodiment, after the obtaining of the compensation policy table, the method further includes: and if the compensation strategy table does not store the compensation strategy matched with the compensation terms, triggering a preset dynamic formula compiler to generate the compensation strategy matched with the compensation terms as the target compensation strategy.
In one embodiment, the generating a corresponding compensation protocol based on the compensation data includes: acquiring a data correctness checking result aiming at the compensation data; and if the data correctness checking result is that the data passes the checking, generating the compensation protocol based on the compensation data.
A compensation protocol generation apparatus, the apparatus comprising:
a compensation clause determination module for determining compensation clauses for the target area;
the detail code acquisition module is used for acquiring the detail codes of the mapping information suitable for the compensation clause and acquiring the area information of the target area;
a mapping information acquisition module, configured to acquire, based on the detail code and the region information, target mapping information that is adapted to the detail code and the region information from a mapping information database that is constructed in advance; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively;
and the compensation protocol generation module is used for obtaining compensation data aiming at the target area according to the target mapping information and the compensation clause and generating a corresponding compensation protocol based on the compensation data.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the above method when executing the computer program.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.
The compensation agreement generating method, the compensation agreement generating device, the computer equipment and the storage medium determine compensation clauses aiming at the target area; acquiring detailed codes of the mapping information corresponding to the compensation clause, and acquiring area information of the target area; acquiring target mapping information adaptive to the detail codes and the regional information from a mapping information database constructed in advance based on the detail codes and the regional information; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively; and obtaining compensation data aiming at the target area according to the target mapping information and the compensation clause, and generating a corresponding compensation protocol based on the compensation data. According to the method and the device, the surveying and mapping information database of the corresponding relation between the detail codes and the regional information and the surveying and mapping information is constructed in advance, when the compensation agreement needs to be generated, the surveying and mapping data can be obtained only by obtaining the corresponding detail codes and the regional information of the target region through the compensation clause, manual calculation and system redesign are not needed, and therefore the efficiency of generating the compensation agreement can be improved.
Drawings
FIG. 1 is a flow diagram illustrating a compensation protocol generation method according to one embodiment;
FIG. 2 is a schematic flow chart illustrating a process for obtaining target mapping information corresponding to detail codes and area information from a pre-constructed mapping information database based on the detail codes and the area information according to an embodiment;
FIG. 3 is a schematic flow chart of another embodiment of obtaining target mapping information from a pre-constructed mapping information database based on detail codes and area information, wherein the target mapping information is adapted to the detail codes and the area information;
FIG. 4 is a flow diagram illustrating the flow of detailed code for obtaining mapping information in accordance with compensation terms in one embodiment;
FIG. 5 is a flowchart illustrating a compensation protocol generation method according to another embodiment;
FIG. 6 is a diagram illustrating the structural relationship of mapping and compensation data in an exemplary application;
FIG. 7 is a block diagram showing the structure of a compensation protocol generating apparatus according to an embodiment;
FIG. 8 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
In an embodiment, as shown in fig. 1, a compensation protocol generating method is provided, and this embodiment is illustrated by applying the method to a terminal, and it is to be understood that the method may also be applied to a server, and may also be applied to a system including the terminal and the server, and is implemented by interaction between the terminal and the server. In this embodiment, the method includes the steps of:
in step S101, the terminal determines a compensation term for the target area.
The target region refers to a region in which compensation terms need to be generated, and different regions may correspond to different compensation terms, for example, for region a, the applicable compensation terms are the total area a requiring the compensation amount a, while for region B, the applicable compensation terms are the total area C requiring the compensation amount C at layer 1, the total area B above layer 1 requiring the compensation amount B, and so on. Therefore, the terminal first needs to determine the corresponding compensation terms for a certain specific area to generate the corresponding compensation agreement.
Step S102, the terminal acquires detailed codes of the mapping information corresponding to the compensation clause and acquires area information of the target area.
The detail code refers to detail code of mapping information, and is adapted to the compensation agreement, and may be an attribute item of the mapping information, for example, for the area a, the applicable compensation terms are the total area a requiring the compensation amount a, so for the compensation terms of the area a, the corresponding detail code of the mapping information is the total area, and for the 1-floor total C area corresponding to the area B, the compensation amount C is required, and for the area B above 1 floor, the compensation terms of the total compensation amount B are the corresponding detail codes of the area of 1 floor and the total area of the floors above 1 floor. The area information is information for describing characteristics of the target area, and may be, for example, an address of the area, or may be in the form of a number for identifying the target area.
Step S103, the terminal acquires target mapping information adaptive to the detailed codes and the regional information from a mapping information database constructed in advance based on the detailed codes and the regional information; wherein the mapping information database stores mapping information corresponding to different detail codes and region information, respectively.
The mapping database stores correspondence between detail codes and area information and mapping information, for example: the mapping information database can store regional information as an address A, detail codes as a total area, corresponding mapping information as an area A, further stores regional information as an address A, detail codes as the number of air conditioners, corresponding mapping information as the number of air conditioners A, and also stores regional information as an address B, detail codes as 1-layer area, corresponding mapping information as an area B, regional information as an address B, detail codes as the total area of more than 1 layer, corresponding mapping information as an area C, regional information as an address B, detail codes as a total area, corresponding mapping information as an area D and other sets of mapping information. At this time, after the terminal obtains the detailed codes of the mapping information and the area information of the target area, which are suitable for the compensation clause, the terminal can obtain the corresponding target mapping information from the mapping information database.
And step S104, the terminal obtains compensation data aiming at the target area according to the target mapping information and the compensation clause, and generates a corresponding compensation protocol based on the compensation data.
After the terminal obtains the target compensation information and the compensation clauses, the terminal can respectively determine the compensation data corresponding to each compensation clause by using the obtained target mapping data based on the compensation clauses, and finally, the terminal collects all the compensation data and writes the compensation data into a file template of a compensation protocol according to a preset format, so that the compensation protocol corresponding to the target area is generated.
In the compensation agreement generating method, the terminal determines a compensation clause aiming at a target area; acquiring detailed codes of the mapping information corresponding to the compensation clause, and acquiring area information of the target area; acquiring target mapping information adaptive to the detail codes and the regional information from a mapping information database constructed in advance based on the detail codes and the regional information; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively; and obtaining compensation data aiming at the target area according to the target mapping information and the compensation clause, and generating a corresponding compensation protocol based on the compensation data. According to the method and the device, the surveying and mapping information database of the corresponding relation between the detail codes and the regional information and the surveying and mapping information is constructed in advance, when the terminal needs to generate the compensation protocol, the surveying and mapping data can be obtained only by obtaining the corresponding detail codes and the regional information of the target region through the compensation clause, manual calculation and system redesign are not needed, and therefore the efficiency of generating the compensation protocol can be improved.
In one embodiment, the area information includes first address information, as shown in fig. 2, the step S103 further includes:
step S201, the terminal obtains first address information of the target area, and extracts at least one first address keyword from the first address information.
The area information may include first address information, which is used to describe an address of the target area, and generally consists of a character string, for example, the first address information may be stored in a form of a D-way E-house number in a province, a city, a B city, and a C district, and the first address keyword is a keyword extracted from the first address information, for example, province information such as a province, a city, and a C district, city information, or street information. Specifically, after the terminal obtains the first address information of the target area, at least one first address keyword may be extracted from the first address information.
Step S202, the terminal selects a second address keyword matched with the first address keyword from the mapping information database;
in step S203, the terminal determines target mapping information based on the detail code and second address information corresponding to the second address keyword.
The second address keyword refers to a keyword which is stored in the mapping information database and matched with the first address keyword, and can be combined into second address information stored in the mapping information database, specifically, after the terminal extracts the first address keyword from the first address information, the second address keyword matched with the first address keyword can be selected from the mapping information database, corresponding second address information is obtained based on the second address keyword, and finally, the corresponding target mapping information is obtained by inquiring the mapping information database through the detailed codes and the obtained second address information.
For example: the first address information of the target area is an address a, and the corresponding first address keywords respectively include a keyword a, a keyword B, and a keyword C, and the address information stored in the mapping information database may include: the method comprises the steps that an address A, an address B and an address C are provided, keywords corresponding to the address A comprise a keyword A, a keyword B and a keyword C, keywords corresponding to the address B comprise a keyword A, a keyword B and a keyword D, and keywords corresponding to the address C comprise a keyword A, a keyword B and a keyword E, so that a terminal can select a second address keyword matched with the keyword A, the keyword B and the keyword C at the moment, and accordingly corresponding second address information is determined, namely address information of the address A stored in a mapping information database at the moment, and finally corresponding target mapping data are obtained according to the address A and corresponding detail codes, such as the total area of the address A.
In addition, since the address information may be changed due to a change of the address name, in order to further improve the accuracy of the obtained target mapping information, in an embodiment, the area information may include the first parcel number data, as shown in fig. 3, and the step S103 may further include:
in step S301, the terminal obtains the first parcel number data of the target area.
The land parcel refers to a land parcel in an ownership boundary address range of a land use authority, namely, a land parcel enclosed by an ownership boundary address line, land parcel number data is an identification number used for identifying land parcels and has uniqueness, each land parcel has corresponding land parcel number data, first land parcel number data is land parcel number data of a target area, and a terminal can determine land parcel number data of the target area as the first land parcel number data according to the target area of compensation terms.
Step S302, the terminal selects parcel number data which is the same as the first parcel number data from the mapping information database as second parcel number data;
step S303, the terminal determines the target mapping information based on the detail code and the second parcel number data.
After the terminal obtains the first parcel number data in step S301, the parcel number data stored in the mapping information database may be compared one by one, parcel number data identical to the first parcel number data is selected from the comparison data, and is used as second parcel number data, and finally, the corresponding target mapping information is obtained by querying from the mapping information database through the detailed code and the second parcel number data.
In the above embodiment, the terminal may find the second address information matched with the first address information keyword by extracting the first address keyword from the first address information and using a keyword matching method, and obtain the target mapping information by using the second address information and the detail code, and may complete the determination of the target mapping information by using a unique parcel identifier, which is parcel number data, so that a determination deviation of the target mapping information due to a transmission change of an address name may be avoided, and the accuracy of the determination of the target mapping information may be further improved.
In addition, in one embodiment, as shown in fig. 4, step S102 may further include:
step S401, the terminal acquires a target compensation strategy matched with the compensation terms.
The compensation terms are generally named in a text string, and the compensation strategy can be a mathematical representation of the compensation terms, and the target compensation strategy is a compensation strategy matched with the compensation terms of the target area. Taking the compensation terms as the amount of money to be compensated is 100 times of the total area of the area as an example, the corresponding target compensation strategy may be Y ═ X100, where Y is the amount of money to be compensated, i.e., the compensation value, and X represents the total area size of the area, and the target mapping information may be obtained from the mapping information database. After the terminal determines the compensation terms for the target area, a target compensation strategy matched with the compensation terms can be obtained.
Step S402, the terminal determines the detail code based on the target compensation strategy.
After the terminal obtains the target compensation policy in step S401, it may determine a detail code based on the target compensation policy, where for the target compensation policy Y ═ X100, since X represents the total area size of the area, the detail code obtained at this time is the total area, and if for the compensation terms, the compensation amount is 80 times the 1-floor area of the area, and 110 times the 1-floor or more floor area, the obtained target compensation policy is Y ═ a 80+ B110, where a and B represent the 1-floor area size and the 1-floor or more floor area size, respectively, and the corresponding detail code is the 1-floor and the 1-floor or more floor area.
Further, in order to improve the efficiency of the compensation protocol generation, step S401 further includes: the terminal acquires a compensation strategy table; the compensation strategy table stores compensation strategies corresponding to various compensation terms; and if the compensation strategy table stores the compensation strategy matched with the compensation terms, extracting the compensation strategy matched with the compensation terms from the compensation strategy table and using the compensation strategy as a target compensation strategy.
The compensation policy table is a corresponding relationship table for storing corresponding relationships between the compensation terms and the compensation policies, and the compensation policies corresponding to a plurality of compensation terms are stored in advance. Specifically, after obtaining the compensation terms for the target area, the terminal may determine whether there is a compensation policy matching the compensation terms from the compensation terms table, and if the compensation policy table does have a compensation policy matching the compensation terms, the terminal may directly extract the compensation policy from the compensation policy table as the target compensation policy.
And if the compensation strategy table does not have the compensation strategy matched with the compensation terms, the terminal triggers a preset dynamic formula compiler to generate the compensation strategy matched with the compensation terms as a target compensation strategy. The dynamic formula editor can be used for editing a corresponding formula to generate a corresponding compensation strategy, if the compensation strategy table does not have a compensation strategy matched with the compensation terms, a user needs to manually input the formula to generate a target compensation strategy through the dynamic formula editor, and after the target compensation strategy is generated, the terminal can establish a corresponding relationship between the compensation terms and the generated target compensation strategy and store the compensation terms and the generated target compensation strategy into the compensation strategy table. Therefore, for different compensation strategies, the system does not need to be redesigned, and the changeable situation of the urban updating compensation protocol can be adapted only by designing a new compensation strategy, so that the generation efficiency of the compensation protocol is further improved.
In this embodiment, the terminal may find a matched target compensation policy through the compensation terms, and further determine the detail code, and the target compensation policy may be obtained from the compensation policy table, so that for different target areas but if the same compensation terms are required, the target compensation policy does not need to be obtained again each time, and if the target compensation policy matched with the compensation terms is not present in the compensation policy table, the target compensation policy may be generated through a preset dynamic formula compiler, and the polytropic condition of the city update compensation protocol may be adapted without redesigning the system, thereby further improving the generation efficiency of the compensation protocol.
Meanwhile, in order to ensure the correctness of the generated compensation protocol, step S104 may further include: the terminal acquires a data correctness checking result aiming at the compensation data; and if the data correctness checking result is that the checking is passed, generating a compensation protocol based on the compensation data.
The data correctness checking result is used for determining the accuracy of the compensation data, after the terminal obtains the compensation data through the target surveying and mapping information and the compensation clauses, the specific numerical value of the compensation data can be displayed through the display device so that a user can check the data finally, if the user checks that the compensation data are accurate, the terminal can obtain the data correctness checking result of the compensation data as a check pass, and then the terminal generates a compensation protocol based on the compensation data.
In the embodiment, the terminal generates the compensation protocol only when the verification passes by acquiring the data correctness verification result aiming at the compensation data, so that the correctness of the obtained compensation data is ensured, and the accuracy of the generated compensation protocol is further improved.
In an embodiment, as shown in fig. 5, a compensation protocol generating method is provided, and this embodiment is illustrated by applying the method to a terminal, and it is to be understood that the method may also be applied to a server, and may also be applied to a system including the terminal and the server, and is implemented by interaction between the terminal and the server. In this embodiment, the method includes the steps of:
step S501, the terminal determines compensation terms aiming at a target area;
step S502, the terminal acquires a compensation strategy table; the compensation strategy table stores compensation strategies corresponding to various compensation terms;
step S503, if the compensation strategy table stores the compensation strategy matched with the compensation terms, the terminal extracts the compensation strategy matched with the compensation terms from the compensation strategy table and takes the compensation strategy as a target compensation strategy; if the compensation strategy table does not store the compensation strategy matched with the compensation terms, the terminal triggers a preset dynamic formula compiler to generate the compensation strategy matched with the compensation terms as a target compensation strategy;
step S504, the terminal determines the detail code based on the target compensation strategy and acquires the first parcel number data of the target area;
step S505, the terminal selects parcel number data which is the same as the first parcel number data from the mapping information database as second parcel number data; determining target mapping information based on the detail code and the second parcel number data;
step S506, the terminal obtains compensation data aiming at the target area according to the target mapping information and the compensation clause;
step S507, the terminal obtains a data correctness checking result aiming at the compensation data; and if the data correctness checking result is that the checking is passed, generating a compensation protocol based on the compensation data.
In the compensation protocol generation method, the terminal establishes the mapping information database of the corresponding relation between the detail codes and the regional information and the mapping information in advance, when the terminal needs to generate the compensation protocol, the mapping data can be obtained only by obtaining the corresponding detail codes and the regional information of the target region through the compensation terms, and manual calculation and system redesign are not needed, so that the efficiency of generating the compensation protocol can be improved. In addition, the target mapping information can be determined through the unique parcel identification of parcel number data, the target mapping information determination deviation caused by the sending change of the address name can be avoided, and a compensation protocol is generated only when the verification is passed through by acquiring a data correctness verification result aiming at the compensation data, so that the correctness of the obtained compensation data is ensured, and the accuracy of the target mapping information determination can be further improved. Meanwhile, the terminal can acquire the target compensation strategy through the compensation strategy table, so that the target compensation strategy does not need to be acquired again each time for different target areas but if the same compensation terms are needed, if the compensation strategy table does not have the target compensation strategy matched with the compensation terms, the target compensation strategy can be generated through a preset dynamic formula compiler, the changeable condition of the urban update compensation protocol can be adapted without redesigning a system, and the generation efficiency of the compensation protocol is further improved.
In an application example, a method for generating a city updating relocation project relocation protocol is provided, the method makes a compensation scheme into a dynamically configurable scheme through an informatization technology, and the overall design is as follows:
(1) the data is stored according to the mode of the fields without adopting the traditional number of detail items, and mapping data is stored by using the mode of the class 'key-Value', and detail data is compensated, so that the feasibility of a configuration scheme is supported from the data structure level;
(2) each village (project) can add a plurality of compensation schemes, and each scheme can add configuration compensation details, thereby providing feasibility for a plurality of schemes in one village.
(3) And when the system is executed, various money items are calculated by compiling and executing the formula in real time. In addition to computing data, data may also be verified by dynamic formulas.
The specific implementation of the scheme may include the following 3 aspects:
first, city updating and removing compensation data structure
The structural relationship between the surveying and mapping data and the compensation data is shown in fig. 6, the whole design is divided into two blocks, namely surveying and mapping data and protocol compensation data, wherein the surveying and mapping data is used as basic data, and after the surveying and mapping data is put in storage, the basic data is used as the basis of subsequent relocation compensation, and the system calculates according to a template of the relocation data to obtain a data detail result of the relocation protocol.
(1) Surveying and mapping data plate
The surveying and mapping data plate respectively has three modules of actual measurement data detail template, parcel basic information and actual measurement data detail, wherein the actual measurement data detail template is mainly used for setting which items are required to be stored in the item, and what unit is (meta, meter, plant and the like), configuration is carried out, the actual measurement data detail template is used as a template basis of the subsequent parcel storage data detail item, the number of types of input frames of a page are displayed according to the configuration, dynamic addition and deletion fields are realized, the key field is detail code MXDM which is used as a unique identifier, and parameters in a dynamic formula are used for distinguishing and reading which data to operate.
The parcel basic letter mainly records conventional information of parcel, such as address, title, survey and drawing number, etc.
And actually measuring data detail, storing quantity data on land, and recording related detail codes MXDM as core association with the data detail template by the data detail.
The recording of the mapping data can be managed by storing mapping attribute data and spatial pattern data into a database in a mutual correlation mode.
(2) Protocol compensation plate
The project scheme information can set basic information of the project scheme information, realize that one project can add a plurality of different schemes, and also configure templates of output contracts related to the schemes.
The compensation data detail template can set which compensation items are, the formula relationship between the compensation items and the mapping data (namely, a compensation detail strategy), the verification constraint and the like, and the compensation items are filled through the appointed dynamic formula rule. The page is also displayed according to items of a detail template of the compensation data, so that dynamic addition and deletion of page fields are realized, wherein a key field is a detail code MXDM which is used as a unique identifier, and parameters in a dynamic formula are used for distinguishing which data are read for operation.
The protocol basic information mainly records the conventional information of the protocol, such as protocol numbers, overall basic conditions, compensation personnel and the like.
The compensation data detail is that items to be filled are displayed according to a compensation data detail template, related data can be calculated through configuration of the data detail template, a user can adjust the data according to the situation of the user, then the dynamic template is used for verification, and the data detail also records related detail codes MXDM as core association with the data detail template.
Second, dynamic formula compiler and self-defined dynamic formula
Dynamic formula compiler we define is a formula that can input string format and then dynamically parse the methods in executing the formula, including common whether logic, ternary logic (if condition 1 is satisfied, the result is a, otherwise is B), methods of common class libraries, and methods of custom class libraries, we take microsoft. The dynamic adjustment formula is realized by dynamically editing the class library.
The self-defining dynamic formula, in the design scheme of the layout library, the MXDM which is a unique identifier is considered, relevant data can be read in a self-defining standard, calculation and layout experience are executed, and the provided self-defining scheme is shown in a table 1:
TABLE 1 customized dynamic formula scheme
Thirdly, the protocol generates a file according to the template
In the project configuration, a printed template can be set, the system writes the result according to the detailed compensation data into a file template, and finally a Word or PDF document is generated.
In the application example, through the design of the data structure, the diversity of the mapping data field of each village (project) is supported, the completed mapping data can be stored in a warehouse, the calculation basis of subsequent removal compensation can be supported, and the entry operation of redundant data is reduced. Each project can support various compensation schemes, and the relocation protocol compensation operation is greatly supported. In addition, by setting the compensation data detail template of each compensation scheme, setting the calculation rule and the constraint rule through the dynamic formula, the system dynamically executes the calculation formula, business personnel can modify data on the basis, and subsequent systems can check the correctness of the data (accumulated sum, addition and subtraction relation of certain numbers) according to the constraint rule of the data detail template after storage, so that the formulas can be subjected to addition and deletion editing, and the compensation schemes are dynamically managed. Because the system can calculate according to the scheme formula only by the business personnel needing to put mapping data in storage and inputting part of data needing to be confirmed according to the configured scheme, various data results are obtained, the workload of the personnel is greatly reduced, the output of the originally complex compensation scheme is simplified relatively, and the training cost of the group is greatly reduced. Due to the fact that the system is automatically calculated, after the villagers adjust the specific data of the compensation items, the protocol calculation results can be quickly obtained, the requirements of the villagers can be responded immediately, a plurality of compensation conditions can be obtained, and decision-making efficiency of the villagers is improved.
It should be understood that although the various steps in the flow charts of fig. 2-5 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-5 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least some of the other steps.
In one embodiment, as shown in fig. 7, there is provided a compensation protocol generating apparatus including: a compensation clause determining module 701, a detail code obtaining module 702, a mapping information obtaining module 703 and a compensation agreement generating module 704, wherein:
a compensation clause determining module 701, configured to determine a compensation clause for the target area;
a detail code obtaining module 702, configured to obtain a detail code of the mapping information according to the compensation clause, and obtain area information of the target area;
a mapping information obtaining module 703, configured to obtain, based on the detail code and the regional information, target mapping information that is adapted to the detail code and the regional information from a mapping information database that is constructed in advance; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively;
and a compensation agreement generating module 704, configured to obtain compensation data for the target area according to the target mapping information and the compensation clause, and generate a corresponding compensation agreement based on the compensation data.
In one embodiment, the area information includes first address information; a mapping information obtaining module 703, configured to further obtain first address information of the target area, and extract at least one first address keyword from the first address information; selecting a second address keyword matched with the first address keyword from the mapping information database; target mapping information is determined based on the detail code and second address information corresponding to the second address keyword.
In one embodiment, the region information includes first parcel number data; a mapping information obtaining module 703, further configured to obtain first parcel number data of the target area; selecting parcel number data which is the same as the first parcel number data from the mapping information database as second parcel number data; target mapping information is determined based on the detail code and the second parcel number data.
In one embodiment, the detail code obtaining module 702 is further configured to obtain a target compensation policy matching the compensation terms; based on the target compensation strategy, a detail code is determined.
In one embodiment, the detail code obtaining module 702 is further configured to obtain a compensation policy table; the compensation strategy table stores compensation strategies corresponding to various compensation terms; and if the compensation strategy table stores the compensation strategy matched with the compensation terms, extracting the compensation strategy matched with the compensation terms from the compensation strategy table and using the compensation strategy as a target compensation strategy.
In an embodiment, the detail code obtaining module 702 is further configured to trigger a preset dynamic formula compiler to generate a compensation policy matching the compensation terms as the target compensation policy if the compensation policy table does not store the compensation policy matching the compensation terms.
In one embodiment, the compensation clause determining module is further configured to obtain a data correctness checking result for the compensation data; and if the data correctness checking result is that the checking is passed, generating a compensation protocol based on the compensation data.
For the specific definition of the compensation protocol generation device, reference may be made to the above definition of the compensation protocol generation method, which is not described herein again. The respective modules in the compensation protocol generation apparatus may be wholly or partially implemented by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 8. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, an operator network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a compensation protocol generation method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is further provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method embodiments when executing the computer program.
In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A compensation protocol generation method, the method comprising:
determining compensation terms for the target area;
obtaining detailed codes of mapping information corresponding to the compensation clause, and obtaining area information of the target area;
acquiring target mapping information adaptive to the detail codes and the region information from a mapping information database constructed in advance based on the detail codes and the region information; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively;
according to the target mapping information and the compensation clauses, obtaining compensation data aiming at the target area, and generating a corresponding compensation protocol based on the compensation data.
2. The method of claim 1, wherein the region information comprises first address information;
the acquiring, from a mapping information database constructed in advance, target mapping information adapted to the detail code and the area information based on the detail code and the area information includes:
acquiring first address information of the target area, and extracting at least one first address keyword from the first address information;
selecting a second address keyword matched with the first address keyword from the mapping information database;
determining the target mapping information based on the detail code and second address information corresponding to the second address keyword.
3. The method of claim 1, wherein the region information comprises first parcel number data;
the acquiring, from a mapping information database constructed in advance, target mapping information adapted to the detail code and the area information based on the detail code and the area information includes:
acquiring first parcel number data of the target area;
selecting parcel number data which is the same as the first parcel number data from the mapping information database as second parcel number data;
determining the target mapping information based on the detail code and the second parcel number data.
4. The method according to any one of claims 1 to 3, wherein the obtaining detailed code of mapping information adapted to the compensation clause comprises:
acquiring a target compensation strategy matched with the compensation clause;
determining the detail code based on the target compensation policy.
5. The method of claim 4, wherein obtaining a target compensation policy that matches the compensation terms comprises:
acquiring a compensation strategy table; the compensation strategy table stores compensation strategies corresponding to various compensation terms;
and if the compensation strategy table stores the compensation strategy matched with the compensation terms, extracting the compensation strategy matched with the compensation terms from the compensation strategy table and using the compensation strategy as the target compensation strategy.
6. The method of claim 5, wherein after obtaining the compensation policy table, the method further comprises:
and if the compensation strategy table does not store the compensation strategy matched with the compensation terms, triggering a preset dynamic formula compiler to generate the compensation strategy matched with the compensation terms as the target compensation strategy.
7. The method of claim 1, wherein generating a corresponding compensation protocol based on the compensation data comprises:
acquiring a data correctness checking result aiming at the compensation data;
and if the data correctness checking result is that the data passes the checking, generating the compensation protocol based on the compensation data.
8. A compensation protocol generation apparatus, the apparatus comprising:
a compensation clause determination module for determining compensation clauses for the target area;
the detail code acquisition module is used for acquiring the detail codes of the mapping information suitable for the compensation clause and acquiring the area information of the target area;
a mapping information acquisition module, configured to acquire, based on the detail code and the region information, target mapping information that is adapted to the detail code and the region information from a mapping information database that is constructed in advance; the mapping information database stores mapping information corresponding to different detailed codes and area information respectively;
and the compensation protocol generation module is used for obtaining compensation data aiming at the target area according to the target mapping information and the compensation clause and generating a corresponding compensation protocol based on the compensation data.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010628250.5A CN111949682B (en) | 2020-07-02 | 2020-07-02 | Compensation protocol generation method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010628250.5A CN111949682B (en) | 2020-07-02 | 2020-07-02 | Compensation protocol generation method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111949682A true CN111949682A (en) | 2020-11-17 |
| CN111949682B CN111949682B (en) | 2024-04-16 |
Family
ID=73337409
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010628250.5A Active CN111949682B (en) | 2020-07-02 | 2020-07-02 | Compensation protocol generation method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111949682B (en) |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5477617A (en) * | 1994-12-14 | 1995-12-26 | Guy; John W. | Carpet measurement tool |
| JP2007087259A (en) * | 2005-09-26 | 2007-04-05 | Fujitsu Ltd | Road plan support program and road plan support apparatus |
| US20070162372A1 (en) * | 2005-12-27 | 2007-07-12 | Alex Anas | Computer based system to generate data for implementing regional and metropolitan economic, land use and transportation planning |
| WO2012020432A2 (en) * | 2010-08-12 | 2012-02-16 | Logica Private Limited | System and method for computing a variable fuel price based on exhaust gas emissions of a vehicle |
| CN103017655A (en) * | 2012-11-30 | 2013-04-03 | 刘庆国 | Method and system for extracting floor area of multi-floor building |
| CN106875131A (en) * | 2017-03-17 | 2017-06-20 | 北京世纪国源科技股份有限公司 | A kind of dismantlement valuation allocation method and system |
| CN207816276U (en) * | 2018-02-28 | 2018-09-04 | 崔壬凤 | A kind of field surveys device of project cost |
| CN109191574A (en) * | 2018-09-07 | 2019-01-11 | 江苏省工程勘测研究院有限责任公司 | Earth clearance object research information management system based on unmanned plane oblique photograph |
| CN109508964A (en) * | 2018-12-14 | 2019-03-22 | 平安国际融资租赁有限公司 | Project method for building up, device, computer equipment and storage medium |
| CN109767374A (en) * | 2019-01-09 | 2019-05-17 | 浙江健德普信息科技有限公司 | A kind of house collection platform |
| CN109767116A (en) * | 2019-01-09 | 2019-05-17 | 浙江健德普信息科技有限公司 | A kind of house administration of collection method |
| CN110263145A (en) * | 2019-05-07 | 2019-09-20 | 深圳市买买提信息科技有限公司 | A kind of electronic contract signature method and electronic contract sign equipment |
| CN110889794A (en) * | 2019-09-30 | 2020-03-17 | 成都市市政工程设计研究院 | Statistical method for municipal road land acquisition houses |
| CN110910446A (en) * | 2019-11-26 | 2020-03-24 | 北京拓维思科技有限公司 | Method and device for determining building removal area and method and device for determining indoor area of building |
| CN210771235U (en) * | 2019-10-10 | 2020-06-16 | 段力元 | Land sign is received and is used measuring device |
-
2020
- 2020-07-02 CN CN202010628250.5A patent/CN111949682B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5477617A (en) * | 1994-12-14 | 1995-12-26 | Guy; John W. | Carpet measurement tool |
| JP2007087259A (en) * | 2005-09-26 | 2007-04-05 | Fujitsu Ltd | Road plan support program and road plan support apparatus |
| US20070162372A1 (en) * | 2005-12-27 | 2007-07-12 | Alex Anas | Computer based system to generate data for implementing regional and metropolitan economic, land use and transportation planning |
| WO2012020432A2 (en) * | 2010-08-12 | 2012-02-16 | Logica Private Limited | System and method for computing a variable fuel price based on exhaust gas emissions of a vehicle |
| CN103017655A (en) * | 2012-11-30 | 2013-04-03 | 刘庆国 | Method and system for extracting floor area of multi-floor building |
| CN106875131A (en) * | 2017-03-17 | 2017-06-20 | 北京世纪国源科技股份有限公司 | A kind of dismantlement valuation allocation method and system |
| CN207816276U (en) * | 2018-02-28 | 2018-09-04 | 崔壬凤 | A kind of field surveys device of project cost |
| CN109191574A (en) * | 2018-09-07 | 2019-01-11 | 江苏省工程勘测研究院有限责任公司 | Earth clearance object research information management system based on unmanned plane oblique photograph |
| CN109508964A (en) * | 2018-12-14 | 2019-03-22 | 平安国际融资租赁有限公司 | Project method for building up, device, computer equipment and storage medium |
| CN109767374A (en) * | 2019-01-09 | 2019-05-17 | 浙江健德普信息科技有限公司 | A kind of house collection platform |
| CN109767116A (en) * | 2019-01-09 | 2019-05-17 | 浙江健德普信息科技有限公司 | A kind of house administration of collection method |
| CN110263145A (en) * | 2019-05-07 | 2019-09-20 | 深圳市买买提信息科技有限公司 | A kind of electronic contract signature method and electronic contract sign equipment |
| CN110889794A (en) * | 2019-09-30 | 2020-03-17 | 成都市市政工程设计研究院 | Statistical method for municipal road land acquisition houses |
| CN210771235U (en) * | 2019-10-10 | 2020-06-16 | 段力元 | Land sign is received and is used measuring device |
| CN110910446A (en) * | 2019-11-26 | 2020-03-24 | 北京拓维思科技有限公司 | Method and device for determining building removal area and method and device for determining indoor area of building |
Non-Patent Citations (1)
| Title |
|---|
| 索俊锋: "基于MicroStation的旧城改造可行性分析——以陕西省丹凤县为例", 宝鸡文理学院学报(自然科学版), 30 December 2006 (2006-12-30), pages 321 - 324 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111949682B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Hesselbarth et al. | landscapemetrics: an open‐source R tool to calculate landscape metrics | |
| US8407262B2 (en) | Systems and methods for generating an entity diagram | |
| CN102067106A (en) | Data quality tracking by determining metric values for child nodes and a parent node | |
| EP3218811B1 (en) | Testing insecure computing environments using random data sets generated from characterizations of real data sets | |
| US20110161373A1 (en) | User Interface for Establishing Mappings from Internal Metadata to External Metadata | |
| US20060259891A1 (en) | System and method of generating an auto-wiring script | |
| CN106681921A (en) | Method and device for achieving data parameterization | |
| CN109597979B (en) | List table generation method and device, computer equipment and storage medium | |
| CN113327136A (en) | Attribution analysis method and device, electronic equipment and storage medium | |
| CN115605903A (en) | System and method for quickly composing, launching and configuring a customizable second-level migration structure with a built-in audit and monitoring structure | |
| Kumar et al. | Conceptualizing “COBieEvaluator” A rule based system for tracking asset changes using COBie datasheets | |
| CN116560683A (en) | Software updating method, device, equipment and storage medium | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN114327435A (en) | Technical document generation method and device and computer readable storage medium | |
| CN111949845B (en) | Method, apparatus, computer device and storage medium for processing mapping information | |
| JP5972472B2 (en) | Data processing apparatus, data processing method, and program | |
| Byrd et al. | An active-set algorithm for nonlinear programming using parametric linear programming | |
| CN105867886A (en) | Method and device for writing table | |
| CN109840250B (en) | Method, device, equipment and storage medium for managing access authority of intermediate field | |
| US7502721B2 (en) | Product design support system, product design support method, and program | |
| CN111949682B (en) | Compensation protocol generation method, device, computer equipment and storage medium | |
| CN113076086B (en) | Metadata management system and method for modeling model object using the same | |
| CN113515570B (en) | Distributed database data replication method and device | |
| US20220342903A1 (en) | A data extraction method | |
| CN115268717A (en) | Method and device for adding measurement points in point inspection management system and computer 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |