¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.web.controller.smartor; |
| | | |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.core.controller.BaseController; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.smartor.domain.TemplateDept; |
| | | import com.smartor.service.ITemplateDeptService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 模æ¿ç§å®¤å
³èController |
| | | * |
| | | * @author lihu |
| | | * @date 2024-09-18 |
| | | */ |
| | | @Api("模æ¿ç§å®¤å
³è") |
| | | @RestController |
| | | @RequestMapping("/smartor/td") |
| | | public class TemplateDeptController extends BaseController |
| | | { |
| | | @Autowired |
| | | private ITemplateDeptService templateDeptService; |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³èå表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢æ¨¡æ¿ç§å®¤å
³èå表") |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(TemplateDept templateDept) |
| | | { |
| | | startPage(); |
| | | List<TemplateDept> list = templateDeptService.selectTemplateDeptList(templateDept); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * å¯¼åºæ¨¡æ¿ç§å®¤å
³èå表 |
| | | */ |
| | | @ApiOperation("å¯¼åºæ¨¡æ¿ç§å®¤å
³èå表") |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:export')") |
| | | @Log(title = "模æ¿ç§å®¤å
³è", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, TemplateDept templateDept) |
| | | { |
| | | List<TemplateDept> list = templateDeptService.selectTemplateDeptList(templateDept); |
| | | ExcelUtil<TemplateDept> util = new ExcelUtil<TemplateDept>(TemplateDept.class); |
| | | util.exportExcel(response, list, "模æ¿ç§å®¤å
³èæ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·å模æ¿ç§å®¤å
³è详ç»ä¿¡æ¯ |
| | | */ |
| | | @ApiOperation("è·å模æ¿ç§å®¤å
³è详ç»ä¿¡æ¯") |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:query')") |
| | | @GetMapping(value = "/getInfo/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) |
| | | { |
| | | return success(templateDeptService.selectTemplateDeptById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢æ¨¡æ¿ç§å®¤å
³è |
| | | */ |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:add')") |
| | | @ApiOperation("æ°å¢æ¨¡æ¿ç§å®¤å
³è") |
| | | @Log(title = "模æ¿ç§å®¤å
³è", businessType = BusinessType.INSERT) |
| | | @PostMapping("/add") |
| | | public AjaxResult add(@RequestBody List<TemplateDept> templateDepts) |
| | | { |
| | | return toAjax(templateDeptService.insertTemplateDept(templateDepts)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹æ¨¡æ¿ç§å®¤å
³è |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æ¨¡æ¿ç§å®¤å
³è") |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:edit')") |
| | | @Log(title = "模æ¿ç§å®¤å
³è", businessType = BusinessType.UPDATE) |
| | | @PostMapping("/edit") |
| | | public AjaxResult edit(@RequestBody TemplateDept templateDept) |
| | | { |
| | | return toAjax(templateDeptService.updateTemplateDept(templateDept)); |
| | | } |
| | | |
| | | /** |
| | | * å 餿¨¡æ¿ç§å®¤å
³è |
| | | */ |
| | | @ApiOperation("å 餿¨¡æ¿ç§å®¤å
³è") |
| | | //@PreAuthorize("@ss.hasPermi('smartor:dept:remove')") |
| | | @Log(title = "模æ¿ç§å®¤å
³è", businessType = BusinessType.DELETE) |
| | | @GetMapping("/remove/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) |
| | | { |
| | | return toAjax(templateDeptService.deleteTemplateDeptByIds(ids)); |
| | | } |
| | | } |
| | |
| | | import com.ruoyi.common.core.domain.entity.SysDept; |
| | | import com.ruoyi.common.core.domain.entity.SysRole; |
| | | import com.ruoyi.common.core.domain.entity.SysUser; |
| | | import com.ruoyi.common.core.domain.entity.SysUserDept; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.SecurityUtils; |
| | |
| | | import com.ruoyi.system.service.ISysPostService; |
| | | import com.ruoyi.system.service.ISysRoleService; |
| | | import com.ruoyi.system.service.ISysUserService; |
| | | import com.smartor.mapper.SysUserDeptMapper; |
| | | import org.apache.commons.lang3.ArrayUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | |
| | | |
| | | @Autowired |
| | | private ISysPostService postService; |
| | | |
| | | @Autowired |
| | | private SysUserDeptMapper sysUserDeptMapper; |
| | | |
| | | /** |
| | | * è·åç¨æ·å表 |
| | |
| | | ajax.put("postIds", postService.selectPostListByUserId(userId)); |
| | | ajax.put("roleIds", sysUser.getRoles().stream().map(SysRole::getRoleId).collect(Collectors.toList())); |
| | | } |
| | | List<SysUserDept> sysUserDeptKSs = null; |
| | | List<SysUserDept> sysUserDeptBQs = null; |
| | | SysUserDept sysUserDept = new SysUserDept(); |
| | | sysUserDept.setUserId(userId); |
| | | sysUserDept.setDeptType("1"); |
| | | sysUserDeptKSs = sysUserDeptMapper.selectSysUserDeptList(sysUserDept); |
| | | ajax.put("belongDepts",sysUserDeptKSs); |
| | | |
| | | sysUserDept.setDeptType("2"); |
| | | sysUserDeptBQs = sysUserDeptMapper.selectSysUserDeptList(sysUserDept); |
| | | ajax.put("belongWards",sysUserDeptBQs); |
| | | |
| | | return ajax; |
| | | } |
| | | |
| | |
| | | @PostMapping("/add") |
| | | public AjaxResult add(@RequestBody SysUserDept sysUserDept) |
| | | { |
| | | |
| | | return toAjax(sysUserDeptService.insertSysUserDept(sysUserDept)); |
| | | } |
| | | |
| | |
| | | private String deptName; |
| | | |
| | | /** |
| | | * é¨é¨ç±»åï¼0å
¨é¨ 1ç§å®¤ 2ç
åº |
| | | */ |
| | | @ApiModelProperty("é¨é¨ç±»åï¼0å
¨é¨ 1ç§å®¤ 2ç
åº") |
| | | private String deptType; |
| | | |
| | | /** |
| | | * æ¾ç¤ºé¡ºåº |
| | | */ |
| | | @ApiModelProperty("æ¾ç¤ºé¡ºåº") |
| | |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import javax.validation.constraints.*; |
| | | |
| | | import io.swagger.annotations.ApiModel; |
| | |
| | | /** |
| | | * ç
åºç¼ç |
| | | */ |
| | | @ApiModelProperty("ç
åºç¼ç ") |
| | | private List<String> leavehospitaldistrictcodes = new ArrayList<String>(); |
| | | @ApiModelProperty("ç
åºéå") |
| | | private List<Map<String, Object>> belongWards = new ArrayList(); |
| | | |
| | | /** |
| | | * ç§å®¤ç¼ç |
| | | */ |
| | | @ApiModelProperty("ç§å®¤ç¼ç ") |
| | | private List<String> leaveldeptcodes = new ArrayList<String>(); |
| | | @ApiModelProperty("ç§å®¤éå") |
| | | private List<Map<String, Object>> belongDepts = new ArrayList(); |
| | | |
| | | |
| | | public SysUser() { |
| | | |
| | | } |
| | | |
| | | public List<String> getLeavehospitaldistrictcodes() { |
| | | return leavehospitaldistrictcodes; |
| | | public List<Map<String, Object>> getBelongWards() { |
| | | return belongWards; |
| | | } |
| | | |
| | | public void setLeavehospitaldistrictcodes(List<String> leavehospitaldistrictcodes) { |
| | | this.leavehospitaldistrictcodes = leavehospitaldistrictcodes; |
| | | public void setBelongWards(List<Map<String, Object>> belongWards) { |
| | | this.belongWards = belongWards; |
| | | } |
| | | |
| | | public List<String> getLeaveldeptcodes() { |
| | | return leaveldeptcodes; |
| | | public List<Map<String, Object>> getBelongDepts() { |
| | | return belongDepts; |
| | | } |
| | | |
| | | public void setLeaveldeptcodes(List<String> leaveldeptcodes) { |
| | | this.leaveldeptcodes = leaveldeptcodes; |
| | | public void setBelongDepts(List<Map<String, Object>> belongDepts) { |
| | | this.belongDepts = belongDepts; |
| | | } |
| | | |
| | | public String getSearchscope() { |
| | |
| | | * é¨é¨ç±»å |
| | | */ |
| | | @ApiModelProperty("é¨é¨ç±»å") |
| | | @Excel(name = "é¨é¨ç±»å") |
| | | @Excel(name = "é¨é¨ç±»å 1:ç§å®¤ 2:ç
åº") |
| | | private String deptType; |
| | | |
| | | /** |
| | |
| | | @ApiModelProperty("é¨é¨ç¼ç ") |
| | | @Excel(name = "é¨é¨ç¼ç ") |
| | | private String deptCode; |
| | | /** |
| | | * é¨é¨ç¼ç |
| | | */ |
| | | @ApiModelProperty("é¨é¨åç§°") |
| | | @Excel(name = "é¨é¨åç§°") |
| | | private String deptName; |
| | | |
| | | /** |
| | | * é¨é¨ID |
| | |
| | | /** |
| | | * æ°å¢${functionName} |
| | | */ |
| | | @ApiOperation("æ°å¢${functionName}") |
| | | //@PreAuthorize("@ss.hasPermi('${permissionPrefix}:add')") |
| | | @Log(title = "${functionName}", businessType = BusinessType.INSERT) |
| | | @PostMapping("/add") |
| | |
| | | package com.ruoyi.system.service.impl; |
| | | |
| | | import com.ruoyi.common.core.domain.entity.SysDept; |
| | | import com.ruoyi.common.core.domain.entity.SysUserDept; |
| | | import com.ruoyi.system.mapper.SysDeptMapper; |
| | | import com.ruoyi.system.service.ISysUserDeptService; |
| | | import com.smartor.mapper.SysUserDeptMapper; |
| | | import org.apache.commons.collections4.CollectionUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | public class SysUserDeptServiceImpl implements ISysUserDeptService { |
| | | @Autowired |
| | | private SysUserDeptMapper sysUserDeptMapper; |
| | | |
| | | @Autowired |
| | | private SysDeptMapper sysDeptMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢ã请填ååè½åç§°ã |
| | |
| | | public int insertSysUserDept(SysUserDept sysUserDept) { |
| | | sysUserDept.setCreateTime(new Date()); |
| | | sysUserDept.setUpdateTime(new Date()); |
| | | //æ ¹æ®codeæ¥è¯¢deptName |
| | | SysDept dept = new SysDept(); |
| | | dept.setDeptCode(sysUserDept.getDeptCode()); |
| | | List<SysDept> sysDepts = sysDeptMapper.selectDeptList(dept); |
| | | if (CollectionUtils.isNotEmpty(sysDepts)) |
| | | sysUserDept.setDeptName(sysDepts.get(0).getDeptName()); |
| | | return sysUserDeptMapper.insertSysUserDept(sysUserDept); |
| | | } |
| | | |
| | |
| | | import org.springframework.util.CollectionUtils; |
| | | |
| | | import javax.validation.Validator; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | |
| | | } |
| | | |
| | | sysUser.setDepts(deptIds); |
| | | if (!CollectionUtils.isEmpty(sysUserDeptBQs)) |
| | | sysUser.setLeavehospitaldistrictcodes(sysUserDeptBQs.stream().map(SysUserDept::getDeptCode).collect(Collectors.toList())); |
| | | if (!CollectionUtils.isEmpty(sysUserDeptKSs)) |
| | | sysUser.setLeaveldeptcodes(sysUserDeptKSs.stream().map(SysUserDept::getDeptCode).collect(Collectors.toList())); |
| | | |
| | | if (!CollectionUtils.isEmpty(sysUserDeptBQs)) { |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | | for (SysUserDept sud : sysUserDeptBQs) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("districtCode", ""); |
| | | if (StringUtils.isNotEmpty(sud.getDeptCode())) map.put("districtCode", sud.getDeptCode()); |
| | | map.put("districtName", ""); |
| | | if (StringUtils.isNotEmpty(sud.getDeptName())) map.put("districtName", sud.getDeptName()); |
| | | list.add(map); |
| | | } |
| | | sysUser.setBelongWards(list); |
| | | } |
| | | if (!CollectionUtils.isEmpty(sysUserDeptKSs)) { |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | | for (SysUserDept sud : sysUserDeptKSs) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("deptCode", ""); |
| | | if (StringUtils.isNotEmpty(sud.getDeptCode())) map.put("deptCode", sud.getDeptCode()); |
| | | map.put("deptName", ""); |
| | | if (StringUtils.isNotEmpty(sud.getDeptName())) map.put("deptName", sud.getDeptName()); |
| | | list.add(map); |
| | | } |
| | | sysUser.setBelongDepts(list); |
| | | } |
| | | return sysUser; |
| | | } |
| | | |
| | |
| | | <result property="updateBy" column="update_by"/> |
| | | <result property="updateTime" column="update_time"/> |
| | | <result property="deptCode" column="dept_code"/> |
| | | <result property="deptType" column="dept_type"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectDeptVo"> |
| | |
| | | d.order_num, |
| | | d.leader, |
| | | d.phone, |
| | | d.dept_type, |
| | | d.email, |
| | | d.status, |
| | | d.del_flag, |
| | |
| | | <if test="deptCode != null and deptCode != ''"> |
| | | AND dept_code = #{deptCode} |
| | | </if> |
| | | <if test="deptType != null and deptType != ''"> |
| | | AND dept_type = #{deptType} |
| | | </if> |
| | | <!-- æ°æ®èå´è¿æ»¤ --> |
| | | ${params.dataScope} |
| | | order by d.parent_id, d.order_num |
| | |
| | | select d.dept_id, |
| | | d.parent_id, |
| | | d.dept_code, |
| | | d.dept_type, |
| | | d.ancestors, |
| | | d.dept_name, |
| | | d.order_num, |
| | |
| | | <if test="email != null and email != ''">email,</if> |
| | | <if test="status != null">status,</if> |
| | | <if test="deptCode != null">dept_code,</if> |
| | | <if test="deptType != null">dept_type,</if> |
| | | <if test="createBy != null and createBy != ''">create_by,</if> |
| | | create_time |
| | | )values( |
| | |
| | | <if test="email != null and email != ''">#{email},</if> |
| | | <if test="status != null">#{status},</if> |
| | | <if test="deptCode != null">#{deptCode},</if> |
| | | <if test="deptType != null">#{deptType},</if> |
| | | <if test="createBy != null and createBy != ''">#{createBy},</if> |
| | | sysdate() |
| | | ) |
| | |
| | | <if test="email != null">email = #{email},</if> |
| | | <if test="status != null and status != ''">status = #{status},</if> |
| | | <if test="deptCode != null">dept_code=#{deptCode},</if> |
| | | <if test="deptType != null">dept_type=#{deptType},</if> |
| | | <if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if> |
| | | update_time = sysdate() |
| | | </set> |
| | |
| | | private List<HeLibraryTag> heLibraryTagList = new ArrayList<>(); |
| | | |
| | | @ApiModelProperty("模æ¿ç§å®¤å
³è表") |
| | | private List<TempDetpRelevance> tempDetpRelevances = new ArrayList<>(); |
| | | private List<TemplateDept> tempDetpRelevances = new ArrayList<>(); |
| | | |
| | | /** |
| | | * æ¯å¦å卿ä½ï¼1 æ°å¢ 2ä¿®æ¹ 3å é¤ |
| | |
| | | private List<IvrLibaTemplateTag> ivrLibaTemplateTagList = new ArrayList<>(); |
| | | |
| | | @ApiModelProperty(value = "模æ¿ç§å®¤å
³è表éå") |
| | | private List<TempDetpRelevance> tempDetpRelevances = new ArrayList<>(); |
| | | private List<TemplateDept> tempDetpRelevances = new ArrayList<>(); |
| | | |
| | | } |
| | |
| | | * 模æ¿ç§å®¤å
³èéå |
| | | */ |
| | | @ApiModelProperty(value = "模æ¿ç§å®¤å
³èéå") |
| | | private List<TempDetpRelevance> tempDetpRelevances = new ArrayList<>(); |
| | | private List<TemplateDept> tempDetpRelevances = new ArrayList<>(); |
| | | |
| | | /** |
| | | * æ¯å¦å卿ä½ï¼1 æ°å¢ 2ä¿®æ¹ 3å é¤ |
| | |
| | | * 模æ¿ç§å®¤å
³èéå |
| | | */ |
| | | @ApiModelProperty(value = "模æ¿ç§å®¤å
³èéå") |
| | | private List<TempDetpRelevance> tempDetpRelevances = new ArrayList<>(); |
| | | private List<TemplateDept> tempDetpRelevances = new ArrayList<>(); |
| | | |
| | | /** |
| | | * æ¯å¦å卿ä½ï¼1 æ°å¢ 2ä¿®æ¹ 3å é¤ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.smartor.domain; |
| | | |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * 模æ¿ç§å®¤å
³è对象 template_dept |
| | | * |
| | | * @author lihu |
| | | * @date 2024-09-18 |
| | | */ |
| | | @Data |
| | | @ApiModel("模æ¿ç§å®¤å
³è") |
| | | public class TemplateDept extends BaseEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 模æ¿åºåç§å®¤å
³èid |
| | | */ |
| | | @ApiModelProperty("模æ¿åºåç§å®¤å
³èid") |
| | | //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** |
| | | * 1 : é®å·æ¨¡æ¿åºidã11ï¼é®å·ä»»å¡æ¨¡æ¿åºidï¼2 :è¯é³é®å·åºidã21ï¼è¯é³ä»»å¡æ¨¡æ¿åºidï¼3 : å®£ææ¨¡æ¿åºidï¼33ï¼å®£æä»»å¡æ¨¡æ¿åºid |
| | | */ |
| | | @ApiModelProperty("1 : é®å·æ¨¡æ¿åºidã11ï¼é®å·ä»»å¡æ¨¡æ¿åºidï¼2 :è¯é³é®å·åºidã21ï¼è¯é³ä»»å¡æ¨¡æ¿åºidï¼3 : å®£ææ¨¡æ¿åºidï¼33ï¼å®£æä»»å¡æ¨¡æ¿åºid") |
| | | @Excel(name = "1 : é®å·æ¨¡æ¿åºidã11ï¼é®å·ä»»å¡æ¨¡æ¿åºidï¼2 :è¯é³é®å·åºidã21ï¼è¯é³ä»»å¡æ¨¡æ¿åºidï¼3 : å®£ææ¨¡æ¿åºidï¼33ï¼å®£æä»»å¡æ¨¡æ¿åºid") |
| | | private Long type; |
| | | |
| | | /** |
| | | * 模æ¿id |
| | | */ |
| | | @ApiModelProperty("模æ¿id") |
| | | @Excel(name = "模æ¿id") |
| | | private Long tempid; |
| | | |
| | | /** |
| | | * ä»»å¡id |
| | | */ |
| | | @ApiModelProperty("ä»»å¡id") |
| | | @Excel(name = "ä»»å¡id") |
| | | private Long taskId; |
| | | |
| | | /** |
| | | * ç§å®¤id |
| | | */ |
| | | @ApiModelProperty("ç§å®¤id") |
| | | @Excel(name = "ç§å®¤id") |
| | | private Long deptId; |
| | | |
| | | /** |
| | | * é¨é¨ç¼ç |
| | | */ |
| | | @ApiModelProperty("é¨é¨ç¼ç ") |
| | | @Excel(name = "é¨é¨ç¼ç ") |
| | | private String deptCode; |
| | | |
| | | /** |
| | | * é¨é¨ç±»åï¼1ç§å®¤ï¼2ç
åº |
| | | */ |
| | | @ApiModelProperty("é¨é¨ç±»åï¼1ç§å®¤ï¼2ç
åº") |
| | | @Excel(name = "é¨é¨ç±»åï¼1ç§å®¤ï¼2ç
åº") |
| | | private String deptType; |
| | | |
| | | /** |
| | | * å 餿 å¿ï¼0ï¼æªå é¤ 1ï¼å·²å é¤ï¼ |
| | | */ |
| | | @ApiModelProperty("å 餿 å¿ï¼0ï¼æªå é¤ 1ï¼å·²å é¤ï¼") |
| | | private Integer delFlag; |
| | | |
| | | @ApiModelProperty(value = "æ¯å¦æ¯é¿ææ¨¡æ¿ï¼ 0ï¼ä¸æ¯ 1ï¼æ¯") |
| | | private Integer longTemp; |
| | | |
| | | |
| | | } |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.smartor.mapper; |
| | | |
| | | import com.smartor.domain.TemplateDept; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 模æ¿ç§å®¤å
³èMapperæ¥å£ |
| | | * |
| | | * @author lihu |
| | | * @date 2024-09-18 |
| | | */ |
| | | @Mapper |
| | | public interface TemplateDeptMapper |
| | | { |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return 模æ¿ç§å®¤å
³è |
| | | */ |
| | | public TemplateDept selectTemplateDeptById(Long id); |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³èå表 |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return 模æ¿ç§å®¤å
³èéå |
| | | */ |
| | | public List<TemplateDept> selectTemplateDeptList(TemplateDept templateDept); |
| | | |
| | | /** |
| | | * æ°å¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | public int insertTemplateDept(TemplateDept templateDept); |
| | | |
| | | /** |
| | | * ä¿®æ¹æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | public int updateTemplateDept(TemplateDept templateDept); |
| | | |
| | | /** |
| | | * å 餿¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteTemplateDeptById(Long id); |
| | | |
| | | /** |
| | | * æ¹éå 餿¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param ids éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteTemplateDeptByIds(Long[] ids); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.smartor.service; |
| | | |
| | | import java.util.List; |
| | | import com.smartor.domain.TemplateDept; |
| | | |
| | | /** |
| | | * 模æ¿ç§å®¤å
³èServiceæ¥å£ |
| | | * |
| | | * @author lihu |
| | | * @date 2024-09-18 |
| | | */ |
| | | public interface ITemplateDeptService |
| | | { |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return 模æ¿ç§å®¤å
³è |
| | | */ |
| | | public TemplateDept selectTemplateDeptById(Long id); |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³èå表 |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return 模æ¿ç§å®¤å
³èéå |
| | | */ |
| | | public List<TemplateDept> selectTemplateDeptList(TemplateDept templateDept); |
| | | |
| | | /** |
| | | * æ°å¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | public int insertTemplateDept(List<TemplateDept> templateDepts); |
| | | |
| | | /** |
| | | * ä¿®æ¹æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | public int updateTemplateDept(TemplateDept templateDept); |
| | | |
| | | /** |
| | | * æ¹éå 餿¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param ids éè¦å é¤ç模æ¿ç§å®¤å
³è主é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteTemplateDeptByIds(Long[] ids); |
| | | |
| | | /** |
| | | * å 餿¨¡æ¿ç§å®¤å
³èä¿¡æ¯ |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteTemplateDeptById(Long id); |
| | | } |
| | |
| | | package com.smartor.service.impl; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.ruoyi.common.exception.base.BaseException; |
| | | import com.ruoyi.common.utils.DateUtils; |
| | | import com.ruoyi.common.utils.DtoConversionUtils; |
| | | import com.smartor.domain.HeLibrary; |
| | | import com.smartor.domain.HeLibraryTag; |
| | | import com.smartor.domain.HeLibraryVO; |
| | | import com.smartor.domain.TempDetpRelevance; |
| | | import com.smartor.mapper.HeLibraryMapper; |
| | | import com.smartor.mapper.HeLibraryTagMapper; |
| | | import com.smartor.mapper.TempDetpRelevanceMapper; |
| | | import com.smartor.service.IHeLibraryService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.collections4.CollectionUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 宣æèµæåºServiceä¸å¡å±å¤ç |
| | |
| | | |
| | | @Autowired |
| | | private HeLibraryTagMapper heLibraryTagMapper; |
| | | |
| | | @Autowired |
| | | private TempDetpRelevanceMapper tempDetpRelevanceMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢å®£æèµæåº |
| | |
| | | private IvrLibaTemplateScriptMapper ivrLibaTemplateScriptMapper; |
| | | |
| | | @Autowired |
| | | private TempDetpRelevanceMapper tempDetpRelevanceMapper; |
| | | private TemplateDeptMapper tempDetpRelevanceMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿åº |
| | |
| | | } |
| | | |
| | | //对ç§å®¤è¿è¡å¤ç |
| | | for (TempDetpRelevance tempDetpRelevance : ivrLibaTemplateVO.getTempDetpRelevances()) { |
| | | for (TemplateDept tempDetpRelevance : ivrLibaTemplateVO.getTempDetpRelevances()) { |
| | | if (tempDetpRelevance.getId() == null) { |
| | | //æ°å¢ |
| | | tempDetpRelevance.setTempid(ivrLibaTemplate.getId()); |
| | | tempDetpRelevance.setType(2L); |
| | | tempDetpRelevance.setCreateTime(new Date()); |
| | | tempDetpRelevanceMapper.insertTempDetpRelevance(tempDetpRelevance); |
| | | tempDetpRelevanceMapper.insertTemplateDept(tempDetpRelevance); |
| | | } else { |
| | | tempDetpRelevance.setUpdateTime(new Date()); |
| | | tempDetpRelevanceMapper.updateTempDetpRelevance(tempDetpRelevance); |
| | | tempDetpRelevanceMapper.updateTemplateDept(tempDetpRelevance); |
| | | } |
| | | } |
| | | |
| | |
| | | import com.smartor.mapper.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.collections4.CollectionUtils; |
| | | import org.apache.commons.lang3.ObjectUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.stereotype.Service; |
| | |
| | | private PatArchiveMapper patArchiveMapper; |
| | | |
| | | @Autowired |
| | | private IvrLibaTemplateMapper ivrLibaTemplateMapper; |
| | | private TemplateDeptMapper templateDeptMapper; |
| | | |
| | | @Autowired |
| | | private IvrTaskTemplateMapper ivrTaskTemplateMapper; |
| | |
| | | for (PatMedInhosp patMedInhosp1 : patMedInhosps) { |
| | | //æ ¹æ®æ£è
æå¨ç§å®¤ï¼è·å该ç§å®¤çé¿æä»»å¡æ¨¡æ¿ |
| | | Long taskid = null; |
| | | SvyTaskTemplate svyTaskTemplate = new SvyTaskTemplate(); |
| | | svyTaskTemplate.setDeptCode(patMedInhosp1.getLeaveldeptcode()); |
| | | svyTaskTemplate.setLongTemp(1); |
| | | List<SvyTaskTemplate> svyTaskTemplates = svyTaskTemplateMapper.selectSvyTaskTemplateList(svyTaskTemplate); |
| | | //éè¿deptCodeè·åå
³èçé¿æä»»å¡æ¨¡æ¿ |
| | | TemplateDept templateDept = new TemplateDept(); |
| | | templateDept.setDeptCode(patMedInhosp1.getLeaveldeptcode()); |
| | | templateDept.setLongTemp(1); |
| | | templateDept.setType(11L); |
| | | List<TemplateDept> templateDepts = templateDeptMapper.selectTemplateDeptList(templateDept); |
| | | //æ ¹æ®è·åçé¿æä»»å¡æ¨¡æ¿IDï¼è·å任塿¨¡æ¿è¯¦æ
|
| | | List<SvyTaskTemplate> svyTaskTemplates = new ArrayList<>(); |
| | | if (CollectionUtils.isNotEmpty(templateDepts)) { |
| | | for (TemplateDept templateDept1 : templateDepts) { |
| | | SvyTaskTemplate svyTaskTemplate = svyTaskTemplateMapper.selectSvyTaskTemplateBySvyid(templateDept1.getTempid()); |
| | | if (ObjectUtils.isNotEmpty(svyTaskTemplate)) svyTaskTemplates.add(svyTaskTemplate); |
| | | } |
| | | } |
| | | //妿é¨é¨æ¨¡æ¿ä¸ºç©ºï¼æå®ï¼å°åºå
¥é¢è¡¨çcheck_flag设置为2 ï¼long_task_reason è®°å½åå ï¼ |
| | | if (CollectionUtils.isEmpty(svyTaskTemplates) || svyTaskTemplates.size() == 0) { |
| | | patMedInhosp1.setCheckFlag("2"); |
| | |
| | | @Autowired |
| | | private SvyLibTemplateTargetoptionMapper svyLibTemplateTargetoptionMapper; |
| | | @Autowired |
| | | private TempDetpRelevanceMapper tempDetpRelevanceMapper; |
| | | private TemplateDeptMapper templateDeptMapper; |
| | | @Autowired |
| | | private SvyLibTemplateTagMapper svyLibTemplateTagMapper; |
| | | @Autowired |
| | |
| | | List<SvyLibTemplateScript> svyLibTemplateScripts = svyLibTemplateScriptMapper.selectSvyLibTemplateScriptList(svyLibTemplateScript); |
| | | for (SvyLibTemplateScript svyLibTemplateScript1 : svyLibTemplateScripts) { |
| | | if (svyLibTemplateScript1.getScriptType().equals("1") || svyLibTemplateScript1.getScriptType().equals("2")) { |
| | | SvyLibTemplateTargetoption svyLibTemplateTargetoption=new SvyLibTemplateTargetoption(); |
| | | SvyLibTemplateTargetoption svyLibTemplateTargetoption = new SvyLibTemplateTargetoption(); |
| | | svyLibTemplateTargetoption.setScriptid(svyLibTemplateScript1.getId()); |
| | | List<SvyLibTemplateTargetoption> svyLibTemplateTargetoptions = svyLibTemplateTargetoptionMapper.selectSvyLibTemplateTargetoptionList(svyLibTemplateTargetoption); |
| | | svyLibTemplateScript1.setSvyLibTemplateTargetoptions(svyLibTemplateTargetoptions); |
| | |
| | | svyLibTemplateVOS.get(i).setSvyTemplateLibScripts(svyLibTemplateScripts); |
| | | |
| | | //è·åæ¯ä¸ªé®å·å¯¹åºçç§å®¤ |
| | | TempDetpRelevance tempDetpRelevance = new TempDetpRelevance(); |
| | | tempDetpRelevance.setTempid(svyLibTemplateVOS.get(i).getSvyid()); |
| | | List<TempDetpRelevance> tempDetpRelevances = tempDetpRelevanceMapper.selectTempDetpRelevanceList(tempDetpRelevance); |
| | | TemplateDept templateDept = new TemplateDept(); |
| | | templateDept.setTempid(svyLibTemplateVOS.get(i).getSvyid()); |
| | | List<TemplateDept> tempDetpRelevances = templateDeptMapper.selectTemplateDeptList(templateDept); |
| | | svyLibTemplateVOS.get(i).setTempDetpRelevances(CollectionUtils.isNotEmpty(tempDetpRelevances) ? tempDetpRelevances : new ArrayList<>()); |
| | | |
| | | //è·åæ ç¾ |
| | |
| | | } |
| | | |
| | | if (CollectionUtils.isNotEmpty(svyLibTemplate.getTempDetpRelevances())) { |
| | | for (TempDetpRelevance tempDetpRelevance : svyLibTemplate.getTempDetpRelevances()) { |
| | | for (TemplateDept tempDetpRelevance : svyLibTemplate.getTempDetpRelevances()) { |
| | | if (tempDetpRelevance.getId() == null) { |
| | | //æ°å¢ |
| | | tempDetpRelevance.setTempid(svyLibTemplate.getSvyid()); |
| | | tempDetpRelevance.setType(1L); |
| | | tempDetpRelevanceMapper.insertTempDetpRelevance(tempDetpRelevance); |
| | | templateDeptMapper.insertTemplateDept(tempDetpRelevance); |
| | | } else { |
| | | tempDetpRelevanceMapper.updateTempDetpRelevance(tempDetpRelevance); |
| | | templateDeptMapper.updateTemplateDept(tempDetpRelevance); |
| | | } |
| | | } |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.smartor.service.impl; |
| | | |
| | | import com.ruoyi.common.utils.DateUtils; |
| | | import com.smartor.domain.TemplateDept; |
| | | import com.smartor.mapper.TemplateDeptMapper; |
| | | import com.smartor.service.ITemplateDeptService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 模æ¿ç§å®¤å
³èServiceä¸å¡å±å¤ç |
| | | * |
| | | * @author lihu |
| | | * @date 2024-09-18 |
| | | */ |
| | | @Service |
| | | public class TemplateDeptServiceImpl implements ITemplateDeptService { |
| | | @Autowired |
| | | private TemplateDeptMapper templateDeptMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return 模æ¿ç§å®¤å
³è |
| | | */ |
| | | @Override |
| | | public TemplateDept selectTemplateDeptById(Long id) { |
| | | return templateDeptMapper.selectTemplateDeptById(id); |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¨¡æ¿ç§å®¤å
³èå表 |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return 模æ¿ç§å®¤å
³è |
| | | */ |
| | | @Override |
| | | public List<TemplateDept> selectTemplateDeptList(TemplateDept templateDept) { |
| | | return templateDeptMapper.selectTemplateDeptList(templateDept); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int insertTemplateDept(List<TemplateDept> templateDepts) { |
| | | for (TemplateDept templateDept : templateDepts) { |
| | | templateDept.setCreateTime(DateUtils.getNowDate()); |
| | | templateDeptMapper.insertTemplateDept(templateDept); |
| | | } |
| | | return 1; |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹æ¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param templateDept 模æ¿ç§å®¤å
³è |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int updateTemplateDept(TemplateDept templateDept) { |
| | | templateDept.setUpdateTime(DateUtils.getNowDate()); |
| | | return templateDeptMapper.updateTemplateDept(templateDept); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå 餿¨¡æ¿ç§å®¤å
³è |
| | | * |
| | | * @param ids éè¦å é¤ç模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteTemplateDeptByIds(Long[] ids) { |
| | | return templateDeptMapper.deleteTemplateDeptByIds(ids); |
| | | } |
| | | |
| | | /** |
| | | * å 餿¨¡æ¿ç§å®¤å
³èä¿¡æ¯ |
| | | * |
| | | * @param id 模æ¿ç§å®¤å
³èä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteTemplateDeptById(Long id) { |
| | | return templateDeptMapper.deleteTemplateDeptById(id); |
| | | } |
| | | } |
| | |
| | | <if test="deptname != null and deptname != ''"> |
| | | AND d.deptname LIKE concat('%',#{deptname}, '%') |
| | | </if> |
| | | <if test="leavehospitaldistrictcodes != null"> |
| | | <if test="leavehospitaldistrictcodes != null and leaveldeptcodes != null"> |
| | | AND d.leavehospitaldistrictcode IN |
| | | <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," |
| | | close=")"> |
| | | #{leavehospitaldistrictcode} |
| | | </foreach> |
| | | OR d.leaveldeptcode IN |
| | | <foreach collection="leaveldeptcodes" item="leaveldeptcode" open="(" separator="," |
| | | close=")"> |
| | | #{leaveldeptcode} |
| | | </foreach> |
| | | </if> |
| | | <if test="leavehospitaldistrictcodes != null and leaveldeptcodes == null"> |
| | | AND d.leavehospitaldistrictcode IN |
| | | <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," |
| | | close=")"> |
| | | #{leavehospitaldistrictcode} |
| | | </foreach> |
| | | </if> |
| | | <if test="leaveldeptcodes != null"> |
| | | <if test="leavehospitaldistrictcodes == null and leaveldeptcodes != null"> |
| | | AND d.leaveldeptcode IN |
| | | <foreach collection="leaveldeptcodes" item="leaveldeptcode" open="(" separator="," |
| | | close=")"> |
| | |
| | | <result property="deptId" column="dept_id"/> |
| | | <result property="delFlag" column="del_flag"/> |
| | | <result property="deptCode" column="dept_code"/> |
| | | <result property="deptName" column="dept_name"/> |
| | | <result property="deptType" column="dept_type"/> |
| | | <result property="createTime" column="create_time"/> |
| | | <result property="updateTime" column="update_time"/> |
| | |
| | | create_time, |
| | | update_time, |
| | | dept_code, |
| | | dept_name, |
| | | dept_type |
| | | from sys_user_dept |
| | | </sql> |
| | |
| | | </if> |
| | | <if test="updateTime != null "> |
| | | and update_time = #{updateTime} |
| | | </if> <if test="deptType != null "> |
| | | and dept_type = #{deptType} |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | <if test="deptCode != null "> |
| | | dept_code, |
| | | </if> |
| | | <if test="deptName != null "> |
| | | dept_name, |
| | | </if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="userId != null">#{userId}, |
| | |
| | | </if> |
| | | <if test="deptCode != null "> |
| | | #{deptCode}, |
| | | </if> |
| | | <if test="deptName != null "> |
| | | #{deptName}, |
| | | </if> |
| | | </trim> |
| | | </insert> |
| | |
| | | <if test="deptCode != null "> |
| | | dept_code = #{deptCode}, |
| | | </if> |
| | | <if test="deptName != null "> |
| | | dept_name = #{deptName}, |
| | | </if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | |
| | | </update> |
| | | |
| | | <select id="selectDeptListByUserId" resultMap="deptResult"> |
| | | select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.status as dept_status |
| | | select d.dept_id, |
| | | d.dept_name, |
| | | d.parent_id, |
| | | d.ancestors, |
| | | d.dept_name, |
| | | d.order_num, |
| | | d.leader, |
| | | d.status as dept_status |
| | | from sys_dept d |
| | | left join sys_user_dept ud on d.dept_id = ud.dept_id |
| | | where ud.user_id = #{userId} |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.TemplateDeptMapper"> |
| | | |
| | | <resultMap type="com.smartor.domain.TemplateDept" id="TemplateDeptResult"> |
| | | <result property="id" column="id"/> |
| | | <result property="type" column="type"/> |
| | | <result property="tempid" column="tempid"/> |
| | | <result property="taskId" column="task_id"/> |
| | | <result property="deptId" column="dept_id"/> |
| | | <result property="deptCode" column="dept_code"/> |
| | | <result property="deptType" column="dept_type"/> |
| | | <result property="longTemp" column="long_temp"/> |
| | | <result property="delFlag" column="del_flag"/> |
| | | <result property="createTime" column="create_time"/> |
| | | <result property="updateTime" column="update_time"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectTemplateDeptVo"> |
| | | select id, |
| | | type, |
| | | tempid, |
| | | task_id, |
| | | long_temp, |
| | | dept_id, |
| | | dept_code, |
| | | dept_type, |
| | | del_flag, |
| | | create_time, |
| | | update_time |
| | | from template_dept |
| | | </sql> |
| | | |
| | | <select id="selectTemplateDeptList" parameterType="com.smartor.domain.TemplateDept" |
| | | resultMap="TemplateDeptResult"> |
| | | <include refid="selectTemplateDeptVo"/> |
| | | <where> |
| | | <if test="type != null "> |
| | | and type = #{type} |
| | | </if> |
| | | <if test="tempid != null "> |
| | | and tempid = #{tempid} |
| | | </if> |
| | | <if test="taskId != null "> |
| | | and task_id = #{taskId} |
| | | </if> |
| | | <if test="deptId != null "> |
| | | and dept_id = #{deptId} |
| | | </if> |
| | | <if test="deptCode != null and deptCode != ''"> |
| | | and dept_code = #{deptCode} |
| | | </if> |
| | | <if test="deptType != null and deptType != ''"> |
| | | and dept_type = #{deptType} |
| | | </if> |
| | | <if test="longTemp != null and longTemp != ''"> |
| | | and long_temp = #{longTemp} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | |
| | | <select id="selectTemplateDeptById" parameterType="Long" |
| | | resultMap="TemplateDeptResult"> |
| | | <include refid="selectTemplateDeptVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertTemplateDept" parameterType="com.smartor.domain.TemplateDept" useGeneratedKeys="true" |
| | | keyProperty="id"> |
| | | insert into template_dept |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="type != null">type, |
| | | </if> |
| | | <if test="tempid != null">tempid, |
| | | </if> |
| | | <if test="taskId != null">task_id, |
| | | </if> |
| | | <if test="deptId != null">dept_id, |
| | | </if> |
| | | <if test="deptCode != null">dept_code, |
| | | </if> |
| | | <if test="deptType != null">dept_type, |
| | | </if> |
| | | <if test="delFlag != null">del_flag, |
| | | </if> |
| | | <if test="createTime != null">create_time, |
| | | </if> |
| | | <if test="updateTime != null">update_time, |
| | | </if> |
| | | <if test="longTemp != null and longTemp != ''"> |
| | | long_temp, |
| | | </if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="type != null">#{type}, |
| | | </if> |
| | | <if test="tempid != null">#{tempid}, |
| | | </if> |
| | | <if test="taskId != null">#{taskId}, |
| | | </if> |
| | | <if test="deptId != null">#{deptId}, |
| | | </if> |
| | | <if test="deptCode != null">#{deptCode}, |
| | | </if> |
| | | <if test="deptType != null">#{deptType}, |
| | | </if> |
| | | <if test="delFlag != null">#{delFlag}, |
| | | </if> |
| | | <if test="createTime != null">#{createTime}, |
| | | </if> |
| | | <if test="updateTime != null">#{updateTime}, |
| | | </if> |
| | | <if test="longTemp != null and longTemp != ''"> |
| | | #{longTemp}, |
| | | </if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateTemplateDept" parameterType="com.smartor.domain.TemplateDept"> |
| | | update template_dept |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="type != null">type = |
| | | #{type}, |
| | | </if> |
| | | <if test="tempid != null">tempid = |
| | | #{tempid}, |
| | | </if> |
| | | <if test="taskId != null">task_id = |
| | | #{taskId}, |
| | | </if> |
| | | <if test="deptId != null">dept_id = |
| | | #{deptId}, |
| | | </if> |
| | | <if test="deptCode != null">dept_code = |
| | | #{deptCode}, |
| | | </if> |
| | | <if test="deptType != null">dept_type = |
| | | #{deptType}, |
| | | </if> |
| | | <if test="delFlag != null">del_flag = |
| | | #{delFlag}, |
| | | </if> |
| | | <if test="createTime != null">create_time = |
| | | #{createTime}, |
| | | </if> |
| | | <if test="updateTime != null">update_time = |
| | | #{updateTime}, |
| | | </if> |
| | | <if test="longTemp != null and longTemp != ''"> |
| | | long_temp = #{longTemp}, |
| | | </if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <update id="deleteTemplateDeptById" parameterType="Long"> |
| | | update template_dept |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | del_flag =1 |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <update id="deleteTemplateDeptByIds" parameterType="String"> |
| | | update template_dept |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | del_flag =1 |
| | | </trim> |
| | | where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </update> |
| | | |
| | | |
| | | </mapper> |