220 lines
6.8 KiB
PHP
220 lines
6.8 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
$start = $_POST['startexpDate'];
|
|
$end = $_POST['endexpDate'];
|
|
$ohc_id = $_SESSION['current_ohcttype'];
|
|
|
|
$queryc = "select * from company_profile ";
|
|
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
|
|
@extract($row_company);
|
|
|
|
?>
|
|
<link rel="preconnect" href="https://fonts.googleapis.com">
|
|
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
|
|
<link href="https://fonts.googleapis.com/css2?family=Mulish:wght@300;400;500;600;700;800&display=swap" rel="stylesheet">
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
|
|
<style>
|
|
* {
|
|
font-family: 'Mulish', sans-serif;
|
|
}
|
|
|
|
@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;
|
|
}
|
|
}
|
|
|
|
#main-table {
|
|
width: 100%;
|
|
border-collapse: collapse;
|
|
border: 1px solid black;
|
|
font-size: 11px;
|
|
}
|
|
|
|
#main-table td {
|
|
padding: 5px;
|
|
border: 1px solid black;
|
|
font-size: 11px;
|
|
}
|
|
|
|
#main-table tr:nth-child(even) {
|
|
background-color: lightgoldenrodyellow;
|
|
color: black;
|
|
}
|
|
|
|
#main-table thead tr {
|
|
background-color: lightcoral;
|
|
}
|
|
</style>
|
|
|
|
<body>
|
|
<table width="100%" cellspacing="0">
|
|
<tr>
|
|
|
|
<td width="20%">
|
|
<?php if (isset($row_company['company_logo']) && $row_company['company_logo'] != null) { ?>
|
|
<img src="data:<?php echo $row_company['image_type'] ?>;base64,<?php echo base64_encode($row_company['company_logo']) ?>" style="width: 150px; height: 60px; margin: 0px; padding: 0px;">
|
|
<?php } ?>
|
|
</td>
|
|
|
|
<td width="60%" align="center">
|
|
<div style="margin-left: 20px; margin-top: 5px; line-height: 1;">
|
|
<center style="font-size: 15px ; text-transform: capitalize;"><b>
|
|
<?php echo $row_company['company_name'] ?>
|
|
<br> <span style="font-size: 11px; ;">MEDICAL DEPARTMENT</span>
|
|
<pre style="margin-top: 0px; font-size:10px;"><?php echo $row_company['address'] ?></pre>
|
|
|
|
<br> <span style="font-size: 11px; text-decoration: underline;">Clinical Visit Summary Report</span>
|
|
</b>
|
|
</center>
|
|
</div>
|
|
</td>
|
|
<td width="40%" align="right">
|
|
<?php if (isset($row_company['right_com_logo']) && $row_company['right_com_logo'] != null) { ?>
|
|
<img src="data:<?php echo $row_company['right_image_type'] ?>;base64,<?php echo base64_encode($row_company['right_com_logo']) ?>" style="width: 150px; height: 60px; margin: 0px; padding: 0px;">
|
|
|
|
<?php } ?>
|
|
</td>
|
|
</tr>
|
|
|
|
|
|
|
|
<tr rowspan="2">
|
|
<td colspan="1"></td>
|
|
<td colspan="2"></td>
|
|
</tr>
|
|
|
|
|
|
|
|
<tr>
|
|
<td colspan="1"></td>
|
|
<td colspan="2"></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="1"></td>
|
|
<td colspan="2"></td>
|
|
</tr>
|
|
|
|
</table>
|
|
|
|
<table width="100%">
|
|
|
|
<tr>
|
|
<td align="left" style="font-size: 12px"><strong>Duration: <?php echo $start; ?> -
|
|
<?php echo $end; ?></strong></td>
|
|
<td align="right" style="font-size: 15px"><button align="left" id="printPageButton" class="btn btn-success" onClick="window.print();">Print</button></td>
|
|
</tr>
|
|
|
|
</table>
|
|
<br>
|
|
|
|
<table id="main-table" border="1" width="100%" cellspacing="0">
|
|
<thead>
|
|
<tr>
|
|
<th>Sr No.</th>
|
|
<th>Details</th>
|
|
<th>Count</th>
|
|
</tr>
|
|
</thead>
|
|
|
|
|
|
<?php
|
|
$opd_count = 0;
|
|
$inj_count = 0;
|
|
|
|
|
|
|
|
$query = "select count(*) as count from employee_appointment where date(appointment_date) between STR_TO_DATE('" . $start . "', '%d-%m-%Y') AND STR_TO_DATE('" . $end . "', '%d-%m-%Y') and ohc_type_id='" . $ohc_id . "' and appointment_type='O'";
|
|
error_log("query to count employee in opd" . $query);
|
|
|
|
if ($result = mysqli_query($conn, $query)) {
|
|
$row = mysqli_fetch_assoc($result);
|
|
$opd_count = $row['count'];
|
|
}
|
|
|
|
$query_inj = "select count(*) as count from employee_appointment where date(appointment_date) between STR_TO_DATE('" . $start . "', '%d-%m-%Y') AND STR_TO_DATE('" . $end . "', '%d-%m-%Y') and ohc_type_id='" . $ohc_id . "' and appointment_type='I'";
|
|
error_log("query to count employee in opd" . $query_inj);
|
|
|
|
if ($result_inj = mysqli_query($conn, $query_inj)) {
|
|
$row_inj = mysqli_fetch_assoc($result_inj);
|
|
$inj_count = $row_inj['count'];
|
|
}
|
|
|
|
$data = [];
|
|
$medical_name = [];
|
|
$checkup = "select * from checkup_type where type_status='Active' and type_state='No'";
|
|
$res = mysqli_query($conn, $checkup);
|
|
while ($row_checkup = mysqli_fetch_assoc($res)) {
|
|
|
|
array_push($medical_name, $row_checkup['checkup_type_name']);
|
|
|
|
$checkup_count = "select count(*) as count from checkup_form where date(checkup_date) between STR_TO_DATE('" . $start . "', '%d-%m-%Y') AND STR_TO_DATE('" . $end . "', '%d-%m-%Y') and checkup_type_id = '" . $row_checkup['checkup_type_id'] . "' and ohc_type_id='" . $ohc_id . "'";
|
|
|
|
$result_checkup = mysqli_query($conn, $checkup_count);
|
|
$row_checkup_count = mysqli_fetch_assoc($result_checkup);
|
|
|
|
$data['emp'][$row_checkup['checkup_type_name']] = $row_checkup_count['count'];
|
|
|
|
error_log("query for medical " . $checkup_count);
|
|
}
|
|
|
|
error_log("final checkup data " . print_r($data, true));
|
|
|
|
?>
|
|
<tbody>
|
|
|
|
<tr>
|
|
<td><?= ++$count ?></td>
|
|
<td>Opd</td>
|
|
<td><?= $opd_count ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td><?= ++$count ?></td>
|
|
<td>Injury</td>
|
|
<td><?= $inj_count ?></td>
|
|
</tr>
|
|
|
|
|
|
<?php
|
|
for ($i = 0; $i < sizeof($data['emp']); $i++) {
|
|
?>
|
|
<tr>
|
|
<td><?= ++$count ?></td>
|
|
<td style="text-transform: capitalize !important;"><?= $medical_name[$i] ?></td>
|
|
<td><?= $data['emp'][$medical_name[$i]] ?></td>
|
|
</tr>
|
|
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
|
|
|
|
</tbody>
|
|
</table>
|
|
</body>
|