SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='23427' LIMIT 1
user discard hour :
user discard_time_text:
arr gateway ids 31
sender id is
Process is trueprocessing
Array
(
[31] => Array
(
[id] => 31
[gateway_id] => 31
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
[post_url] => http://36.255.253.142/sarvApi/
[speed_per_minute] => 70000
[rabitmq_host] => 36.255.253.142
[rabitmq_port] => 5672
[rabitmq_user] => noderabbit
[rabitmq_pass] => saf8777JJKk76KK
[rabitmq_sending_queue] => QCall_v60_31
[rabitmq_reporting_queue] => QReport_v60_31
[rabitmq_queue_status] => 1
[create_date] => 1727696243
[create_by] => admin
[update_date] => 1727696319
[update_by] => admin
)
)
SELECT * FROM `voice_compaign_detail_23427` where status='p' AND report='' AND user_report='' AND compaign_id='23427' AND api_id>0 and api_id=31 ORDER BY id LIMIT 5000
14 total record
publish data
Array
(
[unique_id] => 23427_1_31-u164
[ivr_id] => 100
[receiver] => 07014572026
[sarv_api_uniqueid] => 23427_1
[contact_id] => 1
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563260
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
1 before publish time 15-Feb-2025 10:46:03 am
1 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='1' LIMIT 1
publish data
Array
(
[unique_id] => 23427_2_31-u164
[ivr_id] => 100
[receiver] => 07034704131
[sarv_api_uniqueid] => 23427_2
[contact_id] => 2
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563277
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
2 before publish time 15-Feb-2025 10:46:03 am
2 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='2' LIMIT 1
publish data
Array
(
[unique_id] => 23427_3_31-u164
[ivr_id] => 100
[receiver] => 07738451777
[sarv_api_uniqueid] => 23427_3
[contact_id] => 3
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563293
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
3 before publish time 15-Feb-2025 10:46:03 am
3 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='3' LIMIT 1
publish data
Array
(
[unique_id] => 23427_4_31-u164
[ivr_id] => 100
[receiver] => 08105102316
[sarv_api_uniqueid] => 23427_4
[contact_id] => 4
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563310
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
4 before publish time 15-Feb-2025 10:46:03 am
4 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='4' LIMIT 1
publish data
Array
(
[unique_id] => 23427_6_31-u164
[ivr_id] => 100
[receiver] => 09496328184
[sarv_api_uniqueid] => 23427_6
[contact_id] => 6
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563326
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
6 before publish time 15-Feb-2025 10:46:03 am
6 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='6' LIMIT 1
publish data
Array
(
[unique_id] => 23427_8_31-u164
[ivr_id] => 100
[receiver] => 09539613102
[sarv_api_uniqueid] => 23427_8
[contact_id] => 8
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563343
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
8 before publish time 15-Feb-2025 10:46:03 am
8 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='8' LIMIT 1
publish data
Array
(
[unique_id] => 23427_10_31-u164
[ivr_id] => 100
[receiver] => 09591799022
[sarv_api_uniqueid] => 23427_10
[contact_id] => 10
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563360
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
10 before publish time 15-Feb-2025 10:46:03 am
10 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='10' LIMIT 1
publish data
Array
(
[unique_id] => 23427_12_31-u164
[ivr_id] => 100
[receiver] => 09811997331
[sarv_api_uniqueid] => 23427_12
[contact_id] => 12
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563376
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
12 before publish time 15-Feb-2025 10:46:03 am
12 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='12' LIMIT 1
publish data
Array
(
[unique_id] => 23427_15_31-u164
[ivr_id] => 100
[receiver] => 09947278610
[sarv_api_uniqueid] => 23427_15
[contact_id] => 15
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563393
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
15 before publish time 15-Feb-2025 10:46:03 am
15 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='15' LIMIT 1
publish data
Array
(
[unique_id] => 23427_17_31-u164
[ivr_id] => 100
[receiver] => 09967355469
[sarv_api_uniqueid] => 23427_17
[contact_id] => 17
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563410
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
17 before publish time 15-Feb-2025 10:46:03 am
17 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='17' LIMIT 1
publish data
Array
(
[unique_id] => 23427_18_31-u164
[ivr_id] => 100
[receiver] => 08075400745
[sarv_api_uniqueid] => 23427_18
[contact_id] => 18
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563427
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
18 before publish time 15-Feb-2025 10:46:03 am
18 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='18' LIMIT 1
publish data
Array
(
[unique_id] => 23427_20_31-u164
[ivr_id] => 100
[receiver] => 09096050508
[sarv_api_uniqueid] => 23427_20
[contact_id] => 20
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563444
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
20 before publish time 15-Feb-2025 10:46:03 am
20 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='20' LIMIT 1
publish data
Array
(
[unique_id] => 23427_21_31-u164
[ivr_id] => 100
[receiver] => 09496728499
[sarv_api_uniqueid] => 23427_21
[contact_id] => 21
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563460
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
21 before publish time 15-Feb-2025 10:46:03 am
21 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='21' LIMIT 1
publish data
Array
(
[unique_id] => 23427_22_31-u164
[ivr_id] => 100
[receiver] => 09526492218
[sarv_api_uniqueid] => 23427_22
[contact_id] => 22
[uid] => u164
[callerId] => +911409131892
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1739596563477
[announcement_path] => 1729249381_u164_voice
[voice_duration] => 29
)
Array
(
[31] => Array
(
[0] => +911409131892
)
)
rabbitmq name
QCall_v60_31
22 before publish time 15-Feb-2025 10:46:03 am
22 after publish time 15-Feb-2025 10:46:03 am
UPDATE `voice_compaign_detail_23427` SET `status`='S',`sent_date`='1739596563' WHERE `id`='22' LIMIT 1
end loog loop record 1 31