| | |
| | | page.setCurrent(homeGoodsSkuDTO.getPageCurr()); |
| | | |
| | | LambdaQueryWrapper<GoodsSku> wrapper3= Wrappers.lambdaQuery(); |
| | | wrapper3.eq(GoodsSku::getDelFlag,0); |
| | | wrapper3.eq(GoodsSku::getListingStatus,0); |
| | | // if(homeGoodsSkuDTO.getId()!=null){ |
| | | // List arr=new ArrayList<>(); |
| | |
| | | if (homeGoodsSkuDTO.getSort()==1){ |
| | | wrapper3.last(" ORDER BY IF(isnull(sort_num),1,0), sort_num DESC,create_time DESC"); |
| | | }else{ |
| | | wrapper3.last(",IF(isnull(sort_num),1,0), sort_num DESC,create_time DESC"); |
| | | wrapper3.last("IF(isnull(sort_num),1,0), sort_num DESC,create_time DESC"); |
| | | } |
| | | |
| | | |