| Server IP : 162.240.98.243 / Your IP : 3.137.223.10 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/ |
Upload File : |
<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dbconnection.php");
include("header.php");
include("dashboarddocument.php");
?>
<style>
button {
background-color: #4CAF50;
border: none;
color: white;
padding: 15px 32px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
}
</style>
<!-- jQuery Library -->
<script src="js/jquery.min.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
// Find the toggles and hide their content
$('.toggle').each(function(){
$(this).find('.toggle-content').hide();
});
// When a toggle is clicked (activated) show their content
$('.toggle a.toggle-trigger').click(function(){
var el = $(this), parent = el.closest('.toggle');
if( el.hasClass('active') )
{
parent.find('.toggle-content').slideToggle();
el.removeClass('active');
}
else
{
parent.find('.toggle-content').slideToggle();
el.addClass('active');
}
return false;
});
}); //End
</script>
<!-- Toggle CSS -->
<style type="text/css">
/* Main toggle */
.toggle {
font-size: 13px;
line-height:20px;
font-family: "HelveticaNeue", "Helvetica Neue", Helvetica, Arial, sans-serif;
background: #ffffff; /* Main background */
margin-bottom: 10px;
border: 1px solid #e5e5e5;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
border-radius: 5px;
}
/* Toggle Link text */
.toggle a.toggle-trigger {
display:block;
padding: 10px 20px 15px 20px;
position:relative;
text-decoration: none;
color: #666;
}
/* Toggle Link hover state */
.toggle a.toggle-trigger:hover {
opacity: .8;
text-decoration: none;
}
/* Toggle link when clicked */
.toggle a.active {
text-decoration: none;
border-bottom: 1px solid #e5e5e5;
-webkit-box-shadow: 0 8px 6px -6px #ccc;
-moz-box-shadow: 0 8px 6px -6px #ccc;
box-shadow: 0 8px 6px -6px #ccc;
color: #000;
}
/* Lets add a "-" before the toggle link */
.toggle a.toggle-trigger:before {
content: "-"; /* You can add any symbol, font icon, or graphic icon */
margin-right: 10px;
font-size: 1.3em;
}
/* When the toggle is active, change the "-" to a "+" */
.toggle a.active.toggle-trigger:before {
content: "+";
}
/* The content of the toggle */
.toggle .toggle-content {
padding: 10px 20px 15px 20px;
color:#666;
}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1 Align="center">Incident Report </h1>
<br>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Date & Time</strong></th>
<th><strong>Towards </strong></th>
<th><strong>Reported by </strong></th>
<th><strong>Action</strong></th>
</tr>
</thead>
<?php
session_start();
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql ="DELETE FROM DelayIn WHERE id='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `DelayIn` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Delay In :</b> $rsp[DelayIn] <br> <b>Native description of Occurrence :</b> $rsp[DelayIn_Native] <br><b>Corrective And Preventive Action Taken :</b> $rsp[DelayIn_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_DelayIn.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i>
</a> | <a href='edit_DelayIn.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color:#FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Delay From
if(isset($_GET[DelayFrom_delid]))
{
$sql ="DELETE FROM DelayFrom WHERE id='$_GET[DelayFrom_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `DelayFrom` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Delay From :</b> $rsp[DelayFrom] <br> <b>Delay From Native :</b> $rsp[DelayFrom_Native] <br><b>Delay From Corrective :</b> $rsp[DelayFrom_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_DelayFrom.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_DelayFrom.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DelayFrom_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Reporting Error
if(isset($_GET[ReportingError_delid]))
{
$sql ="DELETE FROM ReportingError WHERE id='$_GET[ReportingError_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `ReportingError` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Reporting Error :</b> $rsp[ReportingError] <br> <b>Reporting Error Native :</b> $rsp[ReportingError_Native] <br><b>Reporting Error Corrective :</b> $rsp[ReportingError_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_ReportingError.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_ReportingError.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ReportingError_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Administrative Related
if(isset($_GET[Administrative_delid]))
{
$sql ="DELETE FROM AdministrativeRelated WHERE id='$_GET[Administrative_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `AdministrativeRelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Administrative Related :</b> $rsp[AdministrativeRelated] <br> <b>Administrative Related Native :</b> $rsp[AdministrativeRelated_Native] <br><b>Administrative Related Corrective :</b> $rsp[AdministrativeRelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_AdministrativeRelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_AdministrativeRelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Administrative_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Clinical care related
if(isset($_GET[Clinicalcarerelated_delid]))
{
$sql ="DELETE FROM Clinicalcarerelated WHERE id='$_GET[Clinicalcarerelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Clinicalcarerelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Clinical care related :</b> $rsp[Clinicalcarerelated] <br> <b>Clinical care related Native :</b> $rsp[Clinicalcarerelated_Native] <br><b>Clinical care related Corrective :</b> $rsp[Clinicalcarerelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Clinicalcarerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Clinicalcarerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Clinicalcarerelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Consent related
if(isset($_GET[Consentrelated_delid]))
{
$sql ="DELETE FROM Consentrelated WHERE id='$_GET[Consentrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Consentrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Consent related :</b> $rsp[Consentrelated] <br> <b>Consent related Native :</b> $rsp[Consentrelated_Native] <br><b>Consent related Corrective :</b> $rsp[Consentrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Consentrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Consentrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Consentrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Equipment related
if(isset($_GET[Equipmentrelated_delid]))
{
$sql ="DELETE FROM Equipmentrelated WHERE id='$_GET[Equipmentrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Equipmentrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Equipment related :</b> $rsp[Equipmentrelated] <br> <b>Equipment related Native :</b> $rsp[Equipmentrelated_Native] <br><b>Equipment related Corrective :</b> $rsp[Equipmentrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Equipmentrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Equipmentrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Equipmentrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Medication related
if(isset($_GET[Medicationrelated_delid]))
{
$sql ="DELETE FROM Medicationrelated WHERE id='$_GET[Medicationrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Medicationrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Medication related :</b> $rsp[Medicationrelated] <br> <b>Medication related Native :</b> $rsp[Medicationrelated_Native] <br><b>Medication related Corrective :</b> $rsp[Medicationrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Medicationrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Medicationrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Medicationrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Needle stick for sharps injury
if(isset($_GET[Needlesharpsinjury_delid]))
{
$sql ="DELETE FROM Needlesharpsinjury WHERE id='$_GET[Needlesharpsinjury_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Needlesharpsinjury` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Needle sharps injury :</b> $rsp[Needlesharpsinjury] <br> <b>Needle sharps injury Native :</b> $rsp[Needlesharpsinjury_Native] <br><b>Needle sharps injury Corrective :</b> $rsp[Needlesharpsinjury_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Needlesharpsinjury.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Needlesharpsinjury.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Needlesharpsinjury_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Software or hardware related
if(isset($_GET[Software_hardwarerelated_delid]))
{
$sql ="DELETE FROM Software_hardwarerelated WHERE id='$_GET[Software_hardwarerelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Software_hardwarerelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Software hardware related :</b> $rsp[Software_hardwarerelated] <br> <b>Software hardware related Native :</b> $rsp[Software_hardwarerelated_Native] <br><b>Software hardware related Corrective :</b> $rsp[Software_hardwarerelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Software_hardwarerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Software_hardwarerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Software_hardwarerelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Laboratory specimen related
if(isset($_GET[Laboratoryspecimenrelated_delid]))
{
$sql ="DELETE FROM Laboratoryspecimenrelated WHERE id='$_GET[Laboratoryspecimenrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Laboratoryspecimenrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Laboratory specimen related :</b> $rsp[Laboratoryspecimenrelated] <br> <b>Laboratory specimen related Native :</b> $rsp[Laboratoryspecimenrelated_Native] <br><b>Laboratory specimen related Corrective :</b> $rsp[Laboratoryspecimenrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Laboratoryspecimenrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Laboratoryspecimenrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i>
</a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Laboratoryspecimenrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Surgery procedure related
if(isset($_GET[Surgeryprocedurerelated_delid]))
{
$sql ="DELETE FROM Surgeryprocedurerelated WHERE id='$_GET[Surgeryprocedurerelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Surgeryprocedurerelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Surgery procedure related :</b> $rsp[Surgeryprocedurerelated] <br> <b>Surgery procedure related Native :</b> $rsp[Surgeryprocedurerelated_Native] <br><b>Surgery procedure related Corrective :</b> $rsp[Surgeryprocedurerelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Surgeryprocedurerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Surgeryprocedurerelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Surgeryprocedurerelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Facility related
if(isset($_GET[Facilityrelated_delid]))
{
$sql ="DELETE FROM Facilityrelated WHERE id='$_GET[Facilityrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Facilityrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Facility related :</b> $rsp[Facilityrelated] <br> <b>Facility related Native :</b> $rsp[Facilityrelated_Native] <br><b>Facility related Corrective :</b> $rsp[Facilityrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Facilityrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Facilityrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Facilityrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Security related
if(isset($_GET[Securityrelated_delid]))
{
$sql ="DELETE FROM Securityrelated WHERE id='$_GET[Securityrelated_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Securityrelated` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Security related :</b> $rsp[Securityrelated] <br> <b>Security related Native :</b> $rsp[Securityrelated_Native] <br><b>Security related Corrective :</b> $rsp[Securityrelated_Corrective]</td>
<td> $rsn[name]</td>
<td><a href='view_Securityrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Securityrelated.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Securityrelated_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Report Disaster
if(isset($_GET[ReportDisaster_delid]))
{
$sql ="DELETE FROM ReportDisaster WHERE id='$_GET[ReportDisaster_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `ReportDisaster` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Report Disaster :</b> $rsp[ReportDisaster] <br> <b>Report Disaster Incidence :</b> $rsp[ReportDisaster_Incidence] <br><b>Report Disaster Native:</b> $rsp[ReportDisaster_Native]
<br><b>Report Disaster Corrective:</b> $rsp[ReportDisaster_Corrective]
</td>
<td> $rsn[name]</td>
<td><a href='view_ReportDisaster.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_ReportDisaster.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ReportDisaster_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Classification of Incidence Near_Miss
if(isset($_GET[Classification_Incidence_delid]))
{
$sql ="DELETE FROM Classification_Incidence WHERE id='$_GET[Classification_Incidence_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Classification_Incidence` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Classification_Incidence='Near_Miss'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
if($rsp['Classification_Incidence']== 'Near_Miss'){
$Classification_Incidence='Near Miss';
}
if($rsp['Classification_Incidence']== 'Sentinel_Event'){
$Classification_Incidence='Sentinel Event';
}
if($rsp['Classification_Incidence']== 'Adverse_Event'){
$Classification_Incidence='Adverse Event';
}
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Classification Incidence :</b> $Classification_Incidence <br>
<b>Native description of Occurrence :</b> $rsp[Minor_Reaction] <br>
<b>Corrective And Preventive Action Taken :</b> $rsp[CorrectivePreventive] <br>
</td>
<td> $rsn[name]</td>
<td><a href='view_Classification_Incidence.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Classification_Incidence.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Classification_Incidence_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Classification of Incidence Near_Miss
if(isset($_GET[Classification_Incidence_delid]))
{
$sql ="DELETE FROM Classification_Incidence WHERE id='$_GET[Classification_Incidence_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlpatient = "SELECT * FROM `Classification_Incidence` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Classification_Incidence='Sentinel_Event'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
if($rsp['Classification_Incidence']== 'Near_Miss'){
$Classification_Incidence='Near Miss';
}
if($rsp['Classification_Incidence']== 'Sentinel_Event'){
$Classification_Incidence='Sentinel Event';
}
if($rsp['Classification_Incidence']== 'Adverse_Event'){
$Classification_Incidence='Adverse Event';
}
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Classification Incidence :</b> $Classification_Incidence <br>
<b>Native description of Occurrence :</b> $rsp[Minor_Reaction] <br>
<b>Corrective And Preventive Action Taken :</b> $rsp[CorrectivePreventive] <br>
</td>
<td> $rsn[name]</td>
<td><a href='view_Classification_Incidence.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Classification_Incidence.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Classification_Incidence_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
// Classification of Incidence Adverse Event
if(isset($_GET[Adverse_Event_delid]))
{
$sql ="DELETE FROM Suspected_Reaction WHERE id='$_GET[Adverse_Event_delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
$sqlSuspected_Reaction = "SELECT * FROM `Suspected_Reaction` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlSuspected_Reaction = mysqli_query($con,$sqlSuspected_Reaction);
while($rsp = mysqli_fetch_array($qsqlSuspected_Reaction)){
$sqlpatient = "SELECT * FROM `Classification_Incidence` WHERE Suspected_Reaction_Id='$rsp[id]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp1 = mysqli_fetch_array($qsqlpatient))
{
if($rsp['Classification_Incidence']== 'Adverse_Event'){
$Suspected_Reaction='Adverse Event';
}
if($rsp['Minor']== 'on'){
$status='Minor';
$Reaction=$rsp['Minor_Reaction'];
}
if($rsp['Major']== 'on'){
$status='Major';
$Reaction =$rsp['Major_Reaction'];
}
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tbody>
<tr> <td> $rsp[created_at]</td>
<td><b>Classification Incidence :</b> $Suspected_Reaction <br>
<b>Seriousness of Reaction :</b> $status <br>
<b> Reaction :</b> $Reaction<br>
<b>Container No :</b> $rsp[Containerno] <br>
<b>Specify :</b> $rsp[Specify] <br>
<b>Other Answer :</b> $rsp[otherAnswer] <br>
<b>Other Answer Date :</b> $rsp[otherAnswer_date] <br>
<b>Name Medicine :</b> $rsp[Name_Medicine] <br>
<b>Treatment Given :</b> $rsp[Treatment_Given] <br>
<b>Outcome :</b> $rsp[Outcome] <br>
<b>Corrective Action :</b> $rsp[Corrective_action] <br>
<b>Recovery Time :</b> $rsp[Recovery_time] <br>
</td>
<td> $rsn[name]</td>
<td><a href='view_Suspected_Reaction.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a> | <a href='edit_Suspected_Reaction.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$rsp[id]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px; color: #FFA500;'></i></a> | <a href='incidentreport.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Adverse_Event_delid=$rsp[id]'><i class='fa fa-trash-o' aria-hidden='true' style='font-size:20px; color:red;'></i></a></td>
</tr>
";
}
}
}
?> </tbody>
<tfoot>
</tfoot>
</table>
<!-- Toggle #1 -->
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Delay In</a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("DelayIn.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div><!-- .toggle (end) -->
<!-- Toggle #2 -->
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Delay From</a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("DelayFrom.php"); ?></p>
</div>
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Reporting Error </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("ReportingError.php"); ?></p>
</div>
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Administrative Related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("AdministrativeRelated.php"); ?></p>
</div>
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Clinical care related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Clinicalcarerelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div><!-- .toggle (end) -->
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Consent related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Consentrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div><!-- .toggle (end) -->
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Equipment related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Equipmentrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Medication related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Medicationrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Needle stick for sharps injury </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Needlesharpsinjury.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Software or hardware related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Software_hardwarerelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Laboratory specimen related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Laboratoryspecimenrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Surgery procedure related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Surgeryprocedurerelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Facility related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Facilityrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Security related </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Securityrelated.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Report Disaster </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("ReportDisaster.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Classification of Incidence </a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Classification_Incidence.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div>
</p>
<div class="clear"></div>
</div>
</div>
<?php
include("footer.php");
?>