Changeset d795fa6 for database

Timestamp:

10/17/21 18:39:50 (3 years ago)

Author:

Berat Kjufliju <kufliju@…>

Branches:

develop, master

Children:

bd9e8e3

Parents:

120759b

Message:

added validation to blades

Location:

database

Files:

• factories/DepartmentFactory.php (modified) (1 diff)
• factories/UserFactory.php (modified) (1 diff)
• migrations/2021_09_27_171107_create_users_table.php (modified) (2 diffs)
• migrations/2021_09_29_121244_create_departments_table.php (modified) (1 diff)
• seeders/PermissionsTableSeeder.php (modified) (1 diff)
• seeders/RolesPermissionsTableSeeder.php (modified) (2 diffs)
• seeders/UsersTableSeeder.php (modified) (1 diff)

database/factories/DepartmentFactory.php

@@ -28 +28 @@
         return [
             'id' => $this->faker->unique()->randomNumber(),
-            'name' => $this->faker->domainName(),
+            'name' => $this->faker->name(),
             'code' => $location,
             'location' => 'Departments/' . $location,

database/factories/UserFactory.php

@@ -29 +29 @@
             'password' => $this->faker->password(),
             'email' => $this->faker->email(),
-            'mobile_number' => $this->faker->phoneNumber(),
+            'phone_number' => $this->faker->phoneNumber(),
             'role_id' => $this->faker->numberBetween(1, 2),
             'is_online' => $this->faker->boolean,
             'is_confirmed' => $this->faker->boolean,
             'is_forgot_password' => $this->faker->boolean,
+            'created_by' => "1",
             'created_at' => Carbon::now()
         ];

database/migrations/2021_09_27_171107_create_users_table.php

@@ -22 +22 @@
             $table->string('password');
             $table->string('email')->unique();
-            $table->string('mobile_number')->unique();
+            $table->string('phone_number')->unique();
             $table->string('avatar')->nullable();
             $table->integer('role_id')->unsigned();
@@ -32 +32 @@
             $table->integer('security_code')->nullable();
             $table->string('verify_token')->nullable();
+            $table->integer("created_by")->unsigned();
             $table->rememberToken();
             $table->timestamps();
+
+            $table->foreign("created_by")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
         });
     }

database/migrations/2021_09_29_121244_create_departments_table.php

@@ -23 +23 @@
 
             $table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
-
         });
     }

database/seeders/PermissionsTableSeeder.php

@@ -27 +27 @@
             ["name" => "delete_all_documents"],         // Delete all document/s
             ["name" => "delete_document"],              // Delete your document/s
+            ["name" => "manage_file_types"],    // Access all file_types to manage
         ]);
     }

database/seeders/RolesPermissionsTableSeeder.php

@@ -26 +26 @@
             ["role_id" => 1, "permission_id" => 9],
             ["role_id" => 1, "permission_id" => 10],
+            ["role_id" => 1, "permission_id" => 11],
 
             // Referent
@@ -36 +37 @@
             ["role_id" => 2, "permission_id" => 9],
             ["role_id" => 2, "permission_id" => 10],
+            ["role_id" => 2, "permission_id" => 11],
 
             // Viewer

database/seeders/UsersTableSeeder.php

@@ -22 +22 @@
             "password" => bcrypt("123456"),
             "email" => "kufliju@gmail.com",
-            "mobile_number" => "+38971201239",
+            "phone_number" => "+38971201239",
             "role_id" => 1,
             "is_active" => true,
             "is_confirmed" => true,
+            "created_by" => "1",
             "created_at" => Carbon::now()
         ]);