| | |
| | | */ |
| | | @ApiOperation("å¯¼åºæ£è
æ¡£æ¡å表") |
| | | @PreAuthorize("@ss.hasPermi('smartor:patarchive:export')") |
| | | @Log(title = "æ£è
æ¡£æ¡", businessType = BusinessType.EXPORT) |
| | | @Log(title = "æ£è
æ¡£æ¡" , businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, PatArchive patArchive) { |
| | | List<PatArchive> list = patArchiveService.selectPatArchiveList(patArchive); |
| | |
| | | @ApiOperation("è·åæ£è
æ¡£æ¡è¯¦ç»ä¿¡æ¯") |
| | | @PreAuthorize("@ss.hasPermi('smartor:patarchive:query')") |
| | | @GetMapping(value = "/getInfo/{patid}") |
| | | @ApiImplicitParam(name = "patid", value = "æ£è
id") |
| | | @ApiImplicitParam(name = "patid" , value = "æ£è
id") |
| | | public AjaxResult getInfo(@PathVariable(name = "patid") Long patid) { |
| | | return success(patArchiveService.selectPatArchiveByPatid(patid)); |
| | | } |
| | |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æ£è
æ¡£æ¡") |
| | | @PreAuthorize("@ss.hasPermi('smartor:patarchive:update')") |
| | | @Log(title = "æ£è
æ¡£æ¡", businessType = BusinessType.UPDATE) |
| | | @Log(title = "æ£è
æ¡£æ¡" , businessType = BusinessType.UPDATE) |
| | | @PostMapping("/update") |
| | | public AjaxResult update(@RequestBody PatArchive patArchive) { |
| | | return toAjax(patArchiveService.update(patArchive)); |
| | |
| | | */ |
| | | @ApiOperation("æ°å¢æä¿®æ¹æ£è
档信æ¯") |
| | | @PreAuthorize("@ss.hasPermi('smartor:patarchive:edit')") |
| | | @Log(title = "æ£è
æ¡£æ¡", businessType = BusinessType.UPDATE) |
| | | @Log(title = "æ£è
æ¡£æ¡" , businessType = BusinessType.UPDATE) |
| | | @PostMapping("/saveOrUpdatePatInfo") |
| | | public AjaxResult saveOrUpdatePatInfo(@RequestBody PatArchiveVO patArchiveVO) { |
| | | return toAjax(patArchiveService.saveOrUpdatePatInfo(patArchiveVO)); |
| | |
| | | */ |
| | | @ApiOperation("å 餿£è
æ¡£æ¡") |
| | | @PreAuthorize("@ss.hasPermi('smartor:patarchive:remove')") |
| | | @Log(title = "æ£è
æ¡£æ¡", businessType = BusinessType.DELETE) |
| | | @Log(title = "æ£è
æ¡£æ¡" , businessType = BusinessType.DELETE) |
| | | @GetMapping("/remove/{patids}") |
| | | @ApiImplicitParam(name = "patids", value = "æ£è
idéå", dataType = "long", dataTypeClass = Long.class) |
| | | @ApiImplicitParam(name = "patids" , value = "æ£è
idéå" , dataType = "long" , dataTypeClass = Long.class) |
| | | public AjaxResult remove(@PathVariable Long[] patids) { |
| | | return toAjax(patArchiveService.deletePatArchiveByPatids(patids)); |
| | | } |
| | |
| | | */ |
| | | @ApiOperation("导å
¥æ£è
æä»¶å¤ç") |
| | | @PostMapping("/importFilehandle") |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "tags", value = "æ ç¾"), @ApiImplicitParam(name = "multipartFile", value = "ä¸ä¼ æä»¶")}) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "tags" , value = "æ ç¾"), @ApiImplicitParam(name = "multipartFile" , value = "ä¸ä¼ æä»¶")}) |
| | | public AjaxResult importFilehandle(@RequestParam("tags") String tags, @RequestParam("multipartFile") MultipartFile multipartFile) { |
| | | Executor executor = Executors.newFixedThreadPool(3); |
| | | //è·åå½åç»é人 |
| | |
| | | return getDataTable2(count, patientInfo); |
| | | } |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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)); |
| | | } |
| | | } |
| | |
| | | # 代ç çæ |
| | | gen: |
| | | gen: |
| | | # ä½è
|
| | | author: ruoyi |
| | | author: lihu |
| | | # é»è®¤çæå
è·¯å¾ system éæ¹æèªå·±ç模ååç§° å¦ system monitor tool |
| | | packageName: com.ruoyi.system |
| | | # packageName: com.ruoyi.system |
| | | packageName: com.smartor |
| | | # èªå¨å»é¤è¡¨åç¼ï¼é»è®¤æ¯false |
| | | autoRemovePre: false |
| | | # 表åç¼ï¼çæç±»åä¸ä¼å
å«è¡¨åç¼ï¼å¤ä¸ªç¨éå·åéï¼ |
| | | tablePrefix: sys_ |
| | | tablePrefix: sys_ |
| | |
| | | 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; |
| | |
| | | |
| | | /** |
| | | * ${functionName}Controller |
| | | * |
| | | * |
| | | * @author ${author} |
| | | * @date ${datetime} |
| | | */ |
| | | @Api("${functionName}") |
| | | @RestController |
| | | @RequestMapping("/${moduleName}/${businessName}") |
| | | public class ${ClassName}Controller extends BaseController |
| | |
| | | /** |
| | | * æ¥è¯¢${functionName}å表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢${functionName}å表") |
| | | @PreAuthorize("@ss.hasPermi('${permissionPrefix}:list')") |
| | | @GetMapping("/list") |
| | | #if($table.crud || $table.sub) |
| | |
| | | /** |
| | | * 导åº${functionName}å表 |
| | | */ |
| | | @ApiOperation("导åº${functionName}å表") |
| | | @PreAuthorize("@ss.hasPermi('${permissionPrefix}:export')") |
| | | @Log(title = "${functionName}", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | |
| | | /** |
| | | * è·å${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})); |
| | |
| | | */ |
| | | @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})); |
| | |
| | | /** |
| | | * ä¿®æ¹${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})); |
| | |
| | | /** |
| | | * å é¤${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)); |
| | |
| | | package ${packageName}.domain; |
| | | |
| | | #foreach ($import in $importList) |
| | | import ${import}; |
| | | #end |
| | | import org.apache.commons.lang3.builder.ToStringBuilder; |
| | | import org.apache.commons.lang3.builder.ToStringStyle; |
| | | #foreach ($import in $importList) |
| | | import ${import}; |
| | | #end |
| | | 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 |
| | | #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} |
| | | * |
| | | * |
| | | * @author ${author} |
| | | * @date ${datetime} |
| | | */ |
| | | #if($table.crud || $table.sub) |
| | | #set($Entity="BaseEntity") |
| | | #set($Entity="BaseEntity") |
| | | #elseif($table.tree) |
| | | #set($Entity="TreeEntity") |
| | | #set($Entity="TreeEntity") |
| | | #end |
| | | @Data |
| | | @ApiModel("${functionName}") |
| | | public class ${ClassName} extends ${Entity} |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | #foreach ($column in $columns) |
| | | #if(!$table.isSuperColumn($column.javaField)) |
| | | #if(!$table.isSuperColumn($column.javaField)) |
| | | /** $column.columnComment */ |
| | | #if($column.list) |
| | | #set($parentheseIndex=$column.columnComment.indexOf("ï¼")) |
| | | #if($parentheseIndex != -1) |
| | | #set($comment=$column.columnComment.substring(0, $parentheseIndex)) |
| | | #else |
| | | #set($comment=$column.columnComment) |
| | | #end |
| | | #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") |
| | | #else |
| | | @Excel(name = "${comment}") |
| | | #end |
| | | #end |
| | | @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) |
| | | #set($comment=$column.columnComment.substring(0, $parentheseIndex)) |
| | | #else |
| | | #set($comment=$column.columnComment) |
| | | #end |
| | | #if($parentheseIndex != -1) |
| | | @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()") |
| | | #elseif($column.javaType == 'Date') |
| | | @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 |
| | | #end |
| | | private $column.javaType $column.javaField; |
| | | |
| | | #end |
| | | #end |
| | | #end |
| | | #if($table.sub) |
| | | /** $table.subTable.functionNameä¿¡æ¯ */ |
| | | private List<${subClassName}> ${subclassName}List; |
| | | /** $table.subTable.functionNameä¿¡æ¯ */ |
| | | private List<${subClassName}> ${subclassName}List; |
| | | |
| | | #end |
| | | #foreach ($column in $columns) |
| | | #if(!$table.isSuperColumn($column.javaField)) |
| | | #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)}) |
| | | #if(!$table.isSuperColumn($column.javaField)) |
| | | #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 |
| | | #end |
| | | #end |
| | | public void set${AttrName}($column.javaType $column.javaField) |
| | | { |
| | | this.$column.javaField = $column.javaField; |
| | | } |
| | | } |
| | | |
| | | 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(); |
| | | } |
| | | } |
| | |
| | | package ${packageName}.mapper; |
| | | |
| | | import java.util.List; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import ${packageName}.domain.${ClassName}; |
| | | #if($table.sub) |
| | | import ${packageName}.domain.${subClassName}; |
| | |
| | | |
| | | /** |
| | | * ${functionName}Mapperæ¥å£ |
| | | * |
| | | * |
| | | * @author ${author} |
| | | * @date ${datetime} |
| | | */ |
| | | public interface ${ClassName}Mapper |
| | | @Mapper |
| | | public interface ${ClassName}Mapper |
| | | { |
| | | /** |
| | | * æ¥è¯¢${functionName} |
| | | * |
| | | * |
| | | * @param ${pkColumn.javaField} ${functionName}ä¸»é® |
| | | * @return ${functionName} |
| | | */ |
| | |
| | | |
| | | /** |
| | | * æ¥è¯¢${functionName}å表 |
| | | * |
| | | * |
| | | * @param ${className} ${functionName} |
| | | * @return ${functionName}éå |
| | | */ |
| | |
| | | |
| | | /** |
| | | * æ°å¢${functionName} |
| | | * |
| | | * |
| | | * @param ${className} ${functionName} |
| | | * @return ç»æ |
| | | */ |
| | |
| | | |
| | | /** |
| | | * ä¿®æ¹${functionName} |
| | | * |
| | | * |
| | | * @param ${className} ${functionName} |
| | | * @return ç»æ |
| | | */ |
| | |
| | | |
| | | /** |
| | | * å é¤${functionName} |
| | | * |
| | | * |
| | | * @param ${pkColumn.javaField} ${functionName}ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | |
| | | |
| | | /** |
| | | * æ¹éå é¤${functionName} |
| | | * |
| | | * |
| | | * @param ${pkColumn.javaField}s éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | |
| | | |
| | | /** |
| | | * æ¹éå é¤${subTable.functionName} |
| | | * |
| | | * |
| | | * @param ${pkColumn.javaField}s éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int delete${subClassName}By${subTableFkClassName}s(${pkColumn.javaType}[] ${pkColumn.javaField}s); |
| | | |
| | | |
| | | /** |
| | | * æ¹éæ°å¢${subTable.functionName} |
| | | * |
| | | * |
| | | * @param ${subclassName}List ${subTable.functionName}å表 |
| | | * @return ç»æ |
| | | */ |
| | | public int batch${subClassName}(List<${subClassName}> ${subclassName}List); |
| | | |
| | | |
| | | |
| | | /** |
| | | * éè¿${functionName}主é®å é¤${subTable.functionName}ä¿¡æ¯ |
| | | * |
| | | * |
| | | * @param ${pkColumn.javaField} ${functionName}ID |
| | | * @return ç»æ |
| | | */ |
| | |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "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 |
| | |
| | | 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> |
| | | <where> |
| | | #foreach($column in $columns) |
| | | #set($queryType=$column.queryType) |
| | | #set($javaField=$column.javaField) |
| | |
| | | #end |
| | | </where> |
| | | </select> |
| | | |
| | | |
| | | <select id="select${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}" resultMap="#if($table.sub)${ClassName}${subClassName}Result#else${ClassName}Result#end"> |
| | | #if($table.crud || $table.tree) |
| | | <include refid="select${ClassName}Vo"/> |
| | |
| | | where a.${pkColumn.columnName} = #{${pkColumn.javaField}} |
| | | #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) |
| | |
| | | </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) |
| | |
| | | </delete> |
| | | |
| | | <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String"> |
| | | delete from ${tableName} where ${pkColumn.columnName} in |
| | | delete from ${tableName} where ${pkColumn.columnName} in |
| | | <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")"> |
| | | #{${pkColumn.javaField}} |
| | | </foreach> |
| | | </delete> |
| | | #if($table.sub) |
| | | |
| | | |
| | | <delete id="delete${subClassName}By${subTableFkClassName}s" parameterType="String"> |
| | | delete from ${subTableName} where ${subTableFkName} in |
| | | delete from ${subTableName} where ${subTableFkName} in |
| | | <foreach item="${subTableFkclassName}" collection="array" open="(" separator="," close=")"> |
| | | #{${subTableFkclassName}} |
| | | </foreach> |
| | |
| | | </foreach> |
| | | </insert> |
| | | #end |
| | | </mapper> |
| | | </mapper> |
| | |
| | | * @author ls |
| | | * @date 2023-06-14 |
| | | */ |
| | | @ApiModel(value = "PatArchiveReq", description = "æ£è
æ¡£æ¡è¯·æ±å¯¹è±¡") |
| | | @ApiModel(value = "PatArchiveReq" , description = "æ£è
æ¡£æ¡è¯·æ±å¯¹è±¡") |
| | | @Data |
| | | public class PatArchiveReq { |
| | | /** |
| | |
| | | private Integer pageSize; |
| | | |
| | | |
| | | /** |
| | | * æ¯å¦è¿è |
| | | */ |
| | | @ApiModelProperty(value = " æ¯å¦è¿è,é»è®¤false ") |
| | | private boolean isFilter = false; |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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; |
| | | |
| | | } |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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); |
| | | } |
| | |
| | | |
| | | 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; |
| | | |
| | |
| | | * @date 2024-08-02 |
| | | */ |
| | | @Service |
| | | public class PatFilterlistServiceImpl implements IPatFilterlistService |
| | | { |
| | | public class PatFilterlistServiceImpl implements IPatFilterlistService { |
| | | @Autowired |
| | | private PatFilterlistMapper patFilterlistMapper; |
| | | @Autowired |
| | | private ServiceSubtaskMapper serviceSubtaskMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢æ£è
è¿æ»¤åå |
| | |
| | | * @return æ£è
è¿æ»¤åå |
| | | */ |
| | | @Override |
| | | public PatFilterlist selectPatFilterlistById(Long id) |
| | | { |
| | | public PatFilterlist selectPatFilterlistById(Long id) { |
| | | return patFilterlistMapper.selectPatFilterlistById(id); |
| | | } |
| | | |
| | |
| | | * @return æ£è
è¿æ»¤åå |
| | | */ |
| | | @Override |
| | | public List<PatFilterlist> selectPatFilterlistList(PatFilterlist patFilterlist) |
| | | { |
| | | public List<PatFilterlist> selectPatFilterlistList(PatFilterlist patFilterlist) { |
| | | return patFilterlistMapper.selectPatFilterlistList(patFilterlist); |
| | | } |
| | | |
| | |
| | | * @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); |
| | | } |
| | | |
| | |
| | | * @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); |
| | | } |
| | |
| | | * @param ids éè¦å é¤çæ£è
è¿æ»¤ååä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public int deletePatFilterlistByIds(Long[] ids) |
| | | { |
| | | public int deletePatFilterlistByIds(Long[] ids) { |
| | | return patFilterlistMapper.deletePatFilterlistByIds(ids); |
| | | } |
| | | |
| | |
| | | * @param id æ£è
è¿æ»¤ååä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public int deletePatFilterlistById(Long id) |
| | | { |
| | | public int deletePatFilterlistById(Long id) { |
| | | return patFilterlistMapper.deletePatFilterlistById(id); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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); |
| | | } |
| | | } |
| | |
| | | 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> |
| | |
| | | #{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> |
| | | |
| | |
| | | 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> |
| | |
| | | #{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> |
| | | |
| | |
| | | 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> |
| | |
| | | #{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> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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> |