| | |
|---|
| | | import java.util.Map; |
|---|
| | | import java.util.Set; |
|---|
| | | |
|---|
| | | import javax.annotation.Resource; |
|---|
| | | |
|---|
| | | import jakarta.annotation.Resource; |
|---|
| | | import org.apache.commons.compress.utils.Lists; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | |
|---|
| | | + "LEFT JOIN l_wh_procure_model pm ON pm.FROM_PROCURE_GOODS_ID = fpg.id WHERE pm.BUSINESS_TYPE = 1 "); |
|---|
| | | // 只查询本机构的采购单 |
|---|
| | | if (param.getAgencyId() != null) { |
|---|
| | | sql.append("and fp.AGENCY_ID like :agencyId "); |
|---|
| | | paramts.put("agencyId", param.getAgencyId()); |
|---|
| | | sql.append("and AGENCY_ID like :agencyId "); |
|---|
| | | paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 入库单号 |
|---|
