Lista de Presente - Saldo
{
"ordering": [
"LISTA",
"CLIENTE",
"CPF",
"ENTRADA",
"SAIDA",
"SALDO FINAL"
],
"fields": {
"LISTA": "giftlist_id",
"CPF": "giftlist_id",
"SAIDA": "giftlist_id",
"SALDO FINAL": "giftlist_id",
"CLIENTE": "giftlist_name",
"ENTRADA": "giftlist_total_price"
},
"format_eval": {
"SAIDA": "Decimal(sum(r.amount for r in item.giftcard.releases.all() if r.amount < 0)).quantize(Decimal('.001'), rounding='ROUND_HALF_UP') if item.giftcard else 0",
"SALDO FINAL": "Decimal(item.giftcard.balance).quantize(Decimal('.001'), rounding='ROUND_HALF_UP') if item.giftcard else 0",
"ENTRADA": "Decimal(sum(r.amount for r in item.giftcard.releases.all() if r.amount > 0)).quantize(Decimal('.001'), rounding='ROUND_HALF_UP') if item.giftcard else 0",
"CPF": "customer.document or ''"
}
}
Updated almost 2 years ago