10-01-2025 11:08:17 am   username=>sr98 -- token=>ZF58dI -- plan_id=>257 -- ivr_id=>2972 -- caller_id=>0 -- contact_numbers=>8447190104 -- data=>{"#3":{"TYPE":"T","VALUE":"500","LANGUAGE":"HI"}} -- 
10-01-2025 11:10:49 am   username=>sr98 -- token=>ZF58dI -- plan_id=>257 -- ivr_id=>2972 -- caller_id=>0 -- contact_numbers=>8447190104 -- data=>{"#3":{"TYPE":"T","VALUE":"500","LANGUAGE":"EN"}} -- 
10-01-2025 12:48:30 pm   username=>sr98 -- token=>Pass@1234 -- announcement_id=>3448 -- plan_id=>253 -- contact_numbers=>8750407885 -- caller_id=>0 -- 
10-01-2025 12:49:06 pm   username=>sr38 -- token=>Pass@1234 -- announcement_id=>3448 -- plan_id=>253 -- contact_numbers=>8750407885 -- caller_id=>0 -- 
10-01-2025 12:49:11 pm   username=>sr98 -- token=>Pass@1234 -- announcement_id=>3448 -- plan_id=>253 -- contact_numbers=>8750407885 -- caller_id=>0 -- 
10-01-2025 12:50:46 pm   username=>sr98 -- token=>ZF58dI -- announcement_id=>3448 -- plan_id=>257 -- contact_numbers=>8750407885 -- caller_id=>0 -- 
10-01-2025 12:50:46 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

sr98_257_56_A_3448__35_35_15_0.065_7_1_15_1736447400

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( 'sr98', 'Trust Signal...mp3', 'A', '3448', '', '1736493647', 'C', '35', 'S', '1736441766_sr98_voice_upload.wav','35','257','56','','promo','answered','static','15','0.065','7','1','15','0' , 'admin,sr83,sr98') 

again_get_cID=>

17159

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_17159 SET status='S', sent_date='1736493647', sarv_api_uniqueid='17159_1' WHERE id='1' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr98' AND  type='D' AND compaign_id='17159' 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('sr98', 'superreseller', '17159', '0.065', 'D', '1736493648', '0.065', '1', 'answered','15')

sql_i_select=>

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

10-01-2025 01:20:41 pm   
10-01-2025 01:21:58 pm   username=>sr98 -- token=>ZF58dI -- announcement_id=>3448 -- plan_id=>257 -- contact_numbers=>8750407885 -- caller_id=>0 -- 
10-01-2025 01:21:58 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

sr98_257_56_A_3448__35_35_15_0.065_7_1_15_1736447400

compaign_id=>

17159

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_17159 SET status='S', sent_date='1736495519', sarv_api_uniqueid='17159_2' WHERE id='2' LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.065 WHERE id=69104 LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.055 WHERE id=69105 LIMIT 1 

10-01-2025 01:38:32 pm   username=>sr98 -- token=>ZF58dI -- announcement_id=>3448 -- plan_id=>257 -- contact_numbers=>8750407885,9643981173 -- caller_id=>0 -- 
10-01-2025 01:38:32 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

sr98_257_56_A_3448__35_35_15_0.065_7_1_15_1736447400

compaign_id=>

17159

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_17159 SET status='S', sent_date='1736496513', sarv_api_uniqueid='17159_3' WHERE id='3' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_17159 SET status='S', sent_date='1736496513', sarv_api_uniqueid='17159_4' WHERE id='4' LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.13 WHERE id=69104 LIMIT 1 

sql_i_select=>

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

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=69105 LIMIT 1