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: create-purchase.php

<?php
// purchase-create.php with variant support
include('includes/db.php');

$error = '';
$success = '';

// 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 existing brands
$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 existing products for selection
$products = [];
$productQuery = "SELECT p.id, p.product_name, p.product_code, b.brand_name, p.color, p.size, p.stock_price, p.customer_price, c.category_name 
                 FROM products p 
                 LEFT JOIN brands b ON p.brand_id = b.id 
                 LEFT JOIN categories c ON p.category_id = c.id 
                 ORDER BY p.product_name";
$productResult = mysqli_query($conn, $productQuery);
if ($productResult) {
    while ($row = mysqli_fetch_assoc($productResult)) {
        $products[] = $row;
    }
}

// Fetch categories for new products
$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);
        
        // 1. Get purchase header 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']);
        $created_by = $_SESSION['user_id'];
        
        // Generate reference number if not provided
        if (empty($reference_no)) {
            $reference_no = 'PUR-' . date('Ymd-His');
        }
        
        // 2. Insert purchase header
        $purchaseQuery = "INSERT INTO purchases (supplier_id, reference_no, purchase_date, payment_method, notes, created_by) 
                         VALUES ('$supplier_id', '$reference_no', '$purchase_date', '$payment_method', '$notes', '$created_by')";
        
        if (!mysqli_query($conn, $purchaseQuery)) {
            throw new Exception("Failed to create purchase: " . mysqli_error($conn));
        }
        
        $purchase_id = mysqli_insert_id($conn);
        $total_amount = 0;
        
        // 3. Process each product item from the new variant-based structure
        $product_items = $_POST['products'];
        $product_types = $product_items['product_type'] ?? [];
        $product_ids = $product_items['product_id'] ?? [];
        $product_names = $product_items['new_name'] ?? [];
        $product_brands = $product_items['brand'] ?? [];
        $product_categories = $product_items['category'] ?? [];
        $selling_prices = $product_items['selling_price'] ?? [];
        
        // Process variant data
        $variant_colors = $product_items['variant_colors'] ?? [];
        $variant_sizes = $product_items['variant_sizes'] ?? [];
        $variant_quantities = $product_items['variant_quantities'] ?? [];
        $variant_prices = $product_items['variant_prices'] ?? [];
        
        $item_count = count($product_types);
        
        for ($i = 0; $i < $item_count; $i++) {
            $product_type = $product_types[$i];
            
            if ($product_type === 'existing') {
                // For existing product with variants
                $product_id = $product_ids[$i];
                
                if ($product_id) {
                    // Get main product details
                    $main_product_query = "SELECT * FROM products WHERE id = $product_id";
                    $main_product_result = mysqli_query($conn, $main_product_query);
                    
                    if (!$main_product_result) {
                        throw new Exception("Failed to fetch product details: " . mysqli_error($conn));
                    }
                    
                    $main_product = mysqli_fetch_assoc($main_product_result);
                    
                    if (!$main_product) {
                        throw new Exception("Product not found with ID: $product_id");
                    }
                    
                    // Process each variant if they exist for this product
                    if (isset($variant_colors[$i]) && is_array($variant_colors[$i])) {
                        $variant_count = count($variant_colors[$i]);
                        
                        for ($v = 0; $v < $variant_count; $v++) {
                            $variant_color = mysqli_real_escape_string($conn, $variant_colors[$i][$v] ?? '');
                            $variant_size = mysqli_real_escape_string($conn, $variant_sizes[$i][$v] ?? '');
                            $variant_price = (float)($variant_prices[$i][$v] ?? 0);
                            $variant_quantity = (int)($variant_quantities[$i][$v] ?? 0);
                            
                            if ($variant_quantity > 0 && !empty($variant_color) && !empty($variant_size)) {
                                // Check if variant already exists
                                $variant_query = "SELECT id FROM products 
                                                WHERE product_name = '{$main_product['product_name']}' 
                                                AND color = '$variant_color' 
                                                AND size = '$variant_size' 
                                                LIMIT 1";
                                $variant_result = mysqli_query($conn, $variant_query);
                                
                                $variant_total_price = $variant_quantity * $variant_price;
                                $total_amount += $variant_total_price;
                                
                                if (mysqli_num_rows($variant_result) > 0) {
                                    // Update existing variant
                                    $variant_row = mysqli_fetch_assoc($variant_result);
                                    $variant_product_id = $variant_row['id'];
                                    
                                    // Update stock
                                    $update_variant_query = "UPDATE products SET quantity = quantity + $variant_quantity WHERE id = $variant_product_id";
                                    if (!mysqli_query($conn, $update_variant_query)) {
                                        throw new Exception("Failed to update variant stock: " . mysqli_error($conn));
                                    }
                                    
                                    // Insert purchase item for variant
                                    $variant_item_query = "INSERT INTO purchase_items (purchase_id, product_id, quantity, unit_price, total_price) 
                                                         VALUES ('$purchase_id', '$variant_product_id', '$variant_quantity', '$variant_price', '$variant_total_price')";
                                    if (!mysqli_query($conn, $variant_item_query)) {
                                        throw new Exception("Failed to add purchase item for variant: " . mysqli_error($conn));
                                    }
                                } else {
                                    // Create new variant product
                                    $variant_product_code = generateVariantCode($main_product['product_code'] ?? '', $variant_color, $variant_size);
                                    
                                    // Calculate selling price (30% markup by default)
                                    $customer_price = $variant_price * 1.3;
                                    $profit = $customer_price - $variant_price;
                                    $profit_percentage = $variant_price > 0 ? ($profit / $variant_price * 100) : 0;
                                    
                                    $new_variant_query = "INSERT INTO products (product_name, brand_id, color, size, category_id, product_code, 
                                                        stock_price, customer_price, profit, profit_percentage, quantity) 
                                                        VALUES ('{$main_product['product_name']}', '{$main_product['brand_id']}', 
                                                        '$variant_color', '$variant_size', '{$main_product['category_id']}', '$variant_product_code',
                                                        '$variant_price', '$customer_price', '$profit', '$profit_percentage', '$variant_quantity')";
                                    
                                    if (!mysqli_query($conn, $new_variant_query)) {
                                        throw new Exception("Failed to create variant product: " . mysqli_error($conn));
                                    }
                                    
                                    $new_variant_id = mysqli_insert_id($conn);
                                    
                                    // Insert purchase item for new variant
                                    $variant_item_query = "INSERT INTO purchase_items (purchase_id, product_id, quantity, unit_price, total_price) 
                                                         VALUES ('$purchase_id', '$new_variant_id', '$variant_quantity', '$variant_price', '$variant_total_price')";
                                    if (!mysqli_query($conn, $variant_item_query)) {
                                        throw new Exception("Failed to add purchase item for new variant: " . mysqli_error($conn));
                                    }
                                }
                            }
                        }
                    }
                }
            } else if ($product_type === 'new') {
                // For new product with variants
                $product_name = mysqli_real_escape_string($conn, $product_names[$i] ?? '');
                $brand_input = mysqli_real_escape_string($conn, $product_brands[$i] ?? '');
                $category_id = mysqli_real_escape_string($conn, $product_categories[$i] ?? '');
                $selling_price = (float)($selling_prices[$i] ?? 0);
                
                if (empty($product_name) || empty($brand_input) || empty($category_id) || $selling_price <= 0) {
                    throw new Exception("Invalid data for new product at index $i");
                }
                
                // Handle brand - check if it exists or create new
                $brand_id = null;
                if (is_numeric($brand_input)) {
                    $brand_id = $brand_input;
                } else {
                    $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);
                    }
                }
                
                // Process each variant for new product
                if (isset($variant_colors[$i]) && is_array($variant_colors[$i])) {
                    $variant_count = count($variant_colors[$i]);
                    
                    for ($v = 0; $v < $variant_count; $v++) {
                        $variant_color = mysqli_real_escape_string($conn, $variant_colors[$i][$v] ?? '');
                        $variant_size = mysqli_real_escape_string($conn, $variant_sizes[$i][$v] ?? '');
                        $variant_price = (float)($variant_prices[$i][$v] ?? 0);
                        $variant_quantity = (int)($variant_quantities[$i][$v] ?? 0);
                        
                        if ($variant_quantity > 0 && !empty($variant_color) && !empty($variant_size) && $variant_price > 0) {
                            // Generate product code for variant
                            $base_code = strtoupper(substr(preg_replace('/[^a-zA-Z0-9]/', '', $product_name), 0, 3));
                            $color_code = substr(strtoupper(preg_replace('/[^a-zA-Z]/', '', $variant_color)), 0, 2);
                            $size_code = str_pad($variant_size, 2, '0', STR_PAD_LEFT);
                            $variant_product_code = $base_code . '-' . $color_code . $size_code . '-' . date('Ymd') . '-' . rand(100, 999);
                            
                            // Calculate profit for variant
                            $profit = $selling_price - $variant_price;
                            $profit_percentage = $variant_price > 0 ? ($profit / $variant_price * 100) : 0;
                            
                            $variant_total_price = $variant_quantity * $variant_price;
                            $total_amount += $variant_total_price;
                            
                            // Insert variant product
                            $newVariantQuery = "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', '$variant_color', '$variant_size', '$category_id', '$variant_product_code',
                                              '$variant_price', '$selling_price', '$profit', '$profit_percentage', '$variant_quantity')";
                            
                            if (!mysqli_query($conn, $newVariantQuery)) {
                                throw new Exception("Failed to create new variant product: " . mysqli_error($conn));
                            }
                            
                            $new_variant_id = mysqli_insert_id($conn);
                            
                            // Insert purchase item for variant
                            $variant_item_query = "INSERT INTO purchase_items (purchase_id, product_id, quantity, unit_price, total_price) 
                                                 VALUES ('$purchase_id', '$new_variant_id', '$variant_quantity', '$variant_price', '$variant_total_price')";
                            if (!mysqli_query($conn, $variant_item_query)) {
                                throw new Exception("Failed to add purchase item for variant: " . mysqli_error($conn));
                            }
                        }
                    }
                }
            }
        }
        
        // 4. Update purchase total
        $updatePurchaseQuery = "UPDATE purchases SET total_amount = '$total_amount', grand_total = '$total_amount' WHERE id = '$purchase_id'";
        if (!mysqli_query($conn, $updatePurchaseQuery)) {
            throw new Exception("Failed to update purchase total: " . mysqli_error($conn));
        }
        
        // 5. Update supplier balance if needed
        $updateSupplierQuery = "UPDATE suppliers SET current_balance = current_balance + $total_amount WHERE id = $supplier_id";
        if (!mysqli_query($conn, $updateSupplierQuery)) {
            throw new Exception("Failed to update supplier balance: " . mysqli_error($conn));
        }
        
        // 6. Log activity
        $activity_log = "Created purchase #$reference_no with $item_count products";
        $log_query = "INSERT INTO activity_logs (user_id, activity) VALUES ('$created_by', '$activity_log')";
        mysqli_query($conn, $log_query);
        
        mysqli_commit($conn);
        $success = "Purchase created successfully with variants! Reference Number: " . htmlspecialchars($reference_no);
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $error = $e->getMessage();
    }
}

// Function to generate variant product code
function generateVariantCode($base_code, $color, $size) {
    if (empty($base_code)) {
        $base_code = 'PROD';
    }
    
    $color_code = substr(strtoupper(preg_replace('/[^a-zA-Z]/', '', $color)), 0, 2);
    $size_code = str_pad($size, 2, '0', STR_PAD_LEFT);
    
    // If base code already has variant suffix, remove it first
    $clean_base = preg_replace('/-[A-Z]{2}\d{2}$/', '', $base_code);
    
    return $clean_base . '-' . $color_code . $size_code;
}
?>

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

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Create New Purchase with Variants</h4>

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

<form method="POST" action="" id="purchaseForm">
                                    
                                    <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 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">Invoice/Reference Number</label>
                                                <input type="text" name="reference_no" id="reference_no" class="form-control" placeholder="Leave blank to auto-generate">
                                                <small class="form-text text-muted">Auto-generated if left blank</small>
                                            </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'); ?>" 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">Cash</option>
                                                    <option value="bank_transfer">Bank Transfer</option>
                                                    <option value="cheque">Cheque</option>
                                                    <option value="card">Card</option>
                                                    <option value="credit">Credit</option>
                                                    <option value="online">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" placeholder="Any additional notes..."></textarea>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="row mb-4">
                                        <div class="col-md-12">
                                            <h5 class="border-bottom pb-2 text-primary">Products with Variants</h5>
                                            <div id="productsContainer">
                                                
                                                <div class="product-row card mb-3" id="productRow_0">
                                                    <div class="card-body">
                                                        <div class="row">
                                                            <div class="col-md-3 mb-3">
                                                                <div class="form-group">
                                                                    <label class="form-label">Product Type</label>
                                                                    <select name="products[product_type][]" class="form-control product-type" onchange="toggleProductFields(0)">
                                                                        <option value="existing">Select Existing Product</option>
                                                                        <option value="new">Add New Product</option>
                                                                    </select>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-3 mb-3 existing-product-fields">
                                                                <div class="form-group">
                                                                    <label class="form-label">Select Product</label>
                                                                    <select name="products[product_id][]" class="form-control existing-product">
                                                                        <option value="">-- Select Product --</option>
                                                                        <?php foreach ($products as $product): ?>
                                                                            <option value="<?php echo $product['id']; ?>">
                                                                                <?php echo htmlspecialchars($product['product_name'] . ' | ' . $product['brand_name']); ?>
                                                                            </option>
                                                                        <?php endforeach; ?>
                                                                    </select>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-6 new-product-fields">
                                                                <div class="row">
                                                                    <div class="col-md-6 mb-3">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Product Name *</label>
                                                                            <input type="text" name="products[new_name][]" class="form-control" placeholder="Enter product name">
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-6 mb-3">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Brand *</label>
                                                                            <input type="text" name="products[brand][]" class="form-control brand-input" list="brandList_0" placeholder="Type brand name">
                                                                            <datalist id="brandList_0">
                                                                                <?php foreach ($brands as $brand): ?>
                                                                                    <option value="<?php echo htmlspecialchars($brand['brand_name']); ?>">
                                                                                <?php endforeach; ?>
                                                                            </datalist>
                                                                            <small class="form-text text-muted">Type to select existing or add new</small>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-12 mb-3">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Category *</label>
                                                                            <select name="products[category][]" class="form-control">
                                                                                <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>
                                                            </div>
                                                        </div>
                                                        
                                                        
                                                        <div class="variants-section mt-3">
                                                            <div class="row mb-2">
                                                                <div class="col-md-12">
                                                                    <h6 class="border-bottom pb-1 text-secondary">Product Variants</h6>
                                                                    <small class="text-muted">Add different color/size combinations for this product</small>
                                                                </div>
                                                            </div>
                                                            <div id="variantsContainer_0">
                                                                
                                                                <div class="variant-row row mb-2" id="variantRow_0_0">
                                                                    <div class="col-md-3">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Color</label>
                                                                            <input type="text" name="products[variant_colors][0][]" class="form-control variant-color" placeholder="e.g., Black" required>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-2">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Size</label>
                                                                            <input type="text" name="products[variant_sizes][0][]" class="form-control variant-size" placeholder="e.g., 42" required>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-2">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Quantity *</label>
                                                                            <input type="number" name="products[variant_quantities][0][]" class="form-control variant-quantity" min="1" value="1" required onchange="updateVariantTotal(0, 0)">
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-2">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Cost Price (₹) *</label>
                                                                            <div class="input-group">
                                                                                <span class="input-group-text">₹</span>
                                                                                <input type="number" step="0.01" name="products[variant_prices][0][]" class="form-control variant-price" min="0" required onchange="updateVariantTotal(0, 0)">
                                                                            </div>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-2">
                                                                        <div class="form-group">
                                                                            <label class="form-label">Total (₹)</label>
                                                                            <input type="text" class="form-control variant-total" readonly value="0.00" style="background-color: #f8f9fa; font-weight: bold;">
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-1 d-flex align-items-end">
                                                                        <button type="button" class="btn btn-danger btn-sm remove-variant" onclick="removeVariantRow(0, 0)" style="margin-top: 8px;">
                                                                            <i class="fas fa-trash"></i>
                                                                        </button>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            
                                                            <div class="row mt-2">
                                                                <div class="col-md-12">
                                                                    <button type="button" class="btn btn-outline-secondary btn-sm" onclick="addVariantRow(0)">
                                                                        <i class="fas fa-plus"></i> Add Another Variant
                                                                    </button>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        
                                                        
                                                        <div class="row mt-3 new-product-fields">
                                                            <div class="col-md-4 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="products[selling_price][]" class="form-control selling-price" min="0">
                                                                    </div>
                                                                    <small class="form-text text-muted">This will be applied to all variants</small>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        
                                                        
                                                        <div class="row mt-3">
                                                            <div class="col-md-4 offset-md-8">
                                                                <div class="form-group">
                                                                    <label class="form-label">Product Total (₹)</label>
                                                                    <div class="form-control" style="background-color: #f8f9fa; font-weight: bold; height: auto; min-height: 45px; display: flex; align-items: center; font-size: 1.1rem; color: #28a745;">
                                                                        ₹ <span id="productTotal_0">0.00</span>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-12 text-end">
                                                                <button type="button" class="btn btn-danger btn-sm remove-product" onclick="removeProductRow(0)" style="margin-top: 8px;">
                                                                    <i class="fas fa-trash"></i> Remove Product
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            
                                            <div class="text-center mt-3">
                                                <button type="button" class="btn btn-outline-primary" onclick="addProductRow()">
                                                    <i class="fas fa-plus-circle"></i> Add Another 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-4">
                                                            <div class="form-group">
                                                                <label class="form-label">Total Products</label>
                                                                <div class="form-control" style="background-color: #f8f9fa; font-weight: bold; height: auto; min-height: 45px; display: flex; align-items: center;">
                                                                    <span id="totalProducts">1</span>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-4">
                                                            <div class="form-group">
                                                                <label class="form-label">Total Variants</label>
                                                                <div class="form-control" style="background-color: #f8f9fa; font-weight: bold; height: auto; min-height: 45px; display: flex; align-items: center;">
                                                                    <span id="totalVariants">1</span>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-4">
                                                            <div class="form-group">
                                                                <label class="form-label">Total Quantity</label>
                                                                <div class="form-control" style="background-color: #f8f9fa; font-weight: bold; height: auto; min-height: 45px; display: flex; align-items: center;">
                                                                    <span id="totalQuantity">1</span>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-12 mt-3">
                                                            <div class="form-group">
                                                                <label class="form-label">Grand Total</label>
                                                                <div class="form-control" style="background-color: #f8f9fa; font-weight: bold; height: auto; min-height: 45px; display: flex; align-items: center; font-size: 1.2rem; color: #28a745;">
                                                                    ₹ <span id="grandTotal">0.00</span>
                                                                </div>
                                                                <input type="hidden" name="calculated_total" id="calculatedTotal" value="0">
                                                            </div>
                                                        </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-check-circle"></i> Create Purchase
                                            </button>
                                            <a href="purchase-list.php" class="btn btn-secondary btn-lg px-5">
                                                <i class="fas fa-times-circle"></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'); ?>

// Initialize event listeners
document.addEventListener('DOMContentLoaded', function() {
    // Update summary when variant data changes
    document.getElementById('productsContainer').addEventListener('input', function(e) {
        if (e.target.classList.contains('variant-quantity') || 
            e.target.classList.contains('variant-price')) {
            const variantRow = e.target.closest('.variant-row');
            if (variantRow) {
                const ids = variantRow.id.split('_');
                updateVariantTotal(ids[1], ids[2]);
            }
        }
    });
    
    // Auto-suggest selling price based on cost price for new products
    document.getElementById('productsContainer').addEventListener('input', function(e) {
        if (e.target.classList.contains('variant-price')) {
            const productRow = e.target.closest('.product-row');
            if (productRow && productRow.querySelector('.product-type').value === 'new') {
                const sellingInput = productRow.querySelector('.selling-price');
                if (sellingInput && sellingInput.value === '') {
                    // Calculate average price of variants
                    let totalPrice = 0;
                    let count = 0;
                    productRow.querySelectorAll('.variant-price').forEach(input => {
                        const price = parseFloat(input.value) || 0;
                        if (price > 0) {
                            totalPrice += price;
                            count++;
                        }
                    });
                    
                    if (count > 0) {
                        const avgPrice = totalPrice / count;
                        const suggestedPrice = avgPrice * 1.3; // 30% markup
                        sellingInput.value = suggestedPrice.toFixed(2);
                    }
                }
            }
        }
    });
    
    // Auto-generate reference number if empty
    document.getElementById('reference_no').addEventListener('focusout', function() {
        if (!this.value.trim()) {
            const now = new Date();
            const dateStr = now.toISOString().slice(0,10).replace(/-/g,'');
            const timeStr = now.toTimeString().slice(0,8).replace(/:/g,'');
            this.value = 'PUR-' + dateStr + '-' + timeStr;
        }
    });
    
    // Form validation
    document.getElementById('purchaseForm').addEventListener('submit', function(e) {
        let isValid = true;
        let errorMessages = [];
        
        // Check supplier
        if (!document.getElementById('supplier_id').value) {
            errorMessages.push('Please select a supplier');
            isValid = false;
        }
        
        // Validate each product
        document.querySelectorAll('.product-row').forEach((row, productIndex) => {
            const productType = row.querySelector('.product-type').value;
            const variants = row.querySelectorAll('.variant-row');
            
            if (variants.length === 0) {
                errorMessages.push(`Product ${productIndex + 1}: At least one variant is required`);
                isValid = false;
            }
            
            // Validate each variant
            variants.forEach((variant, variantIndex) => {
                const color = variant.querySelector('.variant-color').value.trim();
                const size = variant.querySelector('.variant-size').value.trim();
                const quantity = parseFloat(variant.querySelector('.variant-quantity').value) || 0;
                const price = parseFloat(variant.querySelector('.variant-price').value) || 0;
                
                if (!color) {
                    errorMessages.push(`Product ${productIndex + 1}, Variant ${variantIndex + 1}: Color is required`);
                    isValid = false;
                }
                if (!size) {
                    errorMessages.push(`Product ${productIndex + 1}, Variant ${variantIndex + 1}: Size is required`);
                    isValid = false;
                }
                if (quantity <= 0) {
                    errorMessages.push(`Product ${productIndex + 1}, Variant ${variantIndex + 1}: Quantity must be greater than 0`);
                    isValid = false;
                }
                if (price <= 0) {
                    errorMessages.push(`Product ${productIndex + 1}, Variant ${variantIndex + 1}: Cost price must be greater than 0`);
                    isValid = false;
                }
            });
            
            // Additional validation for new products
            if (productType === 'new') {
                const productName = row.querySelector('input[name="products[new_name][]"]').value.trim();
                const brand = row.querySelector('.brand-input').value.trim();
                const category = row.querySelector('select[name="products[category][]"]').value;
                const sellingPrice = parseFloat(row.querySelector('.selling-price').value) || 0;
                
                if (!productName) {
                    errorMessages.push(`Product ${productIndex + 1}: Product name is required for new product`);
                    isValid = false;
                }
                if (!brand) {
                    errorMessages.push(`Product ${productIndex + 1}: Brand is required for new product`);
                    isValid = false;
                }
                if (!category) {
                    errorMessages.push(`Product ${productIndex + 1}: Category is required for new product`);
                    isValid = false;
                }
                if (sellingPrice <= 0) {
                    errorMessages.push(`Product ${productIndex + 1}: Selling price must be greater than 0`);
                    isValid = false;
                }
            } else {
                // Existing product validation
                const productId = row.querySelector('.existing-product').value;
                if (!productId) {
                    errorMessages.push(`Product ${productIndex + 1}: Please select an existing product`);
                    isValid = false;
                }
            }
        });
        
        if (document.querySelectorAll('.product-row').length === 0) {
            errorMessages.push('At least one product is required');
            isValid = false;
        }
        
        if (!isValid) {
            e.preventDefault();
            alert('Please fix the following errors:\n\n' + errorMessages.join('\n'));
        }
    });
    
    // Initialize first product
    toggleProductFields(0);
    updateVariantTotal(0, 0);
    updateSummary();
    
    // Auto focus on first field
    document.getElementById('supplier_id').focus();
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: create-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation