1 | <?php
|
---|
2 |
|
---|
3 | namespace App\Http\Controllers\Dashboard;
|
---|
4 |
|
---|
5 | use App\Helpers\Alert;
|
---|
6 | use App\Models\Department;
|
---|
7 | use App\Models\Folder;
|
---|
8 | use App\Models\File;
|
---|
9 | use App\Models\User;
|
---|
10 | use App\Http\Controllers\Controller;
|
---|
11 | use Carbon\Carbon;
|
---|
12 | use Illuminate\Support\Facades\DB;
|
---|
13 |
|
---|
14 | class 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 | }
|
---|