| | |
| | | String reagentId = selectedOpeWarehouseReserve.getReagentId(); |
| | | String articleNumber = selectedOpeWarehouseReserve.getArticleNumber(); |
| | | |
| | | this.setReagentStatusSelectList(opeReagentStatusService.getOpeReagentStatusList(reagentId, articleNumber, |
| | | this.setReagentStatusSelectList(opeReagentStatusService.getOpeReagentStatusList22(reagentId, articleNumber, |
| | | ArrivalStatus.WAREHOUSE.getKey(), reagentCode, null, null, null)); |
| | | |
| | | // System.out.print("this.getReagentStatusSelectList().size(): " + this.reagentStatusSelectList.size()); |
| | |
| | | System.out.println(reagentId); |
| | | System.out.println(articleNumber); |
| | | System.out.println(reagentCode); |
| | | this.setReagentStatusSelectListForPerson(opeReagentStatusService.getOpeReagentStatusList(reagentId, articleNumber, |
| | | this.setReagentStatusSelectListForPerson(opeReagentStatusService.getOpeReagentStatusList22(reagentId, articleNumber, |
| | | ArrivalStatus.WAREHOUSE.getKey(), reagentCode, null, null, null)); |
| | | |
| | | } |
| | |
| | | |
| | | @SuppressWarnings("rawtypes") |
| | | List<OpeReagentStatus> getOpeReagentStatusList(Map params) throws DataAccessException; |
| | | List<OpeReagentStatus> getOpeReagentStatusList22(Map params) throws DataAccessException; |
| | | |
| | | |
| | | @SuppressWarnings("rawtypes") |
| | | int getOpeReagentStatusTotalCount(Map params) throws DataAccessException; |
| | | |
| | |
| | | <if test="status != null"> |
| | | <choose> |
| | | <when test="status == 1"> |
| | | inner join sys_warehouse as sw on sw.id = oa.house_id |
| | | left join sys_warehouse as sw on sw.id = oa.house_id |
| | | left join sys_warehouse_container as swc on swc.id = oa.container_id |
| | | </when> |
| | | <when test="status == 2"> |
| | | inner join sys_laboratory as sw on sw.id = oa.house_id |
| | | left join sys_laboratory as sw on sw.id = oa.house_id |
| | | left join sys_laboratory_container as swc on swc.id = oa.container_id |
| | | </when> |
| | | </choose> |
| | |
| | | </if> |
| | | </select> |
| | | |
| | | |
| | | <select id="getOpeReagentStatusList22" parameterType="java.util.Map" resultMap="OpeReagentStatus"> |
| | | <include refid="queryColumns"/> |
| | | from ope_reagent_status as oa |
| | | left join sys_reagent sr on oa.reagent_id = sr.id |
| | | left join sys_supplier as ss on sr.supplier_id = ss.id |
| | | left join sys_user as su on oa.user_id = su.id |
| | | |
| | | <if test="status != null"> |
| | | <choose> |
| | | <when test="status == 1"> |
| | | inner join sys_warehouse as sw on sw.id = oa.house_id |
| | | left join sys_warehouse_container as swc on swc.id = oa.container_id |
| | | </when> |
| | | <when test="status == 2"> |
| | | inner join sys_laboratory as sw on sw.id = oa.house_id |
| | | left join sys_laboratory_container as swc on swc.id = oa.container_id |
| | | </when> |
| | | </choose> |
| | | </if> |
| | | where oa.valid_flag = 1 |
| | | <include refid="queryWhereSql"/> |
| | | |
| | | order by oa.reagent_code asc |
| | | <if test="first != null and pageSize != null"> |
| | | limit #{first}, #{pageSize} |
| | | </if> |
| | | </select> |
| | | |
| | | <select id="getOpeReagentStatusListForLab" parameterType="java.util.Map" resultMap="OpeReagentStatus"> |
| | | select oa.*, |
| | | sr.*, |
| | |
| | | void exportLabStock2Excel(List<Map> list) throws Exception; |
| | | |
| | | OpeReagentStatus getStatus(String reagentId, String reagentCode); |
| | | |
| | | List<OpeReagentStatus> getOpeReagentStatusList22(String reagentId, String articleNumber, Integer status, |
| | | String reagentCode, String userId, Integer first, Integer pageSize); |
| | | } |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<OpeReagentStatus> getOpeReagentStatusList22(String reagentId, String articleNumber, Integer status, |
| | | String reagentCode, String userId, Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | |
| | | params.put("reagentId", reagentId); |
| | | params.put("articleNumber", articleNumber); |
| | | params.put("status", status); |
| | | addParamByUserId(userId, params); |
| | | if (StringUtils.isNotBlank(reagentCode)) { |
| | | params.put("reagentCode", "%" + reagentCode + "%"); |
| | | } |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | return this.opeReagentStatusDao.getOpeReagentStatusList22(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | | throw new BusinessException(ExceptionEnumCode.DB_ERR, |
| | | MessageUtil.getMessageByCode(ExceptionEnumCode.DB_ERR.getCode()), e); |
| | | } |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<OpeReagentStatus> getOpeReagentStatusListForLab(String name, String articleNumber, Integer status, |
| | | String reagentCode, String userId,String labName, Integer first, Integer pageSize) { |
| | | try { |