    <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();

$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_sale WHERE order_id = &#039;$orderId&#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;user_name&#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;];
        @$preAmount = $order[&#039;pre_amount&#039;];
        $grandAmount = $order[&#039;grand_total&#039;];
        $cashAmount = $order[&#039;cash_amount&#039;];
        $changeAmount = $order[&#039;change_amount&#039;];
    }
}

$content = ob_get_clean();

function sendToPrinter($result) {
    $printerName = &quot;EPSON_TM_T88V_Receipt&quot;;
    $handle = @fopen(&quot;USB&quot;, &quot;w&quot;);
    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;;
}

sendToPrinter($content);

$currentDate = date(&quot;Y-m-d&quot;);
$billQuery = &quot;SELECT COUNT(DISTINCT order_id) AS total_orders FROM log_user_sale WHERE DATE(date_time) = &#039;$currentDate&#039;&quot;;
$billResult = mysqli_query($connection, $billQuery);
$billRow = mysqli_fetch_assoc($billResult);
$newBillNo = sprintf(&#039;%04d&#039;, $billRow[&#039;total_orders&#039;] + 1);
?&gt;

&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;ur&quot; dir=&quot;rtl&quot;&gt;
&lt;head&gt;
  &lt;meta charset=&quot;UTF-8&quot;&gt;
  &lt;title&gt;رسید&lt;/title&gt;
  &lt;link href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.rtl.min.css&quot; rel=&quot;stylesheet&quot;&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;
        direction: rtl;
        text-align: right;
    }
    .form-control, label, select, th, td {
        text-align: right !important;
        direction: rtl !important;
    }
    .table th, .table td {
        text-align: right !important;
    }
    .input-group-text { text-align: right; }
    .btn { direction: rtl; }
    .dropdown-menu {
        right: 0;
        left: auto;
        text-align: right;
    }
    p { font-weight:700; }
    .fixed-col {
        width: 80px;
        min-width: 80px;
        max-width: 80px;
        text-align: center !important;
        white-space: nowrap;
    }
@media print {
    .no-print {
        display: none !important;
    }

    table {
        page-break-inside: auto;
        border-collapse: collapse !important;
        width: 100% !important;
        table-layout: fixed;
    }

    thead {
        display: table-header-group !important;
    }

    tfoot {
        display: table-footer-group !important;
    }

    tr {
        page-break-inside: avoid !important;
        page-break-after: auto;
    }

    td, th {
        background: none !important;
        color: #000 !important;
        font-size: 12px;
        padding: 2px;
        word-break: break-word;
    }

    body {
        margin: 0;
        padding: 0;
        width: 100% !important;
    }

    .container,
    .invoice-box {
        width: 100% !important;
        max-width: 100% !important;
        margin: 0 auto !important;
        padding: 10px !important;
        box-sizing: border-box;
        border: none !important;
    }

    .ltr {
        direction: ltr !important;
        text-align: left !important;
    }

    @page {
        size: A4 portrait;
        margin: 10mm;
    }

    h2, h5 {
        text-align: center !important;
        margin: 0;
    }

    .header-info p {
        margin: 0;
        padding: 2px 0;
        text-align: left;
        font-weight: 700;
    }
}
  &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;div class=&quot;invoice-box&quot; style=&quot;border:1px solid #E1E1E2; margin-top:50px; max-width: 800px; margin:0 auto;&quot;&gt;
&lt;!--&lt;div class=&quot;text-center&quot;&gt;
  &lt;h2&gt;  &amp;nbsp; &amp;nbsp; &amp;nbsp;Almas Copy House&lt;/h2&gt;
  &lt;h5&gt;Urdu Bazar Lahore&lt;/h5&gt;
&lt;/div&gt;--&gt;

&lt;div class=&quot;header-info&quot; style=&quot;margin-bottom: 10px;&quot;&gt;
  &lt;p&gt;Bill#: &lt;?php echo $newBillNo; ?&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Name: &lt;?php echo strtoupper($customerName); ?&gt;&lt;/p&gt;


  &lt;p&gt;&lt;/p&gt;
&lt;/div&gt;

  &lt;?php foreach ($orderDetails as $order): ?&gt;
    &lt;?php
    $totalQ = 0;
    for ($i = 1; $i &lt;= 10; $i++) {
        $totalQ += floatval($order[&#039;pr&#039; . $i]);
    }
    if ($totalQ === 0) continue;

    $thLabels = [
        1 =&gt; &#039;کھلا رول&#039;,
        2 =&gt; &#039;چار لائن&#039;,
        3 =&gt; &#039;خانہ&#039;,
        4 =&gt; &#039;تنگ&#039;,
        5 =&gt; &#039;بړا خانہ&#039;,
        6 =&gt; &#039;بړا چار لائن&#039;,
        7 =&gt; &#039;سفید&#039;,
        8 =&gt; &#039;کھلا سائنس&#039;,
        9 =&gt; &#039;تنگ سائنس&#039;,
        10 =&gt; &#039;مکس&#039;
    ];
    ?&gt;
    &lt;table class=&quot;table table-striped text-center table-sm &quot; &gt;
      &lt;thead&gt;
        &lt;tr&gt;
          &lt;th&gt;نام&lt;/th&gt;
          &lt;?php for ($i = 1; $i &lt;= 10; $i++): ?&gt;
            &lt;?php if (floatval($order[&#039;pr&#039; . $i])): ?&gt;
              &lt;th&gt;&lt;?php echo $thLabels[$i]; ?&gt;&lt;/th&gt;
            &lt;?php endif; ?&gt;
          &lt;?php endfor; ?&gt;
          &lt;th class=&quot;fixed-col&quot;&gt;کل بنڈل&lt;/th&gt;
          &lt;th class=&quot;fixed-col&quot;&gt;ریٹ&lt;/th&gt;
          &lt;th class=&quot;fixed-col&quot;&gt;ٹوٹل&lt;/th&gt;
        &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;
        &lt;tr style=&#039;border-bottom:2px solid #000;&#039;&gt;
          &lt;td&gt;&lt;?php echo htmlspecialchars($order[&#039;product_name&#039;]); ?&gt;&lt;/td&gt;
          &lt;?php for ($i = 1; $i &lt;= 10; $i++): ?&gt;
            &lt;?php if (floatval($order[&#039;pr&#039; . $i])): ?&gt;
              &lt;td&gt;&lt;?php echo floatval($order[&#039;pr&#039; . $i]); ?&gt;&lt;/td&gt;
            &lt;?php endif; ?&gt;
          &lt;?php endfor; ?&gt;
          &lt;td class=&quot;fixed-col&quot;&gt;&lt;?php echo htmlspecialchars($totalQ); ?&gt;&lt;/td&gt;
          &lt;td class=&quot;fixed-col&quot;&gt;&lt;?php echo htmlspecialchars($order[&#039;product_price&#039;]); ?&gt;&lt;/td&gt;
          &lt;td class=&quot;fixed-col&quot;&gt;&lt;?php echo htmlspecialchars(floatval($order[&#039;product_price&#039;]) * $totalQ); ?&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/tbody&gt;
    &lt;/table&gt;
  &lt;?php endforeach; ?&gt;

  &lt;div class=&quot;mt-4&quot;&gt;
    &lt;p&gt;بل رقم :&lt;?php echo &#039;&amp;nbsp;&#039; . $totalAmount; ?&gt; &lt;/p&gt;
    &lt;p&gt; سابقہ  رقم:&lt;?php echo &#039;&amp;nbsp;&#039; . $preAmount; ?&gt; &lt;/p&gt;
    &lt;p&gt;بقایا رقم
      &lt;?php echo &#039;&amp;nbsp;&#039; . $grandAmount; ?&gt; &lt;/p&gt;

  &lt;/div&gt;

  &lt;div&gt;
    &lt;?php
      $date = new DateTime();
      echo $date-&gt;format(&#039;l, F j, Y g:i:s A&#039;);
    ?&gt;
  &lt;/div&gt;

  &lt;?php
  if ($_SERVER[&#039;REQUEST_METHOD&#039;] === &#039;POST&#039; &amp;&amp; isset($_POST[&#039;exit&#039;])) {
      if (!empty($customerName) &amp;&amp; is_numeric($changeAmount)) {
          $checkQuery = &quot;SELECT 1 FROM creditor_closing WHERE creditor_name = &#039;$customerName&#039; LIMIT 1&quot;;
          $checkResult = mysqli_query($connection, $checkQuery);

          if (mysqli_num_rows($checkResult) &gt; 0) {
              $updateQuery = &quot;UPDATE creditor_closing SET remain_balance = $changeAmount WHERE creditor_name = &#039;$customerName&#039;&quot;;
              $updateResult = mysqli_query($connection, $updateQuery);

              if ($updateResult) {
                  echo &quot;&lt;script&gt;alert(&#039;Back to Add Sale&#039;); location.href=&#039;mainpo.php&#039;;&lt;/script&gt;&quot;;
                  exit;
              } else {
                  echo &quot;&lt;p style=&#039;color:red;&#039;&gt;Update failed: &quot; . mysqli_error($connection) . &quot;&lt;/p&gt;&quot;;
              }
          } else {
              $insertQuery = &quot;INSERT INTO creditor_closing (
                  creditor_name, opening_cash, credit_sales, credit_recieved,
                  remain_balance, date_time, login_user, user_role,
                  outlet_name, outlet_address
              ) VALUES (
                  &#039;$customerName&#039;, 0, 0, 0, $changeAmount, NOW(), &#039;$loginUser&#039;, &#039;$userRole&#039;, &#039;$outletName&#039;, &#039;$outletAddress&#039;
              )&quot;;

              $insertResult = mysqli_query($connection, $insertQuery);

              if ($insertResult) {
                  header(&quot;Location: mainpo.php&quot;);
                  exit;
              } else {
                  echo &quot;&lt;p style=&#039;color:red;&#039;&gt;Insert failed: &quot; . mysqli_error($connection) . &quot;&lt;/p&gt;&quot;;
              }
          }
      }
  }
  ?&gt;

  &lt;div class=&quot;text-center no-print mt-4&quot;&gt;
    &lt;button onclick=&quot;window.print()&quot; class=&quot;btn btn-primary no-print&quot;&gt;Print&lt;/button&gt;
    &lt;form method=&quot;post&quot; style=&quot;display:inline;&quot;&gt;
      &lt;button type=&quot;submit&quot; name=&quot;exit&quot; class=&quot;btn btn-danger no-print&quot;&gt;Exit&lt;/button&gt;
    &lt;/form&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>        </div>
    </div>