[ACE-722] Review SRD API getGponDesignParameters Created: 10/Mar/26  Updated: 15/May/26  Due: 17/Mar/26  Resolved: 11/May/26

Status: Rejected
Project: ACE
Component/s: SRD
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Mbaye Lo Assignee: Mbaye Lo
Resolution: Not Fixed Votes: 0
Labels: Milestone2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File ACE-722.PNG     PNG File Untitled.png     PNG File Untitled.png    
Customer:
OMAN-Tel
Planned Start:
Planned End:
Product: NEP
Rejected By: Zein Trabelsi

 Description   

Review SRD API getGponDesignParameters
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.internal.api.srd.nep.mobinets.com/">
<soapenv:Header/>
<soapenv:Body>
<ser:getGponDesignParameters>
<!-Optional:->
<requestId>mb011</requestId>
<!-Optional:->
<serviceName>1319442_FBB</serviceName>
</ser:getGponDesignParameters>
</soapenv:Body>
</soapenv:Envelope>



 Comments   
Comment by Ayed Bada [ 30/Mar/26 ]

The API is working correctly. In this example, it returns a default response.

To get a real (non-default) response, please execute the following query:
SELECT
sm.request_id,
sbi.MILESTONE_ID
FROM
SRD_MILESTONE sm
INNER JOIN
SRD_MILESTONE_PROFILE sbi
ON sm.id = sbi.MILESTONE_ID
WHERE
sm.DTYPE = 'GPON';
This will provide a list of request_id values that can be used for testing and should return non-default data.

Please also refer to the attached screenshot, where I tested this in my local environment.

Comment by Mbaye Lo [ 11/May/26 ]

Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI

Comment by Zein Trabelsi [ 15/May/26 ]

What it does:
Returns GPON design parameters (total cost, distance to exchange, vendor, exchange list)
by reading the GPON Milestone profiles for the given requestId.

Find valid requestId from DB:
SELECT m.REQUEST_ID, SUM(p.COST), COUNT(p.ID)
FROM SRD_MILESTONE m
JOIN SRD_MILESTONE_PROFILE p ON p.MILESTONE_ID = m.ID
WHERE m.DTYPE = 'GPON' GROUP BY m.REQUEST_ID HAVING COUNT(p.ID) > 0;

UI Check: Open request id → GPON Milestone tab.
Values shown should match the aggregated API response.

see attached screenshots

Generated at Mon Jun 15 15:58:55 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.