Skip to content

Instantly share code, notes, and snippets.

@untillnesss

untillnesss/insert-otp-reschedule-order.sql

Created July 19, 2024 15:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save untillnesss/a6bb4bc026e23a92cd1d213b1e978a1b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save untillnesss/a6bb4bc026e23a92cd1d213b1e978a1b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. untillnesss created this gist Jul 19, 2024.
    1 change: 1 addition & 0 deletions insert-otp-reschedule-order.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    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');