<?php

include __DIR__ . "/../config/connect.php";

$SQLOwner = "SELECT 
    id,
    pesan_kirim_tagihan,
    pesan_peringatan_tagihan,
    pesan_isolir_pelanggan,
    pesan_melunasi_tagihan,
    pesan_koneksi_off,
    pesan_registrasi,
    pesan_aktivasi,
    backround_kwitansi,
    interval_koneksi_off,
    status_koneksi_off
FROM data_server
";

$stmt3 = $pdo->prepare($SQLOwner);
$stmt3->execute();

$owners = $stmt3->fetchAll(PDO::FETCH_ASSOC);

foreach ($owners as $owner) {

    $gatewayType = "unofficial"; // default

    // 1️⃣ Pesan Melunasi Tagihan
    if (!empty($owner['pesan_melunasi_tagihan'])) {
        $sql = "INSERT INTO master_template_pesan 
            (id_data_server, nama, pesan, status_pesan, backround_kwitansi, gateway_type) 
            VALUES (?,?,?,?,?,?)
            ON DUPLICATE KEY UPDATE 
                pesan = VALUES(pesan),
                backround_kwitansi = VALUES(backround_kwitansi),
                gateway_type = VALUES(gateway_type)";
        $stmt = $pdo->prepare($sql);
        $stmt->execute([
            $owner['id'],
            'Pesan Melunasi Tagihan',
            $owner['pesan_melunasi_tagihan'],
            'WhatsApp Unofficial API',
            $owner['backround_kwitansi'],
            $gatewayType
        ]);
    }

    // 2️⃣ Pesan Koneksi Off
    if (!empty($owner['pesan_koneksi_off'])) {
        $sql = "INSERT INTO master_template_pesan 
            (id_data_server, nama, pesan, status_pesan, interval_koneksi_off, status_koneksi_off, gateway_type) 
            VALUES (?,?,?,?,?,?,?)
            ON DUPLICATE KEY UPDATE 
                pesan = VALUES(pesan),
                interval_koneksi_off = VALUES(interval_koneksi_off),
                status_koneksi_off = VALUES(status_koneksi_off),
                gateway_type = VALUES(gateway_type)";
        $stmt = $pdo->prepare($sql);
        $stmt->execute([
            $owner['id'],
            'Pesan Koneksi Off',
            $owner['pesan_koneksi_off'],
            'WhatsApp Unofficial API',
            $owner['interval_koneksi_off'],
            $owner['status_koneksi_off'],
            $gatewayType
        ]);
    }

    // 3️⃣ Sisa pesan lain
    $pesanLain = [
        'Pesan Kirim Tagihan'       => $owner['pesan_kirim_tagihan'],
        'Pesan Peringatan Tagihan'  => $owner['pesan_peringatan_tagihan'],
        'Pesan Isolir Pelanggan'    => $owner['pesan_isolir_pelanggan'],
        'Pesan Registrasi'          => $owner['pesan_registrasi'],
        'Pesan Aktivasi'            => $owner['pesan_aktivasi']
    ];

    foreach ($pesanLain as $namaPesan => $isiPesan) {
        if (!empty($isiPesan)) {
            $sql = "INSERT INTO master_template_pesan 
                (id_data_server, nama, pesan, status_pesan, gateway_type) 
                VALUES (?,?,?,?,?)
                ON DUPLICATE KEY UPDATE 
                    pesan = VALUES(pesan),
                    gateway_type = VALUES(gateway_type)";
            $stmt = $pdo->prepare($sql);
            $stmt->execute([
                $owner['id'],
                $namaPesan,
                $isiPesan,
                'WhatsApp Unofficial API',
                $gatewayType
            ]);
        }
    }
}