SELECT * FROM `voice_compaign_summary` WHERE status ='C'  AND `sent_sms`<=(`answered_sms`+`busy_sms`+`congestion_sms`+`failed_sms`+`hangup_sms`+`no_answer_sms`+`timeout_duration_sms`+`timeout_ring_sms`+`cutting_sms`+`dnd_sms` ) AND total_sms=sent_sms+duplicate_sms AND compaign_file!=1 AND user_report_adjust=0 AND answer_per>0 AND manual_set=0   AND compaign_id='11240'  <pre/>Array
(
    [0] => 11240
    [compaign_id] => 11240
    [1] => r3
    [user_id] => r3
    [2] => 2239,
    [group_ids] => 2239,
    [3] => 
    [sender_id] => 
    [4] => WhatsApp Audio 2025-03-20 at 17.13.48 (online-audio-converter.com) (1).mp3
    [filename] => WhatsApp Audio 2025-03-20 at 17.13.48 (online-audio-converter.com) (1).mp3
    [5] => 12
    [duration] => 12
    [6] => 1
    [credits_per_sms] => 1
    [7] => 15
    [user_pulse] => 15
    [8] => 1742625715
    [start_date] => 1742625715
    [9] => 0
    [end_date] => 0
    [10] => 100000
    [total_sms] => 100000
    [11] => 100000
    [sent_sms] => 100000
    [12] => 0
    [duplicate_sms] => 0
    [13] => 0
    [answered_sms] => 0
    [14] => 0
    [busy_sms] => 0
    [15] => 2645
    [congestion_sms] => 2645
    [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] => 82632
    [cutting_sms] => 82632
    [22] => 14723
    [dnd_sms] => 14723
    [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] => 2645
    [user_congestion_sms] => 2645
    [29] => 14723
    [user_failed_sms] => 14723
    [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] => C
    [status] => C
    [37] => r3
    [created_by] => r3
    [38] => 0
    [isScheduled] => 0
    [39] => 1742625715
    [create_date] => 1742625715
    [40] => 0
    [by_api] => 0
    [41] => 0
    [isRefund] => 0
    [42] => 99
    [cutting_per] => 99
    [43] => 58
    [answer_per] => 58
    [44] => 0
    [dnd_per] => 0
    [45] => 0
    [alloted_api] => 0
    [46] => 0
    [api_pulse] => 0
    [47] => 0
    [api_ring_time] => 0
    [48] => 0
    [api_channels] => 0
    [49] => {"api_allot_time":1742626106,"compaign_read_start_time":1742626106,"compaign_read_complete_time":1742639837,"compaign_send_start_time":1742639882,"compaign_send_complete_time":1742640353}
    [action_time] => {"api_allot_time":1742626106,"compaign_read_start_time":1742626106,"compaign_read_complete_time":1742639837,"compaign_send_start_time":1742639882,"compaign_send_complete_time":1742640353}
    [50] => 0
    [compaign_file] => 0
    [51] => r3_11240_22032025_121825PM_195
    [common_name] => r3_11240_22032025_121825PM_195
    [52] => 1742474504_r3_voice_upload.wav
    [voice_file] => 1742474504_r3_voice_upload.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_2239
    [temp_group_table] => contacts_temp_group_2239
    [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] => 4
    [credit_seq] => 4
    [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] => 200203
    [contact_start_id] => 200203
    [77] => 300262
    [contact_end_id] => 300262
    [78] => 
    [sub_cam_ids] => 
    [79] => 11224
    [parent_compaign_id] => 11224
    [80] => 1742675561
    [last_credit_update_time] => 1742675561
    [81] => R
    [compaign_type] => R
    [82] => 0
    [announcement_id] => 0
    [83] => S
    [api_type] => S
    [84] => 39
    [user_voice_plan_id] => 39
    [85] => 54
    [voice_plan_id] => 54
    [86] => 0
    [gateway_id] => 0
    [87] => 15
    [pulse] => 15
    [88] => 0.055
    [pulse_rate] => 0.055
    [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":"45"}]
    [alloted_apis] => [{"cli":"","g_id":"45"}]
    [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,r3
    [uphierarchy] => admin,r3
    [113] => 
    [extra_params_json] => 
)


Compaign : 11240
\compaign_ans per ans per 56.9395 <br>ans sms 100000 <br>dnd sms 14723 <br><br> require answer perrequire answer per : 48557 <br><br> user answ

 Total Fai


 Total Failed : 15837

 no_answer_count : 5281

 Busy count :4064

 congestion_count : 1880

 failed_count : 4612UPDATE voice_compaign_detail_11265 SET user_report='FNA'




 Tota

 Total Failed : 34880

 no_answer_count : 11629

 Busy count :8951

 congestion_count : 4141

 failed_count : 10159UPDATE voice_compaign_detail_11241 SET user_report='FNA' WHERE api_id=-2 AND user_report=''  ORDER BY rand()UPDUPDUPDATE voice_compaign_detail_11242 SET user_report='FBZ' WHERE api_id=-2 AND user_report=''  ORDER BY rand() LIMIT 96UPDUPDATE voice_compaign_detail_11242 SET user_report='FCG' WHERE api_id=-2 AND user_report=''  ORDER BY rand() LIMIT 4484
UPDATE voice_compaign_detail_11242 SET user_report='FFL' WHERE api_id=-2 AND user_report=''  ORDER BY rand() LIMIT

 B

 

 Blank User Record<pre/>Array
(
    [0] => 
)


 Blank User Record End

 three UPDATE `voice_compaign_summary` SET `user_answered_sms`='49412', `user_busy_sms`='9693', `user_congestion_sms`='4897', `user_failed_sms`='23035', `user_hangup_sms`='0', `user_no_answer_sms`='12594', `user_timeout_duration_sms`='0', `user_timeout_ring_sms`='0', `user_dnd_sms`='0' WHERE `compaign_id`=11242 LIMIT 1 


Time Diff : 0.022

0.022