<html>
<?php
	require_once ("seo.php"); 						        // Capçalera amb els tag i els arxius de css, js, títol, i scripts necesaris.
	require_once ("funcions/conectar_db.php");				// Cadena de conexió amb la base de dades.
	require_once ("funcions/funcions_generals.php");		// Funcions PHP necesaries.

	error_reporting(0);
	$Id = $_GET['id'];
	$Idioma = $_SESSION['idioma'];
	$_SESSION['pagina'] = $_SERVER['PHP_SELF'] . '?id=' . $Id ; 
	
	$db = conectaDB();
	$Sql = "SELECT * FROM curriculum WHERE id =". $Id;
	$result = $db->query($Sql);
	if (!$result) {
    //	print "  <p>Error en la consulta.</p>\n";
	} else {
    	foreach ($result as $row) {
       		switch ($Idioma) 
    			{
    				case 'ca':
						$Dtel =  '<i class="text-primary">Tel&egrave;fon</i>';
						$Doff =   '<i class="text-primary">Despatx</i>';
		   				$Descr = $row['ca'];
						$DContact = 'CONTACTE';
		   				break;
					case 'es':
						$Dtel =   '<i class="text-primary">Telefono</i>';
						$Doff =   '<i class="text-primary">Despacho</i>';
		   				$Descr = $row['es'];
						$DContact = 'CONTACTO';
		   				break;
					case 'en':
						$Dtel =  '<i class="text-primary">Phone</i>';
						$Doff =   '<i class="text-primary">Office</i>';
		   				$Descr = $row['en'];
						$DContact = 'CONTACT';
		   				break;
					default:
						$Dtel =   '<i class="text-primary">Tel&egrave;fon</i>';
						$Doff =   '<i class="text-primary">Despatx</i>';
						$Descr = $row['ca'];
						$DContact = 'CONTACTE';
		   				break;
				}
				$Foto = $row['link_foto'];
 		}
	}
 	$db = null;
	
	$db2 = conectaDB();
	$Sql2 = "SELECT * FROM docent WHERE id =" . $Id;
	$result2 = $db2->query($Sql2);	
	foreach ($result2 as $row2) {
		$Nom = $row2['nom'];
		$Telefon = $row2['telefon'];
		$Email = $row2['email'];
		switch ($Idioma) 
    			{
    				case 'ca':
		   				$Descr2 = $row2['ca'];
		   				break;
					case 'es':
		   				$Descr2 = $row2['es'];
		   				break;
					case 'en':
		   				$Descr2 = $row2['en'];
		   				break;
					default:
						$Descr2 = $row2['ca'];
		   				break;
				}	
		$Despatx = $row2['despatx'];					
	}
	$db2 = null;
						
?>

	<body style="background:#999999;" >
    	<div id="preloader">
    		<div id="loader">&nbsp;</div>
    	</div>
    	<div class="container" id="base_pagina" >
			<?php include("idiomes.php");?>
    		<div class="masthead">
				<!-- ************* CAPÇALERA *********** -->
        		<?php include("header.php");?>
				<!-- ************ MENU ************** -->
       			<?php include("menu.php");?>
      		</div>
			<!-- ***************** CENTRE ********************* -->
			<div class="row">
				
                <div class="col-lg-3" align="left">
					
					<div align="center">
						<img src="imatges/varies/professors/<?php echo $Foto;?>" width="150px" >
						<br>
						<?php 								
						   echo '<p><h6><strong>' . $Descr2 . '</strong></h6><hr>';					  
						   echo '</div>';?>
						   <p class="bg-primary" id="titols"><?php echo $DContact;?></p>
						<?php   echo ''. $Dtel . ' ' . $Telefon . '<br>';
						   echo ''. $Doff . ' ' . $Despatx . '<br>';
						   echo '<strong><a href="mailto:' . $Email .'">' . $Email . '</a></strong></p>';
						?>
					
				</div>
				<div class="col-lg-8">
				  <h3><p class="text-primary"><?php echo NomDocent($Id);?></p></h3>
				 
                <p><?php echo htmlspecialchars_decode($Descr);?></p> 
				<hr>
				<a href="personal_docent.php"><button class="btn btn-default"><i class="fa fa-reply text-primary" aria-hidden="true"> </i></button></a>
				</div>
                <div class="col-lg-1"></div>
			</div>
     		<!-- *************** FI CENTRE  ******************* -->
			<br>
			<!-- ************** PEU DE PAGINA *************** -->
       		<?php include("footer.php");?>
    	</div> <!-- /container -->
	</body>
</html>



