/*
 Navicat Premium Data Transfer

 Source Server         : cold_baota
 Source Server Type    : MySQL
 Source Server Version : 80025 (8.0.25-220701)
 Source Host           : 127.0.0.1:40306
 Source Schema         : cold

 Target Server Type    : MySQL
 Target Server Version : 80025 (8.0.25-220701)
 File Encoding         : 65001

 Date: 13/09/2024 09:22:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `t_mid` int DEFAULT NULL,
  `t_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `t_permission` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `t_sort` int DEFAULT NULL,
  `t_pid` int NOT NULL DEFAULT '0',
  `t_icon` varchar(256) DEFAULT NULL,
  `t__state` int NOT NULL DEFAULT '1',
  `t_type` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (1, 0, '管理员管理', 'AdminManagement', 0, 0, 'icon-guanliyuan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (2, 1, '权限管理', 'RightsManagement', 0, 0, 'icon-quanxianpeizhi', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (4, 2, '新增', 'Power:Add', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (5, 2, '编辑', 'Power:Edit', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (6, 2, '删除', 'Power:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (7, 1, '报警预警', 'Warning', 0, 0, 'icon-baojing', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (8, 7, '批量处理', 'Warning:BatchHandle', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (9, 7, '处理', 'Warning:Handle', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (10, 7, '删除', 'Warning:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (11, 7, '记录', 'Warning:Record', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (12, 1, '内部用户管理', 'Admin', 0, 0, 'icon-ic_user_zx', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (13, 12, '新增人员', 'Admin:Add', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (14, 12, '编辑', 'Admin:Edit', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (15, 12, '删除', 'Admin:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (16, 12, '绑定', 'AdminCompany:Bind', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (17, 1, '设备版本升级管理', 'UpgradedVersion', 0, 0, 'icon-shengji', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (18, 17, '新增版本', 'Upgraded:Add', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (19, 17, '删除', 'Upgraded:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (20, 0, '公司管理', 'companyManagement', 2, 0, 'icon-yonghu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (21, 20, '公司管理', 'Company', 0, 0, 'icon-yonghu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (22, 21, '新增公司\r', 'Company:Add', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (23, 21, '添加分公司\r', 'Company:Filiale', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (24, 21, '编辑\r', 'Company:Edit', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (25, 21, '删除\r', 'Company:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (26, 21, '进入', 'Company:Visit', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (27, 20, '用户管理', 'userManagement', 0, 1, 'icon-User-f--', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (28, 27, '新增用户', 'User:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (29, 27, '编辑', 'User:Edit', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (30, 27, '删除', 'User:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (31, 0, '设备管理', 'equipmentManagement', 3, 1, 'icon-shebei', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (32, 31, '主机管理', 'management', 1, 1, 'icon-shebei', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (33, 32, '新增', 'Device:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (34, 32, '主机设置', 'Device:Setup', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (35, 101, '主机参数记录', 'Device:ParameterList', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (36, 32, '设备设置', 'DeviceSensor:Setup', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (37, 36, '传感器参数', 'DeviceSensor:Parameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (38, 37, '立即配置', 'DeviceSensor:ParameterPu', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (39, 36, '传感器配置', 'DeviceSensor:Config', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (45, 37, '设备参数记录', 'DeviceSensor:ParameterList', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (46, 32, '主机日志', 'Device:Log', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (47, 32, '重启/关机', 'Device:RestartShutdown', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (48, 31, '设备报警', 'callthepolice', 3, 1, 'icon-baojing', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (49, 48, '批量处理', 'Device:Warning:DatchHandle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (50, 48, '处理', 'Device:Warning:Handle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (51, 48, '删除', 'Device:Warning:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (52, 48, '记录', 'Device:Warning:Record', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (53, 48, '导出Excel', 'Device:Warning:Excel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (54, 31, '设备分类', 'DeviceClass', 4, 1, 'icon-ziyuan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (55, 54, '新增分类', 'DeviceClass:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (56, 54, '编辑', 'DeviceClass:Edit', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (57, 54, '删除', 'DeviceClass:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (58, 54, '绑定', 'DeviceClass:Bind', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (61, 31, '报警策略', 'WarningStrategy', 5, 1, 'icon-baojingjilu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (62, 61, '新增策略', 'DeviceNotice:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (63, 61, '编辑', 'DeviceNotice:Edit', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (64, 61, '删除', 'DeviceNotice:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (65, 64, '绑定', 'DeviceNotice:Bind', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (68, 0, '数据展示', 'dataDisplay', 4, 1, 'icon--tubiao', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (69, 68, '实时数据', 'realtime', 0, 1, 'icon-zhexiantu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (70, 68, '数据展示', 'dataShow', 0, 1, 'icon-shujukanban', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (71, 70, '导出Excel', 'dataShow:Excel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (72, 70, '下载PDF', 'dataShow:PDF', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (73, 68, '图表展示', 'chartShow', 0, 1, 'icon-24gl-chartPie', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (74, 68, '轨迹展示', 'mapShow', 0, 1, 'icon-caidanlan-renshi-yuangongdingweiguiji', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (75, 68, '智慧大屏', 'Wisdomscreen', 0, 1, 'icon-zhushujushenqing-shujufenxi-02', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (76, 68, '平面图', 'floorplan', 0, 1, 'icon-xiangmupingmiantu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (77, 68, '3D全景大屏', 'DataView3d', 0, 1, 'icon-3D', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (78, 0, '系统管理', 'systemManagement', 5, 0, 'icon-shezhi', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (79, 78, '工单系统', 'WorkOrderUser', 0, 1, 'icon-gongdanguanli', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (80, 79, '新增', 'WorkOrder:User:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (81, 79, '查看', 'WorkOrder:User:Get', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (82, 79, '已解决', 'WorkOrder:User:Handle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (83, 78, '工单系统（内部）', 'WorkOrder', 0, 0, 'icon-wodegongdan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (84, 83, '查看', 'WorkOrder:Get', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (85, 83, '删除', 'WorkOrder:Del', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (86, 78, '个人信息', 'personal', 0, 0, 'icon-changyongxinxi', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (88, 78, '系统日志', 'logs', 0, 0, 'icon-gongdanguanli', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (89, 78, '操作日志', 'operation', 0, 0, 'icon-chaoqigongdan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (90, 0, '工具箱', 'ToolSystem', 6, 0, 'icon-fenlei', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (91, 90, '订单管理', 'Theorder', 0, 1, 'icon-dingdanyichenggong', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (92, 91, '新增订单', 'GoodsOrder:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (93, 91, '编辑', 'GoodsOrder:Edit', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (94, 91, '删除', 'GoodsOrder:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (95, 91, 'PDF下载', 'GoodsOrder:Pdf', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (96, 90, '生成图表', 'generatechart', 0, 0, 'icon--tubiao', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (101, 34, '主机参数', 'Device:Parameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (102, 101, '立即配置', 'Device:ParameterPu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (103, 34, '主机配置', 'Device:Config', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (106, 32, '远程启停', 'Device:StopRecord', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (108, 31, '设备管理', 'equipment', 2, 1, 'icon-shujukanban', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (109, 108, '报警范围', 'DeviceSensor:Warning', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (110, 108, '预警范围', 'DeviceSensor:Enprel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (111, 108, '启/停', 'DeviceSensor:En', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (112, 108, '数据展示', 'DeviceSensor:Datashow', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (113, 32, '版本升级', 'Device:UpgradedVersion', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (114, 113, '立即升级', 'Device:ProductUpgrade_list', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (115, 0, '首页', 'home', -999, 0, 'icon-shouye', 2, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (116, 115, '工作台', 'workbench', 0, 0, 'icon-shouye', 2, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (117, 0, '流量池', 'Workbench:FlowPool', -999, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (118, 103, '立即配置', 'Device:Pu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (119, 39, '立即配置', 'DeviceSensor:Pu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (120, 108, '空库', 'DeviceSensor:Free', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (121, 70, '备份数据', 'dataShow:Backup', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (122, 1, '数据源管理', 'dataSource', 0, 0, 'icon-zhexiantu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (123, 0, '小程序', 'Applet', -998, 0, NULL, 1, 'A');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (124, 21, '数字孪生', 'Company:DigitalTwin', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (125, 21, '报警统计', 'Company:Warning', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (126, 21, '充值', 'Company:Pay', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (127, 0, '绩效管理', 'PerfManagement', 1, 0, 'icon-24gl-chartPie', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (128, 127, '绩效管理', 'Perf', 0, 0, 'icon-yingyongbangding', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (129, 127, '我的绩效', 'MyPerf', 0, 0, 'icon-ziyuan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (130, 20, '设备报警', 'companyCallthepolice', 3, 1, 'icon-baojing', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (131, 130, '批量处理', 'Company:Warning:DatchHandle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (132, 130, '处理', 'Company:Warning:Handle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (133, 130, '删除', 'Company:Warning:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (134, 130, '记录', 'Company:Warning:Record', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (135, 130, '导出Excel', 'Company:Warning:Excel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (136, 20, '实时数据', 'companyRealtime', 4, 1, 'icon-zhexiantu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (137, 27, '绑定主机', 'User:BindDevice', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (214, 73, '下载PDF', 'chartShow:PDF', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (215, 21, '记账扣费', 'Company:Charging', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (216, 32, '同步参数', 'Device:SyncParameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (217, 108, '类型选择', 'DeviceSensor:TypeSelection', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (218, 90, '出入库管理平台', 'StockInOut', 0, 0, 'icon-chaoqigongdan', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (219, 90, '动环监控', 'MovingRingMonitoring', 0, 0, 'icon-fenlei', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (220, 90, '冷链物流运输', 'CCLogistic', NULL, 0, 'icon-a-011_lenglianyunshu', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (230, 0, '弃用设备', 'abandonDeviceEquipmentManagement', 3, 1, 'icon-qiyong', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (231, 230, '主机管理', 'abandonDeviceManagement', 1, 1, 'icon-shebei', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (232, 231, '新增', 'AbandonDevice:Add', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (233, 231, '主机设置', 'AbandonDevice:Setup', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (234, 233, '主机参数', 'AbandonDevice:Parameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (235, 234, '主机参数记录', 'AbandonDevice:ParameterList', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (236, 231, '设备设置', 'AbandonDeviceSensor:Setup', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (237, 236, '传感器参数', 'AbandonDeviceSensor:Parameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (238, 237, '立即配置', 'AbandonDeviceSensor:ParameterPu', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (239, 236, '传感器配置', 'AbandonDeviceSensor:Config', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (245, 237, '设备参数记录', 'AbandonDeviceSensor:ParameterList', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (246, 231, '主机日志', 'AbandonDevice:Log', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (247, 231, '重启/关机', 'AbandonDevice:RestartShutdown', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (248, 230, '设备报警', 'abandonDeviceCallthepolice', 3, 1, 'icon-baojing', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (249, 248, '批量处理', 'AbandonDevice:Warning:DatchHandle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (250, 248, '处理', 'AbandonDevice:Warning:Handle', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (251, 248, '删除', 'AbandonDevice:Warning:Del', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (252, 248, '记录', 'AbandonDevice:Warning:Record', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (253, 248, '导出Excel', 'AbandonDevice:Warning:Excel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (270, 230, '数据展示', 'abandonDeviceDataShow', 4, 1, 'icon-shujukanban', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (271, 270, '导出Excel', 'AbandonDeviceDataShow::Excel', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (272, 270, '下载PDF', 'AbandonDeviceDataShow::PDF', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (273, 230, '图表展示', 'abandonDeviceChartShow', 5, 1, 'icon-24gl-chartPie', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (280, 234, '立即配置', 'AbandonDevice:ParameterPu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (281, 233, '主机配置', 'AbandonDevice:Config', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (282, 231, '远程启停', 'AbandonDevice:StopRecord', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (283, 230, '设备管理', 'abandonDeviceEquipment', 2, 1, 'icon-shujukanban', 1, 'M');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (284, 231, '版本升级', 'AbandonDevice:UpgradedVersion', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (285, 281, '立即配置', 'AbandonDevice:Pu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (286, 239, '立即配置', 'AbandonDeviceSensor:Pu', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (287, 283, '空库', 'AbandonDeviceSensor:Free', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (288, 270, '备份数据', 'AbandonDeviceDataShow::Backup', 0, 0, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (289, 273, '下载PDF', 'AbandonDeviceChartShow:PDF', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (290, 231, '同步参数', 'AbandonDevice:SyncParameter', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (291, 284, '立即升级', 'AbandonDevice:ProductUpgrade_list', 0, 1, NULL, 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (292, 283, '报警范围', 'AbandonDeviceSensor:Warning', 0, 1, '', 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (293, 283, '预警范围', 'AbandonDeviceSensor:Enprel', 0, 1, '', 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (294, 283, '启/停', 'AbandonDeviceSensor:En', 0, 1, '', 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (295, 283, '数据展示', 'AbandonDeviceSensor:Datashow', 0, 1, '', 1, 'B');
INSERT INTO `menu` (`ID`, `t_mid`, `t_name`, `t_permission`, `t_sort`, `t_pid`, `t_icon`, `t__state`, `t_type`) VALUES (296, 283, '类型选择', 'AbandonDeviceSensor:TypeSelection', 0, 1, '', 1, 'B');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;