From 60eb2f18aaf48a15d2af07918ceadff9cb650626 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 21 七月 2025 18:46:36 +0800
Subject: [PATCH] 后台异常订单模块
---
ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java | 206 +++++++++++++++++++++++++++++++--------------------
1 files changed, 126 insertions(+), 80 deletions(-)
diff --git a/ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java b/ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java
index 041d445..bb789a2 100644
--- a/ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java
+++ b/ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java
@@ -58,9 +58,6 @@
private ITCarServiceService tCarServiceService;
@Autowired
- private ITDriverLineService tDriverLineService;
-
- @Autowired
private ITCarBrandService tCarBrandService;
@Autowired
@@ -83,7 +80,7 @@
@Resource
private CarInsuranceMapper carInsuranceMapper;
- @Resource
+ @Autowired
private ShiroExtUtil shiroExtUtil;
@@ -619,9 +616,6 @@
shellList.add("服务模式:快车[是/否]");
shellList.add("服务模式:出租车[是/否]");
shellList.add("服务模式:跨城出行[是/否]");
- shellList.add("服务模式:小件同城物流[是/否]");
- shellList.add("服务模式:小件跨城物流[是/否]");
- shellList.add("服务模式:包车[是/否]");
shellList.add("车辆品牌");
shellList.add("车辆类型");
shellList.add("车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]");
@@ -665,102 +659,187 @@
Cell cell0 = row.getCell(0); //所属机构[平台车辆/加盟车辆]
String zero = null;
if (SinataUtil.isNotEmpty(cell0)){
- zero = String.valueOf(cell0.getStringCellValue()).trim();
+ int cellType = cell0.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ zero = cell0.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ zero = String.valueOf((long)cell0.getNumericCellValue()).trim();
+ break;
+ }
}
Cell cell1 = row.getCell(1); //所属分公司[提示:加盟车辆选填]
String one = null;
if (SinataUtil.isNotEmpty(cell1)){
- one = String.valueOf(cell1.getStringCellValue()).trim();
+ int cellType = cell1.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ one = cell1.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ one = String.valueOf((long)cell1.getNumericCellValue()).trim();
+ break;
+ }
}
Cell cell2 = row.getCell(2); //所属加盟商[提示:加盟车辆选填]
String two = null;
if (SinataUtil.isNotEmpty(cell2)){
- two = String.valueOf(cell2.getStringCellValue()).trim();
+ int cellType = cell2.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ two = cell2.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ two = String.valueOf((long)cell2.getNumericCellValue()).trim();
+ break;
+ }
}
Cell cell3 = row.getCell(3); //服务模式:快车[是/否]
String three = null;
if (SinataUtil.isNotEmpty(cell3)){
- three = String.valueOf(cell3.getStringCellValue()).trim();
+ int cellType = cell3.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ three = cell3.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ three = String.valueOf((long)cell3.getNumericCellValue()).trim();
+ break;
+ }
}
Cell cell4 = row.getCell(4); //服务模式:出租车[是/否]
String four = null;
if (SinataUtil.isNotEmpty(cell4)){
- four = String.valueOf(cell4.getStringCellValue()).trim();
+ int cellType = cell4.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ four = cell4.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ four = String.valueOf((long)cell4.getNumericCellValue()).trim();
+ break;
+ }
}
Cell cell5 = row.getCell(5); //服务模式:跨城出行[是/否]
String five = null;
if (SinataUtil.isNotEmpty(cell5)){
- five = String.valueOf(cell5.getStringCellValue()).trim();
+ int cellType = cell5.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ five = cell5.getStringCellValue().trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ five = String.valueOf((long)cell5.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell6 = row.getCell(6); //服务模式:小件跨城物流[是/否]
- String six = null;
- if (SinataUtil.isNotEmpty(cell6)){
- six = String.valueOf(cell6.getStringCellValue()).trim();
- }
-
- Cell cell7 = row.getCell(7); //服务模式:小件跨城物流[是/否]
- String seven = null;
- if (SinataUtil.isNotEmpty(cell7)){
- seven = String.valueOf(cell7.getStringCellValue()).trim();
- }
-
- Cell cell8 = row.getCell(8); //服务模式:包车[是/否]
- String eight = null;
- if (SinataUtil.isNotEmpty(cell8)){
- eight = String.valueOf(cell8.getStringCellValue()).trim();
- }
-
- Cell cell9 = row.getCell(9); //车辆品牌
+ Cell cell9 = row.getCell(6); //车辆品牌
String nine = null;
if (SinataUtil.isNotEmpty(cell9)){
- nine = String.valueOf(cell9.getStringCellValue()).trim();
+ int cellType = cell9.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ nine = String.valueOf(cell9.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ nine = String.valueOf((long)cell9.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell10 = row.getCell(10); //车辆类型
+ Cell cell10 = row.getCell(7); //车辆类型
String ten = null;
if (SinataUtil.isNotEmpty(cell10)){
- ten = String.valueOf(cell10.getStringCellValue()).trim();
+ int cellType = cell10.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ ten = String.valueOf(cell10.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ ten = String.valueOf((long)cell10.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell11 = row.getCell(11); //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]
+ Cell cell11 = row.getCell(8); //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]
String eleven = null;
if (SinataUtil.isNotEmpty(cell11)){
- eleven = String.valueOf(cell11.getStringCellValue()).trim();
+ int cellType = cell11.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ eleven = String.valueOf(cell11.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ eleven = String.valueOf((long)cell11.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell12 = row.getCell(12); //车牌号
+ Cell cell12 = row.getCell(9); //车牌号
String twelve = null;
if (SinataUtil.isNotEmpty(cell12)){
- twelve = String.valueOf(cell12.getStringCellValue()).trim();
+ int cellType = cell12.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ twelve = String.valueOf(cell12.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ twelve = String.valueOf((long)cell12.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell13 = row.getCell(13); //行驶证编号
+ Cell cell13 = row.getCell(10); //行驶证编号
String thirteen = null;
if (SinataUtil.isNotEmpty(cell13)){
- thirteen = String.valueOf(cell13.getStringCellValue()).trim();
+ int cellType = cell13.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ thirteen = String.valueOf(cell13.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ thirteen = String.valueOf((long)cell13.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell14 = row.getCell(14); //年检到期时间
+ Cell cell14 = row.getCell(11); //年检到期时间
String fourteen = null;
if (SinataUtil.isNotEmpty(cell14)){
- fourteen = String.valueOf(cell14.getStringCellValue()).trim();
+ int cellType = cell14.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ fourteen = String.valueOf(cell14.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ fourteen = String.valueOf((long)cell14.getNumericCellValue()).trim();
+ break;
+ }
}
- Cell cell15 = row.getCell(15); //商业保险到期时间
+ Cell cell15 = row.getCell(12); //商业保险到期时间
String fifteen = null;
if (SinataUtil.isNotEmpty(cell15)){
- fifteen = String.valueOf(cell15.getStringCellValue()).trim();
+ int cellType = cell15.getCellType();
+ switch (cellType) {
+ case Cell.CELL_TYPE_STRING:
+ fifteen = String.valueOf(cell15.getStringCellValue()).trim();
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ fifteen = String.valueOf((long)cell15.getNumericCellValue()).trim();
+ break;
+ }
}
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(five) || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
|| SinataUtil.isEmpty(eleven) || SinataUtil.isEmpty(twelve) || SinataUtil.isEmpty(thirteen)
|| SinataUtil.isEmpty(fourteen) || SinataUtil.isEmpty(fifteen)){
return new ErrorTip(500, "单元格不能为空");
@@ -780,18 +859,6 @@
//判断服务模式【跨城出行】
if (!five.equals("是") && !five.equals("否")){
return new ErrorTip(500, "服务模式【跨城出行】内容不正确");
- }
- //判断服务模式【小件同城物流】
- if (!six.equals("是") && !six.equals("否")){
- return new ErrorTip(500, "服务模式【小件同城物流】内容不正确");
- }
- //判断服务模式【小件跨城物流】
- if (!seven.equals("是") && !seven.equals("否")){
- return new ErrorTip(500, "服务模式【小件跨城物流】内容不正确");
- }
- //判断服务模式【包车】
- if (!eight.equals("是") && !eight.equals("否")){
- return new ErrorTip(500, "服务模式【包车】内容不正确");
}
//判断车辆颜色
if (!eleven.equals("黑色") && !eleven.equals("银色") && !eleven.equals("白色") && !eleven.equals("红色") && !eleven.equals("黄色") && !eleven.equals("橙色") && !eleven.equals("蓝色")){
@@ -900,27 +967,6 @@
TCarService service = new TCarService();
service.setCarId(car.getId());
service.setType(3);
- tCarServiceService.insert(service);
- }
- //添加小件同城物流服务模式
- if ("是".equals(six)){
- TCarService service = new TCarService();
- service.setCarId(car.getId());
- service.setType(4);
- tCarServiceService.insert(service);
- }
- //添加小件跨城物流服务模式
- if ("是".equals(seven)){
- TCarService service = new TCarService();
- service.setCarId(car.getId());
- service.setType(5);
- tCarServiceService.insert(service);
- }
- //添加包车服务模式
- if ("是".equals(eight)){
- TCarService service = new TCarService();
- service.setCarId(car.getId());
- service.setType(6);
tCarServiceService.insert(service);
}
}
--
Gitblit v1.7.1