@extends('layouts.app', ['pageSlug' => 'customerlist'])

@section('content')
<div class="splynx_top_nav">
    <div style="float: left">
        <ul class="splynx_breadcrumbs">
            <li><span>Invoice / Lists</span></li>
        </ul>
    </div>
    <div class="clearfix"></div>
</div>
<div class="spl-page-panel">
    <div class="row">
        <div class="col-lg-12">
            Search Date
        </div>
    </div>
    <br>
    <form method="GET" action="{{route('invoice.list')}}">
        <div class="row">
            <div class="col-md-3">		
                <div class="form-group">
					<input type="text" name="min_date" id="min" class="form-control datepicker" placeholder="Min Date" autocomplete="off" value="{{$start}}">
				</div>
			</div>
            <div class="col-md-3">	
				<div class="form-group">
					<input type="text" name="max_date" id="max" class="form-control datepicker" placeholder="Max Date" autocomplete="off" value="{{$end}}">
				</div>
			</div>
            <div class="col-md-3">
			    <button type="submit" class="search-btn btn btn-primary" title="Search">Search</button>
			</div>
		</div>
	</form>  
    <div class="row">
        <div class="col-lg-12">
            Invoice Lists
        </div>
    </div>
    <br>
    <div class="row">
        <div class="col-lg-12">
            <div class="p-3">                
                <table id="custom_table" class="table table-striped table-bordered">
                    <thead>
                        <th>#</th>
                        <th>Invoice Number</th>
                        <th>Mangaer</th>
                        <th>username</th>
                        <th>paid</th>
                        <th>price</th>
                        <th>tax</th>
                    </thead>
                    <tbody>
                        @foreach ($invoices as $key => $inv)
                        <tr>
                            <td>{{$key+1}}</td>
                            <td>{{$inv->invnum}}</td>
                            <td>{{$inv->managername}}</td>
                            <td>{{str_replace('_', ' ', $inv->username)}}</td>
                            <td>{{date('Y-m-d', strtotime($inv->paid))}}</td>
                            <td>{{number_format($inv->price, 2, '.', ' ')}}</td>
                            <td>{{number_format($inv->tax, 2, '.', ' ')}}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
           Approved Payments
        </div>
    </div>
    <br>
    <div class="row">
        <div class="col-lg-12">
            <div class="p-3">    
                <table id="approve_table" class="table table-striped table-bordered">
                    <thead>
                        <th>#</th>
                        <th>ID</th>
                        <th>Mangaer</th>
                        <th>username</th>
                        <th>paid</th>
                        <th>price</th>
                        <th>tax</th>
                    </thead>
                    <tbody>
                        @foreach ($payments->where('temp_status','approved') as $key => $val)
                        <tr>
                            <td>{{$key+1}}</td>
                            <td>{{$val->id}}</td>
                            <td>Portal</td>
                            <td>{{$val->username}}</td>
                            <td>{{date('Y-m-d', strtotime($val->created_at))}}</td>
                            <td>{{number_format($val->amount*$val->quantity, 2)}}</td>
                            <td>0</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
     <div class="row">
        <div class="col-lg-12">
           Pending Payments
        </div>
    </div>
    <br>
    <div class="row">
        <div class="col-lg-12">
            <div class="p-3"> 
                <table id="pending_table" class="table table-striped table-bordered">
                    <thead>
                        <th>#</th>
                        <th>ID</th>
                        <th>Mangaer</th>
                        <th>username</th>
                        <th>paid</th>
                        <th>price</th>
                        <th>tax</th>
                    </thead>
                    <tbody>
                        @foreach ($payments->where('temp_status','!=','approved') as $key => $val)
                        <tr>
                            <td>{{$key+1}}</td>
                            <td>{{$val->id}}</td>
                            <td>Portal</td>
                            <td>{{$val->username}}</td>
                            <td>{{date('Y-m-d', strtotime($val->created_at))}}</td>
                            <td>{{number_format($val->amount*$val->quantity, 2)}}</td>
                            <td>0</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection

@push('js')
<script>
    function confirmDelete(route) {
        var result = confirm( "Do you want to delete this?" );
        // if (result) {
        //     location.href = route;
        // }
    }
    $(document).ready(function(){
        $('#custom_table').dataTable();
        $('#approve_table').dataTable();
        $('#pending_table').dataTable();
    })
</script>
    
@endpush