@extends("app")


@section("content")

<style>
.correct {
  color: green;
}
.incorrect {
  color: red;
}
</style>
<div class="container">
    <div class="row">
        <div class="col-md-6">
            <h1 class="dashboard-heading">
                Divisas
            </h1>
            <h2 class="dashboard-heading">
                Zurich Santander
            </h2>
        </div>
        <div class="col-xs-12 col-sm-6 text-right">
            <!--            <a href="{{ action('CashFlowController@create') }}" class="btn btn-primary btn-header">-->              
                <a href="/divisas-ingresardatos" class="btn btn-primary btn-header">
                    Registrar información
                </a>
            </div>
        </div>
        {!! Form::open([
            'method' => 'GET',
            ]) !!}
            <div class="row">
                <div class="col-xs-6">

                    @php
                    $months = [];
                    $date = \Carbon\Carbon::today()->startOfMonth();
                    while(count($months) < 9) {
                    $months[$date->format('Y-m')] = ucfirst($date->formatLocalized('%B %Y'));
                    $date->subMonth();
                }

                @endphp

                <div class="form-group">
                    {!! Form::label('month', 'Mostrar información del mes') !!}
                    {!! Form::select('month', $months, \Carbon\Carbon::today()->format('Y-m'), ['class' => 'form-control']) !!}
                </div>
            </div>
        </div>
        {!! Form::close() !!}
        <div class="row">
            <div class="col-md-6">
                <h2 class="dashboard-heading">Dolares</h2>
            </div>
        </div>

        <div class="table-responsive">
            <table class=" table big-table table-striped table-hover big-table" id="table-divisas">
                <thead>
                    <tr>
                        <th>
                            FECHA   
                        </th>
                        <th>
                            DISPONIBILIDAD  
                        </th>
                        <th>
                            SALDO SANTANDER 5375
                        </th>
                        <th>
                            SALDO SANTANDER 7067
                        </th>
                        <th>
                            SALDO BANORTE 
                        </th>
                        <th>
                            SALDO MONEX
                        </th>
                        <th>
                            SALDO INTERCAM
                        </th>
                        <th>
                            SALDO VECTOR
                        </th>
                        <th>
                            DISPONIBILIDAD SALDOS
                        </th>
                        <th>
                            INGRESOS SANTANDER 5375 
                        </th>
                        <th>
                            INGRESOS SANTANDER 7067 
                        </th>
                        <th>
                            INGRESOS BANORTE    
                        </th>
                        <th>
                            INGRESOS MONEX  
                        </th>
                        <th>
                            INGRESOS INTERCAM   
                        </th>
                        <th>
                            INGRESOS VECTOR     
                        </th>
                        <th>
                            TOTAL DE INGRESOS   
                        </th>
                        <th>
                            EGRESOS SANTANDER 5375  
                        </th>
                        <th>
                            EGRESOS SANTANDER 7067  
                        </th>
                        <th>
                            EGRESOS BANORTE     
                        </th>
                        <th>
                            EGRESOS MONEX   
                        </th>
                        <th>
                            EGRESOS INTERCAM    
                        </th>
                        <th>
                            EGRESOS VECTOR  
                        </th>
                        <th>
                            TOTAL DE EGRESOS    
                        </th>
<!--                    <th>
                        DISPONIBILIDAD
                    </th>-->
                </tr>
            </thead>
            <tbody>

                @foreach($datesTransactionsDolar as $ForeignExchangeTransactionDetail)  
                <tr>
                    <td>
                        <span>
                            <a  class="test" href="/detalle-fecha/{{ $ForeignExchangeTransactionDetail['fecha']}}" data-toggle="tooltip" data-placement="left" title="Detalle" >{{ $ForeignExchangeTransactionDetail['fecha'] }}  </a>
<!--                                        <a class="test" href="/detalle-fecha/{{ $ForeignExchangeTransactionDetail['fecha']}}" >{{ $ForeignExchangeTransactionDetail['fecha'] }}  </a> -->
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['disponibilidad'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_santander']-$ForeignExchangeTransactionDetail['egresos_santander']-$ForeignExchangeTransactionDetail['ingresos_santander'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_santander2']-$ForeignExchangeTransactionDetail['egresos_santander2']-$ForeignExchangeTransactionDetail['ingresos_santander2'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_banorte']-$ForeignExchangeTransactionDetail['egresos_banorte']-$ForeignExchangeTransactionDetail['ingresos_banorte'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_monex']-$ForeignExchangeTransactionDetail['egresos_monex']-$ForeignExchangeTransactionDetail['ingresos_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_intercam']-$ForeignExchangeTransactionDetail['egresos_intercam']-$ForeignExchangeTransactionDetail['ingresos_intercam'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_vector']-$ForeignExchangeTransactionDetail['egresos_vector']-$ForeignExchangeTransactionDetail['ingresos_vector'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['disponibilidad_saldos']-$ForeignExchangeTransactionDetail['total_egresos']-$ForeignExchangeTransactionDetail['total_ingresos'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_santander'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_santander2'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_banorte'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_intercam'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_vector'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['total_ingresos'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_santander'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_santander2'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_banorte'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_intercam'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_vector'],2) }}
                        </span>
                    </td>
                    <td>
                        <span  >
                            $&nbsp;{{ number_format($ForeignExchangeTransactionDetail['total_egresos'],2) }}
                        </span>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    <!--/.Panel 1-->
    <!--Panel 2-->


    <!--TABLA DE EUROS  -->




    <div class="row">
        <div class="col-md-6">
            <h2 class="dashboard-heading">Euros</h2>
        </div>
    </div>

    <div class="table-responsive">
        <table class=" table big-table table-striped table-hover big-table" id="table-divisas">
            <thead>
                <tr>
                    <th>
                        FECHA   
                    </th>
                    <th>
                        DISPONIBILIDAD  
                    </th>
                    <th>
                        SALDO MONEX
                    </th>
                    <th>
                        SALDO INTERCAM
                    </th>
                    
                    <th>
                        INGRESOS MONEX  
                    </th>
                    <th>
                        INGRESOS INTERCAM   
                    </th>
                    <th>
                        TOTAL DE INGRESOS   
                    </th>
                    <th>
                        EGRESOS MONEX   
                    </th>
                    <th>
                        EGRESOS INTERCAM    
                    </th>
                    <th>
                        TOTAL DE EGRESOS    
                    </th>
                </tr>
            </thead>
            <tbody>

                @foreach($datesTransactionsEuro as $ForeignExchangeTransactionDetail)  
                <tr>
                    <td>
                        <span>
                            <a data-toggle="tooltip" data-placement="left" title="Detalle" class="test" href="/detalle-fecha/{{ $ForeignExchangeTransactionDetail['fecha']}}">{{ $ForeignExchangeTransactionDetail['fecha'] }}</a>
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['disponibilidad']-$ForeignExchangeTransactionDetail['total_egresos'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['saldo_intercam'],2) }}
                        </span>
                    </td>
                    
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['ingresos_intercam'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['total_ingresos'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_monex'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['egresos_intercam'],2) }}
                        </span>
                    </td>
                    <td>
                        <span >
                            €&nbsp;{{ number_format($ForeignExchangeTransactionDetail['total_egresos'],2) }}
                        </span>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>

@endsection

@section('script')
<script>
    $(document).ready(function(){
     $('[style="color:red;"]').each(function(i,v){
         let monto = $(v).text();
         $(v).text(monto.replace('-',''));
     }); 
 });
</script>
<script>
/*    $(function() {
      $('#month').change(function() {
        $(this).parents('form').submit();
      });
  });*/
</script>
<script>
/*  $(document).ready(function($) {
  $('table').hide();
  $('#month').change(function() {
    $('table').show();
    var selection = $(this).val();
    var dataset = $('#table-divisas tbody').find('tr');
    // show all rows first
    dataset.show();
    // filter the rows that should be hidden
    dataset.filter(function(index, item) {
      return $(item).find('span:first-child').text().indexOf(selection) === -1;
    }).hide();

  });
});*/
</script>
<script>
    $(document).ready(function($) {
        var selection = $('#month').val();
        if (selection) {
            $.each($('#table-divisas tbody tr'), function(index, item) {
              $(item)[$(item).is(':contains('+ selection  +')')? 'show' : 'hide']();
          });
        }
    });
</script>
<script>
    $(document).ready(function($) {
        $('#month').change( function(){
          var selection = $(this).val();
          if (selection) {
            $.each($('#table-divisas tbody tr'), function(index, item) {
              $(item)[$(item).is(':contains('+ selection  +')')? 'show' : 'hide']();
          });
        }
        
    });
    });
</script>
<!-- <script>
    $(document).ready(function() {
// Tooltip only Text
$('.masterTooltip').hover(function(){
        // Hover over code
        var title = $(this).attr('title');
        $(this).data('tipText', title).removeAttr('title');
        $('<p class="tooltip"></p>')
        .text(title)
        .appendTo('body')
        .fadeIn('slow');
}, function() {
        // Hover out code
        $(this).attr('title', $(this).data('tipText'));
        $('.tooltip').remove();
}).mousemove(function(e) {
        var mousex = e.pageX + 20; //Get X coordinates
        var mousey = e.pageY + 10; //Get Y coordinates
        $('.tooltip')
        .css({ top: mousey, left: mousex })
});
});
</script> -->
<!-- <script>
    $(document).ready(function($) {
        $('a').mouseenter(function (e) {             
            var posMouse = e.pageX - this.offsetLeft; 
            var textoTooltip = $(this).attr("title"); 

            if (textoTooltip.length > 0) {
                $(this).append('<div class="tooltip">' + textoTooltip + '</div>');
                $("a > div.tooltip").css("left", "" + posMouse - 103 + "px");
                $("a > div.tooltip").fadeIn(300);
            }
        });
    });

</script> -->

<!-- <script>
    $(document).ready(function(){
        $('.test').mouseover(function(){
            $('.test').css("position", "absolute");
        });
        $('.test').mouseoout(function(){
            $('.test').css("position", "absolute");
        });
    });
</script> -->
<!-- <script>
$(document).ready(function(){
    $('.test').mouseover(function(){
        $(this).css("display", "none");
    });
});
</script> -->
@endsection