From cdd1ef49773e49dd91d19f9d02c82fb70e9f658c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 18 七月 2025 18:07:54 +0800
Subject: [PATCH] zjh20250718
---
ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java | 105 +++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 94 insertions(+), 11 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
index 493fd23..ec2858e 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
@@ -12,6 +12,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ltkj.common.annotation.Excel;
import com.ltkj.common.core.domain.entity.SysDept;
+import com.ltkj.common.utils.SecurityUtils;
import com.ltkj.common.utils.StringUtils;
import com.ltkj.common.utils.poi.ExcelUtil;
import com.ltkj.framework.config.UserHoder;
@@ -115,37 +116,80 @@
@GetMapping("/getKjTjAdviceKjbqBySex")
@ApiOperation(value = "鏍规嵁浣撴浜烘�у埆鍜屾槸鍚︿负鎬绘鏌ヨ浣撴寤鸿鎺ュ彛")
- public AjaxResult getKjTjAdviceKjbqBySex(@RequestParam String sex, @RequestParam @ApiParam(value = "1甯歌鍖荤敓 0鎬绘") String isZj,
+ public AjaxResult getKjTjAdviceKjbqBySex(@RequestParam @ApiParam(value = "1甯歌鍖荤敓 0鎬绘") String isZj,
+ @RequestParam(required = false) @ApiParam(value ="寤鸿鍐呭") String jynr,
+ @RequestParam(required = false) @ApiParam(value ="寤鸿鏍囬") String jybt,
@ApiParam(value = "椤电爜鏁�(榛樿1)") @RequestParam(defaultValue = "1") Integer page,
@ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize) {
LambdaQueryWrapper<TjAdvice> wq = new LambdaQueryWrapper<>();
Page<TjAdvice> page1 = new Page<>(page, pageSize);
- wq.eq(TjAdvice::getAdSex, sex).or().isNull(TjAdvice::getAdSex);
+// wq.eq(TjAdvice::getAdSex, sex).or().isNull(TjAdvice::getAdSex);
wq.eq(TjAdvice::getIsZj, isZj);
+ if(StringUtil.isNotBlank(jynr)) wq.like(TjAdvice::getAdvice,jynr);
+ if(StringUtil.isNotBlank(jybt)) wq.like(TjAdvice::getTitle,jybt);
+// wq.and(i -> i.eq(TjAdvice::getAdSex, sex).or().isNull(TjAdvice::getAdSex));
Page<TjAdvice> kjbqPage = tjAdviceService.page(page1, wq);
return AjaxResult.success(kjbqPage);
}
- @GetMapping("/getCyTjAdviceKjbqBySex")
+/* @GetMapping("/getCyTjAdviceKjbqBySex")
@ApiOperation(value = "鏍规嵁褰撳墠鐧诲綍浜篿d鑾峰彇甯哥敤寤鸿")
- public AjaxResult getCyTjAdviceKjbqBySex(@RequestParam String sex, @RequestParam @ApiParam(value = "鐢ㄦ埛id 浼犲綋鍓嶇櫥褰曚汉") Long userId,
+ public AjaxResult getCyTjAdviceKjbqBySex(@RequestParam(required = false) String sex, @RequestParam @ApiParam(value = "鐢ㄦ埛id 浼犲綋鍓嶇櫥褰曚汉") Long userId,
@ApiParam(value = "椤电爜鏁�(榛樿1)") @RequestParam(defaultValue = "1") Integer page,
@ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize) {
LambdaQueryWrapper<TjAdvice> wq = new LambdaQueryWrapper<>();
Page<TjAdvice> page1 = new Page<>(page, pageSize);
-// wq.eq(TjAdvice::getAdSex,sex).or().eq(TjAdvice::getAdSex,"2");
if (null != userId) {
LambdaQueryWrapper<TjUserAdvice> wq0 = new LambdaQueryWrapper<>();
wq0.eq(TjUserAdvice::getUserId, userId);
List<TjUserAdvice> list = userAdviceService.list(wq0);
- if (null != list && list.size() > 0) {
+ if (null != list && !list.isEmpty()) {
List<Long> longs = list.stream().map(TjUserAdvice::getAdviceId).collect(Collectors.toList());
wq.in(TjAdvice::getId,longs);
- wq.last("and (ad_sex=1 OR ad_sex=2)");
Page<TjAdvice> kjbqPage = tjAdviceService.page(page1,wq);
return AjaxResult.success(kjbqPage);
}
+ }
+ return AjaxResult.success("璇ョ敤鎴锋殏鏃舵病鏈夊父鐢ㄥ缓璁�!");
+ }*/
+
+
+ @GetMapping("/getCyTjAdviceKjbqBySex")
+ @ApiOperation(value = "鏍规嵁褰撳墠鐧诲綍浜篿d鑾峰彇甯哥敤寤鸿")
+ public AjaxResult getCyTjAdviceKjbqBySex( @RequestParam @ApiParam(value = "鐢ㄦ埛id 浼犲綋鍓嶇櫥褰曚汉") Long userId,
+ @ApiParam(value = "椤电爜鏁�(榛樿1)") @RequestParam(defaultValue = "1") Integer page,
+ @ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize,
+ @RequestParam(required = false) String nr) {
+ LambdaQueryWrapper<TjUserAdvice> wq0 = new LambdaQueryWrapper<>();
+ if(!SecurityUtils.isAdmin(userId))
+ wq0.eq(TjUserAdvice::getUserId, userId);
+ List<TjUserAdvice> list = userAdviceService.list(wq0);
+ List<TjAdvice> kjbqPage = new ArrayList<>();
+ Map<String,Object> map = new HashMap<>();
+ map.put("total", 0);
+ map.put("records", null);
+ if (null != list && !list.isEmpty()) {
+ for (TjUserAdvice advice : list) {
+ TjAdvice advice1 = tjAdviceService.getById(advice.getAdviceId());
+ if(null != advice1){
+ advice1.setUserName(userService.getById(advice.getUserId()).getNickName());
+ kjbqPage.add(advice1);
+ }
+ }
+ List<TjAdvice> adviceList =null;
+ if(StringUtil.isNotBlank( nr)){
+ adviceList = kjbqPage.stream().filter(kjbq -> StringUtil.isNotBlank(kjbq.getTitle()) && kjbq.getTitle().contains(nr)).collect(Collectors.toList());
+ List<TjAdvice> tjAdviceList = adviceList.stream().skip((long) (page - 1) * pageSize).limit(pageSize).collect(Collectors.toList());
+ map.put("total", adviceList.size());
+ map.put("records", tjAdviceList);
+ }else {
+ adviceList = kjbqPage.stream().skip((long) (page - 1) * pageSize).limit(pageSize).collect(Collectors.toList());
+ map.put("total", kjbqPage.size());
+ map.put("records", adviceList);
+ }
+
+ return AjaxResult.success(map);
}
return AjaxResult.success("璇ョ敤鎴锋殏鏃舵病鏈夊父鐢ㄥ缓璁�!");
}
@@ -155,7 +199,7 @@
@ApiOperation(value = "娣诲姞褰撳墠鐧诲綍浜哄父鐢ㄥ缓璁帴鍙�")
public AjaxResult addCyTjAdviceByUserId(@RequestParam @ApiParam(value = "鎵�閫夊缓璁富閿甶d鏁扮粍") List<Long> adviceIds) {
String userId = UserHoder.getLoginUser().getUserId();
- if (null != adviceIds && adviceIds.size() > 0) {
+ if (null != adviceIds && !adviceIds.isEmpty()) {
for (Long id : adviceIds) {
TjUserAdvice tjUserAdvice = userAdviceService.getTjUserAdviceByUserId(Long.valueOf(userId), id);
if (null == tjUserAdvice) {
@@ -169,6 +213,30 @@
}
return AjaxResult.success("璇烽�夋嫨鎮ㄨ娣诲姞鐨勫缓璁�!");
}
+
+
+ @GetMapping("/edaitCyTjAdviceByUserId")
+ @ApiOperation(value = "淇敼褰撳墠鐧诲綍浜哄父鐢ㄥ缓璁帴鍙�")
+ public AjaxResult edaitCyTjAdviceByUserId(@RequestParam @ApiParam(value = "鎵�閫夊缓璁富閿甶d鏁扮粍") List<Long> adviceIds) {
+ String userId = UserHoder.getLoginUser().getUserId();
+ if (null != adviceIds && !adviceIds.isEmpty()) {
+ LambdaQueryWrapper<TjUserAdvice> wq=new LambdaQueryWrapper<>();
+ wq.eq(TjUserAdvice::getUserId,userId);
+ userAdviceService.remove(wq);
+ for (Long id : adviceIds) {
+ TjUserAdvice tjUserAdvice = userAdviceService.getTjUserAdviceByUserId(Long.valueOf(userId), id);
+ if (null == tjUserAdvice) {
+ TjUserAdvice userAdvice = new TjUserAdvice();
+ userAdvice.setAdviceId(id);
+ userAdvice.setUserId(Long.valueOf(userId));
+ userAdviceService.save(userAdvice);
+ }
+ }
+ return AjaxResult.success("娣诲姞鎴愬姛!");
+ }
+ return AjaxResult.success("璇烽�夋嫨鎮ㄨ娣诲姞鐨勫缓璁�!");
+ }
+
@PostMapping("/addCyTjAdvice")
@@ -204,7 +272,7 @@
@ApiParam(value = "寤鸿") @RequestParam(required = false) String nr,
@ApiParam(value = "椤电爜鏁�(榛樿1)") @RequestParam(defaultValue = "1") Integer page,
@ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize,
- @RequestParam(value = "deptId")String deptId) {
+ @RequestParam(required = false)String deptId) {
// LambdaQueryWrapper<SysDept> wrapper = new LambdaQueryWrapper<>();
// wrapper.eq(SysDept::getParentId, 0);
// SysDept sysDept = sysDeptService.getOne(wrapper);
@@ -267,8 +335,8 @@
// }
// map.put("list", list);
// map.put("total", page2.getTotal());
- List<TjAdvice> tjAdvices = tjAdviceService.selectList(proName, deptId, (page - 1) * pageSize, pageSize);
- Integer count = tjAdviceService.selectListCount(proName, deptId);
+ List<TjAdvice> tjAdvices = tjAdviceService.selectList(proName, deptId, (page - 1) * pageSize, pageSize,bt,nr);
+ Integer count = tjAdviceService.selectListCount(proName, deptId,bt,nr);
HashMap<String, Object> hashMap = new HashMap<>();
hashMap.put("list",tjAdvices);
hashMap.put("total",count);
@@ -322,6 +390,7 @@
// @PreAuthorize("@ss.hasPermi('advice:advice:edit')")
@Log(title = "advice", businessType = BusinessType.UPDATE)
@PutMapping
+ @ApiOperation(value = "淇敼浣撴寤鸿鎺ュ彛")
public AjaxResult edit(@RequestBody TjAdvice tjAdvice) {
return AjaxResult.success(tjAdviceService.updateById(tjAdvice));
}
@@ -335,4 +404,18 @@
public AjaxResult remove(@PathVariable Long[] ids) {
return AjaxResult.success(tjAdviceService.deleteTjAdviceByIds(ids));
}
+
+
+ @DeleteMapping("/delCyremove")
+ @ApiOperation(value = "鍒犻櫎鐢ㄦ埛甯哥敤寤鸿鎺ュ彛")
+ public AjaxResult delCyremove(@RequestParam List<String> ids) {
+ String userId = UserHoder.getLoginUser().getUserId();
+ LambdaQueryWrapper<TjUserAdvice> wq=new LambdaQueryWrapper<>();
+ wq.in(TjUserAdvice::getAdviceId,ids);
+ wq.eq(TjUserAdvice::getUserId,userId);
+ if (userAdviceService.remove(wq)) {
+ return AjaxResult.success();
+ }
+ return AjaxResult.error();
+ }
}
--
Gitblit v1.8.0