<?php
session_start();
if (!isset($_SESSION['user_login_status']) and $_SESSION['user_login_status'] != 1) {
    header("location: ../../login.php");
    exit;
}

/* Connect To Database*/
require_once "../db.php"; //Contiene las variables de configuracion para conectar a la base de datos
require_once "../php_conexion.php"; //Contiene funcion que conecta a la base de datos
//Inicia Control de Permisos
include "../permisos.php";
$user_id = $_SESSION['id_users'];
$cargo_users = $_SESSION['cargo_users'];
$sucursal_users = $_SESSION['sucursal_users'];
if ($cargo_users == 1) {
    $est = "";
} else {
    $est = "disabled";
}
get_cadena($user_id);
$modulo = "Reportes";
permisos($modulo, $cadena_permisos);
//Finaliza Control de Permisos
$Reportes = 1;
?>
<?php require 'includes/header_start.php'; ?>

<?php require 'includes/header_end.php'; ?>

<!-- Begin page -->
<div id="wrapper">

    <?php require 'includes/menu.php'; ?>

    <!-- ============================================================== -->
    <!-- Start right Content here -->
    <!-- ============================================================== -->
    <div class="content-page">
        <!-- Start content -->
        <div class="content">
            <div class="container">
                <?php if ($permisos_ver == 1) {
                ?>
                    <div class="col-lg-12">
                        <div class="portlet">
                            <div class="portlet-heading bg-primary">
                                <h3 class="portlet-title">
                                    Reporte de Ventas
                                </h3>
                                <div class="portlet-widgets">
                                    <a href="javascript:;" data-toggle="reload"><i class="ion-refresh"></i></a>
                                    <span class="divider"></span>
                                    <a data-toggle="collapse" data-parent="#accordion1" href="#bg-primary"><i class="ion-minus-round"></i></a>
                                    <span class="divider"></span>
                                    <a href="#" data-toggle="remove"><i class="ion-close-round"></i></a>
                                </div>
                                <div class="clearfix"></div>
                            </div>
                            <div id="bg-primary" class="panel-collapse collapse show">
                                <div class="portlet-body">

                                    <form class="form-horizontal" role="form" id="datos_cotizacion">

                                        <div class="form-group row">

                                            <div class="col-xs-3">
                                                <div class="input-group">
                                                    <div class="input-group-addon">
                                                        <i class="fa fa-calendar"></i>
                                                    </div>
                                                    <input type="text" class="form-control daterange pull-right" value="<?php echo "01" . date('/m/Y') . ' - ' . date('d/m/Y'); ?>" id="range" readonly>

                                                </div><!-- /input-group -->
                                            </div>

                                            <div class="col-xs-3">
                                                <div class="input-group">
                                                    <select id="id_sucursal" name="id_sucursal" class="form-control" onchange="load(1);" <?php echo $est; ?>>
                                                        <option value="">Sucursal</option>
                                                        <option value="">Todas</option>
                                                        <?php
                                                        $query_suc = mysqli_query($conexion, "select id_sucursal, nombre_sucursal from sucursales order by nombre_sucursal");
                                                        while ($rr = mysqli_fetch_array($query_suc)) {
                                                            if ($rr['id_sucursal'] == $sucursal_users) {
                                                                echo '<option value="' . $rr['id_sucursal'] . '" selected>' . $rr['nombre_sucursal'] . '</option>';
                                                            } else {
                                                                echo '<option value="' . $rr['id_sucursal'] . '">' . $rr['nombre_sucursal'] . '</option>';
                                                            }
                                                        }
                                                        ?>
                                                    </select>
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="col-xs-3">
                                                <div class="input-group">
                                                    <select id="employee_id" class="form-control" onchange="load(1);">
                                                        <option value="">Selecciona Empleado</option>
                                                        <option value="">Todos</option>
                                                        <?php
                                                        $sql1 = mysqli_query($conexion, "select id_users, nombre_users, apellido_users from users");
                                                        while ($rw1 = mysqli_fetch_array($sql1)) {
                                                        ?>
                                                            <option value="<?php echo $rw1['id_users'] ?>"><?php echo $rw1['nombre_users'] . ' ' . $rw1['apellido_users']; ?></option>
                                                        <?php
                                                        }
                                                        ?>
                                                    </select>
                                                    <span class="input-group-btn">
                                                        <button class="btn btn-outline-info btn-rounded waves-effect waves-light" type="button" onclick='load(1);'><i class='fa fa-search'></i></button>
                                                    </span>
                                                </div>
                                            </div>

                                            <div class="col-xs-1">
                                                <div id="loader" class="text-center"></div>
                                            </div>

                                            <div class="col-xs-2 ">
                                                <div class="btn-group pull-right">
                                                    <?php if ($permisos_editar == 1) { ?>
                                                        <div class="btn-group dropup">
                                                            <button aria-expanded="false" class="btn btn-outline-default btn-rounded waves-effect waves-light" data-toggle="dropdown" type="button">
                                                                <i class='fa fa-file-text'></i> Reporte
                                                                <span class="caret">
                                                                </span>
                                                            </button>
                                                            <div class="dropdown-menu">
                                                                <a class="dropdown-item" href="#" onclick="reporte();">
                                                                    <i class='fa fa-file-pdf-o'></i> PDF
                                                                </a>
                                                                <a class="dropdown-item" href="#" onclick="reporte_excel();">
                                                                    <i class='fa fa-file-excel-o'></i> Excel
                                                                </a>
                                                            </div>
                                                        </div>
                                                    <?php } ?>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                    <div class="datos_ajax_delete"></div><!-- Carga los datos ajax -->
                                    <div class='outer_div'></div><!-- Carga los datos ajax -->


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

                <?php
                } else {
                ?>
                    <section class="content">
                        <div class="alert alert-danger" align="center">
                            <h3>Acceso denegado! </h3>
                            <p>No cuentas con los permisos necesario para acceder a este módulo.</p>
                        </div>
                    </section>
                <?php
                }
                ?>


            </div>
            <!-- end container -->
        </div>
        <!-- end content -->

        <?php require 'includes/pie.php'; ?>

    </div>
    <!-- ============================================================== -->
    <!-- End Right content here -->
    <!-- ============================================================== -->


</div>
<!-- END wrapper -->

<?php require 'includes/footer_start.php'
?>
<!-- ============================================================== -->
<!-- Todo el codigo js aqui -->
<!-- ============================================================== -->
<script type="text/javascript" src="../../js/VentanaCentrada.js"></script>
<script>
    $(function() {
        //Initialize Select2 Elements
        $(".select2").select2();
    });
    $(function() {
        load(1);

        //Date range picker
        $('.daterange').daterangepicker({
            buttonClasses: ['btn', 'btn-sm'],
            applyClass: 'btn-success',
            cancelClass: 'btn-default',
            locale: {
                format: "DD/MM/YYYY",
                separator: " - ",
                applyLabel: "Aplicar",
                cancelLabel: "Cancelar",
                fromLabel: "Desde",
                toLabel: "Hasta",
                customRangeLabel: "Custom",
                daysOfWeek: [
                    "Do",
                    "Lu",
                    "Ma",
                    "Mi",
                    "Ju",
                    "Vi",
                    "Sa"
                ],
                monthNames: [
                    "Enero",
                    "Febrero",
                    "Marzo",
                    "Abril",
                    "Mayo",
                    "Junio",
                    "Julio",
                    "Agosto",
                    "Septiembre",
                    "Octubre",
                    "Noviembre",
                    "Diciembre"
                ],
                firstDay: 1
            },
            opens: "right"

        });
    });

    function load(page) {
        var range = $("#range").val();
        var id_sucursal = $("#id_sucursal").val();
        var employee_id = $("#employee_id").val();
        var parametros = {
            "action": "ajax",
            "page": page,
            'range': range,
            'id_sucursal': id_sucursal,
            'employee_id': employee_id
        };
        $("#loader").fadeIn('slow');
        $.ajax({
            url: '../ajax/rep_empleado.php',
            data: parametros,
            beforeSend: function(objeto) {
                $("#loader").html("<img src='../../img/ajax-loader.gif'>");
            },
            success: function(data) {
                $(".outer_div").html(data).fadeIn('slow');
                $("#loader").html("");
            }
        })
    }
</script>
<script>
    function reporte() {
        var daterange = $("#range").val();
        var id_sucursal = $("#id_sucursal").val();
        var employee_id = $("#employee_id").val();
        VentanaCentrada('../reportes/rep_empleado_ventas.php?daterange=' + daterange + "&id_sucursal=" + id_sucursal + "&employee_id=" + employee_id, 'Reporte', '', '800', '600', 'true');
    }

    function reporte_excel() {
        var daterange = $("#range").val();
        var id_sucursal = $("#id_sucursal").val();
        var employee_id = $("#employee_id").val();
        window.location.replace("../excel/rep_empleado_ventas.php?daterange=" + daterange + "&id_sucursal=" + id_sucursal + "&employee_id=" + employee_id);
    }
</script>

<?php require 'includes/footer_end.php'
?>