add wayline code

Zero2333333

2024-07-24 9f583e8fb1df4af1e761970e6a68e5908bea67fc

add wayline code

 ruoyi-admin/pom.xml

@@ -61,6 +61,12 @@
            <artifactId>ruoyi-generator</artifactId>
        </dependency>

        <!-- ç³»ç»ŸæŽ¥å£-->
        <dependency>
            <groupId>com.ruoyi</groupId>
            <artifactId>ruoyi-system</artifactId>
        </dependency>

    </dependencies>

    <build>

 ruoyi-admin/src/main/resources/application.yml

@@ -16,7 +16,7 @@
# å¼€å‘环境配置
server:
  # æœåŠ¡å™¨çš„HTTP端口，默认为8080
  port: 8080
  port: 8081
  servlet:
    # åº”用的访问路径
    context-path: /
@@ -122,7 +122,7 @@
# é˜²æ­¢XSS攻击
xss:
  # è¿‡æ»¤å¼€å…³
  enabled: true
  enabled: false
  # æŽ’除链接（多个用逗号分隔）
  excludes: /system/notice
  # åŒ¹é…é“¾æŽ¥

 ruoyi-system/src/main/java/com/ruoyi/system/controller/WaylineJobController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,98 @@
package com.ruoyi.system.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
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.system.domain.WaylineJob;
import com.ruoyi.system.service.IWaylineJobService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * èˆªçº¿Controller
 *
 * @author ruoyi
 * @date 2024-07-23
 */
@RestController
@RequestMapping("/system/job")
public class WaylineJobController extends BaseController
{
    @Autowired
    private IWaylineJobService waylineJobService;

    /**
     * æŸ¥è¯¢èˆªçº¿åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:job:list')")
    @GetMapping("/list")
    public TableDataInfo list(WaylineJob waylineJob)
    {
        startPage();
        List<WaylineJob> list = waylineJobService.selectWaylineJobList(waylineJob);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºèˆªçº¿åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:job:export')")
    @Log(title = "航线", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, WaylineJob waylineJob)
    {
        List<WaylineJob> list = waylineJobService.selectWaylineJobList(waylineJob);
        ExcelUtil<WaylineJob> util = new ExcelUtil<WaylineJob>(WaylineJob.class);
        util.exportExcel(response, list, "航线数据");
    }

    /**
     * èŽ·å–航线详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:job:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(waylineJobService.selectWaylineJobById(id));
    }

    /**
     * æ–°å¢žèˆªçº¿
     */
    @PreAuthorize("@ss.hasPermi('system:job:add')")
    @Log(title = "航线", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody WaylineJob waylineJob)
    {
        return toAjax(waylineJobService.insertWaylineJob(waylineJob));
    }

    /**
     * ä¿®æ”¹èˆªçº¿
     */
    @PreAuthorize("@ss.hasPermi('system:job:edit')")
    @Log(title = "航线", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody WaylineJob waylineJob)
    {
        return toAjax(waylineJobService.updateWaylineJob(waylineJob));
    }

    /**
     * åˆ é™¤èˆªçº¿
     */
    @PreAuthorize("@ss.hasPermi('system:job:remove')")
    @Log(title = "航线", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {

        return toAjax(waylineJobService.deleteWaylineJobByIds(ids));
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/domain/WaylineJob.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,68 @@
package com.ruoyi.system.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;

/**
 * èˆªçº¿å¯¹è±¡ wayline_job
 *
 * @author ruoyi
 * @date 2024-07-24
 */
public class WaylineJob extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private Long id;

    /** èˆªçº¿æ“ä½œ */
    @Excel(name = "航线操作")
    private String operations;

    /** $column.columnComment */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String name;

    public void setId(Long id)
    {
        this.id = id;
    }

    public Long getId()
    {
        return id;
    }
    public void setOperations(String operations)
    {
        this.operations = operations;
    }

    public String getOperations()
    {
        return operations;
    }
    public void setName(String name)
    {
        this.name = name;
    }

    public String getName()
    {
        return name;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
                .append("id", getId())
                .append("operations", getOperations())
                .append("createTime", getCreateTime())
                .append("updateTime", getUpdateTime())
                .append("name", getName())
                .append("remark", getRemark())
                .toString();
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/WaylineJobMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.system.mapper;

import java.util.List;
import com.ruoyi.system.domain.WaylineJob;

/**
 * èˆªçº¿Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
public interface WaylineJobMapper
{
    /**
     * æŸ¥è¯¢èˆªçº¿
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return èˆªçº¿
     */
    public WaylineJob selectWaylineJobById(Long id);

    /**
     * æŸ¥è¯¢èˆªçº¿åˆ—表
     *
     * @param waylineJob èˆªçº¿
     * @return èˆªçº¿é›†åˆ
     */
    public List<WaylineJob> selectWaylineJobList(WaylineJob waylineJob);

    /**
     * æ–°å¢žèˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    public int insertWaylineJob(WaylineJob waylineJob);

    /**
     * ä¿®æ”¹èˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    public int updateWaylineJob(WaylineJob waylineJob);

    /**
     * åˆ é™¤èˆªçº¿
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteWaylineJobById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤èˆªçº¿
     *
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteWaylineJobByIds(Long[] ids);
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/IWaylineJobService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.system.service;

import java.util.List;
import com.ruoyi.system.domain.WaylineJob;

/**
 * èˆªçº¿Service接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
public interface IWaylineJobService
{
    /**
     * æŸ¥è¯¢èˆªçº¿
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return èˆªçº¿
     */
    public WaylineJob selectWaylineJobById(Long id);

    /**
     * æŸ¥è¯¢èˆªçº¿åˆ—表
     *
     * @param waylineJob èˆªçº¿
     * @return èˆªçº¿é›†åˆ
     */
    public List<WaylineJob> selectWaylineJobList(WaylineJob waylineJob);

    /**
     * æ–°å¢žèˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    public int insertWaylineJob(WaylineJob waylineJob);

    /**
     * ä¿®æ”¹èˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    public int updateWaylineJob(WaylineJob waylineJob);

    /**
     * æ‰¹é‡åˆ é™¤èˆªçº¿
     *
     * @param ids éœ€è¦åˆ é™¤çš„航线主键集合
     * @return ç»“æžœ
     */
    public int deleteWaylineJobByIds(Long[] ids);

    /**
     * åˆ é™¤èˆªçº¿ä¿¡æ¯
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteWaylineJobById(Long id);
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/WaylineJobServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.ruoyi.system.service.impl;

import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.system.mapper.WaylineJobMapper;
import com.ruoyi.system.domain.WaylineJob;
import com.ruoyi.system.service.IWaylineJobService;

/**
 * èˆªçº¿Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Service
public class WaylineJobServiceImpl implements IWaylineJobService
{
    @Autowired
    private WaylineJobMapper waylineJobMapper;

    /**
     * æŸ¥è¯¢èˆªçº¿
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return èˆªçº¿
     */
    @Override
    public WaylineJob selectWaylineJobById(Long id)
    {
        return waylineJobMapper.selectWaylineJobById(id);
    }

    /**
     * æŸ¥è¯¢èˆªçº¿åˆ—表
     *
     * @param waylineJob èˆªçº¿
     * @return èˆªçº¿
     */
    @Override
    public List<WaylineJob> selectWaylineJobList(WaylineJob waylineJob)
    {
        return waylineJobMapper.selectWaylineJobList(waylineJob);
    }

    /**
     * æ–°å¢žèˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    @Override
    public int insertWaylineJob(WaylineJob waylineJob)
    {
        waylineJob.setCreateTime(DateUtils.getNowDate());
        return waylineJobMapper.insertWaylineJob(waylineJob);
    }

    /**
     * ä¿®æ”¹èˆªçº¿
     *
     * @param waylineJob èˆªçº¿
     * @return ç»“æžœ
     */
    @Override
    public int updateWaylineJob(WaylineJob waylineJob)
    {
        waylineJob.setUpdateTime(DateUtils.getNowDate());
        return waylineJobMapper.updateWaylineJob(waylineJob);
    }

    /**
     * æ‰¹é‡åˆ é™¤èˆªçº¿
     *
     * @param ids éœ€è¦åˆ é™¤çš„航线主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteWaylineJobByIds(Long[] ids)
    {
        return waylineJobMapper.deleteWaylineJobByIds(ids);
    }

    /**
     * åˆ é™¤èˆªçº¿ä¿¡æ¯
     *
     * @param id èˆªçº¿ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteWaylineJobById(Long id)
    {
        return waylineJobMapper.deleteWaylineJobById(id);
    }
}

 ruoyi-system/src/main/resources/mapper/system/WaylineJobMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,73 @@
<?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.system.mapper.WaylineJobMapper">

    <resultMap type="WaylineJob" id="WaylineJobResult">
        <result property="id"    column="id"    />
        <result property="operations"    column="operations"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
        <result property="name"    column="name"    />
        <result property="remark"    column="remark"    />
    </resultMap>

    <sql id="selectWaylineJobVo">
        select id, operations, create_time, update_time, name, remark from wayline_job
    </sql>

    <select id="selectWaylineJobList" parameterType="WaylineJob" resultMap="WaylineJobResult">
        <include refid="selectWaylineJobVo"/>
        <where>
            <if test="operations != null  and operations != ''"> and operations = #{operations}</if>
            <if test="name != null  and name != ''"> and name like concat('%', #{name}, '%')</if>
        </where>
    </select>

    <select id="selectWaylineJobById" parameterType="Long" resultMap="WaylineJobResult">
        <include refid="selectWaylineJobVo"/>
        where id = #{id}
    </select>

    <insert id="insertWaylineJob" parameterType="WaylineJob" useGeneratedKeys="true" keyProperty="id">
        insert into wayline_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="operations != null and operations != ''">operations,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="name != null">name,</if>
            <if test="remark != null">remark,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="operations != null and operations != ''">#{operations},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="name != null">#{name},</if>
            <if test="remark != null">#{remark},</if>
        </trim>
    </insert>

    <update id="updateWaylineJob" parameterType="WaylineJob">
        update wayline_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="operations != null and operations != ''">operations = #{operations},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="name != null">name = #{name},</if>
            <if test="remark != null">remark = #{remark},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteWaylineJobById" parameterType="Long">
        delete from wayline_job where id = #{id}
    </delete>

    <delete id="deleteWaylineJobByIds" parameterType="String">
        delete from wayline_job where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>