ESH/work_area_sample_level.php

553 lines
20 KiB
PHP
Raw Permalink Normal View History

2024-10-23 18:28:06 +05:30
<?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">Hygiene</li><li class="active">Work Area Sample Level</li>
</ul>
</div>
<!-- End of breadcrumb -->
<div class="page-content">
<div id="flexigridDiv" class="table-responsive">
<div id="flexigridDiv" class="well-sm table-responsive" style="margin-right: 5px;margin-left: 5px;height:auto; width:100%">
<form name="f1" method="post" id="flex_form_work_area_sample" action="">
<div id="flex1" style="width: 100%"></div>
<input type="hidden" name="flex_work_area_sample_id" id="flex_work_area_sample_id" />
</form>
</div>
</div>
</div>
</div>
<!-- /.page-content -->
</div>
</div>
<!-- /.main-content -->
<script type="text/javascript">
//alert("screen.height:"+screen.height+",navbar.heigh:"+$("#navbar").height()+",breadcrumbs.height:"+$(".breadcrumbs").height());
$(function() {
var w=screen.width*.90;
var h =0;
h =(window.innerHeight-($("#navbar").height()+$(".breadcrumbs").height()))*.75;
//alert(h);
$("#flex1").flexigrid({
url: 'work_area_sample_level_script.php',
dataType: 'json',
colModel : [
{display: 'Sr', name : 'count', width : w*.05, sortable : false, align: 'left'},
{display: 'Sample Date', name : 'sample_date', width : w*.1, sortable : true, align: 'left'},
{display: 'Sample Name', name : 'hyg_sample_id', width : w*.1, sortable : true,align: 'left'},
{display: 'Department ', name : 'department_ids ', width : w*.14, sortable : true,align: 'left'},
{display: 'Comments and Recommendation', name : 'commentsAndRecommendations ', width : w*.14, sortable : true, align: 'left'},
{display: 'Hygiene Parameter', name : 'hyg_sample_id ', width : w*.15,sortable : true, align: 'left'},
{display: 'Current Value', name : 'hyg_sample_id ', width : w*.1, sortable : true, align: 'left'},
{display: 'Reference Range', name : 'hyg_sample_id', width : w*.1, sortable : true,align: 'left'},
{display: '', name : 'link', width : w*.15, sortable : false, align: 'left'}
],
buttons : [
{name: 'Add', bclass: 'add', onpress : add},
{separator: true},
{name: 'PDF', bclass: 'print', onpress : pdf},
{separator: true},
{name: 'Excel', bclass: 'print_excel', onpress : excel},
{separator: true}
],
searchitems : [
{display: 'Hygiene Parameter', name : 'hygiene_parameter',isdefault: true},
{display: 'Sample Date(DD-MM-YYYY)', name : 'sample_date'},
{display: 'Sample', name : 'sample_name' },
{display: 'Department', name : 'sbu_name' },
{display: 'currnet Value', name : 'current_value'},
],
sortname: "sample_id",
sortorder: "asc",
usepager: true,//pagination
//title:"Employee OPD",
useRp: true,
rp: 50,//records per page
showTableToggleBtn: false,//toggle button for the whole table
resizable: true,
// width: w,
height: h,
singleSelect: true
});
});
function work_area_sample_level_pdf(Id){
window.open('work_area_sample_level_pdf.php?Id='+Id+'');
}
function pdf(){
window.open('pdf_work_area_sample.php');
}
function excel(){
window.location = 'excel_work_area_sample.php';
}
var item_id;
function deleteParameterRow(count){
item_id =$('#parameter_record_id'+count).val();
del_work_area_sample(item_id);
$('#hygieneParameterTableRow'+count).remove();
$("#parameterRow").val(count);
}
function del_work_area_sample(item_id){
$.ajax({
url : 'del_work_area_param.php',
type : "POST",
data:{'item_id':item_id},
success : function(data) {
if(data.indexOf("SUCCESS")!=-1){
}else{
//BootstrapDialog.alert('Error Deleting Employee Level Hygiene');
}
return;
},
error : function(data) {
//BootstrapDialog.alert('Error Deleting Employee Level Hygiene');
return;
}
});
}
function add(){
var currentDate = new Date();
var today = currentDate.getDate() + '/' + (currentDate.getMonth() + 1) + '/' + currentDate.getFullYear();
$("#sampleDate").val(today);
$("#department").val("");
$('#department').trigger('chosen:updated');
$("#sample").val("");
$("#sample").trigger("chosen:updated");
$("#parameterRow").val("0");
$('#commentsAndRecommendations').val("");
$("#hygieneParameterTable").find("tr:gt(0)").remove();
var tbl = document.getElementById("hygieneParameterTable");
var optionContent='<?php
$query = "select * from hygiene ";
$result = @mysqli_query($conn,$query );
while ( $rows_hygiene = mysqli_fetch_array ( $result ) ) {
$hygieneParameter = getTableFieldValue ( 'hygiene', 'hygiene_parameter', 'hygiene_id', $rows_hygiene ['hygiene_id'] );
?> <option value="<?php echo $rows_hygiene['hygiene_id']?>"><?php echo $hygieneParameter.' ('.$rows_hygiene['human_min_range'].'-'.$rows_hygiene['human_max_range'].') '?></option><?php
}
?>'
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var count =parseInt($("#parameterRow").val());
var content=" <td>"+(count+1)+"</td><td><select class=\"chosen-select form-control\" name=\"hygieneParameter"+count+"\" data-placeholder=\"Select Hygiene Parameter\" "
+" id=\"hygieneParameter"+count+"\" autofocus=\"autofocus\" required><option></option>"
+ optionContent+" </select></td> <td> <input type=\"text\" class=\"form-control\" "
+" style=\"height:30px\" name=\"currentValue"+count+"\" id=\"currentValue"+count+"\" placeholder=\"Current Value\" required /></td>"
+"<td></td>"
$(newRow).append(content);
$(newRow).attr("id", "hygieneParameterTableRow" + count);
$(newRow).attr("class", "active");
$('#hygieneParameter'+count).chosen({allow_single_deselect:true});
$('#hygieneParameter'+count).next().css({'width': '100%'});
$("#parameterRow").val(++count);
$(".save_button").show();
$('#modal-add-work-area-sample').modal("show");
}
function addRowForHygieneParameter(){
//
//$("#hygieneParameterTable").find("tr:gt(0)").remove();
/*
if(tbl.rows.length>2){
for(var i=2;i<tbl.rows.length;i++)
myTable.deleteRow(i);
}*/
var tbl = document.getElementById("hygieneParameterTable");
var optionContent='<?php
$query = "select * from hygiene ";
$result = @mysqli_query($conn,$query );
while ( $rows_hygiene = mysqli_fetch_array ( $result ) ) {
$hygieneParameter = getTableFieldValue ( 'hygiene', 'hygiene_parameter', 'hygiene_id', $rows_hygiene ['hygiene_id'] );
?> <option value="<?php echo $rows_hygiene['hygiene_id']?>"><?php echo $hygieneParameter.' ('.$rows_hygiene['human_min_range'].'-'.$rows_hygiene['human_max_range'].') '?></option><?php
}
?>'
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var count =parseInt($("#parameterRow").val());
var content=" <td>"+(count+1)+"</td><td><select class=\"chosen-select form-control\" name=\"hygieneParameter"+count+"\" data-placeholder=\"Select Hygiene Parameter\" "
+" id=\"hygieneParameter"+count+"\" autofocus=\"autofocus\" required><option></option>"
+ optionContent+" </select></td> <td> <input type=\"text\" class=\"form-control\" "
+" style=\"height:30px\" name=\"currentValue"+count+"\" id=\"currentValue"+count+"\" placeholder=\"Current Value\" required /></td>"
+"<td><a href=\"#\" onclick=\"deleteParameterRow("+count+")\"><i class=\"ace-icon fa fa-trash-o bigger-130\"></i></a></td>"
$(newRow).append(content);
$(newRow).attr("id", "hygieneParameterTableRow" + count);
$('#hygieneParameter'+count).chosen({allow_single_deselect:true});
$('#hygieneParameter'+count).next().css({'width': '100%'});
$("#parameterRow").val(++count);
}
function delete_work_area_sample(sampleId){
$("#flex_work_area_sample_id").val(sampleId);
BootstrapDialog.confirm('Are you sure to delete the Hygiene?', function(result){
if(result) {
$.ajax({
url : 'delete_work_area_sample.php',
type : "POST",
data : $("#flex_form_work_area_sample").serialize(),
success : function(data) {
if(data.indexOf("SUCCESS")!=-1){
BootstrapDialog.alert('Hygiene Deleted Successfully.');
$("#flex1").flexReload();
}else{
BootstrapDialog.alert('Error Deleting Hygiene');
}
return;
},
error : function(data) {
BootstrapDialog.alert('Error Deleting Hygiene');
return;
}
});
}
});
}
var sample_id = "";
function open_work_area_sample(sampleId, action) {
var id = "";
if(action=="V"){
$(".save_button").hide();
}else{
$(".save_button").show();
}
$.ajax({
url : 'select_work_area_sample.php?sampleId='+sampleId+' ',
type : 'POST',
success : function(data) {
//alert(data);
data = $.parseJSON(data);
//alert(data);
$("#sample_id").val(data.sample_id);
$("#sampleDate").val(myDateFormater1(data.sample_date));
$("#department").val('');
$("#sample").val(data.hyg_sample_id);
$('#commentsAndRecommendations').val(data.commentsAndRecommendations);
$("#hygieneParameterTable").find("tr:gt(0)").remove();
$("#parameterRow").val(0);
if(data.department_ids!=null){
var department_ids = data.department_ids;
dataarray=department_ids.split(",");
$("#department").val(dataarray);
}
$("#department").trigger("chosen:updated");
$("#sample").trigger("chosen:updated");
var content="";
var tbl = document.getElementById("hygieneParameterTable");
$("#parameterRow").val(0);
var optionContent='<?php
$query = "select * from hygiene ";
$result = @mysqli_query($conn,$query );
while ( $rows_hygiene = mysqli_fetch_array ( $result ) ) {
$hygieneParameter = getTableFieldValue ( 'hygiene', 'hygiene_parameter', 'hygiene_id', $rows_hygiene ['hygiene_id'] );
?> <option value="<?php echo $rows_hygiene['hygiene_id']?>"><?php echo $hygieneParameter.' ('.$rows_hygiene['human_min_range'].'-'.$rows_hygiene['human_max_range'].') '?></option><?php
}
?>'
for(var i=0;i<data.parameter.length;i++){
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var count =parseInt($("#parameterRow").val());
content=" <td>"+(count+1)+"</td><td><input type=\"hidden\" name=\"parameter_record_id"+count+"\" id=\"parameter_record_id"+count+"\" value="+data.parameter[i].id+"><select class=\"chosen-select form-control\" name=\"hygieneParameter"+count+"\" data-placeholder=\"Select Hygiene Parameter\" "
+" id=\"hygieneParameter"+count+"\" autofocus=\"autofocus\" required><option></option>"
+ optionContent+" </select></td> <td> <input type=\"text\" class=\"form-control\" "
+" style=\"height:30px\" name=\"currentValue"+count+"\" id=\"currentValue"+count+"\" value="+data.parameter[i].hyg_param_val+" /></td>"
if(count>0)
content+="<td><a href=\"#\" onclick=\"deleteParameterRow("+count+")\"><i class=\"ace-icon fa fa-trash-o bigger-130\"></i></a></td>"
else
content+="<td></td>"
$(newRow).append(content);
$(newRow).attr("id", "hygieneParameterTableRow" + count);
$('#hygieneParameter'+count).chosen({allow_single_deselect:true});
$('#hygieneParameter'+count).next().css({'width': '100%'});
$('#hygieneParameter'+count).val(data.parameter[i].hyg_parameter_id);
$('#hygieneParameter'+count).trigger("chosen:updated")
$("#parameterRow").val(++count);
}
$('#modal-add-work-area-sample').modal("show");
},
error : function(data) {
BootstrapDialog.alert('Error Populating Hygiene');
return;
}
});
}
function myDateFormater1(myDate){
var d=new Date(myDate);
var m=d.getMonth()+1;
var y=d.getFullYear();
var date=d.getDate();
var hours = d.getHours();
var minutes = d.getMinutes();
var ampm = hours >= 12 ? 'pm' : 'am';
hours = hours % 12;
hours = hours ? hours : 12; // the hour '0' should be '12'
minutes = minutes < 10 ? '0'+minutes : minutes;
// alert(date+"/"+m+"/"+y);
return date+"/"+m+"/"+y+ " " + hours+ ":" + minutes+ " " + ampm;
}
var sample_id = "";
function view_work_area_sample(sampleId, action) {
$.ajax({
url : 'select_work_area_sample.php?sampleId='+sampleId+' ',
type : 'POST',
success : function(data) {
//alert(data);
data = $.parseJSON(data);
//alert(data);
$("#sample_id").val(data.sample_id);
var sampleDate = new Date(data.sample_date);
var date = sampleDate.getDate();
var month = sampleDate.getMonth() + 1; // Since getMonth() returns month from 0-11 not 1-12
var year = sampleDate.getFullYear();
var hour = sampleDate.getFullYear();
var hours = sampleDate.getHours();
var minutes = sampleDate.getMinutes();
var ampm = hours >= 12 ? 'pm' : 'am';
hours = hours % 12;
hours = hours ? hours : 12; // the hour '0' should be '12'
minutes = minutes < 10 ? '0'+minutes : minutes;
var dateStr = date + "/" + month + "/" + year+ " " + hours+ ":" + minutes+ " " + ampm;
$("#sampleDate1").text(dateStr);
$("#department1").text(data.sbu_name);
$("#sample1").text(data.sample_name);
$('#commentsAndRecommendations1').text(data.commentsAndRecommendations);
if(data.department_ids!=null){
var department_ids = data.department_ids;
dataarray=department_ids.split(",");
$("#department").val(dataarray);
}
$("#hygieneParameterTableview").find("tr:gt(0)").remove();
$("#parameterRow1").val(0);
var content="";
var tbl = document.getElementById("hygieneParameterTableview");
var optionContent='<?php
$query = "select * from hygiene ";
$result = @mysqli_query($conn,$query );
while ( $rows_hygiene = mysqli_fetch_array ( $result ) ) {
$hygieneParameter = getTableFieldValue ( 'hygiene', 'hygiene_parameter', 'hygiene_id', $rows_hygiene ['hygiene_id'] );
?> <option value="<?php echo $rows_hygiene['hygiene_id']?>"><?php echo $hygieneParameter.' ('.$rows_hygiene['human_min_range'].'-'.$rows_hygiene['human_max_range'].') '?></option><?php
}
?>'
for(var i=0;i<data.parameter.length;i++){
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var count =parseInt($("#parameterRow1").val());
content=" <td>"+(count+1)+"</td><td><input type=\"hidden\" name=\"parameter_record_id"+count+"\" id=\"parameter_record_id"+count+"\" value="+data.parameter[i].id+"><div name=\"hygieneParameter1"+count+"\" "
+" id=\"hygieneParameter1"+count+"\" >"+data.parameter[i].hygiene_parameter+"("+data.parameter[i].work_area_min_range+"-"+data.parameter[i].work_area_max_range+")"
+" </div></td> <td><div "
+" style=\"height:30px\" name=\"currentValue1"+count+"\" id=\"currentValue1"+count+"\" > "+data.parameter[i].hyg_param_val+" </div></td>"
/*
content=" <td>"+(count+1)+"</td><td><input type=\"hidden\" name=\"parameter_record_id"+count+"\" id=\"parameter_record_id"+count+"\" value="+data.parameter[i].id+"><div name=\"hygieneParameter"+count+"\" "
+" id=\"hygieneParameter"+count+"\" >"//+data.parameter[i].hygiene_parameter+""
+" </div></td> <td> <div "
+" style=\"height:30px\" name=\"currentValue"+count+"\" id=\"currentValue"+count+"\" >"+data.parameter[i].hyg_param_val+"</div></td>" */
$(newRow).append(content);
$(newRow).attr("id", "hygieneParameterTableRow" + count);
/*
$('#hygieneParameter'+count).chosen({allow_single_deselect:true});
$('#hygieneParameter'+count).next().css({'width': '100%'});
$('#hygieneParameter'+count).val(data.parameter[i].hyg_parameter_id);
$('#hygieneParameter'+count).trigger("chosen:updated")
*/
$("#parameterRow1").val(++count);
}
$('#modal-add-work-area-sample_view').modal("show");
},
error : function(data) {
BootstrapDialog.alert('Error Populating Hygiene');
return;
}
});
}
$('#sampleDate').datepicker({
autoclose:true,
format: 'dd/mm/yyyy',
startDate: '1d/1m/1970y',
}).next().on(ace.click_event, function(){
$(this).prev().focus();
});
</script>
<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>
<?php include('techsyn_footer.php'); ?>
<?php include('form/add_work_area_sample.php');?>
<?php include('form/view_work_area_sample.php');?>