256 lines
7.5 KiB
PHP
256 lines
7.5 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('access.php');
|
|
include('log_entry.php');
|
|
|
|
$id = $_POST['id']; // ya $_GET['id']
|
|
|
|
$sql = "SELECT * FROM patient_master WHERE id='$id'";
|
|
$res = mysqli_query($conn, $sql);
|
|
$p = mysqli_fetch_assoc($res);
|
|
|
|
function v($x)
|
|
{
|
|
return !empty($x) ? htmlspecialchars($x) : '-';
|
|
}
|
|
|
|
$age = ($p['dob']) ? date_diff(date_create($p['dob']), date_create())->y : '-';
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<title>GHCL Vocational Skill Training Institute</title>
|
|
<style>
|
|
body {
|
|
font-family: DejaVu Sans;
|
|
background: #fff;
|
|
}
|
|
|
|
.container {
|
|
width: 900px;
|
|
margin: auto;
|
|
padding: 20px;
|
|
border: 2px solid #000;
|
|
}
|
|
|
|
h2,
|
|
h4 {
|
|
text-align: center;
|
|
margin: 4px 0;
|
|
}
|
|
|
|
table {
|
|
width: 100%;
|
|
border-collapse: collapse;
|
|
font-size: 14px;
|
|
}
|
|
|
|
td {
|
|
border: 1px solid #000;
|
|
padding: 6px;
|
|
}
|
|
</style>
|
|
</head>
|
|
|
|
<body>
|
|
<?php
|
|
$queryc = "SELECT * FROM company_profile";
|
|
$resultc = mysqli_query($conn, $queryc);
|
|
$row_company = mysqli_fetch_array($resultc);
|
|
@extract($row_company);
|
|
?>
|
|
|
|
<div class="container">
|
|
|
|
<table style="border: none; width: 100%;">
|
|
<tr>
|
|
<td width="20%" class="header-cell" style="border: none;">
|
|
<?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;">
|
|
<?php } ?>
|
|
</td>
|
|
<?php
|
|
$exm_id = $_REQUEST['exm_id'];
|
|
$primary_query = "SELECT * FROM placement_examination WHERE exm_id = '$exm_id' AND ohc_type_id = '" . $_SESSION['current_ohcttype'] . "'";
|
|
$primary_result = mysqli_query($conn, $primary_query);
|
|
$primary_row = mysqli_fetch_array($primary_result);
|
|
error_log("check_batch_id : " . $primary_row['batch_name']);
|
|
$course_name = getFieldFromTable('name', 'courses', 'id', getFieldFromTable('training_program_id', 'training_batch_master', 'batch_id', $primary_row['batch_name']));
|
|
$center_name = getFieldFromTable('ohc_type_name', 'ohc_type', 'ohc_type_id', $_SESSION['current_ohcttype']);
|
|
$beneficiary_name = getFieldFromTable('patient_name', 'patient_master', 'id', $primary_row['beneficiary']);
|
|
|
|
?>
|
|
|
|
|
|
<td width="60%" class="header-cell" style="border: none;">
|
|
<div>
|
|
<b style="font-size: 15px;">
|
|
<h2>GHCL</h2>
|
|
<h4>Vocational Skill Training Institute</h4>
|
|
<h4>Initiative by GHCL Foundation Trust</h4>
|
|
</b>
|
|
</div>
|
|
</td>
|
|
<td width="20%" class="header-cell" style="border: none;">
|
|
|
|
</td>
|
|
|
|
</tr>
|
|
|
|
</table>
|
|
|
|
|
|
<table>
|
|
<tr>
|
|
<td><b>Form No.</b></td>
|
|
<td></td>
|
|
<td><b>Date</b></td>
|
|
<td><?= date('d-m-Y') ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>1. Course </b></td>
|
|
<td colspan="3"></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>2. Name </b></td>
|
|
<td colspan="3"><?= v($p['patient_name']) ?></td>
|
|
</tr>
|
|
|
|
|
|
|
|
<tr>
|
|
<td><b>3. Address</b></td>
|
|
<td colspan="3">
|
|
<?= v($p['village']) ?>, <?= v($p['post']) ?>,
|
|
<?= v($p['ps']) ?>, <?= v($p['tehsil']) ?>,
|
|
<?= v($p['district']) ?>, <?= v($p['state']) ?>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>Village</b></td>
|
|
<td><?= getFieldFromTable('village', 'village', 'id', $p['village']) ?></td>
|
|
<td><b>Taluka</b></td>
|
|
<td><?= getFieldFromTable('name', 'tehsils', 'id', $p['tehsil']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>District</b></td>
|
|
<td><?= getFieldFromTable('name', 'districts', 'id', $p['district']) ?> </td>
|
|
<td><b>Pincode</b></td>
|
|
<td><?= v($p['pin_code']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>4. Date of Birth</b></td>
|
|
<td><?= v($p['dob']) ?></td>
|
|
<td><b>Age</b></td>
|
|
<td><?= $age ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>5. Mobile No.</b></td>
|
|
<td><?= v($p['primary_phone']) ?></td>
|
|
<td><b>Alternate No.</b></td>
|
|
<td><?= v($p['personal_phone']) ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>6. Aadhaar No.</b></td>
|
|
<td colspan="3"><?= v($p['aadhar_no']) ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>7. Father / Husband Name</b></td>
|
|
<td colspan="3"><?= v($p['father_name']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>8. Category</b></td>
|
|
<td colspan="3"><?= v($p['caste']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>9. Gender</b></td>
|
|
<td colspan="3"><?= v($p['gender']) ?></td>
|
|
</tr>
|
|
|
|
|
|
|
|
<tr>
|
|
<td><b>10. Economic Status</b></td>
|
|
<td colspan="3"><?= v($p['economic_category']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>11. Education</b></td>
|
|
<td colspan="3"><?= getFieldFromTable('qualification', 'qualification', 'id', $p['education']) ?></td>
|
|
</tr>
|
|
|
|
<!-- <tr>
|
|
<td><b>12. Any Disability</b></td>
|
|
<td colspan="3"><?= ($p['is_disabled'] ? 'Yes' : 'No') ?></td>
|
|
</tr> -->
|
|
|
|
<tr>
|
|
<td><b>12. Annual Family Income</b></td>
|
|
<td colspan="3"><?= v($p['annual_income']) ?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>13. Course Interested</b></td>
|
|
<td colspan="3">__________________________</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><b>Signature of Student</b></td>
|
|
<td></td>
|
|
<td><b>Date</b></td>
|
|
<td></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<br>
|
|
|
|
<h4><b>For Office Use Only</b></h4>
|
|
|
|
<table>
|
|
<tr>
|
|
<td><b>LC</b></td>
|
|
<td></td>
|
|
<td><b>Aadhaar Copy</b></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>Caste Certificate</b></td>
|
|
<td></td>
|
|
<td><b>Student Photcopy - 2</b></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr>
|
|
<td><b>BPL Proof</b></td>
|
|
<td></td>
|
|
<td><b>Marksheet</b></td>
|
|
<td></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<br>
|
|
|
|
<table style="width: 100%;">
|
|
<tr>
|
|
<td style="width: 50%;"><b>Verified By</b></td>
|
|
<td style="width: 50%;"> </td>
|
|
</tr>
|
|
<tr>
|
|
<td style="width: 50%;"><b>Signature</b></td>
|
|
<td style="width: 50%;"> </td>
|
|
</tr>
|
|
</table>
|
|
|
|
</div>
|
|
</body>
|
|
|
|
</html>
|