<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
ob_start();
session_start();

//echo $db_con->query("select sum(amtPaid) as amtP from remitaorder where `regNo`='$matno' and transApproved=True")->rowCount();
//  $hhh="select amtPaid as amtP from remitaorder where `regNo`='$matno'";
//echo "select * from stdprofile where matno='$matno'";
$matNo = $_SESSION['matNo'];
require_once('../../connect.php');
$db_con=db_con_connect();
$matNoP=$_SESSION['matNoP'];
//echo "select * from hostel where Regno='$matNoP' and PaymentStatus='Paid'";
if ($matNo=='HA20220203745'){
    echo "select * from hostel where (Regno='$matNo' or stdid='$matNoP') and PaymentStatus='Paid'";
    die();

}
$kk=$db_con->query("select * from hostel where (Regno='$matNo' or stdid='$matNoP') and PaymentStatus='Paid'");
if ($kk->rowCount()==1) {
    $kk_fetch = $kk->fetch(PDO::FETCH_BOTH);
    $stdid = $kk_fetch['stdid'];
//    $matNo=$kMatNo;
    $all_hall_name = $kk_fetch['hostelName'];
    $all_room_id = $kk_fetch['hostelRoom'];
    $all_bed_id = $kk_fetch['bedSpaceId'];

//    $ss = "select * from room_allocation where matNo='MatNo'";
//    $ss_fetch = $ss->
    $dat = date('l, M d, o, h:i:s a');
    $db = db_connect();
    $sql = $db->query("select * from realdata where matNo='$matNo'");
    $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);
    $num = $sql->rowCount();
    if ($num == 1) {
        $matNo = $sql_fetch['matNo'];
        $fullName = explode(' ', ($sql_fetch['names']));
        $surname = strtoupper($fullName[0]);
        $othernames = $fullName[1] . ' ' . $fullName[2];
        $sex = $sql_fetch['sex'];
        $dept = $sql_fetch['course'];
        if ($sex == 'Male') {
            $title = 'Mr.';
            $dd = "He";
            $dd2 = "his";
            $dd3 = "him";
            $tit="Sir";
        } else {
            $title = 'Miss.';
            $dd = "She";
            $dd2 = "her";
            $dd3 = "her";
            $tit="Ma";
        }

        // $k=count($fullName);
        $ku = $db->query("select * from dept where dOption='$dept'");
        $ku_fetch = $ku->fetch(PDO::FETCH_BOTH);
        $schlName = $ku_fetch['dSchool'];
//        $it_session = $ku_fetch['it_session'];

    }
    $mainBody =
        '<img src="../../images/siwesHead.png">
<div style="font-size: 18px; text-align: center"><b>TENANCY AGREEMENT FORM</b></div>
<div align="right">Date: ' . date('d/m/y') . ' </div>

     <strong> <h3>NAME OF HALL: '.strtoupper($all_hall_name).'</h3></strong>


   <div style="font-size: 23px";align: justify>

  <ol type="1"  >
  <li>I, <b>' . $title . ' ' . $surname . ' ' . $othernames . '</b> with Matriculation Number '.$matNo.', a student in the Department of <b> ' . $dept . '</b>, School of<b> ' . $schlName . '</b>
  have been allocated to <u> Room ' . $all_room_id . ' </u>in the above named Hall of residence for the period covering the Session (that is, the two Semesters excluding normal vacation period) in accordance with the Polytechnic calendar in consideration of my having paid the sum of
 Twenty Thousand Naira (#20,000.00) ONLY</li>
 <li>I confirm that the <u> bed space ('.$all_bed_id.')</u> in this room has been officially allocated to me by the Student Affiars Office after the payment of the sripulated sum of ' . $amtPaid . 'for accommodation.
    </li>
    <li>I agree to pay for any damage done to the facilities in the room or the hall as a whole due to carelessness or deliberate destruction of the Polytechnic property during my tenure.</li>
    <li>I shall return the key to the room at the end of each semester except express permission is granted to remain in the residence by the appropriate authorities on payment of specified fees.</li>
  </ol>
<table style="font-size: 17px"><tr ><td colspan="4"></td></tr>
<br>
<tr><td colspan="2">Students\' Signature & Date:</td><td colspan=2> ..................................................</td></tr>
<p>
</p>
<br>
<tr><td colspan="4" align="center"><b><u>OFFICIAL USE ONLY</u></b></td></tr>
<br>
<br>
<br>
<tr><td colspan="2">Students\' Affairs Officer: .....................................</td><td colspan="2" align="right">Signature & Date: ..................  </td></tr><br>

<p></p>


    </table>

    ';
//echo $mainBody;
    $customizedFooter = '<img src="../../images/siwesfooter.png"><br><div align="right">' . $dat . '</div>';

    include("../../mpdf/mpdf.php");
    $filename = 'tenancyForm-' . $matNo . '.pdf';
    $mpdf = new mPDF('c');
    $mpdf->SetWatermarkImage('../../images/logoBack.png');
    $mpdf->showWatermarkImage = true;


    $mpdf->WriteHTML($mainBody);
    $mpdf->setFooter($customizedFooter);
    $mpdf->Output($filename, 'D');
    exit;
}else{
    echo "An Error has Occur/You have not Paid for Accomodation, Contact ICT on 07061230735 (WhatsApp ONLY)";
}
?>