Data exchange method between domestic engineering management information system and financial sharing platform
By building a data interface and an automated transmission mechanism between the engineering management information system and the financial sharing platform, the problems of error risks, lack of automation and inconsistent standards in data exchange in the existing technology are solved, and efficient and secure data exchange and financial certificate generation are achieved, supporting the enterprise's goal of "integrated business and financial management and control".
Patent Information
- Application Number
- CN202411760498.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-03
- Publication Date
- 2025-04-08
AI Technical Summary
The existing technology has the risk of data input errors in the data exchange between the engineering management information system and the financial sharing platform, the lack of automation functions, the cumbersome approval process, the risk of data leakage and inconsistent data format standards, making it difficult for enterprises to achieve the goal of "integrated business and finance control".
By building a data interface between the engineering management information system and the financial sharing platform, automated data transmission and financial voucher generation are realized, preset standard interfaces support data interaction, and the distribution path for message data backhaul is set according to the network environment and system architecture.
It improves the efficiency and accuracy of data transmission, reduces the time and error rate of manual operation, enhances data security and privacy protection, and realizes seamless docking and efficient exchange of data between systems.
Smart Images

Figure CN119788696A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of data exchange, and in particular to a data exchange method between a domestic engineering management information system and a financial sharing platform. Background Art
[0002] With the development of information technology and the increasing demand for enterprise management, the connection and data exchange between the engineering management information system (EIMS) and the financial sharing platform have become an important direction for modern enterprise management. In daily operations, such systems need to communicate data across departments and systems to ensure the accuracy, timeliness and security of various business data.
[0003] At present, some mature technologies and solutions have been widely used in data exchange between engineering management information systems and financial sharing platforms. For example, API (application programming interface) technology can be used to achieve data intercommunication between the two systems; cloud computing technology can be used to achieve secure data storage and efficient processing; the financial sharing platform is also connected with mainstream ERP systems (such as SAP) and human resources management systems for business exchange. SAP is connected with financial data, such as account codes, project WBS (work breakdown structure), etc., and the human resources management system is mainly connected with personnel organizational structure, personnel coding, etc.
[0004] Although the existing technology has made some progress in the connection between the engineering management information system and the financial sharing platform, there are still some obvious problems that hinder the further optimization and efficiency improvement of data exchange between systems. Specific problems include: At present, many enterprises still rely on manually filling in contract settlement data for financial settlement, which is at risk of data input errors, thus affecting the accuracy of financial statements. Existing systems often lack automation functions and cannot automatically transfer contract settlement data to the financial sharing system and automatically generate vouchers. Each time the settlement data is input and the voucher is generated, manual operations are required, which not only increases the workload but also reduces the processing efficiency. The current approval process still relies on manual review and multi-level approval, resulting in cumbersome and time-consuming secondary approval links in the contract settlement process, low approval efficiency, and easy to cause project capital flow lags, affecting the timeliness and accuracy of financial statements. Although cloud computing and API technology provide certain security guarantees, there is still a risk of data leakage, especially when exchanging data between different systems, there is a possibility of data being intercepted or tampered during the data transmission process. In addition, enterprises lack unified security standards and protocols when exchanging data, resulting in data privacy cannot be effectively protected. The data formats and standards between various business systems vary greatly, and data transmission and docking between different systems often have compatibility issues due to inconsistent standards. Due to the above-mentioned problems in the interconnection between the engineering management information system and the financial sharing platform, it is difficult for enterprises to achieve the goal of "integrated management and control of business and finance".
[0005] Therefore, there is an urgent need for a data exchange method between a domestic engineering management information system and a financial sharing platform. Summary of the invention
[0006] The present invention provides a data exchange method between a domestic engineering management information system and a financial sharing platform to solve the above problems existing in the prior art.
[0007] In order to achieve the above object, the present invention provides the following technical solutions:
[0008] The data exchange method between the domestic engineering management information system and the financial sharing platform includes:
[0009] S101: Based on the data transmission requirements between the engineering management information system and the financial sharing platform, build the corresponding data interface;
[0010] S102: The financial sharing platform extracts message data from the data platform through the data interface, and writes the message data into a designated location of the system according to business requirements;
[0011] S103: The financial sharing platform automatically fills in data and generates corresponding financial vouchers according to pre-set rules and templates;
[0012] S104: For different types of message data, several standard interfaces are preset to support data interaction;
[0013] S105: According to the current network environment and system architecture, a distribution path for returning message data is set.
[0014] Wherein, after step S104, the method further includes:
[0015] After the data interface is triggered, the system automatically starts the message data transmission. If the message data transmission fails, the system will automatically retry after two hours.
[0016] Set two interface triggering modes: automatic and manual. The automatic interface triggering mode means that when the business process in the engineering management system is completed, the system automatically triggers data transmission. The manual interface triggering mode means that the business personnel trigger the message data transmission process after manually entering the payment slip.
[0017] Wherein, step S101 includes:
[0018] S1011: Obtain contract settlement business data related to project construction in the engineering management information system;
[0019] S1012: The engineering management information system transmits the acquired contract settlement business data to the data platform through the data interface;
[0020] S1013: The financial sharing platform obtains the contract settlement business data from the data platform through the data interface, and automatically generates financial voucher information according to the preset rules;
[0021] S1014: Transmit the financial voucher information to the SAP system and complete the construction of the data interface transmission method.
[0022] Wherein, step S102 includes:
[0023] The engineering management system automatically sends the contract settlement business data to the data platform through the message queue MQ. The financial sharing platform extracts the contract settlement business data from the data platform through the set data interface, and writes the contract settlement business data to the designated location of the system according to business needs to ensure the correct flow of data.
[0024] Wherein, step S103 includes:
[0025] In the engineering management system, after the contract settlement business data processing is completed, the data is automatically transmitted to the financial sharing platform through the preset data interface. The financial sharing platform automatically fills in the data and generates relevant financial voucher information according to the pre-set rules and templates, completing the closed loop of contract settlement.
[0026] Wherein, step S104 includes:
[0027] Different standard interfaces are preset for different types of contract settlement data. The standard interfaces include those for processing contract advance payments with or without supervision payment data in the engineering management system, invoice settlement without order, and purchase payment reimbursement bills; the transmission of attachment information between the engineering management system with or without supervision payment data and the imaging system interface; the reimbursement status feedback interface between the engineering management system and the financial sharing platform; and the generation of financial voucher information between personal reimbursement data or public payment voucher data of the financial sharing platform and the voucher page of the engineering management system.
[0028] Wherein, step S105 includes:
[0029] According to the current network environment and system architecture, a unified receiving interceptor based on SpringBoot is designed for the contract settlement business data feedback processing of each subsystem to receive and parse the returned data. The contract settlement business data is authenticated, filtered and encapsulated through the configured rules. The system dynamically identifies the rules through the configuration file. The system intelligently distributes the data to each subsystem according to the type and target of the returned contract settlement business data. At the same time, a load balancing strategy is adopted to perform load balancing operations on the contract settlement business data.
[0030] The contract settlement business data transmission and processing for each subsystem includes:
[0031] When configuring data transmission and return paths, evaluate the network environment and system architecture, assess the current network bandwidth, latency, and stability, and ensure that there are no network partitions or firewall restrictions. At the same time, analyze the functional requirements and communication protocols of each subsystem to ensure high efficiency and stability during data exchange;
[0032] Through the SpringBoot interceptor mechanism, a unified contract settlement business data receiving and processing module is designed. After receiving the contract settlement business data, the interceptor parses the contract settlement business data to ensure that the contract settlement business data conforms to the expected format and structure, and then filters the contract settlement business data to remove invalid or abnormal data, encapsulates the filtered messages and distributes them to the target subsystem. The system supports dynamic routing selection based on configuration files to ensure that messages are transmitted along the optimal path;
[0033] During the distribution of contract settlement business data, a load balancing strategy is adopted to ensure that each subsystem evenly shares the contract settlement business data processing tasks, and load balancing is performed based on polling, random or weighted strategies to avoid overloading of a single subsystem.
[0034] Among them, the engineering management system automatically sends the contract settlement business data to the data platform through the message queue MQ, including:
[0035] The control engineering management system extracts the initial contract settlement business data from the contract settlement business module and formats the contract settlement business data into the message format transmitted by the message queue MQ;
[0036] Determine the transmission status and priority of the current contract settlement business data. The status includes pending transmission status and transmitted status. The priority is used to determine the order of transmission.
[0037] The formatted contract settlement business data is sent to the data platform through MQ, and the status update during the transmission process is monitored until the transmission status of all data sets is updated to the transmitted status, or the preset number of errors reaches the threshold;
[0038] The control data platform receives the contract settlement business data from MQ, stores the contract settlement business data in the designated data storage area, and updates the storage status information;
[0039] The financial sharing platform extracts contract settlement business data from the data platform through a preset interface, determines the integrity and consistency of the extracted data set, and ensures that the data is accurate;
[0040] According to business needs, the financial sharing platform writes the extracted contract settlement business data into the designated location of the system.
[0041] Among them, automatically fill in data and generate relevant financial voucher information, including:
[0042] Querying a preset rule and template library to determine at least one association rule between the contract settlement business data and the financial voucher information;
[0043] Obtain the rule category corresponding to the association rule, which includes: data filling rule and voucher generation rule;
[0044] When the rule category corresponding to the association rule is a data filling rule, the contract settlement business data is analyzed based on a preset filling model to obtain first filling information;
[0045] When the rule category corresponding to the association rule is a voucher generation rule, the voucher template and voucher attributes corresponding to the contract settlement business data are obtained;
[0046] Split the voucher template into multiple template items, and at the same time, obtain the sequence identifiers corresponding to the template items;
[0047] Obtain a preset template line, and set the template items on the template line accordingly based on the sequence identifier;
[0048] Extract features from template items to obtain multiple template features;
[0049] Obtain a necessary feature library corresponding to the credential attribute, match the template feature with the feature in the necessary feature library, and if the match is met, use the corresponding template item as a filling item. At the same time, obtain at least one filling item corresponding to the matched feature, and the filling item includes: filling direction, filling range and filling strategy;
[0050] Select the template item corresponding to the filling range in the filling direction of the filling item on the template line and use it as the filling item;
[0051] Based on the filling strategy, fill the filling item, and if the filling is successful, obtain the second filling information corresponding to the filling strategy;
[0052] Otherwise, obtain the impact value corresponding to the filling strategy;
[0053] The first filling information, the second filling information and the impact value are cumulatively calculated to obtain the voucher information corresponding to the contract settlement business data, thereby completing the voucher generation.
[0054] Compared with the prior art, the present invention has the following advantages:
[0055] The data exchange method between the domestic engineering management information system and the financial sharing platform includes: building a corresponding data interface based on the data transmission requirements between the engineering management information system and the financial sharing platform; the financial sharing platform extracts message data from the data platform through the data interface, and writes the message data into the designated location of the system according to business requirements; the financial sharing platform automatically fills in data and generates corresponding financial vouchers according to pre-set rules and templates; for different types of message data, several standard interfaces are preset to support data interaction; according to the current network environment and system architecture, the distribution path of message data return is set. Through in-depth mining and analysis of exchanged data, valuable business insights and decision support are provided to enterprises.
[0056] Other features and advantages of the present invention will be set forth in the description which follows, and in part will be apparent from the description, or may be learned by practice of the present invention.
[0057] The technical solution of the present invention is further described in detail below through the accompanying drawings and embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0058] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:
[0059] Figure 1 It is a flow chart of a method for exchanging data between a localized engineering management information system and a financial sharing platform in an embodiment of the present invention;
[0060] Figure 2 A flowchart of a corresponding data interface transmission method is constructed in an embodiment of the present invention;
[0061] Figure 3 Schematic diagram of manual triggering of a data interface in an embodiment of the present invention. DETAILED DESCRIPTION
[0062] The preferred embodiments of the present invention are described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present invention, and are not used to limit the present invention.
[0063] The embodiment of the present invention provides a data exchange method between a localized engineering management information system and a financial sharing platform, including:
[0064] S101: Based on the data transmission requirements between the engineering management information system and the financial sharing platform, build the corresponding data interface;
[0065] S102: The financial sharing platform extracts message data from the data platform through the data interface, and writes the message data into a designated location of the system according to business requirements;
[0066] S103: The financial sharing platform automatically fills in data and generates corresponding financial vouchers according to pre-set rules and templates;
[0067] S104: For different types of message data, several standard interfaces are preset to support data interaction;
[0068] S105: According to the current network environment and system architecture, a distribution path for returning message data is set.
[0069] The working principle of the above technical solution is as follows: Step 1: constructing an interface data transmission method;
[0070] Step 2: Set the interface transmission mode. The engineering management system sends the corresponding contract settlement business data to the data platform through the MQ message queue. The Huadian International Sharing Platform automatically extracts the contract settlement business data from the message queue through the data platform and writes it to the corresponding location of the international sharing platform.
[0071] Step 3: Set the integration method and integrate the result data (that is, the engineering management system transfers the corresponding contract settlement business data to the financial sharing system after the business process is completed, and the financial sharing system automatically fills it into the corresponding business scenario according to the set rules).
[0072] Step 4: Preset standard interface. The engineering management system has the supervision payment data and the financial sharing platform interface to generate the contract advance payment invoice. The engineering management system does not have the supervision payment data and the financial sharing platform interface to generate the contract advance payment invoice. The engineering management system has the supervision payment data and the financial sharing platform interface to generate the non-order invoice settlement invoice. The engineering management system does not have the supervision payment data and the financial sharing platform interface to generate the non-order invoice settlement invoice. The engineering management system has the supervision payment data and the financial sharing platform interface to generate the contract procurement payment invoice. The engineering management system does not have the supervision payment data and the financial sharing platform interface to generate the contract procurement payment invoice. The engineering management system has the supervision payment data and the image system interface to transmit the attachment information. The engineering management system does not have the supervision payment data and the image system interface to transmit the attachment information. The engineering management system has the financial sharing platform invoice status feedback interface. The personal reimbursement data of the financial sharing platform and the engineering management system voucher page generate voucher information. The public payment voucher data of the financial sharing platform and the engineering management system voucher page generate voucher information.
[0073] Step 5: Set the interface timeliness. In order to ensure the timeliness of data transmission, it is recommended to set the interface transmission to automatic transmission after the business process of the engineering management system is completed. If the automatic transmission fails, it will be automatically synchronized again two hours later.
[0074] Step 6: Set the interface trigger mode. Automatic interface call mode: automatically trigger through process completion. Manual call trigger mode: business personnel manually enter the page to enter the payment order for transmission.
[0075] Step 7: Set the multi-system distribution path for the returned data. According to the current network environment and system architecture, for the message return processing of each subsystem, a message return traditional receiving interceptor developed based on the springboot development framework is used to parse, identify and authenticate the returned data, effectively filter the message return, and encapsulate and distribute the message. Dynamic identification is based on the configuration file, and the message is distributed to each subsystem. Load balancing is performed on the message. Network environment assessment: Analyze the current network bandwidth, latency and stability, consider whether there is network partitioning, firewall restrictions or security policies, evaluate the network topology, determine the message return path and possible bottlenecks. System architecture analysis: Determine the number, functions and interaction methods of subsystems, analyze the communication protocols and data formats between subsystems, and evaluate the scalability and maintainability of the existing system architecture. Interceptor design: Use the interceptor mechanism of SpringBoot to achieve unified message reception. Design the interceptor interface and define the necessary callback methods, such as message reception, parsing, and processing. Message reception: Configure the endpoint of SpringBoot to receive messages, implement the message reception logic, and pass the received message to the interceptor for processing. Message parsing: According to the communication protocol between subsystems, parse the received message content and convert the parsed message into an internal object for subsequent processing. Message filtering: According to business needs, implement message filtering logic to filter out invalid or non-compliant messages and reduce system burden. Message encapsulation: Encapsulate the filtered messages and add necessary metadata and context information. The encapsulated messages should be easy to distribute and process. Message distribution: According to the configuration file or dynamic rules, the encapsulated messages are distributed to each subsystem. Technologies such as message queues, RPC frameworks, or event buses can be used to implement message distribution. Load balancing: Consider load balancing during message distribution to ensure that each subsystem can process messages evenly. Load balancing can be implemented using polling, random, weight, and other strategies.
[0076] The beneficial effects of the above technical solution are as follows: the data exchange technology adopted can realize efficient and fast data transmission and processing, ensure the real-time synchronization and update of data between the two systems, and this efficient data processing capability greatly improves the efficiency of engineering management and financial management, enabling enterprises to respond to market changes and business needs more quickly. In the process of data exchange, advanced data encryption and transmission technology are adopted to ensure the confidentiality and integrity of data. At the same time, through access control and authority management, it is ensured that only authorized personnel can access and operate relevant data, effectively preventing the risk of data leakage and illegal access. It can flexibly integrate data of different formats and sources to realize the unified management and utilization of multi-source data, which enables the engineering management information system and the financial sharing platform to seamlessly connect, give full play to their respective functional advantages, and maximize the utilization of information resources. Through in-depth mining and analysis of exchanged data, valuable business insights and decision support are provided to enterprises. By using big data analysis and artificial intelligence technology, enterprises can better understand market demand, optimize resource allocation, and improve operational efficiency, thereby gaining a competitive advantage. The adopted technical architecture has good scalability and maintainability, and can adapt to the needs of future development of enterprises. As the business scale expands and the system is upgraded, the data exchange solution can be flexibly adjusted and optimized to ensure the stability and efficiency of the system.
[0077] In another embodiment, after step S104, the method further includes:
[0078] After the data interface is triggered, the system automatically starts the message data transmission. If the message data transmission fails, the system will automatically retry after two hours.
[0079] Set two interface triggering modes: automatic and manual. The automatic interface triggering mode means that when the business process in the engineering management system is completed, the system automatically triggers data transmission. The manual interface triggering mode means that the business personnel trigger the message data transmission process after manually entering the payment slip.
[0080] The working principle of the above technical solution is: the system background sets automatic trigger conditions. When certain key business processes in the engineering management system (such as approval completion or status change) meet the trigger conditions, the system will automatically start message data transmission. Data transmission process: After the system identifies the trigger event, it calls the corresponding data interface. The data is transmitted to the designated system (such as the financial system or third-party payment platform) through the interface.
[0081] The automatic interface trigger mechanism is activated, and the system automatically transmits the payment information of the fee to the financial system to generate a payment order. The automatic interface trigger mechanism starts with the filling of the report by the personnel of the undertaking department. This step is the starting point for triggering the automatic process. The relevant personnel fill in or upload the initial information to ensure the integrity of the data.
[0082] After the responsible person of the responsible department reviews and fills in the form, the information enters the review stage of the responsible person of the responsible department. The review content includes: confirming whether the filled-in information meets the requirements; checking the completeness and accuracy of the data or materials. After the review is passed, the process continues; if it fails, it will be returned to the person filling in the form for modification. According to the flow chart, after the review is completed, it will be divided into two parallel paths: Department responsible person and environmental and water conservation line review: special review of environmental protection and water resources related lines; this path is responsible for confirming whether it meets policy or regulatory requirements. Approval by the branch company's responsible leader: the process simultaneously enters the approval stage of the branch company's responsible leader; the responsible leader verifies whether the overall data meets business needs. After the above two branches are completed, all information is summarized to the branch company's leaders for approval. The branch company leaders are responsible for overall control, including: reviewing the full process data and approval opinions; making the final compliance judgment. After the approval of the branch company leaders, it enters a higher level of approval, that is, the approval of the branch company's directors. In this stage, the directors confirm according to the specific circumstances, which may involve strategic judgments.
[0083] The final process will be approved by the financial staff. The financial staff will verify whether the funds, budgets or payment processes involved are reasonable, and ensure: the accuracy of financial data; compliance with corporate financial regulations.
[0084] When all the steps are passed, the process is completed. If a step in the middle fails, it will return to the previous process or start again.
[0085] like Figure 3 As shown, the manual interface trigger mode, log in to the system: open the browser and access the corresponding system login page. Use the user name and password to log in to the system. In the top navigation bar of the system main interface, click the "Contract Management" module to enter the contract management page.
[0086] Find the "Cross-step Data Transfer" area. After the page loads, scroll down to the "Cross-step Data Transfer" area (such as Figure 3 box). This area is used to manage and trigger data synchronization operations.
[0087] Select "Financial Advancement Type": Click the drop-down box and select the required financial advancement type from the options (e.g. initial approval, financial settlement, etc.). Enter "Payment Order Number": In the corresponding input box, manually enter the relevant payment order number. Ensure that the payment order number is filled in correctly and consistent with the actual record.
[0088] Enter "Contract Number": Fill in the target contract number in the input box. The contract number must match the contract information stored in the system.
[0089] Click the "Skip Step" button: In the operation column on the right, find the "Skip Step" button. After clicking this button, the system will execute the data transfer task. The system will pop up a prompt box to confirm the operation: click "Confirm" to continue the operation, or click "Cancel" to terminate the task.
[0090] The beneficial effects of the above technical solution are: avoiding manual intervention, triggering data transmission immediately after the business process is completed, shortening operation time, reducing error rate: eliminating manual input errors, and ensuring data accuracy. The manual interface triggering method allows business personnel to supplement or revise data under special circumstances to ensure the integrity and accuracy of information transmission. In the case of automatic transmission failure, the interface can be triggered manually to effectively make up for the transmission loopholes.
[0091] In another embodiment, step S101 includes:
[0092] S1011: Obtain contract settlement business data related to project construction in the engineering management information system;
[0093] S1012: The engineering management information system transmits the acquired contract settlement business data to the data platform through the data interface;
[0094] S1013: The financial sharing platform obtains the contract settlement business data from the data platform through the data interface, and automatically generates financial voucher information according to the preset rules;
[0095] S1014: Transmit the financial voucher information to the SAP system and complete the construction of the data interface transmission method.
[0096] The working principle of the above technical solution is as follows: Figure 2 As shown in the figure, the engineering management system includes different subsystems (such as system A-advance payment, system B-progress payment, system C-settlement payment), which generate contract settlement business data related to project construction. Business data is collected and transmitted to the "data center" through a dedicated interface. The engineering management system is responsible for business processes such as contract signing and fund allocation. The division of labor of each subsystem is clear, and data is collected by type to ensure reliable sources.
[0097] The data center receives contract settlement data from the engineering management system. The data center pushes business data to different target platforms in the form of message distribution. During the distribution process, the center identifies the data by referencing fields to ensure that it is distributed to the correct downstream business system. The data center is a data exchange hub between systems, playing a role in data integration and transmission. The message distribution mechanism improves the accuracy and efficiency of data transmission.
[0098] The financial sharing platform receives the contract settlement data transmitted from the data center. According to the contract type and business logic, the financial sharing platform generates the following types of financial data: Prepayment write-off form: used to write off the prepayment that has been paid. No-order invoice settlement bill: handles accounts payable that are not based on orders. Contract payment write-off form: completes the write-off of progress or settlement payments based on contracts. The platform automatically generates the corresponding financial voucher information according to the preset rules. The financial sharing platform ensures efficient and accurate financial data processing through standardized rules. Automatic generation of financial vouchers reduces errors in manual operations.
[0099] The financial sharing platform transmits the generated financial voucher information to the SAP system through the interface. After receiving the financial voucher information, the SAP system completes the accounting and further financial processing. As the core system of enterprise resource management, the SAP system is responsible for the financial processing and decision support of the entire enterprise. The automated transmission of the data interface reduces the manual input link and improves the operation efficiency.
[0100] The beneficial effects of the above technical solution are: the whole process from the engineering management system to the SAP system realizes automated data transmission, which shortens the time of manual operation. Through standardized rules and interface transmission, manual data entry errors are avoided. As an information hub, the data center ensures the interconnection and interoperability of data between different systems. The whole process data of contract settlement is traceable, which is helpful for auditing and management. After receiving complete financial data, the SAP system can generate accurate financial statements to provide decision-making basis for enterprises.
[0101] In another embodiment, step S102 includes:
[0102] The engineering management system automatically sends the contract settlement business data to the data platform through the message queue MQ. The financial sharing platform extracts the contract settlement business data from the data platform through the set data interface, and writes the contract settlement business data to the designated location of the system according to business needs to ensure the correct flow of data.
[0103] The working principle of the above technical solution is: after completing the contract settlement-related business processing, the engineering management system will send the settlement data (such as contract amount, payment details, settlement date, etc.) to the data platform through the message queue (MQ). The role of the message queue is to serve as a data buffer to ensure asynchronous data transmission and avoid excessive system pressure.
[0104] The engineering management system packages the contract settlement data into messages through internal logic and sends them to the message queue (MQ). After receiving the data, the message queue pushes the data to the data platform in sequence.
[0105] For example: After a construction project is completed, the engineering management system sends the project's contract settlement information to the data platform through the MQ message queue. The message content includes the total settlement amount, payer, payee and other information.
[0106] The financial sharing platform extracts contract settlement data from the data platform through a preset interface. The interface can be automatically captured at a scheduled time or triggered according to demand. After obtaining the data, the financial sharing platform will automatically or manually write the data to the designated location of the system (such as the payment management module, financial record module, etc.) according to business needs. For example: the financial sharing platform sets a scheduled task to extract contract settlement data from the data platform every hour, and automatically stores it in the financial system according to fields such as project number, payment amount, settlement date, etc., for subsequent payment processes, report generation, and other operations.
[0107] During the extraction and writing process, the system will check the contract settlement data, such as amount matching, field integrity, etc., to ensure that the data is correct. If an error occurs during data extraction or writing (such as missing fields, wrong format), the system will log it and issue an alarm to remind relevant personnel to handle it.
[0108] The beneficial effects of the above technical solution are as follows: the message queue (MQ) provides an asynchronous processing method, and data can be transmitted to the data platform in real time or near real time, and then the financial sharing platform automatically extracts the data, avoiding manual intervention and greatly improving data processing efficiency. Automated data flow reduces the links of manual entry or manual data transmission, effectively avoiding errors caused by manual operation, and ensuring the accuracy of the data. The message queue (MQ) has strong fault tolerance. When the system is abnormal or the load is too high, it can temporarily save data to ensure that it will not be lost, and then process it after the system is restored. This ensures that data transmission will not be affected even during peak hours or system problems. The engineering management system and the financial sharing platform are decoupled through the data platform. There is no direct dependence between the two systems, which reduces the coupling between the systems and makes the maintenance and upgrade of each system more independent and flexible.
[0109] In another embodiment, step S103 includes:
[0110] In the engineering management system, after the contract settlement business data processing is completed, the data is automatically transmitted to the financial sharing platform through the preset data interface. The financial sharing platform automatically fills in the data and generates relevant financial voucher information according to the pre-set rules and templates, completing the closed loop of contract settlement.
[0111] The working principle of the above technical solution is: after the engineering management system completes the relevant business processing of the contract settlement (for example: checking the settlement amount, confirming the payment plan, generating a settlement order, etc.), it will generate a data packet containing settlement information (such as contract number, settlement amount, payment method, payee, settlement date, etc.). When the business processing is completed, the system automatically triggers the data transmission process. The data interface is a pre-set connection point, through which the engineering management system sends the settlement data to the financial sharing platform. This interface generally supports automated calls without manual intervention. Assuming that after the settlement of a project is completed, the engineering management system will automatically push all the details of the settlement (for example: contract number, settlement amount of 1 million, payment date November 20, 2024) to the financial sharing platform through the data interface.
[0112] The financial sharing platform receives settlement data from the engineering management system through a preset interface. The financial sharing platform has the ability to automatically identify and parse data structures, and stores the received settlement data in the corresponding financial module. The financial sharing platform automatically fills and processes the received data according to pre-set rules and templates (such as: financial voucher format, account code, payment account, etc.). For example, the platform automatically selects the appropriate account according to the contract amount, automatically fills in the name of the settlement party, amount, tax and other information, and generates the corresponding financial voucher. Based on the filled data, the financial sharing platform automatically generates a financial voucher. This voucher will contain information such as the settlement amount, account, and capital flow to ensure that the financial accounts and engineering settlement data are consistent. For example, the engineering management system transmits a payment data with a settlement amount of 1 million yuan. After receiving the data, the financial sharing platform automatically fills in the account as "engineering settlement payment", the payer as "Company A", and the payee as "Company B" according to the set template, and generates a voucher information with the voucher number "202411200001". The system will also automatically calculate the relevant tax amount and payment date according to the rules to ensure the accuracy of the financial voucher.
[0113] After the financial voucher is generated, the financial sharing platform will automatically check to ensure that the voucher information is consistent with the contract settlement data. If there is any mismatch or anomaly, the system will issue an alarm or error prompt, and the financial staff will conduct manual verification. After the verification is correct, the system will automatically record the financial voucher to ensure that the settlement information is accurately reflected in the financial system and provide data support for subsequent payments, report generation and financial analysis. At this point, the process of contract settlement is closed. Assuming that the financial platform successfully generates the settlement voucher and there are no problems after verification, the platform will automatically record the voucher and update the financial report to ensure that the settlement amount is correctly recorded in the financial system and is ready for subsequent payment or audit work.
[0114] The beneficial effects of the above technical solution are: the generation, filling and voucher generation of each contract settlement data are fully logged. Financial personnel and managers can view the data processing process at any time to ensure that the process is transparent and easy to audit and supervise. The rules and templates of the financial sharing platform are formulated in accordance with the financial management system and compliance requirements, which can ensure that all contract settlement data are in line with the company's financial policies and laws and regulations, avoiding compliance risks. The engineering management system and the financial sharing platform achieve seamless docking through automated data transmission, reducing the barriers to cross-departmental communication and making the collaborative work of the business department and the financial department more efficient. After the project settlement is completed, the financial department can automatically receive relevant information and process it in a timely manner, avoiding data delays or errors caused by poor communication. From contract settlement to financial voucher generation, accounting, and then to fund payment, the entire process forms a complete closed loop, ensuring that the company's financial data is reflected in the system in real time and accurately. This can provide accurate data support for financial decision-making, fund scheduling, auditing and budget management.
[0115] In another embodiment, step S104 includes:
[0116] Different standard interfaces are preset for different types of contract settlement data. The standard interfaces include those for processing contract advance payments with or without supervision payment data in the engineering management system, invoice settlement without order, and purchase payment reimbursement bills; the transmission of attachment information between the engineering management system with or without supervision payment data and the imaging system interface; the reimbursement status feedback interface between the engineering management system and the financial sharing platform; and the generation of financial voucher information between personal reimbursement data or public payment voucher data of the financial sharing platform and the voucher page of the engineering management system.
[0117] The working principle of the above technical solution is: the contract advance payment interface between the engineering management system and the financial system. For example, after a contract for a certain engineering project is signed, an advance payment is required. If it involves supervision payment data, the system will obtain the supervision approval record from the engineering management system, and automatically generate payment application data after verifying the contract amount and payment ratio. If there is no supervision payment data, the system will only verify the contract approval information and directly generate the advance payment record.
[0118] The engineering management system pushes the contract information and approval flow to the interface. The interface automatically matches the relevant rules to determine whether supervision approval is required. The financial system generates the corresponding payment documents based on the results of the interface transmission. There is no order invoice settlement interface.
[0119] For example, a supplier directly provides goods without signing an order. When settling accounts, the financial staff enters the invoice information through the interface, and the system automatically verifies whether the invoice amount meets the budget and pushes it to the sharing platform.
[0120] The user enters information in the invoice module, and the interface obtains contract or project data for verification. After the system verifies that it is correct, a payment application is generated and pushed to the financial sharing platform. The attachment transmission interface between the imaging system and the engineering management system.
[0121] For example, a contract requires uploading of image attachments (such as scanned copies of contracts, supervisory approval documents). The image system associates the attachment information with the corresponding contract item in the engineering management system through an interface.
[0122] When users upload attachments to the imaging system, the system automatically generates a unique identifier. The interface matches the corresponding contract data in the engineering management system based on the identifier and synchronizes the attachment information. The status feedback interface between the financial sharing platform and the engineering management system.
[0123] For example: After the financial staff completes the reimbursement of a contract on the shared platform, they need to return the processing status to the engineering management system.
[0124] The sharing platform automatically generates updated information on the reimbursement status (such as "paid" or "pending review"). The status is transmitted to the engineering management system through an interface for the project manager to view in real time. Financial voucher generation interface.
[0125] After a person submits an expense reimbursement form, the system automatically generates a financial voucher and associates it with the corresponding project or contract. The financial sharing platform pushes the individual reimbursement data to the engineering management system. The system generates voucher data that meets accounting requirements based on the interface rules.
[0126] The beneficial effects of the above technical solution are: data processing automation reduces manual operation links and significantly reduces human resource investment. Interface rules ensure the consistency and accuracy of data. Standardized interfaces unify the interaction rules between systems, making data transmission between different departments smoother.
[0127] In another embodiment, according to the current network environment and system architecture, a unified receiving interceptor based on SpringBoot is designed for the contract settlement business data feedback processing of each subsystem, which is used to receive and parse the returned data. The contract settlement business data is authenticated, filtered and encapsulated through the configured rules. The rules are dynamically identified through the configuration file. The system intelligently distributes data to each subsystem according to the type and target of the returned contract settlement business data, and adopts a load balancing strategy to perform load balancing operations on the contract settlement business data.
[0128] The working principle of the above technical solution is: the system receives contract settlement business data through HTTP, message queue and other interfaces. The interceptor captures all incoming data requests and determines whether the request complies with the basic format and permissions through the filter chain.
[0129] For example: Subsystem A returns JSON data {"contractId":"C123","amount":5000}.
[0130] The interceptor determines whether the data source is in the authorized list and whether the data is complete (such as whether the contractId and amount fields are missing).
[0131] Load data rules through configuration files (such as YAML, Properties) to dynamically match contract data types. Configuration rules support differentiation by business type (such as payment settlement, default settlement) or target subsystem matching.
[0132] The system verifies the legitimacy of data content based on configuration rules, such as whether the field range and field value meet the specifications. Invalid data is directly filtered out and does not enter the subsequent processing flow.
[0133] According to the target subsystem’s required format, encapsulate the data into a specific structure, supporting JSON, XML, or custom protocol formats. Use target type matching rules to intelligently distribute data to the corresponding subsystem.
[0134] The system uses load balancing algorithms (such as polling, random, weight, etc.) to distribute data to target subsystems of multiple instances, achieving stable data transmission under high concurrency.
[0135] The beneficial effects of the above technical solution are as follows: through a unified receiving interceptor, the cost of repeatedly developing parsing, authentication and filtering logic for each subsystem is reduced. Dynamically configured rule parsing improves system flexibility, and new rules can be adapted without modifying the code. The data authentication and filtering mechanism ensures that the transmitted data is accurate and legal, and prevents abnormal data from entering the system. The interception mechanism supports source verification and effectively defends against unauthorized access. The configuration file supports dynamic update rules and quickly adapts to changes in contract settlement business rules. Through intelligent distribution, it can quickly support the access requirements of new subsystems. The load balancing strategy avoids single-point pressure and improves the reliability of the system. Balanced data distribution supports stable data flow processing in high-concurrency scenarios. Unified reception and processing facilitate centralized log management and exception troubleshooting. The configuration rules are clear and concise, which facilitates system maintenance personnel to quickly locate and modify problems.
[0136] In another embodiment, the contract settlement business data transmission processing for each subsystem includes:
[0137] When configuring data transmission and return paths, evaluate the network environment and system architecture, assess the current network bandwidth, latency, and stability, and ensure that there are no network partitions or firewall restrictions. At the same time, analyze the functional requirements and communication protocols of each subsystem to ensure high efficiency and stability during data exchange;
[0138] Through the SpringBoot interceptor mechanism, a unified contract settlement business data receiving and processing module is designed. After receiving the contract settlement business data, the interceptor parses the contract settlement business data to ensure that the contract settlement business data conforms to the expected format and structure, and then filters the contract settlement business data to remove invalid or abnormal data, encapsulates the filtered messages and distributes them to the target subsystem. The system supports dynamic routing selection based on configuration files to ensure that messages are transmitted along the optimal path;
[0139] During the distribution of contract settlement business data, a load balancing strategy is adopted to ensure that each subsystem evenly shares the contract settlement business data processing tasks, and load balancing is performed based on polling, random or weighted strategies to avoid overloading of a single subsystem.
[0140] The working principle of the above technical solution is: when configuring the data transmission and return path, the network environment and system architecture must be fully evaluated first. The evaluation content includes key indicators such as current network bandwidth, latency and stability. Bandwidth determines the rate of data transmission, latency reflects the delay of data transmission, and stability ensures that the network connection is not easily disconnected. Through these evaluations, it can be determined whether there are problems such as network partitioning (different areas in the network cannot access each other) or firewall restrictions (network devices restrict the transmission of specific data packets). If these problems are found, corresponding optimization measures need to be taken.
[0141] Analyzing the functional requirements and communication protocols of each subsystem of the system is the basis for ensuring smooth data exchange. For example, different subsystems may use different communication protocols (such as HTTP, TCP, MQTT, etc.), so it is necessary to ensure that these protocols are compatible and meet the needs of data transmission. Protocol analysis helps to understand the data format, exchange method and processing flow, and ensure the efficiency and stability of the data exchange process.
[0142] In the SpringBoot framework, an interceptor is used to intercept contract settlement business data. The role of the interceptor is to uniformly process and verify the data. After receiving the contract settlement business data, the interceptor first parses the data format to ensure that the data conforms to the expected structure and format. For example, if the contract settlement data should be in JSON format, the interceptor will check whether the data conforms to this format.
[0143] After parsing the data, the next step is to filter the data to remove invalid or abnormal data. Invalid data may be data with incorrect format, and abnormal data may refer to data that exceeds the expected range or does not conform to business logic. The purpose of data filtering is to ensure that the system will not cause errors due to invalid data during subsequent processing, and to ensure the accuracy and validity of the data.
[0144] The filtered valid data will be encapsulated into messages and distributed to the target subsystem. The system supports dynamic routing selection based on the configuration file, that is, the optimal target subsystem is selected according to the predefined rules in the configuration file. This ensures that data is transmitted along the optimal path and avoids data transmission bottlenecks or delays caused by improper path selection.
[0145] In the process of contract settlement business data distribution, load balancing strategy is adopted to ensure that each subsystem evenly shares the processing tasks. Load balancing can be achieved through a variety of strategies, such as polling (distributing data to different subsystems in sequence), random (randomly selecting subsystems) or weight strategy (assigning more or less tasks according to the capabilities of the subsystems). Load balancing can effectively avoid overloading of a single subsystem, thereby improving the overall processing capacity and stability of the system.
[0146] The beneficial effects of the above technical solution are: by evaluating the network environment and system architecture, potential problems in the network (such as bandwidth bottlenecks, excessive latency or firewall restrictions, etc.) can be discovered and solved in a timely manner, thereby improving the efficiency and reliability of system data transmission. This evaluation ensures that data is transmitted smoothly on the network and avoids data loss or delays due to network failures. By analyzing the functional requirements and communication protocols of each subsystem, it can be ensured that the data exchange between different subsystems is smooth, avoiding data loss or errors caused by protocol incompatibility. This can improve the efficiency and stability of data exchange and ensure the smooth progress of the system's business processes. Using the SpringBoot interceptor mechanism for unified reception and processing of contract settlement business data can ensure that the data format and structure meet expectations and avoid invalid or abnormal data from entering the system. The data filtering function can improve the data security and accuracy of the system and prevent invalid data from affecting subsequent processing processes.
[0147] In another embodiment, the engineering management system automatically sends the contract settlement business data to the data platform through the message queue MQ, including:
[0148] The control engineering management system extracts the initial contract settlement business data from the contract settlement business module and formats the contract settlement business data into the message format transmitted by the message queue MQ;
[0149] Determine the transmission status and priority of the current contract settlement business data. The status includes pending transmission status and transmitted status. The priority is used to determine the order of transmission.
[0150] The formatted contract settlement business data is sent to the data platform through MQ, and the status update during the transmission process is monitored until the transmission status of all data sets is updated to the transmitted status, or the preset number of errors reaches the threshold;
[0151] The control data platform receives the contract settlement business data from MQ, stores the contract settlement business data in the designated data storage area, and updates the storage status information;
[0152] The financial sharing platform extracts contract settlement business data from the data platform through a preset interface, determines the integrity and consistency of the extracted data set, and ensures that the data is accurate;
[0153] According to business needs, the financial sharing platform writes the extracted contract settlement business data into the designated location of the system.
[0154] Among them, determining the transmission status and priority of the current contract settlement business data includes:
[0155] Determine the transmission status of the current contract settlement business data. The status includes the pending transmission status and the transmitted status. It is calculated by the following formula:
[0156] S=f(T,C,L)
[0157] Among them, S represents the transmission status, T represents the timestamp of data extraction, C represents the data integrity check value, L represents the network load, and the function f is used to comprehensively evaluate these parameters to determine the transmission status;
[0158] Determine the priority of the current contract settlement business data. The priority is used to determine the order of transmission. Generate a transmission plan list based on the transmission status and priority, and output the list;
[0159] During the transmission process, the transmission status and priority of contract settlement business data are monitored in real time, and the transmission plan is dynamically adjusted according to network conditions and transmission feedback to ensure the efficiency and reliability of data transmission;
[0160] If a transmission failure or anomaly is detected, the transmission status and priority will be updated and the transmission task will be rescheduled until all contract settlement business data is successfully transmitted or the preset retry threshold is reached.
[0161] The working principle of the above technical solution is as follows: Contract settlement business data refers to various settlement information related to the contract after the contract is completed. The control engineering management system extracts this data from the contract settlement business module. The extracted data usually exists in the form of database tables, data records, etc. The system will extract this data and prepare for subsequent processing and transmission.
[0162] Formatting is to convert the extracted contract settlement business data into a specific format that can be transmitted through a message queue (MQ). A message queue is a message intermediary tool that allows application systems to transmit data asynchronously, ensuring the reliability and scalability of data transmission. Here, data is formatted into messages (i.e., the serialized form of data), so that it can be transmitted in an efficient and asynchronous manner through a message queue.
[0163] Each contract settlement business data will have a "transmission status" during the transmission process, including "to be transmitted" and "transmitted". At the beginning of the transmission, the data status is "to be transmitted", and after the transmission is successful, the status will be updated to "transmitted". The priority is used to determine which data is transmitted first, which may be set according to the business urgency or other priority rules.
[0164] The formatted data is pushed to the message queue and transmitted to the data platform via MQ. The monitoring system will track the data transmission status in real time. Once the data transmission is successful, the status will be updated to "transmitted"; if a transmission exception occurs, it will be retried until the preset error threshold is reached. If it still fails, the error will be recorded and an alarm will be triggered. The data platform will receive the contract settlement business data from the message queue and store it in the designated data storage area. The data platform is a system that centrally manages data, usually a database or distributed storage system. During the storage process, the platform will record the storage status of the data to ensure that the data is saved as required.
[0165] The financial sharing platform extracts contract settlement business data from the data platform through a preset interface (such as API or database query). When extracting, the financial sharing platform will verify the integrity (whether there is missing data) and consistency (whether the data is coordinated with each other) of the data to ensure that the data is correct. After ensuring the integrity and consistency of the data, the financial sharing platform will write the extracted data to a designated location in the system according to business needs. For example, it can be the account module, report module, etc. in the financial system.
[0166] The beneficial effects of the above technical solution are: data transmission through message queues (MQ) can realize asynchronous transmission and data caching, avoid blocking problems that may occur in synchronous transmission, and improve the efficiency of the system. In addition, MQ's reliable transmission mechanism can ensure that data will not be lost during transmission, and maximize the integrity of the data. Real-time monitoring of transmission status, priority setting and error retry mechanism can help to timely discover problems in transmission and ensure that data can be efficiently and securely transmitted to the data platform. By setting a threshold for the number of errors, infinite retries caused by occasional errors can also be avoided. The data platform centrally stores and manages contract settlement business data, which can uniformly manage all data, simplify data backup and recovery, and ensure data security and consistency. Real-time updates of storage status also help data management and operation and maintenance personnel quickly grasp the status of the data.
[0167] In another embodiment, automatically filling in data and generating relevant financial voucher information includes:
[0168] Querying a preset rule and template library to determine at least one association rule between the contract settlement business data and the financial voucher information;
[0169] Obtain the rule category corresponding to the association rule, which includes: data filling rule and voucher generation rule;
[0170] When the rule category corresponding to the association rule is a data filling rule, the contract settlement business data is analyzed based on a preset filling model to obtain first filling information;
[0171] When the rule category corresponding to the association rule is a voucher generation rule, the voucher template and voucher attributes corresponding to the contract settlement business data are obtained;
[0172] Split the voucher template into multiple template items, and at the same time, obtain the sequence identifiers corresponding to the template items;
[0173] Obtain a preset template line, and set the template items on the template line accordingly based on the sequence identifier;
[0174] Extract features from template items to obtain multiple template features;
[0175] Obtain a necessary feature library corresponding to the credential attribute, match the template feature with the feature in the necessary feature library, and if the match is met, use the corresponding template item as a filling item. At the same time, obtain at least one filling item corresponding to the matched feature, and the filling item includes: filling direction, filling range and filling strategy;
[0176] Select the template item corresponding to the filling range in the filling direction of the filling item on the template line and use it as the filling item;
[0177] Based on the filling strategy, fill the filling item, and if the filling is successful, obtain the second filling information corresponding to the filling strategy;
[0178] Otherwise, obtain the impact value corresponding to the filling strategy;
[0179] Among them, the influence value formula corresponding to the filling strategy is:
[0180]
[0181] Where I represents the impact value of the filling strategy, ω i represents the weight of the i-th feature item, e i represents the error deviation of the i-th feature item (e.g., the difference from the target value), and n represents the number of filler items. i and deviation e i The weighted sum of is used to calculate the total impact value on the business process when filling fails;
[0182] The first filling information, the second filling information and the impact value are cumulatively calculated to obtain the voucher information corresponding to the contract settlement business data, thereby completing the voucher generation.
[0183] Among them, matching the template features with the features in the necessary feature library includes:
[0184] The calculation is based on cosine similarity, and the formula is as follows:
[0185]
[0186] A and B represent the vector representation of template features and necessary features respectively. i and b i Represent the i-th component of vectors A and B respectively, m represents the dimension of the feature vector, and the similarity between the template features and the features in the necessary feature library is calculated through the cosine similarity formula to determine whether they match.
[0187] The working principle of the above technical solution is: query the association rules between contract settlement business data and financial voucher information from the preset rules and template library.
[0188] Association rule categories: Data filling rules: used to fill in data gaps or supplement incomplete information. Voucher generation rules: used to standardize and generate templates and attributes of financial vouchers.
[0189] Data filling rules: Analyze the contract settlement business data based on the filling model and generate the first filling information.
[0190] Voucher generation rules: obtain the voucher template and voucher attributes corresponding to the contract settlement business data, laying the foundation for subsequent voucher generation.
[0191] The voucher template is broken down into multiple template items and arranged according to the corresponding sequence identifiers.
[0192] Based on the preset template line (which defines the arrangement path of the template items), the template items are placed on the template line according to the sequential identification.
[0193] Extract features from template items to obtain template features. Match template features with necessary feature libraries. If the match is successful, then: use the matching template items as filler items.
[0194] Get the corresponding filling direction, filling range, and filling strategy.
[0195] Fill the fill items according to the fill strategy.
[0196] After successful filling, the second filling information is generated; otherwise, the impact value of unsuccessful filling is calculated.
[0197] Information accumulation and voucher generation
[0198] The first filling information, the second filling information and the impact value are cumulatively calculated to generate final voucher information corresponding to the contract settlement business data.
[0199] Complete the credential generation process.
[0200] Among them, the filling model represents a data analysis method used to fill in data gaps or complete undefined information. Necessary feature library: contains a specific feature set required for financial voucher generation or data filling. Template line: a logical path that defines the order of arrangement of template items. Filling direction: the priority or logical direction of data filling (such as vertical or horizontal). Impact value: the error when filling is not successful or the potential impact on subsequent processing.
[0201] The beneficial effects of the above technical solution are: through association rules and filling models, manual intervention can be effectively reduced, and the automation and accuracy of data processing can be improved. According to different rule categories (data filling rules or voucher generation rules), it can be flexibly adapted to various business scenarios. The splitting and feature matching of voucher templates ensure that the generated financial vouchers are highly structured and standardized, which is convenient for subsequent auditing and analysis. By evaluating the risk of filling failure through impact value, feedback can be provided for optimizing the filling strategy and improving the robustness of the overall system.
[0202] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.
Claims
1. A data exchange method between a domestic engineering management information system and a financial sharing platform, characterized in that: include: S101: Based on the data transmission requirements between the engineering management information system and the financial sharing platform, build the corresponding data interface; S102: The financial sharing platform extracts message data from the data platform through the data interface, and writes the message data into a designated location of the system according to business requirements; S103: The financial sharing platform automatically fills in data and generates corresponding financial vouchers according to pre-set rules and templates; S104: For different types of message data, several standard interfaces are preset to support data interaction; S105: According to the current network environment and system architecture, a distribution path for returning message data is set.
2. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: After step S104, the following steps are also included: After the data interface is triggered, the system automatically starts the message data transmission. If the message data transmission fails, the system will automatically retry after two hours. Set two interface triggering modes: automatic and manual. The automatic interface triggering mode means that when the business process in the engineering management system is completed, the system automatically triggers data transmission. The manual interface triggering mode means that the business personnel trigger the message data transmission process after manually entering the payment slip.
3. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: Step S101 includes: S1011: Obtain contract settlement business data related to project construction in the engineering management information system; S1012: The engineering management information system transmits the acquired contract settlement business data to the data platform through the data interface; S1013: The financial sharing platform obtains the contract settlement business data from the data platform through the data interface, and automatically generates financial voucher information according to the preset rules; S1014: Transmit the financial voucher information to the SAP system and complete the construction of the data interface transmission method.
4. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: Step S102 includes: The engineering management system automatically sends the contract settlement business data to the data platform through the message queue MQ. The financial sharing platform extracts the contract settlement business data from the data platform through the set data interface, and writes the contract settlement business data to the designated location of the system according to business needs to ensure the correct flow of data.
5. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: Step S103 includes: In the engineering management system, after the contract settlement business data processing is completed, the data is automatically transmitted to the financial sharing platform through the preset data interface. The financial sharing platform automatically fills in the data and generates relevant financial voucher information according to the pre-set rules and templates, completing the closed loop of contract settlement.
6. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: Step S104 includes: Different standard interfaces are preset for different types of contract settlement data. The standard interfaces include those for processing contract advance payments with or without supervision payment data in the engineering management system, invoice settlement without order, and purchase payment reimbursement bills; the transmission of attachment information between the engineering management system with or without supervision payment data and the imaging system interface; the reimbursement status feedback interface between the engineering management system and the financial sharing platform; and the generation of financial voucher information between personal reimbursement data or public payment voucher data of the financial sharing platform and the voucher page of the engineering management system.
7. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 1 is characterized in that: Step S105 includes: According to the current network environment and system architecture, a unified receiving interceptor based on SpringBoot is designed for the contract settlement business data feedback processing of each subsystem to receive and parse the returned data. The contract settlement business data is authenticated, filtered and encapsulated through the configured rules. The system dynamically identifies the rules through the configuration file. The system intelligently distributes the data to each subsystem according to the type and target of the returned contract settlement business data. At the same time, a load balancing strategy is adopted to perform load balancing operations on the contract settlement business data.
8. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 7 is characterized in that: Contract settlement business data transmission and processing for each subsystem, including: When configuring data transmission and return paths, evaluate the network environment and system architecture, assess the current network bandwidth, latency, and stability, and ensure that there are no network partitions or firewall restrictions. At the same time, analyze the functional requirements and communication protocols of each subsystem to ensure high efficiency and stability during data exchange; Through the SpringBoot interceptor mechanism, a unified contract settlement business data receiving and processing module is designed. After receiving the contract settlement business data, the interceptor parses the contract settlement business data to ensure that the contract settlement business data conforms to the expected format and structure, and then filters the contract settlement business data to remove invalid or abnormal data, encapsulates the filtered messages and distributes them to the target subsystem. The system supports dynamic routing selection based on configuration files to ensure that messages are transmitted along the optimal path; During the distribution of contract settlement business data, a load balancing strategy is adopted to ensure that each subsystem evenly shares the contract settlement business data processing tasks, and load balancing is performed based on polling, random or weighted strategies to avoid overloading of a single subsystem.
9. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 4 is characterized in that: The engineering management system automatically sends contract settlement business data to the data platform through the message queue MQ, including: The control engineering management system extracts the initial contract settlement business data from the contract settlement business module and formats the contract settlement business data into the message format transmitted by the message queue MQ; Determine the transmission status and priority of the current contract settlement business data. The status includes pending transmission status and transmitted status. The priority is used to determine the order of transmission. The formatted contract settlement business data is sent to the data platform through MQ, and the status update during the transmission process is monitored until the transmission status of all data sets is updated to the transmitted status, or the preset number of errors reaches the threshold; The control data platform receives the contract settlement business data from MQ, stores the contract settlement business data in the designated data storage area, and updates the storage status information; The financial sharing platform extracts contract settlement business data from the data platform through a preset interface, determines the integrity and consistency of the extracted data set, and ensures that the data is accurate; According to business needs, the financial sharing platform writes the extracted contract settlement business data into the designated location of the system.
10. The data exchange method between the localized engineering management information system and the financial sharing platform according to claim 5 is characterized in that: Automatically populate data and generate relevant financial voucher information, including: Querying a preset rule and template library to determine at least one association rule between the contract settlement business data and the financial voucher information; Obtain the rule category corresponding to the association rule, which includes: data filling rule and voucher generation rule; When the rule category corresponding to the association rule is a data filling rule, the contract settlement business data is analyzed based on a preset filling model to obtain first filling information; When the rule category corresponding to the association rule is a voucher generation rule, the voucher template and voucher attributes corresponding to the contract settlement business data are obtained; Split the voucher template into multiple template items, and at the same time, obtain the sequence identifiers corresponding to the template items; Obtain a preset template line, and set the template items on the template line accordingly based on the sequence identifier; Extract features from template items to obtain multiple template features; Obtain a necessary feature library corresponding to the credential attribute, match the template feature with the feature in the necessary feature library, and if the match is met, use the corresponding template item as a filling item. At the same time, obtain at least one filling item corresponding to the matched feature, and the filling item includes: filling direction, filling range and filling strategy; Select the template item corresponding to the filling range in the filling direction of the filling item on the template line and use it as the filling item; Based on the filling strategy, fill the filling item, and if the filling is successful, obtain the second filling information corresponding to the filling strategy; Otherwise, obtain the impact value corresponding to the filling strategy; The first filling information, the second filling information and the impact value are cumulatively calculated to obtain the voucher information corresponding to the contract settlement business data, thereby completing the voucher generation.