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/rutzotech.com/public_html/bill

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: update_bill.php

<?php
// update_bill.php
session_start();
require_once 'db_connection.php';

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

$action = isset($_POST['action']) ? $_POST['action'] : '';

if ($action === 'update_item') {
    $index = isset($_POST['index']) ? intval($_POST['index']) : -1;
    $field = isset($_POST['field']) ? $_POST['field'] : '';
    $value = isset($_POST['value']) ? $_POST['value'] : '';
    
    if (isset($_SESSION['current_bill']['items'][$index]) && $field === 'quantity') {
        $quantity = intval($value);
        if ($quantity < 1) $quantity = 1;
        
        // Update quantity
        $_SESSION['current_bill']['items'][$index]['quantity'] = $quantity;
        
        // Recalculate all totals including GST
        recalculateBillTotals();
        
        // Get the updated item total
        $item_total = $_SESSION['current_bill']['items'][$index]['total'];
        
        echo json_encode([
            'success' => true,
            'item_total' => $item_total,
            'summary' => getBillSummary()
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'Invalid item or field']);
    }
    exit();
}

if ($action === 'update_tax') {
    $cgst_amount = isset($_POST['cgst_amount']) ? floatval($_POST['cgst_amount']) : 0;
    $sgst_amount = isset($_POST['sgst_amount']) ? floatval($_POST['sgst_amount']) : 0;
    
    if (isset($_SESSION['current_bill'])) {
        // Update only tax values
        $_SESSION['current_bill']['cgst_amount'] = $cgst_amount;
        $_SESSION['current_bill']['sgst_amount'] = $sgst_amount;
        
        // Recalculate totals with updated taxes
        recalculateBillTotals();
        
        echo json_encode([
            'success' => true,
            'summary' => getBillSummary()
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'No active bill']);
    }
    exit();
}

if ($action === 'update_discount') {
    $discount_type = isset($_POST['discount_type']) ? $_POST['discount_type'] : 'flat';
    $discount_value = isset($_POST['discount_value']) ? floatval($_POST['discount_value']) : 0;
    
    if (isset($_SESSION['current_bill'])) {
        // Update discount values
        $_SESSION['current_bill']['discount_type'] = $discount_type;
        $_SESSION['current_bill']['discount_value'] = $discount_value;
        
        // Recalculate totals with updated discount
        recalculateBillTotals();
        
        echo json_encode([
            'success' => true,
            'summary' => getBillSummary()
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'No active bill']);
    }
    exit();
}

if ($action === 'update_salesperson') {
    $salesperson_id = isset($_POST['salesperson_id']) ? intval($_POST['salesperson_id']) : 0;
    
    if (isset($_SESSION['current_bill'])) {
        $_SESSION['current_bill']['salesperson_id'] = $salesperson_id;
        echo json_encode(['success' => true]);
    } else {
        echo json_encode(['success' => false, 'message' => 'No active bill']);
    }
    exit();
}

// Handle unknown actions
echo json_encode(['success' => false, 'message' => 'Unknown action']);

// Function to recalculate all bill totals including GST
function recalculateBillTotals() {
    if (!isset($_SESSION['current_bill'])) return;
    
    $bill = &$_SESSION['current_bill'];
    $total_items = 0;
    $total_qty = 0;
    $subtotal = 0;
    
    // Initialize GST arrays
    $gst_summary = [];
    $total_cgst = 0;
    $total_sgst = 0;

foreach ($bill['items'] as &$item) {
        $price = floatval($item['price']); // MRP inclusive of GST
        $tax_percent = floatval($item['tax_percent']);
        $quantity = intval($item['quantity']);
        
        // Calculate base price (excluding GST)
        $gst_multiplier = 1 + ($tax_percent / 100);
        $base_price = $price / $gst_multiplier;
        
        // Calculate per unit GST
        $gst_per_unit = $price - $base_price;
        $cgst_per_unit = $gst_per_unit / 2;
        $sgst_per_unit = $gst_per_unit / 2;
        
        // Calculate totals for this item
        $item_total = $price * $quantity;
        $item_cgst = $cgst_per_unit * $quantity;
        $item_sgst = $sgst_per_unit * $quantity;
        $item_gst = $gst_per_unit * $quantity;
        
        $item['total'] = $item_total;
        $item['base_price'] = $base_price;
        $item['cgst'] = $item_cgst;
        $item['sgst'] = $item_sgst;
        $item['gst_total'] = $item_gst;

$total_items++;
        $total_qty += $quantity;
        $subtotal += $item_total;
        $total_cgst += $item_cgst;
        $total_sgst += $item_sgst;
        
        // Collect GST summary by tax rate
        $rate_key = $tax_percent . '%';
        if (!isset($gst_summary[$rate_key])) {
            $gst_summary[$rate_key] = [
                'rate' => $tax_percent,
                'taxable' => 0,
                'cgst' => 0,
                'sgst' => 0,
                'total_gst' => 0
            ];
        }
        $gst_summary[$rate_key]['taxable'] += $base_price * $quantity;
        $gst_summary[$rate_key]['cgst'] += $item_cgst;
        $gst_summary[$rate_key]['sgst'] += $item_sgst;
        $gst_summary[$rate_key]['total_gst'] += $item_gst;
    }

$bill['total_items'] = $total_items;
    $bill['total_qty'] = $total_qty;
    $bill['subtotal'] = $subtotal;
    $bill['gst_summary'] = $gst_summary;

// Calculate bill-level discount
    $discount_amount = 0;
    $discount_value = isset($bill['discount_value']) ? floatval($bill['discount_value']) : 0;
    $discount_type = isset($bill['discount_type']) ? $bill['discount_type'] : 'flat';

if ($discount_type === 'flat') {
        $discount_amount = min($discount_value, $subtotal);
    } elseif ($discount_type === 'percent') {
        $discount_amount = ($subtotal * min($discount_value, 100)) / 100;
    }
    $bill['discount_amount'] = $discount_amount;

// Calculate total taxable and GST
    $total_taxable = 0;
    foreach ($gst_summary as $gst) {
        $total_taxable += $gst['taxable'];
    }
    
    $bill['total_taxable'] = $total_taxable;
    $bill['cgst_amount'] = $total_cgst;
    $bill['sgst_amount'] = $total_sgst;
    $bill['gst_amount'] = $total_cgst + $total_sgst;

// Calculate final total (subtotal already includes GST)
    $bill['total_amount'] = $subtotal - $discount_amount;
    if ($bill['total_amount'] < 0)
        $bill['total_amount'] = 0;
}

// Function to get bill summary for AJAX response
function getBillSummary() {
    $bill = $_SESSION['current_bill'];
    return [
        'total_items' => $bill['total_items'],
        'total_qty' => $bill['total_qty'],
        'subtotal' => $bill['subtotal'],
        'total_taxable' => $bill['total_taxable'] ?? 0,
        'discount_amount' => $bill['discount_amount'],
        'cgst_amount' => $bill['cgst_amount'],
        'sgst_amount' => $bill['sgst_amount'],
        'gst_amount' => $bill['gst_amount'],
        'total_amount' => $bill['total_amount'],
        'gst_summary' => $bill['gst_summary'] ?? []
    ];
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update_bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation