<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
//include('headMain.php');

?>
<div class="row">
    <div class="col-lg-1"></div>
    <div class="col-lg-8">
        <div class="panel panel-default">
            <div class="panel-heading">
                Uploading CGPA
            </div>
            <div class="panel-body">

                <div class="row">
                    <div class="col-lg-12">

                    <?php
require_once('../connect.php');
                    $db=db_connect();
if(isset($_POST["submit"]))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$c = 0;
while(($filesop = fgetcsv($handle, 1000000, ",")) !== false) {

    $matNo = $filesop[0];
    if ($matNo == 'MatricNo') {

    } else {
        $names = $filesop[1];
        $gender = 0;
        $progCode =0;
        $mode = 0;
        $level =0;
        $cgpa = $filesop[2];

//        $supress = $filesop[4];
        $supress = 0;
//        $others = $filesop[5].' '.$filesop[6].' '.$filesop[7];
        $others = 0;
        $remark = $filesop[3];
        $asession = '2023/2024';
        $semester = 'Second Semester';
        $school = '0';
        $dept = '';
        $gpa = '0';

//        MatricNo	FullNames	Gender	CosCode	ProgCode	Mode	Level	Remark	Supress

        $names = str_replace("'", "''", $names);
        $check_data = $db->query("select * from rawcgpa where matNo='$matNo' and level='$level' and asession='$asession'");
        $check_num = $check_data->rowCount();
        $dataNow = $check_data->fetch(PDO::FETCH_BOTH);

        if ($check_num > 0) {
            echo '<br>Already Exist=>' . $matNo . '=>' . $level . '=>' . $gpa . '=>' . $cgpa . '<br>';
            echo 'Present Record =>' . $matNo . '=>' . $level . '=>' . $dataNow['gpa'] . '=>' . $dataNow['cgpa'] . '=>' . $dataNow['cgpa'] . '<br>';
            $db->query("UPDATE `rawcgpa` SET  `gpa`='$gpa', `cgpa`='$cgpa', `remark`='$remark', `supress`='$supress' where matNo='$matNo' and  `level`='$level' and asession='$asession'");
            echo "UPDATE `rawcgpa` SET  `gpa`='$gpa', `cgpa`='$cgpa', `remark`='$remark', `supress`='$supress' where matNo='$matNo' and  `level`='$level' and asession='$asession'";
//        die();
        } else {

//$sql=$db->query("INSERT INTO `fedpoly`.`rawcgpa` (`sn`, `school`, `dept`, `matNo`, `names`, `level`, `gpa`, `cgpa`, `remark`, `supress`, `asession`) VALUES ('', 'e', '1', '1', '2', '3', '5', '6', '7', '8', '2')");
           echo  $r = "INSERT INTO `fedpoly`.`rawcgpa` (`sn`, `school`, `dept`, `matNo`, `names`, `level`, `gpa`, `cgpa`, `remark`, `supress`,`asession`,`modea`)
VALUES (NULL, '$school', '$dept', '$matNo', '$names', '$level', '$gpa', '$cgpa', '$remark', '$supress', '$asession','$mode')";
//            die();
            $sql = $db->query($r);
            if ($sql){
                $counter+=1;
            }else{
                $counterLess+=1;
                echo $matNo.'<br>';
            }
        }
        /*$sql=mysql_query('LOAD DATA LOCAL INFILE "'.$file.'"
                INTO TABLE rawcgpa
                FIELDS TERMINATED by ","
                OPTIONALLY ENCLOSED BY "\'"
                LINES TERMINATED BY "\n"');*/
    }
}
    if($sql){
        echo $counter ."-Your database has imported successfully";
    }else{
        echo $counterLess. "-Sorry! There is some problem.";
    }
}
                    ?>

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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