public function user($username)
{
$uname = strip_tags(trim($username));
//get每次取多条数据,想取多条用take(n)->get();
$user = User::whereRaw('username =?', array($uname))->take(0)->get();
// $user=User::where('username',$uname)->take(0)->get();这种写法也可以
//检查用户是否存在
if (count($user) == 0) {
return Response::make('user not exist', 404);
}
$uid = $user[0]->id;
//获取当前用户的全部文章列表，分页显示
$articles = Article::where('uid', $uid)->where('status', 1)->paginate(5);
//获取文章标签列表[通过uid查找]
//$tags=Tag::where('uid',$uid)->groupBy('tag')->get();
$tags = $user[0]->getTags;
//获取当前用户文章的总数
$total = Article::where('uid', $uid)->where('status', 1)->count();
//获取当前用户分类总数
$cates = User::find($uid)->getCate;
//关联模型获取cate
//获取博客创建时间
$age = $user[0]->created_at;
$age = $this->formatTime($age);
//按日期归档
$date = Article::select(DB::raw("DATE_FORMAT(created_at,'%Y%m') as time,count( DATE_FORMAT(created_at,'%Y%m')) as num"))->where('uid', $uid)->where('status', 1)->groupBy('time')->orderBy('created_at', 'desc')->get();
return View::make('blog.user', compact('articles'))->with('tags', $tags)->with('user', $user[0])->with('count', count($articles))->with('total', $total)->with('cates', $cates)->with('age', $age)->with('date', $date);
}
