Handling for Customer's

Implementation Logic:

Goal: We need to save/update customers.whatsappStatus - (ENUM('ACTIVE', ‘INACTIVE', 'UNSUBSCRIBED’)

Steps to achieve the following:

1. When the first message is triggered to need to add a db call to the following table eshopbox_wms_prod.customers to check whether the customer exists in that table or not based on that two scenarios arise:

   SELECT whatsAppStatus FROM customers where phone_number = '9650186697'

   1. If customers exist check there again are two scenarios

      1. customers.whatsappStatus if it is “ACTIVE” we trigger a message for the same

      2. else if customers.whatsappStatus is “INACTIVE” we do not trigger a message for the same

   2. else if the customer doesn’t exist in the table we trigger a message and save the customer in the customer table

2. The next step is when we receive a delivery report from META we act according to the status received here are the following scenarios:

   1. If “failed” status is received with the reason “incapable of receiving the message we need to update the customers.whatsappStatus as “UNSUBSCRIBED” if the customer number is already present

      UPDATE customers SET whatsAppStatus = UNSUBSCRIBED, origin = whatsApp WHERE phone = 9650186697;

   2. else we need to add the same number in the customer's table and set WhatsApp as “UNSUBSCRIBED”

      INSERT INTO customers (brand_account_id, name, phone, email, origin, whatsAppStatus) VALUES (733, Lakshay, 9650186697, lakshay.aggarwal@eshopbox.com, "whatsapp", "UNSUBSCRIBED");

   3. If DLR is received then the above we need not perform any action.