<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 07/29/2016
 * Time: 9:10 AM
 */
require_once('../connect.php');
$db=db_connect();
$db->query("delete from postutmepoint where jambNo<>''");
$i=1;
$olevel=0;
$realScore=0;
$value_Olevel=0;
$noOfResult=0;
$sql="select * from stddata where jambNo in (select jambNo from jambrelease)"; //formNo<>' ' and level='utmeForm'";
$sql_query=$db->query($sql);
 $sql_count=$sql_query->rowCount();
echo $sql_count;
if ($sql_count>0){
    while ($row=$sql_query->fetch(PDO::FETCH_BOTH)) {
        $jambNo = $row['jambNo'];
        $formNo = $row['formNo'];
        $names=$row['surname'].' '.$row['otherNames'];
        $names=str_replace("'","''",$names);
        $state=$row['state'];
        $dept=$row['option'];
        //olevel
        $sql_olevel=$db->query("select * from preolevel  where formNo='$formNo'");
        $sql_olevel_count=$sql_olevel->rowCount();
        if ($sql_olevel_count>0){
            $sql_olevel_fetch=$sql_olevel->fetch(PDO::FETCH_BOTH);
            $olevelResult=$sql_olevel_fetch['olevel1'].$sql_olevel_fetch['olevel2'];
            $noOfResult=$sql_olevel_fetch['noOfResult'];
        }else{
            $olevelResult='';
        }

        //end


        $sql_jambScore = $db->query("select * from jambrelease where jambNo='$jambNo'");
         $sql_jambScore_status = $sql_jambScore->rowCount();
        if ($sql_jambScore_status > 0) {
            $sql_jambScore_fetch = $sql_jambScore->fetch(PDO::FETCH_BOTH);
             $jambScore = $sql_jambScore_fetch['totalScore'];

        } else {
            $jambScore =$row['jambScore'];// Not present in the Jambrelease table
        }
            $sql_jamb_point = $db->query("select * from jambpoint where (startPoint<='$jambScore' and  endPoint>='$jambScore')");
             $sql_jamb_point_status = $sql_jamb_point->rowCount();


            if ($sql_jamb_point_status > 0) {
                $sql_jamb_point_fetch = $sql_jamb_point->fetch(PDO::FETCH_BOTH);
                $jambScoreGrade = $sql_jamb_point_fetch['point'];

            } else {
                $jambScoreGrade = 500;// Not present in the gradepoint table
            }
        //usage should goes here
        echo ++$i.'->';
       // echo $jambNo.'(';
        //echo $jambScore.')==(';
         $formNo.')';
       // echo $jambScoreGrade;


       // $k=$result3_fetch['$olevel'];
        $olevel=explode(',',$olevelResult);
        $count=count($olevel);

        for ($a=0;$a<$count-1;++$a){
            $splitOlevel=explode('-',$olevel[$a]);
           $score=$splitOlevel[1];
            switch ($score){
                case 'A1 ': $realScore=6; break;
                case 'B2 ': $realScore=5; break;
                case 'B3 ': $realScore=4; break;
                case 'C4 ': $realScore=3; break;
                case 'C5 ': $realScore=2; break;
                case 'C6 ': $realScore=1; break;
                default:$realScore=0;
                   // $value_Olevel=$realScore;
            }
             $value_Olevel+=$realScore;
             $score;
        }
         $value_Olevel;
        if ($noOfResult==1){
            $comination=10;
        }elseif ($noOfResult==2){
            $comination=2;
        }else{
            $comination=-1;
        }
         $comination;

$totalGrade=$jambScoreGrade+$comination+$value_Olevel;
        $a= $value_Olevel/30*50 .'<br>';
        $b= $jambScore/8 .'<br>';
        $c=$a+$b;
        $totalGrade2=($jambScoreGrade/8)+($value_Olevel/30*50);
      echo $formNo.'=='.$jambNo.'=='.$noOfResult.'=='.$olevelResult.'=='.$jambScore.'=='.$comination.'=='.$value_Olevel.'=='.$jambScoreGrade.'=='.$totalGrade.'=='.round($c,2).'<br>';

        $sql_Now=$db->query("INSERT INTO `fedpoly`.`postutmepoint` (`sn`, `formNo`, `jambNo`, `noOfResult`, `oLevelResult`, `jambScore`, `noOfResult_point`, `oLevelResult_point`, `jambScore_point`, `aggregate`,`agg_jamb_olevel`,`names`,`state`,`dept`)VALUES ('', '$formNo', '$jambNo', '$noOfResult', '$olevelResult', '$jambScore', '$comination', '$value_Olevel', '$jambScoreGrade', '$totalGrade',$c,'$names','$state','$dept')");
if($sql_Now){
    echo 'Thanks';
}else{
    echo 'No';
}
        $value_Olevel=0;

//end
    }
    }else{
        $jambScoreGrade=700;// Not present in the stddata table

    }