<?php

namespace App\Http\Controllers;

use Illuminate\Config\Repository;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Config;
use DB;
use Illuminate\Support\Facades\Session;

class ExternalLoginController extends Controller
{
    public function externLogin(Request $request) {
        $query = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME =  ?";
        $db = DB::select($query, [$request->get('database')]);
        if (empty($db)) {
            return redirect('https://my.binggo.co.id');
        } else {
            if (session_status() == PHP_SESSION_NONE) {
                session_start();
            }
            Config::set('database.connections.mysql.database', $request->get('database'));
            DB::purge('mysql');
            DB::reconnect('mysql');
            $login = Auth::attempt(['username' => $request->get('username'), 'password' => $request->get('password')], true);
            if ($login) {
                // Authentication passed...
                // Session::put('db_name', $request->get('database'));
                // Session::put('db_username', $request->get('username'));
                // Session::put('db_password', $request->get('password'));
                // Session::save();
                // session_start();\
                $_SESSION['db_name'] = $request->get('database');
                // dd($_SESSION);
                return redirect()->route('dashboard.index');
            }
        }
    }
}