Engineering project cost management and control system

Abstract

The invention discloses an engineering project cost management and control system, and relates to the technical field of engineering management. The system comprises a hierarchical form and a hierarchical form data analysis tool, the hierarchical form is designed on the basis of a code-free form engine and a rule engine and supports a form for engineering management and control, the hierarchical form is a form structure used for representing the hierarchical relation / father-son relation of data in the form, and the hierarchical form data analysis tool is used for analyzing the hierarchical relation / father-son relation of the data in the form. The hierarchical form data analysis tool comprises a data capture and integration module, a data analysis module and a data visualization module which are in communication connection in sequence, through the design of the hierarchical form and the analysis tool, the data of the hierarchical form can be utilized, powerful data analysis and visualization ability can be provided, a user is helped to deeply analyze engineering cost data, and the user experience is improved. And a more accurate decision is made, so that the problems that the engineering cost management and control granularity is not fine and the management and control analysis is not deep enough when an existing engineering project cost management and control scheme faces a large-scale engineering project can be solved.

Description

Technical Field

[0001] The present invention belongs to the technical field of engineering management, and in particular relates to an engineering project cost control system. Background Art

[0002] Project cost control refers to a series of management activities to plan, control, calculate, analyze and report various project costs throughout the life cycle of the project. Its purpose is to ensure that the project is completed on time within the budget and achieves the predetermined quality and functional goals.

[0003] The existing cost control business of engineering projects mainly uses cost software such as Glodon, Swire or Xindian to produce bills of quantities, and make payment settlements according to the construction progress and bills of quantities throughout the life cycle of the engineering project. However, when dealing with large-scale engineering projects, due to the large scale of the project and the large number of participants, cost control will face the following situations:

[0004] (1) There are many contracts and subcontractors. On the one hand, since large projects usually involve multiple contracts and subcontractors, the complexity of contract management increases. It is necessary to classify and track different contracts to ensure that the execution of each contract is in line with the project plan. On the other hand, coordination and communication between different subcontractors is also an important issue. The lack of an effective coordination mechanism can easily lead to information asymmetry and execution deviation.

[0005] (2) Difficult approval process. On the one hand, the approval process for large projects is usually complicated, involving multiple departments and levels. It requires multiple approvals and signature confirmations, which can easily lead to long approval cycles and low efficiency. On the other hand, during the approval process, the flow and feedback of information are slow, which can easily cause approval delays and affect the overall progress of the project.

[0006] (3) Difficulty in collaboration. On the one hand, in large projects, multiple parties such as owners, general contractors, subcontractors and supervisors need to work together, and there is a lack of a unified platform and tools for information sharing and collaboration, which can easily lead to poor communication and information silos. On the other hand, the data formats and standards of different systems and platforms are not unified, which makes it difficult to share and integrate data, affecting the collaborative effect.

[0007] (4) Information flow is slow. On the one hand, real-time information from the project site cannot be transmitted to the management in a timely manner, resulting in the management being unable to grasp the project dynamics in real time, which affects the timeliness and accuracy of decision-making. On the other hand, there is a lack of effective interconnection mechanism between various information systems, resulting in slow information flow and untimely data transmission and feedback.

[0008] Due to the above situation, cost control of large projects faces the following problems:

[0009] (1) Cost control is not timely. On the one hand, the actual cost data incurred on site is difficult to obtain and feedback in a timely manner, resulting in untimely cost monitoring and control, which is prone to cost overruns. On the other hand, due to delays in the approval process and payment settlement, cost settlement and control cannot be carried out in a timely manner, affecting the project's capital flow and progress.

[0010] (2) Cost control is not sophisticated. On the one hand, there is a lack of in-depth analysis of cost data, which makes it impossible to detect and correct cost deviations in a timely manner, affecting the effectiveness of cost control. On the other hand, due to the lag and incompleteness of data, the accuracy of cost forecasts is low, making it difficult to provide effective decision support. Summary of the invention

[0011] The purpose of the present invention is to provide a project cost control system to solve the problems of the existing project cost control schemes in the face of large-scale projects, such as the lack of fine granularity of project cost control and the lack of in-depth analysis of project cost control.

[0012] In order to achieve the above object, the present invention adopts the following technical solutions:

[0013] In a first aspect, a system for cost control of engineering projects is provided, comprising a hierarchical form designed based on a codeless form engine and a rule engine and supporting a form for engineering control, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure for representing a hierarchical relationship / parent-child relationship of data in a form, and displaying data input items of multiple hierarchical data in a nested form to facilitate data input and management by users, and the hierarchical form data analysis tool comprises a data capture and integration module, a data analysis module, and a data visualization module which are sequentially connected in communication;

[0014] The data capture and integration module includes a data capture unit and a data integration unit, wherein the data capture unit is used to automatically capture the data in the hierarchical form and including data information of all levels, and the data integration unit is used to integrate data of different levels to form a unified data set to be analyzed;

[0015] The data analysis module includes a multi-dimensional analysis unit, an aggregation calculation unit and / or a trend analysis unit, wherein the multi-dimensional analysis unit is used to perform non-cross analysis of different dimensions and / or cross analysis of any combination of dimensions on the data set to be analyzed to obtain a first analysis result, the aggregation calculation unit is used to perform statistical analysis of any aggregation calculation method on the data set to be analyzed to obtain a second analysis result, and the trend analysis unit is used to perform time series analysis on the data set to be analyzed to obtain a third analysis result including a historical change trend of the project cost and / or a predicted future change trend of the project cost;

[0016] The data visualization module includes a chart display unit and a hierarchical display unit, wherein the chart display unit is used to intuitively display the analysis results from the data analysis module in any chart type, and the hierarchical display unit is used to display the hierarchical relationship in the hierarchical form and the data information of each hierarchy.

[0017] Based on the above invention content, a new solution for engineering project cost control suitable for large-scale engineering projects is provided, namely, a hierarchical form designed based on a codeless form engine and a rule engine and supporting forms for engineering control, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure used to represent the hierarchical relationship / parent-child relationship of data in a form, and displays data input items of multiple hierarchical data in a nested form to facilitate users to input and manage data, and the hierarchical form data analysis tool includes a data capture and integration module, a data analysis module and a data visualization module that are sequentially communicated and connected. Through the design of the aforementioned hierarchical form and analysis tool, the data of the hierarchical form can be used to provide powerful data analysis and visualization capabilities, helping users to deeply analyze engineering cost data and make more accurate decisions, thereby solving the problems of the existing engineering project cost control scheme having a loose granularity of engineering cost control and insufficient in-depth analysis of engineering cost control when facing large-scale engineering projects, and facilitating practical application and promotion.

[0018] In a possible design, the engineering control form includes an engineering estimate form, an engineering quantity form and / or a payment form in engineering project cost control.

[0019] In one possible design, the codeless form engine includes a user interface design module and a data management module;

[0020] The user interface design module includes a drag-and-drop editor and / or a preset template unit, wherein the drag-and-drop editor is used to respond to the user's human-computer interaction operation and design the application interface by dragging and dropping UI components, wherein the UI components include buttons, text boxes, forms, pictures and / or charts and allow the user to customize the component style, and the preset template unit is used to provide a variety of preset templates of the application interface for the user to select and customize;

[0021] The data management module includes a database integration unit, a data binding unit and a data import and export unit, wherein the database integration unit is used to support users to create and manage database tables, and support users to define data fields and data types, the data binding unit is used to bind UI components to the database to realize data display and operation, and the data import and export unit is used to support importing data from the outside or exporting data to files.

[0022] In a possible design, the rule engine includes a business logic automation module and an analysis report module;

[0023] The business logic automation module includes a conditional logic unit, a workflow automation unit and a function and expression unit, wherein the conditional logic unit is used to configure a conditional trigger in response to a user's human-computer interaction operation so that the conditional trigger performs a corresponding operation according to the configured condition, the workflow automation unit is used for the user to design and manage business process automation, and the function and expression unit is used to use built-in functions and / or expressions to process data and / or implement processing logic;

[0024] The analysis report module includes a real-time analysis unit, a custom report unit and / or a data visualization unit, wherein the real-time analysis unit is used to provide real-time data analysis functions and monitor the usage and performance of the application, the custom report unit is used to generate custom reports and analyze key business indicators and / or user behaviors, and the data visualization unit is used to use chart tools and / or dashboard tools to visualize data so as to provide intuitive data insight functions.

[0025] In a possible design, the codeless form engine or the rule engine further includes an integration and extension module, a user management module, a deployment and publishing module and / or a collaboration and team management module;

[0026] The integration and extension module includes a third-party service integration unit, an API connection unit and / or a plug-in and extension unit, wherein the third-party service integration unit is used to integrate third-party services, the API connection unit is used to support connection to external services / systems through an API interface to achieve data exchange and / or function extension, and the plug-in and extension unit is used to support the use of plug-ins and / or extensions to enhance application functions;

[0027] The user management module includes a user authentication unit, a role and permission management unit and / or a user activity tracking unit, wherein the user authentication unit is used to provide user registration function, user login function and user password reset function, and supports multiple authentication methods, the role and permission management unit is used to define the roles and permissions of different users, and control the user's access rights to application functions and data, and the user activity tracking unit is used to record the user's activities in the application, and analyze and optimize them;

[0028] The deployment and release module includes a one-click deployment unit, a version management unit and / or a multi-platform support unit, wherein the one-click deployment unit is used to support one-click release of the application to the platform, the version management unit is used to manage different versions of the application and support version rollback and update release, and the multi-platform support unit is used to support the release of the application to multiple platforms;

[0029] The collaboration and team management module includes a team collaboration unit and a permission allocation unit, wherein the team collaboration unit is used to support multiple users to jointly edit and manage the same engineering project, and the permission allocation unit is used to assign different roles and permissions to each team member, and control each team member's access and modification permissions to the engineering project.

[0030] In a possible design, the hierarchical form includes a form item configuration module, a hierarchical management module, a data operation module, an automated workflow module, and a user authority management module;

[0031] The form item configuration module is used to support various types of form items and enable each form item to be configured with basic attributes, wherein the basic attributes include validation rules, default values ​​and / or placeholders;

[0032] The hierarchical management module is used to enable users to manage the hierarchical structure of the form through a visual tool, and supports unlimited levels of nesting;

[0033] The data operation module is used to support the integration of form data with subsequent databases or external APIs, realize data storage and synchronization, and provide data import and export functions so that users can perform batch operations on data;

[0034] The automated workflow module is used to implement automated processing after form submission through conditional logic and triggers;

[0035] The user authority management module is used to support user authority management so that different users can access and operate different parts of the form according to their authority, and provides role and authority settings to ensure data security and access control.

[0036] In a possible design, the user construction method of the hierarchical form includes the following steps:

[0037] Select Create Hierarchical Form Template;

[0038] Create a form hierarchy and form fields based on the hierarchical form template;

[0039] For the form level, drag the field control to create a corresponding form template;

[0040] marking the hierarchical relationship of the hierarchical data regions in the form templates for each pair of said form hierarchies;

[0041] External Excel data is input or imported, and hierarchical data recognition processing is performed on the external Excel data to obtain form data of the hierarchical form.

[0042] In a possible design, external Excel data is imported, and hierarchical data recognition processing is performed on the external Excel data to obtain form data of the hierarchical form, including:

[0043] The user front end responds to the first human-computer interaction operation of the user to select an import file containing external Excel data;

[0044] The user front end responds to the second human-computer interaction operation of the user to configure the identification rule, and transmits the identification rule to the form server;

[0045] The form server verifies whether the form template exists, and if it is determined to exist, verifies whether the import parameters of the import file are legal. If they are legal, the identification rule is transmitted to the parsing server;

[0046] The parsing server parses the imported configuration content in the identification rule to obtain the hierarchical identification configuration content;

[0047] The parsing server parses the imported file based on a stacked hierarchical tree construction algorithm to obtain row-level form data;

[0048] The parsing server constructs hierarchical form relationships for each pair of the row-level form data according to the hierarchical identification configuration content using a hierarchical adjusted tree structure compression algorithm, obtains hierarchical data and returns it to the form server;

[0049] The form server parses the hierarchical data into field data with the help of a hierarchical report field parsing and mapping converter, obtains the form data of the hierarchical form and returns it to the user front end.

[0050] In a possible design, the hierarchical form data analysis tool further includes a report generation module, a user interaction and collaboration module and / or a security and authority management module;

[0051] The report generation module includes a custom report unit and / or an automated report unit, wherein the custom report unit is used to generate a personalized analysis report based on the data and charts selected by the user, and provides a variety of report templates to help users create standardized reports, and the automated report unit is used to send the analysis results to relevant personnel regularly according to a preset time, and supports exporting in multiple formats for sharing and archiving;

[0052] The user interaction and collaboration module includes an interactive analysis unit and / or a multi-user collaboration unit, wherein the interactive analysis unit is used to provide an interactive data analysis tool for users to dynamically adjust the analysis view and data range through human-computer interaction and supports the drill-down function, and the multi-user collaboration unit is used to support multiple users to view and edit data analysis results at the same time and provide comment and annotation functions so that users can add annotations to reports and charts to achieve discussion and record;

[0053] The security and permission management module includes a data security unit and a permission management unit, wherein the data security unit is used to encrypt transmission and / or encrypt storage of all data using encryption technology, and to regularly back up data, and the permission management unit is used to control user access rights to data and / or analysis tools based on role-based permission management, so that users can view and / or operate corresponding data and / or analysis results according to their permissions, thereby ensuring data privacy and security.

[0054] In a possible design, the data visualization module also includes a real-time update unit, wherein the real-time update unit is used to enable the chart display unit and / or the hierarchy display unit to refresh display data in real time and supports dynamic refresh and automatic refresh.

[0055] Beneficial effects of the above scheme:

[0056] (1) The present invention provides a new project cost control scheme applicable to large-scale engineering projects, namely, a hierarchical form designed based on a codeless form engine and a rule engine and supporting forms for engineering control, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure used to represent the hierarchical relationship / parent-child relationship of data in a form, and displays data input items of multiple hierarchical data in a nested form to facilitate data input and management by users, and the hierarchical form data analysis tool includes a data capture and integration module, a data analysis module and a data visualization module that are sequentially connected in communication. Through the design of the aforementioned hierarchical form and analysis tool, the data of the hierarchical form can be used to provide powerful data analysis and visualization capabilities, helping users to deeply analyze engineering cost data and make more accurate decisions, thereby solving the problems of the existing engineering cost control schemes having a loose granularity of engineering cost control and insufficient in-depth analysis of engineering cost control when facing large-scale engineering projects, and facilitating practical application and promotion;

[0057] (2) Through the design of specific functional modules of the codeless form engine and the rule engine, the existing engineering project cost control solutions can solve the problems of multi-unit collaboration and approval flow difficulties in large-scale engineering projects;

[0058] (3) It can also lower the development threshold, improve development efficiency, enhance business flexibility, and improve cross-team collaboration efficiency;

[0059] (4) It can also support parsing complex tables such as engineering cost estimates, bills of quantities, and payment tables into hierarchical structured data, and support the full business process scenario of engineering cost control;

[0060] (5) It can also provide real-time feedback and analysis, and support multi-platform publishing and one-click deployment of forms designed based on the form engine and rule engine. BRIEF DESCRIPTION OF THE DRAWINGS

[0061] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0062] Figure 1 A schematic diagram of the structure of the engineering project cost control system provided in the embodiment of the present application. DETAILED DESCRIPTION

[0063] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in combination with the drawings and the description of the embodiments or the prior art. Obviously, the following description of the structures of the drawings is only some embodiments of the present invention. For ordinary technicians in this field, other embodiments can be obtained based on these embodiments without creative work. It should be noted that the description of these embodiments is used to help understand the present invention, but does not constitute a limitation of the present invention.

[0064] It should be understood that although the terms first and second, etc. may be used herein to describe various objects, these objects should not be limited by these terms. These terms are only used to distinguish one object from another object. For example, a first object can be referred to as a second object, and similarly, a second object can be referred to as a first object without departing from the scope of the exemplary embodiments of the present invention.

[0065] It should be understood that the term "and / or" that may appear in this document is merely a description of the association relationship between associated objects, indicating that there may be three relationships. For example, A and / or B can indicate three situations: A exists alone, B exists alone, or A and B exist at the same time. For another example, A, B and / or C can indicate the existence of any one of A, B and C or any combination of them. The term " / and" that may appear in this document describes another type of association object relationship, indicating that there may be two relationships. For example, A / and B can indicate two situations: A exists alone or A and B exist at the same time. In addition, the character " / " that may appear in this document generally indicates that the previous and next associated objects are in an "or" relationship.

[0066] Example

[0067] like Figure 1 As shown, the engineering project cost control system provided by this embodiment includes but is not limited to hierarchical forms designed based on a codeless form engine and a rule engine and supporting engineering control forms, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure used to represent the hierarchical relationship / parent-child relationship of data in a form, and to display data input items of multiple hierarchical data in a nested form to facilitate user data input and management. Specifically, the aforementioned engineering control forms include but are not limited to engineering budget forms, engineering quantity forms and / or payment forms in engineering project cost control.

[0068] The no-code form engine and the rule engine are used to provide non-technical personnel with an easy way to create and manage applications, and support a series of functions to meet the needs of different types of users, wherein the no-code form engine is a pure no-code form engine product (it is a tool for processing and validating form data, which can help developers simplify the form creation, validation and submission process; it usually provides some ready-made tools and methods to process various elements in the form such as text boxes, drop-down lists, radio buttons, etc.); the rule engine is a software component that allows non-programmers to add or change the business logic in the business process management (Business Process Management, BPM) system (its core concepts include rules, facts, workflows and knowledge bases, etc., which have different meanings and functions in the rule engine).

[0069] In view of the problems of multi-unit collaboration and approval flow difficulties in existing engineering project cost control solutions when facing large projects, preferably, the codeless form engine can be designed to include but not limited to a user interface design module and a data management module; the user interface design module includes but is not limited to a drag-and-drop editor and / or a preset template unit, wherein the drag-and-drop editor is used to respond to the user's human-computer interaction operations and design the application interface by dragging and dropping UI (User Interface) components, and the UI components include but are not limited to buttons, text boxes, forms, pictures and / or charts, etc., and allow users to customize the component style (for example, modify the component's color, font and / or layout, etc. to meet brand or design requirements), the The preset template unit is used to provide a variety of preset templates of the application interface for users to choose from / and make customized modifications (that is, the user selects a preset template, or the user selects a preset template and makes customized modifications to the preset template); the data management module includes but is not limited to a database integration unit, a data binding unit, and a data import and export unit, wherein the database integration unit is used to support users to create and manage database tables, and support users to define data fields and data types, the data binding unit is used to bind UI components to the database to realize data display and operation, and the data import and export unit is used to support importing data from the outside or exporting data to files (for example, exporting to files in formats such as CSV or Excel).In addition, in order to realize the basic capabilities of the engine, the codeless form engine is also designed to include but is not limited to an integration and extension module, a user management module, a deployment and release module and / or a collaboration and team management module; the integration and extension module includes but is not limited to a third-party service integration unit, an API (Application Programming Interface), and a third-party service integration unit. The third-party service integration unit is used to integrate third-party services (such as DingTalk message push, email service and WeChat message push services), the API connection unit is used to support connection to external services / systems through the API interface to achieve data exchange and / or function expansion, and the plug-in and extension unit is used to support the use of plug-ins and / or extensions (such as chart libraries and / or analysis tools, etc.) to enhance application functions; the user management module includes but is not limited to a user authentication unit, a role and permission management unit and / or a user activity tracking unit, etc., wherein the user authentication unit is used to provide user registration function, user login function and user password reset function, and supports multiple authentication methods (such as email authentication method and / or mobile phone number authentication method, etc.), and the role and permission management unit is used to define the roles and permissions of different users and control user access to application functions and data. Permissions, the user activity tracking unit is used to record the user's activities in the application, and analyze and optimize them; the deployment and release module includes but is not limited to a one-click deployment unit, a version management unit and / or a multi-platform support unit, etc., wherein the one-click deployment unit is used to support one-click release of the application to a platform (such as Web, mobile or other platforms), the version management unit is used to manage different versions of the application, and supports version rollback and update release, and the multi-platform support unit is used to support the release of the application to multiple platforms (such as Web applications, iOS and Android mobile applications, etc.); the collaboration and team management module includes but is not limited to a team collaboration unit and a permission allocation unit, etc., wherein the team collaboration unit is used to support multiple users to jointly edit and manage the same project (that is, it can improve the efficiency of team collaboration), and the permission allocation unit is used to assign different roles and permissions to each team member, and control the access and modification permissions of each team member to the project.

[0070] In view of the problems of multi-unit collaboration and approval flow difficulties in existing engineering project cost control solutions when facing large projects, preferably, the rule engine can be designed to include but not limited to business logic automation modules and analysis report modules; the business logic automation module includes but is not limited to conditional logic units, workflow automation units, and function and expression units, wherein the conditional logic unit is used to respond to the user's human-computer interaction operation to configure conditional triggers, so that the conditional triggers perform corresponding operations according to the configured conditions (such as sending notifications and / or updating data, etc.), and the workflow automation unit is used for users to design and manage business processes (such as approval processes and / or order processing). The function and expression unit is used to use built-in functions and / or expressions to process data and / or implement processing logic (for example, to implement complex logic such as automatic aggregation and summation / automatic filtering according to set conditions); the analysis report module includes but is not limited to a real-time analysis unit, a custom report unit and / or a data visualization unit, etc., wherein the real-time analysis unit is used to provide real-time data analysis functions and monitor the usage and performance of the application, the custom report unit is used to generate custom reports and analyze key business indicators and / or user behaviors, and the data visualization unit is used to use chart tools and / or dashboard tools for data visualization to provide intuitive data insight functions. In addition, in order to realize the basic capabilities of the engine, specifically, the rule engine is also designed to include but is not limited to the integration and extension module, the user management module, the deployment and release module and / or the collaboration and team management module, etc.

[0071] The hierarchical form is developed based on the codeless form engine, that is, it supports configuring form templates through the codeless form engine, and can add or import external data in the instance, etc. In view of the problem that the existing engineering project cost control scheme has insufficient granularity in engineering cost control when facing large projects, preferably, the hierarchical form is designed to include but not limited to a form item configuration module, a hierarchical management module, a data operation module, an automated workflow module and a user authority management module, etc.; the form item configuration module is used to support various types of form items (such as text boxes, drop-down menus, check boxes and / or date selectors, etc.), and enable each form item to be configured with basic attributes, wherein the basic attributes include but are not limited to validation rules, default values ​​and / or placeholders, etc.; the hierarchical management module is used to enable users to manage (for example, add, delete) through visual tools. or moving form levels, etc.), and supports unlimited nesting (that is, to meet the needs of complex data structures); the data operation module is used to support the integration of form data with subsequent databases or external APIs, realize data storage and synchronization, and provide data import and export functions so that users can perform batch operations on data; the automated workflow module is used to realize automated processing after form submission (such as sending notifications or updating data, etc.) through conditional logic and triggers; the user authority management module is used to support user authority management so that different users can access and operate different parts of the form according to their authority, and provide role and authority settings to ensure data security and access control.

[0072] In view of the problem that the existing engineering project cost control schemes are not in-depth enough in the analysis of engineering cost control when facing large projects, the hierarchical form data analysis tool aims to use the data of the hierarchical form to provide powerful data analysis and visualization capabilities to help users deeply analyze engineering cost data and make more accurate decisions. Specifically, the hierarchical form data analysis tool includes but is not limited to a data capture and integration module, a data analysis module, and a data visualization module that are sequentially connected in communication.

[0073] The data capture and integration module includes but is not limited to a data capture unit and a data integration unit, wherein the data capture unit is used to automatically capture the data in the hierarchical form and contains all hierarchical data information, and the data integration unit is used to integrate the data at different levels to form a unified data set to be analyzed. In addition, the data capture unit is also used to support the capture of data from different sources (such as a project management system or an enterprise resource planning ERP system, etc.) to achieve data integration; and the data integration unit is also used to support the cleaning and correction of incomplete data or abnormal data to ensure the accuracy of the data.

[0074] The data analysis module includes but is not limited to a multi-dimensional analysis unit, an aggregation calculation unit and / or a trend analysis unit, etc., wherein the multi-dimensional analysis unit is used to perform non-cross analysis of different dimensions (such as time dimension, project dimension or cost dimension, etc.) and / or cross analysis of any dimensional combination (such as time dimension and project dimension, time dimension and cost dimension or project dimension and cost dimension, etc.) on the data set to be analyzed (the cross analysis is used to facilitate users to discover hidden associations and trends) to obtain a first analysis result, the aggregation calculation unit is used to perform statistical analysis of the data set to be analyzed in any aggregation calculation method (such as summing, averaging, maximum value, minimum value or custom calculation formula that meets the user's special analysis needs, etc., to help users perform statistical analysis on the data) to obtain a second analysis result, and the trend analysis unit is used to perform time series analysis on the data set to be analyzed (such as using a long short-term memory network for time series analysis) to obtain a third analysis result including a historical change trend of engineering project costs (which can help users understand the change trend of engineering costs) and / or a predicted future change trend of engineering project costs (which can help users estimate future cost changes).

[0075] The data visualization module includes but is not limited to a chart display unit and a hierarchical display unit, wherein the chart display unit is used to intuitively display the analysis results from the data analysis module in any chart type (such as a bar chart, a line chart, a pie chart and / or an area chart, etc.), and the hierarchical display unit is used to display the hierarchical relationship in the hierarchical form and the data information of each level. In addition, the chart display unit is also used to support custom dashboards, so that users can display multiple charts and data on one interface to form a comprehensive visual view; the hierarchical display unit is also used to support expanding and collapsing hierarchies, so that users can view data details at different levels as needed; the data visualization module also includes a real-time update unit, wherein the real-time update unit is used to enable the chart display unit and / or the hierarchical display unit to refresh the displayed data in real time, and supports dynamic refresh and automatic refresh, which can ensure that the user always sees the latest data without manual operation by the user.

[0076] Based on the aforementioned project cost control system, a new project cost control scheme suitable for large-scale projects is provided, namely, a hierarchical form based on a codeless form engine and a rule engine design and supporting a form for project control, and a hierarchical form data analysis tool based on a codeless form engine, wherein a hierarchical form refers to a form structure used to represent a hierarchical relationship / parent-child relationship of data in a form, and to display data input items of multiple hierarchical data in a nested form so that users can input and manage data, and a hierarchical form data analysis tool includes a data capture and integration module, a data analysis module, and a data visualization module that are sequentially connected in communication. Through the design of the aforementioned hierarchical form and analysis tool, the data of the hierarchical form can be used to provide powerful data analysis and visualization capabilities, helping users to deeply analyze project cost data and make more accurate decisions, thereby solving the problems of the existing project cost control scheme in the face of large-scale projects, such as the lack of fine granularity of project cost control and the lack of in-depth analysis of project cost control, and facilitating practical application and promotion. In addition, the specific functional module design of the codeless form engine and the rule engine can also solve the problems of multi-unit collaborative work and approval flow difficulties in the existing project cost control scheme in the face of large-scale projects.

[0077] Preferably, the user construction method of the hierarchical form specifically includes but is not limited to the following steps S1 to S5.

[0078] S1. Choose Create Hierarchical Form Template.

[0079] S2. Create a form hierarchy and form fields based on the hierarchical form template.

[0080] S3. For the form level, drag the field control to create a corresponding form template.

[0081] In step S3, the field control is used for the user to directly fill in the field content of the data, such as text field content or numeric field content.

[0082] S4. Mark the hierarchical relationship of the hierarchical data regions in each pair of form templates of the form hierarchy.

[0083] S5. Input or import external Excel data, and perform hierarchical data recognition processing on the external Excel data to obtain form data of the hierarchical form.

[0084] In the step S5, specifically, external Excel data is imported, and hierarchical data recognition processing is performed on the external Excel data to obtain form data of the hierarchical form, including but not limited to the following steps S51 to S57 which are interactively executed by multiple parties.

[0085] S51. The user front end responds to the user's first human-computer interaction operation to select an import file containing external Excel data.

[0086] S52. The user front end responds to the user's second human-computer interaction operation to configure an identification rule, and transmits the identification rule to the form server.

[0087] S53. The form server verifies whether the form template exists, and if it is determined to exist, verifies whether the import parameters of the import file are legal. If they are legal, the identification rules are transmitted to the parsing server.

[0088] In step S53, the import parameters specifically include but are not limited to the file format, the data format in the file and / or the contextual hierarchical information in the file, that is, verifying whether the import parameters of the imported file are legal includes but is not limited to: verifying whether the file format of the imported file is correct, whether the data format in the file is legal (such as whether the date data carries time zone information) and / or whether the data in the file has contextual hierarchical information, etc.

[0089] S54. The parsing server parses the imported configuration content in the identification rule to obtain hierarchical identification configuration content.

[0090] S55. The parsing server parses the imported file based on a stacked hierarchical tree construction algorithm to obtain row-level form data.

[0091] In step S55, the stack-type hierarchical tree construction algorithm is an existing algorithm, which is mainly used for depth-first traversal of trees, especially pre-order traversal. As a data structure, the stack is very suitable for implementing depth-first traversal of trees, especially pre-order traversal. In the depth-first traversal of a tree, pre-order traversal means first visiting the root node, then recursively visiting the left subtree, and finally visiting the right subtree. This traversal method is very compatible with the last in, first out (LIFO) characteristic of the stack, because the stack can save nodes that need to be processed later, ensuring that the parent node is processed before the child node is visited. Specifically, the implementation steps of the stack-type hierarchical tree construction algorithm are roughly as follows: (1) At the beginning, push the root node into the stack; (2) When the stack is not empty, repeat the following steps: pop the top element of the stack and visit the node; if the node has a left child node, push the left child node into the stack; if the node has a right child node, also push the right child node into the stack; repeat the above steps until the stack is empty. The implementation of this algorithm relies on the use of recursion and stacks to ensure the correct execution of depth-first traversal. During the tree construction process, a stack is maintained to save the nodes that need to be processed later, ensuring the order of processing parent nodes before accessing child nodes, thereby implementing the logic of pre-order traversal. In addition, this algorithm is not only applicable to binary trees, but can also be extended to multi-fork trees. After popping the top element of the stack, all its child nodes are pushed into the stack in turn.

[0092] S56. The parsing server constructs hierarchical form relationships for each pair of the row-level form data according to the hierarchical identification configuration content using a hierarchical adjusted tree structure compression algorithm, obtains hierarchical data and returns it to the form server.

[0093] In step S56, the tree structure compression algorithm is an existing algorithm, which mainly uses the concept of Huffman Tree, which is a tree with the shortest weighted path length, also known as the optimal binary tree. The construction process of the Huffman Tree is to construct multiple binary trees according to the given weights, and then select the two trees with the smallest weights to merge, and repeat this process until only one tree is left. This method uses the fact that characters with high frequency of occurrence correspond to shorter codes, while characters with low frequency of occurrence correspond to longer codes, thereby effectively reducing the amount of data stored or transmitted. Specifically, Huffman coding is a variable-length coding method, which constructs codewords with the shortest average length of different character heads based entirely on the probability of character occurrence. This coding method has no objection, that is, the binary number corresponding to any character will not "contain the binary number corresponding to other characters", and the average length of the code is shortened as much as possible, so that high-frequency characters are represented by shorter bytes and low-frequency characters are represented by longer bytes. In addition, there is a method for syntax tree compression in the field of NLP (Natural Language Processing). This method first loads the original syntax tree, then traverses the syntax tree and marks each node to determine its importance; then, unnecessary nodes and edges are deleted according to the mark, and finally the compressed syntax tree is output for subsequent use. This method is suitable for processing syntax trees in NLP tasks, reducing the size of data by deleting unimportant nodes and edges while maintaining the basic integrity of the tree structure and function. In summary, the tree structure compression algorithm effectively reduces the size of data by utilizing the concept of Huffman tree and specific methods in the field of NLP, especially when processing large amounts of repeated or redundant data, which can significantly improve the efficiency of data transmission and storage.

[0094] S57. The form server parses the hierarchical data into field data with the help of a hierarchical report field parsing and mapping converter, obtains the form data of the hierarchical form and returns it to the user front end.

[0095] In step S57, the hierarchical report field parsing and mapping converter is used to convert the data obtained by parsing and identifying into structured field data, such as converting text data into strings, or converting digital data into numbers, etc. In addition, after the form data of the hierarchical form is returned to the user front end, the form data can be displayed by rendering a hierarchical tree table style to trigger other business applications.

[0096] Preferably, the hierarchical form data analysis tool also includes but is not limited to a report generation module, a user interaction and collaboration module and / or a security and authority management module, etc.; the report generation module includes but is not limited to a custom report unit and / or an automated report unit, etc., wherein the custom report unit is used to generate a personalized analysis report based on the data and charts selected by the user, and provides a variety of report templates to help users create standardized reports, and the automated report unit is used to send the analysis results to relevant personnel regularly according to a preset time, and supports exporting in multiple formats (such as PDF format and / or Excel format, etc.) for sharing and archiving; the user interaction and collaboration module includes but is not limited to an interactive analysis unit and / or a multi-user collaboration unit, etc., wherein the interactive analysis unit is used to provide an interactive data analysis tool for users to interact with each other through human-computer interaction (for example, by clicking The multi-user collaboration unit is used to support multiple users to view and edit data analysis results at the same time, and provides comment and annotation functions, so that users can add annotations to reports and charts to achieve discussion and record; the security and authority management module includes but is not limited to a data security unit and an authority management unit, wherein the data security unit is used to encrypt transmission and / or encrypt storage of all data using encryption technology, and regularly back up data (which can prevent data loss); the authority management unit is used to control user access rights to data and / or analysis tools in a role-based authority management manner, so that users can view and / or operate corresponding data and / or analysis results according to their authority, thereby ensuring data privacy and security.

[0097] In summary, the project cost control system provided by this embodiment has the following technical effects:

[0098] (1) This embodiment provides a new project cost control solution applicable to large-scale engineering projects, namely, a hierarchical form designed based on a codeless form engine and a rule engine and supporting forms for engineering control, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure used to represent the hierarchical relationship / parent-child relationship of data in a form, and displays data input items of multiple hierarchical data in a nested form to facilitate users to input and manage data, and the hierarchical form data analysis tool includes a data capture and integration module, a data analysis module, and a data visualization module that are sequentially connected in communication. Through the design of the aforementioned hierarchical form and analysis tool, the data of the hierarchical form can be used to provide powerful data analysis and visualization capabilities, helping users to deeply analyze engineering cost data and make more accurate decisions, thereby solving the problems of the existing engineering cost control solution in the face of large-scale engineering projects, such as the lack of fine engineering cost control granularity and insufficient in-depth engineering cost control analysis, and facilitating practical application and promotion;

[0099] (2) Through the design of specific functional modules of the codeless form engine and the rule engine, the existing engineering project cost control solutions can solve the problems of multi-unit collaboration and approval flow difficulties in large-scale engineering projects;

[0100] (3) It can also lower the development threshold, improve development efficiency, enhance business flexibility, and improve cross-team collaboration efficiency;

[0101] (4) It can also support parsing complex tables such as engineering cost estimates, bills of quantities, and payment tables into hierarchical structured data, and support the full business process scenario of engineering cost control;

[0102] (5) It can also provide real-time feedback and analysis, and support multi-platform publishing and one-click deployment of forms designed based on the form engine and rule engine.

[0103] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A project cost control system, characterized in that: It includes a hierarchical form designed based on a codeless form engine and a rule engine and supporting a form for engineering management and control, and a hierarchical form data analysis tool based on the codeless form engine, wherein the hierarchical form refers to a form structure used to represent a hierarchical relationship / parent-child relationship of data in a form, and displays data input items of multiple hierarchical data in a nested form to facilitate data input and management by users, and the hierarchical form data analysis tool includes a data capture and integration module, a data analysis module, and a data visualization module that are sequentially connected in communication; The data capture and integration module includes a data capture unit and a data integration unit, wherein the data capture unit is used to automatically capture the data in the hierarchical form and including data information of all levels, and the data integration unit is used to integrate data of different levels to form a unified data set to be analyzed; The data analysis module includes a multi-dimensional analysis unit, an aggregation calculation unit and / or a trend analysis unit, wherein the multi-dimensional analysis unit is used to perform non-cross analysis of different dimensions and / or cross analysis of any combination of dimensions on the data set to be analyzed to obtain a first analysis result, the aggregation calculation unit is used to perform statistical analysis of any aggregation calculation method on the data set to be analyzed to obtain a second analysis result, and the trend analysis unit is used to perform time series analysis on the data set to be analyzed to obtain a third analysis result including a historical change trend of the project cost and / or a predicted future change trend of the project cost; The data visualization module includes a chart display unit and a hierarchical display unit, wherein the chart display unit is used to intuitively display the analysis results from the data analysis module in any chart type, and the hierarchical display unit is used to display the hierarchical relationship in the hierarchical form and the data information of each hierarchy.

2. The engineering project cost control system according to claim 1, characterized in that: The engineering control forms include engineering budget forms, engineering quantity forms and / or payment forms in engineering project cost control.

3. The engineering project cost control system according to claim 1, characterized in that: The codeless form engine includes a user interface design module and a data management module; The user interface design module includes a drag-and-drop editor and / or a preset template unit, wherein the drag-and-drop editor is used to respond to the user's human-computer interaction operation and design the application interface by dragging and dropping UI components, wherein the UI components include buttons, text boxes, forms, pictures and / or charts and allow the user to customize the component style, and the preset template unit is used to provide a variety of preset templates of the application interface for the user to select and customize; The data management module includes a database integration unit, a data binding unit and a data import and export unit, wherein the database integration unit is used to support users to create and manage database tables, and support users to define data fields and data types, the data binding unit is used to bind UI components to the database to realize data display and operation, and the data import and export unit is used to support importing data from the outside or exporting data to files.

4. The engineering project cost control system according to claim 1, characterized in that: The rule engine includes a business logic automation module and an analysis report module; The business logic automation module includes a conditional logic unit, a workflow automation unit and a function and expression unit, wherein the conditional logic unit is used to configure a conditional trigger in response to a user's human-computer interaction operation so that the conditional trigger performs a corresponding operation according to the configured condition, the workflow automation unit is used for the user to design and manage business process automation, and the function and expression unit is used to use built-in functions and / or expressions to process data and / or implement processing logic; The analysis report module includes a real-time analysis unit, a custom report unit and / or a data visualization unit, wherein the real-time analysis unit is used to provide real-time data analysis functions and monitor the usage and performance of the application, the custom report unit is used to generate custom reports and analyze key business indicators and / or user behaviors, and the data visualization unit is used to use chart tools and / or dashboard tools to visualize data so as to provide intuitive data insight functions.

5. The engineering project cost control system according to claim 3 or 4, characterized in that: The codeless form engine or the rule engine also includes an integration and extension module, a user management module, a deployment and publishing module and / or a collaboration and team management module; The integration and extension module includes a third-party service integration unit, an API connection unit and / or a plug-in and extension unit, wherein the third-party service integration unit is used to integrate third-party services, the API connection unit is used to support connection to external services / systems through an API interface to achieve data exchange and / or function extension, and the plug-in and extension unit is used to support the use of plug-ins and / or extensions to enhance application functions; The user management module includes a user authentication unit, a role and permission management unit and / or a user activity tracking unit, wherein the user authentication unit is used to provide user registration function, user login function and user password reset function, and supports multiple authentication methods, the role and permission management unit is used to define the roles and permissions of different users, and control the user's access rights to application functions and data, and the user activity tracking unit is used to record the user's activities in the application, and analyze and optimize them; The deployment and release module includes a one-click deployment unit, a version management unit and / or a multi-platform support unit, wherein the one-click deployment unit is used to support one-click release of the application to the platform, the version management unit is used to manage different versions of the application and support version rollback and update release, and the multi-platform support unit is used to support the release of the application to multiple platforms; The collaboration and team management module includes a team collaboration unit and a permission allocation unit, wherein the team collaboration unit is used to support multiple users to jointly edit and manage the same engineering project, and the permission allocation unit is used to assign different roles and permissions to each team member, and control each team member's access and modification permissions to the engineering project.

6. The engineering project cost control system according to claim 1, characterized in that: The hierarchical form includes a form item configuration module, a hierarchical management module, a data operation module, an automated workflow module and a user authority management module; The form item configuration module is used to support various types of form items and enable each form item to be configured with basic attributes, wherein the basic attributes include validation rules, default values ​​and / or placeholders; The hierarchical management module is used to enable users to manage the hierarchical structure of the form through a visual tool, and supports unlimited levels of nesting; The data operation module is used to support the integration of form data with subsequent databases or external APIs, realize data storage and synchronization, and provide data import and export functions so that users can perform batch operations on data; The automated workflow module is used to implement automated processing after form submission through conditional logic and triggers; The user authority management module is used to support user authority management so that different users can access and operate different parts of the form according to their authority, and provides role and authority settings to ensure data security and access control.

7. The engineering project cost control system according to claim 1, characterized in that: The user construction method of the hierarchical form includes the following steps: Select Create Hierarchical Form Template; Create a form hierarchy and form fields based on the hierarchical form template; For the form level, drag the field control to create a corresponding form template; marking the hierarchical relationship of the hierarchical data regions in the form templates for each pair of said form hierarchies; External Excel data is input or imported, and hierarchical data recognition processing is performed on the external Excel data to obtain form data of the hierarchical form.

8. The engineering project cost control system according to claim 7, characterized in that: Importing external Excel data, and performing hierarchical data recognition processing on the external Excel data to obtain form data of the hierarchical form, including: The user front end responds to the first human-computer interaction operation of the user to select an import file containing external Excel data; The user front end responds to the second human-computer interaction operation of the user to configure the identification rule, and transmits the identification rule to the form server; The form server verifies whether the form template exists, and if it is determined to exist, verifies whether the import parameters of the import file are legal. If they are legal, the identification rule is transmitted to the parsing server; The parsing server parses the imported configuration content in the identification rule to obtain the hierarchical identification configuration content; The parsing server parses the imported file based on a stacked hierarchical tree construction algorithm to obtain row-level form data; The parsing server constructs hierarchical form relationships for each pair of the row-level form data according to the hierarchical identification configuration content using a hierarchical adjusted tree structure compression algorithm, obtains hierarchical data and returns it to the form server; The form server parses the hierarchical data into field data with the help of a hierarchical report field parsing and mapping converter, obtains the form data of the hierarchical form and returns it to the user front end.

9. The engineering project cost control system according to claim 1, characterized in that: The hierarchical form data analysis tool also includes a report generation module, a user interaction and collaboration module and / or a security and authority management module; The report generation module includes a custom report unit and / or an automated report unit, wherein the custom report unit is used to generate a personalized analysis report based on the data and charts selected by the user, and provides a variety of report templates to help users create standardized reports, and the automated report unit is used to send the analysis results to relevant personnel regularly according to a preset time, and supports exporting in multiple formats for sharing and archiving; The user interaction and collaboration module includes an interactive analysis unit and / or a multi-user collaboration unit, wherein the interactive analysis unit is used to provide an interactive data analysis tool for users to dynamically adjust the analysis view and data range through human-computer interaction and supports the drill-down function, and the multi-user collaboration unit is used to support multiple users to view and edit data analysis results at the same time and provide comment and annotation functions so that users can add annotations to reports and charts to achieve discussion and record; The security and permission management module includes a data security unit and a permission management unit, wherein the data security unit is used to encrypt transmission and / or encrypt storage of all data using encryption technology, and to regularly back up data, and the permission management unit is used to control user access rights to data and / or analysis tools based on role-based permission management, so that users can view and / or operate corresponding data and / or analysis results according to their permissions, thereby ensuring data privacy and security.

10. The engineering project cost control system according to claim 1, characterized in that: The data visualization module also includes a real-time updating unit, wherein the real-time updating unit is used to enable the chart display unit and / or the level display unit to refresh the display data in real time, and supports dynamic refreshing and automatic refreshing.

Images