19-06-2025 10:21:36 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9876149140 -- announcement_id=>7271 -- 19-06-2025 10:21:36 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 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', '20250619090923am5300916819.wav', 'A', '7271', '', '1750308696', 'C', '35', 'S', 'api_1750304370_u4_voice_681.wav','35','25','23','','promo','answered','static','30','0.11','30','1','30','0' , 'admin,u4') again_get_cID=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9876149140', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750308697', sarv_api_uniqueid='40880_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='40880' 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', '40880', '0.11', 'D', '1750308697', '0.11', '1', 'answered','30') 19-06-2025 10:23:22 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9988000023,9023233332 -- announcement_id=>7271 -- 19-06-2025 10:23:22 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9988000023', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750308803', sarv_api_uniqueid='40880_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9023233332', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750308803', sarv_api_uniqueid='40880_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='40880' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.22 WHERE id=167036 LIMIT 1 19-06-2025 10:27:10 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9988000023 -- announcement_id=>7271 -- 19-06-2025 10:27:11 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9988000023', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309032', sarv_api_uniqueid='40880_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='40880' 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=167036 LIMIT 1 19-06-2025 10:30:45 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9988000023 -- announcement_id=>7271 -- 19-06-2025 10:30:45 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9988000023', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309247', sarv_api_uniqueid='40880_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:31:16 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9876149140 -- announcement_id=>7271 -- 19-06-2025 10:31:16 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9876149140', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309277', sarv_api_uniqueid='40880_6' WHERE id='6' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:32:36 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9815761389 -- announcement_id=>7271 -- 19-06-2025 10:32:36 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9815761389', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309357', sarv_api_uniqueid='40880_7' WHERE id='7' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:36:04 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9876149140 -- announcement_id=>7271 -- 19-06-2025 10:36:04 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9876149140', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309565', sarv_api_uniqueid='40880_8' WHERE id='8' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:37:36 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9815761389 -- announcement_id=>7271 -- 19-06-2025 10:37:36 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('40880', '9815761389', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309657', sarv_api_uniqueid='40880_9' WHERE id='9' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:39:55 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8558000150 -- announcement_id=>7271 -- 19-06-2025 10:39:55 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '8558000150', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309796', sarv_api_uniqueid='40880_10' WHERE id='10' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:41:00 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8558000140 -- announcement_id=>7271 -- 19-06-2025 10:41:00 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '8558000140', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309861', sarv_api_uniqueid='40880_11' WHERE id='11' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:42:05 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9876149140 -- announcement_id=>7271 -- 19-06-2025 10:42:05 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9876149140', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750309926', sarv_api_uniqueid='40880_12' WHERE id='12' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:49:43 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9779755727 -- announcement_id=>7271 -- 19-06-2025 10:49:43 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9779755727', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750310384', sarv_api_uniqueid='40880_13' WHERE id='13' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 10:49:48 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9779755727 -- announcement_id=>7271 -- 19-06-2025 10:49:48 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7271__35_35_30_0.11_30_1_30_1750271400 compaign_id=> 40880 sql_contact_insert=> INSERT INTO voice_compaign_detail_40880(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40880', '9779755727', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40880 SET status='S', sent_date='1750310389', sarv_api_uniqueid='40880_14' WHERE id='14' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='40880' 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=167036 LIMIT 1 19-06-2025 12:30:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7280 -- plan_id=>894 -- contact_numbers=>8072301606 -- 19-06-2025 12:30:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7280 -- plan_id=>894 -- contact_numbers=>9789890137 -- 19-06-2025 12:30:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7280 -- plan_id=>894 -- contact_numbers=>8523935848 -- 19-06-2025 12:30:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7280__35_35_30_0.3_79_6_30_1750271400 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', 'Dream_English_Traditional_ABC01_JKgypN2.wav', 'A', '7280', '', '1750316401', 'C', '35', 'S', 'api_1750315584_u531_voice_707.wav','35','894','56','','promo','answered','static','30','0.3','79','3','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 40914 sql_contact_insert=> INSERT INTO voice_compaign_detail_40914(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40914', '9789890137', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40914 SET status='S', sent_date='1750316401', sarv_api_uniqueid='40914_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='40914' AND no_of_pulse='3' 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', '40914', '0.9', 'D', '1750316402', '0.3', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40914' AND no_of_pulse='3' 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', '40914', '0.39', 'D', '1750316402', '0.13', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40914' AND no_of_pulse='6' 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', '40914', '0.33', 'D', '1750316402', '0.055', '6', 'answered','15') 19-06-2025 12:30:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7280__35_35_30_0.3_79_6_30_1750271400 compaign_id=> 40914 sql_contact_insert=> INSERT INTO voice_compaign_detail_40914(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40914', '8072301606', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40914 SET status='S', sent_date='1750316401', sarv_api_uniqueid='40914_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='40914' AND no_of_pulse='3' 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', '40914', '0.9', 'D', '1750316402', '0.3', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40914' AND no_of_pulse='3' 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', '40914', '0.39', 'D', '1750316402', '0.13', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40914' AND no_of_pulse='6' 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', '40914', '0.33', 'D', '1750316402', '0.055', '6', 'answered','15') 19-06-2025 12:30:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7280__35_35_30_0.3_79_6_30_1750271400 compaign_id=> 40914 sql_contact_insert=> INSERT INTO voice_compaign_detail_40914(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40914', '8523935848', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40914 SET status='S', sent_date='1750316402', sarv_api_uniqueid='40914_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='40914' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.9 WHERE id=167174 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40914' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.39 WHERE id=167176 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40914' AND no_of_pulse='6' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.33 WHERE id=167178 LIMIT 1 19-06-2025 01:00:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7282 -- plan_id=>894 -- contact_numbers=>9940290210 -- 19-06-2025 01:00:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7282__35_35_30_0.3_10_1_30_1750271400 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', 'audio3904333662045380681.wav', 'A', '7282', '', '1750318201', 'C', '35', 'S', 'api_1750317900_u531_voice_897.wav','35','894','56','','promo','answered','static','30','0.3','10','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 40920 sql_contact_insert=> INSERT INTO voice_compaign_detail_40920(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40920', '9940290210', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40920 SET status='S', sent_date='1750318201', sarv_api_uniqueid='40920_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='40920' 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', '40920', '0.3', 'D', '1750318201', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40920' 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', '40920', '0.13', 'D', '1750318201', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40920' 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', '40920', '0.055', 'D', '1750318201', '0.055', '1', 'answered','15') 19-06-2025 01:12:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7283 -- plan_id=>894 -- contact_numbers=>9790515061 -- 19-06-2025 01:12:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7283 -- plan_id=>894 -- contact_numbers=>9551362239 -- 19-06-2025 01:12:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7283__35_35_30_0.3_8_1_30_1750271400 compaign_id=> 40922 sql_contact_insert=> INSERT INTO voice_compaign_detail_40922(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40922', '9790515061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40922 SET status='S', sent_date='1750318921', sarv_api_uniqueid='40922_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='40922' 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', '40922', '0.3', 'D', '1750318921', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40922' 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', '40922', '0.13', 'D', '1750318921', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40922' 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', '40922', '0.055', 'D', '1750318921', '0.055', '1', 'answered','15') 19-06-2025 01:12:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7283__35_35_30_0.3_8_1_30_1750271400 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', 'audio8072743169267051715.wav', 'A', '7283', '', '1750318920', 'C', '35', 'S', 'api_1750318860_u531_voice_947.wav','35','894','56','','promo','answered','static','30','0.3','8','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 40922 sql_contact_insert=> INSERT INTO voice_compaign_detail_40922(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40922', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40922 SET status='S', sent_date='1750318921', sarv_api_uniqueid='40922_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='40922' 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', '40922', '0.3', 'D', '1750318921', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40922' 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', '40922', '0.13', 'D', '1750318921', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40922' 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', '40922', '0.055', 'D', '1750318921', '0.055', '1', 'answered','15') 19-06-2025 02:06:41 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>7284 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 19-06-2025 02:06:43 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_7284__35_35_15_0.16_8_1_15_1750271400 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( 'u635', '1cc0613de614492089d4e14cb5a6029a.mp3', 'A', '7284', '', '1750322205', 'C', '35', 'S', 'api_1750322199_u635_voice_660.wav','35','1050','13','','promo','answered','static','15','0.16','8','1','15','0' , 'admin,u635') again_get_cID=> 40926 sql_contact_insert=> INSERT INTO voice_compaign_detail_40926(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40926', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_40926 SET status='S', sent_date='1750322205', sarv_api_uniqueid='40926_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='40926' 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('u635', 'user', '40926', '0.16', 'D', '1750322206', '0.16', '1', 'answered','15') 19-06-2025 02:25:34 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>7285 -- caller_id=>8985705878 -- contact_numbers=>8125518819,8985705878,9010738910 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 19-06-2025 02:25:34 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_7285__35_35_15_0.16_5_1_15_1750271400 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( 'u635', '975cadb59b594a958adc7692ebbc107e.mp3', 'A', '7285', '', '1750323334', 'C', '35', 'S', 'api_1750323333_u635_voice_166.wav','35','1050','13','','promo','answered','static','15','0.16','5','1','15','0' , 'admin,u635') again_get_cID=> 40931 sql_contact_insert=> INSERT INTO voice_compaign_detail_40931(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40931', '8125518819', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_40931 SET status='S', sent_date='1750323335', sarv_api_uniqueid='40931_1' WHERE id='1' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_40931(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40931', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_40931 SET status='S', sent_date='1750323335', sarv_api_uniqueid='40931_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_40931(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40931', '9010738910', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_40931 SET status='S', sent_date='1750323335', sarv_api_uniqueid='40931_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='40931' 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('u635', 'user', '40931', '0.48', 'D', '1750323335', '0.16', '1', 'answered','15') 19-06-2025 04:00:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7281 -- plan_id=>894 -- contact_numbers=>8523935848 -- 19-06-2025 04:00:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7281 -- plan_id=>894 -- contact_numbers=>9789890137 -- 19-06-2025 04:00:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>7281 -- plan_id=>894 -- contact_numbers=>8072301606 -- 19-06-2025 04:00:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7281__35_35_30_0.3_12_1_30_1750271400 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', 'audio9045489080817855427.wav', 'A', '7281', '', '1750329001', 'C', '35', 'S', 'api_1750315704_u531_voice_599.wav','35','894','56','','promo','answered','static','30','0.3','12','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 40949 sql_contact_insert=> INSERT INTO voice_compaign_detail_40949(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40949', '8523935848', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40949 SET status='S', sent_date='1750329001', sarv_api_uniqueid='40949_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='40949' 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', '40949', '0.3', 'D', '1750329001', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40949' 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', '40949', '0.13', 'D', '1750329001', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40949' 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', '40949', '0.055', 'D', '1750329001', '0.055', '1', 'answered','15') 19-06-2025 04:00:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7281__35_35_30_0.3_12_1_30_1750271400 compaign_id=> 40949 sql_contact_insert=> INSERT INTO voice_compaign_detail_40949(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40949', '8072301606', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40949 SET status='S', sent_date='1750329001', sarv_api_uniqueid='40949_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='40949' 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', '40949', '0.3', 'D', '1750329001', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40949' 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', '40949', '0.13', 'D', '1750329001', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40949' 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', '40949', '0.055', 'D', '1750329001', '0.055', '1', 'answered','15') 19-06-2025 04:00:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_7281__35_35_30_0.3_12_1_30_1750271400 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', 'audio9045489080817855427.wav', 'A', '7281', '', '1750329001', 'C', '35', 'S', 'api_1750315704_u531_voice_599.wav','35','894','56','','promo','answered','static','30','0.3','12','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 40948 sql_contact_insert=> INSERT INTO voice_compaign_detail_40948(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('40948', '9789890137', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_40948 SET status='S', sent_date='1750329001', sarv_api_uniqueid='40948_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='40948' 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', '40948', '0.3', 'D', '1750329001', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='40948' 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', '40948', '0.13', 'D', '1750329001', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='40948' 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', '40948', '0.055', 'D', '1750329001', '0.055', '1', 'answered','15')