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



 user discard hour :  

 user discard_time_text:  

 arr gateway ids 27

 <br> sender id is  

 Process is trueprocessing 

<pre/>Array
(
    [27] => Array
        (
            [id] => 27
            [gateway_id] => 27
            [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_27
            [rabitmq_reporting_queue] => QReport_v60_27
            [rabitmq_queue_status] => 1
            [create_date] => 1727695723
            [create_by] => admin
            [update_date] => 1727695788
            [update_by] => admin
        )

)


SELECT * FROM `voice_compaign_detail_11868` where status='p' AND report='' AND user_report='' AND compaign_id='11868' AND api_id>0 and api_id=27 ORDER BY id LIMIT 5000 

2 total record 


 publish data 

<pre/>Array
(
    [unique_id] => 11868_1_27-u111
    [ivr_id] => 100
    [receiver] => 09508227500
    [sarv_api_uniqueid] => 11868_1
    [contact_id] => 1
    [uid] => u111
    [callerId] => +911409131849
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733032863497
    [announcement_path] => 1732961551_u111_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [27] => Array
        (
            [0] => +911409131849
        )

)


rabbitmq name 

 QCall_v60_27

  

 

 1 before publish time 01-Dec-2024 11:31:03 am 

 1 after publish time 01-Dec-2024 11:31:03 am 

UPDATE `voice_compaign_detail_11868` SET `status`='S',`sent_date`='1733032863' WHERE `id`='1' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 11868_2_27-u111
    [ivr_id] => 100
    [receiver] => 09155598706
    [sarv_api_uniqueid] => 11868_2
    [contact_id] => 2
    [uid] => u111
    [callerId] => +911409131849
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733032863510
    [announcement_path] => 1732961551_u111_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [27] => Array
        (
            [0] => +911409131849
        )

)


rabbitmq name 

 QCall_v60_27

  

 

 2 before publish time 01-Dec-2024 11:31:03 am 

 2 after publish time 01-Dec-2024 11:31:03 am 

UPDATE `voice_compaign_detail_11868` SET `status`='S',`sent_date`='1733032863' WHERE `id`='2' LIMIT 1 
 

 end loog loop record 1  27