Changeset 6351545 in Klonkt for src/routes/admin.js
- Timestamp:
- 06/14/2026 08:18:50 AM (3 months ago)
- Branches:
- main
- Children:
- 07775b7
- Parents:
- 9e27d64
- File:
-
- 1 edited
-
src/routes/admin.js (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
src/routes/admin.js
r9e27d64 r6351545 9 9 import { renderPage } from '../middleware/render.js'; 10 10 import { requireGod } from '../middleware/auth.js'; 11 import { getTenancy } from '../services/SettingsService.js'; 11 12 12 13 const router = express.Router(); 13 14 14 15 router.get('/', requireGod, (req, res) => { 16 const tenancy = getTenancy(); 17 18 // De primaire/owner-site — in solo dé site, in hub de hoofdsite. Geeft de 19 // "Uiterlijk"-tegel z'n edit-link. 20 const primarySite = db.prepare( 21 'SELECT slug, title FROM sites ORDER BY created_at ASC LIMIT 1' 22 ).get() || null; 23 15 24 const stats = { 16 25 users: db.prepare('SELECT COUNT(*) AS c FROM users').get().c, … … 22 31 }; 23 32 24 const sites = db.prepare(` 33 // Sites/users-tabellen zijn alleen in hub relevant; in solo besparen we de query. 34 const sites = tenancy === 'hub' ? db.prepare(` 25 35 SELECT s.slug, s.title, s.created_at, u.username AS owner_username 26 36 FROM sites s … … 28 38 ORDER BY s.created_at DESC 29 39 LIMIT 50 30 `).all() ;40 `).all() : []; 31 41 32 const users = db.prepare(`42 const users = tenancy === 'hub' ? db.prepare(` 33 43 SELECT username, email, role, created_at 34 44 FROM users 35 45 ORDER BY created_at DESC 36 46 LIMIT 50 37 `).all() ;47 `).all() : []; 38 48 39 49 renderPage(req, res, 'pages/admin', { 40 pageTitle: ' Admin',50 pageTitle: 'Beheer', 41 51 bodyClass: 'on-admin', 52 tenancy, 53 primarySite, 42 54 stats, 43 55 sites,
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)