@extends('layouts.layout')

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

@section('content')

@php
    $rolesArr = Auth::user()->roles;
    //print_r($rolesArr);
    $userrolename = isset($rolesArr)?$rolesArr->implode('name', ', '):'';
@endphp

<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">Payment Details </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('/')}}/payment/history/search">
                                @csrf
                                <div class="row clearfix">
                                    <div class="col-md-3">
                                        <b>Keyword </b>
                                            <div class="input-group">
                                                <div class="form-group">
                                                    <input type="text" name="searchkey" class="form-control" value="{{request()->get('searchkey')}}">
                                                <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> 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> From 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('/')}}/payment/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
                                 
                                <!--<div class="dt-buttons">          
    <button class="dt-button buttons-copy buttons-html5" tabindex="0" aria-controls="adminTable" type="button"><span>Copy</span></button> 
    <button class="dt-button buttons-excel buttons-html5" tabindex="0" aria-controls="adminTable" type="button"><span>Excel</span></button> 
    <button class="dt-button buttons-csv buttons-html5" tabindex="0" aria-controls="adminTable" type="button"><span>CSV</span></button> 
    <button class="dt-button buttons-pdf buttons-html5" tabindex="0" aria-controls="adminTable" type="button"><span>PDF</span></button> 
    <button class="dt-button buttons-print" tabindex="0" aria-controls="adminTable" type="button"><span>Print</span></button> 
</div>-->
<br>
                                <table id="adminTable" class="display table table-checkable order-column m-t-30 width-per-100">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Bill No</th>
                                            <th>Payment Date</th>
                                            <th>Amount</th>
                                            <th>Rate</th>
                                            <th>Weight</th>
                                            <th>Instalment</th>
                                            <th>Mode</th>
                                            <th>User Details</th>
                                            <th>Transaction Details</th>
                                            <th>Chit Details</th>
                                            <th>Action</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();

                                                    $chitdetailinfo = DB::table('chit_details')->where('id',$item->chit_detail_id)->first();
                                                    $chitinfo = '';
                                                    
                                                    if($chitdetailinfo) {
                                                        if($chitdetailinfo->scheme_id && $chitdetailinfo->group_id) {
                                                            $chitinfo = DB::table('chit_scheme')->where('scheme_id',$chitdetailinfo->scheme_id)->where('id',$chitdetailinfo->group_id)->first();
                                                        }
                                                    }
                                                @endphp
                                                <tr>
                                                    <td>{{ $key+1 }}</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>
                                                        @if($item->payment_date && $item->payment_date!='0000-00-00') 
                                                            {{ date("d/m/Y",strtotime($item->payment_date))}} 
                                                        @else
                                                            @if($item->created_at) 
                                                                {{ date("d/m/Y",strtotime($item->created_at))}} 
                                                            @endif
                                                        @endif
                                                    </td>
                                                    <td><i class="fas fa-rupee-sign"></i> {{ number_format((int)$item->amount) }}</td>
                                                    <td><i class="fas fa-rupee-sign"></i> {{ number_format((int)str_replace(',','',$item->gold_rate)) }}</td>
                                                    <td>{{ number_format($item->gold_weight,3) }}</td>
                                                    <td>{{ $item->no_of_installments }}</td>
                                                    <td>{{$item->payment_mode}}</td>
                                                    <td>
                                                        @if(isset($userinfo->name)) <span class="col-blue">Name :</span> {{ isset($userinfo->name)?$userinfo->name:'' }} @endif
                                                        @if(isset($userinfo->email)) <br> <span class="col-blue">Email : </span>{{ $userinfo->email }} @endif
                                                        @if(isset($userinfo->phone_no)) <br> <span class="col-blue">Phone No : </span>{{ $userinfo->phone_no }} @endif
                                                    </td>
                                                    <td>
                                                        @if($item->payment_mode=='Offline Payment')    
                                                            @if($item->screenshot) <br><span class="col-blue">Screenshot :</span> <a target="_blank" href="{{url('/')}}/uploads/members/{{$item->screenshot}}">Click Here to View</a> @endif
                                                            @if($item->approved==0) <br><button style="width:11pc !important;" onclick="confirmchitPayment({{$item->id}})" class="btn btn-sm btn-warning waves-effect m-t-15" title="Approve"> Want to Approve?</button>
                                                            @else <br><button class="btn btn-sm btn-success waves-effect m-t-15"> Approved</button>
                                                            @endif
                                                        @else
                                                            @if($item->transaction_id) <span class="col-blue">Transaction ID :</span> {{ $item->transaction_id }} @endif
                                                            @if($item->cheque_no) <br>
                                                            <span class="col-blue">Cheque No :</span> {{ $item->cheque_no }} @endif
                                                            @if($item->cheque_date && $item->cheque_date!='0000-00-00') <br> <span class="col-blue">Cheque Date : </span>{{ $item->cheque_date }} @endif
                                                            @if($item->bank_name) <br> <span class="col-blue">Bank Name : </span>{{ $item->bank_name }} @endif
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if($chitinfo)
                                                            @if($chitinfo->chit_name) <span class="col-blue">Group :</span> {{ $chitinfo->chit_name }} @endif
                                                            @if($chitinfo->no_of_installment) <br> <span class="col-blue">No.of Installment : </span>{{ $chitinfo->no_of_installment }} @endif
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if($userrolename=='Admin')
                                                            <!--<a href="javascript:viod(0)" onclick="confirmdelete({{$item->id}})" title="Delete Payment History">
                                                                <i class="fa fa-trash text-warning"></i>
                                                           </a>-->
                                                        @endif
                                                        <a target="_blank" href="{{url('/')}}/payment/history/receipt/{{$item->id}}" title="Print">
                                                            <i class="fa fa-print text-info"></i>
                                                        </a>
                                                        <a target="_blank" href="{{url('/')}}/payment/receipt/{{$item->id}}" title="Payment Entry">
                                                            <i class="fa fa-edit text-success"></i>
                                                        </a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <td colspan="12">
                                                    <div class="dataTables_paginate paging_simple_numbers text-center" style="margin:0 25%;">
                                                        {{ $payment_history->links() }}
                                                    </div>
                                                </td>
                                            </tr>
                                        @else 
                                            <tr>
                                                <td class="text-center" colspan="10">
                                                    <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 src="{{url('/')}}/assets/js/pages/tables/jquery-datatable.js"></script>
@endsection