Method, device, equipment and storage medium for acquiring property budget data
By making API interface calls between the property system and the database, obtaining and matching property budget data, the problem of traditional budget calculation relying on manual and template configuration is solved, and efficient and fast property budget data acquisition and calculation is achieved.
Patent Information
- Application Number
- CN202510162647.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-02-14
- Publication Date
- 2025-04-22
- Estimated Expiration
- 2045-02-14
AI Technical Summary
Traditional property budget calculation methods rely on manual calculations and cannot meet the needs of efficiency and accuracy. The budget templates need to be written by developers, resulting in increased development cycles and costs, and it is impossible to quickly configure to meet temporary budget calculation needs.
The property budget data needs are determined in the visual interface through third-party components, and the target information object and candidate budget data are obtained from the property system and database respectively, and match to obtain the target budget data without configuring a budget template.
It reduces the workload and development costs of developers, improves the efficiency of property budget calculation, and can quickly configure it to meet temporary budget calculation needs.
Smart Images

Figure CN119621793B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to but is not limited to the field of data processing technology, and in particular to a method, device, equipment, and storage medium for acquiring property budget data. Background Art
[0002] In the real estate field, it is often necessary to calculate budget expenditures for different property projects. The traditional budget calculation method mainly relies on manual calculation. However, the budget in the real estate field not only needs to process static data, but also needs to effectively analyze real-time data. Manual calculation can no longer meet the requirements of efficiency and accuracy. Based on this, the existing system pre-sets budget templates for different types of property projects in the property server, selects the corresponding budget template according to different budget requirements, and then automatically imports the budget data through the selected budget template for budget calculation.
[0003] However, since the budget template requires developers to write code, for any property project, the data type of the budget data required to calculate the budget will change according to actual needs. When the data type acquisition requirements of the budget data corresponding to the financial project change, the budget calculation requirements will also change. Developers are required to rewrite the code or modify it to generate a new budget template, which involves a certain development cycle and development cost. If there is a temporary budget calculation requirement, it is impossible to quickly configure a budget template that meets the requirements, which will affect the efficiency of the budget calculation. Summary of the invention
[0004] The embodiments of the present application provide a method, device, equipment, and storage medium for obtaining property budget data. Property budget data is obtained from a database and a property system respectively according to property budget calculation requirements through a third-party component. No budget template is required, which reduces the workload of developers and thus reduces development costs.
[0005] In a first aspect, an embodiment of the present application provides a method for obtaining property budget data, the method is applied to a target component, the target component is respectively connected to a property system and a database, the target component displays a visual interface, and is preset with a first API interface and a second API interface, the method comprising:
[0006] Determine a first data requirement and a second data requirement according to a user operation in the visualization interface, wherein the first data requirement is used to indicate a data requirement in the property system, and the second data requirement is used to indicate a data requirement in the database;
[0007] Obtaining a target information object corresponding to the first data requirement from the property system through the first API interface, wherein the target information object corresponds to a first index, and the first index is used to uniquely identify the target information object;
[0008] Acquire multiple candidate budget data corresponding to the second data requirement from the database through the second API interface, wherein each candidate budget data corresponds to a second index, and the second index is used to uniquely identify the information object corresponding to the candidate budget data;
[0009] The second index matching the first index is determined as a target index, and target budget data of the corresponding target information object is determined according to the candidate budget data corresponding to the target index.
[0010] In some embodiments, the visualization interface displays a first interface and a second interface, and determining the first data requirement and the second data requirement according to a user operation in the visualization interface includes:
[0011] Displaying a plurality of first fields and a plurality of second fields on the first interface, wherein different first fields correspond to different property items, and different second fields are used to indicate different types of information sets;
[0012] Displaying a plurality of third fields on the second interface, where different third fields correspond to different budget types;
[0013] determining the first data requirement by using a first target field selected by a user from a plurality of the first fields and the second fields;
[0014] A second target field selected by a user from the plurality of third fields is determined as the second data requirement.
[0015] In some embodiments, determining the first data requirement and the second data requirement according to the user operation in the visualization interface includes:
[0016] Obtaining the requirement description information entered by the user in the input box of the visualization interface;
[0017] Acquire a target NLP model, wherein the target NLP model is provided with a preset field library, wherein the preset field library includes a first field set associated with the information object and a second field set associated with a budget type;
[0018] Matching the requirement description information with each field of the first field set, and determining the successfully matched field as a first keyword;
[0019] Matching the requirement description information with each field of the second field set, and determining the successfully matched field as a second keyword;
[0020] The first keyword is determined as the first data requirement, and the second keyword is determined as the second data requirement.
[0021] In some embodiments, the property system stores multiple information sets, each of which includes multiple information objects, and obtaining multiple target information objects corresponding to the first data requirement from the property system through the first API interface includes:
[0022] Calling the first API interface to send the first data requirement to the property system, wherein the first data requirement includes a first target keyword for indicating a target information set;
[0023] The property system determines the target information set corresponding to the first target keyword from each of the information sets, and determines all information objects corresponding to the target information set as the target information objects;
[0024] The property system encapsulates all object attribute information corresponding to the target information object into a first response, and sends the first response to the first API interface, wherein the object attribute information includes the first index.
[0025] In some embodiments, the database includes multiple data sources, and different data sources include different types of property budget data. Acquiring multiple candidate budget data corresponding to the second data requirement from the database through the second API interface includes:
[0026] Calling the second API interface to send the second data requirement to the database, wherein the second data requirement includes a second target keyword for indicating a target budget type;
[0027] The database determines a target data source corresponding to the second target keyword from all data sources, and determines all property budget data included in the target data source as the candidate budget data;
[0028] The database encapsulates all of the candidate budget data and the second index associated with each of the candidate budget data into a second response, and sends the second response to the second API interface.
[0029] In some embodiments, the target information object includes a first object and a second object, the first object and the second object have different property items, the first index includes a first sub-index and a second sub-index, the first sub-index corresponds to the first object, and the second sub-index corresponds to the second object, the second index matching the first index is determined as the target index, and the target budget data of the target information object corresponding to the candidate budget data corresponding to the target index is determined, including:
[0030] Matching the first sub-index with all the second indexes, and determining an index that successfully matches the first sub-index as a first target index;
[0031] determining the budget type of the candidate budget data associated with the first target index as a first reference type;
[0032] Matching the second sub-index with all the indexes in the second indexes except the first target index, and determining the index successfully matched with the second sub-index as the second target index;
[0033] determining the budget type of the candidate budget data associated with the second target index as a second reference type;
[0034] The target budget data is determined from candidate budget data corresponding to the first target index and candidate budget data corresponding to the second target index based on the first reference type, the second reference type, and a target budget type indicated by the second data requirement.
[0035] In some embodiments, the target budget type includes a first target type and a second target type, and based on the first reference type, the second reference type, and the target budget type indicated by the second data requirement, determining the target budget data from candidate budget data corresponding to the first target index and candidate budget data corresponding to the second target index includes:
[0036] When the first target type is the same as the first reference type, determining the candidate budget data corresponding to the first target index as the target budget data, or, when the first target type is a subclass of the first reference type, extracting the budget data corresponding to the first target type from the candidate budget data corresponding to the first target index as the target budget data;
[0037] When the second target type is the same as the second reference type, the candidate budget data corresponding to the second target index is determined as the target budget data; or, when the second target type is a subclass of the second reference type, the budget data corresponding to the second target type is extracted from the candidate budget data corresponding to the second target index as the target budget data.
[0038] In a second aspect, an embodiment of the present application provides a control device, comprising at least one control processor and a memory for communicating with the at least one control processor; the memory stores instructions that can be executed by the at least one control processor, and the instructions are executed by the at least one control processor so that the at least one control processor can execute the method for obtaining property budget data as described in the first aspect.
[0039] In a third aspect, an embodiment of the present application further provides an electronic device, comprising the control device of the second aspect.
[0040] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are used to execute the method for acquiring property budget data as described in the first aspect.
[0041] The embodiment of the present application provides a method, device, equipment, and storage medium for obtaining property budget data, the method comprising: determining a first data requirement and a second data requirement according to a user operation in the visualization interface, wherein the first data requirement is used to indicate the data requirement in the property system, and the second data requirement is used to indicate the data requirement in the database; obtaining a target information object corresponding to the first data requirement from the property system through the first API interface, wherein the target information object corresponds to a first index, and the first index is used to uniquely identify the target information object; obtaining multiple candidate budget data corresponding to the second data requirement from the database through the second API interface, wherein each candidate budget data corresponds to a second index, and the second index is used to uniquely identify the information object corresponding to the candidate budget data; determining the second index matching the first index as the target index, and determining the target budget data corresponding to the target information object according to the candidate budget data corresponding to the target index. According to the scheme provided by the embodiment of the present application, the third-party component obtains relevant data from the database and the property system respectively according to the property budget calculation requirements, and further matches the obtained data to obtain the budget data used to calculate the property budget, without the need to configure the budget template, reducing the workload of developers, thereby reducing development costs. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] Figure 1is a flowchart of the steps of a method for obtaining property budget data provided by an embodiment of the present application;
[0043] Figure 2 is a schematic diagram of a method for acquiring property budget data provided by another embodiment of the present application;
[0044] Figure 3 It is a structural diagram of a control device provided in another embodiment of the present application. DETAILED DESCRIPTION
[0045] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0046] It is understood that although the functional modules are divided in the device schematic diagram and the logical order is shown in the flow chart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flow chart. The terms "first", "second", etc. in the specification, claims or the above drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence.
[0047] In the real estate field, it is often necessary to calculate budget expenditures for different property projects. The traditional budget calculation method mainly relies on manual calculation. However, the budget in the real estate field not only needs to process static data, but also needs to effectively analyze real-time data. Manual calculation can no longer meet the requirements of efficiency and accuracy. Based on this, the existing system pre-sets budget templates for different types of property projects in the property server, selects the corresponding budget template according to different budget requirements, and then automatically imports the budget data through the selected budget template for budget calculation.
[0048] However, since the budget template requires developers to write code, for any property project, the data type of the budget data required to calculate the budget will change according to actual needs. When the data type acquisition requirements of the budget data corresponding to the financial project change, the budget calculation requirements will also change. Developers are required to rewrite the code or modify it to generate a new budget template, which involves a certain development cycle and development cost. If there is a temporary budget calculation requirement, it is impossible to quickly configure a budget template that meets the requirements, which will affect the efficiency of the budget calculation.
[0049] To solve the above-mentioned problems, the embodiment of the present application provides a method, device, equipment, and storage medium for obtaining property budget data, the method comprising: determining a first data requirement and a second data requirement according to a user operation in the visual interface, wherein the first data requirement is used to indicate the data requirement in the property system, and the second data requirement is used to indicate the data requirement in the database; obtaining a target information object corresponding to the first data requirement from the property system through the first API interface, wherein the target information object corresponds to a first index, and the first index is used to uniquely identify the target information object; obtaining multiple candidate budget data corresponding to the second data requirement from the database through the second API interface, wherein each candidate budget data corresponds to a second index, and the second index is used to uniquely identify the information object corresponding to the candidate budget data; determining the second index matching the first index as the target index, and determining the target budget data corresponding to the target information object according to the candidate budget data corresponding to the target index. According to the scheme provided by the embodiment of the present application, the third-party component obtains relevant data from the database and the property system respectively according to the property budget calculation requirements, and further matches the obtained data to obtain the budget data used to calculate the property budget, without the need to configure the budget template, reducing the workload of developers, thereby reducing development costs.
[0050] The embodiments of the present application are further described below in conjunction with the accompanying drawings.
[0051] refer to Figure 1 , Figure 1 The present invention provides a method for obtaining property budget data in accordance with an embodiment of the present invention. The present invention provides a method for obtaining property budget data. The method is applied to a target component. The target component is respectively connected to a property system and a database for communication. The target component displays a visual interface and is preset with a first API interface and a second API interface. The method for obtaining property budget data in this embodiment includes but is not limited to the following steps:
[0052] Step S10, determining a first data requirement and a second data requirement according to a user operation in a visualization interface, wherein the first data requirement is used to indicate a data requirement in a property system, and the second data requirement is used to indicate a data requirement in a database.
[0053] Specifically, refer to Figure 2 The target component of this embodiment is a software plug-in. After the user logs in to the target component, he can perform user operations on the visual interface of the target component, thereby generating a first data requirement associated with the property system and a second data requirement associated with the database.
[0054] Specifically, the first data requirement of this embodiment includes corresponding property items and information sets, and the second data requirement includes budget data types. The first data requirement and the second data requirement are determined by specific budget calculation requirements. For example, when the budget calculation requirement is the salary budget cost of cleaning staff, the corresponding property item of the first data requirement corresponds to the property staff salary budget cost, the information set corresponds to cleaning staff, and the budget data type of the second data requirement is property staff salary data; or, when the budget calculation requirement is the greening facility procurement budget cost, the corresponding property item of the first data requirement corresponds to the property facility repair budget cost, the information set corresponds to greening facilities, and the budget data type of the second data requirement is the budget data of various flowers and trees related to greening facilities.
[0055] It can be understood that the main purpose of the scheme of this embodiment is to obtain the property budget data corresponding to the property project, so as to provide a data basis for calculating the budget cost of the corresponding property project. Through a third-party target component that is respectively connected to the property system and the database, the user logs in to the target component to perform user operations to determine the budget list objects (i.e., the first data requirements) that need to be obtained from the property system and the specific budget data (i.e., the second data requirements) obtained from the database, thereby providing effective support for the subsequent acquisition of the target budget data. In this way, when there is a budget calculation demand for a property project, the user directly performs user operations in the visual interface of the target component of this application to determine the data requirements, which can trigger the link between the property system and the database to obtain the data required for calculating the budget. There is no need to obtain and configure the budget template according to the budget calculation demand as in the prior art, and obtain data through the template. If the budget calculation demand is a new temporary demand, there is no suitable budget template in the system and it is necessary to wait for the developer to rewrite the code to configure the new template, which greatly affects the efficiency of calculating the budget. Compared with the prior art, the present application can omit the template configuration process in one step, and only obtain the budget data through the user operation of the target component, thereby reducing the development cost and improving the calculation efficiency of the property budget.
[0056] It should be noted that, in this embodiment, the user operation performed by the user in the visualization interface of the target component can be by respectively selecting the fields required for dragging in the first interface associated with the property system in the visualization interface and the second interface associated with the database, or by entering data requirement description information in the input box of the visualization interface. Both methods can determine the data requirements that can trigger the target component to obtain budget-related data across systems.
[0057] Specifically, in some embodiments, the visual interface displays a first interface and a second interface, and step S10 includes but is not limited to the following steps:
[0058] Step S11, displaying a plurality of first fields and a plurality of second fields on the first interface, wherein different first fields correspond to different property items, and different second fields are used to indicate different types of information sets;
[0059] Step S12, displaying a plurality of third fields on the second interface, where different third fields correspond to different budget types;
[0060] Step S13, determining a first data requirement for a first target field selected by a user from a plurality of first fields and second fields;
[0061] Step S14: determining the second target field selected by the user from the plurality of third fields as the second data requirement.
[0062] Specifically, the first fields and the second fields in the first interface of this embodiment correspond to the following: Figure 2 The information objects related to the property budget stored in the property system shown in the figure have the same number of first fields as the number of property items stored in the property system, the same number of second fields as the number of information sets stored in the property system, and each first field is associated with at least one second field; and the multiple third fields in the second interface correspond to Figure 2 For each data source stored in the database shown, the number of the third fields is the same as the number of the data sources stored in the database.
[0063] Specifically, the first interface of this embodiment includes the first field 1, the first field 2, ..., the first field n, the first field 1 corresponds to the second field 11 and the second field 12, and the first field 2 corresponds to the second field 21 and the second field 22; the second interface includes the third field 1, the third field 2, ..., the third field n, when the user clicks or checks the first field 1 and the corresponding second field 2, the first field 1 and the second field 2 are the first target fields, and the first field 1 and the second field 2 are determined as the first data requirements, and when the user clicks or checks the third field 1, the third field 1 is determined as the second data requirement.
[0064] Specifically, in some embodiments, step S10 includes but is not limited to the following steps:
[0065] Step S15, obtaining the requirement description information input by the user in the input box of the visualization interface;
[0066] Step S16, obtaining a target NLP model, wherein the target NLP model is provided with a preset field library, wherein the preset field library includes a first field set associated with the information object and a second field set associated with the budget type;
[0067] Step S17, matching the requirement description information with each field of the first field set, and determining the successfully matched field as the first keyword;
[0068] Step S18, matching the requirement description information with each field of the second field set, and determining the successfully matched field as the second keyword;
[0069] Step S19: determine the first keyword as the first data requirement, and determine the second keyword as the second data requirement.
[0070] It can be understood that in addition to determining the first data requirement and the second data requirement for linking two different systems by selecting fields in the visual interface through the above steps S11 to S14, the present embodiment also provides a method in which the user can enter the requirement description information in the input box of the visual interface, thereby triggering the call of the target NLP model preset by the target component to perform keyword recognition on the requirement description information to determine the data requirement. The specific steps of this method include: in response to the user entering the requirement description information in the input box of the visual interface, obtaining a target NLP model with a preset field library, wherein the preset field library includes a first field set associated with the information object and a second field set associated with the budget type, matching the requirement description information with each field of the first field set, and determining the successfully matched field as the first keyword; matching the requirement description information with each field of the second field set, and determining the successfully matched field as the second keyword; determining the first keyword as the first data requirement, and determining the second keyword as the second data requirement, thereby providing effective support for triggering the target component to obtain budget-related data across systems.
[0071] Specifically, since obtaining target budget data that meets the property budget calculation requirements requires the target component to obtain data from the property system and the database systems respectively and combine them, and the target component of this embodiment is a software plug-in independent of the two systems, in order to ensure that the target component performs data acquisition smoothly, this embodiment provides a first API interface and a second API interface in the target component, wherein the first API interface is preset with a first function function, which is used to call the code of the property system so that the information returned by the code execution is used as the return parameter of the first function function. Similarly, the second API interface is provided with a second function function, which is used to call the code of the database so that the information returned by the code execution is used as the return parameter of the second function function. In this way, when a user with login operation authority of the target component generates the first data requirement and the second data requirement in the visual interface, the target component can actively obtain the required data across systems through the first API interface and the second API interface, thereby providing effective support for the subsequent acquisition of the target budget data.
[0072] Step S20, obtaining a target information object corresponding to the first data requirement from the property system through the first API interface, wherein the target information object corresponds to a first index, and the first index is used to uniquely identify the target information object.
[0073] Specifically, in some embodiments, the property system stores multiple information sets, each of which includes multiple information objects. Step S20 includes but is not limited to the following steps:
[0074] Step S21, calling a first API interface to send a first data requirement to a property system, wherein the first data requirement includes a first target keyword for indicating a target information set;
[0075] Step S22, the property system determines a target information set corresponding to the first target keyword from each information set, and determines all information objects corresponding to the target information set as target information objects;
[0076] In step S23, the property system encapsulates the object attribute information corresponding to all target information objects into a first response, and sends the first response to the first API interface, wherein the object attribute information includes a first index.
[0077] It can be understood that, with reference to the description of the above embodiment, this embodiment sends a first data requirement to the property system through the first API interface, thereby triggering the first function of the first API interface to call the data query code of the property system, so that the property system determines the target information set corresponding to the first target keyword corresponding to the first data requirement from each information set, and determines all information objects corresponding to the target information set as the target information object, which is the information returned after executing the data query code, and the target information object serves as the return parameter of the first function function. The property system encapsulates the object attribute information corresponding to all the target information objects into a first response, and sends the first response to the first API interface. In this way, the first API interface obtains the return parameter of the first function function, that is, the aforementioned target information object, thereby providing an effective data basis for the subsequent acquisition of target budget data.
[0078] Step S30: acquiring a plurality of candidate budget data corresponding to the second data requirement from the database through the second API interface, wherein each candidate budget data corresponds to a second index, and the second index is used to uniquely identify the information object corresponding to the candidate budget data.
[0079] Specifically, in some embodiments, the database includes multiple data sources, and different data sources include different types of property budget data. Step S30 includes but is not limited to the following steps:
[0080] Step S31, calling a second API interface to send a second data requirement to a database, wherein the second data requirement includes a second target keyword for indicating a target budget type;
[0081] Step S32, the database determines a target data source corresponding to the second target keyword from all data sources, and determines all property budget data included in the target data source as candidate budget data;
[0082] Step S33: the database encapsulates all candidate budget data and the second index associated with each candidate budget data into a second response, and sends the second response to the second API interface.
[0083] It can be understood that, with reference to the description of the above embodiment, this embodiment sends a second data requirement to the database through the second API interface, thereby triggering the second function of the second API interface to call the data query code of the database, so that the database determines the target data source corresponding to the second target keyword corresponding to the second data requirement from various data sources, and determines all budget data corresponding to the target data source as candidate budget data, which is the data returned after executing the data query code of the database, and the candidate budget data serves as the return parameter of the second function function. The database encapsulates all candidate budget data and the corresponding second index into a second response, and sends the second response to the second API interface, so that the second API interface obtains the return parameter of the second function function, that is, the aforementioned candidate budget data, thereby providing an effective data basis for subsequent acquisition of target budget data.
[0084] Step S40: determine the second index matching the first index as the target index, and determine the target budget data of the corresponding target information object according to the candidate budget data corresponding to the target index.
[0085] It can be understood that the target information object obtained from the property system is equivalent to the budget list corresponding to the property budget demand. Each target information object in the budget list corresponds to a first index, and the candidate budget data obtained from the database is equivalent to the price data related to the property budget demand. Each candidate budget data in the price data corresponds to a second index. Although the budget list and the price data are stored separately in different systems, the two can be associated with each other through indexes. Therefore, after obtaining the target information object and candidate budget data from the property system and database through the target component, the first index of the target information object is used as the matching source, and the second index matching the first index is determined as the target index. The target budget data of the corresponding target information object is determined according to the candidate budget data corresponding to the target index, thereby providing an effective data basis for the subsequent budget calculation of the corresponding property project.
[0086] Specifically, in some embodiments, the target information object includes a first object and a second object, the first object and the second object have different property items, the first index includes a first sub-index and a second sub-index, the first sub-index corresponds to the first object, and the second sub-index corresponds to the second object. Figure 1 Step S40 includes but is not limited to the following steps:
[0087] Step S41, matching the first sub-index with all the second indexes, and determining the index that successfully matches the first sub-index as the first target index;
[0088] Step S42, determining the budget type of the candidate budget data associated with the first target index as a first reference type;
[0089] Step S43, matching the second sub-index with all the second indexes except the first target index, and determining the index that successfully matches the second sub-index as the second target index;
[0090] Step S44, determining the budget type of the candidate budget data associated with the second target index as the second reference type;
[0091] Step S45 , determining target budget data from candidate budget data corresponding to the first target index and candidate budget data corresponding to the second target index based on the first reference type, the second reference type and the target budget type indicated by the second data requirement.
[0092] Specifically, in some embodiments, the target budget type includes a first target type and a second target type, and step S45 includes but is not limited to the following steps:
[0093] Step S451, when the first target type is the same as the first reference type, determining the candidate budget data corresponding to the first target index as the target budget data, or, when the first target type is a subclass of the first reference type, extracting the budget data corresponding to the first target type from the candidate budget data corresponding to the first target index as the target budget data;
[0094] Step S452, when the second target type is the same as the second reference type, the candidate budget data corresponding to the second target index is determined as the target budget data, or, when the second target type is a subclass of the second reference type, the budget data corresponding to the second target type is extracted from the candidate budget data corresponding to the second target index as the target budget data.
[0095] It can be understood that the specific type of the target information object obtained from the property system is determined by the property project to which it belongs. Referring to the description of the above embodiment, after the target information object and the candidate budget data are obtained from the property system and the database through the target component, if the target information object includes at least two types of information objects (for example, a first object and a second object), the steps of matching and combining the target information object with the candidate budget data to obtain the target budget data are as follows: selecting the first sub-index to match with all the second indexes, and determining the index that successfully matches the first sub-index as the first target index; determining the budget type of the candidate budget data associated with the first target index as the first reference type; matching the second sub-index with the indexes of all the second indexes except the first target index, and determining the index that successfully matches the second sub-index as the second target index; and matching the second target index with the second sub-index. The budget type of the candidate budget data associated with the reference is determined as the second reference type; however, even if the first index of the target information object matches the second index corresponding to the candidate budget data obtained from the database, the matched candidate budget data may not fully meet the user's budget data acquisition needs. For example, the user's corresponding budget data acquisition needs are to obtain the social security budget costs of cleaning staff and the provident fund costs of maintenance staff, while the candidate budget data obtained from the database are the wage costs of all cleaning staff and maintenance staff, and the provident fund costs and social security budget costs belong to the subcategories of wage costs. If the wage costs of all cleaning staff and maintenance staff are determined as the target budget data, subsequent users will need to filter data from the cleaning staff's wage costs and extract the social security budget costs, and will need to filter data from the maintenance staff's wage costs and extract the provident fund budget costs, which will affect the efficiency of subsequent calculation of budget costs.
[0096] Based on the above-mentioned problems, this embodiment determines the target budget data from the candidate budget data corresponding to the first target index and the candidate budget data corresponding to the second target index based on the target budget type indicated by the first reference type, the second reference type and the second data requirement. Specifically, when the first target type is the same as the first reference type, the candidate budget data corresponding to the first target index is determined as the target budget data, or, when the first target type is a subclass of the first reference type, the budget data corresponding to the first target type is extracted from the candidate budget data corresponding to the first target index as the target budget data; when the second target type is the same as the second reference type, the candidate budget data corresponding to the second target index is determined as the target budget data, or, when the second target type is a subclass of the second reference type, the budget data corresponding to the second target type is extracted from the candidate budget data corresponding to the second target index as the target budget data. That is to say, after completing the matching of the first index and the second index, the target component further compares the reference type (including the first reference type and the second reference type) of the matched budget data with the target type (including the first target type and the second target type) of the corresponding second data requirement to see if they are the same, and determines the accurate target budget data based on the comparison result, thereby ensuring the accuracy of the target budget data and improving the efficiency of calculating the budget cost. For example, the user's corresponding budget data acquisition requirement is to obtain the social security budget cost of the cleaning staff. When the candidate budget data obtained from the database is the salary cost of all cleaning staff, it means that the target type is different from the reference type, and the social security budget cost belongs to the subcategory of salary cost. The target component extracts the social security budget cost from the salary cost of the cleaning staff as the target budget data; when the candidate budget data obtained from the database is the social security budget cost of all cleaning staff, it means that the target type is the same as the reference type, and the social security budget cost of the cleaning staff is directly determined as the target budget data.
[0097] like Figure 3 As shown, Figure 3 : is a structural diagram of a control device provided by an embodiment of the present application. The present invention also provides a control device 300, including:
[0098] The processor 310 may be implemented by a general-purpose central processing unit (CPU), a microprocessor, an application-specific integrated circuit (BSIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;
[0099] The memory 320 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RBM). The memory 320 can store an operating system and other application programs. When the technical solution provided in the embodiment of this specification is implemented by software or firmware, the relevant program code is stored in the memory 320, and the processor 310 calls and executes the method for obtaining property budget data in the embodiment of this application;
[0100] Input / output interface 330, used to implement information input and output;
[0101] Communication interface 340, used to realize communication interaction between the apparatus and other devices, which can be realized by wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.);
[0102] bus 350 , which transmits information between the various components of the device (e.g., processor 310 , memory 320 , input / output interface 330 , and communication interface 340 );
[0103] The processor 310 , the memory 320 , the input / output interface 330 and the communication interface 340 are connected to each other in communication within the device via the bus 350 .
[0104] In addition, an embodiment of the present application further provides an electronic device, including the control device 300 of the above embodiment.
[0105] In addition, an embodiment of the present application further provides a storage medium, which is a computer-readable storage medium and stores a computer program. When the computer program is executed by a processor, the above-mentioned method for obtaining property budget data is implemented.
[0106] As a non-transient computer-readable storage medium, the memory can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage devices. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned networks include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and a combination thereof. The device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and are implemented to be located in one place, or may also be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the present embodiment.
[0107] It will be appreciated by those skilled in the art that all or some of the steps and systems in the methods disclosed above may be implemented as software, firmware, hardware, and appropriate combinations thereof. Some or all physical components may be implemented as software executed by a processor, such as a central processing unit, a digital signal processor, or a microprocessor, or as hardware, or as an integrated circuit, such as an application-specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or temporary medium). As known to those skilled in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data). Computer storage media include, but are not limited to, RBM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disk (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, disk storage or other magnetic storage devices, or any other medium that can be used to store desired information and can be accessed by a computer. Furthermore, it is well known to those skilled in the art that communication media typically include computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.
[0108] The above is a specific description of the preferred implementation of the present invention, but the present invention is not limited to the above-mentioned implementation mode. Technical personnel familiar with the field can also make various equivalent deformations or substitutions under the shared conditions without violating the spirit of the present invention. These equivalent deformations or substitutions are all included in the scope defined by the claims of the present invention.
Claims
1. A method for obtaining property budget data, characterized in that: Applied to a target component, the target component is respectively connected to a property system and a database, the target component displays a visual interface, and is preset with a first API interface and a second API interface, the method includes: Determine a first data requirement and a second data requirement according to a user operation in the visualization interface, wherein the first data requirement is used to indicate a data requirement in the property system, and the second data requirement is used to indicate a data requirement in the database; Obtaining a target information object corresponding to the first data requirement from the property system through the first API interface, wherein the target information object corresponds to a first index, and the first index is used to uniquely identify the target information object; Acquire multiple candidate budget data corresponding to the second data requirement from the database through the second API interface, wherein each candidate budget data corresponds to a second index, and the second index is used to uniquely identify the information object corresponding to the candidate budget data; Determine the second index matching the first index as a target index, and determine the target budget data of the corresponding target information object according to the candidate budget data corresponding to the target index; Determining the first data requirement and the second data requirement according to the user operation in the visualization interface includes: Obtaining the requirement description information entered by the user in the input box of the visualization interface; Acquire a target NLP model, wherein the target NLP model is provided with a preset field library, wherein the preset field library includes a first field set associated with the information object and a second field set associated with a budget type; Matching the requirement description information with each field of the first field set, and determining the successfully matched field as a first keyword; Matching the requirement description information with each field of the second field set, and determining the successfully matched field as a second keyword; Determine the first keyword as the first data requirement, and determine the second keyword as the second data requirement; The target information object includes a first object and a second object, the first object and the second object have different property items, the first index includes a first sub-index and a second sub-index, the first sub-index corresponds to the first object, and the second sub-index corresponds to the second object, the second index matching the first index is determined as the target index, and the target budget data of the target information object corresponding to the candidate budget data corresponding to the target index is determined, including: Matching the first sub-index with all the second indexes, and determining an index that successfully matches the first sub-index as a first target index; determining the budget type of the candidate budget data associated with the first target index as a first reference type; Matching the second sub-index with all the indexes in the second indexes except the first target index, and determining the index successfully matched with the second sub-index as the second target index; determining the budget type of the candidate budget data associated with the second target index as a second reference type; The target budget data is determined from candidate budget data corresponding to the first target index and candidate budget data corresponding to the second target index based on the first reference type, the second reference type, and a target budget type indicated by the second data requirement.
2. The method for obtaining property budget data according to claim 1, characterized in that: The visualization interface displays a first interface and a second interface, and determining the first data requirement and the second data requirement according to a user operation of the user in the visualization interface includes: Displaying a plurality of first fields and a plurality of second fields on the first interface, wherein different first fields correspond to different property items, and different second fields are used to indicate different types of information sets; Displaying a plurality of third fields on the second interface, where different third fields correspond to different budget types; determining the first data requirement by using a first target field selected by a user from a plurality of the first fields and the second fields; A second target field selected by a user from the plurality of third fields is determined as the second data requirement.
3. The method for obtaining property budget data according to claim 1 or 2, characterized in that: The property system stores a plurality of information sets, each of which includes a plurality of information objects. The plurality of target information objects corresponding to the first data requirement are obtained from the property system through the first API interface, including: Calling the first API interface to send the first data requirement to the property system, wherein the first data requirement includes a first target keyword for indicating a target information set; The property system determines the target information set corresponding to the first target keyword from each of the information sets, and determines all information objects corresponding to the target information set as the target information objects; The property system encapsulates all object attribute information corresponding to the target information object into a first response, and sends the first response to the first API interface, wherein the object attribute information includes the first index.
4. The method for obtaining property budget data according to claim 1 or 2, characterized in that: The database includes multiple data sources, and different data sources include different types of property budget data. The multiple candidate budget data corresponding to the second data requirement are obtained from the database through the second API interface, including: Calling the second API interface to send the second data requirement to the database, wherein the second data requirement includes a second target keyword for indicating a target budget type; The database determines a target data source corresponding to the second target keyword from all data sources, and determines all property budget data included in the target data source as the candidate budget data; The database encapsulates all of the candidate budget data and the second index associated with each of the candidate budget data into a second response, and sends the second response to the second API interface.
5. The method for obtaining property budget data according to claim 1, characterized in that: The target budget type includes a first target type and a second target type, and based on the first reference type, the second reference type, and the target budget type indicated by the second data requirement, determining the target budget data from candidate budget data corresponding to the first target index and candidate budget data corresponding to the second target index includes: When the first target type is the same as the first reference type, determining the candidate budget data corresponding to the first target index as the target budget data, or, when the first target type is a subclass of the first reference type, extracting the budget data corresponding to the first target type from the candidate budget data corresponding to the first target index as the target budget data; When the second target type is the same as the second reference type, the candidate budget data corresponding to the second target index is determined as the target budget data; or, when the second target type is a subclass of the second reference type, the budget data corresponding to the second target type is extracted from the candidate budget data corresponding to the second target index as the target budget data.
6. A control device, characterized in that: It includes at least one control processor and a memory for communicating with the at least one control processor; the memory stores instructions that can be executed by the at least one control processor, and the instructions are executed by the at least one control processor to enable the at least one control processor to execute the method for obtaining property budget data as described in any one of claims 1 to 5.
7. An electronic device, characterized in that: Includes the control device as claimed in claim 6.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the method for obtaining property budget data as described in any one of claims 1 to 5.
Citation Information
Patent Citations
Financial budget comparison method and device based on database, equipment and medium
CN119322610A
Integrated and dynamic advertisement, marketing, and e-commerce platform
WO2015044706A1