<?php
    include('config.php');
    define( '_JEXEC', 1 );
    define('JPATH_BASE', dirname(__FILE__) );
    define( 'DS', DIRECTORY_SEPARATOR );
    require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
    require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
    require_once ( JPATH_BASE .DS.'libraries'.DS.'joomla'.DS.'factory.php' );
    
    session_start();

    $mainframe =& JFactory::getApplication('site');
    $user =& JFactory::getUser();             
    
    if (!$user->guest) {
        
        $db_connection=mysql_connect($host, $username, $password, $db_name);
            if (!$db_connection) {
                die("<br><b>Database Error:</b> Could not connected. Try again later.<br>");
                exit;
            }
        @mysql_select_db($db_name, $db_connection) or die("Unable to select database.");
        mysql_query("SET NAMES 'utf8'", $db_connection);

            $_SESSION['SECTION_ID'] = $_POST['sectionId'];   
            session_register('LESSONS_IDS');

           // $Q = "SELECT * FROM lesson WHERE sectionId='".$_POST['sectionId']."' AND departmentId='".$_SESSION['DEPARTMENT_ID']."' ORDER BY semester,lessonTitle";
            $Q = "SELECT `lessonId`, `departmentId`,`sectionId`,`academicYear` FROM `application_form`
                  WHERE `userId`='".$user->id."' AND `academicYear`='".date('Y')."' 
                  AND `departmentId`='".$_SESSION['DEPARTMENT_ID']."' 
                  AND `sectionId`='".$_POST['sectionId']."' 
                  AND `submited`='1'";        
            $result = mysql_query($Q);
           
            if( mysql_num_rows($result) != FALSE ) {
            ?>
            <br>  
                <?php
                    // Exec query to get user's sectionName
                    $sectionQuery = "SELECT * FROM section WHERE id='".$_POST['sectionId']."'";
                    $sectionResult = mysql_query($sectionQuery);
                    $section = mysql_fetch_array($sectionResult);
                ?>
                <a HREF="javascript:history.go(-1)">Τμήμα <?php echo $_POST['departmentName']; ?></a> > 
                <a HREF="javascript:history.go(-1)"><?php echo $section['sectionTitle']; ?></a> > Επιλογή Μαθήματος 
                
                <form method="post" action="?option=com_content&view=article&id=61">
  
                <input type="hidden" name="departmentName" value="<?php echo $_POST['departmentName']; ?>">
                <input type="hidden" name="sectionName" value="<?php echo $section['sectionTitle']; ?>">  

                <br>
                <br>
                    <table align="center">
                        <tr align="center" style='background-color: #B9EEAC;'>
                            <th>Τίτλος Μαθήματος
                            <th>Ώρες Διδασκαλίας
                            <th>Εξάμηνο
                            <th>Επιλογή Μαθήματος
                        </tr>
                        <?php
                            while( $selectedLesson = mysql_fetch_array($result) ) {
                                
                                $selectedLessonQ = "SELECT * FROM lesson 
                                                    WHERE id='".$selectedLesson['lessonId']."' AND departmentId='".$selectedLesson['departmentId']."' 
                                                    AND sectionId='".$selectedLesson['sectionId']."'"; 
                                $selectedLessonResult = mysql_query($selectedLessonQ);
                                $lesson = mysql_fetch_array($selectedLessonResult);   
                                
                                echo "<tr onMouseOut=\"this.style.background='#FFFFFF'\" onMouseOver=\"this.style.background ='#FFA346';\">";
                                echo "<td>".$lesson['lessonTitle']."</td>"; 
                                echo "<td>".$lesson['teachingHours']."</td>"; 
                                echo "<td>".$lesson['semester']."</td>"; 
                                echo "<td align='center'><input type='radio' name='lesson' value='".$lesson['id']."'></td>"; 
                                echo "</tr>";
                            }
                        ?>
                        <tr>
                            <td colspan="5" align="right"><input type="submit" value="Επόμενο >>"></td>
                        </tr>
                    </table>
                </form>
            <?php   
            echo "<br><br>* Ο Τίτλος Μαθήματος με κατάληξη -Θ: αναφέρεται στη Θεωρία.<br>
                          * Ο Τίτλος Μαθήματος με κατάληξη -Ε: αναφέρεται σε Εργαστήριο.<br>";  
            }
            else {
                echo "<font color='red'>Δεν υπάρχουν καταχωρημένα Μαθήματα για τον Επιλεγμένο Τομέα.</font>";    
            }
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>