from django.db import models


class PaymentEditRequest(models.Model):
    """
    A staff member asks to correct a collection they entered.
    Nothing changes on the payment until an admin approves the request.
    """

    STATUS_CHOICES = [
        ('pending', 'Pending'),
        ('approved', 'Approved'),
        ('rejected', 'Rejected'),
    ]

    payment = models.ForeignKey(
        'NexusApp.LoanPayment', on_delete=models.CASCADE, related_name='edit_requests')
    requested_by = models.ForeignKey(
        'NexusApp.Staff', on_delete=models.SET_NULL, null=True, related_name='payment_edit_requests')

    # values when the request was made (so the admin sees old vs new)
    old_payment_date = models.DateField()
    old_amount = models.DecimalField(max_digits=12, decimal_places=2)
    old_payment_method = models.CharField(max_length=10)

    new_payment_date = models.DateField()
    new_amount = models.DecimalField(max_digits=12, decimal_places=2)
    new_payment_method = models.CharField(max_length=10)

    reason = models.CharField(max_length=255)

    status = models.CharField(max_length=10, choices=STATUS_CHOICES, default='pending', db_index=True)
    admin_note = models.CharField(max_length=255, blank=True, default='')
    reviewed_by = models.CharField(max_length=150, blank=True, default='')
    reviewed_at = models.DateTimeField(null=True, blank=True)

    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'payment_edit_requests'
        ordering = ['-created_at']

    def __str__(self):
        return f'Edit request #{self.pk} for payment #{self.payment_id} ({self.status})'
