| Server IP : 162.240.98.243 / Your IP : 18.227.134.133 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();
include("dbconnection.php");
require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
?>
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://www.jqueryscript.net/demo/Dialog-Modal-Dialogify/dist/dialogify.min.js"></script>
<title>PHP - Sending multiple forms data through jQuery Ajax</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
</head>
<body>
<p align="right">
<button type="button" name="add" id="add" class="btn btn-success btn-xs"><i class="fa fa-plus" aria-hidden="true"></i>Add Medication</button>
</p>
<br />
<?php
include("dbconnection.php");
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$_GET[ivid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo "
<h3>Name of Investigation :<u> $rsn[Investigation]</u></h3>
";
}
?>
<form method="post" id="user_form">
<div class="table-responsive">
<table id="user_data" class="table table-bordered table-striped">
<tr>
<td><b>Drug<br>Name</b></td>
<td><b>Dose</b></td>
<td><b>Route</b></td>
<td><b>Frequency</b></td>
<td><b>Duration</b></td>
<td><b>Action</b></td>
</tr>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <tr>";
if (is_numeric($rs[DRUGS]))
{
$sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rs[DRUGS]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
echo"<td>$rs1[DRUGS_name]</td>";
}
else
{
echo"<td>$rs[DRUGS]</td>";
}
echo"<td>$rs[Dose]</td><td>$rs[Route]</td>"; echo "<td>";
switch ($rs[Frequency]) {
case '01':
echo "OD (Once Daily)";
break;
case '2':
echo "BID/b.i.d. (twice a day)";
break;
case '3':
echo "TID/t.id. (three times a day)";
break;
case '04':
echo "QID/q.i.d. (four times a day)";
break;
case '1':
echo "QHS (every bedtime)";
break;
case '6':
echo "Q4h (every 4 hours)";
break;
case '4':
echo "Q4-6h (every 4 to 6 hours)";
break;
case '0.143':
echo "QWK (every week)";
break;
default:
echo "";
} echo"</td><td>$rs[duration] Days ";
echo"
<td> <a href='medication/$rs[potential]'>Edit</a>|<form method='post' action='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' name='status'><input type='submit' name='status' Value='Remove'></form></td>
</tr>
";
}
?>
</table>
</div>
<div align="center">
<input type="submit" name="insert" id="insert" class="btn btn-success btn-xs" value="Submit" />
</div>
</form>
<div id="user_dialog" title="Add Data">
<div class="form-group">
<input type="hidden" name="prescriptionid" id="prescriptionid" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="patientid" id="patientid" class="form-control" />
</div>
<div class="form-group">
<label>Drug Name</label>
<input type='text' onchange="drmdiload(this.value)" name='DRUGS' onkeyup="this.value = this.value.toUpperCase();" list='DRUGS' id='DRUGS'>
<datalist name='DRUGS' id='DRUGS'>
<?php
session_start();
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))
{
$sql ="SELECT * FROM medicine_stok WHERE admin_id='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<option value>Select one...</option>
<option value='$rs[medicine_id]'>$rs[medicine_id]-$rs[DRUGS_name]-$rs[Dose]</option>
";
}
}
?>
</datalist>
<span id="error_DRUGS" class="text-danger"></span>
</div>
<p id='divmedidr'>
<div class="form-group">
<label>Dose</label>
<input type="text" placeholder="Dose" name="Dose" id="Dose" class="form-control" />
<span id="error_Dose" class="text-danger"></span>
</div>
<div class="form-group">
<label> Route</label>
<select class="form-control" name="Route" id="Route" name="Route">
<option value="" disabled selected>Route </option>
<option value="Orally">Orally</option>
<option value="IV/IM">IV/IM</option>
<option value="Sublingually/ Buccally">Sublingually/ Buccally</option>
<option value="Vaginally">Vaginally</option>
<option value="Ocular/ Otic"> Ocular/ Otic </option>
<option value="Nasally">Nasally</option>
<option value="Inhalation/Nebulization">Inhalation/Nebulization</option>
<option value="cutaneously/systemic">cutaneously/systemic</option>
<option value="transdermally">transdermally</option>
</select>
<span id="error_Route" class="text-danger"></span>
</div>
<div class="form-group">
<label>Frequency</label>
<select name="Frequency" id="Frequency" class="form-control">
<option value="" disabled selected>Frequency </option>
<option value="01">OD (Once Daily)</option>
<option value="2">BID/b.i.d. (twice a day)</option>
<option value="3">TID/t.id. (three times a day)</option>
<option value="04">QID/q.i.d. (four times a day)</option>
<option value="1"> QHS (every bedtime) </option>
<option value="6">Q4h (every 4 hours)</option>
<option value="4">Q4-6h (every 4 to 6 hours)</option>
<option value="0.143">QWK (every week)</option>
</select>
<span id="error_Frequency" class="text-danger"></span>
</div>
<div class="form-group">
<label>Duration</label>
<input type="text" name="duration" id='duration' class="form-control">
<span id="error_duration" class="text-danger"></span>
</div>
<div class="form-group">
<input type="hidden" name="poa" id="poa" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="status" id="status" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="Action_med" id="Action_med" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="availability" id="availability" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="batchno" id="batchno" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="entered_by" id="entered_by" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="created_at" id="created_at" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="updated_at" id="updated_at" class="form-control" />
</div>
<div class="form-group" align="center">
<input type="hidden" name="row_id" id="hidden_row_id" />
<button type="button" name="save" id="save" class="btn btn-info">Save</button>
</div>
</div>
<div id="action_alert" title="Action">
</p></div>
</body>
</html>
<script>
$(document).ready(function(){
var count = 0;
$('#user_dialog').dialog({
autoOpen:false,
width:340
});
$('#add').click(function(){
$('#user_dialog').dialog('option', 'title', 'Add Medication');
$('#DRUGS').val('');
$('#error_DRUGS').text('');
$('#Dose').val('');
$('#error_Dose').text('');
$('#Route').val('');
$('#error_Route').text('');
$('#Frequency').val('');
$('#error_Frequency').text('');
$('#duration').val('');
$('#error_duration').text('');
$('#DRUGS').css('border-color', '');
$('#Dose').css('border-color', '');
$('#Route').css('border-color', '');
$('#Frequency').css('border-color', '');
$('#duration').css('border-color', '');
$('#save').text('Save');
$('#user_dialog').dialog('open');
});
$('#save').click(function(){
var error_DRUGS = '';
var DRUGS = '';
if($('#DRUGS').val() == '')
{
error_DRUGS = 'DRUGS is required';
$('#error_DRUGS').text(error_DRUGS);
$('#DRUGS').css('border-color', '#cc0000');
DRUGS = '';
}
else
{
error_DRUGS = '';
$('#error_DRUGS').text(error_DRUGS);
$('#DRUGS').css('border-color', '');
DRUGS = $('#DRUGS').val();
}
if(error_DRUGS != '')
{
return false;
}
var error_Dose = '';
var Dose = '';
if($('#Dose').val() == '')
{
error_Dose= 'Dose is required';
$('#error_Dose').text(error_Dose);
$('#Dose').css('border-color', '#cc0000');
Dose = '';
}
else
{
error_Dose = '';
$('#error_Dose').text(error_Dose);
$('#Dose').css('border-color', '');
Dose = $('#Dose').val();
}
if(error_Dose != '')
{
return false;
}
var error_Route = '';
var Route = '';
if($('#Route').val() == '')
{
error_Dose= 'Route is required';
$('#error_Route').text(error_Dose);
$('#Route').css('border-color', '#cc0000');
Route = '';
}
else
{
error_Route = '';
$('#error_Route').text(error_Route);
$('#Route').css('border-color', '');
Route = $('#Route').val();
}
if(error_Route != '')
{
return false;
}
var error_Frequency = '';
var Frequency = '';
if($('#Frequency').val() == '')
{
error_Frequency= 'Frequency is required';
$('#error_Frequency').text(error_Dose);
$('#Frequency').css('border-color', '#cc0000');
Frequency = '';
}
else
{
error_Frequency = '';
$('#error_Frequency').text(error_Frequency);
$('#Frequency').css('border-color', '');
Frequency = $('#Frequency').val();
}
if(error_Frequency != '')
{
return false;
}
var error_duration = '';
var duration = '';
if($('#duration').val() == '')
{
error_duration= 'duration is required';
$('#error_duration').text(error_Dose);
$('#duration').css('border-color', '#cc0000');
duration = '';
}
else
{
error_duration = '';
$('#error_duration').text(error_duration);
$('#duration').css('border-color', '');
duration = $('#duration').val();
}
if(error_duration != '')
{
return false;
}
else
{
if($('#save').text() == 'Save')
{
count = count + 1;
output = '<tr id="row_'+count+'">';
output += '<td>'+DRUGS+' <input type="hidden" name="hidden_DRUGS[]" id="DRUGS'+count+'" class="DRUGS" value="'+DRUGS+'" /></td>';
output += '<td>'+Dose+' <input type="hidden" name="hidden_Dose[]" id="Dose'+count+'" class="Dose" value="'+Dose+'" /></td>';
output += '<td>'+Route+' <input type="hidden" name="hidden_Route[]" id="Route'+count+'" class="Route" value="'+Route+'" /></td>';
output += '<td>'+Frequency+' <input type="hidden" name="hidden_Frequency[]" id="Frequency'+count+'" class="Frequency" value="'+Frequency+'" /></td>';
output += '<td>'+duration+' <input type="hidden" name="hidden_duration[]" id="duration'+count+'" class="duration" value="'+duration+'" /></td>';
output += ''+prescriptionid+' <input type="hidden" name="hidden_prescriptionid[]" id="prescriptionid'+count+'" value="<?php echo"$_GET[prescriptionid]" ?>" />';
output += ''+patientid+' <input type="hidden" name="hidden_patientid[]" id="patientid'+count+'" value="<?php echo"$_GET[patientid]" ?>" />';
output += ''+poa+' <input type="hidden" name="hidden_poa[]" id="poa'+count+'" value="Opd_Medicine" />';
output += ''+status+' <input type="hidden" name="hidden_status[]" id="status'+count+'" value="Active" />';
output += ''+Action_med+' <input type="hidden" name="hidden_Action_med[]" id="Action_med'+count+'" value="Action_med" />';
output += ''+availability+' <input type="hidden" name="hidden_availability[]" id="availability'+count+'" value="availability" />';
output += ''+batchno+' <input type="hidden" name="hidden_batchno[]" id="batchno'+count+'" value="askjdkjsd"/>';
output += ''+entered_by+' <input type="hidden" name="hidden_entered_by[]" id="entered_by'+count+'" value="entered_by"/>';
output += ''+created_at+' <input type="hidden" name="hidden_created_at[]" id="created_at'+count+'" value="created_at"/>';
output += ''+updated_at+' <input type="hidden" name="hidden_updated_at[]" id="updated_at'+count+'" value="updated_at"/>';
output += '<td><button type="button" name="view_details" class="btn btn-warning btn-xs view_details" id="'+count+'"><i class="fa fa-edit" aria-hidden="true"></i></button>';
output += '<button type="button" name="remove_details" class="btn btn-danger btn-xs remove_details" id="'+count+'"><i class="fa fa-trash" aria-hidden="true"></i></button></td>';
output += '</tr>';
$('#user_data').append(output);
}
else
{
var row_id = $('#hidden_row_id').val();
output = '<td>'+DRUGS+' <input type="hidden" name="hidden_DRUGS[]" id="DRUGS'+row_id+'" class="DRUGS" value="'+DRUGS+'" /></td>';
output = '<td>'+Dose+' <input type="hidden" name="hidden_Dose[]" id="Dose'+row_id+'" class="Dose" value="'+Dose+'" /></td>';
output = '<td>'+Route+' <input type="hidden" name="hidden_Route[]" id="Route'+row_id+'" class="Route" value="'+Route+'" /></td>';
output = '<td>'+Frequency+' <input type="hidden" name="hidden_Frequency[]" id="Frequency'+row_id+'" class="Frequency" value="'+Frequency+'" /></td>';
output = '<td>'+duration+' <input type="hidden" name="hidden_duration[]" id="duration'+row_id+'" class="duration" value="'+duration+'" /></td>';
output += ''+prescriptionid+' <input type="hidden" name="hidden_prescriptionid[]" id="prescriptionid'+row_id+'" value="<?php echo"varanayuy" ?>" />';
output += ''+patientid+' <input type="hidden" name="hidden_patientid[]" id="patientid'+row_id+'" value="<?php echo"varanayuy" ?>" />';
output += ''+poa+' <input type="hidden" name="hidden_poa[]" id="poa'+row_id+'" value="Opd_Medicine" />';
output += ''+status+' <input type="hidden" name="hidden_status[]" id="status'+row_id+'" value="Active" />';
output += ''+Action_med+' <input type="hidden" name="hidden_Action_med[]" id="Action_med'+row_id+'" value="Action_med" />';
output += ''+availability+' <input type="hidden" name="hidden_availability[]" id="availability'+row_id+'" value="Active" />';
output += ''+batchno+' <input type="hidden" name="hidden_batchno[]" id="batchno'+row_id+'" value="Active" />';
output += ''+entered_by+' <input type="hidden" name="hidden_entered_by[]" id="entered_by'+row_id+'" value="entered_by" />';
output += ''+created_at+' <input type="hidden" name="hidden_created_at[]" id="created_at'+row_id+'" value="created_at" />';
output += ''+updated_at+' <input type="hidden" name="hidden_updated_at[]" id="updated_at'+row_id+'" value="updated_at" />';
output += '<td><button type="button" name="view_details" class="btn btn-warning btn-xs view_details" id="'+row_id+'"><i class="fa fa-edit" aria-hidden="true"></i></button>';
output += '<button type="button" name="remove_details" class="btn btn-danger btn-xs remove_details" id="'+row_id+'"><i class="fa fa-trash" aria-hidden="true"></i></button></td>';
$('#row_'+row_id+'').html(output);
}
$('#user_dialog').dialog('close');
}
});
$(document).on('click', '.view_details', function(){
var row_id = $(this).attr("id");
var DRUGS = $('#DRUGS'+row_id+'').val();
$('#DRUGS').val(DRUGS);
var Dose = $('#Dose'+row_id+'').val();
$('#Dose').val(Dose);
var Route = $('#Route'+row_id+'').val();
$('#Route').val(Route);
var Frequency = $('#Frequency'+row_id+'').val();
$('#Frequency').val(Frequency);
var duration = $('#duration'+row_id+'').val();
$('#duration').val(duration);
$('#save').text('Edit');
$('#hidden_row_id').val(row_id);
$('#user_dialog').dialog('option', 'title', 'Edit Data');
$('#user_dialog').dialog('open');
});
$(document).on('click', '.remove_details', function(){
var row_id = $(this).attr("id");
if(confirm("Are you sure you want to remove this row data?"))
{
$('#row_'+row_id+'').remove();
}
else
{
return false;
}
});
$('#action_alert').dialog({
autoOpen:false
});
$('#user_form').on('submit', function(event){
event.preventDefault();
var count_data = 0;
$('.DRUGS').each(function(){
count_data = count_data + 1;
});
if(count_data > 0)
{
var form_data = $(this).serialize();
$.ajax({
url:"testmedipavan2.php",
method:"POST",
data:form_data,
success:function(data)
{
$('#user_data').find("tr:gt(0)").remove();
$('#action_alert').html('<p>DRUGS Inserted Successfully</p>');
$('#action_alert').dialog('open');
window.location.href = "opdset.php?prescriptionid=<?php echo "$_GET[prescriptionid]"?>&patientid=<?php echo "$_GET[patientid]" ?>";
}
})
}
else
{
$('#action_alert').html('<p>Please Add atleast one data</p>');
$('#action_alert').dialog('open');
}
});
});
</script>
<script>
function drmdiload(DRUGS)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("divmedidr").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loaddrug.php?DRUGS="+DRUGS,true);
xmlhttp.send();
}
</script>