<?php
// ডাটাবেস কানেকশন
$host = "localhost";
$dbname = "eseba_blood_donation_db";
$username = "eseba_blood_donation_db";
$password = "eseba_blood_donation_db@@";

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}

// টেবিল তৈরি করুন (যদি না থাকে)
$pdo->exec("CREATE TABLE IF NOT EXISTS donors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    phone VARCHAR(15) UNIQUE NOT NULL,
    whatsapp VARCHAR(20) NOT NULL,
    blood_group VARCHAR(5) NOT NULL,
    gender VARCHAR(10) NOT NULL,
    district VARCHAR(50) NOT NULL,
    upazila VARCHAR(100) NOT NULL,
    last_donated VARCHAR(50) DEFAULT 'কখনো দেইনি',
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

$pdo->exec("CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL
)");

// ডিফল্ট অ্যাডমিন চেক করুন
$stmt = $pdo->query("SELECT COUNT(*) FROM admins");
if ($stmt->fetchColumn() == 0) {
    $pdo->exec("INSERT INTO admins (username, password) VALUES ('admin', 'admin123')");
}

// API হ্যান্ডলিং
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_SERVER['HTTP_X_REQUESTED_WITH'])) {
    header('Content-Type: application/json');
    $data = json_decode(file_get_contents("php://input"), true);
    $action = $data['action'] ?? '';
    
    if ($action === 'register') {
        try {
            $stmt = $pdo->prepare("INSERT INTO donors (name, phone, whatsapp, blood_group, gender, district, upazila, last_donated, password) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
            $stmt->execute([
                $data['name'], $data['phone'], $data['whatsapp'], 
                $data['bloodGroup'], $data['gender'], $data['district'], 
                $data['upazila'], $data['lastDonated'], $data['password']
            ]);
            echo json_encode(["success" => true, "message" => "নিবন্ধন সফল!"]);
        } catch(PDOException $e) {
            echo json_encode(["success" => false, "message" => "এই নম্বর Already আছে!"]);
        }
        exit;
    }
    
    if ($action === 'login') {
        $stmt = $pdo->prepare("SELECT * FROM donors WHERE phone = ?");
        $stmt->execute([$data['phone']]);
        $donor = $stmt->fetch(PDO::FETCH_ASSOC);
        if ($donor && $data['password'] === $donor['password']) {
            session_start();
            $_SESSION['donor'] = $donor;
            echo json_encode(["success" => true, "donor" => $donor]);
        } else {
            echo json_encode(["success" => false, "message" => "ভুল তথ্য!"]);
        }
        exit;
    }
    
    if ($action === 'get_donors') {
        $stmt = $pdo->query("SELECT * FROM donors ORDER BY created_at DESC");
        echo json_encode(["success" => true, "donors" => $stmt->fetchAll(PDO::FETCH_ASSOC)]);
        exit;
    }
    
    if ($action === 'get_stats') {
        $total = $pdo->query("SELECT COUNT(*) FROM donors")->fetchColumn();
        $male = $pdo->query("SELECT COUNT(*) FROM donors WHERE gender='male'")->fetchColumn();
        $female = $pdo->query("SELECT COUNT(*) FROM donors WHERE gender='female'")->fetchColumn();
        echo json_encode(["success" => true, "total" => $total, "male" => $male, "female" => $female]);
        exit;
    }
    
    if ($action === 'update_donated') {
        session_start();
        $stmt = $pdo->prepare("UPDATE donors SET last_donated = ? WHERE id = ?");
        $stmt->execute([$data['last_donated'], $_SESSION['donor']['id']]);
        echo json_encode(["success" => true]);
        exit;
    }
    
    if ($action === 'admin_login') {
        session_start();
        $stmt = $pdo->prepare("SELECT * FROM admins WHERE username = ? AND password = ?");
        $stmt->execute([$data['username'], $data['password']]);
        if ($stmt->fetch()) {
            $_SESSION['admin'] = true;
            echo json_encode(["success" => true]);
        } else {
            echo json_encode(["success" => false]);
        }
        exit;
    }
    
    if ($action === 'admin_get_donors') {
        session_start();
        if (!isset($_SESSION['admin'])) { echo json_encode(["success" => false]); exit; }
        $stmt = $pdo->query("SELECT * FROM donors ORDER BY created_at DESC");
        echo json_encode(["success" => true, "donors" => $stmt->fetchAll(PDO::FETCH_ASSOC)]);
        exit;
    }
    
    if ($action === 'admin_delete_donor') {
        session_start();
        if (!isset($_SESSION['admin'])) { echo json_encode(["success" => false]); exit; }
        $stmt = $pdo->prepare("DELETE FROM donors WHERE id = ?");
        $stmt->execute([$data['id']]);
        echo json_encode(["success" => true]);
        exit;
    }
    
    if ($action === 'admin_update_donor') {
        session_start();
        if (!isset($_SESSION['admin'])) { echo json_encode(["success" => false]); exit; }
        $stmt = $pdo->prepare("UPDATE donors SET name=?, phone=?, blood_group=?, district=?, upazila=?, last_donated=? WHERE id=?");
        $stmt->execute([$data['name'], $data['phone'], $data['bloodGroup'], $data['district'], $data['upazila'], $data['lastDonated'], $data['id']]);
        echo json_encode(["success" => true]);
        exit;
    }
    
    exit;
}

session_start();
?>
<!DOCTYPE html>
<html lang="bn">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>রক্তসাথী - ব্লাড ডোনেশন</title>
    <link href="https://fonts.googleapis.com/css2?family=Hind+Siliguri:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css">
    <style>
        * { margin: 0; padding: 0; box-sizing: border-box; }
        body { font-family: 'Hind Siliguri', sans-serif; background: linear-gradient(135deg, #fff5f0, #ffe8e0); min-height: 100vh; }
        .container { max-width: 1200px; margin: 0 auto; padding: 20px; }
        .navbar {
            background: white; padding: 15px 25px; border-radius: 50px;
            display: flex; justify-content: space-between; align-items: center;
            box-shadow: 0 5px 20px rgba(0,0,0,0.08); margin-bottom: 30px;
            flex-wrap: wrap; gap: 15px;
        }
        .logo { font-size: 26px; font-weight: 700; color: #d32f2f; }
        .logo i { color: #d32f2f; margin-right: 8px; }
        .nav-links { display: flex; gap: 10px; flex-wrap: wrap; }
        .nav-btn {
            background: none; border: none; padding: 8px 18px; font-size: 15px;
            font-weight: 500; cursor: pointer; border-radius: 30px; transition: 0.3s;
        }
        .nav-btn:hover { background: #d32f2f; color: white; }
        .btn {
            background: #d32f2f; color: white; border: none; padding: 12px 28px;
            border-radius: 40px; font-size: 16px; font-weight: 600; cursor: pointer;
            display: inline-flex; align-items: center; gap: 8px;
        }
        .btn-outline { background: transparent; border: 2px solid #d32f2f; color: #d32f2f; }
        .btn-outline:hover { background: #d32f2f; color: white; }
        .btn-sm { padding: 8px 18px; font-size: 14px; }
        .hero { text-align: center; padding: 50px 20px; }
        .hero h1 { font-size: 44px; margin-bottom: 20px; }
        .hero h1 span { color: #d32f2f; }
        .hero p { font-size: 18px; color: #666; margin-bottom: 30px; }
        .stats-row { display: flex; gap: 25px; justify-content: center; margin-top: 30px; flex-wrap: wrap; }
        .stat-card {
            background: white; padding: 25px; border-radius: 25px; text-align: center;
            flex: 1; min-width: 160px; box-shadow: 0 5px 15px rgba(0,0,0,0.08);
        }
        .stat-card i { font-size: 38px; color: #d32f2f; margin-bottom: 12px; }
        .stat-card h2 { font-size: 34px; color: #d32f2f; }
        .card {
            background: white; border-radius: 25px; padding: 28px;
            margin: 20px 0; box-shadow: 0 5px 15px rgba(0,0,0,0.08);
        }
        .form-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(280px, 1fr)); gap: 20px; }
        .form-group { margin-bottom: 0; }
        label { display: block; margin-bottom: 8px; font-weight: 600; }
        input, select {
            width: 100%; padding: 12px 18px; border: 1.5px solid #eee;
            border-radius: 30px; font-size: 15px; font-family: 'Hind Siliguri', sans-serif;
        }
        input:focus, select:focus { outline: none; border-color: #d32f2f; }
        .donor-grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(330px, 1fr)); gap: 25px; margin-top: 20px; }
        .donor-card {
            background: white; border-radius: 20px; padding: 20px;
            box-shadow: 0 3px 10px rgba(0,0,0,0.08); transition: 0.3s;
        }
        .donor-card:hover { transform: translateY(-5px); }
        .donor-header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 15px; flex-wrap: wrap; gap: 10px; }
        .donor-name { font-size: 18px; font-weight: 700; }
        .blood-badge { background: #ffebee; color: #d32f2f; padding: 6px 18px; border-radius: 25px; font-weight: bold; }
        .donor-info { margin: 12px 0; color: #555; }
        .donor-info p { margin: 8px 0; }
        .donor-info i { width: 28px; color: #d32f2f; }
        .contact-buttons { display: flex; gap: 12px; margin-top: 15px; }
        .call-btn, .wa-btn {
            flex: 1; text-align: center; padding: 10px; border-radius: 30px;
            text-decoration: none; font-weight: 600; display: flex; align-items: center; justify-content: center; gap: 8px;
        }
        .call-btn { background: #2E7D32; color: white; }
        .wa-btn { background: #25D366; color: white; }
        .filter-section { display: flex; gap: 15px; flex-wrap: wrap; margin-bottom: 25px; }
        .filter-section select, .filter-section button { flex: 1; min-width: 150px; }
        .modal {
            display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%;
            background: rgba(0,0,0,0.5); justify-content: center; align-items: center; z-index: 1000;
        }
        .modal-content {
            background: white; border-radius: 25px; padding: 28px;
            width: 90%; max-width: 550px; max-height: 85vh; overflow-y: auto;
        }
        .admin-table { width: 100%; overflow-x: auto; }
        .admin-table table { width: 100%; border-collapse: collapse; }
        .admin-table th, .admin-table td { padding: 12px; text-align: left; border-bottom: 1px solid #eee; }
        .admin-table th { background: #fef0ea; }
        .delete-btn, .edit-btn { padding: 5px 12px; border-radius: 20px; cursor: pointer; border: none; margin: 2px; }
        .edit-btn { background: #ff9800; color: white; }
        .delete-btn { background: #f44336; color: white; }
        @media (max-width: 768px) {
            .navbar { flex-direction: column; text-align: center; }
            .hero h1 { font-size: 30px; }
            .stats-row { flex-direction: column; }
        }
    </style>
</head>
<body>
    <div class="container">
        <div class="navbar">
            <div class="logo"><i class="fas fa-droplet"></i> রক্তসাথী</div>
            <div class="nav-links">
                <button class="nav-btn" onclick="loadHome()">হোম</button>
                <button class="nav-btn" onclick="loadDonors()">রক্তদাতা খুঁজুন</button>
                <button class="nav-btn" onclick="showAdminLogin()">অ্যাডমিন</button>
                <button id="loginBtn" class="btn btn-sm" onclick="showAuthModal()">লগইন/রেজিস্টার</button>
                <button id="logoutBtn" class="btn btn-sm btn-outline" style="display:none;" onclick="logout()">লগআউট</button>
            </div>
        </div>
        <div id="mainContent"></div>
    </div>
    <div id="modal" class="modal"><div class="modal-content" id="modalContent"></div></div>

    <script>
        let currentUser = null;
        
        async function apiCall(action, data = {}) {
            data.action = action;
            try {
                const response = await fetch(window.location.href, {
                    method: 'POST',
                    headers: { 'Content-Type': 'application/json', 'X-Requested-With': 'XMLHttpRequest' },
                    body: JSON.stringify(data)
                });
                return await response.json();
            } catch(e) {
                console.error(e);
                return { success: false };
            }
        }
        
        async function loadHome() {
            const stats = await apiCall('get_stats');
            document.getElementById('mainContent').innerHTML = `
                <div class="hero">
                    <h1>রক্ত দিন <span>জীবন বাঁচান</span> ❤️</h1>
                    <p>প্রতি সেকেন্ডে কাউকে না কাউকে রক্তের প্রয়োজন। আপনি পারেন একজন জীবন বাঁচাতে।</p>
                    <button class="btn" onclick="showAuthModal()"><i class="fas fa-hand-holding-heart"></i> রক্তদাতা হোন</button>
                    <button class="btn btn-outline" onclick="loadDonors()"><i class="fas fa-search"></i> রক্তদাতা খুঁজুন</button>
                </div>
                <div class="stats-row">
                    <div class="stat-card"><i class="fas fa-users"></i><h2>${stats.total || 0}</h2><p>মোট রক্তদাতা</p></div>
                    <div class="stat-card"><i class="fas fa-male"></i><h2>${stats.male || 0}</h2><p>পুরুষ</p></div>
                    <div class="stat-card"><i class="fas fa-female"></i><h2>${stats.female || 0}</h2><p>নারী</p></div>
                </div>
            `;
            if (currentUser) {
                document.getElementById('mainContent').innerHTML += `
                    <div class="card">
                        <div style="display:flex; justify-content:space-between; align-items:center; flex-wrap:wrap;">
                            <div><i class="fas fa-calendar-alt" style="color:#d32f2f;"></i> <strong>আপনার শেষ রক্তদান:</strong> ${currentUser.last_donated}</div>
                            <button class="btn btn-sm btn-outline" onclick="updateLastDonated()"><i class="fas fa-edit"></i> আপডেট করুন</button>
                        </div>
                    </div>
                `;
            }
        }
        
        async function loadDonors() {
            const result = await apiCall('get_donors');
            const donors = result.donors || [];
            let html = `<div class="card"><h2><i class="fas fa-tint"></i> রক্তদাতা ডিরেক্টরি</h2><div class="donor-grid">`;
            if (donors.length === 0) {
                html += `<p style="text-align:center;">কোনো রক্তদাতা নেই। প্রথম রক্তদাতা হোন!</p>`;
            } else {
                donors.forEach(d => {
                    html += `
                        <div class="donor-card">
                            <div class="donor-header"><span class="donor-name"><i class="fas fa-user-circle"></i> ${d.name}</span><span class="blood-badge"><i class="fas fa-tint"></i> ${d.blood_group}</span></div>
                            <div class="donor-info"><p><i class="fas fa-map-marker-alt"></i> ${d.district}, ${d.upazila}</p><p><i class="fas fa-calendar"></i> শেষ রক্তদান: ${d.last_donated}</p></div>
                            <div class="contact-buttons"><a href="tel:${d.phone}" class="call-btn"><i class="fas fa-phone"></i> কল</a><a href="https://wa.me/${d.whatsapp.replace(/[^0-9]/g, '')}" target="_blank" class="wa-btn"><i class="fab fa-whatsapp"></i> WhatsApp</a></div>
                        </div>
                    `;
                });
            }
            html += `</div></div>`;
            document.getElementById('mainContent').innerHTML = html;
        }
        
        function showAuthModal() {
            const modal = document.getElementById('modal');
            document.getElementById('modalContent').innerHTML = `
                <h3 style="text-align:center;"><i class="fas fa-user-plus"></i> লগইন / রেজিস্টার</h3>
                <div style="display:flex; gap:10px; margin:20px 0;"><button class="btn" style="flex:1;" onclick="showLogin()">লগইন</button><button class="btn btn-outline" style="flex:1;" onclick="showRegister()">নিবন্ধন</button></div>
                <div id="authForm"></div>
                <button class="btn-outline" onclick="closeModal()" style="width:100%; margin-top:15px;">হোম এ ফিরে যান</button>
            `;
            showLogin();
            modal.style.display = 'flex';
        }
        
        function showLogin() {
            document.getElementById('authForm').innerHTML = `
                <form onsubmit="event.preventDefault(); login()">
                    <div class="form-group"><input type="tel" id="loginPhone" placeholder="মোবাইল নম্বর" required></div>
                    <div class="form-group"><input type="password" id="loginPassword" placeholder="পাসওয়ার্ড" required></div>
                    <button type="submit" class="btn" style="width:100%;">লগইন</button>
                </form>
            `;
        }
        
        async function login() {
            const result = await apiCall('login', { 
                phone: document.getElementById('loginPhone').value, 
                password: document.getElementById('loginPassword').value 
            });
            if (result.success) {
                currentUser = result.donor;
                closeModal();
                document.getElementById('loginBtn').style.display = 'none';
                document.getElementById('logoutBtn').style.display = 'inline-flex';
                loadHome();
                alert('স্বাগতম ' + currentUser.name);
            } else {
                alert(result.message || 'ভুল তথ্য!');
            }
        }
        
        function showRegister() {
            document.getElementById('authForm').innerHTML = `
                <form onsubmit="event.preventDefault(); register()">
                    <div class="form-group"><input type="text" id="regName" placeholder="পূর্ণ নাম" required></div>
                    <div class="form-group"><input type="tel" id="regPhone" placeholder="মোবাইল (01xxxxxxxxx)" required></div>
                    <div class="form-group"><input type="text" id="regWhatsapp" placeholder="হোয়াটসঅ্যাপ"></div>
                    <div class="form-group"><select id="regBlood"><option>A+</option><option>A-</option><option>B+</option><option>B-</option><option>O+</option><option>O-</option><option>AB+</option><option>AB-</option></select></div>
                    <div class="form-group"><select id="regGender"><option value="male">পুরুষ</option><option value="female">নারী</option></select></div>
                    <div class="form-group"><input type="text" id="regDistrict" placeholder="জেলা" required></div>
                    <div class="form-group"><input type="text" id="regUpazila" placeholder="থানা" required></div>
                    <div class="form-group"><input type="text" id="regLastDonated" placeholder="শেষ রক্তদান (YYYY-MM-DD)"></div>
                    <div class="form-group"><input type="password" id="regPassword" placeholder="পাসওয়ার্ড" required></div>
                    <button type="submit" class="btn" style="width:100%;">নিবন্ধন করুন</button>
                </form>
            `;
        }
        
        async function register() {
            const phone = document.getElementById('regPhone').value;
            if (!/^01[3-9]\d{8}$/.test(phone)) { 
                alert("সঠিক ১১ ডিজিটের মোবাইল নম্বর দিন! (01xxxxxxxxx)"); 
                return; 
            }
            const result = await apiCall('register', {
                name: document.getElementById('regName').value,
                phone: phone,
                whatsapp: document.getElementById('regWhatsapp').value || phone,
                bloodGroup: document.getElementById('regBlood').value,
                gender: document.getElementById('regGender').value,
                district: document.getElementById('regDistrict').value,
                upazila: document.getElementById('regUpazila').value,
                lastDonated: document.getElementById('regLastDonated').value || "কখনো দেইনি",
                password: document.getElementById('regPassword').value
            });
            if (result.success) { 
                alert("নিবন্ধন সফল! এখন লগইন করুন"); 
                showLogin(); 
            } else { 
                alert(result.message || "নিবন্ধন ব্যর্থ! এই নম্বর আগে থেকেই আছে।"); 
            }
        }
        
        async function updateLastDonated() {
            if (!currentUser) { alert("লগইন করুন!"); return; }
            const newDate = prompt("শেষ রক্তদানের তারিখ (YYYY-MM-DD) অথবা 'কখনো দেইনি':", currentUser.last_donated);
            if (newDate) {
                await apiCall('update_donated', { last_donated: newDate });
                alert("আপডেট হয়েছে!");
                loadHome();
            }
        }
        
        async function showAdminLogin() {
            const pwd = prompt("অ্যাডমিন পাসওয়ার্ড দিন:");
            const result = await apiCall('admin_login', { username: 'admin', password: pwd });
            if (result.success) {
                loadAdminPanel();
            } else {
                alert("ভুল পাসওয়ার্ড!");
            }
        }
        
        async function loadAdminPanel() {
            const result = await apiCall('admin_get_donors');
            if (!result.success) { alert("অ্যাডমিন লগইন প্রয়োজন!"); return; }
            const donors = result.donors || [];
            let html = `<div class="card"><h2><i class="fas fa-user-shield"></i> অ্যাডমিন প্যানেল</h2><div class="admin-table"> <table> <thead> <tr> <th>নাম</th> <th>মোবাইল</th> <th>ব্লাড</th> <th>জেলা</th> <th>শেষদান</th> <th>অ্যাকশন</th> </tr> </thead> <tbody>`;
            donors.forEach(d => {
                html += `<tr><td>${d.name}</td><td>${d.phone}</td><td>${d.blood_group}</td><td>${d.district}</td><td>${d.last_donated}</td><td><button class="edit-btn" onclick="adminEdit(${d.id})">✏️</button><button class="delete-btn" onclick="adminDelete(${d.id})">🗑️</button></td></tr>`;
            });
            html += `</tbody></table></div></div>`;
            document.getElementById('mainContent').innerHTML = html;
        }
        
        async function adminDelete(id) {
            if (confirm("মুছে ফেলতে চান?")) {
                await apiCall('admin_delete_donor', { id: id });
                loadAdminPanel();
                loadHome();
            }
        }
        
        async function adminEdit(id) {
            const donors = (await apiCall('admin_get_donors')).donors;
            const d = donors.find(x => x.id == id);
            const name = prompt("নতুন নাম", d.name);
            const phone = prompt("মোবাইল", d.phone);
            const blood = prompt("ব্লাড গ্রুপ", d.blood_group);
            const district = prompt("জেলা", d.district);
            const upazila = prompt("থানা", d.upazila);
            const last = prompt("শেষ রক্তদান", d.last_donated);
            await apiCall('admin_update_donor', { id: id, name: name, phone: phone, bloodGroup: blood, district: district, upazila: upazila, lastDonated: last });
            loadAdminPanel();
            loadHome();
        }
        
        function logout() { 
            currentUser = null; 
            document.getElementById('loginBtn').style.display = 'inline-flex'; 
            document.getElementById('logoutBtn').style.display = 'none'; 
            loadHome(); 
            alert("লগআউট হয়েছে"); 
        }
        
        function closeModal() { 
            document.getElementById('modal').style.display = 'none'; 
        }
        
        // Check if user is logged in from session
        <?php if(isset($_SESSION['donor'])): ?>
        currentUser = <?php echo json_encode($_SESSION['donor']); ?>;
        document.getElementById('loginBtn').style.display = 'none';
        document.getElementById('logoutBtn').style.display = 'inline-flex';
        <?php endif; ?>
        
        loadHome();
    </script>
</body>
</html>