Generating Reports

@login_required(login_url='/accounts/login/')
def index(request):
    context = {
        'total_ptes': PTEHeader.objects.filter(estatus__in=[1,2,3,4]).count(),
        'ptes_activo': PTEHeader.objects.filter(estatus=1).count(),
        'ptes_en_proceso': PTEHeader.objects.filter(estatus=2).count(),
        'ptes_terminado': PTEHeader.objects.filter(estatus=3).count(),
        'ptes_cancelado': PTEHeader.objects.filter(estatus=4).count(),
    }

def obtener_volumenes_consolidados(id_ot, codigos):
    # Get OT family (initial + reprogramming)
    id_principal = ot.ot_principal or ot.id
    familia_ots = OTE.objects.filter(
        Q(id=id_principal) | Q(ot_principal=id_principal)
    )
    
    # Latest authorization per concept
    return {p.id_partida: p.volumen_proyectado for p in partidas}

# Only production with validated GPUs
producciones_facturables = Produccion.objects.filter(
    id_reporte_mensual=reporte,
    volumen_produccion__gt=0,
    es_excedente=False,  # No excess
    gpu__id_estatus_id=21  # VALIDADO
)

class RegistroActividad(models.Model):
    registro_id = models.IntegerField()    # Record ID
    evento = models.TextField()            # Event type (CREATE, UPDATE, DELETE)
    campo = models.TextField()             # Changed field
    valor_anterior = models.TextField()    # Old value
    valor_actual = models.TextField()      # New value
    afectacion = models.TextField()        # Affected module
    fecha = models.DateTimeField()         # Timestamp
    usuario_id = models.ForeignKey(User)   # User who made change