13-04-2025 03:23:53 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>6155 -- caller_id=>8985705878 -- contact_numbers=>8985705878,9550410019 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 13-04-2025 03:23:53 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_6155__35_35_15_0.16_6_1_15_1744482600 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', '5ee113df873944c896d923538b429d66.mp3', 'A', '6155', '', '1744538033', 'C', '35', 'S', 'api_1744538032_u635_voice_704.wav','35','1050','13','','promo','answered','static','15','0.16','6','1','15','0' , 'admin,u635') again_get_cID=> 33133 sql_contact_insert=> INSERT INTO voice_compaign_detail_33133(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('33133', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_33133 SET status='S', sent_date='1744538034', sarv_api_uniqueid='33133_1' WHERE id='1' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_33133(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('33133', '9550410019', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_33133 SET status='S', sent_date='1744538034', sarv_api_uniqueid='33133_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='33133' 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', '33133', '0.32', 'D', '1744538034', '0.16', '1', 'answered','15') 13-04-2025 07:13:20 pm username=>sr62 -- token=>8wsys8 -- announcement_id=>4196 -- caller_id=>1234567890 -- plan_id=>1037 -- contact_numbers=>9240214940, -- 13-04-2025 07:13:20 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr62_1037_3_A_4196__29_29_30_0.15_5_1_30_1744482600 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( 'sr62', 'vsmsdemo-cobra1.mp3', 'A', '4196', '', '1744551800', 'C', '29', 'S', '1738912242_sr62_voice_upload.wav','29','1037','3','','trans','answered','static','30','0.15','5','1','30','0' , 'admin,sr62') again_get_cID=> 33164 sql_contact_insert=> INSERT INTO voice_compaign_detail_33164(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('33164', '9240214940', 'P', '29', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_33164 SET status='S', sent_date='1744551801', sarv_api_uniqueid='33164_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr62' AND type='D' AND compaign_id='33164' 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('sr62', 'superreseller', '33164', '0.15', 'D', '1744551801', '0.15', '1', 'answered','30') 13-04-2025 07:16:06 pm username=>sr62 -- token=>8wsys8 -- announcement_id=>4196 -- caller_id=>1234567890 -- plan_id=>1037 -- contact_numbers=>9240214940, -- 13-04-2025 07:16:06 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr62_1037_3_A_4196__29_29_30_0.15_5_1_30_1744482600 compaign_id=> 33164 sql_contact_insert=> INSERT INTO voice_compaign_detail_33164(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('33164', '9240214940', 'P', '29', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_33164 SET status='S', sent_date='1744551967', sarv_api_uniqueid='33164_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr62' AND type='D' AND compaign_id='33164' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.15 WHERE id=134789 LIMIT 1 13-04-2025 07:30:55 pm username=>sr62 -- token=>8wsys8 -- announcement_id=>4196 -- caller_id=>1234567890 -- plan_id=>1037 -- contact_numbers=>9240214940, -- 13-04-2025 07:30:55 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr62_1037_3_A_4196__29_29_30_0.15_5_1_30_1744482600 compaign_id=> 33164 sql_contact_insert=> INSERT INTO voice_compaign_detail_33164(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('33164', '9240214940', 'P', '29', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_33164 SET status='S', sent_date='1744552856', sarv_api_uniqueid='33164_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr62' AND type='D' AND compaign_id='33164' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.15 WHERE id=134789 LIMIT 1