28 lines
591 B
PHP
28 lines
591 B
PHP
<?php
|
|
|
|
namespace App\Model\Facade;
|
|
|
|
use Nette\Database\Connection;
|
|
|
|
class DatabazeFacade
|
|
{
|
|
public function __construct(
|
|
private Connection $masterDb
|
|
) {
|
|
}
|
|
|
|
/**
|
|
* Seznam databází z master tabulky LOGIN (jeden login = jedna databáze).
|
|
*
|
|
* @return \Nette\Database\Row[]
|
|
*/
|
|
public function getAll(): array
|
|
{
|
|
return $this->masterDb->fetchAll(
|
|
'SELECT ID, EMAIL, POSLEDNI_PRIHLASENI, AKTIVNI, [DATABASE], [SERVER], FIRMA_ID, IS_ADMIN
|
|
FROM dbo.LOGIN
|
|
ORDER BY [DATABASE], EMAIL'
|
|
);
|
|
}
|
|
}
|