Untitled
unknown
plain_text
a year ago
3.4 kB
10
Indexable
INSERT INTO push_notification_templates (code, title, message, url_path, status, created_on, last_modified_on, time_to_live_in_seconds) VALUES ( 'SALES_AGENT_CARD_SALES_UPDATE_PUSH_NOTIFICATION', 'Card Sales Update', 'Dear [sales_agent_name], sell [number_of_cards_to_sell] more cards to earn your lump sum of [lump_sum_earned_for_batch].', '', 'ACTIVE', now(), now(), '3600' ); -- REPLACE 83 in below insert query with push_notification_template_id generated for above insertion query INSERT INTO notifications_templates (category, event, push_notification, sms, email, whatsapp, push_notification_template_id, sms_template_id, email_template_id, whatsapp_template_id) VALUES ('UPDATES_FROM_MONIEPOINT', 'SALES_AGENT_CARD_SALES_UPDATE_PUSH_NOTIFICATION', 1, 0, 0, 0, 83, null, null, null); INSERT INTO push_notification_templates (code, title, message, url_path, status, created_on, last_modified_on, time_to_live_in_seconds) VALUES ( 'SALES_AGENT_CARD_SOLD_PUSH_NOTIFICATION', 'Card Sales Wallet Credit', 'Dear [sales_agent_name], you just earned [amount_earned] for selling a card. Sell [number_of_cards_to_sell] more cards to earn your lump sum of [lump_sum_earned_for_batch].', 'main-app/agent/sales_agent_wallet_transaction_history', 'ACTIVE', now(), now(), '3600' ); -- REPLACE 80 in below insert query with push_notification_template_id generated for above insertion query INSERT INTO notifications_templates (category, event, push_notification, sms, email, whatsapp, push_notification_template_id, sms_template_id, email_template_id, whatsapp_template_id) VALUES ('UPDATES_FROM_MONIEPOINT', 'SALES_AGENT_CARD_SOLD_PUSH_NOTIFICATION', 1, 0, 0, 0, 80, null, null, null); INSERT INTO push_notification_templates (code, title, message, url_path, status, created_on, last_modified_on, time_to_live_in_seconds) VALUES ( 'SALES_AGENT_LUMP_SUM_PAID_PUSH_NOTIFICATION', 'Card Sales Wallet Credit', 'Dear [sales_agent_name], you just earned a lump sum of [lump_sum_earned_for_batch]. For selling all the cards within a batch. Keep selling more cards to earn more.', 'main-app/agent/sales_agent_wallet_transaction_history', 'ACTIVE', now(), now(), '3600' ); -- REPLACE 81 in below insert query with push_notification_template_id generated for above insertion query INSERT INTO notifications_templates (category, event, push_notification, sms, email, whatsapp, push_notification_template_id, sms_template_id, email_template_id, whatsapp_template_id) VALUES ('UPDATES_FROM_MONIEPOINT', 'SALES_AGENT_LUMP_SUM_PAID_PUSH_NOTIFICATION', 1, 0, 0, 0, 81, null, null, null); INSERT INTO sms_templates (template_code, template_name, sender_id, message, name_length) VALUES ( 'SALES_AGENT_CARD_SALES_UPDATE_SMS_NOTIFICATION', 'Card Sales Update', 'Moniepoint', 'Dear [sales_agent_name], sell [number_of_cards_to_sell] cash out your wallet balance of [wallet_balance].', 6 ); -- REPLACE 94 in below insert query with sms_template_id generated for above insertion query INSERT INTO notifications_templates (category, event, push_notification, sms, email, whatsapp, push_notification_template_id, sms_template_id, email_template_id, whatsapp_template_id) VALUES ('UPDATES_FROM_MONIEPOINT', 'SALES_AGENT_CARD_SALES_UPDATE_SMS_NOTIFICATION', 0, 1, 0, 0, 94, null, null, null);
Editor is loading...
Leave a Comment