_bdd = $bdd;
}
/**
* Renvoit les informations concernant un forum
*
* @param int $id Identifiant du forum
* @param string $champs Champs à renvoyer
* @access public
* @return array
*/
function obtenir($id, $champs = '*')
{
$requete = 'SELECT';
$requete .= ' ' . $champs . ', annee as forum_annee ';
$requete .= 'FROM';
$requete .= ' afup_forum ';
$requete .= 'WHERE id=' . $id;
return $this->_bdd->obtenirEnregistrement($requete);
}
function supprimable($id)
{
$requete = 'SELECT';
$requete .= ' f.id, count(session_id) as sessions,count(i.id) as inscriptions ';
$requete .= 'FROM';
$requete .= ' afup_forum f ';
$requete .= 'LEFT JOIN afup_sessions s ON (f.id = s.id_forum) ';
$requete .= 'LEFT JOIN afup_inscription_forum i ON (f.id = i.id_forum) ';
$requete .= 'WHERE f.id=' . $id;
$forum = $this->_bdd->obtenirEnregistrement($requete);
return $forum['sessions'] == 0 && $forum['inscriptions'] == 0;
}
function obtenirNombrePlaces($id = NULL)
{
if (empty($id)) {
$id = $this->obtenirDernier();
}
$enregistrement = $this->obtenir($id, 'nb_places');
return $enregistrement['nb_places'];
}
function obtenirDebut($id_forum)
{
$requete = 'SELECT UNIX_TIMESTAMP(date_debut)';
$requete .= 'FROM';
$requete .= ' afup_forum ';
$requete .= 'WHERE';
$requete .= ' id = ' . (int)$id_forum;
return $this->_bdd->obtenirUn($requete);
}
function obtenirForumPrecedent($id_forum)
{
$requete = 'SELECT MAX(id)';
$requete .= 'FROM';
$requete .= ' afup_forum ';
$requete .= 'WHERE';
$requete .= ' id < ' . (int)$id_forum . ' AND titre like "%Forum%"';
return $this->_bdd->obtenirUn($requete);
}
function obtenirDernier()
{
$requete = 'SELECT id ';
$requete .= 'FROM afup_forum ';
$requete .= 'ORDER BY date_debut desc';
return $this->_bdd->obtenirUn($requete);
}
/**
* Renvoit la liste des inscriptions à facturer ou facturé au forum
*
* @param string $champs Champs à renvoyer
* @param string $ordre Tri des enregistrements
* @param bool $associatif Renvoyer un tableau associatif ?
* @access public
* @return array
*/
function obtenirListe($id_forum = null,
$champs = '*',
$ordre = 'titre',
$associatif = false,
$filtre = false)
{
$requete = 'SELECT';
$requete .= ' ' . $champs . ' ';
$requete .= 'FROM';
$requete .= ' afup_forum ';
$requete .= 'ORDER BY ' . $ordre;
if ($associatif) {
return $this->_bdd->obtenirAssociatif($requete);
} else {
return $this->_bdd->obtenirTous($requete);
}
}
function afficherDeroulementMobile($sessions)
{
$deroulement = "";
$jour = 0;
$heure = 0;
foreach ($sessions as $session) {
if ($jour != mktime(0, 0, 0, date("m", $session['debut']), date("d", $session['debut']), date("Y", $session['debut']))) {
$jour = mktime(0, 0, 0, date("m", $session['debut']), date("d", $session['debut']), date("Y", $session['debut']));
$deroulement .= "
" . ($jour > 10000 ? date("d/m/Y", $jour) : 'Jour à définir') . "
";
}
if ($heure != $session['debut']) {
$heure = $session['debut'];
$deroulement .= "
" . date("H\hi", $heure) . "
";
}
$classes = array("deroulement");
$classes[] = $session['journee'];
if ($session['keynote'] == 1) {
$classes[] = "keynote";
}
$conferenciers = $session['conf1'];
if (!empty($session['conf2'])) {
$conferenciers .= "
" . $session['conf2'];
}
$deroulement .= "
";
$deroulement .= "
";
$deroulement .= "
" . $conferenciers . "
";
$deroulement .= "
" . $session['nom_salle'] . "
";
$deroulement .= "
";
}
$deroulement .= "
";
$jour = 0;
$heure = 0;
foreach ($sessions as $session) {
if ($jour != mktime(0, 0, 0, date("m", $session['debut']), date("d", $session['debut']), date("Y", $session['debut']))) {
$jour = mktime(0, 0, 0, date("m", $session['debut']), date("d", $session['debut']), date("Y", $session['debut']));
$deroulement .= "
" . ($jour > 10000 ? date("d/m/Y", $jour) : 'Jour à définir') . "
";
}
if ($heure != $session['debut']) {
$heure = $session['debut'];
$deroulement .= "
" . date("H\hi", $heure) . "
";
}
$classes = array("deroulement");
$classes[] = $session['journee'];
if ($session['keynote'] == 1) {
$classes[] = "keynote";
}
$conferenciers = $session['conf1'];
if (!empty($session['conf2'])) {
$conferenciers .= "
" . $session['conf2'];
}
$deroulement .= "
";
$deroulement .= "
";
$deroulement .= "
" . $conferenciers . "
";
$deroulement .= "
";
}
$deroulement .= "
";
$agenda .= "
" . date("d/m/Y", $jour) . "
";
foreach ($slots_avec_salle as $salle => $slots_avec_horaire) {
foreach ($slots_avec_horaire as $debut => $session) {
$classes = array("slot");
$classes[] = $session['journee'];
$conferenciers = $session['conf1'];
if (!empty($session['conf2'])) {
$conferenciers .= "
" . $session['conf2'];
}
$styles = array("position: absolute;");
if ($session['keynote'] == 1) {
$classes[] = "keynote";
$styles[] = "width: 100%;";
$styles[] = "left: 0%;";
} else {
$styles[] = "width: " . round(100 / $nb_salles) . "%;";
$styles[] = "left: " . ($salles[$session['id_salle']] * round(100 / $nb_salles)) . "%;";
}
$styles[] = "height: " . round(($session['fin'] - $session['debut']) / 19) . "px;";
$styles[] = "top: " . round(40 + $passage_jour * 1600 + ($session['debut'] - $debuts[$jour]) / 19) . "px;";
$agenda .= "
";
$agenda .= "
";
$agenda .= "
" . $conferenciers . "
";
$agenda .= "
" . date("H\hi", $session['debut']) . " - " . date("H\hi", $session['fin']) . "
";
$agenda .= "
";
}
}
$agenda .= "
$2
', $infoSeance);
return $lien;
}
function genAgenda($annee, $for_bo = false, $only_data = false, $forum_id = null, $linkFormat = null)
{
$aAgenda = $this->obtenirAgenda($annee, $forum_id);
if (isset($aAgenda) && count($aAgenda) > 0) {
$nbConf = count($aAgenda);
$nomSalles = array();
$j = 0;
$d = null;
$aProgramme = array();
foreach ($aAgenda as $index => $session) {
if (!isset($nomSalles[$session['id_salle']])) {
$nomSalles[$session['id_salle']] = $session['nom'];
}
$dj = $session['jour'];
if ($dj != $d) {
$j++;
$d = $dj;
$aProgramme[$dj] = array();
}
if (!isset($aProgramme[$dj][$session['debut'] . "-" . $session['fin']])) {
$aProgramme[$dj][$session['debut'] . "-" . $session['fin']] = array();
}
if (!isset($aProgramme[$dj][$session['debut'] . "-" . $session['fin']][$session['nom']])) {
$aProgramme[$dj][$session['debut'] . "-" . $session['fin']][$session['nom']] = array();
}
$aProgrammeData[$dj][$session['debut'] . "-" . $session['fin']][] = $session;
$aProgramme[$dj][$session['debut'] . "-" . $session['fin']][$session['nom']][] = $session['session_id'] . " : " . $session['titre'] . (' ' . $session['conf1'] . ($session['conf2'] ? (' / ' . $session['conf2']) : '') . '');
//$aProgramme[$dj][$session['debut'] ."-". $session['fin']][$session['nom']][] = array('id'=>$session['session_id'], 'titre'=> $session['titre'],'conf1'=> $session['titre'],'titre'=> $session['titre']);
}
//var_dump($aProgrammeData['12-11-2009']);die;
if ($only_data) {
return $aProgrammeData;
}
$nbSalles = count($nomSalles);
$tdWith = round(84 / $nbSalles);
//
$sTable = '';
$j = 1;
$aRowSpan = array();
/* On boucle sur chaque journée du programme. */
foreach ($aProgramme as $journee => $aInfos) {
$journee_aff = date('d/m/Y', strtotime($journee));
$sTable .= <<
| |
CODE_HTML;
$s = 1;
$confNumber = 0;
foreach ($nomSalles as $idSalle => $nomSalle) {
$sTable .= <<{$nomSalle}
CODE_HTML;
$aRowSpan[$idSalle] = 0;
$s++;
}
$sTable .= <<
CODE_HTML;
/* On boucle maintenant sur chaque demi-heure de l'agenda (de 08h00 à 18h00 */
for ($h = 8; $h < 18; $h++) {
for ($i = 0; $i < 12; $i++) {
$bKeynote = false;
$m = sprintf('%02d', 5 * $i);
$m_next = sprintf('%02d', (5 * ($i + 1)) % 60);
$style = ($i % 2 == 0) ? 'lp' : 'li';
$sHeure = ($h < 10) ? '0' . $h : $h;
$h_next = ($i < 11) ? $h : $h + 1;
$sHeure_next = ($h_next < 10) ? '0' . $h_next : $h_next;
/* Création de la ligne avec la cellule indiquant l'heure */
$sTable .= <<
{$sHeure}h{$m} - {$sHeure_next}h{$m_next} |
CODE_HTML;
/* On cherche les scéances commençant à cette heure pour chaque salle. */
foreach ($nomSalles as $idSalle => $nomSalle) {
/* On vérifie qu'on est pas déjà sur une scéance commencée à un tour précédent. */
if ($aRowSpan[$idSalle] <= 1):
$bSeance = false;
$rs = null;
/* Calcul du nombre de lignes occupées par la scéance s'il y en a une. */
for ($c = 0; $c < $nbConf; $c++):
//var_dump($aAgenda[$c]);
if (
$aAgenda[$c]['debut'] == $sHeure . ":" . $m &&
$aAgenda[$c]['id_salle'] == $idSalle &&
$aAgenda[$c]['jour'] == $journee
):
/* Si on toruve une scéance, on ne mettra pas de cellule vide. */
$bSeance = true;
$bKeynote = $aAgenda[$c]['keynote'];
$colspan = $bKeynote ? ' colspan="' . $nbSalles . '" class="keynote" ' : '';
$heures = $aAgenda[$c]['debut'] . "-" . $aAgenda[$c]['fin'];
$nl = $this->dureeSeance($heures);
$aRowSpan[$idSalle] = $nl;
$class = 'conf conf_' . ($confNumber % 2 === 0 ? 'odd' : 'even');
$rs = ($nl > 1) ? ' rowspan="' . $nl . '"' : null;
$nbSeances = (isset($aInfos[$heures][$nomSalle])) ? count($aInfos[$heures][$nomSalle]) : 0;
if ($nbSeances > 0):
$conflit = $nbSeances > 1 ? ' style="color: inherit; background-color: #f99"' : null;
$sTable .= <<
CODE_HTML;
for ($sc = 0; $sc < $nbSeances; $sc++):
$lien = $this->lienSeance($aInfos[$heures][$nomSalle][$sc], $for_bo, $linkFormat);
//$lien = '$2
';
$sTable .= $lien;
endfor;
$sTable .= "";
$confNumber++;
endif;
break;
endif;
endfor;
if (in_array($sHeure . '_' . $m . '_' . $journee, array('17_00_12-11-2009', '10_30_12-11-2009'))) {
$bKeynote = true;
}
if (false === $bSeance && !$bKeynote):
$sTable .= " | ";
endif;
else:
$aRowSpan[$idSalle]--;
endif;
}
$sTable .= " ";
}
}
$sTable .= <<
CODE_HTML;
$j++;
}
} else {
// Aucune donnée dans la base. Affichage alternatif.
$sTable = <<Aucune entrée disponible.
CODE_HTML;
}
return $sTable;
}
function obtenirCsvJoindIn($id_forum)
{
$id_forum = $this->_bdd->echapper($id_forum);
// Récupération des données
$requete = "
SELECT afup_sessions.titre, afup_sessions.abstract, afup_sessions.genre, afup_sessions.journee,
DATE_FORMAT(FROM_UNIXTIME(afup_forum_planning.debut), '%Y-%m-%d') AS date,
DATE_FORMAT(FROM_UNIXTIME(afup_forum_planning.debut), '%H:%i') AS heure,
afup_forum_planning.keynote,
(SELECT CONCAT(afup_conferenciers1.prenom, ' ', afup_conferenciers1.nom)
FROM afup_conferenciers_sessions AS afup_conferenciers_sessions
INNER JOIN afup_conferenciers AS afup_conferenciers1 ON afup_conferenciers1.conferencier_id = afup_conferenciers_sessions.conferencier_id
WHERE afup_conferenciers_sessions.session_id = afup_sessions.session_id
LIMIT 0,1) AS conferencier1,
(SELECT CONCAT(afup_conferenciers2.prenom, ' ', afup_conferenciers2.nom)
FROM afup_conferenciers_sessions AS afup_conferenciers_sessions
INNER JOIN afup_conferenciers AS afup_conferenciers2 ON afup_conferenciers2.conferencier_id = afup_conferenciers_sessions.conferencier_id
WHERE afup_conferenciers_sessions.session_id = afup_sessions.session_id
LIMIT 1,1) AS conferencier2
FROM afup_sessions
INNER JOIN afup_forum_planning ON afup_forum_planning.id_session = afup_sessions.session_id
WHERE afup_sessions.id_forum = $id_forum AND afup_sessions.plannifie = 1;";
$donnees = $this->_bdd->obtenirTous($requete);
// Génération des données CSV
$csv = "Title,Description,Speaker,Date,Time,Type\n";
foreach ($donnees as $conference) {
// Gestion de la description
$description = html_entity_decode($conference['abstract'], null, 'UTF-8');
$description = strip_tags($description);
$description = str_replace('"', '\"', $description);
// Gestion des conférenciers
$conferenciers = array();
for ($i = 1; $i <= 2; $i++) {
if (!empty($conference['conferencier' . $i]) &&
'En cours de validation' != trim($conference['conferencier' . $i])
) {
$conferenciers[] = $conference['conferencier' . $i];
}
}
if (empty($conferenciers)) {
$conferenciers[] = '-';
}
$conferenciers = implode(',', $conferenciers);
// Gestion du type de conférence
if (1 == $conference['keynote']) {
$type = 'Keynote';
} elseif (2 == $conference['genre']) {
$type = 'Workshop';
} else {
$type = 'Talk';
}
$csv .= sprintf(
"\"%s\",\"%s\",\"%s\",\"%s\",\"%s\",\"%s\"\n",
$conference['titre'],
$description,
$conferenciers,
$conference['date'],
$conference['heure'],
$type
);
}
return $csv;
}
function ajouter(
$titre,
$nb_places,
$date_debut,
$date_fin,
$date_fin_appel_projet,
$date_fin_appel_conferencier,
$date_fin_vote,
$date_fin_prevente,
$date_fin_vente,
$date_fin_saisie_repas_speakers,
$date_fin_saisie_nuites_hotel,
$date_annonce_planning,
$chemin_template,
array $text,
$trello_list_id,
$logoUrl,
$placeName,
$placeAddress,
$voteEnabled = true,
$speakersDinerEnabled = true,
$accomodationEnabled = true,
$waitingListUrl = null
) {
$requete = 'INSERT INTO ';
$requete .= ' afup_forum (id, titre, nb_places, date_debut, date_fin, annee, date_fin_appel_projet,';
$requete .= ' date_fin_appel_conferencier, date_fin_vote, date_fin_prevente, date_fin_vente, date_fin_saisie_repas_speakers, date_fin_saisie_nuites_hotel, date_annonce_planning, path, `text`, `trello_list_id`,
`logo_url`, `place_name`, `vote_enabled`, `speakers_diner_enabled`, `accomodation_enabled`, `waiting_list_url`, `place_address`) ';
$requete .= 'VALUES (null,';
$requete .= $this->_bdd->echapper($titre) . ',';
$requete .= (int)$nb_places . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_debut) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin) . ',';
$requete .= (int)$date_debut['Y'] . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_appel_projet, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_appel_conferencier, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_vote, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_prevente, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_vente, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_saisie_repas_speakers, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_fin_saisie_nuites_hotel, true) . ',';
$requete .= $this->_bdd->echapperSqlDateFromQuickForm($date_annonce_planning, true) . ',';
$requete .= $this->_bdd->echapper($chemin_template, true) . ',';
$requete .= $this->_bdd->echapper(json_encode($text)) . ', ';
$requete .= $this->_bdd->echapper($trello_list_id) . ',';
$requete .= $this->_bdd->echapper($logoUrl) . ',';
$requete .= $this->_bdd->echapper($placeName) . ',';
$requete .= $this->_bdd->echapper($voteEnabled ? 1 : 0) . ',';
$requete .= $this->_bdd->echapper($speakersDinerEnabled ? 1 : 0) . ',';
$requete .= $this->_bdd->echapper($accomodationEnabled ? 1 : 0) . ',';
$requete .= $this->_bdd->echapper($waitingListUrl) . ',';
$requete .= $this->_bdd->echapper($placeAddress);
$requete .= ')';
return $this->_bdd->executer($requete);
}
function modifier(
$id,
$titre,
$nb_places,
$date_debut,
$date_fin,
$date_fin_appel_projet,
$date_fin_appel_conferencier,
$date_fin_vote,
$date_fin_prevente,
$date_fin_vente,
$date_fin_saisie_repas_speakers,
$date_fin_saisie_nuites_hotel,
$date_annonce_planning,
$chemin_template,
array $text,
$trello_list_id = null,
$logoUrl = null,
$placeName = null,
$placeAddress = null,
$voteEnabled = true,
$speakersDinerEnabled = true,
$accomodationEnabled = true,
$waitingListUrl = null
) {
$requete = 'UPDATE ';
$requete .= ' afup_forum ';
$requete .= 'SET';
$requete .= ' titre=' . $this->_bdd->echapper($titre) . ',';
$requete .= ' nb_places=' . (int)$nb_places . ',';
$requete .= ' date_debut=' . $this->_bdd->echapperSqlDateFromQuickForm($date_debut) . ',';
$requete .= ' date_fin=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin) . ',';
$requete .= ' annee=' . (int)$date_debut['Y'] . ',';
$requete .= ' date_fin_appel_projet=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_appel_projet, true) . ',';
$requete .= ' date_fin_appel_conferencier=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_appel_conferencier, true) . ',';
$requete .= ' date_fin_vote=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_vote, false) . ',';
$requete .= ' date_fin_prevente=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_prevente, true) . ',';
$requete .= ' date_fin_vente=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_vente, true) . ',';
$requete .= ' date_fin_saisie_repas_speakers=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_saisie_repas_speakers, true) . ',';
$requete .= ' date_fin_saisie_nuites_hotel=' . $this->_bdd->echapperSqlDateFromQuickForm($date_fin_saisie_nuites_hotel, true) . ',';
$requete .= ' date_annonce_planning=' . $this->_bdd->echapperSqlDateFromQuickForm($date_annonce_planning, true) . ',';
$requete .= ' path=' . $this->_bdd->echapper($chemin_template, true) . ', ';
$requete .= ' `text` = ' . $this->_bdd->echapper(json_encode($text)) . ', ';
$requete .= ' `trello_list_id` = ' . $this->_bdd->echapper($trello_list_id) . ',';
$requete .= ' `logo_url` = ' . $this->_bdd->echapper($logoUrl) . ', ';
$requete .= ' `place_name` = ' . $this->_bdd->echapper($placeName) . ', ';
$requete .= ' `vote_enabled` = ' . $this->_bdd->echapper($voteEnabled ? 1 : 0) . ', ';
$requete .= ' `speakers_diner_enabled` = ' . $this->_bdd->echapper($speakersDinerEnabled ? 1 : 0) . ', ';
$requete .= ' `accomodation_enabled` = ' . $this->_bdd->echapper($accomodationEnabled ? 1 : 0) . ', ';
$requete .= ' `waiting_list_url` = ' . $this->_bdd->echapper($waitingListUrl) . ',';
$requete .= ' `place_address` = ' . $this->_bdd->echapper($placeAddress) . ' ';
$requete .= 'WHERE';
$requete .= ' id=' . $id;
return $this->_bdd->executer($requete);
}
function supprimer($id_forum)
{
$id_forum = $this->_bdd->echapper($id_forum);
$requete = 'DELETE FROM afup_forum WHERE id = ' . $id_forum;
return $this->_bdd->executer($requete);
}
}