1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace App\Http\Controllers\Customers; |
4
|
|
|
|
5
|
|
|
use App\Customers; |
6
|
|
|
use App\CustomerFavs; |
7
|
|
|
use App\PhoneNumberType; |
8
|
|
|
use App\CustomerFileTypes; |
9
|
|
|
use Illuminate\Http\Request; |
10
|
|
|
use App\Http\Traits\SystemsTrait; |
11
|
|
|
use Illuminate\Support\Facades\Log; |
12
|
|
|
use Illuminate\Support\Facades\Auth; |
13
|
|
|
use App\Http\Controllers\Controller; |
14
|
|
|
use Illuminate\Support\Facades\Route; |
15
|
|
|
|
16
|
|
|
class CustomerDetailsController extends Controller |
17
|
|
|
{ |
18
|
|
|
use SystemsTrait; |
|
|
|
|
19
|
|
|
|
20
|
14 |
|
public function __construct() |
21
|
|
|
{ |
22
|
14 |
|
$this->middleware('auth'); |
23
|
14 |
|
} |
24
|
|
|
|
25
|
|
|
// New Customer Form |
26
|
4 |
|
public function create() |
27
|
|
|
{ |
28
|
4 |
|
$this->authorize('hasAccess', 'add_customer'); |
29
|
|
|
|
30
|
2 |
|
Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id); |
31
|
2 |
|
return view('customer.newCustomer'); |
32
|
|
|
} |
33
|
|
|
|
34
|
|
|
// Submit the new customer form |
35
|
6 |
|
public function store(Request $request) |
36
|
|
|
{ |
37
|
6 |
|
$this->authorize('hasAccess', 'add_customer'); |
38
|
|
|
|
39
|
4 |
|
$request->validate([ |
40
|
4 |
|
'cust_id' => 'required|numeric|unique:customers,cust_id', |
41
|
|
|
'name' => 'required', // |unique:customers,name', |
42
|
|
|
'dba_name' => 'nullable', |
43
|
|
|
'address' => 'required', |
44
|
|
|
'city' => 'required', |
45
|
|
|
'zip' => 'required|numeric' |
46
|
|
|
]); |
47
|
|
|
|
48
|
|
|
// Remove any forward slash (/) from the Customer name field |
49
|
2 |
|
$request->merge(['name' => str_replace('/', '-', $request->name)]); |
50
|
|
|
|
51
|
2 |
|
Customers::create([ |
52
|
2 |
|
'cust_id' => $request->cust_id, |
53
|
2 |
|
'name' => $request->name, |
54
|
2 |
|
'dba_name' => $request->dba_name, |
55
|
2 |
|
'address' => $request->address, |
56
|
2 |
|
'city' => $request->city, |
57
|
2 |
|
'state' => $request->selectedState, |
58
|
2 |
|
'zip' => $request->zip, |
59
|
|
|
]); |
60
|
|
|
|
61
|
2 |
|
Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id); |
62
|
2 |
|
Log::notice('New Customer ID-'.$request->custID.' created by User ID-'.Auth::user()->user_id); |
63
|
|
|
|
64
|
2 |
|
return response()->json(['success' => true ]); |
65
|
|
|
} |
66
|
|
|
|
67
|
|
|
|
68
|
|
|
|
69
|
|
|
|
70
|
|
|
|
71
|
|
|
|
72
|
|
|
|
73
|
|
|
// Show the customer details |
74
|
|
|
public function details($id, $name) |
|
|
|
|
75
|
|
|
{ |
76
|
|
|
echo 'customer details'; |
77
|
|
|
die(); |
|
|
|
|
78
|
|
|
|
79
|
|
|
|
80
|
|
|
$custDetails = Customers::find($id); |
|
|
|
|
81
|
|
|
$allSystems = $this->getAllSystems(); |
82
|
|
|
|
83
|
|
|
Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id); |
84
|
|
|
if(empty($custDetails)) |
85
|
|
|
{ |
86
|
|
|
Log::info('User ID-'.Auth::user()->user_id.' visited invalid customer ID-'.$id.'-'.$name); |
87
|
|
|
return view('err.customerNotFound'); |
88
|
|
|
} |
89
|
|
|
|
90
|
|
|
// Determine if the customer is one of the users bookmarks |
91
|
|
|
$custFav = CustomerFavs::where('user_id', Auth::user()->user_id)->where('cust_id', $custDetails->cust_id)->first(); |
92
|
|
|
// Get the types of phone numbers that can be assigned to a customer contact |
93
|
|
|
$pTypes = PhoneNumberType::all(); |
94
|
|
|
$phoneTypes = []; |
95
|
|
|
foreach($pTypes as $type) |
96
|
|
|
{ |
97
|
|
|
$phoneTypes[] = [ |
98
|
|
|
'value' => $type->phone_type_id, |
99
|
|
|
'text' => $type->description, |
100
|
|
|
'icon' => $type->icon_class |
101
|
|
|
]; |
102
|
|
|
} |
103
|
|
|
|
104
|
|
|
// Get the types of files that can be attached to a file |
105
|
|
|
$fileTypes = CustomerFileTypes::select('file_type_id as value', 'description as text')->get(); |
106
|
|
|
|
107
|
|
|
Log::debug('Customer Details', $custDetails->toArray()); |
108
|
|
|
return view('customer.details', [ |
109
|
|
|
'details' => $custDetails, |
110
|
|
|
'isFav' => empty($custFav) ? false : true, |
111
|
|
|
'sysList' => $allSystems, |
112
|
|
|
'phoneTypes' => $phoneTypes, |
113
|
|
|
'fileTypes' => $fileTypes |
114
|
|
|
]); |
115
|
|
|
} |
116
|
|
|
|
117
|
|
|
// Get the basic details of the customer |
118
|
|
|
public function show($id) |
119
|
|
|
{ |
120
|
|
|
$details = Customers::find($id); |
121
|
|
|
|
122
|
|
|
Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id); |
123
|
|
|
if(empty($details)) |
124
|
|
|
{ |
125
|
|
|
Log::info('User ID-'.Auth::user()->user_id.' visited invalid customer ID-'.$id); |
126
|
|
|
return response()->json(['error' => 'Customer Not Found']); |
127
|
|
|
} |
128
|
|
|
|
129
|
|
|
Log::debug('Customer Details', $details->toArray()); |
130
|
|
|
return response()->json($details); |
131
|
|
|
} |
132
|
|
|
|
133
|
|
|
// Update the customer details |
134
|
|
|
public function update(Request $request, $id) |
135
|
|
|
{ |
136
|
|
|
$request->validate([ |
137
|
|
|
'name' => 'required', |
138
|
|
|
'dba_name' => 'nullable', |
139
|
|
|
'address' => 'required', |
140
|
|
|
'city' => 'required', |
141
|
|
|
'state' => 'required', |
142
|
|
|
'zip' => 'required|numeric' |
143
|
|
|
]); |
144
|
|
|
|
145
|
|
|
Customers::find($id)->update([ |
146
|
|
|
'name' => $request->name, |
147
|
|
|
'dba_name' => $request->dba_name, |
148
|
|
|
'address' => $request->address, |
149
|
|
|
'city' => $request->city, |
150
|
|
|
'state' => $request->state, |
151
|
|
|
'zip' => $request->zip |
152
|
|
|
]); |
153
|
|
|
|
154
|
|
|
Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id); |
155
|
|
|
Log::notice('Customer Details Updated for Customer ID-'.$id.' by User ID-'.Auth::user()->user_id); |
156
|
|
|
Log::debug('Customer Details Submitted - ', $request->toArray()); |
157
|
|
|
return response()->json([ |
158
|
|
|
'success' => true |
159
|
|
|
]); |
160
|
|
|
} |
161
|
|
|
|
162
|
|
|
/** |
163
|
|
|
* Remove the specified resource from storage. |
164
|
|
|
* |
165
|
|
|
* @param int $id |
166
|
|
|
* @return \Illuminate\Http\Response |
167
|
|
|
*/ |
168
|
|
|
public function destroy($id) |
|
|
|
|
169
|
|
|
{ |
170
|
|
|
// |
171
|
|
|
} |
172
|
|
|
} |
173
|
|
|
|