| | |
|---|
| | | import com.zy.asrs.entity.AdjDetl; |
|---|
| | | import com.zy.asrs.service.AdjDetlService; |
|---|
| | | import com.zy.common.web.BaseController; |
|---|
| | | import com.zy.system.entity.SaasLog; |
|---|
| | | import com.zy.system.service.SaasLogService; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.web.bind.annotation.*; |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | @Autowired |
|---|
| | | private AdjDetlService adjDetlService; |
|---|
| | | |
|---|
| | | @Autowired |
|---|
| | | private SaasLogService saasLogService; |
|---|
| | | |
|---|
| | | @RequestMapping(value = "/adjDetl/{id}/auth") |
|---|
| | | @ManagerAuth |
|---|
| | |
|---|
| | | @RequestParam(required = false)String orderByType, |
|---|
| | | @RequestParam(required = false)String condition, |
|---|
| | | @RequestParam Map<String, Object> param){ |
|---|
| | | //以前是立库库存调整接口，后改为平库调整接口 |
|---|
| | | excludeTrash(param); |
|---|
| | | EntityWrapper<AdjDetl> wrapper = new EntityWrapper<>(); |
|---|
| | | EntityWrapper<SaasLog> wrapper = new EntityWrapper<>(); |
|---|
| | | convert(param, wrapper); |
|---|
| | | allLike(AdjDetl.class, param.keySet(), wrapper, condition); |
|---|
| | | wrapper.eq("type",2); |
|---|
| | | allLike(SaasLog.class, param.keySet(), wrapper, condition); |
|---|
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} |
|---|
| | | return R.ok(adjDetlService.selectPage(new Page<>(curr, limit), wrapper)); |
|---|
| | | return R.ok(saasLogService.selectPage(new Page<>(curr, limit), wrapper)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ |
|---|
| | |
|---|
| | | } |
|---|
| | | ManLocDetl check = manLocDetlService.selectOne(new EntityWrapper<ManLocDetl>() |
|---|
| | | .eq("loc_no", targetNode.getUuid()) |
|---|
| | | .eq("matnr", source.getMatnr())); |
|---|
| | | .eq("matnr", source.getMatnr()) |
|---|
| | | .eq("batch",source.getBatch())); |
|---|
| | | if (check == null) { |
|---|
| | | manLocDetlService.delete(new EntityWrapper<ManLocDetl>().eq("loc_no", source.getLocNo()) |
|---|
| | | .eq("matnr", source.getMatnr())); |
|---|
| | | .eq("matnr", source.getMatnr()).eq("batch",source.getBatch())); |
|---|
| | | source.setLocNo(targetNode.getUuid()); |
|---|
| | | source.setNodeId(targetNode.getId()); |
|---|
| | | |
|---|
| | |
|---|
| | | <select id="queryViewInOutList" parameterType="com.zy.asrs.entity.ViewInOutBean" resultType="com.zy.asrs.entity.ViewInOutBean"> |
|---|
| | | select * from ( |
|---|
| | | select *,ROW_NUMBER() OVER(Order by ymd desc) as rowid |
|---|
| | | from asr_sta_inout_view |
|---|
| | | from man_loc_InOut_view |
|---|
| | | <where> |
|---|
| | | 1=1 |
|---|
| | | <include refid="viewInOutConditionSql"></include> |
|---|
| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="getViewInOutCount" parameterType="com.zy.asrs.entity.ViewInOutBean" resultType="Integer"> |
|---|
| | | select count(1) from asr_sta_inout_view a |
|---|
| | | select count(1) from man_loc_InOut_view a |
|---|
| | | <where> |
|---|
| | | <
