SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='32029' LIMIT 1
Array
(
[0] => 32029
[compaign_id] => 32029
[1] => u401
[user_id] => u401
[2] => 30608,
[group_ids] => 30608,
[3] =>
[sender_id] =>
[4] => ideal-delivery-note-01 (1).mp3
[filename] => ideal-delivery-note-01 (1).mp3
[5] => 14
[duration] => 14
[6] => 1
[credits_per_sms] => 1
[7] => 30
[user_pulse] => 30
[8] => 1731324600
[start_date] => 1731324600
[9] => 0
[end_date] => 0
[10] => 22
[total_sms] => 22
[11] => 0
[sent_sms] => 0
[12] => 0
[duplicate_sms] => 0
[13] => 0
[answered_sms] => 0
[14] => 0
[busy_sms] => 0
[15] => 0
[congestion_sms] => 0
[16] => 0
[failed_sms] => 0
[17] => 0
[hangup_sms] => 0
[18] => 0
[no_answer_sms] => 0
[19] => 0
[timeout_duration_sms] => 0
[20] => 0
[timeout_ring_sms] => 0
[21] => 0
[cutting_sms] => 0
[22] => 9
[dnd_sms] => 9
[23] => 0
[blocked_sms] => 0
[24] => 0
[user_total_sms] => 0
[25] => 0
[user_sent_sms] => 0
[26] => 0
[user_answered_sms] => 0
[27] => 0
[user_busy_sms] => 0
[28] => 0
[user_congestion_sms] => 0
[29] => 0
[user_failed_sms] => 0
[30] => 0
[user_hangup_sms] => 0
[31] => 0
[user_no_answer_sms] => 0
[32] => 0
[user_timeout_duration_sms] => 0
[33] => 0
[user_timeout_ring_sms] => 0
[34] => 0
[user_dnd_sms] => 0
[35] => 0
[user_report_adjust] => 0
[36] => IP
[status] => IP
[37] => u401
[created_by] => u401
[38] => 1
[isScheduled] => 1
[39] => 1731298021
[create_date] => 1731298021
[40] => 0
[by_api] => 0
[41] => 0
[isRefund] => 0
[42] => 0
[cutting_per] => 0
[43] => 0
[answer_per] => 0
[44] => 0
[dnd_per] => 0
[45] => 0
[alloted_api] => 0
[46] => 0
[api_pulse] => 0
[47] => 0
[api_ring_time] => 0
[48] => 500
[api_channels] => 500
[49] => {"api_allot_time":1731324606,"compaign_read_start_time":1731324608,"compaign_read_complete_time":1731324612}
[action_time] => {"api_allot_time":1731324606,"compaign_read_start_time":1731324608,"compaign_read_complete_time":1731324612}
[50] => 0
[compaign_file] => 0
[51] => u401_32029_11112024_050006PM_194
[common_name] => u401_32029_11112024_050006PM_194
[52] => 1726645759_u401_voice_.wav
[voice_file] => 1726645759_u401_voice_.wav
[53] => answered
[plan_type] => answered
[54] => 0
[allowed_hits] => 0
[55] => 0
[used_hits] => 0
[56] => 0
[remote_group_id] => 0
[57] =>
[remote_compaign_id] =>
[58] => 0
[remote_recording_id] => 0
[59] =>
[campaign_create_ip] =>
[60] => contacts_temp_group_30608
[temp_group_table] => contacts_temp_group_30608
[61] => 0
[manual_set] => 0
[62] => 0
[manual_done] => 0
[63] => 1
[occupied] => 1
[64] => 1
[immediate_send] => 1
[65] =>
[remote_compaign_status] =>
[66] =>
[logs] =>
[67] => -1
[message_type] => -1
[68] => -1
[extension_key] => -1
[69] => 1
[credit_seq] => 1
[70] => 0
[reschedule_max] => 0
[71] =>
[reschedule_types] =>
[72] => 0
[reschedule_remaining] => 0
[73] =>
[reschedule_compaign_ids] =>
[74] => 0
[reschedule_last_check_time] => 0
[75] =>
[reschedule_ids] =>
[76] => 0
[contact_start_id] => 0
[77] => 0
[contact_end_id] => 0
[78] =>
[sub_cam_ids] =>
[79] => 0
[parent_compaign_id] => 0
[80] => 1731324662
[last_credit_update_time] => 1731324662
[81] => R
[compaign_type] => R
[82] => 0
[announcement_id] => 0
[83] => S
[api_type] => S
[84] => 776
[user_voice_plan_id] => 776
[85] => 8
[voice_plan_id] => 8
[86] => 0
[gateway_id] => 0
[87] => 30
[pulse] => 30
[88] => 0.26
[pulse_rate] => 0.26
[89] => trans
[delivery_route] => trans
[90] => answered
[delivery_type] => answered
[91] => dedicated
[delivery_cli] => dedicated
[92] =>
[caller_id] =>
[93] => 0
[is_ivr_campaign] => 0
[94] => 0
[ivr_id] => 0
[95] =>
[ivr_flow] =>
[96] => 0
[ivr_deduction] => 0
[97] => 0
[cnt_real_pulse] => 0
[98] => 0
[cnt_used_pulse] => 0
[99] => 0
[cnt_used_pulse_2] => 0
[100] => 0
[cnt_used_pulse_3] => 0
[101] => 0
[dtmf_wait_time] => 0
[102] => 0
[ext_duration] => 0
[103] =>
[rt_time] =>
[104] => 0
[rt_answer_duration] => 0
[105] => ["7447141132"]
[clis] => ["7447141132"]
[106] => [{"cli":7447141132,"g_id":145}]
[alloted_apis] => [{"cli":7447141132,"g_id":145}]
[107] => {"FNA":"1","FBZ":0,"FCG":"1","FFL":"1"}
[retry_value] => {"FNA":"1","FBZ":0,"FCG":"1","FFL":"1"}
[108] => 0
[retry_interval] => 0
[109] => 0
[stop_status] => 0
[110] => 0
[pause_resume_status] => 0
[111] =>
[compaign_name] =>
[112] => admin,sr116,u401
[uphierarchy] => admin,sr116,u401
[113] =>
[extra_params_json] =>
)
user discard hour :
user discard_time_text:
arr gateway ids 145
-------------------- Array
(
[145] => Array
(
[0] => 7447141132
)
)
-------------------- array(1) {
[145]=>
array(1) {
[0]=>
int(7447141132)
}
}
CLI SET IN GATEWAY : 145
here for cli
Array
(
[145] => Array
(
[0] => 07447141132
)
)
here for gateway
Array
(
[145] => Array
(
[id] => 145
[name] => V196 - Trans_Dedicated-Reserved
[voice_plan_id] => 5,8,15,37,45
[gateway_cli] => 07447141103
[cli_prefix] => 0
[channels] => 500
[gateway_pulse] => 30
[gateway_ring_time] => 30
[max_cron] => 10
[gateway_type] => si
[isReserve] => 1
[isDedicated] => 0
[create_date] => 1728298056
[create_by] => admin
[status] => 1
[isDeleted] => 0
[update_date] => 1728299737
[update_by] => admin
[api_owner_id] => admin
[total_credits] => 3252
[total_contacts] => 2249
[total_compaigns] => 94
[active_credits] => 2249
[todays_credits] => 52
[todays_time] => 1731263400
)
)
sender id is check max speen : 20000
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 0
)
Process is trueprocessing
Array
(
[145] => Array
(
[id] => 145
[gateway_id] => 145
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
[post_url] => http://118.185.137.196/sarvApi/
[speed_per_minute] => 20000
[rabitmq_host] => 118.185.137.196
[rabitmq_port] => 5673
[rabitmq_user] => noderabbit
[rabitmq_pass] => saf8777JJKk76KK
[rabitmq_sending_queue] => QCall_vOBD40_145
[rabitmq_reporting_queue] => QReport_vOBD40_145
[rabitmq_queue_status] => 1
[create_date] => 1728298056
[create_by] => admin
[update_date] => 1728298117
[update_by] => admin
)
)
before rabbitMq Connection 118.185.137.1965673noderabbitsaf8777JJKk76KK
rabbitMq Connection
SELECT * FROM `voice_compaign_detail_32029` where status='p' AND report='' AND user_report='' AND compaign_id='32029' AND api_id>0 and api_id=145 ORDER BY id LIMIT 5000
13 total record
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_2_145-u401
[ivr_id] => 100
[receiver] => 09443503101
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_2
[contact_id] => 2
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662266
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
2 before publish time 11-Nov-2024 05:01:02 pm
2 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 1
)
20000 :m--------u : 1
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='2' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_3_145-u401
[ivr_id] => 100
[receiver] => 09597799493
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_3
[contact_id] => 3
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662270
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
3 before publish time 11-Nov-2024 05:01:02 pm
3 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 2
)
20000 :m--------u : 2
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='3' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_5_145-u401
[ivr_id] => 100
[receiver] => 09442859285
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_5
[contact_id] => 5
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662273
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
5 before publish time 11-Nov-2024 05:01:02 pm
5 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 3
)
20000 :m--------u : 3
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='5' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_9_145-u401
[ivr_id] => 100
[receiver] => 09443332340
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_9
[contact_id] => 9
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662276
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
9 before publish time 11-Nov-2024 05:01:02 pm
9 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 4
)
20000 :m--------u : 4
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='9' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_11_145-u401
[ivr_id] => 100
[receiver] => 09442752061
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_11
[contact_id] => 11
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662279
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
11 before publish time 11-Nov-2024 05:01:02 pm
11 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 5
)
20000 :m--------u : 5
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='11' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_13_145-u401
[ivr_id] => 100
[receiver] => 09360762480
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_13
[contact_id] => 13
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662283
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
13 before publish time 11-Nov-2024 05:01:02 pm
13 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 6
)
20000 :m--------u : 6
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='13' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_14_145-u401
[ivr_id] => 100
[receiver] => 09715954029
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_14
[contact_id] => 14
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662286
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
14 before publish time 11-Nov-2024 05:01:02 pm
14 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 7
)
20000 :m--------u : 7
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='14' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_16_145-u401
[ivr_id] => 100
[receiver] => 09698693478
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_16
[contact_id] => 16
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662289
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
16 before publish time 11-Nov-2024 05:01:02 pm
16 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 8
)
20000 :m--------u : 8
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='16' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_17_145-u401
[ivr_id] => 100
[receiver] => 09788208036
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_17
[contact_id] => 17
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662292
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
17 before publish time 11-Nov-2024 05:01:02 pm
17 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 9
)
20000 :m--------u : 9
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='17' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_19_145-u401
[ivr_id] => 100
[receiver] => 09486572529
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_19
[contact_id] => 19
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662295
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
19 before publish time 11-Nov-2024 05:01:02 pm
19 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 10
)
20000 :m--------u : 10
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='19' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_20_145-u401
[ivr_id] => 100
[receiver] => 08695522721
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_20
[contact_id] => 20
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662299
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
20 before publish time 11-Nov-2024 05:01:02 pm
20 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 11
)
20000 :m--------u : 11
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='20' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_21_145-u401
[ivr_id] => 100
[receiver] => 09486432382
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_21
[contact_id] => 21
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662320
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
21 before publish time 11-Nov-2024 05:01:02 pm
21 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 12
)
20000 :m--------u : 12
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='21' LIMIT 1
below is cli_id_arrsArray
(
[145] => Array
(
[0] => 07447141132
)
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
publish data
Array
(
[unique_id] => 32029_22_145-u401
[ivr_id] => 100
[receiver] => 09842969190
[announcement_path] => 1726645759_u401_voice_
[sarv_api_uniqueid] => 32029_22
[contact_id] => 22
[uid] => u401
[callerId] => 07447141132
[voice_duration] => 14
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 1
[busy] => 0
[congestion] => 1
[other] => 1
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1731324662324
)
Array
(
[145] => Array
(
[0] => 07447141132
)
)
rabbitmq name
QCall_vOBD40_145
22 before publish time 11-Nov-2024 05:01:02 pm
22 after publish time 11-Nov-2024 05:01:02 pm
Array
(
[last_reset_time] => 1731324661
[max_limit] => 20000
[used_limit] => 13
)
20000 :m--------u : 13
UPDATE `voice_compaign_detail_32029` SET `status`='S',`sent_date`='1731324662' WHERE `id`='22' LIMIT 1
end loog loop record 1 145