<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
include 'header.php';
include 'dashboarddocument.php';
if(isset($_POST[Nutrition_Recommendation]))
{
    	$updated_at=date("F d, Y / h:i:s A");
 $sql ="UPDATE Nutrition_Recommendation SET weight='$_POST[weight]',Present_Nutritional='$_POST[Present_Nutritional]',Nutritional_Status='$_POST[Nutritional_Status]',Maintain_BP='$_POST[Maintain_BP]',Blood_Sugar='$_POST[Blood_Sugar]',Reduce_Cholesterol='$_POST[Reduce_Cholesterol]',Energy='$_POST[Energy]',Protein='$_POST[Protein]',Fat='$_POST[Fat]',note='$_POST[note]',created_at='$_POST[created_at]',updated_at='$updated_at' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$sql1 ="UPDATE save_activity SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND userno='$_GET[patientid]' AND discription='Opd Slip<br>Nutrition Recommendation<br>Doc.no-'";
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">
        <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div>
<form name="Nutrition_Recommendation" method="post" id="myForm" >
        
           
<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))
		{ 
		    echo"
<tr><td width='50%'> Date & Time</td><td width='50%'> <input id='party' value='$rs[created_at]' type='text' name='created_at'></td></tr>";
		    if($rs[weight] == 'Loose weight'){
		        echo"
    <tr><td><input type='checkbox' name='weight' value='Loose weight' checked></td><td><span>Loose weight</span></td></tr>";
    } 
    else
    {
        echo"
        <tr><td><input type='checkbox' name='weight' value='Loose weight'></td><td><span>Loose weight</span></td></tr>";
    }
    if($rs[weight] == 'Gain weight'){
		        echo"
<tr><td><input type='checkbox' name='weight' value='Gain weight' checked></td> <td><span>Gain weight</span></td></tr>";
    } 
    else
    {
        echo"
        <tr><td><input type='checkbox' name='weight' value='Loose weight'></td><td><span>Loose weight</span></td></tr>";
    }
     if($rs[Present_Nutritional] == 'Maintain Present Nutritional Status'){
		        echo"
<tr>
    <td ><input type='checkbox' name='Present_Nutritional' value='Maintain Present Nutritional Status' checked></td><td><span>Maintain Present Nutritional Status</span></td><td ></td></tr>";
    } 
    else
    {
        echo"
      <tr>
    <td ><input type='checkbox' name='Present_Nutritional' value='Maintain Present Nutritional Status'></td><td><span>Maintain Present Nutritional Status</span></td><td ></td></tr>";
    }
    
    if($rs[Nutritional_Status] == 'To improve Nutritional Status'){
		        echo"
  <tr>
      <td ><input type='checkbox' name='Nutritional_Status' value='To improve Nutritional Status'></td><td><span>To improve Nutritional Status</span></td> </tr>";
    } 
    else
    {
        echo"
      <tr>
      <td ><input type='checkbox' name='Nutritional_Status' value='To improve Nutritional Status'></td><td><span>To improve Nutritional Status</span></td> </tr>";
    }
      if($rs[Maintain_BP] == 'Maintain B.P. Within normal limits'){
		        echo"
  <tr>
     <td ><input type='checkbox' name='Maintain_BP' value='Maintain B.P. Within normal limits' checked></td><td><span>Maintain B.P. Within normal limits</span></td></tr>";
    } 
    else
    {
        echo"
      <tr>
      <td ><input type='checkbox' name='Maintain_BP' value='Maintain B.P. Within normal limits'></td><td><span>Maintain B.P. Within normal limits</span></td> </tr>";
    }
    
     if($rs[Blood_Sugar] == 'Maintain Blood Sugar Within normal limits'){
		        echo"
  <tr>
     <td ><input type='checkbox' name='Blood_Sugar' value='Maintain Blood Sugar Within normal limits'></td><td><span>Maintain Blood Sugar Within normal limits</span></td> </tr>";
    } 
    else
    {
        echo"
      <tr>
      <td ><input type='checkbox' name='Blood_Sugar' value='Maintain Blood Sugar Within normal limits'></td><td><span>Maintain Blood Sugar Within normal limits</span></td> </tr>";
    }
 
     if($rs[Reduce_Cholesterol] == 'Reduce Cholesterol/triglycerides within normal limits'){
		        echo"
  <tr><td><input type='checkbox' name='Reduce_Cholesterol' value='Reduce Cholesterol/triglycerides within normal limits'></td><td><span>Reduce Cholesterol/triglycerides within normal limits</span></td></tr>";
    } 
    else
    {
        echo"
      <tr><td><input type='checkbox' name='Reduce_Cholesterol' value='Reduce Cholesterol/triglycerides within normal limits'></td><td><span>Reduce Cholesterol/triglycerides within normal limits</span></td></tr>";
    }

   
      
       echo"    
    
    </table>

<h5>Diet Recommended:</h5>
<table id='example2' class='table table-bordered table-hover'>
    
    <tr><td width='50%'>Energy :</td><td width='50%'><input type='text' name='Energy' value='$rs[Energy]' placeholder='Kcal/day'></td></tr>
<tr><td width='50%'>Protein :</td><td width='50%'><input type='text' value='$rs[Protein]'  name='Protein' placeholder='gm./day'></td></tr>
<tr><td width='50%'>Fat :</td><td width='50%'><input type='text' value='$rs[Fat]' name='Fat' placeholder='gm./day'></td></tr>
<tr><td width='50%'>Note :</td><td width='50%'><textarea  name='note' rows='2' cols='70'>$rs[note]</textarea></td></tr>
</table>
";
}
?>
<input type="submit" name="Nutrition_Recommendation" id="Nutrition_Recommendation" value="Submit" />
    </form>
    <p>&nbsp;</p>

  
</body>
</html>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

     <script type="text/javascript">
$(document).ready(function(){
    $('#myForm').submit(function() {
     $('#loaderImg').show(); 
      return true;
    });
});
  </script>
<style>
      #loaderImg {
         position: absolute;
         top: 0;
         bottom: 0;
         left: 0;
         right: 0; 
         margin: auto;
         border: 10px solid grey;
         border-radius: 50%;
         border-top: 10px solid black;
         width: 100px;
         height: 100px;
         animation: spin 1s linear infinite;
      }
      @keyframes spin {
         0% {
            -webkit-transform: rotate(0deg);
            transform: rotate(0deg);
         }
         100% {
            -webkit-transform: rotate(360deg);
            transform: rotate(360deg);
         }
      }
   </style>