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

952 lines
26 KiB
PHP

<?php include('techsyn_header.php');
include 'log_entry.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
error_reporting(E_ERROR | E_PARSE);
$id = $_REQUEST['flex_role_id'];
$sql = "select * from oxygen_cylinder_checklist where id = '".$id."' ";
//echo $query;
$result = mysqli_query($conn,$sql);
$num_rows=@mysqli_num_rows($result);
$row =null;
if($num_rows>0)
{
$row=@mysqli_fetch_array($result);
}
$cylinder_code_id=$row['oxygen_cylinder_id'];
$query="select oxygen_kit_no from oxygen_cylinder where id='".$cylinder_code_id."'";
$result2=mysqli_query($conn,$query);
$num_rows2=@mysqli_num_rows($result2);
$row2 =null;
if($num_rows2>0)
{
$row2=@mysqli_fetch_array($result2);
}
$filled=$row['checked_by'];
$query2="select patient_name from patient_master where id='".$filled."'";
$result3=mysqli_query($conn,$query2);
$num_rows3=@mysqli_num_rows($result3);
$row3 =null;
if($num_rows3>0)
{
$row3=@mysqli_fetch_array($result3);
}
//echo $row['patient_name'];
?>
<!--breadcrumb-->
<div class="main-content">
<div class="main-content-inner">
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
<ul class="breadcrumb">
<li>
<i class="ace-icon fa fa-home home-icon"></i>
<a href="#">Home</a>
</li>
<li class="#">Oxygen cylinder Checklist</li>
</ul>
</div>
<!-- End of breadcrumb -->
<div class="page-content">
<div class="box box-primary"
style="padding: 10px; margin: 2px 0px 50px 5px; width: 99.5%; ">
<form id="oxygen_form" method="post">
<!-- box-body-->
<div class="box-body" id="reload_amb">
<div class="row" >
<div class="col-sm-12">
<table id="myTable" class="table table-bordered order-list" >
<thead>
<tr>
<th width="20%">Oxygen Kit No</th>
<th width="20%">Date Of Receiving</th>
<th width="20%">Date of validity</th>
<th width="20%">Issued date</th>
<th width="20%">Location</th>
</tr>
</thead>
<tbody>
<tr>
<td >
<?php echo $row2['oxygen_kit_no']?>
</td>
<td >
<?php echo date_format(date_create($row['date_receiving']),"d-M-Y")?>
</td>
<td>
<?php echo date_format(date_create($row['date_validity']),"d-M-Y")?>
</td>
<td>
<?php echo date_format(date_create($row['issue_date']),"d-M-Y")?>
<td>
<?php echo $row['location']?>
</td>
</tr>
</tbody>
</table>
<table id="myTable1" width="100%" class="table table-bordered order-list" >
<thead>
<tr>
<th width="25%">Date</th>
<th width="25%">Pressure Reading (Kg/cm<sup>2</sup>)</th>
<th width="25%">Any leakage(Y/n)</th>
<th width="25%">Cylinder valve closed (y/n)</th>
</tr>
</thead>
<tbody>
<tr>
<td width="25%">
<?php echo date_format(date_create($row['check_date']),"d-M-Y")?>
</td>
<td width="25%">
<?php echo $row['pressure_reading']?>
<input type="hidden" name="cylinder_id" id="cylinder_id">
</td>
<td>
<?php echo $row['any_leakage']?>
</td>
<td>
<?php echo $row['valve_closed']?>
</td>
</tr>
</tbody>
<tfoot>
</tfoot>
</table>
<table id="myTable1" width="100%" class="table table-bordered order-list" >
<thead>
<tr>
<th width="25%">Status(empty/full/on use)</th>
<th width="25%">Water of humidifier replaced on</th>
<th width="25%">Remarks</th>
<th width="25%">Checked By</th>
</tr>
</thead>
<tbody>
<tr>
<td width="25%">
<?php echo $row['status']?>
</td>
<td width="25%">
<?php echo $row['water_humidifier_date']?>
</td>
<td>
<?php echo $row['remarks']?>
</td>
<td>
<?php echo $row3['patient_name']?>
</td>
</tr>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<table id="myTable3" width="100%" class="table table-bordered order-list">
<thead>
<tr>
<th>Sl.No.</th>
<th>Questionaries</th>
<th>Answer</th>
<th>Remarks</th>
</tr>
</thead>
<tbody>
<?php $i=0;
$sql = "select * from oxygen_cylinder_questionnaire";
$result = mysqli_query($conn,$sql);
$row=@mysqli_fetch_array($result);
$sql_oxy = "select * from oxygen_cylinder_questionnaire";
$result_oxy = mysqli_query($conn,$sql_oxy);
do{
$count = 0;?>
<tr>
<td><?php echo $i+1?></td>
<td>
<?php echo $row['question']?>
<input type="hidden" name="question_id<?php echo $i?>" id="question_id<?php echo $i?>" value="<?php echo $row['question_id']?>" />
</td>
<?php
$new_sqll = "SELECT * from oxygen_cylinder_checklist_details where oxygen_cylinder_id='".$_REQUEST['checklist_id']."'";
error_log("SELECTION QUERY:".$new_sqll);
$resultl = mysqli_query($conn,$new_sqll);
if(mysqli_num_rows($resultl) > 0) {
$rowl = @mysqli_fetch_array($resultl);
$param_present = (explode(',',$rowl['question_id']));
}
?>
<td style="width: 10%">
<select name="answer<?php echo $i?>" value="<?php if(mysqli_num_rows($resultl) > 0) {
foreach($param_present as $x => $val) {
if($val == $rowl['question_id']){
echo 'Yes';
$count=1;
}
}
if($count==0){
echo 'No';
}
}
?>" id="answer<?php echo $i?>" class="form-control">
<option value='N' >No</option>
<option value='Y' <?php if(mysqli_num_rows($resultl) > 0) {
foreach($param_present as $x => $val) {
if($val == $rowl['question_id']){
echo 'selected';
$count=1;
}
}
if($count==0){
echo 'No';
}
}
?>>Yes</option>
</select>
</td>
<td><input type="text" name="qremarks<?php echo $i?>" id="qremarks<?php echo $i?>"></td>
</tr>
<?php $i++;
}while($row=@mysqli_fetch_array($result))?>
</tbody>
<tfoot>
<td><input type="hidden" name="count_qstn" id="count_qstn" value="<?php echo $i?>"></td>
</tfoot>
</table>
</div>
</div>
</div>
<!-- End box-body-->
<!--box-footer-->
<!--End box-footer-->
</form>
</div>
<!-- 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>
<!--breadcrumb-->
</div>
<?php include('techsyn_footer.php'); ?>
</div>
<!-- End of page-content -->
</div>
</div>
</div>
<script>
function validate(){
save();
}
</script>
<style>
#modal-add-ailment{
overflow-y:scroll;
}
</style>
<?php include('techsyn_footer.php'); ?>
<script type="text/javascript">
if(!ace.vars['old_ie'])
$('#issued_date').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
$('.select2').select2()
jQuery(function($) {
var myTable =
$('#dynamic-table')
.DataTable( {
bAutoWidth: false,
"aoColumns": [
{ "bSortable": false },
null, null,null, null, null,
{ "bSortable": false }
],
"aaSorting": [],
select: {
style: 'multi'
}
} );
var defaultCopyAction = myTable.button(1).action();
myTable.button(1).action(function (e, dt, button, config) {
defaultCopyAction(e, dt, button, config);
$('.dt-button-info').addClass('gritter-item-wrapper gritter-info gritter-center white');
});
var defaultColvisAction = myTable.button(0).action();
myTable.button(0).action(function (e, dt, button, config) {
defaultColvisAction(e, dt, button, config);
if($('.dt-button-collection > .dropdown-menu').length == 0) {
$('.dt-button-collection')
.wrapInner('<ul class="dropdown-menu dropdown-light dropdown-caret dropdown-caret" />')
.find('a').attr('href', '#').wrap("<li />")
}
$('.dt-button-collection').appendTo('.tableTools-container .dt-buttons')
});
setTimeout(function() {
$($('.tableTools-container')).find('a.dt-button').each(function() {
var div = $(this).find(' > div').first();
if(div.length == 1) div.tooltip({container: 'body', title: div.parent().text()});
else $(this).tooltip({container: 'body', title: $(this).text()});
});
}, 500);
myTable.on( 'select', function ( e, dt, type, index ) {
if ( type === 'row' ) {
$( myTable.row( index ).node() ).find('input:checkbox').prop('checked', true);
}
} );
myTable.on( 'deselect', function ( e, dt, type, index ) {
if ( type === 'row' ) {
$( myTable.row( index ).node() ).find('input:checkbox').prop('checked', false);
}
} );
$('th input[type=checkbox], td input[type=checkbox]').prop('checked', false);
$('#dynamic-table > thead > tr > th input[type=checkbox], #dynamic-table_wrapper input[type=checkbox]').eq(0).on('click', function(){
var th_checked = this.checked;
$('#dynamic-table').find('tbody > tr').each(function(){
var row = this;
if(th_checked) myTable.row(row).select();
else myTable.row(row).deselect();
});
});
$('#dynamic-table').on('click', 'td input[type=checkbox]' , function(){
var row = $(this).closest('tr').get(0);
if(this.checked) myTable.row(row).deselect();
else myTable.row(row).select();
});
$(document).on('click', '#dynamic-table .dropdown-toggle', function(e) {
e.stopImmediatePropagation();
e.stopPropagation();
e.preventDefault();
});
var active_class = 'active';
$('#simple-table > thead > tr > th input[type=checkbox]').eq(0).on('click', function(){
var th_checked = this.checked;
$(this).closest('table').find('tbody > tr').each(function(){
var row = this;
if(th_checked) $(row).addClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', true);
else $(row).removeClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', false);
});
});
$('#simple-table').on('click', 'td input[type=checkbox]' , function(){
var $row = $(this).closest('tr');
if($row.is('.detail-row ')) return;
if(this.checked) $row.addClass(active_class);
else $row.removeClass(active_class);
});
$('[data-rel="tooltip"]').tooltip({placement: tooltip_placement});
function tooltip_placement(context, source) {
var $source = $(source);
var $parent = $source.closest('table')
var off1 = $parent.offset();
var w1 = $parent.width();
var off2 = $source.offset();
if( parseInt(off2.left) < parseInt(off1.left) + parseInt(w1 / 2) ) return 'right';
return 'left';
}
/***************/
$('.show-details-btn').on('click', function(e) {
e.preventDefault();
$(this).closest('tr').next().toggleClass('open');
$(this).find(ace.vars['.icon']).toggleClass('fa-angle-double-down').toggleClass('fa-angle-double-up');
});
/***************/
})
function save(){
$.ajax({
url : 'save_oxygen_cylinder_checklist.php',
type : "POST",
data : $("#oxygen_form").serialize(),
success : function(data) {
//alert(data);
var id = $("#oxygen_cylinder_id").val();
BootstrapDialog.alert('Details Saved Successfully.');
$("#oxygen_cylinder_id").val("");
$("#issue_date").val("");
$("#date_receive").val("");
$("#date_validity").val("");
$("#check_date").val("");
$("#water_humidifier_date").val("");
$('#pressure_reading').val("");
$("#location").val("");
$("#any_leakage").val("");
$("#checked_by").val("");
$("#valve_closed").val("");
$("#status").val("");
$("#remarks").val("");
$("#cylinder_id").val(id);
return;
},
error : function(data) {
BootstrapDialog.alert('Error Saving Details');
return;
}
});
$('.close').click();
// location.href="procurement_list.php";
}
$('.date-picker').datepicker({
autoclose:true,
format:'dd/mm/yyyy'
}).next().on(ace.click_event,function(){
$(this).prev().focus();
});
$('#issue_date').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
$('#date_receive').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
$('#date_validity').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
$('#date_check').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
$('#water_humidifier_date').datepicker({
format: 'dd/mm/yyyy',//use this option to display seconds
//'setDate': new Date(),
endDate: "+1d",
//minDate: new Date()-10,
icons: {
time: 'fa fa-clock-o',
date: 'fa fa-calendar',
up: 'fa fa-chevron-up',
down: 'fa fa-chevron-down',
previous: 'fa fa-chevron-left',
next: 'fa fa-chevron-right',
today: 'fa fa-arrows ',
clear: 'fa fa-trash',
close: 'fa fa-times'
}
}).datepicker("setDate", new Date());
</script>
<!-- bootstrap & fontawesome -->
<link rel="stylesheet" href="assets/font-awesome/4.5.0/css/font-awesome.min.css" />
<!-- page specific plugin styles -->
<link rel="stylesheet" href="assets/css/jquery-ui.custom.min.css" />
<link rel="stylesheet" href="assets/css/chosen.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-datepicker3.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-timepicker.min.css" />
<link rel="stylesheet" href="assets/css/daterangepicker.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-colorpicker.min.css" />
<script type="text/javascript" src="js/typeahead.bundle.js"></script>
<script src="assets/js/jquery-ui.custom.min.js"></script>
<script src="assets/js/jquery.ui.touch-punch.min.js"></script>
<script src="assets/js/chosen.jquery.min.js"></script>
<script src="assets/js/spinbox.min.js"></script>
<script src="assets/js/bootstrap-datepicker.min.js"></script>
<script src="assets/js/bootstrap-timepicker.min.js"></script>
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/jquery.dataTables.bootstrap.min.js"></script>
<script src="assets/js/dataTables.buttons.min.js"></script>
<script src="assets/js/buttons.flash.min.js"></script>
<script src="assets/js/buttons.html5.min.js"></script>
<script src="assets/js/buttons.print.min.js"></script>
<script src="assets/js/buttons.colVis.min.js"></script>
<script src="assets/js/dataTables.select.min.js"></script>
<script src="assets/js/moment.min.js"></script>
<script src="assets/js/daterangepicker.min.js"></script>
<script src="assets/js/bootstrap-datetimepicker.min.js"></script>
<script src="assets/js/bootstrap-colorpicker.min.js"></script>
<script src="assets/js/jquery.knob.min.js"></script>
<script src="assets/js/autosize.min.js"></script>
<script src="assets/js/jquery.inputlimiter.min.js"></script>
<script src="assets/js/jquery.maskedinput.min.js"></script>
<script src="assets/js/bootstrap-tag.min.js"></script>
<script src="assets/js/ace-elements.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
var counter = $("#count_items").val();
//alert (counter);
$("#addrow").on("click", function () {
var newRow = $("<tr>");
var cols = "";
cols += '<td><input type="text" class="form-control" id="cylinder_number' + counter + '" name="cylinder_number' + counter + '"/></td>';
cols += '<td><input type="text" class="form-control" id="size' + counter + '" name="size' + counter + '"/></td>';
cols += '<td><input type="text" class="form-control" id="location' + counter + '" name="location' + counter + '"/></td>';
cols += '<td><input type="text" class="form-control date-picker" data-date-format="dd/mm/yyyy" id="exp_date' + counter + '" name="exp_date' + counter + '"/></td>';
cols += '<td><input type="text" class="form-control" id="last_hydro_test' + counter + '" name="last_hydro_test' + counter + '"/></td>';
cols += '<td><input type="text" class="form-control" id="minutes_left' + counter + '" name="minutes_left' + counter + '"/></td>';
cols += '<td align="center"><a href="#" class="btn-lg" data-toggle="tooltip" id="deletebtn" title="Delete"><span class="glyphicon glyphicon-trash"></span></a></td>';
newRow.append(cols);
$("#myTable").append(newRow);
/*$('#item_id'+counter).chosen({allow_single_deselect:true});
$('#item_id'+counter).next().css({'width': $('#item_id'+counter).parent().width()});*/
counter++;
$('.select2').select2()
$("#count_items").val(counter);
$('.date-picker').datepicker({
autoclose: true,
todayHighlight: true
})
});
$("#myTable").on("click", "#deletebtn", function (event) {
$(this).closest("tr").remove();
counter -= 1
$("#count_items").val(counter);
});
});
</script>
<script type="text/javascript">
jQuery(function($) {
$('#id-disable-check').on('click', function() {
var inp = $('#form-input-readonly').get(0);
if(inp.hasAttribute('disabled')) {
inp.setAttribute('readonly' , 'true');
inp.removeAttribute('disabled');
inp.value="This text field is readonly!";
}
else {
inp.setAttribute('disabled' , 'disabled');
inp.removeAttribute('readonly');
inp.value="This text field is disabled!";
}
});
if(!ace.vars['touch']) {
$('.chosen-select').chosen({allow_single_deselect:true});
$(window)
.off('resize.chosen')
.on('resize.chosen', function() {
$('.chosen-select').each(function() {
var $this = $(this);
$this.next().css({'width': $this.parent().width()});
})
}).trigger('resize.chosen');
//resize chosen on sidebar collapse/expand
$(document).on('settings.ace.chosen', function(e, event_name, event_val) {
if(event_name != 'sidebar_collapsed') return;
$('.chosen-select').each(function() {
var $this = $(this);
$this.next().css({'width': $this.parent().width()});
})
});
$('#chosen-multiple-style .btn').on('click', function(e){
var target = $(this).find('input[type=radio]');
var which = parseInt(target.val());
if(which == 2) $('#form-field-select-4').addClass('tag-input-style');
else $('#form-field-select-4').removeClass('tag-input-style');
});
}
$('[data-rel=tooltip]').tooltip({container:'body'});
$('[data-rel=popover]').popover({container:'body'});
autosize($('textarea[class*=autosize]'));
$('textarea.limited').inputlimiter({
remText: '%n character%s remaining...',
limitText: 'max allowed : %n.'
});
//"jQuery UI Slider"
//range slider tooltip example
$( "#slider-range" ).css('height','200px').slider({
orientation: "vertical",
range: true,
min: 0,
max: 100,
values: [ 17, 67 ],
slide: function( event, ui ) {
var val = ui.values[$(ui.handle).index()-1] + "";
if( !ui.handle.firstChild ) {
$("<div class='tooltip right in' style='display:none;left:16px;top:-6px;'><div class='tooltip-arrow'></div><div class='tooltip-inner'></div></div>")
.prependTo(ui.handle);
}
$(ui.handle.firstChild).show().children().eq(1).text(val);
}
}).find('span.ui-slider-handle').on('blur', function(){
$(this.firstChild).hide();
});
$( "#slider-range-max" ).slider({
range: "max",
min: 1,
max: 10,
value: 2
});
$( "#slider-eq > span" ).css({width:'90%', 'float':'left', margin:'15px'}).each(function() {
// read initial values from markup and remove that
var value = parseInt( $( this ).text(), 10 );
$( this ).empty().slider({
value: value,
range: "min",
animate: true
});
});
$("#slider-eq > span.ui-slider-purple").slider('disable');//disable third item
$('#id-input-file-1 , #id-input-file-2').ace_file_input({
no_file:'No File ...',
btn_choose:'Choose',
btn_change:'Change',
droppable:false,
onchange:null,
thumbnail:false //| true | large
//whitelist:'gif|png|jpg|jpeg'
//blacklist:'exe|php'
//onchange:''
//
});
//pre-show a file name, for example a previously selected file
//$('#id-input-file-1').ace_file_input('show_file_list', ['myfile.txt'])
//datepicker plugin
//link
$('.date-picker').datepicker({
autoclose: true,
todayHighlight: true
})
//show datepicker when clicking on the icon
.next().on(ace.click_event, function(){
$(this).prev().focus();
});
//chosen plugin inside a modal will have a zero width because the select element is originally hidden
//and its width cannot be determined.
//so we set the width after modal is show
$('#modal-form').on('shown.bs.modal', function () {
if(!ace.vars['touch']) {
$(this).find('.chosen-container').each(function(){
$(this).find('a:first-child').css('width' , '210px');
$(this).find('.chosen-drop').css('width' , '210px');
$(this).find('.chosen-search input').css('width' , '200px');
});
}
})
/**
//or you can activate the chosen plugin after modal is shown
//this way select element becomes visible with dimensions and chosen works as expected
$('#modal-form').on('shown', function () {
$(this).find('.modal-chosen').chosen();
})
*/
$(document).one('ajaxloadstart.page', function(e) {
autosize.destroy('textarea[class*=autosize]')
$('.limiterBox,.autosizejs').remove();
$('.daterangepicker.dropdown-menu,.colorpicker.dropdown-menu,.bootstrap-datetimepicker-widget.dropdown-menu').remove();
});
});
</script>