| | |
| | | private String endSaveTime; |
| | | } |
| | | |
| | | |
| | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonInclude; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | |
| | | */ |
| | | @Data |
| | | @TableName("tb_person") |
| | | @JsonInclude(JsonInclude.Include.NON_NULL) // 序列化时自动忽略 null 值,减少响应大小,性能最优 |
| | | public class TbPerson implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | |
| | | |
| | | // 排序 |
| | | queryWrapper.orderByDesc("p_tagid"); |
| | | |
| | | // 添加车辆标签条件 |
| | | queryWrapper.and(wrapper -> |
| | | wrapper.eq("baoliu19", "系统默认") |
| | | .or() |
| | | .eq("baoliu19", "LORA标签")); |
| | | // 方式1:使用PageHelper的分页查询 |
| | | Page<TbPerson> page = PageHelper.startPage(personTreeTableDto.getPageNum(), personTreeTableDto.getPageSize()) |
| | | .doSelectPage(() -> baseMapper.selectList(queryWrapper)); |
| | |
| | | List<Long> list = companyService.getChildCompanyIds(UserInfoUtil.getUserCompanyId()); |
| | | list.add(Long.valueOf(UserInfoUtil.getUserCompanyId())); |
| | | List<TbPerson> info = personMapper.RealPosition(list); |
| | | // 直接返回,null 值由全局 Jackson 配置自动过滤,避免性能开销 |
| | | return ListDataResult.resultListSuccess(info,MessageUtils.getMessage("Success")); |
| | | } |
| | | |
| | |
| | | tag.setTagId(person.getPTagid()); |
| | | tagService.getBaseMapper().update(tag, queryWrapperTag); |
| | | } |
| | | |
| | | } |
| | |
| | | driver-class-name: com.mysql.cj.jdbc.Driver |
| | | url: jdbc:mysql://localhost:3306/hxzkuwb |
| | | username: root |
| | | password: hxzk20151102 |
| | | password: 123456 |
| | | web: |
| | | resources: |
| | | resources: |
| | |
| | | # 上传文件的存放路径 |
| | | dir: D:Bs/uploads/ |
| | | # 上传文件的IP地址 |
| | | dir-IP: http://103.155.76.198:9002/uploads/ |
| | | dir-IP: http://127.0.0.1:9002/uploads/ |
| | | # 用户头像存放路径 |
| | | dir-UserImg: D:Bs/uploads/User/ |
| | | # 人员头像存放路径 |
| | |
| | | |
| | | <!--实时人员位置--> |
| | | <select id="RealPosition" resultType="com.hxzk.gps.entity.Person.TbPerson"> |
| | | SELECT p.p_tagid,p.baoliu2,p.baoliu3,p.p_addtiem,p.baoliu4,p.company FROM tb_person p |
| | | SELECT p.p_tagid,p.baoliu2,p.baoliu3,p.p_addtiem,p.baoliu4,p.company,p.p_x,p.p_y,p.p_online FROM tb_person p |
| | | WHERE (p.companyid IN |
| | | <foreach item="item" index="index" collection="list" |
| | | open="(" separator="," close=")"> |