/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$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', 'apps.name as app_name', 'apps.id as app_id', 'apps.img_url as app_img', 'comment', 'user__app__comments.created_at')->orderBy('user__app__comments.created_at', 'desc')->take(5)->get();
return $comment_new;
}
//multisearch
$app_list = App::leftjoin('user__app__favorite', 'user__app__favorite.a_id', '=', 'apps.id')->select('apps.id', 'apps.name', 'apps.img_url', 'apps.rating_users', 'apps.genre', 'apps.rating', \DB::raw('count(user__app__favorite.id) as favorite_count'))->groupBy('apps.id')->orderBy('apps.rating_users', 'desc')->orderBy('id', 'asc');
if (Input::has('name')) {
$name = Input::get('name');
$app_list->where('apps.name', 'LIKE', '%' . $name . '%');
}
if (Input::has('genre')) {
$genre = Input::get('genre');
$app_list->where('apps.genre', '=', $genre);
}
if (Input::has('skip')) {
$skip = Input::get('skip');
$app_list->skip($skip);
}
$apps = $app_list->take(10)->get();
if (empty($apps->first())) {
return Response::json(array('message' => 'Empty Query Man~', 'status' => 'error'));
} else {
foreach ($apps as $key => $value) {
$app_comment_counts = App::join('user__app__comments', 'user__app__comments.a_id', '=', 'apps.id')->where('apps.id', '=', $value['id'])->count();
//$value->suck_count = $app_suck_counts;
$value->app_comment = $app_comment_counts;
}
return $apps;
}
}
