452 lines
18 KiB
PHP
452 lines
18 KiB
PHP
|
<script src="https://code.jquery.com/jquery-3.6.4.js" integrity="sha256-a9jBBRygX1Bh5lt8GZjXDzyOB+bWve9EiO7tROUtj/E="
|
||
|
|
crossorigin="anonymous"></script>
|
||
|
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
include('pdf_header_reverse.php');
|
||
|
|
?>
|
||
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
||
|
|
<style>
|
||
|
|
@page {
|
||
|
|
margin: 15px;
|
||
|
|
}
|
||
|
|
|
||
|
|
.btn {
|
||
|
|
background-color: #4CAF50;
|
||
|
|
border-radius: 5%;
|
||
|
|
/* Green */
|
||
|
|
border: none;
|
||
|
|
color: white;
|
||
|
|
padding: 5px 8px;
|
||
|
|
text-align: center;
|
||
|
|
text-decoration: none;
|
||
|
|
display: inline-block;
|
||
|
|
font-size: 12px;
|
||
|
|
margin: 4px 2px;
|
||
|
|
cursor: pointer;
|
||
|
|
}
|
||
|
|
|
||
|
|
@media print {
|
||
|
|
#printPageButton {
|
||
|
|
display: none;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
#myTable td {
|
||
|
|
border: groove;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
|
||
|
|
<?php include('pdf_ohc_header.php') ?>
|
||
|
|
<!-- ------------------------- -->
|
||
|
|
<?php
|
||
|
|
$cat = $_POST["inventory_cat"];
|
||
|
|
$shift = $_POST["shift"];
|
||
|
|
error_log("PARA::" . $cat);
|
||
|
|
if ($_POST["inventory_cat"] != 'AMB_CHECK') {
|
||
|
|
$type = $_POST["inventory_type"];
|
||
|
|
} else {
|
||
|
|
$type = $_POST["inventory_type2"];
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$db_new_date = "";
|
||
|
|
$last_day = "";
|
||
|
|
$m = 0;
|
||
|
|
$y = 0;
|
||
|
|
$selectedParamMonth = $_REQUEST['param_month'];
|
||
|
|
// echo "month......"+$selectedShiftMonth;
|
||
|
|
$selectedParamYear = $_POST['param_year'];
|
||
|
|
//echo "year.........".$selectedShiftYear;
|
||
|
|
if (isset($selectedParamYear) && $selectedParamYear != "" && isset($selectedParamMonth) && $selectedParamMonth != "") {
|
||
|
|
$last_day = date("t-m-Y", strtotime("" . $selectedParamYear . "-" . ($selectedParamMonth + 1) . "-01"));
|
||
|
|
} else {
|
||
|
|
$last_day = date('t-m-Y');
|
||
|
|
//echo "last:date1".$last_day;
|
||
|
|
}
|
||
|
|
$m = date('m', strtotime("" . $selectedParamYear . "-" . ($selectedParamMonth + 1) . "-01"));
|
||
|
|
////echo "month det".$m;
|
||
|
|
$y = date('Y', strtotime("" . $selectedParamYear . "-" . ($selectedParamMonth + 1) . "-01"));
|
||
|
|
//echo "year det".$y;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
<script>
|
||
|
|
var jsonArrayParamData = <?php echo json_encode($param_data); ?>;
|
||
|
|
</script>
|
||
|
|
|
||
|
|
|
||
|
|
<style>
|
||
|
|
#modal-add-ailment {
|
||
|
|
overflow-y: scroll;
|
||
|
|
}
|
||
|
|
|
||
|
|
#myTable thead td {
|
||
|
|
|
||
|
|
font-size: 12px;
|
||
|
|
font-weight: bold;
|
||
|
|
}
|
||
|
|
|
||
|
|
#myTable td {
|
||
|
|
|
||
|
|
height: 50px;
|
||
|
|
border: groove;
|
||
|
|
text-align: center;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
<table width="100%">
|
||
|
|
<td>
|
||
|
|
<h1 style="text-align:center;"><?php
|
||
|
|
$issue_type=$_POST["issue_type"];
|
||
|
|
$amb_id = $_REQUEST['amb_idd'];
|
||
|
|
if ($cat == 'INVENTORY') {
|
||
|
|
echo "INVENTORY " . $type;
|
||
|
|
} else {
|
||
|
|
if($issue_type=='AMB'){
|
||
|
|
echo getTableFieldValue('ambulance_details_new', "CONCAT(ambulance_name , ' ( ' , ambulance_number ,' )' )", 'id', $amb_id);}
|
||
|
|
else{
|
||
|
|
echo getTableFieldValue('ohc_type', "CONCAT(ohc_type_name)", 'ohc_type_id', $amb_id);
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$shift_name=getTableFieldValue('shift_status', "status_name", 'shift_status_id', $shift);
|
||
|
|
echo '('.$shift_name.' Shift)';
|
||
|
|
?>- <span style="color:crimson; ">
|
||
|
|
<?= date("F", mktime(0, 0, 0, $m, 10)); ?> ( <?= $y ?> )
|
||
|
|
</h1>
|
||
|
|
</td>
|
||
|
|
<td>
|
||
|
|
<button align="center" id="printPageButton" class="btn btn-success" onClick="window.print();">Print</button>
|
||
|
|
</td>
|
||
|
|
</table>
|
||
|
|
<table width="100%" style="margin-top: 30px; border: groove;" id="myTable" class="">
|
||
|
|
<thead>
|
||
|
|
<tr>
|
||
|
|
<td></td>
|
||
|
|
<td>Date</td>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
for ($j = 1; $j <= $last_day; $j++) {
|
||
|
|
$new_date = $j . "-" . $m . "-" . $y;
|
||
|
|
$day = date('D', strtotime($new_date));
|
||
|
|
?>
|
||
|
|
<td><?php echo $j ?></td>
|
||
|
|
|
||
|
|
<?php } ?>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td>Sr. No.</td>
|
||
|
|
<td>Description</td>
|
||
|
|
<?php
|
||
|
|
// $last_day = date('t-m-Y');
|
||
|
|
// $m = date('m');
|
||
|
|
// $y = date('Y');
|
||
|
|
for ($k = 1; $k <= $last_day; $k++) {
|
||
|
|
$new_date = $k . "-" . $m . "-" . $y;
|
||
|
|
$day = date('D', strtotime($new_date));
|
||
|
|
?>
|
||
|
|
|
||
|
|
<td><?php echo $day ?></td>
|
||
|
|
|
||
|
|
|
||
|
|
<?php } ?>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
</thead>
|
||
|
|
|
||
|
|
<tbody>
|
||
|
|
<?php $count = 1;
|
||
|
|
$items_array = array();
|
||
|
|
$item = array();
|
||
|
|
$sub_count = 1;
|
||
|
|
$cat = $_POST["inventory_cat"];
|
||
|
|
if ($_POST["inventory_cat"] != 'AMB_CHECK') {
|
||
|
|
$type = $_POST["inventory_type"];
|
||
|
|
} else {
|
||
|
|
$type = $_POST["inventory_type2"];
|
||
|
|
}
|
||
|
|
$item_cat=$_POST["inventory_item_type2"];
|
||
|
|
$item_cat_query='';
|
||
|
|
if($item_cat=="" || $item_cat=='ALL'||$item_cat==null ){$item_cat_query='';}
|
||
|
|
else if($item_cat=="comm"){$item_cat_query='and item_type="'.$item_cat.'"';}
|
||
|
|
else{
|
||
|
|
|
||
|
|
$item_cat_query='and item_type="item" and item_id in (select item_id from tbl_items where cat="'.$item_cat.'") ';
|
||
|
|
}
|
||
|
|
|
||
|
|
error_log("type " . $amb_id);
|
||
|
|
$ohc = "SELECT ohc_type_id from ohc_type where ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ";
|
||
|
|
error_log("PARAMS1111111::" . $ohc);
|
||
|
|
$results_ohc = mysqli_query($conn, $ohc);
|
||
|
|
$row_ohc = mysqli_fetch_array($results_ohc);
|
||
|
|
error_log("ohc Id" . $row_ohc['ohc_type_id']);
|
||
|
|
$i = 1;
|
||
|
|
$query = "SELECT ambulance_issue_master_id from ambulance_issue_master where ohc_type_id = '" . $row_ohc['ohc_type_id'] . "' AND ambulance_id = '$amb_id' AND issue_type='$issue_type' ";
|
||
|
|
error_log("PARAMS::" . $query);
|
||
|
|
$result = @mysqli_query($conn, $query);
|
||
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
||
|
|
|
||
|
|
|
||
|
|
$item_desc = "";
|
||
|
|
$stock_issue_item_id = "SELECT a.* from ambulance_checklist_item a WHERE a.ambulance_issue_master_id ='" . $row['ambulance_issue_master_id'] . "' $item_cat_query";
|
||
|
|
error_log($stock_issue_item_id);
|
||
|
|
$results_issue_item_id = mysqli_query($conn, $stock_issue_item_id);
|
||
|
|
while ($row_issue_item_id = mysqli_fetch_assoc($results_issue_item_id)) {
|
||
|
|
|
||
|
|
$item_desc = "";
|
||
|
|
$sql_issue_items = "SELECT a.* from ambulance_checklist_item a WHERE a.id='" .$row_issue_item_id["id"]."' and a.ambulance_issue_master_id ='" . $row['ambulance_issue_master_id'] . "' $item_cat_query";
|
||
|
|
|
||
|
|
$results_issue_items = mysqli_query($conn, $sql_issue_items);
|
||
|
|
while ($row_issue_items = mysqli_fetch_assoc($results_issue_items)) {
|
||
|
|
array_push($items_array, $row_issue_items);
|
||
|
|
array_push($item, $row_issue_items['item_id'].'$'.$row_issue_items['item_type']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$item = array_unique($item);
|
||
|
|
|
||
|
|
// error_log('item_arr' . print_r($items_array, true));
|
||
|
|
sort($item);
|
||
|
|
$row_issue_qty = array();
|
||
|
|
for ($i = 0; $i < count($item); $i++) {
|
||
|
|
$qty = 0;
|
||
|
|
for ($j = 0; $j < count($items_array); $j++) {
|
||
|
|
|
||
|
|
if ($item[$i] == $items_array[$j]['item_id'].'$'.$items_array[$j]['item_type']) {
|
||
|
|
$qty += $items_array[$j]['issue_qty'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
error_log($item[$i] . '--' . $qty);
|
||
|
|
|
||
|
|
array_push($row_issue_qty, $qty);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$row_issue_items['item_id'] = $item;
|
||
|
|
$row_issue_items['issue_qty'] = $row_issue_qty;
|
||
|
|
|
||
|
|
for ($x = 0; $x < count($row_issue_items['item_id']); $x++) {
|
||
|
|
|
||
|
|
$item_desc = '';
|
||
|
|
$itemWithType=explode('$',$row_issue_items['item_id'][$x]);
|
||
|
|
$row_issue_items['item_id'][$x]=$itemWithType[0];
|
||
|
|
$row_issue_items['item_type'][$x]=$itemWithType[1];
|
||
|
|
if($row_issue_items['item_type'][$x]=='item'){
|
||
|
|
|
||
|
|
|
||
|
|
$item_desc = $item_desc . ' <p> ' . getItemWithFormName($row_issue_items['item_id'][$x]) . " ";
|
||
|
|
|
||
|
|
$item_unit_id = getTableFieldValue('tbl_items', 'unit_id', 'item_id', $row_issue_items['item_id'][$x]);
|
||
|
|
$item_unit = getTableFieldValue('unit_master', 'unit_name', 'unit_id', $item_unit_id);
|
||
|
|
|
||
|
|
error_log("Userid " . $row_issue_items['item_type'][$x]);
|
||
|
|
if ($row_issue_items['issue_qty'][$x] != 0) {
|
||
|
|
|
||
|
|
$item_desc = $item_desc . '<b> Qty: ' . $row_issue_items['issue_qty'][$x] . ' ' . $item_unit . '</b>';
|
||
|
|
}
|
||
|
|
$item_desc = $item_desc . "</p>";
|
||
|
|
}else{
|
||
|
|
$item_desc = $item_desc.' <p> '.getTableFieldValue('questionaire_master','question','question_id',$row_issue_items['item_id'][$x]);
|
||
|
|
$item_desc=$item_desc."</p>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<tr>
|
||
|
|
<td><?php echo $sub_count;
|
||
|
|
$sub_count++; ?></td>
|
||
|
|
<td><?php echo $item_desc; ?></td>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<input type="hidden" name="param_id<?php echo $i ?>" id="param_id<?php echo $i ?>"
|
||
|
|
value="<?php echo $row_issue_items['item_id'][$x].'$'.$row_issue_items['item_type'][$x]; ?>" />
|
||
|
|
<?php $status_id = "";
|
||
|
|
$param_data = array();
|
||
|
|
$query1 = "SELECT * from inventory_parameters_status where month(param_date)='" . $m . "' and year(param_date)='" . $y . "' and shift='$shift' ";
|
||
|
|
error_log("PARAMETER QUERY." . $query1);
|
||
|
|
|
||
|
|
$result1 = @mysqli_query($conn, $query1);
|
||
|
|
$remark = array();
|
||
|
|
while ($row_param = @mysqli_fetch_assoc($result1)) {
|
||
|
|
|
||
|
|
|
||
|
|
$status_id = $row_param['status_id'];
|
||
|
|
$key = $row_param['param_id'] . '_' . $row_param['param_date'];
|
||
|
|
|
||
|
|
$value = $row_param['param_status'];
|
||
|
|
|
||
|
|
$remark += array(
|
||
|
|
$key => $row_param['param_remark'],
|
||
|
|
);
|
||
|
|
|
||
|
|
// error_log(" REMARK " . print_r($remark, true));
|
||
|
|
$param_data[$key] = $value;
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
<input type="hidden" name="status_id<?php echo $i ?>" id="status_id<?php echo $i ?>"
|
||
|
|
value="<?php echo $status_id ?>" />
|
||
|
|
<?php } ?>
|
||
|
|
<?php
|
||
|
|
// error_log(" REAMM " . print_r($remark, true));
|
||
|
|
$db_new_date = "";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$mm = 0;
|
||
|
|
|
||
|
|
for ($k = 1; $k <= $last_day; $k++) {
|
||
|
|
$new_date = $k . "-" . $m . "-" . $y;
|
||
|
|
$db_new_date = $y . "-" . $m . "-" . $k;
|
||
|
|
$day = date('D', strtotime($new_date));
|
||
|
|
if ($k < 10) {
|
||
|
|
$db_new_date = $y . "-" . $m . "-0" . $k;
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
<td>
|
||
|
|
<div style="width:80px;">
|
||
|
|
<input type="checkbox" class="<?php echo date('Y-m-d', strtotime($new_date)) ?>"
|
||
|
|
style="margin-left:20px;max-width:50%;" id="param_status_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
name="param_status_<?php echo $i ?>_<?php echo $k ?>[]"
|
||
|
|
onchange="save_params(<?php echo $i ?>,<?php echo $k ?>)" />
|
||
|
|
|
||
|
|
<br>
|
||
|
|
<input type="text" name="param_remark_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
id="param_remark_<?php echo $i ?>_<?php echo $k ?>" onchange=""
|
||
|
|
style="margin-left:5px;max-width:90%;" placeholder="Remarks">
|
||
|
|
|
||
|
|
<script>
|
||
|
|
$(document).ready(function() {
|
||
|
|
<?php $key = $row_issue_items['item_id'][$x].'$'.$row_issue_items['item_type'][$x] . '_' . $db_new_date; ?>
|
||
|
|
var existingParamValues<?php echo $i ?>_<?php echo $k ?> =
|
||
|
|
"<?php echo $param_data[$key] ?>"
|
||
|
|
document.getElementById(
|
||
|
|
"param_status_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
).value =
|
||
|
|
existingParamValues<?php echo $i ?>_<?php echo $k ?>;
|
||
|
|
|
||
|
|
if (document.getElementById(
|
||
|
|
"param_status_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
).value == "1" || document.getElementById(
|
||
|
|
"param_status_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
).value == "on") {
|
||
|
|
document.getElementById(
|
||
|
|
"param_status_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
).checked = true;
|
||
|
|
document.getElementById(
|
||
|
|
"param_remark_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
).value = "<?php
|
||
|
|
echo $remark[$key]; ?>";
|
||
|
|
}
|
||
|
|
|
||
|
|
});
|
||
|
|
</script>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
</td>
|
||
|
|
<input type="hidden" name="param_date_<?php echo $i ?>_<?php echo $k ?>"
|
||
|
|
id="param_date_<?php echo $i ?>_<?php echo $k ?>" value="<?php echo $new_date ?>" />
|
||
|
|
|
||
|
|
<?php } ?>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$count++;
|
||
|
|
|
||
|
|
$i++;
|
||
|
|
};
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</tbody>
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<br><br>
|
||
|
|
<br><br>
|
||
|
|
|
||
|
|
<?php $query_app = "select e.emp_sign,e.image_type from employee_signature e left join tbl_users u on u.emp_id=e.emp_id left join inventory_checklist_status c on u.user_id=c.approver_user_id where c.status_id ='" . $_REQUEST['status_id'] . "'";
|
||
|
|
error_log("app Signatures :" . $query_app);
|
||
|
|
|
||
|
|
$result_app = mysqli_query($conn, $query_app);
|
||
|
|
|
||
|
|
$app_sign_row = mysqli_fetch_array($result_app);
|
||
|
|
|
||
|
|
extract($app_sign_row);
|
||
|
|
|
||
|
|
|
||
|
|
$query_ck = "select e.emp_sign,e.image_type from employee_signature e left join tbl_users u on u.emp_id=e.emp_id left join inventory_checklist_status c on u.user_id=c.checker_user_id where c.status_id ='" . $_REQUEST['status_id'] . "'";
|
||
|
|
error_log("ch Signatures :" . $query_ck);
|
||
|
|
|
||
|
|
$result_ck = mysqli_query($conn, $query_ck);
|
||
|
|
|
||
|
|
$ck_sign_row = mysqli_fetch_array($result_ck);
|
||
|
|
|
||
|
|
extract($ck_sign_row);
|
||
|
|
?>
|
||
|
|
|
||
|
|
<div class="row">
|
||
|
|
<div style="width: 100%;" class="leftailgn">
|
||
|
|
<?php if($ck_sign_row['emp_sign']!='' || $ck_sign_row['emp_sign']!=null){ ?>
|
||
|
|
<img id='sign' align="left" style="text-align:center; width:150px; height:80px;" class="card-img-bottm"
|
||
|
|
src="data:<?= $ck_sign_row['image_type']; ?>;base64,<?= base64_encode($ck_sign_row['emp_sign']) ?>">
|
||
|
|
<?php }?>
|
||
|
|
<?php if($app_sign_row['emp_sign']!='' || $app_sign_row['emp_sign']!=null){ ?>
|
||
|
|
<img align="right" id='sign' style="text-align:center; width:150px; height:80px;" class="card-img-bottm"
|
||
|
|
src="data:<?= $app_sign_row['image_type']; ?>;base64,<?= base64_encode($app_sign_row['emp_sign']) ?>">
|
||
|
|
<?php }?>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="row">
|
||
|
|
<div style="width: 100%;" class="leftailgn">
|
||
|
|
<div style="width: 100%;" class="leftailgn">
|
||
|
|
<span align='left'>(SIGNATURE OF PT.)</span>
|
||
|
|
<span align='right'>(SIGNATURE OF DOCTOR)</span>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div> -->
|
||
|
|
|
||
|
|
<br><br>
|
||
|
|
<br><br>
|
||
|
|
<br><br>
|
||
|
|
<div class="row">
|
||
|
|
<div style="width: 100%;" class="">
|
||
|
|
<?php if($ck_sign_row['emp_sign']!='' || $ck_sign_row['emp_sign']!=null){ ?>
|
||
|
|
<div align='left'>
|
||
|
|
<span>(SIGNATURE OF CHECKER)</span>
|
||
|
|
</div>
|
||
|
|
<?php }?>
|
||
|
|
<?php if($app_sign_row['emp_sign']!='' || $app_sign_row['emp_sign']!=null){ ?>
|
||
|
|
<div align='right'>
|
||
|
|
<span> (SIGNATURE OF APPROVER)</span>
|
||
|
|
</div>
|
||
|
|
<?php }?>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<!-- <div class="row">
|
||
|
|
<div style="width: 100%;" class="leftailgn">
|
||
|
|
<span align='left'>(SIGNATURE OF PT.)</span>
|
||
|
|
|
||
|
|
<span align='right'>(SIGNATURE OF DOCTOR)</span>
|
||
|
|
</div>
|
||
|
|
</div> -->
|