rohithBirdeye

ALTER TABLE `bazaarify`.`staging_business` 
CHANGE COLUMN `job_status` `job_status` ENUM('new', 'in_progress', 'succeed', 'signing_up_succeed', 'signing_up_failed', 'restricted_name_used', 'adding_user_succeed', 'adding_user_failed', 'updating_business_succeed', 'updating_business_failed', 'updating_entity_succeed', 'updating_entity_failed', 'finding_entity_succeed', 'finding_entity_failed', 'aggregating_entity_succeed', 'aggregating_entity_failed', 'aggregating_reviews_succeed', 'aggregating_reviews_failed', 'name_not_provided', 'zip_not_provided', 'invalid_business_type', 'enterprise_not_found', 'existing_competitor_account_mapping_succeed', 'phone_not_provided', 'invalid_timezone') CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL ;

rohithBirdeye

PASSWORD_PATTERN = "(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z])(?=.*[~!@#$%^&*_=`|(){}:;'<>,.])(?=\\S+$).{8,32}";

rohithBirdeye

(713) 880-8888
(512) 888-9453
(856) 353-3115
(225) 369-6717
(785) 276-9300
(704) 315-5845
(817) 900-8100
(540) 563-1957
+1 503-698-2665
604-227-6764

rohithBirdeye

 select
b.business_id,b.name,bb.payment_status,bb.last_bill_paid_on,b.status,b.activation_status
from
   business b 
   inner join
      business_billing bb 
      on bb.business_id = b.id 
where
   b.status = 'active' 
   and  bb.payment_status in 

rohithBirdeye

Landline Tetxting eligibility for  Account 
1 ) $.messageObject.Body.notifications.Notification.sObject.Id                  -> $.messageObject.Id
2 ) $.messageObject.Body.notifications.Notification.sObject.Phone_Formatted__c  -> $.messageObject.Phone_Formatted__c


Landline Tetxting eligibility for  Lead 
1) $.messageObject.Body.notifications.Notification.sObject.Country.             ->   $.messageObject.Country
2) $.messageObject.Body.notifications.Notification.sObject.Id                   ->  $.messageObject.Id
3) $.messageObject.Body.notifications.Notification.sObject.Phone__c             -> $.messageObject.Phone__c

rohithBirdeye

curl -X POST \
  'http://10.9.11.19:8080/kafka/push?topicName=account_landline_texting' \
  -H 'accept: application/json' \
  -H 'cache-control: no-cache' \
  -H 'content-type: application/xml' \
  -H 'postman-token: 5c000831-04cf-bc0f-c4e8-3b91239e0380' \
  -d '<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
	      <notifications xmlns="http://soap.sforce.com/2005/09/outbound">

rohithBirdeye

curl -X POST \
  'http://10.9.11.19:8080/kafka/push?topicName=lead_landline_texting' \
  -H 'accept: application/json' \
  -H 'cache-control: no-cache' \
  -H 'content-type: application/xml' \
  -H 'postman-token: f18071a4-7784-4ed3-8275-45ba4a7066e2' \
  -d '<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
	      <notifications xmlns="http://soap.sforce.com/2005/09/outbound">

rohithBirdeye

select id,business_id,status,business_ad_url from business_uuid where '%nationstarmtg.com%' OR business_ad_url LIKE
'%www.sungevity.com%' OR business_ad_url LIKE
'%www.carringtonconnects.com%' OR business_ad_url LIKE
'%www.hurricaneauto.com%' OR business_ad_url LIKE
'%www.ringcentral.com%' OR business_ad_url LIKE
'%www.8x8.com%' OR business_ad_url LIKE
'%birdeye.com%' OR business_ad_url LIKE
'%www.zodiacpoolsystems.com%' OR business_ad_url LIKE
'%www.oceandental.net%' OR business_ad_url LIKE
'%weillcornell.org%' OR business_ad_url LIKE

rohithBirdeye

select distinct * from user where id in (
select distinct user_id from business_access_audit where user_id in (select id from user where email_id in (
select distinct email_id from user where  email_id like '%birdeye.com%' and email_id in (
"aai@iacobellilaw.com", "aai@iacobellilaw.com", "aaron@optionsexteriors.com", "aaron@taddikentree.com", "acarlosalzola@foxrentacar.com", "acarlosalzola@foxrentacar.com", "adrian@abconsultingg.com", "akapasi110@gmail.com", "alisha.patel@birdeye.com", "amarjot.kaur@birdeye.com", "amarjot.kaur@birdeye.com", "ameya@birdeye.com", "ameya@birdeye.com", "ana@rockpointlegal.com", "ashley.pohlman@a3smarthome.com", "ashton@optiononesolar.com", "assistant@spectrumaesthetics.com", "austin@campaignium.com", "barbara@suncountrycleaners.com", "bchappell@valveandmeter.com", "bfroistad@pinbn.com", "brianna@whiteboard-mktg.com", "brianna@whiteboard-mktg.com", "brittany@theclearshift.com", "brittany@theclearshift.com", "bstagg@revlocal.com", "c.hartman@atlanticblue.net", "carlais@3menmovers.

rohithBirdeye

select distinct * from user where id in (
select distinct user_id from session_token where user_id in (
select distinct id from user where  email_id like '%birdeye.com%' and email_id in (
"aai@iacobellilaw.com", "aai@iacobellilaw.com", "aaron@optionsexteriors.com", "aaron@taddikentree.com", "acarlosalzola@foxrentacar.com", "acarlosalzola@foxrentacar.com", "adrian@abconsultingg.com", "akapasi110@gmail.com", "alisha.patel@birdeye.com", "amarjot.kaur@birdeye.com", "amarjot.kaur@birdeye.com", "ameya@birdeye.com", "ameya@birdeye.com", "ana@rockpointlegal.com", "ashley.pohlman@a3smarthome.com", "ashton@optiononesolar.com", "assistant@spectrumaesthetics.com", "austin@campaignium.com", "barbara@suncountrycleaners.com", "bchappell@valveandmeter.com", "bfroistad@pinbn.com", "brianna@whiteboard-mktg.com", "brianna@whiteboard-mktg.com", "brittany@theclearshift.com", "brittany@theclearshift.com", "bstagg@revlocal.com", "c.hartman@atlanticblue.net", "carlais@3menmovers.com", "cbello@dreamscapemail.com", "chaye@potsot.com"