@extends('layouts.layout')

@section('title', 'Reports :: Transaction History')

@section('content')

<section class="content">
        <div class="container-fluid">
            <div class="block-header">
                <div class="row">
                    <div class="col-xs-9 col-sm-9 col-md-9 col-lg-9">
                        <ul class="breadcrumb breadcrumb-style ">
                            <li class="breadcrumb-item bcrumb-1">
                                <a href="{{url('/')}}/home">
                                    <i class="fas fa-home"></i> Home</a>
                            </li>
                            <li class="breadcrumb-item active">Reports</li>                            
                            <li class="breadcrumb-item active">Transaction History</li>                            
                        </ul>
                    </div>
                    <!-- <div class="col-xs-3 col-sm-3 col-md-3 col-lg-3 pull-right">
                        <a href="{{ route('contact.create') }}"><button type="button" id="event_add" class="btn btn-primary waves-effect m-t-15">Add New Contact
                        </button></a>
                    </div> -->
                </div>
            </div>
            <!-- Basic Examples -->
            <div class="row clearfix">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="card">
                        <div class="header">
                            <h2><strong>Transaction </strong>  History</h2>
                        </div>
                        <div class="body">

                            <form id="historyfrm" name="historyfrm" method="POST" action="{{url('/')}}/reports/history/search">
                                @csrf
                                <div class="row clearfix">
                                    <!-- <div class="col-md-3">
                                        <b> Keyword </b>
                                        <div class="input-group">
                                            <div class="form-line">
                                                <input type="text" name="searchkey" id="searchkey" class="form-control" maxlength="255" value="{{request()->get('searchkey')}}">
                                            </div>
                                            <span class="input-group-addon">
                                                <i></i>
                                            </span>
                                        </div>
                                    </div> -->
                                    <div class="col-md-3">
                                        <b> Users </b>
                                        <div class="input-group">
                                            <div class="form-group">
                                                <select class="form-control" data-placeholder="Select" name="user_id" id="user_id">
                                                    <option value="">All</option>
                                                    @foreach($userslist  as $key=>$item) 
                                                        @php
                                                            $id = request()->get('user_id');
                                                        @endphp
                                                        <option value="{{$item['id']}}" @if($id==$item['id']) selected @endif>{{$item['name']}} - {{$item['phone_no']}}</option>
                                                    @endforeach  
                                                </select>
                                            </div>
                                            <span class="input-group-addon">
                                                <i></i> 
                                            </span>
                                        </div>
                                    </div>

                                    <div class="col-md-3">
                                        <b> Payment Mode </b>
                                        <div class="input-group">
                                            <div class="form-group">
                                                <select required="" class="form-control" id="payment_mode" name="payment_mode">
                                                    <option value="">All</option>
                                                     @foreach($payment_mode as $key=>$item)
                                                        @php
                                                            $selected = '';
                                                            $payment_mode = request()->get('payment_mode');
                                                            if($item->name==$payment_mode) {
                                                                $selected = 'selected';
                                                            }
                                                        @endphp
                                                        <option {{$selected}} value="{{$item->name}}">{{$item->name}}</option>
                                                    @endforeach
                                                </select>
                                            <span class="input-group-addon">
                                                <i></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                                
                                <div class="col-md-3">
                                        <b>Scheme </b>
                                        <div class="input-group">
                                            <div class="form-group">
                                                <select required="" class="form-control" id="scheme_id" name="scheme_id">
                                                    <option value="">All</option>
                                                        @php
                                                            $selected = '';
                                                            $scheme_id = request()->get('scheme_id');
                                                        @endphp
                                                        <option @if($scheme_id==1) selected = 'selected' @endif value="1">Swarna Akshyam</option>
                                                        <option @if($scheme_id==2) selected = 'selected' @endif value="2">Gold Wallet</option>
                                                </select>
                                            <span class="input-group-addon">
                                                <i></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                                
                                    <div class="col-md-3">
                                        <b> Payment Date </b>
                                        <div class="input-group">
                                            <div class="form-line">
                                                <input id="myDateRange" type="date" name="date_range" class="form-control" value="{{request()->get('date_range')}}">
                                            </div>
                                            <span class="input-group-addon">
                                                <i></i>
                                            </span>
                                        </div>
                                    </div> 
                                    
                                    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 align-center" style="margin-top: -5%;">
                                        <button type="button" onclick="searchMember('history')" class="btn btn-primary m-b-20 m-t-10 waves-effect"> <i class="fas fa-search"></i> Search</button>
                                        <a href="{{url('/')}}/reports/history"><button type="button" class="btn btn-warning m-b-20 m-t-10 waves-effect"> Cancel</button></a>
                                        <button type="reset" class="btn btn-default m-b-20 m-t-10 waves-effect"> Reset</button>
                                    </div>
                                </div>
                            </form>

                            <div class="table-responsive">
                                @if(Session::has('message')) 
                                    <div class="alert bg-{{Session::get('status')}} alert-dismissible" role="alert">
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                            <span aria-hidden="true">×</span>
                                        </button>
                                        {{ Session::get('message') }}
                                    </div>
                                 @endif
                                <table id="adminTable" class="display table table-checkable order-column m-t-20 width-per-100">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Group</th>
                                            <th>RegNo</th>
                                            <th>ManualReceipt</th>
                                            <th>Amount</th>
                                            <th>PaymentDate</th>
                                            <th>Weight</th>
                                            <th>Ins</th>
                                            <th>ModePay</th> 
                                            <th>Remarks</th> 
                                            <th>EmpId</th>                                            
                                            <th>CustName</th>
                                            <th>MobileNumber</th>
                                            <th>Address 1</th>
                                            <th>Address 2</th>
                                            <th>Bank</th>
                                            <th>Branch</th>
                                            <th>ChqNo</th>
                                            <th>ChqDate</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(count($payment_history)>0) 
                                            @php $cardamt=0; $cash=0; $internetbanking=0; $cheque=0; $debitcard=0; $paytm=0; $others=0; @endphp
                                            @foreach($payment_history as $key=>$item)
                                                @php
                                                    $userinfo = DB::table('users')->where('id',$item->user_id)->first();

                                                    $chitdetailinfo = DB::table('chit_details')->where('id',$item->chit_detail_id)->first();
                                                    
                                                    //print_r($chitdetailinfo); exit;
                                                    
                                                    $chitinfo = '';
                                                    if(isset($chitdetailinfo->scheme_id) && isset($chitdetailinfo->group_id)) {
                                                        $chitinfo = DB::table('chit_scheme')->where('scheme_id',$chitdetailinfo->scheme_id)->where('id',$chitdetailinfo->group_id)->first();
                                                    }
                                                    if(isset($chitdetailinfo->scheme_id)) {
                                                        $chitinfo = DB::table('chit_scheme')->where('scheme_id',$chitdetailinfo->scheme_id)->first();
                                                    }
                                                @endphp
                                                <tr>
                                                    <td>{{ $key+1 }}</td>
                                                    <td>@if(isset($chitinfo->chit_name)) {{ $chitinfo->chit_name }} @endif</td>
                                                    <td>@if(isset($chitdetailinfo->regno)) {{ $chitdetailinfo->regno }} @endif</td>
                                                    <td>
                                                        @if($item->is_same_month=='1') 
                                                            <a title="Paid on the same month" class="text-warning"><i class="fa fa-info-circle"></i></a>
                                                        @endif 
                                                        {{ $item->bill_no }}</td>
                                                    <td><i class="fas fa-rupee-sign"></i> {{ number_format($item->amount) }}</td>
                                                    <td>{{ date("d/m/Y",strtotime($item->payment_date))}}</td>
                                                    <td>{{ number_format($item->gold_weight,3) }}</td>
                                                    <td>{{ $item->no_of_installments }}</td>
                                                    
                                                    <td>{{$item->payment_mode}}
                                                        @php
                                                            if($item->payment_mode=="Card") { $cardamt = $cardamt+$item->amount; }
                                                            if($item->payment_mode=="Cash") { $cash = $cash+$item->amount; }
                                                            if($item->payment_mode=="Internet Banking" || $item->payment_mode=="Offline Payment") { $internetbanking = $internetbanking+$item->amount; }
                                                            if($item->payment_mode=="Cheque") { $cheque = $cheque+$item->amount; }
                                                            if($item->payment_mode=="Debit Card") { $debitcard = $debitcard+$item->amount; }
                                                            if($item->payment_mode=="Others") { $others = $others+$item->amount; }
                                                            if($item->payment_mode=="Paytm") { $paytm = $paytm+$item->amount; }
                                                        @endphp
                                                    </td>
                                                    <td>
                                                        @if($item->transaction_id) {{ $item->transaction_id }} @endif <br>
                                                        @if($item->bank_name) {{ $item->bank_name }} @endif
                                                    </td>
                                                    <td> </td>
                                                    <td>@if(isset($userinfo->name)) {{ $userinfo->name }} @endif</td>
                                                    <td>@if(isset($userinfo->phone_no)) {{ $userinfo->phone_no }} @endif</td>
                                                    <td>@if(isset($userinfo->address)) {{ $userinfo->address }} @endif</td>
                                                    <td>@if(isset($userinfo->address1)) {{ $userinfo->address1 }} @endif</td>
                                                    <td>
                                                        @if($item->bank_name) {{ $item->bank_name }} @endif
                                                    </td>
                                                    <td></td>
                                                    <td>
                                                        @if($item->cheque_no) {{ $item->cheque_no }} @endif
                                                    </td>
                                                    <td>
                                                        @if($item->cheque_date && $item->cheque_date!='0000-00-00') 
                                                                {{ date("d/m/Y",strtotime($item->cheque_date))}} 
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endforeach
                                            <tfoot>
                                                @if(($cardamt+$debitcard)>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Card Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($cardamt+$debitcard)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                                
                                                @if($cash>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Cash Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($cash)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                                
                                                @if($internetbanking>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Internet Banking Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($internetbanking)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                                
                                                @if($cheque>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Cheque Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($cheque)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                                
                                                @if($paytm>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Paytm Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($paytm)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                                
                                                @if($others>0)
                                                <tr>
                                                    <th></th><th></th>
                                                    <th><b>Total Others Payment </b></th>
                                                    <th></th>
                                                    <th><i class="fas fa-rupee-sign"></i> {{number_format($others)}}</th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                    <th></th><th></th><th></th><th></th><th></th><th></th>
                                                </tr>
                                                @endif
                                            </tfoot>  
                                        @else 
                                            <tr>
                                                <td class="text-center" colspan="12">
                                                    <img src="{{url('/')}}/assets/images/nodata.png"> 
                                                    <br><h3>No records found!</h3> 
                                                </td>
                                            </tr>
                                        @endif
                                    </tbody>
                                </table>         
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
   
   <style type="text/css">#more0 {display: none;} #more1 {display: none;}</style>
   <script type="text/javascript">
       function myFunction(id) {
          var dots = document.getElementById("dots"+id);
          var moreText = document.getElementById("more"+id);
          var btnText = document.getElementById("myBtn"+id);

          if (dots.style.display === "none") {
            dots.style.display = "inline";
            btnText.innerHTML = "Read more";
            moreText.style.display = "none";
          } else {
            dots.style.display = "none";
            btnText.innerHTML = "Read less";
            moreText.style.display = "inline";
          }
        }
   </script>
   <script src="{{url('/')}}/assets/js/pages/tables/jquery-datatable.js"></script>
@endsection