private function diakkeszites($file)
{
$egyvaltozo1 = Excel::load($file, function ($reader) {
$reader->ignoreEmpty();
})->get(array('hallgatoneptunkodja'))->toArray();
try {
$szamol = User::all()->count();
foreach ($egyvaltozo1 as $egyvaltozo) {
if ($egyvaltozo["hallgatoneptunkodja"] != "") {
$diak = User::firstOrNew(array("name" => $egyvaltozo["hallgatoneptunkodja"], "email" => $egyvaltozo["hallgatoneptunkodja"], "type" => "3"));
if (empty($diak->password)) {
$diak->password = bcrypt($egyvaltozo["hallgatoneptunkodja"]);
$diak->save();
} else {
$diak->active = 1;
$diak->save();
}
}
}
$szamol = User::all()->count() - $szamol;
return $szamol;
} catch (\Exception $e) {
$message = "Import file is not valid! Please check";
return view('import.error', compact('message'));
}
}
public function handle()
{
$adminUser = User::firstOrNew(['email' => env('ADMIN_EMAIL'), 'name' => 'Cocoaheads Admin']);
$adminUser->password = Hash::make(env('ADMIN_PASSWORD'));
$adminUser->save();
$this->info("Admin User id {$adminUser->id}");
}
public function store(BookingRequest $request)
{
$booking = array('car_type_id' => $request->car_type_id, 'number_of_passengers' => $request->number_of_passengers, 'pickup_time' => $request->pickup_date_part . ' ' . $request->pickup_time_part, 'ip_info' => $request->ip_info);
$newBooking = Booking::create($booking);
flash()->success('Your booking has been created!')->important();
if (!empty($request->comment1)) {
//children comment
$comment1 = array('booking_id' => $newBooking->id, 'comment_type_id' => '1', 'role_id' => '1', 'comment' => $request->comment1);
Comment::create($comment1);
}
if (!empty($request->comment2)) {
//general comment
$comment2 = array('booking_id' => $newBooking->id, 'comment_type_id' => '2', 'role_id' => '1', 'comment' => $request->comment2);
Comment::create($comment2);
}
$change = array('booking_id' => $newBooking->id, 'change_type_id' => '4', 'user_id' => Auth::user()->id, 'from' => null, 'to' => null);
Change::create($change);
$passenger = User::firstOrNew(['email' => $request->email]);
$passenger->name = $request->name;
$passenger->phone = $request->phone;
$passenger->save();
$role = array('booking_id' => $newBooking->id, 'role_type_id' => '2', 'user_id' => $passenger->id);
Role::create($role);
$price = array('booking_id' => $newBooking->id, 'income_type_id' => '1', 'amount_eur' => $request->price);
Income::create($price);
$locationArray = $request->location;
foreach ($request->address as $order => $address_id) {
$route_point = null;
$route_point = array('booking_id' => $newBooking->id, 'location_id' => $locationArray[$order], 'address_id' => $address_id, 'order' => $order);
Route_point::create($route_point);
}
return redirect('bookings');
}
/**
* Register any application services.
*
* @return void
*/
public function register()
{
$this->app->singleton('App\\User', function ($app) {
// Session中获取当前认证用户
$authUser = session('logged_user');
if (true || app()->environment('debug')) {
$authUser = (object) array('id' => 'Hello, World!');
}
if (empty($authUser)) {
$oauth = app('wechat')->oauth;
try {
$authUser = $oauth->user();
} catch (\InvalidArgumentException $e) {
$response = $oauth->scopes(['snsapi_base'])->redirect();
return $response;
}
// 保存Session
//$authUser = $oauth->user();
session(['logged_user' => $authUser]);
}
// 根据认证得到的用户openid获取用户信息，若不存在则实例化新用户
$user = User::firstOrNew(['openid' => $authUser->id]);
if ($user->state == 'normal' && $user->score <= 0) {
$user->state = 'disabled';
$user->save();
} else {
if ($user->score > 0 && $user->state == 'disabled' && $user->free_at && $user->free_at->lte(Carbon::now())) {
$user->state = 'normal';
$user->save();
}
}
return $user;
});
}
public function findOrCreateUser($googleUser)
{
$authUser = User::firstOrNew(['email' => $googleUser->email]);
$authUser->token = Crypt::encrypt(json_encode($googleUser->token));
$authUser->save();
return $authUser;
}
/**
* Given an array of formatted user data,
* return a valid user model
*
* @param array $userData
* @return static
*/
public function findByEmailOrCreate($userData)
{
//find user by email
$user = User::firstOrNew(['email' => $userData['email']]);
//save all new data to the record
$user->save($userData);
return $user;
}
/**
* Obtain the user information from GitHub.
*
* @return Response
*/
public function handleProviderCallback()
{
$gitUser = Socialite::driver('github')->user();
$user = User::firstOrNew(['username' => $gitUser->nickname, 'name' => $gitUser->name, 'email' => $gitUser->email]);
$user->github_token = $gitUser->token;
$user->save();
auth()->login($user);
return redirect('/gists');
}
public function getFacebookCallback(Request $req)
{
$user = \Socialite::with('facebook')->user();
$data = array('name' => $user->name, 'email' => $user->email, 'password' => $req['code']);
$request = new Request();
$request = User::firstOrNew($data);
$request->save();
Auth::login($request);
return redirect('');
}
/**
* Obtain the user information from FaceBook.
*
* @return Response
*/
public function handleProviderCallback()
{
$user = Socialite::driver('facebook')->user();
// create in database if null
$save = User::firstOrNew(array('name' => $user->getName(), 'username' => $user->getNickname(), 'email' => $user->getEmail(), 'avatar' => $user->getAvatar(), 'provider' => 'facebook', 'provider_id' => $user->getId()));
$save->save();
//put id and name into session
Session::put('provider_id', $user->getId());
Session::put('name', $user->getName());
return redirect('/main');
}
public function requireAuthenticationForRoute(FunctionalTester $I)
{
$I->dontSeeAuthentication();
$I->amOnPage('/secure');
$I->seeCurrentUrlEquals('/auth/login');
$I->see('Login');
$I->amLoggedAs(User::firstOrNew($this->userAttributes));
$I->amOnPage('/secure');
$I->seeResponseCodeIs(200);
$I->see('Hello World');
}
public function findByEmailOrCreate($userData)
{
$user = User::firstOrNew(['email' => $userData->email]);
if (!$user->exists) {
$name = $this->splitName($userData->name);
$user->f_name = $name[0];
$user->l_name = $name[1];
$user->save();
}
return $user;
}
/**
* Obtain the user information from Facebook.
*
* @return Response
*/
public function handleProviderCallback()
{
$user = Socialite::driver('facebook')->user();
$newUser = User::firstOrNew(['email' => $user->email]);
$newUser->name = $user->name;
$newUser->facebook_id = $user->id;
$newUser->first_name = $user->user['first_name'];
$newUser->last_name = $user->user['last_name'];
$newUser->save();
// dd($newUser);
Auth::login($newUser, true);
return redirect(route('alerts.index'));
}
private function updateUsers($data)
{
foreach ($data as $row) {
$user = User::firstOrNew(['id' => $row->id]);
$user->name = $row->name;
$user->email = $row->email;
$user->thumb_url = $row->thumb_url;
$user->about = $row->about;
$user->phone = $row->phone;
$user->facebook = $row->facebook;
$user->save();
}
return '/admin/user';
}
public function socialCallback($provider)
{
$socialProviderType = SocialProviderType::where('name', $provider)->first();
$socialProviderData = Socialize::with($provider)->user()->map([]);
$socialProvider = SocialProvider::where('social_provider_id', $socialProviderData->id)->where('social_provider_type_id', $socialProviderType->id)->first();
if (Auth::check()) {
$user = Auth::user();
if (!$socialProvider) {
$socialProvider = new SocialProvider();
$socialProvider->token = isset($socialProviderData->token) ? $socialProviderData->token : null;
$socialProvider->social_provider_id = isset($socialProviderData->id) ? $socialProviderData->id : null;
$socialProvider->token_secret = isset($socialProviderData->tokenSecret) ? $socialProviderData->tokenSecret : '';
$socialProvider->social_provider_type_id = $socialProviderType->id;
$socialProvider->nickname = '' + $socialProviderData->nickname;
$socialProvider->email = $socialProviderData->email;
$socialProvider->name = $socialProviderData->name;
$socialProvider->avatar = $socialProviderData->avatar;
$socialProvider->other_provider_info = \Psy\Util\Json::encode($socialProviderData);
$socialProvider->save();
$user->socialProviders()->save($socialProvider);
Auth::login($user);
}
} else {
if ($socialProvider) {
Auth::login($socialProvider->user);
} else {
$socialProvider = new SocialProvider();
$socialProvider->token = isset($socialProviderData->token) ? $socialProviderData->token : null;
$socialProvider->social_provider_id = isset($socialProviderData->id) ? $socialProviderData->id : null;
$socialProvider->token_secret = isset($socialProviderData->tokenSecret) ? $socialProviderData->tokenSecret : '';
$socialProvider->social_provider_type_id = $socialProviderType->id;
$socialProvider->nickname = '' + $socialProviderData->nickname;
$socialProvider->email = $socialProviderData->email;
$socialProvider->name = $socialProviderData->name;
$socialProvider->avatar = $socialProviderData->avatar;
$socialProvider->other_provider_info = \Psy\Util\Json::encode($socialProviderData);
$socialProvider->save();
$user = User::firstOrNew(['email' => $socialProvider->email]);
$user->name = isset($user->name) ? $user->name : $socialProvider->name;
$user->username = null;
$user->password = null;
$user->email = isset($user->email) ? $user->email : $socialProvider->email;
$user->avatar = isset($user->avatar) ? $user->avatar : $socialProvider->avatar;
$user->save();
$user->socialProviders()->save($socialProvider);
Auth::login($user);
}
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$credentials = ['email' => $this->argument('email')];
$user = User::firstOrNew($credentials);
if (!$user->isDirty()) {
$this->info('User already exists');
return;
}
$user->name = $this->argument('name');
$user->rights = $this->option('admin') ? ['admin'] : [];
$user->save();
\Password::sendResetLink($credentials, function (Message $message) {
$message->subject('Velkommen til ub-baser');
});
$this->info('User created, email sent to ' . $user->email . '.');
}
public function run()
{
$email = env('ADMIN_EMAIL');
if ($email === null) {
throw new Exception('ADMIN_EMAIL environment variable not set');
}
$password = env('ADMIN_PASSWORD');
if ($password === null) {
throw new Exception('ADMIN_PASSWORD environment variable not set');
}
$user = User::firstOrNew(['email' => $email]);
$user->password = app('hash')->make($password);
$user->name = 'Admin User';
$user->save();
$this->command->info("Admin user {$email} created successfully.");
}
/**
* Obtain the user information from GitHub.
*
* @return Response
*/
public function handleProviderCallback($provider)
{
$providerUser = Socialite::driver($provider)->user();
$user = User::firstOrNew(['email' => $providerUser->getEmail()]);
if (!$user->exists) {
$user->first_name = $providerUser->user['name']['givenName'];
$user->last_name = $providerUser->user['name']['familyName'];
$user->password = bcrypt(\Illuminate\Support\Str::quickRandom());
$user->save();
}
try {
Auth::login($user, true);
} catch (Exception $ex) {
return redirect()->intended('/');
}
return redirect()->intended('home');
}
/**
* Find or Create a new user
*
* @param $socialUser
* @param $provider
* @return mixed
*/
protected function findOrCreateSocialUser($socialUser, $provider)
{
$userData = ['name' => $socialUser->name, 'email' => $socialUser->email, 'provider' => $provider, 'provider_id' => $socialUser->id, 'photo_url' => $socialUser->avatar, 'confirmed' => true];
//check if user already registered via provider
$user = User::firstOrNew(['provider_id' => $userData['provider_id']]);
if ($user->exists) {
return $user;
}
//if not check if there's already a user with this email address
$user = User::firstOrNew(['email' => $userData['email']]);
if ($user->exists) {
$user->forceFill($userData)->save();
return $user;
}
//create a new user
$user->forceFill($userData)->save();
return $user;
}
public function run()
{
$this->command->info("Seeding admin user.");
if (User::count() === 0) {
// Generate a password.
$password = [];
for ($i = 0; $i < 4; ++$i) {
$password[] = static::$potential_pass_words[array_rand(static::$potential_pass_words)];
}
$password = implode($password, " ");
// Create the user.
$user = User::firstOrNew(['user_id' => 1]);
$user->username = "******";
$user->password = bcrypt($password);
$user->save();
$this->command->info("User \"Admin\" has been created with the following password:\n{$password}");
} else {
$this->command->info("Skipped. Users exist.");
}
}
/**
* add or update organization by superadmin
* @param null $orgId
* @param array $orgDetails
* @return mixed|void
*/
public function saveOrganization(array $orgDetails, $orgId = null)
{
try {
$this->database->beginTransaction();
$orgData = $this->makeOrganizationData($orgDetails);
$organization = $this->organization->firstOrNew(['id' => $orgId]);
$organization->fill($orgData)->save();
$adminData = $this->makeAdminData($orgDetails, $organization->id);
$user = $this->user->firstOrNew(['org_id' => $organization->id]);
$user->fill($adminData)->save();
$settingsData = $this->makeSettingsData($orgDetails, $organization->id);
$settings = $this->settings->firstOrNew(['organization_id' => $organization->id]);
$settings->fill($settingsData)->save();
$this->database->commit();
$this->logger->info($orgId ? 'Organization information Updated' : 'Organization added');
$this->dbLogger->activity($orgId ? "activity.organization_updated" : "activity.organization_added", ['user_id' => $user->id, 'organization_id' => $orgId]);
} catch (Exception $exception) {
$this->database->rollback();
$this->logger->error($exception, ['settings' => $orgDetails]);
}
}
public function addToSap($request, $datos)
{
try {
if ((bool) $datos == true) {
//datos de Compania
$nombreEmpresa = $request->get('nombreEmpresa');
$grupoGiro = $request->get('grupoGiro');
$rfc = $request->get('rfc');
//datos de usuario Contacto
$nombre = $request->get('nombre');
$telefonoc = $request->get('num_telefono');
$apellido = $request->get('apellido');
$email = Auth::user()->email;
//datos de facturacion
$fcalle = $request->get('Fcalle');
$fcolonia = $request->get('Fcolonia');
$fciudad = $request->get('Fciudad');
$fmunicipio = $request->get('Fmunicipio');
$festado = $request->get('Festado');
$fcp = $request->get('Fcp');
$fnumero = $request->get('Fnumero');
$fpais = "MX";
if (isset($_POST['DentreI'])) {
// si esta marcada la casilla tomar los mismos datos
$en_calle = $request->get('Fcalle');
$en_colonia = $request->get('Fcolonia');
$en_ciudad = $request->get('Fciudad');
$en_municipio = $request->get('Fmunicipio');
$en_estado = $request->get('Festado');
$en_cp = $request->get('Fcp');
$en_numero = $request->get('Fnumero');
$en_pais = "MX";
} else {
// si NO esta marcada
$en_calle = $request->get('en_calle');
$en_colonia = $request->get('en_colonia');
$en_ciudad = $request->get('en_ciudad');
$en_municipio = $request->get('en_municipio');
$en_estado = $request->get('en_estado');
$en_cp = $request->get('en_cp');
$en_numero = $request->get('en_numero');
$en_pais = "MX";
}
$businessP = (string) "<CardName>" . $nombreEmpresa . "</CardName>\n \t\t<GroupCode>" . $grupoGiro . "</GroupCode>\n \t\t<FederalTaxID>" . $rfc . "</FederalTaxID>\n \t\t<ContactPerson>" . $nombre . "</ContactPerson>";
$dirEnvio = (string) "<Street>" . $en_calle . "</Street>\n \t\t<Block>" . $en_colonia . "</Block>\n \t\t<ZipCode>" . $en_cp . "</ZipCode>\n \t\t<City>" . $en_ciudad . "</City>\n \t\t<County>" . $en_municipio . "</County>\n \t\t<Country>" . $en_pais . "</Country>\n \t\t<State>" . $en_estado . "</State>\n \t\t<StreetNo>" . $en_numero . "</StreetNo>";
$dirFactura = (string) "<Street>" . $fcalle . "</Street>\n \t\t<Block>" . $fcolonia . "</Block>\n \t\t<ZipCode>" . $fcp . "</ZipCode>\n \t\t<City>" . $fciudad . "</City>\n\t\t <County>" . $fmunicipio . "</County>\n \t\t <Country>" . $fpais . "</Country>\n \t\t<State>" . $festado . "</State>\n \t\t<StreetNo>" . $fnumero . "</StreetNo>";
$personaContacto = (string) "<Name>" . $nombre . "</Name>\n \t\t\t\t<Phone1>" . $telefonoc . "</Phone1>\n \t\t\t\t<E_Mail>" . $email . "</E_Mail>\n \t\t\t\t<FirstName>" . $nombre . "</FirstName>\n \t\t\t\t<LastName>" . $apellido . "</LastName>";
$ID = Session::get('UserId');
$client = Session::get('Client');
//$ID = Sap::getId();
//$client = Sap::getClientSoap();
$carcode = Auth::user()->sapResultado;
$result = $client->call('updateLeadtoCustomer', array('id' => $ID, 'cardCodeLead' => $carcode, 'businessP' => $businessP, 'dirEnvio' => $dirEnvio, 'dirFactura' => $dirFactura, 'personaContacto' => $personaContacto));
$respuesta = (string) $result['updateLeadtoCustomerResult'];
//dd($respuesta);
if (preg_match("/C\\d+/", $respuesta)) {
$user = User::firstOrNew(['id' => Auth::user()->id]);
$user->nombre = $nombre;
$user->telefono = $telefonoc;
$user->apellido = $apellido;
$user->sapResultado = $respuesta;
$user->RFC = $rfc;
$user->grupoGiro = $grupoGiro;
$user->nombreEmpresa = $nombreEmpresa;
$user->save();
$dirEntrega = DirEntrega::firstOrNew(['user_id' => Auth::user()->id]);
$dirEntrega->calle = $en_calle;
$dirEntrega->colonia = $en_colonia;
$dirEntrega->ciudad = $en_ciudad;
$dirEntrega->cp = $en_cp;
$dirEntrega->municipio = $en_municipio;
$dirEntrega->estado = $en_estado;
$dirEntrega->pais = $en_pais;
$dirEntrega->num_calle = $en_numero;
$dirEntrega->save();
$dirFactura = DirFactura::firstOrNew(['user_id' => Auth::user()->id]);
$dirFactura->calle = $fcalle;
$dirFactura->colonia = $fcolonia;
$dirFactura->ciudad = $fciudad;
$dirFactura->cp = $fcp;
$dirFactura->municipio = $fmunicipio;
$dirFactura->estado = $festado;
$dirFactura->pais = $fpais;
$dirFactura->num_calle = $fnumero;
$dirFactura->save();
}
} else {
//si los datos no son editados en la vista check_info
}
return 1;
} catch (Exception $e) {
return 0;
}
}
public function twitterCallback()
{
$data = Input::all();
$u = ["provider" => "twitter", "provider_id" => $data["provider_id"], "name" => $data["name"], "email" => $data["email"], "avatar" => $data["avatar"]];
$med_user = User::firstOrNew(['email' => $u["email"]]);
$med_user->fill($u);
$med_user->save();
Auth::loginUsingId($med_user->id);
//return new RedirectResponse(url('/home'));
return redirect()->intended('home');
//var_dump($user);
// $user->token;
}
/**
* Obtain the user information from GitHub.
*
* @return Response
*/
public function handleProviderCallback()
{
$user = Socialite::driver('facebook')->user();
$UserFind = User::firstOrNew(['email' => $user->id]);
$UserFind->full_name = $user->name;
$UserFind->name = $user->name;
$UserFind->facebook_id = $user->id;
$UserFind->facebook_token = $user->token;
$UserFind->position_longitude = "-70.584075208";
$UserFind->position_latitude = "-33.415208";
$UserFind->save();
return redirect('/dashboard');
return response()->json($UserFind);
}
