@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>Pay Status</th>
            <th>Pay Charges</th>
            <th>Customer Number</th>
            <th>Age</th>
            <th>Nationality</th>
            <th>Number Commitment</th>
            <th>Sim Type</th>
            <th>Select Plan</th>
            <th>Contract Commitment</th>
            <th>Benefits</th>
            <th>Lead No</th>
            <th>Selected Number</th>
            <th>Device</th>
            <th>Commitment Period</th>
            <th>Language</th>
            <th>Dob</th>
            <th>Later Date</th>
            <th>Saler Name</th>
            <th>Saler Id</th>
            <th>Monthly Payment</th>
            <th>Total Monthly Payment</th>
            <th>Remarks</th>
            <th>Emirate Id</th>
            <th>Emirate Num</th>
            <th>Etisalat Number</th>
            <th>Additional Document</th>
            <th>Mobile Payment</th>
            <th>Date Time</th>
            <th>Date Time Follow</th>
            <th>Share With</th>
            <th>Pre Check Remarks</th>
            <th>Pre Check Status</th>
            <th>Pre Check Agent</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>Generic Id</th>
            <th>Addon</th>
            <th>Zone</th>
            <th>Flat</th>
            <th>Street</th>
            <th>Area</th>
            <th>Elife Makani Number</th>
            <th>Location</th>
            <th>Aff Number</th>
            <th>Number Test</th>
            <th>Email</th>
            <th>Num Commit</th>
            <th>Shared With</th>
            <th>Lead Date</th>
            <th>Customer Provider</th>
            <th>Start Date</th>
            <th>Start Time</th>
            <th>Elife Monthly Charges</th>
            <th>Contract Commitement Elife</th>
            <th>Address</th>
            <th>Lat</th>
            <th>Lng</th>
            <th>Assign to</th>
            <th>Closed Date</th>
            <th>Reason For Cancellation</th>
            <th>Sr Number</th>
            <th>Plan Type</th>
            <th>Promotion</th>
            <th>Offers</th>
            <th>Secondary Documents</th>
            <th>Reference</th>
            <th>Request Number</th>
            <th>Landline Account Number</th>
            <th>Alternate Mobile Number</th>
            <th>Lead Refrence Number</th>
            <th>Email Id</th>
            <th>Additional Requirements</th>
            <th>Other Requirement</th>
            <th>Lead Attempt</th>
            <th>Team Leader Id</th>
            <th>Channel Partner Name</th>
            <th>Channel Partner Id</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->pay_status }}</td>
                <td>{{ $lead_sale->pay_charges }}</td>
                <td>{{ $lead_sale->customer_number }}</td>
                <td>{{ $lead_sale->age }}</td>
                <td>{{ $lead_sale->nationality }}</td>
                <td>{{ $lead_sale->number_commitment }}</td>
                <td>{{ $lead_sale->sim_type }}</td>
                <td>{{ $lead_sale->display_plan_name ?? 'N/A' }}</td>
                <td>{{ $lead_sale->contract_commitment }}</td>
                <td>{{ $lead_sale->benefits }}</td>
                <td>{{ $lead_sale->lead_no }}</td>
                <td>{{ $lead_sale->selected_number }}</td>
                <td>{{ $lead_sale->device }}</td>
                <td>{{ $lead_sale->commitment_period }}</td>
                <td>{{ $lead_sale->language }}</td>
                <td>{{ $lead_sale->dob }}</td>
                <td>{{ $lead_sale->later_date }}</td>
                <td>{{ $lead_sale->saler_name }}</td>
                <td>{{ $lead_sale->saler_id }}</td>
                <td>{{ $lead_sale->monthly_payment }}</td>
                <td>{{ $lead_sale->total_monthly_payment }}</td>
                <td>{{ $lead_sale->remarks }}</td>
                <td>{{ $lead_sale->emirate_id }}</td>
                <td>{{ $lead_sale->emirate_num }}</td>
                <td>{{ $lead_sale->etisalat_number }}</td>
                <td>{{ $lead_sale->additional_document }}</td>
                <td>{{ $lead_sale->mobile_payment }}</td>
                <td>{{ $lead_sale->date_time }}</td>
                <td>{{ $lead_sale->date_time_follow }}</td>
                <td>{{ $lead_sale->share_with }}</td>
                <td>{{ $lead_sale->pre_check_remarks }}</td>
                <td>{{ $lead_sale->pre_check_status }}</td>
                <td>{{ $lead_sale->pre_check_agent }}</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->generic_id }}</td>
                <td>{{ $lead_sale->addon }}</td>
                <td>{{ $lead_sale->zone }}</td>
                <td>{{ $lead_sale->flat }}</td>
                <td>{{ $lead_sale->street }}</td>
                <td>{{ $lead_sale->area }}</td>
                <td>{{ $lead_sale->elife_makani_number }}</td>
                <td>{{ $lead_sale->location }}</td>
                <td>{{ $lead_sale->aff_number }}</td>
                <td>{{ $lead_sale->number_test }}</td>
                <td>{{ $lead_sale->email }}</td>
                <td>{{ $lead_sale->numcommit }}</td>
                <td>{{ $lead_sale->shared_with }}</td>
                <td>{{ $lead_sale->lead_date }}</td>
                <td>{{ $lead_sale->customer_provider }}</td>
                <td>{{ $lead_sale->start_date }}</td>
                <td>{{ $lead_sale->start_time }}</td>
                <td>{{ $lead_sale->elife_monthly_charges }}</td>
                <td>{{ $lead_sale->contract_commitement_elife }}</td>
                <td>{{ $lead_sale->address }}</td>
                <td>{{ $lead_sale->lat }}</td>
                <td>{{ $lead_sale->lng }}</td>
                <td>{{ $lead_sale->assign_to }}</td>
                <td>{{ $lead_sale->closed_date }}</td>
                <td>{{ $lead_sale->reason_for_cancellation }}</td>
                <td>{{ $lead_sale->sr_number }}</td>
                <td>{{ $lead_sale->plantype }}</td>
                <td>{{ $lead_sale->promotion }}</td>
                <td>{{ $lead_sale->offers }}</td>
                <td>{{ $lead_sale->secondary_documents }}</td>
                <td>{{ $lead_sale->reference }}</td>
                <td>{{ $lead_sale->request_number }}</td>
                <td>{{ $lead_sale->landline_account_number }}</td>
                <td>{{ $lead_sale->alternate_mobile_number }}</td>
                <td>{{ $lead_sale->lead_refrence_number }}</td>
                <td>{{ $lead_sale->email_id }}</td>
                <td>{{ $lead_sale->additional_requirements }}</td>
                <td>{{ $lead_sale->other_requirement }}</td>
                <td>{{ $lead_sale->lead_attempt }}</td>
                <td>{{ $lead_sale->team_leader_id }}</td>
                <td>{{ $lead_sale->channel_partner_name }}</td>
                <td>{{ $lead_sale->channel_partner_id }}</td>
            </tr>
        @endforeach
    </tbody>
</table>