public function department_list($name,$id)
	{
		$product_list = Product::select('product.product_id','product.name','product.description',
			'product.price','product.discounted_price','product.thumbnail')
			->join('product_category','product.product_id','product_category.product_id')
			->join('category','product_category.category_id','category.category_id')
			->where('product.display',2)
			->orWhere('product.display',3)
			->Where('category.department_id',$id)
			->orderBy('product.name')
			->paginate(20);	
		    return view('products.product_list',['product_list'=>$product_list]);
	     }

 	public function up()
	{
		Schema::create('users',
			function (Blueprint $table)
			{
				$table->increments('id');
				$table->string('name',50);
				$table->string('email',50)->unique();
				$table->string('role',10)->default('user');
				$table->string('first_name',50)->default('');
				$table->string('last_name',60)->default('');
				$table->string('mob_phone',15)->default('');
				$table->string('address',50)->default('');
				$table->string('house',10)->default('');
				$table->string('apartment',10)->default('');
				$table->tinyInteger('city_id')->default(0);
				$table->tinyInteger('country_id')->default(0);
                                $table->string('post_code',10)->default('');
                                $table->string('fir_name',50)->default('');
				$table->string('fir_code',12)->default('');
				$table->string('vat_code',12)->default('');
				$table->string('fir_phone',15)->default('');
				$table->string('fir_address',50)->default('');
				$table->string('fir_house',10)->default('');
				$table->string('fir_apartment',10)->default('');
				$table->tinyInteger('fir_city_id')->default(0);
				$table->tinyInteger('fir_country_id')->default(0);
                                $table->string('fir_post_code',10)->default('');
				$table->timestamp('email_verified_at')->nullable();
				$table->string('password',100);
				$table->rememberToken();
				$table->timestamps();
			});
	}

 protected function setDbFunctions( $params )
	{
		include_once getabspath("connections/dbfunctions/DBFunctions.php");
		
		$extraParams = array_merge($this->getDbFunctionsExtraParams(), $params);
		
		switch( $this->dbType )
		{
			case nDATABASE_MySQL:
				include_once getabspath("connections/dbfunctions/MySQLFunctions.php");
				$this->_functions = new MySQLFunctions( $extraParams );
			break;
			case nDATABASE_Oracle:
				include_once getabspath("connections/dbfunctions/OracleFunctions.php");
				$this->_functions = new OracleFunctions( $extraParams );
			break;
			case nDATABASE_MSSQLServer:
				include_once getabspath("connections/dbfunctions/MSSQLFunctions.php");
				$this->_functions = new MSSQLFunctions( $extraParams );
			break;
			case nDATABASE_Access:
				include_once getabspath("connections/dbfunctions/ODBCFunctions.php");
				$this->_functions = new ODBCFunctions( $extraParams );
			break;
			case nDATABASE_PostgreSQL:
				include_once getabspath("connections/dbfunctions/PostgreFunctions.php");
				$this->_functions = new PostgreFunctions( $extraParams );
			break;
			case nDATABASE_Informix:
				include_once getabspath("connections/dbfunctions/InformixFunctions.php");
				$this->_functions = new InformixFunctions( $extraParams );
			break;
			case nDATABASE_SQLite3:
				include_once getabspath("connections/dbfunctions/SQLite3Functions.php");
				$this->_functions = new SQLite3Functions( $extraParams );
			break;
			case nDATABASE_DB2:
			case 18:	//	iSeries
				include_once getabspath("connections/dbfunctions/DB2Functions.php");
				$this->_functions = new DB2Functions( $extraParams );
			break;
			default:
				include_once getabspath("connections/dbfunctions/GenericFunctions.php");
				$this->_functions = new GenericFunctions( $extraParams );
		}
	}

     'connections' => [

        'sqlite' => [
            'driver' => 'sqlite',
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
        ],

        'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

        'pgsql' => [
            'driver' => 'pgsql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'schema' => 'public',
            'sslmode' => 'prefer',
        ],

        'sqlsrv' => [
            'driver' => 'sqlsrv',
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', '1433'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
        ],
 ],