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/footwear

Free Space:

10.16 TB

🔧 Quick Actions

✏️ Editing: view-supplier.php

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

<?php 
include('includes/head.php'); 
include('includes/db.php');

// Start session
session_start();

// Check if user is logged in and is admin
if (!isset($_SESSION['user_id']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: user-login.php");
    exit();
}

// Get supplier ID
$supplier_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

if ($supplier_id <= 0) {
    header("Location: manage-suppliers.php?msg=Invalid supplier ID&type=danger");
    exit();
}

// Fetch supplier details
$sql = "SELECT * FROM suppliers WHERE id = ?";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, "i", $supplier_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$supplier = mysqli_fetch_assoc($result);
mysqli_stmt_close($stmt);

if (!$supplier) {
    header("Location: manage-suppliers.php?msg=Supplier not found&type=danger");
    exit();
}

// Get recent transactions (last 10)
$transaction_sql = "SELECT * FROM supplier_transactions 
                   WHERE supplier_id = ? 
                   ORDER BY transaction_date DESC, created_at DESC 
                   LIMIT 10";
$trans_stmt = mysqli_prepare($conn, $transaction_sql);
mysqli_stmt_bind_param($trans_stmt, "i", $supplier_id);
mysqli_stmt_execute($trans_stmt);
$transactions_result = mysqli_stmt_get_result($trans_stmt);
$recent_transactions = mysqli_fetch_all($transactions_result, MYSQLI_ASSOC);
mysqli_stmt_close($trans_stmt);

// Get transaction statistics
$stats_sql = "SELECT 
    COUNT(*) as total_transactions,
    SUM(CASE WHEN transaction_type = 'purchase' THEN amount ELSE 0 END) as total_purchases,
    SUM(CASE WHEN transaction_type = 'payment' THEN amount ELSE 0 END) as total_payments,
    SUM(CASE WHEN transaction_type = 'credit_note' THEN amount ELSE 0 END) as total_credit_notes,
    SUM(CASE WHEN transaction_type = 'debit_note' THEN amount ELSE 0 END) as total_debit_notes
    FROM supplier_transactions 
    WHERE supplier_id = ?";
$stats_stmt = mysqli_prepare($conn, $stats_sql);
mysqli_stmt_bind_param($stats_stmt, "i", $supplier_id);
mysqli_stmt_execute($stats_stmt);
$stats_result = mysqli_stmt_get_result($stats_stmt);
$stats = mysqli_fetch_assoc($stats_result);
mysqli_stmt_close($stats_stmt);

// Check if purchases table exists and get supplier purchases
$recent_purchases = [];
$purchases_count = 0;

// First, check if purchases table exists
$table_check_sql = "SHOW TABLES LIKE 'purchases'";
$table_result = mysqli_query($conn, $table_check_sql);
$purchases_table_exists = mysqli_num_rows($table_result) > 0;

if ($purchases_table_exists) {
    $purchase_sql = "SELECT id, reference_no, total_amount, purchase_date 
                    FROM purchases 
                    WHERE supplier_id = ? 
                    ORDER BY purchase_date DESC 
                    LIMIT 5";
    $purchase_stmt = mysqli_prepare($conn, $purchase_sql);
    if ($purchase_stmt) {
        mysqli_stmt_bind_param($purchase_stmt, "i", $supplier_id);
        mysqli_stmt_execute($purchase_stmt);
        $purchases_result = mysqli_stmt_get_result($purchase_stmt);
        $recent_purchases = mysqli_fetch_all($purchases_result, MYSQLI_ASSOC);
        $purchases_count = count($recent_purchases);
        mysqli_stmt_close($purchase_stmt);
    }
}
?>

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

<div id="layout-wrapper">

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

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php'); ?>
        </div>
    </div>

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

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Supplier Details</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="manage-suppliers.php">Manage Suppliers</a></li>
                                    <li class="breadcrumb-item active">View Supplier</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($_GET['msg'])): ?>
                    <div class="alert alert-<?php echo $_GET['type'] ?? 'info'; ?> alert-dismissible fade show" role="alert">
                        <?php echo htmlspecialchars($_GET['msg']); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                
                                <div class="row mb-4">
                                    <div class="col-md-6">
                                        <a href="manage-suppliers.php" class="btn btn-secondary">
                                            <i class="dripicons-arrow-left"></i> Back to List
                                        </a>
                                        <a href="edit-supplier.php?id=<?php echo $supplier_id; ?>" class="btn btn-primary ms-1">
                                            <i class="dripicons-pencil"></i> Edit Supplier
                                        </a>
                                        <a href="supplier-transactions.php?supplier_id=<?php echo $supplier_id; ?>" class="btn btn-info ms-1">
                                            <i class="dripicons-document"></i> All Transactions
                                        </a>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        
                                        <button type="button" class="btn btn-outline-secondary" onclick="printSupplierDetails()">
                                            <i class="dripicons-print"></i> Print
                                        </button>
                                        
                                        <?php
                                        $status_class = '';
                                        switch ($supplier['status']) {
                                            case 'active':
                                                $status_class = 'badge bg-success';
                                                break;
                                            case 'inactive':
                                                $status_class = 'badge bg-secondary';
                                                break;
                                            case 'blocked':
                                                $status_class = 'badge bg-danger';
                                                break;
                                            default:
                                                $status_class = 'badge bg-secondary';
                                        }
                                        ?>
                                        <span class="<?php echo $status_class; ?> fs-6 ms-2">
                                            <?php echo ucfirst($supplier['status']); ?>
                                        </span>
                                    </div>
                                </div>

<div class="row" id="supplierDetails">
                                    
                                    <div class="col-md-6">
                                        <div class="card mb-4">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Basic Information</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-borderless mb-0">
                                                        <tbody>
                                                            <tr>
                                                                <th width="40%">Supplier ID:</th>
                                                                <td>
                                                                    <strong>SUP-<?php echo str_pad($supplier['id'], 6, '0', STR_PAD_LEFT); ?></strong>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Supplier Name:</th>
                                                                <td>
                                                                    <h5 class="text-primary"><?php echo htmlspecialchars($supplier['supplier_name']); ?></h5>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Company Name:</th>
                                                                <td>
                                                                    <?php echo !empty($supplier['company_name']) ? htmlspecialchars($supplier['company_name']) : '<span class="text-muted">Not specified</span>'; ?>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Created Date:</th>
                                                                <td>
                                                                    <?php echo date('d M Y, h:i A', strtotime($supplier['created_at'])); ?>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Last Updated:</th>
                                                                <td>
                                                                    <?php echo date('d M Y, h:i A', strtotime($supplier['updated_at'])); ?>
                                                                </td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>

<div class="card mb-4">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Contact Information</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-borderless mb-0">
                                                        <tbody>
                                                            <tr>
                                                                <th width="40%">Phone:</th>
                                                                <td>
                                                                    <i class="dripicons-phone me-2"></i>
                                                                    <?php echo htmlspecialchars($supplier['phone']); ?>
                                                                </td>
                                                            </tr>
                                                            <?php if (!empty($supplier['mobile'])): ?>
                                                            <tr>
                                                                <th>Mobile:</th>
                                                                <td>
                                                                    <i class="dripicons-mobile me-2"></i>
                                                                    <?php echo htmlspecialchars($supplier['mobile']); ?>
                                                                </td>
                                                            </tr>
                                                            <?php endif; ?>
                                                            <?php if (!empty($supplier['email'])): ?>
                                                            <tr>
                                                                <th>Email:</th>
                                                                <td>
                                                                    <i class="dripicons-mail me-2"></i>
                                                                    <a href="mailto:<?php echo htmlspecialchars($supplier['email']); ?>">
                                                                        <?php echo htmlspecialchars($supplier['email']); ?>
                                                                    </a>
                                                                </td>
                                                            </tr>
                                                            <?php endif; ?>
                                                            <?php if (!empty($supplier['address'])): ?>
                                                            <tr>
                                                                <th>Address:</th>
                                                                <td>
                                                                    <i class="dripicons-location me-2"></i>
                                                                    <?php echo nl2br(htmlspecialchars($supplier['address'])); ?>
                                                                </td>
                                                            </tr>
                                                            <?php endif; ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-md-6">
                                        
                                        <div class="card mb-4">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Financial Information</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    
                                                    <div class="col-md-6 mb-3">
                                                        <div class="card border-<?php echo ($supplier['current_balance'] > 0) ? 'danger' : 'success'; ?>">
                                                            <div class="card-body text-center">
                                                                <h6 class="text-muted mb-2">Current Balance</h6>
                                                                <h3 class="text-<?php echo ($supplier['current_balance'] > 0) ? 'danger' : 'success'; ?>">
                                                                    ₹<?php echo number_format(abs($supplier['current_balance']), 2); ?>
                                                                </h3>
                                                                <small class="text-<?php echo ($supplier['current_balance'] > 0) ? 'danger' : 'success'; ?>">
                                                                    <?php echo ($supplier['current_balance'] > 0) ? 'Supplier Owes You' : 'You Owe Supplier'; ?>
                                                                </small>
                                                            </div>
                                                        </div>
                                                    </div>

<div class="col-md-6 mb-3">
                                                        <div class="card border-info">
                                                            <div class="card-body text-center">
                                                                <h6 class="text-muted mb-2">Credit Limit</h6>
                                                                <h3 class="text-info">
                                                                    <?php if ($supplier['credit_limit'] > 0): ?>
                                                                        ₹<?php echo number_format($supplier['credit_limit'], 2); ?>
                                                                    <?php else: ?>
                                                                        <span class="text-muted">No Limit</span>
                                                                    <?php endif; ?>
                                                                </h3>
                                                                <?php if ($supplier['credit_limit'] > 0): ?>
                                                                    <small class="text-muted">Maximum credit allowed</small>
                                                                <?php endif; ?>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>

<div class="table-responsive mt-3">
                                                    <table class="table table-borderless mb-0">
                                                        <tbody>
                                                            <tr>
                                                                <th width="50%">Opening Balance:</th>
                                                                <td class="text-end">
                                                                    ₹<?php echo number_format($supplier['opening_balance'], 2); ?>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>GST Number:</th>
                                                                <td class="text-end">
                                                                    <?php echo !empty($supplier['gst_number']) ? htmlspecialchars($supplier['gst_number']) : '<span class="text-muted">Not provided</span>'; ?>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Payment Terms:</th>
                                                                <td class="text-end">
                                                                    <?php echo !empty($supplier['payment_terms']) ? ucwords(str_replace('days', ' Days', $supplier['payment_terms'])) : '<span class="text-muted">Not specified</span>'; ?>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <th>Location:</th>
                                                                <td class="text-end">
                                                                    <?php
                                                                    $location = [];
                                                                    if (!empty($supplier['city'])) $location[] = $supplier['city'];
                                                                    if (!empty($supplier['state'])) $location[] = $supplier['state'];
                                                                    if (!empty($supplier['pincode'])) $location[] = $supplier['pincode'];
                                                                    echo !empty($location) ? implode(', ', $location) : '<span class="text-muted">Not specified</span>';
                                                                    ?>
                                                                </td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>

<div class="card">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Quick Actions</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row g-2">
                                                    <div class="col-6">
                                                        <a href="create-purchase.php?supplier_id=<?php echo $supplier_id; ?>" 
                                                           class="btn btn-success w-100">
                                                            <i class="dripicons-cart"></i> New Purchase
                                                        </a>
                                                    </div>
                                                    <div class="col-6">
                                                        <a href="supplier-payments.php?supplier_id=<?php echo $supplier_id; ?>" 
                                                           class="btn btn-warning w-100">
                                                            <i class="dripicons-briefcase"></i> Make Payment
                                                        </a>
                                                    </div>
                                                    <div class="col-6">
                                                        <a href="supplier-transactions.php?supplier_id=<?php echo $supplier_id; ?>&type=statement" 
                                                           class="btn btn-info w-100">
                                                            <i class="dripicons-document"></i> View Statement
                                                        </a>
                                                    </div>
                                                    <div class="col-6">
                                                        <button type="button" class="btn btn-outline-danger w-100" 
                                                                onclick="confirmDelete()">
                                                            <i class="dripicons-trash"></i> Delete
                                                        </button>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<?php if (!empty($supplier['notes'])): ?>
                                <div class="row mt-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Additional Notes</h5>
                                            </div>
                                            <div class="card-body">
                                                <p><?php echo nl2br(htmlspecialchars($supplier['notes'])); ?></p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>

<div class="row mt-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header bg-light d-flex justify-content-between align-items-center">
                                                <h5 class="mb-0">Recent Transactions</h5>
                                                <a href="supplier-transactions.php?supplier_id=<?php echo $supplier_id; ?>" class="btn btn-sm btn-primary">
                                                    View All
                                                </a>
                                            </div>
                                            <div class="card-body">
                                                <?php if (empty($recent_transactions)): ?>
                                                    <div class="text-center py-4">
                                                        <i class="dripicons-document text-muted" style="font-size: 48px;"></i>
                                                        <h5 class="mt-2 text-muted">No transactions yet</h5>
                                                        <p>Start by creating a purchase or payment</p>
                                                    </div>
                                                <?php else: ?>
                                                    <div class="table-responsive">
                                                        <table class="table table-hover mb-0">
                                                            <thead>
                                                                <tr>
                                                                    <th>Date</th>
                                                                    <th>Type</th>
                                                                    <th>Reference No</th>
                                                                    <th>Description</th>
                                                                    <th class="text-end">Amount</th>
                                                                    <th class="text-end">Balance</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <?php foreach ($recent_transactions as $transaction): ?>
                                                                    <?php
                                                                    $amount_class = '';
                                                                    $type_badge = '';
                                                                    
                                                                    switch ($transaction['transaction_type']) {
                                                                        case 'purchase':
                                                                            $amount_class = 'text-danger';
                                                                            $type_badge = '<span class="badge bg-danger">Purchase</span>';
                                                                            break;
                                                                        case 'payment':
                                                                            $amount_class = 'text-success';
                                                                            $type_badge = '<span class="badge bg-success">Payment</span>';
                                                                            break;
                                                                        case 'credit_note':
                                                                            $amount_class = 'text-info';
                                                                            $type_badge = '<span class="badge bg-info">Credit Note</span>';
                                                                            break;
                                                                        case 'debit_note':
                                                                            $amount_class = 'text-warning';
                                                                            $type_badge = '<span class="badge bg-warning">Debit Note</span>';
                                                                            break;
                                                                    }
                                                                    ?>
                                                                    <tr>
                                                                        <td><?php echo date('d M Y', strtotime($transaction['transaction_date'])); ?></td>
                                                                        <td><?php echo $type_badge; ?></td>
                                                                        <td><?php echo htmlspecialchars($transaction['reference_no']); ?></td>
                                                                        <td><?php echo htmlspecialchars($transaction['description']); ?></td>
                                                                        <td class="text-end <?php echo $amount_class; ?>">
                                                                            <?php echo ($transaction['amount'] > 0) ? '+' : ''; ?>₹<?php echo number_format($transaction['amount'], 2); ?>
                                                                        </td>
                                                                        <td class="text-end">
                                                                            ₹<?php echo number_format($transaction['balance'], 2); ?>
                                                                        </td>
                                                                    </tr>
                                                                <?php endforeach; ?>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mt-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Transaction Statistics</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="text-center">
                                                            <h3 class="text-primary"><?php echo $stats['total_transactions'] ?? 0; ?></h3>
                                                            <p class="text-muted mb-0">Total Transactions</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="text-center">
                                                            <h3 class="text-danger">₹<?php echo number_format($stats['total_purchases'] ?? 0, 2); ?></h3>
                                                            <p class="text-muted mb-0">Total Purchases</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="text-center">
                                                            <h3 class="text-success">₹<?php echo number_format($stats['total_payments'] ?? 0, 2); ?></h3>
                                                            <p class="text-muted mb-0">Total Payments</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="text-center">
                                                            <h3 class="text-info"><?php echo $purchases_count; ?></h3>
                                                            <p class="text-muted mb-0">Recent Purchases</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

</div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

</div>

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

function confirmDelete() {
    if (confirm('Are you sure you want to delete this supplier?\n\nThis action cannot be undone!')) {
        window.location.href = 'actions/delete-supplier.php?id=<?php echo $supplier_id; ?>';
    }
}

// Quick contact actions
function callSupplier(phone) {
    if (confirm('Call ' + phone + '?')) {
        window.location.href = 'tel:' + phone;
    }
}

function emailSupplier(email) {
    window.location.href = 'mailto:' + email;
}

// Copy supplier details to clipboard
function copyToClipboard(text) {
    navigator.clipboard.writeText(text).then(function() {
        alert('Copied to clipboard: ' + text);
    }, function(err) {
        console.error('Could not copy text: ', err);
    });
}

document.addEventListener('DOMContentLoaded', function() {
    // Add click event for phone numbers
    document.querySelectorAll('.phone-number').forEach(function(element) {
        element.addEventListener('click', function() {
            callSupplier(this.textContent.trim());
        });
    });

// Add click event for emails
    document.querySelectorAll('.email-address').forEach(function(element) {
        element.addEventListener('click', function() {
            emailSupplier(this.textContent.trim());
        });
    });

// Keyboard shortcuts
    document.addEventListener('keydown', function(e) {
        // Ctrl+P for print
        if (e.ctrlKey && e.key === 'p') {
            e.preventDefault();
            printSupplierDetails();
        }
        // Escape key to go back
        if (e.key === 'Escape') {
            window.location.href = 'manage-suppliers.php';
        }
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-supplier.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation