@@ -8,7 +8,6 @@ |
||
8 | 8 | use App\Http\Requests\helpdesk\BanlistRequest; |
9 | 9 | use App\Http\Requests\helpdesk\BanRequest; |
10 | 10 | // model |
11 | -use App\Model\helpdesk\Email\Banlist; |
|
12 | 11 | use App\User; |
13 | 12 | //classes |
14 | 13 | use Exception; |
@@ -14,7 +14,6 @@ |
||
14 | 14 | use App\Model\helpdesk\Agent\Teams; |
15 | 15 | use App\Model\helpdesk\Email\Emails; |
16 | 16 | use App\Model\helpdesk\Email\Template; |
17 | -use App\Model\helpdesk\Manage\Help_topic; |
|
18 | 17 | use App\Model\helpdesk\Manage\Sla_plan; |
19 | 18 | use App\Model\helpdesk\Settings\System; |
20 | 19 | use App\Model\helpdesk\Ticket\Tickets; |
@@ -15,7 +15,6 @@ |
||
15 | 15 | use Exception; |
16 | 16 | // classes |
17 | 17 | use Illuminate\Http\Request; |
18 | -use Illuminate\Support\Facades\Input; |
|
19 | 18 | use Lang; |
20 | 19 | |
21 | 20 | /** |
@@ -7,7 +7,6 @@ |
||
7 | 7 | // requests |
8 | 8 | use App\Http\Controllers\Controller; |
9 | 9 | //supports |
10 | -use App\Http\Requests; |
|
11 | 10 | use Config; |
12 | 11 | //classes |
13 | 12 | use File; |
@@ -10,17 +10,14 @@ |
||
10 | 10 | use App\Http\Requests\helpdesk\PriorityRequest; |
11 | 11 | // models |
12 | 12 | use App\Model\helpdesk\Email\Emails; |
13 | -use App\Model\helpdesk\Manage\Help_topic; |
|
14 | 13 | use App\Model\helpdesk\Settings\CommonSettings; |
15 | 14 | use App\Model\helpdesk\Settings\Email; |
16 | 15 | use App\Model\helpdesk\Ticket\Ticket_Priority; |
17 | -use Auth; |
|
18 | 16 | use DB; |
19 | 17 | use Exception; |
20 | 18 | // classes |
21 | 19 | use Illuminate\Http\Request; |
22 | 20 | use Illuminate\support\Collection; |
23 | -use Input; |
|
24 | 21 | use Lang; |
25 | 22 | |
26 | 23 | /** |
@@ -47,7 +47,7 @@ |
||
47 | 47 | $user_status = CommonSettings::where('option_name', '=', 'user_priority')->first(); |
48 | 48 | // dd( $user_status); |
49 | 49 | |
50 | - return view('themes.default1.admin.helpdesk.manage.ticket_priority.index', compact('user_status')); |
|
50 | + return view('themes.default1.admin.helpdesk.manage.ticket_priority.index', compact('user_status')); |
|
51 | 51 | } |
52 | 52 | |
53 | 53 | /** |
@@ -8,9 +8,7 @@ |
||
8 | 8 | use App\Http\Requests\helpdesk\SecurityRequest; |
9 | 9 | use App\Model\helpdesk\Settings\Security; |
10 | 10 | // Request |
11 | -use Illuminate\Http\Request; |
|
12 | 11 | // Class |
13 | -use Input; |
|
14 | 12 | use Lang; |
15 | 13 | use Redirect; |
16 | 14 |
@@ -9,7 +9,6 @@ |
||
9 | 9 | use App\Http\Requests\helpdesk\CannedUpdateRequest; |
10 | 10 | // model |
11 | 11 | use App\Model\helpdesk\Agent_panel\Canned; |
12 | -use App\User; |
|
13 | 12 | // classes |
14 | 13 | use Exception; |
15 | 14 | use Lang; |
@@ -5,7 +5,6 @@ |
||
5 | 5 | // controllers |
6 | 6 | use App\Http\Controllers\Controller; |
7 | 7 | // models |
8 | -use App\User; |
|
9 | 8 | // classes |
10 | 9 | use Auth; |
11 | 10 | use DB; |
@@ -5,7 +5,6 @@ |
||
5 | 5 | use App\Http\Controllers\Agent\helpdesk\TicketController; |
6 | 6 | use App\Http\Controllers\Controller; |
7 | 7 | use App\Model\helpdesk\Filters\Filter; |
8 | -use App\Model\helpdesk\Filters\Label; |
|
9 | 8 | use App\Model\helpdesk\Ticket\Tickets; |
10 | 9 | use Auth; |
11 | 10 | use DB; |
@@ -35,10 +35,10 @@ discard block |
||
35 | 35 | $render = false; |
36 | 36 | if (is_array($labels) && count($labels) > 0) { |
37 | 37 | $table = $table |
38 | - ->leftJoin('filters as label', function ($join) { |
|
39 | - $join->on('tickets.id', '=', 'label.ticket_id') |
|
38 | + ->leftJoin('filters as label', function ($join) { |
|
39 | + $join->on('tickets.id', '=', 'label.ticket_id') |
|
40 | 40 | ->where('label.key', '=', 'label'); |
41 | - }) |
|
41 | + }) |
|
42 | 42 | ->whereIn('label.value', $labels); |
43 | 43 | } |
44 | 44 | if (is_array($tags) && count($tags) > 0) { |
@@ -104,9 +104,9 @@ discard block |
||
104 | 104 | }); |
105 | 105 | case '/ticket/myticket': |
106 | 106 | return $table |
107 | - ->leftJoin('ticket_status', function ($join) { |
|
108 | - $join->on('ticket_status.id', '=', 'tickets.status'); |
|
109 | - }) |
|
107 | + ->leftJoin('ticket_status', function ($join) { |
|
108 | + $join->on('ticket_status.id', '=', 'tickets.status'); |
|
109 | + }) |
|
110 | 110 | ->orWhere('tickets.assigned_to', '=', Auth::user()->id) |
111 | 111 | ->where('tickets.status', '=', 1); |
112 | 112 | case '/unassigned': |
@@ -116,9 +116,9 @@ discard block |
||
116 | 116 | } |
117 | 117 | |
118 | 118 | return $table |
119 | - ->leftJoin('ticket_status', function ($join) { |
|
120 | - $join->on('ticket_status.id', '=', 'tickets.status'); |
|
121 | - }) |
|
119 | + ->leftJoin('ticket_status', function ($join) { |
|
120 | + $join->on('ticket_status.id', '=', 'tickets.status'); |
|
121 | + }) |
|
122 | 122 | ->where('tickets.assigned_to', '=', null) |
123 | 123 | ->where('tickets.status', '=', 1); |
124 | 124 | case '/ticket/overdue': |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | $table = $table->where('tickets.dept_id', '=', $id); |
128 | 128 | } |
129 | 129 | |
130 | - return $table |
|
130 | + return $table |
|
131 | 131 | ->leftJoin('ticket_status', function ($join) { |
132 | 132 | $join->on('ticket_status.id', '=', 'tickets.status'); |
133 | 133 | }) |
@@ -181,9 +181,9 @@ discard block |
||
181 | 181 | } |
182 | 182 | |
183 | 183 | return $table |
184 | - ->leftJoin('ticket_status', function ($join) { |
|
185 | - $join->on('ticket_status.id', '=', 'tickets.status'); |
|
186 | - }) |
|
184 | + ->leftJoin('ticket_status', function ($join) { |
|
185 | + $join->on('ticket_status.id', '=', 'tickets.status'); |
|
186 | + }) |
|
187 | 187 | ->where('tickets.assigned_to', '>', 0) |
188 | 188 | ->where('tickets.status', '=', 1); |
189 | 189 | case '/ticket/open': |
@@ -193,9 +193,9 @@ discard block |
||
193 | 193 | } |
194 | 194 | |
195 | 195 | return $table |
196 | - ->leftJoin('ticket_status', function ($join) { |
|
197 | - $join->on('ticket_status.id', '=', 'tickets.status'); |
|
198 | - }) |
|
196 | + ->leftJoin('ticket_status', function ($join) { |
|
197 | + $join->on('ticket_status.id', '=', 'tickets.status'); |
|
198 | + }) |
|
199 | 199 | ->where('isanswered', '=', 0) |
200 | 200 | ->where('tickets.status', '=', 1); |
201 | 201 | case '/duetoday': |
@@ -204,7 +204,7 @@ discard block |
||
204 | 204 | $table = $table->where('tickets.dept_id', '=', $id); |
205 | 205 | } |
206 | 206 | |
207 | - return $table |
|
207 | + return $table |
|
208 | 208 | ->leftJoin('ticket_status', function ($join) { |
209 | 209 | $join->on('ticket_status.id', '=', 'tickets.status'); |
210 | 210 | }) |
@@ -326,8 +326,8 @@ discard block |
||
326 | 326 | $table = $this->table(); |
327 | 327 | if ($user->role == 'user') { |
328 | 328 | $table = $table->leftJoin('ticket_status', 'tickets.status', '=', 'ticket_status.id') |
329 | - ->where('tickets.user_id', '=', $user->id) |
|
330 | - ->where('ticket_status.name', $convert_to_array[3]); |
|
329 | + ->where('tickets.user_id', '=', $user->id) |
|
330 | + ->where('ticket_status.name', $convert_to_array[3]); |
|
331 | 331 | } else { |
332 | 332 | $table = $table->leftJoin('ticket_status', 'tickets.status', '=', 'ticket_status.id') |
333 | 333 | ->where('tickets.assigned_to', '=', $user->id) |