total no of record should be process 1
Array
(
[id] => 68
[csv_file_tage] => Testing
[user_id] => sr71
[file_name] => voice.csv
[total_lines] => 3
[valid_record] => 2
[invalid_record] => 2
[called] => 0
[filed_tage_json] => {"0":"PHONE","1":"NAME","2":"AMOUNT","3":"DATE"}
[create_date] => 1732609978
[create_by] => sr71
[status] => 2
[tts_text] => hello %PHONE% your %AMOUNT% Due
[notes] => calling
[schedule_time] => 1732610700
[isDelete] => 0
[campaign_type] => T
[ivr_id] =>
[unique_id] =>
[uphierarchy] => admin
)
Array
(
[0] => Array
(
[0] => %PHONE%
[1] => %AMOUNT%
)
)
user gateway detail
Array
(
[0] => 37
)
user details
SELECT * FROM voice_compaign_summary WHERE user_id='sr71' AND user_voice_plan_id='663' AND voice_plan_id='56' AND compaign_type='AT' AND sender_id='' AND alloted_api='37' AND gateway_id='37' AND start_date>=1732559400 AND start_date<1732645800 AND total_sms<55000 LIMIT 1
new campaign 11007
%PHONE%%AMOUNT%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"11007_1_37-sr71","receiver":"09214444236","announcement_path":null,"sarv_api_uniqueid":"11007_1","contact_id":1,"uid":"sr71","callerId":"+911409131823","ivr_flow":"{\"START\":\"#2\",\"#2\":{\"ANSWER_THIS_CALL\":{\"CHILD\":{\"PICKUP\":\"D\",\"CHILD_ID\":[\"#3\"]},\"TYPE\":\"ANSWER_THIS_CALL\",\"TITLE\":\"Answer Call\",\"innerHTML\":\"#zz-2\"}},\"#7000\":{\"HANGUP\":{\"CHILD\":{\"PICKUP\":\"N\"},\"DATA\":[],\"TYPE\":\"HANGUP\",\"TITLE\":\"End\",\"innerHTML\":\"#zz-7000\"}},\"#3\":{\"ANNOUNCEMENT\":{\"DATA\":{\"TYPE\":\"T\",\"CONTENT\":\"hello 9214444236 your 1200 Due\",\"LANGUAGE\":\"EN\",\"VOLUME_LEVEL\":\"0\"},\"CHILD\":{\"PICKUP\":\"D\",\"CHILD_ID\":[\"#7000\"]},\"TYPE\":\"ANNOUNCEMENT\",\"TITLE\":\"ANNOUNCEMENT\",\"innerHTML\":\"#zz-3\"}}}"}
{"status":"success","code":"000","desc":"Call Submitted Successfully","data":{"contact_number":"9214444236","unique_id":"11007_1_37-sr71","system_api_uniqueid":"11007_1"}}%PHONE%%AMOUNT%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"11007_2_37-sr71","receiver":"09079728403","announcement_path":null,"sarv_api_uniqueid":"11007_2","contact_id":2,"uid":"sr71","callerId":"+911409131823","ivr_flow":"{\"START\":\"#2\",\"#2\":{\"ANSWER_THIS_CALL\":{\"CHILD\":{\"PICKUP\":\"D\",\"CHILD_ID\":[\"#3\"]},\"TYPE\":\"ANSWER_THIS_CALL\",\"TITLE\":\"Answer Call\",\"innerHTML\":\"#zz-2\"}},\"#7000\":{\"HANGUP\":{\"CHILD\":{\"PICKUP\":\"N\"},\"DATA\":[],\"TYPE\":\"HANGUP\",\"TITLE\":\"End\",\"innerHTML\":\"#zz-7000\"}},\"#3\":{\"ANNOUNCEMENT\":{\"DATA\":{\"TYPE\":\"T\",\"CONTENT\":\"hello 9079728403 your 1800 Due\",\"LANGUAGE\":\"EN\",\"VOLUME_LEVEL\":\"0\"},\"CHILD\":{\"PICKUP\":\"D\",\"CHILD_ID\":[\"#7000\"]},\"TYPE\":\"ANNOUNCEMENT\",\"TITLE\":\"ANNOUNCEMENT\",\"innerHTML\":\"#zz-3\"}}}"}
{"status":"success","code":"000","desc":"Call Submitted Successfully","data":{"contact_number":"9079728403","unique_id":"11007_2_37-sr71","system_api_uniqueid":"11007_2"}}
new invoice inserted