20-02-2025 02:01:19 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8275677838 -- announcement_id=>2628 -- 
20-02-2025 02:01:19 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_2628__35_35_30_0.11_19_1_30_1739989800

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', '20241130174717pm1983597059.wav', 'A', '2628', '', '1740040280', 'C', '35', 'S', 'api_1732969039_u4_voice_909.wav','35','25','23','','promo','answered','static','30','0.11','19','1','30','0' , 'admin,u4') 

again_get_cID=>

24279

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_24279 SET status='S', sent_date='1740040281', sarv_api_uniqueid='24279_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='24279' 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', '24279', '0.11', 'D', '1740040281', '0.11', '1', 'answered','30')

20-02-2025 07:05:26 pm   username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4703 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 
20-02-2025 07:05:26 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u635_1050_13_A_4703__35_35_15_0.16_4_1_15_1739989800

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', '4dc2b78a7f714e78bf3ff98344001d4f.mp3', 'A', '4703', '', '1740058527', 'C', '35', 'S', 'api_1740058526_u635_voice_359.wav','35','1050','13','','promo','answered','static','15','0.16','4','1','15','0' , 'admin,u635') 

again_get_cID=>

24393

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_24393 SET status='S', sent_date='1740058527', sarv_api_uniqueid='24393_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='24393' 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', '24393', '0.16', 'D', '1740058528', '0.16', '1', 'answered','15')