CN111275844B

CN111275844B - Classroom real-time attendance system and attendance method based on programmable wireless routing

Info

Publication number: CN111275844B
Application number: CN202010191472.5A
Authority: CN
Inventors: 敖欣; 杨宇泽; 谢森炯; 萧丁山; 施雨帆; 王双武
Original assignee: Dongguan University of Technology
Current assignee: Dongguan University of Technology
Priority date: 2020-03-18
Filing date: 2020-03-18
Publication date: 2022-05-31
Anticipated expiration: 2040-03-18
Also published as: CN111275844A

Abstract

The invention discloses a programmable wireless routing-based classroom real-time attendance system and an attendance method, wherein the attendance system comprises a client, a router and a server, the client is arranged at a handheld terminal of a student and is used for showing various interfaces for a user and enabling the user to realize functions required by the user; the router transmits the processed information, the MAC address and the timestamp to the server; the server is used for processing card punching data of the client, requesting a user to perform fingerprint verification at irregular time and processing a query request of the client. The attendance system and the attendance method utilize a fingerprint identification technology to carry out attendance management in combination with the mobile phone MAC address, can uniquely determine the card punching attendance of students at a designated place at a designated time by using the own fingerprint of the mobile phone, and have high card punching attendance accuracy and simple and convenient operation.

Description

Programmable wireless routing-based real-time class attendance system and attendance method

Technical Field

The invention relates to the technical field of education internet of things, in particular to a programmable wireless routing-based real-time class attendance system and method.

Background

At present, although the class attendance checking modes of colleges and universities are different in autumn, the class attendance checking modes are still not optimistic. The traditional manual attendance checking mode is low in efficiency and cannot well guarantee accuracy. The conditions that students are late to leave early or go to class midway are difficult to control.

At present, no good and humanized class real-time attendance platform is available on the market. Customization and full automation cannot be achieved. Some traditional fingerprint punched-card machine attendance modes are unfavorable for mr's attendance work and can lead to the student to experience not good.

Patent application CN107492154A discloses a classroom attendance system and working method thereof, and the system includes mobile terminal and classroom attendance system server to and install the APP application on mobile terminal, the APP application includes business turn over detection module, the student is from the module of registering. The method comprises the steps that an intelligent Android device is used for sending a detection request frame containing a physical address at regular time, a wireless router in a classroom judges the identity of a student after receiving the request frame, and the in-out time of the student is recorded. In addition, the student still needs to select the position of oneself in the classroom through student's end APP, and the server can be through the camera in the classroom to every student's position and shoot at a fixed point, and all pictures all are as the basis of secondary attendance, stop the emergence of attendance cheating action.

However, the above attendance checking method has the following disadvantages:

1. although it has been indicated in this patent that the detection request frame in the IEEE 802.11 protocol with its own MAC address is periodically broadcast in the APP to determine the location of the classroom in which the student is located, no relatively specific implementation is given.

2. The teachings of this patent are directed to selecting locations to locate for students in the class and periodically saving images in the classroom via the classroom camera. The student attendance checking system is used as an attendance checking basis, and can perform attendance checking scoring on students in the later period through face recognition so as to ensure that the students are really in a classroom. The method has the following 3 defects:

1) the student needs to select the self-determined seat after entering the classroom, on one hand, the operation that the student drags the selection frame and adjusts the selection frame to the self-located position in the classroom picture through moving, amplifying and reducing is a more complicated operation for the student and is not easily accepted by the student;

2) the classroom attendance system server stores the images of the designated coordinates in the classroom every 10 minutes to serve as attendance bases, and students can be scored for attendance at the later stage through face recognition to ensure that the students are really in the classroom. According to actual measurement research, the feasibility of an attendance checking mode based on a camera in a classroom is very low. Even if the resolution of the camera is high, it is difficult to recognize every classmate from the image. Even if the face of the student can not be captured at all when the student writes with a head down, the attendance checking method can not be implemented, and the accuracy is greatly reduced;

3) the patent does not give a relatively specific secondary attendance strategy.

Therefore, no attendance system capable of dynamically managing the card punching condition according to the student class schedule is available in the market. In addition, the data accuracy of the attendance system on the market is not very high, the phenomenon of printing the attendance is still very serious, or the attendance system is inconvenient because the attendance system needs to hold a card printer at any time to go to class.

Disclosure of Invention

In order to solve the problems, the invention provides a programmable wireless routing-based classroom real-time attendance system and an attendance method, the attendance system and the attendance method utilize a fingerprint identification technology to combine with a mobile phone MAC address to carry out attendance management, can uniquely determine the attendance of a student on a designated place at a designated time by using the fingerprint of the student, and have high accuracy of the attendance of the student on the card, and are simple and convenient to operate.

The invention also aims to provide a classroom real-time attendance system and an attendance method based on the programmable wireless router, wherein the attendance system and the attendance method can judge that the user is always in the specified classroom range through the data packet sent to the server in real time by the programmable wireless router, and can carry out classroom real-time attendance.

In order to realize the purpose, the technical scheme of the invention is as follows:

a classroom real-time attendance system based on programmable wireless routing, which comprises a client, a router and a server,

the client is arranged at a handheld terminal of a student and used for displaying various interfaces for users and enabling the users to realize functions required by the users, such as card punching or card punching condition inquiry and the like;

the router is used for processing a Probe Request detection frame in an IEEE 802.11 protocol and transmitting the processed information, the MAC address and the timestamp to the server; specifically, the MAC address of the mobile device, the MAC address of the router itself, and the timestamp;

the server is used for processing the card punching data of the client, requesting the user to perform fingerprint verification at irregular time and processing the query request of the client.

Further, the client includes, but is not limited to, a mobile phone, a PDA, a PAD, and a tablet.

Further, the client comprises a login module, a card punching module, a record query module and a management/tool module,

the router is provided with a data processing module which receives and sends data of the client and the server, so that the data processing module is divided into two sub-modules of data processing and data sending.

The server is provided with a login processing module, a card punching processing module and an information processing module, wherein the login processing module comprises a data verification submodule, the card punching processing module also comprises a data verification submodule, and the information processing module comprises an information receiving module, an information sending module, an information storage module and an information modification module. When the client logs in, the data verification sub-module of the log-in processing module verifies the user information, and after attendance is finished, when the user punches the card and signs off, the data verification sub-module of the card punching processing module also verifies the user information, so that the attendance accuracy is ensured.

The server comprises the functions of importing a school timetable into a school database, verifying user information, processing router sending data, processing card punching data, judging whether leaving a classroom or not, randomly sending card punching requests, counting card punching data, modifying user card punching data, modifying timetable information, accessing events to be handled and managing notification information.

A real-time class attendance method based on programmable wireless routing comprises the following steps:

101. the student user turns on the mobile device WiFi switch (without connecting any WiFi) after entering a designated classroom at a designated time;

102. a client logs in a designated APP through a learning number and a password, and performs fingerprint verification, card punching and sign-in; the WiFi switch is always kept in an open state during the class;

103. after class, the client opens the APP and performs fingerprint card-punching sign-off.

In the step 102, when the user performs fingerprint verification, a fid is returned, the router stores the processed data in the server in real time, the server stores the processed data in the database, and then a step is performed in a verification stage when the user requests to punch the card, wherein the step is to verify the card punching position, and at this time, the server performs information matching by inquiring whether the record stored in the database by the router is matched with the correct card punching position. And after the matching is successful, the card punching information is stored in the attendance sheet, otherwise, the card punching fails, and prompt information is returned.

Further, after the user at the client logs in the system, the server matches the MAC of the card punching device prestored in the database according to the study number of the student (common student and class manager) user, obtains the location information of the user, which is required to be on class in the time period, through WiFi, and performs user authentication according to the MAC of the user card punching device, the login time and the data sent to the server by the router. And if the matched items exist, the user is not allowed to punch the card through the client, and corresponding error information is prompted.

Further, the router screens out the MAC address in the Probe Request Probe frame in the captured IEEE 802.11 protocol, and the implementation flow is as follows:

1021. finding WiFi-driven source codes in openwrt source codes, processing all received WiFi data packets by an __ ieee80211_ rx _ handle _ packet function, adding codes for processing Probe Request detection frames, and finishing data collection;

1022. storing the collected user MAC address data in a global variable and transmitting the data to a user space in a Generic Netlink mode;

1023. and the router shell script sends the obtained user MAC address, the router MAC address and the timestamp to the server.

Furthermore, after the user performs fingerprint verification card punching, the server obtains all non-repetitive MAC addresses in the time by comparing the data sent by the router corresponding to the user card punching time and the card punching time (data in plus or minus 2 seconds are used for preventing errors), and matches the MAC addresses carried by the user card punching, if the matching is successful, the user is proved to be in a designated classroom. And then, comparing fid and school number generated by card punching with information prestored in a database, and if the fid and school number are consistent, proving that the card punching of the same school is successful.

The invention has the beneficial effects that:

1. and acquiring a Probe Request Probe Request frame in an IEEE 802.11 protocol through a router, and synchronizing the MAC address of the client in the Probe Request Probe Request frame to a server in real time. The functions of judging whether the user login place is correct, judging whether the user card punching place is correct, judging whether the user is in a classroom all the time and the like can be realized in an auxiliary mode.

2. The fingerprint identification technology is combined with the mobile phone MAC address, so that the card punching attendance of students at the appointed place at the appointed time by using the own fingerprint of the mobile phone can be uniquely determined, the card punching accuracy is extremely high, and the operation is relatively convenient.

3. In order to prevent students from escaping from classes after the students punch cards, the situation that the users are always within the specified classroom range is judged through the data packets sent to the server in real time through the programmable wireless router, and the purpose of a classroom real-time attendance platform is reflected.

4. The situation that students walk out by themselves after putting mobile phones in classrooms by punching cards is reduced. By adopting an MQTT message pushing mechanism, the server pushes the card punching prompt message to a random user (preferentially extracting students with bad records) client at irregular time, so that the possibility of the students escaping is further reduced, and the attendance efficiency is greatly improved.

Drawings

Fig. 1 is a logical architecture diagram of an attendance system implemented by the present invention.

Fig. 2 is a functional architecture diagram of an attendance system implemented by the present invention.

FIG. 3 is a flow chart of attendance card punching implemented by the invention.

Fig. 4 is a schematic view of attendance time management implemented by the invention.

Fig. 5 is a flow chart of attendance verification punch-in implemented by the invention.

Fig. 6 is a flow chart of random attendance checking implemented by the invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

As shown in fig. 1, the programmable wireless routing-based real-time class attendance system implemented by the invention comprises a client, a router and a server,

the client is arranged on a handheld terminal of a student and used for displaying various interfaces for a user and enabling the user to realize functions required by the user, such as card punching or inquiry of card punching conditions;

the router is used for processing a Probe Request detection frame in an IEEE 802.11 protocol and transmitting the processed information, the MAC address and the timestamp to the server;

As shown in fig. 2, the client of the present invention mainly includes a login module, a card punching module, a record query module, and a management/tool module, wherein the login module and the card punching module are all completed by the client, the router, and the server, and the record query module and the management/tool module are completed by the client and the server.

Wherein, the login module is used for:

when a user only uses a school code/job number to log in the client, displaying prompt information of 'please input a password';

when a user only uses a password to log in the client, displaying prompt information of 'please input a study number/a job number';

and when the user logs in the client by using the school number/job number and the password and is successfully inquired and matched in the corresponding user data table, successfully logging in the client.

The card punching module is used for:

when a user logs in by using a common student account or a class manager account, the user uses a designated APP to perform fingerprint verification card punching attendance before and after class. But when the user logs in by using the account of the lessee teacher or the account of the educational administration staff, the card punching module is not displayed;

the card punching module uses Tencent biometric authentication open platform, namely TENCENT SOTER, and APP uses the open platform. When the user performs fingerprint verification, a fid is returned (namely, the fingerprint id. has uniqueness in one device, for example, one device can input 5 fingerprints, the fid corresponding to each fingerprint is different, and the fid is changed if new fingerprint information is deleted and added). The client APP sends the learning number, the fid and the equipment MAC address to the server, and the server performs information matching under the cooperation of data sent to the server by the router. And after the matching is successful, the card punching information is stored in the attendance sheet, otherwise, the card punching fails, and prompt information is returned. The specific matching process is described in detail in the server function module later.

The card punching module is further used for:

when a user logs in by using a common student account or a class manager account, a server sends a card punching request to the user at random and random in the course of class, and the user needs to punch a card within 5 minutes for verification.

The record query module is used for:

when a user logs in by using a common student account, checking attendance data generated by punching a card by the common student;

when a user logs in by using a class manager account, checking attendance data generated by punching cards of common students or checking attendance data generated by punching cards of all classmates of the class manager;

when a user logs in by using an account of a teacher in any class, checking the whole class card punching condition of the class taught by the teacher in any class and attendance data of all students in the class of the teacher in any class;

when a user logs in by using an instructor account, attendance information of a teacher in class and attendance information of a class managed by the instructor can be checked, and detailed card punching attendance information of a specific student can also be checked.

The management/tools module is configured to:

when a user logs in by using a common student account, the method comprises card supplementing application, leave asking, equipment replacing application, fingerprint replacing application, individual schedule query, individual score query, individual notification reminding, event adding/deleting to-be-done and the like.

The above functions of the management/tool module are specifically described as follows:

the card supplementing application is used for special conditions (forgetting the mobile phone, powering off the mobile phone and the like), can apply for card supplementing after class, and can change the card reading data to be normal after the examination and approval of teachers in the class but can have card supplementing records.

And the leave request is used for submitting a leave request application. And under the condition that a scanning version false request bar is attached, applying for a false request, and after the approval of a class manager is passed, changing the card punching data to be normal, but recording the false request.

The equipment replacing application is used for scanning the specified two-dimensional code on the old mobile phone by using new equipment when the equipment for punching the card needs to be replaced, and the equipment for punching the card can be changed after the examination and approval of a class administrator is passed, but the equipment for punching the card can be replaced.

The fingerprint application is changed for change the appointed fingerprint of punching the card, can't punch the card, can submit the change fingerprint application, and pass through the back at class administrator approval, the side can change the appointed fingerprint of punching the card, nevertheless has to change and establishes the fingerprint record.

And the personal class schedule query is used for querying the personal class schedule of the corresponding school period.

And the personal achievement inquiry is used for inquiring the personal achievements of all the school periods since the entrance of the school.

The personal notification reminder is used for viewing the notifications issued by the class manager, the lessee teacher and the educational administration or the reminders related to the notifications (such as the related reminders of excessive hung objects and the risk of leaving class).

The adding/deleting of the event to be handled is used for adding the event to be handled (such as an incomplete job and the transaction time thereof), and deleting the event to be handled.

The server comprises the functions of importing a school timetable into a school database, verifying user information, processing router sending data, processing card punching data, judging whether leaving a classroom or not, randomly sending card punching requests, counting card punching data, modifying user card punching data, modifying timetable information, accessing events to be handled and managing notification information, wherein the functions comprise:

the class schedule imported into the school database is used for:

the administrator user can conduct the operation of importing the class schedule in the school database into the platform, and all class schedule information needs to be imported into the database of the platform at the beginning of each school period for subsequent operations such as temporarily modifying the position of a class room.

The verify user information function is to:

after the user logs in the system, the MAC of the card punching equipment prestored in the database and the place information of the user, which is required to be in class in the time period, are matched according to the school number of the student (common student and class manager) user. And user authentication is carried out according to the MAC of the user card punching equipment, the login time and the data sent to the server by the router. If the matched items exist, the user is not allowed to punch the card through the equipment, and corresponding error information is prompted.

The processing router sends data function, which is used to:

and when receiving the data sent by the router, the server stores the data sent by the router into the database.

The function of processing the card punching data is used for:

after a user performs fingerprint verification card punching, the server obtains all non-repetitive MAC addresses in the time by comparing the data sent by the router corresponding to the user card punching time and the card punching time (data within plus or minus 2 seconds are used for preventing errors), and matches the MAC addresses carried by the user card punching, if the matching is successful, the user is proved to be in an appointed classroom at the moment. And then, verifying that fid and school number generated by card punching are compared with information prestored in a database, and if the fid and school number are consistent, proving that the student successfully punches the card.

The determining whether to leave the classroom function is to:

the student is prevented from directly escaping from the class after the student finishes the card punching. And the background judges whether the user with the card is still in the coverage range of the designated router in real time according to the data sent by the router.

The random card punching request function is used for reducing the occurrence that after the student punches the card, the mobile phone is placed in a classroom and a person steals and walks. The server selects the school number of the card punched in the corresponding time period from the attendance table of the database at any time, and pushes the card punching prompt to the client of the specified user through the MQTT protocol, so that the specified user is required to punch the card.

The statistical card punching data function is used for:

when a user logs in by using a common student account or a class manager account, a function of counting card punching data is required to be called in a background when the user card punching condition is inquired, and the attendance data of the user is displayed on a terminal page;

when a user logs in by using an account of a teacher in any class, inquiring the class integral card punching condition of the class taught by the teacher in any class and attendance data punched in the class of the teacher in any class by all students, calling a function of counting the card punching data in a background, and displaying the attendance data to a terminal page;

when a user logs in by using a educational administration account, inquiring attendance information of teachers in the lessons and classes which are managed by the educational administration administrator or inquiring detailed card punching attendance information of a specific student, calling a function of counting card punching data in a background, and displaying the attendance data to a terminal page;

the modify user card data function is used for:

when a student user applies for a card supplement and gives consent to a teacher; when the student user applies for leave, and the lesson teacher agrees, the background modifies the card data of the student user to be normal and marks the data as a supplementary card or leave.

The function of modifying the schedule information is used for:

when any lesson teacher user temporarily modifies the course information, the background checks whether the modified course information conflicts with other courses, and if no conflict exists, the temporarily modified course information is stored in the database. If the permanent course information modification is applied, after the approval of the educational administration manager, the original course information is replaced by the temporarily modified information.

The function of accessing the events to be handled is used for:

and when the user edits the event to be handled by using the function of adding/deleting the event to be handled, accessing the event to be handled to corresponding information in the database in real time.

The management notification information function is configured to:

when a class manager user, a lessee teacher user or a lesson manager user issues a notice, the notice is updated into a database; when all users use the personal notification function, the notifications matched with the learning numbers/job numbers of the users in the database are read and displayed in time sequence.

The invention relates to a real-time attendance checking platform which is formed by taking Android and iOS terminals as foreground, java Web developed by java as development language as background and a programmable wireless route as intermediary for processing a Probe Request detection frame in an IEEE 802.11 protocol. The method has the advantages of being simple to use, friendly in user interface, capable of saving attendance time, capable of enhancing the authenticity of attendance data, convenient to check the attendance data, capable of containing a plurality of practical functions and the like.

As shown in fig. 3, the student card punching system flow is as follows:

s101, after entering a classroom, a student turns on a mobile phone WiFi (the client is connected with the WiFi);

s102, the student opens the appointed APP on the client, logs in with the own student number password, and after login succeeds, the student can enter the APP and click a card punching button on the APP to perform fingerprint authentication to punch the card.

S103, the APP verifies the validity of the fingerprint, and if the user' S learning number, fid (id of fingerprint used for card punching) and mobile phone MAC address are correctly logged in, the fingerprint validity is sent to a server. When a user carries out fingerprint verification, a fid is returned, the processed data is stored in the server in real time by the router, the server is stored in the database, and then a step is carried out in the verification stage of user request card punching to verify the card punching position, and at the moment, whether the card punching position is correct or not is matched by inquiring the record stored in the database by the router.

The router only needs to store the MAC address, the timestamp and the router MAC address of the mobile phone within the range into a redis database in real time, and then when the card is punched, the verification stage can match the MAC address of the current card punching equipment according to the data of the mobile phone MAC address stored in the redis database by the router, so that the current card punching place is obtained.

And S104, simultaneously, the router in the classroom can continuously capture the Probe Request detection frame of the IEEE 802.11 protocol in the range, extract the MAC address of the client in the detection frame, and package and send the MAC address and the time stamp to the server.

Specifically, the router selects the MAC address in the Probe Request Probe frame in the IEEE 802.11 protocol, and the implementation flow is as follows:

1. finding a WiFi-driven source code in openwrt source codes, processing all received WiFi data packets by an __ ieee80211_ rx _ handle _ packet function through adding a code for processing a Probe Request detection frame, and finishing data collection;

2. storing the collected user MAC address data in a global variable and transmitting the data to a user space in a Generic Netlink mode;

3. and the router shell script sends the obtained user MAC address, the router MAC address and the timestamp to the server.

And S105, the server compares the received data sent by the APP, the data sent by the router and the pre-stored database information. And judging whether the students punch the cards with own mobile phones and own fingerprints in the appointed classrooms at the appointed time.

And after the user at the client logs in the system, the server matches the MAC of the card punching device prestored in the database according to the student user study number, acquires the place information of the user, which is required to be used as a class in the time period, of the user through wifi, and performs user authentication according to the MAC of the card punching device of the user, the login time and the data sent to the server by the router. And if the matched items exist, the user is not allowed to punch the card through the client, and corresponding error information is prompted.

After a user performs fingerprint verification card punching, the server obtains all non-repetitive MAC addresses in the time by comparing the data sent by the router corresponding to the user card punching time and the card punching time (data within plus or minus 2 seconds are used for preventing errors), and matches the MAC addresses carried by the user card punching, if the matching is successful, the user is proved to be in an appointed classroom at the moment. And then, comparing fid and school number generated by card punching with information prestored in a database, and if the fid and school number are consistent, proving that the card punching of the same school is successful.

And S106, after the background processes the card punching data, returning a corresponding result, and if the card punching is successful, storing the record into an attendance table in the database. And ending the card punching process.

Time management provisions for card punching are shown in fig. 4.

Thus, the flow of the card punching and the verification is shown in fig. 5:

201. the router acquires a Probe Request detection frame in an IEEE 802.11 protocol in a range in real time;

202. extracting the MAC address of the mobile equipment, the MAC address of the router and the timestamp from the detection frame, and storing the MAC address, the MAC address and the timestamp into a Redis database of a server;

203. after a user checks a card, the fingerprint ID, the learning number and the MAC address of the equipment are sent to a server;

204. the server inquires basic information of the student and corresponding course information according to the student number and the timestamp;

205. verifying whether the student needs to attend a class or not through the course information, if so, acquiring the MAC address of the router of the attending place, and turning to the next step; otherwise, go to step 209;

206. inquiring a matchable record within a certain time (the certain time is usually 2-5 seconds, and the time is set to avoid errors) according to the timestamp, the MAC address of the router and the MAC address of the student device;

207. if the record exists, matching information such as fid, equipment MAC address and the like according to the student information; if the matching is successful, executing the next step, and if the matching cannot be successful, turning to the step 209;

208. storing the record of punching card and storing the data in the attendance table in the database

209. If the user fails, returning error information to the user, if the user succeeds, returning success information to the user, and ending.

The student is prevented from directly escaping from the class after the student finishes the card punching. And the background judges whether the user with the card is still in the coverage range of the designated router in real time according to the data sent by the router. If the student has punched the card, but the router does not detect the MAC address corresponding to the user in the class time, the device is out of the classroom range, and if the device cannot be detected in five minutes, the student is judged to have escaped the class.

The functional flow chart of random card punching is shown in fig. 6, and the steps are as follows:

301. the router acquires a Probe Request detection frame in an IEEE 802.11 protocol in a range in real time;

302. extracting the MAC address of the mobile equipment, the MAC address of the router and the timestamp from the detection frame, and storing the MAC address, the MAC address and the timestamp into a Redis database of a server;

303. the server randomly pushes a secondary card-punching request to a user who punches the card through an MQTT protocol, if no response exists after a certain time (generally, 5 minutes can be set) after the request is sent, the step 305 is executed;

304. after receiving the card punching request, the user carries out fingerprint verification, sends the fid, the school number and the MAC address of the equipment to the server, and then executes step 306;

305. storing the unresponsive user record as a lesson within 5 minutes;

306. the server inquires basic information of students and the MAC addresses of the routers of the places of class according to the study numbers and the timestamps;

307. returning to the MAC address of the router of the place of class;

308. inquiring a matchable record within a certain time (the certain time is usually 2-5 seconds, and the time is set to avoid errors) according to the timestamp, the MAC address of the router and the MAC address of the student device;

309. if the record exists, matching information such as fid, equipment MAC address and the like according to the student information; if the matching is successful, executing the next step, and if the matching cannot be successful, turning to the step 311;

310. storing the record of punching card and storing the data in the attendance table in the database

311. If the result is successful, the success information is returned to the user, and if the result is failed, the corresponding error information is returned, and the process is finished.

The mobile phone is placed in a classroom to reduce the occurrence of the situation that a student steals and slips after the student finishes checking the card. The background server selects the school number of the card punched in the corresponding time period (preferentially extracts students with bad conditions such as late class and early retreat) from the attendance table of the database at any time, and pushes the card punching reminder to the client of the appointed user through the MQTT protocol (the mode of using the publish/subscribe message in the MQTT protocol provides decoupling between one-to-many message distribution and application. The card punching verification process is consistent with the conventional card punching process, and if the card punching is not verified within 3 minutes, the card punching is regarded as absenteeism.

In conclusion, the beneficial effects of the invention are as follows:

1. and acquiring a Probe Request detection Request frame in the IEEE 802.11 protocol through a router, and synchronizing the MAC address of the client in the Probe Request detection Request frame to a server in real time. The functions of judging whether the user login place is correct, judging whether the user card punching place is correct, judging whether the user is in a classroom all the time and the like can be realized in an auxiliary mode.

4. The situation that students walk out by themselves after putting mobile phones in classrooms by punching cards is reduced. By adopting an MQTT message pushing mechanism, the server pushes the card punching prompt message to the random user (preferentially extracting students with bad records) client at irregular time, so that the possibility of class escape of students is further reduced, and the attendance efficiency is greatly improved.

The above description is illustrative of the preferred embodiment of the present invention and is not to be construed as limiting the invention, but rather as encompassing all the modifications, equivalents, and improvements made within the spirit and principles of the invention.

Claims

1. A classroom real-time attendance method based on programmable wireless routing comprises the following steps:

s101, opening a mobile phone WiFi after a student enters a classroom;

s102, the students open the appointed APP on the client side, login is carried out through the own learning number password, and after login is successful, the students can enter the APP and click a card punching button on the APP to carry out fingerprint authentication to punch a card;

s103, the APP verifies the validity of the fingerprint, and if the learning number, the fid and the mobile phone MAC address of the user are correctly logged in, the fingerprint is sent to a server;

the router stores the MAC address, the timestamp and the router MAC address of the mobile phone within the range into a redis database in real time, and then when the card is punched, the verification stage can match the MAC address of the current card punching equipment according to the data of the mobile phone MAC address stored in the redis database by the router, so that the current card punching place is obtained;

s104, the router in the classroom can continuously capture a Probe request detection frame of an IEEE 802.11 protocol in the range, extract a client MAC address in the detection frame, package the client MAC address, the MAC address and a timestamp of the client MAC address and send the client MAC address and the timestamp to a server;

specifically, the router screens out the MAC address in the Probe Request Probe frame in the captured IEEE 802.11 protocol, and the implementation flow is as follows:

1041. finding WiFi-driven source codes in openwrt source codes, processing all received WiFi data packets by an __ ieee80211_ rx _ handle _ packet function, adding codes for processing Probe Request detection frames, and finishing data collection;

1042. storing the collected user MAC address data in a global variable and transmitting the data to a user space in a Generic Netlink mode;

1043. the router shell script sends the acquired user MAC address, the router MAC address and the timestamp to a server;

s105, the server compares the received data sent by the APP, the data sent by the router and the pre-stored database information, and judges whether the student uses the mobile phone of the student and the fingerprint of the student to punch a card in an appointed classroom at an appointed time;

and S106, after the background processes the card punching data, returning a corresponding result, and if the card punching is successful, storing the record into an attendance form in the database.

2. The programmable wireless router-based classroom real-time attendance method as claimed in claim 1, wherein in step 103, when the user performs fingerprint verification, a fid is returned, the router stores the processed data in the server in real time, the server stores the processed data in the database, and then a step is taken in the verification stage when the user requests card punching to verify the card punching position, and at this time, whether the card punching position is correct or not is matched by inquiring the record stored in the database by the router.

3. The programmable wireless router-based classroom real-time attendance method as claimed in claim 1, wherein in step 105, after a user performs fingerprint verification card punching, the server obtains all non-duplicate MAC addresses in the time by comparing the user card punching time with data sent by the router corresponding to the card punching time, and matches the MAC addresses carried by the user card punching, and if the matching is successful, the user is certified that the user is in a designated classroom at the time.