def fetch_latest_ec_details(award_id: int, mapper: OrderedDict,
transaction_type: str) -> dict:
vals, ann = split_mapper_into_qs(mapper)
model = TransactionFPDS if transaction_type == "fpds" else TransactionFABS
retval = (model.objects.filter(
transaction__award_id=award_id, officer_1_name__isnull=False).values(
*vals).annotate(**ann).order_by("-action_date"))
return retval.first()
def fetch_fpds_details_by_pk(primary_key: int, mapper: OrderedDict) -> dict:
vals, ann = split_mapper_into_qs(mapper)
return TransactionFPDS.objects.filter(pk=primary_key).values(*vals).annotate(**ann).first()
def fetch_award_details(filter_q: dict, mapper_fields: OrderedDict) -> dict:
vals, ann = split_mapper_into_qs(mapper_fields)
return Award.objects.filter(**filter_q).values(*vals).annotate(**ann).first()
def fetch_fabs_details_by_pk(primary_key, mapper):
vals, ann = split_mapper_into_qs(mapper)
return TransactionFABS.objects.filter(pk=primary_key).values(
*vals).annotate(**ann).first()
