479 lines
14 KiB
PHP
479 lines
14 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>
|
|
</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" />
|
|
<input type="hidden" name="flex_opd_id" id="flex_opd_id" />
|
|
<input type="hidden" name="returnPage" id="returnPage" />
|
|
|
|
</form>
|
|
<div id="flex1" style="width:100%">
|
|
</div>
|
|
<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: 'sickness_list_script.php',
|
|
dataType: 'json',
|
|
colModel: [{
|
|
display: '',
|
|
name: '',
|
|
width: w * .12,
|
|
sortable: false,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Sr',
|
|
name: 'count',
|
|
width: w * .04,
|
|
sortable: false,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Apointment Date',
|
|
name: 'sickness_date',
|
|
width: w * .11,
|
|
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 * .15,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Emp code',
|
|
name: 'emp_code',
|
|
width: w * .15,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Treatment start',
|
|
name: 'from_date',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Treatment End',
|
|
name: 'to_date',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Absence Start',
|
|
name: 'date_absent',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Rejoining Date',
|
|
name: 'date_return',
|
|
width: w * .1,
|
|
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 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: 'Emp Code',
|
|
name: 'emp_code',
|
|
isdefault: true
|
|
},
|
|
{
|
|
display: 'Patient Name',
|
|
name: 'patient_name',
|
|
isdefault: true
|
|
},
|
|
// {
|
|
// 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 open_pdf_fitness(sickness_id) {
|
|
if (sickness_id != null && sickness_id != "") {
|
|
$("#flex_sickness_id").val(sickness_id);
|
|
$("#flex_form_sickness").attr('target', '_blank');
|
|
$("#flex_form_sickness").attr('method', 'POST');
|
|
$("#flex_form_sickness").attr('action', 'fitness_certificate.php');
|
|
$("#flex_form_sickness").submit();
|
|
}
|
|
|
|
}
|
|
|
|
|
|
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 pdf(appointment_id) {
|
|
window.open('ajax_pdf.php?appointment_id', 'OPD-Injury List');
|
|
}
|
|
|
|
function excel() {
|
|
window.open('ajax_excel.php?appointment_id', 'OPD-Injury List');
|
|
}
|
|
|
|
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();
|
|
}
|
|
|
|
|
|
/*var sickness_id = "";
|
|
function open_sickness(sicknessId, action) {
|
|
var sickness_id = "";
|
|
if(action=="V"){
|
|
$(".save_button").hide();
|
|
//replaceInputFieldsWithDiv();
|
|
}else{
|
|
$(".save_button").show();
|
|
}
|
|
$.ajax({
|
|
url : 'select_sickness.php?sicknessId='+sicknessId+' ',
|
|
type : 'POST',
|
|
success : function(data) {
|
|
//alert(data);
|
|
var data = $.parseJSON(data);
|
|
//alert(data);
|
|
|
|
$("#sickness_id").val(data.sickness_id);
|
|
$("#sickness_date").val(myDateFormater(data.sickness_date));
|
|
$("#from_date").val(myDateFormater(data.date_absent));
|
|
$("#to_date").val(myDateFormater(data.to_date));
|
|
$("#justifiable_from").val(myDateFormater(data.justifiable_from));
|
|
$("#justifiable_to").val(myDateFormater(data.justifiable_to));
|
|
$("#date_absent").val(myDateFormater(data.date_return));
|
|
$("#date_return").val(myDateFormater(data.date_return));
|
|
$("#agency").val(data.agency);
|
|
$("#sickness_name").val(data.sickness_name);
|
|
$("#des").val(data.des);
|
|
$("#emp_id").val(data.emp_id);
|
|
|
|
$('#modal-add-sickness').modal("show");
|
|
},
|
|
error : function(data) {
|
|
BootstrapDialog.alert('Error Populating Sickness');
|
|
return;
|
|
}
|
|
});
|
|
}*/
|
|
|
|
function open_sickness(sicknessId, action, emp_id) {
|
|
|
|
if (action == 'V') {
|
|
// document.forms['flex_form_sickness'].action="view_sickness.php";
|
|
document.forms[0].action = "sickness_view.php";
|
|
} else if (action == 'W') {
|
|
document.forms[0].action = "sickness.php";
|
|
}
|
|
|
|
$("#flex_sickness_id").val(sicknessId);
|
|
$("#flex_opd_id").val(emp_id);
|
|
document.forms[0].method = 'Post';
|
|
document.forms[0].target = '';
|
|
document.forms[0].submit();
|
|
|
|
//$("#flex_form_sickness").method="post";
|
|
//$("#flex_form_sickness").find("#flex_sickness_id").val(sicknessId);
|
|
//$("#flex_form_sickness").find("#returnPage").val("sickness_list.php");
|
|
//$("#flex_form_sickness").submit();
|
|
}
|
|
|
|
|
|
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();
|
|
}
|
|
|
|
function open_item(sicknessId) {
|
|
$("#sicknessId").val("");
|
|
|
|
$("#email_form").find("#ref_identifier").val(sicknessId);
|
|
$("#email_form").find("#ref_type").val("Fitness");
|
|
$("#email_form").find("#to").val('<?php echo getConfigKey('GENERAL_EMAIL_LIST_TO_FITNESS') ?>');
|
|
$("#email_form").find("#cc").val('<?php echo getConfigKey('GENERAL_EMAIL_LIST_CC_FITNESS') ?>');
|
|
$("#email_form").find("#subject").val('<?php echo getConfigKey('GENERAL_EMAIL_SUBJECT_FITNESS') ?>');
|
|
$("#email_form").find("#message").val('<?php echo getConfigKey('GENERAL_EMAIL_TEXT_FITNESS') ?>');
|
|
|
|
|
|
|
|
|
|
|
|
// window.alert("{appointmentId}");
|
|
var id = sicknessId;
|
|
|
|
resizeChosen();
|
|
jQuery(window).on('resize', resizeChosen);
|
|
$('#modal-add-email').modal("show");
|
|
|
|
}
|
|
|
|
|
|
var sickness_id = "";
|
|
|
|
function open_pending_fitness(sicknessId) {
|
|
|
|
$("#flex_sickness_id").val(sicknessId);
|
|
$("#flex_form_sickness").method = 'Post';
|
|
$("#flex_form_sickness").action = 'fitness.php';
|
|
$("#flex_form_sickness").target = '';
|
|
$("#flex_form_sickness").submit();
|
|
/*$("#flex_form_sickness").method="post";
|
|
$("#flex_form_sickness").action="fitness.php";
|
|
$("#flex_sickness_id").val(sicknessId);
|
|
$("#flex_form_sickness").submit();*/
|
|
}
|
|
|
|
function send_email() {
|
|
var sickness_id;
|
|
$.ajax({
|
|
url: 'send_email.php',
|
|
type: 'POST',
|
|
data: $("#email_form").serialize(),
|
|
success: function(data) {
|
|
BootstrapDialog.alert('Mail send Successfully');
|
|
$("#flex1").flexReload();
|
|
return;
|
|
},
|
|
error: function(data) {
|
|
BootstrapDialog.alert('Error in sending mail');
|
|
return;
|
|
}
|
|
});
|
|
$('.close').click();
|
|
}
|
|
</script>
|
|
|
|
<?php include('techsyn_footer.php'); ?>
|
|
<?php // include('form/add_sickness.php');
|
|
?>
|
|
<?php include('form/send_mail.php'); ?>
|
|
<?php include('common_ace.php'); ?>
|