yxh

yxh

2023-03-22 77187eabbf216b5d8283e69708132e2ca75b5f95

yxh

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaExtemplate;
import com.smartor.service.IIvrLibaExtemplateService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrextemplate")
public class IvrLibaExtemplateController extends BaseController
{
    @Autowired
    private IIvrLibaExtemplateService ivrLibaExtemplateService;

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaExtemplate ivrLibaExtemplate)
    {
        startPage();
        List<IvrLibaExtemplate> list = ivrLibaExtemplateService.selectIvrLibaExtemplateList(ivrLibaExtemplate);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ‰©å±•è¯æœ¯æ¨¡æ¿åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:export')")
    @Log(title = "扩展话术模板库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaExtemplate ivrLibaExtemplate)
    {
        List<IvrLibaExtemplate> list = ivrLibaExtemplateService.selectIvrLibaExtemplateList(ivrLibaExtemplate);
        ExcelUtil<IvrLibaExtemplate> util = new ExcelUtil<IvrLibaExtemplate>(IvrLibaExtemplate.class);
        util.exportExcel(response, list, "扩展话术模板库数据");
    }

    /**
     * èŽ·å–扩展话术模板库详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:query')")
    @GetMapping(value = "/{subModuleID}")
    public AjaxResult getInfo(@PathVariable("subModuleID") String subModuleID)
    {
        return success(ivrLibaExtemplateService.selectIvrLibaExtemplateBySubModuleID(subModuleID));
    }

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:add')")
    @Log(title = "扩展话术模板库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaExtemplate ivrLibaExtemplate)
    {
        return toAjax(ivrLibaExtemplateService.insertIvrLibaExtemplate(ivrLibaExtemplate));
    }

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:edit')")
    @Log(title = "扩展话术模板库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaExtemplate ivrLibaExtemplate)
    {
        return toAjax(ivrLibaExtemplateService.updateIvrLibaExtemplate(ivrLibaExtemplate));
    }

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:remove')")
    @Log(title = "扩展话术模板库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{subModuleIDs}")
    public AjaxResult remove(@PathVariable String[] subModuleIDs)
    {
        return toAjax(ivrLibaExtemplateService.deleteIvrLibaExtemplateBySubModuleIDs(subModuleIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaExtemplatescript;
import com.smartor.service.IIvrLibaExtemplatescriptService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrextemplatescript")
public class IvrLibaExtemplatescriptController extends BaseController
{
    @Autowired
    private IIvrLibaExtemplatescriptService ivrLibaExtemplatescriptService;

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        startPage();
        List<IvrLibaExtemplatescript> list = ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:export')")
    @Log(title = "扩展话术模板库话术", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        List<IvrLibaExtemplatescript> list = ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript);
        ExcelUtil<IvrLibaExtemplatescript> util = new ExcelUtil<IvrLibaExtemplatescript>(IvrLibaExtemplatescript.class);
        util.exportExcel(response, list, "扩展话术模板库话术数据");
    }

    /**
     * èŽ·å–扩展话术模板库话术详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:query')")
    @GetMapping(value = "/{DetailID}")
    public AjaxResult getInfo(@PathVariable("DetailID") String DetailID)
    {
        return success(ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptByDetailID(DetailID));
    }

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:add')")
    @Log(title = "扩展话术模板库话术", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        return toAjax(ivrLibaExtemplatescriptService.insertIvrLibaExtemplatescript(ivrLibaExtemplatescript));
    }

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:edit')")
    @Log(title = "扩展话术模板库话术", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        return toAjax(ivrLibaExtemplatescriptService.updateIvrLibaExtemplatescript(ivrLibaExtemplatescript));
    }

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:remove')")
    @Log(title = "扩展话术模板库话术", businessType = BusinessType.DELETE)
    @DeleteMapping("/{DetailIDs}")
    public AjaxResult remove(@PathVariable String[] DetailIDs)
    {
        return toAjax(ivrLibaExtemplatescriptService.deleteIvrLibaExtemplatescriptByDetailIDs(DetailIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaScript;
import com.smartor.service.IIvrLibaScriptService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * è¯æœ¯åº“Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrlibascript")
public class IvrLibaScriptController extends BaseController
{
    @Autowired
    private IIvrLibaScriptService ivrLibaScriptService;

    /**
     * æŸ¥è¯¢è¯æœ¯åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaScript ivrLibaScript)
    {
        startPage();
        List<IvrLibaScript> list = ivrLibaScriptService.selectIvrLibaScriptList(ivrLibaScript);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè¯æœ¯åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:export')")
    @Log(title = "话术库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaScript ivrLibaScript)
    {
        List<IvrLibaScript> list = ivrLibaScriptService.selectIvrLibaScriptList(ivrLibaScript);
        ExcelUtil<IvrLibaScript> util = new ExcelUtil<IvrLibaScript>(IvrLibaScript.class);
        util.exportExcel(response, list, "话术库数据");
    }

    /**
     * èŽ·å–话术库详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:query')")
    @GetMapping(value = "/{questionid}")
    public AjaxResult getInfo(@PathVariable("questionid") String questionid)
    {
        return success(ivrLibaScriptService.selectIvrLibaScriptByQuestionid(questionid));
    }

    /**
     * æ–°å¢žè¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:add')")
    @Log(title = "话术库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaScript ivrLibaScript)
    {
        return toAjax(ivrLibaScriptService.insertIvrLibaScript(ivrLibaScript));
    }

    /**
     * ä¿®æ”¹è¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:edit')")
    @Log(title = "话术库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaScript ivrLibaScript)
    {
        return toAjax(ivrLibaScriptService.updateIvrLibaScript(ivrLibaScript));
    }

    /**
     * åˆ é™¤è¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:remove')")
    @Log(title = "话术库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{questionids}")
    public AjaxResult remove(@PathVariable String[] questionids)
    {
        return toAjax(ivrLibaScriptService.deleteIvrLibaScriptByQuestionids(questionids));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaScripttarget;
import com.smartor.service.IIvrLibaScripttargetService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * è¯æœ¯åº“话术指标Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrscripttarget")
public class IvrLibaScripttargetController extends BaseController
{
    @Autowired
    private IIvrLibaScripttargetService ivrLibaScripttargetService;

    /**
     * æŸ¥è¯¢è¯æœ¯åº“话术指标列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaScripttarget ivrLibaScripttarget)
    {
        startPage();
        List<IvrLibaScripttarget> list = ivrLibaScripttargetService.selectIvrLibaScripttargetList(ivrLibaScripttarget);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè¯æœ¯åº“话术指标列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget: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('smartor:ivrscripttarget:query')")
    @GetMapping(value = "/{questionTargetID}")
    public AjaxResult getInfo(@PathVariable("questionTargetID") String questionTargetID)
    {
        return success(ivrLibaScripttargetService.selectIvrLibaScripttargetByQuestionTargetID(questionTargetID));
    }

    /**
     * æ–°å¢žè¯æœ¯åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:add')")
    @Log(title = "话术库话术指标", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaScripttarget ivrLibaScripttarget)
    {
        return toAjax(ivrLibaScripttargetService.insertIvrLibaScripttarget(ivrLibaScripttarget));
    }

    /**
     * ä¿®æ”¹è¯æœ¯åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:edit')")
    @Log(title = "话术库话术指标", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaScripttarget ivrLibaScripttarget)
    {
        return toAjax(ivrLibaScripttargetService.updateIvrLibaScripttarget(ivrLibaScripttarget));
    }

    /**
     * åˆ é™¤è¯æœ¯åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:remove')")
    @Log(title = "话术库话术指标", businessType = BusinessType.DELETE)
    @DeleteMapping("/{questionTargetIDs}")
    public AjaxResult remove(@PathVariable String[] questionTargetIDs)
    {
        return toAjax(ivrLibaScripttargetService.deleteIvrLibaScripttargetByQuestionTargetIDs(questionTargetIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaTarget;
import com.smartor.service.IIvrLibaTargetService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æŒ‡æ ‡åº“Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrtarget")
public class IvrLibaTargetController extends BaseController
{
    @Autowired
    private IIvrLibaTargetService ivrLibaTargetService;

    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaTarget ivrLibaTarget)
    {
        startPage();
        List<IvrLibaTarget> list = ivrLibaTargetService.selectIvrLibaTargetList(ivrLibaTarget);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæŒ‡æ ‡åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:export')")
    @Log(title = "指标库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaTarget ivrLibaTarget)
    {
        List<IvrLibaTarget> list = ivrLibaTargetService.selectIvrLibaTargetList(ivrLibaTarget);
        ExcelUtil<IvrLibaTarget> util = new ExcelUtil<IvrLibaTarget>(IvrLibaTarget.class);
        util.exportExcel(response, list, "指标库数据");
    }

    /**
     * èŽ·å–指标库详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:query')")
    @GetMapping(value = "/{targetID}")
    public AjaxResult getInfo(@PathVariable("targetID") String targetID)
    {
        return success(ivrLibaTargetService.selectIvrLibaTargetByTargetID(targetID));
    }

    /**
     * æ–°å¢žæŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:add')")
    @Log(title = "指标库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaTarget ivrLibaTarget)
    {
        return toAjax(ivrLibaTargetService.insertIvrLibaTarget(ivrLibaTarget));
    }

    /**
     * ä¿®æ”¹æŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:edit')")
    @Log(title = "指标库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaTarget ivrLibaTarget)
    {
        return toAjax(ivrLibaTargetService.updateIvrLibaTarget(ivrLibaTarget));
    }

    /**
     * åˆ é™¤æŒ‡æ ‡åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:remove')")
    @Log(title = "指标库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{targetIDs}")
    public AjaxResult remove(@PathVariable String[] targetIDs)
    {
        return toAjax(ivrLibaTargetService.deleteIvrLibaTargetByTargetIDs(targetIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaTemplate;
import com.smartor.service.IIvrLibaTemplateService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * è¯æœ¯æ¨¡æ¿åº“Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrtemplate")
public class IvrLibaTemplateController extends BaseController
{
    @Autowired
    private IIvrLibaTemplateService ivrLibaTemplateService;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaTemplate ivrLibaTemplate)
    {
        startPage();
        List<IvrLibaTemplate> list = ivrLibaTemplateService.selectIvrLibaTemplateList(ivrLibaTemplate);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè¯æœ¯æ¨¡æ¿åº“列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:export')")
    @Log(title = "话术模板库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaTemplate ivrLibaTemplate)
    {
        List<IvrLibaTemplate> list = ivrLibaTemplateService.selectIvrLibaTemplateList(ivrLibaTemplate);
        ExcelUtil<IvrLibaTemplate> util = new ExcelUtil<IvrLibaTemplate>(IvrLibaTemplate.class);
        util.exportExcel(response, list, "话术模板库数据");
    }

    /**
     * èŽ·å–话术模板库详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:query')")
    @GetMapping(value = "/{templateID}")
    public AjaxResult getInfo(@PathVariable("templateID") String templateID)
    {
        return success(ivrLibaTemplateService.selectIvrLibaTemplateByTemplateID(templateID));
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:add')")
    @Log(title = "话术模板库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaTemplate ivrLibaTemplate)
    {
        return toAjax(ivrLibaTemplateService.insertIvrLibaTemplate(ivrLibaTemplate));
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:edit')")
    @Log(title = "话术模板库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaTemplate ivrLibaTemplate)
    {
        return toAjax(ivrLibaTemplateService.updateIvrLibaTemplate(ivrLibaTemplate));
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:remove')")
    @Log(title = "话术模板库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{templateIDs}")
    public AjaxResult remove(@PathVariable String[] templateIDs)
    {
        return toAjax(ivrLibaTemplateService.deleteIvrLibaTemplateByTemplateIDs(templateIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaTemplatescript;
import com.smartor.service.IIvrLibaTemplatescriptService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrtemplatescript")
public class IvrLibaTemplatescriptController extends BaseController
{
    @Autowired
    private IIvrLibaTemplatescriptService ivrLibaTemplatescriptService;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        startPage();
        List<IvrLibaTemplatescript> list = ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè¯æœ¯æ¨¡æ¿åº“话术列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:export')")
    @Log(title = "话术模板库话术", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        List<IvrLibaTemplatescript> list = ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript);
        ExcelUtil<IvrLibaTemplatescript> util = new ExcelUtil<IvrLibaTemplatescript>(IvrLibaTemplatescript.class);
        util.exportExcel(response, list, "话术模板库话术数据");
    }

    /**
     * èŽ·å–话术模板库话术详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:query')")
    @GetMapping(value = "/{templateQuestionID}")
    public AjaxResult getInfo(@PathVariable("templateQuestionID") String templateQuestionID)
    {
        return success(ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID));
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:add')")
    @Log(title = "话术模板库话术", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        return toAjax(ivrLibaTemplatescriptService.insertIvrLibaTemplatescript(ivrLibaTemplatescript));
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:edit')")
    @Log(title = "话术模板库话术", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        return toAjax(ivrLibaTemplatescriptService.updateIvrLibaTemplatescript(ivrLibaTemplatescript));
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:remove')")
    @Log(title = "话术模板库话术", businessType = BusinessType.DELETE)
    @DeleteMapping("/{templateQuestionIDs}")
    public AjaxResult remove(@PathVariable String[] templateQuestionIDs)
    {
        return toAjax(ivrLibaTemplatescriptService.deleteIvrLibaTemplatescriptByTemplateQuestionIDs(templateQuestionIDs));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.smartor.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.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
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.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.IvrLibaTemplatetarget;
import com.smartor.service.IIvrLibaTemplatetargetService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术指标Controller
 * 
 * @author smartor
 * @date 2023-03-22
 */
@RestController
@RequestMapping("/smartor/ivrtemplatetarget")
public class IvrLibaTemplatetargetController extends BaseController
{
    @Autowired
    private IIvrLibaTemplatetargetService ivrLibaTemplatetargetService;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:list')")
    @GetMapping("/list")
    public TableDataInfo list(IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        startPage();
        List<IvrLibaTemplatetarget> list = ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè¯æœ¯æ¨¡æ¿åº“话术指标列表
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:export')")
    @Log(title = "话术模板库话术指标", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        List<IvrLibaTemplatetarget> list = ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget);
        ExcelUtil<IvrLibaTemplatetarget> util = new ExcelUtil<IvrLibaTemplatetarget>(IvrLibaTemplatetarget.class);
        util.exportExcel(response, list, "话术模板库话术指标数据");
    }

    /**
     * èŽ·å–话术模板库话术指标详细信息
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:query')")
    @GetMapping(value = "/{templateTargetID}")
    public AjaxResult getInfo(@PathVariable("templateTargetID") String templateTargetID)
    {
        return success(ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetByTemplateTargetID(templateTargetID));
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:add')")
    @Log(title = "话术模板库话术指标", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        return toAjax(ivrLibaTemplatetargetService.insertIvrLibaTemplatetarget(ivrLibaTemplatetarget));
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:edit')")
    @Log(title = "话术模板库话术指标", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        return toAjax(ivrLibaTemplatetargetService.updateIvrLibaTemplatetarget(ivrLibaTemplatetarget));
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:remove')")
    @Log(title = "话术模板库话术指标", businessType = BusinessType.DELETE)
    @DeleteMapping("/{templateTargetIDs}")
    public AjaxResult remove(@PathVariable String[] templateTargetIDs)
    {
        return toAjax(ivrLibaTemplatetargetService.deleteIvrLibaTemplatetargetByTemplateTargetIDs(templateTargetIDs));
    }
}

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

@@ -70,13 +70,13 @@
  # redis é…ç½®
  redis:
    # åœ°å€
    host: localhost
    host: 116.62.18.175
    # ç«¯å£ï¼Œé»˜è®¤ä¸º6379
    port: 6379
    port: 6020
    # æ•°æ®åº“索引
    database: 0
    # å¯†ç 
    password: 
    password: Smartor
    # è¿žæŽ¥è¶…时时间
    timeout: 10s
    lettuce:

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“对象 ivr_liba_extemplate
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaExtemplate extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String subModuleID;

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

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

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

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

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

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

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

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

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

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setSubModuleID(String subModuleID) 
    {
        this.subModuleID = subModuleID;
    }

    public String getSubModuleID() 
    {
        return subModuleID;
    }
    public void setSubModuleName(String subModuleName) 
    {
        this.subModuleName = subModuleName;
    }

    public String getSubModuleName() 
    {
        return subModuleName;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setVersion(Long version) 
    {
        this.version = version;
    }

    public Long getVersion() 
    {
        return version;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setAddUserID(String addUserID) 
    {
        this.addUserID = addUserID;
    }

    public String getAddUserID() 
    {
        return addUserID;
    }
    public void setAddTime(Date addTime) 
    {
        this.addTime = addTime;
    }

    public Date getAddTime() 
    {
        return addTime;
    }
    public void setModifyUserID(String modifyUserID) 
    {
        this.modifyUserID = modifyUserID;
    }

    public String getModifyUserID() 
    {
        return modifyUserID;
    }
    public void setModifyTime(Date modifyTime) 
    {
        this.modifyTime = modifyTime;
    }

    public Date getModifyTime() 
    {
        return modifyTime;
    }
    public void setGroupID(Long GroupID) 
    {
        this.GroupID = GroupID;
    }

    public Long getGroupID() 
    {
        return GroupID;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("subModuleID", getSubModuleID())
            .append("subModuleName", getSubModuleName())
            .append("language", getLanguage())
            .append("description", getDescription())
            .append("version", getVersion())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("addUserID", getAddUserID())
            .append("addTime", getAddTime())
            .append("modifyUserID", getModifyUserID())
            .append("modifyTime", getModifyTime())
            .append("GroupID", getGroupID())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术对象 ivr_liba_extemplatescript
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaExtemplatescript extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String DetailID;

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

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

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

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

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

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

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setDetailID(String DetailID) 
    {
        this.DetailID = DetailID;
    }

    public String getDetailID() 
    {
        return DetailID;
    }
    public void setSubModuleID(String subModuleID) 
    {
        this.subModuleID = subModuleID;
    }

    public String getSubModuleID() 
    {
        return subModuleID;
    }
    public void setSwitchID(Long switchID) 
    {
        this.switchID = switchID;
    }

    public Long getSwitchID() 
    {
        return switchID;
    }
    public void setSwitchText(String switchText) 
    {
        this.switchText = switchText;
    }

    public String getSwitchText() 
    {
        return switchText;
    }
    public void setSwitchWav(String switchWav) 
    {
        this.switchWav = switchWav;
    }

    public String getSwitchWav() 
    {
        return switchWav;
    }
    public void setSelfRegex(String selfRegex) 
    {
        this.selfRegex = selfRegex;
    }

    public String getSelfRegex() 
    {
        return selfRegex;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("DetailID", getDetailID())
            .append("subModuleID", getSubModuleID())
            .append("switchID", getSwitchID())
            .append("switchText", getSwitchText())
            .append("switchWav", getSwitchWav())
            .append("selfRegex", getSelfRegex())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * è¯æœ¯åº“对象 ivr_liba_script
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaScript extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /**    */
    private String questionid;

    /**    */
    @Excel(name = "  ")
    private String questionpoint;

    /**    */
    @Excel(name = "  ")
    private String questiontext;

    /**    */
    @Excel(name = "  ")
    private String questionvoice;

    /**    */
    @Excel(name = "  ")
    private String nomatchtext;

    /**    */
    @Excel(name = "  ")
    private String nomatchvoice;

    /**    */
    @Excel(name = "  ")
    private String sliencetext;

    /**    */
    @Excel(name = "  ")
    private String sliencevoice;

    /**    */
    @Excel(name = "  ")
    private String submoduletext;

    /**    */
    @Excel(name = "  ")
    private String submodulevoice;

    /**    */
    @Excel(name = "  ")
    private String noclearlytext;

    /**    */
    @Excel(name = "  ")
    private String noclearlyvoice;

    /**    */
    @Excel(name = "  ")
    private String questiontype;

    /**    */
    @Excel(name = "  ")
    private String categoryname;

    /**    */
    @Excel(name = "  ")
    private String targetoptions;

    /**    */
    @Excel(name = "  ")
    private String language;

    /**    */
    @Excel(name = "  ")
    private Long version;

    /**    */
    @Excel(name = "  ")
    private Long isenable;

    /**    */
    @Excel(name = "  ")
    private Long isdel;

    /**    */
    @Excel(name = "  ")
    private String adduserid;

    /**    */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "  ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date addtime;

    /**    */
    @Excel(name = "  ")
    private String modifyuserid;

    /**    */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "  ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date modifytime;

    /**    */
    @Excel(name = "  ")
    private String groupid;

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setQuestionid(String questionid) 
    {
        this.questionid = questionid;
    }

    public String getQuestionid() 
    {
        return questionid;
    }
    public void setQuestionpoint(String questionpoint) 
    {
        this.questionpoint = questionpoint;
    }

    public String getQuestionpoint() 
    {
        return questionpoint;
    }
    public void setQuestiontext(String questiontext) 
    {
        this.questiontext = questiontext;
    }

    public String getQuestiontext() 
    {
        return questiontext;
    }
    public void setQuestionvoice(String questionvoice) 
    {
        this.questionvoice = questionvoice;
    }

    public String getQuestionvoice() 
    {
        return questionvoice;
    }
    public void setNomatchtext(String nomatchtext) 
    {
        this.nomatchtext = nomatchtext;
    }

    public String getNomatchtext() 
    {
        return nomatchtext;
    }
    public void setNomatchvoice(String nomatchvoice) 
    {
        this.nomatchvoice = nomatchvoice;
    }

    public String getNomatchvoice() 
    {
        return nomatchvoice;
    }
    public void setSliencetext(String sliencetext) 
    {
        this.sliencetext = sliencetext;
    }

    public String getSliencetext() 
    {
        return sliencetext;
    }
    public void setSliencevoice(String sliencevoice) 
    {
        this.sliencevoice = sliencevoice;
    }

    public String getSliencevoice() 
    {
        return sliencevoice;
    }
    public void setSubmoduletext(String submoduletext) 
    {
        this.submoduletext = submoduletext;
    }

    public String getSubmoduletext() 
    {
        return submoduletext;
    }
    public void setSubmodulevoice(String submodulevoice) 
    {
        this.submodulevoice = submodulevoice;
    }

    public String getSubmodulevoice() 
    {
        return submodulevoice;
    }
    public void setNoclearlytext(String noclearlytext) 
    {
        this.noclearlytext = noclearlytext;
    }

    public String getNoclearlytext() 
    {
        return noclearlytext;
    }
    public void setNoclearlyvoice(String noclearlyvoice) 
    {
        this.noclearlyvoice = noclearlyvoice;
    }

    public String getNoclearlyvoice() 
    {
        return noclearlyvoice;
    }
    public void setQuestiontype(String questiontype) 
    {
        this.questiontype = questiontype;
    }

    public String getQuestiontype() 
    {
        return questiontype;
    }
    public void setCategoryname(String categoryname) 
    {
        this.categoryname = categoryname;
    }

    public String getCategoryname() 
    {
        return categoryname;
    }
    public void setTargetoptions(String targetoptions) 
    {
        this.targetoptions = targetoptions;
    }

    public String getTargetoptions() 
    {
        return targetoptions;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setVersion(Long version) 
    {
        this.version = version;
    }

    public Long getVersion() 
    {
        return version;
    }
    public void setIsenable(Long isenable) 
    {
        this.isenable = isenable;
    }

    public Long getIsenable() 
    {
        return isenable;
    }
    public void setIsdel(Long isdel) 
    {
        this.isdel = isdel;
    }

    public Long getIsdel() 
    {
        return isdel;
    }
    public void setAdduserid(String adduserid) 
    {
        this.adduserid = adduserid;
    }

    public String getAdduserid() 
    {
        return adduserid;
    }
    public void setAddtime(Date addtime) 
    {
        this.addtime = addtime;
    }

    public Date getAddtime() 
    {
        return addtime;
    }
    public void setModifyuserid(String modifyuserid) 
    {
        this.modifyuserid = modifyuserid;
    }

    public String getModifyuserid() 
    {
        return modifyuserid;
    }
    public void setModifytime(Date modifytime) 
    {
        this.modifytime = modifytime;
    }

    public Date getModifytime() 
    {
        return modifytime;
    }
    public void setGroupid(String groupid) 
    {
        this.groupid = groupid;
    }

    public String getGroupid() 
    {
        return groupid;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("questionid", getQuestionid())
            .append("questionpoint", getQuestionpoint())
            .append("questiontext", getQuestiontext())
            .append("questionvoice", getQuestionvoice())
            .append("nomatchtext", getNomatchtext())
            .append("nomatchvoice", getNomatchvoice())
            .append("sliencetext", getSliencetext())
            .append("sliencevoice", getSliencevoice())
            .append("submoduletext", getSubmoduletext())
            .append("submodulevoice", getSubmodulevoice())
            .append("noclearlytext", getNoclearlytext())
            .append("noclearlyvoice", getNoclearlyvoice())
            .append("questiontype", getQuestiontype())
            .append("categoryname", getCategoryname())
            .append("targetoptions", getTargetoptions())
            .append("language", getLanguage())
            .append("description", getDescription())
            .append("version", getVersion())
            .append("isenable", getIsenable())
            .append("isdel", getIsdel())
            .append("adduserid", getAdduserid())
            .append("addtime", getAddtime())
            .append("modifyuserid", getModifyuserid())
            .append("modifytime", getModifytime())
            .append("groupid", getGroupid())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * è¯æœ¯åº“话术指标对象 ivr_liba_scripttarget
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaScripttarget extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String questionTargetID;

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

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

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

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

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

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

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

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

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

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

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

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

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setQuestionTargetID(String questionTargetID) 
    {
        this.questionTargetID = questionTargetID;
    }

    public String getQuestionTargetID() 
    {
        return questionTargetID;
    }
    public void setQuestionID(String questionID) 
    {
        this.questionID = questionID;
    }

    public String getQuestionID() 
    {
        return questionID;
    }
    public void setTargetID(String targetID) 
    {
        this.targetID = targetID;
    }

    public String getTargetID() 
    {
        return targetID;
    }
    public void setTargetType(String targetType) 
    {
        this.targetType = targetType;
    }

    public String getTargetType() 
    {
        return targetType;
    }
    public void setCategoryName(String categoryName) 
    {
        this.categoryName = categoryName;
    }

    public String getCategoryName() 
    {
        return categoryName;
    }
    public void setTargetValue(String targetValue) 
    {
        this.targetValue = targetValue;
    }

    public String getTargetValue() 
    {
        return targetValue;
    }
    public void setBasicRegex(String basicRegex) 
    {
        this.basicRegex = basicRegex;
    }

    public String getBasicRegex() 
    {
        return basicRegex;
    }
    public void setSelfRegex(String selfRegex) 
    {
        this.selfRegex = selfRegex;
    }

    public String getSelfRegex() 
    {
        return selfRegex;
    }
    public void setRegexUsedType(String regexUsedType) 
    {
        this.regexUsedType = regexUsedType;
    }

    public String getRegexUsedType() 
    {
        return regexUsedType;
    }
    public void setSort(Long sort) 
    {
        this.sort = sort;
    }

    public Long getSort() 
    {
        return sort;
    }
    public void setVersion(Long version) 
    {
        this.version = version;
    }

    public Long getVersion() 
    {
        return version;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setTipsJson(String tipsJson) 
    {
        this.tipsJson = tipsJson;
    }

    public String getTipsJson() 
    {
        return tipsJson;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("questionTargetID", getQuestionTargetID())
            .append("questionID", getQuestionID())
            .append("targetID", getTargetID())
            .append("targetType", getTargetType())
            .append("categoryName", getCategoryName())
            .append("targetValue", getTargetValue())
            .append("basicRegex", getBasicRegex())
            .append("selfRegex", getSelfRegex())
            .append("regexUsedType", getRegexUsedType())
            .append("sort", getSort())
            .append("version", getVersion())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("tipsJson", getTipsJson())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * æŒ‡æ ‡åº“对象 ivr_liba_target
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaTarget extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String targetID;

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

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

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

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

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

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

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

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

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

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

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

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

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

    /** æ˜¯å¦å¼‚常标识 */
    @Excel(name = "是否异常标识")
    private Long isAbnormal;

    /** é¢„警阀值上限 */
    @Excel(name = "预警阀值上限")
    private Long WarnUp;

    /** é¢„警阀值下限 */
    @Excel(name = "预警阀值下限")
    private Long WarnDown;

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setTargetID(String targetID) 
    {
        this.targetID = targetID;
    }

    public String getTargetID() 
    {
        return targetID;
    }
    public void setTargetType(String targetType) 
    {
        this.targetType = targetType;
    }

    public String getTargetType() 
    {
        return targetType;
    }
    public void setCategoryName(String categoryName) 
    {
        this.categoryName = categoryName;
    }

    public String getCategoryName() 
    {
        return categoryName;
    }
    public void setTargetValue(String targetValue) 
    {
        this.targetValue = targetValue;
    }

    public String getTargetValue() 
    {
        return targetValue;
    }
    public void setTargetRegex(String targetRegex) 
    {
        this.targetRegex = targetRegex;
    }

    public String getTargetRegex() 
    {
        return targetRegex;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setVersion(Long version) 
    {
        this.version = version;
    }

    public Long getVersion() 
    {
        return version;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setAddUserID(String addUserID) 
    {
        this.addUserID = addUserID;
    }

    public String getAddUserID() 
    {
        return addUserID;
    }
    public void setAddTime(Date addTime) 
    {
        this.addTime = addTime;
    }

    public Date getAddTime() 
    {
        return addTime;
    }
    public void setModifyUserID(String modifyUserID) 
    {
        this.modifyUserID = modifyUserID;
    }

    public String getModifyUserID() 
    {
        return modifyUserID;
    }
    public void setModifyTime(Date modifyTime) 
    {
        this.modifyTime = modifyTime;
    }

    public Date getModifyTime() 
    {
        return modifyTime;
    }
    public void setGroupID(String groupID) 
    {
        this.groupID = groupID;
    }

    public String getGroupID() 
    {
        return groupID;
    }
    public void setIsAbnormal(Long isAbnormal) 
    {
        this.isAbnormal = isAbnormal;
    }

    public Long getIsAbnormal() 
    {
        return isAbnormal;
    }
    public void setWarnUp(Long WarnUp) 
    {
        this.WarnUp = WarnUp;
    }

    public Long getWarnUp() 
    {
        return WarnUp;
    }
    public void setWarnDown(Long WarnDown) 
    {
        this.WarnDown = WarnDown;
    }

    public Long getWarnDown() 
    {
        return WarnDown;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("targetID", getTargetID())
            .append("targetType", getTargetType())
            .append("categoryName", getCategoryName())
            .append("targetValue", getTargetValue())
            .append("targetRegex", getTargetRegex())
            .append("description", getDescription())
            .append("language", getLanguage())
            .append("version", getVersion())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("addUserID", getAddUserID())
            .append("addTime", getAddTime())
            .append("modifyUserID", getModifyUserID())
            .append("modifyTime", getModifyTime())
            .append("groupID", getGroupID())
            .append("isAbnormal", getIsAbnormal())
            .append("WarnUp", getWarnUp())
            .append("WarnDown", getWarnDown())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * è¯æœ¯æ¨¡æ¿åº“对象 ivr_liba_template
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaTemplate extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String templateID;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /** æ’­æŠ¥ç±»åž‹ 0.语音优先 1.文字优先 */
    @Excel(name = "播报类型 0.语音优先 1.文字优先")
    private Long playType;

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

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

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

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

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

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setTemplateID(String templateID) 
    {
        this.templateID = templateID;
    }

    public String getTemplateID() 
    {
        return templateID;
    }
    public void setTemplateName(String templateName) 
    {
        this.templateName = templateName;
    }

    public String getTemplateName() 
    {
        return templateName;
    }
    public void setSilencetime(Long silencetime) 
    {
        this.silencetime = silencetime;
    }

    public Long getSilencetime() 
    {
        return silencetime;
    }
    public void setSlienceRepeatTimes(Long slienceRepeatTimes) 
    {
        this.slienceRepeatTimes = slienceRepeatTimes;
    }

    public Long getSlienceRepeatTimes() 
    {
        return slienceRepeatTimes;
    }
    public void setNomatchRepeatTimes(Long nomatchRepeatTimes) 
    {
        this.nomatchRepeatTimes = nomatchRepeatTimes;
    }

    public Long getNomatchRepeatTimes() 
    {
        return nomatchRepeatTimes;
    }
    public void setFirstQuestionNum(Long firstQuestionNum) 
    {
        this.firstQuestionNum = firstQuestionNum;
    }

    public Long getFirstQuestionNum() 
    {
        return firstQuestionNum;
    }
    public void setSubmodule(String submodule) 
    {
        this.submodule = submodule;
    }

    public String getSubmodule() 
    {
        return submodule;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setAddUserID(String addUserID) 
    {
        this.addUserID = addUserID;
    }

    public String getAddUserID() 
    {
        return addUserID;
    }
    public void setAddTime(Date addTime) 
    {
        this.addTime = addTime;
    }

    public Date getAddTime() 
    {
        return addTime;
    }
    public void setModifyUserID(String modifyUserID) 
    {
        this.modifyUserID = modifyUserID;
    }

    public String getModifyUserID() 
    {
        return modifyUserID;
    }
    public void setModifyTime(Date modifyTime) 
    {
        this.modifyTime = modifyTime;
    }

    public Date getModifyTime() 
    {
        return modifyTime;
    }
    public void setGroupID(String groupID) 
    {
        this.groupID = groupID;
    }

    public String getGroupID() 
    {
        return groupID;
    }
    public void setLabelInfo(String labelInfo) 
    {
        this.labelInfo = labelInfo;
    }

    public String getLabelInfo() 
    {
        return labelInfo;
    }
    public void setSubmoduleID(String submoduleID) 
    {
        this.submoduleID = submoduleID;
    }

    public String getSubmoduleID() 
    {
        return submoduleID;
    }
    public void setPlayType(Long playType) 
    {
        this.playType = playType;
    }

    public Long getPlayType() 
    {
        return playType;
    }
    public void setIcd10code(String icd10code) 
    {
        this.icd10code = icd10code;
    }

    public String getIcd10code() 
    {
        return icd10code;
    }
    public void setIcd10codename(String icd10codename) 
    {
        this.icd10codename = icd10codename;
    }

    public String getIcd10codename() 
    {
        return icd10codename;
    }
    public void setAtuoTaskDayOffset(Long atuoTaskDayOffset) 
    {
        this.atuoTaskDayOffset = atuoTaskDayOffset;
    }

    public Long getAtuoTaskDayOffset() 
    {
        return atuoTaskDayOffset;
    }
    public void setDeptIds(String DeptIds) 
    {
        this.DeptIds = DeptIds;
    }

    public String getDeptIds() 
    {
        return DeptIds;
    }
    public void setDeptNames(String DeptNames) 
    {
        this.DeptNames = DeptNames;
    }

    public String getDeptNames() 
    {
        return DeptNames;
    }
    public void setfKsdm(String fKsdm) 
    {
        this.fKsdm = fKsdm;
    }

    public String getfKsdm() 
    {
        return fKsdm;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("templateID", getTemplateID())
            .append("templateName", getTemplateName())
            .append("silencetime", getSilencetime())
            .append("slienceRepeatTimes", getSlienceRepeatTimes())
            .append("nomatchRepeatTimes", getNomatchRepeatTimes())
            .append("firstQuestionNum", getFirstQuestionNum())
            .append("submodule", getSubmodule())
            .append("language", getLanguage())
            .append("description", getDescription())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("addUserID", getAddUserID())
            .append("addTime", getAddTime())
            .append("modifyUserID", getModifyUserID())
            .append("modifyTime", getModifyTime())
            .append("groupID", getGroupID())
            .append("labelInfo", getLabelInfo())
            .append("submoduleID", getSubmoduleID())
            .append("playType", getPlayType())
            .append("icd10code", getIcd10code())
            .append("icd10codename", getIcd10codename())
            .append("atuoTaskDayOffset", getAtuoTaskDayOffset())
            .append("DeptIds", getDeptIds())
            .append("DeptNames", getDeptNames())
            .append("fKsdm", getfKsdm())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术对象 ivr_liba_templatescript
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaTemplatescript extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String templateQuestionID;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setTemplateQuestionID(String templateQuestionID) 
    {
        this.templateQuestionID = templateQuestionID;
    }

    public String getTemplateQuestionID() 
    {
        return templateQuestionID;
    }
    public void setTemplateQuestionNum(Long templateQuestionNum) 
    {
        this.templateQuestionNum = templateQuestionNum;
    }

    public Long getTemplateQuestionNum() 
    {
        return templateQuestionNum;
    }
    public void setTemplateID(String templateID) 
    {
        this.templateID = templateID;
    }

    public String getTemplateID() 
    {
        return templateID;
    }
    public void setQuestionID(String questionID) 
    {
        this.questionID = questionID;
    }

    public String getQuestionID() 
    {
        return questionID;
    }
    public void setQuestionPoint(String questionPoint) 
    {
        this.questionPoint = questionPoint;
    }

    public String getQuestionPoint() 
    {
        return questionPoint;
    }
    public void setQuestionText(String questionText) 
    {
        this.questionText = questionText;
    }

    public String getQuestionText() 
    {
        return questionText;
    }
    public void setQuestionVoice(String questionVoice) 
    {
        this.questionVoice = questionVoice;
    }

    public String getQuestionVoice() 
    {
        return questionVoice;
    }
    public void setNoMatchText(String noMatchText) 
    {
        this.noMatchText = noMatchText;
    }

    public String getNoMatchText() 
    {
        return noMatchText;
    }
    public void setNoMatchVoice(String noMatchVoice) 
    {
        this.noMatchVoice = noMatchVoice;
    }

    public String getNoMatchVoice() 
    {
        return noMatchVoice;
    }
    public void setSlienceText(String slienceText) 
    {
        this.slienceText = slienceText;
    }

    public String getSlienceText() 
    {
        return slienceText;
    }
    public void setSlienceVoice(String slienceVoice) 
    {
        this.slienceVoice = slienceVoice;
    }

    public String getSlienceVoice() 
    {
        return slienceVoice;
    }
    public void setSubmoduleText(String submoduleText) 
    {
        this.submoduleText = submoduleText;
    }

    public String getSubmoduleText() 
    {
        return submoduleText;
    }
    public void setSubmoduleVoice(String submoduleVoice) 
    {
        this.submoduleVoice = submoduleVoice;
    }

    public String getSubmoduleVoice() 
    {
        return submoduleVoice;
    }
    public void setNoClearlyText(String noClearlyText) 
    {
        this.noClearlyText = noClearlyText;
    }

    public String getNoClearlyText() 
    {
        return noClearlyText;
    }
    public void setNoClearlyVoice(String noClearlyVoice) 
    {
        this.noClearlyVoice = noClearlyVoice;
    }

    public String getNoClearlyVoice() 
    {
        return noClearlyVoice;
    }
    public void setCategoryName(String categoryName) 
    {
        this.categoryName = categoryName;
    }

    public String getCategoryName() 
    {
        return categoryName;
    }
    public void setTargetOptions(String targetOptions) 
    {
        this.targetOptions = targetOptions;
    }

    public String getTargetOptions() 
    {
        return targetOptions;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setPlayWavOnly(Long playWavOnly) 
    {
        this.playWavOnly = playWavOnly;
    }

    public Long getPlayWavOnly() 
    {
        return playWavOnly;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("templateQuestionID", getTemplateQuestionID())
            .append("templateQuestionNum", getTemplateQuestionNum())
            .append("templateID", getTemplateID())
            .append("questionID", getQuestionID())
            .append("questionPoint", getQuestionPoint())
            .append("questionText", getQuestionText())
            .append("questionVoice", getQuestionVoice())
            .append("noMatchText", getNoMatchText())
            .append("noMatchVoice", getNoMatchVoice())
            .append("slienceText", getSlienceText())
            .append("slienceVoice", getSlienceVoice())
            .append("submoduleText", getSubmoduleText())
            .append("submoduleVoice", getSubmoduleVoice())
            .append("noClearlyText", getNoClearlyText())
            .append("noClearlyVoice", getNoClearlyVoice())
            .append("categoryName", getCategoryName())
            .append("targetOptions", getTargetOptions())
            .append("language", getLanguage())
            .append("playWavOnly", getPlayWavOnly())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术指标对象 ivr_liba_templatetarget
 * 
 * @author smartor
 * @date 2023-03-22
 */
public class IvrLibaTemplatetarget extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    private String templateTargetID;

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

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

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

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

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

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

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

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

    /** èŠ‚点待匹配语音 */
    @Excel(name = "节点待匹配语音")
    private String switchTempWav;

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

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

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

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

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

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

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

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

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

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

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

    /** æ’­æŠ¥ç±»åž‹ 0.语音优先 1.文字优先 */
    @Excel(name = "播报类型 0.语音优先 1.文字优先")
    private Long playType;

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setTemplateTargetID(String templateTargetID) 
    {
        this.templateTargetID = templateTargetID;
    }

    public String getTemplateTargetID() 
    {
        return templateTargetID;
    }
    public void setTemplateQuestionID(String templateQuestionID) 
    {
        this.templateQuestionID = templateQuestionID;
    }

    public String getTemplateQuestionID() 
    {
        return templateQuestionID;
    }
    public void setTemplateQuestionNum(Long templateQuestionNum) 
    {
        this.templateQuestionNum = templateQuestionNum;
    }

    public Long getTemplateQuestionNum() 
    {
        return templateQuestionNum;
    }
    public void setNextQuestionNum(Long nextQuestionNum) 
    {
        this.nextQuestionNum = nextQuestionNum;
    }

    public Long getNextQuestionNum() 
    {
        return nextQuestionNum;
    }
    public void setTemplateID(String templateID) 
    {
        this.templateID = templateID;
    }

    public String getTemplateID() 
    {
        return templateID;
    }
    public void setSwitchID(Long switchID) 
    {
        this.switchID = switchID;
    }

    public Long getSwitchID() 
    {
        return switchID;
    }
    public void setSwitchDescription(String switchDescription) 
    {
        this.switchDescription = switchDescription;
    }

    public String getSwitchDescription() 
    {
        return switchDescription;
    }
    public void setSwitchText(String switchText) 
    {
        this.switchText = switchText;
    }

    public String getSwitchText() 
    {
        return switchText;
    }
    public void setSwitchWav(String switchWav) 
    {
        this.switchWav = switchWav;
    }

    public String getSwitchWav() 
    {
        return switchWav;
    }
    public void setSwitchTempWav(String switchTempWav) 
    {
        this.switchTempWav = switchTempWav;
    }

    public String getSwitchTempWav() 
    {
        return switchTempWav;
    }
    public void setTargetType(String targetType) 
    {
        this.targetType = targetType;
    }

    public String getTargetType() 
    {
        return targetType;
    }
    public void setCategoryName(String categoryName) 
    {
        this.categoryName = categoryName;
    }

    public String getCategoryName() 
    {
        return categoryName;
    }
    public void setTargetValue(String targetValue) 
    {
        this.targetValue = targetValue;
    }

    public String getTargetValue() 
    {
        return targetValue;
    }
    public void setTargetID(String targetID) 
    {
        this.targetID = targetID;
    }

    public String getTargetID() 
    {
        return targetID;
    }
    public void setQuestionTargetID(String questionTargetID) 
    {
        this.questionTargetID = questionTargetID;
    }

    public String getQuestionTargetID() 
    {
        return questionTargetID;
    }
    public void setBasicRegex(String basicRegex) 
    {
        this.basicRegex = basicRegex;
    }

    public String getBasicRegex() 
    {
        return basicRegex;
    }
    public void setSelfRegex(String selfRegex) 
    {
        this.selfRegex = selfRegex;
    }

    public String getSelfRegex() 
    {
        return selfRegex;
    }
    public void setRegexUsedType(String regexUsedType) 
    {
        this.regexUsedType = regexUsedType;
    }

    public String getRegexUsedType() 
    {
        return regexUsedType;
    }
    public void setLanguage(String language) 
    {
        this.language = language;
    }

    public String getLanguage() 
    {
        return language;
    }
    public void setIsEnable(Long isEnable) 
    {
        this.isEnable = isEnable;
    }

    public Long getIsEnable() 
    {
        return isEnable;
    }
    public void setIsDel(Long isDel) 
    {
        this.isDel = isDel;
    }

    public Long getIsDel() 
    {
        return isDel;
    }
    public void setPlayType(Long playType) 
    {
        this.playType = playType;
    }

    public Long getPlayType() 
    {
        return playType;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsupload(Long isupload) 
    {
        this.isupload = isupload;
    }

    public Long getIsupload() 
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setOrgid(String orgid) 
    {
        this.orgid = orgid;
    }

    public String getOrgid() 
    {
        return orgid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("templateTargetID", getTemplateTargetID())
            .append("templateQuestionID", getTemplateQuestionID())
            .append("templateQuestionNum", getTemplateQuestionNum())
            .append("nextQuestionNum", getNextQuestionNum())
            .append("templateID", getTemplateID())
            .append("switchID", getSwitchID())
            .append("switchDescription", getSwitchDescription())
            .append("switchText", getSwitchText())
            .append("switchWav", getSwitchWav())
            .append("switchTempWav", getSwitchTempWav())
            .append("targetType", getTargetType())
            .append("categoryName", getCategoryName())
            .append("targetValue", getTargetValue())
            .append("targetID", getTargetID())
            .append("questionTargetID", getQuestionTargetID())
            .append("basicRegex", getBasicRegex())
            .append("selfRegex", getSelfRegex())
            .append("regexUsedType", getRegexUsedType())
            .append("language", getLanguage())
            .append("isEnable", getIsEnable())
            .append("isDel", getIsDel())
            .append("playType", getPlayType())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .toString();
    }
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaExtemplate;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaExtemplateMapper 
{
    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID);

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“集合
     */
    public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID);

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaExtemplatescript;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaExtemplatescriptMapper 
{
    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID);

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术集合
     */
    public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID);

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaScript;

/**
 * è¯æœ¯åº“Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaScriptMapper 
{
    /**
     * æŸ¥è¯¢è¯æœ¯åº“
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return è¯æœ¯åº“
     */
    public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid);

    /**
     * æŸ¥è¯¢è¯æœ¯åº“列表
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return è¯æœ¯åº“集合
     */
    public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript);

    /**
     * æ–°å¢žè¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaScript(IvrLibaScript ivrLibaScript);

    /**
     * ä¿®æ”¹è¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaScript(IvrLibaScript ivrLibaScript);

    /**
     * åˆ é™¤è¯æœ¯åº“
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScriptByQuestionid(String questionid);

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

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

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

import java.util.List;
import com.smartor.domain.IvrLibaScripttarget;

/**
 * è¯æœ¯åº“话术指标Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
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(String questionTargetID);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯åº“话术指标
     * 
     * @param questionTargetIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScripttargetByQuestionTargetIDs(String[] questionTargetIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTarget;

/**
 * æŒ‡æ ‡åº“Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaTargetMapper 
{
    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return æŒ‡æ ‡åº“
     */
    public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID);

    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“列表
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return æŒ‡æ ‡åº“集合
     */
    public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget);

    /**
     * æ–°å¢žæŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget);

    /**
     * ä¿®æ”¹æŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget);

    /**
     * åˆ é™¤æŒ‡æ ‡åº“
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTargetByTargetID(String targetID);

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

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplate;

/**
 * è¯æœ¯æ¨¡æ¿åº“Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaTemplateMapper 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return è¯æœ¯æ¨¡æ¿åº“
     */
    public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return è¯æœ¯æ¨¡æ¿åº“集合
     */
    public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplateByTemplateID(String templateID);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplatescript;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaTemplatescriptMapper 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术
     */
    public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return è¯æœ¯æ¨¡æ¿åº“话术集合
     */
    public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplatetarget;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术指标Mapper接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IvrLibaTemplatetargetMapper 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标列表
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标集合
     */
    public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaExtemplate;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaExtemplateService 
{
    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID);

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“集合
     */
    public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate);

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleIDs éœ€è¦åˆ é™¤çš„扩展话术模板库主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs);

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“信息
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaExtemplatescript;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaExtemplatescriptService 
{
    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID);

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术集合
     */
    public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript);

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailIDs éœ€è¦åˆ é™¤çš„扩展话术模板库话术主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs);

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术信息
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaScript;

/**
 * è¯æœ¯åº“Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaScriptService 
{
    /**
     * æŸ¥è¯¢è¯æœ¯åº“
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return è¯æœ¯åº“
     */
    public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid);

    /**
     * æŸ¥è¯¢è¯æœ¯åº“列表
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return è¯æœ¯åº“集合
     */
    public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript);

    /**
     * æ–°å¢žè¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaScript(IvrLibaScript ivrLibaScript);

    /**
     * ä¿®æ”¹è¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaScript(IvrLibaScript ivrLibaScript);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯åº“
     * 
     * @param questionids éœ€è¦åˆ é™¤çš„话术库主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScriptByQuestionids(String[] questionids);

    /**
     * åˆ é™¤è¯æœ¯åº“信息
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScriptByQuestionid(String questionid);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaScripttarget;

/**
 * è¯æœ¯åº“话术指标Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
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(String[] questionTargetIDs);

    /**
     * åˆ é™¤è¯æœ¯åº“话术指标信息
     * 
     * @param questionTargetID è¯æœ¯åº“话术指标主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaScripttargetByQuestionTargetID(String questionTargetID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTarget;

/**
 * æŒ‡æ ‡åº“Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaTargetService 
{
    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return æŒ‡æ ‡åº“
     */
    public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID);

    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“列表
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return æŒ‡æ ‡åº“集合
     */
    public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget);

    /**
     * æ–°å¢žæŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget);

    /**
     * ä¿®æ”¹æŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget);

    /**
     * æ‰¹é‡åˆ é™¤æŒ‡æ ‡åº“
     * 
     * @param targetIDs éœ€è¦åˆ é™¤çš„指标库主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTargetByTargetIDs(String[] targetIDs);

    /**
     * åˆ é™¤æŒ‡æ ‡åº“信息
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTargetByTargetID(String targetID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplate;

/**
 * è¯æœ¯æ¨¡æ¿åº“Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaTemplateService 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return è¯æœ¯æ¨¡æ¿åº“
     */
    public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return è¯æœ¯æ¨¡æ¿åº“集合
     */
    public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateIDs éœ€è¦åˆ é™¤çš„话术模板库主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“信息
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplateByTemplateID(String templateID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplatescript;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaTemplatescriptService 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术
     */
    public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return è¯æœ¯æ¨¡æ¿åº“话术集合
     */
    public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionIDs éœ€è¦åˆ é™¤çš„话术模板库话术主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术信息
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID);
}

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

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

import java.util.List;
import com.smartor.domain.IvrLibaTemplatetarget;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术指标Service接口
 * 
 * @author smartor
 * @date 2023-03-22
 */
public interface IIvrLibaTemplatetargetService 
{
    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID);

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标列表
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标集合
     */
    public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget);

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetIDs éœ€è¦åˆ é™¤çš„话术模板库话术指标主键集合
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs);

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标信息
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return ç»“æžœ
     */
    public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID);
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaExtemplateMapper;
import com.smartor.domain.IvrLibaExtemplate;
import com.smartor.service.IIvrLibaExtemplateService;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaExtemplateServiceImpl implements IIvrLibaExtemplateService 
{
    @Autowired
    private IvrLibaExtemplateMapper ivrLibaExtemplateMapper;

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    @Override
    public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID)
    {
        return ivrLibaExtemplateMapper.selectIvrLibaExtemplateBySubModuleID(subModuleID);
    }

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     */
    @Override
    public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate)
    {
        return ivrLibaExtemplateMapper.selectIvrLibaExtemplateList(ivrLibaExtemplate);
    }

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate)
    {
        ivrLibaExtemplate.setCreateTime(DateUtils.getNowDate());
        return ivrLibaExtemplateMapper.insertIvrLibaExtemplate(ivrLibaExtemplate);
    }

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaExtemplate æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate)
    {
        ivrLibaExtemplate.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaExtemplateMapper.updateIvrLibaExtemplate(ivrLibaExtemplate);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param subModuleIDs éœ€è¦åˆ é™¤çš„扩展话术模板库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs)
    {
        return ivrLibaExtemplateMapper.deleteIvrLibaExtemplateBySubModuleIDs(subModuleIDs);
    }

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“信息
     * 
     * @param subModuleID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID)
    {
        return ivrLibaExtemplateMapper.deleteIvrLibaExtemplateBySubModuleID(subModuleID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaExtemplatescriptMapper;
import com.smartor.domain.IvrLibaExtemplatescript;
import com.smartor.service.IIvrLibaExtemplatescriptService;

/**
 * æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaExtemplatescriptServiceImpl implements IIvrLibaExtemplatescriptService 
{
    @Autowired
    private IvrLibaExtemplatescriptMapper ivrLibaExtemplatescriptMapper;

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    @Override
    public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID)
    {
        return ivrLibaExtemplatescriptMapper.selectIvrLibaExtemplatescriptByDetailID(DetailID);
    }

    /**
     * æŸ¥è¯¢æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     */
    @Override
    public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        return ivrLibaExtemplatescriptMapper.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript);
    }

    /**
     * æ–°å¢žæ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        ivrLibaExtemplatescript.setCreateTime(DateUtils.getNowDate());
        return ivrLibaExtemplatescriptMapper.insertIvrLibaExtemplatescript(ivrLibaExtemplatescript);
    }

    /**
     * ä¿®æ”¹æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaExtemplatescript æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript)
    {
        ivrLibaExtemplatescript.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaExtemplatescriptMapper.updateIvrLibaExtemplatescript(ivrLibaExtemplatescript);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param DetailIDs éœ€è¦åˆ é™¤çš„扩展话术模板库话术主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs)
    {
        return ivrLibaExtemplatescriptMapper.deleteIvrLibaExtemplatescriptByDetailIDs(DetailIDs);
    }

    /**
     * åˆ é™¤æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术信息
     * 
     * @param DetailID æ‰©å±•è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID)
    {
        return ivrLibaExtemplatescriptMapper.deleteIvrLibaExtemplatescriptByDetailID(DetailID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaScriptMapper;
import com.smartor.domain.IvrLibaScript;
import com.smartor.service.IIvrLibaScriptService;

/**
 * è¯æœ¯åº“Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaScriptServiceImpl implements IIvrLibaScriptService 
{
    @Autowired
    private IvrLibaScriptMapper ivrLibaScriptMapper;

    /**
     * æŸ¥è¯¢è¯æœ¯åº“
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return è¯æœ¯åº“
     */
    @Override
    public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid)
    {
        return ivrLibaScriptMapper.selectIvrLibaScriptByQuestionid(questionid);
    }

    /**
     * æŸ¥è¯¢è¯æœ¯åº“列表
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return è¯æœ¯åº“
     */
    @Override
    public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript)
    {
        return ivrLibaScriptMapper.selectIvrLibaScriptList(ivrLibaScript);
    }

    /**
     * æ–°å¢žè¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaScript(IvrLibaScript ivrLibaScript)
    {
        ivrLibaScript.setCreateTime(DateUtils.getNowDate());
        return ivrLibaScriptMapper.insertIvrLibaScript(ivrLibaScript);
    }

    /**
     * ä¿®æ”¹è¯æœ¯åº“
     * 
     * @param ivrLibaScript è¯æœ¯åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaScript(IvrLibaScript ivrLibaScript)
    {
        ivrLibaScript.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaScriptMapper.updateIvrLibaScript(ivrLibaScript);
    }

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯åº“
     * 
     * @param questionids éœ€è¦åˆ é™¤çš„话术库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaScriptByQuestionids(String[] questionids)
    {
        return ivrLibaScriptMapper.deleteIvrLibaScriptByQuestionids(questionids);
    }

    /**
     * åˆ é™¤è¯æœ¯åº“信息
     * 
     * @param questionid è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaScriptByQuestionid(String questionid)
    {
        return ivrLibaScriptMapper.deleteIvrLibaScriptByQuestionid(questionid);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaScripttargetMapper;
import com.smartor.domain.IvrLibaScripttarget;
import com.smartor.service.IIvrLibaScripttargetService;

/**
 * è¯æœ¯åº“话术指标Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaScripttargetServiceImpl implements IIvrLibaScripttargetService 
{
    @Autowired
    private IvrLibaScripttargetMapper ivrLibaScripttargetMapper;

    /**
     * æŸ¥è¯¢è¯æœ¯åº“话术指标
     * 
     * @param questionTargetID è¯æœ¯åº“话术指标主键
     * @return è¯æœ¯åº“话术指标
     */
    @Override
    public IvrLibaScripttarget selectIvrLibaScripttargetByQuestionTargetID(String questionTargetID)
    {
        return ivrLibaScripttargetMapper.selectIvrLibaScripttargetByQuestionTargetID(questionTargetID);
    }

    /**
     * æŸ¥è¯¢è¯æœ¯åº“话术指标列表
     * 
     * @param ivrLibaScripttarget è¯æœ¯åº“话术指标
     * @return è¯æœ¯åº“话术指标
     */
    @Override
    public List<IvrLibaScripttarget> selectIvrLibaScripttargetList(IvrLibaScripttarget ivrLibaScripttarget)
    {
        return ivrLibaScripttargetMapper.selectIvrLibaScripttargetList(ivrLibaScripttarget);
    }

    /**
     * æ–°å¢žè¯æœ¯åº“话术指标
     * 
     * @param ivrLibaScripttarget è¯æœ¯åº“话术指标
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget)
    {
        ivrLibaScripttarget.setCreateTime(DateUtils.getNowDate());
        return ivrLibaScripttargetMapper.insertIvrLibaScripttarget(ivrLibaScripttarget);
    }

    /**
     * ä¿®æ”¹è¯æœ¯åº“话术指标
     * 
     * @param ivrLibaScripttarget è¯æœ¯åº“话术指标
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget)
    {
        ivrLibaScripttarget.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaScripttargetMapper.updateIvrLibaScripttarget(ivrLibaScripttarget);
    }

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯åº“话术指标
     * 
     * @param questionTargetIDs éœ€è¦åˆ é™¤çš„话术库话术指标主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaScripttargetByQuestionTargetIDs(String[] questionTargetIDs)
    {
        return ivrLibaScripttargetMapper.deleteIvrLibaScripttargetByQuestionTargetIDs(questionTargetIDs);
    }

    /**
     * åˆ é™¤è¯æœ¯åº“话术指标信息
     * 
     * @param questionTargetID è¯æœ¯åº“话术指标主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaScripttargetByQuestionTargetID(String questionTargetID)
    {
        return ivrLibaScripttargetMapper.deleteIvrLibaScripttargetByQuestionTargetID(questionTargetID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaTargetMapper;
import com.smartor.domain.IvrLibaTarget;
import com.smartor.service.IIvrLibaTargetService;

/**
 * æŒ‡æ ‡åº“Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaTargetServiceImpl implements IIvrLibaTargetService 
{
    @Autowired
    private IvrLibaTargetMapper ivrLibaTargetMapper;

    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return æŒ‡æ ‡åº“
     */
    @Override
    public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID)
    {
        return ivrLibaTargetMapper.selectIvrLibaTargetByTargetID(targetID);
    }

    /**
     * æŸ¥è¯¢æŒ‡æ ‡åº“列表
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return æŒ‡æ ‡åº“
     */
    @Override
    public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget)
    {
        return ivrLibaTargetMapper.selectIvrLibaTargetList(ivrLibaTarget);
    }

    /**
     * æ–°å¢žæŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget)
    {
        ivrLibaTarget.setCreateTime(DateUtils.getNowDate());
        return ivrLibaTargetMapper.insertIvrLibaTarget(ivrLibaTarget);
    }

    /**
     * ä¿®æ”¹æŒ‡æ ‡åº“
     * 
     * @param ivrLibaTarget æŒ‡æ ‡åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget)
    {
        ivrLibaTarget.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaTargetMapper.updateIvrLibaTarget(ivrLibaTarget);
    }

    /**
     * æ‰¹é‡åˆ é™¤æŒ‡æ ‡åº“
     * 
     * @param targetIDs éœ€è¦åˆ é™¤çš„指标库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTargetByTargetIDs(String[] targetIDs)
    {
        return ivrLibaTargetMapper.deleteIvrLibaTargetByTargetIDs(targetIDs);
    }

    /**
     * åˆ é™¤æŒ‡æ ‡åº“信息
     * 
     * @param targetID æŒ‡æ ‡åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTargetByTargetID(String targetID)
    {
        return ivrLibaTargetMapper.deleteIvrLibaTargetByTargetID(targetID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaTemplateMapper;
import com.smartor.domain.IvrLibaTemplate;
import com.smartor.service.IIvrLibaTemplateService;

/**
 * è¯æœ¯æ¨¡æ¿åº“Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaTemplateServiceImpl implements IIvrLibaTemplateService 
{
    @Autowired
    private IvrLibaTemplateMapper ivrLibaTemplateMapper;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return è¯æœ¯æ¨¡æ¿åº“
     */
    @Override
    public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID)
    {
        return ivrLibaTemplateMapper.selectIvrLibaTemplateByTemplateID(templateID);
    }

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“列表
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return è¯æœ¯æ¨¡æ¿åº“
     */
    @Override
    public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate)
    {
        return ivrLibaTemplateMapper.selectIvrLibaTemplateList(ivrLibaTemplate);
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate)
    {
        ivrLibaTemplate.setCreateTime(DateUtils.getNowDate());
        return ivrLibaTemplateMapper.insertIvrLibaTemplate(ivrLibaTemplate);
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param ivrLibaTemplate è¯æœ¯æ¨¡æ¿åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate)
    {
        ivrLibaTemplate.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaTemplateMapper.updateIvrLibaTemplate(ivrLibaTemplate);
    }

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“
     * 
     * @param templateIDs éœ€è¦åˆ é™¤çš„话术模板库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs)
    {
        return ivrLibaTemplateMapper.deleteIvrLibaTemplateByTemplateIDs(templateIDs);
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“信息
     * 
     * @param templateID è¯æœ¯æ¨¡æ¿åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplateByTemplateID(String templateID)
    {
        return ivrLibaTemplateMapper.deleteIvrLibaTemplateByTemplateID(templateID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaTemplatescriptMapper;
import com.smartor.domain.IvrLibaTemplatescript;
import com.smartor.service.IIvrLibaTemplatescriptService;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaTemplatescriptServiceImpl implements IIvrLibaTemplatescriptService 
{
    @Autowired
    private IvrLibaTemplatescriptMapper ivrLibaTemplatescriptMapper;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术
     */
    @Override
    public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID)
    {
        return ivrLibaTemplatescriptMapper.selectIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID);
    }

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术列表
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return è¯æœ¯æ¨¡æ¿åº“话术
     */
    @Override
    public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        return ivrLibaTemplatescriptMapper.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript);
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        ivrLibaTemplatescript.setCreateTime(DateUtils.getNowDate());
        return ivrLibaTemplatescriptMapper.insertIvrLibaTemplatescript(ivrLibaTemplatescript);
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param ivrLibaTemplatescript è¯æœ¯æ¨¡æ¿åº“话术
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript)
    {
        ivrLibaTemplatescript.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaTemplatescriptMapper.updateIvrLibaTemplatescript(ivrLibaTemplatescript);
    }

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术
     * 
     * @param templateQuestionIDs éœ€è¦åˆ é™¤çš„话术模板库话术主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs)
    {
        return ivrLibaTemplatescriptMapper.deleteIvrLibaTemplatescriptByTemplateQuestionIDs(templateQuestionIDs);
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术信息
     * 
     * @param templateQuestionID è¯æœ¯æ¨¡æ¿åº“话术主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID)
    {
        return ivrLibaTemplatescriptMapper.deleteIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.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.smartor.mapper.IvrLibaTemplatetargetMapper;
import com.smartor.domain.IvrLibaTemplatetarget;
import com.smartor.service.IIvrLibaTemplatetargetService;

/**
 * è¯æœ¯æ¨¡æ¿åº“话术指标Service业务层处理
 * 
 * @author smartor
 * @date 2023-03-22
 */
@Service
public class IvrLibaTemplatetargetServiceImpl implements IIvrLibaTemplatetargetService 
{
    @Autowired
    private IvrLibaTemplatetargetMapper ivrLibaTemplatetargetMapper;

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    @Override
    public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID)
    {
        return ivrLibaTemplatetargetMapper.selectIvrLibaTemplatetargetByTemplateTargetID(templateTargetID);
    }

    /**
     * æŸ¥è¯¢è¯æœ¯æ¨¡æ¿åº“话术指标列表
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return è¯æœ¯æ¨¡æ¿åº“话术指标
     */
    @Override
    public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        return ivrLibaTemplatetargetMapper.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget);
    }

    /**
     * æ–°å¢žè¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    @Override
    public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        ivrLibaTemplatetarget.setCreateTime(DateUtils.getNowDate());
        return ivrLibaTemplatetargetMapper.insertIvrLibaTemplatetarget(ivrLibaTemplatetarget);
    }

    /**
     * ä¿®æ”¹è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param ivrLibaTemplatetarget è¯æœ¯æ¨¡æ¿åº“话术指标
     * @return ç»“æžœ
     */
    @Override
    public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget)
    {
        ivrLibaTemplatetarget.setUpdateTime(DateUtils.getNowDate());
        return ivrLibaTemplatetargetMapper.updateIvrLibaTemplatetarget(ivrLibaTemplatetarget);
    }

    /**
     * æ‰¹é‡åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标
     * 
     * @param templateTargetIDs éœ€è¦åˆ é™¤çš„话术模板库话术指标主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs)
    {
        return ivrLibaTemplatetargetMapper.deleteIvrLibaTemplatetargetByTemplateTargetIDs(templateTargetIDs);
    }

    /**
     * åˆ é™¤è¯æœ¯æ¨¡æ¿åº“话术指标信息
     * 
     * @param templateTargetID è¯æœ¯æ¨¡æ¿åº“话术指标主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID)
    {
        return ivrLibaTemplatetargetMapper.deleteIvrLibaTemplatetargetByTemplateTargetID(templateTargetID);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,143 @@
<?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.IvrLibaExtemplateMapper">
    
    <resultMap type="IvrLibaExtemplate" id="IvrLibaExtemplateResult">
        <result property="subModuleID"    column="subModuleID"    />
        <result property="subModuleName"    column="subModuleName"    />
        <result property="language"    column="language"    />
        <result property="description"    column="description"    />
        <result property="version"    column="version"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <result property="addUserID"    column="addUserID"    />
        <result property="addTime"    column="addTime"    />
        <result property="modifyUserID"    column="modifyUserID"    />
        <result property="modifyTime"    column="modifyTime"    />
        <result property="GroupID"    column="GroupID"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaExtemplateVo">
        select subModuleID, subModuleName, language, description, version, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, GroupID, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_extemplate
    </sql>

    <select id="selectIvrLibaExtemplateList" parameterType="IvrLibaExtemplate" resultMap="IvrLibaExtemplateResult">
        <include refid="selectIvrLibaExtemplateVo"/>
        <where>  
            <if test="subModuleName != null  and subModuleName != ''"> and subModuleName like concat('%', #{subModuleName}, '%')</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="description != null  and description != ''"> and description = #{description}</if>
            <if test="version != null "> and version = #{version}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</if>
            <if test="addUserID != null  and addUserID != ''"> and addUserID = #{addUserID}</if>
            <if test="addTime != null "> and addTime = #{addTime}</if>
            <if test="modifyUserID != null  and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if>
            <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if>
            <if test="GroupID != null "> and GroupID = #{GroupID}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaExtemplateBySubModuleID" parameterType="String" resultMap="IvrLibaExtemplateResult">
        <include refid="selectIvrLibaExtemplateVo"/>
        where subModuleID = #{subModuleID}
    </select>
        
    <insert id="insertIvrLibaExtemplate" parameterType="IvrLibaExtemplate">
        insert into ivr_liba_extemplate
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="subModuleID != null">subModuleID,</if>
            <if test="subModuleName != null and subModuleName != ''">subModuleName,</if>
            <if test="language != null and language != ''">language,</if>
            <if test="description != null">description,</if>
            <if test="version != null">version,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</if>
            <if test="addUserID != null">addUserID,</if>
            <if test="addTime != null">addTime,</if>
            <if test="modifyUserID != null">modifyUserID,</if>
            <if test="modifyTime != null">modifyTime,</if>
            <if test="GroupID != null">GroupID,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="subModuleID != null">#{subModuleID},</if>
            <if test="subModuleName != null and subModuleName != ''">#{subModuleName},</if>
            <if test="language != null and language != ''">#{language},</if>
            <if test="description != null">#{description},</if>
            <if test="version != null">#{version},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</if>
            <if test="addUserID != null">#{addUserID},</if>
            <if test="addTime != null">#{addTime},</if>
            <if test="modifyUserID != null">#{modifyUserID},</if>
            <if test="modifyTime != null">#{modifyTime},</if>
            <if test="GroupID != null">#{GroupID},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaExtemplate" parameterType="IvrLibaExtemplate">
        update ivr_liba_extemplate
        <trim prefix="SET" suffixOverrides=",">
            <if test="subModuleName != null and subModuleName != ''">subModuleName = #{subModuleName},</if>
            <if test="language != null and language != ''">language = #{language},</if>
            <if test="description != null">description = #{description},</if>
            <if test="version != null">version = #{version},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</if>
            <if test="addUserID != null">addUserID = #{addUserID},</if>
            <if test="addTime != null">addTime = #{addTime},</if>
            <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if>
            <if test="modifyTime != null">modifyTime = #{modifyTime},</if>
            <if test="GroupID != null">GroupID = #{GroupID},</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>
        </trim>
        where subModuleID = #{subModuleID}
    </update>

    <delete id="deleteIvrLibaExtemplateBySubModuleID" parameterType="String">
        delete from ivr_liba_extemplate where subModuleID = #{subModuleID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,123 @@
<?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.IvrLibaExtemplatescriptMapper">
    
    <resultMap type="IvrLibaExtemplatescript" id="IvrLibaExtemplatescriptResult">
        <result property="DetailID"    column="DetailID"    />
        <result property="subModuleID"    column="subModuleID"    />
        <result property="switchID"    column="switchID"    />
        <result property="switchText"    column="switchText"    />
        <result property="switchWav"    column="switchWav"    />
        <result property="selfRegex"    column="selfRegex"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaExtemplatescriptVo">
        select DetailID, subModuleID, switchID, switchText, switchWav, selfRegex, isEnable, isDel, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_extemplatescript
    </sql>

    <select id="selectIvrLibaExtemplatescriptList" parameterType="IvrLibaExtemplatescript" resultMap="IvrLibaExtemplatescriptResult">
        <include refid="selectIvrLibaExtemplatescriptVo"/>
        <where>  
            <if test="subModuleID != null  and subModuleID != ''"> and subModuleID = #{subModuleID}</if>
            <if test="switchID != null "> and switchID = #{switchID}</if>
            <if test="switchText != null  and switchText != ''"> and switchText = #{switchText}</if>
            <if test="switchWav != null  and switchWav != ''"> and switchWav = #{switchWav}</if>
            <if test="selfRegex != null  and selfRegex != ''"> and selfRegex = #{selfRegex}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaExtemplatescriptByDetailID" parameterType="String" resultMap="IvrLibaExtemplatescriptResult">
        <include refid="selectIvrLibaExtemplatescriptVo"/>
        where DetailID = #{DetailID}
    </select>
        
    <insert id="insertIvrLibaExtemplatescript" parameterType="IvrLibaExtemplatescript">
        insert into ivr_liba_extemplatescript
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="DetailID != null">DetailID,</if>
            <if test="subModuleID != null and subModuleID != ''">subModuleID,</if>
            <if test="switchID != null">switchID,</if>
            <if test="switchText != null">switchText,</if>
            <if test="switchWav != null">switchWav,</if>
            <if test="selfRegex != null">selfRegex,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="DetailID != null">#{DetailID},</if>
            <if test="subModuleID != null and subModuleID != ''">#{subModuleID},</if>
            <if test="switchID != null">#{switchID},</if>
            <if test="switchText != null">#{switchText},</if>
            <if test="switchWav != null">#{switchWav},</if>
            <if test="selfRegex != null">#{selfRegex},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaExtemplatescript" parameterType="IvrLibaExtemplatescript">
        update ivr_liba_extemplatescript
        <trim prefix="SET" suffixOverrides=",">
            <if test="subModuleID != null and subModuleID != ''">subModuleID = #{subModuleID},</if>
            <if test="switchID != null">switchID = #{switchID},</if>
            <if test="switchText != null">switchText = #{switchText},</if>
            <if test="switchWav != null">switchWav = #{switchWav},</if>
            <if test="selfRegex != null">selfRegex = #{selfRegex},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</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>
        </trim>
        where DetailID = #{DetailID}
    </update>

    <delete id="deleteIvrLibaExtemplatescriptByDetailID" parameterType="String">
        delete from ivr_liba_extemplatescript where DetailID = #{DetailID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,207 @@
<?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.IvrLibaScriptMapper">
    
    <resultMap type="IvrLibaScript" id="IvrLibaScriptResult">
        <result property="questionid"    column="questionid"    />
        <result property="questionpoint"    column="questionpoint"    />
        <result property="questiontext"    column="questiontext"    />
        <result property="questionvoice"    column="questionvoice"    />
        <result property="nomatchtext"    column="nomatchtext"    />
        <result property="nomatchvoice"    column="nomatchvoice"    />
        <result property="sliencetext"    column="sliencetext"    />
        <result property="sliencevoice"    column="sliencevoice"    />
        <result property="submoduletext"    column="submoduletext"    />
        <result property="submodulevoice"    column="submodulevoice"    />
        <result property="noclearlytext"    column="noclearlytext"    />
        <result property="noclearlyvoice"    column="noclearlyvoice"    />
        <result property="questiontype"    column="questiontype"    />
        <result property="categoryname"    column="categoryname"    />
        <result property="targetoptions"    column="targetoptions"    />
        <result property="language"    column="language"    />
        <result property="description"    column="description"    />
        <result property="version"    column="version"    />
        <result property="isenable"    column="isenable"    />
        <result property="isdel"    column="isdel"    />
        <result property="adduserid"    column="adduserid"    />
        <result property="addtime"    column="addtime"    />
        <result property="modifyuserid"    column="modifyuserid"    />
        <result property="modifytime"    column="modifytime"    />
        <result property="groupid"    column="groupid"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaScriptVo">
        select questionid, questionpoint, questiontext, questionvoice, nomatchtext, nomatchvoice, sliencetext, sliencevoice, submoduletext, submodulevoice, noclearlytext, noclearlyvoice, questiontype, categoryname, targetoptions, language, description, version, isenable, isdel, adduserid, addtime, modifyuserid, modifytime, groupid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_script
    </sql>

    <select id="selectIvrLibaScriptList" parameterType="IvrLibaScript" resultMap="IvrLibaScriptResult">
        <include refid="selectIvrLibaScriptVo"/>
        <where>  
            <if test="questionpoint != null  and questionpoint != ''"> and questionpoint = #{questionpoint}</if>
            <if test="questiontext != null  and questiontext != ''"> and questiontext = #{questiontext}</if>
            <if test="questionvoice != null  and questionvoice != ''"> and questionvoice = #{questionvoice}</if>
            <if test="nomatchtext != null  and nomatchtext != ''"> and nomatchtext = #{nomatchtext}</if>
            <if test="nomatchvoice != null  and nomatchvoice != ''"> and nomatchvoice = #{nomatchvoice}</if>
            <if test="sliencetext != null  and sliencetext != ''"> and sliencetext = #{sliencetext}</if>
            <if test="sliencevoice != null  and sliencevoice != ''"> and sliencevoice = #{sliencevoice}</if>
            <if test="submoduletext != null  and submoduletext != ''"> and submoduletext = #{submoduletext}</if>
            <if test="submodulevoice != null  and submodulevoice != ''"> and submodulevoice = #{submodulevoice}</if>
            <if test="noclearlytext != null  and noclearlytext != ''"> and noclearlytext = #{noclearlytext}</if>
            <if test="noclearlyvoice != null  and noclearlyvoice != ''"> and noclearlyvoice = #{noclearlyvoice}</if>
            <if test="questiontype != null  and questiontype != ''"> and questiontype = #{questiontype}</if>
            <if test="categoryname != null  and categoryname != ''"> and categoryname like concat('%', #{categoryname}, '%')</if>
            <if test="targetoptions != null  and targetoptions != ''"> and targetoptions = #{targetoptions}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="version != null "> and version = #{version}</if>
            <if test="isenable != null "> and isenable = #{isenable}</if>
            <if test="isdel != null "> and isdel = #{isdel}</if>
            <if test="adduserid != null  and adduserid != ''"> and adduserid = #{adduserid}</if>
            <if test="addtime != null "> and addtime = #{addtime}</if>
            <if test="modifyuserid != null  and modifyuserid != ''"> and modifyuserid = #{modifyuserid}</if>
            <if test="modifytime != null "> and modifytime = #{modifytime}</if>
            <if test="groupid != null  and groupid != ''"> and groupid = #{groupid}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaScriptByQuestionid" parameterType="String" resultMap="IvrLibaScriptResult">
        <include refid="selectIvrLibaScriptVo"/>
        where questionid = #{questionid}
    </select>
        
    <insert id="insertIvrLibaScript" parameterType="IvrLibaScript">
        insert into ivr_liba_script
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="questionid != null">questionid,</if>
            <if test="questionpoint != null">questionpoint,</if>
            <if test="questiontext != null">questiontext,</if>
            <if test="questionvoice != null">questionvoice,</if>
            <if test="nomatchtext != null">nomatchtext,</if>
            <if test="nomatchvoice != null">nomatchvoice,</if>
            <if test="sliencetext != null">sliencetext,</if>
            <if test="sliencevoice != null">sliencevoice,</if>
            <if test="submoduletext != null">submoduletext,</if>
            <if test="submodulevoice != null">submodulevoice,</if>
            <if test="noclearlytext != null">noclearlytext,</if>
            <if test="noclearlyvoice != null">noclearlyvoice,</if>
            <if test="questiontype != null">questiontype,</if>
            <if test="categoryname != null">categoryname,</if>
            <if test="targetoptions != null">targetoptions,</if>
            <if test="language != null">language,</if>
            <if test="description != null">description,</if>
            <if test="version != null">version,</if>
            <if test="isenable != null">isenable,</if>
            <if test="isdel != null">isdel,</if>
            <if test="adduserid != null">adduserid,</if>
            <if test="addtime != null">addtime,</if>
            <if test="modifyuserid != null">modifyuserid,</if>
            <if test="modifytime != null">modifytime,</if>
            <if test="groupid != null">groupid,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="questionid != null">#{questionid},</if>
            <if test="questionpoint != null">#{questionpoint},</if>
            <if test="questiontext != null">#{questiontext},</if>
            <if test="questionvoice != null">#{questionvoice},</if>
            <if test="nomatchtext != null">#{nomatchtext},</if>
            <if test="nomatchvoice != null">#{nomatchvoice},</if>
            <if test="sliencetext != null">#{sliencetext},</if>
            <if test="sliencevoice != null">#{sliencevoice},</if>
            <if test="submoduletext != null">#{submoduletext},</if>
            <if test="submodulevoice != null">#{submodulevoice},</if>
            <if test="noclearlytext != null">#{noclearlytext},</if>
            <if test="noclearlyvoice != null">#{noclearlyvoice},</if>
            <if test="questiontype != null">#{questiontype},</if>
            <if test="categoryname != null">#{categoryname},</if>
            <if test="targetoptions != null">#{targetoptions},</if>
            <if test="language != null">#{language},</if>
            <if test="description != null">#{description},</if>
            <if test="version != null">#{version},</if>
            <if test="isenable != null">#{isenable},</if>
            <if test="isdel != null">#{isdel},</if>
            <if test="adduserid != null">#{adduserid},</if>
            <if test="addtime != null">#{addtime},</if>
            <if test="modifyuserid != null">#{modifyuserid},</if>
            <if test="modifytime != null">#{modifytime},</if>
            <if test="groupid != null">#{groupid},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaScript" parameterType="IvrLibaScript">
        update ivr_liba_script
        <trim prefix="SET" suffixOverrides=",">
            <if test="questionpoint != null">questionpoint = #{questionpoint},</if>
            <if test="questiontext != null">questiontext = #{questiontext},</if>
            <if test="questionvoice != null">questionvoice = #{questionvoice},</if>
            <if test="nomatchtext != null">nomatchtext = #{nomatchtext},</if>
            <if test="nomatchvoice != null">nomatchvoice = #{nomatchvoice},</if>
            <if test="sliencetext != null">sliencetext = #{sliencetext},</if>
            <if test="sliencevoice != null">sliencevoice = #{sliencevoice},</if>
            <if test="submoduletext != null">submoduletext = #{submoduletext},</if>
            <if test="submodulevoice != null">submodulevoice = #{submodulevoice},</if>
            <if test="noclearlytext != null">noclearlytext = #{noclearlytext},</if>
            <if test="noclearlyvoice != null">noclearlyvoice = #{noclearlyvoice},</if>
            <if test="questiontype != null">questiontype = #{questiontype},</if>
            <if test="categoryname != null">categoryname = #{categoryname},</if>
            <if test="targetoptions != null">targetoptions = #{targetoptions},</if>
            <if test="language != null">language = #{language},</if>
            <if test="description != null">description = #{description},</if>
            <if test="version != null">version = #{version},</if>
            <if test="isenable != null">isenable = #{isenable},</if>
            <if test="isdel != null">isdel = #{isdel},</if>
            <if test="adduserid != null">adduserid = #{adduserid},</if>
            <if test="addtime != null">addtime = #{addtime},</if>
            <if test="modifyuserid != null">modifyuserid = #{modifyuserid},</if>
            <if test="modifytime != null">modifytime = #{modifytime},</if>
            <if test="groupid != null">groupid = #{groupid},</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>
        </trim>
        where questionid = #{questionid}
    </update>

    <delete id="deleteIvrLibaScriptByQuestionid" parameterType="String">
        delete from ivr_liba_script where questionid = #{questionid}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,153 @@
<?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="IvrLibaScripttarget" id="IvrLibaScripttargetResult">
        <result property="questionTargetID"    column="questionTargetID"    />
        <result property="questionID"    column="questionID"    />
        <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="isDel"    column="isDel"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaScripttargetVo">
        select questionTargetID, questionID, targetID, targetType, categoryName, targetValue, basicRegex, selfRegex, regexUsedType, sort, version, isEnable, isDel, tipsJson, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_scripttarget
    </sql>

    <select id="selectIvrLibaScripttargetList" parameterType="IvrLibaScripttarget" resultMap="IvrLibaScripttargetResult">
        <include refid="selectIvrLibaScripttargetVo"/>
        <where>  
            <if test="questionID != null  and questionID != ''"> and questionID = #{questionID}</if>
            <if test="targetID != null  and targetID != ''"> 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="isDel != null "> and isDel = #{isDel}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaScripttargetByQuestionTargetID" parameterType="String" resultMap="IvrLibaScripttargetResult">
        <include refid="selectIvrLibaScripttargetVo"/>
        where questionTargetID = #{questionTargetID}
    </select>
        
    <insert id="insertIvrLibaScripttarget" parameterType="IvrLibaScripttarget">
        insert into ivr_liba_scripttarget
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="questionTargetID != null">questionTargetID,</if>
            <if test="questionID != null and questionID != ''">questionID,</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="isDel != null">isDel,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="questionTargetID != null">#{questionTargetID},</if>
            <if test="questionID != null and questionID != ''">#{questionID},</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="isDel != null">#{isDel},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaScripttarget" parameterType="IvrLibaScripttarget">
        update ivr_liba_scripttarget
        <trim prefix="SET" suffixOverrides=",">
            <if test="questionID != null and questionID != ''">questionID = #{questionID},</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="isDel != null">isDel = #{isDel},</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>
        </trim>
        where questionTargetID = #{questionTargetID}
    </update>

    <delete id="deleteIvrLibaScripttargetByQuestionTargetID" parameterType="String">
        delete from ivr_liba_scripttarget where questionTargetID = #{questionTargetID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,173 @@
<?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.IvrLibaTargetMapper">
    
    <resultMap type="IvrLibaTarget" id="IvrLibaTargetResult">
        <result property="targetID"    column="targetID"    />
        <result property="targetType"    column="targetType"    />
        <result property="categoryName"    column="categoryName"    />
        <result property="targetValue"    column="targetValue"    />
        <result property="targetRegex"    column="targetRegex"    />
        <result property="description"    column="description"    />
        <result property="language"    column="language"    />
        <result property="version"    column="version"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <result property="addUserID"    column="addUserID"    />
        <result property="addTime"    column="addTime"    />
        <result property="modifyUserID"    column="modifyUserID"    />
        <result property="modifyTime"    column="modifyTime"    />
        <result property="groupID"    column="groupID"    />
        <result property="isAbnormal"    column="isAbnormal"    />
        <result property="WarnUp"    column="WarnUp"    />
        <result property="WarnDown"    column="WarnDown"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaTargetVo">
        select targetID, targetType, categoryName, targetValue, targetRegex, description, language, version, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, groupID, isAbnormal, WarnUp, WarnDown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_target
    </sql>

    <select id="selectIvrLibaTargetList" parameterType="IvrLibaTarget" resultMap="IvrLibaTargetResult">
        <include refid="selectIvrLibaTargetVo"/>
        <where>  
            <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="targetRegex != null  and targetRegex != ''"> and targetRegex = #{targetRegex}</if>
            <if test="description != null  and description != ''"> and description = #{description}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="version != null "> and version = #{version}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</if>
            <if test="addUserID != null  and addUserID != ''"> and addUserID = #{addUserID}</if>
            <if test="addTime != null "> and addTime = #{addTime}</if>
            <if test="modifyUserID != null  and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if>
            <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if>
            <if test="groupID != null  and groupID != ''"> and groupID = #{groupID}</if>
            <if test="isAbnormal != null "> and isAbnormal = #{isAbnormal}</if>
            <if test="WarnUp != null "> and WarnUp = #{WarnUp}</if>
            <if test="WarnDown != null "> and WarnDown = #{WarnDown}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaTargetByTargetID" parameterType="String" resultMap="IvrLibaTargetResult">
        <include refid="selectIvrLibaTargetVo"/>
        where targetID = #{targetID}
    </select>
        
    <insert id="insertIvrLibaTarget" parameterType="IvrLibaTarget">
        insert into ivr_liba_target
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="targetID != null">targetID,</if>
            <if test="targetType != null and targetType != ''">targetType,</if>
            <if test="categoryName != null and categoryName != ''">categoryName,</if>
            <if test="targetValue != null">targetValue,</if>
            <if test="targetRegex != null">targetRegex,</if>
            <if test="description != null">description,</if>
            <if test="language != null and language != ''">language,</if>
            <if test="version != null">version,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</if>
            <if test="addUserID != null">addUserID,</if>
            <if test="addTime != null">addTime,</if>
            <if test="modifyUserID != null">modifyUserID,</if>
            <if test="modifyTime != null">modifyTime,</if>
            <if test="groupID != null">groupID,</if>
            <if test="isAbnormal != null">isAbnormal,</if>
            <if test="WarnUp != null">WarnUp,</if>
            <if test="WarnDown != null">WarnDown,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="targetID != null">#{targetID},</if>
            <if test="targetType != null and targetType != ''">#{targetType},</if>
            <if test="categoryName != null and categoryName != ''">#{categoryName},</if>
            <if test="targetValue != null">#{targetValue},</if>
            <if test="targetRegex != null">#{targetRegex},</if>
            <if test="description != null">#{description},</if>
            <if test="language != null and language != ''">#{language},</if>
            <if test="version != null">#{version},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</if>
            <if test="addUserID != null">#{addUserID},</if>
            <if test="addTime != null">#{addTime},</if>
            <if test="modifyUserID != null">#{modifyUserID},</if>
            <if test="modifyTime != null">#{modifyTime},</if>
            <if test="groupID != null">#{groupID},</if>
            <if test="isAbnormal != null">#{isAbnormal},</if>
            <if test="WarnUp != null">#{WarnUp},</if>
            <if test="WarnDown != null">#{WarnDown},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaTarget" parameterType="IvrLibaTarget">
        update ivr_liba_target
        <trim prefix="SET" suffixOverrides=",">
            <if test="targetType != null and targetType != ''">targetType = #{targetType},</if>
            <if test="categoryName != null and categoryName != ''">categoryName = #{categoryName},</if>
            <if test="targetValue != null">targetValue = #{targetValue},</if>
            <if test="targetRegex != null">targetRegex = #{targetRegex},</if>
            <if test="description != null">description = #{description},</if>
            <if test="language != null and language != ''">language = #{language},</if>
            <if test="version != null">version = #{version},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</if>
            <if test="addUserID != null">addUserID = #{addUserID},</if>
            <if test="addTime != null">addTime = #{addTime},</if>
            <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if>
            <if test="modifyTime != null">modifyTime = #{modifyTime},</if>
            <if test="groupID != null">groupID = #{groupID},</if>
            <if test="isAbnormal != null">isAbnormal = #{isAbnormal},</if>
            <if test="WarnUp != null">WarnUp = #{WarnUp},</if>
            <if test="WarnDown != null">WarnDown = #{WarnDown},</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>
        </trim>
        where targetID = #{targetID}
    </update>

    <delete id="deleteIvrLibaTargetByTargetID" parameterType="String">
        delete from ivr_liba_target where targetID = #{targetID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,208 @@
<?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.IvrLibaTemplateMapper">
    
    <resultMap type="IvrLibaTemplate" id="IvrLibaTemplateResult">
        <result property="templateID"    column="templateID"    />
        <result property="templateName"    column="templateName"    />
        <result property="silencetime"    column="silencetime"    />
        <result property="slienceRepeatTimes"    column="slienceRepeatTimes"    />
        <result property="nomatchRepeatTimes"    column="nomatchRepeatTimes"    />
        <result property="firstQuestionNum"    column="firstQuestionNum"    />
        <result property="submodule"    column="submodule"    />
        <result property="language"    column="language"    />
        <result property="description"    column="description"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <result property="addUserID"    column="addUserID"    />
        <result property="addTime"    column="addTime"    />
        <result property="modifyUserID"    column="modifyUserID"    />
        <result property="modifyTime"    column="modifyTime"    />
        <result property="groupID"    column="groupID"    />
        <result property="labelInfo"    column="labelInfo"    />
        <result property="submoduleID"    column="submoduleID"    />
        <result property="playType"    column="playType"    />
        <result property="icd10code"    column="icd10code"    />
        <result property="icd10codename"    column="icd10codename"    />
        <result property="atuoTaskDayOffset"    column="atuoTaskDayOffset"    />
        <result property="DeptIds"    column="DeptIds"    />
        <result property="DeptNames"    column="DeptNames"    />
        <result property="fKsdm"    column="F_KSDM"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaTemplateVo">
        select templateID, templateName, silencetime, slienceRepeatTimes, nomatchRepeatTimes, firstQuestionNum, submodule, language, description, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, groupID, labelInfo, submoduleID, playType, icd10code, icd10codename, atuoTaskDayOffset, DeptIds, DeptNames, F_KSDM, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_template
    </sql>

    <select id="selectIvrLibaTemplateList" parameterType="IvrLibaTemplate" resultMap="IvrLibaTemplateResult">
        <include refid="selectIvrLibaTemplateVo"/>
        <where>  
            <if test="templateName != null  and templateName != ''"> and templateName like concat('%', #{templateName}, '%')</if>
            <if test="silencetime != null "> and silencetime = #{silencetime}</if>
            <if test="slienceRepeatTimes != null "> and slienceRepeatTimes = #{slienceRepeatTimes}</if>
            <if test="nomatchRepeatTimes != null "> and nomatchRepeatTimes = #{nomatchRepeatTimes}</if>
            <if test="firstQuestionNum != null "> and firstQuestionNum = #{firstQuestionNum}</if>
            <if test="submodule != null  and submodule != ''"> and submodule = #{submodule}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="description != null  and description != ''"> and description = #{description}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</if>
            <if test="addUserID != null  and addUserID != ''"> and addUserID = #{addUserID}</if>
            <if test="addTime != null "> and addTime = #{addTime}</if>
            <if test="modifyUserID != null  and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if>
            <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if>
            <if test="groupID != null  and groupID != ''"> and groupID = #{groupID}</if>
            <if test="labelInfo != null  and labelInfo != ''"> and labelInfo = #{labelInfo}</if>
            <if test="submoduleID != null  and submoduleID != ''"> and submoduleID = #{submoduleID}</if>
            <if test="playType != null "> and playType = #{playType}</if>
            <if test="icd10code != null  and icd10code != ''"> and icd10code = #{icd10code}</if>
            <if test="icd10codename != null  and icd10codename != ''"> and icd10codename like concat('%', #{icd10codename}, '%')</if>
            <if test="atuoTaskDayOffset != null "> and atuoTaskDayOffset = #{atuoTaskDayOffset}</if>
            <if test="DeptIds != null  and DeptIds != ''"> and DeptIds = #{DeptIds}</if>
            <if test="DeptNames != null  and DeptNames != ''"> and DeptNames = #{DeptNames}</if>
            <if test="fKsdm != null  and fKsdm != ''"> and F_KSDM = #{fKsdm}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaTemplateByTemplateID" parameterType="String" resultMap="IvrLibaTemplateResult">
        <include refid="selectIvrLibaTemplateVo"/>
        where templateID = #{templateID}
    </select>
        
    <insert id="insertIvrLibaTemplate" parameterType="IvrLibaTemplate">
        insert into ivr_liba_template
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateID != null">templateID,</if>
            <if test="templateName != null and templateName != ''">templateName,</if>
            <if test="silencetime != null">silencetime,</if>
            <if test="slienceRepeatTimes != null">slienceRepeatTimes,</if>
            <if test="nomatchRepeatTimes != null">nomatchRepeatTimes,</if>
            <if test="firstQuestionNum != null">firstQuestionNum,</if>
            <if test="submodule != null">submodule,</if>
            <if test="language != null and language != ''">language,</if>
            <if test="description != null">description,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</if>
            <if test="addUserID != null">addUserID,</if>
            <if test="addTime != null">addTime,</if>
            <if test="modifyUserID != null">modifyUserID,</if>
            <if test="modifyTime != null">modifyTime,</if>
            <if test="groupID != null">groupID,</if>
            <if test="labelInfo != null">labelInfo,</if>
            <if test="submoduleID != null">submoduleID,</if>
            <if test="playType != null">playType,</if>
            <if test="icd10code != null">icd10code,</if>
            <if test="icd10codename != null">icd10codename,</if>
            <if test="atuoTaskDayOffset != null">atuoTaskDayOffset,</if>
            <if test="DeptIds != null">DeptIds,</if>
            <if test="DeptNames != null">DeptNames,</if>
            <if test="fKsdm != null">F_KSDM,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="templateID != null">#{templateID},</if>
            <if test="templateName != null and templateName != ''">#{templateName},</if>
            <if test="silencetime != null">#{silencetime},</if>
            <if test="slienceRepeatTimes != null">#{slienceRepeatTimes},</if>
            <if test="nomatchRepeatTimes != null">#{nomatchRepeatTimes},</if>
            <if test="firstQuestionNum != null">#{firstQuestionNum},</if>
            <if test="submodule != null">#{submodule},</if>
            <if test="language != null and language != ''">#{language},</if>
            <if test="description != null">#{description},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</if>
            <if test="addUserID != null">#{addUserID},</if>
            <if test="addTime != null">#{addTime},</if>
            <if test="modifyUserID != null">#{modifyUserID},</if>
            <if test="modifyTime != null">#{modifyTime},</if>
            <if test="groupID != null">#{groupID},</if>
            <if test="labelInfo != null">#{labelInfo},</if>
            <if test="submoduleID != null">#{submoduleID},</if>
            <if test="playType != null">#{playType},</if>
            <if test="icd10code != null">#{icd10code},</if>
            <if test="icd10codename != null">#{icd10codename},</if>
            <if test="atuoTaskDayOffset != null">#{atuoTaskDayOffset},</if>
            <if test="DeptIds != null">#{DeptIds},</if>
            <if test="DeptNames != null">#{DeptNames},</if>
            <if test="fKsdm != null">#{fKsdm},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaTemplate" parameterType="IvrLibaTemplate">
        update ivr_liba_template
        <trim prefix="SET" suffixOverrides=",">
            <if test="templateName != null and templateName != ''">templateName = #{templateName},</if>
            <if test="silencetime != null">silencetime = #{silencetime},</if>
            <if test="slienceRepeatTimes != null">slienceRepeatTimes = #{slienceRepeatTimes},</if>
            <if test="nomatchRepeatTimes != null">nomatchRepeatTimes = #{nomatchRepeatTimes},</if>
            <if test="firstQuestionNum != null">firstQuestionNum = #{firstQuestionNum},</if>
            <if test="submodule != null">submodule = #{submodule},</if>
            <if test="language != null and language != ''">language = #{language},</if>
            <if test="description != null">description = #{description},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</if>
            <if test="addUserID != null">addUserID = #{addUserID},</if>
            <if test="addTime != null">addTime = #{addTime},</if>
            <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if>
            <if test="modifyTime != null">modifyTime = #{modifyTime},</if>
            <if test="groupID != null">groupID = #{groupID},</if>
            <if test="labelInfo != null">labelInfo = #{labelInfo},</if>
            <if test="submoduleID != null">submoduleID = #{submoduleID},</if>
            <if test="playType != null">playType = #{playType},</if>
            <if test="icd10code != null">icd10code = #{icd10code},</if>
            <if test="icd10codename != null">icd10codename = #{icd10codename},</if>
            <if test="atuoTaskDayOffset != null">atuoTaskDayOffset = #{atuoTaskDayOffset},</if>
            <if test="DeptIds != null">DeptIds = #{DeptIds},</if>
            <if test="DeptNames != null">DeptNames = #{DeptNames},</if>
            <if test="fKsdm != null">F_KSDM = #{fKsdm},</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>
        </trim>
        where templateID = #{templateID}
    </update>

    <delete id="deleteIvrLibaTemplateByTemplateID" parameterType="String">
        delete from ivr_liba_template where templateID = #{templateID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,188 @@
<?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.IvrLibaTemplatescriptMapper">
    
    <resultMap type="IvrLibaTemplatescript" id="IvrLibaTemplatescriptResult">
        <result property="templateQuestionID"    column="templateQuestionID"    />
        <result property="templateQuestionNum"    column="templateQuestionNum"    />
        <result property="templateID"    column="templateID"    />
        <result property="questionID"    column="questionID"    />
        <result property="questionPoint"    column="questionPoint"    />
        <result property="questionText"    column="questionText"    />
        <result property="questionVoice"    column="questionVoice"    />
        <result property="noMatchText"    column="noMatchText"    />
        <result property="noMatchVoice"    column="noMatchVoice"    />
        <result property="slienceText"    column="slienceText"    />
        <result property="slienceVoice"    column="slienceVoice"    />
        <result property="submoduleText"    column="submoduleText"    />
        <result property="submoduleVoice"    column="submoduleVoice"    />
        <result property="noClearlyText"    column="noClearlyText"    />
        <result property="noClearlyVoice"    column="noClearlyVoice"    />
        <result property="categoryName"    column="categoryName"    />
        <result property="targetOptions"    column="targetOptions"    />
        <result property="language"    column="language"    />
        <result property="playWavOnly"    column="playWavOnly"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaTemplatescriptVo">
        select templateQuestionID, templateQuestionNum, templateID, questionID, questionPoint, questionText, questionVoice, noMatchText, noMatchVoice, slienceText, slienceVoice, submoduleText, submoduleVoice, noClearlyText, noClearlyVoice, categoryName, targetOptions, language, playWavOnly, isEnable, isDel, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_templatescript
    </sql>

    <select id="selectIvrLibaTemplatescriptList" parameterType="IvrLibaTemplatescript" resultMap="IvrLibaTemplatescriptResult">
        <include refid="selectIvrLibaTemplatescriptVo"/>
        <where>  
            <if test="templateQuestionNum != null "> and templateQuestionNum = #{templateQuestionNum}</if>
            <if test="templateID != null  and templateID != ''"> and templateID = #{templateID}</if>
            <if test="questionID != null  and questionID != ''"> and questionID = #{questionID}</if>
            <if test="questionPoint != null  and questionPoint != ''"> and questionPoint = #{questionPoint}</if>
            <if test="questionText != null  and questionText != ''"> and questionText = #{questionText}</if>
            <if test="questionVoice != null  and questionVoice != ''"> and questionVoice = #{questionVoice}</if>
            <if test="noMatchText != null  and noMatchText != ''"> and noMatchText = #{noMatchText}</if>
            <if test="noMatchVoice != null  and noMatchVoice != ''"> and noMatchVoice = #{noMatchVoice}</if>
            <if test="slienceText != null  and slienceText != ''"> and slienceText = #{slienceText}</if>
            <if test="slienceVoice != null  and slienceVoice != ''"> and slienceVoice = #{slienceVoice}</if>
            <if test="submoduleText != null  and submoduleText != ''"> and submoduleText = #{submoduleText}</if>
            <if test="submoduleVoice != null  and submoduleVoice != ''"> and submoduleVoice = #{submoduleVoice}</if>
            <if test="noClearlyText != null  and noClearlyText != ''"> and noClearlyText = #{noClearlyText}</if>
            <if test="noClearlyVoice != null  and noClearlyVoice != ''"> and noClearlyVoice = #{noClearlyVoice}</if>
            <if test="categoryName != null  and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if>
            <if test="targetOptions != null  and targetOptions != ''"> and targetOptions = #{targetOptions}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="playWavOnly != null "> and playWavOnly = #{playWavOnly}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaTemplatescriptByTemplateQuestionID" parameterType="String" resultMap="IvrLibaTemplatescriptResult">
        <include refid="selectIvrLibaTemplatescriptVo"/>
        where templateQuestionID = #{templateQuestionID}
    </select>
        
    <insert id="insertIvrLibaTemplatescript" parameterType="IvrLibaTemplatescript">
        insert into ivr_liba_templatescript
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateQuestionID != null">templateQuestionID,</if>
            <if test="templateQuestionNum != null">templateQuestionNum,</if>
            <if test="templateID != null and templateID != ''">templateID,</if>
            <if test="questionID != null and questionID != ''">questionID,</if>
            <if test="questionPoint != null and questionPoint != ''">questionPoint,</if>
            <if test="questionText != null">questionText,</if>
            <if test="questionVoice != null">questionVoice,</if>
            <if test="noMatchText != null">noMatchText,</if>
            <if test="noMatchVoice != null">noMatchVoice,</if>
            <if test="slienceText != null">slienceText,</if>
            <if test="slienceVoice != null">slienceVoice,</if>
            <if test="submoduleText != null">submoduleText,</if>
            <if test="submoduleVoice != null">submoduleVoice,</if>
            <if test="noClearlyText != null">noClearlyText,</if>
            <if test="noClearlyVoice != null">noClearlyVoice,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="targetOptions != null">targetOptions,</if>
            <if test="language != null and language != ''">language,</if>
            <if test="playWavOnly != null">playWavOnly,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="templateQuestionID != null">#{templateQuestionID},</if>
            <if test="templateQuestionNum != null">#{templateQuestionNum},</if>
            <if test="templateID != null and templateID != ''">#{templateID},</if>
            <if test="questionID != null and questionID != ''">#{questionID},</if>
            <if test="questionPoint != null and questionPoint != ''">#{questionPoint},</if>
            <if test="questionText != null">#{questionText},</if>
            <if test="questionVoice != null">#{questionVoice},</if>
            <if test="noMatchText != null">#{noMatchText},</if>
            <if test="noMatchVoice != null">#{noMatchVoice},</if>
            <if test="slienceText != null">#{slienceText},</if>
            <if test="slienceVoice != null">#{slienceVoice},</if>
            <if test="submoduleText != null">#{submoduleText},</if>
            <if test="submoduleVoice != null">#{submoduleVoice},</if>
            <if test="noClearlyText != null">#{noClearlyText},</if>
            <if test="noClearlyVoice != null">#{noClearlyVoice},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="targetOptions != null">#{targetOptions},</if>
            <if test="language != null and language != ''">#{language},</if>
            <if test="playWavOnly != null">#{playWavOnly},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaTemplatescript" parameterType="IvrLibaTemplatescript">
        update ivr_liba_templatescript
        <trim prefix="SET" suffixOverrides=",">
            <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if>
            <if test="templateID != null and templateID != ''">templateID = #{templateID},</if>
            <if test="questionID != null and questionID != ''">questionID = #{questionID},</if>
            <if test="questionPoint != null and questionPoint != ''">questionPoint = #{questionPoint},</if>
            <if test="questionText != null">questionText = #{questionText},</if>
            <if test="questionVoice != null">questionVoice = #{questionVoice},</if>
            <if test="noMatchText != null">noMatchText = #{noMatchText},</if>
            <if test="noMatchVoice != null">noMatchVoice = #{noMatchVoice},</if>
            <if test="slienceText != null">slienceText = #{slienceText},</if>
            <if test="slienceVoice != null">slienceVoice = #{slienceVoice},</if>
            <if test="submoduleText != null">submoduleText = #{submoduleText},</if>
            <if test="submoduleVoice != null">submoduleVoice = #{submoduleVoice},</if>
            <if test="noClearlyText != null">noClearlyText = #{noClearlyText},</if>
            <if test="noClearlyVoice != null">noClearlyVoice = #{noClearlyVoice},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="targetOptions != null">targetOptions = #{targetOptions},</if>
            <if test="language != null and language != ''">language = #{language},</if>
            <if test="playWavOnly != null">playWavOnly = #{playWavOnly},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</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>
        </trim>
        where templateQuestionID = #{templateQuestionID}
    </update>

    <delete id="deleteIvrLibaTemplatescriptByTemplateQuestionID" parameterType="String">
        delete from ivr_liba_templatescript where templateQuestionID = #{templateQuestionID}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,193 @@
<?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.IvrLibaTemplatetargetMapper">
    
    <resultMap type="IvrLibaTemplatetarget" id="IvrLibaTemplatetargetResult">
        <result property="templateTargetID"    column="templateTargetID"    />
        <result property="templateQuestionID"    column="templateQuestionID"    />
        <result property="templateQuestionNum"    column="templateQuestionNum"    />
        <result property="nextQuestionNum"    column="nextQuestionNum"    />
        <result property="templateID"    column="templateID"    />
        <result property="switchID"    column="switchID"    />
        <result property="switchDescription"    column="switchDescription"    />
        <result property="switchText"    column="switchText"    />
        <result property="switchWav"    column="switchWav"    />
        <result property="switchTempWav"    column="switchTempWav"    />
        <result property="targetType"    column="targetType"    />
        <result property="categoryName"    column="categoryName"    />
        <result property="targetValue"    column="targetValue"    />
        <result property="targetID"    column="targetID"    />
        <result property="questionTargetID"    column="questionTargetID"    />
        <result property="basicRegex"    column="basicRegex"    />
        <result property="selfRegex"    column="selfRegex"    />
        <result property="regexUsedType"    column="regexUsedType"    />
        <result property="language"    column="language"    />
        <result property="isEnable"    column="isEnable"    />
        <result property="isDel"    column="isDel"    />
        <result property="playType"    column="playType"    />
        <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"    />
    </resultMap>

    <sql id="selectIvrLibaTemplatetargetVo">
        select templateTargetID, templateQuestionID, templateQuestionNum, nextQuestionNum, templateID, switchID, switchDescription, switchText, switchWav, switchTempWav, targetType, categoryName, targetValue, targetID, questionTargetID, basicRegex, selfRegex, regexUsedType, language, isEnable, isDel, playType, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_templatetarget
    </sql>

    <select id="selectIvrLibaTemplatetargetList" parameterType="IvrLibaTemplatetarget" resultMap="IvrLibaTemplatetargetResult">
        <include refid="selectIvrLibaTemplatetargetVo"/>
        <where>  
            <if test="templateQuestionID != null  and templateQuestionID != ''"> and templateQuestionID = #{templateQuestionID}</if>
            <if test="templateQuestionNum != null "> and templateQuestionNum = #{templateQuestionNum}</if>
            <if test="nextQuestionNum != null "> and nextQuestionNum = #{nextQuestionNum}</if>
            <if test="templateID != null  and templateID != ''"> and templateID = #{templateID}</if>
            <if test="switchID != null "> and switchID = #{switchID}</if>
            <if test="switchDescription != null  and switchDescription != ''"> and switchDescription = #{switchDescription}</if>
            <if test="switchText != null  and switchText != ''"> and switchText = #{switchText}</if>
            <if test="switchWav != null  and switchWav != ''"> and switchWav = #{switchWav}</if>
            <if test="switchTempWav != null  and switchTempWav != ''"> and switchTempWav = #{switchTempWav}</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="targetID != null  and targetID != ''"> and targetID = #{targetID}</if>
            <if test="questionTargetID != null  and questionTargetID != ''"> and questionTargetID = #{questionTargetID}</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="language != null  and language != ''"> and language = #{language}</if>
            <if test="isEnable != null "> and isEnable = #{isEnable}</if>
            <if test="isDel != null "> and isDel = #{isDel}</if>
            <if test="playType != null "> and playType = #{playType}</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>
        </where>
    </select>
    
    <select id="selectIvrLibaTemplatetargetByTemplateTargetID" parameterType="String" resultMap="IvrLibaTemplatetargetResult">
        <include refid="selectIvrLibaTemplatetargetVo"/>
        where templateTargetID = #{templateTargetID}
    </select>
        
    <insert id="insertIvrLibaTemplatetarget" parameterType="IvrLibaTemplatetarget">
        insert into ivr_liba_templatetarget
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateTargetID != null">templateTargetID,</if>
            <if test="templateQuestionID != null and templateQuestionID != ''">templateQuestionID,</if>
            <if test="templateQuestionNum != null">templateQuestionNum,</if>
            <if test="nextQuestionNum != null">nextQuestionNum,</if>
            <if test="templateID != null and templateID != ''">templateID,</if>
            <if test="switchID != null">switchID,</if>
            <if test="switchDescription != null">switchDescription,</if>
            <if test="switchText != null">switchText,</if>
            <if test="switchWav != null">switchWav,</if>
            <if test="switchTempWav != null">switchTempWav,</if>
            <if test="targetType != null">targetType,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="targetValue != null">targetValue,</if>
            <if test="targetID != null">targetID,</if>
            <if test="questionTargetID != null">questionTargetID,</if>
            <if test="basicRegex != null">basicRegex,</if>
            <if test="selfRegex != null">selfRegex,</if>
            <if test="regexUsedType != null">regexUsedType,</if>
            <if test="language != null and language != ''">language,</if>
            <if test="isEnable != null">isEnable,</if>
            <if test="isDel != null">isDel,</if>
            <if test="playType != null">playType,</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>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="templateTargetID != null">#{templateTargetID},</if>
            <if test="templateQuestionID != null and templateQuestionID != ''">#{templateQuestionID},</if>
            <if test="templateQuestionNum != null">#{templateQuestionNum},</if>
            <if test="nextQuestionNum != null">#{nextQuestionNum},</if>
            <if test="templateID != null and templateID != ''">#{templateID},</if>
            <if test="switchID != null">#{switchID},</if>
            <if test="switchDescription != null">#{switchDescription},</if>
            <if test="switchText != null">#{switchText},</if>
            <if test="switchWav != null">#{switchWav},</if>
            <if test="switchTempWav != null">#{switchTempWav},</if>
            <if test="targetType != null">#{targetType},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="targetValue != null">#{targetValue},</if>
            <if test="targetID != null">#{targetID},</if>
            <if test="questionTargetID != null">#{questionTargetID},</if>
            <if test="basicRegex != null">#{basicRegex},</if>
            <if test="selfRegex != null">#{selfRegex},</if>
            <if test="regexUsedType != null">#{regexUsedType},</if>
            <if test="language != null and language != ''">#{language},</if>
            <if test="isEnable != null">#{isEnable},</if>
            <if test="isDel != null">#{isDel},</if>
            <if test="playType != null">#{playType},</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>
         </trim>
    </insert>

    <update id="updateIvrLibaTemplatetarget" parameterType="IvrLibaTemplatetarget">
        update ivr_liba_templatetarget
        <trim prefix="SET" suffixOverrides=",">
            <if test="templateQuestionID != null and templateQuestionID != ''">templateQuestionID = #{templateQuestionID},</if>
            <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if>
            <if test="nextQuestionNum != null">nextQuestionNum = #{nextQuestionNum},</if>
            <if test="templateID != null and templateID != ''">templateID = #{templateID},</if>
            <if test="switchID != null">switchID = #{switchID},</if>
            <if test="switchDescription != null">switchDescription = #{switchDescription},</if>
            <if test="switchText != null">switchText = #{switchText},</if>
            <if test="switchWav != null">switchWav = #{switchWav},</if>
            <if test="switchTempWav != null">switchTempWav = #{switchTempWav},</if>
            <if test="targetType != null">targetType = #{targetType},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="targetValue != null">targetValue = #{targetValue},</if>
            <if test="targetID != null">targetID = #{targetID},</if>
            <if test="questionTargetID != null">questionTargetID = #{questionTargetID},</if>
            <if test="basicRegex != null">basicRegex = #{basicRegex},</if>
            <if test="selfRegex != null">selfRegex = #{selfRegex},</if>
            <if test="regexUsedType != null">regexUsedType = #{regexUsedType},</if>
            <if test="language != null and language != ''">language = #{language},</if>
            <if test="isEnable != null">isEnable = #{isEnable},</if>
            <if test="isDel != null">isDel = #{isDel},</if>
            <if test="playType != null">playType = #{playType},</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>
        </trim>
        where templateTargetID = #{templateTargetID}
    </update>

    <delete id="deleteIvrLibaTemplatetargetByTemplateTargetID" parameterType="String">
        delete from ivr_liba_templatetarget where templateTargetID = #{templateTargetID}
    </delete>

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