Insurance data processing method, device and equipment

Abstract

The invention discloses an insurance data processing method, device and equipment, the method is applied to the technical field of insurance, and the method comprises the following steps: detecting input data of an insurance page of a website employee; performing integrity and accuracy verification on the input data by adopting a form verification algorithm to obtain a data verification result; under the condition that the data verification result represents that the input data is normal, storing the input data; constructing preset mail templates respectively corresponding to the plurality of preset insurance information types in a mail template library; searching a target mail template corresponding to a target insurance information type in the mail template library according to the target insurance information type of the current insurance information; and generating a target mail according to a target mail template and the current insurance information, and sending the target mail to an insurance organization. According to the invention, the insurance workload and the insurance maintenance cost are reduced.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device and equipment for processing insurance data. Background Art

[0002] At present, logistics companies have to purchase accident insurance for new employees and renew accident insurance for old employees every month, but there are the following problems: 1. Distribution centers and outlets need to organize employee information at the end of each month for insurance or renewal at the beginning of the next month, which creates extra workload.

[0003] 2. After insurance is taken out, a dedicated person is required to liaise with the insurance company and hand over employee information to the insurance company. New employee information needs to be newly insured, old employee information may have information changes, and resigned employee information needs to be uninsured, resulting in increased labor costs.

[0004] After insurance is taken out, there is no unified platform or channel to check the insurance information of employees. There may be omissions, wrong insurance, etc. If you miss the insurance time of the current month, you can only take out insurance next month, which greatly reduces the timeliness. Summary of the invention

[0005] The present invention provides an insurance data processing method, device and equipment, which reduces the insurance workload and insurance maintenance costs.

[0006] In one aspect, the present invention provides a method for processing insurance data, the method comprising: Check the input data of the branch employee insurance enrollment page; Using a form validation algorithm to verify the integrity and accuracy of the input data to obtain a data validation result; If the data verification result indicates that the input data is normal, storing the input data; Constructing multiple preset email templates corresponding to the preset insurance information types in the email template library; According to the target insurance information type of the current insurance information, searching the email template library for a target email template corresponding to the target insurance information type; A target email is generated according to the target email template and the current insurance information, and the target email is sent to the insurance organization.

[0007] In some embodiments, the use of a form validation algorithm to validate the integrity and accuracy of the input data to obtain a data validation result includes: If the input data is key information of the branch staff, a regular expression is used to match and verify the key information to obtain a first data verification result; If the input data is not critical information, verify the input data using a preset algorithm to obtain a second data verification result; The method further comprises: If the first data verification result is a successful verification result, using a data encryption algorithm to encrypt and store the sensitive information in the key information; If the second data verification result is a successful verification result, the non-critical information is stored in an unencrypted manner.

[0008] In some embodiments, the input data includes the critical information and the non-critical information, and the method further includes: If both the first data verification result and the second data verification result are successful verification results, the sensitive information in the key information is encrypted and stored using a data encryption algorithm, and the non-key information is not encrypted and stored; If at least one of the first data verification result and the second data verification result is a verification failure result, the key information and the non-key information are not stored.

[0009] In some embodiments, the method further comprises: When the data verification result indicates that the input data is abnormal, generating abnormal prompt information; Receive modification information of the abnormal prompt information updated by the user; If the modification information is verified to be correct, sending the modification information to the backend server; Based on the multi-condition query algorithm, generate multi-condition combination information of the insurance information to be checked; Generate an SQL query statement based on the multiple condition combination information; Based on the SQL query statement, the insurance information to be checked is searched in a preset database.

[0010] In some embodiments, the method further comprises: When the user triggers the invalidation operation for the insurance policy, the invalidation operation is delayed through the task scheduling algorithm; Based on the timed task trigger, the accumulated delay time of the invalid operation is detected. When the accumulated delay time reaches the target time, the status field of the employee insurance information is updated, and the corresponding associated operation is triggered; When synchronizing the insurance information of resigned employees at failed outlets, use the data synchronization algorithm to obtain the latest resigned employee information and existing employee insurance information from the human resources system; A difference comparison algorithm is used to compare the latest resigned employee information and the existing employee insurance information to determine newly resigned employees, and the insurance information status of the newly resigned employees is updated to an invalid state.

[0011] In some embodiments, sending the target email to the insurance organization includes: Generate an email sending task according to the target email; Using a multithreading or asynchronous processing mechanism, sending the email sending task to a background thread or an asynchronous task processor; The target email is sent to the insurance organization based on the background thread or the asynchronous task processor.

[0012] In some embodiments, the method further comprises: Calculate the deductible fees based on the employee's insurance information and obtain the employee's account balance from the financial system or bank interface; Performing real-time deduction processing according to the account balance and the deductible fees through an amount calculation algorithm; Use data screening algorithms to filter out valid employee insurance information from the database; When updating the effective time of the insurance, use the date calculation algorithm to calculate the date range of the next period and update it to the corresponding insurance information record; A batch update algorithm is used to batch update the screened renewal information into the database.

[0013] Another aspect provides an insurance data processing device, the device comprising: Data detection module, used to detect the input data of the branch employee insurance application page; A data verification module is used to verify the integrity and accuracy of the input data using a form verification algorithm to obtain a data verification result; A data storage module, used for storing the input data when the data verification result indicates that the input data is normal; An email template building module, used to build preset email templates corresponding to multiple preset insurance information types in the email template library; A target template search module, used for searching the target email template corresponding to the target insurance information type in the email template library according to the target insurance information type of the current insurance information; The mail sending module is used to generate a target mail according to a target mail template and the current insurance information, and send the target mail to the insurance organization.

[0014] In some embodiments, the data verification module includes: A first verification unit, configured to, if the input data is key information of a branch employee, use a regular expression to match and verify the key information to obtain a first data verification result; A second verification unit, configured to verify the input data using a preset algorithm to obtain a second data verification result if the input data is not critical information; The device also includes: A first encryption module, configured to encrypt and store the sensitive information in the key information using a data encryption algorithm if the first data verification result is a successful verification result; The second encryption module is used to store the non-critical information in an unencrypted manner if the second data verification result is a successful verification result.

[0015] In some embodiments, the input data includes the key information and the non-key information, and the apparatus further includes: A first storage module is used for encrypting and storing the sensitive information in the key information by using a data encryption algorithm, and storing the non-key information in an unencrypted manner if both the first data verification result and the second data verification result are successful verification results; The second storage module is used for not storing the key information and the non-key information if at least one of the first data verification result and the second data verification result is a verification failure result.

[0016] In some embodiments, the apparatus further comprises: An abnormal information generation module, used for generating abnormal prompt information when the data verification result indicates that the input data is abnormal; An information receiving module, used to receive modification information of the abnormal prompt information updated by the user; An information sending module, used for sending the modification information to the back-end server when the modification information is verified to be correct; A combination information generation module is used to generate multi-condition combination information of the insurance information to be checked based on a multi-condition query algorithm; A statement generation module, used to generate an SQL query statement based on the multi-condition combination information; The information query module is used to search the insurance information to be queried in a preset database based on the SQL query statement.

[0017] In some embodiments, the apparatus further comprises: A delay module is used to delay the execution of the invalidation operation for the policy through a task scheduling algorithm when the user triggers the invalidation operation for the policy; An operation module, used for detecting the accumulated delay time of the failed operation based on a timed task trigger, and updating the status field of the employee insurance information when the accumulated delay time reaches a target time, and triggering a corresponding associated operation; The insurance information acquisition module is used to use the data synchronization algorithm to obtain the latest information of resigned employees and the insurance information of existing employees from the human resources system when synchronizing the insurance information of resigned employees of the failed outlets; The new employee determination module is used to use a difference comparison algorithm to compare the latest resigned employee information and the existing employee insurance information, determine the newly resigned employees, and update the insurance information status of the newly resigned employees to an invalid state.

[0018] In some embodiments, the email sending module includes: A task generating unit, used for generating an email sending task according to the target email; A task sending unit, used to send the email sending task to a background thread or an asynchronous task processor using a multi-threading or asynchronous processing mechanism; An email sending unit is used to send the target email to the insurance organization based on the background thread or the asynchronous task processor.

[0019] In some embodiments, the apparatus further comprises: The balance acquisition module is used to calculate the deductible fees based on the employee's insurance information and obtain the employee's account balance from the financial system or bank interface; A deduction processing module, used to perform real-time deduction processing according to the account balance and the deductible fees through an amount calculation algorithm; An information screening module is used to use a data screening algorithm to screen out valid employee insurance information from the database; The record update module is used to use the date calculation algorithm to calculate the date range of the next period when updating the effective time of the insurance, and update it to the corresponding insurance information record; The data update module is used to adopt a batch update algorithm to batch update the screened renewal information into the database.

[0020] On the other hand, an electronic device is provided, which includes a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement the insurance data processing method as described above.

[0021] On the other hand, a computer storage medium is provided, which stores at least one instruction or at least one program, and the at least one instruction or at least one program is loaded and executed by a processor to implement the insurance data processing method as described above.

[0022] On the other hand, a computer program product or a computer program is provided, the computer program product or the computer program includes computer instructions, the computer instructions are stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes to implement the insurance data processing method as described above.

[0023] The insurance data processing method, device and equipment provided by the present invention have the following technical effects: The present invention detects the input data of the insurance page of the branch employees; uses a form verification algorithm to verify the integrity and accuracy of the input data to obtain a data verification result; when the data verification result indicates that the input data is normal, the input data is stored; a plurality of preset email templates corresponding to each preset insurance information type are constructed in the email template library; according to the target insurance information type of the current insurance information, the target email template corresponding to the target insurance information type is searched in the email template library; a target email is generated according to the target email template and the current insurance information, and the target email is sent to the insurance organization. The present invention does not need to count employee information for insurance, and maintenance can be performed once a month for regular insurance and renewal, thereby reducing the workload. There is no need for a dedicated person to connect with the insurance company and deduct the insurance premium, thereby avoiding the increase of labor costs. Personnel information can be maintained and queried on the insurance page of the branch employees, and it can be used immediately after modification, thereby ensuring the timeliness of the data. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0025] Figure 1 It is a schematic diagram of an insurance data processing system provided in an embodiment of this specification; Figure 2 It is a flowchart of an insurance data processing method provided in an embodiment of this specification; Figure 3 is a flowchart of a method for sending the modification information to a backend server provided in an embodiment of this specification; Figure 4It is a flowchart of a method for searching the insurance information to be checked in a preset database provided by an embodiment of this specification; Figure 5 It is a flowchart of a method for sending the target email to an insurance organization provided by an embodiment of this specification; Figure 6 It is a structural schematic diagram of an insurance data processing device provided in an embodiment of this specification; Figure 7 It is a structural diagram of a server provided in an embodiment of this specification. DETAILED DESCRIPTION

[0026] The following will be combined with the drawings in the embodiments of this specification to clearly and completely describe the technical solutions in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0027] It is understandable that in the specific implementation of the present invention, data related to user information is involved. When the above embodiments of the present invention are applied to specific products or technologies, user permission or consent is required, and the collection, use and processing of relevant data need to comply with relevant laws, regulations and standards of relevant countries and regions.

[0028] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product, or server that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products, or devices.

[0029] See also Figure 1 , Figure 1 is a schematic diagram of an insurance data processing system provided in an embodiment of this specification, such as Figure 1 As shown, the insurance data processing system may include at least a server 01 and a client 02 .

[0030] Specifically, in the embodiments of this specification, the server 01 may include an independently operated server, or a distributed server, or a server cluster composed of multiple servers, and may also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), and big data and artificial intelligence platforms. Server 01 may include a network communication unit, a processor, a memory, and the like. Specifically, the server 01 may be used to store insurance information.

[0031] Specifically, in the embodiments of this specification, the client 02 may include physical devices such as smart phones, desktop computers, tablet computers, laptop computers, digital assistants, smart wearable devices, smart speakers, vehicle terminals, smart TVs, etc., and may also include software running in physical devices, such as web pages provided by some service providers to users, or applications provided by these service providers to users. Specifically, the client 02 may be used to query and modify insurance policy information online.

[0032] The following describes a method for processing insurance data of the present invention. Figure 2 It is a flowchart of an insurance data processing method provided in an embodiment of this specification. This specification provides method operation steps as described in the embodiment or flowchart, but may include more or fewer operation steps based on conventional or non-creative labor. The order of steps listed in the embodiment is only one way of executing the steps among many orders, and does not represent the only order of execution. When the actual system or server product is executed, it can be executed in sequence or in parallel (for example, in a parallel processor or multi-threaded processing environment) according to the method shown in the embodiment or the drawings. Specifically, Figure 2 As shown, the method may include: S201: Check the input data of the branch employee insurance enrollment page. In the embodiments of the present specification, the input data may include key information and non-key information of the branch employees, wherein the key information may include personal identity information, contact information, etc.

[0033] S203: Using a form verification algorithm to verify the integrity and accuracy of the input data to obtain a data verification result.

[0034] In the embodiments of the present specification, different verification algorithms may be used for different types of input data to ensure the correctness of the data verification result.

[0035] S205: When the data verification result indicates that the input data is normal, store the input data.

[0036] In the embodiment of the present specification, when the data verification result indicates that the input data is normal, the input data is stored. When the data verification result indicates that the input data is abnormal, the input data is not stored.

[0037] S207: Constructing a plurality of preset email templates corresponding to respective preset insurance information types in the email template library.

[0038] In the embodiment of the present specification, an email template library can be constructed according to preset email templates corresponding to multiple preset insurance information types.

[0039] S209: According to the target insurance information type of the current insurance information, searching the email template library for a target email template corresponding to the target insurance information type.

[0040] In the embodiments of this specification, when developing an email sending script, an email sending library (such as JavaMail API, Python's smtplib, etc.) is used, and an email template is designed. A template engine (such as Thymeleaf, Django template engine, etc.) can be used to generate personalized email content according to different insurance information.

[0041] S2011: Generate a target email according to the target email template and the current insurance information, and send the target email to the insurance organization.

[0042] In the embodiments of the present specification, the insurance organization may be an insurance company. In order to ensure the reliability of email sending, an email queue and retry mechanism is used to put emails to be sent into a queue. If the sending fails, multiple retries are performed according to a certain retry strategy (such as an exponentially increasing time interval). At the same time, the reason for the sending failure is recorded for subsequent analysis and processing.

[0043] In some embodiments, the use of a form validation algorithm to validate the integrity and accuracy of the input data to obtain a data validation result includes: If the input data is key information of the branch staff, a regular expression is used to match and verify the key information to obtain a first data verification result; If the input data is not critical information, verify the input data using a preset algorithm to obtain a second data verification result; The method further comprises: If the first data verification result is a successful verification result, using a data encryption algorithm to encrypt and store the sensitive information in the key information; If the second data verification result is a successful verification result, the non-critical information is stored in an unencrypted manner.

[0044] In some embodiments, when developing new features for the branch employee insurance application page, a form validation algorithm can be used to ensure the integrity and accuracy of the input data. For example, for key employee information (such as ID number, name, contact information, etc.), regular expressions are used for matching validation to prevent users from entering data that does not meet the specifications. At the same time, a data encryption algorithm can be introduced to encrypt and store sensitive employee information (such as ID number) to ensure information security.

[0045] In some embodiments, the input data includes the critical information and the non-critical information, and the method further includes: If both the first data verification result and the second data verification result are successful verification results, the sensitive information in the key information is encrypted and stored using a data encryption algorithm, and the non-key information is not encrypted and stored; If at least one of the first data verification result and the second data verification result is a verification failure result, the key information and the non-key information are not stored.

[0046] In some embodiments, in terms of data storage, the transaction processing mechanism of the database is used to ensure the atomicity of the newly added data, that is, either all are successfully inserted into the database, or all fail, avoiding data inconsistency problems caused by partial data insertion.

[0047] In the embodiments of this specification, in order to improve the user experience, the front-end real-time verification technology is adopted. While the user is entering data, the data is preliminarily verified using front-end languages ​​such as JavaScript, and instant feedback is given to the user whether the input meets the requirements, thereby reducing the number of times the user needs to re-fill the form due to errors after submission.

[0048] For the layout and interaction of the page, responsive design is used to automatically adjust the layout of page elements according to different device screen sizes and resolutions, making it easier for users to use the page on various devices.

[0049] In some embodiments, Figure 3 As shown, the method also includes: S301: generating abnormality prompt information when the data verification result indicates that the input data is abnormal; S303: receiving modification information of the abnormal prompt information updated by the user; S305: When the modification information is verified to be correct, the modification information is sent to the backend server.

[0050] In some embodiments, when developing the modification function, it is necessary to design an efficient data retrieval algorithm so that when the user chooses to modify the employee insurance information, the corresponding record can be quickly found from the database. Consider using indexing technology to create indexes for fields that are often used as retrieval conditions (such as employee number) to improve the speed of data query.

[0051] During the modification process, a data version control mechanism is introduced to record the modification history of employee insurance information so that the information change process can be traced back when needed. For modification operations, optimistic locking or pessimistic locking can be used to prevent multiple users from modifying the same record at the same time and causing data conflicts. Optimistic locking adds a version number field and checks whether the version number is consistent each time it is modified; pessimistic locking directly locks the data during modification until the operation is completed and the lock is released to ensure data consistency.

[0052] When the user submits the modified information, the front-end and back-end data comparison algorithm is used to send only the modified data to the back-end for updating, reducing the amount of data transmission and database update operations.

[0053] In some embodiments, Figure 4 As shown, the method also includes: S401: Generate multi-condition combination information of the insurance information to be checked based on the multi-condition query algorithm; S403: Generate an SQL query statement based on the multiple condition combination information; S405: Based on the SQL query statement, search for the insurance information to be checked in a preset database.

[0054] In some embodiments, in order to achieve flexible and diverse query functions, a multi-condition query algorithm can be introduced. Users query based on different condition combinations (such as employee name, department, insurance date range, etc.), and the background dynamically generates SQL query statements based on the conditions entered by the user. Through reasonable SQL statement optimization, such as using appropriate connections and avoiding too deep nesting of subqueries, query performance can be improved.

[0055] For large amounts of data, consider paging algorithms and display the query results in pages to avoid slow page response caused by loading too much data at one time. At the same time, you can use virtual scrolling technology on the front end to only load the currently visible part of the data. When the user scrolls the page, the subsequent data is dynamically loaded to improve the user experience.

[0056] In order to enhance the query function, advanced filtering functions are added, such as fuzzy query, range filtering, etc., and sorting operations are supported, allowing users to sort the query results according to their needs, such as sorting by insurance amount, insurance time, etc.

[0057] When developing export functions, you need to consider different data format requirements, such as CSV, Excel, PDF, etc. Use specialized export libraries or tools, such as Apache POI (for Java environments) or XlsxWriter (for Python environments), to convert query results into corresponding file formats.

[0058] For the export of large amounts of data, a batch export algorithm can be used to process the data in multiple batches to avoid memory overflow. At the same time, a compression algorithm (such as ZIP compression) can be used to compress the export file to reduce the file size and facilitate user download and storage.

[0059] During the export process, a progress bar and status feedback function are provided to let users know the progress of the export clearly and improve the user experience.

[0060] In some embodiments, the method further comprises: When the user triggers the invalidation operation for the insurance policy, the invalidation operation is delayed through the task scheduling algorithm; The accumulated delay duration of the failed operation is detected based on a scheduled task trigger. When the accumulated delay duration reaches the target duration, the status field of the employee insurance information is updated and the corresponding associated operation is triggered.

[0061] In this embodiment, the invalidation function can be designed with a timed task trigger. After the user clicks the invalidation operation, the operation is delayed through the background task scheduling algorithm so that there is a certain buffer time to cancel the operation when the user regrets or makes an operation error.

[0062] For invalidation operations, it is necessary to update the status field of the employee's insurance information and trigger corresponding related operations, such as updating other data tables or system modules that depend on the employee's insurance information. When updating the status, use the distributed transaction processing mechanism to ensure data consistency in a distributed system environment, especially when multiple services or databases are involved.

[0063] In some embodiments, the method further comprises: When synchronizing the insurance information of resigned employees at failed outlets, use the data synchronization algorithm to obtain the latest resigned employee information and existing employee insurance information from the human resources system; A difference comparison algorithm is used to compare the latest resigned employee information and the existing employee insurance information to determine newly resigned employees, and the insurance information status of the newly resigned employees is updated to an invalid state.

[0064] In some embodiments, when synchronizing the insurance information of employees who have left the invalid outlets, a data synchronization algorithm can be used to obtain the latest information of employees who have left the outlets from the human resources system by calling the corresponding interface and compare it with the existing employee insurance information. A difference comparison algorithm is used to find the newly-added employees who have left the outlets and update their insurance information status to invalid.

[0065] In order to ensure the accuracy and completeness of data synchronization, a data cleaning algorithm is used to clean the data obtained from different systems, remove duplicate data, correct data formats, etc.

[0066] Consider using a message queue (such as RabbitMQ, Kafka, etc.) to queue synchronization requests and process them in order to avoid data inconsistency caused by concurrent operations. At the same time, during the synchronization process, use a logging algorithm to record the synchronization process and results in detail for subsequent auditing and troubleshooting.

[0067] In some embodiments, Figure 5 As shown, sending the target email to the insurance organization includes: S501: Generate an email sending task according to the target email; S503: Using a multi-thread or asynchronous processing mechanism, sending the email sending task to a background thread or an asynchronous task processor; S505: Sending the target email to the insurance organization based on the background thread or the asynchronous task processor.

[0068] In some embodiments, in order to ensure the reliability of email sending, an email queue and retry mechanism is used to put emails to be sent into a queue. If the sending fails, multiple retries are performed according to a certain retry strategy (such as an exponentially increasing time interval). At the same time, the reason for the sending failure is recorded for subsequent analysis and processing.

[0069] For the performance of email sending, use multi-threading or asynchronous processing mechanism to assign email sending tasks to background threads or asynchronous task processors to avoid blocking the main thread and improve the execution efficiency of the script.

[0070] In some embodiments, the method further comprises: Calculate the deductible fees based on the employee's insurance information and obtain the employee's account balance from the financial system or bank interface; Performing real-time deduction processing according to the account balance and the deductible fees through an amount calculation algorithm; In this embodiment, a special fee calculation and verification algorithm can be designed for the balance verification of insurance fees. First, the deductible fees are calculated based on the employee's insurance information, and then the employee's account balance is obtained from the financial system or bank interface, and the accuracy of the deductible amount is ensured through an accurate amount calculation algorithm.

[0071] Distributed lock technology is used to prevent multiple scripts from performing deduction operations on the same employee account at the same time during the deduction operation, avoiding repeated deductions. During the deduction process, a transaction compensation mechanism is introduced. If the deduction fails, the corresponding rollback operation is performed to restore the state to the state before the deduction to ensure data consistency.

[0072] Use risk assessment models to conduct risk assessments on deduction operations. For example, determine the risk level of deductions based on factors such as employees' historical payment records and account balance fluctuations. For high-risk operations (such as insufficient balance but multiple attempts to deduct fees), trigger an early warning mechanism and notify relevant personnel to handle the situation.

[0073] In some embodiments, the method further comprises: Use data screening algorithms to filter out valid employee insurance information from the database; When updating the effective time of the insurance, use the date calculation algorithm to calculate the date range of the next period and update it to the corresponding insurance information record; A batch update algorithm is used to batch update the screened renewal information into the database.

[0074] In some embodiments, for the function of running scripts on a scheduled basis on the last three days of each month, the scheduled task service of the operating system (such as Linux's cron, Windows's task scheduler) or a dedicated task scheduling framework (such as Quartz for Java, APScheduler for Python) can be used. When scheduling tasks, a distributed task scheduling algorithm can be used to ensure accurate execution of tasks in a distributed environment.

[0075] To prevent repeated execution of tasks, use a distributed lock or task status check mechanism to check whether the task is running at the beginning of the script. If it is running, it will not be executed to avoid task overlap caused by long script execution time.

[0076] Renew valid employee insurance information: For renewal operations, you can use data screening algorithms to filter valid employee insurance information from the database. When updating the effective period of insurance, you can use a date calculation algorithm to accurately calculate the date range of the next month and update it to the corresponding insurance information record.

[0077] The batch update algorithm is used to batch update the selected renewal information to the database, reducing the number of database update operations and improving performance. At the same time, during the update process, the row-level lock or table-level lock of the database is used to ensure the consistency of data updates and avoid the impact of other operations on the data.

[0078] It is forbidden to add insured employee information on the branch employee insurance page: When prohibiting the addition of insured employee information, restrictions can be imposed on both the page and the backend server. On the frontend, the page elements are disabled or hidden to prevent users from clicking the add button or entering relevant information; on the backend, permission control algorithms are used to verify the permissions of the new operations to ensure that only specific users or roles can perform operations during the renewal period, and error messages of insufficient permissions are returned for new requests from other users.

[0079] In order to ensure the consistency and integrity of the data, a data consistency check algorithm can be used to perform consistency checks on related data tables after the renewal operation is completed, such as checking whether the related data of the branch employee insurance information table and the expense table match. At the same time, a data backup and recovery algorithm can be used to back up important data before the renewal operation, and restore the data in time if a problem occurs.

[0080] It can be seen from the technical solution provided by the above embodiments of this specification that the embodiments of this specification detect the input data of the insurance page of the branch employees; use the form verification algorithm to verify the integrity and accuracy of the input data to obtain the data verification result; when the data verification result indicates that the input data is normal, store the input data; construct a plurality of preset email templates corresponding to each preset insurance information type in the email template library; according to the target insurance information type of the current insurance information, search the target email template corresponding to the target insurance information type in the email template library; generate the target email according to the target email template and the current insurance information, and send the target email to the insurance organization. The present invention does not need to count employee information for insurance, and can be insured and renewed on a monthly basis after maintenance, reducing the workload. There is no need for a dedicated person to connect with the insurance company and deduct the insurance premium, avoiding the increase of labor costs. Personnel information can be maintained and queried on the insurance page of the branch employees, which can be used immediately after modification to ensure the timeliness of the data.

[0081] The embodiment of this specification also provides an insurance data processing device, such as Figure 6 As shown, the device comprises: The data detection module 610 is used to detect the input data of the branch employee insurance application page; The data verification module 620 is used to verify the integrity and accuracy of the input data using a form verification algorithm to obtain a data verification result; A data storage module 630, configured to store the input data when the data verification result indicates that the input data is normal; An email template construction module 640 is used to construct preset email templates corresponding to multiple preset insurance information types in the email template library; A target template search module 650 is used to search the target email template corresponding to the target insurance information type in the email template library according to the target insurance information type of the current insurance information; The email sending module 660 is used to generate a target email according to a target email template and the current insurance information, and send the target email to the insurance organization.

[0082] In some embodiments, the data verification module includes: A first verification unit, configured to, if the input data is key information of a branch employee, use a regular expression to match and verify the key information to obtain a first data verification result; A second verification unit, configured to verify the input data using a preset algorithm to obtain a second data verification result if the input data is not critical information; The device also includes: A first encryption module, configured to encrypt and store the sensitive information in the key information using a data encryption algorithm if the first data verification result is a successful verification result; The second encryption module is used to store the non-critical information in an unencrypted manner if the second data verification result is a successful verification result.

[0083] In some embodiments, the input data includes the key information and the non-key information, and the apparatus further includes: A first storage module is used for encrypting and storing the sensitive information in the key information by using a data encryption algorithm, and storing the non-key information in an unencrypted manner if both the first data verification result and the second data verification result are successful verification results; The second storage module is used for not storing the key information and the non-key information if at least one of the first data verification result and the second data verification result is a verification failure result.

[0084] In some embodiments, the apparatus further comprises: An abnormal information generation module, used for generating abnormal prompt information when the data verification result indicates that the input data is abnormal; An information receiving module, used to receive modification information of the abnormal prompt information updated by the user; An information sending module, used for sending the modification information to the back-end server when the modification information is verified to be correct; A combination information generation module is used to generate multi-condition combination information of the insurance information to be checked based on a multi-condition query algorithm; A statement generation module, used to generate an SQL query statement based on the multi-condition combination information; The information query module is used to search the insurance information to be queried in a preset database based on the SQL query statement.

[0085] In some embodiments, the apparatus further comprises: A delay module is used to delay the execution of the invalidation operation for the policy through a task scheduling algorithm when the user triggers the invalidation operation for the policy; An operation module, used for detecting the accumulated delay time of the failed operation based on a timed task trigger, and updating the status field of the employee insurance information when the accumulated delay time reaches a target time, and triggering a corresponding associated operation; The insurance information acquisition module is used to use the data synchronization algorithm to obtain the latest information of resigned employees and the insurance information of existing employees from the human resources system when synchronizing the insurance information of resigned employees of the failed outlets; The new employee determination module is used to use a difference comparison algorithm to compare the latest resigned employee information and the existing employee insurance information, determine the newly resigned employees, and update the insurance information status of the newly resigned employees to an invalid state.

[0086] In some embodiments, the email sending module includes: A task generating unit, used for generating an email sending task according to the target email; A task sending unit, used to send the email sending task to a background thread or an asynchronous task processor using a multi-threading or asynchronous processing mechanism; An email sending unit is used to send the target email to the insurance organization based on the background thread or the asynchronous task processor.

[0087] In some embodiments, the apparatus further comprises: The balance acquisition module is used to calculate the deductible fees based on the employee's insurance information and obtain the employee's account balance from the financial system or bank interface; A deduction processing module, used to perform real-time deduction processing according to the account balance and the deductible fees through an amount calculation algorithm; An information screening module is used to use a data screening algorithm to screen out valid employee insurance information from the database; The record update module is used to use the date calculation algorithm to calculate the date range of the next period when updating the effective time of the insurance, and update it to the corresponding insurance information record; The data update module is used to adopt a batch update algorithm to batch update the screened renewal information into the database.

[0088] The device and method embodiments in the described device embodiments are based on the same inventive concept.

[0089] An embodiment of the present specification provides an electronic device, which includes a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or at least one program is loaded and executed by the processor to implement the insurance data processing method provided in the above method embodiment.

[0090] An embodiment of the present invention also provides a computer storage medium, which can be set in a terminal to store at least one instruction or at least one program related to an insurance data processing method in a method embodiment. The at least one instruction or at least one program is loaded and executed by the processor to implement the insurance data processing method provided in the above method embodiment.

[0091] The embodiment of the present invention also provides a computer program product or a computer program, which includes computer instructions stored in a computer-readable storage medium. The processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes to implement the insurance data processing method provided in the above method embodiment.

[0092] Optionally, in the embodiments of this specification, the storage medium may be located in at least one of the multiple network servers of the computer network. Optionally, in this embodiment, the storage medium may include but is not limited to: a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk, and other media that can store program codes.

[0093] The memory described in the embodiments of this specification can be used to store software programs and modules, and the processor executes various functional applications and data processing by running the software programs and modules stored in the memory. The memory may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, application programs required for functions, etc.; the data storage area may store data created according to the use of the device, etc. In addition, the memory may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other volatile solid-state storage device. Accordingly, the memory may also include a memory controller to provide the processor with access to the memory.

[0094] The insurance data processing method provided in the embodiments of this specification can be executed in a mobile terminal, a computer terminal, a server or a similar computing device. Taking running on a server as an example, Figure 7 1 is a hardware structure diagram of a server of an insurance data processing method provided in an embodiment of this specification. Figure 7 As shown, the server 700 may have relatively large differences due to different configurations or performances, and may include one or more central processing units (CPU) 710 (the central processing unit 710 may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 730 for storing data, and one or more storage media 720 (such as one or more mass storage devices) for storing application programs 723 or data 722. Among them, the memory 730 and the storage medium 720 can be short-term storage or permanent storage. The program stored in the storage medium 720 may include one or more modules, each of which may include a series of instruction operations on the server. Furthermore, the central processing unit 710 can be configured to communicate with the storage medium 720 and execute a series of instruction operations in the storage medium 720 on the server 700. The server 700 may also include one or more power supplies 760, one or more wired or wireless network interfaces 750, one or more input and output interfaces 740, and / or one or more operating systems 721, such as Windows Server™, Mac OS X™, Unix™, Linux™, FreeBSD™, etc.

[0095] The input / output interface 740 may be used to receive or send data via a network. A specific example of the network may include a wireless network provided by a communication provider of the server 700. In one example, the input / output interface 740 includes a network adapter (Network Interface Controller, NIC), which may be connected to other network devices via a base station so as to communicate with the Internet. In one example, the input / output interface 740 may be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0096] It can be understood by those skilled in the art that Figure 7 The structure shown is only for illustration and does not limit the structure of the above electronic device. Figure 7 More or fewer components as shown, or with Figure 7 Different configurations are shown.

[0097] It can be seen from the embodiments of the insurance data processing method, device, electronic device or storage medium provided by the present invention that the present invention detects the input data of the insurance page of the branch employee; uses the form verification algorithm to verify the integrity and accuracy of the input data to obtain the data verification result; when the data verification result indicates that the input data is normal, the input data is stored; a plurality of preset email templates corresponding to each preset insurance information type are constructed in the email template library; according to the target insurance information type of the current insurance information, the target email template corresponding to the target insurance information type is searched in the email template library; a target email is generated according to the target email template and the current insurance information, and the target email is sent to the insurance organization. The present invention does not need to count employee information for insurance, and maintenance can be performed once a month for regular insurance and renewal, reducing the workload. There is no need for a dedicated person to connect with the insurance company and deduct the insurance premium, avoiding the increase of labor costs. Personnel information can be maintained and queried on the insurance page of the branch employee, which can be used immediately after modification to ensure the timeliness of the data.

[0098] It should be noted that the above sequence of the embodiments of this specification is for description only and does not represent the advantages and disadvantages of the embodiments. The above describes specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0099] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment, and storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0100] A person skilled in the art will appreciate that all or part of the steps to implement the above embodiments may be accomplished by hardware or by instructing related hardware through a program, and the program may be stored in a computer storage medium, and the above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0101] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for processing insurance data, characterized in that: The method comprises: Check the input data of the branch employee insurance enrollment page; Using a form validation algorithm to verify the integrity and accuracy of the input data to obtain a data validation result; If the data verification result indicates that the input data is normal, storing the input data; Constructing multiple preset email templates corresponding to the preset insurance information types in the email template library; According to the target insurance information type of the current insurance information, searching the email template library for a target email template corresponding to the target insurance information type; A target email is generated according to the target email template and the current insurance information, and the target email is sent to the insurance organization.

2. The method according to claim 1, characterized in that The form validation algorithm is used to verify the integrity and accuracy of the input data to obtain a data validation result, including: If the input data is key information of the branch staff, a regular expression is used to match and verify the key information to obtain a first data verification result; If the input data is not critical information, verify the input data using a preset algorithm to obtain a second data verification result; The method further comprises: If the first data verification result is a successful verification result, using a data encryption algorithm to encrypt and store the sensitive information in the key information; If the second data verification result is a successful verification result, the non-critical information is stored in an unencrypted manner.

3. The method according to claim 2, characterized in that The input data includes the key information and the non-key information, and the method further includes: If both the first data verification result and the second data verification result are successful verification results, the sensitive information in the key information is encrypted and stored using a data encryption algorithm, and the non-key information is not encrypted and stored; If at least one of the first data verification result and the second data verification result is a verification failure result, the key information and the non-key information are not stored.

4. The method according to claim 1, characterized in that: The method further comprises: When the data verification result indicates that the input data is abnormal, generating abnormal prompt information; Receive modification information of the abnormal prompt information updated by the user; If the modification information is verified to be correct, sending the modification information to the backend server; Based on the multi-condition query algorithm, generate multi-condition combination information of the insurance information to be checked; Generate an SQL query statement based on the multiple condition combination information; Based on the SQL query statement, the insurance information to be checked is searched in a preset database.

5. The method according to claim 1, characterized in that The method further comprises: When the user triggers the invalidation operation for the insurance policy, the invalidation operation is delayed through the task scheduling algorithm; Based on the timed task trigger, the accumulated delay time of the invalid operation is detected. When the accumulated delay time reaches the target time, the status field of the employee insurance information is updated, and the corresponding associated operation is triggered; When synchronizing the insurance information of resigned employees at failed outlets, use the data synchronization algorithm to obtain the latest resigned employee information and existing employee insurance information from the human resources system; A difference comparison algorithm is used to compare the latest resigned employee information and the existing employee insurance information to determine newly resigned employees, and the insurance information status of the newly resigned employees is updated to an invalid state.

6. The method according to claim 1, characterized in that The sending of the target email to the insurance organization comprises: Generate an email sending task according to the target email; Using a multithreading or asynchronous processing mechanism, sending the email sending task to a background thread or an asynchronous task processor; The target email is sent to the insurance organization based on the background thread or the asynchronous task processor.

7. The method according to claim 1, characterized in that The method further comprises: Calculate the deductible fees based on the employee's insurance information and obtain the employee's account balance from the financial system or bank interface; Performing real-time deduction processing according to the account balance and the deductible fees through an amount calculation algorithm; Use data screening algorithms to filter out valid employee insurance information from the database; When updating the effective time of the insurance, use the date calculation algorithm to calculate the date range of the next period and update it to the corresponding insurance information record; A batch update algorithm is used to batch update the screened renewal information into the database.

8. An insurance data processing device, characterized in that: The device comprises: Data detection module, used to detect the input data of the branch employee insurance application page; A data verification module is used to verify the integrity and accuracy of the input data using a form verification algorithm to obtain a data verification result; A data storage module, used for storing the input data when the data verification result indicates that the input data is normal; An email template building module, used to build preset email templates corresponding to multiple preset insurance information types in the email template library; A target template search module, used for searching the target email template corresponding to the target insurance information type in the email template library according to the target insurance information type of the current insurance information; The mail sending module is used to generate a target mail according to a target mail template and the current insurance information, and send the target mail to the insurance organization.

9. An electronic device, characterized in that: The device includes: a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or at least one program is loaded and executed by the processor to implement the insurance data processing method as described in any one of claims 1-7.

10. A computer storage medium, characterized in that: The computer storage medium stores at least one instruction or at least one program, and the at least one instruction or at least one program is loaded and executed by the processor to implement the insurance data processing method as described in any one of claims 1-7.

Images