修改三方对接逻辑和环境参数配置

Pu Zhibing

2025-07-08 91fcd48801ad1120651027824f7a60a14deadf87

 ManagementQYTTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TCarController.java

@@ -80,7 +80,7 @@
    
    @Resource
    private CarInsuranceMapper carInsuranceMapper;
    @Resource
    @Autowired
    private ShiroExtUtil shiroExtUtil;
    
    
@@ -659,79 +659,183 @@
                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 cell9 = row.getCell(6);  //车辆品牌
                String nine = null;
                if (SinataUtil.isNotEmpty(cell9)){
                    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(7);  //车辆类型
                String ten = null;
                if (SinataUtil.isNotEmpty(cell10)){
                    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(8);  //车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]
                String eleven = null;
                if (SinataUtil.isNotEmpty(cell11)){
                    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(9);  //车牌号
                String twelve = null;
                if (SinataUtil.isNotEmpty(cell12)){
                    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(10);  //行驶证编号
                String thirteen = null;
                if (SinataUtil.isNotEmpty(cell13)){
                    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(11);  //年检到期时间
                String fourteen = null;
                if (SinataUtil.isNotEmpty(cell14)){
                    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(12);  //商业保险到期时间
                String fifteen = null;
                if (SinataUtil.isNotEmpty(cell15)){
                    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)