WD - Dev
74 lines
1.6 KiB
PHP
74 lines
1.6 KiB
PHP
<?php
|
|
|
|
include "../config/connect.php";
|
|
|
|
// $sql = "
|
|
// SELECT
|
|
// ds.id AS tujuan_server,
|
|
// mtp.nama,
|
|
// mtp.pesan
|
|
// FROM data_server ds
|
|
// CROSS JOIN (
|
|
// SELECT *
|
|
// FROM master_template_pesan
|
|
// WHERE id_data_server = 1
|
|
// ) mtp
|
|
// WHERE ds.id <> 1
|
|
// AND NOT EXISTS (
|
|
// SELECT 1
|
|
// FROM master_template_pesan cek
|
|
// WHERE cek.id_data_server = ds.id
|
|
// AND cek.nama = mtp.nama
|
|
// )
|
|
// ";
|
|
|
|
// $stmt = $pdo->prepare($sql);
|
|
// $stmt->execute();
|
|
|
|
// while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
|
|
// echo "Server: {$row['tujuan_server']} | Nama: {$row['nama']} | Template: {$row['pesan']}<br>";
|
|
// }
|
|
|
|
$sql = "
|
|
INSERT INTO master_template_pesan (
|
|
id_data_server,
|
|
nama,
|
|
pesan,
|
|
pesan_official,
|
|
status_pesan,
|
|
gateway_type,
|
|
nama_template,
|
|
backround_kwitansi,
|
|
interval_koneksi_off,
|
|
status_koneksi_off
|
|
)
|
|
SELECT
|
|
ds.id,
|
|
mtp.nama,
|
|
mtp.pesan,
|
|
mtp.pesan_official,
|
|
mtp.status_pesan,
|
|
mtp.gateway_type,
|
|
mtp.nama_template,
|
|
mtp.backround_kwitansi,
|
|
mtp.interval_koneksi_off,
|
|
mtp.status_koneksi_off
|
|
FROM data_server ds
|
|
CROSS JOIN (
|
|
SELECT *
|
|
FROM master_template_pesan
|
|
WHERE id_data_server = 1
|
|
) mtp
|
|
WHERE ds.id <> 1
|
|
AND NOT EXISTS (
|
|
SELECT 1
|
|
FROM master_template_pesan cek
|
|
WHERE cek.id_data_server = ds.id
|
|
AND cek.nama = mtp.nama
|
|
)
|
|
";
|
|
|
|
$stmt = $pdo->prepare($sql);
|
|
$stmt->execute();
|
|
|
|
echo "Berhasil insert " . $stmt->rowCount() . " data."; |