<?php

$username = $_SESSION['username'];


// basic breakdown or notes to self before continueing
// first 1 are for both
// second 1 for for objective
// third for daily plotter

// the first one fetches data from the table
// called main and grabs the time start , time end, class name,
// and period and stores it in the first box

function grabmain($username, $period)
  {

$host = "127.0.0.1";
$user = "teacherp_db";
$pass = "teacher";
$database = "teacherp_db";

  $con = mysql_connect($host, $user, $pass)
            or die("Cannot connect to SQL Server");
  mysql_select_db($database, $con);

  $sql = " SELECT * FROM main where username = '$username' ";
  $result = mysql_query($sql);

$row = mysql_fetch_array($result);
$var1 = $row['per1name'];
$var2 = $row['per1time1'];
$var3 = $row['per1time2'];
$var4 = $row['per2name'];
$var5 = $row['per2time1'];
$var6 = $row['per2time2'];
$var7 = $row['per3name'];
$var8 = $row['per3time1'];
$var9 = $row['per3time2'];
$var10 = $row['per4name'];
$var11 = $row['per4time1'];
$var12 = $row['per4time2'];
$var13 = $row['per5name'];
$var14 = $row['per5time1'];
$var15 = $row['per5time2'];
$var16 = $row['per6name'];
$var17 = $row['per6time1'];
$var18 = $row['per6time2'];
$var19 = $row['per7name'];
$var20 = $row['per7time1'];
$var21 = $row['per7time2'];
$var22 = $row['per8name'];
$var23 = $row['per8time1'];
$var24 = $row['per8time2'];
$var25 = $row['per9name'];
$var26 = $row['per9time1'];
$var27 = $row['per9time2'];

 If($period == 1)
   {
  echo "$var1";
  echo "<br>";
  echo "Time: "; echo "$var2"; echo " - "; echo "$var3";
   }

 If($period == 2)
   {
  echo "$var4";
  echo "<br>";
  echo "Time: "; echo "$var5"; echo " - "; echo "$var6";
   }

 If($period == 3)
   {
  echo "$var7";
  echo "<br>";
  echo "Time: "; echo "$var8"; echo " - "; echo "$var9";
   }


 If($period == 4)
   {
  echo "$var10";
  echo "<br>";
  echo "Time: "; echo "$var11"; echo " - "; echo "$var12";
   }

 If($period == 5)
   {
  echo "$var13";
  echo "<br>";
  echo "Time: "; echo "$var14"; echo " - "; echo "$var15";
   }


 If($period == 6)
   {
  echo "$var16";
  echo "<br>";
  echo "Time: "; echo "$var17"; echo " - "; echo "$var18";
   }


 If($period == 7)
   {
  echo "$var19";
  echo "<br>";
  echo "Time: "; echo "$var20"; echo " - "; echo "$var21";
   }

 If($period == 8)
   {
  echo "$var22";
  echo "<br>";
  echo "Time: "; echo "$var23"; echo " - "; echo "$var24";
   }


 If($period == 9)
   {
  echo "$var25";
  echo "<br>";
  echo "Time: "; echo "$var26"; echo " - "; echo "$var27";
   }

}

// this one gets objective info, do not touch unless you know what to do

function grabobj($weekid, $period, $username)
{

    $host = "127.0.0.1";
    $user = "teacherp_db";
    $pass = "teacher";
    $database = "teacherp_db";
    $con = mysql_connect($host, $user, $pass)
            or die("Cannot connect to SQL Server");
    mysql_select_db($database, $con);
    $sql = "
             SELECT * FROM planbook
             where owner = '$username'
             and weeknum = '$weekid'
             and period  = '$period'
              ";
    $result = mysql_query($sql);
    $count  = mysql_num_rows($result);
    If ($count < 1)
      {
      echo " ";
      }
    else
      {
      while ($row = mysql_fetch_array($result))
         {
          echo "<b>"; // bold
          $vk1 = $row['content'];
          echo "$vk1";
          echo "</b>";  // end bold
         }
      }

}


function determine($input, $selid, $bktxt)
{
  If ($input == 1)
  {
   echo "<b>Assesment - Quiz</b> <br>";
  }
  ElseIf ($input == 2)
  {
   echo "<b>Assesment - Test</b> <br>";
  }
  ElseIf ($input == 3)
  {
   echo "<b>Activity</b> <br>";
  }
  ElseIf ($input == 4)
  {
   echo "<b>Activity - Textbook</b><br>";
   echo "$selid";            echo "<br>";
   echo "$bktxt";            echo "<br>";
  }
  ElseIf ($input == 5)
  {
   echo "<b>Activity - Worksheet</b> <br>";
  }
  ElseIf ($input == 6)
  {
   echo "<b>Activity - Presentation</b> <br>";
  }
  ElseIf ($input == 7)
  {
   echo "<b>Activity - Essay Writing</b> <br>";
  }
  ElseIf ($input == 8)
  {
   echo "<b>Activity - Assembly </b> <br>";
  }
  ElseIf ($input == 9)
  {
   echo "<b>Activity - Movie</b> <br>";
  }
  Else
  {
   echo "<b>Activity</b> <br>";
  }

}
// this one is for the plotter , very complex but simple at the same time
// day = 1-6, 1,2,3,4,5 is mon-fri , 6 = notes
// weekid = 1aug/1sept -> 40aug/40sept -> use a call script for week numberings

function grabplot($weekid, $period, $username, $day)
{
    $host = "127.0.0.1";
    $user = "teacherp_db";
    $pass = "teacher";
    $database = "teacherp_db";
    $con = mysql_connect($host, $user, $pass)
            or die("Cannot connect to SQL Server");
    mysql_select_db($database, $con);
    $sql = " SELECT * FROM plotter WHERE weeknum = '$weekid' AND period = '$period'
             and owner = '$username' ";
    $result = mysql_query($sql);
    $count = mysql_num_rows($result);
    $row  = mysql_fetch_array($result);
    If ($count < 1)
    {
     echo " &nbsp; ";
    }
    else
    {
    $mon  = $row['mon'];
    $tue  = $row['tue'];
    $wed  = $row['wed'];
    $thu  = $row['thu'];
    $fri  = $row['fri'];
    $note = $row['note'];
    $mont = $row['mont'];
    $tuet = $row['tuet'];
    $wedt = $row['wedt'];
    $thut = $row['thut'];
    $frit = $row['frit'];
    $selid1 = $row['selid1'];
    $selid2 = $row['selid2'];
    $selid3 = $row['selid3'];
    $selid4 = $row['selid4'];
    $selid5 = $row['selid5'];
    $bktxt1 = $row['bktxt1'];
    $bktxt2 = $row['bktxt2'];
    $bktxt3 = $row['bktxt3'];
    $bktxt4 = $row['bktxt4'];
    $bktxt5 = $row['bktxt5'];

      If ($day == 1)
      {
       determine($mont, $selid1, $bktxt1);
       echo "$mon";
      }

      If ($day == 2)
      {
       determine($tuet, $selid2, $bktxt2);
       echo "$tue";
      }

      If ($day == 3)
      {
       determine($thut, $selid3, $bktxt3);
       echo "$wed";
      }

      If ($day == 4)
      {
       determine($wedt, $selid4, $bktxt4);
       echo "$thu";
      }

      If ($day == 5)
      {
       determine($frit, $selid5, $bktxt5);
       echo "$fri";
      }

      If ($day == 6)
      {
       echo "<b>Notes</b> <br>";
       echo "$note";
      }
    }
}

function bkname($username, $selectid)
  {
    $host = "127.0.0.1";
    $user = "teacherp_db";
    $pass = "teacher";
    $database = "teacherp_db";
    $con = mysql_connect($host, $user, $pass)
            or die("Cannot connect to SQL Server");
    mysql_select_db($database, $con);
    $sql = "SELECT * FROM main where username = '$username' ";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);
    echo "<select name="; echo "$selectid"; echo ">";
    echo "<option>"; echo $row['bk1']; echo "</option>";
    echo "<option>"; echo $row['bk2']; echo "</option>";
    echo "<option>"; echo $row['bk3']; echo "</option>";
    echo "<option>"; echo $row['bk4']; echo "</option>";
    echo "<option>"; echo $row['bk5']; echo "</option>";
    echo "<option>"; echo $row['bk6']; echo "</option>";
    echo "<option>"; echo $row['bk7']; echo "</option>";
    echo "<option>"; echo $row['bk8']; echo "</option>";
    echo "<option>"; echo $row['bk9']; echo "</option>";
    echo "</select>";

  }
?>