| | |
| | | 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)){ |
| | |
| | | .selectAs(Position::getName,Member::getPositionName) |
| | | .leftJoin(Position.class,Position::getId,Member::getPositionId) |
| | | .eq(StringUtils.isNotBlank(checkVisitedDTO.getMobile()),Member::getPhone,checkVisitedDTO.getMobile()) |
| | | .eq(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName()) |
| | | .like(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName()) |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .eq(Member::getStatus,Constants.ZERO) |
| | | .eq(Member::getWorkStatus,Constants.ZERO) |
| | |
| | | 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(); |