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/style29.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: save_invoice.php

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

header('Content-Type: application/json');

// Get POST data
$data = json_decode(file_get_contents('php://input'), true);

if (!$data) {
    echo json_encode(['success' => false, 'message' => 'Invalid data']);
    exit;
}

// Debug logging
error_log("Received invoice data: " . print_r($data, true));

// Start transaction
mysqli_begin_transaction($conn);

try {
    // 1. Save customer information
    $customerName = mysqli_real_escape_string($conn, $data['customer_name'] ?? 'Walk-in Customer');
    $customerPhone = mysqli_real_escape_string($conn, $data['customer_phone'] ?? '');
    
    // Check if customer exists by phone (if phone provided)
    $customerId = null;
    if (!empty($customerPhone)) {
        $checkCustomer = mysqli_query($conn, "SELECT id FROM customers WHERE phone = '$customerPhone' LIMIT 1");
        if ($checkCustomer && mysqli_num_rows($checkCustomer) > 0) {
            $customerRow = mysqli_fetch_assoc($checkCustomer);
            $customerId = $customerRow['id'];
        }
    }
    
    // If customer doesn't exist, create new
    if (!$customerId) {
        $insertCustomer = mysqli_query($conn, 
            "INSERT INTO customers (name, phone, created_at) 
             VALUES ('$customerName', '$customerPhone', NOW())");
        if (!$insertCustomer) throw new Exception("Failed to save customer: " . mysqli_error($conn));
        $customerId = mysqli_insert_id($conn);
    }
    
    // 2. Save invoice with item discount tracking
    $subtotal = floatval($data['subtotal'] ?? 0);
    $discount = floatval($data['discount'] ?? 0);
    $discountType = mysqli_real_escape_string($conn, $data['discount_type'] ?? 'percent');
    $total = floatval($data['total'] ?? 0);
    $cashReceived = floatval($data['cash_received'] ?? 0);
    $changeGiven = floatval($data['change_given'] ?? 0);
    $paymentMethod = mysqli_real_escape_string($conn, $data['payment_method'] ?? 'cash');
    
    // Get total item discount from data
    $totalItemDiscount = floatval($data['total_item_discount'] ?? 0);
    
    // Generate invoice number
    $invoiceNumber = 'INV' . date('YmdHis') . rand(100, 999);
    
    // Insert invoice
    $insertInvoice = mysqli_query($conn,
        "INSERT INTO invoices (
            customer_id, invoice_number, subtotal, discount, discount_type, 
            total_item_discount, total, cash_received, change_given, payment_method, created_at
        ) VALUES (
            $customerId, 
            '$invoiceNumber',
            $subtotal, $discount, '$discountType', 
            $totalItemDiscount, $total, $cashReceived, $changeGiven, '$paymentMethod', NOW()
        )");
    
    if (!$insertInvoice) {
        throw new Exception("Failed to save invoice: " . mysqli_error($conn));
    }
    $invoiceId = mysqli_insert_id($conn);
    
    // 3. Save invoice items with calculations for invoice_print.php
    $items = $data['items'] ?? [];
    error_log("Items count: " . count($items));
    
    foreach ($items as $index => $item) {
        error_log("Processing item $index: " . print_r($item, true));
        
        $productId = intval($item['id'] ?? 0);
        $productName = mysqli_real_escape_string($conn, $item['name'] ?? 'Unknown Product');
        $quantity = intval($item['quantity'] ?? $item['qty'] ?? 1);
        $price = floatval($item['price'] ?? 0);
        $category = mysqli_real_escape_string($conn, $item['category'] ?? $item['product_category'] ?? '');
        $productCode = mysqli_real_escape_string($conn, $item['code'] ?? $item['product_code'] ?? '');
        
        // Get discount information for this item
        $discountValue = floatval($item['discountValue'] ?? $item['discount_value'] ?? $item['discount'] ?? 0);
        $discountTypeItem = mysqli_real_escape_string($conn, $item['discountType'] ?? $item['discount_type'] ?? 'percent');
        
        // Calculate values for invoice_print.php
        $originalPrice = floatval($item['originalPrice'] ?? $item['original_price'] ?? $price);
        $baseAmount = $originalPrice * $quantity;
        
        // Calculate discount amount and percentage
        $discountAmount = 0;
        $discountPercentage = 0;
        
        if ($discountValue > 0) {
            if ($discountTypeItem === 'percent') {
                $discountAmount = $baseAmount * ($discountValue / 100);
                $discountPercentage = $discountValue;
            } else {
                $discountAmount = min($discountValue, $baseAmount);
                $discountPercentage = ($discountAmount / $baseAmount) * 100;
            }
        }
        
        $discountedPrice = $baseAmount - $discountAmount;
        $totalPrice = $discountedPrice;
        
        // Validate required fields
        if (empty($productName)) {
            throw new Exception("Product name is required for item $index");
        }
        
        if ($quantity <= 0) {
            throw new Exception("Invalid quantity for product: $productName");
        }
        
        // Check product stock if product ID is provided
        if ($productId > 0) {
            $checkStock = mysqli_query($conn, "SELECT quantity, product_name FROM products WHERE id = $productId");
            if (!$checkStock || mysqli_num_rows($checkStock) === 0) {
                throw new Exception("Product not found: ID $productId");
            }
            
            $stockData = mysqli_fetch_assoc($checkStock);
            $stock = $stockData['quantity'];
            if ($stock < $quantity) {
                throw new Exception("Insufficient stock for product: " . $stockData['product_name'] . " (Available: $stock, Requested: $quantity)");
            }
        }
        
        // CORRECTED: Insert item with columns that invoice_print.php expects
        $insertItem = mysqli_query($conn,
            "INSERT INTO invoice_items (
                invoice_id, product_name, quantity, 
                original_price, discount_percentage, discounted_price, total_price,
                product_category, product_code
            ) VALUES (
                $invoiceId, '$productName', $quantity, 
                $originalPrice, $discountPercentage, $discountedPrice, $totalPrice,
                '$category', '$productCode'
            )");
        
        if (!$insertItem) {
            throw new Exception("Failed to save invoice item: " . mysqli_error($conn) . " - Product: $productName");
        }
        
        // Update product stock if product ID is provided
        if ($productId > 0) {
            $updateStock = mysqli_query($conn,
                "UPDATE products SET quantity = quantity - $quantity WHERE id = $productId");
            
            if (!$updateStock) {
                throw new Exception("Failed to update product stock: " . mysqli_error($conn) . " - Product ID: $productId");
            }
        }
        
        error_log("Successfully saved item: $productName");
    }
    
    // Commit transaction
    mysqli_commit($conn);
    
    error_log("Invoice saved successfully: $invoiceNumber");
    
    echo json_encode([
        'success' => true,
        'invoice_id' => $invoiceNumber, // CHANGED: Send invoice number instead of database ID
        'invoice_number' => $invoiceNumber,
        'message' => 'Invoice saved successfully with item discounts'
    ]);
    
} catch (Exception $e) {
    mysqli_rollback($conn);
    error_log("Invoice save error: " . $e->getMessage());
    
    echo json_encode([
        'success' => false,
        'message' => 'Error saving invoice: ' . $e->getMessage()
    ]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: save_invoice.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation