CN112867148B - Positioning method and system for employee seat, electronic device and storage medium - Google Patents
Positioning method and system for employee seat, electronic device and storage medium Download PDFInfo
- Publication number
- CN112867148B CN112867148B CN202110181432.7A CN202110181432A CN112867148B CN 112867148 B CN112867148 B CN 112867148B CN 202110181432 A CN202110181432 A CN 202110181432A CN 112867148 B CN112867148 B CN 112867148B
- Authority
- CN
- China
- Prior art keywords
- self
- seat
- target
- employee
- maintenance
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W64/00—Locating users or terminals or network equipment for network management purposes, e.g. mobility management
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
- H04W4/02—Services making use of location information
- H04W4/029—Location-based management or tracking services
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
- H04W4/30—Services specially adapted for particular environments, situations or purposes
- H04W4/33—Services specially adapted for particular environments, situations or purposes for indoor environments, e.g. buildings
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Telephonic Communication Services (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
The invention discloses a positioning method and a system of staff seats, electronic equipment and a storage medium, wherein the positioning method is used for positioning the staff seats in a plurality of office areas, and each office area is provided with a plurality of wireless relay devices; the positioning method comprises the following steps: acquiring log information generated by wireless connection between terminal equipment and the wireless relay equipment, wherein the log information comprises an MAC (media access control) address of the terminal equipment; and if the MAC address corresponds to a target employee, determining the office area of the seat of the target employee according to the position of the wireless relay equipment. According to the invention, the office area where the staff seats corresponding to the terminal equipment are located is positioned according to the connection condition of the terminal equipment and the wireless relay equipment, so that a better solution is provided for the staff seats in medium and large-sized office places, which are lagged in updating and difficult to maintain.
Description
Technical Field
The invention belongs to the technical field of indoor positioning, and particularly relates to a positioning method, a positioning system, positioning equipment and a storage medium for an employee seat.
Background
With the increasing demand of mobile office, more and more enterprises prefer to configure a notebook computer for employees to replace a desktop computer, however, due to the portability of the notebook computer, many employees rarely access the intranet through a network cable even in a company, but directly access the intranet through a wireless network. When the computer needs to be opened or moved, the network cable does not need to be plugged and pulled out. The problem with this is the increased difficulty of maintaining staff seats.
In a large-medium enterprise, a maintenance entrance is generally provided to allow employees themselves or an organization administrator to maintain seat information for employees under an organization, but the maintenance method has obvious defects: the staff's seat is not a constant one, and changes occur to the staff's seat as management changes or staff movement. The layout distribution of the seats is not durable, and local or whole seats can be moved along with the business adjustment or office area adjustment of a company; the interchange of the personnel and the main station is also not uncommon. The adjusted seat number is also adjusted, and the physical seat table possibly used by the staff is not changed, but the floor and the seat position are completely inconsistent. Under the condition, the staff is required to update the seat information in the related system, but the staff does not necessarily remember to update the seat at the moment, and a lot of recorded seat information becomes outdated after a long time, so that people cannot be found, misguidance is generated, and the difficulty in finding people is increased.
Disclosure of Invention
The invention provides a method, a system, equipment and a storage medium for positioning an employee seat, and aims to overcome the defect that the employee seat cannot be updated in time in the prior art.
The invention solves the technical problems through the following technical scheme:
the invention provides a positioning method of staff seats, which is used for positioning the staff seats in a plurality of office areas, wherein each office area is provided with a plurality of wireless relay devices; the positioning method comprises the following steps:
acquiring log information generated by wireless connection between terminal equipment and the wireless relay equipment, wherein the log information comprises a Media Access Control (MAC) Address of the terminal equipment;
and if the MAC address corresponds to a target employee, determining the office area of the seat of the target employee according to the position of the wireless relay equipment.
Preferably, the step of determining the office area of the target employee's seat according to the location of the wireless relay device further comprises:
and if the office area is different from the pre-stored office area of the seat of the target employee, sending a self-maintenance page entry to the terminal equipment, wherein the self-maintenance page entry is used for prompting the target employee to perform self-maintenance operation on the position of the seat.
Preferably, if the target employee responds to the self-maintenance page entry within the effective time and performs self-maintenance operation, determining the position of the seat of the target employee according to the self-maintenance operation;
and/or the presence of a gas in the gas,
if the target staff do not respond to the self-maintenance page entrance within the effective time, the self-maintenance page entrance is invalid, and broadcast information comprising the target staff and the office area is generated;
and/or the presence of a gas in the atmosphere,
after the step of determining the seat position of the seat of the target employee according to the self-maintenance operation, the method further comprises the following steps:
and if the terminal equipment is accessed to the network in a wired mode, re-determining the seat position according to the port number used when the terminal equipment is accessed to the network.
Preferably, the step of re-determining the seat position further comprises:
and if the terminal equipment is wirelessly connected with the wireless relay equipment again, determining the seat position again according to the self-maintenance operation.
Preferably, after the step of obtaining the log information generated by the wireless connection between the terminal device and the wireless relay device, the method further includes:
according to the log information, counting a historical connection record, wherein the historical connection record comprises connection time and/or connection times of the terminal equipment and a plurality of wireless relay equipment respectively;
determining a target wireless relay device according to the historical connection record;
determining the office area of the seats of the target employees according to the position of the target wireless relay equipment;
and/or the presence of a gas in the gas,
and if a self-maintenance request sent by the terminal equipment is received, sending a self-maintenance page entry to the terminal equipment for prompting the terminal equipment to carry out self-maintenance operation.
The invention also provides a positioning system of the staff seats, which is used for positioning the staff seats in a plurality of office areas, wherein each office area is provided with a plurality of wireless relay devices; the positioning system includes:
the system comprises a log acquisition module, a log acquisition module and a log processing module, wherein the log acquisition module is used for acquiring log information generated by wireless connection between terminal equipment and the wireless relay equipment, and the log information comprises an MAC (media access control) address of the terminal equipment;
and the positioning module is used for determining the office area of the seat of the target staff according to the position of the wireless relay equipment when the MAC address corresponds to the working hours of the target staff.
Preferably, the positioning system further comprises:
and the self-maintenance module is used for sending a self-maintenance page inlet to the terminal equipment when the office area is different from the pre-stored office area of the seat of the target employee, wherein the self-maintenance page inlet is used for prompting the target employee to carry out self-maintenance operation on the position of the seat.
Preferably, if the target employee responds to the self-maintenance page entry within the effective time and performs a self-maintenance operation, the positioning module is further configured to determine an agent position of an agent of the target employee according to the self-maintenance operation;
and/or the presence of a gas in the gas,
if the target staff does not respond to the self-maintenance page entry within the effective time, the self-maintenance module is further used for enabling the self-maintenance page entry to be invalid, and the positioning module is further used for generating broadcast information comprising the target staff and the office area;
and/or the presence of a gas in the gas,
and if the terminal equipment is accessed to the network in a wired mode, the positioning module is also used for re-determining the seat position according to the port number used when the terminal equipment is accessed to the network.
Preferably, if the terminal device is wirelessly connected with the wireless relay device again, the positioning module is further configured to determine the seat position again according to the self-maintenance operation.
Preferably, the positioning system further comprises:
the statistical module is used for counting historical connection records according to the log information, wherein the historical connection records comprise connection time and/or connection times of the terminal equipment and the wireless relay equipment respectively;
the determining module is used for determining target wireless relay equipment according to the historical connection record;
the positioning module is also used for determining the office area of the seat of the target employee according to the position of the target wireless relay equipment;
and/or the presence of a gas in the gas,
and if the self-maintenance request sent from the terminal equipment is received, the self-maintenance module is also used for sending a self-maintenance page inlet to the terminal equipment and prompting a user staff of the terminal equipment to carry out self-maintenance operation on the position of the user staff.
The invention also provides electronic equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the positioning method of the employee seat when executing the computer program.
The invention also provides a computer-readable storage medium on which a computer program is stored, which, when executed by a processor, carries out the steps of the method for positioning an employee seat as described above.
The positive progress effects of the invention are as follows: compared with the prior art, the invention provides a positioning method, a system, equipment and a storage medium for staff seats, which are used for determining the corresponding relation between terminal equipment and target staff by acquiring the connection log information of the terminal equipment and the wireless relay equipment and determining the office area where the seat position of the target staff corresponding to the terminal equipment is located based on the position of the wireless relay equipment, thereby providing a better solution for the late update and difficult maintenance of the staff seat position in a medium-large office place.
Drawings
Fig. 1 is a flowchart of a method for positioning an employee seat according to embodiment 1 of the present invention.
Fig. 2 is a schematic diagram of a self-maintenance page entry in embodiment 1 of the present invention.
Fig. 3 is a schematic diagram of a self-maintenance page in embodiment 1 of the present invention.
Fig. 4 is a schematic block diagram of a positioning system of an employee seat according to embodiment 2 of the present invention.
Fig. 5 is a block diagram of an electronic device according to embodiment 3 of the present invention.
Detailed Description
The invention is further illustrated by the following examples, which are not intended to limit the scope of the invention.
Example 1
Referring to fig. 1 to 3, the present embodiment specifically provides a method for locating employee seats, which is used to locate employee seats in a plurality of office areas, where each office area is provided with a plurality of wireless relay devices. The wireless relay device in this embodiment may be an AP (Access Point, wireless Access Point), an AC (Access Controller, wireless Access Controller), and the like; when the equipment with the wireless connection function initiates wireless connection with the wireless relay equipment, a record is left in a log file of the wireless relay equipment; if the connection is successful, the record includes information such as specific network address and hardware address of the device. The single AP coverage range for non-bridging mode is typically around 20 meters; i.e. a certain office area on a certain floor can be covered. Office areas with a larger range in the same floor can be well distinguished by the characteristic of the AP for office areas across floors, buildings and even regions.
The positioning method of the employee seat in the embodiment comprises the following steps:
s1, acquiring log information generated by wireless connection between a terminal device and the wireless relay device, wherein the log information comprises an MAC address of the terminal device.
And S2, if the MAC address corresponds to a target employee, determining the office area of the seat of the target employee according to the position of the wireless relay equipment.
In step S1, the authentication log information generated and stored on the wireless relay device when the terminal device of the employee accesses the network through WIFI (wireless fidelity access), where the log information certainly includes the AP name and also includes, but is not limited to, the MAC address of the terminal device recorded during connection. In the step S2, the uniqueness of the MAC address of the terminal device may be utilized to perform matching query on the MAC address and the database of the employee full-scale terminal device; the database usually records employee ID (identity authentication) numbers, IP (network address) addresses of employee devices, MAC addresses, and the like; once the MAC address of the terminal device in the log information exists in the database, the possibility that the terminal device is a device such as a private mobile phone of the employee is eliminated, otherwise, the terminal device, as a work terminal registered in the register and belonging to the employee, may be regarded as a direct correspondence to the employee's seat, and thus the location of the terminal device may also correspond to the location of the employee's seat.
Further in step S2, the position of the employee' S seat may also be determined by the wireless relay device. For example, the names of the APs are queried and matched in the total information database of the APs, and because the positions of the APs during installation are well documented or can be accurately registered at any time after installation and maintenance, the records are stored in the total information database of the APs, the positions of the seats of the employees can be determined by obtaining the association relationship between the seats of the employees and the APs. Since the indoor positioning accuracy of the AP is limited as described above, at least the office area where the employee's seat is located can be obtained.
In a specific example, firstly, standardizing the seats of all the offices by establishing a unified standard, for example, defining the positions of the seats at a city level until the buildings, the floors and specific numbers are subdivided, of course, as known to those skilled in the art, the wireless relay devices are not limited to the APs and the AC devices, and the division of the preset positions of the wireless relay devices is not limited to the cities or the floors; the specific data format in this example is shown in table 1:
table 1: staff seat standard watch
| City | Region(s) | Floor level | Seat number |
| Shanghai | SHALK | 12#03F | 12#03F111 |
The total information of the AP devices deployed in each office area includes, in addition to the host name, the area in table 1 and the correspondence relationship between the area and the standardized agent number. For example, if an AP is located above agent 12#03111, its location is recorded as 12#03111, and if not, the nearest agent may be selected as its location according to the principle of proximity, so that the location of each AP may be discriminated by the zone + agent number, and the specific key field refers to table 2:
table 2: AP full information table
| AP name | City | Region(s) | Floor level | Seat number |
| WAP6803 | Shanghai | SHALK | 12#03F | 12#03F111 |
And reading log information acquired by the AP equipment and used for user authentication of the terminal equipment connected with the AP equipment, and sending the log information to a corresponding subject in Kafka (a distributed publish-subscribe message system) for a downstream consumer to consume the latest log data in real time.
Usually, the whole log information is a JSON (text format) character string, and the required information needs to be analyzed by matching through a regular expression. For example, a log message as follows:
"message":"Aug 17 12:07:40 10.38.255.5 2020-08-17 12:07:39.200.1+08:00SWI2744HW12708-ACU％％01CM/5/USER_ACCESSRESULT(s)[3849425]:[WLAN_STA_INFO_AUTHENTICATION]ACMAC:0c-45-ba-18-ec-35；ACNAME:SWI2744HW12708-ACU；APMAC:9c-37-f4-7b-70-80；APNAME:WAP683HW5030；SSID:CORP；RADIOID:1；USER:zhangsan@trip.com；MAC:b8-c1-11-a8-8f-e3；IPADDRESS:192.168.1.22；TIME:1597637259；ZONE:UTC+0800；DAYLIGHT:false；ERRCODE:0；RESULT:success；USERGROUP:CORP-nonAD；AUTHENPLACE:RADIUS；CIB ID:143096；INTERFACE:Wlan-Dbss21205；ACCESS TYPE:802.1x；VLAN:40；",
"type":"WiFi_WLAN",
"hostname":"WAP6803",
"path":"/var/log/network_syslog.log",
"timestamp":1597637265930。
for the above log information, the MAC address of the AP is obtained by regular expression APMAC (# is) matching as 9c-37-f4-7b-70-80. The AP name is obtained similarly as WAP6803, as well as SSID (network name), IP address, timestamp, and other information. And comparing the equipment MAC address with the employee full terminal equipment database to determine whether the current MAC address is the terminal equipment of the currently registered employee or not, and further acquiring other information of the terminal equipment for analysis and use.
As a preferred embodiment, step S2 is followed by:
and if the office area is different from the pre-stored office area of the seat of the target employee, sending a self-maintenance page entry to the terminal equipment, wherein the self-maintenance page entry is used for prompting the target employee to perform self-maintenance operation on the position of the seat.
As described above, when it is determined that the office area where the position of the employee is located has changed, it indicates that the position of the employee has the necessity of re-maintenance and positioning, and therefore, a self-maintenance page entry is sent to the terminal device to prompt the target employee corresponding to the terminal device to perform self-maintenance operation on the position of the employee, and the form of the self-maintenance page entry may be flexibly set as a WEB page link or a WEB page floating layer according to a carrier where the page is located, such as an APP (application) end, a WEB (WEB page) end, an H5 (page form), and the like. After receiving the self-maintenance page entrance, the employee can enter the self-maintenance page to maintain and modify the relevant information through direct confirmation or identity verification. Of course, other related notification mechanisms such as mail or chat software may also be triggered to notify the employee that the AP has been connected to more times recently and the location of the AP. Still further, referring to FIG. 2, options may be provided to go to modify or not to modify.
In a preferred embodiment, referring to fig. 3, if the target employee responds to the self-maintenance page entry within the validity time and performs the self-maintenance operation, the position of the agent of the target employee is determined based on the self-maintenance operation. And if the target staff do not respond to the self-maintenance page entrance within the effective time, the self-maintenance page entrance is invalid, and broadcast information comprising the target staff and the office area is generated.
As described above, a token mechanism is used to perform a preset time for the self-maintenance page entry, for example, 3 hours, within the preset time, the target employee clicks the confirmation modification at the self-maintenance page entry and goes to the self-maintenance page to modify the position information, and then the modified position is used as a new seat position of the target employee, in the process, after the operator inputs a seat number, information such as a relevant city and a floor can be retrieved in real time according to standardized seat data to achieve quick entry, and the state of a relevant record is updated to be modified. If the target employee responds to the self-maintenance page entry within the preset time, but selects 'no modification', the employee considers that the agent does not need to be modified, so that only the events which do not need to be modified are saved, and the rest can be processed without any treatment.
In another situation, if the employee does not make any response including confirmation of the modification and no modification, the embodiment adopts a mode of automatically pushing the acquired AP location and the information of the target employee, for example, the office area of the target employee is provided to downstream consumption of the system according to the AP location or pushed to other colleagues as a broadcast as a reference.
As a preferred embodiment, the step of determining the seat position of the target employee's seat based on the self-maintenance operation further comprises: and if the terminal equipment is accessed to the network in a wired mode, re-determining the seat position according to the port number used when the terminal equipment is accessed to the network. After the seat position is determined again, the method further comprises the following steps: and if the terminal equipment is wirelessly connected with the wireless relay equipment again, determining the seat position again according to the self-maintenance operation.
In this embodiment, a mechanism for locating a wired network access situation of the terminal device is further provided, that is, the position of the agent is re-determined according to a port number used when the terminal device accesses the network. Certainly, those skilled in the art can know that the wired network can be correspondingly bound by the switch and the MAC address of each registered terminal device when being connected; the port number may be pre-allocated and pre-stored in the database, for example, the port number may be associated in a field form of a man-machine-port number, and according to the matching operation, the seat position of the corresponding terminal device may be determined by the port number, so as to determine the seat position of the target employee to which the terminal device belongs. Accordingly, the position of the seat determined at this time naturally also covers the position of the seat of the target employee determined by the self-maintenance operation described above. But the determined agent position and the corresponding time stamp information are still reserved.
Further, in a case where an employee may use his/her own notebook to perform wired network access in a seat of another person, since the actual seat position is not changed, when the target employee returns to his/her own seat and performs wireless network access, the seat position in the self-maintenance operation result is called again as the current seat position of the target employee.
As a preferred embodiment, after the step of obtaining the log information generated by the wireless connection between the terminal device and the wireless relay device, a historical connection record may be counted according to the log information, where the historical connection record includes information such as connection time and connection times of the terminal device and the wireless relay devices, respectively; and determining the target wireless relay equipment according to the historical connection records, and further determining the office area of the seat of the target employee according to the position of the target wireless relay equipment. Specifically, the target wireless relay device can be determined by analyzing data such as connection time and connection times of the employee terminal to the AP at regular time; examples may include, but are not limited to: taking the AP with the maximum connection frequency of the terminal equipment in the last three days as target wireless relay equipment; or taking the AP connected last time as the target wireless relay equipment; or an AP having the most connection times out of the last 10 days and the authentication times exceeding 5 times is used as a target wireless relay apparatus. And the selected target wireless relay equipment can be ensured to have higher coupling degree to the association of the employee seat positions according to different application scenes. Of course, those skilled in the art will appreciate that the basis for determining the target wireless relay device herein includes, but is not limited to, one or a combination of several other defined conditions, such as connection time, connection times, connection status, and employee job status.
As a preferred embodiment, if a self-maintenance request sent by a terminal device is received, a self-maintenance page entry is sent to the terminal device for prompting the terminal device to perform self-maintenance operation.
In this embodiment, besides prompting the staff according to the acquired information, a mechanism for automatically applying for maintenance of the seat position is provided for the staff. For example, a channel for self-service maintenance application is opened for a staff using wireless internet access, when a self-maintenance request sent from a terminal device is received, for example, wildcard characters such as "weihu", "seat" and the like are set in instant chat software, and once the characters are received, the staff to which the terminal user belongs is considered to have made an application for active maintenance, and a corresponding self-maintenance page entry is provided. In this case, it is ensured that the employee has the maintenance right for the seat position by assisting with the verification information such as the employee password or the face matching.
In the embodiment, the office area where the staff seat corresponding to the terminal device is located according to the connection condition of the terminal device and the wireless relay device, so that the self-maintenance operation of locating the position of the staff seat is reasonably prompted and given to the staff, and the approximate area of the position of the staff seat is given to prompt other staff when the staff performs the self-maintenance operation on time; and provides a resolution mechanism for acquiring conflicts between the positions of the employee agents through a port accessing the wired network and a self-maintenance operation. The positioning method of the staff seat provides a better solution for the lag of staff seat update and the difficulty in maintenance in large and medium-sized office places.
Example 2
Referring to fig. 4, the present embodiment specifically provides a positioning system for staff seats, where the positioning system is used to position the staff seats in multiple office areas, where each office area is provided with a plurality of wireless relay devices. The wireless relay device in this embodiment may be an AP, an AC, or the like; when the equipment with the wireless connection function initiates wireless connection with the wireless relay equipment, a record is left in a log file of the wireless relay equipment; if the connection is successful, the record includes information such as specific network address and hardware address of the device. The single AP coverage range for non-bridging mode is typically around 20 meters; i.e. a certain office area on a certain floor can be covered. Office areas with a larger range on the same floor can be better distinguished by the characteristic of the AP for office areas across floors, buildings and even regions. The positioning system of the staff seat of the embodiment comprises:
the system comprises a log obtaining module 1, a log obtaining module and a log sending module, wherein the log obtaining module is used for obtaining log information generated by wireless connection between terminal equipment and the wireless relay equipment, and the log information comprises an MAC (media access control) address of the terminal equipment;
and the positioning module 2 is used for determining the office area of the seat of the target staff according to the position of the wireless relay equipment when the MAC address corresponds to the working hours of the target staff.
The log obtaining module 1 obtains authentication log information which is generated when the terminal device of the employee accesses the network through the WIFI and is stored on the wireless relay device, and the log information certainly includes an AP name and also includes, but is not limited to, an MAC address of the terminal device recorded when the connection is performed. The uniqueness of the MAC address of the terminal equipment can be utilized to carry out matching query on the terminal equipment and a database of the staff total terminal equipment; the database usually records employee ID number, IP address of employee equipment, MAC address and the like; once the MAC address of the terminal device in the log information exists in the database, the possibility that the terminal device is a device such as a private mobile phone of the employee is eliminated, otherwise, the terminal device, as a work terminal registered in the register and belonging to the employee, may be regarded as a direct correspondence to the employee's seat, and thus the location of the terminal device may also correspond to the location of the employee's seat.
The positioning module 2 can determine the position of the employee seat through the wireless relay device. For example, the names of the APs are queried and matched in the total information database of the APs, and because the positions of the APs during installation are well documented or can be accurately registered at any time after installation and maintenance, the records are stored in the total information database of the APs, the positions of the seats of the employees can be determined by obtaining the association relationship between the seats of the employees and the APs. Since the indoor positioning accuracy of the AP is limited as described above, at least the office area where the employee's seat is located can be obtained.
In a specific example, firstly, standardizing the seats of all office places by establishing a unified standard, for example, defining the positions of the seats at a city level until the seats are subdivided into buildings, floors and specific numbers, and of course, as known to those skilled in the art, the wireless relay devices are not limited to the APs and the AC devices, and the division of the preset positions of the wireless relay devices is not limited to the cities or the floors; the specific data format in this example is shown in table 1:
table 1: staff seat standard watch
| City | Region(s) | Floor level | Seat number |
| Shanghai | SHALK | 12#03F | 12#03F111 |
The total information of the AP devices deployed in each office area includes, in addition to the host name, the area in table 1 and the correspondence relationship between the area and the standardized agent number. For example, if an AP is located above agent 12#03111, its location is recorded as 12#03111, and if not, the nearest agent may be selected as its location according to the principle of proximity, so that the location of each AP may be discriminated by the zone + agent number, and the specific key field refers to table 2:
table 2: AP full information table
| AP name | City | Region(s) | Floor level | Seat number |
| WAP6803 | Shanghai | SHALK | 12#03F | 12#03F111 |
And reading the log information which is acquired by the AP equipment and used for user authentication by the terminal equipment connected with the AP equipment, and sending the log information to a corresponding theme in Kafka for a downstream consumer to consume the latest log data in real time.
Usually, the whole log information is a JSON character string, and the required information needs to be analyzed by matching through a regular expression. For example, a log message as follows:
"message":"Aug 17 12:07:40 10.38.255.5 2020-08-17 12:07:39.200.1+08:00SWI2744HW12708-ACU％％01CM/5/USER_ACCESSRESULT(s)[3849425]:[WLAN_STA_INFO_AUTHENTICATION]ACMAC:0c-45-ba-18-ec-35；ACNAME:SWI2744HW12708-ACU；APMAC:9c-37-f4-7b-70-80；APNAME:WAP683HW5030；SSID:CORP；RADIOID:1；USER:zhangsan@trip.com；MAC:b8-c1-11-a8-8f-e3；IPADDRESS:192.168.1.22；TIME:1597637259；ZONE:UTC+0800；DAYLIGHT:false；ERRCODE:0；RESULT:success；USERGROUP:CORP-nonAD；AUTHENPLACE:RADIUS；CIB ID:143096；INTERFACE:Wlan-Dbss21205；ACCESS TYPE:802.1x；VLAN:40；",
"type":"WiFi_WLAN",
"hostname":"WAP6803",
"path":"/var/log/network_syslog.log",
"timestamp":1597637265930。
for the above log information, the MAC address of the AP is obtained by regular expression APMAC (# is) matching as 9c-37-f4-7b-70-80. The AP name is obtained similarly as WAP6803, along with SSID, IP address, timestamp, and other information. The MAC address of the device is compared with the database of the staff total terminal devices, so that whether the current MAC address is the terminal device of the registered staff or not can be determined, and other information of the terminal device can be further acquired for analysis and use.
As a preferred embodiment, the positioning system further includes a self-maintenance module 3, configured to send a self-maintenance page entry to the terminal device when the office area is different from the office area of a pre-stored target employee's seat, where the self-maintenance page entry is used to prompt the target employee to perform self-maintenance operation on the seat position of the seat.
As described above, when it is determined that the office area where the position of the employee is located has changed, it indicates that the position of the employee has the necessity of re-maintenance and positioning, and therefore, the self-maintenance module 3 sends the self-maintenance page entry to the terminal device to prompt the target employee corresponding to the terminal device to perform self-maintenance operation on the position of the employee, and the form of the self-maintenance page entry may be flexibly set as a WEB page link or a WEB page floating layer according to the carrier where the page is located, such as an APP end, a WEB end, and H5. After receiving the self-maintenance page entrance, the employee can enter the self-maintenance page to maintain and modify the relevant information through direct confirmation or identity verification. Of course, the self-maintenance module 3 may also trigger other related notification mechanisms such as mail or chat software to notify the employee that the AP has been connected to more times recently and the location of the AP. Still further, options may be provided to go to modification or not.
In a preferred embodiment, if the target employee responds to the self-maintenance page entry within the valid time and performs the self-maintenance operation, the positioning module 2 is further configured to determine the position of the seat of the target employee according to the self-maintenance operation; if the target staff does not respond to the self-maintenance page entry within the effective time, the self-maintenance module 3 is further configured to disable the self-maintenance page entry, and generate broadcast information including the target staff and the office area.
As described above, a preset time, for example, 3 hours, is performed for the self-maintenance page entry through the token mechanism, and within the preset time, the target employee clicks the confirmation modification at the self-maintenance page entry and goes to the self-maintenance page to modify the position information, then the positioning module 2 takes the modified position as a new seat position of the target employee, and in this process, after the operator inputs the seat number, information such as an associated city and a floor can be retrieved in real time according to standardized seat data to achieve quick entry, and the state of the associated record is updated to be modified. If the target employee responds to the self-maintenance page entry within the preset time, but selects 'no modification', the fact that the employee thinks that the seat does not need to be modified is indicated, so that only events which do not need to be modified are saved, and the rest can be processed.
In another situation, if the employee does not make any response including confirmation of modification and no need of modification, the self-maintenance page portal pushed this time is invalid; of course, the push may be again made the next time a possible change in seat position is detected. The positioning module 2 automatically pushes the acquired AP location and the information about the target employee, for example, the office area of the target employee is provided to downstream consumption of the system according to the AP location or pushed to other colleagues as a broadcast as a reference.
As a preferred embodiment, if the terminal device accesses the network in a wired manner, the positioning module 2 determines the position of the seat again according to the port number used when the terminal device accesses the network. And after the seat position is determined again, if the terminal device is wirelessly connected with the wireless relay device again, the positioning module 2 determines the seat position again according to the self-maintenance operation.
In this embodiment, a mechanism for locating a wired network access situation of the terminal device is further provided, that is, the seat position is re-determined according to a port number used when the terminal device accesses the network. Certainly, those skilled in the art can know that the wired network can be correspondingly bound by the switch and the MAC address of each registered terminal device when being connected; the port number may be pre-allocated and pre-stored in the database, for example, the port number may be associated in a field form of a man-machine-port number, and according to the matching operation, the seat position of the corresponding terminal device may be determined by the port number, so as to determine the seat position of the target employee to which the terminal device belongs. Accordingly, the seat position determined at this time naturally also covers the aforementioned seat position of the target employee determined by the self-maintenance operation. But the determined agent position and the corresponding time stamp information are still reserved.
Further, in a case where an employee may use his/her own notebook to perform wired network access in a seat of another person, since the actual seat position is not changed, when the target employee returns to his/her own seat and performs wireless network access, the positioning module 2 retrieves the seat position in the self-maintenance operation result as the current seat position of the target employee.
As a preferred implementation, the positioning system of this embodiment further includes:
the statistical module is used for counting historical connection records according to the log information, wherein the historical connection records comprise connection time and/or connection times of the terminal equipment and the wireless relay equipment respectively; the determining module is used for determining the target wireless relay equipment according to the historical connection record; and the positioning module 2 is used for determining the office area of the seat of the target employee according to the position of the target wireless relay equipment.
For example, the statistical module periodically counts data such as connection time and connection frequency of the employee's terminal to the AP, and the determination module selects the AP according to the set screening conditions. For example, the AP with the largest number of connections in the last three days of the terminal device is determined as the target wireless relay device; or taking the AP connected last time as the target wireless relay equipment; or an AP that has been connected the most in the last 10 days and has been authenticated more than 5 times is set as a target wireless relay device. And a suitable target wireless relay device can be selected according to different application scenes to ensure that the selected wireless relay device has higher coupling degree for the association of the employee seat positions. Of course, those skilled in the art will appreciate that the basis for selecting the target wireless relay device herein includes, but is not limited to, one or a combination of several other defined conditions, such as connection time, connection times, connection status, and employee job status. Further, the office area of the target employee's seat is still determined by the positioning module 2 based on the location of the wireless relay device.
As a preferred embodiment, if a self-maintenance request sent from the terminal device is received, the self-maintenance module 3 sends a self-maintenance page entry to the terminal device, so as to prompt a user of the terminal device to perform self-maintenance operation on his/her seat position.
In this embodiment, besides prompting the staff according to the acquired information, a mechanism for automatically applying for maintenance of the position of the seat is provided for the staff. For example, a channel for self-service maintenance application is opened for a staff using wireless internet access, when a self-maintenance request sent from a terminal device is received, for example, wildcard characters such as "weihu", "seat" and the like are set in instant chat software, and once the characters are received, the staff to which the terminal user belongs is considered to have made an application for active maintenance, and the self-maintenance module 3 provides a corresponding self-maintenance page entry. In this case, it is ensured that the employee has the maintenance right for the seat position by assisting with the verification information such as the employee password or the face matching.
In the embodiment, the office area where the staff seat corresponding to the terminal device is located according to the connection condition of the terminal device and the wireless relay device, so that the self-maintenance operation of locating the position of the staff seat is reasonably prompted and given to the staff, and the approximate area of the position of the staff seat is given to prompt other staff when the staff performs the self-maintenance operation on time; and provides a resolution mechanism for acquiring conflicts between the positions of the employee agents through a port accessing the wired network and a self-maintenance operation. The positioning method of the staff seat provides a better solution for the lag of staff seat update and the difficulty in maintenance in large and medium-sized office places.
Example 3
Fig. 5 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention. The electronic device comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the computer program to realize the positioning method of the employee seat in the embodiment 1. The electronic device 30 shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 5, the electronic device 30 may be embodied in the form of a general purpose computing device, which may be, for example, a server device. The components of the electronic device 30 may include, but are not limited to: the at least one processor 31, the at least one memory 32, and a bus 33 connecting the various system components (including the memory 32 and the processor 31).
The bus 33 includes a data bus, an address bus, and a control bus.
The memory 32 may include volatile memory, such as Random Access Memory (RAM) 321 and/or cache memory 322, and may further include Read Only Memory (ROM) 323.
The processor 31 executes various functional applications and data processing, such as the positioning method of the employee seat in embodiment 1 of the present invention, by running the computer program stored in the memory 32.
The electronic device 30 may also communicate with one or more external devices 34 (e.g., keyboard, pointing device, etc.). Such communication may be through an input/output (I/O) interface 35. Also, model-generating device 30 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via network adapter 36. As shown in FIG. 5, network adapter 36 communicates with the other modules of model-generating device 30 via bus 33. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the model-generating device 30, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems, etc.
It should be noted that although in the above detailed description several units/modules or sub-units/modules of the electronic device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more of the units/modules described above may be embodied in one unit/module according to embodiments of the invention. Conversely, the features and functions of one unit/module described above may be further divided into embodiments by a plurality of units/modules.
Example 4
The present embodiment provides a computer-readable storage medium on which a computer program is stored, which when executed by a processor implements the steps in the positioning method for an employee seat in embodiment 1.
More specific examples, among others, that the readable storage medium may employ may include, but are not limited to: a portable disk, hard disk, random access memory, read only memory, erasable programmable read only memory, optical storage device, magnetic storage device, or any suitable combination of the foregoing.
In a possible implementation, the present invention can also be implemented in the form of a program product, which includes program code for causing a terminal device to perform the steps in the positioning method for an employee seat in implementation example 1, when the program product is run on the terminal device.
Where program code for carrying out the invention is written in any combination of one or more programming languages, the program code may execute entirely on the user device, partly on the user device, as a stand-alone software package, partly on the user device and partly on a remote device or entirely on the remote device.
While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that this is by way of example only, and that the scope of the invention is defined by the appended claims. Various changes or modifications to these embodiments may be made by those skilled in the art without departing from the principle and spirit of this invention, and these changes and modifications are within the scope of this invention.
Claims (10)
1. The positioning method of the staff seats is characterized in that the positioning method is used for positioning the staff seats in a plurality of office areas, wherein each office area is provided with a plurality of wireless relay devices; the positioning method comprises the following steps:
acquiring log information generated by wireless connection between terminal equipment and the wireless relay equipment, wherein the log information comprises an MAC (media access control) address of the terminal equipment;
if the MAC address corresponds to a target employee, determining the office area of the seat of the target employee according to the position of the wireless relay equipment;
the step of determining the office area of the target employee's seat according to the location of the wireless relay device further comprises:
if the office area is different from the pre-stored office area of the seat of the target employee, sending a self-maintenance page entry to the terminal equipment, wherein the self-maintenance page entry is used for prompting the target employee to perform self-maintenance operation on the position of the seat;
if the target staff responds to the self-maintenance page entrance within the effective time and carries out self-maintenance operation, determining the position of the seat of the target staff according to the self-maintenance operation;
and if the target staff do not respond to the self-maintenance page entrance within the effective time, the self-maintenance page entrance is invalid, and broadcast information comprising the target staff and the office area is generated.
2. The method of locating an employee's seat according to claim 1, wherein said step of determining the position of the target employee's seat based on the self-maintenance operation further comprises:
and if the terminal equipment is accessed to the network in a wired mode, re-determining the seat position according to the port number used when the terminal equipment is accessed to the network.
3. The method of locating an employee agent according to claim 2, wherein said step of re-determining said agent location further comprises, after:
and if the terminal equipment is wirelessly connected with the wireless relay equipment again, determining the seat position again according to the self-maintenance operation.
4. The method for positioning an employee agent according to claim 1, wherein the step of obtaining log information generated by a wireless connection between a terminal device and the wireless relay device further comprises:
according to the log information, counting a historical connection record, wherein the historical connection record comprises connection time and/or connection times of the terminal equipment and a plurality of wireless relay equipment respectively;
determining a target wireless relay device according to the historical connection record;
determining the office area of the seat of the target employee according to the position of the target wireless relay equipment;
and/or the presence of a gas in the gas,
and if the self-maintenance request sent by the terminal equipment is received, sending a self-maintenance page entry to the terminal equipment for prompting the terminal equipment to carry out self-maintenance operation.
5. The positioning system for the staff seats is characterized by being used for positioning the staff seats in a plurality of office areas, wherein each office area is provided with a plurality of wireless relay devices; the positioning system includes:
the system comprises a log acquisition module, a log acquisition module and a log processing module, wherein the log acquisition module is used for acquiring log information generated by wireless connection between terminal equipment and the wireless relay equipment, and the log information comprises an MAC (media access control) address of the terminal equipment;
the positioning module is used for determining the office area of the seat of the target staff according to the position of the wireless relay equipment when the MAC address corresponds to the working hours of the target staff;
the self-maintenance module is used for sending a self-maintenance page inlet to the terminal equipment when the office area is different from the pre-stored office area of the seat of the target employee, and the self-maintenance page inlet is used for prompting the target employee to carry out self-maintenance operation on the position of the seat;
if the target employee responds to the self-maintenance page entry within the effective time and performs self-maintenance operation, the positioning module is specifically used for determining the position of the seat of the target employee according to the self-maintenance operation;
if the target staff does not respond to the self-maintenance page entrance within the effective time, the self-maintenance module is further used for enabling the self-maintenance page entrance to be invalid, and the positioning module is further used for generating broadcast information comprising the target staff and the office area.
6. The system of claim 5, wherein if the terminal device accesses the network via a wired connection, the location module is further configured to re-determine the location of the agent according to a port number used when the terminal device accesses the network.
7. The staff seat positioning system of claim 6, wherein the positioning module is further configured to determine the seat position again according to the self-maintenance operation if the terminal device and the wireless relay device are again wirelessly connected.
8. The staff agent positioning system of claim 5, further comprising:
the statistical module is used for counting historical connection records according to the log information, wherein the historical connection records comprise connection time and/or connection times of the terminal equipment and the wireless relay equipment respectively; the determining module is used for determining target wireless relay equipment according to the historical connection record;
the positioning module is also used for determining the office area of the seat of the target employee according to the position of the target wireless relay equipment;
and/or the presence of a gas in the gas,
and if the self-maintenance request sent from the terminal equipment is received, the self-maintenance module is also used for sending a self-maintenance page inlet to the terminal equipment and prompting a user staff of the terminal equipment to carry out self-maintenance operation on the position of the user staff.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of positioning an employee agent according to any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method for positioning an employee agent according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110181432.7A CN112867148B (en) | 2021-02-09 | 2021-02-09 | Positioning method and system for employee seat, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110181432.7A CN112867148B (en) | 2021-02-09 | 2021-02-09 | Positioning method and system for employee seat, electronic device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112867148A CN112867148A (en) | 2021-05-28 |
| CN112867148B true CN112867148B (en) | 2023-01-31 |
Family
ID=75989572
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110181432.7A Active CN112867148B (en) | 2021-02-09 | 2021-02-09 | Positioning method and system for employee seat, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112867148B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113837719A (en) * | 2021-09-15 | 2021-12-24 | 携程旅游网络技术（上海）有限公司 | Method, system, electronic device and medium for acquiring computer office location |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860791A (en) * | 2010-06-09 | 2010-10-13 | 华为技术有限公司 | Realizing method for positioning user terminal and related equipment |
| CN105101062A (en) * | 2014-04-21 | 2015-11-25 | 北京奇虎科技有限公司 | Wearable device, and method and system for obtaining attribute information of wireless network |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7702309B2 (en) * | 2005-05-04 | 2010-04-20 | Nokia Corporation | Using MAC address of a WLAN access point as location information |
| JP2008048033A (en) * | 2006-08-11 | 2008-02-28 | Canon Inc | Access control method |
| KR102123636B1 (en) * | 2013-10-02 | 2020-06-17 | 삼성전자주식회사 | Method for positioning based on network and an electronic device thereof |
| US10200963B2 (en) * | 2014-07-25 | 2019-02-05 | Verizon Patent And Licensing Inc. | Reducing power consumption and network usage when locating a user device |
| US10353047B2 (en) * | 2015-06-19 | 2019-07-16 | Lenovo (Singapore) Pte. Ltd. | Device location determined by wireless signals |
-
2021
- 2021-02-09 CN CN202110181432.7A patent/CN112867148B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860791A (en) * | 2010-06-09 | 2010-10-13 | 华为技术有限公司 | Realizing method for positioning user terminal and related equipment |
| CN105101062A (en) * | 2014-04-21 | 2015-11-25 | 北京奇虎科技有限公司 | Wearable device, and method and system for obtaining attribute information of wireless network |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112867148A (en) | 2021-05-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9231962B1 (en) | Identifying suspicious user logins in enterprise networks | |
| US9325590B2 (en) | Automatic switch-mapping and client device location detection | |
| US7483394B2 (en) | System and method for automatically managing a network port based on a calendar function | |
| CN103843380B (en) | For monitoring monitoring system, monitoring server, the methods and procedures of unauthorized access point | |
| CN112737825B (en) | Log-based network device association method, system, device and storage medium | |
| US9853864B2 (en) | System and method for updating printer location information field | |
| EP2135157A1 (en) | Method and apparatus for managing printing devices in a local area network | |
| US11170350B2 (en) | Systems and methods for mobile application requests of physical facilities | |
| CN113254969B (en) | Business data processing method and device, electronic equipment and storage medium | |
| CN112867148B (en) | Positioning method and system for employee seat, electronic device and storage medium | |
| Pritoni et al. | Accessing WI-FI data for occupancy sensing | |
| CN112751976B (en) | Agent association method, system, equipment and storage medium based on authentication log | |
| CN110704501B (en) | User account correlation method and device | |
| JP6741607B2 (en) | License data management system, license data management method and program | |
| CN112637378B (en) | User-based network address association method, system, device and storage medium | |
| CN110599651A (en) | Access control system based on unified authorization center and control method | |
| US20140047097A1 (en) | Probabilistic Inventory System | |
| KR102498136B1 (en) | Method and system for automatic computer network environment setup | |
| JP2015211337A (en) | System comprising information generating device and receiving device | |
| JP2003203145A (en) | Personnel management support system and method therefor | |
| CN114281849B (en) | Data query method and device | |
| CN115002015B (en) | Network environment detection method, system, equipment and medium of terminal equipment | |
| JP2006092039A (en) | Service utilization system | |
| US10027841B1 (en) | System and method for document processing device administration | |
| WO2020246016A1 (en) | Data management system, data processing system, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |