SELECT * FROM `voice_compaign_summary` WHERE status='IP' AND compaign_id='25359' LIMIT 1
Array
(
    [0] => 25359
    [compaign_id] => 25359
    [1] => u355
    [user_id] => u355
    [2] => 24789,
    [group_ids] => 24789,
    [3] => 
    [sender_id] => 
    [4] => WhatsApp Audio 2024-07-04 at 1.11.12 PM.mp3
    [filename] => WhatsApp Audio 2024-07-04 at 1.11.12 PM.mp3
    [5] => 15
    [duration] => 15
    [6] => 1
    [credits_per_sms] => 1
    [7] => 15
    [user_pulse] => 15
    [8] => 1721893794
    [start_date] => 1721893794
    [9] => 0
    [end_date] => 0
    [10] => 18117
    [total_sms] => 18117
    [11] => 18115
    [sent_sms] => 18115
    [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] => 8100
    [cutting_sms] => 8100
    [22] => 0
    [dnd_sms] => 0
    [23] => 15
    [blocked_sms] => 15
    [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] => u355
    [created_by] => u355
    [38] => 0
    [isScheduled] => 0
    [39] => 1721893766
    [create_date] => 1721893766
    [40] => 0
    [by_api] => 0
    [41] => 0
    [isRefund] => 0
    [42] => 45
    [cutting_per] => 45
    [43] => 48
    [answer_per] => 48
    [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":1721893803,"compaign_read_start_time":1721893805,"compaign_read_complete_time":1721893849,"compaign_send_start_time":1721893862}
    [action_time] => {"api_allot_time":1721893803,"compaign_read_start_time":1721893805,"compaign_read_complete_time":1721893849,"compaign_send_start_time":1721893862}
    [50] => 0
    [compaign_file] => 0
    [51] => u355_25359_25072024_012002PM_674
    [common_name] => u355_25359_25072024_012002PM_674
    [52] => 1720079518_u355_voice_upload.wav
    [voice_file] => 1720079518_u355_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.235.192
    [campaign_create_ip] => 10.244.235.192
    [60] => contacts_temp_group_24789
    [temp_group_table] => contacts_temp_group_24789
    [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] => 3
    [message_type] => 3
    [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] => 1721893862
    [last_credit_update_time] => 1721893862
    [81] => R
    [compaign_type] => R
    [82] => 0
    [announcement_id] => 0
    [83] => S
    [api_type] => S
    [84] => 677
    [user_voice_plan_id] => 677
    [85] => 1
    [voice_plan_id] => 1
    [86] => 0
    [gateway_id] => 0
    [87] => 15
    [pulse] => 15
    [88] => 0.16
    [pulse_rate] => 0.16
    [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] => 5
    [dtmf_wait_time] => 5
    [102] => 0
    [ext_duration] => 0
    [103] => 
    [rt_time] => 
    [104] => 0
    [rt_answer_duration] => 0
    [105] => 
    [clis] => 
    [106] => [{"cli":"","g_id":"54"}]
    [alloted_apis] => [{"cli":"","g_id":"54"}]
    [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,sr99,u355
    [uphierarchy] => admin,sr99,u355
    [113] => {"contact_list_name":"group_compose_173523"}
    [extra_params_json] => {"contact_list_name":"group_compose_173523"}
)


 user discard hour :  

 user discard_time_text:  

 arr gateway ids 54

 

 -------------------- 
Array
(
    [54] => Array
        (
            [0] => 
        )

)


 -------------------- array(1) {
  [54]=>
  array(1) {
    [0]=>
    string(0) ""
  }
}

sender id is check max speen : 70000
Array
(
    [last_reset_time] => 1721893922
    [max_limit] => 70000
    [used_limit] => 5000
)


 /var/www/html/raws/voice_compaign_send_files/send_25359.crn file not exists 

Resource id #35
Array
(
    [start_time] => 1721893862
    [last_update_time] => 0
    [process_id] => 0
)
current time 1721893981
in if 
0 < 1721893932
05:30:00 am < 01:22:12 pm
 kill here previous process 

 Process is trueprocessing 

Array
(
    [54] => Array
        (
            [id] => 54
            [gateway_id] => 54
            [owner_id] => 100001
            [token] => luroekngnkvsaguut7t09439
            [post_url] => http://36.255.253.142/sarvApi/
            [speed_per_minute] => 70000
            [rabitmq_host] => 36.255.253.142
            [rabitmq_port] => 5672
            [rabitmq_user] => noderabbit
            [rabitmq_pass] => saf8777JJKk76KK
            [rabitmq_sending_queue] => QCall_vOBD40_54
            [rabitmq_reporting_queue] => QReport_vOBD40_54
            [rabitmq_queue_status] => 1
            [create_date] => 1701936782
            [create_by] => admin
            [update_date] => 1701936842
            [update_by] => admin
        )

)


  before rabbitMq Connection 
36.255.253.142
5672
noderabbit
saf8777JJKk76KK

 rabbitMq Connection 

SELECT * FROM `voice_compaign_detail_25359` where status='p' AND report='' AND user_report='' AND compaign_id='25359' AND api_id>0 and api_id=54 ORDER BY id LIMIT 5000 

2 total record 


 below is cli_id_arrs
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)


 publish data 

Array
(
    [unique_id] => 25359_18116_54-u355
    [ivr_id] => 100
    [receiver] => 09810543467
    [announcement_path] => 1720079518_u355_voice_upload
    [sarv_api_uniqueid] => 25359_18116
    [contact_id] => 18116
    [uid] => u355
    [callerId] => +918645314858
    [voice_duration] => 15
    [dtmf_timeout_manual] => 5
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1721893982308
)
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)


rabbitmq name 

 QCall_vOBD40_54

  

 

 18116 before publish time 25-Jul-2024 01:23:02 pm 

 18116 after publish time 25-Jul-2024 01:23:02 pm 

Array
(
    [last_reset_time] => 1721893922
    [max_limit] => 70000
    [used_limit] => 5001
)
70000 :m--------u : 5001

 
UPDATE `voice_compaign_detail_25359` SET `status`='S',`sent_date`='1721893982' WHERE `id`='18116' LIMIT 1 


 below is cli_id_arrs
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)


 publish data 

Array
(
    [unique_id] => 25359_18117_54-u355
    [ivr_id] => 100
    [receiver] => 09414472556
    [announcement_path] => 1720079518_u355_voice_upload
    [sarv_api_uniqueid] => 25359_18117
    [contact_id] => 18117
    [uid] => u355
    [callerId] => +918645314858
    [voice_duration] => 15
    [dtmf_timeout_manual] => 5
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1721893982313
)
Array
(
    [54] => Array
        (
            [0] => +918645314858
        )

)


rabbitmq name 

 QCall_vOBD40_54

  

 

 18117 before publish time 25-Jul-2024 01:23:02 pm 

 18117 after publish time 25-Jul-2024 01:23:02 pm 

Array
(
    [last_reset_time] => 1721893922
    [max_limit] => 70000
    [used_limit] => 5002
)
70000 :m--------u : 5002

 
UPDATE `voice_compaign_detail_25359` SET `status`='S',`sent_date`='1721893982' WHERE `id`='18117' LIMIT 1 
 

 end loog loop record 1  54