package com.hxzkmonitor.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.hxzkmonitor.mapper.TbBaidumapMapper;
|
import com.hxzkmonitor.pojo.TbBaidumap;
|
import com.hxzkmonitor.pojo.TbCompany;
|
import com.hxzkmonitor.mapper.TbCompanyMapper;
|
import com.hxzkmonitor.pojo.TbCompany;
|
import com.hxzkmonitor.service.TbBaidumapService;
|
import com.hxzkmonitor.service.TbCompanyService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-08-05
|
*/
|
@Service
|
public class TbCompanyServiceImpl extends ServiceImpl<TbCompanyMapper, TbCompany> implements TbCompanyService {
|
|
@Autowired
|
TbBaidumapService tbBaidumapService;
|
|
@Autowired
|
TbBaidumapMapper tbBaidumapMapper;
|
@Override
|
public IPage<TbCompany> searchCompany(Page page, String keyword) {
|
QueryWrapper<TbCompany> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("Companyname", keyword);
|
IPage<TbCompany> tagid = baseMapper.selectPage(page, queryWrapper);
|
return tagid;
|
}
|
|
@Override
|
public Integer delCompany(Integer id) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("id", id);
|
TbCompany tbCompany = baseMapper.selectOne(queryWrapper);
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("companyname", tbCompany.getCompanyname());
|
// tbBaidumapMapper.selectOne(queryWrapper2);
|
tbBaidumapMapper.delete(queryWrapper2);
|
return baseMapper.delete(queryWrapper);
|
}
|
|
@Override
|
public Integer addorupCompany(TbCompany tbCompany) {
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
tbCompany.setAddtime(formatter.format(date));
|
if (tbCompany.getId() != null) {
|
return baseMapper.updateById(tbCompany);
|
} else {
|
TbBaidumap tbBaidumap = new TbBaidumap();
|
tbBaidumap.setMapname("百度地图");
|
tbBaidumap.setIsshow("在线地图");
|
tbBaidumap.setLevel("19");
|
tbBaidumap.setCenter("105.86159832032634;37.245153887456491");
|
tbBaidumap.setFile("/hxzkuwb/tiles");
|
tbBaidumap.setShijiao("64.5");
|
tbBaidumap.setHeig("60");
|
tbBaidumap.setIshow("显示");
|
tbBaidumap.setZhuanhuan("百度");
|
tbBaidumap.setMoshi("0");
|
tbBaidumap.setCompanyname(tbCompany.getCompanyname());
|
tbBaidumapService.addorupBaidumap(tbBaidumap);
|
return baseMapper.insert(tbCompany);
|
}
|
}
|
|
@Override
|
public IPage<TbCompany> getCompanyPage(Page page) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.orderByDesc("addtime");
|
IPage<TbCompany> CompanyPage = baseMapper.selectPage(page, queryWrapper);
|
return CompanyPage;
|
}
|
|
@Override
|
public List<TbCompany> search(String query) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
|
queryWrapper.like("companyname", query);
|
queryWrapper.orderByDesc("addtime");
|
// queryWrapper.last("LIMIT 5");
|
return baseMapper.selectList(queryWrapper);
|
}
|
|
@Override
|
public List<TbCompany> searchfive() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
|
// queryWrapper.like("companyname", query);
|
queryWrapper.orderByDesc("addtime");
|
queryWrapper.last("LIMIT 5");
|
return baseMapper.selectList(queryWrapper);
|
}
|
|
}
|
