getConversationMessages Sorted on user_id about tbmsg HOT 3 CLOSED

thanks,
never noticed it as it still works on only one of my projects and all the
messages are after each other,
but it really should be on created date.

Do you use this package?

On Sun, Jun 8, 2014 at 1:43 PM, RaoulDijksman [email protected]
wrote:

Messages returned from the method getConversationMessages are sorted on
user_id in an ascending mater on their user_id and not on created date.
Messages sorted on created_at is more useful.

An easy fix would be to add: 'ORDER BY msg.created_at' at the end of the
sql query.

public function getConversationMessages($conv_id, $user_id) {
$results = DB::select(
'
SELECT msg.id as msgID, msg.content, msg.created_at, us.id as userId, up.username, up.photo
FROM messages_status mst
INNER JOIN messages msg
ON mst.msg_id=msg.id
INNER JOIN users us
ON msg.sender_id=us.id
INNER JOIN profiles up
ON us.id=up.user_id
WHERE msg.conv_id=?
AND mst.user_id = ?
AND mst.status NOT IN (?,?)
ORDER BY msg.created_at
'
, array($conv_id, $user_id, self::DELETED, self::ARCHIVED));
return $results;
}

—
Reply to this email directly or view it on GitHub
#1.

Tzook Bar Noy

"Life is what happens while you are busy making other plans"

Phone: +972.52.4625353

Email: [email protected]

from tbmsg.

Yeah i do. This saved me alot of time! Thanks 👍 If i come across anything ells I'll let you know.

from tbmsg.

Great!
Well this is my first package so I'll probably improve it soon.

Make sure to put in composer json. 1.* or something so I won't break your
project

Tzook Bar Noy

"Expert In Life"

mobile: +972 52 462 5353
email: [email protected]
On Jun 8, 2014 2:01 PM, "RaoulDijksman" [email protected] wrote:

Yeah i do. This saved me alot of time! Thanks [image: 👍] If i come
across anything ells I'll let you know.

—
Reply to this email directly or view it on GitHub
#1 (comment).

from tbmsg.