@@ -1,14 +1,14 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | 3 | $term = $_GET["term"]; |
4 | -$users = app\User::where('email', 'LIKE', '%' . $term . '%')->where('active', '=', 1)->where('role', '=', 'user')->get(); |
|
4 | +$users = app\User::where('email', 'LIKE', '%'.$term.'%')->where('active', '=', 1)->where('role', '=', 'user')->get(); |
|
5 | 5 | $json = array(); |
6 | 6 | |
7 | 7 | foreach ($users as $user) { |
8 | 8 | |
9 | 9 | $json[] = array( |
10 | 10 | 'value' => $user["email"], |
11 | - 'label' => 'Name: '.$user["first_name"] .' '.$user["last_name"].' | '.('Email: <'.$user["email"].'>'), |
|
11 | + 'label' => 'Name: '.$user["first_name"].' '.$user["last_name"].' | '.('Email: <'.$user["email"].'>'), |
|
12 | 12 | 'email' => $user["email"], |
13 | 13 | 'user_name' => $user["user_name"], |
14 | 14 | 'first_name' => $user["first_name"], |
@@ -225,7 +225,7 @@ |
||
225 | 225 | <label>{!! Lang::get('lang.priority') !!}:</label> |
226 | 226 | </div> |
227 | 227 | <div class="col-md-3"> |
228 | - <?php $Priority = App\Model\helpdesk\Ticket\Ticket_Priority::where('status','=',1)->get(); ?> |
|
228 | + <?php $Priority = App\Model\helpdesk\Ticket\Ticket_Priority::where('status', '=', 1)->get(); ?> |
|
229 | 229 | {!! Form::select('priority', ['Priority'=>$Priority->lists('priority_desc','priority_id')->toArray()],null,['class' => 'form-control select']) !!} |
230 | 230 | </div> |
231 | 231 |
@@ -3,20 +3,20 @@ |
||
3 | 3 | Lang::get('lang.status')=>$status->name, |
4 | 4 | Lang::get('lang.priority')=>$priority->priority_desc, |
5 | 5 | Lang::get('lang.department')=>$dept123->name, |
6 | - Lang::get('lang.email')=>str_limit($user->email,30), |
|
6 | + Lang::get('lang.email')=>str_limit($user->email, 30), |
|
7 | 7 | Lang::get('lang.source')=>$ticket_source, |
8 | 8 | Lang::get('lang.help_topic')=>$help_topic->topic, |
9 | - Lang::get('lang.last_message')=>str_limit($username,30), |
|
9 | + Lang::get('lang.last_message')=>str_limit($username, 30), |
|
10 | 10 | Lang::get('lang.organization') => $LastResponse->getOrgWithLink(), |
11 | 11 | ]; |
12 | 12 | |
13 | - if($user->ban > 0){ |
|
13 | + if ($user->ban > 0) { |
|
14 | 14 | array_push($array, [Lang::get('lang.this_ticket_is_under_banned_user')=>'']); |
15 | 15 | } |
16 | - if($user->phone_number !=null){ |
|
16 | + if ($user->phone_number != null) { |
|
17 | 17 | array_push($array, [Lang::get('lang.phone')=>$user->phone_number]); |
18 | 18 | } |
19 | - if($user->mobile !=null){ |
|
19 | + if ($user->mobile != null) { |
|
20 | 20 | array_push($array, [Lang::get('lang.mobile')=>$user->mobile]); |
21 | 21 | } |
22 | 22 | $collection = collect($array); |
@@ -83,13 +83,13 @@ |
||
83 | 83 | } |
84 | 84 | ?> |
85 | 85 | <?php |
86 | - if (Auth::user()->role == 'admin' || Auth::user()->role == 'agent') { |
|
86 | + if (Auth::user()->role == 'admin' || Auth::user()->role == 'agent') { |
|
87 | 87 | $todaytickets = count(App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereRaw('date(duedate) = ?', [date('Y-m-d')])->get()); |
88 | 88 | } else { |
89 | 89 | $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
90 | 90 | $todaytickets = count(App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereRaw('date(duedate) = ?', [date('Y-m-d')])->where('dept_id', '=', $dept->id)->get()); |
91 | 91 | } |
92 | - ?> |
|
92 | + ?> |
|
93 | 93 | <div class="col-md-2" style="width:20%;"> |
94 | 94 | <a href="{!! route('inbox.ticket') !!}"> |
95 | 95 | <div class="info-box"> |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id', '=', $overdue->sla)->first(); |
69 | 69 | |
70 | 70 | $ovadate = $overdue->created_at; |
71 | - $new_date = date_add($ovadate, date_interval_create_from_date_string($sla_plan->grace_period)) . '<br/><br/>'; |
|
71 | + $new_date = date_add($ovadate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
72 | 72 | if (date('Y-m-d H:i:s') > $new_date) { |
73 | 73 | $j++; |
74 | 74 | //$value[] = $overdue; |
@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | if (Auth::user()->role == 'admin' || Auth::user()->role == 'agent') { |
87 | 87 | $todaytickets = count(App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereRaw('date(duedate) = ?', [date('Y-m-d')])->get()); |
88 | 88 | } else { |
89 | - $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
|
89 | + $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
|
90 | 90 | $todaytickets = count(App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereRaw('date(duedate) = ?', [date('Y-m-d')])->where('dept_id', '=', $dept->id)->get()); |
91 | 91 | } |
92 | 92 | ?> |
@@ -176,9 +176,9 @@ discard block |
||
176 | 176 | $created_date = $start_date->created_at; |
177 | 177 | $created_date = explode(' ', $created_date); |
178 | 178 | $created_date = $created_date[0]; |
179 | - $start_date = date("m/d/Y", strtotime($created_date . ' -1 months')); |
|
179 | + $start_date = date("m/d/Y", strtotime($created_date.' -1 months')); |
|
180 | 180 | } else { |
181 | - $start_date = date("m/d/Y", strtotime(date("m/d/Y") . ' -1 months')); |
|
181 | + $start_date = date("m/d/Y", strtotime(date("m/d/Y").' -1 months')); |
|
182 | 182 | } |
183 | 183 | ?> |
184 | 184 | <script type="text/javascript"> |
@@ -94,13 +94,13 @@ |
||
94 | 94 | |
95 | 95 | <div class="col-md-2" style="width:20%;"> |
96 | 96 | <?php |
97 | - if (Auth::user()->role == 'admin') { |
|
97 | + if (Auth::user()->role == 'admin') { |
|
98 | 98 | $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate','=', \Carbon\Carbon::now()->format('Y-m-d'))->count(); |
99 | 99 | } else { |
100 | 100 | $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
101 | - $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate','=', \Carbon\Carbon::now()->format('Y-m-d'))->where('dept_id', '=', $dept->id)->count(); |
|
101 | + $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate','=', \Carbon\Carbon::now()->format('Y-m-d'))->where('dept_id', '=', $dept->id)->count(); |
|
102 | 102 | } |
103 | - ?> |
|
103 | + ?> |
|
104 | 104 | <a href="{!! route('ticket.duetoday') !!}"> |
105 | 105 | <div class="info-box"> |
106 | 106 | <span class="info-box-icon bg-red"><i class="glyphicon glyphicon-eye-open"></i></span> |
@@ -95,10 +95,10 @@ discard block |
||
95 | 95 | <div class="col-md-2" style="width:20%;"> |
96 | 96 | <?php |
97 | 97 | if (Auth::user()->role == 'admin') { |
98 | - $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate','=', \Carbon\Carbon::now()->format('Y-m-d'))->count(); |
|
98 | + $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate', '=', \Carbon\Carbon::now()->format('Y-m-d'))->count(); |
|
99 | 99 | } else { |
100 | - $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
|
101 | - $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate','=', \Carbon\Carbon::now()->format('Y-m-d'))->where('dept_id', '=', $dept->id)->count(); |
|
100 | + $dept = App\Model\helpdesk\Agent\Department::where('id', '=', Auth::user()->primary_dpt)->first(); |
|
101 | + $todaytickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->whereDate('tickets.duedate', '=', \Carbon\Carbon::now()->format('Y-m-d'))->where('dept_id', '=', $dept->id)->count(); |
|
102 | 102 | } |
103 | 103 | ?> |
104 | 104 | <a href="{!! route('ticket.duetoday') !!}"> |
@@ -132,9 +132,9 @@ discard block |
||
132 | 132 | $created_date = $start_date->created_at; |
133 | 133 | $created_date = explode(' ', $created_date); |
134 | 134 | $created_date = $created_date[0]; |
135 | - $start_date = date("m/d/Y", strtotime($created_date . ' -1 months')); |
|
135 | + $start_date = date("m/d/Y", strtotime($created_date.' -1 months')); |
|
136 | 136 | } else { |
137 | - $start_date = date("m/d/Y", strtotime(date("m/d/Y") . ' -1 months')); |
|
137 | + $start_date = date("m/d/Y", strtotime(date("m/d/Y").' -1 months')); |
|
138 | 138 | } |
139 | 139 | ?> |
140 | 140 | <script type="text/javascript"> |
@@ -197,7 +197,7 @@ discard block |
||
197 | 197 | <table class="table table-hover table-bordered"> |
198 | 198 | <?php |
199 | 199 | // dd($department); |
200 | - $flattened = $department->flatMap(function ($values) { |
|
200 | + $flattened = $department->flatMap(function($values) { |
|
201 | 201 | return $values->keyBy('status'); |
202 | 202 | }); |
203 | 203 | $statuses = $flattened->keys(); |
@@ -52,7 +52,7 @@ |
||
52 | 52 | |
53 | 53 | @foreach($categorys as $category) |
54 | 54 | <?php |
55 | -$num = \App\Model\kb\Relationship::where('category_id','=', $category->id)->get(); |
|
55 | +$num = \App\Model\kb\Relationship::where('category_id', '=', $category->id)->get(); |
|
56 | 56 | $article_id = $num->lists('article_id'); |
57 | 57 | $numcount = count($article_id); |
58 | 58 | ?> |
@@ -3,7 +3,7 @@ discard block |
||
3 | 3 | |
4 | 4 | <?php |
5 | 5 | //dd($arti); |
6 | -$all = App\Model\kb\Relationship::where('article_id','=', $arti->id)->get(); |
|
6 | +$all = App\Model\kb\Relationship::where('article_id', '=', $arti->id)->get(); |
|
7 | 7 | //dd($all); |
8 | 8 | /* from whole attribute pick the article_id */ |
9 | 9 | $category_id = $all->lists('category_id')->toArray(); |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | <?php $categorys = App\Model\kb\Category::all(); ?> |
145 | 145 | @foreach($categorys as $category) |
146 | 146 | <?php |
147 | -$num = \App\Model\kb\Relationship::where('category_id','=', $category->id)->get(); |
|
147 | +$num = \App\Model\kb\Relationship::where('category_id', '=', $category->id)->get(); |
|
148 | 148 | $article_id = $num->lists('article_id'); |
149 | 149 | $numcount = count($article_id); |
150 | 150 | ?> |
@@ -43,7 +43,7 @@ |
||
43 | 43 | |
44 | 44 | @foreach($categorys as $category) |
45 | 45 | <?php |
46 | -$num = \App\Model\kb\Relationship::where('category_id','=', $category->id)->get(); |
|
46 | +$num = \App\Model\kb\Relationship::where('category_id', '=', $category->id)->get(); |
|
47 | 47 | $article_id = $num->lists('article_id'); |
48 | 48 | $numcount = count($article_id); |
49 | 49 | ?> |
@@ -66,7 +66,7 @@ |
||
66 | 66 | $article = $article->where('status', '1'); |
67 | 67 | } |
68 | 68 | $article = $article->where('type', '1'); |
69 | - $article = $article->orderBy('publish_time','desc')->get(); |
|
69 | + $article = $article->orderBy('publish_time', 'desc')->get(); |
|
70 | 70 | ?> |
71 | 71 | @forelse($article as $arti) |
72 | 72 | <li> |