SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='22878' LIMIT 1
Array ( [0] => 22878 [compaign_id] => 22878 [1] => r9 [user_id] => r9 [2] => 22339, [group_ids] => 22339, [3] => [sender_id] => [4] => WhatsApp Audio 2024-06-21 at 12.36.08 (online-audio-converter.com).mp3(3) [filename] => WhatsApp Audio 2024-06-21 at 12.36.08 (online-audio-converter.com).mp3(3) [5] => 29 [duration] => 29 [6] => 1 [credits_per_sms] => 1 [7] => 30 [user_pulse] => 30 [8] => 1719665334 [start_date] => 1719665334 [9] => 0 [end_date] => 0 [10] => 2 [total_sms] => 2 [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] => r9 [created_by] => r9 [38] => 0 [isScheduled] => 0 [39] => 1719665334 [create_date] => 1719665334 [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":1719665342,"compaign_read_start_time":1719665345,"compaign_read_complete_time":1719665345} [action_time] => {"api_allot_time":1719665342,"compaign_read_start_time":1719665345,"compaign_read_complete_time":1719665345} [50] => 0 [compaign_file] => 0 [51] => r9_22878_29062024_061902PM_157 [common_name] => r9_22878_29062024_061902PM_157 [52] => 1719564757_r9_voice.wav [voice_file] => 1719564757_r9_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_22339 [temp_group_table] => contacts_temp_group_22339 [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] => 157 [user_voice_plan_id] => 157 [85] => 11 [voice_plan_id] => 11 [86] => 0 [gateway_id] => 0 [87] => 30 [pulse] => 30 [88] => 0.17 [pulse_rate] => 0.17 [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":"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,sr10,r9 [uphierarchy] => admin,sr10,r9 [113] => {"contact_list_name":"group_compose_156373"} [extra_params_json] => {"contact_list_name":"group_compose_156373"} ) user discard hour : user discard_time_text: arr gateway ids 79 -------------------- Array ( [79] => Array ( [0] => ) ) -------------------- array(1) { [79]=> array(1) { [0]=> string(0) "" } }