<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
include("dbconnection.php");
if(isset($_POST['update'])) 
{ 
    	$updated_at=date("F d, Y / h:i:s A");
$sql ="UPDATE bloodtransfusion SET blood='$_POST[blood]',Diagnosis='$_POST[Diagnosis]',Indications_Transfusion='$_POST[Indications_Transfusion]',blood_group='$_POST[blood_group]',advers_reaction='$_POST[advers_reaction]',Blood_Bag_Number='$_POST[Blood_Bag_Number]',Products_Blood_Group='$_POST[Products_Blood_Group]',product_name='$_POST[product_name]',blood_bank_name='$_POST[blood_bank_name]',date_of_expiry='$_POST[date_of_expiry]',Blood_Checked_Doctor='$_POST[Blood_Checked_Doctor]',doctor_id_no='$_POST[doctor_id_no]',Nurse_name='$_POST[Nurse_name]',Nurse_Id_No='$_POST[Nurse_Id_No]',blood_start='$_POST[blood_start]',blood_stop='$_POST[blood_stop]', created_at='$updated_at',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
$sql1 ="UPDATE patient_invace SET created_at='$updated_at',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND pagetype='$_GET[id]'";
if($qsql = mysqli_query($con,$sql))
		{
		    if($qsql = mysqli_query($con,$sql1))
		    {
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
  }else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h3 align='center'>Blood Transfusion Start</h3>
        <form name='update' method='POST'>
   	<table id="example2" class="table table-bordered table-hover"> 
   
   	<?php
$sql ="SELECT * FROM bloodtransfusion WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_GET[id]'";
$qsql = mysqli_query($con,$sql);
while($rs1 = mysqli_fetch_array($qsql))
{
     echo " <tbody>

            <tr> <td>Start at :</td>  <td>&nbsp;<input type='text' name='blood_start' value='$rs1[blood_start]'></td> </tr>
          
                        <tr> <td>Blood Bag Number :</td>  <td>&nbsp;<input type='text' name='Blood_Bag_Number' value='$rs1[Blood_Bag_Number]'></td> </tr>
              		<tr><td>Product's Blood Group : </td> <td><input type='text' name='Products_Blood_Group' value='$rs1[Products_Blood_Group]'></td></tr>
              		<tr><td>Product's Name(PL. encircle) : </td> <td><input type='text' name='product_name' value='$rs1[product_name]'></td></tr>
              		<tr><td>Name of the Blood Bank: : </td><td><input type='text' name='blood_bank_name' value='$rs1[blood_bank_name]'></td></tr>
              		<tr><td>Date of expiry: </td><td><input type='date' name='date_of_expiry' value='$rs1[date_of_expiry]'></td>          </tr> 
              			<tr><td>Blood Checked by the Doctor: </td><td><input type='text' name='Blood_Checked_Doctor' value='$rs1[Blood_Checked_Doctor]'></td>          </tr>  
              			<tr><td width='50%'>SPo2</td><td  width='50%'><input type='text' name='Spo2' value=' $rs1[Spo2]'></td></tr>
<tr><td  width='50%'>RBS</td><td  width='50%'><input type='text' name='RBS' value='$rs1[RBS]'></td></tr>
<tr><td  width='50%'>Temperature</td><td  width='50%'><input type='text' name='Temp' value='$rs1[Temp]'></td></tr>
<tr><td  width='50%'>Pulse</td><td  width='50%'><input type='text' name='Pulse' value='$rs1[Pulse]'></td></tr>
<tr><td  width='50%'>Blood Pressure:</td><td  width='50%'><input type='text' name='BP2' value='$rs1[BP2]'><input type='text' name='BP' value='$rs1[BP]'></td></tr>
          
          ";
}

?> 
   	</table>
   	
   	 <h3 align='center'>Blood Transfusion Stop</h3>
   	<table id="example2" class="table table-bordered table-hover"> 
   
   	<?php
$sql1 ="SELECT * FROM bloodtransfusion WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_GET[id]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs21 = mysqli_fetch_array($qsql1))
{
   
     echo " <tbody>

      
            <tr> <td>Stop at :</td>  <td>&nbsp;<input type='datetime-local' name='blood_stop' value='$rs21[blood_stop]'></td> </tr>
                       
              			<tr><td width='50%'>SPo2</td><td  width='50%'><input type='text' name='Spo2' value='$rs21[Spo2]'></td></tr>
<tr><td  width='50%'>RBS</td><td  width='50%'><input type='text' name='RBS' value='$rs21[RBS]'></td></tr>
<tr><td  width='50%'>Temperature</td><td  width='50%'><input type='text' name='Temp' value='$rs21[Temp]'></td></tr>
<tr><td  width='50%'>Pulse</td><td  width='50%'><input type='text' name='Pulse' value='$rs21[Pulse]'></td></tr>
<tr><td  width='50%'>Blood Pressure:</td><td  width='50%'><input type='text' name='BP2' value='$rs21[BP2]'><input type='text' name='BP' value='$rs21[BP]'></td></tr>
          
          ";

}

?> 
   	</table>
   	<input type='submit' name='update' value='Submit'>
   	</form>