package com.dsh.guns.modular.system.controller.general;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.dsh.course.feignClient.account.model.CompanyQuerySuperiorIdAndTypeAndFlgAndNameReq;
|
import com.dsh.course.feignClient.account.model.CompanyQueryTypeAndFlgAndNameReq;
|
import com.dsh.course.feignClient.account.model.CompanyQueryTypeAndFlgReq;
|
import com.dsh.course.feignClient.activity.CompanyClient;
|
import com.dsh.course.feignClient.activity.DriverClient;
|
import com.dsh.course.feignClient.activity.model.CompanyInfoRes;
|
import com.dsh.course.feignClient.activity.model.CompanyQueryReq;
|
import com.dsh.course.feignClient.activity.model.TDriverReq;
|
import com.dsh.course.mapper.CarInsuranceMapper;
|
import com.dsh.guns.config.UserExt;
|
import com.dsh.guns.core.base.controller.BaseController;
|
import com.dsh.guns.core.base.tips.ErrorTip;
|
import com.dsh.guns.core.common.constant.factory.PageFactory;
|
import com.dsh.guns.core.log.LogObjectHolder;
|
import com.dsh.guns.core.util.SinataUtil;
|
import com.dsh.guns.modular.system.model.*;
|
import com.dsh.guns.modular.system.service.*;
|
import com.dsh.guns.modular.system.util.DateUtil;
|
import com.dsh.guns.modular.system.util.ExcelExportUtil;
|
import com.dsh.guns.modular.system.util.ResultUtil;
|
import org.apache.commons.lang.time.DateUtils;
|
import org.apache.poi.ss.usermodel.Cell;
|
import org.apache.poi.ss.usermodel.Row;
|
import org.apache.poi.ss.usermodel.Sheet;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.Model;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
import org.springframework.web.multipart.MultipartHttpServletRequest;
|
import com.dsh.guns.core.util.WoUtil;
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
|
/**
|
* 车辆管理控制器
|
*
|
* @author fengshuonan
|
* @Date 2020-06-05 17:25:12
|
*/
|
@Controller
|
@RequestMapping("/tCar")
|
public class TCarController extends BaseController {
|
|
private String PREFIX = "/system/tCar/";
|
|
@Autowired
|
private ITCarService tCarService;
|
|
// @Autowired
|
// private ITCompanyService tCompanyService;
|
|
@Autowired
|
private ITCarServiceService tCarServiceService;
|
|
// @Autowired
|
// private ITDriverLineService tDriverLineService;
|
|
@Autowired
|
private ITCarBrandService tCarBrandService;
|
|
@Autowired
|
private ITCarModelService tCarModelService;
|
|
@Autowired
|
private ITCarServiceService itCarServiceService;
|
|
@Autowired
|
private ITServerCarmodelService itServerCarmodelService;
|
|
// @Autowired
|
// private PushMinistryOfTransportUtil pushMinistryOfTransportUtil;
|
|
@Resource
|
private CarInsuranceMapper carInsuranceMapper;
|
|
@Autowired
|
private CompanyClient companyClient;
|
@Autowired
|
private DriverClient driverClient;
|
|
|
/**
|
* 跳转到车辆管理首页
|
*/
|
@RequestMapping("")
|
public String index(Model model) {
|
model.addAttribute("language",UserExt.getLanguage());
|
return PREFIX + "tCar.html";
|
}
|
|
/**
|
* 跳转到添加车辆管理
|
*/
|
@RequestMapping("/tCar_add")
|
public String tCarAdd(Model model) {
|
List<CompanyInfoRes> companyList = companyClient.queryByTypeCompany(2);
|
model.addAttribute("companyList",companyList);
|
User user = UserExt.getUser();
|
Integer roleType = user.getRoleType();
|
model.addAttribute("roleType",roleType);
|
if (2 == roleType){
|
// List<TCompany> franchiseeList = companyClient.queryByTypeCompany(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",11));
|
List<CompanyInfoRes> companyInfoRes = companyClient.queryByListCompany(new CompanyQueryReq(3, user.getObjectId()));
|
model.addAttribute("franchiseeList",companyInfoRes);
|
}else{
|
model.addAttribute("franchiseeList",null);
|
}
|
//查询当前用户所属分公司/加盟商
|
|
model.addAttribute("objectName",companyClient.queryById(UserExt.getUser().getObjectId()).getName());
|
|
//车辆品牌 car brand
|
List<TCarBrand> brandList = tCarBrandService.list(new QueryWrapper<TCarBrand>().eq("state", 1));
|
model.addAttribute("brandList",brandList);
|
//车辆类型
|
/*List<TCarModel> modelList = tCarModelService.selectList(new EntityWrapper<TCarModel>().eq("state", 1));
|
model.addAttribute("modelList",modelList);*/
|
|
List<TServerCarmodel> zcModelList = itServerCarmodelService.list(new QueryWrapper<TServerCarmodel>().eq("type", 1).eq("state", 1));
|
model.addAttribute("zcModelList",zcModelList);
|
List<TServerCarmodel> kcModelList = itServerCarmodelService.list(new QueryWrapper<TServerCarmodel>().eq("type", 2).eq("state", 1));
|
model.addAttribute("kcModelList",kcModelList);
|
model.addAttribute("language",UserExt.getLanguage());
|
return PREFIX + "tCar_add.html";
|
}
|
|
/**
|
* 查询车辆类型
|
* @param carBrandId
|
* @return
|
*/
|
@RequestMapping(value = "/brandChange")
|
@ResponseBody
|
public Object brandChange(@RequestParam Integer carBrandId) {
|
List<TCarModel> list = new ArrayList<>();
|
if (SinataUtil.isNotEmpty(carBrandId)){
|
list = tCarModelService.list(new QueryWrapper<TCarModel>().eq("state",1).eq("brandId", carBrandId));
|
}
|
return list;
|
}
|
|
/**
|
* 跳转到修改车辆管理
|
*/
|
@RequestMapping("/tCar_update/{tCarId}")
|
public String tCarUpdate(@PathVariable Integer tCarId, Model model) {
|
TCar tCar = tCarService.getById(tCarId);
|
model.addAttribute("item",tCar);
|
LogObjectHolder.me().set(tCar);
|
User user = UserExt.getUser();
|
Integer roleType = user.getRoleType();
|
model.addAttribute("roleType",roleType);
|
model.addAttribute("objectName",companyClient.queryById(user.getObjectId()).getName());
|
|
if (1 == roleType){
|
// List<TCompany> companyList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 2));
|
List<CompanyInfoRes> companyInfoRes = companyClient.queryByTypeCompany(2);
|
model.addAttribute("companyList",companyInfoRes);
|
// List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",tCar.getCompanyId()));
|
List<CompanyInfoRes> companyInfoRes1 = companyClient.queryByListCompany(new CompanyQueryReq(3, tCar.getCompanyId()));
|
model.addAttribute("franchiseeList",companyInfoRes1);
|
}else if (2 == roleType){
|
// List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",11));
|
List<CompanyInfoRes> companyInfoRes1 = companyClient.queryByListCompany(new CompanyQueryReq(3, user.getObjectId()));
|
model.addAttribute("franchiseeList",companyInfoRes1);
|
}
|
|
//查询平台ID
|
// TCompany company = tCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1));
|
CompanyInfoRes company = companyClient.queryByTypeCompany(1).get(0);
|
//判断是平台司机还是加盟司机
|
if ((SinataUtil.isEmpty(tCar.getCompanyId()) || tCar.getCompanyId() == 0 || tCar.getCompanyId() == company.getId()) && (SinataUtil.isEmpty(tCar.getFranchiseeId()) || tCar.getFranchiseeId() == 0)){
|
model.addAttribute("companyType",1);
|
}else{
|
model.addAttribute("companyType",2);
|
}
|
|
//获取经营业务
|
List<TCarService> serviceList = tCarServiceService.list(new QueryWrapper<TCarService>().eq("carId", tCar.getId()));
|
Integer one = 1;
|
Integer two = 1;
|
Integer three = 1;
|
Integer four = 1;
|
Integer five = 1;
|
Integer six = 1;
|
Integer zcModel = 0;
|
Integer kcModel = 0;
|
for (TCarService obj : serviceList){
|
if (obj.getType() == 1){
|
one = 2;
|
zcModel = obj.getServerCarModelId();
|
}
|
if (obj.getType() == 2){
|
two = 2;
|
}
|
if (obj.getType() == 3){
|
three = 2;
|
kcModel = obj.getServerCarModelId();
|
}
|
if (obj.getType() == 4){
|
four = 2;
|
}
|
if (obj.getType() == 5){
|
five = 2;
|
}
|
if (obj.getType() == 6){
|
six = 2;
|
}
|
}
|
model.addAttribute("one",one);
|
model.addAttribute("two",two);
|
model.addAttribute("three",three);
|
model.addAttribute("four",four);
|
model.addAttribute("five",five);
|
model.addAttribute("six",six);
|
model.addAttribute("zcModel",zcModel);
|
model.addAttribute("kcModel",kcModel);
|
|
List<TServerCarmodel> zcModelList = itServerCarmodelService.list(new QueryWrapper<TServerCarmodel>().eq("type", 1).eq("state", 1));
|
model.addAttribute("zcModelList",zcModelList);
|
List<TServerCarmodel> kcModelList = itServerCarmodelService.list(new QueryWrapper<TServerCarmodel>().eq("type", 2).eq("state", 1));
|
model.addAttribute("kcModelList",kcModelList);
|
|
//车辆品牌 car brand
|
List<TCarBrand> brandList = tCarBrandService.list(new QueryWrapper<TCarBrand>().eq("state", 1));
|
model.addAttribute("brandList",brandList);
|
//车辆类型
|
List<TCarModel> modelList = tCarModelService.list(new QueryWrapper<TCarModel>().eq("brandId",tCar.getCarBrandId()).eq("state", 1));
|
model.addAttribute("modelList",modelList);
|
model.addAttribute("language",UserExt.getLanguage());
|
return PREFIX + "tCar_edit.html";
|
}
|
|
|
/**
|
* 跳转到保险列表页
|
* @param carId
|
* @param model
|
* @return
|
*/
|
@RequestMapping("/carInsurance")
|
public String carInsurance(Integer carId, Model model){
|
model.addAttribute("carId", carId);
|
return PREFIX + "carInsurance.html";
|
}
|
|
/**
|
* 跳转到添加页面
|
* @param carId
|
* @param model
|
* @return
|
*/
|
@RequestMapping("/showAddCarInsurance")
|
public String showAddCarInsurance(Integer carId, Model model){
|
model.addAttribute("carId", carId);
|
model.addAttribute("id", "");
|
return PREFIX + "carInsuranceInfo.html";
|
}
|
|
/**
|
* 跳转到编辑页
|
* @param id
|
* @param carId
|
* @param model
|
* @return
|
*/
|
@RequestMapping("/showEditCarInsurance")
|
public String showEditCarInsurance(Integer id, Integer carId, Model model){
|
model.addAttribute("carId", carId);
|
model.addAttribute("id", id);
|
return PREFIX + "carInsuranceInfo.html";
|
}
|
|
/**
|
* 添加保险数据
|
* @param carInsurance
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/saveCarInsurance", method = RequestMethod.POST)
|
public ResultUtil saveCarInsurance(CarInsurance carInsurance){
|
if(carInsurance.getId() == null){
|
carInsuranceMapper.insert(carInsurance);
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){//上传数据
|
// pushMinistryOfTransportUtil.baseInfoVehicleInsurance(carInsurance.getId(), 1);
|
// }
|
// }
|
// }).start();
|
}else{
|
carInsuranceMapper.updateById(carInsurance);
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){//上传数据
|
// pushMinistryOfTransportUtil.baseInfoVehicleInsurance(carInsurance.getId(), 2);
|
// }
|
// }
|
// }).start();
|
}
|
|
return ResultUtil.success();
|
}
|
|
/**
|
* 获取保险详情
|
* @param id
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryCarInsurance", method = RequestMethod.POST)
|
public ResultUtil queryCarInsurance(Integer id){
|
CarInsurance carInsurance = carInsuranceMapper.selectById(id);
|
return ResultUtil.success(carInsurance);
|
}
|
|
|
/**
|
* 获取保险列表
|
* @param carId
|
* @param offset
|
* @param limit
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/queryInsuranceList", method = RequestMethod.POST)
|
public Object queryInsuranceList(Integer carId, Integer offset,Integer limit){
|
try {
|
Map<String, Object> map = new HashMap<>();
|
List<Map<String, Object>> list = carInsuranceMapper.queryInsuranceList(carId, offset, limit);
|
int i = carInsuranceMapper.queryInsuranceListCount(carId);
|
map.put("rows", list);
|
map.put("total", i);
|
return map;
|
}catch (Exception e){
|
e.printStackTrace();
|
return ResultUtil.runErr();
|
}
|
}
|
|
/**
|
* 删除保险
|
* @param id
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping(value = "/delCarInsurance", method = RequestMethod.POST)
|
public ResultUtil delCarInsurance(Integer id){
|
carInsuranceMapper.deleteById(id);
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){//上传数据
|
// pushMinistryOfTransportUtil.baseInfoVehicleInsurance(id, 3);
|
// }
|
// }
|
// }).start();
|
return ResultUtil.success();
|
}
|
|
|
/**
|
* 获取车辆管理列表
|
*/
|
@RequestMapping(value = "/list")
|
@ResponseBody
|
public Object list(String createTime,
|
String id,
|
String brandName,
|
String modelName,
|
String carColor,
|
String serverStr,
|
String carLicensePlate,
|
String driverName,
|
String companyName,
|
String franchiseeName) {
|
String beginTime = null;
|
String endTime = null;
|
if (SinataUtil.isNotEmpty(createTime)){
|
String[] timeArray = createTime.split(" - ");
|
beginTime = timeArray[0];
|
endTime = timeArray[1];
|
}
|
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
|
page.setRecords(tCarService.getCarList(page,UserExt.getUser().getRoleType(),UserExt.getUser().getObjectId(),beginTime,endTime,id,brandName,modelName,carColor,serverStr,carLicensePlate,driverName,companyName,franchiseeName));
|
return super.packForBT(page);
|
}
|
|
/**
|
* 新增车辆管理
|
*/
|
@RequestMapping(value = "/add")
|
@ResponseBody
|
public Object add( TCar tCar, String serverBox,Integer roleType,Integer companyType,Integer oneId,Integer twoId,Integer franchiseeId,String zcModel,String kcModel) {
|
TCar tCar1 = tCarService.getBaseMapper().selectOne(new QueryWrapper<TCar>().eq("carLicensePlate", tCar.getCarLicensePlate()).eq("state", 1));
|
if(null != tCar1){
|
return ResultUtil.error(UserExt.getLanguage() == 1 ? "车牌号重复" : UserExt.getLanguage() == 2 ? "Duplicate license plate" : "Kode kendaraan diulangi.");
|
}
|
|
if (1 == roleType){ //平台 platfrom
|
if (2 == companyType.intValue()){
|
if (SinataUtil.isNotEmpty(oneId)){
|
tCar.setCompanyId(oneId);
|
}
|
if (SinataUtil.isNotEmpty(twoId)){
|
tCar.setFranchiseeId(twoId);
|
}
|
}else if (1 == companyType.intValue()){
|
// TCompany company = tCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1));
|
CompanyInfoRes company = companyClient.queryByTypeCompany(1).get(0);
|
tCar.setCompanyId(company.getId());
|
tCar.setFranchiseeId(0);
|
}
|
tCar.setAddType(2);
|
tCar.setIsPlatCar(1);
|
}else if (2 == roleType){ //分公司 sub company
|
if (SinataUtil.isNotEmpty(UserExt.getUser().getObjectId())){
|
tCar.setCompanyId(UserExt.getUser().getObjectId());
|
}
|
if (SinataUtil.isNotEmpty(franchiseeId)){
|
tCar.setFranchiseeId(franchiseeId);
|
}
|
tCar.setIsPlatCar(2);
|
tCar.setAddType(3);
|
tCar.setAddObjectId(UserExt.getUser().getObjectId());
|
}else if (3 == roleType){ //加盟商 Franchisee.
|
CompanyInfoRes tCompany = companyClient.queryById(UserExt.getUser().getObjectId());
|
if (SinataUtil.isNotEmpty(tCompany)){
|
tCar.setCompanyId(tCompany.getSuperiorId());
|
}
|
if (SinataUtil.isNotEmpty(UserExt.getUser().getObjectId())){
|
tCar.setFranchiseeId(UserExt.getUser().getObjectId());
|
}
|
tCar.setIsPlatCar(2);
|
tCar.setAddType(4);
|
tCar.setAddObjectId(UserExt.getUser().getObjectId());
|
}
|
tCar.setInsertTime(new Date());
|
tCar.setState(1);
|
tCarService.save(tCar);
|
|
//添加经营业务 Add business operations.
|
String[] serverArray = serverBox.split(",");
|
for (int i=0;i<serverArray.length;i++){
|
TCarService service = new TCarService();
|
service.setCarId(tCar.getId());
|
service.setType(Integer.valueOf(serverArray[i]));
|
if (1 == service.getType()){
|
service.setServerCarModelId(Integer.valueOf(zcModel));
|
}else if (3 == service.getType()){
|
service.setServerCarModelId(Integer.valueOf(kcModel));
|
}
|
tCarServiceService.save(service);
|
}
|
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){//上传数据
|
// pushMinistryOfTransportUtil.baseInfoCompanyStat();
|
// pushMinistryOfTransportUtil.baseInfoVehicle(tCar.getId());
|
// }
|
// }
|
// }).start();
|
return ResultUtil.success();
|
}
|
|
/**
|
* 删除车辆管理
|
*/
|
@RequestMapping(value = "/delete")
|
@ResponseBody
|
public Object delete(@RequestParam Integer tCarId) {
|
TCar tCar = tCarService.getById(tCarId);
|
tCar.setState(2);
|
tCarService.updateById(tCar);
|
|
//清除相对应的司机关联车辆ID Remove the corresponding driver-associated vehicle ID.
|
List<TDriverReq> list = driverClient.queryDriverListByCarId(tCarId);
|
for (TDriverReq obj : list){
|
obj.setCarId(null);
|
driverClient.updateById(obj);
|
}
|
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){//上传数据
|
// pushMinistryOfTransportUtil.baseInfoCompanyStat();
|
// pushMinistryOfTransportUtil.baseInfoVehicle(tCar.getId());
|
// }
|
// }
|
// }).start();
|
return SUCCESS_TIP;
|
}
|
|
/**
|
* 修改车辆管理
|
*/
|
@RequestMapping(value = "/update")
|
@ResponseBody
|
public Object update(TCar tCar,@RequestParam String serverBox,Integer roleType,Integer companyType,Integer oneId,Integer twoId,Integer franchiseeId,String zcModel,String kcModel) {
|
TCar tCar1 = tCarService.getBaseMapper().selectOne(new QueryWrapper<TCar>().eq("carLicensePlate", tCar.getCarLicensePlate()).eq("state", 1));
|
if(null != tCar1 && tCar1.getId().compareTo(tCar.getId()) != 0){
|
return ResultUtil.error(UserExt.getLanguage() == 1 ? "车牌号重复" : UserExt.getLanguage() == 2 ? "Duplicate license plate" : "Kode kendaraan diulangi.");
|
}
|
if (1 == roleType){ //平台 platfrom
|
if (2 == companyType.intValue()){
|
if (SinataUtil.isNotEmpty(oneId)){
|
tCar.setCompanyId(oneId);
|
}
|
if (SinataUtil.isNotEmpty(twoId)){
|
tCar.setFranchiseeId(twoId);
|
}
|
}else if (1 == companyType.intValue()){
|
// TCompany company = tCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1));
|
CompanyInfoRes company = companyClient.queryByTypeCompany(1).get(0);
|
tCar.setCompanyId(company.getId());
|
tCar.setFranchiseeId(0);
|
}
|
}else if (2 == roleType){ //分公司 sub company
|
if (SinataUtil.isNotEmpty(UserExt.getUser().getObjectId())){
|
tCar.setCompanyId(UserExt.getUser().getObjectId());
|
}
|
if (SinataUtil.isNotEmpty(franchiseeId)){
|
tCar.setFranchiseeId(franchiseeId);
|
}
|
}else if (3 == roleType){ //加盟商 Franchisee
|
CompanyInfoRes tCompany = companyClient.queryById(UserExt.getUser().getObjectId());
|
if (SinataUtil.isNotEmpty(tCompany)){
|
tCar.setCompanyId(tCompany.getSuperiorId());
|
}
|
if (SinataUtil.isNotEmpty(UserExt.getUser().getObjectId())){
|
tCar.setFranchiseeId(UserExt.getUser().getObjectId());
|
}
|
}
|
|
//删除业务 Delete business
|
tCarServiceService.remove(new QueryWrapper<TCarService>().eq("carId",tCar.getId()));
|
|
//添加经营业务 add business
|
String[] serverArray = serverBox.split(",");
|
for (int i=0;i<serverArray.length;i++){
|
TCarService service = new TCarService();
|
service.setCarId(tCar.getId());
|
service.setType(Integer.valueOf(serverArray[i]));
|
if (1 == service.getType()){
|
service.setServerCarModelId(Integer.valueOf(zcModel));
|
}else if (3 == service.getType()){
|
service.setServerCarModelId(Integer.valueOf(kcModel));
|
}
|
tCarServiceService.save(service);
|
}
|
|
tCarService.updateById(tCar);
|
// new Thread(new Runnable() {
|
// @Override
|
// public void run() {
|
// if(pushMinistryOfTransport){
|
// pushMinistryOfTransportUtil.baseInfoVehicle(tCar.getId());
|
// }
|
// }
|
// }).start();
|
return ResultUtil.success();
|
}
|
|
/**
|
* 车辆管理详情
|
*/
|
@RequestMapping(value = "/detail/{tCarId}")
|
@ResponseBody
|
public Object detail(@PathVariable("tCarId") Integer tCarId) {
|
return tCarService.getById(tCarId);
|
}
|
|
/**
|
* 下载模板
|
* @param request
|
* @param response
|
*/
|
@RequestMapping(value = "/uploadCarModel")
|
public void uploadCarModel(HttpServletRequest request, HttpServletResponse response) {
|
// 表格数据【封装】 Table datas
|
List<List<String>> dataList = new ArrayList<List<String>>();
|
Integer language = UserExt.getLanguage();
|
if(language==1){
|
// 首行【封装】 first line
|
List<String> shellList = new ArrayList<String>();
|
shellList.add("所属机构[平台车辆/加盟车辆]");
|
shellList.add("所属分公司[提示:加盟车辆选填]");
|
shellList.add("所属加盟商[提示:加盟车辆选填]");
|
shellList.add("服务模式:摩托车车[是/否]");
|
shellList.add("服务模式:同城快送[是/否]");
|
shellList.add("车辆品牌");
|
shellList.add("车辆类型");
|
shellList.add("车辆颜色[1(黑色)/2(银色)/3(白色)/4(红色)/5(黄色)/6(橙色)/7(蓝色)]");
|
shellList.add("车牌号");
|
shellList.add("行驶证编号");
|
shellList.add("年检到期时间[例如 2020-02-02]");
|
shellList.add("商业保险到期时间[例如 2020-02-02]");
|
dataList.add(shellList);
|
|
try {
|
// 调用工具类进行导出 Invoke the utility class to carry out data export.
|
ExcelExportUtil.easySheet("平台导入车辆模板"+DateUtil.format(new Date(), "YYYYMMddHHmmss"), "平台导入车辆模板", dataList, request, response);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}else if(language==2){
|
// 首行【封装】 first line
|
List<String> shellList = new ArrayList<String>();
|
shellList.add("Affiliated Organization [Platform Vehicle/Franchised Vehicle]");
|
shellList.add("Affiliated branch [Tip: Select for franchised vehicle]");
|
shellList.add("Franchisee [Tip: Select Franchised vehicle]");
|
shellList.add("Service mode: Motorcycle [Yes/No]");
|
shellList.add("Service mode: intra-city express [Yes/No]");
|
shellList.add("Vehicle brand");
|
shellList.add("Vehicle type");
|
shellList.add("Vehicle color [1(Black)/2(Silver)/3(white)/4(red)/5(yellow)/6(orange)/7(Blue)]");
|
shellList.add("License plate number");
|
shellList.add("License number");
|
shellList.add("Annual inspection expiration time [e.g. 2020-02-02]");
|
shellList.add("Commercial Insurance Expiration Time [e.g. 2020-02-02]");
|
dataList.add(shellList);
|
|
try {
|
// 调用工具类进行导出 Invoke the utility class to carry out data export.
|
ExcelExportUtil.easySheet("Platform import vehicle template"+DateUtil.format(new Date(), "YYYYMMddHHmmss"), "Platform import vehicle template", dataList, request, response);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}else {
|
// 首行【封装】 first line
|
List<String> shellList = new ArrayList<String>();
|
shellList.add("Organisasi Berkait [Platform Vehicle/Franchised Vehicle]");
|
shellList.add("Branch terkait [Tip: Pilih untuk kendaraan terkait]");
|
shellList.add("Franchisee [Tip: Pilih kendaraan Franchised]");
|
shellList.add("Mod layanan: Motosikal [Ya/Tidak]");
|
shellList.add("Modus layanan: ekspres intra-kota [Ya/Tidak]");
|
shellList.add("Tanda kendaraan");
|
shellList.add("Jenis kendaraan");
|
shellList.add("Warna kendaraan [1(Hitam)/2(Perak)/3(putih)/4(merah)/5(kuning)/6(oranye)/7(Biru)]");
|
shellList.add("Nomor plat lisensi");
|
shellList.add("Nomor lisensi");
|
shellList.add("Waktu penggantian inspeksi tahunan [contohnya 2020-02-02]");
|
shellList.add("Waktu Expiration Insurance Commercial [contohnya 2020-02-02]");
|
dataList.add(shellList);
|
|
try {
|
// 调用工具类进行导出 Invoke the utility class to carry out data export.
|
ExcelExportUtil.easySheet("templat kendaraan import platform"+DateUtil.format(new Date(), "YYYYMMddHHmmss"), "templat kendaraan import platform", dataList, request, response);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
|
|
}
|
|
|
/**
|
* 导入操作
|
* @param request
|
* @return
|
*/
|
@RequestMapping(value="/exportCar",method = RequestMethod.POST)
|
@ResponseBody
|
public Object exportCar(HttpServletRequest request){
|
Integer language = UserExt.getLanguage();
|
if(language==1) {
|
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
|
MultipartFile file = (MultipartFile) multipartRequest.getFile("myfile");
|
try {
|
//定时五秒后执行 Execute after five seconds on schedule.
|
/*Map<String,Object> maps=new HashMap<>();
|
Workbook book = WoUtil.ImportFile(file);
|
maps.put("book",book);
|
QuartzManager.addJob(AddContract.class, (AddContract.name+new Date().getTime()).toUpperCase(), TimeJobType.ADMIN,DateUtil.getDate_strYMdHms(new Date().getTime() + 1*1000) , maps);*/
|
|
Workbook book = WoUtil.ImportFile(file);
|
Sheet sh = book.getSheetAt(0); //获取到第一个表 get first table
|
for (int i = 1; i <= sh.getLastRowNum(); i++) {
|
Row row = sh.getRow(i);
|
|
Cell cell0 = row.getCell(0); //所属机构[平台车辆/加盟车辆] Affiliated Organization [Platform Vehicles/Franchise Vehicles]
|
String zero = null;
|
if (SinataUtil.isNotEmpty(cell0)) {
|
zero = String.valueOf(cell0.getStringCellValue()).trim();
|
}
|
|
Cell cell1 = row.getCell(1); //所属分公司[提示:加盟车辆选填] Affiliated branch company [Note: Franchise vehicles are optional].
|
String one = null;
|
|
if (SinataUtil.isNotEmpty(cell1)) {
|
cell1.setCellType(Cell.CELL_TYPE_STRING);
|
one = String.valueOf(cell1.getStringCellValue()).trim();
|
}
|
|
Cell cell2 = row.getCell(2); //所属加盟商[提示:加盟车辆选填] Affiliated Franchise [Note: Franchise vehicles are optional].
|
String two = null;
|
if (SinataUtil.isNotEmpty(cell2)) {
|
two = String.valueOf(cell2.getStringCellValue()).trim();
|
}
|
|
Cell cell3 = row.getCell(3); //服务模式:专车[是/否] Business mode: dedicated vehicle [yes/no]
|
String three = null;
|
if (SinataUtil.isNotEmpty(cell3)) {
|
three = String.valueOf(cell3.getStringCellValue()).trim();
|
}
|
|
Cell cell4 = row.getCell(4); //服务模式:出租车[是/否] Business mode: taxi [yes/no]
|
String four = null;
|
if (SinataUtil.isNotEmpty(cell4)) {
|
four = String.valueOf(cell4.getStringCellValue()).trim();
|
}
|
|
Cell cell5 = row.getCell(5); //服务模式:跨城出行[是/否] Business mode: cross-city [yes/no]
|
String five = null;
|
if (SinataUtil.isNotEmpty(cell5)) {
|
five = String.valueOf(cell5.getStringCellValue()).trim();
|
}
|
|
Cell cell6 = row.getCell(6); //服务模式:小件跨城物流[是/否] Business mode: small-scale logistics [yes/no]
|
String six = null;
|
if (SinataUtil.isNotEmpty(cell6)) {
|
six = String.valueOf(cell6.getStringCellValue()).trim();
|
}
|
|
Cell cell7 = row.getCell(7); //服务模式:小件跨城物流[是/否] Business mode: small-scale logistics [yes/no]
|
String seven = null;
|
if (SinataUtil.isNotEmpty(cell7)) {
|
seven = String.valueOf(cell7.getStringCellValue()).trim();
|
}
|
|
Cell cell8 = row.getCell(8); //服务模式:包车[是/否] Service mode: Chartered service [Yes/No]
|
cell8.setCellType(Cell.CELL_TYPE_STRING);
|
String eight = null;
|
if (SinataUtil.isNotEmpty(cell8)) {
|
eight = String.valueOf(cell8.getStringCellValue()).trim();
|
}
|
|
Cell cell9 = row.getCell(9); //车辆品牌 car brand
|
cell9.setCellType(Cell.CELL_TYPE_STRING);
|
String nine = null;
|
if (SinataUtil.isNotEmpty(cell9)) {
|
nine = String.valueOf(cell9.getStringCellValue()).trim();
|
}
|
|
Cell cell10 = row.getCell(10); //车辆类型 car type
|
cell10.setCellType(Cell.CELL_TYPE_STRING);
|
|
String ten = null;
|
if (SinataUtil.isNotEmpty(cell10)) {
|
ten = String.valueOf(cell10.getStringCellValue()).trim();
|
}
|
|
Cell cell11 = row.getCell(11); //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色] Vehicle color options include black, silver, white, red, yellow, orange, and blue.
|
cell11.setCellType(Cell.CELL_TYPE_STRING);
|
String eleven = null;
|
if (SinataUtil.isNotEmpty(cell11)) {
|
eleven = String.valueOf(cell11.getStringCellValue()).trim();
|
}
|
|
|
if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
|
|| SinataUtil.isEmpty(five) || SinataUtil.isEmpty(six) || SinataUtil.isEmpty(seven)
|
|| SinataUtil.isEmpty(eight) || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
|
|| SinataUtil.isEmpty(eleven)) {
|
return new ErrorTip(500, "单元格不能为空");
|
} else {
|
//判断所属机构 Determine the affiliated organization.
|
if (!zero.equals("平台车辆") && !zero.equals("加盟车辆")) {
|
return new ErrorTip(500, "所属机构内容不正确");
|
}
|
//判断服务模式【专车】 Assessing the Service Mode "Private Car
|
if (!three.equals("是") && !three.equals("否")) {
|
return new ErrorTip(500, "服务模式【摩托车】内容不正确");
|
}
|
//判断服务模式【出租车】Assessing the Service Mode "taxi Car
|
if (!four.equals("是") && !four.equals("否")) {
|
return new ErrorTip(500, "服务模式【同城快送】内容不正确");
|
}
|
//判断车辆颜色Assessing the car colors
|
if (!seven.equals("1") && !seven.equals("2") && !seven.equals("3") && !seven.equals("4") && !seven.equals("5") && !seven.equals("6") && !seven.equals("7")) {
|
return new ErrorTip(500, "车辆颜色内容不正确");
|
}
|
//判断年检到期时间格式是否正确 Verify if the format of the expiration date for inspection is correct.
|
try {
|
if (!isValidDate(ten)) {
|
ten = importByExcelForDate(ten);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "年检到期时间格式不正确");
|
}
|
//判断商业保险到期时间格式是否正确 Check whether the expiration date format of the commercial insurance is correct.
|
try {
|
if (!isValidDate(eleven)) {
|
eleven = importByExcelForDate(eleven);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "商业保险到期时间格式不正确");
|
}
|
|
//查找平台公司 Search for platform companies
|
// TCompany platCompany = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes platCompany = companyClient.queryByTypeAndFlg(new CompanyQueryTypeAndFlgReq(1, 3));
|
Integer companyId = platCompany.getId();
|
Integer franchiseeId = 0;
|
if ("加盟车辆".equals(zero)) {
|
//判断所属分公司是否存在 Check if the subsidiary company exists
|
if (SinataUtil.isNotEmpty(one)) {
|
// TCompany company = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("name", one).eq("type", 2).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes company = companyClient.queryByTypeAndFlgAndName(new CompanyQueryTypeAndFlgAndNameReq(2, 3, one));
|
if (SinataUtil.isNotEmpty(company)) {
|
companyId = company.getId();
|
//判断加盟商是否存在 Assessing the existence of a franchisee
|
if (SinataUtil.isNotEmpty(two)) {
|
// TCompany franchisee = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("superiorId",company.getId()).eq("name", two).eq("type", 3).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes franchisee = companyClient.queryBySuperiorIdAndTypeAndFlgAndName(new CompanyQuerySuperiorIdAndTypeAndFlgAndNameReq(3, 3, two, company.getId()));
|
if (SinataUtil.isNotEmpty(franchisee)) {
|
franchiseeId = franchisee.getId();
|
}
|
}
|
}
|
}
|
}
|
|
Integer carBrandId = null;
|
Integer carModelId = null;
|
//查找品牌 search brand
|
if (SinataUtil.isNotEmpty(five)) {
|
TCarBrand carBrand = tCarBrandService.getOne(new QueryWrapper<TCarBrand>().eq("name", five).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carBrand)) {
|
carBrandId = carBrand.getId();
|
if (SinataUtil.isNotEmpty(six)) {
|
//查找类型 search type
|
TCarModel carModel = tCarModelService.getOne(new QueryWrapper<TCarModel>().eq("brandId", carBrand.getId()).eq("name", six).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carModel)) {
|
carModelId = carModel.getId();
|
}
|
}
|
}
|
}
|
|
//添加车辆对象 add vechcle obj
|
TCar car = new TCar();
|
if ("平台车辆".equals(zero)) {
|
car.setIsPlatCar(1);
|
} else if ("加盟车辆".equals(zero)) {
|
car.setIsPlatCar(2);
|
}
|
car.setCompanyId(companyId);
|
car.setFranchiseeId(franchiseeId);
|
car.setCarColor(seven);
|
car.setCarBrandId(carBrandId);
|
car.setCarModelId(carModelId);
|
car.setCarLicensePlate(eight);
|
car.setDrivingLicenseNumber(nine);
|
car.setAnnualInspectionTime(DateUtil.parseDate(ten));
|
car.setCommercialInsuranceTime(DateUtil.parseDate(eleven));
|
car.setInsertTime(new Date());
|
car.setState(1);
|
if (UserExt.getUser().getRoleType() == 1) {
|
car.setAddType(2);
|
} else if (UserExt.getUser().getRoleType() == 2) {
|
car.setAddType(3);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
} else if (UserExt.getUser().getRoleType() == 3) {
|
car.setAddType(4);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
}
|
tCarService.save(car);
|
|
//添加专车服务模式 add special car service
|
if ("是".equals(three)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(1);
|
tCarServiceService.save(service);
|
}
|
//添加小件同城物流服务模式 add small-scale local-city service model
|
if ("是".equals(four)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(4);
|
tCarServiceService.save(service);
|
}
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return SUCCESS_TIP;
|
}else if(language==2){
|
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
|
MultipartFile file = (MultipartFile) multipartRequest.getFile("myfile");
|
try {
|
//定时五秒后执行 execute after 5s on schedule
|
/*Map<String,Object> maps=new HashMap<>();
|
Workbook book = WoUtil.ImportFile(file);
|
maps.put("book",book);
|
QuartzManager.addJob(AddContract.class, (AddContract.name+new Date().getTime()).toUpperCase(), TimeJobType.ADMIN,DateUtil.getDate_strYMdHms(new Date().getTime() + 1*1000) , maps);*/
|
|
Workbook book = WoUtil.ImportFile(file);
|
Sheet sh = book.getSheetAt(0); //获取到第一个表 get first table
|
for (int i = 1; i <= sh.getLastRowNum(); i++) {
|
Row row = sh.getRow(i);
|
|
Cell cell0 = row.getCell(0); //所属机构[平台车辆/加盟车辆] Affiliated Organization [Platform Vehicles/Franchise Vehicles]
|
String zero = null;
|
if (SinataUtil.isNotEmpty(cell0)) {
|
zero = String.valueOf(cell0.getStringCellValue()).trim();
|
}
|
|
Cell cell1 = row.getCell(1); //所属分公司[提示:加盟车辆选填] Affiliated branch company [Note: Franchise vehicles are optional].
|
String one = null;
|
if (SinataUtil.isNotEmpty(cell1)) {
|
cell1.setCellType(Cell.CELL_TYPE_STRING);
|
one = String.valueOf(cell1.getStringCellValue()).trim();
|
}
|
|
Cell cell2 = row.getCell(2); //所属加盟商[提示:加盟车辆选填]Affiliated Franchise [Note: Franchise vehicles are optional].
|
String two = null;
|
if (SinataUtil.isNotEmpty(cell2)) {
|
two = String.valueOf(cell2.getStringCellValue()).trim();
|
}
|
|
Cell cell3 = row.getCell(3); //服务模式:专车[是/否]Business mode: dedicated vehicle [yes/no]
|
String three = null;
|
if (SinataUtil.isNotEmpty(cell3)) {
|
three = String.valueOf(cell3.getStringCellValue()).trim();
|
}
|
|
Cell cell4 = row.getCell(4); //服务模式:出租车[是/否]Business mode: taxi [yes/no]
|
String four = null;
|
if (SinataUtil.isNotEmpty(cell4)) {
|
four = String.valueOf(cell4.getStringCellValue()).trim();
|
}
|
|
Cell cell5 = row.getCell(5); //服务模式:跨城出行[是/否]Business mode: cross-city [yes/no]
|
String five = null;
|
if (SinataUtil.isNotEmpty(cell5)) {
|
five = String.valueOf(cell5.getStringCellValue()).trim();
|
}
|
|
Cell cell6 = row.getCell(6); //服务模式:小件跨城物流[是/否]Business mode: small-scale logistics [yes/no]
|
String six = null;
|
if (SinataUtil.isNotEmpty(cell6)) {
|
six = String.valueOf(cell6.getStringCellValue()).trim();
|
}
|
|
Cell cell7 = row.getCell(7); //服务模式:小件跨城物流[是/否]Business mode: small-scale logistics [yes/no]
|
String seven = null;
|
if (SinataUtil.isNotEmpty(cell7)) {
|
seven = String.valueOf(cell7.getStringCellValue()).trim();
|
}
|
|
Cell cell8 = row.getCell(8); //服务模式:包车[是/否]Service mode: Chartered service [Yes/No]
|
cell8.setCellType(Cell.CELL_TYPE_STRING);
|
String eight = null;
|
if (SinataUtil.isNotEmpty(cell8)) {
|
eight = String.valueOf(cell8.getStringCellValue()).trim();
|
}
|
|
Cell cell9 = row.getCell(9); //车辆品牌car brand
|
cell9.setCellType(Cell.CELL_TYPE_STRING);
|
String nine = null;
|
if (SinataUtil.isNotEmpty(cell9)) {
|
nine = String.valueOf(cell9.getStringCellValue()).trim();
|
}
|
|
Cell cell10 = row.getCell(10); //车辆类型 car type
|
cell10.setCellType(Cell.CELL_TYPE_STRING);
|
|
String ten = null;
|
if (SinataUtil.isNotEmpty(cell10)) {
|
ten = String.valueOf(cell10.getStringCellValue()).trim();
|
}
|
|
Cell cell11 = row.getCell(11); //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]Vehicle color options include black, silver, white, red, yellow, orange, and blue.
|
cell11.setCellType(Cell.CELL_TYPE_STRING);
|
String eleven = null;
|
if (SinataUtil.isNotEmpty(cell11)) {
|
eleven = String.valueOf(cell11.getStringCellValue()).trim();
|
}
|
|
|
if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
|
|| SinataUtil.isEmpty(five) || SinataUtil.isEmpty(six) || SinataUtil.isEmpty(seven)
|
|| SinataUtil.isEmpty(eight) || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
|
|| SinataUtil.isEmpty(eleven)) {
|
return new ErrorTip(500, "Cells cannot be empty");
|
} else {
|
//判断所属机构 Determine the affiliated organization.
|
if (!zero.equals("Platform vehicle") && !zero.equals("Franchised vehicle")) {
|
return new ErrorTip(500, "The organization content is incorrect");
|
}
|
//判断服务模式【专车】Assessing the Service Mode "Private Car
|
if (!three.equals("yes") && !three.equals("no")) {
|
return new ErrorTip(500, "Service mode [motorcycle] content is incorrect");
|
}
|
//判断服务模式【出租车】Assessing the Service Mode "taxi
|
if (!four.equals("yes") && !four.equals("no")) {
|
return new ErrorTip(500, "Service mode [Intra-city Express] content is incorrect");
|
}
|
//判断车辆颜色 Assessing the color
|
if (!seven.equals("1") && !seven.equals("2") && !seven.equals("3") && !seven.equals("4") && !seven.equals("5") && !seven.equals("6") && !seven.equals("7")) {
|
return new ErrorTip(500, "The vehicle color content is incorrect");
|
}
|
//判断年检到期时间格式是否正确 Verify if the format of the expiration date for inspection is correct.
|
try {
|
if (!isValidDate(ten)) {
|
ten = importByExcelForDate(ten);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "The format of the annual inspection expiration time is incorrect");
|
}
|
//判断商业保险到期时间格式是否正确 Check whether the expiration date format of the commercial insurance is correct.
|
try {
|
if (!isValidDate(eleven)) {
|
eleven = importByExcelForDate(eleven);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "The format of commercial insurance expiration time is incorrect");
|
}
|
|
//查找平台公司 Search for platform companies
|
// TCompany platCompany = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes platCompany = companyClient.queryByTypeAndFlg(new CompanyQueryTypeAndFlgReq(1, 3));
|
Integer companyId = platCompany.getId();
|
Integer franchiseeId = 0;
|
if ("Franchised vehicle".equals(zero)) {
|
//判断所属分公司是否存在 Checking if the subsidiary company exists.
|
if (SinataUtil.isNotEmpty(one)) {
|
// TCompany company = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("name", one).eq("type", 2).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes company = companyClient.queryByTypeAndFlgAndName(new CompanyQueryTypeAndFlgAndNameReq(2, 3, one));
|
if (SinataUtil.isNotEmpty(company)) {
|
companyId = company.getId();
|
//判断加盟商是否存在 Assessing the existence of a franchisee
|
if (SinataUtil.isNotEmpty(two)) {
|
// TCompany franchisee = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("superiorId",company.getId()).eq("name", two).eq("type", 3).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes franchisee = companyClient.queryBySuperiorIdAndTypeAndFlgAndName(new CompanyQuerySuperiorIdAndTypeAndFlgAndNameReq(3, 3, two, company.getId()));
|
if (SinataUtil.isNotEmpty(franchisee)) {
|
franchiseeId = franchisee.getId();
|
}
|
}
|
}
|
}
|
}
|
|
Integer carBrandId = null;
|
Integer carModelId = null;
|
//查找品牌 search brand
|
if (SinataUtil.isNotEmpty(five)) {
|
TCarBrand carBrand = tCarBrandService.getOne(new QueryWrapper<TCarBrand>().eq("name", five).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carBrand)) {
|
carBrandId = carBrand.getId();
|
if (SinataUtil.isNotEmpty(six)) {
|
//查找类型 search type
|
TCarModel carModel = tCarModelService.getOne(new QueryWrapper<TCarModel>().eq("brandId", carBrand.getId()).eq("name", six).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carModel)) {
|
carModelId = carModel.getId();
|
}
|
}
|
}
|
}
|
|
//添加车辆对象 add vechcle obj
|
TCar car = new TCar();
|
if ("Platform vehicle".equals(zero)) {
|
car.setIsPlatCar(1);
|
} else if ("Franchised vehicle".equals(zero)) {
|
car.setIsPlatCar(2);
|
}
|
car.setCompanyId(companyId);
|
car.setFranchiseeId(franchiseeId);
|
car.setCarColor(seven);
|
car.setCarBrandId(carBrandId);
|
car.setCarModelId(carModelId);
|
car.setCarLicensePlate(eight);
|
car.setDrivingLicenseNumber(nine);
|
car.setAnnualInspectionTime(DateUtil.parseDate(ten));
|
car.setCommercialInsuranceTime(DateUtil.parseDate(eleven));
|
car.setInsertTime(new Date());
|
car.setState(1);
|
if (UserExt.getUser().getRoleType() == 1) {
|
car.setAddType(2);
|
} else if (UserExt.getUser().getRoleType() == 2) {
|
car.setAddType(3);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
} else if (UserExt.getUser().getRoleType() == 3) {
|
car.setAddType(4);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
}
|
tCarService.save(car);
|
|
//添加专车服务模式
|
if ("yes".equals(three)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(1);
|
tCarServiceService.save(service);
|
}
|
//添加小件同城物流服务模式
|
if ("yes".equals(four)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(4);
|
tCarServiceService.save(service);
|
}
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return SUCCESS_TIP;
|
}else {
|
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
|
MultipartFile file = (MultipartFile) multipartRequest.getFile("myfile");
|
try {
|
//定时五秒后执行
|
/*Map<String,Object> maps=new HashMap<>();
|
Workbook book = WoUtil.ImportFile(file);
|
maps.put("book",book);
|
QuartzManager.addJob(AddContract.class, (AddContract.name+new Date().getTime()).toUpperCase(), TimeJobType.ADMIN,DateUtil.getDate_strYMdHms(new Date().getTime() + 1*1000) , maps);*/
|
|
Workbook book = WoUtil.ImportFile(file);
|
Sheet sh = book.getSheetAt(0); //获取到第一个表 get first table
|
for (int i = 1; i <= sh.getLastRowNum(); i++) {
|
Row row = sh.getRow(i);
|
|
Cell cell0 = row.getCell(0); //所属机构[平台车辆/加盟车辆] Affiliated Organization [Platform Vehicles/Franchise Vehicles]
|
String zero = null;
|
if (SinataUtil.isNotEmpty(cell0)) {
|
zero = String.valueOf(cell0.getStringCellValue()).trim();
|
}
|
|
Cell cell1 = row.getCell(1); //所属分公司[提示:加盟车辆选填]Affiliated Organization [Platform Vehicles/Franchise Vehicles]
|
String one = null;
|
if (SinataUtil.isNotEmpty(cell1)) {
|
cell1.setCellType(Cell.CELL_TYPE_STRING);
|
one = String.valueOf(cell1.getStringCellValue()).trim();
|
}
|
|
Cell cell2 = row.getCell(2); //所属加盟商[提示:加盟车辆选填]Affiliated Franchise [Platform Vehicles/Franchise Vehicles]
|
String two = null;
|
if (SinataUtil.isNotEmpty(cell2)) {
|
two = String.valueOf(cell2.getStringCellValue()).trim();
|
}
|
|
Cell cell3 = row.getCell(3); //服务模式:专车[是/否]Business mode: dedicated vehicle [yes/no]
|
String three = null;
|
if (SinataUtil.isNotEmpty(cell3)) {
|
three = String.valueOf(cell3.getStringCellValue()).trim();
|
}
|
|
Cell cell4 = row.getCell(4); //服务模式:出租车[是/否] Business mode: taxi [yes/no]
|
String four = null;
|
if (SinataUtil.isNotEmpty(cell4)) {
|
four = String.valueOf(cell4.getStringCellValue()).trim();
|
}
|
|
Cell cell5 = row.getCell(5); //服务模式:跨城出行[是/否] Business mode: cross-city [yes/no]
|
String five = null;
|
if (SinataUtil.isNotEmpty(cell5)) {
|
five = String.valueOf(cell5.getStringCellValue()).trim();
|
}
|
|
Cell cell6 = row.getCell(6); //服务模式:小件跨城物流[是/否]Business mode: small-scale logistics [yes/no]
|
String six = null;
|
if (SinataUtil.isNotEmpty(cell6)) {
|
six = String.valueOf(cell6.getStringCellValue()).trim();
|
}
|
|
Cell cell7 = row.getCell(7); //服务模式:小件跨城物流[是/否]Business mode: small-scale logistics [yes/no]
|
String seven = null;
|
if (SinataUtil.isNotEmpty(cell7)) {
|
seven = String.valueOf(cell7.getStringCellValue()).trim();
|
}
|
|
Cell cell8 = row.getCell(8); //服务模式:包车[是/否]Service mode: Chartered service [Yes/No]
|
cell8.setCellType(Cell.CELL_TYPE_STRING);
|
String eight = null;
|
if (SinataUtil.isNotEmpty(cell8)) {
|
eight = String.valueOf(cell8.getStringCellValue()).trim();
|
}
|
|
Cell cell9 = row.getCell(9); //车辆品牌 car brand
|
cell9.setCellType(Cell.CELL_TYPE_STRING);
|
String nine = null;
|
if (SinataUtil.isNotEmpty(cell9)) {
|
nine = String.valueOf(cell9.getStringCellValue()).trim();
|
}
|
|
Cell cell10 = row.getCell(10); //车辆类型
|
cell10.setCellType(Cell.CELL_TYPE_STRING);
|
|
String ten = null;
|
if (SinataUtil.isNotEmpty(cell10)) {
|
ten = String.valueOf(cell10.getStringCellValue()).trim();
|
}
|
|
Cell cell11 = row.getCell(11); //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]Vehicle color options include black, silver, white, red, yellow, orange, and blue.
|
cell11.setCellType(Cell.CELL_TYPE_STRING);
|
String eleven = null;
|
if (SinataUtil.isNotEmpty(cell11)) {
|
eleven = String.valueOf(cell11.getStringCellValue()).trim();
|
}
|
|
|
if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
|
|| SinataUtil.isEmpty(five) || SinataUtil.isEmpty(six) || SinataUtil.isEmpty(seven)
|
|| SinataUtil.isEmpty(eight) || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
|
|| SinataUtil.isEmpty(eleven)) {
|
return new ErrorTip(500, "Sel tidak dapat kosong");
|
} else {
|
//判断所属机构
|
if (!zero.equals("Mobil platform") && !zero.equals("Kendaraan yang dibersihkan")) {
|
return new ErrorTip(500, "isi organisasi tidak benar");
|
}
|
//判断服务模式【专车】
|
if (!three.equals("ya") && !three.equals("Tidak")) {
|
return new ErrorTip(500, "Konten mode layanan [motor] tidak benar");
|
}
|
//判断服务模式【出租车】
|
if (!four.equals("ya") && !four.equals("Tidak")) {
|
return new ErrorTip(500, "Konten mode layanan [Intra-city Express] tidak benar");
|
}
|
//判断车辆颜色
|
if (!seven.equals("1") && !seven.equals("2") && !seven.equals("3") && !seven.equals("4") && !seven.equals("5") && !seven.equals("6") && !seven.equals("7")) {
|
return new ErrorTip(500, "Konten warna kendaraan tidak benar");
|
}
|
//判断年检到期时间格式是否正确
|
try {
|
if (!isValidDate(ten)) {
|
ten = importByExcelForDate(ten);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "Format waktu penggantian inspeksi tahunan tidak benar");
|
}
|
//判断商业保险到期时间格式是否正确
|
try {
|
if (!isValidDate(eleven)) {
|
eleven = importByExcelForDate(eleven);
|
}
|
} catch (Exception e) {
|
return new ErrorTip(500, "Format waktunya kehabisan asuransi komersial tidak benar");
|
}
|
|
//查找平台公司 Search for platform companies
|
// TCompany platCompany = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes platCompany = companyClient.queryByTypeAndFlg(new CompanyQueryTypeAndFlgReq(1, 3));
|
Integer companyId = platCompany.getId();
|
Integer franchiseeId = 0;
|
if ("Kendaraan yang dibersihkan".equals(zero)) {
|
//判断所属分公司是否存在 Checking if the subsidiary company exists.
|
if (SinataUtil.isNotEmpty(one)) {
|
// TCompany company = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("name", one).eq("type", 2).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes company = companyClient.queryByTypeAndFlgAndName(new CompanyQueryTypeAndFlgAndNameReq(2, 3, one));
|
if (SinataUtil.isNotEmpty(company)) {
|
companyId = company.getId();
|
//判断加盟商是否存在 Assessing the existence of a franchisee
|
if (SinataUtil.isNotEmpty(two)) {
|
// TCompany franchisee = itCompanyService.selectOne(new EntityWrapper<TCompany>().eq("superiorId",company.getId()).eq("name", two).eq("type", 3).notIn("flag", "3").last(" limit 1"));
|
CompanyInfoRes franchisee = companyClient.queryBySuperiorIdAndTypeAndFlgAndName(new CompanyQuerySuperiorIdAndTypeAndFlgAndNameReq(3, 3, two, company.getId()));
|
if (SinataUtil.isNotEmpty(franchisee)) {
|
franchiseeId = franchisee.getId();
|
}
|
}
|
}
|
}
|
}
|
|
Integer carBrandId = null;
|
Integer carModelId = null;
|
//查找品牌 search brand
|
if (SinataUtil.isNotEmpty(five)) {
|
TCarBrand carBrand = tCarBrandService.getOne(new QueryWrapper<TCarBrand>().eq("name", five).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carBrand)) {
|
carBrandId = carBrand.getId();
|
if (SinataUtil.isNotEmpty(six)) {
|
//查找类型 search type
|
TCarModel carModel = tCarModelService.getOne(new QueryWrapper<TCarModel>().eq("brandId", carBrand.getId()).eq("name", six).eq("state", 1).last(" limit 1"));
|
if (SinataUtil.isNotEmpty(carModel)) {
|
carModelId = carModel.getId();
|
}
|
}
|
}
|
}
|
|
//添加车辆对象 add vechcle obj
|
TCar car = new TCar();
|
if ("Mobil platform".equals(zero)) {
|
car.setIsPlatCar(1);
|
} else if ("Kendaraan yang dibersihkan".equals(zero)) {
|
car.setIsPlatCar(2);
|
}
|
car.setCompanyId(companyId);
|
car.setFranchiseeId(franchiseeId);
|
car.setCarColor(seven);
|
car.setCarBrandId(carBrandId);
|
car.setCarModelId(carModelId);
|
car.setCarLicensePlate(eight);
|
car.setDrivingLicenseNumber(nine);
|
car.setAnnualInspectionTime(DateUtil.parseDate(ten));
|
car.setCommercialInsuranceTime(DateUtil.parseDate(eleven));
|
car.setInsertTime(new Date());
|
car.setState(1);
|
if (UserExt.getUser().getRoleType() == 1) {
|
car.setAddType(2);
|
} else if (UserExt.getUser().getRoleType() == 2) {
|
car.setAddType(3);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
} else if (UserExt.getUser().getRoleType() == 3) {
|
car.setAddType(4);
|
car.setAddObjectId(UserExt.getUser().getObjectId());
|
}
|
tCarService.save(car);
|
|
//添加专车服务模式
|
if ("ya".equals(three)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(1);
|
tCarServiceService.save(service);
|
}
|
//添加小件同城物流服务模式
|
if ("ya".equals(four)) {
|
TCarService service = new TCarService();
|
service.setCarId(car.getId());
|
service.setType(4);
|
tCarServiceService.save(service);
|
}
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return SUCCESS_TIP;
|
}
|
}
|
|
/**
|
* 判断日期是否满足yyyy-MM-dd格式
|
* @param str
|
* @return
|
*/
|
public static boolean isValidDate(String str) {
|
boolean convertSuccess=true;
|
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
|
try {
|
format.setLenient(false);
|
format.parse(str);
|
} catch (Exception e) {
|
convertSuccess=false;
|
}
|
return convertSuccess;
|
}
|
|
|
/**
|
* 转换日期
|
* @return
|
*/
|
public static String importByExcelForDate(String value) {//value就是它的天数
|
String currentCellValue = "";
|
if(value != null && !value.equals("")){
|
Calendar calendar = new GregorianCalendar(1900,0,-1);
|
Date d = calendar.getTime();
|
Date dd = DateUtils.addDays(d,Integer.valueOf(value));
|
DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
|
currentCellValue = formater.format(dd);
|
}
|
return currentCellValue;
|
}
|
|
/**
|
* 导出车辆信息
|
*/
|
@RequestMapping(value = "/outCar")
|
public void outCar(HttpServletRequest request, HttpServletResponse response) {
|
List<Map<String,Object>> listMap = tCarService.getCarList(null,UserExt.getUser().getRoleType(),UserExt.getUser().getObjectId(),null,null,null,null,null,null,null,null,null,null,null);
|
|
// 表格数据【封装】
|
List<List<String>> dataList = new ArrayList<>();
|
|
//第一行显示【封装】
|
List<String> twoList = new ArrayList<String>();
|
twoList.add("总计:");
|
twoList.add(String.valueOf(listMap.size())+"条");
|
dataList.add(twoList);
|
|
// 列【封装】
|
List<String> shellList = new ArrayList<String>();
|
shellList.add("添加时间");
|
shellList.add("车辆ID");
|
shellList.add("所属机构");
|
shellList.add("车辆品牌");
|
shellList.add("车辆类型");
|
shellList.add("颜色");
|
shellList.add("服务模式");
|
shellList.add("车牌号");
|
shellList.add("行驶证号码");
|
shellList.add("关联司机");
|
shellList.add("年检到期时间");
|
shellList.add("商业保险到期时间");
|
shellList.add("车辆剩余电量");
|
dataList.add(shellList);
|
|
for (Map<String,Object> object : listMap){
|
// 详细数据列【封装】 detail
|
shellList = new ArrayList<String>();
|
if(SinataUtil.isNotEmpty(object.get("insertTime"))){
|
shellList.add(DateUtil.format(DateUtil.parse(object.get("insertTime").toString(),"YYYY-MM-dd HH:mm:ss.S"), "YYYY-MM-dd HH:mm:ss"));
|
}else{
|
shellList.add("-");
|
}
|
shellList.add(String.valueOf(object.get("id")));
|
|
if(SinataUtil.isNotEmpty(object.get("companyName"))){
|
shellList.add(object.get("companyName").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("brandName"))){
|
shellList.add(object.get("brandName").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("modelName"))){
|
shellList.add(object.get("modelName").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("carColor"))){
|
shellList.add(object.get("carColor").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("serverStr"))){
|
shellList.add(object.get("serverStr").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("carLicensePlate"))){
|
shellList.add(object.get("carLicensePlate").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("drivingLicenseNumber"))){
|
shellList.add(object.get("drivingLicenseNumber").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("driverName"))){
|
shellList.add(object.get("driverName").toString());
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("annualInspectionTime"))){
|
shellList.add(DateUtil.format(DateUtil.parse(object.get("annualInspectionTime").toString(),"YYYY-MM-dd HH:mm:ss.S"), "YYYY-MM-dd HH:mm:ss"));
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("commercialInsuranceTime"))){
|
shellList.add(DateUtil.format(DateUtil.parse(object.get("commercialInsuranceTime").toString(),"YYYY-MM-dd HH:mm:ss.S"), "YYYY-MM-dd HH:mm:ss"));
|
}else{
|
shellList.add("-");
|
}
|
if(SinataUtil.isNotEmpty(object.get("power"))){
|
shellList.add(object.get("power").toString());
|
}else{
|
shellList.add("-");
|
}
|
dataList.add(shellList);
|
}
|
try {
|
// 调用工具类进行导出
|
ExcelExportUtil.easySheet("车辆信息导出记录"+DateUtil.format(new Date(), "YYYYMMddHHmmss"), "车辆信息导出记录", dataList,request, response);
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
|
}
|
