29-06-2025 01:30:03 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9904713534 -- announcement_id=>6136 -- 
29-06-2025 01:30:03 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6136__35_35_30_0.11_16_1_30_1751135400

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', '20250411193318pm2857592765.wav', 'A', '6136', '', '1751184003', 'C', '35', 'S', 'api_1744380211_u4_voice_852.wav','35','25','23','','promo','answered','static','30','0.11','16','1','30','0' , 'admin,u4') 

again_get_cID=>

42170

sql_contact_insert=>

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

sql_contact_update=>

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

29-06-2025 01:31:03 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9904713534 -- announcement_id=>6127 -- 
29-06-2025 01:31:04 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6127__35_35_30_0.11_25_1_30_1751135400

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', '20250411080349am3457544392.wav', 'A', '6127', '', '1751184064', 'C', '35', 'S', 'api_1744338835_u4_voice_362.wav','35','25','23','','promo','answered','static','30','0.11','25','1','30','0' , 'admin,u4') 

again_get_cID=>

42171

sql_contact_insert=>

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

sql_contact_update=>

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