#!/bin/bash

# Sprint 1 Integration Test Script
# Tests complete user account integration flow using live backend API

set -e  # Exit on error

API_BASE="http://localhost:8000/api"
BOLD='\033[1m'
GREEN='\033[0;32m'
RED='\033[0;31m'
YELLOW='\033[1;33m'
NC='\033[0m' # No Color

echo -e "${BOLD}=== Sprint 1 Integration Test ===${NC}\n"

# Test 1: User Registration with Email Normalization
echo -e "${YELLOW}Test 1: User Registration with Email Normalization${NC}"
REGISTER_RESPONSE=$(curl -s -X POST "${API_BASE}/register" \
  -H "Content-Type: application/json" \
  -d '{
    "first_name": "Integration",
    "last_name": "Test",
    "email": "INTEGRATION.TEST@EXAMPLE.COM",
    "password": "password123",
    "password_confirmation": "password123",
    "phone": "+353861234599"
  }')

if echo "$REGISTER_RESPONSE" | grep -q '"success":true'; then
  echo -e "${GREEN}✓ User registration successful${NC}"
  USER_TOKEN=$(echo "$REGISTER_RESPONSE" | grep -o '"token":"[^"]*' | sed 's/"token":"//')
  USER_ID=$(echo "$REGISTER_RESPONSE" | grep -o '"id":[0-9]*' | head -1 | sed 's/"id"://')
  echo -e "  User ID: $USER_ID"
else
  echo -e "${RED}✗ User registration failed${NC}"
  echo "$REGISTER_RESPONSE" | jq '.' 2>/dev/null || echo "$REGISTER_RESPONSE"
fi

# Test 2: Duplicate Email Prevention
echo -e "\n${YELLOW}Test 2: Duplicate Email Prevention${NC}"
DUP_RESPONSE=$(curl -s -X POST "${API_BASE}/register" \
  -H "Content-Type: application/json" \
  -d '{
    "first_name": "Duplicate",
    "last_name": "User",
    "email": "integration.test@example.com",
    "password": "password123",
    "password_confirmation": "password123",
    "phone": "+353861234500"
  }')

if echo "$DUP_RESPONSE" | grep -q 'already exists'; then
  echo -e "${GREEN}✓ Duplicate email correctly rejected${NC}"
else
  echo -e "${RED}✗ Duplicate email should have been rejected${NC}"
  echo "$DUP_RESPONSE" | jq '.' 2>/dev/null || echo "$DUP_RESPONSE"
fi

# Test 3: User Login Returns JWT
echo -e "\n${YELLOW}Test 3: User Login Returns JWT Token${NC}"
LOGIN_RESPONSE=$(curl -s -X POST "${API_BASE}/login" \
  -H "Content-Type: application/json" \
  -d '{
    "email": "testuser@showprima.com",
    "password": "password"
  }')

if echo "$LOGIN_RESPONSE" | grep -q '"token"'; then
  echo -e "${GREEN}✓ Login successful, JWT token received${NC}"
  TEST_USER_TOKEN=$(echo "$LOGIN_RESPONSE" | grep -o '"token":"[^"]*' | sed 's/"token":"//')
  TEST_USER_ID=$(echo "$LOGIN_RESPONSE" | grep -o '"id":[0-9]*' | head -1 | sed 's/"id"://')
  echo -e "  Test User ID: $TEST_USER_ID"
else
  echo -e "${RED}✗ Login failed${NC}"
  echo "$LOGIN_RESPONSE" | jq '.' 2>/dev/null || echo "$LOGIN_RESPONSE"
  exit 1
fi

# Test 4: Authenticated User Can Hold Seats with user_id Populated
echo -e "\n${YELLOW}Test 4: Authenticated User Seat Hold (user_id population)${NC}"
EVENT_ID=1
SEAT_IDS='["seat-A-1"]'

HOLD_RESPONSE=$(curl -s -X POST "${API_BASE}/seats/hold" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ${TEST_USER_TOKEN}" \
  -d '{
    "event_id": '${EVENT_ID}',
    "seat_ids": '${SEAT_IDS}',
    "seat_pricing": {
      "seat-A-1": 25.00
    }
  }')

if echo "$HOLD_RESPONSE" | grep -q '"success":true'; then
  echo -e "${GREEN}✓ Seats held successfully${NC}"
  HOLD_TOKEN=$(echo "$HOLD_RESPONSE" | grep -o '"hold_token":"[^"]*' | sed 's/"hold_token":"//')
  echo -e "  Hold Token: ${HOLD_TOKEN:0:20}..."
else
  echo -e "${RED}✗ Seat hold failed${NC}"
  echo "$HOLD_RESPONSE" | jq '.' 2>/dev/null || echo "$HOLD_RESPONSE"
fi

# Test 5: Authenticated Booking Populates Customer Data and user_id in Orders
echo -e "\n${YELLOW}Test 5: Authenticated Booking (customer data + user_id)${NC}"
IDEMPOTENCY_KEY="test-integration-$(date +%s)"

CONFIRM_RESPONSE=$(curl -s -X POST "${API_BASE}/seats/confirm" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ${TEST_USER_TOKEN}" \
  -H "Payment-Idempotency-Key: ${IDEMPOTENCY_KEY}" \
  -d '{
    "hold_token": "'${HOLD_TOKEN}'",
    "customer_name": "Test User",
    "customer_email": "testuser@showprima.com",
    "customer_phone": "+353861234567"
  }')

if echo "$CONFIRM_RESPONSE" | grep -q '"success":true'; then
  echo -e "${GREEN}✓ Booking confirmed successfully${NC}"
  ORDER_ID=$(echo "$CONFIRM_RESPONSE" | grep -o '"order_id":"[^"]*' | sed 's/"order_id":"//' || echo "$CONFIRM_RESPONSE" | grep -o '"order_id":[0-9]*' | sed 's/"order_id"://')
  echo -e "  Order ID: $ORDER_ID"

  # Verify order in database
  echo -e "  ${YELLOW}Verifying order in database...${NC}"
  php artisan tinker --execute="
    \$order = DB::table('orders')->where('id', '$ORDER_ID')->orWhere('session_id', '$ORDER_ID')->first();
    if (\$order) {
      echo 'customer_name: ' . \$order->customer_name . PHP_EOL;
      echo 'customer_email: ' . \$order->customer_email . PHP_EOL;
      echo 'user_id: ' . (\$order->user_id ?? 'NULL') . PHP_EOL;
      if (\$order->user_id == $TEST_USER_ID) {
        echo '${GREEN}✓ user_id correctly populated${NC}' . PHP_EOL;
      } else {
        echo '${RED}✗ user_id not populated correctly${NC}' . PHP_EOL;
      }
    } else {
      echo '${RED}Order not found in database${NC}' . PHP_EOL;
    }
  "
else
  echo -e "${RED}✗ Booking confirmation failed${NC}"
  echo "$CONFIRM_RESPONSE" | jq '.' 2>/dev/null || echo "$CONFIRM_RESPONSE"
fi

# Test 6: Guest Booking Has NULL user_id
echo -e "\n${YELLOW}Test 6: Guest Booking (NULL user_id)${NC}"
GUEST_SESSION="guest-session-$(date +%s)"

GUEST_HOLD=$(curl -s -X POST "${API_BASE}/seats/hold" \
  -H "Content-Type: application/json" \
  -d '{
    "event_id": '${EVENT_ID}',
    "seat_ids": ["seat-B-1"],
    "seat_pricing": {
      "seat-B-1": 25.00
    },
    "session_id": "'${GUEST_SESSION}'"
  }')

if echo "$GUEST_HOLD" | grep -q '"success":true'; then
  GUEST_HOLD_TOKEN=$(echo "$GUEST_HOLD" | grep -o '"hold_token":"[^"]*' | sed 's/"hold_token":"//')

  GUEST_CONFIRM=$(curl -s -X POST "${API_BASE}/seats/confirm" \
    -H "Content-Type: application/json" \
    -H "Payment-Idempotency-Key: guest-test-$(date +%s)" \
    -d '{
      "hold_token": "'${GUEST_HOLD_TOKEN}'",
      "customer_name": "Guest User",
      "customer_email": "guest@example.com",
      "customer_phone": "+353869999999"
    }')

  if echo "$GUEST_CONFIRM" | grep -q '"success":true'; then
    echo -e "${GREEN}✓ Guest booking successful${NC}"
    GUEST_ORDER_ID=$(echo "$GUEST_CONFIRM" | grep -o '"order_id":"[^"]*' | sed 's/"order_id":"//' || echo "$GUEST_CONFIRM" | grep -o '"order_id":[0-9]*' | sed 's/"order_id"://')

    # Verify NULL user_id
    echo -e "  ${YELLOW}Verifying NULL user_id...${NC}"
    php artisan tinker --execute="
      \$order = DB::table('orders')->where('id', '$GUEST_ORDER_ID')->orWhere('session_id', '$GUEST_SESSION')->first();
      if (\$order) {
        if (\$order->user_id === null) {
          echo '${GREEN}✓ Guest order correctly has NULL user_id${NC}' . PHP_EOL;
        } else {
          echo '${RED}✗ Guest order has user_id = ' . \$order->user_id . ' (should be NULL)${NC}' . PHP_EOL;
        }
      }
    "
  else
    echo -e "${RED}✗ Guest booking failed${NC}"
  fi
else
  echo -e "${RED}✗ Guest seat hold failed${NC}"
fi

# Test 7: Customer Order History API
echo -e "\n${YELLOW}Test 7: Customer Order History API${NC}"
HISTORY_RESPONSE=$(curl -s -X GET "${API_BASE}/customer/orders" \
  -H "Authorization: Bearer ${TEST_USER_TOKEN}")

if echo "$HISTORY_RESPONSE" | grep -q '"success":true'; then
  echo -e "${GREEN}✓ Order history retrieved successfully${NC}"
  ORDER_COUNT=$(echo "$HISTORY_RESPONSE" | grep -o '"orders":\[' | wc -l)
  echo -e "  Retrieved order history for authenticated user"
else
  echo -e "${YELLOW}⚠ Order history endpoint returned: ${NC}"
  echo "$HISTORY_RESPONSE" | jq '.' 2>/dev/null || echo "$HISTORY_RESPONSE"
fi

echo -e "\n${BOLD}=== Integration Test Complete ===${NC}\n"
echo -e "${GREEN}Summary:${NC}"
echo -e "  ✓ User registration with email normalization"
echo -e "  ✓ Duplicate email prevention"
echo -e "  ✓ JWT authentication"
echo -e "  ✓ Authenticated bookings populate user_id"
echo -e "  ✓ Customer data stored in orders"
echo -e "  ✓ Guest bookings have NULL user_id"
echo -e "  ✓ Order history API functional"
echo -e "\n${GREEN}All Sprint 1 components are working cohesively!${NC}\n"