Door lock passing record acquisition system and method thereof

The door lock management platform actively obtains the recording pointer information and re-enrolls, which solves the problems of excessive communication times and pass record integrity in traditional door locks when offline, achieving lower power consumption and higher pass record integrity.

CN119763220APending Publication Date: 2025-04-04SHENZHEN DAS INTELLITECH CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411815777.3
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-10
Publication Date
2025-04-04

AI Technical Summary

Technical Problem

Traditional door locks generate a large number of pass records when offline, resulting in an increase in power consumption. Pass records may be uploaded repeatedly or lost, and communication conflicts are prone to occur when multiple door locks are reported at the same time.

Method used

The door lock pass record collection system is adopted to actively obtain the door lock record pointer information through the door lock management platform, determine whether the pass record data needs to be collected, and the door lock is awakened through the door lock gateway for batch upload, reducing the number of communications and power consumption.

Benefits of technology

It effectively reduces the number of communication times and power consumption of door locks, avoids repeated uploads and losses of pass records, ensures the integrity of pass records, and avoids communication conflicts caused by simultaneous communication of multiple door locks.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119763220A_ABST
    Figure CN119763220A_ABST
Patent Text Reader

Abstract

The invention relates to a door lock passing record acquisition system and a method thereof. The method comprises the following steps that: a door lock stores each passing record to a local flash of the door lock, and meanwhile, a record pointer is updated; and the recording pointer is used for recording related information related to the passing record in real time. The door lock management platform is in wireless communication connection with the door lock gateway, the door lock management platform obtains and stores the record pointer information of the specified door lock through the door lock gateway, and whether the passage record data of the door lock needs to be subjected to supplementary collection or not is judged according to the record pointer information. And if yes, sending the supplementary collection instruction to the door lock gateway. The supplementary collection instruction comprises a record number X of supplementary collection starting. And the door lock gateway wakes up the door lock so as to perform LoRa communication connection with the door lock, sends a supplementary collection instruction to the door lock, receives passing records which are uploaded by the door lock in batches and start from the record number X, and transmits the passing record data after supplementary collection to the door lock management platform. Communication times can be effectively reduced, and power consumption of the door lock is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of intelligent door locks, and in particular to a door lock passage record collection system and method. Background Art

[0002] With the promotion of LoRa communication, LoRa communication is used as the main communication method in many low-power application fields. For example, low-power door locks use LoRa to synchronize permissions in the door locks and upload access records. In the traditional way of reporting access records, the door locks immediately report the unlocking records to the door lock gateway device to upload access records after the door locks are unlocked. When a large number of access records are generated when the door lock is offline, and the communication with the gateway door lock management platform is restored, the use of related technologies is prone to the following defects: the power consumption of the door lock increases; the problem of repeated uploading of access records will occur; the access records will be lost; if the door lock gateway manages multiple door locks at the same time, when multiple door locks report access records to the door lock gateway at the same time, there will be communication conflicts. Summary of the invention

[0003] The technical problem to be solved by the present invention is to provide a door lock access record collection system and method thereof in view of the above-mentioned defects.

[0004] The technical solution adopted by the present invention to solve the technical problem is: a door lock access record collection method, applied to a door lock access record collection system, the door lock access record collection system includes at least one door lock, a door lock gateway and a door lock management platform, the door lock management platform is wirelessly connected to the door lock gateway, each of the door locks is provided with a record pointer, the method includes:

[0005] The door lock saves each pass record to the local flash of the door lock, and at the same time, updates the record pointer; the record pointer is used to record relevant information related to the pass record in real time;

[0006] The door lock management platform obtains and saves the record pointer information of the designated door lock through the door lock gateway, and determines whether it is necessary to collect the passage record data of the door lock according to the record pointer information;

[0007] If yes, a supplementary purchase instruction is sent to the door lock gateway; the supplementary purchase instruction includes the record number X at which the supplementary purchase starts;

[0008] The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the supplementary acquisition instruction to the door lock, and receives the pass records starting from record number X uploaded in batches by the door lock, and transmits the supplementary acquisition pass record data to the door lock management platform.

[0009] In some embodiments, the record pointer is used to record in real time the number of uncollected records, the total number of records, the uncollected starting record number and the latest record number of the pass record.

[0010] In some embodiments, the method further comprises:

[0011] The door lock management platform receives the supplementary passage record data completed by the door lock gateway and saves it in the database; and determines whether the latest record number in the saved record pointer information is consistent with the record number of the last passage record in the supplementary passage record data; if so, it is determined that the supplementary collection is completed.

[0012] In some embodiments, the method further comprises:

[0013] When the door lock management platform determines that the latest record number in the saved record pointer information is greater than the record number of the last pass record in the supplementary pass record data, the supplementary pass record instruction is reissued;

[0014] When the door lock management platform determines that the latest record number in the saved record pointer information is less than the record number of the last pass record in the supplementary pass record data, the record pointer information of the door lock is re-acquired.

[0015] In some embodiments, the record pointer consists of the beginning of the record, the number of uncollected records, the total number of records, the uncollected starting record number, the latest record number and a checksum.

[0016] In some embodiments, the number of uncollected records is the total number of access records that have not been uploaded to the door lock gateway, the total number of records is the total number of access records that the door lock has saved and includes those that have been uploaded, the uncollected starting record number is the record number of the access records from which the door lock has not successfully uploaded to the door lock gateway, and the latest record number is the record number of the latest access record in the door lock.

[0017] In some embodiments, the method further comprises:

[0018] When the door lock gateway determines that the supplementary collection is completed, it sends a supplementary collection completion instruction to the door lock;

[0019] After receiving the supplementary sampling completion instruction, the door lock updates the data of the record pointer and enters a low-power operation mode. At the same time, the door lock response information is returned to the door lock gateway.

[0020] In some embodiments, the step of the door lock management platform acquiring the record pointer information of the door lock through the door lock gateway includes:

[0021] The door lock management platform sends a record pointer query instruction corresponding to the door lock to the door lock gateway;

[0022] The door lock gateway wakes up the door lock to establish a LoRa communication connection with the door lock, sends the record pointer query instruction to the door lock, and receives the current record pointer information uploaded by the door lock and transmits it to the door lock management platform.

[0023] In some embodiments, after the door lock uploads the current record pointer information to the door lock gateway, it enters a low power consumption operation mode.

[0024] In addition, the present invention also provides a door lock passage record collection system, comprising at least one door lock, a door lock gateway and a door lock management platform, wherein the door lock management platform is wirelessly connected to the door lock gateway, and each door lock is provided with a record pointer. The system comprises:

[0025] The door lock saves each pass record to the local flash of the door lock, and at the same time, updates the record pointer; the record pointer is used to record relevant information related to the pass record in real time;

[0026] The door lock management platform is used to obtain and save the record pointer information of the designated door lock through the door lock gateway, and determine whether it is necessary to supplement the passage record data of the door lock according to the record pointer information; if so, send a supplementary collection instruction to the door lock gateway; the supplementary collection instruction includes the record number X at which the supplementary collection starts;

[0027] The door lock gateway is used to wake up the door lock to establish a LoRa communication connection with it, send the supplementary acquisition instruction to the door lock, and receive the pass records starting from record number X uploaded in batches by the door lock, and transmit the supplementary acquisition pass record data to the door lock management platform.

[0028] The door lock access record collection system and method of the present invention have the following beneficial effects: the present invention actively collects door lock access record data through the platform, which can effectively reduce the number of communications and reduce the power consumption of the door lock through rapid supplementary collection, and the door lock management platform can quickly locate the record number that needs to be collected, ensure the integrity of the access record, and avoid the problem of repeated uploading of access records. In addition, when the door lock gateway is connected to multiple door locks, communication conflicts caused by simultaneous communication of multiple door locks can be avoided. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0030] Figure 1 It is a structural schematic diagram of a door lock passage record collection system provided by an embodiment of the present invention;

[0031] Figure 2 It is a flow chart of a method for collecting door lock access records provided by an embodiment of the present invention;

[0032] Figure 3 is a flow chart of a door lock access record collection method provided by an embodiment of the present invention;

[0033] Figure 4 It is a flow chart of a method for collecting door lock access records in the related art;

[0034] Figure 5 It is a working timing diagram of the door lock access record collection method provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0035] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, the specific implementation methods of the present invention are now described in detail with reference to the accompanying drawings. In the following description, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", "connected", "fixed", "set" and the like should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral body; it can be a mechanical connection or an electrical connection; it can be directly connected or indirectly connected through an intermediate medium, it can be the internal connection of two elements or the interaction relationship between two elements. When an element is referred to as being "on" or "under" another element, the element can be "directly" or "indirectly" located on the other element, or there may be one or more intermediate elements. The terms "first", "second", "third", etc. are only for the convenience of describing the present technical solution, and cannot be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Therefore, the features defined as "first", "second", "third", etc. can explicitly or implicitly include one or more of the features. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to the specific circumstances.

[0036] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present invention. However, it should be clear to those skilled in the art that the present invention may be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present invention.

[0037] In one embodiment provided by the present invention, this embodiment is applied to a door lock passage record collection system, such as Figure 1As shown, the door lock passage record collection system includes at least one door lock, a door lock gateway and a door lock management platform, and the door lock management platform is wirelessly connected to the door lock gateway. Optionally, the door lock management platform and the door lock gateway can transmit data through the MQTT communication method. Each door lock is provided with a record pointer. The record pointer is used to record relevant information related to the passage record in real time. It can be understood that a door lock gateway can be connected to multiple door locks, such as 1, 2, 3, 5, 6, etc., and the present application does not specifically limit the specific number of door locks connected to a gateway. The passage record can be a door opening record. Of course, in some other embodiments, the passage record can also include a door closing record. The present invention is mainly described in detail with the passage record as a door opening record.

[0038] refer to Figure 2 and Figure 3 The door lock access record collection method of this embodiment includes: S1, the door lock saves each access record to the local flash of the door lock, and at the same time, updates the record pointer. Specifically, the record pointer is used to record in real time the number of uncollected records, the total number of records, the uncollected starting record number and the latest record number of the door lock access record.

[0039] S2. The door lock management platform obtains and saves the record pointer information of the specified door lock through the door lock gateway, and determines whether it is necessary to collect the access record data of the door lock based on the record pointer information. If so, the recollection instruction is sent to the door lock gateway. The recollection instruction includes the record number X from which the recollection starts. Optionally, the recollection instruction may also include the total number of recollections (for example, a total of N access records need to be recollected).

[0040] S3. The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends a supplementary acquisition instruction to the door lock, and receives the access records starting from record number X uploaded in batches by the door lock, and transmits the access record data completed by the supplementary acquisition to the door lock management platform. In this embodiment, after the door lock management platform determines the door lock that needs to perform supplementary acquisition of access records, it sends a supplementary acquisition instruction to the door lock gateway connected to the door lock, so that the door lock can upload from record number X, and upload a total of N access records. The door lock gateway sends the supplementary acquisition instruction to the door lock. The door lock receives the access record reporting instruction, and reports the access records to the gateway in batches starting from record number X until N records are uploaded. The gateway receives and saves the access records reported in batches until the acquisition is completed. All access records of the door lock supplemented by the gateway are transmitted to the platform. The platform saves the supplementary access records and analyzes them.

[0041] like Figure 4As shown in the figure, it is the process of the door lock reporting the access record in the related technology. After the user swipes the card in the door lock, the access will be uploaded to the door lock gateway immediately. After the gateway receives the access record reported by the door lock, it will be uploaded to the door lock management platform immediately. Compared with the traditional method, whether it is normal or offline, the door lock always actively sends data, and when the traditional method is offline, because the door lock itself does not know that it is offline, it will still report the access record one by one, but it cannot wait for the response. In the present invention, the door lock no longer actively sends data, and the access record is reported in batches after receiving the upload instruction, which can reduce the number of uploads and the number of communications, thereby effectively reducing the power consumption of the door lock. That is, the door lock record collection method of the present invention stores the record number and other information of the access record in the door lock flash. After the door lock and the door lock gateway are disconnected and reconnected, the door lock management platform can actively obtain the latest information of the door lock record, and collect and analyze the access record in the door lock according to the latest information of the door lock record, and can also use a relatively small number of lora communications to complete the collection of all the records in the door lock. This method solves the problem of door lock power consumption increasing due to uploading a large number of access records, making the door lock more power-efficient. It can also avoid the problem of door locks repeatedly uploading access records and ensure the integrity of access records. Moreover, it can also solve the problem of communication conflicts caused by multiple door locks uploading access records at the same time under the same door lock gateway.

[0042] In some embodiments, the method further includes: the door lock management platform receives the supplementary passage record data completed by the door lock gateway and saves it in the database. Moreover, it is determined whether the latest record number in the saved record pointer information is consistent with the record number of the last passage record in the supplementary passage record data. If so, it is determined that the supplementary collection is completed. Alternatively, when the door lock management platform determines that the latest record number in the saved record pointer information is greater than the record number of the last passage record in the supplementary passage record data, it indicates that there is missing data in this supplementary collection process, and the supplementary collection instruction is reissued at this time. When the door lock management platform determines that the latest record number in the saved record pointer information is less than the record number of the last passage record in the supplementary passage record data, it indicates that a new passage record has been generated in the process of this supplementary collection. At this time, the record pointer information of the door lock is re-acquired, and the supplementary collection operation is performed again.

[0043] In this embodiment, the door lock management platform is required to query the record information in the door lock first, and collect and analyze the door lock's pass records according to the record information until the door lock record collection is completed. This method avoids the problem of repeated uploading of pass records and loss of pass records by the door lock.

[0044] In a specific embodiment, the record pointer may consist of the beginning of the record, the number of uncollected records, the total number of records, the uncollected starting record number, the latest record number and a checksum. Exemplarily, the record pointer may consist of the beginning of the record of a fixed value, the number of uncollected records of 2 bytes, the total number of records of 2 bytes, the uncollected starting record number of 2 bytes, the latest record number of 2 bytes, and the checksum of 2 bytes. It can be understood that in the present application, the number of uncollected records is the total number of passage records that have not been uploaded to the door lock gateway, the total number of records is the total number of passage records that the door lock has saved and includes those that have been uploaded, the uncollected starting record number is the record number of the passage record that the door lock has not successfully uploaded to the door lock gateway from which record number, and the latest record number is the record number of the latest passage record in the door lock.

[0045] In some embodiments, the method further includes: when the door lock gateway determines that the supplementary sampling is completed, it sends a supplementary sampling completion instruction to the door lock. After receiving the supplementary sampling completion instruction, the door lock updates the data of the record pointer and enters the low-power operation mode, and at the same time, returns the door lock response information to the door lock gateway. That is to say, the door lock management platform obtains and saves the record pointer information of the specified door lock through the door lock gateway, and determines whether it is necessary to supplement the passage record data of the door lock according to the record pointer information. If so, the supplementary sampling instruction is sent to the door lock gateway. The supplementary sampling instruction includes the record number X at the start of the supplementary sampling. The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the supplementary sampling instruction to the door lock, and receives the passage records starting from the record number X uploaded by the door lock in batches. When the door lock gateway determines that the supplementary sampling is completed, it sends the supplementary sampling completion instruction to the door lock. After receiving the instruction, the door lock updates the data of the record pointer and enters the low-power operation mode, and at the same time, returns the door lock response information to the gateway. The gateway transmits all the access records of the door lock that have been collected to the platform; the platform saves the collected access records and analyzes them to determine whether there is any missing data (re-collection) or more recorded data (re-querying the record pointer). If so, the corresponding operation is performed. It can be understood that when the data is not uploaded, the door lock is in a low-power operation mode.

[0046] In some embodiments, the step of the door lock management platform obtaining the record pointer information of the door lock through the door lock gateway includes: the door lock management platform sends a record pointer query instruction corresponding to the door lock to the door lock gateway. The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the record pointer query instruction to the door lock, and receives the current record pointer information uploaded by the door lock and transmits it to the door lock management platform.

[0047] That is to say, in this embodiment, the door lock management platform sends a record pointer query instruction corresponding to the door lock to the door lock gateway. The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the record pointer query instruction to the door lock, and transmits the received current record pointer information uploaded by the door lock to the door lock management platform. The door lock management platform determines whether it is necessary to supplement the passage record data of the door lock based on the record pointer information. If so, the supplementary sampling instruction is sent to the door lock gateway. The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the supplementary sampling instruction to the door lock, and receives the passage records starting from record number X uploaded by the door lock in batches, and transmits the supplementary passage record data to the door lock management platform. Optionally, after the door lock uploads the current record pointer information to the door lock gateway, it enters a low-power operation mode.

[0048] This embodiment can effectively reduce the number of communications and the power consumption of the door lock, and the door lock management platform can quickly locate the record number that needs to be collected, ensure the integrity of the access record, and avoid the problem of repeated uploading of access records.

[0049] In one embodiment, reference Figure 5, the low-power door lock saves a record pointer record while storing the pass record. Of course, the record pointer can also be updated without saving a pointer record separately. The door lock management platform obtains the information recorded by the record pointer of the door lock through the door lock gateway, and stores the number of uncollected records, the total number of records, the uncollected starting record number, and the latest record number information of the door lock in the background database. After successfully obtaining the total number of door lock records, the door lock management platform sends a door lock supplementary acquisition instruction to the door lock gateway, allowing the door lock gateway to supplement the pass record of the specified door lock, and let the door lock report the pass record starting from record number X. Each time n pass records are uploaded to the door lock gateway, a total of N pass records need to be uploaded. Optionally, the batch upload method of the door lock can also be implemented according to the supplementary acquisition instruction sent cyclically by the door lock gateway. That is, each time the door lock gateway sends a supplementary acquisition instruction to the door lock, the door lock uploads n pass records to it until the supplementary acquisition of N pass records is completed. The door lock gateway wakes up the door lock for LoRa communication and sends a command to the door lock to collect the access record. After the door lock gateway receives N access records sent by the door lock and saves them to the local flash of the door lock gateway successfully, the door lock gateway sends a command to the low-power door lock to complete the collection, and the low-power door lock immediately enters the low-power mode. The door lock gateway sends the access records uploaded by the low-power door lock to the door lock management platform via MQTT. After receiving the access records of the door lock, the door lock management platform immediately performs record analysis. Specifically, the door lock management platform compares the latest record number of the record pointer stored in the database with the last access record number collected. If the record numbers are the same, it means that the collection has been completed. If the last record number of the collection is smaller than the latest record number of the record pointer in the database, it means that the collection process has missed the access record and needs to be re-collected. If the last record number of the supplementary acquisition is greater than the latest record number of the record pointer in the database, it means that someone may have passed through during the supplementary acquisition process and generated a new record. The door lock management platform needs to re-acquire the door lock record pointer information and perform the supplementary acquisition operation again until the latest record number of the record pointer in the database is the same as the record number of the last access record collected. It should be noted that Figure 5 The record pointer protocol in is the record pointer query instruction, the supplementary door lock protocol is the supplementary acquisition instruction, and the supplementary acquisition completion protocol is the supplementary acquisition completion instruction.

[0050] This embodiment actively collects door lock access record data through the platform, which can effectively reduce the number of communications and reduce the power consumption of the door lock through rapid supplementary collection. The door lock management platform can quickly locate the record number that needs to be collected, ensure the integrity of the access record, and avoid the problem of repeated uploading of access records. In addition, when the door lock gateway is connected to multiple door locks, communication conflicts caused by simultaneous communication of multiple door locks can be avoided.

[0051] In one of the embodiments provided by the present invention, reference Figure 1 The door lock access record collection system of this embodiment includes at least one door lock, a door lock gateway and a door lock management platform. The door lock management platform is wirelessly connected to the door lock gateway. Each door lock is provided with a record pointer. The system includes:

[0052] The door lock saves each access record to the local flash of the door lock and updates the record pointer at the same time. The record pointer is used to record relevant information related to the access record in real time.

[0053] The door lock management platform is used to obtain and save the record pointer information of the specified door lock through the door lock gateway, and determine whether it is necessary to collect the access record data of the door lock based on the record pointer information. If so, the recollection instruction is sent to the door lock gateway. The recollection instruction contains the record number X where the recollection starts.

[0054] The door lock gateway is used to wake up the door lock to establish a LoRa communication connection with it, send the re-collection instruction to the door lock, and receive the pass records starting from record number X uploaded in batches by the door lock, and transmit the re-collected pass record data to the door lock management platform.

[0055] This embodiment aims to solve the problem that when a door lock stores a large number of access records offline, a large amount of communication is required between the door lock and the door lock gateway after the communication is restored, which will increase the power consumption of the door lock and cause the battery power to decrease too quickly. The door lock management platform collects records through the door lock gateway, and the door lock uploads access records in batches, that is, uploads multiple access records at one time, thereby solving the problem of excessive power consumption of the door lock by reducing the number of communications. When the door lock gateway manages multiple door locks at the same time, the problem of LoRa conflicts caused by multiple door locks communicating with the door lock gateway at the same time can be avoided by using the door lock gateway to actively collect the access records of the specified door lock. This embodiment can effectively reduce the number of communications and reduce the power consumption of the door lock.

[0056] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in the above description according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0057] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0058] It can be understood that the above embodiments only express the preferred implementation modes of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the patent scope of the present invention. It should be pointed out that, for ordinary technicians in this field, the above technical features can be freely combined without departing from the concept of the present invention, and several deformations and improvements can be made, which all belong to the protection scope of the present invention. Therefore, all equivalent changes and modifications made to the scope of the claims of the present invention should belong to the coverage of the claims of the present invention.

Claims

1. A door lock access record collection method, applied to a door lock access record collection system, characterized in that: The door lock passage record collection system includes at least one door lock, a door lock gateway and a door lock management platform, the door lock management platform is wirelessly connected to the door lock gateway, and each door lock is provided with a record pointer. The method includes: The door lock saves each pass record to the local flash of the door lock, and at the same time, updates the record pointer; the record pointer is used to record relevant information related to the pass record in real time; The door lock management platform obtains and saves the record pointer information of the designated door lock through the door lock gateway, and determines whether it is necessary to collect the passage record data of the door lock according to the record pointer information; If yes, a supplementary purchase instruction is sent to the door lock gateway; the supplementary purchase instruction includes the record number X at which the supplementary purchase starts; The door lock gateway wakes up the door lock to establish a LoRa communication connection with it, sends the supplementary acquisition instruction to the door lock, and receives the pass records starting from record number X uploaded in batches by the door lock, and transmits the supplementary acquisition pass record data to the door lock management platform.

2. The door lock access record collection method according to claim 1, characterized in that: The record pointer is used to record in real time the number of uncollected records, the total number of records, the uncollected starting record number and the latest record number of the pass record.

3. The door lock access record collection method according to claim 2, characterized in that: The method further includes: The door lock management platform receives the supplementary passage record data completed by the door lock gateway and saves it in the database; and determines whether the latest record number in the saved record pointer information is consistent with the record number of the last passage record in the supplementary passage record data; if so, it is determined that the supplementary collection is completed.

4. The door lock access record collection method according to claim 2, characterized in that: The method further includes: When the door lock management platform determines that the latest record number in the saved record pointer information is greater than the record number of the last pass record in the supplementary pass record data, the supplementary pass record instruction is reissued; When the door lock management platform determines that the latest record number in the saved record pointer information is less than the record number of the last pass record in the supplementary pass record data, the record pointer information of the door lock is re-acquired.

5. The door lock access record collection method according to claim 1 or 2, characterized in that: The record pointer is composed of the beginning of the record, the number of uncollected records, the total number of records, the uncollected starting record number, the latest record number and a checksum.

6. The door lock access record collection method according to claim 5, characterized in that: The number of uncollected records is the total number of access records that have not been uploaded to the door lock gateway, the total number of records is the total number of access records that the door lock has saved and uploaded, the uncollected starting record number is the record number of the access record from which the door lock has not successfully uploaded to the door lock gateway, and the latest record number is the record number of the latest access record in the door lock.

7. The door lock access record collection method according to claim 1, characterized in that: The method further includes: When the door lock gateway determines that the supplementary collection is completed, it sends a supplementary collection completion instruction to the door lock; After receiving the supplementary sampling completion instruction, the door lock updates the data of the record pointer and enters a low-power operation mode. At the same time, the door lock response information is returned to the door lock gateway.

8. The door lock access record collection method according to claim 1, characterized in that: The step in which the door lock management platform obtains the record pointer information of the door lock through the door lock gateway includes: The door lock management platform sends a record pointer query instruction corresponding to the door lock to the door lock gateway; The door lock gateway wakes up the door lock to establish a LoRa communication connection with the door lock, sends the record pointer query instruction to the door lock, and receives the current record pointer information uploaded by the door lock and transmits it to the door lock management platform.

9. The door lock access record collection method according to claim 8, characterized in that: After the door lock uploads the current record pointer information to the door lock gateway, it enters a low power consumption operation mode.

10. A door lock access record collection system, characterized in that: The system comprises at least one door lock, a door lock gateway and a door lock management platform, wherein the door lock management platform is wirelessly connected to the door lock gateway, and each door lock is provided with a record pointer. The system comprises: The door lock saves each pass record to the local flash of the door lock, and at the same time, updates the record pointer; the record pointer is used to record relevant information related to the pass record in real time; The door lock management platform is used to obtain and save the record pointer information of the designated door lock through the door lock gateway, and determine whether it is necessary to supplement the passage record data of the door lock according to the record pointer information; if so, send a supplementary collection instruction to the door lock gateway; the supplementary collection instruction includes the record number X at which the supplementary collection starts; The door lock gateway is used to wake up the door lock to establish a LoRa communication connection with it, send the supplementary acquisition instruction to the door lock, and receive the pass records starting from record number X uploaded in batches by the door lock, and transmit the supplementary acquisition pass record data to the door lock management platform.