<?php

namespace App\Models;

use Config;
use App;
use DB;
use Illuminate\Database\Eloquent\Model;

class Registration extends Model
{
	/**
	 * init var for table, which is set up in the constructor
	 */
	protected $table;

	/**
	 * Primary Key
	 * @var string
	 */
	protected $primaryKey = 'RegistrationID';
	
	function __construct($attributes = [])
	{  	
		parent::__construct($attributes);

        /**
         * there is no table, only a mssql function, see query line 35
         */
        $this->table = false;
    }

    public static function getRegistrationFromCustomQuery($registrationId, $type)
    {
        $locale = App::getLocale();
        $service = "GP"; 
        
        if($type == "reg") {
            // $search = [$registrationId, null, null, $locale, $service];
            $search = [$registrationId, null, null, null, null];
        }else if ($type == "vin") {
            // $search = [null, $registrationId, null, $locale, $service];
            $search = [null, $registrationId, null, null, null];
        }else{
            // $search = [null, null, $registrationId, $locale, $service];
            $search = [null, null, $registrationId, null, null];
        }

    	// return DB::select('SELECT * FROM ' . Config::get('app.registration_db_functions') . '(?,?,?,?,?)', $search);
        return DB::select('SELECT * FROM ' . Config::get('app.registration_db_functions') . '(?,?,?,?,?)', $search);
    }
}