Add Soft Delete for Payment Orders

[chibie]

User Story
As a system operator, I want payment orders to be soft deleted instead of permanently removed, to maintain data integrity and audit history while still allowing cleanup of old records.

Acceptance Criteria

1. GIVEN a payment order is deleted
   WHEN using normal deletion
   THEN the record is soft deleted by setting deleted_at

2. GIVEN querying payment orders
   WHEN no special context is provided
   THEN only non-deleted records are returned

3. GIVEN querying payment orders
   WHEN using SkipSoftDelete context
   THEN all records including soft-deleted ones are returned

4. GIVEN a sender profile is deleted
   WHEN the cascade delete triggers
   THEN associated payment orders are soft deleted

Tech Details

• Create new SoftDeleteMixin in schema/mixins.go following Ent documentation for soft delete
• Add SoftDeleteMixin to both LockPaymentOrder and PaymentOrder schemas
• Update PaymentOrder edge in SenderProfile to use entsql.Cascade
• Add SkipSoftDelete context utility function
• Create database migration for new deleted_at field
• Add soft delete functionality to LockPaymentOrder and PaymentOrder schemas
• Ignore writing tests for this ticket

Notes/Assumptions

• Both schemas currently use TimeMixin
• Multiple mixins can be combined
• Existing deletion logic will be replaced by soft delete
• Permanent deletion still possible with SkipSoftDelete context

Open Questions

[od-hunter]

Hi, please can I be assigned this please? This would be my first time contributing to this project and I would love to be the given the opportunity to solve this issue please. I am good with tests and I have experience in html, css, JavaScript,TypeScript and solidity, and Cairo.

[Amizeey]

I'd be happy to do this.

[Fidel-wole]

I'd be happy to do this.

[Supa-mega]

Can I jump on this task? first time contributor

[caxtonacollins]

May I try my hand at this?

[chibie]

@Fidel-wole have you started work on this ticket?

[Fidel-wole]

I'm still going through the repository, will begin soon