总结--2021-12-17

日志信息，公司id权限等-- （线路版本号设置）

Controller 4个接口

package com.spiov.cloud.schedule.controller;

import cn.iovnet.commons.utils.message.Messages;
import cn.iovnet.commons.utils.model.IovnetLog;
import cn.iovnet.commons.utils.util.CommonResponse;
import cn.iovnet.commons.utils.util.HttpUtil;
import cn.iovnet.commons.utils.util.IovnetLogUtil;
import com.baomidou.mybatisplus.plugins.Page;
import com.spiov.cloud.schedule.constants.DdyModuleNames;
import com.spiov.cloud.schedule.service.LineVersionService;
import com.spiov.cloud.schedule.vo.IdsVo;
import com.spiov.cloud.schedule.vo.LineVersionInfoVo;
import com.spiov.cloud.schedule.vo.LineVersionQueryVo;
import com.spiov.cloud.schedule.vo.UpdateLineVersionVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * 线路版本号设置
 *
 * @author duyq
 * @date 2021/12/14 08:56
 **/
@RestController
@RequestMapping("/sys/lineVersion")
public class LineVersionController {
    @Autowired
    private LineVersionService lineVersionService;

    /**
     * 查询线路版本号列表数据
     *
     * @param vo      查询条件
     * @param request
     * @return 线路版本号列表
     * @author guozh
     * @date 2021/12/17 13:50
     */
    @PostMapping("/getLineVersionList")
    public CommonResponse getLineVersionList(@RequestBody LineVersionQueryVo vo, HttpServletRequest request) {
        CommonResponse instance = CommonResponse.getInstance();
        Integer companyId = Integer.parseInt(HttpUtil.getCompanyId(request));
        Page<LineVersionQueryVo> page = new Page<>(vo.getCurrent(), vo.getSize());
        List<LineVersionInfoVo> lineVersion = lineVersionService.getLineVersionList(companyId, vo, page);
        instance.setResultData(lineVersion);
        instance.setTotalRowNumber(page.getTotal());
        IovnetLog log = IovnetLogUtil.getIovnetLog(request, DdyModuleNames.SYSTEM_SETUP_ID, DdyModuleNames.SYSTEM_SETUP_NAME, DdyModuleNames.LINE_VERSION_ID, DdyModuleNames.LINE_VERSION_NAME, "查询线路版本号列表数据");
        instance.setIovnetLog(log);
        return instance;
    }

    /**
     * 根据id查询线路版本号详情
     *
     * @param id 主键id
     * @return 线路版本号详情
     * @author guozh
     * @date 2021/12/17 14:03
     */
    @GetMapping("/getLineVersionDetail")
    public CommonResponse getLineVersionDetail(Integer id,HttpServletRequest request) {
        CommonResponse instance = CommonResponse.getInstance();
        LineVersionInfoVo vo = lineVersionService.getLineVersionDetail(id);
        instance.setResultData(vo);
        IovnetLog log = IovnetLogUtil.getIovnetLog(request, DdyModuleNames.SYSTEM_SETUP_ID, DdyModuleNames.SYSTEM_SETUP_NAME, DdyModuleNames.LINE_VERSION_ID, DdyModuleNames.LINE_VERSION_NAME, "根据id查询线路版本号详情");
        instance.setIovnetLog(log);
        return instance;
    }

    /**
     * 线路版本号设置-删除
     *
     * @param idsVo 主键id列表
     * @return 返回结果
     * @author guozh
     * @date 2021/12/17 14:30
     */
    @PostMapping("/deleteLineVersionData")
    public CommonResponse deleteLineVersionData(@RequestBody IdsVo idsVo,HttpServletRequest request) {
        CommonResponse instance = CommonResponse.getInstance();
        Boolean result = lineVersionService.deleteLineVersionData(idsVo);
        if (result) {
            instance.setResultData("删除成功！");
        } else {
            instance.setErrorCode(Messages.CODE_400103);
            instance.setResultData("删除失败！");
        }
        IovnetLog log = IovnetLogUtil.getIovnetLog(request, DdyModuleNames.SYSTEM_SETUP_ID, DdyModuleNames.SYSTEM_SETUP_NAME, DdyModuleNames.LINE_VERSION_ID, DdyModuleNames.LINE_VERSION_NAME, "线路版本号设置-删除");
        instance.setIovnetLog(log);
        return instance;
    }

    /**
     * 线路版本号设置-修改
     *
     * @param vo 修改信息
     * @return 返回结果
     * @author guozh
     * @date 2021/12/17 15:33
     */
    @PostMapping("/editLineVersionData")
    public CommonResponse editLineVersionData(@RequestBody UpdateLineVersionVo vo,HttpServletRequest request) {
        CommonResponse instance = CommonResponse.getInstance();
        lineVersionService.editLineVersionData(vo);
        IovnetLog log = IovnetLogUtil.getIovnetLog(request, DdyModuleNames.SYSTEM_SETUP_ID, DdyModuleNames.SYSTEM_SETUP_NAME, DdyModuleNames.LINE_VERSION_ID, DdyModuleNames.LINE_VERSION_NAME, "线路版本号设置-修改");
        instance.setIovnetLog(log);
        return instance;
    }


}

Service

package com.spiov.cloud.schedule.service;

import com.baomidou.mybatisplus.plugins.Page;
import com.spiov.cloud.schedule.vo.IdsVo;
import com.spiov.cloud.schedule.vo.LineVersionInfoVo;
import com.spiov.cloud.schedule.vo.LineVersionQueryVo;
import com.spiov.cloud.schedule.vo.UpdateLineVersionVo;

import java.util.List;

/**
 * 线路版本号设置接口服务
 *
 * @author duyq
 * @date 2021/12/14 15:29
 **/
public interface LineVersionService {


    /**
     * 查询线路版本号列表数据
     *
     * @param companyId 公司id
     * @param vo        查询条件
     * @param page      分页
     * @return 线路版本号列表
     * @author guozh
     * @date 2021/12/17 13:52
     */
    List<LineVersionInfoVo> getLineVersionList(Integer companyId, LineVersionQueryVo vo, Page<LineVersionQueryVo> page);

    /**
     * 根据id查询线路版本号详情
     *
     * @param id 主键id
     * @return 线路版本号详情
     * @author guozh
     * @date 2021/12/17 14:03
     */
    LineVersionInfoVo getLineVersionDetail(Integer id);

    /**
     * 线路版本号设置-删除
     *
     * @param idsVo 主键id列表
     * @return java.lang.Boolean
     * @author guozh
     * @date 2021/12/17 14:31
     */
    Boolean deleteLineVersionData(IdsVo idsVo);

    /**
     * 线路版本号设置-修改
     *
     * @param vo 修改信息
     * @return void
     * @author guozh
     * @date 2021/12/17 15:34
     */
    void editLineVersionData(UpdateLineVersionVo vo);
}

ServiceImpl

package com.spiov.cloud.schedule.service.impl;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.spiov.cloud.entity.mapper.DdyLineVersionDataMapper;
import com.spiov.cloud.entity.model.DdyLineVersionData;
import com.spiov.cloud.schedule.mapper.SystemSetupMapper;
import com.spiov.cloud.schedule.service.LineVersionService;
import com.spiov.cloud.schedule.vo.IdsVo;
import com.spiov.cloud.schedule.vo.LineVersionInfoVo;
import com.spiov.cloud.schedule.vo.LineVersionQueryVo;
import com.spiov.cloud.schedule.vo.UpdateLineVersionVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
 * 线路版本号设置接口服务实现
 *
 * @author duyq
 * @date 2021/12/14 09:28
 **/
@Service
public class LineVersionServiceImpl implements LineVersionService {


    @Autowired
    private SystemSetupMapper systemSetupMapper;
    @Autowired
    private DdyLineVersionDataMapper ddyLineVersionDataMapper;

    @Override
    public List<LineVersionInfoVo> getLineVersionList(Integer companyId, LineVersionQueryVo vo, Page<LineVersionQueryVo> page) {
        List<LineVersionInfoVo> lineVersion = systemSetupMapper.getLineVersionList(companyId, vo, page);
        return lineVersion;
    }

    @Override
    public LineVersionInfoVo getLineVersionDetail(Integer id) {
        LineVersionInfoVo vo = systemSetupMapper.getLineVersionDetail(id);
        return vo;
    }

    @Override
    public Boolean deleteLineVersionData(IdsVo idsVo) {
        DdyLineVersionData lineVersionData = new DdyLineVersionData();
        lineVersionData.setDeleted(1);
        lineVersionData.setUpdateDate(new Date());
        EntityWrapper<DdyLineVersionData> wrapper = new EntityWrapper<>();
        wrapper.in("id",idsVo.getIdList());
        return ddyLineVersionDataMapper.update(lineVersionData,wrapper) > 0;
    }

    @Override
    public void editLineVersionData(UpdateLineVersionVo vo) {
        DdyLineVersionData lineVersionData = ddyLineVersionDataMapper.selectById(vo.getId());
        if (lineVersionData != null){
            lineVersionData.setLineId(vo.getLineId());
            lineVersionData.setLineDirection(vo.getLineDirection());
            lineVersionData.setHistoryVersion(vo.getHistoryVersion());
            lineVersionData.setVersion(vo.getVersion());
            lineVersionData.setEffectTime(vo.getEffectTime());
            lineVersionData.setUpdateDate(new Date());
        }
        ddyLineVersionDataMapper.updateAllColumnById(lineVersionData);
    }
}

Mapper接口

package com.spiov.cloud.schedule.mapper;

import com.baomidou.mybatisplus.plugins.Page;
import com.spiov.cloud.schedule.vo.LineVersionInfoVo;
import com.spiov.cloud.schedule.vo.LineVersionQueryVo;
import com.spiov.cloud.schedule.vo.OneWayTimeInfoVo;
import com.spiov.cloud.schedule.vo.OneWayTimeQueryVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 系统设置查询接口
 *
 * @author duyq
 * @date 2021/12/16 13:18
 **/
public interface SystemSetupMapper {


    /**
     * 查询线路版本号列表数据
     *
     * @param companyId 公司id
     * @param vo        查询条件
     * @param page      分页
     * @return 线路版本号列表
     * @author guozh
     * @date 2021/12/17 13:53
     */
    List<LineVersionInfoVo> getLineVersionList(@Param("companyId") Integer companyId, @Param("vo") LineVersionQueryVo vo, Page<LineVersionQueryVo> page);

    /**
     * 根据id查询线路版本号详情
     *
     * @param id 主键id
     * @return 线路版本号详情
     * @author guozh
     * @date 2021/12/17 14:04
     */
    LineVersionInfoVo getLineVersionDetail(@Param("id") Integer id);

    /**
     * 查询线路单程时间设置列表数据
     * @param companyId 公司id
	 * @param vo 查询条件
	 * @param page 分页
     * @return 线路单程时间列表
     * @author guozh
     * @date 2021/12/17 17:11
     */
    List<OneWayTimeInfoVo> getOneWayTimeList(@Param("companyId") Integer companyId,@Param("vo") OneWayTimeQueryVo vo, Page<OneWayTimeQueryVo> page);
}

Mapper.xml

<?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.spiov.cloud.schedule.mapper.SystemSetupMapper">


    <!-- 查询线路版本号列表 -->
    <select id="getLineVersionList" resultType="com.spiov.cloud.schedule.vo.LineVersionInfoVo">
        SELECT
        dlvd.id id,
        dlvd.company_id companyId,
        dlvd.dept_id deptId,
        dlvd.line_id lineId,
        dld.line_name lineName,
        dlvd.line_direction lineDirection,
        dlvd.history_version historyVersion,
        dlvd.version version,
        dlvd.effect_time effectTime,
        dlvd.invalid_time invalidTime,
        dlvd.effect_state effectState,
        dlvd.`disable` disable,
        dlvd.update_date updateDate,
        dlvd.create_date createDate
        FROM
        ddy_line_version_data dlvd
        LEFT JOIN
        ddy_line_data dld ON dlvd.line_id = dld.id
        <where>
            dlvd.company_id = #{companyId}
            <if test="vo.lineId != null and vo.lineId != ''">
                AND dlvd.line_id = #{vo.lineId}
            </if>
            <if test="vo.lineDirection != null">
                AND dlvd.line_direction = #{vo.lineDirection}
            </if>
            <if test="vo.effectTime != null and vo.effectTime != ''">
                AND DATE_FORMAT(dlvd.effect_time,'%Y-%m-%d') = #{vo.effectTime}
            </if>
        </where>
    </select>

    <!--根据id查询线路版本号详情-->
    <select id="getLineVersionDetail" resultType="com.spiov.cloud.schedule.vo.LineVersionInfoVo">
        SELECT
            dlvd.id id,
            dlvd.company_id companyId,
            dlvd.dept_id deptId,
            dlvd.line_id lineId,
            dld.line_name lineName,
            dlvd.line_direction lineDirection,
            dlvd.history_version historyVersion,
            dlvd.version version,
            dlvd.effect_time effectTime,
            dlvd.invalid_time invalidTime,
            dlvd.effect_state effectState,
            dlvd.`disable` disable,
            dlvd.update_date updateDate,
            dlvd.create_date createDate
        FROM
            ddy_line_version_data dlvd
        LEFT JOIN ddy_line_data dld ON dlvd.line_id = dld.id
        WHERE
            dlvd.id = #{id}
    </select>

    <!--查询线路单程时间设置列表数据-->
    <select id="getOneWayTimeList" resultType="com.spiov.cloud.schedule.vo.OneWayTimeInfoVo">
        SELECT
            dowtd.id id,
            dowtd.company_id companyId,
            dowtd.dept_id deptId,
            dowtd.line_id lineId,
            dld.line_name lineName,
            dowtd.line_direction lineDirection,
            dowtd.begin_time beginTime,
            dowtd.end_time endTime,
            dowtd.one_way_time oneWayTime,
            dowtd.`disable` disable,
            dowtd.deleted deleted,
            dowtd.update_date updateDate,
            dowtd.create_date createDate
        FROM
            ddy_one_way_time_data dowtd
        LEFT JOIN ddy_line_data dld ON dowtd.line_id = dld.id
        <where>
            dowtd.company_id = #{companyId}
            <if test="vo.lineId != null and vo.lineId != ''">
                AND dowtd.line_id = #{vo.lineId}
            </if>
            <if test="vo.lineDirection != null">
                AND dowtd.line_direction = #{vo.lineDirection}
            </if>
        </where>
    </select>
</mapper>