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



 user discard hour :  

 user discard_time_text:  

 arr gateway ids 44

 <br> sender id is  

 Process is trueprocessing 

<pre/>Array
(
    [44] => Array
        (
            [id] => 44
            [gateway_id] => 44
            [owner_id] => 100001
            [token] => luroekngnkvsaguut7t09439
            [post_url] => http://118.185.137.196/sarvApi/
            [speed_per_minute] => 20000
            [rabitmq_host] => 118.185.137.196
            [rabitmq_port] => 5673
            [rabitmq_user] => noderabbit
            [rabitmq_pass] => saf8777JJKk76KK
            [rabitmq_sending_queue] => QCall_v60_44
            [rabitmq_reporting_queue] => QReport_v60_44
            [rabitmq_queue_status] => 1
            [create_date] => 1732789311
            [create_by] => admin
            [update_date] => 1732789390
            [update_by] => sarv45
        )

)


SELECT * FROM `voice_compaign_detail_12356` where status='p' AND report='' AND user_report='' AND compaign_id='12356' AND api_id>0 and api_id=44 ORDER BY id LIMIT 5000 

5 total record 


 publish data 

<pre/>Array
(
    [unique_id] => 12356_1_44-u304
    [ivr_id] => 453
    [receiver] => 01400830395
    [sarv_api_uniqueid] => 12356_1
    [contact_id] => 1
    [uid] => u304
    [callerId] => 07447141562
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733313543156
    [announcement_path] => 1731126736_u304_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [44] => Array
        (
            [0] => 07447141562
        )

)


rabbitmq name 

 QCall_v60_44

  

 

 1 before publish time 04-Dec-2024 05:29:03 pm 

 1 after publish time 04-Dec-2024 05:29:03 pm 

UPDATE `voice_compaign_detail_12356` SET `status`='S',`sent_date`='1733313543' WHERE `id`='1' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 12356_2_44-u304
    [ivr_id] => 453
    [receiver] => 01400830383
    [sarv_api_uniqueid] => 12356_2
    [contact_id] => 2
    [uid] => u304
    [callerId] => 07447141562
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733313543169
    [announcement_path] => 1731126736_u304_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [44] => Array
        (
            [0] => 07447141562
        )

)


rabbitmq name 

 QCall_v60_44

  

 

 2 before publish time 04-Dec-2024 05:29:03 pm 

 2 after publish time 04-Dec-2024 05:29:03 pm 

UPDATE `voice_compaign_detail_12356` SET `status`='S',`sent_date`='1733313543' WHERE `id`='2' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 12356_3_44-u304
    [ivr_id] => 453
    [receiver] => 01408400493
    [sarv_api_uniqueid] => 12356_3
    [contact_id] => 3
    [uid] => u304
    [callerId] => 07447141562
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733313543185
    [announcement_path] => 1731126736_u304_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [44] => Array
        (
            [0] => 07447141562
        )

)


rabbitmq name 

 QCall_v60_44

  

 

 3 before publish time 04-Dec-2024 05:29:03 pm 

 3 after publish time 04-Dec-2024 05:29:03 pm 

UPDATE `voice_compaign_detail_12356` SET `status`='S',`sent_date`='1733313543' WHERE `id`='3' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 12356_4_44-u304
    [ivr_id] => 453
    [receiver] => 01400830409
    [sarv_api_uniqueid] => 12356_4
    [contact_id] => 4
    [uid] => u304
    [callerId] => 07447141562
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733313543196
    [announcement_path] => 1731126736_u304_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [44] => Array
        (
            [0] => 07447141562
        )

)


rabbitmq name 

 QCall_v60_44

  

 

 4 before publish time 04-Dec-2024 05:29:03 pm 

 4 after publish time 04-Dec-2024 05:29:03 pm 

UPDATE `voice_compaign_detail_12356` SET `status`='S',`sent_date`='1733313543' WHERE `id`='4' LIMIT 1 


 publish data 

<pre/>Array
(
    [unique_id] => 12356_5_44-u304
    [ivr_id] => 453
    [receiver] => 01401891998
    [sarv_api_uniqueid] => 12356_5
    [contact_id] => 5
    [uid] => u304
    [callerId] => 07447141562
    [dtmf_timeout_manual] => 0
    [retryCount] => Array
        (
            [unanswered] => 0
            [busy] => 0
            [congestion] => 0
            [other] => 0
        )

    [retryInterval] => 0
    [info] => 
    [ramGTime] => 1733313543212
    [announcement_path] => 1731126736_u304_voice
    [voice_duration] => 19
)
<pre/>Array
(
    [44] => Array
        (
            [0] => 07447141562
        )

)


rabbitmq name 

 QCall_v60_44

  

 

 5 before publish time 04-Dec-2024 05:29:03 pm 

 5 after publish time 04-Dec-2024 05:29:03 pm 

UPDATE `voice_compaign_detail_12356` SET `status`='S',`sent_date`='1733313543' WHERE `id`='5' LIMIT 1 
 

 end loog loop record 1  44 

 

 update ivr id :  , ivr_id='453'