From 923af8f8eb0d849b92afa8b567036aae2837f202 Mon Sep 17 00:00:00 2001 From: Jinquan_Ou <Jinquan@gdut.com> Date: 星期五, 21 四月 2023 16:41:00 +0800 Subject: [PATCH] 888 --- zhang-content/src/main/java/com/ruoyi/domain/ZfEvent.java | 24 +++++++ zhang-content/src/main/java/com/ruoyi/service/impl/ZfCollectionServiceImpl.java | 6 + zhang-content/src/main/java/com/ruoyi/service/impl/ZfEventServiceImpl.java | 35 ++++++----- zhang-content/src/main/java/com/ruoyi/domain/ZfCollection.java | 34 ++++++++-- zhang-content/src/main/java/com/ruoyi/domain/ZfProperty.java | 24 +++++++ zhang-content/src/main/java/com/ruoyi/service/impl/IZfPropertyServiceImpl.java | 43 +++++++++---- 6 files changed, 121 insertions(+), 45 deletions(-) diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZfCollection.java b/zhang-content/src/main/java/com/ruoyi/domain/ZfCollection.java index 1ed6f7b..3a2530d 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZfCollection.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZfCollection.java @@ -32,13 +32,6 @@ private Integer id; /** - * 鑾峰緱鏃堕棿 - */ - @JsonFormat(pattern = "yyyy-MM-dd") - @Excel(name = "鍒涘缓鏃堕棿", dateFormat = "yyyy-MM-dd") - private Date getTime; - - /** * 绫诲埆 */ @Excel(name = "绫诲埆") @@ -88,7 +81,7 @@ /** * 鎵�灞炲搴璱d */ - @Excel(name = "鎵�灞炲搴紪鍙�") + @Excel(name = "鎵�灞炲搴紪鍙�(瀵煎叆鏁版嵁鏃惰鍒犻櫎姝ゆ爮)") private String familyId; /** @@ -97,5 +90,30 @@ @TableField(exist = false) private Integer ownData = 0; + /** + * 鍒涘缓鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd") + private Date createTime; + + /** + * 寮�濮嬫椂闂� + */ + @TableField(exist = false) + private Date happenStartTime; + + /** + * 缁撴潫鏃堕棿 + */ + @TableField(exist = false) + private Date happenEndTime; + + /** + * 鑾峰緱鏃堕棿 + */ + @Excel(name = "鍙戠敓鏃堕棿", dateFormat = "yyyy-MM-dd") + @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") + private Date happenTime; + } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZfEvent.java b/zhang-content/src/main/java/com/ruoyi/domain/ZfEvent.java index b2664d1..4285af2 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZfEvent.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZfEvent.java @@ -1,6 +1,7 @@ package com.ruoyi.domain; import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.fasterxml.jackson.annotation.JsonFormat; @@ -34,7 +35,6 @@ * 鍒涘缓鏃堕棿 */ @JsonFormat(pattern = "yyyy-MM-dd") - @Excel(name = "鍒涘缓鏃堕棿", dateFormat = "yyyy-MM-dd") private Date createTime; /** @@ -63,7 +63,27 @@ private String url; - @Excel(name="瀹跺涵缂栧彿") + @Excel(name="鎵�灞炲搴紪鍙�(瀵煎叆鏁版嵁鏃惰鍒犻櫎姝ゆ爮)") private String familyId; + + /** + * 寮�濮嬫椂闂� + */ + @TableField(exist = false) + private Date happenStartTime; + + /** + * 缁撴潫鏃堕棿 + */ + @TableField(exist = false) + private Date happenEndTime; + + /** + * 鍙戠敓鏃堕棿 + */ + @Excel(name = "鍙戠敓鏃堕棿", dateFormat = "yyyy-MM-dd") + @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") + private Date happenTime; + } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZfProperty.java b/zhang-content/src/main/java/com/ruoyi/domain/ZfProperty.java index 1989f69..06ed9ac 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZfProperty.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZfProperty.java @@ -57,15 +57,21 @@ * 鍒涘缓鏃堕棿 */ @JsonFormat(pattern = "yyyy-MM-dd") - @Excel(name = "鍒涘缓鏃堕棿", dateFormat = "yyyy-MM-dd") private Date createTime; + + /** + * 鍙戠敓鏃堕棿 + */ + @Excel(name = "鍙戠敓鏃堕棿", dateFormat = "yyyy-MM-dd") + @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") + private Date happenTime; private String url; /** * 瀹跺涵id */ - @Excel(name = "鎵�灞炲搴紪鍙�") + @Excel(name = "鎵�灞炲搴紪鍙�(瀵煎叆鏁版嵁鏃惰鍒犻櫎姝ゆ爮)") private String familyId; /** @@ -74,8 +80,22 @@ @TableField(exist = false) private Integer ownData = 0; + /** + * 鏁版嵁鐘舵�� + */ @Excel(name = "鏄惁娉ㄩ攢",readConverterExp = "0=姝e父,1=宸叉敞閿�") private Integer status; + /** + * 寮�濮嬫椂闂� + */ + @TableField(exist = false) + private Date happenStartTime; + + /** + * 缁撴潫鏃堕棿 + */ + @TableField(exist = false) + private Date happenEndTime; } diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/IZfPropertyServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/IZfPropertyServiceImpl.java index d1c5af7..cc75031 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/IZfPropertyServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/IZfPropertyServiceImpl.java @@ -22,6 +22,9 @@ import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; +import java.text.ParseException; +import java.text.SimpleDateFormat; +import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.stream.Collectors; @@ -38,14 +41,26 @@ @Service public class IZfPropertyServiceImpl extends ServiceImpl<ZfPropertyMapper, ZfProperty> implements IZfPropertyService { - - @Resource IZfPropertyService zfPropertyService; @Resource ZInfoUserService zInfoUserService; + +// private Date getHappenTime(ZfProperty zfProperty) { +// SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); +// String happenTimeStr = format.format(zfProperty.getHappenTime()); +// +// Date happenTime = null; +// try { +// happenTime = format.parse(happenTimeStr); +// System.out.println("鏂规硶閲岀殑:" + happenTime); +// } catch (ParseException e) { +// throw new RuntimeException("鏃堕棿鏍煎紡杞崲鏈夎"); +// } +// return happenTime; +// } private LambdaQueryWrapper<ZfProperty> buildCondition(ZfProperty zfProperty) { @@ -57,7 +72,8 @@ .like(!StringUtils.isEmpty(zfProperty.getHolder()), ZfProperty::getHolder, zfProperty.getHolder()) .like(!StringUtils.isEmpty(zfProperty.getAddress()), ZfProperty::getAddress, zfProperty.getAddress()) .like(!StringUtils.isEmpty(zfProperty.getRemark()), ZfProperty::getRemark, zfProperty.getRemark()) - .like(zfProperty.getCreateTime() != null, ZfProperty::getCreateTime, zfProperty.getCreateTime()); + .eq(zfProperty.getHappenTime()!=null,ZfProperty::getHappenTime,zfProperty.getHappenTime()) + .between(zfProperty.getHappenStartTime() != null && zfProperty.getHappenEndTime() != null, ZfProperty::getHappenTime, zfProperty.getHappenStartTime(), zfProperty.getHappenEndTime()); return lqw; } @@ -86,7 +102,7 @@ secondFamilyIdsBuffer.deleteCharAt(secondFamilyIdsBuffer.length() - 1); } - }else{ + } else { setSecondFamilyAuthority(secondFamilyIdsBuffer, secondFamilyAuthority); //鎶婂悗闈㈢殑閫楀彿鍘绘帀 if (secondFamilyIdsBuffer.length() > 1) { @@ -140,7 +156,7 @@ } - lqw.orderByDesc(ZfProperty::getId); + lqw.orderByDesc(ZfProperty::getCreateTime); return lqw; } @@ -183,7 +199,7 @@ } @Override - public List<ZfProperty> selectByCondition(ZfProperty zfProperty) { + public List<ZfProperty> selectByCondition(ZfProperty zfProperty) { String familyIds = listFamilyIds(); String secondFamilyIds = listSecondFamilyIds(); LambdaQueryWrapper<ZfProperty> lambdaQueryWrapper = buildCondition(zfProperty, familyIds, secondFamilyIds); @@ -247,7 +263,7 @@ if (flag) { if (save(zfProperty)) { return AjaxResult.success(); - }else { + } else { return AjaxResult.error(); } @@ -257,33 +273,32 @@ } @Override - public AjaxResult addData2(ZfProperty zfProperty){ + public AjaxResult addData2(ZfProperty zfProperty) { ZInfoUser mySelf = getMySelf(); String myFamilyId = mySelf.getFamilyId(); - if (StringUtils.isNotEmpty(zfProperty.getFamilyId())){ + if (StringUtils.isNotEmpty(zfProperty.getFamilyId())) { throw new RuntimeException("瀵煎叆鏁版嵁鏃舵偍涓嶈兘鎸囧畾瀹跺涵鍙�"); } - if(StringUtils.isEmpty(myFamilyId)){ + if (StringUtils.isEmpty(myFamilyId)) { throw new RuntimeException("鎮ㄨ繕鏈姞鍏ヤ换浣曞搴�"); } - if (myFamilyId.contains(",")){ + if (myFamilyId.contains(",")) { String[] myFamilyIds = myFamilyId.split(","); //榛樿娣诲姞绗竴涓搴殑鏁版嵁 zfProperty.setFamilyId(myFamilyIds[0]); - }else { + } else { zfProperty.setFamilyId(myFamilyId); } if (save(zfProperty)) { return AjaxResult.success(); - }else { + } else { return AjaxResult.error(); } } - @Override diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCollectionServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCollectionServiceImpl.java index 5a26611..f61f637 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCollectionServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCollectionServiceImpl.java @@ -13,6 +13,7 @@ import com.ruoyi.domain.ZInfoUser; import com.ruoyi.domain.ZfCollection; import com.ruoyi.domain.ZfCollection; +import com.ruoyi.domain.ZfCollection; import com.ruoyi.mapper.ZfCollectionMapper; import com.ruoyi.service.ZInfoUserService; import com.ruoyi.service.ZfCollectionService; @@ -56,7 +57,8 @@ lqw.like(StringUtils.isNotEmpty(zfCollection.getPrice()),ZfCollection::getPrice,zfCollection.getPrice()); lqw.like(StringUtils.isNotEmpty(zfCollection.getLocation()),ZfCollection::getLocation,zfCollection.getLocation()); lqw.like(StringUtils.isNotEmpty(zfCollection.getRemark()),ZfCollection::getRemark,zfCollection.getRemark()); - lqw.like(zfCollection.getGetTime()!=null,ZfCollection::getGetTime,zfCollection.getGetTime()); + lqw.eq(zfCollection.getHappenTime() != null, ZfCollection::getHappenTime, zfCollection.getHappenTime()); + lqw.between(zfCollection.getHappenStartTime() != null && zfCollection.getHappenEndTime() != null, ZfCollection::getHappenTime, zfCollection.getHappenStartTime(), zfCollection.getHappenEndTime()); return lqw; } @@ -139,7 +141,7 @@ } - lqw.orderByDesc(ZfCollection::getId); + lqw.orderByDesc(ZfCollection::getCreateTime); return lqw; } diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfEventServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfEventServiceImpl.java index fb803c4..9fef9fc 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfEventServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfEventServiceImpl.java @@ -42,36 +42,36 @@ @Resource ZfEventService zfEventService; - - private String listFamilyIds(){ + + private String listFamilyIds() { SysUser user = SecurityUtils.getLoginUser().getUser(); Long userId = user.getUserId(); LambdaQueryWrapper<ZInfoUser> zInfoUserLambdaQueryWrapper = new LambdaQueryWrapper<>(); - zInfoUserLambdaQueryWrapper.eq(ZInfoUser::getUserId,userId); + zInfoUserLambdaQueryWrapper.eq(ZInfoUser::getUserId, userId); ZInfoUser zInfoUser = zInfoUserService.getOne(zInfoUserLambdaQueryWrapper); return zInfoUser.getFamilyId(); } - + @Override public AjaxResult selectEventList(ZfEvent zfEvent, Integer pageNum, Integer pageSize) { String familyIds = listFamilyIds(); - LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent,familyIds); + LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent, familyIds); - Page<ZfEvent> ZfEventPage = new Page<>(pageNum,pageSize); + Page<ZfEvent> ZfEventPage = new Page<>(pageNum, pageSize); Page<ZfEvent> pageResult = page(ZfEventPage, lqw); HashMap<String, Object> data = MapUtils.getResult(pageResult); return AjaxResult.success(data); } - + @Override public List<ZfEvent> selectByCondition(ZfEvent zfEvent) { String familyIds = listFamilyIds(); - LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent,familyIds); + LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent, familyIds); List<ZfEvent> list = list(lqw); - log.info("杩斿洖鐨勬暟鎹负:{}",list); + log.info("杩斿洖鐨勬暟鎹负:{}", list); return list; } @@ -119,11 +119,12 @@ private LambdaQueryWrapper<ZfEvent> buildCondition(ZfEvent zfEvent) { LambdaQueryWrapper<ZfEvent> lqw = new LambdaQueryWrapper<>(); - lqw.like(!StringUtils.isEmpty(zfEvent.getAddress()),ZfEvent::getAddress,zfEvent.getAddress()); - lqw.like(!StringUtils.isEmpty(zfEvent.getPeople()),ZfEvent::getPeople,zfEvent.getPeople()); - lqw.like(!StringUtils.isEmpty(zfEvent.getTitle()),ZfEvent::getTitle,zfEvent.getTitle()); - lqw.like(!StringUtils.isEmpty(zfEvent.getRemark()),ZfEvent::getRemark,zfEvent.getRemark()); - lqw.like(zfEvent.getCreateTime()!=null,ZfEvent::getCreateTime,zfEvent.getCreateTime()); + lqw.like(!StringUtils.isEmpty(zfEvent.getAddress()), ZfEvent::getAddress, zfEvent.getAddress()); + lqw.like(!StringUtils.isEmpty(zfEvent.getPeople()), ZfEvent::getPeople, zfEvent.getPeople()); + lqw.like(!StringUtils.isEmpty(zfEvent.getTitle()), ZfEvent::getTitle, zfEvent.getTitle()); + lqw.like(!StringUtils.isEmpty(zfEvent.getRemark()), ZfEvent::getRemark, zfEvent.getRemark()); + lqw.eq(zfEvent.getHappenTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenTime()); + lqw.between(zfEvent.getHappenStartTime() != null && zfEvent.getHappenEndTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenStartTime(), zfEvent.getHappenEndTime()); return lqw; } @@ -131,9 +132,9 @@ LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent); if (familyIds.contains(",")) { String[] familyList = familyIds.split(","); - lqw.in(ZfEvent::getFamilyId,familyList); - }else { - lqw.eq(ZfEvent::getFamilyId,familyIds); + lqw.in(ZfEvent::getFamilyId, familyList); + } else { + lqw.eq(ZfEvent::getFamilyId, familyIds); } return lqw; } -- Gitblit v1.9.1