@@ -4,15 +4,15 @@ |
||
| 4 | 4 | |
| 5 | 5 | class ClearDataSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - $permissions = DB::table('permissions')->whereIn('model', ['reports']); |
|
| 15 | - DB::table('groups_permissions')->whereIn('permission_id', $permissions->pluck('id'))->delete(); |
|
| 16 | - $permissions->delete(); |
|
| 17 | - } |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + $permissions = DB::table('permissions')->whereIn('model', ['reports']); |
|
| 15 | + DB::table('groups_permissions')->whereIn('permission_id', $permissions->pluck('id'))->delete(); |
|
| 16 | + $permissions->delete(); |
|
| 17 | + } |
|
| 18 | 18 | } |
@@ -11,7 +11,7 @@ |
||
| 11 | 11 | */ |
| 12 | 12 | public function run() |
| 13 | 13 | { |
| 14 | - $permissions = DB::table('permissions')->whereIn('model', ['reports']); |
|
| 14 | + $permissions = DB::table('permissions')->whereIn('model', ['reports']); |
|
| 15 | 15 | DB::table('groups_permissions')->whereIn('permission_id', $permissions->pluck('id'))->delete(); |
| 16 | 16 | $permissions->delete(); |
| 17 | 17 | } |
@@ -4,15 +4,15 @@ |
||
| 4 | 4 | |
| 5 | 5 | class DatabaseSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - $this->call(ClearDataSeeder::class); |
|
| 15 | - $this->call(ReportsTableSeeder::class); |
|
| 16 | - $this->call(AssignRelationsSeeder::class); |
|
| 17 | - } |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + $this->call(ClearDataSeeder::class); |
|
| 15 | + $this->call(ReportsTableSeeder::class); |
|
| 16 | + $this->call(AssignRelationsSeeder::class); |
|
| 17 | + } |
|
| 18 | 18 | } |
@@ -4,70 +4,70 @@ |
||
| 4 | 4 | |
| 5 | 5 | class ReportsTableSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - /** |
|
| 15 | - * Insert the permissions related to settings table. |
|
| 16 | - */ |
|
| 17 | - DB::table('permissions')->insert( |
|
| 18 | - [ |
|
| 19 | - /** |
|
| 20 | - * Reporting model permissions. |
|
| 21 | - */ |
|
| 22 | - [ |
|
| 23 | - 'name' => 'find', |
|
| 24 | - 'model' => 'reports', |
|
| 25 | - 'created_at' => \DB::raw('NOW()'), |
|
| 26 | - 'updated_at' => \DB::raw('NOW()') |
|
| 27 | - ], |
|
| 28 | - [ |
|
| 29 | - 'name' => 'search', |
|
| 30 | - 'model' => 'reports', |
|
| 31 | - 'created_at' => \DB::raw('NOW()'), |
|
| 32 | - 'updated_at' => \DB::raw('NOW()') |
|
| 33 | - ], |
|
| 34 | - [ |
|
| 35 | - 'name' => 'list', |
|
| 36 | - 'model' => 'reports', |
|
| 37 | - 'created_at' => \DB::raw('NOW()'), |
|
| 38 | - 'updated_at' => \DB::raw('NOW()') |
|
| 39 | - ], |
|
| 40 | - [ |
|
| 41 | - 'name' => 'findby', |
|
| 42 | - 'model' => 'reports', |
|
| 43 | - 'created_at' => \DB::raw('NOW()'), |
|
| 44 | - 'updated_at' => \DB::raw('NOW()') |
|
| 45 | - ], |
|
| 46 | - [ |
|
| 47 | - 'name' => 'first', |
|
| 48 | - 'model' => 'reports', |
|
| 49 | - 'created_at' => \DB::raw('NOW()'), |
|
| 50 | - 'updated_at' => \DB::raw('NOW()') |
|
| 51 | - ], |
|
| 52 | - [ |
|
| 53 | - 'name' => 'paginate', |
|
| 54 | - 'model' => 'reports', |
|
| 55 | - 'created_at' => \DB::raw('NOW()'), |
|
| 56 | - 'updated_at' => \DB::raw('NOW()') |
|
| 57 | - ], |
|
| 58 | - [ |
|
| 59 | - 'name' => 'paginateby', |
|
| 60 | - 'model' => 'reports', |
|
| 61 | - 'created_at' => \DB::raw('NOW()'), |
|
| 62 | - 'updated_at' => \DB::raw('NOW()') |
|
| 63 | - ], |
|
| 64 | - [ |
|
| 65 | - 'name' => 'admin_count', |
|
| 66 | - 'model' => 'reports', |
|
| 67 | - 'created_at' => \DB::raw('NOW()'), |
|
| 68 | - 'updated_at' => \DB::raw('NOW()') |
|
| 69 | - ] |
|
| 70 | - ] |
|
| 71 | - ); |
|
| 72 | - } |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + /** |
|
| 15 | + * Insert the permissions related to settings table. |
|
| 16 | + */ |
|
| 17 | + DB::table('permissions')->insert( |
|
| 18 | + [ |
|
| 19 | + /** |
|
| 20 | + * Reporting model permissions. |
|
| 21 | + */ |
|
| 22 | + [ |
|
| 23 | + 'name' => 'find', |
|
| 24 | + 'model' => 'reports', |
|
| 25 | + 'created_at' => \DB::raw('NOW()'), |
|
| 26 | + 'updated_at' => \DB::raw('NOW()') |
|
| 27 | + ], |
|
| 28 | + [ |
|
| 29 | + 'name' => 'search', |
|
| 30 | + 'model' => 'reports', |
|
| 31 | + 'created_at' => \DB::raw('NOW()'), |
|
| 32 | + 'updated_at' => \DB::raw('NOW()') |
|
| 33 | + ], |
|
| 34 | + [ |
|
| 35 | + 'name' => 'list', |
|
| 36 | + 'model' => 'reports', |
|
| 37 | + 'created_at' => \DB::raw('NOW()'), |
|
| 38 | + 'updated_at' => \DB::raw('NOW()') |
|
| 39 | + ], |
|
| 40 | + [ |
|
| 41 | + 'name' => 'findby', |
|
| 42 | + 'model' => 'reports', |
|
| 43 | + 'created_at' => \DB::raw('NOW()'), |
|
| 44 | + 'updated_at' => \DB::raw('NOW()') |
|
| 45 | + ], |
|
| 46 | + [ |
|
| 47 | + 'name' => 'first', |
|
| 48 | + 'model' => 'reports', |
|
| 49 | + 'created_at' => \DB::raw('NOW()'), |
|
| 50 | + 'updated_at' => \DB::raw('NOW()') |
|
| 51 | + ], |
|
| 52 | + [ |
|
| 53 | + 'name' => 'paginate', |
|
| 54 | + 'model' => 'reports', |
|
| 55 | + 'created_at' => \DB::raw('NOW()'), |
|
| 56 | + 'updated_at' => \DB::raw('NOW()') |
|
| 57 | + ], |
|
| 58 | + [ |
|
| 59 | + 'name' => 'paginateby', |
|
| 60 | + 'model' => 'reports', |
|
| 61 | + 'created_at' => \DB::raw('NOW()'), |
|
| 62 | + 'updated_at' => \DB::raw('NOW()') |
|
| 63 | + ], |
|
| 64 | + [ |
|
| 65 | + 'name' => 'admin_count', |
|
| 66 | + 'model' => 'reports', |
|
| 67 | + 'created_at' => \DB::raw('NOW()'), |
|
| 68 | + 'updated_at' => \DB::raw('NOW()') |
|
| 69 | + ] |
|
| 70 | + ] |
|
| 71 | + ); |
|
| 72 | + } |
|
| 73 | 73 | } |
@@ -4,19 +4,19 @@ discard block |
||
| 4 | 4 | |
| 5 | 5 | class AssignRelationsSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - /** |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + /** |
|
| 15 | 15 | * Assign the permissions to the admin group. |
| 16 | 16 | */ |
| 17 | - $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
|
| 18 | - DB::table('permissions')->whereIn('model', ['reports'])->each(function ($permission) use ($adminGroupId) { |
|
| 19 | - DB::table('groups_permissions')->insert( |
|
| 17 | + $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
|
| 18 | + DB::table('permissions')->whereIn('model', ['reports'])->each(function ($permission) use ($adminGroupId) { |
|
| 19 | + DB::table('groups_permissions')->insert( |
|
| 20 | 20 | [ |
| 21 | 21 | 'permission_id' => $permission->id, |
| 22 | 22 | 'group_id' => $adminGroupId, |
@@ -24,6 +24,6 @@ discard block |
||
| 24 | 24 | 'updated_at' => \DB::raw('NOW()') |
| 25 | 25 | ] |
| 26 | 26 | ); |
| 27 | - }); |
|
| 28 | - } |
|
| 27 | + }); |
|
| 28 | + } |
|
| 29 | 29 | } |
@@ -15,7 +15,7 @@ |
||
| 15 | 15 | * Assign the permissions to the admin group. |
| 16 | 16 | */ |
| 17 | 17 | $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
| 18 | - DB::table('permissions')->whereIn('model', ['reports'])->each(function ($permission) use ($adminGroupId) { |
|
| 18 | + DB::table('permissions')->whereIn('model', ['reports'])->each(function($permission) use ($adminGroupId) { |
|
| 19 | 19 | DB::table('groups_permissions')->insert( |
| 20 | 20 | [ |
| 21 | 21 | 'permission_id' => $permission->id, |
@@ -4,23 +4,23 @@ |
||
| 4 | 4 | |
| 5 | 5 | class ClearDataSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - $adminGroupId = DB::table('groups')->where('name', 'Admin')->first()->id; |
|
| 15 | - $adminUserId = DB::table('users')->where('email', '[email protected]')->first()->id; |
|
| 16 | - $permissions = DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups']); |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + $adminGroupId = DB::table('groups')->where('name', 'Admin')->first()->id; |
|
| 15 | + $adminUserId = DB::table('users')->where('email', '[email protected]')->first()->id; |
|
| 16 | + $permissions = DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups']); |
|
| 17 | 17 | |
| 18 | - DB::table('groups_permissions')->whereIn('permission_id', $permissions->pluck('id'))->delete(); |
|
| 19 | - DB::table('users_groups')->where('user_id', $adminUserId)->where('group_id', $adminGroupId)->delete(); |
|
| 18 | + DB::table('groups_permissions')->whereIn('permission_id', $permissions->pluck('id'))->delete(); |
|
| 19 | + DB::table('users_groups')->where('user_id', $adminUserId)->where('group_id', $adminGroupId)->delete(); |
|
| 20 | 20 | |
| 21 | - DB::table('users')->where('email', '[email protected]')->delete(); |
|
| 22 | - DB::table('groups')->where('name', 'Admin')->delete(); |
|
| 21 | + DB::table('users')->where('email', '[email protected]')->delete(); |
|
| 22 | + DB::table('groups')->where('name', 'Admin')->delete(); |
|
| 23 | 23 | |
| 24 | - $permissions->delete(); |
|
| 25 | - } |
|
| 24 | + $permissions->delete(); |
|
| 25 | + } |
|
| 26 | 26 | } |
@@ -4,17 +4,17 @@ |
||
| 4 | 4 | |
| 5 | 5 | class DatabaseSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - $this->call(ClearDataSeeder::class); |
|
| 15 | - $this->call(UsersTableSeeder::class); |
|
| 16 | - $this->call(GroupsTableSeeder::class); |
|
| 17 | - $this->call(PermissionsTableSeeder::class); |
|
| 18 | - $this->call(AssignRelationsSeeder::class); |
|
| 19 | - } |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + $this->call(ClearDataSeeder::class); |
|
| 15 | + $this->call(UsersTableSeeder::class); |
|
| 16 | + $this->call(GroupsTableSeeder::class); |
|
| 17 | + $this->call(PermissionsTableSeeder::class); |
|
| 18 | + $this->call(AssignRelationsSeeder::class); |
|
| 19 | + } |
|
| 20 | 20 | } |
@@ -4,125 +4,125 @@ |
||
| 4 | 4 | |
| 5 | 5 | class UsersTableSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - /** |
|
| 15 | - * Insert the permissions related to users table. |
|
| 16 | - */ |
|
| 17 | - DB::table('permissions')->insert( |
|
| 18 | - [ |
|
| 19 | - /** |
|
| 20 | - * Users model permissions. |
|
| 21 | - */ |
|
| 22 | - [ |
|
| 23 | - 'name' => 'save', |
|
| 24 | - 'model' => 'users', |
|
| 25 | - 'created_at' => \DB::raw('NOW()'), |
|
| 26 | - 'updated_at' => \DB::raw('NOW()') |
|
| 27 | - ], |
|
| 28 | - [ |
|
| 29 | - 'name' => 'delete', |
|
| 30 | - 'model' => 'users', |
|
| 31 | - 'created_at' => \DB::raw('NOW()'), |
|
| 32 | - 'updated_at' => \DB::raw('NOW()') |
|
| 33 | - ], |
|
| 34 | - [ |
|
| 35 | - 'name' => 'find', |
|
| 36 | - 'model' => 'users', |
|
| 37 | - 'created_at' => \DB::raw('NOW()'), |
|
| 38 | - 'updated_at' => \DB::raw('NOW()') |
|
| 39 | - ], |
|
| 40 | - [ |
|
| 41 | - 'name' => 'list', |
|
| 42 | - 'model' => 'users', |
|
| 43 | - 'created_at' => \DB::raw('NOW()'), |
|
| 44 | - 'updated_at' => \DB::raw('NOW()') |
|
| 45 | - ], |
|
| 46 | - [ |
|
| 47 | - 'name' => 'search', |
|
| 48 | - 'model' => 'users', |
|
| 49 | - 'created_at' => \DB::raw('NOW()'), |
|
| 50 | - 'updated_at' => \DB::raw('NOW()') |
|
| 51 | - ], |
|
| 52 | - [ |
|
| 53 | - 'name' => 'findby', |
|
| 54 | - 'model' => 'users', |
|
| 55 | - 'created_at' => \DB::raw('NOW()'), |
|
| 56 | - 'updated_at' => \DB::raw('NOW()') |
|
| 57 | - ], |
|
| 58 | - [ |
|
| 59 | - 'name' => 'first', |
|
| 60 | - 'model' => 'users', |
|
| 61 | - 'created_at' => \DB::raw('NOW()'), |
|
| 62 | - 'updated_at' => \DB::raw('NOW()') |
|
| 63 | - ], |
|
| 64 | - [ |
|
| 65 | - 'name' => 'paginate', |
|
| 66 | - 'model' => 'users', |
|
| 67 | - 'created_at' => \DB::raw('NOW()'), |
|
| 68 | - 'updated_at' => \DB::raw('NOW()') |
|
| 69 | - ], |
|
| 70 | - [ |
|
| 71 | - 'name' => 'paginateby', |
|
| 72 | - 'model' => 'users', |
|
| 73 | - 'created_at' => \DB::raw('NOW()'), |
|
| 74 | - 'updated_at' => \DB::raw('NOW()') |
|
| 75 | - ], |
|
| 76 | - [ |
|
| 77 | - 'name' => 'assigngroups', |
|
| 78 | - 'model' => 'users', |
|
| 79 | - 'created_at' => \DB::raw('NOW()'), |
|
| 80 | - 'updated_at' => \DB::raw('NOW()') |
|
| 81 | - ], |
|
| 82 | - [ |
|
| 83 | - 'name' => 'block', |
|
| 84 | - 'model' => 'users', |
|
| 85 | - 'created_at' => \DB::raw('NOW()'), |
|
| 86 | - 'updated_at' => \DB::raw('NOW()') |
|
| 87 | - ], |
|
| 88 | - [ |
|
| 89 | - 'name' => 'unblock', |
|
| 90 | - 'model' => 'users', |
|
| 91 | - 'created_at' => \DB::raw('NOW()'), |
|
| 92 | - 'updated_at' => \DB::raw('NOW()') |
|
| 93 | - ], |
|
| 94 | - [ |
|
| 95 | - 'name' => 'group', |
|
| 96 | - 'model' => 'users', |
|
| 97 | - 'created_at' => \DB::raw('NOW()'), |
|
| 98 | - 'updated_at' => \DB::raw('NOW()') |
|
| 99 | - ], |
|
| 100 | - [ |
|
| 101 | - 'name' => 'deleted', |
|
| 102 | - 'model' => 'users', |
|
| 103 | - 'created_at' => \DB::raw('NOW()'), |
|
| 104 | - 'updated_at' => \DB::raw('NOW()') |
|
| 105 | - ], |
|
| 106 | - [ |
|
| 107 | - 'name' => 'restore', |
|
| 108 | - 'model' => 'users', |
|
| 109 | - 'created_at' => \DB::raw('NOW()'), |
|
| 110 | - 'updated_at' => \DB::raw('NOW()') |
|
| 111 | - ] |
|
| 112 | - ] |
|
| 113 | - ); |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + /** |
|
| 15 | + * Insert the permissions related to users table. |
|
| 16 | + */ |
|
| 17 | + DB::table('permissions')->insert( |
|
| 18 | + [ |
|
| 19 | + /** |
|
| 20 | + * Users model permissions. |
|
| 21 | + */ |
|
| 22 | + [ |
|
| 23 | + 'name' => 'save', |
|
| 24 | + 'model' => 'users', |
|
| 25 | + 'created_at' => \DB::raw('NOW()'), |
|
| 26 | + 'updated_at' => \DB::raw('NOW()') |
|
| 27 | + ], |
|
| 28 | + [ |
|
| 29 | + 'name' => 'delete', |
|
| 30 | + 'model' => 'users', |
|
| 31 | + 'created_at' => \DB::raw('NOW()'), |
|
| 32 | + 'updated_at' => \DB::raw('NOW()') |
|
| 33 | + ], |
|
| 34 | + [ |
|
| 35 | + 'name' => 'find', |
|
| 36 | + 'model' => 'users', |
|
| 37 | + 'created_at' => \DB::raw('NOW()'), |
|
| 38 | + 'updated_at' => \DB::raw('NOW()') |
|
| 39 | + ], |
|
| 40 | + [ |
|
| 41 | + 'name' => 'list', |
|
| 42 | + 'model' => 'users', |
|
| 43 | + 'created_at' => \DB::raw('NOW()'), |
|
| 44 | + 'updated_at' => \DB::raw('NOW()') |
|
| 45 | + ], |
|
| 46 | + [ |
|
| 47 | + 'name' => 'search', |
|
| 48 | + 'model' => 'users', |
|
| 49 | + 'created_at' => \DB::raw('NOW()'), |
|
| 50 | + 'updated_at' => \DB::raw('NOW()') |
|
| 51 | + ], |
|
| 52 | + [ |
|
| 53 | + 'name' => 'findby', |
|
| 54 | + 'model' => 'users', |
|
| 55 | + 'created_at' => \DB::raw('NOW()'), |
|
| 56 | + 'updated_at' => \DB::raw('NOW()') |
|
| 57 | + ], |
|
| 58 | + [ |
|
| 59 | + 'name' => 'first', |
|
| 60 | + 'model' => 'users', |
|
| 61 | + 'created_at' => \DB::raw('NOW()'), |
|
| 62 | + 'updated_at' => \DB::raw('NOW()') |
|
| 63 | + ], |
|
| 64 | + [ |
|
| 65 | + 'name' => 'paginate', |
|
| 66 | + 'model' => 'users', |
|
| 67 | + 'created_at' => \DB::raw('NOW()'), |
|
| 68 | + 'updated_at' => \DB::raw('NOW()') |
|
| 69 | + ], |
|
| 70 | + [ |
|
| 71 | + 'name' => 'paginateby', |
|
| 72 | + 'model' => 'users', |
|
| 73 | + 'created_at' => \DB::raw('NOW()'), |
|
| 74 | + 'updated_at' => \DB::raw('NOW()') |
|
| 75 | + ], |
|
| 76 | + [ |
|
| 77 | + 'name' => 'assigngroups', |
|
| 78 | + 'model' => 'users', |
|
| 79 | + 'created_at' => \DB::raw('NOW()'), |
|
| 80 | + 'updated_at' => \DB::raw('NOW()') |
|
| 81 | + ], |
|
| 82 | + [ |
|
| 83 | + 'name' => 'block', |
|
| 84 | + 'model' => 'users', |
|
| 85 | + 'created_at' => \DB::raw('NOW()'), |
|
| 86 | + 'updated_at' => \DB::raw('NOW()') |
|
| 87 | + ], |
|
| 88 | + [ |
|
| 89 | + 'name' => 'unblock', |
|
| 90 | + 'model' => 'users', |
|
| 91 | + 'created_at' => \DB::raw('NOW()'), |
|
| 92 | + 'updated_at' => \DB::raw('NOW()') |
|
| 93 | + ], |
|
| 94 | + [ |
|
| 95 | + 'name' => 'group', |
|
| 96 | + 'model' => 'users', |
|
| 97 | + 'created_at' => \DB::raw('NOW()'), |
|
| 98 | + 'updated_at' => \DB::raw('NOW()') |
|
| 99 | + ], |
|
| 100 | + [ |
|
| 101 | + 'name' => 'deleted', |
|
| 102 | + 'model' => 'users', |
|
| 103 | + 'created_at' => \DB::raw('NOW()'), |
|
| 104 | + 'updated_at' => \DB::raw('NOW()') |
|
| 105 | + ], |
|
| 106 | + [ |
|
| 107 | + 'name' => 'restore', |
|
| 108 | + 'model' => 'users', |
|
| 109 | + 'created_at' => \DB::raw('NOW()'), |
|
| 110 | + 'updated_at' => \DB::raw('NOW()') |
|
| 111 | + ] |
|
| 112 | + ] |
|
| 113 | + ); |
|
| 114 | 114 | |
| 115 | 115 | /** |
| 116 | 116 | * Create Default users. |
| 117 | 117 | */ |
| 118 | 118 | DB::table('users')->insertGetId( |
| 119 | - [ |
|
| 119 | + [ |
|
| 120 | 120 | 'name' => 'Admin', |
| 121 | 121 | 'email' => '[email protected]', |
| 122 | 122 | 'password' => bcrypt('123456'), |
| 123 | 123 | 'created_at' => \DB::raw('NOW()'), |
| 124 | 124 | 'updated_at' => \DB::raw('NOW()') |
| 125 | 125 | ] |
| 126 | - ); |
|
| 127 | - } |
|
| 126 | + ); |
|
| 127 | + } |
|
| 128 | 128 | } |
@@ -4,14 +4,14 @@ discard block |
||
| 4 | 4 | |
| 5 | 5 | class AssignRelationsSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
|
| 15 | 15 | $adminUserId = DB::table('users')->whereIn('email', '[email protected]')->select('id')->first()->id; |
| 16 | 16 | |
| 17 | 17 | /** |
@@ -24,13 +24,13 @@ discard block |
||
| 24 | 24 | 'created_at' => \DB::raw('NOW()'), |
| 25 | 25 | 'updated_at' => \DB::raw('NOW()') |
| 26 | 26 | ] |
| 27 | - ); |
|
| 27 | + ); |
|
| 28 | 28 | |
| 29 | - /** |
|
| 29 | + /** |
|
| 30 | 30 | * Assign the permissions to the admin group. |
| 31 | 31 | */ |
| 32 | - DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups'])->each(function ($permission) use ($adminGroupId) { |
|
| 33 | - DB::table('groups_permissions')->insert( |
|
| 32 | + DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups'])->each(function ($permission) use ($adminGroupId) { |
|
| 33 | + DB::table('groups_permissions')->insert( |
|
| 34 | 34 | [ |
| 35 | 35 | 'permission_id' => $permission->id, |
| 36 | 36 | 'group_id' => $adminGroupId, |
@@ -38,6 +38,6 @@ discard block |
||
| 38 | 38 | 'updated_at' => \DB::raw('NOW()') |
| 39 | 39 | ] |
| 40 | 40 | ); |
| 41 | - }); |
|
| 42 | - } |
|
| 41 | + }); |
|
| 42 | + } |
|
| 43 | 43 | } |
@@ -12,7 +12,7 @@ discard block |
||
| 12 | 12 | public function run() |
| 13 | 13 | { |
| 14 | 14 | $adminGroupId = DB::table('groups')->whereIn('name', 'admin')->select('id')->first()->id; |
| 15 | - $adminUserId = DB::table('users')->whereIn('email', '[email protected]')->select('id')->first()->id; |
|
| 15 | + $adminUserId = DB::table('users')->whereIn('email', '[email protected]')->select('id')->first()->id; |
|
| 16 | 16 | |
| 17 | 17 | /** |
| 18 | 18 | * Assign users to groups. |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | /** |
| 30 | 30 | * Assign the permissions to the admin group. |
| 31 | 31 | */ |
| 32 | - DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups'])->each(function ($permission) use ($adminGroupId) { |
|
| 32 | + DB::table('permissions')->whereIn('model', ['users', 'permissions', 'groups'])->each(function($permission) use ($adminGroupId) { |
|
| 33 | 33 | DB::table('groups_permissions')->insert( |
| 34 | 34 | [ |
| 35 | 35 | 'permission_id' => $permission->id, |
@@ -4,64 +4,64 @@ |
||
| 4 | 4 | |
| 5 | 5 | class PermissionsTableSeeder extends Seeder |
| 6 | 6 | { |
| 7 | - /** |
|
| 8 | - * Run the database seeds. |
|
| 9 | - * |
|
| 10 | - * @return void |
|
| 11 | - */ |
|
| 12 | - public function run() |
|
| 13 | - { |
|
| 14 | - /** |
|
| 15 | - * Insert the permissions related to permissions table. |
|
| 16 | - */ |
|
| 17 | - DB::table('permissions')->insert( |
|
| 18 | - [ |
|
| 19 | - /** |
|
| 20 | - * Permissions model permissions. |
|
| 21 | - */ |
|
| 22 | - [ |
|
| 23 | - 'name' => 'find', |
|
| 24 | - 'model' => 'permissions', |
|
| 25 | - 'created_at' => \DB::raw('NOW()'), |
|
| 26 | - 'updated_at' => \DB::raw('NOW()') |
|
| 27 | - ], |
|
| 28 | - [ |
|
| 29 | - 'name' => 'search', |
|
| 30 | - 'model' => 'permissions', |
|
| 31 | - 'created_at' => \DB::raw('NOW()'), |
|
| 32 | - 'updated_at' => \DB::raw('NOW()') |
|
| 33 | - ], |
|
| 34 | - [ |
|
| 35 | - 'name' => 'list', |
|
| 36 | - 'model' => 'permissions', |
|
| 37 | - 'created_at' => \DB::raw('NOW()'), |
|
| 38 | - 'updated_at' => \DB::raw('NOW()') |
|
| 39 | - ], |
|
| 40 | - [ |
|
| 41 | - 'name' => 'findby', |
|
| 42 | - 'model' => 'permissions', |
|
| 43 | - 'created_at' => \DB::raw('NOW()'), |
|
| 44 | - 'updated_at' => \DB::raw('NOW()') |
|
| 45 | - ], |
|
| 46 | - [ |
|
| 47 | - 'name' => 'first', |
|
| 48 | - 'model' => 'permissions', |
|
| 49 | - 'created_at' => \DB::raw('NOW()'), |
|
| 50 | - 'updated_at' => \DB::raw('NOW()') |
|
| 51 | - ], |
|
| 52 | - [ |
|
| 53 | - 'name' => 'paginate', |
|
| 54 | - 'model' => 'permissions', |
|
| 55 | - 'created_at' => \DB::raw('NOW()'), |
|
| 56 | - 'updated_at' => \DB::raw('NOW()') |
|
| 57 | - ], |
|
| 58 | - [ |
|
| 59 | - 'name' => 'paginateby', |
|
| 60 | - 'model' => 'permissions', |
|
| 61 | - 'created_at' => \DB::raw('NOW()'), |
|
| 62 | - 'updated_at' => \DB::raw('NOW()') |
|
| 63 | - ] |
|
| 64 | - ] |
|
| 65 | - ); |
|
| 66 | - } |
|
| 7 | + /** |
|
| 8 | + * Run the database seeds. |
|
| 9 | + * |
|
| 10 | + * @return void |
|
| 11 | + */ |
|
| 12 | + public function run() |
|
| 13 | + { |
|
| 14 | + /** |
|
| 15 | + * Insert the permissions related to permissions table. |
|
| 16 | + */ |
|
| 17 | + DB::table('permissions')->insert( |
|
| 18 | + [ |
|
| 19 | + /** |
|
| 20 | + * Permissions model permissions. |
|
| 21 | + */ |
|
| 22 | + [ |
|
| 23 | + 'name' => 'find', |
|
| 24 | + 'model' => 'permissions', |
|
| 25 | + 'created_at' => \DB::raw('NOW()'), |
|
| 26 | + 'updated_at' => \DB::raw('NOW()') |
|
| 27 | + ], |
|
| 28 | + [ |
|
| 29 | + 'name' => 'search', |
|
| 30 | + 'model' => 'permissions', |
|
| 31 | + 'created_at' => \DB::raw('NOW()'), |
|
| 32 | + 'updated_at' => \DB::raw('NOW()') |
|
| 33 | + ], |
|
| 34 | + [ |
|
| 35 | + 'name' => 'list', |
|
| 36 | + 'model' => 'permissions', |
|
| 37 | + 'created_at' => \DB::raw('NOW()'), |
|
| 38 | + 'updated_at' => \DB::raw('NOW()') |
|
| 39 | + ], |
|
| 40 | + [ |
|
| 41 | + 'name' => 'findby', |
|
| 42 | + 'model' => 'permissions', |
|
| 43 | + 'created_at' => \DB::raw('NOW()'), |
|
| 44 | + 'updated_at' => \DB::raw('NOW()') |
|
| 45 | + ], |
|
| 46 | + [ |
|
| 47 | + 'name' => 'first', |
|
| 48 | + 'model' => 'permissions', |
|
| 49 | + 'created_at' => \DB::raw('NOW()'), |
|
| 50 | + 'updated_at' => \DB::raw('NOW()') |
|
| 51 | + ], |
|
| 52 | + [ |
|
| 53 | + 'name' => 'paginate', |
|
| 54 | + 'model' => 'permissions', |
|
| 55 | + 'created_at' => \DB::raw('NOW()'), |
|
| 56 | + 'updated_at' => \DB::raw('NOW()') |
|
| 57 | + ], |
|
| 58 | + [ |
|
| 59 | + 'name' => 'paginateby', |
|
| 60 | + 'model' => 'permissions', |
|
| 61 | + 'created_at' => \DB::raw('NOW()'), |
|
| 62 | + 'updated_at' => \DB::raw('NOW()') |
|
| 63 | + ] |
|
| 64 | + ] |
|
| 65 | + ); |
|
| 66 | + } |
|
| 67 | 67 | } |