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_invoice1.php

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

// Set timezone to IST
date_default_timezone_set('Asia/Kolkata');

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

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    echo json_encode(['success' => false, 'message' => 'Invalid request method']);
    exit;
}

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

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

try {
    // Start transaction
    mysqli_begin_transaction($conn);
    
    // 1. Create or get customer
    $customerName = mysqli_real_escape_string($conn, $input['customer_name']);
    $customerPhone = mysqli_real_escape_string($conn, $input['customer_phone'] ?? '');
    
    $customerId = null;
    if (!empty($customerPhone)) {
        $customerCheck = mysqli_query($conn, "SELECT id FROM customers WHERE phone = '{$customerPhone}' LIMIT 1");
        if (mysqli_num_rows($customerCheck) > 0) {
            $customerId = mysqli_fetch_assoc($customerCheck)['id'];
        }
    }
    
    if (!$customerId) {
        $customerSql = "INSERT INTO customers (name, phone, created_at) VALUES (?, ?, NOW())";
        $stmt = mysqli_prepare($conn, $customerSql);
        mysqli_stmt_bind_param($stmt, 'ss', $customerName, $customerPhone);
        mysqli_stmt_execute($stmt);
        $customerId = mysqli_insert_id($conn);
    }
    
    // 2. Generate invoice number
    $invoiceNumber = 'INV' . date('YmdHis');
    
    // 3. Create invoice
    $invoiceSql = "INSERT INTO invoices (customer_id, invoice_number, subtotal, discount, discount_type, total, cash_received, change_given, payment_method, created_at) 
                   VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())";
    $stmt = mysqli_prepare($conn, $invoiceSql);
    mysqli_stmt_bind_param($stmt, 'isddsddds', 
        $customerId, 
        $invoiceNumber,
        $input['subtotal'],
        $input['discount'],
        $input['discount_type'],
        $input['total'],
        $input['cash_received'],
        $input['change_given'],
        $input['payment_method']
    );
    mysqli_stmt_execute($stmt);
    $invoiceId = mysqli_insert_id($conn);
    
    // 4. Add invoice items and update stock
    foreach ($input['items'] as $item) {
        // Insert invoice item
        $itemSql = "INSERT INTO invoice_items (invoice_id, product_name, quantity, original_price, discounted_price, total_price) 
                    VALUES (?, ?, ?, ?, ?, ?)";
        $stmt = mysqli_prepare($conn, $itemSql);
        $productName = mysqli_real_escape_string($conn, $item['name']);
        $quantity = (int)$item['qty'];
        $price = (float)$item['price'];
        $totalPrice = $price * $quantity;
        
        mysqli_stmt_bind_param($stmt, 'isiddd', $invoiceId, $productName, $quantity, $price, $price, $totalPrice);
        mysqli_stmt_execute($stmt);
        
        // Update product stock
        $updateStock = "UPDATE products SET quantity = quantity - ? WHERE product_name = ? AND quantity >= ?";
        $stmt = mysqli_prepare($conn, $updateStock);
        mysqli_stmt_bind_param($stmt, 'isi', $quantity, $productName, $quantity);
        mysqli_stmt_execute($stmt);
    }
    
    // Commit transaction
    mysqli_commit($conn);
    
    // Generate print HTML and return it
    $printHtml = generatePrintHtml($invoiceId, $invoiceNumber, $input);
    
    echo json_encode([
        'success' => true,
        'invoice_id' => $invoiceNumber,
        'print_html' => $printHtml
    ]);
    
} catch (Exception $e) {
    mysqli_rollback($conn);
    echo json_encode(['success' => false, 'message' => $e->getMessage()]);
}

<div>Invoice: <span class='bold'>{$invoiceNumber}</span></div>
            <div>Date: <span class='bold'>{$currentDate} IST</span></div>
            <div>Payment: <span class='bold'>{$paymentMethod}</span></div>

<div class='h2'>Bill To</div>
            <div>Name: <span class='bold'>" . htmlspecialchars($customerName) . "</span></div>
            <div>Phone: <span class='bold'>{$customerPhone}</span></div>

<table class='table'>
                <thead>
                    <tr>
                        <th class='col-item'>Item</th>
                        <th class='col-qty'>Qty</th>
                        <th class='col-amt'>Amt</th>
                    </tr>
                </thead>
                <tbody>
                    {$itemsHtml}
                </tbody>
            </table>

<div class='right'>Subtotal: <span class='bold'>₹ " . number_format($input['subtotal'], 2) . "</span></div>
            <div class='right'>Discount: <span class='bold'>₹ " . number_format($input['discount'], 2) . "</span></div>
            <div class='line'></div>
            <div class='right h2'>Grand Total: ₹ " . number_format($input['total'], 2) . "</div>
            <div class='right'>Paid: <span class='bold'>₹ " . number_format($input['cash_received'], 2) . "</span></div>
            " . ($input['change_given'] > 0 ? "<div class='right'>Change: <span class='bold'>₹ " . number_format($input['change_given'], 2) . "</span></div>" : "") . "

<div class='bold'>Amount in words:</div>
            <div>{$amountWords}</div>

<div class='line'></div>
            <div class='center bold'>Thank you for shopping with {$shopName}!</div>
            <div class='center'>Proprietor: {$ownerName}</div>
        </div>
    ";
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: save_invoice1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation