SELECT * FROM `voice_compaign_summary` WHERE status='V' AND alloted_apis='' AND occupied=0 AND compaign_id='15841' LIMIT 1 user dedicated gateway
Array ( [0] => 87 [1] => 88 [2] => 89 [3] => 64 ) plan gateways Array ( [0] => 87 [1] => 88 [2] => 89 [3] => 64 ) 1 XXXXXXXXXXXXXXXXXXX-----------BELOW GATEWAY DETAIL xxxxxxxxxxxxxxxxxxxxxxxxArray ( [88] => Array ( [id] => 88 [gateway_id] => 88 [owner_id] => 100001 [token] => luroekngnkvsaguut7t09439 [post_url] => http://103.179.224.115/sarvApi/ [speed_per_minute] => 10000 [rabitmq_host] => 103.179.224.115 [rabitmq_port] => 5672 [rabitmq_user] => noderabbit [rabitmq_pass] => saf8777JJKk76KK [rabitmq_sending_queue] => QCall_vOBD40_88 [rabitmq_reporting_queue] => QReport_vOBD40_88 [rabitmq_queue_status] => 1 [create_date] => 1714458679 [create_by] => admin [update_date] => 1714458750 [update_by] => admin ) ) XXXXXXXXXXXXXXXXXXX-----------BELOW GATEWAY INFO xxxxxxxxxxxxxxxxxxxxxxxxArray ( [88] => Array ( [id] => 88 [name] => V115-TAS-Videocon-02 [voice_plan_id] => 1,3,4,6,7,11,16,24,28,29,43,46,47,48,49,50,51,54,55 [gateway_cli] => +917313658604 [cli_prefix] => +91 [channels] => 500 [gateway_pulse] => 30 [gateway_ring_time] => 30 [max_cron] => 10 [gateway_type] => si [isReserve] => 1 [isDedicated] => 1 [create_date] => 1714458679 [create_by] => admin [status] => 1 [isDeleted] => 0 [update_date] => 1715244943 [update_by] => admin [api_owner_id] => admin [total_credits] => 2920402 [total_contacts] => 2507832 [total_compaigns] => 106 [active_credits] => 2507832 [todays_credits] => 130522 [todays_time] => 1715279400 ) ) i am here IN SI Array ( [post_url] => http://103.179.224.115/sarvApi/ [announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1715334942_r42_voice_upload.wav [owner_id] => 100001 [token] => luroekngnkvsaguut7t09439 ) Array ( [post_url] => http://103.179.224.115/sarvApi/ [announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1715334942_r42_voice_upload.wav [owner_id] => 100001 [token] => luroekngnkvsaguut7t09439 ) http://103.179.224.115/sarvApi//upload_announcement.php Array ( [announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1715334942_r42_voice_upload.wav [owner_id] => 100001 [token] => luroekngnkvsaguut7t09439 ) {"status":"success","code":"000","desc":"Announcement Uploaded Successfully","data":{"announcement_name":"1715334942_r42_voice_upload.wav"}} upload annuncment response : {"status":"success","code":"000","desc":"Announcement Uploaded Successfully","data":{"announcement_name":"1715334942_r42_voice_upload.wav"}} gateway size : 1 9646/1 update voice_compaign_summary set alloted_apis='[{"cli":"","g_id":"88"}]', api_type='S', api_channels='500', action_time='{"api_allot_time":1715337940}', common_name='r42_15841_10052024_041540PM_484',`duplicate_sms`='0',`remote_group_id`='0',`remote_recording_id`='0', credits_per_sms='1' WHERE compaign_id='15841' LIMIT 1