02-04-2025 12:49:48 pm   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>5969 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
02-04-2025 12:49:48 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_5969__35_35_15_0.16_8_1_15_1743532200

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', 'f0f2ae4b0c21424c976931d469fb0faf.mp3', 'A', '5969', '', '1743578389', 'C', '35', 'S', 'api_1743578388_u635_voice_455.wav','35','1050','13','','promo','answered','static','15','0.16','8','1','15','0' , 'admin,u635') 

again_get_cID=>

32088

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_32088 SET status='S', sent_date='1743578389', sarv_api_uniqueid='32088_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='32088' 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', '32088', '0.16', 'D', '1743578390', '0.16', '1', 'answered','15')