| | |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.domain.ZSelfNote; |
| | | import com.ruoyi.domain.ZSelfNote; |
| | | import com.ruoyi.mapper.ZSelfNoteMapper; |
| | | import com.ruoyi.service.ZSelfNoteService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | |
| | | lqw.eq(userId != null, ZSelfNote::getUid, userId) |
| | | .like(StringUtils.isNotEmpty(zSelfNote.getPeople()), ZSelfNote::getPeople, zSelfNote.getPeople()) |
| | | .like(StringUtils.isNotEmpty(zSelfNote.getTitle()), ZSelfNote::getTitle, zSelfNote.getTitle()) |
| | | .like(StringUtils.isNotEmpty(zSelfNote.getAddress()),ZSelfNote::getAddress,zSelfNote.getAddress()) |
| | | .like(StringUtils.isNotEmpty(zSelfNote.getRemark()),ZSelfNote::getRemark,zSelfNote.getRemark()) |
| | | .between(zSelfNote.getHappenStartTime() != null && zSelfNote.getHappenEndTime() != null, ZSelfNote::getHappenTime, zSelfNote.getHappenStartTime(), zSelfNote.getHappenEndTime()) |
| | | .orderByDesc(ZSelfNote::getCreateTime); |
| | | return lqw; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<ZSelfNote> selectByCondition() { |
| | | |
| | | SysUser user = SecurityUtils.getLoginUser().getUser(); |
| | | Long userId = user.getUserId(); |
| | | |
| | | ZSelfNote zSelfNote = new ZSelfNote(); |
| | | LambdaQueryWrapper<ZSelfNote> lqw = buildCondition(zSelfNote, userId); |
| | | return list(lqw); |
| | | } |
| | | |
| | | @Override |
| | | @Transactional |
| | | public AjaxResult importExcel(MultipartFile file) { |
| | | |