| | |
| | | .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.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); |
| | | } |