From ad64ecb1fa079ca8051d4c36e21d0acadc966243 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 06 Aug 2021 14:56:55 +0800
Subject: [PATCH] 1.装备管理添加辖区
---
src/main/java/org/springblade/modules/coinspect/service/ICoinspectService.java | 41 ++
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml | 113 ++++++
src/main/java/org/springblade/modules/coinspect/vo/CoinspectVO.java | 36 ++
src/main/java/org/springblade/modules/information/controller/InformationController.java | 9
src/main/java/org/springblade/modules/equipage/entity/Car.java | 1
src/main/java/org/springblade/modules/equipage/entity/Gun.java | 1
src/main/java/org/springblade/modules/coinspect/entity/Coinspect.java | 89 ++++
src/main/java/org/springblade/modules/information/service/IInformationService.java | 1
src/main/java/org/springblade/modules/seinspect/entity/Seinspect.java | 100 +++++
src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.xml | 23 +
src/main/java/org/springblade/modules/seinspect/service/impl/SeinspectServiceImpl.java | 41 ++
src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java | 5
src/main/java/sql/coinspect.menu.mysql | 10
src/main/java/org/springblade/modules/equipage/entity/Equipage.java | 1
src/main/java/org/springblade/modules/seinspect/dto/SeinspectDTO.java | 34 +
src/main/java/org/springblade/modules/seinspect/service/ISeinspectService.java | 41 ++
src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.java | 42 ++
src/main/java/org/springblade/modules/coinspect/dto/CoinspectDTO.java | 34 +
src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.java | 42 ++
src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.xml | 21 +
src/main/java/org/springblade/modules/information/mapper/InformationMapper.java | 1
src/main/java/org/springblade/modules/seinspect/vo/SeinspectVO.java | 36 ++
src/main/java/org/springblade/common/config/BladeConfiguration.java | 2
src/main/java/sql/seinspect.menu.mysql | 10
src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.java | 126 +++++++
src/main/java/org/springblade/modules/coinspect/service/impl/CoinspectServiceImpl.java | 41 ++
src/main/java/org/springblade/modules/seinspect/controller/SeinspectController.java | 126 +++++++
27 files changed, 1,026 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/common/config/BladeConfiguration.java b/src/main/java/org/springblade/common/config/BladeConfiguration.java
index 3f6af5e..a2a7f50 100644
--- a/src/main/java/org/springblade/common/config/BladeConfiguration.java
+++ b/src/main/java/org/springblade/common/config/BladeConfiguration.java
@@ -77,6 +77,8 @@
secureRegistry.excludePathPatterns("/trainExam/**");
secureRegistry.excludePathPatterns("/trainingRegistration/**");
secureRegistry.excludePathPatterns("/workReport/**");
+ secureRegistry.excludePathPatterns("/seinspect/**");
+ secureRegistry.excludePathPatterns("/coinspect/**");
return secureRegistry;
}
diff --git a/src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.java b/src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.java
new file mode 100644
index 0000000..94a6263
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.java
@@ -0,0 +1,126 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.controller;
+
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
+import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
+import lombok.AllArgsConstructor;
+import javax.validation.Valid;
+
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.mp.support.Query;
+import org.springblade.core.tool.api.R;
+import org.springblade.core.tool.utils.Func;
+import org.springframework.web.bind.annotation.*;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springblade.modules.coinspect.entity.Coinspect;
+import org.springblade.modules.coinspect.vo.CoinspectVO;
+import org.springblade.modules.coinspect.service.ICoinspectService;
+import org.springblade.core.boot.ctrl.BladeController;
+
+/**
+ * 控制器
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@RestController
+@AllArgsConstructor
+@RequestMapping("/coinspect")
+@Api(value = "", tags = "接口")
+public class CoinspectController extends BladeController {
+
+ private final ICoinspectService coinspectService;
+
+ /**
+ * 详情
+ */
+ @GetMapping("/detail")
+ @ApiOperationSupport(order = 1)
+ @ApiOperation(value = "详情", notes = "传入coinspect")
+ public R<Coinspect> detail(Coinspect coinspect) {
+ Coinspect detail = coinspectService.getOne(Condition.getQueryWrapper(coinspect));
+ return R.data(detail);
+ }
+
+ /**
+ * 分页
+ */
+ @GetMapping("/list")
+ @ApiOperationSupport(order = 2)
+ @ApiOperation(value = "分页", notes = "传入coinspect")
+ public R<IPage<Coinspect>> list(Coinspect coinspect, Query query) {
+ IPage<Coinspect> pages = coinspectService.page(Condition.getPage(query), Condition.getQueryWrapper(coinspect));
+ return R.data(pages);
+ }
+
+ /**
+ * 自定义分页
+ */
+ @GetMapping("/page")
+ @ApiOperationSupport(order = 3)
+ @ApiOperation(value = "分页", notes = "传入coinspect")
+ public R<IPage<CoinspectVO>> page(CoinspectVO coinspect, Query query) {
+ IPage<CoinspectVO> pages = coinspectService.selectCoinspectPage(Condition.getPage(query), coinspect);
+ return R.data(pages);
+ }
+
+ /**
+ * 新增
+ */
+ @PostMapping("/save")
+ @ApiOperationSupport(order = 4)
+ @ApiOperation(value = "新增", notes = "传入coinspect")
+ public R save(@Valid @RequestBody Coinspect coinspect) {
+ return R.status(coinspectService.save(coinspect));
+ }
+
+ /**
+ * 修改
+ */
+ @PostMapping("/update")
+ @ApiOperationSupport(order = 5)
+ @ApiOperation(value = "修改", notes = "传入coinspect")
+ public R update(@Valid @RequestBody Coinspect coinspect) {
+ return R.status(coinspectService.updateById(coinspect));
+ }
+
+ /**
+ * 新增或修改
+ */
+ @PostMapping("/submit")
+ @ApiOperationSupport(order = 6)
+ @ApiOperation(value = "新增或修改", notes = "传入coinspect")
+ public R submit(@Valid @RequestBody Coinspect coinspect) {
+ return R.status(coinspectService.saveOrUpdate(coinspect));
+ }
+
+
+ /**
+ * 删除
+ */
+ @PostMapping("/remove")
+ @ApiOperationSupport(order = 8)
+ @ApiOperation(value = "删除", notes = "传入ids")
+ public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
+ return R.status(coinspectService.removeByIds(Func.toLongList(ids)));
+ }
+
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/dto/CoinspectDTO.java b/src/main/java/org/springblade/modules/coinspect/dto/CoinspectDTO.java
new file mode 100644
index 0000000..bf413e0
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/dto/CoinspectDTO.java
@@ -0,0 +1,34 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.dto;
+
+import org.springblade.modules.coinspect.entity.Coinspect;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+/**
+ * 数据传输对象实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class CoinspectDTO extends Coinspect {
+ private static final long serialVersionUID = 1L;
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/entity/Coinspect.java b/src/main/java/org/springblade/modules/coinspect/entity/Coinspect.java
new file mode 100644
index 0000000..e123f50
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/entity/Coinspect.java
@@ -0,0 +1,89 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.entity;
+
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+
+import java.time.LocalDateTime;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+
+import java.io.Serializable;
+import java.util.Date;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import org.springframework.format.annotation.DateTimeFormat;
+
+/**
+ * 实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@TableName("sys_coinspect")
+@ApiModel(value = "Coinspect对象", description = "Coinspect对象")
+public class Coinspect implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+ /**
+ * 检查人姓名
+ */
+ @ApiModelProperty(value = "检查人姓名")
+ private String name;
+ /**
+ * 被检查单位名称
+ */
+ @ApiModelProperty(value = "被检查单位名称")
+ @TableField("sName")
+ private String sname;
+ /**
+ * 检查人单位
+ */
+ @ApiModelProperty(value = "检查人单位")
+ @TableField("deptName")
+ private String deptname;
+ /**
+ * 检查日期
+ */
+ @ApiModelProperty(value = "检查日期")
+ @TableField("reviewTime")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+ @DateTimeFormat(pattern = "yyyy-MM-dd ")
+ private Date reviewtime;
+ /**
+ * 检查内容
+ */
+ @ApiModelProperty(value = "检查内容")
+ private String insid;
+ /**
+ * 检查结果
+ */
+ @ApiModelProperty(value = "检查结果")
+ private String results;
+
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.java b/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.java
new file mode 100644
index 0000000..aa0ef85
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.java
@@ -0,0 +1,42 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.mapper;
+
+import org.springblade.modules.coinspect.entity.Coinspect;
+import org.springblade.modules.coinspect.vo.CoinspectVO;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import java.util.List;
+
+/**
+ * Mapper 接口
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+public interface CoinspectMapper extends BaseMapper<Coinspect> {
+
+ /**
+ * 自定义分页
+ *
+ * @param page
+ * @param coinspect
+ * @return
+ */
+ List<CoinspectVO> selectCoinspectPage(IPage page, CoinspectVO coinspect);
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.xml b/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.xml
new file mode 100644
index 0000000..ee0b701
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/mapper/CoinspectMapper.xml
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="org.springblade.modules.coinspect.mapper.CoinspectMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="coinspectResultMap" type="org.springblade.modules.coinspect.entity.Coinspect">
+ <id column="id" property="id"/>
+ <result column="name" property="name"/>
+ <result column="sName" property="sname"/>
+ <result column="deptName" property="deptname"/>
+ <result column="reviewTime" property="reviewtime"/>
+ <result column="insid" property="insid"/>
+ <result column="results" property="results"/>
+ </resultMap>
+
+
+ <select id="selectCoinspectPage" resultMap="coinspectResultMap">
+ select * from sys_coinspect where is_deleted = 0
+ </select>
+
+</mapper>
diff --git a/src/main/java/org/springblade/modules/coinspect/service/ICoinspectService.java b/src/main/java/org/springblade/modules/coinspect/service/ICoinspectService.java
new file mode 100644
index 0000000..9492c8f
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/service/ICoinspectService.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.service;
+
+import org.springblade.modules.coinspect.entity.Coinspect;
+import org.springblade.modules.coinspect.vo.CoinspectVO;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+
+/**
+ * 服务类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+public interface ICoinspectService extends IService<Coinspect> {
+
+ /**
+ * 自定义分页
+ *
+ * @param page
+ * @param coinspect
+ * @return
+ */
+ IPage<CoinspectVO> selectCoinspectPage(IPage<CoinspectVO> page, CoinspectVO coinspect);
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/service/impl/CoinspectServiceImpl.java b/src/main/java/org/springblade/modules/coinspect/service/impl/CoinspectServiceImpl.java
new file mode 100644
index 0000000..3043e9a
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/service/impl/CoinspectServiceImpl.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.service.impl;
+
+import org.springblade.modules.coinspect.entity.Coinspect;
+import org.springblade.modules.coinspect.vo.CoinspectVO;
+import org.springblade.modules.coinspect.mapper.CoinspectMapper;
+import org.springblade.modules.coinspect.service.ICoinspectService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+
+/**
+ * 服务实现类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Service
+public class CoinspectServiceImpl extends ServiceImpl<CoinspectMapper, Coinspect> implements ICoinspectService {
+
+ @Override
+ public IPage<CoinspectVO> selectCoinspectPage(IPage<CoinspectVO> page, CoinspectVO coinspect) {
+ return page.setRecords(baseMapper.selectCoinspectPage(page, coinspect));
+ }
+
+}
diff --git a/src/main/java/org/springblade/modules/coinspect/vo/CoinspectVO.java b/src/main/java/org/springblade/modules/coinspect/vo/CoinspectVO.java
new file mode 100644
index 0000000..fdd18b9
--- /dev/null
+++ b/src/main/java/org/springblade/modules/coinspect/vo/CoinspectVO.java
@@ -0,0 +1,36 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.coinspect.vo;
+
+import org.springblade.modules.coinspect.entity.Coinspect;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import io.swagger.annotations.ApiModel;
+
+/**
+ * 视图实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ApiModel(value = "CoinspectVO对象", description = "CoinspectVO对象")
+public class CoinspectVO extends Coinspect {
+ private static final long serialVersionUID = 1L;
+
+}
diff --git a/src/main/java/org/springblade/modules/equipage/entity/Car.java b/src/main/java/org/springblade/modules/equipage/entity/Car.java
index 2be0044..3aa29a8 100644
--- a/src/main/java/org/springblade/modules/equipage/entity/Car.java
+++ b/src/main/java/org/springblade/modules/equipage/entity/Car.java
@@ -79,5 +79,6 @@
* 车辆型号
*/
private String mode;
+ private String jurisdiction;
}
diff --git a/src/main/java/org/springblade/modules/equipage/entity/Equipage.java b/src/main/java/org/springblade/modules/equipage/entity/Equipage.java
index 4cecff8..fb6929c 100644
--- a/src/main/java/org/springblade/modules/equipage/entity/Equipage.java
+++ b/src/main/java/org/springblade/modules/equipage/entity/Equipage.java
@@ -63,6 +63,7 @@
* 品牌，厂商
*/
private String brand;
+ private String jurisdiction;
/**
* 生产时间
diff --git a/src/main/java/org/springblade/modules/equipage/entity/Gun.java b/src/main/java/org/springblade/modules/equipage/entity/Gun.java
index 8651b66..dcc9331 100644
--- a/src/main/java/org/springblade/modules/equipage/entity/Gun.java
+++ b/src/main/java/org/springblade/modules/equipage/entity/Gun.java
@@ -62,6 +62,7 @@
*/
@TableField("gun_mode")
private String gunMode;
+ private String jurisdiction;
/**
* 发证日期
diff --git a/src/main/java/org/springblade/modules/information/controller/InformationController.java b/src/main/java/org/springblade/modules/information/controller/InformationController.java
index 49b48de..2789ebd 100644
--- a/src/main/java/org/springblade/modules/information/controller/InformationController.java
+++ b/src/main/java/org/springblade/modules/information/controller/InformationController.java
@@ -736,4 +736,13 @@
return R.success("删除成功");
}
+ /**
+ * 保安员统计
+ */
+ @PostMapping("/selectLi")
+ public R selectLi(String jurisdiction,String deptid) {
+ List<Map<Object, Object>> list = informationService.selectLi(jurisdiction, deptid);
+ return R.data(list);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
index 08a67ce..0598720 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
@@ -52,6 +52,7 @@
Map<String, String> queryYearSoil(String year,String jurisdiction,String deptid);
Map<String, String> queryYearAn(String year,String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountB(String jurisdiction,String deptid);
+ List<Map<Object,Object>> selectLi(String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountZc(String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountCz(String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountSb(String jurisdiction,String deptid);
diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
index a90ce6d..67cd837 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
@@ -94,7 +94,7 @@
LEFT JOIN sys_jurisdiction j ON j.id= u.jurisdiction
WHERE
hold = 1
- <if test="jurisdiction!=null and jurisdiction!='' and jurisdiction!='1123598813738675201'">
+ <if test="jurisdiction!=null and jurisdiction!=''">
and u.jurisdiction =#{jurisdiction}
</if>
<if test="deptid!=null and deptid!=''">
@@ -798,4 +798,115 @@
<delete id="deleteDept">
delete from blade_dept where id=#{ids}
</delete>
+
+
+
+ <select id="selectLi" resultType="java.util.HashMap">
+ SELECT
+ IFNULL( A.num, 0 ) AS num,
+ IFNULL( B.cznum, 0 ) AS cznum,
+ IFNULL( C.paiqnum, 0 ) AS paiqnum,
+ IFNULL( D.wpaiqnum, 0 ) AS wpaiqnum,
+ IFNULL( E.caijnum, 0 ) AS caijnum,
+ IFNULL( F.wcaijnum, 0 ) AS wcaijnum,
+ IFNULL( G.yicnum, 0 ) AS yicnum,
+ A.dept_id,
+ d.dept_name AS deptname,
+ j.dept_name AS jurname
+ FROM
+ ( SELECT COUNT( * ) AS num, dept_id, jurisdiction FROM blade_user WHERE role_id = '1412226235153731586' GROUP BY dept_id, jurisdiction ) A
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS cznum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND hold=0
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) B ON A.dept_id = B.dept_id
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS paiqnum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND dispatch=0
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) C ON C.dept_id = A.dept_id
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS wpaiqnum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND dispatch=1
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) D ON D.dept_id = A.dept_id
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS caijnum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND photo=0
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) E ON E.dept_id = A.dept_id
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS wcaijnum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND photo=1
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) F ON F.dept_id = A.dept_id
+ LEFT JOIN (
+ SELECT
+ COUNT( * ) AS yicnum,
+ dept_id,
+ jurisdiction
+ FROM
+ blade_user
+ WHERE
+ role_id = '1412226235153731586'
+ AND examination_mx=1
+ GROUP BY
+ dept_id,
+ jurisdiction
+ ) G ON G.dept_id = A.dept_id
+ LEFT JOIN blade_dept d ON A.dept_id = d.id
+ LEFT JOIN sys_jurisdiction j ON j.id = A.jurisdiction
+ WHERE 1=1
+ <if test="jurisdiction!=null and jurisdiction!='' and jurisdiction!='1123598813738675201'">
+ and A.jurisdiction =#{jurisdiction}
+ </if>
+ <if test="deptid!=null and deptid!=''">
+ and A.dept_id =#{deptid}
+ </if>
+ </select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/information/service/IInformationService.java b/src/main/java/org/springblade/modules/information/service/IInformationService.java
index f44cde0..926aded 100644
--- a/src/main/java/org/springblade/modules/information/service/IInformationService.java
+++ b/src/main/java/org/springblade/modules/information/service/IInformationService.java
@@ -69,4 +69,5 @@
Map selectWPcount(String jurisdiction,String deptid);
List<Map<Object,Object>> selectIn(String jurisdiction);
void deleteDept(String ids);
+ List<Map<Object,Object>> selectLi(String jurisdiction,String deptid);
}
diff --git a/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java b/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
index d84066b..d2fc062 100644
--- a/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
+++ b/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
@@ -180,5 +180,10 @@
baseMapper.deleteDept(ids);
}
+ @Override
+ public List<Map<Object, Object>> selectLi(String jurisdiction, String deptid) {
+ return baseMapper.selectLi(jurisdiction, deptid);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/seinspect/controller/SeinspectController.java b/src/main/java/org/springblade/modules/seinspect/controller/SeinspectController.java
new file mode 100644
index 0000000..3fadb68
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/controller/SeinspectController.java
@@ -0,0 +1,126 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.controller;
+
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
+import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
+import lombok.AllArgsConstructor;
+import javax.validation.Valid;
+
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.mp.support.Query;
+import org.springblade.core.tool.api.R;
+import org.springblade.core.tool.utils.Func;
+import org.springframework.web.bind.annotation.*;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springblade.modules.seinspect.entity.Seinspect;
+import org.springblade.modules.seinspect.vo.SeinspectVO;
+import org.springblade.modules.seinspect.service.ISeinspectService;
+import org.springblade.core.boot.ctrl.BladeController;
+
+/**
+ * 控制器
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@RestController
+@AllArgsConstructor
+@RequestMapping("/seinspect")
+@Api(value = "", tags = "接口")
+public class SeinspectController extends BladeController {
+
+ private final ISeinspectService seinspectService;
+
+ /**
+ * 详情
+ */
+ @GetMapping("/detail")
+ @ApiOperationSupport(order = 1)
+ @ApiOperation(value = "详情", notes = "传入seinspect")
+ public R<Seinspect> detail(Seinspect seinspect) {
+ Seinspect detail = seinspectService.getOne(Condition.getQueryWrapper(seinspect));
+ return R.data(detail);
+ }
+
+ /**
+ * 分页
+ */
+ @GetMapping("/list")
+ @ApiOperationSupport(order = 2)
+ @ApiOperation(value = "分页", notes = "传入seinspect")
+ public R<IPage<Seinspect>> list(Seinspect seinspect, Query query) {
+ IPage<Seinspect> pages = seinspectService.page(Condition.getPage(query), Condition.getQueryWrapper(seinspect));
+ return R.data(pages);
+ }
+
+ /**
+ * 自定义分页
+ */
+ @GetMapping("/page")
+ @ApiOperationSupport(order = 3)
+ @ApiOperation(value = "分页", notes = "传入seinspect")
+ public R<IPage<SeinspectVO>> page(SeinspectVO seinspect, Query query) {
+ IPage<SeinspectVO> pages = seinspectService.selectSeinspectPage(Condition.getPage(query), seinspect);
+ return R.data(pages);
+ }
+
+ /**
+ * 新增
+ */
+ @PostMapping("/save")
+ @ApiOperationSupport(order = 4)
+ @ApiOperation(value = "新增", notes = "传入seinspect")
+ public R save(@Valid @RequestBody Seinspect seinspect) {
+ return R.status(seinspectService.save(seinspect));
+ }
+
+ /**
+ * 修改
+ */
+ @PostMapping("/update")
+ @ApiOperationSupport(order = 5)
+ @ApiOperation(value = "修改", notes = "传入seinspect")
+ public R update(@Valid @RequestBody Seinspect seinspect) {
+ return R.status(seinspectService.updateById(seinspect));
+ }
+
+ /**
+ * 新增或修改
+ */
+ @PostMapping("/submit")
+ @ApiOperationSupport(order = 6)
+ @ApiOperation(value = "新增或修改", notes = "传入seinspect")
+ public R submit(@Valid @RequestBody Seinspect seinspect) {
+ return R.status(seinspectService.saveOrUpdate(seinspect));
+ }
+
+
+ /**
+ * 删除
+ */
+ @PostMapping("/remove")
+ @ApiOperationSupport(order = 8)
+ @ApiOperation(value = "删除", notes = "传入ids")
+ public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
+ return R.status(seinspectService.removeByIds(Func.toLongList(ids)));
+ }
+
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/dto/SeinspectDTO.java b/src/main/java/org/springblade/modules/seinspect/dto/SeinspectDTO.java
new file mode 100644
index 0000000..c2cc24d
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/dto/SeinspectDTO.java
@@ -0,0 +1,34 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.dto;
+
+import org.springblade.modules.seinspect.entity.Seinspect;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+/**
+ * 数据传输对象实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class SeinspectDTO extends Seinspect {
+ private static final long serialVersionUID = 1L;
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/entity/Seinspect.java b/src/main/java/org/springblade/modules/seinspect/entity/Seinspect.java
new file mode 100644
index 0000000..1f653b3
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/entity/Seinspect.java
@@ -0,0 +1,100 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.entity;
+
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+
+import java.time.LocalDateTime;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+
+import java.io.Serializable;
+import java.util.Date;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import org.springframework.format.annotation.DateTimeFormat;
+
+/**
+ * 实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@TableName("sys_seinspect")
+@ApiModel(value = "Seinspect对象", description = "Seinspect对象")
+public class Seinspect implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+ /**
+ * 保安员姓名
+ */
+ @ApiModelProperty(value = "保安员姓名")
+ @TableField("realName")
+ private String realname;
+ /**
+ * 保安员身份证号
+ */
+ @ApiModelProperty(value = "保安员身份证号")
+ private String carid;
+ /**
+ * 保安员单位
+ */
+ @ApiModelProperty(value = "保安员单位")
+ @TableField("sName")
+ private String sname;
+ /**
+ * 检查人姓名
+ */
+ @ApiModelProperty(value = "检查人姓名")
+ private String inspectman;
+ /**
+ * 检查人单位
+ */
+ @ApiModelProperty(value = "检查人单位")
+ @TableField("deptName")
+ private String deptname;
+ /**
+ * 检查日期
+ */
+ @ApiModelProperty(value = "检查日期")
+ @TableField("reviewTime")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+ @DateTimeFormat(pattern = "yyyy-MM-dd ")
+ private Date reviewtime;
+ /**
+ * 检查内容
+ */
+ @ApiModelProperty(value = "检查内容")
+ private String insid;
+ /**
+ * 检查结果
+ */
+ @ApiModelProperty(value = "检查结果")
+ private String examinationType;
+
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.java b/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.java
new file mode 100644
index 0000000..68b422c
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.java
@@ -0,0 +1,42 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.mapper;
+
+import org.springblade.modules.seinspect.entity.Seinspect;
+import org.springblade.modules.seinspect.vo.SeinspectVO;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import java.util.List;
+
+/**
+ * Mapper 接口
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+public interface SeinspectMapper extends BaseMapper<Seinspect> {
+
+ /**
+ * 自定义分页
+ *
+ * @param page
+ * @param seinspect
+ * @return
+ */
+ List<SeinspectVO> selectSeinspectPage(IPage page, SeinspectVO seinspect);
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.xml b/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.xml
new file mode 100644
index 0000000..0c55533
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/mapper/SeinspectMapper.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="org.springblade.modules.seinspect.mapper.SeinspectMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="seinspectResultMap" type="org.springblade.modules.seinspect.entity.Seinspect">
+ <id column="id" property="id"/>
+ <result column="realName" property="realname"/>
+ <result column="carid" property="carid"/>
+ <result column="sName" property="sname"/>
+ <result column="inspectman" property="inspectman"/>
+ <result column="deptName" property="deptname"/>
+ <result column="reviewTime" property="reviewtime"/>
+ <result column="insid" property="insid"/>
+ <result column="examination_type" property="examinationType"/>
+ </resultMap>
+
+
+ <select id="selectSeinspectPage" resultMap="seinspectResultMap">
+ select * from sys_seinspect where is_deleted = 0
+ </select>
+
+</mapper>
diff --git a/src/main/java/org/springblade/modules/seinspect/service/ISeinspectService.java b/src/main/java/org/springblade/modules/seinspect/service/ISeinspectService.java
new file mode 100644
index 0000000..da4e667
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/service/ISeinspectService.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.service;
+
+import org.springblade.modules.seinspect.entity.Seinspect;
+import org.springblade.modules.seinspect.vo.SeinspectVO;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+
+/**
+ * 服务类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+public interface ISeinspectService extends IService<Seinspect> {
+
+ /**
+ * 自定义分页
+ *
+ * @param page
+ * @param seinspect
+ * @return
+ */
+ IPage<SeinspectVO> selectSeinspectPage(IPage<SeinspectVO> page, SeinspectVO seinspect);
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/service/impl/SeinspectServiceImpl.java b/src/main/java/org/springblade/modules/seinspect/service/impl/SeinspectServiceImpl.java
new file mode 100644
index 0000000..7be0956
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/service/impl/SeinspectServiceImpl.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.service.impl;
+
+import org.springblade.modules.seinspect.entity.Seinspect;
+import org.springblade.modules.seinspect.vo.SeinspectVO;
+import org.springblade.modules.seinspect.mapper.SeinspectMapper;
+import org.springblade.modules.seinspect.service.ISeinspectService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+
+/**
+ * 服务实现类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Service
+public class SeinspectServiceImpl extends ServiceImpl<SeinspectMapper, Seinspect> implements ISeinspectService {
+
+ @Override
+ public IPage<SeinspectVO> selectSeinspectPage(IPage<SeinspectVO> page, SeinspectVO seinspect) {
+ return page.setRecords(baseMapper.selectSeinspectPage(page, seinspect));
+ }
+
+}
diff --git a/src/main/java/org/springblade/modules/seinspect/vo/SeinspectVO.java b/src/main/java/org/springblade/modules/seinspect/vo/SeinspectVO.java
new file mode 100644
index 0000000..7eabc90
--- /dev/null
+++ b/src/main/java/org/springblade/modules/seinspect/vo/SeinspectVO.java
@@ -0,0 +1,36 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.seinspect.vo;
+
+import org.springblade.modules.seinspect.entity.Seinspect;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import io.swagger.annotations.ApiModel;
+
+/**
+ * 视图实体类
+ *
+ * @author BladeX
+ * @since 2021-08-03
+ */
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ApiModel(value = "SeinspectVO对象", description = "SeinspectVO对象")
+public class SeinspectVO extends Seinspect {
+ private static final long serialVersionUID = 1L;
+
+}
diff --git a/src/main/java/sql/coinspect.menu.mysql b/src/main/java/sql/coinspect.menu.mysql
new file mode 100644
index 0000000..e43794f
--- /dev/null
+++ b/src/main/java/sql/coinspect.menu.mysql
@@ -0,0 +1,10 @@
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422364202189787143', 1123598815738675201, 'coinspect', '单位检查', 'menu', '/coinspect/coinspect', NULL, 1, 1, 0, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422364202189787144', '1422364202189787143', 'coinspect_add', '新增', 'add', '/coinspect/coinspect/add', 'plus', 1, 2, 1, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422364202189787145', '1422364202189787143', 'coinspect_edit', '修改', 'edit', '/coinspect/coinspect/edit', 'form', 2, 2, 2, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422364202189787146', '1422364202189787143', 'coinspect_delete', '删除', 'delete', '/api/blade-coinspect/coinspect/remove', 'delete', 3, 2, 3, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422364202189787147', '1422364202189787143', 'coinspect_view', '查看', 'view', '/coinspect/coinspect/view', 'file-text', 4, 2, 2, 1, NULL, 0);
diff --git a/src/main/java/sql/seinspect.menu.mysql b/src/main/java/sql/seinspect.menu.mysql
new file mode 100644
index 0000000..fa859df
--- /dev/null
+++ b/src/main/java/sql/seinspect.menu.mysql
@@ -0,0 +1,10 @@
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422363615113056263', 1123598815738675201, 'seinspect', '保安员检查', 'menu', '/seinspect/seinspect', NULL, 1, 1, 0, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422363615113056264', '1422363615113056263', 'seinspect_add', '新增', 'add', '/seinspect/seinspect/add', 'plus', 1, 2, 1, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422363615113056265', '1422363615113056263', 'seinspect_edit', '修改', 'edit', '/seinspect/seinspect/edit', 'form', 2, 2, 2, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422363615113056266', '1422363615113056263', 'seinspect_delete', '删除', 'delete', '/api/blade-seinspect/seinspect/remove', 'delete', 3, 2, 3, 1, NULL, 0);
+INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`)
+VALUES ('1422363615113056267', '1422363615113056263', 'seinspect_view', '查看', 'view', '/seinspect/seinspect/view', 'file-text', 4, 2, 2, 1, NULL, 0);
--
Gitblit v1.9.3