package com.stylefeng.guns.modular.system.controller;
|
|
import cn.hutool.core.bean.BeanUtil;
|
import cn.hutool.crypto.SecureUtil;
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.plugins.Page;
|
import com.stylefeng.guns.core.base.controller.BaseController;
|
import com.stylefeng.guns.core.util.DateUtil;
|
import com.stylefeng.guns.core.util.ToolUtil;
|
import com.stylefeng.guns.modular.system.model.TDriver;
|
import com.stylefeng.guns.modular.system.model.TDriverListVo;
|
import com.stylefeng.guns.modular.system.service.ITDriverService;
|
import com.stylefeng.guns.modular.system.utils.WoUtil;
|
import com.stylefeng.guns.modular.system.utils.tips.ErrorTip;
|
import com.stylefeng.guns.modular.system.utils.tips.SuccessTip;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiImplicitParam;
|
import io.swagger.annotations.ApiImplicitParams;
|
import io.swagger.annotations.ApiOperation;
|
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.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
|
/**
|
* 控制器
|
*
|
* @author fengshuonan
|
* @Date 2022-12-30 17:04:55
|
*/
|
@Controller
|
@Api(tags = "司机")
|
@RequestMapping("/api/driver")
|
public class DriverController extends BaseController {
|
|
@Autowired
|
private ITDriverService driverService;
|
|
|
|
@ApiOperation(value = "卡车公司-司机列表", notes = "卡车公司-司机列表")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
@ApiImplicitParam(name = "time", value = "2000-01-01 - 2000-11-11", required = false, dataType = "String"),
|
@ApiImplicitParam(name = "name", value = "name", required = false, dataType = "String"),
|
@ApiImplicitParam(name = "id", value = "id", required = true, dataType = "int"),
|
@ApiImplicitParam(name = "pageNumber", value = "pageNumber", required = true, dataType = "int"),
|
@ApiImplicitParam(name = "pageSize", value = "pageSize", required = true, dataType = "int"),
|
})
|
@GetMapping(value = "/driverList")
|
@ResponseBody
|
public Object driverList(String time, String name,int id, int pageNumber, int pageSize) {
|
String sTime = null;
|
String eTime = null;
|
EntityWrapper<TDriver> wrapper = new EntityWrapper<>();
|
Page<TDriver> tDriverPage = new Page<>(pageNumber, pageSize);
|
wrapper.eq("remove", 0);
|
wrapper.eq("is_carriers",1);
|
wrapper.eq("company_id",id);
|
if (ToolUtil.isNotEmpty(name)) {
|
wrapper.like("driver_name", name).or().like("account", name);
|
}
|
if (ToolUtil.isNotEmpty(time)) {
|
sTime = time.split(" - ")[0] + " 00:00:01";
|
eTime = time.split(" - ")[1] + " 23:59:59";
|
wrapper.between("create_time", sTime, eTime);
|
}
|
Page<TDriver> tDrivers = driverService.selectPage(tDriverPage, wrapper);
|
ArrayList<TDriverListVo> tDriverListVos = new ArrayList<>();
|
tDrivers.getRecords().stream().forEach(e -> {
|
TDriverListVo tDriverListVo = new TDriverListVo();
|
BeanUtil.copyProperties(e, tDriverListVo);
|
tDriverListVos.add(tDriverListVo);
|
});
|
|
Page<TDriverListVo> objectPage = new Page<>();
|
objectPage.setRecords(tDriverListVos);
|
BeanUtil.copyProperties(tDrivers, objectPage);
|
return new SuccessTip(objectPage);
|
}
|
|
|
@ApiOperation(value = "卡车公司-添加司机", notes = "卡车公司-添加司机")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
})
|
@PostMapping(value = "/driverAdd")
|
@ResponseBody
|
public Object driverAdd(@RequestBody TDriver driver) {
|
try {
|
driver.setCreateTime(new Date());
|
driverService.insert(driver);
|
return new SuccessTip();
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500, "Error");
|
}
|
}
|
|
@ApiOperation(value = "卡车公司-删除司机", notes = "卡车公司-删除司机")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
@ApiImplicitParam(name = "id", value = "id", required = true, dataType = "int"),
|
})
|
@GetMapping(value = "/driverDelete")
|
@ResponseBody
|
public Object driverDelete(int id) {
|
try {
|
TDriver tDriver = driverService.selectById(id);
|
tDriver.setRemove(1);
|
driverService.updateById(tDriver);
|
return new SuccessTip();
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500, "Error");
|
}
|
}
|
|
|
@ApiOperation(value = "卡车公司-获取司机详情", notes = "卡车公司-获取司机详情")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
@ApiImplicitParam(name = "id", value = "id", required = true, dataType = "int"),
|
})
|
@GetMapping(value = "/driverDetail")
|
@ResponseBody
|
public Object driverDetail(int id) {
|
try {
|
TDriver tDriver = driverService.selectById(id);
|
return new SuccessTip(tDriver);
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500, "Error");
|
}
|
}
|
|
|
@ApiOperation(value = "卡车公司-编辑司机", notes = "卡车公司-编辑司机")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
})
|
@PostMapping(value = "/driverUpdate")
|
@ResponseBody
|
public Object driverUpdate(@RequestBody TDriver driver) {
|
try {
|
driverService.updateById(driver);
|
return new SuccessTip();
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500, "Error");
|
}
|
}
|
|
/**
|
* 导入操作
|
*
|
* @param request
|
* @return
|
*/
|
@ApiOperation(value = "卡车公司-司机导入", notes = "卡车公司-司机导入")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
})
|
@RequestMapping(value = "/exportCar", method = RequestMethod.POST)
|
@ResponseBody
|
public Object exportCar(HttpServletRequest request, MultipartFile file) {
|
try {
|
Workbook book = WoUtil.ImportFile(file);
|
Sheet sh = book.getSheetAt(0); //获取到第一个表
|
for (int i = 1; i <= sh.getLastRowNum(); i++) {
|
Row row = sh.getRow(i);
|
|
Cell cell0 = row.getCell(0);
|
String zero = null;//司机名称
|
if (ToolUtil.isNotEmpty(cell0)) {
|
cell0.setCellType(Cell.CELL_TYPE_STRING);
|
zero = String.valueOf(cell0.getStringCellValue()).trim();
|
}
|
|
Cell cell1 = row.getCell(1);
|
String one = null;//Contact Number
|
|
if (ToolUtil.isNotEmpty(cell1)) {
|
cell1.setCellType(Cell.CELL_TYPE_STRING);
|
one = String.valueOf(cell1.getStringCellValue()).trim();
|
}
|
|
Cell cell2 = row.getCell(2);
|
String two = null;//Driver Number
|
if (ToolUtil.isNotEmpty(cell2)) {
|
cell2.setCellType(Cell.CELL_TYPE_STRING);
|
two = String.valueOf(cell2.getStringCellValue()).trim();
|
}
|
|
Cell cell3 = row.getCell(3);
|
String three = null;//Date of Birth
|
if (ToolUtil.isNotEmpty(cell3)) {
|
cell3.setCellType(Cell.CELL_TYPE_STRING);
|
three = String.valueOf(cell3.getStringCellValue()).trim();
|
}
|
|
Cell cell4 = row.getCell(4);
|
String four = null;//Address
|
if (ToolUtil.isNotEmpty(cell4)) {
|
cell4.setCellType(Cell.CELL_TYPE_STRING);
|
four = String.valueOf(cell4.getStringCellValue()).trim();
|
}
|
|
Cell cell5 = row.getCell(5);
|
String five = null;//Driver Type
|
if (ToolUtil.isNotEmpty(cell5)) {
|
cell5.setCellType(Cell.CELL_TYPE_STRING);
|
five = String.valueOf(cell5.getStringCellValue()).trim();
|
}
|
|
Cell cell6 = row.getCell(6);
|
String six = null;//Status
|
if (ToolUtil.isNotEmpty(cell6)) {
|
cell6.setCellType(Cell.CELL_TYPE_STRING);
|
six = String.valueOf(cell6.getStringCellValue()).trim();
|
}
|
|
Cell cell7 = row.getCell(7);
|
String seven = null;//StatusRemark
|
if (ToolUtil.isNotEmpty(cell7)) {
|
cell7.setCellType(Cell.CELL_TYPE_STRING);
|
seven = String.valueOf(cell7.getStringCellValue()).trim();
|
}
|
|
Cell cell8 = row.getCell(8);
|
if(cell8!=null){
|
cell8.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String eight = null;//Commercial Driiver Since Year
|
if (ToolUtil.isNotEmpty(cell8)) {
|
eight = String.valueOf(cell8.getStringCellValue()).trim();
|
}
|
|
Cell cell9 = row.getCell(9);
|
if(cell9!=null){
|
cell9.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String nine = null;//License Type
|
if (ToolUtil.isNotEmpty(cell9)) {
|
nine = String.valueOf(cell9.getStringCellValue()).trim();
|
}
|
|
Cell cell10 = row.getCell(10);
|
if(cell10!=null){
|
cell10.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
|
String ten = null;//CDL Number
|
if (ToolUtil.isNotEmpty(cell10)) {
|
ten = String.valueOf(cell10.getStringCellValue()).trim();
|
}
|
|
Cell cell11 = row.getCell(11);
|
if(cell11!=null){
|
cell11.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String eleven = null;//Driving School
|
if (ToolUtil.isNotEmpty(cell11)) {
|
eleven = String.valueOf(cell11.getStringCellValue()).trim();
|
}
|
|
Cell cell12 = row.getCell(12);
|
if(cell12!=null){
|
cell12.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twelve = null;//Type of Experience
|
if (ToolUtil.isNotEmpty(cell12)) {
|
twelve = String.valueOf(cell12.getStringCellValue()).trim();
|
}
|
|
Cell cell13 = row.getCell(13);
|
if(cell13!=null){
|
cell13.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String thirteen = null;//License Endorsements
|
if (ToolUtil.isNotEmpty(cell13)) {
|
thirteen = String.valueOf(cell13.getStringCellValue()).trim();
|
}
|
|
Cell cell14 = row.getCell(14);
|
if(cell14!=null){
|
cell14.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String fourteen = null;//Application Date
|
if (ToolUtil.isNotEmpty(cell14)) {
|
fourteen = String.valueOf(cell14.getStringCellValue()).trim();
|
}
|
|
Cell cell15 = row.getCell(15);
|
if(cell15!=null){
|
cell15.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String fifteen = null;//Termination Date
|
if (ToolUtil.isNotEmpty(cell15)) {
|
fifteen = String.valueOf(cell15.getStringCellValue()).trim();
|
}
|
|
Cell cell16 = row.getCell(16);
|
if(cell16!=null){
|
cell16.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String sixteen = null;//Bonus Eligibility Date
|
if (ToolUtil.isNotEmpty(cell16)) {
|
sixteen = String.valueOf(cell16.getStringCellValue()).trim();
|
}
|
|
Cell cell17 = row.getCell(17);
|
if(cell17!=null){
|
cell17.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String seventeen = null;//Hire Date
|
if (ToolUtil.isNotEmpty(cell17)) {
|
seventeen = String.valueOf(cell17.getStringCellValue()).trim();
|
}
|
Cell cell18 = row.getCell(18);
|
if(cell18!=null){
|
cell18.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String eighteen = null;//Rehirable
|
if (ToolUtil.isNotEmpty(cell18)) {
|
eighteen = String.valueOf(cell18.getStringCellValue()).trim();
|
}
|
Cell cell19 = row.getCell(19);
|
if(cell19!=null){
|
cell19.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String nineteen = null;//License Endorsements One
|
if (ToolUtil.isNotEmpty(cell19)) {
|
nineteen = String.valueOf(cell19.getStringCellValue()).trim();
|
}
|
Cell cell20 = row.getCell(20);
|
if(cell20!=null){
|
cell20.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twenty = null;//Insurance Co
|
if (ToolUtil.isNotEmpty(cell20)) {
|
twenty = String.valueOf(cell20.getStringCellValue()).trim();
|
}
|
Cell cell21 = row.getCell(21);
|
if(cell21!=null){
|
cell21.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyOne = null;//Id Number
|
if (ToolUtil.isNotEmpty(cell21)) {
|
twentyOne = String.valueOf(cell21.getStringCellValue()).trim();
|
}
|
Cell cell22 = row.getCell(22);
|
if(cell22!=null){
|
cell22.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyTwo = null;//Group Number
|
if (ToolUtil.isNotEmpty(cell22)) {
|
twentyTwo = String.valueOf(cell22.getStringCellValue()).trim();
|
}
|
Cell cell23 = row.getCell(23);
|
if(cell23!=null){
|
cell23.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyThree = null;//License Expiration Date
|
if (ToolUtil.isNotEmpty(cell23)) {
|
twentyThree = String.valueOf(cell23.getStringCellValue()).trim();
|
}
|
Cell cell24 = row.getCell(24);
|
if(cell24!=null){
|
cell24.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyFour = null;//Hazmat Endorsement Expiration Date
|
if (ToolUtil.isNotEmpty(cell24)) {
|
twentyFour = String.valueOf(cell24.getStringCellValue()).trim();
|
}
|
Cell cell25 = row.getCell(25);
|
if(cell25!=null){
|
cell25.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyFive = null;//Insurance Expiration Date
|
if (ToolUtil.isNotEmpty(cell25)) {
|
twentyFive = String.valueOf(cell25.getStringCellValue()).trim();
|
}
|
Cell cell26 = row.getCell(26);
|
if(cell26!=null){
|
cell26.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentySix = null;//Last Drug Test Date
|
if (ToolUtil.isNotEmpty(cell26)) {
|
twentySix = String.valueOf(cell26.getStringCellValue()).trim();
|
}
|
Cell cell27 = row.getCell(27);
|
if(cell27!=null){
|
cell27.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentySeven = null;//TWIC Card Expiration Date
|
if (ToolUtil.isNotEmpty(cell27)) {
|
twentySeven = String.valueOf(cell27.getStringCellValue()).trim();
|
}
|
Cell cell28 = row.getCell(28);
|
if(cell28!=null){
|
cell28.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyEight = null;//DOT Medical Card Expiration Date
|
if (ToolUtil.isNotEmpty(cell28)) {
|
twentyEight = String.valueOf(cell28.getStringCellValue()).trim();
|
}
|
Cell cell29 = row.getCell(29);
|
if(cell29!=null){
|
cell29.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String twentyNine = null;//Late Road Test Date
|
if (ToolUtil.isNotEmpty(cell29)) {
|
twentyNine = String.valueOf(cell29.getStringCellValue()).trim();
|
}
|
Cell cell30 = row.getCell(30);
|
if(cell30!=null){
|
cell30.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String thirty = null;//Last Alcogol Test Date
|
if (ToolUtil.isNotEmpty(cell30)) {
|
thirty = String.valueOf(cell30.getStringCellValue()).trim();
|
}
|
Cell cell31 = row.getCell(31);
|
if(cell31!=null){
|
cell31.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String thirtyOne = null;//Account
|
if (ToolUtil.isNotEmpty(cell31)) {
|
thirtyOne = String.valueOf(cell31.getStringCellValue()).trim();
|
}
|
Cell cell32 = row.getCell(32);
|
if(cell32!=null){
|
cell32.setCellType(Cell.CELL_TYPE_STRING);
|
}
|
String thirtyTwo = null;//Password
|
if (ToolUtil.isNotEmpty(cell32)) {
|
thirtyTwo = String.valueOf(cell32.getStringCellValue()).trim();
|
}
|
|
|
if (ToolUtil.isEmpty(thirtyOne) || ToolUtil.isEmpty(zero) || ToolUtil.isEmpty(one)
|
|| ToolUtil.isEmpty(thirtyTwo)) {
|
return new ErrorTip(500, "[Driver name、Contact number、Account、Password] can not be blank");
|
}
|
|
|
TDriver tDriver = new TDriver();
|
tDriver.setCreateTime(new Date());
|
tDriver.setRemove(0);
|
tDriver.setDriverName(zero);
|
tDriver.setContactNumber(one);
|
tDriver.setDriverNumber(two);
|
if (three != null) {
|
tDriver.setDateOfBrith(DateUtil.parseDate(three));
|
}
|
tDriver.setAddress(four);
|
if (five != null) {
|
tDriver.setDriverType(Integer.valueOf(five));
|
}
|
if (six != null) {
|
tDriver.setStatus(Integer.valueOf(six));
|
}
|
tDriver.setStatusRemark(seven);
|
tDriver.setSinceYear(eight);
|
tDriver.setLicenseType(nine);
|
tDriver.setCdlNumber(ten);
|
tDriver.setDrivingSchool(eleven);
|
tDriver.setTypeOfExperience(twelve);
|
tDriver.setLicenseEndorsements(thirteen);
|
|
if (fourteen != null) {
|
tDriver.setApplicationDate(DateUtil.parseDate(fourteen));
|
}
|
if (fifteen != null) {
|
tDriver.setTerminationDate(DateUtil.parseDate(fifteen));
|
}
|
if (sixteen != null) {
|
tDriver.setBonusEligibilityDate(DateUtil.parseDate(sixteen));
|
}
|
if (seventeen != null) {
|
tDriver.setHireDate(DateUtil.parseDate(seventeen));
|
}
|
tDriver.setRehirable(eighteen);
|
tDriver.setLicenseEndorsementsOne(nineteen);
|
tDriver.setInsuranceCo(twenty);
|
tDriver.setIdNumber(twentyOne);
|
tDriver.setGroupNumber(thirtyTwo);
|
if (twentyThree != null) {
|
tDriver.setLicenseExpirationDate(DateUtil.parseDate(twentyThree));
|
}
|
if (twentyFour != null) {
|
tDriver.setHazmatExpriationDate(DateUtil.parseDate(twentyFour));
|
}
|
if (twentyFive != null) {
|
tDriver.setInsuranceExpirationDate(DateUtil.parseDate(twentyFive));
|
}
|
if (twentySix != null) {
|
tDriver.setLastDrugTestDate(DateUtil.parseDate(twentySix));
|
}
|
if (twentySeven != null) {
|
tDriver.setTwicCardExpirationDate(DateUtil.parseDate(twentySeven));
|
}
|
if (twentyEight != null) {
|
tDriver.setDotCardExpirationDate(DateUtil.parseDate(twentyEight));
|
}
|
if (twentyNine != null) {
|
tDriver.setLastRoadTestDate(DateUtil.parseDate(twentyNine));
|
}
|
if (thirty != null) {
|
tDriver.setLastAlcoholTestDate(DateUtil.parseDate(thirty));
|
}
|
tDriver.setAccount(thirtyOne);
|
tDriver.setPassword(SecureUtil.md5(thirtyTwo));
|
List<TDriver> tDrivers = driverService.selectList(new EntityWrapper<TDriver>().eq("account", thirtyOne));
|
if(tDrivers.size()==0){
|
driverService.insert(tDriver);
|
}
|
}
|
return new SuccessTip();
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500,"Error");
|
}
|
}
|
|
/**
|
* 转换日期
|
*
|
* @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;
|
}
|
|
}
|
