182 lines
4.2 KiB
PHP
182 lines
4.2 KiB
PHP
<?php
|
|
include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
//include('pop_up_top.php');
|
|
?>
|
|
<?php include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
// include('pop_up_top.php');
|
|
?>
|
|
<style>
|
|
/* General Table Styling */
|
|
table {
|
|
width: 100%;
|
|
border-collapse: collapse;
|
|
margin-bottom: 20px;
|
|
}
|
|
|
|
th,
|
|
td {
|
|
/* border: 1px solid #ddd; */
|
|
padding: 10px;
|
|
text-align: center;
|
|
}
|
|
|
|
th {
|
|
background-color: #f4f4f4;
|
|
font-size: 16px;
|
|
color: #333;
|
|
}
|
|
|
|
td {
|
|
font-size: 14px;
|
|
}
|
|
|
|
tr:nth-child(even) {
|
|
background-color: #f9f9f9;
|
|
}
|
|
|
|
tr:hover {
|
|
background-color: #e2e2e2;
|
|
}
|
|
|
|
/* Logo and Header Styling */
|
|
.logo-container {
|
|
width: 100%;
|
|
margin-bottom: 20px;
|
|
}
|
|
|
|
.logo-container img {
|
|
margin: 0;
|
|
padding: 0;
|
|
height: 60px;
|
|
}
|
|
|
|
.header-center {
|
|
text-align: center;
|
|
}
|
|
|
|
.header-title {
|
|
font-size: 18px;
|
|
font-weight: bold;
|
|
margin-bottom: 10px;
|
|
}
|
|
|
|
.header-subtitle {
|
|
font-size: 14px;
|
|
}
|
|
|
|
/* Result Table Styling */
|
|
.result-table th {
|
|
background-color: #eeeeee;
|
|
}
|
|
|
|
.result-table td {
|
|
background-color: #ffffff;
|
|
}
|
|
|
|
.total-row {
|
|
background-color: #d4edda;
|
|
font-weight: bold;
|
|
}
|
|
</style>
|
|
|
|
|
|
|
|
<?php
|
|
$queryc = "select * from company_profile ";
|
|
|
|
//echo $query;
|
|
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
|
|
@extract($row_company);
|
|
|
|
?>
|
|
|
|
<table>
|
|
<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%">
|
|
<div style="margin-left: 20px;">
|
|
|
|
<center style="font-size: 15px ;"><b>
|
|
<?php echo $row_company['company_name'] ?>
|
|
<?php echo $row_for_ohc['ohc_type_name'] ?><br><br>
|
|
<span style="font-size: 12px; ;">Vocational Training Institute</span>
|
|
|
|
|
|
|
|
</b></center>
|
|
</div>
|
|
</td>
|
|
|
|
<td width="25%" align="left"> User :
|
|
<?php echo $username ?>
|
|
</td>
|
|
</tr>
|
|
|
|
|
|
</table>
|
|
|
|
|
|
<h2 style="text-align: center;">Tranning Batch Enrollment List</h2>
|
|
<table border="1" cellspacing="0" cellpadding="5">
|
|
<?php
|
|
$ohc_type_id ="ohc_type_id =". $_SESSION['current_ohcttype'];
|
|
|
|
$sql = "SELECT * FROM training_batch_enrollment where $ohc_type_id";
|
|
|
|
$result = mysqli_query($conn, $sql);
|
|
|
|
|
|
|
|
?>
|
|
<tr bgcolor='#eeeeee'>
|
|
<th width="20%">Batch Name</th>
|
|
<th width="20%">Batch Started Date</th>
|
|
<th width="20%">Batch End Date</th>
|
|
<th width="20%">Program</th>
|
|
<th width="20%">Status</th>
|
|
|
|
</tr>
|
|
<?php
|
|
while ($row = mysqli_fetch_array($result)) {
|
|
|
|
$batch_start_date = date_format(date_create($row['batch_start_date']), "d-m-Y");
|
|
$batch_end_date = date_format(date_create($row['batch_end_date']), "d-m-Y");
|
|
$beneficiary_name = getFieldFromTable('patient_name', 'patient_master', 'id', $row['beneficiary_id']);
|
|
$batch_name = getFieldFromTable('batch_name', 'training_batch_master', 'batch_id', $row['batch_name']);
|
|
$subject = getFieldFromTable('name', 'courses', 'id', $row['subject']);
|
|
$batch_name = getFieldFromTable('batch_name', 'training_batch_master', 'batch_id', $row['batch_id']);
|
|
|
|
if ($row1['batch_started'] == '1') {
|
|
$batch_started = '<span style="color: green;">Yes</span>';
|
|
} elseif ($row1['batch_started'] == '0') {
|
|
$batch_started = '<span style="color: red;"> No </span>';
|
|
}
|
|
|
|
|
|
?>
|
|
<tr>
|
|
<td><?php echo $batch_name; ?></td>
|
|
<td><?php echo $batch_start_date; ?></td>
|
|
<td><?php echo $batch_end_date; ?></td>
|
|
<td><?php echo $subject; ?></td>
|
|
<td><?php echo $row['status']; ?></td>
|
|
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|