<?php
    include(JPATH_BASE .DS.'externalpages'.DS.'ams'.DS.'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);
   
        $dbManagerQuery = "SELECT * FROM db_manager WHERE userId='".$user->id."'";
        $dbManagerResult = mysql_query($dbManagerQuery); 
        $dbManagerRow = mysql_fetch_array($dbManagerResult);
        
        $_SESSION['departmentId'] = $dbManagerRow['departmentId'];
        
        $departmentQuery = "SELECT * FROM department WHERE id='".$dbManagerRow['departmentId']."'"; 
        $departmentResult = mysql_query($departmentQuery);
        $departmentRow = mysql_fetch_array($departmentResult);
        
        
        echo "<h2><font color='#0080C0'><center>Τμήμα ".$departmentRow['departmentName']."</center></font></h2>";
        
        if( $departmentRow['id'] == 1 ) {
            $filename = "2012/1_informatics.zip" ;    
        }
        if( $departmentRow['id'] == 2 ) {
            $filename = "2012/2_mech_eng.zip" ;    
        }
        if( $departmentRow['id'] == 3 ) {
            $filename = "2012/3_tpde.zip" ;    
        }
        if( $departmentRow['id'] == 4 ) {
            $filename = "2012/4_geomatics.zip" ;    
        }
        if( $departmentRow['id'] == 6 ) {
            $filename = "2012/6_tde.zip" ;    
        }
        if( $departmentRow['id'] == 7 ) {
            $filename = "2012/7_tlog.zip" ;    
        }
        if( $departmentRow['id'] == 11 ) {
            $filename = "2012/11_EASDA.zip" ;    
        }
		if( $departmentRow['id'] == 12 ) {
            $filename = "2012/12_xenesglosses.zip" ;    
        }


    ?>     
    <br><br><br>   
            <table cellspacing="10" border="" align="center">
                <tr>
                    <th align="center" colspan="4"><font size="3">Αιτήσεις</font></th>
                </tr>
                <tr>
                    <td>
                        <button style="height: 110px; width: 120px"  type="button" onclick="location.href='?option=com_content&view=article&id=73'">
                        <img width="70" height="70" src="/ees_request/images/stories/cancel_app.png" alt="Ακύρωση Αίτησης"/>
                        <br />Ακύρωση Αίτησης</button>
                    </td>
                    <td>
                        <button style="height: 110px; width: 125px"  type="button" onclick="location.href='?option=com_content&view=article&id=75'">
                        <img  width="70" height="70" src="/ees_request/images/stories/statistics.png" alt="Στατιστικά Αιτήσεων" />
                        <br /> <font size="2">Στατιστικά Αιτήσεων</font></button>
                    </td>
                    <td>
                        <button style="height: 110px; width: 125px" type="button" onclick="location.href='?option=com_content&view=article&id=76'">
                        <img  width="70" height="70" src="/ees_request/images/stories/download.png" alt="Λήψη Αιτήσεων" />
                        <br /> <font size="2">Λήψη Αίτησης</font></button>
                    </td>
                </tr>
            </table>  
            <br>  
            <table cellspacing="10" border="" align="center">
                <tr>
                    <th align="center" colspan="2"><font size="3">Αξιολόγηση</font></th>
                </tr>
                <tr>
                    <td>
                        <button style="height: 100px; width: 150px" width="80" height="80" type="button" onclick="location.href='?option=com_content&view=article&id=72'">
                        <img width="70" height="70" src="/ees_request/images/stories/create_xls.png" alt="Δημιουργία Αρχείων Αξιολόγησης"/>
                        <br />Δημιουργία Αρχείων</button>
                    </td>
                    <td>
                        <button style="height: 100px; width: 150px" width="80" height="80" type="button" onclick="location.href='externalpages/dba/application/xls/<?php echo $filename;?>'">  
                        <img  width="70" height="70" src="/ees_request/images/stories/download.png" alt="Λήψη Αρχείων Αρχείων Αξιολόγησης" />
                        <br /> <font size="2">Λήψη Αρχείων</font></button>
                    </td>
                </tr>
            </table>  
              
    <?php    
    
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>