static function vypis_zoznam()
{
$db = napoj_db();
$sql = <<<EOF
SELECT * from POUZIVATELIA LEFT JOIN oddiely ON POUZIVATELIA.id_oddiel=oddiely.id ORDER BY oddiely.id IS NULL, oddiely.nazov;;
EOF;
$akt_oddiel = ".";
$ret = $db->query($sql);
while ($row = $ret->fetchArray(SQLITE3_ASSOC)) {
if ($akt_oddiel != $row['nazov']) {
$akt_oddiel = $row['nazov'];
if ($akt_oddiel == "") {
echo "<h2 class=ZC_nadpis>Bez oddielu</h2>";
} else {
echo "<h2 class=ZC_nadpis>" . $akt_oddiel . "</h2>";
}
}
POUZIVATELIA::vypis_profil($row);
}
//echo "Operation done successfully"."<br>";
$db->close();
}
