@extends('inventory.layout') 
@section('title', 'Report')
@section('content')
 @push('head')
  
  <style>
    .error{
      color: red;
    }
    /*.searchclass{
        text-transform:capitalize;
    }*/
    .tradeadd{
        background-color: #2dce89;
        border-color: #2dce89;
        color:#fff !important;
    }
    .tradeadd:hover{
    background-color:#2dce89;
    border-color: #2dce89;c
    }
    .showmedia{
        padding-right: 10px;
    }


  </style>
  @endpush
    <!-- push external head elements to head --> 
    <div class="container-fluid">
        <div class="page-header">
            <div class="row align-items-end">
                <div class="col-lg-8">
                    <div class="page-header-title">
                        
                        <!-- <i class="ik ik-users bg-green"></i> -->
                        <div class="d-inline">
                            <h5>Reports</h5>
                            
                        </div>
                    </div>
                </div>
                <div class="col-lg-4">
                    <nav class="breadcrumb-container" aria-label="breadcrumb">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item">
                                <a href="{{url('dashboard')}}"><i class="ik ik-home"></i></a>
                            </li>
                            <li class="breadcrumb-item">
                                <a href="#">Reports</a>
                            </li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>
        <div class="row">
            <!-- list layout 1 start -->
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header row">
                       
                        <div class="col col-sm-12">
                            <div class="card-search with-adv-search dropdown">
                                <form action="{{route('reports.index')}}" method="get">
                                    <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                        <label for="pro">From </label>                                @if(Request::get('proceeding'))                          <input type="text" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{Request::get('proceeding')}}">   
                                        @else        
                                        <input type="text" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{isset($start) ? $start:''}}">
                                        @endif
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                        <label for="and">To </label>
                                        <input type="text" class="form-control searchclass" id="searches" name="from" value="{{ date('Y-m-d') }}" placeholder="From Date" >
                                    </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            {{\Request::get('user_id')}}
                                        <label for="adv">Advocate </label>
                                            <select  class="form-control" name="user_id" id="user">
                                            <option value="">-NA-</option>
                                                @foreach($users as $user)

                                                @if($user->id==Request::get('user_id'))
                                                    <option value="{{$user->id}}" selected="true">{{isset($user->name) ? $user->name:''}}</option>
                                                @else
                                                <option value="{{$user->id}}" >{{isset($user->name) ? $user->name:''}}</option>
                                                @endif
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                   
                                    <div class="col-md-3">
                                        <div class="form-group">
                                        <label for="adv">Client</label>
                                            <select  class="form-control" name="client_id" id="user">
                                            <option value="">Please Select</option>
                                                @foreach($clients as $client)
                                                    <option value="{{$client->id}}">{{isset($client->name) ? $client->name:''}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    
                                     <div class="col col-sm-3">
                                        <div class="card-options text-right">
                                            <span class="mr-5" id="top">{{--{{($tenants->currentpage()-1)*$tenants->perpage()+1}} to {{$tenants->currentpage()*$tenants->perpage()}}
                                                        of  {{$tenants->total()}} entries--}}</span>
                                            {{--<a href="#"><i class="ik ik-chevron-left"></i></a>
                                            <a href="#"><i class="ik ik-chevron-right"></i></a>
                                            <a href="{{route('tenant.create')}}" class=" btn btn-outline-primary btn-semi-rounded tradeadd"><i class="ik ik-plus"></i>&nbsp;Add Tenant</a>--}}
                                        </div>
                           
                                    </div>
                            
                                     <div class="col-md-12">
                                        <div class="form-group">
                                            <input style="    position: relative; top: 3px;" type="checkbox" name="charges" value="on" @if(isset($charges) ? $charges=='on':'') checked @endif>
                                            <label for="adv">Charges</label>
                                        </div>
                                    </div>
                                    
                                    <div class="col-sm-2">
                                    <div class="form-group">
                                        <button type="submit" style="font-size: 14px; height: 45px;  padding-left: 15px;  padding-right: 15px; background: #1e27a0; color: #fff;" class="btn">Search&nbsp; <i class="ik ik-search"></i></button>
                                    </div>
                                    </div>
                                    {{--<button type="button" id="adv_wrap_toggler_1" class="adv-btn ik ik-chevron-down dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></button>--}}
                                </div>
                                    
                                </form>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col col-sm-2"></div>
                            <div class="col col-sm-5">
                                <!--<div class="card-options text-right">
                                    
                                        <form action="{{route('exportTopdf')}}" method="get"> 
                                        <button type="submit" class="bpdf-green" title="PDF" style="font-size: 14px;height: 45px;padding-left: 15px;padding-right: 15px;background: #1e27a0;color: #fff;">
                                             @if(Request::get('proceeding'))                          <input type="hidden" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{Request::get('proceeding')}}">   
                                            @else         
                                            <input type="hidden" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{isset($start) ? $start:''}}">
                                            @endif
                                            <input type="hidden" class="form-control searchclass" id="searches" name="from" value="{{ date('Y-m-d') }}" placeholder="From Date" >
                                              <input type="hidden" class="form-control searchclass"  name="user_id" value="{{ Request::get('user_id')}}" >
                                            <input type="hidden" name="charges" value="{{isset($charges) ? $charges:''}}">
                                             <input type="hidden" name="client_id" value="{{ Request::get('client_id')}}">
                                            
                                            Export as PDF
                                        </button>  
                                        </form> 
                                    
                                </div>-->
                               
                            </div>

                            <div class="col col-sm-5">
                                <!--<div class="card-options text-right">
                                    
                                       
                                        
                                         <form action="{{route('exportToExcel')}}" method="get"> 
                                        <button type="submit" class="bpdf-green" title="CSV" style="font-size: 14px;height: 45px;padding-left: 15px;padding-right: 15px;background: #1e27a0;color: #fff;">
                                             @if(Request::get('proceeding'))                          <input type="hidden" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{Request::get('proceeding')}}">   
                                            @else         
                                            <input type="hidden" class="form-control global_filter searchclass" id="search" name="proceeding" placeholder="Proceeding" value="{{isset($start) ? $start:''}}">
                                            @endif
                                            <input type="hidden" class="form-control searchclass" id="searches" name="from" value="{{ date('Y-m-d') }}" placeholder="From Date" >
                                              <input type="hidden" class="form-control searchclass"  name="user_id" value="{{ Request::get('user_id')}}" >
                                            <input type="hidden" name="charges" value="{{isset($charges) ? $charges:''}}">
                                             <input type="hidden" name="client_id" value="{{ Request::get('client_id')}}">
                                            Export as CSV</button></form>
                                    
                                </div>
                               -->
                            </div>
                        </div> 
                       
                    </div>
                    @if(isset($userproceeding) && $userproceeding!='')
                    <div class="card-body">
                        <table id="product_table" class="table">
                            <thead>
                                <tr>
                                    
                                    <th>{{ __('Date')}}</th>
                                    <th>{{ __('Advocate')}}</th>
                                    <th>{{ __('Client')}}</th>
                                    <th>{{ __('Proceedings')}}</th>
                                    <th>{{ __('Duration')}}</th>
                                    <th>{{ __('Rate')}}</th>
                                    @if(isset($charges) && $charges!='')
                                    <th>{{ __('Charges')}}</th>
                                    @endif
                                   
                                </tr>
                            </thead>
                            <tbody>
                                
                                @foreach($userproceeding as $proceeding)
                                <tr>
                                    @if(isset($proceeding->DATE))
                                    <td>{{\Carbon\Carbon::parse($proceeding->DATE)->format('d M Y')}}</td>
                                    @endif
                                    <td>{{ isset($proceeding->Advocate) ? $proceeding->Advocate :'' }}</td>
                                    <td>
                                        {{ isset($proceeding->Client) ? $proceeding->Client :'' }}
                                    </td>
                                    <td>{{ isset($proceeding->Proceedings) ? $proceeding->Proceedings :'' }} <p style="color:blue;">File: {{isset($proceeding->orderdetail->file_no) ? $proceeding->orderdetail->file_no:''}} ({{\Carbon\Carbon::parse($proceeding->Date)->format('d M Y')}})</p></td>
                                    
                                    <td>    
                                        
                                      {{ isset($proceeding->advHours) ? $proceeding->advHours :'' }}                                  
                                    </td>
                                    <td>{{isset($proceeding->rate) ? $proceeding->rate :''  }}</td>
                                    @if(isset($charges) && $charges!='')
                                    @if(isset($hours) && isset($proceeding->rate))
                                    <td>
                                        {{(str_replace(':', '.',$proceeding->advHours))  * $proceeding->advChargesPerHr }}
                             
                                    </td>
                                    @endif
                                    @endif
                                    
                                    
                                </tr>
                                @endforeach
                                

<tr>
    <td colspan="3"> <th>{{ __('Total')}}</th> </td>
     <!-- <td colspan="2">  </td> -->
    <td colspan="">{{isset($totalhours) ? $totalhours:''}}</td>
    <td>{{isset($totalrates) ? $totalrates:''}} </td> 
    @if(isset($charges) && $charges!='')
    <td colspan="1">{{$totalhours * $totalrates }} </td> 
    @endif
    </tr>
                            </tbody>
                        </table>
                        <div class="card-footer d-flex align-items-center">

                                <div class="col-md-6">
                                </div>
                                
                                <div class="col-md-6">
                                {{--{{ $tenants->links('include.pagination') }}--}}
                                </div>
                        </div>
                    </div>
                    @else
                    <h5 style="text-align:center;">No Data Available</h5>
                    @endif
                </div>
            </div>
            <!-- list layout 1 end -->
            <div class="col-md-12"><hr></div>
            <!-- list layout 2 -->
            
            <!-- list layout 2 end -->
        </div>
    </div>
    
    <!-- category add modal-->
    
    <div class="modal fade edit-layout-modal pr-0 show" id="postView" tabindex="-1" role="dialog" aria-labelledby="productViewLabel" style="padding-right: 17px; display: none;" aria-modal="true">
      <div class="modal-dialog" role="document">
          <div class="modal-content">
              <div class="modal-header">
                  <h5 class="modal-title catname" id="productViewLabel"></h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
              </div>
              <div class="modal-body">
                  <div class="row">
                      <div class="col-4 appendimg">
                          
                      </div>
                  </div>
            
                          
              </div>
          </div>
      </div>

    </div>

@push('script')
<script src="{{ url('js/global.js')}}"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.1/bootstrap3-typeahead.min.js"></script>
<script src = "http://cdn.datatables.net/1.10.18/js/jquery.dataTables.min.js"></script>

<script type="text/javascript">

    var route = "{{ url('tenantsearch') }}";
 $('#search').typeahead({
            source: function (query, process) {
                return $.get(route, {
                    query: query
                }, function (data) {
                    console.log(data);
                    return process(data);
                });
            }
        });

 /*$(document).ready(function () {
    $('#product_table').DataTable({
        order: [[3, 'desc']],
    });
});*/
var table = $('#product_table').DataTable({

        paging: false,
        ordering: true,
        info: false,
        searching:false,
    });

</script>
 @endpush
 @endsection