<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use DB;
class Zoom extends Model
{
	public function is_table_empty() {
		$result = DB::table('zoom_oauth')
                     ->select(DB::raw('count(*) as totalcount'))
                     ->where('provider', '=', 'zoom')
                     ->first();
        if($result->totalcount < 0) {
            return false;
        }
 
        return true;
    }
 
    public function get_access_token() {
        $result = DB::table('zoom_oauth')->select('provider_value')->where('provider', '=', 'zoom')->first();
        return json_decode($result->provider_value);
    }
 
    public function get_refresh_token() {
        $result = $this->get_access_token();
        return $result->refresh_token;
    }
 
    public function update_access_token($token) {
        if($this->is_table_empty()) {
        	DB::table('zoom_oauth')->insert(['provider' => 'zoom', 'provider_value' => $token]);
        } else {
        	DB::table('zoom_oauth')->where('provider', '=', 'zoom')->update(array('provider_value' => $token));
        }
    }

}