CN109285080B

CN109285080B - Policy information rolling processing method and device, computer equipment and storage medium

Info

Publication number: CN109285080B
Application number: CN201811026932.8A
Authority: CN
Inventors: 马耿彬
Original assignee: Ping An Property and Casualty Insurance Company of China Ltd
Current assignee: Ping An Property and Casualty Insurance Company of China Ltd
Priority date: 2018-09-04
Filing date: 2018-09-04
Publication date: 2023-04-04
Anticipated expiration: 2038-09-04
Also published as: CN109285080A

Abstract

The invention discloses a policy information rolling processing method, a policy information rolling processing device, computer equipment and a storage medium. The method comprises the following steps: creating a first data table and a second data table, and configuring the operation time point of the first data table; storing the policy in the validity period into a first data table; if the operation time point of the first data table is reached, the policy in the first data table is stored in the second data table; removing the invalid policy from the first data table according to the policy de-insurance information and the policy de-insurance information; if the current time is one day per month, adding the new insurance policy in the previous month into the first data table; and removing the insurance policy in the first data table according to the correction processing information and the date correction information in the previous month correction processing information. By the method, the policy stored in the first data table can be guaranteed to be the policy to be processed, the policy to be processed in the first data table can be read quickly in the subsequent processing process, and the policy processing efficiency is improved.

Description

Policy information rolling processing method and device, computer equipment and storage medium

Technical Field

The invention relates to the technical field of policy information processing, in particular to a policy information rolling processing method, a policy information rolling processing device, computer equipment and a storage medium.

Background

Enterprises need to calculate the policy regularly, for example, the reserve of the policy regularly every month, however, in the existing policy storage methods, all policies are stored in the database, when the policy needs to be calculated regularly, all policies in the database are calculated, when a large number of policies are stored by adopting the traditional policy storage method, the reading time of the policies is long due to the huge data volume of the policies, and therefore, the efficiency of calculating the policies is influenced, and the processing efficiency of the policies is low. Therefore, the existing policy information processing method has the problem of low processing efficiency.

Disclosure of Invention

The embodiment of the invention provides a policy information rolling processing method, a policy information rolling processing device, computer equipment and a storage medium, and aims to solve the problem of low policy information processing efficiency in the prior art.

In a first aspect, an embodiment of the present invention provides a policy information rolling processing method, which includes:

creating a first data table for saving a current effective policy and a second data table for backing up a historical policy, and configuring the running time point of the first data table as the last day of the current month;

acquiring a policy pre-stored in a historical data table, acquiring the policy in the validity period in the historical data table according to the current time, storing the policy in the created first data table, and adding a new mark to the policy stored in the first data table;

if the current time reaches the operation time point of the first data table, judging whether the policy in the first data table has a newly added mark, and storing the policy with the newly added mark into the second data table for backup;

acquiring policy de-insurance information and policy de-insurance information, and removing the invalid policy corresponding to the policy de-insurance information and the policy de-insurance information from the first data table;

deleting the newly added mark of the policy in the first data table;

if the current time reaches the next month and the day, acquiring a newly-increased policy in the previous month according to the current time, adding the acquired newly-increased policy in the previous month into a first data table, and adding a newly-increased mark for the newly-increased policy in the previous month;

acquiring correction processing information and date correction information in the previous month correction processing information, and removing the insurance policy in the first data table according to the correction processing information and the date correction information;

and changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table.

In a second aspect, an embodiment of the present invention provides a policy information scroll processing apparatus, including:

the data table creating unit is used for creating a first data table used for storing a current effective policy and a second data table used for backing up a historical policy, and the operation time point of the first data table is configured to be the last day of the current month;

the valid period policy adding unit is used for acquiring policies pre-stored in the historical data table, acquiring policies in the valid period in the historical data table according to the current time, storing the policies into the created first data table, and adding new marks to the policies stored in the first data table;

the policy backup unit is used for judging whether the policy in the first data table has the newly added mark or not and storing the policy with the newly added mark into the second data table for backup if the current time reaches the operation time point of the first data table;

the system comprises a failure policy processing unit, a first data table and a second data table, wherein the failure policy processing unit is used for acquiring policy de-insurance information and policy de-approval information and removing failure policies corresponding to the policy de-insurance information and the policy de-approval information from the first data table;

a newly added mark deleting unit, configured to delete the newly added mark of the policy in the first data table;

a newly-added policy adding unit, configured to obtain a newly-added policy for the previous month according to the current time if the current time reaches the next month and day, add the obtained newly-added policy for the previous month to the first data table, and add a newly-added flag to the newly-added policy for the previous month;

the previous month approval information processing unit is used for acquiring the approval processing information and the date approval information in the previous month approval processing information and removing the insurance policy in the first data sheet according to the approval processing information and the date approval information;

and the operation time point changing unit is used for changing the operation time point of the first data table to be the last day of the current month and judging whether the current time reaches the operation time point of the first data table.

In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the policy information rolling processing method according to the first aspect when executing the computer program.

In a fourth aspect, an embodiment of the present invention further provides a storage medium, where the storage medium stores a computer program, and the computer program, when executed by a processor, causes the processor to execute the policy information rolling processing method according to the first aspect.

The embodiment of the invention provides a policy information rolling processing method, a policy information rolling processing device, computer equipment and a storage medium. By creating the first data table and the second data table, the invalid policy in the first data table is removed at the time preset every month, and the policy in the first data table is removed according to the previous month policy processing information, so that the policies stored in the first data table can be ensured to be pending policies, the pending policies in the first data table can be read quickly in the subsequent processing process, and the policy processing efficiency is improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

FIG. 1 is a schematic flow chart of a policy information rolling processing method according to an embodiment of the present invention;

FIG. 2 is a schematic view of a sub-flow of a policy information rolling processing method according to an embodiment of the present invention;

FIG. 3 is a schematic view of another sub-flow of a policy information rolling processing method according to an embodiment of the present invention;

FIG. 4 is a schematic view of another sub-flow of a policy information rolling processing method according to an embodiment of the present invention;

FIG. 5 is a schematic view of another sub-flow of the policy information rolling processing method according to the embodiment of the present invention;

FIG. 6 is a schematic block diagram of a policy information scroll processing apparatus according to an embodiment of the present invention;

FIG. 7 is a schematic block diagram of a sub-unit of a policy information rolling processing apparatus according to an embodiment of the present invention;

FIG. 8 is a schematic block diagram of another sub-unit of a policy information rolling processing device according to an embodiment of the present invention;

FIG. 9 is a schematic block diagram of another sub-unit of a policy information rolling processing device according to an embodiment of the present invention;

FIG. 10 is a schematic block diagram of another sub-unit of a policy information rolling processing device according to an embodiment of the present invention;

FIG. 11 is a schematic block diagram of a computer device provided by an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, belong to the protection scope of the present invention.

It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

Referring to fig. 1, fig. 1 is a schematic flow chart of a policy information rolling processing method according to an embodiment of the present invention.

As shown in fig. 1, the method includes steps S101 to S108.

S101, a first data table used for storing a current effective policy and a second data table used for backing up a historical policy are created, and the operation time point of the first data table is configured to be the last day of the current month.

A first data table for holding a currently active policy, that is, a database table for holding policy information in the management server, and a second data table for backing up a historical policy, that is, another database table for holding policy information in the management server, are created in the management server. The management server is a server side used for storing policy data.

After the first data table and the second data table are created, the operating time point of the first data table is configured as the last day of the current month. The running time point is a time node for processing the policy in the first data table when a preset time is reached.

Therefore, the effective policy in the current month is calculated only by reading the policy in the first data table, and the policy in the current month does not need to be read from the data in a plurality of months, so that the policy required to be processed can be quickly obtained, and the policy processing efficiency is greatly improved.

S102, acquiring a policy pre-stored in the historical data table, acquiring the policy in the validity period in the historical data table according to the current time, storing the policy in the created first data table, and adding a new mark to the policy stored in the first data table.

Acquiring a policy stored in a historical data table in advance, acquiring expiration time of the policy, judging whether the policy is in an effective period according to current time, storing the policy in the effective period to the created first data table, and adding a new mark to the policy stored in the first data table. The historical data table is a data table used for storing historical policy data, the expiration time of the policy is time information for maintaining the policy to be valid, the newly added mark of the policy is mark information used for judging whether the policy is the newly added policy, and the newly added mark needs to be added to the policy stored in the first data table because the policies stored in the first data table are the newly added policies at the moment. Wherein the policy also includes a creation date of the policy.

In one embodiment, as shown in fig. 2, step S102 includes sub-steps S1021 and S1022.

And S1021, acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy.

And acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy. If the expiration time of the policy has passed, the policy is the policy in the expiration period; if the expiration time of the policy is not reached, the policy is the policy in the validity period, whether the policy is in the validity period can be judged according to the current time and the expiration time of the policy, and the policy in the validity period is obtained.

For example, the current time is 2018, 5/1, and the results of acquiring the policy including the expiration time and determining whether the policy is in the valid period are shown in table 1.

Policy number	Expiration time	Whether or not it is in the valid period
			XXXX0001	2018-05-30	Is that
XXXX0002	2018-03-27	Whether or not
			XXXX0003	2018-07-16	Is that

TABLE 1

And S1022, acquiring the policy in the validity period according to the judgment result and storing the policy in the validity period into the created first data table.

After the first data table is created, the first data table can be used, and the obtained insurance policy with the validity period is stored in the first data table.

S103, if the current time reaches the operation time point of the first data table, judging whether the policy in the first data table has the newly added mark, and storing the policy with the newly added mark into the second data table for backup.

The first data table is used for storing the policy valid in the current month, the second data table is used for storing the policy valid in the historical month, if the current time reaches the operation time point of the first data table, whether the policy in the first data table has the newly added mark or not is judged, and the policy with the newly added mark in the first data table is stored in the second data table for backup. The operation time point is a time node for periodically processing the policy in the first data table, for example, if the preset operation time point of the first data table is the last day of the month, and the current time reaches the last day of the month, the management server stores the policy in the first data table into the second data table for backup.

S104, acquiring the policy de-insurance information and the policy cancellation information, and removing the invalid policy corresponding to the policy de-insurance information and the policy cancellation information in the first data table from the first data table.

Acquiring policy de-insurance information and policy de-insurance information, and removing the corresponding de-insurance policy and de-insurance policy in the first data table, namely removing the invalid policy from the first data table. The policy revocation information is information for performing a revocation process on the policy received by the management server, and the policy cancellation information is information for performing a cancellation process on the policy received by the management server. Under certain conditions, the policy is subjected to the processing of de-insurance and cancellation, so that the policy does not need to be stored in the first data table, and the corresponding de-insurance policy and cancelled policy in the first data table can be removed by acquiring the de-insurance information and cancellation information of the policy to remove the policy which is stored in the first data table and does not need to be processed, so that only the policy which needs to be processed is stored in the first data table.

And S105, deleting the newly added mark of the policy in the first data table.

Deleting the newly added mark of the policy in the first data table, wherein the newly added mark of the policy is mark information for attaching whether the policy is the newly added policy or not, deleting the newly added mark of the policy in the first data table to be convenient for distinguishing the policy from the subsequently added policy, and being convenient for a user to carry out statistical analysis on the policy in the first data table in the subsequent processing process.

In addition, the calculation of the policy in the first data table may be performed after the addition of the policy in the first data table is removed. For example, a specific calculation procedure is: and calculating the valid period proportion, the unexpired premium and the reserve fund of the policy according to the creation date, the expiration time, the premium amount and the re-insurance division proportion of the policy in the first data table so as to facilitate the user to obtain the calculated calculation result and carry out statistical analysis on the financial condition of the policy in the first data table. And storing the calculated calculation result so as to facilitate the statistical analysis of the financial condition of the policy in the first data table by the user.

S106, if the current time reaches the next month and the next day, acquiring the newly added policy for the previous month according to the current time, adding the acquired newly added policy for the previous month into the first data table, and adding a newly added mark for the newly added policy for the previous month.

And if the current time reaches the next month and day, automatically acquiring the newly added previous month policy according to the current time, adding the acquired newly added previous month policy into the first data table, and adding a newly added mark for the newly added previous month policy. Specifically, the creation date and the current time of the policy are obtained, and whether the policy is the newly added policy in the previous month is judged according to the current time and the creation date of the policy. The creation date of the policy is the date information on which the policy was created. Specifically, month information of the current time is obtained, the month information of the current time is subtracted by one to obtain month judgment information, whether the creation month of the policy is equal to the month judgment information or not is judged, and if the creation month of the policy is equal to the month judgment information, the policy is a new policy added in the previous month; if the creation month of the policy is not equal to the month judgment information, the policy is not the previous month new policy.

For example, if the current time is 2018, 6/month, 1/day, the month information of the current time is 6, and the obtained month judgment information is 6-1=5, then it is judged whether the creation month of the policy is equal to 5; if the month judgment information is 0, judging whether the creation month of the policy is equal to 12, namely the current time is 1 month, and judging whether the creation month of the policy is 12 months of the previous year.

And adding the obtained previous month new policy into the first data table according to the judgment result, and adding a new flag for the previous month new policy added in the first data table. And adding a new mark for the previous month new policy added in the first data table after obtaining the previous month new policy according to the current time. The newly added mark of the policy is the mark information used for adding whether the policy is the newly added policy or not, and the newly added mark is added to the newly added policy in the previous month added in the first data table, so that whether the policy is the newly added policy or not in the first data table is distinguished, and the statistical analysis of the policy in the first data table by a user in the subsequent processing process can be facilitated.

S107, correction processing information and date correction information in the previous month correction processing information are obtained, and the insurance policy in the first data table is removed according to the correction processing information and the date correction information.

The previous month bill processing information is information for performing bill processing on the insurance policy completed in the previous month, and corresponding insurance policies in the first data table can be removed according to the correction processing information in the previous month bill processing information; and updating the expiration time of the policy in the first data table according to the date correction information in the previous policy processing information to obtain the policy with the updated expiration time in the first data table, and removing the policy in the first data table according to the updated expiration time of the policy.

In one embodiment, as shown in fig. 3, step S107 includes sub-steps S1071 and S1072.

S1071, acquiring the correction processing information, removing the corresponding insurance policy in the first data table according to the correction processing information, and transferring the insurance policy to the second data table for storage.

And removing the corresponding policy in the first data table according to the modification processing information in the previous policy processing information, storing the removed policy in the first data table into the second data table, wherein the modified policy does not need to be stored in the first data table, and the policy is migrated from the first data table and transferred to the second data table for storage.

In an embodiment, as shown in fig. 4, step S1071 includes substeps S10711 and S10712.

S10711, the modified insurance policy matched with the modification processing information is inquired in the first data table according to the modification processing information.

And after the addition of the newly added policy in the previous month is finished, acquiring correction processing information in the previous month policy processing information, and matching the correction processing information with the policy in the first data table according to the correction processing information to obtain a corrected policy matched with the correction processing information in the first data table. And removing the corresponding warranty in the first data table according to the correction processing information in the previous statement processing information, wherein the corrected warranty does not need to be stored in the first data table and needs to be transferred to the second data table for storage.

S10712, transferring the changed insurance policy from the first data table to a second data table for storage, and removing the changed insurance policy from the first data table.

In this embodiment, the corresponding modified warranty is obtained by querying the first data table according to the modification information in the previous month's warranty processing information, and the modified warranty is removed from the first data table and transferred to the second data table for backup storage, so that the latest warranty information processed according to the previous month's warranty processing information is ensured to be stored in the first data table.

S1072, updating the expiration time of the policy in the first data table according to the date correction information, and removing the policy which is not in the validity period according to the updated expiration time of the policy.

Because the policy needs to be renewed or the policy is terminated within the validity period, the expiration time of the policy in the first data table needs to be updated according to the date correction information, and then the expiration time of the policy in the first data table can be updated according to the date correction information, so as to obtain the policy processed according to the date correction information.

In one embodiment, as shown in fig. 5, step S1072 includes sub-steps S10721, S10722, and S10723.

S10721, updating the expiration time of the insurance policy in the first data table according to the date correction information.

S10722, judging whether the policy is in the valid period according to the current time and the expiration time after updating the policy.

And after updating the expiration time of the policy in the first data table according to the date correction information, acquiring the expiration time of the policy in the updated first data table, and judging whether the policy is expired in the current month according to the current time to obtain the policy which is not in the validity period.

S10723, removing the insurance policy which is not in the validity period from the first data table according to the judgment result.

And if the policy is judged to be not in the validity period according to the judgment result of the policy, the policy does not need to be stored in the first data table, namely the policy not in the validity period is removed from the first data table. Wherein the policy which is not in the valid period comprises the policy which expires in the current month.

For example, the current time is 6/1/2018, the expiration time of the policy before updating is 12/31/2018, the expiration time of the policy is updated to 31/2018/5/31/2018 due to the fact that the policy is modified according to the date modification information, and the policy after updating the expiration time is judged not to be in the validity period, so that the policy is removed from the first data table.

In this embodiment, before removing the policy expired in the current month from the first data table, the expiration time of the policy corresponding to the date correction information in the first data table needs to be updated according to the date correction information of the previous month policy processing information. And judging whether the policy is in the valid period or not according to the updated expiration time of the policy in the first data table, and removing the policy which is not in the valid period from the first data table, so that the policy to be removed is judged more accurately, and all the policies which are not in the valid period can be removed from the first data table.

And S108, changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table.

And changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table, namely the time node for next processing the policy in the first data table is the last day of the current month, wherein if the current time reaches the operation time point of the first data table, the method flow jumps to the step S103 for rolling execution.

By creating the first data table and the second data table, the invalid policy in the first data table is removed at the time preset every month, and the policy in the first data table is removed according to the previous month policy processing information, so that the policies stored in the first data table can be ensured to be pending policies, the pending policies in the first data table can be read quickly in the subsequent processing process, and the policy processing efficiency is improved.

The embodiment of the invention also provides a policy information rolling processing device, which is used for executing any embodiment of the policy information rolling processing method. Specifically, referring to fig. 6, fig. 6 is a schematic block diagram of a policy information rolling processing device according to an embodiment of the present invention.

As shown in fig. 6, the policy information scroll processing device 100 includes a data table creating unit 101, an expiration policy adding unit 102, a policy backup unit 103, a failure policy processing unit 104, an addition flag deleting unit 105, an addition policy adding unit 106, a previous month policy information processing unit 107, and an operation time point changing unit 108.

The data table creating unit 101 is used for creating a first data table for storing a current effective policy and a second data table for backing up a historical policy, and configuring the operation time point of the first data table as the last day of the current month.

A first data table for holding currently active policy and a second data table for backing up historical policy are created in the management server, the first data table being a database table in the management server for holding policy information, and the second data table being another database table in the management server for holding policy information. The management server is a server side used for storing policy data.

After the first data table and the second data table are created, the operation time point of the first data table is configured to be the last day of the current month. The running time point is a time node for processing the policy in the first data table when a preset time is reached.

And the validity period policy adding unit 102 is configured to obtain policies pre-stored in the historical data table, obtain policies in the validity period from the historical data table according to the current time, store the policies in the validity period into the created first data table, and add new addition marks to the policies stored in the first data table.

Acquiring a policy stored in a historical data table in advance, acquiring expiration time of the policy, judging whether the policy is in an effective period according to current time, storing the policy in the effective period to the created first data table, and adding a new mark to the policy stored in the first data table. The historical data table is a data table used for storing historical policy data, the expiration time of the policy is time information for maintaining and validating the policy, the newly added mark of the policy is mark information used for judging whether the policy is added to the newly added policy, and the newly added mark needs to be added to the policy stored in the first data table because the policies stored in the first data table are all the newly added policies at the moment. Wherein the policy also includes a date of creation of the policy.

In another embodiment of the present invention, as shown in fig. 7, the validity policy adding unit 102 includes sub-units: a date judgment unit 1021 and a policy addition unit 1022.

And a date judgment unit 1021, configured to obtain the expiration time of the policy in the history data table, and judge whether the policy is in the valid period according to the current time and the expiration time of the policy.

And acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy. If the expiration time of the policy has passed, the policy is the policy in the expiration period; if the expiration time of the policy is not reached, the policy is the policy in the valid period, and whether the policy is in the valid period can be judged according to the current time and the expiration time of the policy, and the policy in the valid period is obtained.

And a policy adding unit 1022 for acquiring a policy in the validity period according to the judgment result and saving the policy in the validity period into the created first data table.

And the policy backup unit 103 is configured to determine whether the policy in the first data table has a new flag if the current time reaches the operation time point of the first data table, and store the policy with the new flag into the second data table for backup.

And the failure policy processing unit 104 is configured to obtain policy de-insurance information and policy logout information, and remove the failure policy corresponding to the policy de-insurance information and the policy logout information from the first data table.

Acquiring the policy de-insurance information and the policy cancellation information, and removing the corresponding de-insurance policy and cancelled policy in the first data table, namely removing the invalid policy from the first data table. The policy revocation information is information for performing a revocation process on the policy received by the management server, and the policy cancellation information is information for performing a cancellation process on the policy received by the management server. Under certain conditions, the policy is subjected to the processing of de-insurance and de-insurance, so that the policy does not need to be stored in the first data table, and the corresponding de-insurance policy and the de-insurance policy in the first data table can be removed by acquiring the de-insurance information and the de-insurance policy information of the policy to remove the policy which is stored in the first data table and does not need to be processed, so that only the policy which needs to be processed is stored in the first data table.

And a new mark deleting unit 105, configured to delete the new mark of the policy in the first data table.

Deleting the newly added mark of the policy in the first data table, wherein the newly added mark of the policy is mark information for judging whether the policy is added to the newly added policy, and deleting the newly added mark of the policy in the first data table to be convenient for distinguishing from the subsequently added policy, so that a user can conveniently carry out statistical analysis on the policy in the first data table in the subsequent processing process.

In addition, after the new flag of the policy in the first data table is deleted, the calculation process of the policy in the first data table can be performed. For example, a specific calculation procedure is: and calculating the valid period proportion, the unexpired premium and the reserve fund of the policy according to the creation date, the expiration time, the premium amount and the re-insurance division proportion of the policy in the first data table so as to facilitate the user to obtain the calculated calculation result and carry out statistical analysis on the financial condition of the policy in the first data table. And storing the calculated calculation result so as to facilitate the statistical analysis of the financial condition of the policy in the first data table by the user.

And a new policy adding unit 106, configured to, if the current time reaches the next month and day, obtain a new policy for the previous month according to the current time, add the obtained new policy for the previous month to the first data table, and add a new flag to the new policy for the previous month.

And adding the obtained newly increased policy in the previous month into the first data table according to the judgment result, and adding a newly increased mark to the newly increased policy in the previous month added into the first data table. And adding a new mark for the previous month new policy added in the first data table after obtaining the previous month new policy according to the current time. The newly added mark of the policy is mark information used for adding whether the policy is the newly added policy or not, and the newly added mark is added to the newly added policy in the last month added in the first data table, so that whether the policy in the first data table is the newly added policy or not is distinguished, and the statistical analysis of the policy in the first data table by a user in the subsequent processing process can be facilitated.

The previous month receipt information processing unit 107 is configured to obtain the correction processing information and the date correction information in the previous month receipt processing information, and remove the policy in the first data table according to the correction processing information and the date correction information.

The previous month bill processing information is information for performing bill processing on the insurance policy completed in the previous month, and corresponding insurance policies in the first data table can be removed according to the correction processing information in the previous month bill processing information; and updating the due time of the policy in the first data table according to the date correction information in the previous-month policy processing information to obtain the policy with the updated due time in the first data table, and removing the policy in the first data table according to the updated due time of the policy.

In another embodiment of the present invention, as shown in fig. 8, the previous monthly statement information processing unit 107 includes sub-units: a first modification unit 1071 and a second modification unit 1072.

The first modification unit 1071 is configured to obtain modification information, remove a corresponding policy in the first data table according to the modification information, and transfer the policy to the second data table for storage.

In other embodiments of the present invention, as shown in fig. 9, the first modification processing unit 1071 includes sub-units: a policy matching unit 10711 and a policy dump unit 10712.

A warranty matching unit 10711 for searching the first data table for a modified warranty matching the modification processing information according to the modification processing information.

And after the addition of the newly added policy in the previous month is finished, acquiring the correction processing information in the previous month policy processing information, and matching the correction processing information with the policy in the first data table to obtain the corrected policy matched with the correction processing information in the first data table. And removing the corresponding warranty in the first data table according to the correction processing information in the previous statement processing information, wherein the corrected warranty does not need to be stored in the first data table and needs to be transferred to the second data table for storage.

The policy unloading unit 10712 is used to transfer the modified policy from the first data table to the second data table for saving, and remove the modified policy from the first data table.

The second correcting processing unit 1072 is configured to update the expiration time of the policy in the first data table according to the date correcting information, and remove the policy that is not in the validity period according to the updated expiration time of the policy.

Because the policy needs to be renewed or the policy is terminated within the validity period, the expiration time of the policy in the first data table needs to be updated according to the date correction information, and the expiration time of the policy in the first data table can be updated according to the date correction information, so that the policy processed according to the date correction information can be obtained.

In another embodiment of the present invention, as shown in fig. 10, the second modifying unit 1072 includes sub-units: policy expiration time updating unit 10721, validity period judging unit 10722, and policy removing unit 10723.

A policy expiration time updating unit 10721 for updating the expiration time of the policy in the first data table according to the date correction information.

A validity period determining unit 10722, configured to determine whether the policy is in a validity period according to the current time and the expiration time after updating the policy.

And a policy removing unit 10723 for removing a policy not in the validity period from the first data table according to the judgment result.

And an operation time point changing unit 108, configured to change the operation time point of the first data table to be the last day of the current month, and determine whether the current time reaches the operation time point of the first data table.

And changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table, namely, the time node for processing the policy in the first data table next time is the last day of the current month.

The policy information scroll processing means described above may be implemented in the form of a computer program that can be run on a computer device as shown in fig. 11.

Referring to fig. 11, fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present invention.

Referring to fig. 11, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.

The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032, when executed, causes the processor 502 to perform a policy information scroll processing method.

The processor 502 is used to provide computing and control capabilities that support the operation of the overall computer device 500.

The internal memory 504 provides an environment for running the computer program 5032 in the nonvolatile storage medium 503, and when the computer program 5032 is executed by the processor 502, the processor 502 can be caused to execute the policy information rolling processing method.

The network interface 505 is used for network communication. Those skilled in the art will appreciate that the configuration shown in fig. 11 is a block diagram of only a portion of the configuration associated with aspects of the present invention and is not intended to limit the computing device 500 to which aspects of the present invention may be applied, and that a particular computing device 500 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

Wherein the processor 502 is configured to run the computer program 5032 stored in the memory to implement the following functions: creating a first data table for saving a current effective policy and a second data table for backing up a historical policy, and configuring the running time point of the first data table as the last day of the current month; acquiring a policy pre-stored in a historical data table, acquiring the policy in the validity period in the historical data table according to the current time, storing the policy in the created first data table, and adding a new mark to the policy stored in the first data table; if the current time reaches the operation time point of the first data table, judging whether the policy in the first data table has a newly added mark, and storing the policy with the newly added mark into the second data table for backup; acquiring policy de-insurance information and policy de-insurance information, and removing the invalid policy corresponding to the policy de-insurance information and the policy de-insurance information from the first data table; deleting the newly added mark of the policy in the first data table; if the current time reaches the next month and the day, acquiring a newly-increased policy in the previous month according to the current time, adding the acquired newly-increased policy in the previous month into a first data table, and adding a newly-increased mark for the newly-increased policy in the previous month; acquiring correction processing information and date correction information in previous month correction processing information, and removing the insurance policy in the first data table according to the correction processing information and the date correction information; and changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table.

In one embodiment, the processor 502 performs the following operations when executing the steps of acquiring a policy stored in advance in the history data table, acquiring a policy in the validity period in the history data table according to the current time, saving the policy in the created first data table, and adding a new mark to the policy saved in the first data table: acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy; and acquiring the policy in the validity period according to the judgment result and storing the policy in the validity period into the created first data table.

In an embodiment, when the processor 502 executes the step of acquiring the correction processing information and the date correction information in the previous month bill processing information and removing the insurance policy in the first data table according to the correction processing information and the date correction information, the following operations are executed: acquiring correction processing information, removing corresponding insurance policies in the first data table according to the correction processing information, and transferring the insurance policies to the second data table for storage; and updating the expiration time of the policy in the first data table according to the date correction information, and removing the policy which is not in the valid period according to the updated expiration time of the policy.

In an embodiment, when the processor 502 executes the steps of obtaining the correction processing information, removing the corresponding policy in the first data table according to the correction processing information, and transferring the policy to the second data table for saving, the following operations are executed: inquiring a modified insurance policy matched with the modification processing information in a first data table according to the modification processing information; and transferring the approved insurance policy from the first data table to a second data table for storage, and removing the approved insurance policy from the first data table.

In one embodiment, the processor 502 performs the following operations when executing the steps of updating the expiration time of the policy in the first data table according to the date modification information and removing the policy which is not in the validity period according to the updated expiration time of the policy: updating the expiration time of the policy in the first data table according to the date correction information; judging whether the policy is in the valid period according to the current time and the expiration time after updating the policy; and removing the insurance policy which is not in the validity period from the first data table according to the judgment result.

Those skilled in the art will appreciate that the embodiment of a computer device illustrated in fig. 11 does not constitute a limitation on the specific construction of the computer device, and that in other embodiments a computer device may include more or fewer components than those illustrated, or some components may be combined, or a different arrangement of components. For example, in some embodiments, the computer device may only include a memory and a processor, and in such embodiments, the structures and functions of the memory and the processor are consistent with those of the embodiment shown in fig. 11, and are not described herein again.

It should be understood that, in the embodiment of the present invention, the Processor 502 may be a Central Processing Unit (CPU), and the Processor 502 may also be other general purpose processors, digital Signal Processors (DSPs), application Specific Integrated Circuits (ASICs), field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

In another embodiment of the present invention, a storage medium is provided. The storage medium may be a non-volatile computer-readable storage medium. The storage medium stores a computer program, wherein the computer program when executed by a processor implements the steps of: creating a first data table for saving a current effective policy and a second data table for backing up a historical policy, and configuring the running time point of the first data table as the last day of the current month; acquiring a policy stored in a historical data table in advance, acquiring the policy in the validity period in the historical data table according to the current time, storing the policy in the established first data table, and adding a new mark to the policy stored in the first data table; if the current time reaches the operation time point of the first data table, judging whether the policy in the first data table has a newly added mark, and storing the policy with the newly added mark into the second data table for backup; acquiring policy de-insurance information and policy logout information, and removing invalid policies corresponding to the policy de-insurance information and the policy logout information from the first data table; deleting the newly added mark of the policy in the first data table; if the current time reaches the next month and day, acquiring a newly-increased policy in the previous month according to the current time, adding the acquired newly-increased policy in the previous month into a first data table, and adding a newly-increased mark for the newly-increased policy in the previous month; acquiring correction processing information and date correction information in previous month correction processing information, and removing the insurance policy in the first data table according to the correction processing information and the date correction information; and changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table.

In an embodiment, the step of obtaining the policy stored in the history data table in advance, obtaining the policy in the validity period in the history data table according to the current time, saving the policy in the created first data table, and adding a new mark to the policy saved in the first data table includes: acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy; and acquiring the policy in the validity period according to the judgment result and storing the policy in the validity period into the created first data table.

In an embodiment, the step of obtaining the correction processing information and the date correction information in the previous batch processing information and removing the policy in the first data table according to the correction processing information and the date correction information includes: acquiring correction processing information, removing corresponding insurance policies in the first data sheet according to the correction processing information, and transferring the corresponding insurance policies to the second data sheet for storage; and updating the expiration time of the policy in the first data table according to the date correction information, and removing the policy which is not in the valid period according to the updated expiration time of the policy.

In an embodiment, the step of acquiring the correction processing information, removing the corresponding policy from the first data table according to the correction processing information, and transferring the policy to the second data table for saving includes: inquiring a modified insurance policy matched with the modification processing information in a first data table according to the modification processing information; and transferring the modified insurance policy from the first data table to a second data table for storage, and removing the modified insurance policy from the first data table.

In an embodiment, the step of updating the expiration time of the policy in the first data table according to the date correction information and removing the policy not in the validity period according to the updated expiration time of the policy includes: updating the expiration time of the policy in the first data table according to the date correction information; judging whether the policy is in the valid period according to the current time and the expiration time after updating the policy; and removing the insurance policy which is not in the validity period from the first data table according to the judgment result.

It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses, devices and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only a logical division, and there may be other divisions in actual implementation, or units with the same function may be grouped into one unit, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may also be an electric, mechanical or other form of connection.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a storage medium. Based on such understanding, the technical solution of the present invention essentially or partly contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk.

While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A policy information scroll processing method is characterized by comprising the following steps:

acquiring a policy stored in a historical data table in advance, acquiring the policy in the validity period in the historical data table according to the current time, storing the policy in the established first data table, and adding a new mark to the policy stored in the first data table;

deleting the newly added mark of the policy in the first data table;

if the current time reaches the next month and day, acquiring a newly-increased policy in the previous month according to the current time, adding the acquired newly-increased policy in the previous month into a first data table, and adding a newly-increased mark for the newly-increased policy in the previous month;

changing the operation time point of the first data table to be the last day of the current month, and judging whether the current time reaches the operation time point of the first data table;

the acquiring the correction processing information and the date correction information in the previous month correction processing information, and removing the insurance policy in the first data table according to the correction processing information and the date correction information comprises:

acquiring correction processing information, removing corresponding insurance policies in the first data table according to the correction processing information, and transferring the insurance policies to the second data table for storage;

updating the expiration time of the policy in the first data table according to the date correction information, and removing the policy which is not in the validity period according to the updated expiration time of the policy;

the removing the corresponding insurance policy in the first data sheet according to the correction processing information and transferring the insurance policy to the second data sheet for storage comprises the following steps:

inquiring a modified warranty matched with the modifying processing information in the first data table according to the modifying processing information;

transferring the modified warranty from the first data table to a second data table for storage, and removing the modified warranty from the first data table;

calculating the valid period proportion, the unexpired premium and the reserve fund of the policy according to the creation date, the expiration time, the premium amount and the re-insurance separation proportion of the policy in the first data table so as to facilitate a user to obtain a calculated calculation result and perform statistical analysis on the financial condition of the policy in the first data table; and storing the calculated calculation result so as to facilitate the statistical analysis of the financial condition of the policy in the first data table by the user.

2. The policy information rolling processing method according to claim 1, wherein the obtaining of the policy in the validity period in the history data table according to the current time and saving of the policy in the created first data table comprises:

acquiring the expiration time of the policy in the historical data table, and judging whether the policy is in the valid period according to the current time and the expiration time of the policy;

and acquiring the policy in the validity period according to the judgment result and storing the policy in the validity period into the created first data table.

3. The policy information rolling processing method according to claim 1, wherein said removing policy that is not in validity period according to expiration time after policy update comprises:

updating the expiration time of the policy in the first data table according to the date correction information;

judging whether the policy is in the valid period according to the current time and the expiration time after updating the policy;

and removing the insurance policy which is not in the validity period from the first data table according to the judgment result.

4. A policy information scroll processing apparatus, comprising:

the operation time point changing unit is used for changing the operation time point of the first data table to be the last day of the current month and judging whether the current time reaches the operation time point of the first data table;

the previous monthly batch information processing unit comprises:

the first correction processing unit is used for acquiring correction processing information, removing corresponding insurance policies in the first data table according to the correction processing information, and transferring the insurance policies to the second data table for storage;

the second correction processing unit is used for updating the expiration time of the policy in the first data table according to the date correction information and removing the policy which is not in the validity period according to the updated expiration time of the policy;

the first batch modification processing unit comprises subunits: the warranty matching unit is used for inquiring the approved warranty matched with the correction processing information in the first data table according to the correction processing information; the insurance policy unloading unit is used for transferring the approved insurance policy from the first data table to the second data table for storage and removing the approved insurance policy from the first data table;

5. The policy information roll processing device according to claim 4, wherein the validity period policy adding unit comprises:

the date judging unit is used for acquiring the expiration time of the policy in the historical data table and judging whether the policy is in the valid period according to the current time and the expiration time of the policy;

and the policy adding unit is used for acquiring the policy in the valid period according to the judgment result and storing the policy in the valid period into the created first data table.

6. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the policy information rolling processing method according to any one of claims 1 to 3 when executing the computer program.

7. A storage medium characterized in that the storage medium stores a computer program which, when executed by a processor, causes the processor to execute the policy information scroll processing method according to any one of claims 1 to 3.