File "service_request_dashboard.php"

Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/service_request_dashboard.php
File size: 10.36 KB
MIME-type: text/x-php
Charset: utf-8

<?php
// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Database connection
$conn = new mysqli("server329", "leadltht_prazey1982", "prazey1982123456", "leadltht_fastlinkinternet");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Initialize counts
$installation_count = $installation_assignment_count = $completed_installation_count = 0;
$repair_count = $repair_assignment_count = $completed_repair_count = 0;
$payment_proof_pending_count = $payment_proof_declined_count = $payment_proof_approved_count = 0;

// Fetch counts for installation requests
$installation_count_sql = "SELECT COUNT(*) as count FROM installation_request WHERE status = 'Pending'";
$installation_count_result = $conn->query($installation_count_sql);
if ($installation_count_result) {
    $installation_count = $installation_count_result->fetch_assoc()['count'];
}

// Fetch counts for assigned installation requests
$installation_assignment_count_sql = "SELECT COUNT(*) as count FROM installation_request WHERE status = 'Assigned'";
$installation_assignment_count_result = $conn->query($installation_assignment_count_sql);
if ($installation_assignment_count_result) {
    $installation_assignment_count = $installation_assignment_count_result->fetch_assoc()['count'];
}

// Fetch counts for completed installation requests
$completed_installation_count_sql = "SELECT COUNT(*) as count FROM installation_request WHERE status = 'Completed'";
$completed_installation_count_result = $conn->query($completed_installation_count_sql);
if ($completed_installation_count_result) {
    $completed_installation_count = $completed_installation_count_result->fetch_assoc()['count'];
}

// Fetch counts for repair requests
$repair_count_sql = "SELECT COUNT(*) as count FROM client_complaint WHERE status = 'Pending'";
$repair_count_result = $conn->query($repair_count_sql);
if ($repair_count_result) {
    $repair_count = $repair_count_result->fetch_assoc()['count'];
}

// Fetch counts for assigned repair requests
$repair_assignment_count_sql = "SELECT COUNT(*) as count FROM client_complaint WHERE status = 'Opened'";
$repair_assignment_count_result = $conn->query($repair_assignment_count_sql);
if ($repair_assignment_count_result) {
    $repair_assignment_count = $repair_assignment_count_result->fetch_assoc()['count'];
}

// Fetch counts for completed repair requests
$completed_repair_count_sql = "SELECT COUNT(*) as count FROM client_complaint WHERE status = 'Closed'";
$completed_repair_count_result = $conn->query($completed_repair_count_sql);
if ($completed_repair_count_result) {
    $completed_repair_count = $completed_repair_count_result->fetch_assoc()['count'];
}

// Fetch counts for pending payment proofs
$payment_proof_pending_count_sql = "SELECT COUNT(*) as count FROM pop WHERE Status = 'Pending'";
$payment_proof_pending_count_result = $conn->query($payment_proof_pending_count_sql);
if ($payment_proof_pending_count_result) {
    $payment_proof_pending_count = $payment_proof_pending_count_result->fetch_assoc()['count'];
}

// Fetch counts for declined payment proofs
$payment_proof_declined_count_sql = "SELECT COUNT(*) as count FROM pop WHERE Status = 'Declined'";
$payment_proof_declined_count_result = $conn->query($payment_proof_declined_count_sql);
if ($payment_proof_declined_count_result) {
    $payment_proof_declined_count = $payment_proof_declined_count_result->fetch_assoc()['count'];
}

// Fetch counts for approved payment proofs
$payment_proof_approved_count_sql = "SELECT COUNT(*) as count FROM pop WHERE Status = 'Approved'";
$payment_proof_approved_count_result = $conn->query($payment_proof_approved_count_sql);
if ($payment_proof_approved_count_result) {
    $payment_proof_approved_count = $payment_proof_approved_count_result->fetch_assoc()['count'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Service Request Dashboard</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
    <style>
        .large-number {
            font-size: 4.5rem;
            font-weight: bold;
            display: inline-block;
        }
        .large-number a {
            color: #fff;
            text-decoration: none;
        }
    </style>
</head>
<body>
<div class="container mt-5">
    <h2 class="mb-4">Service Request Dashboard</h2>
    <div class="row">
        <div class="col-md-4">
            <div class="card text-white bg-primary mb-3">
                <div class="card-header">Installation Requests</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=installation_request"><?php echo $installation_count; ?></a>
                    </h5>
                    <p class="card-text">Total installation requests received.</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card text-white bg-info mb-3">
                <div class="card-header">Assigned Installations</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=installation_assignment"><?php echo $installation_assignment_count; ?></a>
                    </h5>
                    <p class="card-text">Total installation requests assigned.</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Installations Completed</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=completed_installation_request"><?php echo $completed_installation_count; ?></a>
                    </h5>
                    <p class="card-text">Total installations completed.</p>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-4">
            <div class="card text-white bg-primary mb-3">
                <div class="card-header">Repair Requests</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=repair_request"><?php echo $repair_count; ?></a>
                    </h5>
                    <p class="card-text">Total repair requests received.</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card text-white bg-info mb-3">
                <div class="card-header">Assigned Repairs</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=repair_assignment"><?php echo $repair_assignment_count; ?></a>
                    </h5>
                    <p class="card-text">Total repair requests assigned.</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Repairs Completed</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=completed_repair_request"><?php echo $completed_repair_count; ?></a>
                    </h5>
                    <p class="card-text">Total repairs completed.</p>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <?php if ($_SESSION['userdata']['type'] != 2): ?>
<div class="col-md-4">
    <div class="card text-white bg-warning mb-3">
        <div class="card-header">Pending Payment Proofs</div>
        <div class="card-body">
            <h5 class="card-title large-number">
                <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=payment_proof"><?php echo $payment_proof_pending_count; ?></a>
            </h5>
            <p class="card-text">Total payment proofs received and for approval.</p>
        </div>
    </div>
</div>
<?php endif; ?>
        <?php if ($_SESSION['userdata']['type'] != 2): ?>
        <div class="col-md-4">
            <div class="card text-white bg-danger mb-3">
                <div class="card-header">Declined Payment Proofs</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=declined_payment_proof"><?php echo $payment_proof_declined_count; ?></a>
                    </h5>
                    <p class="card-text">Total declined payment proofs.</p>
                </div>
            </div>
        </div>
        <?php endif; ?>
        <?php if ($_SESSION['userdata']['type'] != 2): ?>
        <div class="col-md-4">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Approved Payment Proofs</div>
                <div class="card-body">
                    <h5 class="card-title large-number">
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=approved_payment_proof"><?php echo $payment_proof_approved_count; ?></a>
                    </h5>
                    <p class="card-text">Total approved payment proofs.</p>
                </div>
            </div>
        </div>
        <?php endif; ?>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</body>
</html>

<?php
$conn->close();
?>