<?php
     session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');

    include("../dbconnection.php");
		$sql2 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    
		   	include 'dashboarddocument.php';
}
?>
	  

  <?php

include 'fileheader.php';
?>



<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
?>
 
 
<h4 align='center'>Recommendation</h4>
<br>

<h5>Advised to</h5>
<table id="example2" class="table table-bordered table-hover">
    
   
        <?php
  	$sql ="SELECT * FROM Nutrition_Recommendation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{ 
		    if($rs[weight] == 'Gain weight'){
		        echo"
		        <tr>
        <td>Gain weight</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>Loose weight</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr> ";
        }
        
         if($rs[Present_Nutritional] == 'Maintain Present Nutritional Status'){
		        echo"
		        <tr>
        <td>Maintain Present Nutritional Status</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>Maintain Present Nutritional Status</td><td><i class='fa fa-times' aria-hidden='true'></i></td> </tr> ";
        }
          if($rs[Nutritional_Status] == 'To improve Nutritional Status'){
		        echo"
		        <tr>
        <td>To improve Nutritional Status</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>To improve Nutritional Status</td><td><i class='fa fa-times' aria-hidden='true'></i></td> </tr> ";
        }
         if($rs[Maintain_BP] == 'Maintain B.P. Within normal limits'){
		        echo"
		        <tr>
        <td>Maintain B.P. Within normal limits</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>Maintain B.P. Within normal limits</td><td><i class='fa fa-times' aria-hidden='true'></i></td> </tr> ";
        }
        if($rs[Blood_Sugar] == 'Maintain Blood Sugar Within normal limits'){
		        echo"
		        <tr>
        <td>Maintain Blood Sugar Within normal limits</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>Maintain Blood Sugar Within normal limits</td><td><i class='fa fa-times' aria-hidden='true'></i></td> </tr> ";
        }
         if($rs[Reduce_Cholesterol] == 'Reduce Cholesterol/triglycerides within normal limits'){
		        echo"
		        <tr>
        <td>Reduce Cholesterol/triglycerides within normal limits</td><td><i class='fa fa-check' aria-hidden='true'></i></td> </tr>";
        }
        else
        {
            echo"
              <tr>
        <td>Reduce Cholesterol/triglycerides within normal limits</td><td><i class='fa fa-times' aria-hidden='true'></i></td> </tr> ";
        }
        echo"
    </table>";
    echo"

<h5>Diet Recommended:</h5>
<table id='example2' class='table table-bordered table-hover'>
    
    <tr><td width='50%'>Energy :</td><td width='50%'>$rs[Energy]</td></tr>
<tr><td width='50%'>Protein :</td><td width='50%'>$rs[Protein]</td></tr>
<tr><td width='50%'>Fat :</td><td width='50%'>$rs[Fat]</td></tr>
<tr><td width='50%'>Note :</td><td width='50%'>$rs[note]</td></tr>
</table>
";
}
?>

</body>
</html>