<?php if (!defined('ABSPATH')) exit; ?>
<script type="text/javascript" src="<?php echo HOME_URI; ?>assets/plugins/bootstrap-multiselect/dist/js/bootstrap-multiselect.js"></script>
<link rel="stylesheet" href="<?php echo HOME_URI; ?>assets/plugins/bootstrap-multiselect/dist/css/bootstrap-multiselect.css" type="text/css"/>
<link rel="stylesheet" type="text/css" href="<?php echo HOME_URI; ?>views/_js/datatable/jquery.dataTables.css"><!-- usado tabela -->
<link rel="stylesheet" type="text/css" href="<?php echo HOME_URI; ?>views/_js/datatable/resources/syntax/shCore.css"><!-- usado tabela -->
<script type="text/javascript" language="javascript" src="<?php echo HOME_URI; ?>views/_js/datatable/jquery.dataTables.js"></script><!-- usado tabela -->
<script type="text/javascript" language="javascript" src="<?php echo HOME_URI; ?>views/_js/datatable/resources/syntax/shCore.js"></script><!-- usado tabela -->
<div class="row">
    <div class="col-md-12">
        <!-- start: PAGE CONTENT -->
        <div class="row">
            <?php /* ?>
              <div class="col-md-12">
              <!-- start: SEARCH RESULT -->
              <div class="search-classic">
              <table class="table table-striped table-bordered table-hover table-full-width" id="sample_1">
              <thead>
              <tr>
              <th class="hidden-xs" style="width: 20%;">Departamento</th>
              <th style="width: 30%;">Assunto</th>
              <th class="hidden-xs" style="width: 20%;">Status</th>
              <th class="hidden-xs" style="width: 20%;">Última atualização</th>
              <th style="width: 10%;">Ações</th>
              </tr>
              </thead>
              <tfoot>
              <tr>

              </tr>
              </tfoot>
              </table>
              </div>
              <!-- end: SEARCH RESULT -->
              </div>
              <?php */ ?>
            <div class="col-md-12">
                <div class="col-md-12 alert alert-warning">
                            <strong><i class="fa fa-warning"></i> &nbsp;Atendimento </strong>- Nosso horário de atendimento é de <b>Segunda à Sexta</b> das <b>08h às 18h*</b>.<br><br>
                            * Os ticktes são atendidos por ordem de abertura e eventualmente poderá ser respondido fora desse horário!
            </div><br><br>
                <a class="btn btn-success" href="<?php echo HOME_URI . 'user-register/ticketsadd' ?>"><i class="fa fa-plus"></i>
                    Adicionar Novo</a><br><br>
            
                <!-- start: DYNAMIC TABLE PANEL -->
                <div class="panel panel-default">
                    <div class="panel-heading">
                        <i class="fa fa-external-link-square"></i>
                        Lista de Detalhes
                        <div class="panel-tools">
                            <a class="btn btn-xs btn-link panel-expand" href="#"> <i class="clip-expand"></i> </a>										
                        </div>
                    </div>
                    <div class="panel-body">
<?php if ($mobile_use == '1') { ?><div class="table-responsive"><?php } ?>
                        <table class="table table-striped table-bordered table-hover table-full-width" id="sample_1">
                            <thead>
                                <tr>
                                    <th style="width: 10%;">Departamento</th>
                                    <th style="width: 30%;">Assunto</th>
                                    <th style="width: 10%;">Status</th>
                                    <th style="width: 20%;">Última atualização</th>
                                    <th style="width: 10%;">Ações</th>                                                                                                
                                </tr>
                            </thead>
                            <tbody id="">
                                <?php
                                require ABSPATH . '/connectpadrao.php';
                                if ($permissoes_usuario['OCULTO_vertodosostickets'] == '1') {
                                    $sql_tickets = $banco->query('SELECT * FROM tickets_geral WHERE id_cliente = "' . $_SESSION['userdata']['contratante'] . '" ORDER BY id_ticket DESC');
                                    $sql_tickets_list = $banco->query('SELECT * FROM tickets_geral WHERE id_cliente = "' . $_SESSION['userdata']['contratante'] . '" ORDER BY id_ticket DESC');
                                } else {
                                    $sql_tickets = $banco->query('SELECT * FROM tickets_geral WHERE id_cliente_solicitante = "' . $_SESSION['userdata']['id_mestre'] . '" ORDER BY id_ticket DESC');
                                    $sql_tickets_list = $banco->query('SELECT * FROM tickets_geral WHERE id_cliente_solicitante = "' . $_SESSION['userdata']['id_mestre'] . '" ORDER BY id_ticket DESC');
                                }
                                if($sql_tickets->fetch(PDO::FETCH_ASSOC)){
                                while ($ticket = $sql_tickets_list->fetch(PDO::FETCH_ASSOC)) {
                                    ?>
                                    <tr id="columm<?= $ticket['id_ticket']; ?>">
                                        <td>
                                            <?php
                                            $sql_departamentos = $banco->query('SELECT * FROM departamentos WHERE id_departamento = "' . $ticket['departamento'] . '"');
                                            $departamento = $sql_departamentos->fetch(PDO::FETCH_ASSOC);

                                            echo $departamento['nome_departamento'];
                                            ?>
                                        </td>
                                        <td>
                                            <?php echo $ticket['cod_ticket'] . ' - ' . $ticket['assunto_ticket']; ?>
                                        </td>
                                        <td>
                                            <?php
                                            $sql_tickets_status = $banco->query('SELECT * FROM tickets_geral WHERE id_ticket = "' . $ticket['titulo_status'] . '"');
                                            $ticket_status = $sql_tickets_status->fetch(PDO::FETCH_ASSOC);
                                            ?>
                                            <div class="label" style="background-color: <?php echo $ticket_status['cor_status']; ?>">
                                                <?php echo $ticket_status['titulo_status']; ?>
                                            </div>    
                                        </td>
                                        <td>
                                            <?php echo $ticket['data_atualizacao']; ?>
                                        </td>
                                        <td class="center">
                                            <div class="">
                                                <div class="btn-group">
                                                    <a class="btn btn-primary" href="<?php echo HOME_URI; ?>user-register/ticketsver?ticket=<?php echo $ticket['id_ticket']; ?>">
                                                        <?php if ($mobile_use != '1') { ?>Ver Ticket<?php } else { ?><i class="clip-search"></i><?php } ?>
                                                    </a>
                                                </div>
                                            </div>
                                        </td>                                
                                    </tr>
                                <?php
                                }
                                } ?>
                            </tbody>
                        </table>
<?php if ($mobile_use == '1') { ?></div><?php } ?>
                    </div>
                </div>
                <!-- end: DYNAMIC TABLE PANEL -->
            </div>
        </div>
        <!-- end: PAGE CONTENT-->
    </div>
</div>
<script type="text/javascript" src="<?php echo HOME_URI; ?>assets/plugins/bootstrap-multiselect/dist/js/bootstrap-multiselect.js"></script>
<script type="text/javascript" language="javascript" class="init">
    
    var table = $('#sample_1').dataTable({
    "autoWidth": false,
            "processing": false,
            "bFilter": false,
            "serverSide": true,
            "sScrollBody": true,
            "bSort": false,
            "aoColumnDefs" : [ {
"bSortable" : false,
"aTargets" : [ "_all" ]
} ],
            "oLanguage": {
            "sLengthMenu": "Exibir _MENU_<?php if ($mobile_use != '1') { ?> por página<?php } ?>",
                    "sZeroRecords": "<div class=\"form-control\" style=\"height:70px\">Nenhum Cadastro encontrado!<br> Reajuste sua busca para obter melhores resultados.</div>",
                    "sInfo": "Exibindo de _START_ a _END_ de _TOTAL_ registros",
                    "sInfoEmpty": "Nenhum registro sendo exibido",
                    "sInfoFiltered": "(filtrou-se a partir de _MAX_ registros)",
                    "sSearch": "Busca:",
    <?php if ($mobile_use == '1') { ?>
                "oPaginate": {
                "sLast": "Last page",
                        "sNext": "",
                        "sPrevious": ""
                }
    <?php } else { ?>
                "oPaginate": {
                "sLast": "Last page",
                        "sNext": "Proxima",
                        "sPrevious": "Anterior"
                }
    <?php } ?>
            },
            "aLengthMenu": [
            [5, 10, 15, 20, - 1],
            [5, 10, 15, 20, "Todos"]
            ],
            "iDisplayLength": 10,
    });
    $('#sample_1_wrapper .dataTables_filter input').addClass("form-control input-sm").attr("placeholder", "Buscar");
    $('#sample_1_wrapper .dataTables_length select').addClass("m-wrap small");
    $('#sample_1_wrapper .dataTables_length select').select2();
    $('#sample_1_column_toggler input[type="checkbox"]').change(function() {
    var iCol = parseInt($(this).attr("data-column"));
    var bVis = oTable.fnSettings().aoColumns[iCol].bVisible;
    oTable.fnSetColumnVis(iCol, (bVis ? false : true));
    });
    $('input.global_filter').on('keyup click', function() {
    filterGlobal();
    });
    $('input.column_filter').on('keyup click', function() {
    filterColumn($(this).parents('tr').attr('data-column'));
    });
    $('.column_filter').on('change', function() {
    filterColumn($(this).parents('tr').attr('data-column'));
    });
</script>