Notifikasi WHMCS Otomatis: Reminder Domain via SMS & WhatsApp

<?php
// /includes/hooks/zenziva_notify.php, kirim SMS reminder saat domain mendekati jatuh tempo.
use WHMCS\Database\Capsule;

add_hook('DailyCronJob', 1, function () {
    $target = date('Y-m-d', strtotime('+3 days'));

    $rows = Capsule::table('tbldomains')
        ->join('tblclients', 'tbldomains.userid', '=', 'tblclients.id')
        ->where('tbldomains.status', 'Active')
        ->where('tbldomains.expirydate', $target)
        ->get(['tbldomains.domain', 'tblclients.firstname', 'tblclients.phonenumber']);

    foreach ($rows as $r) {
        $to = preg_replace('/[^0-9+]/', '', $r->phonenumber);
        if (!$to) continue;
        $msg = 'Halo ' . $r->firstname . ', domain ' . $r->domain . ' Anda jatuh tempo dalam 3 hari. Mohon segera diperpanjang.';

        $ch = curl_init('{CONSOLE_BASEURL}/masking/api/sendsms/');
        curl_setopt_array($ch, [
            CURLOPT_POST => true,
            CURLOPT_POSTFIELDS => http_build_query([
                'userkey' => 'API_USERKEY',
                'passkey' => 'API_PASSKEY',
                'to'      => $to,
                'message' => $msg,
            ]),
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_TIMEOUT => 10,
        ]);
        curl_exec($ch);
        curl_close($ch);
    }
});

// Ganti blok curl Console dengan ini untuk WhatsApp (WABA Platform):
$ch = curl_init('{WABA_BASEURL}/api/messages/v1/send');
curl_setopt_array($ch, [
    CURLOPT_POST => true,
    CURLOPT_HTTPHEADER => ['Content-Type: application/json', 'X-API-Key: API_KEY_WABA_ANDA'],
    CURLOPT_POSTFIELDS => json_encode([
        'to'               => $to,
        'templateName'     => 'reminder_domain',
        'templateLanguage' => 'id',
        'bodyVariables'    => [$r->firstname, $r->domain],
    ]),
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_TIMEOUT => 10,
]);
curl_exec($ch);
curl_close($ch);