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/bakery/branch

Free Space:

10.32 TB

🔧 Quick Actions

✏️ Editing: foods_adjust.php

<?php
// foods_adjust.php - Stock Adjustment (Increase/Decrease)
session_start();
require_once 'config/db_config.php';

if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || !in_array($_SESSION['role'], ['branch', 'warehouse_manager'])) {
    header("Location: login.php");
    exit();
}

$user_branch_id = $_SESSION['branch_id'] ?? null;
if (!$user_branch_id) {
    header("Location: login.php");
    exit();
}

if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}

$csrf = $_SESSION['csrf_token'];
function h(string $v): string { return htmlspecialchars($v, ENT_QUOTES, 'UTF-8'); }

// Get branch name
$branch_name = '';
try {
    $stmt = $pdo->prepare("SELECT branch_name FROM branches WHERE branch_id = ?");
    $stmt->execute([$user_branch_id]);
    $branch = $stmt->fetch(PDO::FETCH_ASSOC);
    $branch_name = $branch['branch_name'] ?? 'Your Branch';
} catch (PDOException $e) {
    $branch_name = 'Your Branch';
}

// Create stock_adjustments table if it doesn't exist (do this before any operations)
try {
    $pdo->query("
        CREATE TABLE IF NOT EXISTS stock_adjustments (
            adjustment_id INT AUTO_INCREMENT PRIMARY KEY,
            branch_food_id INT NOT NULL,
            food_id INT NOT NULL,
            branch_id INT NOT NULL,
            adjustment_type ENUM('increase', 'decrease') NOT NULL,
            adjustment_quantity DECIMAL(10,3) NOT NULL,
            previous_quantity DECIMAL(10,3) NOT NULL,
            new_quantity DECIMAL(10,3) NOT NULL,
            stock_unit ENUM('gram','kg','piece','pack','box','dozen') NOT NULL,
            reason VARCHAR(255) NOT NULL,
            notes TEXT,
            adjusted_by INT NOT NULL,
            adjusted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    ");
} catch (Exception $e) {
    // Silently fail - table might already exist
    error_log("Table creation note: " . $e->getMessage());
}

// Fetch food items for this branch
try {
    $query = "
        SELECT
            f.food_id, f.food_name, fc.category_name,
            bfs.price_per_unit, bfs.quantity, bfs.stock_unit, bfs.display_unit,
            bfs.image_url, bfs.is_available,
            bf.branch_food_id,
            GROUP_CONCAT(fb.barcode) AS barcodes
        FROM foods f
        LEFT JOIN food_categories fc ON f.category_id = fc.category_id
        JOIN branch_foods bf ON f.food_id = bf.food_id
        JOIN branch_food_stock bfs ON bf.branch_food_id = bfs.branch_food_id
        LEFT JOIN food_barcodes fb ON f.food_id = fb.food_id AND fb.branch_id = ?
        WHERE bf.branch_id = ? AND bf.status = 'active'
        GROUP BY f.food_id
        ORDER BY f.food_name COLLATE utf8mb4_unicode_ci
    ";
    $stmt = $pdo->prepare($query);
    $stmt->execute([$user_branch_id, $user_branch_id]);
    $foods = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    foreach ($foods as &$food) {
        $food['barcodes'] = $food['barcodes'] ? explode(',', $food['barcodes']) : [];
        // Convert kg to grams for easier calculation
        if ($food['stock_unit'] === 'kg') {
            $food['display_quantity'] = $food['quantity'] * 1000;
            $food['display_unit'] = 'gram';
        } else {
            $food['display_quantity'] = $food['quantity'];
            $food['display_unit'] = $food['stock_unit'];
        }
    }
    unset($food);
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching foods: " . h($e->getMessage());
    $foods = [];
}

// Handle form submission for stock adjustment
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['csrf']) && $_POST['csrf'] === $csrf) {
    $food_id = $_POST['food_id'] ?? 0;
    $adjustment_type = $_POST['adjustment_type'] ?? ''; // 'increase' or 'decrease'
    $adjustment_quantity = $_POST['adjustment_quantity'] ?? 0;
    $reason = trim($_POST['reason'] ?? '');
    $notes = trim($_POST['notes'] ?? '');
    
    $errors = [];
    
    // Validate inputs
    if (!$food_id || !is_numeric($food_id)) {
        $errors[] = "Please select a valid food item.";
    }
    
    if (!in_array($adjustment_type, ['increase', 'decrease'])) {
        $errors[] = "Invalid adjustment type.";
    }
    
    if (!is_numeric($adjustment_quantity) || $adjustment_quantity <= 0) {
        $errors[] = "Adjustment quantity must be a positive number.";
    }
    
    if (empty($reason)) {
        $errors[] = "Please provide a reason for the adjustment.";
    }
    
    // Find the selected food
    $selected_food = null;
    $branch_food_id = null;
    if (!$errors) {
        foreach ($foods as $food) {
            if ($food['food_id'] == $food_id) {
                $selected_food = $food;
                $branch_food_id = $food['branch_food_id'];
                break;
            }
        }
        if (!$selected_food) {
            $errors[] = "Selected food not found in your branch.";
        }
    }
    
    // Process adjustment if no errors
    if (empty($errors) && $selected_food && $branch_food_id) {
        try {
            $pdo->beginTransaction();
            
            // Get current stock details
            $stmt = $pdo->prepare("
                SELECT quantity, stock_unit, display_unit 
                FROM branch_food_stock 
                WHERE branch_food_id = ?
            ");
            $stmt->execute([$branch_food_id]);
            $current_stock = $stmt->fetch(PDO::FETCH_ASSOC);
            
            if (!$current_stock) {
                throw new Exception("Food stock information not found.");
            }
            
            $current_quantity = (float)$current_stock['quantity'];
            $stock_unit = $current_stock['stock_unit'];
            $display_unit = $current_stock['display_unit'];
            
            // Calculate new quantity
            $adjustment_value = (float)$adjustment_quantity;
            
            // If stock unit is kg, convert adjustment to grams for calculation
            if ($stock_unit === 'kg') {
                $adjustment_value *= 1000;
            }
            
            if ($adjustment_type === 'increase') {
                $new_quantity = $current_quantity + $adjustment_value;
            } else { // decrease
                if ($adjustment_value > $current_quantity) {
                    throw new Exception("Cannot decrease more than current stock. Current: " . 
                        ($stock_unit === 'kg' ? $current_quantity/1000 : $current_quantity) . " " . $stock_unit);
                }
                $new_quantity = $current_quantity - $adjustment_value;
            }
            
            // Update stock
            $stmt = $pdo->prepare("
                UPDATE branch_food_stock 
                SET quantity = ? 
                WHERE branch_food_id = ?
            ");
            $stmt->execute([$new_quantity, $branch_food_id]);
            
            // Log the adjustment
            try {
                $stmt = $pdo->prepare("
                    INSERT INTO stock_adjustments 
                    (branch_food_id, food_id, branch_id, adjustment_type, adjustment_quantity, 
                     previous_quantity, new_quantity, stock_unit, reason, notes, adjusted_by)
                    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                ");
                $stmt->execute([
                    $branch_food_id,
                    $food_id,
                    $user_branch_id,
                    $adjustment_type,
                    $adjustment_quantity,
                    $current_quantity,
                    $new_quantity,
                    $stock_unit,
                    $reason,
                    $notes ?: null,
                    $_SESSION['user_id']
                ]);
            } catch (Exception $e) {
                // If log fails, continue but log error
                error_log("Stock adjustment log failed: " . $e->getMessage());
            }
            
            $pdo->commit();
            
            // Format display values
            $display_current = $stock_unit === 'kg' ? $current_quantity/1000 : $current_quantity;
            $display_adjustment = $adjustment_quantity;
            $display_new = $stock_unit === 'kg' ? $new_quantity/1000 : $new_quantity;
            
            $_SESSION['success'] = "Stock adjusted successfully!<br>" .
                "Food: <strong>" . h($selected_food['food_name']) . "</strong><br>" .
                "Adjustment: <strong>" . ($adjustment_type === 'increase' ? '+' : '-') . 
                number_format($display_adjustment, 3) . " " . $stock_unit . "</strong><br>" .
                "Previous: " . number_format($display_current, 3) . " " . $stock_unit . " → " .
                "New: " . number_format($display_new, 3) . " " . $stock_unit;
            
            header("Location: foods_adjust.php");
            exit();
            
        } catch (Exception $e) {
            if ($pdo->inTransaction()) {
                $pdo->rollBack();
            }
            $errors[] = "Error adjusting stock: " . h($e->getMessage());
        }
    }
    
    // If there were errors, show them
    if (!empty($errors)) {
        $_SESSION['error'] = implode("<br>", $errors);
        header("Location: foods_adjust.php");
        exit();
    }
}

// Fetch recent adjustments for display
$recent_adjustments = [];
try {
    $query = "
        SELECT 
            sa.*,
            f.food_name,
            u.full_name as adjusted_by_name,
            sa.adjusted_at as adjustment_date
        FROM stock_adjustments sa
        JOIN foods f ON sa.food_id = f.food_id
        LEFT JOIN users u ON sa.adjusted_by = u.user_id
        WHERE sa.branch_id = ?
        ORDER BY sa.adjusted_at DESC
        LIMIT 20
    ";
    $stmt = $pdo->prepare($query);
    $stmt->execute([$user_branch_id]);
    $recent_adjustments = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
    // Table might not exist yet, that's okay
    $recent_adjustments = [];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Stock Adjustment - <?= h($branch_name) ?></title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.6.0/css/all.min.css" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <style>
        .fa-icon { font-size: 16px; margin-right: 4px; }
        .section-title { font-size: 1rem; color: #4361ee; font-weight: 600; }
        .card-shadow { box-shadow: 0 2px 4px rgba(0,0,0,0.1); }
        .total-price-box { background: #f8f9fa; border-radius: 10px; padding: 1rem; text-align: center; font-size: 0.9rem; border: 2px solid #4361ee; }
        .total-price-value { font-size: 1.4rem; font-weight: 800; color: #4361ee; }
        .adjustment-form-card { border-left: 4px solid #4361ee; }
        .adjustment-history-card { border-left: 4px solid #10b981; }
        .adjustment-increase { color: #10b981; font-weight: 600; }
        .adjustment-decrease { color: #ef4444; font-weight: 600; }
        .food-select-card { border: 1px solid #e5e7eb; border-radius: 8px; padding: 1rem; cursor: pointer; transition: all 0.2s; }
        .food-select-card:hover { border-color: #4361ee; background-color: #f8fafc; }
        .food-select-card.selected { border-color: #4361ee; background-color: #eef2ff; }
        .food-image { width: 50px; height: 50px; object-fit: cover; border-radius: 6px; }
        .quantity-display { font-size: 1.1rem; font-weight: 600; color: #1f2937; }
        .stock-unit { color: #6b7280; font-size: 0.9rem; }
        @media (max-width: 768px) { .dashboard-main-body { padding-bottom: 80px; } }
    </style>
</head>
<body>
    <?php include './partials/layouts/layoutTop.php'; ?>
    
    <div class="dashboard-main-body">
        <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-16">
            <h6 class="fw-semibold mb-0 text-lg">Stock Adjustment - <?= h($branch_name) ?></h6>
            <ul class="d-flex align-items-center gap-1 text-sm">
                <li><a href="index.php" class="d-flex align-items-center gap-1 hover-text-primary"><i class="fas fa-home fa-icon"></i> Dashboard</a></li>
                <li>-</li>
                <li><a href="foods_list.php" class="hover-text-primary">Foods</a></li>
                <li>-</li>
                <li class="text-primary">Stock Adjustment</li>
            </ul>
        </div>

<?php if (!empty($_SESSION['success'])): ?>
            <div class="alert alert-success alert-dismissible fade show mb-24" role="alert">
                <i class="fas fa-check-circle fa-icon"></i>
                <?= $_SESSION['success']; unset($_SESSION['success']); ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        <?php endif; ?>
        
        <?php if (!empty($_SESSION['error'])): ?>
            <div class="alert alert-danger alert-dismissible fade show mb-24" role="alert">
                <i class="fas fa-exclamation-circle fa-icon"></i>
                <?= h($_SESSION['error']); unset($_SESSION['error']); ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        <?php endif; ?>

<div class="card card-shadow adjustment-form-card mb-24">
            <div class="card-header">
                <h6 class="section-title mb-0 text-md"><i class="fas fa-exchange-alt fa-icon"></i> Adjust Stock Quantity</h6>
            </div>
            <div class="card-body p-16">
                <form method="POST" id="adjustmentForm" class="row g-3">
                    <input type="hidden" name="csrf" value="<?= h($csrf) ?>">
                    
                    
                    <div class="col-12 mb-16">
                        <h6 class="text-sm mb-3 fw-semibold"><i class="fas fa-utensils fa-icon"></i> Step 1: Select Food Item</h6>
                        <?php if (empty($foods)): ?>
                            <div class="alert alert-warning">
                                <i class="fas fa-exclamation-triangle fa-icon"></i>
                                No food items found in your branch. <a href="foods_add.php" class="alert-link">Add food items first</a>.
                            </div>
                        <?php else: ?>
                            <div class="row row-cols-1 row-cols-md-2 row-cols-lg-3 g-3" id="foodSelection">
                                <?php foreach ($foods as $food): ?>
                                    <?php 
                                    $display_qty = $food['display_quantity'];
                                    $display_unit = $food['display_unit'];
                                    ?>
                                    <div class="col">
                                        <div class="food-select-card" data-food-id="<?= h($food['food_id']) ?>" 
                                             data-food-name="<?= h($food['food_name']) ?>"
                                             data-current-quantity="<?= h($display_qty) ?>"
                                             data-stock-unit="<?= h($food['stock_unit']) ?>"
                                             data-display-unit="<?= h($display_unit) ?>">
                                            <div class="d-flex align-items-center gap-3">
                                                <img src="<?= h($food['image_url'] ? '../' . $food['image_url'] : 'assets/images/food/default.png') ?>" 
                                                     alt="<?= h($food['food_name']) ?>" class="food-image">
                                                <div class="flex-grow-1">
                                                    <h6 class="mb-1 text-sm fw-semibold"><?= h($food['food_name']) ?></h6>
                                                    <div class="d-flex justify-content-between align-items-center">
                                                        <span class="badge bg-primary text-white text-sm">
                                                            <?= h($food['category_name']) ?>
                                                        </span>
                                                        <div class="text-end">
                                                            <div class="quantity-display">
                                                                <?= number_format($display_qty, $food['stock_unit'] === 'kg' ? 3 : 0) ?>
                                                            </div>
                                                            <small class="stock-unit">
                                                                <?= h($display_unit) ?>
                                                            </small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                            <input type="hidden" name="food_id" id="selectedFoodId" required>
                        <?php endif; ?>
                    </div>
                    
                    
                    <div class="col-12" id="adjustmentDetails" style="display: none;">
                        <h6 class="text-sm mb-3 fw-semibold"><i class="fas fa-sliders-h fa-icon"></i> Step 2: Adjustment Details</h6>
                        <div class="row g-3">
                            
                            <div class="col-md-6">
                                <div class="total-price-box">
                                    <p class="text-sm mb-1"><i class="fas fa-box fa-icon"></i> Current Stock</p>
                                    <h6 class="total-price-value" id="currentStockDisplay">0</h6>
                                    <p class="text-muted text-sm mb-0" id="currentUnitDisplay">unit</p>
                                </div>
                            </div>
                            
                            
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <small>Adjustment Type <span class="text-danger">*</span></small>
                                    <div class="btn-group w-100" role="group">
                                        <input type="radio" class="btn-check" name="adjustment_type" id="increase" value="increase" autocomplete="off" required>
                                        <label class="btn btn-outline-success" for="increase">
                                            <i class="fas fa-plus fa-icon"></i> Increase Stock
                                        </label>
                                        <input type="radio" class="btn-check" name="adjustment_type" id="decrease" value="decrease" autocomplete="off">
                                        <label class="btn btn-outline-danger" for="decrease">
                                            <i class="fas fa-minus fa-icon"></i> Decrease Stock
                                        </label>
                                    </div>
                                </div>
                            </div>
                            
                            
                            <div class="col-md-6">
                                <small>Adjustment Quantity <span class="text-danger">*</span></small>
                                <div class="input-group">
                                    <input type="number" step="0.001" min="0.001" name="adjustment_quantity" 
                                           id="adjustment_quantity" class="form-control form-control-sm" required>
                                    <span class="input-group-text" id="adjustmentUnit">unit</span>
                                </div>
                                <small class="text-muted">Enter the quantity to add or remove</small>
                            </div>
                            
                            
                            <div class="col-md-6">
                                <div class="total-price-box">
                                    <p class="text-sm mb-1"><i class="fas fa-calculator fa-icon"></i> New Stock After Adjustment</p>
                                    <h6 class="total-price-value" id="newStockDisplay">0</h6>
                                    <p class="text-muted text-sm mb-0" id="newUnitDisplay">unit</p>
                                </div>
                            </div>
                            
                            
                            <div class="col-12">
                                <small>Reason for Adjustment <span class="text-danger">*</span></small>
                                <select name="reason" id="reason" class="form-select form-select-sm" required>
                                    <option value="">Select Reason</option>
                                    <option value="restock">Restock from Supplier</option>
                                    <option value="damaged">Damaged/Expired Items</option>
                                    <option value="waste">Kitchen/Preparation Waste</option>
                                    <option value="theft">Theft/Loss</option>
                                    <option value="correction">Stock Count Correction</option>
                                    <option value="transfer">Branch Transfer</option>
                                    <option value="other">Other</option>
                                </select>
                            </div>
                            
                            
                            <div class="col-12">
                                <small>Additional Notes (Optional)</small>
                                <textarea name="notes" id="notes" class="form-control form-control-sm" rows="2" 
                                          placeholder="Any additional details about this adjustment..."></textarea>
                            </div>
                            
                            
                            <div class="col-12 text-end mt-3">
                                <button type="button" class="btn btn-outline-secondary btn-sm me-2" id="backToSelection">
                                    <i class="fas fa-arrow-left fa-icon"></i> Back to Food Selection
                                </button>
                                <button type="submit" class="btn btn-primary btn-sm">
                                    <i class="fas fa-check-circle fa-icon"></i> Apply Stock Adjustment
                                </button>
                            </div>
                        </div>
                    </div>
                </form>
            </div>
        </div>

<?php if (!empty($recent_adjustments)): ?>
        <div class="card card-shadow adjustment-history-card">
            <div class="card-header">
                <h6 class="section-title mb-0 text-md"><i class="fas fa-history fa-icon"></i> Recent Stock Adjustments</h6>
            </div>
            <div class="card-body p-16">
                <div class="table-responsive">
                    <table class="table bordered-table sm-table mb-0" id="adjustmentsTable">
                        <thead>
                            <tr>
                                <th>Date</th>
                                <th>Food Item</th>
                                <th>Adjustment</th>
                                <th>Previous Qty</th>
                                <th>New Qty</th>
                                <th>Reason</th>
                                <th>Adjusted By</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($recent_adjustments as $adj): ?>
                                <?php 
                                // Format quantities for display
                                $prev_qty = $adj['stock_unit'] === 'kg' ? $adj['previous_quantity']/1000 : $adj['previous_quantity'];
                                $new_qty = $adj['stock_unit'] === 'kg' ? $adj['new_quantity']/1000 : $adj['new_quantity'];
                                $adj_qty = $adj['stock_unit'] === 'kg' ? $adj['adjustment_quantity']/1000 : $adj['adjustment_quantity'];
                                ?>
                                <tr>
                                    <td class="text-sm">
                                        <?= date('d M, H:i', strtotime($adj['adjustment_date'])) ?>
                                    </td>
                                    <td class="text-sm">
                                        <strong><?= h($adj['food_name']) ?></strong>
                                    </td>
                                    <td class="text-sm">
                                        <span class="badge <?= $adj['adjustment_type'] === 'increase' ? 'bg-success' : 'bg-danger' ?> text-white">
                                            <?= $adj['adjustment_type'] === 'increase' ? '+' : '-' ?>
                                            <?= number_format($adj_qty, 3) ?> <?= h($adj['stock_unit']) ?>
                                        </span>
                                    </td>
                                    <td class="text-sm">
                                        <?= number_format($prev_qty, 3) ?> <?= h($adj['stock_unit']) ?>
                                    </td>
                                    <td class="text-sm">
                                        <?= number_format($new_qty, 3) ?> <?= h($adj['stock_unit']) ?>
                                    </td>
                                    <td class="text-sm">
                                        <?= h($adj['reason']) ?>
                                        <?php if ($adj['notes']): ?>
                                            <br><small class="text-muted"><?= h($adj['notes']) ?></small>
                                        <?php endif; ?>
                                    </td>
                                    <td class="text-sm">
                                        <?= h($adj['adjusted_by_name'] ?? 'Unknown') ?>
                                    </td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <?php endif; ?>
    </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: foods_adjust.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation