@@ -25,7 +25,7 @@ |
||
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'); |
@@ -55,7 +55,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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, |
@@ -37,8 +37,7 @@ discard block |
||
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 |
||
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 |
||
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(); |
@@ -73,7 +73,7 @@ discard block |
||
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 |
||
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 | } |
@@ -70,7 +70,7 @@ |
||
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) |
@@ -29,7 +29,7 @@ discard block |
||
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 |
||
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); |
@@ -29,7 +29,8 @@ discard block |
||
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 |
||
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); |
@@ -36,7 +36,7 @@ discard block |
||
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 |
||
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 |
||
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') |
@@ -110,7 +110,8 @@ |
||
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') |
@@ -66,8 +66,8 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -83,7 +83,8 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | }); |
@@ -88,7 +88,7 @@ |
||
88 | 88 | $this->bar->advance(); |
89 | 89 | $fileParts = pathinfo($this->argument('filename')); |
90 | 90 | $this->baseName = $fileParts['filename']; |
91 | - $this->archive = Zip::open(config('filesystems.disks.backup.root') . DIRECTORY_SEPARATOR.$this->argument('filename')); |
|
91 | + $this->archive = Zip::open(config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.$this->argument('filename')); |
|
92 | 92 | // if (!$this->archive->has('version.txt')) { |
93 | 93 | // $this->error('THIS IS NOT A VALID TECH BENCH BACKUP'); |
94 | 94 | // $this->error('Exiting'); |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | // Create the archive and place the version file in it |
84 | 84 | $this->zip = Zip::create(config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.$backupName); |
85 | 85 | $this->bar->advance(); |
86 | - $this->zip->add(config('filesystems.disks.backup.root') . DIRECTORY_SEPARATOR . 'version.txt'); |
|
86 | + $this->zip->add(config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.'version.txt'); |
|
87 | 87 | $this->bar->advance(); |
88 | 88 | $this->zip->add(base_path().DIRECTORY_SEPARATOR.'.env'); |
89 | 89 | $this->bar->advance(); |
@@ -115,9 +115,9 @@ discard block |
||
115 | 115 | $process = new Process('mysqldump tb-dev5-data -u root'); |
116 | 116 | $process->run(); |
117 | 117 | |
118 | - File::put(config('filesystems.disks.backup.root') . DIRECTORY_SEPARATOR . 'database.sql', $process->getOutput()); |
|
118 | + File::put(config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.'database.sql', $process->getOutput()); |
|
119 | 119 | $this->bar->advance(); |
120 | - $this->zip->add(config('filesystems.disks.backup.root') . DIRECTORY_SEPARATOR . 'database.sql'); |
|
120 | + $this->zip->add(config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.'database.sql'); |
|
121 | 121 | $this->bar->advance(); |
122 | 122 | } |
123 | 123 |