=== EPS PAYMENT DEBUG ===

TEST 1: Hash Generation
EPS_USER: Epsdemo@gmail.com
EPS_HASH_KEY: FHZxyzeps56789gfhg678ygu876o=
Hash(EPS_USER): y74VdLnmZoMCi+0EAkdRHwcdNnI3B/8+T9yuV0XQa3ZVBR5LU9lAUXewHmkBmLQ8X8eLzacw2/rEiKi/4OQ/uw==
Hash(txnId): OXqVfOyPWk4BriyF7mra63YVctOBlYzPA1fSPST7EqGzPDozjf/nBnTyTpU16g7qBi8qqj0iwtpbEDAb8j+FPQ==

TEST 2: GetToken API
URL: https://sandboxpgapi.eps.com.bd/v1/Auth/GetToken
HTTP Code: 200
CURL Error: none
Raw Response: {"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6Ijc2NmU4MzQ2LTI5YzQtNGRmZi04YTE1LTMxMDExNTZjMjNkMSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL25hbWUiOiJFcHNkZW1vQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL2dpdmVubmFtZSI6IkVwc2RlbW8iLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9lbWFpbGFkZHJlc3MiOiJFcHNkZW1vQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcm9sZSI6IlN5c3RlbU1lcmNoYW50IiwiZXhwIjoxNzgwMjAwNzUzLCJpc3MiOiJ4eXouY29tIiwiYXVkIjoieHl6LmNvbSJ9.SGDBs_O1l4Xv4IwmwnGIP-sn2gdtfZ2fHx29XehYhgo","expireDate":"2026-05-31T10:12:33.7284591","errorMessage":null,"errorCode":null}
Token extracted: ✅ eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ...

TEST 3: Verify Transaction (API #03)
TxnId: VP20260429041549551
Verify URL: https://sandboxpgapi.eps.com.bd/v1/EPSEngine/CheckMerchantTransactionStatus
Verify Hash: OXqVfOyPWk4BriyF7mra63YVctOBlYzPA1fSPST7EqGzPDozjf/nBnTyTpU16g7qBi8qqj0iwtpbEDAb8j+FPQ==
Full URL: https://sandboxpgapi.eps.com.bd/v1/EPSEngine/CheckMerchantTransactionStatus?merchantTransactionId=VP20260429041549551
HTTP Code: 200
CURL Error: none
Raw Response: {"MerchantTransactionId":"VP20260429041549551","EPSTransactionId":"7265810040429C","Status":"Success","TotalAmount":"499.00","StoreAmount":"490.52","TransactionDate":"29 Apr 2026 10:10:58 AM","TransactionType":"P2P_B2B_FundTransfer","FinancialEntity":"BKash","ErrorCode":null,"ErrorMessage":null,"CustomerId":null,"CustomerName":"AdminFree","CustomerEmail":"adminf@gmail.com","CustomerAddress":"Dhaka","CustomerAddress2":null,"CustomerCity":"Dhaka","CustomerState":"Dhaka","CustomerPostcode":"1200","CustomerCountry":"BD","CustomerPhone":"01714410620","ShipmentName":null,"ShipmentAddress":null,"ShipmentAddress2":null,"ShipmentCity":null,"ShipmentState":null,"ShipmentPostcode":null,"ShipmentCountry":null,"ValueA":null,"ValueB":null,"ValueC":null,"ValueD":null,"ShippingMethod":"NO","NoOfItem":"1","ProductName":"VocabPanda Monthly Pro","ProductProfile":"digital-goods","ProductCategory":"Subscription","PaymentReferance":null,"PaymentId":""}
Status field: Success

✅ EPS VERIFIED! Status = Success

TEST 4: DB Update
Found in DB: user_id=10, sub_id=44, plan=monthly, status=success
ℹ️  Already marked success — no update needed

TEST 5: Current DB State
payment_transactions.status = success
subscriptions.status        = active
users.is_pro                = 1
users.pro_expires_at        = 2026-05-29 14:44:29

TEST 6: All 'initiated' Transactions
  VP20260502172653744 | ৳99.00 | 2026-05-02 23:26:53

=== DEBUG COMPLETE ===