<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
//include('headMain.php');
require_once('../connect.php');
$db=db_connect();
?>
    <script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

    <script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
    <script type="text/javascript" language="javascript" src="../js/scriptFileLong.js"></script>

    <div class="row">
        <div class="col-lg-1"></div>
        <div class="col-lg-10">
            <div class="panel panel-default">
                <div class="panel-heading">
                    Uploading Admitted Students
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-12">
                            <?php
                            if(isset($_POST["submit"]))
                            {
                                $file = $_FILES['file']['tmp_name'];
                                $handle = fopen($file, "r");
                                $c = 0;
                                $dup=0;
                                $real=0;
                                while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
                                {
                                    $level=$_POST['level'];
//                                    die();
                                    $jambNo = $filesop[1];
                                    $fullName = $filesop[2];
                                    $dept = $filesop[3];
                                    $originalNo = $filesop[4];
                                    $fullName=str_replace("'","''",$fullName);
                                    $admDate='2021-06-30';
                                    $admDate=$filesop[5];

                                    if ($level==1){
                                        $mode='NFT';
                                        $sql_jambNo=$db->query("select formNo from stddata where jambNo='$jambNo'");
                                        $sql_jambNo_num=$sql_jambNo->rowCount();

                                        if ($sql_jambNo_num==1){
                                            $sql_jambNo_fetch=$sql_jambNo->fetch(PDO::FETCH_BOTH);
                                            $formNo=$sql_jambNo_fetch['formNo'];
                                        }else{
                                            $formNo=$jambNo;
                                        }
                                    }else if($level==8){
                                        $formNo = $filesop[1];
                                        $mode='DPT';
                                        $formTypea='dptForm';
                                    }else if($level==5){
                                        $formNo = $filesop[1];
                                        $mode="RPT";
                                        $formTypea='ptForm';
                                    }else if($level==3){
                                        $formNo = $filesop[1];
                                        $mode="HFT";
                                    }else if($level==10){
                                        $formNo = $filesop[1];
                                        $mode="PFT";
                                    }else if($level==11){
                                        $formNo = $filesop[1];
                                        $mode="HDPT";
                                    }

									
//$postScore = $filesop[18];
//                                    echo "select * from admitted where jambNo='$originalNo' or sex='$originalNo' or formNo='$jambNo' or formNo='$jambNo'";
//                                    echo "select * from admitted where jambNo='$originalNo' or sex='$originalNo' or formNo='$jambNo' or formNo='$jambNo'";
                                    echo "select * from admitted where jambNo='$originalNo' or sex='$originalNo' or formNo='$jambNo' or formNo='$jambNo'";
                                    $sql_a=$db->query("select * from admitted where jambNo='$originalNo' or sex='$originalNo' or formNo='$jambNo' or formNo='$jambNo'");
//                                    $sql_a=$db->query("select * from admitted where sex='$originalNo'");
//                                    $sql_a=$db->query("select * from ace_admitted where jambNo='$jambNo'");
//                                    $sql_a=$db->query("select * from realdata where jambNo='$jambNo'");
                                    $sql_a_num=$sql_a->rowCount();
                                    if($sql_a_num>0){
                                        $sql_a_fetch = $sql_a->fetch(PDO::FETCH_BOTH);
                                        echo 'Previous Record :ID No: ' . $jambNo . '--> Names:' . $sql_a_fetch['names'] . '-->Department:' . $sql_a_fetch['course'] . '-->Batch:' . $sql_a_fetch['batch'] . '<br>';
                                        echo 'Current Record :ID No: ' . $jambNo . '--> Names:' . $fullName . '-->Department:' . $dept . '<br>';
                                        $dup=$dup+1;
                                        $sola=0;
                                        $sql=0;
                                    }else {
                                        // $sql=$db->query("INSERT INTO check_phoneno(`sn`,`formNo`)values('',$jambNo)");
//                                       echo $sola="INSERT INTO `fedpoly`.`admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0',  '0', '0', '14', '0', CURRENT_TIMESTAMP,'0')";
                                   // echo  $sola="INSERT INTO `fedpoly`.`ace_admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0',  '$gsm', '0', '4', '0', CURRENT_TIMESTAMP,'0')";
										 $sola="INSERT INTO `fedpoly`.`admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`,`admDate`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0',  '0', '$originalNo', '11', '0', CURRENT_TIMESTAMP,'1','$admDate')";
                                    // echo   $sola="INSERT INTO `fedpoly`.`realdata` (`sn`, `formNo`, `matNo`, `names`, `course`, `levelID`, `mode`, `usernamea`, `passworda`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '$matNo', '$matNo')";
										//die();
                                        $sql = $db->query($sola);
//       die();
                                        $real = $real + 1;

                                        //=========================Conversion column Start
//
     $courseDept = $db->query("select sn from dept where dOption='$dept'");

        $courseDept_fetch = $courseDept->fetch(PDO::FETCH_BOTH);
        $dOption = $courseDept_fetch['sn'];

        $na = explode(' ', $fullName);
        $surName = $na[0];
        if (isset($na[2])) {
            $otherNames = $na[1] . ' ' . $na[2];
        }
        else{
            $otherNames=$na[1];
        }

        $pass2=md5($jambNo);
        $phoneNumber='';
        $eMail='';
        $transID=$jambNo;

            $formNo='';
    $saheed="INSERT INTO `fedpoly`.`entrancetable` (`sn`, `surname`, `othernames`, `password`, `gsm`, `email`, `course`, `transID`,`formType`,`dept`)
 VALUES (NULL, '$surName', '$otherNames', '$pass2', '08000000000', '[email protected]', '$dOption', '$transID','$formTypea','$dOption')";
        $sql_a = $db->query($saheed);
//    die($dept);
//=======================================Conversion column End
                                    }
                                }
                                if($sql){
                                    echo $real. " Record imported successfully<br>";
                                    echo $dup. " Record(s) Duplicated Found";
                                }else{
                                    echo "Sorry! There is some problem.";
                                    echo $real. " Record imported successfully<br>";
                                    echo $dup. " Record(s) Duplicated Found";
                                    echo $sola;
                                }
                            }
                            ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php
include('footMain.php');
?>