Changeset 4b7e2d3 for app/Http/Controllers/Dashboard/IndexController.php

Timestamp:

10/23/21 04:03:46 (3 years ago)

Author:

beratkjufliju <kufliju@…>

Branches:

develop, master

Children:

b39afb5

Parents:

c6b84df

Message:

bug fixes, edited export, added fileSeeder for DB testing

File:

• app/Http/Controllers/Dashboard/IndexController.php (modified) (2 diffs)

app/Http/Controllers/Dashboard/IndexController.php

@@ -9 +9 @@
 use App\Models\User;
 use App\Http\Controllers\Controller;
+use Carbon\Carbon;
+use Illuminate\Support\Facades\DB;
 
 class IndexController extends Controller
@@ -18 +20 @@
         );
 
+        $date = Carbon::today()->subDays(5);
+        $recentFiles = File::where('created_at', '>=', $date)->get();
+
+        $year = ['2021','2022','2023','2024', '2025'];
+
+        $file = [];
+        foreach ($year as $key => $value) {
+            $file[] = File::where(DB::raw("DATE_FORMAT(created_at, '%Y')"),$value)->count();
+        }
+
         return view("dashboard.index")->with([
             "counters" => $counters,
+            "largestDepartments" => Department::orderBy('no_of_folders', 'desc')->limit(10)->get(),
+            "folders" => Folder::all(),
+            "files" => File::all(),
+            "recentFiles" => $recentFiles,
+            "year" => json_encode($year,JSON_NUMERIC_CHECK),
+            "file" => json_encode($file,JSON_NUMERIC_CHECK),
             "departments" => Department::all(),
-            "folders" => Folder::all(),
-            "files" => File::all()
-        ]);
+            "excelExt" => array("xls", "xlsx", "xls", "csv"),
+            "textExt" => array("txt", "doc", "docx"),
+            "imageExt" => array("png", "jpg", "jpeg"),
+
+         ]);
     }
 }