@extends('layouts.dashboard-app')
@section('main-content')
    <div class="content-body">
        <div class="container">
            <div class="row page-titles">
                <div class="col p-0">
                    <h4>Hello, <span>Welcome {{ auth()->user()->name }}</span></h4>

                </div>
                <div class="col p-0">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0)">All Leads</a>
                        </li>
                        <li class="breadcrumb-item active">All Leads Records Mis Coordinator</li>
                    </ol>
                </div>
            </div>
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <h4 class="card-title">All Leads Records Mis Coordinator</h4>
                            <div class="table-responsive">

                                <table class="table table-striped table-bordered zero-configuration">
                                    <thead>
                                        <tr>
                                            <th>S#</th>
                                            <th>Lead No</th>
                                            <th>Customer Name</th>
                                            <th>Plan Name</th>
                                            <th>Sim Type</th>
                                            <th>Lead Type</th>
                                            <th>C.M. No</th>
                                            <th>Status</th>
                                            <th>Revenue</th>
                                            <th>Verified Status</th>
                                            <th>Sr Status</th>
                                            <th>File Uploader Name</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($records as $key => $item)
                                            @php
                                                $status = DB::table('status_codes')
                                                    ->where('status_code', $item->status)
                                                    ->first();
                                            @endphp
                                            <tr>
                                                <td>{{ ++$key }}</td>
                                                <td>{{ $item->lead_no }}</td>
                                                <td>{{ $item->customer_name }}</td>
                                                <td>
                                                    @if ($item->sim_type == 'New')
                                                        @foreach (explode(',', $item->select_plan) as $info)
                                                            @php($plans = \App\plan::whereid($info)->first())
                                                            {{ $plans->plan_name }}
                                                        @endforeach
                                                    @elseif($item->sim_type == 'MNP')
                                                        @foreach (explode(',', $item->select_plan) as $info)
                                                            @php($plans = \App\plan::whereid($info)->first())
                                                            {{ $plans->plan_name }}
                                                        @endforeach
                                                    @elseif($item->sim_type == 'Migration')
                                                        @foreach (explode(',', $item->select_plan) as $info)
                                                            @php($plans = \App\plan::whereid($info)->first())
                                                            {{ $plans->plan_name }}
                                                        @endforeach
                                                    @else
                                                        @foreach (explode(',', $item->select_plan) as $info)
                                                            @php($plans = \App\elife_plan::whereid($info)->first())
                                                            {{ $plans->plan_name }}
                                                        @endforeach
                                                    @endif

                                                </td>
                                                <td>{{ $item->sim_type }}</td>
                                                <td>{{ $item->lead_type }}</td>
                                                <td>{{ $item->customer_number }}</td>
                                                <td>
                                                    {{ $status ? $status->status_name : 'Status not found' }}
                                                </td>
                                                <td>{{ $item->revenue }}</td>
                                                <td>{{ $item->verified_status }}</td>
                                                <td>{{ $item->sr_status }}</td>
                                                <td>{{ $item->file_uploader_name }}</td>

                                            </tr>
                                        @endforeach

                                    </tbody>

                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </div>
        <!-- #/ container -->
    </div>
@endsection
{{-- @@section('name') --}}

{{-- @endsection --}}