@extends('adminlte::page')
@section('content')

<div class="card">
    <div class="card-header">
        <h3 class="card-title"><b>Daily prices pilot:
                {{\Carbon\Carbon::createFromFormat('Y-m-d',$date)->format('m/d/Y')}}</b>
        </h3>

        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#import"
            style="margin-left: 5px;float:right">
            <i class="fa fa-download"></i> Import daily prices
        </button>
        <form action="/daily-reports/daily-prices-pilot" class="form-inline" style="float:right">
            
            <label for="country">Country</label>
            <select name="country" class="form-control" id="country" style="margin-right:5px">
                <option value="us" @if(Request()->country=='us') selected @endif>US</option>
                <option value="can" @if(Request()->country=='can') selected @endif>CAN</option>
            </select>
            <label for="date" id="date">Date</label>
            <input type="date" name="date" class="form-control" id="date" value="{{$date}}">
            <input type="submit" value="Filter" class="btn btn-success" />
        </form>
    </div>
    <div class="card-body">
        <table class="table table-striped table-bordered datatables" id="summary">
            <thead style="text-align: center">
                <th>Country</th>
                <th>Date</th>
                <th>Site</th>
                <th>City</th>
                <th>Prov/State</th>
                <th>Rack id</th>
                <th>Rack city</th>
                <th>Retail price</th>
                <th>Your price</th>
                <th>Savings</th>
                <th>Our price + .05</th>
                <th>Our price + .07</th>
                <th>Our price + .10</th>
            </thead>
            <tbody>
                @foreach($report as $r)
                <tr>
                    <td>{{$r->country}}</td>
                    <td>{{$r->date}}</td>
                    <td>{{$r->site}}</td>
                    <td>{{$r->city}}</td>
                    <td>{{$r->state}}</td>
                    <td>{{$r->rack_id}}</td>
                    <td>{{$r->rack_city}}</td>
                    <td>{{$r->retail_price}}</td>
                    <td>{{$r->your_price}}</td>
                    <td>{{$r->savings_total}}</td>
                    <td>{{$r->your_price+0.05}}</td>
                    <td>{{$r->your_price+0.07}}</td>
                    <td>{{$r->your_price+0.10}}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    {{$report->count()}} records

    </div>
</div>
<!-- /.card-body -->
</div>
<div class="modal fade" id="import">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="/import" method="post" enctype="multipart/form-data">
                @csrf
                <div class="modal-header">
                    <h4 class="modal-title">Pilot daily prices import</h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="report_type" value="pillot-price-lists">
                    <label for="country">Country</label>
                    <select name="country" class="form-control" id="country">
                        <option value="us">US</option>
                        <option value="can">CAN</option>
                    </select>
                    <label for="report">Report</label>
                    <input type="file" id="report" name="reports[]" class="form-control" multiple="multiple"/> <br />
                    <input type="submit" class="btn btn-success" value="Import" />
                </div>
            </form>

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


@section('css')
<link rel="stylesheet" href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">
<script>
    $(function () {
        $(".datatables").DataTable({
            "bAutoWidth": false,
            "paging": false,
            "searching": false,
            "bInfo": false
        });
    });

</script>

@stop
@section('js')

@stop