<?php
// PERBAIKAN 1: Contoh isi /home/kangdenny/dennysolutions.id/private/db_config.php
// Pastikan $db_user, $db_pass, dan $db_name sesuai dengan MySQL Databases di cPanel Anda!
// PERBAIKAN 2: Simpan kode di bawah sebagai /dennysolutions.id/agent/api_bridge_phplist.php
header('Content-Type: application/json');

// 1. Konfigurasi Database MySQL & phpList Anda
$db_host = 'localhost';
$db_name = 'db_dennysolutions';
$db_user = 'user_db_anda';
$db_pass = 'password_db_anda';
$phplist_subscribe_url = 'https://dennysolutions.id/lists/?p=subscribe&id=1';
$phplist_list_id = '1'; // ID List Asuransi Mobil & Rumah di phpList

$data = json_decode(file_get_contents('php://input'), true);
if (!$data || empty($data['email'])) {
    http_response_code(400);
    echo json_encode(['status' => 'error', 'msg' => 'Data tidak lengkap']);
    exit;
}

// 2. Simpan Prospek ke Database MySQL (Dennysolutions CRM)
try {
    $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    ]);
    $stmt = $pdo->prepare("INSERT INTO leads_asuransi (nama, kota, email, whatsapp, produk, unit_mobil_rumah, tahun_mobil, nilai_aset, estimasi_premi) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->execute([
        $data['name'] ?? '', $data['city'] ?? '', $data['email'] ?? '',
        $data['wa'] ?? '', $data['product'] ?? '', $data['carModel'] ?? '',
        $data['carYear'] ?? '', (int)($data['assetValue'] ?? 0), $data['estPremi'] ?? ''
    ]);
} catch (Exception $e) {
    // Tetap lanjut kirim ke phpList meskipun DB sedang dikonfigurasi
}

// 3. Teruskan Otomatis ke phpList (dennysolutions.id/lists/)
$postFields = http_build_query([
    'email' => $data['email'],
    'emailconfirm' => $data['email'],
    'htmlemail' => '1',
    "list[$phplist_list_id]" => 'signup',
    'attribute1' => $data['name'] ?? '',      // Atribut Nama di phpList
    'attribute2' => $data['city'] ?? '',      // Atribut Kota Jabodetabek
    'attribute3' => $data['carModel'] ?? '',  // Atribut Unit Mobil/Rumah
    'subscribe' => 'Subscribe'
]);

$ch = curl_init($phplist_subscribe_url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 8);
curl_exec($ch);
curl_close($ch);

echo json_encode(['status' => 'ok', 'phplist_synced' => true]);
?>

-- PETA INTEGRASI CPANEL (/home/kangdenny/dennysolutions.id/agent/):
-- 1. /agent/index.php (1,11 KB)       -> Ganti placeholder dengan Landing Page & Form Prospek ini
-- 2. /agent/prospek-mobil.php (10 KB) -> Hubungkan form kalkulator mobil <=10 thn & rumah
-- 3. /agent/lead-engine/index.php     -> Pasang 5 Autonomous Agents Campaign Engine ini
-- 4. /agent/lists/ (phpList)          -> Endpoint subscribe: /lists/?p=subscribe&id=1
-- 5. /agent/dashboard.php & leads.php -> Panel Admin CRM (dilindungi login.php)

-- Jalankan di phpMyAdmin (cPanel kangdenny) jika tabel belum ada:
CREATE TABLE IF NOT EXISTS leads_asuransi (
  id INT AUTO_INCREMENT PRIMARY KEY,
  nama VARCHAR(120) NOT NULL,
  kota VARCHAR(60) NOT NULL,
  email VARCHAR(150) NOT NULL,
  whatsapp VARCHAR(40) NOT NULL,
  produk VARCHAR(100) NOT NULL,
  unit_mobil_rumah VARCHAR(150) NOT NULL,
  tahun_mobil VARCHAR(20) NOT NULL,
  nilai_aset BIGINT DEFAULT 0,
  estimasi_premi VARCHAR(80) DEFAULT '',
  status_prospek VARCHAR(40) DEFAULT 'Baru',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 2. Atribut Subscriber yang Disarankan di phpList:
-- Masuk ke phpList Admin -> Subscribers -> Configure Attributes:
-- Attribute 1: NAMA_LENGKAP (textline)
-- Attribute 2: KOTA_JABODETABEK (textline)
-- Attribute 3: UNIT_MOBIL_RUMAH (textline)

-- 3. Template Kampanye phpList (Gunakan placeholder [NAMA_LENGKAP]):
Subjek: Proposal Simulasi Asuransi [UNIT_MOBIL_RUMAH] Anda — Dennysolutions.id
Isi:
Halo Bapak/Ibu [NAMA_LENGKAP] di [KOTA_JABODETABEK],
Terima kasih telah menghitung simulasi proteksi di dennysolutions.id.
Kami lampirkan rincian manfaat All Risk (mobil maks. 10 tahun) & proteksi rumah tinggal beserta daftar bengkel rekanan Jabodetabek.
Untuk diskusi cepat via WhatsApp, klik: https://wa.me/6281234567890