/**
 * currency_helpers.php
 * /app/Helpers/currency_helpers.php
 * This original/initial version is DEPRECATED
 */

// Critical Info:

/* ************
All previous/existing fees fetching, fees structure, fees application/implementation, fees calculation, as well as all previous/existing fx rates, fx conversion, currency data, currency settings, currency formatting, calculation, etc helpers, methods, functions and classes must now delegate to the NEW currency + fees management suite, which implements records in the following db tables as source of truth for my fintech app/website platform.

modular_currency_data,
modular_currency_rates,
modular_currency_rates_history,
modular_currency_settings,
modular_fee_internal_names,
modular_fee_process_types,
modular_fee_structures

These NEW currency + fees management suite scripts include:
/app/Classes/PaymentModule.php
/app/Classes/fxMasterSuite.php
/app/Classes/SimpleFileCache.php

Fee structures are created and managed by the super_admin with the following script:
/app/Legacy/admin/fees-management.php which has been adapted from /app/Legacy/admin/admin_fees_management.php 
************  */





/**
 * ============================================================================
 * CURRENCY HELPERS
 * ============================================================================
 */

/**
 * Get currency symbol from database (with fallback)
 * 
 * @param string $currencyCode The currency code (e.g., USD, NGN)
 * @param mysqli|null $db Database connection (optional)
 * @return string Currency symbol
 */
function getCurrencySymbol($currencyCode, $db = null) {
    // Try to use FxCalculator first (most reliable)
    global $fxCalculator;
    
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        return $fxCalculator->getCurrencySymbol($currencyCode);
    }
    
    // Try database lookup
    if ($db) {
        try {
            $stmt = $db->prepare("SELECT symbol FROM currency_data WHERE currency_code = ? AND is_active = 1");
            $stmt->bind_param('s', $currencyCode);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($row = $result->fetch_assoc()) {
                return $row['symbol'];
            }
        } catch (Exception $e) {
            error_log("Error getting currency symbol: " . $e->getMessage());
        }
    }
    
    // Fallback symbols
    $symbols = [
        'USD' => '$', 'EUR' => '€', 'GBP' => '£', 'NGN' => '₦',
        'GHS' => 'GH₵', 'KES' => 'KSh', 'ZAR' => 'R', 'CNY' => '¥',
        'JPY' => '¥', 'CAD' => 'C$', 'AUD' => 'A$', 'CHF' => 'Fr',
        'INR' => '₹', 'BRL' => 'R$', 'MXN' => '$', 'SGD' => 'S$'
    ];
    return $symbols[$currencyCode] ?? '$';
}

/**
 * Format amount with currency symbol
 * 
 * @param float|int|string $amount The amount to format
 * @param string $currencyCode The currency code
 * @param int|null $decimals Number of decimal places (optional, uses currency defaults)
 * @param mysqli|null $db Database connection (optional)
 * @return string Formatted amount with currency symbol
 */
function formatCurrency($amount, $currencyCode, $decimals = null, $db = null) {
    // Try to use FxCalculator
    global $fxCalculator;
    
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        return $fxCalculator->formatAmount($amount, $currencyCode, $decimals);
    }
    
    // Get decimals from database if not provided
    if ($decimals === null && $db) {
        try {
            $stmt = $db->prepare("SELECT decimals FROM currency_data WHERE currency_code = ? AND is_active = 1");
            $stmt->bind_param('s', $currencyCode);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($row = $result->fetch_assoc()) {
                $decimals = (int)$row['decimals'];
            }
        } catch (Exception $e) {
            error_log("Error getting decimals: " . $e->getMessage());
        }
    }
    
    $decimals = $decimals ?? 2;
    $symbol = getCurrencySymbol($currencyCode, $db);
    $formatted = number_format((float)$amount, $decimals);
    return $symbol . $formatted;
}

/**
 * Convert amount between currencies using MasterFxCalculator
 * 
 * @param float|int|string $amount The amount to convert
 * @param string $fromCurrency Source currency code
 * @param string $toCurrency Target currency code
 * @param mysqli|null $db Database connection (optional)
 * @return float Converted amount
 */
function convertCurrency($amount, $fromCurrency, $toCurrency, $db = null) {
    // If same currency, no conversion needed
    if ($fromCurrency === $toCurrency) {
        return (float)$amount;
    }
    
    // Try to use FxCalculator (most reliable)
    global $fxCalculator;
    
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        $rate = $fxCalculator->getRate($fromCurrency, $toCurrency);
        return (float)$amount * $rate;
    }
    
    // Fallback: query database directly
    if ($db) {
        $baseCurrency = getBaseCurrency($db);
        
        try {
            $stmt = $db->prepare("SELECT external_rates FROM currency_rates 
                                  WHERE base_currency = ? 
                                  ORDER BY last_updated DESC LIMIT 1");
            $stmt->bind_param('s', $baseCurrency);
            $stmt->execute();
            $result = $stmt->get_result();
            $row = $result->fetch_assoc();
            
            if ($row) {
                $rates = json_decode($row['external_rates'], true);
                
                if (isset($rates[$fromCurrency]) && isset($rates[$toCurrency])) {
                    $inBase = (float)$amount / $rates[$fromCurrency];
                    return $inBase * $rates[$toCurrency];
                }
            }
        } catch (Exception $e) {
            error_log("Error converting currency: " . $e->getMessage());
        }
    }
    
    // Ultimate fallback - return original amount
    error_log("Currency conversion failed, using original amount: $fromCurrency -> $toCurrency");
    return (float)$amount;
}

/**
 * Get base currency from database
 * 
 * @param mysqli|null $db Database connection (optional)
 * @return string Base currency code
 */
/**
 * Get base currency from database - SOURCE OF TRUTH: currency_settings table
 */
function getBaseCurrency($db = null) {
    static $baseCurrency = null;
    
    if ($baseCurrency !== null) {
        return $baseCurrency;
    }
    
    // Try to use MasterFxCalculator first (it now uses currency_settings)
    global $fxCalculator;
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        $baseCurrency = $fxCalculator->getBaseCurrency();
        return $baseCurrency;
    }
    
    // Direct database query if calculator not available
    if ($db) {
        try {
            // PRIMARY SOURCE: currency_settings
            $result = $db->query("SELECT base_currency FROM currency_settings WHERE id = 1");
            if ($result && $row = $result->fetch_assoc()) {
                $baseCurrency = $row['base_currency'];
                return $baseCurrency;
            }
            
            // FALLBACK: folrun_currency_settings
            $result = $db->query("SELECT base_currency FROM folrun_currency_settings WHERE id = 1");
            if ($result && $row = $result->fetch_assoc()) {
                $baseCurrency = $row['base_currency'];
                return $baseCurrency;
            }
        } catch (Exception $e) {
            error_log("Error getting base currency: " . $e->getMessage());
        }
    }
    
    $baseCurrency = defined('DEFAULT_BASE_CURRENCY') ? DEFAULT_BASE_CURRENCY : 'USD';
    return $baseCurrency;
}


/**
 * Get fee by key from database
 */
function getFeeByKey_XXX($feeKey, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    try {
        $stmt = $db->prepare("SELECT fee_value, fee_type FROM folrun_fee_settings 
                              WHERE fee_key = ? AND is_active = 1 LIMIT 1");
        if ($stmt) {
            $stmt->bind_param('s', $feeKey);
            $stmt->execute();
            $result = $stmt->get_result();
            return $result->fetch_assoc();
        }
    } catch (Exception $e) {
        error_log("Error getting fee by key: " . $e->getMessage());
    }
    
    return null;
}



/**
 * Get fee by transaction type, wallet type, and user role
 */
function getFeeByTransactionAndWallet($transactionType, $walletType, $userRole, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    try {
        $sql = "SELECT * FROM folrun_fee_settings 
                WHERE is_active = 1 
                AND (transaction_type = ? OR transaction_type = 'all')
                AND (wallet_type = ? OR wallet_type = 'all')
                AND (user_role = ? OR user_role = 'all')
                ORDER BY 
                    CASE WHEN transaction_type = ? THEN 1 ELSE 2 END,
                    CASE WHEN wallet_type = ? THEN 1 ELSE 2 END,
                    CASE WHEN user_role = ? THEN 1 ELSE 2 END
                LIMIT 1";
        
        $stmt = $db->prepare($sql);
        $stmt->bind_param('ssssss', $transactionType, $walletType, $userRole, $transactionType, $walletType, $userRole);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->fetch_assoc();
    } catch (Exception $e) {
        error_log("Error getting fee by transaction and wallet: " . $e->getMessage());
        return null;
    }
}



/**
 * Get admin currency from database
 * 
 * @param mysqli|null $db Database connection (optional)
 * @return string Admin currency code
 */
function getAdminCurrency($db = null) {
    static $adminCurrency = null;
    
    if ($adminCurrency !== null) {
        return $adminCurrency;
    }
    
    global $fxCalculator;
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        $adminCurrency = $fxCalculator->getAdminCurrency();
        return $adminCurrency;
    }
    
    if ($db) {
        try {
            $result = $db->query("SELECT default_admin_currency FROM currency_settings WHERE id = 1");
            if ($result && $row = $result->fetch_assoc()) {
                $adminCurrency = $row['default_admin_currency'];
                return $adminCurrency;
            }
            
            $result = $db->query("SELECT default_admin_currency FROM folrun_currency_settings WHERE id = 1");
            if ($result && $row = $result->fetch_assoc()) {
                $adminCurrency = $row['default_admin_currency'];
                return $adminCurrency;
            }
        } catch (Exception $e) {
            error_log("Error getting admin currency: " . $e->getMessage());
        }
    }
    
    $adminCurrency = defined('DEFAULT_ADMIN_CURRENCY') ? DEFAULT_ADMIN_CURRENCY : 'GHS';
    return $adminCurrency;
}

/**
 * Get all active currencies with rates
 * 
 * @param mysqli $db Database connection
 * @return array Array of currencies with their data and rates
 */
function getAllCurrenciesWithRates($db) {
    $baseCurrency = getBaseCurrency($db);
    $currencies = [];
    
    try {
        // Get currency data
        $result = $db->query("SELECT currency_code, symbol, name, decimals, fallback_rate 
                              FROM currency_data WHERE is_active = 1 
                              ORDER BY currency_code");
        if ($result) {
            while ($row = $result->fetch_assoc()) {
                $currencies[$row['currency_code']] = [
                    'name' => $row['name'],
                    'symbol' => $row['symbol'],
                    'decimals' => (int)$row['decimals'],
                    'fallback_rate' => (float)$row['fallback_rate']
                ];
            }
        }
        
        // Get current rates
        $stmt = $db->prepare("SELECT external_rates, internal_rates_from, internal_rates_to 
                              FROM currency_rates WHERE base_currency = ? 
                              ORDER BY last_updated DESC LIMIT 1");
        $stmt->bind_param('s', $baseCurrency);
        $stmt->execute();
        $result = $stmt->get_result();
        $row = $result->fetch_assoc();
        
        $externalRates = $row ? json_decode($row['external_rates'], true) : [];
        $internalFrom = $row ? json_decode($row['internal_rates_from'], true) : [];
        $internalTo = $row ? json_decode($row['internal_rates_to'], true) : [];
        
        foreach ($currencies as $code => &$data) {
            $data['rate'] = $externalRates[$code] ?? $data['fallback_rate'];
            $data['rate_from'] = $internalFrom[$code] ?? $data['rate'];
            $data['rate_to'] = $internalTo[$code] ?? $data['rate'];
            $data['base_currency'] = $baseCurrency;
        }
        
    } catch (Exception $e) {
        error_log("Error getting currencies with rates: " . $e->getMessage());
    }
    
    return $currencies;
}

/**
 * Get active currencies list (without rates)
 * 
 * @param mysqli $db Database connection
 * @return array Array of active currencies
 */
function getActiveCurrencies($db): array {
    $currencies = [];
    try {
        $result = $db->query("SELECT currency_code, symbol, name, decimals 
                              FROM currency_data WHERE is_active = 1 
                              ORDER BY currency_code");
        if ($result) {
            while ($row = $result->fetch_assoc()) {
                $currencies[$row['currency_code']] = [
                    'symbol' => $row['symbol'],
                    'name' => $row['name'],
                    'decimals' => (int)$row['decimals']
                ];
            }
        }
    } catch (Exception $e) {
        error_log("Error getting active currencies: " . $e->getMessage());
    }
    return $currencies;
}

/**
 * ============================================================================
 * FEE HELPERS
 * ============================================================================
 */

/**
 * Get fee structure for a specific transaction
 * 
 * @param mysqli $db Database connection
 * @param string $transaction_type Transaction type (deposit, withdrawal, etc.)
 * @param string $wallet_type Wallet type (funding, earnings, etc.)
 * @param float|int $amount Transaction amount
 * @param MasterFxCalculator|null $fxCalculator Optional FX calculator instance
 * @return array Fee breakdown
 */
function getTransactionFees($db, $transaction_type, $wallet_type, $amount, $fxCalculator = null) {
    $fees = [
        'fx_spread' => 0,
        'main_fee' => 0,
        'total' => 0
    ];
    
    try {
        // Get FX spread - try to use FxCalculator first
        if ($fxCalculator && $fxCalculator instanceof MasterFxCalculator) {
            $fees['fx_spread'] = $fxCalculator->getFee('fx_spread_nominal_perc', 0.05);
        } else {
            $sql = "SELECT fee_value FROM fee_settings 
                    WHERE fee_key = 'fx_spread' AND is_active = 1 LIMIT 1";
            $result = $db->query($sql);
            if ($result && $row = $result->fetch_assoc()) {
                $fees['fx_spread'] = (float)$row['fee_value'] / 100;
            } else {
                $fees['fx_spread'] = 0.05;
            }
        }
        
        // Get transaction-specific fee
        $sql = "SELECT * FROM fee_settings 
                WHERE (transaction_type = ? OR transaction_type = 'all')
                AND (wallet_type = ? OR wallet_type = 'all')
                AND is_active = 1
                ORDER BY 
                    CASE WHEN transaction_type = ? THEN 1 
                         WHEN transaction_type = 'all' THEN 3 
                         ELSE 2 END,
                    CASE WHEN wallet_type = ? THEN 1 
                         WHEN wallet_type = 'all' THEN 3 
                         ELSE 2 END
                LIMIT 1";
        $stmt = $db->prepare($sql);
        $stmt->bind_param('ssss', $transaction_type, $wallet_type, $transaction_type, $wallet_type);
        $stmt->execute();
        $feeSetting = $stmt->get_result()->fetch_assoc();
        
        if ($feeSetting) {
            if ($feeSetting['fee_type'] === 'flexible') {
                if ($amount < $feeSetting['threshold_amount']) {
                    $fees['main_fee'] = (float)$feeSetting['fixed_fee_value'];
                } else {
                    $fees['main_fee'] = $amount * ((float)$feeSetting['percentage_fee_value'] / 100);
                }
            } elseif ($feeSetting['fee_type'] === 'percentage') {
                $fees['main_fee'] = $amount * ((float)$feeSetting['fee_value'] / 100);
            } elseif ($feeSetting['fee_type'] === 'fixed') {
                $fees['main_fee'] = (float)$feeSetting['fee_value'];
            }
        } else {
            $fees['main_fee'] = $amount * 0.10; // Default 10%
        }
        
        $fees['total'] = ($amount * $fees['fx_spread']) + $fees['main_fee'];
        
    } catch (Exception $e) {
        error_log("Error getting fees: " . $e->getMessage());
        $fees['fx_spread'] = 0.05;
        $fees['main_fee'] = $amount * 0.10;
        $fees['total'] = ($amount * 0.05) + ($amount * 0.10);
    }
    
    return $fees;
}

/**
 * Get a specific fee by key
 * 
 * @param mysqli $db Database connection
 * @param string $feeKey The fee key to retrieve
 * @param mixed $default Default value if fee not found
 * @return mixed Fee value or array for flexible fees
 */
 
/*
function getFeeByKey($db, $feeKey, $default = 0) {
    try {
        $sql = "SELECT fee_value, fee_type, threshold_amount, fixed_fee_value, percentage_fee_value 
                FROM fee_settings 
                WHERE fee_key = ? AND is_active = 1 
                LIMIT 1";
        $stmt = $db->prepare($sql);
        $stmt->bind_param('s', $feeKey);
        $stmt->execute();
        $result = $stmt->get_result();
        $fee = $result->fetch_assoc();
        
        if ($fee) {
            if ($fee['fee_type'] === 'percentage') {
                return (float)$fee['fee_value'] / 100;
            } elseif ($fee['fee_type'] === 'fixed') {
                return (float)$fee['fee_value'];
            } elseif ($fee['fee_type'] === 'flexible') {
                return [
                    'type' => 'flexible',
                    'threshold' => (float)$fee['threshold_amount'],
                    'fixed_fee' => (float)$fee['fixed_fee_value'],
                    'percentage_fee' => (float)$fee['percentage_fee_value']
                ];
            }
        }
    } catch (Exception $e) {
        error_log("Error getting fee by key: " . $e->getMessage());
    }
    return $default;
}
*/



/**
 * Get all active fees
 * 
 * @param mysqli $db Database connection
 * @return array Array of all active fees
 */
function getAllFees($db): array {
    $fees = [];
    try {
        $result = $db->query("SELECT * FROM fee_settings WHERE is_active = 1 ORDER BY sort_order");
        if ($result) {
            while ($row = $result->fetch_assoc()) {
                $fees[] = $row;
            }
        }
    } catch (Exception $e) {
        error_log("Error getting all fees: " . $e->getMessage());
    }
    return $fees;
}

/**
 * ============================================================================
 * USER CURRENCY HELPERS
 * ============================================================================
 */

/**
 * Get user's effective currency
 * 
 * @param int $user_id User ID
 * @param mysqli|null $db Database connection (optional)
 * @return string User's currency code
 */
function getUserCurrency($user_id, $db = null) {
    static $cache = [];
    
    if (isset($cache[$user_id])) {
        return $cache[$user_id];
    }
    
    // Try to use UserManager if available
    global $userManager;
    if (isset($userManager) && $userManager instanceof UserManager) {
        $user = $userManager->getUser($user_id);
        if ($user && isset($user['currency_code'])) {
            $cache[$user_id] = $user['currency_code'];
            return $cache[$user_id];
        }
    }
    
    // Query database directly
    if ($db) {
        try {
            $stmt = $db->prepare("SELECT currency_code FROM users WHERE id = ?");
            $stmt->bind_param('i', $user_id);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($row = $result->fetch_assoc()) {
                $cache[$user_id] = $row['currency_code'];
                return $cache[$user_id];
            }
        } catch (Exception $e) {
            error_log("Error getting user currency: " . $e->getMessage());
        }
    }
    
    // Default fallback
    return defined('DEFAULT_USER_CURRENCY') ? DEFAULT_USER_CURRENCY : 'NGN';
}

/**
 * Update user's currency
 * 
 * @param int $user_id User ID
 * @param string $newCurrency New currency code
 * @param mysqli $db Database connection
 * @return bool True on success, false on failure
 */
function updateUserCurrency($user_id, $newCurrency, $db) {
    try {
        $stmt = $db->prepare("UPDATE users SET currency_code = ? WHERE id = ?");
        $stmt->bind_param('si', $newCurrency, $user_id);
        return $stmt->execute();
    } catch (Exception $e) {
        error_log("Error updating user currency: " . $e->getMessage());
        return false;
    }
}

/**
 * ============================================================================
 * UTILITY FUNCTIONS
 * ============================================================================
 */

/**
 * Calculate exchange rate impact (for display)
 * 
 * @param string $fromCurrency Source currency
 * @param string $toCurrency Target currency
 * @param float|int $amount Amount to convert
 * @param mysqli|null $db Database connection (optional)
 * @return array Exchange rate impact details
 */
function getExchangeRateImpact($fromCurrency, $toCurrency, $amount, $db = null) {
    $rate = convertCurrency(1, $fromCurrency, $toCurrency, $db);
    $result = $amount * $rate;
    
    return [
        'rate' => $rate,
        'original' => $amount,
        'converted' => $result,
        'formatted_original' => formatCurrency($amount, $fromCurrency, null, $db),
        'formatted_converted' => formatCurrency($result, $toCurrency, null, $db)
    ];
}

/**
 * Format amount in multiple currencies
 * 
 * @param float|int $amount Amount to format
 * @param array $currencies Array of currency codes
 * @param mysqli|null $db Database connection (optional)
 * @return array Formatted amounts by currency
 */
function formatMultiCurrency($amount, $currencies, $db = null) {
    $result = [];
    foreach ($currencies as $currency) {
        $result[$currency] = formatCurrency($amount, $currency, null, $db);
    }
    return $result;
}

/**
 * Validate currency code
 * 
 * @param string $currencyCode Currency code to validate
 * @param mysqli|null $db Database connection (optional)
 * @return bool True if currency is valid and active
 */
function isValidCurrency($currencyCode, $db = null) {
    if ($db) {
        try {
            $stmt = $db->prepare("SELECT id FROM currency_data WHERE currency_code = ? AND is_active = 1");
            $stmt->bind_param('s', $currencyCode);
            $stmt->execute();
            return $stmt->get_result()->num_rows > 0;
        } catch (Exception $e) {
            error_log("Error validating currency: " . $e->getMessage());
        }
    }
    
    $validCurrencies = ['USD', 'EUR', 'GBP', 'NGN', 'GHS', 'KES', 'ZAR', 'CNY'];
    return in_array(strtoupper($currencyCode), $validCurrencies);
}

/**
 * Get currency data for display
 * 
 * @param string $currencyCode Currency code
 * @param mysqli|null $db Database connection (optional)
 * @return array Currency display data
 */
function getCurrencyDisplayData($currencyCode, $db = null) {
    global $fxCalculator;
    
    if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
        $data = $fxCalculator->getCurrencyDataFromDb($currencyCode);
        return [
            'code' => $currencyCode,
            'symbol' => $data['symbol'] ?? '$',
            'name' => $data['name'] ?? $currencyCode,
            'decimals' => $data['decimals'] ?? 2
        ];
    }
    
    if ($db) {
        try {
            $stmt = $db->prepare("SELECT symbol, name, decimals FROM currency_data WHERE currency_code = ? AND is_active = 1");
            $stmt->bind_param('s', $currencyCode);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($row = $result->fetch_assoc()) {
                return [
                    'code' => $currencyCode,
                    'symbol' => $row['symbol'],
                    'name' => $row['name'],
                    'decimals' => (int)$row['decimals']
                ];
            }
        } catch (Exception $e) {
            error_log("Error getting currency display data: " . $e->getMessage());
        }
    }
    
    return [
        'code' => $currencyCode,
        'symbol' => getCurrencySymbol($currencyCode),
        'name' => $currencyCode,
        'decimals' => 2
    ];
}


/**
 * Get minimum deposit amount for a user based on their role
 * Returns amount in the system base currency (from database)
 * 
 * @param int $user_id User ID
 * @param mysqli|null $db Database connection
 * @return float Minimum deposit amount in system base currency (0 = no limit)
 */
function getMinimumDepositForUser($user_id, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 2.00;
    }
    
    // Get user's role
    $sql = "SELECT role FROM users WHERE id = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 2.00;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    
    if (!$user) {
        return 2.00;
    }
    
    $role = $user['role'];
    
    // Get limits for this role (amounts are in system base currency)
    $sql = "SELECT min_deposit_base FROM transaction_limits 
            WHERE role = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 2.00;
    }
    $stmt->bind_param('s', $role);
    $stmt->execute();
    $result = $stmt->get_result();
    $limit = $result->fetch_assoc();
    
    // Return 0 if no limit found (meaning no minimum)
    return $limit ? (float)$limit['min_deposit_base'] : 0;
}


/**
 * Get maximum deposit amount for a user based on their role
 * 
 * @param int $user_id User ID
 * @param mysqli|null $db Database connection
 * @return float Maximum deposit amount (0 = no limit)
 */
function getMaximumDepositForUser($user_id, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 0;
    }
    
    $sql = "SELECT role FROM users WHERE id = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    
    if (!$user) {
        return 0;
    }
    
    $role = $user['role'];
    
    $sql = "SELECT max_deposit_base FROM transaction_limits WHERE role = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('s', $role);
    $stmt->execute();
    $result = $stmt->get_result();
    $limit = $result->fetch_assoc();
    
    return $limit ? (float)$limit['max_deposit_base'] : 0;
}




/**
 * Get minimum withdrawal amount for a user based on their role
 * 
 * @param int $user_id User ID
 * @param string|null $currency Currency to return the amount in
 * @param mysqli|null $db Database connection
 * @return float Minimum withdrawal amount
 */
function getMinimumWithdrawalForUser($user_id, $currency = null, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 2.00;
    }
    
    $sql = "SELECT role FROM users WHERE id = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 2.00;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    
    if (!$user) {
        return 2.00;
    }
    
    $role = $user['role'];
    
    $sql = "SELECT min_withdrawal_base FROM transaction_limits 
            WHERE (role = ? OR role IS NULL)
            ORDER BY CASE WHEN role = ? THEN 0 ELSE 1 END
            LIMIT 1";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 2.00;
    }
    $stmt->bind_param('ss', $role, $role);
    $stmt->execute();
    $result = $stmt->get_result();
    $limit = $result->fetch_assoc();
    
    $minWithdrawalBase = $limit ? (float)$limit['min_withdrawal_base'] : 2.00;
    
    if ($currency !== null) {
        global $fxCalculator;
        if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
            return $fxCalculator->convert($minWithdrawalBase, 'USD', $currency);
        }
    }
    
    return $minWithdrawalBase;
}


/**
 * Get daily deposit limit for a user based on their role
 * 
 * @param int $user_id User ID
 * @param mysqli|null $db Database connection
 * @return float Daily deposit limit (0 = no limit)
 */
function getDailyDepositLimitForUser($user_id, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 0;
    }
    
    $sql = "SELECT role FROM users WHERE id = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    
    if (!$user) {
        return 0;
    }
    
    $role = $user['role'];
    
    $sql = "SELECT daily_deposit_limit_base FROM transaction_limits WHERE role = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('s', $role);
    $stmt->execute();
    $result = $stmt->get_result();
    $limit = $result->fetch_assoc();
    
    return $limit ? (float)$limit['daily_deposit_limit_base'] : 0;
}



/**
 * Get daily withdrawal limit for a user based on their role
 * CORRECTED: Uses 'daily_withdrawal_limit_base' column
 * 
 * @param int $user_id User ID
 * @param string|null $currency Currency to return the amount in
 * @param mysqli|null $db Database connection
 * @return float Daily withdrawal limit (0 = no limit)
 */
function getDailyWithdrawalLimitForUser($user_id, $currency = null, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 0;
    }
    
    $sql = "SELECT role FROM users WHERE id = ?";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    
    if (!$user) {
        return 0;
    }
    
    $role = $user['role'];
    
    // CORRECTED: Use 'daily_withdrawal_limit_base' column
    $sql = "SELECT daily_withdrawal_limit_base FROM transaction_limits 
            WHERE (role = ? OR role IS NULL)
            ORDER BY CASE WHEN role = ? THEN 0 ELSE 1 END
            LIMIT 1";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return 0;
    }
    $stmt->bind_param('ss', $role, $role);
    $stmt->execute();
    $result = $stmt->get_result();
    $limit = $result->fetch_assoc();
    
    $dailyLimitBase = $limit ? (float)$limit['daily_withdrawal_limit_base'] : 0;
    
    if ($currency !== null && $dailyLimitBase > 0) {
        global $fxCalculator;
        if (isset($fxCalculator) && $fxCalculator instanceof MasterFxCalculator) {
            return $fxCalculator->convert($dailyLimitBase, 'USD', $currency);
        }
    }
    
    return $dailyLimitBase;
}



/**
 * Get formatted minimum deposit string for display
 * 
 * @param int $user_id User ID
 * @param string $userCurrency User's currency code
 * @param mysqli|null $db Database connection
 * @return string Formatted minimum deposit string
 */
function getFormattedMinimumDeposit($user_id, $userCurrency, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    global $fxCalculator;
    
    $minInBase = getMinimumDepositForUser($user_id, null, $db);
    $minInUserCurrency = $fxCalculator->convert($minInBase, 'USD', $userCurrency);
    
    return $fxCalculator->formatAmount($minInUserCurrency, $userCurrency);
}





/**
 * Get remaining daily deposit allowance in system base currency
 * 
 * @param int $user_id User ID
 * @param mysqli|null $db Database connection
 * @return float Remaining daily deposit amount in system base currency
 */
function getRemainingDailyDepositAllowance($user_id, $db = null) {
    if ($db === null) {
        global $db;
    }
    
    if (!$db) {
        return 0;
    }
    
    $dailyLimit = getDailyDepositLimitForUser($user_id, $db);
    
    // If no daily limit, return a large number
    if ($dailyLimit <= 0) {
        return 99999999.00;
    }
    
    // Get today's total deposits (in system base currency)
    $sql = "SELECT COALESCE(SUM(gross_amount_base_curr), 0) as today_deposits 
            FROM all_transactions 
            WHERE user_id = ? 
            AND transaction_type = 'credit' 
            AND DATE(date_created) = CURDATE()
            AND status IN ('pending', 'processing', 'successful')";
    $stmt = $db->prepare($sql);
    if (!$stmt) {
        return $dailyLimit;
    }
    $stmt->bind_param('i', $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();
    
    $todayDeposits = (float)($row['today_deposits'] ?? 0);
    
    return max(0, $dailyLimit - $todayDeposits);
}<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>GigzSocial - Social Content Sharing Community</title>
    
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    
    <!-- Bootstrap Icons -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.8.1/font/bootstrap-icons.css">
    
    <!-- AOS Animation Library -->
    <link href="https://unpkg.com/aos@2.3.1/dist/aos.css" rel="stylesheet">
    
    <!-- Custom CSS -->
    <style>
        :root {
            --primary-color: #4e73df;
            --secondary-color: #1cc88a;
            --dark-color: #5a5c69;
            --light-color: #f8f9fc;
        }
        
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            overflow-x: hidden;
        }
        
        /* Navigation */
        .navbar {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            padding: 1rem 0;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
        }
        
        .navbar-brand {
            font-size: 1.8rem;
            font-weight: bold;
            color: white !important;
        }
        
        .navbar-brand i {
            margin-right: 10px;
            color: #ffd700;
        }
        
        .nav-link {
            color: rgba(255,255,255,0.9) !important;
            font-weight: 500;
            margin: 0 10px;
            transition: all 0.3s;
        }
        
        .nav-link:hover {
            color: white !important;
            transform: translateY(-2px);
        }
        
        .btn-register {
            background: white;
            color: #667eea !important;
            border-radius: 50px;
            padding: 0.5rem 1.5rem !important;
            font-weight: 600;
        }
        
        .btn-register:hover {
            background: #f8f9fa;
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.2);
        }
        
        /* Hero Section */
        .hero {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            padding: 100px 0;
            position: relative;
            overflow: hidden;
        }
        
        .hero::before {
            content: '';
            position: absolute;
            top: 0;
            left: 0;
            right: 0;
            bottom: 0;
            background: url('data:image/svg+xml,<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 1440 320"><path fill="rgba(255,255,255,0.1)" fill-opacity="1" d="M0,96L48,112C96,128,192,160,288,160C384,160,480,128,576,122.7C672,117,768,139,864,154.7C960,171,1056,181,1152,165.3C1248,149,1344,107,1392,85.3L1440,64L1440,320L1392,320C1344,320,1248,320,1152,320C1056,320,960,320,864,320C768,320,672,320,576,320C480,320,384,320,288,320C192,320,96,320,48,320L0,320Z"></path></svg>');
            background-repeat: no-repeat;
            background-position: bottom;
            background-size: cover;
            opacity: 0.1;
        }
        
        .hero h1 {
            font-size: 3.5rem;
            font-weight: 700;
            margin-bottom: 1.5rem;
        }
        
        .hero p {
            font-size: 1.2rem;
            margin-bottom: 2rem;
            opacity: 0.95;
        }
        
        .hero-stats {
            margin-top: 3rem;
        }
        
        .hero-stat {
            text-align: center;
            padding: 1rem;
        }
        
        .hero-stat h3 {
            font-size: 2rem;
            font-weight: 700;
            margin-bottom: 0.5rem;
        }
        
        .hero-stat p {
            font-size: 1rem;
            margin-bottom: 0;
            opacity: 0.8;
        }
        
        /* Features Section */
        .features {
            padding: 80px 0;
            background: var(--light-color);
        }
        
        .section-title {
            text-align: center;
            margin-bottom: 3rem;
        }
        
        .section-title h2 {
            font-size: 2.5rem;
            font-weight: 700;
            color: #333;
            margin-bottom: 1rem;
        }
        
        .section-title p {
            font-size: 1.1rem;
            color: #666;
            max-width: 700px;
            margin: 0 auto;
        }
        
        .feature-card {
            background: white;
            padding: 2rem;
            border-radius: 10px;
            text-align: center;
            box-shadow: 0 5px 20px rgba(0,0,0,0.05);
            transition: all 0.3s;
            height: 100%;
        }
        
        .feature-card:hover {
            transform: translateY(-10px);
            box-shadow: 0 10px 30px rgba(0,0,0,0.1);
        }
        
        .feature-icon {
            width: 80px;
            height: 80px;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            border-radius: 50%;
            display: flex;
            align-items: center;
            justify-content: center;
            margin: 0 auto 1.5rem;
            color: white;
            font-size: 2rem;
        }
        
        .feature-card h4 {
            font-size: 1.3rem;
            font-weight: 600;
            margin-bottom: 1rem;
            color: #333;
        }
        
        .feature-card p {
            color: #666;
            line-height: 1.6;
        }
        
        /* How It Works */
        .how-it-works {
            padding: 80px 0;
            background: white;
        }
        
        .step-card {
            text-align: center;
            padding: 2rem;
            position: relative;
        }
        
        .step-number {
            width: 60px;
            height: 60px;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            border-radius: 50%;
            display: flex;
            align-items: center;
            justify-content: center;
            margin: 0 auto 1.5rem;
            color: white;
            font-size: 1.5rem;
            font-weight: bold;
        }
        
        .step-card h4 {
            font-size: 1.3rem;
            font-weight: 600;
            margin-bottom: 1rem;
        }
        
        .step-card p {
            color: #666;
        }
        
        /* Content Showcase */
        .content-showcase {
            padding: 80px 0;
            background: var(--light-color);
        }
        
        .content-card {
            background: white;
            border-radius: 10px;
            overflow: hidden;
            box-shadow: 0 5px 20px rgba(0,0,0,0.05);
            transition: all 0.3s;
            height: 100%;
        }
        
        .content-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 10px 30px rgba(0,0,0,0.1);
        }
        
        .content-image {
            height: 200px;
            background-size: cover;
            background-position: center;
            position: relative;
            background-color: #e9ecef;
        }
        
        .content-type {
            position: absolute;
            top: 1rem;
            right: 1rem;
            background: rgba(0,0,0,0.7);
            color: white;
            padding: 0.3rem 1rem;
            border-radius: 50px;
            font-size: 0.8rem;
        }
        
        .content-body {
            padding: 1.5rem;
        }
        
        .content-body h5 {
            font-size: 1.1rem;
            font-weight: 600;
            margin-bottom: 0.5rem;
        }
        
        .content-meta {
            display: flex;
            align-items: center;
            margin-top: 1rem;
            color: #666;
            font-size: 0.9rem;
        }
        
        .content-meta i {
            margin-right: 0.3rem;
        }
        
        .content-meta .author {
            display: flex;
            align-items: center;
            margin-left: auto;
        }
        
        .author-avatar {
            width: 30px;
            height: 30px;
            border-radius: 50%;
            margin-right: 0.5rem;
            object-fit: cover;
        }
        
        /* Testimonials */
        .testimonials {
            padding: 80px 0;
            background: white;
        }
        
        .testimonial-card {
            background: var(--light-color);
            padding: 2rem;
            border-radius: 10px;
            position: relative;
            height: 100%;
        }
        
        .testimonial-card::before {
            content: '"';
            position: absolute;
            top: -20px;
            left: 20px;
            font-size: 5rem;
            color: var(--primary-color);
            opacity: 0.2;
            font-family: serif;
        }
        
        .testimonial-author {
            display: flex;
            align-items: center;
            margin-top: 1.5rem;
        }
        
        .testimonial-author img {
            width: 50px;
            height: 50px;
            border-radius: 50%;
            margin-right: 1rem;
            object-fit: cover;
        }
        
        .testimonial-author h6 {
            margin: 0;
            font-weight: 600;
        }
        
        .testimonial-author small {
            color: #666;
        }
        
        .rating {
            color: #ffc107;
            margin-top: 0.5rem;
        }
        
        /* CTA Section */
        .cta {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            padding: 80px 0;
            text-align: center;
        }
        
        .cta h2 {
            font-size: 2.5rem;
            font-weight: 700;
            margin-bottom: 1rem;
        }
        
        .cta p {
            font-size: 1.2rem;
            margin-bottom: 2rem;
            opacity: 0.95;
        }
        
        .cta .btn {
            background: white;
            color: #667eea;
            border: none;
            padding: 1rem 3rem;
            font-size: 1.2rem;
            font-weight: 600;
            border-radius: 50px;
            transition: all 0.3s;
        }
        
        .cta .btn:hover {
            transform: translateY(-3px);
            box-shadow: 0 10px 30px rgba(0,0,0,0.2);
        }
        
        /* Footer */
        .footer {
            background: #2c3e50;
            color: white;
            padding: 50px 0 20px;
        }
        
        .footer h5 {
            font-size: 1.2rem;
            font-weight: 600;
            margin-bottom: 1.5rem;
        }
        
        .footer ul {
            list-style: none;
            padding: 0;
        }
        
        .footer ul li {
            margin-bottom: 0.8rem;
        }
        
        .footer ul li a {
            color: rgba(255,255,255,0.7);
            text-decoration: none;
            transition: all 0.3s;
        }
        
        .footer ul li a:hover {
            color: white;
            padding-left: 5px;
        }
        
        .footer-bottom {
            margin-top: 3rem;
            padding-top: 2rem;
            border-top: 1px solid rgba(255,255,255,0.1);
            text-align: center;
            color: rgba(255,255,255,0.6);
        }
        
        /* Responsive */
        @media (max-width: 768px) {
            .hero h1 {
                font-size: 2.5rem;
            }
            
            .section-title h2 {
                font-size: 2rem;
            }
            
            .hero-stat {
                margin-bottom: 1.5rem;
            }
        }
    </style>
</head>
<body>
    <!-- Navigation -->
    <nav class="navbar navbar-expand-lg navbar-dark fixed-top">
        <div class="container">
            <a class="navbar-brand" href="https://globalwebsite.name.ng/gigz/public/">
                <i class="bi bi-share-fill"></i> GigzSocial
            </a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ms-auto">
                    <li class="nav-item">
                        <a class="nav-link" href="#features">Features</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#how-it-works">How It Works</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#content">Content</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#testimonials">Testimonials</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="https://globalwebsite.name.ng/gigz/public/faq">FAQ</a>
                    </li>
                                            <li class="nav-item">
                            <a class="nav-link" href="https://globalwebsite.name.ng/gigz/public/login">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link btn-register" href="https://globalwebsite.name.ng/gigz/public/register">Register</a>
                        </li>
                                    </ul>
            </div>
        </div>
    </nav>

    <!-- Hero Section -->
    <section class="hero">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-lg-6" data-aos="fade-right">
                    <h1>Earn Money Sharing Content You Love</h1>
                    <p>Join the largest social content sharing community. Create, share, and earn with GigzSocial's revolutionary platform.</p>
                                            <a href="https://globalwebsite.name.ng/gigz/public/register" class="btn btn-light btn-lg me-3">
                            <i class="bi bi-person-plus"></i> Get Started
                        </a>
                                        <a href="#features" class="btn btn-outline-light btn-lg">
                        <i class="bi bi-info-circle"></i> Learn More
                    </a>
                    
                    <div class="hero-stats row mt-5">
                        <div class="col-4 hero-stat">
                            <h3>3+</h3>
                            <p>Active Users</p>
                        </div>
                        <div class="col-4 hero-stat">
                            <h3>$0.0M+</h3>
                            <p>Monthly Volume</p>
                        </div>
                        <div class="col-4 hero-stat">
                            <h3>0+</h3>
                            <p>Content Items</p>
                        </div>
                    </div>
                </div>
                <div class="col-lg-6" data-aos="fade-left">
                    <img src="https://globalwebsite.name.ng/gigz/public/assets/images/hero-illustration.svg" alt="Hero Illustration" class="img-fluid">
                </div>
            </div>
        </div>
    </section>

    <!-- Features Section -->
    <section id="features" class="features">
        <div class="container">
            <div class="section-title" data-aos="fade-up">
                <h2>Why Choose GigzSocial?</h2>
                <p>We provide the tools and platform for content creators and sharers to monetize their reach effectively.</p>
            </div>
            
            <div class="row g-4">
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="100">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-currency-dollar"></i>
                        </div>
                        <h4>Multi-Currency Support</h4>
                        <p>Earn and withdraw in your preferred currency with competitive exchange rates and low fees.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="200">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-share"></i>
                        </div>
                        <h4>Easy Sharing</h4>
                        <p>Share content across multiple social platforms with one click and track your earnings in real-time.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="300">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-people"></i>
                        </div>
                        <h4>Referral Program</h4>
                        <p>Earn commissions from your referrals with our multi-level referral system.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="400">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-shield-check"></i>
                        </div>
                        <h4>Secure & Verified</h4>
                        <p>KYC verification ensures a safe environment for all users and transactions.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="500">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-graph-up"></i>
                        </div>
                        <h4>Real-Time Analytics</h4>
                        <p>Track your earnings, views, and shares with detailed analytics and reports.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="600">
                    <div class="feature-card">
                        <div class="feature-icon">
                            <i class="bi bi-headset"></i>
                        </div>
                        <h4>24/7 Support</h4>
                        <p>Our dedicated support team is always ready to help you with any questions.</p>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <!-- How It Works -->
    <section id="how-it-works" class="how-it-works">
        <div class="container">
            <div class="section-title" data-aos="fade-up">
                <h2>How It Works</h2>
                <p>Start earning in three simple steps</p>
            </div>
            
            <div class="row">
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="100">
                    <div class="step-card">
                        <div class="step-number">1</div>
                        <h4>Create Account</h4>
                        <p>Sign up for free and complete your profile. Verify your email to get started.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="200">
                    <div class="step-card">
                        <div class="step-number">2</div>
                        <h4>Choose Your Role</h4>
                        <p>Select whether you want to create content, share content, or both.</p>
                    </div>
                </div>
                
                <div class="col-md-4" data-aos="fade-up" data-aos-delay="300">
                    <div class="step-card">
                        <div class="step-number">3</div>
                        <h4>Start Earning</h4>
                        <p>Create or share content and watch your earnings grow. Withdraw anytime!</p>
                    </div>
                </div>
            </div>
            
            <div class="row mt-5">
                <div class="col-md-6 offset-md-3">
                    <div class="text-center">
                        <h5>For Publishers</h5>
                        <p>Create content and earn from shares and views</p>
                        <h5 class="mt-4">For Sharers</h5>
                        <p>Share content on your social media and earn commissions</p>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <!-- Content Showcase -->
    <section id="content" class="content-showcase">
        <div class="container">
            <div class="section-title" data-aos="fade-up">
                <h2>Featured Content</h2>
                <p>Check out some of our popular content from top creators</p>
            </div>
            
            <div class="row g-4">
                                    <!-- Placeholder content -->
                    <div class="col-md-4" data-aos="fade-up" data-aos-delay="100">
                        <div class="content-card">
                            <div class="content-image" style="background-image: url('https://globalwebsite.name.ng/gigz/public/assets/images/content1.jpg')">
                                <span class="content-type"><i class="bi bi-camera-video"></i> Video</span>
                            </div>
                            <div class="content-body">
                                <h5>Amazing Travel Vlog: Exploring Bali</h5>
                                <p class="text-muted small">Join us on an incredible journey through the beautiful islands of Bali.</p>
                                <div class="content-meta">
                                    <span><i class="bi bi-eye"></i> 2.5K</span>
                                    <span class="ms-3"><i class="bi bi-share"></i> 156</span>
                                    <span class="author">
                                        <div style="width:30px;height:30px;background:#e9ecef;border-radius:50%;margin-right:8px;"></div>
                                        <span>TravelMike</span>
                                    </span>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-4" data-aos="fade-up" data-aos-delay="200">
                        <div class="content-card">
                            <div class="content-image" style="background-image: url('https://globalwebsite.name.ng/gigz/public/assets/images/content2.jpg')">
                                <span class="content-type"><i class="bi bi-file-text"></i> Article</span>
                            </div>
                            <div class="content-body">
                                <h5>10 Tips for Successful Content Marketing</h5>
                                <p class="text-muted small">Learn the secrets of effective content marketing from industry experts.</p>
                                <div class="content-meta">
                                    <span><i class="bi bi-eye"></i> 1.8K</span>
                                    <span class="ms-3"><i class="bi bi-share"></i> 89</span>
                                    <span class="author">
                                        <div style="width:30px;height:30px;background:#e9ecef;border-radius:50%;margin-right:8px;"></div>
                                        <span>MarketingPro</span>
                                    </span>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-4" data-aos="fade-up" data-aos-delay="300">
                        <div class="content-card">
                            <div class="content-image" style="background-image: url('https://globalwebsite.name.ng/gigz/public/assets/images/content3.jpg')">
                                <span class="content-type"><i class="bi bi-music-note"></i> Audio</span>
                            </div>
                            <div class="content-body">
                                <h5>Relaxing Piano Music for Work</h5>
                                <p class="text-muted small">A beautiful collection of piano music to help you focus and relax.</p>
                                <div class="content-meta">
                                    <span><i class="bi bi-eye"></i> 5.2K</span>
                                    <span class="ms-3"><i class="bi bi-share"></i> 342</span>
                                    <span class="author">
                                        <div style="width:30px;height:30px;background:#e9ecef;border-radius:50%;margin-right:8px;"></div>
                                        <span>PianoMaster</span>
                                    </span>
                                </div>
                            </div>
                        </div>
                    </div>
                            </div>
            
            <div class="text-center mt-5" data-aos="fade-up">
                <a href="https://globalwebsite.name.ng/gigz/public/content" class="btn btn-outline-primary btn-lg">
                    <i class="bi bi-grid"></i> Browse All Content
                </a>
            </div>
        </div>
    </section>

    <!-- Testimonials -->
    <section id="testimonials" class="testimonials">
        <div class="container">
            <div class="section-title" data-aos="fade-up">
                <h2>What Our Users Say</h2>
                <p>Join thousands of satisfied creators and sharers</p>
            </div>
            
            <div class="row g-4">
                                <div class="col-md-4" data-aos="fade-up" data-aos-delay="100">
                    <div class="testimonial-card">
                        <p>GigzSocial has transformed how I monetize my content. The platform is easy to use and the payouts are always on time!</p>
                        
                        <div class="rating">
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                    </div>
                        
                        <div class="testimonial-author">
                                                            <div style="width: 50px; height: 50px; background: #e9ecef; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin-right: 1rem;">
                                    <i class="bi bi-person text-secondary"></i>
                                </div>
                                                        <div>
                                <h6>John D.</h6>
                                <small>Member since Jun 2026</small>
                            </div>
                        </div>
                    </div>
                </div>
                                <div class="col-md-4" data-aos="fade-up" data-aos-delay="200">
                    <div class="testimonial-card">
                        <p>As a sharer, I love how easy it is to find great content to share. The referral program is a nice bonus!</p>
                        
                        <div class="rating">
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                    </div>
                        
                        <div class="testimonial-author">
                                                            <div style="width: 50px; height: 50px; background: #e9ecef; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin-right: 1rem;">
                                    <i class="bi bi-person text-secondary"></i>
                                </div>
                                                        <div>
                                <h6>Sarah M.</h6>
                                <small>Member since Jun 2026</small>
                            </div>
                        </div>
                    </div>
                </div>
                                <div class="col-md-4" data-aos="fade-up" data-aos-delay="300">
                    <div class="testimonial-card">
                        <p>The multi-currency support is fantastic. I can earn in USD and withdraw in my local currency with great rates.</p>
                        
                        <div class="rating">
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                            <i class="bi bi-star-fill"></i>
                                                    </div>
                        
                        <div class="testimonial-author">
                                                            <div style="width: 50px; height: 50px; background: #e9ecef; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin-right: 1rem;">
                                    <i class="bi bi-person text-secondary"></i>
                                </div>
                                                        <div>
                                <h6>Michael R.</h6>
                                <small>Member since Jun 2026</small>
                            </div>
                        </div>
                    </div>
                </div>
                            </div>
        </div>
    </section>

    <!-- CTA Section -->
    <section class="cta">
        <div class="container">
            <div class="row">
                <div class="col-lg-8 mx-auto" data-aos="fade-up">
                    <h2>Ready to Start Earning?</h2>
                    <p>Join GigzSocial today and turn your content into cash</p>
                                            <a href="https://globalwebsite.name.ng/gigz/public/register" class="btn btn-light">
                            <i class="bi bi-person-plus"></i> Create Free Account
                        </a>
                                    </div>
            </div>
        </div>
    </section>

    <!-- Footer -->
    <footer class="footer">
        <div class="container">
            <div class="row">
                <div class="col-md-4">
                    <h5>About GigzSocial</h5>
                    <p>A revolutionary social content sharing community where creators and sharers can monetize their content and reach.</p>
                </div>
                
                <div class="col-md-2">
                    <h5>Quick Links</h5>
                    <ul>
                        <li><a href="#features">Features</a></li>
                        <li><a href="#how-it-works">How It Works</a></li>
                        <li><a href="#content">Content</a></li>
                        <li><a href="#testimonials">Testimonials</a></li>
                    </ul>
                </div>
                
                <div class="col-md-2">
                    <h5>Resources</h5>
                    <ul>
                        <li><a href="https://globalwebsite.name.ng/gigz/public/faq">FAQ</a></li>
                        <li><a href="https://globalwebsite.name.ng/gigz/public/contact">Contact</a></li>
                        <li><a href="https://globalwebsite.name.ng/gigz/public/terms">Terms of Service</a></li>
                        <li><a href="https://globalwebsite.name.ng/gigz/public/privacy">Privacy Policy</a></li>
                    </ul>
                </div>
                
                <div class="col-md-4">
                    <h5>Contact Info</h5>
                    <ul>
                        <li><i class="bi bi-envelope"></i> support@gigzsocial.com</li>
                        <li><i class="bi bi-clock"></i> Support: 24/7</li>
                        <li><i class="bi bi-globe"></i> Global Community</li>
                    </ul>
                    
                    <div class="social-links mt-3">
                        <a href="#" class="text-white me-3"><i class="bi bi-facebook fs-4"></i></a>
                        <a href="#" class="text-white me-3"><i class="bi bi-twitter fs-4"></i></a>
                        <a href="#" class="text-white me-3"><i class="bi bi-instagram fs-4"></i></a>
                        <a href="#" class="text-white"><i class="bi bi-linkedin fs-4"></i></a>
                    </div>
                </div>
            </div>
            
            <div class="footer-bottom">
                <p>&copy; 2026 GigzSocial. All rights reserved. | Empowering content creators worldwide</p>
            </div>
        </div>
    </footer>

    <!-- Scripts -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://unpkg.com/aos@2.3.1/dist/aos.js"></script>
    <script>
        // Initialize AOS
        AOS.init({
            duration: 1000,
            once: true
        });
        
        // Smooth scrolling for anchor links
        document.querySelectorAll('a[href^="#"]').forEach(anchor => {
            anchor.addEventListener('click', function (e) {
                e.preventDefault();
                const target = document.querySelector(this.getAttribute('href'));
                if (target) {
                    target.scrollIntoView({
                        behavior: 'smooth',
                        block: 'start'
                    });
                }
            });
        });
        
        // Navbar background on scroll
        window.addEventListener('scroll', function() {
            const navbar = document.querySelector('.navbar');
            if (window.scrollY > 50) {
                navbar.style.background = 'linear-gradient(135deg, #5a67d8 0%, #6b46a1 100%)';
                navbar.style.boxShadow = '0 2px 10px rgba(0,0,0,0.1)';
            } else {
                navbar.style.background = 'linear-gradient(135deg, #667eea 0%, #764ba2 100%)';
            }
        });
    </script>
</body>
</html>