| | |
| | | |
| | | import com.consum.base.core.CodeGeneratorEnum; |
| | | import com.consum.base.core.CodeGeneratorService; |
| | | import com.consum.base.core.tools.MapRowMapper; |
| | | import com.consum.base.core.utils.IdUtil; |
| | | import com.consum.base.core.utils.MapRowMapper; |
| | | import com.consum.base.pojo.LWhFormTransferParam; |
| | | import com.consum.base.pojo.LWhProcureModelParams; |
| | | import com.consum.base.pojo.LWhProcureModelUserDTO; |
| | | import com.consum.base.pojo.query.TransferQryDto; |
| | | import com.consum.base.util.IdUtil; |
| | | import com.consum.base.pojo.query.TransferQry; |
| | | import com.consum.model.po.BaseGoodsModels; |
| | | import com.consum.model.po.BaseWarehouse; |
| | | import com.consum.model.po.FinSysTenant; |
| | |
| | | * @Author 卢庆阳 |
| | | * @Date 2023/10/30 |
| | | */ |
| | | public GenericPager<LWhFormTransfer> queryFormTransferList(TransferQryDto param) { |
| | | public GenericPager<LWhFormTransfer> queryFormTransferList(TransferQry param) { |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | StringBuilder sql = new StringBuilder(QUERY_FORM_TRANSFER_LIST); |
| | | //调拨单号 |
| | |
| | | paramts.put("createTimeEnd", param.getCreateTimeEnd() * 1000000 + 240000); |
| | | } |
| | | //接收时间 |
| | | if (param.getInTimeStart() != null) { |
| | | if (param.getStartTime() != null) { |
| | | sql.append(" and IN_TIME >=:inTimeStart "); |
| | | paramts.put("inTimeStart", param.getInTimeStart() * 1000000); |
| | | paramts.put("inTimeStart", param.getStartTime() * 1000000); |
| | | } |
| | | if (param.getInTimeEnd() != null) { |
| | | if (param.getEndTime() != null) { |
| | | sql.append(" and IN_TIME <:inTimeEnd "); |
| | | paramts.put("inTimeEnd", param.getInTimeEnd() * 1000000 + 240000); |
| | | paramts.put("inTimeEnd", param.getEndTime() * 1000000 + 240000); |
| | | } |
| | | |
| | | sql.append(" ORDER BY CREATE_TIME DESC"); |
| | |
| | | return this.update(lWhFormTransfer); |
| | | } |
| | | |
| | | public GenericPager<Map<String, Object>> queryTransferInfo(TransferQryDto transferQryDto) { |
| | | public GenericPager<Map<String, Object>> queryTransferInfo(TransferQry transferQry) { |
| | | |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | StringBuilder sql = new StringBuilder("SELECT\n" |
| | |
| | | + "\tLEFT JOIN fin_sys_tenant_department fstd ON fstu.SYS_DEPT_ID = fstd.ID \n" |
| | | + "\tLEFT JOIN fin_sys_tenant fst ON fst.id = fstd.TENANT_ID where 1=1 "); |
| | | //单号 |
| | | if (StringUtils.isNotEmpty(transferQryDto.getBusinessFormCode())) { |
| | | if (StringUtils.isNotEmpty(transferQry.getBusinessFormCode())) { |
| | | sql.append("AND BUSINESS_FORM_CODE like :businessFormCode "); |
| | | paramts.put("businessFormCode", StringUtils.CHAR_PERCENT + transferQryDto.getBusinessFormCode() + StringUtils.CHAR_PERCENT); |
| | | paramts.put("businessFormCode", StringUtils.CHAR_PERCENT + transferQry.getBusinessFormCode() + StringUtils.CHAR_PERCENT); |
| | | } |
| | | //物品名称 |
| | | if (StringUtils.isNotEmpty(transferQryDto.getGoodsTemplateName())) { |
| | | if (StringUtils.isNotEmpty(transferQry.getGoodsTemplateName())) { |
| | | sql.append("AND bgt.GOODS_NAME like:goodsName "); |
| | | paramts.put("goodsName", StringUtils.CHAR_PERCENT + transferQryDto.getGoodsTemplateName() + StringUtils.CHAR_PERCENT); |
| | | paramts.put("goodsName", StringUtils.CHAR_PERCENT + transferQry.getGoodsTemplateName() + StringUtils.CHAR_PERCENT); |
| | | } |
| | | // 规格型号 |
| | | if (transferQryDto.getBaseGoodsTemplateId() != null) { |
| | | if (transferQry.getBaseGoodsTemplateId() != null) { |
| | | sql.append("AND bgm.id =:goodsModelId "); |
| | | paramts.put("goodsModelId", transferQryDto.getBaseGoodsTemplateId()); |
| | | paramts.put("goodsModelId", transferQry.getBaseGoodsTemplateId()); |
| | | } |
| | | //调拨机构 |
| | | if (transferQryDto.getOutAgencyId() != null) { |
| | | if (transferQry.getOutAgencyId() != null) { |
| | | sql.append("AND OUT_AGENCY_ID = :OUT_AGENCY_ID "); |
| | | paramts.put("OUT_AGENCY_ID", transferQryDto.getOutAgencyId()); |
| | | paramts.put("OUT_AGENCY_ID", transferQry.getOutAgencyId()); |
| | | } |
| | | |
| | | //创建人 |
| | | if (StringUtils.isNotEmpty(transferQryDto.getOperatorName())) { |
| | | if (StringUtils.isNotEmpty(transferQry.getOperatorName())) { |
| | | sql.append("AND ft.OPERATOR_NAME =:OPERATOR_NAME "); |
| | | paramts.put("OPERATOR_NAME", transferQryDto.getOperatorName()); |
| | | paramts.put("OPERATOR_NAME", transferQry.getOperatorName()); |
| | | } |
| | | //申请时间 |
| | | if (transferQryDto.getCreateTimeStart() != null) { |
| | | if (transferQry.getCreateTimeStart() != null) { |
| | | sql.append("AND ft.CREATE_TIME >=:createTimeStart "); |
| | | paramts.put("createTimeStart", transferQryDto.getCreateTimeStart() * 1000000); |
| | | paramts.put("createTimeStart", transferQry.getCreateTimeStart() * 1000000); |
| | | } |
| | | if (transferQryDto.getCreateTimeEnd() != null) { |
| | | if (transferQry.getCreateTimeEnd() != null) { |
| | | sql.append("AND ft.CREATE_TIME <:createTimeEnd "); |
| | | paramts.put("createTimeEnd", transferQryDto.getCreateTimeEnd() * 1000000 + 240000); |
| | | paramts.put("createTimeEnd", transferQry.getCreateTimeEnd() * 1000000 + 240000); |
| | | } |
| | | sql.append("ORDER BY ft.CREATE_TIME DESC"); |
| | | |
| | | GenericPager<Map<String, Object>> mapGenericPager = this.selectSplit(sql.toString(), paramts, transferQryDto.getPageNum(), transferQryDto.getPageSize(), |
| | | GenericPager<Map<String, Object>> mapGenericPager = this.selectSplit(sql.toString(), paramts, transferQry.getPageNum(), transferQry.getPageSize(), |
| | | new MapRowMapper()); |
| | | |
| | | return mapGenericPager; |