SELECT * FROM `voice_compaign_summary` WHERE status='IP'   AND compaign_id='31892'   LIMIT 1 



 user discard hour :  

 user discard_time_text:  

 arr gateway ids 31

 <br> sender id is  

 Process is trueprocessing 

<pre/>Array
(
    [31] => Array
        (
            [id] => 31
            [gateway_id] => 31
            [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_v60_31
            [rabitmq_reporting_queue] => QReport_v60_31
            [rabitmq_queue_status] => 1
            [create_date] => 1727696243
            [create_by] => admin
            [update_date] => 1727696319
            [update_by] => admin
        )

)


SELECT * FROM `voice_compaign_detail_31892` where status='p' AND report='' AND user_report='' AND compaign_id='31892' AND api_id>0 and api_id=31 ORDER BY id LIMIT 5000 

3 total record 


 publish data 

<pre/>Array
(
    [unique_id] => 31892_2_31-u607
    [ivr_id] => 100
    [receiver] => 08143143345
    [sarv_api_uniqueid] => 31892_2
    [contact_id] => 2
    [uid] => u607
    [callerId] => +911409131849
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1743398162266
    [announcement_path] => 1743396055_u607_voice
    [voice_duration] => 21
)
<pre/>Array
(
    [31] => Array
        (
            [0] => +911409131849
        )

)


rabbitmq name 

 QCall_v60_31

  

 

 2 before publish time 31-Mar-2025 10:46:02 am 

 2 after publish time 31-Mar-2025 10:46:02 am 

UPDATE `voice_compaign_detail_31892` SET `status`='S',`sent_date`='1743398162' WHERE `id`='2' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 31892_3_31-u607
    [ivr_id] => 100
    [receiver] => 09640027456
    [sarv_api_uniqueid] => 31892_3
    [contact_id] => 3
    [uid] => u607
    [callerId] => +911409131849
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1743398162278
    [announcement_path] => 1743396055_u607_voice
    [voice_duration] => 21
)
<pre/>Array
(
    [31] => Array
        (
            [0] => +911409131849
        )

)


rabbitmq name 

 QCall_v60_31

  

 

 3 before publish time 31-Mar-2025 10:46:02 am 

 3 after publish time 31-Mar-2025 10:46:02 am 

UPDATE `voice_compaign_detail_31892` SET `status`='S',`sent_date`='1743398162' WHERE `id`='3' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 31892_4_31-u607
    [ivr_id] => 100
    [receiver] => 09573078774
    [sarv_api_uniqueid] => 31892_4
    [contact_id] => 4
    [uid] => u607
    [callerId] => +911409131849
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1743398162296
    [announcement_path] => 1743396055_u607_voice
    [voice_duration] => 21
)
<pre/>Array
(
    [31] => Array
        (
            [0] => +911409131849
        )

)


rabbitmq name 

 QCall_v60_31

  

 

 4 before publish time 31-Mar-2025 10:46:02 am 

 4 after publish time 31-Mar-2025 10:46:02 am 

UPDATE `voice_compaign_detail_31892` SET `status`='S',`sent_date`='1743398162' WHERE `id`='4' LIMIT 1 
 

 end loog loop record 1  31