Newer
Older
ournorth2021 / views / live.php
LuisOlaya on 8 Apr 2021 6 KB primer
<?php
    if($_SESSION['id_user'] == "" ){
        echo '
			<script>
				window.location = "/login"
			</script>
        ';
    }

    $queryUsr = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$_SESSION['id_user']."' ");
    $dataUsr = mysqli_fetch_array($queryUsr);


    $query = mysqli_query($connect,"SELECT * FROM Live WHERE estado = 1 ");
	$data = mysqli_fetch_array($query);

    $queryTrivia = mysqli_query($connect,"SELECT * FROM Trivias WHERE estado = 1 ");
	$dataTrivia = mysqli_fetch_array($queryTrivia);
    
    $idTrivia = 0;
    $finalizado = true;

    if($queryTrivia->num_rows > 0){
        
        $idTrivia = $dataTrivia["id"];
        $pregunta;
        $opc_1 = '';
        $opc_2 = '';
        $opc_3 = '';
        $opc_4 = '';
        $opc_5 = '';
        $id_pregunta = 0;

        $queryPreguntas = mysqli_query($connect,"SELECT * FROM Trivia_Preguntas WHERE id_trivia = '".$dataTrivia["id"]."' AND estado = 1 ORDER BY orden ASC ");
        while($dataPreguntas = mysqli_fetch_array($queryPreguntas)){

            $queryResp = mysqli_query($connect,"SELECT * FROM Trivias_Respuestas WHERE id_pregunta = '".$dataPreguntas["id"]."' ");

            if( $queryResp->num_rows == 0 ){
                $pregunta = $dataPreguntas["pregunta"];
                $opc_1 = $dataPreguntas["opc_1"];
                $opc_2 = $dataPreguntas["opc_2"];
                $opc_3 = $dataPreguntas["opc_3"];
                $opc_4 = $dataPreguntas["opc_4"];
                $opc_5 = $dataPreguntas["opc_5"];
                $id_pregunta = $dataPreguntas["id"];

                $finalizado = false;
                break;
            }
        }
        
    }
?>



<style>
    body{
		background-size: cover; 
		background-position: center; 
		background-attachment: fixed;
        background-image: url(<?php echo $url; ?>/img/bg_reuniones.jpg);
	}
</style>


<div class="container" >

	<div class="row" style="margin-top: 25px">
        
        
        <!-- PLAYER -->
        <div class="col-md-12" align="center"  id="columna_player">
            <div id="cont_player">
                <?php echo $data["codigo"]; ?>
		    </div>
        </div>
		
        <!-- PLAYER -->
        <div class="col-md-4" align="center" style="margin-top: 20px; display: none">

            <div id="scroll_cont" style="max-height: 390px; overflow: auto; margin-bottom: 10px;">
                <div id="cont_chat" align="left" style="background-color: #f1f1f1; padding: 10px;  ">
                    <?php
                    $queryChat = mysqli_query($connect,"SELECT * FROM Chat ORDER BY created_at ASC ");
                    while($dataChat = mysqli_fetch_array($queryChat)){

                        $queryAsis = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$dataChat["id_asistente"]."' ");
                        $dataAsis = mysqli_fetch_array($queryAsis);

                        echo '
                        <div class="chat_box">
                            <div class="txt_envia">'.$dataAsis["nombre"].' '.$dataAsis["apellidos"].' - '.$dataChat["created_at"].'</div>
                            '.$dataChat["comentario"].'
                        </div>';
                    }

                    ?>
                </div>
            </div>
            
            <div id="cont_comentarios">
                <div>
                    <button type="submit" class="btn btn-warning bt_enviar" onClick="Registrar_Comentario()">
                        <i class="fa fa-arrow-right" aria-hidden="true"></i>
                    </button>
                </div>
                <textarea id="comentario" class="form-control" placeholder="Ingresa un comentario..."></textarea>
                
                
            </div>
            
        </div>
		

		
	</div>
	
</div>

<script>
$( document ).ready(function() {
    $("#bt_live").addClass("btn_item_menu_active"); 

    $("#scroll_cont").animate({ scrollTop: $("#cont_chat").height() }, 0);

});
</script>


<script>

vista_streaming = true;
var api = '<?php echo $api; ?>';


var activar = false;
function Registrar_Comentario(){
    
    if($("#comentario").val() != "" ){
        
        if(activar == false){
            $("#modal_body").html('Está a punto de registrar un comentario en el chat grupal ¿Estás seguro?<br><br>');
            $("#modal_body").append('<button type="button" class="btn btn-success" style="margin-right: 10px;" onclick="activar = true; Registrar_Comentario(); Ocultar_Modal()">Enviar</button>');
            $("#modal_general").modal('show');
        }
        else{
            activar = false;

            data = {
                id_user:  <?php echo $_SESSION['id_user']; ?>,
                comentario: $("#comentario").val()
            };

            jQuery.ajax({
                url: api+"guardar_comentario.php",
                type:'post',
                data: data ,
                }).done(function (resp){
                    $("#cont_chat").html(resp);
                    $("#comentario").val("");

                })
                .fail(function(resp) {
                    console.log(resp);
                })
                .always(function(resp){
                }
            );
            
            if($("#comentario").val() != "" ){
                 hoy = new Date();
                 hora = hoy.getHours() + ':' + hoy.getMinutes() + ':' + hoy.getSeconds();
                
                database.ref( 'chat' ).set({
                    nombre: '<?php echo $_SESSION['name_user'] ?>', 
                    comentario: $("#comentario").val(),
                    fecha : hora
                });
            }
            
    
        }
    }
    
    else{
        $("#modal_body").html('Recuerde ingresar un comentario en la caja de texto.');
        $("#modal_general").modal('show');
    }
    
    
	
}
   
function Ocultar_Modal(){
    $("#modal_general").modal('hide');  
}
    
    
    
    
    
    
    

</script>

<style>
    .chat_box{
        background-color: #fff;
        padding: 8px 20px;
        border-radius: 5px;
        box-shadow: 1px 1px 5px rgba(0,0,0,0.1);
        width: fit-content;
        margin-bottom: 12px;
    }
    .bt_enviar{
        border-radius: 30px;
        margin-bottom: 15px;
        padding: 10px 12px;
        color: #006db7;
        font-size: 20px;
        background-color: #ffea00;
        border: 0;
        font-family: Signika-Bold;
        
        margin-bottom: -50px;
        position: relative;
        float: right;
        margin-top: 10px;
        margin-right: 10px;
    }
    .txt_envia{
        font-size: 12px;
        color: #a9a9a9;
    }
</style>