@extends('adminlte::page')


@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title"><b>CPS Main verification </b></h3>
        </div>
        <!-- /.card-header -->
        <div class="card-body">


            <div class="card card-primary card-outline card-tabs">
                <div class="card-header p-0 pt-1 border-bottom-0">
                    <ul class="nav nav-tabs" id="custom-tabs-two-tab" role="tablist">
                        <li class="nav-item">
                            <a class="nav-link active" id="custom-tabs-two-home-tab" data-toggle="pill"
                                href="#custom-tabs-two-home" role="tab" aria-controls="custom-tabs-two-home"
                                aria-selected="true">Differences</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="custom-tabs-two-profile-tab" data-toggle="pill"
                                href="#custom-tabs-two-profile" role="tab" aria-controls="custom-tabs-two-profile"
                                aria-selected="false">CPS data</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="custom-tabs-two-messages-tab" data-toggle="pill"
                                href="#custom-tabs-two-messages" role="tab" aria-controls="custom-tabs-two-messages"
                                aria-selected="false">Our data</a>
                        </li>
                        {{-- <li class="nav-item">
                            <a class="nav-link" id="custom-tabs-combined-tab" data-toggle="pill"
                                href="#custom-tabs-combined" role="tab" aria-controls="custom-tabs-combined"
                                aria-selected="false">Combined</a>
                        </li> --}}

                    </ul>
                </div>
                <div class="card-body">
                    <div class="tab-content" id="custom-tabs-two-tabContent">
                        <div class="tab-pane fade show active" id="custom-tabs-two-home" role="tabpanel"
                            aria-labelledby="custom-tabs-two-home-tab">
                            <table class="table table-striped table-bordered">

                                <tr>
                                    <th>Week ID</th>
                                    <th>Date</td>
                                    <th>CPS starting balance</td>
                                    <th>Fees+NonDB</td>
                                    <th>CPS Subaccount</td>
                                    <th>ACH Cheques</td>
                                    <th>CPS final balance</th>
                                </tr>
                                @foreach ($difference as $c)
                                    <tr style="text-align: right">
                                        <td>{{ $c['week_id'] }}</td>
                                        <td>{{ $c['date'] }}</td>
                                        <td>{{ $c['cps_starting_balance'] }} </td>
                                        <td>{{ $c['fees_nondb'] }}</td>
                                        <td> {{ $c['cps_subaccount'] }}</td>
                                        <td> {{ $c['ach_cheques'] }}</td>
                                        <td> {{ $c['cps_final_balance'] }}</td>
                                    </tr>
                                @endforeach


                            </table>
                        </div>
                        <div class="tab-pane fade" id="custom-tabs-two-profile" role="tabpanel"
                            aria-labelledby="custom-tabs-two-profile-tab">
                            <a href="/cps-main-verification/export" class="btn btn-info"
                                style="float:right;margin-right:5px">Export</a>
                            <button type="button" class="btn btn-success" data-toggle="modal" data-target="#import"
                                style="margin-right: 5px;float:right">
                                Import
                            </button>
                            <br />
                            <br />
                            <table class="table table-striped table-bordered">

                                <tr>
                                    <th>Week ID</th>
                                    <th>Date</td>
                                    <th>CPS starting balance</td>
                                    <th>Fees+NonDB</td>
                                    <th>CPS Subaccount</td>
                                    <th>ACH Cheques</td>
                                    <th>CPS final balance</th>
                                    <th>Note</th>
                                    <th>Edit</th>

                                </tr>
                                @foreach ($cps_data as $c)
                                    <tr style="text-align: right">
                                        <td>{{ $c->week_id }}</td>
                                        <td>{{ getMondayFromWeekID($c->week_id) }}</td>
                                        <td>{{ number_format($c->cps_starting_balance,2) }} </td>
                                        <td>{{ number_format($c->fees_nondb,2) }}</td>
                                        <td> {{ number_format($c->cps_subaccount,2) }}</td>
                                        <td> {{ number_format($c->ach_cheques,2) }}</td>
                                        <td> {{ number_format($c->cps_final_balance,2) }}</td>
                                        <td> {{ $c->note }}</td>
                                        <td> <a href="/cps-main-verification/edit-cps-data/{{ $c->id }}"
                                                class="btn btn-warning">Edit </a></td>
                                    </tr>
                                @endforeach


                            </table>
                        </div>
                        <div class="tab-pane fade" id="custom-tabs-two-messages" role="tabpanel"
                            aria-labelledby="custom-tabs-two-messages-tab">

                            {{-- <a href="/cps-main-verification/calculate-starting-balance" class="btn btn-info"
                                style="float:right">Calculate starting balance </a>  --}}
                                
                                     <button type="button" class="btn btn-sm btn-success" data-toggle="modal" data-target="#calculate"
                style="margin-left: 5px;float:right">
                Calculate starting balance
            </button>
                                <br /><br />
                            <table class="table table-striped table-bordered">

                                <tr>
                                    <th>Week ID</th>
                                    <th>Date </td>
                                    <th>CPS starting balance</td>
                                    <th>Fees+NonDB</td>
                                    <th>CPS Subaccount</td>
                                    <th>ACH Cheques</td>
                                    <th>CPS final balance</th>
                                    <th>Edit</th>

                                </tr>
                                @foreach ($our_data as $c)
                                    <tr style="text-align: right">
                                        <td>{{ $c['week_id'] }}</td>
                                        <td>{{ $c['date'] }}</td>
                                        <td>{{ $c['cps_starting_balance'] }} </td>
                                        <td>{{ $c['fees_nondb'] }}</td>
                                        <td> {{ $c['cps_subaccount'] }}</td>
                                        <td> {{ $c['ach_cheques'] }}</td>
                                        <td> {{ $c['cps_final_balance'] }}</td>
                                        <td>
                                            @if ($c['starting_balance_id'] != null) <a
                                                    href="/cps-main-verification/edit-starting-balance/
                                        {{ $c['starting_balance_id'] }}" class="btn btn-warning">Edit</a> @else -
                                            @endif
                                        </td>
                                    </tr>
                                @endforeach


                            </table>
                        </div>

                          <div class="tab-pane fade" id="custom-tabs-combined" role="tabpanel"
                            aria-labelledby="custom-tabs-combined-tab">

                            <a href="/cps-main-verification/calculate-starting-balance" class="btn btn-info"
                                style="float:right">Calculate starting balance </a> <br /><br />
                            <table class="table table-striped table-bordered">

                                <tr>
                                    <th>CPS Starting Balace</th>
                                    <th>Fees + NonDB</th>
                                    <th>CPS Subaccount</th>
                                    <th>ACH Cheques</th>
                                    <th>CPS final balance</th>
                                </tr>
                                <tr>
                                    <td colspan="3">CPS Data</td>
                                    <td colspan="3">Our Data</td>
                                    <td colspan="3">Difference</td>
                                    
                                </tr>
                                {{-- @foreach ($our_data as $c)
                                    <tr style="text-align: right">
                                        <td>{{ $c['week_id'] }}</td>
                                        <td>{{ $c['date'] }}</td>
                                        <td>{{ $c['cps_starting_balance'] }} </td>
                                        <td>{{ $c['fees_nondb'] }}</td>
                                        <td> {{ $c['cps_subaccount'] }}</td>
                                        <td> {{ $c['ach_cheques'] }}</td>
                                        <td> {{ $c['cps_final_balance'] }}</td>
                                        <td>
                                            @if ($c['starting_balance_id'] != null) <a
                                                    href="/cps-main-verification/edit-starting-balance/
                                        {{ $c['starting_balance_id'] }}" class="btn btn-warning">Edit</a> @else -
                                            @endif
                                        </td>
                                    </tr>
                                @endforeach --}}


                            </table>
                        </div>

                    </div>
                </div>
                <!-- /.card -->
            </div>


        </div>
        <!-- /.card-body -->
    </div>
      <div class="modal fade" id="calculate">
        <div class="modal-dialog">
            <div class="modal-content">
                <form action="/cps-main-verification/calculate-starting-balance" method="get" >
                    @csrf
                    <div class="modal-header">
                        <h4 class="modal-title">Calculate Starting Balance</h4>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        
                        <label for="week_id">From Week ID</label>
                        <input type="text" name="from_week_id" id="week_id" value="{{date('yW')}}" class="form-control"/>

                        <label for="week_id">To Week ID</label>
                        <input type="text" name="to_week_id" id="week_id" value="{{date('yW')}}" class="form-control"/>

                        <br/>
                     
                        <input type="submit" class="btn btn-success" value="Calculate" />
                    </div>
                </form>

            </div>
        </div>
        <!-- /.modal-content -->
    </div>

    <div class="modal fade" id="import">
        <div class="modal-dialog">
            <div class="modal-content">
                <form action="/cps-main-verification/import" method="post" enctype="multipart/form-data">
                    @csrf
                    <div class="modal-header">
                        <h4 class="modal-title">Import CPS Verification</h4>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">

                        <label for="report">Report</label>
                        <input type="file" id="report" name="report" multiple="multiple" class="form-control" /> <br />
                        <input type="submit" class="btn btn-success" value="Import" />
                    </div>
                </form>

            </div>
        </div>
        <!-- /.modal-content -->
    </div>
@stop

@section('css')

@stop

@section('js')

@stop