public function __construct() { $this->middleware('auth'); // Checking event_id key exist in session. if (Session::has('event_id')) { $eventId = Session::get('event_id'); $systemtrackId = Session::get('systemtrack_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('event_id'); } }
/** * function run by server every certain time for logout */ public function outFromSystem() { $now = new DateTime(date("Y-m-d H:i:s")); $userid = Tracklogin::select('userid')->first(); $userId = $userid->userid; $sessiontime = Tracklogin::select('sessiontime')->get()->first(); $date2 = $sessiontime->sessiontime; $date3 = new DateTime($date2); $diff1 = $date3->diff($now); $test = $diff1->s; if ($diff1->s > 2) { //Checking event_id key exist in session. $maxID = DB::table('systemtracks')->max('id'); $eventid = Systemtrack::where('id', $maxID)->pluck('eventid'); $leave_at = Systemtrack::where('id', $maxID)->pluck('leave_at'); if ($eventid != 0 && $leave_at == NULL) { $systemeventid = Systemtrack::where('id', $maxID)->pluck('systemeventid'); $systemtrack = Systemtrack::find($systemeventid); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); } //Checking booth_id key exist in session. $maxID = DB::table('systemtracks')->max('id'); $boothid = Systemtrack::where('id', $maxID)->pluck('boothid'); $leave_at = Systemtrack::where('id', $maxID)->pluck('leave_at'); if ($boothid != 0 && $leave_at == Null) { $systemboothid = Systemtrack::where('id', $maxID)->pluck('systemboothid'); $systemtrack = Systemtrack::find($systemboothid); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); } $maxLogin = DB::table('tracklogins')->where('user_id', $userId)->max('login_at'); DB::table('tracklogins')->where('user_id', $userId)->where('login_at', $maxLogin)->update(['logout_at' => $now]); //Auth::logout(); } }
public function showboothAjax() { //log out from last booth if (Session::has('booth_id')) { $boothId = Session::get('booth_id'); $systemtrackId = Session::get('systemtrack_booth_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('booth_id'); // Session::forget('systemtrack_id'); } $boothId = Request::get('boothId'); $booth = Booth::find($boothId); $systemtrack = new Systemtrack(); $systemtrack->user_id = Auth::User()->id; $systemtrack->spot_id = $booth->spot_id; $systemtrack->do = Auth::User()->name . ' ' . 'visit' . ' ' . $booth->name . ' Booth ' . 'at' . ' ' . date("Y-m-d H:i:s"); $systemtrack->comein_at = date("Y-m-d H:i:s"); $systemtrack->type = 'booth'; $systemtrack->type_id = $boothId; $systemtrack->save(); Session::put('booth_id', $boothId); Session::put('systemtrack_booth_id', $systemtrack->id); // echo json_encode($booth); //echo "yarab far7a"; $result = $booth; $result2 = $booth->exhibitor->name; echo json_encode(array("value" => $result, "value2" => $result2)); }
public function outFromSystem() { //ignore_user_abort(true); // $date1 = new DateTime(Session::get('sessionstart')); // $date2 = new DateTime(date("Y-m-d H:i:s")); // $date3 = new DateTime(Session::get('timer')); // $diff1 = $date2->diff($date1); //login // $diff2 = $date2->diff($date3); //refresh // // echo $diff->format('%h hours %i mintues %s secounds'); // // echo $diff->i; // //if($diff1->i > 1 ){ // ob_flush(); // if (connection_aborted()) { // // Checking event_id key exist in session. // if (Session::has('event_id')) { // $eventId=Session::get('event_id'); // $systemtrackId=Session::get('systemtrack_event_id'); // $systemtrack = Systemtrack::find($systemtrackId); // $systemtrack->leave_at=date("Y-m-d H:i:s"); // $systemtrack->save(); // Session::forget('event_id'); // // Session::forget('systemtrack_id'); // } // if (Session::has('booth_id')) { // $boothId=Session::get('booth_id'); // $systemtrackId=Session::get('systemtrack_booth_id'); // $systemtrack = Systemtrack::find($systemtrackId); // $systemtrack->leave_at=date("Y-m-d H:i:s"); // $systemtrack->save(); // Session::forget('booth_id'); // // Session::forget('systemtrack_id'); // } // $userId=Auth::user()->id; // $now = new DateTime(); // $maxLogin=DB::table('tracklogins') // ->where('user_id', $userId) // ->max('login_at'); // DB::table('tracklogins') // ->where('user_id', $userId) // ->where('login_at', $maxLogin) // ->update(['logout_at' => $now]); // Auth::logout(); // } ignore_user_abort(true); // inactive $date1 = new DateTime(Session::get('sessiontimer')); $date2 = new DateTime(date("Y-m-d H:i:s")); $diff1 = $date2->diff($date1); //refresh if ($diff1->i > 10) { // Checking event_id key exist in session. if (Session::has('event_id')) { $eventId = Session::get('event_id'); $systemtrackId = Session::get('systemtrack_event_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('event_id'); // Session::forget('systemtrack_id'); } if (Session::has('booth_id')) { $boothId = Session::get('booth_id'); $systemtrackId = Session::get('systemtrack_booth_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('booth_id'); // Session::forget('systemtrack_id'); } $userId = Auth::user()->id; $now = new DateTime(); $maxLogin = DB::table('tracklogins')->where('user_id', $userId)->max('login_at'); DB::table('tracklogins')->where('user_id', $userId)->where('login_at', $maxLogin)->update(['logout_at' => $now]); Auth::logout(); } else { for ($i = 0; $i < 5; $i++) { flush(); ob_flush(); echo connection_status(); if (connection_aborted()) { // Checking event_id key exist in session. if (Session::has('event_id')) { $eventId = Session::get('event_id'); $systemtrackId = Session::get('systemtrack_event_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('event_id'); // Session::forget('systemtrack_id'); } if (Session::has('booth_id')) { $boothId = Session::get('booth_id'); $systemtrackId = Session::get('systemtrack_booth_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('booth_id'); // Session::forget('systemtrack_id'); } $userId = Auth::user()->id; $now = new DateTime(); $maxLogin = DB::table('tracklogins')->where('user_id', $userId)->max('login_at'); DB::table('tracklogins')->where('user_id', $userId)->where('login_at', $maxLogin)->update(['logout_at' => $now]); Auth::logout(); //exit; } sleep(1); } } }
/** * function ajax for showing booths * @param integer $user_id * @return Response */ public function showboothAjax() { //log out from last booth if (Session::has('booth_id')) { $boothId = Session::get('booth_id'); $systemtrackId = Session::get('systemtrack_booth_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('booth_id'); // Session::forget('systemtrack_id'); } //check on event_id is exsist //log out from last booth if (Session::has('systemtrack_event_id')) { $systemtrack_event_id_value = Session::get('systemtrack_event_id'); $systemtrack_event = Systemtrack::find($systemtrack_event_id_value); if ($systemtrack_event->leave_at == null) { DB::table('systemtracks')->where('id', $systemtrack_event_id_value)->update(['leave_at' => date("Y-m-d H:i:s")]); //$systemtrack_booth->leave_at=date("Y-m-d H:i:s"); } } $boothId = Request::get('boothId'); $booth = Booth::find($boothId); $systemtrack = new Systemtrack(); $systemtrack->user_id = Auth::User()->id; $systemtrack->spot_id = $booth->spot_id; $systemtrack->do = Auth::User()->name . ' ' . 'visit' . ' ' . $booth->name . ' Booth ' . 'at' . ' ' . date("Y-m-d H:i:s"); $systemtrack->comein_at = date("Y-m-d H:i:s"); $systemtrack->type = 'booth'; $systemtrack->type_id = $boothId; $systemtrack->save(); Session::put('booth_id', $boothId); Session::put('systemtrack_booth_id', $systemtrack->id); DB::table('systemtracks')->where('id', $systemtrack->id)->update(['boothid' => $id, 'systemboothid' => $systemtrack->id]); // echo json_encode($booth); //echo "yarab far7a"; $result = $booth; $result2 = $booth->exhibitor->name; echo json_encode(array("value" => $result, "value2" => $result2)); }
/** * Log the user out of the application. * * @return \Illuminate\Http\Response */ public function getLogout() { // Checking event_id key exist in session. if (Session::has('event_id')) { $eventId = Session::get('event_id'); $systemtrackId = Session::get('systemtrack_event_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('event_id'); // Session::forget('systemtrack_id'); } if (Session::has('booth_id')) { $boothId = Session::get('booth_id'); $systemtrackId = Session::get('systemtrack_booth_id'); $systemtrack = Systemtrack::find($systemtrackId); $systemtrack->leave_at = date("Y-m-d H:i:s"); $systemtrack->save(); Session::forget('booth_id'); // Session::forget('systemtrack_id'); } $userId = Auth::user()->id; $now = new DateTime(); // Tracklogin::where('user_id', $userId) // ->max('login_at') // ->update(['logout_at' => $now]); $maxLogin = DB::table('tracklogins')->where('user_id', $userId)->max('login_at'); DB::table('tracklogins')->where('user_id', $userId)->where('login_at', $maxLogin)->update(['logout_at' => $now]); $this->auth->logout(); return redirect(property_exists($this, 'redirectAfterLogout') ? $this->redirectAfterLogout : '/'); }
/** * function to show event in certain page * * @param int $id * @return Response */ public function showEventPage($id) { //check on event_id is exsist if (Session::has('systemtrack_event_id')) { $systemtrack_event_id_value = Session::get('systemtrack_event_id'); $systemtrack_event = Systemtrack::find($systemtrack_event_id_value); if ($systemtrack_event->leave_at == null) { DB::table('systemtracks')->where('id', $systemtrack_event_id_value)->update(['leave_at' => date("Y-m-d H:i:s")]); //$systemtrack_booth->leave_at=date("Y-m-d H:i:s"); } } //check on booth_id is exsist if (Session::has('systemtrack_booth_id')) { $systemtrackid = Systemtrack::all()->last()->pluck('id'); $systemtrack_booth_id_value = Session::get('systemtrack_booth_id'); $systemtrack_booth = Systemtrack::find($systemtrack_booth_id_value); if ($systemtrack_booth->leave_at == null) { DB::table('systemtracks')->where('id', $systemtrack_booth_id_value)->update(['leave_at' => date("Y-m-d H:i:s")]); //$systemtrack_booth->leave_at=date("Y-m-d H:i:s"); } } $exhibitionevent = ExhibitionEvent::find($id); $booths = Booth::where('exhibition_event_id', $id)->get(); $systemtrack = new Systemtrack(); $systemtrack->user_id = Auth::User()->id; // $systemtrack->spot_id=$booth->spot_id; $systemtrack->do = Auth::User()->name . ' ' . 'visit' . ' ' . $exhibitionevent->name . ' Event ' . 'at' . ' ' . date("Y-m-d H:i:s"); $systemtrack->comein_at = date("Y-m-d H:i:s"); $systemtrack->type = 'exhibitionevent'; $systemtrack->type_id = $id; $systemtrack->save(); //save exhibition event id in session Session::put('event_id', $id); Session::put('systemtrack_event_id', $systemtrack->id); DB::table('systemtracks')->where('id', $systemtrack->id)->update(['eventid' => $id, 'systemeventid' => $systemtrack->id]); return view('exhibitionevents.eventpage', compact('exhibitionevent', 'booths')); }