Changeset 24a616f for database

Timestamp:

10/13/21 15:44:57 (3 years ago)

Author:

Berat Kjufliju <kufliju@…>

Branches:

develop, master

Children:

120759b

Parents:

194a359

Message:

added documents crud, added last_seen_to_user, edited views

Location:

database

Files:

• factories/DepartmentFactory.php (added)
• factories/UserFactory.php (deleted)
• migrations/2021_09_27_171107_create_users_table.php (modified) (1 diff)
• migrations/2021_09_29_121244_create_departments_table.php (modified) (1 diff)
• migrations/2021_10_06_103305_create_documents_table.php (added)
• migrations/2021_10_07_131654_create_add_last_seen_to_users_table.php (added)
• migrations/2021_10_10_103309_create_files_table.php (added)
• seeders/DatabaseSeeder.php (modified) (1 diff)
• seeders/DepartmentsTableSeeder.php (modified) (2 diffs)
• seeders/DocumentsTableSeeder.php (added)
• seeders/PermissionsTableSeeder.php (modified) (1 diff)
• seeders/RolesPermissionsTableSeeder.php (modified) (1 diff)
• seeders/RolesTableSeeder.php (modified) (1 diff)
• seeders/UsersTableSeeder.php (modified) (1 diff)

database/migrations/2021_09_27_171107_create_users_table.php

@@ -23 +23 @@
             $table->string('email')->unique();
             $table->string('mobile_number')->unique();
+            $table->string('avatar')->nullable();
             $table->integer('role_id')->unsigned();
             $table->foreign("role_id")->references("id")->on("roles");

database/migrations/2021_09_29_121244_create_departments_table.php

@@ -19 +19 @@
             $table->string("name");
             $table->string("code");
+            $table->string("location");
             $table->timestamps();
 

database/seeders/DatabaseSeeder.php

@@ -19 +19 @@
         $this->call(UsersTableSeeder::class);
         $this->call(DepartmentsTableSeeder::class);
+        $this->call(DocumentsTableSeeder::class);
     }
 }

database/seeders/DepartmentsTableSeeder.php

@@ -3 +3 @@
 namespace Database\Seeders;
 
+use App\Models\Department;
 use Carbon\Carbon;
 use Illuminate\Database\Seeder;
@@ -15 +16 @@
     public function run()
     {
-        \DB::table('departments')->insert([
-            [
-                "name" => "HR department",
-                "code" => "14",
-                "user_id" => "1",
-                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
-            ],
-            [
-                "name" => "IT department",
-                "code" => "01",
-                "user_id" => "1",
-                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
-            ],
-            [
-                "name" => "Business department",
-                "code" => "12",
-                "user_id" => "1",
-                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
-            ],
-        ]);
+//        \DB::table('departments')->insert([
+//            [
+//                "name" => "HR department",
+//                "code" => "14",
+//                "location" => "C:\laragon\www\SaveSpace\storage/Departments/14",
+//                "user_id" => "1",
+//                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
+//            ],
+//            [
+//                "name" => "IT department",
+//                "code" => "01",
+//                "location" => "C:\laragon\www\SaveSpace\storage/Departments/01",
+//                "user_id" => "1",
+//                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
+//            ],
+//            [
+//                "name" => "Business department",
+//                "code" => "12",
+//                "location" => "C:\laragon\www\SaveSpace\storage/Departments/12",
+//                "user_id" => "1",
+//                "created_at" => Carbon::now()->format('Y-m-d H:i:s'),
+//            ],
+//        ]);
+
+        Department::factory()->count(50)->create();
     }
 }

database/seeders/PermissionsTableSeeder.php

@@ -18 +18 @@
         \DB::table('permissions')->insert([
             ["name" => "create_user"],                          // Create new user
-            ["name" => "access_all_users"],             // Access to all users to manage
-            ["name" => "access_all_departments"],               // Access to all departments to manage
+            ["name" => "manage_all_users"],             // Access all users to manage
+            ["name" => "manage_all_departments"],       // Access all departments to manage
+            ["name" => "manage_all_documents"],         // Access all documents to manage
+            ["name" => "view_all_departments"],         // Access all departments to view
+            ["name" => "view_all_documents"],       // Access all documents to view
+            ["name" => "edit_all_documents"],           // Edit all documents
+            ["name" => "edit_document"],                    // Edit your document/s
+            ["name" => "delete_all_documents"],         // Delete all document/s
+            ["name" => "delete_document"],              // Delete your document/s
         ]);
     }

database/seeders/RolesPermissionsTableSeeder.php

@@ -19 +19 @@
             ["role_id" => 1, "permission_id" => 2],
             ["role_id" => 1, "permission_id" => 3],
+            ["role_id" => 1, "permission_id" => 4],
+            ["role_id" => 1, "permission_id" => 5],
+            ["role_id" => 1, "permission_id" => 6],
+            ["role_id" => 1, "permission_id" => 7],
+            ["role_id" => 1, "permission_id" => 8],
+            ["role_id" => 1, "permission_id" => 9],
+            ["role_id" => 1, "permission_id" => 10],
 
             // Referent
-            ["role_id" => 2, "permission_id" => 3]
+            ["role_id" => 2, "permission_id" => 3],
+            ["role_id" => 2, "permission_id" => 4],
+            ["role_id" => 2, "permission_id" => 5],
+            ["role_id" => 2, "permission_id" => 6],
+            ["role_id" => 2, "permission_id" => 7],
+            ["role_id" => 2, "permission_id" => 8],
+            ["role_id" => 2, "permission_id" => 9],
+            ["role_id" => 2, "permission_id" => 10],
+
+            // Viewer
+            ["role_id" => 3, "permission_id" => 5],
+            ["role_id" => 3, "permission_id" => 6],
         ]);
     }

database/seeders/RolesTableSeeder.php

@@ -16 +16 @@
         \DB::table('roles')->insert([
             ["name" => "Admin"], // Have access to all users(managing users), departments, documents etc
-            ["name" => "Referent"], // Have access to all departments, documents etc
+            ["name" => "Referent"], // Have access to manage and view all departments, documents etc
+            ["name" => "Viewer"], // Have access to view all departments, documents etc
         ]);
     }

database/seeders/UsersTableSeeder.php

@@ -41 +41 @@
         ]);
 
-        //factory(App\Models\User::class, 50)->create();
     }
 }