From 045b55722b25ccc77d88671c5d6df309edb8a66d Mon Sep 17 00:00:00 2001
From: 钟日健 <5689795+arsn@user.noreply.gitee.com>
Date: Tue, 22 Feb 2022 16:00:34 +0800
Subject: [PATCH] 1. 保安员新增异步推送数据至群访用户表 2. 会员标记接口新增,会员标记成功,则创建会员记录和会员题库记录(包含120道题目) 3. web 端考试开始,查询题目判断用户是否为会员,如果为会员则从会员题库获取当前人员的考试题目(从120道题中随机抽取60道)
---
src/main/java/org/springblade/modules/equipage/service/impl/CarServiceImpl.java | 66 +++++++++++++++++++++++++++++++++
1 files changed, 66 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/equipage/service/impl/CarServiceImpl.java b/src/main/java/org/springblade/modules/equipage/service/impl/CarServiceImpl.java
index 9f9b908..71a86a1 100644
--- a/src/main/java/org/springblade/modules/equipage/service/impl/CarServiceImpl.java
+++ b/src/main/java/org/springblade/modules/equipage/service/impl/CarServiceImpl.java
@@ -2,11 +2,22 @@
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.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
/**
* 车辆服务实现类
@@ -14,6 +25,9 @@
*/
@Service
public class CarServiceImpl extends ServiceImpl<CarMapper, Car> implements CarService {
+
+ @Autowired
+ private IUserDeptService userDeptService;
/**
* 车辆分页信息
@@ -34,4 +48,56 @@
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);
+
+ });
+ }else {
+ throw new ServiceException("没有数据");
+ }
+ }
+
+ @Override
+ public List<Map<Object,Object>> selectCar() {
+ return baseMapper.selectCar();
+ }
}
--
Gitblit v1.9.3