电磁锁单表概要提交

zhangnaisong

2024-06-29 4df69fcaa8187e67d288e801ad759b3d06721e2a

电磁锁单表概要提交

 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;

/**
 * ç”µç£é”Controller
 *
 * @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));
    }
}

 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();
    }
}

 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;

/**
 * ç”µç£é”Mapper接口
 * 
 * @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);
}

 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;

/**
 * ç”µç£é”Service接口
 * 
 * @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);
}

 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;

/**
 * ç”µç£é”Service业务层处理
 *
 * @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);
    }
}

 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>