SELECT * FROM `voice_compaign_summary` WHERE status='V' AND alloted_apis='' AND occupied=0 AND compaign_id='45950' LIMIT 1
user dedicated gateway
Array
(
)
user gatway is empty
isReserved : 0
SELECT id FROM `voice_gateways` WHERE FIND_IN_SET ('8', `voice_plan_id`) AND isDedicated=0 AND isReserve=0 AND status=1 AND isDeleted=0 AND api_owner_id='admin' ORDER BY todays_credits/channels
plan gateways
Array
(
[0] => 174
[1] => 173
)
1
Array
(
[0] => 7447143462
)
match gateway according cli
Array
(
[174] => Array
(
[0] => 7447143462
)
[173] => Array
(
[0] => 7447143462
)
)
find gateway
Array
(
[7447143462] => 174
)
XXXXXXXXXXXXXXXXXXX-----------BELOW GATEWAY DETAIL xxxxxxxxxxxxxxxxxxxxxxxxArray
(
[174] => Array
(
[id] => 174
[gateway_id] => 174
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
[post_url] => http://42.104.82.91/sarvApi/
[speed_per_minute] => 200000
[rabitmq_host] => 42.104.82.91
[rabitmq_port] => 5673
[rabitmq_user] => noderabbit
[rabitmq_pass] => saf8777JJKk76KK
[rabitmq_sending_queue] => QCall_vOBD40_174
[rabitmq_reporting_queue] => QReport_vOBD40_174
[rabitmq_queue_status] => 1
[create_date] => 1737534484
[create_by] => admin
[update_date] => 1737534543
[update_by] => admin
)
)
XXXXXXXXXXXXXXXXXXX-----------BELOW GATEWAY INFO xxxxxxxxxxxxxxxxxxxxxxxxArray
(
[174] => Array
(
[id] => 174
[name] => V91-Trans_Dedicated-02
[voice_plan_id] => 5,8,15,37,45
[gateway_cli] => 07447141565
[cli_prefix] => 0
[channels] => 500
[gateway_pulse] => 30
[gateway_ring_time] => 30
[max_cron] => 10
[gateway_type] => si
[isReserve] => 0
[isDedicated] => 0
[create_date] => 1737534484
[create_by] => admin
[status] => 1
[isDeleted] => 0
[update_date] => 1753782135
[update_by] => admin
[api_owner_id] => admin
[total_credits] => 19436
[total_contacts] => 19184
[total_compaigns] => 52
[active_credits] => 19184
[todays_credits] => 261
[todays_time] => 1757010600
)
)
i am here
IN SI
Array
(
[post_url] => http://42.104.82.91/sarvApi/
[announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1754471962_u665_voice_.wav
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
)
Array
(
[post_url] => http://42.104.82.91/sarvApi/
[announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1754471962_u665_voice_.wav
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
)
http://42.104.82.91/sarvApi//upload_announcement.php
Array
(
[announcement_path] => https://obd40.sarv.com/raws/inboxcart_nfsserver/voice_files/1754471962_u665_voice_.wav
[owner_id] => 100001
[token] => luroekngnkvsaguut7t09439
)
{"status":"success","code":"000","desc":"Announcement Uploaded Successfully","data":{"announcement_name":"1754471962_u665_voice_.wav"}}
upload annuncment response : {"status":"success","code":"000","desc":"Announcement Uploaded Successfully","data":{"announcement_name":"1754471962_u665_voice_.wav"}}
gateway size : 1
164/1
update voice_compaign_summary set alloted_apis='[{"cli":7447143462,"g_id":174}]', api_type='S', api_channels='500', action_time='{"api_allot_time":1757068329}', common_name='u665_45950_05092025_040209PM_169',`duplicate_sms`='0',`remote_group_id`='0',`remote_recording_id`='0', credits_per_sms='1' WHERE compaign_id='45950' LIMIT 1