public function status($statusType) { if (1 == $statusType) { $buildingNumber = Building::count(); $roomNumber = Room::count(); $buildingRet = ['buildingNumber' => $buildingNumber, 'roomNumber' => $roomNumber]; return $buildingRet; } else { if (2 == $statusType) { $roomNumber = Room::count(); $rentedRoomNumber = Contract::count(); $emptyRoomNumber = $roomNumber - $rentedRoomNumber; $rentRet = ['roomNumber' => $roomNumber, 'rentedNumber' => $rentedRoomNumber, 'emptyNumber' => $emptyRoomNumber]; return $rentRet; } else { if (3 == $statusType) { $feePlanItem = DB::select('SELECT COUNT(DISTINCT feemeta_id) as counts FROM fee_plans WHERE status=0 AND deleted_at IS NULL'); $feePlanRentNumber = DB::select('SELECT COUNT(DISTINCT rent_id) as counts FROM fee_plans WHERE status=0 AND deleted_at IS NULL'); $feeRet = ['feePlanNumber' => $feePlanItem[0]->counts, 'feePlanRentNumber' => $feePlanRentNumber[0]->counts]; return $feeRet; } else { if (4 == $statusType) { $userNumber = User::count(); $userRet = ['userCount' => $userNumber]; return $userRet; } } } } }
/** * Get homepage * * @param Request $request * @return View|void */ public function getHomepage(Request $request) { /** * Load data */ $this->_arViewData = $this->_loadPageByUrl('/'); /** * Number of users */ $this->_arViewData['users_no'] = User::count() + 135000; /** * Number of campaigns */ $this->_arViewData['campaigns_no'] = Campaign::count(); /** * Number of payments total */ $this->_arViewData['payments_no_total'] = Payment::sum('amount'); /** * Number of payments last month */ $this->_arViewData['payments_no_last_month'] = Payment::where('created_at', '>=', Carbon::now()->subMonth())->count(); /** * Return view */ return $this->_showViewOr404('frontend.homepage'); }
public function index(ArticleRepository $article, MarketRepository $market) { $article_counts = $article->publishedCountWithCommentCount(); $user_count = \App\User::count(); $event_count = $market->currentAndFutureCount(); return view('backend.page.index', compact('article_counts', 'user_count', 'event_count')); }
public function challenges() { /*$game = Game::first(); $categories = Category::get(); $categories = $categories->toArray(); foreach($categories as $category) { $challenges = Challenge::where('category_id', $category['id'])->get()->toArray(); $categories[(int)$category['id'] - 1]['challenges'] = $challenges; } $data = array('game' => $game, 'categories' => $categories);*/ $num_users = User::count(); $completed = Submitted_flag::count(); $num_challenges = Challenge::count(); $average_c = $completed / $num_users / $num_challenges * 100; $stats = array('num_users' => $num_users, 'completed' => $completed, 'average' => $average_c); $game = Game::first(); $categories = Category::get(); $categories = $categories->toArray(); foreach ($categories as $category) { $challenges = Challenge::where('category_id', $category['id'])->get()->toArray(); $categories[(int) $category['id'] - 1]['challenges'] = $challenges; } $directory = base_path() . '/public/Challenges_Repo/'; $files = scandir($directory); $data = array('user' => Auth::user(), 'game' => $game, 'categories' => $categories, 'stats' => $stats, 'files' => $files); return view("pages.challenges")->with('data', $data); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $users_count = User::count(); $posts_count = Post::count(); $galleries_count = Gallery::count(); return response()->json(['users_count' => $users_count, 'posts_count' => $posts_count, 'galleries_count' => $galleries_count]); }
/** * Display a dashboard. * * @return Response */ public function index() { $userCount = User::count(); $pagesCount = Page::count(); $newsCount = News::count(); return view('util.index', compact('userCount', 'pagesCount', 'newsCount')); }
public function index() { $title = "Dashboard"; $users = User::count(); $operation_areas = Operation_area::select()->get(); return view('admin.dashboard.index', compact('title', 'users', 'operation_areas')); }
/** * Display the dashboard once the user is logged * * @return \Illuminate\Http\Response */ public function index() { $nb_users = User::count(); $nb_posts = Post::count(); $nb_pages = Page::count(); return view('admin.admin', compact('nb_users', 'nb_posts', 'nb_pages')); }
public function dashboard(Request $request) { $stat = new \Stdclass(); $stat->num_ads = Ad::count(); $stat->num_promo_ads = Ad::where('ad_promo', 1)->count(); $stat->users = User::count(); $stat->reports = AdReport::count(); //get last 10 days ads $ads_by_date = Ad::select(DB::raw("count(ad_id) AS ad_count, DATE_FORMAT(ad_publish_date, '%Y-%m-%d') AS date_formated"))->groupBy('date_formated')->orderBy('date_formated', 'desc')->take(10)->get()->toArray(); $stat->ads_by_date = []; if (!empty($ads_by_date)) { $stat->ads_by_date = array_reverse($ads_by_date); } //get last 10 promo days ads $promo_ads_by_date = Ad::select(DB::raw("count(ad_id) AS ad_count, DATE_FORMAT(ad_publish_date, '%Y-%m-%d') AS date_formated"))->where('ad_promo', 1)->groupBy('date_formated')->orderBy('date_formated', 'desc')->take(10)->get()->toArray(); $stat->promo_ads_by_date = []; if (!empty($promo_ads_by_date)) { $stat->promo_ads_by_date = array_reverse($promo_ads_by_date); } //get last 10 months ads $ads_by_month = Ad::select(DB::raw("count(ad_id) AS ad_count, DATE_FORMAT(ad_publish_date, '%Y-%m') AS date_formated"))->groupBy('date_formated')->orderBy('date_formated', 'desc')->take(10)->get()->toArray(); $stat->ads_by_month = []; if (!empty($ads_by_month)) { $stat->ads_by_month = array_reverse($ads_by_month); } //get last 10 years ads $ads_by_year = Ad::select(DB::raw("count(ad_id) AS ad_count, DATE_FORMAT(ad_publish_date, '%Y') AS date_formated"))->groupBy('date_formated')->orderBy('date_formated', 'desc')->take(10)->get()->toArray(); $stat->ads_by_year = []; if (!empty($ads_by_year)) { $stat->ads_by_year = array_reverse($ads_by_year); } return view('admin.dashboard.dashboard', ['stat' => $stat]); }
public function challenges() { $startd = DB::table('Games')->select('start')->first(); $endd = DB::table('Games')->select('stop')->first(); if ($startd->start > Carbon::now()) { return view("pages.countdown"); } elseif ($endd->stop < Carbon::now()) { return view('pages.closed'); } $num_users = User::count(); $completed = Submitted_flag::count(); $num_challenges = Challenge::count(); $average_c = $completed / $num_users / $num_challenges * 100; $stats = array('num_users' => $num_users, 'completed' => $completed, 'average' => $average_c); $mycompleted = Submitted_flag::where('user_id', Auth::user()->id)->get()->toArray(); $game = Game::first(); $categories = Category::get(); $categories = $categories->toArray(); foreach ($categories as $category) { $challenges = Challenge::where('category_id', $category['id'])->orderby('point_value', 'ASC')->get()->toArray(); $categories[(int) $category['id'] - 1]['challenges'] = $challenges; } $directory = base_path() . '/public/Challenges_Repo/'; $files = scandir($directory); $startd = DB::table('Games')->select('start')->first(); if ($startd->start > Carbon::now()) { $start = true; } else { $start = false; } $data = array('user' => Auth::user(), 'game' => $game, 'categories' => $categories, 'stats' => $stats, 'files' => $files, 'completed' => $mycompleted, 'start' => $start); return view("pages.challenges")->with('data', $data); }
public function testGet() { $users = User::get(); $this->assertEquals(3, $users->count()); $users = User::where('id', '>', 1)->get(); $this->assertEquals(2, $users->count()); // test chunk User::chunk(2, function ($users) { foreach ($users as $user) { $this->assertInternalType('int', $user->id); } }); User::chunk(1, function ($users) { $this->assertInstanceOf('Illuminate\\Support\\Collection', $users); }); // test find with query builder $user = User::where('id', '>', 1)->find(1); $this->assertNull($user); $user = User::where('id', '>', 1)->find(2); $this->assertEquals(2, $user->id); // test first without query builder $user = User::first(); $this->assertInstanceOf('App\\User', $user); // test retrieving aggregates $max_id = User::max('id'); $this->assertGreaterThanOrEqual(3, $max_id); $count = User::count(); $this->assertGreaterThanOrEqual(3, $count); $sum = User::sum('id'); $this->assertGreaterThanOrEqual(6, $sum); }
public static function tableRowCount($col, $met, $val) { if (strlen(trim($val)) > 0) { return User::where(DB::raw($col), $met, '%' . str_replace(' ', '%', $val) . '%')->count(); } else { return User::count(); } }
public function index() { $title = "Dashboard"; $questions = Question::count(); $questioncategories = QuestionCategory::count(); $users = User::count(); return view('admin.dashboard.index', compact('title', 'questions', 'questioncategories', 'countries', 'users')); }
public function index() { $article_num = Article::count(); $articles = Article::sortByDesc('id')->take(5)->get(); $user_num = User::count(); $users = User::sortByDesc('id')->take(5)->get(); return Theme::view('admin.dash.index', compact(['article_num', 'user_num', 'articles', 'users'])); }
public function index() { $userCount = User::count(); $articleCount = Article::count(); $tagCount = Tag::count(); $imageCount = Image::count(); return view('admin.index', compact('userCount', 'articleCount', 'imageCount', 'tagCount')); }
public function delete($id) { if (User::count() < 2) { return redirect('admin/users'); } User::findOrFail($id)->delete(); return redirect('/admin/users'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $users = User::all(); $totalUser = User::count(); // dd($totalBiz); // foreach( $bizs as $biz) return view('admin.user.index', compact('users', 'totalUser')); }
public function home() { $stats['employees'] = \App\Employee::count(); $stats['assets'] = \App\Asset::count(); $stats['users'] = \App\User::count(); $stats['vendors'] = \App\Vendor::count(); return View('pages.dashboard', compact('stats')); }
public function index() { $title = "Dashboard"; $users = User::count(); $notifications = Notification::count(); $packages = Package::count(); return view('admin.dashboard.index', compact('users', 'title', 'notifications', 'packages')); }
public function index() { $article_count = Article::count(); $category_count = Category::count(); $tag_count = Tag::count(); $user_count = User::count(); return view('admin.console', compact('article_count', 'category_count', 'tag_count', 'user_count')); }
public function run() { $faker = Faker::create(); //Category for ($i = 0; $i < 10; $i++) { $user = User::select(['id'])->where('id', rand(1, User::count()))->first(); $address = Address::create(['user_id' => $i <= 2 ? 4 : $user->id, 'default' => 0, 'line1' => $faker->streetAddress, 'line2' => $faker->streetAddress, 'phone' => $faker->e164PhoneNumber, 'name_contact' => $faker->streetName, 'zipcode' => $faker->postcode, 'city' => $faker->city, 'country' => $faker->country, 'state' => $faker->state]); } }
/** * Execute the console command. * * @return mixed */ public function handle() { $this->info('Welcome to 2015 Election API'); if (User::count() > 0) { $this->error('Application is already installed!'); exit; } $this->createUser(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // //App::setLocale('kh'); //return trans('administrators.dashboard'); //$user = Auth::user(); //return $user->toJson(); return View('admin.dashboard')->with(['user_total' => \App\User::count(), 'content_total' => \App\Content::count(), 'category_total' => \App\Category::count(), 'slider_total' => \App\Slider::count()]); }
public function index() { $article_num = Article::count(); $user_num = User::count(); $person_num = Person::count(); $project_num = Project::count(); $users = User::sortByDesc('id')->take(5)->get(); return Theme::view('admin.dash.index', compact('article_num', 'user_num', 'person_num', 'project_num', 'users')); }
/** * Create a new user instance after a valid registration. * * @param array $data * @return User */ protected function create(array $data) { if (User::count() == 0) { $user_rank = 'admin'; } else { $user_rank = 'user'; } return User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password']), 'rank' => $user_rank]); }
public function dashboard() { // $this->middleware('auth'); $researchs = Research::count(); $funds = Fund::count(); $translations = Translation::count(); $users = User::count(); return view('dashboard', ['researchs' => $researchs, 'funds' => $funds, 'translations' => $translations, 'users' => $users]); }
public function getSiteStat() { return Cache::remember(self::CACHE_KEY, self::CACHE_MINUTES, function () { $entity = new StatEntity(); $entity->topic_count = Topic::count(); $entity->reply_count = Reply::count(); $entity->user_count = User::count(); return $entity; }); }
public function adminDashboard() { $page = 'partials.admin-dashboard'; $users = User::all(); $user_count = User::count(); $product_count = Product::count(); $brand_count = Brand::count(); $type_count = Type::count(); return view('quantri/admin', compact('page', 'users', 'user_count', 'product_count', 'brand_count', 'type_count')); }
public function index() { $pages = \App\Page::count(); $banners = \App\Banner::count(); $coupons = \App\Coupons::count(); $posts = \App\Post::count(); $users = \App\User::count(); $images = \App\Image::count(); return view('home')->with('pages', $pages)->with('banners', $banners)->with('coupons', $coupons)->with('posts', $posts)->with('users', $users)->with('images', $images); }
public function index() { $title = "Dashboard"; $article = Article::count(); $articlecategory = ArticleCategory::count(); $users = User::count(); $photo = Photo::count(); $photoalbum = PhotoAlbum::count(); return view('admin.dashboard.index', compact('title', 'article', 'articlecategory', 'photo', 'photoalbum', 'users')); }