total no of record should be process 1
Array
(
[id] => 69
[csv_file_tage] => Test
[user_id] => u431
[file_name] => Untitled spreadsheet - Sheet1 (10).csv
[total_lines] => 2
[valid_record] => 1
[invalid_record] => 1
[called] => 0
[filed_tage_json] => {"0":"PHONE","1":"NAME"}
[create_date] => 1733211050
[create_by] => u431
[status] => 2
[tts_text] => Hi this is test %%NAME%%
[notes] => calling
[schedule_time] => 0
[isDelete] => 0
[campaign_type] => T
[ivr_id] =>
[unique_id] =>
[uphierarchy] => admin
)
Array
(
[0] => Array
(
[0] => %%
[1] => %%
)
)
user gateway detail
Array
(
[0] => 37
)
user details
SELECT * FROM voice_compaign_summary WHERE user_id='u431' AND user_voice_plan_id='724' AND voice_plan_id='28' AND compaign_type='AT' AND sender_id='' AND alloted_api='37' AND gateway_id='37' AND start_date>=1733164200 AND start_date<1733250600 AND total_sms<55000 LIMIT 1
new campaign 12198
%%%%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"12198_1_37-u431","receiver":"09799945685","announcement_path":null,"sarv_api_uniqueid":"12198_1","contact_id":1,"uid":"u431","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\":\"Hi this is test %%NAME%%\",\"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":"9799945685","unique_id":"12198_1_37-u431","system_api_uniqueid":"12198_1"}}
new invoice inserted