智慧保安后台管理-外网项目备份
tangzy
2022-02-24 d4b00c05321d9373a33bfb26618735e2a5868a81
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package org.springblade.modules.equipage.service.impl;
 
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.equipage.entity.Car;
import org.springblade.modules.equipage.excel.CarExcel;
import org.springblade.modules.equipage.mapper.CarMapper;
import org.springblade.modules.equipage.service.CarService;
import org.springblade.modules.equipage.vo.CarVo;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
import java.util.Map;
import java.util.Objects;
 
/**
 * 车辆服务实现类
 * @author zhongrj
 */
@Service
public class CarServiceImpl extends ServiceImpl<CarMapper, Car> implements CarService {
 
    @Autowired
    private IUserDeptService userDeptService;
    @Autowired
    private  MyAsyncService myAsyncService;
 
    /**
     * 车辆分页信息
     * @param page
     * @param car 车辆信息对象
     * @return
     */
    @Override
    public IPage<CarVo> selectCarPage(IPage<CarVo> page, CarVo car) {
        return page.setRecords(baseMapper.selectCarPage(page, car));
    }
 
    /**
     * 详情
     * @param car 车辆信息对象
     */
    @Override
    public CarVo selectCarInfo(Car car) {
        return baseMapper.selectCarInfo(car);
    }
 
 
    /**
     * 车辆批量导入
     * @param data
     * @param isCovered
     */
    @Override
    public void importCar(List<CarExcel> data, Boolean isCovered,String deptId) {
        if (data.size()>0){
            //遍历
            data.forEach(carExcel -> {
                Car car = Objects.requireNonNull(BeanUtil.copy(carExcel, Car.class));
                //设置部门id
                String deptIds = userDeptService.selectIn(carExcel.getDeptId());
                if (null!=deptIds && !deptIds.equals("")) {
                    if (null != deptId && !deptId.equals("")) {
                        if (!deptId.equals(deptIds)) {
                            throw new ServiceException("导入失败!不能导入不是本公司的车辆信息数据!");
                        }
                    }
                    car.setDeptId(Long.parseLong(deptIds));
                }else {
                    //如果deptIds 为空,则说明还没有改公司
                    throw new ServiceException("导入失败!公司名:["+carExcel.getDeptId()+"]不存在!");
                }
 
                //新增车辆数据
                this.save(car);
 
                //数据同步
                String s = "insert into blade_user(" +
                    "id,dept_id,car_number,person_in_charge,brand,umweltsatz,mode) " +
                    "values(" + "'" + car.getId() + "'" +
                    "," + "'" + car.getDeptId() + "'" +
                    "," + "'" + car.getCarNumber() + "'" +
                    "," + "'" + car.getPersonInCharge() + "'" +
                    "," + "'" + car.getBrand() + "'" +
                    "," + "'" + car.getUmweltsatz() + "'" +
                    "," + "'" + car.getMode() + "'" + ")";
                //FtpUtil.sqlFileUpload(s);
                myAsyncService.FTP(s);
 
            });
        }else {
            throw new ServiceException("没有数据");
        }
    }
 
    @Override
    public List<Map<Object,Object>> selectCar() {
        return baseMapper.selectCar();
    }
}