| | |
| | | @Override |
| | | public List<GoodsorderExportVO> findExportNotBikPage(Goodsorder model){ |
| | | List<GoodsorderExportVO> list = new ArrayList<>(); |
| | | model.setPayStatus(Constants.ONE); //只查询支付成功的 |
| | | MPJLambdaWrapper<Goodsorder> queryWrapper = initQueryParamByModel(model); |
| | | |
| | | List<Goodsorder> goodsorderList = goodsorderJoinMapper.selectJoinList(Goodsorder.class,queryWrapper); |
| | | if(goodsorderList!=null){ |
| | | for(Goodsorder order : goodsorderList){ |
| | | GoodsorderExportVO vo = new GoodsorderExportVO(); |
| | | vo.setId(order.getId()); |
| | | vo.setOpenid(order.getMemberName()); |
| | | vo.setOpenid(order.getMemberOpenid()); |
| | | vo.setPayDate(order.getPayDate()); |
| | | vo.setCloseDate(order.getCloseDate()); |
| | | vo.setCloseDate(order.getCloseDate()); |
| | |
| | | private MPJLambdaWrapper<Goodsorder> initQueryParamByModel(Goodsorder model) { |
| | | MPJLambdaWrapper<Goodsorder> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(model); |
| | | //只查询支付成功的 |
| | | model.setPayStatus(Constants.ONE); |
| | | |
| | | queryWrapper.selectAll(Goodsorder.class); |
| | | queryWrapper.selectAs(Member::getOpenid, Goodsorder::getMemberOpenid); |
| | | queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId); |