source: app/Http/Controllers/Dashboard/IndexController.php@ dbc5976

Last change on this file since dbc5976 was 0a1fb54, checked in by beratkjufliju <kufliju@…>, 3 years ago

bug fixes

  • Property mode set to 100644
File size: 1.4 KB
Line 
1<?php
2
3namespace App\Http\Controllers\Dashboard;
4
5use App\Helpers\Alert;
6use App\Models\Department;
7use App\Models\Folder;
8use App\Models\File;
9use App\Models\User;
10use App\Http\Controllers\Controller;
11use Carbon\Carbon;
12use Illuminate\Support\Facades\DB;
13
14class IndexController extends Controller
15{
16 public function index()
17 {
18 $counters = array(
19 "users" => User::count(),
20 );
21
22 $date = Carbon::today()->subDays(5);
23 $recentFiles = File::where('created_at', '>=', $date)->get();
24
25 $year = ['2021','2022','2023','2024', '2025'];
26
27 $file = [];
28 foreach ($year as $key => $value) {
29 $file[] = File::where(DB::raw("DATE_FORMAT(created_at, '%Y')"),$value)->count();
30 }
31
32 return view("dashboard.index")->with([
33 "counters" => $counters,
34 "largestDepartments" => Department::orderBy('no_of_folders', 'desc')->limit(5)->get(),
35 "folders" => Folder::all(),
36 "files" => File::all(),
37 "recentFiles" => $recentFiles,
38 "year" => json_encode($year,JSON_NUMERIC_CHECK),
39 "file" => json_encode($file,JSON_NUMERIC_CHECK),
40 "departments" => Department::all(),
41 "excelExt" => array("xls", "xlsx", "xls", "csv"),
42 "textExt" => array("txt", "doc", "docx"),
43 "imageExt" => array("png", "jpg", "jpeg")
44
45 ]);
46 }
47}
Note: See TracBrowser for help on using the repository browser.