/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$date = date('Y-m-');
$compliance = TicketItem::select(\DB::raw(" IFNULL( Sum(`tickets_items`.`weight` * `tickets_items`.`score` ) ,0) AS score "))->join('ticket', 'ticket.id', '=', 'tickets_items.id')->groupBy('requester')->get();
$tickets = Ticket::select('requester', \DB::raw("count(ticket.requester) AS requesters "))->groupBy('requester')->get();
return \Response::json(["legends" => $tickets->lists('requester'), "set1" => $tickets->lists('requesters'), "set2" => $compliance->lists('score')], 200, [], JSON_NUMERIC_CHECK);
}
/**
* Begin process
*
* @return \Illuminate\Http\Response
*/
public function postCloneArea(Request $request, $ticket_id, $area_id)
{
$Ticket = Ticket::find($ticket_id);
//record items or activites
$SurveyItems = SurveyItem::where('area_id', $area_id)->get();
foreach ($SurveyItems as $SurveyItem) {
$TicketItem = new TicketItem();
$TicketItem->ticket_id = $ticket_id;
$TicketItem->ref_number = $Ticket->ref_number;
$TicketItem->survey_id = $SurveyItem->survey_id;
$TicketItem->area_id = $SurveyItem->area_id;
$TicketItem->name = $SurveyItem->name;
$TicketItem->weight = $SurveyItem->weight;
$TicketItem->created_by = \Auth::user()->id;
$TicketItem->save();
}
return response(['ok' => true], 200);
}
