<?php
if(@isset($_POST['Consentrelatedva'])){
    $updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");

	 $CheckPatient = $con->query("SELECT * FROM Consentrelated WHERE prescriptionid = '$_POST[prescriptionid]' AND patientid = '$_POST[patientid]' AND Consentrelated='$_POST[Consentrelated]' AND Consentrelated_Native='$_POST[Consentrelated_Native]' AND Consentrelated_Corrective='$_POST[Consentrelated_Corrective]'");
$numSU=mysqli_num_rows($CheckPatient);
if($numSU > 0){
        echo "<script>alert('Already Exists');</script>";
    }else{ 
	


$DelayIn=$con->query("INSERT INTO Consentrelated(id,prescriptionid,patientid,Consentrelated,Consentrelated_Native,Consentrelated_Corrective,entered_by,created_at,updated_at) VALUES (NULL,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[Consentrelated]','$_POST[Consentrelated_Native]','$_POST[Consentrelated_Corrective]','$_POST[entered_by]','$created_at','$updated_at')");
$last_id = mysqli_insert_id($con);


$save_activity=$con->query("INSERT INTO save_activity(srno,userno,prescriptionid,discription,entered_by,link,created_at,updated_at) VALUES (NULL, '$_POST[patientid]','$_POST[prescriptionid]','Incident Report<br>Consent Related','$_POST[entered_by]','showConsentrelated.php?prescriptionid=$_POST[prescriptionid]&patientid=$_POST[patientid]&id=$last_id','$created_at','$updated_at')");

if($DelayIn){
echo "<script>alert('Consent Related Add successfully..');</script><script>window.history.go(-1)</script>;</script>";  
}
}

    
		 }

?>


           	<h3><i class="fa fa-angle-right"></i> &nbsp; &nbsp;Consent related  </h3>
           	
           	<form name="Consentrelatedva" method="post">
           	  
           	   <input type='hidden' name='entered_by' value='<?php echo $entered_by; ?>'>
<input type='hidden' name='patientid' value='<?php echo $_GET['patientid']; ?>'>
<input type='hidden' name='prescriptionid' value='<?php echo $_GET['prescriptionid']; ?>'>            	 
           	 
           	    
           	  <table class='table table-hover table-bordered'>
           	      <tr>
           	          <td><label for="address">Consent related </label></td>
           	          <td> <select name="Consentrelated" class='form-control'>
              <option value="" disabled selected>Consent related</option>
             <option value="Incorrect consent form used">Incorrect consent form used </option>
<option value="Incomplete consent form">Incomplete consent form </option>
<option value="Consent not taken">Consent not taken   </option>
<option value="Consent given by unauthorized personnel">Consent given by unauthorized personnel  </option>
        </select></td>
           	      </tr>
           	      
           	       <tr>
           	          <td>  <label>Native description of Occurrence</label></td>
           	          <td><input type="text" class='form-control' name="Consentrelated_Native" placeholder="Native description of Occurrence"></td>
           	      </tr>
           	      
           	       <tr>
           	          <td> <label>Corrective And Preventive Action Taken</label></td>
           	          <td>  <input type="text" class='form-control' name="Consentrelated_Corrective" placeholder="Corrective And Preventive Action Taken"> </td>
           	      </tr>
           	      
           	       <tr>
           	         
           	          <td colspan='2'><button style="float: right;"  name="Consentrelatedva" type="submit" class='btn btn-success'> Save</button></td>
           	      </tr>
           	     
           	      
           	      </table>
           	   
    
        
</form>