Intelligent storage method based on ultrahigh frequency read-write

Abstract

The invention discloses an intelligent storage method based on ultrahigh frequency read-write, which comprises the following steps: initializing an intelligent storage cabinet, and adding a configuration file; starting an application of the intelligent locker, reading the configuration file, generating an intelligent locker information table, and creating a user information table and an administrator account; the administrator logs in the account to enter a management interface; creating type information of grids in the intelligent storage cabinet by the administrator, and filling the type information of each grid into the corresponding grid; an administrator scans the RFID equipment through the RFID reader-writer to obtain tag IDs and the number and store the tag IDs and the number into a database; after the common user logs in the account, the borrowed or returned grid list is displayed according to the permission list; when the user selects borrowing or returning operation, the operation interface sends a control instruction to the dot matrix module, controls opening and closing of the corresponding grid, and records borrowing or returning information to the database; the borrowing or returning operation supports local operation and remote operation. A lot of manpower and material resources can be saved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of Internet of Things, and in particular to an intelligent storage method based on super high frequency reading and writing. BACKGROUND

[0002] In the teaching of Internet of Things and the storage of some real-life items, storage cabinets are often needed. Because of the large number of types and quantities of devices, management is inconvenient, and often leads to loss of devices or the data of borrowing and returning does not match, resulting in chaotic management. The traditional management method needs to specially equip a manager to manage and borrow the warehouse items. This method needs to consume a lot of manpower and material resources. The following problems mainly exist:

[0003] 1. When checking the devices, it is difficult to check and classify due to the large number of types and quantities of devices;

[0004] 2. Special personnel are needed for management, and special storage rooms are needed for storage;

[0005] 3. The usual storage cabinet can only support one kind of online or offline operation for the user;

[0006] 4. There is no record of borrowing and returning, and it is difficult to find the corresponding personnel when the device is lost. SUMMARY

[0007] Therefore, the purpose of the present application is to provide an intelligent storage method based on super high frequency reading and writing, which saves a lot of manpower and material resources.

[0008] In order to achieve the above technical purpose, the technical scheme adopted by the present application is:

[0009] The present application provides an intelligent storage method based on super high frequency reading and writing, comprising the following steps:

[0010] Step 1: The administrator initializes the intelligent storage cabinet and adds the configuration file of the intelligent storage cabinet;

[0011] Step 2: When starting the application of the intelligent storage cabinet, read the configuration file, generate the intelligent storage cabinet information table, and create the user information table and the administrator account;

[0012] Step 3: The administrator logs in the account and enters the management interface after verifying the identity;

[0013] Step 4: The administrator creates the type information of the grid in the intelligent storage cabinet, including the ordinary grid and the RFID grid, and fills the type information of each grid into the corresponding grid;

[0014] Step 5: For RFID grids, the administrator scans the RFID device with an RFID reader to obtain the tag ID and quantity, and stores it in the database; repeat steps 4 and 5 until all the required data is entered into the database.

[0015] Step 6: After a regular user logs in, the list of borrowed or returned grid cells is displayed according to the permission list. When a user selects to borrow or return a grid cell, the operation interface sends control commands to the dot matrix module via the serial port to control the opening and closing of the corresponding grid cell and records the borrowing or returning information to the database.

[0016] Step 7: Borrowing or returning operations support both local and remote operations. Local operations are managed offline through a database, while remote operations are controlled via the IoT cloud platform through the MQTT protocol.

[0017] Furthermore, step 1 specifically includes:

[0018] Step 11: The administrator initializes the smart locker;

[0019] Step 12: Add a configuration file for the smart locker. The configuration file includes MQTT information and the number of lockers. The MQTT information includes the client ID, username, and password.

[0020] Step 13: Bind the configuration file to the smart locker and store the configuration file and binding information locally.

[0021] Furthermore, step 2 specifically includes:

[0022] Step 21: Open the smart locker application. When the application starts, read the configuration file to get the number of lockers.

[0023] Step 22: The database creates and generates a smart locker information table based on the number of lockers;

[0024] Step 23: According to the smart locker information table, divide the smart locker into one main locker and several auxiliary lockers. Set up multiple compartments under the main locker and auxiliary lockers and number them in sequence. The main locker also has an operation interface and an RFID reader in the middle.

[0025] Step 24: Read the MQTT information from the configuration file. The database creates a user information table based on the MQTT information and adds an administrator account.

[0026] Furthermore, step 3 specifically includes:

[0027] Step 31, the administrator logs in the account, the database executes the query statement, compares the account and the password stored in the database with the input account and password, if the comparison result is consistent, it means that the login is successful, and jumps to the home page; if the comparison result is inconsistent, an error message is prompted;

[0028] Step 32, after the administrator logs in successfully, the background judges whether the logged-in user is an administrator, if it is an administrator, the administrator permission is opened, and the management function menu is displayed; if it is not an administrator, the administrator permission is not opened.

[0029] Further, the step 4 specifically includes:

[0030] Step 41, the administrator creates the type information of each grid in the intelligent storage cabinet according to the number of ordinary devices and RFID devices in the to-be-stored device, including ordinary grid and RFID grid;

[0031] Step 42, a query statement is used to read out all the grids, the selection of the grid is performed, the type of the current grid is judged according to the type information corresponding to the selected grid, if the type of the current grid is an ordinary grid, the type information of the ordinary grid is filled in, the database executes an insertion statement, the type information of the current grid is stored in the selected grid, and is saved to the database; if the type of the current grid is an RFID grid, the type information of the RFID grid is filled in, the database executes an insertion statement, the type information of the current grid is stored in the selected grid, and is saved to the database;

[0032] Step 43, the ordinary grid is bound with the ordinary device, and the RFID grid is bound with the RFID device.

[0033] Further, the step 5 specifically includes:

[0034] Step 51, for each RFID grid, the operation interface of the intelligent storage cabinet generates an RFID scanning instruction, and sends the RFID scanning instruction to the RFID reader through the serial port driver library calling the serial port;

[0035] Step 52, after the RFID reader receives the RFID scanning instruction, the scanning mode is started, and a radio frequency signal is transmitted for scanning;

[0036] Step 53, the RFID device with the RFID tag to be counted is close to the RFID reader, the RFID device obtains energy through electromagnetic induction and activates the chip, and returns the tag data to the RFID reader;

[0037] Step 54, the RFID reader returns the scanned tag data to the operation interface through the serial port;

[0038] Step 55, the operation interface extracts the received label data to obtain the label ID and quantity, and de-duplicates the multiple scanning results;

[0039] Step 56, the de-duplicated label ID is associated with the corresponding quantity, and is stored to a database, and the label ID is taken as the device information of the RFID grid.

[0040] Further, the step 6 specifically comprises:

[0041] Step 61, a normal user is added, and user basic information is input and the accessible grid permission is associated;

[0042] Step 62, the user inputs an account and a password for login, and reads a grid list under the permission of the account after successful login;

[0043] Step 63, the grid list that can be borrowed and the grid list to be returned are classified and displayed according to the state of grid borrowing;

[0044] Step 64, when the user selects a target grid and enters the borrowing operation, the connection state of the dot matrix module and the serial port is detected, if the connection is normal, the operation interface sends a cabinet opening instruction to the dot matrix module through the serial port, the dot matrix module analyzes the cabinet opening instruction, controls the corresponding grid to be opened, and feeds back the opening state and records the borrowing log information;

[0045] Step 65, when the returning operation is entered, the quantity of the normal device is verified, the label scanning of the RFID device is verified, and the operation is completed after the quantity is consistent.

[0046] Further, the step 61 specifically comprises:

[0047] Step 611, the administrator creates a normal user account, inputs user basic information, and the database obtains a list of all grids for display according to the user basic information;

[0048] Step 612, after the corresponding grid is dynamically screened according to the user permission, the number of the corresponding grid is recorded and stored in the permission field of the user, and the permission field is stored in the format of grid numbers separated by commas;

[0049] The step 62 specifically comprises:

[0050] Step 621, the user inputs an account and a password for login, and the background compares the account and the password stored in the database with the input account and password, if the comparison result is consistent, it means that the login is successful, if the comparison result is inconsistent, it means that the login fails;

[0051] Step 622, after the user logs in successfully, read the grid list under the account permission, enter the home page, get the grid list that can be borrowed and the grid list to be returned, the grid list is the grid number under the account permission;

[0052] The step 63 specifically includes:

[0053] Step 631, data traversal is performed, and according to the state of grid borrowing, a grid list that can be borrowed and a grid list to be returned are screened out for classified display;

[0054] Step 632, all grids are displayed in the form of a card list, and the card contains device names and device quantities;

[0055] Step 633, click the card, and query the details of the grid in the database according to the corresponding grid ID;

[0056] The step 64 specifically includes:

[0057] Step 641, if in the grid list that can be borrowed, click the borrowing button, at this time the program initiates a serial detection command to the dot matrix module connected with the operation interface, if the returned protocol data bit is 00, it represents that the connection is normal, and step 642 is entered; otherwise, it represents that the connection is not normal;

[0058] Step 642, if the operation interface is connected with the dot matrix module through the serial port, the operation interface sends a cabinet opening instruction to the dot matrix module through the serial port, and the content of the cabinet opening instruction includes the address code of the cabinet, the number of the grid and the protocol command for opening the cabinet door;

[0059] Step 643, after the dot matrix module receives the cabinet opening instruction, the corresponding cabinet is found according to the address code of the cabinet, and the corresponding grid on the cabinet is found according to the number of the grid, after the dot matrix module receives the protocol command for opening the cabinet door, a high-level operation is sent, the cabinet door is connected with the level signal, the high-level triggers the level signal, at this time the cabinet door of the corresponding grid is automatically opened;

[0060] Step 644, after the cabinet door is opened, the program is returned with the state of whether it is opened, after the program receives it, borrowing success is prompted, the borrowing process is completed, and the current time, the current grid number, the device name borrowed and the borrowed device quantity are recorded and stored into the database to form borrowing log information;

[0061] The step 65 specifically includes:

[0062] Step 651, if in the grid list to be returned, click the return button, at this time the program judges the type of the current device, if it is a normal device, step 652 is entered; if it is an RFID device, step 653 is entered;

[0063] Step 652, input the correct number of borrow, the program reads the database borrow log information, data comparison, if the number of borrow and the actual input number is consistent, click the return button, prompt return success, and generate a return record; if the number is inconsistent, click the return button, prompt error, please user check the number;

[0064] Step 653, the user places the RFID equipment with RFID tag near the RFID reader for scanning, compares the scanning number with the database record, if the number is consistent, the return is completed, otherwise an error is prompted; the specific is as follows:

[0065] Display the RFID scanning button, which cannot input the number, click the button, the program sends an open scanning instruction to the serial port of the RFID reader, after receiving the open scanning instruction, the electromagnetic wave of the RFID reader starts to scan the RFID equipment of each frequency band around, the RFID tag sends a signal to the RFID reader, and the RFID equipment with RFID tag to be returned is placed near the RFID reader for detection, at this time the RFID reader sends the scanned tag ID list to the program listener of the operation interface through the serial port, the array length of the tag ID list is taken in the return interface, the return number is assigned, the device ID is assigned as the tag ID, the assigned return number is compared with the database data, if the number is consistent, a prompt window is popped up to prompt the return success, if the number is inconsistent, an error message is prompted, the user needs to repeat the adjustment operation until correct, if missing, the administrator needs to operate and leave a missing note, after the return is completed, the information is also stored to form a return record.

[0066] Further, the step 7 specifically includes:

[0067] The borrow or return operation supports local operation and remote operation, wherein:

[0068] The local operation mode includes:

[0069] 1) The administrator adds a user account through the local interface, and the database adds a user information;

[0070] 2) The user performs local data verification when logging in the application of the intelligent storage cabinet, and completes authentication in an off-network state;

[0071] 3) The database is stored on the storage card of the operation interface, and the data is still retained after the application of the intelligent storage cabinet is uninstalled;

[0072] The remote operation mode includes:

[0073] 1) Pre-configure MQTT information, including client ID, username and password;

[0074] 2) Create an executor as a switch of the application communication between the Internet of Things cloud platform and the smart locker;

[0075] 3) The application of the smart locker establishes an MQTT long connection with the Internet of Things cloud platform through the executor according to the MQTT information;

[0076] 4) The Internet of Things cloud platform issues a control instruction to the application of the smart locker through the executor;

[0077] 5) The application of the smart locker receives the control instruction issued by the Internet of Things cloud platform, and analyzes the control instruction to obtain the number of the target compartment;

[0078] 6) The switch instruction of the target compartment is sent to the dot matrix module through the serial port, and the dot matrix module realizes remote control operation according to the switch instruction of the target compartment;

[0079] 7) Keep the user login state to maintain the running of the MQTT service.

[0080] Further, the local operation mode is to store user data and operation records by using an SQLite embedded database; and the remote operation mode is to realize the transparent transmission of the instructions of the Internet of Things cloud platform through the MQTT protocol.

[0081] Compared with the prior art, the technical scheme has the beneficial effects that:

[0082] The application is mainly applied to the storage of articles, relies on automatic reading of ultra-high frequency, and automatically records the number of devices through the number of ultra-high frequency tags. The number cannot be modified by a user, so that the number of borrowing and returning is consistent, and correct operation can be performed. If the number of devices does not match, the administrator needs to be contacted for operation. The smart locker reduces the management of management personnel and the use of warehouse rooms. The vertical smart locker can be placed in the empty space of a classroom or a corridor, is convenient and simple to operate, and saves the cost and space of a school or an enterprise. Meanwhile, the application supports online and offline modes. If the current environment has WIFI, network connection can be performed on the operation interface. After corresponding information is configured, online opening of a compartment and borrowing of articles are supported, and a person does not need to be present on site. If there is no network, the offline mode can be used to perform on-site operation and article borrowing and returning.

[0083] The application has three main modules: the first is the dot matrix module, which is used to control the grid of the intelligent storage cabinet, and distinguishes the operation of the intelligent storage cabinet through the address code; the second is the operation interface and the RFID reader, which is connected with the operation interface through the serial port, can send instructions, and transmit the instructions to the dot matrix module, and then perform the opening operation of the cabinet; the third is the intelligent storage cabinet, which includes the main cabinet and the auxiliary cabinet, and the main cabinet and the auxiliary cabinet have multiple grids, which are controlled by the dot matrix module.

[0084] The product has the following functions:

[0085] 1. The RFID reader with ultra-high frequency reading and writing is used to identify the number of articles, and the operation of borrowing and returning is performed;

[0086] 2. Through the database, user management, off-network storage of articles and opening operation of the cabinet door are realized;

[0087] 3. The WIFI or 4G module is used to perform the remote opening operation of the cabinet or the off-network storage of articles and the opening operation of the cabinet door;

[0088] 4. The operation interface is connected with the dot matrix module through the serial port, and the opening operation of the corresponding point cabinet is realized; the borrowing and returning operations are recorded, and the corresponding personnel can be found. BRIEF DESCRIPTION OF DRAWINGS

[0089] In order to more clearly illustrate the technical solutions in the embodiments of the application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description only some embodiments of the application, and for those skilled in the art, other drawings can also be obtained without creative labor on the basis of these drawings.

[0090] Fig. 1 It is an execution flow chart of the intelligent storage method based on ultra-high frequency reading and writing provided by the embodiment of the application.

[0091] Fig. 2 It is an intelligent storage system architecture diagram based on ultra-high frequency reading and writing provided by the embodiment of the application.

[0092] Fig. 3 It is a structural schematic diagram of the intelligent storage cabinet provided by the embodiment of the application. DETAILED DESCRIPTION

[0093] The application will be further described in detail below with reference to the accompanying drawings and embodiments. It is particularly pointed out that the following embodiments are only used to illustrate the application, but do not limit the scope of the application. Similarly, the following embodiments are only part of the embodiments of the application, not all embodiments, and all other embodiments obtained by those of ordinary skill in the art without creative labor are within the scope of the application.

[0094] Please refer to Figs. 1-3 The application is an intelligent storage method based on ultra-high frequency reading and writing, comprising the following steps:

[0095] Step 1: The administrator initializes the intelligent storage cabinet and adds the configuration file of the intelligent storage cabinet.

[0096] In this embodiment, step 1 specifically comprises:

[0097] Step 11: The administrator initializes the intelligent storage cabinet; using the intelligent storage cabinet reduces the management of the management personnel and the use of the warehouse room, and the intelligent storage cabinet adopts a vertical structure. The vertical intelligent storage cabinet can be placed in the empty space in the classroom or the corridor, which is convenient and simple to operate, and saves the cost and space for the school or enterprise.

[0098] Step 12: Add the configuration file of the intelligent storage cabinet, which includes MQTT information and the number of cabinets, and the MQTT information includes client ID, username and password.

[0099] Step 13: Bind the configuration file with the intelligent storage cabinet, and store the configuration file and the binding information in the local. According to the number of cabinets, the background data is added. If the MQTT information has not been filled in, only local operation is supported. If the MQTT information is correctly filled in, remote operation is supported.

[0100] Step 2: When starting the application of the intelligent storage cabinet, read the configuration file, generate the intelligent storage cabinet information table, and create the user information table and the administrator account.

[0101] In this embodiment, step 2 specifically comprises:

[0102] Step 21: Open the application of the intelligent storage cabinet, and read the configuration file when starting the application to obtain the number of cabinets.

[0103] Step 22: The database creates and generates the intelligent storage cabinet information table according to the number of cabinets.

[0104] Step 23, according to the smart locker information table, the smart locker is divided into a main cabinet and several sub-cabinets, a plurality of cells are arranged under the main cabinet and the sub-cabinets and are numbered in sequence respectively, and an operation interface and an RFID reader are further arranged in the middle of the main cabinet; for example, there is one main cabinet and one sub-cabinet, which are distinguished by A and B respectively; there are 58 cells under the main cabinet, which are numbered in sequence as A01-A58, and there are 64 cells under the sub-cabinet, which are numbered in sequence as B01-B64. The A serial number is the main cabinet, and the main cabinet occupies 6 cells because of the operation interface and the RFID reader, so the total number of cells is 58, and the total number of cells of the sub-cabinet is 64.

[0105] Step 24, read the MQTT information of the configuration file, and the database creates a user information table according to the MQTT information and adds an administrator account. The process of obtaining the MQTT information is as follows:

[0106] First, log in to the platform http: / / www.nlecloud.com / , if there is no account, you can apply for it, after applying, go to the development to set a key, if there is an account, log in directly. Enter the developer center to add a project, create a project, add a device, input the corresponding information, click the button to determine the addition of the device, and the device will be created, then create the corresponding device according to the set naming method. If you want to increase, name it in alphabetical order. Among them, the client ID of the MQTT information is the device identifier, the username is the device ID, and the password is the SecretKey of the device.

[0107] Step 3, the administrator logs in the account, and after verifying the identity, enters the management interface;

[0108] In this embodiment, the step 3 specifically comprises:

[0109] Step 31, the administrator logs in the account, the database executes a query statement, and compares the account and the password stored in the database with the input account and the password, if the comparison result is consistent, it means that the login is successful, and jumps to the home page; if the comparison result is inconsistent, an error message is prompted;

[0110] Step 32, after the administrator logs in successfully, the background judges whether the logged-in user is an administrator, if yes, the administrator permission is opened, and the management function menu is displayed; if not, the administrator permission is not opened.

[0111] Step 4, the administrator creates type information of the cells in the smart locker, including ordinary cells and RFID cells, and fills the type information of each cell into the corresponding cell;

[0112] In this embodiment, the step 4 specifically comprises:

[0113] Step 41, the administrator creates the type information of each grid in the intelligent locker according to the number of ordinary devices and RFID devices in the device to be stored, including ordinary grid and RFID grid;

[0114] Step 42, using a query statement, read all the grids, select the grid, judge the type of the current grid according to the type information corresponding to the selected grid, if the type of the current grid is ordinary grid, fill in the type information as ordinary grid, the database executes the insert statement, stores the type information of the current grid into the selected grid, and saves it to the database; if the type of the current grid is RFID grid, fill in the type information as RFID grid, the database executes the insert statement, stores the type information of the current grid into the selected grid, and saves it to the database;

[0115] Step 43, bind the ordinary grid with the ordinary device, and bind the RFID grid with the RFID device.

[0116] Step 5, for the RFID grid, the administrator scans the RFID device through the RFID reader, obtains the tag ID and the number, and stores them into the database; repeat step 4 and step 5 until all the required data are recorded into the database, and the database file is not stored in the application of the intelligent locker, but is written into the storage card SD of the operation interface in the form of file stream, so as to ensure that the data will not be cleared when the application is unloaded.

[0117] In the embodiment, the step 5 specifically includes:

[0118] Step 51, for each RFID grid, the operation interface of the intelligent locker generates an RFID scanning instruction, and sends the RFID scanning instruction to the RFID reader through the serial port driver library call serial port;

[0119] Step 52, after the RFID reader receives the RFID scanning instruction, it starts the scanning mode and transmits the radio frequency signal for scanning; the scanning is performed at a speed of 1 time per second, and the frequency of the transmitted radio frequency signal is: 860-960MHz;

[0120] Step 53, the RFID device with RFID tag to be counted is close to the RFID reader, the RFID device obtains energy through electromagnetic induction and activates the chip, and returns the tag data to the RFID reader;

[0121] Step 54, the RFID reader returns the scanned tag data to the operation interface through the serial port;

[0122] Step 55, the operation interface extracts the received tag data to obtain the tag ID and the number, and performs the deduplication processing on the multiple scanning results;

[0123] Step 56, associate the de-duplicated tag ID with the corresponding quantity, and store it to the database, taking the tag ID as the device information of the RFID grid.

[0124] Step 6, after the general user logs in the account, the grid list for borrowing or returning is displayed according to the permission list; when the user selects the borrowing or returning operation, the operation interface sends a control instruction to the dot matrix module through the serial port to control the switch of the corresponding grid, and records the borrowing or returning information to the database;

[0125] In this embodiment, the step 6 specifically comprises:

[0126] Step 61, add a general user, input the basic information of the user and associate the accessible grid permission;

[0127] Step 62, the user inputs the account and password for login, and reads the grid list under the permission of the account after successful login;

[0128] Step 63, the grid list that can be borrowed and the grid list to be returned are classified and displayed according to the state of grid borrowing;

[0129] Step 64, after the user selects the target grid, when entering the borrowing operation, the connection state of the dot matrix module and the serial port is detected, if the connection is normal, the operation interface sends the cabinet opening instruction to the dot matrix module through the serial port, the dot matrix module analyzes the cabinet opening instruction and controls the corresponding grid to open, and feeds back the opening state and records the borrowing log information;

[0130] Step 65, when entering the returning operation, the quantity of the general device is verified, the tag scanning verification of the RFID device is performed, and the operation is completed after the quantity is consistent.

[0131] In this embodiment, the step 61 specifically comprises:

[0132] Step 611, the administrator creates a general user account, inputs the basic information of the user, and the database obtains the list of all grids according to the basic information of the user to display;

[0133] Step 612, after dynamically screening the corresponding grid according to the user permission, the number of the corresponding grid is recorded and stored in the permission field of the user, and the permission field is stored in the format of grid number separated by commas; for example, the format of "A01, A02, B01, B02".

[0134] The step 62 specifically comprises:

[0135] Step 621, the user inputs the account and password for login, and the background compares the account and password stored in the database with the input account and password, if the comparison result is consistent, it means that the login is successful, if the comparison result is inconsistent, it means that the login fails;

[0136] Step 622, after the user logs in successfully, read the grid list under the account permission, enter the home page, get the grid list that can be borrowed and the grid list to be returned, the grid list is the grid number under the account permission;

[0137] The step 63 specifically includes:

[0138] Step 631, data traversal is performed, and according to the state of grid borrowing, the grid list that can be borrowed and the grid list to be returned are screened out for classified display;

[0139] Step 632, all grids are displayed in the form of a card list, and the card contains device name and device quantity;

[0140] Step 633, click the card, and query the details of the grid in the database according to the corresponding grid ID;

[0141] The step 64 specifically includes:

[0142] Step 641, if in the grid list that can be borrowed, click the borrowing button, at this time the program initiates a serial detection command to the dot matrix module connected with the operation interface, if the returned protocol data bit is 00, it represents that the connection is normal, and step 642 is entered; otherwise, it represents that the connection is not normal;

[0143] Step 642, if the operation interface is connected with the dot matrix module through the serial port, the operation interface sends the cabinet opening instruction to the dot matrix module through the serial port, and the content of the cabinet opening instruction includes the address code of the cabinet, the number of the grid and the protocol command for opening the cabinet door;

[0144] Step 643, after the dot matrix module receives the cabinet opening instruction, the corresponding cabinet is found according to the address code of the cabinet, and the corresponding grid on the cabinet is found according to the number of the grid, after the dot matrix module receives the protocol command for opening the cabinet door, the high-level operation is sent, the cabinet door is connected with the level signal, the high-level trigger level signal, at this time the cabinet door of the corresponding grid is automatically opened;

[0145] Step 644, after the cabinet door is opened, the program is returned whether it is opened or not, after the program receives it, the borrowing success is prompted, the borrowing process is completed, and the current time, the current grid number, the device name borrowed and the borrowed device quantity are recorded and stored to the database, forming the borrowing log information;

[0146] The step 65 specifically includes:

[0147] Step 651, if in the grid list to be returned, click the return button, at this time the program judges the type of the current device, if it is a normal device, step 652 is entered; if it is an RFID device, step 653 is entered;

[0148] Step 652, input the correct number of borrow, the program reads the database log information, and compares the data, if the number of borrow is consistent with the actual input number, click the return button, then prompt the return success, and generate a return record; if the number is not consistent, click the return button, then prompt error, please user check the number;

[0149] Step 653, the user places the RFID device with RFID tag near the RFID reader for scanning, compares the scanning number with the database record, if the number is consistent, the return is completed, otherwise, an error is prompted; the specific steps are as follows:

[0150] The RFID scanning button is displayed, and the number cannot be input. Click the button, the program sends an open scanning instruction to the serial port of the RFID reader. After receiving the open scanning instruction, the electromagnetic wave of the RFID reader starts to scan the RFID devices in each frequency band around it. The RFID tag sends a signal to the RFID reader. The RFID device with RFID tag to be returned is placed near the RFID reader for detection. At this time, the RFID reader sends the scanned tag ID list to the program listener of the operation interface through the serial port. The array length of the tag ID list is obtained in the return interface, and the return number is assigned. The tag ID is assigned as the device ID. Since it is a RFID device return, the return number can only be obtained by scanning, and cannot be obtained by input. The assigned return number is compared with the data in the database. If the number is consistent, a prompt window is popped up to prompt the return success. If the number is not consistent, an error message is prompted. The user needs to repeat the adjustment operation until the correct number is obtained. If it is missing, the administrator needs to operate and leave a missing note. After the return is completed, the information is also stored to form a return record.

[0151] The above steps of borrowing and returning will generate corresponding records. According to the logged account ID, the database records of the account are screened out. The data in the data list is traversed and displayed. The data list includes borrowing time, return time, borrowed device, borrowed quantity, borrower and other information.

[0152] Step 7, the borrowing or returning operation supports local operation and remote operation. The local operation is realized by off-network management of the database, and the remote operation is realized by MQTT protocol and Internet of Things cloud platform control.

[0153] In the embodiment, the step 7 specifically includes:

[0154] The borrowing or returning operation supports local operation and remote operation, supports online and offline modes, if the current environment has WIFI, the network connection can be performed on the operation interface, after the corresponding information is configured, the online grid opening and borrowing of articles are supported, and people do not have to go to the site. If there is no network, the offline mode can be used, and the operation is performed on the site to borrow and return articles and the like. Among them:

[0155] The local operation mode includes:

[0156] 1) The administrator adds a user account through the local interface, and the database adds a user information;

[0157] 2) The user performs local data verification when logging in to the application of the intelligent storage cabinet, and completes authentication in an offline state; therefore, the device does not need to be connected to the network and can be used;

[0158] 3) The database is stored on the storage card of the operation interface, and the data is still retained after the application of the intelligent storage cabinet is uninstalled;

[0159] The remote operation mode includes:

[0160] 1) The MQTT information is pre-configured, including the client ID, username and password;

[0161] 2) The executor is created, which is used as a switch for communication between the Internet of Things cloud platform and the application of the intelligent storage cabinet;

[0162] 3) The application of the intelligent storage cabinet establishes an MQTT long connection with the Internet of Things cloud platform according to the MQTT information through the executor;

[0163] 4) The Internet of Things cloud platform issues a control instruction to the application of the intelligent storage cabinet through the executor; the control instruction includes the number of the grid, for example, the first grid of the A cabinet is A01, and the fifth grid of the B cabinet is B05;

[0164] 5) The application of the intelligent storage cabinet receives the control instruction issued by the Internet of Things cloud platform, and analyzes the control instruction to obtain the number of the target grid;

[0165] 6) The serial port sends the opening and closing instruction of the target grid to the dot matrix module, and the dot matrix module realizes remote control operation according to the opening and closing instruction of the target grid;

[0166] 7) The user login state is maintained to maintain the running of the MQTT service, and the connection of data communication is ensured.

[0167] In the embodiment, the local operation mode uses the SQLite embedded database to store user data and operation records; and the remote operation mode realizes the transparent transmission of the instructions of the Internet of Things cloud platform through the MQTT protocol.

[0168] As Fig. 2 shown, the system includes an Internet of Things cloud platform, an application of the intelligent locker, a dot matrix module and the intelligent locker.

[0169] 1. The Internet of Things cloud platform is used for remotely controlling the switch of the intelligent locker.

[0170] 2. The application of the intelligent locker is used for operating the intelligent locker. It includes serial port service, MQTT service, database service and ultra-high frequency service (RFID reader / writer), carries out the reading and writing check of the equipment through the ultra-high frequency service, stores the data into the database, when the user carries out the access operation, calls the serial port service, the serial port service will control the corresponding control signal of the dot matrix module, and then operates the intelligent locker.

[0171] 3. The dot matrix module is mainly responsible for controlling the switch function of each compartment in the intelligent locker. When the application of the intelligent locker sends the instruction to the dot matrix module through the serial port service, the corresponding compartment key information is obtained through the analysis of the protocol, and then the opening operation of the compartment is carried out. The dot matrix module is only responsible for opening, and does not support closing operation.

[0172] 4. The intelligent locker includes one main cabinet 1 and 0-15 sub-cabinets 2 (in this embodiment, one sub-cabinet 2 is adopted). The main cabinet 1 is provided with an operation interface 3 and an RFID reader / writer 4. The intelligent locker is a physical equipment, which can only be controlled through the signal of the dot matrix module, and the cabinet is divided into the main cabinet 1 and the sub-cabinet 2. The main cabinet 1 has 58 compartments, including 8 large compartments and 50 small compartments. The sub-cabinet 2 has 64 compartments, including 8 large compartments and 56 small compartments. Fig. 3 As

[0173] The above only describes some embodiments of the present application, and does not limit the protection scope of the present application. Any equivalent device or equivalent process conversion, or direct or indirect application in other related technical fields, which is based on the content of the specification and drawings, is also included in the patent protection scope of the present application.

Claims

1. A smart storage method based on ultra-high frequency read / write, characterized in that, Includes the following steps: Step 1: The administrator initializes the smart locker and adds the configuration file for the smart locker; Step 2: When starting the smart locker application, read the configuration file, generate the smart locker information table, and create the user information table and administrator account; Step 3: The administrator logs in to the account, verifies their identity, and then enters the management interface; Step 4: The administrator creates the type information of the compartments in the smart locker, including ordinary compartments and RFID compartments, and fills in the type information of each compartment into the corresponding compartment. Step 5: For RFID grids, the administrator scans the RFID device with an RFID reader to obtain the tag ID and quantity, and stores it in the database; repeat steps 4 and 5 until all the required data is entered into the database. Step 6: After a regular user logs in, the list of borrowed or returned grid cells is displayed according to the permission list. When a user selects to borrow or return a grid cell, the operation interface sends control commands to the dot matrix module via the serial port to control the opening and closing of the corresponding grid cell and records the borrowing or returning information to the database. Step 7: Borrowing or returning operations support both local and remote operations. Local operations are managed offline through a database, while remote operations are controlled via the IoT cloud platform through the MQTT protocol.

2. The intelligent storage method based on ultra-high frequency read / write as described in claim 1, characterized in that, Step 1 specifically includes: Step 11: The administrator initializes the smart locker; Step 12: Add a configuration file for the smart locker. The configuration file includes MQTT information and the number of lockers. The MQTT information includes the client ID, username, and password. Step 13: Bind the configuration file to the smart locker and store the configuration file and binding information locally.

3. The intelligent storage method based on ultra-high frequency read / write as described in claim 2, characterized in that, Step 2 specifically includes: Step 21: Open the smart locker application. When the application starts, read the configuration file to get the number of lockers. Step 22: The database creates and generates a smart locker information table based on the number of lockers; Step 23: According to the smart locker information table, divide the smart locker into one main locker and several auxiliary lockers. Set up multiple compartments under the main locker and auxiliary lockers and number them in sequence. The main locker also has an operation interface and an RFID reader in the middle. Step 24: Read the MQTT information from the configuration file. The database creates a user information table based on the MQTT information and adds an administrator account.

4. The intelligent storage method based on ultra-high frequency read / write as described in claim 1, characterized in that, Step 3 specifically includes: Step 31: The administrator logs in to the account, executes a query statement in the database, and compares the username and password stored in the database with the entered username and password. If the comparison results match, the login is successful and the user is redirected to the homepage; if the comparison results do not match, an error message is displayed. Step 32: After the administrator logs in successfully, the backend determines whether the logged-in user is an administrator. If the user is an administrator, administrator privileges are granted and the management function menu is displayed; otherwise, administrator privileges are not granted.

5. The intelligent storage method based on ultra-high frequency read / write as described in claim 1, characterized in that, Step 4 specifically includes: Step 41: The administrator creates type information for each compartment in the smart locker based on the number of ordinary devices and RFID devices among the devices to be stored, including ordinary compartments and RFID compartments; Step 42: Use a query statement to read all the cells, select the cells, and determine the type of the current cell based on the type information corresponding to the selected cell. If the current cell is a normal cell, fill in the type information as normal cell, execute an insert statement to store the type information of the current cell into the selected cell, and save it to the database; if the current cell is an RFID cell, fill in the type information as RFID cell, execute an insert statement to store the type information of the current cell into the selected cell, and save it to the database. Step 43: Bind the ordinary grid to the ordinary device, and bind the RFID grid to the RFID device.

6. The intelligent storage method based on ultra-high frequency read / write as described in claim 3, characterized in that, Step 5 specifically includes: Step 51: For each RFID cell, the smart locker's operation interface generates an RFID scanning command, and sends the RFID scanning command to the RFID reader / writer by calling the serial port through the serial port driver library. Step 52: After receiving the RFID scanning command, the RFID reader starts the scanning mode and transmits radio frequency signals to scan; Step 53: Bring the RFID devices with RFID tags that need to be inventoried close to the RFID reader. The RFID devices obtain energy through electromagnetic induction and activate the chip, returning the tag data to the RFID reader. Step 54: The RFID reader transmits the scanned tag data back to the operation interface via the serial port; Step 55: The operation interface extracts the received tag data to obtain the tag ID and quantity, and performs deduplication on multiple scan results. Step 56: Associate the deduplicated tag ID with the corresponding quantity and store it in the database, using the tag ID as the device information for that RFID grid.

7. The intelligent storage method based on ultra-high frequency read / write as described in claim 1, characterized in that, Step 6 specifically includes: Step 61: Add a new regular user, enter the user's basic information and associate the access permissions of the grid cells; Step 62: The user enters their account and password to log in. After successful login, the list of cells under the account's permissions is read. Step 63: Based on the status of the borrowed grids, display the list of grids that can be borrowed and the list of grids that need to be returned; Step 64: After the user selects the target cell and enters the borrowing operation, the connection status between the dot matrix module and the serial port is checked. If the connection is normal, the operation interface sends the opening command to the dot matrix module through the serial port. After the dot matrix module parses the opening command, it controls the corresponding cell to open and feeds back the opening status and records the borrowing log information. Step 65: When entering the return operation, verify the quantity of ordinary devices and verify the tag scanning of RFID devices. The operation is completed after the quantity matches.

8. The intelligent storage method based on ultra-high frequency read / write as described in claim 7, characterized in that, Step 61 specifically includes: Step 611: The administrator creates a regular user account, enters the user's basic information, and the database retrieves and displays a list of all cells based on the user's basic information. Step 612: After dynamically filtering the corresponding cells according to user permissions, record the cell number and store it in the user's permission field. The permission field is stored in the cell number format separated by commas. Step 62 specifically includes: Step 621: The user enters their username and password to log in. The backend compares the username and password stored in the database with the entered username and password. If the comparison results match, the login is successful; if the comparison results do not match, the login fails. Step 622: After the user successfully logs in, read the grid list under the account's permissions. After entering the homepage, obtain the list of grids that can be borrowed and the list of grids to be returned. This grid list is the grid number under the account's permissions. Step 63 specifically includes: Step 631: Perform data traversal, and based on the status of the borrowed grids, filter out the list of grids that can be borrowed and the list of grids that need to be returned, and display them in categories. Step 632: All cells are displayed as a card list, with each card containing the device name and the number of devices. Step 633: Click on the card and retrieve the details of the corresponding cell from the database based on the cell ID; Step 64 specifically includes: Step 641: If the available grid is in the list of available grids, click the borrow button. At this time, the program sends a serial port detection command to the dot matrix module connected to the operation interface. If the returned protocol data bit is 00, it means the connection is normal and proceed to step 642; otherwise, it means the connection is not normal. Step 642: The operation interface is connected to the dot matrix module via a serial port. The operation interface sends the cabinet opening command to the dot matrix module via the serial port. The content of the cabinet opening command includes the cabinet address code, the cell number and the protocol command to open the cabinet door. Step 643: After receiving the cabinet opening command, the dot matrix module finds the corresponding cabinet according to the cabinet address code, and then finds the corresponding cell on the cabinet according to the cell number. After receiving the protocol command to open the cabinet door, the dot matrix module sends a high-level operation. The cabinet door is connected to the level signal, and the high-level trigger signal is activated. At this time, the cabinet door of the corresponding cell opens automatically. Step 644: After opening the cabinet door, return the status of whether it is open to the program. After receiving the status, the program will prompt that the borrowing is successful, complete the borrowing process, and store the current time, current cabinet number, borrowed equipment name and borrowed equipment quantity in the database to form borrowing log information. Step 65 specifically includes: Step 651: If the cell is in the list of cells to be returned, click the return button. At this time, the program determines the type of the current device. If it is a regular device, proceed to step 652; if it is an RFID device, proceed to step 653. Step 652: Enter the correct borrowing quantity. The program reads the borrowing log information from the database and compares the data. If the borrowing quantity matches the actual input quantity, clicking the return button will prompt a successful return and generate a return record. If the quantity does not match, clicking the return button will prompt an error and ask the user to verify the quantity. Step 653: The user places the RFID device with the RFID tag near the RFID reader for scanning. The scanned quantity is compared with the database record. If the quantity matches, the return is complete; otherwise, an error is displayed. Details are as follows: The RFID scan button is displayed, but the quantity cannot be entered. Clicking the button sends an "Start Scan" command to the RFID reader's serial port. Upon receiving the command, the RFID reader begins scanning for RFID devices on various frequency bands in the vicinity. RFID tags send signals to the reader. The RFID device to be returned is placed near the reader for detection. The reader then sends a list of scanned tag IDs to the program listener on the user interface via serial port. The return interface retrieves the array length of the tag ID list, assigns it the return quantity, and assigns the tag ID the device ID. The returned quantity is compared with the database. If the quantities match, a pop-up window indicates successful return; otherwise, an error message is displayed, requiring the user to repeat the process until correct. If any items are missing, the administrator must be contacted, and a record of the loss must be kept. After the return is complete, the information is stored to create a return record.

9. The intelligent storage method based on ultra-high frequency read / write as described in claim 1, characterized in that, Step 7 specifically includes: Borrowing or returning operations support both local and remote operations, among which: Local operation modes include: 1) When an administrator adds a user account through the local interface, a new user record is added to the database; 2) When users log in to the smart locker application, local data verification is performed, and authentication is completed in offline mode; 3) The database is stored on the memory card in the operating interface, and the data is still retained after the smart locker application is uninstalled; Remote operation modes include: 1) Pre-configure MQTT information, including client ID, username, and password; 2) Create an actuator to act as a communication adapter between the IoT cloud platform and the smart locker; 3) The application of smart lockers establishes a long MQTT connection with the IoT cloud platform through actuators based on MQTT information; 4) The IoT cloud platform sends control commands to the smart locker application through actuators; 5) The application of smart lockers receives control commands from the Internet of Things cloud platform and parses the control commands to obtain the number of the target compartment; 6) Send the on / off command of the target cell to the dot matrix module via serial port, and the dot matrix module realizes remote control operation according to the on / off command of the target cell; 7) Keep users logged in to maintain the MQTT service running.

10. The intelligent storage method based on ultra-high frequency read / write as described in claim 9, characterized in that, The local operation mode uses an embedded SQLite database to store user data and operation records; the remote operation mode uses the MQTT protocol to transmit commands through the IoT cloud platform.

Images