@extends('Admin/layout')
@section('title','List View Downline')
@section('content')
@if(has_permission('Downline Upline','List View Downline'))
<div class="container-fluid">
    <div class="row">
    <div class="col-lg-12">
            <div class="card">
                <div class="card-header">
                    <div class="d-flex align-items-center flex-wrap gap-2">
                        <div class="flex-grow-1">
                            <h4 class="card-title mb-0 flex-grow-1">List View Downline</h4>
                            <form method="POST" action="{{route('visitportal.ListViewDownline')}}" class="needs-validation" novalidate >
                                @csrf
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="mb-3">
                                            <label for="Nameinput" class="form-label">Search By Associate Name/GK Code/Rera No </label>
                                            <select class="form-control single-select" id="associates_name" name="associates_name">
                                                <option value="" >Select Associates Name</option>
                                                @if(!empty($tblassociates))
                                                    @foreach($tblassociates as $key => $value)
                                                        <option value="{{$value->id}}" {{$associates_name == $value->id ? 'selected' : ''}}>{{$value->name}}, {{$value->gk_code}}, {{$value->rera_no}}</option>
                                                    @endforeach
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                      <div class="col-md-2">
                                        <label for="Nameinput" class="form-label">As on Date </label>
                                        <input type="date" class="form-control" name="as_on_date" id="as_on_date" value="{{$as_on_date}}" placeholder="As On Date " >
                                      </div>
                                        <div class="col-md-3" >
                                        <label for="Nameinput" class="form-label" style="margin-top: 30px;">Only active associate on date </label>
                                            <label>
                                            <input type="checkbox" id="active_associate_on_date" name="active_associate_on_date" {{ $active_associate_on_date == 1 ? 'checked' :'' }}>
                                            
                                            </label>
                                      </div>
                                    <div class="col-md-1">
                                        <div class="text-end">
                                            <button type="submit" class="btn btn-primary" style="margin-top: 27px;">Seach</button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                        <div class="flex-shrink-0">
                            
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-xl-12">
            <div class="card">
                <div class="card-body">
                    <div class="live-preview" style="padding: 20px;">
                        <div class="table-responsive table-card mb-1">
                            <table class="table table-sm table-striped align-middle table-nowrap mb-0" id="example" style="width:100%">
    <thead class="table-dark">
        <tr>
            <th scope="col">S.No</th>
            <th scope="col">Full Name</th>
            <th scope="col">GK Code</th>
            <th scope="col">Level</th>
            <th scope="col">Rera No</th>
            <!-- <th scope="col">Sponsor ID</th> -->
            <th scope="col">Sponsor GK Code</th>
            <th scope="col">Sponsor Name</th>
            <th scope="col">Sponsor Rera No</th>
            <th scope="col">Status</th>
            <th scope="col">Opening Stock</th>
            <th scope="col">Joining Date</th>
            <th scope="col">Left Date</th>
            <th scope="col">Personal Sale</th>
            <th scope="col">Team Sale</th>
            <th scope="col">Total Sale</th>
            <th scope="col">Company Sale Cur Month</th>
        </tr>
    </thead>

    <tbody>
        @if(!empty($downlinedata))
            @foreach($downlinedata as $key => $value)
                <tr>
                    <td>{{ $key + 1 }}</td>

                    <td>{{ $value->name ?? '-' }}</td>

                    <td>
                        <span class="badge bg-primary">
                            {{ $value->gk_code ?? '-' }}
                        </span>
                    </td>

                    <td>{{ $value->level ?? '-' }}</td>

                    <td>{{ $value->rera_no ?? '-' }}</td>

                    <!-- <td>{{ $value->sponsor_id ?? '-' }}</td> -->

                    <td>{{ $value->sponsor_gk_code ?? '-' }}</td>

                    <td>{{ $value->sponsor_name ?? '-' }}</td>

                    <td>{{ $value->sponsor_rera_no ?? '-' }}</td>

                    <td>
                        @if(strtoupper($value->currentStatus ?? '') == 'ACTIVE')
                            <span class="badge bg-success">
                                ACTIVE
                            </span>
                        @elseif(strtoupper($value->currentStatus ?? '') == 'LEFT')
                            <span class="badge bg-danger">
                                LEFT
                            </span>
                        @else
                            <span class="badge bg-warning text-dark">
                                {{ $value->currentStatus ?? '-' }}
                            </span>
                        @endif
                    </td>

                    <td>
                        {{ number_format((float)($value->openingStock ?? 0), 4) }}
                    </td>

                    <td>{{ $value->joining_date ?? '-' }}</td>

                    <td>
                        {{ !empty($value->left_date) ? $value->left_date : '-' }}
                    </td>

                    <td>
                        {{ number_format((float)($value->PersonalSale ?? 0), 2) }}
                    </td>

                    <td>
                        {{ number_format((float)($value->TeamSale ?? 0), 2) }}
                    </td>

                    <td>
                        {{ number_format((float)($value->TotalSale ?? 0), 4) }}
                    </td>

                    <td>
                        {{ number_format((float)($value->CompanySaleCurMonth ?? 0), 2) }}
                    </td>
                </tr>
            @endforeach
        @endif
    </tbody>
</table>

                                
                            </table>
                            <!-- end table -->
                        </div>
                        <!-- end table responsive -->
                    </div>
                    
                </div><!-- end card-body -->
            </div><!-- end card -->
        </div><!-- end col -->
       
    </div>
</div>

<link href="https://cdn.datatables.net/2.0.8/css/dataTables.dataTables.css" rel="stylesheet" type="text/css" />
<script src="{{ URL::asset('assets/js/jquery.min.js') }}"></script>
<script src="https://cdn.datatables.net/2.0.8/js/dataTables.js"></script>

<script>
//    new DataTable('#example');
   $('#example').dataTable({
    // "pageLength": -1,  //display all records
    "order": [[ 0, "desc" ]] // Sort by first column descending
});


</script>
@endif
@endsection