FM / routes

/opt/canhelp/apps/api/src/routes

Name	Size	Mode	Actions
admin.ts	95057	0644	edit dl rm
auto-match.ts	7406	0644	edit dl rm
auto-response.ts	8111	0644	edit dl rm
availability.ts	7294	0644	edit dl rm
categories.ts	1867	0644	edit dl rm
chat.ts	9377	0644	edit dl rm
dashboard.ts	5142	0644	edit dl rm
favorites.ts	4441	0644	edit dl rm
fomo.ts	6844	0644	edit dl rm
google.ts	4872	0644	edit dl rm
health.ts	1214	0644	edit dl rm
i18n.ts	167086	0644	edit dl rm
locations.ts	1781	0644	edit dl rm
notifications.ts	2862	0644	edit dl rm
offers.ts	10047	0644	edit dl rm
payments.ts	21167	0644	edit dl rm
plans.ts	1352	0644	edit dl rm
portfolio.ts	6658	0644	edit dl rm
price-list.ts	14417	0644	edit dl rm
reports.ts	2007	0644	edit dl rm
reviews.ts	2783	0644	edit dl rm
skill-suggestions.ts	1035	0644	edit dl rm
specialist-cards.ts	18641	0644	edit dl rm
stats.ts	1093	0644	edit dl rm
statuses.ts	3731	0644	edit dl rm
support.ts	8452	0644	edit dl rm
tasks.ts	30018	0644	edit dl rm
uploads.ts	1526	0644	edit dl rm
users.ts	37157	0644	edit dl rm

Edit: /opt/canhelp/apps/api/src/routes/stats.ts (1093B)

const app = new Hono()

const CACHE_KEY = 'public:stats:v2'
const CACHE_TTL = 60 * 10 // 10 minutes

// GET /stats — public platform statistics
app.get('/', async (c) => {
  const cached = await redis.get(CACHE_KEY).catch(() => null)
  if (cached) return c.json(JSON.parse(cached))

const [[{ specialistCount }], [{ taskCount }], [{ categoryCount }]] =
    await Promise.all([
      db.select({ specialistCount: countDistinct(specialistCards.specialistId) }).from(specialistCards).where(eq(specialistCards.isActive, true)),
      db.select({ taskCount: count() }).from(tasks),
      db.select({ categoryCount: count() }).from(categories).where(eq(categories.isActive, true)),
    ])

const result = { specialistCount, taskCount, categoryCount }
  redis.set(CACHE_KEY, JSON.stringify(result), 'EX', CACHE_TTL).catch(() => {})
  return c.json(result)
})

export default app

import { Hono } from 'hono' import { count, countDistinct, eq } from 'drizzle-orm' import { db } from '../db.js' import { tasks, categories, specialistCards } from '@canhelp/db' import { redis } from '../redis.js' const app = new Hono() const CACHE_KEY = 'public:stats:v2' const CACHE_TTL = 60 * 10 // 10 minutes // GET /stats — public platform statistics app.get('/', async (c) => { const cached = await redis.get(CACHE_KEY).catch(() => null) if (cached) return c.json(JSON.parse(cached)) const [[{ specialistCount }], [{ taskCount }], [{ categoryCount }]] = await Promise.all([ db.select({ specialistCount: countDistinct(specialistCards.specialistId) }).from(specialistCards).where(eq(specialistCards.isActive, true)), db.select({ taskCount: count() }).from(tasks), db.select({ categoryCount: count() }).from(categories).where(eq(categories.isActive, true)), ]) const result = { specialistCount, taskCount, categoryCount } redis.set(CACHE_KEY, JSON.stringify(result), 'EX', CACHE_TTL).catch(() => {}) return c.json(result) }) export default app