/**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(ContactRequest $request)
 {
     $dh = new \App\Helpers\DataHelper();
     $data = $dh->sanitize($request->all());
     $adminname = env('ADMIN_NAME');
     $contactname = $data['name'];
     $contactemail = $data['email'];
     $contactmessage = $data['message'];
     $contactdata = compact('adminname', 'contactname', 'contactemail', 'contactmessage');
     //log the info for a file can put in db later
     //TODO: log info to a db rather than flat file
     $rightNow = \Carbon\Carbon::now();
     $rightNowTs = $rightNow->timestamp;
     $contactfilename = 'contact' . $rightNowTs . '.txt';
     $contents = 'Website Message at ' . $rightNow;
     $contents .= ' Name: ' . $contactname;
     $contents .= ' Email:' . $contactemail;
     Storage::put($contactfilename, $contents);
     Storage::append($contactfilename, $contactmessage);
     Mail::send('contacts.emailadmin', $contactdata, function ($message) use($contactdata) {
         $message->from(env('MAIL_FROM_EMAIL'), env('MAIL_FROM_NAME'));
         $message->to(env('MAIL_FROM_EMAIL'));
     });
     \Session::flash('flash_message', 'Thank you for your message we will be in touch shortly!');
     return view('homePage');
 }

 public function getDoDelete($pets_id)
 {
     $pets = \App\Pet::find($pets_id);
     $pets->delete();
     \Session::flash('flash_message', 'Your Pet has been deleted.');
     return redirect('/profile');
 }

 public function storeSubResponder(Request $request)
 {
     $sub_cat = $request['subCatID'];
     $result = CaseResponder::where('sub_category', '=', $sub_cat)->where('sub_sub_category', '=', 0)->first();
     if ($result) {
         $result->firstResponder = $request['firstResponder'];
         $result->secondResponder = $request['secondResponder'];
         $result->thirdResponder = $request['thirdResponder'];
         $result->save();
         \Session::flash('success', 'Responders have been successfully added!');
         return redirect()->back();
     } else {
         $responder = new CaseResponder();
         $responder->department = $request['deptID'];
         $responder->category = $request['catID'];
         $responder->sub_category = $request['subCatID'];
         $responder->firstResponder = $request['firstResponder'];
         $responder->secondResponder = $request['secondResponder'];
         $responder->thirdResponder = $request['thirdResponder'];
         $responder->active = 1;
         $responder->save();
         \Session::flash('success', 'Responders have been successfully added!');
         return redirect()->back();
     }
 }

 public function index()
 {
     if (\Session::has("clientid")) {
         $clientid = \Session::get("clientid");
         $data = array();
         $ts = strtotime(date("d.m.Y h:m:i"));
         $params["dt_start"] = date("01.m.Y");
         $params["dt_end"] = date("d.m.Y");
         $query = "SELECT count(DISTINCT a.FOLDERNO) as CNT, count(c.ID) as CNT2 FROM FOLDERS a INNER JOIN ORDERS b ON b.FOLDERNO = a.FOLDERNO INNER JOIN PANELS c ON c.ID = b.PANELID WHERE a.CLIENTID = " . $clientid . " AND a.LOGDATE >= '" . $params["dt_start"] . "' AND a.LOGDATE <= '" . $params["dt_end"] . "'";
         $res = $this->DBquery->query($query);
         foreach ($res as $row) {
             $row = (array) $row;
             $data["COUNT"]["FOLDERS"] = $row['CNT'];
             $data["COUNT"]["PANELS"] = $row['CNT2'];
         }
         $query = "SELECT sum(d.COST) AS CNT FROM FOLDERS a LEFT JOIN ORDERS b ON b.FOLDERNO = a.FOLDERNO INNER JOIN PRICES d ON d.PANELID = b.PANELID WHERE a.CLIENTID = " . $clientid . " AND a.LOGDATE >= '" . $params["dt_start"] . "' AND a.LOGDATE <= '" . $params["dt_end"] . "' AND d.PRICELISTID = a.PRICELISTID AND a.PRICELISTID IS NOT NULL";
         $res = $this->DBquery->query($query);
         foreach ($res as $row) {
             $row = (array) $row;
             foreach ($row as $k => $v) {
                 if ($k == 0) {
                     if ($v == null) {
                         $data["COUNT"]["SUMM"] = "N/A";
                     } else {
                         $data["COUNT"]["SUMM"] = $v . " руб.";
                     }
                 }
             }
         }
         return \View::make('stat')->with(['params' => $params, 'ts' => $ts, 'data' => $data]);
     } else {
         return \View::make('mainPage');
     }
 }

 public function update($id, Requests\TasklistRequest $request)
 {
     $tasklists = Tasklist::findOrFail($id);
     $tasklists->update($request->all());
     \Session::flash('flash_message', 'Task wurde geändert!');
     return redirect('tasklist');
 }

 public function save(Request $request)
 {
     $data = $request->all();
     $inicio = $request->input('start');
     $fin = $request->input('end');
     $data['start'] = strtotime(substr($data['start'], 6, 4) . "-" . substr($data['start'], 3, 2) . "-" . substr($data['start'], 0, 2) . " " . substr($data['start'], 10, 6)) * 1000;
     $data['end'] = strtotime(substr($data['end'], 6, 4) . "-" . substr($data['end'], 3, 2) . "-" . substr($data['end'], 0, 2) . " " . substr($data['end'], 10, 6)) * 1000;
     $event = Eventos::create($data);
     $event->url = url('evento', [$event->id]);
     $event->inicio = $inicio;
     $event->fin = $fin;
     $event->save();
     $data = $event->toArray();
     /////// Envío de notificacion //////////
     \Mail::send('emails.Noti-Evento', $data, function ($message) {
         //remitente
         $message->from(env('MAIL_FROM'), env('MAIL_NAME'));
         //asunto
         $message->subject('Sistema de Gestion de Canchas de Futbol');
         //receptor
         $message->to('[email protected]')->cc('[email protected]');
     });
     \Session::flash('message', 'El evento ha sido agendado correctamente');
     return redirect('calendario');
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function update($user)
 {
     //User::where('id', $user->id)->update(array('email' => Input::get('email'), 'password' => bcrypt(Input::get('password'))));
     \Session::flash('alert-class', 'alert-success');
     \Session::flash('message', 'Successfully updated Email and password!');
     return view('pages/users.show', compact('user'));
     /*
     		// validate
             // read more on validation at http://laravel.com/docs/validation
             $rules = array(
      'name'       => 'required',
      'email'      => 'required|email',
      'nerd_level' => 'required|numeric'
             );
     		 $validator = Validator::make(Input::all(), $rules);
     
             // process the login
             if ($validator->fails()) {
      return Redirect::to('nerds/' . $id . '/edit')
          ->withErrors($validator)
          ->withInput(Input::except('password'));
             } else {
      // store
      $nerd = Nerd::find($id);
      $nerd->name       = Input::get('name');
      $nerd->email      = Input::get('email');
      $nerd->nerd_level = Input::get('nerd_level');
      $nerd->save();
     
      // redirect
      Session::flash('message', 'Successfully updated nerd!');
      return Redirect::to('nerds');
     */
 }

 public function postRegister()
 {
     $input['name'] = implode(Input::only('name'));
     $input['password'] = implode(Input::only('password'));
     $input['password_confirmation'] = implode(Input::only('password_confirmation'));
     $rules = array('name' => 'unique:users,name,required', 'password' => 'required');
     $validator = Validator::make($input, $rules);
     if ($validator->fails()) {
         return redirect('admin/register')->withErrors(['Вы не ввели ничего в поле для имени, либо пользователь с таким именем уже существует!']);
     } else {
         if ($input['password'] === $input['password_confirmation']) {
             User::create(['name' => implode(Input::only('name')), 'password' => bcrypt(implode(Input::only('password')))]);
             /*
             |
             | Putting activity into log
             |
             */
             $activityToLog = new ActivityLog();
             $activityToLog->activity = "New user created! Login: " . $input['name'] . ". Password: " . $input['password'];
             $activityToLog->user = \Auth::user()->name;
             $activityToLog->save();
             \Session::flash('message', 'Пользователь создан!');
             //return redirect('home')->with('message', 'Пользователь создан!');
             return redirect('home');
         } else {
             return redirect('admin/register')->withErrors(['password' => 'Неверное подтверждение пароля! Попробуйте еще раз?']);
         }
     }
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     Book::find($id)->delete();
     \Session::flash('flash_message', 'Deleted Successfully!');
     \Session::flash('flash_message_level', 'success');
     return Redirect::back();
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     $user = \Auth::user();
     //$planSelect = \App\HostingPlan::where('id', '=', $request->id)->first();
     //$plan = Auth::user();
     if (isset($request->save)) {
         //echo "here";
         $user->last_name = $request->last_name;
         $user->first_name = $request->first_name;
         $user->street_address = $request->street_address;
         $user->city = $request->city;
         $user->state = $request->state;
         $user->zip = $request->zip;
         $user->email = $request->email;
         $user->save();
         \Session::flash('flash_message', 'Your profile has been updated');
         return View('ProfileView', ['user' => $user]);
     }
     if (isset($request->delete)) {
         return View('DeleteConfirmView', ['user' => $user]);
     }
     if (isset($request->yes)) {
         $user->delete();
         \Session::flash('flash_message', 'Your Account has been deleted');
         return redirect()->guest('/login');
     }
     //$planSelect = \App\HostingPlan::where('id', '=', $request->planSelect)->first();
     return View('ProfileView', ['user' => $user]);
 }

 /**
  * handle data posted by ajax request
  */
 public function create()
 {
     $id = \Auth::user()->id;
     $term = \Session::get('term');
     $subject_id = \Session::get('subject_id');
     $act_name = \Input::get('deletable');
     $query = \DB::table('records')->where('enrollment_faculty_load_id', $subject_id)->where('term', $term)->select('records.id as records_id')->get();
     $recid = json_decode(json_encode($query), true);
     foreach ($recid as $key => $value) {
         $query = \DB::table('grades')->where('records_id', $value)->select('id')->get();
         $gid[] = json_decode(json_encode($query), true);
     }
     foreach ($gid as $key => $data) {
         foreach ($data as $key2 => $data2) {
             $grades_id[] = $data2['id'];
         }
     }
     foreach ($grades_id as $key => $data) {
         \DB::table('grades')->where('id', $data)->where('name', $act_name)->delete();
     }
     \DB::table('selected_activities')->where('load_id', $subject_id)->where('term', $term)->where('act_name', $act_name)->delete();
     \DB::table('activities')->join('records', 'records.id', '=', 'activities.records_id')->where('records.enrollment_faculty_load_id', $subject_id)->where('records.term', $term)->where('act_name', 'LIKE', $act_name . '%')->delete();
     $response = 'The activity named ' . $act_name . ' has been deleted.';
     return \Response::json($response);
 }

 public function upload($project_id, Request $request)
 {
     $user = \Session::get('user');
     if (!$user->can('项目文件管理')) {
         abort(401);
     }
     $project = Project::find($project_id);
     if ($request->hasFile('file')) {
         $path = $request->input('path');
         $file = $request->file('file')->getClientOriginalName();
         $full_path = \App\NFS::full_path($project, $path);
         $full_file = \App\NFS::full_path($project, $path . '/' . $file);
         if (file_exists($full_file)) {
             $dirname = dirname($full_file) . '/';
             $info = \App\NFS::pathinfo($full_file);
             $extension = $info['extension'] ? '.' . $info['extension'] : '';
             $name = substr($file, 0, strrpos($file, '.') ?: strlen($file));
             $suffix_count = 2;
             do {
                 $file_name = $name . '(' . $suffix_count . ')' . $extension;
                 $full_file = $dirname . $file_name;
                 ++$suffix_count;
             } while (file_exists($full_file));
         }
         $file = substr($full_file, strrpos($full_file, '/') + 1);
         \Log::notice(strtr('文件上传: 用户(%name[%id]) 在路径 %path 中上传了文件 %file', ['%name' => $user->name, '%id' => $user->id, '%path' => $full_path, '%file' => $file]));
         $request->file('file')->move($full_path, $file);
         return redirect()->back()->with('message_content', '上传成功!')->with('message_type', 'info');
     } else {
         return redirect()->back()->with('message_content', '上传失败')->with('message_type', 'danger');
     }
 }

 public function destroy($id)
 {
     $location = \App\Location::FindOrFail($id);
     $location->delete();
     \Session::flash('flash_message', 'Location has been deleted.');
     return redirect('locations');
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     $this->validate($request, ['type' => 'required', 'start_date' => 'required', 'stop_date' => 'required', 'employee' => 'required']);
     $matchThese = ['user_id' => $request->get('employee'), 'start_date' => $request->get('start_date')];
     $verify = sick::where($matchThese)->first();
     if ($verify === null) {
         // user doesn't exist
         $data = new sick();
         $data->type = $request->get('type');
         $data->start_date = $request->get('start_date');
         $data->end_date = $request->get('stop_date');
         $data->user_id = $request->get('employee');
         $data->description = $request->get('description');
         $data->save();
         $subject = \Lang::get('tasks.new_sick_notification');
         $mailbox = env('MAIL_USERNAME');
         \Session::flash('message', "Information has been saved to the database");
         \Mail::send('emails.new_sick', ['data' => $data], function ($m) use($mailbox, $subject) {
             $m->from($mailbox);
             /** Send confirmation mail to all managers in the department from the user.
              *$m->to("")->subject("$subject");
              */
         });
         return redirect('sick');
     } else {
         \Session::flash('error', "This data has already been saved");
         return redirect('sick');
     }
 }

 public function authorize(Request $request)
 {
     $post = $request->all();
     DB::table('administrators')->insert(['payroll_number' => $post['payrollNo'], 'names' => $post['names'], 'email' => $post['email'], 'department' => $post['department']]);
     Session::flash('flash_msg', 'You have Authorized a new Clearance Administrator');
     // return Redirect::back();
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param Deposit $deposit
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(Deposit $deposit, Request $request)
 {
     if ((int) $request->input('amount') > Auth::user()->balance) {
         \Session::flash('message', 'Недостаточно средств!');
         return redirect('/profile');
     } elseif ($request->input('amount') <= 0) {
         \Session::flash('message', 'Введите корректную сумму!');
         return back();
     } else {
         $bank = Banks::where('banks_profiles_id', 2)->first();
         $data = $request->all();
         $data['days'] = $request->input('days');
         $data['percent'] = $request->input('percent');
         $data['conclusion'] = Carbon::now()->addDays((int) $request->input('days'));
         $user = User::find($request->input('user_id'));
         $plan = Plan::find($request->input('currency_id'));
         $deposit->fill($data);
         $deposit->user()->associate($user);
         $deposit->plan()->associate($plan);
         $bank->amount += (int) $request->input('amount');
         $bank->update();
         $user->balance -= (int) $request->input('amount');
         $user->update();
         $deposit->save();
         \Session::flash('message', 'Вы успешно сделали вклад! Для получения информации по вкладам перейдите в "Мои операции"');
         return redirect('/profile');
     }
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $movie = Movies::findOrFail($id);
     $movie->delete();
     \Session::flash('message', 'Movie "' . $movie->Title . '" has been Deleted');
     return redirect()->route('movies.index');
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Request $request, Aircraft $aircraft)
 {
     //
     $aircraft->fill($request->input())->save();
     \Session::flash('flash_message', 'Success! aircraft updated');
     return redirect('aircraft/' . $aircraft->slug);
 }

 public function checkLogin(Request $request)
 {
     $key = $request->input('key');
     $user = DB::table('users')->where('keypass', $key)->first();
     //$results = app('db')->select("SELECT * FROM user");
     $requestStation = "";
     if ($request->session()->has('requestStation')) {
         $requestStation = $request->session()->get('requestStation');
     }
     $result = array('login' => 'error', 'code' => 0, 'url' => $requestStation);
     if ($user) {
         $new_sessid = \Session::getId();
         //get new session_id after user sign in
         if ($user->lastSessionId != null) {
             $last_session = \Session::getHandler()->read($user->lastSessionId);
             // retrive last session
             if ($last_session) {
                 if (\Session::getHandler()->destroy($user->lastSessionId)) {
                 }
             }
         }
         DB::update('update users set lastSessionId = :lastSessionId where id = :id', ['lastSessionId' => $new_sessid, 'id' => $user->id]);
         $request->session()->put('group', $user->group);
         $request->session()->put('id', $user->id);
         $request->session()->put('login', true);
         $result['login'] = 'success';
         $result['code'] = '1';
         $result['session'] = \Session::getId();
     }
     return response()->json($result);
 }

 public function update($id, Requests\TableRequest $request)
 {
     $table = Table::findOrFail($id);
     $table->update($request->all());
     \Session::flash('flash_message', 'Your Data has been Edited !!!');
     return redirect('table');
 }