From 86d65e6f837ff14b090ffc3312c013987b6f67d8 Mon Sep 17 00:00:00 2001
From: zqy <2522236926@qq.com>
Date: 星期二, 14 十月 2025 21:59:13 +0800
Subject: [PATCH] 荣誉 新增两个字段的查询
---
zhang-content/src/main/java/com/ruoyi/service/impl/ZHonorServiceImpl.java | 174 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 174 insertions(+), 0 deletions(-)
diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZHonorServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZHonorServiceImpl.java
index 14879b6..a32b41f 100644
--- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZHonorServiceImpl.java
+++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZHonorServiceImpl.java
@@ -1,11 +1,32 @@
package com.ruoyi.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.common.utils.MapUtils;
+import com.ruoyi.common.utils.SecurityUtils;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.domain.ZHonor;
+import com.ruoyi.domain.ZInfoUser;
+import com.ruoyi.domain.ZSecret;
import com.ruoyi.mapper.ZHonorMapper;
import com.ruoyi.service.ZHonorService;
+import com.ruoyi.service.ZInfoUserService;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
+
+import javax.annotation.Resource;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.HashMap;
+import java.util.List;
+import java.util.stream.Collectors;
/**
* <p>
@@ -18,4 +39,157 @@
@Service
public class ZHonorServiceImpl extends ServiceImpl<ZHonorMapper, ZHonor> implements ZHonorService {
+ @Autowired
+ ZHonorServiceImpl zHonorService;
+
+ @Autowired
+ ZInfoUserService zInfoUserService;
+ @Resource
+ ZHonorMapper zHonorMapper;
+
+ private LambdaQueryWrapper<ZHonor> uniqueCondition(ZHonor zHonor){
+ LambdaQueryWrapper<ZHonor> lqw = new LambdaQueryWrapper<>();
+ lqw.eq(StringUtils.isNotEmpty(zHonor.getName()),ZHonor::getName,zHonor.getName())
+ .eq(zHonor.getType()!=null,ZHonor::getType,zHonor.getType())
+ .eq(StringUtils.isNotEmpty(zHonor.getIdNo()),ZHonor::getIdNo,zHonor.getIdNo())
+ .eq(StringUtils.isNotEmpty(zHonor.getGrade()),ZHonor::getGrade,zHonor.getGrade())
+ .eq(zHonor.getValidityDate()!=null,ZHonor::getValidityDate,zHonor.getValidityDate())
+ .eq(zHonor.getGetDate()!=null,ZHonor::getGetDate,zHonor.getGetDate())
+ .eq(StringUtils.isNotEmpty(zHonor.getLocation()),ZHonor::getLocation,zHonor.getLocation())
+ .eq(StringUtils.isNotEmpty(zHonor.getRemark()),ZHonor::getRemark,zHonor.getRemark())
+ .eq(zHonor.getUserId()!=null,ZHonor::getUserId,zHonor.getUserId());
+ return lqw;
+ }
+
+ private LambdaQueryWrapper<ZHonor> buildCondition(ZHonor zHonor,Long userId){
+ LambdaQueryWrapper<ZHonor> lqw = new LambdaQueryWrapper<>();
+ lqw.eq(StringUtils.isNotEmpty(zHonor.getName()),ZHonor::getName,zHonor.getName())
+ .eq(ZHonor::getUserId,userId)
+ .like(zHonor.getType()!=null,ZHonor::getType,zHonor.getType())
+ .like(StringUtils.isNotEmpty(zHonor.getIdNo()),ZHonor::getIdNo,zHonor.getIdNo())
+ .like(StringUtils.isNotEmpty(zHonor.getGrade()),ZHonor::getGrade,zHonor.getGrade())
+ .like(StringUtils.isNotEmpty(zHonor.getLocation()),ZHonor::getLocation,zHonor.getLocation())
+ .like(StringUtils.isNotEmpty(zHonor.getRemark()),ZHonor::getRemark,zHonor.getRemark())
+ .eq(zHonor.getGetDate() !=null,ZHonor::getGetDate,zHonor.getGetDate())
+ .eq(zHonor.getValidityDate() !=null,ZHonor::getValidityDate,zHonor.getValidityDate())
+ .orderByDesc(ZHonor::getCreateTime);
+ return lqw;
+ }
+ private LambdaQueryWrapper<ZHonor> buildConditionSec(ZHonor zHonor,List<Long> userIds){
+ LambdaQueryWrapper<ZHonor> lqw = new LambdaQueryWrapper<>();
+
+ lqw.in(ZHonor::getUserId, userIds)
+ .eq(StringUtils.isNotEmpty(zHonor.getName()),ZHonor::getName,zHonor.getName())
+ .like(zHonor.getType()!=null,ZHonor::getType,zHonor.getType())
+ .like(StringUtils.isNotEmpty(zHonor.getIdNo()),ZHonor::getIdNo,zHonor.getIdNo())
+ .like(StringUtils.isNotEmpty(zHonor.getGrade()),ZHonor::getGrade,zHonor.getGrade())
+ .like(StringUtils.isNotEmpty(zHonor.getLocation()),ZHonor::getLocation,zHonor.getLocation())
+ .like(StringUtils.isNotEmpty(zHonor.getRemark()),ZHonor::getRemark,zHonor.getRemark())
+ .eq(zHonor.getGetDate() !=null,ZHonor::getGetDate,zHonor.getGetDate())
+ .eq(zHonor.getValidityDate() !=null,ZHonor::getValidityDate,zHonor.getValidityDate())
+ .orderByDesc(ZHonor::getCreateTime);
+ return lqw;
+ }
+ /**
+ * 鍒嗛〉鏌ユ壘
+ */
+ @Override
+ public AjaxResult selectDataList(ZHonor zHonor,Integer pageNum,Integer pageSize) {
+ SysUser user = SecurityUtils.getLoginUser().getUser();
+ Long userId = user.getUserId();
+
+
+
+ //鏍规嵁userId鏌ヨ鍒癷nfouser鐨剈aid
+ ZInfoUser zInfoUser = zInfoUserService.getInfoBysysId(userId);
+ //鎷垮埌鎵�鏈夌殑sysid
+ List<Long> fms = zInfoUserService.findByUaidToFaid(zInfoUser.getUaid()).stream().map(ZInfoUser::getSysId).collect(Collectors.toList());
+ LambdaQueryWrapper<ZHonor> lqw;
+ if(!fms.isEmpty())
+ lqw = buildConditionSec(zHonor, fms);
+ else
+ lqw = buildCondition(zHonor, userId);
+
+ // LambdaQueryWrapper<ZHonor> lqw = buildCondition(zHonor, userId);
+
+ Page<ZHonor> pageBean = new Page<>(pageNum, pageSize);
+ Page<ZHonor> pageResult = page(pageBean, lqw);
+
+ List<ZHonor> beanRecords = pageResult.getRecords();//寰楀埌鏌ヨ鍑烘潵鐨勬暟鎹�
+
+ HashMap<String, Object> data = MapUtils.getResult(pageResult, beanRecords);
+ return AjaxResult.success(data);
+
+ }
+
+ @Override
+ public List<ZHonor> selectCondition(ZHonor zHonor) {
+ SysUser user = SecurityUtils.getLoginUser().getUser();
+ Long userId = user.getUserId();
+ LambdaQueryWrapper<ZHonor> lqw = buildCondition(zHonor, userId);
+ return list(lqw);
+ }
+
+ @Override
+ public List<ZHonor> selectByIds(Long[] ids) {
+ List<ZHonor> list = new ArrayList<>();
+ if(!(ids==null||ids.length==0))
+ list = listByIds(Arrays.asList(ids));
+ else
+ list = list();
+ return list;
+ }
+
+ @Override
+ public AjaxResult listType() {
+ List<String> result = zHonorMapper.listType();
+ return AjaxResult.success(result);
+ }
+
+ @Override
+ public AjaxResult mySave(ZHonor zHonor) {
+ SysUser user = SecurityUtils.getLoginUser().getUser();
+ Long userId = user.getUserId();
+ zHonor.setUserId(userId);
+
+ //妫�鏌ユ槸鍚︽湁閲嶅鏁版嵁鎻掑叆
+ LambdaQueryWrapper<ZHonor> lqw = uniqueCondition(zHonor);
+ List<ZHonor> list = list(lqw);
+ if(list.size()>0){
+ throw new RuntimeException("璇峰嬁鏂板閲嶅鏁版嵁");
+ }
+
+ if (save(zHonor)) {
+ return AjaxResult.success();
+ }else {
+ return AjaxResult.error();
+ }
+
+ }
+
+ @Override
+ @Transactional
+ public AjaxResult importExcel(MultipartFile file) {
+
+ ExcelUtil<ZHonor> util = new ExcelUtil<>(ZHonor.class);
+ List<ZHonor> dataList = null;
+ try {
+ dataList = util.importExcel(file.getInputStream());
+ } catch (Exception e) {
+ throw new RuntimeException("娌℃湁鎸夌収瑙勫垯瀵煎叆鏁版嵁");
+ }
+
+ assert dataList != null;
+
+ for (ZHonor zHonor : dataList) {
+ zHonorService.mySave(zHonor);
+ }
+
+ return AjaxResult.success();
+
+ }
+
+
+
+
}
--
Gitblit v1.9.1