//Page d'index par default pour les utilisateurs logués
function afficherIndex() {
	
	echo '<div id="content">';
	echo '<h2>Accueil</h2>';
	echo '<br/>';
	
	include('config/config.inc.php');
	$site = new Site($cfg['title'], $cfg['default_skin'], $cfg['lang']);
		
	$MySQL = new Mysql($cfg['url'], $cfg['user'], $cfg['password'], $cfg['table'], $cfg['lang'],$cfg['verbose']);
	
	$MySQL->executionSQL(	'SELECT projet.n_client,nom_client,n_projet, nom_projet, descrip_projet, procedure_projet, YEAR(date_debut_pr) as DebutAAAA,MONTH(date_debut_pr) as DebutMM,dayofmonth(date_debut_pr) as DebutJJ,year(date_fin_pr) as FinAAAA,MONTH(date_fin_pr) as FinMM,dayofmonth(date_fin_pr) as FinJJ,n_statut, n_intervenant' 
						.' FROM projet,clients'
						.' WHERE ( n_statut = 2 OR n_statut= 3)'
						.' AND projet.n_client = clients.n_client'
			
					);
												

	
	//s'il y a des projets non traités ou en cours de traitement on affiche
	if($MySQL->nombreResultat(1) > 0)
	{
		echo '<h3>Projets non traités ou en cours de traitement</h3>';
		echo '<span class="alpha">';
		echo '<table>'."\n";
		echo '<td><th COLSPAN=50>Nom du projet</th><th  COLSPAN=50>Client</th><th  COLSPAN=50 align="center">Statut</th></td>'."\n";
		
		$nombreClient = 2;
		
		for($i=1; $i <= $MySQL->nombreResultat(1); $i++)
		{
			$dataProjet = $MySQL->resultat(1);
			
			//On récupère tout les clients
			$MySQL->executionSQL(		'SELECT *'
							.' FROM clients'
							.' WHERE n_client ='.$dataProjet['n_client']
					);
			
			$data = $MySQL->resultat($nombreClient);
			
			$tmpClient = new Client($data['n_client'], $data['nom_client'], $data['adresse_client'], $data['cp_client'],$data['ville_client'],$data['tel_client'],$data['fax_client'] ,$data['email_client']); 
			
			$ClientSerial = serialize($tmpClient);
			$paramURLClient = urlencode($ClientSerial);
			
			$tmpProjet = new Projet($dataProjet['n_projet'],$dataProjet['nom_projet'],$dataProjet['descrip_projet'],$dataProjet['procedure_projet'],$dataProjet['DebutJJ'],$dataProjet['DebutMM'],$dataProjet['DebutAAAA'],$dataProjet['FinJJ'],$dataProjet['FinMM'],$dataProjet['FinAAAA'],$dataProjet['n_intervenant'],$dataProjet['n_statut'],$tmpClient->getNum());	
		
			//On encode la classe Projet
			$ProjetSerial = serialize($tmpProjet);
			$ProjetDeSerial = urlencode($ProjetSerial);
			
			echo '<tr><td COLSPAN=50><a href="index.php?action=read&cat=projet&numClient='.$tmpClient->getNum().'&idProjet='.$ProjetDeSerial.'">'.$tmpProjet->getNom().'</a></td><td COLSPAN=50>'.$tmpClient->getNom().'</td><td COLSPAN=50 align="center"><img src="template/skin1/'.$tmpProjet->getNumStatut().'.gif"></td></tr>';
			$nombreClient++;
			
		}
		echo '<table>';
		
		$MySQL->executionSQL(	'SELECT nom_projet, intervention.n_client, n_intervention, nom_intervention, descrip_intervention, procedure_intervention, YEAR(date_debut) as DebutAAAA,MONTH(date_debut) as DebutMM,dayofmonth(date_debut) as DebutJJ,year(date_fin) as FinAAAA,MONTH(date_fin) as FinMM,dayofmonth(date_fin) as FinJJ, intervention.n_statut, intervention.n_projet, intervention.n_intervenant' 
							.' FROM intervention, projet'
							.' WHERE (intervention.n_statut = 2 OR intervention.n_statut = 3)'
							.' AND intervention.n_projet = projet.n_projet'
						);
		
		echo '<br/><br/>';
		
		$nombreClient2 = $nombreClient + 1;
		//s'il y a des interventions non traités ou en cours de traitement on affiche
		if($MySQL->nombreResultat($nombreClient) > 0)
		{
			echo '<h3>Interventions non traités ou en cours de traitement</h3>';
			echo '<span class="alpha">';
			echo '<table>'."\n";
			echo '<td><th COLSPAN=50>Nom de l\'intervention</th><th  COLSPAN=50>Projet</th><th  COLSPAN=50 align="center">Client</th><th  COLSPAN=50 align="center">Statut</th></td>'."\n";
			for($i=1; $i <= $MySQL->nombreResultat($nombreClient); $i++)
			{
				$dataIntervention = $MySQL->resultat($nombreClient);
								
				//On récupère tout les clients
				$MySQL->executionSQL(		'SELECT *'
								.' FROM clients'
								.' WHERE n_client ='.$dataIntervention['n_client']
						);
				
				
				
				$dataClient = $MySQL->resultat($nombreClient2);
				$tmpClient = new Client($dataClient['n_client'], $dataClient['nom_client'], $dataClient['adresse_client'], $dataClient['cp_client'],$dataClient['ville_client'],$dataClient['tel_client'],$dataClient['fax_client'] ,$dataClient['email_client']); 

				//echo "Intervention :".$dataIntervention['n_intervention'].' '.$dataClient['n_client'];
				$tmpIntervention = new Intervention($dataIntervention['n_intervention'], $dataIntervention['nom_intervention'], $dataIntervention['descrip_intervention'], $dataIntervention['procedure_intervention'], $dataIntervention['DebutJJ'],$dataIntervention['DebutMM'],$dataIntervention['DebutAAAA'],$dataIntervention['FinJJ'],$dataIntervention['FinMM'],$dataIntervention['FinAAAA'], $dataIntervention['n_statut'], $dataIntervention['n_projet'], $tmpClient->getNum(), $dataIntervention['n_intervenant']);
				
				//On encode la classe Intervention
				$InterventionSerial = serialize($tmpIntervention);
				$InterventionDeSerial = urlencode($InterventionSerial);
				
				echo '<tr><td COLSPAN=50><a href="index.php?action=read&cat=intervention&idIntervention='.$InterventionDeSerial.'">'.$tmpIntervention->getNomIntervention().'</a></td><td COLSPAN=50>'.$dataIntervention['nom_projet'].'</td><td COLSPAN=50 align="center">'.$dataClient['nom_client'].'</td><td COLSPAN=50 align="center"><img src="template/skin1/'.$tmpIntervention->getNumStatut().'.gif"></td></tr>';

				
				$nombreClient2++;
			}
			echo '<table>';
		}
		
	}
	echo '</span>';
	echo '</div>';

	echo '</body>';
}