电子班牌部署

运维

新增数据库

抢修人员维护表 yw_rush_repair_person

CREATE TABLE `yw_rush_repair_person` (
  `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属部门',
  `people_photo_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人脸信息库id',
  `user_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'sys_user表id',
  `ticke_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '紧急工作票id(票号基本表id)',
  `rush_repair_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '抢修人员姓名',
  `rush_repair_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '抢修人员手机号',
  `unit_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位名称(运维人脸信息表)',
  `people_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人员类别(运维人脸信息表)',
  `card_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号(运维人脸信息表)',
  `people_sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人员性别(运维人脸信息表)',
  `work_location_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作间id',
  `del_flag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '软删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='抢修人员维护表';

抢修系统维护表 yw_rush_repair_system

CREATE TABLE `yw_rush_repair_system` (
  `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属部门',
  `system_name` varchar(64) COLLATE utf8mb4_general_ci NOT NULL COMMENT '系统名称',
  `system_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '系统描述',
  `del_flag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '软删除',
  `system_company` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '系统所属公司',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='抢修系统维护表';

新增字段 yw_work_locations

ALTER TABLE `yw_work_locations` 
ADD COLUMN `work_location_type` INT(11) DEFAULT NULL COMMENT '操作间类型';

新增字典值 sys_dict

INSERT INTO `sys_dict` (`id`, `dict_name`, `dict_code`, `description`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `type`, `tenant_id`, `low_app_id`) VALUES ('1961274784625205250', '操作间类型', 'workLocationType', NULL, 0, 'admin', '2025-08-29 11:48:42', NULL, NULL, 0, 0, NULL);
INSERT INTO `nyunwei`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `item_color`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1961274854959489026', '1961274784625205250', '闸机', '1', NULL, NULL, 1, 1, 'admin', '2025-08-29 11:48:59', NULL, NULL);
INSERT INTO `nyunwei`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `item_color`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1961274939839619073', '1961274784625205250', '电子班牌', '2', NULL, NULL, 2, 1, 'admin', '2025-08-29 11:49:19', NULL, NULL);

新增字段 yw_equip_mng

ALTER TABLE `yw_equip_mng` 
ADD COLUMN `device_number` varchar(255) DEFAULT NULL COMMENT '设备编号';

系统管理-字典管理

新增设备类型-电子班牌 6

更换nginx配置文件

#user root;
worker_processes 1;
# error_log  D:/app/logs/nginx/error.log error;
#error_log  /app/logs/nginx/error_notice.log  notice;
#error_log  /app/logs/nginx/error_info.log  info;
#pid logs/nginx.pid;
events {
    worker_connections  1024;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    #tcp_nopush     on;
    #keepalive_timeout  0;
    keepalive_timeout  65;
    server_tokens off;
    gzip  on;
    map $http_upgrade $connection_upgrade {
        default keep-alive;
        'websocket' upgrade;
    }
    upstream yunwei_server{
    server 192.168.10.90:8081;
    }
   upstream yunwei2_server{
       server 10.122.241.207:18001; 
   }    
    server {
        listen       13000;
        server_name  localhost;
        client_max_body_size 1024m;
    client_body_buffer_size 1024m;
        #添加头部信息
        proxy_set_header Cookie $http_cookie;
        proxy_set_header X-Forwarded-Host $host;
        proxy_set_header X-Forwarded-Server $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-real-ip $remote_addr;
    location ~* /.+jmreport.+ {
        # 使用if指令和=403来拒绝访问
        if ($request_uri ~* "jmreport") {
            return 403;
        }
    }
    # 1. /api/v1/verify_user → /yunwei/access/ywAccessRecord/queryPageListByLike
        location = /api/v1/verify_user {
            # 直接转发到后端，路径拼接 /yunwei/xxx（无需依赖后续 /yunwei/ 规则，更精准）
            proxy_pass http://yunwei_server/yunwei/electronic/classSign/onlineVerificationAfterRecognition$is_args$args;
            proxy_http_version 1.1;
            proxy_set_header Host $host;
        }
        # 2. /api/v1/record/face → /yunwei/access/ywAccessRecord/getDetail
        location = /api/v1/record/face {
            proxy_pass http://yunwei_server/yunwei/electronic/classSign/uploadRecordSuccessfulRecognition$is_args$args;
            proxy_http_version 1.1;
            proxy_set_header Host $host;
        }
         # 3. /api/v1/stranger → /yunwei/access/stranger
        location = /api/v1/stranger {
            proxy_pass http://yunwei_server/yunwei/electronic/classSign/stranger$is_args$args;
            proxy_http_version 1.1;
            proxy_set_header Host $host;
        }
        # 4. /api/v1/user/inf_photo → /yunwei/access/stranger
        location = /api/v1/user/inf_photo {
            proxy_pass http://yunwei_server/yunwei/electronic/classSign/infPhoto$is_args$args;
            proxy_http_version 1.1;
            proxy_set_header Host $host;
        }
    location /yunwei/websocket {
            proxy_pass http://yunwei_server;
            proxy_http_version 1.1;
            proxy_set_header Host $host;
			proxy_set_header Upgrade $http_upgrade;
            proxy_set_header Connection $connection_upgrade;
        }
    location /yunwei/ {
        rewrite ^/(.*)/yunwei/yunwei(.*)$ /$1/yunwei$2 last;
            proxy_set_header Host $Host;
        proxy_set_header X-Forward-For $remote_addr;
	    proxy_pass http://yunwei_server;
        }
	location /yunwei2/ {
            rewrite ^/(.*)/yunwei2/yunwei2(.*)$ /$1/yunwei2$2 last;
            proxy_set_header Host $Host;
            proxy_set_header X-Forward-For $remote_addr;
            proxy_pass http://yunwei2_server;
        }
     location /yw2{
            alias  /home/web/yunwei2/yunwei;
            index  index.html index.htm;
            try_files $uri $uri/ = 404;
        }
        location / {
        #rewrite ^/(.*)/yunwei/yunwei(.*)$ /$1/yunwei$2 last;
	    try_files $uri $uri/ /index.html;
            root   ./html/dist;
            index  index.html index.htm;
        }
        error_page  404              /index.html;
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}