Website Issues — Per-Page Issue Detection & AI Code Fixer

model WebsiteIssue {
  id                 String    @id @default(cuid())
  tenantId           String
  connectedChannelId String
  webPageId          String
  webCrawlJobId      String
 
  issueType  String   // see Issue Types table below
  severity   String   // "critical" | "warning" | "info"
  pageUrl    String   // denormalized — display without join
  details    Json?    // { wordCount, httpStatus, duplicateCount, imageUrl, ... }
 
  status      String    @default("open")  // "open" | "fixed" | "ignored"
  fixPrUrl    String?
  fixPrNumber Int?
  fixedAt     DateTime?
 
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt
 
  @@index([connectedChannelId, issueType])
  @@index([connectedChannelId, status])
  @@index([webPageId])
  @@map("website_issue")
}

model WebsiteGitHubSync {
  id                 String    @id @default(cuid())
  tenantId           String
  connectedChannelId String    @unique   // Website ConnectedChannel
  githubChannelId    String              // GitHub OAuth ConnectedChannel
 
  repoOwner  String
  repoName   String
  branch     String  @default("main")
 
  lastFixRunAt   DateTime?
  lastPrUrl      String?
  lastPrNumber   Int?
  lastFixStatus  String?   // "idle" | "running" | "success" | "failed"
  lastFixError   String?   @db.Text
 
  @@map("website_github_sync")
}

generateWebsiteIssues(tenantId, connectedChannelId, webCrawlJobId)
  ├─ Load all WebPage rows for this crawl
  ├─ Load IMAGE WebMedia rows with no altText (via pageMedias join)
  │
  ├─ For each page:
  │   ├─ title IS NULL          → missing_title (critical)
  │   ├─ description IS NULL    → missing_meta_description (critical)
  │   ├─ httpStatus >= 400      → broken_page (critical)
  │   └─ wordCount < 200 > 0    → thin_content (warning)
  │
  ├─ Across all pages (duplicate detection):
  │   ├─ Group pages by lowercase title  → titles shared by 2+ pages → duplicate_title (warning) per page
  │   └─ Group pages by lowercase desc   → descs shared by 2+ pages  → duplicate_meta (warning) per page
  │
  ├─ For each image with no altText → missing_alt_text (warning) on its first associated page
  │
  ├─ DELETE existing open issues for channel  (fixed/ignored preserved)
  └─ createMany(issues)

// packages/queue/src/types.ts
interface WebsiteCodeFixerJobData {
  tenantId:            string;
  tenantName:          string;
  connectedChannelId:  string;
  websiteGitHubSyncId: string;
  issueIds:            string[];  // empty = fix all open issues for channel
}

// packages/queue/src/queues.ts
enqueueWebsiteCodeFixer(data: WebsiteCodeFixerJobData): Promise<string>
// Queue: agent__website-code-fixer
// JobId: website-code-fixer__{tenantId}__{connectedChannelId}__{Date.now()}

processJob(job)
  ├─ 1. Load WebsiteGitHubSync → decrypt GitHub OAuth token
  ├─ 2. Load open WebsiteIssue rows (issueIds filter or all open)
  │      Cap at 50. Filter to code-fixable types only (excludes broken_page).
  ├─ 3. publishAgentEvent(agent:started)
  ├─ 4. GitHubService.getFileTree() → detect framework from file names
  │      Frameworks: nextjs / nuxt / gatsby / wordpress / astro / node-generic / html
  ├─ 5. Claude tool-use loop (max 20 iterations):
  │      Tools:
  │        read_file(filePath)  → GitHubService.getFileContent()
  │        write_file(filePath, content, commitMessage) → GitHubService.putFile()
  │          (creates branch on first write: "leadmetrics/fix-website-issues-{timestamp}")
  │      Prompt: framework + file tree (first 300 paths) + issue list
  │      Model: from AgentConfig.role="website-code-fixer", default claude-sonnet-4-6
  ├─ 6. GitHubService.createPR() — if any files were changed
  │      Title: "fix: website SEO issues detected by Leadmetrics (N issues)"
  │      Body: issue list + files changed + merge instructions
  ├─ 7. WebsiteIssue.updateMany → status="fixed", fixPrUrl, fixPrNumber, fixedAt
  ├─ 8. WebsiteGitHubSync.update → lastFixStatus, lastPrUrl, lastPrNumber
  └─ 9. publishAgentEvent(agent:completed)

# Website Code Fix Task

## Framework
{detected framework}

## Repository File Tree (first 300 lines)
{file paths, one per line}

## Issues to Fix
1. [missing_title] https://example.com/about
2. [missing_meta_description] https://example.com/services — ...

## Instructions
- read_file before editing, write_file after
- Make ONLY targeted changes, no refactoring
- For missing_title/meta: add/update HTML meta tags in template/layout file
- For missing_alt_text: add descriptive alt to <img> tags
- For thin_content: create a details.json note (do NOT fabricate content)
- For duplicate_title/meta: make each page's tag unique by appending page name
- Skip issues where the responsible file cannot be determined
- Output a JSON summary block at the end: { fixed[], skipped[], filesChanged[] }