From 9f583e8fb1df4af1e761970e6a68e5908bea67fc Mon Sep 17 00:00:00 2001 From: Zero2333333 <764361881@qq.com> Date: 星期三, 24 七月 2024 14:04:38 +0800 Subject: [PATCH] add wayline code --- ruoyi-system/src/main/java/com/ruoyi/system/service/IWaylineJobService.java | 61 +++++++ ruoyi-system/src/main/java/com/ruoyi/system/domain/WaylineJob.java | 68 ++++++++ ruoyi-admin/pom.xml | 6 ruoyi-system/src/main/java/com/ruoyi/system/controller/WaylineJobController.java | 98 ++++++++++++ ruoyi-system/src/main/resources/mapper/system/WaylineJobMapper.xml | 73 +++++++++ ruoyi-admin/src/main/resources/application.yml | 4 ruoyi-system/src/main/java/com/ruoyi/system/mapper/WaylineJobMapper.java | 61 +++++++ ruoyi-system/src/main/java/com/ruoyi/system/service/impl/WaylineJobServiceImpl.java | 96 ++++++++++++ 8 files changed, 465 insertions(+), 2 deletions(-) diff --git a/ruoyi-admin/pom.xml b/ruoyi-admin/pom.xml index b97ef88..8f9a09f 100644 --- a/ruoyi-admin/pom.xml +++ b/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> diff --git a/ruoyi-admin/src/main/resources/application.yml b/ruoyi-admin/src/main/resources/application.yml index 569d225..b6ff297 100644 --- a/ruoyi-admin/src/main/resources/application.yml +++ b/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 # 鍖归厤閾炬帴 diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/controller/WaylineJobController.java b/ruoyi-system/src/main/java/com/ruoyi/system/controller/WaylineJobController.java new file mode 100644 index 0000000..7c0b0b8 --- /dev/null +++ b/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)); + } +} \ No newline at end of file diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/domain/WaylineJob.java b/ruoyi-system/src/main/java/com/ruoyi/system/domain/WaylineJob.java new file mode 100644 index 0000000..62c032d --- /dev/null +++ b/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(); + } +} diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/WaylineJobMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/WaylineJobMapper.java new file mode 100644 index 0000000..f7a5663 --- /dev/null +++ b/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); +} diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/IWaylineJobService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/IWaylineJobService.java new file mode 100644 index 0000000..3936541 --- /dev/null +++ b/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); +} diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/WaylineJobServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/WaylineJobServiceImpl.java new file mode 100644 index 0000000..3603a13 --- /dev/null +++ b/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); + } +} diff --git a/ruoyi-system/src/main/resources/mapper/system/WaylineJobMapper.xml b/ruoyi-system/src/main/resources/mapper/system/WaylineJobMapper.xml new file mode 100644 index 0000000..776e2e6 --- /dev/null +++ b/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> \ No newline at end of file -- Gitblit v1.9.3