20-04-2025 02:31:32 pm   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>6285 -- caller_id=>8985705878 -- contact_numbers=>8985705878,6303086362 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
20-04-2025 02:31:32 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_6285__35_35_15_0.16_6_1_15_1745087400

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', 'a9f7a8d9e4094684bdfb3bad3f509891.mp3', 'A', '6285', '', '1745139693', 'C', '35', 'S', 'api_1745139692_u635_voice_312.wav','35','1050','13','','promo','answered','static','15','0.16','6','1','15','0' , 'admin,u635') 

again_get_cID=>

33851

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33851 SET status='S', sent_date='1745139693', sarv_api_uniqueid='33851_1' WHERE id='1' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33851 SET status='S', sent_date='1745139693', sarv_api_uniqueid='33851_2' WHERE id='2' LIMIT 1 

sql_i_select=>

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