ESH/pending_fitness_list.php
2024-10-23 18:28:06 +05:30

363 lines
10 KiB
PHP

<?php include('techsyn_header.php'); ?>
<!-- Main Content Container for side bar and body-->
<div class="main-container ace-save-state" id="main-container">
<script type="text/javascript">
try {
ace.settings.loadState('main-container')
} catch (e) {}
</script>
<?php include('techsyn_sidebar.php'); ?>
<?php
$id = $_POST['flex_opd_id'];
$query = "select * from patient_master where id = '".$id."' ";
//echo $query;
if (!$result = @mysqli_query($conn,$query)) {
exit(mysqli_error($conn));
} else{
$row=@mysqli_fetch_array($result);
@extract($row);
}
?>
<!--breadcrumb-->
<div class="main-content">
<div class="main-content-inner">
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
<ul class="breadcrumb">
<li class="active">Patient Visit</li>
<li class="active">Sickness</li>
<li class="active">Pending Fitness</li>
</ul>
</div>
<!-- End of breadcrumb -->
<div class="page-content">
<div id="flexigridDiv" class="table-responsive">
<form name="f1" method="post" action="fitness.php" id="flex_form_sickness"
name="flex_form_sickness">
<div id="flex1" style="width:100%">
</div>
<input type="hidden" name="flex_sickness_id" id="flex_sickness_id" />
</form>
<form name="export_form" method="post" id="export_form" action="">
<input type="hidden" name="flex_employee_appointment_id" id="flex_employee_appointment_id" />
<input type="hidden" name="pdf_action" id="pdf_action" value="pdf_sickness.php" />
<input type="hidden" name="excel_action" id="excel_action" value="excel_sickness.php" />
</form>
</div>
</div>
</div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->
<script type="text/javascript">
$(function() {
var w = screen.width * .90;
var h = 0;
h = (window.innerHeight - ($("#navbar").height() + $(".breadcrumbs").height())) * .75;
$("#flex1").flexigrid({
url: 'pending_fitness_list_script.php',
dataType: 'json',
colModel: [{
display: '',
name: '',
width: w * .08,
sortable: false,
align: 'left'
},
{
display: 'Sr',
name: 'count',
width: w * .04,
sortable: false,
align: 'left'
},
{
display: 'Apointment Date',
name: 'sickness_date',
width: w * .1,
sortable: true,
align: 'left'
},
{
display: 'Ticket No',
name: 'ticket_no',
width: w * .05,
sortable: true,
align: 'left'
},
{
display: 'Token No',
name: 'token_no',
width: w * .05,
sortable: true,
align: 'left'
},
{
display: 'Patient Name',
name: 'patient_name',
width: w * .12,
sortable: true,
align: 'left'
},
{
display: 'Treatment start',
name: 'from_date',
width: w * .08,
sortable: true,
align: 'left'
},
{
display: 'Treatment End',
name: 'to_date',
width: w * .08,
sortable: true,
align: 'left'
},
{
display: 'Absence Start',
name: 'date_absent',
width: w * .08,
sortable: true,
align: 'left'
},
{
display: 'Rejoining Date',
name: 'date_return',
width: w * .08,
sortable: true,
align: 'left'
}, {
display: 'Days of Leaves',
name: 'date_difference',
width: w * .08,
sortable: true,
align: 'left'
},
{
display: 'Treatment Agency',
name: 'agency',
width: w * .1,
sortable: true,
align: 'left'
},
{
display: 'Ailment Name',
name: 'sickness',
width: w * .1,
sortable: true,
align: 'left'
},
{
display: 'Ailment Details',
name: 'des',
width: w * .1,
sortable: true,
align: 'left'
},
],
buttons: [
{
name: 'PDF',
bclass: 'print',
onpress: pdf
},
{
separator: true
},
{
name: 'Excel',
bclass: 'print_excel',
onpress: excel
},
{
separator: true
}
],
searchitems: [
{
display: 'Patient Name',
name: 'sickness_name',
isdefault: true
},
{
display: 'Description',
name: 'des'
},
{
display: 'Sickness Date ',
name: 'sickness_date'
},
{
display: 'Treatment start Date',
name: 'from_date'
},
{
display: 'Treatment End Date ',
name: 'to_date'
},
{
display: 'Absence Start Date',
name: 'date_absent'
},
{
display: 'Rejoining Date',
name: 'date_return'
},
{
display: 'Treatment Agency',
name: 'agency'
},
{
display: 'Sickness Date Between',
name: 'sickness_date_between'
},
{
display: 'Treatment start Date Between',
name: 'from_date_between'
},
{
display: 'Treatment End Date Between',
name: 'to_date_between'
},
{
display: 'Date Absent Between',
name: 'date_absent_between'
},
{
display: 'Date Return Between',
name: 'date_return_between'
},
],
sortname: "sickness_date",
sortorder: "desc",
usepager: true, //pagination
useRp: true,
rp: 50, //records per page
showTableToggleBtn: false, //toggle button for the whole table
resizable: true,
//width: w,
height: h,
singleSelect: true
});
});
function add() {
$(".save_button").show();
$("#sickness_id").val("");
$("#sickness_date").val("");
$("#from_date").val("");
$("#to_date").val("");
$("#date_absent").val("");
$("#date_return").val("");
$("#agency").val("");
$("#sickness_name").val("");
$("#des").val("");
$("#emp_id").val("");
$('#modal-add-sickness').modal("show");
}
function pdf(appointment_id) {
window.open('ajax_pdf.php?appointment_id', 'OPD-Injury List');
}
function excel() {
window.location = 'excel_sickness.php';
}
function delete_fitness(fitnessId) {
$("#flex_sickness_id").val(fitnessId);
BootstrapDialog.confirm('Are you sure to delete the fitness?', function(result) {
if (result) {
$.ajax({
url: 'delete_sickness.php',
type: "POST",
data: $("#flex_form_sickness").serialize(),
success: function(data) {
if (data.indexOf("SUCCESS") != -1) {
BootstrapDialog.alert('fitness Deleted Successfully.');
$("#flex1").flexReload();
} else {
BootstrapDialog.alert('Error Deleting fitness');
}
return;
},
error: function(data) {
BootstrapDialog.alert('Error Deleting fitness');
return;
}
});
}
});
}
function save_sickness() {
$.ajax({
url: 'save_sickness_form.php?id=' + sickness_id + ' ',
type: "POST",
data: $("#sickness_form").serialize(),
success: function(data) {
BootstrapDialog.alert('Sickness Saved Successfully.');
$("#flex1").flexReload();
return;
},
error: function(data) {
BootstrapDialog.alert('Error Saving Sickness');
return;
}
});
$('.close').click();
}
function open_pdf_fitness_certificate(sickness_id, certificate) {
var link = '';
if (certificate == 'rest') link = 'medical_certificate_rest_pdf.php';
else if (certificate == 'duty') link = 'medical_certificate_fitness_duty_pdf.php';
else if (certificate == 'fitness') link = 'fitness_certificate.php';
else if (certificate == 'experience') link = 'experience_certificate_pdf.php';
else link = '';
$("#flex_sickness_id").val(sickness_id);
$("#flex_form_sickness").attr('method', 'POST');
$("#flex_form_sickness").attr('target', '_blank');
$("#flex_form_sickness").attr('action', link);
$("#flex_form_sickness").submit();
}
var sickness_id = "";
function open_pending_fitness(sicknessId) {
$("#flex_form_sickness").action = "fitness.php";
$("#flex_form_sickness").method = "post";
$("#flex_sickness_id").val(sicknessId);
$("#flex_form_sickness").submit();
}
</script>
<?php include('techsyn_footer.php'); ?>
<?php include('form/add_sickness.php');?>
<?php include('common_ace.php'); ?>