路泰科技体检后端
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zhaowenxuan
2024-12-07 27c04611f66074cb501de1fd7b1d617138dea4a4 
 ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java


@@ -10,16 +10,14 @@


import com.ltkj.common.enums.DataSourceType;


import com.ltkj.framework.config.UserHoder;


import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;


import com.ltkj.hosp.domain.TjCustomer;


import com.ltkj.hosp.domain.TjOrder;


import com.ltkj.hosp.domain.TjOrderRemark;


import com.ltkj.hosp.domain.TjProject;


import com.ltkj.hosp.domain.*;


import com.ltkj.hosp.service.*;


import com.ltkj.hosp.sqlDomain.*;


import com.ltkj.hosp.mapper.TestMapper;


import com.ltkj.system.service.ISysDeptService;


import io.swagger.annotations.Api;


import io.swagger.annotations.ApiOperation;


import io.swagger.annotations.ApiParam;


import org.checkerframework.checker.units.qual.A;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.data.redis.core.ConvertingCursor;


@@ -30,12 +28,12 @@


import org.springframework.web.bind.annotation.*;




import javax.annotation.Resource;


import javax.servlet.http.HttpServletRequest;


import javax.servlet.http.HttpSession;


import java.sql.ResultSet;


import java.sql.SQLException;


import java.util.ArrayList;


import java.util.HashMap;


import java.util.List;


import java.util.Map;


import java.util.*;


import java.util.stream.Collectors;




import static com.ltkj.framework.datasource.DynamicDataSourceContextHolder.log;


import static org.apache.poi.hemf.record.emfplus.HemfPlusRecordType.save;


@@ -82,6 +80,11 @@


    private LtkjHisUserService hisUserService;


    @Resource


    private ITjProjectService tjProjectService;


    @Autowired


    private ITjOrderDetailService tjOrderDetailService;


    @Resource


    private ITjOrderRemarkService tjOrderRemarkService;






    @GetMapping("/getTjHyBgList")


    @ApiOperation(value = "查询lis数据库项目信息接口")


@@ -95,13 +98,18 @@






    @GetMapping("/newGetTjPat")


    @ApiOperation(value = "新的查询体检信息接口")


    @ApiOperation(value = "A------新的查询体检信息接口")


    public AjaxResult newGetTjPat(@RequestParam(required = false)String pacCode,


                                  @RequestParam(required = false)String pacName,


                                  @RequestParam(required = false)String pacRemark) {


//        List<Map<String, Object>> maps = testMapper.newGetTjPat111111(pacName);


        List<Map<String, Object>> maps = testMapper.newGetTjPat(pacCode,pacName,pacRemark);


        DynamicDataSourceContextHolder.clearDataSourceType();


        List<String> strings = orderService.selectTjOrderByCardId1();


        if(null !=strings && strings.size()>0){


            List<Map<String, Object>> collect = maps.stream()


                    .filter(item ->  !strings.contains(item.get("pacCode").toString())).collect(Collectors.toList());


            return AjaxResult.success(collect);


        }


        return AjaxResult.success(maps);


    }




@@ -404,7 +412,7 @@


                //同步化验项目


                testMapper.updateDetailByCall(order.getCardId(), String.valueOf(order.getOrderId()),order.getTjNumber(), "1");


                //同步检查项目


                testMapper.updateDetailByTjJcCall(order.getCardId(), String.valueOf(order.getOrderId()),order.getTjNumber(),"1");


//                testMapper.updateDetailByTjJcCall(order.getCardId(), String.valueOf(order.getOrderId()),order.getTjNumber(),"1");


            }


//        }


        return AjaxResult.success("同步成功");


@@ -439,4 +447,17 @@


    }






    @GetMapping("/getHuaYanProByTjNum")


    @ApiOperation(value = "根据体检号查询化验项目接口")


    public AjaxResult getHuaYanProByTjNum(@RequestParam @ApiParam(value = "体检号") String tjNumber) {


        Map<String,Object> map=new HashMap<>();




        List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.addHuaYanTable(tjNumber);


        List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.addHuaYanTable(tjNumber);


        map.put("tjOrderDetails",tjOrderDetails);


        map.put("tjOrderRemarks",tjOrderRemarks);


        return AjaxResult.success(map);


    }






}