176 lines
4.2 KiB
PHP
176 lines
4.2 KiB
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="20%" 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>
|
|
|
|
|
|
</table>
|
|
|
|
|
|
|
|
<table width="100%">
|
|
<tr>
|
|
<div style="font-size:12px">
|
|
<td align="center" width="25%" align="left">
|
|
</td>
|
|
<td align="center" width="50%" align="center" style="font-size:20px"><strong>Beneficiary Attendence List </strong></td>
|
|
<td align="center" width="25%" align="left"> User :
|
|
<?php echo $username ?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
|
|
|
|
<table border="1" width="100%">
|
|
<?php
|
|
$id = $_REQUEST['id'];
|
|
$sql = "SELECT * FROM attendance_batch where ohc_type_id = '".$_SESSION['current_ohcttype']."'";
|
|
//echo $sql;
|
|
$result = mysqli_query($conn, $sql);
|
|
// $rowOfEmployee = mysqli_fetch_array($result);
|
|
|
|
?>
|
|
<tr bgcolor='#eeeeee' >
|
|
<th width=33%>Batch Name </th>
|
|
<th width=33%>Attendance Date</th>
|
|
<th width=33%>Remarks</th>
|
|
|
|
</tr>
|
|
<?php
|
|
while($rowOfEmployee = mysqli_fetch_array($result)) {
|
|
|
|
|
|
$batch_name = getFieldFromTable('batch_name', 'training_batch_master', 'batch_id', $rowOfEmployee['batch_id']);
|
|
$attendence_date = date_format(date_create($rowOfEmployee['attendence_date']),"d-m-Y");
|
|
|
|
?>
|
|
<tr>
|
|
|
|
<td align="center"><?php echo $batch_name ?></td>
|
|
<td align="center"><?php echo $attendence_date ?></td>
|
|
<td align="center"><?php echo $rowOfEmployee['remarks'] ?></td>
|
|
|
|
</tr>
|
|
<?php } ?>
|
|
</table>
|
|
|
|
|
|
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|