    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">
&lt;?php
include(&quot;../db/cn.php&quot;);
ob_start();

// Fetch order details from the database
$orderId = isset($_GET[&#039;order_id&#039;]) ? mysqli_real_escape_string($connection, $_GET[&#039;order_id&#039;]) : null;
$orderDetails = [];
$outletName = $loginUser = $userRole = $outletAddress = $dateTime = $totalAmount = $paidBy = $customerName = $customerPhone = $discountedAmount = $discounted = $discountPer = $cashAmount = $changeAmount = $taxAmount = null;

if ($orderId) {
    $query = &quot;SELECT * FROM log_user_sales WHERE order_id = &#039;$orderId&#039; &amp;&amp; status=&#039;&#039; &amp;&amp; r_order_id = &#039;&#039;&quot;;
    $result = mysqli_query($connection, $query);

    if ($result &amp;&amp; mysqli_num_rows($result) &gt; 0) {
        $orderDetails = mysqli_fetch_all($result, MYSQLI_ASSOC);
        $order = $orderDetails[0];
        $outletName = $order[&#039;outlet_name&#039;];
        $loginUser = $order[&#039;login_user&#039;];
        $userRole = $order[&#039;user_role&#039;];
        $outletAddress = $order[&#039;outlet_address&#039;];
        $dateTime = $order[&#039;date_time&#039;];
        $totalAmount = $order[&#039;net_amount&#039;];
        $paidBy = $order[&#039;paid_by&#039;];
        $customerName = $order[&#039;customer_name&#039;];
        $customerPhone = $order[&#039;customer_phone&#039;];
        $discountedAmount = $order[&#039;discount_amount&#039;];
        $discounted = $order[&#039;discounted&#039;];
        $discountPer = $order[&#039;discount_per&#039;];
        $cashAmount = $order[&#039;cash_amount&#039;];
        $changeAmount = $order[&#039;change_amount&#039;];
        $taxAmount = $order[&#039;tax_amount&#039;];
    }
}

$content = ob_get_clean(); // Capture HTML content

// Function to send data to the printer
function sendToPrinter($result) {
    $printerName = &quot;EPSON_TM_T88V_Receipt&quot;; // Change to your printer&#039;s name
    $handle = @fopen(&quot;USB&quot;, &quot;w&quot;); // LPT1 is commonly used for parallel port printers, change if necessary
    if (!$handle) {
        echo &quot;Error opening printer on Windows. Check the printer port and connection.&quot;;
        return;
    }
    fwrite($handle, $result);
    fclose($handle);
    echo &quot;&quot;;
}

// Call the print function
sendToPrinter($content);
?&gt;


&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;title&gt;Print Order&lt;/title&gt;
&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.4.0/jspdf.umd.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.23/jspdf.plugin.autotable.min.js&quot;&gt;&lt;/script&gt;
   &lt;link href=&quot;https://fonts.googleapis.com/css2?family=Quicksand:wght@200;300;400;500;600;700&amp;display=swap&quot; rel=&quot;stylesheet&quot;&gt;

    &lt;style&gt;
    body {
    font-family: &#039;Quicksand&#039;, sans-serif;
    
}
        @media print {
            body {
                width: 72mm;
                margin: 0;
                padding: 0;
            }
            .container {
                width: 100%;
                margin: 0;
                padding: 0;
            }
            .no-print {
                display: none;
            }
            .text-center {
                text-align: center;
            }
            table {
                width: 100%;
                border-collapse: collapse;
            }
            th, td {
                border: 1px solid #000;
                padding: 5px;
                text-align: center;
            }
            .mb-0, .mb-1 {
                margin-bottom: 5px;
            }
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;div class=&quot;container&quot; id=&quot;invoice&quot;&gt;
    &lt;div class=&quot;text-center&quot; style=&quot;margin-left:10px;&quot;&gt;
       
        &lt;h2 style=&quot;font-weight:600; text-transform:uppercase;&quot;&gt;IRFAN TRADERS 
 &lt;/h2&gt;
        &lt;p class=&quot;mb-0&quot; style=&quot;font-size:16px;margin-top:5px;text-transform:uppercase;font-weight:600;&quot;&gt;
         Distributer Unilever Pakistan limited  ,Sultan Alhilal, Lipton Pakistan&lt;/p&gt;
         &lt;p class=&quot;mb-0&quot; style=&quot;font-size:14px;margin-top:5px;text-transform:uppercase;font-weight:600;&quot;&gt;
         Hameed Garden safdarabad Near Wapda Office district sheikpura&lt;/p&gt;
        &lt;p class=&quot;mb-0&quot; style=&quot;margin-top:-2px;font-weight:600;&quot;&gt;Irfan Ilyas 
 : 03403401121&lt;/p&gt;
         &lt;p class=&quot;mb-0&quot; style=&quot;margin-top:-2px;font-weight:600;&quot;&gt;Rizwan ilyas : 03334405300&lt;/p&gt;

        
        &lt;p style=&quot;margin-top:-3px;&quot;&gt;&lt;strong&gt;Date:&lt;/strong&gt; &lt;?php echo htmlspecialchars($dateTime); ?&gt; &lt;/p&gt;
    &lt;/div&gt;

    &lt;div&gt;
        &lt;p style=&quot;text-transform:capitalize;&quot;&gt;&lt;strong&gt;Name:&lt;/strong&gt; &lt;?php echo htmlspecialchars($customerName); ?&gt;&lt;br&gt;
        &lt;strong&gt;Phone:&lt;/strong&gt; &lt;?php echo htmlspecialchars($customerPhone); ?&gt;&lt;br&gt;
       &lt;strong&gt;Payment:&lt;/strong&gt; &lt;?php echo htmlspecialchars($paidBy); ?&gt;&lt;br&gt;
        &lt;strong&gt;Order ID:&lt;/strong&gt; &lt;?php echo htmlspecialchars($orderId); ?&gt;&lt;/p&gt;
    &lt;/div&gt;

    &lt;div&gt;
        &lt;table class=&quot;table table-bordered&quot;&gt;
            &lt;thead&gt;
                &lt;tr&gt;
                    &lt;th&gt;Product&lt;/th&gt;
                    &lt;th&gt;Qty&lt;/th&gt;
                    &lt;th&gt;Price&lt;/th&gt;
                    &lt;th&gt;Dis&lt;/th&gt;
                    &lt;th&gt;PKR&lt;/th&gt;
                    &lt;th&gt;Final&lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;
            &lt;tbody&gt;
                &lt;?php foreach ($orderDetails as $order): ?&gt;
                &lt;tr&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;product_name&#039;]); ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;product_quantity&#039;]); ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;product_price&#039;]); ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;discount&#039;]); ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;n_price&#039;]); ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;net_amount&#039;]); ?&gt;&lt;/td&gt;
                    
                &lt;/tr&gt;
                &lt;?php endforeach; ?&gt;
            &lt;/tbody&gt;
        &lt;/table&gt;
    &lt;/div&gt;
    &lt;?php
    $sub = mysqli_query($connection, &quot;SELECT SUM(net_amount) AS sub FROM log_user_sales WHERE order_id = &#039;$orderId&#039;&quot;);
    $rowSub = mysqli_fetch_array($sub);
    ?&gt;
    &lt;div&gt;
        &lt;p&gt;&lt;strong&gt;Sub:&lt;/strong&gt; Rs &lt;?php echo htmlspecialchars($rowSub[&quot;sub&quot;]); ?&gt; /-&lt;br&gt;
        &lt;strong&gt;Disc:&lt;/strong&gt; Rs &lt;?php echo htmlspecialchars($discounted); ?&gt; /-&lt;br&gt;
        &lt;strong&gt;Total:&lt;/strong&gt; Rs &lt;?php echo htmlspecialchars($discountedAmount) . &quot;.00&quot;; ?&gt; /-&lt;br&gt;
        &lt;strong&gt;Cash:&lt;/strong&gt; Rs &lt;?php echo htmlspecialchars($cashAmount) . &quot;.00&quot;; ?&gt; /-&lt;br&gt;
       &lt;strong&gt;Change:&lt;/strong&gt; Rs &lt;?php echo htmlspecialchars($changeAmount) ; ?&gt; /-&lt;br&gt;
    &lt;/div&gt;

    &lt;div&gt;
        &lt;p&gt;Generated By: ATR Software | 0334-8739892&lt;/p&gt;
    &lt;/div&gt;

    &lt;div&gt;
        &lt;h3&gt;Notes:&lt;/h3&gt;
      &lt;p&gt;1. Exchanges are accepted within 7 days from the date of purchase.&lt;br&gt;
       2. Items must be in their original condition with all tags attached.&lt;br&gt;
       3. A valid receipt or proof of purchase is required for all exchanges.&lt;/p&gt;
       
        &lt;h3 style=&quot;text-align:center;&quot;&gt;Thanks For Visiting.&lt;/h3&gt;
    &lt;/div&gt;

    &lt;div class=&quot;text-center no-print&quot;&gt;
        &lt;button class=&quot;no-print btn btn-primary&quot; onclick=&quot;window.print()&quot;&gt;Print&lt;/button&gt;
        &lt;button class=&quot;no-print btn btn-success&quot; onclick=&quot;downloadPDF()&quot;&gt;Download PDF&lt;/button&gt;
        &lt;button class=&quot;no-print btn btn-secondary&quot; onclick=&quot;window.location.href=&#039;mainpos.php&#039;&quot;&gt;Exit&lt;/button&gt;
    &lt;/div&gt;
&lt;/div&gt;


&lt;/body&gt;
&lt;script&gt;
    function downloadPDF() {
        // Import jsPDF
        const { jsPDF } = window.jspdf;
        const doc = new jsPDF(&#039;p&#039;, &#039;mm&#039;, &#039;a4&#039;);

        // Add the logo
        const img = new Image();
        img.src = &#039;img/Amazon Fashion STORE11.png&#039;;
        img.onload = function () {
            // Adding the logo
            doc.addImage(img, &#039;PNG&#039;, 10, 10, 40, 40);

            // Add the store name and other details
            doc.setFontSize(18);
            doc.text(&#039;Amazon Fashion Store&#039;, 60, 20);

            doc.setFontSize(12);
            doc.text(&#039;M. Block Near Ex M.N.A Office Arif Bazar, Burewala&#039;, 60, 30);
            doc.text(&#039;Muneeb: 0310-6089145, Safi Gujjar: 0303-4993253&#039;, 60, 40);
            doc.text(&#039;Date: &lt;?php echo htmlspecialchars($dateTime); ?&gt;&#039;, 60, 50);

            // Add customer details
            doc.setFontSize(14);
            doc.text(&#039;Customer Details&#039;, 10, 70);
            doc.setFontSize(12);
            doc.text(&#039;Name: &lt;?php echo htmlspecialchars($customerName); ?&gt;&#039;, 10, 80);
            doc.text(&#039;Phone: &lt;?php echo htmlspecialchars($customerPhone); ?&gt;&#039;, 10, 90);
            doc.text(&#039;Payment: &lt;?php echo htmlspecialchars($paidBy); ?&gt;&#039;, 10, 100);
            doc.text(&#039;Order ID: &lt;?php echo htmlspecialchars($orderId); ?&gt;&#039;, 10, 110);

            // Add the table header
            doc.setFontSize(14);
            doc.text(&#039;Order Details&#039;, 10, 130);
            doc.setFontSize(12);
            doc.autoTable({
                startY: 140,
                head: [[&#039;Product&#039;, &#039;Qty&#039;, &#039;Price&#039;, &#039;Dis&#039;, &#039;PKR&#039;]],
                body: [
                    &lt;?php foreach ($orderDetails as $order): ?&gt;
                    [&#039;&lt;?php echo htmlspecialchars($order[&#039;product_name&#039;]); ?&gt;&#039;, &#039;&lt;?php echo htmlspecialchars($order[&#039;product_quantity&#039;]); ?&gt;&#039;, &#039;&lt;?php echo htmlspecialchars($order[&#039;product_price&#039;]); ?&gt;&#039;, &#039;&lt;?php echo htmlspecialchars($order[&#039;discount&#039;]); ?&gt;&#039;, &#039;&lt;?php echo htmlspecialchars($order[&#039;net_amount&#039;]); ?&gt;&#039;],
                    &lt;?php endforeach; ?&gt;
                ],
                theme: &#039;grid&#039;
            });

            // Add totals
            let finalY = doc.lastAutoTable.finalY + 10;
            doc.setFontSize(14);
            doc.text(&#039;Summary&#039;, 10, finalY);
            doc.setFontSize(12);
            finalY += 10;
            doc.text(&#039;Sub: Rs &lt;?php echo htmlspecialchars($rowSub[&quot;sub&quot;]); ?&gt; /-&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;Disc: Rs &lt;?php echo htmlspecialchars($discounted); ?&gt; /-&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;Total: Rs &lt;?php echo htmlspecialchars($discountedAmount) . &quot;.00&quot;; ?&gt; /-&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;Cash: Rs &lt;?php echo htmlspecialchars($cashAmount) . &quot;.00&quot;; ?&gt; /-&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;Change: Rs &lt;?php echo htmlspecialchars($changeAmount); ?&gt; /-&#039;, 10, finalY);

            // Add footer
            finalY += 20;
            doc.text(&#039;Generated By: Amazon Fashion Store&#039;, 10, finalY);
            finalY += 10;
            doc.setFontSize(10);
            doc.text(&#039;Notes:&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;1. Exchanges are accepted within 7 days from the date of purchase.&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;2. Items must be unworn, unwashed, and in their original condition with all tags attached.&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;3. A valid receipt or proof of purchase is required for all exchanges.&#039;, 10, finalY);
            finalY += 10;
            doc.text(&#039;Thanks For Visiting.&#039;, 60, finalY + 20, &#039;center&#039;);

            // Save the PDF with the name &#039;invoice.pdf&#039;
            doc.save(&#039;invoice.pdf&#039;);
        };
    }
&lt;/script&gt;
&lt;/html&gt;

</code></pre>        </div>
    </div>