@extends('layouts.template')

@section('content')


<!--page-content-->
<div class="page-content">
    <!-- class kayton -->

    <!--row-->
    <div class="row">
        <!--número de colunas-->
        <div class="col-md-12 col-sm-12 col-xs-12">
            <!--x_panel-->
            <div class="container2">
                <div class="x_panel">
                    <div class="x_title">
                        <h2><b>Vendas Acumuladas PDV - Filtro</b></h2>
                        <ul class="nav navbar-right panel_toolbox">
                            <li><a class="collapsed-link" data-toggle="collapse" href="#collapsed-filtros" aria-expanded="true" aria-controls="collapsed-filtros"><i class="fa fa-chevron-up"></i></a></li>
                            <li><a class="close-link"><i class="fa fa-close"></i></a></li>
                        </ul>
                        <div class="clearfix"></div>
                    </div>
                    <!--x_title-->
                    <div id="collapsed-filtros" class="collapsed" aria-labelledby="heading-collapsed">
                        <!--x_content-->
                        <div class="x_content">
                            <div class="well" style="overflow: auto">
                                <form action="{{ route('venda_acumulada_pdv') }}" method="POST" class="form-horizontal">
                                    <div class="col-md-4">
                                        <b>Período de</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <div class="input-group date" id="datepicker_dtde">
                                                        <input type="text" name="_P_DTDE" class="form-control" required>
                                                        <div class="input-group-addon">
                                                            <span class="glyphicon glyphicon-th"></span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-md-4">
                                        <b>Período até</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <div class="input-group date" id="datepicker_dtate">
                                                        <input type="text" name="_P_DTATE" class="form-control" required>
                                                        <div class="input-group-addon">
                                                            <span class="glyphicon glyphicon-th"></span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-4">
                                        <b>Empresa</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_EMP" id="empresa" class="form-control input-lg dynamic">
                                                        @foreach($emp as $emps)
                                                        <option value="{{ $emps->empcod }}">{{ $emps->empfan }}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-6">
                                        <b>Operador</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_RCA" id="vendedor" class="form-control input-lg dynamic">
                                                        
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-6">
                                        <b>Fornecedor</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_FORN" id="fornecedor" class="form-control input-lg dynamic">
                                                        
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-6">
                                        <b>Marca</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_MARCA" id="marca" class="form-control input-lg dynamic">
                                                        
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-6">
                                        <b>Departamento</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_DEPP" id="departamento" class="form-control input-lg dynamic">
                                                        
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-12">
                                        <b>Agrupamento</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_GROUP" id="agrupamento" class="form-control input-lg dynamic">
                                                        @foreach($agrupamento as $agrup)
                                                        <option id="group" value="{{ $agrup->grupocod }}">{{ $agrup->grupodes }}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-12">
                                        <b>Apresentação</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_APR" id="apresentacao" class="form-control input-lg dynamic">
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-sm-12">
                                        <b>Classificação</b>
                                        <fieldset>
                                            <div class="control-group">
                                                <div class="controls">
                                                    <select name="_P_CLASSIF" id="classificacao" class="form-control input-lg dynamic">
                                                        @foreach($classificacao as $classif)
                                                        <option value="{{ $classif->classifcod }}">{{ $classif->classifdes }}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                        </fieldset>
                                    </div>
                                    <div class="col-md-12">
                                        <br>
                                        <fieldset>
                                            <button id="send" type="submit" class="btn btn-success">Selecionar</button>
                                        </fieldset>
                                    </div>
                                    <input type="hidden" name="_method" value="post">
                                    <input type="hidden" name="_token" value="{{ csrf_token() }}">
                                </form>
                            </div>
                        </div>
                        <!--x_content-->
                    </div>

                </div>
                <!--x_panel-->
            </div>
        </div>
        <!--número de colunas-->
    </div>
    <!--row-->


    <!--row-->
    <div class="row">
        <!--número de colunas-->
        <div class="col-md-12 col-sm-12 col-xs-12">
            <!--x_panel-->
            <div class="container2">
                <div class="x_panel">
                    <div class="x_title">
                        <h2 class="green">Venda Acumuladas - Resultado</h2>
                        <ul class="nav navbar-right panel_toolbox">
                            <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                            <li><a class="close-link"><i class="fa fa-close"></i></a></li>
                        </ul>
                        <div class="clearfix"></div>
                    </div>
                    <!--x_title-->

                    <!--x_content-->
                    <div class="x_content">
                        <!-- will be used to show any messages -->
                        @if (Session::has('message'))
                        <div class="alert alert-success alert-dismissible" role="alert">
                            <button type="button" class="close" data-dismiss="alert" aria-label="Fechar"><span aria-hidden="true">&times;</span></button>
                            {{ Session::get('message') }}
                        </div>
                        @endif


                        @if ($_POST)
                        @if (count($dados_venda) > 0)
                        <!-- table -->
                        <table id="datatable-responsive" class="table table-striped table-bordered dt-responsive nowrap datatables" cellspacing="0" width="100%">
                            <thead>
                                <tr>
                                    <th style="font-weight: bold; color: blue">Agrupamento: {{$group}}</th>
                                    <th><b>Apresentação</b></th>
                                    <th style="text-align:right; font-weight: bold; color: green"><b>Valor </b></th>
                                    <th style="text-align:right; font-weight: bold; color: black"><b>Qt.NF</b></th>
                                    <th style="text-align:right; font-weight: bold; color: black"><b>Qt.Pro</b></th>
                                    <th style="text-align:right; font-weight: bold; color: brown"><b>Vl.Cancel</b></th>
                                    <th style="text-align:right; font-weight: bold; color: black"><b>Ticket Médio</b></th>
                                </tr>
                            </thead>
                            <tbody>

                                <!-- Content -->

                                @foreach($dados_venda as $dado)

                                <tr>
                                    <td><b>{{ $dado->aprdes }}</td>
                                    <td><b>{{ $dado->grupodes }}</td>
                                    <td style="text-align:right"><b>R$ {{ number_format($dado->fat_vl, 2) }}</b></td>
                                    <td style="text-align:right"><b>{{ $dado->qt_nf_fat }}</b></td>
                                    <td style="text-align:right"><b>{{ $dado->fat_qt}}</b></td>
                                    <td style="text-align:right"><b>R$ {{ number_format($dado->cancel_vl, 2)}}</b></td>
                                    <td style="text-align:right"><b>R$ {{ number_format($dado->tk_med, 2)}}</b></td>
                                </tr>
                                @endforeach

                                <a class="btn btn-xs btn-warning" id="btn-imprimir" 
                                href="{{ asset('/jasperphp/gerarRelatorio.php?relatorio=wt_venda_acumulada_pdv&formato=pdf&P_DTDE='.$_P_DTDE.'&P_DTATE='.$_P_DTATE.'&P_EMP='.$_P_EMP.'&P_RCA='.$_P_RCA.'&P_CAT='.$_P_CAT.'&P_FORN='.$_P_FORN.'&P_DEPP='.$_P_DEPP.'&P_MARCA='.$_P_MARCA.'&P_APR='.$_P_APR.'&P_GROUP='.$_P_GROUP.'&P_CLASSIF='.$_P_CLASSIF)}}" target="_blank">Imprimir
                                </a>
                            </tbody>
                            <tfooter>
                                <tr>
                                    <th colspan="2" style="text-align:right; font-weight: bold; color: green">Total: {{ number_format($dado->t_fat_vl, 2) }} </th>
                                    <th colspan="1" style="text-align:right; font-weight: bold; color: black">Total: {{ $dado->t_qt_nf_fat }} </th>
                                    <th colspan="1" style="text-align:right; font-weight: bold; color: black">Total: {{ $dado->t_fat_qt }} </th>
                                    <th colspan="1" style="text-align:right; font-weight: bold; color: brown">Total: {{ number_format($dado->t_cancel_vl, 2) }} </th>
                                    <th colspan="1" style="text-align:right; font-weight: bold; color: black">Total: {{ number_format($dado->t_tk_med, 2) }} </th>
                                </tr>
                            </tfooter>
                        </table>
                        @else
                        <p>Não possui dados para o período informado.</p>
                        @endif
                        @else
                        <p>Selecione um filtro.</p>
                        @endif

                        <script>
                            $(document).ready(function() {
                                var groupColumn = 1;
                                var table = $('.datatables').DataTable({
                                    columnDefs: [{
                                        visible: false,
                                        targets: groupColumn
                                    }],
                                    order: [
                                        [groupColumn, 'asc']
                                    ],
                                    displayLength: 25,
                                    drawCallback: function(settings) {
                                        var api = this.api();
                                        var rows = api.rows({
                                            page: 'current'
                                        }).nodes();
                                        var last = null;

                                        api
                                            .column(groupColumn, {
                                                page: 'current'
                                            })
                                            .data()
                                            .each(function(group, i) {
                                                if (last !== group) {
                                                    $(rows)
                                                        .eq(i)
                                                        .before('<tr class="group" style="font-weight: bold; color: blue"><td colspan="6" style="width:100%">' + group + '</td></tr>');

                                                    last = group;
                                                }
                                            });
                                    },
                                    "language": {
                                        "decimal": "",
                                        "emptyTable": "Sem dados disponíveis",
                                        "info": "Mostrando de _START_ até _END_ de _TOTAL_ registos",
                                        "infoEmpty": "Mostrando de 0 até 0 de 0 registos",
                                        "infoFiltered": "(filtrado de _MAX_ registos no total)",
                                        "infoPostFix": "",
                                        "thousands": ",",
                                        "lengthMenu": "Mostrar _MENU_ registos",
                                        "loadingRecords": "A carregar dados...",
                                        "processing": "A processar...",
                                        "search": "Procurar:",
                                        "zeroRecords": "Não foram encontrados resultados",
                                        "paginate": {
                                            "first": "Primeiro",
                                            "last": "Último",
                                            "next": "Seguinte",
                                            "previous": "Anterior"
                                        },
                                        "aria": {
                                            "sortAscending": ": clique para ordenar ascendente (ASC)",
                                            "sortDescending": ": clique para ordenar descendente (DESC)"
                                        }
                                    }
                                });

                                // Order by the grouping
                                $('.datatables tbody').on('click', 'tr.group', function() {
                                    var currentOrder = table.order()[0];
                                    if (currentOrder[0] === groupColumn && currentOrder[1] === 'asc') {
                                        table.order([groupColumn, 'desc']).draw();
                                    } else {
                                        table.order([groupColumn, 'asc']).draw();
                                    }
                                });

                            });
                        </script>

                    </div>
                </div>
                <!--x_panel-->
            </div>
        </div>
        <!--número de colunas-->
    </div>
    <!--row-->
</div>
<!--x_content-->

<script type="text/javascript">
    $(document).ready(function() {

        // ------------------------------------------------- datepicker ----------------------------------------------------------

        $(function() {
            $('#datepicker_dtde').datepicker({
                defaultDate: "getDate()",
                dateFormat: "dd/mm/yy",
                language: 'pt-BR',
                minDate: 0,
                autoclose: true
            }).datepicker("setDate", new Date());
        });
        $(function() {
            $('#datepicker_dtate').datepicker({
                defaultDate: "getDate()",
                dateFormat: "dd/mm/yy",
                language: 'pt-BR',
                minDate: 0,
                autoclose: true
            }).datepicker("setDate", new Date());
        });


        $(function() {
            $.ajax({
                url: 'venda_acumulada_pdv/buscarAprPdv',
                type: "GET",
                dataType: "json",
                success: function(data) {
                    console.log(data);
                    $.each(data, function(key, value) {
                        $('select[name="_P_APR"]').append('<option value="' + value.aprcod + '">' + value.aprdes + '</option>');
                    });
                }
            });
        });


        // ------------------------------------------------- Operador ----------------------------------------------------------
        $(function() {

            var select = $("#vendedor").select2({
                placeholder: "Selecione o Operador",
                allowClear: true,
                ajax: {
                    url: "{{ url('admin/venda_acumulada_pdv/buscarOperadorPdv') }}",
                    dataType: 'json',
                    delay: 250,
                    processResults: function(data, params) {
                        return {
                            results: $.map(data.items, function(item) {
                                return {
                                    text: item.rcades,
                                    id: item.rcacod,
                                    cnpj: item.rcacpf,
                                    fantasia: item.rcafan
                                }
                            })
                        };
                    },
                    cache: true
                },
                escapeMarkup: function(markup) {
                    return markup;
                }, // let our custom formatter work
                minimumInputLength: 1,
                templateResult: function(repo) {
                    if (repo.loading) return 'Buscando...';
                    return '<b>' + repo.text + ' - (Cód: ' + repo.id + ')</b>' +
                        '<br>' +
                        '<i>CNPJ: ' + repo.cnpj + '</i>' +
                        '<br>' +
                        '<i>Fantasia: ' + repo.fantasia + '</i>';
                },
                templateSelection: function(repo) {
                    return repo.text || repo.id;
                }
            });
            


        });


        // ------------------------------------------------- fornecedor ----------------------------------------------------------

        $("#fornecedor").select2({
            placeholder: "Selecione o fornecedor",
            allowClear: true,
            ajax: {
                url: "{{ url('admin/venda_acumulada_pdv/buscarFornPdv') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        page: params.page
                    };
                },
                processResults: function(data, params) {
                    return {
                        results: $.map(data.items, function(item) {
                            return {
                                text: item.fornfan,
                                id: item.forncod
                            }
                        })
                    };
                },
                cache: true
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work
            minimumInputLength: 1,
            templateResult: function(repo) {
                if (repo.loading) return 'Buscando...';
                return '<b>' + repo.text + ' - (Cód: ' + repo.id + ')</b>';
            },
            templateSelection: function(repo) {
                return repo.text || repo.id;

            },
        });

        // ------------------------------------------------- departamento ----------------------------------------------------------

        $("#departamento").select2({
            placeholder: "Selecione o Departamento",
            allowClear: true,
            ajax: {
                url: "{{ url('admin/venda_acumulada_pdv/buscarDeppPdv') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        page: params.page
                    };
                },
                processResults: function(data, params) {
                    return {
                        results: $.map(data.items, function(item) {
                            return {
                                text: item.deppdes,
                                id: item.deppcod
                            }
                        })
                    };
                },
                cache: true
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work
            minimumInputLength: 1,
            templateResult: function(repo) {
                if (repo.loading) return 'Buscando...';
                return '<b>' + repo.text + ' - (Cód: ' + repo.id + ')</b>';
            },
            templateSelection: function(repo) {
                return repo.text || repo.id;

            },
        });

        // ------------------------------------------------- marca ----------------------------------------------------------

        $("#marca").select2({
            placeholder: "Selecione a marca",
            allowClear: true,
            ajax: {
                url: "{{ url('admin/venda_acumulada_pdv/buscarMarcaPdv') }}",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        page: params.page
                    };
                },
                processResults: function(data, params) {
                    return {
                        results: $.map(data.items, function(item) {
                            return {
                                text: item.marcasdes,
                                id: item.marcascod
                            }
                        })
                    };
                },
                cache: true
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work
            minimumInputLength: 1,
            templateResult: function(repo) {
                if (repo.loading) return 'Buscando...';
                return '<b>' + repo.text + ' - (Cód: ' + repo.id + ')</b>';
            },
            templateSelection: function(repo) {
                return repo.text || repo.id;

            },
        });
    });
</script>

@endsection