Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/systemgem/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: addcustomerren.php

<?php
// ERROR DEBUGGER
error_reporting(E_ALL);
ini_set('display_errors', 1);

function shutDownFunction()
{
    $error = error_get_last();
    if ($error !== NULL && $error['type'] === E_ERROR) {
        echo "<div style='background-color: #ffebee; color: #c62828; padding: 20px; border: 2px solid #ef5350; margin: 20px; font-family: monospace;'>";
        echo "<h3>⚠️ FATAL ERROR DETECTED</h3>";
        echo "<strong>Message:</strong> " . $error['message'] . "<br>";
        echo "<strong>File:</strong> " . $error['file'] . "<br>";
        echo "<strong>Line:</strong> " . $error['line'];
        echo "</div>";
    }
}
register_shutdown_function('shutDownFunction');

session_start();
include("includes/inall.php");

// Updated to capture 'id' from your URL addcustomerren.php?id=15&ref=15
$eid = $_REQUEST['id'] ?? $_REQUEST['eid'] ?? '';
$invoice_no_from_url = $_GET['ref'] ?? '';
$action = $_REQUEST['action'] ?? 'Add';
$heading = "Customer AMC";
$addpage = "addcustomer.php";
$listpage = "viewcustomers.php";
$table = "customers";
$pkey = "id";

/* Fields to save - added invoice_no */
$_SESSION['ifield'] = array(
    "invoice_no",
    "customer_name",
    "phone_number",
    "amc_location",
    "num_cameras",
    "camera_make",
    "num_dvr",
    "dvr_make",
    "hard_disk",
    "amc_type",
    "visit_frequency",
    "agreed_amount",
    "steps",
    "concerns",
    "amc_signed_date",
    "amc_renewal_date",
    "amc_visit_date"
);

/* ================= AJAX: Mark Visit Done / Undo ================= */
if (isset($_POST['ajax']) && $_POST['ajax'] == "mark_visit_done") {
    $cid = intval($_POST['customer_id']);
    $visit_date = $_POST['visit_date'];

$check = mysqli_query($con, "SELECT sid FROM service_history WHERE customer_id='$cid' AND visit_date='$visit_date'");
    if (mysqli_num_rows($check) > 0) {
        mysqli_query($con, "DELETE FROM service_history WHERE customer_id='$cid' AND visit_date='$visit_date'");
    } else {
        mysqli_query($con, "INSERT INTO service_history (customer_id, visit_date, created_at) VALUES ('$cid','$visit_date',NOW())");
    }

$cres = mysqli_query($con, "SELECT visit_frequency FROM customers WHERE id='$cid'");
    $crow = mysqli_fetch_assoc($cres);

$last = mysqli_query($con, "SELECT visit_date FROM service_history WHERE customer_id='$cid' ORDER BY visit_date DESC LIMIT 1");
    $next_date = '';
    if (mysqli_num_rows($last) > 0) {
        $last_row = mysqli_fetch_assoc($last);
        $next = new DateTime($last_row['visit_date']);
        if ($crow['visit_frequency'] == "Monthly") $next->modify("+1 month");
        else $next->modify("+15 days");
        $next_date = $next->format("Y-m-d");
    } else {
        $res = mysqli_query($con, "SELECT amc_visit_date FROM customers WHERE id='$cid'");
        $row = mysqli_fetch_assoc($res);
        $next_date = $row['amc_visit_date'];
    }

mysqli_query($con, "UPDATE customers SET amc_visit_date='$next_date' WHERE id='$cid'");
    echo json_encode(['next_visit' => $next_date]);
    exit();
}

/* ================= SAVE CUSTOMER WITH RENEWAL HISTORY ARCHIVING ================= */
if (isset($_POST['submitin'])) {
    foreach ($_SESSION['ifield'] as $val) {
        $$val = isset($_POST[$val]) ? addslashes(trim($_POST[$val])) : '';
    }

$sql_data = [];
    foreach ($_SESSION['ifield'] as $val) $sql_data[$val] = $$val;

if ($_POST['submitin'] == "Add") {
        // --- ARCHIVING TO RENEWAL HISTORY ---
        if (!empty($eid)) {
            $old_data_res = mysqli_query($con, "SELECT * FROM customers WHERE id='" . (int)$eid . "'");
            if ($old_data_row = mysqli_fetch_assoc($old_data_res)) {

$renewal_history_data = [
                    'customer_id'  => $old_data_row['id'],
                    'invoice_no'   => $old_data_row['invoice_no'],
                    'renewal_date' => $old_data_row['amc_signed_date'],
                    'expiry_date'  => $old_data_row['amc_renewal_date'],
                    'amount_paid'  => $old_data_row['agreed_amount'],
                    'remarks'      => addslashes($old_data_row['concerns']),
                    'payment_mode' => 'Cash/Online', // Default
                    'created_at'   => date("Y-m-d H:i:s")
                ];

tep_db_perform("renewal_history", $renewal_history_data, "insert");
            }

// --- UPDATE EXISTING ROW STEP ---
            $sql_data['status'] = '1';
            $sql_data['created_date'] = date("Y-m-d");

$ins_query = tep_db_perform($table, $sql_data, "update", $pkey . "=" . (int)$eid);
            $new_eid = $eid;
        } else {
            $sql_data['status'] = '1';
            $sql_data['created_date'] = date("Y-m-d");
            $ins_query = tep_db_perform($table, $sql_data, "insert");
            $new_eid = mysqli_insert_id($con);
        }

// --- Handle Service History (Visits) ---
        if (isset($_POST['temp_visits'])) {
            $visits = json_decode($_POST['temp_visits'], true);
            if (is_array($visits)) {
                foreach ($visits as $v) {
                    mysqli_query($con, "INSERT INTO service_history (customer_id, visit_date, created_at) VALUES ('$new_eid','" . $v['date'] . "',NOW())");
                }
            }
        }
    } else {
        $ins_query = tep_db_perform($table, $sql_data, "update", $pkey . "=" . (int)$eid);
    }

if ($ins_query) {
        $_SESSION['msg'] = "AMC Renewed Successfully.";
        header("location:" . $listpage);
        exit();
    }
}

/* ================= FETCH DATA ================= */
if ($eid != "") {
    $res = mysqli_query($con, "SELECT * FROM `$table` WHERE `$pkey`='$eid'");
    $rowm = mysqli_fetch_object($res);
}

include("includes/headermain.php");
?>

.floatleft {
        float: left;
    }

.cleaner {
        clear: both;
        height: 10px;
    }

.label-red {
        color: red;
        font-weight: bold;
    }

.readonly-bg {
        background: #f8f9fa !important;
        border: 1px solid #ddd;
    }

.amount-input {
        font-weight: bold;
        color: #2d3436;
    }

.history-section {
        border-top: 2px solid #eee;
        margin-top: 30px;
        padding-top: 20px;
    }
</style>

<div class="form-group col-md-4 floatleft">
                                    <label class="label-red">*Invoice No (Renewal Ref)</label>
                                    <input type="text" class="form-control" name="invoice_no" required value="<?php echo $invoice_no_from_url ?: ($rowm->invoice_no ?? ''); ?>" style="border: 1px solid red;">
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label>*Customer Name</label>
                                    <input type="text" class="form-control" name="customer_name" required value="<?php echo $rowm->customer_name ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label>*Phone Number</label>
                                    <input type="text" class="form-control" name="phone_number" required value="<?php echo $rowm->phone_number ?? ''; ?>">
                                </div>
                                <div class="cleaner"></div>

<div class="form-group col-md-4 floatleft">
                                    <label>*AMC Location</label>
                                    <input type="text" class="form-control" name="amc_location" required value="<?php echo $rowm->amc_location ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label>Cameras Qty</label>
                                    <input type="number" class="form-control" name="num_cameras" value="<?php echo $rowm->num_cameras ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label>Camera Make</label>
                                    <input type="text" class="form-control" name="camera_make" value="<?php echo $rowm->camera_make ?? ''; ?>">
                                </div>
                                <div class="cleaner"></div>

<div class="form-group col-md-3 floatleft">
                                    <label>DVR Qty</label>
                                    <input type="number" class="form-control" name="num_dvr" value="<?php echo $rowm->num_dvr ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-3 floatleft">
                                    <label>DVR Make</label>
                                    <input type="text" class="form-control" name="dvr_make" value="<?php echo $rowm->dvr_make ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-3 floatleft">
                                    <label>Hard Disk</label>
                                    <input type="text" class="form-control" name="hard_disk" value="<?php echo $rowm->hard_disk ?? ''; ?>">
                                </div>
                                <div class="form-group col-md-3 floatleft">
                                    <label class="label-red">Agreed Amount (₹)</label>
                                    <input type="number" step="0.01" class="form-control amount-input" name="agreed_amount" value="<?php echo $rowm->agreed_amount ?? ''; ?>">
                                </div>
                                <div class="cleaner"></div>

<div class="form-group col-md-4 floatleft">
                                    <label>AMC Duration</label>
                                    <select class="form-control" name="amc_type" id="amc_type" onchange="calculateDates(); generateVisitTable();">
                                        <option value="Yearly" <?php if (($rowm->amc_type ?? '') == 'Yearly') echo 'selected'; ?>>Yearly (+1 Year)</option>
                                        <option value="Half-Yearly" <?php if (($rowm->amc_type ?? '') == 'Half-Yearly') echo 'selected'; ?>>Half-Yearly (+6 Months)</option>
                                    </select>
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label>Visit Frequency</label>
                                    <select class="form-control" name="visit_frequency" id="visit_frequency" onchange="calculateDates(); generateVisitTable();">
                                        <option value="Monthly" <?php if (($rowm->visit_frequency ?? '') == 'Monthly') echo 'selected'; ?>>Monthly</option>
                                        <option value="15 Days" <?php if (($rowm->visit_frequency ?? '') == '15 Days') echo 'selected'; ?>>Every 15 Days</option>
                                    </select>
                                </div>
                                <div class="form-group col-md-4 floatleft">
                                    <label class="label-red">*AMC Signed Date</label>
                                    <input type="date" class="form-control" name="amc_signed_date" id="signed_date" required onchange="calculateDates(); generateVisitTable();" value="<?php echo date('Y-m-d'); ?>">
                                </div>
                                <div class="cleaner"></div>

<div class="form-group col-md-6 floatleft">
                                    <label>Renewal Date (Calculated)</label>
                                    <input type="date" class="form-control readonly-bg" name="amc_renewal_date" id="renewal_date" readonly>
                                </div>
                                <div class="form-group col-md-6 floatleft">
                                    <label>First Visit Date (Calculated)</label>
                                    <input type="date" class="form-control readonly-bg" name="amc_visit_date" id="visit_date" readonly>
                                </div>
                                <div class="cleaner"></div>

<div class="form-group col-md-12">
                                    <button type="submit" name="submitin" value="Add" class="btn btn-primary btn-lg shadow-sm">Confirm & Submit Renewal</button>
                                </div>
                            </form>

<div id="visit_schedule_container" style="display:none;">
                                <hr>
                                <h4>Scheduled Visits (Next 12 Visits)</h4>
                                <table class="table table-bordered" id="visit_schedule_table">
                                    <thead>
                                        <tr>
                                            <th>Visit Date</th>
                                            <th>Status</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody></tbody>
                                </table>
                            </div>

</div>
                    </div>
                </div>
            </div>
            <?php include("includes/footer.php"); ?>
        </div>
    </div>

function calculateDates() {
            const signedVal = document.getElementById('signed_date').value;
            const amcType = document.getElementById('amc_type').value;
            const visitFreq = document.getElementById('visit_frequency').value;

if (signedVal) {
                let d = new Date(signedVal);

// 1. Calculate Renewal Date
                let renewal = new Date(d);
                if (amcType == "Yearly") renewal.setFullYear(renewal.getFullYear() + 1);
                else renewal.setMonth(renewal.getMonth() + 6);
                document.getElementById('renewal_date').value = renewal.toISOString().split('T')[0];

// 2. Calculate First Visit Date (Only if no visits are marked done yet)
                const markedDone = tempVisits.filter(v => v.done);
                if (markedDone.length === 0) {
                    let visit = new Date(d);
                    if (visitFreq == "Monthly") visit.setMonth(visit.getMonth() + 1);
                    else visit.setDate(visit.getDate() + 15);
                    document.getElementById('visit_date').value = visit.toISOString().split('T')[0];
                }
            }
        }

function generateVisitTable() {
            const signedVal = document.getElementById('signed_date').value;
            const visitFreq = document.getElementById('visit_frequency').value;
            const container = document.getElementById('visit_schedule_container');
            const tbody = document.querySelector('#visit_schedule_table tbody');
            tbody.innerHTML = '';
            tempVisits = [];

if (!signedVal) {
                container.style.display = 'none';
                return;
            }

let start = new Date(signedVal);
            // Move to first visit cycle
            if (visitFreq == "Monthly") start.setMonth(start.getMonth() + 1);
            else start.setDate(start.getDate() + 15);

for (let i = 0; i < 12; i++) {
                let vdate = new Date(start);
                const dateStr = vdate.toISOString().split('T')[0];

tbody.innerHTML += `<tr>
                <td>${dateStr}</td>
                <td id="status_${i}">Pending</td>
                <td><button type="button" class="btn btn-success btn-sm" id="btn_${i}" onclick="toggleDone(${i}, '${dateStr}')">Mark Done</button></td>
            </tr>`;

if (visitFreq == "Monthly") start.setMonth(start.getMonth() + 1);
                else start.setDate(start.getDate() + 15);

tempVisits.push({
                    date: dateStr,
                    done: false
                });
            }
            container.style.display = 'block';
        }

function toggleDone(index, dateStr) {
            const btn = document.getElementById('btn_' + index);
            const visitFreq = document.getElementById('visit_frequency').value;
            tempVisits[index].done = !tempVisits[index].done;

if (tempVisits[index].done) {
                document.getElementById('status_' + index).innerHTML = '<span class="text-success">Done</span>';
                btn.textContent = 'Undo';
                btn.classList.replace('btn-success', 'btn-warning');
            } else {
                document.getElementById('status_' + index).innerText = 'Pending';
                btn.textContent = 'Mark Done';
                btn.classList.replace('btn-warning', 'btn-success');
            }

// Update the hidden input for form submission
            const completed = tempVisits.filter(v => v.done);
            document.getElementById('temp_visits').value = JSON.stringify(completed);

// --- DYNAMICALLY UPDATE THE "NEXT VISIT DATE" FIELD ---
            if (completed.length > 0) {
                // Find the latest completed visit date
                let lastDoneDate = new Date(completed[completed.length - 1].date);
                // Calculate next visit based on frequency
                if (visitFreq == "Monthly") lastDoneDate.setMonth(lastDoneDate.getMonth() + 1);
                else lastDoneDate.setDate(lastDoneDate.getDate() + 15);

document.getElementById('visit_date').value = lastDoneDate.toISOString().split('T')[0];
            } else {
                // Reset to default calculation if nothing is checked
                calculateDates();
            }
        }

document.addEventListener('DOMContentLoaded', function() {
            if (document.getElementById('signed_date').value != '') {
                calculateDates();
                generateVisitTable();
            }
        });
    </script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addcustomerren.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation