package com.stylefeng.guns.modular.system.controller.general;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.stylefeng.guns.core.shiro.ShiroKit;
import com.stylefeng.guns.core.util.DateUtil;
import com.stylefeng.guns.core.util.SinataUtil;
import com.stylefeng.guns.core.util.ToolUtil;
import com.stylefeng.guns.core.util.WoUtil;
import com.stylefeng.guns.modular.system.model.*;
import com.stylefeng.guns.modular.system.service.*;
import com.stylefeng.guns.modular.system.util.ExcelExportUtil;
import com.stylefeng.guns.modular.system.util.ResultUtil;
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.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.*;

/**
* 车辆售卖
* @author pzb
* @Date 2022/5/30 19:31
*/
@Controller
@RequestMapping("/sellingCar")
public class SellingCarController {

    private String PREFIX = "/system/sellingCar/";

    @Autowired
    private ITCarBrandService carBrandService;

    @Autowired
    private ISellingCarService sellingCarService;

    @Autowired
    private ITRegionService regionService;
    
    @Autowired
    private ITUserService userService;
    
    @Autowired
    private ITDriverService driverService;
    
    @Autowired
    private ITCompanyService companyService;
    
    /**
     * 跳转到列表页
     *
     * @return
     */
    @GetMapping("/showSellingCarList")
    public String showSellingCarList(Model model) {
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        model.addAttribute("userType", ShiroKit.getUser().getRoleType());
        return PREFIX + "sellingCar.html";
    }

    /**
     * 跳转到添加页
     * @param model
     * @return
     */
    @GetMapping("/sellingCar_add")
    public String sellingCar_add(Model model) {
        model.addAttribute("push", ShiroKit.getUser().getRoleType() == 1 ? true : false);
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        List<TRegion> regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", 0));
        model.addAttribute("regions", regions);
        regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", regions.get(0).getId()));
        model.addAttribute("city", regions);
        return PREFIX + "sellingCar_add.html";
    }

    /**
     * 跳转到编辑页
     * @param model
     * @param id
     * @return
     */
    @GetMapping("/sellingCar_update")
    public String sellingCar_update(Model model, Integer id) {
        SellingCar sellingCar = sellingCarService.selectById(id);
        model.addAttribute("item", sellingCar);
        model.addAttribute("imgs", sellingCar.getImgUrl().split(","));
        model.addAttribute("videos", sellingCar.getVideoUrl().split(","));
        model.addAttribute("describeImgs", sellingCar.getDescribeImgUrl().split(","));
        model.addAttribute("push", ShiroKit.getUser().getRoleType() == 1 ? true : false);
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        List<TRegion> regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", 0));
        model.addAttribute("regions", regions);
        regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", regionService.selectOne(new EntityWrapper<TRegion>().eq("code", sellingCar.getProvinceCode())).getId()));
        model.addAttribute("city", regions);
        List<String> list = Arrays.asList("GPS导航", "倒车影像", "定速巡航", "多媒体控制", "前雷达", "全景摄像头", "胎压监测", "氙气大灯", "车内氛围灯", "车载电视", "铝合金轮圈", "车载冰箱", "行车显示屏", "运动座椅");
        List<Map<String, Object>> data = new ArrayList<>();
        String[] split = sellingCar.getInstallationConfiguration().split(",");
        for (String s : list) {
            Map<String, Object> map = new HashMap<>();
            map.put("name", s);
            map.put("selected", false);
            for (String s1 : split) {
                if(s.equals(s1)){
                    map.put("selected", true);
                    break;
                }
            }
            data.add(map);
        }
        model.addAttribute("installationConfiguration", data);
        return PREFIX + "sellingCar_edit.html";
    }

    /**
     * 跳转到详情页
     * @param model
     * @param id
     * @return
     */
    @GetMapping("/showSellingCarInfo")
    public String showSellingCarInfo(Model model, Integer id){
        SellingCar sellingCar = sellingCarService.selectById(id);
        model.addAttribute("item", sellingCar);
        model.addAttribute("imgs", ToolUtil.isNotEmpty(sellingCar.getImgUrl()) ? sellingCar.getImgUrl().split(",") : 0);
        model.addAttribute("videos", ToolUtil.isNotEmpty(sellingCar.getVideoUrl()) ? sellingCar.getVideoUrl().split(",") : "");
        model.addAttribute("describeImgs", ToolUtil.isNotEmpty(sellingCar.getDescribeImgUrl()) ? sellingCar.getDescribeImgUrl().split(",") : "");
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        List<TRegion> regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", 0));
        model.addAttribute("regions", regions);
        regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", regions.get(0).getId()));
        model.addAttribute("city", regions);
        List<String> list = Arrays.asList("GPS导航", "倒车影像", "定速巡航", "多媒体控制", "前雷达", "全景摄像头", "胎压监测", "氙气大灯", "车内氛围灯", "车载电视", "铝合金轮圈", "车载冰箱", "行车显示屏", "运动座椅");
        List<Map<String, Object>> data = new ArrayList<>();
        String[] split = sellingCar.getInstallationConfiguration().split(",");
        for (String s : list) {
            Map<String, Object> map = new HashMap<>();
            map.put("name", s);
            map.put("selected", false);
            for (String s1 : split) {
                if(s.equals(s1)){
                    map.put("selected", true);
                    break;
                }
            }
            data.add(map);
        }
        model.addAttribute("installationConfiguration", data);
        if(sellingCar.getUserType() == 1){
            TUser tUser = userService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tUser.getName());
            model.addAttribute("pushUserPhone", tUser.getPhone());
        }
        if(sellingCar.getUserType() == 2){
            TDriver tDriver = driverService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tDriver.getName());
            model.addAttribute("pushUserPhone", tDriver.getPhone());
        }
        if(sellingCar.getUserType() == 3){
            TCompany tCompany = companyService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tCompany.getName());
            model.addAttribute("pushUserPhone", tCompany.getPrincipalPhone());
        }
        return PREFIX + "sellingCar_info.html";
    }


    /**
     * 跳转到审核页面
     * @return
     */
    @GetMapping("/showAuditSellingCar")
    public String showAuditSellingCar(Model model){
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        return PREFIX + "auditSellingCar.html";
    }


    /**
     * 跳转到审核详情页
     * @param model
     * @param id
     * @return
     */
    @GetMapping("/showAuditSellingCar_info")
    public String showAuditSellingCar_info(Model model, Integer id){
        SellingCar sellingCar = sellingCarService.selectById(id);
        model.addAttribute("item", sellingCar);
        model.addAttribute("imgs", ToolUtil.isNotEmpty(sellingCar.getImgUrl()) ? sellingCar.getImgUrl().split(",") : 0);
        model.addAttribute("videos", ToolUtil.isNotEmpty(sellingCar.getVideoUrl()) ? sellingCar.getVideoUrl().split(",") : "");
        model.addAttribute("describeImgs", ToolUtil.isNotEmpty(sellingCar.getDescribeImgUrl()) ? sellingCar.getDescribeImgUrl().split(",") : "");
        List<TCarBrand> state = carBrandService.selectList(new EntityWrapper<TCarBrand>().eq("state", 1));
        model.addAttribute("carBrand", state);
        List<TRegion> regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", 0));
        model.addAttribute("regions", regions);
        regions = regionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", regions.get(0).getId()));
        model.addAttribute("city", regions);
        List<String> list = Arrays.asList("GPS导航", "倒车影像", "定速巡航", "多媒体控制", "前雷达", "全景摄像头", "胎压监测", "氙气大灯", "车内氛围灯", "车载电视", "铝合金轮圈", "车载冰箱", "行车显示屏", "运动座椅");
        List<Map<String, Object>> data = new ArrayList<>();
        String[] split = sellingCar.getInstallationConfiguration().split(",");
        for (String s : list) {
            Map<String, Object> map = new HashMap<>();
            map.put("name", s);
            map.put("selected", false);
            for (String s1 : split) {
                if(s.equals(s1)){
                    map.put("selected", true);
                    break;
                }
            }
            data.add(map);
        }
        model.addAttribute("installationConfiguration", data);
        if(sellingCar.getUserType() == 1){
            TUser tUser = userService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tUser.getName());
            model.addAttribute("pushUserPhone", tUser.getPhone());
        }
        if(sellingCar.getUserType() == 2){
            TDriver tDriver = driverService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tDriver.getName());
            model.addAttribute("pushUserPhone", tDriver.getPhone());
        }
        if(sellingCar.getUserType() == 3){
            TCompany tCompany = companyService.selectById(sellingCar.getUserId());
            model.addAttribute("pushUser", tCompany.getName());
            model.addAttribute("pushUserPhone", tCompany.getPrincipalPhone());
        }
        return PREFIX + "auditSellingCar_info.html";
    }



    /**
     * 获取列表数据
     * @param createTime
     * @param title
     * @param brandId
     * @param insertUser
     * @param status
     * @param userType
     * @param offset
     * @param limit
     * @return
     */
    @ResponseBody
    @PostMapping("/list")
    public Object list(String createTime, String carLicensePlate, Integer brandId, String insertUser, Integer status, Integer userType, Integer offset, Integer limit){
        try {
            List<Integer> state = Arrays.asList(2, 3, 4);
            if(null != status){
                state = Arrays.asList(status);
            }
            return sellingCarService.list(createTime, carLicensePlate, brandId, insertUser, state, userType, offset, limit);
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }

    /**
     * 添加数据
     * @param sellingCar
     * @return
     */
    @ResponseBody
    @PostMapping("/addSellingCar")
    public ResultUtil addSellingCar(SellingCar sellingCar){
        try {
            return sellingCarService.addSellingCar(sellingCar);
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }

    /**
     * 修改数据
     * @param sellingCar
     * @return
     */
    @ResponseBody
    @PostMapping("/updateSellingCar")
    public ResultUtil updateSellingCar(SellingCar sellingCar){
        try {
            return sellingCarService.updateSellingCar(sellingCar);
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }


    /**
     * 删除数据
     * @param id
     * @return
     */
    @ResponseBody
    @PostMapping("/deleteSellingCar")
    public ResultUtil deleteSellingCar(Integer id){
        try {
            SellingCar sellingCar = sellingCarService.selectById(id);
            sellingCar.setStatus(6);
            sellingCarService.updateById(sellingCar);
            return ResultUtil.success();
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }

    /**
     * 上架操作
     * @param id
     * @return
     */
    @ResponseBody
    @PostMapping("/onlineSellingCar")
    public ResultUtil onlineSellingCar(Integer id){
        try {
            SellingCar sellingCar = sellingCarService.selectById(id);
            if(sellingCar.getStatus() == 1){
                return ResultUtil.error("该数据还未审核");
            }
            if(sellingCar.getStatus() == 2){
                return ResultUtil.error("不允许重复操作");
            }
            sellingCar.setStatus(2);
            sellingCarService.updateById(sellingCar);
            return ResultUtil.success();
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }


    /**
     * 下架操作
     * @param id
     * @return
     */
    @ResponseBody
    @PostMapping("/offlineSellingCar")
    public ResultUtil offlineSellingCar(Integer id){
        try {
            SellingCar sellingCar = sellingCarService.selectById(id);
            if(sellingCar.getStatus() == 1){
                return ResultUtil.error("该数据还未审核");
            }
            if(sellingCar.getStatus() == 3){
                return ResultUtil.error("不允许重复操作");
            }
            sellingCar.setStatus(3);
            sellingCarService.updateById(sellingCar);
            return ResultUtil.success();
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }


    /**
     * 设置首页推荐
     * @param id
     * @return
     */
    @ResponseBody
    @PostMapping("/homeSellingCar")
    public ResultUtil homeSellingCar(Integer id){
        try {
            SellingCar sellingCar = sellingCarService.selectById(id);
            if(sellingCar.getStatus() == 1){
                return ResultUtil.error("该数据还未审核");
            }
            if(sellingCar.getStatus() == 3){
                return ResultUtil.error("该数据已下架");
            }
            if(sellingCar.getStatus() == 4){
                return ResultUtil.error("该数据还未上架");
            }
            if(sellingCar.getFirstPageShow() == 1){
                return ResultUtil.error("不允许重复操作");
            }
            int i = sellingCarService.selectCount(new EntityWrapper<SellingCar>().in("status", Arrays.asList(2, 3)).eq("firstPageShow", 1));
            if(i >= 6){
                return ResultUtil.error("首页推荐最多设置6个");
            }
            sellingCar.setFirstPageShow(1);
            sellingCarService.updateById(sellingCar);
            return ResultUtil.success();
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }

    /**
     * 取消首页推荐
     * @param id
     * @return
     */
    @ResponseBody
    @PostMapping("/cancelHomeSellingCar")
    public ResultUtil cancelHomeSellingCar(Integer id){
        try {
            SellingCar sellingCar = sellingCarService.selectById(id);
            if(sellingCar.getStatus() == 1){
                return ResultUtil.error("该数据还未审核");
            }
            if(sellingCar.getStatus() == 3){
                return ResultUtil.error("该数据已下架");
            }
            if(sellingCar.getStatus() == 4){
                return ResultUtil.error("该数据还未上架");
            }
            if(sellingCar.getFirstPageShow() == 2){
                return ResultUtil.error("不允许重复操作");
            }
            sellingCar.setFirstPageShow(2);
            sellingCarService.updateById(sellingCar);
            return ResultUtil.success();
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }


    /**
     * 下载导入模板
     * @param request
     * @param response
     */
    @RequestMapping(value = "/uploadSellingCarModel")
    public void uploadSellingCarModel(HttpServletRequest request, HttpServletResponse response) {
        // 表格数据【封装】
        List<List<String>> dataList = new ArrayList<List<String>>();

        // 首行【封装】
        List<String> shellList = new ArrayList<String>();
        shellList.add("用户类型[用户/司机/企业]");
        shellList.add("用户手机号/企业名称");
        shellList.add("标题");
        shellList.add("品牌名称");
        shellList.add("类别[非营运/营运]");
        shellList.add("车辆识别码");
        shellList.add("车牌号");
        shellList.add("车辆颜色");
        shellList.add("上牌时间[2020-01-01]");
        shellList.add("行驶里程");
        shellList.add("描述");
        shellList.add("描述图片地址[多个英文逗号分隔]");
        shellList.add("联系人");
        shellList.add("联系人电话");
        shellList.add("省");
        shellList.add("市");
        shellList.add("详细地址");
        shellList.add("车辆图片地址[多个英文逗号分隔]");
        shellList.add("车辆视频地址");
        shellList.add("牌照所在地");
        shellList.add("过户次数");
        shellList.add("排量");
        shellList.add("变速箱");
        shellList.add("等级[微型车/小型车/紧凑型车/中型车/大中型车/大型车/小型SUV/紧凑型SUV/中型SUV/大中型SUV/大型SUV/紧凑型MVP/中型MVP/大中型MVP/大型MVP/跑车/皮卡/微面/轻客/微卡]");
        shellList.add("车辆售价[20.5]");
        shellList.add("是否包含过户费[是/否]");
        shellList.add("新车价格[20.5]");
        shellList.add("交强险到期时间[2020-01-01]");
        shellList.add("年检到期时间[2020-01-01]");
        shellList.add("商业险到期时间[2020-01-01]");
        shellList.add("是否有抵押（是/否）");
        shellList.add("加装配置[GPS导航,倒车影像,定速巡航,多媒体控制,前雷达,全景摄像头,胎压监测,氙气大灯,车内氛围灯,车载电视,铝合金轮圈,车载冰箱,行车显示屏,运动座椅]");
        shellList.add("剩余营运时间[2020-01-01]");
        shellList.add("营运更新时间[2020-01-01]");
        dataList.add(shellList);

        try {
            // 调用工具类进行导出
            ExcelExportUtil.easySheet("车辆出售导入模板"+ DateUtil.formatDate(new Date(), "YYYYMMddHHmmss"), "车辆出售导入模板", dataList, request, response);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 导入数据
     * @param request
     * @return
     */
    @ResponseBody
    @PostMapping("/importSellingCar")
    public ResultUtil importSellingCar(HttpServletRequest request){
        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        MultipartFile file = (MultipartFile) multipartRequest.getFile("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 (SinataUtil.isNotEmpty(cell0)){
                    zero = String.valueOf(cell0.getStringCellValue()).trim();
                }

                Cell cell1 = row.getCell(1);  //用户名称
                String one = null;
                if (SinataUtil.isNotEmpty(cell1)){
                    one = String.valueOf(cell1.getStringCellValue()).trim();
                }

                Cell cell2 = row.getCell(2);  //标题
                String two = null;
                if (SinataUtil.isNotEmpty(cell2)){
                    two = String.valueOf(cell2.getStringCellValue()).trim();
                }

                Cell cell3 = row.getCell(3);  //品牌名称
                String three = null;
                if (SinataUtil.isNotEmpty(cell3)){
                    three = String.valueOf(cell3.getStringCellValue()).trim();
                }

                Cell cell4 = row.getCell(4);  //类别
                String four = null;
                if (SinataUtil.isNotEmpty(cell4)){
                    four = String.valueOf(cell4.getStringCellValue()).trim();
                }

                Cell cell5 = row.getCell(5);  //车辆识别码
                String five = null;
                if (SinataUtil.isNotEmpty(cell5)){
                    five = String.valueOf(cell5.getStringCellValue()).trim();
                }

                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);  //行驶里程
                String nine = null;
                if (SinataUtil.isNotEmpty(cell9)){
                    nine = String.valueOf(cell9.getStringCellValue()).trim();
                }

                Cell cell10 = row.getCell(10);  //描述
                String ten = null;
                if (SinataUtil.isNotEmpty(cell10)){
                    ten = String.valueOf(cell10.getStringCellValue()).trim();
                }

                Cell cell11 = row.getCell(11);  //描述图片地址
                String eleven = null;
                if (SinataUtil.isNotEmpty(cell11)){
                    eleven = String.valueOf(cell11.getStringCellValue()).trim();
                }

                Cell cell12 = row.getCell(12);  //联系人
                String twelve = null;
                if (SinataUtil.isNotEmpty(cell12)){
                    twelve = String.valueOf(cell12.getStringCellValue()).trim();
                }

                Cell cell13 = row.getCell(13);  //联系人电话
                String thirteen = null;
                if (SinataUtil.isNotEmpty(cell13)){
                    thirteen = String.valueOf(cell13.getStringCellValue()).trim();
                }

                Cell cell14 = row.getCell(14);  //省
                String fourteen = null;
                if (SinataUtil.isNotEmpty(cell14)){
                    fourteen = String.valueOf(cell14.getStringCellValue()).trim();
                }

                Cell cell15 = row.getCell(15);  //市
                String fifteen = null;
                if (SinataUtil.isNotEmpty(cell15)){
                    fifteen = String.valueOf(cell15.getStringCellValue()).trim();
                }

                Cell cell16 = row.getCell(16);  //详细地址
                String sixteen = null;
                if (SinataUtil.isNotEmpty(cell16)){
                    sixteen = String.valueOf(cell16.getStringCellValue()).trim();
                }

                Cell cell17 = row.getCell(17);  //车辆图片地址
                String seventeen = null;
                if (SinataUtil.isNotEmpty(cell17)){
                    seventeen = String.valueOf(cell17.getStringCellValue()).trim();
                }

                Cell cell18 = row.getCell(18);  //车辆视频地址
                String eighteen = null;
                if (SinataUtil.isNotEmpty(cell18)){
                    eighteen = String.valueOf(cell18.getStringCellValue()).trim();
                }

                Cell cell19 = row.getCell(19);  //牌照所在地
                String nineteen = null;
                if (SinataUtil.isNotEmpty(cell19)){
                    nineteen = String.valueOf(cell19.getStringCellValue()).trim();
                }

                Cell cell20 = row.getCell(20);  //过户次数
                String twenty = null;
                if (SinataUtil.isNotEmpty(cell20)){
                    twenty = String.valueOf(cell20.getStringCellValue()).trim();
                }

                Cell cell21 = row.getCell(21);  //排量
                String twentyOne = null;
                if (SinataUtil.isNotEmpty(cell21)){
                    twentyOne = String.valueOf(cell21.getStringCellValue()).trim();
                }

                Cell cell22 = row.getCell(22);  //变速箱
                String twentyTwo = null;
                if (SinataUtil.isNotEmpty(cell22)){
                    twentyTwo = String.valueOf(cell22.getStringCellValue()).trim();
                }

                Cell cell23 = row.getCell(23);  //等级
                String twentyThree = null;
                if (SinataUtil.isNotEmpty(cell23)){
                    twentyThree = String.valueOf(cell23.getStringCellValue()).trim();
                }

                Cell cell24 = row.getCell(24);  //车辆售价
                String twentyFour = null;
                if (SinataUtil.isNotEmpty(cell24)){
                    twentyFour = String.valueOf(cell24.getStringCellValue()).trim();
                }

                Cell cell25 = row.getCell(25);  //是否包含过户费(1=是，2=否)
                String twentyFive = null;
                if (SinataUtil.isNotEmpty(cell25)){
                    twentyFive = String.valueOf(cell25.getStringCellValue()).trim();
                }

                Cell cell26 = row.getCell(26);  //新车价格
                String twentySix = null;
                if (SinataUtil.isNotEmpty(cell26)){
                    twentySix = String.valueOf(cell26.getStringCellValue()).trim();
                }

                Cell cell27 = row.getCell(27);  //交强险到期时间
                String twentySeven = null;
                if (SinataUtil.isNotEmpty(cell27)){
                    twentySeven = String.valueOf(cell27.getStringCellValue()).trim();
                }

                Cell cell28 = row.getCell(28);  //年检到期时间
                String twentyEight = null;
                if (SinataUtil.isNotEmpty(cell28)){
                    twentyEight = String.valueOf(cell28.getStringCellValue()).trim();
                }

                Cell cell29 = row.getCell(29);  //商业险到期时间
                String twentyNine = null;
                if (SinataUtil.isNotEmpty(cell29)){
                    twentyNine = String.valueOf(cell29.getStringCellValue()).trim();
                }

                Cell cell30 = row.getCell(30);  //是否有抵押
                String thirty = null;
                if (SinataUtil.isNotEmpty(cell30)){
                    thirty = String.valueOf(cell30.getStringCellValue()).trim();
                }

                Cell cell31 = row.getCell(31);  //加装配置
                String thirtyOne = null;
                if (SinataUtil.isNotEmpty(cell31)){
                    thirtyOne = String.valueOf(cell31.getStringCellValue()).trim();
                }

                Cell cell32 = row.getCell(32);  //剩余营运时间
                String thirtyTwo = null;
                if (SinataUtil.isNotEmpty(cell32)){
                    thirtyTwo = String.valueOf(cell32.getStringCellValue()).trim();
                }

                Cell cell33 = row.getCell(33);  //营运更新时间
                String thirtyThree = null;
                if (SinataUtil.isNotEmpty(cell33)){
                    thirtyThree = String.valueOf(cell33.getStringCellValue()).trim();
                }


                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(eleven) || SinataUtil.isEmpty(twelve) || SinataUtil.isEmpty(thirteen)
                        || SinataUtil.isEmpty(fourteen) || SinataUtil.isEmpty(fifteen) || SinataUtil.isEmpty(sixteen)
                        || SinataUtil.isEmpty(seventeen) || SinataUtil.isEmpty(eighteen) || SinataUtil.isEmpty(nineteen)
                        || SinataUtil.isEmpty(twenty) || SinataUtil.isEmpty(twentyOne) || SinataUtil.isEmpty(twentyTwo)
                        || SinataUtil.isEmpty(twentyThree) || SinataUtil.isEmpty(twentyFour) || SinataUtil.isEmpty(twentyFive)
                        || SinataUtil.isEmpty(twentySix) || SinataUtil.isEmpty(twentySeven) || SinataUtil.isEmpty(twentyEight)
                        || SinataUtil.isEmpty(twentyNine) || SinataUtil.isEmpty(thirty)){
                    return ResultUtil.error("单元格不能为空");
                }else{
                    //判断所属机构
                    if (!zero.equals("用户") && !zero.equals("司机") && !zero.equals("企业")){
                        return ResultUtil.error("用户类型不正确");
                    }

                    Integer userType = 0;
                    Integer userId = null;
                    if("用户".equals(zero)){
                        TUser tUser = userService.selectOne(new EntityWrapper<TUser>().eq("phone", one).eq("flag", 1));
                        if(null == tUser){
                            return ResultUtil.error("用户手机号不正确");
                        }
                        userType = 1;
                        userId = tUser.getId();
                    }
                    if("司机".equals(zero)){
                        TDriver tDriver = driverService.selectOne(new EntityWrapper<TDriver>().eq("phone", one).eq("flag", 1));
                        if(null == tDriver){
                            return ResultUtil.error("司机手机号不正确");
                        }
                        userType = 2;
                        userId = tDriver.getId();
                    }
                    if("企业".equals(zero)){
                        TCompany tCompany = companyService.selectOne(new EntityWrapper<TCompany>().eq("name", one).eq("flag", 1));
                        if(null == tCompany){
                            return ResultUtil.error("企业名称不正确");
                        }
                        userType = 3;
                        userId = tCompany.getId();
                    }

                    TCarBrand tCarBrand = carBrandService.selectOne(new EntityWrapper<TCarBrand>().eq("name", three).eq("state", 1));
                    if(null == tCarBrand){
                        return ResultUtil.error("品牌名称不正确");
                    }
                    TRegion province = regionService.selectOne(new EntityWrapper<TRegion>().eq("name", fifteen));
                    if(null == province){
                        return ResultUtil.error("省名称不正确");
                    }
                    TRegion city = regionService.selectOne(new EntityWrapper<TRegion>().eq("name", sixteen));
                    if(null == city){
                        return ResultUtil.error("市名称不正确");
                    }

                    if(!"是".equals(twentyFive) && !"否".equals(twentyFive)){
                        return ResultUtil.error("是否包含过户费内容不正确");
                    }
                    if(!"是".equals(thirty) && !"否".equals(thirty)){
                        return ResultUtil.error("是否包含过户费内容不正确");
                    }

                    if("营运".equals(four)){
                        if(SinataUtil.isEmpty(thirtyTwo)){
                            return ResultUtil.error("剩余营运时间不能为空");
                        }
                        if(SinataUtil.isEmpty(thirtyThree)){
                            return ResultUtil.error("营运更新时间不能为空");
                        }
                    }

                    SellingCar sellingCar = new SellingCar();
                    sellingCar.setUserType(userType);
                    sellingCar.setUserId(userId);
                    sellingCar.setTitle(two);
                    sellingCar.setBrandId(tCarBrand.getId());
                    sellingCar.setBrandName(three);
                    sellingCar.setCategory("非营运".equals(four) ? 1 : 2);
                    sellingCar.setCarIdentificationCode(five);
                    sellingCar.setCarLicensePlate(six);
                    sellingCar.setCarColor(seven);
                    sellingCar.setLicensingTime(eight);
                    sellingCar.setMileage(nine);
                    sellingCar.setDescribe(ten);
                    sellingCar.setDescribeImgUrl(eleven);
                    sellingCar.setContactsPhone(thirteen);
                    sellingCar.setContactsName(twelve);
                    sellingCar.setProvinceCode(province.getCode());
                    sellingCar.setCityCode(city.getCode());
                    sellingCar.setProvinceName(province.getName());
                    sellingCar.setCityName(city.getName());
                    sellingCar.setCreateTime(new Date());
                    sellingCar.setStatus(1);
                    sellingCar.setAddres(sixteen);
                    sellingCar.setImgUrl(seventeen);
                    sellingCar.setVideoUrl(eighteen);
                    sellingCar.setLocationOfLicensePlate(nineteen);
                    sellingCar.setTransferTimes(twenty);
                    sellingCar.setDisplacement(twentyOne);
                    sellingCar.setTransmissionCase(twentyTwo);
                    sellingCar.setLevel(twentyThree);
                    sellingCar.setTransferPrice(Double.valueOf(twentyFour));
                    sellingCar.setIncludingTransferFee("是".equals(twentyFive) ? 1 : 2);
                    sellingCar.setNewCarPrice(Double.valueOf(twentySix));
                    sellingCar.setDueTimeOfCompulsoryInsurance(twentySeven);
                    sellingCar.setExpirationTimeOfAnnualInspection(twentyEight);
                    sellingCar.setMaturityTimeOfCommercialInsurance(twentyNine);
                    sellingCar.setMortgage("是".equals(thirty) ? 1 : 2);
                    sellingCar.setInstallationConfiguration(thirtyOne);
                    sellingCar.setRemainingOperationTime(thirtyTwo);
                    sellingCar.setOperationUpdateTime(thirtyThree);
                    sellingCar.setFirstPageShow(2);
                    sellingCarService.insert(sellingCar);
                }
            }
            return ResultUtil.success();
        } catch (Exception e) {
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }



    /**
     * 获取车辆出租审核列表
     * @param createTime
     * @param title
     * @param brandId
     * @param insertUser
     * @param status
     * @param userType
     * @param offset
     * @param limit
     * @return
     */
    @ResponseBody
    @PostMapping("/listAuditSellingCar")
    public Object listAuditSellingCar(String createTime, String carLicensePlate, Integer brandId, String insertUser, Integer status, Integer userType, Integer offset, Integer limit){
        try {
            List<Integer> state = Arrays.asList(1, 5);
            if(null != status){
                state = Arrays.asList(status);
            }
            return sellingCarService.list(createTime, carLicensePlate, brandId, insertUser, state, userType, offset, limit);
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }


    /**
     * 审核操作
     * @param id
     * @param status
     * @param authRemark
     * @return
     */
    @ResponseBody
    @PostMapping("/auditSellingCar")
    public ResultUtil auditSellingCar(Integer id, Integer status, String authRemark){
        try {
            return sellingCarService.auditSellingCar(id, status, authRemark);
        }catch (Exception e){
            e.printStackTrace();
            return ResultUtil.runErr();
        }
    }
}