| | |
| | | package com.consum.base.service; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import org.apache.commons.compress.utils.Lists; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.consum.base.core.WhBusinessEnum; |
| | | import com.consum.base.core.type.MixType; |
| | | import com.consum.base.core.utils.CurrencyUtil; |
| | | import com.consum.base.core.utils.MapRowMapper; |
| | | import com.consum.base.core.utils.MapUtils; |
| | | import com.consum.base.core.utils.MapperUtil; |
| | | import com.consum.base.core.utils.PageUtil; |
| | | import com.consum.base.core.utils.*; |
| | | import com.consum.base.pojo.LWarehouseFlowParam; |
| | | import com.consum.base.pojo.query.LWhFormOutputQry; |
| | | import com.consum.base.pojo.response.OutAndInDetailVO; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import org.apache.commons.compress.utils.Lists; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @ClassName LWarehouseFlowService |
| | |
| | | paramts.put("chuKuBusinessFormCode", businessFormCode); |
| | | sqlBaoFei.append(" and tScrapped.BUSINESS_FORM_CODE = :baoFeiBusinessFormCode"); |
| | | paramts.put("baoFeiBusinessFormCode", businessFormCode); |
| | | |
| | | sqlBaoFei.append(" and tDepScrapped.BUSINESS_FORM_CODE = :deptBaoFeiBusinessFormCode"); |
| | | sqlDepBaoFei.append(" and tDepScrapped.BUSINESS_FORM_CODE = :deptBaoFeiBusinessFormCode"); |
| | | paramts.put("deptBaoFeiBusinessFormCode", businessFormCode); |
| | | sqlBaoFei.append(" and tBack.BUSINESS_FORM_CODE = :deptBackBusinessFormCode"); |
| | | sqlDepTuiHui.append(" and tBack.BUSINESS_FORM_CODE = :deptBackBusinessFormCode"); |
| | | paramts.put("deptBackBusinessFormCode", businessFormCode); |
| | | |
| | | |
| | | sqlPanDian.append(" and tInventory.BUSINESS_FORM_CODE = :panDianBusinessFormCode"); |
| | | paramts.put("panDianBusinessFormCode", businessFormCode); |
| | | |
| | |
| | | .append(sqlChuKu) |
| | | .append(sqlBaoFei) |
| | | .append(sqlPanDian) |
| | | |
| | | .append(sqlDepBaoFei) |
| | | .append(sqlDepTuiHui) |
| | | .append(sqlEnd); |
| | | |
| | | return selectSplit(sql.toString(), paramts, param.getPageNum(), param.getPageSize(), new MapperUtil()); |