package com.stylefeng.guns.modular.system.controller;
|
|
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.TCarriers;
|
import com.stylefeng.guns.modular.system.service.TCarriersService;
|
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.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.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* 控制器
|
*
|
* @author fengshuonan
|
* @Date 2023-01-09 09:51:51
|
*/
|
@Controller
|
@Api(tags = "承运商")
|
@RequestMapping("/api/tCarriers")
|
public class TCarriersController extends BaseController {
|
|
@Autowired
|
private TCarriersService carriersService;
|
|
|
/**
|
* 获取列表
|
*/
|
@ApiOperation(value = "卡车公司-承运商列表",notes="卡车公司-承运商列表")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
@ApiImplicitParam(name = "time", value = "xxxx - xxxx", required = false, dataType = "String",paramType = "query"),
|
@ApiImplicitParam(name = "name", value = "powerUnitNumber", required = false, dataType = "String",paramType = "query"),
|
@ApiImplicitParam(name = "pageNumber", value = "pageNumber", required = true, dataType = "int",paramType = "query"),
|
@ApiImplicitParam(name = "pageSize", value = "pageSize", required = true, dataType = "int",paramType = "query"),
|
})
|
@GetMapping(value = "/list")
|
@ResponseBody
|
public Object list(String time,String name,int pageNumber,int pageSize) {
|
Page<TCarriers> tCarriersPage = new Page<>(pageNumber, pageSize);
|
String sTime=null;
|
String eTime=null;
|
EntityWrapper<TCarriers> wrapper = new EntityWrapper<>();
|
wrapper.eq("remove",0);
|
if(ToolUtil.isNotEmpty(name)){
|
wrapper.like("company_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);
|
}
|
wrapper.orderBy("create_time",false);
|
Page<TCarriers> tCarriersPage1 = carriersService.selectPage(tCarriersPage, wrapper);
|
return new SuccessTip(tCarriersPage1);
|
}
|
|
|
|
@ApiOperation(value = "卡车公司-添加承运商",notes="卡车公司-添加承运商")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
})
|
@PostMapping(value = "/addCarriers")
|
@ResponseBody
|
public Object addCarriers(@RequestBody TCarriers tCarriers) {
|
tCarriers.setCreateTime(new Date());
|
return new SuccessTip();
|
}
|
|
@ApiOperation(value = "卡车公司-编辑承运商",notes="卡车公司-编辑承运商")
|
@ApiImplicitParams({
|
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
|
})
|
@PostMapping(value = "/updateCarriers")
|
@ResponseBody
|
public Object updateCarriers(@RequestBody TCarriers tCarriers) {
|
carriersService.updateById(tCarriers);
|
return new SuccessTip();
|
}
|
|
@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",paramType = "query"),
|
})
|
@GetMapping(value = "/deleteCarriers")
|
@ResponseBody
|
public Object deleteCarriers(int id) {
|
TCarriers tCarriers = carriersService.selectById(id);
|
tCarriers.setRemove(1);
|
carriersService.updateById(tCarriers);
|
return new SuccessTip();
|
}
|
|
|
/**
|
* 导入操作
|
*
|
* @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 = "/exportCarriers", method = RequestMethod.POST)
|
@ResponseBody
|
public Object exportCarriers(HttpServletRequest request, MultipartFile file,int id) {
|
try {
|
Workbook book = WoUtil.ImportFile(file);
|
Sheet sh = book.getSheetAt(0); //获取到第一个表
|
ArrayList<TCarriers> list = new ArrayList<>();
|
|
for (int i = 1; i <= sh.getLastRowNum(); i++) {
|
Row row = sh.getRow(i);
|
|
Cell cell0 = row.getCell(0);
|
String zero = null;//COMPANY NAME
|
if (ToolUtil.isNotEmpty(cell0)) {
|
cell0.setCellType(Cell.CELL_TYPE_STRING);
|
zero = String.valueOf(cell0.getStringCellValue()).trim();
|
}
|
|
Cell cell1 = row.getCell(1);
|
String one = null;//SCAC CODE
|
if (ToolUtil.isNotEmpty(cell1)) {
|
cell1.setCellType(Cell.CELL_TYPE_STRING);
|
one = String.valueOf(cell1.getStringCellValue()).trim();
|
}
|
|
Cell cell2 = row.getCell(2);
|
String two = null;//LOGO
|
if (ToolUtil.isNotEmpty(cell2)) {
|
cell2.setCellType(Cell.CELL_TYPE_STRING);
|
two = String.valueOf(cell2.getStringCellValue()).trim();
|
}
|
|
Cell cell3 = row.getCell(3);
|
String three = null;//CONTACT PHONE
|
if (ToolUtil.isNotEmpty(cell3)) {
|
cell3.setCellType(Cell.CELL_TYPE_STRING);
|
three = String.valueOf(cell3.getStringCellValue()).trim();
|
}
|
|
Cell cell4 = row.getCell(4);
|
String four = null;//CONTACT EMAIL
|
if (ToolUtil.isNotEmpty(cell4)) {
|
cell4.setCellType(Cell.CELL_TYPE_STRING);
|
four = String.valueOf(cell4.getStringCellValue()).trim();
|
}
|
|
Cell cell5 = row.getCell(5);
|
String five = null;//ADDRESS
|
if (ToolUtil.isNotEmpty(cell5)) {
|
cell5.setCellType(Cell.CELL_TYPE_STRING);
|
five = String.valueOf(cell5.getStringCellValue()).trim();
|
}
|
|
Cell cell6 = row.getCell(6);
|
String six = null;//MC NUMBER
|
if (ToolUtil.isNotEmpty(cell6)) {
|
cell6.setCellType(Cell.CELL_TYPE_STRING);
|
six = String.valueOf(cell6.getStringCellValue()).trim();
|
}
|
|
Cell cell7 = row.getCell(7);
|
String seven = null;//USDOT
|
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;//SET UP THE TIME
|
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;//LOGISTICS CONTACT NAME
|
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;//LOGISTICS CONTACT EMAIL
|
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;//POWER UNITS
|
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;//DRIVERS
|
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;//INSPECTIONS
|
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;//Commission
|
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;//BILL NUMBER
|
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;//ACCOUNT
|
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;//PASSWORD
|
if (ToolUtil.isNotEmpty(cell17)) {
|
seventeen = String.valueOf(cell17.getStringCellValue()).trim();
|
}
|
|
|
if (ToolUtil.isEmpty(one) || ToolUtil.isEmpty(two) || ToolUtil.isEmpty(three)
|
|| ToolUtil.isEmpty(four)|| ToolUtil.isEmpty(five) || ToolUtil.isEmpty(six) || ToolUtil.isEmpty(seven) || ToolUtil.isEmpty(eight) || ToolUtil.isEmpty(nine)
|
|| ToolUtil.isEmpty(ten) || ToolUtil.isEmpty(eleven) || ToolUtil.isEmpty(twelve)
|
|| ToolUtil.isEmpty(thirteen) || ToolUtil.isEmpty(fourteen) || ToolUtil.isEmpty(fifteen) || ToolUtil.isEmpty(sixteen) || ToolUtil.isEmpty(seventeen)) {
|
return new ErrorTip(500, "table can not be blank");
|
}
|
List<TCarriers> account = carriersService.selectList(new EntityWrapper<TCarriers>().eq("account", sixteen));
|
if(account.size()>0){
|
continue;
|
}
|
TCarriers tCarriers = new TCarriers();
|
tCarriers.setCompanyId(id);
|
tCarriers.setRemove(0);
|
tCarriers.setCompanyName(zero);
|
tCarriers.setScacCode(one);
|
tCarriers.setCompanyLogo(two);
|
tCarriers.setContactPhone(three);
|
tCarriers.setContactEmail(four);
|
tCarriers.setAddress(five);
|
tCarriers.setMcNumber(six);
|
tCarriers.setUsdot(seven);
|
Date date = DateUtil.parseDate(eight);
|
tCarriers.setSetUpTheTime(date);
|
tCarriers.setLogisticsContactName(nine);
|
tCarriers.setLogisticsContactEmail(ten);
|
tCarriers.setPowerUnits(eleven);
|
tCarriers.setDrivers(twelve);
|
tCarriers.setInspections(thirteen);
|
tCarriers.setCommission(Double.valueOf(fourteen));
|
tCarriers.setBillNumber(fifteen);
|
tCarriers.setAccount(sixteen);
|
tCarriers.setCreateTime(new Date());
|
tCarriers.setPassword(SecureUtil.md5(seventeen));
|
list.add(tCarriers);
|
}
|
if(list.size()>0){
|
|
carriersService.insertBatch(list);
|
}
|
return new SuccessTip();
|
} catch (Exception e) {
|
e.printStackTrace();
|
return new ErrorTip(500,"Error");
|
}
|
}
|
|
|
}
|
