485 lines
14 KiB
PHP
485 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'); ?>
|
|
|
|
|
|
|
|
|
|
<!--breadcrumb-->
|
|
<div class="main-content">
|
|
<div class="main-content-inner">
|
|
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
|
|
<ul class="breadcrumb">
|
|
|
|
<li class="#">Waste Management</li>
|
|
<li class="active">Bio Medical Waste Generation (OHC PLANT)</li>
|
|
</ul>
|
|
|
|
|
|
</div>
|
|
<!-- End of breadcrumb -->
|
|
|
|
<div class="page-content">
|
|
<div id="flexigridDiv" class="table-responsive">
|
|
|
|
<form name="f1" method="post" id="flex_appointment_form" action="">
|
|
<div id="flex1" style="width:100%">
|
|
</div>
|
|
<input type="hidden" name="flex_waste_id" id="flex_waste_id" />
|
|
|
|
</form>
|
|
|
|
<form name="export_form" method="post" id="export_form" action="">
|
|
|
|
<input type="hidden" name="pdf_actions" id="pdf_actions" value="bio_medical_waste_generation_pdf.php" />
|
|
<input type="hidden" name="excel_actions" id="excel_actions" value="bio_medical_waste_generation_excel.php" />
|
|
<input type="hidden" name="pdf_action" id="pdf_action" value="bio_medical_waste_plant_pdf.php" />
|
|
<input type="hidden" name="excel_action" id="excel_action" value="excel_bio_medical_waste.php" />
|
|
</form>
|
|
|
|
|
|
</div>
|
|
</div>
|
|
|
|
|
|
|
|
</div><!-- /.page-content -->
|
|
</div>
|
|
</div><!-- /.main-content -->
|
|
|
|
<?php
|
|
|
|
$sql = "select count(*) from bio_medical_waste_new WHERE approval_status != 'A'";
|
|
$result = mysqli_query($conn, $sql);
|
|
$row = mysqli_fetch_array($result);
|
|
$total = $row[0];
|
|
|
|
?>
|
|
|
|
|
|
<script type="text/javascript">
|
|
$(function() {
|
|
var w = screen.width * .90;
|
|
var h = 0;
|
|
h = (window.innerHeight - ($("#navbar").height() + $(".breadcrumbs").height())) * .75;
|
|
$("#flex1").flexigrid({
|
|
url: 'bio_medical_waste_list_script.php',
|
|
dataType: 'json',
|
|
colModel: [{
|
|
display: 'Bulk Approval',
|
|
name: 'checkbox',
|
|
width: w * .1,
|
|
sortable: false,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: '',
|
|
name: 'link',
|
|
width: w * .08,
|
|
sortable: false,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Sr',
|
|
name: 'count',
|
|
width: w * .05,
|
|
sortable: false,
|
|
align: 'left'
|
|
},
|
|
|
|
|
|
{
|
|
display: 'Collection Date',
|
|
name: 'waste_gen_date',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'Yellow (in gms)',
|
|
name: 'plant_yellow_qty',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'No. Of bags',
|
|
name: 'yellow_bags',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'Red (in gms)',
|
|
name: 'plant_red_qty',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'No. Of bags',
|
|
name: 'red_bags',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'Blue (in gms)',
|
|
name: 'plant_blue_qty',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'No. Of bags',
|
|
name: 'blue_bags',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'White (in gms)',
|
|
name: 'plant_white_qty',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'No. Of bags',
|
|
name: 'white_bags',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'collected by',
|
|
name: 'collected_by',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
{
|
|
display: 'vehicle no.',
|
|
name: 'vehicle_no',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
{
|
|
display: 'challan no.',
|
|
name: 'challan_no',
|
|
width: w * .12,
|
|
sortable: true,
|
|
align: 'left'
|
|
},
|
|
|
|
|
|
|
|
|
|
|
|
],
|
|
buttons: [
|
|
<?php
|
|
if ($total != 0) {
|
|
?> {
|
|
name: 'Approve',
|
|
bclass: '',
|
|
onpress: BulkApproval
|
|
},
|
|
{
|
|
separator: true
|
|
},
|
|
<?php } ?>
|
|
|
|
{
|
|
name: 'Add',
|
|
bclass: 'add',
|
|
onpress: add
|
|
},
|
|
{
|
|
separator: true
|
|
},
|
|
//{name: 'PDFReport', bclass: 'print', onpress : pdfReport},
|
|
// {separator: true},
|
|
{
|
|
name: 'PDF',
|
|
bclass: 'print',
|
|
onpress: pdf
|
|
},
|
|
{
|
|
separator: true
|
|
},
|
|
{
|
|
name: 'Excel',
|
|
bclass: 'print_excel',
|
|
onpress: excel
|
|
},
|
|
{
|
|
separator: true
|
|
}
|
|
],
|
|
searchitems: [
|
|
//{display: 'Appointment Id', name : 'appointment_id',isdefault: true},
|
|
|
|
|
|
{
|
|
display: 'Waste Generation Date (dd/mm/yyyy)',
|
|
name: 'waste_gen_date'
|
|
},
|
|
{
|
|
display: 'Waste Generation Date Between (dd/mm/yyyy-dd/mm/yyyy)',
|
|
name: 'waste_gen_date_between'
|
|
},
|
|
|
|
//{display: 'Is Disposed(Yes/No)', name : 'isDisposed'},
|
|
//{display: 'Comments', name : 'comments'},
|
|
|
|
//{display: 'Disposal Comments', name : 'disposal_comments'},
|
|
|
|
|
|
],
|
|
sortname: "waste_gen_date",
|
|
sortorder: "desc",
|
|
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
|
|
});
|
|
|
|
$("td[abbr~='plant_yellow_qty']").children("div").css('color', 'yellow');
|
|
$("th[abbr~='plant_yellow_qty']").css('background-color', 'yellow');
|
|
$("th[abbr~='plant_blue_qty']").css('background-color', '#3C8DBC');
|
|
$("th[abbr~='plant_red_qty']").css('background-color', 'red');
|
|
$("th[abbr~='yellow_bags']").css('background-color', 'yellow');
|
|
$("th[abbr~='blue_bags']").css('background-color', '#3C8DBC');
|
|
$("th[abbr~='red_bags']").css('background-color', 'red');
|
|
// $( "th[abbr^='plant_white_qty']" ).css('background-color', '#fff');
|
|
//$( "th[abbr^='mines_white_qty']" ).css('background-color', '#fff');
|
|
//$( "th[abbr^='white_qty_total']" ).css('background-color', '#fff');
|
|
|
|
});
|
|
|
|
function add() {
|
|
|
|
location.href = "bio_medical_new_form.php";
|
|
|
|
}
|
|
|
|
|
|
var Idss = [];
|
|
|
|
function DataPass(count, id) {
|
|
const isChecked = $("#bulk_" + count).is(":checked");
|
|
|
|
var id = $("#bulk_" + count).val();
|
|
|
|
if (isChecked) {
|
|
Idss.push(id);
|
|
} else {
|
|
var removeValue = id;
|
|
Idss = $.grep(Idss, function(n) {
|
|
return n != removeValue;
|
|
});
|
|
}
|
|
|
|
|
|
$("#waste_id_bulk").val(Idss);
|
|
|
|
// $.ajax({
|
|
// url: 'bulkapprovebiowaste.php',
|
|
// data: {id : Idss},
|
|
// success (result) {
|
|
// $("#flex1").flexReload();
|
|
// return;
|
|
// }
|
|
// });
|
|
|
|
// console.log(Idss);
|
|
|
|
}
|
|
|
|
function BulkApproval() {
|
|
var Idss = $("#waste_id_bulk").val();
|
|
console.log(jQuery.type(Idss));
|
|
var trainindIdArray = Idss.split(',');
|
|
$.ajax({
|
|
url: 'bulkapprovebiowaste.php',
|
|
data: {
|
|
id: trainindIdArray
|
|
},
|
|
success(result) {
|
|
console.log(result);
|
|
$("#flex1").flexReload();
|
|
BootstrapDialog.alert('BULk APPROVE Successfully');
|
|
}
|
|
});
|
|
|
|
console.log(Idss);
|
|
}
|
|
|
|
|
|
|
|
function save_bio_medical_waste() {
|
|
|
|
$.ajax({
|
|
url: 'save_bio_medical_wastage.php',
|
|
type: "POST",
|
|
data: $("#bio_medical_waste_form").serialize(),
|
|
success: function(data) {
|
|
BootstrapDialog.alert('Bio Medical Waste Record Saved Successfully.');
|
|
$("#flex1").flexReload();
|
|
return;
|
|
},
|
|
error: function(data) {
|
|
BootstrapDialog.alert('Error Saving Bio Medical Waste Record');
|
|
return;
|
|
}
|
|
});
|
|
$('.close').click();
|
|
|
|
|
|
}
|
|
|
|
function delete_medical_waste_generation_form(waste_id) {
|
|
|
|
$.ajax({
|
|
url: 'delete_medical_waste_generation.php',
|
|
data: {
|
|
waste_id: waste_id
|
|
},
|
|
type: 'POST',
|
|
dataType: 'json',
|
|
success: function(data) {
|
|
|
|
if (data == 'SUCCESS') {
|
|
|
|
BootstrapDialog.alert('Delelet Bio Medical Waste Generation Successfully');
|
|
$("#flex1").flexReload();
|
|
return;
|
|
}
|
|
|
|
|
|
|
|
|
|
},
|
|
error: function(data) {
|
|
BootstrapDialog.alert('Error Deleleting Bio Medical Waste Generation');
|
|
return;
|
|
}
|
|
});
|
|
|
|
}
|
|
|
|
function open_bio_waste(flex_waste_id, action) {
|
|
if (action == "V") {
|
|
$("#flex_waste_id").val(flex_waste_id);
|
|
$("#flex_appointment_form").attr('method', 'POST');
|
|
$("#flex_appointment_form").attr('action', 'view_bio_medical_waste_new.php');
|
|
$("#flex_appointment_form").submit();
|
|
} else {
|
|
$("#flex_waste_id").val(flex_waste_id);
|
|
$("#flex_appointment_form").attr('method', 'POST');
|
|
$("#flex_appointment_form").attr('action', 'edit_bio_medical_form_new.php');
|
|
$("#flex_appointment_form").submit();
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
function open_bio_medical_waste_generation_form(waste_id, access) {
|
|
if (access == 'V') {
|
|
$("#save_button").hide()
|
|
} else if (access == 'E')
|
|
$("#save_button").show()
|
|
|
|
$.ajax({
|
|
url: 'select_bio_medical_waste_generation.php',
|
|
data: {
|
|
waste_id: waste_id
|
|
},
|
|
type: 'POST',
|
|
dataType: 'json',
|
|
success: function(data) {
|
|
$("#waste_generation_date").val(myDateFormat(data.waste_gen_date));
|
|
$("#forward_date").val(myDateFormat(data.forward_date));
|
|
$("#waste_category").val(data.waste_category);
|
|
$('#waste_category').trigger('chosen:updated');
|
|
$("#waste_qty").val(data.qty);
|
|
$("#waste_comments").val(data.comments);
|
|
$("#is_disposed").val(data.isDisposed);
|
|
$('#is_disposed').trigger('chosen:updated');
|
|
$("#disposal_comments").val(data.disposal_comments);
|
|
// $("#forward_date").val(data.forward_date)
|
|
$("#forward_status").val(data.forward_status);
|
|
$('#forward_status').trigger('chosen:updated');
|
|
$("#waste_id").val(data.waste_id);
|
|
|
|
|
|
|
|
|
|
$('#modal-add-bio-medical-waste-form').modal("show");
|
|
|
|
},
|
|
error: function(data) {
|
|
BootstrapDialog.alert('Error Populating Medicine Details');
|
|
return;
|
|
}
|
|
});
|
|
|
|
|
|
|
|
}
|
|
|
|
function pdfReport() {
|
|
window.open('ajax_pdf.php', 'Bio Medical Waste List');
|
|
|
|
|
|
}
|
|
|
|
function pdf() {
|
|
window.open('ajax_pdf.php', 'Bio Medical Waste List');
|
|
}
|
|
|
|
function excel() {
|
|
window.open('ajax_excel.php', 'Bio Medical Waste List');
|
|
}
|
|
|
|
function excel() {
|
|
window.open('ajax_excel.php', 'Bio Medical Waste List');
|
|
}
|
|
|
|
function myDateFormat(date) {
|
|
|
|
var d = new Date(date);
|
|
var day = d.getDate();
|
|
var m = d.getMonth() + 1;
|
|
var y = d.getFullYear();
|
|
|
|
|
|
return day + "-" + m + "-" + y;
|
|
|
|
|
|
}
|
|
</script>
|
|
|
|
<input type="hidden" name="waste_id_bulk" id="waste_id_bulk">
|
|
|
|
<?php include('techsyn_footer.php'); ?>
|
|
<?php include('form/bio_medical_waste_form.php'); ?>
|