From 1140f80aefef30b543c99aaed47bcbca731b24e2 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期五, 08 十二月 2023 18:21:40 +0800 Subject: [PATCH] 海康接口对接开发 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ProblemsServiceImpl.java | 44 ++++++++++++++++++++++++++++++++++++-------- 1 files changed, 36 insertions(+), 8 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ProblemsServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ProblemsServiceImpl.java index f039e1e..836e413 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ProblemsServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ProblemsServiceImpl.java @@ -2,18 +2,22 @@ import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; +import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.business.ProblemsMapper; import com.doumee.dao.business.model.Problems; +import com.doumee.dao.web.response.ProblemsVO; import com.doumee.service.business.ProblemsService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; +import java.util.ArrayList; import java.util.List; /** @@ -83,7 +87,7 @@ QueryWrapper<Problems> wrapper = new QueryWrapper<>(problems); return problemsMapper.selectList(wrapper); } - + @Override public PageData<Problems> findPage(PageWrap<Problems> pageWrap) { IPage<Problems> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); @@ -133,13 +137,8 @@ if (pageWrap.getModel().getUseType() != null) { queryWrapper.lambda().eq(Problems::getUseType, pageWrap.getModel().getUseType()); } - for(PageWrap.SortData sortData: pageWrap.getSorts()) { - if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { - queryWrapper.orderByDesc(sortData.getProperty()); - } else { - queryWrapper.orderByAsc(sortData.getProperty()); - } - } + queryWrapper.lambda().orderByAsc(Problems::getCreateDate); + queryWrapper.select("problems.*, (select REALNAME from system_user where system_user.id = problems.CREATOR) as creatorName"); return PageData.from(problemsMapper.selectPage(page, queryWrapper)); } @@ -148,4 +147,33 @@ QueryWrapper<Problems> wrapper = new QueryWrapper<>(problems); return problemsMapper.selectCount(wrapper); } + + @Override + public List<Problems> findListByUseType(Integer useType) { + + return null; + } + + + /** + * 鑾峰彇棰樼洰淇℃伅 + * @param useType + * @return + */ + @Override + public List<ProblemsVO> getProblemsVO(Integer useType){ + List<Problems> problemsList = problemsMapper.selectList(new QueryWrapper<Problems>().lambda().eq(Problems::getUseType,useType) + .eq(Problems::getIsdeleted, Constants.ZERO).orderByAsc(Problems::getSortnu)); + List<ProblemsVO> problemsVOList = new ArrayList<>(); + for (Problems problems:problemsList) { + ProblemsVO problemsVO = new ProblemsVO(); + BeanUtils.copyProperties(problems,problemsVO); + problemsVOList.add(problemsVO); + } + return problemsVOList; + } + + + + } -- Gitblit v1.9.3