Examples with MessageVO com.fanap.podchat.mainmodel.MessageVO used on opensource projects

Example 46 with MessageVO

use of com.fanap.podchat.mainmodel.MessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getMentionList.

public void getMentionList(RequestGetMentionList request, FunctionalListener listener) {
    worker(() -> {
        List<MessageVO> messageVOS = new ArrayList<>();
        List<CacheMessageVO> cacheMessageVOS = new ArrayList<>();
        String condition;
        condition = request.getUnreadMentioned() != null && request.getUnreadMentioned() ? " and seen = false " : " ";
        String rawQuery = "SELECT * FROM CacheMessageVO WHERE threadVoId = " + request.getThreadId() + " and mentioned = true" + condition + "ORDER BY timeStamp ASC LIMIT " + request.getCount() + " OFFSET " + request.getOffset();
        SupportSQLiteQuery sqLiteQuery = new SimpleSQLiteQuery(rawQuery);
        cacheMessageVOS = messageDao.getRawHistory(sqLiteQuery);
        String contentCountQuery = "SELECT count(*) FROM CacheMessageVO WHERE threadVoId = " + request.getThreadId() + " and mentioned = true" + condition;
        long contentCount = messageDao.getHistoryContentCount(new SimpleSQLiteQuery(contentCountQuery));
        prepareMessageVOs(messageVOS, cacheMessageVOS);
        if (messageVOS.size() > 0)
            listener.onWorkDone(messageVOS, contentCount);
    });
}

Example 47 with MessageVO

use of com.fanap.podchat.mainmodel.MessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getHistories.

public void getHistories(@NonNull History history, long threadId, OnWorkDone listener) {
    List<MessageVO> messageVOS = new ArrayList<>();
    List<CacheMessageVO> cacheMessageVOS;
    long fromTime = history.getFromTime();
    long fromTimeNanos = history.getFromTimeNanos();
    long toTime = history.getToTime();
    long toTimeNanos = history.getToTimeNanos();
    long messageId = history.getId();
    long offset = history.getOffset();
    long count = history.getCount();
    int messageType = history.getMessageType();
    String query = history.getQuery();
    String order = history.getOrder();
    offset = offset >= 0 ? offset : 0;
    count = count > 0 ? count : 50;
    if (Util.isNullOrEmpty(order)) {
        order = "desc";
    }
    String rawQuery = "SELECT * FROM CacheMessageVO WHERE threadVoId =" + threadId;
    rawQuery = addMessageIdIfExist(messageId, rawQuery);
    rawQuery = addFromTimeIfExist(fromTime, fromTimeNanos, rawQuery);
    rawQuery = addToTimeIfExist(toTime, toTimeNanos, rawQuery);
    rawQuery = addQueryIfExist(query, rawQuery);
    rawQuery = addMessageTypeIfExist(messageType, rawQuery);
    long contentCount = messageDao.getHistoryContentCount(new SimpleSQLiteQuery(rawQuery.replaceFirst("SELECT \\* ", "SELECT COUNT(ID) ")));
    rawQuery = addOrderAndLimitAndOffset(offset, count, order, rawQuery);
    SupportSQLiteQuery sqLiteQuery = new SimpleSQLiteQuery(rawQuery);
    cacheMessageVOS = messageDao.getRawHistory(sqLiteQuery);
    prepareMessageVOs(messageVOS, cacheMessageVOS);
    List<Sending> sendingList = getAllSendingQueueByThreadId(threadId);
    List<Uploading> uploadingList = getAllUploadingQueueByThreadId(threadId);
    List<Failed> failedList = getAllWaitQueueCacheByThreadId(threadId);
    ChatResponse<ResultHistory> chatResponse = new ChatResponse<>();
    chatResponse.setCache(true);
    ResultHistory resultHistory = new ResultHistory();
    resultHistory.setHistory(messageVOS);
    resultHistory.setNextOffset(history.getOffset() + messageVOS.size());
    resultHistory.setContentCount(contentCount);
    if (messageVOS.size() + history.getOffset() < contentCount) {
        resultHistory.setHasNext(true);
    } else {
        resultHistory.setHasNext(false);
    }
    resultHistory.setHistory(messageVOS);
    resultHistory.setSending(sendingList);
    resultHistory.setUploadingQueue(uploadingList);
    resultHistory.setFailed(failedList);
    chatResponse.setErrorCode(0);
    chatResponse.setHasError(false);
    chatResponse.setErrorMessage("");
    chatResponse.setResult(resultHistory);
    chatResponse.setCache(true);
    chatResponse.setSubjectId(threadId);
    listener.onWorkDone(chatResponse);
}

Example 48 with MessageVO

use of com.fanap.podchat.mainmodel.MessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getHashTagList.

public void getHashTagList(RequestGetHashTagList request, FunctionalListener listener) {
    worker(() -> {
        List<MessageVO> messageVOS = new ArrayList<>();
        List<CacheMessageVO> cacheMessageVOS = new ArrayList<>();
        String condistion = "'%" + request.getHashtag() + "%'";
        String rawQuery = "SELECT * FROM CacheMessageVO WHERE threadVoId = " + request.getThreadId() + " And hashtags LIKE " + condistion;
        SupportSQLiteQuery sqLiteQuery = new SimpleSQLiteQuery(rawQuery);
        cacheMessageVOS = messageDao.getRawHistory(sqLiteQuery);
        String contentCountQuery = "SELECT count(*) FROM CacheMessageVO WHERE threadVoId = " + request.getThreadId() + " And hashtags LIKE " + condistion;
        long contentCount = messageDao.getHistoryContentCount(new SimpleSQLiteQuery(contentCountQuery));
        prepareMessageVOs(messageVOS, cacheMessageVOS);
        if (messageVOS.size() > 0)
            listener.onWorkDone(messageVOS, contentCount);
    });
}