<?php
/**
 * Created by PhpStorm.
 * User: fpe
 * Date: 7/3/2020
 * Time: 10:02 PM
 */
$count_result=0;
$count_result_g1=0;
$count_result_g11=0;
$count_result_g12=0;
$count_result_g13=0;
$count_result_g14=0;
$count_result_g15=0;
$count_result_g2=0;
$count_result_g21=0;
$count_result_g22=0;
$count_result_g23=0;
$count_result_g24=0;
$count_result_g25=0;

$count_result_g0=0;
$count_result_g3=0;
$count_result_g31=0;
$count_result_g32=0;
$count_result_g33=0;
$count_result_g34=0;
$count_result_g35=0;
//$sqlk = $db->query("select * from vw_stddata_utmeform where level='$levelName' and `option`='$dept'");
//$numk = $sqlk->rowCount();
//$i = 0;
//if ($numk > 0) {
//    $rowk = $sqlk->fetch(PDO::FETCH_BOTH);
     $oleve=$row['olevel1'].$row['olevel2'];
     $dept=$row['course'];

    $sub=explode(",",$oleve);
    $sub_count=count($sub)-1;

   for($i=0;$i<=$sub_count;++$i){
       $subj=explode("-",$sub[$i]);
         $jj=count($subj);
       if($jj==2){

            $subject=trim($subj[0]);
             $result=trim($subj[1]);
           if(($result=='A1')||($result=='B2')||($result=='B3')||($result=='C4')||($result=='C5')||($result=='C6')) {
               if (($subject == 'English Language') or ($subject == 'Mathematics')) {
                   if ($count_result_g0 < 2) {
                       $count_result_g0 += 1;
                   }
               }

               $aspoa_fine = "select sn from dept where dOption='$dept'";
               $sql_aspoa = $db->query($aspoa_fine);
               $aspoa_fine_fetch = $sql_aspoa->fetch(PDO::FETCH_BOTH);
               $deptID = $aspoa_fine_fetch['sn'];
//echo $subject;
//               echo '+';
               $aspoa_sub = "select * from olevelcourses where subject='$subject'";
               $sql_aspoa_sub = $db->query($aspoa_sub);
               $aspoa_sub_fetch = $sql_aspoa_sub->fetch(PDO::FETCH_BOTH);
                $subID = $aspoa_sub_fetch['ID'];
//echo '-';
                 $aspoa_ID = "select * from tblolevelrequirement where dept_ID='$deptID' and OlevelCourse_ID='$subID'";
               $sql_aspoa_ID = $db->query($aspoa_ID);
               $aspoa_ID_fetch = $sql_aspoa_ID->fetch(PDO::FETCH_BOTH);
                 $Group1 = $aspoa_ID_fetch['Group1'];
               $NumRequired = $aspoa_ID_fetch['NumRequired'];
               $Child_Group = $aspoa_ID_fetch['Child_Group'];
               $NumRequired_Childgroup = $aspoa_ID_fetch['NumRequired_Childgroup'];

//               if ($dept=='Computer Science'){
//echo $subject;
//               echo $NumRequired;
              if ($Group1==1) {
                  if ($count_result_g1 < $NumRequired) {
                      if ($Child_Group==0) {
                          $count_result_g1 += 1;
                      }else{
                          if ($Child_Group==1) {
                              if ($count_result_g11 < $NumRequired_Childgroup) {
                                  $count_result_g11 += 1;
                                  $count_result_g1 += 1;
                              }
                          }
                          if ($Child_Group==2) {
                              if ($count_result_g12 < $NumRequired_Childgroup) {
                                  $count_result_g12 += 1;
                                  $count_result_g1 += 1;
                              }
                          }
                          if ($Child_Group==3) {
                              if ($count_result_g13 < $NumRequired_Childgroup) {
                                  $count_result_g13 += 1;
                                  $count_result_g1 += 1;
                              }
                          }
                          if ($Child_Group==4) {
                              if ($count_result_g14 < $NumRequired_Childgroup) {
                                  $count_result_g14 += 1;
                                  $count_result_g1 += 1;
                              }
                          }
                          if ($Child_Group==5) {
                              if ($count_result_g15 < $NumRequired_Childgroup) {
                                  $count_result_g15 += 1;
                                  $count_result_g1 += 1;
                              }
                          }
                      }
                      $NumRequired;
                  }
              }
               if ($Group1==2) {
                   if ($count_result_g2 < $NumRequired) {
                       if ($Child_Group==0) {
                           $count_result_g2 += 1;
                       }else{
                           if ($Child_Group==1) {
                               if ($count_result_g21 < $NumRequired_Childgroup) {
                                   $count_result_g21 += 1;
                                   $count_result_g2 += 1;
                               }
                           }
                           if ($Child_Group==2) {
                               if ($count_result_g22 < $NumRequired_Childgroup) {
                                  echo $count_result_g22 += 1;
                                   $count_result_g2 += 1;
                               }
                           }
                           if ($Child_Group==3) {
                               if ($count_result_g23 < $NumRequired_Childgroup) {
                                   $count_result_g23 += 1;
                                   $count_result_g2 += 1;
                               }
                           }
                           if ($Child_Group==4) {
                               if ($count_result_g24 < $NumRequired_Childgroup) {
                                   $count_result_g24 += 1;
                                   $count_result_g2 += 1;
                               }
                           }
                           if ($Child_Group==5) {
                               if ($count_result_g25 < $NumRequired_Childgroup) {
                                   $count_result_g25 += 1;
                                   $count_result_g2 += 1;
                               }
                           }


                   }
               }



              }
               if ($Group1==3) {
                   if ($count_result_g3 < $NumRequired) {
                       if ($Child_Group==0) {
                           $count_result_g3 += 1;
                       }else{
                           if ($Child_Group==1) {
                               if ($count_result_g31 < $NumRequired_Childgroup) {
                                   $count_result_g31 += 1;
                                   $count_result_g3 += 1;
                               }
                           }
                           if ($Child_Group==2) {
                               if ($count_result_g32 < $NumRequired_Childgroup) {
                                   echo $count_result_g32 += 1;
                                   $count_result_g3 += 1;
                               }
                           }
                           if ($Child_Group==3) {
                               if ($count_result_g33 < $NumRequired_Childgroup) {
                                   $count_result_g33 += 1;
                                   $count_result_g3 += 1;
                               }
                           }
                           if ($Child_Group==4) {
                               if ($count_result_g34 < $NumRequired_Childgroup) {
                                   $count_result_g34 += 1;
                                   $count_result_g3 += 1;
                               }
                           }


                       }
                   }



               }

           }


//               $count_result+=1;
           }

//       echo '<br>';

       //+$count_result_g12+$count_result_g13+$count_result_g14+$count_result_g2+$count_result_g21+$count_result_g22+$count_result_g23+$count_result_g24;
   }


$count_resultf=$count_result_g0+$count_result_g1+$count_result_g2;+$count_result_g3;

//die();