10-04-2025 03:01:43 pm   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>6114 -- caller_id=>8985705878 -- contact_numbers=>8985705878,9394099089,7093444400, -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
10-04-2025 03:01:43 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_6114__35_35_15_0.16_4_1_15_1744223400

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( 'u635', '98688452e51d475ea088c0af5eb467ee.mp3', 'A', '6114', '', '1744277506', 'C', '35', 'S', 'api_1744277500_u635_voice_412.wav','35','1050','13','','promo','answered','static','15','0.16','4','1','15','0' , 'admin,u635') 

again_get_cID=>

32872

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32872 SET status='S', sent_date='1744277509', sarv_api_uniqueid='32872_1' WHERE id='1' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32872 SET status='S', sent_date='1744277509', sarv_api_uniqueid='32872_2' WHERE id='2' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32872 SET status='S', sent_date='1744277509', sarv_api_uniqueid='32872_3' WHERE id='3' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND  type='D' AND compaign_id='32872' 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('u635', 'user', '32872', '0.48', 'D', '1744277518', '0.16', '1', 'answered','15')

10-04-2025 03:02:09 pm   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>6115 -- caller_id=>8985705878 -- contact_numbers=>8985705878,9394099089,7093444400,9000144444 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
10-04-2025 03:02:09 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_6115__35_35_15_0.16_4_1_15_1744223400

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( 'u635', 'c71c1fbf4b2e4461a343fe143a0bb601.mp3', 'A', '6115', '', '1744277529', 'C', '35', 'S', 'api_1744277528_u635_voice_949.wav','35','1050','13','','promo','answered','static','15','0.16','4','1','15','0' , 'admin,u635') 

again_get_cID=>

32873

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32873 SET status='S', sent_date='1744277530', sarv_api_uniqueid='32873_1' WHERE id='1' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32873 SET status='S', sent_date='1744277530', sarv_api_uniqueid='32873_2' WHERE id='2' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32873 SET status='S', sent_date='1744277530', sarv_api_uniqueid='32873_3' WHERE id='3' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32873 SET status='S', sent_date='1744277530', sarv_api_uniqueid='32873_4' WHERE id='4' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND  type='D' AND compaign_id='32873' 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('u635', 'user', '32873', '0.64', 'D', '1744277530', '0.16', '1', 'answered','15')