From 77187eabbf216b5d8283e69708132e2ca75b5f95 Mon Sep 17 00:00:00 2001 From: yxh <172933527@qq.com> Date: 星期三, 22 三月 2023 13:07:00 +0800 Subject: [PATCH] yxh --- smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml | 208 + smartor/src/main/java/com/smartor/domain/IvrLibaScript.java | 424 +++ smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplateMapper.java | 61 smartor/src/main/java/com/smartor/service/IIvrLibaTemplateService.java | 61 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplateController.java | 104 smartor/src/main/resources/mapper/smartor/IvrLibaExtemplateMapper.xml | 143 + smartor/src/main/java/com/smartor/mapper/IvrLibaScriptMapper.java | 61 smartor/src/main/java/com/smartor/domain/IvrLibaScripttarget.java | 281 ++ smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatescriptServiceImpl.java | 96 smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplatescriptMapper.java | 61 smartor/src/main/resources/mapper/smartor/IvrLibaScripttargetMapper.xml | 153 + smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplateServiceImpl.java | 96 smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatetargetServiceImpl.java | 96 smartor/src/main/java/com/smartor/service/IIvrLibaExtemplatescriptService.java | 61 smartor/src/main/java/com/smartor/domain/IvrLibaTemplatescript.java | 379 +++ ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplateController.java | 104 smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java | 324 ++ ruoyi-admin/src/main/resources/application.yml | 6 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplatescriptController.java | 104 smartor/src/main/java/com/smartor/domain/IvrLibaExtemplatescript.java | 197 + smartor/src/main/java/com/smartor/service/IIvrLibaScriptService.java | 61 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatescriptController.java | 104 smartor/src/main/java/com/smartor/service/IIvrLibaTemplatescriptService.java | 61 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptController.java | 104 smartor/src/main/resources/mapper/smartor/IvrLibaExtemplatescriptMapper.xml | 123 + smartor/src/main/resources/mapper/smartor/IvrLibaTemplatetargetMapper.xml | 193 + ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatetargetController.java | 104 smartor/src/main/java/com/smartor/service/IIvrLibaScripttargetService.java | 61 smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java | 422 +++ smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java | 96 smartor/src/main/java/com/smartor/service/impl/IvrLibaScripttargetServiceImpl.java | 96 smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java | 96 smartor/src/main/java/com/smartor/mapper/IvrLibaScripttargetMapper.java | 61 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTargetController.java | 104 smartor/src/main/java/com/smartor/domain/IvrLibaExtemplate.java | 240 ++ smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatetargetMapper.java | 61 smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplatescriptServiceImpl.java | 96 smartor/src/main/java/com/smartor/mapper/IvrLibaTargetMapper.java | 61 smartor/src/main/java/com/smartor/service/IIvrLibaExtemplateService.java | 61 smartor/src/main/java/com/smartor/service/IIvrLibaTargetService.java | 61 smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml | 207 + smartor/src/main/java/com/smartor/service/IIvrLibaTemplatetargetService.java | 61 smartor/src/main/resources/mapper/smartor/IvrLibaTemplatescriptMapper.xml | 188 + smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplateServiceImpl.java | 96 smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml | 173 + smartor/src/main/java/com/smartor/mapper/IvrLibaTemplateMapper.java | 61 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScripttargetController.java | 104 smartor/src/main/java/com/smartor/domain/IvrLibaTemplatetarget.java | 393 +++ smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatescriptMapper.java | 61 49 files changed, 6,627 insertions(+), 3 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplateController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplateController.java new file mode 100644 index 0000000..5ce0478 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplateController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaExtemplate; +import com.smartor.service.IIvrLibaExtemplateService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 鎵╁睍璇濇湳妯℃澘搴揅ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrextemplate") +public class IvrLibaExtemplateController extends BaseController +{ + @Autowired + private IIvrLibaExtemplateService ivrLibaExtemplateService; + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaExtemplate ivrLibaExtemplate) + { + startPage(); + List<IvrLibaExtemplate> list = ivrLibaExtemplateService.selectIvrLibaExtemplateList(ivrLibaExtemplate); + return getDataTable(list); + } + + /** + * 瀵煎嚭鎵╁睍璇濇湳妯℃澘搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:export')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaExtemplate ivrLibaExtemplate) + { + List<IvrLibaExtemplate> list = ivrLibaExtemplateService.selectIvrLibaExtemplateList(ivrLibaExtemplate); + ExcelUtil<IvrLibaExtemplate> util = new ExcelUtil<IvrLibaExtemplate>(IvrLibaExtemplate.class); + util.exportExcel(response, list, "鎵╁睍璇濇湳妯℃澘搴撴暟鎹�"); + } + + /** + * 鑾峰彇鎵╁睍璇濇湳妯℃澘搴撹缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:query')") + @GetMapping(value = "/{subModuleID}") + public AjaxResult getInfo(@PathVariable("subModuleID") String subModuleID) + { + return success(ivrLibaExtemplateService.selectIvrLibaExtemplateBySubModuleID(subModuleID)); + } + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:add')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaExtemplate ivrLibaExtemplate) + { + return toAjax(ivrLibaExtemplateService.insertIvrLibaExtemplate(ivrLibaExtemplate)); + } + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:edit')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaExtemplate ivrLibaExtemplate) + { + return toAjax(ivrLibaExtemplateService.updateIvrLibaExtemplate(ivrLibaExtemplate)); + } + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplate:remove')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴�", businessType = BusinessType.DELETE) + @DeleteMapping("/{subModuleIDs}") + public AjaxResult remove(@PathVariable String[] subModuleIDs) + { + return toAjax(ivrLibaExtemplateService.deleteIvrLibaExtemplateBySubModuleIDs(subModuleIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplatescriptController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplatescriptController.java new file mode 100644 index 0000000..f9be8dc --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaExtemplatescriptController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaExtemplatescript; +import com.smartor.service.IIvrLibaExtemplatescriptService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈疌ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrextemplatescript") +public class IvrLibaExtemplatescriptController extends BaseController +{ + @Autowired + private IIvrLibaExtemplatescriptService ivrLibaExtemplatescriptService; + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + startPage(); + List<IvrLibaExtemplatescript> list = ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript); + return getDataTable(list); + } + + /** + * 瀵煎嚭鎵╁睍璇濇湳妯℃澘搴撹瘽鏈垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:export')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + List<IvrLibaExtemplatescript> list = ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript); + ExcelUtil<IvrLibaExtemplatescript> util = new ExcelUtil<IvrLibaExtemplatescript>(IvrLibaExtemplatescript.class); + util.exportExcel(response, list, "鎵╁睍璇濇湳妯℃澘搴撹瘽鏈暟鎹�"); + } + + /** + * 鑾峰彇鎵╁睍璇濇湳妯℃澘搴撹瘽鏈缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:query')") + @GetMapping(value = "/{DetailID}") + public AjaxResult getInfo(@PathVariable("DetailID") String DetailID) + { + return success(ivrLibaExtemplatescriptService.selectIvrLibaExtemplatescriptByDetailID(DetailID)); + } + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:add')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + return toAjax(ivrLibaExtemplatescriptService.insertIvrLibaExtemplatescript(ivrLibaExtemplatescript)); + } + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:edit')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + return toAjax(ivrLibaExtemplatescriptService.updateIvrLibaExtemplatescript(ivrLibaExtemplatescript)); + } + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrextemplatescript:remove')") + @Log(title = "鎵╁睍璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.DELETE) + @DeleteMapping("/{DetailIDs}") + public AjaxResult remove(@PathVariable String[] DetailIDs) + { + return toAjax(ivrLibaExtemplatescriptService.deleteIvrLibaExtemplatescriptByDetailIDs(DetailIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptController.java new file mode 100644 index 0000000..96ab960 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaScript; +import com.smartor.service.IIvrLibaScriptService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璇濇湳搴揅ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrlibascript") +public class IvrLibaScriptController extends BaseController +{ + @Autowired + private IIvrLibaScriptService ivrLibaScriptService; + + /** + * 鏌ヨ璇濇湳搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaScript ivrLibaScript) + { + startPage(); + List<IvrLibaScript> list = ivrLibaScriptService.selectIvrLibaScriptList(ivrLibaScript); + return getDataTable(list); + } + + /** + * 瀵煎嚭璇濇湳搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:export')") + @Log(title = "璇濇湳搴�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaScript ivrLibaScript) + { + List<IvrLibaScript> list = ivrLibaScriptService.selectIvrLibaScriptList(ivrLibaScript); + ExcelUtil<IvrLibaScript> util = new ExcelUtil<IvrLibaScript>(IvrLibaScript.class); + util.exportExcel(response, list, "璇濇湳搴撴暟鎹�"); + } + + /** + * 鑾峰彇璇濇湳搴撹缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:query')") + @GetMapping(value = "/{questionid}") + public AjaxResult getInfo(@PathVariable("questionid") String questionid) + { + return success(ivrLibaScriptService.selectIvrLibaScriptByQuestionid(questionid)); + } + + /** + * 鏂板璇濇湳搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:add')") + @Log(title = "璇濇湳搴�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaScript ivrLibaScript) + { + return toAjax(ivrLibaScriptService.insertIvrLibaScript(ivrLibaScript)); + } + + /** + * 淇敼璇濇湳搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:edit')") + @Log(title = "璇濇湳搴�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaScript ivrLibaScript) + { + return toAjax(ivrLibaScriptService.updateIvrLibaScript(ivrLibaScript)); + } + + /** + * 鍒犻櫎璇濇湳搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrlibascript:remove')") + @Log(title = "璇濇湳搴�", businessType = BusinessType.DELETE) + @DeleteMapping("/{questionids}") + public AjaxResult remove(@PathVariable String[] questionids) + { + return toAjax(ivrLibaScriptService.deleteIvrLibaScriptByQuestionids(questionids)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScripttargetController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScripttargetController.java new file mode 100644 index 0000000..d911cfc --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScripttargetController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaScripttarget; +import com.smartor.service.IIvrLibaScripttargetService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璇濇湳搴撹瘽鏈寚鏍嘋ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrscripttarget") +public class IvrLibaScripttargetController extends BaseController +{ + @Autowired + private IIvrLibaScripttargetService ivrLibaScripttargetService; + + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍囧垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaScripttarget ivrLibaScripttarget) + { + startPage(); + List<IvrLibaScripttarget> list = ivrLibaScripttargetService.selectIvrLibaScripttargetList(ivrLibaScripttarget); + return getDataTable(list); + } + + /** + * 瀵煎嚭璇濇湳搴撹瘽鏈寚鏍囧垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:export')") + @Log(title = "璇濇湳搴撹瘽鏈寚鏍�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaScripttarget ivrLibaScripttarget) + { + List<IvrLibaScripttarget> list = ivrLibaScripttargetService.selectIvrLibaScripttargetList(ivrLibaScripttarget); + ExcelUtil<IvrLibaScripttarget> util = new ExcelUtil<IvrLibaScripttarget>(IvrLibaScripttarget.class); + util.exportExcel(response, list, "璇濇湳搴撹瘽鏈寚鏍囨暟鎹�"); + } + + /** + * 鑾峰彇璇濇湳搴撹瘽鏈寚鏍囪缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:query')") + @GetMapping(value = "/{questionTargetID}") + public AjaxResult getInfo(@PathVariable("questionTargetID") String questionTargetID) + { + return success(ivrLibaScripttargetService.selectIvrLibaScripttargetByQuestionTargetID(questionTargetID)); + } + + /** + * 鏂板璇濇湳搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:add')") + @Log(title = "璇濇湳搴撹瘽鏈寚鏍�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaScripttarget ivrLibaScripttarget) + { + return toAjax(ivrLibaScripttargetService.insertIvrLibaScripttarget(ivrLibaScripttarget)); + } + + /** + * 淇敼璇濇湳搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:edit')") + @Log(title = "璇濇湳搴撹瘽鏈寚鏍�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaScripttarget ivrLibaScripttarget) + { + return toAjax(ivrLibaScripttargetService.updateIvrLibaScripttarget(ivrLibaScripttarget)); + } + + /** + * 鍒犻櫎璇濇湳搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrscripttarget:remove')") + @Log(title = "璇濇湳搴撹瘽鏈寚鏍�", businessType = BusinessType.DELETE) + @DeleteMapping("/{questionTargetIDs}") + public AjaxResult remove(@PathVariable String[] questionTargetIDs) + { + return toAjax(ivrLibaScripttargetService.deleteIvrLibaScripttargetByQuestionTargetIDs(questionTargetIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTargetController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTargetController.java new file mode 100644 index 0000000..178c7e2 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTargetController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaTarget; +import com.smartor.service.IIvrLibaTargetService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 鎸囨爣搴揅ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrtarget") +public class IvrLibaTargetController extends BaseController +{ + @Autowired + private IIvrLibaTargetService ivrLibaTargetService; + + /** + * 鏌ヨ鎸囨爣搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaTarget ivrLibaTarget) + { + startPage(); + List<IvrLibaTarget> list = ivrLibaTargetService.selectIvrLibaTargetList(ivrLibaTarget); + return getDataTable(list); + } + + /** + * 瀵煎嚭鎸囨爣搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:export')") + @Log(title = "鎸囨爣搴�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaTarget ivrLibaTarget) + { + List<IvrLibaTarget> list = ivrLibaTargetService.selectIvrLibaTargetList(ivrLibaTarget); + ExcelUtil<IvrLibaTarget> util = new ExcelUtil<IvrLibaTarget>(IvrLibaTarget.class); + util.exportExcel(response, list, "鎸囨爣搴撴暟鎹�"); + } + + /** + * 鑾峰彇鎸囨爣搴撹缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:query')") + @GetMapping(value = "/{targetID}") + public AjaxResult getInfo(@PathVariable("targetID") String targetID) + { + return success(ivrLibaTargetService.selectIvrLibaTargetByTargetID(targetID)); + } + + /** + * 鏂板鎸囨爣搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:add')") + @Log(title = "鎸囨爣搴�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaTarget ivrLibaTarget) + { + return toAjax(ivrLibaTargetService.insertIvrLibaTarget(ivrLibaTarget)); + } + + /** + * 淇敼鎸囨爣搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:edit')") + @Log(title = "鎸囨爣搴�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaTarget ivrLibaTarget) + { + return toAjax(ivrLibaTargetService.updateIvrLibaTarget(ivrLibaTarget)); + } + + /** + * 鍒犻櫎鎸囨爣搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtarget:remove')") + @Log(title = "鎸囨爣搴�", businessType = BusinessType.DELETE) + @DeleteMapping("/{targetIDs}") + public AjaxResult remove(@PathVariable String[] targetIDs) + { + return toAjax(ivrLibaTargetService.deleteIvrLibaTargetByTargetIDs(targetIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplateController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplateController.java new file mode 100644 index 0000000..35963a7 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplateController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaTemplate; +import com.smartor.service.IIvrLibaTemplateService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璇濇湳妯℃澘搴揅ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrtemplate") +public class IvrLibaTemplateController extends BaseController +{ + @Autowired + private IIvrLibaTemplateService ivrLibaTemplateService; + + /** + * 鏌ヨ璇濇湳妯℃澘搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaTemplate ivrLibaTemplate) + { + startPage(); + List<IvrLibaTemplate> list = ivrLibaTemplateService.selectIvrLibaTemplateList(ivrLibaTemplate); + return getDataTable(list); + } + + /** + * 瀵煎嚭璇濇湳妯℃澘搴撳垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:export')") + @Log(title = "璇濇湳妯℃澘搴�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaTemplate ivrLibaTemplate) + { + List<IvrLibaTemplate> list = ivrLibaTemplateService.selectIvrLibaTemplateList(ivrLibaTemplate); + ExcelUtil<IvrLibaTemplate> util = new ExcelUtil<IvrLibaTemplate>(IvrLibaTemplate.class); + util.exportExcel(response, list, "璇濇湳妯℃澘搴撴暟鎹�"); + } + + /** + * 鑾峰彇璇濇湳妯℃澘搴撹缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:query')") + @GetMapping(value = "/{templateID}") + public AjaxResult getInfo(@PathVariable("templateID") String templateID) + { + return success(ivrLibaTemplateService.selectIvrLibaTemplateByTemplateID(templateID)); + } + + /** + * 鏂板璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:add')") + @Log(title = "璇濇湳妯℃澘搴�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaTemplate ivrLibaTemplate) + { + return toAjax(ivrLibaTemplateService.insertIvrLibaTemplate(ivrLibaTemplate)); + } + + /** + * 淇敼璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:edit')") + @Log(title = "璇濇湳妯℃澘搴�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaTemplate ivrLibaTemplate) + { + return toAjax(ivrLibaTemplateService.updateIvrLibaTemplate(ivrLibaTemplate)); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplate:remove')") + @Log(title = "璇濇湳妯℃澘搴�", businessType = BusinessType.DELETE) + @DeleteMapping("/{templateIDs}") + public AjaxResult remove(@PathVariable String[] templateIDs) + { + return toAjax(ivrLibaTemplateService.deleteIvrLibaTemplateByTemplateIDs(templateIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatescriptController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatescriptController.java new file mode 100644 index 0000000..369e067 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatescriptController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaTemplatescript; +import com.smartor.service.IIvrLibaTemplatescriptService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈疌ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrtemplatescript") +public class IvrLibaTemplatescriptController extends BaseController +{ + @Autowired + private IIvrLibaTemplatescriptService ivrLibaTemplatescriptService; + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaTemplatescript ivrLibaTemplatescript) + { + startPage(); + List<IvrLibaTemplatescript> list = ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript); + return getDataTable(list); + } + + /** + * 瀵煎嚭璇濇湳妯℃澘搴撹瘽鏈垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:export')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaTemplatescript ivrLibaTemplatescript) + { + List<IvrLibaTemplatescript> list = ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript); + ExcelUtil<IvrLibaTemplatescript> util = new ExcelUtil<IvrLibaTemplatescript>(IvrLibaTemplatescript.class); + util.exportExcel(response, list, "璇濇湳妯℃澘搴撹瘽鏈暟鎹�"); + } + + /** + * 鑾峰彇璇濇湳妯℃澘搴撹瘽鏈缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:query')") + @GetMapping(value = "/{templateQuestionID}") + public AjaxResult getInfo(@PathVariable("templateQuestionID") String templateQuestionID) + { + return success(ivrLibaTemplatescriptService.selectIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID)); + } + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:add')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaTemplatescript ivrLibaTemplatescript) + { + return toAjax(ivrLibaTemplatescriptService.insertIvrLibaTemplatescript(ivrLibaTemplatescript)); + } + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:edit')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaTemplatescript ivrLibaTemplatescript) + { + return toAjax(ivrLibaTemplatescriptService.updateIvrLibaTemplatescript(ivrLibaTemplatescript)); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatescript:remove')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈�", businessType = BusinessType.DELETE) + @DeleteMapping("/{templateQuestionIDs}") + public AjaxResult remove(@PathVariable String[] templateQuestionIDs) + { + return toAjax(ivrLibaTemplatescriptService.deleteIvrLibaTemplatescriptByTemplateQuestionIDs(templateQuestionIDs)); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatetargetController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatetargetController.java new file mode 100644 index 0000000..0c3e3f1 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaTemplatetargetController.java @@ -0,0 +1,104 @@ +package com.smartor.controller; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.IvrLibaTemplatetarget; +import com.smartor.service.IIvrLibaTemplatetargetService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈寚鏍嘋ontroller + * + * @author smartor + * @date 2023-03-22 + */ +@RestController +@RequestMapping("/smartor/ivrtemplatetarget") +public class IvrLibaTemplatetargetController extends BaseController +{ + @Autowired + private IIvrLibaTemplatetargetService ivrLibaTemplatetargetService; + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍囧垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:list')") + @GetMapping("/list") + public TableDataInfo list(IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + startPage(); + List<IvrLibaTemplatetarget> list = ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget); + return getDataTable(list); + } + + /** + * 瀵煎嚭璇濇湳妯℃澘搴撹瘽鏈寚鏍囧垪琛� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:export')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈寚鏍�", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + List<IvrLibaTemplatetarget> list = ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget); + ExcelUtil<IvrLibaTemplatetarget> util = new ExcelUtil<IvrLibaTemplatetarget>(IvrLibaTemplatetarget.class); + util.exportExcel(response, list, "璇濇湳妯℃澘搴撹瘽鏈寚鏍囨暟鎹�"); + } + + /** + * 鑾峰彇璇濇湳妯℃澘搴撹瘽鏈寚鏍囪缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:query')") + @GetMapping(value = "/{templateTargetID}") + public AjaxResult getInfo(@PathVariable("templateTargetID") String templateTargetID) + { + return success(ivrLibaTemplatetargetService.selectIvrLibaTemplatetargetByTemplateTargetID(templateTargetID)); + } + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:add')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈寚鏍�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + return toAjax(ivrLibaTemplatetargetService.insertIvrLibaTemplatetarget(ivrLibaTemplatetarget)); + } + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:edit')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈寚鏍�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + return toAjax(ivrLibaTemplatetargetService.updateIvrLibaTemplatetarget(ivrLibaTemplatetarget)); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + @PreAuthorize("@ss.hasPermi('smartor:ivrtemplatetarget:remove')") + @Log(title = "璇濇湳妯℃澘搴撹瘽鏈寚鏍�", businessType = BusinessType.DELETE) + @DeleteMapping("/{templateTargetIDs}") + public AjaxResult remove(@PathVariable String[] templateTargetIDs) + { + return toAjax(ivrLibaTemplatetargetService.deleteIvrLibaTemplatetargetByTemplateTargetIDs(templateTargetIDs)); + } +} diff --git a/ruoyi-admin/src/main/resources/application.yml b/ruoyi-admin/src/main/resources/application.yml index 9dffcb8..f54c5cb 100644 --- a/ruoyi-admin/src/main/resources/application.yml +++ b/ruoyi-admin/src/main/resources/application.yml @@ -70,13 +70,13 @@ # redis 閰嶇疆 redis: # 鍦板潃 - host: localhost + host: 116.62.18.175 # 绔彛锛岄粯璁や负6379 - port: 6379 + port: 6020 # 鏁版嵁搴撶储寮� database: 0 # 瀵嗙爜 - password: + password: Smartor # 杩炴帴瓒呮椂鏃堕棿 timeout: 10s lettuce: diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplate.java b/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplate.java new file mode 100644 index 0000000..0d45509 --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplate.java @@ -0,0 +1,240 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撳璞� ivr_liba_extemplate + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaExtemplate extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String subModuleID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String subModuleName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String language; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long version; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String addUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date addTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String modifyUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date modifyTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long GroupID; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setSubModuleID(String subModuleID) + { + this.subModuleID = subModuleID; + } + + public String getSubModuleID() + { + return subModuleID; + } + public void setSubModuleName(String subModuleName) + { + this.subModuleName = subModuleName; + } + + public String getSubModuleName() + { + return subModuleName; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setVersion(Long version) + { + this.version = version; + } + + public Long getVersion() + { + return version; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setAddUserID(String addUserID) + { + this.addUserID = addUserID; + } + + public String getAddUserID() + { + return addUserID; + } + public void setAddTime(Date addTime) + { + this.addTime = addTime; + } + + public Date getAddTime() + { + return addTime; + } + public void setModifyUserID(String modifyUserID) + { + this.modifyUserID = modifyUserID; + } + + public String getModifyUserID() + { + return modifyUserID; + } + public void setModifyTime(Date modifyTime) + { + this.modifyTime = modifyTime; + } + + public Date getModifyTime() + { + return modifyTime; + } + public void setGroupID(Long GroupID) + { + this.GroupID = GroupID; + } + + public Long getGroupID() + { + return GroupID; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("subModuleID", getSubModuleID()) + .append("subModuleName", getSubModuleName()) + .append("language", getLanguage()) + .append("description", getDescription()) + .append("version", getVersion()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("addUserID", getAddUserID()) + .append("addTime", getAddTime()) + .append("modifyUserID", getModifyUserID()) + .append("modifyTime", getModifyTime()) + .append("GroupID", getGroupID()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplatescript.java b/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplatescript.java new file mode 100644 index 0000000..c5d0a3c --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaExtemplatescript.java @@ -0,0 +1,197 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈璞� ivr_liba_extemplatescript + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaExtemplatescript extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String DetailID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String subModuleID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long switchID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String switchText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String switchWav; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String selfRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setDetailID(String DetailID) + { + this.DetailID = DetailID; + } + + public String getDetailID() + { + return DetailID; + } + public void setSubModuleID(String subModuleID) + { + this.subModuleID = subModuleID; + } + + public String getSubModuleID() + { + return subModuleID; + } + public void setSwitchID(Long switchID) + { + this.switchID = switchID; + } + + public Long getSwitchID() + { + return switchID; + } + public void setSwitchText(String switchText) + { + this.switchText = switchText; + } + + public String getSwitchText() + { + return switchText; + } + public void setSwitchWav(String switchWav) + { + this.switchWav = switchWav; + } + + public String getSwitchWav() + { + return switchWav; + } + public void setSelfRegex(String selfRegex) + { + this.selfRegex = selfRegex; + } + + public String getSelfRegex() + { + return selfRegex; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("DetailID", getDetailID()) + .append("subModuleID", getSubModuleID()) + .append("switchID", getSwitchID()) + .append("switchText", getSwitchText()) + .append("switchWav", getSwitchWav()) + .append("selfRegex", getSelfRegex()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java new file mode 100644 index 0000000..baf10b3 --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java @@ -0,0 +1,424 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 璇濇湳搴撳璞� ivr_liba_script + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaScript extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** */ + private String questionid; + + /** */ + @Excel(name = " ") + private String questionpoint; + + /** */ + @Excel(name = " ") + private String questiontext; + + /** */ + @Excel(name = " ") + private String questionvoice; + + /** */ + @Excel(name = " ") + private String nomatchtext; + + /** */ + @Excel(name = " ") + private String nomatchvoice; + + /** */ + @Excel(name = " ") + private String sliencetext; + + /** */ + @Excel(name = " ") + private String sliencevoice; + + /** */ + @Excel(name = " ") + private String submoduletext; + + /** */ + @Excel(name = " ") + private String submodulevoice; + + /** */ + @Excel(name = " ") + private String noclearlytext; + + /** */ + @Excel(name = " ") + private String noclearlyvoice; + + /** */ + @Excel(name = " ") + private String questiontype; + + /** */ + @Excel(name = " ") + private String categoryname; + + /** */ + @Excel(name = " ") + private String targetoptions; + + /** */ + @Excel(name = " ") + private String language; + + /** */ + @Excel(name = " ") + private Long version; + + /** */ + @Excel(name = " ") + private Long isenable; + + /** */ + @Excel(name = " ") + private Long isdel; + + /** */ + @Excel(name = " ") + private String adduserid; + + /** */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " ", width = 30, dateFormat = "yyyy-MM-dd") + private Date addtime; + + /** */ + @Excel(name = " ") + private String modifyuserid; + + /** */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " ", width = 30, dateFormat = "yyyy-MM-dd") + private Date modifytime; + + /** */ + @Excel(name = " ") + private String groupid; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setQuestionid(String questionid) + { + this.questionid = questionid; + } + + public String getQuestionid() + { + return questionid; + } + public void setQuestionpoint(String questionpoint) + { + this.questionpoint = questionpoint; + } + + public String getQuestionpoint() + { + return questionpoint; + } + public void setQuestiontext(String questiontext) + { + this.questiontext = questiontext; + } + + public String getQuestiontext() + { + return questiontext; + } + public void setQuestionvoice(String questionvoice) + { + this.questionvoice = questionvoice; + } + + public String getQuestionvoice() + { + return questionvoice; + } + public void setNomatchtext(String nomatchtext) + { + this.nomatchtext = nomatchtext; + } + + public String getNomatchtext() + { + return nomatchtext; + } + public void setNomatchvoice(String nomatchvoice) + { + this.nomatchvoice = nomatchvoice; + } + + public String getNomatchvoice() + { + return nomatchvoice; + } + public void setSliencetext(String sliencetext) + { + this.sliencetext = sliencetext; + } + + public String getSliencetext() + { + return sliencetext; + } + public void setSliencevoice(String sliencevoice) + { + this.sliencevoice = sliencevoice; + } + + public String getSliencevoice() + { + return sliencevoice; + } + public void setSubmoduletext(String submoduletext) + { + this.submoduletext = submoduletext; + } + + public String getSubmoduletext() + { + return submoduletext; + } + public void setSubmodulevoice(String submodulevoice) + { + this.submodulevoice = submodulevoice; + } + + public String getSubmodulevoice() + { + return submodulevoice; + } + public void setNoclearlytext(String noclearlytext) + { + this.noclearlytext = noclearlytext; + } + + public String getNoclearlytext() + { + return noclearlytext; + } + public void setNoclearlyvoice(String noclearlyvoice) + { + this.noclearlyvoice = noclearlyvoice; + } + + public String getNoclearlyvoice() + { + return noclearlyvoice; + } + public void setQuestiontype(String questiontype) + { + this.questiontype = questiontype; + } + + public String getQuestiontype() + { + return questiontype; + } + public void setCategoryname(String categoryname) + { + this.categoryname = categoryname; + } + + public String getCategoryname() + { + return categoryname; + } + public void setTargetoptions(String targetoptions) + { + this.targetoptions = targetoptions; + } + + public String getTargetoptions() + { + return targetoptions; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setVersion(Long version) + { + this.version = version; + } + + public Long getVersion() + { + return version; + } + public void setIsenable(Long isenable) + { + this.isenable = isenable; + } + + public Long getIsenable() + { + return isenable; + } + public void setIsdel(Long isdel) + { + this.isdel = isdel; + } + + public Long getIsdel() + { + return isdel; + } + public void setAdduserid(String adduserid) + { + this.adduserid = adduserid; + } + + public String getAdduserid() + { + return adduserid; + } + public void setAddtime(Date addtime) + { + this.addtime = addtime; + } + + public Date getAddtime() + { + return addtime; + } + public void setModifyuserid(String modifyuserid) + { + this.modifyuserid = modifyuserid; + } + + public String getModifyuserid() + { + return modifyuserid; + } + public void setModifytime(Date modifytime) + { + this.modifytime = modifytime; + } + + public Date getModifytime() + { + return modifytime; + } + public void setGroupid(String groupid) + { + this.groupid = groupid; + } + + public String getGroupid() + { + return groupid; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("questionid", getQuestionid()) + .append("questionpoint", getQuestionpoint()) + .append("questiontext", getQuestiontext()) + .append("questionvoice", getQuestionvoice()) + .append("nomatchtext", getNomatchtext()) + .append("nomatchvoice", getNomatchvoice()) + .append("sliencetext", getSliencetext()) + .append("sliencevoice", getSliencevoice()) + .append("submoduletext", getSubmoduletext()) + .append("submodulevoice", getSubmodulevoice()) + .append("noclearlytext", getNoclearlytext()) + .append("noclearlyvoice", getNoclearlyvoice()) + .append("questiontype", getQuestiontype()) + .append("categoryname", getCategoryname()) + .append("targetoptions", getTargetoptions()) + .append("language", getLanguage()) + .append("description", getDescription()) + .append("version", getVersion()) + .append("isenable", getIsenable()) + .append("isdel", getIsdel()) + .append("adduserid", getAdduserid()) + .append("addtime", getAddtime()) + .append("modifyuserid", getModifyuserid()) + .append("modifytime", getModifytime()) + .append("groupid", getGroupid()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScripttarget.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScripttarget.java new file mode 100644 index 0000000..da4d86f --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaScripttarget.java @@ -0,0 +1,281 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 璇濇湳搴撹瘽鏈寚鏍囧璞� ivr_liba_scripttarget + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaScripttarget extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String questionTargetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String categoryName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetValue; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String basicRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String selfRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String regexUsedType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long sort; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long version; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String tipsJson; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setQuestionTargetID(String questionTargetID) + { + this.questionTargetID = questionTargetID; + } + + public String getQuestionTargetID() + { + return questionTargetID; + } + public void setQuestionID(String questionID) + { + this.questionID = questionID; + } + + public String getQuestionID() + { + return questionID; + } + public void setTargetID(String targetID) + { + this.targetID = targetID; + } + + public String getTargetID() + { + return targetID; + } + public void setTargetType(String targetType) + { + this.targetType = targetType; + } + + public String getTargetType() + { + return targetType; + } + public void setCategoryName(String categoryName) + { + this.categoryName = categoryName; + } + + public String getCategoryName() + { + return categoryName; + } + public void setTargetValue(String targetValue) + { + this.targetValue = targetValue; + } + + public String getTargetValue() + { + return targetValue; + } + public void setBasicRegex(String basicRegex) + { + this.basicRegex = basicRegex; + } + + public String getBasicRegex() + { + return basicRegex; + } + public void setSelfRegex(String selfRegex) + { + this.selfRegex = selfRegex; + } + + public String getSelfRegex() + { + return selfRegex; + } + public void setRegexUsedType(String regexUsedType) + { + this.regexUsedType = regexUsedType; + } + + public String getRegexUsedType() + { + return regexUsedType; + } + public void setSort(Long sort) + { + this.sort = sort; + } + + public Long getSort() + { + return sort; + } + public void setVersion(Long version) + { + this.version = version; + } + + public Long getVersion() + { + return version; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setTipsJson(String tipsJson) + { + this.tipsJson = tipsJson; + } + + public String getTipsJson() + { + return tipsJson; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("questionTargetID", getQuestionTargetID()) + .append("questionID", getQuestionID()) + .append("targetID", getTargetID()) + .append("targetType", getTargetType()) + .append("categoryName", getCategoryName()) + .append("targetValue", getTargetValue()) + .append("basicRegex", getBasicRegex()) + .append("selfRegex", getSelfRegex()) + .append("regexUsedType", getRegexUsedType()) + .append("sort", getSort()) + .append("version", getVersion()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("tipsJson", getTipsJson()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java new file mode 100644 index 0000000..458cb7d --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java @@ -0,0 +1,324 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 鎸囨爣搴撳璞� ivr_liba_target + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaTarget extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String targetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String categoryName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetValue; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String language; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long version; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String addUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date addTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String modifyUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date modifyTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String groupID; + + /** 鏄惁寮傚父鏍囪瘑 */ + @Excel(name = "鏄惁寮傚父鏍囪瘑") + private Long isAbnormal; + + /** 棰勮闃�鍊间笂闄� */ + @Excel(name = "棰勮闃�鍊间笂闄�") + private Long WarnUp; + + /** 棰勮闃�鍊间笅闄� */ + @Excel(name = "棰勮闃�鍊间笅闄�") + private Long WarnDown; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setTargetID(String targetID) + { + this.targetID = targetID; + } + + public String getTargetID() + { + return targetID; + } + public void setTargetType(String targetType) + { + this.targetType = targetType; + } + + public String getTargetType() + { + return targetType; + } + public void setCategoryName(String categoryName) + { + this.categoryName = categoryName; + } + + public String getCategoryName() + { + return categoryName; + } + public void setTargetValue(String targetValue) + { + this.targetValue = targetValue; + } + + public String getTargetValue() + { + return targetValue; + } + public void setTargetRegex(String targetRegex) + { + this.targetRegex = targetRegex; + } + + public String getTargetRegex() + { + return targetRegex; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setVersion(Long version) + { + this.version = version; + } + + public Long getVersion() + { + return version; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setAddUserID(String addUserID) + { + this.addUserID = addUserID; + } + + public String getAddUserID() + { + return addUserID; + } + public void setAddTime(Date addTime) + { + this.addTime = addTime; + } + + public Date getAddTime() + { + return addTime; + } + public void setModifyUserID(String modifyUserID) + { + this.modifyUserID = modifyUserID; + } + + public String getModifyUserID() + { + return modifyUserID; + } + public void setModifyTime(Date modifyTime) + { + this.modifyTime = modifyTime; + } + + public Date getModifyTime() + { + return modifyTime; + } + public void setGroupID(String groupID) + { + this.groupID = groupID; + } + + public String getGroupID() + { + return groupID; + } + public void setIsAbnormal(Long isAbnormal) + { + this.isAbnormal = isAbnormal; + } + + public Long getIsAbnormal() + { + return isAbnormal; + } + public void setWarnUp(Long WarnUp) + { + this.WarnUp = WarnUp; + } + + public Long getWarnUp() + { + return WarnUp; + } + public void setWarnDown(Long WarnDown) + { + this.WarnDown = WarnDown; + } + + public Long getWarnDown() + { + return WarnDown; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("targetID", getTargetID()) + .append("targetType", getTargetType()) + .append("categoryName", getCategoryName()) + .append("targetValue", getTargetValue()) + .append("targetRegex", getTargetRegex()) + .append("description", getDescription()) + .append("language", getLanguage()) + .append("version", getVersion()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("addUserID", getAddUserID()) + .append("addTime", getAddTime()) + .append("modifyUserID", getModifyUserID()) + .append("modifyTime", getModifyTime()) + .append("groupID", getGroupID()) + .append("isAbnormal", getIsAbnormal()) + .append("WarnUp", getWarnUp()) + .append("WarnDown", getWarnDown()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java new file mode 100644 index 0000000..916fa7c --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java @@ -0,0 +1,422 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 璇濇湳妯℃澘搴撳璞� ivr_liba_template + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaTemplate extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String templateID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String templateName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long silencetime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long slienceRepeatTimes; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long nomatchRepeatTimes; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long firstQuestionNum; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String submodule; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String language; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String addUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date addTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String modifyUserID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Date modifyTime; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String groupID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String labelInfo; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String submoduleID; + + /** 鎾姤绫诲瀷 0.璇煶浼樺厛 1.鏂囧瓧浼樺厛 */ + @Excel(name = "鎾姤绫诲瀷 0.璇煶浼樺厛 1.鏂囧瓧浼樺厛") + private Long playType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String icd10code; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String icd10codename; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long atuoTaskDayOffset; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String DeptIds; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String DeptNames; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String fKsdm; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setTemplateID(String templateID) + { + this.templateID = templateID; + } + + public String getTemplateID() + { + return templateID; + } + public void setTemplateName(String templateName) + { + this.templateName = templateName; + } + + public String getTemplateName() + { + return templateName; + } + public void setSilencetime(Long silencetime) + { + this.silencetime = silencetime; + } + + public Long getSilencetime() + { + return silencetime; + } + public void setSlienceRepeatTimes(Long slienceRepeatTimes) + { + this.slienceRepeatTimes = slienceRepeatTimes; + } + + public Long getSlienceRepeatTimes() + { + return slienceRepeatTimes; + } + public void setNomatchRepeatTimes(Long nomatchRepeatTimes) + { + this.nomatchRepeatTimes = nomatchRepeatTimes; + } + + public Long getNomatchRepeatTimes() + { + return nomatchRepeatTimes; + } + public void setFirstQuestionNum(Long firstQuestionNum) + { + this.firstQuestionNum = firstQuestionNum; + } + + public Long getFirstQuestionNum() + { + return firstQuestionNum; + } + public void setSubmodule(String submodule) + { + this.submodule = submodule; + } + + public String getSubmodule() + { + return submodule; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setAddUserID(String addUserID) + { + this.addUserID = addUserID; + } + + public String getAddUserID() + { + return addUserID; + } + public void setAddTime(Date addTime) + { + this.addTime = addTime; + } + + public Date getAddTime() + { + return addTime; + } + public void setModifyUserID(String modifyUserID) + { + this.modifyUserID = modifyUserID; + } + + public String getModifyUserID() + { + return modifyUserID; + } + public void setModifyTime(Date modifyTime) + { + this.modifyTime = modifyTime; + } + + public Date getModifyTime() + { + return modifyTime; + } + public void setGroupID(String groupID) + { + this.groupID = groupID; + } + + public String getGroupID() + { + return groupID; + } + public void setLabelInfo(String labelInfo) + { + this.labelInfo = labelInfo; + } + + public String getLabelInfo() + { + return labelInfo; + } + public void setSubmoduleID(String submoduleID) + { + this.submoduleID = submoduleID; + } + + public String getSubmoduleID() + { + return submoduleID; + } + public void setPlayType(Long playType) + { + this.playType = playType; + } + + public Long getPlayType() + { + return playType; + } + public void setIcd10code(String icd10code) + { + this.icd10code = icd10code; + } + + public String getIcd10code() + { + return icd10code; + } + public void setIcd10codename(String icd10codename) + { + this.icd10codename = icd10codename; + } + + public String getIcd10codename() + { + return icd10codename; + } + public void setAtuoTaskDayOffset(Long atuoTaskDayOffset) + { + this.atuoTaskDayOffset = atuoTaskDayOffset; + } + + public Long getAtuoTaskDayOffset() + { + return atuoTaskDayOffset; + } + public void setDeptIds(String DeptIds) + { + this.DeptIds = DeptIds; + } + + public String getDeptIds() + { + return DeptIds; + } + public void setDeptNames(String DeptNames) + { + this.DeptNames = DeptNames; + } + + public String getDeptNames() + { + return DeptNames; + } + public void setfKsdm(String fKsdm) + { + this.fKsdm = fKsdm; + } + + public String getfKsdm() + { + return fKsdm; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("templateID", getTemplateID()) + .append("templateName", getTemplateName()) + .append("silencetime", getSilencetime()) + .append("slienceRepeatTimes", getSlienceRepeatTimes()) + .append("nomatchRepeatTimes", getNomatchRepeatTimes()) + .append("firstQuestionNum", getFirstQuestionNum()) + .append("submodule", getSubmodule()) + .append("language", getLanguage()) + .append("description", getDescription()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("addUserID", getAddUserID()) + .append("addTime", getAddTime()) + .append("modifyUserID", getModifyUserID()) + .append("modifyTime", getModifyTime()) + .append("groupID", getGroupID()) + .append("labelInfo", getLabelInfo()) + .append("submoduleID", getSubmoduleID()) + .append("playType", getPlayType()) + .append("icd10code", getIcd10code()) + .append("icd10codename", getIcd10codename()) + .append("atuoTaskDayOffset", getAtuoTaskDayOffset()) + .append("DeptIds", getDeptIds()) + .append("DeptNames", getDeptNames()) + .append("fKsdm", getfKsdm()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatescript.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatescript.java new file mode 100644 index 0000000..5de221b --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatescript.java @@ -0,0 +1,379 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈璞� ivr_liba_templatescript + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaTemplatescript extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String templateQuestionID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long templateQuestionNum; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String templateID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionPoint; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionVoice; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String noMatchText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String noMatchVoice; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String slienceText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String slienceVoice; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String submoduleText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String submoduleVoice; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String noClearlyText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String noClearlyVoice; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String categoryName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetOptions; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String language; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long playWavOnly; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setTemplateQuestionID(String templateQuestionID) + { + this.templateQuestionID = templateQuestionID; + } + + public String getTemplateQuestionID() + { + return templateQuestionID; + } + public void setTemplateQuestionNum(Long templateQuestionNum) + { + this.templateQuestionNum = templateQuestionNum; + } + + public Long getTemplateQuestionNum() + { + return templateQuestionNum; + } + public void setTemplateID(String templateID) + { + this.templateID = templateID; + } + + public String getTemplateID() + { + return templateID; + } + public void setQuestionID(String questionID) + { + this.questionID = questionID; + } + + public String getQuestionID() + { + return questionID; + } + public void setQuestionPoint(String questionPoint) + { + this.questionPoint = questionPoint; + } + + public String getQuestionPoint() + { + return questionPoint; + } + public void setQuestionText(String questionText) + { + this.questionText = questionText; + } + + public String getQuestionText() + { + return questionText; + } + public void setQuestionVoice(String questionVoice) + { + this.questionVoice = questionVoice; + } + + public String getQuestionVoice() + { + return questionVoice; + } + public void setNoMatchText(String noMatchText) + { + this.noMatchText = noMatchText; + } + + public String getNoMatchText() + { + return noMatchText; + } + public void setNoMatchVoice(String noMatchVoice) + { + this.noMatchVoice = noMatchVoice; + } + + public String getNoMatchVoice() + { + return noMatchVoice; + } + public void setSlienceText(String slienceText) + { + this.slienceText = slienceText; + } + + public String getSlienceText() + { + return slienceText; + } + public void setSlienceVoice(String slienceVoice) + { + this.slienceVoice = slienceVoice; + } + + public String getSlienceVoice() + { + return slienceVoice; + } + public void setSubmoduleText(String submoduleText) + { + this.submoduleText = submoduleText; + } + + public String getSubmoduleText() + { + return submoduleText; + } + public void setSubmoduleVoice(String submoduleVoice) + { + this.submoduleVoice = submoduleVoice; + } + + public String getSubmoduleVoice() + { + return submoduleVoice; + } + public void setNoClearlyText(String noClearlyText) + { + this.noClearlyText = noClearlyText; + } + + public String getNoClearlyText() + { + return noClearlyText; + } + public void setNoClearlyVoice(String noClearlyVoice) + { + this.noClearlyVoice = noClearlyVoice; + } + + public String getNoClearlyVoice() + { + return noClearlyVoice; + } + public void setCategoryName(String categoryName) + { + this.categoryName = categoryName; + } + + public String getCategoryName() + { + return categoryName; + } + public void setTargetOptions(String targetOptions) + { + this.targetOptions = targetOptions; + } + + public String getTargetOptions() + { + return targetOptions; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setPlayWavOnly(Long playWavOnly) + { + this.playWavOnly = playWavOnly; + } + + public Long getPlayWavOnly() + { + return playWavOnly; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("templateQuestionID", getTemplateQuestionID()) + .append("templateQuestionNum", getTemplateQuestionNum()) + .append("templateID", getTemplateID()) + .append("questionID", getQuestionID()) + .append("questionPoint", getQuestionPoint()) + .append("questionText", getQuestionText()) + .append("questionVoice", getQuestionVoice()) + .append("noMatchText", getNoMatchText()) + .append("noMatchVoice", getNoMatchVoice()) + .append("slienceText", getSlienceText()) + .append("slienceVoice", getSlienceVoice()) + .append("submoduleText", getSubmoduleText()) + .append("submoduleVoice", getSubmoduleVoice()) + .append("noClearlyText", getNoClearlyText()) + .append("noClearlyVoice", getNoClearlyVoice()) + .append("categoryName", getCategoryName()) + .append("targetOptions", getTargetOptions()) + .append("language", getLanguage()) + .append("playWavOnly", getPlayWavOnly()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatetarget.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatetarget.java new file mode 100644 index 0000000..bef91a6 --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplatetarget.java @@ -0,0 +1,393 @@ +package com.smartor.domain; + +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈寚鏍囧璞� ivr_liba_templatetarget + * + * @author smartor + * @date 2023-03-22 + */ +public class IvrLibaTemplatetarget extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private String templateTargetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String templateQuestionID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long templateQuestionNum; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long nextQuestionNum; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String templateID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long switchID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String switchDescription; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String switchText; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String switchWav; + + /** 鑺傜偣寰呭尮閰嶈闊� */ + @Excel(name = "鑺傜偣寰呭尮閰嶈闊�") + private String switchTempWav; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String categoryName; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetValue; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String targetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String questionTargetID; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String basicRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String selfRegex; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String regexUsedType; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private String language; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isEnable; + + /** $column.columnComment */ + @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") + private Long isDel; + + /** 鎾姤绫诲瀷 0.璇煶浼樺厛 1.鏂囧瓧浼樺厛 */ + @Excel(name = "鎾姤绫诲瀷 0.璇煶浼樺厛 1.鏂囧瓧浼樺厛") + private Long playType; + + /** 鍒犻櫎鏍囪 */ + private String delFlag; + + /** 涓婁紶鏍囪 */ + @Excel(name = " 涓婁紶鏍囪 ") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd") + private Date uploadTime; + + /** 鏈烘瀯ID */ + @Excel(name = " 鏈烘瀯ID ") + private String orgid; + + public void setTemplateTargetID(String templateTargetID) + { + this.templateTargetID = templateTargetID; + } + + public String getTemplateTargetID() + { + return templateTargetID; + } + public void setTemplateQuestionID(String templateQuestionID) + { + this.templateQuestionID = templateQuestionID; + } + + public String getTemplateQuestionID() + { + return templateQuestionID; + } + public void setTemplateQuestionNum(Long templateQuestionNum) + { + this.templateQuestionNum = templateQuestionNum; + } + + public Long getTemplateQuestionNum() + { + return templateQuestionNum; + } + public void setNextQuestionNum(Long nextQuestionNum) + { + this.nextQuestionNum = nextQuestionNum; + } + + public Long getNextQuestionNum() + { + return nextQuestionNum; + } + public void setTemplateID(String templateID) + { + this.templateID = templateID; + } + + public String getTemplateID() + { + return templateID; + } + public void setSwitchID(Long switchID) + { + this.switchID = switchID; + } + + public Long getSwitchID() + { + return switchID; + } + public void setSwitchDescription(String switchDescription) + { + this.switchDescription = switchDescription; + } + + public String getSwitchDescription() + { + return switchDescription; + } + public void setSwitchText(String switchText) + { + this.switchText = switchText; + } + + public String getSwitchText() + { + return switchText; + } + public void setSwitchWav(String switchWav) + { + this.switchWav = switchWav; + } + + public String getSwitchWav() + { + return switchWav; + } + public void setSwitchTempWav(String switchTempWav) + { + this.switchTempWav = switchTempWav; + } + + public String getSwitchTempWav() + { + return switchTempWav; + } + public void setTargetType(String targetType) + { + this.targetType = targetType; + } + + public String getTargetType() + { + return targetType; + } + public void setCategoryName(String categoryName) + { + this.categoryName = categoryName; + } + + public String getCategoryName() + { + return categoryName; + } + public void setTargetValue(String targetValue) + { + this.targetValue = targetValue; + } + + public String getTargetValue() + { + return targetValue; + } + public void setTargetID(String targetID) + { + this.targetID = targetID; + } + + public String getTargetID() + { + return targetID; + } + public void setQuestionTargetID(String questionTargetID) + { + this.questionTargetID = questionTargetID; + } + + public String getQuestionTargetID() + { + return questionTargetID; + } + public void setBasicRegex(String basicRegex) + { + this.basicRegex = basicRegex; + } + + public String getBasicRegex() + { + return basicRegex; + } + public void setSelfRegex(String selfRegex) + { + this.selfRegex = selfRegex; + } + + public String getSelfRegex() + { + return selfRegex; + } + public void setRegexUsedType(String regexUsedType) + { + this.regexUsedType = regexUsedType; + } + + public String getRegexUsedType() + { + return regexUsedType; + } + public void setLanguage(String language) + { + this.language = language; + } + + public String getLanguage() + { + return language; + } + public void setIsEnable(Long isEnable) + { + this.isEnable = isEnable; + } + + public Long getIsEnable() + { + return isEnable; + } + public void setIsDel(Long isDel) + { + this.isDel = isDel; + } + + public Long getIsDel() + { + return isDel; + } + public void setPlayType(Long playType) + { + this.playType = playType; + } + + public Long getPlayType() + { + return playType; + } + public void setDelFlag(String delFlag) + { + this.delFlag = delFlag; + } + + public String getDelFlag() + { + return delFlag; + } + public void setIsupload(Long isupload) + { + this.isupload = isupload; + } + + public Long getIsupload() + { + return isupload; + } + public void setUploadTime(Date uploadTime) + { + this.uploadTime = uploadTime; + } + + public Date getUploadTime() + { + return uploadTime; + } + public void setOrgid(String orgid) + { + this.orgid = orgid; + } + + public String getOrgid() + { + return orgid; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("templateTargetID", getTemplateTargetID()) + .append("templateQuestionID", getTemplateQuestionID()) + .append("templateQuestionNum", getTemplateQuestionNum()) + .append("nextQuestionNum", getNextQuestionNum()) + .append("templateID", getTemplateID()) + .append("switchID", getSwitchID()) + .append("switchDescription", getSwitchDescription()) + .append("switchText", getSwitchText()) + .append("switchWav", getSwitchWav()) + .append("switchTempWav", getSwitchTempWav()) + .append("targetType", getTargetType()) + .append("categoryName", getCategoryName()) + .append("targetValue", getTargetValue()) + .append("targetID", getTargetID()) + .append("questionTargetID", getQuestionTargetID()) + .append("basicRegex", getBasicRegex()) + .append("selfRegex", getSelfRegex()) + .append("regexUsedType", getRegexUsedType()) + .append("language", getLanguage()) + .append("isEnable", getIsEnable()) + .append("isDel", getIsDel()) + .append("playType", getPlayType()) + .append("delFlag", getDelFlag()) + .append("updateBy", getUpdateBy()) + .append("updateTime", getUpdateTime()) + .append("createBy", getCreateBy()) + .append("createTime", getCreateTime()) + .append("isupload", getIsupload()) + .append("uploadTime", getUploadTime()) + .append("orgid", getOrgid()) + .toString(); + } +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplateMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplateMapper.java new file mode 100644 index 0000000..0a732d1 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplateMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaExtemplate; + +/** + * 鎵╁睍璇濇湳妯℃澘搴揗apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaExtemplateMapper +{ + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴� + */ + public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID); + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 鎵╁睍璇濇湳妯℃澘搴撻泦鍚� + */ + public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID); + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplatescriptMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplatescriptMapper.java new file mode 100644 index 0000000..58c00b7 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaExtemplatescriptMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaExtemplatescript; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈疢apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaExtemplatescriptMapper +{ + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID); + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈泦鍚� + */ + public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID); + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptMapper.java new file mode 100644 index 0000000..af112a2 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaScript; + +/** + * 璇濇湳搴揗apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaScriptMapper +{ + /** + * 鏌ヨ璇濇湳搴� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 璇濇湳搴� + */ + public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid); + + /** + * 鏌ヨ璇濇湳搴撳垪琛� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 璇濇湳搴撻泦鍚� + */ + public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript); + + /** + * 鏂板璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + public int insertIvrLibaScript(IvrLibaScript ivrLibaScript); + + /** + * 淇敼璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + public int updateIvrLibaScript(IvrLibaScript ivrLibaScript); + + /** + * 鍒犻櫎璇濇湳搴� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaScriptByQuestionid(String questionid); + + /** + * 鎵归噺鍒犻櫎璇濇湳搴� + * + * @param questionids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaScriptByQuestionids(String[] questionids); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaScripttargetMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaScripttargetMapper.java new file mode 100644 index 0000000..6effbce --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaScripttargetMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaScripttarget; + +/** + * 璇濇湳搴撹瘽鏈寚鏍嘙apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaScripttargetMapper +{ + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳搴撹瘽鏈寚鏍� + */ + public IvrLibaScripttarget selectIvrLibaScripttargetByQuestionTargetID(String questionTargetID); + + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 璇濇湳搴撹瘽鏈寚鏍囬泦鍚� + */ + public List<IvrLibaScripttarget> selectIvrLibaScripttargetList(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 鏂板璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int insertIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 淇敼璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int updateIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 鍒犻櫎璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaScripttargetByQuestionTargetID(String questionTargetID); + + /** + * 鎵归噺鍒犻櫎璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaScripttargetByQuestionTargetIDs(String[] questionTargetIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaTargetMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaTargetMapper.java new file mode 100644 index 0000000..11b6be1 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaTargetMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaTarget; + +/** + * 鎸囨爣搴揗apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaTargetMapper +{ + /** + * 鏌ヨ鎸囨爣搴� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 鎸囨爣搴� + */ + public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID); + + /** + * 鏌ヨ鎸囨爣搴撳垪琛� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 鎸囨爣搴撻泦鍚� + */ + public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget); + + /** + * 鏂板鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget); + + /** + * 淇敼鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget); + + /** + * 鍒犻櫎鎸囨爣搴� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTargetByTargetID(String targetID); + + /** + * 鎵归噺鍒犻櫎鎸囨爣搴� + * + * @param targetIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaTargetByTargetIDs(String[] targetIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplateMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplateMapper.java new file mode 100644 index 0000000..a828fe2 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplateMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplate; + +/** + * 璇濇湳妯℃澘搴揗apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaTemplateMapper +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 璇濇湳妯℃澘搴� + */ + public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 璇濇湳妯℃澘搴撻泦鍚� + */ + public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate); + + /** + * 鏂板璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate); + + /** + * 淇敼璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplateByTemplateID(String templateID); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴� + * + * @param templateIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatescriptMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatescriptMapper.java new file mode 100644 index 0000000..70a66e8 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatescriptMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplatescript; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈疢apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaTemplatescriptMapper +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈� + */ + public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 璇濇湳妯℃澘搴撹瘽鏈泦鍚� + */ + public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs); +} diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatetargetMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatetargetMapper.java new file mode 100644 index 0000000..4d96eef --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaTemplatetargetMapper.java @@ -0,0 +1,61 @@ +package com.smartor.mapper; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplatetarget; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈寚鏍嘙apper鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IvrLibaTemplatetargetMapper +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍囬泦鍚� + */ + public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplateService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplateService.java new file mode 100644 index 0000000..fa1cb18 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplateService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaExtemplate; + +/** + * 鎵╁睍璇濇湳妯℃澘搴揝ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaExtemplateService +{ + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴� + */ + public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID); + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 鎵╁睍璇濇湳妯℃澘搴撻泦鍚� + */ + public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate); + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleIDs 闇�瑕佸垹闄ょ殑鎵╁睍璇濇湳妯℃澘搴撲富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs); + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撲俊鎭� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplatescriptService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplatescriptService.java new file mode 100644 index 0000000..882210d --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaExtemplatescriptService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaExtemplatescript; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈疭ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaExtemplatescriptService +{ + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID); + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈泦鍚� + */ + public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript); + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailIDs 闇�瑕佸垹闄ょ殑鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs); + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈俊鎭� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaScriptService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptService.java new file mode 100644 index 0000000..0a65c94 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaScript; + +/** + * 璇濇湳搴揝ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaScriptService +{ + /** + * 鏌ヨ璇濇湳搴� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 璇濇湳搴� + */ + public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid); + + /** + * 鏌ヨ璇濇湳搴撳垪琛� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 璇濇湳搴撻泦鍚� + */ + public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript); + + /** + * 鏂板璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + public int insertIvrLibaScript(IvrLibaScript ivrLibaScript); + + /** + * 淇敼璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + public int updateIvrLibaScript(IvrLibaScript ivrLibaScript); + + /** + * 鎵归噺鍒犻櫎璇濇湳搴� + * + * @param questionids 闇�瑕佸垹闄ょ殑璇濇湳搴撲富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaScriptByQuestionids(String[] questionids); + + /** + * 鍒犻櫎璇濇湳搴撲俊鎭� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaScriptByQuestionid(String questionid); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaScripttargetService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaScripttargetService.java new file mode 100644 index 0000000..4603e62 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaScripttargetService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaScripttarget; + +/** + * 璇濇湳搴撹瘽鏈寚鏍嘢ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaScripttargetService +{ + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳搴撹瘽鏈寚鏍� + */ + public IvrLibaScripttarget selectIvrLibaScripttargetByQuestionTargetID(String questionTargetID); + + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 璇濇湳搴撹瘽鏈寚鏍囬泦鍚� + */ + public List<IvrLibaScripttarget> selectIvrLibaScripttargetList(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 鏂板璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int insertIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 淇敼璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int updateIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget); + + /** + * 鎵归噺鍒犻櫎璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetIDs 闇�瑕佸垹闄ょ殑璇濇湳搴撹瘽鏈寚鏍囦富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaScripttargetByQuestionTargetIDs(String[] questionTargetIDs); + + /** + * 鍒犻櫎璇濇湳搴撹瘽鏈寚鏍囦俊鎭� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaScripttargetByQuestionTargetID(String questionTargetID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaTargetService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaTargetService.java new file mode 100644 index 0000000..a761071 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaTargetService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaTarget; + +/** + * 鎸囨爣搴揝ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaTargetService +{ + /** + * 鏌ヨ鎸囨爣搴� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 鎸囨爣搴� + */ + public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID); + + /** + * 鏌ヨ鎸囨爣搴撳垪琛� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 鎸囨爣搴撻泦鍚� + */ + public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget); + + /** + * 鏂板鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget); + + /** + * 淇敼鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget); + + /** + * 鎵归噺鍒犻櫎鎸囨爣搴� + * + * @param targetIDs 闇�瑕佸垹闄ょ殑鎸囨爣搴撲富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaTargetByTargetIDs(String[] targetIDs); + + /** + * 鍒犻櫎鎸囨爣搴撲俊鎭� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTargetByTargetID(String targetID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaTemplateService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplateService.java new file mode 100644 index 0000000..dc7fe48 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplateService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplate; + +/** + * 璇濇湳妯℃澘搴揝ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaTemplateService +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 璇濇湳妯℃澘搴� + */ + public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 璇濇湳妯℃澘搴撻泦鍚� + */ + public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate); + + /** + * 鏂板璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate); + + /** + * 淇敼璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴� + * + * @param templateIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撲富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撲俊鎭� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplateByTemplateID(String templateID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatescriptService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatescriptService.java new file mode 100644 index 0000000..afb4136 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatescriptService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplatescript; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈疭ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaTemplatescriptService +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈� + */ + public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 璇濇湳妯℃澘搴撹瘽鏈泦鍚� + */ + public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撹瘽鏈富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈俊鎭� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID); +} diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatetargetService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatetargetService.java new file mode 100644 index 0000000..44839fd --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IIvrLibaTemplatetargetService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.IvrLibaTemplatetarget; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈寚鏍嘢ervice鎺ュ彛 + * + * @author smartor + * @date 2023-03-22 + */ +public interface IIvrLibaTemplatetargetService +{ + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID); + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍囬泦鍚� + */ + public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget); + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs); + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍囦俊鎭� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID); +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplateServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplateServiceImpl.java new file mode 100644 index 0000000..736cfe9 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplateServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaExtemplateMapper; +import com.smartor.domain.IvrLibaExtemplate; +import com.smartor.service.IIvrLibaExtemplateService; + +/** + * 鎵╁睍璇濇湳妯℃澘搴揝ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaExtemplateServiceImpl implements IIvrLibaExtemplateService +{ + @Autowired + private IvrLibaExtemplateMapper ivrLibaExtemplateMapper; + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴� + */ + @Override + public IvrLibaExtemplate selectIvrLibaExtemplateBySubModuleID(String subModuleID) + { + return ivrLibaExtemplateMapper.selectIvrLibaExtemplateBySubModuleID(subModuleID); + } + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 鎵╁睍璇濇湳妯℃澘搴� + */ + @Override + public List<IvrLibaExtemplate> selectIvrLibaExtemplateList(IvrLibaExtemplate ivrLibaExtemplate) + { + return ivrLibaExtemplateMapper.selectIvrLibaExtemplateList(ivrLibaExtemplate); + } + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate) + { + ivrLibaExtemplate.setCreateTime(DateUtils.getNowDate()); + return ivrLibaExtemplateMapper.insertIvrLibaExtemplate(ivrLibaExtemplate); + } + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴� + * + * @param ivrLibaExtemplate 鎵╁睍璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaExtemplate(IvrLibaExtemplate ivrLibaExtemplate) + { + ivrLibaExtemplate.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaExtemplateMapper.updateIvrLibaExtemplate(ivrLibaExtemplate); + } + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴� + * + * @param subModuleIDs 闇�瑕佸垹闄ょ殑鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaExtemplateBySubModuleIDs(String[] subModuleIDs) + { + return ivrLibaExtemplateMapper.deleteIvrLibaExtemplateBySubModuleIDs(subModuleIDs); + } + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撲俊鎭� + * + * @param subModuleID 鎵╁睍璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaExtemplateBySubModuleID(String subModuleID) + { + return ivrLibaExtemplateMapper.deleteIvrLibaExtemplateBySubModuleID(subModuleID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplatescriptServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplatescriptServiceImpl.java new file mode 100644 index 0000000..70da213 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaExtemplatescriptServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaExtemplatescriptMapper; +import com.smartor.domain.IvrLibaExtemplatescript; +import com.smartor.service.IIvrLibaExtemplatescriptService; + +/** + * 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈疭ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaExtemplatescriptServiceImpl implements IIvrLibaExtemplatescriptService +{ + @Autowired + private IvrLibaExtemplatescriptMapper ivrLibaExtemplatescriptMapper; + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + @Override + public IvrLibaExtemplatescript selectIvrLibaExtemplatescriptByDetailID(String DetailID) + { + return ivrLibaExtemplatescriptMapper.selectIvrLibaExtemplatescriptByDetailID(DetailID); + } + + /** + * 鏌ヨ鎵╁睍璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + */ + @Override + public List<IvrLibaExtemplatescript> selectIvrLibaExtemplatescriptList(IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + return ivrLibaExtemplatescriptMapper.selectIvrLibaExtemplatescriptList(ivrLibaExtemplatescript); + } + + /** + * 鏂板鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + ivrLibaExtemplatescript.setCreateTime(DateUtils.getNowDate()); + return ivrLibaExtemplatescriptMapper.insertIvrLibaExtemplatescript(ivrLibaExtemplatescript); + } + + /** + * 淇敼鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaExtemplatescript 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaExtemplatescript(IvrLibaExtemplatescript ivrLibaExtemplatescript) + { + ivrLibaExtemplatescript.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaExtemplatescriptMapper.updateIvrLibaExtemplatescript(ivrLibaExtemplatescript); + } + + /** + * 鎵归噺鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈� + * + * @param DetailIDs 闇�瑕佸垹闄ょ殑鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaExtemplatescriptByDetailIDs(String[] DetailIDs) + { + return ivrLibaExtemplatescriptMapper.deleteIvrLibaExtemplatescriptByDetailIDs(DetailIDs); + } + + /** + * 鍒犻櫎鎵╁睍璇濇湳妯℃澘搴撹瘽鏈俊鎭� + * + * @param DetailID 鎵╁睍璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaExtemplatescriptByDetailID(String DetailID) + { + return ivrLibaExtemplatescriptMapper.deleteIvrLibaExtemplatescriptByDetailID(DetailID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java new file mode 100644 index 0000000..25cd10d --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaScriptMapper; +import com.smartor.domain.IvrLibaScript; +import com.smartor.service.IIvrLibaScriptService; + +/** + * 璇濇湳搴揝ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaScriptServiceImpl implements IIvrLibaScriptService +{ + @Autowired + private IvrLibaScriptMapper ivrLibaScriptMapper; + + /** + * 鏌ヨ璇濇湳搴� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 璇濇湳搴� + */ + @Override + public IvrLibaScript selectIvrLibaScriptByQuestionid(String questionid) + { + return ivrLibaScriptMapper.selectIvrLibaScriptByQuestionid(questionid); + } + + /** + * 鏌ヨ璇濇湳搴撳垪琛� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 璇濇湳搴� + */ + @Override + public List<IvrLibaScript> selectIvrLibaScriptList(IvrLibaScript ivrLibaScript) + { + return ivrLibaScriptMapper.selectIvrLibaScriptList(ivrLibaScript); + } + + /** + * 鏂板璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaScript(IvrLibaScript ivrLibaScript) + { + ivrLibaScript.setCreateTime(DateUtils.getNowDate()); + return ivrLibaScriptMapper.insertIvrLibaScript(ivrLibaScript); + } + + /** + * 淇敼璇濇湳搴� + * + * @param ivrLibaScript 璇濇湳搴� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaScript(IvrLibaScript ivrLibaScript) + { + ivrLibaScript.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaScriptMapper.updateIvrLibaScript(ivrLibaScript); + } + + /** + * 鎵归噺鍒犻櫎璇濇湳搴� + * + * @param questionids 闇�瑕佸垹闄ょ殑璇濇湳搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaScriptByQuestionids(String[] questionids) + { + return ivrLibaScriptMapper.deleteIvrLibaScriptByQuestionids(questionids); + } + + /** + * 鍒犻櫎璇濇湳搴撲俊鎭� + * + * @param questionid 璇濇湳搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaScriptByQuestionid(String questionid) + { + return ivrLibaScriptMapper.deleteIvrLibaScriptByQuestionid(questionid); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScripttargetServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScripttargetServiceImpl.java new file mode 100644 index 0000000..af9699e --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScripttargetServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaScripttargetMapper; +import com.smartor.domain.IvrLibaScripttarget; +import com.smartor.service.IIvrLibaScripttargetService; + +/** + * 璇濇湳搴撹瘽鏈寚鏍嘢ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaScripttargetServiceImpl implements IIvrLibaScripttargetService +{ + @Autowired + private IvrLibaScripttargetMapper ivrLibaScripttargetMapper; + + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳搴撹瘽鏈寚鏍� + */ + @Override + public IvrLibaScripttarget selectIvrLibaScripttargetByQuestionTargetID(String questionTargetID) + { + return ivrLibaScripttargetMapper.selectIvrLibaScripttargetByQuestionTargetID(questionTargetID); + } + + /** + * 鏌ヨ璇濇湳搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 璇濇湳搴撹瘽鏈寚鏍� + */ + @Override + public List<IvrLibaScripttarget> selectIvrLibaScripttargetList(IvrLibaScripttarget ivrLibaScripttarget) + { + return ivrLibaScripttargetMapper.selectIvrLibaScripttargetList(ivrLibaScripttarget); + } + + /** + * 鏂板璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget) + { + ivrLibaScripttarget.setCreateTime(DateUtils.getNowDate()); + return ivrLibaScripttargetMapper.insertIvrLibaScripttarget(ivrLibaScripttarget); + } + + /** + * 淇敼璇濇湳搴撹瘽鏈寚鏍� + * + * @param ivrLibaScripttarget 璇濇湳搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaScripttarget(IvrLibaScripttarget ivrLibaScripttarget) + { + ivrLibaScripttarget.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaScripttargetMapper.updateIvrLibaScripttarget(ivrLibaScripttarget); + } + + /** + * 鎵归噺鍒犻櫎璇濇湳搴撹瘽鏈寚鏍� + * + * @param questionTargetIDs 闇�瑕佸垹闄ょ殑璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaScripttargetByQuestionTargetIDs(String[] questionTargetIDs) + { + return ivrLibaScripttargetMapper.deleteIvrLibaScripttargetByQuestionTargetIDs(questionTargetIDs); + } + + /** + * 鍒犻櫎璇濇湳搴撹瘽鏈寚鏍囦俊鎭� + * + * @param questionTargetID 璇濇湳搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaScripttargetByQuestionTargetID(String questionTargetID) + { + return ivrLibaScripttargetMapper.deleteIvrLibaScripttargetByQuestionTargetID(questionTargetID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java new file mode 100644 index 0000000..533c031 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaTargetMapper; +import com.smartor.domain.IvrLibaTarget; +import com.smartor.service.IIvrLibaTargetService; + +/** + * 鎸囨爣搴揝ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaTargetServiceImpl implements IIvrLibaTargetService +{ + @Autowired + private IvrLibaTargetMapper ivrLibaTargetMapper; + + /** + * 鏌ヨ鎸囨爣搴� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 鎸囨爣搴� + */ + @Override + public IvrLibaTarget selectIvrLibaTargetByTargetID(String targetID) + { + return ivrLibaTargetMapper.selectIvrLibaTargetByTargetID(targetID); + } + + /** + * 鏌ヨ鎸囨爣搴撳垪琛� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 鎸囨爣搴� + */ + @Override + public List<IvrLibaTarget> selectIvrLibaTargetList(IvrLibaTarget ivrLibaTarget) + { + return ivrLibaTargetMapper.selectIvrLibaTargetList(ivrLibaTarget); + } + + /** + * 鏂板鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaTarget(IvrLibaTarget ivrLibaTarget) + { + ivrLibaTarget.setCreateTime(DateUtils.getNowDate()); + return ivrLibaTargetMapper.insertIvrLibaTarget(ivrLibaTarget); + } + + /** + * 淇敼鎸囨爣搴� + * + * @param ivrLibaTarget 鎸囨爣搴� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaTarget(IvrLibaTarget ivrLibaTarget) + { + ivrLibaTarget.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaTargetMapper.updateIvrLibaTarget(ivrLibaTarget); + } + + /** + * 鎵归噺鍒犻櫎鎸囨爣搴� + * + * @param targetIDs 闇�瑕佸垹闄ょ殑鎸囨爣搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTargetByTargetIDs(String[] targetIDs) + { + return ivrLibaTargetMapper.deleteIvrLibaTargetByTargetIDs(targetIDs); + } + + /** + * 鍒犻櫎鎸囨爣搴撲俊鎭� + * + * @param targetID 鎸囨爣搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTargetByTargetID(String targetID) + { + return ivrLibaTargetMapper.deleteIvrLibaTargetByTargetID(targetID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplateServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplateServiceImpl.java new file mode 100644 index 0000000..c6ccb10 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplateServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaTemplateMapper; +import com.smartor.domain.IvrLibaTemplate; +import com.smartor.service.IIvrLibaTemplateService; + +/** + * 璇濇湳妯℃澘搴揝ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaTemplateServiceImpl implements IIvrLibaTemplateService +{ + @Autowired + private IvrLibaTemplateMapper ivrLibaTemplateMapper; + + /** + * 鏌ヨ璇濇湳妯℃澘搴� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 璇濇湳妯℃澘搴� + */ + @Override + public IvrLibaTemplate selectIvrLibaTemplateByTemplateID(String templateID) + { + return ivrLibaTemplateMapper.selectIvrLibaTemplateByTemplateID(templateID); + } + + /** + * 鏌ヨ璇濇湳妯℃澘搴撳垪琛� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 璇濇湳妯℃澘搴� + */ + @Override + public List<IvrLibaTemplate> selectIvrLibaTemplateList(IvrLibaTemplate ivrLibaTemplate) + { + return ivrLibaTemplateMapper.selectIvrLibaTemplateList(ivrLibaTemplate); + } + + /** + * 鏂板璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate) + { + ivrLibaTemplate.setCreateTime(DateUtils.getNowDate()); + return ivrLibaTemplateMapper.insertIvrLibaTemplate(ivrLibaTemplate); + } + + /** + * 淇敼璇濇湳妯℃澘搴� + * + * @param ivrLibaTemplate 璇濇湳妯℃澘搴� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaTemplate(IvrLibaTemplate ivrLibaTemplate) + { + ivrLibaTemplate.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaTemplateMapper.updateIvrLibaTemplate(ivrLibaTemplate); + } + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴� + * + * @param templateIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplateByTemplateIDs(String[] templateIDs) + { + return ivrLibaTemplateMapper.deleteIvrLibaTemplateByTemplateIDs(templateIDs); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撲俊鎭� + * + * @param templateID 璇濇湳妯℃澘搴撲富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplateByTemplateID(String templateID) + { + return ivrLibaTemplateMapper.deleteIvrLibaTemplateByTemplateID(templateID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatescriptServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatescriptServiceImpl.java new file mode 100644 index 0000000..910b2ba --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatescriptServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaTemplatescriptMapper; +import com.smartor.domain.IvrLibaTemplatescript; +import com.smartor.service.IIvrLibaTemplatescriptService; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈疭ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaTemplatescriptServiceImpl implements IIvrLibaTemplatescriptService +{ + @Autowired + private IvrLibaTemplatescriptMapper ivrLibaTemplatescriptMapper; + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈� + */ + @Override + public IvrLibaTemplatescript selectIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID) + { + return ivrLibaTemplatescriptMapper.selectIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID); + } + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈垪琛� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 璇濇湳妯℃澘搴撹瘽鏈� + */ + @Override + public List<IvrLibaTemplatescript> selectIvrLibaTemplatescriptList(IvrLibaTemplatescript ivrLibaTemplatescript) + { + return ivrLibaTemplatescriptMapper.selectIvrLibaTemplatescriptList(ivrLibaTemplatescript); + } + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript) + { + ivrLibaTemplatescript.setCreateTime(DateUtils.getNowDate()); + return ivrLibaTemplatescriptMapper.insertIvrLibaTemplatescript(ivrLibaTemplatescript); + } + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈� + * + * @param ivrLibaTemplatescript 璇濇湳妯℃澘搴撹瘽鏈� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaTemplatescript(IvrLibaTemplatescript ivrLibaTemplatescript) + { + ivrLibaTemplatescript.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaTemplatescriptMapper.updateIvrLibaTemplatescript(ivrLibaTemplatescript); + } + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈� + * + * @param templateQuestionIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplatescriptByTemplateQuestionIDs(String[] templateQuestionIDs) + { + return ivrLibaTemplatescriptMapper.deleteIvrLibaTemplatescriptByTemplateQuestionIDs(templateQuestionIDs); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈俊鎭� + * + * @param templateQuestionID 璇濇湳妯℃澘搴撹瘽鏈富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplatescriptByTemplateQuestionID(String templateQuestionID) + { + return ivrLibaTemplatescriptMapper.deleteIvrLibaTemplatescriptByTemplateQuestionID(templateQuestionID); + } +} diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatetargetServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatetargetServiceImpl.java new file mode 100644 index 0000000..410dacb --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplatetargetServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.IvrLibaTemplatetargetMapper; +import com.smartor.domain.IvrLibaTemplatetarget; +import com.smartor.service.IIvrLibaTemplatetargetService; + +/** + * 璇濇湳妯℃澘搴撹瘽鏈寚鏍嘢ervice涓氬姟灞傚鐞� + * + * @author smartor + * @date 2023-03-22 + */ +@Service +public class IvrLibaTemplatetargetServiceImpl implements IIvrLibaTemplatetargetService +{ + @Autowired + private IvrLibaTemplatetargetMapper ivrLibaTemplatetargetMapper; + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + @Override + public IvrLibaTemplatetarget selectIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID) + { + return ivrLibaTemplatetargetMapper.selectIvrLibaTemplatetargetByTemplateTargetID(templateTargetID); + } + + /** + * 鏌ヨ璇濇湳妯℃澘搴撹瘽鏈寚鏍囧垪琛� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + */ + @Override + public List<IvrLibaTemplatetarget> selectIvrLibaTemplatetargetList(IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + return ivrLibaTemplatetargetMapper.selectIvrLibaTemplatetargetList(ivrLibaTemplatetarget); + } + + /** + * 鏂板璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + @Override + public int insertIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + ivrLibaTemplatetarget.setCreateTime(DateUtils.getNowDate()); + return ivrLibaTemplatetargetMapper.insertIvrLibaTemplatetarget(ivrLibaTemplatetarget); + } + + /** + * 淇敼璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param ivrLibaTemplatetarget 璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * @return 缁撴灉 + */ + @Override + public int updateIvrLibaTemplatetarget(IvrLibaTemplatetarget ivrLibaTemplatetarget) + { + ivrLibaTemplatetarget.setUpdateTime(DateUtils.getNowDate()); + return ivrLibaTemplatetargetMapper.updateIvrLibaTemplatetarget(ivrLibaTemplatetarget); + } + + /** + * 鎵归噺鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍� + * + * @param templateTargetIDs 闇�瑕佸垹闄ょ殑璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplatetargetByTemplateTargetIDs(String[] templateTargetIDs) + { + return ivrLibaTemplatetargetMapper.deleteIvrLibaTemplatetargetByTemplateTargetIDs(templateTargetIDs); + } + + /** + * 鍒犻櫎璇濇湳妯℃澘搴撹瘽鏈寚鏍囦俊鎭� + * + * @param templateTargetID 璇濇湳妯℃澘搴撹瘽鏈寚鏍囦富閿� + * @return 缁撴灉 + */ + @Override + public int deleteIvrLibaTemplatetargetByTemplateTargetID(String templateTargetID) + { + return ivrLibaTemplatetargetMapper.deleteIvrLibaTemplatetargetByTemplateTargetID(templateTargetID); + } +} diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplateMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplateMapper.xml new file mode 100644 index 0000000..f81e4d1 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplateMapper.xml @@ -0,0 +1,143 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaExtemplateMapper"> + + <resultMap type="IvrLibaExtemplate" id="IvrLibaExtemplateResult"> + <result property="subModuleID" column="subModuleID" /> + <result property="subModuleName" column="subModuleName" /> + <result property="language" column="language" /> + <result property="description" column="description" /> + <result property="version" column="version" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="addUserID" column="addUserID" /> + <result property="addTime" column="addTime" /> + <result property="modifyUserID" column="modifyUserID" /> + <result property="modifyTime" column="modifyTime" /> + <result property="GroupID" column="GroupID" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaExtemplateVo"> + select subModuleID, subModuleName, language, description, version, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, GroupID, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_extemplate + </sql> + + <select id="selectIvrLibaExtemplateList" parameterType="IvrLibaExtemplate" resultMap="IvrLibaExtemplateResult"> + <include refid="selectIvrLibaExtemplateVo"/> + <where> + <if test="subModuleName != null and subModuleName != ''"> and subModuleName like concat('%', #{subModuleName}, '%')</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="description != null and description != ''"> and description = #{description}</if> + <if test="version != null "> and version = #{version}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="addUserID != null and addUserID != ''"> and addUserID = #{addUserID}</if> + <if test="addTime != null "> and addTime = #{addTime}</if> + <if test="modifyUserID != null and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if> + <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if> + <if test="GroupID != null "> and GroupID = #{GroupID}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaExtemplateBySubModuleID" parameterType="String" resultMap="IvrLibaExtemplateResult"> + <include refid="selectIvrLibaExtemplateVo"/> + where subModuleID = #{subModuleID} + </select> + + <insert id="insertIvrLibaExtemplate" parameterType="IvrLibaExtemplate"> + insert into ivr_liba_extemplate + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="subModuleID != null">subModuleID,</if> + <if test="subModuleName != null and subModuleName != ''">subModuleName,</if> + <if test="language != null and language != ''">language,</if> + <if test="description != null">description,</if> + <if test="version != null">version,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="addUserID != null">addUserID,</if> + <if test="addTime != null">addTime,</if> + <if test="modifyUserID != null">modifyUserID,</if> + <if test="modifyTime != null">modifyTime,</if> + <if test="GroupID != null">GroupID,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="subModuleID != null">#{subModuleID},</if> + <if test="subModuleName != null and subModuleName != ''">#{subModuleName},</if> + <if test="language != null and language != ''">#{language},</if> + <if test="description != null">#{description},</if> + <if test="version != null">#{version},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="addUserID != null">#{addUserID},</if> + <if test="addTime != null">#{addTime},</if> + <if test="modifyUserID != null">#{modifyUserID},</if> + <if test="modifyTime != null">#{modifyTime},</if> + <if test="GroupID != null">#{GroupID},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaExtemplate" parameterType="IvrLibaExtemplate"> + update ivr_liba_extemplate + <trim prefix="SET" suffixOverrides=","> + <if test="subModuleName != null and subModuleName != ''">subModuleName = #{subModuleName},</if> + <if test="language != null and language != ''">language = #{language},</if> + <if test="description != null">description = #{description},</if> + <if test="version != null">version = #{version},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="addUserID != null">addUserID = #{addUserID},</if> + <if test="addTime != null">addTime = #{addTime},</if> + <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if> + <if test="modifyTime != null">modifyTime = #{modifyTime},</if> + <if test="GroupID != null">GroupID = #{GroupID},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where subModuleID = #{subModuleID} + </update> + + <delete id="deleteIvrLibaExtemplateBySubModuleID" parameterType="String"> + delete from ivr_liba_extemplate where subModuleID = #{subModuleID} + </delete> + + <delete id="deleteIvrLibaExtemplateBySubModuleIDs" parameterType="String"> + delete from ivr_liba_extemplate where subModuleID in + <foreach item="subModuleID" collection="array" open="(" separator="," close=")"> + #{subModuleID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplatescriptMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplatescriptMapper.xml new file mode 100644 index 0000000..bc15d9b --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaExtemplatescriptMapper.xml @@ -0,0 +1,123 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaExtemplatescriptMapper"> + + <resultMap type="IvrLibaExtemplatescript" id="IvrLibaExtemplatescriptResult"> + <result property="DetailID" column="DetailID" /> + <result property="subModuleID" column="subModuleID" /> + <result property="switchID" column="switchID" /> + <result property="switchText" column="switchText" /> + <result property="switchWav" column="switchWav" /> + <result property="selfRegex" column="selfRegex" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaExtemplatescriptVo"> + select DetailID, subModuleID, switchID, switchText, switchWav, selfRegex, isEnable, isDel, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_extemplatescript + </sql> + + <select id="selectIvrLibaExtemplatescriptList" parameterType="IvrLibaExtemplatescript" resultMap="IvrLibaExtemplatescriptResult"> + <include refid="selectIvrLibaExtemplatescriptVo"/> + <where> + <if test="subModuleID != null and subModuleID != ''"> and subModuleID = #{subModuleID}</if> + <if test="switchID != null "> and switchID = #{switchID}</if> + <if test="switchText != null and switchText != ''"> and switchText = #{switchText}</if> + <if test="switchWav != null and switchWav != ''"> and switchWav = #{switchWav}</if> + <if test="selfRegex != null and selfRegex != ''"> and selfRegex = #{selfRegex}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaExtemplatescriptByDetailID" parameterType="String" resultMap="IvrLibaExtemplatescriptResult"> + <include refid="selectIvrLibaExtemplatescriptVo"/> + where DetailID = #{DetailID} + </select> + + <insert id="insertIvrLibaExtemplatescript" parameterType="IvrLibaExtemplatescript"> + insert into ivr_liba_extemplatescript + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="DetailID != null">DetailID,</if> + <if test="subModuleID != null and subModuleID != ''">subModuleID,</if> + <if test="switchID != null">switchID,</if> + <if test="switchText != null">switchText,</if> + <if test="switchWav != null">switchWav,</if> + <if test="selfRegex != null">selfRegex,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="DetailID != null">#{DetailID},</if> + <if test="subModuleID != null and subModuleID != ''">#{subModuleID},</if> + <if test="switchID != null">#{switchID},</if> + <if test="switchText != null">#{switchText},</if> + <if test="switchWav != null">#{switchWav},</if> + <if test="selfRegex != null">#{selfRegex},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaExtemplatescript" parameterType="IvrLibaExtemplatescript"> + update ivr_liba_extemplatescript + <trim prefix="SET" suffixOverrides=","> + <if test="subModuleID != null and subModuleID != ''">subModuleID = #{subModuleID},</if> + <if test="switchID != null">switchID = #{switchID},</if> + <if test="switchText != null">switchText = #{switchText},</if> + <if test="switchWav != null">switchWav = #{switchWav},</if> + <if test="selfRegex != null">selfRegex = #{selfRegex},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where DetailID = #{DetailID} + </update> + + <delete id="deleteIvrLibaExtemplatescriptByDetailID" parameterType="String"> + delete from ivr_liba_extemplatescript where DetailID = #{DetailID} + </delete> + + <delete id="deleteIvrLibaExtemplatescriptByDetailIDs" parameterType="String"> + delete from ivr_liba_extemplatescript where DetailID in + <foreach item="DetailID" collection="array" open="(" separator="," close=")"> + #{DetailID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml new file mode 100644 index 0000000..d794907 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml @@ -0,0 +1,207 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaScriptMapper"> + + <resultMap type="IvrLibaScript" id="IvrLibaScriptResult"> + <result property="questionid" column="questionid" /> + <result property="questionpoint" column="questionpoint" /> + <result property="questiontext" column="questiontext" /> + <result property="questionvoice" column="questionvoice" /> + <result property="nomatchtext" column="nomatchtext" /> + <result property="nomatchvoice" column="nomatchvoice" /> + <result property="sliencetext" column="sliencetext" /> + <result property="sliencevoice" column="sliencevoice" /> + <result property="submoduletext" column="submoduletext" /> + <result property="submodulevoice" column="submodulevoice" /> + <result property="noclearlytext" column="noclearlytext" /> + <result property="noclearlyvoice" column="noclearlyvoice" /> + <result property="questiontype" column="questiontype" /> + <result property="categoryname" column="categoryname" /> + <result property="targetoptions" column="targetoptions" /> + <result property="language" column="language" /> + <result property="description" column="description" /> + <result property="version" column="version" /> + <result property="isenable" column="isenable" /> + <result property="isdel" column="isdel" /> + <result property="adduserid" column="adduserid" /> + <result property="addtime" column="addtime" /> + <result property="modifyuserid" column="modifyuserid" /> + <result property="modifytime" column="modifytime" /> + <result property="groupid" column="groupid" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaScriptVo"> + select questionid, questionpoint, questiontext, questionvoice, nomatchtext, nomatchvoice, sliencetext, sliencevoice, submoduletext, submodulevoice, noclearlytext, noclearlyvoice, questiontype, categoryname, targetoptions, language, description, version, isenable, isdel, adduserid, addtime, modifyuserid, modifytime, groupid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_script + </sql> + + <select id="selectIvrLibaScriptList" parameterType="IvrLibaScript" resultMap="IvrLibaScriptResult"> + <include refid="selectIvrLibaScriptVo"/> + <where> + <if test="questionpoint != null and questionpoint != ''"> and questionpoint = #{questionpoint}</if> + <if test="questiontext != null and questiontext != ''"> and questiontext = #{questiontext}</if> + <if test="questionvoice != null and questionvoice != ''"> and questionvoice = #{questionvoice}</if> + <if test="nomatchtext != null and nomatchtext != ''"> and nomatchtext = #{nomatchtext}</if> + <if test="nomatchvoice != null and nomatchvoice != ''"> and nomatchvoice = #{nomatchvoice}</if> + <if test="sliencetext != null and sliencetext != ''"> and sliencetext = #{sliencetext}</if> + <if test="sliencevoice != null and sliencevoice != ''"> and sliencevoice = #{sliencevoice}</if> + <if test="submoduletext != null and submoduletext != ''"> and submoduletext = #{submoduletext}</if> + <if test="submodulevoice != null and submodulevoice != ''"> and submodulevoice = #{submodulevoice}</if> + <if test="noclearlytext != null and noclearlytext != ''"> and noclearlytext = #{noclearlytext}</if> + <if test="noclearlyvoice != null and noclearlyvoice != ''"> and noclearlyvoice = #{noclearlyvoice}</if> + <if test="questiontype != null and questiontype != ''"> and questiontype = #{questiontype}</if> + <if test="categoryname != null and categoryname != ''"> and categoryname like concat('%', #{categoryname}, '%')</if> + <if test="targetoptions != null and targetoptions != ''"> and targetoptions = #{targetoptions}</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="version != null "> and version = #{version}</if> + <if test="isenable != null "> and isenable = #{isenable}</if> + <if test="isdel != null "> and isdel = #{isdel}</if> + <if test="adduserid != null and adduserid != ''"> and adduserid = #{adduserid}</if> + <if test="addtime != null "> and addtime = #{addtime}</if> + <if test="modifyuserid != null and modifyuserid != ''"> and modifyuserid = #{modifyuserid}</if> + <if test="modifytime != null "> and modifytime = #{modifytime}</if> + <if test="groupid != null and groupid != ''"> and groupid = #{groupid}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaScriptByQuestionid" parameterType="String" resultMap="IvrLibaScriptResult"> + <include refid="selectIvrLibaScriptVo"/> + where questionid = #{questionid} + </select> + + <insert id="insertIvrLibaScript" parameterType="IvrLibaScript"> + insert into ivr_liba_script + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="questionid != null">questionid,</if> + <if test="questionpoint != null">questionpoint,</if> + <if test="questiontext != null">questiontext,</if> + <if test="questionvoice != null">questionvoice,</if> + <if test="nomatchtext != null">nomatchtext,</if> + <if test="nomatchvoice != null">nomatchvoice,</if> + <if test="sliencetext != null">sliencetext,</if> + <if test="sliencevoice != null">sliencevoice,</if> + <if test="submoduletext != null">submoduletext,</if> + <if test="submodulevoice != null">submodulevoice,</if> + <if test="noclearlytext != null">noclearlytext,</if> + <if test="noclearlyvoice != null">noclearlyvoice,</if> + <if test="questiontype != null">questiontype,</if> + <if test="categoryname != null">categoryname,</if> + <if test="targetoptions != null">targetoptions,</if> + <if test="language != null">language,</if> + <if test="description != null">description,</if> + <if test="version != null">version,</if> + <if test="isenable != null">isenable,</if> + <if test="isdel != null">isdel,</if> + <if test="adduserid != null">adduserid,</if> + <if test="addtime != null">addtime,</if> + <if test="modifyuserid != null">modifyuserid,</if> + <if test="modifytime != null">modifytime,</if> + <if test="groupid != null">groupid,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="questionid != null">#{questionid},</if> + <if test="questionpoint != null">#{questionpoint},</if> + <if test="questiontext != null">#{questiontext},</if> + <if test="questionvoice != null">#{questionvoice},</if> + <if test="nomatchtext != null">#{nomatchtext},</if> + <if test="nomatchvoice != null">#{nomatchvoice},</if> + <if test="sliencetext != null">#{sliencetext},</if> + <if test="sliencevoice != null">#{sliencevoice},</if> + <if test="submoduletext != null">#{submoduletext},</if> + <if test="submodulevoice != null">#{submodulevoice},</if> + <if test="noclearlytext != null">#{noclearlytext},</if> + <if test="noclearlyvoice != null">#{noclearlyvoice},</if> + <if test="questiontype != null">#{questiontype},</if> + <if test="categoryname != null">#{categoryname},</if> + <if test="targetoptions != null">#{targetoptions},</if> + <if test="language != null">#{language},</if> + <if test="description != null">#{description},</if> + <if test="version != null">#{version},</if> + <if test="isenable != null">#{isenable},</if> + <if test="isdel != null">#{isdel},</if> + <if test="adduserid != null">#{adduserid},</if> + <if test="addtime != null">#{addtime},</if> + <if test="modifyuserid != null">#{modifyuserid},</if> + <if test="modifytime != null">#{modifytime},</if> + <if test="groupid != null">#{groupid},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaScript" parameterType="IvrLibaScript"> + update ivr_liba_script + <trim prefix="SET" suffixOverrides=","> + <if test="questionpoint != null">questionpoint = #{questionpoint},</if> + <if test="questiontext != null">questiontext = #{questiontext},</if> + <if test="questionvoice != null">questionvoice = #{questionvoice},</if> + <if test="nomatchtext != null">nomatchtext = #{nomatchtext},</if> + <if test="nomatchvoice != null">nomatchvoice = #{nomatchvoice},</if> + <if test="sliencetext != null">sliencetext = #{sliencetext},</if> + <if test="sliencevoice != null">sliencevoice = #{sliencevoice},</if> + <if test="submoduletext != null">submoduletext = #{submoduletext},</if> + <if test="submodulevoice != null">submodulevoice = #{submodulevoice},</if> + <if test="noclearlytext != null">noclearlytext = #{noclearlytext},</if> + <if test="noclearlyvoice != null">noclearlyvoice = #{noclearlyvoice},</if> + <if test="questiontype != null">questiontype = #{questiontype},</if> + <if test="categoryname != null">categoryname = #{categoryname},</if> + <if test="targetoptions != null">targetoptions = #{targetoptions},</if> + <if test="language != null">language = #{language},</if> + <if test="description != null">description = #{description},</if> + <if test="version != null">version = #{version},</if> + <if test="isenable != null">isenable = #{isenable},</if> + <if test="isdel != null">isdel = #{isdel},</if> + <if test="adduserid != null">adduserid = #{adduserid},</if> + <if test="addtime != null">addtime = #{addtime},</if> + <if test="modifyuserid != null">modifyuserid = #{modifyuserid},</if> + <if test="modifytime != null">modifytime = #{modifytime},</if> + <if test="groupid != null">groupid = #{groupid},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where questionid = #{questionid} + </update> + + <delete id="deleteIvrLibaScriptByQuestionid" parameterType="String"> + delete from ivr_liba_script where questionid = #{questionid} + </delete> + + <delete id="deleteIvrLibaScriptByQuestionids" parameterType="String"> + delete from ivr_liba_script where questionid in + <foreach item="questionid" collection="array" open="(" separator="," close=")"> + #{questionid} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScripttargetMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScripttargetMapper.xml new file mode 100644 index 0000000..ca38487 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaScripttargetMapper.xml @@ -0,0 +1,153 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaScripttargetMapper"> + + <resultMap type="IvrLibaScripttarget" id="IvrLibaScripttargetResult"> + <result property="questionTargetID" column="questionTargetID" /> + <result property="questionID" column="questionID" /> + <result property="targetID" column="targetID" /> + <result property="targetType" column="targetType" /> + <result property="categoryName" column="categoryName" /> + <result property="targetValue" column="targetValue" /> + <result property="basicRegex" column="basicRegex" /> + <result property="selfRegex" column="selfRegex" /> + <result property="regexUsedType" column="regexUsedType" /> + <result property="sort" column="sort" /> + <result property="version" column="version" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="tipsJson" column="tipsJson" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaScripttargetVo"> + select questionTargetID, questionID, targetID, targetType, categoryName, targetValue, basicRegex, selfRegex, regexUsedType, sort, version, isEnable, isDel, tipsJson, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_scripttarget + </sql> + + <select id="selectIvrLibaScripttargetList" parameterType="IvrLibaScripttarget" resultMap="IvrLibaScripttargetResult"> + <include refid="selectIvrLibaScripttargetVo"/> + <where> + <if test="questionID != null and questionID != ''"> and questionID = #{questionID}</if> + <if test="targetID != null and targetID != ''"> and targetID = #{targetID}</if> + <if test="targetType != null and targetType != ''"> and targetType = #{targetType}</if> + <if test="categoryName != null and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if> + <if test="targetValue != null and targetValue != ''"> and targetValue = #{targetValue}</if> + <if test="basicRegex != null and basicRegex != ''"> and basicRegex = #{basicRegex}</if> + <if test="selfRegex != null and selfRegex != ''"> and selfRegex = #{selfRegex}</if> + <if test="regexUsedType != null and regexUsedType != ''"> and regexUsedType = #{regexUsedType}</if> + <if test="sort != null "> and sort = #{sort}</if> + <if test="version != null "> and version = #{version}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="tipsJson != null and tipsJson != ''"> and tipsJson = #{tipsJson}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaScripttargetByQuestionTargetID" parameterType="String" resultMap="IvrLibaScripttargetResult"> + <include refid="selectIvrLibaScripttargetVo"/> + where questionTargetID = #{questionTargetID} + </select> + + <insert id="insertIvrLibaScripttarget" parameterType="IvrLibaScripttarget"> + insert into ivr_liba_scripttarget + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="questionTargetID != null">questionTargetID,</if> + <if test="questionID != null and questionID != ''">questionID,</if> + <if test="targetID != null">targetID,</if> + <if test="targetType != null">targetType,</if> + <if test="categoryName != null">categoryName,</if> + <if test="targetValue != null">targetValue,</if> + <if test="basicRegex != null">basicRegex,</if> + <if test="selfRegex != null">selfRegex,</if> + <if test="regexUsedType != null">regexUsedType,</if> + <if test="sort != null">sort,</if> + <if test="version != null">version,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="tipsJson != null">tipsJson,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="questionTargetID != null">#{questionTargetID},</if> + <if test="questionID != null and questionID != ''">#{questionID},</if> + <if test="targetID != null">#{targetID},</if> + <if test="targetType != null">#{targetType},</if> + <if test="categoryName != null">#{categoryName},</if> + <if test="targetValue != null">#{targetValue},</if> + <if test="basicRegex != null">#{basicRegex},</if> + <if test="selfRegex != null">#{selfRegex},</if> + <if test="regexUsedType != null">#{regexUsedType},</if> + <if test="sort != null">#{sort},</if> + <if test="version != null">#{version},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="tipsJson != null">#{tipsJson},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaScripttarget" parameterType="IvrLibaScripttarget"> + update ivr_liba_scripttarget + <trim prefix="SET" suffixOverrides=","> + <if test="questionID != null and questionID != ''">questionID = #{questionID},</if> + <if test="targetID != null">targetID = #{targetID},</if> + <if test="targetType != null">targetType = #{targetType},</if> + <if test="categoryName != null">categoryName = #{categoryName},</if> + <if test="targetValue != null">targetValue = #{targetValue},</if> + <if test="basicRegex != null">basicRegex = #{basicRegex},</if> + <if test="selfRegex != null">selfRegex = #{selfRegex},</if> + <if test="regexUsedType != null">regexUsedType = #{regexUsedType},</if> + <if test="sort != null">sort = #{sort},</if> + <if test="version != null">version = #{version},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="tipsJson != null">tipsJson = #{tipsJson},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where questionTargetID = #{questionTargetID} + </update> + + <delete id="deleteIvrLibaScripttargetByQuestionTargetID" parameterType="String"> + delete from ivr_liba_scripttarget where questionTargetID = #{questionTargetID} + </delete> + + <delete id="deleteIvrLibaScripttargetByQuestionTargetIDs" parameterType="String"> + delete from ivr_liba_scripttarget where questionTargetID in + <foreach item="questionTargetID" collection="array" open="(" separator="," close=")"> + #{questionTargetID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml new file mode 100644 index 0000000..6c8d1e9 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml @@ -0,0 +1,173 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaTargetMapper"> + + <resultMap type="IvrLibaTarget" id="IvrLibaTargetResult"> + <result property="targetID" column="targetID" /> + <result property="targetType" column="targetType" /> + <result property="categoryName" column="categoryName" /> + <result property="targetValue" column="targetValue" /> + <result property="targetRegex" column="targetRegex" /> + <result property="description" column="description" /> + <result property="language" column="language" /> + <result property="version" column="version" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="addUserID" column="addUserID" /> + <result property="addTime" column="addTime" /> + <result property="modifyUserID" column="modifyUserID" /> + <result property="modifyTime" column="modifyTime" /> + <result property="groupID" column="groupID" /> + <result property="isAbnormal" column="isAbnormal" /> + <result property="WarnUp" column="WarnUp" /> + <result property="WarnDown" column="WarnDown" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaTargetVo"> + select targetID, targetType, categoryName, targetValue, targetRegex, description, language, version, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, groupID, isAbnormal, WarnUp, WarnDown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_target + </sql> + + <select id="selectIvrLibaTargetList" parameterType="IvrLibaTarget" resultMap="IvrLibaTargetResult"> + <include refid="selectIvrLibaTargetVo"/> + <where> + <if test="targetType != null and targetType != ''"> and targetType = #{targetType}</if> + <if test="categoryName != null and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if> + <if test="targetValue != null and targetValue != ''"> and targetValue = #{targetValue}</if> + <if test="targetRegex != null and targetRegex != ''"> and targetRegex = #{targetRegex}</if> + <if test="description != null and description != ''"> and description = #{description}</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="version != null "> and version = #{version}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="addUserID != null and addUserID != ''"> and addUserID = #{addUserID}</if> + <if test="addTime != null "> and addTime = #{addTime}</if> + <if test="modifyUserID != null and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if> + <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if> + <if test="groupID != null and groupID != ''"> and groupID = #{groupID}</if> + <if test="isAbnormal != null "> and isAbnormal = #{isAbnormal}</if> + <if test="WarnUp != null "> and WarnUp = #{WarnUp}</if> + <if test="WarnDown != null "> and WarnDown = #{WarnDown}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaTargetByTargetID" parameterType="String" resultMap="IvrLibaTargetResult"> + <include refid="selectIvrLibaTargetVo"/> + where targetID = #{targetID} + </select> + + <insert id="insertIvrLibaTarget" parameterType="IvrLibaTarget"> + insert into ivr_liba_target + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="targetID != null">targetID,</if> + <if test="targetType != null and targetType != ''">targetType,</if> + <if test="categoryName != null and categoryName != ''">categoryName,</if> + <if test="targetValue != null">targetValue,</if> + <if test="targetRegex != null">targetRegex,</if> + <if test="description != null">description,</if> + <if test="language != null and language != ''">language,</if> + <if test="version != null">version,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="addUserID != null">addUserID,</if> + <if test="addTime != null">addTime,</if> + <if test="modifyUserID != null">modifyUserID,</if> + <if test="modifyTime != null">modifyTime,</if> + <if test="groupID != null">groupID,</if> + <if test="isAbnormal != null">isAbnormal,</if> + <if test="WarnUp != null">WarnUp,</if> + <if test="WarnDown != null">WarnDown,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="targetID != null">#{targetID},</if> + <if test="targetType != null and targetType != ''">#{targetType},</if> + <if test="categoryName != null and categoryName != ''">#{categoryName},</if> + <if test="targetValue != null">#{targetValue},</if> + <if test="targetRegex != null">#{targetRegex},</if> + <if test="description != null">#{description},</if> + <if test="language != null and language != ''">#{language},</if> + <if test="version != null">#{version},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="addUserID != null">#{addUserID},</if> + <if test="addTime != null">#{addTime},</if> + <if test="modifyUserID != null">#{modifyUserID},</if> + <if test="modifyTime != null">#{modifyTime},</if> + <if test="groupID != null">#{groupID},</if> + <if test="isAbnormal != null">#{isAbnormal},</if> + <if test="WarnUp != null">#{WarnUp},</if> + <if test="WarnDown != null">#{WarnDown},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaTarget" parameterType="IvrLibaTarget"> + update ivr_liba_target + <trim prefix="SET" suffixOverrides=","> + <if test="targetType != null and targetType != ''">targetType = #{targetType},</if> + <if test="categoryName != null and categoryName != ''">categoryName = #{categoryName},</if> + <if test="targetValue != null">targetValue = #{targetValue},</if> + <if test="targetRegex != null">targetRegex = #{targetRegex},</if> + <if test="description != null">description = #{description},</if> + <if test="language != null and language != ''">language = #{language},</if> + <if test="version != null">version = #{version},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="addUserID != null">addUserID = #{addUserID},</if> + <if test="addTime != null">addTime = #{addTime},</if> + <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if> + <if test="modifyTime != null">modifyTime = #{modifyTime},</if> + <if test="groupID != null">groupID = #{groupID},</if> + <if test="isAbnormal != null">isAbnormal = #{isAbnormal},</if> + <if test="WarnUp != null">WarnUp = #{WarnUp},</if> + <if test="WarnDown != null">WarnDown = #{WarnDown},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where targetID = #{targetID} + </update> + + <delete id="deleteIvrLibaTargetByTargetID" parameterType="String"> + delete from ivr_liba_target where targetID = #{targetID} + </delete> + + <delete id="deleteIvrLibaTargetByTargetIDs" parameterType="String"> + delete from ivr_liba_target where targetID in + <foreach item="targetID" collection="array" open="(" separator="," close=")"> + #{targetID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml new file mode 100644 index 0000000..625f066 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml @@ -0,0 +1,208 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaTemplateMapper"> + + <resultMap type="IvrLibaTemplate" id="IvrLibaTemplateResult"> + <result property="templateID" column="templateID" /> + <result property="templateName" column="templateName" /> + <result property="silencetime" column="silencetime" /> + <result property="slienceRepeatTimes" column="slienceRepeatTimes" /> + <result property="nomatchRepeatTimes" column="nomatchRepeatTimes" /> + <result property="firstQuestionNum" column="firstQuestionNum" /> + <result property="submodule" column="submodule" /> + <result property="language" column="language" /> + <result property="description" column="description" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="addUserID" column="addUserID" /> + <result property="addTime" column="addTime" /> + <result property="modifyUserID" column="modifyUserID" /> + <result property="modifyTime" column="modifyTime" /> + <result property="groupID" column="groupID" /> + <result property="labelInfo" column="labelInfo" /> + <result property="submoduleID" column="submoduleID" /> + <result property="playType" column="playType" /> + <result property="icd10code" column="icd10code" /> + <result property="icd10codename" column="icd10codename" /> + <result property="atuoTaskDayOffset" column="atuoTaskDayOffset" /> + <result property="DeptIds" column="DeptIds" /> + <result property="DeptNames" column="DeptNames" /> + <result property="fKsdm" column="F_KSDM" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaTemplateVo"> + select templateID, templateName, silencetime, slienceRepeatTimes, nomatchRepeatTimes, firstQuestionNum, submodule, language, description, isEnable, isDel, addUserID, addTime, modifyUserID, modifyTime, groupID, labelInfo, submoduleID, playType, icd10code, icd10codename, atuoTaskDayOffset, DeptIds, DeptNames, F_KSDM, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_template + </sql> + + <select id="selectIvrLibaTemplateList" parameterType="IvrLibaTemplate" resultMap="IvrLibaTemplateResult"> + <include refid="selectIvrLibaTemplateVo"/> + <where> + <if test="templateName != null and templateName != ''"> and templateName like concat('%', #{templateName}, '%')</if> + <if test="silencetime != null "> and silencetime = #{silencetime}</if> + <if test="slienceRepeatTimes != null "> and slienceRepeatTimes = #{slienceRepeatTimes}</if> + <if test="nomatchRepeatTimes != null "> and nomatchRepeatTimes = #{nomatchRepeatTimes}</if> + <if test="firstQuestionNum != null "> and firstQuestionNum = #{firstQuestionNum}</if> + <if test="submodule != null and submodule != ''"> and submodule = #{submodule}</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="description != null and description != ''"> and description = #{description}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="addUserID != null and addUserID != ''"> and addUserID = #{addUserID}</if> + <if test="addTime != null "> and addTime = #{addTime}</if> + <if test="modifyUserID != null and modifyUserID != ''"> and modifyUserID = #{modifyUserID}</if> + <if test="modifyTime != null "> and modifyTime = #{modifyTime}</if> + <if test="groupID != null and groupID != ''"> and groupID = #{groupID}</if> + <if test="labelInfo != null and labelInfo != ''"> and labelInfo = #{labelInfo}</if> + <if test="submoduleID != null and submoduleID != ''"> and submoduleID = #{submoduleID}</if> + <if test="playType != null "> and playType = #{playType}</if> + <if test="icd10code != null and icd10code != ''"> and icd10code = #{icd10code}</if> + <if test="icd10codename != null and icd10codename != ''"> and icd10codename like concat('%', #{icd10codename}, '%')</if> + <if test="atuoTaskDayOffset != null "> and atuoTaskDayOffset = #{atuoTaskDayOffset}</if> + <if test="DeptIds != null and DeptIds != ''"> and DeptIds = #{DeptIds}</if> + <if test="DeptNames != null and DeptNames != ''"> and DeptNames = #{DeptNames}</if> + <if test="fKsdm != null and fKsdm != ''"> and F_KSDM = #{fKsdm}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaTemplateByTemplateID" parameterType="String" resultMap="IvrLibaTemplateResult"> + <include refid="selectIvrLibaTemplateVo"/> + where templateID = #{templateID} + </select> + + <insert id="insertIvrLibaTemplate" parameterType="IvrLibaTemplate"> + insert into ivr_liba_template + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="templateID != null">templateID,</if> + <if test="templateName != null and templateName != ''">templateName,</if> + <if test="silencetime != null">silencetime,</if> + <if test="slienceRepeatTimes != null">slienceRepeatTimes,</if> + <if test="nomatchRepeatTimes != null">nomatchRepeatTimes,</if> + <if test="firstQuestionNum != null">firstQuestionNum,</if> + <if test="submodule != null">submodule,</if> + <if test="language != null and language != ''">language,</if> + <if test="description != null">description,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="addUserID != null">addUserID,</if> + <if test="addTime != null">addTime,</if> + <if test="modifyUserID != null">modifyUserID,</if> + <if test="modifyTime != null">modifyTime,</if> + <if test="groupID != null">groupID,</if> + <if test="labelInfo != null">labelInfo,</if> + <if test="submoduleID != null">submoduleID,</if> + <if test="playType != null">playType,</if> + <if test="icd10code != null">icd10code,</if> + <if test="icd10codename != null">icd10codename,</if> + <if test="atuoTaskDayOffset != null">atuoTaskDayOffset,</if> + <if test="DeptIds != null">DeptIds,</if> + <if test="DeptNames != null">DeptNames,</if> + <if test="fKsdm != null">F_KSDM,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="templateID != null">#{templateID},</if> + <if test="templateName != null and templateName != ''">#{templateName},</if> + <if test="silencetime != null">#{silencetime},</if> + <if test="slienceRepeatTimes != null">#{slienceRepeatTimes},</if> + <if test="nomatchRepeatTimes != null">#{nomatchRepeatTimes},</if> + <if test="firstQuestionNum != null">#{firstQuestionNum},</if> + <if test="submodule != null">#{submodule},</if> + <if test="language != null and language != ''">#{language},</if> + <if test="description != null">#{description},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="addUserID != null">#{addUserID},</if> + <if test="addTime != null">#{addTime},</if> + <if test="modifyUserID != null">#{modifyUserID},</if> + <if test="modifyTime != null">#{modifyTime},</if> + <if test="groupID != null">#{groupID},</if> + <if test="labelInfo != null">#{labelInfo},</if> + <if test="submoduleID != null">#{submoduleID},</if> + <if test="playType != null">#{playType},</if> + <if test="icd10code != null">#{icd10code},</if> + <if test="icd10codename != null">#{icd10codename},</if> + <if test="atuoTaskDayOffset != null">#{atuoTaskDayOffset},</if> + <if test="DeptIds != null">#{DeptIds},</if> + <if test="DeptNames != null">#{DeptNames},</if> + <if test="fKsdm != null">#{fKsdm},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaTemplate" parameterType="IvrLibaTemplate"> + update ivr_liba_template + <trim prefix="SET" suffixOverrides=","> + <if test="templateName != null and templateName != ''">templateName = #{templateName},</if> + <if test="silencetime != null">silencetime = #{silencetime},</if> + <if test="slienceRepeatTimes != null">slienceRepeatTimes = #{slienceRepeatTimes},</if> + <if test="nomatchRepeatTimes != null">nomatchRepeatTimes = #{nomatchRepeatTimes},</if> + <if test="firstQuestionNum != null">firstQuestionNum = #{firstQuestionNum},</if> + <if test="submodule != null">submodule = #{submodule},</if> + <if test="language != null and language != ''">language = #{language},</if> + <if test="description != null">description = #{description},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="addUserID != null">addUserID = #{addUserID},</if> + <if test="addTime != null">addTime = #{addTime},</if> + <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if> + <if test="modifyTime != null">modifyTime = #{modifyTime},</if> + <if test="groupID != null">groupID = #{groupID},</if> + <if test="labelInfo != null">labelInfo = #{labelInfo},</if> + <if test="submoduleID != null">submoduleID = #{submoduleID},</if> + <if test="playType != null">playType = #{playType},</if> + <if test="icd10code != null">icd10code = #{icd10code},</if> + <if test="icd10codename != null">icd10codename = #{icd10codename},</if> + <if test="atuoTaskDayOffset != null">atuoTaskDayOffset = #{atuoTaskDayOffset},</if> + <if test="DeptIds != null">DeptIds = #{DeptIds},</if> + <if test="DeptNames != null">DeptNames = #{DeptNames},</if> + <if test="fKsdm != null">F_KSDM = #{fKsdm},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where templateID = #{templateID} + </update> + + <delete id="deleteIvrLibaTemplateByTemplateID" parameterType="String"> + delete from ivr_liba_template where templateID = #{templateID} + </delete> + + <delete id="deleteIvrLibaTemplateByTemplateIDs" parameterType="String"> + delete from ivr_liba_template where templateID in + <foreach item="templateID" collection="array" open="(" separator="," close=")"> + #{templateID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatescriptMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatescriptMapper.xml new file mode 100644 index 0000000..2b24f8e --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatescriptMapper.xml @@ -0,0 +1,188 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaTemplatescriptMapper"> + + <resultMap type="IvrLibaTemplatescript" id="IvrLibaTemplatescriptResult"> + <result property="templateQuestionID" column="templateQuestionID" /> + <result property="templateQuestionNum" column="templateQuestionNum" /> + <result property="templateID" column="templateID" /> + <result property="questionID" column="questionID" /> + <result property="questionPoint" column="questionPoint" /> + <result property="questionText" column="questionText" /> + <result property="questionVoice" column="questionVoice" /> + <result property="noMatchText" column="noMatchText" /> + <result property="noMatchVoice" column="noMatchVoice" /> + <result property="slienceText" column="slienceText" /> + <result property="slienceVoice" column="slienceVoice" /> + <result property="submoduleText" column="submoduleText" /> + <result property="submoduleVoice" column="submoduleVoice" /> + <result property="noClearlyText" column="noClearlyText" /> + <result property="noClearlyVoice" column="noClearlyVoice" /> + <result property="categoryName" column="categoryName" /> + <result property="targetOptions" column="targetOptions" /> + <result property="language" column="language" /> + <result property="playWavOnly" column="playWavOnly" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaTemplatescriptVo"> + select templateQuestionID, templateQuestionNum, templateID, questionID, questionPoint, questionText, questionVoice, noMatchText, noMatchVoice, slienceText, slienceVoice, submoduleText, submoduleVoice, noClearlyText, noClearlyVoice, categoryName, targetOptions, language, playWavOnly, isEnable, isDel, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_templatescript + </sql> + + <select id="selectIvrLibaTemplatescriptList" parameterType="IvrLibaTemplatescript" resultMap="IvrLibaTemplatescriptResult"> + <include refid="selectIvrLibaTemplatescriptVo"/> + <where> + <if test="templateQuestionNum != null "> and templateQuestionNum = #{templateQuestionNum}</if> + <if test="templateID != null and templateID != ''"> and templateID = #{templateID}</if> + <if test="questionID != null and questionID != ''"> and questionID = #{questionID}</if> + <if test="questionPoint != null and questionPoint != ''"> and questionPoint = #{questionPoint}</if> + <if test="questionText != null and questionText != ''"> and questionText = #{questionText}</if> + <if test="questionVoice != null and questionVoice != ''"> and questionVoice = #{questionVoice}</if> + <if test="noMatchText != null and noMatchText != ''"> and noMatchText = #{noMatchText}</if> + <if test="noMatchVoice != null and noMatchVoice != ''"> and noMatchVoice = #{noMatchVoice}</if> + <if test="slienceText != null and slienceText != ''"> and slienceText = #{slienceText}</if> + <if test="slienceVoice != null and slienceVoice != ''"> and slienceVoice = #{slienceVoice}</if> + <if test="submoduleText != null and submoduleText != ''"> and submoduleText = #{submoduleText}</if> + <if test="submoduleVoice != null and submoduleVoice != ''"> and submoduleVoice = #{submoduleVoice}</if> + <if test="noClearlyText != null and noClearlyText != ''"> and noClearlyText = #{noClearlyText}</if> + <if test="noClearlyVoice != null and noClearlyVoice != ''"> and noClearlyVoice = #{noClearlyVoice}</if> + <if test="categoryName != null and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if> + <if test="targetOptions != null and targetOptions != ''"> and targetOptions = #{targetOptions}</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="playWavOnly != null "> and playWavOnly = #{playWavOnly}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaTemplatescriptByTemplateQuestionID" parameterType="String" resultMap="IvrLibaTemplatescriptResult"> + <include refid="selectIvrLibaTemplatescriptVo"/> + where templateQuestionID = #{templateQuestionID} + </select> + + <insert id="insertIvrLibaTemplatescript" parameterType="IvrLibaTemplatescript"> + insert into ivr_liba_templatescript + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="templateQuestionID != null">templateQuestionID,</if> + <if test="templateQuestionNum != null">templateQuestionNum,</if> + <if test="templateID != null and templateID != ''">templateID,</if> + <if test="questionID != null and questionID != ''">questionID,</if> + <if test="questionPoint != null and questionPoint != ''">questionPoint,</if> + <if test="questionText != null">questionText,</if> + <if test="questionVoice != null">questionVoice,</if> + <if test="noMatchText != null">noMatchText,</if> + <if test="noMatchVoice != null">noMatchVoice,</if> + <if test="slienceText != null">slienceText,</if> + <if test="slienceVoice != null">slienceVoice,</if> + <if test="submoduleText != null">submoduleText,</if> + <if test="submoduleVoice != null">submoduleVoice,</if> + <if test="noClearlyText != null">noClearlyText,</if> + <if test="noClearlyVoice != null">noClearlyVoice,</if> + <if test="categoryName != null">categoryName,</if> + <if test="targetOptions != null">targetOptions,</if> + <if test="language != null and language != ''">language,</if> + <if test="playWavOnly != null">playWavOnly,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="templateQuestionID != null">#{templateQuestionID},</if> + <if test="templateQuestionNum != null">#{templateQuestionNum},</if> + <if test="templateID != null and templateID != ''">#{templateID},</if> + <if test="questionID != null and questionID != ''">#{questionID},</if> + <if test="questionPoint != null and questionPoint != ''">#{questionPoint},</if> + <if test="questionText != null">#{questionText},</if> + <if test="questionVoice != null">#{questionVoice},</if> + <if test="noMatchText != null">#{noMatchText},</if> + <if test="noMatchVoice != null">#{noMatchVoice},</if> + <if test="slienceText != null">#{slienceText},</if> + <if test="slienceVoice != null">#{slienceVoice},</if> + <if test="submoduleText != null">#{submoduleText},</if> + <if test="submoduleVoice != null">#{submoduleVoice},</if> + <if test="noClearlyText != null">#{noClearlyText},</if> + <if test="noClearlyVoice != null">#{noClearlyVoice},</if> + <if test="categoryName != null">#{categoryName},</if> + <if test="targetOptions != null">#{targetOptions},</if> + <if test="language != null and language != ''">#{language},</if> + <if test="playWavOnly != null">#{playWavOnly},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaTemplatescript" parameterType="IvrLibaTemplatescript"> + update ivr_liba_templatescript + <trim prefix="SET" suffixOverrides=","> + <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if> + <if test="templateID != null and templateID != ''">templateID = #{templateID},</if> + <if test="questionID != null and questionID != ''">questionID = #{questionID},</if> + <if test="questionPoint != null and questionPoint != ''">questionPoint = #{questionPoint},</if> + <if test="questionText != null">questionText = #{questionText},</if> + <if test="questionVoice != null">questionVoice = #{questionVoice},</if> + <if test="noMatchText != null">noMatchText = #{noMatchText},</if> + <if test="noMatchVoice != null">noMatchVoice = #{noMatchVoice},</if> + <if test="slienceText != null">slienceText = #{slienceText},</if> + <if test="slienceVoice != null">slienceVoice = #{slienceVoice},</if> + <if test="submoduleText != null">submoduleText = #{submoduleText},</if> + <if test="submoduleVoice != null">submoduleVoice = #{submoduleVoice},</if> + <if test="noClearlyText != null">noClearlyText = #{noClearlyText},</if> + <if test="noClearlyVoice != null">noClearlyVoice = #{noClearlyVoice},</if> + <if test="categoryName != null">categoryName = #{categoryName},</if> + <if test="targetOptions != null">targetOptions = #{targetOptions},</if> + <if test="language != null and language != ''">language = #{language},</if> + <if test="playWavOnly != null">playWavOnly = #{playWavOnly},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where templateQuestionID = #{templateQuestionID} + </update> + + <delete id="deleteIvrLibaTemplatescriptByTemplateQuestionID" parameterType="String"> + delete from ivr_liba_templatescript where templateQuestionID = #{templateQuestionID} + </delete> + + <delete id="deleteIvrLibaTemplatescriptByTemplateQuestionIDs" parameterType="String"> + delete from ivr_liba_templatescript where templateQuestionID in + <foreach item="templateQuestionID" collection="array" open="(" separator="," close=")"> + #{templateQuestionID} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatetargetMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatetargetMapper.xml new file mode 100644 index 0000000..3b805ad --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplatetargetMapper.xml @@ -0,0 +1,193 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.IvrLibaTemplatetargetMapper"> + + <resultMap type="IvrLibaTemplatetarget" id="IvrLibaTemplatetargetResult"> + <result property="templateTargetID" column="templateTargetID" /> + <result property="templateQuestionID" column="templateQuestionID" /> + <result property="templateQuestionNum" column="templateQuestionNum" /> + <result property="nextQuestionNum" column="nextQuestionNum" /> + <result property="templateID" column="templateID" /> + <result property="switchID" column="switchID" /> + <result property="switchDescription" column="switchDescription" /> + <result property="switchText" column="switchText" /> + <result property="switchWav" column="switchWav" /> + <result property="switchTempWav" column="switchTempWav" /> + <result property="targetType" column="targetType" /> + <result property="categoryName" column="categoryName" /> + <result property="targetValue" column="targetValue" /> + <result property="targetID" column="targetID" /> + <result property="questionTargetID" column="questionTargetID" /> + <result property="basicRegex" column="basicRegex" /> + <result property="selfRegex" column="selfRegex" /> + <result property="regexUsedType" column="regexUsedType" /> + <result property="language" column="language" /> + <result property="isEnable" column="isEnable" /> + <result property="isDel" column="isDel" /> + <result property="playType" column="playType" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="orgid" column="orgid" /> + </resultMap> + + <sql id="selectIvrLibaTemplatetargetVo"> + select templateTargetID, templateQuestionID, templateQuestionNum, nextQuestionNum, templateID, switchID, switchDescription, switchText, switchWav, switchTempWav, targetType, categoryName, targetValue, targetID, questionTargetID, basicRegex, selfRegex, regexUsedType, language, isEnable, isDel, playType, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid from ivr_liba_templatetarget + </sql> + + <select id="selectIvrLibaTemplatetargetList" parameterType="IvrLibaTemplatetarget" resultMap="IvrLibaTemplatetargetResult"> + <include refid="selectIvrLibaTemplatetargetVo"/> + <where> + <if test="templateQuestionID != null and templateQuestionID != ''"> and templateQuestionID = #{templateQuestionID}</if> + <if test="templateQuestionNum != null "> and templateQuestionNum = #{templateQuestionNum}</if> + <if test="nextQuestionNum != null "> and nextQuestionNum = #{nextQuestionNum}</if> + <if test="templateID != null and templateID != ''"> and templateID = #{templateID}</if> + <if test="switchID != null "> and switchID = #{switchID}</if> + <if test="switchDescription != null and switchDescription != ''"> and switchDescription = #{switchDescription}</if> + <if test="switchText != null and switchText != ''"> and switchText = #{switchText}</if> + <if test="switchWav != null and switchWav != ''"> and switchWav = #{switchWav}</if> + <if test="switchTempWav != null and switchTempWav != ''"> and switchTempWav = #{switchTempWav}</if> + <if test="targetType != null and targetType != ''"> and targetType = #{targetType}</if> + <if test="categoryName != null and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if> + <if test="targetValue != null and targetValue != ''"> and targetValue = #{targetValue}</if> + <if test="targetID != null and targetID != ''"> and targetID = #{targetID}</if> + <if test="questionTargetID != null and questionTargetID != ''"> and questionTargetID = #{questionTargetID}</if> + <if test="basicRegex != null and basicRegex != ''"> and basicRegex = #{basicRegex}</if> + <if test="selfRegex != null and selfRegex != ''"> and selfRegex = #{selfRegex}</if> + <if test="regexUsedType != null and regexUsedType != ''"> and regexUsedType = #{regexUsedType}</if> + <if test="language != null and language != ''"> and language = #{language}</if> + <if test="isEnable != null "> and isEnable = #{isEnable}</if> + <if test="isDel != null "> and isDel = #{isDel}</if> + <if test="playType != null "> and playType = #{playType}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + </where> + </select> + + <select id="selectIvrLibaTemplatetargetByTemplateTargetID" parameterType="String" resultMap="IvrLibaTemplatetargetResult"> + <include refid="selectIvrLibaTemplatetargetVo"/> + where templateTargetID = #{templateTargetID} + </select> + + <insert id="insertIvrLibaTemplatetarget" parameterType="IvrLibaTemplatetarget"> + insert into ivr_liba_templatetarget + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="templateTargetID != null">templateTargetID,</if> + <if test="templateQuestionID != null and templateQuestionID != ''">templateQuestionID,</if> + <if test="templateQuestionNum != null">templateQuestionNum,</if> + <if test="nextQuestionNum != null">nextQuestionNum,</if> + <if test="templateID != null and templateID != ''">templateID,</if> + <if test="switchID != null">switchID,</if> + <if test="switchDescription != null">switchDescription,</if> + <if test="switchText != null">switchText,</if> + <if test="switchWav != null">switchWav,</if> + <if test="switchTempWav != null">switchTempWav,</if> + <if test="targetType != null">targetType,</if> + <if test="categoryName != null">categoryName,</if> + <if test="targetValue != null">targetValue,</if> + <if test="targetID != null">targetID,</if> + <if test="questionTargetID != null">questionTargetID,</if> + <if test="basicRegex != null">basicRegex,</if> + <if test="selfRegex != null">selfRegex,</if> + <if test="regexUsedType != null">regexUsedType,</if> + <if test="language != null and language != ''">language,</if> + <if test="isEnable != null">isEnable,</if> + <if test="isDel != null">isDel,</if> + <if test="playType != null">playType,</if> + <if test="delFlag != null and delFlag != ''">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="orgid != null">orgid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="templateTargetID != null">#{templateTargetID},</if> + <if test="templateQuestionID != null and templateQuestionID != ''">#{templateQuestionID},</if> + <if test="templateQuestionNum != null">#{templateQuestionNum},</if> + <if test="nextQuestionNum != null">#{nextQuestionNum},</if> + <if test="templateID != null and templateID != ''">#{templateID},</if> + <if test="switchID != null">#{switchID},</if> + <if test="switchDescription != null">#{switchDescription},</if> + <if test="switchText != null">#{switchText},</if> + <if test="switchWav != null">#{switchWav},</if> + <if test="switchTempWav != null">#{switchTempWav},</if> + <if test="targetType != null">#{targetType},</if> + <if test="categoryName != null">#{categoryName},</if> + <if test="targetValue != null">#{targetValue},</if> + <if test="targetID != null">#{targetID},</if> + <if test="questionTargetID != null">#{questionTargetID},</if> + <if test="basicRegex != null">#{basicRegex},</if> + <if test="selfRegex != null">#{selfRegex},</if> + <if test="regexUsedType != null">#{regexUsedType},</if> + <if test="language != null and language != ''">#{language},</if> + <if test="isEnable != null">#{isEnable},</if> + <if test="isDel != null">#{isDel},</if> + <if test="playType != null">#{playType},</if> + <if test="delFlag != null and delFlag != ''">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="orgid != null">#{orgid},</if> + </trim> + </insert> + + <update id="updateIvrLibaTemplatetarget" parameterType="IvrLibaTemplatetarget"> + update ivr_liba_templatetarget + <trim prefix="SET" suffixOverrides=","> + <if test="templateQuestionID != null and templateQuestionID != ''">templateQuestionID = #{templateQuestionID},</if> + <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if> + <if test="nextQuestionNum != null">nextQuestionNum = #{nextQuestionNum},</if> + <if test="templateID != null and templateID != ''">templateID = #{templateID},</if> + <if test="switchID != null">switchID = #{switchID},</if> + <if test="switchDescription != null">switchDescription = #{switchDescription},</if> + <if test="switchText != null">switchText = #{switchText},</if> + <if test="switchWav != null">switchWav = #{switchWav},</if> + <if test="switchTempWav != null">switchTempWav = #{switchTempWav},</if> + <if test="targetType != null">targetType = #{targetType},</if> + <if test="categoryName != null">categoryName = #{categoryName},</if> + <if test="targetValue != null">targetValue = #{targetValue},</if> + <if test="targetID != null">targetID = #{targetID},</if> + <if test="questionTargetID != null">questionTargetID = #{questionTargetID},</if> + <if test="basicRegex != null">basicRegex = #{basicRegex},</if> + <if test="selfRegex != null">selfRegex = #{selfRegex},</if> + <if test="regexUsedType != null">regexUsedType = #{regexUsedType},</if> + <if test="language != null and language != ''">language = #{language},</if> + <if test="isEnable != null">isEnable = #{isEnable},</if> + <if test="isDel != null">isDel = #{isDel},</if> + <if test="playType != null">playType = #{playType},</if> + <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="orgid != null">orgid = #{orgid},</if> + </trim> + where templateTargetID = #{templateTargetID} + </update> + + <delete id="deleteIvrLibaTemplatetargetByTemplateTargetID" parameterType="String"> + delete from ivr_liba_templatetarget where templateTargetID = #{templateTargetID} + </delete> + + <delete id="deleteIvrLibaTemplatetargetByTemplateTargetIDs" parameterType="String"> + delete from ivr_liba_templatetarget where templateTargetID in + <foreach item="templateTargetID" collection="array" open="(" separator="," close=")"> + #{templateTargetID} + </foreach> + </delete> +</mapper> \ No newline at end of file -- Gitblit v1.9.3