/**
* Services
* Get all the services attached to the domain.
* @return array
*/
public static function Services($domainID)
{
$items = array();
if (isset($domainID) && is_numeric($domainID)) {
$services = OrdersItemsDomains::find_by_domain_id($domainID, "oid.relationship_id,oi.detail_id, p.product_id, pd.name, DATE_FORMAT(oi.date_start, '" . Settings::getMySQLDateFormat('dateformat') . "') as date_start, DATE_FORMAT(oi.date_end, '" . Settings::getMySQLDateFormat('dateformat') . "') as date_end", true);
if (isset($services[0])) {
$i = 0;
foreach ($services as $service) {
$items[$i]['service_id'] = $service['OrdersItems']['detail_id'];
$items[$i]['fromdate'] = $service['OrdersItems']['date_start'];
$items[$i]['todate'] = $service['OrdersItems']['date_end'];
$items[$i]['service'] = $service['OrdersItems']['Products']['ProductsData'][0]['name'];
$i++;
}
return $items;
}
}
}
