Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'default' => env('DB_CONNECTION', 'mysql'),
- 'connections' => [
- 'mysql' => [
- 'driver' => 'mysql',
- 'host' => env('DB_HOST', 'localhost'),
- 'port' => env('DB_PORT', '3306'),
- 'database' => env('DB_DATABASE', 'erptenants'),
- 'username' => env('DB_USERNAME', 'root'),
- 'password' => env('DB_PASSWORD', ''),
- 'charset' => 'utf8',
- 'collation' => 'utf8_unicode_ci',
- 'prefix' => '',
- 'strict' => false,
- 'engine' => null,
- ],
- 'tenant' => [
- 'driver' => 'mysql',
- 'host' => env('DB_HOST', ''),
- 'port' => env('DB_PORT', '3306'),
- 'database' => env('DB_DATABASE', ''),
- 'username' => env('DB_USERNAME', ''),
- 'password' => env('DB_PASSWORD', ''),
- 'charset' => 'utf8',
- 'collation' => 'utf8_unicode_ci',
- 'prefix' => '',
- 'strict' => false,
- 'engine' => null,
- ],
- ],
- class TenantIdentification
- {
- public function handle($request, Closure $next)
- {
- $tk = "HYD"; //hardcoded for time being
- $tenant = AppModelsTenant::where('tenantKey', $tk)->first();
- Config::set('database.connections.tenant.host', env('DB_HOST', $tenant ->host));
- Config::set('database.connections.tenant.username', env('DB_USERNAME', $tenant ->username));
- Config::set('database.connections.tenant.password', env('DB_PASSWORD', $tenant ->password));
- Config::set('database.connections.tenant.database', env('DB_DATABASE', $tenant ->database));
- return $next($request);
- }
- }
- <?php
- namespace AppModels;
- use IlluminateFoundationAuthUser as Authenticatable;
- class User extends Authenticatable
- {
- protected $connection = 'tenant';
- /**
- * The attributes that are mass assignable.
- *
- * @var array
- */
- protected $fillable = [
- 'name', 'email', 'password',
- ];
- /**
- * The attributes that should be hidden for arrays.
- *
- * @var array
- */
- protected $hidden = [
- 'password', 'remember_token',
- ];
- }
- public function verify(Request $request)
- {
- $username = $request->username;
- $password = $request->password;
- $user = AppModelsUser::where('username',$username)->where('password',$password)->first();
- var_dump($user);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement