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

🔧 Quick Actions

✏️ Editing: edit-purchase.php

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

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

// Check if user is admin
if ($_SESSION['user_role'] !== 'admin') {
    $_SESSION['error'] = "You don't have permission to edit purchases.";
    header("Location: purchase-list.php");
    exit();
}

$purchase_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch purchase details
$query = "SELECT p.*, s.supplier_name, s.phone as supplier_phone
          FROM purchases p
          LEFT JOIN suppliers s ON p.supplier_id = s.id
          WHERE p.id = $purchase_id";

$result = mysqli_query($conn, $query);
$purchase = mysqli_fetch_assoc($result);

if (!$purchase) {
    $_SESSION['error'] = "Purchase not found!";
    header("Location: purchase-list.php");
    exit();
}

// Fetch purchase items
$itemsQuery = "SELECT pi.*, pr.product_name, pr.product_code, b.brand_name, 
               pr.color, pr.size, pr.category_id, c.category_name,
               pr.customer_price as selling_price
               FROM purchase_items pi
               LEFT JOIN products pr ON pi.product_id = pr.id
               LEFT JOIN brands b ON pr.brand_id = b.id
               LEFT JOIN categories c ON pr.category_id = c.id
               WHERE pi.purchase_id = $purchase_id
               ORDER BY pi.id";
$itemsResult = mysqli_query($conn, $itemsQuery);
$existing_items = [];
while ($item = mysqli_fetch_assoc($itemsResult)) {
    $existing_items[] = $item;
}

// Fetch suppliers for dropdown
$suppliers = [];
$supplierQuery = "SELECT id, supplier_name, phone FROM suppliers WHERE status = 'active' ORDER BY supplier_name";
$supplierResult = mysqli_query($conn, $supplierQuery);
if ($supplierResult) {
    while ($row = mysqli_fetch_assoc($supplierResult)) {
        $suppliers[] = $row;
    }
}

// Fetch products for dropdown
$products = [];
$productQuery = "SELECT p.id, p.product_name, p.product_code, b.brand_name, p.color, p.size, p.stock_price 
                 FROM products p 
                 LEFT JOIN brands b ON p.brand_id = b.id 
                 ORDER BY p.product_name";
$productResult = mysqli_query($conn, $productQuery);
if ($productResult) {
    while ($row = mysqli_fetch_assoc($productResult)) {
        $products[] = $row;
    }
}

// Fetch brands for new product
$brands = [];
$brandQuery = "SELECT id, brand_name FROM brands WHERE status = 'active' ORDER BY brand_name";
$brandResult = mysqli_query($conn, $brandQuery);
if ($brandResult) {
    while ($row = mysqli_fetch_assoc($brandResult)) {
        $brands[] = $row;
    }
}

// Fetch categories for new product
$categories = [];
$catQuery = "SELECT id, category_name FROM categories WHERE status = 'active' ORDER BY category_name";
$catResult = mysqli_query($conn, $catQuery);
if ($catResult) {
    while ($row = mysqli_fetch_assoc($catResult)) {
        $categories[] = $row;
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        mysqli_begin_transaction($conn);
        
        // Get form data
        $supplier_id = mysqli_real_escape_string($conn, $_POST['supplier_id']);
        $reference_no = mysqli_real_escape_string($conn, $_POST['reference_no']);
        $purchase_date = mysqli_real_escape_string($conn, $_POST['purchase_date']);
        $payment_method = mysqli_real_escape_string($conn, $_POST['payment_method']);
        $notes = mysqli_real_escape_string($conn, $_POST['notes']);
        
        // Update purchase header
        $updateQuery = "UPDATE purchases SET 
                       supplier_id = '$supplier_id',
                       reference_no = '$reference_no',
                       purchase_date = '$purchase_date',
                       payment_method = '$payment_method',
                       notes = '$notes',
                       updated_at = NOW()
                       WHERE id = $purchase_id";
        
        if (!mysqli_query($conn, $updateQuery)) {
            throw new Exception("Failed to update purchase: " . mysqli_error($conn));
        }
        
        // Handle item deletions
        if (isset($_POST['delete_items'])) {
            foreach ($_POST['delete_items'] as $item_id => $value) {
                $item_id = intval($item_id);
                
                // Get item details before deletion
                $itemQuery = "SELECT product_id, quantity FROM purchase_items WHERE id = $item_id";
                $itemResult = mysqli_query($conn, $itemQuery);
                $item = mysqli_fetch_assoc($itemResult);
                
                if ($item) {
                    // Restore product stock (subtract quantity)
                    $product_id = $item['product_id'];
                    $quantity = $item['quantity'];
                    $updateStockQuery = "UPDATE products SET quantity = quantity - $quantity WHERE id = $product_id";
                    mysqli_query($conn, $updateStockQuery);
                    
                    // Delete the purchase item
                    $deleteQuery = "DELETE FROM purchase_items WHERE id = $item_id";
                    mysqli_query($conn, $deleteQuery);
                }
            }
        }
        
        // Process updated items
        if (isset($_POST['existing_items'])) {
            $existing_items_data = $_POST['existing_items'];
            
            foreach ($existing_items_data as $item_id => $item_data) {
                $item_id = intval($item_id);
                $quantity = intval($item_data['quantity']);
                $unit_price = floatval($item_data['unit_price']);
                $total_price = $quantity * $unit_price;
                
                // Get current item details
                $currentItemQuery = "SELECT * FROM purchase_items WHERE id = $item_id";
                $currentItemResult = mysqli_query($conn, $currentItemQuery);
                $currentItem = mysqli_fetch_assoc($currentItemResult);
                
                if ($currentItem) {
                    // Calculate quantity difference
                    $quantity_diff = $quantity - $currentItem['quantity'];
                    
                    // Update purchase item
                    $updateItemQuery = "UPDATE purchase_items SET 
                                       quantity = $quantity,
                                       unit_price = $unit_price,
                                       total_price = $total_price
                                       WHERE id = $item_id";
                    
                    if (!mysqli_query($conn, $updateItemQuery)) {
                        throw new Exception("Failed to update item: " . mysqli_error($conn));
                    }
                    
                    // Update product stock
                    if ($quantity_diff != 0) {
                        $product_id = $currentItem['product_id'];
                        $updateStockQuery = "UPDATE products SET quantity = quantity + $quantity_diff WHERE id = $product_id";
                        if (!mysqli_query($conn, $updateStockQuery)) {
                            throw new Exception("Failed to update product stock: " . mysqli_error($conn));
                        }
                    }
                }
            }
        }
        
        // Handle new items
        if (isset($_POST['new_items'])) {
            $new_items = $_POST['new_items'];
            $new_item_count = count($new_items['product_type']);
            
            for ($i = 0; $i < $new_item_count; $i++) {
                $product_type = $new_items['product_type'][$i];
                $quantity = intval($new_items['quantity'][$i]);
                $unit_price = floatval($new_items['unit_price'][$i]);
                $total_price = $quantity * $unit_price;
                
                if ($product_type === 'existing') {
                    $product_id = $new_items['product_id'][$i];
                    
                    if ($product_id) {
                        // Add new purchase item for existing product
                        $insertItemQuery = "INSERT INTO purchase_items (purchase_id, product_id, quantity, unit_price, total_price) 
                                           VALUES ($purchase_id, $product_id, $quantity, $unit_price, $total_price)";
                        
                        if (!mysqli_query($conn, $insertItemQuery)) {
                            throw new Exception("Failed to add new item: " . mysqli_error($conn));
                        }
                        
                        // Update product stock
                        $updateStockQuery = "UPDATE products SET quantity = quantity + $quantity WHERE id = $product_id";
                        if (!mysqli_query($conn, $updateStockQuery)) {
                            throw new Exception("Failed to update product stock: " . mysqli_error($conn));
                        }
                    }
                } else if ($product_type === 'new') {
                    // Add new product
                    $product_name = mysqli_real_escape_string($conn, $new_items['new_name'][$i]);
                    $brand_input = mysqli_real_escape_string($conn, $new_items['brand'][$i]);
                    $color = mysqli_real_escape_string($conn, $new_items['color'][$i]);
                    $size = mysqli_real_escape_string($conn, $new_items['size'][$i]);
                    $category_id = mysqli_real_escape_string($conn, $new_items['category'][$i]);
                    $selling_price = floatval($new_items['selling_price'][$i]);
                    
                    // Handle brand - check if it exists or create new
                    if (is_numeric($brand_input)) {
                        // Existing brand selected
                        $brand_id = $brand_input;
                    } else {
                        // New brand - create it
                        $brand_name = $brand_input;
                        $brandCheck = mysqli_query($conn, "SELECT id FROM brands WHERE brand_name = '$brand_name'");
                        
                        if (mysqli_num_rows($brandCheck) > 0) {
                            $brandRow = mysqli_fetch_assoc($brandCheck);
                            $brand_id = $brandRow['id'];
                        } else {
                            $brandQuery = "INSERT INTO brands (brand_name) VALUES ('$brand_name')";
                            if (!mysqli_query($conn, $brandQuery)) {
                                throw new Exception("Failed to create brand: " . mysqli_error($conn));
                            }
                            $brand_id = mysqli_insert_id($conn);
                        }
                    }
                    
                    // Generate product code
                    $product_code = strtoupper(substr($product_name, 0, 3)) . '-' . date('Ymd') . '-' . rand(100, 999);
                    
                    // Calculate profit
                    $profit = $selling_price - $unit_price;
                    $profit_percentage = $unit_price > 0 ? ($profit / $unit_price * 100) : 0;
                    
                    // Insert new product
                    $newProductQuery = "INSERT INTO products (product_name, brand_id, color, size, category_id, product_code, 
                                      stock_price, customer_price, profit, profit_percentage, quantity) 
                                      VALUES ('$product_name', '$brand_id', '$color', '$size', '$category_id', '$product_code',
                                      '$unit_price', '$selling_price', '$profit', '$profit_percentage', '$quantity')";
                    
                    if (!mysqli_query($conn, $newProductQuery)) {
                        throw new Exception("Failed to create new product: " . mysqli_error($conn));
                    }
                    
                    $new_product_id = mysqli_insert_id($conn);
                    
                    // Insert purchase item for the new product
                    $insertItemQuery = "INSERT INTO purchase_items (purchase_id, product_id, quantity, unit_price, total_price) 
                                       VALUES ($purchase_id, $new_product_id, $quantity, $unit_price, $total_price)";
                    
                    if (!mysqli_query($conn, $insertItemQuery)) {
                        throw new Exception("Failed to add purchase item for new product: " . mysqli_error($conn));
                    }
                }
            }
        }
        
        // Recalculate total amount
        $recalcQuery = "SELECT SUM(total_price) as new_total FROM purchase_items WHERE purchase_id = $purchase_id";
        $recalcResult = mysqli_query($conn, $recalcQuery);
        $recalcRow = mysqli_fetch_assoc($recalcResult);
        $new_total = $recalcRow['new_total'] ?? 0;
        
        // Update purchase total
        $updateTotalQuery = "UPDATE purchases SET total_amount = $new_total, grand_total = $new_total WHERE id = $purchase_id";
        if (!mysqli_query($conn, $updateTotalQuery)) {
            throw new Exception("Failed to update purchase total: " . mysqli_error($conn));
        }
        
        mysqli_commit($conn);
        $_SESSION['success'] = "Purchase updated successfully!";
        header("Location: purchase-details.php?id=$purchase_id");
        exit();
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $_SESSION['error'] = $e->getMessage();
    }
}
?>

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

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

<?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">

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

<div class="row">
                <div class="col-xl-12">
                    <div class="card">
                        <div class="card-body">
                            <h4 class="card-title mb-4">Edit Purchase Details</h4>

<form method="POST" action="" id="editPurchaseForm">
                                
                                <div class="row mb-4">
                                    <div class="col-md-12">
                                        <h5 class="border-bottom pb-2 text-primary">Purchase Information</h5>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <div class="form-group">
                                            <label for="supplier_id" class="form-label">Supplier *</label>
                                            <select name="supplier_id" id="supplier_id" class="form-control" required>
                                                <option value="">-- Select Supplier --</option>
                                                <?php foreach ($suppliers as $supplier): ?>
                                                    <option value="<?php echo $supplier['id']; ?>" 
                                                        <?php echo ($purchase['supplier_id'] == $supplier['id']) ? 'selected' : ''; ?>>
                                                        <?php echo htmlspecialchars($supplier['supplier_name'] . ' (' . $supplier['phone'] . ')'); ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <div class="form-group">
                                            <label for="reference_no" class="form-label">Reference Number *</label>
                                            <input type="text" name="reference_no" id="reference_no" class="form-control" 
                                                   value="<?php echo htmlspecialchars($purchase['reference_no']); ?>" required>
                                        </div>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <div class="form-group">
                                            <label for="purchase_date" class="form-label">Purchase Date *</label>
                                            <input type="date" name="purchase_date" id="purchase_date" class="form-control" 
                                                   value="<?php echo date('Y-m-d', strtotime($purchase['purchase_date'])); ?>" required>
                                        </div>
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <div class="form-group">
                                            <label for="payment_method" class="form-label">Payment Method *</label>
                                            <select name="payment_method" id="payment_method" class="form-control" required>
                                                <option value="cash" <?php echo ($purchase['payment_method'] == 'cash') ? 'selected' : ''; ?>>Cash</option>
                                                <option value="bank_transfer" <?php echo ($purchase['payment_method'] == 'bank_transfer') ? 'selected' : ''; ?>>Bank Transfer</option>
                                                <option value="cheque" <?php echo ($purchase['payment_method'] == 'cheque') ? 'selected' : ''; ?>>Cheque</option>
                                                <option value="card" <?php echo ($purchase['payment_method'] == 'card') ? 'selected' : ''; ?>>Card</option>
                                                <option value="credit" <?php echo ($purchase['payment_method'] == 'credit') ? 'selected' : ''; ?>>Credit</option>
                                                <option value="online" <?php echo ($purchase['payment_method'] == 'online') ? 'selected' : ''; ?>>Online</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-8 mb-3">
                                        <div class="form-group">
                                            <label for="notes" class="form-label">Notes</label>
                                            <textarea name="notes" id="notes" class="form-control" rows="2"><?php echo htmlspecialchars($purchase['notes'] ?? ''); ?></textarea>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="row mb-4">
                                    <div class="col-md-12">
                                        <h5 class="border-bottom pb-2 text-primary">Existing Items</h5>
                                        <?php if (!empty($existing_items)): ?>
                                            <?php foreach ($existing_items as $index => $item): ?>
                                                <div class="card mb-3 existing-item-row" id="existingItem_<?php echo $item['id']; ?>">
                                                    <div class="card-body">
                                                        <div class="row">
                                                            <div class="col-md-4 mb-3">
                                                                <div class="form-group">
                                                                    <label class="form-label">Product</label>
                                                                    <input type="text" class="form-control" value="<?php echo htmlspecialchars($item['product_name']); ?>" readonly>
                                                                    <input type="hidden" name="existing_items[<?php echo $item['id']; ?>][product_id]" value="<?php echo $item['product_id']; ?>">
                                                                </div>
                                                            </div>
                                                            <div class="col-md-2 mb-3">
                                                                <div class="form-group">
                                                                    <label class="form-label">Quantity *</label>
                                                                    <input type="number" name="existing_items[<?php echo $item['id']; ?>][quantity]" 
                                                                           class="form-control quantity" min="1" 
                                                                           value="<?php echo $item['quantity']; ?>" required>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-2 mb-3">
                                                                <div class="form-group">
                                                                    <label class="form-label">Unit Cost (₹) *</label>
                                                                    <div class="input-group">
                                                                        <span class="input-group-text">₹</span>
                                                                        <input type="number" step="0.01" name="existing_items[<?php echo $item['id']; ?>][unit_price]" 
                                                                               class="form-control unit-price" min="0" 
                                                                               value="<?php echo $item['unit_price']; ?>" required>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-2 mb-3">
                                                                <div class="form-group">
                                                                    <label class="form-label">Total (₹)</label>
                                                                    <input type="text" class="form-control item-total" 
                                                                           value="<?php echo number_format($item['quantity'] * $item['unit_price'], 2); ?>" readonly>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-2 mb-3 d-flex align-items-end">
                                                                <button type="button" class="btn btn-danger btn-sm remove-item" 
                                                                        data-item-id="<?php echo $item['id']; ?>">
                                                                    <i class="fas fa-trash"></i> Remove
                                                                </button>
                                                            </div>
                                                        </div>
                                                        <div class="row">
                                                            <div class="col-md-12">
                                                                <small class="text-muted">
                                                                    Code: <?php echo htmlspecialchars($item['product_code'] ?? 'N/A'); ?> | 
                                                                    Brand: <?php echo htmlspecialchars($item['brand_name'] ?? 'N/A'); ?> | 
                                                                    Color: <?php echo htmlspecialchars($item['color'] ?? 'N/A'); ?> | 
                                                                    Size: <?php echo htmlspecialchars($item['size'] ?? 'N/A'); ?>
                                                                </small>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            <?php endforeach; ?>
                                        <?php else: ?>
                                            <div class="alert alert-info">
                                                <i class="fas fa-info-circle me-2"></i> No items found for this purchase.
                                            </div>
                                        <?php endif; ?>
                                    </div>
                                </div>
                                
                                
                                <div class="row mb-4">
                                    <div class="col-md-12">
                                        <h5 class="border-bottom pb-2 text-primary">Add New Items</h5>
                                        <div id="newItemsContainer">
                                            
                                        </div>
                                        <div class="text-center mt-3">
                                            <button type="button" class="btn btn-outline-primary" onclick="addNewItemRow('existing')">
                                                <i class="fas fa-plus-circle"></i> Add Existing Product
                                            </button>
                                            <button type="button" class="btn btn-outline-success ms-2" onclick="addNewItemRow('new')">
                                                <i class="fas fa-plus-circle"></i> Add New Product
                                            </button>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="row mb-4">
                                    <div class="col-md-12">
                                        <div class="card">
                                            <div class="card-header bg-light">
                                                <h5 class="mb-0">Purchase Summary</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    <div class="col-md-6">
                                                        <h6>Total Items: <span id="totalItems"><?php echo count($existing_items); ?></span></h6>
                                                        <h6>Total Quantity: <span id="totalQuantity">0</span></h6>
                                                    </div>
                                                    <div class="col-md-6 text-end">
                                                        <h4>Grand Total: ₹ <span id="grandTotal">0.00</span></h4>
                                                        <input type="hidden" name="calculated_total" id="calculatedTotal" value="0">
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="form-row mt-4">
                                    <div class="col-md-12 text-center">
                                        <button type="submit" class="btn btn-primary btn-lg px-5">
                                            <i class="fas fa-save"></i> Update Purchase
                                        </button>
                                        <a href="purchase-details.php?id=<?php echo $purchase_id; ?>" class="btn btn-secondary btn-lg px-5">
                                            <i class="fas fa-times"></i> Cancel
                                        </a>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

</div>
    </div>

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

</div>

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

// Function to add new item row
function addNewItemRow(productType = 'existing') {
    let template;
    
    if (productType === 'existing') {
        template = `
            <div class="card mb-3 new-item-row" id="newItem_${newItemCounter}">
                <div class="card-body">
                    <input type="hidden" name="new_items[product_type][]" value="existing">
                    <div class="row">
                        <div class="col-md-4 mb-3">
                            <div class="form-group">
                                <label class="form-label">Select Product *</label>
                                <select name="new_items[product_id][]" class="form-control existing-product" required>
                                    <option value="">-- Select Product --</option>
                                    <?php foreach ($products as $product): ?>
                                        <option value="<?php echo $product['id']; ?>" data-price="<?php echo $product['stock_price']; ?>">
                                            <?php echo htmlspecialchars($product['product_name'] . ' | ' . $product['brand_name']); ?>
                                        </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Quantity *</label>
                                <input type="number" name="new_items[quantity][]" class="form-control quantity" min="1" value="1" required>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Unit Cost (₹) *</label>
                                <div class="input-group">
                                    <span class="input-group-text">₹</span>
                                    <input type="number" step="0.01" name="new_items[unit_price][]" class="form-control unit-price" min="0" required>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Total (₹)</label>
                                <input type="text" class="form-control item-total" readonly value="0.00">
                            </div>
                        </div>
                        <div class="col-md-2 mb-3 d-flex align-items-end">
                            <button type="button" class="btn btn-danger btn-sm" onclick="removeNewItemRow(${newItemCounter})">
                                <i class="fas fa-times"></i>
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        `;
    } else {
        template = `
            <div class="card mb-3 new-item-row" id="newItem_${newItemCounter}">
                <div class="card-body">
                    <input type="hidden" name="new_items[product_type][]" value="new">
                    <div class="row">
                        <div class="col-md-3 mb-3">
                            <div class="form-group">
                                <label class="form-label">Product Name *</label>
                                <input type="text" name="new_items[new_name][]" class="form-control" placeholder="Enter product name" required>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Brand *</label>
                                <input type="text" name="new_items[brand][]" class="form-control brand-input" list="brandList_${newItemCounter}" placeholder="Type brand name" required>
                                <datalist id="brandList_${newItemCounter}">
                                    <?php foreach ($brands as $brand): ?>
                                        <option value="<?php echo htmlspecialchars($brand['brand_name']); ?>">
                                    <?php endforeach; ?>
                                </datalist>
                                <small class="text-muted">Type to select existing or add new</small>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Color</label>
                                <input type="text" name="new_items[color][]" class="form-control" placeholder="e.g., Black">
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Size</label>
                                <input type="text" name="new_items[size][]" class="form-control" placeholder="e.g., 42">
                            </div>
                        </div>
                        <div class="col-md-3 mb-3">
                            <div class="form-group">
                                <label class="form-label">Category *</label>
                                <select name="new_items[category][]" class="form-control" required>
                                    <option value="">-- Select Category --</option>
                                    <?php foreach ($categories as $category): ?>
                                        <option value="<?php echo $category['id']; ?>">
                                            <?php echo htmlspecialchars($category['category_name']); ?>
                                        </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Quantity *</label>
                                <input type="number" name="new_items[quantity][]" class="form-control quantity" min="1" value="1" required>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Unit Cost (₹) *</label>
                                <div class="input-group">
                                    <span class="input-group-text">₹</span>
                                    <input type="number" step="0.01" name="new_items[unit_price][]" class="form-control unit-price" min="0" required>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Selling Price (₹) *</label>
                                <div class="input-group">
                                    <span class="input-group-text">₹</span>
                                    <input type="number" step="0.01" name="new_items[selling_price][]" class="form-control selling-price" min="0" required>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <label class="form-label">Total (₹)</label>
                                <input type="text" class="form-control item-total" readonly value="0.00">
                            </div>
                        </div>
                        <div class="col-md-1 mb-3 d-flex align-items-end">
                            <button type="button" class="btn btn-danger btn-sm" onclick="removeNewItemRow(${newItemCounter})">
                                <i class="fas fa-times"></i>
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        `;
    }
    
    document.getElementById('newItemsContainer').insertAdjacentHTML('beforeend', template);
    
    // Auto-fill selling price for new products
    if (productType === 'new') {
        const row = document.getElementById(`newItem_${newItemCounter}`);
        const unitPriceInput = row.querySelector('.unit-price');
        const sellingPriceInput = row.querySelector('.selling-price');
        
        unitPriceInput.addEventListener('input', function() {
            const costPrice = parseFloat(this.value) || 0;
            if (costPrice > 0 && (!sellingPriceInput.value || sellingPriceInput.value === '0')) {
                // Auto-suggest 30% markup
                const suggestedPrice = costPrice * 1.3;
                sellingPriceInput.value = suggestedPrice.toFixed(2);
                updateSummary();
            }
        });
    }
    
    updateSummary();
    newItemCounter++;
}

// Function to remove new item row
function removeNewItemRow(rowId) {
    const row = document.getElementById(`newItem_${rowId}`);
    if (row) {
        row.remove();
        updateSummary();
    }
}

// Function to remove existing item (mark for deletion)
document.querySelectorAll('.remove-item').forEach(button => {
    button.addEventListener('click', function() {
        const itemId = this.getAttribute('data-item-id');
        const row = document.getElementById(`existingItem_${itemId}`);
        
        if (confirm('Are you sure you want to remove this item?')) {
            // Add a hidden input to mark item for deletion
            const deleteInput = document.createElement('input');
            deleteInput.type = 'hidden';
            deleteInput.name = `delete_items[${itemId}]`;
            deleteInput.value = '1';
            row.appendChild(deleteInput);
            
            // Hide the row
            row.style.display = 'none';
            
            updateSummary();
        }
    });
});

// Update summary calculations
function updateSummary() {
    let totalItems = 0;
    let totalQuantity = 0;
    let grandTotal = 0;
    
    // Calculate from existing items
    document.querySelectorAll('.existing-item-row').forEach(row => {
        if (row.style.display !== 'none') {
            const quantityInput = row.querySelector('.quantity');
            const unitPriceInput = row.querySelector('.unit-price');
            
            if (quantityInput && unitPriceInput) {
                const quantity = parseFloat(quantityInput.value) || 0;
                const unitPrice = parseFloat(unitPriceInput.value) || 0;
                const itemTotal = quantity * unitPrice;
                
                totalItems++;
                totalQuantity += quantity;
                grandTotal += itemTotal;
                
                // Update item total display
                const itemTotalInput = row.querySelector('.item-total');
                if (itemTotalInput) {
                    itemTotalInput.value = itemTotal.toFixed(2);
                }
            }
        }
    });
    
    // Calculate from new items
    document.querySelectorAll('.new-item-row').forEach(row => {
        const quantityInput = row.querySelector('.quantity');
        const unitPriceInput = row.querySelector('.unit-price');
        
        if (quantityInput && unitPriceInput) {
            const quantity = parseFloat(quantityInput.value) || 0;
            const unitPrice = parseFloat(unitPriceInput.value) || 0;
            const itemTotal = quantity * unitPrice;
            
            totalItems++;
            totalQuantity += quantity;
            grandTotal += itemTotal;
            
            // Update item total display
            const itemTotalInput = row.querySelector('.item-total');
            if (itemTotalInput) {
                itemTotalInput.value = itemTotal.toFixed(2);
            }
        }
    });
    
    document.getElementById('totalItems').textContent = totalItems;
    document.getElementById('totalQuantity').textContent = totalQuantity;
    document.getElementById('grandTotal').textContent = grandTotal.toFixed(2);
    document.getElementById('calculatedTotal').value = grandTotal;
}

// Auto-fill unit price when existing product is selected
document.addEventListener('change', function(e) {
    if (e.target.classList.contains('existing-product') && e.target.value) {
        const selectedOption = e.target.options[e.target.selectedIndex];
        const price = parseFloat(selectedOption.getAttribute('data-price')) || 0;
        const row = e.target.closest('.card');
        const priceInput = row.querySelector('.unit-price');
        
        if (priceInput && price > 0) {
            priceInput.value = price.toFixed(2);
            updateSummary();
        }
    }
});

// Update summary on input changes
document.addEventListener('input', function(e) {
    if (e.target.classList.contains('quantity') || e.target.classList.contains('unit-price') || e.target.classList.contains('selling-price')) {
        updateSummary();
    }
});

// Form validation
document.getElementById('editPurchaseForm').addEventListener('submit', function(e) {
    let isValid = true;
    let errorMessages = [];
    
    // Check if at least one item exists
    const existingItems = document.querySelectorAll('.existing-item-row:not([style*="display: none"])').length;
    const newItems = document.querySelectorAll('.new-item-row').length;
    
    if (existingItems === 0 && newItems === 0) {
        errorMessages.push('At least one purchase item is required');
        isValid = false;
    }
    
    // Validate new items
    document.querySelectorAll('.new-item-row').forEach((row, index) => {
        const productTypeInput = row.querySelector('input[name="new_items[product_type][]"]');
        const productType = productTypeInput ? productTypeInput.value : 'existing';
        
        if (productType === 'existing') {
            const productSelect = row.querySelector('.existing-product');
            const quantityInput = row.querySelector('.quantity');
            const unitPriceInput = row.querySelector('.unit-price');
            
            if (!productSelect.value) {
                errorMessages.push(`New item ${index + 1}: Please select a product`);
                isValid = false;
            }
            
            if (!quantityInput.value || parseFloat(quantityInput.value) <= 0) {
                errorMessages.push(`New item ${index + 1}: Quantity must be greater than 0`);
                isValid = false;
            }
            
            if (!unitPriceInput.value || parseFloat(unitPriceInput.value) <= 0) {
                errorMessages.push(`New item ${index + 1}: Unit price must be greater than 0`);
                isValid = false;
            }
        } else {
            // Validate new product fields
            const productNameInput = row.querySelector('input[name="new_items[new_name][]"]');
            const brandInput = row.querySelector('.brand-input');
            const categorySelect = row.querySelector('select[name="new_items[category][]"]');
            const quantityInput = row.querySelector('.quantity');
            const unitPriceInput = row.querySelector('.unit-price');
            const sellingPriceInput = row.querySelector('.selling-price');
            
            if (!productNameInput.value.trim()) {
                errorMessages.push(`New product ${index + 1}: Product name is required`);
                isValid = false;
            }
            
            if (!brandInput.value.trim()) {
                errorMessages.push(`New product ${index + 1}: Brand is required`);
                isValid = false;
            }
            
            if (!categorySelect.value) {
                errorMessages.push(`New product ${index + 1}: Category is required`);
                isValid = false;
            }
            
            if (!quantityInput.value || parseFloat(quantityInput.value) <= 0) {
                errorMessages.push(`New product ${index + 1}: Quantity must be greater than 0`);
                isValid = false;
            }
            
            if (!unitPriceInput.value || parseFloat(unitPriceInput.value) <= 0) {
                errorMessages.push(`New product ${index + 1}: Unit price must be greater than 0`);
                isValid = false;
            }
            
            if (!sellingPriceInput.value || parseFloat(sellingPriceInput.value) <= 0) {
                errorMessages.push(`New product ${index + 1}: Selling price must be greater than 0`);
                isValid = false;
            }
            
            // Check if selling price is less than cost price
            const unitPrice = parseFloat(unitPriceInput.value) || 0;
            const sellingPrice = parseFloat(sellingPriceInput.value) || 0;
            if (sellingPrice < unitPrice) {
                if (!confirm(`New product ${index + 1}: Selling price (₹${sellingPrice}) is less than cost price (₹${unitPrice}). This will result in a loss. Do you want to continue?`)) {
                    e.preventDefault();
                    sellingPriceInput.focus();
                    isValid = false;
                }
            }
        }
    });
    
    if (!isValid) {
        e.preventDefault();
        alert('Please fix the following errors:\n\n' + errorMessages.join('\n'));
    }
});

// Initialize summary on page load
document.addEventListener('DOMContentLoaded', function() {
    updateSummary();
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation