zjh 2024/01/03--1

zjh

2024-01-03 a2b14a4b47d4184b7d9ae885557840fee894d79a

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java

@@ -12,7 +12,9 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ltkj.common.core.domain.entity.SysDept;
import com.ltkj.common.utils.bean.BeanUtils;
import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
import com.ltkj.hosp.domain.*;
import com.ltkj.hosp.mapper.TestMapper;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.treeUtil.TreeSelect;
import com.ltkj.system.service.ISysConfigService;
@@ -57,6 +59,20 @@
    private DictProSfxmService dictProSfxmService;
    @Autowired
    private ITjRulesService tjRulesService;
    @Resource
    private TestMapper testMapper;


    @GetMapping("/getTjHyBgList")
    @ApiOperation(value = "查询lis数据库项目信息接口")
    public AjaxResult getTjHyBgList(@RequestParam(required = false)String pacCode,
                                  @RequestParam(required = false)String pacName,
                                  @RequestParam(required = false)String pacRemark) {
        List<Map<String, Object>> maps = testMapper.getTjHyBgList(pacCode,pacName,pacRemark);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(maps);
    }


    /**
     * 查询体检项目列表
@@ -66,27 +82,34 @@
    public AjaxResult getlist(@RequestParam(required = false) @ApiParam(value = "项目名称") String proName,
                              @RequestParam(required = false) @ApiParam(value = "检查类别") String checkType,
                              @RequestParam(required = false) @ApiParam(value = "部门id") String deptId) {
        LambdaQueryWrapper<TjProject> wq0 = new LambdaQueryWrapper<>();
        wq0.eq(TjProject::getProParentId, 0);
        if(null !=proName){
            wq0.like(TjProject::getProName,proName);
        }
        if(null !=checkType){
            wq0.like(TjProject::getProCheckType,checkType);
        }
        if(null !=deptId){
            wq0.like(TjProject::getDeptId,deptId);
        }
//        LambdaQueryWrapper<TjProject> wq0 = new LambdaQueryWrapper<>();
//        wq0.eq(TjProject::getProParentId, 0);
//        if(null !=proName){
//            wq0.like(TjProject::getProName,proName);
//        }
//        if(null !=checkType){
//            wq0.like(TjProject::getProCheckType,checkType);
//        }
//        if(null !=deptId){
//            wq0.like(TjProject::getDeptId,deptId);
//        }
//
//        List<TjProject> tjProjects = tjProjectService.list(wq0);

        List<TjProject> tjProjects = tjProjectService.list(wq0);
        //上面的换sql
        final List<TjProject> tjProjects = tjProjectService.getProBySqlAndName(proName, checkType, deptId);

        if (tjProjects != null) {
            for (TjProject project : tjProjects) {
                LambdaQueryWrapper<TjProject> wq1 = new LambdaQueryWrapper<>();
                wq1.eq(TjProject::getProParentId, project.getProId());
                if(null !=proName) {
                    wq1.like(TjProject::getProName, proName);
                }
                List<TjProject> projectList = tjProjectService.list(wq1);
                project.setTjProjectList(projectList);

                //根据每个项目的deptId拿到name  2023/2/7

                SysDept sysDept = deptService.selectDeptById(project.getDeptId());
                if (sysDept!=null){
                    project.setDeptName(sysDept.getDeptName());
@@ -125,7 +148,7 @@
    /**
     * 导出体检项目列表
     */
    @PreAuthorize("@ss.hasPermi('hosp:project:export')")
    //@PreAuthorize("@ss.hasPermi('hosp:project:export')")
    @Log(title = "体检项目", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    @ApiOperation(value = "导出体检项目列表")
@@ -138,7 +161,7 @@
    /**
     * 获取体检项目详细信息
     */
    @PreAuthorize("@ss.hasPermi('hosp:project:query')")
    //@PreAuthorize("@ss.hasPermi('hosp:project:query')")
    @GetMapping(value = "/{proId}")
    @ApiOperation(value = "获取体检项目详细信息")
    public AjaxResult getInfo(@PathVariable("proId") @ApiParam(value = "体检项目id") Long proId) {
@@ -174,7 +197,7 @@
    /**
     * 新增体检项目
     */
    @PreAuthorize("@ss.hasPermi('hosp:project:add')")
    //@PreAuthorize("@ss.hasPermi('hosp:project:add')")
    @ApiOperation(value = "新增体检项目")
    @Log(title = "体检项目", businessType = BusinessType.INSERT)
    @PostMapping
@@ -245,7 +268,7 @@
    /**
     * 修改体检项目
     */
    @PreAuthorize("@ss.hasPermi('hosp:project:edit')")
    //@PreAuthorize("@ss.hasPermi('hosp:project:edit')")
    @Log(title = "体检项目", businessType = BusinessType.UPDATE)
    @PutMapping
    @ApiOperation(value = "修改体检项目")
@@ -344,7 +367,7 @@
    /**
     * 删除体检项目
     */
    @PreAuthorize("@ss.hasPermi('hosp:project:remove')")
    // @PreAuthorize("@ss.hasPermi('hosp:project:remove')")
    @Log(title = "体检项目", businessType = BusinessType.DELETE)
    @DeleteMapping("/{proIds}")
    @ApiOperation(value = "删除体检项目(可删除父项目和子项目)")