any way to query specific types of messages

[keinagae]

any way to query specific types of messages

[tolgatasci]

if you wish use eloquent

Chat::where() or scope
https://laravel.com/docs/8.x/eloquent

You can generate queries of your own.

dont forget

https://github.com/musonza/chat#data-transformers

[dhi2]

You can reuse the getConversationMessages function from here:

chat/src/Models/Conversation.php

Line 319 in a229349

private function getConversationMessages(Model $participant, $paginationParams, $deleted)

Like this:

$conversation = Chat::conversations()->getById(request('id'));

$tablePrefix = 'chat_';

$paginationParams = [
    'pageName' => 'page',
    'page' => request('page') ? request('page') : 1,
    'perPage' => 10,
    'sorting' => "desc"
];

$message_types = array(); // <- Add message types to this array

$messages = Chat::conversation($conversation)->setParticipant($user)
    ->conversation
    ->messages()
    ->join($tablePrefix.'message_notifications', $tablePrefix.'message_notifications.message_id', '=', $tablePrefix.'messages.id')
    ->where($tablePrefix.'message_notifications.messageable_type', $user->getMorphClass())
    ->where($tablePrefix.'message_notifications.messageable_id', $user->getKey())
    ->when(!empty($message_types), function($query) use ($message_types) {
        $query->whereIn('type', $message_types);
    })
    ->orderBy($tablePrefix.'messages.id', $paginationParams['sorting'])
    ->paginate(
        $paginationParams['perPage'],
        [
            $tablePrefix.'message_notifications.updated_at as read_at',
            $tablePrefix.'message_notifications.deleted_at as deleted_at',
            $tablePrefix.'message_notifications.messageable_id',
            $tablePrefix.'message_notifications.id as notification_id',
            $tablePrefix.'message_notifications.is_seen',
            $tablePrefix.'message_notifications.is_sender',
            $tablePrefix.'messages.*',
        ],
        $paginationParams['pageName'],
        $paginationParams['page']
    );