Affichage historique des membres

<?php
class Repetition_class {
	
	private $id_repetition;
	private $date_repetition;
    private $present_repetition;
	
	private $bdd;
	
	public function __construct($id_repetition, $date_repetition, $present_repetition) {
		
		$this->id_repetition			= $id_repetition;
		$this->date_repetition		= $date_repetition;
		$this->present_repetition 	= $present_repetition;
		
		$this->bdd 					= bdd();
	}
//**********************************************************************************************************
	public function ChampsVideAjoutRepetition() {
		return(empty($this->date_repetition) || empty($this->present_repetition)) ? true : false;		
	}
	
	public function DateExist() {
		$sql = "SELECT *
				FROM  tb_presence_repetition
				WHERE date_repetition = :date_repetition";
		$requete = $this->bdd->prepare($sql);
		$requete->execute(array('date_repetition' => $this->date_repetition));
		$resultat = $requete->fetch();		
		return $resultat;
	}
	
	public function VerifAjoutRepetition() {
		
		if($this->ChampsVideAjoutRepetition()) {
			$erreur = "Veuillez remplir la date de la Répétition";

		} else if($this->DateExist() > 0 ) {
			$erreur = 'Cette date de répétition existe déjà !';

		} else {
			$erreur = 'success';
		}
		return $erreur;
	}
	
	public function AjoutRepetition() {

			$id_adherent = " - " . implode(" - , - ", $_POST['present_repetition']) . " - ";
			
			$sql = "INSERT INTO tb_presence_repetition(date_repetition, present_repetition)
					VALUES(:date_repetition, :present_repetition)";
			$requete = $this->bdd->prepare($sql);
			$success = $requete->execute(array(
										'date_repetition' 		=> $this->date_repetition,
										'present_repetition' 	=> $id_adherent,
										));
			return $success;
	}
//**********************************************************************************************************
}

<?php
	$sql = "SELECT present_repetition, date_repetition, DATE_FORMAT(date_repetition, '%Y') AS date_present_repetition
			FROM tb_presence_repetition";
	$requete = $bdd->prepare($sql);
	$requete->execute();
	
echo "<div class='ui-accordion'>";

$donnees = $requete->fetch();
?>

<h3 class='ui-accordion-header'><a href='#'><?php echo $donnees['date_present_repetition']; ?></a></h3>
	<div class='ui-accordion-content'>
		<p class='PresentRepetition'>
			<li>
				<span class='colonne01-PresentRepetition'><?php echo $donnees['present_repetition']; ?>
				</span>
			</li>
		</p>
		
<?php

$anneecourante = $donnees['date_present_repetition'];

while ($donnees = $requete->fetch()) {

	if ($donnees['date_present_repetition'] != $anneecourante) {
?>
	</div>
	
<h3 class='ui-accordion-header'><a href='#'><?php echo $donnees['date_present_repetition']; ?></a></h3>
	<div class="ui-accordion-content">
		<p class='PresentRepetition'>
			<li>
				<span class='colonne01-PresentRepetition'><?php echo $donnees['present_repetition']; ?>
				</span>
			</li>
		</p>
	
<?php		
	} else {
?>
		<p class='PresentRepetition'>
			<li>
				<span class='colonne01-PresentRepetition'><?php echo $donnees['present_repetition']; ?>
				</span>
			</li>
		</p>

<?php

	}
	$anneecourante = $donnees['date_present_repetition'];
}
?>
	</div>
</div>

<?php
if(isset($_POST['action'])) {
	
	$id_date_repetition		= isset($_REQUEST['id_date_repetition']) ? $_REQUEST['id_date_repetition'] : '';
    $date_repetition			= isset($_POST['alt_date_repetition']) ? $_POST['alt_date_repetition'] : '';
	$id_presence_repetition	= isset($_POST['id_presence_repetition']) ? $_POST['id_presence_repetition'] : '';
	$rid_adherent				= isset($_POST['rid_adherent']) ? $_POST['rid_adherent'] : '';
	$rid_date_repetition		= isset($_POST['rid_date_repetition']) ? $_POST['rid_date_repetition'] : '';

	$PresentRepetition = new Present_Repetition_class($id_date_repetition, $date_repetition, $id_presence_repetition, $rid_adherent, $rid_date_repetition);
	$VerifAjoutDateRepetition = $PresentRepetition->VerifAjoutDateRepetition();
	
	if($VerifAjoutDateRepetition == 'success') {
		
		if($PresentRepetition->AjoutPresentRepetition()) {
			$success_info[] = "L'enregistrement c'est bien effectué";
		} else {
			$erreur_info[] = "Une erreur est survenue";
		}
		
	} else {
		$erreur_info[] = $VerifAjoutDateRepetition;
	}	
}

if (isset($erreur_info)) {
	echo erreurs($erreur_info);
}
if (isset($success_info)) {
	echo success($success_info);
}
?>

<div id="PresentRepetition">
	<form id="formulaire" action="" method="post">
		<span style="float: right";>Date de la Répétition
			<input name="date_repetition" id="date_repetition" class="PresentRepetition" size="30" type="text" value="">
			<input type="hidden" id="alt_date_repetition" name='alt_date_repetition'>
		</span>
			<table cellpadding="0" cellspacing="1">
				<tr>
					<th width="36%">Présent</th>
				</tr>
<?php
	$sql = "SELECT *
			FROM tb_gestion_participant
			LEFT JOIN tb_adherent
				ON tb_adherent.id_adherent = tb_gestion_participant.rid_adherent
			WHERE actif = 1
			AND participant_repetition = 1
			ORDER BY nom, prenom ASC";
	$requete = $bdd->prepare($sql);
	$requete->execute();
		
	while($donnees = $requete->fetch()) {
				
			echo'<tr>';
				echo'<td width="30%">';
					echo'<input type="checkbox" name="rid_adherent[]" class="styled" value=" '.$donnees['id_adherent'].' " />';
					echo'<label for="id">' .$donnees['nom'] . ' ' . $donnees['prenom']. '</label>';
				echo'</td>';
			echo'</tr>';
	}
?>
			</table>
				<input name="action" value="ajouter" type="hidden" />
				<a href="javascript:void(0)"><input type="submit" class="submit" value="Enregistrer"/></a>
			
	</form>					
</div>
	

echo'<input type="checkbox" name="rid_adherent" class="styled" value=" '.$donnees['id_adherent'].' " />';

ADHERENTS--0,n---(Assister à)---0,n--REPETITIONS
                     `----------0,n--DATES

ADHERENTS:
+-----+--------+----------+-----+
|idadh|    nom |   prenom | etc |
+-----+--------+----------+-----+
|   1 | MARTIN | Jean     | ... |
|   2 | DUPONT | Isabelle | ... |
|   3 | DUVAL  | Denis    | ... |
| ... | ...    | ...      | ... |

REPETITIONS:
+-----+------------------------+-----+
|idrep|         sujet          | etc |
+-----+------------------------+-----+
|   1 | Beethoven 5°S 1er mvt  | ... |
|   2 | Beethoven 5°S 2ème mvt | ... |
|   3 | Mozart 40°S 1er mvt.   | ... |
|   4 | Mozart 40°S 2ème mvt.  | ... |
| ... | ...                    | ... |

ASSISTER:
+------------+-----+-----+---------+-----+
|    date    |idrep|idadh|   obs   | etc |
+------------+-----+-----+---------+-----+
| 2015-01-09 |   1 | 119 | ... ... | ... |
| 2015-01-09 |   1 |   3 | ... ... | ... |
| 2015-01-09 |   1 | 176 | ... ... | ... |
| 2015-01-16 |   2 | 119 | ... ... | ... |
| 2015-01-16 |   2 | 175 | ... ... | ... |
| 2015-01-16 |   2 | 126 | ... ... | ... |