163 lines
4.7 KiB
PHP
163 lines
4.7 KiB
PHP
<?php
|
|
include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
?>
|
|
|
|
|
|
|
|
|
|
<head>
|
|
<style>
|
|
body {
|
|
font-family: Arial, sans-serif;
|
|
font-size: 12px;
|
|
margin: 0;
|
|
padding: 0;
|
|
}
|
|
.header-table, .main-table {
|
|
width: 100%;
|
|
border-collapse: collapse;
|
|
}
|
|
.header-table td {
|
|
padding: 5px;
|
|
}
|
|
.header-table .logo {
|
|
width: 150px;
|
|
height: 30px;
|
|
}
|
|
.header-table .company-info {
|
|
text-align: center;
|
|
font-size: 15px;
|
|
}
|
|
.header-table .company-info b {
|
|
display: block;
|
|
}
|
|
.header-table .company-info span {
|
|
font-size: 12px;
|
|
}
|
|
.title-table td {
|
|
font-size: 18px;
|
|
text-align: center;
|
|
padding: 10px;
|
|
}
|
|
table {
|
|
border-collapse: collapse;
|
|
width: 100%;
|
|
margin-top: 20px;
|
|
}
|
|
th, td {
|
|
border: 1px solid #dddddd;
|
|
text-align: left;
|
|
padding: 8px;
|
|
}
|
|
th {
|
|
background-color: #eeeeee;
|
|
}
|
|
tr:nth-child(even) {
|
|
background-color: #f2f2f2;
|
|
}
|
|
tr:hover {
|
|
background-color: #ddd;
|
|
}
|
|
</style>
|
|
</head>
|
|
<?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 class="title-table">
|
|
<tr>
|
|
<td width="25%"></td>
|
|
<td width="50%"><strong>Placement Feedback List</strong></td>
|
|
<td width="25%">User: <?php echo htmlspecialchars($username); ?></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<table class="main-table">
|
|
<tr>
|
|
<th width="5%">Sr.</th>
|
|
<th width="15%">Batch Name</th>
|
|
<th width="20%">Follow Up Routine</th>
|
|
<th width="15%">Placement Partner Name</th>
|
|
<th width="15%">Beneficiary</th>
|
|
<th width="15%">Technical Skill</th>
|
|
<th width="15%">Behaviour</th>
|
|
<th width="15%">Communication</th>
|
|
<th width="15%">Performance</th>
|
|
<th width="12%">Remark</th>
|
|
</tr>
|
|
<?php
|
|
$sql = "SELECT * FROM placement_feedback";
|
|
$result = mysqli_query($conn, $sql);
|
|
$count = 1;
|
|
while ($rowOffeedback = mysqli_fetch_array($result)) {
|
|
$batch_name = getFieldFromTable('batch_name', 'training_batch_master', 'batch_id', $rowOffeedback['batch_id']);
|
|
$partner_id = getFieldFromTable('partner_name', 'partners', 'partner_id', $rowOffeedback['placement_id']);
|
|
$placement_name = getFieldFromTable('client_name', 'client_master', 'id', $partner_id);
|
|
?>
|
|
<tr>
|
|
<td><?php echo $count; ?></td>
|
|
<td><?php echo htmlspecialchars($batch_name); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['follow_up_routine']); ?></td>
|
|
<td><?php echo htmlspecialchars($placement_name); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['beneficiary']); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['technical_skill']); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['behaviour']); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['communication']); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['performance']); ?></td>
|
|
<td><?php echo htmlspecialchars($rowOffeedback['remark']); ?></td>
|
|
</tr>
|
|
<?php
|
|
$count++;
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|
|
|
|
|