// packages/db/src/utils/product-slug.ts

const CONTAINER_TYPE_SLUGS: Record<string, string> = {
  roll_off: "roll-off-dumpster",
  trailer: "dumpster-trailer",
  front_load: "front-load-dumpster",
  rear_load: "rear-load-dumpster",
  wheeled_cart: "wheeled-cart",
}

export function generateContainerSlug(
  size: string | number,
  volumeUnit: string,
  containerType: string,
): string {
  const n = parseFloat(String(size))
  const sizeStr = n % 1 === 0 ? String(n) : n.toFixed(1)
  const unit = volumeUnit === "yard" ? "yd" : "gal"
  const typeSuffix = CONTAINER_TYPE_SLUGS[containerType]
    ?? containerType.replace(/_/g, "-")
  return `${sizeStr}${unit}-${typeSuffix}`
}

// "20yd-roll-off-dumpster"
// "10yd-dumpster-trailer"
// "96gal-wheeled-cart"

• All old URLs get 301 redirects. /hauler/lob/10-yard-msw → /hauler/lob/10yd-roll-off-dumpster?waste=msw
• 301 preserves SEO authority. Google treats 301s as permanent and transfers ranking signals.
• Redirect map generated from DB: query all products, build old slug → new slug mapping, add to Next.js redirects in next.config.mjs or middleware.
• Waste stream preserved via query param. The ?waste=msw param pre-selects the waste stream on the PDP so inbound links from search or directory pages land on the right context.

• What changed Pre-checkout dialog eliminated. Booking inputs move to PDP sidebar.
• Framework Cold Start Problem (Ch. 12) — transaction friction kills liquidity
• Supporting Fogg Behavior Model — reduce effort at the Action step
• Reference model Airbnb listing page: content left, booking widget right
• Risk Form on PDP may create premature commitment anxiety for browsers
• Mitigation Form starts empty. CTA says "Continue to Checkout" (not "Pay Now"). Call-to-quote always visible as escape hatch.

• What changed Waste stream selector killed. Each waste stream = separate product, not a variant.
• Data 99.1% of container groups have one waste stream. 79% of products have one tier. Selectors solved a <1% edge case.
• Implication Default PDP has zero selectors — just price, address, dates, CTA. Tier selector appears conditionally (8.5% of products).
• Multi-product containers (0.9%) Same container URL shows separate product sections. Not variants — separate booking forms.

• What changed Product cards on hauler profile show container + price + arrow. No tiers, no waste stream label.
• Framework Thinking, Fast and Slow (Kahneman) — browsing is System 1, deciding is System 2. Don't force System 2 on a browsing page.
• Grouped by Container type (Roll-Off, Trailer) then by size within group
• Card shows Size badge, container name, waste type count, rental range, lowest price, chevron

• What changed Mobile PDP = the desktop booking widget rendered as the full page. CTA above the fold. No drawer, no sticky bar.
• Rationale Customer clicked through from hauler profile — they've decided. The PDP's job on mobile is to capture the booking, not re-sell. Content is reassurance, not discovery.
• Layout Header (title + hauler) → waste stream → tiers → address → dates → CTA. All above fold. Supporting content below in collapsible accordion sections.
• Previous approach Content-first page with sticky bottom bar + booking drawer. Killed — treated mobile as a browsing page when it should be a booking page.

• What's new Container render/image, project tags, accepted/rejected materials
• Purpose Answer the two questions 80% of first-time renters have: "Is this the right size?" and "Can I put X in it?"
• Data source Static content mapped per container size + waste stream. Not DB-driven (yet).
• SEO value Unique, useful content per page. Avoids thin-page penalties. Matches informational search intent alongside transactional.

• What stays the same Checkout page layout, Stripe Elements, placement form, contract approval
• What changes Entry point moves from dialog to PDP sidebar. Checkout receives same query params.
• Implication PRD #211 issues #212-#218 all remain valid. Only #214 (pre-checkout dialog) is superseded by PDP sidebar.

• Container image: generic placeholder. Just a dashed box showing layout space. No SVG renders, no photos. Future investment.
• Project tags: repackage existing SIZE_CONTENT. Data already curated in size-directory-view.tsx. Industry-standard sizing guidance. No deep research needed. Refine with booking data when available.
• No waste stream context from directory. Directory pages filter by location + size, never by waste stream. No ?waste= param needed. PDP defaults to first available waste stream.
• No PDP for unclaimed haulers. PDP only exists when hauler has claimed AND set up products. Unclaimed haulers have profile pages and directory cards only. Route returns 404 if no products exist for the container.