手持设备和音柱

zhanghua

2022-10-31 f7e473f469fb35d4a6edc63c5df91b819d3d9b5c

手持设备和音柱

 document/×ÛºÏÐÐÕþÖ´·¨ÎÄÊé²Î¿¼Ñùʽ.docx

Binary files differ

 ycl-platform/src/main/java/com/ycl/controller/epuipment/HandheldTerminalController.java

New file
@@ -0,0 +1,66 @@
package com.ycl.controller.epuipment;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.annotation.LogSave;
import com.ycl.api.CommonResult;
import com.ycl.controller.BaseController;
import com.ycl.vo.equipment.HandheldTerminalVo;
import com.ycl.entity.equipment.HandheldTerminal;
import com.ycl.service.equipment.IHandheldTerminalService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


/**
 * æ‰‹æŒè®¾å¤‡ç®¡ç†
 *
 * @version V1.0
 * @author: AI
 * @date: 2022-10-31 15:44
 **/
@RestController
@RequestMapping("/equipment_handheld_terminal")
@Api(tags = "手持设备管理")
public class HandheldTerminalController extends BaseController {

    IHandheldTerminalService handheldTerminalService;

    @Autowired
    public void setHandheldTerminalService(IHandheldTerminalService handheldTerminalService) {
        this.handheldTerminalService = handheldTerminalService;
    }

    @GetMapping("/query")
    @ApiOperation("查询")
    @LogSave
    public CommonResult<Page<HandheldTerminalVo>> search(@RequestParam(required = false) Integer size,
                                                         @RequestParam(required = false) Integer current,
                                                         @RequestParam(required = false) Short state) {
        return CommonResult.success(handheldTerminalService.search(size, current, state));
    }

    @PostMapping("/add")
    @ApiOperation("添加")
    @LogSave(operationType = "手持设备管理", contain = "添加手持设备")
    public CommonResult add(@RequestBody HandheldTerminal handheldTerminal) {
        return CommonResult.success(null);
    }

    @PutMapping("/update")
    @ApiOperation("修改")
    @LogSave(operationType = "手持设备管理", contain = "修改手持设备")
    public CommonResult update(@RequestBody HandheldTerminal handheldTerminal) {
        return CommonResult.success(null);
    }

    @DeleteMapping("/delete/{id}")
    @ApiOperation("删除")
    @LogSave(operationType = "手持设备管理", contain = "删除手持设备")
    public CommonResult delete(@PathVariable Long id) {
        return CommonResult.success(null);
    }

}

 ycl-platform/src/main/java/com/ycl/controller/epuipment/LoudspeakerController.java

New file
@@ -0,0 +1,81 @@
package com.ycl.controller.epuipment;


import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.annotation.LogSave;
import com.ycl.api.CommonResult;
import com.ycl.controller.BaseController;
import com.ycl.entity.dict.DataDictionary;
import com.ycl.entity.equipment.EquipmentBayonet;
import com.ycl.entity.equipment.Loudspeaker;
import com.ycl.service.dict.IDataDictionaryService;
import com.ycl.service.equipment.IEquipmentBayonetService;
import com.ycl.service.equipment.ILoudspeakerService;
import com.ycl.vo.equipment.EquipmentBayonetVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.SneakyThrows;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.stream.Collectors;


/**
 * éŸ³æŸ±ç®¡ç†
 *
 * @version V1.0
 * @author: AI
 * @date: 2022-10-31 15:45
 **/
@RestController
@RequestMapping("/equipment_loudspeaker")
@Api(tags = "音柱管理")
public class LoudspeakerController extends BaseController {

    ILoudspeakerService loudspeakerService;

    @Autowired
    public void setLoudspeakerService(ILoudspeakerService loudspeakerService) {
        this.loudspeakerService = loudspeakerService;
    }

    @GetMapping("/query")
    @ApiOperation("查询")
    @LogSave
    public CommonResult search(@RequestParam(required = false) Integer size,
                               @RequestParam(required = false) Integer current,
                               @RequestParam(required = false) Short state) {
        return null;
    }

    @PostMapping("/add")
    @ApiOperation("添加")
    @LogSave(operationType = "音柱管理", contain = "添加音柱")
    public CommonResult add(@RequestBody Loudspeaker loudspeaker) {
        return CommonResult.success(null);
    }

    @PutMapping("/update")
    @ApiOperation("编辑")
    @LogSave(operationType = "音柱管理", contain = "修改音柱")
    public CommonResult update(@RequestBody Loudspeaker loudspeaker) {
        return CommonResult.success(null);
    }

    @DeleteMapping("/delete/{id}")
    @ApiOperation("删除")
    @LogSave(operationType = "音柱管理", contain = "删除音柱")
    public CommonResult delete(@PathVariable Long id) {
        return CommonResult.success(null);
    }


}

 ycl-platform/src/main/java/com/ycl/entity/equipment/HandheldTerminal.java

New file
@@ -0,0 +1,72 @@
package com.ycl.entity.equipment;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.time.LocalDateTime;


/**
 * æ‰‹æŒç»ˆç«¯
 *
 * @version V1.0
 * @author: AI
 * @date: 2022-10-31 14:55
 **/
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("ums_equipment_handheld_terminal")
public class HandheldTerminal implements Serializable {
    /**
     * ä¸»é”®
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * åç§°
     */
    @TableField("name")
    private String name;

    /**
     * ç¼–号
     */
    @TableField("code")
    private String code;

    /**
     * ä½¿ç”¨äºº
     */
    @TableField("user")
    private String user;

    /**
     * è”系方式
     */
    @TableField("phone")
    private String phone;

    /**
     * éƒ¨é—¨id
     */
    @TableField("depart_id")
    private Integer departId;

    /**
     * çŠ¶æ€1在线0离线
     */
    @TableField("state")
    private Short state;

    /**
     * åˆ›å»ºæ—¶é—´
     */
    @TableField("create_time")
    private LocalDateTime createTime;
}

 ycl-platform/src/main/java/com/ycl/entity/equipment/Loudspeaker.java

New file
@@ -0,0 +1,85 @@
package com.ycl.entity.equipment;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.time.LocalDateTime;


/**
 * éŸ³æŸ±
 *
 * @version V1.0
 * @author: AI
 * @date: 2022-10-31 14:55
 **/
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("ums_equipment_loudspeaker")
public class Loudspeaker implements Serializable {
    /**
     * ä¸»é”®
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * åç§°
     */
    @TableField("name")
    private String name;

    /**
     * ç¼–号
     */
    @TableField("code")
    private String code;

    /**
     * åŠŸçŽ‡
     */
    @TableField("power")
    private String power;

    /**
     * é¢‘率响应
     */
    @TableField("frequency_response")
    private String frequencyResponse;

    /**
     * å–‡å­å•å…ƒ
     */
    @TableField("full_range_speaker")
    private String fullRangeSpeaker;

    /**
     * ç»åº¦
     */
    @TableField("longitude")
    private Double longitude;

    /**
     * çº¬åº¦
     */
    @TableField("latitude")
    private Double latitude;


    /**
     * çŠ¶æ€1在线0离线
     */
    @TableField("state")
    private Short state;

    /**
     * åˆ›å»ºæ—¶é—´
     */
    @TableField("create_time")
    private LocalDateTime createTime;
}

 ycl-platform/src/main/java/com/ycl/mapper/equipment/HandheldTerminalMapper.java

New file
@@ -0,0 +1,20 @@
package com.ycl.mapper.equipment;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.vo.equipment.HandheldTerminalVo;
import com.ycl.entity.equipment.HandheldTerminal;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * æ‰‹æŒè®¾å¤‡ç®¡ç† Mapper æŽ¥å£
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
public interface HandheldTerminalMapper extends BaseMapper<HandheldTerminal> {

    Page<HandheldTerminalVo> search(Page<HandheldTerminalVo> page, @Param("state") Short state);
}

 ycl-platform/src/main/java/com/ycl/mapper/equipment/LoudspeakerMapper.java

New file
@@ -0,0 +1,16 @@
package com.ycl.mapper.equipment;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.entity.equipment.Loudspeaker;

/**
 * <p>
 * éŸ³æŸ±ç®¡ç† Mapper æŽ¥å£
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
public interface LoudspeakerMapper extends BaseMapper<Loudspeaker> {

}

 ycl-platform/src/main/java/com/ycl/service/equipment/IHandheldTerminalService.java

New file
@@ -0,0 +1,18 @@
package com.ycl.service.equipment;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.vo.equipment.HandheldTerminalVo;
import com.ycl.entity.equipment.HandheldTerminal;

/**
 * <p>
 * æ‰‹æŒè®¾å¤‡ç®¡ç† æœåŠ¡ç±»
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
public interface IHandheldTerminalService extends IService<HandheldTerminal> {
    Page<HandheldTerminalVo> search(Integer size, Integer current, Short state);
}

 ycl-platform/src/main/java/com/ycl/service/equipment/ILoudspeakerService.java

New file
@@ -0,0 +1,16 @@
package com.ycl.service.equipment;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.equipment.EquipmentBayonet;
import com.ycl.entity.equipment.Loudspeaker;

/**
 * <p>
 * éŸ³æŸ±ç®¡ç† æœåŠ¡ç±»
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
public interface ILoudspeakerService extends IService<Loudspeaker> {
}

 ycl-platform/src/main/java/com/ycl/service/equipment/impl/HandheldTerminalServiceImpl.java

New file
@@ -0,0 +1,27 @@
package com.ycl.service.equipment.impl;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.vo.equipment.HandheldTerminalVo;
import com.ycl.entity.equipment.HandheldTerminal;
import com.ycl.mapper.equipment.HandheldTerminalMapper;
import com.ycl.service.equipment.IHandheldTerminalService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * æ‰‹æŒè®¾å¤‡ç®¡ç† æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
@Service
public class HandheldTerminalServiceImpl extends ServiceImpl<HandheldTerminalMapper, HandheldTerminal> implements IHandheldTerminalService {
    @Override
    public Page<HandheldTerminalVo> search(Integer size, Integer current, Short state) {
        Page<HandheldTerminalVo> page = new Page<>(size, current);
        page = baseMapper.search(page, state);
        return page;
    }
}

 ycl-platform/src/main/java/com/ycl/service/equipment/impl/LoudspeakerServiceImpl.java

New file
@@ -0,0 +1,19 @@
package com.ycl.service.equipment.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.entity.equipment.Loudspeaker;
import com.ycl.mapper.equipment.LoudspeakerMapper;
import com.ycl.service.equipment.ILoudspeakerService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * éŸ³æŸ±ç®¡ç† æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author zhanghua
 * @since 2022-10-14
 */
@Service
public class LoudspeakerServiceImpl extends ServiceImpl<LoudspeakerMapper, Loudspeaker> implements ILoudspeakerService {
}

 ycl-platform/src/main/java/com/ycl/vo/equipment/HandheldTerminalVo.java

New file
@@ -0,0 +1,10 @@
package com.ycl.vo.equipment;

import com.ycl.entity.equipment.HandheldTerminal;
import lombok.Data;

@Data
public class HandheldTerminalVo extends HandheldTerminal {
    private String departName;
    private String pDepartName;
}

 ycl-platform/src/main/resources/mapper/equipment/HandheldTerminalMapper.xml

New file
@@ -0,0 +1,41 @@
<?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.ycl.mapper.equipment.HandheldTerminalMapper">

    <!-- é€šç”¨æŸ¥è¯¢æ˜ å°„结果 -->
    <resultMap id="BaseResultMap" type="com.ycl.entity.equipment.HandheldTerminal">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="name" property="name" jdbcType="VARCHAR"/>
        <result column="code" property="code" jdbcType="VARCHAR"/>
        <result column="user" property="user" jdbcType="VARCHAR"/>
        <result column="phone" property="phone" jdbcType="VARCHAR"/>
        <result column="depart_id" property="departId" jdbcType="INTEGER"/>
        <result column="state" property="state" jdbcType="INTEGER"/>
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP"/>
    </resultMap>

    <!-- é€šç”¨æŸ¥è¯¢ç»“果列 -->
    <sql id="Base_Column_List">
        id
        ,name,code,user,phone,depart_id,state,create_time
    </sql>

    <resultMap id="VoMap" type="com.ycl.vo.equipment.HandheldTerminalVo">
        <result column="depart_name" property="departName" jdbcType="VARCHAR"/>
        <result column="p_depart_name" property="pDepartName" jdbcType="VARCHAR"/>
    </resultMap>
    <select id="search" resultMap="VoMap">
        SELECT ht.*,IF(p.depart_name is null ,'',d.depart_name) depart_name,IFNULL(p.depart_name,d.depart_name)
        p_depart_name
        FROM ums_equipment_handheld_terminal ht
        LEFT JOIN ums_depart d on ht.depart_id = d.id
        LEFT JOIN ums_depart p on d.parent_id = p.id
        <where>
            <if test="state!=null">
                ht.state = #{carNum}
            </if>
        </where>
        order by ht.id desc
    </select>

</mapper>

 ycl-platform/src/main/resources/mapper/equipment/LoudspeakerMapper.xml

New file
@@ -0,0 +1,25 @@
<?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.ycl.mapper.equipment.LoudspeakerMapper">

    <!-- é€šç”¨æŸ¥è¯¢æ˜ å°„结果 -->
    <resultMap id="BaseResultMap" type="com.ycl.entity.equipment.Loudspeaker">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="name" property="name" jdbcType="VARCHAR"/>
        <result column="code" property="code" jdbcType="VARCHAR"/>
        <result column="power" property="power" jdbcType="VARCHAR"/>
        <result column="frequency_response" property="frequencyResponse" jdbcType="VARCHAR"/>
        <result column="full_range_speaker" property="fullRangeSpeaker" jdbcType="VARCHAR"/>
        <result column="longitude" property="longitude" jdbcType="FLOAT"/>
        <result column="latitude" property="latitude" jdbcType="FLOAT"/>
        <result column="state" property="state" jdbcType="INTEGER"/>
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP"/>
    </resultMap>

    <!-- é€šç”¨æŸ¥è¯¢ç»“果列 -->
    <sql id="Base_Column_List">
        id
        ,name,code,power,frequency_response,full_range_speaker,longitude,latitude,state,create_time
    </sql>

</mapper>