/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
//
$status = Input::get('status');
if ($status == 'comment') {
$comment_new = User_App_Comment::join('apps', 'apps.id', '=', 'user__app__comments.a_id')->join('users', 'users.id', '=', 'user__app__comments.u_id')->select('user__app__comments.id', 'users.name as user_name', 'users.id as user_id', 'users.img as user_img', 'apps.id as app_id', 'apps.name as app_name', 'apps.img_url as app_img', 'comment', 'user__app__comments.created_at')->orderBy('user__app__comments.created_at', 'desc')->where('user__app__comments.a_id', '=', $id);
$return_all = $comment_new->get();
$empty_test = $comment_new->first();
if (empty($empty_test)) {
return Response::json(array('message' => 'No comments', 'status' => 'error'));
}
return $return_all;
}
$app_detail = App::where('id', '=', $id)->first();
$app_behaviors = App::join('app__behaviors', 'app__behaviors.a_id', '=', 'apps.id')->join('behaviors', 'behaviors.id', '=', 'app__behaviors.b_id')->where('apps.id', '=', $id)->select('behaviors.id', 'behaviors.name', 'behaviors.genre', 'app__behaviors.score')->orderBy('behaviors.genre', 'asc')->orderBy('behaviors.id', 'asc')->get();
$app_comments = User_App_Comment::join('apps', 'apps.id', '=', 'user__app__comments.a_id')->join('users', 'users.id', '=', 'user__app__comments.u_id')->where('user__app__comments.a_id', '=', $id)->select('user__app__comments.id', 'users.id as user_id', 'users.name as user_name', 'apps.id as app_id', 'apps.name as app_name', 'apps.img_url as app_img', 'comment', 'user__app__comments.created_at as comment_time')->orderBy('user__app__comments.created_at', 'desc')->get();
$app_favorite_counts = App::join('user__app__favorite', 'user__app__favorite.a_id', '=', 'apps.id')->where('apps.id', '=', $id)->count();
$app_comment_counts = App::join('user__app__comments', 'user__app__comments.a_id', '=', 'apps.id')->where('apps.id', '=', $id)->count();
$app_clusters = Cluster::join('apps', 'apps.cl_id', '=', 'clusters.id')->where('apps.id', '!=', $id)->where('clusters.id', '=', $app_detail['cl_id'])->get();
$app_detail->behaviors = $app_behaviors;
$app_detail->comments = $app_comments;
$app_detail->favorite_count = $app_favorite_counts;
$app_detail->comment_count = $app_comment_counts;
$app_detail->group_app = $app_clusters;
if (Auth::check()) {
$user_id = Auth::user()->id;
$check_suck = User::join('user__app__favorite', 'user__app__favorite.u_id', '=', 'users.id')->where('user__app__favorite.a_id', '=', $id)->where('user__app__favorite.u_id', '=', $user_id)->first();
if (empty($check_suck)) {
$user_favorite = "Not yet";
} else {
$user_favorite = "Already";
}
} else {
$user_favorite = "Not login";
}
$app_detail->user_favorite = $user_favorite;
$app_detail->success = 'success';
return $app_detail;
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$user = User::where('id', '=', $id)->first();
$user_favorite_counts = User::where('users.id', '=', $id)->join('user__app__favorite', 'user__app__favorite.u_id', '=', 'users.id')->count();
$user_coment_counts = User::where('users.id', '=', $id)->join('user__app__comments', 'user__app__comments.u_id', '=', 'users.id')->count();
$user_comment_list = User_App_Comment::join('apps', 'apps.id', '=', 'user__app__comments.a_id')->join('users', 'users.id', '=', 'user__app__comments.u_id')->select('user__app__comments.id', 'apps.id as app_id', 'apps.name as app_name', 'apps.img_url as app_img', 'comment', 'user__app__comments.created_at')->where('users.id', '=', $id)->orderBy('user__app__comments.created_at', 'desc')->get();
$user_favorite_list = User_App_Favorite::join('apps', 'apps.id', '=', 'user__app__favorite.a_id')->join('users', 'users.id', '=', 'user__app__favorite.u_id')->select('user__app__favorite.id', 'apps.id as app_id', 'apps.name as app_name', 'apps.img_url as app_img', 'user__app__favorite.created_at')->where('users.id', '=', $id)->orderBy('user__app__favorite.created_at', 'desc')->get();
$user->favorite_counts = $user_favorite_counts;
$user->comments_counts = $user_coment_counts;
$user->comment_list = $user_comment_list;
$user->favorite_list = $user_favorite_list;
$user->status = 'success';
return $user;
}
