import os
import re
from collections import OrderedDict
from datetime import date, datetime, timedelta
import requests
from django.conf import settings
from django.core.cache import cache
from django.db.models import Count, Prefetch, Q, Sum
from django.db.models.functions import TruncMonth
from django.utils import timezone
from rest_framework import viewsets
from rest_framework.decorators import action
from rest_framework.parsers import JSONParser, MultiPartParser, FormParser
from rest_framework.response import Response
from drf_spectacular.utils import extend_schema, OpenApiParameter
AI_DESCRIBE_SYSTEM_PROMPT = (
"You are an assistant that writes clear, professional project descriptions for a "
"research organization's internal knowledge hub.\n\n"
"Rules:\n"
"- Respond ONLY with the project description itself. No preamble, no commentary, "
"no markdown code fences.\n"
"- Format as clean semantic HTML for a rich-text editor: use ,
, /- , "
". Do NOT include , , , or