@php
    use App\Models\Instalasi;

    $start_date = '2025-07-26';
    $end_date = '2026-08-26';

    $instalasi_under1year = Instalasi::join('customer', 'customer.id_customer', 'instalasi.id_customer')
        ->join('produk', 'produk.id_produk', 'instalasi.id_produk')
        ->where('customer.id_unit_instalasi',1)
        ->whereDate('instalasi.tgl_pasang', '>=', now()->subYear())
        ->whereDate('instalasi.tgl_uninstal', '>=', $start_date)
        ->whereDate('instalasi.tgl_uninstal', '<=', $end_date)
        ->where('instalasi.status_instalasi', 'Uninstall')
        ->get();

        dd($instalasi_under1year);


@endphp