19-05-2025 12:02:33 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9769817389 -- announcement_id=>6127 -- 
19-05-2025 12:02:33 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6127__35_35_30_0.11_25_1_30_1747593000

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', '', '1747636354', '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=>

37231

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37231 SET status='S', sent_date='1747636354', sarv_api_uniqueid='37231_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='37231' 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', '37231', '0.11', 'D', '1747636355', '0.11', '1', 'answered','30')

19-05-2025 12:54:38 pm   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9137394902 -- announcement_id=>6125 -- 
19-05-2025 12:54:38 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_24_17_A_6125__35_35_15_0.075_15_1_15_1747593000

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', '20250410205413pm6155629157.wav', 'A', '6125', '', '1747639479', 'C', '35', 'S', 'api_1744298658_u4_voice_991.wav','35','24','17','','promo','answered','static','15','0.075','15','1','15','0' , 'admin,u4') 

again_get_cID=>

37244

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37244 SET status='S', sent_date='1747639479', sarv_api_uniqueid='37244_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='37244' 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', '37244', '0.075', 'D', '1747639480', '0.075', '1', 'answered','15')

19-05-2025 03:27:24 pm   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9702791025 -- announcement_id=>6125 -- 
19-05-2025 03:27:24 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_24_17_A_6125__35_35_15_0.075_15_1_15_1747593000

compaign_id=>

37244

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37244 SET status='S', sent_date='1747648645', sarv_api_uniqueid='37244_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='37244' 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=151304 LIMIT 1 

19-05-2025 06:07:27 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8275777195 -- announcement_id=>2650 -- 
19-05-2025 06:07:29 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_2650__35_35_30_0.11_21_1_30_1747593000

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', '20241202124007pm7611994673.wav', 'A', '2650', '', '1747658252', 'C', '35', 'S', 'api_1733123409_u4_voice_707.wav','35','25','23','','promo','answered','static','30','0.11','21','1','30','0' , 'admin,u4') 

again_get_cID=>

37312

sql_contact_insert=>

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

sql_contact_update=>

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

19-05-2025 06:07:34 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7588728034 -- announcement_id=>2650 -- 
19-05-2025 06:07:34 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_2650__35_35_30_0.11_21_1_30_1747593000

compaign_id=>

37312

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37312 SET status='S', sent_date='1747658255', sarv_api_uniqueid='37312_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='37312' 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=151579 LIMIT 1 

19-05-2025 06:07:42 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7768832631 -- announcement_id=>2650 -- 
19-05-2025 06:07:42 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_2650__35_35_30_0.11_21_1_30_1747593000

compaign_id=>

37312

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37312 SET status='S', sent_date='1747658263', sarv_api_uniqueid='37312_3' WHERE id='3' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='37312' 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=151579 LIMIT 1 

19-05-2025 06:07:49 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9370121824 -- announcement_id=>2650 -- 
19-05-2025 06:07:49 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_2650__35_35_30_0.11_21_1_30_1747593000

compaign_id=>

37312

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_37312 SET status='S', sent_date='1747658271', sarv_api_uniqueid='37312_4' WHERE id='4' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND  type='D' AND compaign_id='37312' 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=151579 LIMIT 1