@@ -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) |