@extends('adminlte::page')

@section('title', 'Dashboard')

@section('css')
<style>
    table {
        text-align: center;
    }
</style>

@section('content')
<div class="card card-default">
    <div class="card-header">Link statements</div>
    <div class="card-body">
        <h5 style="text-align:center"><b> CPS transactions not linked:</b> <a
                href="/unlinked-cps?fuel_provider=pilot">{{\App\CompasReport::where('fuel_provider','pilot')->has('pilotStatement','<',1)->count()}}
                pilot </a> |
            <a href="/unlinked-cps?fuel_provider=loves">
            {{\App\CompasReport::where('fuel_provider','loves')->where('fp_report_id','=',null)->count()}} loves </a> | 
            <a href="/unlinked-cps?fuel_provider=road-rangers">
            {{\App\CompasReport::where('fuel_provider','road_rangers')->has('RoadRangerStatement','<',1)->count()}} RR </a> |

            <a href="/unlinked-cps?fuel_provider=cps_checks">
            {{\App\CompasReport::where('fuel_provider','cps_checks')->where('fp_report_id','=',null)->count()}} CPS Checks </a> |

            <a href="/unlinked-cps?fuel_provider=independent">
            {{\App\CompasReport::where('fuel_provider','independent')->where('fp_report_id','=',null)->count()}} Independent </a>
        </h5> <br />

        <h3 style="text-align:center">Link FP statements</h3>
        <table class="table table-bordered table-hover" style="width: 800px;margin:0px auto;">
            <tr style="text-align:center">
                <th><a href="/unlinked-pilot-statements">Pilot transactions ({{$pilot_statements}})</a></td>
                <th style="width:170px"><a href="/loves-statements/check-statements">Love statements </a> ({{$love_statements}}) </td>
                <th><a href="/unlinked-road-rangers-statements">Road Rangers</a> ({{$road_rangers}})</th>
                <th>Indirect billing ({{\App\CPSStatement::where('report_id','=',null)->count()}}/{{\App\CPSStatement::count()}})</th>
                <th>Love rebates ({{$love_rebate}})</th>
                <th>Autocomplete unit#</th>

            </tr>
            <tr>
                <td>
                    <!-- <a href="/link-pilot-statements" class="btn btn-sm btn-success">Link all</a>  -->

                        
                       <a
                        href="/link-missing-pilot-statements" class="btn btn-sm btn-success">Link new</a> 

                        <!-- <a
                        href="/unlink-last-week-pilot-statements" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure')">Unlink last week</a>  -->

                        
                    
                    </td>
                <td><a href="/link-love-statements"
                        class="btn btn-sm btn-success">Link now</a>| <a href="/unlink-love-statements" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')">Empty</a>
                    
                    </td>
                <td> <a href="/link-road-rangers" class="btn btn-sm btn-success">Link</a></td>
                <td><a href="/link-indirect-billing" class="btn btn-sm btn-success">Link</a></td>
                <td><a href="/link-love-rebate" class="btn btn-sm btn-success">Link</a></td>
                <td><a href="/autocomplete-unit-no" class="btn btn-sm btn-success">Execute</a> 
                | <a href="/empty-unit-no" onclick="return confirm('Are you sure')" class="btn btn-sm btn-danger">Empty</a>
            </td>


        

            </tr>
        </table>



        <h3 style="text-align: center;margin-top:50px;">Profit & discount calculation </h3>
        <table class="table table-bordered table-hover" style="width: 800px;margin:0px auto;">
            <tr style="text-align:center">
                <th>Discount<br/> ({{$discount_not_calculated}} not calculated)</th>
                <th>Empty discount</th>
                <th>Profit Pilot ({{$profit_pilot}})</th>
                <th>Profit Loves ({{$profit_loves}})</th>
                <th>Profit not calculated <br/>({{$profit_all}})</td>
                <th>Empty</th>

            </tr>
            <tr>
                <td>
                <a href="/calculate-discount" class="btn btn-sm btn-success" style="width: 160px;">Calculate discount</a>  
                <!-- <a href="/calculate-discount?discount_type=static" class="btn btn-sm btn-success" style="margin-top:5px">Calculate static discount</a>  -->
                </td>
                <td>
                <a class="btn btn-sm btn-danger" href="/empty-discount?last_week" onclick="return confirm('Are you sure?')">Last week</a> <br/> <br/>    
                <button type="button" class="btn btn-sm btn-danger" data-toggle="modal" data-target="#delete-discount" style="margin-left: 5px;float:right">
             Advanced delete
        </button>
                <div class="modal fade" id="delete-discount">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="/empty-discount" method="get">
                @csrf
                <div class="modal-header">
                    <h4 class="modal-title">Advanced delete</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="carrier">Carrier</label>
                    <select name="carrier_id" id="carrier" class="form-control">
                        <option value=""> All</option>
                        @foreach($carriers as $carrier)
                        <option value="{{$carrier->id}}">{{$carrier->name}}</option>
                        @endforeach
                    </select><br />
                    <label for="week_id">Week ID</label>
                    <input type="text" name="week_id" id="week_id" class="form-control" value="20{{date('W')-1}}" />

<br/>
                    <input type="submit" class="btn btn-danger" value="Delete" />
                </div>
            </form>

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

                <!-- <a class="btn btn-sm btn-danger" href="/empty-discount" onclick="return confirm('Are you sure?')" style="width:70px;margin-top: 5px;">All</a> -->


                </div>

                </td>

                <td><a href="/calculate-profit?fuel_provider=loves"
                        class="btn btn-sm btn-success">Calculate</a></td>
                <td><a href="/calculate-profit?fuel_provider=pilot"
                        class="btn btn-sm btn-success">Calculate</a></td>
                <td>
                    <b><a href="/calculate-profit" class="btn btn-sm btn-success">Calculate all</a> 
                </td>
                <td> <a
                        href="/empty-profit?last_week" onclick="return confirm('Are you sure?')"
                        class="btn btn-sm btn-danger">Last week</a> <br/> <br/>
                        <!-- <a
                        href="/empty-profit" onclick="return confirm('Are you sure?')"
                        class="btn btn-sm btn-danger" style="width:70px;margin-top:5px">All</a> -->

                        <button type="button" class="btn btn-sm btn-danger" data-toggle="modal" data-target="#delete-profit" style="margin-left: 5px;float:right">
             Advanced delete
        </button>
                <div class="modal fade" id="delete-profit">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="/empty-profit" method="get">
                @csrf
                <div class="modal-header">
                    <h4 class="modal-title">Advanced delete</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="carrier">Carrier</label>
                    <select name="carrier_id" id="carrier" class="form-control">
                        <option value=""> All</option>
                        @foreach($carriers as $carrier)
                        <option value="{{$carrier->id}}">{{$carrier->name}}</option>
                        @endforeach
                    </select><br />
                    <label for="fp">Fuel provider</label>
                    <select name="fuel_provider" id="fp" class="form-control">
                        <option value=""> All</option>
                        <option value="pilot">Pilot</option>
                        <option value="loves">Loves</option>
                    </select><br />
                    <label for="week_id">Week ID</label>
                    <input type="text" name="week_id" id="week_id" class="form-control" value="20{{date('W')-1}}" />

<br/>
                    <input type="submit" class="btn btn-danger" value="Delete" />
                </div>
            </form>
                </td>

            </tr>
        </table>

        <h3 style="text-align: center;margin-top:50px">Daily prices</h3>
        <table class="table table-bordered table-hover" style="width: 500px; margin:0px auto;">
            <tr style="text-align:center">
                <th style="width:152px">Pilot</td>
                <th style="width:152px">Loves</td>
                <th>Link</th>
                <th>Empty</th>

            </tr>
            <tr>
                
                <td>{{$pilot_statement_price}}</td>
                    
                    <td>{{$love_statement_price}}  </td>
                    <td><a href="/link-daily-prices"
                        class="btn btn-sm btn-success">Link</a> </td>
                    <td><a href="/empty-prices" class="btn btn-sm btn-danger"
                        onclick="return confirm('Are you sure?')">Empty</a>
                </td>

            </tr>
        </table>
        <span style="color:red;font-weight:bold"> Unlinked dates pilot :</span> {{implode(' ; ',$unlinked_pilot_statement_price)}}
        <br/><span style="color:red;font-weight:bold"> Unlinked dates loves:</span> {{implode(' ; ',$unlinked_love_statement_price)}}
        
    </div>
</div>


@stop