file = r'app\Http\Controllers\DashboardController.php'
with open(file, 'r', encoding='utf-8') as f:
    c = f.read()

# Fix manager marketing - tambah 2 data setelah kompetitorData
old_mgr = "                    'kompetitorData'   => $sessions->get()->groupBy('brand_kompetitor')->map->count(),"
new_mgr = """                    'kompetitorData'          => $sessions->get()->groupBy('brand_kompetitor')->map->count(),
                    'alasanTidakKonversiData' => $sessions->get()->groupBy('alasan_tidak_konversi')->map->count(),
                    'alasanKompetitorData'    => $sessions->get()->groupBy('alasan_kompetitor')->map->count(),"""

# Fix SPV marketing - tambah 2 data setelah kompetitorData
old_spv = "                'kompetitorData'   => $spvSessions->get()->groupBy('brand_kompetitor')->map->count(),"
new_spv = """                'kompetitorData'          => $spvSessions->get()->groupBy('brand_kompetitor')->map->count(),
                    'alasanTidakKonversiData' => $spvSessions->get()->groupBy('alasan_tidak_konversi')->map->count(),
                    'alasanKompetitorData'    => $spvSessions->get()->groupBy('alasan_kompetitor')->map->count(),"""

if old_mgr in c:
    c = c.replace(old_mgr, new_mgr)
    print("manager: OK")
else:
    print("manager: GAGAL")

if old_spv in c:
    c = c.replace(old_spv, new_spv)
    print("spv: OK")
else:
    print("spv: GAGAL")

with open(file, 'w', encoding='utf-8') as f:
    f.write(c)