insert-otp-reschedule-order.sql

INSERT INTO `templates` (`id`, `nama_template`, `subject_email`, `template_email`, `template_wa`, `list_variabel`, `created_at`, `updated_at`) VALUES (NULL, 'otp_reschedule_order', 'Otp Cancel Order', '<p><br></p>', '<p><span style=\"color: rgb(75, 86, 117);\">Gunakan kode OTP {{$OTP}} untuk reschedule order {{$NO_ORDER}}.</span></p><p><br></p><p><br></p><p><span style=\"color: rgb(75, 86, 117);\"><span class=\"ql-cursor\"></span>Testing template notifikasi ya.</span></p>', '[\"{{OTP}}\",\"{{NO_ORDER}}\",\"{{PELANGGAN}}\",\"{{TOTAL_ORDER}}\",\"{{REKENING_PEMBAYARAN}}\",\"{{BATAS_PEMBAYARAN}}\",\"{{DETAIL_ORDER}}\",\"{{STATUS_PELANGGAN}}\",\"{{JENIS_PELANGGAN}}\",\"{{LEVEL_PELANGGAN}}\",\"{{JUDUL_KUPON}}\",\"{{JUMLAH_POTONGAN}}\",\"{{RENTAL_REWARD_POIN}}\",\"{{RENTAL_REWARD_EXPIRED}}\"]', NULL, '2024-06-28 14:29:18');