<?php
namespace ABeCe\Booking\Repository;
use ABeCe\Booking\Domain\CatalogException;
/** Append-only payment audit; reversal is a separate refund row. */
final class PaymentTransactionsRepository {
 public function __construct(private readonly \wpdb $wpdb) {}
 public function forBooking(int $id): array {
  $wpdb = $this->wpdb;
  $rows=$wpdb->get_results($wpdb->prepare('SELECT * FROM %i WHERE booking_id=%d ORDER BY id',\ABeCe\Booking\Infrastructure\Database\Tables::name( $wpdb, 'payment_transactions' ),$id),ARRAY_A);if($wpdb->last_error)$this->fail();
  foreach($rows as &$row)foreach(['id','booking_id','user_id','amount'] as $key)$row[$key]=null===$row[$key]?null:(int)$row[$key];unset($row);return $rows;
 }
 public function append(array $row): int {if(false===$this->wpdb->insert(\ABeCe\Booking\Infrastructure\Database\Tables::name( $this->wpdb, 'payment_transactions' ),$row))$this->fail();return (int)$this->wpdb->insert_id;}
 private function fail(): never {throw new CatalogException('abece_booking_financial_database_error',__('The financial operation could not be completed. Please try again.','abece-booking'),503);}
}