Text / China Pacific Property & Casualty Insurance Co., Ltd. Guizhou Branch, Ma Fei, Chen Jiayong, He Lin, Gan Xing
The construction of high-standard farmland is an important starting point for implementing the spirit of the General Secretary's important instructions and the decisions and arrangements of the Party Central Committee and the State Council, and deepening the strategy of "storing grain on the ground and storing grain in technology", and it is also the guarantee of national food security and economic and social development. In order to further implement the strategy of comprehensively promoting rural revitalization, with the strong support of the Guizhou Provincial Department of Agriculture and Rural Affairs and the help of the Tongren Municipal Bureau of Agriculture and Rural Affairs, our company has realized the insurance of 10,000 mu of high-standard farmland under construction in Bijiang District and 67,500 mu of high-standard farmland under construction in Shiqian County, so as to explore a new model of insurance project operation in line with the potential defects of high-standard farmland construction projects in Guizhou Province.
However, in the absence of system support, the daily business operation time of high-standard farmland IDI practitioners is long, and the timeliness is difficult to be guaranteed; at the same time, it is difficult to form dynamic project data reports in real time, and the analysis and summary are overly dependent on manual work, which cannot meet the personalized needs and affect the company's business decision-making; the information management of project archives is not realized, and most of the project information data are now stored on the computer hard disks of the personnel of each branch, the data is scattered, the risk of loss is greater, and the information results cannot be shared interactively, and the internal management needs to be improved urgently。
Project significance
In order to strengthen the function of high-standard farmland IDI project management and control, insurance companies urgently need to build a platform that can effectively support their development strategy, so that high-standard farmland IDI project management standardization, process standardization, and circulation automation can be further released, and work efficiency and work quality can be improved, and at the same time, it can meet the personalized use requirements of insurance companies in terms of leadership cockpit, data management, task management, punch card management, audit management, report management, message management, and underwriting claims. Therefore, when designing the system, it is necessary to consider the whole situation and do a good job of top-level planning, so that the system has good adaptability and scalability. Through the construction of this project, all the business processes of the insurance company's high-standard farmland IDI project have been online and digitized, and the work efficiency and work quality have reached a new level. Compared with the same industry, our company's current IT technology application depth is not enough, and the efficiency is not high, resulting in low production capacity and high labor costs, and we urgently need technology empowerment to enhance competitiveness. Therefore, through the independent development of high-standard farmland IDI system, it helps the company to quickly realize transformation and upgrading, and achieve the strategic goal of "leading the industry and leading the best".
Requirements gathering and analysis
1. System goals
The main goal of developing this system is to strengthen the management and control function of the insurance company on the high-standard farmland IDI project, build the high-standard farmland IDI system into a platform that can effectively support the business development of the insurance company, comprehensively improve the standardization of the high-standard farmland IDI project management, standardize its business, standardize the process, and automate the circulation, further improve the work efficiency and work quality, and focus on the task management, data management, punch-in management, audit management, etc. Functions such as report management, underwriting and claims, and message management can achieve comprehensive analysis and accurate control of high-standard farmland IDI projects in the province.
2. Construction principles
In the process of construction of high-standard farmland IDI system, adhere to the vertical integration, hierarchical management control, data-driven business, support business decision-making, follow the construction principle of integration, platform, modularization, closely focus on the main line of high-standard farmland IDI project management, unified planning, ensure the "integrity, consistency and effectiveness" of project information, and implement scheduling development and step-by-step promotion at the implementation level, covering the use needs of insurance institutions, TIS institutions, management and maintenance teams, maintenance teams and agricultural and rural departments.
3. Functional requirements
The system is divided into 7 subsystems, 10 functional modules and 50 functional points. Among them, the workbench needs to realize functions such as quick entry, to-do tasks, completed tasks, message notifications, system announcements, and leadership cockpits.
Data management needs to realize the query and retrieval of project-related information such as project code, project name, project stage, construction address and other information.
Task management needs to make detailed records of the project name, administrative village name, small place name, facility category, management team, inspection personnel, inspection deadline of the task and other relevant information, and query and retrieval and task assignment through the name of the project and the name of the administrative area.
Punch-in management needs to add, modify, and delete punch-in points, and record the longitude and latitude, number of punch-in points, and clock-in frequency of each item in detail.
Audit management needs to realize the approval function of inspection tasks and related reports during the construction period, inspection tasks and related reports during the management and maintenance period.
Report management needs to record the detailed information of the project quality report at each stage of the project, and search and query through fields such as project code, project name, project stage, first-level directory, second-level catalog, and report name.
Underwriting claims need to realize a detailed record of the project code, project name, subject category, latitude and longitude, surveyor and other information of the claim investigation, and query and retrieval through the fields of project code, project name, facility category, and claim submitter.
Message management needs to implement the message push function, feedback the recipient's viewing status information, and search and query through fields such as message code, message summary, and pusher.
System management needs to implement functions such as user management, role management, menu management, department management, dictionary management, basic data, parameter setting, and log management.
4. Performance requirements
The users of the system include insurance institutions, TIS institutions, management and maintenance teams, maintenance teams, agricultural and rural departments, so it is necessary to meet the needs of internal and external network office computer users, but also to meet the needs of mobile phone users anytime and anywhere, the total number of users in the province exceeds 1000, concurrent access is considered according to 10% of the total number of users, the peak is 100, the page response time is less than 0.1 seconds, and the system availability requirements are greater than 99.99%. Therefore, two web application servers are deployed in a cluster in the DMZ area to ensure high reliability and stability of user access, and WeChat Mini Programs are deployed on Tencent Cloud servers, and communicate with the intranet servers through the Nginx reverse proxy server in the DMZ area of the insurance company's private cloud, so as to ensure that the mobile terminal can receive inspection tasks and upload inspection photos, audio, video and other files anytime and anywhere.
System design and implementation
1. System design
(1) Prototyping. The system is designed using the rapid prototyping method, through the preliminary research and analysis of the list of system functions provided by the requirements specification specification, quickly generate workbench, data management, task management, punch management, audit management, report management, underwriting claims, message management, system management 9 functional modules and the system prototype of the mobile WeChat applet, and the 50 function points of the system are displayed in detail through the secondary menu and tertiary menu, and the business process and approval process involved in the system are completely presented.
(2) Architecture design. The system adopts B/S architecture, including PC system and mobile applet. The system logic architecture is divided into five levels, namely the front-end UI, the display layer, the business layer, the data layer, and the runtime environment (as shown in Figure 1).
Figure 1 System architecture
In terms of data architecture design, in order to ensure the access efficiency of structured data and unstructured data, structured data is stored in the MySQL database server, and unstructured data is stored in the Minio file server. At the same time, in order to ensure the security of system data and files, the data in the system background database and the files in the file server are regularly backed up to the DG database through the automatic backup mechanism to prevent data and files from being lost or damaged.
In terms of physical architecture design, in order to ensure the safe and stable operation of the system, one Nginx reverse proxy server is deployed at the exit to communicate with the external network, the front-end web server is deployed in the DMZ_WEB area, the back-end business server and file server are deployed in the DMZ_APP area, and the database server is deployed in the intranet DB area.
(3) Table structure design. The database uses MySQL 8.0.33 and the character set is UTF8. The system defines 12 system tables, including user information table, department table, role information table, menu table, user and role association table, role and menu association table, role and department association table, operation log table, dictionary type table, dictionary data table, scheduled task table, and scheduled task log table, according to various data details. At the same time, 22 business tables have been defined, including task master table, task sub-table, sub-task detail table, photo information table, video information table, audio information table, problem list table, punch-in point management table, punch-in point detailed table, claim underwriting table, quality report management table, attachment table, administrative division table, project information table, TIS organization information table, TIS organization personnel table, management team information table, management team personnel table, maintenance team information table, maintenance team personnel table, message push table, government personnel information table.
(4) Safety design. Since this system is the business management system of insurance companies, it involves a lot of sensitive information, so a series of security measures have been taken to ensure the security of the system.
In terms of database security, the database username and password are encrypted, and sensitive information such as ID card number, mobile phone number, and home address of table data is desensitized. The database server is deployed in the private cloud zone, and database access is restricted to specific IP addresses. At the same time, table permission control is carried out to assign differentiated table permissions to different operators, including read-write permissions and read-only permissions, so as to ensure data security.
In terms of system access control, it is controlled from the aspects of personnel permissions, menu permissions, and function permissions. Personnel authority control: Hierarchical control of personnel is achieved by configuring the adding, deleting, and modifying permissions of personnel at different levels of management personnel. Menu permission control: Establish the corresponding role group, assign the corresponding function menu according to the role group to which the operator belongs, and do not display the menu for the functions that are not authorized to use. Function permission control: Assign different operation permissions to different operators according to their roles, so that only the corresponding function buttons are displayed under the account, and other function buttons are hidden, for example, ordinary employees only have the button to view the quality inspection report, but not the button to modify the quality inspection report.
In terms of system release permission control, the system adopts a B/S multi-layer structure, and all system codes are placed on the server, and only authorized developers can log in to the server through bastion hosts to change the code and publish the system. Personnel who enter the system management background must pass the dual identity verification of ordinary user identity authentication and root user identity authentication on the server, and randomly generate complex passwords in the way of one password at a time to prevent brute-force attacks.
2. Technical implementation
(1) Technology selection. The development language of this system adopts Java and JavaScript, the development toolkit uses JDK 1.8 and Node 16.0.0, the development platform adopts IDE and Wechat Devtools, the database adopts MySQL 8.0.33, the middleware uses Nginx 1.12.1, Minio, Redis 6.2.4, Maven 3.6.3, and the front-end framework adopts vue2 and Element-ui 2.15.11, the back-end framework uses spring-boot and mybatis-plus, and the applet framework uses uniapp, uview-ui, amap-wx.js, etc.
The system uses watermark camera technology to punch in, attaches information such as project name, project address, facility category, administrative area, geographical coordinates, shooting time, name of shooting personnel, mobile phone number and other information to the on-site photos, and can only call the watermark camera on the high-standard farmland IDI system to take photos on the spot, and cannot upload other photos in the gallery, so as to ensure the authenticity and accuracy of inspection punch cards and claims investigation materials (as shown in Figure 2).
Figure 2 On-site inspection check-in photos sent back by the watermark camera
(2) Implementation process. After a month of demand research and analysis, the system prototype was designed, and the user was repeatedly communicated and confirmed, and the "High Standard Farmland IDI System Requirements Specification" was completed and passed the review. Then, after two months of system design, the "Detailed Design Specification" was completed, and according to the development plan, the project team completed the program coding and testing of all modules after three months of intense coding testing. Finally, after system debugging and data initialization, the system was successfully released online through blue-green deployment and grayscale release. During the trial process, we continued to track the feedback and optimization suggestions of users, continuously iteratively updated, optimized and improved the system, and finally reached the design goals of the system and the expectations of users after half a year.
(3) Operating environment. The operating system version of this system is Red Hat Enterprise Linux 7, the application container is Tomcat 9.0.63, the Java runtime environment is JRE1.8, the file service is Minio, and the database is MySQL 8.0.33.
Because the system should not only meet the needs of internal user insurance agency personnel, but also meet the use needs of external user TIS institutions, management and guard teams, maintenance teams and relevant personnel of the province's agricultural and rural departments. Therefore, the system needs to communicate with the external through the Nginx reverse proxy server deployed in the DMZ area, and at the same time enable the network control policy for the Nginx reverse proxy server to access the web server, the network control policy for the WEB server to access the backend application server, and the network control policy for the backend application server to access the file server and the intranet database server. The WeChat Mini Program is deployed on Tencent Cloud servers, and communicates with the intranet server through the Nginx reverse proxy server in the DMZ area of the insurance company's private cloud, meeting the requirements of mobile terminal use anytime and anywhere.
Summary and outlook
Based on the concepts of agile development, continuous integration and continuous delivery, this paper mainly studies the practical methods and application value of the experimental system of high-standard farmland IDI system in the insurance industry, adopts the rapid prototyping method for design and exploration, and continuously iterates, updates and optimizes through blue-green deployment and grayscale release.
In the process of demand analysis and prototype design of high-standard farmland IDI system, he has repeatedly communicated with the company's government security business department, group customer comprehensive marketing department and other relevant personnel, confirmed the requirements, completed the preparation of the "High-standard Farmland IDI System Requirements Specification" and the design of the system prototype, and successfully passed the expert review. After that, the outline design, detailed design, coding test, system debugging, and finally released and delivered to users for promotion and use, which won unanimous praise from the leaders of the insurance company and the majority of employees. In the future, the system will use mathematical modeling, introduce AI algorithms, conduct engineering big data analysis, mine potential rules, reshape business processes, and improve the efficiency and quality of underwriting claims, becoming a strategic support platform for insurance companies to expand their business, transform and upgrade.
(This article was published in the second half of March 2024)