Test personnel information management statistical method and system
By designing the experimental personnel information management statistics system, the problems of incomplete, inaccurate and in real-time data in traditional management methods are solved, real-time management and efficient statistics of experimental personnel information are realized, and it is suitable for large-scale experimental projects.
Patent Information
- Application Number
- CN202411122555.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-15
- Publication Date
- 2024-11-19
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
The traditional information management method of test personnel has problems such as incomplete, inaccurate and unreal-time data, and the operator is not friendly, making it difficult to meet the information management needs of large-scale experimental projects.
A statistical method and system for the management of personnel information was designed, including establishing a login account information database, basic information database, disclaimer information database, duty information database and in-situ information database, and through the personnel information management module and multiple attendance terminals and User terminal connection, real-time information query and update, and supports classified statistics and data display.
It realizes complete, accurate and real-time management of test personnel information, improves the efficiency of information management statistics, supports the information management of test projects with a capacity of more than 1,000 people, simplifies the operation process and improves the data processing speed.
Smart Images

Figure CN118982331A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of information management, and more specifically, to a method and system for managing and counting information of test personnel. Background Art
[0002] For test tasks involving hundreds of thousands of people, due to the complicated test work process, long cycle span, and numerous coordination units, the single manual or paper management during the task can no longer meet the information management needs of test personnel. Therefore, it is necessary to use computer systems to effectively manage the information of various test personnel during the test.
[0003] According to the management needs of the test process, the information of test personnel can be divided into basic personal information, on-site information, on-duty information, and leave information. The traditional method of manual statistical update is difficult to achieve complete, accurate, and real-time information statistics and management. The existing information management and statistical methods based on databases or tables have the following problems: operators are required to enter and change a large amount of information on the same terminal, the management and statistical interface is not operator-friendly, and it is very easy to cause data distortion due to misoperation. Summary of the invention
[0004] The purpose of the present invention is to provide a method and system for managing and statistically analyzing the information of experimental personnel, which can not only meet the requirements of complete and accurate entry and modification of experimental personnel information, but also perform real-time information query and update on a simple and friendly web system interface for operators, thereby improving the statistical ability level of experimental personnel information management and supporting personnel information management for experimental projects with more than 100 people.
[0005] In order to achieve the purpose and other advantages of the present invention, a method for managing and statistically analyzing information of test personnel is provided, comprising: Establish a login account information database, a basic information database, a leave information database, a duty information database, and an on-duty information database; Establishing a personnel information management module associated with the login account information database, the basic information database, the leave information database, the duty information database and the presence information database; Establishing a plurality of attendance terminals associated with the personnel information management module, wherein the plurality of attendance terminals are used to obtain the attendance data of the test personnel and send the data to the personnel information management module; Establish multiple user terminals associated with the personnel information management module, the multiple user terminals are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module, receive the data returned by the personnel information management module and display it; wherein, The personnel information management module is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-the-job information database, and classify, count and display the leave information, duty information and on-the-job information of the test personnel according to the obtained login information and query instructions.
[0006] Preferably, the login account information database is used to store the login account of the test personnel, including the user name, password and user level code, and the personnel information management module allocates corresponding operation permissions to the login user according to the user level code.
[0007] Preferably, the basic information database is used to store basic information of test personnel, including basic personal information, technical ability information, work experience information, family information, and contact information.
[0008] Preferably, the leave request and cancellation information database is used to store the leave request and cancellation information of the test personnel, including the person requesting leave, the unit to which he belongs, the leave time, the expected return time, the departure time, the return time, the leave type, the destination, the leave cancellation time, the remarks, whether to cancel the leave and the leave cancellation operation.
[0009] Preferably, the duty information database is used to store the duty information of the test personnel, including the duty personnel, duty units and duty dates.
[0010] Preferably, the on-site information database is used to store the on-site information of the test personnel, including the unit name, total number of people, number of people on duty, number of people on family leave, number of people on business trips, number of people on study and training, number of people on sick leave, number of people on personal leave, number of people temporarily away and other number of people.
[0011] Preferably, when calculating leave information, the number of days of leave taken needs to be deducted from the national statutory holidays of the year. The calculation method is as follows: S1. Create an array of vacation days for each tester a
[12] Each data in the array represents a month, and the data type of the array is a 31-bit binary unsigned integer, that is, the size range of each number in the array is (0, 2 31 -1), the default is 0, that is, all 31 bits are 0; S2, extract the leave time period of each test personnel, and update the corresponding binary number in the array according to the leave time of each month, that is, i moon j Days of absence, 1≤ i ≤12 、1 ≤ j ≤31, then the first i Elementsa [ i ] j The 0th bit is updated to 1, and a new array containing the leave information of each test personnel in the current year is obtained. a’
[12] ; S3, refer to step S1, establish an array a
[12] An array of national statutory holidays records of the same type b
[12] ; Refer to step S2, and arrange the update group according to the national statutory holidays b
[12] , get a new array containing the national statutory holidays information for the current year b’
[12] ; S4. Put two arrays a’
[12] b’
[12] After performing a bitwise AND operation on the 12 binary numbers contained in each of them, the number of 1s in all the binary numbers in the statistical result is the number of days that should be deducted from the test personnel’s vacation days for the year, including national statutory holidays; .
[0012] Preferably, the classification statistics include statistics according to test personnel, unit, year, month, day, and reason for leave.
[0013] Preferably, the multiple user terminals include mobile phones, tablets and computers, and the multiple user terminals acquire information based on web page operations.
[0014] The present invention also provides a test personnel information management and statistical system, comprising: The database module includes a login account information database, a basic information database, a leave information database, a duty information database, and an on-duty information database; A personnel information management module, which is connected to the database module, and is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-site information database, and classify, count and display the leave information, duty information and on-site information of the test personnel according to the obtained login information and query instructions; A plurality of attendance terminals connected to the personnel information management module, the plurality of attendance terminals being used to obtain the attendance data of the test personnel and send the data to the personnel information management module; Multiple user terminals are connected to the personnel information management module. The multiple user terminals are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module, and receive and display the data returned by the personnel information management module.
[0015] The present invention has at least the following beneficial effects: First, the experimental personnel information management and statistical method and system of the present invention solve the problems of incomplete, inaccurate and non-real-time data in experimental personnel information management and statistics in large-scale experimental projects, as well as the problems that traditional paper or electronic spreadsheets are operator-unfriendly and do not support multi-user data entry. At present, the system has been maturely and reliably applied to personnel information management and statistical work in experimental projects with more than 100 people, and can provide complete, accurate and real-time information management services. Its data capacity can support the information management of at least 1,000 experimental personnel, greatly improving the efficiency of information management and statistical work.
[0016] Second, the present invention provides a method for calculating the number of days to be deducted from vacation days. Compared with the traditional day matching statistical algorithm, this calculation method abstractly maps all the days of the 12 months of a year into an array, with concise expression, clear mapping definition, and convenient data update. In the matching operation of the vacation array and the statutory holiday array, there is no need for cyclic judgment, and the matching can be quickly completed directly using computer binary operations; when the number of people is n, the traditional algorithm needs to loop at least 365n times, and the algorithm only needs to execute n binary bitwise AND operations and count the number of 1s in the n binary numbers. The number of cyclic calculations of the latter is positively correlated with the number of 1s in the binary number, so the number of calculations is much less than 365n times.
[0017] Other advantages, objectives and features of the present invention will be embodied in part through the following description, and in part will be understood by those skilled in the art through study and practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS
[0018] Figure 1 It is a structural block diagram of a test personnel information management and statistics system according to an embodiment of the present invention. DETAILED DESCRIPTION
[0019] The present invention is further described in detail below in conjunction with embodiments and drawings so that those skilled in the art can implement the invention with reference to the description.
[0020] It should be understood that the terms such as “having”, “including” and “comprising” used herein do not exclude the existence or addition of one or more other elements or combinations thereof.
[0021] It should be noted that the experimental methods described in the following embodiments are conventional methods unless otherwise specified, and the reagents and materials can be obtained from commercial channels unless otherwise specified.
[0022] The present invention provides a method for managing and statistically analyzing information of test personnel, comprising: Establish a login account information database, basic information database, leave information database, duty information database and on-duty information database.
[0023] Among them, the login account information database is used to store the login account of the test personnel, including the user name, password and user level code, and the personnel information management module assigns corresponding operation permissions to the login user according to the user level code; illustratively, the user level code can be set to ordinary test personnel, test personnel in charge of each unit and test personnel in charge of the project. Ordinary test personnel have the authority to query personal basic information, leave information, duty information, in-place information and apply / change personal leave applications. The test personnel in charge of each unit have the authority to query the personal basic information, leave information, duty information, in-place information of all test personnel in the unit they manage, and operate the leave application of all test personnel in the unit they manage. The test personnel in charge of the project have the authority to query the personal basic information, leave information, duty information, in-place information of all test personnel in the project, and operate the leave application of all test personnel in the project. The basic information database is used to store the basic information of the test personnel, including personal basic information, technical ability information, work experience information, family information, and contact information. The leave request and cancellation information database is used to store the leave request and cancellation information of the test personnel, including the person who requested leave, the unit to which he belongs, the leave time, the expected return time, the departure time, the return time, the leave type, the destination, the leave cancellation time, the remarks, whether to cancel the leave and the leave cancellation operation. The duty information database is used to store the duty information of the test personnel, including the duty personnel, the duty unit and the duty date. The presence information database is used to store the presence information of the test personnel, including the unit name, the total number of people, the number of people in place, the number of people on family leave, the number of people on business trips, the number of people on training, the number of people on sick leave, the number of people on personal leave, the number of people temporarily out and other numbers.
[0024] A personnel information management module is established which is associated with the login account information database, the basic information database, the leave information database, the duty information database and the presence information database.
[0025] Among them, the personnel information management module is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-the-job information database, and classify, count and display the leave information, on-duty information and on-the-job information of the test personnel according to the obtained login information and query instructions.
[0026] A plurality of attendance terminals associated with the personnel information management module are established, and the plurality of attendance terminals are used to obtain the attendance data of the test personnel and send the data to the personnel information management module.
[0027] Among them, the multiple attendance terminals include fingerprint attendance machines, face recognition attendance machines, and mobile phones with built-in mobile phone positioning attendance (such as DingTalk, Enterprise WeChat).
[0028] Establish multiple user terminals associated with the personnel information management module, and the multiple user terminals are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module, receive the data returned by the personnel information management module and display it.
[0029] Among them, the multiple user terminals include mobile phones, tablets and computers, and the multiple user terminals acquire information based on web page operations.
[0030] Exemplarily, a display interface is set up that is linked to the basic information database, the duty information database, and the on-site information database, and a display interface and corresponding editing entrance are set up respectively for viewing the information of all or part of the test personnel, adding duty information, and querying the duty status of the test personnel of each unit, as well as the on-site status of the test personnel. By default, the personal basic information of the login account, the duty information of all test personnel, and the on-site information of the test personnel on that day are displayed; the specific method is as follows: link the database to the system editing interface, convert the edited information into a database update command, and input the data into the database; when querying information, convert the corresponding time date and the information of the person or unit being queried into the corresponding database query command through the query entrance, and return the data list to be displayed on the query interface. Set up a leave application interface linked to the leave application information database, provide a leave application entrance, including the applicant, the unit to which he belongs, the date of leaving the team, the date of returning to the team, the reason for the leave, the destination and remarks, provide a leave application query and change interface, set support for information query based on year, the unit or individual being queried, one by one or statistically, and realize the statistics of the number of times, days and time periods of each type of leave, and display the statistical information of individual leave application one by one in the current year by default. The specific method is as follows: link the database to the leave application webpage, convert the leave application entry into a database update command, and input the data into the database; when querying leave information one by one, convert the query entry into the corresponding database query command, and return the data list to be displayed on the leave query interface; when statistically querying leave information, first extract all leave information that meets the requirements, and count the number of leave types and add up the number of leave days according to the corresponding statistical categories.
[0031] Furthermore, when calculating the leave information, the number of days of leave needs to be deducted from the national statutory holidays of the year. The calculation method is as follows: S1. Create a leave day record array for each tester. a
[12] Each data in the array represents a month, and the data type of the array is a 31-bit binary unsigned integer, that is, the size range of each number in the array is (0, 2 31-1), the default is 0, that is, all 31 bits are 0; S2, extract the leave time period of each tester, and update the corresponding binary number in the array according to the leave time of each month, that is, i moon j Days of absence, 1≤ i ≤12 、1 ≤ j ≤31, then the first i Elements a [ i ] j The 0th bit is updated to 1, and a new array containing the leave information of each test personnel in the current year is obtained. a’
[12] ; S3, refer to step S1, establish an array a
[12] An array of national statutory holidays records of the same type b
[12] ; Refer to step S2, and arrange the update group according to the national statutory holidays b
[12] , get a new array containing the national statutory holidays information for the current year b’
[12] ; S4, two arrays a’
[12] b’
[12] After performing a bitwise AND operation on the 12 binary numbers contained in each of them, the number of 1s in all the binary numbers in the statistical result is the number of days that should be deducted from the test personnel’s vacation days for the year, including national statutory holidays. .
[0032] like Figure 1 As shown, the present invention also provides a test personnel information management and statistics system, which is implemented by using MySQL database language and web page PHP code programming, including: The database module 1 includes a login account information database, a basic information database, a leave information database, a duty information database and an on-duty information database.
[0033] Among them, the login account information database is used to store the login account of the test personnel, including the user name, password and user level code, and the personnel information management module assigns corresponding operation permissions to the login user according to the user level code; illustratively, the user level code can be set to ordinary test personnel, test personnel in charge of each unit and test personnel in charge of the project. Ordinary test personnel have the authority to query personal basic information, leave information, duty information, in-place information and apply / change personal leave applications. The test personnel in charge of each unit have the authority to query the personal basic information, leave information, duty information, in-place information of all test personnel in the unit they manage, and operate the leave application of all test personnel in the unit they manage. The test personnel in charge of the project have the authority to query the personal basic information, leave information, duty information, in-place information of all test personnel in the project, and operate the leave application of all test personnel in the project. The basic information database is used to store the basic information of the test personnel, including personal basic information, technical ability information, work experience information, family information, and contact information. The leave request and cancellation information database is used to store the leave request and cancellation information of the test personnel, including the person who requested leave, the unit to which he belongs, the leave time, the expected return time, the departure time, the return time, the leave type, the destination, the leave cancellation time, the remarks, whether to cancel the leave and the leave cancellation operation. The duty information database is used to store the duty information of the test personnel, including the duty personnel, the duty unit and the duty date. The presence information database is used to store the presence information of the test personnel, including the unit name, the total number of people, the number of people in place, the number of people on family leave, the number of people on business trips, the number of people on training, the number of people on sick leave, the number of people on personal leave, the number of people temporarily out and other numbers.
[0034] The personnel information management module 2 is connected to the database module 1, and is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-the-job information database, and classify, count and display the leave information, duty information and on-the-job information of the test personnel according to the obtained login information and query instructions.
[0035] Multiple attendance terminals 3 are connected to the personnel information management module 2, and the multiple attendance terminals 3 are used to obtain the attendance data of the test personnel and send it to the personnel information management module 2; wherein the multiple attendance terminals include fingerprint attendance machines, face recognition attendance machines, and mobile phones with built-in mobile phone positioning attendance (such as DingTalk, Enterprise WeChat).
[0036] Multiple user terminals 4 are connected to the personnel information management module 2. The multiple user terminals 4 are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module 2, receive the data returned by the personnel information management module 2 and display it; wherein the multiple user terminals include mobile phones, tablets and computers, and the multiple user terminals realize information acquisition based on web page operations.
[0037] Exemplarily, a display interface is set up that is linked to the basic information database, the duty information database, and the on-site information database, and a display interface and corresponding editing entrance are set up respectively for viewing the information of all or part of the test personnel, adding duty information, and querying the duty status of the test personnel of each unit, as well as the on-site status of the test personnel. By default, the personal basic information of the login account, the duty information of all test personnel, and the on-site information of the test personnel on that day are displayed; the specific method is as follows: link the database to the system editing interface, convert the edited information into a database update command, and input the data into the database; when querying information, convert the corresponding time date and the information of the person or unit being queried into the corresponding database query command through the query entrance, and return the data list to be displayed on the query interface. Set up a leave application interface linked to the leave application information database, provide a leave application entrance, including the applicant, the unit to which he belongs, the date of leaving the team, the date of returning to the team, the reason for the leave, the destination and remarks, provide a leave application query and change interface, set support for information query based on year, the unit or individual being queried, one by one or statistically, and realize the statistics of the number of times, days and time periods of each type of leave, and display the statistical information of individual leave application one by one in the current year by default. The specific method is as follows: link the database to the leave application webpage, convert the leave application entry into a database update command, and input the data into the database; when querying leave information one by one, convert the query entry into the corresponding database query command, and return the data list to be displayed on the leave query interface; when statistically querying leave information, first extract all leave information that meets the requirements, and count the number of leave types and add up the number of leave days according to the corresponding statistical categories.
[0038] Furthermore, when calculating the leave information, the number of days of leave needs to be deducted from the national statutory holidays of the year. The calculation method is as follows: S1. Create a leave day record array for each tester. a
[12] Each data in the array represents a month, and the data type of the array is a 31-bit binary unsigned integer, that is, the size range of each number in the array is (0, 2 31 -1), the default is 0, that is, all 31 bits are 0; S2, extract the leave time period of each tester, and update the corresponding binary number in the array according to the leave time of each month, that is, i moon j Days of absence, 1≤ i≤12 、1 ≤ j ≤31, then the first i Elements a [ i ] j The 0th bit is updated to 1, and a new array containing the leave information of each test personnel in the current year is obtained. a’
[12] ; S3, refer to step S1, establish an array a
[12] An array of national statutory holidays records of the same type b
[12] ; Refer to step S2, and arrange the update group according to the national statutory holidays b
[12] , get a new array containing the national statutory holidays information for the current year b’
[12] ; S4, two arrays a’
[12] b’
[12] After performing a bitwise AND operation on the 12 binary numbers contained in each of them, the number of 1s in all the binary numbers in the statistical result is the number of days that should be deducted from the test personnel’s vacation days for the year, including national statutory holidays. .
[0039] The number of devices and processing scales described here are used to simplify the description of the present invention. The application, modification and variation of the statistical method and system for managing test personnel information of the present invention are obvious to those skilled in the art.
[0040] Although the embodiments of the present invention have been disclosed as above, they are not limited to the applications listed in the specification and the implementation modes, and they can be fully applied to various fields suitable for the present invention. For those familiar with the art, additional modifications can be easily implemented. Therefore, without departing from the general concept defined by the claims and the scope of equivalents, the present invention is not limited to the specific details and the illustrations shown and described herein.
Claims
1. A method for statistical management of test personnel information, characterized in that: include: Establish a login account information database, a basic information database, a leave information database, a duty information database, and an on-duty information database; Establishing a personnel information management module associated with the login account information database, the basic information database, the leave information database, the duty information database and the presence information database; Establishing a plurality of attendance terminals associated with the personnel information management module, wherein the plurality of attendance terminals are used to obtain the attendance data of the test personnel and send the data to the personnel information management module; Establish multiple user terminals associated with the personnel information management module, the multiple user terminals are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module, receive the data returned by the personnel information management module and display it; wherein, The personnel information management module is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-the-job information database, and classify, count and display the leave information, duty information and on-the-job information of the test personnel according to the obtained login information and query instructions.
2. A method for managing and counting test personnel information according to claim 1, characterized in that: The login account information database is used to store the login account of the test personnel, including the user name, password and user level code. The personnel information management module allocates corresponding operation permissions to the login user according to the user level code.
3. A method for managing and counting test personnel information according to claim 1, characterized in that: The basic information database is used to store the basic information of the test personnel, including basic personal information, technical ability information, work experience information, family information, and contact information.
4. A method for managing and counting test personnel information according to claim 1, characterized in that: The leave request and cancellation information database is used to store the leave request and cancellation information of the test personnel, including the person requesting leave, the unit to which he belongs, the leave time, the expected return time, the departure time, the return time, the leave type, the destination, the leave cancellation time, the remarks, whether to cancel the leave and the leave cancellation operation.
5. A method for managing and counting test personnel information according to claim 1, characterized in that: The duty information database is used to store the duty information of the test personnel, including the duty personnel, duty units and duty dates.
6. A method for managing and counting test personnel information according to claim 1, characterized in that: The on-the-job information database is used to store the on-the-job information of the test personnel, including the unit name, total number of people, number of people on duty, number of people on family visit leave, number of people on business trips, number of people on study and training, number of people on sick leave, number of people on personal leave, number of people temporarily away and other number of people.
7. A method for managing and counting test personnel information according to claim 1, characterized in that: When calculating leave information, the number of days of leave taken needs to be deducted from the national statutory holidays of the year. The calculation method is as follows: S1. Create an array of vacation days for each tester a [12] Each data in the array represents a month, and the data type of the array is a 31-bit binary unsigned integer, that is, the size range of each number in the array is (0, 2 31 -1), the default is 0, that is, all 31 bits are 0; S2, extract the leave time period of each test personnel, and update the corresponding binary number in the array according to the leave time of each month, that is, i moon j Days of absence, 1≤ i ≤12 、1 ≤ j ≤31, then the first i Elements a [ i ] j The 0th bit is updated to 1, and a new array containing the leave information of each test personnel in the current year is obtained. a’ [12]; S3, refer to step S1, establish an array a [12] An array of national statutory holidays records of the same type b [12]; Refer to step S2, and arrange the update group according to the national statutory holidays b [12], get a new array containing the national statutory holidays information for the current year b’ [12]; S4. Put two arrays a’ [12] b’ [12] After performing a bitwise AND operation on the 12 binary numbers contained in each of them, the number of 1s in all the binary numbers in the statistical result is the number of days that should be deducted from the test personnel’s vacation days for the year, including national statutory holidays; 。 8. A method for managing and counting test personnel information according to claim 1, characterized in that: The classification statistics include statistics based on test personnel, units, years, months, days, and reasons for leave.
9. A method for managing and counting test personnel information according to claim 1, characterized in that: The multiple user terminals include mobile phones, tablets and computers, and the multiple user terminals acquire information based on web page operations.
10. A test personnel information management and statistical system, characterized in that: include: The database module includes a login account information database, a basic information database, a leave information database, a duty information database, and an on-duty information database; A personnel information management module, which is connected to the database module, and is used to obtain the registration, attendance, duty and leave information of the test personnel, update the login account information database, basic information database, leave information database, duty information database and on-site information database, and classify, count and display the leave information, duty information and on-site information of the test personnel according to the obtained login information and query instructions; A plurality of attendance terminals connected to the personnel information management module, the attendance terminals are used to obtain the attendance data of the test personnel and send it to the personnel information management module; Multiple user terminals are connected to the personnel information management module. The user terminals are used to obtain the registration, login, duty, leave and query information of the test personnel and send it to the personnel information management module, and receive and display the data returned by the personnel information management module.
Citation Information
Patent Citations
Military staff leave and resumption from leave management system based on cloud platform
CN108537496A
Attendance management system and method, and electronic device
CN109741477A
Method for intelligently generating, filling and verifying annual false plans of civil employees
CN115392857A
Asking-for-leave management system and related products
CN118379037A
