public function run()
{
$comment_list = ['看見麥兜總召的格局', '所以我說那個醬汁呢', '李嚴，你怎麼帥成這樣', '那些年，子洋的粉色泡泡', '刁難哥奇遇記', '轉角遇到典型的政大資管人', '喔～問題來了', '你這樣不Work', '資管迎新茶會 5/22 商院101 熱血開踢', '5/13 科技組晚上上課有演講者，歡迎到場', 'Hakuna Matata', '老王的五十個案子', '杰哥的衣服Queue', '中央資管，我愛你們全部', '阿~我們就全班宅男啊', '我都參考貝克漢穿搭耶', '這個大叔是哪來的', '現在放棄的話，就可以放暑假了', '潮水退了就知道誰沒穿褲子', '聽完周老師這番話，全資管系都驚呆了', '左手寫詩，右手寫程式', '啊不就好棒棒', '吃吃看，你吃一口就知道了', '德國拳王倒下去，莎拉布萊曼照唱 Time to say goodbye', '面對現實，不然現實就面對你', '棉被再怎麼抖都會有灰塵', '務必冷靜理性透徹，暫時把好惡丟到河流另一邊去', '怕熱就不要進廚房', '拿破崙說 由馴鹿所領導的獅子軍團 就在也不是獅子軍團', '甜甜圈～', '在非洲，每六十秒，就有一分鐘過去', '當你的左臉被人打，那你的左臉就會痛', '英國研究 生日過越多的人就越老', '當蝴蝶在南半球拍了兩下翅膀，牠就會稍微飛高一點點', '我買了130元的高級鵝肉飯'];
//echo count($comment_list);
$user_list = User::select('id')->lists('id');
//echo var_dump($user_list);
foreach ($user_list as $user_key => $user_value) {
$app_ran_list = App::orderByRaw("RAND()")->take(35)->lists('id');
foreach ($app_ran_list as $app_key => $app_value) {
User_App_Comment::create(['u_id' => $user_value, 'a_id' => $app_value, 'comment' => $comment_list[$app_key]]);
}
}
}
/**
* 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;
}
