@include('layouts.breadcumb')
@section('header')

    <link rel="stylesheet" href="/plugins/datatables/jquery.dataTables.min.css">
    <link rel="stylesheet" href="/plugins/datatables/dataTables.bootstrap.min.css">

@stop


<div class="row">
    <div class="panel panel-orange panel-border">
        <!-- panel head -->
        <div class="panel-heading">

        </div>
        <div class="panel-body">

            <div class="tabs-vertical-env">
                <ul class="nav tabs-vertical" style="width: 5%;"><!-- available classes "right-aligned" -->
                    <li rel="tooltip" data-placement="right" data-original-title="BENEFICIARIO" class="active"><a href="#beneficiario" data-toggle="tab"><i class="fa fa-2x fa-user"></i></a></li>
                    <li rel="tooltip" data-placement="right" data-original-title="BENEFICIARIO Y CONCEPTO"><a href="#beneficiario_concepto" data-toggle="tab"><i class="fa fa-2x fa-wrench"></i></a></li>
                    <li rel="tooltip" data-placement="right" data-original-title="BENEFICIOS Y TIPOS DE CONCEPTOS"><a href="#beneficiario_tipo_concepto" data-toggle="tab"><i class="fa fa-2x fa-globe"></i></a></li>
                </ul>

                <div class="tab-content">
                    <form method="get" action="/compras/informes/gastos/" role="form" class="validate">

                            <div class="form-group  col-md-3">
                                <label>FECHA - 日期</label>
                                <div class="input-group">
                                    <input readonly type="text" name="fecha_rango" id="fecha_rango" value="{{  Input::get('fecha_rango') }}" class="form-control input-lg" /><span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
                                </div>

                            </div>
                            <div class="form-group col-md-6">

                                <label for="beneficiario" class="control-label">BENEFICIARIOS - 受益者</label>
                                <select class="select2" name="beneficiario_id" id="beneficiario_id">
                                    <option value="">- Seleccionar -</option>
                                        @foreach( $beneficiarios as $beneficiario)
                                            <option value="{{$beneficiario->id}}">{{$beneficiario->nombre}}</option>
                                        @endforeach

                                </select>
                            </div>
                            <div class="col-md-3">
                                <br>
                                <button onclick="showMessage('CARGANDO DATOS, ESPERE POR FAVOR ')" type="submit" id="VerInformesButton" class="btn btn-orange btn-icon btn-rounded waves-light waves-effect btn-lg ">Ver Informe<i class="fa fa-2x fa-list"></i></button>
                            </div>
                            <div class="clearfix"></div>
                            <div class="form-group col-md-6">

                                <label for="conceptos" class="control-label">CONCEPTOS - 概念</label>
                                <select class="select2" name="conceptos" id="conceptos">
                                    <option value="">- Seleccionar -</option>
                                    @foreach( $conceptos as $concepto)
                                        <option value="{{$concepto->cnc_id}}">{{$concepto->cnc_nombre}}</option>
                                    @endforeach

                                </select>
                            </div>
                            <div class="form-group col-md-6">

                                <label for="tipo_conceptos" class="control-label">TIPO CONCEPTOS - 等概念</label>
                                <select class="select2" name="tipo_conceptos" id="tipo_conceptos">
                                    <option value="">- Seleccionar -</option>
                                    @foreach( $tipo_conceptos as $tipo_concepto)
                                        <option value="{{$tipo_concepto->cls_id}}">{{$tipo_concepto->cls_nombre}}</option>
                                    @endforeach

                                </select>
                            </div>

                            <div class="clearfix"></div>
                            <br>
                    </form>
                    <div class="clearfix"></div>
                    <div class="tab-content">
                        <div class="tab-pane active" id="beneficiario">

                            @if( Input::get('fecha_rango') )
                                <hr />
                                <h2>{{'Beneficiarios'}}</h2>
                                <table class="table table-striped table-colored-bordered table-bordered-inverse table-hover table-responsive" id="table-1">
                                    <thead>

                                    <tr>
                                        <th>NUMERO</th>
                                        <th>FECHA</th>
                                        <th>BENEFICIARIO</th>
                                        <th>CONCEPTO</th>
                                        <th>CUENTA</th>
                                        <th>NOTA</th>
                                        <th>MONTO</th>
                                    </tr>
                                    <tr class="filter-column-tr">
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                                                            @foreach( $gastos as $gasto)
                                            <tr>
                                                <td>{{$gasto->egr_id}}</td>
                                                <td>{{substr($gasto->egr_fecha,0,10)}}</td>
                                                <td>{{$gasto->beneficiaro}}</td>
                                                <td>{{$gasto->concepto}}</td>
                                                <td>{{$gasto->cuenta}}</td>
                                                <td>{{$gasto->egr_nota}}</td>
                                                <td  style="text-align: right">{{ number_format($gasto->egr_monto)}}</td>
                                            </tr>
                                                                                    @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td></td>
                                            <td>Total</td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td style="text-align: right">{{number_format($total_monto_ben,2)}}</td>
                                        </tr>
                                    </tfoot>
                                </table>
                            @endif
                            <table class="table table-hover">
                            </table>
                        </div>
                        <div class="tab-pane " id="beneficiario_concepto">
                            @if( Input::get('fecha_rango') )
                                <hr />
                                <h2>Beneficiarios por Conceptos</h2>
                                <table class="table table-striped table-colored-bordered table-bordered-inverse table-hover table-responsive" id="table-2">
                                    <thead>

                                    <tr>
                                        <th>NUMERO</th>
                                        <th>FECHA</th>
                                        <th>BENEFICIARIO</th>
                                        <th>CONCEPTO</th>
                                        <th>CUENTA</th>
                                        <th>NOTA</th>
                                        <th>MONTO</th>
                                    </tr>
                                    <tr class="filter-column-tr">
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                                                        @foreach( $gastos_conceptos as $gastos_concepto)
                                        <tr>
                                            <td>{{$gastos_concepto->egr_id}}</td>
                                            <td>{{substr($gastos_concepto->egr_fecha,0,10)}}</td>
                                            <td>{{$gastos_concepto->beneficiaro}}</td>
                                            <td>{{$gastos_concepto->concepto}}</td>
                                            <td>{{$gastos_concepto->cuenta}}</td>
                                            <td>{{$gastos_concepto->egr_nota}}</td>
                                            <td  style="text-align: right">{{ number_format($gastos_concepto->egr_monto)}}</td>
                                        </tr>
                                                                            @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td></td>
                                            <td>Total</td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td>{{$total_monto_con}}</td>
                                        </tr>
                                    </tfoot>
                                </table>
                            @endif
                            <table class="table table-hover">
                            </table>
                        </div>
                        <div class="tab-pane " id="beneficiario_tipo_concepto">
                            @if( Input::get('fecha_rango') )
                                <hr />
                                <h2>Beneficiario Tipo Concepto</h2>
                                <table class="table table-striped table-colored-bordered table-bordered-inverse table-hover table-responsive" id="table-3">
                                    <thead>

                                    <tr>
                                        <th>NUMERO</th>
                                        <th>FECHA</th>
                                        <th>BENEFICIARIO</th>
                                        <th>CONCEPTO</th>
                                        <th>CUENTA</th>
                                        <th>NOTA</th>
                                        <th>MONTO</th>
                                    </tr>
                                    <tr class="filter-column-tr">
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                                                        @foreach( $gastos_tipo_conceptos as $gastos_tipo_concepto)
                                        <tr>
                                            <td>{{$gastos_tipo_concepto->egr_id}}</td>
                                            <td>{{substr($gastos_tipo_concepto->egr_fecha,0,10)}}</td>
                                            <td>{{$gastos_tipo_concepto->beneficiaro}}</td>
                                            <td>{{$gastos_tipo_concepto->concepto}}</td>
                                            <td>{{$gastos_tipo_concepto->cuenta}}</td>
                                            <td>{{$gastos_tipo_concepto->egr_nota}}</td>
                                            <td  style="text-align: right">{{ number_format($gastos_tipo_concepto->egr_monto)}}</td>
                                        </tr>
                                                                            @endforeach

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td></td>
                                            <td>Total</td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td>{{$total_monto_tip}}</td>
                                        </tr>


                                    </tfoot>
                                </table>
                            @endif
                            <table class="table table-hover">
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            <div class="clearfix"></div>
        </div>
    </div>
</div>

@section('footer')
    <script src="/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="/plugins/datatables/dataTables.bootstrap.js"></script>
<script type="text/javascript">

    setDatatable('#table-1');
    setDatatable('#table-2');
    setDatatable('#table-3');

    $('#fecha_rango').daterangepicker(
        {
            ranges: {
                'Ayer': [moment().subtract('days', 1), moment().subtract('days', 1)],
                'Últimos 7 días': [moment().subtract('days', 6), moment()],
                'Últimos 15 días': [moment().subtract('days', 14), moment()],
                'Últimos 30 días': [moment().subtract('month', 1), moment()],
                'Mes actual': [moment().startOf('month'), moment().endOf('month')],
                'Mes anterior': [moment().subtract('month', 1).startOf('month'), moment().subtract('month', 1).endOf('month')],
                'Ultimos 3 meses': [moment().subtract('month', 3), moment()],
                'Ultimos 6 meses': [moment().subtract('month', 6), moment()],
                'Año actual': [moment().startOf('year'), moment()]

            },

            locale: {
                endDate: moment(),
                format: 'YYYY-MM-DD',
                separator: ' | ',
                applyLabel: 'Aplicar',
                cancelLabel: 'Cancelar',
                fromLabel: 'Desde',
                toLabel: 'Hasta',
                weekLabel: 'S',
                customRangeLabel: 'Otro Rango'
            }
        }
    );
</script>

@stop