代码提交

liusheng

2023-12-22 7f9e11864762e6a1f9231a7657e736d81b2abeb4

代码提交

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

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

import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.IvrLibaScriptTarget;
import com.smartor.service.IIvrLibaScriptTargetService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

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

/**
 * é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“Controller
 *
 * @author ruoyi
 * @date 2023-12-21
 */
@RestController
@RequestMapping("/smartor/scripttarget")
public class IvrLibaScriptTargetController extends BaseController {
    @Autowired
    private IIvrLibaScriptTargetService ivrLibaScriptTargetService;

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:target:list')")
    @PostMapping("/list")
    public TableDataInfo list(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
        startPage();
        List<IvrLibaScriptTarget> list = ivrLibaScriptTargetService.selectIvrLibaScriptTargetList(ivrLibaScriptTarget);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®é¢˜è¯æœ¯æŒ‡æ ‡åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:target:export')")
    @Log(title = "问题话术指标库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaScriptTarget ivrLibaScriptTarget) {
        List<IvrLibaScriptTarget> list = ivrLibaScriptTargetService.selectIvrLibaScriptTargetList(ivrLibaScriptTarget);
        ExcelUtil<IvrLibaScriptTarget> util = new ExcelUtil<IvrLibaScriptTarget>(IvrLibaScriptTarget.class);
        util.exportExcel(response, list, "问题话术指标库数据");
    }

    /**
     * èŽ·å–问题话术指标库详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:target:query')")
    @GetMapping(value = "/getInfo/{questionTargetID}")
    public AjaxResult getInfo(@PathVariable("questionTargetID") String questionTargetID) {
        return success(ivrLibaScriptTargetService.selectIvrLibaScriptTargetByQuestionTargetID(questionTargetID));
    }

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('system:target:add')")
    @Log(title = "问题话术指标库", businessType = BusinessType.INSERT)
    @PostMapping("/add")
    public AjaxResult add(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
        return toAjax(ivrLibaScriptTargetService.insertIvrLibaScriptTarget(ivrLibaScriptTarget));
    }

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('system:target:edit')")
    @Log(title = "问题话术指标库", businessType = BusinessType.UPDATE)
    @PostMapping("/edit")
    public AjaxResult edit(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
        return toAjax(ivrLibaScriptTargetService.updateIvrLibaScriptTarget(ivrLibaScriptTarget));
    }

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('system:target:remove')")
    @Log(title = "问题话术指标库", businessType = BusinessType.DELETE)
    @GetMapping("/remove/{questionTargetIDs}")
    public AjaxResult remove(@PathVariable Integer[] ids) {
        return toAjax(ivrLibaScriptTargetService.deleteIvrLibaScriptTargetByQuestionTargetIDs(ids));
    }
}

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

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

import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

/**
 * é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“对象 ivr_liba_script_target
 *
 * @author ruoyi
 * @date 2023-12-21
 */
@Data
@ApiModel(value = "IvrLibaScriptTarget", description = "问题话术指标库对象")
public class IvrLibaScriptTarget extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("主键")
    private Long id;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("问题id")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long scriptid;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("指标ID")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long targetID;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("指标类型")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String targetType;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("类别名")
    @Excel(name = "${类别名}", readConverterExp = "$column.readConverterExp()")
    private String categoryName;

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

    /**
     * $column.columnComment
     */
    @ApiModelProperty("基础的正则")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String basicRegex;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("本身的正则")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String selfRegex;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("正则使用类型")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String regexUsedType;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("分页")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long sort;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("版本")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long version;

    /**
     * $column.columnComment
     */
    @ApiModelProperty("是否可用")
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long isEnable;


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

    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty("删除标记")
    private String delFlag;

    /**
     * ä¸Šä¼ æ ‡è®°
     */
    @ApiModelProperty("上传标记")
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    private Long isupload;

    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @ApiModelProperty("上传时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;

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

    /**
     * çˆ¶ID
     */
    @ApiModelProperty("父ID")
    @Excel(name = "父ID")
    private Long pid;

    /**
     * GUID
     */
    @ApiModelProperty("GUID")
    @Excel(name = "GUID")
    private String guid;

    /**
     * æ˜¯å¦å­˜åœ¨æ“ä½œï¼š1 æ–°å¢ž 2修改 3删除
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;
}

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

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

import com.smartor.domain.IvrLibaScriptTarget;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“Mapper接口
 *
 * @author ruoyi
 * @date 2023-12-21
 */
@Mapper
public interface IvrLibaScriptTargetMapper {
    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param questionTargetID é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“主键
     * @return é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     */
    public IvrLibaScriptTarget selectIvrLibaScriptTargetByQuestionTargetID(String questionTargetID);

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“列表
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“集合
     */
    public List<IvrLibaScriptTarget> selectIvrLibaScriptTargetList(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param questionTargetID é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScriptTargetByQuestionTargetID(Long id);

}

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

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

import com.smartor.domain.IvrLibaScriptTarget;

import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“Service接口
 *
 * @author ruoyi
 * @date 2023-12-21
 */
public interface IIvrLibaScriptTargetService {
    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param questionTargetID é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“主键
     * @return é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     */
    public IvrLibaScriptTarget selectIvrLibaScriptTargetByQuestionTargetID(String questionTargetID);

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“列表
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“集合
     */
    public List<IvrLibaScriptTarget> selectIvrLibaScriptTargetList(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param ivrLibaScriptTarget é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);

    /**
     * æ‰¹é‡åˆ é™¤é—®é¢˜è¯æœ¯æŒ‡æ ‡åº“
     *
     * @param questionTargetIDs éœ€è¦åˆ é™¤çš„问题话术指标库主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScriptTargetByQuestionTargetIDs(Integer[] ids);

}

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

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

    <resultMap type="com.smartor.domain.IvrLibaScriptTarget" id="IvrLibaScriptTargetResult">
        <result property="id" column="id"/>
        <result property="scriptid" column="scriptid"/>
        <result property="targetID" column="targetID"/>
        <result property="targetType" column="targetType"/>
        <result property="categoryName" column="categoryName"/>
        <result property="targetValue" column="targetValue"/>
        <result property="basicRegex" column="basicRegex"/>
        <result property="selfRegex" column="selfRegex"/>
        <result property="regexUsedType" column="regexUsedType"/>
        <result property="sort" column="sort"/>
        <result property="version" column="version"/>
        <result property="isEnable" column="isEnable"/>
        <result property="tipsJson" column="tipsJson"/>
        <result property="delFlag" column="del_flag"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="orgid" column="orgid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
    </resultMap>

    <sql id="selectIvrLibaScriptTargetVo">
        select id,
               scriptid,
               targetID,
               targetType,
               categoryName,
               targetValue,
               basicRegex,
               selfRegex,
               regexUsedType,
               sort,
               version,
               isEnable,
               tipsJson,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               orgid,
               pid,
               guid
        from ivr_liba_script_target
    </sql>

    <select id="selectIvrLibaScriptTargetList" parameterType="com.smartor.domain.IvrLibaScriptTarget"
            resultMap="IvrLibaScriptTargetResult">
        <include refid="selectIvrLibaScriptTargetVo"/>
        <where>
            <if test="scriptid != null ">and scriptid = #{scriptid}</if>
            <if test="targetID != null ">and targetID = #{targetID}</if>
            <if test="targetType != null  and targetType != ''">and targetType = #{targetType}</if>
            <if test="categoryName != null  and categoryName != ''">and categoryName like concat('%', #{categoryName},
                '%')
            </if>
            <if test="targetValue != null  and targetValue != ''">and targetValue = #{targetValue}</if>
            <if test="basicRegex != null  and basicRegex != ''">and basicRegex = #{basicRegex}</if>
            <if test="selfRegex != null  and selfRegex != ''">and selfRegex = #{selfRegex}</if>
            <if test="regexUsedType != null  and regexUsedType != ''">and regexUsedType = #{regexUsedType}</if>
            <if test="sort != null ">and sort = #{sort}</if>
            <if test="version != null ">and version = #{version}</if>
            <if test="isEnable != null ">and isEnable = #{isEnable}</if>
            <if test="tipsJson != null  and tipsJson != ''">and tipsJson = #{tipsJson}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
        </where>
    </select>

    <select id="selectIvrLibaScriptTargetByQuestionTargetID" parameterType="String"
            resultMap="IvrLibaScriptTargetResult">
        <include refid="selectIvrLibaScriptTargetVo"/>
        where id = #{id}
    </select>

    <insert id="insertIvrLibaScriptTarget" parameterType="com.smartor.domain.IvrLibaScriptTarget">
        insert into ivr_liba_script_target
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="scriptid != null">scriptid,</if>
            <if test="targetID != null">targetID,</if>
            <if test="targetType != null">targetType,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="targetValue != null">targetValue,</if>
            <if test="basicRegex != null">basicRegex,</if>
            <if test="selfRegex != null">selfRegex,</if>
            <if test="regexUsedType != null">regexUsedType,</if>
            <if test="sort != null">sort,</if>
            <if test="version != null">version,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="tipsJson != null">tipsJson,</if>
            <if test="delFlag != null and delFlag != ''">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="orgid != null">orgid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="scriptid != null ">#{scriptid},</if>
            <if test="targetID != null">#{targetID},</if>
            <if test="targetType != null">#{targetType},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="targetValue != null">#{targetValue},</if>
            <if test="basicRegex != null">#{basicRegex},</if>
            <if test="selfRegex != null">#{selfRegex},</if>
            <if test="regexUsedType != null">#{regexUsedType},</if>
            <if test="sort != null">#{sort},</if>
            <if test="version != null">#{version},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="tipsJson != null">#{tipsJson},</if>
            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
        </trim>
    </insert>

    <update id="updateIvrLibaScriptTarget" parameterType="com.smartor.domain.IvrLibaScriptTarget">
        update ivr_liba_script_target
        <trim prefix="SET" suffixOverrides=",">
            <if test="scriptid != null">scriptid = #{scriptid},</if>
            <if test="targetID != null">targetID = #{targetID},</if>
            <if test="targetType != null">targetType = #{targetType},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="targetValue != null">targetValue = #{targetValue},</if>
            <if test="basicRegex != null">basicRegex = #{basicRegex},</if>
            <if test="selfRegex != null">selfRegex = #{selfRegex},</if>
            <if test="regexUsedType != null">regexUsedType = #{regexUsedType},</if>
            <if test="sort != null">sort = #{sort},</if>
            <if test="version != null">version = #{version},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="tipsJson != null">tipsJson = #{tipsJson},</if>
            <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteIvrLibaScriptTargetByQuestionTargetID" parameterType="Long">
        update ivr_liba_script_target
        <trim prefix="SET" suffixOverrides=",">
            <if test="delFlag != null and delFlag != ''">del_flag = 1</if>
        </trim>
        where id = #{id}
    </delete>

</mapper>