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/vkmobiles/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: jobcard-details.php

<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

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

<?php
                // Include database connection
                include('includes/db.php');

// Function to log activities
                function logActivity($conn, $activity_type, $description, $related_id = null, $related_table = null) {
                    $user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
                    $ip_address = $_SERVER['REMOTE_ADDR'];
                    $user_agent = $_SERVER['HTTP_USER_AGENT'];
                    
                    $stmt = $conn->prepare("INSERT INTO activity_logs (user_id, activity_type, description, related_id, related_table, ip_address, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)");
                    $stmt->bind_param("ississs", $user_id, $activity_type, $description, $related_id, $related_table, $ip_address, $user_agent);
                    $stmt->execute();
                    $stmt->close();
                }

// Check if job card ID is provided
                if (!isset($_GET['id']) || empty($_GET['id'])) {
                    echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>Job Card ID is required!
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    include('includes/footer.php');
                    exit();
                }

$jobcard_id = intval($_GET['id']);

// Fetch job card details
                $sql = "SELECT * FROM service_jobcards WHERE id = $jobcard_id";
                $result = $conn->query($sql);

if ($result->num_rows == 0) {
                    echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>Job Card not found!
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    include('includes/footer.php');
                    exit();
                }

$jobcard = $result->fetch_assoc();

// Handle status update
                if (isset($_POST['update_status'])) {
                    $new_status = $conn->real_escape_string($_POST['status']);
                    $technician_notes = $conn->real_escape_string($_POST['technician_notes']);
                    $actual_cost = $conn->real_escape_string($_POST['actual_cost']);
                    
                    // If status is completed, set completed_at timestamp
                    $completed_at_sql = "";
                    if ($new_status == 'completed' && $jobcard['status'] != 'completed') {
                        $completed_at_sql = ", completed_at = NOW()";
                    }
                    
                    $sql = "UPDATE service_jobcards SET 
                            status = '$new_status',
                            technician_notes = '$technician_notes',
                            actual_cost = '$actual_cost'
                            $completed_at_sql
                            WHERE id = $jobcard_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card status updated to: $new_status", $jobcard_id, 'service_jobcards');
                        
                        // Refresh job card data
                        $result = $conn->query("SELECT * FROM service_jobcards WHERE id = $jobcard_id");
                        $jobcard = $result->fetch_assoc();
                        
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>Job card status updated successfully!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error updating job card: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle cost update
                if (isset($_POST['update_cost'])) {
                    $estimated_cost = $conn->real_escape_string($_POST['estimated_cost']);
                    $advance_payment = $conn->real_escape_string($_POST['advance_payment']);
                    $actual_cost = $conn->real_escape_string($_POST['actual_cost']);
                    
                    $sql = "UPDATE service_jobcards SET 
                            estimated_cost = '$estimated_cost',
                            advance_payment = '$advance_payment',
                            actual_cost = '$actual_cost'
                            WHERE id = $jobcard_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card costs updated", $jobcard_id, 'service_jobcards');
                        
                        // Refresh job card data
                        $result = $conn->query("SELECT * FROM service_jobcards WHERE id = $jobcard_id");
                        $jobcard = $result->fetch_assoc();
                        
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>Cost details updated successfully!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error updating cost details: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle service completion
                if (isset($_POST['complete_service'])) {
                    $final_cost = $conn->real_escape_string($_POST['final_cost']);
                    $payment_received = $conn->real_escape_string($_POST['payment_received']);
                    $service_notes = $conn->real_escape_string($_POST['service_notes']);
                    
                    $sql = "UPDATE service_jobcards SET 
                            status = 'completed',
                            actual_cost = '$final_cost',
                            payment_received = '$payment_received',
                            service_notes = '$service_notes',
                            completed_at = NOW()
                            WHERE id = $jobcard_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card completed and delivered", $jobcard_id, 'service_jobcards');
                        
                        // Refresh job card data
                        $result = $conn->query("SELECT * FROM service_jobcards WHERE id = $jobcard_id");
                        $jobcard = $result->fetch_assoc();
                        
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>Service marked as completed!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error completing service: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle delivery with payment collection
                if (isset($_POST['mark_delivered'])) {
                    $total_amount_collected = $conn->real_escape_string($_POST['total_amount_collected']);
                    $payment_method = $conn->real_escape_string($_POST['payment_method']);
                    $payment_notes = $conn->real_escape_string($_POST['payment_notes']);
                    
                    // Calculate balance amount to collect
                    $balance_to_collect = $jobcard['actual_cost'] - $jobcard['advance_payment'];
                    $remaining_balance = $balance_to_collect - $total_amount_collected;
                    
                    // Update job card with delivery status and final payment
                    $sql = "UPDATE service_jobcards SET 
                            status = 'delivered',
                            payment_received = payment_received + $total_amount_collected,
                            service_notes = CONCAT(COALESCE(service_notes, ''), '\n\n--- Delivery Payment ---\nAmount Collected: ₹$total_amount_collected\nPayment Method: $payment_method\nNotes: $payment_notes\nDelivery Date: " . date('Y-m-d H:i:s') . "'),
                            updated_at = NOW()
                            WHERE id = $jobcard_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card delivered. Amount collected: ₹$total_amount_collected", $jobcard_id, 'service_jobcards');
                        
                        // Refresh job card data
                        $result = $conn->query("SELECT * FROM service_jobcards WHERE id = $jobcard_id");
                        $jobcard = $result->fetch_assoc();
                        
                        $message = 'Job card marked as delivered successfully!';
                        if ($remaining_balance > 0) {
                            $message .= " Balance amount of ₹" . number_format($remaining_balance, 2) . " is still pending.";
                        } else if ($remaining_balance == 0) {
                            $message .= " All payments have been collected.";
                        } else {
                            $message .= " Note: Excess amount of ₹" . number_format(abs($remaining_balance), 2) . " was collected.";
                        }
                        
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>' . $message . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error marking as delivered: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }
                ?>

<div class="row">
                    <div class="col-12">
                        
                        <div class="card">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-8">
                                        <div class="d-flex align-items-center">
                                            <div class="flex-shrink-0">
                                                <div class="avatar-lg bg-light rounded-circle">
                                                    <span class="avatar-title text-primary fw-bold display-6">
                                                        <?php echo strtoupper(substr($jobcard['customer_name'], 0, 1)); ?>
                                                    </span>
                                                </div>
                                            </div>
                                            <div class="flex-grow-1 ms-3">
                                                <h4 class="card-title mb-1"><?php echo htmlspecialchars($jobcard['customer_name']); ?></h4>
                                                <p class="text-muted mb-1">Job Card: <strong><?php echo htmlspecialchars($jobcard['jobcard_number']); ?></strong></p>
                                                <p class="text-muted mb-0">
                                                    <i class="fas fa-phone me-1"></i><?php echo htmlspecialchars($jobcard['customer_phone']); ?>
                                                    <?php if (!empty($jobcard['customer_email'])): ?>
                                                        | <i class="fas fa-envelope me-1"></i><?php echo htmlspecialchars($jobcard['customer_email']); ?>
                                                    <?php endif; ?>
                                                </p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="text-md-end">
                                            <?php
                                            $status_badge = [
                                                'pending' => 'warning',
                                                'in_progress' => 'info', 
                                                'completed' => 'success',
                                                'delivered' => 'primary',
                                                'cancelled' => 'danger'
                                            ];
                                            ?>
                                            <span class="badge bg-<?php echo $status_badge[$jobcard['status']]; ?> fs-6 mb-2">
                                                <?php echo ucfirst(str_replace('_', ' ', $jobcard['status'])); ?>
                                            </span>
                                            <div class="mt-2">
                                                <button type="button" class="btn btn-outline-primary me-2" onclick="printJobcard()">
                                                    <i class="fas fa-print me-1"></i>Print
                                                </button>
                                                <a href="service-jobcard.php" class="btn btn-outline-secondary">
                                                    <i class="fas fa-arrow-left me-1"></i>Back to List
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="row">
                            
                            <div class="col-lg-8">
                                
                                <div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-mobile-alt me-2"></i>Device Information
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="row">
                                            <div class="col-md-6">
                                                <table class="table table-borderless">
                                                    <tr>
                                                        <td width="40%"><strong>Device Type:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['device_type']); ?></td>
                                                    </tr>
                                                    <tr>
                                                        <td><strong>Brand:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['brand']); ?></td>
                                                    </tr>
                                                    <tr>
                                                        <td><strong>Model:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['model']); ?></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="col-md-6">
                                                <table class="table table-borderless">
                                                    <?php if (!empty($jobcard['imei_number'])): ?>
                                                    <tr>
                                                        <td width="40%"><strong>IMEI Number:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['imei_number']); ?></td>
                                                    </tr>
                                                    <?php endif; ?>
                                                    <?php if (!empty($jobcard['serial_number'])): ?>
                                                    <tr>
                                                        <td><strong>Serial Number:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['serial_number']); ?></td>
                                                    </tr>
                                                    <?php endif; ?>
                                                    <tr>
                                                        <td><strong>Condition:</strong></td>
                                                        <td><?php echo !empty($jobcard['device_condition']) ? htmlspecialchars($jobcard['device_condition']) : 'N/A'; ?></td>
                                                    </tr>
                                                </table>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-tools me-2"></i>Service Details
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="mb-3">
                                            <label class="form-label"><strong>Reported Problem:</strong></label>
                                            <div class="border rounded p-3 bg-light">
                                                <?php echo nl2br(htmlspecialchars($jobcard['device_problem'])); ?>
                                            </div>
                                        </div>
                                        
                                        <?php if (!empty($jobcard['accessories'])): ?>
                                        <div class="mb-3">
                                            <label class="form-label"><strong>Accessories Received:</strong></label>
                                            <div class="border rounded p-3 bg-light">
                                                <?php echo htmlspecialchars($jobcard['accessories']); ?>
                                            </div>
                                        </div>
                                        <?php endif; ?>

<?php if (!empty($jobcard['technician_notes'])): ?>
                                        <div class="mb-3">
                                            <label class="form-label"><strong>Technician Notes:</strong></label>
                                            <div class="border rounded p-3 bg-light">
                                                <?php echo nl2br(htmlspecialchars($jobcard['technician_notes'])); ?>
                                            </div>
                                        </div>
                                        <?php endif; ?>

<?php if (!empty($jobcard['service_notes'])): ?>
                                        <div class="mb-3">
                                            <label class="form-label"><strong>Service Notes:</strong></label>
                                            <div class="border rounded p-3 bg-light">
                                                <?php echo nl2br(htmlspecialchars($jobcard['service_notes'])); ?>
                                            </div>
                                        </div>
                                        <?php endif; ?>
                                    </div>
                                </div>

<div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-user me-2"></i>Customer Information
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="row">
                                            <div class="col-md-6">
                                                <table class="table table-borderless">
                                                    <tr>
                                                        <td width="40%"><strong>Name:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['customer_name']); ?></td>
                                                    </tr>
                                                    <tr>
                                                        <td><strong>Phone:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['customer_phone']); ?></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="col-md-6">
                                                <table class="table table-borderless">
                                                    <?php if (!empty($jobcard['customer_email'])): ?>
                                                    <tr>
                                                        <td width="40%"><strong>Email:</strong></td>
                                                        <td><?php echo htmlspecialchars($jobcard['customer_email']); ?></td>
                                                    </tr>
                                                    <?php endif; ?>
                                                    <tr>
                                                        <td><strong>Address:</strong></td>
                                                        <td><?php echo !empty($jobcard['customer_address']) ? nl2br(htmlspecialchars($jobcard['customer_address'])) : 'N/A'; ?></td>
                                                    </tr>
                                                </table>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

<div class="col-lg-4">
                                
                                <div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-bolt me-2"></i>Quick Actions
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="d-grid gap-2">
                                            <button type="button" class="btn btn-outline-primary" data-bs-toggle="modal" data-bs-target="#updateStatusModal">
                                                <i class="fas fa-edit me-1"></i>Update Status
                                            </button>
                                            
                                            <?php if ($jobcard['status'] != 'completed' && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled'): ?>
                                            <button type="button" class="btn btn-outline-warning" data-bs-toggle="modal" data-bs-target="#updateCostModal">
                                                <i class="fas fa-money-bill me-1"></i>Update Costs
                                            </button>
                                            <?php endif; ?>
                                            
                                            <?php if ($jobcard['status'] == 'completed'): ?>
                                            <button type="button" class="btn btn-outline-success" data-bs-toggle="modal" data-bs-target="#markDeliveredModal">
                                                <i class="fas fa-truck me-1"></i>Mark as Delivered
                                            </button>
                                            <?php endif; ?>
                                            
                                            <?php if ($jobcard['status'] != 'completed' && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled'): ?>
                                            <button type="button" class="btn btn-outline-info" data-bs-toggle="modal" data-bs-target="#completeServiceModal">
                                                <i class="fas fa-check-circle me-1"></i>Complete Service
                                            </button>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                </div>

<div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-money-bill-wave me-2"></i>Cost Summary
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <table class="table table-sm">
                                            <tr>
                                                <td><strong>Estimated Cost:</strong></td>
                                                <td class="text-end">₹<?php echo number_format($jobcard['estimated_cost'], 2); ?></td>
                                            </tr>
                                            <tr>
                                                <td><strong>Advance Paid:</strong></td>
                                                <td class="text-end text-success">₹<?php echo number_format($jobcard['advance_payment'], 2); ?></td>
                                            </tr>
                                            <?php if (!empty($jobcard['actual_cost'])): ?>
                                            <tr>
                                                <td><strong>Actual Cost:</strong></td>
                                                <td class="text-end text-primary">₹<?php echo number_format($jobcard['actual_cost'], 2); ?></td>
                                            </tr>
                                            <?php endif; ?>
                                            <?php if (!empty($jobcard['payment_received'])): ?>
                                            <tr>
                                                <td><strong>Total Received:</strong></td>
                                                <td class="text-end text-success">₹<?php echo number_format($jobcard['payment_received'], 2); ?></td>
                                            </tr>
                                            <?php endif; ?>
                                            <tr class="table-active">
                                                <td><strong>Balance Due:</strong></td>
                                                <td class="text-end text-danger">
                                                    ₹<?php 
                                                    $balance_due = $jobcard['actual_cost'] - $jobcard['payment_received'];
                                                    echo number_format(max(0, $balance_due), 2); 
                                                    ?>
                                                </td>
                                            </tr>
                                            <?php if ($jobcard['status'] == 'completed'): ?>
                                            <tr class="table-warning">
                                                <td><strong>Amount to Collect:</strong></td>
                                                <td class="text-end fw-bold text-danger">
                                                    ₹<?php 
                                                    $amount_to_collect = $jobcard['actual_cost'] - $jobcard['advance_payment'];
                                                    echo number_format(max(0, $amount_to_collect), 2); 
                                                    ?>
                                                </td>
                                            </tr>
                                            <?php endif; ?>
                                        </table>
                                    </div>
                                </div>

<div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">
                                            <i class="fas fa-history me-2"></i>Timeline
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <div class="timeline">
                                            <div class="timeline-item <?php echo $jobcard['status'] == 'pending' ? 'active' : 'completed'; ?>">
                                                <div class="timeline-marker"></div>
                                                <div class="timeline-content">
                                                    <h6 class="mb-1">Job Card Created</h6>
                                                    <small class="text-muted"><?php echo date('M j, Y g:i A', strtotime($jobcard['created_at'])); ?></small>
                                                </div>
                                            </div>
                                            
                                            <?php if ($jobcard['status'] == 'in_progress' || $jobcard['status'] == 'completed' || $jobcard['status'] == 'delivered'): ?>
                                            <div class="timeline-item <?php echo $jobcard['status'] == 'in_progress' ? 'active' : 'completed'; ?>">
                                                <div class="timeline-marker"></div>
                                                <div class="timeline-content">
                                                    <h6 class="mb-1">In Progress</h6>
                                                    <small class="text-muted">Repair work started</small>
                                                </div>
                                            </div>
                                            <?php endif; ?>
                                            
                                            <?php if ($jobcard['status'] == 'completed' || $jobcard['status'] == 'delivered'): ?>
                                            <div class="timeline-item <?php echo $jobcard['status'] == 'completed' ? 'active' : 'completed'; ?>">
                                                <div class="timeline-marker"></div>
                                                <div class="timeline-content">
                                                    <h6 class="mb-1">Completed</h6>
                                                    <small class="text-muted">
                                                        <?php echo $jobcard['completed_at'] ? date('M j, Y g:i A', strtotime($jobcard['completed_at'])) : 'Date not available'; ?>
                                                    </small>
                                                </div>
                                            </div>
                                            <?php endif; ?>
                                            
                                            <?php if ($jobcard['status'] == 'delivered'): ?>
                                            <div class="timeline-item active">
                                                <div class="timeline-marker"></div>
                                                <div class="timeline-content">
                                                    <h6 class="mb-1">Delivered</h6>
                                                    <small class="text-muted">Device returned to customer</small>
                                                </div>
                                            </div>
                                            <?php endif; ?>
                                            
                                            <?php if ($jobcard['status'] == 'cancelled'): ?>
                                            <div class="timeline-item active">
                                                <div class="timeline-marker bg-danger"></div>
                                                <div class="timeline-content">
                                                    <h6 class="mb-1">Cancelled</h6>
                                                    <small class="text-muted">Job card cancelled</small>
                                                </div>
                                            </div>
                                            <?php endif; ?>
                                        </div>
                                        
                                        <?php if ($jobcard['estimated_delivery']): ?>
                                        <div class="mt-3 p-3 bg-light rounded">
                                            <small class="text-muted">
                                                <i class="fas fa-calendar me-1"></i>
                                                <strong>Estimated Delivery:</strong> 
                                                <?php echo date('M j, Y', strtotime($jobcard['estimated_delivery'])); ?>
                                                
                                                <?php
                                                $today = date('Y-m-d');
                                                $delivery_date = date('Y-m-d', strtotime($jobcard['estimated_delivery']));
                                                $days_remaining = floor((strtotime($delivery_date) - strtotime($today)) / (60 * 60 * 24));
                                                
                                                if ($days_remaining > 0 && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled') {
                                                    echo '<span class="badge bg-info ms-2">' . $days_remaining . ' days remaining</span>';
                                                } elseif ($days_remaining < 0 && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled') {
                                                    echo '<span class="badge bg-danger ms-2">Overdue by ' . abs($days_remaining) . ' days</span>';
                                                } elseif ($days_remaining == 0 && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled') {
                                                    echo '<span class="badge bg-warning ms-2">Due today</span>';
                                                }
                                                ?>
                                            </small>
                                        </div>
                                        <?php endif; ?>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

<?php include('includes/rightbar.php')?>

<div class="modal fade" id="updateStatusModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Update Job Card Status</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 for="status" class="form-label">Status <span class="text-danger">*</span></label>
                        <select class="form-select" id="status1" name="status" required>
                            <option value="pending" <?php echo $jobcard['status'] == 'pending' ? 'selected' : ''; ?>>Pending</option>
                            <option value="in_progress" <?php echo $jobcard['status'] == 'in_progress' ? 'selected' : ''; ?>>In Progress</option>
                            <option value="completed" <?php echo $jobcard['status'] == 'completed' ? 'selected' : ''; ?>>Completed</option>
                            <option value="delivered" <?php echo $jobcard['status'] == 'delivered' ? 'selected' : ''; ?>>Delivered</option>
                            <option value="cancelled" <?php echo $jobcard['status'] == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label for="technician_notes" class="form-label">Technician Notes</label>
                        <textarea class="form-control" id="technician_notes" name="technician_notes" rows="3" placeholder="Add any technical notes or updates..."><?php echo htmlspecialchars($jobcard['technician_notes']); ?></textarea>
                    </div>
                    <div class="mb-3">
                        <label for="actual_cost" class="form-label">Actual Cost (₹)</label>
                        <input type="number" class="form-control" id="actual_cost" name="actual_cost" step="0.01" min="0" value="<?php echo $jobcard['actual_cost']; ?>">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_status" class="btn btn-primary">Update Status</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="updateCostModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Update Cost Details</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 for="estimated_cost" class="form-label">Estimated Cost (₹)</label>
                        <input type="number" class="form-control" id="estimated_cost" name="estimated_cost" step="0.01" min="0" value="<?php echo $jobcard['estimated_cost']; ?>">
                    </div>
                    <div class="mb-3">
                        <label for="advance_payment" class="form-label">Advance Payment (₹)</label>
                        <input type="number" class="form-control" id="advance_payment" name="advance_payment" step="0.01" min="0" value="<?php echo $jobcard['advance_payment']; ?>">
                    </div>
                    <div class="mb-3">
                        <label for="actual_cost" class="form-label">Actual Cost (₹)</label>
                        <input type="number" class="form-control" id="actual_cost" name="actual_cost" step="0.01" min="0" value="<?php echo $jobcard['actual_cost']; ?>">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_cost" class="btn btn-primary">Update Costs</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="completeServiceModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Complete Service</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 for="final_cost" class="form-label">Final Cost (₹) <span class="text-danger">*</span></label>
                        <input type="number" class="form-control" id="final_cost" name="final_cost" step="0.01" min="0" value="<?php echo $jobcard['actual_cost'] ?: $jobcard['estimated_cost']; ?>" required>
                    </div>
                    <div class="mb-3">
                        <label for="payment_received" class="form-label">Payment Received (₹)</label>
                        <input type="number" class="form-control" id="payment_received" name="payment_received" step="0.01" min="0" value="<?php echo $jobcard['payment_received']; ?>">
                    </div>
                    <div class="mb-3">
                        <label for="service_notes" class="form-label">Service Notes</label>
                        <textarea class="form-control" id="service_notes" name="service_notes" rows="3" placeholder="Add final service notes..."><?php echo htmlspecialchars($jobcard['service_notes']); ?></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="complete_service" class="btn btn-success">Complete Service</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="markDeliveredModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Mark as Delivered - Collect Payment</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="fas fa-info-circle me-2"></i>
                        This will mark the job card as delivered and collect the remaining payment.
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label"><strong>Payment Summary</strong></label>
                        <table class="table table-sm table-bordered">
                            <tr>
                                <td>Actual Cost:</td>
                                <td class="text-end">₹<?php echo number_format($jobcard['actual_cost'], 2); ?></td>
                            </tr>
                            <tr>
                                <td>Advance Paid:</td>
                                <td class="text-end text-success">- ₹<?php echo number_format($jobcard['advance_payment'], 2); ?></td>
                            </tr>
                            <tr class="table-warning">
                                <td><strong>Amount to Collect:</strong></td>
                                <td class="text-end fw-bold text-danger">
                                    ₹<?php 
                                    $amount_to_collect = $jobcard['actual_cost'] - $jobcard['advance_payment'];
                                    echo number_format(max(0, $amount_to_collect), 2); 
                                    ?>
                                </td>
                            </tr>
                        </table>
                    </div>
                    
                    <div class="mb-3">
                        <label for="total_amount_collected" class="form-label">Amount Collected (₹) <span class="text-danger">*</span></label>
                        <input type="number" class="form-control" id="total_amount_collected" name="total_amount_collected" 
                               step="0.01" min="0" max="<?php echo $amount_to_collect; ?>" 
                               value="<?php echo $amount_to_collect; ?>" required>
                        <div class="form-text">Enter the amount collected from customer</div>
                    </div>
                    
                    <div class="mb-3">
                        <label for="payment_method" class="form-label">Payment Method</label>
                        <select class="form-select" id="payment_method" name="payment_method">
                            <option value="cash">Cash</option>
                            <option value="card">Card</option>
                            <option value="upi">UPI</option>
                            <option value="bank_transfer">Bank Transfer</option>
                        </select>
                    </div>
                    
                    <div class="mb-3">
                        <label for="payment_notes" class="form-label">Payment Notes</label>
                        <textarea class="form-control" id="payment_notes" name="payment_notes" rows="2" placeholder="Any notes about the payment..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="mark_delivered" class="btn btn-success">Collect Payment & Mark Delivered</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/scripts.php')?>

// Auto-focus on first input in modals
document.addEventListener('DOMContentLoaded', function() {
    var updateStatusModal = document.getElementById('updateStatusModal');
    if (updateStatusModal) {
        updateStatusModal.addEventListener('shown.bs.modal', function () {
            document.getElementById('status').focus();
        });
    }
    
    // Auto-calculate amount to collect in delivery modal
    var markDeliveredModal = document.getElementById('markDeliveredModal');
    if (markDeliveredModal) {
        markDeliveredModal.addEventListener('shown.bs.modal', function () {
            var amountToCollect = <?php echo $amount_to_collect; ?>;
            document.getElementById('total_amount_collected').value = amountToCollect;
            document.getElementById('total_amount_collected').focus();
        });
    }
});

// Validate amount collected doesn't exceed amount to collect
document.getElementById('total_amount_collected')?.addEventListener('input', function() {
    var amountToCollect = <?php echo $amount_to_collect; ?>;
    var collectedAmount = parseFloat(this.value) || 0;
    
    if (collectedAmount > amountToCollect) {
        this.setCustomValidity('Collected amount cannot exceed amount to collect (₹' + amountToCollect.toFixed(2) + ')');
    } else {
        this.setCustomValidity('');
    }
});
</script>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: jobcard-details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation