@extends('admin.layout')

@section('content')

    <div class="wrapper-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <p class="m-n font-thin h3">Report(Transaction)</p>
                    </div>
                    <div class="col-md-2 text-right">

                    </div>
                </div>
            </div>


                <div class="panel-body">
                <div class="card">
                    <div class="card-body">

                  <form method="GET" action="{{ url('/report-transaction') }}" accept-charset="UTF-8" autocomplete="off" class="form-inline my-2 my-lg-0 float-right" role="search">
                      <div class="input-group">
                          <label>Invoice No.</label>
                          <input type="text" class="form-control" name="invoice"  value="{{ request('invoice') }}">
                      </div>
                            <div class="input-group">
                                <label>Category(Income/Expense)</label>
                                <select class="form-control selectpicker" name="searchAccount[]" multiple  data-selected-text-format="count"  data-size="5" data-actions-box="true"  data-live-search="true"  >
                                    <option value="">--Search By Category--</option>
                                    @foreach($category as $key=>$item)
                                    <option value="{{$item->name}}"  @if(  @in_array($item->name, request('searchAccount'))) selected @endif>{{ $item->name }}</option>
                                        @endforeach
                                </select>

                            </div>

                      <div class="form-group {{ $errors->has('date') ? 'has-error' : ''}}  " >
                          <label for="date" >{{ 'Date From' }}</label><br>
                          <input class="form-control" name="date_from" type="text"   value="{{  request('date_from') }}" data-provide="datepicker"
                                 data-date-format="dd/mm/yyyy">
                          {!! $errors->first('date', '<p class="help-block">:message</p>') !!}
                      </div>

                      <div class="form-group {{ $errors->has('date') ? 'has-error' : ''}}  "  >
                          <label for="date"  >{{ 'Date To' }}</label><br>
                          <input class="form-control" name="date_to" type="text"   value="{{  request('date_to') }}" data-provide="datepicker"
                                 data-date-format="dd/mm/yyyy">
                          {!! $errors->first('date', '<p class="help-block">:message</p>') !!}
                      </div>


                      <div class="input-group pt-4"><br>
                                    <button class="btn btn-secondary" type="submit">
                                        <i class="fa fa-search"></i> Search
                                    </button>
                      </div>
                        </form>

                        <br/>
                        <br/>
                        <div class="table-responsive">
                            <table class="table table-bordered table-primary   dataTable table-hover">
                                <thead>
                                    <tr>
                                        <th>Date</th><th>Invoice</th>  <th>Category</th>  <th>Type</th>   <th>Debit</th>     <th>Credit</th>   <th class="text-right">Balance</th>
                                    </tr>
                                </thead>
                                <tbody>
                                @php $total =0; @endphp
                                @foreach($result as $item)
                                    <tr>
                                        <td>{{ !empty($item->created_at)? date('d/m/Y',  strtotime($item->created_at)) : '' }}</td>
                                        <td>{{ $item->invoice_id ?? '' }}</td>
                                        <td>{{ $item->category ?? '' }}</td>
                                        <td>{{ $item->type ?? '' }}</td>
                                        <td>{{ $item->dr ?? '' }}</td>
                                        <td>{{ $item->cr ?? '' }}</td>
                                        <td>{{ $item->bal ?? '' }}</td>


                                    </tr>
                                @endforeach
                                </tbody>

                            </table>

                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
    <script src=" https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>


    <link rel="stylesheet" href="//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
    <script src="//cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>

    <style>
        .dataTables_wrapper .dataTables_paginate .paginate_button{
            padding: 0 !important;
        }
    </style>
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.4.1/css/buttons.dataTables.min.css">
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.flash.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.html5.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.print.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            ////////////////////////////////////////////////////////////////////////////////////////
            $(".dataTable3").dataTable();
            $('.dataTable').dataTable({
                "bPaginate": true,
                "bLengthChange": false,
                "bFilter": true,
                "bSort": false,
                "bInfo": true,
                "bAutoWidth": false,
                dom: 'Bfrtip',
                select: true,
                fixedHeader: true,
                colReorder: true,
                "scrollY": 500,
                buttons: [
                    'csv','pdf', 'excel', 'print'
                ],
                "lengthMenu": [[ 10, 25, 50,100, -1], [ 10, 25, 50,100, "All"]],


                "bPaginate": true,
                "sPaginationType": "full_numbers",
            });
        });
    </script>
@endsection