Passed
Push — dev5 ( 1d1d2b...f018c9 )
by Ron
06:53
created
app/Http/Controllers/Installer/SystemsController.php 3 patches
Indentation   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -209,10 +209,10 @@  discard block
 block discarded – undo
209 209
     }
210 210
 
211 211
     //  Delete an existing system - note this will fail if the system has any customers or tech tips assigned to it
212
-   public function destroy($id)
213
-   {
214
-       //
215
-       try {
212
+    public function destroy($id)
213
+    {
214
+        //
215
+        try {
216 216
             SystemTypes::find($id)->delete();
217 217
             return response()->json(['success' => true, 'reason' => 'Equipment Successfully Deleted']);
218 218
         }
@@ -220,5 +220,5 @@  discard block
 block discarded – undo
220 220
         {
221 221
             return response()->json(['success' => false, 'reason' => 'Cannot delete this equipment.  It has Customers or Tech Tips assigned to it.  Please delete those first.']);
222 222
         }
223
-   }
223
+    }
224 224
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -18,7 +18,7 @@  discard block
 block discarded – undo
18 18
     public function __construct()
19 19
     {
20 20
         $this->middleware('auth');
21
-        $this->middleware(function ($request, $next) {
21
+        $this->middleware(function($request, $next) {
22 22
             $this->authorize('hasAccess', 'Manage Equipment');
23 23
             return $next($request);
24 24
         });
@@ -120,7 +120,7 @@  discard block
 block discarded – undo
120 120
         $fields = SystemDataFieldTypes::all();
121 121
         $cat = SystemCategories::where('name', str_replace('-', ' ', $cat))->first();
122 122
 
123
-        Log::debug('Route ' . Route::currentRouteName() . ' visited by User ID-' . Auth::user()->user_id);
123
+        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
124 124
         return view('installer.newSystem', [
125 125
             'cat'      => $cat,
126 126
             'dataList' => $fields,
@@ -136,7 +136,7 @@  discard block
 block discarded – undo
136 136
             $query->join('system_data_field_types', 'system_data_fields.data_type_id', '=', 'system_data_field_types.data_type_id');
137 137
         }])->withCount('SystemDataFields')->first();
138 138
 
139
-        Log::debug('Route ' . Route::currentRouteName() . ' visited by User ID-' . Auth::user()->user_id);
139
+        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
140 140
         return view('installer.editSystem', [
141 141
             'system'   => $system,
142 142
             'dataList' => $fields,
@@ -216,7 +216,7 @@  discard block
 block discarded – undo
216 216
             SystemTypes::find($id)->delete();
217 217
             return response()->json(['success' => true, 'reason' => 'Equipment Successfully Deleted']);
218 218
         }
219
-        catch (\Illuminate\Database\QueryException $e)
219
+        catch(\Illuminate\Database\QueryException $e)
220 220
         {
221 221
             return response()->json(['success' => false, 'reason' => 'Cannot delete this equipment.  It has Customers or Tech Tips assigned to it.  Please delete those first.']);
222 222
         }
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -131,8 +131,7 @@  discard block
 block discarded – undo
131 131
     public function edit($id)
132 132
     {
133 133
         $fields = SystemDataFieldTypes::all();
134
-        $system = SystemTypes::where('sys_id', $id)->with(['SystemDataFields' => function($query)
135
-        {
134
+        $system = SystemTypes::where('sys_id', $id)->with(['SystemDataFields' => function($query) {
136 135
             $query->join('system_data_field_types', 'system_data_fields.data_type_id', '=', 'system_data_field_types.data_type_id');
137 136
         }])->withCount('SystemDataFields')->first();
138 137
 
@@ -212,7 +211,8 @@  discard block
 block discarded – undo
212 211
    public function destroy($id)
213 212
    {
214 213
        //
215
-       try {
214
+       try
215
+       {
216 216
             SystemTypes::find($id)->delete();
217 217
             return response()->json(['success' => true, 'reason' => 'Equipment Successfully Deleted']);
218 218
         }
Please login to merge, or discard this patch.
app/Http/Controllers/Installer/SettingsController.php 2 patches
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -39,14 +39,14 @@  discard block
 block discarded – undo
39 39
 
40 40
         Settings::firstOrCreate(
41 41
             ['key'   => 'app.logo'],
42
-            ['key'   => 'app.logo', 'value' => '/storage/img/' . $fileName]
43
-        )->update(['value' => '/storage/img/' . $fileName]);
42
+            ['key'   => 'app.logo', 'value' => '/storage/img/'.$fileName]
43
+        )->update(['value' => '/storage/img/'.$fileName]);
44 44
 
45
-        Log::debug('Route ' . Route::currentRouteName() . ' visited by User ID-' . Auth::user()->user_id);
45
+        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
46 46
         Log::debug('Submitted Data - ', $request->toArray());
47
-        Log::notice('A new company logo has been uploaded by User ID-' . Auth::user()->user_id);
47
+        Log::notice('A new company logo has been uploaded by User ID-'.Auth::user()->user_id);
48 48
 
49
-        return response()->json(['url' => '/storage/img/' . $fileName]);
49
+        return response()->json(['url' => '/storage/img/'.$fileName]);
50 50
     }
51 51
 
52 52
     public function configuration()
@@ -81,14 +81,14 @@  discard block
 block discarded – undo
81 81
             )->update(['value' => $request->url]);
82 82
         }
83 83
         //  Update the site timezone
84
-        if (config('app.timezone') !== $request->timezone) {
84
+        if(config('app.timezone') !== $request->timezone) {
85 85
             Settings::firstOrCreate(
86 86
                 ['key'   => 'app.timezone'],
87 87
                 ['key'   => 'app.timezone', 'value' => $request->timezone]
88 88
             )->update(['value' => $request->timezone]);
89 89
         }
90 90
         //  Update the maximum file upload size
91
-        if (config('filesystems.paths.max_size') !== $request->filesize) {
91
+        if(config('filesystems.paths.max_size') !== $request->filesize) {
92 92
             Settings::firstOrCreate(
93 93
                 ['key'   => 'filesystems.paths.max_size'],
94 94
                 ['key'   => 'filesystems.paths.max_size', 'value' => $request->filesize]
Please login to merge, or discard this patch.
Braces   +4 added lines, -2 removed lines patch added patch discarded remove patch
@@ -81,14 +81,16 @@
 block discarded – undo
81 81
             )->update(['value' => $request->url]);
82 82
         }
83 83
         //  Update the site timezone
84
-        if (config('app.timezone') !== $request->timezone) {
84
+        if (config('app.timezone') !== $request->timezone)
85
+        {
85 86
             Settings::firstOrCreate(
86 87
                 ['key'   => 'app.timezone'],
87 88
                 ['key'   => 'app.timezone', 'value' => $request->timezone]
88 89
             )->update(['value' => $request->timezone]);
89 90
         }
90 91
         //  Update the maximum file upload size
91
-        if (config('filesystems.paths.max_size') !== $request->filesize) {
92
+        if (config('filesystems.paths.max_size') !== $request->filesize)
93
+        {
92 94
             Settings::firstOrCreate(
93 95
                 ['key'   => 'filesystems.paths.max_size'],
94 96
                 ['key'   => 'filesystems.paths.max_size', 'value' => $request->filesize]
Please login to merge, or discard this patch.
app/Http/Middleware/CheckPasswordExpire.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -25,7 +25,7 @@
 block discarded – undo
25 25
             if(Auth::user()->password_expires !== null)
26 26
             {
27 27
                 $passExp = new Carbon((Auth::user()->password_expires));
28
-                if(Carbon::now() > $passExp )
28
+                if(Carbon::now() > $passExp)
29 29
                 {
30 30
                     Log::notice('User ID-'.Auth::user()->user_id.' is being forced to change their password.');
31 31
                     $request->session()->flash('change_password', 'change_password');
Please login to merge, or discard this patch.
app/Http/Controllers/Admin/AdminController.php 2 patches
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
     //  Show the links for the selected user
56 56
     public function showLinks($id)
57 57
     {
58
-        $user     = User::find($id);
58
+        $user = User::find($id);
59 59
 
60 60
         Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
61 61
         return view('admin.linkDetails', [
@@ -88,7 +88,7 @@  discard block
 block discarded – undo
88 88
         )->update(['value' => $request->passExpire]);
89 89
 
90 90
         //  If the setting is changing from never to xx days, update all users
91
-        if ($request->passExpire == 0) {
91
+        if($request->passExpire == 0) {
92 92
             User::whereNotNull('password_expires')->update([
93 93
                 'password_expires' => null
94 94
             ]);
@@ -101,9 +101,9 @@  discard block
 block discarded – undo
101 101
             ]);
102 102
         }
103 103
 
104
-        Log::debug('Route ' . Route::currentRouteName() . ' visited by User ID-' . Auth::user()->user_id);
104
+        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
105 105
         Log::debug('Submitted Data - ', $request->toArray());
106
-        Log::notice('User Settings have been changed by User ID-' . Auth::user()->user_id);
106
+        Log::notice('User Settings have been changed by User ID-'.Auth::user()->user_id);
107 107
         return redirect()->back()->with('success', 'User Security Updated');
108 108
     }
109 109
 
@@ -162,7 +162,7 @@  discard block
 block discarded – undo
162 162
             'name'        => $request->name,
163 163
             'description' => $request->description,
164 164
         ]);
165
-        foreach ($request->permissions as $perm)
165
+        foreach($request->permissions as $perm)
166 166
         {
167 167
             UserRolePermissions::create([
168 168
                 'role_id'      => $role->role_id,
Please login to merge, or discard this patch.
Braces   +4 added lines, -5 removed lines patch added patch discarded remove patch
@@ -37,8 +37,7 @@  discard block
 block discarded – undo
37 37
         $userLinks = new UserCollection(
38 38
                         User::withCount([
39 39
                                 'FileLinks',
40
-                                'FileLinks as expired_file_links_count' => function($query)
41
-                                {
40
+                                'FileLinks as expired_file_links_count' => function($query) {
42 41
                                     $query->where('expire', '<', Carbon::now());
43 42
                                 }
44 43
                             ])
@@ -88,7 +87,8 @@  discard block
 block discarded – undo
88 87
         )->update(['value' => $request->passExpire]);
89 88
 
90 89
         //  If the setting is changing from never to xx days, update all users
91
-        if ($request->passExpire == 0) {
90
+        if ($request->passExpire == 0)
91
+        {
92 92
             User::whereNotNull('password_expires')->update([
93 93
                 'password_expires' => null
94 94
             ]);
@@ -110,8 +110,7 @@  discard block
 block discarded – undo
110 110
     public function roleSettings()
111 111
     {
112 112
         $this->authorize('hasAccess', 'Manage User Roles');
113
-        $roles = UserRoleType::with(['UserRolePermissions' => function($query)
114
-        {
113
+        $roles = UserRoleType::with(['UserRolePermissions' => function($query) {
115 114
             $query->join('user_role_permission_types', 'user_role_permission_types.perm_type_id', '=', 'user_role_permissions.perm_type_id');
116 115
         }])->get();
117 116
         $perms = UserRolePermissionTypes::all();
Please login to merge, or discard this patch.
app/Http/Controllers/Customers/CustomerDetailsController.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -73,7 +73,7 @@  discard block
 block discarded – undo
73 73
         Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
74 74
         Log::notice('New Customer ID-'.$request->custID.' created by User ID-'.Auth::user()->user_id);
75 75
 
76
-        return response()->json(['success' => true, 'cust_id' => $custData->cust_id ]);
76
+        return response()->json(['success' => true, 'cust_id' => $custData->cust_id]);
77 77
     }
78 78
 
79 79
     //  Show the customer details
@@ -142,7 +142,7 @@  discard block
 block discarded – undo
142 142
 
143 143
         $parentsParent = Customers::find($request->parent_id);
144 144
 
145
-        if ($parentsParent->parent_id)
145
+        if($parentsParent->parent_id)
146 146
         {
147 147
             $request->parent_id = $parentsParent->parent_id;
148 148
         }
Please login to merge, or discard this patch.
app/Http/Controllers/Customers/CustomerContactsController.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -70,7 +70,7 @@
 block discarded – undo
70 70
 
71 71
         //  Determine if there is a parent site with shared contacts
72 72
         $parent = Customers::find($id)->parent_id;
73
-        if ($parent)
73
+        if($parent)
74 74
         {
75 75
             $parentList = CustomerContacts::where('cust_id', $parent)
76 76
                 ->where('shared', 1)
Please login to merge, or discard this patch.
app/Http/Controllers/Customers/CustomerNotesController.php 2 patches
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -29,7 +29,7 @@  discard block
 block discarded – undo
29 29
 
30 30
         //  Determine if the note should go to the customer, or its parent
31 31
         $details = Customers::find($request->cust_id);
32
-        if ($details->parent_id && $request->shared) {
32
+        if($details->parent_id && $request->shared) {
33 33
             $request->cust_id = $details->parent_id;
34 34
         }
35 35
 
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
 
56 56
         //  Determine if there is a parent site with shared contacts
57 57
         $parent = Customers::find($id)->parent_id;
58
-        if ($parent) {
58
+        if($parent) {
59 59
             $parentList = CustomerNotes::where('cust_id', $parent)->orderBy('urgent', 'desc')->get();
60 60
 
61 61
             $notes = $notes->merge($parentList);
Please login to merge, or discard this patch.
Braces   +4 added lines, -2 removed lines patch added patch discarded remove patch
@@ -29,7 +29,8 @@  discard block
 block discarded – undo
29 29
 
30 30
         //  Determine if the note should go to the customer, or its parent
31 31
         $details = Customers::find($request->cust_id);
32
-        if ($details->parent_id && $request->shared) {
32
+        if ($details->parent_id && $request->shared)
33
+        {
33 34
             $request->cust_id = $details->parent_id;
34 35
         }
35 36
 
@@ -55,7 +56,8 @@  discard block
 block discarded – undo
55 56
 
56 57
         //  Determine if there is a parent site with shared contacts
57 58
         $parent = Customers::find($id)->parent_id;
58
-        if ($parent) {
59
+        if ($parent)
60
+        {
59 61
             $parentList = CustomerNotes::where('cust_id', $parent)->orderBy('urgent', 'desc')->get();
60 62
 
61 63
             $notes = $notes->merge($parentList);
Please login to merge, or discard this patch.
app/Http/Controllers/Customers/CustomerFilesController.php 2 patches
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -36,7 +36,7 @@  discard block
 block discarded – undo
36 36
         //  Verify that the upload is valid and being processed
37 37
         if($receiver->isUploaded() === false)
38 38
         {
39
-            Log::error('Upload File Missing - ' .
39
+            Log::error('Upload File Missing - '.
40 40
             /** @scrutinizer ignore-type */
41 41
             $request->toArray());
42 42
             throw new UploadMissingFileException();
@@ -50,7 +50,7 @@  discard block
 block discarded – undo
50 50
         {
51 51
             //  Determine if the note should go to the customer, or its parent
52 52
             $details = Customers::find($request->cust_id);
53
-            if ($details->parent_id && $request->shared)
53
+            if($details->parent_id && $request->shared)
54 54
             {
55 55
                 $request->cust_id = $details->parent_id;
56 56
             }
@@ -110,7 +110,7 @@  discard block
 block discarded – undo
110 110
 
111 111
         //  Determine if there is a parent site with shared files
112 112
         $parent = Customers::find($id)->parent_id;
113
-        if ($parent) {
113
+        if($parent) {
114 114
             $parentList = Customerfiles::where('cust_id', $parent)
115 115
                 ->with('Files')
116 116
                 ->with('CustomerFileTypes')
Please login to merge, or discard this patch.
Braces   +2 added lines, -1 removed lines patch added patch discarded remove patch
@@ -110,7 +110,8 @@
 block discarded – undo
110 110
 
111 111
         //  Determine if there is a parent site with shared files
112 112
         $parent = Customers::find($id)->parent_id;
113
-        if ($parent) {
113
+        if ($parent)
114
+        {
114 115
             $parentList = Customerfiles::where('cust_id', $parent)
115 116
                 ->with('Files')
116 117
                 ->with('CustomerFileTypes')
Please login to merge, or discard this patch.
database/migrations/2019_11_30_215206_updates_for_version_5_0.php 2 patches
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -66,8 +66,8 @@  discard block
 block discarded – undo
66 66
     private function updatePhoneIcons()
67 67
     {
68 68
         $newIcons = [
69
-            ['description' => 'Home',   'icon_class' => 'fas fa-home'],
70
-            ['description' => 'Work',   'icon_class' => 'fas fa-briefcase'],
69
+            ['description' => 'Home', 'icon_class' => 'fas fa-home'],
70
+            ['description' => 'Work', 'icon_class' => 'fas fa-briefcase'],
71 71
             ['description' => 'Mobile', 'icon_class' => 'fas fa-mobile-alt'],
72 72
         ];
73 73
 
@@ -99,7 +99,7 @@  discard block
 block discarded – undo
99 99
         {
100 100
             if(!Schema::hasColumn('users', 'role_id'))
101 101
             {
102
-                Schema::table('users', function (Blueprint $table) {
102
+                Schema::table('users', function(Blueprint $table) {
103 103
                     $table->integer('role_id')->after('user_id')->unsigned()->default(4);
104 104
                     $table->foreign('role_id')->references('role_id')->on('user_role_descriptions')->onUpdate('cascade');
105 105
                 });
@@ -326,8 +326,8 @@  discard block
 block discarded – undo
326 326
     //  Add soft deletes to tech tips table to prevent accidental deletes
327 327
     private function addSoftDeleteToTechTips()
328 328
     {
329
-        if (!Schema::hasColumn('tech_tips', 'deleted_at')) {
330
-            Schema::table('tech_tips', function (Blueprint $table) {
329
+        if(!Schema::hasColumn('tech_tips', 'deleted_at')) {
330
+            Schema::table('tech_tips', function(Blueprint $table) {
331 331
                 $table->softDeletes()->after('description');
332 332
             });
333 333
         }
@@ -345,7 +345,7 @@  discard block
 block discarded – undo
345 345
             //  Migrate over all deactivated users
346 346
             DB::update('UPDATE `users` SET `deleted_at` = "'.Carbon::now().'" WHERE `active` = 0');
347 347
             //  Remove the Active column
348
-            Schema::table('users', function (Blueprint $table) {
348
+            Schema::table('users', function(Blueprint $table) {
349 349
                 $table->dropColumn('active');
350 350
             });
351 351
         }
@@ -364,27 +364,27 @@  discard block
 block discarded – undo
364 364
         }
365 365
         if(!Schema::hasColumn('customer_systems', 'shared'))
366 366
         {
367
-            Schema::table('customer_systems', function (Blueprint $table)
367
+            Schema::table('customer_systems', function(Blueprint $table)
368 368
             {
369 369
                 $table->boolean('shared')->default(0)->after('sys_id');
370 370
             });
371 371
         }
372
-        if (!Schema::hasColumn('customer_contacts', 'shared'))
372
+        if(!Schema::hasColumn('customer_contacts', 'shared'))
373 373
         {
374
-            Schema::table('customer_contacts', function (Blueprint $table)
374
+            Schema::table('customer_contacts', function(Blueprint $table)
375 375
             {
376 376
                 $table->boolean('shared')->default(0)->after('cust_id');
377 377
             });
378 378
         }
379
-        if (!Schema::hasColumn('customer_notes', 'shared'))
379
+        if(!Schema::hasColumn('customer_notes', 'shared'))
380 380
         {
381
-            Schema::table('customer_notes', function (Blueprint $table)
381
+            Schema::table('customer_notes', function(Blueprint $table)
382 382
             {
383 383
                 $table->boolean('shared')->default(0)->after('user_id');
384 384
             });
385 385
         }
386
-        if (!Schema::hasColumn('customer_files', 'shared')) {
387
-            Schema::table('customer_files', function (Blueprint $table) {
386
+        if(!Schema::hasColumn('customer_files', 'shared')) {
387
+            Schema::table('customer_files', function(Blueprint $table) {
388 388
                 $table->boolean('shared')->default(0)->after('user_id');
389 389
             });
390 390
         }
Please login to merge, or discard this patch.
Braces   +29 added lines, -22 removed lines patch added patch discarded remove patch
@@ -83,7 +83,8 @@  discard block
 block discarded – undo
83 83
     //  Added the ability to set an expiration date for user passwords - will force them to change after this expires
84 84
     private function addPasswordExpiresColumn()
85 85
     {
86
-        if(!Schema::hasColumn('users', 'password_expires')) {
86
+        if(!Schema::hasColumn('users', 'password_expires'))
87
+        {
87 88
             Schema::table('users', function(Blueprint $table) {
88 89
                 $table->timestamp('password_expires')
89 90
                     ->nullable()
@@ -119,7 +120,8 @@  discard block
 block discarded – undo
119 120
     //  Added a 'hidden' attribute to system customer data types to allow passwords to not be viewed unless clicked or focus
120 121
     private function addHiddenColumn()
121 122
     {
122
-        if(!Schema::hasColumn('system_data_field_types', 'hidden')) {
123
+        if(!Schema::hasColumn('system_data_field_types', 'hidden'))
124
+        {
123 125
             Schema::table('system_cust_data_types', function(Blueprint $table) {
124 126
                 $table->boolean('hidden')
125 127
                     ->default(0)
@@ -131,7 +133,8 @@  discard block
 block discarded – undo
131 133
     //  Update the File links table - add cust_id and note column
132 134
     private function addColumnsToFileLinksTable()
133 135
     {
134
-        if(!Schema::hasColumn('file_links', 'cust_id')) {
136
+        if(!Schema::hasColumn('file_links', 'cust_id'))
137
+        {
135 138
             Schema::table('file_links', function(Blueprint $table) {
136 139
                 $table->integer('cust_id')
137 140
                     ->unsigned()
@@ -140,7 +143,8 @@  discard block
 block discarded – undo
140 143
                 $table->foreign('cust_id')->references('cust_id')->on('customers')->onUpdate('cascade')->onDelete('cascade');
141 144
             });
142 145
         }
143
-        if(!Schema::hasColumn('file_links', 'note')) {
146
+        if(!Schema::hasColumn('file_links', 'note'))
147
+        {
144 148
             Schema::table('file_links', function(Blueprint $table) {
145 149
                 $table->longText('note')
146 150
                     ->nullable()
@@ -148,7 +152,8 @@  discard block
 block discarded – undo
148 152
             });
149 153
             //  Migrate the instructions from the old table to the new column
150 154
             $instructions = DB::select('SELECT * FROM `file_link_instructions`');
151
-            foreach($instructions as $ins) {
155
+            foreach($instructions as $ins)
156
+            {
152 157
                 FileLinks::find($ins->link_id)->update([
153 158
                     'note' => $ins->instruction
154 159
                 ]);
@@ -159,7 +164,8 @@  discard block
 block discarded – undo
159 164
     //  Add Notes column to the file links files table
160 165
     private function addNotesColumnToFileLinkFiles()
161 166
     {
162
-        if(!Schema::hasColumn('file_link_files', 'note')) {
167
+        if(!Schema::hasColumn('file_link_files', 'note'))
168
+        {
163 169
             Schema::table('file_link_files', function(Blueprint $table) {
164 170
                 $table->longText('note')
165 171
                     ->nullable()
@@ -167,7 +173,8 @@  discard block
 block discarded – undo
167 173
             });
168 174
             //  Migrate the existing notes to the new table
169 175
             $notes = DB::select('SELECT * FROM `file_link_notes`');
170
-            foreach($notes as $note) {
176
+            foreach($notes as $note)
177
+            {
171 178
                 FileLinkFiles::where('file_id', $note->file_id)->update([
172 179
                     'note' => $note->note
173 180
                 ]);
@@ -178,7 +185,8 @@  discard block
 block discarded – undo
178 185
     //  Add the documentation column to the tech tips table
179 186
     private function migrateSystemDocumentation()
180 187
     {
181
-        if(!Schema::hasColumn('tech_tips', 'tip_type_id')) {
188
+        if(!Schema::hasColumn('tech_tips', 'tip_type_id'))
189
+        {
182 190
             Schema::table('tech_tips', function(Blueprint $table) {
183 191
                 $table->bigInteger('tip_type_id')->unsigned()->after('public')->default(1);
184 192
                 $table->foreign('tip_type_id')->references('tip_type_id')->on('tech_tip_types')->onUpdate('cascade');
@@ -186,7 +194,8 @@  discard block
 block discarded – undo
186 194
 
187 195
             //  Move all of the system files over to the tech tips table
188 196
             $sysFiles = DB::select('SELECT * FROM `system_files`');
189
-            foreach($sysFiles as $sysFile) {
197
+            foreach($sysFiles as $sysFile)
198
+            {
190 199
                 $newTip = TechTips::create([
191 200
                     'user_id'       => $sysFile->user_id,
192 201
                     'public'        => 0,
@@ -280,7 +289,8 @@  discard block
 block discarded – undo
280 289
     //  Remove the system files and system file types table
281 290
     private function removeSystemFilesTables()
282 291
     {
283
-        if(Schema::hasTable('system_files')) {
292
+        if(Schema::hasTable('system_files'))
293
+        {
284 294
             Schema::table('system_files', function(Blueprint $table) {
285 295
                 $table->dropForeign(['sys_id']);
286 296
                 $table->dropForeign(['type_id']);
@@ -326,7 +336,8 @@  discard block
 block discarded – undo
326 336
     //  Add soft deletes to tech tips table to prevent accidental deletes
327 337
     private function addSoftDeleteToTechTips()
328 338
     {
329
-        if (!Schema::hasColumn('tech_tips', 'deleted_at')) {
339
+        if (!Schema::hasColumn('tech_tips', 'deleted_at'))
340
+        {
330 341
             Schema::table('tech_tips', function (Blueprint $table) {
331 342
                 $table->softDeletes()->after('description');
332 343
             });
@@ -338,8 +349,7 @@  discard block
 block discarded – undo
338 349
     {
339 350
         if(!Schema::hasColumn('users', 'deleted_at'))
340 351
         {
341
-            Schema::table('users', function(Blueprint $table)
342
-            {
352
+            Schema::table('users', function(Blueprint $table) {
343 353
                 $table->softDeletes()->after('password_expires');
344 354
             });
345 355
             //  Migrate over all deactivated users
@@ -356,34 +366,31 @@  discard block
 block discarded – undo
356 366
     {
357 367
         if(!Schema::hasColumn('customers', 'parent_id'))
358 368
         {
359
-            Schema::table('customers', function(Blueprint $table)
360
-            {
369
+            Schema::table('customers', function(Blueprint $table) {
361 370
                 $table->integer('parent_id')->after('cust_id')->nullable()->unsigned();
362 371
                 $table->foreign('parent_id')->references('cust_id')->on('customers')->onUpdate('cascade');
363 372
             });
364 373
         }
365 374
         if(!Schema::hasColumn('customer_systems', 'shared'))
366 375
         {
367
-            Schema::table('customer_systems', function (Blueprint $table)
368
-            {
376
+            Schema::table('customer_systems', function (Blueprint $table) {
369 377
                 $table->boolean('shared')->default(0)->after('sys_id');
370 378
             });
371 379
         }
372 380
         if (!Schema::hasColumn('customer_contacts', 'shared'))
373 381
         {
374
-            Schema::table('customer_contacts', function (Blueprint $table)
375
-            {
382
+            Schema::table('customer_contacts', function (Blueprint $table) {
376 383
                 $table->boolean('shared')->default(0)->after('cust_id');
377 384
             });
378 385
         }
379 386
         if (!Schema::hasColumn('customer_notes', 'shared'))
380 387
         {
381
-            Schema::table('customer_notes', function (Blueprint $table)
382
-            {
388
+            Schema::table('customer_notes', function (Blueprint $table) {
383 389
                 $table->boolean('shared')->default(0)->after('user_id');
384 390
             });
385 391
         }
386
-        if (!Schema::hasColumn('customer_files', 'shared')) {
392
+        if (!Schema::hasColumn('customer_files', 'shared'))
393
+        {
387 394
             Schema::table('customer_files', function (Blueprint $table) {
388 395
                 $table->boolean('shared')->default(0)->after('user_id');
389 396
             });
Please login to merge, or discard this patch.