@extends('layouts.master-vnext')
@inject('dateranges', 'App\Services\DateRangePickerService')

@section('page-title')
Reports
@endsection

@section('content')

<div class="row">
    <div class="col-md-12">
        <div class="box">
            <div class="box-body">
                <form action="{{ action("Wages\PayrollController@selectPayDayForReport") }}" method="GET" class="form-inline">
                    <div class="form-group has-feedback" style="margin-left: 15px;">
                        <input type="text" class="form-control" id="filter-datetimerange"  style="width: 100%;">
                        <span class="fa fa-calendar form-control-feedback"></span>
                    </div>

                    <input type="hidden" id="filterFrom" name="filterFrom" />
                    <input type="hidden" id="filterTo" name="filterTo" />
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-md-12">
        <div class="box">

            <div class="box-body">
                <table class="table table-hover table-condensed">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th class="text-right">SSS</th>
                            <th class="text-right">SSS Loan</th>
                            <th class="text-right">Philcare</th>
                            <th class="text-right">Tax</th>
                            <th class="text-right">Pagibig</th>
                            <th class="text-right">Pagibig Loan</th>
                            <th class="text-right">Amount payed</th>
                        </tr>
                    </thead>

                    <tbody>
                        @foreach($paydays as $payday)
                        <tr>
                            <td>
                                {{ $payday->wage_date->format('Y-m-d') }}
                            </td>
                            <td class="text-right">
                                @currency($payday->total_sss)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_sss_loan)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_philcare)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_tax)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_pagibig)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_pagibig_fund)
                            </td>
                            <td class="text-right">
                                @currency($payday->total_received)
                            </td>
                            <td class="actions">
                                <a href="{{ action("Wages\PayrollController@companyReport", ['payday' => $payday->wage_date->format('Y-m-d')]) }}" class="btn btn-xs btn-default">
                                    <i class="fa fa-pencil-square-o"></i> Company report
                                </a>

                                <a href="{{ action("Wages\PayrollController@governmentReport", ['payday' => $payday->wage_date->format('Y-m-d')]) }}" class="btn btn-xs btn-default">
                                    <i class="fa fa-pencil-square-o"></i> Government report
                                </a>
                            </td>
                        </tr>
                        @endforeach


                    </tbody>
                    <tfoot>
                        <tr>
                            <td>Total</td>
                            <td class="text-right">@currency($paydays->sum('total_sss'))</td>
                            <td class="text-right">@currency($paydays->sum('total_sss_loan'))</td>
                            <td class="text-right">@currency($paydays->sum('total_philcare'))</td>
                            <td class="text-right">@currency($paydays->sum('total_tax'))</td>
                            <td class="text-right">@currency($paydays->sum('total_pagibig'))</td>
                            <td class="text-right">@currency($paydays->sum('total_pagibig_fund'))</td>
                            <td class="text-right">@currency($paydays->sum('total_received'))</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
</div>

@endsection


@section('js')
<script type="text/javascript">
$('#filter-datetimerange').daterangepicker({
    timePicker: true,
    timePicker24Hour: true,
    showDropdowns: true,

    startDate: moment('{{ $filterFrom->setTimezone('Asia/Manila')->toIso8601String() }}'),
    endDate: moment('{{ $filterTo->setTimezone('Asia/Manila')->toIso8601String() }}'),

    ranges: {
        @foreach($dateranges->default() as $range)
        '{{ $range["label"] }}': [moment('{{ $range["start"]->toIso8601String() }}'), moment('{{ $range["end"]->toIso8601String() }}')],
        @endforeach
    },
});

$('#filter-datetimerange').on('apply.daterangepicker', function(ev, picker) {
    $('#filterFrom').val(picker.startDate.format('YYYY-MM-DD HH:mm:ss'));
    $('#filterTo').val(picker.endDate.format('YYYY-MM-DD HH:mm:ss'));

    $(this).closest('form').submit();
});

</script>
@endsection