');
            // print_r($importedNames);
            // exit;

            // Ambil customer_id + nama_customer dari database 
            $customers = Customer::where(function ($query) use ($importedNames) {
                $query->whereIn(\DB::raw('LOWER(nama_customer)'), array_map('strtolower', $importedNames))
                    ->orWhereIn(\DB::raw('LOWER(no_hp)'), array_map('strtolower', $importedNames));
            })
                ->where('is_active', true)
                ->select(
                    'customer_id as id',
                    \DB::raw('concat(nama_customer, \' / \', no_hp) as nama')
                )
                ->get();

            return response()->json([
                'success' => true,
                'customers' => $customers
            ]);
        } catch (\Exception $e) {
            return response()->json([
                'success' => false,
                'message' => $e->getMessage()
            ]);
        }
    }

    public function uploadPenerima(Request $request)
    {
        $request->validate([
            'excel_file' => 'required|mimes:xlsx,csv'
        ]);

        try {
            // Import file
            $import = new PenerimaImport();
            Excel::import($import, $request->file('excel_file'));

            $importedNames = $import->getImportedNames();

            // Cari yang ditemukan
            $customers = Customer::where(function ($query) use ($importedNames) {
                $query->whereIn(\DB::raw('LOWER(nama_customer)'), array_map('strtolower', $importedNames))
                    ->orWhereIn(\DB::raw('LOWER(no_hp)'), array_map('strtolower', $importedNames));
            })
                ->where('is_active', true)
                ->select(
                    'customer_id as id',
                    \DB::raw("LOWER(nama_customer) as nama"),
                    \DB::raw("LOWER(no_hp) as no_hp"),
                    \DB::raw("concat(nama_customer, ' / ', no_hp) as label")
                )
                ->get();

            // Ambil semua nama dan no_hp dari hasil query untuk dibandingkan
            $foundNames = $customers->map(function ($item) {
                return [
                    trim(strtolower($item->nama)),
                    trim(strtolower($item->no_hp))
                ];
            })->flatten()->unique()->toArray();

            // Cari yang tidak ditemukan
            $notFound = array_filter($importedNames, function ($name) use ($foundNames) {
                return !in_array(trim(strtolower($name)), $foundNames);
            });

            if (count($notFound)) {
                // Jika ada yang tidak ditemukan, kembalikan file Excel
                $export = new PenerimaExport($notFound);
                $filename = 'data_tidak_ditemukan.xlsx';

                return Excel::download($export, $filename);
            }

            // Jika semua ditemukan, kirim balik data customer untuk ditambahkan ke selector
            $formatted = $customers->map(function ($cust) {
                return [
                    'id' => $cust->id,
                    'nama' => $cust->label
                ];
            });

            return response()->json([
                'success' => true,
                'customers' => $formatted
            ]);
        } catch (\Exception $e) {
            return response()->json([
                'success' => false,
                'message' => $e->getMessage()
            ]);
        }
    }

    public function downloadTemplate()
    {
        // Path ke file template Excel yang sudah Anda buat
        $templatePath = storage_path('app/templates/template_excel_penerima_notif.xlsx');

        // Cek apakah file template ada
        if (file_exists($templatePath)) {
            return response()->download($templatePath);
        }

        return response()->json(['message' => 'Template tidak ditemukan.'], 404);
    }
}