WD - Dev
99 lines
3.1 KiB
PHP
99 lines
3.1 KiB
PHP
<?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
|
|
]);
|
|
}
|
|
}
|
|
}
|