@php
    // Preload status codes with leads and dynamically join only the necessary tables based on conditions
    $leadsQuery = DB::table('lead_sales')
        ->leftJoin('status_codes', 'lead_sales.status', '=', 'status_codes.status_code')
        ->select(
            'lead_sales.*',
            'status_codes.status_name',
            'elife_telesales_plans.plan_name as elife_telesales_plan_name',
            'home_wifi_plans.plan_name as home_wifi_plan_name',
            'postpaid_mnp_plans.plan_name as postpaid_mnp_plan_name',
            'postpaid_new_plans.plan_name as postpaid_new_plan_name',
        );

    // Dynamic joins based on conditions with unique aliases
    $leadsQuery->when(
        fn($query) => $query
            ->where('lead_sales.sim_type', 'Elife')
            ->whereIn('lead_sales.sale_type', ['Elife Telesales', 'Elife DTD']),
        fn($query) => $query->leftJoin(
            'elife_plans as elife_telesales_plans',
            'lead_sales.select_plan',
            '=',
            'elife_telesales_plans.id',
        ),
    );

    $leadsQuery->when(
        fn($query) => $query->whereIn('lead_sales.sim_type', ['HomeWifiTelesales', 'HomeWifiDTD']),
        fn($query) => $query->leftJoin(
            'elife_plans as home_wifi_plans',
            'lead_sales.select_plan',
            '=',
            'home_wifi_plans.id',
        ),
    );

    $leadsQuery->when(
        fn($query) => $query
            ->where('lead_sales.sim_type', 'MNP')
            ->whereIn('lead_sales.sale_type', ['Postpaid DTD', 'Postpaid Telesales']),
        fn($query) => $query->leftJoin(
            'plans as postpaid_mnp_plans',
            'lead_sales.select_plan',
            '=',
            'postpaid_mnp_plans.id',
        ),
    );

    $leadsQuery->when(
        fn($query) => $query->where('lead_sales.sim_type', 'New')->where('lead_sales.sale_type', 'Postpaid Telesales'),
        fn($query) => $query->leftJoin(
            'plans as postpaid_new_plans',
            'lead_sales.select_plan',
            '=',
            'postpaid_new_plans.id',
        ),
    );

    // Execute the query and get results
    $leads = $leadsQuery->get();

    // Post-process to only show the relevant plan name based on sim_type
    $leads->transform(function ($lead) {
        switch ($lead->sim_type) {
            case 'Elife':
                $lead->display_plan_name = $lead->elife_telesales_plan_name;
                break;
            case 'HomeWifiTelesales':
            case 'HomeWifiDTD':
                $lead->display_plan_name = $lead->home_wifi_plan_name;
                break;
            case 'MNP':
                $lead->display_plan_name = $lead->postpaid_mnp_plan_name;
                break;
            case 'New':
                $lead->display_plan_name = $lead->postpaid_new_plan_name;
                break;
            default:
                $lead->display_plan_name = null;
                break;
        }
        return $lead;
    });

    // dd($leads);

@endphp
<table>
    <thead>
        <tr>
            <th>Customer Name</th>
            <th>Gender</th>
            <th>Emirates</th>
            <th>Sim Type</th>
            <th>Select Plan</th>
            <th>Lead No</th>
            <th>Language</th>
            <th>Status</th>
            <th>Created At</th>
            <th>Updated At</th>
            <th>Lead Type</th>
            <th>Channel Type</th>
            <th>Sale Type</th>
            <th>Sr Number</th>
            <th>Request Number</th>
            <th>Lead Refrence Number</th>
            <th>Verified Status</th>
            <th>SR Status</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($leads as $lead_sale)
            <tr>
                <td>{{ $lead_sale->customer_name }}</td>
                <td>{{ $lead_sale->gender }}</td>
                <td>{{ $lead_sale->emirates }}</td>
                <td>{{ $lead_sale->sim_type }}</td>
                <td>{{ $lead_sale->display_plan_name ?? 'N/A' }}</td>
                <td>{{ $lead_sale->lead_no }}</td>
                <td>{{ $lead_sale->language }}</td>
                <td>{{ $lead_sale->status_name ?? 'N/A' }}</td>
                <td>{{ $lead_sale->created_at }}</td>
                <td>{{ $lead_sale->updated_at }}</td>
                <td>{{ $lead_sale->lead_type }}</td>
                <td>{{ $lead_sale->channel_type }}</td>
                <td>{{ $lead_sale->sale_type }}</td>
                <td>{{ $lead_sale->sr_number }}</td>
                <td>{{ $lead_sale->request_number }}</td>
                <td>{{ $lead_sale->lead_refrence_number }}</td>
                <td>{{ $lead_sale->verified_status }}</td>
                <td>{{ $lead_sale->sr_status }}</td>
            </tr>
        @endforeach
    </tbody>
</table>