CN114757639A

CN114757639A - Data processing method, device, equipment and storage medium

Info

Publication number: CN114757639A
Application number: CN202210311851.2A
Authority: CN
Inventors: 杨军杰
Original assignee: Bank of China Ltd
Current assignee: Bank of China Ltd
Priority date: 2022-03-28
Filing date: 2022-03-28
Publication date: 2022-07-15

Abstract

The application discloses a data processing method, a data processing device, equipment and a storage medium, relates to the technical field of big data processing, and aims to solve the problem that in the prior art, the efficiency of attendance data and overtime data statistics is low. The specific scheme is as follows: acquiring at least one piece of attendance information in a preset time period from a card printing database and a leave database, wherein the attendance information comprises at least one of the following items: employee identity identification, card punching date, work card punching time and leave time; according to the attendance rules corresponding to the employee identity, storing daily attendance data in at least one piece of attendance information to a daily database, and storing overtime attendance data in at least one piece of attendance information to an overtime database; and acquiring data to be counted corresponding to the statistical target from the daily database and the overtime database, and acquiring attendance statistical data according to the data to be counted. The method and the device are used for counting attendance data.

Description

Data processing method, device, equipment and storage medium

Technical Field

The present application relates to the field of big data technologies, and in particular, to a data processing method, apparatus, device, and storage medium.

Background

Generally, the work time is determined by the card punching of the staff, and the fixed work time, the flexible work time and the leave information need to be considered in the attendance statistics process through the attendance management system. Considering the actual application scenario, there may be a case where the card punching is forgotten. In contrast, attendance checking and attendance checking can be performed, in the attendance checking and attendance checking process, whether attendance is abnormal or not, whether attendance is required or not, whether overtime conditions exist or not and the like are checked through inquiring the card punching record and the leave-on application record, the process is complicated and needs to be checked repeatedly, phenomena of missing filling, mistaken filling and mistaken filling can be caused, and further, when a checker performs rechecking in the later period, work such as rework, rechecking, recalculation and the like can be added, so that the attendance checking and counting efficiency is low. Based on this, it may result in low equivalence rate of counting normal attendance data and overtime data.

Disclosure of Invention

The application provides a data processing method, a data processing device, data processing equipment and a storage medium, and aims to solve the problem that the equivalence ratio of statistical normal attendance data and overtime data is low in the prior art.

In order to achieve the purpose, the technical scheme is as follows:

in a first aspect, the present application provides a data processing method, including: at least one piece of attendance information in a preset time period is acquired from a card punching database and a leave asking database, and each piece of attendance information comprises at least one of the following items: employee identification, card punching date, attendance card punching time, off duty card punching time and leave time; according to the attendance rules corresponding to the employee identity, daily attendance data in at least one piece of attendance information is stored in a daily database, overtime attendance data in at least one piece of attendance information is stored in an overtime database, and the daily attendance data comprises normal attendance data and abnormal attendance data; acquiring data to be counted corresponding to a counting target from a daily database and an overtime database, and acquiring attendance statistical data according to the data to be counted, wherein the data to be counted is at least one of the following data: normal attendance data, abnormal attendance data and overtime data.

Therefore, in the data processing method provided by the application, since the daily work time and the overtime time recorded in the card punching database and the leave requesting database are mutually mixed, and the data processing efficiency may be greatly reduced due to data in the query or statistics process, the daily attendance data and the overtime data are respectively stored in the daily database and the overtime database by performing database division processing on the attendance information recorded in the card punching database and the leave requesting database, so that the required data (such as the daily attendance data or the overtime data) can be directly acquired from different databases, and the processing efficiency of daily attendance condition and overtime working duration statistics can be improved.

Optionally, according to an attendance rule corresponding to the employee identity, storing the daily attendance data in the at least one piece of attendance information into the daily database, and storing the overtime attendance data in the at least one piece of attendance information into the overtime database, where the method includes: under the condition that an attendance rule corresponding to the employee identity is an elastic system, determining the working time length of the day according to the working card punching time and the working card punching time, wherein the working time length of the day is the difference value of the working card punching time and the working card punching time; under the condition that the working duration of the current day is less than the preset working duration, searching the leave-on duration corresponding to the card punching date in the attendance checking information; under the condition that the leave-on duration is greater than or equal to the first absent-duty duration, storing attendance information into a daily database, and setting an absent-duty state identifier, wherein the first absent-duty duration is the difference between the preset working duration and the working duration of the day; under the condition that the leave-on duration is less than the first absent-attendance duration, storing attendance information and the first absent-attendance duration into a daily database, and setting a state identifier to be confirmed; under the condition that the working duration of the current day is equal to the preset working duration, storing the attendance information into a date database, and setting a normal state identifier; and under the condition that the working time length of the day is greater than the preset working time length, storing the attendance information and a first overtime length into an overtime database, wherein the first overtime length is the difference value between the working time length of the day and the preset working time length.

According to the method, due to the fact that the corresponding post characteristics of office workers are different, whether the attendance information is stored in a daily database or an overtime database is judged according to the actual working time of the day for the attendance rules of the flexible system, and the normal state identification, the absent state identification or the to-be-confirmed state identification are set according to the working time of the day and the leave-on time, so that the attendance information can be accurately processed in different databases.

Optionally, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a status identifier to be confirmed and an absent attendance status identifier; before acquiring attendance statistical data according to the data to be counted and the data to be counted corresponding to the statistical target from the daily database and the overtime database, the method further comprises the following steps: acquiring employee identity identifications corresponding to the state identifications to be confirmed in a daily database; acquiring a first absent time corresponding to an employee identity corresponding to a state identifier to be confirmed in a daily database; acquiring a first overtime length corresponding to an employee identity corresponding to a state identifier to be confirmed in an overtime database; under the condition that the first attendance duration is less than or equal to the first overtime duration, changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier, and determining the difference value between the first overtime duration and the first attendance duration as the updated first overtime duration; and generating attendance abnormity prompt information under the condition that the first attendance absence time length is greater than the first overtime length, wherein the attendance abnormity prompt information is used for prompting that the employee identity identification corresponding to the state identification to be confirmed needs attendance check-in.

According to the method, the situation that the card punching is forgotten when the employee punches the card is considered, the mode of generating the abnormal attendance prompting information is adopted, and the phenomena that the employee is left without filling, mistakenly filled or mistakenly filled when filling the working duration and the like have high rework rate can be avoided when the employee logs in the attendance.

Optionally, according to an attendance rule corresponding to the employee identity, storing the daily attendance data in the at least one piece of attendance information into the daily database, and storing the overtime attendance data in the at least one piece of attendance information into the overtime database, where the method includes: under the condition that the off-duty time of the card punching is after the preset off-duty time, storing attendance information and second off-duty time length into an off-duty database, wherein the second off-duty time length is the difference value of the off-duty time of the card punching and the preset time of the card punching; under the condition that attendance information meets preset attendance conditions, acquiring second attendance duration according to the attendance time and the attendance time, wherein the preset attendance conditions comprise at least one of the following: after the working time, the off-duty time and the working time are preset, the second absent time period is the sum of a first difference value and a second difference value, the first difference value is the difference value between the working time and the preset on-duty time, and the second difference value is the difference value between the preset off-duty time and the off-duty time; under the condition that the second absent duration is less than or equal to the leave-on duration, storing attendance information into a date database, and identifying the absent status by setting an absent status; under the condition that the second absent time duration is longer than the leave-on time duration, storing attendance information and the second absent time duration into a daily database, and setting a state identifier to be confirmed; and under the condition that the attendance information does not meet the preset absence condition, storing the attendance information into a date database, and setting a normal state identifier.

According to the method, due to the fact that the positions corresponding to office workers have different characteristics, whether the attendance information is stored in a daily database or an overtime database is judged according to the actual working time of the day for the fixed attendance rules, and the normal state identification, the absent state identification or the to-be-confirmed state identification are set according to the working time of the day and the leave-on time, so that the attendance information can be accurately processed in different databases.

Optionally, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a status identifier to be confirmed and an absent attendance status identifier; before acquiring data to be counted corresponding to a statistical target from a daily database and an overtime database and acquiring attendance statistical data according to the data to be counted, the method further comprises the following steps: acquiring employee identity identifications corresponding to the state identifications to be confirmed in a daily database; acquiring a second absent time corresponding to the employee identity corresponding to the status identifier to be confirmed in a daily database; acquiring a second overtime time corresponding to the employee identity corresponding to the status identifier to be confirmed in an overtime database; under the condition that the second off-duty time length is less than or equal to the second off-duty time length, changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier, and determining the difference value between the first off-duty time length and the first off-duty time length as the updated second off-duty time length; and generating attendance exception prompt information under the condition that the second absent time length is greater than the second overtime length, wherein the attendance exception prompt information is used for prompting that the employee identity identification corresponding to the status identification to be confirmed needs to perform attendance checking and attendance checking.

According to the method, the situation that the card punching is forgotten possibly exists when the employee punches the card is considered, the mode of generating the abnormal attendance prompt information is adopted, and the phenomena that the employee stores the work duration and has high rework rate such as missing filling, wrong filling or wrong filling and the like when the employee logs in the attendance can be avoided.

In a second aspect, the present application provides a data processing apparatus comprising: the device comprises an acquisition unit, a storage unit and a processing unit; the system comprises an acquisition unit, a card reading unit and a leave-asking database, wherein the acquisition unit is used for acquiring at least one piece of attendance information in a preset time period from the card reading database and the leave-asking database, and each piece of attendance information comprises at least one of the following items: employee identification, card punching date, attendance card punching time, off duty card punching time and leave time; the storage unit is used for storing the daily attendance data in at least one piece of attendance information into the daily database and storing the overtime attendance data in at least one piece of attendance information into the overtime database according to the attendance rules corresponding to the employee identity, and the daily attendance data comprises normal attendance data and abnormal attendance data; the processing unit is used for acquiring data to be counted corresponding to a counting target from the daily database and the overtime database, and acquiring attendance statistical data according to the data to be counted, wherein the data to be counted is at least one of the following data: normal attendance data, abnormal attendance data and overtime data.

Optionally, the storage unit is specifically configured to: under the condition that an attendance rule corresponding to the employee identity is an elastic system, determining the working time length of the day according to the working card punching time and the working card punching time, wherein the working time length of the day is the difference value of the working card punching time and the working card punching time; under the condition that the working duration of the current day is less than the preset working duration, searching the leave-on duration corresponding to the card punching date in the attendance checking information; under the condition that the leave-on duration is greater than or equal to the first absent-duty duration, storing attendance information into a daily database, and setting an absent-duty state identifier, wherein the first absent-duty duration is a difference value between the preset working duration and the working duration of the day; under the condition that the leave-on duration is less than the first absent-duty duration, storing attendance information and the first absent-duty duration into a daily database, and setting a state identifier to be confirmed; under the condition that the working duration of the current day is equal to the preset working duration, the attendance information is stored in a daily database, and a normal state identifier is set; and under the condition that the working time length of the day is greater than the preset working time length, storing the attendance information and a first overtime length into an overtime database, wherein the first overtime length is the difference value between the working time length of the day and the preset working time length.

Optionally, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a to-be-confirmed status identifier and an absent status identifier; the above-mentioned device still includes: the acquisition unit is also used for acquiring the employee identity identifier corresponding to the state identifier to be confirmed in the daily database; the acquiring unit is also used for acquiring a first absent time corresponding to the employee identity corresponding to the state identifier to be confirmed in the daily database; the acquiring unit is also used for acquiring a first overtime length corresponding to the employee identity corresponding to the state identifier to be confirmed in the overtime database; the processing unit is further used for changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier under the condition that the first attendance duration is less than or equal to the first overtime duration, and determining the difference value between the first overtime duration and the first attendance duration as the updated first overtime duration; and the processing unit is further used for generating attendance abnormity prompt information under the condition that the first attendance absence time length is greater than the first overtime length, wherein the attendance abnormity prompt information is used for prompting that the employee identity identifier corresponding to the state identifier to be confirmed needs attendance check-in.

Optionally, the storage unit is specifically further configured to: under the condition that the off-duty time is after the preset off-duty time, the attendance information and a second off-duty time length are stored in an off-duty database, wherein the second off-duty time length is the difference value between the off-duty time length and the preset time length; under the condition that the attendance information meets the preset attendance-absence condition, acquiring second attendance-absence duration according to the attendance-absence time and the attendance-absence time, wherein the preset attendance-absence condition comprises at least one of the following items: after the on-duty card punching time is preset on-duty time, before the off-duty card punching time is preset on-duty time and after the off-duty card punching time, the second off-duty time is the sum of a first difference value and a second difference value, the first difference value is the difference value between the on-duty card punching time and the preset on-duty time, and the second difference value is the difference value between the preset off-duty time and the off-duty card punching time; under the condition that the second absent duration is less than or equal to the leave-on duration, storing attendance information into a date database, and identifying the absent status by setting an absent status; under the condition that the second absent time duration is longer than the leave-on time duration, storing attendance information and the second absent time duration into a daily database, and setting a state identifier to be confirmed; and under the condition that the attendance information does not meet the preset absence condition, storing the attendance information into a date database, and setting a normal state identifier.

Optionally, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a to-be-confirmed status identifier and an absent status identifier; the above-mentioned device still includes: the acquiring unit is further used for acquiring data to be counted corresponding to the counting target from the daily database and the overtime database, and before acquiring attendance statistical data according to the data to be counted, the device further comprises: the acquisition unit is also used for acquiring the employee identity identifier corresponding to the state identifier to be confirmed in the daily database; the acquiring unit is further used for acquiring a second absent time corresponding to the employee identity corresponding to the state identifier to be confirmed in the daily database; the acquiring unit is further used for acquiring a second overtime duration corresponding to the employee identity corresponding to the state identifier to be confirmed in the overtime database; the processing unit is further used for changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier under the condition that the second off-duty time length is less than or equal to the second off-duty time length, and determining the difference value between the first off-duty time length and the first off-duty time length as the updated second off-duty time length; and the processing unit is further used for generating attendance abnormity prompting information under the condition that the second attendance absence time length is greater than the second overtime length, wherein the attendance abnormity prompting information is used for prompting that the employee identity identifier corresponding to the state identifier to be confirmed needs attendance check-in.

In a third aspect, a computer device is provided, comprising: a processor; a memory for storing the processor-executable instructions; wherein the processor is configured to execute instructions to implement the method as provided in the first aspect above.

In a fourth aspect, the present application provides a computer-readable storage medium comprising instructions. The instructions, when executed on a computer, cause the computer to perform the method as provided in the first aspect above.

In a fifth aspect, the present application provides a computer program product for causing a computer to perform the method as provided in the first aspect above when the computer program product is run on the computer.

It should be noted that all or part of the above computer instructions may be stored on the first computer readable storage medium. The first computer readable storage medium may be packaged with the processor of the access network terminal device, or may be packaged separately from the processor of the access network terminal device, which is not limited in this application.

For the descriptions of the second, third, fourth and fifth aspects in this application, reference may be made to the detailed description of the first aspect; in addition, for the beneficial effects described in the second aspect, the third aspect, the fourth aspect and the fifth aspect, reference may be made to the beneficial effect analysis of the first aspect, and details are not repeated here.

In the present application, the above names do not limit the terminal devices or the function modules themselves, and in actual implementation, the terminal devices or the function modules may appear by other names. As long as the functions of the respective terminal devices or functional modules are similar to those of the present application, they fall within the scope of the claims of the present application and their equivalents.

These and other aspects of the present application will be more readily apparent from the following description.

Drawings

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

FIG. 1 is a diagram illustrating a data structure of a database according to an embodiment of the present application;

FIG. 2 is a flow chart of a data processing method according to an embodiment of the present application;

FIG. 3 is a second flowchart illustrating a data processing method according to an embodiment of the present application;

FIG. 4 is a third flowchart illustrating a data processing method according to an embodiment of the present application;

FIG. 5 is a fourth flowchart illustrating a data processing method according to an embodiment of the present application;

FIG. 6 is a fifth flowchart illustrating a data processing method according to an embodiment of the present application;

fig. 7 is a schematic diagram of a data structure of attendance checking in accordance with an embodiment of the present application;

FIG. 8 is a flow diagram illustrating data flow according to an embodiment of the present application;

FIG. 9 is a schematic diagram of a data processing apparatus according to an embodiment of the present application;

fig. 10 is a schematic structural diagram of a computer device according to an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

It should be noted that in the embodiments of the present application, words such as "exemplary" or "for example" are used to indicate examples, illustrations or explanations. Any embodiment or design described herein as "exemplary" or "such as" is not necessarily to be construed as preferred or advantageous over other embodiments or designs. Rather, use of the word "exemplary" or "such as" is intended to present relevant concepts in a concrete fashion.

For the convenience of clearly describing the technical solutions of the embodiments of the present application, in the embodiments of the present application, the terms "first" and "second" are used to distinguish the same items or similar items with basically the same functions and actions, and those skilled in the art can understand that the terms "first" and "second" are not limited in number or execution order.

The embodiment of the application provides a data processing method based on the problem that the equivalence ratio of statistical normal attendance data and overtime data is low. As shown in fig. 1, the method includes: the method comprises the steps of dividing information in a card database and an attendance database, namely storing daily attendance data (including normal attendance data and abnormal attendance data) in at least one piece of attendance information into a daily constant database according to an attendance rule corresponding to employee identity identification, storing overtime attendance data in at least one piece of attendance information into an overtime database, acquiring data to be counted corresponding to a counting target from the daily database and the overtime database, and acquiring attendance statistical data according to the data to be counted.

The execution main body of the data processing method provided by the embodiment of the application can be attendance management equipment and is used for managing related data such as attendance. For example, the attendance management device may be an electronic device with data processing capability, such as a computer and a server. The server may be a single server, or may be a server cluster including a plurality of servers. In some embodiments, the server cluster may also be a distributed cluster. The subject of the data processing method is not limited in this application.

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

FIG. 2 is a flow diagram illustrating a data processing method according to an exemplary embodiment. As shown in fig. 2, the method includes steps 201 to 203.

Step 201, the data processing device obtains at least one piece of attendance information in a preset time period from a card punching database and a leave asking database.

The data processing device is used for managing related data such as attendance, and can be the attendance management equipment or integrated on the attendance management equipment. The attendance management device may be an electronic device such as the aforementioned computer or server.

In an embodiment of the present application, each attendance information includes at least one of the following: employee identification, card punching date, attendance card punching time, off duty card punching time and leave time. It can be understood that, in the attendance information, the employee identification and the card punching date are included for the employee who has entered the attendance management system, and corresponding other information is obtained by the employee identification or the random code for the employee identification, where the other information may include the on-duty card punching time, the off-duty card punching time and the leave-on time, and if no other information is recorded, the recording is performed by using a preset invalid identifier or a null value. In the attendance information, when the attendance device is used for punching the card of the employee who is not logged in the attendance management system, the attendance time and/or the off-duty time can be recorded firstly, and the characteristic information of the employee, such as fingerprints, face images and the like, is recorded, so that the attendance time and/or the off-duty time can be imported after the employee is logged in the attendance management system subsequently.

It should be noted that the work time of punching the card is the earliest time within the time range in which the work time of punching the card can be performed, for example, the work time of punching the card is respectively performed at two time points of 8 o ' clock and 8 o ' clock, the work time of punching the card is recorded as 8 o ' clock, and no recording is performed when the work time of punching the card is repeated subsequently. The off duty time is the latest time within the time range of off duty time, if the off duty time is respectively performed at two time points of 5-point integer and 5-point half, the off duty time is recorded as 5-point half, and if the off duty time is repeatedly punched subsequently, the off duty time is updated.

In the embodiment of the application, the attendance information in the card punching database and the leave database is acquired in response to the card punching operation input by the employee. It is to be understood that the card punch device that receives the punch operation input by the employee may be at least one of: the system comprises a mobile phone terminal, a computer terminal, a fingerprint card punching device, a face card punching device and an electronic card identification card punching device.

It should be noted that, if the attendance information can be entered through multiple types of card punching devices, the attendance data of the multiple types of card punching devices needs to be summarized before data processing, and the data summarizing mode is at least one of the following modes: attendance data are gathered manually through a physical line, are transmitted to a specific terminal in a wireless network transmission mode, and are gathered in a cloud mode.

Optionally, in this embodiment of the present application, before responding to the punch-card operation input by the employee, it is further required to confirm that the identity of the employee is consistent with the identity of the employee who inputs the punch-card operation.

Optionally, in this embodiment of the present application, in the case of responding to the punch operation input by the employee, the current punch date also needs to be identified. The date of the punch card is generally the date recorded in the punching device. It can be understood that, in order to ensure the accuracy of the date, the non-networked card punching device may set an administrator mode capable of modifying the time of the card punching device, the networked card punching device may set an administrator mode capable of modifying the time of the card punching device, and the networked card punching device may also set a mode synchronized with the network time through a network time protocol.

In the embodiment of the application, in the actual working process, the attendance information is usually used for counting the attendance and overtime conditions of the staff and providing a basis for calculating the wages of the staff, so that the attendance information is time-efficient, and for the monthly wages, a preset time period can be set to be one month, for example, 3 months 1 day to 3 months 31 days, 4 months 1 day to 4 months 30 days, and the like. For example, the preset time period may be automatically set according to the current time, for example, if the current time is 4 months and 3 days, the preset time period is automatically adjusted to 3 months and 1 day to 3 months and 31 days.

It can be understood that because the attendance information is continuously increased along with the time, the attendance information in the preset time period can be subjected to data processing, and then, in the next preset time period, the attendance information is subjected to data processing according to the scheme, so that all the attendance data are collected.

Step 202, the data processing device stores the daily attendance data in at least one piece of attendance information to a daily database and stores the overtime attendance data in at least one piece of attendance information to an overtime database according to the attendance rules corresponding to the employee identity.

In the embodiment of the application, the daily attendance data comprises normal attendance data and abnormal attendance data. It can be understood that the normal attendance data refers to that the time of punching the card in the attendance information belongs to the working time required according to the attendance rule, and the abnormal attendance data refers to that the time of punching the card in the attendance information does not belong to the working time required according to the attendance rule. The abnormal attendance data can be late arrival, early departure, absence, missed card punching and the like of the staff.

Optionally, in this embodiment of the application, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a status identifier to be confirmed and an absent status identifier. For the status identifier, binary codes may be used for identification, such as a normal status identifier 00, an absent duty status identifier 01, and a to-be-confirmed status identifier 11.

It can be understood that the status identifier to be confirmed may be further refined according to actual requirements, the late status identifier, the early exit status identifier, and the absence status identifier may be further refined, and the identifier mode adopted for the refined status identifier to be confirmed may be an octal code, a hexadecimal code, a decimal code, and the like.

In the embodiment of the present application, the attendance checking rule is used for recording the normal working time of the employee, and may include a working date and a working duration, for example, weekend double break, 2 days of monthly break, 8 hours of daily work, five in eight nights in the morning, six in nine nights in the morning, and the like.

Illustratively, the flexible measure refers to the length of time that the employee needs to work for a fixed period of time, e.g., 8 hours per day for 5 days per week, 12 hours per 36 hours per month, 12 hours per day for 10 days per month, etc.

Illustratively, the fixed system means that the work attendance time of the employee is fixed, such as morning and evening five on weekend double break, morning and evening six on weekend double break, morning and evening 4 on weekend single break, and the like.

It can be understood that, for different attendance rules, the judgment rules for judging whether the attendance information should be stored in the date database or the overtime database are different, and therefore, the attendance rules need to be stored in different databases according to whether the attendance rules are in an elastic system or a fixed system.

In the embodiment of the application, the original attendance information is processed, screened and classified according to the service scene, and respectively stored in the daily database and the overtime database. Because the daily database and the overtime database belong to two independent databases, the data can be called according to the requirement of the data in the later period, so that the system resources are saved. It can be understood that the attendance information stored in the daily database and the overtime database includes the identity of the employee and the date of the card punch, and according to the actual operation of the employee, the attendance information may further include: the system comprises work attendance card punching time, work leaving card punching time and leave asking time.

And 203, the data processing device acquires data to be counted corresponding to the counting target from the daily database and the overtime database, and acquires attendance statistical data according to the data to be counted.

In the embodiment of the application, the data to be counted is at least one of the following data: normal attendance data, abnormal attendance data and overtime data. It should be noted that the data to be counted may also be determined according to the requirements of the service scenario.

In the embodiment of the application, if the statistical target may be attendance details, attendance normal rate, attendance abnormal rate or overtime rate of the employee, the data to be statistical corresponding to the statistical target may be acquired according to an independent database (a daily database or an overtime database), and then attendance statistics is performed on the data to be statistical so as to acquire the attendance statistical data.

Moreover, in the embodiment of the present application, if the statistical target may also be the login-complementing related information, the abnormal attendance data and the overtime data may be merged for the daily database and the overtime database, so as to obtain the data to be counted corresponding to the statistical target, and then the attendance statistics is performed on the data to be counted, so as to obtain the login-complementing data corresponding to the employee identity.

Furthermore, in the embodiment of the application, the data to be counted can further include the number of attendance days, the working time and the overtime time corresponding to the employee identification.

In the embodiment of the application, the attendance information recorded in the card database and the leave-on database is processed in a database, and the daily attendance data and the leave-on data are respectively stored in the daily database and the leave-on database, so that the processing efficiency of counting the daily attendance condition and the leave-on working time can be improved.

Optionally, in this embodiment of the present application, as shown in fig. 3, step 202 may be implemented by steps 301 to 306.

Step 301, the data processing device determines the working time length of the day according to the office attendance time and the office attendance time under the condition that the attendance rule corresponding to the employee identity is the flexible system.

Step 302, the data processing apparatus searches for the leave-on duration corresponding to the card-punching date in the attendance information when the working duration of the current day is less than the preset working duration.

And step 303, storing the attendance information into a daily database by the data processing device under the condition that the leave-on duration is greater than or equal to the first absent-duty duration, and setting an absent-duty state identifier.

And step 304, under the condition that the leave asking time duration is less than the first absent duty duration, the data processing device stores the attendance information and the first absent duty duration into a date database and sets a to-be-confirmed state identifier.

And 305, storing the attendance information into a daily database and setting a normal state identifier under the condition that the working time of the current day is equal to the preset working time.

And step 306, under the condition that the working time of the day is longer than the preset working time, the data processing device stores the attendance information and the first overtime time into an overtime database.

In the embodiment of the application, the working time of the day is a difference value between the off-duty time and the on-duty time, the first off-duty time is a difference value between the preset working time and the working time of the day, and the first on-duty time is a difference value between the working time of the day and the preset working time.

In the embodiment of the application, for the flexible attendance checking rule, the database in which attendance information needs to be stored is judged by considering the comparison result of the current-day work duration and the preset work duration as well as the leave-asking duration and the first absent-attendance duration.

It can be understood that, in order to record the state of the attendance information, a normal state identifier, an absent state identifier and a to-be-confirmed state identifier are further set. The normal state identification is used for identifying the attendance information as the attendance record of normal attendance of the staff, the absent state identification is used for identifying the attendance record of attendance information as the staff leave, and the to-be-confirmed state identification is used for identifying the attendance record of the attendance information as the attendance record of the staff which is not normally attendance.

Optionally, in this embodiment of the application, as shown in fig. 4, after the step 202, the data processing method may further be implemented through the following steps 401 to 405.

Step 401, the data processing device obtains the employee identity corresponding to the status identifier to be confirmed in the daily database.

Step 402, the data processing device obtains a first absent time corresponding to the employee identity corresponding to the status identifier to be confirmed in the daily database.

And step 403, the data processing device acquires a first shift-adding duration corresponding to the employee identity corresponding to the status identifier to be confirmed in the shift-adding database.

Step 404, when the first absence period is less than or equal to the first overtime period, the data processing device changes the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier, and determines a difference value between the first overtime period and the first absence period as the updated first overtime period.

And 405, generating attendance abnormity prompt information by the data processing device under the condition that the first attendance duration is greater than the first overtime duration.

In the embodiment of the application, the identifier of the normal attendance data is a normal state identifier, the identifier of the abnormal attendance data comprises a to-be-confirmed state identifier and an absent state identifier, and the attendance abnormal prompt information is used for prompting that the employee identity identifier corresponding to the to-be-confirmed state identifier needs attendance checking and attendance checking.

In the embodiment of the application, for the prompt of the staff on the login, the daily database and the overtime database need to be merged, so that the login time length is calculated, and the prompt information of attendance exception is generated. It can be understood that the attendance exception prompt information can be sent to the terminal corresponding to the identity identifier of the logged-on employee in a mail mode, and the attendance exception prompt information can be counted and summarized so that the attendance checking personnel can uniformly remind corresponding employees according to the attendance exception prompt information.

Optionally, in this embodiment of the present application, as shown in fig. 5, step 202 may be implemented by steps 501 to 505 described below.

And step 501, under the condition that the off-duty time is after the preset off-duty time, the data processing device stores the attendance information and the second off-duty time length into an off-duty database.

And step 502, under the condition that the attendance information meets the preset attendance condition, the data processing device acquires second attendance duration according to the attendance card time and the attendance card time.

And 503, under the condition that the second absent duration is less than or equal to the leave-on duration, the data processing device stores the attendance information into a date database and sets an absent status identifier.

And step 504, under the condition that the second absent time duration is longer than the leave-on time duration, the data processing device stores the attendance information and the second absent time duration into a date database, and sets a to-be-confirmed state identifier.

And 505, under the condition that the attendance information does not meet the preset attendance absence condition, the data processing device stores the attendance information into a date database and sets a normal state identifier.

In the embodiment of the application, the second overtime time is the difference value between the off-duty time and the preset time; the preset absence condition comprises at least one of the following: the working time of the card is after the preset working time, the working time of the card is before the preset working time and the working time of the card is after the working time of the card, the second absent time is the sum of a first difference value and a second difference value, the first difference value is the difference value between the working time of the card and the preset working time, and the second difference value is the difference value between the preset working time of the card and the working time of the card.

In the embodiment of the application, for the fixedly-made attendance rules, similar to the elastically-made attendance rules, the attendance information needs to be stored in a database, and the state identifier is set.

It can be understood that the second attendance duration and the first attendance duration in step 404 are actual attendance durations, and because the attendance rules adopted are different, the calculation methods of the attendance durations are also different, and different names are adopted for distinguishing different attendance rules.

According to the method, whether the attendance information is stored in the daily database or the overtime database is judged according to the actual working time of the day for the fixed attendance rule, and the normal state identifier, the absent state identifier or the to-be-confirmed state identifier is set according to the working time of the day and the leave-on time, so that the attendance information can be accurately sorted and processed.

Optionally, in this embodiment of the application, as shown in fig. 6, the data processing method may further be implemented by the following steps 601 to 605.

Step 601, the data processing device obtains the employee identity corresponding to the status identifier to be confirmed in the daily database.

Step 602, the data processing device obtains a second absent time corresponding to the employee identity corresponding to the status identifier to be confirmed in the daily database.

And 603, the data processing device acquires a second overtime length corresponding to the employee identity corresponding to the status identifier to be confirmed in an overtime database.

And step 604, under the condition that the second attendance duration is less than or equal to the second overtime duration, changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier, and determining the difference value between the first overtime duration and the first attendance duration as the updated second overtime duration.

And 605, generating attendance abnormal prompt information under the condition that the second attendance time is longer than the second overtime time.

In the embodiment of the application, the identifier of the normal attendance data is a normal status identifier, the identifier of the abnormal attendance data comprises a status identifier to be confirmed and an absent attendance status identifier, and the attendance abnormal prompt information is used for prompting that the employee identity identifier corresponding to the status identifier to be confirmed needs to perform attendance registration.

It should be noted that if the attendance exception prompting information exists, the attendance checking personnel can be prompted to perform recheck statistics in a visual prompting manner.

In the embodiment of the present application, as shown in fig. 7, regarding attendance checking and attendance checking, it can be simply understood that an attendance checking system is divided into an elastic system and a fixed system, and then calculation is performed in combination with multiple scene dimensions such as leave taking, attendance checking, overtime, and the like, so as to determine the identity, the date and the time of attendance checking and attendance checking.

In the embodiment of the application, for attendance checking and subsidizing, currently, calculation is mostly performed through a simple time difference of checking, the method is not suitable for a scene with fixed time for office work, the working duration is manually filled, the conditions of attendance checking, leave asking, shift adding and the like on the day need to be comprehensively considered by staff, and the staff mis-filling rate and the background check staff rework rate are high.

In the embodiment of the present application, to implement the data processing method provided by the present application, a use parameter, a constant: a normal shift-up point MIN, a normal shift-down point MAX, an overtime starting point ADD and a daily time length WORKH; variables are as follows: employee identification id, date, earliest time of card punching begin 0:0, latest time of card punching end 0:0 (marked as 0:0 as initial state to prevent missed card punching), attendance state (normal 00, absent work 01, to be confirmed 11, late to 10, early retreat 11, absenteeism 12), absent work time period leaveh entries 0, daily work hours wokhours 0, and work hours addmans 0.

In the embodiment of the present application, as shown in fig. 8, a specific implementation process includes: data collection, data banking and data calculation. The data sources comprise daily card punching records (id, date, begin, end) of the staff in the card punching database and staff leave requests (id, date, leave hours) in the leave request database. The data sub-database can integrate data sources by adopting a timing batch running mode.

In one example, if the attendance system uses the resiliency system, the following procedure can be used to implement the binning:

in another example, if the attendance system employs fixed customization, the sub-library may be implemented using the following procedure:

it should be further noted that, in the database sorting process, the original data is processed, and the screening and classification are performed according to the service scene, including a daily database and an overtime database. The daily database comprises normal attendance data and abnormal attendance data, wherein the abnormal attendance data comprises attendance data corresponding to the absent attendance state identification and the to-be-confirmed attendance state identification.

It can be understood that the daily database and the overtime database belong to two independent databases respectively, and data can be called according to later-stage requirements, so that resources are saved.

It can also be understood that, when the abnormal attendance data corresponding to the state identifier to be confirmed is used, the employee can fill in the working hours by himself, and meanwhile, the page gives an abnormal attendance prompt notice.

In the embodiment of the present application, the data calculation process may include: combining the daily database and the overtime database, and adding the abnormal attendance information corresponding to the state identifier to be confirmed into a complementary database (id, date, state, workhours, addjours); when the staff performs the working hour registration, the maximum working hour capable of being filled in can be automatically displayed; the checking statistics personnel can directly call the data in the overtime library to calculate the overtime rate; the attendance abnormal rate can be counted according to the attendance states (such as 00, 01 and 10).

It should be noted that, for the data calculation process, data is called in a scene, and if the employee checks the login completion time, the attendance data in the daily database and the overtime database are merged; if the checker counts the attendance abnormal rate or overtime rate, the calculation can be carried out on each independent library.

It can be understood that the phenomena of missing filling, wrong filling and wrong filling often occur in the process of filling the working hours by the staff, and the rework rate is higher in the later period. When the user is on the card, whether attendance is abnormal, whether the user asks for leave, whether overtime happens or not and the like need to be checked, the processes of inquiring the card record, asking for leave application record and the like are complicated, and the user experience is poor.

It can be understood that, when the business party or the checker rechecks the overtime rate, the abnormal rate and other conditions, the work of rework, recheck, recalculation and the like is added, and unnecessary waste of personnel is caused.

It can be understood that various data are stored, screened and fused by a big data technology, visual prompts are provided for employees, and the verifier can concentrate on abnormal rate for rechecking statistics. And the data is distributed and managed according to the service scene, so that the service party can conveniently carry out scene-divided data statistics, and unnecessary resources are repeatedly wasted.

The method provided by the embodiment of the present application is described in detail above with reference to fig. 1 to 8. In order to implement the functions, the data processing device includes hardware structures and/or software modules for performing the respective functions, and the hardware structures and/or software modules for performing the respective functions may constitute an electronic device. Those of skill in the art will readily appreciate that the present application is capable of hardware or a combination of hardware and computer software implementing the various illustrative algorithm steps described in connection with the embodiments disclosed herein. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.

In the embodiment of the present application, according to the method described above, the electronic device is exemplarily divided into the functional modules, for example, the electronic device may include a data processing apparatus, the data processing apparatus may divide each functional module corresponding to each function, or may integrate two or more functions into one processing module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. It should be noted that, in the embodiment of the present application, the division of the module is schematic, and is only one logic function division, and there may be another division manner in actual implementation.

Hereinafter, the data processing apparatus according to the embodiment of the present application will be described in detail with reference to fig. 9. It should be understood that the description of the apparatus embodiments corresponds to the description of the method embodiments, and therefore, for brevity, details are not repeated here, since the details that are not described in detail may be referred to the above method embodiments.

Fig. 9 is a schematic diagram illustrating a structure of a data processing apparatus according to an exemplary embodiment, which may be used to perform the data processing methods illustrated in fig. 1-8. As one implementation, the apparatus may include: an acquisition unit 91, a storage unit 92, and a processing unit 93;

The obtaining unit 91 is configured to obtain at least one piece of attendance information in a preset time period from the card printing database and the leave asking database, where each piece of attendance information includes at least one of the following items: employee identity identification, card punching date, work card punching time and leave time; for example, in connection with fig. 1, the data acquisition unit 91 may be configured to perform step 201.

The storage unit 92 is configured to store the daily attendance data in the at least one piece of attendance information to the daily database and store the overtime attendance data in the at least one piece of attendance information to the overtime database according to the attendance rules corresponding to the employee identity, where the daily attendance data includes normal attendance data and abnormal attendance data; for example, in conjunction with fig. 2, storage unit 92 may be used to perform step 202.

The processing unit 93 is configured to obtain data to be counted corresponding to the statistical target from the daily database and the overtime database, and obtain attendance statistical data according to the data to be counted, where the data to be counted is at least one of the following data: normal attendance data, abnormal attendance data and overtime data. For example, in conjunction with fig. 1, the attendance processing unit 93 may be configured to perform step 203.

Optionally, as shown in fig. 9, the storage unit 92 is specifically configured to: under the condition that an attendance rule corresponding to the employee identity is an elastic system, determining the working time length of the day according to the working time and the off-duty time, wherein the working time length of the day is the difference value of the off-duty time and the working time; under the condition that the working duration of the current day is less than the preset working duration, searching for the leave-asking duration corresponding to the card-punching date in the attendance information; under the condition that the leave-on duration is greater than or equal to the first absent-duty duration, storing attendance information into a daily database, and setting an absent-duty state identifier, wherein the first absent-duty duration is a difference value between the preset working duration and the working duration of the day; under the condition that the leave-on duration is less than the first absent-duty duration, storing attendance information and the first absent-duty duration into a daily database, and setting a state identifier to be confirmed; under the condition that the working duration of the current day is equal to the preset working duration, the attendance information is stored in a daily database, and a normal state identifier is set; and under the condition that the working time length of the day is greater than the preset working time length, storing the attendance information and a first overtime length into an overtime database, wherein the first overtime length is the difference value between the working time length of the day and the preset working time length. For example, in conjunction with fig. 3, the storage unit 92 may be used to perform steps 301 to 306.

Optionally, as shown in fig. 9, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a status identifier to be confirmed and an absent status identifier; the above-mentioned device still includes:

the obtaining unit 91 is further configured to obtain, in the daily database, an employee identity corresponding to the status identifier to be confirmed; for example, in conjunction with fig. 4, the obtaining unit 92 may be configured to perform step 401.

The acquiring unit is also used for acquiring a first absent time corresponding to the employee identity corresponding to the state identifier to be confirmed in the daily database; for example, in conjunction with fig. 4, the obtaining unit 92 may be configured to perform step 402.

The acquiring unit is also used for acquiring a first overtime length corresponding to the employee identity corresponding to the state identifier to be confirmed in the overtime database; for example, in conjunction with fig. 4, the obtaining unit 92 may be configured to perform step 403.

The processing unit is further used for changing the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database into a normal state identifier under the condition that the first attendance duration is less than or equal to the first overtime duration, and determining the difference value between the first overtime duration and the first attendance duration as the updated first overtime duration; for example, in connection with fig. 4, processing unit 93 may be configured to perform step 404.

The processing unit 93 is further configured to generate attendance exception prompting information when the first attendance duration is longer than the first overtime duration, where the attendance exception prompting information is used to prompt that the employee identity identifier corresponding to the to-be-confirmed status identifier needs to perform attendance checking and attendance checking. For example, in connection with fig. 4, the processing unit 93 may be adapted to perform step 405.

Optionally, as shown in fig. 9, the storage unit 92 is specifically further configured to: in particular also for: under the condition that the off-duty time is after the preset off-duty time, the attendance information and a second off-duty time length are stored in an off-duty database, wherein the second off-duty time length is the difference value between the off-duty time length and the preset time length; under the condition that the attendance information meets the preset attendance-absence condition, acquiring second attendance-absence duration according to the attendance-absence time and the attendance-absence time, wherein the preset attendance-absence condition comprises at least one of the following items: after the working time, the off-duty time and the working time are preset, the second absent time period is the sum of a first difference value and a second difference value, the first difference value is the difference value between the working time and the preset on-duty time, and the second difference value is the difference value between the preset off-duty time and the off-duty time; under the condition that the second absent duration is less than or equal to the leave-on duration, storing the attendance information into a daily database, and identifying the absent status by setting the absent status; under the condition that the second absent time length is greater than the leave-on time length, storing the attendance information and the second absent time length into a daily database, and setting a state identifier to be confirmed; and under the condition that the attendance information does not meet the preset absence condition, storing the attendance information into a daily database, and setting a normal state identifier. For example, in conjunction with fig. 5, the storage unit 92 may be used to perform steps 501 to 505.

Optionally, the identifier of the normal attendance data is a normal status identifier, and the identifier of the abnormal attendance data includes a status identifier to be confirmed and an absent attendance status identifier; as shown in fig. 9, the apparatus further includes:

the obtaining unit 91 is further configured to obtain, in the daily database, an employee identity corresponding to the status identifier to be confirmed; for example, in connection with fig. 6, the obtaining unit 91 may be configured to perform step 601.

The obtaining unit 91 is further configured to obtain, in the daily database, a second absent duration corresponding to the employee identity corresponding to the status identifier to be confirmed; for example, in connection with fig. 6, the obtaining unit 91 may be configured to perform step 602.

The obtaining unit 91 is further configured to obtain, in the overtime database, a second overtime duration corresponding to the employee identity corresponding to the status identifier to be confirmed; for example, in connection with fig. 6, the obtaining unit 91 may be configured to perform step 603.

The processing unit 93 is further configured to, when the second attendance time length is less than or equal to the second overtime length, change the status identifier corresponding to the employee identity identifier corresponding to the status identifier to be confirmed in the daily database into a normal status identifier, and determine a difference between the first overtime length and the first attendance time length as the updated second overtime length; for example, in connection with fig. 6, the processing unit 93 may be adapted to perform step 604.

And the processing unit 93 is further configured to generate attendance exception prompting information when the second attendance duration is longer than the second overtime duration, where the attendance exception prompting information is used to prompt that the employee identity identifier corresponding to the to-be-confirmed status identifier needs to perform attendance checking and attendance checking. For example, in connection with fig. 6, the processing unit 93 may be configured to execute step 605.

Fig. 10 is a schematic diagram illustrating a hardware configuration of a computer device according to an example embodiment. The computer device may comprise a processor 1002, the processor 1002 being configured to execute application program code to implement the data processing method in the present application.

The processor 1002 may be a Central Processing Unit (CPU), a microprocessor, an application-specific integrated circuit (ASIC), or one or more ics for controlling the execution of programs in accordance with the present disclosure.

As shown in fig. 10, the computer device may also include a memory 1003. The memory 1003 is used for storing application program codes for executing the scheme of the application, and the execution is controlled by the processor 1002.

The memory 1003 may be, but is not limited to, a read-only memory (ROM) or other type of static storage device that can store static information and instructions, a Random Access Memory (RAM) or other type of dynamic storage device that can store information and instructions, an electrically erasable programmable read-only memory (EEPROM), a compact disk read-only memory (CD-ROM) or other optical disk storage, optical disk storage (including compact disk, laser disk, optical disk, digital versatile disk, blu-ray disk, etc.), magnetic disk storage or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer. The memory 1003 may be separate and coupled to the processor 1002 by a bus 1004. Memory 1003 may also be integrated with processor 1002.

As shown in fig. 10, the computer device may further comprise a communication interface 1001, wherein the communication interface 1001, the processor 1002 and the memory 1003 may be coupled to each other, for example, via a bus 1004. The communication interface 1001 is used for information interaction with other devices, for example, information interaction between a computer device and other devices is supported.

It should be noted that the device configuration shown in fig. 10 does not constitute a limitation of the computer device, and the computer device may include more or less components than those shown in fig. 10, or combine some components, or a different arrangement of components, in addition to the components shown in fig. 10.

In actual implementation, the functions implemented by the obtaining unit 91, the storage unit 92 and the processing unit 93 can be implemented by the processor 1002 shown in fig. 10 calling program codes in the memory 1003. For a specific implementation process, reference may be made to the description of the data processing method portion shown in fig. 2, which is not described herein again.

The present application also provides a computer-readable storage medium comprising instructions stored thereon, which when executed by a processor of a computer device, enable a computer to perform the block chain based data processing method provided by the above-described illustrative embodiment. For example, the computer-readable storage medium may be a memory 1003 including instructions executable by a processor 1002 of a computer device to perform the above-described method. Alternatively, the computer readable storage medium may be a non-transitory computer readable storage medium, for example, the non-transitory computer readable storage medium may be a ROM, a RAM, a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.

In an exemplary embodiment, the present application further provides a computer program product, which when run on a computer, causes the computer to implement the data processing method in the foregoing embodiment.

Through the description of the above embodiments, it is clear to those skilled in the art that, for convenience and simplicity of description, only the division of the above functional modules is used for illustration, and in practical applications, the above function allocation may be completed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules, so as to complete the above-described whole classification part or part of the functions.

In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a module or a unit is only one type of logical functional division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another apparatus, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

Units described as separate parts may or may not be physically separate, and parts displayed as units may be one physical unit or a plurality of physical units, may be located in one place, or may be distributed to a plurality of different places. The partial or full classification units can be selected according to actual needs to achieve the purpose of the scheme of the embodiment.

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

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present application, or portions thereof that substantially contribute to the prior art, or the whole classification part or portions thereof, may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling a device (which may be a single chip, a chip, etc.) or a processor (processor) to execute the whole classification part or some steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a removable hard disk, a ROM, a RAM, a magnetic disk, or an optical disk.

The above description is only an embodiment of the present application, but the scope of the present application is not limited thereto, and any changes or substitutions within the technical scope disclosed in the present application should be covered within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims

1. A method of data processing, the method comprising:

acquiring at least one piece of attendance information in a preset time period from a card printing database and a leave database, wherein the attendance information comprises at least one of the following items: employee identity identification, card punching date, work card punching time and leave time;

according to the attendance rules corresponding to the employee identity, storing daily attendance data in the at least one piece of attendance information into a daily database, and storing overtime attendance data in the at least one piece of attendance information into an overtime database, wherein the daily attendance data comprises normal attendance data and abnormal attendance data;

acquiring data to be counted corresponding to a counting target from the daily database and the overtime database, and acquiring attendance statistical data according to the data to be counted, wherein the data to be counted is at least one of the following data: the normal attendance data, the abnormal attendance data and the overtime data.

2. The data processing method of claim 1, wherein the storing the daily attendance data in the at least one piece of attendance information to a date database and the storing the overtime attendance data in the at least one piece of attendance information to an overtime database according to the attendance rules corresponding to the employee identity comprises:

under the condition that an attendance rule corresponding to the employee identity is an elastic system, determining the working time of the day according to the working time of checking the attendance and the working time of checking the attendance, wherein the working time of the day is the difference value between the working time of checking the attendance and the working time of checking the attendance;

under the condition that the working duration of the current day is less than the preset working duration, searching the leave-on duration corresponding to the card punching date in the attendance information;

under the condition that the leave-on duration is greater than or equal to a first absent-duty duration, storing the attendance information to the daily database, and setting an absent-duty state identifier, wherein the first absent-duty duration is a difference value between the preset working duration and the working duration of the day;

under the condition that the leave asking time length is less than a first absent time length, storing the attendance information and the first absent time length into the daily database, and setting a state identifier to be confirmed;

Under the condition that the working time of the current day is equal to the preset working time, storing the attendance information into the daily database, and setting a normal state identifier;

and under the condition that the working time of the day is greater than the preset working time, storing the attendance information and a first overtime time into the overtime database, wherein the first overtime time is a difference value between the working time of the day and the preset working time.

3. The data processing method of claim 2, wherein the identifier of the normal attendance data is the normal status identifier, and the identifier of the abnormal attendance data comprises the to-be-confirmed status identifier and the absent attendance status identifier;

before acquiring attendance statistical data according to the data to be counted from the daily database and the overtime database and the data to be counted corresponding to a statistical target, the method further comprises the following steps:

acquiring employee identity marks corresponding to the state marks to be confirmed in the daily database;

acquiring a first absent time corresponding to the employee identity corresponding to the status identifier to be confirmed in the daily database;

Acquiring a first overtime length corresponding to the employee identity corresponding to the status identifier to be confirmed in the overtime database;

when the first attendance duration is less than or equal to the first overtime duration, changing the status identifier corresponding to the employee identity identifier corresponding to the status identifier to be confirmed in the daily database into a normal status identifier, and determining the difference value between the first overtime duration and the first attendance duration as the updated first overtime duration;

and generating abnormal attendance prompt information under the condition that the first attendance time length is greater than the first overtime time length, wherein the abnormal attendance prompt information is used for prompting that the employee identity identification corresponding to the state identification to be confirmed needs to carry out attendance registration.

4. The data processing method of claim 1, wherein the storing the daily attendance data in the at least one piece of attendance information to a date database and the storing the overtime attendance data in the at least one piece of attendance information to an overtime database according to the attendance rules corresponding to the employee identity comprises:

under the condition that the off-duty time of punching is after the preset off-duty time, storing the attendance information and the second off-duty time length into the off-duty database, wherein the second off-duty time length is the difference value between the off-duty time of punching and the preset time of punching;

Under the condition that the attendance information meets a preset attendance condition, acquiring second attendance duration according to the office attendance time and the off-duty time; the preset absence condition comprises at least one of: after the on-duty time of card punching is preset on-duty time, the off-duty time of card punching is before the preset off-duty time and the on-duty time of card punching is after the off-duty time of card punching, wherein the second off-duty time is the sum of a first difference value and a second difference value, the first difference value is the difference value between the on-duty time of card punching and the preset on-duty time, and the second difference value is the difference value between the preset off-duty time of card punching and the preset off-duty time of card punching;

under the condition that the second absent duty time is less than or equal to the leave-on time, storing the attendance information into the daily database, and setting an absent duty state identifier;

under the condition that the second absent time length is greater than the leave-on time length, storing the attendance information and the second absent time length into the daily database, and setting a state identifier to be confirmed;

and under the condition that the attendance information does not meet the preset attendance absence condition, storing the attendance information to the daily database, and setting a normal state identifier.

5. The data processing method of claim 4, wherein the identifier of the normal attendance data is the normal status identifier, and the identifier of the abnormal attendance data comprises the to-be-confirmed status identifier and the absent attendance status identifier;

before acquiring data to be counted corresponding to a statistical target from the daily database and the overtime database and acquiring attendance statistical data according to the data to be counted, the method further comprises the following steps:

acquiring a second absent time corresponding to the employee identity corresponding to the status identifier to be confirmed in the daily database;

acquiring a second overtime time corresponding to the employee identity corresponding to the status identifier to be confirmed in the overtime database;

when the second attendance duration is less than or equal to the second overtime duration, changing the status identifier corresponding to the employee identity identifier corresponding to the status identifier to be confirmed in the daily database into a normal status identifier, and determining the difference value between the first overtime duration and the first attendance duration as the updated second overtime duration;

And generating abnormal attendance prompt information under the condition that the second attendance time is longer than the second overtime time, wherein the abnormal attendance prompt information is used for prompting that the employee identity identification corresponding to the state identification to be confirmed needs to carry out attendance registration.

6. A data processing apparatus, characterized by comprising: the device comprises an acquisition unit, a storage unit and a processing unit;

the acquisition unit is used for acquiring at least one piece of attendance information in a preset time period from a card punching database and a leave asking database, and each piece of attendance information comprises at least one of the following items: employee identity identification, card punching date, work card punching time and leave time;

the storage unit is used for storing the daily attendance data in the at least one piece of attendance information to an daily database and storing the overtime attendance data in the at least one piece of attendance information to an overtime database according to the attendance rules corresponding to the employee identity, wherein the daily attendance data comprises normal attendance data and abnormal attendance data;

the processing unit is used for acquiring data to be counted corresponding to a counting target from the daily database and the overtime database, and acquiring attendance statistical data according to the data to be counted, wherein the data to be counted is at least one of the following data: the normal attendance data, the abnormal attendance data and the overtime data.

7. The data processing apparatus of claim 6, wherein the storage unit is specifically configured to:

under the condition that the working time length of the day is equal to the preset working time length, storing the attendance information into the daily database, and setting a normal state identifier;

And under the condition that the working time length of the day is greater than the preset working time length, storing the attendance information and a first overtime length to the overtime database, wherein the first overtime length is the difference value between the working time length of the day and the preset working time length.

8. The data processing apparatus of claim 7, wherein the identification of normal attendance data is the normal status identification, and the identification of abnormal attendance data comprises the to-be-confirmed status identification and the absent attendance status identification;

the device further comprises:

the acquiring unit is further configured to acquire, in the daily database, the employee identity corresponding to the status identifier to be confirmed;

the acquiring unit is further configured to acquire, in the daily database, a first absence duration corresponding to the employee identity corresponding to the status identifier to be confirmed;

the acquiring unit is further configured to acquire, in the overtime database, a first overtime duration corresponding to the employee identity corresponding to the status identifier to be confirmed;

the processing unit is further configured to change the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database to a normal state identifier when the first absence period is less than or equal to the first overtime period, and determine a difference between the first overtime period and the first absence period as an updated first overtime period;

The processing unit is further used for generating attendance exception prompt information under the condition that the first attendance duration is greater than the first overtime duration, wherein the attendance exception prompt information is used for prompting that the employee identity identification corresponding to the state identification to be confirmed needs to perform attendance checking and attendance checking.

9. The data processing apparatus of claim 6, wherein the storage unit is further configured to:

under the condition that attendance information satisfies preset absence condition, according to the time of checking a card on duty with the time of checking a card off duty, obtain the second absence duration, preset absence condition includes at least one of following: after the on-duty card punching time is after preset on-duty time, before the off-duty card punching time is before the preset off-duty time and after the off-duty card punching time, the second off-duty time is the sum of a first difference value and a second difference value, the first difference value is the difference value between the on-duty card punching time and the preset on-duty time, and the second difference value is the difference value between the preset off-duty time and the off-duty card punching time;

10. The data processing apparatus of claim 9, wherein the identifier of normal attendance data is a normal status identifier, and the identifier of abnormal attendance data comprises a to-be-confirmed status identifier and an absent status identifier;

the device further comprises:

the acquiring unit is further configured to, before acquiring data to be counted corresponding to a statistical target from the daily database and the overtime database and acquiring attendance statistical data according to the data to be counted, the apparatus further includes:

The acquiring unit is further configured to acquire, in the daily database, a second attendance duration corresponding to the employee identity corresponding to the status identifier to be confirmed;

the acquiring unit is further configured to acquire, in the overtime database, a second overtime duration corresponding to the employee identity corresponding to the status identifier to be confirmed;

the processing unit is further configured to change the state identifier corresponding to the employee identity identifier corresponding to the state identifier to be confirmed in the daily database to a normal state identifier when the second absence period is less than or equal to the second overtime period, and determine a difference between the first overtime period and the first absence period as the updated second overtime period;

the processing unit is further configured to generate attendance exception prompt information under the condition that the second attendance absence duration is greater than the second overtime duration, wherein the attendance exception prompt information is used for prompting that the employee identity identifier corresponding to the to-be-confirmed state identifier needs attendance checking and attendance checking.

11. An electronic device comprising a memory, a processor, a bus, and a communication interface; the memory is used for storing computer execution instructions, and the processor is connected with the memory through the bus; the processor executes the computer-executable instructions stored by the memory when the electronic device is running to cause the electronic device to perform the data processing method of any of claims 1-5.

12. A computer-readable storage medium, comprising computer-executable instructions that, when executed on a computer, cause the computer to perform the data processing method of any one of claims 1-5.