Search in sources :

Example 1 with CacheMessageVO

use of com.fanap.podchat.cachemodel.CacheMessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method saveHistory.

private void saveHistory(@NonNull List<CacheMessageVO> messageVOS, long threadId) {
    worker(() -> {
        for (CacheMessageVO cacheMessageVO : messageVOS) {
            cacheMessageVO.setThreadVoId(threadId);
            long time = cacheMessageVO.getTime();
            long timeNanos = cacheMessageVO.getTimeNanos();
            long pow = (long) Math.pow(10, 9);
            long timestamp = ((time / 1000) * pow) + timeNanos;
            cacheMessageVO.setTimeStamp(timestamp);
            if (cacheMessageVO.getParticipant() != null) {
                cacheMessageVO.setParticipantId(cacheMessageVO.getParticipant().getId());
                messageDao.insertParticipant(cacheMessageVO.getParticipant());
            }
            if (cacheMessageVO.getConversation() != null) {
                cacheMessageVO.setConversationId(cacheMessageVO.getConversation().getId());
            }
            if (cacheMessageVO.getForwardInfo() != null) {
                cacheMessageVO.setForwardInfoId(cacheMessageVO.getForwardInfo().getId());
                messageDao.insertForwardInfo(cacheMessageVO.getForwardInfo());
                if (cacheMessageVO.getForwardInfo().getParticipant() != null) {
                    cacheMessageVO.getForwardInfo().setParticipantId(cacheMessageVO.getForwardInfo().getParticipant().getId());
                    messageDao.insertParticipant(cacheMessageVO.getForwardInfo().getParticipant());
                }
            }
            if (cacheMessageVO.getReplyInfoVO() != null) {
                CacheReplyInfoVO cacheReplyInfoVO = cacheMessageVO.getReplyInfoVO();
                cacheMessageVO.setReplyInfoVOId(cacheReplyInfoVO.getRepliedToMessageId());
                if (cacheReplyInfoVO.getParticipant() != null) {
                    CacheParticipant cacheReplyParticipant = cacheReplyInfoVO.getParticipant();
                    cacheReplyInfoVO.setParticipantId(cacheReplyParticipant.getId());
                    messageDao.insertParticipant(cacheReplyParticipant);
                }
                messageDao.insertReplyInfoVO(cacheReplyInfoVO);
            }
        }
        messageDao.insertHistories(messageVOS);
    });
}
Also used : CacheParticipant(com.fanap.podchat.cachemodel.CacheParticipant) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO)

Example 2 with CacheMessageVO

use of com.fanap.podchat.cachemodel.CacheMessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getThreadRaw.

public void getThreadRaw(Integer count, Long offset, @Nullable ArrayList<Integer> threadIds, @Nullable String threadName, boolean isNew, OnWorkDone listener) throws RoomIntegrityException {
    if (!canUseDatabase())
        throw new RoomIntegrityException();
    worker(() -> {
        String sQuery;
        final String ORDER = "order by pin desc,time desc";
        sQuery = "select * from ThreadVo " + ORDER;
        if (threadName != null && !isNew) {
            sQuery = "select * from ThreadVo where title LIKE '%" + threadName + "%' " + ORDER;
        }
        if (threadIds != null && threadIds.size() > 0 && !isNew) {
            StringBuilder stringBuilder = new StringBuilder();
            for (int id : threadIds) {
                stringBuilder.append(id).append(",");
            }
            String stringIds = stringBuilder.toString();
            String lastString = stringIds.replaceAll(",$", "");
            if (threadName != null) {
                sQuery = "select * from ThreadVo where id IN " + "(" + lastString + ")" + "AND title LIKE  '%" + threadName + "%' " + ORDER;
            } else {
                sQuery = "select * from ThreadVo where id IN " + "(" + lastString + ")" + " " + ORDER;
            }
        }
        // only threads with unreadCount > 0 if isNew == true
        if (isNew) {
            sQuery = "select * from ThreadVo where unreadCount > 0 " + ORDER;
        }
        long contentCount = 0;
        SimpleSQLiteQuery countQuery = new SimpleSQLiteQuery(sQuery.replaceFirst("select \\* ", "select count(id) "));
        contentCount = messageDao.getThreadContentCount(countQuery);
        sQuery += getPaging(count, offset);
        SimpleSQLiteQuery query = new SimpleSQLiteQuery(sQuery);
        List<ThreadVo> threadVos = messageDao.getThreadRaw(query);
        List<Thread> threads = new ArrayList<>();
        if (threadVos != null) {
            for (ThreadVo threadVo : threadVos) {
                if (threadVo.getId() == 0)
                    continue;
                CacheParticipant cacheParticipant;
                CacheReplyInfoVO cacheReplyInfoVO;
                Participant participant = null;
                ReplyInfoVO replyInfoVO = null;
                @Nullable MessageVO lastMessageVO = null;
                if (threadVo.getInviterId() > 0) {
                    threadVo.setInviter(messageDao.getInviter(threadVo.getInviterId()));
                }
                if (threadVo.getLastMessageVOId() > 0) {
                    threadVo.setLastMessageVO(messageDao.getLastMessageVO(threadVo.getLastMessageVOId()));
                    CacheMessageVO cacheLastMessageVO = threadVo.getLastMessageVO();
                    if (cacheLastMessageVO != null) {
                        if (cacheLastMessageVO.getParticipantId() != null) {
                            cacheParticipant = messageDao.getParticipant(cacheLastMessageVO.getParticipantId());
                            if (cacheParticipant != null) {
                                participant = cacheToParticipantMapper(cacheParticipant, null, null);
                            }
                        }
                        if (cacheLastMessageVO.getReplyInfoVOId() != null) {
                            cacheReplyInfoVO = messageDao.getReplyInfo(cacheLastMessageVO.getReplyInfoVOId());
                            if (cacheReplyInfoVO != null)
                                replyInfoVO = new ReplyInfoVO(cacheReplyInfoVO.getRepliedToMessageId(), cacheReplyInfoVO.getMessageType(), cacheReplyInfoVO.isDeleted(), cacheReplyInfoVO.getRepliedToMessage(), cacheReplyInfoVO.getSystemMetadata(), cacheReplyInfoVO.getMetadata(), cacheReplyInfoVO.getMessage(), cacheReplyInfoVO.getRepliedToMessageTime(), cacheReplyInfoVO.getRepliedToMessageNanos());
                        }
                        lastMessageVO = cacheMessageVoToMessageVoMapper(participant, replyInfoVO, null, cacheLastMessageVO);
                    }
                }
                // adding pinned message of thread if exist
                addPinnedMessageOfThread(threadVo);
                Thread thread = threadVoToThreadMapper(threadVo, lastMessageVO);
                threads.add(thread);
            }
        }
        listener.onWorkDone(threads);
        listener.onWorkDone(contentCount, threads);
    });
}
Also used : ArrayList(java.util.ArrayList) Thread(com.fanap.podchat.mainmodel.Thread) ThreadVo(com.fanap.podchat.cachemodel.ThreadVo) CacheThreadParticipant(com.fanap.podchat.cachemodel.CacheThreadParticipant) CacheParticipant(com.fanap.podchat.cachemodel.CacheParticipant) Participant(com.fanap.podchat.mainmodel.Participant) CacheCallParticipant(com.fanap.podchat.call.persist.CacheCallParticipant) SimpleSQLiteQuery(android.arch.persistence.db.SimpleSQLiteQuery) CacheParticipant(com.fanap.podchat.cachemodel.CacheParticipant) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO) ReplyInfoVO(com.fanap.podchat.model.ReplyInfoVO) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) PinMessageVO(com.fanap.podchat.mainmodel.PinMessageVO) MessageVO(com.fanap.podchat.mainmodel.MessageVO) GapMessageVO(com.fanap.podchat.cachemodel.GapMessageVO) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) Nullable(android.support.annotation.Nullable)

Example 3 with CacheMessageVO

use of com.fanap.podchat.cachemodel.CacheMessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getThreadHistory.

public Observable<ChatResponse<ResultHistory>> getThreadHistory(@NonNull SearchSystemMetadataRequest request) {
    return rx.Observable.create(subscriber -> {
        List<MessageVO> messageVOS = new ArrayList<>();
        List<CacheMessageVO> cacheMessageVOS;
        long offset = request.getOffset();
        long count = request.getCount();
        String order = request.getOrder();
        offset = offset >= 0 ? offset : 0;
        count = count > 0 ? count : 50;
        if (Util.isNullOrEmpty(order)) {
            order = "desc";
        }
        String rawQuery = "SELECT * FROM CacheMessageVO WHERE threadVoId =" + request.getMessageThreadId();
        // rawQuery = rawQuery + " AND system_metadata_" + request.getMetadataCriteria().getField() + " >= " + request.getMetadataCriteria().getGte();
        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(request.getMessageThreadId());
        List<Uploading> uploadingList = getAllUploadingQueueByThreadId(request.getMessageThreadId());
        List<Failed> failedList = getAllWaitQueueCacheByThreadId(request.getMessageThreadId());
        ChatResponse<ResultHistory> chatResponse = new ChatResponse<>();
        chatResponse.setCache(true);
        ResultHistory resultHistory = new ResultHistory();
        resultHistory.setHistory(messageVOS);
        resultHistory.setNextOffset(request.getOffset() + messageVOS.size());
        resultHistory.setContentCount(contentCount);
        if (messageVOS.size() + request.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(request.getMessageThreadId());
        subscriber.onNext(chatResponse);
    });
}
Also used : Sending(com.fanap.podchat.cachemodel.queue.Sending) SupportSQLiteQuery(android.arch.persistence.db.SupportSQLiteQuery) Failed(com.fanap.podchat.cachemodel.queue.Failed) ArrayList(java.util.ArrayList) Uploading(com.fanap.podchat.cachemodel.queue.Uploading) ResultHistory(com.fanap.podchat.model.ResultHistory) SimpleSQLiteQuery(android.arch.persistence.db.SimpleSQLiteQuery) ChatResponse(com.fanap.podchat.model.ChatResponse) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) PinMessageVO(com.fanap.podchat.mainmodel.PinMessageVO) MessageVO(com.fanap.podchat.mainmodel.MessageVO) GapMessageVO(com.fanap.podchat.cachemodel.GapMessageVO) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO)

Example 4 with CacheMessageVO

use of com.fanap.podchat.cachemodel.CacheMessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method getThreadsByThreadName.

public List<Thread> getThreadsByThreadName(String threadName) {
    List<Thread> threads;
    List<ThreadVo> listThreadVo = messageDao.getThreadByName(50, 0, threadName);
    if (listThreadVo != null) {
        threads = new ArrayList<>();
        for (ThreadVo threadVo : listThreadVo) {
            CacheParticipant cacheParticipant;
            CacheReplyInfoVO cacheReplyInfoVO;
            Participant participant = null;
            ReplyInfoVO replyInfoVO = null;
            MessageVO lastMessageVO = null;
            if (threadVo.getInviterId() > 0) {
                threadVo.setInviter(messageDao.getInviter(threadVo.getInviterId()));
            }
            if (threadVo.getLastMessageVOId() > 0) {
                threadVo.setLastMessageVO(messageDao.getLastMessageVO(threadVo.getLastMessageVOId()));
                CacheMessageVO cacheLastMessageVO = threadVo.getLastMessageVO();
                if (cacheLastMessageVO != null) {
                    if (cacheLastMessageVO.getParticipantId() != null) {
                        cacheParticipant = messageDao.getParticipant(cacheLastMessageVO.getParticipantId());
                        participant = cacheToParticipantMapper(cacheParticipant, null, null);
                    }
                    if (cacheLastMessageVO.getReplyInfoVOId() != null) {
                        cacheReplyInfoVO = messageDao.getReplyInfo(cacheLastMessageVO.getReplyInfoVOId());
                        if (cacheReplyInfoVO != null)
                            replyInfoVO = new ReplyInfoVO(cacheReplyInfoVO.getRepliedToMessageId(), cacheReplyInfoVO.getMessageType(), cacheReplyInfoVO.isDeleted(), cacheReplyInfoVO.getRepliedToMessage(), cacheReplyInfoVO.getSystemMetadata(), cacheReplyInfoVO.getMetadata(), cacheReplyInfoVO.getMessage(), cacheReplyInfoVO.getRepliedToMessageTime(), cacheReplyInfoVO.getRepliedToMessageNanos());
                    }
                    lastMessageVO = cacheMessageVoToMessageVoMapper(participant, replyInfoVO, null, cacheLastMessageVO);
                }
            }
            // adding pinned message of thread if exist
            addPinnedMessageOfThread(threadVo);
            Thread thread = threadVoToThreadMapper(threadVo, lastMessageVO);
            threads.add(thread);
        }
    } else {
        return new ArrayList<>();
    }
    return threads;
}
Also used : ThreadVo(com.fanap.podchat.cachemodel.ThreadVo) CacheThreadParticipant(com.fanap.podchat.cachemodel.CacheThreadParticipant) CacheParticipant(com.fanap.podchat.cachemodel.CacheParticipant) Participant(com.fanap.podchat.mainmodel.Participant) CacheCallParticipant(com.fanap.podchat.call.persist.CacheCallParticipant) ArrayList(java.util.ArrayList) CacheParticipant(com.fanap.podchat.cachemodel.CacheParticipant) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO) ReplyInfoVO(com.fanap.podchat.model.ReplyInfoVO) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) PinMessageVO(com.fanap.podchat.mainmodel.PinMessageVO) MessageVO(com.fanap.podchat.mainmodel.MessageVO) GapMessageVO(com.fanap.podchat.cachemodel.GapMessageVO) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) Thread(com.fanap.podchat.mainmodel.Thread)

Example 5 with CacheMessageVO

use of com.fanap.podchat.cachemodel.CacheMessageVO in project pod-chat-android-sdk by FanapSoft.

the class MessageDatabaseHelper method updateThreadLastMessage.

private void updateThreadLastMessage(Thread thread, ThreadVo threadVo) {
    CacheMessageVO cacheMessageVO = null;
    CacheReplyInfoVO cacheReplyInfoVO;
    CacheForwardInfo cacheForwardInfo;
    if (thread.getLastMessageVO() != null)
        cacheMessageVO = insertLastMessage(thread, threadVo);
    if (cacheMessageVO == null)
        return;
    if (threadVo.getLastMessageVO().getParticipant() != null) {
        insertParticipant(cacheMessageVO, threadVo);
    }
    if (threadVo.getLastMessageVO().getReplyInfoVO() != null) {
        cacheReplyInfoVO = insertReplyInfo(cacheMessageVO, threadVo);
        if (threadVo.getLastMessageVO().getReplyInfoVO().getParticipant() != null) {
            insertReplyParticipant(cacheReplyInfoVO, threadVo);
        }
    }
    if (threadVo.getLastMessageVO().getForwardInfo() != null) {
        cacheForwardInfo = insertForwardInfo(cacheMessageVO, threadVo);
        if (threadVo.getLastMessageVO().getForwardInfo().getParticipant() != null) {
            insertForwardInfo(cacheForwardInfo, threadVo);
        }
        if (threadVo.getLastMessageVO().getForwardInfo().getConversation() != null) {
            insertConversationSummary(cacheForwardInfo, threadVo);
        }
    }
}
Also used : CacheForwardInfo(com.fanap.podchat.cachemodel.CacheForwardInfo) CacheMessageVO(com.fanap.podchat.cachemodel.CacheMessageVO) CacheReplyInfoVO(com.fanap.podchat.cachemodel.CacheReplyInfoVO)

Aggregations

CacheMessageVO (com.fanap.podchat.cachemodel.CacheMessageVO)22 MessageVO (com.fanap.podchat.mainmodel.MessageVO)15 GapMessageVO (com.fanap.podchat.cachemodel.GapMessageVO)14 PinMessageVO (com.fanap.podchat.mainmodel.PinMessageVO)14 ArrayList (java.util.ArrayList)12 SimpleSQLiteQuery (android.arch.persistence.db.SimpleSQLiteQuery)8 SupportSQLiteQuery (android.arch.persistence.db.SupportSQLiteQuery)7 CacheParticipant (com.fanap.podchat.cachemodel.CacheParticipant)7 CacheReplyInfoVO (com.fanap.podchat.cachemodel.CacheReplyInfoVO)7 ThreadVo (com.fanap.podchat.cachemodel.ThreadVo)6 CacheThreadParticipant (com.fanap.podchat.cachemodel.CacheThreadParticipant)5 CacheCallParticipant (com.fanap.podchat.call.persist.CacheCallParticipant)5 Participant (com.fanap.podchat.mainmodel.Participant)5 Thread (com.fanap.podchat.mainmodel.Thread)5 ReplyInfoVO (com.fanap.podchat.model.ReplyInfoVO)5 Failed (com.fanap.podchat.cachemodel.queue.Failed)3 Sending (com.fanap.podchat.cachemodel.queue.Sending)3 Uploading (com.fanap.podchat.cachemodel.queue.Uploading)3 ChatResponse (com.fanap.podchat.model.ChatResponse)3 ResultHistory (com.fanap.podchat.model.ResultHistory)3