@@ -355,25 +355,25 @@ discard block |
||
355 | 355 | <?php |
356 | 356 | $conversations = App\Model\Ticket\Ticket_Thread::where('ticket_id', '=', $ticket->id)->paginate(10); |
357 | 357 | foreach ($conversations as $conversation) { |
358 | - ?> |
|
358 | + ?> |
|
359 | 359 | <li class="time-label"> |
360 | 360 | <?php |
361 | 361 | $ConvDate1 = $conversation->created_at; |
362 | - $ConvDate = explode(' ', $ConvDate1); |
|
362 | + $ConvDate = explode(' ', $ConvDate1); |
|
363 | 363 | |
364 | - $date = $ConvDate[0]; |
|
365 | - $time = $ConvDate[1]; |
|
366 | - $time = substr($time, 0, -3); |
|
367 | - if (isset($data) && $date == $data) { |
|
364 | + $date = $ConvDate[0]; |
|
365 | + $time = $ConvDate[1]; |
|
366 | + $time = substr($time, 0, -3); |
|
367 | + if (isset($data) && $date == $data) { |
|
368 | 368 | |
369 | - } else { |
|
370 | - ?> <span class="bg-green"> |
|
369 | + } else { |
|
370 | + ?> <span class="bg-green"> |
|
371 | 371 | {{date_format($conversation->created_at, 'd/m/Y')}} |
372 | 372 | </span> <?php |
373 | 373 | $data = $ConvDate[0]; |
374 | - } |
|
374 | + } |
|
375 | 375 | $role = App\User::where('id','=',$conversation->user_id)->first(); |
376 | - ?> |
|
376 | + ?> |
|
377 | 377 | </li> |
378 | 378 | <li> |
379 | 379 | <?php if($conversation->is_internal) { ?> |
@@ -446,7 +446,7 @@ discard block |
||
446 | 446 | // $body = explode($attachment->file, $body); |
447 | 447 | // $body = $body[0]; |
448 | 448 | } |
449 | - ?> |
|
449 | + ?> |
|
450 | 450 | |
451 | 451 | <?php |
452 | 452 | $string = $body; |
@@ -35,9 +35,9 @@ |
||
35 | 35 | <?php |
36 | 36 | $counted = count(App\Model\Ticket\Tickets::where('status', '=', 1)->get()); |
37 | 37 | if ($counted < 20) { |
38 | - echo $counted . "/" . $counted; |
|
38 | + echo $counted . "/" . $counted; |
|
39 | 39 | } else { |
40 | - echo "20/" . $counted; |
|
40 | + echo "20/" . $counted; |
|
41 | 41 | } |
42 | 42 | ?> |
43 | 43 | </div> |
@@ -396,25 +396,25 @@ discard block |
||
396 | 396 | <?php |
397 | 397 | $conversations = App\Model\Ticket\Ticket_Thread::where('ticket_id', '=', $tickets->id)->paginate(10); |
398 | 398 | foreach ($conversations as $conversation) { |
399 | - ?> |
|
399 | + ?> |
|
400 | 400 | <li class="time-label"> |
401 | 401 | <?php |
402 | 402 | $ConvDate1 = $conversation->created_at; |
403 | - $ConvDate = explode(' ', $ConvDate1); |
|
403 | + $ConvDate = explode(' ', $ConvDate1); |
|
404 | 404 | |
405 | - $date = $ConvDate[0]; |
|
406 | - $time = $ConvDate[1]; |
|
407 | - $time = substr($time, 0, -3); |
|
408 | - if (isset($data) && $date == $data) { |
|
405 | + $date = $ConvDate[0]; |
|
406 | + $time = $ConvDate[1]; |
|
407 | + $time = substr($time, 0, -3); |
|
408 | + if (isset($data) && $date == $data) { |
|
409 | 409 | |
410 | - } else { |
|
411 | - ?> <span class="bg-green"> |
|
410 | + } else { |
|
411 | + ?> <span class="bg-green"> |
|
412 | 412 | {{date_format($conversation->created_at, 'd/m/Y')}} |
413 | 413 | </span> <?php |
414 | 414 | $data = $ConvDate[0]; |
415 | - } |
|
415 | + } |
|
416 | 416 | $role = App\User::where('id','=',$conversation->user_id)->first(); |
417 | - ?> |
|
417 | + ?> |
|
418 | 418 | </li> |
419 | 419 | <li> |
420 | 420 | <?php if($conversation->is_internal) { ?> |
@@ -487,7 +487,7 @@ discard block |
||
487 | 487 | // $body = explode($attachment->file, $body); |
488 | 488 | // $body = $body[0]; |
489 | 489 | } |
490 | - ?> |
|
490 | + ?> |
|
491 | 491 | |
492 | 492 | <?php |
493 | 493 | $string = $body; |
@@ -54,7 +54,7 @@ |
||
54 | 54 | <?php |
55 | 55 | $encrypter = app('Illuminate\Encryption\Encrypter'); |
56 | 56 | $encrypted_token = $encrypter->encrypt(csrf_token()); |
57 | - ?> |
|
57 | + ?> |
|
58 | 58 | <input id="token" type="hidden" value="{{$encrypted_token}}"> |
59 | 59 | {!! Form::open(['action'=>'Client\helpdesk\FormController@postedForm','method'=>'post']) !!} |
60 | 60 | <div> |
@@ -164,8 +164,8 @@ |
||
164 | 164 | </div> |
165 | 165 | <!-- priority --> |
166 | 166 | <?php |
167 | - $Priority = App\Model\helpdesk\Settings\CommonSettings::select('status')->where('option_name','=', 'user_priority')->first(); |
|
168 | - $user_Priority=$Priority->status; |
|
167 | + $Priority = App\Model\helpdesk\Settings\CommonSettings::select('status')->where('option_name','=', 'user_priority')->first(); |
|
168 | + $user_Priority=$Priority->status; |
|
169 | 169 | ?> |
170 | 170 | |
171 | 171 | @if(Auth::user()) |
@@ -8,23 +8,23 @@ |
||
8 | 8 | |
9 | 9 | $dept = App\Model\helpdesk\Agent\Department::where('id','=',$user->primary_dpt)->first(); |
10 | 10 | |
11 | - $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
12 | - $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
13 | - $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); |
|
14 | - $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
15 | - $i = 0; |
|
16 | - foreach ($overdues as $overdue) { |
|
17 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
18 | - $ovdate = $overdue->created_at; |
|
19 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
20 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
21 | - $i++; |
|
22 | - } |
|
23 | - } |
|
24 | - // echo "created=".$created."<br/>"; |
|
25 | - // echo "closed=".$closed."<br/>"; |
|
26 | - // echo "inprogress=".$inprogress."<br/>"; |
|
27 | - // echo "overdue=".$i."<br/>"; |
|
11 | + $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
12 | + $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
13 | + $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); |
|
14 | + $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
15 | + $i = 0; |
|
16 | + foreach ($overdues as $overdue) { |
|
17 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
18 | + $ovdate = $overdue->created_at; |
|
19 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
20 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
21 | + $i++; |
|
22 | + } |
|
23 | + } |
|
24 | + // echo "created=".$created."<br/>"; |
|
25 | + // echo "closed=".$closed."<br/>"; |
|
26 | + // echo "inprogress=".$inprogress."<br/>"; |
|
27 | + // echo "overdue=".$i."<br/>"; |
|
28 | 28 | |
29 | 29 | ?> |
30 | 30 |
@@ -6,24 +6,24 @@ discard block |
||
6 | 6 | |
7 | 7 | $depts = App\Model\helpdesk\Agent\Department::all(); |
8 | 8 | foreach ($depts as $dept) { |
9 | - // echo $dept->name; |
|
10 | - $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
11 | - $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
12 | - $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); |
|
13 | - $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
14 | - $i = 0; |
|
15 | - foreach ($overdues as $overdue) { |
|
16 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
17 | - $ovdate = $overdue->created_at; |
|
18 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
19 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
20 | - $i++; |
|
21 | - } |
|
22 | - } |
|
23 | - // echo "created=".$created."<br/>"; |
|
24 | - // echo "closed=".$closed."<br/>"; |
|
25 | - // echo "inprogress=".$inprogress."<br/>"; |
|
26 | - // echo "overdue=".$i."<br/>"; |
|
9 | + // echo $dept->name; |
|
10 | + $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
11 | + $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
12 | + $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); |
|
13 | + $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
14 | + $i = 0; |
|
15 | + foreach ($overdues as $overdue) { |
|
16 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
17 | + $ovdate = $overdue->created_at; |
|
18 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
19 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
20 | + $i++; |
|
21 | + } |
|
22 | + } |
|
23 | + // echo "created=".$created."<br/>"; |
|
24 | + // echo "closed=".$closed."<br/>"; |
|
25 | + // echo "inprogress=".$inprogress."<br/>"; |
|
26 | + // echo "overdue=".$i."<br/>"; |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | ?> |
@@ -79,18 +79,18 @@ discard block |
||
79 | 79 | $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
80 | 80 | $i = 0; |
81 | 81 | foreach ($overdues as $overdue) { |
82 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
83 | - $ovdate = $overdue->created_at; |
|
84 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
85 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
86 | - $i++; |
|
87 | - } |
|
82 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
83 | + $ovdate = $overdue->created_at; |
|
84 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
85 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
86 | + $i++; |
|
87 | + } |
|
88 | 88 | } |
89 | - // echo "created=".$created."<br/>"; |
|
90 | - // echo "closed=".$closed."<br/>"; |
|
91 | - // echo "inprogress=".$inprogress."<br/>"; |
|
92 | - // echo "overdue=".$i."<br/>"; |
|
93 | - ?> |
|
89 | + // echo "created=".$created."<br/>"; |
|
90 | + // echo "closed=".$closed."<br/>"; |
|
91 | + // echo "inprogress=".$inprogress."<br/>"; |
|
92 | + // echo "overdue=".$i."<br/>"; |
|
93 | + ?> |
|
94 | 94 | <!-- Overview Table --> |
95 | 95 | <table align="center" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333;" width="500" border="0" cellspacing="0" cellpadding="10"> |
96 | 96 | <tr > |
@@ -6,28 +6,28 @@ discard block |
||
6 | 6 | |
7 | 7 | $depts = App\Model\helpdesk\Agent\Department::all(); |
8 | 8 | foreach ($depts as $dept) { |
9 | - // echo $dept->name; |
|
10 | - $created = DB::table('tickets')->select('created_at')->where('dept_id', $dept->id)->where('team_id', $team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
11 | - |
|
12 | - $closed = DB::table('tickets')->where('dept_id', $dept->id)->where('team_id', $team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
13 | - |
|
14 | - $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id', $dept->id)->where('team_id', $team_id)->where('status', '=', 1)->count(); |
|
15 | - |
|
16 | - $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id', $dept->id)->where('team_id', $team_id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
17 | - |
|
18 | - $i = 0; |
|
19 | - foreach ($overdues as $overdue) { |
|
20 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
21 | - $ovdate = $overdue->created_at; |
|
22 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
23 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
24 | - $i++; |
|
25 | - } |
|
26 | - } |
|
27 | - // echo "created=".$created."<br/>"; |
|
28 | - // echo "closed=".$closed."<br/>"; |
|
29 | - // echo "inprogress=".$inprogress."<br/>"; |
|
30 | - // echo "overdue=".$i."<br/>"; |
|
9 | + // echo $dept->name; |
|
10 | + $created = DB::table('tickets')->select('created_at')->where('dept_id', $dept->id)->where('team_id', $team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
11 | + |
|
12 | + $closed = DB::table('tickets')->where('dept_id', $dept->id)->where('team_id', $team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
13 | + |
|
14 | + $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id', $dept->id)->where('team_id', $team_id)->where('status', '=', 1)->count(); |
|
15 | + |
|
16 | + $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id', $dept->id)->where('team_id', $team_id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); |
|
17 | + |
|
18 | + $i = 0; |
|
19 | + foreach ($overdues as $overdue) { |
|
20 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
21 | + $ovdate = $overdue->created_at; |
|
22 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
23 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
24 | + $i++; |
|
25 | + } |
|
26 | + } |
|
27 | + // echo "created=".$created."<br/>"; |
|
28 | + // echo "closed=".$closed."<br/>"; |
|
29 | + // echo "inprogress=".$inprogress."<br/>"; |
|
30 | + // echo "overdue=".$i."<br/>"; |
|
31 | 31 | } |
32 | 32 | |
33 | 33 | ?> |
@@ -228,24 +228,24 @@ discard block |
||
228 | 228 | <!-- Start Full Text --> |
229 | 229 | <?php |
230 | 230 | foreach ($depts as $dept) { |
231 | - $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
231 | + $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
232 | 232 | |
233 | - $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
233 | + $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
234 | 234 | |
235 | - $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->count(); |
|
235 | + $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->count(); |
|
236 | 236 | |
237 | - $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->get(); |
|
237 | + $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->get(); |
|
238 | 238 | |
239 | - $i = 0; |
|
240 | - foreach ($overdues as $overdue) { |
|
241 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
242 | - $ovdate = $overdue->created_at; |
|
243 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
244 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
245 | - $i++; |
|
246 | - } |
|
247 | - } |
|
248 | - ?> |
|
239 | + $i = 0; |
|
240 | + foreach ($overdues as $overdue) { |
|
241 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
242 | + $ovdate = $overdue->created_at; |
|
243 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
244 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
245 | + $i++; |
|
246 | + } |
|
247 | + } |
|
248 | + ?> |
|
249 | 249 | <table width="100%" bgcolor="#ffffff" cellpadding="0" cellspacing="0" border="0" id="backgroundTable" st-sortable="full-text"> |
250 | 250 | <tbody> |
251 | 251 | <tr> |
@@ -507,24 +507,24 @@ discard block |
||
507 | 507 | </p> |
508 | 508 | <?php |
509 | 509 | foreach ($depts as $dept) { |
510 | - $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
510 | + $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('created_at','LIKE','%'.$day1.'%')->count(); |
|
511 | 511 | |
512 | - $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
512 | + $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('closed_at','LIKE','%'.$day1.'%')->count(); |
|
513 | 513 | |
514 | - $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->count(); |
|
514 | + $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->count(); |
|
515 | 515 | |
516 | - $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->get(); |
|
516 | + $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('team_id','=',$team_id)->where('status', '=', 1)->get(); |
|
517 | 517 | |
518 | - $i = 0; |
|
519 | - foreach ($overdues as $overdue) { |
|
520 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
521 | - $ovdate = $overdue->created_at; |
|
522 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
523 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
524 | - $i++; |
|
525 | - } |
|
526 | - } |
|
527 | - ?> |
|
518 | + $i = 0; |
|
519 | + foreach ($overdues as $overdue) { |
|
520 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
521 | + $ovdate = $overdue->created_at; |
|
522 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
523 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
524 | + $i++; |
|
525 | + } |
|
526 | + } |
|
527 | + ?> |
|
528 | 528 | <!-- Overview Table --> |
529 | 529 | <table align="center" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333;" width="500" border="0" cellspacing="0" cellpadding="10"> |
530 | 530 | <tr > |
@@ -14,18 +14,18 @@ |
||
14 | 14 | $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept_id)->where('status', '=', 1)->where('isanswered', '=', 0)->get(); |
15 | 15 | |
16 | 16 | $i = 0; |
17 | - foreach ($overdues as $overdue) { |
|
18 | - $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
19 | - $ovdate = $overdue->created_at; |
|
20 | - $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
21 | - if(date('Y-m-d H:i:s') > $new_date){ |
|
22 | - $i++; |
|
23 | - } |
|
24 | - } |
|
25 | - // echo "created=".$created."<br/>"; |
|
26 | - // echo "closed=".$closed."<br/>"; |
|
27 | - // echo "inprogress=".$inprogress."<br/>"; |
|
28 | - // echo "overdue=".$i."<br/>"; |
|
17 | + foreach ($overdues as $overdue) { |
|
18 | + $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); |
|
19 | + $ovdate = $overdue->created_at; |
|
20 | + $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'<br/><br/>'; |
|
21 | + if(date('Y-m-d H:i:s') > $new_date){ |
|
22 | + $i++; |
|
23 | + } |
|
24 | + } |
|
25 | + // echo "created=".$created."<br/>"; |
|
26 | + // echo "closed=".$closed."<br/>"; |
|
27 | + // echo "inprogress=".$inprogress."<br/>"; |
|
28 | + // echo "overdue=".$i."<br/>"; |
|
29 | 29 | ?> |
30 | 30 | |
31 | 31 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |