Profile Quality Score: deterministic talent ranking

export function calculateJobseekerQualitySignals(
  input: JobseekerQualityScoreInput,
): QualitySignal[] {
  return [
    { key: "avatar", weight: 15, earned: isFieldFilled(input.avatar_url) ? 15 : 0 },
    { key: "job_title", weight: 10, earned: isFieldFilled(input.job_title) ? 10 : 0 },
    { key: "bio", weight: 10, earned: stripHtmlToText(input.description).length >= 100 ? 10 : 0 },
    { key: "country", weight: 5, earned: isFieldFilled(input.country) ? 5 : 0 },
    { key: "skills", weight: 10, earned: input.skillsCount >= 3 ? 10 : 0 },
    { key: "experience", weight: 10, earned: input.experienceCount >= 1 ? 10 : 0 },
    { key: "education", weight: 5, earned: input.educationCount >= 1 ? 5 : 0 },
    { key: "rate", weight: 5, earned: isFieldFilled(input.desired_compensation) ? 5 : 0 },
    { key: "phone", weight: 5, earned: isFieldFilled(input.phone) ? 5 : 0 },
    { key: "cv", weight: 5, earned: input.hasProfileCv ? 5 : 0 },
    { key: "email", weight: 10, earned: input.emailConfirmed ? 10 : 0 },
    { key: "verification", weight: 10, earned: Math.min(Math.floor((input.verificationPercentage ?? 0) / 10), 10) },
  ];
}

export function calculateJobseekerQualityScore(input: JobseekerQualityScoreInput): number {
  const total = calculateJobseekerQualitySignals(input).reduce((sum, signal) => sum + signal.earned, 0);
  return Math.max(0, Math.min(100, total));
}

-- JS .trim() / \s strip the FULL ECMAScript whitespace set; Postgres btrim / \s are
-- ASCII-only. So we enumerate the JS set as explicit \uXXXX escapes to score identically.
create or replace function public.pqs_field_filled(v text)
returns boolean language sql immutable set search_path = pg_temp as $$
  select coalesce(
    btrim(v, E' \t\n\u000b\f\r\u00a0\u1680\u2000\u2001\u2002\u2003\u2004\u2005\u2006\u2007\u2008\u2009\u200a\u2028\u2029\u202f\u205f\u3000\ufeff')
      not in ('', '-'),
    false
  );
$$;

create or replace function public.pqs_strip_html(v text)
returns text language sql immutable set search_path = pg_temp as $$
  select case when v is null then '' else btrim(
    regexp_replace(
      regexp_replace(
        regexp_replace(v, '&(nbsp|#160|#xa0|#x00a0|#8203|#x200b|zwnj|#8204|#x200c);', ' ', 'gi'),
        '<[^>]*>', ' ', 'g'),
      E'[ \t\n\u000b\f\r\u00a0\u1680\u2000-\u200a\u2028\u2029\u202f\u205f\u3000\ufeff]+', ' ', 'g')
  ) end;
$$;

-- AFTER (not BEFORE): the compute fn re-queries the row (joins auth.users, counts skills),
-- so on BEFORE INSERT the row isn't in the table yet. quality_score is deliberately ABSENT
-- from the UPDATE OF list below, so the recompute's own UPDATE never re-fires the trigger.
create trigger trg_jobseekers_quality_score_upd
  after update of
    avatar_url, job_title, description, country, desired_compensation,
    phone, profile_cv_id, experience_history, education_history, verification_percentage
  on public.jobseekers
  for each row execute function public.pqs_jobseekers_recompute();

create trigger trg_jobseeker_skills_quality_score
  after insert or delete on public.jobseeker_skills
  for each row execute function public.pqs_skills_recompute();

const RADIUS = 34;
const CIRCUMFERENCE = 2 * Math.PI * RADIUS;

function bandStroke(score: number): string {
  if (score >= 70) return "stroke-brand-emerald";
  if (score >= 40) return "stroke-brand-amber";
  return "stroke-brand-red";
}

export function ProfileQualityRing({ score, loading, onClick }: ProfileQualityRingProps) {
  const value = score ?? 0;
  const dashoffset = CIRCUMFERENCE * (1 - value / 100);
  return (
    <button type="button" onClick={onClick} aria-busy={loading} className="...">
      <svg viewBox="0 0 80 80" className="h-20 w-20 -rotate-90">
        <circle cx="40" cy="40" r={RADIUS} fill="none" strokeWidth="8" className="stroke-muted" />
        {score !== null && (
          <circle cx="40" cy="40" r={RADIUS} fill="none" strokeWidth="8" strokeLinecap="round"
            strokeDasharray={CIRCUMFERENCE} strokeDashoffset={dashoffset}
            className={`${bandStroke(value)} transition-[stroke-dashoffset] duration-700 ease-out`} />
        )}
      </svg>
      {/* centered score, band-colored */}
    </button>
  );
}