| | |
| | | import com.fzzy.igds.domain.Camera; |
| | | import com.fzzy.igds.mapper.CameraMapper; |
| | | import com.fzzy.igds.utils.ContextUtil; |
| | | import com.fzzy.igds.utils.DateUtil; |
| | | import com.ruoyi.common.core.redis.RedisCache; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | if(StringUtils.isNotBlank(param.getSpdwlx())){ |
| | | queryWrapper.eq("spdwlx", param.getSpdwlx()); |
| | | } |
| | | |
| | | queryWrapper.orderByAsc("order_num"); |
| | | cameraMapper.selectPage(page, queryWrapper); |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | /** |
| | | * 获取更新监控数量 |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | * @return |
| | | */ |
| | | public int getUpdateCount(String deptId, Date start, Date end) { |
| | | |
| | | QueryWrapper<Camera> queryWrapper = new QueryWrapper<>(); |
| | | |
| | | if(StringUtils.isNotBlank(deptId)){ |
| | | queryWrapper.eq("dept_id", deptId); |
| | | } |
| | | if (null != start) { |
| | | queryWrapper.ge("update_time", start); |
| | | } |
| | | if (null != end) { |
| | | queryWrapper.le("update_time", end); |
| | | } |
| | | |
| | | return cameraMapper.selectCount(queryWrapper); |
| | | } |
| | | |
| | | /** |
| | | * 保存数据 |
| | | * @param data |
| | | */ |