total no of record should be process 1
Array
(
[id] => 59
[csv_file_tage] => ABC
[user_id] => sr71
[file_name] => Demo excel 1.csv
[total_lines] => 6
[valid_record] => 5
[invalid_record] => 2
[called] => 0
[filed_tage_json] => {"0":"Name","1":"PHONE"}
[create_date] => 1732521469
[create_by] => sr71
[status] => 2
[tts_text] => Hello %Name% Your vehicle is repaired now. Please visit 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
old compaign id
%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_5_37-sr71","receiver":"09529304561","announcement_path":null,"sarv_api_uniqueid":"10845_5","contact_id":5,"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 Gaurav Your vehicle is repaired now. Please visit 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_5_37-sr71","system_api_uniqueid":"10845_5"}}%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_6_37-sr71","receiver":"09549734561","announcement_path":null,"sarv_api_uniqueid":"10845_6","contact_id":6,"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 Rahul Your vehicle is repaired now. Please visit 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_6_37-sr71","system_api_uniqueid":"10845_6"}}%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_7_37-sr71","receiver":"09929452312","announcement_path":null,"sarv_api_uniqueid":"10845_7","contact_id":7,"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 Manisha Your vehicle is repaired now. Please visit 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":"9929452312","unique_id":"10845_7_37-sr71","system_api_uniqueid":"10845_7"}}%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_8_37-sr71","receiver":"09044769004","announcement_path":null,"sarv_api_uniqueid":"10845_8","contact_id":8,"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 Kaushiki Your vehicle is repaired now. Please visit 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":"9044769004","unique_id":"10845_8_37-sr71","system_api_uniqueid":"10845_8"}}%Name%
normal google
in broadcast api response in this queue : QCallAdvanced_v60_37
{"unique_id":"10845_9_37-sr71","receiver":"09982228289","announcement_path":null,"sarv_api_uniqueid":"10845_9","contact_id":9,"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 Sachin Your vehicle is repaired now. Please visit 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":"9982228289","unique_id":"10845_9_37-sr71","system_api_uniqueid":"10845_9"}}