From fad63be580dc8ddef06b9f502e4551227e14d438 Mon Sep 17 00:00:00 2001 From: 张磊磊 <201175954@qq.com> Date: 星期五, 24 十一月 2023 13:41:26 +0800 Subject: [PATCH] 苏州地磅数据加工入库 --- hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 47 insertions(+), 6 deletions(-) diff --git a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java index 47fc2ef..cc10f59 100644 --- a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java +++ b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java @@ -4,6 +4,7 @@ import com.github.pagehelper.PageInfo; import com.thhy.general.common.BasicResult; import com.thhy.general.config.SysUserInfo; +import com.thhy.general.utils.ExcelUtils; import com.thhy.general.utils.UUIDUtils; import com.thhy.general.utils.UserInfoUtils; import com.thhy.secure.modules.biz.hiddenDanger.entity.HiddenDangerEntity; @@ -13,6 +14,8 @@ import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import javax.servlet.http.HttpServletResponse; +import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Map; @@ -86,8 +89,19 @@ map.put("companyId",sysUserInfo.getCompanyId()); int pageNum = (int) map.get("pageNum"); int pageSize = (int) map.get("pageSize"); + int type = 0; + if( map.get("type")!= null){ + type = (int) map.get("type");//type =1 小程序来的 + } PageHelper.startPage(pageNum,pageSize); - List<HiddenDangerEntity> hiddenDangerEntities = hiddenDangerMapper.selectPageList(map); + List<HiddenDangerEntity> hiddenDangerEntities = new ArrayList<>(); + if(type == 1){ + //小程序 待审核排前面 待审核按时间正序 审核成功的倒叙 + hiddenDangerEntities = hiddenDangerMapper.selectAppList(map); + }else { + //web 按时间倒序 + hiddenDangerEntities = hiddenDangerMapper.selectPageList(map); + } hiddenDangerEntities.forEach(obj ->{ String id = obj.getId(); obj.setImgEntities(hiddenDangerMapper.selectImgList(id)); @@ -96,24 +110,51 @@ } @Override - public BasicResult selectNoPageList(Map<String, Object> map) { + public void export(Map<String, Object> map, HttpServletResponse response) { SysUserInfo sysUserInfo = UserInfoUtils.getInstance().getUserInfo(); map.put("companyId",sysUserInfo.getCompanyId()); List<HiddenDangerEntity> hiddenDangerEntities = hiddenDangerMapper.selectPageList(map); hiddenDangerEntities.forEach(obj ->{ - String id = obj.getId(); - obj.setImgEntities(hiddenDangerMapper.selectImgList(id)); + Integer auditStatus = obj.getAuditStatus(); + Integer level = obj.getLevel(); + switch (auditStatus){ + case 0: + obj.setAuditStatusName("未审核"); + break; + case 1: + obj.setAuditStatusName("已审核"); + break; + case 2: + obj.setAuditStatusName("审核失败"); + break; + } + if (level != null){ + switch (level){ + case 1: + obj.setLevelName("一般隐患"); + break; + case 2: + obj.setLevelName("重大隐患"); + break; + case 3: + obj.setLevelName("不存在"); + break; + } + } }); - return BasicResult.success(hiddenDangerEntities); + ExcelUtils.downExcel(hiddenDangerEntities,HiddenDangerEntity.class,response,"隐患举报"); } @Override public BasicResult selectInfo(String id) { - return BasicResult.success(hiddenDangerMapper.selectInfo(id)); + HiddenDangerEntity hiddenDangerEntity = hiddenDangerMapper.selectInfo(id); + hiddenDangerEntity.setImgEntities(hiddenDangerMapper.selectImgList(id)); + return BasicResult.success(hiddenDangerEntity); } @Override public BasicResult examine(HiddenDangerEntity hiddenDangerEntity) { + hiddenDangerEntity.setAuditStatus(1);//1审核通过 hiddenDangerMapper.update(hiddenDangerEntity); return BasicResult.success(); } -- Gitblit v1.9.3