02-07-2025 10:13:18 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8308518180 -- announcement_id=>7323 -- 02-07-2025 10:13:18 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7323__35_35_30_0.11_36_2_30_1751394600 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', '20250623120251pm1000734607.wav', 'A', '7323', '', '1751431398', 'C', '35', 'S', 'api_1750660376_u4_voice_516.wav','35','25','23','','promo','answered','static','30','0.11','36','2','30','0' , 'admin,u4') again_get_cID=> 42369 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8308518180', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431399', sarv_api_uniqueid='42369_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='42369' 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('u4', 'user', '42369', '0.22', 'D', '1751431399', '0.11', '2', 'answered','30') 02-07-2025 10:15:04 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9552902030,9765394646,8308518180,7776828252,7448295074,9623121492,9860703438,8554041852,7798194700,9823614039,8888836290,7499740762,9075104849,7666346500,9657368767,7798959937,7249341083,8605317419,8888284635,8600526564,9307458338,9922150105,9767382664,9527389130,9527389451,7387655613,9067206116,9529686755,8788644114,9503704220,7755973105,7666329598,7447745856,7057275152,9049005774,9049642410,9764082931,9421232466,9673672243,9096398630,9421652325,9021308205,7709291719,8275241400,9527376646,8888068113,7083124747,7757982696,9420609895,9579370518 -- announcement_id=>7323 -- 02-07-2025 10:15:04 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7323__35_35_30_0.11_36_2_30_1751394600 compaign_id=> 42369 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9552902030', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9765394646', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_3' WHERE id='3' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8308518180', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_4' WHERE id='4' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7776828252', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_5' WHERE id='5' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7448295074', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_6' WHERE id='6' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9623121492', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_7' WHERE id='7' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9860703438', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_8' WHERE id='8' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8554041852', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_9' WHERE id='9' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7798194700', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_10' WHERE id='10' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9823614039', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_11' WHERE id='11' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8888836290', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_12' WHERE id='12' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7499740762', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_13' WHERE id='13' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9075104849', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_14' WHERE id='14' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7666346500', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_15' WHERE id='15' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9657368767', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_16' WHERE id='16' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '7798959937', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_17' WHERE id='17' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7249341083', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_18' WHERE id='18' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8605317419', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_19' WHERE id='19' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8888284635', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_20' WHERE id='20' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8600526564', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_21' WHERE id='21' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9307458338', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_22' WHERE id='22' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9922150105', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_23' WHERE id='23' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9767382664', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_24' WHERE id='24' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9527389130', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_25' WHERE id='25' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9527389451', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_26' WHERE id='26' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7387655613', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_27' WHERE id='27' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9067206116', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_28' WHERE id='28' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9529686755', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_29' WHERE id='29' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8788644114', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_30' WHERE id='30' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9503704220', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_31' WHERE id='31' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7755973105', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_32' WHERE id='32' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7666329598', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_33' WHERE id='33' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7447745856', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431505', sarv_api_uniqueid='42369_34' WHERE id='34' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7057275152', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_35' WHERE id='35' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9049005774', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_36' WHERE id='36' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9049642410', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_37' WHERE id='37' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9764082931', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_38' WHERE id='38' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9421232466', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_39' WHERE id='39' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9673672243', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_40' WHERE id='40' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9096398630', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_41' WHERE id='41' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9421652325', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_42' WHERE id='42' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9021308205', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_43' WHERE id='43' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7709291719', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_44' WHERE id='44' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8275241400', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_45' WHERE id='45' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9527376646', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_46' WHERE id='46' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8888068113', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_47' WHERE id='47' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7083124747', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_48' WHERE id='48' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7757982696', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_49' WHERE id='49' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9420609895', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_50' WHERE id='50' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9579370518', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431506', sarv_api_uniqueid='42369_51' WHERE id='51' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='42369' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+11 WHERE id=173063 LIMIT 1 02-07-2025 10:15:07 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8806931002,8237950135,9970203795,8554915547,9579313278,8208011834,842165580,9970926323,9923436906,7218934647,9421288176,8956396136,9145178575,88066481002,9403233760,7499674010,9763210240,9579196802,9403885547,7020674668,7559331074,8999843151,9322546904,9604952919,7420891270,9552721351,7249015625,9325673400,8806675752,7304816133,8898292329,8080928978,9579939440,9673495473,9834510608,9404289026,9284742396,9922872442,9403231361,8468814135,8208301987,9022471949,8308199321,9529067454,9404495816,9588492883,7385190171,9689626652,7057582160,7588793796 -- announcement_id=>7323 -- 02-07-2025 10:15:09 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8412003268,7387469975,8308508440,9766871467,8956610599,9226116001,7755059296,8379831819,9145012950,9881996632 -- announcement_id=>7323 -- 02-07-2025 10:15:09 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7323__35_35_30_0.11_36_2_30_1751394600 compaign_id=> 42369 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8412003268', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_52' WHERE id='52' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7387469975', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_53' WHERE id='53' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8308508440', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_54' WHERE id='54' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9766871467', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_55' WHERE id='55' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '8956610599', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_56' WHERE id='56' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9226116001', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_57' WHERE id='57' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '7755059296', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_58' WHERE id='58' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '8379831819', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_59' WHERE id='59' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42369', '9145012950', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_60' WHERE id='60' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_42369(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42369', '9881996632', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42369 SET status='S', sent_date='1751431510', sarv_api_uniqueid='42369_61' WHERE id='61' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='42369' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+2.2 WHERE id=173063 LIMIT 1 02-07-2025 11:05:03 am username=>u4 -- token=>ruNtks -- plan_id=>24 -- contact_numbers=>9372605675 -- announcement_id=>6125 -- 02-07-2025 11:05:03 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_24_17_A_6125__35_35_15_0.075_15_1_15_1751394600 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', '', '1751434503', '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=> 42378 sql_contact_insert=> INSERT INTO voice_compaign_detail_42378(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42378', '9372605675', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42378 SET status='S', sent_date='1751434504', sarv_api_uniqueid='42378_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='42378' 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', '42378', '0.075', 'D', '1751434504', '0.075', '1', 'answered','15') 02-07-2025 02:17:04 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8058711416 -- announcement_id=>7455 -- 02-07-2025 02:17:04 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7455__35_35_30_0.11_26_1_30_1751394600 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', '20250701113525am8321353362.wav', 'A', '7455', '', '1751446024', 'C', '35', 'S', 'api_1751349930_u4_voice_146.wav','35','25','23','','promo','answered','static','30','0.11','26','1','30','0' , 'admin,u4') again_get_cID=> 42398 sql_contact_insert=> INSERT INTO voice_compaign_detail_42398(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42398', '8058711416', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42398 SET status='S', sent_date='1751446025', sarv_api_uniqueid='42398_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='42398' 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', '42398', '0.11', 'D', '1751446025', '0.11', '1', 'answered','30') 02-07-2025 02:28:47 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7877377775 -- announcement_id=>7455 -- 02-07-2025 02:28:47 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7455__35_35_30_0.11_26_1_30_1751394600 compaign_id=> 42398 sql_contact_insert=> INSERT INTO voice_compaign_detail_42398(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('42398', '7877377775', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_42398 SET status='S', sent_date='1751446729', sarv_api_uniqueid='42398_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='42398' 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=173219 LIMIT 1 02-07-2025 02:30:40 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8107972327 -- announcement_id=>7455 -- 02-07-2025 02:30:40 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7455__35_35_30_0.11_26_1_30_1751394600 compaign_id=> 42398 sql_contact_insert=> INSERT INTO voice_compaign_detail_42398(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42398', '8107972327', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42398 SET status='S', sent_date='1751446842', sarv_api_uniqueid='42398_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='42398' 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=173219 LIMIT 1 02-07-2025 02:31:52 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8890776655 -- announcement_id=>7455 -- 02-07-2025 02:31:52 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7455__35_35_30_0.11_26_1_30_1751394600 compaign_id=> 42398 sql_contact_insert=> INSERT INTO voice_compaign_detail_42398(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42398', '8890776655', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42398 SET status='S', sent_date='1751446913', sarv_api_uniqueid='42398_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='42398' 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=173219 LIMIT 1 02-07-2025 02:40:45 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8890776655 -- announcement_id=>7455 -- 02-07-2025 02:40:45 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_7455__35_35_30_0.11_26_1_30_1751394600 compaign_id=> 42398 sql_contact_insert=> INSERT INTO voice_compaign_detail_42398(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('42398', '8890776655', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_42398 SET status='S', sent_date='1751447446', sarv_api_uniqueid='42398_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='42398' 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=173219 LIMIT 1