//Page d'index par default pour les utilisateurs loguésfunction 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>';}