|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | import com.doumee.core.utils.Constants; | 
 |  |  | import com.doumee.dao.business.JkSketchMapper; | 
 |  |  | import com.doumee.dao.business.model.*; | 
 |  |  | import com.doumee.service.business.third.model.PageData; | 
 |  |  | import com.doumee.service.business.third.model.PageWrap; | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private JkSketchLineMapper jkSketchLineMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private JkSketchMapper jkSketchMapper; | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public Integer create(JkSketchLine jkSketchLine) { | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public List<JkSketchLine> findList(JkSketchLine jkSketchLine) { | 
 |  |  |    /*     if(jkSketchLine.getSketchId()!=null){ | 
 |  |  |             JkSketch sketch = jkSketchMapper.selectById(jkSketchLine.getSketchId()); | 
 |  |  |             if(sketch!=null){ | 
 |  |  |                 jkSketchLine.setType(Constants.formatIntegerNum(sketch.getOptStatus())); | 
 |  |  |             } | 
 |  |  |         }*/ | 
 |  |  |         MPJLambdaWrapper<JkSketchLine> wrapper = new MPJLambdaWrapper<>(); | 
 |  |  |         wrapper.selectAll(JkSketchLine.class ) | 
 |  |  |                 .selectAs(Member::getName,JkSketchLine::getMemberName) | 
 |  |  | 
 |  |  |                 .selectAs(JkLine::getName,JkSketchLine::getLineName) | 
 |  |  |                 .selectAs(Category::getId,JkSketchLine::getCategoryId) | 
 |  |  |                 .selectAs(Category::getName,JkSketchLine::getCategoryName) | 
 |  |  |                 .selectAs(JkLine::getMaxOrder,JkSketchLine::getMaxOrder) | 
 |  |  |                 .selectAs(JkLine::getMaxCustomer,JkSketchLine::getMaxCustomer) | 
 |  |  |                 .leftJoin(JkLine.class,JkLine::getId,JkOrders::getLineId ) | 
 |  |  |                 .leftJoin(Cars.class,Cars::getId,JkLine::getCarId ) | 
 |  |  |                 .leftJoin(Member.class,Member::getId,Cars::getMemberId ) | 
 |  |  |                 .leftJoin(Category.class,Category::getId,JkLine::getCategoryId ); | 
 |  |  |         wrapper.eq( jkSketchLine.getType()!=null,JkSketchLine::getType, jkSketchLine.getType()); | 
 |  |  |         wrapper.eq( jkSketchLine.getSketchId()!=null,JkSketchLine::getSketchId, jkSketchLine.getSketchId()) | 
 |  |  |                 .eq(  JkSketchLine::getIsdeleted,Constants.ZERO); | 
 |  |  |                 .eq(  JkSketchLine::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .orderByAsc(JkLine::getSortnum ); | 
 |  |  |  | 
 |  |  |         return jkSketchLineMapper.selectJoinList(JkSketchLine.class,wrapper); | 
 |  |  |     } | 
 |  |  |    | 
 |  |  |     @Override | 
 |  |  |     public PageData<JkSketchLine> findPage(PageWrap<JkSketchLine> pageWrap) { | 
 |  |  |         if(pageWrap.getModel().getSketchId()!=null){ | 
 |  |  |             JkSketch sketch = jkSketchMapper.selectById(pageWrap.getModel().getSketchId()); | 
 |  |  |             if(sketch!=null){ | 
 |  |  |                 pageWrap.getModel().setType(Constants.formatIntegerNum(sketch.getOptStatus())); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         IPage<JkSketchLine> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); | 
 |  |  |         QueryWrapper<JkSketchLine> queryWrapper = new QueryWrapper<>(); | 
 |  |  |         Utils.MP.blankToNull(pageWrap.getModel()); | 
 |  |  |         if (pageWrap.getModel().getId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(JkSketchLine::getId, pageWrap.getModel().getId()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCreator() != null) { | 
 |  |  |             queryWrapper.lambda().eq(JkSketchLine::getCreator, pageWrap.getModel().getCreator()); | 
 |  |  |         if (pageWrap.getModel().getType() != null) { | 
 |  |  |             queryWrapper.lambda().eq(JkSketchLine::getType, pageWrap.getModel().getType()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCreateDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(JkSketchLine::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); |