import pandas as pd
from app.Models.fox_products_models import (
                                            fox_cmp_ctrl,
                                            fox_cmp
                                           )

def get_ano_fox_cmp_ctrl():
    # años válidos y su maxcmp (lo venías usando)
    return list(fox_cmp_ctrl.objects.values("ano", "maxcmp"))


def get_camp_fox_cmp_pairs():
    # pares (ano, camp) distintos para validar existencia en fox_cmp
    return list(fox_cmp.objects.values("ano", "camp").distinct())