| | |
| | | package com.ruoyi.web.controller.zhang; |
| | | |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.domain.entity.SysUser; |
| | |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; |
| | |
| | | private TravelCountService travelCountService; |
| | | |
| | | @GetMapping("/all") |
| | | public AjaxResult listAll(TravelCount travelCount){ |
| | | public AjaxResult listAll(TravelCount travelCount, @JsonFormat(pattern = "yyyy-MM-dd") Date happenStartTime,@JsonFormat(pattern = "yyyy-MM-dd") Date happenEndTime){ |
| | | SysUser user = SecurityUtils.getLoginUser().getUser(); |
| | | Long userId = user.getUserId(); |
| | | Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); |
| | | Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); |
| | | return travelCountService.selectDataList(userId,pageNum,pageSize,travelCount); |
| | | return travelCountService.selectDataList(userId,pageNum,pageSize,travelCount,happenStartTime,happenEndTime); |
| | | } |
| | | |
| | | @GetMapping("/{id}") |
| | |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.domain.TravelCount; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | */ |
| | | public interface TravelCountService extends IService<TravelCount> { |
| | | |
| | | AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize,TravelCount travelCount); |
| | | AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize, TravelCount travelCount, @JsonFormat(pattern = "yyyy-MM-dd") Date happenStartTime, @JsonFormat(pattern = "yyyy-MM-dd") Date happenEndTime); |
| | | |
| | | void removeData(List<Long> list); |
| | | |
| | |
| | | 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.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.utils.MapUtils; |
| | | import com.ruoyi.domain.TravelCount; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.text.DecimalFormat; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | private TravelCountService travelCountService; |
| | | |
| | | @Override |
| | | public AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize,TravelCount travelCount) { |
| | | public AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize, TravelCount travelCount, @JsonFormat(pattern = "yyyy-MM-dd") Date happenStartTime, @JsonFormat(pattern = "yyyy-MM-dd") Date happenEndTime) { |
| | | //设置查询条件 |
| | | LambdaQueryWrapper<TravelCount> lqw = new LambdaQueryWrapper<>(); |
| | | lqw.eq(TravelCount::getUid,userId); |
| | |
| | | lqw.like(travelCount.getName()!=null,TravelCount::getName,travelCount.getName()); |
| | | lqw.like(travelCount.getName()!=null,TravelCount::getName,travelCount.getName()); |
| | | } |
| | | if(happenStartTime!=null){ |
| | | lqw.gt(TravelCount::getStartTime,happenStartTime); |
| | | } |
| | | |
| | | if(happenEndTime!=null){ |
| | | lqw.lt(TravelCount::getEndTime,happenEndTime); |
| | | } |
| | | |
| | | |
| | | |