| | |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | // queryWrapper.eq("status","未处理"); |
| | | if (objectid!=null){ |
| | | queryWrapper.eq("anchorid",objectid); |
| | | String output = objectid.toUpperCase();//将小写字母转成大写字母 |
| | | |
| | | queryWrapper.eq("anchorid",output); |
| | | } |
| | | queryWrapper.eq("companyid",company); |
| | | queryWrapper.eq("company",company); |
| | | |
| | | queryWrapper.orderByDesc("GreateTime"); |
| | | IPage<TbAchor> CompanyPage = baseMapper.selectPage(page, queryWrapper); |
| | |
| | | @Override |
| | | public Integer findonline(String company) { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("companyid",company); |
| | | queryWrapper.eq("company",company); |
| | | queryWrapper.eq("anchormode",1); |
| | | List<TbAchor> CompanyPage = baseMapper.selectList(queryWrapper); |
| | | return CompanyPage.size(); |
| | |
| | | @Override |
| | | public Integer findoffline(String company) { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("companyid",company); |
| | | queryWrapper.eq("company",company); |
| | | queryWrapper.ne("anchormode",1); |
| | | List<TbAchor> CompanyPage = baseMapper.selectList(queryWrapper); |
| | | return CompanyPage.size(); |
| | |
| | | @Override |
| | | public List<TbAchor> getBaseGPSCesium( String company) { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("companyid",company); |
| | | queryWrapper.eq("company",company); |
| | | // List<TbAchor> people = tbAchorMapper.getBaseGPSCesium(); |
| | | return baseMapper.selectList(queryWrapper); |
| | | } |