| | |
| | | //20230323判断项目已检 |
| | | wq.ne(TjOrderDetail::getTjStatus, 0); |
| | | wq.ne(TjOrderDetail::getProId,projectService.getHuaYanProId()); |
| | | wq.eq(TjOrderDetail::getProId,projectService.getNotCcCtXdtProId()); |
| | | List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.list(wq); |
| | | |
| | | //遍历体检记录 将项目的具体信息 |
| | |
| | | LambdaQueryWrapper<TjOrderRemark> wqq = new LambdaQueryWrapper<>(); |
| | | wqq.eq(TjOrderRemark::getTjNumber, tjNumber); |
| | | wqq.ne(TjOrderRemark::getDeptId,"241"); |
| | | wqq.in(TjOrderRemark::getDeptId,"269","270","253","254","255","257"); |
| | | List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.list(wqq); |
| | | |
| | | for (TjOrderRemark tjOrderRemark : tjOrderRemarks) { |
| | |
| | | |
| | | |
| | | List<Long> getHuaYanKsProId(String ksId); |
| | | |
| | | |
| | | @Select("SELECT a.pro_id FROM tj_project a JOIN sys_dept b ON a.dept_id=b.dept_id WHERE a.deleted=0 AND b.dept_id in(269,270,253,254,255,257) AND a.need_report='Y'") |
| | | List<Long> getNotCcCtXdtProId(); |
| | | } |
| | |
| | | |
| | | List<Long> getHuaYanKsProId(String ksId); |
| | | |
| | | List<Long> getNotCcCtXdtProId(); |
| | | |
| | | |
| | | } |
| | |
| | | return tjProjectMapper.getHuaYanKsProId(ksId); |
| | | } |
| | | |
| | | @Override |
| | | public List<Long> getNotCcCtXdtProId() { |
| | | return tjProjectMapper.getNotCcCtXdtProId(); |
| | | } |
| | | |
| | | /** |
| | | * 递归列表 |
| | | */ |