14-02-2025 12:10:02 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>4459 -- plan_id=>790 -- contact_numbers=>918308715835,917441111188,919827985386 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"} -- 14-02-2025 12:10:02 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_4459__35_35_15_0.08_23_2_15_1739471400 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( 'sr190', '2753431739515103_SANJAYSHARMA.mp3', 'A', '4459', '', '1739515203', 'C', '35', 'S', 'api_1739515154_sr190_voice_226.wav','35','790','17','','promo','answered','static','15','0.08','23','2','15','0' , 'admin,sr190') again_get_cID=> 23309 sql_contact_insert=> INSERT INTO voice_compaign_detail_23309(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23309', '8308715835', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23309 SET status='S', sent_date='1739515204', sarv_api_uniqueid='23309_1' WHERE id='1' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23309(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23309', '7441111188', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23309 SET status='S', sent_date='1739515204', sarv_api_uniqueid='23309_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23309(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23309', '9827985386', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23309 SET status='S', sent_date='1739515204', sarv_api_uniqueid='23309_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='23309' AND no_of_pulse='2' 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('sr190', 'superreseller', '23309', '0.48', 'D', '1739515204', '0.08', '2', 'answered','15') 14-02-2025 12:12:03 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>4459 -- plan_id=>790 -- contact_numbers=>919827985386,918308715835 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"} -- 14-02-2025 12:12:03 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_4459__35_35_15_0.08_23_2_15_1739471400 compaign_id=> 23309 sql_contact_insert=> INSERT INTO voice_compaign_detail_23309(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23309', '9827985386', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23309 SET status='S', sent_date='1739515327', sarv_api_uniqueid='23309_4' WHERE id='4' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23309(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23309', '8308715835', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23309 SET status='S', sent_date='1739515327', sarv_api_uniqueid='23309_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='23309' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.32 WHERE id=93045 LIMIT 1 14-02-2025 03:02:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4465 -- plan_id=>894 -- contact_numbers=>8686360372 -- 14-02-2025 03:02:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4465 -- plan_id=>894 -- contact_numbers=>9551362239 -- 14-02-2025 03:02:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4465__35_35_30_0.3_14_1_30_1739471400 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', 'audio7106003754544332359.wav', 'A', '4465', '', '1739525521', 'C', '35', 'S', 'api_1739525477_u531_voice_904.wav','35','894','56','','promo','answered','static','30','0.3','14','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23350 sql_contact_insert=> INSERT INTO voice_compaign_detail_23350(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23350', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23350 SET status='S', sent_date='1739525521', sarv_api_uniqueid='23350_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='23350' 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', '23350', '0.3', 'D', '1739525521', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23350' 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', '23350', '0.13', 'D', '1739525521', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23350' 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', '23350', '0.055', 'D', '1739525521', '0.055', '1', 'answered','15') 14-02-2025 03:02:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4465__35_35_30_0.3_14_1_30_1739471400 compaign_id=> 23350 sql_contact_insert=> INSERT INTO voice_compaign_detail_23350(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23350', '8686360372', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23350 SET status='S', sent_date='1739525521', sarv_api_uniqueid='23350_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='23350' 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', '23350', '0.3', 'D', '1739525521', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23350' 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', '23350', '0.13', 'D', '1739525521', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23350' 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', '23350', '0.055', 'D', '1739525521', '0.055', '1', 'answered','15') 14-02-2025 03:05:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4467 -- plan_id=>894 -- contact_numbers=>9677886319 -- 14-02-2025 03:05:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4467 -- plan_id=>894 -- contact_numbers=>9597280269 -- 14-02-2025 03:05:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4467 -- plan_id=>894 -- contact_numbers=>8686360372 -- 14-02-2025 03:05:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4467 -- plan_id=>894 -- contact_numbers=>9790515061 -- 14-02-2025 03:05:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4467 -- plan_id=>894 -- contact_numbers=>9551362239 -- 14-02-2025 03:05:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4467__35_35_30_0.3_12_1_30_1739471400 compaign_id=> 23353 sql_contact_insert=> INSERT INTO voice_compaign_detail_23353(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23353', '9677886319', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23353 SET status='S', sent_date='1739525701', sarv_api_uniqueid='23353_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='23353' 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', '23353', '0.3', 'D', '1739525701', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23353' 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', '23353', '0.13', 'D', '1739525701', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23353' 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', '23353', '0.055', 'D', '1739525701', '0.055', '1', 'answered','15') 14-02-2025 03:05:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4467__35_35_30_0.3_12_1_30_1739471400 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', 'audio3419845745113626963.wav', 'A', '4467', '', '1739525701', 'C', '35', 'S', 'api_1739525680_u531_voice_142.wav','35','894','56','','promo','answered','static','30','0.3','12','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23355 sql_contact_insert=> INSERT INTO voice_compaign_detail_23354(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23354', '8686360372', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23354 SET status='S', sent_date='1739525701', sarv_api_uniqueid='23354_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='23354' 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', '23354', '0.3', 'D', '1739525701', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23354' 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', '23354', '0.13', 'D', '1739525701', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23354' 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', '23354', '0.055', 'D', '1739525701', '0.055', '1', 'answered','15') 14-02-2025 03:05:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4467__35_35_30_0.3_12_1_30_1739471400 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', 'audio3419845745113626963.wav', 'A', '4467', '', '1739525701', 'C', '35', 'S', 'api_1739525680_u531_voice_142.wav','35','894','56','','promo','answered','static','30','0.3','12','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23355 sql_contact_insert=> INSERT INTO voice_compaign_detail_23355(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23355', '9790515061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23355 SET status='S', sent_date='1739525701', sarv_api_uniqueid='23355_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='23355' 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', '23355', '0.3', 'D', '1739525701', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23355' 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', '23355', '0.13', 'D', '1739525701', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23355' 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', '23355', '0.055', 'D', '1739525701', '0.055', '1', 'answered','15') 14-02-2025 03:05:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4467__35_35_30_0.3_12_1_30_1739471400 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', 'audio3419845745113626963.wav', 'A', '4467', '', '1739525701', 'C', '35', 'S', 'api_1739525680_u531_voice_142.wav','35','894','56','','promo','answered','static','30','0.3','12','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23353 sql_contact_insert=> INSERT INTO voice_compaign_detail_23353(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('23353', '9597280269', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_23353 SET status='S', sent_date='1739525701', sarv_api_uniqueid='23353_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='23353' 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', '23353', '0.3', 'D', '1739525702', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23353' 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', '23353', '0.13', 'D', '1739525702', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23353' 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=93197 LIMIT 1 14-02-2025 03:05:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4467__35_35_30_0.3_12_1_30_1739471400 compaign_id=> 23355 sql_contact_insert=> INSERT INTO voice_compaign_detail_23355(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23355', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23355 SET status='S', sent_date='1739525701', sarv_api_uniqueid='23355_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='23355' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.3 WHERE id=93190 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23355' 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', '23355', '0.13', 'D', '1739525702', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23355' 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', '23355', '0.055', 'D', '1739525702', '0.055', '1', 'answered','15') 14-02-2025 03:07:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4468 -- plan_id=>894 -- contact_numbers=>8686360372 -- 14-02-2025 03:07:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4468__35_35_30_0.3_22_2_30_1739471400 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', 'audio867513820980327871.wav', 'A', '4468', '', '1739525821', 'C', '35', 'S', 'api_1739525787_u531_voice_111.wav','35','894','56','','promo','answered','static','30','0.3','22','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23356 sql_contact_insert=> INSERT INTO voice_compaign_detail_23356(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23356', '8686360372', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23356 SET status='S', sent_date='1739525821', sarv_api_uniqueid='23356_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='23356' 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', '23356', '0.3', 'D', '1739525821', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23356' 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', '23356', '0.13', 'D', '1739525821', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23356' AND no_of_pulse='2' 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', '23356', '0.11', 'D', '1739525821', '0.055', '2', 'answered','15') 14-02-2025 03:42:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>4471 -- plan_id=>894 -- contact_numbers=>9551362239 -- 14-02-2025 03:42:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_4471__35_35_30_0.3_9_1_30_1739471400 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', 'audio6947058239240273937.wav', 'A', '4471', '', '1739527921', 'C', '35', 'S', 'api_1739527875_u531_voice_352.wav','35','894','56','','promo','answered','static','30','0.3','9','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 23374 sql_contact_insert=> INSERT INTO voice_compaign_detail_23374(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23374', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23374 SET status='S', sent_date='1739527921', sarv_api_uniqueid='23374_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='23374' 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', '23374', '0.3', 'D', '1739527921', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='23374' 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', '23374', '0.13', 'D', '1739527921', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='23374' 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', '23374', '0.055', 'D', '1739527921', '0.055', '1', 'answered','15') 14-02-2025 06:27:00 pm username=> -- 14-02-2025 06:37:02 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>3897 -- plan_id=>790 -- contact_numbers=>918851254495 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"} -- 14-02-2025 06:37:02 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_3897__35_35_15_0.08_18_2_15_1739471400 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( 'sr190', '2815651738312457_gf.mp3', 'A', '3897', '', '1739538423', 'C', '35', 'S', 'api_1738312459_sr190_voice_436.wav','35','790','17','','promo','answered','static','15','0.08','18','2','15','0' , 'admin,sr190') again_get_cID=> 23411 sql_contact_insert=> INSERT INTO voice_compaign_detail_23411(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23411', '8851254495', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_23411 SET status='S', sent_date='1739538424', sarv_api_uniqueid='23411_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='23411' AND no_of_pulse='2' 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('sr190', 'superreseller', '23411', '0.16', 'D', '1739538424', '0.08', '2', 'answered','15') 14-02-2025 08:21:53 pm username=>u425 -- token=>hJlEQH -- announcement_id=>001 -- plan_id=>703 -- contact_numbers=>9480028276 -- caller_id=>6360158947 -- 14-02-2025 08:23:45 pm username=>u425 -- token=>hJlEQH -- announcement_id=>2605 -- plan_id=>703 -- contact_numbers=>9480028276 -- caller_id=>6360158947 -- 14-02-2025 08:24:07 pm username=>u425 -- token=>hJlEQH -- announcement_id=>2605 -- plan_id=>704 -- contact_numbers=>9480028276 -- caller_id=>6360158947 -- 14-02-2025 08:24:39 pm username=>u425 -- token=>hJlEQH -- announcement_id=>2605 -- plan_id=>704 -- contact_numbers=>9480028276 -- caller_id=>6360158947 --