total no of record should be process 1
Array
(
[id] => 56
[csv_file_tage] => Demo
[user_id] => sr71
[file_name] => Demo excel.csv
[total_lines] => 2
[valid_record] => 2
[invalid_record] => 1
[called] => 0
[filed_tage_json] => {"0":"NAME","1":"PHONE"}
[create_date] => 1732518908
[create_by] => sr71
[status] => 2
[tts_text] => Hello %Name% Your car number 9773 is repaired Please come and check at the workshop.
[notes] => calling
[schedule_time] => 0
[isDelete] => 0
[campaign_type] => T
[ivr_id] =>
[unique_id] =>
[uphierarchy] => admin
)
Array
(
[0] => Array
(
[0] => %Name%
)
)
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>=1732473000 AND start_date<1732559400 AND total_sms<55000 LIMIT 1
new campaign 10845
%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_1_37-sr71","receiver":"09529304561","announcement_path":null,"sarv_api_uniqueid":"10845_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 %Name% Your car number 9773 is repaired Please come and check at the workshop. \",\"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":"9529304561","unique_id":"10845_1_37-sr71","system_api_uniqueid":"10845_1"}}%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_2_37-sr71","receiver":"09549734561","announcement_path":null,"sarv_api_uniqueid":"10845_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 %Name% Your car number 9773 is repaired Please come and check at the workshop. \",\"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":"9549734561","unique_id":"10845_2_37-sr71","system_api_uniqueid":"10845_2"}}
new invoice inserted