<?php
if(@isset($_POST['Facilityrelatedva']))

	{
	
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");

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


$Facilityrelated=$con->query("INSERT INTO Facilityrelated(id,prescriptionid,patientid,Facilityrelated,Facilityrelated_Native,Facilityrelated_Corrective,entered_by,created_at,updated_at) VALUES (NULL,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[Facilityrelated]','$_POST[Facilityrelated_Native]','$_POST[Facilityrelated_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>Facility related','$_POST[entered_by]','showFacilityrelated.php?prescriptionid=$_POST[prescriptionid]&patientid=$_POST[patientid]&id=$last_id','$created_at','$updated_at')");

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

?>


      
           	<h3><i class="fa fa-angle-right"></i> &nbsp; &nbsp;Facility related </h3>
           	
           	<form name="Facilityrelatedva" 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">Facility related</label></td>
<td> <select name="Facilityrelated" class='form-control'>
              <option value="" disabled selected>Facility related</option>
             <option value="UPS breakdown">UPS breakdown</option>
<option value="Lift breakdown">Lift breakdown</option><option value="Generator breakdown">Generator breakdown</option>
<option value="Oxygen cylinder not available">Oxygen cylinder not available</option>
<option value="No response to the complaint">No response to the complaint</option>
        </select></td>
</tr>
<tr>
<td><label>Native description of Occurrence</label></td>
<td> <input type="text" name="Facilityrelated_Native" class='form-control' placeholder="Native description of Occurrence"></td>
</tr>
<tr>
<td> <label>Corrective And Preventive Action Taken</label></td>
<td> <input type="text" name="Facilityrelated_Corrective" class='form-control' placeholder="Corrective And Preventive Action Taken"> </td>
</tr>
<tr>

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

</table>
           	    
             
         
       
        
       
       
 
        
</form>