SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='39845' LIMIT 1
Array
(
[0] => 39845
[compaign_id] => 39845
[1] => u647
[user_id] => u647
[2] => 36831,
[group_ids] => 36831,
[3] =>
[sender_id] =>
[4] => devmanus voice.mp3
[filename] => devmanus voice.mp3
[5] => 28
[duration] => 28
[6] => 1
[credits_per_sms] => 1
[7] => 30
[user_pulse] => 30
[8] => 1748868148
[start_date] => 1748868148
[9] => 0
[end_date] => 0
[10] => 100000
[total_sms] => 100000
[11] => 99988
[sent_sms] => 99988
[12] => 0
[duplicate_sms] => 0
[13] => 168
[answered_sms] => 168
[14] => 85
[busy_sms] => 85
[15] => 0
[congestion_sms] => 0
[16] => 582
[failed_sms] => 582
[17] => 0
[hangup_sms] => 0
[18] => 193
[no_answer_sms] => 193
[19] => 0
[timeout_duration_sms] => 0
[20] => 0
[timeout_ring_sms] => 0
[21] => 69804
[cutting_sms] => 69804
[22] => 183
[dnd_sms] => 183
[23] => 1
[blocked_sms] => 1
[24] => 0
[user_total_sms] => 0
[25] => 0
[user_sent_sms] => 0
[26] => 168
[user_answered_sms] => 168
[27] => 85
[user_busy_sms] => 85
[28] => 0
[user_congestion_sms] => 0
[29] => 765
[user_failed_sms] => 765
[30] => 0
[user_hangup_sms] => 0
[31] => 193
[user_no_answer_sms] => 193
[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] => u647
[created_by] => u647
[38] => 0
[isScheduled] => 0
[39] => 1748868148
[create_date] => 1748868148
[40] => 0
[by_api] => 0
[41] => 0
[isRefund] => 0
[42] => 70
[cutting_per] => 70
[43] => 35
[answer_per] => 35
[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":1748868189,"compaign_read_start_time":1748868197,"compaign_read_complete_time":1748868586,"compaign_send_start_time":1748868602}
[action_time] => {"api_allot_time":1748868189,"compaign_read_start_time":1748868197,"compaign_read_complete_time":1748868586,"compaign_send_start_time":1748868602}
[50] => 0
[compaign_file] => 0
[51] => u647_39845_02062025_061309PM_902
[common_name] => u647_39845_02062025_061309PM_902
[52] => 1748860007_u647_voice_.wav
[voice_file] => 1748860007_u647_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] => 10.244.100.241
[campaign_create_ip] => 10.244.100.241
[60] => contacts_temp_group_36831
[temp_group_table] => contacts_temp_group_36831
[61] => 0
[manual_set] => 0
[62] => 0
[manual_done] => 0
[63] => 1
[occupied] => 1
[64] => 0
[immediate_send] => 0
[65] =>
[remote_compaign_status] =>
[66] =>
[logs] =>
[67] => -1
[message_type] => -1
[68] => -1
[extension_key] => -1
[69] => 2
[credit_seq] => 2
[70] => 1
[reschedule_max] => 1
[71] => FNA,FBZ,FCG,FFL,FHG,FTD,FTR,N,
[reschedule_types] => FNA,FBZ,FCG,FFL,FHG,FTD,FTR,N,
[72] => 1
[reschedule_remaining] => 1
[73] =>
[reschedule_compaign_ids] =>
[74] => 0
[reschedule_last_check_time] => 0
[75] =>
[reschedule_ids] =>
[76] => 300000
[contact_start_id] => 300000
[77] => 400000
[contact_end_id] => 400000
[78] =>
[sub_cam_ids] =>
[79] => 39841
[parent_compaign_id] => 39841
[80] => 1748868783
[last_credit_update_time] => 1748868783
[81] => R
[compaign_type] => R
[82] => 0
[announcement_id] => 0
[83] => S
[api_type] => S
[84] => 1121
[user_voice_plan_id] => 1121
[85] => 11
[voice_plan_id] => 11
[86] => 0
[gateway_id] => 0
[87] => 30
[pulse] => 30
[88] => 0.1275
[pulse_rate] => 0.1275
[89] => trans
[delivery_route] => trans
[90] => answered
[delivery_type] => answered
[91] => static
[delivery_cli] => static
[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] =>
[clis] =>
[106] => [{"cli":"","g_id":"165"}]
[alloted_apis] => [{"cli":"","g_id":"165"}]
[107] => {"FNA":0,"FBZ":0,"FCG":0,"FFL":0}
[retry_value] => {"FNA":0,"FBZ":0,"FCG":0,"FFL":0}
[108] => 0
[retry_interval] => 0
[109] => 0
[stop_status] => 0
[110] => 0
[pause_resume_status] => 0
[111] =>
[compaign_name] =>
[112] => admin,sr10,u647
[uphierarchy] => admin,sr10,u647
[113] => {"contact_list_name":"Data_8"}
[extra_params_json] => {"contact_list_name":"Data_8"}
)
user discard hour :
user discard_time_text:
arr gateway ids 165
-------------------- Array
(
[165] => Array
(
[0] =>
)
)
-------------------- array(1) {
[165]=>
array(1) {
[0]=>
string(0) ""
}
}
sender id is check max speen : 200000
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 0
)
/var/www/html/raws/voice_compaign_send_files/send_39845.crn file not exists
Resource id #35Array
(
[start_time] => 1748868602
[last_update_time] => 0
[process_id] => 0
)
current time 1748868962
in if
0 < 1748868913
05:30:00 am < 06:25:13 pm
kill here previous process
Process is trueprocessing
Array
(
[165] => Array
(
[id] => 165
[gateway_id] => 165
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
[post_url] => http://42.104.82.91/sarvApi/
[speed_per_minute] => 200000
[rabitmq_host] => 42.104.82.91
[rabitmq_port] => 5673
[rabitmq_user] => noderabbit
[rabitmq_pass] => saf8777JJKk76KK
[rabitmq_sending_queue] => QCall_vOBD40_165
[rabitmq_reporting_queue] => QReport_vOBD40_165
[rabitmq_queue_status] => 1
[create_date] => 1737533008
[create_by] => admin
[update_date] => 1737533086
[update_by] => admin
)
)
before rabbitMq Connection 42.104.82.915673noderabbitsaf8777JJKk76KK
rabbitMq Connection
SELECT * FROM `voice_compaign_detail_39845` where status='p' AND report='' AND user_report='' AND compaign_id='39845' AND api_id>0 and api_id=165 ORDER BY id LIMIT 5000
12 total record
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99989_165-u647
[ivr_id] => 100
[receiver] => 09820816946
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99989
[contact_id] => 99989
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962929
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99989 before publish time 02-Jun-2025 06:26:02 pm
99989 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 1
)
200000 :m--------u : 1
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99989' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99990_165-u647
[ivr_id] => 100
[receiver] => 09619470175
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99990
[contact_id] => 99990
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962934
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99990 before publish time 02-Jun-2025 06:26:02 pm
99990 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 2
)
200000 :m--------u : 2
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99990' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99991_165-u647
[ivr_id] => 100
[receiver] => 09920316975
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99991
[contact_id] => 99991
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962937
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99991 before publish time 02-Jun-2025 06:26:02 pm
99991 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 3
)
200000 :m--------u : 3
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99991' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99992_165-u647
[ivr_id] => 100
[receiver] => 07506021618
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99992
[contact_id] => 99992
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962955
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99992 before publish time 02-Jun-2025 06:26:02 pm
99992 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 4
)
200000 :m--------u : 4
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99992' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99993_165-u647
[ivr_id] => 100
[receiver] => 09920706335
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99993
[contact_id] => 99993
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962959
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99993 before publish time 02-Jun-2025 06:26:02 pm
99993 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 5
)
200000 :m--------u : 5
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99993' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99994_165-u647
[ivr_id] => 100
[receiver] => 09833674789
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99994
[contact_id] => 99994
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962965
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99994 before publish time 02-Jun-2025 06:26:02 pm
99994 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 6
)
200000 :m--------u : 6
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99994' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99995_165-u647
[ivr_id] => 100
[receiver] => 09920820145
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99995
[contact_id] => 99995
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962969
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99995 before publish time 02-Jun-2025 06:26:02 pm
99995 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 7
)
200000 :m--------u : 7
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99995' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99996_165-u647
[ivr_id] => 100
[receiver] => 09920995868
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99996
[contact_id] => 99996
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962973
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99996 before publish time 02-Jun-2025 06:26:02 pm
99996 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 8
)
200000 :m--------u : 8
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99996' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99997_165-u647
[ivr_id] => 100
[receiver] => 09833843253
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99997
[contact_id] => 99997
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962976
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99997 before publish time 02-Jun-2025 06:26:02 pm
99997 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 9
)
200000 :m--------u : 9
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99997' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99998_165-u647
[ivr_id] => 100
[receiver] => 08879888621
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99998
[contact_id] => 99998
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962979
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99998 before publish time 02-Jun-2025 06:26:02 pm
99998 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 10
)
200000 :m--------u : 10
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99998' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_99999_165-u647
[ivr_id] => 100
[receiver] => 09930931228
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_99999
[contact_id] => 99999
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962982
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
99999 before publish time 02-Jun-2025 06:26:02 pm
99999 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 11
)
200000 :m--------u : 11
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='99999' LIMIT 1
below is cli_id_arrsArray
(
[165] => Array
(
[0] => 07447141859
)
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
publish data
Array
(
[unique_id] => 39845_100000_165-u647
[ivr_id] => 100
[receiver] => 09820280685
[announcement_path] => 1748860007_u647_voice_
[sarv_api_uniqueid] => 39845_100000
[contact_id] => 100000
[uid] => u647
[callerId] => 07447141859
[voice_duration] => 28
[dtmf_timeout_manual] => 0
[retryCount] => Array
(
[unanswered] => 0
[busy] => 0
[congestion] => 0
[other] => 0
)
[retryInterval] => 0
[info] =>
[ramGTime] => 1748868962984
)
Array
(
[165] => Array
(
[0] => 07447141859
)
)
rabbitmq name
QCall_vOBD40_165
100000 before publish time 02-Jun-2025 06:26:02 pm
100000 after publish time 02-Jun-2025 06:26:02 pm
Array
(
[last_reset_time] => 1748868962
[max_limit] => 200000
[used_limit] => 12
)
200000 :m--------u : 12
UPDATE `voice_compaign_detail_39845` SET `status`='S',`sent_date`='1748868962' WHERE `id`='100000' LIMIT 1
end loog loop record 1 165