Make a menu link from admin product list to frontpage

Code: Select all

$this->data['products'][] = array(
	'product_id' => $result['product_id'],
	'name'       => $result['name'],
         ..................................
        'front_product_url' => HTTP_CATALOG . $result['keyword'],               
	'action'     => $action
);

Code: Select all

<a href="<?php echo $product['front_product_url']; ?>" target="_blank"> View product in front store </a>

Code: Select all

private function getProductKeyword($product_id) {
     $sql = "SELECT keyword FROM " . DB_PREFIX . "url_alias WHERE query = 'product_id=" . (int)$product_id . "'";
     $query = $this->db->query($sql);
    
     if ($query->num_rows) {
         return $query->row['keyword'];
     }

     return false;
}

public function getProductFrontURL($product_id) {
     $keyword = $this->getProductKeyword($product_id);

     $product_url = HTTP_CATALOG;

     if ($keyword) {
         $product_url .= $keyword;
     } else {
         $product_url .= 'index.php?route=product/product&product_id=' . $product_id;
     }
     
     return $product_url;
}