Index: src/routes/admin-seo.js =================================================================== --- src/routes/admin-seo.js (revision 662345333cce064d12731d86e9a2ede2f4b6805c) +++ src/routes/admin-seo.js (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -0,0 +1,99 @@ +/** + * Admin: geavanceerde SEO-instellingen van de primaire site. + * + * GET /admin/seo -> formulier met alle SEO/social-velden van de hoofdsite + * POST /admin/seo -> opslaan (god-only) + * + * Deze velden worden al door de (shell.ejs) en de JSON-LD/OpenGraph- + * tags geconsumeerd, maar waren tot nu toe nergens te bewerken. De basis- + * velden (titel/bio/robots) blijven in Uiterlijk; dit is de geavanceerde laag: + * titel-sjabloon, canonical, social-share-afbeelding, verificatie-metas, + * publisher/JSON-LD en OpenGraph-locale. + * + * Werkt op de PRIMAIRE site (solo = de enige site; hub = de bedrijfssite). + */ + +import express from 'express'; +import db from '../config/database.js'; +import { renderPage } from '../middleware/render.js'; +import { requireGod } from '../middleware/auth.js'; +import { getPrimarySite } from '../middleware/site.js'; + +const router = express.Router(); + +function trimOrNull(v, max) { + const s = (v == null ? '' : String(v)).trim(); + return s ? s.slice(0, max) : null; +} + +// ==================== FORM ==================== +router.get('/', requireGod, (req, res) => { + const primary = getPrimarySite(); + if (!primary) { + return res.redirect('/admin/sites/new?error=' + encodeURIComponent('Maak eerst een site aan')); + } + const site = db.prepare('SELECT * FROM sites WHERE id = ?').get(primary.id); + + renderPage(req, res, 'pages/admin-seo', { + pageTitle: 'SEO', + bodyClass: 'on-admin', + site, + success: req.query.success || null, + error: req.query.error || null, + }); +}); + +// ==================== SAVE ==================== +router.post('/', requireGod, (req, res) => { + const primary = getPrimarySite(); + if (!primary) return res.redirect('/admin/seo?error=' + encodeURIComponent('Geen site gevonden')); + + const f = req.body; + const schemaType = f.schema_type === 'Organization' ? 'Organization' : 'Person'; + + db.prepare(` + UPDATE sites SET + robots_index = ?, + title_template = ?, + canonical = ?, + default_description = ?, + og_image_default = ?, + og_locale = ?, + author = ?, + twitter = ?, + facebook_app_id = ?, + google_verification = ?, + bing_verification = ?, + pinterest_verification = ?, + yandex_verification = ?, + schema_type = ?, + publisher_name = ?, + publisher_url = ?, + publisher_logo = ?, + updated_at = CURRENT_TIMESTAMP + WHERE id = ? + `).run( + f.robots_index ? 1 : 0, + (f.title_template || '{title} — {site}').slice(0, 200), + trimOrNull(f.canonical, 200), + trimOrNull(f.default_description, 500), + trimOrNull(f.og_image_default, 500), + trimOrNull(f.og_locale, 32), + trimOrNull(f.author, 120), + trimOrNull(f.twitter, 64), + trimOrNull(f.facebook_app_id, 64), + trimOrNull(f.google_verification, 200), + trimOrNull(f.bing_verification, 200), + trimOrNull(f.pinterest_verification, 200), + trimOrNull(f.yandex_verification, 200), + schemaType, + trimOrNull(f.publisher_name, 200), + trimOrNull(f.publisher_url, 200), + trimOrNull(f.publisher_logo, 500), + primary.id, + ); + + res.redirect('/admin/seo?success=' + encodeURIComponent('SEO-instellingen opgeslagen')); +}); + +export default router; Index: src/routes/admin-sites.js =================================================================== --- src/routes/admin-sites.js (revision 0dbb5c14a391c55db20fd75acf91c9876095ea7e) +++ src/routes/admin-sites.js (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -303,7 +303,4 @@ feed_view_default = ?, feed_view_switch = ?, show_search = ?, show_archive_link = ?, - title_template = ?, twitter = ?, canonical = ?, - google_verification = ?, bing_verification = ?, - pinterest_verification = ?, yandex_verification = ?, custom_css = ?, custom_head_html = ?, custom_foot_html = ?, updated_at = CURRENT_TIMESTAMP @@ -330,11 +327,4 @@ f.show_search ? 1 : 0, f.show_archive_link ? 1 : 0, - (f.title_template || '{title} — {site}').slice(0, 200), - (f.twitter || '').slice(0, 64) || null, - (f.canonical || '').slice(0, 200) || null, - (f.google_verification || '').slice(0, 200) || null, - (f.bing_verification || '').slice(0, 200) || null, - (f.pinterest_verification || '').slice(0, 200) || null, - (f.yandex_verification || '').slice(0, 200) || null, f.custom_css || null, f.custom_head_html || null, Index: src/server.js =================================================================== --- src/server.js (revision 0dbb5c14a391c55db20fd75acf91c9876095ea7e) +++ src/server.js (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -33,4 +33,5 @@ import adminCommentsRoutes from './routes/admin-comments.js'; import adminSettingsRoutes from './routes/admin-settings.js'; +import adminSeoRoutes from './routes/admin-seo.js'; import prutterRoutes from './routes/prutter.js'; import audioRoutes from './routes/audio.js'; @@ -245,4 +246,5 @@ app.use('/admin/comments', adminCommentsRoutes); app.use('/admin/settings', adminSettingsRoutes); +app.use('/admin/seo', adminSeoRoutes); app.use('/admin/circle', adminCircleRoutes); app.use('/admin/updates', adminUpdatesRoutes); Index: src/views/pages/admin-seo.ejs =================================================================== --- src/views/pages/admin-seo.ejs (revision 662345333cce064d12731d86e9a2ede2f4b6805c) +++ src/views/pages/admin-seo.ejs (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -0,0 +1,104 @@ +
+

← Beheer

+

SEO & vindbaarheid

+

Geavanceerde SEO van <%= site.title %> — hoe je site in zoekmachines en bij het delen op social media verschijnt.

+ + <% if (typeof success !== 'undefined' && success) { %>
<%= success %>
<% } %> + <% if (typeof error !== 'undefined' && error) { %>
<%= error %>
<% } %> + +
+ +
+ Indexeren + +
+ +
+ Titel & omschrijving + + + + +
+ +
+ Delen op social media + + + + +
+ +
+ Uitgever (JSON-LD / rich results) + + + + +
+ +
+ Zoekmachine-verificatie + + + + +
+ + +
+
Index: src/views/pages/admin-site-edit.ejs =================================================================== --- src/views/pages/admin-site-edit.ejs (revision 0dbb5c14a391c55db20fd75acf91c9876095ea7e) +++ src/views/pages/admin-site-edit.ejs (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -226,37 +226,8 @@ -
+
SEO & social - - - -
- Zoekmachine-verificatie - - - - -
+

Titel-sjabloon, canonical, deel-afbeelding, verificatie-metas en meer staan + nu op een eigen pagina: 🔎 SEO & vindbaarheid.

Index: src/views/pages/admin.ejs =================================================================== --- src/views/pages/admin.ejs (revision 0dbb5c14a391c55db20fd75acf91c9876095ea7e) +++ src/views/pages/admin.ejs (revision 662345333cce064d12731d86e9a2ede2f4b6805c) @@ -14,4 +14,5 @@ 📃 Playlists 💬 Reacties + <% if (primarySite) { %>🔎 SEO<% } %> ⚙️ Instellingen <% } else { %> @@ -27,4 +28,5 @@ 🔗 Cirkel <% } %> + <% if (primarySite) { %>🔎 SEO<% } %> ⚙️ Instellingen <% } %>