Title = 'Hostované projekty'; $this->ParentClass = 'PageNetwork'; } function Show(): string { $Output = '
'; $DbResult = $this->Database->query('SELECT NetworkDevice.Name as ServerName, HostedProject.Name, HostedProject.Homepage, HostedProject.TimeCreate, User.Name AS UserName FROM HostedProject JOIN User ON User.Id = HostedProject.User JOIN NetworkDevice ON NetworkDevice.Id = HostedProject.Server ORDER BY HostedProject.Name'); while ($DbRow = $DbResult->fetch_assoc()) { $Output .= ''; } $Output .= '

Název projektu	Založeno	Umístění na serveru	Zodpovědná osoba
'.$DbRow['Name'].'	'.HumanDate($DbRow['TimeCreate']).'	'.$DbRow['ServerName'].'	'.$DbRow['UserName'].'

'; return $Output; } }