Viewing File: /home/cienp/public_html/portal/ver_agnd_semn.php

<?php
    if ($_POST[passa] == 'yes') {

    require "$this->include_dir/conecta.php";

    $s_id_tipo = $_POST[id_tipo];
    settype($s_id_tipo,'integer');

    if ($s_id_tipo > 0) {
        $se_tipo = "WHERE id_tipo = '$s_id_tipo' ";
    }

    $sql  = "SELECT id_agnd_gerl, id_tipo, de_titl, dt_inic, dt_finl, ";
    $sql .= "DATE_FORMAT(dt_inic, '%H:%i') as hr_ini2 ";
    $sql .= "FROM ".$pref_tabl."agnd_gerl ";
    $sql .= "$se_tipo ";
    $sql .= "ORDER BY id_agnd_gerl DESC ";
    $res  = mysqli_query($conn, $sql);
    #echo $sql.'<br>';
    if (mysqli_num_rows($res) > 0) {
					
?>

<script src="<?php echo $this->site_root?>/vendors/jquery/dist/jquery.min.js"></script><!-- jQuery -->
<script src="<?php echo $this->site_root?>/vendors/moment/min/moment.min.js"></script><!-- bootstrap-daterangepicker -->
<link href="<?php echo $this->site_root?>/vendors/fullcalendar/css/fullcalendar.min.css" rel="stylesheet">
<link href="<?php echo $this->site_root?>/vendors/fullcalendar/css/fullcalendar.print.min.css" rel="stylesheet" media="print">
<script src="<?php echo $this->site_root?>/vendors/fullcalendar/js/fullcalendar.min.js"></script>
<script src="<?php echo $this->site_root?>/vendors/fullcalendar/locale/pt-br.js"></script>

<div class="right_col" role="main">
    <div class="clearfix"></div>
    <div class="row">
        <div class="col-md-12 col-sm-12 col-xs-12">
            <div class="x_panel">

                <div class="x_title">
                    <h2>Calendário</h2>
                    <ul class="nav navbar-right panel_toolbox">
                        <li><a href="javascript:ver_filt(0);"><button class="btn btn-default"><i class="fa fa-file"></i> Todos</button></a></li>
                        <li><a href="javascript:ver_filt(1);"><button class="btn btn-warning"><i class="fa fa-beer"></i> Feriados</button></a></li>
                        <li><a href="javascript:ver_filt(2);"><button class="btn btn-info"><i class="fa fa-briefcase"></i> Férias de Colaboradores</button></a></li>
                        <li><a href="javascript:ver_filt(3);"><button class="btn btn-primary"><i class="fa fa-flask"></i> Reserva de Laboratórios/Salas</button></a></li>
                        <li><a href="javascript:ver_filt(4);"><button class="btn btn-success"><i class="fa fa-bullhorn"></i> Agenda de Programações</button></a></li>
                    </ul>
                    <div class="clearfix"></div>
                </div>
                <div class="x_content">
                    <div id="calendar"></div>
                </div>

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

<script>
    $(function() {
        $('#calendar').fullCalendar({
            header: {
                left: 'prev,next today',
                center: 'title',
                right: 'month'
            },
            defaultDate: '<?php echo date('Y-m-d');?>',
            navLinks: true, // can click day/week names to navigate views
            editable: true,
            eventLimit: true,
            events: [
<?php
                while ($linha = mysqli_fetch_array($res)) {
                    switch ($linha[id_tipo]) {
                        case '1':
                            $de_corr = '#f0ad4e';
                            break;
                        case '2':
                            $de_corr = '#5bc0de';
                            break;
                        case '3':
                            $de_corr = '#337ab7';
                            break;
                        default:
                            $de_corr = '#26B99A';
                            break;
                    }
?>
                {
                    title: '<?php echo $linha['de_titl']?>',
                    start: '<?php echo $linha['dt_inic']?>',
                    end: '<?php echo $linha['dt_finl']?>',
                    color: '<?php echo $de_corr;?>',
                    url: '<?php echo $linha['id_agnd_gerl']?>',
                },
<?php
                }
?>
            ],
            eventClick: function(event) {
                if (event.url) {
                    document.acidente.action = "index1.php?pg=alt_agnd_gerl";
                    document.acidente.id_agnd_gerl.value = event.url;
                    document.acidente.submit();
                    return false;
                }
            }
        });
    });

    function ver_filt(xx) {
        document.acidente.action = "index1.php?pg=ver_agnd_semn";
        document.acidente.id_tipo.value = xx;
        document.acidente.submit();
    }

</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
  <input type="hidden" name="id_agnd_gerl">
  <input type="hidden" name="id_tipo">
  <input type="hidden" name="opc">
  <input type="hidden" name="v_de_onde" id="v_de_onde" value="semn">
  <input type="hidden" name="passa" id="passa" value="yes">
</form>
<?php
    }

    } else {
	    require "erro.php";
    }
?>