A Laravel chat package. You can use this package to create a chat/messaging Laravel application.

Hi sir

i am beginner and i am install this plugin step by step. but creating message function "createConversation" but this function return required fields. i am searching in google but not any find solution.

Any one help me step by step .

I installed the package, placed the Alias and ServiceProvider in config/app.php and I am getting the following error.

Class 'Musonza\Chat\Facades\ChatFacade::class' not found

This is happening in the browser and PHPUnit tests when using a method on the Chat facade.

Describe the bug One of conversation has ~20k participants and when new message is added, the conversation generator crash with this mysql error: SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many placeholders

To Reproduce Steps to reproduce the behavior:

1. Normal instalation
2. Add conversation
3. Add hundreds of thousands of participants
4. Create a message and see the error: SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many placeholders

Expected behavior No error and all notifications created.

Screenshots

I need to refactor this createCustomNotifications method on src/Models/MessageNotification.php:

public static function createCustomNotifications($message, $conversation)
    {
        $notification = [];

        foreach ($conversation->participants as $participation) {
            $is_sender = ($message->participation_id == $participation->id) ? 1 : 0;

            $notification[] = [
                'messageable_id'   => $participation->messageable_id,
                'messageable_type' => $participation->messageable_type,
                'message_id'       => $message->id,
                'participation_id' => $participation->id,
                'conversation_id'  => $conversation->id,
                'is_seen'          => $is_sender,
                'is_sender'        => $is_sender,
                'created_at'       => $message->created_at,
            ];
        }

        self::insert($notification);
    }

How I do?

My idea: or chunk participant list in support number of MySQL, or work with jobs, sending the responsability to queue.

Checklist

• [x] Ability to use any Laravel model as participant :zap:
• [x] Update package readme, functions, tables, Models to not refer participants as users
• [x] Add tests with different Model types as participants. Passing right now because there is one Model type in use
• [x] Direct Messaging instead of referring to it as private
• [x] Package routes
• [x] Conversation settings for participant (example: mute_mentions, mute_conversation)
• [x] Fire additional events (ConversationStarted, ParticipantJoined, ParticipantLeft)
• [x] Model Transformers
• [x] https://github.com/musonza/chat/issues/104
• [x] https://github.com/musonza/chat/issues/165
• [ ] https://github.com/musonza/chat/issues/65

Demo https://github.com/musonza/chat-demo/tree/multiple-model-recipients

Release Candidate https://github.com/musonza/chat/releases/tag/v4.0.0-rc6

Hii @musonza

I have one query regarding your demo example. I have setup in local system and working very well but this is not real time messaging system. This is look like page refresh and normal ajax or vue post request.

So how can i make this demo to real time messaging system. If you have real time message system demo then you can share me.

Please explain if possible then how can convert your demo example to real time messaging system.

Can we add socket type setting to make real time system in your package of chatting? Do you thing about it?

Thanks for demo.

#66 Hello, I have:

Broadcast::channel('mc-chat-conversation.{conversation_id}', function($user) { return $user; });

App.js:

mounted() { Echo.private('mc-chat-conversation.' + this.convId) .listen('MessageWasSent', (e) => { console.log(e); this.chat.message.push(e.message); this.chat.user.push(e.user); this.chat.time.push(this.getTime()); console.log(e); }) .listenForWhisper('typing', (e) => { if(e.name != '') this.typing = 'Набирает сообщение..'; else this.typing = null; }); }

Controller:

broadcast(new MessageWasSent($message))->toOthers();

But event not received data to other user, why??? console.log(e) get empty result.

I think, that event MessageWasSent not know, that need send message to other user. He can only receive a message? Why??

A column ('data') to store details about each message was added. For instance, if our message type is an image, we can add the image link, or if it is a link we can store the link and attachment details in it. The conversation table already has this column, I think there is a need for this in the message table too.

Hi, great work

But here I faced an issue, when I try to get all messages for user Chat::conversation($conversation)->setUser($user)->getMessages() I get only 25 of them.

In your ConversationService class getMessages method there is no way to pass any paginate params. I don't know is it bug or not but is there are a way to fetch all the messages for user? Thank you

I have function:

public function setMessagesSeen(Conversation $conversation, Request $request) {
$v = Validator::make($request->all(), [
    'message' => 'required|string|max:4000',
]);

$user = User::find(Auth::id());

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

//$message = Chat::conversations($conversations)->for($user)->getMessages()->where('body', $request->message)->where('user_id', '<>', $user->id);

//$message->markRead();

//var_dump($message); exit;

broadcast(new MessageIsSeen($message));

return response('ok'); }

I have a post request:

methods: {
    seenMessage() {
        if(this.message.length != 0) {
            axios.post('/setMessagesSeen/' + this.convId, {
                message: this.message,
            })
            .then( response => { $('li').removeClass('unread'); }) 
            .catch( response => { console.log(response) } )
        }
},

How I can correctly read message for users? I need add/remove class to div in app.js, when message is readed for user. But how check this and mark correctly read message, I need message id?

Hi Musonza,

I am getting an sql error when I used the getMessages method.

my code ::

public function chats() { $currentuser = Auth::user();

		$conversations = Chat::getConversationBetween($currentuser, 1);

		$messages = Chat::conversations()->for($currentuser)->limit(25)->page(1)->get();

		//return view('chats',['conversation' => $conversations, 'messages' => $messages]);

		//return $messages;
}

it shows the below error ::

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."message_id"' = mc_messages.id where mc_messages.conversation_id in ' at line 1 (SQL: select notifications., mc_messages. from mc_messages inner join notifications on notifications.data->'$."message_id"' = mc_messages.id where mc_messages.conversation_id in (1) order by mc_messages.id desc)

Please Suggest me something :)

Could you please explain how I can start conversation with oneself with existing structure of the table (but before that check if there is already conversation with oneself)? Also before starting conversation with oneself I have already other conversations.

How can I add unreadCount to

$chats =   Chat::conversations()->setPaginationParams([
            'page' => request()->get('page', 1),
            'perPage' => 10,
            'sorting' => "desc",
            'columns' => [
                '*'
            ],
        ])
            ->setParticipant(request()->user())
            ->get();

I try

$user1 = User::find(1); $user2 = User::find(2); $conversation = Chat::conversations()->between($user1, $user2); return $conversation;

in my controller

This allows developers to override default connection on package models by adding a key of database_connection in config/musonza_chat.php. I would like to use this in a project I am working on right now but I am unable to because I need to use a different database connection from the default. This change will not affect existing applications already using the default connection. No configuration changes are need for migrations, one can simply pass --database[=DATABASE] at the time of migration.

Please accept my pull request so that I may use this package. Thank you!

According to the documentation, you can Get common conversations among participants using:

$conversations = Chat::conversations()->common($participants);

But that method doesn't exist.

Steps to reproduce the behavior:

$participants = [$model1, $model2];
$conversations = Chat::conversations()->common($participants);

Expected behavior Return a list of conversations between $model1 and $model2.

Additional context The between() method could be used for this, however, that method only works for 2 models and conversations that are private.

I'm trying to retrieve a list of all the Models (participants) that a certain Model ever had a conversation with.

My chat screen has 3 columns:

1. list of contacts (grouped, so each contact is displayed only once and sorted by latest message first)
2. list of conversations with the selected contact
3. messages inside the selected conversation

My question is regarding the first column. Is this possible?

I tried it with this query to get all participants for User with id 1, which works, but doesn't group the participants:

Musonza\Chat\Models\Conversation::query()
    ->whereHas('participants', function($query) {
        $query->whereHasMorph(
            'messageable',
            [User::class],
            function ($query) {
                $query->where('id', 1);
            })
            ->groupBy(['messageable_type', 'messageable_id']);
    })
    ->get()