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

?>
    <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 Courses
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-12">
                            <?php
                            extract($_POST);
                            if(isset($_POST["submit"]))
                            {
                                $file = $_FILES['file']['tmp_name'];
                                $handle = fopen($file, "r");
                                $c = 0;
                                $dup=0;
                                $real=0;
                                $dptLevel=0;
                                $hdptLevel=0;
                                $school = $school;
                                $dept = $dept;

                                $SQLname=$db->query("select dOption from dept where sn=$dept");
                                $SQLname_fetch=$SQLname->fetch(PDO::FETCH_BOTH);
                                $deptName=$SQLname_fetch[0];
                                $levelID = $levelID;
                                $semester = $semester;
                                 $solaSQL="select * from coursepool where school='$school' and dept='$deptName' and levelID='$levelID' and semester='$semester'";

                                $sql_a=$db->query($solaSQL);
                                $sql_a_num=$sql_a->rowCount();
                                if($sql_a_num>0){
                                    $sql_a_fetch = $sql_a->fetch(PDO::FETCH_BOTH);
                                    echo 'Already Existing Record :School: ' . $school . '--> Department:' . $sql_a_fetch['dept'] . '-->LevelID:' . $sql_a_fetch['levelID']  .'-->Semester:' . $sql_a_fetch['semester']. '<br>';

                                    if(($levelID==2) or ($levelID==1)) {
                                        $levelIDDPT = $levelID + 7;
                                    }elseif(($levelID==4) or ($levelID==3)){
                                        $levelIDDPT=$levelID+8;
                                        }else{
                                        $levelIDDPT=0;
                                    }

                                        $solaDELETE="Delete from coursepool where school='$school' and dept='$deptName' and (levelID='$levelID' or levelID='$levelIDDPT') and semester='$semester'";

//                                    die();
//                                    if(($levelID==2) or ($levelID==1)) {
//                                        $levelIDDPT = $levelID + 7;
//                                        $solaDELETE="Delete from coursepool where school='$school' and dept='$deptName' and levelID='$levelIDDPT' and semester='$semester'";
//                                    }
//                                    if(($levelID==4) or ($levelID==3)) {
//                                        $levelIDHDPT = $levelID + 8;
//                                        $solaDELETE="Delete from coursepool where school='$school' and dept='$deptName' and levelID='$levelIDHDPT' and semester='$semester'";
//
//                                    }
                                    $db->query($solaDELETE);
//                                    die();
                                    echo 'But Has Been Deleted <br>';
                                }
                                while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
                                {
                                    $courseCode = $filesop[0];
                                    $fullName=$filesop[1];
                                    $courseUnit = $filesop[2];
                                    $courseTitle=str_replace("'","''",$fullName);
//                                    echo "<br>";
                                    $sola="INSERT INTO `coursepool` (`sn`, `school`, `dept`, `levelID`, `courseCode`, `courseTitle`, `courseUnit`, `semester`, `postR`,`staffID`) VALUES (NULL, '$school', '$deptName', '$levelID', '$courseCode', '$courseTitle', '$courseUnit', '$semester', '0','0')";
                                    $sql = $db->query($sola);
                                    if(($levelID==2) or ($levelID==1)){
                                        $levelIDDPT=$levelID+7;
                                        $db->query("INSERT INTO `coursepool` (`sn`, `school`, `dept`, `levelID`, `courseCode`, `courseTitle`, `courseUnit`, `semester`, `postR`,`staffID`) VALUES (NULL, '$school', '$deptName', '$levelIDDPT', '$courseCode', '$courseTitle', '$courseUnit', '$semester', '0','0')");
                                        $dptLevel+=1;
                                    }
                                    if(($levelID==4) or ($levelID==3)){
                                        $levelIDHDPT=$levelID+8;
                                        $db->query("INSERT INTO `coursepool` (`sn`, `school`, `dept`, `levelID`, `courseCode`, `courseTitle`, `courseUnit`, `semester`, `postR`,`staffID`) VALUES (NULL, '$school', '$deptName', '$levelIDHDPT', '$courseCode', '$courseTitle', '$courseUnit', '$semester', '0','0')");
                                        $hdptLevel+=1;
                                    }
                                    $real = $real + 1;
                                }
                                if($sql){
                                    echo $sql_a_num. " Record Deleted successfully<br>";
                                    echo $real. " Real Record imported successfully<br>";
                                    echo $dptLevel. " DPT Record imported successfully<br>";
                                    echo $hdptLevel. " HDPT Record imported successfully<br>";
                                }else{
                                    echo "Sorry! There is some problem.";
                                    echo $real. " Record imported successfully<br>";
                                    echo $sola;
                                }
                            }
                            ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

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