Voucher production scheduling method, device, computer system and readable storage medium
By periodically obtaining and managing the tasks and execution status of the policy information table, CPU consumption is distributed, and the problem of being unable to complete the creation of credentials within a limited time in the prior art is solved, ensuring timely generation of credentials and continuity of user services.
Patent Information
- Application Number
- CN202010127180.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2020-02-28
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2040-02-28
AI Technical Summary
The prior art uses a large number of insurance policy information tables to make certificates within a limited time, resulting in excessive CPU computing consumption of servers, inability to complete credential production within a limited time, and occupying CPU resources, causing users to be unable to handle other services.
By periodically obtaining target policy information tables from the database, using task control tables and execution status tables to manage tasks and execution status, dispersing CPU consumption, and using certificate making threads to call certificate making procedures to prepare certificates for global temporary tables to ensure that certificate information and The policy information table is associated with storage.
Real-time processing of insurance policy information tables is realized, avoiding the server CPU consumption and the user's inability to handle other services, and ensuring that all credentials are completed within a limited time.
Smart Images

Figure CN111352714B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a voucher production scheduling method, device, computer system and readable storage medium. Background Art
[0002] According to the accrual basis of accounting, after the user purchases an insurance policy, an accounts receivable voucher is generated based on the organization's summary when the policy starts. In order to facilitate the query of the policy based on the voucher and the query of the voucher based on the policy, and to ensure that the list and the voucher are consistent, the property insurance company will write the voucher number and voucher date of the accounts receivable voucher back to the policy information; the current voucher information certification system usually uses the JOB function of the database during non-working hours to first find out from the policy information table all the data with an insurance start date in the current period and that should have been certified but has not been certified, and perform logical processing on the certification; in order to ensure that the certification does not affect production business, the certification requirement is to complete the certification before the next working day. If it is not completed, the certification will be forcibly stopped.
[0003] However, with the continuous development of the industry, the daily insurance policy volume has exploded, requiring the current certificate-making system to produce a large number of insurance policy information sheets at one time within a limited time (such as from the end of the day's working hours to the beginning of the next day's working hours). This causes the server's CPU computing consumption to increase in a short period of time, which not only easily leads to the inability to complete the production of all certificates within the limited time, but also because the server's CPU computing power is occupied by the certificate-making program for a large amount and for a long time, resulting in the user being unable to handle other business through the server during this time period. Summary of the invention
[0004] The purpose of the present invention is to provide a voucher production scheduling method, device, computer system and readable storage medium, which are used to solve the problems existing in the prior art that a large number of insurance policy information tables need to be produced at one time within a limited time, resulting in an increase in server CPU computing consumption in a short period of time, resulting in the inability to complete the production of all certificates within the limited time, and the CPU computing power of the server is occupied by the certificate production program for a large amount and for a long time, making it impossible for users to process other business through the server during this time period.
[0005] To achieve the above object, the present invention provides a voucher production scheduling method, comprising:
[0006] Periodically obtaining a target insurance policy information table from a preset database, obtaining the institution data in the target insurance policy information table and storing it in a first task control table, and marking the task status of the institution data in the first task control table;
[0007] Acquire task mechanism data from the first task control table according to the task status through the scheduling framework, acquire execution mechanism data from the second task control table according to the execution status of the task mechanism data, and store the execution mechanism data in a global temporary table;
[0008] Start a certification thread to call a certification program to certify the execution mechanism data in the global temporary table to obtain credential information, and modify the task status of the execution mechanism data in the first task control table and the execution status of the second task control table;
[0009] The credential information is associated with the target policy information table and stored in the database.
[0010] In the above scheme, periodically obtaining the target insurance policy information table from the preset database includes:
[0011] Create a scheduling framework, an organization directory and a first task control table, wherein the scheduling framework is used to start the certificate making thread in the system program and call the certificate making program, the organization directory is used to store and mark the organization name, and the first task control table is used to store the organization data and mark its task status;
[0012] The scheduling framework is provided with a scheduling time point. If the current time reaches the scheduling time point, the scheduling framework is started to obtain the institution name from the institution directory and output it to the database, so as to achieve the purpose of periodically obtaining the target policy information table from the database;
[0013] The insurance policy information table with the institution name is queried through the database, and whether the insurance policy information table is associated with the credential information; if not, the insurance policy information table is set as the target insurance policy information table; if so, the insurance policy information table is returned to the database.
[0014] In the above solution, before obtaining the task mechanism data from the first task control table according to the task status through the scheduling framework, the following steps are included:
[0015] Creating a second task control table for storing mechanism data and marking its execution status, copying the mechanism data in the first task control table, and marking the execution status of the mechanism data in the second task control table;
[0016] The task status of each institution data in the first task control table is detected by the started scheduling framework, and the institution data with the task status of pending certification is set as the task institution data;
[0017] The execution status of the task mechanism data in the second task control table is detected by the scheduling framework, and the task mechanism data with an execution status of not being executed is set as the execution mechanism data.
[0018] In the above solution, after storing the actuator data in the global temporary table, the method further includes:
[0019] The execution status of the execution mechanism data in the second task control table is modified to being executed.
[0020] In the above scheme, starting the certification thread to call the certification program to certify the execution agency data in the global temporary table to obtain the credential information includes:
[0021] Start the system program's certificate-making thread;
[0022] Calling a pre-stored certificate-making program in the server through the certificate-making thread;
[0023] The execution agency data in the global temporary table is extracted, and the execution agency data is authenticated by the authentication program to obtain credential information.
[0024] In the above solution, modifying the task status of the execution mechanism data in the first task control table and the execution status of the second task control table includes:
[0025] Modify the task status of the execution agency data in the first task control table from pending certification to completed;
[0026] The execution status of the execution mechanism data in the second task control table is changed from being executed to being executed successfully.
[0027] In the above solution, associating the credential information with the target policy information table and storing it in the database includes:
[0028] Writing the current voucher number and voucher date in the voucher information into the target policy information table, so that the voucher information is associated with the target policy information table;
[0029] Detect whether the task status of all target insurance policy information in the first task control table is completed; if so, generate a certificate completion signal and add a scheduling time point in the scheduling framework; if not, obtain the task agency data from the first task control table again, and obtain the execution agency data from the second task control table according to the execution status of the task agency data and store it in the global temporary table, and start the certificate thread to call the certificate program to certify the execution agency data in the global temporary table to obtain the credential information;
[0030] The certificate information and target insurance policy information are stored in a database according to a certificate completion signal.
[0031] To achieve the above object, the present invention also provides a voucher production scheduling device, comprising:
[0032] A data extraction and status marking module, used to obtain a target policy information table from a preset database, obtain the institution data in the target policy information table and store it in a first task control table, and mark the task status of the institution data in the first task control table;
[0033] A task execution status management module, used for obtaining task mechanism data from a first task control table according to the task status through a scheduling framework, obtaining execution mechanism data from a second task control table according to the execution status of the task mechanism data, and storing the execution mechanism data in a global temporary table;
[0034] A voucher making module, used for starting a voucher making thread to call a voucher making program to make a voucher for the execution agency data in the global temporary table to obtain voucher information, and modifying the task status of the execution agency data in the first task control table and the execution status of the second task control table;
[0035] The voucher feedback module is used to associate the voucher information with the target policy information table and store it in the database.
[0036] To achieve the above-mentioned purpose, the present invention also provides a computer system, which includes multiple computer devices, each of which includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processors of the multiple computer devices execute the computer program, they jointly implement the steps of the above-mentioned voucher production scheduling method.
[0037] To achieve the above-mentioned purpose, the present invention also provides a computer-readable storage medium, which includes multiple storage media, each storage medium stores a computer program, and when the computer programs stored in the multiple storage media are executed by a processor, they jointly implement the steps of the above-mentioned voucher production scheduling method.
[0038] The voucher production scheduling method, device, computer system and readable storage medium provided by the present invention realize real-time processing of the policy information table by periodically obtaining the target policy information table and controlling the task status and execution status of the mechanism data through the first task control table and the second task control table, and periodically disperse the CPU consumption of the server into scattered time periods every day, thereby avoiding the current certificate production system needing to produce a large number of policy information tables at one time within a limited time, resulting in an increase in the CPU computing consumption of the server in a short period of time, and the CPU computing power of the server being occupied by the certificate production program for a large amount and for a long time, resulting in the user being unable to process other services through the server during the time period;
[0039] By storing the executing agency data that needs to be certified in a global temporary table, and calling the certification program through the certification thread to certify the executing agency data in the global temporary table to obtain the credential information, the agency data in the target policy information table that needs to be certified can only be completed after the credential is completely produced. Therefore, it is ensured that the agency data obtained in each cycle can be used to produce certificates, avoiding the current problem of not being able to complete the production of all certificates within the limited time. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 This is a flow chart of Embodiment 1 of the voucher production scheduling method of the present invention;
[0041] Figure 2 This is a workflow diagram between a voucher production scheduling device and a service system in Embodiment 1 of the voucher production scheduling method of the present invention;
[0042] Figure 3 A schematic diagram of a program module of a second embodiment of a voucher production and scheduling device of the present invention;
[0043] Figure 4 Schematic diagram of the hardware structure of the computer device in the third embodiment of the computer system of the present invention.
[0044] Reference numerals:
[0045] 1. Voucher production and scheduling device 2. Server 3. Network 4. Database 5. Computer equipment
[0046] 11. Data extraction and status marking module 12. Task execution status management module
[0047] 13. Voucher making module 14. Voucher feedback module 51. Memory 52. Processor DETAILED DESCRIPTION
[0048] In order to make the purpose, technical scheme and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention. 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.
[0049] The voucher production scheduling method, device, computer system and readable storage medium provided by the present invention are applicable to the computer field, and provide a voucher production scheduling method based on a data extraction and status marking module, a task execution status management module, a voucher production module and a voucher feedback module. The present invention periodically obtains the target policy information table, and controls the task status and execution status of the agency data through the first task control table and the second task control table, and stores the execution agency data to be produced in a global temporary table, and uses the certificate production thread to call the certificate production program to produce the execution agency data in the global temporary table to obtain the voucher information, thereby realizing real-time processing of the policy information table, periodically dispersing the CPU consumption of the server into scattered time periods every day, and ensuring that the agency data obtained in each cycle can be used to produce vouchers.
[0050] Embodiment 1
[0051] See also Figure 1 A voucher production scheduling method of this embodiment includes:
[0052] S101: periodically obtaining a target insurance policy information table from a preset database, obtaining the institution data in the target insurance policy information table and storing it in a first task control table, and marking the task status of the institution data in the first task control table;
[0053] S102: acquiring task mechanism data from the first task control table according to the task status through the scheduling framework, acquiring execution mechanism data from the second task control table according to the execution status of the task mechanism data, and storing the execution mechanism data in a global temporary table;
[0054] S103: Start a certification thread to call a certification program to certify the execution mechanism data in the global temporary table to obtain credential information, and modify the task status of the execution mechanism data in the first task control table and the execution status of the second task control table;
[0055] S104: Associating the credential information with the target policy information table and storing it in the database.
[0056] In an exemplary embodiment, see Figure 2, a server 2 running a data scheduling method is connected to a database 4 through a network 3. After the server 2 obtains a target policy information table from the database 4, extracts the institution data in the target policy information table and stores it in the first task control table, it marks the task status of the institution data in the first task control table; wherein the policy information table is a form stored in the database 4 for storing institution names and institution data, and the database 4 is a data storage institution for insurance institutions to store and manage institution data; the institution data includes: institution name, policy number, individual group information, channel information, insurance type information, amount information, currency information, policy description information and cost center; the task status includes pending certification and completed; at the same time, the execution status includes not executed, executing and successfully executed; the server 2 uses the scheduling framework according to the The task status obtains the task mechanism data from the first task control table, obtains the execution mechanism data from the second task control table according to the execution status of the task mechanism data, and stores the execution mechanism data in the global temporary table; and starts the certificate making thread to call the certificate making program to make a certificate for the execution mechanism data in the global temporary table to obtain the credential information, and modifies the task status of the execution mechanism data in the first task control table and the task status in the second task control table; the server 2 associates the credential information with the target policy information table and stores it in the database 4, wherein the credential information can be associated with the target policy information table by writing the current voucher number and voucher date in the voucher information into the target policy information table.
[0057] In a preferred embodiment, periodically obtaining the target insurance policy information table from a preset database includes:
[0058] Create a scheduling framework, an organization directory and a first task control table, wherein the scheduling framework is used to start the certificate making thread in the system program and call the certificate making program, the organization directory is used to store and mark the organization name, and the first task control table is used to store the organization data and mark its task status;
[0059] The scheduling framework is provided with a scheduling time point. If the current time reaches the scheduling time point, the scheduling framework is started to obtain the institution name from the institution directory and output it to the database, so as to achieve the purpose of periodically obtaining the target policy information table from the database;
[0060] The insurance policy information table with the institution name is queried through the database, and whether the insurance policy information table is associated with the credential information; if not, the insurance policy information table is set as the target insurance policy information table; if so, the insurance policy information table is returned to the database.
[0061] It should be noted that the system program is pre-stored in the server, which is written in JAVA language and has a certificate thread, wherein a thread is a unit that the system program can perform calculation scheduling, which is contained in the process and is the actual operation unit in the process. A thread refers to a single sequential control flow in a process, and multiple threads can be concurrent in a process, each thread executing different tasks in parallel. The certificate thread in this application is a thread used to call the certificate program; the certificate program is installed in the system program, and is a computer program used to extract information from the institution data and convert and summarize it to obtain credential information; this application sends the institution name to the database in sequence according to the order of the institution name in the institution directory, so as to achieve the technical effect of obtaining the target policy information table according to the institution name. Since the number of policy information tables stored in the database is hundreds of millions, this application avoids the current situation that the server's CPU, I / O and memory are consumed a lot due to the one-time acquisition of a large number of form data tables, resulting in a long time to obtain policy information and low processing efficiency.
[0062] In a preferred embodiment, before obtaining the task mechanism data from the first task control table according to the task status through the scheduling framework, the method includes:
[0063] Creating a second task control table for storing mechanism data and marking its execution status, copying the mechanism data in the first task control table, and marking the execution status of the mechanism data in the second task control table;
[0064] The task status of each institution data in the first task control table is detected by the started scheduling framework, and the institution data with the task status of pending certification is set as the task institution data;
[0065] The execution status of the task mechanism data in the second task control table is detected by the scheduling framework, and the task mechanism data with an execution status of not being executed is set as the execution mechanism data.
[0066] It should be noted that the scheduling framework is a Quartz open source job scheduling framework written in Java, which is not only used for threads and thread management, but also because it uses a multi-threaded architecture, it can realize the simultaneous start of multiple certificate-making threads to call the certificate-making program to make certificates for the execution agency data; the scheduling framework is provided with a scheduling time point, which is used to trigger the scheduling framework to obtain the agency data from the task list when the current time reaches the scheduling time point, and store it in the global temporary table.
[0067] In a preferred embodiment, after storing the actuator data in the global temporary table, the method further includes:
[0068] The execution status of the execution mechanism data in the second task control table is modified to being executed.
[0069] In this step, the execution status of the execution agency data stored in the global temporary table in the second task control table is modified to executing to avoid the situation of duplicate certificate. This method not only improves the accuracy and efficiency of certificate production, but also avoids the credential information generation errors caused by duplicate certificate.
[0070] In a preferred embodiment, starting the certification thread to call the certification program to certify the execution agency data in the global temporary table to obtain the credential information includes:
[0071] Start the system program's certificate-making thread;
[0072] Calling a pre-stored certificate-making program in the server through the certificate-making thread;
[0073] The execution agency data in the global temporary table is extracted, and the execution agency data is authenticated by the authentication program to obtain credential information.
[0074] It should be noted that the global temporary table is a kind of intermediate result set used to save transactions or sessions. The session in this application refers to the whole process of a subject calling the certificate making program through the scheduling framework and the certificate making thread to make a certificate for the execution agency data. The data saved in the global temporary table in this application is only visible to the session of the current subject (the current subject is the module that controls the scheduling framework and calls the certificate making program). The sessions of all other subjects (the other subjects are modules that control other frameworks or call other programs) cannot know the data of the current subject's session, and the session of the current subject has submitted the credential information, and the sessions of other subjects cannot know the credential information. Therefore, the global temporary table in this application will not have multi-user concurrency problems, that is, the situation where other subjects cannot use the global temporary table because of the use of the global temporary table by a certain subject will not occur, making this application highly compatible and reliable.
[0075] Optionally, the global temporary table of the present application may adopt a Temporary table developed by Oracle.
[0076] In this embodiment, the certificate making threads of the system program can be started continuously, each certificate making thread calls the certificate making program respectively, and extracts an execution agency data in the global temporary table to make a certificate for it, thereby achieving the technical effect of multi-threaded certificate making. This method improves the efficiency of certificate making of credential information; at the same time, the number of certificate making threads started by the scheduling framework can also be adjusted according to the resource consumption of the server to take into account both certificate making efficiency and certificate making reliability.
[0077] Specifically, the certification data is certified by the certification program to obtain the credential information, including:
[0078] Obtain the maximum voucher number from the database and add a fixed value to it to generate the current voucher number;
[0079] Take the amount information from the policy information table and set it as a debit amount;
[0080] Extracting individual group information from the actuator data and converting it into an individual group code;
[0081] Extracting channel information from the actuator data and converting it into a channel code;
[0082] Extracting the insurance type information in the execution agency data and converting it into an insurance type code;
[0083] Extracting currency information from the actuator data and converting it into a currency code;
[0084] Extracting the policy description information in the execution agency data and converting it into voucher type, voucher status, account, transaction party, and related party;
[0085] Set the current date as the voucher date;
[0086] The voucher information is obtained by summarizing the current voucher number, debit amount, group code, channel code, insurance code, currency code, voucher type, voucher status, account, trader, related party, voucher date and cost center in the execution agency data.
[0087] It should be noted that: the policy description information contains the policy type, policy status, account, counterparty and related party used to describe the policy. Therefore, by extracting the policy type, policy status, account, counterparty and related party, and setting them as voucher type, voucher status, account, counterparty and related party; the server also has a code database, and the code database has individual group information, individual group code and the correspondence between individual group information and individual group code, and channel information, channel code and the correspondence between channel information and channel code, and insurance type information, insurance type code and the correspondence between insurance type information and insurance type code, and currency information, currency code and the correspondence between currency information and currency code; therefore, the present application obtains the individual group code according to the individual group information, obtains the channel code according to the channel information, obtains the insurance type code according to the insurance type information, and obtains the currency code according to the currency information through the code database.
[0088] In this embodiment, obtaining the maximum voucher number from the database and adding a fixed value thereto to generate the current voucher number includes:
[0089] Extracting a policy information table associated with voucher information from the database according to the institution name;
[0090] Extract the voucher number of each voucher information, and take the voucher number with the largest value as the maximum voucher number;
[0091] A fixed value is added to the maximum voucher number to obtain the current voucher number.
[0092] The fixed value may be 1.
[0093] In a preferred embodiment, modifying the task status of the execution mechanism data in the first task control table and the execution status of the second task control table includes:
[0094] Modify the task status of the execution agency data in the first task control table from pending certification to completed;
[0095] The execution status of the execution mechanism data in the second task control table is changed from being executed to being executed successfully.
[0096] In this step, by modifying the task status and execution status, the task organization data in the first task control table or the execution data in the second task control table is avoided from being repeatedly called or duplicated, thereby improving the efficiency and accuracy of producing credential information.
[0097] Furthermore, the modifying of the state mark in the first task control table of the actuator data and the execution mark in the second task control table further includes:
[0098] The actuator data in the global temporary table is deleted, and the memory burden of the server is timely reduced by deleting the data in the global temporary table, thereby ensuring that the server can run smoothly.
[0099] In a preferred embodiment, associating the credential information with the target policy information table and storing it in the database comprises:
[0100] Writing the current voucher number and voucher date in the voucher information into the target policy information table, so that the voucher information is associated with the target policy information table;
[0101] Detect whether the task status of all target insurance policy information in the first task control table is completed; if so, generate a certificate completion signal and add a scheduling time point in the scheduling framework; if not, obtain the task agency data from the first task control table again, and obtain the execution agency data from the second task control table according to the execution status of the task agency data and store it in the global temporary table, and start the certificate thread to call the certificate program to certify the execution agency data in the global temporary table to obtain the credential information;
[0102] The certificate information and target insurance policy information are stored in a database according to a certificate completion signal.
[0103] It should be noted that when all the institution data in the first task control list have completed certificate production, the certificate production is terminated and a new scheduling time point is added, so that when the scheduling framework reaches the scheduling time point, it will start again and obtain the next institution name from the institution directory and output it to the database; this application uses this "relay" method to promptly terminate the certificate production and add a new scheduling time point when all the institution data in the first task control table have completed certificate production, so that the scheduling framework can receive the institution data from the database according to the next institution name, which not only disperses the consumption of server computing power, but also ensures the continuity of the policy information form certificate production operation, improves the efficiency of certificate production, and reduces the burden on the server.
[0104] Embodiment 2
[0105] See also Figure 3 , a voucher production scheduling device 1 of this embodiment includes:
[0106] The data extraction and status marking module 11 is used to periodically obtain a target policy information table from a preset database, obtain the institution data in the target policy information table and store it in a first task control table, and mark the task status of the institution data in the first task control table;
[0107] The task execution state management module 12 is used to obtain the task mechanism data from the first task control table according to the task state through the scheduling framework, obtain the execution mechanism data from the second task control table according to the execution state of the task mechanism data, and store the execution mechanism data in the global temporary table;
[0108] The voucher making module 13 is used to start the voucher making thread to call the voucher making program to make a voucher for the execution agency data in the global temporary table to obtain voucher information, and to modify the task status of the execution agency data in the first task control table and the execution status in the second task control table;
[0109] The voucher feedback module 14 is used to associate the voucher information with the target policy information table and store it in the database.
[0110] This technical solution is based on the development technology of R&D management. It periodically obtains the target policy information table, and controls the task status and execution status of the agency data through the first task control table and the second task control table. It stores the execution agency data that needs to be certified in a global temporary table, and uses the certification thread to call the certification program to certify the execution agency data in the global temporary table to obtain credential information, so as to optimize the credential information generation process, thereby achieving the technical effect of optimizing the transaction processing process.
[0111] Embodiment three:
[0112] To achieve the above-mentioned purpose, the present invention further provides a computer system, which includes a plurality of computer devices 5. The components of the voucher production and scheduling device 1 of the second embodiment can be dispersed in different computer devices. The computer devices can be smart phones, tablet computers, laptop computers, desktop computers, rack servers, blade servers, tower servers or cabinet servers (including independent servers, or server clusters composed of multiple servers) that execute programs. The computer devices of this embodiment include at least but are not limited to: a memory 51 and a processor 52 that can be interconnected through a system bus, such as Figure 4 It should be pointed out that Figure 4 Only a computer device with components is shown, but it should be understood that implementing all of the components shown is not a requirement and more or fewer components may alternatively be implemented.
[0113] In this embodiment, the memory 51 (i.e., readable storage medium) includes flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, disk, optical disk, etc. In some embodiments, the memory 51 can be an internal storage unit of a computer device, such as a hard disk or memory of the computer device. In other embodiments, the memory 51 can also be an external storage device of a computer device, such as a plug-in hard disk equipped on the computer device, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), etc. Of course, the memory 51 can also include both the internal storage unit of the computer device and its external storage device. In this embodiment, the memory 51 is generally used to store the operating system and various application software installed on the computer device, such as the program code of the voucher production and scheduling device of the first embodiment. In addition, the memory 51 can also be used to temporarily store various types of data that have been output or are to be output.
[0114] The processor 52 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip in some embodiments. The processor 52 is generally used to control the overall operation of the computer device. In this embodiment, the processor 52 is used to run the program code stored in the memory 51 or process data, such as running the voucher production scheduling device to implement the voucher production scheduling method of the first embodiment.
[0115] Embodiment 4:
[0116] To achieve the above purpose, the present invention also provides a computer-readable storage system, which includes multiple storage media, such as flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, disk, optical disk, server, App application mall, etc., on which a computer program is stored, and the program realizes the corresponding function when executed by the processor 52. The computer-readable storage medium of this embodiment is used to store the voucher production scheduling device, and when executed by the processor 52, the voucher production scheduling method of embodiment 1 is realized.
[0117] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.
[0118] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method.
[0119] The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.
Claims
1. A voucher production scheduling method, characterized in that: include: Periodically obtaining a target insurance policy information table from a preset database, obtaining the institution data in the target insurance policy information table and storing it in a first task control table, and marking the task status of the institution data in the first task control table; The task mechanism data is obtained from the first task control table according to the task status through the scheduling framework, and the execution mechanism data is obtained from the second task control table according to the execution status of the task mechanism data, and the execution mechanism data is stored in the global temporary table; wherein, the task status includes pending certification and completed; the execution status includes unexecuted, executing and successfully executed; the global temporary table is a kind of intermediate result set used to save transactions or sessions, and the session refers to the whole process of a subject calling the certification program through the scheduling framework through the certification thread to certify the execution mechanism data; Start a certification thread to call a certification program to certify the execution mechanism data in the global temporary table to obtain credential information, and modify the task status of the execution mechanism data in the first task control table and the execution status of the second task control table; The step of starting the certification thread to call the certification program to certify the execution agency data in the global temporary table to obtain the credential information includes: Start the system program's certificate-making thread; Calling a pre-stored certificate-making program in the server through the certificate-making thread; Extracting the actuator data in the global temporary table, and certifying the actuator data through the certification program to obtain credential information; The credential information is associated with the target policy information table and stored in the database.
2. The voucher production scheduling method according to claim 1, characterized in that: The process of periodically obtaining the target insurance policy information table from the preset database includes: Create a scheduling framework, an organization directory and a first task control table, wherein the scheduling framework is used to start the certificate making thread in the system program and call the certificate making program, the organization directory is used to store and mark the organization name, and the first task control table is used to store the organization data and mark its task status; The scheduling framework is provided with a scheduling time point. If the current time reaches the scheduling time point, the scheduling framework is started to obtain the institution name from the institution directory and output it to the database, so as to achieve the purpose of periodically obtaining the target policy information table from the database; The insurance policy information table with the institution name is queried through the database, and whether the insurance policy information table is associated with the credential information; if not, the insurance policy information table is set as the target insurance policy information table; if so, the insurance policy information table is returned to the database.
3. The voucher production scheduling method according to claim 1, characterized in that: Before obtaining the task mechanism data from the first task control table according to the task status through the scheduling framework, the following steps are included: Creating a second task control table for storing mechanism data and marking its execution status, copying the mechanism data in the first task control table, and marking the execution status of the mechanism data in the second task control table; The task status of each institution data in the first task control table is detected by the started scheduling framework, and the institution data with the task status of pending certification is set as the task institution data; The execution status of the task mechanism data in the second task control table is detected by the scheduling framework, and the task mechanism data with an execution status of not being executed is set as the execution mechanism data.
4. The voucher production scheduling method according to claim 1, characterized in that: After storing the actuator data in the global temporary table, the following steps are further included: The execution status of the execution mechanism data in the second task control table is modified to being executed.
5. The voucher production scheduling method according to claim 1, characterized in that: Modifying the task status of the execution mechanism data in the first task control table and the execution status of the second task control table includes: Modify the task status of the execution agency data in the first task control table from pending certification to completed; The execution status of the execution mechanism data in the second task control table is changed from being executed to being executed successfully.
6. The voucher production scheduling method according to claim 1, characterized in that: Associating the credential information with the target policy information table and storing it in the database includes: Writing the current voucher number and voucher date in the voucher information into the target policy information table, so that the voucher information is associated with the target policy information table; Detect whether the task status of all target insurance policy information in the first task control table is completed; if so, generate a certificate completion signal and add a scheduling time point in the scheduling framework; if not, obtain the task agency data from the first task control table again, and obtain the execution agency data from the second task control table according to the execution status of the task agency data and store it in the global temporary table, and start the certificate thread to call the certificate program to certify the execution agency data in the global temporary table to obtain the credential information; The certificate information and target insurance policy information are stored in a database according to a certificate completion signal.
7. A voucher production scheduling device, characterized in that: include: A data extraction and status marking module, used to periodically obtain a target policy information table from a preset database, obtain the institution data in the target policy information table and store it in a first task control table, and mark the task status of the institution data in the first task control table; The task execution status management module is used to obtain the task mechanism data from the first task control table according to the task status through the scheduling framework, obtain the execution mechanism data from the second task control table according to the execution status of the task mechanism data, and store the execution mechanism data in the global temporary table; wherein, the task status includes pending certification and completed; the execution status includes unexecuted, executing and successfully executed; the global temporary table is a kind of intermediate result set used to save transactions or sessions, and the session refers to the whole process of a subject calling the certification program through the scheduling framework and the certification thread to certify the execution mechanism data; The credential making module is used to start the credential making thread to call the credential making program to make a credential for the executive body data in the global temporary table to obtain credential information, and to modify the task status of the executive body data in the first task control table and the execution status in the second task control table; wherein, starting the credential making thread to call the credential making program to make a credential for the executive body data in the global temporary table to obtain credential information includes: starting the credential making thread of the system program; calling the credential making program pre-stored in the server through the credential making thread; extracting the executive body data in the global temporary table, and making a credential for the executive body data through the credential making program to obtain credential information; The voucher feedback module is used to associate the voucher information with the target policy information table and store it in the database.
8. A computer system comprising a plurality of computer devices, each of which comprises a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that: When the processors of the plurality of computer devices execute the computer program, the processors jointly implement the steps of the voucher production scheduling method according to any one of claims 1 to 6.
9. A computer-readable storage medium, comprising a plurality of storage media, each storage medium storing a computer program, characterized in that: The computer programs stored in the multiple storage media, when executed by a processor, jointly implement the steps of the voucher production scheduling method according to any one of claims 1 to 6.
Citation Information
Patent Citations
Guarantee slip combining method and device thereof
CN108460682A
Voucher preparation information acquisition method based on service data resources, terminal device and medium
CN109284331A
Data processing method, apparatus, system, and computer readable storage medium
CN109408286A
Electronic voucher service system and method using RFID
WO2009116793A2
