    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php 
include(&quot;../db/cn.php&quot;);

if (!isset($_GET[&quot;id&quot;])) {
  die(&quot;ID parameter is missing.&quot;);
}

$id = $_GET[&quot;id&quot;];
$rec_patient = mysqli_query($connection, &quot;SELECT * FROM patient WHERE id = &#039;$id&#039;&quot;);
$row_patient = mysqli_fetch_array($rec_patient);

if ($connection-&gt;connect_error) {
  die(&quot;Connection failed: &quot; . $connection-&gt;connect_error);
}

if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot;) {
  $patientId = $_POST[&quot;patientId&quot;];
  $doctor = $_POST[&quot;doctor&quot;];
  $subtotal = $_POST[&quot;subtotal&quot;];
  $discount = $_POST[&quot;discount&quot;];
  $deposit = $_POST[&quot;deposit&quot;];
  $due = $_POST[&quot;due&quot;];
  $paymentMethod = $_POST[&quot;paymentMethod&quot;];
  $p_name = $_POST[&quot;p_name&quot;];
  $date_time = date(&quot;Y-m-d&quot;);
  
  $invoiceId = uniqid();
  
  $sql_invoice = &quot;INSERT INTO lab_invoice (
    invoice_id,
    p_id,
    p_name,
    ref_doctor,
    sub_total,
    discount_amount,
    deposit_amount,
    due,
    deposit_type,
    date_time
  ) VALUES (
    &#039;$invoiceId&#039;,
    &#039;$patientId&#039;,
    &#039;$p_name&#039;,
    &#039;$doctor&#039;,
    &#039;$subtotal&#039;,
    &#039;$discount&#039;,
    &#039;$deposit&#039;,
    &#039;$due&#039;,
    &#039;$paymentMethod&#039;,
    &#039;$date_time&#039;
  )&quot;;
  
  if ($connection-&gt;query($sql_invoice) === TRUE) {
    if (isset($_POST[&#039;labTest&#039;]) &amp;&amp; is_array($_POST[&#039;labTest&#039;])) {
      $labTests = $_POST[&#039;labTest&#039;];
      foreach ($labTests as $labTest) {
        list($itemName, $itemPrice) = explode(&#039;-&#039;, $labTest);
        
        $sql_item = &quot;INSERT INTO lab_invoice_items (invoice_id, test_name, test_price, date_time)
                     VALUES (&#039;$invoiceId&#039;, &#039;$itemName&#039;, &#039;$itemPrice&#039;, &#039;$date_time&#039;)&quot;;
        
        if ($connection-&gt;query($sql_item) !== TRUE) {
          echo &quot;Error: &quot; . $sql_item . &quot;&lt;br&gt;&quot; . $connection-&gt;error;
        }
      }
      
      echo &quot;&quot;;
    } else {
      echo &quot;&quot;;
    }
  } else {
    echo &quot;Error: &quot; . $sql_invoice . &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;link rel=&quot;apple-touch-icon&quot; sizes=&quot;76x76&quot; href=&quot;../assets/img/apple-icon.png&quot;&gt;
    &lt;link rel=&quot;icon&quot; type=&quot;image/png&quot; href=&quot;../img/print_logo.png&quot;&gt;
    &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=edge,chrome=1&quot; /&gt;
    &lt;title&gt;Laboratory L.I.M.S&lt;/title&gt;
    &lt;meta content=&#039;width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no&#039; name=&#039;viewport&#039; /&gt;
    &lt;link href=&quot;https://fonts.googleapis.com/css?family=Quicksand:500,700,200&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css&quot;&gt;
    &lt;link href=&quot;../assets/css/light-bootstrap-dashboard.css&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;style&gt;
        .modal-lg-custom {
            max-width: 90% !important;
        }
		.btn-outline-dark{
		   background:#2C2C2C;
		   color:#fff;	
			}
			.btn-outline-dark:hover{
			    background:#fff;
				color:#2C2C2C;
				border:1px solid #2C2C2C;	
				}
		.bg-dark{
		   background:#7A2355;
		   color:#fff;	
			}
    &lt;/style&gt;
&lt;/head&gt;

&lt;body&gt;
    &lt;div class=&quot;wrapper&quot;&gt;
        &lt;div class=&quot;sidebar&quot; data-image=&quot;../assets/img/sidebar-7.jpg&quot;&gt;
            &lt;?php include(&quot;common/sd.php&quot;); ?&gt;
        &lt;/div&gt;
        &lt;div class=&quot;main-panel&quot;&gt;
            &lt;?php include(&quot;common/hd.php&quot;); ?&gt;
            &lt;div class=&quot;content&quot;&gt;
                
                &lt;div class=&quot;container&quot;&gt;
    &lt;div class=&quot;row&quot;&gt;
    &lt;div class=&quot;col-sm-4&quot;&gt;
    &lt;h2&gt;Invoice &lt;/h2&gt;
    &lt;/div&gt;
    &lt;div class=&quot;col-sm-5&quot;&gt;&lt;/div&gt;
    &lt;div class=&quot;col-sm-3&quot;&gt;
   &lt;a href=&quot;payment_h.php?id=&lt;?php echo $row_patient[&quot;id&quot;];?&gt;&quot;&gt; &lt;button type=&quot;button&quot; class=&quot;btn btn-dark btn-sm&quot;&gt;Back&lt;/button&gt;&lt;/a&gt;
    &lt;/div&gt;
    &lt;/div&gt;
    &lt;br&gt;
    &lt;form action=&quot;invoice_p2.php?id=&lt;?php echo $row_patient[&quot;id&quot;]; ?&gt;&quot; method=&quot;post&quot;&gt;
      &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
          &lt;label for=&quot;patientId&quot; class=&quot;form-label&quot;&gt;Patient ID&lt;/label&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;p_name&quot; value=&quot;&lt;?php echo $row_patient[&quot;p_name&quot;]; ?&gt;&quot; /&gt;
          &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;patientId&quot; name=&quot;patientId&quot; value=&quot;&lt;?php echo $row_patient[&quot;id&quot;]; ?&gt;&quot; readonly&gt;
          &lt;label for=&quot;patientId&quot; class=&quot;form-label&quot;&gt;Patient Name&lt;/label&gt;
           &lt;input type=&quot;text&quot; class=&quot;form-control &quot; style=&quot;text-transform:capitalize;&quot; id=&quot;&quot; name=&quot;&quot; value=&quot;&lt;?php echo $row_patient[&quot;p_name&quot;]; ?&gt;&quot; readonly&gt;
         
          &lt;label for=&quot;doctor&quot; class=&quot;form-label&quot;&gt;Doctor&lt;/label&gt;
          &lt;select class=&quot;form-select&quot; id=&quot;doctor&quot; name=&quot;doctor&quot;&gt;
            &lt;option value=&quot;&lt;?php echo $row_patient[&quot;doctor&quot;];?&gt;&quot;&gt;&lt;?php echo $row_patient[&quot;doctor&quot;];?&gt;&lt;/option&gt;
            &lt;!-- Add more options as needed --&gt;
          &lt;/select&gt;
        
          &lt;?php $labTest = mysqli_query($connection, &quot;select * from lab_test&quot;); ?&gt;
          &lt;label for=&quot;labTest&quot; class=&quot;form-label&quot;&gt;Lab Test&lt;/label&gt;
          &lt;select class=&quot;form-select&quot; id=&quot;labTest&quot; name=&quot;labTest&quot;&gt;
            &lt;option value=&quot;&quot;&gt;Select Lab Test&lt;/option&gt;
            &lt;?php while ($rowLab = mysqli_fetch_array($labTest)) { ?&gt;
              &lt;option value=&quot;&lt;?php echo $rowLab[&quot;test_name&quot;] . &quot; - &quot; . $rowLab[&quot;test_price&quot;]; ?&gt;&quot;&gt;
                &lt;?php echo $rowLab[&quot;test_name&quot;] . &quot; - &quot; . $rowLab[&quot;test_price&quot;]; ?&gt;
              &lt;/option&gt;
            &lt;?php } ?&gt;
          &lt;/select&gt;&lt;br&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn btn-primary&quot; id=&quot;addItemBtn&quot;&gt;Add Item&lt;/button&gt;
        &lt;/div&gt;
        
        &lt;div class=&quot;col-sm-6&quot;&gt;
          &lt;!-- Table to display selected items --&gt;
          &lt;table class=&quot;table text-dark&quot; id=&quot;itemTable&quot; &gt;
            &lt;thead &gt;
              &lt;tr &gt;
                &lt;th &gt;Item&lt;/th&gt;
                &lt;th &gt;Price&lt;/th&gt;
                &lt;th &gt;Action&lt;/th&gt;
              &lt;/tr&gt;
            &lt;/thead&gt;
            &lt;tbody&gt;
              &lt;!-- Selected items will be added dynamically here --&gt;
            &lt;/tbody&gt;
          &lt;/table&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;subtotal&quot; class=&quot;form-label&quot;&gt;Subtotal&lt;/label&gt;
            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;subtotal&quot; name=&quot;subtotal&quot; readonly&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;discount&quot; class=&quot;form-label&quot;&gt;Discount&lt;/label&gt;
            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;discount&quot; name=&quot;discount&quot;&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;deposit&quot; class=&quot;form-label&quot;&gt;Deposit&lt;/label&gt;
            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;deposit&quot; name=&quot;deposit&quot;&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;due&quot; class=&quot;form-label&quot;&gt;Due&lt;/label&gt;
            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;due&quot; name=&quot;due&quot; readonly&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;grandTotal&quot; class=&quot;form-label&quot;&gt;Grand Total&lt;/label&gt;
            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;grandTotal&quot; name=&quot;grandTotal&quot; readonly&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-group&quot;&gt;
            &lt;label for=&quot;paymentMethod&quot; class=&quot;form-label&quot;&gt;Payment Method&lt;/label&gt;
            &lt;select class=&quot;form-select&quot; id=&quot;paymentMethod&quot; name=&quot;paymentMethod&quot;&gt;
              &lt;option value=&quot;cash&quot;&gt;Cash&lt;/option&gt;
              &lt;option value=&quot;card&quot;&gt;Card&lt;/option&gt;
              &lt;option value=&quot;bank&quot;&gt;Bank Transfer&lt;/option&gt;
            &lt;/select&gt;
          &lt;/div&gt;
          &lt;button type=&quot;submit&quot; class=&quot;btn btn-success btn-sm&quot;&gt;Generate Invoice&lt;/button&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/form&gt;
  &lt;/div&gt;
              

          
          
                
            &lt;/div&gt;
            
            &lt;footer class=&quot;footer&quot;&gt;
                &lt;div class=&quot;container-fluid&quot;&gt;
                &lt;/div&gt;
            &lt;/footer&gt;
        &lt;/div&gt;
    &lt;/div&gt;
 &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
  &lt;script&gt;
    document.addEventListener(&quot;DOMContentLoaded&quot;, function() {
      let addItemBtn = document.getElementById(&quot;addItemBtn&quot;);
      let itemTableBody = document.querySelector(&quot;#itemTable tbody&quot;);

      addItemBtn.addEventListener(&quot;click&quot;, function() {
        let labTest = document.getElementById(&quot;labTest&quot;);
        let selectedOption = labTest.options[labTest.selectedIndex];

        if (selectedOption.value !== &quot;&quot;) {
          let itemText = selectedOption.text;
          let itemParts = itemText.split(&quot; - &quot;);
          let itemName = itemParts[0];
          let itemPrice = parseFloat(itemParts[1]);

          if (!isNaN(itemPrice)) {
            let newRow = document.createElement(&quot;tr&quot;);
            newRow.innerHTML = `
              &lt;td style=&quot;color:#511738;&quot;&gt;${itemName}&lt;/td&gt;
              &lt;td style=&quot;color:#511738;&quot;&gt;${itemPrice.toFixed(2)}&lt;/td&gt;
              &lt;td style=&quot;color:#511738;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-danger btn-sm&quot;&gt;x&lt;/button&gt;&lt;/td&gt;
              &lt;input type=&quot;hidden&quot; name=&quot;labTest[]&quot; value=&quot;${itemName}-${itemPrice.toFixed(2)}&quot;&gt;
            `;
            itemTableBody.appendChild(newRow);

            let subtotal = document.getElementById(&quot;subtotal&quot;);
            let currentSubtotal = parseFloat(subtotal.value) || 0;
            subtotal.value = (currentSubtotal + itemPrice).toFixed(2);

            calculateDueAndGrandTotal();
          } else {
            console.error(&quot;Invalid item price:&quot;, itemPrice);
          }
        }
      });

      itemTableBody.addEventListener(&quot;click&quot;, function(event) {
        if (event.target.classList.contains(&quot;btn-danger&quot;)) {
          let row = event.target.closest(&quot;tr&quot;);
          let price = parseFloat(row.children[1].textContent);

          if (!isNaN(price)) {
            row.remove();

            let subtotal = document.getElementById(&quot;subtotal&quot;);
            let currentSubtotal = parseFloat(subtotal.value) || 0;
            subtotal.value = (currentSubtotal - price).toFixed(2);

            calculateDueAndGrandTotal();
          }
        }
      });

      document.getElementById(&quot;discount&quot;).addEventListener(&quot;input&quot;, calculateDueAndGrandTotal);
      document.getElementById(&quot;deposit&quot;).addEventListener(&quot;input&quot;, calculateDueAndGrandTotal);

      function calculateDueAndGrandTotal() {
        let subtotal = parseFloat(document.getElementById(&quot;subtotal&quot;).value) || 0;
        let discount = parseFloat(document.getElementById(&quot;discount&quot;).value) || 0;
        let deposit = parseFloat(document.getElementById(&quot;deposit&quot;).value) || 0;
        let due = document.getElementById(&quot;due&quot;);
        let grandTotal = document.getElementById(&quot;grandTotal&quot;);

        let totalDue = subtotal - discount - deposit;
        due.value = totalDue.toFixed(2);
        grandTotal.value = subtotal.toFixed(2);
      }
    });
  &lt;/script&gt;
    &lt;script src=&quot;https://code.jquery.com/jquery-3.5.1.slim.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/core/jquery.3.2.1.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/core/popper.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/core/bootstrap.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/plugins/bootstrap-switch.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/plugins/chartist.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/plugins/bootstrap-notify.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/light-bootstrap-dashboard.js?v=2.0.0&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/demo.js&quot;&gt;&lt;/script&gt;
&lt;/body&gt;

&lt;/html&gt;
</code></pre>        </div>
    </div>