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