23-02-2025 09:43:28 am   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4816 -- caller_id=>8985705878 -- contact_numbers=>8985705878,6303086362 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
23-02-2025 06:42:54 pm   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>7906268061 -- announcement_id=>4849 -- 
23-02-2025 06:42:54 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_24_17_A_4849__35_35_15_0.075_14_1_15_1740249000

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( 'u4', '20250223182224pm109282588.wav', 'A', '4849', '', '1740316375', 'C', '35', 'S', 'api_1740315149_u4_voice_942.wav','35','24','17','','promo','answered','static','15','0.075','14','1','15','0' , 'admin,u4') 

again_get_cID=>

25244

sql_contact_insert=>

INSERT INTO voice_compaign_detail_25244(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('25244', '7906268061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_25244 SET status='S', sent_date='1740316376', sarv_api_uniqueid='25244_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='25244' 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('u4', 'user', '25244', '0.075', 'D', '1740316376', '0.075', '1', 'answered','15')

23-02-2025 06:45:08 pm   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>7906268061 -- announcement_id=>4849 -- 
23-02-2025 06:45:08 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_24_17_A_4849__35_35_15_0.075_14_1_15_1740249000

compaign_id=>

25244

sql_contact_insert=>

INSERT INTO voice_compaign_detail_25244(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('25244', '7906268061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}')  

sql_contact_update=>

UPDATE voice_compaign_detail_25244 SET status='S', sent_date='1740316509', sarv_api_uniqueid='25244_2' WHERE id='2' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='25244' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.075 WHERE id=100112 LIMIT 1