whmcsDNSManager/modules/addons/DNSManager2/helpers/WHMCS/Service.php

<?php

namespace MGModule\DNSManager2\helpers\WHMCS;

use MGModule\DNSManager2\mgLibs\MySQL\query;

/**
 * Class Service
 *
 * @author Artur Pilch <artur.pi@modulesgarden.com>
 */
class Service
{
    CONST CANCELED = 'Cancelled';
    CONST TERMINATED = 'Terminated';
    CONST SUSPENDED = 'Suspended';
    CONST ACTIVE = 'Active';

    public static function getServicesStatusesAvailableToDelete()
    {
        return [
            SELF::CANCELED,
            SELF::SUSPENDED,
            SELF::TERMINATED,
        ];
    }

    public static function getServicesAsDomainKey()
    {
        return query::query('SELECT domain, userid, domainstatus FROM tblhosting')->fetchGroup();
    }
}