From 167751ed6648f027e5d8d870c128228bd311db93 Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Sun, 13 May 2018 15:17:59 +0200 Subject: Added follower/follow list in wormhole api --- .../admin/src/Controller/WormholeController.php | 29 +++++++++++++++------- 1 file changed, 20 insertions(+), 9 deletions(-) (limited to 'main/app/sprinkles/admin/src/Controller/WormholeController.php') diff --git a/main/app/sprinkles/admin/src/Controller/WormholeController.php b/main/app/sprinkles/admin/src/Controller/WormholeController.php index ecefe33..0040062 100644 --- a/main/app/sprinkles/admin/src/Controller/WormholeController.php +++ b/main/app/sprinkles/admin/src/Controller/WormholeController.php @@ -60,22 +60,33 @@ class WormholeController extends SimpleController } public function getInfo(Request $request, Response $response, $args) { + /** @var UserFrosting\Sprinkle\Core\Util\ClassMapper $classMapper */ + $classMapper = $this->ci->classMapper; + if ($this->verifyAccessToken($args)) { - $user = DB::table('users') - ->where('id', $args["user_id"]) + $user = $classMapper->staticMethod('user', 'where', 'id', $args['user_id']) ->first(); if (!$user) { throw new NotFoundException($request, $response); } - $classMapper = $this->ci->classMapper; - $user = $classMapper->createInstance('user') - ->where('user_name', $user->user_name) - ->join("user_follow", "users.id", "=", "user_follow.user_id") - ->select("*") - ->first(); + + $UsersFollower = DB::table('user_follow') + ->where('user_id', $user->id) + ->join("users", "users.id", "=", "user_follow.followed_by_id") + ->select("user_follow.followed_by_id as id", "users.user_name as username") + ->get(); // TODO: MULTI FOLLOWER ARRAY! + + $UsersFollows = DB::table('user_follow') + ->where('followed_by_id', $user->id) + ->join("users", "users.id", "=", "user_follow.user_id") + ->select("user_follow.user_id as id", "users.user_name as username") + ->get(); // TODO: MULTI FOLLOWER ARRAY! $result = $user->toArray(); - //$result["avatar"] = $user->avatar; + //print_r($user); + $result["avatar"] = $user->avatar; + $result["followers"] = $UsersFollower; + $result["follows"] = $UsersFollows; return $response->withJson($result, 200, JSON_PRETTY_PRINT); } } -- cgit v1.2.3