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.12 TB

🔧 Quick Actions

✏️ Editing: supplier-transactions.php

<?php
// Start session only if not already started
if (session_status() === PHP_SESSION_NONE) {
   
}

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

// 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 (optional - if viewing specific supplier's transactions)
$supplier_id = isset($_GET['supplier_id']) ? (int)$_GET['supplier_id'] : 0;
$type = isset($_GET['type']) ? mysqli_real_escape_string($conn, $_GET['type']) : '';

// Pagination variables
$limit = 50; // Number of records per page
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $limit;

// Filter variables
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$transaction_type = isset($_GET['transaction_type']) ? mysqli_real_escape_string($conn, $_GET['transaction_type']) : '';
$start_date = isset($_GET['start_date']) ? mysqli_real_escape_string($conn, $_GET['start_date']) : '';
$end_date = isset($_GET['end_date']) ? mysqli_real_escape_string($conn, $_GET['end_date']) : '';

// Build WHERE clause for main query
$where_conditions = [];
$params = [];
$types = '';

// If viewing specific supplier's transactions
if ($supplier_id > 0) {
    $where_conditions[] = "st.supplier_id = ?";
    $types .= 'i';
    $params[] = $supplier_id;
    
    // Get supplier details for header
    $supplier_sql = "SELECT * FROM suppliers WHERE id = ?";
    $supplier_stmt = mysqli_prepare($conn, $supplier_sql);
    mysqli_stmt_bind_param($supplier_stmt, "i", $supplier_id);
    mysqli_stmt_execute($supplier_stmt);
    $supplier_result = mysqli_stmt_get_result($supplier_stmt);
    $supplier = mysqli_fetch_assoc($supplier_result);
    mysqli_stmt_close($supplier_stmt);
}

// Search filter
if (!empty($search)) {
    $where_conditions[] = "(st.reference_no LIKE ? OR st.description LIKE ? OR s.supplier_name LIKE ?)";
    $search_term = "%{$search}%";
    $types .= 'sss';
    $params = array_merge($params, [$search_term, $search_term, $search_term]);
}

// Transaction type filter
if (!empty($transaction_type)) {
    $where_conditions[] = "st.transaction_type = ?";
    $types .= 's';
    $params[] = $transaction_type;
}

// Date range filter
if (!empty($start_date)) {
    $where_conditions[] = "st.transaction_date >= ?";
    $types .= 's';
    $params[] = $start_date;
}
if (!empty($end_date)) {
    $where_conditions[] = "st.transaction_date <= ?";
    $types .= 's';
    $params[] = $end_date;
}

$where_clause = '';
if (!empty($where_conditions)) {
    $where_clause = 'WHERE ' . implode(' AND ', $where_conditions);
}

// Get total number of transactions for pagination
$count_sql = "SELECT COUNT(*) as total 
             FROM supplier_transactions st
             LEFT JOIN suppliers s ON st.supplier_id = s.id
             $where_clause";
             
$count_stmt = mysqli_prepare($conn, $count_sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($count_stmt, $types, ...$params);
}
mysqli_stmt_execute($count_stmt);
$count_result = mysqli_stmt_get_result($count_stmt);
$total_rows = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_rows / $limit);
mysqli_stmt_close($count_stmt);

// Get transactions with pagination
$sql = "SELECT st.*, s.supplier_name, s.company_name, s.phone
        FROM supplier_transactions st
        LEFT JOIN suppliers s ON st.supplier_id = s.id
        $where_clause 
        ORDER BY st.transaction_date DESC, st.created_at DESC 
        LIMIT ?, ?";
        
$limit_params = $params; // Copy params for limit query
$limit_types = $types . 'ii';
$limit_params[] = $start;
$limit_params[] = $limit;

$stmt = mysqli_prepare($conn, $sql);
if ($stmt) {
    if (!empty($limit_params)) {
        mysqli_stmt_bind_param($stmt, $limit_types, ...$limit_params);
    }
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $transactions = mysqli_fetch_all($result, MYSQLI_ASSOC);
    mysqli_stmt_close($stmt);
} else {
    $transactions = [];
}

// Get statistics - FIXED VERSION
$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 st
    LEFT JOIN suppliers s ON st.supplier_id = s.id
    $where_clause";
    
$stats_stmt = mysqli_prepare($conn, $stats_sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($stats_stmt, $types, ...$params);
}
mysqli_stmt_execute($stats_stmt);
$stats_result = mysqli_stmt_get_result($stats_stmt);
$stats = mysqli_fetch_assoc($stats_result);
mysqli_stmt_close($stats_stmt);

// Initialize stats if null
if (!$stats) {
    $stats = [
        'total_transactions' => 0,
        'total_purchases' => 0,
        'total_payments' => 0,
        'total_credit_notes' => 0,
        'total_debit_notes' => 0
    ];
}
?>
<!doctype html>
<html lang="en">

<?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">
                                <?php if ($supplier_id > 0 && isset($supplier)): ?>
                                    Transactions - <?php echo htmlspecialchars($supplier['supplier_name']); ?>
                                <?php else: ?>
                                    Supplier Transactions
                                <?php endif; ?>
                            </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>
                                    <?php if ($supplier_id > 0 && isset($supplier)): ?>
                                        <li class="breadcrumb-item"><a href="view-supplier.php?id=<?php echo $supplier_id; ?>">View Supplier</a></li>
                                    <?php endif; ?>
                                    <li class="breadcrumb-item active">
                                        <?php echo ($type == 'statement') ? 'Statement' : 'Transactions'; ?>
                                    </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; ?>

<?php if ($supplier_id > 0 && isset($supplier)): ?>
                <div class="row mb-4">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-8">
                                        <h5 class="card-title mb-3">Supplier Information</h5>
                                        <div class="row">
                                            <div class="col-md-6">
                                                <table class="table table-borderless mb-0">
                                                    <tr>
                                                        <th width="40%">Supplier:</th>
                                                        <td><strong><?php echo htmlspecialchars($supplier['supplier_name']); ?></strong></td>
                                                    </tr>
                                                    <tr>
                                                        <th>Company:</th>
                                                        <td><?php echo !empty($supplier['company_name']) ? htmlspecialchars($supplier['company_name']) : 'N/A'; ?></td>
                                                    </tr>
                                                    <tr>
                                                        <th>Phone:</th>
                                                        <td><?php echo htmlspecialchars($supplier['phone']); ?></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="col-md-6">
                                                <table class="table table-borderless mb-0">
                                                    <tr>
                                                        <th width="40%">Current Balance:</th>
                                                        <td class="<?php echo ($supplier['current_balance'] > 0) ? 'text-danger' : 'text-success'; ?> fw-bold">
                                                            ₹<?php echo number_format(abs($supplier['current_balance']), 2); ?>
                                                            <br>
                                                            <small>
                                                                <?php if ($supplier['current_balance'] > 0): ?>
                                                                    <span class="text-danger">Supplier owes you</span>
                                                                <?php elseif ($supplier['current_balance'] < 0): ?>
                                                                    <span class="text-success">You owe supplier</span>
                                                                <?php else: ?>
                                                                    <span class="text-muted">No balance due</span>
                                                                <?php endif; ?>
                                                            </small>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <th>Credit Limit:</th>
                                                        <td>
                                                            <?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; ?>
                                                        </td>
                                                    </tr>
                                                </table>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4 text-end">
                                        <div class="d-flex flex-column h-100 justify-content-center">
                                            <a href="view-supplier.php?id=<?php echo $supplier_id; ?>" class="btn btn-outline-primary mb-2">
                                                <i class="dripicons-preview me-1"></i> View Supplier
                                            </a>
                                            <a href="supplier-payments.php?supplier_id=<?php echo $supplier_id; ?>" class="btn btn-success mb-2">
                                                <i class="dripicons-briefcase me-1"></i> Make Payment
                                            </a>
                                            <a href="create-purchase.php?supplier_id=<?php echo $supplier_id; ?>" class="btn btn-warning">
                                                <i class="dripicons-cart me-1"></i> New Purchase
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-6">
                                        <?php if ($supplier_id > 0): ?>
                                            <a href="view-supplier.php?id=<?php echo $supplier_id; ?>" class="btn btn-secondary">
                                                <i class="dripicons-arrow-left"></i> Back to Supplier
                                            </a>
                                        <?php else: ?>
                                            <a href="manage-suppliers.php" class="btn btn-secondary">
                                                <i class="dripicons-arrow-left"></i> Back to Suppliers
                                            </a>
                                        <?php endif; ?>
                                        <button type="button" class="btn btn-outline-primary ms-1" onclick="printStatement()">
                                            <i class="dripicons-print"></i> Print Statement
                                        </button>
                                        <?php if ($type == 'statement'): ?>
                                            <button type="button" class="btn btn-info ms-1" onclick="downloadPDF()">
                                                <i class="dripicons-download"></i> Download PDF
                                            </button>
                                        <?php endif; ?>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        <?php if (!$supplier_id > 0): ?>
                                            <a href="add-supplier.php" class="btn btn-primary">
                                                <i class="dripicons-user-add"></i> Add Supplier
                                            </a>
                                        <?php endif; ?>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card bg-light">
                                            <div class="card-body">
                                                <h6 class="mb-3"><i class="dripicons-filter me-2"></i> Filter Transactions</h6>
                                                <form method="GET" class="row g-3">
                                                    <?php if ($supplier_id > 0): ?>
                                                        <input type="hidden" name="supplier_id" value="<?php echo $supplier_id; ?>">
                                                    <?php endif; ?>
                                                    <?php if ($type): ?>
                                                        <input type="hidden" name="type" value="<?php echo $type; ?>">
                                                    <?php endif; ?>
                                                    
                                                    <div class="col-md-3">
                                                        <input type="text" class="form-control" name="search" 
                                                               placeholder="Search reference/description..." 
                                                               value="<?php echo htmlspecialchars($search); ?>">
                                                    </div>
                                                    
                                                    <div class="col-md-2">
                                                        <select class="form-control" name="transaction_type">
                                                            <option value="">All Types</option>
                                                            <option value="purchase" <?php echo $transaction_type == 'purchase' ? 'selected' : ''; ?>>Purchase</option>
                                                            <option value="payment" <?php echo $transaction_type == 'payment' ? 'selected' : ''; ?>>Payment</option>
                                                            <option value="credit_note" <?php echo $transaction_type == 'credit_note' ? 'selected' : ''; ?>>Credit Note</option>
                                                            <option value="debit_note" <?php echo $transaction_type == 'debit_note' ? 'selected' : ''; ?>>Debit Note</option>
                                                        </select>
                                                    </div>
                                                    
                                                    <div class="col-md-2">
                                                        <input type="date" class="form-control" name="start_date" 
                                                               value="<?php echo htmlspecialchars($start_date); ?>"
                                                               max="<?php echo date('Y-m-d'); ?>">
                                                    </div>
                                                    
                                                    <div class="col-md-2">
                                                        <input type="date" class="form-control" name="end_date" 
                                                               value="<?php echo htmlspecialchars($end_date); ?>"
                                                               max="<?php echo date('Y-m-d'); ?>">
                                                    </div>
                                                    
                                                    <div class="col-md-3">
                                                        <button type="submit" class="btn btn-primary w-100">
                                                            <i class="dripicons-search"></i> Filter
                                                        </button>
                                                    </div>
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-md-3 col-6 mb-3">
                                        <div class="card border-primary">
                                            <div class="card-body text-center">
                                                <h6 class="text-muted mb-2">Total Transactions</h6>
                                                <h3 class="text-primary"><?php echo $stats['total_transactions'] ?? 0; ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-6 mb-3">
                                        <div class="card border-danger">
                                            <div class="card-body text-center">
                                                <h6 class="text-muted mb-2">Total Purchases</h6>
                                                <h3 class="text-danger">₹<?php echo number_format($stats['total_purchases'] ?? 0, 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-6 mb-3">
                                        <div class="card border-success">
                                            <div class="card-body text-center">
                                                <h6 class="text-muted mb-2">Total Payments</h6>
                                                <h3 class="text-success">₹<?php echo number_format($stats['total_payments'] ?? 0, 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-6 mb-3">
                                        <div class="card border-info">
                                            <div class="card-body text-center">
                                                <h6 class="text-muted mb-2">Balance Adjustments</h6>
                                                <h3 class="text-info">₹<?php 
                                                    $adjustments = ($stats['total_credit_notes'] ?? 0) + ($stats['total_debit_notes'] ?? 0);
                                                    echo number_format($adjustments, 2); 
                                                ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive" id="printableTable">
                                    <?php if ($type == 'statement' && $supplier_id > 0 && isset($supplier)): ?>
                                        
                                        <div class="text-center mb-4">
                                            <h4>Account Statement</h4>
                                            <h5><?php echo htmlspecialchars($supplier['supplier_name']); ?></h5>
                                            <p class="text-muted">
                                                <?php if ($start_date || $end_date): ?>
                                                    Period: <?php echo $start_date ? date('d M Y', strtotime($start_date)) : 'Beginning'; ?> 
                                                    to <?php echo $end_date ? date('d M Y', strtotime($end_date)) : date('d M Y'); ?>
                                                <?php else: ?>
                                                    As of <?php echo date('d M Y'); ?>
                                                <?php endif; ?>
                                            </p>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <table class="table table-hover table-centered mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <?php if (!$supplier_id > 0): ?>
                                                    <th>Supplier</th>
                                                <?php endif; ?>
                                                <th>Date</th>
                                                <th>Type</th>
                                                <th>Reference No</th>
                                                <th>Description</th>
                                                <th class="text-end">Debit</th>
                                                <th class="text-end">Credit</th>
                                                <th class="text-end">Balance</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            // Calculate running balance differently for statement view
                                            if ($type == 'statement' && $supplier_id > 0 && isset($supplier)) {
                                                // For statement view, we need to calculate from oldest to newest
                                                $reversed_transactions = array_reverse($transactions);
                                                $running_balance = $supplier['opening_balance'] ?? 0;
                                                
                                                foreach ($reversed_transactions as $transaction) {
                                                    switch ($transaction['transaction_type']) {
                                                        case 'purchase':
                                                        case 'debit_note':
                                                            $running_balance -= $transaction['amount'];
                                                            break;
                                                        case 'payment':
                                                        case 'credit_note':
                                                            $running_balance += $transaction['amount'];
                                                            break;
                                                    }
                                                }
                                            } else {
                                                $running_balance = $supplier_id > 0 && isset($supplier) ? $supplier['current_balance'] : 0;
                                            }
                                            
                                            $counter = $start + 1;
                                            
                                            if (empty($transactions)): ?>
                                                <tr>
                                                    <td colspan="<?php echo $supplier_id > 0 ? '9' : '10'; ?>" class="text-center py-4">
                                                        <div class="text-muted">
                                                            <i class="dripicons-document" style="font-size: 48px;"></i>
                                                            <h5 class="mt-2">No transactions found</h5>
                                                            <p>
                                                                <?php if ($supplier_id > 0): ?>
                                                                    No transactions recorded for this supplier yet.
                                                                <?php else: ?>
                                                                    No transactions found matching your criteria.
                                                                <?php endif; ?>
                                                            </p>
                                                        </div>
                                                    </td>
                                                </tr>
                                            <?php else: ?>
                                                <?php 
                                                // For statement view, we need to process transactions in chronological order
                                                $display_transactions = $transactions;
                                                if ($type == 'statement' && $supplier_id > 0) {
                                                    $display_transactions = array_reverse($transactions);
                                                    $running_balance = $supplier['opening_balance'] ?? 0;
                                                }
                                                
                                                foreach ($display_transactions as $transaction): 
                                                    // Determine transaction type styling
                                                    $type_class = '';
                                                    $type_badge = '';
                                                    $debit = 0;
                                                    $credit = 0;
                                                    
                                                    switch ($transaction['transaction_type']) {
                                                        case 'purchase':
                                                            $type_class = 'danger';
                                                            $type_badge = '<span class="badge bg-danger">Purchase</span>';
                                                            $debit = abs($transaction['amount']);
                                                            if ($type == 'statement') {
                                                                $running_balance += $transaction['amount']; // Purchase increases what supplier owes
                                                            } else {
                                                                $running_balance -= $transaction['amount'];
                                                            }
                                                            break;
                                                        case 'payment':
                                                            $type_class = 'success';
                                                            $type_badge = '<span class="badge bg-success">Payment</span>';
                                                            $credit = abs($transaction['amount']);
                                                            if ($type == 'statement') {
                                                                $running_balance -= $transaction['amount']; // Payment decreases what supplier owes
                                                            } else {
                                                                $running_balance += $transaction['amount'];
                                                            }
                                                            break;
                                                        case 'credit_note':
                                                            $type_class = 'info';
                                                            $type_badge = '<span class="badge bg-info">Credit Note</span>';
                                                            $credit = abs($transaction['amount']);
                                                            if ($type == 'statement') {
                                                                $running_balance -= $transaction['amount'];
                                                            } else {
                                                                $running_balance += $transaction['amount'];
                                                            }
                                                            break;
                                                        case 'debit_note':
                                                            $type_class = 'warning';
                                                            $type_badge = '<span class="badge bg-warning">Debit Note</span>';
                                                            $debit = abs($transaction['amount']);
                                                            if ($type == 'statement') {
                                                                $running_balance += $transaction['amount'];
                                                            } else {
                                                                $running_balance -= $transaction['amount'];
                                                            }
                                                            break;
                                                    }
                                                    
                                                    $balance_class = $running_balance > 0 ? 'text-danger' : 'text-success';
                                                    ?>
                                                    <tr>
                                                        <td><?php echo $counter++; ?></td>
                                                        <?php if (!$supplier_id > 0): ?>
                                                            <td>
                                                                <strong><?php echo htmlspecialchars($transaction['supplier_name']); ?></strong>
                                                                <?php if (!empty($transaction['company_name'])): ?>
                                                                    <br><small class="text-muted"><?php echo htmlspecialchars($transaction['company_name']); ?></small>
                                                                <?php endif; ?>
                                                                <br><small class="text-muted"><?php echo htmlspecialchars($transaction['phone']); ?></small>
                                                            </td>
                                                        <?php endif; ?>
                                                        <td><?php echo date('d M Y', strtotime($transaction['transaction_date'])); ?></td>
                                                        <td><?php echo $type_badge; ?></td>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($transaction['reference_no']); ?></strong>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($transaction['description']); ?></td>
                                                        <td class="text-end text-danger">
                                                            <?php if ($debit > 0): ?>
                                                                ₹<?php echo number_format($debit, 2); ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">-</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td class="text-end text-success">
                                                            <?php if ($credit > 0): ?>
                                                                ₹<?php echo number_format($credit, 2); ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">-</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td class="text-end <?php echo $balance_class; ?> fw-bold">
                                                            ₹<?php echo number_format(abs($running_balance), 2); ?>
                                                            <br>
                                                            <small class="<?php echo $balance_class; ?>">
                                                                <?php echo $running_balance > 0 ? 'Due from Supplier' : 'Due to Supplier'; ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group" role="group">
                                                                <button type="button" class="btn btn-sm btn-light dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false">
                                                                    <i class="dripicons-gear"></i>
                                                                </button>
                                                                <ul class="dropdown-menu">
                                                                    <li>
                                                                        <a class="dropdown-item" href="view-transaction.php?id=<?php echo $transaction['id']; ?>">
                                                                            <i class="dripicons-preview"></i> View Details
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item" href="edit-transaction.php?id=<?php echo $transaction['id']; ?>">
                                                                            <i class="dripicons-pencil"></i> Edit
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item" href="#" onclick="printTransaction(<?php echo $transaction['id']; ?>)">
                                                                            <i class="dripicons-print"></i> Print Receipt
                                                                        </a>
                                                                    </li>
                                                                    <li><hr class="dropdown-divider"></li>
                                                                    <li>
                                                                        <a class="dropdown-item text-danger" href="actions/delete-transaction.php?id=<?php echo $transaction['id']; ?>" 
                                                                           onclick="return confirm('Are you sure you want to delete this transaction? This will affect the supplier balance.')">
                                                                            <i class="dripicons-trash"></i> Delete
                                                                        </a>
                                                                    </li>
                                                                </ul>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            <?php endif; ?>
                                        </tbody>
                                        <?php if (!empty($transactions)): ?>
                                        <tfoot>
                                            <tr class="table-active">
                                                <th colspan="<?php echo $supplier_id > 0 ? '5' : '6'; ?>">Totals</th>
                                                <th class="text-end text-danger">₹<?php 
                                                    $total_debit = array_sum(array_map(function($t) {
                                                        return in_array($t['transaction_type'], ['purchase', 'debit_note']) ? abs($t['amount']) : 0;
                                                    }, $transactions));
                                                    echo number_format($total_debit, 2); 
                                                ?></th>
                                                <th class="text-end text-success">₹<?php 
                                                    $total_credit = array_sum(array_map(function($t) {
                                                        return in_array($t['transaction_type'], ['payment', 'credit_note']) ? abs($t['amount']) : 0;
                                                    }, $transactions));
                                                    echo number_format($total_credit, 2); 
                                                ?></th>
                                                <th class="text-end">
                                                    <?php if ($supplier_id > 0 && isset($supplier)): ?>
                                                        <span class="<?php echo $supplier['current_balance'] > 0 ? 'text-danger' : 'text-success'; ?> fw-bold">
                                                            ₹<?php echo number_format(abs($supplier['current_balance']), 2); ?>
                                                        </span>
                                                    <?php else: ?>
                                                        <span class="text-muted">N/A</span>
                                                    <?php endif; ?>
                                                </th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                        <?php endif; ?>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                    <div class="row mt-3">
                                        <div class="col-md-6">
                                            <p class="text-muted">
                                                Showing <?php echo ($start + 1); ?> to <?php echo min($start + $limit, $total_rows); ?> of <?php echo $total_rows; ?> entries
                                            </p>
                                        </div>
                                        <div class="col-md-6">
                                            <nav aria-label="Page navigation">
                                                <ul class="pagination justify-content-end">
                                                    <li class="page-item <?php echo ($page <= 1) ? 'disabled' : ''; ?>">
                                                        <a class="page-link" href="?<?php 
                                                            $query_params = $_GET;
                                                            $query_params['page'] = $page - 1;
                                                            echo http_build_query($query_params);
                                                        ?>">Previous</a>
                                                    </li>
                                                    
                                                    <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                        <li class="page-item <?php echo ($page == $i) ? 'active' : ''; ?>">
                                                            <a class="page-link" href="?<?php 
                                                                $query_params = $_GET;
                                                                $query_params['page'] = $i;
                                                                echo http_build_query($query_params);
                                                            ?>"><?php echo $i; ?></a>
                                                        </li>
                                                    <?php endfor; ?>
                                                    
                                                    <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                                                        <a class="page-link" href="?<?php 
                                                            $query_params = $_GET;
                                                            $query_params['page'] = $page + 1;
                                                            echo http_build_query($query_params);
                                                        ?>">Next</a>
                                                    </li>
                                                </ul>
                                            </nav>
                                        </div>
                                    </div>
                                <?php endif; ?>

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

</div>
        </div>

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

</div>

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

function downloadPDF() {
    // This would require a server-side PDF generation script
    alert('PDF download feature would be implemented with a server-side PDF generator like TCPDF or Dompdf.');
    // window.location.href = 'generate-pdf.php?supplier_id=<?php echo $supplier_id; ?>&type=statement';
}

function printTransaction(transactionId) {
    window.open('print-transaction.php?id=' + transactionId, '_blank');
}

// Auto-submit form when dates are selected
document.addEventListener('DOMContentLoaded', function() {
    const startDate = document.querySelector('input[name="start_date"]');
    const endDate = document.querySelector('input[name="end_date"]');
    
    // Set end date max to today
    const today = new Date().toISOString().split('T')[0];
    if (startDate) startDate.max = today;
    if (endDate) endDate.max = today;
    
    // Auto-set end date if start date is selected and end date is empty
    if (startDate) {
        startDate.addEventListener('change', function() {
            if (this.value && endDate && !endDate.value) {
                endDate.value = this.value;
            }
        });
    }
    
    // Quick date filters
    const quickFilterButtons = document.querySelectorAll('.quick-filter');
    quickFilterButtons.forEach(button => {
        button.addEventListener('click', function(e) {
            e.preventDefault();
            const days = this.getAttribute('data-days');
            const end = new Date();
            const start = new Date();
            start.setDate(start.getDate() - days);
            
            startDate.value = start.toISOString().split('T')[0];
            endDate.value = end.toISOString().split('T')[0];
            
            this.closest('form').submit();
        });
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: supplier-transactions.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation