【丽水】随访建议

陈昶聿

6 小时以前 99810f5221dc88701fb2efdd700f9a92dccca55c

【丽水】随访建议

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskAdviceController.java

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

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

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.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.annotation.AddOrgId;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.ServiceSubtaskAdvice;
import com.smartor.service.IServiceSubtaskAdviceService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * éšè®¿å»ºè®®Controller
 *
 * @author ruoyi
 * @date 2026-08-14
 */
@RestController
@RequestMapping("/system/serviceSubtaskAdvice")
public class ServiceSubtaskAdviceController extends BaseController {
    @Autowired
    private IServiceSubtaskAdviceService serviceSubtaskAdviceService;


    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®åˆ—表
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:list')")
    @AddOrgId(field = "orgid", paramIndex = 0, campusField = "campusid")
    @PostMapping("list")
    public TableDataInfo list(@RequestBody ServiceSubtaskAdvice serviceSubtaskAdvice) {
        startPage();
        List<ServiceSubtaskAdvice> list = serviceSubtaskAdviceService.selectServiceSubtaskAdviceList(serviceSubtaskAdvice);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºéšè®¿å»ºè®®åˆ—表
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:export')")
    @Log(title = "随访建议", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ServiceSubtaskAdvice serviceSubtaskAdvice) {
        List<ServiceSubtaskAdvice> list = serviceSubtaskAdviceService.selectServiceSubtaskAdviceList(serviceSubtaskAdvice);
        ExcelUtil<ServiceSubtaskAdvice> util = new ExcelUtil<ServiceSubtaskAdvice>(ServiceSubtaskAdvice.class);
        util.exportExcel(response, list, "随访建议数据");
    }

    /**
     * èŽ·å–随访建议详细信息
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(serviceSubtaskAdviceService.selectServiceSubtaskAdviceById(id));
    }

    /**
     * æ–°å¢žéšè®¿å»ºè®®
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:add')")
    @Log(title = "随访建议", businessType = BusinessType.INSERT)
    @AddOrgId(field = "orgid", paramIndex = 0, campusField = "campusid")
    @PostMapping("/add")
    public AjaxResult add(@RequestBody ServiceSubtaskAdvice serviceSubtaskAdvice) {
        return toAjax(serviceSubtaskAdviceService.insertServiceSubtaskAdvice(serviceSubtaskAdvice));
    }

    /**
     * ä¿®æ”¹éšè®¿å»ºè®®
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:edit')")
    @Log(title = "随访建议", businessType = BusinessType.UPDATE)
    @AddOrgId(field = "orgid", paramIndex = 0, campusField = "campusid")
    @PostMapping("/edit")
    public AjaxResult edit(@RequestBody ServiceSubtaskAdvice serviceSubtaskAdvice) {
        return toAjax(serviceSubtaskAdviceService.updateServiceSubtaskAdvice(serviceSubtaskAdvice));
    }

    /**
     * åˆ é™¤éšè®¿å»ºè®®
     */
    //@PreAuthorize("@ss.hasPermi('system:serviceSubtaskAdvice:remove')")
    @Log(title = "随访建议", businessType = BusinessType.DELETE)
    @GetMapping("/remove/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(serviceSubtaskAdviceService.deleteServiceSubtaskAdviceByIds(ids));
    }
}

 smartor/src/main/java/com/smartor/domain/ServiceSubtaskAdvice.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,101 @@
package com.smartor.domain;

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import lombok.Data;
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;

/**
 * éšè®¿å»ºè®®è¡¨å¯¹è±¡ service_subtask_advice
 *
 * @author ruoyi
 * @date 2026-08-14
 */
@ApiModel(value = "ServiceSubtaskAdvice", description = "随访任务建议")
@Data
public class ServiceSubtaskAdvice extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** å»ºè®®ä¸»é”®ID */
    private Long id;

    /** ä»»åŠ¡ID */
    @Excel(name = "任务ID")
    private Long subid;

    /** æœåŠ¡ID */
    @Excel(name = "服务ID")
    private Long taskid;

    /** ç—…人ID */
    @Excel(name = "病人ID")
    private Long patid;

    /** å»ºè®®ç±»åž‹(1、投诉；2、建议；3、表扬) */
    @Excel(name = "建议类型(1、投诉；2、建议；3、表扬)")
    private String adviceType;

    /** æ¶‰åŠç§‘室代码，逗号分割，可多选 */
    @Excel(name = "涉及科室代码，逗号分割，可多选")
    private String deptCodes;

    /** æ¶‰åŠç—…区代码，逗号分割，可多选 */
    @Excel(name = "涉及病区代码，逗号分割，可多选")
    private String wardCodes;

    /** æ¶‰åŠäººå‘˜ä»£ç ï¼Œé€—号分割，可多选 */
    @Excel(name = "涉及人员代码，逗号分割，可多选")
    private String involvedUsers;

    /** å†…容 */
    @Excel(name = "内容")
    private String content;

    /** æœºæž„编码 */
    @Excel(name = "机构编码")
    private String orgid;

    /** åˆ é™¤çŠ¶æ€ */
    @Excel(name = "删除状态")
    private String delFlag;

    /** åˆ›å»ºæ—¶é—´ */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "创建时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    /** æ›´æ–°æ—¶é—´ */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "更新时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date updateTime;

    /** æŽ’序 */
    @Excel(name = "排序")
    private Long sort;

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("subid", getSubid())
            .append("taskid", getTaskid())
            .append("patid", getPatid())
            .append("adviceType", getAdviceType())
            .append("deptCodes", getDeptCodes())
            .append("wardCodes", getWardCodes())
            .append("involvedUsers", getInvolvedUsers())
            .append("content", getContent())
            .append("remark", getRemark())
            .append("orgid", getOrgid())
            .append("delFlag", getDelFlag())
            .append("createTime", getCreateTime())
            .append("updateTime", getUpdateTime())
            .append("sort", getSort())
            .toString();
    }
}

 smartor/src/main/java/com/smartor/mapper/ServiceSubtaskAdviceMapper.java

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

import java.util.List;
import com.smartor.domain.ServiceSubtaskAdvice;
import org.apache.ibatis.annotations.Mapper;

/**
 * éšè®¿å»ºè®®è¡¨Mapper接口
 *
 * @author ruoyi
 * @date 2026-08-14
 */
@Mapper
public interface ServiceSubtaskAdviceMapper
{
    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®
     *
     * @param id éšè®¿å»ºè®®ä¸»é”®
     * @return éšè®¿å»ºè®®
     */
    public ServiceSubtaskAdvice selectServiceSubtaskAdviceById(Long id);

    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®åˆ—表
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return éšè®¿å»ºè®®é›†åˆ
     */
    public List<ServiceSubtaskAdvice> selectServiceSubtaskAdviceList(ServiceSubtaskAdvice serviceSubtaskAdvice);

    /**
     * æ–°å¢žéšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    public int insertServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice);

    /**
     * ä¿®æ”¹éšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    public int updateServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice);

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

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

 smartor/src/main/java/com/smartor/service/IServiceSubtaskAdviceService.java

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

import java.util.List;

import com.smartor.domain.ServiceSubtaskAdvice;

/**
 * éšè®¿å»ºè®®Service接口
 *
 * @author ruoyi
 * @date 2026-08-14
 */
public interface IServiceSubtaskAdviceService
{
    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®
     *
     * @param id éšè®¿å»ºè®®ä¸»é”®
     * @return éšè®¿å»ºè®®
     */
    public ServiceSubtaskAdvice selectServiceSubtaskAdviceById(Long id);

    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®åˆ—表
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return éšè®¿å»ºè®®é›†åˆ
     */
    public List<ServiceSubtaskAdvice> selectServiceSubtaskAdviceList(ServiceSubtaskAdvice serviceSubtaskAdvice);

    /**
     * æ–°å¢žéšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    public int insertServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice);

    /**
     * ä¿®æ”¹éšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    public int updateServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice);

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

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

 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAdviceServiceImpl.java

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

import java.util.List;

import com.ruoyi.common.utils.DateUtils;
import com.smartor.mapper.ServiceSubtaskAdviceMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.smartor.domain.ServiceSubtaskAdvice;
import com.smartor.service.IServiceSubtaskAdviceService;

/**
 * éšè®¿å»ºè®®Service业务层处理
 *
 * @author ruoyi
 * @date 2026-08-14
 */
@Service
public class ServiceSubtaskAdviceServiceImpl implements IServiceSubtaskAdviceService
{
    @Autowired
    private ServiceSubtaskAdviceMapper serviceSubtaskAdviceMapper;

    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®
     *
     * @param id éšè®¿å»ºè®®ä¸»é”®
     * @return éšè®¿å»ºè®®
     */
    @Override
    public ServiceSubtaskAdvice selectServiceSubtaskAdviceById(Long id)
    {
        return serviceSubtaskAdviceMapper.selectServiceSubtaskAdviceById(id);
    }

    /**
     * æŸ¥è¯¢éšè®¿å»ºè®®åˆ—表
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return éšè®¿å»ºè®®
     */
    @Override
    public List<ServiceSubtaskAdvice> selectServiceSubtaskAdviceList(ServiceSubtaskAdvice serviceSubtaskAdvice)
    {
        return serviceSubtaskAdviceMapper.selectServiceSubtaskAdviceList(serviceSubtaskAdvice);
    }

    /**
     * æ–°å¢žéšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    @Override
    public int insertServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice)
    {
        serviceSubtaskAdvice.setCreateTime(DateUtils.getNowDate());
        return serviceSubtaskAdviceMapper.insertServiceSubtaskAdvice(serviceSubtaskAdvice);
    }

    /**
     * ä¿®æ”¹éšè®¿å»ºè®®
     *
     * @param serviceSubtaskAdvice éšè®¿å»ºè®®
     * @return ç»“æžœ
     */
    @Override
    public int updateServiceSubtaskAdvice(ServiceSubtaskAdvice serviceSubtaskAdvice)
    {
        serviceSubtaskAdvice.setUpdateTime(DateUtils.getNowDate());
        return serviceSubtaskAdviceMapper.updateServiceSubtaskAdvice(serviceSubtaskAdvice);
    }

    /**
     * æ‰¹é‡åˆ é™¤éšè®¿å»ºè®®
     *
     * @param ids éœ€è¦åˆ é™¤çš„随访建议主键集合
     * @return ç»“æžœ
     */
    @Override
    public int deleteServiceSubtaskAdviceByIds(Long[] ids)
    {
        return serviceSubtaskAdviceMapper.deleteServiceSubtaskAdviceByIds(ids);
    }

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

 smartor/src/main/resources/mapper/smartor/ServiceSubtaskAdviceMapper.xml

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

    <resultMap type="ServiceSubtaskAdvice" id="ServiceSubtaskAdviceResult">
        <result property="id"    column="id"    />
        <result property="subid"    column="subid"    />
        <result property="taskid"    column="taskid"    />
        <result property="patid"    column="patid"    />
        <result property="adviceType"    column="advice_type"    />
        <result property="deptCodes"    column="dept_codes"    />
        <result property="wardCodes"    column="ward_codes"    />
        <result property="involvedUsers"    column="involved_users"    />
        <result property="content"    column="content"    />
        <result property="remark"    column="remark"    />
        <result property="orgid"    column="orgid"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="sort"    column="sort"    />
    </resultMap>

    <sql id="selectServiceSubtaskAdviceVo">
        select id, subid, taskid, patid, advice_type, dept_codes, ward_codes, involved_users, content, remark, orgid, del_flag, create_by, create_time, update_by, update_time, sort from service_subtask_advice
    </sql>

    <select id="selectServiceSubtaskAdviceList" parameterType="ServiceSubtaskAdvice" resultMap="ServiceSubtaskAdviceResult">
        <include refid="selectServiceSubtaskAdviceVo"/>
        where del_flag = '0'
        <if test="orgid != null and orgid != ''">
            AND orgid = #{orgid}
        </if>
        <if test="subid != null "> and subid = #{subid}</if>
        <if test="taskid != null "> and taskid = #{taskid}</if>
        <if test="patid != null "> and patid = #{patid}</if>
        <if test="adviceType != null  and adviceType != ''"> and advice_type = #{adviceType}</if>
        <if test="deptCodes != null  and deptCodes != ''"> and dept_codes = #{deptCodes}</if>
        <if test="wardCodes != null  and wardCodes != ''"> and ward_codes = #{wardCodes}</if>
        <if test="involvedUsers != null  and involvedUsers != ''"> and involved_users = #{involvedUsers}</if>
        <if test="content != null  and content != ''"> and content like concat('%', #{content}, '%')</if>
        <if test="createBy != null  and createBy != ''"> and create_by = #{createBy}</if>
        <if test="updateBy != null  and updateBy != ''"> and update_by = #{updateBy}</if>
        <if test="sort != null "> and sort = #{sort}</if>
        order by sort asc, id desc
    </select>

    <select id="selectServiceSubtaskAdviceById" parameterType="Long" resultMap="ServiceSubtaskAdviceResult">
        <include refid="selectServiceSubtaskAdviceVo"/>
        where id = #{id} and del_flag = '0'
    </select>

    <insert id="insertServiceSubtaskAdvice" parameterType="ServiceSubtaskAdvice" useGeneratedKeys="true" keyProperty="id">
        insert into service_subtask_advice
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="subid != null">subid,</if>
            <if test="taskid != null">taskid,</if>
            <if test="patid != null">patid,</if>
            <if test="adviceType != null">advice_type,</if>
            <if test="deptCodes != null">dept_codes,</if>
            <if test="wardCodes != null">ward_codes,</if>
            <if test="involvedUsers != null">involved_users,</if>
            <if test="content != null">content,</if>
            <if test="remark != null">remark,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="sort != null">sort,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="subid != null">#{subid},</if>
            <if test="taskid != null">#{taskid},</if>
            <if test="patid != null">#{patid},</if>
            <if test="adviceType != null">#{adviceType},</if>
            <if test="deptCodes != null">#{deptCodes},</if>
            <if test="wardCodes != null">#{wardCodes},</if>
            <if test="involvedUsers != null">#{involvedUsers},</if>
            <if test="content != null">#{content},</if>
            <if test="remark != null">#{remark},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="sort != null">#{sort},</if>
         </trim>
    </insert>

    <update id="updateServiceSubtaskAdvice" parameterType="ServiceSubtaskAdvice">
        update service_subtask_advice
        <trim prefix="SET" suffixOverrides=",">
            <if test="subid != null">subid = #{subid},</if>
            <if test="taskid != null">taskid = #{taskid},</if>
            <if test="patid != null">patid = #{patid},</if>
            <if test="adviceType != null">advice_type = #{adviceType},</if>
            <if test="deptCodes != null">dept_codes = #{deptCodes},</if>
            <if test="wardCodes != null">ward_codes = #{wardCodes},</if>
            <if test="involvedUsers != null">involved_users = #{involvedUsers},</if>
            <if test="content != null">content = #{content},</if>
            <if test="remark != null">remark = #{remark},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="sort != null">sort = #{sort},</if>
        </trim>
        where id = #{id}
    </update>

    <update id="deleteServiceSubtaskAdviceById" parameterType="Long">
        update service_subtask_advice set del_flag = '1' where id = #{id}
    </update>

    <update id="deleteServiceSubtaskAdviceByIds" parameterType="Long">
        update service_subtask_advice set del_flag = '1' where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </update>
</mapper>