# Get pending validation results
DeviceResultsValidation.objects.filter(
    device_id=device_id,
    lab_id=lab_id,
    status="PENDING",
    received_date__range=(from_date, to_date)
).select_related(
    "device",
    "lab_report_relation"
).order_by("-received_date")

# interfacing/models/device_results_validation.py
@classmethod
def release_parameters(cls, lab_details, device_id, parameters):
    """Atomic release of validated parameters"""
    with transaction.atomic():
        # Update validation records
        for param in parameters:
            validation = cls.objects.get(pk=param["id"])
            validation.status = "RELEASED"
            validation.save()
            
            # Update lab report
            report = LabReportRelation.objects.get(pk=param["report_id"])
            report.update_value(param["value"])
            report.save()
        
        # Post-processing
        cls.post_process_report(report_detail, logs, lab_details)

class ReleaseParametersView(GenericView):
    
    @transaction.atomic
    def post(self, request, device_id, *args, **kwargs):
        lab_details = {
            "lab_id": self.get_lab_id_from_session(request.session),
            "session": request.session,
            ...
        }
        
        DeviceResultsValidation.release_parameters(
            lab_details=lab_details,
            device_id=device_id,
            parameters=request.data.get("parameters", [])
        )
        
        return JsonResponse({"status": "success"})

# interfacing/models/device_results_validation.py
@classmethod
def post_process_report(cls, report_detail, logs, lab_details):
    """Apply lab-specific post-processing rules"""
    
    post_process_type = lab_details.get("post_process_type")
    
    if post_process_type == "SIGN_AUTOMATICALLY":
        cls.sign_or_save_report(report_detail, is_sign=True, ...)
    elif post_process_type == "SAVE_AND_NOTIFY":
        # Save and trigger notification
        ...

# Use bulk operations for release
DeviceResultsValidation.objects.filter(
    id__in=parameter_ids
).update(status="RELEASED")