Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
3.4 kB
7
Indexable
Never

   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);
Leave a Comment