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/ecommer.in/public_html/billing/srivari

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: add-plan.php

<?php
// add-plan.php - Add New Chit Plan (With File Existence Checks)
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
session_start();

// Define base path
$base_path = dirname(__FILE__);

// Check and include required files
$include_files = [
    'db.php',
    'head.php',
    'topbar.php',
    
    'leftbar.php',
    'breadcrumb.php',
    'rightbar.php',
    'footer.php',
    'scripts.php'
];

foreach ($include_files as $file) {
    $file_path = $base_path . '/includes/' . $file;
    if (!file_exists($file_path)) {
        die("Error: Required file 'includes/$file' not found. Please check your installation.");
    }
}

include 'includes/db.php';

$edit_mode = isset($_GET['edit']) && is_numeric($_GET['edit']);
$plan_id = $edit_mode ? intval($_GET['edit']) : 0;
$plan_data = [];
$plan_details = [];

// Load existing plan data for editing
if ($edit_mode) {
    $stmt = $conn->prepare("SELECT * FROM plans WHERE id = ?");
    $stmt->bind_param("i", $plan_id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($result->num_rows > 0) {
        $plan_data = $result->fetch_assoc();
        
        // Load plan details
        $stmt_details = $conn->prepare("SELECT * FROM plan_details WHERE plan_id = ? ORDER BY period_number ASC");
        $stmt_details->bind_param("i", $plan_id);
        $stmt_details->execute();
        $result_details = $stmt_details->get_result();
        
        while ($row = $result_details->fetch_assoc()) {
            $plan_details[] = $row;
        }
        $stmt_details->close();
    } else {
        $_SESSION['error'] = "Plan not found.";
        header("Location: manage-plans.php");
        exit;
    }
    $stmt->close();
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $title = trim($_POST['title'] ?? '');
    $plan_type = $_POST['plan_type'] ?? 'monthly';
    $total_periods = intval($_POST['total_periods'] ?? 0);
    $installment_amount = floatval($_POST['installment_amount'] ?? 0);
    $total_received_amount = floatval($_POST['total_received_amount'] ?? 0);
    $weekly_installment = floatval($_POST['weekly_installment'] ?? 0);
    $daily_installment = floatval($_POST['daily_installment'] ?? 0);
    
    $monthly_installment = $installment_amount;
    $total_months = $total_periods;
    $period_type = $plan_type == 'weekly' ? 'week' : ($plan_type == 'daily' ? 'day' : 'month');
    
    $errors = [];
    if (empty($title)) $errors[] = "Plan title is required.";
    if ($total_periods <= 0) $errors[] = "Total periods must be greater than 0.";
    if ($installment_amount <= 0) $errors[] = "Installment amount must be greater than 0.";
    if ($total_received_amount <= 0) $errors[] = "Total received amount must be greater than 0.";
    
    if (!empty($errors)) {
        $_SESSION['error'] = "• " . implode("<br>• ", $errors);
        header("Location: add-plan.php" . ($edit_mode ? "?edit=$plan_id" : ""));
        exit;
    }
    
    $period_details_data = [];
    
    for ($i = 1; $i <= $total_periods; $i++) {
        $installment_key = ($plan_type == 'weekly') ? "week_{$i}_installment" : "month_{$i}_installment";
        $withdrawal_key = ($plan_type == 'weekly') ? "week_{$i}_withdrawal" : "month_{$i}_withdrawal";
        
        $installment = isset($_POST[$installment_key]) ? floatval($_POST[$installment_key]) : $installment_amount;
        $withdrawal = isset($_POST[$withdrawal_key]) ? floatval($_POST[$withdrawal_key]) : 0;
        
        $period_details_data[] = [
            'period' => $i,
            'installment' => $installment,
            'withdrawal' => $withdrawal
        ];
    }
    
    $conn->begin_transaction();
    
    try {
        if ($edit_mode) {
            $stmt = $conn->prepare("UPDATE plans SET 
                title = ?, 
                plan_type = ?,
                installment_amount = ?,
                total_periods = ?,
                monthly_installment = ?, 
                total_months = ?, 
                total_received_amount = ?,
                weekly_installment = ?,
                daily_installment = ?,
                period_type = ?
                WHERE id = ?");
            
            $stmt->bind_param("ssdididddsi", 
                $title,
                $plan_type,
                $installment_amount,
                $total_periods,
                $monthly_installment,
                $total_months,
                $total_received_amount,
                $weekly_installment,
                $daily_installment,
                $period_type,
                $plan_id
            );
        } else {
            $stmt = $conn->prepare("INSERT INTO plans 
                (title, plan_type, installment_amount, total_periods, monthly_installment, total_months, total_received_amount, weekly_installment, daily_installment, period_type) 
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
            
            $stmt->bind_param("ssdididdds", 
                $title,
                $plan_type,
                $installment_amount,
                $total_periods,
                $monthly_installment,
                $total_months,
                $total_received_amount,
                $weekly_installment,
                $daily_installment,
                $period_type
            );
        }
        
        if (!$stmt->execute()) {
            throw new Exception("Failed to save plan: " . $stmt->error);
        }
        
        $plan_id = $edit_mode ? $plan_id : $conn->insert_id;
        $stmt->close();
        
        $conn->query("DELETE FROM plan_details WHERE plan_id = $plan_id");
        
        $stmt_detail = $conn->prepare("INSERT INTO plan_details 
            (plan_id, period_number, installment, withdrawal_eligible, period_type, is_collection_day) 
            VALUES (?, ?, ?, ?, ?, 1)");
        
        foreach ($period_details_data as $detail) {
            $stmt_detail->bind_param("iidds",
                $plan_id,
                $detail['period'],
                $detail['installment'],
                $detail['withdrawal'],
                $period_type
            );
            
            if (!$stmt_detail->execute()) {
                throw new Exception("Failed to save plan details: " . $stmt_detail->error);
            }
        }
        
        $stmt_detail->close();
        
        $conn->commit();
        
        $_SESSION['success'] = $edit_mode ? "Plan updated successfully!" : "Plan created successfully!";
        header("Location: manage-plans.php");
        exit;
        
    } catch (Exception $e) {
        $conn->rollback();
        $_SESSION['error'] = $e->getMessage();
        header("Location: add-plan.php" . ($edit_mode ? "?edit=$plan_id" : ""));
        exit;
    }
}
?>
<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>
<style>
    .plan-type-card {
        cursor: pointer;
        transition: all 0.3s;
        border: 2px solid #dee2e6;
        padding: 20px;
        border-radius: 10px;
        text-align: center;
        height: 100%;
    }
    .plan-type-card:hover {
        border-color: #0d6efd;
        transform: translateY(-5px);
        box-shadow: 0 5px 15px rgba(0,0,0,0.1);
    }
    .plan-type-card.active {
        border-color: #0d6efd;
        background-color: #e7f1ff;
    }
    .plan-type-card i {
        font-size: 2.5rem;
        margin-bottom: 10px;
        color: #0d6efd;
    }
    .fixed-amounts-card {
        background: #f8f9fa;
        border-radius: 8px;
        padding: 15px;
        height: 100%;
        border-left: 4px solid #198754;
    }
    .summary-card {
        background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
        color: white;
        padding: 20px;
        border-radius: 12px;
        height: 100%;
    }
    .summary-item {
        background: rgba(255, 255, 255, 0.1);
        padding: 12px;
        border-radius: 8px;
        margin-bottom: 10px;
    }
    .plan-details-container {
        max-height: 500px;
        overflow-y: auto;
        border: 1px solid #dee2e6;
        border-radius: 8px;
        padding: 15px;
        margin-top: 20px;
    }
    .detail-row {
        transition: background-color 0.2s;
    }
    .detail-row:hover {
        background-color: #f8f9fa;
    }
    .highlight {
        border-left: 4px solid #0d6efd;
        background: #e7f1ff !important;
    }
    .badge-monthly { background-color: #0d6efd; color: white; padding: 3px 8px; border-radius: 4px; font-size: 11px; margin-left: 5px; }
    .badge-weekly { background-color: #198754; color: white; padding: 3px 8px; border-radius: 4px; font-size: 11px; margin-left: 5px; }
    .badge-daily { background-color: #ffc107; color: black; padding: 3px 8px; border-radius: 4px; font-size: 11px; margin-left: 5px; }
    .period-indicator {
        display: inline-block;
        padding: 2px 6px;
        border-radius: 4px;
        font-size: 11px;
        background-color: #6c757d;
        color: white;
        margin-left: 5px;
    }
</style>
<body>
    <?php include 'includes/topbar.php'; ?>
    <div class="startbar d-print-none">
       
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>
    </div>
    <div class="page-wrapper">
        <div class="page-content">
            <div class="container-fluid">
                <?php
                $page_title = $edit_mode ? "Edit Plan" : "Add New Plan";
                $breadcrumb_active = $page_title;
                include 'includes/breadcrumb.php';
                ?>
                
                <?php if (isset($_SESSION['success'])): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <?= $_SESSION['success']; unset($_SESSION['success']); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>
                
                <?php if (isset($_SESSION['error'])): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <?= $_SESSION['error']; unset($_SESSION['error']); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>
                
                <div class="row align-items-center mb-3">
                    <div class="col">
                        <h3 class="mb-0"><?= $edit_mode ? 'Edit Chit Fund Plan' : 'Create New Chit Fund Plan'; ?></h3>
                        <small class="text-muted">Define plan structure with monthly, weekly, and daily options</small>
                    </div>
                    <div class="col-auto">
                        <a href="manage-plans.php" class="btn btn-light">Back to Plans</a>
                    </div>
                </div>
                
                <form method="POST">
                    
                    <div class="card mb-4">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Select Plan Type</h4>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-4 mb-3">
                                    <div class="plan-type-card active" onclick="selectPlanType('monthly')" id="type-monthly">
                                        <i class="fas fa-calendar-alt"></i>
                                        <h5>Monthly Plan</h5>
                                        <p class="text-muted mb-0">Standard monthly installments</p>
                                        <span class="badge-monthly">Monthly</span>
                                        <input type="radio" name="plan_type" value="monthly" class="d-none" checked>
                                    </div>
                                </div>
                                <div class="col-md-4 mb-3">
                                    <div class="plan-type-card" onclick="selectPlanType('weekly')" id="type-weekly">
                                        <i class="fas fa-calendar-week"></i>
                                        <h5>Weekly Plan</h5>
                                        <p class="text-muted mb-0">Weekly installments (4 weeks/month)</p>
                                        <span class="badge-weekly">Weekly</span>
                                        <input type="radio" name="plan_type" value="weekly" class="d-none">
                                    </div>
                                </div>
                                <div class="col-md-4 mb-3">
                                    <div class="plan-type-card" onclick="selectPlanType('daily')" id="type-daily">
                                        <i class="fas fa-sun"></i>
                                        <h5>Daily Plan</h5>
                                        <p class="text-muted mb-0">Daily installments (30 days/month)</p>
                                        <span class="badge-daily">Daily</span>
                                        <input type="radio" name="plan_type" value="daily" class="d-none">
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card mb-4">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Basic Plan Information</h4>
                        </div>
                        <div class="card-body">
                            <div class="row g-3">
                                <div class="col-md-6">
                                    <label class="form-label">Plan Title <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" name="title" id="plan_title" required 
                                           placeholder="e.g., 1 Lakh - 10 Months" 
                                           value="<?= $edit_mode ? htmlspecialchars($plan_data['title']) : ''; ?>"
                                           oninput="updateSummary()">
                                    <small class="text-muted plan-title-hint" id="titleHint">Descriptive name for the plan</small>
                                </div>
                                <div class="col-md-3">
                                    <label class="form-label" id="periodsLabel">Total Months <span class="text-danger">*</span></label>
                                    <input type="number" class="form-control" name="total_periods" id="total_periods" 
                                           required min="1" max="60" value="10" onchange="generateRows()">
                                    <small class="text-muted" id="periodsHint">Number of months (1-60)</small>
                                </div>
                                <div class="col-md-3">
                                    <label class="form-label" id="installmentLabel">Base Monthly Installment <span class="text-danger">*</span></label>
                                    <div class="input-group">
                                        <span class="input-group-text">₹</span>
                                        <input type="number" step="0.01" class="form-control" name="installment_amount" 
                                               id="installment_amount" required min="0.01" value="7300" 
                                               onchange="updateCalculations()">
                                    </div>
                                    <small class="text-muted" id="installmentHint">Standard monthly payment amount</small>
                                </div>
                                <div class="col-md-6">
                                    <label class="form-label">Total Received Amount <span class="text-danger">*</span></label>
                                    <div class="input-group">
                                        <span class="input-group-text">₹</span>
                                        <input type="number" step="0.01" class="form-control" name="total_received_amount" 
                                               id="total_received_amount" required min="0.01" value="89500" 
                                               onchange="updateCalculations()">
                                    </div>
                                    <small class="text-muted">Total amount member will receive</small>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card mb-4">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Fixed Amounts for Different Payment Frequencies</h4>
                            <small class="text-muted">These amounts will be used when members choose weekly or daily payment mode</small>
                        </div>
                        <div class="card-body">
                            <div class="row g-3">
                                <div class="col-md-4">
                                    <div class="fixed-amounts-card">
                                        <h6 class="mb-3">Weekly Installment</h6>
                                        <div class="input-group mb-3">
                                            <span class="input-group-text">₹</span>
                                            <input type="number" step="0.01" class="form-control" name="weekly_installment" 
                                                   id="weekly_installment" value="2250" onchange="updateCalculations()">
                                        </div>
                                        <small class="text-muted">
                                            Fixed weekly amount (4 weeks per month).<br>
                                            If 0, system will calculate automatically.
                                        </small>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="fixed-amounts-card">
                                        <h6 class="mb-3">Daily Installment</h6>
                                        <div class="input-group mb-3">
                                            <span class="input-group-text">₹</span>
                                            <input type="number" step="0.01" class="form-control" name="daily_installment" 
                                                   id="daily_installment" value="360" onchange="updateCalculations()">
                                        </div>
                                        <small class="text-muted">
                                            Fixed daily amount (30 days per month).<br>
                                            If 0, system will calculate automatically.
                                        </small>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="summary-card">
                                        <h6 class="mb-3 text-white">Quick Calculation</h6>
                                        <div class="summary-item">
                                            <small class="text-white">Monthly: <span id="calc_monthly">₹7,300.00</span></small><br>
                                            <small class="text-white">Weekly: <span id="calc_weekly">₹2,250.00</span></small><br>
                                            <small class="text-white">Daily: <span id="calc_daily">₹360.00</span></small>
                                        </div>
                                        <small class="text-white">Calculated based on monthly amount</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card mb-4">
                        <div class="card-header">
                            <h4 class="card-title mb-0">
                                <span id="detailsTitle">Monthly Plan Details</span>
                                <small class="text-muted" id="detailsSubtitle">(Optional - Monthly installment variations)</small>
                            </h4>
                        </div>
                        <div class="card-body">
                            <div class="alert alert-info">
                                <i class="fas fa-info-circle me-2"></i>
                                <span id="detailsInfoText">You can specify different monthly installment amounts and withdrawal eligibility amounts for each month. If left blank, the base monthly installment will be used for all months.</span>
                            </div>
                            
                            <div class="table-responsive">
                                <table class="table table-bordered" id="details_table">
                                    <thead class="table-light">
                                        <tr>
                                            <th width="80">#</th>
                                            <th id="periodHeader">Month</th>
                                            <th>Installment Amount (₹) <span class="text-danger">*</span></th>
                                            <th>Withdrawal Eligible (₹)</th>
                                         </thead>
                                    <tbody id="detailsBody">
                                        
                                    </tbody>
                                    <tfoot>
                                        <tr class="table-info">
                                            <th colspan="2">Total Installments Paid by Customer</th>
                                            <th id="total_installments">₹0.00</th>
                                            <th id="total_withdrawals">₹0.00</th>
                                          </tr>
                                    </tfoot>
                                  </table>
                            </div>
                            
                            <div class="mt-3">
                                <button type="button" class="btn btn-sm btn-outline-primary" id="fillAllBtn">
                                    <i class="fas fa-copy me-1"></i>Use Base Amount for All
                                </button>
                                <span class="float-end">
                                    <strong>Total Periods: <span id="totalPeriodsCount">10</span></strong>
                                </span>
                            </div>
                        </div>
                    </div>

<div class="card mb-4">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Plan Summary</h4>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <strong>Plan Overview:</strong>
                                        <ul class="mt-2 list-unstyled">
                                            <li id="summary_title">Title: <span class="text-muted">Not specified</span></li>
                                            <li id="summary_duration">Duration: <span class="text-muted">10 months</span></li>
                                            <li id="summary_monthly">Monthly: <span class="text-muted">₹7,300.00</span></li>
                                            <li id="summary_weekly">Weekly: <span class="text-muted">₹2,250.00</span></li>
                                            <li id="summary_daily">Daily: <span class="text-muted">₹360.00</span></li>
                                            <li id="summary_total">Total Payout: <span class="text-muted">₹89,500.00</span></li>
                                        </ul>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="alert alert-warning">
                                        <i class="fas fa-exclamation-triangle me-2"></i>
                                        <strong>Important:</strong> Once a plan is created and members are enrolled, 
                                        you cannot change the total months or payment structure significantly.
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between">
                                <a href="manage-plans.php" class="btn btn-light btn-lg px-4">
                                    <i class="fas fa-times me-2"></i>Cancel
                                </a>
                                <button type="submit" class="btn btn-primary btn-lg px-4">
                                    <i class="fas fa-save me-2"></i>
                                    <?= $edit_mode ? 'Update Plan' : 'Create Plan'; ?>
                                </button>
                            </div>
                        </div>
                    </div>
                </form>
            </div>

<?php include 'includes/rightbar.php'; ?>
            <?php include 'includes/footer.php'; ?>
        </div>
    </div>

<?php include 'includes/scripts.php'; ?>

for (let i = 1; i <= total; i++) {
                let installment = baseAmount;
                let withdrawal = 0;
                let periodDisplay = '';
                
                // Check for existing data
                if (existingDetails.length > 0) {
                    const existing = existingDetails.find(d => d.period_number === i);
                    if (existing) {
                        installment = existing.installment;
                        withdrawal = existing.withdrawal_eligible;
                    }
                }
                
                // Calculate period display based on type
                if (currentPlanType === 'weekly') {
                    const monthNum = Math.ceil(i / 4);
                    const weekNum = i % 4 === 0 ? 4 : i % 4;
                    periodDisplay = `Week ${i} <span class="period-indicator">Month ${monthNum}, Week ${weekNum}</span>`;
                } else if (currentPlanType === 'daily') {
                    const monthNum = Math.ceil(i / 30);
                    const weekNum = Math.ceil((i % 30 || 30) / 7);
                    const dayNum = i % 30 === 0 ? 30 : i % 30;
                    periodDisplay = `Day ${i} <span class="period-indicator">Month ${monthNum}, Week ${weekNum}, Day ${dayNum}</span>`;
                } else {
                    periodDisplay = `Month ${i}`;
                }
                
                const row = document.createElement('tr');
                row.className = 'detail-row';
                if (i === 1) row.classList.add('highlight');
                
                row.innerHTML = `
                    <td class="align-middle">${i}</td>
                    <td class="align-middle"><strong>${periodDisplay}</strong></td>
                    <td>
                        <div class="input-group">
                            <span class="input-group-text">₹</span>
                            <input type="number" step="0.01" name="${currentPlanType === 'weekly' ? 'week_' + i + '_installment' : 'month_' + i + '_installment'}" 
                                   class="form-control period-installment" 
                                   required min="0.01" value="${installment}" onchange="calculateTotal()">
                        </div>
                    </td>
                    <td>
                        <div class="input-group">
                            <span class="input-group-text">₹</span>
                            <input type="number" step="0.01" name="${currentPlanType === 'weekly' ? 'week_' + i + '_withdrawal' : 'month_' + i + '_withdrawal'}" 
                                   class="form-control period-withdrawal" 
                                   min="0" value="${withdrawal}" onchange="calculateTotal()">
                        </div>
                    </td>
                `;
                tbody.appendChild(row);
                totalInst += installment;
            }

document.getElementById('total_installments').innerHTML = '₹' + totalInst.toFixed(2);
            document.getElementById('totalPeriodsCount').textContent = total;
            updateCalculations();
        }

// Event listeners
        document.getElementById('total_periods').addEventListener('change', generateRows);
        document.getElementById('installment_amount').addEventListener('input', function() {
            const baseAmount = parseFloat(this.value) || 0;
            document.querySelectorAll('.period-installment').forEach(input => {
                input.value = baseAmount;
            });
            calculateTotal();
            updateCalculations();
        });
        
        document.getElementById('weekly_installment').addEventListener('input', updateCalculations);
        document.getElementById('daily_installment').addEventListener('input', updateCalculations);
        document.getElementById('total_received_amount').addEventListener('input', updateCalculations);
        document.getElementById('plan_title').addEventListener('input', updateSummary);
        
        // Fill all with base amount
        document.getElementById('fillAllBtn').addEventListener('click', function() {
            const baseAmount = parseFloat(document.getElementById('installment_amount').value) || 0;
            const withdrawalAmount = parseFloat(prompt("Enter withdrawal eligible amount for all periods (₹):", "0")) || 0;
            
            document.querySelectorAll('.period-installment').forEach(input => {
                input.value = baseAmount;
            });
            
            document.querySelectorAll('.period-withdrawal').forEach(input => {
                input.value = withdrawalAmount;
            });
            
            calculateTotal();
        });

// Initialize
        window.addEventListener('DOMContentLoaded', function() {
            selectPlanType(currentPlanType);
            generateRows();
            updateCalculations();
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-plan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation