from app.models import LoanDecisionTable
from app.util.util import get_or_none


class LoanDecisionTableAccessor:
    @classmethod
    def get_applicable_loan_offers(cls, application_id):
        return LoanDecisionTable.objects.filter(application_id=application_id, status=0, deleted_at=None).order_by('tenure')

    @classmethod
    def get_loan_offer(cls, application_id, loan_offer_id):
        return LoanDecisionTable.objects.filter(application_id=application_id, offer_id=loan_offer_id).first()

    @classmethod
    def get_loan_offer_for_application_id(cls, loan_application_id):
        return LoanDecisionTable.objects.filter(application_id=loan_application_id).first()