[Bug][Backend] adminDisputeController & loanController query non-existent 'loans' table

[blurbeast]

Issue #10

Database Error: Non-Existent loans Table in Queries

• Title: [Bug][Backend] adminDisputeController & loanController query non-existent 'loans' table
• Labels: bug, backend, database, high
• Location: backend/src/controllers/adminDisputeController.ts:131, backend/src/controllers/loanController.ts:58, 91
• Description:
  Queries attempt JOIN loans l ON l.id = d.loan_id and SELECT * FROM loans WHERE id = $1. The PostgreSQL schema derives loan state from contract_events and does not have a loans table.
• Impact:
  Endpoints GET /admin/loan-disputes/:disputeId, POST /api/loans/:loanId/build-cancel, and POST /admin/loans/:loanId/build-reject crash with relation "loans" does not exist.
• Suggested Fix:
  Update queries to aggregate loan state from contract_events.

---

Backend Analytics & Logic

[oyinade247]

Can I work on this pleaseee

[ItunuOni]

@ItunuOni has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I would like to work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ItunuOni to this issue.

[samad13]

@samad13 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

let me work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @samad13 to this issue.

[Calebstack]

@Calebstack has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello maintainer, i’ve got this covered! Ready to drop a high-impact, clean PR that gets this merged seamlessly

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Calebstack to this issue.

[KingDavid9999]

@KingDavid9999 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi maintainer, I'd very much appreciate the opportunity to work on this issue.
Having reviewed the acceptance criteria, I'm confident that I'd be able to have a PR up shortly after being assigned.
Kindly assign this issue to me.
Thank you!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @KingDavid9999 to this issue.

[drips-wave]

Congratulations, @ItunuOni! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @ItunuOni: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊