SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='28457' LIMIT 1
Array ( [0] => 28457 [compaign_id] => 28457 [1] => u476 [user_id] => u476 [2] => 27725, [group_ids] => 27725, [3] => [sender_id] => [4] => WhatsApp Audio 2024-08-25 at 2.05.23 PM.mp3 [filename] => WhatsApp Audio 2024-08-25 at 2.05.23 PM.mp3 [5] => 19 [duration] => 19 [6] => 1 [credits_per_sms] => 1 [7] => 30 [user_pulse] => 30 [8] => 1724575979 [start_date] => 1724575979 [9] => 0 [end_date] => 0 [10] => 1 [total_sms] => 1 [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] => 0 [dnd_sms] => 0 [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] => u476 [created_by] => u476 [38] => 0 [isScheduled] => 0 [39] => 1724575979 [create_date] => 1724575979 [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] => 200 [api_channels] => 200 [49] => {"api_allot_time":1724575986,"compaign_read_start_time":1724575987,"compaign_read_complete_time":1724575987} [action_time] => {"api_allot_time":1724575986,"compaign_read_start_time":1724575987,"compaign_read_complete_time":1724575987} [50] => 0 [compaign_file] => 0 [51] => u476_28457_25082024_022305PM_246 [common_name] => u476_28457_25082024_022305PM_246 [52] => 1724575101_u476_voice.wav [voice_file] => 1724575101_u476_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.235.192 [campaign_create_ip] => 10.244.235.192 [60] => contacts_temp_group_27725 [temp_group_table] => contacts_temp_group_27725 [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] => 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] => 0 [last_credit_update_time] => 0 [81] => R [compaign_type] => R [82] => 0 [announcement_id] => 0 [83] => S [api_type] => S [84] => 854 [user_voice_plan_id] => 854 [85] => 1 [voice_plan_id] => 1 [86] => 0 [gateway_id] => 0 [87] => 30 [pulse] => 30 [88] => 0.2 [pulse_rate] => 0.2 [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":"79"}] [alloted_apis] => [{"cli":"","g_id":"79"}] [107] => {"FNA":"2","FBZ":0,"FCG":"2","FFL":"2"} [retry_value] => {"FNA":"2","FBZ":0,"FCG":"2","FFL":"2"} [108] => 0 [retry_interval] => 0 [109] => 0 [stop_status] => 0 [110] => 0 [pause_resume_status] => 0 [111] => [compaign_name] => [112] => admin,sr69,u476 [uphierarchy] => admin,sr69,u476 [113] => {"contact_list_name":"group_compose_194075"} [extra_params_json] => {"contact_list_name":"group_compose_194075"} ) user discard hour : user discard_time_text: arr gateway ids 79 -------------------- Array ( [79] => Array ( [0] => ) ) -------------------- array(1) { [79]=> array(1) { [0]=> string(0) "" } }