代码提交

liusheng

2024-06-21 ecda68f9ffbd4e0f01d3939550906f670b1e0482

代码提交

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

@@ -3,11 +3,16 @@
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.IvrTaskVO;
import com.smartor.domain.SvyTaskSingle;
import com.smartor.domain.SvyTaskVO;
import com.smartor.service.ISvyTaskSingleService;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
@@ -23,8 +28,7 @@
 */
@RestController
@RequestMapping("/smartor/svysingle")
public class SvyTaskSingleController extends BaseController
{
public class SvyTaskSingleController extends BaseController {
    @Autowired
    private ISvyTaskSingleService svyTaskSingleService;

@@ -33,8 +37,7 @@
     */
    @PreAuthorize("@ss.hasPermi('system:single:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyTaskSingle svyTaskSingle)
    {
    public TableDataInfo list(SvyTaskSingle svyTaskSingle) {
        startPage();
        List<SvyTaskSingle> list = svyTaskSingleService.selectSvyTaskSingleList(svyTaskSingle);
        return getDataTable(list);
@@ -46,8 +49,7 @@
    @PreAuthorize("@ss.hasPermi('system:single:export')")
    @Log(title = "单一任务（问卷）", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyTaskSingle svyTaskSingle)
    {
    public void export(HttpServletResponse response, SvyTaskSingle svyTaskSingle) {
        List<SvyTaskSingle> list = svyTaskSingleService.selectSvyTaskSingleList(svyTaskSingle);
        ExcelUtil<SvyTaskSingle> util = new ExcelUtil<SvyTaskSingle>(SvyTaskSingle.class);
        util.exportExcel(response, list, "单一任务（问卷）数据");
@@ -58,8 +60,7 @@
     */
    @PreAuthorize("@ss.hasPermi('system:single:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(svyTaskSingleService.selectSvyTaskSingleById(id));
    }

@@ -69,8 +70,7 @@
    @PreAuthorize("@ss.hasPermi('system:single:add')")
    @Log(title = "单一任务（问卷）", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyTaskSingle svyTaskSingle)
    {
    public AjaxResult add(@RequestBody SvyTaskSingle svyTaskSingle) {
        return toAjax(svyTaskSingleService.insertSvyTaskSingle(svyTaskSingle));
    }

@@ -80,8 +80,7 @@
    @PreAuthorize("@ss.hasPermi('system:single:edit')")
    @Log(title = "单一任务（问卷）", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyTaskSingle svyTaskSingle)
    {
    public AjaxResult edit(@RequestBody SvyTaskSingle svyTaskSingle) {
        return toAjax(svyTaskSingleService.updateSvyTaskSingle(svyTaskSingle));
    }

@@ -91,8 +90,21 @@
    @PreAuthorize("@ss.hasPermi('system:single:remove')")
    @Log(title = "单一任务（问卷）", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(svyTaskSingleService.deleteSvyTaskSingleByIds(ids));
    }

    /**
     * æ–°å¢žæˆ–修改删除问卷任务
     */
    @ApiOperation("新增或修改删除问卷任务")
    @PreAuthorize("@ss.hasPermi('system:task:add')")
    @PostMapping("/insertOrUpdateSvyTask")
    public AjaxResult insertOrUpdateSvyTask(@RequestBody SvyTaskVO svyTaskVO) {

        LoginUser loginUser = getLoginUser();
        SysUser user = loginUser.getUser();
        svyTaskVO.setCreateBy(user.getNickName());
        return toAjax(svyTaskSingleService.insertOrUpdateSvyTask(svyTaskVO));
    }
}

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

@@ -6,8 +6,11 @@
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.SendTaskVO;
import com.smartor.domain.SvyTaskTemplate;
import com.smartor.domain.SvyTaskTemplateVO;
import com.smartor.service.ISvyTaskTemplateService;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
@@ -23,8 +26,7 @@
 */
@RestController
@RequestMapping("/smartor/svytemplate")
public class SvyTaskTemplateController extends BaseController
{
public class SvyTaskTemplateController extends BaseController {
    @Autowired
    private ISvyTaskTemplateService svyTaskTemplateService;

@@ -33,8 +35,7 @@
     */
    @PreAuthorize("@ss.hasPermi('system:template:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyTaskTemplate svyTaskTemplate)
    {
    public TableDataInfo list(SvyTaskTemplate svyTaskTemplate) {
        startPage();
        List<SvyTaskTemplate> list = svyTaskTemplateService.selectSvyTaskTemplateList(svyTaskTemplate);
        return getDataTable(list);
@@ -46,8 +47,7 @@
    @PreAuthorize("@ss.hasPermi('system:template:export')")
    @Log(title = "任务问卷模板", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyTaskTemplate svyTaskTemplate)
    {
    public void export(HttpServletResponse response, SvyTaskTemplate svyTaskTemplate) {
        List<SvyTaskTemplate> list = svyTaskTemplateService.selectSvyTaskTemplateList(svyTaskTemplate);
        ExcelUtil<SvyTaskTemplate> util = new ExcelUtil<SvyTaskTemplate>(SvyTaskTemplate.class);
        util.exportExcel(response, list, "任务问卷模板数据");
@@ -58,8 +58,7 @@
     */
    @PreAuthorize("@ss.hasPermi('system:template:query')")
    @GetMapping(value = "/{svyid}")
    public AjaxResult getInfo(@PathVariable("svyid") Long svyid)
    {
    public AjaxResult getInfo(@PathVariable("svyid") Long svyid) {
        return success(svyTaskTemplateService.selectSvyTaskTemplateBySvyid(svyid));
    }

@@ -69,8 +68,7 @@
    @PreAuthorize("@ss.hasPermi('system:template:add')")
    @Log(title = "任务问卷模板", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyTaskTemplate svyTaskTemplate)
    {
    public AjaxResult add(@RequestBody SvyTaskTemplate svyTaskTemplate) {
        return toAjax(svyTaskTemplateService.insertSvyTaskTemplate(svyTaskTemplate));
    }

@@ -80,8 +78,7 @@
    @PreAuthorize("@ss.hasPermi('system:template:edit')")
    @Log(title = "任务问卷模板", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyTaskTemplate svyTaskTemplate)
    {
    public AjaxResult edit(@RequestBody SvyTaskTemplate svyTaskTemplate) {
        return toAjax(svyTaskTemplateService.updateSvyTaskTemplate(svyTaskTemplate));
    }

@@ -91,8 +88,31 @@
    @PreAuthorize("@ss.hasPermi('system:template:remove')")
    @Log(title = "任务问卷模板", businessType = BusinessType.DELETE)
    @DeleteMapping("/{svyids}")
    public AjaxResult remove(@PathVariable Long[] svyids)
    {
    public AjaxResult remove(@PathVariable Long[] svyids) {
        return toAjax(svyTaskTemplateService.deleteSvyTaskTemplateBySvyids(svyids));
    }

    /**
     * æ–°å¢žæˆ–修改随访任务问卷模板库
     */
    @PreAuthorize("@ss.hasPermi('system:template:add')")
    @ApiOperation("新增或修改随访任务问卷模板库")
    @PostMapping("/saveOrUpdateTaskTemp")
    public AjaxResult saveOrUpdateTaskTemp(@RequestBody SvyTaskTemplateVO svyTaskTemplateVO) {
        return AjaxResult.success(svyTaskTemplateService.saveOrUpdateTemplate(svyTaskTemplateVO));
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿è¯¦æƒ…根据条件
     *
     * @param svyTaskTemplateVO
     * @return
     */
    @PreAuthorize("@ss.hasPermi('system:template:add')")
    @ApiOperation("查询模板详情根据条件")
    @PostMapping("/selectInfoByCondition")
    public AjaxResult selectInfoByCondition(@RequestBody SvyTaskTemplateVO svyTaskTemplateVO) {
        return AjaxResult.success(svyTaskTemplateService.selectInfoByCondition(svyTaskTemplateVO));
    }

}

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

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

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

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

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“Controller
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@RestController
@RequestMapping("/smartor/svyTaskTempScript")
public class SvyTaskTemplateScriptController extends BaseController
{
    @Autowired
    private ISvyTaskTemplateScriptService svyTaskTemplateScriptService;

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:script:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyTaskTemplateScript svyTaskTemplateScript)
    {
        startPage();
        List<SvyTaskTemplateScript> list = svyTaskTemplateScriptService.selectSvyTaskTemplateScriptList(svyTaskTemplateScript);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:script:export')")
    @Log(title = "问卷任务模版问题话术库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyTaskTemplateScript svyTaskTemplateScript)
    {
        List<SvyTaskTemplateScript> list = svyTaskTemplateScriptService.selectSvyTaskTemplateScriptList(svyTaskTemplateScript);
        ExcelUtil<SvyTaskTemplateScript> util = new ExcelUtil<SvyTaskTemplateScript>(SvyTaskTemplateScript.class);
        util.exportExcel(response, list, "问卷任务模版问题话术库数据");
    }

    /**
     * èŽ·å–问卷任务模版问题话术库详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:script:query')")
    @GetMapping(value = "/{ID}")
    public AjaxResult getInfo(@PathVariable("ID") Long ID)
    {
        return success(svyTaskTemplateScriptService.selectSvyTaskTemplateScriptByID(ID));
    }

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('system:script:add')")
    @Log(title = "问卷任务模版问题话术库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyTaskTemplateScript svyTaskTemplateScript)
    {
        return toAjax(svyTaskTemplateScriptService.insertSvyTaskTemplateScript(svyTaskTemplateScript));
    }

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('system:script:edit')")
    @Log(title = "问卷任务模版问题话术库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyTaskTemplateScript svyTaskTemplateScript)
    {
        return toAjax(svyTaskTemplateScriptService.updateSvyTaskTemplateScript(svyTaskTemplateScript));
    }

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    @PreAuthorize("@ss.hasPermi('system:script:remove')")
    @Log(title = "问卷任务模版问题话术库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{IDs}")
    public AjaxResult remove(@PathVariable Long[] IDs)
    {
        return toAjax(svyTaskTemplateScriptService.deleteSvyTaskTemplateScriptByIDs(IDs));
    }
}

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

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

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

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

/**
 * é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“Controller
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@RestController
@RequestMapping("/smartor/svyTaskTargetOption")
public class SvyTaskTemplateTargetoptionController extends BaseController {
    @Autowired
    private ISvyTaskTemplateTargetoptionService svyTaskTemplateTargetoptionService;

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption) {
        startPage();
        List<SvyTaskTemplateTargetoption> list = svyTaskTemplateTargetoptionService.selectSvyTaskTemplateTargetoptionList(svyTaskTemplateTargetoption);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:export')")
    @Log(title = "问卷任务模板指标选项库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyTaskTemplateTargetoption svyTaskTemplateTargetoption) {
        List<SvyTaskTemplateTargetoption> list = svyTaskTemplateTargetoptionService.selectSvyTaskTemplateTargetoptionList(svyTaskTemplateTargetoption);
        ExcelUtil<SvyTaskTemplateTargetoption> util = new ExcelUtil<SvyTaskTemplateTargetoption>(SvyTaskTemplateTargetoption.class);
        util.exportExcel(response, list, "问卷任务模板指标选项库数据");
    }

    /**
     * èŽ·å–问卷任务模板指标选项库详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(svyTaskTemplateTargetoptionService.selectSvyTaskTemplateTargetoptionById(id));
    }

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:add')")
    @Log(title = "问卷任务模板指标选项库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyTaskTemplateTargetoption svyTaskTemplateTargetoption) {
        return toAjax(svyTaskTemplateTargetoptionService.insertSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption));
    }

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:edit')")
    @Log(title = "问卷任务模板指标选项库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyTaskTemplateTargetoption svyTaskTemplateTargetoption) {
        return toAjax(svyTaskTemplateTargetoptionService.updateSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption));
    }

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:targetoption:remove')")
    @Log(title = "问卷任务模板指标选项库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(svyTaskTemplateTargetoptionService.deleteSvyTaskTemplateTargetoptionByIds(ids));
    }
}

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

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

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

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

/**
 * é—®å·ç»“果记录详情Controller
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@RestController
@RequestMapping("/smartor/svytasksingledetail")
public class SvyTasksingledetailController extends BaseController
{
    @Autowired
    private ISvyTasksingledetailService svyTasksingledetailService;

    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情列表
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyTasksingledetail svyTasksingledetail)
    {
        startPage();
        List<SvyTasksingledetail> list = svyTasksingledetailService.selectSvyTasksingledetailList(svyTasksingledetail);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®å·ç»“果记录详情列表
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:export')")
    @Log(title = "问卷结果记录详情", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyTasksingledetail svyTasksingledetail)
    {
        List<SvyTasksingledetail> list = svyTasksingledetailService.selectSvyTasksingledetailList(svyTasksingledetail);
        ExcelUtil<SvyTasksingledetail> util = new ExcelUtil<SvyTasksingledetail>(SvyTasksingledetail.class);
        util.exportExcel(response, list, "问卷结果记录详情数据");
    }

    /**
     * èŽ·å–问卷结果记录详情详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:query')")
    @GetMapping(value = "/{calldetailid}")
    public AjaxResult getInfo(@PathVariable("calldetailid") String calldetailid)
    {
        return success(svyTasksingledetailService.selectSvyTasksingledetailByCalldetailid(calldetailid));
    }

    /**
     * æ–°å¢žé—®å·ç»“果记录详情
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:add')")
    @Log(title = "问卷结果记录详情", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyTasksingledetail svyTasksingledetail)
    {
        return toAjax(svyTasksingledetailService.insertSvyTasksingledetail(svyTasksingledetail));
    }

    /**
     * ä¿®æ”¹é—®å·ç»“果记录详情
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:edit')")
    @Log(title = "问卷结果记录详情", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyTasksingledetail svyTasksingledetail)
    {
        return toAjax(svyTasksingledetailService.updateSvyTasksingledetail(svyTasksingledetail));
    }

    /**
     * åˆ é™¤é—®å·ç»“果记录详情
     */
    @PreAuthorize("@ss.hasPermi('system:tasksingledetail:remove')")
    @Log(title = "问卷结果记录详情", businessType = BusinessType.DELETE)
    @DeleteMapping("/{calldetailids}")
    public AjaxResult remove(@PathVariable String[] calldetailids)
    {
        return toAjax(svyTasksingledetailService.deleteSvyTasksingledetailByCalldetailids(calldetailids));
    }
}

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

@@ -50,6 +50,13 @@
    private String orgid;

    /**
     * æ ‡ç­¾å
     */
    @ApiModelProperty(value = "标签名")
    @Excel(name = " æ ‡ç­¾å ")
    private String tagname;

    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty(value = "删除标记")

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

@@ -43,6 +43,13 @@
    private Long tagid;

    /**
     * æ ‡ç­¾å
     */
    @ApiModelProperty(value = "标签名")
    @Excel(name = " æ ‡ç­¾å ")
    private String tagname;

    /**
     * æœºæž„ID
     */
    @ApiModelProperty(value = "机构ID")

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

@@ -115,6 +115,13 @@
    private Long warndown;

    /**
     * é¡ºåºåºå·
     */
    @ApiModelProperty(value = "顺序序号")
    @Excel(name = "顺序序号")
    private Long orderno;

    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty(value = "删除标记")

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

@@ -123,13 +123,6 @@
    @ApiModelProperty("上传时间")
    private Date uploadTime;


    /**
     * svy_script题目表的主键ID
     */
    @ApiModelProperty("题目表的主键ID")
    private Long svyscriptId;

    /**
     * é¢˜ç›®å†…容
     */

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

@@ -23,7 +23,7 @@
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "自增ID")
    private Long optionid;
    private Long id;

    /**
     * é¢˜ç›®ID
@@ -72,7 +72,7 @@
     * æ˜¯å¦å¼‚常项目
     */
    @ApiModelProperty(value = "是否异常项目")
    private Long isexceptionitem;
    private Long isabnormal;

    /**
     * æ˜¯å¦è·Ÿè¿›
@@ -84,7 +84,7 @@
     * åˆ†æ•°
     */
    @ApiModelProperty(value = "分数")
    private Long score;
    private String score;

    /**
     * æç¤º

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

@@ -252,5 +252,49 @@
    @ApiModelProperty(value = "文本变量参数")
    private String param;

    /**
     * æ–‡æœ¬å˜é‡å‚æ•°
     */
    @Excel(name = "文本变量参数")
    @ApiModelProperty(value = "文本变量参数")
    private String textParam;

    /**
     * æš‚停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1
     */
    @Excel(name = "暂停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1")
    @ApiModelProperty(value = "暂停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1")
    private Long stopState = 0L;

    @ApiModelProperty(value = "上午时间")
    private String showTimeMorn;

    @ApiModelProperty(value = "中午时间")
    private String showTimeNoon;

    @ApiModelProperty(value = "晚午时间")
    private String showTimeNight;

    @ApiModelProperty(value = "展示日期")
    private String showDate;

    /**
     * ç±»åž‹åç§°
     */
    @Excel(name = "发送时间段")
    @ApiModelProperty(value = "发送时间段")
    private String sendTimeSlot;

    /**
     * æ¨¡æ¿åº“模版名称
     */
    @Excel(name = "模板库模版名称")
    private String libtemplatename;

    /**
     * æ¨¡æ¿åº“模版ID
     */
    @Excel(name = "模板库模版ID")
    private String libtemplateid;

}

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

@@ -41,6 +41,13 @@
    private String phone;

    /**
     * æ‚£è€…ID
     */
    @Excel(name = " æ‚£è€…ID ")
    @ApiModelProperty(value = "患者ID")
    private Long patid;

    /**
     * æ€§åˆ«
     */
    @Excel(name = "  æ€§åˆ«")

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

@@ -25,7 +25,7 @@
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "主键")
    private Long svyid;
    private Long id;

    /**
     * æ¨¡æ¿é—®å·ID

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

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

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“对象 svy_task_template_script
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Data
public class SvyTaskTemplateScript extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * ä¸»é”®ID
     */
    private Long ID;

    /**
     * ä»»åŠ¡id
     */
    @ApiModelProperty(value = "任务id")
    private Long taskid;

    /**
     * æ¨¡æ¿è¯æœ¯ç¼–号
     */
    @ApiModelProperty(value = "模板话术编号")
    private Long templateQuestionNum;

    /**
     * æ¨¡æ¿ID
     */
    @ApiModelProperty(value = "模板ID")
    private Long templateID;

    /**
     * è¯æœ¯ID
     */
    @ApiModelProperty(value = "话术ID")
    private Long scriptID;

    /**
     * æ ‡é¢˜
     */
    @ApiModelProperty(value = "标题")
    private String questiontitle;

    /**
     * è¯­è¨€
     */
    @ApiModelProperty(value = "语言")
    private String language;

    /**
     * ç±»åˆ«å
     */
    @ApiModelProperty(value = "类别名")
    private String categoryName;

    /**
     * é—®é¢˜ç‚¹
     */
    @ApiModelProperty(value = "问题点")
    private String questionPoint;

    /**
     * è¯æœ¯å†…容
     */
    @ApiModelProperty(value = "话术内容")
    private String questionText;

    /**
     * è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "话术语音")
    private String questionVoice;

    /**
     * æ— åŒ¹é…è¯æœ¯
     */
    @ApiModelProperty(value = "无匹配话术")
    private String noMatchText;

    /**
     * æ— åŒ¹é…è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "无匹配话术语音")
    private String noMatchVoice;

    /**
     * é™é»˜è¯æœ¯
     */
    @ApiModelProperty(value = "静默话术")
    private String slienceText;

    /**
     * é™é»˜è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "静默话术语音")
    private String slienceVoice;

    /**
     * é€šç”¨åº“匹配后话术
     */
    @ApiModelProperty(value = "通用库匹配后话术")
    private String submoduleText;

    /**
     * é€šç”¨åº“匹配后话术语音
     */
    @ApiModelProperty(value = "通用库匹配后话术语音")
    private String submoduleVoice;

    /**
     * å¬ä¸æ¸…话术
     */
    @ApiModelProperty(value = "听不清话术")
    private String noClearlyText;

    /**
     * å¬ä¸æ¸…话术语音
     */
    @ApiModelProperty(value = "听不清话术语音")
    private String noClearlyVoice;

    /**
     * æ˜¯å¦å¿…å¡«,1:必填    2：可以不填    ï¼ˆç»™äººå·¥ç”¨çš„，AI不用遵守）
     */
    @ApiModelProperty(value = "是否必填,1:必填    2：可以不填  ")
    private String isMust;

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

    /**
     * åªèƒ½æ’­æ”¾WAV类型
     */
    @ApiModelProperty(value = "只能播放WAV类型")
    private Long playWavOnly;

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

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

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

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

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

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

    /**
     * å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "值类型  1= é€‰é¡¹,2= æ–‡æœ¬,3= æ•°å€¼")
    private Long valueType;

    /**
     * æŒ‡æ ‡é€‰é¡¹*
     */
    @ApiModelProperty(value = "指标选项*")
    private String targetOptions;

    /**
     * åŸºç¡€æŒ‡æ ‡ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "基础指标类型1=选项,2=文本,3=数值")
    private String targettype;

    /**
     * åŸºç¡€æŒ‡æ ‡ID(暂时当序号id)
     */
    @ApiModelProperty(value = "基础指标ID(暂时当序号id)")
    private Long targetid;

    /**
     * åŸºç¡€æŒ‡æ ‡å€¼
     */
    @ApiModelProperty(value = "基础指标值")
    private String targetvalue;

    /**
     * ä¸‹ä¸€è¯æœ¯ç¼–号
     */
    @ApiModelProperty(value = "下一话术编号")
    private Long nextQuestion;

    /**
     * é—®é¢˜ç»“果（给“值类型”是文本或者数值用的）*
     */
    @ApiModelProperty(value = "问题结果")
    private String questionResult;

    /**
     * å˜é‡å‚数集合
     */
    @ApiModelProperty(value = "变量参数集合")
    private String otherdata;

    /**
     * é—®é¢˜å›¾ç‰‡è·¯å¾„
     */
    @ApiModelProperty(value = "问题图片路径")
    private String picturePath;

}

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

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

import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“对象 svy_task_template_script
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Data
public class SvyTaskTemplateScriptVO extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * ä¸»é”®ID
     */
    private Long ID;

    /**
     * ä»»åŠ¡id
     */
    @ApiModelProperty(value = "任务id")
    private Long taskid;

    /**
     * æ¨¡æ¿è¯æœ¯ç¼–号
     */
    @ApiModelProperty(value = "模板话术编号")
    private Long templateQuestionNum;

    /**
     * æ¨¡æ¿ID
     */
    @ApiModelProperty(value = "模板ID")
    private Long templateID;

    /**
     * è¯æœ¯ID
     */
    @ApiModelProperty(value = "话术ID")
    private Long scriptID;

    /**
     * æ ‡é¢˜
     */
    @ApiModelProperty(value = "标题")
    private String questiontitle;

    /**
     * è¯­è¨€
     */
    @ApiModelProperty(value = "语言")
    private String language;

    /**
     * ç±»åˆ«å
     */
    @ApiModelProperty(value = "类别名")
    private String categoryName;

    /**
     * é—®é¢˜ç‚¹
     */
    @ApiModelProperty(value = "问题点")
    private String questionPoint;

    /**
     * è¯æœ¯å†…容
     */
    @ApiModelProperty(value = "话术内容")
    private String questionText;

    /**
     * è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "话术语音")
    private String questionVoice;

    /**
     * æ— åŒ¹é…è¯æœ¯
     */
    @ApiModelProperty(value = "无匹配话术")
    private String noMatchText;

    /**
     * æ— åŒ¹é…è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "无匹配话术语音")
    private String noMatchVoice;

    /**
     * é™é»˜è¯æœ¯
     */
    @ApiModelProperty(value = "静默话术")
    private String slienceText;

    /**
     * é™é»˜è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "静默话术语音")
    private String slienceVoice;

    /**
     * é€šç”¨åº“匹配后话术
     */
    @ApiModelProperty(value = "通用库匹配后话术")
    private String submoduleText;

    /**
     * é€šç”¨åº“匹配后话术语音
     */
    @ApiModelProperty(value = "通用库匹配后话术语音")
    private String submoduleVoice;

    /**
     * å¬ä¸æ¸…话术
     */
    @ApiModelProperty(value = "听不清话术")
    private String noClearlyText;

    /**
     * å¬ä¸æ¸…话术语音
     */
    @ApiModelProperty(value = "听不清话术语音")
    private String noClearlyVoice;

    /**
     * æ˜¯å¦å¿…å¡«,1:必填    2：可以不填    ï¼ˆç»™äººå·¥ç”¨çš„，AI不用遵守）
     */
    @ApiModelProperty(value = "是否必填,1:必填    2：可以不填 ")
    private String isMust;

    /**
     * åªèƒ½æ’­æ”¾WAV类型
     */
    @ApiModelProperty(value = "只能播放WAV类型")
    private Long playWavOnly;

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

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

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

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

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

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

    /**
     * å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "值类型1=选项,2=文本,3=数值")
    private Long valueType;

    /**
     * æŒ‡æ ‡é€‰é¡¹*
     */
    @ApiModelProperty(value = "指标选项*")
    private String targetOptions;

    /**
     * åŸºç¡€æŒ‡æ ‡ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "基础指标类型 1=选项,2=文本,3=数值")
    private String targettype;

    /**
     * åŸºç¡€æŒ‡æ ‡ID(暂时当序号id)
     */
    @ApiModelProperty(value = "基础指标ID(暂时当序号id)")
    private Long targetid;

    /**
     * åŸºç¡€æŒ‡æ ‡å€¼
     */
    @ApiModelProperty(value = "基础指标值")
    private String targetvalue;

    /**
     * ä¸‹ä¸€è¯æœ¯ç¼–号
     */
    @ApiModelProperty(value = "下一话术编号")
    private Long nextQuestion;

    /**
     * é—®é¢˜ç»“果（给“值类型”是文本或者数值用的）*
     */
    @ApiModelProperty(value = "问题结果 ,给=“值类型”是文本或者数值用的")
    private String questionResult;

    /**
     * å˜é‡å‚数集合
     */
    @ApiModelProperty(value = "变量参数集合")
    private String otherdata;

    /**
     * é—®é¢˜å›¾ç‰‡è·¯å¾„
     */
    @ApiModelProperty(value = "问题图片路径")
    private String picturePath;

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

    /**
     * è¯æœ¯é€‰é¡¹
     */
    @ApiModelProperty(value = "话术选项")
    private List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = new ArrayList<>();
}

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

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

import java.util.Date;
import java.util.List;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“对象 svy_task_template_targetoption
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Data
public class SvyTaskTemplateTargetoption extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * ä¸»é”®
     */
    @ApiModelProperty(value = "主键")
    private Long id;

    /**
     * ä»»åŠ¡id
     */
    @ApiModelProperty(value = "任务id")
    private Long taskid;

    /**
     * æ¨¡æ¿ID
     */
    @ApiModelProperty(value = "模板ID")
    private Long templateID;

    /**
     * æŒ‡æ ‡ID
     */
    @ApiModelProperty(value = "指标ID")
    private Long targetid;

    /**
     * æŒ‡æ ‡åç§°
     */
    @ApiModelProperty(value = "指标名称")
    private String targetname;

    /**
     * æ¨¡æ¿æŒ‡æ ‡ç±»åž‹
     */
    @ApiModelProperty(value = "模板指标类型")
    private String targettype;

    /**
     * ç±»åˆ«åç§°
     */
    @ApiModelProperty(value = "类别名称")
    private String categoryName;

    /**
     * æ¨¡æ¿æŒ‡æ ‡å€¼
     */
    @ApiModelProperty(value = "模板指标值")
    private String targetvalue;

    /**
     * æ¨¡æ¿æŒ‡æ ‡æ­£åˆ™2
     */
    @ApiModelProperty(value = "模板指标正则2")
    private String targetregex2;

    /**
     * æ¨¡æ¿æŒ‡æ ‡æ­£åˆ™
     */
    @ApiModelProperty(value = "模板指标正则")
    private String targetregex;

    /**
     * é€‰é¡¹æè¿°
     */
    @ApiModelProperty(value = "选项描述")
    private String optiondesc;

    /**
     * è¯­è¨€
     */
    @ApiModelProperty(value = "语言")
    private String language;

    /**
     * ç‰ˆæœ¬
     */
    @ApiModelProperty(value = "版本")
    private String version;

    /**
     * åˆ†ç»„ID
     */
    @ApiModelProperty(value = "分组ID")
    private String groupid;

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

    /**
     * é¢„警阀值上限
     */
    @ApiModelProperty(value = "预警阀值上限")
    private Long warnup;

    /**
     * é¢„警阀值下限
     */
    @ApiModelProperty(value = "预警阀值下限")
    private Long warndown;

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

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

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

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

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

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

    /**
     * é—®é¢˜id
     */
    @ApiModelProperty(value = "问题id")
    private Long scriptid;

    /**
     * æ­£åˆ™å…³é”®å­—(含)
     */
    @ApiModelProperty(value = "正则关键字(含)集合")
    private List<String> nodynamiccruxs;

    /**
     * æ­£åˆ™å…³é”®å­—(不含)
     */
    @ApiModelProperty(value = "正则关键字(不含)集合")
    private List<String> dynamiccruxs;
    /**
     * æ­£åˆ™å…³é”®å­—(含)
     */
    @ApiModelProperty(value = "正则关键字(含)")
    private String nodynamiccruxsJson;

    /**
     * æ­£åˆ™å…³é”®å­—(不含)
     */
    @ApiModelProperty(value = "正则关键字(不含)")
    private String dynamiccruxsJson;

    /**
     * ä¸‹ä¸€é¢˜
     */
    @ApiModelProperty(value = "下一题")
    private Long nextQuestion;

    /**
     * é€‰é¡¹å›¾ç‰‡è·¯å¾„
     */
    @ApiModelProperty(value = "选项图片路径")
    private String picturePath;

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

}

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

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

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

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * éšè®¿ä»»åŠ¡éšè®¿æ¨¡æ¿åº“对象 ivr_task_template
 *
 * @author ruoyi
 * @date 2024-05-13
 */
@Data
@ApiModel(value = "IvrTaskTemplateVO", description = "任务任务随访模板库对象")
public class SvyTaskTemplateVO extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "主键")
    private Long id;

    /**
     * æ¨¡æ¿é—®å·ID
     */
    @Excel(name = " æ¨¡æ¿é—®å·ID ")
    @ApiModelProperty(value = "模板问卷ID")
    private Long templateid;

    /**
     * é—®å·åˆ†ç±»ID
     */
    @Excel(name = " é—®å·åˆ†ç±»ID ")
    @ApiModelProperty(value = "问卷分类ID")
    private Long categoryid;

    /**
     * é—®å·ä»£ç 
     */
    @Excel(name = " é—®å·ä»£ç  ")
    @ApiModelProperty(value = "问卷代码")
    private String svycode;

    /**
     * é—®å·åç§°
     */
    @Excel(name = " é—®å·åç§° ")
    @ApiModelProperty(value = "问卷名称")
    private String svyname;

    /**
     * æè¿°
     */
    @Excel(name = " æè¿° ")
    @ApiModelProperty(value = "描述")
    private String description;

    /**
     * é—®å·ä»‹ç»
     */
    @Excel(name = " é—®å·ä»‹ç» ")
    @ApiModelProperty(value = "问卷介绍")
    private String introduce;

    /**
     * é—®å·æç¤º
     */
    @Excel(name = " é—®å·æç¤º ")
    @ApiModelProperty(value = "问卷提示")
    private String submitprompt;

    /**
     * æ ‡ç­¾
     */
    @Excel(name = "标签")
    @ApiModelProperty(value = "标签")
    private String tag;

    /**
     * ç‰ˆæœ¬
     */
    @Excel(name = " ç‰ˆæœ¬ ")
    @ApiModelProperty(value = "版本")
    private BigDecimal version;

    /**
     * ä¸­å¿ƒåº“代码
     */
    @Excel(name = " ä¸­å¿ƒåº“代码 ")
    @ApiModelProperty(value = "中心库代码")
    private String centerlibrarycode;

    /**
     * ä¸­å¿ƒåº“ID
     */
    @Excel(name = " ä¸­å¿ƒåº“ID ")
    @ApiModelProperty(value = "中心库ID")
    private Long centerlibraryid;

    /**
     * æ˜¯å¦æœ¬åœ°
     */
    @Excel(name = " æ˜¯å¦æœ¬åœ° ")
    @ApiModelProperty(value = "是否本地")
    private Long islocal;

    /**
     * æ˜¯å¦å¯ç”¨
     */
    @Excel(name = " æ˜¯å¦å¯ç”¨ ")
    @ApiModelProperty(value = "是否启用")
    private String isenable;

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

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

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

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

    /**
     * é—®é¢˜id
     */
    @Excel(name = "问题id")
    @ApiModelProperty(value = "问题id")
    private String taskScriptId;

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

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

    /**
     * ç§‘室名称
     */
    @Excel(name = "科室名称")
    @ApiModelProperty(value = "科室名称")
    private String deptNames;

    /**
     * æ ‡ç­¾ä¿¡æ¯
     */
    @Excel(name = "标签信息")
    @ApiModelProperty(value = "标签信息")
    private String labelInfo;

    /**
     * é™¢åŒº
     */
    @Excel(name = "院区")
    @ApiModelProperty(value = "院区")
    private String campus;

    /**
     * é€‚用方式：调查表1，智能语音2、人工3
     */
    @Excel(name = "适用方式：调查表1，智能语音2、人工3")
    @ApiModelProperty(value = "适用方式：调查表1，智能语音2、人工3")
    private String suitway;

    /**
     * å…¶å®ƒæ•°æ®ï¼ˆå­˜å‚¨å˜é‡ï¼‰
     */
    @Excel(name = "其它数据", readConverterExp = "存=储变量")
    @ApiModelProperty(value = "其它数据（存储变量）")
    private String otherdata;

    /**
     * å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @Excel(name = "值类型", readConverterExp = "1=,选=项,2=,文=本,3=,数=值")
    @ApiModelProperty(value = " å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰")
    private String valueType;

    /**
     * å›žå¤ï¼ˆæŒ‡é—®é¢˜çš„回复，给问答题用的）
     */
    @Excel(name = "回复", readConverterExp = "指=问题的回复，给问答题用的")
    @ApiModelProperty(value = "回复（指问题的回复，给问答题用的）")
    private String reply;

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


    @ApiModelProperty(value = "模板问题集合")
    private List<SvyTaskTemplateScriptVO> svyTaskTemplateScriptVOS = new ArrayList<>();

}

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

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

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

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * ç»¼åˆé—®å·ä»»åŠ¡ï¼ˆä»»åŠ¡ï¼‰å¯¹è±¡ svy_task
 *
 * @author ruoyi
 * @date 2024-06-12
 */
@Data
public class SvyTaskVO extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     *
     */
    @ApiModelProperty(value = "任务ID")
    private Long taskid;

    /**
     * æ‚£è€…服务任务id
     */
    @Excel(name = "患者服务任务id")
    @ApiModelProperty(value = "患者服务任务id")
    private Long svrtaskid;

    /**
     *
     */
    @Excel(name = "  ")
    @ApiModelProperty(value = "任务名称")
    private String taskname;

    /**
     * æ¨¡æ¿ID
     */
    @Excel(name = "  æ¨¡æ¿ID")
    @ApiModelProperty(value = "模板ID")
    private String templateid;

    /**
     * æ¨¡æ¿åç§°
     */
    @Excel(name = "  æ¨¡æ¿åç§°")
    @ApiModelProperty(value = "模板名称")
    private String templatename;

    /**
     * æ ‡ç­¾ä¿¡æ¯
     */
    @Excel(name = "  æ ‡ç­¾ä¿¡æ¯")
    @ApiModelProperty(value = "标签信息")
    private String labelinfo;

    /**
     * çŠ¶æ€
     */
    @Excel(name = "  çŠ¶æ€")
    @ApiModelProperty(value = "状态")
    private Long state;

    /**
     * æ•°é‡
     */
    @Excel(name = "  æ•°é‡")
    @ApiModelProperty(value = "数量")
    private Long count;

    /**
     * æ‰§è¡Œ
     */
    @Excel(name = "  æ‰§è¡Œ")
    @ApiModelProperty(value = "执行")
    private Long executed;

    /**
     * ä¸æ‰§è¡Œ
     */
    @Excel(name = "  ä¸æ‰§è¡Œ")
    @ApiModelProperty(value = "不执行")
    private Long unexecuted;

    /**
     * æ˜¯å¦å¤±è´¥
     */
    @Excel(name = "  æ˜¯å¦å¤±è´¥")
    @ApiModelProperty(value = "是否失败")
    private Long fail;

    /**
     * æ‚£è€…ID
     */
    @Excel(name = "  æ‚£è€…ID")
    @ApiModelProperty(value = "患者ID")
    private String patientid;

    /**
     * æ‚£è€…名称
     */
    @Excel(name = "  æ‚£è€…名称")
    @ApiModelProperty(value = "患者名称")
    private String patientname;

    /**
     *
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "  ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "新增时间")
    private Date addtime;

    /**
     * å®¡æ ¸äººid
     */
    @Excel(name = "  å®¡æ ¸äººid")
    @ApiModelProperty(value = "审核人id")
    private String checkuserid;

    /**
     * æ–‡æœ¬å˜é‡å‚æ•°
     */
    @Excel(name = "文本变量参数")
    @ApiModelProperty(value = "文本变量参数")
    private Map<String, Map<String, String>> textParamMap;

    /**
     * å®¡æ ¸äºº
     */
    @Excel(name = "  å®¡æ ¸äºº")
    @ApiModelProperty(value = "审核人")
    private String checkusername;

    /**
     *
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "  ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "审核时间")
    private Date checktime;

    /**
     * 1，出院随访；2，体检通知；3，满意度调查；4，宣教；
     */
    @Excel(name = " 1，出院随访；2，体检通知；3，满意度调查；4，宣教； ")
    @ApiModelProperty(value = "出院随访；2，体检通知；3，满意度调查；4，宣教；")
    private String type;

    /**
     * ç±»åž‹åç§°
     */
    @Excel(name = "  ç±»åž‹åç§°")
    @ApiModelProperty(value = "类型名称")
    private String typename;

    /**
     * 0.不使用播前短信 1.使用播前短信
     */
    @Excel(name = " 0.不使用播前短信 1.使用播前短信 ")
    @ApiModelProperty(value = "0.不使用播前短信 1.使用播前短信")
    private Long usebqsms;

    /**
     * 0.不使用播后短信 1.使用播前短信
     */
    @Excel(name = " 0.不使用播后短信 1.使用播前短信 ")
    @ApiModelProperty(value = " 0.不使用播后短信 1.使用播前短信")
    private Long usebhsms;

    /**
     *
     */
    @Excel(name = "  ")
    @ApiModelProperty(value = "")
    private Long usesendsms;

    /**
     * éƒ¨é—¨code
     */
    @Excel(name = "  éƒ¨é—¨code")
    @ApiModelProperty(value = "部门code")
    private String deptcode;

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

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

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

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

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

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

    /**
     * ä»»åŠ¡å½¢å¼ 1,多媒体   2,纸质  3,电话  4,短信  5.微信公众号 6.微信小程序  7.支付宝  8.智能小程序  9.钉钉
     */
    @Excel(name = " ä»»åŠ¡å½¢å¼ 1,多媒体   2,纸质  3,电话  4,短信  5.微信公众号 6.微信小程序  7.支付宝  8.智能小程序  9.钉钉")
    @ApiModelProperty(value = "任务形式 1,多媒体   2,纸质  3,电话  4,短信  5.微信公众号 6.微信小程序  7.支付宝  8.智能小程序  9.钉钉")
    private String preachform;

    /**
     * æ˜¯å¦å‘送 ï¼š 0 æš‚停发送  1 å®šæ—¶å‘送  2 ç«‹å³å‘送
     */
    @Excel(name = "是否发送 ï¼š 0 æš‚停发送  1 å®šæ—¶å‘送  2 ç«‹å³å‘送  ")
    @ApiModelProperty(value = "是否发送 ï¼š 0 æš‚停发送  1 å®šæ—¶å‘送  2 ç«‹å³å‘送")
    private Long isSend;

    /**
     * å‘送状态：  0  å¤±è´¥   1成功
     */
    @Excel(name = "发送状态：  0  å¤±è´¥   1成功")
    @ApiModelProperty(value = "发送状态：  0  å¤±è´¥   1成功")
    private String sendState;

    /**
     * æ–‡æœ¬å˜é‡å‚æ•°
     */
    @Excel(name = "文本变量参数")
    @ApiModelProperty(value = "文本变量参数")
    private String param;

    /**
     * æ‚£è€…与单一任务关联表集合
     */
    @Excel(name = " å®£æ‚£è€…与单一任务关联表集合")
    @ApiModelProperty(value = "患者与单一任务关联表集合")
    private List<PatTaskRelevance> patTaskRelevances;

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

    /**
     * æ–‡æœ¬å˜é‡å‚æ•°
     */
    @Excel(name = "文本变量参数")
    @ApiModelProperty(value = "文本变量参数")
    private String textParam;

    /**
     * æš‚停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1
     */
    @Excel(name = "暂停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1")
    @ApiModelProperty(value = "暂停状态 ï¼š çŠ¶æ€å¦‚果发生修改，值就加1")
    private Long stopState = 0L;

    @ApiModelProperty(value = "上午时间")
    private String showTimeMorn;

    @ApiModelProperty(value = "中午时间")
    private String showTimeNoon;

    @ApiModelProperty(value = "晚午时间")
    private String showTimeNight;

    @ApiModelProperty(value = "展示日期")
    private String showDate;

    /**
     * å‘送时间段
     */
    @ApiModelProperty(value = "发送时间段 ")
    private List<TaskSendTimeVO> sendTimeSlot;

    /**
     * æ¨¡æ¿åº“模版名称
     */
    @Excel(name = "模板库模版名称")
    private String libtemplatename;

    /**
     * æ¨¡æ¿åº“模版ID
     */
    @Excel(name = "模板库模版ID")
    private String libtemplateid;
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,576 @@
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;

/**
 * é—®å·ç»“果记录详情对象 svy_tasksingledetail
 *
 * @author ruoyi
 * @date 2024-06-19
 */
public class SvyTasksingledetail extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä»»åŠ¡ç”µè¯ID */
    private String calldetailid;

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

    /** æ‹¨å·uuid */
    @Excel(name = "拨号uuid")
    private String uuid;

    /** ç”µè¯å·ç  */
    @Excel(name = "电话号码")
    private String phone;

    /** æ˜¾ç¤ºå·ç  */
    @Excel(name = "显示号码")
    private String displayno;

    /** æ“ä½œäºº  */
    @Excel(name = "操作人 ")
    private String operate;

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

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

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

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

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

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

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

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

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

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

    /** å›žç­”结果 */
    @Excel(name = "回答结果")
    private String asrtext;

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

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

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

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

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

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

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

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

    /** é—®é¢˜æ–‡æœ¬   */
    @Excel(name = "问题文本  ")
    private String questiontext;

    /** é—®é¢˜è¯­éŸ³   */
    @Excel(name = "问题语音  ")
    private String questionvoice;

    /** ç±»åˆ« */
    @Excel(name = "类别")
    private String categoryname;

    /** æŒ‡æ ‡é€‰é¡¹ */
    @Excel(name = "指标选项")
    private String targetoptions;

    /** æŒ‡æ ‡å€¼ï¼ˆæ­£åˆ™åŒ¹é…çš„选项值） */
    @Excel(name = "指标值", readConverterExp = "æ­£=则匹配的选项值")
    private String targetvalue;

    /** é€šè¿‡æ­£åˆ™è§£æžçš„值 */
    @Excel(name = "通过正则解析的值")
    private String matchedtext;

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

    /** ä¸Šä¼ æ ‡è®° */
    @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;

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

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

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

    /** é—®é¢˜ç±»åž‹ */
    @Excel(name = "问题类型")
    private String valueType;

    public void setCalldetailid(String calldetailid)
    {
        this.calldetailid = calldetailid;
    }

    public String getCalldetailid()
    {
        return calldetailid;
    }
    public void setCallid(String callid)
    {
        this.callid = callid;
    }

    public String getCallid()
    {
        return callid;
    }
    public void setUuid(String uuid)
    {
        this.uuid = uuid;
    }

    public String getUuid()
    {
        return uuid;
    }
    public void setPhone(String phone)
    {
        this.phone = phone;
    }

    public String getPhone()
    {
        return phone;
    }
    public void setDisplayno(String displayno)
    {
        this.displayno = displayno;
    }

    public String getDisplayno()
    {
        return displayno;
    }
    public void setOperate(String operate)
    {
        this.operate = operate;
    }

    public String getOperate()
    {
        return operate;
    }
    public void setInbound(Long inbound)
    {
        this.inbound = inbound;
    }

    public Long getInbound()
    {
        return inbound;
    }
    public void setIncoming(Long incoming)
    {
        this.incoming = incoming;
    }

    public Long getIncoming()
    {
        return incoming;
    }
    public void setAssigntime(Long assigntime)
    {
        this.assigntime = assigntime;
    }

    public Long getAssigntime()
    {
        return assigntime;
    }
    public void setStarttime(Long starttime)
    {
        this.starttime = starttime;
    }

    public Long getStarttime()
    {
        return starttime;
    }
    public void setAnswertime(Long answertime)
    {
        this.answertime = answertime;
    }

    public Long getAnswertime()
    {
        return answertime;
    }
    public void setSilent(Long silent)
    {
        this.silent = silent;
    }

    public Long getSilent()
    {
        return silent;
    }
    public void setDtmfKey(String dtmfKey)
    {
        this.dtmfKey = dtmfKey;
    }

    public String getDtmfKey()
    {
        return dtmfKey;
    }
    public void setMusicpath(String musicpath)
    {
        this.musicpath = musicpath;
    }

    public String getMusicpath()
    {
        return musicpath;
    }
    public void setSentIndex(Long sentIndex)
    {
        this.sentIndex = sentIndex;
    }

    public Long getSentIndex()
    {
        return sentIndex;
    }
    public void setSentBegin(Long sentBegin)
    {
        this.sentBegin = sentBegin;
    }

    public Long getSentBegin()
    {
        return sentBegin;
    }
    public void setAsrtext(String asrtext)
    {
        this.asrtext = asrtext;
    }

    public String getAsrtext()
    {
        return asrtext;
    }
    public void setBeginTime(Long beginTime)
    {
        this.beginTime = beginTime;
    }

    public Long getBeginTime()
    {
        return beginTime;
    }
    public void setEndTime(Long endTime)
    {
        this.endTime = endTime;
    }

    public Long getEndTime()
    {
        return endTime;
    }
    public void setSentEnd(Long sentEnd)
    {
        this.sentEnd = sentEnd;
    }

    public Long getSentEnd()
    {
        return sentEnd;
    }
    public void setRecordpath(String recordpath)
    {
        this.recordpath = recordpath;
    }

    public String getRecordpath()
    {
        return recordpath;
    }
    public void setRecordurl(String recordurl)
    {
        this.recordurl = recordurl;
    }

    public String getRecordurl()
    {
        return recordurl;
    }
    public void setTemplateid(String templateid)
    {
        this.templateid = templateid;
    }

    public String getTemplateid()
    {
        return templateid;
    }
    public void setTemplatequestionnum(Long templatequestionnum)
    {
        this.templatequestionnum = templatequestionnum;
    }

    public Long getTemplatequestionnum()
    {
        return templatequestionnum;
    }
    public void setSwitchid(Long switchid)
    {
        this.switchid = switchid;
    }

    public Long getSwitchid()
    {
        return switchid;
    }
    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 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 setTargetvalue(String targetvalue)
    {
        this.targetvalue = targetvalue;
    }

    public String getTargetvalue()
    {
        return targetvalue;
    }
    public void setMatchedtext(String matchedtext)
    {
        this.matchedtext = matchedtext;
    }

    public String getMatchedtext()
    {
        return matchedtext;
    }
    public void setAddtime(Date addtime)
    {
        this.addtime = addtime;
    }

    public Date getAddtime()
    {
        return addtime;
    }
    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;
    }
    public void setDelFlag(String delFlag)
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag()
    {
        return delFlag;
    }
    public void setPid(Long pid)
    {
        this.pid = pid;
    }

    public Long getPid()
    {
        return pid;
    }
    public void setGuid(String guid)
    {
        this.guid = guid;
    }

    public String getGuid()
    {
        return guid;
    }
    public void setValueType(String valueType)
    {
        this.valueType = valueType;
    }

    public String getValueType()
    {
        return valueType;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("calldetailid", getCalldetailid())
            .append("callid", getCallid())
            .append("uuid", getUuid())
            .append("phone", getPhone())
            .append("displayno", getDisplayno())
            .append("operate", getOperate())
            .append("inbound", getInbound())
            .append("incoming", getIncoming())
            .append("assigntime", getAssigntime())
            .append("starttime", getStarttime())
            .append("answertime", getAnswertime())
            .append("silent", getSilent())
            .append("dtmfKey", getDtmfKey())
            .append("musicpath", getMusicpath())
            .append("sentIndex", getSentIndex())
            .append("sentBegin", getSentBegin())
            .append("asrtext", getAsrtext())
            .append("beginTime", getBeginTime())
            .append("endTime", getEndTime())
            .append("sentEnd", getSentEnd())
            .append("recordpath", getRecordpath())
            .append("recordurl", getRecordurl())
            .append("templateid", getTemplateid())
            .append("templatequestionnum", getTemplatequestionnum())
            .append("switchid", getSwitchid())
            .append("questiontext", getQuestiontext())
            .append("questionvoice", getQuestionvoice())
            .append("categoryname", getCategoryname())
            .append("targetoptions", getTargetoptions())
            .append("targetvalue", getTargetvalue())
            .append("matchedtext", getMatchedtext())
            .append("addtime", getAddtime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("orgid", getOrgid())
            .append("createTime", getCreateTime())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("pid", getPid())
            .append("guid", getGuid())
            .append("valueType", getValueType())
            .toString();
    }
}

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

@@ -2,6 +2,7 @@

import com.smartor.domain.SvyTaskSingle;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@@ -60,4 +61,6 @@
     * @return ç»“æžœ
     */
    public int deleteSvyTaskSingleByIds(Long[] ids);

    public int deleteSvyTaskcallByCondition(@Param("taskid") Long id, @Param("patid") Long patid);
}

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

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

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

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“Mapper接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Mapper
public interface SvyTaskTemplateScriptMapper
{
    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    public SvyTaskTemplateScript selectSvyTaskTemplateScriptByID(Long ID);

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“列表
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“集合
     */
    public List<SvyTaskTemplateScript> selectSvyTaskTemplateScriptList(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int insertSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int updateSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateScriptByID(Long ID);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param IDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateScriptByIDs(Long[] IDs);
}

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

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

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

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“Mapper接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Mapper
public interface SvyTaskTemplateTargetoptionMapper
{
    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    public SvyTaskTemplateTargetoption selectSvyTaskTemplateTargetoptionById(Long id);

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“集合
     */
    public List<SvyTaskTemplateTargetoption> selectSvyTaskTemplateTargetoptionList(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int insertSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int updateSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateTargetoptionById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateTargetoptionByIds(Long[] ids);
}

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

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

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

import java.util.List;

/**
 * é—®å·ç»“果记录详情Mapper接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Mapper
public interface SvyTasksingledetailMapper {
    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return é—®å·ç»“果记录详情
     */
    public SvyTasksingledetail selectSvyTasksingledetailByCalldetailid(String calldetailid);

    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情列表
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return é—®å·ç»“果记录详情集合
     */
    public List<SvyTasksingledetail> selectSvyTasksingledetailList(SvyTasksingledetail svyTasksingledetail);

    /**
     * æ–°å¢žé—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    public int insertSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail);

    /**
     * ä¿®æ”¹é—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    public int updateSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail);

    /**
     * åˆ é™¤é—®å·ç»“果记录详情
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return ç»“æžœ
     */
    public int deleteSvyTasksingledetailByCalldetailid(String calldetailid);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ç»“果记录详情
     *
     * @param calldetailids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTasksingledetailByCalldetailids(String[] calldetailids);
}

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

@@ -1,6 +1,7 @@
package com.smartor.service;

import com.smartor.domain.SvyTaskSingle;
import com.smartor.domain.SvyTaskVO;

import java.util.List;

@@ -59,4 +60,9 @@
     * @return ç»“æžœ
     */
    public int deleteSvyTaskSingleById(Long id);

    /**
     * æ–°å¢žæˆ–修改删除问卷任务
     */
    public int insertOrUpdateSvyTask(SvyTaskVO svyTaskVO);
}

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

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

import com.smartor.domain.SvyTaskTemplateScript;

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“Service接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
public interface ISvyTaskTemplateScriptService
{
    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    public SvyTaskTemplateScript selectSvyTaskTemplateScriptByID(Long ID);

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“列表
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“集合
     */
    public List<SvyTaskTemplateScript> selectSvyTaskTemplateScriptList(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int insertSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    public int updateSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param IDs éœ€è¦åˆ é™¤çš„问卷任务模版问题话术库主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateScriptByIDs(Long[] IDs);

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“信息
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateScriptByID(Long ID);
}

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

@@ -1,6 +1,8 @@
package com.smartor.service;

import com.smartor.domain.IvrLibaTemplateVO;
import com.smartor.domain.SvyTaskTemplate;
import com.smartor.domain.SvyTaskTemplateVO;

import java.util.List;

@@ -10,8 +12,7 @@
 * @author ruoyi
 * @date 2024-06-12
 */
public interface ISvyTaskTemplateService
{
public interface ISvyTaskTemplateService {
    /**
     * æŸ¥è¯¢ä»»åŠ¡é—®å·æ¨¡æ¿
     *
@@ -59,4 +60,14 @@
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateBySvyid(Long svyid);

    /**
     * æ–°å¢žæˆ–修改问题详情
     */
    public Integer saveOrUpdateTemplate(SvyTaskTemplateVO svyTaskTemplateVO);

    /**
     * æŸ¥è¯¢æ¨¡æ¿è¯¦æƒ…根据条件
     */
    public SvyTaskTemplateVO selectInfoByCondition(SvyTaskTemplateVO svyTaskTemplateVO);
}

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

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

import com.smartor.domain.SvyTaskTemplateTargetoption;

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“Service接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
public interface ISvyTaskTemplateTargetoptionService
{
    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    public SvyTaskTemplateTargetoption selectSvyTaskTemplateTargetoptionById(Long id);

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“集合
     */
    public List<SvyTaskTemplateTargetoption> selectSvyTaskTemplateTargetoptionList(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int insertSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int updateSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问卷任务模板指标选项库主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateTargetoptionByIds(Long[] ids);

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“信息
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyTaskTemplateTargetoptionById(Long id);
}

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

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

import com.smartor.domain.SvyTasksingledetail;

import java.util.List;

/**
 * é—®å·ç»“果记录详情Service接口
 *
 * @author ruoyi
 * @date 2024-06-19
 */
public interface ISvyTasksingledetailService
{
    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return é—®å·ç»“果记录详情
     */
    public SvyTasksingledetail selectSvyTasksingledetailByCalldetailid(String calldetailid);

    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情列表
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return é—®å·ç»“果记录详情集合
     */
    public List<SvyTasksingledetail> selectSvyTasksingledetailList(SvyTasksingledetail svyTasksingledetail);

    /**
     * æ–°å¢žé—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    public int insertSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail);

    /**
     * ä¿®æ”¹é—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    public int updateSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ç»“果记录详情
     *
     * @param calldetailids éœ€è¦åˆ é™¤çš„问卷结果记录详情主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyTasksingledetailByCalldetailids(String[] calldetailids);

    /**
     * åˆ é™¤é—®å·ç»“果记录详情信息
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return ç»“æžœ
     */
    public int deleteSvyTasksingledetailByCalldetailid(String calldetailid);
}

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

@@ -53,28 +53,26 @@
     */
    @Override
    public List<SvyLibScript> selectSvyLibScriptList(SvyLibScript svyLibTopic) {
        //添加题目

        List<SvyLibScript> svyLibTopics = svyLibTopicMapper.selectSvyLibScriptList(svyLibTopic);
        List<SvyLibScript> svyLibScripts = svyLibTopicMapper.selectSvyLibScriptList(svyLibTopic);
        //获取题目选项

        for (int j = 0; j < svyLibTopics.size(); j++) {
            log.info("问题id为：{}", svyLibTopics.get(j).getSvyscriptId());
            if (StringUtils.isNotEmpty(svyLibTopics.get(j).getIcd10Name()))
                svyLibTopics.get(j).setIcd10NameList(JSONArray.parseArray(svyLibTopics.get(j).getIcd10Name(), String.class));
        for (int j = 0; j < svyLibScripts.size(); j++) {
            log.info("问题id为：{}", svyLibScripts.get(j).getId());
            if (StringUtils.isNotEmpty(svyLibScripts.get(j).getIcd10Name()))
                svyLibScripts.get(j).setIcd10NameList(JSONArray.parseArray(svyLibScripts.get(j).getIcd10Name(), String.class));

            if (StringUtils.isNotEmpty(svyLibTopics.get(j).getScripttype()) && svyLibTopics.get(j).getScripttype().equals("3") || svyLibTopics.get(j).getId() == null) {
            if (StringUtils.isNotEmpty(svyLibScripts.get(j).getScripttype()) && svyLibScripts.get(j).getScripttype().equals("3") || svyLibScripts.get(j).getId() == null) {
                //作答题，不需要选项
                continue;
            } else {
                SvyLibScriptOption svyLibTopicoption = new SvyLibScriptOption();
                svyLibTopicoption.setTopicid(svyLibTopics.get(j).getId());
                svyLibTopicoption.setTopicid(svyLibScripts.get(j).getId());
                List<SvyLibScriptOption> svyLibTopicoptions = svyLibScriptOptionMapper.selectSvyLibScriptOptionList(svyLibTopicoption);
                //将查询出的选项目放到题目中
                svyLibTopics.get(j).setSvyLibScriptOptions(svyLibTopicoptions);
                svyLibScripts.get(j).setSvyLibScriptOptions(svyLibTopicoptions);
            }
        }
        return svyLibTopics;
        return svyLibScripts;
    }

    /**
@@ -122,7 +120,7 @@
                    svyLibScriptOptionMapper.updateSvyLibScriptOption(svyLibTopicoption);
                } else if (svyLibTopicoption.getIsoperation() != null && svyLibTopicoption.getIsoperation() == 3) {
                    //删除
                    svyLibScriptOptionMapper.deleteSvyLibScriptOptionByOptionid(svyLibTopicoption.getOptionid());
                    svyLibScriptOptionMapper.deleteSvyLibScriptOptionByOptionid(svyLibTopicoption.getId());
                }
            }
        }

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

@@ -153,6 +153,10 @@
            //修改
            svyLibTemplate.setUpdateTime(DateUtils.getNowDate());
            i = svyLibTemplateMapper.updateSvyLibTemplate(svyLibTemplate);
        } else if (svyLibTemplate.getIsoperation() != null && svyLibTemplate.getIsoperation() == 3) {
            //删除
            i = svyLibTemplateMapper.deleteSvyLibTemplateBySvyid(svyLibTemplate.getSvyid());

        }

        //处理题目
@@ -170,6 +174,8 @@
                    //修改
                    svyLibTemplateScript.setSvyid(svyLibTemplate.getSvyid());
                    svyLibTemplateScriptMapper.updateSvyLibTemplateScript(svyLibTemplateScript);
                } else if (svyLibScript.getIsoperation() != null && svyLibScript.getIsoperation() == 3) {
                    svyLibTemplateScriptMapper.deleteSvyLibTemplateScriptByTopicid(svyLibTemplateScript.getId());
                }

                //对题目选项进行处理
@@ -183,6 +189,9 @@
                            //修改
                            svyLibTemplateTargetoption.setScriptid(svyLibScript.getId());
                            svyLibTemplateTargetoptionMapper.updateSvyLibTemplateTargetoption(svyLibTemplateTargetoption);
                        } else if (svyLibTemplateTargetoption.getIsoperation() != null && svyLibTemplateTargetoption.getIsoperation() == 3) {
                            //删除
                            svyLibTemplateTargetoptionMapper.deleteSvyLibTemplateTargetoptionById(svyLibTemplateTargetoption.getId());
                        }
                    }


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

@@ -1,9 +1,20 @@
package com.smartor.service.impl;

import com.alibaba.fastjson2.JSON;
import com.google.gson.Gson;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.DtoConversionUtils;
import com.smartor.domain.PatTaskRelevance;
import com.smartor.domain.SvyTask;
import com.smartor.domain.SvyTaskSingle;
import com.smartor.domain.SvyTaskVO;
import com.smartor.mapper.SvyTaskSingleMapper;
import com.smartor.service.ISvyTaskService;
import com.smartor.service.ISvyTaskSingleService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.lang3.ObjectUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -15,11 +26,14 @@
 * @author ruoyi
 * @date 2024-06-12
 */
@Slf4j
@Service
public class SvyTaskSingleServiceImpl implements ISvyTaskSingleService
{
public class SvyTaskSingleServiceImpl implements ISvyTaskSingleService {
    @Autowired
    private SvyTaskSingleMapper svyTaskSingleMapper;

    @Autowired
    private ISvyTaskService svyTaskService;

    /**
     * æŸ¥è¯¢å•ä¸€ä»»åŠ¡ï¼ˆé—®å·ï¼‰
@@ -28,8 +42,7 @@
     * @return å•ä¸€ä»»åŠ¡ï¼ˆé—®å·ï¼‰
     */
    @Override
    public SvyTaskSingle selectSvyTaskSingleById(Long id)
    {
    public SvyTaskSingle selectSvyTaskSingleById(Long id) {
        return svyTaskSingleMapper.selectSvyTaskSingleById(id);
    }

@@ -40,8 +53,7 @@
     * @return å•ä¸€ä»»åŠ¡ï¼ˆé—®å·ï¼‰
     */
    @Override
    public List<SvyTaskSingle> selectSvyTaskSingleList(SvyTaskSingle svyTaskSingle)
    {
    public List<SvyTaskSingle> selectSvyTaskSingleList(SvyTaskSingle svyTaskSingle) {
        return svyTaskSingleMapper.selectSvyTaskSingleList(svyTaskSingle);
    }

@@ -52,8 +64,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyTaskSingle(SvyTaskSingle svyTaskSingle)
    {
    public int insertSvyTaskSingle(SvyTaskSingle svyTaskSingle) {
        svyTaskSingle.setCreateTime(DateUtils.getNowDate());
        return svyTaskSingleMapper.insertSvyTaskSingle(svyTaskSingle);
    }
@@ -65,8 +76,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyTaskSingle(SvyTaskSingle svyTaskSingle)
    {
    public int updateSvyTaskSingle(SvyTaskSingle svyTaskSingle) {
        svyTaskSingle.setUpdateTime(DateUtils.getNowDate());
        return svyTaskSingleMapper.updateSvyTaskSingle(svyTaskSingle);
    }
@@ -78,8 +88,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskSingleByIds(Long[] ids)
    {
    public int deleteSvyTaskSingleByIds(Long[] ids) {
        return svyTaskSingleMapper.deleteSvyTaskSingleByIds(ids);
    }

@@ -90,8 +99,84 @@
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskSingleById(Long id)
    {
    public int deleteSvyTaskSingleById(Long id) {
        return svyTaskSingleMapper.deleteSvyTaskSingleById(id);
    }

    @Override
    public int insertOrUpdateSvyTask(SvyTaskVO svyTaskVO) {
        if (ObjectUtils.isEmpty(svyTaskVO)) {
            log.info("问卷任务入参为空，请检查入参");
            throw new BaseException("问卷任务入参为空，请检查入参");
        }
        Integer integer = 1;
        SvyTask svyTask = DtoConversionUtils.sourceToTarget(svyTaskVO, SvyTask.class);
        svyTask.setTextParam(JSON.toJSONString(svyTaskVO.getTextParamMap()));
        if (svyTaskVO.getIsoperation() != null && svyTaskVO.getIsoperation() == 1) {
            //往任务表中，新增任务
            if (ObjectUtils.isNotEmpty(svyTaskVO.getSendTimeSlot()))
                svyTask.setSendTimeSlot(JSON.toJSONString(svyTaskVO.getSendTimeSlot()));
            if (svyTask.getSendState() == null) svyTask.setSendState("1");
            svyTask.setTemplateid(svyTaskVO.getLibtemplateid());
            svyTaskService.insertSvyTask(svyTask);

            //将任务信息放到服务表中
            SvyTaskSingle svyTaskSingle = DtoConversionUtils.sourceToTarget(svyTaskVO, SvyTaskSingle.class);
            svyTaskSingle.setTaskid(svyTask.getTaskid());
            //新增
            if (CollectionUtils.isNotEmpty(svyTaskVO.getPatTaskRelevances())) {
                for (PatTaskRelevance patTaskRelevance : svyTaskVO.getPatTaskRelevances()) {
                    //将任务信息新增到随访服务表中
                    svyTaskSingle.setSendname(patTaskRelevance.getName());
                    svyTaskSingle.setAge(patTaskRelevance.getAge());
                    svyTaskSingle.setSfzh(patTaskRelevance.getSfzh());
                    svyTaskSingle.setPhone(patTaskRelevance.getPhone());
                    svyTaskSingle.setAddr(patTaskRelevance.getAddr());
                    svyTaskSingle.setPatid(patTaskRelevance.getPatid());
                    svyTaskSingle.setCreateTime(DateUtils.getNowDate());
                    svyTaskSingle.setCreateTime(DateUtils.getNowDate());
                    svyTaskSingleMapper.insertSvyTaskSingle(svyTaskSingle);
                    integer = svyTaskSingle.getId().intValue();
                }
            }

        } else if (svyTaskVO.getIsoperation() != null && svyTaskVO.getIsoperation() == 2) {
            //任务修改
            if (ObjectUtils.isNotEmpty(svyTaskVO.getSendTimeSlot()))
                svyTask.setSendTimeSlot(JSON.toJSONString(svyTaskVO.getSendTimeSlot()));
            //修改操作，需要将stopState状态+1
            SvyTask svyTask1 = svyTaskService.selectSvyTaskByTaskid(svyTaskVO.getTaskid());
            svyTask.setStopState(svyTask1.getStopState() + 1);
            svyTask.setTemplateid(svyTaskVO.getLibtemplateid());
            svyTaskService.updateSvyTask(svyTask);

            if (CollectionUtils.isNotEmpty(svyTaskVO.getPatTaskRelevances())) {
                for (PatTaskRelevance patTaskRelevance : svyTaskVO.getPatTaskRelevances()) {

                    SvyTaskSingle svyTaskSingle = DtoConversionUtils.sourceToTarget(svyTaskVO, SvyTaskSingle.class);
                    svyTaskSingle.setSendname(patTaskRelevance.getName());
                    svyTaskSingle.setAge(patTaskRelevance.getAge());
                    svyTaskSingle.setSfzh(patTaskRelevance.getSfzh());
                    svyTaskSingle.setPhone(patTaskRelevance.getPhone());
                    svyTaskSingle.setAddr(patTaskRelevance.getAddr());
                    svyTaskSingle.setPatid(patTaskRelevance.getPatid());
                    svyTaskSingle.setCreateTime(DateUtils.getNowDate());
                    svyTaskSingle.setTextParam(new Gson().toJson(svyTaskVO.getTextParamMap()));
                    if (patTaskRelevance.getIsoperation() != null) {
                        if (patTaskRelevance.getIsoperation() == 2)
                            svyTaskSingleMapper.updateSvyTaskSingle(svyTaskSingle);
                        if (patTaskRelevance.getIsoperation() == 1)
                            svyTaskSingleMapper.insertSvyTaskSingle(svyTaskSingle);
                        if (patTaskRelevance.getIsoperation() == 3)
                            //  é€šè¿‡taskid和patid去删除该条数据
                            svyTaskSingleMapper.deleteSvyTaskcallByCondition(svyTaskVO.getTaskid(), patTaskRelevance.getPatid());
                    }
                    integer = svyTaskSingle.getTaskid().intValue();
                }
            }
        }


        return integer;
    }
}

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

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

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyTaskTemplateScript;
import com.smartor.mapper.SvyTaskTemplateScriptMapper;
import com.smartor.service.ISvyTaskTemplateScriptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“Service业务层处理
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Service
public class SvyTaskTemplateScriptServiceImpl implements ISvyTaskTemplateScriptService
{
    @Autowired
    private SvyTaskTemplateScriptMapper svyTaskTemplateScriptMapper;

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    @Override
    public SvyTaskTemplateScript selectSvyTaskTemplateScriptByID(Long ID)
    {
        return svyTaskTemplateScriptMapper.selectSvyTaskTemplateScriptByID(ID);
    }

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“列表
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     */
    @Override
    public List<SvyTaskTemplateScript> selectSvyTaskTemplateScriptList(SvyTaskTemplateScript svyTaskTemplateScript)
    {
        return svyTaskTemplateScriptMapper.selectSvyTaskTemplateScriptList(svyTaskTemplateScript);
    }

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript)
    {
        svyTaskTemplateScript.setCreateTime(DateUtils.getNowDate());
        return svyTaskTemplateScriptMapper.insertSvyTaskTemplateScript(svyTaskTemplateScript);
    }

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param svyTaskTemplateScript é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyTaskTemplateScript(SvyTaskTemplateScript svyTaskTemplateScript)
    {
        svyTaskTemplateScript.setUpdateTime(DateUtils.getNowDate());
        return svyTaskTemplateScriptMapper.updateSvyTaskTemplateScript(svyTaskTemplateScript);
    }

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“
     *
     * @param IDs éœ€è¦åˆ é™¤çš„问卷任务模版问题话术库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateScriptByIDs(Long[] IDs)
    {
        return svyTaskTemplateScriptMapper.deleteSvyTaskTemplateScriptByIDs(IDs);
    }

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“信息
     *
     * @param ID é—®å·ä»»åŠ¡æ¨¡ç‰ˆé—®é¢˜è¯æœ¯åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateScriptByID(Long ID)
    {
        return svyTaskTemplateScriptMapper.deleteSvyTaskTemplateScriptByID(ID);
    }
}

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

@@ -1,12 +1,25 @@
package com.smartor.service.impl;

import com.alibaba.fastjson2.JSON;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyTaskTemplate;
import com.ruoyi.common.utils.DtoConversionUtils;
import com.ruoyi.common.utils.StringUtils;
import com.smartor.domain.*;
import com.smartor.mapper.SvyTaskTemplateMapper;
import com.smartor.mapper.SvyTaskTemplateScriptMapper;
import com.smartor.mapper.SvyTaskTemplateTargetoptionMapper;
import com.smartor.service.ISvyTaskTemplateService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections4.CollectionUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.List;

/**
@@ -15,11 +28,17 @@
 * @author ruoyi
 * @date 2024-06-12
 */
@Slf4j
@Service
public class SvyTaskTemplateServiceImpl implements ISvyTaskTemplateService
{
public class SvyTaskTemplateServiceImpl implements ISvyTaskTemplateService {
    @Autowired
    private SvyTaskTemplateMapper svyTaskTemplateMapper;

    @Autowired
    private SvyTaskTemplateScriptMapper svyTaskTemplateScriptMapper;

    @Autowired
    private SvyTaskTemplateTargetoptionMapper svyTaskTemplateTargetoptionMapper;

    /**
     * æŸ¥è¯¢ä»»åŠ¡é—®å·æ¨¡æ¿
@@ -28,8 +47,7 @@
     * @return ä»»åŠ¡é—®å·æ¨¡æ¿
     */
    @Override
    public SvyTaskTemplate selectSvyTaskTemplateBySvyid(Long svyid)
    {
    public SvyTaskTemplate selectSvyTaskTemplateBySvyid(Long svyid) {
        return svyTaskTemplateMapper.selectSvyTaskTemplateBySvyid(svyid);
    }

@@ -40,8 +58,7 @@
     * @return ä»»åŠ¡é—®å·æ¨¡æ¿
     */
    @Override
    public List<SvyTaskTemplate> selectSvyTaskTemplateList(SvyTaskTemplate svyTaskTemplate)
    {
    public List<SvyTaskTemplate> selectSvyTaskTemplateList(SvyTaskTemplate svyTaskTemplate) {
        return svyTaskTemplateMapper.selectSvyTaskTemplateList(svyTaskTemplate);
    }

@@ -52,8 +69,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyTaskTemplate(SvyTaskTemplate svyTaskTemplate)
    {
    public int insertSvyTaskTemplate(SvyTaskTemplate svyTaskTemplate) {
        svyTaskTemplate.setCreateTime(DateUtils.getNowDate());
        return svyTaskTemplateMapper.insertSvyTaskTemplate(svyTaskTemplate);
    }
@@ -65,8 +81,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyTaskTemplate(SvyTaskTemplate svyTaskTemplate)
    {
    public int updateSvyTaskTemplate(SvyTaskTemplate svyTaskTemplate) {
        svyTaskTemplate.setUpdateTime(DateUtils.getNowDate());
        return svyTaskTemplateMapper.updateSvyTaskTemplate(svyTaskTemplate);
    }
@@ -78,8 +93,7 @@
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateBySvyids(Long[] svyids)
    {
    public int deleteSvyTaskTemplateBySvyids(Long[] svyids) {
        return svyTaskTemplateMapper.deleteSvyTaskTemplateBySvyids(svyids);
    }

@@ -90,8 +104,163 @@
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateBySvyid(Long svyid)
    {
    public int deleteSvyTaskTemplateBySvyid(Long svyid) {
        return svyTaskTemplateMapper.deleteSvyTaskTemplateBySvyid(svyid);
    }

    /**
     * æ–°å¢žæˆ–修改问题详情
     *
     * @param svyTaskTemplateVO
     * @return
     */
    @Override
    public Integer saveOrUpdateTemplate(SvyTaskTemplateVO svyTaskTemplateVO) {
        Integer i = null;
        SvyTaskTemplate svyTaskTemplate = DtoConversionUtils.sourceToTarget(svyTaskTemplateVO, SvyTaskTemplate.class);
        if (svyTaskTemplateVO.getIsoperation() != null && svyTaskTemplateVO.getIsoperation() == 1) {
            //新增
            svyTaskTemplate.setCreateTime(new Date());
            svyTaskTemplateMapper.insertSvyTaskTemplate(svyTaskTemplate);
            i = svyTaskTemplate.getId().intValue();
        } else if (svyTaskTemplateVO.getIsoperation() != null && svyTaskTemplateVO.getIsoperation() == 2) {
            //修改
            svyTaskTemplate.setUpdateTime(new Date());
            svyTaskTemplateMapper.updateSvyTaskTemplate(svyTaskTemplate);
            i = svyTaskTemplate.getId().intValue();
        }
        log.info("新增或修改问卷任务模板详情的id为：{}", svyTaskTemplate.getId());

        //对模板话术和选项进行处理（话术表与指标表进行合并了，）
        if (CollectionUtils.isNotEmpty(svyTaskTemplateVO.getSvyTaskTemplateScriptVOS())) {
            log.error("ivrTaskTemplateVO.getIvrTaskTemplateScriptVOList()是否有数据哈：{}", svyTaskTemplateVO.getSvyTaskTemplateScriptVOS());
            for (SvyTaskTemplateScriptVO svyTaskTemplateScriptVO : svyTaskTemplateVO.getSvyTaskTemplateScriptVOS()) {
                if (svyTaskTemplateScriptVO.getIsoperation() != null && svyTaskTemplateScriptVO.getIsoperation() == 1 || svyTaskTemplateScriptVO.getIsoperation() == null && svyTaskTemplateScriptVO.getIsoperation() == 1) {
                    //新增
                    SvyTaskTemplateScript svyTaskTemplateScript = DtoConversionUtils.sourceToTarget(svyTaskTemplateScriptVO, SvyTaskTemplateScript.class);
                    svyTaskTemplateScript.setTemplateID(svyTaskTemplate.getId());
                    svyTaskTemplateScript.setCreateTime(new Date());
                    svyTaskTemplateScriptMapper.insertSvyTaskTemplateScript(svyTaskTemplateScript);
                    svyTaskTemplateScript.setIsoperation(1);
                    //对选项目进行处理
                    dealOption(svyTaskTemplateScriptVO.getSvyTaskTemplateTargetoptions(), svyTaskTemplateScript, svyTaskTemplate.getId());

                } else if (svyTaskTemplateScriptVO.getIsoperation() != null && svyTaskTemplateScriptVO.getIsoperation() == 2) {
                    //修改
                    SvyTaskTemplateScript svyTaskTemplateScript = DtoConversionUtils.sourceToTarget(svyTaskTemplateScriptVO, SvyTaskTemplateScript.class);
                    svyTaskTemplateScript.setTemplateID(svyTaskTemplate.getId());
                    svyTaskTemplateScript.setUpdateTime(new Date());
                    svyTaskTemplateScriptMapper.updateSvyTaskTemplateScript(svyTaskTemplateScript);
                    svyTaskTemplateScript.setIsoperation(2);
                    //对选项目进行处理
                    dealOption(svyTaskTemplateScriptVO.getSvyTaskTemplateTargetoptions(), svyTaskTemplateScript, svyTaskTemplate.getId());

                } else if (svyTaskTemplateScriptVO.getIsoperation() != null && svyTaskTemplateScriptVO.getIsoperation() == 3) {
                    //删除
                    if (svyTaskTemplateScriptVO.getID() == null) {
                        log.info("删除失败,模板话术id为空");
                    } else {
                        svyTaskTemplateScriptVO.setUpdateTime(new Date());
                        svyTaskTemplateScriptMapper.deleteSvyTaskTemplateScriptByID(svyTaskTemplateScriptVO.getID());
                    }
                }
            }
        }

        return i;
    }


    /**
     * æŸ¥è¯¢æ¨¡æ¿è¯¦æƒ…根据条件
     */
    @Override
    public SvyTaskTemplateVO selectInfoByCondition(SvyTaskTemplateVO svyTaskTemplateVO) {
        log.info("selectInfoByCondition查询模板详情根据条件的入参为 : {}", svyTaskTemplateVO);
        //先根据条件查询问题表信息
        SvyTaskTemplate svyTaskTemplate = DtoConversionUtils.sourceToTarget(svyTaskTemplateVO, SvyTaskTemplate.class);
        List<SvyTaskTemplate> svyTaskTemplates = selectSvyTaskTemplateList(svyTaskTemplate);
        if (CollectionUtils.isEmpty(svyTaskTemplates)) {
            log.info("模板信息提供的条件,查询模板详情数据为空：{}", svyTaskTemplates);
            throw new BaseException("模板信息提供的条件,查询模板详情数据为空");
        }

        log.info("svyLibaTemplates的查询结果为:{},数量为 : {}", svyTaskTemplates.get(0), svyTaskTemplates.size());
        //定义IvrLibaTemplateVO ç”¨äºŽè¿”参
        SvyTaskTemplateVO templateVO = DtoConversionUtils.sourceToTarget(svyTaskTemplates.get(0), SvyTaskTemplateVO.class);

        //查询话术
        SvyTaskTemplateScript svyTaskTemplateScript = new SvyTaskTemplateScript();
        svyTaskTemplateScript.setTemplateID(svyTaskTemplates.get(0).getId());
        List<SvyTaskTemplateScript> svyTaskTemplateScripts = svyTaskTemplateScriptMapper.selectSvyTaskTemplateScriptList(svyTaskTemplateScript);
        List<SvyTaskTemplateScriptVO> svyTaskTemplateScriptVOS = DtoConversionUtils.sourceToTarget(svyTaskTemplateScripts, SvyTaskTemplateScriptVO.class);

        //通过话术ID获取选项
        for (SvyTaskTemplateScriptVO svyTaskTemplateScriptVO : svyTaskTemplateScriptVOS) {
            log.info("svyLibaTemplateScriptVO的主键id为：{}", svyTaskTemplateScriptVO.getID());
            SvyTaskTemplateTargetoption svyTaskTemplateTargetoption = new SvyTaskTemplateTargetoption();
            svyTaskTemplateTargetoption.setScriptid(svyTaskTemplateScriptVO.getID());
            List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = svyTaskTemplateTargetoptionMapper.selectSvyTaskTemplateTargetoptionList(svyTaskTemplateTargetoption);
            for (SvyTaskTemplateTargetoption svyTaskTemplateTargetoption1 : svyTaskTemplateTargetoptions) {
                ObjectMapper mapper = new ObjectMapper();
                if (!StringUtils.isEmpty(svyTaskTemplateTargetoption1.getDynamiccruxs())) {
                    try {
                        svyTaskTemplateTargetoption1.setDynamiccruxs(mapper.readValue(svyTaskTemplateTargetoption1.getDynamiccruxsJson(), List.class));
                    } catch (JsonProcessingException e) {
                        e.printStackTrace();
                    }
                }

                if (!StringUtils.isEmpty(svyTaskTemplateTargetoption1.getNodynamiccruxs())) {
                    try {
                        svyTaskTemplateTargetoption1.setNodynamiccruxs(mapper.readValue(svyTaskTemplateTargetoption1.getNodynamiccruxsJson(), List.class));
                    } catch (JsonProcessingException e) {
                        e.printStackTrace();
                    }
                }

            }
            svyTaskTemplateScriptVO.setSvyTaskTemplateTargetoptions(svyTaskTemplateTargetoptions);
        }
        Collections.sort(svyTaskTemplateScriptVOS, Comparator.comparing(SvyTaskTemplateScriptVO::getTargetid));
        //数据组装
        templateVO.setSvyTaskTemplateScriptVOS(svyTaskTemplateScriptVOS);
        return templateVO;
    }


    private void dealOption(List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions, SvyTaskTemplateScript svyTaskTemplateScript, Long tmpID) {
        log.info("svyTaskTemplateScript的值为：{}", svyTaskTemplateScript);
        //对模板指标选项进行处理
        if (CollectionUtils.isNotEmpty(svyTaskTemplateTargetoptions)) {
            for (SvyTaskTemplateTargetoption svyTaskTemplateTargetoption : svyTaskTemplateTargetoptions) {
                if (svyTaskTemplateTargetoption.getIsoperation() != null && svyTaskTemplateTargetoption.getIsoperation() == 1 || svyTaskTemplateTargetoption.getIsoperation() == null && svyTaskTemplateTargetoption.getIsoperation() == 1) {
                    //新增
                    svyTaskTemplateTargetoption.setTemplateID(tmpID);
                    svyTaskTemplateTargetoption.setScriptid(svyTaskTemplateScript.getID());
                    if (CollectionUtils.isNotEmpty(svyTaskTemplateTargetoption.getDynamiccruxs()))
                        svyTaskTemplateTargetoption.setDynamiccruxsJson(JSON.toJSONString(svyTaskTemplateTargetoption.getDynamiccruxs()));
                    if (CollectionUtils.isNotEmpty(svyTaskTemplateTargetoption.getNodynamiccruxs()))
                        svyTaskTemplateTargetoption.setNodynamiccruxsJson(JSON.toJSONString(svyTaskTemplateTargetoption.getNodynamiccruxs()));
                    svyTaskTemplateTargetoptionMapper.insertSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption);
                } else if (svyTaskTemplateTargetoption.getIsoperation() != null && svyTaskTemplateTargetoption.getIsoperation() == 2) {
                    //修改
                    svyTaskTemplateTargetoption.setTemplateID(tmpID);
                    svyTaskTemplateTargetoption.setScriptid(svyTaskTemplateScript.getID());
                    if (CollectionUtils.isNotEmpty(svyTaskTemplateTargetoption.getDynamiccruxs()))
                        svyTaskTemplateTargetoption.setDynamiccruxsJson(JSON.toJSONString(svyTaskTemplateTargetoption.getDynamiccruxs()));
                    if (CollectionUtils.isNotEmpty(svyTaskTemplateTargetoption.getNodynamiccruxs()))
                        svyTaskTemplateTargetoption.setNodynamiccruxsJson(JSON.toJSONString(svyTaskTemplateTargetoption.getNodynamiccruxs()));
                    svyTaskTemplateTargetoptionMapper.updateSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption);
                } else if (svyTaskTemplateTargetoption.getIsoperation() != null && svyTaskTemplateTargetoption.getIsoperation() == 3) {
                    //删除
                    if (svyTaskTemplateTargetoption.getId() == null) {
                        log.info("删除失败,模板指标选项id为空");
                    } else {
                        svyTaskTemplateTargetoptionMapper.deleteSvyTaskTemplateTargetoptionById(svyTaskTemplateTargetoption.getId());
                    }
                }
            }
        }
    }
}

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

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

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyTaskTemplateTargetoption;
import com.smartor.mapper.SvyTaskTemplateTargetoptionMapper;
import com.smartor.service.ISvyTaskTemplateTargetoptionService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“Service业务层处理
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Service
public class SvyTaskTemplateTargetoptionServiceImpl implements ISvyTaskTemplateTargetoptionService
{
    @Autowired
    private SvyTaskTemplateTargetoptionMapper svyTaskTemplateTargetoptionMapper;

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    @Override
    public SvyTaskTemplateTargetoption selectSvyTaskTemplateTargetoptionById(Long id)
    {
        return svyTaskTemplateTargetoptionMapper.selectSvyTaskTemplateTargetoptionById(id);
    }

    /**
     * æŸ¥è¯¢é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     */
    @Override
    public List<SvyTaskTemplateTargetoption> selectSvyTaskTemplateTargetoptionList(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption)
    {
        return svyTaskTemplateTargetoptionMapper.selectSvyTaskTemplateTargetoptionList(svyTaskTemplateTargetoption);
    }

    /**
     * æ–°å¢žé—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption)
    {
        svyTaskTemplateTargetoption.setCreateTime(DateUtils.getNowDate());
        return svyTaskTemplateTargetoptionMapper.insertSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption);
    }

    /**
     * ä¿®æ”¹é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyTaskTemplateTargetoption é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyTaskTemplateTargetoption(SvyTaskTemplateTargetoption svyTaskTemplateTargetoption)
    {
        svyTaskTemplateTargetoption.setUpdateTime(DateUtils.getNowDate());
        return svyTaskTemplateTargetoptionMapper.updateSvyTaskTemplateTargetoption(svyTaskTemplateTargetoption);
    }

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问卷任务模板指标选项库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateTargetoptionByIds(Long[] ids)
    {
        return svyTaskTemplateTargetoptionMapper.deleteSvyTaskTemplateTargetoptionByIds(ids);
    }

    /**
     * åˆ é™¤é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“信息
     *
     * @param id é—®å·ä»»åŠ¡æ¨¡æ¿æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTaskTemplateTargetoptionById(Long id)
    {
        return svyTaskTemplateTargetoptionMapper.deleteSvyTaskTemplateTargetoptionById(id);
    }
}

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

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

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyTasksingledetail;
import com.smartor.mapper.SvyTasksingledetailMapper;
import com.smartor.service.ISvyTasksingledetailService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * é—®å·ç»“果记录详情Service业务层处理
 *
 * @author ruoyi
 * @date 2024-06-19
 */
@Service
public class SvyTasksingledetailServiceImpl implements ISvyTasksingledetailService
{
    @Autowired
    private SvyTasksingledetailMapper svyTasksingledetailMapper;

    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return é—®å·ç»“果记录详情
     */
    @Override
    public SvyTasksingledetail selectSvyTasksingledetailByCalldetailid(String calldetailid)
    {
        return svyTasksingledetailMapper.selectSvyTasksingledetailByCalldetailid(calldetailid);
    }

    /**
     * æŸ¥è¯¢é—®å·ç»“果记录详情列表
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return é—®å·ç»“果记录详情
     */
    @Override
    public List<SvyTasksingledetail> selectSvyTasksingledetailList(SvyTasksingledetail svyTasksingledetail)
    {
        return svyTasksingledetailMapper.selectSvyTasksingledetailList(svyTasksingledetail);
    }

    /**
     * æ–°å¢žé—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail)
    {
        svyTasksingledetail.setCreateTime(DateUtils.getNowDate());
        return svyTasksingledetailMapper.insertSvyTasksingledetail(svyTasksingledetail);
    }

    /**
     * ä¿®æ”¹é—®å·ç»“果记录详情
     *
     * @param svyTasksingledetail é—®å·ç»“果记录详情
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyTasksingledetail(SvyTasksingledetail svyTasksingledetail)
    {
        svyTasksingledetail.setUpdateTime(DateUtils.getNowDate());
        return svyTasksingledetailMapper.updateSvyTasksingledetail(svyTasksingledetail);
    }

    /**
     * æ‰¹é‡åˆ é™¤é—®å·ç»“果记录详情
     *
     * @param calldetailids éœ€è¦åˆ é™¤çš„问卷结果记录详情主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTasksingledetailByCalldetailids(String[] calldetailids)
    {
        return svyTasksingledetailMapper.deleteSvyTasksingledetailByCalldetailids(calldetailids);
    }

    /**
     * åˆ é™¤é—®å·ç»“果记录详情信息
     *
     * @param calldetailid é—®å·ç»“果记录详情主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyTasksingledetailByCalldetailid(String calldetailid)
    {
        return svyTasksingledetailMapper.deleteSvyTasksingledetailByCalldetailid(calldetailid);
    }
}

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

@@ -8,6 +8,7 @@
        <result property="id" column="id"/>
        <result property="tagcategoryid" column="tagcategoryid"/>
        <result property="tagid" column="tagid"/>
        <result property="tagname" column="tagname"/>
        <result property="orgid" column="orgid"/>
        <result property="delFlag" column="del_flag"/>
        <result property="updateBy" column="update_by"/>
@@ -35,6 +36,7 @@
               upload_time,
               targetid,
               pid,
               tagname,
               guid
        from ivr_liba_target_tag
    </sql>
@@ -50,6 +52,7 @@
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="targetid != null ">and targetid = #{targetid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="tagname != null ">and tagname = #{tagname}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
        </where>
    </select>
@@ -87,6 +90,7 @@
            <if test="targetid != null">targetid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="tagname != null">tagname,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
@@ -102,6 +106,7 @@
            <if test="targetid != null">#{targetid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="tagname != null">#{tagname},</if>
        </trim>
    </insert>

@@ -121,6 +126,7 @@
            <if test="targetid != null">targetid = #{targetid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="tagname != null">tagname = #{tagname},</if>
        </trim>
        where id = #{id}
    </update>

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

@@ -31,6 +31,7 @@
        <result property="orgid" column="orgid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <result property="orderno" column="orderno"/>
    </resultMap>

    <sql id="selectIvrLibaTargetoptionVo">
@@ -42,6 +43,7 @@
               targetregex,
               targetregex2,
               nodynamiccruxs,
               orderno,
               dynamiccruxs,
               optiondesc, language, version, groupid, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid
        from ivr_liba_targetoption
@@ -71,6 +73,7 @@
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="orderno != null ">and orderno = #{orderno}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="nodynamiccruxsJson != null">and nodynamiccruxs = #{nodynamiccruxsJson}</if>
            <if test="dynamiccruxsJson != null">and dynamiccruxs = #{dynamiccruxsJson}</if>
@@ -113,6 +116,7 @@
            <if test="guid != null">guid,</if>
            <if test="nodynamiccruxsJson != null">nodynamiccruxs,</if>
            <if test="dynamiccruxsJson != null">dynamiccruxs,</if>
            <if test="orderno != null">orderno,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="targetid != null">#{targetid},</if>
@@ -140,6 +144,7 @@
            <if test="guid != null">#{guid},</if>
            <if test="nodynamiccruxsJson != null">#{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null">#{dynamiccruxsJson},</if>
            <if test="orderno != null">#{orderno},</if>
        </trim>
    </insert>

@@ -171,6 +176,7 @@
            <if test="guid != null">guid = #{guid},</if>
            <if test="nodynamiccruxsJson != null">nodynamiccruxs = #{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null">dynamiccruxs = #{dynamiccruxsJson},</if>
            <if test="orderno != null">orderno = #{orderno},</if>
        </trim>
        where targetoptionid = #{targetoptionid}
    </update>

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

@@ -38,8 +38,6 @@
        <result property="libtemplateid" column="libtemplateid"/>
        <result property="libtemplatename" column="libtemplatename"/>
        <result property="sendTimeSlot" column="send_time_slot"/>
        <result property="libtemplatename" column="libtemplatename"/>
        <result property="libtemplatename" column="libtemplatename"/>
        <result property="stopState" column="stop_state"/>
        <result property="showDate" column="show_date"/>
        <result property="showTimeMorn" column="show_time_morn"/>

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

@@ -69,8 +69,7 @@
               otherdata,
               script_picture,
            language,
            icd10_name,
            svy_scriptid as svyscriptId
            icd10_name
        from svy_lib_script
    </sql>

@@ -124,7 +123,6 @@
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="tag != null">tag,</if>
            <if test="svyscriptId != null">svy_scriptid,</if>
            <if test="categoryid != null">categoryid,</if>
            <if test="scriptContent != null and scriptContent != ''">script_content,</if>
            <if test="suitway != null and suitway != ''">suitway,</if>
@@ -157,7 +155,6 @@
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="tag != null">#{tag},</if>
            <if test="svyscriptId != null">#{svyscriptId},</if>
            <if test="categoryid != null">#{categoryid},</if>
            <if test="scriptContent != null and scriptContent != ''">#{scriptContent},</if>
            <if test="suitway != null  and suitway != ''">#{suitway},</if>

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

@@ -5,7 +5,7 @@
<mapper namespace="com.smartor.mapper.SvyLibScriptOptionMapper">

    <resultMap type="com.smartor.domain.SvyLibScriptOption" id="SvyLibScriptOptionResult">
        <result property="optionid" column="optionid"/>
        <result property="id" column="id"/>
        <result property="topicid" column="topicid"/>
        <result property="svyid" column="svyid"/>
        <result property="topictype" column="topictype"/>
@@ -13,7 +13,7 @@
        <result property="optioncontent" column="optioncontent"/>
        <result property="isexistdetail" column="isexistdetail"/>
        <result property="detailismandatory" column="detailismandatory"/>
        <result property="isexceptionitem" column="isexceptionitem"/>
        <result property="isabnormal" column="isabnormal"/>
        <result property="istrack" column="istrack"/>
        <result property="score" column="score"/>
        <result property="prompt" column="prompt"/>
@@ -39,7 +39,7 @@
    </resultMap>

    <sql id="selectSvyLibScriptOptionVo">
        select optionid,
        select id,
               topicid,
               svyid,
               topictype,
@@ -47,7 +47,7 @@
               optioncontent,
               isexistdetail,
               detailismandatory,
               isexceptionitem,
               isabnormal,
               istrack,
               score,
               prompt,
@@ -85,7 +85,7 @@
            <if test="optioncontent != null  and optioncontent != ''">and optioncontent = #{optioncontent}</if>
            <if test="isexistdetail != null ">and isexistdetail = #{isexistdetail}</if>
            <if test="detailismandatory != null ">and detailismandatory = #{detailismandatory}</if>
            <if test="isexceptionitem != null ">and isexceptionitem = #{isexceptionitem}</if>
            <if test="isabnormal != null ">and isabnormal = #{isabnormal}</if>
            <if test="istrack != null ">and istrack = #{istrack}</if>
            <if test="score != null ">and score = #{score}</if>
            <if test="prompt != null  and prompt != ''">and prompt = #{prompt}</if>
@@ -108,11 +108,11 @@

    <select id="selectSvyLibScriptOptionByOptionid" parameterType="Long" resultMap="SvyLibScriptOptionResult">
        <include refid="selectSvyLibScriptOptionVo"/>
        where optionid = #{optionid}
        where id = #{id}
    </select>

    <insert id="insertSvyLibScriptOption" parameterType="com.smartor.domain.SvyLibScriptOption" useGeneratedKeys="true"
            keyProperty="optionid">
            keyProperty="id">
        insert into svy_lib_ScriptOption
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="topicid != null">topicid,</if>
@@ -122,7 +122,7 @@
            <if test="optioncontent != null">optioncontent,</if>
            <if test="isexistdetail != null">isexistdetail,</if>
            <if test="detailismandatory != null">detailismandatory,</if>
            <if test="isexceptionitem != null">isexceptionitem,</if>
            <if test="isabnormal != null">isabnormal,</if>
            <if test="istrack != null">istrack,</if>
            <if test="score != null">score,</if>
            <if test="prompt != null">prompt,</if>
@@ -154,7 +154,7 @@
            <if test="optioncontent != null">#{optioncontent},</if>
            <if test="isexistdetail != null">#{isexistdetail},</if>
            <if test="detailismandatory != null">#{detailismandatory},</if>
            <if test="isexceptionitem != null">#{isexceptionitem},</if>
            <if test="isabnormal != null">#{isabnormal},</if>
            <if test="istrack != null">#{istrack},</if>
            <if test="score != null">#{score},</if>
            <if test="prompt != null">#{prompt},</if>
@@ -190,7 +190,7 @@
            <if test="optioncontent != null">optioncontent = #{optioncontent},</if>
            <if test="isexistdetail != null">isexistdetail = #{isexistdetail},</if>
            <if test="detailismandatory != null">detailismandatory = #{detailismandatory},</if>
            <if test="isexceptionitem != null">isexceptionitem = #{isexceptionitem},</if>
            <if test="isabnormal != null">isabnormal = #{isabnormal},</if>
            <if test="istrack != null">istrack = #{istrack},</if>
            <if test="score != null">score = #{score},</if>
            <if test="prompt != null">prompt = #{prompt},</if>
@@ -214,7 +214,7 @@
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
        </trim>
        where optionid = #{optionid}
        where id = #{id}
    </update>

    <update id="deleteSvyLibScriptOptionByOptionid" parameterType="Long">
@@ -222,13 +222,13 @@
        <trim prefix="SET" suffixOverrides=",">
           del_flag = 1
        </trim>
        where optionid = #{optionid}
        where id = #{id}
    </update>

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


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

@@ -71,7 +71,8 @@
        from svy_lib_template
    </sql>

    <select id="selectSvyLibTemplateList" parameterType="com.smartor.domain.SvyLibTemplateReq" resultMap="SvyLibTemplateResult">
    <select id="selectSvyLibTemplateList" parameterType="com.smartor.domain.SvyLibTemplateReq"
            resultMap="SvyLibTemplateResult">
        select a.svyid, a.categoryid, a.svycode, a.svyname, a.description, a.introduce,a.submitprompt, a.templateid,
        a.version,a.centerlibrarycode, a.centerlibraryid, a.islocal, a.isenable, a.orgid, a.del_flag, a.create_by,
        a.create_time, a.update_by, a.update_time, a.isupload,
@@ -201,8 +202,8 @@
    </update>

    <delete id="deleteSvyLibTemplateBySvyid" parameterType="Long">
        delete
        from svy_lib_template
        update svy_lib_template
        set del_flag=1
        where svyid = #{svyid}
    </delete>


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

@@ -216,8 +216,8 @@
    </update>

    <delete id="deleteSvyLibTemplateScriptByTopicid" parameterType="Long">
        delete
        from svy_lib_template_script
        update svy_lib_template_script
        set del_flag=1
        where id = #{id}
    </delete>


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

@@ -208,8 +208,8 @@
    </update>

    <delete id="deleteSvyLibTemplateTargetoptionById" parameterType="Long">
        delete
        from svy_lib_template_targetoption
        update svy_lib_template_targetoption
        set del_flag=1
        where id = #{id}
    </delete>


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

@@ -42,10 +42,65 @@
        <result property="isSend"    column="is_send"    />
        <result property="sendState"    column="send_state"    />
        <result property="param"    column="param"    />
        <result property="textParam" column="text_param"/>
        <result property="stopState" column="stop_state"/>
        <result property="showDate" column="show_date"/>
        <result property="showTimeMorn" column="show_time_morn"/>
        <result property="showTimeNoon" column="show_time_noon"/>
        <result property="showTimeNight" column="show_time_night"/>
        <result property="sendTimeSlot" column="send_time_slot"/>
        <result property="libtemplateid" column="libtemplateid"/>
        <result property="libtemplatename" column="libtemplatename"/>
    </resultMap>

    <sql id="selectSvyTaskVo">
        select taskid, svrtaskid, taskname, templateid, templatename, labelinfo, state, count, executed, unexecuted, fail, patientid, patientname, addtime, checkuserid, checkusername, checktime, type, typename, usebqsms, usebhsms, usesendsms, deptcode, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, preachform, is_send, send_state, param from svy_task
        select taskid,
               send_time_slot,
               libtemplateid,
               libtemplatename,
               show_date,
               show_time_morn,
               show_time_noon,
               show_time_night,
               stop_state,
               svrtaskid,
               text_param,
               taskname,
               templateid,
               templatename,
               labelinfo,
               state,
               count,
               executed,
               unexecuted,
               fail,
               patientid,
               patientname,
               addtime,
               checkuserid,
               checkusername,
               checktime,
               type,
               typename,
               usebqsms,
               usebhsms,
               usesendsms,
               deptcode,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               orgid,
               pid,
               guid,
               preachform,
               is_send,
               send_state,
               param
        from svy_task
    </sql>

    <select id="selectSvyTaskList" parameterType="com.smartor.domain.SvyTask" resultMap="SvyTaskResult">
@@ -54,7 +109,9 @@
            <if test="svrtaskid != null "> and svrtaskid = #{svrtaskid}</if>
            <if test="taskname != null  and taskname != ''"> and taskname like concat('%', #{taskname}, '%')</if>
            <if test="templateid != null  and templateid != ''"> and templateid = #{templateid}</if>
            <if test="templatename != null  and templatename != ''"> and templatename like concat('%', #{templatename}, '%')</if>
            <if test="templatename != null  and templatename != ''">and templatename like concat('%', #{templatename},
                '%')
            </if>
            <if test="labelinfo != null  and labelinfo != ''"> and labelinfo = #{labelinfo}</if>
            <if test="state != null "> and state = #{state}</if>
            <if test="count != null "> and count = #{count}</if>
@@ -62,10 +119,14 @@
            <if test="unexecuted != null "> and unexecuted = #{unexecuted}</if>
            <if test="fail != null "> and fail = #{fail}</if>
            <if test="patientid != null  and patientid != ''"> and patientid = #{patientid}</if>
            <if test="patientname != null  and patientname != ''"> and patientname like concat('%', #{patientname}, '%')</if>
            <if test="patientname != null  and patientname != ''">and patientname like concat('%', #{patientname},
                '%')
            </if>
            <if test="addtime != null "> and addtime = #{addtime}</if>
            <if test="checkuserid != null  and checkuserid != ''"> and checkuserid = #{checkuserid}</if>
            <if test="checkusername != null  and checkusername != ''"> and checkusername like concat('%', #{checkusername}, '%')</if>
            <if test="checkusername != null  and checkusername != ''">and checkusername like concat('%',
                #{checkusername}, '%')
            </if>
            <if test="checktime != null "> and checktime = #{checktime}</if>
            <if test="type != null  and type != ''"> and type = #{type}</if>
            <if test="typename != null  and typename != ''"> and typename like concat('%', #{typename}, '%')</if>
@@ -82,6 +143,11 @@
            <if test="isSend != null "> and is_send = #{isSend}</if>
            <if test="sendState != null  and sendState != ''"> and send_state = #{sendState}</if>
            <if test="param != null  and param != ''"> and param = #{param}</if>
            <if test="sendTimeSlot != null  and sendTimeSlot != ''">and send_time_slot like concat('%', #{sendTimeSlot},
                '%')
            </if>
            <if test="libtemplateid != null ">and libtemplateid = #{libtemplateid}</if>
            <if test="libtemplatename != null  and libtemplatename != ''">and libtemplatename = #{libtemplatename}</if>
        </where>
    </select>

@@ -129,6 +195,15 @@
            <if test="isSend != null">is_send,</if>
            <if test="sendState != null">send_state,</if>
            <if test="param != null">param,</if>
            <if test="textParam != null">text_param,</if>
            <if test="sendTimeSlot != null  and sendTimeSlot != ''">send_time_slot,</if>
            <if test="stopState != null">stop_state,</if>
            <if test="showDate != null and showDate != ''">show_date,</if>
            <if test="showTimeNight != null and showTimeNight != ''">show_time_night,</if>
            <if test="showTimeNoon != null and showTimeNoon != ''">show_time_noon,</if>
            <if test="showTimeMorn != null and showTimeMorn != ''">show_time_morn,</if>
            <if test="libtemplateid != null ">libtemplateid,</if>
            <if test="libtemplatename != null  and libtemplatename != ''">libtemplatename,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="svrtaskid != null">#{svrtaskid},</if>
@@ -167,6 +242,15 @@
            <if test="isSend != null">#{isSend},</if>
            <if test="sendState != null">#{sendState},</if>
            <if test="param != null">#{param},</if>
            <if test="textParam != null">#{textParam},</if>
            <if test="sendTimeSlot != null  and sendTimeSlot != ''">#{sendTimeSlot},</if>
            <if test="stopState != null">#{stopState},</if>
            <if test="showDate != null and showDate != ''">#{showDate},</if>
            <if test="showTimeNight != null and showTimeNight != ''">#{showTimeNight},</if>
            <if test="showTimeNoon != null and showTimeNoon != ''">#{showTimeNoon},</if>
            <if test="showTimeMorn != null and showTimeMorn != ''">#{showTimeMorn},</if>
            <if test="libtemplateid != null ">#{libtemplateid},</if>
            <if test="libtemplatename != null  and libtemplatename != ''">#{libtemplatename},</if>
         </trim>
    </insert>

@@ -209,12 +293,23 @@
            <if test="isSend != null">is_send = #{isSend},</if>
            <if test="sendState != null">send_state = #{sendState},</if>
            <if test="param != null">param = #{param},</if>
            <if test="textParam != null">text_param = #{textParam},</if>
            <if test="sendTimeSlot != null  and sendTimeSlot != ''">send_time_slot=#{sendTimeSlot},</if>
            <if test="stopState != null ">stop_state=#{stopState},</if>
            <if test="showDate != null and showDate != ''">show_date=#{showDate},</if>
            <if test="showTimeNight != null and showTimeNight != ''">show_time_night=#{showTimeNight},</if>
            <if test="showTimeNoon != null and showTimeNoon != ''">show_time_noon=#{showTimeNoon},</if>
            <if test="showTimeMorn != null and showTimeMorn != ''">show_time_morn=#{showTimeMorn},</if>
            <if test="libtemplateid != null ">libtemplateid = #{libtemplateid},</if>
            <if test="libtemplatename != null  and libtemplatename != ''">libtemplatename = #{libtemplatename},</if>
        </trim>
        where taskid = #{taskid}
    </update>

    <delete id="deleteSvyTaskByTaskid" parameterType="Long">
        delete from svy_task where taskid = #{taskid}
        delete
        from svy_task
        where taskid = #{taskid}
    </delete>

    <delete id="deleteSvyTaskByTaskids" parameterType="String">

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

@@ -69,11 +69,13 @@
        <result property="admindate" column="admindate"/>
        <result property="roomno" column="roomno"/>
        <result property="bedno" column="bedno"/>
        <result property="patid" column="patid"/>
    </resultMap>

    <sql id="selectSvyTaskSingleVo">
        select id,
               sendname,
               patid,
               phone,
               sex,
               age,
@@ -204,6 +206,7 @@
            <if test="admindate != null ">and admindate = #{admindate}</if>
            <if test="roomno != null  and roomno != ''">and roomno = #{roomno}</if>
            <if test="bedno != null  and bedno != ''">and bedno = #{bedno}</if>
            <if test="patid != null ">and patid = #{patid}</if>
        </where>
    </select>

@@ -279,6 +282,7 @@
            <if test="admindate != null">admindate,</if>
            <if test="roomno != null">roomno,</if>
            <if test="bedno != null">bedno,</if>
            <if test="patid != null">patid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="sendname != null">#{sendname},</if>
@@ -344,6 +348,7 @@
            <if test="admindate != null">#{admindate},</if>
            <if test="roomno != null">#{roomno},</if>
            <if test="bedno != null">#{bedno},</if>
            <if test="patid != null">#{patid},</if>
        </trim>
    </insert>

@@ -413,6 +418,7 @@
            <if test="admindate != null">admindate = #{admindate},</if>
            <if test="roomno != null">roomno = #{roomno},</if>
            <if test="bedno != null">bedno = #{bedno},</if>
            <if test="patid != null">patid = #{patid},</if>
        </trim>
        where id = #{id}
    </update>
@@ -429,4 +435,12 @@
            #{id}
        </foreach>
    </delete>

    <update id="deleteSvyTaskcallByCondition" >
        update svy_task_single
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where patid = #{patid} and taskid = #{taskid}
    </update>
</mapper>

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

@@ -5,7 +5,7 @@
<mapper namespace="com.smartor.mapper.SvyTaskTemplateMapper">

    <resultMap type="com.smartor.domain.SvyTaskTemplate" id="SvyTaskTemplateResult">
        <result property="svyid" column="svyid"/>
        <result property="id" column="id"/>
        <result property="templateid" column="templateid"/>
        <result property="categoryid" column="categoryid"/>
        <result property="svycode" column="svycode"/>
@@ -41,7 +41,7 @@
    </resultMap>

    <sql id="selectSvyTaskTemplateVo">
        select svyid,
        select id,
               templateid,
               categoryid,
               svycode,
@@ -115,11 +115,11 @@

    <select id="selectSvyTaskTemplateBySvyid" parameterType="Long" resultMap="SvyTaskTemplateResult">
        <include refid="selectSvyTaskTemplateVo"/>
        where svyid = #{svyid}
        where id = #{id}
    </select>

    <insert id="insertSvyTaskTemplate" parameterType="com.smartor.domain.SvyTaskTemplate" useGeneratedKeys="true"
            keyProperty="svyid">
            keyProperty="id">
        insert into svy_task_template
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateid != null">templateid,</if>
@@ -227,19 +227,19 @@
            <if test="reply != null">reply = #{reply},</if>
            <if test="taskid != null">taskid = #{taskid},</if>
        </trim>
        where svyid = #{svyid}
        where id = #{id}
    </update>

    <delete id="deleteSvyTaskTemplateBySvyid" parameterType="Long">
        delete
        from svy_task_template
        where svyid = #{svyid}
        where id = #{id}
    </delete>

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

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

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

    <resultMap type="com.smartor.domain.SvyTaskTemplateScript" id="SvyTaskTemplateScriptResult">
        <result property="ID"    column="ID"    />
        <result property="taskid"    column="taskid"    />
        <result property="templateQuestionNum"    column="templateQuestionNum"    />
        <result property="templateID"    column="templateID"    />
        <result property="scriptID"    column="scriptID"    />
        <result property="questiontitle"    column="questiontitle"    />
        <result property="language"    column="language"    />
        <result property="categoryName"    column="categoryName"    />
        <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="isMust"    column="is_must"    />
        <result property="playWavOnly"    column="playWavOnly"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="isupload"    column="isupload"    />
        <result property="uploadTime"    column="upload_time"    />
        <result property="orgid"    column="orgid"    />
        <result property="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
        <result property="valueType"    column="value_type"    />
        <result property="targetOptions"    column="targetOptions"    />
        <result property="targettype"    column="targettype"    />
        <result property="targetid"    column="targetid"    />
        <result property="targetvalue"    column="targetvalue"    />
        <result property="nextQuestion"    column="next_question"    />
        <result property="questionResult"    column="question_result"    />
        <result property="otherdata"    column="otherdata"    />
        <result property="picturePath"    column="picture_path"    />
    </resultMap>

    <sql id="selectSvyTaskTemplateScriptVo">
        select ID, taskid, templateQuestionNum, templateID, scriptID, questiontitle, language, categoryName, questionPoint, questionText, questionVoice, noMatchText, noMatchVoice, slienceText, slienceVoice, submoduleText, submoduleVoice, noClearlyText, noClearlyVoice, is_must, playWavOnly, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, value_type, targetOptions, targettype, targetid, targetvalue, next_question, question_result, otherdata, picture_path from svy_task_template_script
    </sql>

    <select id="selectSvyTaskTemplateScriptList" parameterType="com.smartor.domain.SvyTaskTemplateScript" resultMap="SvyTaskTemplateScriptResult">
        <include refid="selectSvyTaskTemplateScriptVo"/>
        <where>
            <if test="taskid != null "> and taskid = #{taskid}</if>
            <if test="templateQuestionNum != null "> and templateQuestionNum = #{templateQuestionNum}</if>
            <if test="templateID != null "> and templateID = #{templateID}</if>
            <if test="scriptID != null "> and scriptID = #{scriptID}</if>
            <if test="questiontitle != null  and questiontitle != ''"> and questiontitle = #{questiontitle}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="categoryName != null  and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</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="isMust != null  and isMust != ''"> and is_must = #{isMust}</if>
            <if test="playWavOnly != null "> and playWavOnly = #{playWavOnly}</if>
            <if test="isupload != null "> and isupload = #{isupload}</if>
            <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
            <if test="valueType != null "> and value_type = #{valueType}</if>
            <if test="targetOptions != null  and targetOptions != ''"> and targetOptions = #{targetOptions}</if>
            <if test="targettype != null  and targettype != ''"> and targettype = #{targettype}</if>
            <if test="targetid != null "> and targetid = #{targetid}</if>
            <if test="targetvalue != null  and targetvalue != ''"> and targetvalue = #{targetvalue}</if>
            <if test="nextQuestion != null "> and next_question = #{nextQuestion}</if>
            <if test="questionResult != null  and questionResult != ''"> and question_result = #{questionResult}</if>
            <if test="otherdata != null  and otherdata != ''"> and otherdata = #{otherdata}</if>
            <if test="picturePath != null  and picturePath != ''"> and picture_path = #{picturePath}</if>
        </where>
    </select>

    <select id="selectSvyTaskTemplateScriptByID" parameterType="Long" resultMap="SvyTaskTemplateScriptResult">
        <include refid="selectSvyTaskTemplateScriptVo"/>
        where ID = #{ID}
    </select>

    <insert id="insertSvyTaskTemplateScript" parameterType="com.smartor.domain.SvyTaskTemplateScript" useGeneratedKeys="true" keyProperty="ID">
        insert into svy_task_template_script
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="taskid != null">taskid,</if>
            <if test="templateQuestionNum != null">templateQuestionNum,</if>
            <if test="templateID != null">templateID,</if>
            <if test="scriptID != null">scriptID,</if>
            <if test="questiontitle != null">questiontitle,</if>
            <if test="language != null">language,</if>
            <if test="categoryName != null">categoryName,</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="isMust != null">is_must,</if>
            <if test="playWavOnly != null">playWavOnly,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="orgid != null">orgid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="valueType != null">value_type,</if>
            <if test="targetOptions != null">targetOptions,</if>
            <if test="targettype != null">targettype,</if>
            <if test="targetid != null">targetid,</if>
            <if test="targetvalue != null">targetvalue,</if>
            <if test="nextQuestion != null">next_question,</if>
            <if test="questionResult != null">question_result,</if>
            <if test="otherdata != null">otherdata,</if>
            <if test="picturePath != null">picture_path,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="taskid != null">#{taskid},</if>
            <if test="templateQuestionNum != null">#{templateQuestionNum},</if>
            <if test="templateID != null">#{templateID},</if>
            <if test="scriptID != null">#{scriptID},</if>
            <if test="questiontitle != null">#{questiontitle},</if>
            <if test="language != null">#{language},</if>
            <if test="categoryName != null">#{categoryName},</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="isMust != null">#{isMust},</if>
            <if test="playWavOnly != null">#{playWavOnly},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="valueType != null">#{valueType},</if>
            <if test="targetOptions != null">#{targetOptions},</if>
            <if test="targettype != null">#{targettype},</if>
            <if test="targetid != null">#{targetid},</if>
            <if test="targetvalue != null">#{targetvalue},</if>
            <if test="nextQuestion != null">#{nextQuestion},</if>
            <if test="questionResult != null">#{questionResult},</if>
            <if test="otherdata != null">#{otherdata},</if>
            <if test="picturePath != null">#{picturePath},</if>
         </trim>
    </insert>

    <update id="updateSvyTaskTemplateScript" parameterType="com.smartor.domain.SvyTaskTemplateScript">
        update svy_task_template_script
        <trim prefix="SET" suffixOverrides=",">
            <if test="taskid != null">taskid = #{taskid},</if>
            <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if>
            <if test="templateID != null">templateID = #{templateID},</if>
            <if test="scriptID != null">scriptID = #{scriptID},</if>
            <if test="questiontitle != null">questiontitle = #{questiontitle},</if>
            <if test="language != null">language = #{language},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <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="isMust != null">is_must = #{isMust},</if>
            <if test="playWavOnly != null">playWavOnly = #{playWavOnly},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="valueType != null">value_type = #{valueType},</if>
            <if test="targetOptions != null">targetOptions = #{targetOptions},</if>
            <if test="targettype != null">targettype = #{targettype},</if>
            <if test="targetid != null">targetid = #{targetid},</if>
            <if test="targetvalue != null">targetvalue = #{targetvalue},</if>
            <if test="nextQuestion != null">next_question = #{nextQuestion},</if>
            <if test="questionResult != null">question_result = #{questionResult},</if>
            <if test="otherdata != null">otherdata = #{otherdata},</if>
            <if test="picturePath != null">picture_path = #{picturePath},</if>
        </trim>
        where ID = #{ID}
    </update>

    <delete id="deleteSvyTaskTemplateScriptByID" parameterType="Long">
        delete from svy_task_template_script where ID = #{ID}
    </delete>

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

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

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

    <resultMap type="com.smartor.domain.SvyTaskTemplateTargetoption" id="SvyTaskTemplateTargetoptionResult">
        <result property="id"    column="id"    />
        <result property="taskid"    column="taskid"    />
        <result property="templateID"    column="templateID"    />
        <result property="targetid"    column="targetid"    />
        <result property="targetname"    column="targetname"    />
        <result property="targettype"    column="targettype"    />
        <result property="categoryName"    column="categoryName"    />
        <result property="targetvalue"    column="targetvalue"    />
        <result property="targetregex2"    column="targetregex2"    />
        <result property="targetregex"    column="targetregex"    />
        <result property="optiondesc"    column="optiondesc"    />
        <result property="language"    column="language"    />
        <result property="version"    column="version"    />
        <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"    />
        <result property="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
        <result property="scriptid"    column="scriptid"    />
        <result property="nodynamiccruxsJson"    column="nodynamiccruxs"    />
        <result property="dynamiccruxsJson"    column="dynamiccruxs"    />
        <result property="nextQuestion"    column="next_question"    />
        <result property="picturePath"    column="picture_path"    />
    </resultMap>

    <sql id="selectSvyTaskTemplateTargetoptionVo">
        select id, taskid, templateID, targetid, targetname, targettype, categoryName, targetvalue, targetregex2, targetregex, optiondesc, language, version, groupid, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, scriptid, nodynamiccruxs, dynamiccruxs, next_question, picture_path from svy_task_template_targetoption
    </sql>

    <select id="selectSvyTaskTemplateTargetoptionList" parameterType="SvyTaskTemplateTargetoption" resultMap="SvyTaskTemplateTargetoptionResult">
        <include refid="selectSvyTaskTemplateTargetoptionVo"/>
        <where>
            <if test="taskid != null "> and taskid = #{taskid}</if>
            <if test="templateID != null "> and templateID = #{templateID}</if>
            <if test="targetid != null "> and targetid = #{targetid}</if>
            <if test="targetname != null  and targetname != ''"> and targetname like concat('%', #{targetname}, '%')</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="targetregex2 != null  and targetregex2 != ''"> and targetregex2 = #{targetregex2}</if>
            <if test="targetregex != null  and targetregex != ''"> and targetregex = #{targetregex}</if>
            <if test="optiondesc != null  and optiondesc != ''"> and optiondesc = #{optiondesc}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="version != null  and version != ''"> and version = #{version}</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>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
            <if test="scriptid != null "> and scriptid = #{scriptid}</if>
            <if test="nodynamiccruxs != null  and nodynamiccruxs != ''"> and nodynamiccruxs = #{nodynamiccruxsJson}</if>
            <if test="dynamiccruxs != null  and dynamiccruxs != ''"> and dynamiccruxs = #{dynamiccruxsJson}</if>
            <if test="nextQuestion != null "> and next_question = #{nextQuestion}</if>
            <if test="picturePath != null  and picturePath != ''"> and picture_path = #{picturePath}</if>
        </where>
    </select>

    <select id="selectSvyTaskTemplateTargetoptionById" parameterType="Long" resultMap="SvyTaskTemplateTargetoptionResult">
        <include refid="selectSvyTaskTemplateTargetoptionVo"/>
        where id = #{id}
    </select>

    <insert id="insertSvyTaskTemplateTargetoption" parameterType="com.smartor.domain.SvyTaskTemplateTargetoption" useGeneratedKeys="true" keyProperty="id">
        insert into svy_task_template_targetoption
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="taskid != null">taskid,</if>
            <if test="templateID != null">templateID,</if>
            <if test="targetid != null">targetid,</if>
            <if test="targetname != null">targetname,</if>
            <if test="targettype != null">targettype,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="targetvalue != null">targetvalue,</if>
            <if test="targetregex2 != null">targetregex2,</if>
            <if test="targetregex != null">targetregex,</if>
            <if test="optiondesc != null">optiondesc,</if>
            <if test="language != null">language,</if>
            <if test="version != null">version,</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">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="orgid != null">orgid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="scriptid != null">scriptid,</if>
            <if test="nodynamiccruxs != null">nodynamiccruxs,</if>
            <if test="dynamiccruxs != null">dynamiccruxs,</if>
            <if test="nextQuestion != null">next_question,</if>
            <if test="picturePath != null">picture_path,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="taskid != null">#{taskid},</if>
            <if test="templateID != null">#{templateID},</if>
            <if test="targetid != null">#{targetid},</if>
            <if test="targetname != null">#{targetname},</if>
            <if test="targettype != null">#{targettype},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="targetvalue != null">#{targetvalue},</if>
            <if test="targetregex2 != null">#{targetregex2},</if>
            <if test="targetregex != null">#{targetregex},</if>
            <if test="optiondesc != null">#{optiondesc},</if>
            <if test="language != null">#{language},</if>
            <if test="version != null">#{version},</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">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="scriptid != null">#{scriptid},</if>
            <if test="nodynamiccruxs != null">#{nodynamiccruxsJson},</if>
            <if test="dynamiccruxs != null">#{dynamiccruxsJson},</if>
            <if test="nextQuestion != null">#{nextQuestion},</if>
            <if test="picturePath != null">#{picturePath},</if>
         </trim>
    </insert>

    <update id="updateSvyTaskTemplateTargetoption" parameterType="com.smartor.domain.SvyTaskTemplateTargetoption">
        update svy_task_template_targetoption
        <trim prefix="SET" suffixOverrides=",">
            <if test="taskid != null">taskid = #{taskid},</if>
            <if test="templateID != null">templateID = #{templateID},</if>
            <if test="targetid != null">targetid = #{targetid},</if>
            <if test="targetname != null">targetname = #{targetname},</if>
            <if test="targettype != null">targettype = #{targettype},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="targetvalue != null">targetvalue = #{targetvalue},</if>
            <if test="targetregex2 != null">targetregex2 = #{targetregex2},</if>
            <if test="targetregex != null">targetregex = #{targetregex},</if>
            <if test="optiondesc != null">optiondesc = #{optiondesc},</if>
            <if test="language != null">language = #{language},</if>
            <if test="version != null">version = #{version},</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">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="scriptid != null">scriptid = #{scriptid},</if>
            <if test="nodynamiccruxs != null">nodynamiccruxs = #{nodynamiccruxsJson},</if>
            <if test="dynamiccruxs != null">dynamiccruxs = #{dynamiccruxsJson},</if>
            <if test="nextQuestion != null">next_question = #{nextQuestion},</if>
            <if test="picturePath != null">picture_path = #{picturePath},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteSvyTaskTemplateTargetoptionById" parameterType="Long">
        delete from svy_task_template_targetoption where id = #{id}
    </delete>

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

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

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

    <resultMap type="com.smartor.domain.SvyTasksingledetail" id="SvyTasksingledetailResult">
        <result property="calldetailid"    column="calldetailid"    />
        <result property="callid"    column="callid"    />
        <result property="uuid"    column="uuid"    />
        <result property="phone"    column="phone"    />
        <result property="displayno"    column="displayno"    />
        <result property="operate"    column="operate"    />
        <result property="inbound"    column="inbound"    />
        <result property="incoming"    column="incoming"    />
        <result property="assigntime"    column="assigntime"    />
        <result property="starttime"    column="starttime"    />
        <result property="answertime"    column="answertime"    />
        <result property="silent"    column="silent"    />
        <result property="dtmfKey"    column="dtmf_key"    />
        <result property="musicpath"    column="musicpath"    />
        <result property="sentIndex"    column="sent_index"    />
        <result property="sentBegin"    column="sent_begin"    />
        <result property="asrtext"    column="asrtext"    />
        <result property="beginTime"    column="begin_time"    />
        <result property="endTime"    column="end_time"    />
        <result property="sentEnd"    column="sent_end"    />
        <result property="recordpath"    column="recordpath"    />
        <result property="recordurl"    column="recordurl"    />
        <result property="templateid"    column="templateid"    />
        <result property="templatequestionnum"    column="templatequestionnum"    />
        <result property="switchid"    column="switchid"    />
        <result property="questiontext"    column="questiontext"    />
        <result property="questionvoice"    column="questionvoice"    />
        <result property="categoryname"    column="categoryname"    />
        <result property="targetoptions"    column="targetoptions"    />
        <result property="targetvalue"    column="targetvalue"    />
        <result property="matchedtext"    column="matchedtext"    />
        <result property="addtime"    column="addtime"    />
        <result property="isupload"    column="isupload"    />
        <result property="uploadTime"    column="upload_time"    />
        <result property="orgid"    column="orgid"    />
        <result property="createTime"    column="create_time"    />
        <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="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
        <result property="valueType"    column="value_type"    />
    </resultMap>

    <sql id="selectSvyTasksingledetailVo">
        select calldetailid, callid, uuid, phone, displayno, operate, inbound, incoming, assigntime, starttime, answertime, silent, dtmf_key, musicpath, sent_index, sent_begin, asrtext, begin_time, end_time, sent_end, recordpath, recordurl, templateid, templatequestionnum, switchid, questiontext, questionvoice, categoryname, targetoptions, targetvalue, matchedtext, addtime, isupload, upload_time, orgid, create_time, del_flag, update_by, update_time, create_by, pid, guid, value_type from svy_tasksingledetail
    </sql>

    <select id="selectSvyTasksingledetailList" parameterType="com.smartor.domain.SvyTasksingledetail" resultMap="SvyTasksingledetailResult">
        <include refid="selectSvyTasksingledetailVo"/>
        <where>
            <if test="callid != null  and callid != ''"> and callid = #{callid}</if>
            <if test="uuid != null  and uuid != ''"> and uuid = #{uuid}</if>
            <if test="phone != null  and phone != ''"> and phone = #{phone}</if>
            <if test="displayno != null  and displayno != ''"> and displayno = #{displayno}</if>
            <if test="operate != null  and operate != ''"> and operate = #{operate}</if>
            <if test="inbound != null "> and inbound = #{inbound}</if>
            <if test="incoming != null "> and incoming = #{incoming}</if>
            <if test="assigntime != null "> and assigntime = #{assigntime}</if>
            <if test="starttime != null "> and starttime = #{starttime}</if>
            <if test="answertime != null "> and answertime = #{answertime}</if>
            <if test="silent != null "> and silent = #{silent}</if>
            <if test="dtmfKey != null  and dtmfKey != ''"> and dtmf_key = #{dtmfKey}</if>
            <if test="musicpath != null  and musicpath != ''"> and musicpath = #{musicpath}</if>
            <if test="sentIndex != null "> and sent_index = #{sentIndex}</if>
            <if test="sentBegin != null "> and sent_begin = #{sentBegin}</if>
            <if test="asrtext != null  and asrtext != ''"> and asrtext = #{asrtext}</if>
            <if test="beginTime != null "> and begin_time = #{beginTime}</if>
            <if test="endTime != null "> and end_time = #{endTime}</if>
            <if test="sentEnd != null "> and sent_end = #{sentEnd}</if>
            <if test="recordpath != null  and recordpath != ''"> and recordpath = #{recordpath}</if>
            <if test="recordurl != null  and recordurl != ''"> and recordurl = #{recordurl}</if>
            <if test="templateid != null  and templateid != ''"> and templateid = #{templateid}</if>
            <if test="templatequestionnum != null "> and templatequestionnum = #{templatequestionnum}</if>
            <if test="switchid != null "> and switchid = #{switchid}</if>
            <if test="questiontext != null  and questiontext != ''"> and questiontext = #{questiontext}</if>
            <if test="questionvoice != null  and questionvoice != ''"> and questionvoice = #{questionvoice}</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="targetvalue != null  and targetvalue != ''"> and targetvalue = #{targetvalue}</if>
            <if test="matchedtext != null  and matchedtext != ''"> and matchedtext = #{matchedtext}</if>
            <if test="addtime != null "> and addtime = #{addtime}</if>
            <if test="isupload != null "> and isupload = #{isupload}</if>
            <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
            <if test="valueType != null  and valueType != ''"> and value_type = #{valueType}</if>
        </where>
    </select>

    <select id="selectSvyTasksingledetailByCalldetailid" parameterType="String" resultMap="SvyTasksingledetailResult">
        <include refid="selectSvyTasksingledetailVo"/>
        where calldetailid = #{calldetailid}
    </select>

    <insert id="insertSvyTasksingledetail" parameterType="com.smartor.domain.SvyTasksingledetail">
        insert into svy_tasksingledetail
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="calldetailid != null">calldetailid,</if>
            <if test="callid != null">callid,</if>
            <if test="uuid != null">uuid,</if>
            <if test="phone != null">phone,</if>
            <if test="displayno != null">displayno,</if>
            <if test="operate != null">operate,</if>
            <if test="inbound != null">inbound,</if>
            <if test="incoming != null">incoming,</if>
            <if test="assigntime != null">assigntime,</if>
            <if test="starttime != null">starttime,</if>
            <if test="answertime != null">answertime,</if>
            <if test="silent != null">silent,</if>
            <if test="dtmfKey != null">dtmf_key,</if>
            <if test="musicpath != null">musicpath,</if>
            <if test="sentIndex != null">sent_index,</if>
            <if test="sentBegin != null">sent_begin,</if>
            <if test="asrtext != null">asrtext,</if>
            <if test="beginTime != null">begin_time,</if>
            <if test="endTime != null">end_time,</if>
            <if test="sentEnd != null">sent_end,</if>
            <if test="recordpath != null">recordpath,</if>
            <if test="recordurl != null">recordurl,</if>
            <if test="templateid != null">templateid,</if>
            <if test="templatequestionnum != null">templatequestionnum,</if>
            <if test="switchid != null">switchid,</if>
            <if test="questiontext != null">questiontext,</if>
            <if test="questionvoice != null">questionvoice,</if>
            <if test="categoryname != null">categoryname,</if>
            <if test="targetoptions != null">targetoptions,</if>
            <if test="targetvalue != null">targetvalue,</if>
            <if test="matchedtext != null">matchedtext,</if>
            <if test="addtime != null">addtime,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="orgid != null">orgid,</if>
            <if test="createTime != null">create_time,</if>
            <if test="delFlag != null">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="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="valueType != null">value_type,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="calldetailid != null">#{calldetailid},</if>
            <if test="callid != null">#{callid},</if>
            <if test="uuid != null">#{uuid},</if>
            <if test="phone != null">#{phone},</if>
            <if test="displayno != null">#{displayno},</if>
            <if test="operate != null">#{operate},</if>
            <if test="inbound != null">#{inbound},</if>
            <if test="incoming != null">#{incoming},</if>
            <if test="assigntime != null">#{assigntime},</if>
            <if test="starttime != null">#{starttime},</if>
            <if test="answertime != null">#{answertime},</if>
            <if test="silent != null">#{silent},</if>
            <if test="dtmfKey != null">#{dtmfKey},</if>
            <if test="musicpath != null">#{musicpath},</if>
            <if test="sentIndex != null">#{sentIndex},</if>
            <if test="sentBegin != null">#{sentBegin},</if>
            <if test="asrtext != null">#{asrtext},</if>
            <if test="beginTime != null">#{beginTime},</if>
            <if test="endTime != null">#{endTime},</if>
            <if test="sentEnd != null">#{sentEnd},</if>
            <if test="recordpath != null">#{recordpath},</if>
            <if test="recordurl != null">#{recordurl},</if>
            <if test="templateid != null">#{templateid},</if>
            <if test="templatequestionnum != null">#{templatequestionnum},</if>
            <if test="switchid != null">#{switchid},</if>
            <if test="questiontext != null">#{questiontext},</if>
            <if test="questionvoice != null">#{questionvoice},</if>
            <if test="categoryname != null">#{categoryname},</if>
            <if test="targetoptions != null">#{targetoptions},</if>
            <if test="targetvalue != null">#{targetvalue},</if>
            <if test="matchedtext != null">#{matchedtext},</if>
            <if test="addtime != null">#{addtime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="valueType != null">#{valueType},</if>
         </trim>
    </insert>

    <update id="updateSvyTasksingledetail" parameterType="com.smartor.domain.SvyTasksingledetail">
        update svy_tasksingledetail
        <trim prefix="SET" suffixOverrides=",">
            <if test="callid != null">callid = #{callid},</if>
            <if test="uuid != null">uuid = #{uuid},</if>
            <if test="phone != null">phone = #{phone},</if>
            <if test="displayno != null">displayno = #{displayno},</if>
            <if test="operate != null">operate = #{operate},</if>
            <if test="inbound != null">inbound = #{inbound},</if>
            <if test="incoming != null">incoming = #{incoming},</if>
            <if test="assigntime != null">assigntime = #{assigntime},</if>
            <if test="starttime != null">starttime = #{starttime},</if>
            <if test="answertime != null">answertime = #{answertime},</if>
            <if test="silent != null">silent = #{silent},</if>
            <if test="dtmfKey != null">dtmf_key = #{dtmfKey},</if>
            <if test="musicpath != null">musicpath = #{musicpath},</if>
            <if test="sentIndex != null">sent_index = #{sentIndex},</if>
            <if test="sentBegin != null">sent_begin = #{sentBegin},</if>
            <if test="asrtext != null">asrtext = #{asrtext},</if>
            <if test="beginTime != null">begin_time = #{beginTime},</if>
            <if test="endTime != null">end_time = #{endTime},</if>
            <if test="sentEnd != null">sent_end = #{sentEnd},</if>
            <if test="recordpath != null">recordpath = #{recordpath},</if>
            <if test="recordurl != null">recordurl = #{recordurl},</if>
            <if test="templateid != null">templateid = #{templateid},</if>
            <if test="templatequestionnum != null">templatequestionnum = #{templatequestionnum},</if>
            <if test="switchid != null">switchid = #{switchid},</if>
            <if test="questiontext != null">questiontext = #{questiontext},</if>
            <if test="questionvoice != null">questionvoice = #{questionvoice},</if>
            <if test="categoryname != null">categoryname = #{categoryname},</if>
            <if test="targetoptions != null">targetoptions = #{targetoptions},</if>
            <if test="targetvalue != null">targetvalue = #{targetvalue},</if>
            <if test="matchedtext != null">matchedtext = #{matchedtext},</if>
            <if test="addtime != null">addtime = #{addtime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="delFlag != null">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="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="valueType != null">value_type = #{valueType},</if>
        </trim>
        where calldetailid = #{calldetailid}
    </update>

    <delete id="deleteSvyTasksingledetailByCalldetailid" parameterType="String">
        delete from svy_tasksingledetail where calldetailid = #{calldetailid}
    </delete>

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