From 89e166f18d6e33efde0dda97f1fb27f29e675660 Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期一, 05 八月 2024 17:57:45 +0800 Subject: [PATCH] 代码提交 --- smartor/src/main/java/com/smartor/domain/PatMedOperation.java | 151 ++++++++++ ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm | 244 +++++++++------ smartor/src/main/java/com/smartor/service/IPatMedOperationService.java | 61 ++++ smartor/src/main/java/com/smartor/mapper/PatMedOperationMapper.java | 63 ++++ smartor/src/main/resources/mapper/smartor/PatMedOperationMapper.xml | 153 ++++++++++ ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationController.java | 108 +++++++ smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.java | 96 ++++++ 7 files changed, 781 insertions(+), 95 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationController.java new file mode 100644 index 0000000..3ef5d40 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationController.java @@ -0,0 +1,108 @@ +package com.ruoyi.web.controller.smartor; + +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; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.PatMedOperation; +import com.smartor.service.IPatMedOperationService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 鎮h�呮墜鏈褰旵ontroller + * + * @author lihu + * @date 2024-08-05 + */ +@Api("鎮h�呮墜鏈褰�") +@RestController +@RequestMapping("/smartor/operation") +public class PatMedOperationController extends BaseController { + @Autowired + private IPatMedOperationService patMedOperationService; + + /** + * 鏌ヨ鎮h�呮墜鏈褰曞垪琛� + */ + @ApiOperation("鏌ヨ鎮h�呮墜鏈褰曞垪琛�") + @PreAuthorize("@ss.hasPermi('smartor:operation:list')") + @GetMapping("/list") + public TableDataInfo list(PatMedOperation patMedOperation) { + startPage(); + List<PatMedOperation> list = patMedOperationService.selectPatMedOperationList(patMedOperation); + return getDataTable(list); + } + + /** + * 瀵煎嚭鎮h�呮墜鏈褰曞垪琛� + */ + @ApiOperation("瀵煎嚭鎮h�呮墜鏈褰曞垪琛�") + @PreAuthorize("@ss.hasPermi('smartor:operation:export')") + @Log(title = "鎮h�呮墜鏈褰�" , businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, PatMedOperation patMedOperation) { + List<PatMedOperation> list = patMedOperationService.selectPatMedOperationList(patMedOperation); + ExcelUtil<PatMedOperation> util = new ExcelUtil<PatMedOperation>(PatMedOperation.class); + util.exportExcel(response, list, "鎮h�呮墜鏈褰曟暟鎹�"); + } + + /** + * 鑾峰彇鎮h�呮墜鏈褰曡缁嗕俊鎭� + */ + @ApiOperation("鑾峰彇鎮h�呮墜鏈褰曡缁嗕俊鎭�") + @PreAuthorize("@ss.hasPermi('smartor:operation:query')") + @GetMapping(value = "/getInfo/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) { + return success(patMedOperationService.selectPatMedOperationById(id)); + } + + /** + * 鏂板鎮h�呮墜鏈褰� + */ + @PreAuthorize("@ss.hasPermi('smartor:operation:add')") + @Log(title = "鎮h�呮墜鏈褰�" , businessType = BusinessType.INSERT) + @PostMapping("/add") + public AjaxResult add(@RequestBody PatMedOperation patMedOperation) { + return toAjax(patMedOperationService.insertPatMedOperation(patMedOperation)); + } + + /** + * 淇敼鎮h�呮墜鏈褰� + */ + @ApiOperation("淇敼鎮h�呮墜鏈褰�") + @PreAuthorize("@ss.hasPermi('smartor:operation:edit')") + @Log(title = "鎮h�呮墜鏈褰�" , businessType = BusinessType.UPDATE) + @PostMapping("/edit") + public AjaxResult edit(@RequestBody PatMedOperation patMedOperation) { + return toAjax(patMedOperationService.updatePatMedOperation(patMedOperation)); + } + + /** + * 鍒犻櫎鎮h�呮墜鏈褰� + */ + @ApiOperation("鍒犻櫎鎮h�呮墜鏈褰�") + @PreAuthorize("@ss.hasPermi('smartor:operation:remove')") + @Log(title = "鎮h�呮墜鏈褰�" , businessType = BusinessType.DELETE) + @GetMapping("/remove/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) { + return toAjax(patMedOperationService.deletePatMedOperationByIds(ids)); + } +} diff --git a/ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm b/ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm index 588d65c..ca7df28 100644 --- a/ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm +++ b/ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm @@ -1,135 +1,189 @@ <?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"> + PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="${packageName}.mapper.${ClassName}Mapper"> <resultMap type="${packageName}.domain.${ClassName}" id="${ClassName}Result"> -#foreach ($column in $columns) - <result property="${column.javaField}" column="${column.columnName}" /> -#end + #foreach ($column in $columns) + <result property="${column.javaField}" column="${column.columnName}"/> + #end </resultMap> -#if($table.sub) + #if($table.sub) - <resultMap id="${ClassName}${subClassName}Result" type="${ClassName}" extends="${ClassName}Result"> - <collection property="${subclassName}List" notNullColumn="sub_${subTable.pkColumn.columnName}" javaType="java.util.List" resultMap="${subClassName}Result" /> - </resultMap> + <resultMap id="${ClassName}${subClassName}Result" type="${ClassName}" extends="${ClassName}Result"> + <collection property="${subclassName}List" notNullColumn="sub_${subTable.pkColumn.columnName}" + javaType="java.util.List" resultMap="${subClassName}Result"/> + </resultMap> - <resultMap type="${subClassName}" id="${subClassName}Result"> -#foreach ($column in $subTable.columns) - <result property="${column.javaField}" column="sub_${column.columnName}" /> -#end - </resultMap> -#end + <resultMap type="${subClassName}" id="${subClassName}Result"> + #foreach ($column in $subTable.columns) + <result property="${column.javaField}" column="sub_${column.columnName}"/> + #end + </resultMap> + #end <sql id="select${ClassName}Vo"> - select#foreach($column in $columns) $column.columnName#if($foreach.count != $columns.size()),#end#end from ${tableName} + select#foreach($column in $columns) $column.columnName#if($foreach.count != $columns.size()),#end#end + from ${tableName} </sql> - <select id="select${ClassName}List" parameterType="${packageName}.domain.${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) -#set($queryType=$column.queryType) -#set($javaField=$column.javaField) -#set($javaType=$column.javaType) -#set($columnName=$column.columnName) -#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) -#if($column.query) -#if($column.queryType == "EQ") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName = #{$javaField}</if> -#elseif($queryType == "NE") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName != #{$javaField}</if> -#elseif($queryType == "GT") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName > #{$javaField}</if> -#elseif($queryType == "GTE") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName >= #{$javaField}</if> -#elseif($queryType == "LT") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName < #{$javaField}</if> -#elseif($queryType == "LTE") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName <= #{$javaField}</if> -#elseif($queryType == "LIKE") - <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName like concat('%', #{$javaField}, '%')</if> -#elseif($queryType == "BETWEEN") - <if test="params.begin$AttrName != null and params.begin$AttrName != '' and params.end$AttrName != null and params.end$AttrName != ''"> and $columnName between #{params.begin$AttrName} and #{params.end$AttrName}</if> -#end -#end -#end + #foreach($column in $columns) + #set($queryType=$column.queryType) + #set($javaField=$column.javaField) + #set($javaType=$column.javaType) + #set($columnName=$column.columnName) + #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) + #if($column.query) + #if($column.queryType == "EQ") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName = #{$javaField} + </if> + #elseif($queryType == "NE") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName != #{$javaField} + </if> + #elseif($queryType == "GT") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName > #{$javaField} + </if> + #elseif($queryType == "GTE") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName >= #{$javaField} + </if> + #elseif($queryType == "LT") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName < #{$javaField} + </if> + #elseif($queryType == "LTE") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName <= #{$javaField} + </if> + #elseif($queryType == "LIKE") + <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> + and $columnName like concat('%', #{$javaField}, '%') + </if> + #elseif($queryType == "BETWEEN") + <if test="params.begin$AttrName != null and params.begin$AttrName != '' and params.end$AttrName != null and params.end$AttrName != ''"> + and $columnName between #{params.begin$AttrName} and #{params.end$AttrName} + </if> + #end + #end + #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 ${pkColumn.columnName} = #{${pkColumn.javaField}} -#elseif($table.sub) - select#foreach($column in $columns) a.$column.columnName#if($foreach.count != $columns.size()),#end#end, - #foreach($column in $subTable.columns) b.$column.columnName as sub_$column.columnName#if($foreach.count != $subTable.columns.size()),#end#end + <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 ${pkColumn.columnName} = #{${pkColumn.javaField}} + #elseif($table.sub) + select#foreach($column in $columns) a.$column.columnName#if($foreach.count != $columns.size()),#end#end, + #foreach($column in $subTable.columns) b.$column.columnName as + sub_$column.columnName#if($foreach.count != $subTable.columns.size()),#end#end - from ${tableName} a - left join ${subTableName} b on b.${subTableFkName} = a.${pkColumn.columnName} - where a.${pkColumn.columnName} = #{${pkColumn.javaField}} -#end + from ${tableName} a + left join ${subTableName} b on b.${subTableFkName} = a.${pkColumn.columnName} + where a.${pkColumn.columnName} = #{${pkColumn.javaField}} + #end </select> - <insert id="insert${ClassName}" parameterType="${packageName}.domain.${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) -#if($column.columnName != $pkColumn.columnName || !$pkColumn.increment) - <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName,</if> -#end -#end - </trim> + #foreach($column in $columns) + #if($column.columnName != $pkColumn.columnName || !$pkColumn.increment) + <if test="$column.javaField != null#if($column.javaType == + 'String' && $column.required) and $column.javaField != ''#end">$column.columnName, + </if> + #end + #end + </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> -#foreach($column in $columns) -#if($column.columnName != $pkColumn.columnName || !$pkColumn.increment) - <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">#{$column.javaField},</if> -#end -#end - </trim> + #foreach($column in $columns) + #if($column.columnName != $pkColumn.columnName || !$pkColumn.increment) + <if test="$column.javaField != null#if($column.javaType == + 'String' && $column.required) and $column.javaField != ''#end">#{$column.javaField}, + </if> + #end + #end + </trim> </insert> <update id="update${ClassName}" parameterType="${packageName}.domain.${ClassName}"> update ${tableName} <trim prefix="SET" suffixOverrides=","> -#foreach($column in $columns) -#if($column.columnName != $pkColumn.columnName) - <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName = #{$column.javaField},</if> -#end -#end + #foreach($column in $columns) + #if($column.columnName != $pkColumn.columnName) + <if test="$column.javaField != null#if($column.javaType == + 'String' && $column.required) and $column.javaField != ''#end">$column.columnName = + #{$column.javaField}, + </if> + #end + #end </trim> where ${pkColumn.columnName} = #{${pkColumn.javaField}} </update> - <delete id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}"> - delete from ${tableName} where ${pkColumn.columnName} = #{${pkColumn.javaField}} - </delete> + ## <delete id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}"> + ## delete from ${tableName} where ${pkColumn.columnName} = #{${pkColumn.javaField}} + ## </delete> + <update id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}"> + update ${tableName} + <trim prefix="SET" suffixOverrides=","> + del_flag =1 + </trim> + where ${pkColumn.columnName} = #{${pkColumn.javaField}} + </update> - <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String"> - delete from ${tableName} where ${pkColumn.columnName} in + ## <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String"> + ## delete from ${tableName} where ${pkColumn.columnName} in + ## <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")"> + ## #{${pkColumn.javaField}} + ## </foreach> + ## </delete> + <update id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String"> + update ${tableName} + <trim prefix="SET" suffixOverrides=","> + del_flag =1 + </trim> + where ${pkColumn.columnName} in <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")"> #{${pkColumn.javaField}} </foreach> - </delete> -#if($table.sub) + </update> - <delete id="delete${subClassName}By${subTableFkClassName}s" parameterType="String"> - delete from ${subTableName} where ${subTableFkName} in - <foreach item="${subTableFkclassName}" collection="array" open="(" separator="," close=")"> - #{${subTableFkclassName}} - </foreach> - </delete> - <delete id="delete${subClassName}By${subTableFkClassName}" parameterType="${pkColumn.javaType}"> - delete from ${subTableName} where ${subTableFkName} = #{${subTableFkclassName}} - </delete> - <insert id="batch${subClassName}"> - insert into ${subTableName}(#foreach($column in $subTable.columns) $column.columnName#if($foreach.count != $subTable.columns.size()),#end#end) values - <foreach item="item" index="index" collection="list" separator=","> - (#foreach($column in $subTable.columns) #{item.$column.javaField}#if($foreach.count != $subTable.columns.size()),#end#end) - </foreach> - </insert> -#end + + #if($table.sub) + + <delete id="delete${subClassName}By${subTableFkClassName}s" parameterType="String"> + delete from ${subTableName} where ${subTableFkName} in + <foreach item="${subTableFkclassName}" collection="array" open="(" separator="," close=")"> + #{${subTableFkclassName}} + </foreach> + </delete> + + <delete id="delete${subClassName}By${subTableFkClassName}" parameterType="${pkColumn.javaType}"> + delete + from ${subTableName} where ${subTableFkName} = #{${subTableFkclassName}} + </delete> + + <insert id="batch${subClassName}"> + insert into ${subTableName} + (#foreach($column in $subTable.columns) $column.columnName#if($foreach.count != $subTable.columns.size()) + ,#end#end) values + <foreach item="item" index="index" collection="list" separator=","> + (#foreach($column in $subTable.columns) #{item.$column.javaField + }#if($foreach.count != $subTable.columns.size()),#end#end) + </foreach> + </insert> + #end </mapper> diff --git a/smartor/src/main/java/com/smartor/domain/PatMedOperation.java b/smartor/src/main/java/com/smartor/domain/PatMedOperation.java new file mode 100644 index 0000000..7098106 --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/PatMedOperation.java @@ -0,0 +1,151 @@ +package com.smartor.domain; + +import com.fasterxml.jackson.annotation.JsonFormat; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +/** + * 鎮h�呮墜鏈褰曞璞� pat_med_operation + * + * @author lihu + * @date 2024-08-05 + */ +@Data +@ApiModel("鎮h�呮墜鏈褰�") +public class PatMedOperation extends BaseEntity { + private static final long serialVersionUID = 1L; + + /** + * 鑷ID + */ + @ApiModelProperty("鑷ID") + private Long id; + + /** + * 灏辫瘖娴佹按鍙� + */ + @ApiModelProperty("灏辫瘖娴佹按鍙�") + @Excel(name = "灏辫瘖娴佹按鍙�") + private String serialnum; + + /** + * 妗fID + */ + @ApiModelProperty("妗fID") + @Excel(name = "妗fID") + private Long patid; + + /** + * 鎵嬫湳鍚嶇О + */ + @ApiModelProperty("鎵嬫湳鍚嶇О") + @Excel(name = "鎵嬫湳鍚嶇О") + private String operationname; + + /** + * 鎵嬫湳浠g爜 + */ + @ApiModelProperty("鎵嬫湳浠g爜") + @Excel(name = "鎵嬫湳浠g爜") + private String operationcode; + + /** + * 鎵嬫湳ID + */ + @ApiModelProperty("鎵嬫湳ID") + @Excel(name = "鎵嬫湳ID") + private Long operationid; + + /** + * 鎵嬫湳鏃堕棿 + */ + @ApiModelProperty("鎵嬫湳鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "鎵嬫湳鏃堕棿" , width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date operationtime; + + /** + * 灏辫瘖ID + */ + @ApiModelProperty("灏辫瘖ID") + @Excel(name = "灏辫瘖ID") + private Long visitid; + + /** + * 灏辫瘖绫诲瀷;1闂ㄨ瘖 2浣忛櫌 3浣撴 + */ + @ApiModelProperty("灏辫瘖绫诲瀷;1闂ㄨ瘖 2浣忛櫌 3浣撴") + @Excel(name = "灏辫瘖绫诲瀷;1闂ㄨ瘖 2浣忛櫌 3浣撴") + private Long visittype; + + /** + * 鎵嬫湳鐘舵��;0鏈紑濮� 1宸插畬鎴� + */ + @ApiModelProperty("鎵嬫湳鐘舵��;0鏈紑濮� 1宸插畬鎴�") + @Excel(name = "鎵嬫湳鐘舵��;0鏈紑濮� 1宸插畬鎴�") + private Long status; + + /** + * 鏂规鐘舵�佹搷浣滄椂闂� + */ + @ApiModelProperty("鏂规鐘舵�佹搷浣滄椂闂�") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "鏂规鐘舵�佹搷浣滄椂闂�" , width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date schemetime; + + /** + * 鏄惁鐢熸垚璁″垝;0鏈敓鎴� 1鐢熸垚鎵嬫湳鍓� 2鐢熸垚鎵嬫湳鍚� 9鏃犲尮閰嶆柟妗� + */ + @ApiModelProperty("鏄惁鐢熸垚璁″垝;0鏈敓鎴� 1鐢熸垚鎵嬫湳鍓� 2鐢熸垚鎵嬫湳鍚� 9鏃犲尮閰嶆柟妗�") + @Excel(name = "鏄惁鐢熸垚璁″垝;0鏈敓鎴� 1鐢熸垚鎵嬫湳鍓� 2鐢熸垚鎵嬫湳鍚� 9鏃犲尮閰嶆柟妗�") + private Long schemestatus; + + /** + * 鏈烘瀯ID + */ + @ApiModelProperty("鏈烘瀯ID") + @Excel(name = "鏈烘瀯ID") + private String orgid; + + /** + * 鍒犻櫎鏍囧織锛�0锛氭湭鍒犻櫎 1锛氬凡鍒犻櫎锛� + */ + @ApiModelProperty("鍒犻櫎鏍囧織锛�0锛氭湭鍒犻櫎 1锛氬凡鍒犻櫎锛�") + private String delFlag; + + /** + * 涓婁紶鏍囧織锛�0锛氭湭涓婁紶 1锛氬凡涓婁紶锛� + */ + @ApiModelProperty("涓婁紶鏍囧織锛�0锛氭湭涓婁紶 1锛氬凡涓婁紶锛�") + @Excel(name = "涓婁紶鏍囧織" , readConverterExp = "0=锛氭湭涓婁紶,1=锛氬凡涓婁紶") + private Long isupload; + + /** + * 涓婁紶鏃堕棿 + */ + @ApiModelProperty("涓婁紶鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "涓婁紶鏃堕棿" , width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date uploadTime; + + /** + * 鐖禝D + */ + @ApiModelProperty("鐖禝D") + @Excel(name = "鐖禝D") + private Long pid; + + /** + * GUID + */ + @ApiModelProperty("GUID") + @Excel(name = "GUID") + private String guid; + +} + diff --git a/smartor/src/main/java/com/smartor/mapper/PatMedOperationMapper.java b/smartor/src/main/java/com/smartor/mapper/PatMedOperationMapper.java new file mode 100644 index 0000000..285e118 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/PatMedOperationMapper.java @@ -0,0 +1,63 @@ +package com.smartor.mapper; + +import java.util.List; +import org.apache.ibatis.annotations.Mapper; +import com.smartor.domain.PatMedOperation; + +/** + * 鎮h�呮墜鏈褰昅apper鎺ュ彛 + * + * @author lihu + * @date 2024-08-05 + */ +@Mapper +public interface PatMedOperationMapper +{ + /** + * 鏌ヨ鎮h�呮墜鏈褰� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 鎮h�呮墜鏈褰� + */ + public PatMedOperation selectPatMedOperationById(Long id); + + /** + * 鏌ヨ鎮h�呮墜鏈褰曞垪琛� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 鎮h�呮墜鏈褰曢泦鍚� + */ + public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation); + + /** + * 鏂板鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + public int insertPatMedOperation(PatMedOperation patMedOperation); + + /** + * 淇敼鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + public int updatePatMedOperation(PatMedOperation patMedOperation); + + /** + * 鍒犻櫎鎮h�呮墜鏈褰� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 缁撴灉 + */ + public int deletePatMedOperationById(Long id); + + /** + * 鎵归噺鍒犻櫎鎮h�呮墜鏈褰� + * + * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deletePatMedOperationByIds(Long[] ids); +} diff --git a/smartor/src/main/java/com/smartor/service/IPatMedOperationService.java b/smartor/src/main/java/com/smartor/service/IPatMedOperationService.java new file mode 100644 index 0000000..1a90115 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IPatMedOperationService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.PatMedOperation; + +/** + * 鎮h�呮墜鏈褰昐ervice鎺ュ彛 + * + * @author lihu + * @date 2024-08-05 + */ +public interface IPatMedOperationService +{ + /** + * 鏌ヨ鎮h�呮墜鏈褰� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 鎮h�呮墜鏈褰� + */ + public PatMedOperation selectPatMedOperationById(Long id); + + /** + * 鏌ヨ鎮h�呮墜鏈褰曞垪琛� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 鎮h�呮墜鏈褰曢泦鍚� + */ + public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation); + + /** + * 鏂板鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + public int insertPatMedOperation(PatMedOperation patMedOperation); + + /** + * 淇敼鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + public int updatePatMedOperation(PatMedOperation patMedOperation); + + /** + * 鎵归噺鍒犻櫎鎮h�呮墜鏈褰� + * + * @param ids 闇�瑕佸垹闄ょ殑鎮h�呮墜鏈褰曚富閿泦鍚� + * @return 缁撴灉 + */ + public int deletePatMedOperationByIds(Long[] ids); + + /** + * 鍒犻櫎鎮h�呮墜鏈褰曚俊鎭� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 缁撴灉 + */ + public int deletePatMedOperationById(Long id); +} diff --git a/smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.java new file mode 100644 index 0000000..436ed44 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.PatMedOperationMapper; +import com.smartor.domain.PatMedOperation; +import com.smartor.service.IPatMedOperationService; + +/** + * 鎮h�呮墜鏈褰昐ervice涓氬姟灞傚鐞� + * + * @author lihu + * @date 2024-08-05 + */ +@Service +public class PatMedOperationServiceImpl implements IPatMedOperationService +{ + @Autowired + private PatMedOperationMapper patMedOperationMapper; + + /** + * 鏌ヨ鎮h�呮墜鏈褰� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 鎮h�呮墜鏈褰� + */ + @Override + public PatMedOperation selectPatMedOperationById(Long id) + { + return patMedOperationMapper.selectPatMedOperationById(id); + } + + /** + * 鏌ヨ鎮h�呮墜鏈褰曞垪琛� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 鎮h�呮墜鏈褰� + */ + @Override + public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation) + { + return patMedOperationMapper.selectPatMedOperationList(patMedOperation); + } + + /** + * 鏂板鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + @Override + public int insertPatMedOperation(PatMedOperation patMedOperation) + { + patMedOperation.setCreateTime(DateUtils.getNowDate()); + return patMedOperationMapper.insertPatMedOperation(patMedOperation); + } + + /** + * 淇敼鎮h�呮墜鏈褰� + * + * @param patMedOperation 鎮h�呮墜鏈褰� + * @return 缁撴灉 + */ + @Override + public int updatePatMedOperation(PatMedOperation patMedOperation) + { + patMedOperation.setUpdateTime(DateUtils.getNowDate()); + return patMedOperationMapper.updatePatMedOperation(patMedOperation); + } + + /** + * 鎵归噺鍒犻櫎鎮h�呮墜鏈褰� + * + * @param ids 闇�瑕佸垹闄ょ殑鎮h�呮墜鏈褰曚富閿� + * @return 缁撴灉 + */ + @Override + public int deletePatMedOperationByIds(Long[] ids) + { + return patMedOperationMapper.deletePatMedOperationByIds(ids); + } + + /** + * 鍒犻櫎鎮h�呮墜鏈褰曚俊鎭� + * + * @param id 鎮h�呮墜鏈褰曚富閿� + * @return 缁撴灉 + */ + @Override + public int deletePatMedOperationById(Long id) + { + return patMedOperationMapper.deletePatMedOperationById(id); + } +} diff --git a/smartor/src/main/resources/mapper/smartor/PatMedOperationMapper.xml b/smartor/src/main/resources/mapper/smartor/PatMedOperationMapper.xml new file mode 100644 index 0000000..f21e649 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/PatMedOperationMapper.xml @@ -0,0 +1,153 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.PatMedOperationMapper"> + + <resultMap type="com.smartor.domain.PatMedOperation" id="PatMedOperationResult"> + <result property="id" column="id" /> + <result property="serialnum" column="serialnum" /> + <result property="patid" column="patid" /> + <result property="operationname" column="operationname" /> + <result property="operationcode" column="operationcode" /> + <result property="operationid" column="operationid" /> + <result property="operationtime" column="operationtime" /> + <result property="visitid" column="visitid" /> + <result property="visittype" column="visittype" /> + <result property="status" column="status" /> + <result property="schemetime" column="schemetime" /> + <result property="schemestatus" column="schemestatus" /> + <result property="orgid" column="orgid" /> + <result property="delFlag" column="del_flag" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="isupload" column="isupload" /> + <result property="uploadTime" column="upload_time" /> + <result property="pid" column="pid" /> + <result property="guid" column="guid" /> + </resultMap> + + <sql id="selectPatMedOperationVo"> + select id, serialnum, patid, operationname, operationcode, operationid, operationtime, visitid, visittype, status, schemetime, schemestatus, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, pid, guid from pat_med_operation + </sql> + + <select id="selectPatMedOperationList" parameterType="com.smartor.domain.PatMedOperation" resultMap="PatMedOperationResult"> + <include refid="selectPatMedOperationVo"/> + <where> + <if test="serialnum != null and serialnum != ''"> and serialnum = #{serialnum}</if> + <if test="patid != null "> and patid = #{patid}</if> + <if test="operationname != null and operationname != ''"> and operationname like concat('%', #{operationname}, '%')</if> + <if test="operationcode != null and operationcode != ''"> and operationcode = #{operationcode}</if> + <if test="operationid != null "> and operationid = #{operationid}</if> + <if test="operationtime != null "> and operationtime = #{operationtime}</if> + <if test="visitid != null "> and visitid = #{visitid}</if> + <if test="visittype != null "> and visittype = #{visittype}</if> + <if test="status != null "> and status = #{status}</if> + <if test="schemetime != null "> and schemetime = #{schemetime}</if> + <if test="schemestatus != null "> and schemestatus = #{schemestatus}</if> + <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if> + <if test="isupload != null "> and isupload = #{isupload}</if> + <if test="uploadTime != null "> and upload_time = #{uploadTime}</if> + <if test="pid != null "> and pid = #{pid}</if> + <if test="guid != null and guid != ''"> and guid = #{guid}</if> + </where> + </select> + + <select id="selectPatMedOperationById" parameterType="Long" resultMap="PatMedOperationResult"> + <include refid="selectPatMedOperationVo"/> + where id = #{id} + </select> + + <insert id="insertPatMedOperation" parameterType="com.smartor.domain.PatMedOperation"> + insert into pat_med_operation + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null">id,</if> + <if test="serialnum != null">serialnum,</if> + <if test="patid != null">patid,</if> + <if test="operationname != null">operationname,</if> + <if test="operationcode != null">operationcode,</if> + <if test="operationid != null">operationid,</if> + <if test="operationtime != null">operationtime,</if> + <if test="visitid != null">visitid,</if> + <if test="visittype != null">visittype,</if> + <if test="status != null">status,</if> + <if test="schemetime != null">schemetime,</if> + <if test="schemestatus != null">schemestatus,</if> + <if test="orgid != null">orgid,</if> + <if test="delFlag != null">del_flag,</if> + <if test="updateBy != null">update_by,</if> + <if test="updateTime != null">update_time,</if> + <if test="createBy != null">create_by,</if> + <if test="createTime != null">create_time,</if> + <if test="isupload != null">isupload,</if> + <if test="uploadTime != null">upload_time,</if> + <if test="pid != null">pid,</if> + <if test="guid != null">guid,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null">#{id},</if> + <if test="serialnum != null">#{serialnum},</if> + <if test="patid != null">#{patid},</if> + <if test="operationname != null">#{operationname},</if> + <if test="operationcode != null">#{operationcode},</if> + <if test="operationid != null">#{operationid},</if> + <if test="operationtime != null">#{operationtime},</if> + <if test="visitid != null">#{visitid},</if> + <if test="visittype != null">#{visittype},</if> + <if test="status != null">#{status},</if> + <if test="schemetime != null">#{schemetime},</if> + <if test="schemestatus != null">#{schemestatus},</if> + <if test="orgid != null">#{orgid},</if> + <if test="delFlag != null">#{delFlag},</if> + <if test="updateBy != null">#{updateBy},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createBy != null">#{createBy},</if> + <if test="createTime != null">#{createTime},</if> + <if test="isupload != null">#{isupload},</if> + <if test="uploadTime != null">#{uploadTime},</if> + <if test="pid != null">#{pid},</if> + <if test="guid != null">#{guid},</if> + </trim> + </insert> + + <update id="updatePatMedOperation" parameterType="com.smartor.domain.PatMedOperation"> + update pat_med_operation + <trim prefix="SET" suffixOverrides=","> + <if test="serialnum != null">serialnum = #{serialnum},</if> + <if test="patid != null">patid = #{patid},</if> + <if test="operationname != null">operationname = #{operationname},</if> + <if test="operationcode != null">operationcode = #{operationcode},</if> + <if test="operationid != null">operationid = #{operationid},</if> + <if test="operationtime != null">operationtime = #{operationtime},</if> + <if test="visitid != null">visitid = #{visitid},</if> + <if test="visittype != null">visittype = #{visittype},</if> + <if test="status != null">status = #{status},</if> + <if test="schemetime != null">schemetime = #{schemetime},</if> + <if test="schemestatus != null">schemestatus = #{schemestatus},</if> + <if test="orgid != null">orgid = #{orgid},</if> + <if test="delFlag != null">del_flag = #{delFlag},</if> + <if test="updateBy != null">update_by = #{updateBy},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createBy != null">create_by = #{createBy},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="isupload != null">isupload = #{isupload},</if> + <if test="uploadTime != null">upload_time = #{uploadTime},</if> + <if test="pid != null">pid = #{pid},</if> + <if test="guid != null">guid = #{guid},</if> + </trim> + where id = #{id} + </update> + + <delete id="deletePatMedOperationById" parameterType="Long"> + delete from pat_med_operation where id = #{id} + </delete> + + <delete id="deletePatMedOperationByIds" parameterType="String"> + delete from pat_med_operation where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </delete> +</mapper> -- Gitblit v1.9.3