@extends('layouts.sistema')
@section('titulo', URL::full())

@section('conteudo')
    @include('sistema/components/navbar')
    <div class="row no-gutters">
        @include('sistema/components/painel_lateral')
        <div class="d-none d-md-block col-md-8 col-lg-9 coWl-xl-10">
            <div class="painel">
                <div class="my-5">
                    <div class="container">
                        <div class="row no-gutters justify-content-center">                            
                            <div class="col-12">
                                <div class="d-flex flex-wrap align-items-center justify-content-between mb-5">
                                    <h2 class="m-0">Galeria</h2> 
                                    <div>
                                        <a href="{{url('sistema/painel')}}" class="btn btn-sm btn-primary">Voltar</a> 
                                        <a class="btn btn-sm btn-success" href="{{$url_cadastro}}/video"> Cadastrar Vídeo</a>
                                        <a class="btn btn-sm btn-success" href="{{$url_cadastro}}"> Cadastrar Foto</a>
                                    </div>
                                </div>         
                            </div>
                            <div class="col-12">
                                @if(isset($errors) && count($errors) >0)
                                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                                    @foreach($errors->all() as $erro)
                                    <p class="m-0">{{$erro}}</p>
                                    @endforeach
                                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                        <span aria-hidden="true">&times;</span>
                                    </button>
                                </div>
                                @endif
                                @if(session('error_bd'))
                                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                                        <p class="m-0">{{session('error_bd')}}</p>
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                @endif    
                                @if(session('mensagem'))
                                <div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <p class="m-0">{{session('mensagem')}}</p>
                                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                        <span aria-hidden="true">&times;</span>
                                    </button>
                                </div>
                                @endif
                            </div>

                            @if($num_rows>0) 
                           
                            <div class="col-12">
                                <h1>Fotos</h1>
                                <table class="table">
                                    <thead class="thead-primary">
                                        <tr>
                                            <th scope="col" class="border">
                                                <p class="m-0">Imagem</p>
                                            </th>
                                            <th scope="col" class="border">
                                                <p class="m-0 text-center">Editar</p>
                                            </th>
                                            <th scope="col" class="border">
                                                <p class="m-0 text-center">Deletar</p>
                                            </th> 
                                        </tr>
                                    </thead>
                                    <tbody class="sortable">
                                        @foreach ($galeria as $galerias)
                                        <tr> 
                                            <td class="border">
                                                <div class="img-box bg-img border" data-bg="{{url($galerias->gl_img_path)}}"></div>
                                            </td>
                                            <td class="col-1 border">
                                                <a class="btn mx-auto d-block w-100 btn-sm btn-primary"
                                                href="{{$url_pagina . "/editar/" . $galerias->cd_galeria}}">
                                                    Editar
                                                </a>
                                            </td>
                                            <td class="col-1 border">
                                                <form id="frmDelete" class="m-0" method="POST" name="frmDelete" action="{{ $url_pagina."/". $galerias->cd_galeria }}">
                                                @method('DELETE')
                                                @CSRF
                                                <button type="button" class="btn mx-auto d-block w-100 btn-sm btn-danger" data-toggle="modal" data-target="#modal{{$galerias->cd_galeria}}">Deletar</button>  

                                                {{-- modal restaurar aviso --}}
                                                <div class="modal fade" id="modal{{$galerias->cd_galeria}}" data-backdrop="static" data-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
                                                    <div class="modal-dialog modal-dialog-centered">
                                                        <div class="modal-content">
                                                            <div class="modal-header justify-content-center">
                                                                <h5 class="modal-title" id="staticBackdropLabel">Deletar galeria</h5>
                                                            </div>
                                                            <div class="modal-body">
                                                                <p class="mx-0 my-3 text-center text-uppercase">Deseja <strong>deletar</strong> a foto <strong> ?</p>
                                                            </div>
                                                            <div class="modal-footer">
                                                                <div class="mx-auto">
                                                                    <button type="button" class="btn btn-sm btn-primary" data-dismiss="modal">Cancelar</button>
                                                                    <button type="submit" class="btn btn-sm btn-secondary">Deletar</button>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                                </form>
                                            </td>
 
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>               
                            </div>
                            @endif      



                            @if($num_rows>0) 
                            
                            <div class="col-12  pt-5">
                                <h1>Vídeos</h1>
                                <table class="table">
                                    <thead class="thead-primary">
                                        <tr>
                                            <th scope="col" class="border">
                                                <p class="m-0">Vídeo</p>
                                            </th>
                                            <th scope="col" class="border">
                                                <p class="m-0 text-center">Editar</p>
                                            </th>
                                            <th scope="col" class="border">
                                                <p class="m-0 text-center">Deletar</p>
                                            </th> 
                                        </tr>
                                    </thead>
                                    <tbody class="sortable">
                                        @php
                                            // Função para extrair o token do link do YouTube
                                            function extractYoutubeToken($url) {
                                                parse_str(parse_url($url, PHP_URL_QUERY), $query);
                                                if (isset($query['v'])) {
                                                    return $query['v'];
                                                }
                                                return '';
                                            }
                                        @endphp

                                        @foreach ($galeriaVideo as $galeriasVideo)
                                            @php 
                                                $token = '';
                                                // Extrair o token do link do YouTube
                                                if (isset($galeriasVideo->gl_video)) {
                                                    $youtubeLink = $galeriasVideo->gl_video; // Exemplo de link do YouTube
                                                    $token = extractYoutubeToken($youtubeLink);
                                                }
                                            @endphp

                                        <tr> 
                                            <td class="border">
                                                <div class="img-box bg-img border"><iframe width="100%" height="100px" src="https://www.youtube.com/embed/{{$token}}" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe></div>
                                            </td>
                                            <td class="col-1 border">
                                                <a class="btn mx-auto d-block w-100 btn-sm btn-primary"
                                                href="{{$url_pagina . "/editar/video/" . $galeriasVideo->cd_galeria}}">
                                                    Editar
                                                </a>
                                            </td>
                                            <td class="col-1 border">
                                                <form id="frmDelete" class="m-0" method="POST" name="frmDelete" action="{{ $url_pagina."/video/". $galeriasVideo->cd_galeria }}">
                                                @method('DELETE')
                                                @CSRF
                                                <button type="button" class="btn mx-auto d-block w-100 btn-sm btn-danger" data-toggle="modal" data-target="#modal{{$galeriasVideo->cd_galeria}}">Deletar</button>  

                                                {{-- modal restaurar aviso --}}
                                                <div class="modal fade" id="modal{{$galeriasVideo->cd_galeria}}" data-backdrop="static" data-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
                                                    <div class="modal-dialog modal-dialog-centered">
                                                        <div class="modal-content">
                                                            <div class="modal-header justify-content-center">
                                                                <h5 class="modal-title" id="staticBackdropLabel">Deletar galeria</h5>
                                                            </div>
                                                            <div class="modal-body">
                                                                <p class="mx-0 my-3 text-center text-uppercase">Deseja <strong>deletar</strong> o vídeo <strong> ?</p>
                                                            </div>
                                                            <div class="modal-footer">
                                                                <div class="mx-auto">
                                                                    <button type="button" class="btn btn-sm btn-primary" data-dismiss="modal">Cancelar</button>
                                                                    <button type="submit" class="btn btn-sm btn-secondary">Deletar</button>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                                </form>
                                            </td>
 
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>               
                            </div>
                            @endif 
 

                            @if($num_rows<=0)
                            <div class="col-12 border p-4">
                                <h5 class="m-0 text-center">Não há nada cadastrado</h5>
                            </div>
                            @endif 
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection