Advertisement
Guest User

Untitled

a guest
Mar 13th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. 'default' => env('DB_CONNECTION', 'mysql'),
  2.  
  3. 'connections' => [
  4. 'mysql' => [
  5. 'driver' => 'mysql',
  6. 'host' => env('DB_HOST', 'localhost'),
  7. 'port' => env('DB_PORT', '3306'),
  8. 'database' => env('DB_DATABASE', 'erptenants'),
  9. 'username' => env('DB_USERNAME', 'root'),
  10. 'password' => env('DB_PASSWORD', ''),
  11. 'charset' => 'utf8',
  12. 'collation' => 'utf8_unicode_ci',
  13. 'prefix' => '',
  14. 'strict' => false,
  15. 'engine' => null,
  16. ],
  17. 'tenant' => [
  18. 'driver' => 'mysql',
  19. 'host' => env('DB_HOST', ''),
  20. 'port' => env('DB_PORT', '3306'),
  21. 'database' => env('DB_DATABASE', ''),
  22. 'username' => env('DB_USERNAME', ''),
  23. 'password' => env('DB_PASSWORD', ''),
  24. 'charset' => 'utf8',
  25. 'collation' => 'utf8_unicode_ci',
  26. 'prefix' => '',
  27. 'strict' => false,
  28. 'engine' => null,
  29. ],
  30. ],
  31.  
  32. class TenantIdentification
  33. {
  34. public function handle($request, Closure $next)
  35. {
  36.  
  37. $tk = "HYD"; //hardcoded for time being
  38.  
  39. $tenant = AppModelsTenant::where('tenantKey', $tk)->first();
  40.  
  41. Config::set('database.connections.tenant.host', env('DB_HOST', $tenant ->host));
  42. Config::set('database.connections.tenant.username', env('DB_USERNAME', $tenant ->username));
  43. Config::set('database.connections.tenant.password', env('DB_PASSWORD', $tenant ->password));
  44. Config::set('database.connections.tenant.database', env('DB_DATABASE', $tenant ->database));
  45.  
  46.  
  47. return $next($request);
  48. }
  49. }
  50.  
  51. <?php
  52.  
  53. namespace AppModels;
  54.  
  55. use IlluminateFoundationAuthUser as Authenticatable;
  56.  
  57. class User extends Authenticatable
  58. {
  59. protected $connection = 'tenant';
  60. /**
  61. * The attributes that are mass assignable.
  62. *
  63. * @var array
  64. */
  65. protected $fillable = [
  66. 'name', 'email', 'password',
  67. ];
  68.  
  69. /**
  70. * The attributes that should be hidden for arrays.
  71. *
  72. * @var array
  73. */
  74. protected $hidden = [
  75. 'password', 'remember_token',
  76. ];
  77.  
  78.  
  79. }
  80.  
  81. public function verify(Request $request)
  82. {
  83.  
  84. $username = $request->username;
  85. $password = $request->password;
  86.  
  87. $user = AppModelsUser::where('username',$username)->where('password',$password)->first();
  88.  
  89. var_dump($user);
  90. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement