/** * Show the form for creating a new resource. * * @return Response */ public function create() { if (Session::has('visitordata')) { $session_visitor = session('visitordata'); } else { $session_visitor = ''; } //print_r(session());die; //Session::put('visitordata', ''); $card_no = str_random(4) . date_timestamp_get(date_create()); $arival_date = date('d-m-Y'); $arival_time = date('H:i'); $user_role = Auth::user()->role_id; $user_locationid = Auth::user()->location_id; $visitorlocationid = Auth::user()->location_id; $visitorlocation = Location::where('id', '=', $visitorlocationid)->pluck('name'); if ($user_role == 1) { $visitors = DB::table('visitors')->join('locations', 'visitors.location', '=', 'locations.id')->join('visitor_role', 'visitors.id', '=', 'visitor_role.visitor_id')->join('visitor_types', 'visitor_role.role_id', '=', 'visitor_types.id')->join('users', 'users.id', '=', 'visitors.host_name')->get(['visitors.*', 'locations.name', 'visitor_types.name as visitor_type', 'users.name as visitor_host']); } else { $visitors = DB::table('visitors')->where('location', '=', $user_locationid)->where('arival_date', '=', $arival_date)->join('locations', 'visitors.location', '=', 'locations.id')->join('visitor_role', 'visitors.id', '=', 'visitor_role.visitor_id')->join('visitor_types', 'visitor_role.role_id', '=', 'visitor_types.id')->join('users', 'users.id', '=', 'visitors.host_name')->get(['visitors.*', 'locations.name', 'visitor_types.name as visitor_type', 'users.name as visitor_host']); } //echo "<pre>"; print_r($visitors);die; $visitortypes = VisitorType::all()->toArray(); $current_visitors = DB::table('visitor_role')->join('visitors', 'visitors.id', '=', 'visitor_role.visitor_id')->where('visitors.status', '=', 1)->where('visitors.arival_date', '=', $arival_date)->get(['visitor_role.role_id']); $visitor_counts = array(); foreach ($visitortypes as $key => $visitortype) { $count = 0; $visitor_counts[$key]['visitortype'] = $visitortype['name']; foreach ($current_visitors as $current_visitor) { if ($visitortype['id'] == $current_visitor->role_id) { $count++; } } $visitor_counts[$key]['count'] = $count; } /*echo "<pre>"; print_r($visitor_counts);die;*/ $employees = Employee::where('role_id', '=', 5)->get(); return Response::json(array('visitors' => $visitors, 'visitortypes' => $visitortypes, 'hostnames' => $employees, 'location' => $visitorlocation, 'location_id' => $visitorlocationid, 'card_no' => $card_no, 'arival_date' => $arival_date, 'arival_time' => $arival_time, 'visitor_counts' => $visitor_counts, 'session_visitor' => $session_visitor)); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { VisitorType::destroy($id); return Response::json(array('success' => 'Visitor type has been deleted!')); }
public function handleDeleteVisitortype() { // Handle the delete confirmation. $id = Input::get('visitortype'); $visitortype = VisitorType::findOrFail($id); $visitortype->delete(); return Redirect::action('CommonController@visitortypes'); }