/** * 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); }