Communication project budget preparation method, system, electronic equipment and storage medium

Abstract

The present application proposes a budget preparation method, system, electronic device and storage medium for communication projects, and relates to the field of communication engineering technology. The method includes: drawing engineering drawings according to project-related information, and counting the required engineering materials and their quantities based on the drawn engineering drawings; selecting the corresponding communication engineering construction unit calculation plug-in for budget preparation according to the region where the project is located to obtain the corresponding budget preparation result data; selecting and loading the corresponding export template according to the specific process of the project and the needs of the builder, the export template includes a preset standard template and a template written by the user; binding the budget preparation result data and the additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file. This solution can improve the flexibility and customizability of data, and simplify the generation process of budget reports, thereby reducing manual intervention and errors, and improving efficiency and accuracy.

Description

Technical Field

[0001] The present application relates to the field of communication engineering technology, and in particular to a budget preparation method, system, electronic equipment and storage medium for a communication project. Background Art

[0002] Telecommunications project budgeting refers to the process of scientifically and rationally predicting and planning the resources (including human, material, and financial resources) required for a communication project before it is launched, based on factors such as project demand, scale, technical requirements, and market environment. This process requires not only accurate estimation of various costs, but also consideration of the sustainability, risk, and economic benefits of the project to ensure the smooth realization of project goals.

[0003] At present, there are two main methods for design budget preparation commonly used in the industry: one is the traditional method based on manual experience, which relies on experienced experts to make estimates based on historical data and project characteristics; the other is the semi-automatic method, which assists budget preparation by integrating some automated tools, but still requires a lot of manual intervention. However, these existing methods are limited by fixed software formats, have poor flexibility, and rely on a large number of manual preparation of supporting documents, resulting in efficiency and accuracy that need to be improved. Summary of the invention

[0004] The purpose of this application is to provide a budget preparation method, system, electronic device and storage medium for a communication project, which can improve the flexibility and customizability of data and simplify the budget report generation process, thereby reducing human intervention and errors and improving efficiency and accuracy.

[0005] In a first aspect, the present application provides a method for preparing a budget for a communication project, comprising the following steps: drawing engineering drawings based on project-related information, and counting the required engineering materials and their quantities based on the drawn engineering drawings; selecting a corresponding communication engineering construction unit calculation plug-in to prepare a budget based on the region where the project is located, so as to obtain corresponding budget preparation result data; selecting and loading a corresponding export template based on the specific process of the project and the needs of the builder, the export template including a preset standard template and a template written by the user; binding the budget preparation result data and additional imported data to the corresponding dynamic placeholders in the export template to obtain a corresponding budget report file.

[0006] In some implementations of the present application, when selecting the corresponding communication engineering construction unit calculation plug-in for budget preparation, it also includes adjusting the quota association and adjusting the price of engineering materials according to market price fluctuations.

[0007] In some implementations of the present application, the export template is in the format of an electronic document or a spreadsheet file.

[0008] In some implementations of the present application, binding the budget preparation result data to the dynamic placeholder in the export template includes: binding the budget preparation result data to the dynamic placeholder in the export template through the engine interface or function of the export template.

[0009] In some implementations of the present application, the step of binding the budget preparation result data to the dynamic placeholder in the export template is implemented through a rendering operation, which receives a dictionary containing key-value pairs as a parameter, the key corresponds to the placeholder name in the template, and the value corresponds to the data to be inserted.

[0010] In some implementations of the present application, the dynamic placeholder is a marker used to represent a variable or a control structure list in an export template, and will be replaced with actual static text or undergo corresponding logical processing during the export process.

[0011] In the second aspect, the present application provides a budget preparation system for a communication project, which includes: a data acquisition module, which is used to draw engineering drawings based on project-related information, and to count the required engineering materials and their quantities based on the drawn engineering drawings; a budget preparation module, which is used to select the corresponding communication engineering construction unit calculation plug-in for budget preparation according to the project area, so as to obtain the corresponding budget preparation result data; a selection and loading module, which is used to select and load the corresponding export template according to the specific process of the project and the needs of the builder, and the export template includes a preset standard template and a template written by the user; a report generation module, which is used to bind the budget preparation result data and additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

[0012] In some implementations of the present application, the architecture of the system includes: a model layer, which is used to store and process budget preparation result data; a control layer, which is used to receive user instructions and coordinate data interaction between the model layer and the view layer; and a view layer, which is used to display the budget preparation results and the user interaction interface.

[0013] In a third aspect, the present application provides an electronic device, comprising a memory for storing one or more programs; a processor; when the one or more programs are executed by the processor, a method as described in any one of the first aspects is implemented.

[0014] In a fourth aspect, the present application provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method as described in any one of the above-mentioned first aspects.

[0015] Compared with the prior art, the present invention has at least the following advantages or beneficial effects: This application proposes a budget preparation method for communication projects, which provides preset standard templates and user-defined templates, so that the budget preparation report can be flexibly adjusted according to the specific process of the project and the needs of the construction party, overcoming the limitations of fixed software formats. In addition, combined with the precise statistics of engineering drawings and the calculation plug-in of regional specific communication engineering construction units, the error of manual estimation is reduced, and the introduction of automated tools significantly improves the speed and accuracy of budget preparation. In addition, the automated data binding and report generation process greatly reduces the workload of manually compiling supporting documents and reduces errors and delays caused by human factors. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 A flowchart of an embodiment of a method for preparing a budget for a communication project of the present application; Figure 2 This is a schematic diagram of the modular export process in an embodiment of the present application; Figure 3 A schematic diagram of an electronic document template prepared in an embodiment of the present application; Figure 4 A schematic diagram of an electronic document exported after rendering in an embodiment of the present application; Figure 5 A structural block diagram of an embodiment of a budget preparation system for a communication project of the present application; Figure 6 This is a schematic diagram of the architecture of an embodiment of a budget compilation system for a communication project of the present application; Figure 7 A structural block diagram of an electronic device provided in an embodiment of the present application.

[0018] Icon: 201, processor; 202, memory; 203, communication interface. DETAILED DESCRIPTION

[0019] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, rather than all the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various different configurations.

[0020] In conjunction with the accompanying drawings, some embodiments of the present application are described in detail below. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.

[0021] Example 1 In the budget preparation of communication projects, the traditional manual experience method relies on expert judgment and lacks standardization and flexibility; while the semi-automated method introduces automated tools but is still highly dependent on manual labor, with limited efficiency and accuracy. These existing methods are limited by fixed software formats and a large amount of manual preparation, making it difficult to meet the needs of efficient and flexible budget preparation.

[0022] Specifically, the semi-automated method usually includes the following steps: (1) Budget preparation stage At this stage, professionals conduct comprehensive cost estimation and budget preparation for the communication engineering project based on relevant national standards, industry specifications and the budget management methods in the framework contract signed with the customer. This process involves the detailed planning and calculation of various expenses such as equipment purchase, material costs, construction and installation, commissioning and testing, etc., in order to ensure the rationality, accuracy and comprehensiveness of the budget.

[0023] (2) Fixed template data export After budget preparation is completed, the system usually provides export templates pre-designed by the software vendor. Users need to use these fixed templates to export budget data into tables in specific formats (such as spreadsheets, electronic documents, comma separated values, etc.) for subsequent use or sharing. However, the limitation of this step is that the export format is fixed and difficult to adjust, and cannot meet the user's needs for personalized report formats.

[0024] (3) Preparation of diversified explanatory documents In addition to budget forms, communication engineering projects also need to prepare a series of explanatory documents during the feasibility study, project establishment, approval, and completion stages. These documents include but are not limited to engineering specifications, review minutes, design review evaluation signature forms, etc., which are intended to elaborate on the project background, technical solutions, budget basis, review opinions, etc. At this stage, users need to manually compile these documents based on the exported budget data and actual project information. This process is not only time-consuming and labor-intensive, but also prone to errors or omissions due to human factors. In particular, when the project plan changes, all relevant documents need to be recompiled, which increases the complexity and uncertainty of the work.

[0025] The inventors have found that the current semi-automatic method has great limitations, mainly including the following aspects: (1) Rigidity of budget export format: Current project management software generally uses a fixed format pre-made by the software manufacturer when exporting budget reports, which severely limits the personalized needs of users. Users are often unable to adjust the export format according to their own project characteristics, report audience or specific requirements, resulting in the lack of flexibility and pertinence in the generated budget report, making it difficult to meet diverse actual needs.

[0026] (2) High cost and error-proneness of data compilation: During the key stages of the feasibility study, project establishment, approval, and completion of communication projects, communication project construction units need to prepare a large number of supporting documents. These documents are mostly in the form of spreadsheets, electronic documents, etc., and the needs of different communication project construction units vary and are of various types. At present, the preparation of these documents is highly dependent on manual labor and needs to be manually compiled based on actual project information and budget data. This method is not only inefficient and error-prone, but also seems to be unable to cope with the frequent modifications and changes to project plans. Once there is any change, all relevant information needs to be recompiled, which greatly increases the workload and the risk of errors, while also extending the project cycle and affecting the overall progress.

[0027] In this regard, an embodiment of the present application provides a budget preparation method for a communication project, which realizes the intelligent, standardized and efficient budget preparation by integrating technical means such as drawing statistics, exclusive plug-in calculations and flexible template export, significantly improves the flexibility and customizability of data, and simplifies the budget report generation process, thereby reducing manual intervention and errors and improving efficiency and accuracy.

[0028] See also Figure 1 The budget preparation method of a communication project includes the following steps: Step S101: Draw engineering drawings according to project-related information, and count the required engineering materials and their quantities based on the drawn engineering drawings.

[0029] In the above step S101, all information related to the project is first comprehensively collected, including but not limited to the project scale, technical requirements, geographical location, construction period, etc. Then, based on this information, professional engineers can draw detailed engineering drawings, which are important basis for subsequent project implementation and budget preparation. Then, according to these engineering drawings, various engineering materials and their quantities required for the project can be counted through calculation or by using special material estimation software.

[0030] Step S102: According to the region where the project is located, select the corresponding communication engineering construction unit calculation plug-in to prepare the budget, so as to obtain the corresponding budget preparation result data; In the above step S102, the corresponding communication engineering construction unit calculation plug-in is selected according to the characteristics of the region where the project is located (such as policies and regulations, market environment, cost structure, etc.). These plug-ins usually integrate regional-specific quota standards, tax policies and other information, which helps to prepare budgets more accurately, and can automatically prepare budgets based on the list of materials and other cost elements (such as labor costs, management fees, etc.) obtained in step 101. The budget preparation result data includes various cost details and the total budget. This region-specific communication engineering construction unit calculation plug-in can more accurately reflect the actual cost of the project in the local area, improve the accuracy of the budget, and ensure that the budget preparation process complies with local laws, regulations and industry standards, reducing legal risks.

[0031] Furthermore, in some implementations of the present application, when selecting the corresponding communication engineering construction unit calculation plug-in for budget preparation, it also includes adjusting the quota association and adjusting the price of engineering materials according to market price fluctuations. Among them, the quota association refers to the correspondence between various expenses and standard quotas in budget preparation. Since the actual situation of the project may differ from the standard quota (such as construction conditions, technical requirements, material specifications, etc.), it is necessary to adjust the quota association. This step requires the budget preparation personnel to have an in-depth understanding of the project, to accurately identify and evaluate the impact of these differences on the budget, and to make reasonable adjustments. Ensure that the calculation of various expenses is in line with the actual situation of the project. At the same time, according to market price fluctuations, adjust the material prices to ensure the timeliness and accuracy of the budget.

[0032] It should be noted that in the budget calculation process, the calculation of Table 3A, Table 3B, Table 3C, Table 4A Main Materials, Table 4A Equipment (these tables are standard tables for preparing budgets for communication projects), the number of rows varies according to the project. Assume that one of the Tables 3A has N rows of data and all elements are in set A. The elements in the set need to participate in the calculation of the data with a fixed number x , technician quota j , General Worker Quota p , demolition / construction / expansion coefficient μ. Then i Number of general workers in the line , the number of technicians in row i Then the total number of technicians in Table 3 is Similarly, the total number of technicians is Since each row of data needs to be calculated during the data update process, the time complexity of updating data is O(N).

[0033] Let cn be the number of times the data is updated. In the calculation process, only the first calculation uses the complexity of O(N), and its calculation method is , , , , temporary data is generated after the first calculation , .

[0034] Since users can only operate one row of data at a time in most cases, when cn>1, when the updated data is k When the element and , No. k The number of general workers before the element operation , Number of technicians . Number of general workers after operation , Number of technicians At this time, the general workers total , the total number of technicians . When cn>1 and When the time complexity can be easily obtained as O(1), its formula is , .

[0035] When the user operates all elements in set B at once and , Q is the number of elements in B, and the total number of common workers in B before the user operation is , similarly the total number of technicians is The total number of general workers in set B after the user operation is Similarly, the total number of technicians is The total number of general workers in set A is Similarly, the total number of technicians is , its time complexity is O(Q), and O(Q)≤O(N). If we use the algorithm with cn=1, its time complexity is O(N+Q), which is greater than O(N).

[0036] When the user adds set C to set A, and Q is the number of elements in C, and the total number of elements in C is Similarly, the total number of technicians is .gather The total number of Pu Ge is Similarly, the total number of technicians is . Its time complexity is O(Q). If we use the algorithm with cn=1, its time complexity is O(N+Q), which is greater than O(N).

[0037] Since the main materials in Table 3B, Table 3C, Table 4A, and the equipment in Table 4A are similar to Table 3A, their calculation results are amounts rather than working days. When cn=1, the time complexity of the above algorithm is O(N). When cn>1, its time complexity is divided into O(1) and O(Q) according to different operations, which are both smaller than the time complexity of the algorithm when cn=1.

[0038] Please continue reading Figure 1 , Step S103: According to the specific process of the project and the needs of the builder, select and load the corresponding export template, the export template includes a preset standard template and a template written by the user; After the budget is prepared, it is necessary to select a suitable export template based on the specific process of the project and the needs of the builder. These export templates can be pre-set standard templates or templates written by the project team based on previous experience. Templates are usually in the format of electronic documents or spreadsheet files, which is convenient for subsequent data processing and format adjustment. If you choose a pre-set standard template, you can load it directly. If you choose a user-written template, you need to design the template format and content according to the project requirements, then save it to a file format that the target software can recognize, and then load it.

[0039] In other budget preparation processes, if additional data needs to be imported or the budget preparation results need to be adjusted, users often need to manually modify the template content, which is cumbersome and error-prone, reducing work efficiency. In the above step S103, data can be filled according to the selected export template, which reduces manual intervention and errors and improves project management efficiency. In addition, users can customize the export template according to actual needs, including format, style, content, etc., so as to meet diverse reporting needs and improve the flexibility and customizability of data.

[0040] For example, Figure 2 As shown, the process of selecting and loading the corresponding export template can be as follows: (1) Signal acquisition: The main window obtains user operation instructions and sends signals to the main control.

[0041] (2) Basic data acquisition: The main control sends a signal to the model layer to pull the latest basic data.

[0042] (3) Export template reads rendering template: The main control instantiates a templated export module and writes the latest basic data into the export module. The export module reads the corresponding template from the hard disk and then renders the data in the basic data into the template.

[0043] (4) Complete storage: The template export module saves the rendered template data permanently to the hard disk.

[0044] Please continue reading Figure 1 , step S104: bind the budget preparation result data and the additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

[0045] After selecting and loading the corresponding export template, the data binding operation can then be performed according to the dynamic placeholder in the template. Through the flexible export template selection in step S103 and the data binding mechanism of the dynamic placeholder in step S104, the budget report can be set according to the actual needs of the project, thereby meeting the personalized requirements of different construction parties. Among them, the dynamic placeholder is a mark used to represent the variable or control structure list in the export template, which will be replaced with the actual static text or corresponding logical processing during the export process. For simple variable placeholders, they can be directly replaced with the corresponding numerical value or text information in the budget preparation result data. For example, the "{{Total project budget}}" placeholder in the export template may be replaced with a specific amount of money. For control structure list placeholders, such as loops or conditional judgment structures, traversal or judgment operations can be performed according to the preset logic, and the corresponding results can be filled into the export template. For another example, if the export template contains a list of multiple project sub-items, you can traverse and replace the placeholders in the list one by one according to the sub-item data in the budget preparation result data, generate a complete list of project sub-items, and finally save the generated document to the corresponding storage unit.

[0046] In summary, this application focuses on improving the accuracy, efficiency and flexibility of budget preparation, and optimizes the entire process from project information collection to final budget report generation through four closely linked steps. First, by accurately drawing engineering drawings and counting material requirements, a solid foundation is laid for subsequent budget preparation; second, by using regional specific communication engineering construction unit calculation plug-ins, budget preparation is ensured to comply with local actual conditions and laws and regulations; then, through flexible export template selection, the personalized needs of different projects are met; finally, through the automated data binding process, manual intervention is reduced and the efficiency of budget report generation is improved.

[0047] Specifically, by providing preset standard templates and user-defined templates, this application can flexibly adjust the budget preparation report according to the specific process of the project and the needs of the construction party, overcoming the limitations of fixed software formats. In addition, combined with the precise statistics of engineering drawings and the calculation plug-in of regional specific communication engineering construction units, the errors of manual estimation are reduced, and the introduction of automated tools significantly improves the speed and accuracy of budget preparation. In addition, the automated data binding and report generation process greatly reduces the workload of manual preparation of supporting documents and reduces errors and delays caused by human factors.

[0048] In some implementations of the present application, the step of binding the budget preparation result data to the dynamic placeholder in the export template includes: binding the budget preparation result data to the dynamic placeholder in the export template through an engine interface or function of the export template. The export template can be edited by the user in the original format of the exported electronic document or spreadsheet file, and the export template is decoupled from the budget preparation system.

[0049] In the above implementation, the binding of budget preparation result data and dynamic placeholders is realized by introducing the engine interface or function of the export template, which not only improves the automation and accuracy of budget preparation, but also enhances the flexibility and scalability of the budget report, providing more comprehensive and accurate information support for project decision-making.

[0050] Among them, when implementing this implementation method, first of all, it is necessary to design and define an export template containing dynamic placeholders according to the needs of the budget report. These dynamic placeholders are tags in the export template for subsequent data filling, and their positions and formats can be adjusted as needed. After the budget is prepared, the result data is organized into a format that the system can recognize, such as JSON, XML or database tables. These data contain various cost and expense information in the budget preparation process. Then, by calling the engine interface or function of the export template, the prepared budget preparation result data can be bound to the dynamic placeholders in the export template. This process is usually completed automatically by the template engine, which fills the corresponding data into the specified position of the export template according to the preset rules and logic. Finally, after completing the data binding, the template engine will generate the final budget report file. This file contains a visual presentation of the budget preparation result data, such as tables, charts, etc., which is convenient for decision makers or project teams to view and analyze.

[0051] Since the data binding and report generation process is automatically completed by the template engine, it reduces errors and omissions caused by improper human operation and improves the accuracy of the budget report. And when the project requirements change or new cost elements need to be added, you only need to adjust the export template or update the budget preparation result data to quickly generate a budget report that meets the requirements, reducing the system maintenance cost and expansion difficulty.

[0052] In some implementations of the present application, the step of binding the budget preparation result data to the dynamic placeholder in the export template is implemented through a rendering operation, which receives a dictionary containing key-value pairs as a parameter, the key corresponds to the placeholder name in the template, and the value corresponds to the data to be inserted.

[0053] In the above implementation, the format and content of the report can be easily adjusted by modifying the export template and data dictionary without modifying the underlying code. In addition, the design of separating templates and data makes the system more modular, easy to maintain and expand. At the same time, the rendering operation is usually fast and automated, which can greatly shorten the time of report generation.

[0054] Exemplarily, the process of the rendering operation may be as follows: 1. Preparation (1) Template definition: First, you need to define the export template. These templates can be documents in the format of spreadsheets or electronic documents. The template contains static content and dynamic placeholders (wrapped in curly brackets). The dynamic placeholders are used to insert data in the subsequent rendering process.

[0055] (2) Data preparation: At the same time, the data to be rendered needs to be prepared. This data usually comes from the results of real-time calculation of basic data in the software model layer (budget preparation result data) and additional imported data information, which will be used to replace dynamic placeholders in the export template.

[0056] 2. Rendering process (1) Loading templates: Using a template engine similar to the one used to render HTML, first load the predefined template file. The template engine will parse the structure of the template file and identify the static content and dynamic placeholders.

[0057] (2) Data binding: Bind the prepared data to the dynamic placeholders in the template through the template engine's interface or function. This is done through the rendering method, which receives a dictionary containing key-value pairs as a parameter, where the key corresponds to the placeholder name in the template and the value corresponds to the data to be inserted.

[0058] (3) Rendering generation: The template engine generates the final document content based on the bound data and the structure of the template. In this step, the dynamic placeholders in the template will be replaced by the corresponding data, while the static content remains unchanged.

[0059] (4) Output or save: After rendering is completed, the generated document content is saved to a file.

[0060] For example, the prepared electronic document template is as follows: Figure 3 As shown in the figure, the string inside the curly brackets accesses the data in the exported model and renders it into the value in the model with the same format. The rendered exported electronic document is as follows: Figure 4As shown. The export template not only supports the output of a single value, but also supports the output of a list using a loop. For example, {% for i in merged model.Table 3A.Total.Details%}{{ i.Quota number}}{% endfor %} can traverse Table 3A and render all quota numbers into the template. All rendered text will retain the original format.

[0061] It should be noted that Figure 3 The "proVar" that appears in the figure is the abbreviation of project parameters, "volStatus" is the volume status, "|" is the channel operation symbol, which means that the result of the previous operation is placed in the parameter of the next operation, and the "." symbol indicates the call method or property. The curly braces are wrapped in dynamic placeholders, which are automatically replaced with corresponding values ​​after the system is running.

[0062] Among them, the dynamic placeholder "Merged model.volStatus.Table 4A Main Materials.values()" means getting the key value of "Table 4A Main Materials" under "volStatus (volume status)" under the "Merged model" key value, and then calling the values ​​function of this value to get its value.

[0063] Similarly, the dynamic placeholder "Merge model.volStatus.Table 4A main materials.values()|map(attribute='Total.Price minus tax')|sum-Merge model.Table 1.Total.Recycling costs.Price minus tax" means to obtain all the values ​​of "Merge model.volStatus.Table 4A main materials" and then pass them into the "map function" to extract only the value of "Price minus tax" under the "Total" key, and then pass the result into the following "sum function" for summing, and finally obtain the value of the price minus tax of all material costs in "Material A" and Table 4A main materials. Among them, attribute is a parameter of the map function.

[0064] Example 2 See also Figure 5 The present application embodiment provides a communication project budget preparation system, which includes: The data acquisition module is used to draw engineering drawings according to project-related information, and to count the required engineering materials and their quantities based on the drawn engineering drawings; the budget preparation module is used to select the corresponding communication engineering construction unit calculation plug-in for budget preparation according to the project area, so as to obtain the corresponding budget preparation result data; the selection and loading module is used to select and load the corresponding export template according to the specific process of the project and the needs of the builder, and the export template includes a preset standard template and a template written by the user; the report generation module is used to bind the budget preparation result data and the additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

[0065] For the specific implementation process of the above system, please refer to the budget preparation method for a communication project provided in Example 1, which will not be repeated here. It should be noted that for users who need customized functions, the existing systems often lack portable plug-in writing interfaces and tool support, resulting in high customized development costs and long cycles. At the same time, the existing systems all rely on specific software platforms and are highly coupled to specific commercial electronic spreadsheets or document processing software, which limits the flexibility and compatibility of the system and makes users lack freedom in software selection. The budget preparation system for the communication project of the present application can reduce the dependence on specific commercial electronic documents and electronic spreadsheet software, and by providing an open data interface and a standardized data exchange format, the system can be compatible with a variety of different electronic document processing software. Such a design allows users to choose the most suitable tool according to their preferences and needs without being restricted by specific software platforms or operating systems.

[0066] like Figure 6 As shown, in some implementations of the present application, the architecture of the system includes: a model layer, used to store and process budget preparation result data; a control layer, used to receive user instructions and coordinate data interaction between the model layer and the view layer; and a view layer, used to display the budget preparation results and the user interaction interface.

[0067] In the above implementation, the system adopts a three-layer architecture model of model layer (Model), control layer (Controller) and view layer (View), which helps to achieve high cohesion and low coupling of the code and improve the maintainability and scalability of the system.

[0068] Among them, the model layer will store various data for budget preparation, such as budget items, budget amounts, budget allocation rules, etc. It will also process these data, such as performing budget calculations, verifying data integrity, and performing data updates. The control layer is a bridge between the model layer and the view layer. It is responsible for receiving instructions issued by users through the view layer (such as clicking buttons, submitting forms, etc.), and then calling relevant methods of the model layer to process these instructions, and returning the processing results to the view layer for display. The control layer does not directly process data or display data directly. It is mainly responsible for the flow of data and the forwarding of instructions. Through the control layer, unified processing of user requests can be achieved to improve the response speed and stability of the system. The view layer is the interface for users to interact with the system. It is responsible for displaying the results of budget preparation and the user interaction interface. In the budget preparation system, the view layer can display budget tables, charts, reports, etc., and provide interfaces for users to input data, such as text boxes, drop-down lists, buttons, etc. The view layer is usually related to the user's direct experience, so it needs to have a good user experience and visual effects. At the same time, the view layer also needs to work closely with the control layer to accurately display the results of user requests and process the data entered by users.

[0069] In other words, by adopting a modular (model, control, view separation) architecture, the system has strong scalability, and users can flexibly compile various plug-ins according to different application scenarios and the requirements of communication engineering construction units to adapt to the changing budget preparation needs. This design not only reduces the maintenance cost of the system, but also greatly improves its applicability and market competitiveness.

[0070] It should be noted that if Figure 6 As shown, the view layer can include basic component modules (including various basic data display windows), menu modules, sub-window modules, pop-up window modules and main window modules. The menu module is used for various menu displays, a sub-volume in the sub-window module has a sub-window, the pop-up window module is used for interactive pop-ups of various services, and a project in the main window module and a main program loop have only one main window, which determines which plug-in to use.

[0071] The control layer may include a main control module and plug-ins, wherein the main control module is used to update data and interfaces, and the plug-ins are used to write plug-in modules adapted to different budget preparation methods.

[0072] The model layer may include a database module, a rate conversion module, a basic data module, a quota library module, a Decimal module, a read-write module, an add-delete-modify-check module, a modular export module, and a calculator module. Among them, the database module is used to store the read-write quota library, the rate library, and the service fee rate library; the rate conversion module is used to convert the rate into a data structure that matches the basic data module; the basic data module is used to define the data structure and read-write of the basic data in the memory; the quota library module is used to convert and filter the quota data read and written in the database; the Decimal module is used to adapt the floating point class of the precision of the communication budget calculation; the read-write module is used to write the basic data to the disk or import the disk data into the memory; the add-delete-modify-check module is used for the add-delete-modify-check of the basic data; the modular export module is used for the import of custom data and the modular export of data segments; the calculator module is used for data calculation after the basic data is updated.

[0073] Example 3 See also Figure 7 , the embodiment of the present application provides an electronic device, the electronic device includes at least one processor 201 and at least one memory 202; wherein the processor 201 and the memory 202 are directly connected to each other, or communicate with each other through a communication interface 203, or are electrically connected through one or more communication buses or signal lines to achieve data transmission or interaction; the memory 202 stores program instructions that can be executed by the processor 201, and the processor 201 calls the program instructions to execute a method for budgeting a communication project. For example, the following is implemented: Draw engineering drawings based on project-related information, and count the required engineering materials and their quantities based on the drawn engineering drawings; select the corresponding communication engineering construction unit calculation plug-in to prepare the budget according to the project area, so as to obtain the corresponding budget preparation result data; select and load the corresponding export template according to the specific process of the project and the needs of the builder, and the export template includes preset standard templates and user-written templates; bind the budget preparation result data and additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

[0074] Among them, the memory 202 can be, but is not limited to, a random access memory (RAM), a read only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable read-only memory (EEPROM), etc.

[0075] The processor 201 may be an integrated circuit chip with signal processing capability. The processor 201 may be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it may also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.

[0076] Understandably, Figure 7 The structure shown is for illustration only. The electronic device may also include Figure 7 More or fewer components as shown, or with Figure 7 Different configurations are shown. Figure 7 Each component shown in the figure can be implemented by hardware, software or a combination thereof.

[0077] Example 4 The present application provides a computer-readable storage medium having a computer program stored thereon, which implements a method for budgeting a communication project when executed by a processor 201. For example, the following methods are implemented: Draw engineering drawings based on project-related information, and count the required engineering materials and their quantities based on the drawn engineering drawings; select the corresponding communication engineering construction unit calculation plug-in to prepare the budget according to the project area, so as to obtain the corresponding budget preparation result data; select and load the corresponding export template according to the specific process of the project and the needs of the builder, and the export template includes preset standard templates and user-written templates; bind the budget preparation result data and additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

[0078] If the above functions are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, and other media that can store program codes.

[0079] It will be apparent to those skilled in the art that the present application is not limited to the details of the exemplary embodiments described above, and that the present application can be implemented in other specific forms without departing from the spirit or essential features of the present application. Therefore, the embodiments should be considered exemplary and non-limiting in all respects, and the scope of the present application is defined by the appended claims rather than the above description, and it is intended that all changes falling within the meaning and scope of the equivalent elements of the claims be included in the present application. Any reference numeral in a claim should not be considered as limiting the claim to which it relates.

Claims

1. A method for preparing a budget for a communication project, characterized in that: The following steps are involved: Draw engineering drawings based on project-related information, and count the required engineering materials and their quantities based on the drawn engineering drawings; According to the project location, select the corresponding communication engineering construction unit calculation plug-in to prepare the budget to obtain the corresponding budget preparation result data; According to the specific process of the project and the needs of the builder, select and load the corresponding export template, which includes preset standard templates and user-written templates; The budget preparation result data and the additional imported data are bound to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

2. The method according to claim 1, characterized in that When selecting the corresponding communication engineering construction unit calculation plug-in for budget preparation, it also includes adjusting the quota association and adjusting the price of engineering materials according to market price fluctuations.

3. The method according to claim 1, characterized in that The export template is in the format of an electronic document or a spreadsheet file.

4. The method according to claim 1, characterized in that: The step of binding the budget preparation result data to the dynamic placeholder in the export template includes: binding the budget preparation result data to the dynamic placeholder in the export template through the engine interface or function of the export template.

5. The method according to claim 1, characterized in that The step of binding the budget preparation result data to the dynamic placeholder in the export template is implemented by a rendering operation, which receives a dictionary containing key-value pairs as a parameter, the key corresponding to the placeholder name in the template, and the value corresponding to the data to be inserted.

6. The method according to claim 1, characterized in that The dynamic placeholder is a marker used to represent a variable or a control structure list in the export template, and will be replaced by actual static text or undergo corresponding logical processing during the export process.

7. A budget preparation system for a communication project, characterized in that: include: The data acquisition module is used to draw engineering drawings according to project-related information and to count the required engineering materials and their quantities according to the drawn engineering drawings; The budget preparation module is used to select the corresponding communication engineering construction unit calculation plug-in for budget preparation according to the project location to obtain the corresponding budget preparation result data; A selection and loading module is used to select and load the corresponding export template according to the specific process of the project and the needs of the builder. The export template includes a preset standard template and a template written by the user; The report generation module is used to bind the budget preparation result data and additional imported data to the corresponding dynamic placeholders in the export template to obtain the corresponding budget report file.

8. The system according to claim 7, characterized in that The architecture of the system includes: Model layer, used to store and process budget preparation result data; The control layer is used to receive user instructions and coordinate data interaction between the model layer and the view layer; The view layer is used to display the budget preparation results and the user interaction interface.

9. An electronic device, characterized in that: include: A memory for storing one or more programs; processor; When the one or more programs are executed by the processor, the method according to any one of claims 1 to 6 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

Images