14-04-2025 09:28:32 am   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9883069674 -- announcement_id=>6125 -- 
14-04-2025 09:29:40 am   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9768850049 -- announcement_id=>6125 -- 
14-04-2025 09:30:25 am   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9768850049 -- announcement_id=>6125 -- 
14-04-2025 12:18:18 pm   username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>7045084749 -- announcement_id=>6125 -- 
14-04-2025 12:18:18 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_24_17_A_6125__35_35_15_0.075_15_1_15_1744569000

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

33219

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33219 SET status='S', sent_date='1744613299', sarv_api_uniqueid='33219_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='33219' 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', '33219', '0.075', 'D', '1744613299', '0.075', '1', 'answered','15')

14-04-2025 12:25:06 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9892140177,9769126125 -- announcement_id=>6127 -- 
14-04-2025 12:25:06 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6127__35_35_30_0.11_25_1_30_1744569000

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

33220

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33220 SET status='S', sent_date='1744613707', sarv_api_uniqueid='33220_1' WHERE id='1' LIMIT 1 

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33220 SET status='S', sent_date='1744613707', sarv_api_uniqueid='33220_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='33220' 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', '33220', '0.22', 'D', '1744613707', '0.11', '1', 'answered','30')

14-04-2025 12:27:18 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8655408508 -- announcement_id=>6136 -- 
14-04-2025 12:27:18 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6136__35_35_30_0.11_16_1_30_1744569000

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

33222

sql_contact_insert=>

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

sql_contact_update=>

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

14-04-2025 12:29:36 pm   username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9967865006 -- announcement_id=>6136 -- 
14-04-2025 12:29:37 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

u4_25_23_A_6136__35_35_30_0.11_16_1_30_1744569000

compaign_id=>

33222

sql_contact_insert=>

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

sql_contact_update=>

UPDATE voice_compaign_detail_33222 SET status='S', sent_date='1744613978', sarv_api_uniqueid='33222_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='33222' 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=135048 LIMIT 1