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/poorva

Free Space:

10.15 TB

🔧 Quick Actions

✏️ Editing: sales-receipt.php

<?php
session_start();
require_once 'includes/db.php';

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

$branch_id = $_SESSION['branch_id'];

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    die('Invalid invoice ID.');
}

$sale_id = (int)$_GET['id'];
$referer = $_SERVER['HTTP_REFERER'] ?? 'sales-new.php';

// Fetch Branch Details
$branch_stmt = $conn->prepare("
    SELECT branch_name, address, city, state, pincode, phone, email, gst_number, branch_code
    FROM branches 
    WHERE id = ? 
    LIMIT 1
");
$branch_stmt->bind_param("i", $branch_id);
$branch_stmt->execute();
$branch = $branch_stmt->get_result()->fetch_assoc();
$branch_stmt->close();

if (!$branch) {
    die('Branch not found.');
}

// Fetch Sale Data - including EMI fields
$stmt = $conn->prepare("
    SELECT s.*, 
           c.customer_name, c.customer_phone, c.customer_email, c.customer_address,
           c.customer_phone_alternate
    FROM sales s 
    LEFT JOIN customers c ON s.customer_id = c.id 
    WHERE s.id = ? 
    LIMIT 1
");
$stmt->bind_param("i", $sale_id);
$stmt->execute();
$sale = $stmt->get_result()->fetch_assoc();
$stmt->close();

if (!$sale) {
    die('Invoice not found.');
}

// Format invoice number to 7 digits without branch ID
$invoice_number = $sale['invoice_number'] ?? $sale['sale_number'];
// Extract numeric part and pad to 7 digits
if (preg_match('/(\d+)$/', $invoice_number, $matches)) {
    $numeric_part = $matches[1];
    // Remove branch code/ID prefix if present
    $cleaned_numeric = preg_replace('/[^0-9]/', '', $numeric_part);
    // Pad to 7 digits
    $invoice_number = str_pad($cleaned_numeric, 7, '0', STR_PAD_LEFT);
} else {
    // If no numeric pattern found, use a sequential number from sale ID
    $invoice_number = str_pad($sale_id, 7, '0', STR_PAD_LEFT);
}

// Fetch finance partner name from finance_master table if finance_partner exists in sale
$finance_name = '';
if (!empty($sale['finance_partner']) && is_numeric($sale['finance_partner'])) {
    $finance_stmt = $conn->prepare("
        SELECT finance_name 
        FROM finance_master 
        WHERE branch_id = ? AND id = ?
        LIMIT 1
    ");
    $finance_stmt->bind_param("ii", $branch_id, $sale['finance_partner']);
    $finance_stmt->execute();
    $finance_result = $finance_stmt->get_result();
    if ($finance_row = $finance_result->fetch_assoc()) {
        $finance_name = $finance_row['finance_name'];
    }
    $finance_stmt->close();
}

// Use branch info as company info
$sale['company_name'] = $branch['branch_name'];
$sale['gstn_number'] = $branch['gst_number'] ?? 'GST Not Available';
$sale['company_address'] = trim($branch['address'] . ', ' . $branch['city'] . ' - ' . $branch['pincode']);
$sale['company_phone'] = $branch['phone'] ?? '+91 98765 43210';
$sale['company_email'] = $branch['email'] ?? 'info@example.com';

// Fetch IMEI/Serial from sale_items table (entered during sale)
$items_stmt = $conn->prepare("
    SELECT si.*, 
           p.product_name, p.brand_id, p.model, p.imei_number_1, p.imei_number_2, p.serial_number,
           p.warranty_period, b.brand_name,
           c.category_name
    FROM sale_items si 
    JOIN products p ON si.product_id = p.id 
    LEFT JOIN brands b ON p.brand_id = b.id
    LEFT JOIN categories c ON p.category_id = c.id
    WHERE si.sale_id = ?
");
$items_stmt->bind_param("i", $sale_id);
$items_stmt->execute();
$items_result = $items_stmt->get_result();

// Store items in array for reuse
$items = [];
$warranty_info = [];
$gst_applicable_for_sale = false;
$total_cgst = 0;
$total_sgst = 0;
$total_gst_amount = 0;
$has_imei_serial_data = false;

while ($item = $items_result->fetch_assoc()) {
    // Determine product type based on what's stored in product
    $product_type = 'none';
    if (!empty($item['imei_number_1']) || !empty($item['imei_number_2'])) {
        if (!empty($item['serial_number'])) {
            $product_type = 'both';
        } else {
            $product_type = 'imei';
        }
    } elseif (!empty($item['serial_number'])) {
        $product_type = 'serial';
    }
    
    // Add product type to item
    $item['product_type'] = $product_type;
    $items[] = $item;
    
    // Check if this item has IMEI/Serial data
    if (!empty($item['imei_number_1']) || !empty($item['imei_number_2']) || !empty($item['serial_number'])) {
        $has_imei_serial_data = true;
    }
    
    if (!empty($item['warranty_period'])) {
        $warranty_info[] = [
            'product_name' => $item['product_name'],
            'warranty_period' => $item['warranty_period']
        ];
    }
    
    if ($item['gst_applicable']) {
        $gst_applicable_for_sale = true;
        $item_cgst = $item['gst_amount'] / 2;
        $item_sgst = $item['gst_amount'] / 2;
        $total_cgst += $item_cgst;
        $total_sgst += $item_sgst;
        $total_gst_amount += $item['gst_amount'];
    }
}

// Prepare warranty summary
$warranty_summary = '';
if (!empty($warranty_info)) {
    $warranty_items = [];
    foreach ($warranty_info as $warranty) {
        $warranty_items[] = $warranty['product_name'] . ': ' . $warranty['warranty_period'];
    }
    $warranty_summary = implode(' | ', $warranty_items);
} else {
    $warranty_summary = 'As per manufacturer warranty terms';
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Invoice <?= htmlspecialchars($invoice_number) ?> - <?= htmlspecialchars($branch['branch_name']) ?></title>
    <style>
        @page { 
            margin: 0.5cm; 
            size: A4; 
        }
        body {
            font-family: Arial, sans-serif;
            margin: 0 auto;
            padding: 15px;
            font-size: 11px;
            line-height: 1.3;
            position: relative;
            width: 21cm; /* A4 width */
            min-height: 29.7cm; /* A4 height */
            background: white;
            box-sizing: border-box;
        }
        table { 
            width: 100%; 
            border-collapse: collapse; 
            page-break-inside: auto;
        }
        tr {
            page-break-inside: avoid;
            page-break-after: auto;
        }
        td, th { 
            border: 1px solid #000; 
            padding: 5px; 
            vertical-align: top; 
        }
        .text-center { text-align: center; }
        .text-right { text-align: right; }
        .text-left { text-align: left; }
        .text-bold { font-weight: bold; }
        .logo { 
            width: 100px; 
            height: auto; 
        }
        .no-border { border: none; }
        .mt-10 { margin-top: 10px; }
        .mb-10 { margin-bottom: 10px; }
        
        /* Logo Watermark - Increased opacity */
        .logo-watermark {
            position: fixed;
            top: 50%;
            left: 50%;
            transform: translate(-50%, -50%);
            opacity: 0.20;
            z-index: -1;
            pointer-events: none;
            width: 500px;
            height: 500px;
        }
        
        .logo-watermark img {
            width: 100%;
            height: 100%;
            object-fit: contain;
            filter: grayscale(100%);
        }
        
        /* Text fallback for watermark */
        .text-watermark {
            position: fixed;
            top: 50%;
            left: 50%;
            transform: translate(-50%, -50%);
            opacity: 0.08;
            z-index: -1;
            pointer-events: none;
            font-size: 120px;
            font-weight: bold;
            color: #aaa;
            display: none;
        }
        
        .company-header {
            border: 2px solid #000;
            padding: 8px;
            margin-bottom: 10px;
        }
        
        .signature-space {
            height: 60px;
            position: relative;
        }
        
        .item-details {
            font-size: 10px;
            line-height: 1.2;
        }
        
        .item-line {
            margin-bottom: 2px;
        }
        
        /* Print controls */
        .print-controls {
            position: fixed;
            top: 10px;
            right: 10px;
            background: white;
            padding: 10px;
            border: 1px solid #ccc;
            border-radius: 5px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
            z-index: 1000;
        }
        
        .print-controls button {
            margin: 5px;
            padding: 8px 15px;
            background: #007bff;
            color: white;
            border: none;
            border-radius: 3px;
            cursor: pointer;
        }
        
        .print-controls button:hover {
            background: #0056b3;
        }
        
        @media print { 
            body { 
                -webkit-print-color-adjust: exact; 
                margin: 0.5cm auto;
                padding: 0;
                width: 100%;
                min-height: auto;
            }
            .logo-watermark { 
                display: block;
                opacity: 0.10;
            }
            .text-watermark {
                opacity: 0.08;
            }
            .print-controls { display: none; }
            table {
                page-break-inside: auto;
            }
            tr {
                page-break-inside: avoid;
                page-break-after: auto;
            }
            thead {
                display: table-header-group;
            }
            tfoot {
                display: table-footer-group;
            }
        }
        
        /* Ensure watermark is visible on screen */
        .logo-watermark {
            display: block !important;
        }
        
        .gst-notice {
            background-color: #fff3cd;
            padding: 6px;
            border: 1px solid #ffeaa7;
            margin-bottom: 8px;
            text-align: center;
            font-weight: bold;
            font-size: 10px;
        }
        
        .amount-summary {
            background: #f8f9fa;
            border: 1px solid #dee2e6;
        }
        
        .total-row {
            background: #e9ecef;
            font-weight: bold;
        }
        
        /* IMEI/Serial display styles */
        .serial-info {
            font-family: 'Courier New', monospace;
            font-size: 9px;
            color: #000;
            background: #f8f9fa;
            padding: 3px 5px;
            margin-top: 3px;
            font-weight: bold;
            letter-spacing: 0.5px;
            border-radius: 3px;
            border-left: 3px solid;
        }
        
        .imei-info { border-left-color: #dc3545; }
        .serial-info-only { border-left-color: #0d6efd; }
        .both-info { border-left-color: #fd7e14; }
        .none-info { border-left-color: #6c757d; }
        
        .imei-label {
            background: #dc3545 !important;
            color: white;
            padding: 1px 4px;
            border-radius: 2px;
            font-size: 8px;
            margin-right: 3px;
            font-weight: bold;
        }
        
        .serial-label {
            background: #0d6efd !important;
            color: white;
            padding: 1px 4px;
            border-radius: 2px;
            font-size: 8px;
            margin-right: 3px;
            font-weight: bold;
        }
        
        /* Terms & Conditions Box */
        .terms-box {
            border: 2px solid #000;
            padding: 8px;
            margin-top: 5px;
            background: #fff;
        }
        
        .terms-section {
            font-size: 9px;
            line-height: 1.3;
        }
        
        .language-section {
            margin-bottom: 5px;
        }
        
        .language-title {
            font-weight: bold;
            margin-bottom: 2px;
            text-decoration: underline;
            font-size: 10px;
        }
        
        .warranty-notice {
            padding: 4px 8px;
            margin: 3px 0;
            font-size: 9px;
            border-radius: 3px;
            background: #d4edda;
            border: 1px solid #c3e6cb;
        }
        
        /* Product type indicator badge */
        .product-type-badge {
            display: inline-block;
            padding: 1px 4px;
            border-radius: 2px;
            font-size: 8px;
            margin-left: 5px;
        }
        
        .imei-badge { background: #f8d7da; color: #721c24; border: 1px solid #f5c6cb; }
        .serial-badge { background: #cce5ff; color: #004085; border: 1px solid #b8daff; }
        .both-badge { background: #fff3cd; color: #856404; border: 1px solid #ffeaa7; }
        .none-badge { background: #e2e3e5; color: #383d41; border: 1px solid #d6d8db; }
        
        .branch-code {
            display: inline-block;
            background: #0d6efd;
            color: white;
            padding: 2px 8px;
            border-radius: 3px;
            font-size: 10px;
            margin-left: 10px;
        }
        
        .logo-fallback {
            width: 70px;
            height: 70px;
            border: 2px solid #000;
            text-align: center;
            line-height: 70px;
            font-weight: bold;
            margin: 0 auto;
        }
        
        .product-description {
            max-width: 300px;
            word-wrap: break-word;
        }
        
        .gst-column {
            min-width: 70px;
        }
        
        .amount-column {
            min-width: 80px; /* Reduced size */
        }
        
        .product-header {
            background: #f8f9fa;
            padding: 3px;
            margin-bottom: 3px;
            border-radius: 3px;
        }
        
        .gst-number-display {
            background: #f8f9fa;
            padding: 3px 8px;
            border-radius: 3px;
            font-weight: bold;
            font-size: 10px;
            margin-top: 3px;
            border: 1px dashed #6c757d;
        }
        
        .finance-info {
            background: #e7f1ff;
            padding: 3px 8px;
            border-radius: 3px;
            font-size: 10px;
            border: 1px solid #b8daff;
            margin-top: 3px;
        }
        
        /* Invoice container for better centering */
        .invoice-container {
            width: 100%;
            max-width: 21cm;
            margin: 0 auto;
            position: relative;
            z-index: 1;
        }
        
        /* Customer address styling */
        .customer-address {
            font-size: 10px;
            line-height: 1.4;
            margin-top: 3px;
            color: #333;
        }
        
        .customer-detail-label {
            font-weight: bold;
            color: #555;
        }
        
        .bill-to-section {
            background: #f9f9f9;
            padding: 5px;
            border-radius: 3px;
        }
        
        /* Left side blank space for terms */
        .terms-container {
            display: flex;
            gap: 10px;
        }
        
        .terms-left {
            width: 50%;
            border-right: 1px solid #ccc;
            padding-right: 8px;
        }
        
        .terms-right {
            width: 50%;
            padding-left: 8px;
        }
        
        /* Reduced amount column width */
        .amount-table th, .amount-table td {
            padding: 4px 5px;
        }
        
        /* Place of supply styling */
        .place-supply {
            display: inline-block;
            background: #f8f9fa;
            padding: 2px 8px;
            border-radius: 3px;
            margin-top: 3px;
        }
    </style>
</head>
<body>

<div class="print-controls">
    <button onclick="window.print()">
        <i class="fas fa-print"></i> Print Invoice
    </button>
    <button onclick="goBack()">
        <i class="fas fa-arrow-left"></i> Back
    </button>
</div>

<div class="logo-watermark">
    <img src="assets/images/poorva1.png" alt="Watermark Logo" 
         onerror="this.style.display='none'; document.getElementById('textWatermark').style.display='block';">
</div>

<div class="text-watermark" id="textWatermark">
    <?= htmlspecialchars($branch['branch_name']) ?>
</div>

<div class="invoice-container">

<table class="mb-10">
    <tr>
        <td colspan="2" class="no-border text-center">
            <h3 style="margin:3px 0; font-size:13px; text-decoration:underline; text-transform: uppercase;">
                <?php if ($gst_applicable_for_sale): ?>
                    TAX INVOICE
                <?php else: ?>
                    RECEIPT
                <?php endif; ?>
            </h3>
        </td>
    </tr>
</table>

<table class="mb-10 company-header">
    <tr>
        <td width="20%" class="no-border text-center">
            <img src="assets/images/poorva1.png" alt="<?= htmlspecialchars($branch['branch_name']) ?>" class="logo" 
                 onerror="this.style.display='none'; document.getElementById('logoFallback').style.display='block';">
            <div id="logoFallback" style="display:none;" class="logo-fallback">
                RCP
            </div>
        </td>
        <td width="80%" class="no-border text-left">
            <h2 style="margin:2px 0; font-size:16px; text-transform: uppercase;">
                <?= htmlspecialchars($branch['branch_name']) ?>
                <?php if (!empty($branch['branch_code'])): ?>
                    <span class="branch-code"><?= htmlspecialchars($branch['branch_code']) ?></span>
                <?php endif; ?>
            </h2>
            <p style="margin:2px 0; font-size:10px;">
                <?= htmlspecialchars($branch['address']) ?><br>
                <?= htmlspecialchars($branch['city']) ?> - <?= htmlspecialchars($branch['pincode']) ?><br>
                Phone: <?= htmlspecialchars($branch['phone']) ?> | Email: <?= htmlspecialchars($branch['email']) ?><br>
                
                
                <?php if (!empty($branch['gst_number'])): ?>
                    <div class="gst-number-display">
                        GSTIN: <?= htmlspecialchars($branch['gst_number']) ?>
                    </div>
                <?php endif; ?>
            </p>
        </td>
    </tr>
</table>

<table class="mb-10">
    <tr>
        <td width="50%" class="bill-to-section">
            <strong>Bill To:</strong><br>
            <span class="customer-detail-label">Name:</span> <?= htmlspecialchars($sale['customer_name']) ?><br>
            
            <?php if (!empty($sale['customer_address'])): ?>
            <span class="customer-detail-label">Address:</span> 
            <span class="customer-address"><?= nl2br(htmlspecialchars($sale['customer_address'])) ?></span><br>
            <?php endif; ?>
            
            <span class="customer-detail-label">Phone:</span> <?= htmlspecialchars($sale['customer_phone']) ?><br>
            
            <?php if (!empty($sale['customer_phone_alternate'])): ?>
            <span class="customer-detail-label">Alt Phone:</span> <?= htmlspecialchars($sale['customer_phone_alternate']) ?><br>
            <?php endif; ?>
            
            <?php if (!empty($sale['customer_email'])): ?>
            <span class="customer-detail-label">Email:</span> <?= htmlspecialchars($sale['customer_email']) ?><br>
            <?php endif; ?>
        </td>
        <td width="50%">
            <strong>Invoice Details:</strong><br>
            Invoice No: <strong><?= htmlspecialchars($invoice_number) ?></strong><br>
            Invoice Date: <strong><?= date('d-m-Y', strtotime($sale['sale_date'])) ?></strong><br>
            <?php if ($gst_applicable_for_sale): ?>
                
                <span class="place-supply">
                    <strong>Place of Supply:</strong> Papparapatti<br>
                </span>
            <?php endif; ?>
            Payment Method: <strong>
                <?php 
                if ($sale['payment_type'] == 'TVS') {
                    echo 'TVS FINANCE';
                } elseif ($sale['payment_type'] == 'Bajaj') {
                    echo 'BAJAJ FINANCE';
                } else {
                    echo strtoupper(htmlspecialchars($sale['payment_type']));
                }
                ?>
            </strong><br>
            Status: <strong style="color: <?= $sale['payment_status'] == 'paid' ? '#28a745' : ($sale['payment_status'] == 'partial' ? '#ffc107' : '#dc3545') ?>;">
                <?= strtoupper(htmlspecialchars($sale['payment_status'])) ?>
            </strong>
            
            
            <?php if ($sale['payment_type'] == 'TVS' || $sale['payment_type'] == 'Bajaj'): ?>
                <div class="finance-info">
                    Finance Partner: <strong><?= strtoupper(htmlspecialchars($sale['payment_type'])) ?> Finance</strong>
                </div>
            <?php endif; ?>
            
            
            <?php if (!empty($sale['emi_due_date'])): ?>
                <div class="finance-info">
                    EMI Due Date: <strong><?= date('d-m-Y', strtotime($sale['emi_due_date'])) ?></strong>
                </div>
            <?php endif; ?>
        </td>
    </tr>
</table>

<table class="mb-10">
    <thead>
        <tr>
            <th width="5%" style="min-width: 25px;">S.No</th>
            <th width="60%" class="product-description">Product Description & Specifications</th>
            <th width="6%" style="min-width: 40px;">Qty</th>
            <th width="12%" style="min-width: 60px;">Unit Price</th>
            <th width="17%" style="min-width: 80px;" class="amount-column">Amount (₹)</th>
        </tr>
    </thead>
    <tbody>
        <?php 
        $subtotal = 0;
        $counter = 1;
        foreach ($items as $item): 
            $item_total = $item['quantity'] * $item['unit_price'];
            $item_total_with_gst = $item['total_price_with_gst'];
            $subtotal += $item_total;
            
            // Get IMEI/Serial from products table (pre-stored)
            $imei1 = isset($item['imei_number_1']) ? trim($item['imei_number_1']) : '';
            $imei2 = isset($item['imei_number_2']) ? trim($item['imei_number_2']) : '';
            $serial_number = isset($item['serial_number']) ? trim($item['serial_number']) : '';
            
            // Get product type from determination
            $product_type = $item['product_type'];
            
            // Determine which class to use based on product type
            $serial_info_class = '';
            switch($product_type) {
                case 'imei':
                    $serial_info_class = 'imei-info';
                    break;
                case 'serial':
                    $serial_info_class = 'serial-info-only';
                    break;
                case 'both':
                    $serial_info_class = 'both-info';
                    break;
                case 'none':
                default:
                    $serial_info_class = 'none-info';
                    break;
            }
            
            // Determine badge text and class
            $product_badge_class = '';
            $product_badge_text = '';
            switch($product_type) {
                case 'imei':
                    $product_badge_class = 'imei-badge';
                    $product_badge_text = 'IMEI Product';
                    break;
                case 'serial':
                    $product_badge_class = 'serial-badge';
                    $product_badge_text = 'Serial Product';
                    break;
                case 'both':
                    $product_badge_class = 'both-badge';
                    $product_badge_text = 'IMEI + Serial Product';
                    break;
                case 'none':
                default:
                    $product_badge_class = 'none-badge';
                    $product_badge_text = 'Standard Product';
                    break;
            }
        ?>
        <tr>
            <td class="text-center"><?= $counter++ ?></td>
            <td class="product-description">
                <div class="item-details">
                    <div class="product-header">
                        <strong><?= htmlspecialchars($item['product_name']) ?></strong>
                        <span class="product-type-badge <?= $product_badge_class ?>"><?= $product_badge_text ?></span>
                        <?php if ($item['gst_applicable']): ?>
                            <span style="color: #28a745; font-size: 9px; margin-left: 5px;">
                                (GST @<?= $item['gst_percentage'] ?>%)
                            </span>
                        <?php endif; ?>
                    </div>
                    
                    <div class="item-line">
                        <strong>Brand:</strong> <?= htmlspecialchars($item['brand_name']) ?> | 
                        <strong>Model:</strong> <?= htmlspecialchars($item['model']) ?>
                    </div>
                    
                    
                    <?php if ($imei1 || $imei2 || $serial_number): ?>
                    <div class="serial-info <?= $serial_info_class ?>">
                        <?php 
                        // Always show IMEI if it exists
                        if ($imei1): ?>
                            <span class="imei-label">IMEI 1</span> <?= htmlspecialchars($imei1) ?><br>
                        <?php endif; 
                        if ($imei2): ?>
                            <span class="imei-label">IMEI 2</span> <?= htmlspecialchars($imei2) ?><br>
                        <?php endif;
                        
                        // Always show Serial if it exists
                        if ($serial_number): ?>
                            <span class="serial-label">SERIAL</span> <?= htmlspecialchars($serial_number) ?><br>
                        <?php endif;
                        ?>
                    </div>
                    <?php endif; ?>
                    
                    
                    <?php if (!empty($item['warranty_period'])): ?>
                    <div class="warranty-notice">
                        <strong>Warranty:</strong> <?= strtoupper($item['warranty_period']) ?>
                    </div>
                    <?php endif; ?>
                    
                    
                    <div style="font-size: 8px; color: #666; margin-top: 3px;">
                        Category: <?= htmlspecialchars($item['category_name']) ?> 
                    </div>
                </div>
            </td>
            <td class="text-center"><?= $item['quantity'] ?></td>
            <td class="text-right">₹<?= number_format($item['unit_price'], 2) ?></td>
            <td class="text-right amount-column">
                ₹<?= number_format($item_total_with_gst, 2) ?>
                <?php if ($item['gst_applicable']): ?>
                    <br><small style="color: #28a745; font-size: 8px;">Inc. GST: ₹<?= number_format($item['gst_amount'], 2) ?></small>
                <?php endif; ?>
            </td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>

<table class="mb-10 amount-summary" style="width: 50%; margin-left: auto;">
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">Sub Total:</td>
        <td class="text-right" style="padding: 4px; width: 100px;">₹<?= number_format($subtotal, 2) ?></td>
    </tr>
    
    <?php if ($gst_applicable_for_sale): ?>
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">CGST:</td>
        <td class="text-right" style="padding: 4px;">₹<?= number_format($total_cgst, 2) ?></td>
    </tr>
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">SGST:</td>
        <td class="text-right" style="padding: 4px;">₹<?= number_format($total_sgst, 2) ?></td>
    </tr>
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">Total GST:</td>
        <td class="text-right" style="padding: 4px;">₹<?= number_format($total_gst_amount, 2) ?></td>
    </tr>
    <?php endif; ?>
    
    <tr class="total-row">
        <td class="text-right text-bold" style="padding: 4px;">Grand Total:</td>
        <td class="text-right text-bold" style="padding: 4px;">₹<?= number_format($sale['total_amount'], 2) ?></td>
    </tr>
    
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">Paid Amount:</td>
        <td class="text-right text-bold" style="padding: 4px; color: #28a745;">₹<?= number_format($sale['paid_amount'], 2) ?></td>
    </tr>
    
    <?php if ($sale['due_amount'] > 0): ?>
    <tr>
        <td class="text-right text-bold" style="padding: 4px;">Due Amount:</td>
        <td class="text-right text-bold" style="padding: 4px; color: #dc3545;">₹<?= number_format($sale['due_amount'], 2) ?></td>
    </tr>
    <tr>
        <td colspan="2" class="text-center" style="font-size: 9px; padding: 4px; color: #dc3545;">
            <strong>
                <?php if (!empty($sale['emi_due_date'])): ?>
                    EMI Due Date: <?= date('d-m-Y', strtotime($sale['emi_due_date'])) ?>
                <?php elseif (!empty($sale['credit_due_date'])): ?>
                    Payment Due Date: <?= date('d-m-Y', strtotime($sale['credit_due_date'])) ?>
                <?php endif; ?>
            </strong>
        </td>
    </tr>
    <?php endif; ?>
</table>

<table class="mb-10">
    <tr>
        <td width="70%">
            <strong>Amount in Words:</strong><br>
            <em>Indian Rupees <?= convertNumberToWords($sale['total_amount']) ?> Only</em>
        </td>
        <td width="30%">
            <strong>Payment Info:</strong><br>
            Type: <strong>
                <?php 
                if ($sale['payment_type'] == 'TVS') {
                    echo 'TVS FINANCE';
                } elseif ($sale['payment_type'] == 'Bajaj') {
                    echo 'BAJAJ FINANCE';
                } else {
                    echo strtoupper(htmlspecialchars($sale['payment_type']));
                }
                ?>
            </strong><br>
            Status: <span style="color: <?= $sale['payment_status'] == 'paid' ? '#28a745' : ($sale['payment_status'] == 'partial' ? '#ffc107' : '#dc3545') ?>; font-weight: bold;">
                <?= strtoupper(htmlspecialchars($sale['payment_status'])) ?>
            </span>
            <?php if (!empty($sale['credit_due_date'])): ?>
            <br>Due Date: <?= date('d-m-Y', strtotime($sale['credit_due_date'])) ?>
            <?php endif; ?>
            
            <?php if (!empty($sale['emi_due_date'])): ?>
            <br>EMI Due: <?= date('d-m-Y', strtotime($sale['emi_due_date'])) ?>
            <?php endif; ?>
        </td>
    </tr>
</table>

<table class="mb-10">
    <tr>
        <td class="no-border" style="padding: 0;">
            <div class="terms-box">
                <div class="terms-container">
                    <div class="terms-left">
                        <strong>Terms & Conditions:</strong><br>
                        <div class="terms-section">
                            
                            <div class="language-section">
                                <div class="language-title">Terms:</div>
                                1. Goods once sold will not be taken back or exchanged<br>
                                2. Warranty as per manufacturer terms and conditions<br>
                                <strong>3. WARRANTY PERIOD: <?= $warranty_summary ?></strong><br>
                                4. Warranty void if device is tampered with or physically damaged<br>
                                5. Please keep this invoice for warranty claims - contains IMEI/Serial numbers<br>
                                6. All disputes subject to <?= htmlspecialchars($branch['city']) ?> jurisdiction only<br>
                                7. E. & O.E.
                            </div>
                            <?php if (!empty($sale['notes'])): ?>
                            <div style="margin-top: 5px; padding: 5px; background: #f8f9fa; border-left: 3px solid #17a2b8;">
                                <strong>Notes:</strong> <?= nl2br(htmlspecialchars($sale['notes'])) ?>
                            </div>
                            <?php endif; ?>
                        </div>
                    </div>
                    <div class="terms-right">
                        
                        &nbsp;
                    </div>
                </div>
            </div>
        </td>
    </tr>
</table>

<table class="mb-10">
    <tr>
        <td width="60%">
            <strong>Customer Declaration:</strong><br>
            I hereby acknowledge receipt of the goods in good condition and confirm that all specifications match my order.
            <?php if ($has_imei_serial_data): ?>
            I have verified the IMEI/Serial numbers as shown above.
            <?php endif; ?>
            <?php if (!empty($sale['emi_due_date'])): ?>
            <br>I acknowledge the EMI due date of <?= date('d-m-Y', strtotime($sale['emi_due_date'])) ?>.
            <?php endif; ?>
            <?php if ($sale['payment_type'] == 'TVS' || $sale['payment_type'] == 'Bajaj'): ?>
            <br>I acknowledge the finance terms with <?= strtoupper(htmlspecialchars($sale['payment_type'])) ?> Finance.
            <?php endif; ?>
            <div class="signature-space">
                _________________________<br>
                <em>Customer Signature with Date</em>
            </div>
        </td>
        <td width="40%" class="text-right">
            <strong>For <?= htmlspecialchars($branch['branch_name']) ?></strong><br>
            <div class="signature-space">
                _________________________<br>
                <em>Authorized Signatory</em>
            </div>
        </td>
    </tr>
</table>
</div>

// Auto-print on load
window.onload = function() {
    setTimeout(function() {
        window.print();
    }, 500);
    
    if (window.matchMedia) {
        const mediaQueryList = window.matchMedia('print');
        mediaQueryList.addListener(function(mql) {
            if (!mql.matches) {
                setTimeout(function() {
                    goBack();
                }, 500);
            }
        });
    }
    
    window.onafterprint = function() {
        setTimeout(function() {
            goBack();
        }, 500);
    };
};

// Fallback: if no print events fire, go back after 10 seconds
setTimeout(function() {
    goBack();
}, 10000);

// Keyboard shortcut for going back (Esc key)
document.addEventListener('keydown', function(e) {
    if (e.key === 'Escape') {
        goBack();
    }
});

// Add copy IMEI/Serial function for easy copying
document.addEventListener('dblclick', function(e) {
    if (e.target.classList.contains('serial-info')) {
        const textToCopy = e.target.innerText
            .replace(/IMEI \d:|SERIAL:|Product Details:/g, '')
            .replace(/^\s*[\r\n]/gm, '')
            .trim();
        
        if (textToCopy) {
            navigator.clipboard.writeText(textToCopy).then(function() {
                const originalText = e.target.innerHTML;
                e.target.innerHTML = '<span style="color:#28a745; font-weight:bold;">✓ Copied to clipboard!</span>';
                setTimeout(function() {
                    e.target.innerHTML = originalText;
                }, 2000);
            });
        }
    }
});
</script>

</body>
</html>

<?php
// Number to Words Function
function convertNumberToWords($number) {
    $ones = ["", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", 
             "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen"];
    $tens = ["", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety"];
    $thousands = ["", "Thousand", "Lakh", "Crore"];

if ($number == 0) return 'Zero';

$rupees = floor($number);
    $paisa = round(($number - $rupees) * 100);
    
    $words = '';
    
    if ($rupees > 0) {
        $counter = 0;
        $num = $rupees;
        
        while ($num > 0) {
            $part = $num % 1000;
            if ($part > 0) {
                $partWords = '';
                if ($part >= 100) {
                    $partWords .= $ones[floor($part / 100)] . ' Hundred ';
                    $part %= 100;
                }
                if ($part >= 20) {
                    $partWords .= $tens[floor($part / 10)] . ' ';
                    $part %= 10;
                }
                if ($part > 0) {
                    $partWords .= $ones[$part] . ' ';
                }
                $words = $partWords . $thousands[$counter] . ' ' . $words;
            }
            $num = floor($num / 1000);
            $counter++;
        }
    } else {
        $words = 'Zero ';
    }
    
    $words = trim($words) . ' Rupees';
    
    if ($paisa > 0) {
        $words .= ' and ' . convertNumberToWords($paisa) . ' Paisa';
    }
    
    return $words;
}

$items_stmt->close();
mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-receipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation