<?php
session_start();
require_once('headMain2.php');
extract($_POST);
if (isset($_SESSION['jamb'])){
    $jamb=$_SESSION['jamb'];
}else{
    $_SESSION['jamb']=$jamb;
}

require_once('../connect.php');
$db=db_connect();

$dd=$db->query("select * from current WHERE sn=2");
$dd_fetch=$dd->fetch(PDO::FETCH_BOTH);
$_SESSION['it_print']=$dd_fetch['it_start'];
$_SESSION['asession']=$dd_fetch['asession']='2022/2023';
$_SESSION['asemester']=$dd_fetch['asemester'];

// $spe="select * from admitted where sex='$jamb' and formStatus=1";
//$sq=$db->query($spe);
//if ($sq->rowCount()){
//    $sq_fetch=$sq->fetch(PDO::FETCH_BOTH);
//
//    echo '<p></p><div style="font-size: 20px; color: #000066; margin-top: 40px; margin-bottom: 20px"> Your Conversion Code is :'.$sq_fetch['formNo'].' Kindly use it to check your Admission Status</div>';
//}

//$sql="select * from admitted where (jambNo ='$jamb' or formNo='$jamb') and course not in ('BIOCHEMISTRY','Chemistry','MICROBIOLOGY','PHYSICS ELECTRONICS')";
$sql="select * from admitted_22_23 where (jambNo ='$jamb' or formNo='$jamb' or sex='$jamb')";
$result=$db->query($sql);
$num =$result->rowCount();
?>
<div class="col-lg-8 col-lg-offset-2 ">
<?php

if ($num==1) {
    $result_fetch = $result->fetch(PDO::FETCH_BOTH);
    $batch = $result_fetch['batch'];
    $formStatus = $result_fetch['formStatus'];
    $jNo = $result_fetch['jambNo'];

    $closed = $_SESSION['closed'] = $result_fetch['closed'];
    $fNo = $result_fetch['formNo'];


    $stddata_monitor = $db->query("select * from stddata_2022 where formNo='$fNo'")->rowCount();
//    echo $_SESSION['closed'];
    $_SESSION['olevelVerify'] = $olevelVerify = $result_fetch['olevelVerify'];
    $kMode = $result_fetch['mode'];
//    require('../filetoU/logFile.php');
//    $logD = 'LogIn from Admission Status';
//    logDetail($jamb, $logD);
    echo '    <div class="col-lg-12 alert-info" style="margin-top: 20px; margin-bottom: 20px">';
    $k = $result_fetch['mode'];
    if ($k == 'DPT') {
        $msg = 'Daily Part Time';
    } elseif ($k == 'HFT') {
        $msg = 'HND FT';
    } elseif ($k == 'NFT') {
        $msg = 'ND FT';
    } elseif ($k == 'RPT') {
        $msg = 'ND PT';
    } elseif ($k == 'PFT') {
        $msg = 'Pre ND';
    } elseif ($k == 'HDPT') {
        $msg = 'HND DPT';
    }
    echo '<div style="font-size: 20px; color: #000066; margin-top: 20px; margin-bottom: 20px">Congratulation ' . strtoupper($result_fetch['names']) . ', <br> You have been offered Admission to study <div style="color:#ff00ff">' . $result_fetch['course'] . ' (' . $msg . ')</div></div>';
    $deptTest = $result_fetch['course'];
    $formNo = $_SESSION['formNo'] = $result_fetch['formNo'];
    $_SESSION['matNo'] = $result_fetch['formNo'];
    $_SESSION['sn'] = $result_fetch['sn'];
    $_SESSION['names'] = $result_fetch['names'];
    $course = $_SESSION['course'] = $result_fetch['course'];

    $_SESSION['deptID'] = 0;
    $res = $db->query("select * from dept where dOption='$course'");
    $n = $res->rowCount();
    if ($n > 0) {
        $res_fetch = $res->fetch(PDO::FETCH_BOTH);
        $_SESSION['deptID'] = $res_fetch['sn'];


        $_SESSION['dschool'] = $res_fetch['dSchool'];
    }
    $_SESSION['acceptance'] = $result_fetch['acceptance'];
    $_SESSION['levelID'] = $result_fetch['levelID'];
    echo "select * from remitaorder_2022_2023 where regNo='$formNo'and (paymentType='Acceptance Fee' or paymentType='Admission Slip2') and transApproved='True' and pay_session='2022/2023'";

    $kk = $db->query("select * from remitaorder_2022_2023 where regNo='$formNo'and (paymentType='Acceptance Fee' or paymentType='Admission Slip2') and transApproved='True' and pay_session='2022/2023'")->rowCount();
    // echo $k;
    //die($formNo);
    if ($kk == 1) {
        if( strpos( $formNo, '198111' ) !== false) {
//        if (strpos($formNo, '198')!== false)){
            echo '<br>
 <div style="font-size: 19px"class="fa fa-arrow-circle-o-right">Acceptance Fee has been PAID</div><p>
<p><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/admissionLetter_22_23.php" target="_blank">Print Admission Letter 2022_2023</a></div>';
        }else{
            echo '<br> <div style="font-size: 19px; color: #020202">Acceptance Fee has been PAID</div><p>
<div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/admissionSlip.php"> Click to Print Admission Slip</a></div>
<p></p><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/acceptancePrint_21_22.php" target="_blank">Print Acceptance Receipt21_22</a></p></div>
<p></p><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/acceptancePrint_22_23.php" target="_blank">Print Acceptance Receipt22_23</a></p></div>
<p><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/admissionLetter_21_22.php" target="_blank">Print Admission Letter_21_22</a></div>
<p><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="../admin_student/print/admissionLetter_22_23.php" target="_blank">Print Admission Letter_22_23</a></div>';
        }



        $res_bio = $db->query("select * from realdata where formNo='$formNo' and fresher='80' and matNo in (select regNo from remitaorder_2022_2023 where transApproved='True')");
        $k = $res_bio->rowCount();
        if ($k > 0) {
            $res_bio_fetch = $res_bio->fetch(PDO::FETCH_BOTH);
            $newMatNo = $res_bio_fetch['matNo'];

            echo '<div style="font-size: 19px; color: red" >Kindly Login With Your Matric No.(' . $newMatNo . ')as Username and NOTE that your password is your School Fees RRR</div>';
//            echo '<div style="font-size: 19px; color: red" ><a href="../admin_student"> Click Here to Login</a></div>';

        } else {
//echo $kMode;
//            if (($olevelVerify <> '1') and (($kMode <> 'HFT') and ($kMode <> 'HDPT') and ($kMode <> 'PFT'))) {
            if ($olevelVerify <> '1') {

                echo '<div style="font-size: 30px"><a href="olevelVerify.php" style="color: red">Check Your O\'Level</a></div>';
            } else {
                if ($stddata_monitor == 0) {
                    echo '<br><div style="font-size: 25px; color: red" class="fa fa-arrow-circle-o-right"><a style="font-size: 25px; color: red" href="login_process.php?user=' . $formNo . '&pass=' . $jNo . '"> Click to Fill Application Form</a></div>';
                } else {


                    echo ' <p></p><div style="font-size: 19px; color: #f14833;display: nonle" class="fa fa-arrow-circle-o-right"><a href="../admin_student/index_pay_schoolFees.php" style="color: #0FF00F; font-size: larger""> Kindly Proceed to Pay School Fees</a></div>';
                }
            }
        }
    } else if ($kk == 0) {

//echo $kk;
        ?>
        <br>
<!--        <div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a-->
<!--                href="../admin_student/print/admissionSlip.php"> Click to Print Admission Slip</a></div>-->
        <br>
        <div style="font-size: 19px;color:#ff0000" class="fa fa-arrow-circle-o-right"><a
                href="../admin_student/index_pay_Acceptance.php"> Click to Pay Acceptance Fees</a></div>
    <?php
    } else {
        $noForm = $db->query("select formStatus from admitted_22_23 where formNo='$formNo' and formStatus=1")->rowCount();
        if ($formStatus == 1) {
            if ($closed==0) {

                echo '<br><div style="font-size: 19px" class="fa fa-arrow-circle-o-right"><a href="login_process.php?user=' . $formNo . '&pass=' . $formNo . '"> Click to Obtain Application Form (Your Conversion code is :' . $formNo . ')</a></div>';
                echo "<p><hr><div style='color: red; font-size: 25px; display: none'>Kindly Wait for 12 hours after Application Form Payment and use your New Form No to check the Admission Status.
<br>For Any Complaint kindly email us at '[email protected]' or use our contact page.</div>";
                die("<hr>");
            }
        }

        //echo $deptTest;
        if ($deptTest == 'Estate ManagementT') {
            echo "<hr><div style='color: red; font-size: 18px'>You are advised to confirm your eligibility from your Head of Department before making Payment.</div><hr>";
        }
        if ($closed <> 1) {
            $_SESSION['batch'] = $batch;
            ?>

            <br>
            <div style="font-size: 19px; display: " class="fa fa-arrow-circle-o-right" ><a
                    href="../admin_student/index_pay_adminSlip.php"> Click to Print Admission Slip</a></div>


            <br/>
        <?php

        } else {
            echo '<div style="font-size: 20px; color: red"><h2>Acceptance Fees Payment Has Closed</h2>';
//    echo $closed;
        }
    }
    echo '</div></div>';
    echo '<br> <div style="font-size: 19px; color: #96a3b4;display: none" class="col-lg-6 col-lg-offset-3"><a href="paymentHistory.php"> Click to check Payment History</a></div></div>';

    echo '</div>';
}else {
//    $ace_admission = "select * from ace_admitted where formNo='$jamb'";
//    $querya = $db->query($ace_admission)->rowCount();
//    $ossce_admission = "select * from ossce_admitted where formNo='$jamb'";
//    $queryb = $db->query($ossce_admission)->rowCount();
//    $eace_admission = "select * from eace_admitted where formNo='$jamb'";
//    $queryc = $db->query($eace_admission)->rowCount();
//    echo $sum = $querya + $queryb + $queryc;
//    die();
    $sum=0;
    if ($sum == 1) {
        if ($querya == 1) {
            echo '<script>
        window.location="../ace_entranceForm/adminStatus_process.php";
        </script>';
//        header('location:../ace_entranceForm/adminStatus_process.php');
            die();
        } else {

            if ($queryb == 1) {
                echo '<script>
        window.location="../ossce_entranceForm/adminStatus_process.php";
        </script>';
                die();
            } else {

                if ($queryc == 1) {
                    echo '<script>
        window.location="../eace_entranceForm/adminStatus_process.php";
        </script>';

                } else {


                }
            }
        }

    }else {
//        echo ' <h3><div class="col-lg-10" style="16px">Check here for Dual Awards Admission</div><p></p>
//    <div class="col-lg-10" style="16px;fa fa-arrow-circle-o-right""><a href="../ossce_entranceForm/adminStatus.php">Osun State College of Education Ila-Orangun, Osun State</a> </div>
//    <div class="col-lg-10" style="16px;fa fa-arrow-circle-o-right""><a href="../ace_entranceForm/adminStatus.php">Ilori College of Education Ede, Osun State</a> </div>
//</h3>    ';
    }
    echo '<div style="font-size: 19px; color: red" class="col-lg-10"><h3>' . "No Admission Yet" . '</h3></div><br>';
}

            ?>
   <br /><br />
    </div>
</div>
<p></p>
<div class="col-lg-8 col-lg-offset-2">
    <div>

    </div>
    <div class="col-lg-12  btn btn-info" style="font-size: 18px; color: red"><a href="logout_out.php" style="text-decoration: none">Log Out </a></div>
       <div class="col-lg-12 btn btn-default" style=" data-x :30; data-y: 340">     <a onclick="window.open('../chat/student_chat.php?chatwith=ICT ADMIN','_blank','height=500,width=430,left=10,top=10, resizable=no,scrollbars=no,titlebar=no, toolbar=no,menubar=no,location=no,directories=no,status=no');" style="text-decoration:underline; cursor:pointer; font-weight:bold;" >Online ICT Support </a><br /><br /></div>

</div>