Hello, i need to return current_traffic and Current quota from API (web_sites_get _domain). The Api is using : function getDataRecord($primary_id) { and the sql is dynamic. How can i add the two left joins to the current Query ? Do i need to use other function or write the full query in somewere else ? Thanks.
I recommend that you add a new function for querying the monitor_data table which holds the quota information and the web_traffic table which holds the website traffic. The current function shall only return the record from web_domain table so that this record can be used to pass it back directly for updates.
