Admin Control Center — WMSU CE Batch 2001

Operations Overview

Live counts across the whole CE2001 platform.

Committee Management

Members, mandates, terms & documents — auto-published to the Governance section via the public db_committees feed.

Committee	Chair	Members	Term	Docs

Articles — Submission, Review & Publishing

draft → review → approved → published · every save versioned in ArticleVersions · published items feed News / Programs / Awards / AMSAP / Legacy via db_articles.

Title	Section	Author	Status	v	Updated

Certificates & ID Design Studio

The full WYSIWYG studio (templates, dynamic fields, Google Slides → PDF → Drive) lives in the existing consoles; QR verification is live below.

Open Design Studio →Alumni ID & Certificate templates, presets, PDF generation to Drive (Designs / Certificates sheets) Awards certificate designer →Award-category certificate templates & batch issuance

🔍 QR Verification API tester

Credential / Alumni ID

Public portal →

Endpoint: ?action=ac_verify&id=… — embedded in every issued ID/certificate QR.

Awards & Nomination Panel

Categories, nominees, blind scoring, live consolidation and certificate generation run in the dedicated console (AwardCategories / Nominees / AwardCommittee sheets).

Open Awards Console →Category manager · nominee pipeline · blind evaluator scoring · real-time consolidation · certificate output Public nominations page →What members see

Events & Check-In

Live attendance from the Registration / RSVP / CheckIn sheets.

QR Check-In scanner →Event-day check-in / check-out console Participants Directory →Who's registered & attending Events calendar →Public schedule

Membership & Directory Admin

Profile edits, registration approval, credential (re)issuance and directory visibility run in the verification console; payment overrides in the WP dashboard admin tab.

Verification console →Approve / hide / edit alumni · issue & reissue IDs and certificates · endorsement moderation WP admin overrides →Verify · mark membership paid · record certificates (Admin tab) Public directory →What the world sees

AMSAP Support Confidential

Alumni Mutual Support Assistance Program — visible to Admin & Secretariat roles only. Intake endpoint: db_amsap_submit.

Case	Requester	Summary	Priority	Status	Handler

Legacy Hub & Donor Wall

Pledges, donations and sponsors are managed in the Finance console; the public Donor Wall auto-updates from the same sheets; receipts go out via MailWish (donor_receipt template).

Finance console →Pledges · donations · sponsors · receipts Legacy Hub (public) →Projects & pledge wall Donor Wall (public) →Auto-updating from Sponsors/Pledges

💛 Send a donor receipt

Marketplace Moderation

Approve, feature, or hide alumni business listings. Approval emails the owner via MailWish automatically.

Business	Owner	Category	Rating	Status

Project Impact Map — Verification

Verify submitted projects before they appear on the Global Map and Gallery. Verification emails the submitter via MailWish. Correct coordinates during review if needed.

Project	Location	Year	Submitter	Pin	Status

Gallery — Photo Moderation

Alumni uploads land in Drive's _Pending_Uploads and this queue. Approve moves the photo into its album (live within 5 minutes); Reject trashes it. Everything is logged in the UploadLog sheet.

Photo	Uploader	Album	Caption

Communications & Email Automation

All mail flows through MailWish (Mail.gs). Queue bulk sends, watch the log, monitor the hourly worker.

📣 Bulk send

Audience Template Variables (JSON — e.g. {"event_title":"Gala","message":"…"})

⏱ Queue status

—

Hourly worker drains BulkQueue at ≤ MAIL_HOURLY_LIMIT (MailWish ~300/hr cap).

📜 EmailLog (latest 100)

Time	To	Subject	Template	Committee	Status

Settings & Security

Role-based access · API-key status (values never shown) · full audit trail.

👮 Roles

Email	Role	Committee	Active

Permission matrix — admin: everything · secretariat: all ops except this module · editor: articles + comms · chair: own committee + article submit/review. Chairman/Secretariat from the Awards Committee sheet are admins automatically.

🔑 API keys (Script Properties)

Key	Status	Preview

Values are write-only — set them in Apps Script → Project Settings. Secrets show last-4 only.

🧾 Audit log (latest 150)

Time	Who	Action	Detail