Skip to content
Extraits de code Groupes Projets
Sélectionner une révision Git
  • afc3b17ae3c5a3ea39ca4f8a3510dbc6c3ccd354
  • master par défaut
2 résultats

timeline.php

Blame
    • Blame
    • Bifurcation depuis ProjetWeb / TimeLine
    Le projet source a une visibilité limitée.
    timeline.php 11,37 Kio 
    <?php

	session_start();

	$annee = $_POST['annee'];
	$name = $_POST['theme'];


    function getThemeSoiree($db, $name, $annee) {

      $stmt = $db->query("SELECT theme FROM soiree WHERE name='$name' AND annee='$annee'");
      $stmt->setFetchMode(PDO::FETCH_OBJ);
      $stmt = $stmt->fetch();
      return $stmt->theme;
    }

    function getIdSoiree($db, $name, $annee) {

      $stmt = $db->query("SELECT idsoiree FROM soiree WHERE name='$name' AND annee='$annee'");
      $stmt->setFetchMode(PDO::FETCH_OBJ);
      $stmt = $stmt->fetch();
      return $stmt->idsoiree;
    }

    function getPhotosSoiree($db, $idsoiree) {

        $stmt = $db->query("SELECT photo.idphoto, photo.extension, photo.composteur, photo.heure, utilisateur.surnom FROM photo INNER JOIN utilisateur ON photo.idposteur=utilisateur.identifiant WHERE idsoiree='$idsoiree' ORDER BY photo.heure ASC");
        $stmt->setFetchMode(PDO::FETCH_NUM);
        $result = $stmt->fetchAll();
        return $result;
    }


    function orderPhoto($tab) {

    	 $avantMinuit = array();
    	 $apresMinuit = array();

    	 foreach ($tab as $pic)
    	{
	    	if( strtotime($pic[3]) < strtotime("12:00:00"))
		 	{
		 		$apresMinuit[] = $pic;
		 	}
		 	else
		 	{
		 		$avantMinuit[] = $pic;
		 	}
		}

    	 $result = array();

    	 foreach ($avantMinuit as $a) 
    	 {
    	 	$result[] = $a;
    	 }
    	 foreach ($apresMinuit as $b) 
    	 {
    	 	$result[] = $b;
    	 }

    	 return $result;

    }


    function printTimeline($tab, $annee, $name, $idsoiree) {

    	// $tab[0] idphoto
    	// 1 extension
        	// 2 com
    	// 3 heure
    	// 4 surnom posteur

    	 $i=0;
    	 foreach ($tab as $pic)
    	 {

    	 	$idphoto=$pic[0];
    	 	$extension=$pic[1];
    	 	$com=$pic[2];
    	 	$surnom=$pic[4];
    	 	$time=$pic[3];
    	 
    	 	$path = "photos/{$annee}/{$name}/{$idphoto}.{$extension}";
    	 	if( ($i%2) == 0 )
    	 	{
    	 		echo "<li>";

				if($i == 0)
				{
				$heure = date("H", strtotime($pic[3]));
				$oldHeure = $heure;

				echo "<button class='button-timeline btn btn-info btn-sm' id='$heure'>";
				echo $heure.' H';
				echo '</button>';
				}
				else
				{
				$oldHeure=$heure;
				$heure=date("H", strtotime($pic[3]));

				if($heure != $oldHeure)
				{
				echo "<button class='button-timeline btn btn-info btn-sm' id='$heure'>";
				echo $heure.' H';
				echo '</button>';
				}
				}
    	 		echo "<div class='timeline-badge primary'><a><i class='glyphicon glyphicon-record' rel='tooltip' title='$time' id=''></i></a></div>";
    	 	}
    	 	else
    	 	{
    	 		echo "<li  class='timeline-inverted'>";

    	 		$oldHeure=$heure;
				$heure=date("H", strtotime($pic[3]));

				if($heure != $oldHeure)
				{
				echo "<button class='button-timeline btn btn-info btn-sm'  id='$heure' >";
				echo $heure.' H';
				echo '</button>';
				}

    	 		echo "<div class='timeline-badge primary'><a><i class='glyphicon glyphicon-record invert' rel='tooltip' title='$time' id=''></i></a></div>";
    	 	}

			echo "<div class='timeline-panel'>";
			echo "<div class='timeline-heading'>";
			echo "<img class='img-responsive' src='$path' id='$idphoto' idsoiree='$idsoiree' data-toggle='modal' data-target='#myModal'/>";
			echo '</div>';
			echo "<div class='timeline-body'>";
			echo "<blockquote><p>".$com."</p><footer>D'après ".$surnom."</footer></blockquote>";
			echo "</div>";
			// echo "<div class='timeline-footer'>";
			// echo "<a><i class='glyphicon glyphicon-thumbs-up'></i></a>";
			// echo "<a><i class='glyphicon glyphicon-share'></i></a>";
			// echo "<a class='pull-right'>Postée par ".$surnom."</a>";
    			// echo "</div>";
			echo "</div>";
			echo "</li>";
			$i=$i+1;
    	 }
    	
          
    }

    function printSideBar ($tab) {

        $i=0;
        foreach ($tab as $pic) 
        {
            if($i == 0)
            {
                $heure = date("H", strtotime($pic[3]));
                $oldHeure = $heure;

                echo "<li><button class='scroll-button' id='b_".$heure."'>".$heure." H</button><li>";
                
            }
            else
            {
                $oldHeure=$heure;
                $heure=date("H", strtotime($pic[3]));

                if($heure != $oldHeure)
                   echo "<li><button class='scroll-button' id='b_".$heure."'>".$heure." H</button><li>";
            }
            $i=$i+1;

        }

    }    
    try{

      /* Connexion à la base de données avec PDO */

       $DB = new PDO("pgsql:host=localhost;dbname=projet_web", "postgres", "root");

       $theme = getThemeSoiree($DB,$name,$annee);
       $idsoiree = getIdSoiree($DB,$name,$annee);

       $tabPhotos = getPhotosSoiree($DB,$idsoiree);

       $tabOrd = orderPhoto($tabPhotos);

       $DB = null;
    	


    }

    catch(PDOException $e){
       echo "Database Error";
    }

?>

<!DOCTYPE html >
<html lang="fr">
  <head>
    <meta charset="utf-8"/>

    
    <link rel="shortcut icon" href="fonts/icone.ico">
    <title>TIMELINE</title>

    <!-- pour les moteurs de recherche -->
        <meta name="description" lang="fr" content="plateforme de timeline photo pour soirée et évènement" />
    <meta name="keywords" lang="fr" content="photos, soirée, timeline, ENSIIE, iiens" />

	<!-- Latest compiled and minified CSS -->
	<link rel="stylesheet" href="css/bootstrap.css">

	<!-- fichier css menu -->
	<link rel="stylesheet" href="css/menu.css">

	<!-- fichier css mise en page timeline -->
	<link rel="stylesheet" type="text/css" href="css/timeline.css">

    <link rel="stylesheet" type="text/css" href="css/modal.css">

  
</head>

<body>

	<?php include 'header2.php'; ?>

  <!-- menu gauche -->
  <div id="lmenu" class="container-fluid">
  <div class="row">
        <div class="col-sm-2 col-md-1 sidebar">

          <ul class="nav nav-sidebar ss-links">
                <?php printSideBar($tabOrd); ?>
          </ul>
          
        </div>

        <div class="col-sm-10 col-sm-offset-2 col-md-11 col-md-offset-1 main">


        	<div class="container fluid" id="main">
            <div class="page-header text-center">
                <h1 id="timeline"><?php echo $annee." - ".$theme; ?></h1>
            </div>
            <ul class="timeline">
                
                <?php printTimeline($tabOrd, $annee, $name, $idsoiree); ?>

                <li class="clearfix" style="float: none;"></li>
            </ul>
            </div>
        </div>

<!-- div fin de menu -->
    </div>
    </div>

    <div id="myModal" class="modal fade" role="dialog">
        <div class="modal-dialog modal-lg">

            <div class="modal-content">

                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title"></h4>
                </div>
           
                <div class="modal-body">
                    <div class="row">
                        <div class="col-lg-12 col-sm-12" id="image-content">
                        <!-- Va contenir l'image -->
                        </div>
                        <div class="col-lg-12 col-sm-12 hidden-xs">
                                <div >
                                    <div id="com-content" class="container-fluid">
                                          <div class="row">

                                            <div class="comment-tabs">
                                                <ul class="nav nav-tabs" role="tablist">
                                                    <li class="active"><a href="#list-comment" role="tab" data-toggle="tab"><h4>Commentaires</h4></a></li>
                                                    <li><a href="#add-comment" role="tab" data-toggle="tab"><h4>Ajouter un commentaire</h4></a></li>
                                                </ul>            
                                                <div class="tab-content">
                                                    <div class="tab-pane active" id="list-comment">                
                                                        <ul class="media-list" style="overflow-y: scroll; max-height: 240px;">
                                                                   
                                                        </ul>
                                                    </div>      
                                                    <div class="tab-pane" id="add-comment">
                                                        <form action="#" method="post" class="form-horizontal" id="commentForm" role="form"> 
                                                            <div class="form-group">
                                                                <label for="email" class="col-sm-2 control-label">Commentaire</label>
                                                                <div class="col-sm-10">
                                                                  <textarea class="form-control" name="addComment" id="addComment" rows="5"></textarea>
                                                                </div>
                                                            </div>
                                                            <div class="form-group">
                                                                <div class="col-sm-offset-2 col-sm-10">                    
                                                                    <button class="btn btn-success btn-circle text-uppercase" type="submit" id="submitComment"><span class="glyphicon glyphicon-send"></span> Envoyer </button>
                                                                </div>
                                                            </div>            
                                                        </form>
                                                    </div>
                                                   
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

                        </div>

                    </div>
                </div> <!-- close modal body -->

                <div class="modal-footer">
                    <button class='btn btn-primary vote' data-toggle='tooltip' title='Vote pour la photo la plus trash'>Trash<span class='badge'>15</span></button>
                    <button class='btn btn-primary vote' data-toggle='tooltip' title='Vote pour la photo où ça pécho sec'>Love<span class='badge'>15</span></button>
                    <button class='btn btn-primary vote' data-toggle='tooltip' title='Photo de toute beauté'>Like<span class='badge'>15</span></button>
                </div>
          
            </div>

        </div>
    </div>


    <!-- End of content : script JS -->
	<script type="text/javascript" src="js/jquery_library.js"></script>
	<!-- Latest compiled and minified JavaScript -->
	<script type="text/javascript" src="js/bootstrap.js"></script>
	<script type="text/javascript" src="js/timeline.js"></script>
	<script type="text/javascript" src="js/modal.js"></script> 
</body>

</html>