<?php
session_start();
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once("../patientmanager.php");
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
if(isset($_POST[note]))
{
		PatientManager::narayanharilal("$_GET[prescriptionid]","$_GET[patientid]","$_POST[Assessment_note]","$_POST[Nursing_diagnosis_note]","$_POST[Plan_of_Action]","$_POST[Implementation]","$_POST[Evaluation]","$_POST[Ward]","$_POST[rate]","$_POST[entered_by]");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
{
$sql56 ="SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql56 = mysqli_query($con,$sql56);
		while($rs56 = mysqli_fetch_array($qsql56))
		{
	$sql212 ="SELECT * FROM tarifrate WHERE tarifid='1' AND hospitalid='$re[entered_by]' AND wardid='$rs56[Ward]'";
$qsql212 = mysqli_query($con,$sql212);
if($rs112 = mysqli_fetch_array($qsql212))
{
    $subbill=$rs112[rate];
  	$msg=mysqli_query($con,"insert into patient_invace(patientid,	prescriptionid,discription,pagetype,link,pricetotal,discount,grand_total,paymentmode,status,entered_by,created_at,updated_at) values('$_GET[patientid]','$_GET[prescriptionid]','Nursing_Assessment','$total','drinvace.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$_POST[id]','$subbill','','','','','$usertype','','')");
  }
}
}
	 }

?>
           <table id="example2" class="table table-bordered table-hover">
                 
         
						<tr>
						    <th>Date & Time</th>
							<th>Nursing Plan Of care</th>
							</tr>
				
      

<?php
include("dbconnection.php");
$sql ="SELECT * FROM nurse_note WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "<tr><td>$rs[created_at]</td>
<td><b>Assessment : </b>$rs[Assessment_note]<br>
<b>Nursing diagnosis : </b>$rs[Nursing_diagnosis_note]<br>
<b>Plan of Action : </b>$rs[Plan_of_Action]<br>
<b>Implementation : </b>$rs[Implementation]<br>
<b>Evaluation : </b>$rs[Evaluation]</tr>
";
    
    
}
?>
</table>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
   <form method="post" name="note">
	<table width="100%" id="example2" class="table table-bordered table-hover">  
      <tbody>
	     
		  <h3 align="center">Nursing Plan Of care</h3>
		  <tr>

		      <th></th>
		      <th>Note</th>
		  </tr>
        	<tr>
        
          <td width="20%">Assessment:</td>
          <td width="60%"><input type="text"  name="Assessment_note" required/></td>
        </tr>
        		<tr>
        	  
          <td width="20%">Nursing diagnosis:</td>
          <td width="60%"><input type="text"  name="Nursing_diagnosis_note" id="bp" required/></td>
        </tr>
        		<tr>
           
          <td width="20%">Plan of Action:</td>
          <td width="60%"><input type="text"  name="Plan_of_Action" required/></td>
        </tr>
        
        		<tr>
           
          <td width="20%">Implementation:</td>
          <td width="60%"><input type="text"  name="Implementation" required/></td>
        </tr>
        		<tr>
            
          <td width="20%">Evaluation:</td>
          <td width="60%"><input type="text"  name="Evaluation" required/></td>
        </tr>
        
        <tr><td></td><td>
<?php
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once("../patientmanager.php");
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		$rh1 = mysqli_fetch_array($qsql1);
		
		   
		   
$sql56 ="SELECT * FROM request_for_admission WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND entered_by='$rh1[entered_by]'";
		$qsql56 = mysqli_query($con,$sql56);
		$rs56 = mysqli_fetch_array($qsql56);
		
	
   echo "<input type='hidden' name='Ward' value='$rs56[Ward]'/>";
	$sql212 ="SELECT * FROM tarifrate WHERE tarifid='1' AND hospitalid='$rh1[entered_by]' AND wardid='$rs56[Ward]'";
$qsql212 = mysqli_query($con,$sql212);
$rs112 = mysqli_fetch_array($qsql212);

    $subbill=$rs112[rate];
    echo "<input type='hidden' name='rate' value='$rs112[rate]'/>";

	
		  ?>

		  
		  </td>
        </tr>
       
           </tbody>
    </table>
    <input type="submit" name="note" value="submit">
    </form>
     
<script>

$("#Ward").change(function () {
   var selectedItem = $(this).val();
   var abc=$(this).find(':selected').data("id");
   //console.log(abc)
   $('[name="ward_vice_amt"]').val(abc);
  });
</script>