14-05-2025 01:35:17 pm   username=>u847 -- token=>ejMoZj -- plan_id=>1306 -- announcement_id=>6552 -- caller_id=>0000 -- contact_numbers=>9079728403 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
14-05-2025 01:35:17 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u847_1306_56_A_6552__35_35_30_0.18_28_1_30_DTMFWT_1_1747161000

compaign_id=>


sql_comp_insert=>

INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id,  user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration ,dtmf_wait_time  , uphierarchy) VALUES( 'u847', 'Stewindia voice (1).mp3', 'A', '6552', '', '1747209918', 'C', '35', 'S', '1746682397_u847_voice.wav','35','1306','56','','promo','answered','static','30','0.18','28','1','30','0' , 1 , 'admin,sr71,u847') 

again_get_cID=>

36537

sql_contact_insert=>

INSERT INTO voice_compaign_detail_36537(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('36537', '9079728403', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_36537 SET status='S', sent_date='1747209918', sarv_api_uniqueid='36537_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u847' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u847', 'user', '36537', '0.18', 'D', '1747209919', '0.18', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr71' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr71', 'superreseller', '36537', '0.18', 'D', '1747209919', '0.18', '1', 'answered','30')

14-05-2025 01:37:47 pm   username=>u847 -- token=>ejMoZj -- plan_id=>1306 -- announcement_id=>6552 -- caller_id=>0000 -- contact_numbers=>9079728403 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
14-05-2025 01:37:47 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u847_1306_56_A_6552__35_35_30_0.18_28_1_30_DTMFWT_1_1747161000

compaign_id=>

36537

sql_contact_insert=>

INSERT INTO voice_compaign_detail_36537(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('36537', '9079728403', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_36537 SET status='S', sent_date='1747210068', sarv_api_uniqueid='36537_2' WHERE id='2' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u847' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148403 LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr71' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148404 LIMIT 1 

14-05-2025 01:37:59 pm   username=>u847 -- token=>ejMoZj -- plan_id=>1306 -- announcement_id=>6552 -- caller_id=>0000 -- contact_numbers=>9079728403 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
14-05-2025 01:37:59 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u847_1306_56_A_6552__35_35_30_0.18_28_1_30_DTMFWT_1_1747161000

compaign_id=>

36537

sql_contact_insert=>

INSERT INTO voice_compaign_detail_36537(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('36537', '9079728403', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_36537 SET status='S', sent_date='1747210080', sarv_api_uniqueid='36537_3' WHERE id='3' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u847' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148403 LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr71' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148404 LIMIT 1 

14-05-2025 01:38:09 pm   username=>u847 -- token=>ejMoZj -- plan_id=>1306 -- announcement_id=>6552 -- caller_id=>0000 -- contact_numbers=>9079728403 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
14-05-2025 01:38:09 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u847_1306_56_A_6552__35_35_30_0.18_28_1_30_DTMFWT_1_1747161000

compaign_id=>

36537

sql_contact_insert=>

INSERT INTO voice_compaign_detail_36537(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('36537', '9079728403', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_36537 SET status='S', sent_date='1747210089', sarv_api_uniqueid='36537_4' WHERE id='4' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u847' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148403 LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr71' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148404 LIMIT 1 

14-05-2025 05:29:30 pm   username=>u847 -- token=>ejMoZj -- plan_id=>1306 -- announcement_id=>6552 -- caller_id=>0000 -- contact_numbers=>9079728403 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
14-05-2025 05:29:30 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u847_1306_56_A_6552__35_35_30_0.18_28_1_30_DTMFWT_1_1747161000

compaign_id=>

36537

sql_contact_insert=>

INSERT INTO voice_compaign_detail_36537(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('36537', '9079728403', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_36537 SET status='S', sent_date='1747223976', sarv_api_uniqueid='36537_5' WHERE id='5' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u847' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148403 LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr71' AND  type='D' AND compaign_id='36537' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.18 WHERE id=148404 LIMIT 1