<?php
session_start();
include("headers.php");
include("workdeskmenu.php");
include("dbconnection.php");
if(isset($_POST[submit]))
{
	$sql ="UPDATE carrectivepreventive SET note='$_POST[note]' WHERE id='$_GET[id]' AND toward='$_GET[toward]'";
if($qsql = mysqli_query($con,$sql))
		{
    echo "<script>alert('Corrective and Preventive successfully');</script><script>
 window.history.go(-2)</script>";
  } else {
    echo "Sorry, there was an error uploading your file.";
  } 
    
}
?>



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

    <ul>
      <li class="first">Corrective and Preventive Action</li></ul>
  </div>
</div>
<div class="wrapper col4">
  <div id="container">
  
 
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
   <form method="post" action="" name="submit" onSubmit="return validateform()">
    <table width="532" border="3">
	<table id="example2" class="table table-bordered table-hover">  
      <tbody>
	        
            <?php
		  
				echo "<input type='hidden' name='id' value='$_GET[id]'>";
				echo "<input type='hidden' name='toward' value='$_GET[toward]'>";
				  ?>
                  <tr>
          <td width="50">Note</td>
          <td width="50"><textarea  name="note" rows="2" cols="50">
         <?php     	$sql41 ="SELECT * FROM carrectivepreventive WHERE id='$_GET[id]' AND toward='$_GET[toward]'";
		$qsql41 = mysqli_query($con,$sql41);
		while($rp1 = mysqli_fetch_array($qsql41))
		{
		    echo"$rp1[note]";
		}
		?>
          </textarea></td>
          
                 <?php
          include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
          
				
				echo "<input type='hidden' name='entered_by' value='$re[userno]'>";
				}
	?>
	
        <tr>
          <td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Submit" /></td>
        </tr>
      </tbody>
    </table>
    </form>
    <p>&nbsp;</p>

  </div>
</div>
</div>
 <div class="clear"></div>
  </div>
</div>
<?php
include("footer.php");
?>