315 lines
16 KiB
PHP
315 lines
16 KiB
PHP
<?php include('techsyn_header.php'); ?>
|
|
|
|
<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>
|
|
<i class="ace-icon fa fa-home home-icon"></i>
|
|
<a href="#">Documents</a>
|
|
</li>
|
|
|
|
</ul>
|
|
|
|
</div>
|
|
<!-- End of breadcrumb -->
|
|
|
|
|
|
<?php
|
|
$ohc_type_id = $_SESSION['current_ohcttype'];
|
|
|
|
$i = 0;
|
|
if (isset($_REQUEST['flex_patient_id'])) {
|
|
$sql = "select * from activity_log where id='" . $_REQUEST['flex_patient_id'] . "'";
|
|
error_log($sql . "dipak mali");
|
|
//echo "query:".$sql;
|
|
$result = mysqli_query($conn, $sql);
|
|
$num_rows = @mysqli_num_rows($result);
|
|
$row = null;
|
|
if ($num_rows > 0) {
|
|
$row = @mysqli_fetch_assoc($result);
|
|
extract($row);
|
|
}
|
|
}
|
|
?>
|
|
|
|
<div class="page-content">
|
|
<div class="box box-primary" style="padding: 10px; margin: 2px 0px 50px 5px; width: 99.5%; ">
|
|
|
|
<form id="activityForm" method="POST" enctype="multipart/form-data">
|
|
<!-- box-body-->
|
|
<div class="box-body">
|
|
<div class="row" style="margin-left: 100px; margin-right: 100px">
|
|
<div class="form-group col-sm-3">
|
|
<label>Activity <span style="color:red">*</span></label>
|
|
<!-- <input type="text" id="activity" name="activity" class="form-control" placeholder="Enter Activity Name" required> -->
|
|
|
|
<select class="form-control select2" id="activity" name="activity" data-placeholder="Choose a item..." style="width: 290px;">
|
|
<option value=""></option>
|
|
<?php echo generateOptionWithWhereClause('program_master', 'program_name', 'program_id', $activity, '', 'program_status', '"Active"') ?>
|
|
|
|
</select>
|
|
|
|
<input type="hidden" name="pri_tbl_id" id="pri_tbl_id" value="<?php echo $id; ?>">
|
|
|
|
<input type="hidden" name="procurement_id" id="procurement_id" value="<?php echo $_REQUEST['flex_procurement_id'] ?>">
|
|
|
|
<input type="hidden" name="stock_issue_id" id="stock_issue_id" value="">
|
|
|
|
</div>
|
|
|
|
<div class="form-group col-sm-3">
|
|
<label for="activity_date">Activity Date</label>
|
|
<input type="date" id="activity_date" name="activity_date" value="<?php echo $activity_date ?>" class="form-control" required>
|
|
</div>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<div class="row" style="margin-left: 100px; margin-right: 100px">
|
|
<div class="col-sm-12">
|
|
<table id="sopTable" class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th>Program Name</th>
|
|
<th>Doc Number</th>
|
|
<th>Last Renewal Date</th>
|
|
<th>Next Renewal Date</th>
|
|
|
|
<?php
|
|
if ($id) { ?>
|
|
<th></th>
|
|
<?php } ?>
|
|
<th>File Upload</th>
|
|
<th>Action</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$sql_doc = "SELECT * FROM sop_document WHERE activity_log_id='$id'";
|
|
error_log("child sql doc" . $sql_doc);
|
|
$fetch_sql = mysqli_query($conn, $sql_doc);
|
|
$result_doc = mysqli_fetch_array($fetch_sql);
|
|
$i = 0;
|
|
|
|
|
|
|
|
do {
|
|
|
|
|
|
|
|
?>
|
|
<input type="hidden" name="medical_doc_id<?php echo $i; ?>" id="medical_doc_id<?php echo $i; ?>" value="<?php echo $result_doc['medical_doc_id']; ?>" />
|
|
<tr>
|
|
<td>
|
|
<select class="form-control select2" id="sop_name_<?php echo $i ?>" name="sop_name_<?php echo $i ?>" data-placeholder="Choose a item..." style="width: 290px;">
|
|
<option value=""></option>
|
|
<?php echo generateOption('csr_program', 'program_name', 'csr_id', $result_doc['medical_doc_desc'], '') ?>
|
|
|
|
</select>
|
|
|
|
|
|
</td>
|
|
<td><input type="text" name="sop_number_<?php echo $i ?>" id="sop_number_<?php echo $i ?>" class="form-control" placeholder="Enter SOP Number" value="<?php echo $result_doc['sop_number'] ?>" required></td>
|
|
<td><input type="date" name="last_renewal_date_<?php echo $i ?>" id="last_renewal_date_<?php echo $i ?>" class="form-control" value="<?php echo $result_doc['last_renewal_date'] ?>" required></td>
|
|
<td><input type="date" name="next_renewal_date_<?php echo $i ?>" id="next_renewal_date_<?php echo $i ?>" value="<?php echo $result_doc['new_renewal_date'] ?>" class="form-control" required></td>
|
|
<?php
|
|
error_log($id."nana");
|
|
|
|
if($id) { ?>
|
|
<?php
|
|
error_log("MEDICAL DOC " . $result_doc['medical_doc']);
|
|
if ($result_doc['medical_doc_type'] == 'application/pdf') { ?>
|
|
<!-- Display PDF -->
|
|
<td style="width: 20%;">
|
|
<object data="data:application/pdf;base64,<?php echo base64_encode($result_doc['medical_doc']) ?>" type="application/pdf" style="height:200px;width:100%"></object>
|
|
</td>
|
|
<?php } else if ($result_doc['medical_doc_type'] == 'image/jpeg') { ?>
|
|
<!-- Display Image -->
|
|
<td style="width: 20%;">
|
|
<img src="data:<?php echo $result_doc['medical_doc_type'] ?>;base64,<?php echo base64_encode($result_doc['medical_doc']) ?>" alt="Image Preview" style="height:200px;width:100%">
|
|
</td>
|
|
<?php } elseif ($result_doc['medical_doc_type'] == 'application/vnd.openxmlformats-officedocument.wordprocessingml.document') { ?>
|
|
<!-- Display Download for Word Document -->
|
|
<td style="width: 20%;">
|
|
<a href="data:<?php echo $result_doc['medical_doc_type'] ?>;base64,<?php echo base64_encode($result_doc['medical_doc']) ?>" download="<?php echo $result_doc['medical_doc_name'] ?>">
|
|
<img src="images/word.png" width="35" height="35" alt="Download Word Document">
|
|
</a>
|
|
</td>
|
|
<?php } ?>
|
|
|
|
<?php } ?>
|
|
<td><input type="file" name="file_doc_<?php echo $i ?>" id="file_doc_<?php echo $i ?>" class="form-control">
|
|
|
|
|
|
</td>
|
|
<td><button type="button" class="btn btn-danger removeRow">Remove</button></td>
|
|
</tr>
|
|
<?php
|
|
$i++;
|
|
} while ($result_doc = mysqli_fetch_array($fetch_sql))
|
|
|
|
?>
|
|
|
|
</tbody>
|
|
</table>
|
|
<button type="button" id="addRow" class="btn btn-success">Add Row</button>
|
|
<input type="submit" class="btn btn-primary" value="Save">
|
|
|
|
</div>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<input type="hidden" name="total_rows" id="total_rows" value='<?php echo ($i - 1) ?>'>
|
|
|
|
|
|
</form>
|
|
|
|
|
|
<?php if (isset($_REQUEST['flex_procurement_id'])) { ?>
|
|
<?php include('upload_bill.php'); ?>
|
|
<?php include('image_popup_procurement.php'); ?>
|
|
<?php } ?>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
|
|
<!-- End of page-content -->
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<script>
|
|
$(document).ready(function() {
|
|
var rowCount = $('#total_rows').val();
|
|
|
|
$('#addRow').on('click', function() {
|
|
rowCount++;
|
|
|
|
|
|
let newRow = `<tr>
|
|
<td><select class="form-control select2" id="sop_name_${rowCount}" name="sop_name_${rowCount}" data-placeholder="Choose a item..." style="width: 290px;"><option value=""></option><?php echo generateOption('csr_program', 'program_name', 'csr_id', $result_doc['medical_doc_desc'], '')?>
|
|
</td>
|
|
<td><input type="text" name="sop_number_${rowCount}" id="sop_number_${rowCount}" class="form-control" placeholder="Enter SOP Number" required></td>
|
|
<td><input type="date" name="last_renewal_date_${rowCount}" id="last_renewal_date_${rowCount}" class="form-control" required></td>
|
|
<td><input type="date" name="next_renewal_date_${rowCount}" id="next_renewal_date_${rowCount}" class="form-control" required></td>
|
|
<td><input type="file" name="file_doc_${rowCount}" id="file_doc_${rowCount}" class="form-control" required></td>
|
|
<td><button type="button" class="btn btn-danger removeRow">Remove</button></td>
|
|
</tr>`;
|
|
|
|
$('#sopTable tbody').append(newRow);
|
|
$('#total_rows').val(rowCount);
|
|
});
|
|
|
|
$('#sopTable').on('click', '.removeRow', function() {
|
|
$(this).closest('tr').remove();
|
|
updateTotalRows();
|
|
});
|
|
|
|
|
|
$('#activityForm').submit(function(e) {
|
|
e.preventDefault();
|
|
|
|
let formData = new FormData(this);
|
|
|
|
$.ajax({
|
|
url: 'save_sop_document.php',
|
|
type: 'POST',
|
|
data: formData,
|
|
contentType: false,
|
|
processData: false,
|
|
success: function(response) {
|
|
|
|
BootstrapDialog.alert('Data saved successfully.');
|
|
|
|
|
|
$("#flex1").flexReload();
|
|
|
|
|
|
window.location.href = 'techsyn_upload.php';
|
|
},
|
|
error: function(xhr, status, error) {
|
|
console.error('Error:', error);
|
|
alert('Error saving data.');
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
function updateTotalRows() {
|
|
let totalRows = $('#sopTable tbody tr').length;
|
|
$('#total_rows').val(totalRows);
|
|
}
|
|
});
|
|
</script>
|
|
|
|
<style>
|
|
#modal-add-ailment {
|
|
overflow-y: scroll;
|
|
}
|
|
</style>
|
|
|
|
|
|
|
|
<?php include('techsyn_footer.php'); ?>
|
|
<!-- 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>
|