@extends('statepanel.layout.master')
@section('content')
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">

                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="{{ url('state-panel/home') }}">Home</a></li>
                            <li class="breadcrumb-item"><a href="{{ url('state-panel/garbagehome') }}">Garbage Home</a></li>
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Garbage Home Transactions</a></li>
                        </ol>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">

                <form action="{{ url('state-panel/garbageTransactions', ['txnId' => $txnId]) }}" method="get">
                    <div class="row">
                        <div class="col-md-12">
                            <div class="callout callout-info">
                                <h5><i class="fas fa-info"></i> Garbage Home Transactions:</h5>
                                List
                            </div>
                            <div class="card card-secondary">
                                <div class="card-header">
                                    <h2 class="card-title">Filter :</h2>
                                </div>

                                <!-- /.card-header -->
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label for="exampleInputEmail1">Date From</label>
                                                <input type="date" class="form-control" name="date_from"
                                                    value="{{ old('date_from', $date_from) }}">
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label for="exampleInputEmail1">Date To</label>
                                                <input type="date" class="form-control" name="date_to"
                                                    value="{{ old('date_to', $date_to) }}">
                                            </div>
                                        </div>                                       
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label for="exampleInputEmail1">Account Number</label>
                                                <input type="number" class="form-control" name="account_number"
                                                    placeholder="Enter Account Number" value="{{ old('account_number',$account_number) }}">
                                            </div>
                                        </div>

                                    </div>

                                </div>
                                <div class="card-footer">
                                    <div class="text-left">
                                        <button type="submit" name="search" value="search" class="btn btn-primary btn-sm">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/filter.png') }}"
                                                alt="filter" /> Filter</button>
                                        <a href="{{ url('state-panel/garbageTransactions', ['txnId' => $txnId]) }}"
                                            class="btn btn-primary btn-sm">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/clear.png') }}"
                                                alt="Clear" /> Clear</a>
                                        <a href="{{ url('state-panel/garbagehome') }}" class="btn btn-primary btn-sm">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/back.png') }}"
                                                alt="Back" /> Back</a>

                                    </div>
                                    <div class="text-right marginTopminus">
                                        <a href="{{ url('state-panel/export-garbageTransactions?type=CSV&date_from='.$date_from.'&date_to='.$date_to.'&account_number='.$account_number.'&txnId='.$txnId) }}"
                                            class="btn  btn-sm exportButtonBorder">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/csv.png') }}"
                                                alt="CSV" />CSV</a>
                                        <a href="{{ url('state-panel/export-garbageTransactions?type=EXCEL&date_from='.$date_from.'&date_to='.$date_to.'&account_number='.$account_number.'&txnId='.$txnId) }}"
                                            class="btn  btn-sm exportButtonBorder">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/excel.png') }}"
                                                alt="Excel" />Excel</a>
                                        <a href="{{ url('state-panel/garbageTransactions-pdf?date_from='.$date_from.'&date_to='.$date_to.'&account_number='.$account_number.'&txnId='.$txnId) }}"
                                            class="btn btn-sm exportButtonBorder">
                                            <img class="imgIconSize" src="{{ asset('theme/icon/pdf.png') }}"
                                                alt="PDF" /> PDF</a>
                                    </div>
                                </div>
                                <!-- /.card-body -->
                            </div>
                        </div>
                        <!-- /.col -->
                        <div class="col-md-12">

                            <!-- /.card -->

                            <div class="card">

                                <!-- /.card-header -->
                                <div class="card-body">
                                    <div class="card-header2">
                                        <p class="pMargin">Account Owner : {{$details->vendor_name}}</p>
                                        <p class="pMargin">House No  : {{$details->house_no}}</p>
                                        <p class="pMargin">Total Transactions: {{ $totaltxn }}</p>
                                        <p class="pMargin">Total Successful Transactions : {{ $totaltxnSuccess }}</p>
                                        <p class="pMargin">Total Failed Transactions : {{ $totaltxnFailed }}</p>
                                        <p class="pMargin">Total Cancelled Transactions : {{ $totaltxnCancelled }}</p>
                                    </div>
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr class="tableHeader">
                                                <th style="width: 10px">Count</th>
                                                <th>Date Time</th>
                                                <th>LG </th>
                                                <th>Account Number</th>
                                                <th>Amount Paid </th>
                                                <th>txn_by</th>
                                                <th>txn_type</th>
                                                <th>Due Date</th>
                                                <th>Reference</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>