// Example: Fetching Main HIS Indicator Data in PHP
$apiUrl = 'https://hispmd.merqconsultancy.org/api/chart/public/data/hispm_data.php';

// Initialize cURL session
$ch = curl_init($apiUrl);

// Set cURL options
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Accept: application/json'
]);

// Execute and close cURL session
$response = curl_exec($ch);

if (curl_errno($ch)) {
    // Handle cURL error
    echo 'Error:' . curl_error($ch);
} else {
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    $data = json_decode($response, true);
    
    if ($httpCode >= 400) {
        // Handle API error
        echo "API Error: " . ($data['error']['message'] ?? "HTTP status $httpCode");
    } else {
        // Process successful response
        print_r($data);
    }
}

curl_close($ch);

// Example: Fetching Indicators with API Key in PHP
$apiKey = 'YOUR_API_KEY'; // Replace with your actual key
$apiUrl = 'https://hispmd.merqconsultancy.org/app/api/v1.php?table=moh_indicators&action=list';

// Initialize cURL session
$ch = curl_init();

// Set URL and options
curl_setopt($ch, CURLOPT_URL, $apiUrl . '?apikey=' . urlencode($apiKey));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

// Alternatively with Authorization header:
// curl_setopt($ch, CURLOPT_URL, $apiUrl);
// curl_setopt($ch, CURLOPT_HTTPHEADER, [
//     'Authorization: Bearer ' . $apiKey,
//     'Accept: application/json'
// ]);

// Execute the request
$response = curl_exec($ch);
$httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

if ($httpCode !== 200) {
    $errorData = json_decode($response, true);
    echo "API Request Failed with status: $httpCode\n";
    echo "Error: " . ($errorData['error']['message'] ?? 'Unknown error');
} else {
    $data = json_decode($response, true);
    // Process the data
    print_r($data);
}

// Close cURL session
curl_close($ch);

# Example: Fetching Main HIS Indicator Data in Python
import requests

url = "https://hispmd.merqconsultancy.org/api/chart/public/data/hispm_data.php"

try:
    response = requests.get(url)
    response.raise_for_status()  # Raises an HTTPError for bad responses
    
    data = response.json()
    print("API Response:", data)
    
except requests.exceptions.RequestException as e:
    print(f"Request Failed: {e}")
except ValueError as e:
    print(f"Failed to decode JSON: {e}")

# Example with API Key in Python
import requests

api_key = "YOUR_API_KEY"  # Replace with your actual key
url = "https://hispmd.merqconsultancy.org/app/api/v1.php?table=moh_indicators&action=list"

# Option 1: API Key in URL (not recommended for production)
# response = requests.get(f"{url}?apikey={api_key}")

# Option 2: API Key in Headers (recommended)
headers = {
    "Authorization": f"Bearer {api_key}",
    "Accept": "application/json"
}

try:
    response = requests.get(url, headers=headers)
    response.raise_for_status()
    
    data = response.json()
    
    if data.get("status") == "error":
        print(f"API Error: {data.get('error', {}).get('message', 'Unknown error')}")
    else:
        print("API Success:", data)
        
except requests.exceptions.RequestException as e:
    print(f"Request Failed: {e}")

// Example: Displaying data in a dashboard
async function loadDashboard() {
    try {
        const response = await fetch('https://hispmd.merqconsultancy.org/api/chart/public/data/hispm_data.php');
        const data = await response.json();
        
        if (!response.ok) {
            throw new Error(data.error?.message || 'Failed to load data');
        }
        
        const dashboard = document.getElementById('dashboard');
        dashboard.innerHTML = ''; // Clear previous content
        
        // Create cards for each indicator
        data.forEach(indicator => {
            const card = document.createElement('div');
            card.className = 'dashboard-card';
            
            // Calculate progress percentage
            const progress = (indicator.value / indicator.target) * 100;
            const progressClass = progress >= 90 ? 'high' : 
                                progress >= 70 ? 'medium' : 'low';
            
            card.innerHTML = `
                
${indicator.indicator_name}
                

                    ${indicator.value}
                    Target: ${indicator.target}
                
                

                

                    ${indicator.region}
                    ${indicator.period}
                
            `;
            
            dashboard.appendChild(card);
        });
        
    } catch (error) {
        showErrorToast(error.message);
    }
}

// Initialize dashboard when page loads
document.addEventListener('DOMContentLoaded', loadDashboard);

// Example: Generating automated reports
const API_KEY = 'YOUR_API_KEY'; // In production, use environment variables

async function generateMonthlyReport() {
    try {
        // Fetch data from multiple endpoints in parallel
        const [indicators, regions, reportingRates] = await Promise.all([
            fetchData('https://hispmd.merqconsultancy.org/app/api/v1.php?table=moh_indicators&action=list'),
            fetchData('https://hispmd.merqconsultancy.org/app/api/v1.php?table=moh_regions&action=list'),
            fetchData('https://hispmd.merqconsultancy.org/app/api/v1.php?table=dhis2_reporting_rates&action=list')
        ]);
        
        // Generate report HTML
        const reportDate = new Date().toLocaleDateString();
        const reportHTML = `
            
            
            
                
                
            
            
                
HISPMD Monthly Report
                
Generated on: ${reportDate}
                
                

                    
Key Indicators
                    ${generateIndicatorTable(indicators)}
                
                
                

                    
Reporting Rates by Region
                    ${generateReportingRatesChart(reportingRates, regions)}
                
            
            
        `;
        
        // Save or send the report
        saveReport(reportHTML);
        
    } catch (error) {
        console.error('Report generation failed:', error);
        // Send error notification
        sendErrorNotification(error);
    }
}

// Helper function to fetch data with API key
async function fetchData(endpoint) {
    const response = await fetch(`${endpoint}?apikey=${API_KEY}`);
    if (!response.ok) {
        throw new Error(`Failed to fetch ${endpoint}: ${response.status}`);
    }
    return await response.json();
}

// Run report generation
generateMonthlyReport();