PublicApiController.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746
  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. $amin = SnowflakeService::byDate(now()->subDays(90));
  269. $key = 'user:last_active_at:id:'.$user->id;
  270. $ttl = now()->addMinutes(5);
  271. Cache::remember($key, $ttl, function() use($user) {
  272. $user->last_active_at = now();
  273. $user->save();
  274. return;
  275. });
  276. $filtered = UserFilter::whereUserId($user->profile_id)
  277. ->whereFilterableType('App\Profile')
  278. ->whereIn('filter_type', ['mute', 'block'])
  279. ->pluck('filterable_id')->toArray();
  280. if($min || $max) {
  281. $dir = $min ? '>' : '<';
  282. $id = $min ?? $max;
  283. $timeline = Status::select(
  284. 'id',
  285. 'profile_id',
  286. 'type',
  287. 'scope',
  288. 'local'
  289. )->where('id', $dir, $id)
  290. ->where('id', '>', $amin)
  291. ->whereIn('type', ['text', 'photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  292. ->whereNotIn('profile_id', $filtered)
  293. ->whereLocal(true)
  294. ->whereScope('public')
  295. ->orderBy('id', 'desc')
  296. ->limit($limit)
  297. ->get()
  298. ->map(function($s) use ($user) {
  299. $status = StatusService::get($s->id);
  300. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  301. return $status;
  302. });
  303. $res = $timeline->toArray();
  304. } else {
  305. $timeline = Status::select(
  306. 'id',
  307. 'profile_id',
  308. 'type',
  309. 'scope',
  310. 'local'
  311. )->whereIn('type', ['text', 'photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  312. ->where('id', '>', $amin)
  313. ->whereNotIn('profile_id', $filtered)
  314. ->with('profile', 'hashtags', 'mentions')
  315. ->whereLocal(true)
  316. ->whereScope('public')
  317. ->orderBy('id', 'desc')
  318. ->limit($limit)
  319. ->get()
  320. ->map(function($s) use ($user) {
  321. $status = StatusService::get($s->id);
  322. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  323. return $status;
  324. });
  325. $res = $timeline->toArray();
  326. }
  327. return response()->json($res);
  328. }
  329. public function homeTimelineApi(Request $request)
  330. {
  331. if(!Auth::check()) {
  332. return abort(403);
  333. }
  334. $this->validate($request,[
  335. 'page' => 'nullable|integer|max:40',
  336. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  337. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  338. 'limit' => 'nullable|integer|max:40',
  339. 'recent_feed' => 'nullable',
  340. 'recent_min' => 'nullable|integer'
  341. ]);
  342. $recentFeed = $request->input('recent_feed') == 'true';
  343. $recentFeedMin = $request->input('recent_min');
  344. $page = $request->input('page');
  345. $min = $request->input('min_id');
  346. $max = $request->input('max_id');
  347. $limit = $request->input('limit') ?? 3;
  348. $user = $request->user();
  349. $key = 'user:last_active_at:id:'.$user->id;
  350. $ttl = now()->addMinutes(5);
  351. Cache::remember($key, $ttl, function() use($user) {
  352. $user->last_active_at = now();
  353. $user->save();
  354. return;
  355. });
  356. $pid = Auth::user()->profile_id;
  357. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  358. $following = Follower::whereProfileId($pid)->pluck('following_id');
  359. return $following->push($pid)->toArray();
  360. });
  361. if($recentFeed == true) {
  362. $key = 'profile:home-timeline-cursor:'.$user->id;
  363. $ttl = now()->addMinutes(30);
  364. $min = Cache::remember($key, $ttl, function() use($pid) {
  365. $res = StatusView::whereProfileId($pid)->orderByDesc('status_id')->first();
  366. return $res ? $res->status_id : null;
  367. });
  368. }
  369. $filtered = Auth::check() ? UserFilterService::filters(Auth::user()->profile_id) : [];
  370. if($min || $max) {
  371. $dir = $min ? '>' : '<';
  372. $id = $min ?? $max;
  373. $timeline = Status::select(
  374. 'id',
  375. 'uri',
  376. 'caption',
  377. 'rendered',
  378. 'profile_id',
  379. 'type',
  380. 'in_reply_to_id',
  381. 'reblog_of_id',
  382. 'is_nsfw',
  383. 'scope',
  384. 'local',
  385. 'reply_count',
  386. 'comments_disabled',
  387. 'place_id',
  388. 'likes_count',
  389. 'reblogs_count',
  390. 'created_at',
  391. 'updated_at'
  392. )->whereIn('type', ['text','photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  393. ->with('profile', 'hashtags', 'mentions')
  394. ->where('id', $dir, $id)
  395. ->whereIn('profile_id', $following)
  396. ->whereNotIn('profile_id', $filtered)
  397. ->whereIn('visibility',['public', 'unlisted', 'private'])
  398. ->orderBy('created_at', 'desc')
  399. ->limit($limit)
  400. ->get();
  401. } else {
  402. $timeline = Status::select(
  403. 'id',
  404. 'uri',
  405. 'caption',
  406. 'rendered',
  407. 'profile_id',
  408. 'type',
  409. 'in_reply_to_id',
  410. 'reblog_of_id',
  411. 'is_nsfw',
  412. 'scope',
  413. 'local',
  414. 'reply_count',
  415. 'comments_disabled',
  416. 'place_id',
  417. 'likes_count',
  418. 'reblogs_count',
  419. 'created_at',
  420. 'updated_at'
  421. )->whereIn('type', ['text','photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  422. ->with('profile', 'hashtags', 'mentions')
  423. ->whereIn('profile_id', $following)
  424. ->whereNotIn('profile_id', $filtered)
  425. ->whereIn('visibility',['public', 'unlisted', 'private'])
  426. ->orderBy('created_at', 'desc')
  427. ->simplePaginate($limit);
  428. }
  429. $fractal = new Fractal\Resource\Collection($timeline, new StatusTransformer());
  430. $res = $this->fractal->createData($fractal)->toArray();
  431. return response()->json($res);
  432. }
  433. public function networkTimelineApi(Request $request)
  434. {
  435. abort_if(!Auth::check(), 403);
  436. abort_if(config('federation.network_timeline') == false, 404);
  437. $this->validate($request,[
  438. 'page' => 'nullable|integer|max:40',
  439. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  440. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  441. 'limit' => 'nullable|integer|max:30'
  442. ]);
  443. $page = $request->input('page');
  444. $min = $request->input('min_id');
  445. $max = $request->input('max_id');
  446. $limit = $request->input('limit') ?? 3;
  447. $user = $request->user();
  448. $amin = SnowflakeService::byDate(now()->subDays(90));
  449. $key = 'user:last_active_at:id:'.$user->id;
  450. $ttl = now()->addMinutes(5);
  451. Cache::remember($key, $ttl, function() use($user) {
  452. $user->last_active_at = now();
  453. $user->save();
  454. return;
  455. });
  456. if($min || $max) {
  457. $dir = $min ? '>' : '<';
  458. $id = $min ?? $max;
  459. $timeline = Status::select(
  460. 'id',
  461. 'uri',
  462. 'type',
  463. 'scope',
  464. 'created_at',
  465. )->where('id', $dir, $id)
  466. ->whereIn('type', ['photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  467. ->whereNotNull('uri')
  468. ->whereScope('public')
  469. ->where('id', '>', $amin)
  470. ->orderBy('created_at', 'desc')
  471. ->limit($limit)
  472. ->get()
  473. ->map(function($s) use ($user) {
  474. $status = StatusService::get($s->id);
  475. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  476. return $status;
  477. });
  478. $res = $timeline->toArray();
  479. } else {
  480. $timeline = Status::select(
  481. 'id',
  482. 'uri',
  483. 'type',
  484. 'scope',
  485. 'created_at',
  486. )->whereIn('type', ['photo', 'photo:album', 'video', 'video:album', 'photo:video:album'])
  487. ->whereNotNull('uri')
  488. ->whereScope('public')
  489. ->where('id', '>', $amin)
  490. ->orderBy('created_at', 'desc')
  491. ->limit($limit)
  492. ->get()
  493. ->map(function($s) use ($user) {
  494. $status = StatusService::get($s->id);
  495. $status['favourited'] = (bool) LikeService::liked($user->profile_id, $s->id);
  496. return $status;
  497. });
  498. $res = $timeline->toArray();
  499. }
  500. return response()->json($res);
  501. }
  502. public function relationships(Request $request)
  503. {
  504. if(!Auth::check()) {
  505. return response()->json([]);
  506. }
  507. $this->validate($request, [
  508. 'id' => 'required|array|min:1|max:20',
  509. 'id.*' => 'required|integer'
  510. ]);
  511. $ids = collect($request->input('id'));
  512. $filtered = $ids->filter(function($v) {
  513. return $v != Auth::user()->profile->id;
  514. });
  515. $relations = Profile::whereNull('status')->findOrFail($filtered->all());
  516. $fractal = new Fractal\Resource\Collection($relations, new RelationshipTransformer());
  517. $res = $this->fractal->createData($fractal)->toArray();
  518. return response()->json($res);
  519. }
  520. public function account(Request $request, $id)
  521. {
  522. $res = AccountService::get($id);
  523. return response()->json($res);
  524. }
  525. public function accountFollowers(Request $request, $id)
  526. {
  527. abort_unless(Auth::check(), 403);
  528. $profile = Profile::with('user')->whereNull('status')->whereNull('domain')->findOrFail($id);
  529. if(Auth::id() != $profile->user_id && $profile->is_private || !$profile->user->settings->show_profile_followers) {
  530. return response()->json([]);
  531. }
  532. $followers = $profile->followers()->orderByDesc('followers.created_at')->paginate(10);
  533. $resource = new Fractal\Resource\Collection($followers, new AccountTransformer());
  534. $res = $this->fractal->createData($resource)->toArray();
  535. return response()->json($res);
  536. }
  537. public function accountFollowing(Request $request, $id)
  538. {
  539. abort_unless(Auth::check(), 403);
  540. $profile = Profile::with('user')
  541. ->whereNull('status')
  542. ->whereNull('domain')
  543. ->findOrFail($id);
  544. // filter by username
  545. $search = $request->input('fbu');
  546. $owner = Auth::id() == $profile->user_id;
  547. $filter = ($owner == true) && ($search != null);
  548. abort_if($owner == false && $profile->is_private == true && !$profile->followedBy(Auth::user()->profile), 404);
  549. abort_if($profile->user->settings->show_profile_following == false && $owner == false, 404);
  550. if($search) {
  551. abort_if(!$owner, 404);
  552. $following = $profile->following()
  553. ->where('profiles.username', 'like', '%'.$search.'%')
  554. ->orderByDesc('followers.created_at')
  555. ->paginate(10);
  556. } else {
  557. $following = $profile->following()
  558. ->orderByDesc('followers.created_at')
  559. ->paginate(10);
  560. }
  561. $resource = new Fractal\Resource\Collection($following, new AccountTransformer());
  562. $res = $this->fractal->createData($resource)->toArray();
  563. return response()->json($res);
  564. }
  565. public function accountStatuses(Request $request, $id)
  566. {
  567. $this->validate($request, [
  568. 'only_media' => 'nullable',
  569. 'pinned' => 'nullable',
  570. 'exclude_replies' => 'nullable',
  571. 'max_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  572. 'since_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  573. 'min_id' => 'nullable|integer|min:0|max:' . PHP_INT_MAX,
  574. 'limit' => 'nullable|integer|min:1|max:24'
  575. ]);
  576. $profile = Profile::whereNull('status')->findOrFail($id);
  577. $limit = $request->limit ?? 9;
  578. $max_id = $request->max_id;
  579. $min_id = $request->min_id;
  580. $scope = $request->only_media == true ?
  581. ['photo', 'photo:album', 'video', 'video:album'] :
  582. ['photo', 'photo:album', 'video', 'video:album', 'share', 'reply'];
  583. if($profile->is_private) {
  584. if(!Auth::check()) {
  585. return response()->json([]);
  586. }
  587. $pid = Auth::user()->profile->id;
  588. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  589. $following = Follower::whereProfileId($pid)->pluck('following_id');
  590. return $following->push($pid)->toArray();
  591. });
  592. $visibility = true == in_array($profile->id, $following) ? ['public', 'unlisted', 'private'] : [];
  593. } else {
  594. if(Auth::check()) {
  595. $pid = Auth::user()->profile->id;
  596. $following = Cache::remember('profile:following:'.$pid, now()->addMinutes(1440), function() use($pid) {
  597. $following = Follower::whereProfileId($pid)->pluck('following_id');
  598. return $following->push($pid)->toArray();
  599. });
  600. $visibility = true == in_array($profile->id, $following) ? ['public', 'unlisted', 'private'] : ['public', 'unlisted'];
  601. } else {
  602. $visibility = ['public', 'unlisted'];
  603. }
  604. }
  605. $tag = in_array('private', $visibility) ? 'private' : 'public';
  606. if($min_id == 1 && $limit == 9 && $tag == 'public') {
  607. $limit = 9;
  608. $scope = ['photo', 'photo:album', 'video', 'video:album'];
  609. $key = '_api:statuses:recent_9:'.$profile->id;
  610. $res = Cache::remember($key, now()->addHours(24), function() use($profile, $scope, $visibility, $limit) {
  611. $dir = '>';
  612. $id = 1;
  613. $timeline = Status::select(
  614. 'id',
  615. 'uri',
  616. 'caption',
  617. 'rendered',
  618. 'profile_id',
  619. 'type',
  620. 'in_reply_to_id',
  621. 'reblog_of_id',
  622. 'is_nsfw',
  623. 'likes_count',
  624. 'reblogs_count',
  625. 'scope',
  626. 'visibility',
  627. 'local',
  628. 'place_id',
  629. 'comments_disabled',
  630. 'cw_summary',
  631. 'created_at',
  632. 'updated_at'
  633. )->whereProfileId($profile->id)
  634. ->whereIn('type', $scope)
  635. ->where('id', $dir, $id)
  636. ->whereIn('visibility', $visibility)
  637. ->limit($limit)
  638. ->orderByDesc('id')
  639. ->get();
  640. $resource = new Fractal\Resource\Collection($timeline, new StatusStatelessTransformer());
  641. $res = $this->fractal->createData($resource)->toArray();
  642. return response()->json($res, 200, [], JSON_PRETTY_PRINT|JSON_UNESCAPED_SLASHES);
  643. });
  644. return $res;
  645. }
  646. $dir = $min_id ? '>' : '<';
  647. $id = $min_id ?? $max_id;
  648. $timeline = Status::select(
  649. 'id',
  650. 'uri',
  651. 'caption',
  652. 'rendered',
  653. 'profile_id',
  654. 'type',
  655. 'in_reply_to_id',
  656. 'reblog_of_id',
  657. 'is_nsfw',
  658. 'likes_count',
  659. 'reblogs_count',
  660. 'scope',
  661. 'visibility',
  662. 'local',
  663. 'place_id',
  664. 'comments_disabled',
  665. 'cw_summary',
  666. 'created_at',
  667. 'updated_at'
  668. )->whereProfileId($profile->id)
  669. ->whereIn('type', $scope)
  670. ->where('id', $dir, $id)
  671. ->whereIn('visibility', $visibility)
  672. ->limit($limit)
  673. ->orderByDesc('id')
  674. ->get();
  675. $resource = new Fractal\Resource\Collection($timeline, new StatusStatelessTransformer());
  676. $res = $this->fractal->createData($resource)->toArray();
  677. return response()->json($res, 200, [], JSON_PRETTY_PRINT|JSON_UNESCAPED_SLASHES);
  678. }
  679. }