com.hazelcast.query.PagingPredicate Java Examples

@TimeStep(prob = 0.2)
public void pagePredicate(ThreadState state) {
    double maxSalary = state.randomDouble() * Employee.MAX_SALARY;
    Predicate predicate = Predicates.lessThan("salary", maxSalary);
    SalaryComparator salaryComparator = new SalaryComparator();
    PagingPredicate pagingPredicate = new PagingPredicateImpl(predicate, salaryComparator, pageSize);

    Collection<Employee> employees;
    List<Employee> employeeList;
    do {
        employees = map.values(pagingPredicate);
        employeeList = fillListWithQueryResultSet(employees);
        Employee nextEmployee;
        Employee currentEmployee;
        for (int i = 0; i < employeeList.size() - 1; i++) {
            currentEmployee = employeeList.get(i);
            nextEmployee = employeeList.get(i + 1);
            // check the order & max salary
            assertTrue(format(baseAssertMessage, currentEmployee.getSalary(), predicate),
                    currentEmployee.getSalary() <= nextEmployee.getSalary() && nextEmployee.getSalary() < maxSalary);
        }
        pagingPredicate.nextPage();
    } while (!employees.isEmpty());

    state.operationCounter.pagePredicateCount++;
}
 

@Override
public void handleRequest(HttpServerExchange exchange) throws Exception {
    IMap<String, Client> clients = CacheStartupHookProvider.hz.getMap("clients");
    Deque<String> clientNameDeque = exchange.getQueryParameters().get("clientName");
    String clientName = clientNameDeque == null? "%" : clientNameDeque.getFirst() + "%";
    int page = Integer.valueOf(exchange.getQueryParameters().get("page").getFirst()) - 1;
    Deque<String> pageSizeDeque = exchange.getQueryParameters().get("pageSize");
    int pageSize = pageSizeDeque == null? 10 : Integer.valueOf(pageSizeDeque.getFirst());

    LikePredicate likePredicate = new LikePredicate("clientName", clientName);

    PagingPredicate pagingPredicate = new PagingPredicate(likePredicate, new ClientComparator(), pageSize);
    pagingPredicate.setPage(page);
    Collection<Client> values = clients.values(pagingPredicate);

    List results = new ArrayList();
    for (Client value : values) {
        Client c = Client.copyClient(value);
        c.setClientSecret(null);
        results.add(c);
    }
    exchange.getResponseHeaders().add(new HttpString("Content-Type"), "application/json");
    exchange.getResponseSender().send(Config.getInstance().getMapper().writeValueAsString(results));
    processAudit(exchange);
}
 

@Override
public void handleRequest(HttpServerExchange exchange) throws Exception {
    IMap<String, Service> services = CacheStartupHookProvider.hz.getMap("services");

    Deque<String> serviceIdDeque = exchange.getQueryParameters().get("serviceId");
    String serviceId = serviceIdDeque == null? "%" : serviceIdDeque.getFirst() + "%";
    int page = Integer.valueOf(exchange.getQueryParameters().get("page").getFirst()) - 1;
    Deque<String> pageSizeDeque = exchange.getQueryParameters().get("pageSize");
    int pageSize = pageSizeDeque == null? 10 : Integer.valueOf(pageSizeDeque.getFirst());

    LikePredicate likePredicate = new LikePredicate("serviceId", serviceId);

    PagingPredicate pagingPredicate = new PagingPredicate(likePredicate, new ServiceComparator(), pageSize);
    pagingPredicate.setPage(page);
    Collection<Service> values = services.values(pagingPredicate);

    exchange.getResponseHeaders().add(Headers.CONTENT_TYPE, "application/json");
    exchange.getResponseSender().send(Config.getInstance().getMapper().writeValueAsString(values));
    processAudit(exchange);
}
 

@SuppressWarnings("unchecked")
@Override
public void handleRequest(HttpServerExchange exchange) throws Exception {
    IMap<String, User> users = CacheStartupHookProvider.hz.getMap("users");
    Deque<String> userIdDeque = exchange.getQueryParameters().get("userId");
    String userId = userIdDeque == null? "%" : userIdDeque.getFirst() + "%";
    int page = Integer.valueOf(exchange.getQueryParameters().get("page").getFirst()) - 1;
    Deque<String> pageSizeDeque = exchange.getQueryParameters().get("pageSize");
    int pageSize = pageSizeDeque == null? 10 : Integer.valueOf(pageSizeDeque.getFirst());

    LikePredicate likePredicate = new LikePredicate("userId", userId);

    PagingPredicate pagingPredicate = new PagingPredicate(likePredicate, new UserComparator(), pageSize);
    pagingPredicate.setPage(page);
    Collection<User> values = users.values(pagingPredicate);

    for (User value : values) {
        value.setPassword(null);
    }
    exchange.getResponseHeaders().add(Headers.CONTENT_TYPE, "application/json");
    exchange.getResponseSender().send(Config.getInstance().getMapper().writeValueAsString(values));
    processAudit(exchange);
}
 

@Override
public void handleRequest(HttpServerExchange exchange) throws Exception {
    IMap<String, RefreshToken> tokens = CacheStartupHookProvider.hz.getMap("tokens");
    Deque<String> userIdDeque = exchange.getQueryParameters().get("userId");
    String userId = userIdDeque == null? "%" : userIdDeque.getFirst() + "%";
    int page = Integer.valueOf(exchange.getQueryParameters().get("page").getFirst()) - 1;
    Deque<String> pageSizeDeque = exchange.getQueryParameters().get("pageSize");
    int pageSize = pageSizeDeque == null? 10 : Integer.valueOf(pageSizeDeque.getFirst());
    if(logger.isDebugEnabled()) logger.debug("userId = " + userId + " page = " + page + " pageSize = " + pageSize);
    LikePredicate likePredicate = new LikePredicate("userId", userId);

    PagingPredicate pagingPredicate = new PagingPredicate(likePredicate, new RefreshTokenComparator(), pageSize);
    pagingPredicate.setPage(page);
    Collection<RefreshToken> values = tokens.values(pagingPredicate);

    exchange.getResponseHeaders().add(new HttpString("Content-Type"), "application/json");
    exchange.getResponseSender().send(Config.getInstance().getMapper().writeValueAsString(values));
    processAudit(exchange);
}
 

@SuppressWarnings("unchecked")
public static int getQueneIndex(String agent , String orgi , String skill){
	
	int queneUsers = 0 ;
	
	PagingPredicate<String, AgentUser> pagingPredicate = null ;
	if(!StringUtils.isBlank(skill)){
		pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inquene' AND skill = '" + skill + "'  AND orgi = '" + orgi +"'") , 100 );
	}else if(!StringUtils.isBlank(agent)){
		pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inquene' AND agent = '"+agent+"' AND orgi = '" + orgi +"'") , 100 );
	}else{
		pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inquene' AND orgi = '" + orgi +"'") , 100 );
	}
	queneUsers = ((IMap<String , AgentUser>) CacheHelper.getAgentUserCacheBean().getCache()).values(pagingPredicate) .size();
	return queneUsers;
}
 

/**
 * 外呼监控，包含机器人和人工两个部分
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallOutNames> callOutNames(String calltype , int p , int ps){
	List<CallOutNames> callOutNamesList = new ArrayList<CallOutNames>();
	if(CacheHelper.getCallOutCacheBean()!=null && CacheHelper.getCallOutCacheBean().getCache()!=null) {
		PagingPredicate<String, CallOutNames> pagingPredicate = new PagingPredicate<String, CallOutNames>(  new SqlPredicate( "calltype = '"+calltype+"'") , 10 ) ;
		pagingPredicate.setPage(p);
		callOutNamesList.addAll(((IMap<String , CallOutNames>) CacheHelper.getCallOutCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return callOutNamesList ;
}
 

@SuppressWarnings("unchecked")
private <T extends HazelcastEntity> Collection<T> find(Predicate predicate, int pageSize, Class<T> tClass) {
    final Predicate pagingPredicate = (pageSize > 0)
            ? new PagingPredicate(predicate, new HazelcastEntityComparator(), pageSize)
            : predicate;
    return (Collection<T>) mapsHolder.get(tClass).values(pagingPredicate);
}
 

/**
 * <p>
 * Construct the final query predicate for Hazelcast to execute, from the base query plus any paging and sorting.
 * </P>
 * <p>
 * Variations here allow the base query predicate to be omitted, sorting to be omitted, and paging to be omitted.
 * </P>
 *
 * @param criteria Search criteria, null means match everything
 * @param sort     Possibly null collation
 * @param offset   Start point of returned page, -1 if not used
 * @param rows     Size of page, -1 if not used
 * @param keyspace The map name
 * @return Results from Hazelcast
 */
@Override
public Collection<?> execute(final Predicate<?, ?> criteria, final Comparator<Entry<?, ?>> sort, final long offset,
                             final int rows, final String keyspace) {

    final HazelcastKeyValueAdapter adapter = getAdapter();
    Assert.notNull(adapter, "Adapter must not be 'null'.");

    Predicate<?, ?> predicateToUse = criteria;
    @SuppressWarnings({"unchecked", "rawtypes"}) Comparator<Entry> sortToUse = ((Comparator<Entry>) (Comparator) sort);

    if (rows > 0) {
        PagingPredicate pp = new PagingPredicateImpl(predicateToUse, sortToUse, rows);
        long x = offset / rows;
        while (x > 0) {
            pp.nextPage();
            x--;
        }
        predicateToUse = pp;

    } else {
        if (sortToUse != null) {
            predicateToUse = new PagingPredicateImpl(predicateToUse, sortToUse, Integer.MAX_VALUE);
        }
    }

    if (predicateToUse == null) {
        return adapter.getMap(keyspace).values();
    } else {
        return adapter.getMap(keyspace).values((Predicate<Object, Object>) predicateToUse);
    }

}
 

@RequestMapping(method = RequestMethod.GET)
public ResponseEntity<Collection<Topology>> getOperations(
        @PageableDefault Pageable pageable
) throws IOException, EventStoreException {
    try {
        Collection<Topology> values = operationsMap.values(
                new PagingPredicate<>((Comparator<Map.Entry<String, Topology>> & Serializable) (o1, o2) -> -1 * Long.compare(o1.getValue().getStartTime(), o2.getValue().getStartTime()),
                        pageable.getPageSize()));
        return new ResponseEntity<>(values, HttpStatus.OK);
    } catch (Exception e) {
        log.error(e.getMessage(), e);
        return ResponseEntity.status(500).build();
    }
}
 

/**
 * 为外呼坐席分配名单
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallCenterAgent> extention(String extno){
	List<CallCenterAgent> agentList = new ArrayList<CallCenterAgent>();
	if(CacheHelper.getCallCenterAgentCacheBean()!=null && CacheHelper.getCallCenterAgentCacheBean().getCache()!=null) {
		PagingPredicate<String, CallCenterAgent> pagingPredicate = new PagingPredicate<String, CallCenterAgent>(  new SqlPredicate( "extno = '"+extno+"'") , 10 ) ;
		agentList.addAll(((IMap<String , CallCenterAgent>) CacheHelper.getCallCenterAgentCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return agentList ;
}
 

/**
 * 预测式外呼坐席
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallCenterAgent> forecastAgent(String forecastid){
	List<CallCenterAgent> agentList = new ArrayList<CallCenterAgent>();
	if(CacheHelper.getCallCenterAgentCacheBean()!=null && CacheHelper.getCallCenterAgentCacheBean().getCache()!=null) {
		PagingPredicate<String, CallCenterAgent> pagingPredicate = new PagingPredicate<String, CallCenterAgent>( new SqlPredicate( "forecastvalue like '%"+forecastid+"%' AND workstatus ='"+UKDataContext.WorkStatusEnum.CALLOUT.toString()+"'" )   , 1 ) ;
		agentList.addAll(((IMap<String , CallCenterAgent>) CacheHelper.getCallCenterAgentCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return agentList ;
}
 

/**
 * 预测式外呼坐席
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallCenterAgent> forecast(String forecastid){
	List<CallCenterAgent> agentList = new ArrayList<CallCenterAgent>();
	if(CacheHelper.getCallCenterAgentCacheBean()!=null && CacheHelper.getCallCenterAgentCacheBean().getCache()!=null) {
		PagingPredicate<String, CallCenterAgent> pagingPredicate = new PagingPredicate<String, CallCenterAgent>( Predicates.like("forecastvalue", forecastid) , 1 ) ;
		agentList.addAll(((IMap<String , CallCenterAgent>) CacheHelper.getCallCenterAgentCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return agentList ;
}
 

/**
 * 为外呼坐席分配名单
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallCenterAgent> service(String sip){
	List<CallCenterAgent> agentList = new ArrayList<CallCenterAgent>();
	if(CacheHelper.getCallCenterAgentCacheBean()!=null && CacheHelper.getCallCenterAgentCacheBean().getCache()!=null) {
		PagingPredicate<String, CallCenterAgent> pagingPredicate = new PagingPredicate<String, CallCenterAgent>(  new SqlPredicate( "siptrunk = '"+sip+"'") , 10 ) ;
		agentList.addAll(((IMap<String , CallCenterAgent>) CacheHelper.getCallCenterAgentCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return agentList ;
}
 

/**
 * 为外呼坐席分配名单
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static List<CallCenterAgent> service(){
	List<CallCenterAgent> agentList = new ArrayList<CallCenterAgent>();
	if(CacheHelper.getCallCenterAgentCacheBean()!=null && CacheHelper.getCallCenterAgentCacheBean().getCache()!=null) {
		PagingPredicate<String, CallCenterAgent> pagingPredicate = new PagingPredicate<String, CallCenterAgent>(  new SqlPredicate( "workstatus = 'callout'") , 10 ) ;
		agentList.addAll(((IMap<String , CallCenterAgent>) CacheHelper.getCallCenterAgentCacheBean().getCache()).values(pagingPredicate)) ;
	}
	return agentList ;
}
 

@SuppressWarnings("unchecked")
public static List<AgentStatus> getAgentStatus(String skill , String orgi){
	PagingPredicate<String, AgentStatus> pagingPredicate = new PagingPredicate<String, AgentStatus>(  new SqlPredicate( "orgi = '" + orgi +"'") , 100 ) ;
	
	if(!StringUtils.isBlank(skill)) {
		pagingPredicate = new PagingPredicate<String, AgentStatus>(  new SqlPredicate( "skill = '"+skill+"' AND orgi = '" + orgi +"'") , 100 ) ;
	}
	List<AgentStatus> agentList = new ArrayList<AgentStatus>();
	agentList.addAll(((IMap<String , AgentStatus>) CacheHelper.getAgentStatusCacheBean().getCache()).values(pagingPredicate)) ;
	return agentList;
}
 

@SuppressWarnings("unchecked")
public static int getAgentUsers(String agent , String orgi){
	/**
	 * agentno自动是 服务的坐席， agent 是请求的坐席
	 */
	PagingPredicate<String, AgentUser> pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inservice' AND agentno = '" + agent + "'  AND orgi = '" + orgi +"'") , 100 ) ;
	List<AgentUser> agentUserList = new ArrayList<AgentUser>();
	agentUserList.addAll(((IMap<String , AgentUser>) CacheHelper.getAgentUserCacheBean().getCache()).values(pagingPredicate)) ;
	return agentUserList.size();
}
 

/**
 * 为用户分配坐席
 * @param agentUser
 */
@SuppressWarnings("unchecked")
public static AgentService allotAgent(AgentUser agentUser , String orgi){
	/**
	 * 查询条件，当前在线的 坐席，并且 未达到最大 服务人数的坐席
	 */
	SessionConfig config = initSessionConfig(orgi) ;
	List<AgentStatus> agentStatusList = new ArrayList<AgentStatus>();
	PagingPredicate<String, AgentStatus> pagingPredicate = null ;
	AgentStatus agentStatus = null ;
	/**
	 * 处理ACD 的 技能组请求和 坐席请求
	 */
	if(!StringUtils.isBlank(agentUser.getAgentno()) && config.isEnablersession() && CacheHelper.getAgentStatusCacheBean().getCacheObject(agentUser.getAgentno(), agentUser.getOrgi()) != null){
		agentStatusList.add((AgentStatus) CacheHelper.getAgentStatusCacheBean().getCacheObject(agentUser.getAgentno(), agentUser.getOrgi())) ;
	}
	if(agentStatusList.size() == 0) {
		if(!StringUtils.isBlank(agentUser.getAgent()) && CacheHelper.getAgentStatusCacheBean().getCacheObject(agentUser.getAgent(), agentUser.getOrgi()) != null){
			pagingPredicate = new PagingPredicate<String, AgentStatus>(  new SqlPredicate( " busy = false AND agentno = '" + agentUser.getAgent()+"' AND orgi = '" + orgi +"'") , 1 );
		}else if(!StringUtils.isBlank(agentUser.getSkill())){
			pagingPredicate = new PagingPredicate<String, AgentStatus>(  new SqlPredicate( " busy = false AND skill = '" + agentUser.getSkill()+"' AND orgi = '" + orgi +"'") , 1 );
		}else{
			pagingPredicate = new PagingPredicate<String, AgentStatus>(  new SqlPredicate( " busy = false AND orgi = '" + orgi +"'") , 1 );
		}
		agentStatusList.addAll(((IMap<String , AgentStatus>) CacheHelper.getAgentStatusCacheBean().getCache()).values(pagingPredicate)) ;
	}
	AgentService agentService = null ;	//放入缓存的对象
	if(agentStatusList!=null && agentStatusList.size() > 0){
		agentStatus = agentStatusList.get(0) ;
		if(agentStatus !=null && config !=null && agentStatus.getUsers() >= config.getMaxuser()){
			agentStatus = null ;
			/**
			 * 判断当前有多少人排队中 ， 分三种情况：1、请求技能组的，2、请求坐席的，3，默认请求的
			 * 
			 */
			
		}
	}
	try {
		agentService = processAgentService(agentStatus, agentUser, orgi) ;
		if(agentService!=null && agentService.getStatus().equals(UKDataContext.AgentUserStatusEnum.INQUENE.toString())){
			agentService.setQueneindex(getQueneIndex(agentUser.getAgent(), orgi, agentUser.getSkill()));
		}
		
	}catch(Exception ex){
		ex.printStackTrace(); 
	}
	publishMessage(orgi, "user" , agentService!=null && agentService.getStatus().equals(UKDataContext.AgentUserStatusEnum.INSERVICE.toString()) ? "inservice" : "inquene" , agentUser.getId());
	return agentService;
}
 

/**
 * 为坐席批量分配用户
 * @param agentStatus
 */
@SuppressWarnings("unchecked")
public static void allotAgent(String agentno , String orgi){
	AgentStatus agentStatus = (AgentStatus) CacheHelper.getAgentStatusCacheBean().getCacheObject(agentno, orgi) ;
	List<AgentUser> agentStatusList = new ArrayList<AgentUser>();
	PagingPredicate<String, AgentUser> pagingPredicate = null ;
	if(agentStatus!=null && !StringUtils.isBlank(agentStatus.getSkill())){
		pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inquene' AND ((agent = null AND skill = null) OR (skill = '" + agentStatus.getSkill() + "' AND agent = null) OR agent = '"+agentno+"') AND orgi = '" + orgi +"'") , 10 );
	}else{
		pagingPredicate = new PagingPredicate<String, AgentUser>(  new SqlPredicate( "status = 'inquene' AND ((agent = null AND skill = null) OR agent = '"+agentno+"') AND orgi = '" + orgi +"'") , 10 );
	}
	agentStatusList.addAll(((IMap<String , AgentUser>) CacheHelper.getAgentUserCacheBean().getCache()).values(pagingPredicate)) ;
	for(AgentUser agentUser : agentStatusList){
		SessionConfig sessionConfig = ServiceQuene.initSessionConfig(orgi) ;
		long maxusers = sessionConfig!=null ? sessionConfig.getMaxuser() : UKDataContext.AGENT_STATUS_MAX_USER ;
		if(agentStatus != null && agentStatus.getUsers() < maxusers){		//坐席未达到最大咨询访客数量
			CacheHelper.getAgentUserCacheBean().delete(agentUser.getUserid(), orgi);		//从队列移除，进入正在处理的队列， 避免使用 分布式锁
			try{
				AgentService agentService = processAgentService(agentStatus, agentUser, orgi) ;

				MessageOutContent outMessage = new MessageOutContent() ;
				outMessage.setMessage(ServiceQuene.getSuccessMessage(agentService , agentUser.getChannel(),orgi));
				outMessage.setMessageType(UKDataContext.MediaTypeEnum.TEXT.toString());
				outMessage.setCalltype(UKDataContext.CallTypeEnum.IN.toString());
				outMessage.setNickName(agentStatus.getUsername());
				outMessage.setCreatetime(UKTools.dateFormate.format(new Date()));

				if(!StringUtils.isBlank(agentUser.getUserid())){
					OutMessageRouter router = null ; 
					router  = (OutMessageRouter) UKDataContext.getContext().getBean(agentUser.getChannel()) ;
					if(router!=null){
						router.handler(agentUser.getUserid(), UKDataContext.MessageTypeEnum.STATUS.toString(), agentUser.getAppid(), outMessage);
					}
				}

				NettyClients.getInstance().sendAgentEventMessage(agentService.getAgentno(), UKDataContext.MessageTypeEnum.NEW.toString(), agentUser);
			}catch(Exception ex){
				ex.printStackTrace();
			}
		}else{
			break ;
		}
	}
	publishMessage(orgi , "agent" , "success" , agentno);
}
 

private PagingPredicate createNewPredicate() {
    return new PagingPredicateImpl(innerPredicate, pageSize);
}