| | |
| | | package com.doumee.service.business.impl; |
| | | |
| | | import com.doumee.biz.system.SystemDictDataBiz; |
| | | import com.doumee.core.model.PageData; |
| | | import com.doumee.core.model.PageWrap; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.business.CategorySegMapper; |
| | | import com.doumee.dao.business.model.CategorySeg; |
| | | import com.doumee.dao.business.model.Segments; |
| | | import com.doumee.dao.business.vo.UnitCodeVo; |
| | | import com.doumee.service.business.CategorySegService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | |
| | | @Service |
| | | public class CategorySegServiceImpl implements CategorySegService { |
| | | |
| | | @Autowired |
| | | private SystemDictDataBiz systemDictDataBiz; |
| | | @Autowired |
| | | private CategorySegMapper categorySegMapper; |
| | | |
| | |
| | | public PageData<CategorySeg> findPage(PageWrap<CategorySeg> pageWrap) { |
| | | IPage<CategorySeg> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<CategorySeg> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.select("category_seg.*," + |
| | | "(select b.name from shop b where b.code = category_seg.scode limit 1 ) as sname," + |
| | | "(select b.name from shop b where b.code = category_seg.org_id limit 1 ) as orgName"); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | if (pageWrap.getModel().getId() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getId, pageWrap.getModel().getId()); |
| | |
| | | queryWrapper.lambda().eq(CategorySeg::getSegId3, pageWrap.getModel().getSegId3()); |
| | | } |
| | | if (pageWrap.getModel().getSegName() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getSegName, pageWrap.getModel().getSegName()); |
| | | queryWrapper.lambda().like(CategorySeg::getSegName, pageWrap.getModel().getSegName()); |
| | | } |
| | | if (pageWrap.getModel().getSegName2() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getSegName2, pageWrap.getModel().getSegName2()); |
| | | queryWrapper.lambda().like(CategorySeg::getSegName2, pageWrap.getModel().getSegName2()); |
| | | } |
| | | if (pageWrap.getModel().getSegName3() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getSegName3, pageWrap.getModel().getSegName3()); |
| | | queryWrapper.lambda().like(CategorySeg::getSegName3, pageWrap.getModel().getSegName3()); |
| | | } |
| | | if (pageWrap.getModel().getSyncDate() != null) { |
| | | queryWrapper.lambda().ge(CategorySeg::getSyncDate, Utils.Date.getStart(pageWrap.getModel().getSyncDate())); |
| | |
| | | queryWrapper.lambda().eq(CategorySeg::getShipToAddress, pageWrap.getModel().getShipToAddress()); |
| | | } |
| | | if (pageWrap.getModel().getShipToPerson() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getShipToPerson, pageWrap.getModel().getShipToPerson()); |
| | | queryWrapper.lambda().like(CategorySeg::getShipToPerson, pageWrap.getModel().getShipToPerson()); |
| | | } |
| | | if (pageWrap.getModel().getShipToPhone() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getShipToPhone, pageWrap.getModel().getShipToPhone()); |
| | | queryWrapper.lambda().like(CategorySeg::getShipToPhone, pageWrap.getModel().getShipToPhone()); |
| | | } |
| | | if (pageWrap.getModel().getScode() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getScode, pageWrap.getModel().getScode()); |
| | | } |
| | | if (pageWrap.getModel().getOrgId() != null) { |
| | | queryWrapper.lambda().eq(CategorySeg::getOrgId, pageWrap.getModel().getOrgId()); |
| | | } |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
| | |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | } |
| | | } |
| | | return PageData.from(categorySegMapper.selectPage(page, queryWrapper)); |
| | | queryWrapper.lambda().orderByAsc(CategorySeg::getScode); |
| | | PageData<CategorySeg> pagedata =PageData.from(categorySegMapper.selectPage(page, queryWrapper)); |
| | | if(pagedata!=null && pagedata.getRecords()!=null && pagedata.getRecords().size()>0){ |
| | | List<UnitCodeVo> unitCodeVoList =systemDictDataBiz.getUnitList(); |
| | | for(CategorySeg model : pagedata.getRecords()){ |
| | | model.setUnitName(systemDictDataBiz.getUnitName(model.getUnitCode(),unitCodeVoList)); |
| | | } |
| | | |
| | | } |
| | | return pagedata; |
| | | } |
| | | |
| | | @Override |