PublicApiController.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709
  1. <?php
  2. namespace App\Http\Controllers;
  3. use Illuminate\Http\Request;
  4. use App\{
  5. Hashtag,
  6. Follower,
  7. Like,
  8. Media,
  9. Notification,
  10. Profile,
  11. StatusHashtag,
  12. Status,
  13. StatusView,
  14. UserFilter
  15. };
  16. use Auth, Cache;
  17. use Carbon\Carbon;
  18. use League\Fractal;
  19. use App\Transformer\Api\{
  20. AccountTransformer,
  21. RelationshipTransformer,
  22. StatusTransformer,
  23. StatusStatelessTransformer
  24. };
  25. use App\Services\{
  26. AccountService,
  27. LikeService,
  28. PublicTimelineService,
  29. StatusService,
  30. SnowflakeService,
  31. UserFilterService
  32. };
  33. use App\Jobs\StatusPipeline\NewStatusPipeline;
  34. use League\Fractal\Serializer\ArraySerializer;
  35. use League\Fractal\Pagination\IlluminatePaginatorAdapter;
  36. class PublicApiController extends Controller
  37. {
  38. protected $fractal;
  39. public function __construct()
  40. {
  41. $this->fractal = new Fractal\Manager();
  42. $this->fractal->setSerializer(new ArraySerializer());
  43. }
  44. protected function getUserData($user)
  45. {
  46. if(!$user) {
  47. return [];
  48. } else {
  49. return AccountService::get($user->profile_id);
  50. }
  51. }
  52. protected function getLikes($status)
  53. {
  54. if(false == Auth::check()) {
  55. return [];
  56. } else {
  57. $profile = Auth::user()->profile;
  58. if($profile->status) {
  59. return [];
  60. }
  61. $likes = $status->likedBy()->orderBy('created_at','desc')->paginate(10);
  62. $collection = new Fractal\Resource\Collection($likes, new AccountTransformer());
  63. return $this->fractal->createData($collection)->toArray();
  64. }
  65. }
  66. protected function getShares($status)
  67. {
  68. if(false == Auth::check()) {
  69. return [];
  70. } else {
  71. $profile = Auth::user()->profile;
  72. if($profile->status) {
  73. return [];
  74. }
  75. $shares = $status->sharedBy()->orderBy('created_at','desc')->paginate(10);
  76. $collection = new Fractal\Resource\Collection($shares, new AccountTransformer());
  77. return $this->fractal->createData($collection)->toArray();
  78. }
  79. }
  80. public function status(Request $request, $username, int $postid)
  81. {
  82. $profile = Profile::whereUsername($username)->whereNull('status')->firstOrFail();
  83. $status = Status::whereProfileId($profile->id)->findOrFail($postid);
  84. $this->scopeCheck($profile, $status);
  85. if(!Auth::check()) {
  86. $res = Cache::remember('wapi:v1:status:stateless_byid:' . $status->id, now()->addMinutes(30), function() use($status) {
  87. $item = new Fractal\Resource\Item($status, new StatusStatelessTransformer());
  88. $res = [
  89. 'status' => $this->fractal->createData($item)->toArray(),
  90. ];
  91. return $res;
  92. });
  93. return response()->json($res);
  94. }
  95. $item = new Fractal\Resource\Item($status, new StatusStatelessTransformer());
  96. $res = [
  97. 'status' => $this->fractal->createData($item)->toArray(),
  98. ];
  99. return response()->json($res);
  100. }
  101. public function statusState(Request $request, $username, int $postid)
  102. {
  103. $profile = Profile::whereUsername($username)->whereNull('status')->firstOrFail();
  104. $status = Status::whereProfileId($profile->id)->findOrFail($postid);
  105. $this->scopeCheck($profile, $status);
  106. if(!Auth::check()) {
  107. $res = [
  108. 'user' => [],
  109. 'likes' => [],
  110. 'shares' => [],
  111. 'reactions' => [
  112. 'liked' => false,
  113. 'shared' => false,
  114. 'bookmarked' => false,
  115. ],
  116. ];
  117. return response()->json($res);
  118. }
  119. $res = [
  120. 'user' => $this->getUserData($request->user()),
  121. 'likes' => [],
  122. 'shares' => [],
  123. 'reactions' => [
  124. 'liked' => (bool) $status->liked(),
  125. 'shared' => (bool) $status->shared(),
  126. 'bookmarked' => (bool) $status->bookmarked(),
  127. ],
  128. ];
  129. return response()->json($res);
  130. }
  131. public function statusComments(Request $request, $username, int $postId)
  132. {
  133. $this->validate($request, [
  134. 'min_id' => 'nullable|integer|min:1',
  135. 'max_id' => 'nullable|integer|min:1|max:'.PHP_INT_MAX,
  136. 'limit' => 'nullable|integer|min:5|max:50'
  137. ]);
  138. $limit = $request->limit ?? 10;
  139. $profile = Profile::whereNull('status')->findOrFail($username);
  140. $status = Status::whereProfileId($profile->id)->whereCommentsDisabled(false)->findOrFail($postId);
  141. $this->scopeCheck($profile, $status);
  142. if(Auth::check()) {
  143. $p = Auth::user()->profile;
  144. $filtered = UserFilter::whereUserId($p->id)
  145. ->whereFilterableType('App\Profile')
  146. ->whereIn('filter_type', ['mute', 'block'])
  147. ->pluck('filterable_id')->toArray();
  148. $scope = $p->id == $status->profile_id ? ['public', 'private', 'unlisted'] : ['public','unlisted'];
  149. } else {
  150. $filtered = [];
  151. $scope = ['public', 'unlisted'];
  152. }
  153. if($request->filled('min_id') || $request->filled('max_id')) {
  154. if($request->filled('min_id')) {
  155. $replies = $status->comments()
  156. ->whereNull('reblog_of_id')
  157. ->whereIn('scope', $scope)
  158. ->whereNotIn('profile_id', $filtered)
  159. ->select('id', 'caption', 'local', 'visibility', 'scope', 'is_nsfw', 'rendered', 'profile_id', 'in_reply_to_id', 'type', 'reply_count', 'created_at')
  160. ->where('id', '>=', $request->min_id)
  161. ->orderBy('id', 'desc')
  162. ->paginate($limit);
  163. }
  164. if($request->filled('max_id')) {
  165. $replies = $status->comments()
  166. ->whereNull('reblog_of_id')
  167. ->whereIn('scope', $scope)
  168. ->whereNotIn('profile_id', $filtered)
  169. ->select('id', 'caption', 'local', 'visibility', 'scope', 'is_nsfw', 'rendered', 'profile_id', 'in_reply_to_id', 'type', 'reply_count', 'created_at')
  170. ->where('id', '<=', $request->max_id)
  171. ->orderBy('id', 'desc')
  172. ->paginate($limit);
  173. }
  174. } else {
  175. $replies = $status->comments()
  176. ->whereNull('reblog_of_id')
  177. ->whereIn('scope', $scope)
  178. ->whereNotIn('profile_id', $filtered)
  179. ->select('id', 'caption', 'local', 'visibility', 'scope', 'is_nsfw', 'rendered', 'profile_id', 'in_reply_to_id', 'type', 'reply_count', 'created_at')
  180. ->orderBy('id', 'desc')
  181. ->paginate($limit);
  182. }
  183. $resource = new Fractal\Resource\Collection($replies, new StatusTransformer(), 'data');
  184. $resource->setPaginator(new IlluminatePaginatorAdapter($replies));
  185. $res = $this->fractal->createData($resource)->toArray();
  186. return response()->json($res, 200, [], JSON_PRETTY_PRINT);
  187. }
  188. public function statusLikes(Request $request, $username, $id)
  189. {
  190. abort_if(!$request->user(), 404);
  191. $status = Status::findOrFail($id);
  192. $this->scopeCheck($status->profile, $status);
  193. $page = $request->input('page');
  194. if($page && $page >= 3 && $request->user()->profile_id != $status->profile_id) {
  195. return response()->json([
  196. 'data' => []
  197. ]);
  198. }
  199. $likes = $this->getLikes($status);
  200. return response()->json([
  201. 'data' => $likes
  202. ]);
  203. }
  204. public function statusShares(Request $request, $username, $id)
  205. {
  206. abort_if(!$request->user(), 404);
  207. $profile = Profile::whereUsername($username)->whereNull('status')->firstOrFail();
  208. $status = Status::whereProfileId($profile->id)->findOrFail($id);
  209. $this->scopeCheck($profile, $status);
  210. $page = $request->input('page');
  211. if($page && $page >= 3 && $request->user()->profile_id != $status->profile_id) {
  212. return response()->json([
  213. 'data' => []
  214. ]);
  215. }
  216. $shares = $this->getShares($status);
  217. return response()->json([
  218. 'data' => $shares
  219. ]);
  220. }
  221. protected function scopeCheck(Profile $profile, Status $status)
  222. {
  223. if($profile->is_private == true && Auth::check() == false) {
  224. abort(404);
  225. }
  226. switch ($status->scope) {
  227. case 'public':
  228. case 'unlisted':
  229. break;
  230. case 'private':
  231. $user = Auth::check() ? Auth::user() : false;
  232. if(!$user) {
  233. abort(403);
  234. } else {
  235. $follows = $profile->followedBy($user->profile);
  236. if($follows == false && $profile->id !== $user->profile->id && $user->is_admin == false) {
  237. abort(404);
  238. }
  239. }
  240. break;
  241. case 'direct':
  242. abort(404);
  243. break;
  244. case 'draft':
  245. abort(404);
  246. break;
  247. default:
  248. abort(404);
  249. break;
  250. }
  251. }
  252. public function publicTimelineApi(Request $request)
  253. {
  254. $this->validate($request,[
  255. 'page' => 'nullable|integer|max:40',
  256. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  257. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  258. 'limit' => 'nullable|integer|max:30'
  259. ]);
  260. if(config('instance.timeline.local.is_public') == false && !Auth::check()) {
  261. abort(403, 'Authentication required.');
  262. }
  263. $page = $request->input('page');
  264. $min = $request->input('min_id');
  265. $max = $request->input('max_id');
  266. $limit = $request->input('limit') ?? 3;
  267. $user = $request->user();
  268. $filtered = UserFilter::whereUserId($user->profile_id)
  269. ->whereFilterableType('App\Profile')
  270. ->whereIn('filter_type', ['mute', 'block'])
  271. ->pluck('filterable_id')->toArray();
  272. if(PublicTimelineService::count() == 0) {
  273. PublicTimelineService::warmCache(true, 400);
  274. }
  275. if ($max) {
  276. $feed = PublicTimelineService::getRankedMaxId($max, $limit);
  277. } else if ($min) {
  278. $feed = PublicTimelineService::getRankedMinId($min, $limit);
  279. } else {
  280. $feed = PublicTimelineService::get(0, $limit);
  281. }
  282. $res = collect($feed)
  283. ->map(function($k) use($user) {
  284. $status = StatusService::get($k);
  285. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $k);
  286. return $status;
  287. })
  288. ->toArray();
  289. return response()->json($res);
  290. }
  291. public function homeTimelineApi(Request $request)
  292. {
  293. if(!Auth::check()) {
  294. return abort(403);
  295. }
  296. $this->validate($request,[
  297. 'page' => 'nullable|integer|max:40',
  298. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  299. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  300. 'limit' => 'nullable|integer|max:40',
  301. 'recent_feed' => 'nullable',
  302. 'recent_min' => 'nullable|integer'
  303. ]);
  304. $recentFeed = $request->input('recent_feed') == 'true';
  305. $recentFeedMin = $request->input('recent_min');
  306. $page = $request->input('page');
  307. $min = $request->input('min_id');
  308. $max = $request->input('max_id');
  309. $limit = $request->input('limit') ?? 3;
  310. $user = $request->user();
  311. $key = 'user:last_active_at:id:'.$user->id;
  312. $ttl = now()->addMinutes(5);
  313. Cache::remember($key, $ttl, function() use($user) {
  314. $user->last_active_at = now();
  315. $user->save();
  316. return;
  317. });
  318. $pid = Auth::user()->profile_id;
  319. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  320. $following = Follower::whereProfileId($pid)->pluck('following_id');
  321. return $following->push($pid)->toArray();
  322. });
  323. if($recentFeed == true) {
  324. $key = 'profile:home-timeline-cursor:'.$user->id;
  325. $ttl = now()->addMinutes(30);
  326. $min = Cache::remember($key, $ttl, function() use($pid) {
  327. $res = StatusView::whereProfileId($pid)->orderByDesc('status_id')->first();
  328. return $res ? $res->status_id : null;
  329. });
  330. }
  331. $filtered = Auth::check() ? UserFilterService::filters(Auth::user()->profile_id) : [];
  332. if($min || $max) {
  333. $dir = $min ? '>' : '<';
  334. $id = $min ?? $max;
  335. $timeline = Status::select(
  336. 'id',
  337. 'uri',
  338. 'caption',
  339. 'rendered',
  340. 'profile_id',
  341. 'type',
  342. 'in_reply_to_id',
  343. 'reblog_of_id',
  344. 'is_nsfw',
  345. 'scope',
  346. 'local',
  347. 'reply_count',
  348. 'comments_disabled',
  349. 'place_id',
  350. 'likes_count',
  351. 'reblogs_count',
  352. 'created_at',
  353. 'updated_at'
  354. )->whereIn('type', ['text','photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  355. ->with('profile', 'hashtags', 'mentions')
  356. ->where('id', $dir, $id)
  357. ->whereIn('profile_id', $following)
  358. ->whereNotIn('profile_id', $filtered)
  359. ->whereIn('visibility',['public', 'unlisted', 'private'])
  360. ->orderBy('created_at', 'desc')
  361. ->limit($limit)
  362. ->get();
  363. } else {
  364. $timeline = Status::select(
  365. 'id',
  366. 'uri',
  367. 'caption',
  368. 'rendered',
  369. 'profile_id',
  370. 'type',
  371. 'in_reply_to_id',
  372. 'reblog_of_id',
  373. 'is_nsfw',
  374. 'scope',
  375. 'local',
  376. 'reply_count',
  377. 'comments_disabled',
  378. 'place_id',
  379. 'likes_count',
  380. 'reblogs_count',
  381. 'created_at',
  382. 'updated_at'
  383. )->whereIn('type', ['text','photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  384. ->with('profile', 'hashtags', 'mentions')
  385. ->whereIn('profile_id', $following)
  386. ->whereNotIn('profile_id', $filtered)
  387. ->whereIn('visibility',['public', 'unlisted', 'private'])
  388. ->orderBy('created_at', 'desc')
  389. ->simplePaginate($limit);
  390. }
  391. $fractal = new Fractal\Resource\Collection($timeline, new StatusTransformer());
  392. $res = $this->fractal->createData($fractal)->toArray();
  393. return response()->json($res);
  394. }
  395. public function networkTimelineApi(Request $request)
  396. {
  397. abort_if(!Auth::check(), 403);
  398. abort_if(config('federation.network_timeline') == false, 404);
  399. $this->validate($request,[
  400. 'page' => 'nullable|integer|max:40',
  401. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  402. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  403. 'limit' => 'nullable|integer|max:30'
  404. ]);
  405. $page = $request->input('page');
  406. $min = $request->input('min_id');
  407. $max = $request->input('max_id');
  408. $limit = $request->input('limit') ?? 3;
  409. $user = $request->user();
  410. $amin = SnowflakeService::byDate(now()->subDays(90));
  411. $key = 'user:last_active_at:id:'.$user->id;
  412. $ttl = now()->addMinutes(5);
  413. Cache::remember($key, $ttl, function() use($user) {
  414. $user->last_active_at = now();
  415. $user->save();
  416. return;
  417. });
  418. if($min || $max) {
  419. $dir = $min ? '>' : '<';
  420. $id = $min ?? $max;
  421. $timeline = Status::select(
  422. 'id',
  423. 'uri',
  424. 'type',
  425. 'scope',
  426. 'created_at',
  427. )->where('id', $dir, $id)
  428. ->whereIn('type', ['photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  429. ->whereNotNull('uri')
  430. ->whereScope('public')
  431. ->where('id', '>', $amin)
  432. ->orderBy('created_at', 'desc')
  433. ->limit($limit)
  434. ->get()
  435. ->map(function($s) use ($user) {
  436. $status = StatusService::get($s->id);
  437. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  438. return $status;
  439. });
  440. $res = $timeline->toArray();
  441. } else {
  442. $timeline = Status::select(
  443. 'id',
  444. 'uri',
  445. 'type',
  446. 'scope',
  447. 'created_at',
  448. )->whereIn('type', ['photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  449. ->whereNotNull('uri')
  450. ->whereScope('public')
  451. ->where('id', '>', $amin)
  452. ->orderBy('created_at', 'desc')
  453. ->limit($limit)
  454. ->get()
  455. ->map(function($s) use ($user) {
  456. $status = StatusService::get($s->id);
  457. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  458. return $status;
  459. });
  460. $res = $timeline->toArray();
  461. }
  462. return response()->json($res);
  463. }
  464. public function relationships(Request $request)
  465. {
  466. if(!Auth::check()) {
  467. return response()->json([]);
  468. }
  469. $this->validate($request, [
  470. 'id' => 'required|array|min:1|max:20',
  471. 'id.*' => 'required|integer'
  472. ]);
  473. $ids = collect($request->input('id'));
  474. $filtered = $ids->filter(function($v) {
  475. return $v != Auth::user()->profile->id;
  476. });
  477. $relations = Profile::whereNull('status')->findOrFail($filtered->all());
  478. $fractal = new Fractal\Resource\Collection($relations, new RelationshipTransformer());
  479. $res = $this->fractal->createData($fractal)->toArray();
  480. return response()->json($res);
  481. }
  482. public function account(Request $request, $id)
  483. {
  484. $res = AccountService::get($id);
  485. return response()->json($res);
  486. }
  487. public function accountFollowers(Request $request, $id)
  488. {
  489. abort_unless(Auth::check(), 403);
  490. $profile = Profile::with('user')->whereNull('status')->whereNull('domain')->findOrFail($id);
  491. if(Auth::id() != $profile->user_id && $profile->is_private || !$profile->user->settings->show_profile_followers) {
  492. return response()->json([]);
  493. }
  494. $followers = $profile->followers()->orderByDesc('followers.created_at')->paginate(10);
  495. $resource = new Fractal\Resource\Collection($followers, new AccountTransformer());
  496. $res = $this->fractal->createData($resource)->toArray();
  497. return response()->json($res);
  498. }
  499. public function accountFollowing(Request $request, $id)
  500. {
  501. abort_unless(Auth::check(), 403);
  502. $profile = Profile::with('user')
  503. ->whereNull('status')
  504. ->whereNull('domain')
  505. ->findOrFail($id);
  506. // filter by username
  507. $search = $request->input('fbu');
  508. $owner = Auth::id() == $profile->user_id;
  509. $filter = ($owner == true) && ($search != null);
  510. abort_if($owner == false && $profile->is_private == true && !$profile->followedBy(Auth::user()->profile), 404);
  511. abort_if($profile->user->settings->show_profile_following == false && $owner == false, 404);
  512. if($search) {
  513. abort_if(!$owner, 404);
  514. $following = $profile->following()
  515. ->where('profiles.username', 'like', '%'.$search.'%')
  516. ->orderByDesc('followers.created_at')
  517. ->paginate(10);
  518. } else {
  519. $following = $profile->following()
  520. ->orderByDesc('followers.created_at')
  521. ->paginate(10);
  522. }
  523. $resource = new Fractal\Resource\Collection($following, new AccountTransformer());
  524. $res = $this->fractal->createData($resource)->toArray();
  525. return response()->json($res);
  526. }
  527. public function accountStatuses(Request $request, $id)
  528. {
  529. $this->validate($request, [
  530. 'only_media' => 'nullable',
  531. 'pinned' => 'nullable',
  532. 'exclude_replies' => 'nullable',
  533. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  534. 'since_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  535. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  536. 'limit' => 'nullable|integer|min:1|max:24'
  537. ]);
  538. $profile = Profile::whereNull('status')->findOrFail($id);
  539. $limit = $request->limit ?? 9;
  540. $max_id = $request->max_id;
  541. $min_id = $request->min_id;
  542. $scope = $request->only_media == true ?
  543. ['photo', 'photo:album', 'video', 'video:album'] :
  544. ['photo', 'photo:album', 'video', 'video:album', 'share', 'reply'];
  545. if($profile->is_private) {
  546. if(!Auth::check()) {
  547. return response()->json([]);
  548. }
  549. $pid = Auth::user()->profile->id;
  550. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  551. $following = Follower::whereProfileId($pid)->pluck('following_id');
  552. return $following->push($pid)->toArray();
  553. });
  554. $visibility = true == in_array($profile->id, $following) ? ['public', 'unlisted', 'private'] : [];
  555. } else {
  556. if(Auth::check()) {
  557. $pid = Auth::user()->profile->id;
  558. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  559. $following = Follower::whereProfileId($pid)->pluck('following_id');
  560. return $following->push($pid)->toArray();
  561. });
  562. $visibility = true == in_array($profile->id, $following) ? ['public', 'unlisted', 'private'] : ['public', 'unlisted'];
  563. } else {
  564. $visibility = ['public', 'unlisted'];
  565. }
  566. }
  567. $tag = in_array('private', $visibility) ? 'private' : 'public';
  568. if($min_id == 1 && $limit == 9 && $tag == 'public') {
  569. $limit = 9;
  570. $scope = ['photo', 'photo:album', 'video', 'video:album'];
  571. $key = '_api:statuses:recent_9:'.$profile->id;
  572. $res = Cache::remember($key, now()->addHours(24), function() use($profile, $scope, $visibility, $limit) {
  573. $dir = '>';
  574. $id = 1;
  575. $timeline = Status::select(
  576. 'id',
  577. 'uri',
  578. 'caption',
  579. 'rendered',
  580. 'profile_id',
  581. 'type',
  582. 'in_reply_to_id',
  583. 'reblog_of_id',
  584. 'is_nsfw',
  585. 'likes_count',
  586. 'reblogs_count',
  587. 'scope',
  588. 'visibility',
  589. 'local',
  590. 'place_id',
  591. 'comments_disabled',
  592. 'cw_summary',
  593. 'created_at',
  594. 'updated_at'
  595. )->whereProfileId($profile->id)
  596. ->whereIn('type', $scope)
  597. ->where('id', $dir, $id)
  598. ->whereIn('visibility', $visibility)
  599. ->limit($limit)
  600. ->orderByDesc('id')
  601. ->get();
  602. $resource = new Fractal\Resource\Collection($timeline, new StatusStatelessTransformer());
  603. $res = $this->fractal->createData($resource)->toArray();
  604. return response()->json($res, 200, [], JSON_PRETTY_PRINT|JSON_UNESCAPED_SLASHES);
  605. });
  606. return $res;
  607. }
  608. $dir = $min_id ? '>' : '<';
  609. $id = $min_id ?? $max_id;
  610. $timeline = Status::select(
  611. 'id',
  612. 'uri',
  613. 'caption',
  614. 'rendered',
  615. 'profile_id',
  616. 'type',
  617. 'in_reply_to_id',
  618. 'reblog_of_id',
  619. 'is_nsfw',
  620. 'likes_count',
  621. 'reblogs_count',
  622. 'scope',
  623. 'visibility',
  624. 'local',
  625. 'place_id',
  626. 'comments_disabled',
  627. 'cw_summary',
  628. 'created_at',
  629. 'updated_at'
  630. )->whereProfileId($profile->id)
  631. ->whereIn('type', $scope)
  632. ->where('id', $dir, $id)
  633. ->whereIn('visibility', $visibility)
  634. ->limit($limit)
  635. ->orderByDesc('id')
  636. ->get();
  637. $resource = new Fractal\Resource\Collection($timeline, new StatusStatelessTransformer());
  638. $res = $this->fractal->createData($resource)->toArray();
  639. return response()->json($res, 200, [], JSON_PRETTY_PRINT|JSON_UNESCAPED_SLASHES);
  640. }
  641. }