Payroll query method, system, computer storage medium and electronic device
By creating an auxiliary data table in a distributed caching system and leveraging the collaborative work of the query system and the application, the target payroll is filtered out and fed back to the application, thus solving the problem of low payroll query efficiency and achieving efficient payroll retrieval.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- INDUSTRIAL AND COMMERCIAL BANK OF CHINA
- Filing Date
- 2023-03-07
- Publication Date
- 2026-07-03
AI Technical Summary
In existing technologies, the payslip query process is inefficient and it is difficult to efficiently obtain the payslips that need to be queried.
By creating auxiliary data tables in a distributed caching system, and leveraging the collaborative work of the query system and the application, the target payroll with the shortest payroll period relative to the current time is selected and fed back into the application.
It enables efficient and fast processing of payslip inquiries, improves the efficiency of payslip retrieval, and solves the problem of customers having difficulty obtaining payslips efficiently.
Smart Images

Figure CN116204689B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of financial technology, and more specifically, to a method, system, computer storage medium, and electronic device for querying pay slips. Background Technology
[0002] After each quarter, employees can check their payroll by logging into an application on their mobile devices. Since enterprise customer uploads and individual customer queries involve low-frequency writes and high-frequency reads, a read-write separation approach is typically used to meet performance requirements.
[0003] However, in existing technologies, the two types of data in read-write separation are stored using the same data structure, which is a relatively complex storage method and makes it difficult to process payroll efficiently and quickly.
[0004] There is currently no effective solution to the problem that customers have difficulty efficiently obtaining the payroll they need in related technologies. Summary of the Invention
[0005] This application provides a method, system, computer storage medium, and electronic device for querying payslips, in order to solve the problem in related technologies that customers find it difficult to efficiently obtain the payslips they need to query.
[0006] According to one aspect of this application, a method for querying payslips is provided. The method includes: obtaining a query request for a target payslip through a query system and identifying a customer ID in the query request, wherein the query request is a request issued by a target customer through an application, and the customer ID is a number used by the target customer to associate account information on the application; using the identified customer ID, determining whether the target customer has activated the payslip query function in the application, and obtaining a determination result; if the determination result indicates that the target customer has activated the payslip query function, selecting a target payslip for a target payroll period from a distributed cache system, wherein the distributed cache system is used to store payslips for multiple payroll periods for all accounts of multiple customers, and the target payroll period is a preset payroll period with the shortest interval to the current time; and feeding the target payslip back to the application.
[0007] Optionally, before selecting the target payroll for the target payroll period from the distributed cache system, the method further includes: comparing the attribution period of the first payroll with the attribution period of the second payroll in the auxiliary data table to obtain a comparison result, wherein the auxiliary data table is stored in the distributed cache system, the first payroll is the payroll with the shortest interval between the payroll period and the current time, and the second payroll refers to the payroll with the shortest interval between the payroll period and the current time among multiple payrolls stored in the distributed cache system; if the comparison result indicates that the attribution period of the second payroll is later than or equal to the attribution period of the first payroll, the second payroll is determined as the target payroll; if the comparison result indicates that the attribution period of the second payroll is earlier than the attribution period of the first payroll, the first payroll is synchronized to the auxiliary data table, and the first payroll is determined as the target payroll.
[0008] Optionally, before comparing the attribution period of the first payroll with the attribution period of the second payroll in the auxiliary data table, the method further includes: obtaining the first payrolls of multiple customers uploaded by the enterprise to the distributed cache system through the query system, and identifying the account information in each first payroll; determining the customer number of each customer based on the account information, and sending payroll payment notifications to multiple customers based on the customer number.
[0009] Optionally, before comparing the attribution period of the first payroll slip with the attribution period of the second payroll slip in the auxiliary data table, the method further includes: obtaining the second payroll slip from the payroll slips of multiple payroll periods in the distributed cache system, and synchronizing the second payroll slip to the auxiliary data table.
[0010] Optionally, before obtaining the second payslip from multiple payroll periods in the distributed cache system and synchronizing the second payslip to the auxiliary data table, the method further includes: upon receiving a payslip deletion instruction from the target customer through the application, obtaining the attribution period of the payslips from multiple payroll periods in the distributed cache system; obtaining the payslip from the distributed cache system whose attribution period is shortest than the current time, and synchronizing the obtained payslip to the auxiliary data table.
[0011] Optionally, determining whether a target customer has activated the payroll query function in the application using the identified customer ID includes: obtaining the query grayscale switch in the application and determining the status of the query grayscale switch, wherein the query grayscale switch is loaded in the application, and the status of the query grayscale switch is used to indicate whether the query function is online in the customer's region; if the status of the query grayscale switch indicates that the query function is online in the target customer's region, determining whether the period for which the enterprise uploads payrolls is within the target time interval, wherein the target time interval is a sub-interval of the time interval for which the query function is available; if the period for which the enterprise uploads payrolls is within the target time interval, determining that the target customer has activated the payroll query function in the application.
[0012] According to one aspect of this application, a payslip query system is provided. The system includes: a distributed caching system for storing payslips for multiple payroll periods from all accounts of multiple customers uploaded by an enterprise; upon receiving a query request for a target payslip from the query system, the system filters out the target payslip for the preset payroll period with the shortest interval to the current time and transmits the target payslip to the query system; an application communication connection to the query system for sending a query request to the query system and displaying the target payslip upon receiving it from the query system; and a query system communication connection to the distributed caching system for receiving the query request from the application, and, if the system identifies that a customer has activated the payslip query function based on the customer number in the query request, forwarding the query request to the distributed caching system, and also for sending the target payslip to the application upon receiving it from the distributed caching system.
[0013] According to another aspect of this application, a payslip query device is provided. The device includes: a first acquisition unit, configured to acquire a query request for a target payslip through a query system and identify a customer number in the query request, wherein the query request is a request issued by a target customer through an application, and the customer number is a number used by the target customer to associate account information on the application; a judgment unit, configured to use the identified customer number to determine whether the target customer has activated the payslip query function in the application, and obtain a judgment result; a selection unit, configured to select a target payslip for a target payroll period from a distributed cache system if the judgment result indicates that the target customer has activated the payslip query function, wherein the distributed cache system is used to store payslips for multiple payroll periods for all accounts of multiple customers, and the target payroll period is a preset payroll period with the shortest interval from the current time; and a feedback unit, configured to feed the target payslip back to the application.
[0014] According to another aspect of the present invention, a computer storage medium is also provided for storing a program, wherein the program, when running, controls the device where the non-volatile storage medium is located to execute a payroll query method.
[0015] According to another aspect of the present invention, an electronic device is also provided, comprising a processor and a memory; the memory stores computer-readable instructions, and the processor is configured to execute the computer-readable instructions, wherein the computer-readable instructions, when executed, perform a payroll query method.
[0016] This application employs the following steps: A query request for a target payslip is obtained through a query system, and the customer ID in the query request is identified. The query request is issued by the target customer through the application, and the customer ID is the number used by the target customer to associate account information on the application. Using the identified customer ID, it is determined whether the target customer has activated the payslip query function in the application, and a determination result is obtained. If the determination result indicates that the target customer has activated the payslip query function, a target payslip for the target payroll period is selected from a distributed cache system. This distributed cache system stores payslips for multiple payroll periods from all accounts of multiple customers, and the target payroll period is the preset payroll period with the shortest interval to the current time. The target payslip is then fed back to the application. This solves the problem in related technologies where customers find it difficult to efficiently obtain the payslips they need to query. By creating an auxiliary data table in the distributed cache system, using multiple systems to filter target payslips, and synchronizing the target payslips to the data table, the effect of high-concurrency payslip processing is achieved. Attached Figure Description
[0017] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:
[0018] Figure 1 This is a schematic diagram of a payslip query system provided according to an embodiment of this application;
[0019] Figure 2 This is a flowchart of a payslip query method provided according to an embodiment of this application;
[0020] Figure 3 This is a schematic diagram of a payslip template in the payslip query method provided according to an embodiment of this application;
[0021] Figure 4 This is a schematic diagram of target payroll information provided according to an embodiment of this application;
[0022] Figure 5 This is a schematic diagram of the updated auxiliary data table information provided according to the embodiments of this application. Figure 1 ;
[0023] Figure 6 This is a schematic diagram of the updated auxiliary data table information provided according to the embodiments of this application. Figure 2 ;
[0024] Figure 7 This is a schematic diagram of the query function in the judgment application provided according to the embodiments of this application;
[0025] Figure 8 This is a schematic diagram of a payslip query device provided according to an embodiment of this application;
[0026] Figure 9 This is a schematic diagram of an electronic device provided according to an embodiment of this application. Detailed Implementation
[0027] It should be noted that, unless otherwise specified, the embodiments and features described in this application can be combined with each other. This application will now be described in detail with reference to the accompanying drawings and embodiments.
[0028] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort should fall within the scope of protection of the present application.
[0029] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate for the embodiments of this application described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.
[0030] It should be noted that all information (including but not limited to customer device information, customer personal information, etc.) and data (including but not limited to data used for display, data used for analysis, etc.) involved in this disclosure are information and data authorized by the customer or fully authorized by all parties.
[0031] According to an embodiment of this application, a payslip query system is provided. Figure 1 This is a schematic diagram of a payslip query system provided according to an embodiment of this application, such as... Figure 1 As shown, the system includes:
[0032] The distributed caching system 101 is used to store payrolls for multiple payroll periods for all accounts of multiple customers uploaded by the enterprise. After receiving a query request for a target payroll from the query system 103, it filters out the target payroll for the preset payroll period with the shortest interval to the current time and transmits the target payroll to the query system 103.
[0033] It should be noted that the distributed caching system 101 is a distributed caching cluster based on an open platform's distributed technology architecture. It possesses four key characteristics: high performance, elastic scalability, high availability, and ease of use, and it communicates with the query system 103. In the payroll processing operation, the distributed caching system 101 stores payrolls for multiple employees from multiple periods uploaded by the company. Different companies can customize the information included in the payrolls, thus supporting personalized template definitions. The payrolls can include employee personal information, account information, and the components of their salary.
[0034] Specifically, after the target customer sends a request for the latest payslip in application 102, application 102 passes the query request to query system 103, which then sends the request to distributed cache system 101. Distributed cache system 101 selects the target payslip from multiple stored payslips based on the customer information in the request. The target payslip refers to the payslip with the latest payment date.
[0035] Furthermore, after the target payroll is selected, it is transmitted to the query system 103, which then transmits the target payroll further.
[0036] Application 102 is connected to query system 103 and is used to send query requests to query system 103 and display the target payroll after receiving the target payroll returned by query system 103.
[0037] Specifically, Application 102 is a virtual platform that provides access to financial data such as salary and securities, as well as investment management services. Although each customer can open multiple accounts, each customer is assigned a unique customer number on the platform. Based on this customer number, all account information of the customer can be retrieved.
[0038] After receiving a query request, the application forwards it to the query system 103. The query system 103 then forwards the request to the distributed cache system 101. The distributed cache system 101 filters the target payroll and, after being passed through the query system 103, the target payroll is received by the application 102. Upon receiving the target payroll, the application 102 displays it to the customer on its page.
[0039] The query system 103 is communicatively connected to the distributed cache system 101. It is used to receive query requests sent by the application 102, and if it is found that the customer has activated the payroll query function based on the customer number in the query request, it forwards the query request to the distributed cache system 101. It is also used to send the target payroll to the application 102 after receiving the target payroll transmitted by the distributed cache system 101.
[0040] Specifically, the query system 103 is an "intermediate bridge" between the distributed cache system 101 and the application 102. When the query system 103 receives a query request from the application 102, it needs to first check whether the customer has activated the query service based on the customer number in the query request. If the customer has activated the query service, the request is forwarded to the distributed cache system 101. After receiving the target payroll list filtered by the distributed cache system 101, it forwards it to the application 102.
[0041] The payslip query system 103 provided in this embodiment uses a distributed cache system 101 to store payslips for multiple payroll periods from all accounts of multiple customers uploaded by the enterprise. Upon receiving a query request for a target payslip from the query system 103, the system filters out the target payslip for the preset payroll period with the shortest interval to the current time and transmits the target payslip to the query system 103. An application program 102 communicates with the query system 103, sends query requests to the query system 103, and displays the target payslip upon receiving it from the query system 103. The query system 103 is connected to the distributed cache system. The storage system 101 is connected to a communication system to receive query requests from the application 102. If the system identifies that a customer has activated the payroll query function based on the customer number in the query request, it forwards the query request to the distributed cache system 101. The system is also used to send the target payroll to the application 102 after receiving the target payroll from the distributed cache system 101. This solves the problem in related technologies where customers have difficulty efficiently obtaining the payroll they need to query. By creating an auxiliary data table in the distributed cache system, using multiple systems to filter the target payroll, and synchronizing the target payroll to the data table, the system achieves the effect of high-concurrency processing of payroll.
[0042] According to an embodiment of this application, a method for querying pay slips is provided.
[0043] Figure 2 This is a flowchart of a payslip query method provided according to an embodiment of this application, such as... Figure 2 As shown, the method includes the following steps:
[0044] Step S202: Obtain the query request for the target payroll through the query system and identify the customer number in the query request. The query request is a request issued by the target customer through the application, and the customer number is a number used by the target customer to associate account information on the application.
[0045] It should be noted that different companies can customize the information contained in the payslip, which means that personalized templates are supported. Figure 3 This is a schematic diagram of a payslip template in the payslip query method provided in the embodiments of this application, as shown below. Figure 3 As shown, a payslip can include an employee's personal information, account information, salary components, account opening date, and other information.
[0046] A target payslip refers to the payslip that a target customer needs to access; it can be the latest monthly or annual salary paid by the company. Figure 4 This is a schematic diagram of the target payroll information provided according to an embodiment of this application, such as... Figure 4 As shown, the target payslip may include the customer's customer ID, account information, salary composition, transaction details, and expenditure information. Each customer has a unique customer ID, which allows them to access all account information and salary payments made to all accounts.
[0047] When a target customer sends a query request for a target payslip on the application, the application forwards the query request to the query system. The query system receives and identifies the customer number in the request, and can then use the customer number to retrieve the payslips for different pay periods stored in the distributed cache system for that target customer.
[0048] Step S204: Using the identified customer ID, determine whether the target customer has activated the payslip query function in the application, and obtain the determination result.
[0049] Before querying the target payslip, it's necessary to determine whether the target customer has activated the function to query the latest payslips in the application. If the target customer has not activated this function, they need to search for it themselves. If they have activated the query service, they can query it through the system. Specifically, determining the query function requires using the customer ID from the identified query request. Based on the customer ID, it's possible to check whether the function is activated, thus obtaining the determination result.
[0050] Step S206: If the judgment result indicates that the target customer has enabled the payslip query function, select the target payslip for the target pay period from the distributed cache system. The distributed cache system is used to store payslips for multiple pay periods for all accounts of multiple customers. The target pay period is the preset pay period with the shortest interval from the current time.
[0051] It should be noted that the target salary payment cycle can be different time periods, such as monthly or quarterly payments, and the current time refers to the time when the target customer initiates the query request.
[0052] Specifically, when a customer activates the query function in the application, the query system sends the obtained query request to the distributed cache system. After receiving the query request, the distributed cache system identifies the customer ID in the query request. Based on the customer ID, the query system filters out the target payroll that the customer needs from multiple stored payrolls. The customer's salary is uploaded to the distributed cache system by the enterprise and stored in the system. Therefore, the target payroll can only be retrieved from multiple payrolls based on a specific query request.
[0053] Step S208: Feed the target payslip to the application.
[0054] Specifically, after the query system receives the target payroll from the distributed caching system, it transmits it to the application used by the target customer, and the application displays the payroll.
[0055] The payslip query method provided in this application embodiment obtains a query request for a target payslip through a query system and identifies the customer number in the query request. The query request is issued by the target customer through an application, and the customer number is the number used by the target customer to associate account information on the application. Using the identified customer number, it determines whether the target customer has enabled the payslip query function in the application and obtains the determination result. If the determination result indicates that the target customer has enabled the payslip query function, a target payslip for a target payroll period is selected from a distributed cache system. This distributed cache system stores payslips for multiple payroll periods from all accounts of multiple customers, and the target payroll period is a preset payroll period with the shortest interval from the current time. The target payslip is then fed back to the application. This solves the problem in related technologies where customers find it difficult to efficiently obtain the payslips they need to query. By creating an auxiliary data table in the distributed cache system, using multiple systems to filter target payslips, and synchronizing the target payslips to the data table, the effect of high-concurrency payslip processing is achieved.
[0056] Filtering target payrolls requires determining the payroll's attribution date. Optionally, in the payroll query method provided in this application embodiment, before selecting the target payroll for the target payroll period from the distributed cache system, the method further includes: comparing the attribution period of the first payroll with the attribution period of the second payroll in the auxiliary data table to obtain a comparison result. The auxiliary data table is stored in the distributed cache system. The first payroll is the payroll with the shortest interval between its payroll period and the current time. The second payroll refers to the payroll with the shortest interval between its attribution period and the current time among multiple payrolls stored in the distributed cache system. If the comparison result indicates that the attribution period of the second payroll is later than or equal to the attribution period of the first payroll, the second payroll is determined as the target payroll. If the comparison result indicates that the attribution period of the second payroll is earlier than the attribution period of the first payroll, the first payroll is synchronized to the auxiliary data table, and the first payroll is determined as the target payroll.
[0057] It should be noted that, in order to enable target customers to quickly find the payslips they need, an auxiliary data table is created in the distributed caching system. This auxiliary data table is used to store the latest payslips with the latest attribution date for the target customers. For example, if a company pays January's salary in February, then February refers to the salary payment cycle, and January refers to the salary attribution date. The first payslip refers to the payslip with the latest attribution date stored in the distributed caching system; the second payslip refers to the payslip with the latest payment cycle uploaded by the company.
[0058] Specifically, Figure 5 This is a schematic diagram of the updated auxiliary data table information provided according to the embodiments of this application. Figure 1 ,like Figure 5 As shown, after querying the auxiliary data table, it is determined whether the table contains the latest payroll. If not, the latest payroll with the latest attribution date needs to be inserted. If the table already contains payroll, the attribution date of the second payroll uploaded by the company to the distributed cache system needs to be compared with the attribution date of the first payroll to obtain the comparison result. If the attribution date of the second payroll is later than the attribution date of the first payroll, the payroll in the auxiliary data table needs to be updated again. For example, the second payroll refers to the February salary paid by the company in March, and the first payroll is the January salary stored in the distributed cache system. When the comparison result indicates that the attribution period of the second payroll is later than or equal to the attribution period of the first payroll, that is, February of the second payroll is later than January of the first payroll, the second payroll, i.e., the February payroll, is taken as the target payroll.
[0059] Furthermore, if the second payslip refers to the January salary paid by the company in March, and the second payslip refers to the February salary stored in the distributed wake-up system, and the comparison results indicate that the attribution period of the second payslip is earlier than that of the first payslip, that is, the January of the second payslip is earlier than the February of the first payslip, then the first payslip is taken as the target payslip and stored in the auxiliary data table.
[0060] After the company distributes wages, the application sends a notification. Optionally, in the wage slip query method provided in this application embodiment, before comparing the attribution period of the first wage slip with the attribution period of the second wage slip in the auxiliary data table, the method further includes: obtaining the first wage slips of multiple customers uploaded by the company to the distributed cache system through the query system, and identifying the account information in each first wage slip; determining the customer number of each customer based on the account information, and sending wage distribution notifications to multiple customers based on the customer number.
[0061] Specifically, the first payslip is the payslip with the shortest interval between the payroll period and the current time; that is, it refers to the payslip with the most recent payroll period issued by the company. For example, if a company paid January's salary in January and February, and a target customer requests a payslip on February 14th, then the salary paid in February will be considered the first payslip. Before selecting the target payslip, the query system needs to be used to search the information in the payslips uploaded by the company to the distributed cache system to obtain the bank card account information of the customer in that payslip. Based on the account information, the customer ID of the associated customer can be determined.
[0062] Furthermore, the query system retrieves the target customer's contact information stored in the application based on the customer ID, and sends salary payment notifications to each customer according to the payment method, reminding them to check in a timely manner.
[0063] After selecting a payslip from the distributed cache system, it is stored in an auxiliary data table. Optionally, in the payslip query method provided in this application embodiment, before comparing the attribution period of the first payslip with the attribution period of the second payslip in the auxiliary data table, the method further includes: obtaining the second payslip from the payslips of multiple pay period in the distributed cache system, and synchronizing the second payslip to the auxiliary data table.
[0064] Specifically, the second payslip refers to the payslip among multiple payslips stored in the distributed cache system that has the shortest interval between the pay period and the current time. In other words, it is the latest payslip stored in the distributed cache system. For example, if the distributed cache system stores payslips for July, September, and December of the previous year and February of this year, the second payslip refers to the payslip for February of this year.
[0065] Furthermore, after obtaining the ownership period of all stored payrolls, the payrolls closest to the target customer's query request are selected and synchronously written to the auxiliary data table loaded in the distributed cache system.
[0066] After a target customer deletes a payslip, the remaining payslips in the distributed cache system need to be filtered. Optionally, in the payslip query method provided in this application embodiment, before obtaining the second payslip from multiple payroll periods in the distributed cache system and synchronizing the second payslip to the auxiliary data table, the method further includes: upon receiving a payslip deletion instruction from the target customer through the application, obtaining the attribution period of the payslips from multiple payroll periods in the distributed cache system; obtaining the payslip from the distributed cache system whose attribution period is shortest than the current time, and synchronizing the obtained payslip to the auxiliary data table.
[0067] Before selecting the latest payroll, it is necessary to determine whether any payrolls stored in the distributed cache system have been deleted by the target customer. If there are cases where the payroll payment cycles are not continuous, it is necessary to select from the remaining payrolls. Figure 6 This is a schematic diagram of the updated auxiliary data table information provided according to the embodiments of this application. Figure 2 ,like Figure 6 As shown, specifically, when the query system receives a deletion instruction from the application for a payroll for a certain payment period, it retrieves the payment period attribution date of the remaining payrolls from the distributed cache system that communicates with the query system. Here, the attribution date refers to the payroll to which the payroll belongs at a specific time. For example, if a company pays the payroll for January in February, the payroll payment period for the payroll is February, and the attribution date of the payroll is January.
[0068] Furthermore, the attribution dates of all pay stubs are filtered to select the pay stub with the shortest time interval since the target customer made the query request. For example, if the target customer made a query request for the latest pay stub on February 14th, but the customer deleted the January pay stub from the distributed cache system for some special reason, the attribution dates of pay stubs in the distributed cache system include the pay stubs of the previous year for 12 months. The pay stub with the closest time interval to February 14th is selected, that is, the pay stub of the previous year for December is retrieved. This pay stub is then synchronously copied to the auxiliary data table in the distributed cache system, and the target customer can directly query the target pay stub from the auxiliary data table.
[0069] Before querying a target payslip, it is necessary to determine whether the query function is enabled. Optionally, in the payslip query method provided in this application embodiment, determining whether the target customer has enabled the payslip query function in the application using the identified customer number includes: obtaining a query grayscale switch in the application and determining the status of the query grayscale switch, wherein the query grayscale switch is loaded in the application, and the status of the query grayscale switch is used to indicate whether the query function is online in the customer's region; if the status of the query grayscale switch indicates that the query function is online in the target customer's region, determining whether the period for which the enterprise uploads payslips is within a target time interval, wherein the target time interval is a sub-interval of the time interval for which the query function is enabled; if the period for which the enterprise uploads payslips is within the target time interval, determining that the target customer has enabled the payslip query function in the application.
[0070] It should be noted that the query grayscale switch is used to determine the online and enabled status of the application's query function. Therefore, to determine the query function, it is necessary to first check the status of the query grayscale switch. The attribution date refers to the date to which the payroll uploaded by the enterprise to the distributed cache system belongs. For example, the attribution date of January's salary is January.
[0071] Specifically, Figure 7 This is a schematic diagram of the query function in the judgment application provided in the embodiments of this application, such as... Figure 7 As shown, firstly, the query grayscale switch is obtained, and it is determined whether the pilot master switch in the grayscale switch is in the on state. If the pilot master switch is off, it means that the query function is not online in this region; if the switch is on, it means that the query grayscale switch is on, that is, the query function is online in the region where the target customer is located. It is necessary to obtain the corresponding configuration parameters according to the customer number, and at the same time store the target customer's information in the distributed cache system.
[0072] Furthermore, it's determined whether the payslip uploaded by the company falls within the period between the activation and deactivation of the query function. Specifically, it's determined whether the upload time of the payslip falls between the activation and deactivation of the query function. If the payslip upload time, i.e., the payroll period, falls within the activation and deactivation time of the query function, relevant parameters in the application are modified; for example, the `existflag` parameter is set to 1. Conversely, if the payroll period does not fall within the activation and deactivation time of the query function, the `existflag` parameter is set to 0. After modifying the corresponding parameters, it can be confirmed that the target customer has activated the query function, meaning that the target payslip can be queried from the distributed cache system.
[0073] It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases the steps shown or described may be executed in a different order than that shown here.
[0074] This application also provides a payslip query device. It should be noted that the payslip query device of this application can be used to execute the payslip query method provided in this application. The payslip query device provided in this application is described below.
[0075] Figure 8 This is a schematic diagram of a payslip query device provided according to an embodiment of this application, such as... Figure 8 As shown, the device includes: a first acquisition unit 80, a judgment unit 81, a selection unit 82, and a feedback unit 83.
[0076] The first acquisition unit 80 is used to acquire a query request for the target payroll through the query system and identify the customer number in the query request. The query request is a request issued by the target customer through the application, and the customer number is a number used by the target customer to associate account information on the application.
[0077] The judgment unit 81 is used to determine whether the target customer has activated the payslip query function in the application using the identified customer number, and to obtain the judgment result.
[0078] The selection unit 82 is used to select a target payroll for a target payroll period from the distributed cache system when the judgment result indicates that the target customer has enabled the payroll query function. The distributed cache system is used to store payrolls for multiple payroll periods for all accounts of multiple customers. The target payroll period is the preset payroll period with the shortest interval from the current time.
[0079] Feedback unit 83 is used to feed the target payroll back to the application.
[0080] Optionally, in the payslip query device provided in this application embodiment, the device further includes: a comparison unit, configured to compare the attribution period of the first payslip with the attribution period of the second payslip in the auxiliary data table before selecting the target payslip for the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip with the target payslip; a determination unit, configured to determine the second payslip as the target payslip if the comparison result indicates that the attribution period of the second payslip is later than or equal to the attribution period of the first payslip; and a first synchronization unit, configured to synchronize the first payslip to the auxiliary data table and determine the first payslip as the target payslip if the comparison result indicates that the attribution period of the second payslip is earlier than the attribution period of the first payslip.
[0081] Optionally, in the payroll query device provided in this application embodiment, the device further includes: a second acquisition unit, used to acquire first payrolls of multiple customers uploaded by the enterprise to the distributed cache system through the query system before comparing the attribution period of the first payroll with the attribution period of the second payroll in the auxiliary data table, and to identify the account information in each first payroll; and a sending unit, used to determine the customer number of each customer according to the account information, and to send a payroll payment notification to multiple customers according to the customer number.
[0082] Optionally, in the payroll query device provided in the embodiments of this application, the device further includes: a third acquisition unit, used to acquire the second payroll from payrolls of multiple payroll periods in the distributed cache system and synchronize the second payroll to the auxiliary data table before comparing the attribution period of the first payroll with the attribution period of the second payroll in the auxiliary data table.
[0083] Optionally, in the payslip query device provided in this application embodiment, the device further includes: a fourth acquisition unit, configured to acquire a second payslip from multiple payslips of payslips in a distributed cache system, and before synchronizing the second payslip to an auxiliary data table, upon receiving a payslip deletion instruction from a target customer through an application, acquire the attribution period of the payslips from multiple payslips in the distributed cache system; acquire the payslip from the distributed cache system whose attribution period is shortest than the current time, and synchronize the acquired payslip to the auxiliary data table.
[0084] Optionally, in the payroll query device provided in this application embodiment, the judgment unit 81 includes: an acquisition module, used to acquire a query grayscale switch in the application and judge the state of the query grayscale switch, wherein the query grayscale switch is loaded in the application, and the state of the query grayscale switch is used to indicate whether the query function is online in the customer's area; a judgment module, used to judge whether the period for which the enterprise uploads payrolls is within a target time interval when the state of the query grayscale switch indicates that the query function is online in the target customer's area, wherein the target time interval is a sub-interval of the time interval for which the query function is enabled; and a determination module, used to determine that the target customer has enabled the payroll query function in the application when the period for which the enterprise uploads payrolls is within the target time interval.
[0085] The payslip query device provided in this application embodiment includes a first acquisition unit 80, which acquires a query request for a target payslip through a query system and identifies the customer number in the query request. The query request is issued by the target customer through an application, and the customer number is the number used by the target customer to associate account information on the application. A judgment unit 81 uses the identified customer number to determine whether the target customer has enabled the payslip query function in the application and obtains a judgment result. A selection unit 82, if the judgment result indicates that the target customer has enabled the payslip query function, selects a target payslip for a target pay period from a distributed cache system. The distributed cache system stores payslips for multiple pay periods from all accounts of multiple customers, and the target pay period is a preset pay period with the shortest interval to the current time. A feedback unit 83 feeds back the target payslip to the application. This solves the problem in related technologies where customers find it difficult to efficiently obtain the payslips they need to query. By creating an auxiliary data table in the distributed cache system, filtering target payslips using multiple systems, and synchronizing the target payslips to the data table, the device achieves high-concurrency processing of payslips.
[0086] The aforementioned payslip query device includes a processor and a memory. The first acquisition unit 80, judgment unit 81, selection unit 82, feedback unit 83, etc., are all stored in the memory as program units. The processor executes the aforementioned program units stored in the memory to realize the corresponding functions.
[0087] The processor contains a kernel, which retrieves the corresponding program unit from memory. One or more kernels can be configured; adjusting kernel parameters can address the problem of customers efficiently retrieving payroll records in related technologies.
[0088] The memory may include non-permanent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM, and the memory includes at least one memory chip.
[0089] This application also provides a computer storage medium for storing a program, wherein the program, when running, controls the device where the non-volatile storage medium is located to execute a payroll query method.
[0090] This application also provides an electronic device. Figure 9 This is a schematic diagram of an electronic device provided according to an embodiment of this application, such as... Figure 9 As shown, the electronic device 90 includes a processor and a memory; the memory stores computer-readable instructions, and the processor executes these computer-readable instructions, which, when executed, perform a payroll query method. The electronic device in this document can be a server, PC, PAD, mobile phone, etc.
[0091] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0092] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0093] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0094] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0095] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0096] Memory may include non-persistent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.
[0097] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic magnetic disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.
[0098] It should also be noted that the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article, or apparatus. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element.
[0099] The above are merely embodiments of this application and are not intended to limit the scope of this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the scope of the claims of this application.
Claims
1. A method for querying pay slips, characterized in that, include: The system obtains a query request for the target payslip and identifies the customer number in the query request. The query request is a request issued by the target customer through the application, and the customer number is a number used by the target customer to associate account information on the application. Using the identified customer ID, determine whether the target customer has activated the payslip query function in the application, and obtain the determination result; If the judgment result indicates that the target customer has enabled the payslip query function, the target payslip for the target pay period is selected from the distributed cache system. The distributed cache system is used to store payslips for multiple pay periods for all accounts of multiple customers. The target pay period is the preset pay period with the shortest interval from the current time. The target payslip is then fed back to the application. The method further includes, before selecting the target payroll for the target payroll period from the distributed cache system: The attribution period of the first payroll slip is compared with the attribution period of the second payroll slip in the auxiliary data table to obtain the comparison result. The auxiliary data table is stored in the distributed cache system. The first payroll slip is the payroll slip with the shortest interval between the payroll payment period and the current time. The second payroll slip refers to the payroll slip with the shortest interval between the payroll attribution period and the current time among the multiple payroll slips stored in the distributed cache system. If the comparison result indicates that the attribution period of the second payslip is later than or equal to the attribution period of the first payslip, the second payslip is determined as the target payslip. If the comparison result indicates that the attribution period of the second payslip is earlier than that of the first payslip, the first payslip is synchronized to the auxiliary data table, and the first payslip is identified as the target payslip.
2. The method according to claim 1, characterized in that, Before comparing the attribution period of the first payslip with the attribution period of the second payslip in the auxiliary data table, the method further includes: The query system retrieves the first payrolls of multiple customers uploaded by the enterprise to the distributed caching system, and identifies the account information in each first payroll. Based on the account information, a customer number is determined for each customer, and salary payment notifications are sent to multiple customers based on the customer number.
3. The method according to claim 1, characterized in that, Before comparing the attribution period of the first payslip with the attribution period of the second payslip in the auxiliary data table, the method further includes: Obtain the second payslip from the payslips of the multiple payroll periods in the distributed cache system, and synchronize the second payslip to the auxiliary data table.
4. The method according to claim 2, characterized in that, Before retrieving the second payslip from the payslips of the multiple payroll periods in the distributed caching system and synchronizing the second payslip to the auxiliary data table, the method further includes: Upon receiving a payslip deletion instruction from the target customer through the application, the system retrieves the payslip belonging to the multiple payroll periods in the distributed caching system. The system retrieves the payroll with the shortest payroll period from among multiple payrolls in the distributed cache system, and synchronizes the retrieved payroll to the auxiliary data table.
5. The method according to claim 1, characterized in that, Determining whether the target customer has activated the payslip query function in the application using the identified customer ID includes: Obtain the query grayscale switch in the application and determine the status of the query grayscale switch, wherein the query grayscale switch is loaded in the application, and the status of the query grayscale switch is used to indicate whether the query function is online in the customer's area; When the state of the query grayscale switch indicates that the query function is online in the target customer's area, it is determined whether the period of the enterprise's uploaded payslip is within the target time interval, wherein the target time interval is a sub-interval of the time interval during which the query function is enabled; If the period for which the enterprise uploads payslips falls within the target time interval, then the target customer is determined to have activated the payslip query function in the application.
6. A payslip query system, characterized in that, include: A distributed caching system is used to store payrolls for multiple payroll periods for all accounts of multiple customers uploaded by an enterprise. After receiving a query request for a target payroll from the query system, the system filters out the target payroll for the preset payroll period with the shortest interval to the current time and transmits the target payroll to the query system. The application communicates with the query system, sends the query request to the query system, and displays the target payslip after receiving the target payslip returned by the query system. The query system is communicatively connected to the distributed caching system and is used to receive the query request sent by the application. If the query system identifies that a customer has activated the payslip query function based on the customer number in the query request, it forwards the query request to the distributed caching system. The system is also used to send the target payslip to the application after receiving the target payslip transmitted by the distributed caching system. The target payslip is obtained through the following steps: the attribution period of the first payslip is compared with the attribution period of the second payslip in the auxiliary data table to obtain the comparison result. The auxiliary data table is stored in the distributed cache system. The first payslip is the payslip with the shortest interval between the pay period and the current time. The second payslip is the payslip with the shortest interval between the pay period and the current time among the multiple payslips stored in the distributed cache system. If the comparison result indicates that the attribution period of the second payslip is later than or equal to the attribution period of the first payslip, the second payslip is determined as the target payslip. If the comparison result indicates that the attribution period of the second payslip is earlier than that of the first payslip, the first payslip is synchronized to the auxiliary data table, and the first payslip is identified as the target payslip.
7. A payslip query device, characterized in that, include: The first acquisition unit is used to acquire a query request for a target payslip through a query system and identify the customer number in the query request, wherein the query request is a request issued by the target customer through an application, and the customer number is a number used by the target customer to associate account information on the application. The judgment unit is used to determine, using the identified customer number, whether the target customer has activated the payslip query function in the application, and to obtain the judgment result; The selection unit is used to select the target payslip for the target payroll period from the distributed cache system when the judgment result indicates that the target customer has enabled the payslip query function. The distributed cache system is used to store payslips for multiple payroll periods for all accounts of multiple customers. The target payroll period is the preset payroll period with the shortest interval from the current time. A feedback unit is used to send the target payslip back to the application. The apparatus further includes: a comparison unit, configured to compare the attribution period of a first payroll order with the attribution period of a second payroll order in an auxiliary data table before selecting a target payroll order for a target payroll order with a target payroll order for a target payroll order with a target payroll order period from a distributed cache system, and obtain a comparison result, wherein the auxiliary data table is stored in the distributed cache system, the first payroll order is the payroll order with the shortest interval between the payroll order period and the current time, and the second payroll order is the payroll order with the shortest interval between the payroll order period and the current time among multiple payroll orders stored in the distributed cache system; a determination unit, configured to determine the second payroll order as the target payroll order if the comparison result indicates that the attribution period of the second payroll order is later than or equal to the attribution period of the first payroll order; and a first synchronization unit, configured to synchronize the first payroll order to the auxiliary data table and determine the first payroll order as the target payroll order if the comparison result indicates that the attribution period of the second payroll order is earlier than the attribution period of the first payroll order.
8. A computer storage medium, characterized in that, The computer storage medium is used to store a program, wherein the program, when running, controls the device where the computer storage medium is located to execute the payroll query method according to any one of claims 1 to 5.
9. An electronic device comprising a memory and a processor, characterized in that, The memory stores a computer program, and the processor is configured to execute the payroll query method according to any one of claims 1 to 5 through the computer program.