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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: stock-adjustment.php

<?php
// stock-adjustment.php
session_start();
require_once 'includes/db.php';

$message = '';

// Handle stock adjustment
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['adjust_stock'])) {
    $product_id = intval($_POST['product_id']);
    $adjustment_type = $_POST['adjustment_type'];
    $quantity = floatval($_POST['quantity']);
    $notes = trim($_POST['notes'] ?? '');
    
    // Validate inputs
    $errors = [];
    if ($product_id <= 0) $errors[] = "Please select a valid product.";
    if (empty($adjustment_type)) $errors[] = "Please select adjustment type.";
    if ($quantity <= 0) $errors[] = "Quantity must be greater than 0.";
    
    if (empty($errors)) {
        // Get current product details
        $product_sql = "SELECT name, total_quantity, quantity_unit, price FROM products WHERE id = $product_id";
        $product_result = mysqli_query($conn, $product_sql);
        
        if (mysqli_num_rows($product_result) > 0) {
            $product = mysqli_fetch_assoc($product_result);
            $current_quantity = $product['total_quantity'];
            $product_name = $product['name'];
            $quantity_unit = $product['quantity_unit'];
            $product_price = $product['price'];
            
            // Calculate new quantity based on adjustment type
            $change_type = '';
            $value_change = 0;
            
            switch ($adjustment_type) {
                case 'add':
                    $new_quantity = $current_quantity + $quantity;
                    $change_type = 'stock_added';
                    $value_change = $quantity * $product_price;
                    break;
                    
                case 'remove':
                    $new_quantity = $current_quantity - $quantity;
                    if ($new_quantity < 0) {
                        $errors[] = "Cannot remove more stock than available! Current stock: " . $current_quantity . " " . $quantity_unit;
                    } else {
                        $change_type = 'stock_removed';
                        $value_change = -($quantity * $product_price);
                    }
                    break;
                    
                case 'set':
                    $new_quantity = $quantity;
                    $change_type = 'stock_set';
                    $value_change = ($new_quantity - $current_quantity) * $product_price;
                    break;
                    
                default:
                    $errors[] = "Invalid adjustment type.";
            }
            
            if (empty($errors)) {
                // Start transaction
                mysqli_begin_transaction($conn);
                
                try {
                    // Update product quantity
                    $update_sql = "UPDATE products SET total_quantity = $new_quantity, updated_at = NOW() WHERE id = $product_id";
                    
                    if (mysqli_query($conn, $update_sql)) {
                        // Check if stock_history table exists, if not create it
                        $check_table_sql = "SHOW TABLES LIKE 'stock_history'";
                        $table_result = mysqli_query($conn, $check_table_sql);
                        
                        if (mysqli_num_rows($table_result) == 0) {
                            // Create stock_history table
                            $create_table_sql = "CREATE TABLE stock_history (
                                id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                                product_id INT(11) NOT NULL,
                                change_type ENUM('stock_added', 'stock_removed', 'stock_set', 'sale', 'purchase', 'adjustment') NOT NULL,
                                previous_quantity DECIMAL(10,2) NOT NULL,
                                new_quantity DECIMAL(10,2) NOT NULL,
                                quantity_change DECIMAL(10,2) NOT NULL,
                                notes TEXT NULL,
                                created_by VARCHAR(100) DEFAULT 'admin',
                                created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
                                FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE
                            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
                            
                            mysqli_query($conn, $create_table_sql);
                        }
                        
                        // Record stock history
                        $history_sql = "INSERT INTO stock_history (product_id, change_type, previous_quantity, new_quantity, quantity_change, notes, created_by, created_at) 
                                       VALUES ($product_id, '$change_type', $current_quantity, $new_quantity, " . ($new_quantity - $current_quantity) . ", '" . mysqli_real_escape_string($conn, $notes) . "', 'admin', NOW())";
                        
                        if (mysqli_query($conn, $history_sql)) {
                            mysqli_commit($conn);
                            
                            $message_type = 'success';
                            $message_text = "
                                <strong>Stock updated successfully!</strong><br>
                                <strong>Product:</strong> {$product_name}<br>
                                <strong>Previous Stock:</strong> " . number_format($current_quantity, 2) . " {$quantity_unit}<br>
                                <strong>New Stock:</strong> " . number_format($new_quantity, 2) . " {$quantity_unit}<br>
                                <strong>Change:</strong> " . ($new_quantity - $current_quantity > 0 ? '+' : '') . number_format($new_quantity - $current_quantity, 2) . " {$quantity_unit}<br>
                                <strong>Value Change:</strong> " . ($value_change > 0 ? '+' : '') . "₹" . number_format(abs($value_change), 2) . "<br>
                                <strong>Notes:</strong> " . ($notes ? htmlspecialchars($notes) : 'None')
                            ;
                            
                            // Clear form on success
                            $_POST = [];
                        } else {
                            throw new Exception("History not recorded: " . mysqli_error($conn));
                        }
                    } else {
                        throw new Exception("Error updating stock: " . mysqli_error($conn));
                    }
                } catch (Exception $e) {
                    mysqli_rollback($conn);
                    $message_type = 'danger';
                    $message_text = $e->getMessage();
                }
            }
        } else {
            $message_type = 'danger';
            $message_text = "Product not found!";
        }
    } else {
        $message_type = 'danger';
        $message_text = '<ul class="mb-0"><li>' . implode('</li><li>', $errors) . '</li></ul>';
    }
    
    if (isset($message_type) && isset($message_text)) {
        $message = '<div class="alert alert-' . $message_type . '">' . $message_text . '</div>';
    }
}

// Get products for dropdown
$products_sql = "SELECT id, name, total_quantity, quantity_unit, price FROM products WHERE is_active = 1 ORDER BY name";
$products_result = mysqli_query($conn, $products_sql);

// Get recent stock adjustments for display
$recent_sql = "SELECT sh.*, p.name as product_name, p.quantity_unit 
               FROM stock_history sh 
               JOIN products p ON sh.product_id = p.id 
               ORDER BY sh.created_at DESC 
               LIMIT 10";
$recent_result = mysqli_query($conn, $recent_sql);

// Get stock statistics
$stats_sql = "SELECT 
                COUNT(*) as total_products,
                SUM(total_quantity * price) as total_stock_value,
                SUM(total_quantity) as total_quantity,
                COUNT(CASE WHEN total_quantity < 10 THEN 1 END) as low_stock_count
              FROM products 
              WHERE is_active = 1";
$stats_result = mysqli_query($conn, $stats_sql);
$stats = mysqli_fetch_assoc($stats_result);
?>
<!doctype html>
<html lang="en">
<?php include('includes/head.php')?>
<body data-sidebar="dark">
<?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="row align-items-center mb-3">
                    <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
                        <h4 class="mb-0">Stock Adjustment</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="stock-history.php" class="btn btn-secondary btn-sm">
                                <i class="fas fa-history me-1"></i> Stock History
                            </a>
                            <a href="manage-products.php" class="btn btn-primary btn-sm">Manage Products</a>
                        </div>
                    </div>
                </div>

<?php echo $message; ?>

<div class="row mb-4">
                    <div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Total Products</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-cubes text-primary h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h3 class="mb-1"><?php echo number_format($stats['total_products']); ?></h3>
                                    <p class="text-muted mb-0">Active products</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Total Stock Value</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-rupee-sign text-success h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h3 class="mb-1">₹<?php echo number_format($stats['total_stock_value'] ?? 0, 2); ?></h3>
                                    <p class="text-muted mb-0">Current inventory value</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Total Quantity</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-boxes text-info h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h3 class="mb-1"><?php echo number_format($stats['total_quantity'] ?? 0, 2); ?></h3>
                                    <p class="text-muted mb-0">Total stock units</p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-3 col-md-6">
                        <div class="card card-hover">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h5 class="font-size-14 mb-0">Low Stock Items</h5>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-exclamation-triangle text-warning h4"></i>
                                    </div>
                                </div>
                                <div class="mt-3">
                                    <h3 class="mb-1"><?php echo number_format($stats['low_stock_count']); ?></h3>
                                    <p class="text-muted mb-0">Need restocking</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-6">
                        
                        <div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Adjust Stock Quantity</h5>
                            </div>
                            <div class="card-body">
                                <form method="POST" id="stockAdjustmentForm">
                                    <div class="mb-3">
                                        <label class="form-label">Product <span class="text-danger">*</span></label>
                                        <select name="product_id" id="productSelect" class="form-select" required onchange="updateProductInfo()">
                                            <option value="">Select Product</option>
                                            <?php while ($product = mysqli_fetch_assoc($products_result)): ?>
                                                <option value="<?php echo $product['id']; ?>" 
                                                    data-quantity="<?php echo $product['total_quantity']; ?>"
                                                    data-unit="<?php echo $product['quantity_unit']; ?>"
                                                    data-price="<?php echo $product['price']; ?>"
                                                    <?php echo (isset($_POST['product_id']) && $_POST['product_id'] == $product['id']) ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($product['name']); ?> 
                                                    (Current: <?php echo $product['total_quantity']; ?> <?php echo $product['quantity_unit']; ?>)
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                        <div class="form-text">Select the product you want to adjust</div>
                                    </div>

<div id="currentStockInfo" class="alert alert-info d-none">
                                        <div class="row">
                                            <div class="col-6">
                                                <strong>Current Stock:</strong><br>
                                                <span id="currentQuantity" class="h5">0</span> 
                                                <span id="currentUnit" class="text-muted"></span>
                                            </div>
                                            <div class="col-6">
                                                <strong>Stock Value:</strong><br>
                                                <span id="currentValue" class="h5">₹0.00</span>
                                            </div>
                                        </div>
                                    </div>

<div class="mb-3">
                                        <label class="form-label">Adjustment Type <span class="text-danger">*</span></label>
                                        <select name="adjustment_type" id="adjustmentType" class="form-select" required onchange="updateQuantityField()">
                                            <option value="">Select Type</option>
                                            <option value="add" <?php echo (isset($_POST['adjustment_type']) && $_POST['adjustment_type'] == 'add') ? 'selected' : ''; ?>>Add Stock</option>
                                            <option value="remove" <?php echo (isset($_POST['adjustment_type']) && $_POST['adjustment_type'] == 'remove') ? 'selected' : ''; ?>>Remove Stock</option>
                                            <option value="set" <?php echo (isset($_POST['adjustment_type']) && $_POST['adjustment_type'] == 'set') ? 'selected' : ''; ?>>Set Stock Level</option>
                                        </select>
                                        <div class="form-text">
                                            <strong>Add:</strong> Increase current stock<br>
                                            <strong>Remove:</strong> Decrease current stock<br>
                                            <strong>Set:</strong> Set exact stock level
                                        </div>
                                    </div>

<div class="mb-3">
                                        <label class="form-label" id="quantityLabel">Quantity to Add <span class="text-danger">*</span></label>
                                        <input type="number" name="quantity" id="quantityInput" class="form-control" 
                                               step="0.01" min="0.01" required 
                                               placeholder="Enter quantity"
                                               value="<?php echo htmlspecialchars($_POST['quantity'] ?? ''); ?>">
                                        <div class="form-text" id="quantityHelp">
                                            Enter the quantity you want to add to current stock
                                        </div>
                                    </div>

<div id="stockPreview" class="alert alert-warning d-none">
                                        <strong>Preview:</strong>
                                        <span id="previewText"></span>
                                    </div>

<div class="mb-3">
                                        <label class="form-label">Adjustment Notes</label>
                                        <textarea name="notes" class="form-control" rows="3" 
                                                  placeholder="Reason for stock adjustment (purchase, damage, correction, etc.)"><?php echo htmlspecialchars($_POST['notes'] ?? ''); ?></textarea>
                                        <div class="form-text">Optional notes for tracking purposes</div>
                                    </div>

<div class="d-grid gap-2">
                                        <button type="submit" name="adjust_stock" class="btn btn-primary btn-lg">
                                            <i class="fas fa-sync-alt me-2"></i> Update Stock
                                        </button>
                                        <button type="reset" class="btn btn-outline-secondary" onclick="resetForm()">
                                            <i class="fas fa-redo me-2"></i> Reset Form
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>

<div class="col-lg-6">
                        
                        <div class="card">
                            <div class="card-header bg-light d-flex justify-content-between align-items-center">
                                <h5 class="card-title mb-0">Recent Stock Adjustments</h5>
                                <a href="stock-history.php" class="btn btn-sm btn-outline-primary">View All</a>
                            </div>
                            <div class="card-body">
                                <?php if (mysqli_num_rows($recent_result) > 0): ?>
                                    <div class="table-responsive">
                                        <table class="table table-sm table-hover mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Product</th>
                                                    <th>Type</th>
                                                    <th class="text-end">Change</th>
                                                    <th class="text-end">New Qty</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($adjustment = mysqli_fetch_assoc($recent_result)): ?>
                                                <tr>
                                                    <td>
                                                        <small><?php echo date('M j', strtotime($adjustment['created_at'])); ?></small>
                                                    </td>
                                                    <td>
                                                        <div class="fw-semibold"><?php echo htmlspecialchars($adjustment['product_name']); ?></div>
                                                    </td>
                                                    <td>
                                                        <?php 
                                                        $type_badges = [
                                                            'stock_added' => 'success',
                                                            'stock_removed' => 'danger',
                                                            'stock_set' => 'warning',
                                                            'sale' => 'info',
                                                            'purchase' => 'primary'
                                                        ];
                                                        $type_names = [
                                                            'stock_added' => 'Added',
                                                            'stock_removed' => 'Removed',
                                                            'stock_set' => 'Set',
                                                            'sale' => 'Sale',
                                                            'purchase' => 'Purchase'
                                                        ];
                                                        ?>
                                                        <span class="badge bg-<?php echo $type_badges[$adjustment['change_type']] ?? 'secondary'; ?>">
                                                            <?php echo $type_names[$adjustment['change_type']] ?? ucfirst($adjustment['change_type']); ?>
                                                        </span>
                                                    </td>
                                                    <td class="text-end">
                                                        <?php if ($adjustment['quantity_change'] > 0): ?>
                                                            <span class="text-success fw-bold">
                                                                +<?php echo number_format($adjustment['quantity_change'], 2); ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="text-danger fw-bold">
                                                                <?php echo number_format($adjustment['quantity_change'], 2); ?>
                                                            </span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td class="text-end">
                                                        <strong><?php echo number_format($adjustment['new_quantity'], 2); ?></strong>
                                                        <div class="small text-muted"><?php echo $adjustment['quantity_unit']; ?></div>
                                                    </td>
                                                </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php else: ?>
                                    <div class="text-center py-4">
                                        <i class="fas fa-exchange-alt fa-2x text-muted mb-3"></i>
                                        <h6>No recent adjustments</h6>
                                        <p class="text-muted small">Stock adjustments will appear here</p>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Quick Actions</h5>
                            </div>
                            <div class="card-body">
                                <div class="d-grid gap-2">
                                    <a href="manage-products.php" class="btn btn-outline-primary">
                                        <i class="fas fa-cubes me-2"></i>Manage Products
                                    </a>
                                    <a href="stock-history.php" class="btn btn-outline-success">
                                        <i class="fas fa-history me-2"></i>View Stock History
                                    </a>
                                    <a href="add-product.php" class="btn btn-outline-info">
                                        <i class="fas fa-plus me-2"></i>Add New Product
                                    </a>
                                </div>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Adjustment Guide</h5>
                            </div>
                            <div class="card-body">
                                <div class="alert alert-light">
                                    <h6>When to use each type:</h6>
                                    <ul class="mb-0 small">
                                        <li><strong>Add Stock:</strong> New purchase, production, or returns</li>
                                        <li><strong>Remove Stock:</strong> Damage, wastage, or internal use</li>
                                        <strong>Set Stock:</strong> Correction, stocktake, or reconciliation</li>
                                    </ul>
                                </div>
                                <div class="alert alert-warning small">
                                    <i class="fas fa-exclamation-circle me-2"></i>
                                    <strong>Important:</strong> All adjustments are logged and cannot be undone. Always verify quantities before submitting.
                                </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 updateQuantityField() {
    const adjustmentType = document.getElementById('adjustmentType').value;
    const quantityLabel = document.getElementById('quantityLabel');
    const quantityHelp = document.getElementById('quantityHelp');
    
    switch(adjustmentType) {
        case 'add':
            quantityLabel.textContent = 'Quantity to Add *';
            quantityHelp.textContent = 'Enter the quantity you want to add to current stock';
            break;
        case 'remove':
            quantityLabel.textContent = 'Quantity to Remove *';
            quantityHelp.textContent = 'Enter the quantity you want to remove from current stock';
            break;
        case 'set':
            quantityLabel.textContent = 'New Stock Level *';
            quantityHelp.textContent = 'Enter the exact quantity you want to set as stock level';
            break;
        default:
            quantityLabel.textContent = 'Quantity *';
            quantityHelp.textContent = 'Enter the quantity';
    }
    
    updateStockPreview();
}

function resetForm() {
    document.getElementById('currentStockInfo').classList.add('d-none');
    document.getElementById('stockPreview').classList.add('d-none');
    setTimeout(() => {
        updateQuantityField();
    }, 100);
}

// Event listeners
document.addEventListener('DOMContentLoaded', function() {
    const quantityInput = document.getElementById('quantityInput');
    const productSelect = document.getElementById('productSelect');
    const adjustmentType = document.getElementById('adjustmentType');
    
    quantityInput.addEventListener('input', updateStockPreview);
    productSelect.addEventListener('change', updateProductInfo);
    adjustmentType.addEventListener('change', updateStockPreview);
    
    // Initialize form state
    updateQuantityField();
    updateProductInfo();
    
    // Auto-focus on product select
    productSelect.focus();
});

// Confirm before form submission
document.getElementById('stockAdjustmentForm').addEventListener('submit', function(e) {
    const productSelect = document.getElementById('productSelect');
    const adjustmentType = document.getElementById('adjustmentType').value;
    const quantityInput = document.getElementById('quantityInput');
    const selectedProduct = productSelect.options[productSelect.selectedIndex].text;
    
    const confirmationMessage = `Are you sure you want to ${adjustmentType} ${quantityInput.value} units of ${selectedProduct}?`;
    
    if (!confirm(confirmationMessage)) {
        e.preventDefault();
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock-adjustment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation