639 lines
16 KiB
PHP
639 lines
16 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'); ?>
|
|
|
|
|
|
|
|
<!--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 Manag</li>
|
|
|
|
<li class="active">Approved</li>
|
|
|
|
<li class="active">All Sickness/Fitness</li>
|
|
|
|
</ul>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
<!-- End of breadcrumb -->
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<div class="page-content">
|
|
|
|
|
|
|
|
<div id="flexigridDiv" class="table-responsive">
|
|
<div id="flex1" style="width:100%">
|
|
</div>
|
|
</div>
|
|
<form name="flex_form_sickness" method="post" action="fitness.php" id="flex_form_sickness"
|
|
name="flex_form_sickness">
|
|
|
|
<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><!-- /.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: 'fitness_list_script.php',
|
|
|
|
dataType: 'json',
|
|
|
|
colModel: [
|
|
|
|
{
|
|
display: '',
|
|
name: '',
|
|
width: w * .1,
|
|
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 * .08,
|
|
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: 'Department',
|
|
name: 'dept_name',
|
|
width: w * .15,
|
|
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: 'Fitness Status',
|
|
name: 'fitness_status',
|
|
width: w * .08,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'Treatment Agency',
|
|
name: 'agency',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Diagnosis',
|
|
name: 'des',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Ailment System',
|
|
name: 'sickness_name',
|
|
width: w * .1,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'Health Status',
|
|
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: '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.open('ajax_excel.php', 'excel_sickness.php');
|
|
|
|
}
|
|
|
|
function open_pdf_fitness_form(sickness_id, status) {
|
|
|
|
$("#flex_sickness_id").val(sickness_id);
|
|
$("#flex_form_sickness").attr('method', 'POST');
|
|
$("#flex_form_sickness").attr('target', '_blank');
|
|
$("#flex_form_sickness").attr('action', 'fitness_certificate.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, status, rowElement,date_to,sr) {
|
|
$("#sicknessId").val("");
|
|
var app_root = '<?php echo getConfigKey('APP_ROOT')?>';
|
|
|
|
var emailContent = "";
|
|
// if (status == "APPROVED") {
|
|
// var link = "" + app_root + "/fitness_certificate.php?flex_sickness_id=" + sicknessId;
|
|
// } else if (status == "REJECTED") {
|
|
// var link = "" + app_root + "/unfit_certificate.php?flex_sickness_id=" + sicknessId;
|
|
// }
|
|
var link = "" + app_root + "/fitness_certificate.php?flex_sickness_id=" + sicknessId;
|
|
$("#email_form").find("#ref_identifier").val(sicknessId);
|
|
$("#email_form").find("#ref_type").val("Fitness");
|
|
$("#email_form").find("#email_list_to").val(
|
|
'<?php echo getCommaSeperatedValuesForInClause('select offiial_email_id from patient_master','id',$email_list_to)?>'
|
|
);
|
|
$("#email_form").find("#email_list_cc").val(
|
|
'<?php echo getCommaSeperatedValuesForInClause('select offiial_email_id from patient_master','id',$email_list_cc)?>'
|
|
);
|
|
$("#email_form").find("#subject").val('<?php echo getConfigKey('GENERAL_EMAIL_SUBJECT_FITNESS')?>');
|
|
$("#email_form").find("#email_content").text(
|
|
'<div style=\"style="text-transform: none; !important"\"><?php echo getConfigKey('GENERAL_EMAIL_TEXT_MEDICAL')?></div>'
|
|
);
|
|
emailContent += "<span>Dear Sir/Madam <br>New Sickness is recordes.<br></span>";
|
|
emailContent +=
|
|
"<table class='table-bordered' style='border: groove;' width='100%'><thead><tr><th style='border: groove;'>Date</th><th style='border: groove;'>Patient Name</th><th style='border: groove;'>Clock no</th>"+
|
|
// <th>Department</th>
|
|
"<th style='border: groove;'>Sickness From Date</th><th style='border: groove;'>sickness till</th>"+
|
|
// <th>Fitness Date</th><th>Fitness Status</th>
|
|
"</tr><thead><tbody>";
|
|
emailContent += "<tr><td style='border: groove;'>" + $(rowElement).parent().parent().parent().children("td[abbr='date_absent']").text() +
|
|
"</td><td style='border: groove;'>" + $(rowElement).parent().parent().parent().children("td[abbr='patient_name']").text()+' '+sr +
|
|
"</td><td style='border: groove;'>" + $(rowElement).parent().parent().parent().children("td[abbr='emp_code']").text() + "</td>"+
|
|
// <td>" + $(
|
|
// rowElement).parent().parent().parent().children("td[abbr='dept_name']").text() + "</td>
|
|
"<td style='border: groove;'>" + $(rowElement)
|
|
.parent().parent().parent().children("td[abbr='date_absent']").text() + "</td><td style='border: groove;'>" + date_to + "</td>"+
|
|
// <td>" + $(rowElement).parent().parent()
|
|
// .parent().children("td[abbr='date_return']").text() + "</td><td>" + $(rowElement).parent().parent().parent()
|
|
// .children("td[abbr='fitness_status']").text() + "</td>
|
|
"</tr>";
|
|
emailContent += "</table>";
|
|
|
|
|
|
|
|
|
|
|
|
//emailContent+= "<?php echo getConfigKey('GENERAL_EMAIL_TEXT_FITNESS')?>";
|
|
|
|
//emailContent= "<table width='100%' border='1px' style='border:1px;'><tr><th>Date</th><th>Patient Name</th><th>Ticket No</th><th>Ailment System</th><th>Fitness Status</th></tr>";
|
|
//emailContent+= "<tr><td>"+$(rowElement).parent().parent().parent().children("td[abbr='sickness_date']").text()+"</td><td>"+$(rowElement).parent().parent().parent().children("td[abbr='patient_name']").text()+"</td><td>"+$(rowElement).parent().parent().parent().children("td[abbr='ticket_no']").text()+"</td><td>"+$(rowElement).parent().parent().parent().children("td[abbr='sickness_name']").text()+"</td><td>"+$(rowElement).parent().parent().parent().children("td[abbr='fitness_status']").text()+"</td></tr>";
|
|
//emailContent+="</table>";
|
|
// emailContent+='<a target="_blank" class="blue" href="http://103.196.222.49:90/tatametaliks_uat/form24_incident_report.php?sicknessId_pdf="+sicknessId>Detail</a>'
|
|
emailContent += "<br><a href='" + link + "'> Details</a> ";
|
|
emailContent += "<br><p>Thanks with Regards<br>Medical Dept.<br>"+"<?= getTableFieldValue('company_profile','company_name')?>"+".</p> ";
|
|
$("#email_form").find("#email_content").html(emailContent);
|
|
|
|
|
|
|
|
|
|
|
|
// window.alert("{appointmentId}");
|
|
var id = sicknessId;
|
|
|
|
resizeChosen();
|
|
jQuery(window).on('resize', resizeChosen);
|
|
$('#modal-add-email').modal("show");
|
|
|
|
}
|
|
|
|
|
|
|
|
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();
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
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();
|
|
}
|
|
|
|
function send_email() {
|
|
var sickness_id;
|
|
|
|
$("#message").val($("#email_form").find("#email_content").html());
|
|
$.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('form/send_mail.php');?>
|
|
<?php include('techsyn_footer.php'); ?>
|