@extends('layouts.app')
@section('content')
    <link rel="stylesheet"
        href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/css/bootstrap-datepicker.min.css">
    <div class="container">
        <div class="col-md-12">
            <form class="date-range-filter" name="documentTransactionReportForm" id="documentTransactionReportForm"
                class="form-inline" action="{{ URL::route('admin.documentTransactionReport.filterEarnings') }}" method="POST">
                {{ csrf_field() }}
                <div class="form-group col-sm-3">
                    <label for="editor" class="control-label control-label col-xs-3 col-sm-12 col-md-12 col-lg-3"
                        style="margin-top: 4px;">Editor</label>
                    <div class="input-group input-group col-xs-5 col-sm-9">
                        <select name="editor" class="form-control" id="editor">
                            <option value="">--</option>
                                                    </select>
                    </div>
                </div>
                <div class="form-group col-sm-3">
                    <label for="from_date" class="control-label">From Date</label>
                    <div class="input-group date" id="datepicker_from">
                        <input type="text" value="{{ $curr_from_date }}" id="from_date" name="from_date" class="required"
                        title="Please select a From Date." class="form-control" />
                        <span class="input-group-append">
                            {{-- <span class="input-group-text bg-light d-block">
                                <i class="fa fa-calendar"></i>
                            </span> --}}
                        </span>
                    </div>
                  
                </div>
                <div class="form-group col-sm-3">
                    <label for="to_date" class="control-label">To Date</label>
                    <div class="input-group date" id="datepicker_to">
                        <input type="text" value="{{ $curr_to_date }}" id="to_date" name="to_date" class="required"
                        title="Please select a To Date." class="form-control" />
                        <span class="input-group-append">
                            {{-- <span class="input-group-text bg-light d-block">
                                <i class="fa fa-calendar"></i>
                            </span> --}}
                        </span>
                    </div>
                   
                </div>
                <button type="submit" class="btn knowmad_btn_blue knowmad_btn" name="search">Search</button>
                <button type="submit" class="btn knowmad_btn_blue knowmad_btn" name="export">Export</button>
            </form>
            <div class="row margin-top-10">
                <div class="col-md-12">
                    <table class="table table-striped tableStyle no-bottom dt-responsive" 
                        id="documentTransactionReport">
                        <thead>
                            <tr>
                                <th>
                                    File Name
                                </th>
                                <th>
                                    Category
                                </th>
                                <th>
                                    Num of Words
                                </th>
                                <th>
                                    Service
                                </th>
                                <th>
                                    Submit Date
                                </th>
                                <th>
                                    Editor
                                </th>
                                <th>
                                    Client
                                </th>
                                <th>
                                    Total
                                </th>
                                <th>
                                    Editor Earnings
                                </th>
                                <th>
                                    Payment Type
                                </th>
                                <th>
                                    Coupon Code
                                </th>
                            </tr>
                        </thead>
                        <tbody>
                                                        @foreach ($transactions as $transaction)
                                <tr>
                                    <td>
                                        {{ document()->getDocumentName($transaction->doc_name) }}
                                    </td>
                                    <td>
                                        {{ $transaction->categories }}
                                    </td>
                                    <td>
                                        {{ $transaction->no_of_words }}
                                    </td>
                                    <td>
                                        {{ $transaction->service_type }}
                                    </td>
                                    <td>
                                        {{ $transaction->start_date }}
                                    </td>
                                    <td>
                                        {{ $transaction->editor_username }}
                                    </td>
                                    <td>
                                        {{ $transaction->client_username }}
                                    </td>
                                    <td>
                                        {{ money_format('%.2n', $transaction->total) }}
                                    </td>
                                    <td>
                                        {{ money_format('%.2n', $transaction->editor_earnings) }}
                                    </td>
                                    <td>
                                        {{ $transaction->gateway }}
                                    </td>
                                    <td>
                                        {{ $transaction->coupon_code }}
                                    </td>
                                </tr>
                                                            @endforeach
                        </tbody>

                        @if (count($transactions) > 0)
                            <tfoot>
                                <tr>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>Total</td>
                                    <td>{{ money_format('%.2n', $total_transactions) }}</td>
                                    <td>{{ money_format('%.2n', $total_editors) }}</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                </tr>
                            </tfoot>
                        @endif
                    </table>
                </div>
            </div>
        </div>
    </div>

@stop
@push('footer_js')
    <script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/js/bootstrap-datepicker.min.js"></script>
    <script src="/js/reports.js"></script>
    <script type="text/javascript">
        $(function() {
            $('#datepicker_from').datepicker();
        });

        $(function() {
            $('#datepicker_to').datepicker();
        });
    </script>
@endpush