SmoothDeal

name; $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); $i = 0; foreach ($overdues as $overdue) { $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); $ovdate = $overdue->created_at; $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'

'; if(date('Y-m-d H:i:s') > $new_date){ $i++; } } // echo "created=".$created."
"; // echo "closed=".$closed."
"; // echo "inprogress=".$inprogress."
"; // echo "overdue=".$i."
"; } ?> SmoothDeal

{!! $company !!}

Daily Report

Hi {!! $name !!},
Below mentioned is daily report for {!! $company !!}.

Overview

@foreach ($depts as $dept) name; $created = DB::table('tickets')->select('created_at')->where('dept_id','=',$dept->id)->where('created_at','LIKE','%'.$day1.'%')->count(); $closed = DB::table('tickets')->where('dept_id','=',$dept->id)->where('closed_at','LIKE','%'.$day1.'%')->count(); $inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('status', '=', 1)->count(); $overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id','=',$dept->id)->where('isanswered', '=', 0)->where('status', '=', 1)->get(); $i = 0; foreach ($overdues as $overdue) { $sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id','=',$overdue->sla)->first(); $ovdate = $overdue->created_at; $new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)).'

'; if(date('Y-m-d H:i:s') > $new_date){ $i++; } } // echo "created=".$created."
"; // echo "closed=".$closed."
"; // echo "inprogress=".$inprogress."
"; // echo "overdue=".$i."
"; ?>

{!! $dept->name !!}
New tickets	{!! $created !!}
Closed tickets	{!! $closed !!}
Inprogress tickets	{!! $inprogress !!}
Overdue tickets	{!! $i !!}

@endforeach

We should all work hard to guarantee that all tickets are being addressed in a timely manner.

Thank You,
Kind Regards,
{!! $company !!}