phpffcms /
ffcms
| @@ 341-352 (lines=12) @@ | ||
| 338 | // before raw: select * from `ffcms_messages` where (`target_id` = ? and `sender_id` = ?) or (`target_id` = ? and `sender_id` = ?) order by `created_at` desc |
|
| 339 | // 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 |
|
| 340 | switch ($queryType) { |
|
| 341 | case 'after': |
|
| 342 | $messages = Message::where('id', '>', $queryId) |
|
| 343 | ->where(function ($query) use ($cor_id, $user) { |
|
| 344 | $query->where(function ($q) use ($cor_id, $user){ |
|
| 345 | $q->where('target_id', '=', $user->getId()) |
|
| 346 | ->where('sender_id', '=', $cor_id); |
|
| 347 | })->orWhere(function ($q) use ($cor_id, $user){ |
|
| 348 | $q->where('target_id', '=', $cor_id) |
|
| 349 | ->where('sender_id', '=', $user->getId()); |
|
| 350 | }); |
|
| 351 | }); |
|
| 352 | break; |
|
| 353 | case 'before': |
|
| 354 | $messages = Message::where('id', '<', $queryId) |
|
| 355 | ->where(function ($query) use ($cor_id, $user) { |
|
| @@ 353-364 (lines=12) @@ | ||
| 350 | }); |
|
| 351 | }); |
|
| 352 | break; |
|
| 353 | case 'before': |
|
| 354 | $messages = Message::where('id', '<', $queryId) |
|
| 355 | ->where(function ($query) use ($cor_id, $user) { |
|
| 356 | $query->where(function ($q) use ($cor_id, $user){ |
|
| 357 | $q->where('target_id', '=', $user->getId()) |
|
| 358 | ->where('sender_id', '=', $cor_id); |
|
| 359 | })->orWhere(function ($q) use ($cor_id, $user){ |
|
| 360 | $q->where('target_id', '=', $cor_id) |
|
| 361 | ->where('sender_id', '=', $user->getId()); |
|
| 362 | }); |
|
| 363 | }); |
|
| 364 | break; |
|
| 365 | default: |
|
| 366 | $messages = Message::where(function($query) use ($cor_id, $user) { |
|
| 367 | $query->where('target_id', '=', $user->getId()) |
|
