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: viewservicescm.php

<?php
ob_start();
session_start();
include("includes/inall.php");

$heading = "Service History";
$table = "service_calls";
$listpage = "viewservices.php";

/* ================= 1. ASSIGN TECHNICIAN LOGIC ================= */
if (isset($_POST['assign_tech'])) {
    $call_id = mysqli_real_escape_string($con, $_POST['call_id']);
    $job_sheet_no = mysqli_real_escape_string($con, $_POST['job_sheet_no']);
    $tid = mysqli_real_escape_string($con, $_POST['technician_id']);
    $t_name = "";

// If Job Sheet is provided, fetch tech_id from sales_headerbl
    if (!empty($job_sheet_no)) {
        $job_res = mysqli_query($con, "SELECT assigned_tp_id FROM sales_headerbl WHERE sl_unid = '$job_sheet_no' LIMIT 1");
        if (mysqli_num_rows($job_res) > 0) {
            $job_data = mysqli_fetch_assoc($job_res);
            $tid = $job_data['assigned_tp_id'];
        } else {
            $_SESSION['msg_error'] = "Error: Job Sheet No. $job_sheet_no not found in sales records!";
            header("Location: " . $listpage);
            exit();
        }
    }

if (!empty($tid)) {
        $t_res = mysqli_query($con, "SELECT tech_name FROM technicians WHERE id = '$tid'");
        $t_data = mysqli_fetch_assoc($t_res);
        $t_name = $t_data['tech_name'];

mysqli_query($con, "UPDATE `$table` SET 
            tech_id = '$tid', 
            assigned_tech_name = '$t_name', 
            job_sheet_no = '$job_sheet_no', 
            status = 'Assigned' 
            WHERE id = '$call_id'");

$_SESSION['msg'] = "Job assigned to " . $t_name;
    } else {
        $_SESSION['msg_error'] = "Please select a technician or enter a valid Job Sheet No.";
    }

header("Location: " . $listpage);
    exit();
}

/* ================= 2. COMPLETE JOB LOGIC ================= */
if (isset($_GET['complete_id'])) {
    $cid = mysqli_real_escape_string($con, $_GET['complete_id']);
    mysqli_query($con, "UPDATE `$table` SET status = 'Completed', completed_at = NOW() WHERE id = '$cid'");
    $_SESSION['msg'] = "Service Call marked as Completed.";
    header("Location: " . $listpage);
    exit();
}

/* ================= 3. DELETE LOGIC ================= */
if (isset($_GET['delete_id']) && $_SESSION['logtype'] == "superadmin") {
    $did = mysqli_real_escape_string($con, $_GET['delete_id']);
    mysqli_query($con, "DELETE FROM `$table` WHERE id = '$did'");
    $_SESSION['msg'] = "Record deleted successfully.";
    header("Location: " . $listpage);
    exit();
}

/* ================= 4. SEARCH FILTERS ================= */
$where = " WHERE 1=1 and status='Completed'";
if (!empty($_GET['token_no'])) $where .= " AND `token_no` LIKE '%" . mysqli_real_escape_string($con, $_GET['token_no']) . "%'";
if (!empty($_GET['customer_name'])) $where .= " AND `customer_name` LIKE '%" . mysqli_real_escape_string($con, $_GET['customer_name']) . "%'";
if (!empty($_GET['phone'])) $where .= " AND `phone_number` LIKE '%" . mysqli_real_escape_string($con, $_GET['phone']) . "%'";
if (!empty($_GET['location'])) $where .= " AND `location` LIKE '%" . mysqli_real_escape_string($con, $_GET['location']) . "%'";
if (!empty($_GET['fdate']) && !empty($_GET['tdate'])) $where .= " AND `complaint_date` BETWEEN '" . $_GET['fdate'] . "' AND '" . $_GET['tdate'] . "'";

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

<body>
    <div class="page-container">
        <?php include("includes/leftmenu.php"); ?>
        <div class="main-content">
            <?php include("includes/header.php"); ?>
            <div class="main-content-inner">
                <div class="col-lg-12 mt-4">
                    <div class="card">
                        <div class="card-body">
                            <h4 class="header-title">Service Call History</h4>

<form action="<?php echo $listpage; ?>" method="get" class="mb-4 bg-light p-3 border">
                                <div class="row">
                                    <div class="col-md-2"><label>Token No</label><input type="text" name="token_no" class="form-control" value="<?php echo $_GET['token_no'] ?? ''; ?>"></div>
                                    <div class="col-md-2"><label>Customer</label><input type="text" name="customer_name" class="form-control" value="<?php echo $_GET['customer_name'] ?? ''; ?>"></div>
                                    <div class="col-md-2"><label>Phone</label><input type="text" name="phone" class="form-control" value="<?php echo $_GET['phone'] ?? ''; ?>"></div>
                                    <div class="col-md-2"><label>Location</label><input type="text" name="location" class="form-control" value="<?php echo $_GET['location'] ?? ''; ?>"></div>
                                    <div class="col-md-2"><label>From</label><input type="date" name="fdate" class="form-control" value="<?php echo $_GET['fdate'] ?? ''; ?>"></div>
                                    <div class="col-md-2"><label>To</label><input type="date" name="tdate" class="form-control" value="<?php echo $_GET['tdate'] ?? ''; ?>"></div>
                                </div>
                                <div class="row mt-3">
                                    <div class="col-md-12 text-right">
                                        <a href="<?php echo $listpage; ?>" class="btn btn-secondary btn-sm">Reset</a>
                                        <button type="submit" class="btn btn-primary btn-sm">Search</button>
                                    </div>
                                </div>
                            </form>

<?php if (!empty($_SESSION['msg'])) { ?>
                                <div class="alert alert-success alert-dismissible fade show"><?php echo $_SESSION['msg'];
                                                                                                unset($_SESSION['msg']); ?><button type="button" class="close" data-dismiss="alert">&times;</button></div>
                            <?php } ?>
                            <?php if (!empty($_SESSION['msg_error'])) { ?>
                                <div class="alert alert-danger alert-dismissible fade show"><?php echo $_SESSION['msg_error'];
                                                                                            unset($_SESSION['msg_error']); ?><button type="button" class="close" data-dismiss="alert">&times;</button></div>
                            <?php } ?>

<div class="table-responsive">
                                <table class="table table-hover border text-center">
                                    <thead class="bg-dark text-white">
                                        <tr>
                                            <th>Token No</th>
                                            <th style="text-align: left;">Customer Details</th>
                                            <th style="text-align: left;">Complaint</th>
                                            <th>Technician / Job Sheet</th>
                                            <th>Status</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $modals = "";
                                        $res = mysqli_query($con, "SELECT * FROM `$table` $where ORDER BY id DESC");
                                        if (mysqli_num_rows($res) > 0) {
                                            while ($row = mysqli_fetch_assoc($res)) {
                                                $badge = ($row['status'] == 'Completed') ? "badge-success" : (($row['status'] == 'Assigned') ? "badge-warning" : "badge-danger");
                                                $source_icon = ($row['entry_by'] == 'Customer') ? '<i class="fa fa-globe text-primary" title="Web Request"></i>' : '<i class="fa fa-user-circle text-muted" title="Staff Entry"></i>';
                                        ?>
                                                <tr>
                                                    <td><b class="text-primary"><?php echo $row['token_no']; ?></b><br><?php echo $source_icon; ?></td>
                                                    <td class="text-left">
                                                        <b><?php echo $row['customer_name']; ?></b><br>
                                                        <small><?php echo $row['phone_number']; ?></small><br>
                                                        <small class="text-muted"><?php echo $row['location']; ?></small>
                                                        (<small>Done by <?php echo $row['entry_by']; ?></small>)
                                                    </td>
                                                    <td class="text-left">
                                                        <small><?php echo date('d-M-y', strtotime($row['complaint_date'])); ?></small><br>
                                                        <span class="small font-weight-bold"><?php echo $row['complaint_type']; ?></span>
                                                    </td>
                                                    <td>
                                                        <?php
                                                        if (!empty($row['assigned_tech_name'])) {
                                                            echo '<span class="text-info font-weight-bold">' . $row['assigned_tech_name'] . '</span>';
                                                            if (!empty($row['job_sheet_no'])) echo '<br><small class="badge badge-light">JS: ' . $row['job_sheet_no'] . '</small>';
                                                        } else {
                                                            echo '<i class="text-muted">Unassigned</i>';
                                                        }
                                                        ?>
                                                    </td>
                                                    <td>
                                                        <span class="badge <?php echo $badge; ?> p-2"><?php echo $row['status']; ?></span>
                                                        <?php
                                                        if ($row['status'] == 'Completed' && !empty($row['completed_at'])) {
                                                            echo '<br><small class="text-success">' . date('d-M-Y H:i', strtotime($row['completed_at'])) . '</small>';
                                                        }
                                                        ?>
                                                    </td>

<td>
                                                        <?php if ($row['status'] == 'Pending') { ?>
                                                            <button type="button" class="btn btn-xs btn-info" data-toggle="modal" data-target="#assignModal<?php echo $row['id']; ?>"><i class="fa fa-user-plus"></i> Assign</button>
                                                        <?php } elseif ($row['status'] == 'Assigned') { ?>
                                                            <a href="<?php echo $listpage; ?>?complete_id=<?php echo $row['id']; ?>" class="btn btn-xs btn-success" onclick="return confirm('Complete this job?')"><i class="fa fa-check"></i> Complete</a>
                                                        <?php } ?>

<?php if ($_SESSION['logtype'] == "superadmin") { ?>
                                                            <a href="<?php echo $listpage; ?>?delete_id=<?php echo $row['id']; ?>" class="btn btn-xs btn-link text-danger" onclick="return confirm('Delete?')"><i class="fa fa-trash"></i></a>
                                                        <?php } ?>
                                                    </td>
                                                </tr>
                                        <?php
                                                $modals .= '
                                        <div class="modal fade" id="assignModal' . $row['id'] . '" tabindex="-1" role="dialog">
                                            <div class="modal-dialog modal-dialog-centered">
                                                <form method="post" class="modal-content text-left">
                                                    <div class="modal-header bg-info text-white">
                                                        <h5 class="modal-title">Assign Token: ' . $row['token_no'] . '</h5>
                                                        <button type="button" class="close text-white" data-dismiss="modal"><span>&times;</span></button>
                                                    </div>
                                                    <div class="modal-body">
                                                        <input type="hidden" name="call_id" value="' . $row['id'] . '">
                                                        
                                                        <div class="form-group">
                                                            <label class="text-primary font-weight-bold">Option 1: Link to Job Sheet</label>
                                                            <input type="text" name="job_sheet_no" class="form-control" placeholder="Enter Job Sheet Number">
                                                            <small class="text-muted">Will auto-assign tech from Sales records.</small>
                                                        </div>

<div class="form-group">
                                                            <label class="text-primary font-weight-bold">Option 2: Select Technician</label>
                                                            <select name="technician_id" class="form-control">
                                                                <option value="">-- Manual Selection --</option>';
                                                $t_query = mysqli_query($con, "SELECT id, tech_name FROM technicians WHERE status='1'");
                                                while ($t = mysqli_fetch_assoc($t_query)) {
                                                    $modals .= "<option value='" . $t['id'] . "'>" . $t['tech_name'] . "</option>";
                                                }
                                                $modals .= '        </select>
                                                        </div>
                                                    </div>
                                                    <div class="modal-footer">
                                                        <button type="submit" name="assign_tech" class="btn btn-info btn-block">Confirm Assignment</button>
                                                    </div>
                                                </form>
                                            </div>
                                        </div>';
                                            }
                                        } else {
                                            echo "<tr><td colspan='6' class='p-5'>No records found.</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<?php echo $modals; ?>
        <?php include("includes/footer.php"); ?>
    </div>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewservicescm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation