| | |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.util.ObjectUtils; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | |
| | | */ |
| | | @Override |
| | | public Integer interCoordinate(Map<String, Object> params) { |
| | | // String mac = params.get("mac").toString(); |
| | | String mac ="p5dnd7a0243625"; |
| | | String mac = params.get("mac").toString(); |
| | | QueryWrapper<SpecialDevice> wrapper = new QueryWrapper<>(); |
| | | wrapper.eq("mac",mac); |
| | | wrapper.eq("is_delete","0"); |
| | | SpecialDevice specialDevice = specialDeviceMapper.selectOne(wrapper); |
| | | String startPoint = params.get("startPoint").toString(); |
| | | String endPoint = params.get("endPoint").toString(); |
| | | QueryWrapper<ManageCoordinate> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("start_point",startPoint); |
| | | queryWrapper.eq("end_point",endPoint); |
| | | Integer integer = manageCoordinateMapper.selectCount(queryWrapper); |
| | | if (integer>=1){ |
| | | return null; |
| | |
| | | manageCoordinate.setCreateTime(new Date()); |
| | | manageCoordinate.setUpdateTime(new Date()); |
| | | manageCoordinate.setStartPoint(startPoint); |
| | | manageCoordinate.setEndPoint(endPoint); |
| | | manageCoordinate.setIsDel(0); |
| | | manageCoordinate.setOrganizationId(specialDevice.getOrganizationId()); |
| | | int code = manageCoordinateMapper.insert(manageCoordinate); |
| | |
| | | * @return |
| | | */ |
| | | @Override |
| | | public List<ManageCoordinate> selectCoordinate() { |
| | | public List<ManageCoordinate> selectCoordinate(String name,String mac) { |
| | | |
| | | QueryWrapper<ManageCoordinate> queryWrapper = new QueryWrapper<>(); |
| | | |
| | | if (!ObjectUtils.isEmpty(name)){ |
| | | queryWrapper.like("start_point",name); |
| | | } |
| | | if(!ObjectUtils.isEmpty(mac)){ |
| | | QueryWrapper<SpecialDevice> wrapper = new QueryWrapper<>(); |
| | | wrapper.eq("mac",mac); |
| | | wrapper.eq("is_delete","0"); |
| | | SpecialDevice specialDevice = specialDeviceMapper.selectOne(wrapper); |
| | | queryWrapper.eq("organization_id",specialDevice.getOrganizationId()); |
| | | } |
| | | queryWrapper.eq("is_del",0); |
| | | queryWrapper.orderByDesc("coordinate_id"); |
| | | List<ManageCoordinate> manageCoordinates = manageCoordinateMapper.selectList(queryWrapper); |
| | | return manageCoordinates; |
| | | } |