Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/medical/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: loyalty-program.php

<?php
session_start();
include('includes/db_connection.php');

// Create required tables if they don't exist
$create_tables = [
    'system_settings' => "
        CREATE TABLE IF NOT EXISTS system_settings (
            id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
            setting_key VARCHAR(100) UNIQUE NOT NULL,
            setting_value TEXT,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    ",
    
    'loyalty_transactions' => "
        CREATE TABLE IF NOT EXISTS loyalty_transactions (
            id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
            customer_id INT(11) NOT NULL,
            points INT(11) NOT NULL,
            type ENUM('purchase', 'manual', 'redemption', 'welcome', 'birthday', 'referral') DEFAULT 'purchase',
            reason VARCHAR(255),
            discount_amount DECIMAL(10,2) DEFAULT 0.00,
            sale_id INT(11) DEFAULT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    "
];

foreach ($create_tables as $table_name => $create_sql) {
    if (!$conn->query($create_sql)) {
        $_SESSION['error_message'] = "Error creating $table_name table: " . $conn->error;
    }
}

// Check if loyalty_points column exists in customers table, add if not
$check_column = $conn->query("SHOW COLUMNS FROM customers LIKE 'loyalty_points'");
if ($check_column->num_rows == 0) {
    $conn->query("ALTER TABLE customers ADD COLUMN loyalty_points INT DEFAULT 0");
}

// Initialize default loyalty settings
$default_settings = [
    'loyalty_points_per_rupee' => 1,
    'loyalty_rupees_per_point' => 0.1,
    'loyalty_min_points_redeem' => 100,
    'loyalty_min_purchase_redeem' => 500,
    'loyalty_welcome_points' => 50,
    'loyalty_birthday_points' => 100,
    'loyalty_referral_points' => 200
];

// Check if settings exist, insert defaults if not
foreach ($default_settings as $key => $value) {
    $check = $conn->prepare("SELECT id FROM system_settings WHERE setting_key = ?");
    $check->bind_param("s", $key);
    $check->execute();
    
    if ($check->get_result()->num_rows == 0) {
        $insert = $conn->prepare("INSERT INTO system_settings (setting_key, setting_value) VALUES (?, ?)");
        $insert->bind_param("ss", $key, $value);
        $insert->execute();
    }
}

// Get loyalty program settings
$settings_query = "SELECT setting_key, setting_value FROM system_settings WHERE setting_key LIKE 'loyalty_%'";
$settings_result = $conn->query($settings_query);
$loyalty_settings = [];

if ($settings_result) {
    while ($setting = $settings_result->fetch_assoc()) {
        $loyalty_settings[$setting['setting_key']] = $setting['setting_value'];
    }
}

// Merge with defaults to ensure all settings exist
$loyalty_settings = array_merge($default_settings, $loyalty_settings);

// Handle save settings
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['save_settings'])) {
    foreach ($_POST as $key => $value) {
        if (strpos($key, 'loyalty_') === 0) {
            $check_query = "SELECT id FROM system_settings WHERE setting_key = ?";
            $stmt = $conn->prepare($check_query);
            $stmt->bind_param("s", $key);
            $stmt->execute();
            
            if ($stmt->get_result()->num_rows > 0) {
                $update_query = "UPDATE system_settings SET setting_value = ? WHERE setting_key = ?";
                $stmt = $conn->prepare($update_query);
                $stmt->bind_param("ss", $value, $key);
                $stmt->execute();
            } else {
                $insert_query = "INSERT INTO system_settings (setting_key, setting_value) VALUES (?, ?)";
                $stmt = $conn->prepare($insert_query);
                $stmt->bind_param("ss", $key, $value);
                $stmt->execute();
            }
            
            // Update local settings array
            $loyalty_settings[$key] = $value;
        }
    }
    $_SESSION['success_message'] = "Loyalty program settings updated successfully!";
    header("Location: loyalty-program.php");
    exit();
}

// Handle add points
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['add_points'])) {
    $customer_id = (int)$_POST['customer_id'];
    $points = (int)$_POST['points'];
    $reason = $conn->real_escape_string($_POST['reason']);
    
    if ($customer_id > 0 && $points > 0) {
        // Update customer points
        $update_query = "UPDATE customers SET loyalty_points = loyalty_points + ? WHERE id = ?";
        $stmt = $conn->prepare($update_query);
        $stmt->bind_param("ii", $points, $customer_id);
        
        if ($stmt->execute()) {
            // Log the transaction
            $log_query = "INSERT INTO loyalty_transactions (customer_id, points, type, reason, created_at) 
                         VALUES (?, ?, 'manual', ?, NOW())";
            $stmt = $conn->prepare($log_query);
            $stmt->bind_param("iis", $customer_id, $points, $reason);
            $stmt->execute();
            
            $_SESSION['success_message'] = "Successfully added $points points to customer!";
        } else {
            $_SESSION['error_message'] = "Error adding points: " . $conn->error;
        }
    }
    header("Location: loyalty-program.php");
    exit();
}

// Handle redeem points
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['redeem_points'])) {
    $customer_id = (int)$_POST['customer_id_redeem'];
    $points = (int)$_POST['redeem_points_amount'];
    $sale_id = isset($_POST['sale_id']) ? (int)$_POST['sale_id'] : 0;
    
    // Get customer current points
    $customer_query = "SELECT loyalty_points FROM customers WHERE id = ?";
    $stmt = $conn->prepare($customer_query);
    $stmt->bind_param("i", $customer_id);
    $stmt->execute();
    $customer = $stmt->get_result()->fetch_assoc();
    
    if ($customer && $customer['loyalty_points'] >= $points) {
        // Calculate discount amount
        $discount_amount = $points * $loyalty_settings['loyalty_rupees_per_point'];
        
        // Update customer points
        $update_query = "UPDATE customers SET loyalty_points = loyalty_points - ? WHERE id = ?";
        $stmt = $conn->prepare($update_query);
        $stmt->bind_param("ii", $points, $customer_id);
        
        if ($stmt->execute()) {
            // Log the redemption
            $log_query = "INSERT INTO loyalty_transactions (customer_id, points, type, discount_amount, sale_id, created_at) 
                         VALUES (?, ?, 'redemption', ?, ?, NOW())";
            $stmt = $conn->prepare($log_query);
            $stmt->bind_param("iidi", $customer_id, $points, $discount_amount, $sale_id);
            $stmt->execute();
            
            $_SESSION['success_message'] = "Successfully redeemed $points points (₹" . number_format($discount_amount, 2) . " discount)!";
        }
    } else {
        $_SESSION['error_message'] = "Insufficient points or invalid customer!";
    }
    header("Location: loyalty-program.php");
    exit();
}

// Fetch top customers by loyalty points
$top_customers_query = "
    SELECT id, customer_name, customer_phone, loyalty_points, total_purchases, 
           (loyalty_points * ?) as points_value
    FROM customers 
    WHERE loyalty_points > 0 AND status = 'active'
    ORDER BY loyalty_points DESC 
    LIMIT 10
";

$stmt = $conn->prepare($top_customers_query);
$stmt->bind_param("d", $loyalty_settings['loyalty_rupees_per_point']);
$stmt->execute();
$top_customers_result = $stmt->get_result();

// Fetch recent loyalty transactions
$transactions_query = "
    SELECT lt.*, c.customer_name, c.customer_phone
    FROM loyalty_transactions lt
    LEFT JOIN customers c ON lt.customer_id = c.id
    ORDER BY lt.created_at DESC 
    LIMIT 50
";

$transactions_result = $conn->query($transactions_query);

// Fetch all customers for dropdown
$customers_query = "SELECT id, customer_name, customer_phone, loyalty_points FROM customers WHERE status = 'active' ORDER BY customer_name";
$customers_result = $conn->query($customers_query);

// Calculate total loyalty stats
$stats_query = "
    SELECT 
        COALESCE(SUM(loyalty_points), 0) as total_points,
        COALESCE(COUNT(DISTINCT id), 0) as active_members,
        COALESCE(AVG(loyalty_points), 0) as avg_points,
        COALESCE(MAX(loyalty_points), 0) as max_points
    FROM customers 
    WHERE loyalty_points > 0 AND status = 'active'
";

$stats_result = $conn->query($stats_query);
$stats = $stats_result->fetch_assoc();

// Fetch customers for redeem dropdown
$customers_result2 = $conn->query($customers_query);
?>

<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8"/>
    <title>Loyalty Program - MD Medicals</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    
    
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    
    
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
    
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css"/>
    
    <link href="assets/css/app.min.css" rel="stylesheet" type="text/css"/>
    
    <style>
        .points-badge {
            background: linear-gradient(45deg, #6a11cb 0%, #2575fc 100%);
            color: white;
            padding: 8px 16px;
            border-radius: 20px;
            font-weight: 600;
            display: inline-block;
        }
        
        .tier-card {
            border-radius: 15px;
            padding: 20px;
            text-align: center;
            transition: transform 0.3s;
            margin-bottom: 20px;
        }
        
        .tier-card:hover {
            transform: translateY(-5px);
        }
        
        .tier-bronze { background: linear-gradient(135deg, #CD7F32, #E6B87D); color: white; }
        .tier-silver { background: linear-gradient(135deg, #C0C0C0, #F0F0F0); }
        .tier-gold { background: linear-gradient(135deg, #FFD700, #FFF8DC); }
        .tier-platinum { background: linear-gradient(135deg, #E5E4E2, #F8F8FF); }
        
        .progress-bar-points {
            background: linear-gradient(90deg, #6a11cb, #2575fc);
        }
        
        .loyalty-benefit {

padding-left: 15px;
            margin-bottom: 15px;
        }
        
        .stat-card {

transition: transform 0.2s;
        }
        .stat-card:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
    </style>
</head>

<div id="layout-wrapper">

<?php include('includes/topbar.php') ?>
    
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php') ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">

<?php if (isset($_SESSION['success_message'])): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo $_SESSION['success_message']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['success_message']); ?>
                <?php endif; ?>
                
                <?php if (isset($_SESSION['error_message'])): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo $_SESSION['error_message']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['error_message']); ?>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $stats['total_points'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Total Points Issued</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-star-circle font-size-24 text-primary"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $stats['active_members'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Active Members</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-account-group font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format(($stats['total_points'] ?? 0) * $loyalty_settings['loyalty_rupees_per_point'], 2); ?></h4>
                                        <p class="text-muted mb-0">Total Points Value</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cash font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card stat-card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $stats['max_points'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Highest Points</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-trophy font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Quick Actions</h5>
                                <div class="row">
                                    <div class="col-md-4 mb-3">
                                        <button type="button" class="btn btn-primary w-100" data-bs-toggle="modal" data-bs-target="#addPointsModal">
                                            <i class="mdi mdi-plus-circle me-1"></i> Add Points
                                        </button>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <button type="button" class="btn btn-warning w-100" data-bs-toggle="modal" data-bs-target="#redeemPointsModal">
                                            <i class="mdi mdi-gift-outline me-1"></i> Redeem Points
                                        </button>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <button type="button" class="btn btn-info w-100" data-bs-toggle="modal" data-bs-target="#settingsModal">
                                            <i class="mdi mdi-cog me-1"></i> Program Settings
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">How It Works</h5>
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="loyalty-benefit">
                                            <h6><i class="mdi mdi-cash-multiple text-success me-2"></i>Earn Points</h6>
                                            <p class="text-muted mb-0">
                                                Earn <?php echo $loyalty_settings['loyalty_points_per_rupee']; ?> point for every ₹1 spent
                                            </p>
                                        </div>
                                        <div class="loyalty-benefit">
                                            <h6><i class="mdi mdi-account-plus text-primary me-2"></i>Welcome Bonus</h6>
                                            <p class="text-muted mb-0">
                                                Get <?php echo $loyalty_settings['loyalty_welcome_points']; ?> points on joining
                                            </p>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="loyalty-benefit">
                                            <h6><i class="mdi mdi-gift text-warning me-2"></i>Redeem Points</h6>
                                            <p class="text-muted mb-0">
                                                1 point = ₹<?php echo number_format($loyalty_settings['loyalty_rupees_per_point'], 2); ?> discount
                                            </p>
                                        </div>
                                        <div class="loyalty-benefit">
                                            <h6><i class="mdi mdi-cake text-danger me-2"></i>Birthday Bonus</h6>
                                            <p class="text-muted mb-0">
                                                Get <?php echo $loyalty_settings['loyalty_birthday_points']; ?> points on your birthday
                                            </p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-lg-4">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Minimum Requirements</h5>
                                <ul class="list-unstyled">
                                    <li class="mb-2">
                                        <i class="mdi mdi-check-circle text-success me-2"></i>
                                        Minimum <?php echo $loyalty_settings['loyalty_min_points_redeem']; ?> points to redeem
                                    </li>
                                    <li class="mb-2">
                                        <i class="mdi mdi-check-circle text-success me-2"></i>
                                        Minimum ₹<?php echo $loyalty_settings['loyalty_min_purchase_redeem']; ?> purchase to redeem
                                    </li>
                                    <li class="mb-2">
                                        <i class="mdi mdi-check-circle text-success me-2"></i>
                                        Points valid for 1 year
                                    </li>
                                    <li>
                                        <i class="mdi mdi-check-circle text-success me-2"></i>
                                        No expiry for Gold members
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Top Loyalty Customers</h5>
                                <div class="table-responsive">
                                    <table class="table table-hover mb-0">
                                        <thead>
                                            <tr>
                                                <th>Rank</th>
                                                <th>Customer</th>
                                                <th>Phone</th>
                                                <th>Loyalty Points</th>
                                                <th>Points Value</th>
                                                <th>Total Purchases</th>
                                                <th>Tier</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if ($top_customers_result->num_rows > 0): ?>
                                                <?php $rank = 1; ?>
                                                <?php while ($customer = $top_customers_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Determine tier based on points
                                                    $points = $customer['loyalty_points'];
                                                    if ($points >= 1000) {
                                                        $tier = 'Platinum';
                                                        $tier_class = 'text-primary';
                                                    } elseif ($points >= 500) {
                                                        $tier = 'Gold';
                                                        $tier_class = 'text-warning';
                                                    } elseif ($points >= 200) {
                                                        $tier = 'Silver';
                                                        $tier_class = 'text-secondary';
                                                    } else {
                                                        $tier = 'Bronze';
                                                        $tier_class = 'text-danger';
                                                    }
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <?php if ($rank == 1): ?>
                                                                <i class="mdi mdi-trophy text-warning"></i>
                                                            <?php elseif ($rank == 2): ?>
                                                                <i class="mdi mdi-trophy-outline text-secondary"></i>
                                                            <?php elseif ($rank == 3): ?>
                                                                <i class="mdi mdi-medal-outline text-danger"></i>
                                                            <?php else: ?>
                                                                <span class="text-muted">#<?php echo $rank; ?></span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($customer['customer_name']); ?></strong>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($customer['customer_phone']); ?></td>
                                                        <td>
                                                            <span class="points-badge"><?php echo $points; ?> pts</span>
                                                        </td>
                                                        <td>
                                                            <strong>₹<?php echo number_format($customer['points_value'], 2); ?></strong>
                                                        </td>
                                                        <td>₹<?php echo number_format($customer['total_purchases'], 2); ?></td>
                                                        <td>
                                                            <span class="<?php echo $tier_class; ?>">
                                                                <i class="mdi mdi-crown me-1"></i><?php echo $tier; ?>
                                                            </span>
                                                        </td>
                                                    </tr>
                                                    <?php $rank++; ?>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="7" class="text-center text-muted">
                                                        No loyalty customers found. Start adding points to customers!
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title">Recent Loyalty Transactions</h5>
                                <div class="table-responsive">
                                    <table class="table table-hover mb-0">
                                        <thead>
                                            <tr>
                                                <th>Date & Time</th>
                                                <th>Customer</th>
                                                <th>Type</th>
                                                <th>Points</th>
                                                <th>Value</th>
                                                <th>Reason/Details</th>
                                                <th>Sale ID</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if ($transactions_result && $transactions_result->num_rows > 0): ?>
                                                <?php while ($transaction = $transactions_result->fetch_assoc()): ?>
                                                    <?php
                                                    $point_class = $transaction['points'] > 0 ? 'text-success' : 'text-danger';
                                                    $icon = $transaction['points'] > 0 ? 'mdi-plus-circle' : 'mdi-minus-circle';
                                                    $type_badge = '';
                                                    
                                                    switch($transaction['type']) {
                                                        case 'purchase':
                                                            $type_badge = '<span class="badge bg-primary">Purchase</span>';
                                                            break;
                                                        case 'manual':
                                                            $type_badge = '<span class="badge bg-info">Manual</span>';
                                                            break;
                                                        case 'redemption':
                                                            $type_badge = '<span class="badge bg-warning">Redeemed</span>';
                                                            break;
                                                        case 'welcome':
                                                            $type_badge = '<span class="badge bg-success">Welcome</span>';
                                                            break;
                                                        case 'birthday':
                                                            $type_badge = '<span class="badge bg-danger">Birthday</span>';
                                                            break;
                                                        case 'referral':
                                                            $type_badge = '<span class="badge bg-purple">Referral</span>';
                                                            break;
                                                    }
                                                    ?>
                                                    <tr>
                                                        <td><?php echo date('d M Y h:i A', strtotime($transaction['created_at'])); ?></td>
                                                        <td>
                                                            <?php if ($transaction['customer_name']): ?>
                                                                <?php echo htmlspecialchars($transaction['customer_name']); ?>
                                                                <br><small class="text-muted"><?php echo htmlspecialchars($transaction['customer_phone']); ?></small>
                                                            <?php else: ?>
                                                                <span class="text-muted">Customer not found</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo $type_badge; ?></td>
                                                        <td>
                                                            <span class="<?php echo $point_class; ?>">
                                                                <i class="mdi <?php echo $icon; ?> me-1"></i>
                                                                <?php echo $transaction['points']; ?> pts
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <?php if ($transaction['discount_amount'] > 0): ?>
                                                                -₹<?php echo number_format($transaction['discount_amount'], 2); ?>
                                                            <?php else: ?>
                                                                ₹<?php echo number_format(abs($transaction['points']) * $loyalty_settings['loyalty_rupees_per_point'], 2); ?>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($transaction['reason'] ?: '-'); ?></td>
                                                        <td>
                                                            <?php if ($transaction['sale_id']): ?>
                                                                <a href="view-sale.php?id=<?php echo $transaction['sale_id']; ?>" class="text-primary">
                                                                    #<?php echo $transaction['sale_id']; ?>
                                                                </a>
                                                            <?php else: ?>
                                                                <span class="text-muted">-</span>
                                                            <?php endif; ?>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="7" class="text-center text-muted">
                                                        No loyalty transactions yet
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<footer class="footer">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        ©
                        <script>document.write(new Date().getFullYear())</script> MD Medicals<span class="d-none d-sm-inline-block"> -
                            designed and developed by Ecommer <a href="https://ecommer.in" target="_blank">ecommer.in</a></span>
                    </div>
                </div>
            </div>
        </footer>
    </div>

</div>

<div class="modal fade" id="addPointsModal" tabindex="-1" aria-labelledby="addPointsModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="addPointsModalLabel">Add Loyalty Points</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Select Customer</label>
                        <select class="form-select" name="customer_id" required>
                            <option value="">Choose customer...</option>
                            <?php if ($customers_result->num_rows > 0): ?>
                                <?php while ($customer = $customers_result->fetch_assoc()): ?>
                                    <option value="<?php echo $customer['id']; ?>">
                                        <?php echo htmlspecialchars($customer['customer_name']); ?> 
                                        (<?php echo $customer['customer_phone']; ?>)
                                        - <?php echo $customer['loyalty_points']; ?> points
                                    </option>
                                <?php endwhile; ?>
                            <?php endif; ?>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Points to Add</label>
                        <input type="number" class="form-control" name="points" min="1" max="10000" required>
                        <small class="text-muted">Enter positive number to add points</small>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Reason</label>
                        <select class="form-select" name="reason" required>
                            <option value="">Select reason...</option>
                            <option value="Birthday Bonus">Birthday Bonus</option>
                            <option value="Referral Bonus">Referral Bonus</option>
                            <option value="Manual Adjustment">Manual Adjustment</option>
                            <option value="Special Promotion">Special Promotion</option>
                            <option value="Customer Service">Customer Service</option>
                            <option value="Other">Other</option>
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="add_points" class="btn btn-primary">Add Points</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="redeemPointsModal" tabindex="-1" aria-labelledby="redeemPointsModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="redeemPointsModalLabel">Redeem Loyalty Points</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="alert alert-info">
                        <i class="mdi mdi-information-outline me-2"></i>
                        Conversion rate: 1 point = ₹<?php echo number_format($loyalty_settings['loyalty_rupees_per_point'], 2); ?> discount
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Select Customer</label>
                        <select class="form-select" name="customer_id_redeem" id="customerSelect" required>
                            <option value="">Choose customer...</option>
                            <?php if ($customers_result2->num_rows > 0): ?>
                                <?php while ($customer = $customers_result2->fetch_assoc()): ?>
                                    <option value="<?php echo $customer['id']; ?>" data-points="<?php echo $customer['loyalty_points']; ?>">
                                        <?php echo htmlspecialchars($customer['customer_name']); ?> 
                                        (<?php echo $customer['customer_phone']; ?>)
                                        - <?php echo $customer['loyalty_points']; ?> points
                                    </option>
                                <?php endwhile; ?>
                            <?php endif; ?>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Available Points</label>
                        <input type="text" class="form-control" id="availablePoints" readonly value="0">
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Points to Redeem</label>
                        <input type="number" class="form-control" name="redeem_points_amount" id="redeemPoints" 
                               min="<?php echo $loyalty_settings['loyalty_min_points_redeem']; ?>" required>
                        <small class="text-muted">Minimum <?php echo $loyalty_settings['loyalty_min_points_redeem']; ?> points required</small>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Discount Amount</label>
                        <input type="text" class="form-control" id="discountAmount" readonly value="₹0.00">
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Sale ID (Optional)</label>
                        <input type="number" class="form-control" name="sale_id" placeholder="Enter sale ID if applicable">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="redeem_points" class="btn btn-warning">Redeem Points</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="settingsModal" tabindex="-1" aria-labelledby="settingsModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="settingsModalLabel">Loyalty Program Settings</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Points per ₹1 spent</label>
                            <input type="number" step="0.1" class="form-control" 
                                   name="loyalty_points_per_rupee" 
                                   value="<?php echo $loyalty_settings['loyalty_points_per_rupee']; ?>" required>
                            <small class="text-muted">How many points customer earns per ₹1</small>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">₹ per point (Redemption)</label>
                            <input type="number" step="0.01" class="form-control" 
                                   name="loyalty_rupees_per_point" 
                                   value="<?php echo $loyalty_settings['loyalty_rupees_per_point']; ?>" required>
                            <small class="text-muted">Discount value of 1 point</small>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Minimum Points to Redeem</label>
                            <input type="number" class="form-control" 
                                   name="loyalty_min_points_redeem" 
                                   value="<?php echo $loyalty_settings['loyalty_min_points_redeem']; ?>" required>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Minimum Purchase to Redeem (₹)</label>
                            <input type="number" class="form-control" 
                                   name="loyalty_min_purchase_redeem" 
                                   value="<?php echo $loyalty_settings['loyalty_min_purchase_redeem']; ?>" required>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Welcome Bonus Points</label>
                            <input type="number" class="form-control" 
                                   name="loyalty_welcome_points" 
                                   value="<?php echo $loyalty_settings['loyalty_welcome_points']; ?>" required>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Birthday Bonus Points</label>
                            <input type="number" class="form-control" 
                                   name="loyalty_birthday_points" 
                                   value="<?php echo $loyalty_settings['loyalty_birthday_points']; ?>" required>
                        </div>
                        <div class="col-md-12 mb-3">
                            <label class="form-label">Referral Bonus Points</label>
                            <input type="number" class="form-control" 
                                   name="loyalty_referral_points" 
                                   value="<?php echo $loyalty_settings['loyalty_referral_points']; ?>" required>
                            <small class="text-muted">Points given to both referrer and referred customer</small>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="save_settings" class="btn btn-primary">Save Settings</button>
                </div>
            </form>
        </div>
    </div>
</div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>

<script src="assets/js/app.js"></script>

// Update available points when customer selected
    document.getElementById('customerSelect').addEventListener('change', function() {
        const selectedOption = this.options[this.selectedIndex];
        const points = selectedOption.getAttribute('data-points') || 0;
        document.getElementById('availablePoints').value = points;
        
        // Update max points for redeem input
        const redeemInput = document.getElementById('redeemPoints');
        redeemInput.max = points;
        redeemInput.value = '';
        document.getElementById('discountAmount').value = '₹0.00';
    });

// Validate redeem points
    document.querySelector('form[name="redeem_points"]').addEventListener('submit', function(e) {
        const pointsInput = document.getElementById('redeemPoints');
        const availablePoints = parseInt(document.getElementById('availablePoints').value) || 0;
        const pointsToRedeem = parseInt(pointsInput.value) || 0;
        const minPoints = <?php echo $loyalty_settings['loyalty_min_points_redeem']; ?>;
        
        if (pointsToRedeem < minPoints) {
            alert(`Minimum ${minPoints} points required for redemption!`);
            e.preventDefault();
            return false;
        }
        
        if (pointsToRedeem > availablePoints) {
            alert('Cannot redeem more points than available!');
            e.preventDefault();
            return false;
        }
        
        const discountAmount = (pointsToRedeem * <?php echo $loyalty_settings['loyalty_rupees_per_point']; ?>).toFixed(2);
        if (!confirm(`Are you sure you want to redeem ${pointsToRedeem} points for ₹${discountAmount} discount?`)) {
            e.preventDefault();
            return false;
        }
    });

// Auto-calculate points value
    function calculatePointsValue(points) {
        return (points * <?php echo $loyalty_settings['loyalty_rupees_per_point']; ?>).toFixed(2);
    }

// Quick refresh
    setTimeout(function() {
        window.location.reload();
    }, 300000); // Refresh every 5 minutes
</script>

</body>
</html>
<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: loyalty-program.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation