An attendance management system for Bluetooth device interaction through mini-programs

Abstract

The present invention relates to the technical field of attendance management, and specifically discloses an attendance management system for interacting with Bluetooth devices through a mini-program, which is used to solve the problem that in a complex attendance environment with multiple departments and multiple shifts, it is difficult to automatically generate an optimal schedule and ensure that it meets the working hour requirements of all employees, the working hour restrictions stipulated by law, employee preferences and company operation needs. The system consists of a main control module, a scheduling optimization module, a collection function module, a display function module, a sound function module, a button function module, a storage function module, a Bluetooth function module and a mini-program. The main control module constructs an integer linear programming model according to defined variables, objective functions and constraints, and uses an integer linear programming solver to solve the model and find the optimal solution. Through the WeChat mini-program operation, users can manage attendance through their mobile phones, and the integer linear programming algorithm is used to dynamically generate and optimize the optimal schedule in combination with historical preference data and real-time feedback.

Description

Technical Field

[0001] The present invention relates to the field of attendance application technology, and more specifically, to an attendance management system for interacting with Bluetooth devices through a small program. Background Art

[0002] Attendance is an act of managing members' daily attendance and leave in specific scenarios by an enterprise or organization, so as to achieve the corresponding management of personnel and time. Existing attendance management systems are mainly implemented through pure software or software plus equipment. The attendance management system of software plus equipment is mainly based on the following technologies: (1) Standalone operation without Internet connection. The manager enters the device through other media (U disk) to perform corresponding operations such as personnel entry, scheduling, and attendance data export; (2) Connecting the device within the local area network, and performing corresponding management operations, data collection, and report output through the local software pre-installed on the PC; (3) Connecting the device through the Internet (cloud), and performing corresponding management operations, data collection, and report output through the web page. The application of the latter two technologies can meet the complex attendance management needs through the software platform, which is suitable for medium and large enterprises. The application of the first technology mainly performs corresponding attendance management through the embedded program in the device, and then exports the result file of the embedded program through the U disk to complete the attendance management. It is more suitable for small enterprises. The entry of personnel, the establishment of management systems, the setting of personnel shifts, the export of attendance results, etc. must still be completed by the administrator through corresponding operations on the device. Each operation must enter the device menu, which greatly limits and inconveniences the actual use of the administrator. At the same time, frequent equipment operation will accelerate the wear of the mechanical and electronic parts of the equipment and affect the service life of the equipment. In addition, with the rapid development of mobile intelligence, the traditional attendance management system model is increasingly unable to meet the needs of users in terms of humanized operation and convenience. With the development of mobile Internet and Bluetooth technology, attendance management systems are gradually moving towards intelligence and mobility. Through the combination of WeChat applets and Bluetooth devices, convenient and efficient attendance data collection and management can be achieved. However, in a complex attendance environment with multiple departments and multiple shifts, automatically generating the optimal schedule and ensuring that it meets the working hour requirements of all employees, legal working hour restrictions, employee preferences and company operating needs is still a very challenging technical problem. Summary of the invention

[0003] In order to overcome the above-mentioned defects of the prior art, the present invention provides an attendance management system for interacting with Bluetooth devices through a mini-program. It is operated through the WeChat mini-program, and users can manage their attendance through their mobile phones. It adopts an integer linear programming algorithm, combines historical preference data and real-time feedback, and dynamically generates and optimizes the optimal schedule.

[0004] To achieve the above object, the present invention provides the following technical solutions:

[0005] An attendance management system that interacts with Bluetooth devices through a mini-program, consisting of a main control module, a scheduling optimization module, a collection function module, a display function module, a sound function module, a button function module, a storage function module, a Bluetooth function module and a mini-program. The main control module is connected to the scheduling optimization module, the collection function module, the display function module, the sound function module, the button function module, the storage function module and the Bluetooth function module. The scheduling optimization module is connected to the mini-program, and the mini-program is connected to the main control module via the Bluetooth function module. The scheduling optimization module obtains employee information, department requirements, shift settings, and legal requirements from the mini-program. Working time data, run the integer linear programming algorithm in the main control module to generate the optimal schedule, transmit the generated schedule to the mini program through the Bluetooth function module, and store it in the storage function module. The main control module builds an integer linear programming model based on the defined variables, objective functions and constraints, uses the integer linear programming solver to solve, finds the optimal solution, outputs the optimal schedule, and verifies its feasibility and effectiveness. Adjustments and feedback are made according to actual conditions to ensure the execution effect of the schedule. In the main control module, the objective function is to maximize the comprehensive score of employee preferences and meet department needs. The formula of the objective function is:

[0006]

[0007] Where: is the value of the objective function, is the comprehensive score of maximizing employee preferences and satisfying department needs, is a keyword that maximizes the value of the function that follows it, Index for employees, is the shift index, is the shift day index, For employees The scheduling preference score is obtained by analyzing the employee's historical preference data. For employees Is it arranged in The first shift days, obtained through employee availability and shift setting data, The actual shifts in the department The working hours required are set by the operational requirements and historical data provided by the company. For the department's planning The working hours required for each shift are set by the operation plan and historical data provided by the department. For employees In the The first shift The day's scheduling preference score, Planned work time requirements for the department Compared with the actual scheduled working hours The gap between is the weight factor used to balance and The weight between .

[0008] In the employee index, the value range is 1 to between, is the total number of employees, obtained from the employee database, including employees' personal information, working hours requirements, and shift preferences; in the shift index, shift indicates a specific shift, ranging from 1 to It is obtained from the company's operation plan and historical data, including the length of working hours for each shift and other relevant information; in the day index, the day index represents the specific day, ranging from 1 to Between, it is set according to the shift cycle (one month) and obtained from the company's shift cycle.

[0009] Preferably, in the main control module, the constraints of the objective function include employee working hour constraints, department demand constraints, daily shift restrictions and employee availability constraints.

[0010] Preferably, in the main control module, the employee working hours constraint is to ensure that the total working hours of each employee are within the legal range. The expression of the employee working hours constraint is:

[0011]

[0012] Where: , The minimum and maximum working hours are respectively stipulated by law for any employee. All satisfied.

[0013] Preferably, in the master control module, the department demand constraints are to ensure that the working hours requirements of each department are met, and the shifts Total working hours No less than department Working hours required , the expression of department demand constraint is:

[0014]

[0015] The above formula is satisfied for any department. The department demand data is obtained from the department's operation plan and historical data, and is input by the department manager or automatically calculated.

[0016] Preferably, in the main control module, the daily shift limit is to ensure that each employee is scheduled for at most one shift per day, and the expression of the daily shift limit is:

[0017]

[0018] The above formula is for employees In the Only one shift can be arranged per day ,The shift setting data is set according to the company's operational needs and historical data, and is provided by the scheduling optimization module.

[0019] Preferably, in the master control module, the employee availability constraint is to ensure that employees are assigned shifts only during their available time periods. In the Flights per day If it is not available in ,Employee available working hours are data obtained from employees’ contracts and historical attendance records, and the available time periods for each employee are automatically generated.

[0020] Preferably, in the main control module, the employee in the objective function The specific process of obtaining the scheduling preference score through the analysis of employees' historical preference data includes:

[0021] Step 1: Data collection: Collect employees’ historical shift arrangements, attendance, and leave records from historical shift scheduling data, and collect employees’ preference scores for each shift and their satisfaction with shift arrangements from employee feedback records. Clean and integrate the two sets of data to form a comprehensive data table containing each employee, each shift, and each date.

[0022] Step 2, feature extraction: calculate the attendance times and satisfaction scores of each employee in different shifts as the employee's shift preference, analyze the employee's attendance and preference in different time periods as the employee's time preference, calculate the impact of the employee's consecutive working days on the satisfaction score as the employee's consecutive working days preference, analyze the employee's rest preference for weekends and holidays as the employee's rest day preference, and use shift preference, time preference, consecutive working days preference and rest day preference as the key features that affect the employee's scheduling preference;

[0023] Step 3: Model training: Select the random forest model, use historical data for model training, adjust model parameters, and use the cross-validation method to evaluate model performance;

[0024] Step 4: Calculate preference scores: Input the current employee’s feature data into the trained model to predict their preference scores for different shifts, and normalize the preference scores so that the scores are between 0 and 1.

[0025] Step 5: Real-time update of the model: Continuously collect the latest scheduling data and employee feedback data, dynamically adjust the preference scores based on the latest scheduling data and employee feedback, regularly retrain the preference prediction model with the latest data, update the model parameters, and adjust the employee's shift preference scores based on the prediction results of the new model.

[0026] Preferably, in the shift scheduling optimization module, an integer linear programming model is constructed based on defined variables, objective functions and constraints, and an integer linear programming algorithm is run to generate an optimal shift schedule, including:

[0027] Step 1, calculation of employee scheduling preference scores: Calculation of employee scheduling preference scores based on steps 1 to 5;

[0028] Step 2, define variables, objective function and constraints;

[0029] Step 3, use the integer linear programming solver to solve: select the Gurobi solver, input the constructed integer linear programming model into the solver for solving, the solver performs optimization calculation according to the objective function and constraints, finds the optimal solution, and generates the optimal schedule;

[0030] Step 4, result output and verification: output the optimal schedule and verify its feasibility and effectiveness, transmit the generated schedule to the mini program through the Bluetooth function module, and store it in the storage function module;

[0031] Step 5, Adjustment and Feedback: Make adjustments and provide feedback based on actual conditions to ensure the effectiveness of the schedule, continuously monitor the execution of the schedule, collect feedback from employees and departments, and further optimize and improve the model.

[0032] Preferably, in step 5, the shift optimization module makes adjustments and provides feedback according to the actual situation to ensure the execution effect of the shift schedule. The execution of the shift schedule is continuously monitored by comprehensively considering attendance rate, production efficiency and satisfaction score of the execution effect of the shift schedule. The weighted sum of the three is used as the execution effect score of the shift schedule. The execution effect score formula of the shift schedule is:

[0033]

[0034] Where: Score the execution effect of the schedule. For employees In the Attendance of the day, For attendance, For absence, is the total number of employees, is the total number of days in the scheduling cycle, For shift The production efficiency score is obtained from the production management records. is the total number of shifts, For employees The satisfaction score of the execution effect of the shift schedule is obtained through the employee satisfaction questionnaire. , , is a weighting factor, which is set based on company strategy and management decisions.

[0035] Preferably, the collection function module is used to collect employees' biometric data and IC card data, the display function module is used to display interface content and perform human-computer interaction, the sound function module is used to output sound prompts for verification and comparison results, the button function module is used to implement the operation function of the device, the storage function module is used to store biometric data and successful records of daily comparisons, the Bluetooth function module is used to realize the communication connection between the device and the mini program, and the mini program is used to realize the functions of user management, department management, shift equipment, scheduling settings, attendance settings, equipment settings, password management, and report management.

[0036] Compared with the prior art, the technical effects and advantages of the present invention are as follows: the present invention is operated through the WeChat applet, and users do not need to perform tedious operations on the device. They can complete various functions of attendance management through their mobile phones, including user management, shift setting, attendance data collection and report output, etc., which greatly improves management efficiency and convenience. It adopts advanced integer linear programming algorithms, combines employees' historical preference data and real-time feedback, and automatically generates the optimal shift schedule. It can dynamically adjust the shift schedule to ensure that the working hour requirements of each shift are met, while maximally meeting employees' preferences and legal working hour restrictions, improving the scientificity and rationality of the shift schedule, and continuously monitoring the execution of the shift schedule. It collects employees' attendance data, production efficiency and satisfaction feedback, uses complex mathematical functions for comprehensive evaluation, adjusts and optimizes the shift schedule in real time, ensures the execution effect of the shift schedule, improves employee satisfaction and company operating efficiency, and transmits data wirelessly via Bluetooth, which reduces frequent equipment operations and extends the service life of the equipment. At the same time, it replaces device button operations with mobile phone operations, which reduces the mechanical wear and failure rate of the equipment. It is suitable for the attendance management needs of small, medium and large enterprises, and can not only meet simple stand-alone operations, but also realize complex attendance management through LAN and the Internet. Through flexible scheduling optimization and data analysis, it can adapt to the operational needs of enterprises of different sizes and types. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 It is a system block diagram of the present invention. DETAILED DESCRIPTION

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

[0039] like Figure 1 As shown, the present invention proposes an attendance management system for interacting with Bluetooth devices through a mini-program, which is composed of a main control module, a scheduling optimization module, a collection function module, a display function module, a sound function module, a button function module, a storage function module, a Bluetooth function module and a mini-program. The main control module is connected to the scheduling optimization module, the collection function module, the display function module, the sound function module, the button function module, the storage function module and the Bluetooth function module. The scheduling optimization module is connected to the mini-program, and the mini-program is connected to the main control module through the Bluetooth function module. The scheduling optimization module obtains employee information, department requirements, shift settings, The working time data stipulated by the law is used to run the integer linear programming algorithm in the main control module to generate the optimal schedule. The generated schedule is transmitted to the mini program through the Bluetooth function module and stored in the storage function module. The main control module constructs an integer linear programming model based on the defined variables, objective functions and constraints, uses the integer linear programming solver to solve, finds the optimal solution, outputs the optimal schedule, and verifies its feasibility and effectiveness. Adjustments and feedback are made according to actual conditions to ensure the execution effect of the schedule. In the main control module, the objective function is to maximize the comprehensive score of employee preferences and meet department needs. The formula of the objective function is:

[0040]

[0041] Where: is the value of the objective function, is the comprehensive score of maximizing employee preferences and satisfying department needs, is a keyword that maximizes the value of the function that follows it, Index for employees, is the shift index, is the shift day index, For employees The scheduling preference score is obtained by analyzing the employee's historical preference data. For employees Is it arranged in The first shift days, obtained through employee availability and shift setting data, The actual shifts in the department The working hours required are set by the operational requirements and historical data provided by the company. For the department's planning The working hours required for each shift are set by the operation plan and historical data provided by the department. For employees In the The first shift The day's scheduling preference score, Planned work time requirements for the department Compared with the actual scheduled working hours The gap between is the weight factor used to balance and The weight between .

[0042] In the employee index, the value range is 1 to between, is the total number of employees, obtained from the employee database, including employees' personal information, working hours requirements, and shift preferences; in the shift index, shift indicates a specific shift, ranging from 1 to It is obtained from the company's operation plan and historical data, including the length of working hours for each shift and other relevant information; in the day index, the day index represents the specific day, ranging from 1 to Between, it is set according to the shift cycle (one month) and obtained from the company's shift cycle.

[0043] It should be noted that in the main control module, the constraints of the objective function include employee working hours constraints, department demand constraints, daily shift restrictions, and employee availability constraints.

[0044] By operating through the WeChat applet, users do not need to perform tedious operations on the device. They can complete various attendance management functions through their mobile phones, including user management, shift settings, attendance data collection and report output, etc., which greatly improves management efficiency and convenience. It adopts advanced integer linear programming algorithms, combined with employees' historical preference data and real-time feedback, to automatically generate the optimal shift schedule, and can dynamically adjust the shift schedule to ensure that the working hours required for each shift are met. At the same time, it maximizes the satisfaction of employees' preferences and legal working hours restrictions, improves the scientificity and rationality of the shift schedule, and continuously monitors the execution of the shift schedule to collect employees' attendance data. , production efficiency and satisfaction feedback, use complex mathematical functions for comprehensive evaluation, adjust and optimize the schedule in real time, ensure the execution effect of the schedule, improve employee satisfaction and company operating efficiency, and transmit data wirelessly through Bluetooth, which reduces frequent equipment operation and extends the service life of the equipment. At the same time, mobile phone operation replaces device button operation, which reduces the mechanical wear and failure rate of the equipment. It is suitable for the attendance management needs of small, medium and large enterprises, and can not only meet simple stand-alone operation, but also realize complex attendance management through LAN and the Internet. Through flexible scheduling optimization and data analysis, it can adapt to the operational needs of enterprises of different sizes and types.

[0045] It should be noted that the collection function module is used to collect employees' biometric data and IC card data, the display function module is used to display interface content and perform human-computer interaction, the sound function module is used to output sound prompts for verification and comparison results, the button function module is used to realize the operation function of the equipment, the storage function module is used to store biometric data and successful records of daily comparisons, the Bluetooth function module is used to realize the communication connection between the device and the mini program, and the mini program is used to realize the functions of user management, department management, shift equipment, scheduling settings, attendance settings, equipment settings, password management, and report management.

[0046] It should be noted that in the main control module, the employee working hours constraint is to ensure that the total working hours of each employee are within the legal range. The expression of the employee working hours constraint is:

[0047]

[0048] Where: , The minimum and maximum working hours are respectively stipulated by law for any employee. All satisfied.

[0049] Such constraint settings ensure that employees' working hours comply with labor laws and regulations, prevent overtime work, protect employees' legitimate rights and interests, avoid enterprises being punished or assuming legal responsibilities for violating labor laws and regulations, control employees' working hours, prevent employees from being overly tired, and protect employees' physical and mental health. Reasonable working hours arrangements help improve employees' work efficiency and job satisfaction; reasonable working hours arrangements help employees maintain a good working state, improve work efficiency, and avoid inefficiency and reduced work quality caused by long working hours; complying with legal working hours arrangements can improve employees' trust and satisfaction with the company. Employees working within reasonable working hours can better balance work and life, and enhance employees' work enthusiasm and loyalty; through working hours constraints, employees' working hours can be effectively managed and allocated, the formulation of shift schedules can be optimized, and the workload of each employee can be ensured to be moderate, avoiding waste of resources and uneven distribution; ensuring working hours compliance can reduce labor disputes caused by working hours issues, reduce management risks of enterprises, establish good labor relations, and contribute to the long-term and stable development of enterprises; through strict working hours constraints, employees' working hours data can be collected and analyzed to provide decision-making support for enterprise management and help enterprises formulate more scientific and reasonable management policies and operation strategies.

[0050] It should be noted that in the main control module, the department demand constraints are to ensure that the working hours requirements of each department are met. Total working hours No less than department Working hours required , the expression of department demand constraint is:

[0051]

[0052] The above formula is satisfied for any department. The department demand data is obtained from the department's operation plan and historical data, and is input by the department manager or automatically calculated.

[0053] Such constraints ensure that the working hours requirements of each department are met, ensure that the workload of each department can be completed on time, and avoid work delays and backlogs caused by insufficient working hours; reasonably allocate employees' working time to ensure that the needs of each department are met, which helps to optimize the company's resource allocation and improve overall operational efficiency; by meeting the working hours requirements of the departments, ensure that production and operational activities can proceed smoothly, and reduce the problem of low production efficiency caused by insufficient manpower; meet the working hours requirements of the departments to ensure that each department can achieve its operational goals and plans, improve the performance of the departments and the overall business performance; ensure that the working hours requirements of each department are met, which can effectively level the Balance the workload between different departments to avoid situations where some departments are too busy while other departments are idle; reasonable working hour arrangements can prevent some employees from becoming dissatisfied due to excessive overtime, while ensuring that each department has sufficient staff, reducing the pressure caused by excessive workload, and improving employee satisfaction and enthusiasm; by clarifying the working hour requirements and satisfaction of the departments, the transparency of corporate management can be enhanced, making the workload and manpower allocation of each department more open and fair; by collecting and analyzing the working hour demand data of the departments, it supports the company in making data-driven decisions, helping management understand the operating status of each department and adjust resource allocation and operating strategies in a timely manner.

[0054] It should be noted that in the main control module, the daily shift limit is to ensure that each employee is scheduled for at most one shift per day. The expression of the daily shift limit is:

[0055]

[0056] The above formula is for employees In the Only one shift can be arranged per day ,The shift setting data is set according to the company's operational needs and historical data, and is provided by the scheduling optimization module.

[0057] Limiting each employee to one shift per day can prevent employees from working multiple shifts in a row on the same day, avoid overwork, and protect employees' physical health and work efficiency; ensure that employees have sufficient rest time, maintain a good working state, and improve work efficiency and quality; ensure that each employee's workload is balanced by reasonably arranging employee shifts to avoid excessive concentration of workload on a few employees; limiting employees to one shift per day can simplify scheduling management, reduce the complexity of the schedule, and improve scheduling efficiency; through reasonable shift arrangements, reduce employee dissatisfaction, and improve employee satisfaction and work enthusiasm; comply with relevant requirements of labor laws and regulations, avoid legal risks caused by overtime work, and ensure the legality and compliance of corporate operations; ensure that each employee can only have one shift per day, reduce the possibility of scheduling conflicts, and improve the operability and execution effect of the schedule; reasonably allocate employee working hours to ensure that each shift has staff arrangements and improve the utilization rate of corporate resources.

[0058] It should be noted that in the master control module, the employee availability constraint is to ensure that employees are assigned shifts only during their available time periods. In the Flights per day If it is not available in ,Employee available working hours are data obtained from employees’ contracts and historical attendance records, and the available time periods for each employee are automatically generated.

[0059] Ensure that employees are only scheduled for shifts during their actual available time periods, avoid scheduling employees during time periods when they are unable to work, and improve the rationality and operability of scheduling; ensure that employees work in the best condition, reduce inefficiency caused by unreasonable scheduling, and improve overall work efficiency; avoid scheduling employees during their rest time or other unavailable time periods, and ensure employees' rest time and physical and mental health; avoid scheduling conflicts and improve the execution effect and accuracy of the schedule by understanding the employees' available time periods in advance; let employees feel that the company attaches importance to their work time arrangements, and improve employee satisfaction and work enthusiasm; automatically generate each employee's available time period through the system, reduce the complexity and error probability of manual scheduling, and improve scheduling efficiency; avoid employees being scheduled to work during unavailable time periods, and ensure the continuity and coherence of work tasks; ensure that scheduling meets contract requirements based on the working hours agreed in the employee contract and historical attendance records, and avoid labor disputes and legal risks.

[0060] It should be noted that in the main control module, the employee The specific process of obtaining the scheduling preference score through the analysis of employees' historical preference data includes:

[0061] Step 1: Data collection: Collect employees’ historical shift arrangements, attendance, and leave records from historical shift scheduling data, and collect employees’ preference scores for each shift and their satisfaction with shift arrangements from employee feedback records. Clean and integrate the two sets of data to form a comprehensive data table containing each employee, each shift, and each date.

[0062] Step 2: Feature extraction: Calculate the attendance times and satisfaction scores of each employee in different shifts as the employee's shift preference, analyze the employee's attendance and preference in different time periods as the employee's time preference, calculate the impact of the employee's consecutive working days on the satisfaction score as the employee's consecutive working days preference, analyze the employee's rest preference for weekends and holidays as the employee's rest day preference, and use shift preference, time preference, consecutive working days preference and rest day preference as the key features that affect the employee's scheduling preference;

[0063] Step 3: Model training: Select the random forest model, use historical data for model training, adjust model parameters, and use the cross-validation method to evaluate model performance;

[0064] Step 4: Calculate preference scores: Input the current employee’s feature data into the trained model to predict their preference scores for different shifts, and normalize the preference scores so that the scores are between 0 and 1.

[0065] Step 5: Real-time update of the model: Continuously collect the latest scheduling data and employee feedback data, dynamically adjust the preference scores based on the latest scheduling data and employee feedback, regularly retrain the preference prediction model with the latest data, update the model parameters, and adjust the employee's shift preference scores based on the prediction results of the new model.

[0066] By analyzing historical data and feedback, we can accurately understand each employee's shift preferences and improve the personalization of scheduling and employee satisfaction. Using data analysis and machine learning models, we can make decisions using a large amount of historical data to make scheduling more scientific and reasonable. We can schedule shifts based on employees' actual preferences to avoid employees being assigned to shifts they don't like, thereby improving employee satisfaction and work enthusiasm. We can schedule shifts based on employees' preferences and optimal working hours to improve employee work efficiency and overall productivity. By continuously collecting and updating data, we can dynamically adjust employee preference scores to promptly adapt to changes in employee preferences and changes in company operational needs. By automating the data collection and analysis process, we can reduce the scheduling workload of managers and improve scheduling efficiency. We can schedule shifts based on data and models to avoid human bias and ensure fairness and rationality of scheduling. We can continuously optimize scheduling and improve the quality of scheduling decisions by updating models in real time and dynamically adjusting preference scores. We can meet employee preferences, improve employee satisfaction and work efficiency, and ultimately improve the overall operational performance of the enterprise.

[0067] It should be noted that in the shift scheduling optimization module, an integer linear programming model is constructed based on the defined variables, objective functions and constraints, and the integer linear programming algorithm is run to generate the optimal shift schedule. The process includes:

[0068] Step 1, calculation of employee scheduling preference scores: Calculation of employee scheduling preference scores based on steps 1 to 5;

[0069] Step 2, define variables, objective function and constraints;

[0070] Step 3, use the integer linear programming solver to solve: select the Gurobi solver, input the constructed integer linear programming model into the solver for solving, the solver performs optimization calculation according to the objective function and constraints, finds the optimal solution, and generates the optimal schedule;

[0071] Step 4, result output and verification: output the optimal schedule and verify its feasibility and effectiveness, transmit the generated schedule to the mini program through the Bluetooth function module, and store it in the storage function module;

[0072] Step 5, Adjustment and Feedback: Make adjustments and provide feedback based on actual conditions to ensure the effectiveness of the schedule, continuously monitor the execution of the schedule, collect feedback from employees and departments, and further optimize and improve the model.

[0073] By calculating the employee scheduling preference score, we can ensure that the scheduling arrangement meets the employee's preferences to the greatest extent and improve employee satisfaction. Using the integer linear programming model, we can optimize the scheduling arrangement while meeting various constraints, making resource allocation more scientific and reasonable. Reasonable scheduling can ensure that employees work in the best condition and improve work efficiency and overall productivity. By setting working time constraints and daily shift limits, we can ensure that the scheduling arrangement complies with labor laws and regulations and avoid legal risks. We can continuously monitor the execution of the schedule, adjust and optimize the schedule in real time according to feedback, and ensure that the schedule is always in the best state. Using historical data and real-time feedback to make decisions, the scheduling arrangement is more accurate and effective, and the management level of the enterprise is improved. The automated scheduling optimization and real-time adjustment mechanism reduces the complexity and workload of manual scheduling and improves management efficiency. It meets the scheduling preferences of employees, reduces dissatisfaction, improves employee satisfaction and work enthusiasm, and enhances employees' sense of identity with the enterprise. Scientific scheduling can make better use of enterprise resources, avoid resource waste, and improve resource utilization.

[0074] It should be noted that in step 5, the shift optimization module makes adjustments and feedbacks according to the actual situation to ensure the execution effect of the shift schedule. The way to continuously monitor the execution of the shift schedule is to comprehensively consider the attendance rate, production efficiency and the satisfaction score of the execution effect of the shift schedule. The weighted sum of these three is used as the execution effect score of the shift schedule. The execution effect score formula of the shift schedule is:

[0075]

[0076] Where: Score the execution effect of the schedule. For employees In the Attendance of the day, For attendance, For absence, is the total number of employees, is the total number of days in the scheduling cycle, For shift The production efficiency score is obtained from the production management records. is the total number of shifts, For employees The satisfaction score of the execution effect of the shift schedule is obtained through the employee satisfaction questionnaire. , , is a weighting factor, which is set based on company strategy and management decisions.

[0077] By examining the attendance of employees, the actual implementation effect of the shift schedule is evaluated. A high attendance rate indicates that the shift schedule is reasonable and employees are willing to work on time. By analyzing the production efficiency of each shift, the impact of the shift schedule on the completion of production tasks is evaluated. High production efficiency means that the shift schedule can effectively support production goals. Through employee feedback and satisfaction scores, the impact of the shift schedule on employees is evaluated. A high satisfaction score indicates that the shift schedule meets employee expectations and improves employee satisfaction and work enthusiasm. Combining attendance rate, production efficiency and satisfaction scores, the shift optimization module can fully understand the actual implementation effect of the shift schedule and make scientific and reasonable adjustment decisions. By comprehensively considering data from different dimensions, the shift schedule is optimized, employee attendance rate and production efficiency are improved, and ultimately the overall work efficiency of the enterprise is improved. Adjust the shift schedule based on employee feedback and satisfaction scores to meet employee needs, reduce dissatisfaction, and improve employee work enthusiasm and satisfaction. The real-time monitoring and feedback mechanism allows the shift schedule to be dynamically adjusted and continuously optimized according to actual conditions to ensure that the shift schedule is always in the best state. Through comprehensive monitoring and feedback, timely discover and solve problems in scheduling, and reduce management risks and legal risks caused by unreasonable scheduling. Comprehensively consider various indicators, optimize the schedule, improve resource utilization efficiency, and ensure that human resources and production resources are maximized. By collecting and analyzing a large amount of data, support data-driven management decisions, improve the scientificity and accuracy of decisions, and reduce subjective judgments and human errors. Optimized scheduling can improve production efficiency and employee satisfaction, reduce operating costs, and thus enhance the market competitiveness of enterprises.

[0078] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

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

Claims

1. An attendance management system for interacting with Bluetooth devices through a mini-program, characterized in that: It consists of a main control module, a scheduling optimization module, a collection function module, a display function module, a sound function module, a button function module, a storage function module, a Bluetooth function module and a mini-program. The main control module is connected to the scheduling optimization module, the collection function module, the display function module, the sound function module, the button function module, the storage function module and the Bluetooth function module. The scheduling optimization module is connected to the mini-program, and the mini-program is connected to the main control module through the Bluetooth function module. The scheduling optimization module obtains employee information, department requirements, shift settings, and legal working hours data from the mini-program, runs an integer linear programming algorithm in the main control module, generates an optimal schedule, transmits the generated schedule to the mini-program through the Bluetooth function module, and stores it in the storage function module. The main control module constructs an integer linear programming model based on the defined variables, objective functions and constraints, uses an integer linear programming solver to solve, finds the optimal solution, outputs the optimal schedule, and verifies its feasibility and effectiveness, makes adjustments and feedbacks based on actual conditions, and ensures the execution effect of the schedule. In the main control module, the objective function is the comprehensive score of maximizing employee preferences and meeting department requirements. The formula of the objective function is: Where: is the value of the objective function, is the comprehensive score of maximizing employee preferences and satisfying department needs, is a keyword that maximizes the value of the function that follows it, Index for employees, is the shift index, is the shift day index, For employees The scheduling preference score is obtained by analyzing the employee's historical preference data. For employees Is it arranged in The first shift days, obtained through employee availability and shift setting data, The actual shifts in the department The working hours required are set by the operational requirements and historical data provided by the company. For the department's planning The working hours required for each shift are set by the operation plan and historical data provided by the department. For employees In the The first shift The day's scheduling preference score, Planned work time requirements for the department Compared with the actual scheduled working hours The gap between is the weight factor used to balance and The weight between In the master control module, the constraints of the objective function include employee working hours constraints, department demand constraints, daily shift limits, and employee availability constraints; In the main control module, the employee working hours constraint is to ensure that the total working hours of each employee are within the legal range. The expression of the employee working hours constraint is: Where: , The minimum and maximum working hours are respectively stipulated by law for any employee. All are satisfied; In the master control module, department demand constraints are set to ensure that the working hours requirements of each department are met. Total working hours No less than department Working hours required , the expression of department demand constraint is: The above formula is satisfied for any department. The department demand data is obtained from the department's operation plan and historical data, input by the department manager or automatically calculated; In the master control module, the daily shift limit is to ensure that each employee is scheduled for at most one shift per day. The expression for the daily shift limit is: The above formula is for employees In the Only one shift can be arranged per day ,The shift setting data is set according to the company's operational needs and historical data, and is provided by the scheduling optimization module.

2. According to claim 1, an attendance management system for interacting with Bluetooth devices through a mini-program is characterized in that: In the master control module, employee availability constraints are set to ensure that employees are assigned shifts only during their available time periods. In the Flights per day If it is not available in ,employee available working time data is obtained from the employee’s contract and historical attendance records, and the available time period for each employee is automatically generated.

3. According to claim 1, an attendance management system for interacting with Bluetooth devices through a mini-program is characterized in that: In the main control module, the employee in the objective function The specific process of obtaining the scheduling preference score through the analysis of employees' historical preference data includes: Step 1: Data collection: Collect employees’ historical shift arrangements, attendance, and leave records from historical shift scheduling data, and collect employees’ preference scores for each shift and their satisfaction with shift arrangements from employee feedback records. Clean and integrate the two sets of data to form a comprehensive data table containing each employee, each shift, and each date. Step 2, feature extraction: calculate the attendance times and satisfaction scores of each employee in different shifts as the employee's shift preference, analyze the employee's attendance and preference in different time periods as the employee's time preference, calculate the impact of the employee's consecutive working days on the satisfaction score as the employee's consecutive working days preference, analyze the employee's rest preference for weekends and holidays as the employee's rest day preference, and use shift preference, time preference, consecutive working days preference and rest day preference as the key features that affect the employee's scheduling preference; Step 3: Model training: Select the random forest model, use historical data for model training, adjust model parameters, and use the cross-validation method to evaluate model performance; Step 4: Calculate preference scores: Input the current employee’s feature data into the trained model to predict their preference scores for different shifts, and normalize the preference scores so that the scores are between 0 and 1. Step 5: Real-time update of the model: Continuously collect the latest scheduling data and employee feedback data, dynamically adjust the preference scores based on the latest scheduling data and employee feedback, regularly retrain the preference prediction model with the latest data, update the model parameters, and adjust the employee's shift preference scores based on the prediction results of the new model.

4. According to claim 3, an attendance management system for interacting with Bluetooth devices through a mini-program is characterized in that: In the shift scheduling optimization module, an integer linear programming model is constructed based on the defined variables, objective functions, and constraints, and the integer linear programming algorithm is run to generate the optimal shift schedule. The process includes: Step 1, calculation of employee scheduling preference scores: Calculation of employee scheduling preference scores based on steps 1 to 5; Step 2, define variables, objective function and constraints; Step 3, use the integer linear programming solver to solve: select the Gurobi solver, input the constructed integer linear programming model into the solver for solving, the solver performs optimization calculation according to the objective function and constraints, finds the optimal solution, and generates the optimal schedule; Step 4, result output and verification: output the optimal schedule and verify its feasibility and effectiveness, transmit the generated schedule to the mini program through the Bluetooth function module, and store it in the storage function module; Step 5, Adjustment and Feedback: Make adjustments and provide feedback based on actual conditions to ensure the effectiveness of the schedule, continuously monitor the execution of the schedule, collect feedback from employees and departments, and further optimize and improve the model.

5. The attendance management system for interacting with Bluetooth devices through a mini-program according to claim 4, characterized in that: In step 5, the shift optimization module makes adjustments and provides feedback based on the actual situation to ensure the execution effect of the shift schedule. The way to continuously monitor the execution of the shift schedule is to comprehensively consider the attendance rate, production efficiency and the satisfaction score of the execution effect of the shift schedule. The weighted sum of these three is used as the execution effect score of the shift schedule. The execution effect score formula of the shift schedule is: Where: Score the execution effect of the shift schedule. For employees In the Attendance of the day, For attendance, For absence, is the total number of employees, is the total number of days in the scheduling cycle, For shift The production efficiency score is obtained from the production management records. is the total number of shifts, For employees The satisfaction score of the execution effect of the shift schedule is obtained through the employee satisfaction questionnaire. , , is a weighting factor, which is set based on company strategy and management decisions.

6. The attendance management system for interacting with Bluetooth devices through a mini-program according to claim 1, characterized in that: The collection function module is used to collect employees' biometric data and IC card data, the display function module is used to display interface content and perform human-computer interaction, the sound function module is used to output sound prompts for verification and comparison results, the button function module is used to implement the operation function of the device, the storage function module is used to store biometric data and successful records of daily comparisons, the Bluetooth function module is used to realize the communication connection between the device and the mini program, and the mini program is used to realize the functions of user management, department management, shift equipment, scheduling settings, attendance settings, equipment settings, password management, and report management.

Images