public function index() { //总访问量 $visits = \Cache::get('visits', 0); //今日注册用户 $todayUsers = User::today()->count('user_id'); //总用户数 $totalUsers = User::count('user_id'); //管理员聊天记录 $chatMessages = AdminMessage::with('admin')->limit(10)->oldest()->get(); //最新留言 $guestBook = GuestBook::with('user')->limit(10)->oldest()->get(); //最新注册用户 $users = User::limit(24)->oldest()->get(); //最新评论 $comments = Comment::limit(10)->oldest()->get(); // 总会员数量/待审核会员/普通会员/高端会员 $user_all_num = User::count('user_id'); $user_shenhe_num = User::status(\App\Enum\User::STATUS_CHECK)->count('user_id'); $user_level1_num = User::level(\App\Enum\User::LEVEL_1)->count('user_id'); $user_level3_num = User::level(\App\Enum\User::LEVEL_3)->count('user_id'); // 自我介绍待审核数量 $user_info_num = UserInfo::where('introduce_status', \App\Enum\User::INTRODUCE_CHECK)->count('user_id'); // 会员相片审核数量 $user_gallery_num = DB::table('user_gallery')->where('status', '待审核')->where('image_url', '!=', '')->count('photo_id'); // 文章数量 $article_num = DB::table('articles')->count('article_id'); $res = array('user_all_num' => $user_all_num, 'user_shenhe_num' => $user_shenhe_num, 'user_level1_num' => $user_level1_num, 'user_level3_num' => $user_level3_num, 'user_info_num' => $user_info_num, 'user_gallery_num' => $user_gallery_num, 'article_num' => $article_num); return $this->view('index', $res); // return $this->view('index')->with('visits', $visits)->with('todayUsers', $todayUsers)->with('totalUsers', // $totalUsers)->with('chatMessages', $chatMessages)->with('guestBook', $guestBook)->with('users', // $users)->with('comments', $comments); }
public function testLimit() { /* $conn->query("DELETE FROM users"); $conn->query("INSERT INTO users(id,name) VALUES(1,'bar'), (2, 'foo'), (3, 'hoge'), (4, 'fuga')"); $conn->query("DELETE FROM comments"); $conn->query("INSERT INTO comments(id, text, user_id) VALUES(1, 'bar comment first', 1), (2, 'bar comment second', 1), (3, 'foo comment first', 2)"); $conn->query("DELETE FROM users_skills"); $conn->query("INSERT INTO users_skills(id, users_id, skills_id) VALUES(1, 1, 1), (2, 1, 2), (3, 2, 1)"); $conn->query("DELETE FROM skills"); $conn->query("INSERT INTO skills(id, name) VALUES(1,'skill1'), (2, 'skill2'), (3, 'skill3')"); $conn->query("DELETE FROM profiles"); $conn->query("INSERT INTO profiles(id, text, user_id) VALUES(1, 'bar profile', 1), (2, 'foo frofile', 2), (3, 'hoge frofile', 3)"); */ $users = User::limit(4); $this->assertEquals('bar profile', $users[0]->Profile->text); $this->assertEquals('foo frofile', $users[1]->Profile->text); $this->assertEquals('hoge frofile', $users[2]->Profile->text); $this->assertEquals(null, $users[3]->Profile); $this->assertEquals('bar comment first', $users[0]->Comment[0]->text); $this->assertEquals('bar comment second', $users[0]->Comment[1]->text); $this->assertEquals('foo comment first', $users[1]->Comment[0]->text); $this->assertEquals([], $users[2]->Comment); $this->assertEquals([], $users[3]->Comment); $this->assertEquals('skill1', $users[0]->Skill[0]->name); $this->assertEquals('skill1', $users[1]->Skill[0]->name); $this->assertEquals([], $users[2]->Skill); $this->assertEquals([], $users[3]->Skill); }