ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatArchiveController.java
@@ -216,5 +216,6 @@ }); return getDataTable2(count, patientInfo); } } ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatSpeciallistCategoryController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,106 @@ 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.PatSpeciallistCategory; import com.smartor.service.IPatSpeciallistCategoryService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.List; /** * ä¸ç æ£è åç±»Controller * * @author ruoyi * @date 2024-08-05 */ @Api("ä¸ç æ£è åç±»") @RestController @RequestMapping("/smartor/patSpeciallistCategory") public class PatSpeciallistCategoryController extends BaseController { @Autowired private IPatSpeciallistCategoryService patSpeciallistCategoryService; /** * æ¥è¯¢ä¸ç æ£è åç±»å表 */ @ApiOperation("æ¥è¯¢ä¸ç æ£è åç±»å表") @PreAuthorize("@ss.hasPermi('system:category:list')") @GetMapping("/list") public TableDataInfo list(PatSpeciallistCategory patSpeciallistCategory) { startPage(); List<PatSpeciallistCategory> list = patSpeciallistCategoryService.selectPatSpeciallistCategoryList(patSpeciallistCategory); return getDataTable(list); } /** * 导åºä¸ç æ£è åç±»å表 */ @ApiOperation("导åºä¸ç æ£è åç±»å表") @PreAuthorize("@ss.hasPermi('system:category:export')") @Log(title = "ä¸ç æ£è åç±»", businessType = BusinessType.EXPORT) @PostMapping("/export") public void export(HttpServletResponse response, PatSpeciallistCategory patSpeciallistCategory) { List<PatSpeciallistCategory> list = patSpeciallistCategoryService.selectPatSpeciallistCategoryList(patSpeciallistCategory); ExcelUtil<PatSpeciallistCategory> util = new ExcelUtil<PatSpeciallistCategory>(PatSpeciallistCategory.class); util.exportExcel(response, list, "ä¸ç æ£è åç±»æ°æ®"); } /** * è·åä¸ç æ£è å类详ç»ä¿¡æ¯ */ @ApiOperation("è·åä¸ç æ£è å类详ç»ä¿¡æ¯") @PreAuthorize("@ss.hasPermi('system:category:query')") @GetMapping(value = "/getInfo/{id}") public AjaxResult getInfo(@PathVariable("id") Long id) { return success(patSpeciallistCategoryService.selectPatSpeciallistCategoryById(id)); } /** * æ°å¢ä¸ç æ£è åç±» */ @PreAuthorize("@ss.hasPermi('system:category:add')") @Log(title = "ä¸ç æ£è åç±»", businessType = BusinessType.INSERT) @PostMapping("/add") public AjaxResult add(@RequestBody PatSpeciallistCategory patSpeciallistCategory) { return toAjax(patSpeciallistCategoryService.insertPatSpeciallistCategory(patSpeciallistCategory)); } /** * ä¿®æ¹ä¸ç æ£è åç±» */ @ApiOperation("ä¿®æ¹ä¸ç æ£è åç±»") @PreAuthorize("@ss.hasPermi('system:category:edit')") @Log(title = "ä¸ç æ£è åç±»", businessType = BusinessType.UPDATE) @PostMapping("/edit") public AjaxResult edit(@RequestBody PatSpeciallistCategory patSpeciallistCategory) { return toAjax(patSpeciallistCategoryService.updatePatSpeciallistCategory(patSpeciallistCategory)); } /** * å é¤ä¸ç æ£è åç±» */ @ApiOperation("å é¤ä¸ç æ£è åç±»") @PreAuthorize("@ss.hasPermi('system:category:remove')") @Log(title = "ä¸ç æ£è åç±»", businessType = BusinessType.DELETE) @GetMapping("/remove/{ids}") public AjaxResult remove(@PathVariable Long[] ids) { return toAjax(patSpeciallistCategoryService.deletePatSpeciallistCategoryByIds(ids)); } } ruoyi-generator/src/main/resources/generator.yml
@@ -1,9 +1,10 @@ # 代ç çæ gen: # ä½è author: ruoyi author: lihu # é»è®¤çæå è·¯å¾ system éæ¹æèªå·±ç模ååç§° å¦ system monitor tool packageName: com.ruoyi.system # packageName: com.ruoyi.system packageName: com.smartor # èªå¨å»é¤è¡¨åç¼ï¼é»è®¤æ¯false autoRemovePre: false # 表åç¼ï¼çæç±»åä¸ä¼å å«è¡¨åç¼ï¼å¤ä¸ªç¨éå·åéï¼ ruoyi-generator/src/main/resources/vm/java/controller.java.vm
@@ -1,6 +1,8 @@ package ${packageName}.controller; import java.util.List; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import javax.servlet.http.HttpServletResponse; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.beans.factory.annotation.Autowired; @@ -30,6 +32,7 @@ * @author ${author} * @date ${datetime} */ @Api("${functionName}") @RestController @RequestMapping("/${moduleName}/${businessName}") public class ${ClassName}Controller extends BaseController @@ -40,6 +43,7 @@ /** * æ¥è¯¢${functionName}å表 */ @ApiOperation("æ¥è¯¢${functionName}å表") @PreAuthorize("@ss.hasPermi('${permissionPrefix}:list')") @GetMapping("/list") #if($table.crud || $table.sub) @@ -60,6 +64,7 @@ /** * 导åº${functionName}å表 */ @ApiOperation("导åº${functionName}å表") @PreAuthorize("@ss.hasPermi('${permissionPrefix}:export')") @Log(title = "${functionName}", businessType = BusinessType.EXPORT) @PostMapping("/export") @@ -73,8 +78,9 @@ /** * è·å${functionName}详ç»ä¿¡æ¯ */ @ApiOperation("è·å${functionName}详ç»ä¿¡æ¯") @PreAuthorize("@ss.hasPermi('${permissionPrefix}:query')") @GetMapping(value = "/{${pkColumn.javaField}}") @GetMapping(value = "/getInfo/{${pkColumn.javaField}}") public AjaxResult getInfo(@PathVariable("${pkColumn.javaField}") ${pkColumn.javaType} ${pkColumn.javaField}) { return success(${className}Service.select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaField})); @@ -85,7 +91,7 @@ */ @PreAuthorize("@ss.hasPermi('${permissionPrefix}:add')") @Log(title = "${functionName}", businessType = BusinessType.INSERT) @PostMapping @PostMapping("/add") public AjaxResult add(@RequestBody ${ClassName} ${className}) { return toAjax(${className}Service.insert${ClassName}(${className})); @@ -94,9 +100,10 @@ /** * ä¿®æ¹${functionName} */ @ApiOperation("ä¿®æ¹${functionName}") @PreAuthorize("@ss.hasPermi('${permissionPrefix}:edit')") @Log(title = "${functionName}", businessType = BusinessType.UPDATE) @PutMapping @PostMapping("/edit") public AjaxResult edit(@RequestBody ${ClassName} ${className}) { return toAjax(${className}Service.update${ClassName}(${className})); @@ -105,9 +112,10 @@ /** * å é¤${functionName} */ @ApiOperation("å é¤${functionName}") @PreAuthorize("@ss.hasPermi('${permissionPrefix}:remove')") @Log(title = "${functionName}", businessType = BusinessType.DELETE) @DeleteMapping("/{${pkColumn.javaField}s}") @GetMapping("/remove/{${pkColumn.javaField}s}") public AjaxResult remove(@PathVariable ${pkColumn.javaType}[] ${pkColumn.javaField}s) { return toAjax(${className}Service.delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaField}s)); ruoyi-generator/src/main/resources/vm/java/domain.java.vm
@@ -3,14 +3,17 @@ #foreach ($import in $importList) import ${import}; #end import org.apache.commons.lang3.builder.ToStringBuilder; import org.apache.commons.lang3.builder.ToStringStyle; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.ruoyi.common.annotation.Excel; #if($table.crud || $table.sub) import com.ruoyi.common.core.domain.BaseEntity; #elseif($table.tree) import com.ruoyi.common.core.domain.TreeEntity; #end import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; /** * ${functionName}对象 ${tableName} @@ -23,6 +26,8 @@ #elseif($table.tree) #set($Entity="TreeEntity") #end @Data @ApiModel("${functionName}") public class ${ClassName} extends ${Entity} { private static final long serialVersionUID = 1L; @@ -30,6 +35,11 @@ #foreach ($column in $columns) #if(!$table.isSuperColumn($column.javaField)) /** $column.columnComment */ @ApiModelProperty("$column.columnComment") #if($column.pk) //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) ## @TableId(type = IdType.AUTO) #end #if($column.list) #set($parentheseIndex=$column.columnComment.indexOf("ï¼")) #if($parentheseIndex != -1) @@ -40,8 +50,8 @@ #if($parentheseIndex != -1) @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") #elseif($column.javaType == 'Date') @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "${comment}", width = 30, dateFormat = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @Excel(name = "${comment}", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") #else @Excel(name = "${comment}") #end @@ -62,44 +72,7 @@ #else #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) #end public void set${AttrName}($column.javaType $column.javaField) { this.$column.javaField = $column.javaField; #end #end } public $column.javaType get${AttrName}() { return $column.javaField; } #end #end #if($table.sub) public List<${subClassName}> get${subClassName}List() { return ${subclassName}List; } public void set${subClassName}List(List<${subClassName}> ${subclassName}List) { this.${subclassName}List = ${subclassName}List; } #end @Override public String toString() { return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) #foreach ($column in $columns) #if($column.javaField.length() > 2 && $column.javaField.substring(1,2).matches("[A-Z]")) #set($AttrName=$column.javaField) #else #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) #end .append("${column.javaField}", get${AttrName}()) #end #if($table.sub) .append("${subclassName}List", get${subClassName}List()) #end .toString(); } } ruoyi-generator/src/main/resources/vm/java/mapper.java.vm
@@ -1,6 +1,7 @@ package ${packageName}.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import ${packageName}.domain.${ClassName}; #if($table.sub) import ${packageName}.domain.${subClassName}; @@ -12,6 +13,7 @@ * @author ${author} * @date ${datetime} */ @Mapper public interface ${ClassName}Mapper { /** ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm
@@ -4,7 +4,7 @@ "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="${packageName}.mapper.${ClassName}Mapper"> <resultMap type="${ClassName}" id="${ClassName}Result"> <resultMap type="${packageName}.domain.${ClassName}" id="${ClassName}Result"> #foreach ($column in $columns) <result property="${column.javaField}" column="${column.columnName}" /> #end @@ -26,7 +26,7 @@ select#foreach($column in $columns) $column.columnName#if($foreach.count != $columns.size()),#end#end from ${tableName} </sql> <select id="select${ClassName}List" parameterType="${ClassName}" resultMap="${ClassName}Result"> <select id="select${ClassName}List" parameterType="${packageName}.domain.${ClassName}" resultMap="${ClassName}Result"> <include refid="select${ClassName}Vo"/> <where> #foreach($column in $columns) @@ -72,7 +72,7 @@ #end </select> <insert id="insert${ClassName}" parameterType="${ClassName}"#if($pkColumn.increment) useGeneratedKeys="true" keyProperty="$pkColumn.javaField"#end> <insert id="insert${ClassName}" parameterType="${packageName}.domain.${ClassName}"#if($pkColumn.increment) useGeneratedKeys="true" keyProperty="$pkColumn.javaField"#end> insert into ${tableName} <trim prefix="(" suffix=")" suffixOverrides=","> #foreach($column in $columns) @@ -90,7 +90,7 @@ </trim> </insert> <update id="update${ClassName}" parameterType="${ClassName}"> <update id="update${ClassName}" parameterType="${packageName}.domain.${ClassName}"> update ${tableName} <trim prefix="SET" suffixOverrides=","> #foreach($column in $columns) smartor/src/main/java/com/smartor/domain/PatArchiveReq.java
@@ -135,6 +135,13 @@ @ApiModelProperty(value = "pageSize") @Excel(name = "pageSize") private Integer pageSize; /** * æ¯å¦è¿è */ @ApiModelProperty(value = " æ¯å¦è¿è,é»è®¤false ") private boolean isFilter = false; } smartor/src/main/java/com/smartor/domain/PatSpeciallistCategory.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,69 @@ 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; /** * ä¸ç æ£è å类对象 pat_speciallist_category * * @author ruoyi * @date 2024-08-05 */ @Data @ApiModel("ä¸ç æ£è åç±»") public class PatSpeciallistCategory extends BaseEntity { private static final long serialVersionUID = 1L; /** * $column.columnComment */ @ApiModelProperty("$column.columnComment") //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) private Long id; /** * åç±»åç§° */ @ApiModelProperty("åç±»åç§°") @Excel(name = "åç±»åç§°") private String name; /** * åºå· */ @ApiModelProperty("åºå·") @Excel(name = "åºå·") private Long seqno; /** * ç¶ID */ @ApiModelProperty("ç¶ID") @Excel(name = "ç¶ID") private Long pid; /** * GUID */ @ApiModelProperty("GUID") @Excel(name = "GUID") private String guid; /** * å»é¢æºæid */ @ApiModelProperty("å»é¢æºæid") @Excel(name = "å»é¢æºæid") private Long orgid; /** * å 餿 å¿ï¼0ï¼æªå é¤ 1ï¼å·²å é¤ï¼ */ @ApiModelProperty("å 餿 å¿ï¼0ï¼æªå é¤ 1ï¼å·²å é¤ï¼") private Long delFlag; } smartor/src/main/java/com/smartor/mapper/PatSpeciallistCategoryMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,64 @@ package com.smartor.mapper; import com.smartor.domain.PatSpeciallistCategory; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * ä¸ç æ£è åç±»Mapperæ¥å£ * * @author ruoyi * @date 2024-08-05 */ @Mapper public interface PatSpeciallistCategoryMapper { /** * æ¥è¯¢ä¸ç æ£è åç±» * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ä¸ç æ£è åç±» */ public PatSpeciallistCategory selectPatSpeciallistCategoryById(Long id); /** * æ¥è¯¢ä¸ç æ£è åç±»å表 * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ä¸ç æ£è åç±»éå */ public List<PatSpeciallistCategory> selectPatSpeciallistCategoryList(PatSpeciallistCategory patSpeciallistCategory); /** * æ°å¢ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ public int insertPatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory); /** * ä¿®æ¹ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ public int updatePatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory); /** * å é¤ä¸ç æ£è åç±» * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ç»æ */ public int deletePatSpeciallistCategoryById(Long id); /** * æ¹éå é¤ä¸ç æ£è åç±» * * @param ids éè¦å é¤çæ°æ®ä¸»é®éå * @return ç»æ */ public int deletePatSpeciallistCategoryByIds(Long[] ids); } smartor/src/main/java/com/smartor/service/IPatSpeciallistCategoryService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,62 @@ package com.smartor.service; import com.smartor.domain.PatSpeciallistCategory; import java.util.List; /** * ä¸ç æ£è åç±»Serviceæ¥å£ * * @author ruoyi * @date 2024-08-05 */ public interface IPatSpeciallistCategoryService { /** * æ¥è¯¢ä¸ç æ£è åç±» * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ä¸ç æ£è åç±» */ public PatSpeciallistCategory selectPatSpeciallistCategoryById(Long id); /** * æ¥è¯¢ä¸ç æ£è åç±»å表 * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ä¸ç æ£è åç±»éå */ public List<PatSpeciallistCategory> selectPatSpeciallistCategoryList(PatSpeciallistCategory patSpeciallistCategory); /** * æ°å¢ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ public int insertPatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory); /** * ä¿®æ¹ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ public int updatePatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory); /** * æ¹éå é¤ä¸ç æ£è åç±» * * @param ids éè¦å é¤çä¸ç æ£è å类主é®éå * @return ç»æ */ public int deletePatSpeciallistCategoryByIds(Long[] ids); /** * å é¤ä¸ç æ£è åç±»ä¿¡æ¯ * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ç»æ */ public int deletePatSpeciallistCategoryById(Long id); } smartor/src/main/java/com/smartor/service/impl/PatFilterlistServiceImpl.java
@@ -2,10 +2,14 @@ import com.ruoyi.common.utils.DateUtils; import com.smartor.domain.PatFilterlist; import com.smartor.domain.ServiceSubtask; import com.smartor.mapper.PatFilterlistMapper; import com.smartor.mapper.ServiceSubtaskMapper; import com.smartor.service.IPatFilterlistService; import org.apache.commons.collections4.CollectionUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; @@ -16,10 +20,11 @@ * @date 2024-08-02 */ @Service public class PatFilterlistServiceImpl implements IPatFilterlistService { public class PatFilterlistServiceImpl implements IPatFilterlistService { @Autowired private PatFilterlistMapper patFilterlistMapper; @Autowired private ServiceSubtaskMapper serviceSubtaskMapper; /** * æ¥è¯¢æ£è è¿æ»¤åå @@ -28,8 +33,7 @@ * @return æ£è è¿æ»¤åå */ @Override public PatFilterlist selectPatFilterlistById(Long id) { public PatFilterlist selectPatFilterlistById(Long id) { return patFilterlistMapper.selectPatFilterlistById(id); } @@ -40,8 +44,7 @@ * @return æ£è è¿æ»¤åå */ @Override public List<PatFilterlist> selectPatFilterlistList(PatFilterlist patFilterlist) { public List<PatFilterlist> selectPatFilterlistList(PatFilterlist patFilterlist) { return patFilterlistMapper.selectPatFilterlistList(patFilterlist); } @@ -51,10 +54,20 @@ * @param patFilterlist æ£è è¿æ»¤åå * @return ç»æ */ @Transactional(rollbackFor = Exception.class) @Override public int insertPatFilterlist(PatFilterlist patFilterlist) { public int insertPatFilterlist(PatFilterlist patFilterlist) { //å æ¥è¯¢ä¸ä¸ï¼è¯¥æ£è æ¯å¦ææ§è¡çä»»å¡ï¼å¦ææçè¯ï¼å°ä»»å¡æå ServiceSubtask serviceSubtask = new ServiceSubtask(); serviceSubtask.setPatid(patFilterlist.getPatid()); serviceSubtask.setDelFlag("0"); List<ServiceSubtask> selectServiceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(serviceSubtask); if (CollectionUtils.isNotEmpty(selectServiceSubtaskList)) { serviceSubtaskMapper.deleteServiceSubtaskById(selectServiceSubtaskList.get(0).getId()); } //æ°å¢æ£è è¿æ»¤ä¿¡æ¯ patFilterlist.setCreateTime(DateUtils.getNowDate()); patFilterlist.setUpdateTime(DateUtils.getNowDate()); return patFilterlistMapper.insertPatFilterlist(patFilterlist); } @@ -64,9 +77,9 @@ * @param patFilterlist æ£è è¿æ»¤åå * @return ç»æ */ @Transactional(rollbackFor = Exception.class) @Override public int updatePatFilterlist(PatFilterlist patFilterlist) { public int updatePatFilterlist(PatFilterlist patFilterlist) { patFilterlist.setUpdateTime(DateUtils.getNowDate()); return patFilterlistMapper.updatePatFilterlist(patFilterlist); } @@ -77,9 +90,9 @@ * @param ids éè¦å é¤çæ£è è¿æ»¤ååä¸»é® * @return ç»æ */ @Transactional(rollbackFor = Exception.class) @Override public int deletePatFilterlistByIds(Long[] ids) { public int deletePatFilterlistByIds(Long[] ids) { return patFilterlistMapper.deletePatFilterlistByIds(ids); } @@ -89,9 +102,9 @@ * @param id æ£è è¿æ»¤ååä¸»é® * @return ç»æ */ @Transactional(rollbackFor = Exception.class) @Override public int deletePatFilterlistById(Long id) { public int deletePatFilterlistById(Long id) { return patFilterlistMapper.deletePatFilterlistById(id); } } smartor/src/main/java/com/smartor/service/impl/PatSpeciallistCategoryServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,90 @@ package com.smartor.service.impl; import com.ruoyi.common.utils.DateUtils; import com.smartor.domain.PatSpeciallistCategory; import com.smartor.mapper.PatSpeciallistCategoryMapper; import com.smartor.service.IPatSpeciallistCategoryService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; /** * ä¸ç æ£è åç±»Serviceä¸å¡å±å¤ç * * @author ruoyi * @date 2024-08-05 */ @Service public class PatSpeciallistCategoryServiceImpl implements IPatSpeciallistCategoryService { @Autowired private PatSpeciallistCategoryMapper patSpeciallistCategoryMapper; /** * æ¥è¯¢ä¸ç æ£è åç±» * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ä¸ç æ£è åç±» */ @Override public PatSpeciallistCategory selectPatSpeciallistCategoryById(Long id) { return patSpeciallistCategoryMapper.selectPatSpeciallistCategoryById(id); } /** * æ¥è¯¢ä¸ç æ£è åç±»å表 * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ä¸ç æ£è åç±» */ @Override public List<PatSpeciallistCategory> selectPatSpeciallistCategoryList(PatSpeciallistCategory patSpeciallistCategory) { return patSpeciallistCategoryMapper.selectPatSpeciallistCategoryList(patSpeciallistCategory); } /** * æ°å¢ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ @Override public int insertPatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory) { patSpeciallistCategory.setCreateTime(DateUtils.getNowDate()); return patSpeciallistCategoryMapper.insertPatSpeciallistCategory(patSpeciallistCategory); } /** * ä¿®æ¹ä¸ç æ£è åç±» * * @param patSpeciallistCategory ä¸ç æ£è åç±» * @return ç»æ */ @Override public int updatePatSpeciallistCategory(PatSpeciallistCategory patSpeciallistCategory) { patSpeciallistCategory.setUpdateTime(DateUtils.getNowDate()); return patSpeciallistCategoryMapper.updatePatSpeciallistCategory(patSpeciallistCategory); } /** * æ¹éå é¤ä¸ç æ£è åç±» * * @param ids éè¦å é¤çä¸ç æ£è åç±»ä¸»é® * @return ç»æ */ @Override public int deletePatSpeciallistCategoryByIds(Long[] ids) { return patSpeciallistCategoryMapper.deletePatSpeciallistCategoryByIds(ids); } /** * å é¤ä¸ç æ£è åç±»ä¿¡æ¯ * * @param id ä¸ç æ£è åç±»ä¸»é® * @return ç»æ */ @Override public int deletePatSpeciallistCategoryById(Long id) { return patSpeciallistCategoryMapper.deletePatSpeciallistCategoryById(id); } } smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
@@ -315,6 +315,8 @@ LEFT JOIN ( SELECT patid, GROUP_CONCAT( tagname ) AS tagname FROM pat_archivetag GROUP BY patid ) t ON t.patid = d.patid <where> d.del_flag != 1 AND a.del_flag != 1 <if test="name != null and name != ''">and a.name like concat('%', #{name}, '%')</if> <if test="idcardno != null and idcardno != ''">and a.idcardno = #{idcardno}</if> <if test="pid != null and pid != ''">and a.id = #{id}</if> @@ -353,8 +355,9 @@ #{pid} </foreach> </if> AND d.del_flag != 1 AND a.del_flag != 1 <if test="isFilter == true"> AND NOT exists ( SELECT 1 FROM pat_filterlist f where d.patid=f.patid) </if> </where> </select> @@ -394,6 +397,8 @@ LEFT JOIN ( SELECT patid, GROUP_CONCAT( tagname ) AS tagname FROM pat_archivetag GROUP BY patid ) t ON t.patid = d.patid <where> d.del_flag != 1 AND a.del_flag != 1 <if test="pid != null and pid != ''">and a.id = #{pid}</if> <if test="name != null and name != ''">and a.name like concat('%', #{name}, '%')</if> <if test="idcardno != null and idcardno != ''">and a.idcardno = #{idcardno}</if> @@ -422,8 +427,9 @@ #{pid} </foreach> </if> AND d.del_flag != 1 AND a.del_flag != 1 <if test="isFilter == true"> AND NOT exists ( SELECT 1 FROM pat_filterlist f where d.patid=f.patid) </if> </where> </select> @@ -463,6 +469,8 @@ LEFT JOIN ( SELECT patid, GROUP_CONCAT( tagname ) AS tagname FROM pat_archivetag GROUP BY patid ) t ON t.patid = d.patid <where> d.del_flag != 1 AND a.del_flag != 1 <if test="pid != null and pid != ''">and a.id = #{pid}</if> <if test="name != null and name != ''">and a.name like concat('%', #{name}, '%')</if> <if test="idcardno != null and idcardno != ''">and a.idcardno = #{idcardno}</if> @@ -492,8 +500,9 @@ #{pid} </foreach> </if> AND d.del_flag != 1 AND a.del_flag != 1 <if test="isFilter == true"> AND NOT exists ( SELECT 1 FROM pat_filterlist f where d.patid=f.patid) </if> </where> </select> smartor/src/main/resources/mapper/smartor/PatSpeciallistCategoryMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,111 @@ <?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.PatSpeciallistCategoryMapper"> <resultMap type="com.smartor.domain.PatSpeciallistCategory" id="PatSpeciallistCategoryResult"> <result property="id" column="id"/> <result property="name" column="name"/> <result property="seqno" column="seqno"/> <result property="pid" column="pid"/> <result property="guid" column="guid"/> <result property="orgid" column="orgid"/> <result property="delFlag" column="del_flag"/> <result property="createBy" column="create_by"/> <result property="createTime" column="create_time"/> <result property="updateBy" column="update_by"/> <result property="updateTime" column="update_time"/> </resultMap> <sql id="selectPatSpeciallistCategoryVo"> select id, name, seqno, pid, guid, orgid, del_flag, create_by, create_time, update_by, update_time from pat_speciallist_category </sql> <select id="selectPatSpeciallistCategoryList" parameterType="com.smartor.domain.PatSpeciallistCategory" resultMap="PatSpeciallistCategoryResult"> <include refid="selectPatSpeciallistCategoryVo"/> <where> <if test="name != null and name != ''">and name like concat('%', #{name}, '%')</if> <if test="seqno != null ">and seqno = #{seqno}</if> <if test="pid != null ">and pid = #{pid}</if> <if test="guid != null and guid != ''">and guid = #{guid}</if> <if test="orgid != null ">and orgid = #{orgid}</if> </where> </select> <select id="selectPatSpeciallistCategoryById" parameterType="Long" resultMap="PatSpeciallistCategoryResult"> <include refid="selectPatSpeciallistCategoryVo"/> where id = #{id} </select> <insert id="insertPatSpeciallistCategory" parameterType="com.smartor.domain.PatSpeciallistCategory" useGeneratedKeys="true" keyProperty="id"> insert into pat_speciallist_category <trim prefix="(" suffix=")" suffixOverrides=","> <if test="name != null">name,</if> <if test="seqno != null">seqno,</if> <if test="pid != null">pid,</if> <if test="guid != null">guid,</if> <if test="orgid != null">orgid,</if> <if test="delFlag != null">del_flag,</if> <if test="createBy != null">create_by,</if> <if test="createTime != null">create_time,</if> <if test="updateBy != null">update_by,</if> <if test="updateTime != null">update_time,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="name != null">#{name},</if> <if test="seqno != null">#{seqno},</if> <if test="pid != null">#{pid},</if> <if test="guid != null">#{guid},</if> <if test="orgid != null">#{orgid},</if> <if test="delFlag != null">#{delFlag},</if> <if test="createBy != null">#{createBy},</if> <if test="createTime != null">#{createTime},</if> <if test="updateBy != null">#{updateBy},</if> <if test="updateTime != null">#{updateTime},</if> </trim> </insert> <update id="updatePatSpeciallistCategory" parameterType="com.smartor.domain.PatSpeciallistCategory"> update pat_speciallist_category <trim prefix="SET" suffixOverrides=","> <if test="name != null">name = #{name},</if> <if test="seqno != null">seqno = #{seqno},</if> <if test="pid != null">pid = #{pid},</if> <if test="guid != null">guid = #{guid},</if> <if test="orgid != null">orgid = #{orgid},</if> <if test="delFlag != null">del_flag = #{delFlag},</if> <if test="createBy != null">create_by = #{createBy},</if> <if test="createTime != null">create_time = #{createTime},</if> <if test="updateBy != null">update_by = #{updateBy},</if> <if test="updateTime != null">update_time = #{updateTime},</if> </trim> where id = #{id} </update> <delete id="deletePatSpeciallistCategoryById" parameterType="Long"> delete from pat_speciallist_category where id = #{id} </delete> <delete id="deletePatSpeciallistCategoryByIds" parameterType="String"> delete from pat_speciallist_category where id in <foreach item="id" collection="array" open="(" separator="," close=")"> #{id} </foreach> </delete> </mapper>