Electric forklift working condition visualization system based on Internet of things
Technical Field
The invention relates to the field of data visualization, in particular to an electric forklift working condition visualization system based on the Internet of things.
Background
The electric forklift adopts a clean energy storage battery as power, really realizes zero pollution, belongs to environment-friendly equipment, replaces the traditional internal combustion forklift step by step, and becomes mainstream carrying equipment. Electric fork truck is in the use, its speed, the position, the battery surplus, whether idle waiting system operating mode direct influence fork truck's working property and availability factor, domestic many enterprises all still adopt the mode of manual management in the aspect of the warehouse logistics management, this kind of mode can not make managers in time master fork truck's operating condition and life-span state, and then timely make the maintenance strategy and make reasonable distribution scheduling scheme to the fork truck in whole warehouse to fork truck, the functioning speed of whole logistics chain has seriously been influenced.
Traditional fork truck intelligent management system, the current position of fork truck can only be single acquireing, can not directly perceivedly see the change of fork truck speed, accurate real-time running state, the operation condition that reflects fork truck. The existing database system can realize functions of data entry, query, statistics and the like, but cannot effectively discover the relation and development trend existing in the data and cannot effectively help a user to make analysis and decision according to the existing data.
The data visualization is to convert the engineering data collected in the actual measurement into visual graphic image information convenient for understanding and present the graphic image information to users by using computer graphic knowledge and image processing technology, so as to help people to better understand the data, thereby rapidly capturing the information from mass data.
Disclosure of Invention
The invention aims to design an electric forklift working condition visualization system based on the Internet of things in warehouse logistics by utilizing a visualization technology and a visualization tool aiming at the defects of the prior art, so that a decision maker can master the overall situation at the first time and master the current operation working condition of a forklift in time, the original data can be analyzed more quickly and accurately, and the dispatching efficiency of the forklift is improved.
In order to achieve the purpose, the invention provides the following technical scheme: an electric forklift working condition visualization system based on the Internet of things comprises a data acquisition module, a data preprocessing module, a data storage module, a chart drawing module and an interaction and display module;
the data acquisition module: the system comprises a Zigbee wireless positioning network module, a speed and weighing sensor, a battery power detection module, a local gateway, a cloud server and a MySQL database; arranging a set of Zigbee wireless positioning backbone network according to the area of the warehouse, installing a mobile node on each forklift in the warehouse, and outputting positioning coordinates of the mobile node by a preset signal strength value of a reference node in the moving process of the forklift so as to determine the real-time position of the forklift; speed sensors, weighing sensors and battery electric quantity detection sensors are deployed on the forklift, and data acquired by the sensors are transmitted to a local gateway through an STM32 controller platform; the local gateway uploads working condition data such as the speed, the position, the weight of goods transported each time, the battery power and whether the goods are idle to a cloud server one by one, and the cloud server stores the data in a MySQL database on the cloud in time;
the data preprocessing module: according to all original working condition data stored in a MySQL database, a clustering and regression algorithm is applied, the original data containing noise and errors are cleaned by denoising, data cleaning and feature extraction, clean data useful for users are reserved, and the data are reorganized according to a data format required by a corresponding chart to realize standardization;
the data storage module: storing data processed by the data acquisition module and the data preprocessing module for later use according to a pre-designed data table, wherein the data table comprises a forklift original information data table, a forklift position data table, a forklift speed data table, a forklift weighing weight data table and a forklift battery electric quantity display data table;
the chart drawing module: the method for mapping the stored data to the chart specifically comprises the following sub-modules:
(1) excel table of forklift original basic information data: the serial numbers and types of all forklifts in the current warehouse, the weight grades of goods suitable for carrying, drivers and other data are visually displayed through an excel table one by one for being inquired by managers;
(2) the forklift position and historical track map module: according to mobile node information data sent back by a wireless network module carried on a body of the electric forklift, current position information of the forklift is obtained, the current position of the forklift is displayed by colored dots on a map, all acquired track points are connected, a historical track traveled by the forklift can be drawn, and the traveling track of each forklift can be visually seen through different color settings;
(3) the forklift weighing data histogram and line graph module: acquiring the weight sum of accumulated transported goods in each working day of each forklift stored in a MySQL database according to a forklift weighing weight data table, generating a specific data graph of the working capacity of three days, one week, one month and one month in real time in a plane coordinate, setting a switching button, dynamically switching weighing data between a line graph and a column graph, reflecting the total working capacity of the forklift through the column graph, and predicting the trend of the change trend of the forklift working capacity through the line graph;
(4) fork truck regional work load pie chart module: accumulating and adding the sum of the weighing data in the working days of the forklift truck in each warehouse, correspondingly dividing the pie chart into blocks according to the number of the warehouses, selecting time periods according to needs through a time period pull-down frame, and respectively displaying the total workload of each area in one day, three days, one week, half a month and one month, so that the comparison of the workload of the forklift truck in each warehouse in the same time period can be visually seen, and the statistical analysis of monthly statements is prepared;
(5) the battery power grid module of the forklift comprises grids formed by 10 × 10 small squares, each small square represents 1% of power, the current power is represented by the number of the small squares filled with colors, and the remaining percentage n of the current power is represented by assuming that n small squares are filled with colors;
the interaction and presentation module: the method comprises the steps of using a visualization tool Echart.js technology to visually display drawn excel lists of forklift original basic information data, a map module of forklift positions and historical tracks, a forklift weighing data histogram and line graph module, a forklift battery electric quantity grid module and a forklift regional workload pie module in an intuitive and understandable mode, and managers can access the visually displayed data through a Web browser and can interactively operate charts while seeing dynamic charts.
Further, in the data storage module, the forklift original information data table comprises data items: the forklift truck comprises a forklift truck number (main key), a driver number, a forklift truck type and a weighing grade, wherein the forklift truck number (main key) is increased by 1 and sorted; the forklift position/speed/weight/power data table comprises the following data items: fork truck serial number (main key), fork truck X, Y coordinate/fork truck speed/weight/electric quantity, fork truck serial number (main key) increases 1 sequencing by one.
Further, in the forklift battery power grid module, the filling color is red when the power is below 10%, the filling color is orange when the power is within the range of 10% -40%, and the filling color is green when the power is above 40%.
Further, the interaction operation in the interaction and presentation module comprises:
(1) and (3) calculating the dragging weight: the management personnel can extract partial data in a dragging mode so as to more flexibly analyze key attention objects and recombine the data in a targeted manner;
(2) and (3) data view: the manager can view the data source while seeing the data visualization effect, and the broken line, the column and the pie chart are switched into a data view;
(3) data area scaling: when the data volume is large, a manager can randomly select a concerned data area for visualization;
(4) dynamic type switching: the same data has a plurality of visualization scheme selections, and dynamically and randomly switches among different types of charts;
(5) flexible time axis: aiming at the visual display of data containing time information, such as weighing data in different time periods, any chart is matched with a time axis, and the change process of the data is dynamically displayed.
Furthermore, the system is developed based on B/S, an MVC three-layer structure development mode is adopted, HTML + Bootstrap + Javascript is used as a front-end page display tool, JSP is used as a dynamic page display tool, JavaBean is used as a model base in a system scheduling management background, Servlet is used for realizing page control and service logic, Microsoft SQL Server 2000 is used as a database Server, Apache Tomcat is used as a webpage Server, and Ajax technology is combined, so that asynchronous communication between a browser and a Web Server is realized, and user experience is improved.
Compared with the prior art, the invention has the following beneficial effects: the invention relates to an electrician forklift working condition visualization system, which combines visualization technology and visualization analysis tools, displays the speed and position of a forklift in real time at a background dispatching center according to the internet of things data of the running state of the forklift transmitted to a server by a gateway, processes and utilizes the data to generate and display visual charts such as maps, columns, broken lines, pie charts and the like of the forklift use efficiency, personnel assessment, battery residual quantity, forklift speed change curve, total travel distance record and the like every week and every month in real time, so that a manager can master the forklift working condition in real time, switches among different views according to requirements to comprehensively judge the working efficiency of the forklift, predicts and analyzes the service life state of the forklift, then reasonably selects task distribution and scheduling schemes according to the workshop working requirements, and finally improves the use efficiency of the forklift and the working efficiency of a warehouse, the service life of the forklift is prolonged, management and energy cost are saved for enterprises, the service level of the enterprises is improved, the spanning development is realized, and more benefits are brought for the enterprises.
Drawings
Fig. 1 is a structural block diagram of an electric forklift working condition visualization system based on the internet of things.
Detailed Description
The invention is described in further detail below with reference to the figures and specific examples.
As shown in fig. 1, the electric forklift working condition visualization system based on the internet of things provided by the invention comprises a data acquisition module, a data preprocessing module, a data storage module, a chart drawing module and an interaction and display module;
the data acquisition module: the system comprises a Zigbee wireless positioning network module, a speed and weighing sensor, a battery power detection module, a local gateway, a cloud server and a MySQL database; arranging a set of Zigbee wireless positioning backbone network according to the area of the warehouse, installing a mobile node on each forklift in the warehouse, and outputting positioning coordinates of the mobile node by a preset signal strength value of a reference node in the moving process of the forklift so as to determine the real-time position of the forklift; speed sensors, weighing sensors and battery electric quantity detection sensors are deployed on the forklift, and data acquired by the sensors are transmitted to a local gateway through an STM32 controller platform; the local gateway uploads working condition data such as the speed, the position, the weight of goods transported each time, the battery power and whether idle to the cloud server one by one, and the cloud server saves the data to the MySQL database on the cloud in time.
The data preprocessing module: according to all original working condition data stored in the MySQL database, the clustering and regression algorithm is applied, the original data containing noise and errors are cleaned through denoising, data cleaning and feature extraction, clean data useful for users are reserved, and the data are reorganized according to a data format required by a corresponding chart to realize standardization.
The data storage module: storing data processed by the data acquisition module and the data preprocessing module for later use according to a pre-designed data table, wherein the data table comprises a forklift original information data table, a forklift position data table, a forklift speed data table, a forklift weighing weight data table and a forklift battery electric quantity display data table;
the forklift original information data table comprises the following data items: the forklift truck comprises a forklift truck number (main key), a driver number, a forklift truck type and a weighing grade, wherein the forklift truck number (main key) is increased by 1 and sorted; the forklift position/speed/weight/power data table comprises the following data items: fork truck serial number (main key), fork truck X, Y coordinate/fork truck speed/weight/electric quantity, fork truck serial number (main key) increases 1 sequencing by one.
The chart drawing module: the method for mapping the stored data to the chart specifically comprises the following sub-modules:
(1) excel table of forklift original basic information data: the serial numbers and types of all forklifts in the current warehouse, the weight grades of goods suitable for carrying, drivers and other data are visually displayed through an excel table one by one for being inquired by managers;
(2) the forklift position and historical track map module: according to mobile node information data sent back by a wireless network module carried on a body of the electric forklift, current position information of the forklift is obtained, the current position of the forklift is displayed by colored dots on a map, all acquired track points are connected, a historical track traveled by the forklift can be drawn, and the traveling track of each forklift can be visually seen through different color settings;
(3) the forklift weighing data histogram and line graph module: according to the forklift weighing weight data table, the total weight of accumulated transported goods in each working day of each forklift stored in the MySQL database is obtained, a specific data graph of three days, one week, one half month and one month working capacity is generated in a plane coordinate in real time, a switching button is arranged, weighing data can be dynamically switched between a line graph and a column graph, the column graph can well reflect the working total amount of the forklift, and the line graph can predict the change trend of the forklift working capacity, so that the working efficiency of the forklift is mastered.
(4) Fork truck regional work load pie chart module: the sum of the weighing data in the working days of the forklift in each warehouse is accumulated and added, the pie charts are divided into blocks according to the number of the warehouses, the selectable time items are 1 day, 3 days, 7 days, half a month and one month, the time period is selected according to the requirement through the time period pull-down frame, the total work amount of each area in one day, three days, one week, half a month and one month is displayed respectively, the comparison of the work amount of the forklift in each warehouse in the same time period can be visually seen, and the statistical analysis of the monthly statement is prepared.
(5) The forklift battery power grid module is characterized in that a grid is formed by 10 × 10 small squares, each small square represents 1% of power, the current power is represented by the number of the small squares filled with colors, and the remaining percentage n of the current power is represented by assuming that the n small squares are filled with colors, wherein the filling color is red when the power is below 10%, the filling color is orange when the power is within the range of 10% -40%, and the filling color is green when the power is above 40%.
The interaction and presentation module: the method comprises the following steps of using a visualization tool Echart.js technology to visually display drawn excel lists of forklift original basic information data, a map module of forklift positions and historical tracks, a forklift weighing data histogram and broken line graph module, a forklift battery power grid module and data of a forklift regional workload pie graph module in an intuitive and easy-to-understand mode, so that managers can access the visually displayed data through a Web browser, and can perform the following operations on a graph while seeing a dynamic graph:
(1) and (3) calculating the dragging weight: the management personnel can extract partial data in a dragging mode so as to more flexibly analyze key attention objects and recombine the data in a targeted manner;
(2) and (3) data view: the manager can view the data source while seeing the data visualization effect, and the broken line, the column and the pie chart are switched into a data view;
(3) data area scaling: when the data volume is large, a manager can randomly select a concerned data area for visualization;
(4) dynamic type switching: the same data has a plurality of visualization scheme selections, and dynamically and randomly switches among different types of charts;
(5) flexible time axis: aiming at the visual display of data containing time information, such as weighing data in different time periods, any chart is matched with a time axis, and the change process of the data is dynamically displayed.
Through various interactive operations, the manager can fully understand the chart and the corresponding information.
The system can be developed based on B/S (browser/Server), an MVC three-layer structure development mode is adopted, HTML + Bootstrap + Javascript is used as a front-end page display tool, JSP is used as a dynamic page display tool, JavaBean is used as a model base in a system scheduling management background, Servlet is used for realizing page control and service logic, Microsoft SQL Server 2000 is used as a database Server, Apache Tomcat is adopted in a webpage Server, and Ajax technology is combined, so that asynchronous communication between the browser and the Web Server is realized, and user experience is improved.
The above description is only exemplary of the present invention and should not be construed as limiting the present invention, and any modifications, alterations, etc. made on the principle of the present invention should be included in the protection scope of the present invention.