| | |
|---|
| | | import com.core.annotations.ManagerAuth; |
|---|
| | | import com.core.common.*; |
|---|
| | | import com.core.exception.CoolException; |
|---|
| | | import com.sun.org.apache.xpath.internal.operations.Or; |
|---|
| | | import com.zy.asrs.entity.*; |
|---|
| | | import com.zy.asrs.entity.param.OrderDomainParam; |
|---|
| | | import com.zy.asrs.entity.result.OrderDetlVo; |
|---|
| | | import com.zy.asrs.service.*; |
|---|
| | | import com.zy.common.CodeRes; |
|---|
| | | import com.zy.common.model.DetlDto; |
|---|
| | |
|---|
| | | EntityWrapper<OrderDetl> locCheckEntityWrapper = new EntityWrapper<>(); |
|---|
| | | locCheckEntityWrapper.eq("order_no",orderNo); |
|---|
| | | List<OrderDetl> list = orderDetlService.selectList(locCheckEntityWrapper); |
|---|
| | | |
|---|
| | | List<OrderDetlVo> orderDetlVos=new ArrayList<>(); |
|---|
| | | OrderDetlVo orderDetlVo=new OrderDetlVo(); |
|---|
| | | for (OrderDetl o: |
|---|
| | | list) { |
|---|
| | | orderDetlVo.setOrderNo(o.getOrderNo()); |
|---|
| | | orderDetlVo.setMatnr(o.getMatnr()); |
|---|
| | | orderDetlVo.setMaktx(o.getMaktx()); |
|---|
| | | orderDetlVo.setSpecs(o.getSpecs()); |
|---|
| | | orderDetlVo.setOwner(o.getOwner$()); |
|---|
| | | orderDetlVo.setPayment(o.getPayment$()); |
|---|
| | | orderDetlVo.setAnfme(o.getAnfme()); |
|---|
| | | orderDetlVo.setQty(o.getQty()); |
|---|
| | | orderDetlVo.setWorkQty(o.getWorkQty()); |
|---|
| | | orderDetlVo.setWeight(o.getWeight()); |
|---|
| | | orderDetlVos.add(orderDetlVo); |
|---|
| | | } |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding("utf-8"); |
|---|
| | | String fileName = URLEncoder.encode("单据", "UTF-8"); |
|---|
| | |
|---|
| | | includeColumnFiledNames.add("qty"); |
|---|
| | | includeColumnFiledNames.add("workQty"); |
|---|
| | | includeColumnFiledNames.add("weight"); |
|---|
| | | EasyExcel.write(response.getOutputStream(), OrderDetl.class) |
|---|
| | | EasyExcel.write(response.getOutputStream(), OrderDetlVo.class) |
|---|
| | | .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
|---|
| | | .includeColumnFiledNames(includeColumnFiledNames) |
|---|
| | | .sheet("表1") |
|---|
| | | .doWrite(list); |
|---|
| | | .doWrite(orderDetlVos); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RequestMapping(value = "/order/list/all") |
|---|
| | | public R orderList() { |
|---|
| | | |
|---|
| | | return R.ok(orderService.selectAllorderNo()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //订单组托2 |
|---|
| | | @RequestMapping(value = "/order/list/orderNo") |
|---|
| | | public R orderListorderNo(@RequestParam String orderNo) { |
|---|
| | | //数量修改成为完成数量 |
|---|
| | | List<OrderDetl> orderDetl1=orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo)); |
|---|
| | | List<OrderDetl> orderDetls= new ArrayList<OrderDetl>(); |
|---|
| | | for (OrderDetl o: orderDetl1) { |
|---|
| | | o.setAnfme(o.getAnfme()-o.getWorkQty()); |
|---|
| | | orderDetls.add(o); |
|---|
| | | } |
|---|
| | | return R.ok(orderDetls); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
