[Backend] PaymentStatus enum not standardised — Prisma schema, service layer, and API responses use different values

[Pvsaint]

Problem

The TODO.md confirms issue #216 'PaymentStatus enum standardization' is still 'In Progress' at step 1/6. The Prisma schema, payment.service.ts, and frontend types.ts use different status string values, causing mismatch bugs at runtime when statuses are compared or stored.

Acceptance Criteria

• PaymentStatus Prisma enum defined with canonical values: pending, partially_paid, confirmed, overpaid, expired, failed, paid, completed, refunded, partially_refunded
• Payment.status field uses the enum type in schema
• Migration generated and applied: add_payment_status_enum
• payment.service.ts uses enum values everywhere (no raw strings)
• API responses serialise enum values consistently
• PAYMENT_LIFECYCLE.md created in docs describing each state transition
• All existing tests pass after migration

Branch & Commit

branch: fix/payment-status-enum-migration
commit: fix(payments): standardise PaymentStatus enum across Prisma, services, and API

[Gbotemi-ojo]

@Gbotemi-ojo has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I can work on this maintainer,assign this to me maintainer

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

[eischideraa-unn]

@eischideraa-unn has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello Maintainer,

I'd like to work on this issue. I have experience contributing to similar codebases and can quickly get up to speed with the existing architecture. My plan is to identify the root cause, implement a clean fix that follows project conventions, and thoroughly test the solution before submitting a PR.

Looking forward to contributing.

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

[akinboyewaSamson]

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

Hello Maintainer, Please I would like to work on this issue

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

[Damilorlar]

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

I would love to work on this project.

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

[Kayce10]

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

Hi maintainer, i would like to work on this issue

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

[DANTE-1903]

@DANTE-1903 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

please assign this issue to me

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

[Primex-Tech]

@Primex-Tech has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I will love to solve this issue

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

[muffti123]

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

i would love to work on this.
please assign, thank you!!

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

[somotochukwu-dev]

@somotochukwu-dev has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi
Please I would like to work on this issue

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

[olatundefay-prog]

@olatundefay-prog has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Allow me to professionally implement this task with precision and accuracy.

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