110 Commits
Author SHA1 Message Date
nmemmertandClaude Sonnet 5.5 a2fb3b056a Add free-type spell checker for students
Build and Push Docker Image / build-and-push (push) Successful in 1m5s
Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-19 17:01:02 -04:00
nmemmertandClaude Sonnet 4.6 91fe38c00d Fix parent doc viewer: sign comment permissions server-side
Build and Push Docker Image / build-and-push (push) Successful in 35s
Client-side permission overrides invalidated the JWT. Move the
comment-only config to a new PIN-protected endpoint that signs
the correct permissions before returning to the browser.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 16:38:34 -04:00
nmemmertandClaude Sonnet 4.6 3e53efd752 Allow parent to add comments on submitted documents
Build and Push Docker Image / build-and-push (push) Successful in 38s
Switch admin doc viewer from view mode to comment-only mode so the
parent can annotate student work without editing the text.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 15:44:07 -04:00
nmemmertandClaude Sonnet 4.6 3d1e887c19 Add cache-busting query strings and no-cache for HTML files
Build and Push Docker Image / build-and-push (push) Successful in 39s
Proxy was caching old admin.js; ?v=3 query string forces a fresh fetch.
Also extend no-cache header to .html files so future deploys propagate immediately.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 15:39:40 -04:00
nmemmertandClaude Sonnet 4.6 3eb6322427 Show error message in admin docs panel instead of staying on Loading
Build and Push Docker Image / build-and-push (push) Successful in 38s
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 15:01:41 -04:00
nmemmertandClaude Sonnet 4.6 ad3e0bc7be Fix editor full-screen and add parent-side doc viewer
Build and Push Docker Image / build-and-push (push) Successful in 45s
Student editor:
- Add body.docs-editor-open class when editor opens; hide hero, nav,
  confetti so nothing bleeds behind the fixed overlay

Admin docs panel:
- New "Documents" sidebar entry listing all submitted docs with student
  name, date, and unread badge
- Click any doc to open it in OnlyOffice in view (read-only) mode
- Download button for offline access
- /api/docs/bykey/:key/editor-config server route for admin viewer

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:54:38 -04:00
nmemmertandClaude Sonnet 4.6 6a5ac46294 Disable browser caching for CSS and JS files
Build and Push Docker Image / build-and-push (push) Successful in 39s
Prevents stale styles/scripts after deployments.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:40:45 -04:00
nmemmertandClaude Sonnet 4.6 402fbfa16d Raise docs editor z-index to 10000 to cover nav bar and all overlays
Build and Push Docker Image / build-and-push (push) Successful in 44s
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:36:55 -04:00
nmemmertandClaude Sonnet 4.6 4126a1bf55 Move docs editor overlay outside section so fixed positioning works
Build and Push Docker Image / build-and-push (push) Successful in 35s
The editor div was inside #tab-docs (.tab-panel) whose ancestor chain
could trap position:fixed. Moving it to a sibling of <section> so the
full-screen overlay covers the entire viewport unconditionally.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:33:24 -04:00
nmemmertandClaude Sonnet 4.6 9375332f6a Fix New Document button and make editor full-screen
Build and Push Docker Image / build-and-push (push) Successful in 35s
- Replace prompt() with inline title form (button → input → Create/Cancel)
- Editor view: position:fixed inset:0 z-index:200 so it covers full screen
- Docs editor toolbar moved into CSS (was duplicated in styles)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:29:01 -04:00
nmemmertandClaude Sonnet 4.6 95c0da5c51 Redesign student UI and add OnlyOffice document integration
Build and Push Docker Image / build-and-push (push) Successful in 33s
- Student section: new hero gradient header, fixed bottom nav bar with
  icon+label pills (Today/Courses/Spelling/Inbox/Docs)
- Today rows: card style with left accent stripe, lift on hover
- Course cards: grid layout with top color bar per course
- Docs tab: list view with doc cards, OnlyOffice editor embedded via
  iframe using server-signed JWT config
- Server: documents table, CRUD routes, OnlyOffice callback endpoint
  for auto-save, /api/docs/:id/editor-config returns signed config
- Blank DOCX template embedded as base64 for new document creation
- OnlyOffice server: https://onlyoffice.necloud.us (set ONLYOFFICE_JWT_SECRET
  env var to match your Document Server JWT secret)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 14:12:39 -04:00
nmemmertandClaude Sonnet 4.6 16e3bbbd83 Fix seed.js constraints: empty string for quiz body and SA choices, one assignment per student
Build and Push Docker Image / build-and-push (push) Successful in 36s
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 13:44:21 -04:00
nmemmertandClaude Sonnet 4.6 43850693ac Fix Settings nav and scope admin sidebar active-class toggle
Build and Push Docker Image / build-and-push (push) Successful in 36s
- Include .admin-sidebar-footer .nav-pill in click listener so Settings is reachable
- Update showPanel to toggle active class on both .admin-nav and footer pills

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 13:39:09 -04:00
nmemmertandClaude Sonnet 4.6 7775c4fc3a Redesign admin dashboard with sidebar layout, planner overhaul, and readability fixes
Build and Push Docker Image / build-and-push (push) Successful in 41s
- Replace horizontal top-nav with a dark sidebar (grouped: People / Academics / Tools)
- Add Dashboard landing page with kid stat cards, today's schedule, and recent scores
- Add /api/admin/schedule and /api/admin/recent-scores endpoints for dashboard data
- Add Lock button and mobile sidebar toggle in top bar
- Redesign planner toolbar: two-section layout (nav left, actions right)
- Elevate auto-schedule out of hidden accordion into always-visible inline bar
- Richer planner task cards: course color stripe, course name label, completion counter per day
- Dashed "+ Add task" empty state instead of plain dash
- Fix nav-pill CSS conflict: student tabs (light bg) now use dark text; admin sidebar keeps white text
- Add seed.js demo data script for two students (Emma and Liam)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 13:31:12 -04:00
nmemmertandClaude Sonnet 4.6 ab32ba8634 Complete visual redesign — new design system
- Switch to Inter (body) + Nunito (kid headings) from Google Fonts
- Replace warm-cream palette with clean blue-tinted design system
  - --bg: #f5f7ff, --card: #fff, --accent: #4f7ef8
  - Layered shadow variables (--shadow-xs through --shadow-lg)
  - --border / --border-hover / --accent-light tokens
- Admin panel: sticky header with compact nav pills, clean card borders,
  uppercase label style for admin-card fields, hover transitions
- Student app: Nunito bold headings, better kid-card glow on dark home,
  cleaner word-card / done-card / item-card styles
- Better button hierarchy: gradient primary, neutral secondary, red danger
- Modernized form inputs: consistent 1.5px border + focus ring system
- Cleaner planner tasks (accent-light tint), today rows, unit blocks
- All theme variants updated to match new palette tokens

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 12:58:24 -04:00
nmemmertandClaude Sonnet 4.6 a92db291c7 Add paper/print alternatives for off-screen learning
Build and Push Docker Image / build-and-push (push) Successful in 3m35s
- Spelling: "Blank test" print button per word list (numbered lines, no words shown) for dictated paper tests
- Spelling: "Record Paper Test" form in admin to log a paper test score to the gradebook
- Gradebook: "Record Paper Score" form to log a paper quiz/assignment score for any course item
- Flashcards: "Print" button per deck generates a cut-and-fold card sheet (fronts page + backs page)
- Crossword: print now includes a second page with a filled answer key
- Lessons + Assignments: 🖨 Print button in student view generates a clean printable page
- Word lists: new "CSV file" import tab — upload a .csv with word, sentence, definition columns

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-10-19 12:43:38 -04:00
nmemmertandClaude Sonnet 4.6 6baea15986 Fix TTS audio stalling and add back/previous-word navigation in spelling
Build and Push Docker Image / build-and-push (push) Successful in 55s
- Add timeout fallback in ttsDrain so the queue never permanently stalls
  when the browser fails to fire onend (common Chrome/Safari bug after
  extended use)
- Call speechSynthesis.resume() before speak() to un-stick suspended
  synthesis on mobile
- Rename "← Stop" / "← Cancel" to "← Back" on practice and test views
- Add "← Previous word" button in spelling test so kids can go back one
  word (e.g. when audio broke) — pops the saved answer and replays

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-26 15:52:28 -04:00
nmemmertandClaude Sonnet 4.6 74c4530060 Migrate workflow from .github to .gitea/workflows
Build and Push Docker Image / build-and-push (push) Successful in 3m56s
Switch registry from ghcr.io to git.necloud.us and update secrets
to REGISTRY_USER / REGISTRY_TOKEN for Gitea Actions compatibility.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-26 13:29:19 -04:00
nmemmertandClaude Sonnet 4.6 44b481e177 Add in-app and OS notifications for new messages
Polls every 30s for unread messages on both kid and admin sides.
Kid app shows a tappable in-page toast and fires a browser OS
notification when a parent message arrives while the tab is open.
Admin app shows a toast and OS notification when a student replies.
Clicking the OS notification focuses the tab and opens the messages view.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-24 10:19:29 -04:00
Nate EmmertandClaude Sonnet 4.6 4ad11ea4ee Fix test correction: remove transaction, add error handling
Replaced db.transaction() wrapper (unreliable in node:sqlite at this
version) with a plain loop. Added try/catch in the JS save handler so
any server error surfaces as a visible toast instead of failing silently.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-21 09:06:12 -04:00
Nate EmmertandClaude Sonnet 4.6 0744ba9e39 Add spelling test correction feature for admins
Adds a "Correct" button to each test in the Spelling Test History table.
Clicking it opens a modal showing each word, what the student typed, and a
checkbox to mark it correct or incorrect. Saving PATCHes the server, which
updates test_answers, recalculates the test score, and keeps any linked
course submission in sync.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-21 08:56:28 -04:00
Nate EmmertandClaude Sonnet 4.6 4574bd3785 Limit practice sessions to the assigned list only
Remove cross-list review words (Leitner spaced repetition) from practice
sessions so only the currently assigned list's words are shown. Also remove
the now-unused dueReviews count from the state endpoint and student UI.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-21 08:34:36 -04:00
nmemmertandClaude Sonnet 4.6 43aa367f63 Add Graded sub-tab to student inbox
New grades show in the New tab on first visit; on return they move to the Graded tab so the inbox stays clean without losing the history.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-20 13:58:43 -04:00
nmemmertandClaude Sonnet 4.6 3a018a97bb Fix parent messaging — allow sending to any student, not just those who messaged first
- Replace reply-by-message-ID endpoint with POST /api/admin/messages/:studentId so parent can send without a prior message existing
- Switch GET /api/admin/messages to LEFT JOIN so all students appear in the thread list, not just those who have sent messages
- Remove guard that blocked sending when no messages existed in the thread

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-20 13:37:08 -04:00
nmemmertandClaude Sonnet 4.6 556b570b60 Add worksheet short-answer grading view, student inbox, and parent-student messaging
- Grading queue now shows short-answer questions and student responses inline so the parent can read answers before scoring
- Student inbox tab shows all graded items with score, percentage, and parent feedback; unread badge appears on login
- Parent-student messaging: students send messages from the Inbox tab; Messages panel in admin shows threads with unread count badge, full conversation history, and reply compose

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-20 13:28:28 -04:00
nmemmertandClaude Sonnet 4.6 2834738598 Track each spelling practice pass as a separate activity record
Each time a student completes a pass through a spelling_practice course
item — initial round, missed-words drill, or a retry — a row is now
written to submission_history so the parent sees individual attempts
instead of a single day-grouped entry.

- app.js: send sessionAttempted/sessionCorrect with /complete calls
- server.js: write to submission_history on each spelling_practice
  completion; add GET /api/spelling-sessions endpoint
- admin.html/js: new "Practice Sessions" table shows one row per pass

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-14 09:08:53 -04:00
nmemmertandClaude Sonnet 4.6 bb56b9b9e8 Fix drill missed words button — shuffle was not defined
ReferenceError on click prevented the drill session from starting.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-12 13:37:38 -04:00
nmemmertandClaude Sonnet 4.6 5290dd80ca Add spelling practice activity log for parents
Shows per-student, per-day practice history in the Spelling panel: date,
time range, word list(s), and first-try correct rate. Clicking a row opens
a detail modal with every word attempted, what the student typed, and
whether it was a first try or retype.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-11 07:48:12 -04:00
nmemmertandClaude Sonnet 4.6 6b7baf7297 Add school name and logo to home screen and admin header
- School name now appears on the student home screen and updates the page title
- Logo can be uploaded in Settings (PNG/JPG/GIF/WebP/SVG, max 2 MB); stored in the data volume so it persists across container restarts
- When a logo is uploaded the text school name is hidden in favour of the logo
- Admin header shows the school name instead of hardcoded "Homeschool", updates live when saved
- New server endpoints: GET /api/logo, POST /api/admin/upload-logo, DELETE /api/admin/logo
- /api/public-settings now includes school_name and has_logo

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-10 16:46:00 -04:00
nmemmertandClaude Sonnet 4.6 1eedfc7715 Add birthday celebrations for students
Parents can set a birthday (MM-DD) per student in the Kids panel. During the student's birthday week (Mon–Sun), a festive overlay appears on login with balloons, birthday cake, confetti, and a personalized message — shown once per day via sessionStorage. Summer birthdays (June–Aug) show a note in admin suggesting the parent set an alternate school-week date to celebrate early.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-10 09:02:48 -04:00
nmemmertandClaude Sonnet 4.6 7f6268d6e5 Add word list preview, young learner mode, and practice improvements
- Show full word list before practice starts so students can study words first
- Add per-student young learner mode (set in admin): word stays visible while typing
- Center all practice card content (speak button, prompt, feedback, check button)
- Remove 10-word-per-session cap so large lists (25-30 words) practice all words
- Double the misspelled-word study countdown from 4s to 8s
- Fix word list preview numbering for 10+ items (inline numbers, no clipping)
- Add young_learner column to students table with admin toggle

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-05 10:43:24 -04:00
nmemmertandClaude Sonnet 4.6 006c865b87 Add emoji toggle setting to parent dashboard Settings panel
Parent can turn the floating school emoji on/off from Settings > Student home screen. Setting persists in the DB and is read via a public /api/public-settings endpoint on the student home page.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 17:00:42 -04:00
nmemmertandClaude Sonnet 4.6 f66b2749f0 Style all back/switch/stop buttons as proper pill buttons
Replaces the plain muted text style with a white card button: border, shadow, hover lift, and transition — consistent across Switch, Back, Stop, and Cancel labels throughout the student app.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:56:13 -04:00
nmemmertandClaude Sonnet 4.6 dc147821e1 Hide floating emoji once student enters their account
Confetti only shows on the kid picker screen, not inside the student's account.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:54:00 -04:00
nmemmertandClaude Sonnet 4.6 dcdf4bf1fd Dark background + glowing kid cards + parent dashboard card on student home
- Student home gets a deep navy-to-indigo background so card glows pop
- Each kid card glows its own theme color via ::after blur pseudo-element with breathing animation; hover cranks it up to full brightness
- Floating school emoji opacity increased for visibility on dark bg
- 'Parent dashboard' link replaced with a frosted-glass card button

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:53:37 -04:00
nmemmertandClaude Sonnet 4.6 21d828b7c7 Add more floating school emoji to student login background
Doubles the decoration count to 20 items: scissors, open book, trophy, crayon, triangle ruler, lightbulb, backpack, microscope, straight ruler, globe, bell, paintbrush join the existing stars, books, pencil, rainbow, palette, and notepad.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:44:30 -04:00
nmemmertandClaude Sonnet 4.6 8d6bcbe132 Liven up parent and student login screens
Parent: floating card with box-shadow over a soft multi-radial gradient background; decorative emoji header above PIN form.
Student: each kid card gets a colored top border matching their saved theme; subtle floating emoji (stars, books, pencil, rainbow) drift in the background.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:42:20 -04:00
nmemmertandClaude Sonnet 4.6 538522cfe7 Fix 7 UX pain points: grading filter, next-item nav, lesson prose, gradebook calc, auto-schedule skip, lesson item defaults, planner improvements
- Grading: add student filter dropdown, Enter-to-save, and point max always defaults to 100
- Student side: show next-item/back-to-course actions after completing a lesson or assignment
- Lesson body: apply prose typography styles (headings, lists, blockquotes, links, hr)
- Gradebook: fix % display when points_possible is 0 (default to 100 on grade save)
- Auto-schedule: skip items that already have a submission
- Item editor: default new/existing item point values to 100 instead of 10
- Planner: friendly week date header, per-day short date, today highlight, course color on task pills, done toggle, within-day drag reorder, Today button

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 16:33:59 -04:00
nmemmertandClaude Sonnet 4.6 60a2a597c5 Planner UX improvements and grading max-points display
- Today button jumps planner to current week; today column highlighted with accent outline
- Week label now shows friendly format (Aug 3–7, 2026) instead of ISO dates
- Course color shown as left border on scheduled course items
- Parent-side done toggle on every planner task (works for offline + course items)
- Within-day drag-to-reorder tasks via new /api/schedule/reorder endpoint
- Grading queue shows visible "/ N pts" max-points label (defaults to 100 when unset)
- New item default points changed from 10 to 100

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 15:16:49 -04:00
nmemmertandClaude Sonnet 4.6 7580257ba0 Replace planner queue + inline forms with searchable add-task modal
- Single "Add task" button in the planner header opens a modal
- Day tabs (Mon–Fri with dates) let you switch the target day without closing
- Live search filters all course items across all courses instantly
- Items pre-fetched in background when planner loads — no per-click delay
- Clicking an item schedules it immediately (no separate Save step)
- Column "+ Add" buttons still work and open the modal pre-selected to that day
- Offline task field at the bottom for non-course entries
- Backdrop click or ✕ closes modal and re-renders the planner

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 14:25:36 -04:00
nmemmertandClaude Sonnet 4.6 6b7b77829e Add school name, passing threshold, and week-start-day settings
- School/family name: saved to DB, appears in printed week/month report headers
- Passing grade threshold: replaces hardcoded 80% in all gradebook/history views
- Week start day (Mon vs Sun): shifts the planner 5-day grid and month view accordingly
- Settings are loaded at unlock time so they apply before any panel opens

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 14:11:23 -04:00
nmemmertandClaude Sonnet 4.6 a10239ead9 Remove page scanning / Ollama AI vision feature
Removes the scan-a-page workflow (photo → lesson/quiz content), all
Ollama/cloud provider code, the scan settings panel, and the related
DB seed values.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 13:52:55 -04:00
nmemmertandClaude Sonnet 4.6 61f9288aa5 Add student delight features: celebrations, sounds, animations, and background patterns
- Confetti + pop sound on lesson/assignment completion
- Done stamp animation (awaitable, shows below toast)
- Welcome toast on first login only (not back-navigation)
- Web Audio ding/buzz during spelling practice and flashcards
- Fanfare on all-day completion
- Score counter animate-up on practice/test results
- 3D flashcard flip animation (rotateY via CSS keyframes)
- Tab slide transition (Today/Courses/Spelling, directional)
- Staggered card entrance + time-of-day greeting on home screen
- Emoji wobble on kid card hover
- Word card green/red flash on correct/wrong spelling answer
- Combo streak celebration at milestones (3, 5, 7, 10 in a row)
- Random cheer messages for generic celebrations
- Button bounce on :active (scale + translateY)
- Progress bar smooth transition (0.5s ease-out)
- Background pattern picker: dots, stripes, grid, stars, bubbles
- bg_pattern persisted per-student via PATCH /api/students/:id/bg-pattern
- Theme switching preserves bg pattern class

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-04 13:15:53 -04:00
nmemmertandClaude Sonnet 4.6 6f73acd03e Add Worksheet item type with paste-and-parse authoring, digital submission, and print-blank
- New `worksheet` item type: admin pastes raw worksheet text, parser auto-detects fill-in-the-blank (___), true/false (T   F   ...), section headers (Part N —), and short-answer questions
- Admin editor shows each parsed question with inputs to set correct answers for FITB and T/F; short answers are marked parent-grades
- Kid view renders FITB as inline underline inputs, T/F as tap-to-toggle T/F buttons, and short answer as a textarea; Name/Date header auto-populated
- Auto-grades T/F (exact) and FITB (case-insensitive); worksheets with short answers go to grading queue as status=done
- Print blank button opens a formatted print window with underlines, circled T/F, and ruled lines for short answers
- "I handed in my paper copy" button lets kids mark a printed worksheet as turned in without digital submission, queuing it for parent grading

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-03 15:59:13 -04:00
nmemmertandClaude Sonnet 4.6 9abb107096 Perf, correctness, and data-integrity improvements
- requirePin: prepare pin-lookup statement once at module level instead of per-request
- Gradebook: replace O(students × items × 3) per-item queries with 2 bulk INs + in-memory Maps
- List/deck PUT: wrap DELETE + re-INSERT in a transaction to prevent partial-write corruption
- Print views: detect HTML vs plain-text lesson bodies before escaping, fixing rich-text output
- Planner add-task: parallelize course detail fetches with Promise.all
- Planner save-all: parallelize schedule inserts with Promise.all
- HOMESCHOOL_DIR: read from env var with existing path as fallback
- Remove unused isDown function in crossword-submit handler
- Remove dead empty-if stub in docx import change handler

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-03 14:58:56 -04:00
nmemmertandClaude Sonnet 4.6 07853890e8 Upgrade spelling worksheet to a proper print sheet
- Name/Date header line on every print
- Numbered words (1. after, 2. again…)
- Ruled write slots: solid baseline + faint midline guide instead of bare underline
- Mode picker (screen-only): toggle between Practice (word shown, write twice) and Dictation/Test (numbered blank lines only) before hitting Print

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-03 11:20:06 -04:00
nmemmertandClaude Sonnet 4.6 eb4b713e9d Fix docx import missing lesson content — include h1-h6 block elements
mammoth outputs week/quiz headings as <h2>/<h1>, not <p><strong>. The
block-element regex only matched <p>, so all headings were skipped and no
lessons were ever created. Expand regex to h[1-6]|p|ul|ol and treat any
h-tag as a heading unconditionally.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-03 10:13:56 -04:00
nmemmertandClaude Sonnet 4.6 3197d29a28 Add course import/export: JSON bundle and direct Word docx upload
- Export any course as a .json bundle (GET /api/admin/courses/:id/export)
- Import a .json bundle as a new course (POST /api/admin/import-course)
- Import one or more unit .docx files directly in the browser — server
  parses each file with mammoth, extracts Week N: headings as lesson
  items and the Unit Quiz section as a graded quiz with answer key
  (POST /api/admin/import-course-docx, multer memory storage)
- Admin UI: Export button on course detail; Import card with JSON and
  Word docs tabs; multi-file picker for docx uploads
- scripts/import-kitchen-course.js: one-time converter that produced
  the Kitchen, Tools & Electrical Skills course JSON bundle (already
  imported as course id 3: 8 units, 44 items)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-03 10:02:10 -04:00
Nate EmmertandClaude Sonnet 4.6 a44cf659b5 Make crossword view full-width to avoid grid scrolling
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-01 20:34:45 -04:00
Nate EmmertandClaude Sonnet 4.6 2a21045e70 Fix crossword clue scrollIntoView jumping the page
Replace scrollIntoView (which escapes to the window when the list isn't
tall enough to scroll) with manual scrollTop logic that stays strictly
within the clue list container.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-08-01 20:28:10 -04:00