    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&#039;db/cn.php&#039;);
if(isset($_SESSION[&#039;user_name&#039;]) &amp;&amp; isset($_SESSION[&#039;user_role&#039;]) &amp;&amp; isset($_SESSION[&#039;outlet_name&#039;])
 &amp;&amp; isset($_SESSION[&#039;outlet_address&#039;])) {
    $userName = $_SESSION[&#039;user_name&#039;];
    $userRole = $_SESSION[&#039;user_role&#039;];
    $outlet_address = $_SESSION[&#039;outlet_address&#039;];
    $outlet_name = $_SESSION[&#039;outlet_name&#039;];
 }
// Fetch order_id from URL
$order_id = isset($_GET[&#039;order_id&#039;]) ? $_GET[&#039;order_id&#039;] : null;

$orderDetails = []; // Initialize array to hold order details
$query = &quot;SELECT product_name,product_price,product_quantity,tax_amount,total_amount,discount_amount,customer_name,customer_phone,paid_by,date_time
          FROM m_order
          WHERE login_user =&#039;$userName&#039; AND user_role = &#039;$userRole&#039; AND order_id = &#039;$order_id&#039;&quot;;
$result = $connection-&gt;query($query);

if ($result) {
    while ($row = $result-&gt;fetch_assoc()) {
        $orderDetails[] = $row;
    }
} else {
    echo &quot;Error: &quot; . $query . &quot;&lt;br&gt;&quot; . $connection-&gt;error;
}
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;link href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css&quot;&gt;
    &lt;title&gt;Ghani Glass House&lt;/title&gt;
    &lt;style&gt;
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        .container {
            margin: 20px auto;
            padding: 20px;
            border: 1px solid #fff;
            border-radius: 8px;
        }
        .header {
            text-align: center;
            margin-bottom: 20px;
        }
        
        th, td {
            
            padding: 8px;
            text-align: left;
        }
        th {
            background-color: #f2f2f2;
        }
        .total {
            text-align: right;
            font-weight: bold;
            margin-top: 10px;
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body onload=&quot;window.print()&quot;&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;header&quot;&gt;
         &lt;img src=&quot;img/print_logo.png&quot; width=&quot;40&quot; height=&quot;40&quot; /&gt;
            &lt;h5 style=&quot;margin-top:8px;&quot;&gt;GHANI GLASS &lt;/h5&gt;
             
        &lt;h4 style=&quot;margin-top:-7px; font-size:16px; font-weight:600;&quot; &gt;Al Hafeez Shopping Mall, Main Blvd Gulberg, Block D 1 Block D1 Gulberg III, Lahore&lt;/h4&gt;
        &lt;h5 style=&quot;margin-top:-6px; font-size:13px;&quot;&gt;Cell:0334-8739892&lt;/h5&gt;
        &lt;/div&gt;
        &lt;h6&gt;&lt;?php echo $order_id;?&gt;&lt;/h4&gt;
            &lt;p&gt;&lt;strong&gt;Name:&lt;/strong&gt; &lt;?php echo $orderDetails[0][&#039;customer_name&#039;]; ?&gt;&lt;/p&gt;
            &lt;p style=&quot;margin-top:-16px;&quot;&gt;&lt;strong&gt;Phone:&lt;/strong&gt; &lt;?php echo $orderDetails[0][&#039;customer_phone&#039;]; ?&gt;&lt;/p&gt;
            &lt;p style=&quot;margin-top:-16px;&quot; class=&quot;text-capitalize&quot;&gt;&lt;strong&gt;Paid By:&lt;/strong&gt; &lt;?php echo $orderDetails[0][&#039;paid_by&#039;]; ?&gt;&lt;/p&gt;
        &lt;table class=&quot;table table-striped table-hover&quot;&gt;
            &lt;thead&gt;
                &lt;tr&gt;
                    &lt;th&gt;Product Name&lt;/th&gt;
                    &lt;th&gt;Price&lt;/th&gt;
                     &lt;th&gt;Quantity&lt;/th&gt;
                    &lt;th&gt;Amount&lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;
            &lt;tbody&gt;
                &lt;?php foreach ($orderDetails as $item): ?&gt;
                    &lt;tr style=&quot;font-size:13px;&quot;&gt;
                        &lt;td style=&quot;font-size:10px;&quot;&gt;&lt;?php echo $item[&#039;product_name&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;product_price&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $item[&#039;product_quantity&#039;]; ?&gt;&lt;/td&gt;
                        
                        &lt;td&gt;&lt;?php echo number_format($item[&#039;product_price&#039;] * $item[&#039;product_quantity&#039;], 0); ?&gt;&lt;/td&gt;
                    &lt;/tr&gt;
                &lt;?php endforeach; ?&gt;
            &lt;/tbody&gt;
        &lt;/table&gt;
        &lt;div class=&quot;total&quot;&gt;
            &lt;!-- Total amount will be printed here --&gt;
            &lt;?php
                $totalAmount = array_reduce($orderDetails, function ($carry, $item) {
                    return $carry + ($item[&#039;product_price&#039;] * $item[&#039;product_quantity&#039;]);
                }, 0);
                echo &quot;Sub: Rs &quot; . number_format($totalAmount,0).&quot;&lt;br&gt;&quot;;
				echo &quot;Disc: Rs &quot;.$item[&quot;discount_amount&quot;].&quot;&lt;br&gt;&quot;;
				echo &quot;Total: Rs &quot;.$item[&quot;total_amount&quot;];
				            ?&gt;
            
        &lt;/div&gt;
        
        &lt;div class=&quot;notes&quot; style=&quot;font-size:13px;&quot;&gt;
            &lt;h4&gt;Notes:&lt;/h4&gt;
            &lt;p&gt;Specific Items Can Be Returned OR Rxchanged Within 10 Days.&lt;/p&gt;
        &lt;/div&gt;&lt;br&gt;
        &lt;h5 style=&quot;font-size:15px;&quot;&gt;Generated By:&lt;span style=&quot;font-size:14px; font-weight:500; text-transform:capitalize;&quot;&gt;
        &amp;nbsp;&amp;nbsp;&lt;?php echo $_SESSION[&#039;user_role&#039;]; ?&gt;&lt;/span&gt;&lt;/h4&gt;
        &lt;div&gt;
            
</code></pre>        </div>
    </div>