File Manager

✏️ Edit File: /home/sgssmau.org/public_html/admin/donations.php

<?php
session_start();
require_once '../config/database.php';
require_once '../includes/functions.php';

// Check if admin is logged in
requireLogin('admin', '../admin/login.php');

$success = '';
$errors = [];

// Handle donation actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (!verifyCSRFToken($_POST['csrf_token'] ?? '')) {
        $errors[] = 'Invalid security token';
    } else {
        $action = $_POST['action'] ?? '';
        $donationId = intval($_POST['donation_id'] ?? 0);
        
        try {
            $pdo = getConnection();
            
            switch ($action) {
                case 'approve':
                    $stmt = $pdo->prepare("UPDATE donations SET status = 'approved', admin_approved_by = ?, admin_approved_at = CURRENT_TIMESTAMP WHERE id = ?");
                    if ($stmt->execute([$_SESSION['admin_id'], $donationId])) {
                        $success = 'Donation approved successfully';
                    }
                    break;
                    
                case 'reject':
                    $reason = sanitizeInput($_POST['reason'] ?? '');
                    $stmt = $pdo->prepare("UPDATE donations SET status = 'rejected', admin_approved_by = ?, admin_approved_at = CURRENT_TIMESTAMP, admin_notes = ? WHERE id = ?");
                    if ($stmt->execute([$_SESSION['admin_id'], $reason, $donationId])) {
                        $success = 'Donation rejected';
                    }
                    break;

case 'delete':
                    $stmt = $pdo->prepare("DELETE FROM donations WHERE id = ?");
                    if ($stmt->execute([$donationId])) {
                        $success = 'Donation deleted successfully';
                    }
                    break;
            }
        } catch (Exception $e) {
            error_log("Donation action error: " . $e->getMessage());
            $errors[] = 'An error occurred while processing the request';
        }
    }
}

// Get donations with filtering
$status = $_GET['status'] ?? '';
$search = $_GET['search'] ?? '';
$page = max(1, intval($_GET['page'] ?? 1));
$limit = 20;
$offset = ($page - 1) * $limit;

try {
    $pdo = getConnection();
    
    // Build query
    $whereConditions = [];
    $params = [];
    
    if ($status) {
        $whereConditions[] = "status = ?";
        $params[] = $status;
    }
    
    if ($search) {
        $whereConditions[] = "(donor_name LIKE ? OR donor_email LIKE ? OR donor_phone LIKE ? OR receipt_number LIKE ?)";
        $searchTerm = "%$search%";
        $params = array_merge($params, [$searchTerm, $searchTerm, $searchTerm, $searchTerm]);
    }
    
    $whereClause = $whereConditions ? 'WHERE ' . implode(' AND ', $whereConditions) : '';
    
    // Get total count
    $countStmt = $pdo->prepare("SELECT COUNT(*) as total FROM donations $whereClause");
    $countStmt->execute($params);
    $totalDonations = $countStmt->fetch()['total'];
    $totalPages = ceil($totalDonations / $limit);
    
    // Get donations
    $stmt = $pdo->prepare("
        SELECT d.*, a.full_name as approved_by_name
        FROM donations d 
        LEFT JOIN admin_users a ON d.admin_approved_by = a.id 
        $whereClause 
        ORDER BY d.created_at DESC 
        LIMIT $limit OFFSET $offset
    ");
    $stmt->execute($params);
    $donations = $stmt->fetchAll();
    
} catch (Exception $e) {
    error_log("Donations fetch error: " . $e->getMessage());
    $donations = [];
    $totalDonations = 0;
    $totalPages = 1;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Manage Donations - IHRSO Admin</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet">
    <link href="../assets/css/style.css" rel="stylesheet">
    <style>
        .status-pending { color: #ffc107; }
        .status-approved { color: #198754; }
        .status-rejected { color: #dc3545; }
        .payment-slip-thumb {
            max-width: 60px;
            max-height: 60px;
            cursor: pointer;
        }
    </style>
</head>
<body class="bg-light">
    <?php include 'navbar.php'; ?>

<div class="container-fluid py-4">
        <div class="row">
            <div class="col-12">
                
                <div class="d-flex justify-content-between align-items-center mb-4">
                    <h2><i class="fas fa-heart me-2"></i>Manage Donations</h2>
                </div>

<?php if (!empty($errors)): ?>
                    <div class="alert alert-danger">
                        <ul class="mb-0">
                            <?php foreach ($errors as $error): ?>
                                <li><?php echo htmlspecialchars($error); ?></li>
                            <?php endforeach; ?>
                        </ul>
                    </div>
                <?php endif; ?>
                
                <?php if ($success): ?>
                    <div class="alert alert-success">
                        <i class="fas fa-check-circle me-2"></i><?php echo htmlspecialchars($success); ?>
                    </div>
                <?php endif; ?>

<div class="card mb-4">
                    <div class="card-body">
                        <form method="GET" class="row g-3">
                            <div class="col-md-3">
                                <label class="form-label">Status</label>
                                <select name="status" class="form-select">
                                    <option value="">All Statuses</option>
                                    <option value="pending" <?php echo $status === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                    <option value="approved" <?php echo $status === 'approved' ? 'selected' : ''; ?>>Approved</option>
                                    <option value="rejected" <?php echo $status === 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                </select>
                            </div>
                            <div class="col-md-6">
                                <label class="form-label">Search</label>
                                <input type="text" name="search" class="form-control" 
                                       placeholder="Search by name, email, phone, or receipt number" 
                                       value="<?php echo htmlspecialchars($search); ?>">
                            </div>
                            <div class="col-md-3">
                                <label class="form-label">&nbsp;</label>
                                <div class="d-grid">
                                    <button type="submit" class="btn btn-primary">
                                        <i class="fas fa-search me-1"></i>Search
                                    </button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

<div class="card">
                    <div class="card-header">
                        <h5 class="mb-0">Donations (<?php echo $totalDonations; ?> total)</h5>
                    </div>
                    <div class="card-body p-0">
                        <?php if (!empty($donations)): ?>
                            <div class="table-responsive">
                                <table class="table table-hover mb-0">
                                    <thead class="bg-light">
                                        <tr>
                                            <th>Receipt #</th>
                                            <th>Donor Details</th>
                                            <th>Amount</th>
                                            <th>Payment Mode</th>
                                            <th>Payment Slip</th>
                                            <th>Status</th>
                                            <th>Date</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php foreach ($donations as $donation): ?>
                                            <tr>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($donation['receipt_number']); ?></strong>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong><?php echo htmlspecialchars($donation['donor_name']); ?></strong><br>
                                                        <small class="text-muted">
                                                            <?php echo htmlspecialchars($donation['donor_email']); ?><br>
                                                            <?php echo htmlspecialchars($donation['donor_phone']); ?>
                                                        </small>
                                                    </div>
                                                </td>
                                                <td>
                                                    <strong>₹<?php echo number_format($donation['amount'], 2); ?></strong>
                                                    <?php if ($donation['cause']): ?>
                                                        <br><small class="text-muted"><?php echo htmlspecialchars($donation['cause']); ?></small>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-info">
                                                        <?php echo strtoupper(str_replace('_', ' ', $donation['payment_mode'])); ?>
                                                    </span>
                                                    <?php if ($donation['transaction_id']): ?>
                                                        <br><small class="text-muted">ID: <?php echo htmlspecialchars($donation['transaction_id']); ?></small>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <?php if ($donation['payment_slip']): ?>
                                                        <img src="../uploads/payment_slips/<?php echo htmlspecialchars($donation['payment_slip']); ?>" 
                                                             class="payment-slip-thumb img-thumbnail"
                                                             onclick="showPaymentSlip('<?php echo htmlspecialchars($donation['payment_slip']); ?>')"
                                                             alt="Payment Slip">
                                                    <?php else: ?>
                                                        <span class="text-muted">No slip</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php 
                                                        echo $donation['status'] === 'approved' ? 'success' : 
                                                            ($donation['status'] === 'rejected' ? 'danger' : 'warning'); 
                                                    ?>">
                                                        <?php echo ucfirst($donation['status']); ?>
                                                    </span>
                                                    <?php if ($donation['admin_approved_at']): ?>
                                                        <br><small class="text-muted">
                                                            by <?php echo htmlspecialchars($donation['approved_by_name'] ?? 'Admin'); ?>
                                                        </small>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <small>
                                                        <?php echo date('d M Y, g:i A', strtotime($donation['created_at'])); ?>
                                                    </small>
                                                </td>
                                                <td>
                                                    <?php if ($donation['status'] === 'pending'): ?>
                                                        <div class="btn-group-vertical btn-group-sm">
                                                            <button type="button" class="btn btn-success btn-sm" 
                                                                    onclick="approveDonation(<?php echo $donation['id']; ?>)">
                                                                <i class="fas fa-check"></i> Approve
                                                            </button>
                                                            <button type="button" class="btn btn-danger btn-sm" 
                                                                    onclick="rejectDonation(<?php echo $donation['id']; ?>)">
                                                                <i class="fas fa-times"></i> Reject
                                                            </button>
                                                            <button type="button" class="btn btn-outline-danger btn-sm" 
                                                                    onclick="deleteDonation(<?php echo $donation['id']; ?>)">
                                                                <i class="fas fa-trash"></i>
                                                            </button>
                                                        </div>
                                                    <?php else: ?>
                                                        <button type="button" class="btn btn-outline-primary btn-sm" 
                                                                onclick="viewDonationDetails(<?php echo $donation['id']; ?>)">
                                                            <i class="fas fa-eye"></i> View
                                                        </button>
                                                        <button type="button" class="btn btn-outline-danger btn-sm" 
                                                                onclick="deleteDonation(<?php echo $donation['id']; ?>)">
                                                            <i class="fas fa-trash"></i>
                                                        </button>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                        <?php endforeach; ?>
                                    </tbody>
                                </table>
                            </div>
                        <?php else: ?>
                            <div class="text-center py-5">
                                <i class="fas fa-heart fa-3x text-muted mb-3"></i>
                                <h5 class="text-muted">No donations found</h5>
                                <p class="text-muted">No donations match your current filters.</p>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>

<?php if ($totalPages > 1): ?>
                    <nav class="mt-4">
                        <ul class="pagination justify-content-center">
                            <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                                <li class="page-item <?php echo $i === $page ? 'active' : ''; ?>">
                                    <a class="page-link" href="?page=<?php echo $i; ?>&status=<?php echo urlencode($status); ?>&search=<?php echo urlencode($search); ?>">
                                        <?php echo $i; ?>
                                    </a>
                                </li>
                            <?php endfor; ?>
                        </ul>
                    </nav>
                <?php endif; ?>
            </div>
        </div>
    </div>

<div class="modal fade" id="paymentSlipModal" tabindex="-1">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Payment Slip</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body text-center">
                    <img id="paymentSlipImage" src="" class="img-fluid" alt="Payment Slip">
                </div>
            </div>
        </div>
    </div>

<form id="actionForm" method="POST" style="display: none;">
        <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
        <input type="hidden" name="action" id="actionType">
        <input type="hidden" name="donation_id" id="donationId">
        <input type="hidden" name="reason" id="rejectionReason">
    </form>

function approveDonation(donationId) {
            if (confirm('Are you sure you want to approve this donation?')) {
                document.getElementById('actionType').value = 'approve';
                document.getElementById('donationId').value = donationId;
                document.getElementById('actionForm').submit();
            }
        }

function rejectDonation(donationId) {
            const reason = prompt('Please enter the reason for rejection:');
            if (reason && reason.trim()) {
                document.getElementById('actionType').value = 'reject';
                document.getElementById('donationId').value = donationId;
                document.getElementById('rejectionReason').value = reason.trim();
                document.getElementById('actionForm').submit();
            }
        }

function deleteDonation(donationId) {
            if (confirm('Are you sure you want to delete this donation? This action cannot be undone.')) {
                document.getElementById('actionType').value = 'delete';
                document.getElementById('donationId').value = donationId;
                document.getElementById('actionForm').submit();
            }
        }

function viewDonationDetails(donationId) {
            // Implement view details functionality if needed
            alert('View details functionality can be implemented here');
        }
    </script>
</body>
</html>

Batal

⬅ Naik ke public_html 30 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁ajax	dir	—	2026-06-04 10:51	📂 Buka
📁js	dir	—	2026-06-04 10:51	📂 Buka
🐘award-certificates.php	php	9.9 KB	2026-06-04 09:01	✏️ Edit 👁️ View
🐘causes.php	php	11.7 KB	2026-01-18 01:24	✏️ Edit 👁️ View
🐘cms.php	php	118.5 KB	2026-06-04 09:10	✏️ Edit 👁️ View
🐘create-admin.php	php	3.6 KB	2025-07-09 22:37	✏️ Edit 👁️ View
🐘custom-certificate.php	php	41.2 KB	2026-06-04 09:04	✏️ Edit 👁️ View
🐘dashboard.php	php	17.2 KB	2026-06-04 09:01	✏️ Edit 👁️ View
🐘documents.php	php	9.9 KB	2026-06-04 09:11	✏️ Edit 👁️ View
🐘donations.php	php	19.7 KB	2026-06-04 09:08	✏️ Edit 👁️ View
🐘edit-member.php	php	22.4 KB	2026-06-04 09:12	✏️ Edit 👁️ View
🐘fix-password.php	php	840 B	2025-07-09 22:37	✏️ Edit 👁️ View
🐘fix_db_column.php	php	410 B	2026-01-16 19:38	✏️ Edit 👁️ View
🐘generate-award-certificate.php	php	20.2 KB	2026-06-04 09:04	✏️ Edit 👁️ View
🐘job-applications.php	php	16.8 KB	2026-06-04 09:04	✏️ Edit 👁️ View
🐘login.php	php	9.6 KB	2026-01-06 21:08	✏️ Edit 👁️ View
🐘logout.php	php	279 B	2025-07-09 22:37	✏️ Edit 👁️ View
🐘members.php	php	42.9 KB	2026-06-30 07:02	✏️ Edit 👁️ View
🐘membership-plans.php	php	18.5 KB	2026-06-04 09:09	✏️ Edit 👁️ View
🐘navbar.php	php	13.6 KB	2026-06-04 10:51	✏️ Edit 👁️ View
🐘payments.php	php	27.4 KB	2026-06-04 09:06	✏️ Edit 👁️ View
🐘profile.php	php	4.7 KB	2026-06-04 09:12	✏️ Edit 👁️ View
📝serial_2026.txt	txt	1 B	2026-01-15 21:19	✏️ Edit 👁️ View
🐘settings.php	php	133.4 KB	2026-06-04 09:11	✏️ Edit 👁️ View
🐘setup_award_certificates.php	php	767 B	2026-06-04 08:44	✏️ Edit 👁️ View
🐘setup_documents_db.php	php	689 B	2026-01-07 05:33	✏️ Edit 👁️ View
🐘ssettings.php	php	29.6 KB	2025-08-23 03:34	✏️ Edit 👁️ View
🐘sssettings.php	php	36.9 KB	2025-08-27 21:29	✏️ Edit 👁️ View
🐘team.php	php	22 KB	2026-06-04 09:10	✏️ Edit 👁️ View
🐘test-login.php	php	3.2 KB	2025-07-09 22:37	✏️ Edit 👁️ View