28-03-2025 09:59:00 am   username=>u531 -- token=>lwrvcu -- announcement_id=>5802 -- plan_id=>894 -- contact_numbers=>8056003157 -- 
28-03-2025 11:05:00 am   username=>u531 -- token=>lwrvcu -- announcement_id=>5806 -- plan_id=>894 -- contact_numbers=>9597280269 -- 
28-03-2025 11:05:00 amget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u531_894_56_A_5806__35_35_30_0.3_8_1_30_1743100200

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( 'u531', 'audio7079560510456237451.wav', 'A', '5806', '', '1743140100', 'C', '35', 'S', 'api_1743140080_u531_voice_142.wav','35','894','56','','promo','answered','static','30','0.3','8','1','30','0' , 'admin,sr83,sr195,u531') 

again_get_cID=>

31248

sql_contact_insert=>

INSERT INTO voice_compaign_detail_31248(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31248', '9597280269', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' )  

sql_contact_update=>

UPDATE voice_compaign_detail_31248 SET status='S', sent_date='1743140101', sarv_api_uniqueid='31248_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND  type='D' AND compaign_id='31248' 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('u531', 'user', '31248', '0.3', 'D', '1743140101', '0.3', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND  type='D' AND compaign_id='31248' 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('sr195', 'superreseller', '31248', '0.13', 'D', '1743140101', '0.13', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND  type='D' AND compaign_id='31248' 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('sr83', 'superreseller', '31248', '0.055', 'D', '1743140101', '0.055', '1', 'answered','15')

28-03-2025 11:08:00 am   username=>u531 -- token=>lwrvcu -- announcement_id=>5807 -- plan_id=>894 -- contact_numbers=>9597280269 -- 
28-03-2025 11:08:00 amget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u531_894_56_A_5807__35_35_30_0.3_4_1_30_1743100200

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( 'u531', 'audio1386422444466245684.wav', 'A', '5807', '', '1743140280', 'C', '35', 'S', 'api_1743140252_u531_voice_515.wav','35','894','56','','promo','answered','static','30','0.3','4','1','30','0' , 'admin,sr83,sr195,u531') 

again_get_cID=>

31252

sql_contact_insert=>

INSERT INTO voice_compaign_detail_31252(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31252', '9597280269', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' )  

sql_contact_update=>

UPDATE voice_compaign_detail_31252 SET status='S', sent_date='1743140281', sarv_api_uniqueid='31252_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND  type='D' AND compaign_id='31252' 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('u531', 'user', '31252', '0.3', 'D', '1743140281', '0.3', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND  type='D' AND compaign_id='31252' 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('sr195', 'superreseller', '31252', '0.13', 'D', '1743140281', '0.13', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND  type='D' AND compaign_id='31252' 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('sr83', 'superreseller', '31252', '0.055', 'D', '1743140281', '0.055', '1', 'answered','15')

28-03-2025 11:17:00 am   username=>u531 -- token=>lwrvcu -- announcement_id=>5809 -- plan_id=>894 -- contact_numbers=>9597280269 -- 
28-03-2025 11:17:00 amget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u531_894_56_A_5809__35_35_30_0.3_6_1_30_1743100200

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( 'u531', 'audio6346739785259470573.wav', 'A', '5809', '', '1743140820', 'C', '35', 'S', 'api_1743140805_u531_voice_699.wav','35','894','56','','promo','answered','static','30','0.3','6','1','30','0' , 'admin,sr83,sr195,u531') 

again_get_cID=>

31258

sql_contact_insert=>

INSERT INTO voice_compaign_detail_31258(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31258', '9597280269', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' )  

sql_contact_update=>

UPDATE voice_compaign_detail_31258 SET status='S', sent_date='1743140821', sarv_api_uniqueid='31258_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND  type='D' AND compaign_id='31258' 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('u531', 'user', '31258', '0.3', 'D', '1743140821', '0.3', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND  type='D' AND compaign_id='31258' 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('sr195', 'superreseller', '31258', '0.13', 'D', '1743140821', '0.13', '1', 'answered','30')

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND  type='D' AND compaign_id='31258' 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('sr83', 'superreseller', '31258', '0.055', 'D', '1743140821', '0.055', '1', 'answered','15')