12-01-2025 01:05:04 pm   username=>sr190 -- token=>5REKc4 -- announcement_id=>3486 -- plan_id=>790 -- contact_numbers=>919911488433 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"} -- 
12-01-2025 01:05:04 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

sr190_790_17_A_3486__35_35_15_0.08_4_1_15_1736620200

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', '2815651736667209_mperakesh.mp3', 'A', '3486', '', '1736667305', 'C', '35', 'S', 'api_1736667211_sr190_voice_927.wav','35','790','17','','promo','answered','static','15','0.08','4','1','15','0' , 'admin,sr190') 

again_get_cID=>

17389

sql_contact_insert=>

INSERT INTO voice_compaign_detail_17389(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('17389', '9911488433', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_17389 SET status='S', sent_date='1736667306', sarv_api_uniqueid='17389_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='17389' 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('sr190', 'superreseller', '17389', '0.08', 'D', '1736667306', '0.08', '1', 'answered','15')

12-01-2025 01:08:02 pm   username=>sr190 -- token=>5REKc4 -- announcement_id=>3486 -- plan_id=>790 -- contact_numbers=>919911488433 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"} -- 
12-01-2025 01:08:02 pmget_user_limit=>


USER_IVR_CAMPAIGN_ID_KEY=>

sr190_790_17_A_3486__35_35_15_0.08_4_1_15_1736620200

compaign_id=>

17389

sql_contact_insert=>

INSERT INTO voice_compaign_detail_17389(compaign_id, mobile_no, status, api_id, whitelist_status, retry)  VALUES('17389', '9911488433', 'P', '35', '0', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"2"}')  

sql_contact_update=>

UPDATE voice_compaign_detail_17389 SET status='S', sent_date='1736667483', sarv_api_uniqueid='17389_2' WHERE id='2' LIMIT 1 

sql_i_select=>

SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND  type='D' AND compaign_id='17389' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 

sql_i_update=>

UPDATE voice_compaign_credit_invoices SET amount=amount+0.08 WHERE id=70114 LIMIT 1