query("SELECT COUNT(*) FROM charity_members WHERE created_by IS NULL OR updated_by IS NULL")->fetchColumn() > 0) {
db()->query("UPDATE charity_members SET created_by = 1 WHERE created_by IS NULL");
db()->query("UPDATE charity_members SET updated_by = 1 WHERE updated_by IS NULL");
}
} catch (Exception $e) {}
if (!isAdmin() && !canView('charity_members')) {
echo "
غير مصرح لك بالوصول لهذه الصفحة.
";
require_once 'includes/footer.php';
exit;
}
$action = $_GET['action'] ?? 'list';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['add_member']) && (isAdmin() || canAdd('charity_members'))) {
$name = $_POST['name'] ?? '';
$role = $_POST['role'] ?? '';
$phone = $_POST['phone'] ?? '';
$email = $_POST['email'] ?? '';
$join_date = $_POST['join_date'] ?? date('Y-m-d');
$status = $_POST['status'] ?? 'active';
$stmt = db()->prepare("INSERT INTO charity_members (name, role, phone, email, join_date, status, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute([$name, $role, $phone, $email, $join_date, $status, $_SESSION['user_id'], $_SESSION['user_id']]);
$_SESSION['success'] = "تمت إضافة العضو بنجاح.";
redirect('charity_members.php');
} elseif (isset($_POST['edit_member']) && (isAdmin() || canEdit('charity_members'))) {
$id = $_POST['id'];
$name = $_POST['name'] ?? '';
$role = $_POST['role'] ?? '';
$phone = $_POST['phone'] ?? '';
$email = $_POST['email'] ?? '';
$join_date = $_POST['join_date'] ?? date('Y-m-d');
$status = $_POST['status'] ?? 'active';
$stmt = db()->prepare("UPDATE charity_members SET name = ?, role = ?, phone = ?, email = ?, join_date = ?, status = ?, updated_by = ? WHERE id = ?");
$stmt->execute([$name, $role, $phone, $email, $join_date, $status, $_SESSION['user_id'], $id]);
$_SESSION['success'] = "تم تحديث العضو بنجاح.";
redirect('charity_members.php');
} elseif (isset($_POST['delete_member']) && (isAdmin() || canDelete('charity_members'))) {
$id = $_POST['id'];
$stmt = db()->prepare("DELETE FROM charity_members WHERE id = ?");
$stmt->execute([$id]);
$_SESSION['success'] = "تم حذف العضو بنجاح.";
redirect('charity_members.php');
}
}
// Fetch members
$search = $_GET['search'] ?? '';
$query = "SELECT * FROM charity_members";
$params = [];
if (!empty($search)) {
$query .= " WHERE name LIKE ? OR role LIKE ? OR phone LIKE ? OR email LIKE ?";
$searchTerm = "%$search%";
$params = [$searchTerm, $searchTerm, $searchTerm, $searchTerm];
}
$query .= " ORDER BY name ASC";
$stmt = db()->prepare($query);
$stmt->execute($params);
$members = $stmt->fetchAll();
?>