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

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


$Medicationrelated=$con->query("INSERT INTO Securityrelated(id,prescriptionid,patientid,Securityrelated,Securityrelated_Native,Securityrelated_Corrective,entered_by,created_at,updated_at) VALUES (NULL,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[Securityrelated]','$_POST[Securityrelated_Native]','$_POST[Securityrelated_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>Security related','$_POST[entered_by]','showSecurityrelated.php?prescriptionid=$_POST[prescriptionid]&patientid=$_POST[patientid]&id=$last_id','$created_at','$updated_at')");

if($Medicationrelated){
echo "<script>alert('Security related add successfully..');</script><script>window.history.go(-1)</script>;</script>";  
}
}	
		
	 }

?>


           	<h3><i class="fa fa-angle-right"></i> &nbsp; &nbsp;Security related </h3>
           	
           	<form name="Securityrelatedva" 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">Security related</label></td>
<td><select name="Securityrelated" class='form-control'>
              <option value="" disabled selected>Security related</option>
             <option value="Assault to patient">Assault to patient</option>
<option value="Assault to patient visitor">Assault to patient visitor</option><option value="Theft">Theft</option>
<option value="Lost">Lost</option>
<option value="Absconding patient">Absconding patient</option>
<option value="Unauthorized visitors entry">Unauthorized visitors entry</option>
        </select></td>
</tr>
<tr>
<td><label>Native description of Occurrence</label></td>
<td>  <input type="text" class='form-control' name="Securityrelated_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="Securityrelated_Corrective" placeholder="Corrective And Preventive Action Taken"> </td>
</tr>
<tr>

<td colspan='2'><button style="float: right;" class='btn btn-success' name="Securityrelatedva" type="submit"> Save</button></td>
</tr>

</table>         	    	
           	
           	    
     
    
        
</form>