<?php
   include 'header.php';
?>




<!-- ==========Banner Section Starts Here========== -->
<section class="page-header bg_img" data-background="assets/images/banner/page-header.jpg">
    <div class="container">
        <div class="page-header-content">
            <h1 class="title">Transfer Certificate</h1>
              <ul class="breadcrumb">
                <li>
                    <a href="index.php">Home</a>
                </li>
                <li>
                    Transfer Certificate
                </li>
            </ul>
        </div>
    </div>
</section>
<!-- ==========Banner Section Ends Here========== -->


<section class="about-section pos-rel padding-bottom padding-top oh">
    <div class="container">

        <div class="row justify-content-center">
            <div class="col-xl-6 col-lg-7">
                <div class="section-title text-center">
                    <h6 class="sub-title double-line"> Result <?php echo date('Y'); ?></h6>
                    <h3 class="title mt-3">Transfer Certificate </h3>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">
                <div>
                  <ul>
                     <li>Application for TCs are to be made at least two weeks in advance.</li>
                     <li>TCs will be issued only on clearance of all dues.</li>
                     <li>Duplicate copies of TCs are not ordinarily issued.</li>
                     <li>In exceptional cases a duplicate copy may be issued on production of an affidavit that the original TC has been irrecoverably lost.</li>
                     <li>The responsibility for any possible misuse will rest on the parent.</li>
                     <li>Caution Deposit: An undertaking for return of Caution Deposit should be made while applying for the TC. Caution Deposits will not be refunded, if not claimed, within one year from the date of leaving the school.</li>
                  </ul>
                </div>
                <div class="table-responsive mt-3">
                <table class="table table-striped ">
                    <!-- <thead>
                        <tr>
                        <th scope="col">Class Nursery Holiday Homework </th>
                        <th scope="col">Handle</th>
                        </tr>
                    </thead> -->
                    <tbody>
                    <?php
                    $tc_year = date('Y');
                    $query = $conn->prepare("SELECT * FROM transfer_certificate where tc_year = :tc_year order by id ASC");
                    $query->bindParam(':tc_year', $tc_year);
                    $query->execute();
                    $toppers_result = $query->fetchAll();
                    $toppers_row = count($toppers_result);
                    if ($toppers_row > 0) {
                        $sr_id = 1;
                        foreach ($toppers_result as $value) {
                            $tc_id = $value['id'];
                            $student_name = $value['student_name'];
                            $admission_no = $value['admission_no'];
                            $tc_documents = $value['tc_documents'];
                            $tc_year = $value['tc_year'];
                            ?>
                            <tr>
                                <th scope="row"><?php if (!empty($sr_id)) {  echo $sr_id; } ?></th>
                                <th scope="row"><?php if (!empty($student_name)) { echo $student_name; } ?></th>
                                <td scope="row"><?php if (!empty($father_name)) { echo $father_name; } ?></td>
                                <td scope="row"><?php if (!empty($admission_no)) {  echo $admission_no; } ?></td>
                                <td scope="row"><?php if (!empty($tc_year)) {  echo $tc_year; } ?></td>
                                <td><a target="_blank" href="bb-admin/upload/tc_documents/<?php echo $value['tc_documents'] ?>">View</td>
                            </tr>
                            <?php
                            $sr_id = $sr_id + 1;
                           }
                        }else{
                             echo "<h4 class='text-center mt-4'>No data available...</h4>";
                            }
                        ?> 
                        <!--<tr>-->
                        <!--    <th scope="row">Class Nursery Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class LKG Holiday Home-work </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class UKG Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 1st Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 2nd Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 3rd Holiday Homework </th>  -->
                        <!--   <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 4th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 5th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 6th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 7th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 8th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 9th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 10th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 11th Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 12th (Arts) Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 12th (Commerce) Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                        <!--<tr>-->
                        <!--    <th scope="row">Class 12th (Science) Holiday Homework </th>  -->
                        <!--    <td><img src="assets/images/product/pdf.png" alt="img"></td>-->
                        <!--</tr>-->
                    </tbody>
                </table>
                </div>
            </div>
        </div>
    </div>
</section>






<?php
   include 'footer.php';
   ?>