后台异常订单 车

liujie

6 天以前 60d755ccd24c740509562c59385578d601cd4e46

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

@@ -1,6 +1,7 @@
package com.stylefeng.guns.modular.system.controller.general;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.stylefeng.guns.core.base.controller.BaseController;
import com.stylefeng.guns.core.base.tips.ErrorTip;
@@ -16,6 +17,7 @@
import com.stylefeng.guns.modular.system.util.ExcelExportUtil;
import com.stylefeng.guns.modular.system.util.PushMinistryOfTransportUtil;
import com.stylefeng.guns.modular.system.util.ResultUtil;
import com.sun.org.apache.bcel.internal.generic.NEW;
import org.apache.commons.lang.time.DateUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
@@ -58,9 +60,6 @@
    private ITCarServiceService tCarServiceService;

    @Autowired
    private ITDriverLineService tDriverLineService;

    @Autowired
    private ITCarBrandService tCarBrandService;

    @Autowired
@@ -83,7 +82,7 @@
    
    @Resource
    private CarInsuranceMapper carInsuranceMapper;
    @Resource
    @Autowired
    private ShiroExtUtil shiroExtUtil;
    
    
@@ -319,6 +318,9 @@
    }





    /**
     * 获取保险列表
     * @param carId
@@ -395,7 +397,7 @@
     */
    @RequestMapping(value = "/add")
    @ResponseBody
    public Object add(TCar tCar,@RequestParam String serverBox,Integer roleType,Integer companyType,Integer oneId,Integer twoId,Integer franchiseeId,String zcModel,String kcModel) {
    public Object add(TCar tCar,@RequestParam String serverBox,Integer roleType,Integer companyType,Integer oneId,Integer twoId,Integer franchiseeId,String zcModel,String kcModel,String bindDriverId) {
        if (1 == roleType){  //平台
            if (2 == companyType.intValue()){
                if (SinataUtil.isNotEmpty(oneId)){
@@ -435,6 +437,7 @@
        }
        tCar.setInsertTime(new Date());
        tCar.setState(1);
        tCar.setBindDriverId(bindDriverId);
        tCarService.insert(tCar);

        //添加经营业务
@@ -491,13 +494,26 @@
        }).start();
        return SUCCESS_TIP;
    }

    @ResponseBody
    @RequestMapping(value = "/selectDriverFromCompanyId", method = RequestMethod.POST)
    public Object selectDriverFromCompanyId(Integer companyId){
        Wrapper<TDriver> companyId1 = new EntityWrapper<TDriver>().eq("companyId", companyId).eq("authState", 2).ne("flag", 3);
        List<TDriver> tDrivers = tDriverService.selectList(companyId1);
        ArrayList<Map<String, Object>> list = new ArrayList<>();
        for (TDriver tDriver : tDrivers){
            HashMap<String, Object> map = new HashMap<>();
            map.put("id", tDriver.getId());
            map.put("name", tDriver.getName());
            list.add(map);
        }
        return list;
    }
    /**
     * 修改车辆管理
     */
    @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) {
    public Object update(TCar tCar,@RequestParam String serverBox,Integer roleType,Integer companyType,Integer oneId,Integer twoId,Integer franchiseeId,String zcModel,String kcModel,String bindDriverId) {
        if (1 == roleType){  //平台
            if (2 == companyType.intValue()){
                if (SinataUtil.isNotEmpty(oneId)){
@@ -580,6 +596,10 @@
        obj.setGPSModel(tCar.getGPSModel());
        obj.setRegisterDate(tCar.getRegisterDate());
        obj.setCommercialType(tCar.getCommercialType());
        if(bindDriverId==null){
            bindDriverId="";
        }
        obj.setBindDriverId(bindDriverId);
        tCarService.updateAllColumnById(obj);
        new Thread(new Runnable() {
            @Override
@@ -619,9 +639,6 @@
        shellList.add("服务模式:快车[是/否]");
        shellList.add("服务模式:出租车[是/否]");
        shellList.add("服务模式:跨城出行[是/否]");
        shellList.add("服务模式:小件同城物流[是/否]");
        shellList.add("服务模式:小件跨城物流[是/否]");
        shellList.add("服务模式:包车[是/否]");
        shellList.add("车辆品牌");
        shellList.add("车辆类型");
        shellList.add("车辆颜色[黑色/银色/白色/红色/黄色/橙色/蓝色]");
@@ -665,102 +682,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 +882,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 +990,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);
                    }
                }