25-04-2025 06:26:00 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>6296804113 -- announcement_id=>1587 -- 
25-04-2025 06:26:00 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_1587__35_35_30_0.11_23_1_30_1745519400

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  , uphierarchy) VALUES( 'u4', '20241106103946am814156422.wav', 'A', '1587', '', '1745585760', 'C', '35', 'S', 'api_1730869789_u4_voice_923.wav','35','25','23','','promo','answered','static','30','0.11','23','1','30','0' , 'admin,u4') 

again_get_cID=>

34288

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34288(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34288', '6296804113', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34288 SET status='S', sent_date='1745585761', sarv_api_uniqueid='34288_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='34288' 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('u4', 'user', '34288', '0.11', 'D', '1745585761', '0.11', '1', 'answered','30')

25-04-2025 06:27:23 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7719127840,6296804113 -- announcement_id=>1587 -- 
25-04-2025 06:27:23 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_1587__35_35_30_0.11_23_1_30_1745519400

compaign_id=>

34288

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34288(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34288', '7719127840', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34288 SET status='S', sent_date='1745585844', sarv_api_uniqueid='34288_2' WHERE id='2' LIMIT 1 

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34288(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34288', '6296804113', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34288 SET status='S', sent_date='1745585844', sarv_api_uniqueid='34288_3' WHERE id='3' LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.22 WHERE id=139287 LIMIT 1 

25-04-2025 06:28:40 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9734822795 -- announcement_id=>1587 -- 
25-04-2025 06:28:40 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_1587__35_35_30_0.11_23_1_30_1745519400

compaign_id=>

34288

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34288(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34288', '9734822795', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34288 SET status='S', sent_date='1745585921', sarv_api_uniqueid='34288_4' WHERE id='4' LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=139287 LIMIT 1 

25-04-2025 06:50:46 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7719127840,9734822795 -- announcement_id=>1589 -- 
25-04-2025 06:50:47 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_1589__35_35_30_0.11_28_1_30_1745519400

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  , uphierarchy) VALUES( 'u4', '20241106104029am9245184371.wav', 'A', '1589', '', '1745587247', 'C', '35', 'S', 'api_1730869832_u4_voice_718.wav','35','25','23','','promo','answered','static','30','0.11','28','1','30','0' , 'admin,u4') 

again_get_cID=>

34295

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34295(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34295', '7719127840', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34295 SET status='S', sent_date='1745587248', sarv_api_uniqueid='34295_1' WHERE id='1' LIMIT 1 

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34295(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34295', '9734822795', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34295 SET status='S', sent_date='1745587248', sarv_api_uniqueid='34295_2' WHERE id='2' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='34295' 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('u4', 'user', '34295', '0.22', 'D', '1745587248', '0.11', '1', 'answered','30')

25-04-2025 07:09:01 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7719127840 -- announcement_id=>1589 -- 
25-04-2025 07:09:01 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_1589__35_35_30_0.11_28_1_30_1745519400

compaign_id=>

34295

sql_contact_insert=>

INSERT INTO voice_compaign_detail_34295(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('34295', '7719127840', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_34295 SET status='S', sent_date='1745588342', sarv_api_uniqueid='34295_3' WHERE id='3' LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=139305 LIMIT 1