OpenCart 🇺🇦

$url_info = parse_url(str_replace('&', '&', $link));

$url = ''; 

$data = array();

parse_str($url_info['query'], $data);

foreach ($data as $key => $value) {
	if (isset($data['route'])) {
		if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id')) {
			$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "'");
		
			if ($query->num_rows) {
				$url .= '/' . $query->row['keyword'];
				
				unset($data[$key]);
			}					
		} elseif ($key == 'path') {
			$categories = explode('_', $value);
			
			foreach ($categories as $category) {
				$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = 'category_id=" . (int)$category . "'");
		
				if ($query->num_rows) {
					$url .= '/' . $query->row['keyword'];
				}							
			}
			
			unset($data[$key]);
		}
	}
}

if ($url) {
	unset($data['route']);

	$query = '';

	if ($data) {
		foreach ($data as $key => $value) {
			$query .= '&' . $key . '=' . $value;
		}
		
		if ($query) {
			$query = '?' . trim($query, '&');
		}
	}

	return $url_info['scheme'] . '://' . $url_info['host'] . (isset($url_info['port']) ? ':' . $url_info['port'] : '') . str_replace('/index.php', '', $url_info['path']) . $url . $query;
} else {
	return $link;
}