<?php
session_start();
include("headers.php");
include("workdeskmenu.php");
include("dbconnection.php");
if(isset($_POST[submit]))
{
		$sql ="INSERT INTO carrectivepreventive(id,toward,note,entered_by) values('$_POST[id]','$_POST[toward]','$_POST[note]','$_POST[entered_by]')";
		if($qsql = mysqli_query($con,$sql))
		{
			echo "<script>alert('Corrective and Preventive Note Add successfully...');</script><script>
 window.history.go(-2)</script>";
		}
		else
		{
			echo mysqli_error($con);
		}
}
?>


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

$DisplayForm=True;
$narayan=LoginManager::currentUser();
$hari=LoginManager::getUserTypeByuname("$narayan");
		$sql41 ="SELECT * FROM carrectivepreventive WHERE id='$_GET[id]' AND toward='$_GET[toward]'";
		$qsql41 = mysqli_query($con,$sql41);
		while($rp1 = mysqli_fetch_array($qsql41))
		{
$DisplayForm=False;
echo "<script>window.location='show_carrectivepreventive.php?toward=$rp1[toward]&id=$rp1[id]'</script>";
}
if($DisplayForm)
{
?>
<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"></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");
?>

<?php
}
?>