From 4c99ee7028c3fe58a2cd4b8273b22c75c45574fc Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期五, 16 五月 2025 10:27:41 +0800
Subject: [PATCH] 修改文档bug

---
 ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java |  299 +++++++++++++++++++++++++++++++++++------------------------
 1 files changed, 179 insertions(+), 120 deletions(-)

diff --git a/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java b/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
index 4e608b9..9bff68c 100644
--- a/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
+++ b/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
@@ -16,8 +16,7 @@
 import com.stylefeng.guns.modular.system.model.*;
 import com.stylefeng.guns.modular.system.service.*;
 import com.stylefeng.guns.modular.system.util.EmailUtil;
-import com.stylefeng.guns.modular.system.util.HttpRequestUtil;
-import com.stylefeng.guns.modular.system.util.PushURL;
+import com.stylefeng.guns.modular.system.util.RedisUtil;
 import com.stylefeng.guns.modular.system.util.ResultUtil;
 import org.apache.poi.ss.usermodel.Cell;
 import org.apache.poi.ss.usermodel.Row;
@@ -80,8 +79,21 @@
 
     @Value("${spring.mail.template-path}")
     private String templatePath;
-
-
+    
+    @Autowired
+    private RedisUtil redisUtil;
+    @Autowired
+    private IIncomeService incomeService;
+    @Autowired
+    private ITUserService userService;
+    @Autowired
+    private IUserActivityInviteService userActivityInviteService;
+    @Autowired
+    private IDriverActivityRegisteredService driverActivityRegisteredService;
+    @Autowired
+    private ITCompanyService itCompanyService;
+    @Autowired
+    private ITDriverServiceService itDriverServiceService;
 
     /**
      * 跳转到司机审核列表首页
@@ -106,7 +118,8 @@
      */
     @RequestMapping("/tDriver_add")
     public String tDriverAdd(Model model) {
-        List<TCompany> companyList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 2));
+        List<TCompany> companyList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 2)
+                .eq("state", 0).ne("flag", 3));
         model.addAttribute("companyList",companyList);
 
         Integer roleType = ShiroKit.getUser().getRoleType();
@@ -185,17 +198,17 @@
         model.addAttribute("objectName",tCompanyService.selectById(ShiroKit.getUser().getObjectId()).getName());
 
         if (1 == roleType){
-            List<TCompany> companyList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 2));
+            List<TCompany> companyList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 2).eq("state", 0).ne("flag", 3));
             model.addAttribute("companyList",companyList);
-            List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",tDriver.getCompanyId()));
+            List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",tDriver.getCompanyId()).eq("state", 0).ne("flag", 3));
             model.addAttribute("franchiseeList",franchiseeList);
         }else if (2 == roleType){
-            List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",ShiroKit.getUser().getObjectId()));
+            List<TCompany> franchiseeList = tCompanyService.selectList(new EntityWrapper<TCompany>().eq("type", 3).eq("superiorId",ShiroKit.getUser().getObjectId()).eq("state", 0).ne("flag", 3));
             model.addAttribute("franchiseeList",franchiseeList);
         }
 
         //查询平台ID
-        TCompany company = tCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1));
+        TCompany company = tCompanyService.selectOne(new EntityWrapper<TCompany>().eq("type", 1).eq("state", 0).ne("flag", 3));
         //判断是平台司机还是加盟司机
         if ((SinataUtil.isEmpty(tDriver.getCompanyId()) || tDriver.getCompanyId() == 0 || tDriver.getCompanyId() == company.getId()) && (SinataUtil.isEmpty(tDriver.getFranchiseeId()) || tDriver.getFranchiseeId() == 0)){
             model.addAttribute("companyType",1);
@@ -258,7 +271,6 @@
         model.addAttribute("id", id);
         return PREFIX + "training.html";
     }
-
 
     /**
      * 保存培训数据
@@ -329,7 +341,6 @@
         return ResultUtil.success(driverTrains);
     }
 
-
     /**
      * 跳转到处罚页
      * @param id
@@ -341,7 +352,6 @@
         model.addAttribute("id", id);
         return PREFIX + "punish.html";
     }
-
 
     /**
      * 保存处罚数据
@@ -405,7 +415,6 @@
         return ResultUtil.success();
     }
 
-
     /**
      * 获取所有处罚数据
      * @param driverId
@@ -417,7 +426,6 @@
         List<DriverPunish> driverPunishes = driverPunishMapper.queryAllPunish(driverId);
         return ResultUtil.success(driverPunishes);
     }
-
 
     /**
      * 根据分公司ID获取加盟商
@@ -473,7 +481,8 @@
     public Object listYesDriver(String insertTime,
                        String companyName,
                        String phone,
-                       String name,
+                       String lastName,
+                                String firstName,
                        Integer addType,
                        Integer authState,
                        Integer state,
@@ -486,7 +495,7 @@
             endTime = timeArray[1];
         }
         Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage();
-        page.setRecords(tDriverService.getDriverList(page,ShiroKit.getUser().getRoleType(),ShiroKit.getUser().getObjectId(),beginTime,endTime,companyName,phone,name,addType,authState,state,teamId));
+        page.setRecords(tDriverService.getDriverList(page,ShiroKit.getUser().getRoleType(),ShiroKit.getUser().getObjectId(),beginTime,endTime,companyName,phone,lastName,firstName,addType,authState,state,teamId));
         return super.packForBT(page);
     }
 
@@ -515,20 +524,6 @@
         return super.packForBT(page);
 
     }
-
-    @Autowired
-    private IIncomeService incomeService;
-
-
-    @Autowired
-    private ITUserService userService;
-
-    @Autowired
-    private IUserActivityInviteService userActivityInviteService;
-
-    @Autowired
-    private IDriverActivityRegisteredService driverActivityRegisteredService;
-
 
     /**
      * 审核操作  1=通过 2=不通过
@@ -589,34 +584,34 @@
                 type = 6;
                 tDriver.setAuthState(4);
             }
-
             new Thread(new Runnable() {
                 @Override
                 public void run() {
                     try {
                         String path = templatePath +  "driver/index.html";
                         Document document = Jsoup.parse(new File(path), "UTF-8");
-                        document.getElementById("chinese").attr("style", "display: none;");
-                        document.getElementById("french").attr("style", "display: none;");
-                        document.getElementById("invite1").attr("style", "display: none;");
-                        document.getElementById("user1").attr("style", "display: none;");
-                        document.getElementById("settle1").attr("style", "display: none;");
-                        document.getElementById("pass1").attr("style", "display: none;");
-                        document.getElementById("email1").attr("style", "display: none;");
-                        document.getElementById("bill1").attr("style", "display: none;");
-                        document.getElementById("reward1").attr("style", "display: none;");
-                        document.getElementById("rewardToday1").attr("style", "display: none;");
-                        document.getElementById("carAudit1").attr("style", "display: none;");
+                        document.getElementById("chinese").remove();
+                        document.getElementById("french").remove();
+                        document.getElementById("invite1").remove();
+                        document.getElementById("user1").remove();
+                        document.getElementById("settle1").remove();
+                        document.getElementById("pass1").remove();
+                        document.getElementById("email1").remove();
+                        document.getElementById("bill1").remove();
+                        document.getElementById("reward1").remove();
+                        document.getElementById("rewardToday1").remove();
+                        document.getElementById("carAudit1").remove();
 
+                        document.getElementsByTag("title").get(0).text(1 == authState ? "Driver is verified and qualified" : "Driver is not verified and qualified");
                         Element driver_audit1_user = document.getElementById("driver_audit1_user");
-                        driver_audit1_user.text("Hello " + tDriver.getName() + ",");
+                        driver_audit1_user.text("Hello " + tDriver.getFirstName() + " " + tDriver.getLastName() + ",");
                         Element driver_audit1_content = document.getElementById("driver_audit1_content");
                         if(1 == authState){
-                            driver_audit1_content.text("You application has been approved.");
+                            driver_audit1_content.text("Your application has been approved.");
                         }else{
-                            driver_audit1_content.text("I'm sorry, your application was rejected. Reason for rejection: Incomplete filling in personal information.");
+                            driver_audit1_content.text("We are sorry to inform you that your application was rejected. Please contact our service for relevant details, call 0577777767 or send e-mail to support@i-go.group");
                         }
-                        EmailUtil.send(tDriver.getEmail(), "Notice of driver registration application",  document.html());
+                        EmailUtil.send(tDriver.getEmail(), 1 == authState ? "Driver is verified and qualified" : "Driver is not verified and qualified",  document.html());
                     }catch (Exception e){
                         e.printStackTrace();
                     }
@@ -699,6 +694,21 @@
 
         tDriver.setPassword(ShiroKit.md5(tDriver.getPassword(), "SA;d5#"));
 
+        String phone = tDriver.getPhone();
+        String substring = phone.substring(0, 1);
+        if("0".equals(substring)){
+            phone = "233" + phone.substring(1);
+        }
+        if(phone.indexOf("233") < 0){
+            phone = "233" + phone;
+        }
+        tDriver.setPhone(phone);
+        tDriver.setAccount(phone);
+        tDriver.setBalance(new BigDecimal(0));
+//        tDriver.setCommission(new BigDecimal(0));
+//        tDriver.setCouponBalance(new BigDecimal(0));
+//        tDriver.setBackgroundBalance(new BigDecimal(0));
+
         tDriverService.insert(tDriver);
 
         //添加经营业务
@@ -719,7 +729,7 @@
 
         return SUCCESS_TIP;
     }
-
+    
     /**
      * 添加线路
      * @param subArr
@@ -739,7 +749,6 @@
         }
     }
 
-
     /**
      * 删除司机审核列表
      */
@@ -751,6 +760,7 @@
         tDriverService.updateById(driver);
         return SUCCESS_TIP;
     }
+
     /**
      * 操作司机状态
      */
@@ -762,6 +772,10 @@
             if (1 == optType){  //解冻
                 tDriver.setAuthState(2);
             }else if (2 == optType){  //冻结
+                String token = redisUtil.getValue("DRIVER_" + tDriver.getPhone());
+                redisUtil.remove(token);//删除个人信息数据
+                redisUtil.remove("DRIVER_" + tDriver.getPhone());//删除后台冻结相关缓存
+                redisUtil.remove("DRIVER_" + driverId);//清除存储的token
                 tDriver.setAuthState(3);
             }
             tDriver.setRemark(remark);
@@ -822,6 +836,16 @@
             tDriver.setPassword(obj.getPassword());
         }
 
+        String phone = tDriver.getPhone();
+        String substring = phone.substring(0, 1);
+        if("0".equals(substring)){
+            phone = "233" + phone.substring(1);
+        }
+        if(phone.indexOf("233") < 0){
+            phone = "233" + phone;
+        }
+        tDriver.setPhone(phone);
+        tDriver.setAccount(phone);
         tDriverService.updateById(tDriver);
 
         //删除业务
@@ -865,7 +889,8 @@
         if (ShiroKit.getUser().getRoleType() == 1){
             title = "平台导入司机模板";
 
-            shellList.add("司机名称");
+            shellList.add("司机姓");
+            shellList.add("司机名");
             shellList.add("所属机构[平台司机/加盟司机]");
             shellList.add("所属分公司[提示:加盟司机选填]");
             shellList.add("所属加盟商[提示:加盟司机选填]");
@@ -887,7 +912,8 @@
         }else if (ShiroKit.getUser().getRoleType() == 2){
             title = "分公司导入司机模板";
 
-            shellList.add("司机名称");
+            shellList.add("司机姓");
+            shellList.add("司机名");
             shellList.add("所属加盟商[选填]");
             shellList.add("性别[男/女]");
             shellList.add("驾驶证号码");
@@ -907,7 +933,8 @@
         }else if (ShiroKit.getUser().getRoleType() == 3){
             title = "加盟商导入司机模板";
 
-            shellList.add("司机名称");
+            shellList.add("司机姓");
+            shellList.add("司机名");
             shellList.add("性别[男/女]");
             shellList.add("驾驶证号码");
             shellList.add("驾龄");
@@ -957,115 +984,128 @@
                         zero = String.valueOf(cell0.getStringCellValue()).trim();
                     }
 
-                    Cell cell1 = row.getCell(1);  //所属机构[平台司机/加盟司机]
+                    Cell cell01 = row.getCell(1);  //司机名称
+                    String zero1 = null;
+                    if (SinataUtil.isNotEmpty(cell01)){
+                        zero1 = String.valueOf(cell01.getStringCellValue()).trim();
+                    }
+
+                    Cell cell1 = row.getCell(2);  //所属机构[平台司机/加盟司机]
                     String one = null;
                     if (SinataUtil.isNotEmpty(cell1)){
                         one = String.valueOf(cell1.getStringCellValue()).trim();
                     }
 
-                    Cell cell2 = row.getCell(2);  //所属分公司[提示:加盟司机选填]
+                    Cell cell2 = row.getCell(3);  //所属分公司[提示:加盟司机选填]
                     String two = null;
                     if (SinataUtil.isNotEmpty(cell2)){
                         two = String.valueOf(cell2.getStringCellValue()).trim();
                     }
 
-                    Cell cell3 = row.getCell(3);  //所属加盟商[提示:加盟司机选填]
+                    Cell cell3 = row.getCell(4);  //所属加盟商[提示:加盟司机选填]
                     String three = null;
                     if (SinataUtil.isNotEmpty(cell3)){
                         three = String.valueOf(cell3.getStringCellValue()).trim();
                     }
 
-                    Cell cell4 = row.getCell(4);  //性别[男/女]
+                    Cell cell4 = row.getCell(5);  //性别[男/女]
                     String four = null;
                     if (SinataUtil.isNotEmpty(cell4)){
                         four = String.valueOf(cell4.getStringCellValue()).trim();
                     }
 
-                    Cell cell5 = row.getCell(5);  //驾驶证号码
+                    Cell cell5 = row.getCell(6);  //驾驶证号码
                     String five = null;
                     if (SinataUtil.isNotEmpty(cell5)){
                         five = String.valueOf(cell5.getStringCellValue()).trim();
                     }
 
-                    Cell cell6 = row.getCell(6);  //驾龄
+                    Cell cell6 = row.getCell(7);  //驾龄
                     String six = null;
                     if (SinataUtil.isNotEmpty(cell6)){
                         six = String.valueOf(cell6.getStringCellValue()).trim();
                     }
 
-                    Cell cell7 = row.getCell(7);  //身份证号
+                    Cell cell7 = row.getCell(8);  //身份证号
                     String seven = null;
                     if (SinataUtil.isNotEmpty(cell7)){
                         seven = String.valueOf(cell7.getStringCellValue()).trim();
                     }
 
-                    Cell cell8 = row.getCell(8);  //居住地址
+                    Cell cell8 = row.getCell(9);  //居住地址
                     String eight = null;
                     if (SinataUtil.isNotEmpty(cell8)){
                         eight = String.valueOf(cell8.getStringCellValue()).trim();
                     }
 
-                    Cell cell9 = row.getCell(9);  //出租车资格证号
+                    Cell cell9 = row.getCell(10);  //出租车资格证号
                     String nine = null;
                     if (SinataUtil.isNotEmpty(cell9)){
                         nine = String.valueOf(cell9.getStringCellValue()).trim();
                     }
 
-                    Cell cell10 = row.getCell(10);  //工号[选填]
+                    Cell cell10 = row.getCell(11);  //工号[选填]
                     String ten = null;
                     if (SinataUtil.isNotEmpty(cell10)){
                         ten = String.valueOf(cell10.getStringCellValue()).trim();
                     }
 
-                    Cell cell11 = row.getCell(11);  //经营业务:专车[是/否]
+                    Cell cell11 = row.getCell(12);  //经营业务:专车[是/否]
                     String eleven = null;
                     if (SinataUtil.isNotEmpty(cell11)){
                         eleven = String.valueOf(cell11.getStringCellValue()).trim();
                     }
 
-                    Cell cell12 = row.getCell(12);  //经营业务:专车[是/否]
+                    Cell cell12 = row.getCell(13);  //经营业务:专车[是/否]
                     String twelve = null;
                     if (SinataUtil.isNotEmpty(cell12)){
                         twelve = String.valueOf(cell12.getStringCellValue()).trim();
                     }
 
-                    Cell cell13 = row.getCell(13);  //经营业务:跨城出行[是/否]
+                    Cell cell13 = row.getCell(14);  //经营业务:跨城出行[是/否]
                     String thirteen = null;
                     if (SinataUtil.isNotEmpty(cell13)){
                         thirteen = String.valueOf(cell13.getStringCellValue()).trim();
                     }
 
-                    Cell cell14 = row.getCell(14);  //经营业务:小件同城物流[是/否]
+                    Cell cell14 = row.getCell(15);  //经营业务:小件同城物流[是/否]
                     String fourteen = null;
                     if (SinataUtil.isNotEmpty(cell14)){
                         fourteen = String.valueOf(cell14.getStringCellValue()).trim();
                     }
 
-                    Cell cell15 = row.getCell(15);  //经营业务:小件跨城物流[是/否]
+                    Cell cell15 = row.getCell(16);  //经营业务:小件跨城物流[是/否]
                     String fifteen = null;
                     if (SinataUtil.isNotEmpty(cell15)){
                         fifteen = String.valueOf(cell15.getStringCellValue()).trim();
                     }
 
-                    Cell cell16 = row.getCell(16);  //经营业务:包车[是/否]
+                    Cell cell16 = row.getCell(17);  //经营业务:包车[是/否]
                     String sixteen = null;
                     if (SinataUtil.isNotEmpty(cell16)){
                         sixteen = String.valueOf(cell16.getStringCellValue()).trim();
                     }
 
-                    Cell cell17 = row.getCell(17);  //登录账号[手机号]
+                    Cell cell17 = row.getCell(18);  //登录账号[手机号]
                     String seventeen = null;
                     if (SinataUtil.isNotEmpty(cell17)){
                         seventeen = String.valueOf(cell17.getStringCellValue()).trim();
+                        String substring = seventeen.substring(0, 1);
+                        if("0".equals(substring)){
+                            seventeen = "233" + seventeen.substring(1);
+                        }
+                        if(seventeen.indexOf("233") < 0){
+                            seventeen = "233" + seventeen;
+                        }
                     }
 
-                    Cell cell18 = row.getCell(18);  //登录密码[密码长度为6-18]
+                    Cell cell18 = row.getCell(19);  //登录密码[密码长度为6-18]
                     String eighteen = null;
                     if (SinataUtil.isNotEmpty(cell18)){
                         eighteen = String.valueOf(cell18.getStringCellValue()).trim();
                     }
 
-                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(one) || SinataUtil.isEmpty(four)
+                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(zero1) || SinataUtil.isEmpty(one) || SinataUtil.isEmpty(four)
                             || SinataUtil.isEmpty(five) || SinataUtil.isEmpty(six) || SinataUtil.isEmpty(nine)
                             || SinataUtil.isEmpty(eleven) || SinataUtil.isEmpty(twelve) || SinataUtil.isEmpty(thirteen)
                             || SinataUtil.isEmpty(fourteen) || SinataUtil.isEmpty(fifteen) || SinataUtil.isEmpty(sixteen)
@@ -1148,7 +1188,8 @@
                         driver.setJobNumber(ten);
                         driver.setPhone(seventeen);
                         driver.setPassword(ShiroKit.md5(eighteen, "SA;d5#"));
-                        driver.setName(zero);
+                        driver.setLastName(zero);
+                        driver.setFirstName(zero1);
                         if ("男".equals(four)){
                             driver.setSex(1);
                         }else if ("女".equals(four)){
@@ -1234,102 +1275,116 @@
                         zero = String.valueOf(cell0.getStringCellValue()).trim();
                     }
 
-                    Cell cell1 = row.getCell(1);  //所属加盟商[选填]
+                    Cell cell01 = row.getCell(1);  //司机名称
+                    String zero1 = null;
+                    if (SinataUtil.isNotEmpty(cell01)){
+                        zero1 = String.valueOf(cell01.getStringCellValue()).trim();
+                    }
+
+                    Cell cell1 = row.getCell(2);  //所属加盟商[选填]
                     String one = null;
                     if (SinataUtil.isNotEmpty(cell1)){
                         one = String.valueOf(cell1.getStringCellValue()).trim();
                     }
 
-                    Cell cell2 = row.getCell(2);  //性别[男/女]
+                    Cell cell2 = row.getCell(3);  //性别[男/女]
                     String two = null;
                     if (SinataUtil.isNotEmpty(cell2)){
                         two = String.valueOf(cell2.getStringCellValue()).trim();
                     }
 
-                    Cell cell3 = row.getCell(3);  //驾驶证号码
+                    Cell cell3 = row.getCell(4);  //驾驶证号码
                     String three = null;
                     if (SinataUtil.isNotEmpty(cell3)){
                         three = String.valueOf(cell3.getStringCellValue()).trim();
                     }
 
-                    Cell cell4 = row.getCell(4);  //驾龄
+                    Cell cell4 = row.getCell(5);  //驾龄
                     String four = null;
                     if (SinataUtil.isNotEmpty(cell4)){
                         four = String.valueOf(cell4.getStringCellValue()).trim();
                     }
 
-                    Cell cell5 = row.getCell(5);  //身份证号
+                    Cell cell5 = row.getCell(6);  //身份证号
                     String five = null;
                     if (SinataUtil.isNotEmpty(cell5)){
                         five = String.valueOf(cell5.getStringCellValue()).trim();
                     }
 
-                    Cell cell6 = row.getCell(6);  //居住地址
+                    Cell cell6 = row.getCell(7);  //居住地址
                     String six = null;
                     if (SinataUtil.isNotEmpty(cell6)){
                         six = String.valueOf(cell6.getStringCellValue()).trim();
                     }
 
-                    Cell cell7 = row.getCell(7);  //出租车资格证号
+                    Cell cell7 = row.getCell(8);  //出租车资格证号
                     String seven = null;
                     if (SinataUtil.isNotEmpty(cell7)){
                         seven = String.valueOf(cell7.getStringCellValue()).trim();
                     }
 
-                    Cell cell8 = row.getCell(8);  //工号[选填]
+                    Cell cell8 = row.getCell(9);  //工号[选填]
                     String eight = null;
                     if (SinataUtil.isNotEmpty(cell8)){
                         eight = String.valueOf(cell8.getStringCellValue()).trim();
                     }
 
-                    Cell cell9 = row.getCell(9);  //经营业务:专车[是/否]
+                    Cell cell9 = row.getCell(10);  //经营业务:专车[是/否]
                     String nine = null;
                     if (SinataUtil.isNotEmpty(cell9)){
                         nine = String.valueOf(cell9.getStringCellValue()).trim();
                     }
 
-                    Cell cell10 = row.getCell(10);  //经营业务:出租车[是/否]
+                    Cell cell10 = row.getCell(11);  //经营业务:出租车[是/否]
                     String ten = null;
                     if (SinataUtil.isNotEmpty(cell10)){
                         ten = String.valueOf(cell10.getStringCellValue()).trim();
                     }
 
-                    Cell cell11 = row.getCell(11);  //经营业务:跨城出行[是/否]
+                    Cell cell11 = row.getCell(12);  //经营业务:跨城出行[是/否]
                     String eleven = null;
                     if (SinataUtil.isNotEmpty(cell11)){
                         eleven = String.valueOf(cell11.getStringCellValue()).trim();
                     }
 
-                    Cell cell12 = row.getCell(12);  //经营业务:小件同城物流[是/否]
+                    Cell cell12 = row.getCell(13);  //经营业务:小件同城物流[是/否]
                     String twelve = null;
                     if (SinataUtil.isNotEmpty(cell12)){
                         twelve = String.valueOf(cell12.getStringCellValue()).trim();
                     }
 
-                    Cell cell13 = row.getCell(13);  //经营业务:小件跨城物流[是/否]
+                    Cell cell13 = row.getCell(14);  //经营业务:小件跨城物流[是/否]
                     String thirteen = null;
                     if (SinataUtil.isNotEmpty(cell13)){
                         thirteen = String.valueOf(cell13.getStringCellValue()).trim();
                     }
 
-                    Cell cell14 = row.getCell(14);  //经营业务:包车[是/否]
+                    Cell cell14 = row.getCell(15);  //经营业务:包车[是/否]
                     String fourteen = null;
                     if (SinataUtil.isNotEmpty(cell14)){
                         fourteen = String.valueOf(cell14.getStringCellValue()).trim();
                     }
 
-                    Cell cell15 = row.getCell(15);  //登录账号[手机号]
+                    Cell cell15 = row.getCell(16);  //登录账号[手机号]
                     String fifteen = null;
                     if (SinataUtil.isNotEmpty(cell15)){
                         fifteen = String.valueOf(cell15.getStringCellValue()).trim();
+
+                        String substring = fifteen.substring(0, 1);
+                        if("0".equals(substring)){
+                            fifteen = "233" + fifteen.substring(1);
+                        }
+                        if(fifteen.indexOf("233") < 0){
+                            fifteen = "233" + fifteen;
+                        }
                     }
 
-                    Cell cell16 = row.getCell(16);  //登录密码[密码长度为6-18]
+                    Cell cell16 = row.getCell(17);  //登录密码[密码长度为6-18]
                     String sixteen = null;
                     if (SinataUtil.isNotEmpty(cell16)){
                         sixteen = String.valueOf(cell16.getStringCellValue()).trim();
                     }
-                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(two) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
+                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(zero1) || SinataUtil.isEmpty(two) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
                             || SinataUtil.isEmpty(five) || SinataUtil.isEmpty(seven)
                             || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
                             || SinataUtil.isEmpty(eleven) || SinataUtil.isEmpty(twelve) || SinataUtil.isEmpty(thirteen)
@@ -1397,7 +1452,8 @@
                         driver.setJobNumber(eight);
                         driver.setPhone(fifteen);
                         driver.setPassword(ShiroKit.md5(sixteen, "SA;d5#"));
-                        driver.setName(zero);
+                        driver.setLastName(zero);
+                        driver.setFirstName(zero1);
                         if ("男".equals(two)){
                             driver.setSex(1);
                         }else if ("女".equals(two)){
@@ -1479,96 +1535,109 @@
                         zero = String.valueOf(cell0.getStringCellValue()).trim();
                     }
 
-                    Cell cell2 = row.getCell(1);  //性别[男/女]
+                    Cell cell01 = row.getCell(1);  //司机名称
+                    String zero1 = null;
+                    if (SinataUtil.isNotEmpty(cell01)){
+                        zero1 = String.valueOf(cell01.getStringCellValue()).trim();
+                    }
+
+                    Cell cell2 = row.getCell(2);  //性别[男/女]
                     String one = null;
                     if (SinataUtil.isNotEmpty(cell2)){
                         one = String.valueOf(cell2.getStringCellValue()).trim();
                     }
 
-                    Cell cell3 = row.getCell(2);  //驾驶证号码
+                    Cell cell3 = row.getCell(3);  //驾驶证号码
                     String two = null;
                     if (SinataUtil.isNotEmpty(cell3)){
                         two = String.valueOf(cell3.getStringCellValue()).trim();
                     }
 
-                    Cell cell4 = row.getCell(3);  //驾龄
+                    Cell cell4 = row.getCell(4);  //驾龄
                     String three = null;
                     if (SinataUtil.isNotEmpty(cell4)){
                         three = String.valueOf(cell4.getStringCellValue()).trim();
                     }
 
-                    Cell cell5 = row.getCell(4);  //身份证号
+                    Cell cell5 = row.getCell(5);  //身份证号
                     String four = null;
                     if (SinataUtil.isNotEmpty(cell5)){
                         four = String.valueOf(cell5.getStringCellValue()).trim();
                     }
 
-                    Cell cell6 = row.getCell(5);  //居住地址
+                    Cell cell6 = row.getCell(6);  //居住地址
                     String five = null;
                     if (SinataUtil.isNotEmpty(cell6)){
                         five = String.valueOf(cell6.getStringCellValue()).trim();
                     }
 
-                    Cell cell7 = row.getCell(6);  //出租车资格证号
+                    Cell cell7 = row.getCell(7);  //出租车资格证号
                     String six = null;
                     if (SinataUtil.isNotEmpty(cell7)){
                         six = String.valueOf(cell7.getStringCellValue()).trim();
                     }
 
-                    Cell cell8 = row.getCell(7);  //工号[选填]
+                    Cell cell8 = row.getCell(8);  //工号[选填]
                     String seven = null;
                     if (SinataUtil.isNotEmpty(cell8)){
                         seven = String.valueOf(cell8.getStringCellValue()).trim();
                     }
 
-                    Cell cell9 = row.getCell(8);  //经营业务:专车[是/否]
+                    Cell cell9 = row.getCell(9);  //经营业务:专车[是/否]
                     String eight = null;
                     if (SinataUtil.isNotEmpty(cell9)){
                         eight = String.valueOf(cell9.getStringCellValue()).trim();
                     }
 
-                    Cell cell10 = row.getCell(9);  //经营业务:出租车[是/否]
+                    Cell cell10 = row.getCell(10);  //经营业务:出租车[是/否]
                     String nine = null;
                     if (SinataUtil.isNotEmpty(cell10)){
                         nine = String.valueOf(cell10.getStringCellValue()).trim();
                     }
 
-                    Cell cell11 = row.getCell(10);  //经营业务:跨城出行[是/否]
+                    Cell cell11 = row.getCell(11);  //经营业务:跨城出行[是/否]
                     String ten = null;
                     if (SinataUtil.isNotEmpty(cell11)){
                         ten = String.valueOf(cell11.getStringCellValue()).trim();
                     }
 
-                    Cell cell12 = row.getCell(11);  //经营业务:小件同城物流[是/否]
+                    Cell cell12 = row.getCell(12);  //经营业务:小件同城物流[是/否]
                     String eleven = null;
                     if (SinataUtil.isNotEmpty(cell12)){
                         eleven = String.valueOf(cell12.getStringCellValue()).trim();
                     }
 
-                    Cell cell13 = row.getCell(12);  //经营业务:小件跨城物流[是/否]
+                    Cell cell13 = row.getCell(13);  //经营业务:小件跨城物流[是/否]
                     String twelve = null;
                     if (SinataUtil.isNotEmpty(cell13)){
                         twelve = String.valueOf(cell13.getStringCellValue()).trim();
                     }
 
-                    Cell cell14 = row.getCell(13);  //经营业务:包车[是/否]
+                    Cell cell14 = row.getCell(14);  //经营业务:包车[是/否]
                     String thirteen = null;
                     if (SinataUtil.isNotEmpty(cell14)){
                         thirteen = String.valueOf(cell14.getStringCellValue()).trim();
                     }
 
-                    Cell cell15 = row.getCell(14);  //登录账号[手机号]
+                    Cell cell15 = row.getCell(15);  //登录账号[手机号]
                     String fourteen = null;
                     if (SinataUtil.isNotEmpty(cell15)){
                         fourteen = String.valueOf(cell15.getStringCellValue()).trim();
+                        String substring = fourteen.substring(0, 1);
+                        if("0".equals(substring)){
+                            fourteen = "233" + fourteen.substring(1);
+                        }
+                        if(fourteen.indexOf("233") < 0){
+                            fourteen = "233" + fourteen;
+                        }
                     }
 
-                    Cell cell16 = row.getCell(15);  //登录密码[密码长度为6-18]
+                    Cell cell16 = row.getCell(16);  //登录密码[密码长度为6-18]
                     String fifteen = null;
                     if (SinataUtil.isNotEmpty(cell16)){
                         fifteen = String.valueOf(cell16.getStringCellValue()).trim();
                     }
-                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(one)  || SinataUtil.isEmpty(two) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
+                    if (SinataUtil.isEmpty(zero) || SinataUtil.isEmpty(zero1) || SinataUtil.isEmpty(one)  || SinataUtil.isEmpty(two) || SinataUtil.isEmpty(three) || SinataUtil.isEmpty(four)
                             || SinataUtil.isEmpty(six) || SinataUtil.isEmpty(eight)
                             || SinataUtil.isEmpty(nine) || SinataUtil.isEmpty(ten)
                             || SinataUtil.isEmpty(eleven) || SinataUtil.isEmpty(twelve) || SinataUtil.isEmpty(thirteen)
@@ -1637,7 +1706,8 @@
                         driver.setJobNumber(seven);
                         driver.setPhone(fourteen);
                         driver.setPassword(ShiroKit.md5(fifteen, "SA;d5#"));
-                        driver.setName(zero);
+                        driver.setLastName(zero);
+                        driver.setFirstName(zero1);
                         if ("男".equals(one)){
                             driver.setSex(1);
                         }else if ("女".equals(one)){
@@ -1712,15 +1782,6 @@
         }
         return SUCCESS_TIP;
     }
-
-
-
-
-    @Autowired
-    private ITCompanyService itCompanyService;
-
-    @Autowired
-    private ITDriverServiceService itDriverServiceService;
 
     /**
      * 验证是否可以字符转为整数
@@ -1813,8 +1874,8 @@
             }else{
                 shellList.add("-");
             }
-            if(SinataUtil.isNotEmpty(object.get("name"))){
-                shellList.add(object.get("name").toString());
+            if(SinataUtil.isNotEmpty(object.get("firstName"))){
+                shellList.add(object.get("firstName").toString() + " " + object.get("lastName").toString());
             }else{
                 shellList.add("-");
             }
@@ -1824,7 +1885,7 @@
                 shellList.add("-");
             }
             if(SinataUtil.isNotEmpty(object.get("sex"))){
-                shellList.add(object.get("sex").toString() == "1"?"男":"女");
+                shellList.add(object.get("sex").toString().equals("1")?"男":"女");
             }else{
                 shellList.add("-");
             }
@@ -1891,8 +1952,6 @@
             }
             if(SinataUtil.isNotEmpty(object.get("authState"))){
                 shellList.add(object.get("authState").toString().equals("1")?"待审核":(object.get("authState").toString().equals("2")?"正常":(object.get("authState").toString().equals("3")?"冻结":(object.get("authState").toString().equals("4")?"已拒绝":""))));
-
-                shellList.add(object.get("authState").toString());
             }else{
                 shellList.add("-");
             }

--
Gitblit v1.7.1