liusheng
2023-06-16 e53334611e8d51fb67e769cba898743f11dcf627
患者管理相关接口,提交
已添加18个文件
已修改19个文件
2647 ■■■■■ 文件已修改
ruoyi-admin/src/main/java/com/ruoyi/web/controller/PatArchinvecontactController.java 100 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseTagController.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedBloodsugarController.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedDrugController.java 107 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedHypertensionController.java 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedInhospController.java 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedInspectionController.java 100 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOuthospController.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedPhysicalController.java 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedWeightController.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyCategoryController.java 47 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/BaseTag.java 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/BaseTagcategory.java 18 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatArchinvecontact.java 102 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatArchive.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatArchiveAndTag.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatMedDrug.java 298 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatMedInhosp.java 37 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatMedInspection.java 395 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/PatMedPhysical.java 25 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/domain/SvyCategory.java 112 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/mapper/PatArchinvecontactMapper.java 63 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/mapper/PatMedDrugMapper.java 63 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/mapper/PatMedInspectionMapper.java 63 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/mapper/SvyCategoryMapper.java 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/IPatArchinvecontactService.java 62 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/IPatMedDrugService.java 62 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/IPatMedInspectionService.java 62 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/ISvyCategoryService.java 6 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/impl/PatArchinvecontactServiceImpl.java 97 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/impl/PatMedDrugServiceImpl.java 90 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/impl/PatMedInspectionServiceImpl.java 97 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/java/com/smartor/service/impl/SvyCategoryServiceImpl.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/resources/mapper/smartor/PatArchinvecontactMapper.xml 116 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/resources/mapper/smartor/PatMedDrugMapper.xml 182 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/resources/mapper/smartor/PatMedInspectionMapper.xml 218 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
smartor/src/main/resources/mapper/smartor/SvyCategoryMapper.xml 52 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ruoyi-admin/src/main/java/com/ruoyi/web/controller/PatArchinvecontactController.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,100 @@
package com.ruoyi.web.controller;
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.PatArchinvecontact;
import com.smartor.service.IPatArchinvecontactService;
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 2023-06-16
 */
@Api(description = "患者联系方式")
@RestController
@RequestMapping("/system/archinvecontact")
public class PatArchinvecontactController extends BaseController {
    @Autowired
    private IPatArchinvecontactService patArchinvecontactService;
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式列表
     */
    @ApiOperation("查询患者联系方式列表")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatArchinvecontact patArchinvecontact) {
        startPage();
        List<PatArchinvecontact> list = patArchinvecontactService.selectPatArchinvecontactList(patArchinvecontact);
        return getDataTable(list);
    }
    /**
     * å¯¼å‡ºæ‚£è€…联系方式列表
     */
    @ApiOperation("导出患者联系方式列表")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:export')")
    @Log(title = "患者联系方式", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatArchinvecontact patArchinvecontact) {
        List<PatArchinvecontact> list = patArchinvecontactService.selectPatArchinvecontactList(patArchinvecontact);
        ExcelUtil<PatArchinvecontact> util = new ExcelUtil<PatArchinvecontact>(PatArchinvecontact.class);
        util.exportExcel(response, list, "患者联系方式数据");
    }
    /**
     * èŽ·å–æ‚£è€…è”ç³»æ–¹å¼è¯¦ç»†ä¿¡æ¯
     */
    @ApiOperation("获取患者联系方式详细信息")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(patArchinvecontactService.selectPatArchinvecontactById(id));
    }
    /**
     * æ–°å¢žæ‚£è€…联系方式
     */
    @ApiOperation("新增患者联系方式")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:add')")
    @Log(title = "患者联系方式", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody PatArchinvecontact patArchinvecontact) {
        return toAjax(patArchinvecontactService.insertPatArchinvecontact(patArchinvecontact));
    }
    /**
     * ä¿®æ”¹æ‚£è€…联系方式
     */
    @ApiOperation("修改患者联系方式")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:edit')")
    @Log(title = "患者联系方式", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody PatArchinvecontact patArchinvecontact) {
        return toAjax(patArchinvecontactService.updatePatArchinvecontact(patArchinvecontact));
    }
    /**
     * åˆ é™¤æ‚£è€…联系方式
     */
    @ApiOperation("删除患者联系方式")
    @PreAuthorize("@ss.hasPermi('system:archinvecontact:remove')")
    @Log(title = "患者联系方式", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(patArchinvecontactService.deletePatArchinvecontactByIds(ids));
    }
}
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseTagController.java
@@ -44,7 +44,7 @@
     */
    @ApiOperation("查询标签列表")
    @PreAuthorize("@ss.hasPermi('system:tag:list')")
    @GetMapping("/list")
    @PostMapping("/list")
    public TableDataInfo list(@RequestBody BaseTag baseTag) {
        startPage();
        List<BaseTag> list = baseTagService.selectBaseTagList(baseTag);
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedBloodsugarController.java
@@ -25,7 +25,7 @@
 * @author ruoyi
 * @date 2023-06-07
 */
@Api("患者血糖记录")
@Api(description = "患者血糖记录")
@RestController
@RequestMapping("/system/bloodsugar")
public class PatMedBloodsugarController extends BaseController {
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedDrugController.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,107 @@
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.PatMedDrug;
import com.smartor.service.IPatMedDrugService;
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 2023-06-16
 */
@Api(description = "患者用药记录")
@RestController
@RequestMapping("/system/drug")
public class PatMedDrugController extends BaseController
{
    @Autowired
    private IPatMedDrugService patMedDrugService;
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录列表
     */
    @ApiOperation("查询患者用药记录列表")
    @PreAuthorize("@ss.hasPermi('system:drug:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedDrug patMedDrug)
    {
        startPage();
        List<PatMedDrug> list = patMedDrugService.selectPatMedDrugList(patMedDrug);
        return getDataTable(list);
    }
    /**
     * å¯¼å‡ºæ‚£è€…用药记录列表
     */
    @ApiOperation("导出患者用药记录列表")
    @PreAuthorize("@ss.hasPermi('system:drug:export')")
    @Log(title = "患者用药记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatMedDrug patMedDrug)
    {
        List<PatMedDrug> list = patMedDrugService.selectPatMedDrugList(patMedDrug);
        ExcelUtil<PatMedDrug> util = new ExcelUtil<PatMedDrug>(PatMedDrug.class);
        util.exportExcel(response, list, "患者用药记录数据");
    }
    /**
     * èŽ·å–æ‚£è€…ç”¨è¯è®°å½•è¯¦ç»†ä¿¡æ¯
     */
    @ApiOperation("获取患者用药记录详细信息")
    @PreAuthorize("@ss.hasPermi('system:drug:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(patMedDrugService.selectPatMedDrugById(id));
    }
    /**
     * æ–°å¢žæ‚£è€…用药记录
     */
    @ApiOperation("新增患者用药记录")
    @PreAuthorize("@ss.hasPermi('system:drug:add')")
    @Log(title = "患者用药记录", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody PatMedDrug patMedDrug)
    {
        return toAjax(patMedDrugService.insertPatMedDrug(patMedDrug));
    }
    /**
     * ä¿®æ”¹æ‚£è€…用药记录
     */
    @ApiOperation("修改患者用药记录")
    @PreAuthorize("@ss.hasPermi('system:drug:edit')")
    @Log(title = "患者用药记录", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody PatMedDrug patMedDrug)
    {
        return toAjax(patMedDrugService.updatePatMedDrug(patMedDrug));
    }
    /**
     * åˆ é™¤æ‚£è€…用药记录
     */
    @ApiOperation("删除患者用药记录")
    @PreAuthorize("@ss.hasPermi('system:drug:remove')")
    @Log(title = "患者用药记录", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(patMedDrugService.deletePatMedDrugByIds(ids));
    }
}
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedHypertensionController.java
@@ -27,9 +27,8 @@
 */
@RestController
@RequestMapping("/smartor/hypertension")
@Api("患者高血压记录")
public class PatMedHypertensionController extends BaseController
{
@Api(description = "患者高血压记录")
public class PatMedHypertensionController extends BaseController {
    @Autowired
    private IPatMedHypertensionService patMedHypertensionService;
@@ -39,8 +38,7 @@
    @PreAuthorize("@ss.hasPermi('system:hypertension:list')")
    @GetMapping("/list")
    @ApiOperation("查询患者高血压记录列表")
    public TableDataInfo list(PatMedHypertension patMedHypertension)
    {
    public TableDataInfo list(PatMedHypertension patMedHypertension) {
        startPage();
        List<PatMedHypertension> list = patMedHypertensionService.selectPatMedHypertensionList(patMedHypertension);
        return getDataTable(list);
@@ -53,8 +51,7 @@
    @PreAuthorize("@ss.hasPermi('system:hypertension:export')")
    @Log(title = "患者高血压记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatMedHypertension patMedHypertension)
    {
    public void export(HttpServletResponse response, PatMedHypertension patMedHypertension) {
        List<PatMedHypertension> list = patMedHypertensionService.selectPatMedHypertensionList(patMedHypertension);
        ExcelUtil<PatMedHypertension> util = new ExcelUtil<PatMedHypertension>(PatMedHypertension.class);
        util.exportExcel(response, list, "患者高血压记录数据");
@@ -67,8 +64,7 @@
    @ApiImplicitParam(name = "getInfo", value = "主键ID", dataType = "long", dataTypeClass = Long.class)
    @PreAuthorize("@ss.hasPermi('system:hypertension:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(patMedHypertensionService.selectPatMedHypertensionById(id));
    }
@@ -79,8 +75,7 @@
    @PreAuthorize("@ss.hasPermi('system:hypertension:add')")
    @Log(title = "患者高血压记录", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody PatMedHypertension patMedHypertension)
    {
    public AjaxResult add(@RequestBody PatMedHypertension patMedHypertension) {
        return toAjax(patMedHypertensionService.insertPatMedHypertension(patMedHypertension));
    }
@@ -91,8 +86,7 @@
    @PreAuthorize("@ss.hasPermi('system:hypertension:edit')")
    @Log(title = "患者高血压记录", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody PatMedHypertension patMedHypertension)
    {
    public AjaxResult edit(@RequestBody PatMedHypertension patMedHypertension) {
        return toAjax(patMedHypertensionService.updatePatMedHypertension(patMedHypertension));
    }
@@ -104,8 +98,7 @@
    @Log(title = "患者高血压记录", businessType = BusinessType.DELETE)
    @ApiImplicitParam(name = "remove", value = "主键ID", dataType = "long", dataTypeClass = Array.class)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(patMedHypertensionService.deletePatMedHypertensionByIds(ids));
    }
}
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedInhospController.java
@@ -2,6 +2,9 @@
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -27,6 +30,7 @@
 * @author smartor
 * @date 2023-03-04
 */
@Api(description = "患者住院记录")
@RestController
@RequestMapping("/smartor/patinhosp")
public class PatMedInhospController extends BaseController
@@ -37,6 +41,7 @@
    /**
     * æŸ¥è¯¢æ‚£è€…住院记录列表
     */
    @ApiOperation("查询患者住院记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedInhosp patMedInhosp)
@@ -49,6 +54,7 @@
    /**
     * å¯¼å‡ºæ‚£è€…住院记录列表
     */
    @ApiOperation("导出患者住院记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:export')")
    @Log(title = "患者住院记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
@@ -62,6 +68,7 @@
    /**
     * èŽ·å–æ‚£è€…ä½é™¢è®°å½•è¯¦ç»†ä¿¡æ¯
     */
    @ApiOperation("获取患者住院记录详细信息")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:query')")
    @GetMapping(value = "/{inhospid}")
    public AjaxResult getInfo(@PathVariable("inhospid") Long inhospid)
@@ -72,6 +79,7 @@
    /**
     * æ–°å¢žæ‚£è€…住院记录
     */
    @ApiOperation("新增患者住院记录")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:add')")
    @Log(title = "患者住院记录", businessType = BusinessType.INSERT)
    @PostMapping
@@ -83,6 +91,7 @@
    /**
     * ä¿®æ”¹æ‚£è€…住院记录
     */
    @ApiOperation("修改患者住院记录")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:edit')")
    @Log(title = "患者住院记录", businessType = BusinessType.UPDATE)
    @PutMapping
@@ -94,6 +103,7 @@
    /**
     * åˆ é™¤æ‚£è€…住院记录
     */
    @ApiOperation("删除患者住院记录")
    @PreAuthorize("@ss.hasPermi('smartor:patinhosp:remove')")
    @Log(title = "患者住院记录", businessType = BusinessType.DELETE)
    @DeleteMapping("/{inhospids}")
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedInspectionController.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,100 @@
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.PatMedInspection;
import com.smartor.service.IPatMedInspectionService;
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 2023-06-16
 */
@Api(description = "患者检查检验记录")
@RestController
@RequestMapping("/system/inspection")
public class PatMedInspectionController extends BaseController {
    @Autowired
    private IPatMedInspectionService patMedInspectionService;
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录列表
     */
    @ApiOperation("查询患者检查检验记录列表")
    @PreAuthorize("@ss.hasPermi('system:inspection:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedInspection patMedInspection) {
        startPage();
        List<PatMedInspection> list = patMedInspectionService.selectPatMedInspectionList(patMedInspection);
        return getDataTable(list);
    }
    /**
     * å¯¼å‡ºæ‚£è€…检查检验记录列表
     */
    @ApiOperation("导出患者检查检验记录列表")
    @PreAuthorize("@ss.hasPermi('system:inspection:export')")
    @Log(title = "患者检查检验记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatMedInspection patMedInspection) {
        List<PatMedInspection> list = patMedInspectionService.selectPatMedInspectionList(patMedInspection);
        ExcelUtil<PatMedInspection> util = new ExcelUtil<PatMedInspection>(PatMedInspection.class);
        util.exportExcel(response, list, "患者检查检验记录数据");
    }
    /**
     * èŽ·å–æ‚£è€…æ£€æŸ¥æ£€éªŒè®°å½•è¯¦ç»†ä¿¡æ¯
     */
    @ApiOperation("获取患者检查检验记录详细信息")
    @PreAuthorize("@ss.hasPermi('system:inspection:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(patMedInspectionService.selectPatMedInspectionById(id));
    }
    /**
     * æ–°å¢žæ‚£è€…检查检验记录
     */
    @PreAuthorize("@ss.hasPermi('system:inspection:add')")
    @Log(title = "新增患者检查检验记录", businessType = BusinessType.INSERT)
    @ApiOperation("新增患者检查检验记录")
    @PostMapping
    public AjaxResult add(@RequestBody PatMedInspection patMedInspection) {
        return toAjax(patMedInspectionService.insertPatMedInspection(patMedInspection));
    }
    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录
     */
    @PreAuthorize("@ss.hasPermi('system:inspection:edit')")
    @Log(title = "修改患者检查检验记录", businessType = BusinessType.UPDATE)
    @ApiOperation("修改患者检查检验记录")
    @PutMapping
    public AjaxResult edit(@RequestBody PatMedInspection patMedInspection) {
        return toAjax(patMedInspectionService.updatePatMedInspection(patMedInspection));
    }
    /**
     * åˆ é™¤æ‚£è€…检查检验记录
     */
    @PreAuthorize("@ss.hasPermi('system:inspection:remove')")
    @Log(title = "患者检查检验记录", businessType = BusinessType.DELETE)
    @ApiOperation("患者检查检验记录")
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(patMedInspectionService.deletePatMedInspectionByIds(ids));
    }
}
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOuthospController.java
@@ -34,7 +34,7 @@
 */
@RestController
@RequestMapping("/smartor/patouthosp")
@Api("患者门诊记录")
@Api(description = "患者门诊记录")
public class PatMedOuthospController extends BaseController {
    @Autowired
    private IPatMedOuthospService patMedOuthospService;
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedPhysicalController.java
@@ -2,6 +2,9 @@
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -27,6 +30,7 @@
 * @author smartor
 * @date 2023-03-04
 */
@Api(description = "患者体检记录")
@RestController
@RequestMapping("/smartor/patphysical")
public class PatMedPhysicalController extends BaseController
@@ -37,6 +41,7 @@
    /**
     * æŸ¥è¯¢æ‚£è€…体检记录列表
     */
    @ApiOperation("查询患者体检记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedPhysical patMedPhysical)
@@ -49,6 +54,7 @@
    /**
     * å¯¼å‡ºæ‚£è€…体检记录列表
     */
    @ApiOperation("导出患者体检记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:export')")
    @Log(title = "患者体检记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
@@ -62,6 +68,7 @@
    /**
     * èŽ·å–æ‚£è€…ä½“æ£€è®°å½•è¯¦ç»†ä¿¡æ¯
     */
    @ApiOperation("获取患者体检记录详细信息")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
@@ -72,6 +79,7 @@
    /**
     * æ–°å¢žæ‚£è€…体检记录
     */
    @ApiOperation("新增患者体检记录")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:add')")
    @Log(title = "患者体检记录", businessType = BusinessType.INSERT)
    @PostMapping
@@ -83,6 +91,7 @@
    /**
     * ä¿®æ”¹æ‚£è€…体检记录
     */
    @ApiOperation("修改患者体检记录")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:edit')")
    @Log(title = "患者体检记录", businessType = BusinessType.UPDATE)
    @PutMapping
@@ -94,6 +103,7 @@
    /**
     * åˆ é™¤æ‚£è€…体检记录
     */
    @ApiOperation("删除患者体检记录")
    @PreAuthorize("@ss.hasPermi('smartor:patphysical:remove')")
    @Log(title = "患者体检记录", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedWeightController.java
@@ -25,7 +25,7 @@
 * @author ruoyi
 * @date 2023-06-07
 */
@Api("患者体重记录")
@Api(description = "患者体重记录")
@RestController
@RequestMapping("/system/weight")
public class PatMedWeightController extends BaseController
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyCategoryController.java
@@ -1,17 +1,15 @@
package com.smartor.controller;
package com.ruoyi.web.controller.smartor;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiModelProperty;
import io.swagger.annotations.ApiOperation;
import io.swagger.v3.oas.annotations.tags.Tag;
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 org.springframework.web.bind.annotation.*;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
@@ -27,10 +25,10 @@
 * @author ruoyi
 * @date 2023-03-02
 */
@Api(description = "问卷分类")
@RestController
@RequestMapping("/smartor/svycategory")
public class SvyCategoryController extends BaseController
{
public class SvyCategoryController extends BaseController {
    @Autowired
    private ISvyCategoryService svyCategoryService;
@@ -39,8 +37,7 @@
     */
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyCategory svyCategory)
    {
    public TableDataInfo list(SvyCategory svyCategory) {
        startPage();
        List<SvyCategory> list = svyCategoryService.selectSvyCategoryList(svyCategory);
        return getDataTable(list);
@@ -52,21 +49,20 @@
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:export')")
    @Log(title = "问卷分类", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyCategory svyCategory)
    {
    public void export(HttpServletResponse response, SvyCategory svyCategory) {
        List<SvyCategory> list = svyCategoryService.selectSvyCategoryList(svyCategory);
        ExcelUtil<SvyCategory> util = new ExcelUtil<SvyCategory>(SvyCategory.class);
        util.exportExcel(response, list, "问卷分类数据");
    }
    /**
     * èŽ·å–é—®å·åˆ†ç±»è¯¦ç»†ä¿¡æ¯
     * èŽ·å–é—®å·åˆ†ç±»ä¿¡æ¯é€šè¿‡åˆ†ç±»åç§°
     */
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(svyCategoryService.selectSvyCategoryById(id));
    // @PreAuthorize("@ss.hasPermi('smartor:svycategory:query')")
    @ApiOperation("获取问卷分类详细信息(问卷类别)")
    @PostMapping(value = "/getInfo")
    public TableDataInfo getInfo(@RequestParam(required = false) String categoryname) {
        return getDataTable(svyCategoryService.selectSvyCategoryById(categoryname));
    }
    /**
@@ -75,8 +71,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:add')")
    @Log(title = "问卷分类", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyCategory svyCategory)
    {
    public AjaxResult add(@RequestBody SvyCategory svyCategory) {
        return toAjax(svyCategoryService.insertSvyCategory(svyCategory));
    }
@@ -86,8 +81,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:edit')")
    @Log(title = "问卷分类", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyCategory svyCategory)
    {
    public AjaxResult edit(@RequestBody SvyCategory svyCategory) {
        return toAjax(svyCategoryService.updateSvyCategory(svyCategory));
    }
@@ -97,8 +91,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:svycategory:remove')")
    @Log(title = "问卷分类", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(svyCategoryService.deleteSvyCategoryByIds(ids));
    }
}
smartor/src/main/java/com/smartor/domain/BaseTag.java
@@ -80,4 +80,10 @@
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;
    /**
     * æ˜¯å¦å¼€å¯
     */
    @ApiModelProperty("是否开启  1开启   0关闭")
    private Integer isenable;
}
smartor/src/main/java/com/smartor/domain/BaseTagcategory.java
@@ -25,47 +25,47 @@
    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(name = "自增ID")
    @ApiModelProperty(value = "自增ID")
    private Long tagcategoryid;
    /**
     * æœºæž„ID
     */
    @ApiModelProperty(name = "机构ID")
    @ApiModelProperty(value = "机构ID")
    @Excel(name = " æœºæž„ID ")
    private String orgid;
    /**
     * æ‹¼éŸ³ç 
     */
    @ApiModelProperty(name = "拼音码")
    @ApiModelProperty(value = "拼音码")
    @Excel(name = " æ‹¼éŸ³ç  ")
    private String pym;
    /**
     * äº”笔码
     */
    @ApiModelProperty(name = "五笔码")
    @ApiModelProperty(value = "五笔码")
    @Excel(name = " äº”笔码 ")
    private String wbm;
    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty(name = "删除标记")
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**
     * ä¸Šä¼ æ ‡è®°
     */
    @ApiModelProperty(name = "上传标记")
    @ApiModelProperty(value = "上传标记")
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    private Long isupload;
    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @ApiModelProperty(name = "上传时间")
    @ApiModelProperty(value = "上传时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;
@@ -73,11 +73,11 @@
    /**
     * æ ‡ç­¾åç§°
     */
    @ApiModelProperty(name = "标签类别名称")
    @ApiModelProperty(value = "标签类别名称")
    @Excel(name = " æ ‡ç­¾ç±»åˆ«åç§° ")
    private String categoryname;
    @ApiModelProperty(name = "标签数量")
    @ApiModelProperty(value = "标签数量")
    private String tagNum;
}
smartor/src/main/java/com/smartor/domain/PatArchinvecontact.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,102 @@
package com.smartor.domain;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
/**
 * æ‚£è€…联系方式对象 pat_archinvecontact
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@ApiModel(value = "PatArchinvecontact", description = "患者联系方式对象")
@Data
public class PatArchinvecontact extends BaseEntity {
    private static final long serialVersionUID = 1L;
    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "自增ID")
    private Long id;
    /**
     * è”系方式ID
     */
    @Excel(name = " è”系方式ID ")
    @ApiModelProperty(value = "联系方式ID")
    private Long patid;
    /**
     * è”系方式
     */
    @Excel(name = " è”系方式 ")
    @ApiModelProperty(value = "联系方式")
    private String contactway;
    /**
     * å…³ç³»
     */
    @Excel(name = " å…³ç³» ")
    @ApiModelProperty(value = "关系")
    private Long relation;
    /**
     * æ•°æ®æ¥æº
     */
    @Excel(name = " æ•°æ®æ¥æº ")
    @ApiModelProperty(value = "数据来源")
    private Long datasource;
    /**
     * æ˜¯å¦é»˜è®¤
     */
    @Excel(name = " æ˜¯å¦é»˜è®¤ ")
    @ApiModelProperty(value = "是否默认")
    private Long isdefault;
    /**
     * æœºæž„ID
     */
    @Excel(name = " æœºæž„ID ")
    @ApiModelProperty(value = "机构ID")
    private String orgid;
    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**
     * ä¸Šä¼ æ ‡è®°
     */
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    @ApiModelProperty(value = "上传标记")
    private Long isupload;
    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @ApiModelProperty(value = "上传时间")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;
    /**
     * è”系姓名
     */
    @Excel(name = " è”系姓名 ")
    @ApiModelProperty(value = "联系姓名")
    private String contactname;
}
smartor/src/main/java/com/smartor/domain/PatArchive.java
@@ -27,7 +27,7 @@
    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(name = "自增ID")
    @ApiModelProperty("自增ID")
    private Long patid;
    /**
smartor/src/main/java/com/smartor/domain/PatArchiveAndTag.java
@@ -26,7 +26,7 @@
    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(name = "自增ID")
    @ApiModelProperty(value = "自增ID")
    private Long patid;
    /**
smartor/src/main/java/com/smartor/domain/PatMedDrug.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,298 @@
package com.smartor.domain;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import java.util.Date;
/**
 * æ‚£è€…用药记录对象 pat_med_drug
 *
 * @author ruoyi
 * @date 2023-06-16
 */
public class PatMedDrug extends BaseEntity
{
    private static final long serialVersionUID = 1L;
    /**  è‡ªå¢žID  */
    private Long id;
    /**  æµæ°´å·  */
    @Excel(name = " æµæ°´å· ")
    private String serialnum;
    /**  æ¡£æ¡ˆID  */
    @Excel(name = " æ¡£æ¡ˆID ")
    private Long patid;
    /**  è¯å“åç§°  */
    @Excel(name = " è¯å“åç§° ")
    private String drugname;
    /**  å¼€æ–¹æ—¥æœŸ  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " å¼€æ–¹æ—¥æœŸ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date opendate;
    /**  è¯å“ç±»åž‹  */
    @Excel(name = " è¯å“ç±»åž‹ ")
    private String drugtype;
    /**  å•位  */
    @Excel(name = " å•位 ")
    private String unit;
    /**  è§„æ ¼  */
    @Excel(name = " è§„æ ¼ ")
    private String spec;
    /**  ç”¨æ³•  */
    @Excel(name = " ç”¨æ³• ")
    private String drugusage;
    /**  å‰‚量  */
    @Excel(name = " å‰‚量 ")
    private String dose;
    /**  æœºæž„ID  */
    @Excel(name = " æœºæž„ID ")
    private String orgid;
    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;
    /**  ä¸Šä¼ æ ‡è®°  */
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    private Long isupload;
    /**  ä¸Šä¼ æ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;
    /**  è¯å“ID  */
    @Excel(name = " è¯å“ID ")
    private Long drugid;
    /**  å°±è¯Šç±»åž‹  */
    @Excel(name = " å°±è¯Šç±»åž‹ ")
    private Long visittype;
    /**  å°±è¯ŠID  */
    @Excel(name = " å°±è¯ŠID ")
    private Long visitid;
    /**  æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成就诊 9无匹配方案  */
    @Excel(name = " æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成就诊 9无匹配方案 ")
    private Long schemestatus;
    /**  æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date schemetime;
    public void setId(Long id)
    {
        this.id = id;
    }
    public Long getId()
    {
        return id;
    }
    public void setSerialnum(String serialnum)
    {
        this.serialnum = serialnum;
    }
    public String getSerialnum()
    {
        return serialnum;
    }
    public void setPatid(Long patid)
    {
        this.patid = patid;
    }
    public Long getPatid()
    {
        return patid;
    }
    public void setDrugname(String drugname)
    {
        this.drugname = drugname;
    }
    public String getDrugname()
    {
        return drugname;
    }
    public void setOpendate(Date opendate)
    {
        this.opendate = opendate;
    }
    public Date getOpendate()
    {
        return opendate;
    }
    public void setDrugtype(String drugtype)
    {
        this.drugtype = drugtype;
    }
    public String getDrugtype()
    {
        return drugtype;
    }
    public void setUnit(String unit)
    {
        this.unit = unit;
    }
    public String getUnit()
    {
        return unit;
    }
    public void setSpec(String spec)
    {
        this.spec = spec;
    }
    public String getSpec()
    {
        return spec;
    }
    public void setDrugusage(String drugusage)
    {
        this.drugusage = drugusage;
    }
    public String getDrugusage()
    {
        return drugusage;
    }
    public void setDose(String dose)
    {
        this.dose = dose;
    }
    public String getDose()
    {
        return dose;
    }
    public void setOrgid(String orgid)
    {
        this.orgid = orgid;
    }
    public String getOrgid()
    {
        return orgid;
    }
    public void setDelFlag(String delFlag)
    {
        this.delFlag = delFlag;
    }
    public String getDelFlag()
    {
        return delFlag;
    }
    public void setIsupload(Long isupload)
    {
        this.isupload = isupload;
    }
    public Long getIsupload()
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime)
    {
        this.uploadTime = uploadTime;
    }
    public Date getUploadTime()
    {
        return uploadTime;
    }
    public void setDrugid(Long drugid)
    {
        this.drugid = drugid;
    }
    public Long getDrugid()
    {
        return drugid;
    }
    public void setVisittype(Long visittype)
    {
        this.visittype = visittype;
    }
    public Long getVisittype()
    {
        return visittype;
    }
    public void setVisitid(Long visitid)
    {
        this.visitid = visitid;
    }
    public Long getVisitid()
    {
        return visitid;
    }
    public void setSchemestatus(Long schemestatus)
    {
        this.schemestatus = schemestatus;
    }
    public Long getSchemestatus()
    {
        return schemestatus;
    }
    public void setSchemetime(Date schemetime)
    {
        this.schemetime = schemetime;
    }
    public Date getSchemetime()
    {
        return schemetime;
    }
    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("serialnum", getSerialnum())
            .append("patid", getPatid())
            .append("drugname", getDrugname())
            .append("opendate", getOpendate())
            .append("drugtype", getDrugtype())
            .append("unit", getUnit())
            .append("spec", getSpec())
            .append("drugusage", getDrugusage())
            .append("dose", getDose())
            .append("orgid", getOrgid())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("drugid", getDrugid())
            .append("visittype", getVisittype())
            .append("visitid", getVisitid())
            .append("schemestatus", getSchemestatus())
            .append("schemetime", getSchemetime())
            .toString();
    }
}
smartor/src/main/java/com/smartor/domain/PatMedInhosp.java
@@ -2,6 +2,8 @@
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
@@ -13,122 +15,157 @@
 * @author smartor
 * @date 2023-03-04
 */
@ApiModel(value = "PatMedInhosp", description = "患者住院记录对象")
public class PatMedInhosp extends BaseEntity
{
    private static final long serialVersionUID = 1L;
    /**  è‡ªå¢žID  */
    @ApiModelProperty(value = "自增ID")
    private Long inhospid;
    /**  æµæ°´å·  */
    @ApiModelProperty(value = "流水号")
    private String serialnum;
    /**  åŒ»é™¢åç§°  */
    @ApiModelProperty(value = "医院名称")
    @Excel(name = " åŒ»é™¢åç§° ")
    private String hospitalname;
    /**  åŒ»é™¢ç¼–号  */
    @ApiModelProperty(value = "医院编号")
    private String hospitalcode;
    /**  é™¢åŒºç¼–号  */
    @ApiModelProperty(value = "院区编号")
    private String hospitaldistrictcode;
    /**  é™¢åŒºåç§°  */
    @ApiModelProperty(value = "院区名称")
    @Excel(name = " é™¢åŒºåç§° ")
    private String hospitaldistrictname;
    /**  å…¥é™¢è¯Šæ–­ICD值  */
    @ApiModelProperty(value = "入院诊断ICD值")
    private String icd10code;
    /**  å…¥é™¢è¯Šæ–­åç§°  */
    @ApiModelProperty(value = "入院诊断名称")
    private String diagname;
    /**  å…¥é™¢æ—¶é—´  */
    @ApiModelProperty(value = "入院时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " å…¥é™¢æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date starttime;
    /**  å‡ºé™¢æ—¶é—´  */
    @ApiModelProperty(value = "出院时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " å‡ºé™¢æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date endtime;
    /**  å…¥é™¢ç§‘室代码  */
    @ApiModelProperty(value = "入院科室代码")
    private String deptcode;
    /**  å…¥é™¢ç§‘室名称  */
    @ApiModelProperty(value = "入院科室名称")
    private String deptname;
    /**  æˆ¿é—´å·  */
    @ApiModelProperty(value = "房间号")
    private String roomno;
    /**  åºŠä½å·  */
    @ApiModelProperty(value = "床位号")
    @Excel(name = " åºŠä½å· ")
    private String bedno;
    /**  æœºæž„ID  */
    @ApiModelProperty(value = "机构ID")
    @Excel(name = " æœºæž„ID ")
    private String orgid;
    /**  åˆ é™¤æ ‡è®°  */
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**  ä¸Šä¼ æ ‡è®°  */
    @ApiModelProperty(value = "上传标记")
    private Long isupload;
    /**  ä¸Šä¼ æ—¶é—´  */
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;
    /**  æ¡£æ¡ˆID  */
    @ApiModelProperty(value = "档案ID")
    private Long patid;
    /**  å‡ºé™¢è¯Šæ–­  */
    @ApiModelProperty(value = "出院诊断")
    @Excel(name = " å‡ºé™¢è¯Šæ–­ ")
    private String leavediagname;
    /**  å‡ºé™¢è¯Šæ–­ICD值  */
    @ApiModelProperty(value = "出院诊断ICD值")
    private String leaveicd10code;
    /**  åŒ»ç”Ÿå·¥å·  */
    @ApiModelProperty(value = "医生工号")
    private String drcode;
    /**  åŒ»ç”Ÿåç§°  */
    @ApiModelProperty(value = "医生名称")
    @Excel(name = " åŒ»ç”Ÿåç§° ")
    private String drname;
    /**  æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成入院 2生成出院 9无匹配方案  */
    @ApiModelProperty(value = "是否生成方案状态;0未生成 1生成入院 2生成出院 9无匹配方案")
    private Long schemestatus;
    /**  æ˜¯å¦ç”Ÿæˆé€šç”¨æ–¹æ¡ˆçŠ¶æ€;0未生成 1生成 9无匹配方案  */
    @ApiModelProperty(value = "是否生成通用方案状态;0未生成 1生成 9无匹配方案")
    private Long generalschemestatus;
    /**  å‡ºé™¢ç§‘室代码  */
    @ApiModelProperty(value = "出院科室代码")
    private String leaveldeptcode;
    /**  å‡ºé™¢ç§‘室名称  */
    @ApiModelProperty(value = "出院科室名称")
    @Excel(name = " å‡ºé™¢ç§‘室名称 ")
    private String leaveldeptname;
    /**  ç—…区ID  */
    @ApiModelProperty(value = "病区ID")
    private Long hospitaldistrictid;
    /**  å‡ºé™¢ç—…区编号  */
    @ApiModelProperty(value = "出院病区编号")
    private String leavehospitaldistrictcode;
    /**  å‡ºé™¢ç—…区名称  */
    @ApiModelProperty(value = "出院病区名称")
    @Excel(name = " å‡ºé™¢ç—…区名称 ")
    private String leavehospitaldistrictname;
    /**  å‡ºé™¢ç—…区ID  */
    @ApiModelProperty(value = "出院病区ID")
    private Long leavehospitaldistrictid;
    /**  å…¥é™¢ç§‘室ID  */
    @ApiModelProperty(value = "入院科室ID")
    private Long deptid;
    /**  å‡ºé™¢ç§‘室ID  */
    @ApiModelProperty(value = "出院科室ID")
    private Long leaveldeptid;
    /**  æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´  */
    @ApiModelProperty(value = "方案状态操作时间")
    private Date schemetime;
    public void setInhospid(Long inhospid) 
smartor/src/main/java/com/smartor/domain/PatMedInspection.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,395 @@
package com.smartor.domain;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
/**
 * æ‚£è€…检查检验记录对象 pat_med_inspection
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@ApiModel(value = "PatMedInspection", description = "患者检查检验记录对象")
public class PatMedInspection extends BaseEntity
{
    private static final long serialVersionUID = 1L;
    /**  è‡ªå¢žID  */
    @ApiModelProperty(value = "自增ID")
    private Long id;
    /**  æµæ°´å·  */
    @Excel(name = " æµæ°´å· ")
    @ApiModelProperty(value = "流水号")
    private String serialnum;
    /**  æ¡£æ¡ˆID  */
    @Excel(name = " æ¡£æ¡ˆID ")
    @ApiModelProperty(value = "档案ID")
    private Long patid;
    /**  ç±»åž‹;0.检验项目 1.检查项目  */
    @ApiModelProperty(value = "类型;0.检验项目 1.检查项目")
    @Excel(name = " ç±»åž‹;0.检验项目 1.检查项目 ")
    private Long projecttype;
    /**  é¡¹ç›®ç¼–号  */
    @Excel(name = " é¡¹ç›®ç¼–号 ")
    @ApiModelProperty(value = "项目编号")
    private String projectcode;
    /**  é¡¹ç›®åç§°  */
    @Excel(name = " é¡¹ç›®åç§° ")
    @ApiModelProperty(value = "项目名称")
    private String projectname;
    /**  æŠ¥å‘Šæ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " æŠ¥å‘Šæ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "报告时间")
    private Date reporttime;
    /**  åŒ»é™¢åç§°  */
    @Excel(name = " åŒ»é™¢åç§° ")
    @ApiModelProperty(value = "医院名称")
    private String hospitalname;
    /**  åŒ»é™¢ç¼–号  */
    @Excel(name = " åŒ»é™¢ç¼–号 ")
    @ApiModelProperty(value = "医院编号")
    private String hospitalcode;
    /**  æœºæž„ID  */
    @Excel(name = " æœºæž„ID ")
    @ApiModelProperty(value = "机构ID")
    private String orgid;
    /**  åˆ é™¤æ ‡è®°  */
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**  ä¸Šä¼ æ ‡è®°  */
    @ApiModelProperty(value = "上传标记")
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    private Long isupload;
    /**  ä¸Šä¼ æ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;
    /**  é¡¹ç›®ID  */
    @Excel(name = " é¡¹ç›®ID ")
    @ApiModelProperty(value = "项目ID")
    private Long projectid;
    /**  ç”³è¯·æ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ç”³è¯·æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "申请时间")
    private Date applicationtime;
    /**  å°±è¯Šç±»åž‹  */
    @Excel(name = " å°±è¯Šç±»åž‹ ")
    @ApiModelProperty(value = "就诊类型")
    private Long visittype;
    /**  å°±è¯ŠID  */
    @Excel(name = " å°±è¯ŠID ")
    @ApiModelProperty(value = "就诊ID")
    private Long visitid;
    /**  æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成申请后 2.生成报告后  9无匹配方案  */
    @Excel(name = " æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成申请后 2.生成报告后  9无匹配方案 ")
    @ApiModelProperty(value = "是否生成方案状态;0未生成 1生成申请后 2.生成报告后  9无匹配方案")
    private Long schemestatus;
    /**  æ˜¯å¦å¼‚常;0否 1是  */
    @Excel(name = " æ˜¯å¦å¼‚常;0否 1是 ")
    @ApiModelProperty(value = "是否异常;0否 1是")
    private Long isabnormal;
    /**  æŠ¥å‘Šç»“论  */
    @Excel(name = " æŠ¥å‘Šç»“论 ")
    @ApiModelProperty(value = "报告结论")
    private String reportconclusion;
    /**  æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    @ApiModelProperty(value = "方案状态操作时间")
    private Date schemetime;
    /**  å¼€å•科室代码  */
    @Excel(name = " å¼€å•科室代码 ")
    @ApiModelProperty(value = "开单科室代码")
    private String deptcode;
    /**  å¼€å•科室名称  */
    @Excel(name = " å¼€å•科室名称 ")
    @ApiModelProperty(value = "开单科室名称")
    private String deptname;
    /**  å¼€å•科室ID  */
    @Excel(name = " å¼€å•科室ID ")
    @ApiModelProperty(value = "开单科室ID")
    private Long deptid;
    public void setId(Long id)
    {
        this.id = id;
    }
    public Long getId()
    {
        return id;
    }
    public void setSerialnum(String serialnum)
    {
        this.serialnum = serialnum;
    }
    public String getSerialnum()
    {
        return serialnum;
    }
    public void setPatid(Long patid)
    {
        this.patid = patid;
    }
    public Long getPatid()
    {
        return patid;
    }
    public void setProjecttype(Long projecttype)
    {
        this.projecttype = projecttype;
    }
    public Long getProjecttype()
    {
        return projecttype;
    }
    public void setProjectcode(String projectcode)
    {
        this.projectcode = projectcode;
    }
    public String getProjectcode()
    {
        return projectcode;
    }
    public void setProjectname(String projectname)
    {
        this.projectname = projectname;
    }
    public String getProjectname()
    {
        return projectname;
    }
    public void setReporttime(Date reporttime)
    {
        this.reporttime = reporttime;
    }
    public Date getReporttime()
    {
        return reporttime;
    }
    public void setHospitalname(String hospitalname)
    {
        this.hospitalname = hospitalname;
    }
    public String getHospitalname()
    {
        return hospitalname;
    }
    public void setHospitalcode(String hospitalcode)
    {
        this.hospitalcode = hospitalcode;
    }
    public String getHospitalcode()
    {
        return hospitalcode;
    }
    public void setOrgid(String orgid)
    {
        this.orgid = orgid;
    }
    public String getOrgid()
    {
        return orgid;
    }
    public void setDelFlag(String delFlag)
    {
        this.delFlag = delFlag;
    }
    public String getDelFlag()
    {
        return delFlag;
    }
    public void setIsupload(Long isupload)
    {
        this.isupload = isupload;
    }
    public Long getIsupload()
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime)
    {
        this.uploadTime = uploadTime;
    }
    public Date getUploadTime()
    {
        return uploadTime;
    }
    public void setProjectid(Long projectid)
    {
        this.projectid = projectid;
    }
    public Long getProjectid()
    {
        return projectid;
    }
    public void setApplicationtime(Date applicationtime)
    {
        this.applicationtime = applicationtime;
    }
    public Date getApplicationtime()
    {
        return applicationtime;
    }
    public void setVisittype(Long visittype)
    {
        this.visittype = visittype;
    }
    public Long getVisittype()
    {
        return visittype;
    }
    public void setVisitid(Long visitid)
    {
        this.visitid = visitid;
    }
    public Long getVisitid()
    {
        return visitid;
    }
    public void setSchemestatus(Long schemestatus)
    {
        this.schemestatus = schemestatus;
    }
    public Long getSchemestatus()
    {
        return schemestatus;
    }
    public void setIsabnormal(Long isabnormal)
    {
        this.isabnormal = isabnormal;
    }
    public Long getIsabnormal()
    {
        return isabnormal;
    }
    public void setReportconclusion(String reportconclusion)
    {
        this.reportconclusion = reportconclusion;
    }
    public String getReportconclusion()
    {
        return reportconclusion;
    }
    public void setSchemetime(Date schemetime)
    {
        this.schemetime = schemetime;
    }
    public Date getSchemetime()
    {
        return schemetime;
    }
    public void setDeptcode(String deptcode)
    {
        this.deptcode = deptcode;
    }
    public String getDeptcode()
    {
        return deptcode;
    }
    public void setDeptname(String deptname)
    {
        this.deptname = deptname;
    }
    public String getDeptname()
    {
        return deptname;
    }
    public void setDeptid(Long deptid)
    {
        this.deptid = deptid;
    }
    public Long getDeptid()
    {
        return deptid;
    }
    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("serialnum", getSerialnum())
            .append("patid", getPatid())
            .append("projecttype", getProjecttype())
            .append("projectcode", getProjectcode())
            .append("projectname", getProjectname())
            .append("reporttime", getReporttime())
            .append("hospitalname", getHospitalname())
            .append("hospitalcode", getHospitalcode())
            .append("orgid", getOrgid())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .append("projectid", getProjectid())
            .append("applicationtime", getApplicationtime())
            .append("visittype", getVisittype())
            .append("visitid", getVisitid())
            .append("schemestatus", getSchemestatus())
            .append("isabnormal", getIsabnormal())
            .append("reportconclusion", getReportconclusion())
            .append("schemetime", getSchemetime())
            .append("deptcode", getDeptcode())
            .append("deptname", getDeptname())
            .append("deptid", getDeptid())
            .toString();
    }
}
smartor/src/main/java/com/smartor/domain/PatMedPhysical.java
@@ -2,6 +2,8 @@
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
@@ -13,82 +15,105 @@
 * @author smartor
 * @date 2023-03-04
 */
@ApiModel(value = "PatMedPhysical", description = "患者体检记录对象")
public class PatMedPhysical extends BaseEntity
{
    private static final long serialVersionUID = 1L;
    /**  è‡ªå¢žID  */
    @ApiModelProperty(value = "自增ID")
    private Long id;
    /**  æµæ°´å·  */
    @Excel(name = " æµæ°´å· ")
    @ApiModelProperty(value = "流水号")
    private String serialnum;
    /**  æ¡£æ¡ˆID  */
    @ApiModelProperty(value = "档案ID")
    private Long patid;
    /**  æ€»ç»“医生工号  */
    @ApiModelProperty(value = "总结医生工号")
    private String drcode;
    /**  æ€»ç»“医生名称  */
    @Excel(name = " æ€»ç»“医生名称 ")
    @ApiModelProperty(value = "总结医生名称")
    private String drname;
    /**  ä½“检单位/医院编号  */
    @ApiModelProperty(value = "体检单位/医院编号")
    private String hospitalcode;
    /**  ä½“检单位/医院  */
    @Excel(name = " ä½“检单位/医院 ")
    @ApiModelProperty(value = "体检单位/医院")
    private String hospitalname;
    /**  ä½“检时间  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @ApiModelProperty(value = "体检时间")
    @Excel(name = " ä½“检时间 ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date physicaldate;
    /**  æœºæž„ID  */
    @Excel(name = " æœºæž„ID ")
    @ApiModelProperty(value = "机构ID")
    private String orgid;
    /**  åˆ é™¤æ ‡è®°  */
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**  ä¸Šä¼ æ ‡è®°  */
    @ApiModelProperty(value = "上传标记")
    private Long isupload;
    /**  ä¸Šä¼ æ—¶é—´  */
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;
    /**  ç§‘室代码  */
    @ApiModelProperty(value = "科室代码")
    private String deptcode;
    /**  ç§‘室名称  */
    @ApiModelProperty(value = "科室名称")
    @Excel(name = " ç§‘室名称 ")
    private String deptname;
    /**  ä½“检项目名称  */
    @ApiModelProperty(value = "体检项目名称")
    @Excel(name = " ä½“检项目名称 ")
    private String projectname;
    /**  ä½“检项目编码  */
    @ApiModelProperty(value = "体检项目编码")
    private String projectcode;
    /**  çŠ¶æ€;0.已预约 1.已体检 2.报告已出  */
    @ApiModelProperty(value = "状态;0.已预约 1.已体检 2.报告已出")
    private Long state;
    /**  æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成体检前 2生成体检后 3.生成报告已出  9无匹配方案  */
    @ApiModelProperty(value = "是否生成方案状态;0未生成 1生成体检前 2生成体检后 3.生成报告已出  9无匹配方案")
    private Long schemestatus;
    /**  æ˜¯å¦ç”Ÿæˆé€šç”¨æ–¹æ¡ˆçŠ¶æ€;0未生成 1生成 9无匹配方案  */
    @ApiModelProperty(value = "是否生成通用方案状态;0未生成 1生成 9无匹配方案")
    private Long generalschemestatus;
    /**  ç§‘室ID  */
    @ApiModelProperty(value = "科室ID")
    private Long deptid;
    /**  ä½“检套餐ID  */
    @ApiModelProperty(value = "体检套餐ID")
    private Long projectid;
    /**  æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´  */
    @ApiModelProperty(value = "方案状态操作时间")
    private Date schemetime;
    public void setId(Long id) 
smartor/src/main/java/com/smartor/domain/SvyCategory.java
@@ -1,7 +1,11 @@
package com.smartor.domain;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
@@ -13,98 +17,54 @@
 * @author ruoyi
 * @date 2023-03-02
 */
public class SvyCategory extends BaseEntity
{
@ApiModel(value = "SvyCategory", description = "问卷分类对象")
@Data
public class SvyCategory extends BaseEntity {
    private static final long serialVersionUID = 1L;
    /**  è‡ªå¢žID  */
    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "自增ID")
    private Long id;
    /**  åˆ†ç±»åç§°  */
    /**
     * åˆ†ç±»åç§°
     */
    @ApiModelProperty(value = "问卷分类名称")
    @Excel(name = " åˆ†ç±»åç§° ")
    private String categoryname;
    /**  æœºæž„ID  */
    /**
     * æœºæž„ID
     */
    @ApiModelProperty(value = "机构ID")
    @Excel(name = " æœºæž„ID ")
    private String orgid;
    /**  åˆ é™¤æ ‡è®°  */
    /**
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty(value = "删除标记")
    private String delFlag;
    /**  ä¸Šä¼ æ ‡è®°  */
    /**
     * ä¸Šä¼ æ ‡è®°
     */
    @ApiModelProperty(value = "上传标记")
    private Long isupload;
    /**  ä¸Šä¼ æ—¶é—´  */
    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;
    public void setId(Long id)
    {
        this.id = id;
    }
    /**
     * é—®å·æ•°é‡
     */
    @ApiModelProperty(value = "问卷数量")
    private String svyNum;
    public Long getId()
    {
        return id;
    }
    public void setCategoryname(String categoryname)
    {
        this.categoryname = categoryname;
    }
    public String getCategoryname()
    {
        return categoryname;
    }
    public void setOrgid(String orgid)
    {
        this.orgid = orgid;
    }
    public String getOrgid()
    {
        return orgid;
    }
    public void setDelFlag(String delFlag)
    {
        this.delFlag = delFlag;
    }
    public String getDelFlag()
    {
        return delFlag;
    }
    public void setIsupload(Long isupload)
    {
        this.isupload = isupload;
    }
    public Long getIsupload()
    {
        return isupload;
    }
    public void setUploadTime(Date uploadTime)
    {
        this.uploadTime = uploadTime;
    }
    public Date getUploadTime()
    {
        return uploadTime;
    }
    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("categoryname", getCategoryname())
            .append("orgid", getOrgid())
            .append("delFlag", getDelFlag())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("isupload", getIsupload())
            .append("uploadTime", getUploadTime())
            .toString();
    }
}
smartor/src/main/java/com/smartor/mapper/PatArchinvecontactMapper.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.smartor.mapper;
import com.smartor.domain.PatArchinvecontact;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * æ‚£è€…联系方式Mapper接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Mapper
public interface PatArchinvecontactMapper {
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式
     *
     * @param id æ‚£è€…联系方式主键
     * @return æ‚£è€…联系方式
     */
    public PatArchinvecontact selectPatArchinvecontactById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式列表
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return æ‚£è€…联系方式集合
     */
    public List<PatArchinvecontact> selectPatArchinvecontactList(PatArchinvecontact patArchinvecontact);
    /**
     * æ–°å¢žæ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    public int insertPatArchinvecontact(PatArchinvecontact patArchinvecontact);
    /**
     * ä¿®æ”¹æ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    public int updatePatArchinvecontact(PatArchinvecontact patArchinvecontact);
    /**
     * åˆ é™¤æ‚£è€…联系方式
     *
     * @param id æ‚£è€…联系方式主键
     * @return ç»“æžœ
     */
    public int deletePatArchinvecontactById(Long id);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…联系方式
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ•°æ®ä¸»é”®é›†åˆ
     * @return ç»“æžœ
     */
    public int deletePatArchinvecontactByIds(Long[] ids);
}
smartor/src/main/java/com/smartor/mapper/PatMedDrugMapper.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.smartor.mapper;
import com.smartor.domain.PatMedDrug;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * æ‚£è€…用药记录Mapper接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Mapper
public interface PatMedDrugMapper {
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录
     *
     * @param id æ‚£è€…用药记录主键
     * @return æ‚£è€…用药记录
     */
    public PatMedDrug selectPatMedDrugById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录列表
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return æ‚£è€…用药记录集合
     */
    public List<PatMedDrug> selectPatMedDrugList(PatMedDrug patMedDrug);
    /**
     * æ–°å¢žæ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    public int insertPatMedDrug(PatMedDrug patMedDrug);
    /**
     * ä¿®æ”¹æ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    public int updatePatMedDrug(PatMedDrug patMedDrug);
    /**
     * åˆ é™¤æ‚£è€…用药记录
     *
     * @param id æ‚£è€…用药记录主键
     * @return ç»“æžœ
     */
    public int deletePatMedDrugById(Long id);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…用药记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ•°æ®ä¸»é”®é›†åˆ
     * @return ç»“æžœ
     */
    public int deletePatMedDrugByIds(Long[] ids);
}
smartor/src/main/java/com/smartor/mapper/PatMedInspectionMapper.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.smartor.mapper;
import com.smartor.domain.PatMedInspection;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * æ‚£è€…检查检验记录Mapper接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Mapper
public interface PatMedInspectionMapper {
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return æ‚£è€…检查检验记录
     */
    public PatMedInspection selectPatMedInspectionById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录列表
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return æ‚£è€…检查检验记录集合
     */
    public List<PatMedInspection> selectPatMedInspectionList(PatMedInspection patMedInspection);
    /**
     * æ–°å¢žæ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    public int insertPatMedInspection(PatMedInspection patMedInspection);
    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    public int updatePatMedInspection(PatMedInspection patMedInspection);
    /**
     * åˆ é™¤æ‚£è€…检查检验记录
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return ç»“æžœ
     */
    public int deletePatMedInspectionById(Long id);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ•°æ®ä¸»é”®é›†åˆ
     * @return ç»“æžœ
     */
    public int deletePatMedInspectionByIds(Long[] ids);
}
smartor/src/main/java/com/smartor/mapper/SvyCategoryMapper.java
@@ -1,7 +1,9 @@
package com.smartor.mapper;
import java.util.List;
import com.smartor.domain.SvyCategory;
import org.apache.ibatis.annotations.Mapper;
/**
 * é—®å·åˆ†ç±»Mapper接口
@@ -9,15 +11,15 @@
 * @author ruoyi
 * @date 2023-03-02
 */
public interface SvyCategoryMapper
{
@Mapper
public interface SvyCategoryMapper {
    /**
     * æŸ¥è¯¢é—®å·åˆ†ç±»
     * 
     * @param id é—®å·åˆ†ç±»ä¸»é”®
     * @return é—®å·åˆ†ç±»
     */
    public SvyCategory selectSvyCategoryById(Long id);
    public List<SvyCategory> selectSvyCategoryById(String categoryname);
    /**
     * æŸ¥è¯¢é—®å·åˆ†ç±»åˆ—表
smartor/src/main/java/com/smartor/service/IPatArchinvecontactService.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;
import com.smartor.domain.PatArchinvecontact;
import java.util.List;
/**
 * æ‚£è€…联系方式Service接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
public interface IPatArchinvecontactService
{
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式
     *
     * @param id æ‚£è€…联系方式主键
     * @return æ‚£è€…联系方式
     */
    public PatArchinvecontact selectPatArchinvecontactById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式列表
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return æ‚£è€…联系方式集合
     */
    public List<PatArchinvecontact> selectPatArchinvecontactList(PatArchinvecontact patArchinvecontact);
    /**
     * æ–°å¢žæ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    public int insertPatArchinvecontact(PatArchinvecontact patArchinvecontact);
    /**
     * ä¿®æ”¹æ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    public int updatePatArchinvecontact(PatArchinvecontact patArchinvecontact);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…联系方式
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…联系方式主键集合
     * @return ç»“æžœ
     */
    public int deletePatArchinvecontactByIds(Long[] ids);
    /**
     * åˆ é™¤æ‚£è€…联系方式信息
     *
     * @param id æ‚£è€…联系方式主键
     * @return ç»“æžœ
     */
    public int deletePatArchinvecontactById(Long id);
}
smartor/src/main/java/com/smartor/service/IPatMedDrugService.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;
import com.smartor.domain.PatMedDrug;
import java.util.List;
/**
 * æ‚£è€…用药记录Service接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
public interface IPatMedDrugService
{
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录
     *
     * @param id æ‚£è€…用药记录主键
     * @return æ‚£è€…用药记录
     */
    public PatMedDrug selectPatMedDrugById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录列表
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return æ‚£è€…用药记录集合
     */
    public List<PatMedDrug> selectPatMedDrugList(PatMedDrug patMedDrug);
    /**
     * æ–°å¢žæ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    public int insertPatMedDrug(PatMedDrug patMedDrug);
    /**
     * ä¿®æ”¹æ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    public int updatePatMedDrug(PatMedDrug patMedDrug);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…用药记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…用药记录主键集合
     * @return ç»“æžœ
     */
    public int deletePatMedDrugByIds(Long[] ids);
    /**
     * åˆ é™¤æ‚£è€…用药记录信息
     *
     * @param id æ‚£è€…用药记录主键
     * @return ç»“æžœ
     */
    public int deletePatMedDrugById(Long id);
}
smartor/src/main/java/com/smartor/service/IPatMedInspectionService.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;
import com.smartor.domain.PatMedInspection;
import java.util.List;
/**
 * æ‚£è€…检查检验记录Service接口
 *
 * @author ruoyi
 * @date 2023-06-16
 */
public interface IPatMedInspectionService
{
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return æ‚£è€…检查检验记录
     */
    public PatMedInspection selectPatMedInspectionById(Long id);
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录列表
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return æ‚£è€…检查检验记录集合
     */
    public List<PatMedInspection> selectPatMedInspectionList(PatMedInspection patMedInspection);
    /**
     * æ–°å¢žæ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    public int insertPatMedInspection(PatMedInspection patMedInspection);
    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    public int updatePatMedInspection(PatMedInspection patMedInspection);
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…检查检验记录主键集合
     * @return ç»“æžœ
     */
    public int deletePatMedInspectionByIds(Long[] ids);
    /**
     * åˆ é™¤æ‚£è€…检查检验记录信息
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return ç»“æžœ
     */
    public int deletePatMedInspectionById(Long id);
}
smartor/src/main/java/com/smartor/service/ISvyCategoryService.java
@@ -1,6 +1,7 @@
package com.smartor.service;
import java.util.List;
import com.smartor.domain.SvyCategory;
/**
@@ -9,15 +10,14 @@
 * @author ruoyi
 * @date 2023-03-02
 */
public interface ISvyCategoryService
{
public interface ISvyCategoryService {
    /**
     * æŸ¥è¯¢é—®å·åˆ†ç±»
     * 
     * @param id é—®å·åˆ†ç±»ä¸»é”®
     * @return é—®å·åˆ†ç±»
     */
    public SvyCategory selectSvyCategoryById(Long id);
    public List<SvyCategory> selectSvyCategoryById(String categoryname);
    /**
     * æŸ¥è¯¢é—®å·åˆ†ç±»åˆ—表
smartor/src/main/java/com/smartor/service/impl/PatArchinvecontactServiceImpl.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.smartor.service.impl;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.PatArchinvecontact;
import com.smartor.mapper.PatArchinvecontactMapper;
import com.smartor.service.IPatArchinvecontactService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
 * æ‚£è€…联系方式Service业务层处理
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Service
public class PatArchinvecontactServiceImpl implements IPatArchinvecontactService
{
    @Autowired
    private PatArchinvecontactMapper patArchinvecontactMapper;
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式
     *
     * @param id æ‚£è€…联系方式主键
     * @return æ‚£è€…联系方式
     */
    @Override
    public PatArchinvecontact selectPatArchinvecontactById(Long id)
    {
        return patArchinvecontactMapper.selectPatArchinvecontactById(id);
    }
    /**
     * æŸ¥è¯¢æ‚£è€…联系方式列表
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return æ‚£è€…联系方式
     */
    @Override
    public List<PatArchinvecontact> selectPatArchinvecontactList(PatArchinvecontact patArchinvecontact)
    {
        return patArchinvecontactMapper.selectPatArchinvecontactList(patArchinvecontact);
    }
    /**
     * æ–°å¢žæ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    @Override
    public int insertPatArchinvecontact(PatArchinvecontact patArchinvecontact)
    {
        patArchinvecontact.setCreateTime(DateUtils.getNowDate());
        return patArchinvecontactMapper.insertPatArchinvecontact(patArchinvecontact);
    }
    /**
     * ä¿®æ”¹æ‚£è€…联系方式
     *
     * @param patArchinvecontact æ‚£è€…联系方式
     * @return ç»“æžœ
     */
    @Override
    public int updatePatArchinvecontact(PatArchinvecontact patArchinvecontact)
    {
        patArchinvecontact.setUpdateTime(DateUtils.getNowDate());
        return patArchinvecontactMapper.updatePatArchinvecontact(patArchinvecontact);
    }
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…联系方式
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…联系方式主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatArchinvecontactByIds(Long[] ids)
    {
        return patArchinvecontactMapper.deletePatArchinvecontactByIds(ids);
    }
    /**
     * åˆ é™¤æ‚£è€…联系方式信息
     *
     * @param id æ‚£è€…联系方式主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatArchinvecontactById(Long id)
    {
        return patArchinvecontactMapper.deletePatArchinvecontactById(id);
    }
}
smartor/src/main/java/com/smartor/service/impl/PatMedDrugServiceImpl.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,90 @@
package com.smartor.service.impl;
import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.PatMedDrug;
import com.smartor.mapper.PatMedDrugMapper;
import com.smartor.service.IPatMedDrugService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
 * æ‚£è€…用药记录Service业务层处理
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Service
public class PatMedDrugServiceImpl implements IPatMedDrugService {
    @Autowired
    private PatMedDrugMapper patMedDrugMapper;
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录
     *
     * @param id æ‚£è€…用药记录主键
     * @return æ‚£è€…用药记录
     */
    @Override
    public PatMedDrug selectPatMedDrugById(Long id) {
        return patMedDrugMapper.selectPatMedDrugById(id);
    }
    /**
     * æŸ¥è¯¢æ‚£è€…用药记录列表
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return æ‚£è€…用药记录
     */
    @Override
    public List<PatMedDrug> selectPatMedDrugList(PatMedDrug patMedDrug) {
        return patMedDrugMapper.selectPatMedDrugList(patMedDrug);
    }
    /**
     * æ–°å¢žæ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    @Override
    public int insertPatMedDrug(PatMedDrug patMedDrug) {
        patMedDrug.setCreateTime(DateUtils.getNowDate());
        return patMedDrugMapper.insertPatMedDrug(patMedDrug);
    }
    /**
     * ä¿®æ”¹æ‚£è€…用药记录
     *
     * @param patMedDrug æ‚£è€…用药记录
     * @return ç»“æžœ
     */
    @Override
    public int updatePatMedDrug(PatMedDrug patMedDrug) {
        patMedDrug.setUpdateTime(DateUtils.getNowDate());
        return patMedDrugMapper.updatePatMedDrug(patMedDrug);
    }
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…用药记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…用药记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedDrugByIds(Long[] ids) {
        return patMedDrugMapper.deletePatMedDrugByIds(ids);
    }
    /**
     * åˆ é™¤æ‚£è€…用药记录信息
     *
     * @param id æ‚£è€…用药记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedDrugById(Long id) {
        return patMedDrugMapper.deletePatMedDrugById(id);
    }
}
smartor/src/main/java/com/smartor/service/impl/PatMedInspectionServiceImpl.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.smartor.service.impl;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.PatMedInspection;
import com.smartor.mapper.PatMedInspectionMapper;
import com.smartor.service.IPatMedInspectionService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
 * æ‚£è€…检查检验记录Service业务层处理
 *
 * @author ruoyi
 * @date 2023-06-16
 */
@Service
public class PatMedInspectionServiceImpl implements IPatMedInspectionService
{
    @Autowired
    private PatMedInspectionMapper patMedInspectionMapper;
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return æ‚£è€…检查检验记录
     */
    @Override
    public PatMedInspection selectPatMedInspectionById(Long id)
    {
        return patMedInspectionMapper.selectPatMedInspectionById(id);
    }
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录列表
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return æ‚£è€…检查检验记录
     */
    @Override
    public List<PatMedInspection> selectPatMedInspectionList(PatMedInspection patMedInspection)
    {
        return patMedInspectionMapper.selectPatMedInspectionList(patMedInspection);
    }
    /**
     * æ–°å¢žæ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    @Override
    public int insertPatMedInspection(PatMedInspection patMedInspection)
    {
        patMedInspection.setCreateTime(DateUtils.getNowDate());
        return patMedInspectionMapper.insertPatMedInspection(patMedInspection);
    }
    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录
     *
     * @param patMedInspection æ‚£è€…检查检验记录
     * @return ç»“æžœ
     */
    @Override
    public int updatePatMedInspection(PatMedInspection patMedInspection)
    {
        patMedInspection.setUpdateTime(DateUtils.getNowDate());
        return patMedInspectionMapper.updatePatMedInspection(patMedInspection);
    }
    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„æ‚£è€…检查检验记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedInspectionByIds(Long[] ids)
    {
        return patMedInspectionMapper.deletePatMedInspectionByIds(ids);
    }
    /**
     * åˆ é™¤æ‚£è€…检查检验记录信息
     *
     * @param id æ‚£è€…检查检验记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedInspectionById(Long id)
    {
        return patMedInspectionMapper.deletePatMedInspectionById(id);
    }
}
smartor/src/main/java/com/smartor/service/impl/SvyCategoryServiceImpl.java
@@ -27,9 +27,9 @@
     * @return é—®å·åˆ†ç±»
     */
    @Override
    public SvyCategory selectSvyCategoryById(Long id)
    public List<SvyCategory> selectSvyCategoryById(String categoryname)
    {
        return svyCategoryMapper.selectSvyCategoryById(id);
        return svyCategoryMapper.selectSvyCategoryById(categoryname);
    }
    /**
smartor/src/main/resources/mapper/smartor/PatArchinvecontactMapper.xml
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,116 @@
<?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.PatArchinvecontactMapper">
    <resultMap type="com.smartor.domain.PatArchinvecontact" id="PatArchinvecontactResult">
        <result property="id"    column="id"    />
        <result property="patid"    column="patid"    />
        <result property="contactway"    column="contactway"    />
        <result property="relation"    column="relation"    />
        <result property="datasource"    column="datasource"    />
        <result property="isdefault"    column="isdefault"    />
        <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="contactname"    column="contactname"    />
    </resultMap>
    <sql id="selectPatArchinvecontactVo">
        select id, patid, contactway, relation, datasource, isdefault, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, contactname from pat_archinvecontact
    </sql>
    <select id="selectPatArchinvecontactList" parameterType="com.smartor.domain.PatArchinvecontact" resultMap="PatArchinvecontactResult">
        <include refid="selectPatArchinvecontactVo"/>
        <where>
            <if test="patid != null "> and patid = #{patid}</if>
            <if test="contactway != null  and contactway != ''"> and contactway = #{contactway}</if>
            <if test="relation != null "> and relation = #{relation}</if>
            <if test="datasource != null "> and datasource = #{datasource}</if>
            <if test="isdefault != null "> and isdefault = #{isdefault}</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="contactname != null  and contactname != ''"> and contactname like concat('%', #{contactname}, '%')</if>
        </where>
    </select>
    <select id="selectPatArchinvecontactById" parameterType="Long" resultMap="PatArchinvecontactResult">
        <include refid="selectPatArchinvecontactVo"/>
        where id = #{id}
    </select>
    <insert id="insertPatArchinvecontact" parameterType="com.smartor.domain.PatArchinvecontact" useGeneratedKeys="true" keyProperty="id">
        insert into pat_archinvecontact
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="patid != null">patid,</if>
            <if test="contactway != null">contactway,</if>
            <if test="relation != null">relation,</if>
            <if test="datasource != null">datasource,</if>
            <if test="isdefault != null">isdefault,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null and delFlag != ''">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="contactname != null">contactname,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="patid != null">#{patid},</if>
            <if test="contactway != null">#{contactway},</if>
            <if test="relation != null">#{relation},</if>
            <if test="datasource != null">#{datasource},</if>
            <if test="isdefault != null">#{isdefault},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="contactname != null">#{contactname},</if>
         </trim>
    </insert>
    <update id="updatePatArchinvecontact" parameterType="com.smartor.domain.PatArchinvecontact">
        update pat_archinvecontact
        <trim prefix="SET" suffixOverrides=",">
            <if test="patid != null">patid = #{patid},</if>
            <if test="contactway != null">contactway = #{contactway},</if>
            <if test="relation != null">relation = #{relation},</if>
            <if test="datasource != null">datasource = #{datasource},</if>
            <if test="isdefault != null">isdefault = #{isdefault},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="contactname != null">contactname = #{contactname},</if>
        </trim>
        where id = #{id}
    </update>
    <delete id="deletePatArchinvecontactById" parameterType="Long">
        delete from pat_archinvecontact where id = #{id}
    </delete>
    <delete id="deletePatArchinvecontactByIds" parameterType="String">
        delete from pat_archinvecontact where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>
smartor/src/main/resources/mapper/smartor/PatMedDrugMapper.xml
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,182 @@
<?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.PatMedDrugMapper">
    <resultMap type="com.smartor.domain.PatMedDrug" id="PatMedDrugResult">
        <result property="id" column="id"/>
        <result property="serialnum" column="serialnum"/>
        <result property="patid" column="patid"/>
        <result property="drugname" column="drugname"/>
        <result property="opendate" column="opendate"/>
        <result property="drugtype" column="drugtype"/>
        <result property="unit" column="unit"/>
        <result property="spec" column="spec"/>
        <result property="drugusage" column="drugusage"/>
        <result property="dose" column="dose"/>
        <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="drugid" column="drugid"/>
        <result property="visittype" column="visittype"/>
        <result property="visitid" column="visitid"/>
        <result property="schemestatus" column="schemestatus"/>
        <result property="schemetime" column="schemetime"/>
    </resultMap>
    <sql id="selectPatMedDrugVo">
        select id,
               serialnum,
               patid,
               drugname,
               opendate,
               drugtype,
               unit,
               spec,
               drugusage,
               dose,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               drugid,
               visittype,
               visitid,
               schemestatus,
               schemetime
        from pat_med_drug
    </sql>
    <select id="selectPatMedDrugList" parameterType="com.smartor.domain.PatMedDrug" resultMap="PatMedDrugResult">
        <include refid="selectPatMedDrugVo"/>
        <where>
            <if test="serialnum != null  and serialnum != ''">and serialnum = #{serialnum}</if>
            <if test="patid != null ">and patid = #{patid}</if>
            <if test="drugname != null  and drugname != ''">and drugname like concat('%', #{drugname}, '%')</if>
            <if test="opendate != null ">and opendate = #{opendate}</if>
            <if test="drugtype != null  and drugtype != ''">and drugtype = #{drugtype}</if>
            <if test="unit != null  and unit != ''">and unit = #{unit}</if>
            <if test="spec != null  and spec != ''">and spec = #{spec}</if>
            <if test="drugusage != null  and drugusage != ''">and drugusage = #{drugusage}</if>
            <if test="dose != null  and dose != ''">and dose = #{dose}</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="drugid != null ">and drugid = #{drugid}</if>
            <if test="visittype != null ">and visittype = #{visittype}</if>
            <if test="visitid != null ">and visitid = #{visitid}</if>
            <if test="schemestatus != null ">and schemestatus = #{schemestatus}</if>
            <if test="schemetime != null ">and schemetime = #{schemetime}</if>
        </where>
    </select>
    <select id="selectPatMedDrugById" parameterType="Long" resultMap="PatMedDrugResult">
        <include refid="selectPatMedDrugVo"/>
        where id = #{id}
    </select>
    <insert id="insertPatMedDrug" parameterType="com.smartor.domain.PatMedDrug" useGeneratedKeys="true"
            keyProperty="id">
        insert into pat_med_drug
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="serialnum != null">serialnum,</if>
            <if test="patid != null">patid,</if>
            <if test="drugname != null">drugname,</if>
            <if test="opendate != null">opendate,</if>
            <if test="drugtype != null">drugtype,</if>
            <if test="unit != null">unit,</if>
            <if test="spec != null">spec,</if>
            <if test="drugusage != null">drugusage,</if>
            <if test="dose != null">dose,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null and delFlag != ''">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="drugid != null">drugid,</if>
            <if test="visittype != null">visittype,</if>
            <if test="visitid != null">visitid,</if>
            <if test="schemestatus != null">schemestatus,</if>
            <if test="schemetime != null">schemetime,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="serialnum != null">#{serialnum},</if>
            <if test="patid != null">#{patid},</if>
            <if test="drugname != null">#{drugname},</if>
            <if test="opendate != null">#{opendate},</if>
            <if test="drugtype != null">#{drugtype},</if>
            <if test="unit != null">#{unit},</if>
            <if test="spec != null">#{spec},</if>
            <if test="drugusage != null">#{drugusage},</if>
            <if test="dose != null">#{dose},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="drugid != null">#{drugid},</if>
            <if test="visittype != null">#{visittype},</if>
            <if test="visitid != null">#{visitid},</if>
            <if test="schemestatus != null">#{schemestatus},</if>
            <if test="schemetime != null">#{schemetime},</if>
        </trim>
    </insert>
    <update id="updatePatMedDrug" parameterType="com.smartor.domain.PatMedDrug">
        update pat_med_drug
        <trim prefix="SET" suffixOverrides=",">
            <if test="serialnum != null">serialnum = #{serialnum},</if>
            <if test="patid != null">patid = #{patid},</if>
            <if test="drugname != null">drugname = #{drugname},</if>
            <if test="opendate != null">opendate = #{opendate},</if>
            <if test="drugtype != null">drugtype = #{drugtype},</if>
            <if test="unit != null">unit = #{unit},</if>
            <if test="spec != null">spec = #{spec},</if>
            <if test="drugusage != null">drugusage = #{drugusage},</if>
            <if test="dose != null">dose = #{dose},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="drugid != null">drugid = #{drugid},</if>
            <if test="visittype != null">visittype = #{visittype},</if>
            <if test="visitid != null">visitid = #{visitid},</if>
            <if test="schemestatus != null">schemestatus = #{schemestatus},</if>
            <if test="schemetime != null">schemetime = #{schemetime},</if>
        </trim>
        where id = #{id}
    </update>
    <delete id="deletePatMedDrugById" parameterType="Long">
        delete
        from pat_med_drug
        where id = #{id}
    </delete>
    <delete id="deletePatMedDrugByIds" parameterType="String">
        delete from pat_med_drug where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>
smartor/src/main/resources/mapper/smartor/PatMedInspectionMapper.xml
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,218 @@
<?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.PatMedInspectionMapper">
    <resultMap type="com.smartor.domain.PatMedInspection" id="PatMedInspectionResult">
        <result property="id" column="id"/>
        <result property="serialnum" column="serialnum"/>
        <result property="patid" column="patid"/>
        <result property="projecttype" column="projecttype"/>
        <result property="projectcode" column="projectcode"/>
        <result property="projectname" column="projectname"/>
        <result property="reporttime" column="reporttime"/>
        <result property="hospitalname" column="hospitalname"/>
        <result property="hospitalcode" column="hospitalcode"/>
        <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="projectid" column="projectid"/>
        <result property="applicationtime" column="applicationtime"/>
        <result property="visittype" column="visittype"/>
        <result property="visitid" column="visitid"/>
        <result property="schemestatus" column="schemestatus"/>
        <result property="isabnormal" column="isabnormal"/>
        <result property="reportconclusion" column="reportconclusion"/>
        <result property="schemetime" column="schemetime"/>
        <result property="deptcode" column="deptcode"/>
        <result property="deptname" column="deptname"/>
        <result property="deptid" column="deptid"/>
    </resultMap>
    <sql id="selectPatMedInspectionVo">
        select id,
               serialnum,
               patid,
               projecttype,
               projectcode,
               projectname,
               reporttime,
               hospitalname,
               hospitalcode,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               projectid,
               applicationtime,
               visittype,
               visitid,
               schemestatus,
               isabnormal,
               reportconclusion,
               schemetime,
               deptcode,
               deptname,
               deptid
        from pat_med_inspection
    </sql>
    <select id="selectPatMedInspectionList" parameterType="com.smartor.domain.PatMedInspection"
            resultMap="PatMedInspectionResult">
        <include refid="selectPatMedInspectionVo"/>
        <where>
            <if test="serialnum != null  and serialnum != ''">and serialnum = #{serialnum}</if>
            <if test="patid != null ">and patid = #{patid}</if>
            <if test="projecttype != null ">and projecttype = #{projecttype}</if>
            <if test="projectcode != null  and projectcode != ''">and projectcode = #{projectcode}</if>
            <if test="projectname != null  and projectname != ''">and projectname like concat('%', #{projectname},
                '%')
            </if>
            <if test="reporttime != null ">and reporttime = #{reporttime}</if>
            <if test="hospitalname != null  and hospitalname != ''">and hospitalname like concat('%', #{hospitalname},
                '%')
            </if>
            <if test="hospitalcode != null  and hospitalcode != ''">and hospitalcode = #{hospitalcode}</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="projectid != null ">and projectid = #{projectid}</if>
            <if test="applicationtime != null ">and applicationtime = #{applicationtime}</if>
            <if test="visittype != null ">and visittype = #{visittype}</if>
            <if test="visitid != null ">and visitid = #{visitid}</if>
            <if test="schemestatus != null ">and schemestatus = #{schemestatus}</if>
            <if test="isabnormal != null ">and isabnormal = #{isabnormal}</if>
            <if test="reportconclusion != null  and reportconclusion != ''">and reportconclusion = #{reportconclusion}
            </if>
            <if test="schemetime != null ">and schemetime = #{schemetime}</if>
            <if test="deptcode != null  and deptcode != ''">and deptcode = #{deptcode}</if>
            <if test="deptname != null  and deptname != ''">and deptname like concat('%', #{deptname}, '%')</if>
            <if test="deptid != null ">and deptid = #{deptid}</if>
        </where>
    </select>
    <select id="selectPatMedInspectionById" parameterType="Long" resultMap="PatMedInspectionResult">
        <include refid="selectPatMedInspectionVo"/>
        where id = #{id}
    </select>
    <insert id="insertPatMedInspection" parameterType="com.smartor.domain.PatMedInspection" useGeneratedKeys="true"
            keyProperty="id">
        insert into pat_med_inspection
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="serialnum != null">serialnum,</if>
            <if test="patid != null">patid,</if>
            <if test="projecttype != null">projecttype,</if>
            <if test="projectcode != null">projectcode,</if>
            <if test="projectname != null">projectname,</if>
            <if test="reporttime != null">reporttime,</if>
            <if test="hospitalname != null">hospitalname,</if>
            <if test="hospitalcode != null">hospitalcode,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null and delFlag != ''">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="projectid != null">projectid,</if>
            <if test="applicationtime != null">applicationtime,</if>
            <if test="visittype != null">visittype,</if>
            <if test="visitid != null">visitid,</if>
            <if test="schemestatus != null">schemestatus,</if>
            <if test="isabnormal != null">isabnormal,</if>
            <if test="reportconclusion != null">reportconclusion,</if>
            <if test="schemetime != null">schemetime,</if>
            <if test="deptcode != null">deptcode,</if>
            <if test="deptname != null">deptname,</if>
            <if test="deptid != null">deptid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="serialnum != null">#{serialnum},</if>
            <if test="patid != null">#{patid},</if>
            <if test="projecttype != null">#{projecttype},</if>
            <if test="projectcode != null">#{projectcode},</if>
            <if test="projectname != null">#{projectname},</if>
            <if test="reporttime != null">#{reporttime},</if>
            <if test="hospitalname != null">#{hospitalname},</if>
            <if test="hospitalcode != null">#{hospitalcode},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="projectid != null">#{projectid},</if>
            <if test="applicationtime != null">#{applicationtime},</if>
            <if test="visittype != null">#{visittype},</if>
            <if test="visitid != null">#{visitid},</if>
            <if test="schemestatus != null">#{schemestatus},</if>
            <if test="isabnormal != null">#{isabnormal},</if>
            <if test="reportconclusion != null">#{reportconclusion},</if>
            <if test="schemetime != null">#{schemetime},</if>
            <if test="deptcode != null">#{deptcode},</if>
            <if test="deptname != null">#{deptname},</if>
            <if test="deptid != null">#{deptid},</if>
        </trim>
    </insert>
    <update id="updatePatMedInspection" parameterType="com.smartor.domain.PatMedInspection">
        update pat_med_inspection
        <trim prefix="SET" suffixOverrides=",">
            <if test="serialnum != null">serialnum = #{serialnum},</if>
            <if test="patid != null">patid = #{patid},</if>
            <if test="projecttype != null">projecttype = #{projecttype},</if>
            <if test="projectcode != null">projectcode = #{projectcode},</if>
            <if test="projectname != null">projectname = #{projectname},</if>
            <if test="reporttime != null">reporttime = #{reporttime},</if>
            <if test="hospitalname != null">hospitalname = #{hospitalname},</if>
            <if test="hospitalcode != null">hospitalcode = #{hospitalcode},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="projectid != null">projectid = #{projectid},</if>
            <if test="applicationtime != null">applicationtime = #{applicationtime},</if>
            <if test="visittype != null">visittype = #{visittype},</if>
            <if test="visitid != null">visitid = #{visitid},</if>
            <if test="schemestatus != null">schemestatus = #{schemestatus},</if>
            <if test="isabnormal != null">isabnormal = #{isabnormal},</if>
            <if test="reportconclusion != null">reportconclusion = #{reportconclusion},</if>
            <if test="schemetime != null">schemetime = #{schemetime},</if>
            <if test="deptcode != null">deptcode = #{deptcode},</if>
            <if test="deptname != null">deptname = #{deptname},</if>
            <if test="deptid != null">deptid = #{deptid},</if>
        </trim>
        where id = #{id}
    </update>
    <delete id="deletePatMedInspectionById" parameterType="Long">
        delete
        from pat_med_inspection
        where id = #{id}
    </delete>
    <delete id="deletePatMedInspectionByIds" parameterType="String">
        delete from pat_med_inspection where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>
smartor/src/main/resources/mapper/smartor/SvyCategoryMapper.xml
@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.smartor.mapper.SvyCategoryMapper">
    
    <resultMap type="SvyCategory" id="SvyCategoryResult">
    <resultMap type="com.smartor.domain.SvyCategory" id="SvyCategoryResult">
        <result property="id"    column="id"    />
        <result property="categoryname"    column="categoryname"    />
        <result property="orgid"    column="orgid"    />
@@ -18,23 +18,53 @@
    </resultMap>
    <sql id="selectSvyCategoryVo">
        select id, categoryname, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time from svy_category
        select id,
               categoryname,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time
        from svy_category
    </sql>
    <select id="selectSvyCategoryList" parameterType="SvyCategory" resultMap="SvyCategoryResult">
    <select id="selectSvyCategoryList" parameterType="com.smartor.domain.SvyCategory" resultMap="SvyCategoryResult">
        <include refid="selectSvyCategoryVo"/>
        <where>  
            <if test="categoryname != null  and categoryname != ''"> and categoryname like concat('%', #{categoryname}, '%')</if>
            <if test="categoryname != null  and categoryname != ''">and categoryname like concat('%', #{categoryname},
                '%')
            </if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
        </where>
    </select>
    
    <select id="selectSvyCategoryById" parameterType="Long" resultMap="SvyCategoryResult">
        <include refid="selectSvyCategoryVo"/>
        where id = #{id}
    <select id="selectSvyCategoryById" parameterType="String" resultType="com.smartor.domain.SvyCategory">
        select a.id,
        a.categoryname,
        a. orgid,
        a.del_flag,
        a.update_by,
        a.update_time,
        a.create_by,
        a.create_time,
        a.isupload,
        a.upload_time,
        count(b.svyid) svyNum
        from svy_category a,svy_lib_title b
        <where>
            a.id = b.categoryid
            <if test="categoryname != null and categoryname != ''">
                and categoryname = #{categoryname}
            </if>
        </where>
     group by  a.categoryname
    </select>
        
    <insert id="insertSvyCategory" parameterType="SvyCategory" useGeneratedKeys="true" keyProperty="id">
    <insert id="insertSvyCategory" parameterType="com.smartor.domain.SvyCategory" useGeneratedKeys="true"
            keyProperty="id">
        insert into svy_category
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="categoryname != null">categoryname,</if>
@@ -60,7 +90,7 @@
         </trim>
    </insert>
    <update id="updateSvyCategory" parameterType="SvyCategory">
    <update id="updateSvyCategory" parameterType="com.smartor.domain.SvyCategory">
        update svy_category
        <trim prefix="SET" suffixOverrides=",">
            <if test="categoryname != null">categoryname = #{categoryname},</if>
@@ -77,7 +107,9 @@
    </update>
    <delete id="deleteSvyCategoryById" parameterType="Long">
        delete from svy_category where id = #{id}
        delete
        from svy_category
        where id = #{id}
    </delete>
    <delete id="deleteSvyCategoryByIds" parameterType="String">