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


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_6313__35_35_15_0.16_4_1_15_1745346600

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', '770fa155cfb04ed589af5b80a29f9579.mp3', 'A', '6313', '', '1745396015', 'C', '35', 'S', 'api_1745396014_u635_voice_290.wav','35','1050','13','','promo','answered','static','15','0.16','4','1','15','0' , 'admin,u635') 

again_get_cID=>

34071

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_34071 SET status='S', sent_date='1745396016', sarv_api_uniqueid='34071_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND  type='D' AND compaign_id='34071' 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', '34071', '0.16', 'D', '1745396016', '0.16', '1', 'answered','15')