Method getProductCanonicalLink

public static function getProductCanonicalLink($id, $catid, $idAlias, $catidAlias, $preferredCatid = 0)
{
    if ((int) $preferredCatid > 0) {
        $db = Factory::getDBO();
        $query = 'SELECT c.id, c.alias' . ' FROM #__phocacart_categories AS c' . ' WHERE c.id = ' . (int) $preferredCatid . ' ORDER BY c.id';
        $db->setQuery($query, 0, 1);
        $catO = $db->loadObject();
        if (isset($catO->id) && isset($catO->alias)) {
            return self::getItemRoute($id, $catO->id, $idAlias, $catO->alias);
        }
    }
    return self::getItemRoute($id, $catid, $idAlias, $catidAlias);
}