phpffcms /
ffcms
| @@ 377-388 (lines=12) @@ | ||
| 374 | // before raw: select * from `ffcms_messages` where (`target_id` = ? and `sender_id` = ?) or (`target_id` = ? and `sender_id` = ?) order by `created_at` desc |
|
| 375 | // default raw: select * from `ffcms_messages` where `id` < ? and ((`target_id` = ? and `sender_id` = ?) or (`target_id` = ? and `sender_id` = ?)) order by `created_at` desc |
|
| 376 | switch ($queryType) { |
|
| 377 | case 'after': |
|
| 378 | $messages = Message::where('id', '>', $queryId) |
|
| 379 | ->where(function ($query) use ($cor_id, $user) { |
|
| 380 | $query->where(function ($q) use ($cor_id, $user){ |
|
| 381 | $q->where('target_id', '=', $user->getId()) |
|
| 382 | ->where('sender_id', '=', $cor_id); |
|
| 383 | })->orWhere(function ($q) use ($cor_id, $user){ |
|
| 384 | $q->where('target_id', '=', $cor_id) |
|
| 385 | ->where('sender_id', '=', $user->getId()); |
|
| 386 | }); |
|
| 387 | }); |
|
| 388 | break; |
|
| 389 | case 'before': |
|
| 390 | $messages = Message::where('id', '<', $queryId) |
|
| 391 | ->where(function ($query) use ($cor_id, $user) { |
|
| @@ 389-400 (lines=12) @@ | ||
| 386 | }); |
|
| 387 | }); |
|
| 388 | break; |
|
| 389 | case 'before': |
|
| 390 | $messages = Message::where('id', '<', $queryId) |
|
| 391 | ->where(function ($query) use ($cor_id, $user) { |
|
| 392 | $query->where(function ($q) use ($cor_id, $user){ |
|
| 393 | $q->where('target_id', '=', $user->getId()) |
|
| 394 | ->where('sender_id', '=', $cor_id); |
|
| 395 | })->orWhere(function ($q) use ($cor_id, $user){ |
|
| 396 | $q->where('target_id', '=', $cor_id) |
|
| 397 | ->where('sender_id', '=', $user->getId()); |
|
| 398 | }); |
|
| 399 | }); |
|
| 400 | break; |
|
| 401 | default: |
|
| 402 | $messages = Message::where(function($query) use ($cor_id, $user) { |
|
| 403 | $query->where('target_id', '=', $user->getId()) |
|
