From 4df69fcaa8187e67d288e801ad759b3d06721e2a Mon Sep 17 00:00:00 2001
From: zhangnaisong <2434969829@qq.com>
Date: 星期六, 29 六月 2024 16:01:47 +0800
Subject: [PATCH] 电磁锁单表概要提交
---
ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java | 109 ++++++++++
ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java | 61 ++++++
ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java | 61 ++++++
ard-work/src/main/java/com/ruoyi/sy/domain/ArdTankLock.java | 135 +++++++++++++
ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml | 88 ++++++++
ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java | 92 +++++++++
6 files changed, 546 insertions(+), 0 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java
new file mode 100644
index 0000000..46f8860
--- /dev/null
+++ b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java
@@ -0,0 +1,109 @@
+package com.ruoyi.sy.controller;
+
+import java.util.List;
+import javax.servlet.http.HttpServletResponse;
+
+import com.ruoyi.common.utils.uuid.IdUtils;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.PutMapping;
+import org.springframework.web.bind.annotation.DeleteMapping;
+import org.springframework.web.bind.annotation.PathVariable;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+import com.ruoyi.common.annotation.Log;
+import com.ruoyi.common.core.controller.BaseController;
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.sy.domain.ArdTankLock;
+import com.ruoyi.sy.service.IArdTankLockService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.common.core.page.TableDataInfo;
+
+/**
+ * 鐢电閿丆ontroller
+ *
+ * @author ard
+ * @date 2024-06-29
+ */
+@Api(tags = "鐢电閿�")
+@RestController
+@RequestMapping("/sy/lock")
+public class ArdTankLockController extends BaseController {
+ @Autowired
+ private IArdTankLockService ardTankLockService;
+
+/**
+ * 鏌ヨ鐢电閿佸垪琛�
+ */
+@ApiOperation("鏌ヨ鐢电閿佸垪琛�")
+@PreAuthorize("@ss.hasPermi('sy:lock:list')")
+@GetMapping("/list")
+ public TableDataInfo list(ArdTankLock ardTankLock) {
+ startPage();
+ List<ArdTankLock> list = ardTankLockService.selectArdTankLockList(ardTankLock);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭鐢电閿佸垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('sy:lock:export')")
+ @Log(title = "鐢电閿�" , businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, ArdTankLock ardTankLock) {
+ List<ArdTankLock> list = ardTankLockService.selectArdTankLockList(ardTankLock);
+ ExcelUtil<ArdTankLock> util = new ExcelUtil<ArdTankLock>(ArdTankLock. class);
+ util.exportExcel(response, list, "鐢电閿佹暟鎹�");
+ }
+
+ /**
+ * 鑾峰彇鐢电閿佽缁嗕俊鎭�
+ */
+ @ApiOperation("鑾峰彇鐢电閿佽缁嗕俊鎭�")
+ @PreAuthorize("@ss.hasPermi('sy:lock:query')")
+ @GetMapping(value = "/{id}")
+ public AjaxResult getInfo(@PathVariable("id") String id) {
+ return success(ardTankLockService.selectArdTankLockById(id));
+ }
+
+ /**
+ * 鏂板鐢电閿�
+ */
+ @ApiOperation("鏂板鐢电閿�")
+ @PreAuthorize("@ss.hasPermi('sy:lock:add')")
+ @Log(title = "鐢电閿�" , businessType = BusinessType.INSERT)
+ @PostMapping
+ public AjaxResult add(@RequestBody ArdTankLock ardTankLock) {
+ String id = IdUtils.simpleUUID();
+ ardTankLock.setId(id);
+ return toAjax(ardTankLockService.insertArdTankLock(ardTankLock));
+ }
+
+ /**
+ * 淇敼鐢电閿�
+ */
+ @ApiOperation("淇敼鐢电閿�")
+ @PreAuthorize("@ss.hasPermi('sy:lock:edit')")
+ @Log(title = "鐢电閿�" , businessType = BusinessType.UPDATE)
+ @PutMapping
+ public AjaxResult edit(@RequestBody ArdTankLock ardTankLock) {
+ return toAjax(ardTankLockService.updateArdTankLock(ardTankLock));
+ }
+
+ /**
+ * 鍒犻櫎鐢电閿�
+ */
+ @ApiOperation("鍒犻櫎鐢电閿�")
+ @PreAuthorize("@ss.hasPermi('sy:lock:remove')")
+ @Log(title = "鐢电閿�" , businessType = BusinessType.DELETE)
+ @DeleteMapping("/{ids}")
+ public AjaxResult remove(@PathVariable String[] ids) {
+ return toAjax(ardTankLockService.deleteArdTankLockByIds(ids));
+ }
+}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/domain/ArdTankLock.java b/ard-work/src/main/java/com/ruoyi/sy/domain/ArdTankLock.java
new file mode 100644
index 0000000..ce8b5e1
--- /dev/null
+++ b/ard-work/src/main/java/com/ruoyi/sy/domain/ArdTankLock.java
@@ -0,0 +1,135 @@
+package com.ruoyi.sy.domain;
+
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+
+/**
+ * 鐢电閿佸璞� ard_tank_lock
+ *
+ * @author ard
+ * @date 2024-06-29
+ */
+public class ArdTankLock extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 涓婚敭 */
+ private String id;
+
+ /** 閿佺紪鍙� */
+ @Excel(name = "閿佺紪鍙�")
+ private String lockNum;
+
+ /** 閿佸悕绉� */
+ @Excel(name = "閿佸悕绉�")
+ private String lockName;
+
+ /** 椤堕儴浣嶇疆 */
+ @Excel(name = "椤堕儴浣嶇疆")
+ private String imgPositionTop;
+
+ /** 鍙充晶浣嶇疆 */
+ @Excel(name = "鍙充晶浣嶇疆")
+ private String imgPositionLeft;
+
+ /** 涓変竴杞﹁締涓婚敭 */
+ @Excel(name = "涓変竴杞﹁締涓婚敭")
+ private String carId;
+
+ /** 浣胯兘 */
+ @Excel(name = "浣胯兘")
+ private String enable;
+
+ /** 鍦ㄧ嚎鏃堕棿 */
+ @Excel(name = "鍦ㄧ嚎鏃堕棿")
+ private String onlineTime;
+
+ public void setId(String id)
+ {
+ this.id = id;
+ }
+
+ public String getId()
+ {
+ return id;
+ }
+ public void setLockNum(String lockNum)
+ {
+ this.lockNum = lockNum;
+ }
+
+ public String getLockNum()
+ {
+ return lockNum;
+ }
+ public void setLockName(String lockName)
+ {
+ this.lockName = lockName;
+ }
+
+ public String getLockName()
+ {
+ return lockName;
+ }
+ public void setImgPositionTop(String imgPositionTop)
+ {
+ this.imgPositionTop = imgPositionTop;
+ }
+
+ public String getImgPositionTop()
+ {
+ return imgPositionTop;
+ }
+ public void setImgPositionLeft(String imgPositionLeft)
+ {
+ this.imgPositionLeft = imgPositionLeft;
+ }
+
+ public String getImgPositionLeft()
+ {
+ return imgPositionLeft;
+ }
+ public void setCarId(String carId)
+ {
+ this.carId = carId;
+ }
+
+ public String getCarId()
+ {
+ return carId;
+ }
+ public void setEnable(String enable)
+ {
+ this.enable = enable;
+ }
+
+ public String getEnable()
+ {
+ return enable;
+ }
+ public void setOnlineTime(String onlineTime)
+ {
+ this.onlineTime = onlineTime;
+ }
+
+ public String getOnlineTime()
+ {
+ return onlineTime;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("id", getId())
+ .append("lockNum", getLockNum())
+ .append("lockName", getLockName())
+ .append("imgPositionTop", getImgPositionTop())
+ .append("imgPositionLeft", getImgPositionLeft())
+ .append("carId", getCarId())
+ .append("enable", getEnable())
+ .append("onlineTime", getOnlineTime())
+ .toString();
+ }
+}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java
new file mode 100644
index 0000000..847df92
--- /dev/null
+++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java
@@ -0,0 +1,61 @@
+package com.ruoyi.sy.mapper;
+
+import java.util.List;
+import com.ruoyi.sy.domain.ArdTankLock;
+
+/**
+ * 鐢电閿丮apper鎺ュ彛
+ *
+ * @author ard
+ * @date 2024-06-29
+ */
+public interface ArdTankLockMapper
+{
+ /**
+ * 鏌ヨ鐢电閿�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 鐢电閿�
+ */
+ public ArdTankLock selectArdTankLockById(String id);
+
+ /**
+ * 鏌ヨ鐢电閿佸垪琛�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 鐢电閿侀泦鍚�
+ */
+ public List<ArdTankLock> selectArdTankLockList(ArdTankLock ardTankLock);
+
+ /**
+ * 鏂板鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ public int insertArdTankLock(ArdTankLock ardTankLock);
+
+ /**
+ * 淇敼鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ public int updateArdTankLock(ArdTankLock ardTankLock);
+
+ /**
+ * 鍒犻櫎鐢电閿�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 缁撴灉
+ */
+ public int deleteArdTankLockById(String id);
+
+ /**
+ * 鎵归噺鍒犻櫎鐢电閿�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteArdTankLockByIds(String[] ids);
+}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java
new file mode 100644
index 0000000..43b1353
--- /dev/null
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java
@@ -0,0 +1,61 @@
+package com.ruoyi.sy.service;
+
+import java.util.List;
+import com.ruoyi.sy.domain.ArdTankLock;
+
+/**
+ * 鐢电閿丼ervice鎺ュ彛
+ *
+ * @author ard
+ * @date 2024-06-29
+ */
+public interface IArdTankLockService
+{
+ /**
+ * 鏌ヨ鐢电閿�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 鐢电閿�
+ */
+ public ArdTankLock selectArdTankLockById(String id);
+
+ /**
+ * 鏌ヨ鐢电閿佸垪琛�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 鐢电閿侀泦鍚�
+ */
+ public List<ArdTankLock> selectArdTankLockList(ArdTankLock ardTankLock);
+
+ /**
+ * 鏂板鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ public int insertArdTankLock(ArdTankLock ardTankLock);
+
+ /**
+ * 淇敼鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ public int updateArdTankLock(ArdTankLock ardTankLock);
+
+ /**
+ * 鎵归噺鍒犻櫎鐢电閿�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鐢电閿佷富閿泦鍚�
+ * @return 缁撴灉
+ */
+ public int deleteArdTankLockByIds(String[] ids);
+
+ /**
+ * 鍒犻櫎鐢电閿佷俊鎭�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 缁撴灉
+ */
+ public int deleteArdTankLockById(String id);
+}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java
new file mode 100644
index 0000000..06593f7
--- /dev/null
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java
@@ -0,0 +1,92 @@
+package com.ruoyi.sy.service.impl;
+
+import java.util.List;
+
+import com.ruoyi.common.utils.uuid.IdUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import java.util.ArrayList;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.SecurityUtils;
+import com.ruoyi.sy.mapper.ArdTankLockMapper;
+import com.ruoyi.sy.domain.ArdTankLock;
+import com.ruoyi.sy.service.IArdTankLockService;
+
+/**
+ * 鐢电閿丼ervice涓氬姟灞傚鐞�
+ *
+ * @author ard
+ * @date 2024-06-29
+ */
+@Service
+public class ArdTankLockServiceImpl implements IArdTankLockService {
+ @Autowired
+ private ArdTankLockMapper ardTankLockMapper;
+
+ /**
+ * 鏌ヨ鐢电閿�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 鐢电閿�
+ */
+ @Override
+ public ArdTankLock selectArdTankLockById(String id) {
+ return ardTankLockMapper.selectArdTankLockById(id);
+ }
+
+ /**
+ * 鏌ヨ鐢电閿佸垪琛�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 鐢电閿�
+ */
+ @Override
+ public List<ArdTankLock> selectArdTankLockList(ArdTankLock ardTankLock) {
+ return ardTankLockMapper.selectArdTankLockList(ardTankLock);
+ }
+
+ /**
+ * 鏂板鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int insertArdTankLock(ArdTankLock ardTankLock) {
+ ardTankLock.setId(IdUtils.simpleUUID());
+ return ardTankLockMapper.insertArdTankLock(ardTankLock);
+ }
+
+ /**
+ * 淇敼鐢电閿�
+ *
+ * @param ardTankLock 鐢电閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int updateArdTankLock(ArdTankLock ardTankLock) {
+ return ardTankLockMapper.updateArdTankLock(ardTankLock);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎鐢电閿�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鐢电閿佷富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteArdTankLockByIds(String[] ids) {
+ return ardTankLockMapper.deleteArdTankLockByIds(ids);
+ }
+
+ /**
+ * 鍒犻櫎鐢电閿佷俊鎭�
+ *
+ * @param id 鐢电閿佷富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteArdTankLockById(String id) {
+ return ardTankLockMapper.deleteArdTankLockById(id);
+ }
+}
diff --git a/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
new file mode 100644
index 0000000..0ee14af
--- /dev/null
+++ b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
@@ -0,0 +1,88 @@
+<?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="com.ruoyi.sy.mapper.ArdTankLockMapper">
+
+ <resultMap type="ArdTankLock" id="ArdTankLockResult">
+ <result property="id" column="id" />
+ <result property="lockNum" column="lock_num" />
+ <result property="lockName" column="lock_name" />
+ <result property="imgPositionTop" column="img_position_top" />
+ <result property="imgPositionLeft" column="img_position_left" />
+ <result property="carId" column="car_id" />
+ <result property="enable" column="enable" />
+ <result property="onlineTime" column="online_time" />
+ </resultMap>
+
+ <sql id="selectArdTankLockVo">
+ select id, lock_num, lock_name, img_position_top, img_position_left, car_id, enable, online_time from ard_tank_lock
+ </sql>
+
+ <select id="selectArdTankLockList" parameterType="ArdTankLock" resultMap="ArdTankLockResult">
+ <include refid="selectArdTankLockVo"/>
+ <where>
+ <if test="lockNum != null and lockNum != ''"> and lock_num = #{lockNum}</if>
+ <if test="lockName != null and lockName != ''"> and lock_name like '%'||#{lockName}||'%'</if>
+ <if test="imgPositionTop != null and imgPositionTop != ''"> and img_position_top = #{imgPositionTop}</if>
+ <if test="imgPositionLeft != null and imgPositionLeft != ''"> and img_position_left = #{imgPositionLeft}</if>
+ <if test="carId != null and carId != ''"> and car_id = #{carId}</if>
+ <if test="enable != null and enable != ''"> and enable = #{enable}</if>
+ <if test="onlineTime != null and onlineTime != ''"> and online_time = #{onlineTime}</if>
+ </where>
+ </select>
+
+ <select id="selectArdTankLockById" parameterType="String" resultMap="ArdTankLockResult">
+ <include refid="selectArdTankLockVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertArdTankLock" parameterType="ArdTankLock">
+ insert into ard_tank_lock
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">id,</if>
+ <if test="lockNum != null">lock_num,</if>
+ <if test="lockName != null">lock_name,</if>
+ <if test="imgPositionTop != null">img_position_top,</if>
+ <if test="imgPositionLeft != null">img_position_left,</if>
+ <if test="carId != null">car_id,</if>
+ <if test="enable != null">enable,</if>
+ <if test="onlineTime != null">online_time,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">#{id},</if>
+ <if test="lockNum != null">#{lockNum},</if>
+ <if test="lockName != null">#{lockName},</if>
+ <if test="imgPositionTop != null">#{imgPositionTop},</if>
+ <if test="imgPositionLeft != null">#{imgPositionLeft},</if>
+ <if test="carId != null">#{carId},</if>
+ <if test="enable != null">#{enable},</if>
+ <if test="onlineTime != null">#{onlineTime},</if>
+ </trim>
+ </insert>
+
+ <update id="updateArdTankLock" parameterType="ArdTankLock">
+ update ard_tank_lock
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="lockNum != null">lock_num = #{lockNum},</if>
+ <if test="lockName != null">lock_name = #{lockName},</if>
+ <if test="imgPositionTop != null">img_position_top = #{imgPositionTop},</if>
+ <if test="imgPositionLeft != null">img_position_left = #{imgPositionLeft},</if>
+ <if test="carId != null">car_id = #{carId},</if>
+ <if test="enable != null">enable = #{enable},</if>
+ <if test="onlineTime != null">online_time = #{onlineTime},</if>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteArdTankLockById" parameterType="String">
+ delete from ard_tank_lock where id = #{id}
+ </delete>
+
+ <delete id="deleteArdTankLockByIds" parameterType="String">
+ delete from ard_tank_lock where id in
+ <foreach item="id" collection="array" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </delete>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3