@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/closed/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-4">
                                        <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']}}</option>
                                                    @endforeach  
                                                </select>
                                            </div>
                                            <span class="input-group-addon">
                                                <i></i>
                                            </span>
                                        </div>
                                    </div>-->

                                    <!--<div class="col-md-4">
                                        <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="">Select</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-5">
                                        <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-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-lg-4 col-md-4 col-sm-4 col-xs-4 align-center">
                                        <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>CustName</th>
                                            <th>Group</th>
                                            <th>RegNo</th>
                                            <th>InsPaid</th>
                                            <th>TotalIns</th>                                            
                                            <th>JoinDate</th>                                            
                                            <th>BillDate</th>
                                            <th>BillNo</th>
                                            <th>Amount</th>
                                            <th>Weight</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(count($payment_history)>0) 
                                            @foreach($payment_history as $key=>$item)
                                                @php
                                                    $userinfo = DB::table('users')->where('id',$item->user_id)->first();
                                                    $inspaid = DB::table('payment_details')->where('chit_detail_id',$item->id)->count();
                                                    $gold_weight = DB::table('payment_details')->where('chit_detail_id',$item->id)->sum('gold_weight');
                                                    $paymentinfo = DB::table('payment_details')->where('chit_detail_id',$item->id)->orderBy('id','DESC')->first();

                                                    if($item->scheme_id && $item->group_id) {
                                                        $chitinfo = DB::table('chit_scheme')->where('scheme_id',$item->scheme_id)->where('id',$item->group_id)->first();
                                                    }
                                                @endphp
                                                <tr>
                                                    <td>{{ $key+1 }}</td>
                                                    <td>@if(isset($userinfo->name)) {{ $userinfo->name }} @endif</td>
                                                    <td>@if(isset($chitinfo->chit_name)) {{ $chitinfo->chit_name }} @endif</td>
                                                    <td>@if($item->regno) {{ $item->regno }} @endif</td>
                                                    <td>{{ $inspaid }}</td>
                                                    <td>{{ isset($chitinfo->no_of_installment)?$chitinfo->no_of_installment:'-' }}</td>
                                                    <td>
                                                        @if($item->joining_date && $item->joining_date!='0000-00-00') 
                                                            {{ date("d/m/Y",strtotime($item->joining_date))}} 
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if($paymentinfo->payment_date && $paymentinfo->payment_date!='0000-00-00') 
                                                            {{ date("d/m/Y",strtotime($paymentinfo->payment_date))}} 
                                                        @endif
                                                    </td>
                                                    <td>{{$paymentinfo->bill_no}}</td>
                                                    <td><i class="fas fa-rupee-sign"></i> 
                                                    @php
                                                    $insamt = isset($chitinfo->installment_amount)?number_format($chitinfo->installment_amount):'';
                                                    @endphp
                                                    {{$insamt}}
                                                    @if(!$insamt)
                                                    {{isset($paymentinfo->amount)?number_format($paymentinfo->amount):''}}
                                                    @endif
                                                    </td>
                                                    <td>{{number_format($gold_weight,3)}}</td>
                                                </tr>
                                            @endforeach
                                        @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