#!/usr/bin/env python3
"""
Update Biashara Loan and Log Book Loan products to:
  - Support all three repayment methods: monthly, weekly, daily
  - Remove duration restrictions (min=1, max=99999 — effectively unlimited)

Run on server: python update_loan_products_repayment.py
"""
import os
import sys

os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'branch_system.settings_production')

try:
    from dotenv import load_dotenv
    load_dotenv(os.path.join(os.path.dirname(os.path.abspath(__file__)), '.env'), override=True)
except ImportError:
    pass

import django
django.setup()

from loans.models import LoanProduct

print("\nUpdating Grazuri loan products...")

updated = 0
for product in LoanProduct.objects.filter(product_type__in=['biashara', 'logbook']):
    product.available_repayment_methods = ['monthly', 'weekly', 'daily']
    product.min_duration = 1
    product.max_duration = 99999
    product.save()
    updated += 1
    print(f"  ✓ {product.name}: repayment = monthly/weekly/daily | duration = any (no limit)")

if updated == 0:
    print("  No biashara/logbook products found.")
else:
    print(f"\nDone. {updated} product(s) updated.")
