16-12-2024 10:21:23 am   username=>u431 -- token=>5UfHZI -- plan_id=>715 -- announcement_id=>2674 -- caller_id=>0 -- contact_numbers=>8638150190 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- dtmf_wait=>1 -- dtmf_wait_time=>1 -- 
16-12-2024 10:21:23 amget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u431_715_3_A_2674__27_27_15_0.02_12_1_15_DTMFWT_1_1734287400

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 ,dtmf_wait_time  , uphierarchy) VALUES( 'u431', 'ttsmaker-file-2024-11-25-16-25-21.mp3', 'A', '2674', '', '1734324683', 'C', '27', 'S', '1733206190_u431_voice_upload.wav','27','715','3','','trans','answered','static','15','0.02','12','1','15','0' , 1 , 'admin,u431') 

again_get_cID=>

13826

sql_contact_insert=>

INSERT INTO voice_compaign_detail_13826(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('13826', '8638150190', 'P', '27', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_13826 SET status='S', sent_date='1734324684', sarv_api_uniqueid='13826_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u431' AND  type='D' AND compaign_id='13826' 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('u431', 'user', '13826', '0.02', 'D', '1734324684', '0.02', '1', 'answered','15')