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



 user discard hour :  

 user discard_time_text:  

 arr gateway ids 38

 <br> sender id is  

 Process is trueprocessing 

<pre/>Array
(
    [38] => Array
        (
            [id] => 38
            [gateway_id] => 38
            [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_38
            [rabitmq_reporting_queue] => QReport_v60_38
            [rabitmq_queue_status] => 1
            [create_date] => 1731045290
            [create_by] => admin
            [update_date] => 1731045348
            [update_by] => sarv26
        )

)


SELECT * FROM `voice_compaign_detail_6789` where status='p' AND report='' AND user_report='' AND compaign_id='6789' AND api_id>0 and api_id=38 ORDER BY id LIMIT 5000 

3 total record 


 publish data 

<pre/>Array
(
    [unique_id] => 6789_1_38-u304
    [ivr_id] => 453
    [receiver] => 07231076364
    [sarv_api_uniqueid] => 6789_1
    [contact_id] => 1
    [uid] => u304
    [callerId] => +911409131823
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1731053642915
    [announcement_path] => 1731053318_u304_voice
    [voice_duration] => 22
)
<pre/>Array
(
    [38] => Array
        (
            [0] => +911409131823
        )

)


rabbitmq name 

 QCall_v60_38

  

 

 1 before publish time 08-Nov-2024 01:44:02 pm 

 1 after publish time 08-Nov-2024 01:44:02 pm 

UPDATE `voice_compaign_detail_6789` SET `status`='S',`sent_date`='1731053642' WHERE `id`='1' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 6789_2_38-u304
    [ivr_id] => 453
    [receiver] => 08947993812
    [sarv_api_uniqueid] => 6789_2
    [contact_id] => 2
    [uid] => u304
    [callerId] => +911409131823
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1731053642918
    [announcement_path] => 1731053318_u304_voice
    [voice_duration] => 22
)
<pre/>Array
(
    [38] => Array
        (
            [0] => +911409131823
        )

)


rabbitmq name 

 QCall_v60_38

  

 

 2 before publish time 08-Nov-2024 01:44:02 pm 

 2 after publish time 08-Nov-2024 01:44:02 pm 

UPDATE `voice_compaign_detail_6789` SET `status`='S',`sent_date`='1731053642' WHERE `id`='2' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 6789_3_38-u304
    [ivr_id] => 453
    [receiver] => 08209019949
    [sarv_api_uniqueid] => 6789_3
    [contact_id] => 3
    [uid] => u304
    [callerId] => +911409131823
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1731053642920
    [announcement_path] => 1731053318_u304_voice
    [voice_duration] => 22
)
<pre/>Array
(
    [38] => Array
        (
            [0] => +911409131823
        )

)


rabbitmq name 

 QCall_v60_38

  

 

 3 before publish time 08-Nov-2024 01:44:02 pm 

 3 after publish time 08-Nov-2024 01:44:02 pm 

UPDATE `voice_compaign_detail_6789` SET `status`='S',`sent_date`='1731053642' WHERE `id`='3' LIMIT 1 
 

 end loog loop record 1  38 

 

 update ivr id :  , ivr_id='453'