<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
?>
 <?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dashboarddocument.php");
include("header.php");
?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">

<h4 align='center'>Recommendation</h4>
<br>

  <?php
  	$sql ="SELECT * FROM Nutrition_Recommendation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo"
		    <h3 align='right'><a href='edit_showpage_Nutrition_Recommendation.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'>Edit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a></h3>";
		}
		?>
<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>
";
}
?>
<div class='container'>
    <div class='row'>
        <div class='col-sm-12'>
           <center><a href='testopdslip4.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>' style='text-align:center;margin:12px;' class='btn btn-info'>Next Page</a></center> 
        </div>
    </div>
</div>
</body>
</html>