<?php
require_once("admin/inc/protecao-final.php");

$total_avisos_ativos = mysqli_num_rows(mysqli_query($conexao,"SELECT * FROM avisos WHERE area = 'streaming'"));
$checar_status_aviso = mysqli_num_rows(mysqli_query($conexao,"SELECT * FROM avisos_desativados WHERE area = 'streaming' AND codigo_usuario = '".$dados_stm["porta"]."'"));
$total_avisos_exibir = ($total_avisos_ativos > $checar_status_aviso) ? $total_avisos_ativos-$checar_status_aviso : 0;

if($_POST["cadastrar"]) {

list($hora,$minuto) = explode(":",$_POST["hora"]);
list($ano,$mes,$dia) = explode("-",$_POST["data"]);
$data = $ano."-".$mes."-".$dia;

if(@count($_POST["dias"]) > 0){
  $dias = implode(",",$_POST["dias"]);
}

mysqli_query($conexao,"INSERT INTO autodj_acoes (codigo_stm,codigo_playlist,frequencia,data,hora,minuto,dias,acao) VALUES ('".$dados_stm["codigo"]."','".$_POST["codigo_playlist"]."','".$_POST["frequencia"]."','".$data."','".$hora."','".$minuto."','".$dias.",','".$_POST["acao"]."')");

// Cria o sessão do status das ações executadas e redireciona.
$_SESSION["status_acao"] = "<div class='alert alert-success text-center' role='alert'>".$lang['lang_acao_gerenciador_agendamentos_resultado_ok']."</div>";

header("Location: /gerenciar-acoes-autodj");
exit();
}

// Função para remover a acao
if(query_string('1') == "remover") {

  // Proteção contra acesso direto
  if(!preg_match("/".str_replace("http://","",str_replace("www.","",$_SERVER['HTTP_HOST']))."/i",$_SERVER['HTTP_REFERER'])) {
  die("<span class='texto_status_erro'>0x001 - Atenção! Acesso não autorizado, favor entrar em contato com nosso atendimento para maiores informações!</span>");
  }

  $codigo = code_decode(query_string('2'),"D");

  mysqli_query($conexao,"Delete From autodj_acoes where codigo = '".$codigo."'");
  
  echo "<div class='alert alert-success text-center' role='alert'>Ação removida com sucesso.</div>";
  
  exit();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>Streaming <?php echo $dados_stm["porta"]; ?></title>
  <link rel="stylesheet" href="/inc/materialdesignicons.min.css">
  <link rel="stylesheet" href="/inc/font-awesome.min.css">
  <link rel="stylesheet" href="/inc/vendor.bundle.base.css">
  <link rel="stylesheet" href="/inc/vendor.bundle.addons.css">
  <link rel="stylesheet" href="/inc/theme.css">
  <link rel="shortcut icon" href="/img/favicon.ico">
  <script type="text/javascript" src="/inc/ajax-streaming.js"></script>
  <script type="text/javascript" src="/inc/javascript.js"></script>
</head>

<body>
  <div class="container-scroller">
      <nav class="navbar col-lg-12 col-12 p-0 fixed-top d-flex flex-row">
      <div class="text-center navbar-brand-wrapper d-flex align-items-center justify-content-center">
        <?php if($dados_revenda["url_logo"]) { ?>
        <a class="navbar-brand brand-logo" href="/dashboard"><img id="logo" src="<?php echo $dados_revenda["url_logo"]; ?>" title="Painel" height="60" border="0"></a>
        <?php } else { ?>
        <a class="navbar-brand brand-logo" href="/dashboard"><span>Painel Streaming</span></a>
        <?php } ?>
        <a class="navbar-brand brand-logo-mini" href="/dashboard"><img src="/img/icones/img-icone-logo.png" title="Painel" width="32" height="32" border="0"></a>
      </div>
      <div class="navbar-menu-wrapper d-flex align-items-center justify-content-end justify-content-lg-start">
        <button class="navbar-toggler navbar-toggler align-self-center" type="button" data-toggle="minimize">
          <span class="mdi mdi-menu text-icones"></span>
        </button>
        <ul class="navbar-nav navbar-nav-right">
          <li class="nav-item nav-profile dropdown show">
            <a class="nav-link dropdown-toggle" href="#" data-toggle="dropdown" id="profileDropdown" aria-expanded="true">
              <i class="fa fa-power-off f-18 text-icones" data-toggle="tooltip" data-placement="bottom" title="<?php echo $lang['lang_botao_titulo_ligar']; ?>/<?php echo $lang['lang_botao_titulo_desligar']; ?>"></i>
            </a>
            <div class="dropdown-menu dropdown-menu-right navbar-dropdown" aria-labelledby="profileDropdown">
              <a class="dropdown-item text-success" href="javascript:ligar_streaming('<?php echo $porta_code; ?>');"> <?php echo $lang['lang_botao_titulo_ligar']; ?> Streaming</a>
              <a class="dropdown-item text-danger" href="javascript:desligar_streaming('<?php echo $porta_code; ?>');"> <?php echo $lang['lang_botao_titulo_desligar']; ?> Streaming</a>
              <?php if($dados_stm["autodj"] == "sim") { ?>
              <div class="dropdown-divider"></div>              
              <a class="dropdown-item text-success" href="javascript:carregar_opcoes_ligar_autodj('<?php echo $porta_code; ?>');"> <?php echo $lang['lang_botao_titulo_ligar']; ?> AutoDJ</a>
              <a class="dropdown-item text-danger" href="javascript:desligar_autodj('<?php echo $porta_code; ?>');"> <?php echo $lang['lang_botao_titulo_desligar']; ?> AutoDJ</a>
              <?php } ?>
            </div>
          </li>
          <li class="nav-item dropdown">
            <a class="nav-link count-indicator dropdown-toggle d-flex align-items-center justify-content-center" id="notificationDropdown" href="#" data-toggle="dropdown" aria-expanded="false">
              <i class="mdi mdi-bell f-22 text-icones" data-toggle="tooltip" data-placement="bottom" title="<?php echo $lang['lang_info_pagina_informacoes_tab_avisos']; ?>"></i>
              <?php if($total_avisos_exibir > 0) { ?><span class="count bg-success"><?php echo $total_avisos_exibir; ?></span><?php } ?>           
            </a>
            <div class="dropdown-menu dropdown-menu-right navbar-dropdown preview-list" aria-labelledby="notificationDropdown">
              <a class="dropdown-item">
                <p class="mb-0 font-weight-normal float-left"><?php echo $lang['lang_info_pagina_informacoes_tab_avisos']; ?></p>
              </a>
              <div class="dropdown-divider"></div>
              <?php carregar_avisos_streaming($conexao,$dados_stm["porta"],$dados_servidor["codigo"]); ?>
            </div>
          </li>
          <li class="nav-item">
            <a class="nav-link" href="/sair"><i class="mdi mdi-logout f-22 text-icones" data-toggle="tooltip" data-placement="bottom" title="Sair/logout"></i></a>
          </li>
          <li>
            <button type="button" class="btn btn-info" id="status-streaming" onClick="status_streaming('<?php echo $porta_code; ?>');" style="margin: 10px;min-width: 150px; min-height: 40px"><i class="fa fa-refresh"></i></button>
          </li>
        </ul>
        <button class="navbar-toggler navbar-toggler-right d-lg-none align-self-center" type="button" data-toggle="offcanvas">
          <span class="mdi mdi-menu text-icones"></span>
        </button>
      </div>
    </nav>

    <!-- modal -->
      <div class="modal fade" id="avisos" tabindex="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title"><?php echo $lang['lang_info_pagina_informacoes_tab_avisos']; ?></h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                </div>
                <div class="modal-body" id="avisos-conteudo"><img src="/img/ajax-loader.gif" align="center" /></div>
            </div>
        </div>
      </div>
                
      <div class="modal fade" id="playlists-autodj" tabindex="-1" role="dialog" aria-hidden="true">
          <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">AutoDJ</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                </div>
                <div class="modal-body text-center" id="playlists-autodj-conteudo" style="text-align: center;"><img src="/img/ajax-loader.gif" /></div>
            </div>
          </div>
      </div>
                
      <div class="modal fade" id="log-sistema" tabindex="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
                <div class="modal-body" id="log-sistema-conteudo" style="text-align:center"><img src="/img/ajax-loader.gif" /></div>
            </div>
        </div>
      </div>
      
    <div class="container-fluid page-body-wrapper">      
    <?php require_once("menu.php"); ?>
      <div class="main-panel">
        <div class="content-wrapper">
          <div id="local-status-acoes"><?php echo $_SESSION['status_acao'];unset($_SESSION['status_acao']); ?></div>
          <div class="row">            

            <div class="col-lg-12">
              <div class="card">
                  <div class="card-header">
                    <header>A&ccedil;&otilde;es</header>
                  </div>
                <div class="card-body">
                    <table id="data_table1" class="table dataTable no-footer" role="grid" aria-describedby="data_table_info">
                                                <thead>
                                                    <tr role="row">
                                                        <th class="sorting_asc" tabindex="0" aria-controls="data_table" rowspan="1" colspan="1" aria-sort="ascending">A&ccedil;&atilde;o</th>
                                                        <th class="nosort sorting_disabled" tabindex="0" aria-controls="data_table" rowspan="1" colspan="1" aria-sort="ascending"><?php echo $lang['lang_info_gerenciador_agendamentos_executar_acao']; ?></th>
                                                    </tr>
                                                </thead>
                                                <tbody>
<?php
$sql = mysqli_query($conexao,"SELECT * FROM autodj_acoes where codigo_stm = '".$dados_stm["codigo"]."' ORDER by data DESC");
while ($dados_acao = mysqli_fetch_array($sql)) {

$dados_playlist = mysqli_fetch_array(mysqli_query($conexao,"SELECT * FROM playlists where codigo = '".$dados_acao["codigo_playlist"]."'"));

list($ano,$mes,$dia) = explode("-",$dados_acao["data"]);
$data = "".$dia."/".$mes."/".$ano."";

if($dados_acao["acao"] == "ligar") {
$playlist = "playlist ".$dados_playlist["nome"]."";
}

if($dados_acao["frequencia"] == "1") {
$descricao = "".ucfirst($dados_acao["acao"])." em ".$data." ".$dados_acao["hora"].":".$dados_acao["minuto"]." ".$playlist."";
} elseif($dados_acao["frequencia"] == "2") {
$descricao = "".ucfirst($dados_acao["acao"])." diariamente às ".$dados_acao["hora"].":".$dados_acao["minuto"]." ".$playlist."";
} else {

$array_dias = explode(",",$dados_acao["dias"]);

foreach($array_dias as $dia) {

if($dia == "1") {
$dia_nome = "<font color='#003399'>".$lang['lang_label_segunda']."</font>";
} elseif($dia == "2") {
$dia_nome = "<font color='#FF0000'>".$lang['lang_label_terca']."</font>";
} elseif($dia == "3") {
$dia_nome = "<font color='#FF9900'>".$lang['lang_label_quarta']."</font>";
} elseif($dia == "4") {
$dia_nome = "<font color='#CC0066'>".$lang['lang_label_quinta']."</font>";
} elseif($dia == "5") {
$dia_nome = "<font color='#009900'>".$lang['lang_label_sexta']."</font>";
} elseif($dia == "6") {
$dia_nome = "<font color='#663300'>".$lang['lang_label_sabado']."</font>";
} elseif($dia == "7") {
$dia_nome = "<font color='#663399'>".$lang['lang_label_domingo']."</font>";
} else {
$dia_nome = "";
}

$lista_dias .= "".$dia_nome.", ";

}

$descricao = "".ucfirst($dados_acao["acao"])." &raquo; ".substr($lista_dias, 0, -4)." &raquo; ".$dados_acao["hora"].":".$dados_acao["minuto"]." ".$playlist."";
}

$acao_code = code_decode($dados_acao["codigo"],"E");

echo "<tr id='".$acao_code."'>
<td height='25' align='left' scope='col'>&nbsp;".$descricao."</td>
<td height='25' align='left' scope='col'><a href='javascript:remover_acao_autodj(\"".$acao_code."\");' data-toggle='tooltip' data-placement='bottom' title='".$lang['lang_info_gerenciador_agendamentos_acao_remover']."'><i class='fa fa-trash-o text-danger'></i></a></td>
</tr>";

unset($lista_dias);
unset($dia_nome);
}
?>
                                                </tbody>
                                            </table>
                </div>
              </div>
            </div>
            
            <div class="col-lg-12">
              <div class="card">
                  <div class="card-header">
                    <header>Cadastrar A&ccedil;&atilde;o</header>
                  </div>
                <div class="card-body">
                  <form method="post" action="/gerenciar-acoes-autodj" name="autodj_acoes">
                    <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="160" height="50" align="left" class="texto_padrao_destaque" style="padding-left:5px;"><strong>A&ccedil;&atilde;o</strong></td>
        <td align="left">
        <select name="acao" id="acao" class="form-control" style="width:100%;" onchange="desativar_playlist(this.value);">
          <option value="ligar" selected="selected">Ligar AutoDJ</option>
          <option value="desligar">Desligar AutoDJ</option>
        </select>
        </td>
      </tr>
      <tr>
        <td width="160" height="50" align="left" class="texto_padrao_destaque" style="padding-left:5px;"><strong>Playlist</strong></td>
        <td align="left">
        <select name="codigo_playlist" class="form-control" id="codigo_playlist" style="width:100%;">
        <option value="0" selected="selected">Escolha uma para ligar</option>
<?php

$query = mysqli_query($conexao,"SELECT * FROM playlists where codigo_stm = '".$dados_stm["codigo"]."' ORDER by nome ASC");
while ($dados_playlist = mysqli_fetch_array($query)) {

$total_musicas = mysqli_num_rows(mysqli_query($conexao,"SELECT * FROM playlists_musicas where codigo_playlist = '".$dados_playlist["codigo"]."'"));

echo '<option value="' . $dados_playlist["codigo"] . '">' . $dados_playlist["nome"] . ' (' . $total_musicas . ')</option>';

}
?>
            </select>
        </td>
      </tr>
      <tr>
        <td height="50" align="left" style="padding-left:5px;" class="texto_padrao_destaque"><strong><?php echo $lang['lang_info_gerenciador_agendamentos_relay_frequencias']; ?></strong></td>
        <td align="left">
        <select name="frequencia" id="frequencia" class="form-control" style="width:100%;" onchange="valida_opcoes_frequencia(this.value);">
          <option value="1" selected="selected"><?php echo $lang['lang_info_gerenciador_agendamentos_relay_frequencia1']; ?></option>
          <option value="2"><?php echo $lang['lang_info_gerenciador_agendamentos_relay_frequencia2']; ?></option>
          <option value="3"><?php echo $lang['lang_info_gerenciador_agendamentos_relay_frequencia3']; ?></option>
        </select>        </td>
      </tr>
      <tr>
        <td height="50" align="left" style="padding-left:5px;" class="texto_padrao_destaque"><strong>Data</strong></td>
        <td align="left"><input class="form-control" id="data" name="data" type="date" style="width:200px;"></td>
      </tr>
      <tr>
        <td height="50" align="left" style="padding-left:5px;" class="texto_padrao_destaque"><strong>Hor&aacute;rio Execu&ccedil;&atilde;o</strong></td>
        <td align="left" class="texto_padrao_pequeno"><input class="form-control" id="hora" name="hora" type="time" style="width:200px;"></td>
      </tr>
      <tr>
        <td height="50" align="left" style="padding-left:5px;" class="texto_padrao_destaque"><strong><?php echo $lang['lang_info_gerenciador_agendamentos_dias_especificos']; ?></strong></td>
        <td align="left" valign="middle" class="texto_padrao">
        <input name="dias[]" type="checkbox" value="1" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_segunda']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="2" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_terca']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="3" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_quarta']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="4" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_quinta']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="5" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_sexta']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="6" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_sabado']; ?>&nbsp;
        <input name="dias[]" type="checkbox" value="7" id="dias" disabled="disabled" style="vertical-align:middle" /><?php echo $lang['lang_label_domingo']; ?></td>
      </tr>
      <tr>
                                            <td height="50" colspan="2" align="right"><button type="button" class="btn btn-info" onClick="document.autodj_acoes.submit();"><?php echo $lang['lang_botao_titulo_cadastrar']; ?></button><input name="cadastrar" type="hidden" id="cadastrar" value="sim" /> </td>
                                          </tr>
    </table></form>
                </div>
              </div>
            </div>

          </div>
        </div>
      </div>      

    </div>
  </div>
  <script src="/inc/vendor.bundle.base.js"></script>
  <script src="/inc/vendor.bundle.addons.js"></script>
  <script src="/inc/theme.js"></script>
  <script>
  status_streaming('<?php echo $porta_code; ?>');
  setInterval("status_streaming('<?php echo $porta_code; ?>')",60000);
function desativar_playlist(opcao) {

  if(opcao == "desligar") {
  document.getElementById('codigo_playlist').disabled = true;
  document.getElementById('codigo_playlist').style.cursor = "not-allowed";
  } else {
  document.getElementById('codigo_playlist').disabled = false;
  document.getElementById('codigo_playlist').style.cursor = "default";
  }
}
  </script>
</body>
</html>