@extends('cms.layout.app')

@section('content')

<style>
    input[type="date"]::-webkit-calendar-picker-indicator {
        background: transparent;
        bottom: 0;
        color: transparent;
        cursor: pointer;
        height: auto;
        left: 0;
        position: absolute;
        right: 0;
        top: 0;
        width: auto;
    }
</style>
<div class="page-wrapper">
    <div class="page-header card">
        <div class="row align-items-end">
            <div class="col-lg-8">
                <div class="page-header-title">
                    <i class="icofont icofont-money bg-warning"></i>
                    <div class="d-inline">
                        <h4>Transaction Reports</h4>
                    </div>
                </div>
            </div>
            <div class="col-lg-4">
                <div class="page-header-breadcrumb">
                    <ul class="breadcrumb-title">
                        <li class="breadcrumb-item">
                            <a href="{{route('cms.dashboard')}}">
                                <i class="icofont icofont-home"></i>
                            </a>
                        </li>
                        <li class="breadcrumb-item"><a href="#!">Transaction Reports</a>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <div class="page-body">

        <div class="row">

            <div class="col-12">
                <div class="card">
                    <div class="card-block-small">
                        <form>
                            <div class="row">

                                <div class="col-3">
                                    <div class="form-group row">
                                        <label class="col-sm-3 col-form-label">Start</label>
                                        <div class="col-sm-9">
                                            <input type="date" name="start_date" value="{{$start_date}}" class="form-control">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-3">
                                    <div class="form-group row">
                                        <label class="col-sm-3 col-form-label">End</label>
                                        <div class="col-sm-9">
                                            <input type="date" name="end_date" value="{{$end_date}}"  class="form-control">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-3">
                                    <div class="form-group row">
                                        <label class="col-sm-3 col-form-label">Network</label>
                                        <div class="col-sm-9">
                                            <select name="network_id" id="" class="form-control">
                                                <option value="">ALL Networks</option>
                                                @foreach ($networks as $network)
                                                    <option {{$network_id == $network->id ? 'selected' : ''}} value="{{$network->id}}">{{$network->name}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-3">
                                    <div class="form-group row">
                                        <label class="col-sm-3 col-form-label">Store</label>
                                        <div class="col-sm-9">
                                            <input type="text" name="store_name" class="form-control" value="{{$store_name ?? ''}}">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <input type="submit" value="Filter" class="btn btn-primary float-right">
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>

            <div class="col-md-6 col-xl-4">
                <div class="card widget-card-1">
                    <div class="card-block-small">
                        <i class="icofont icofont-pie-chart bg-c-blue card1-icon"></i>
                        <span class="text-c-blue f-w-600">Total Transactions</span>
                        <h4>{{$transactions->count()}}</h4>
                    </div>
                </div>
            </div>

            <div class="col-md-6 col-xl-4">
                <div class="card widget-card-1">
                    <div class="card-block-small">
                        <i class="icofont icofont-pie-chart bg-c-yellow card1-icon"></i>
                        <span class="text-c-blue f-w-600">Total Amount</span>
                        <h4>${{$transactions->sum('amount')}}</h4>
                    </div>
                </div>
            </div>

            <div class="col-md-6 col-xl-4">
                <div class="card widget-card-1">
                    <div class="card-block-small">
                        <i class="icofont icofont-pie-chart bg-c-green card1-icon"></i>
                        <span class="text-c-blue f-w-600">Total Commission</span>
                        <h4>${{$transactions->sum('commission')}}</h4>
                    </div>
                </div>
            </div>

            <div class="col-12">
                <div class="card">
                    <div class="card-block table-border-style">
                        <div class="table-responsive p-4">
                            <table class="table datatable table-hover">
                                <thead>
                                    <tr>
                                        <th>Transaction ID</th>
                                        <th>Store</th>
                                        <th>Network</th>
                                        <th>Amount</th>
                                        <th>Commission</th>
                                        <th>Date</th>
                                        <th>Transaction Type</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($transactions as $transaction)
                                    <tr>
                                        <td>{{$transaction->transid}}</td>
                                        <td>{{$transaction->store->name}}</td>
                                        <td>{{$transaction->network->name}}</td>
                                        <td>${{$transaction->amount}}</td>
                                        <td>${{$transaction->commission}}</td>
                                        <td>{{date('m/d/Y g:i:s A', strtotime($transaction->transdate))}}</td>
                                        <td>{{$transaction->transtype}}</td>
                                    </tr>
                                    @endforeach

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>

        </div>


    </div>
</div>
@endsection


@section('page-script')
    <script>
            $(document).ready( function () {
                $('.datatable').DataTable();
            } );
    </script>
@endsection