|  |  | 
 |  |  | import org.apache.commons.collections.CollectionUtils; | 
 |  |  | import org.apache.commons.lang3.RandomStringUtils; | 
 |  |  | import org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.apache.poi.ss.usermodel.CellType; | 
 |  |  | import org.apache.shiro.SecurityUtils; | 
 |  |  | import org.springframework.beans.BeanUtils; | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | 
 |  |  |     private TmsService tmsService; | 
 |  |  |     @Autowired | 
 |  |  |     private SystemUserMapper systemUserMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private CarsMapper carsMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private ParkBookMapper parkBookMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     @Lazy | 
 |  |  | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {BusinessException.class,Exception.class}) | 
 |  |  |     public void deleteById(Integer id,LoginUserInfo loginUserInfo) { | 
 |  |  |  | 
 |  |  |         Date date =new Date(); | 
 |  |  |         Member member=new Member(); | 
 |  |  |         member.setId(id); | 
 |  |  |         member.setIsdeleted(Constants.ONE); | 
 |  |  |         member.setEditor(loginUserInfo.getId()); | 
 |  |  |         member.setEditDate(new Date()); | 
 |  |  |         member.setEditDate(date); | 
 |  |  |         member.setHkStatus(Constants.ZERO); | 
 |  |  |         member.setRemark("人员已删除,等待删除门禁权限"); | 
 |  |  |         memberMapper.updateById(member); | 
 |  |  | 
 |  |  |                 .set(SystemUser::getUpdateUser,member.getEditor()) | 
 |  |  |                 .set(SystemUser::getUpdateTime,member.getEditDate()) | 
 |  |  |         ); | 
 |  |  |  | 
 |  |  |         saveUserActionBiz(member,loginUserInfo,Constants.UserActionType.DELETE,userActionJoinMapper,JSONObject.toJSONString(member)); | 
 |  |  |         List<Cars> carsList = carsMapper.selectList(new QueryWrapper<Cars>().lambda() | 
 |  |  |                 .eq(Cars::getMemberId,member.getId()) | 
 |  |  |                 .eq(Cars::getIsdeleted,Constants.ONE) | 
 |  |  |                 .eq(Cars::getAuthStatus,Constants.ONE)//已授权包期的车辆 | 
 |  |  |         ); | 
 |  |  |         if ((carsMapper!=null && carsList.size()>0)){ | 
 |  |  |             for(Cars car :carsList){ | 
 |  |  |                if(Constants.equalsInteger(car.getAuthStatus(),Constants.ZERO)){ | 
 |  |  |                    Cars model = new Cars(); | 
 |  |  |                    carsMapper.update(null,new UpdateWrapper<Cars>().lambda() | 
 |  |  |                            .eq(Cars::getId,car.getId()) | 
 |  |  |                            .set(Cars::getStartTime,null) | 
 |  |  |                            .set(Cars::getEndTime,null) | 
 |  |  |                            .set(Cars::getAuthTimeType,null) | 
 |  |  |                            .set(Cars::getAuthStatus,Constants.ZERO) | 
 |  |  |                            .set(Cars::getEditDate,model.getEditDate()) | 
 |  |  |                            .set(Cars::getEdirot,model.getEdirot()) | 
 |  |  |                    ); | 
 |  |  |                    //删除已授权下发的包期授权 | 
 |  |  |                    CarsServiceImpl.dealCancelBookBiz(car.getCode(),date,parkBookMapper); | 
 |  |  |                } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     public static void saveUserActionBiz(Member updateMember,LoginUserInfo user, Constants.UserActionType type,UserActionJoinMapper userActionMapper,String content) { | 
 |  |  |         updateMember.setEditDate(updateMember.getEditDate()==null?new Date():updateMember.getEditDate()); | 
 |  |  |         UserAction userAction=new UserAction(); | 
 |  |  |        UserAction userAction=new UserAction(); | 
 |  |  |         userAction.setIsdeleted(Constants.ZERO); | 
 |  |  |         userAction.setCreateDate(updateMember.getEditDate()); | 
 |  |  |         userAction.setCreator(updateMember.getEditor()); | 
 |  |  | 
 |  |  |         SystemUser user = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda() | 
 |  |  |                 .eq(SystemUser::getOpenid,openId) | 
 |  |  |                 .in(SystemUser::getType,Constants.memberType.internal) | 
 |  |  |                 .eq(SystemUser::getDeleted,Boolean.FALSE) | 
 |  |  |                 .eq(SystemUser::getDeleted,Constants.ZERO) | 
 |  |  |                 .last(" limit 1 ")); | 
 |  |  |         //非访客用户 进行判断是否存在用户 | 
 |  |  |         if(!Objects.isNull(user)){ | 
 |  |  | 
 |  |  |         SystemUser user = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda() | 
 |  |  |                 .eq(SystemUser::getOpenid,openId) | 
 |  |  |                 .in(SystemUser::getType,Constants.memberType.internal,Constants.memberType.driver) | 
 |  |  |                 .eq(SystemUser::getDeleted,Boolean.FALSE) | 
 |  |  |                 .eq(SystemUser::getDeleted,Constants.ZERO) | 
 |  |  |                 .last(" limit 1 ")); | 
 |  |  |         //非访客用户 进行判断是否存在用户 | 
 |  |  |         if(!Objects.isNull(user)){ | 
 |  |  | 
 |  |  |                 .eq(SystemUser::getOpenid,openId) | 
 |  |  |                 .eq(SystemUser::getType,source) | 
 |  |  | //                .eq(Objects.nonNull(source)&&Constants.equalsInteger(source,Constants.TWO),SystemUser::getType,source) | 
 |  |  |                 .eq(SystemUser::getDeleted,Boolean.FALSE) | 
 |  |  |                 .eq(SystemUser::getDeleted,Constants.ZERO) | 
 |  |  |                 .last(" limit 1 ")); | 
 |  |  |         //非访客用户 进行判断是否存在用户 | 
 |  |  |         if(!Objects.isNull(user)){ | 
 |  |  | 
 |  |  |             ExcelImporter ie = null; | 
 |  |  |             List<MemberImport> dataList =null; | 
 |  |  |             try { | 
 |  |  |                 ie = new ExcelImporter(file,1,0); | 
 |  |  |                 ie = new ExcelImporter(file,1,0, CellType.STRING); // 确保单元格类型为字符串); | 
 |  |  |                 dataList = ie.getDataList(MemberImport.class,null); | 
 |  |  |             }  catch (Exception e) { | 
 |  |  |                 e.printStackTrace(); |