How do you create a link to BOTH the product frontend and backend from the sales order page?

Question

We are looking to create a link to the frontend of a product and the backend of a product from the "items ordered" area of the sales order page. We have the code to create both, but not from the same section. By this we mean we can't combine them into the same column/area, For example we have:

Frontend:

    <td>
        <?php if ($this->canDisplayContainer()): ?>
        <div id="<?php echo $this->getHtmlId() ?>" class="item-container">
        <?php endif; ?>
        <div class="item-text">
<?php $_pullProduct = Mage::getModel('catalog/product')->loadByAttribute('sku', $_item->getData('sku')); ?>
<a target="_blank" rel="external" href="<?php echo Mage::getUrl() . $_pullProduct->getData('url_path'); ?>"><?php echo $this->getColumnHtml($_item, 'name') ?></a>
</div>
        <?php if ($this->canDisplayContainer()): ?>
        </div>
        <?php endif ?>
    </td>

And for the backend:

<td>
        <?php if ($this->canDisplayContainer()): ?>
        <div id="<?php echo $this->getHtmlId() ?>" class="item-container">
        <?php endif; ?>
        <div class="item-text">
<?php $_pullProduct = Mage::getModel('catalog/product')->loadByAttribute('sku', $_item->getData('sku')); ?>
<a target="_blank" rel="external" href="<?php echo Mage::helper('adminhtml')->getUrl('adminhtml/catalog_product/edit', array('id' => $_pullProduct->getId()))?>"><?php echo $this->getColumnHtml($_item, 'name') ?></a>
</div>
        <?php if ($this->canDisplayContainer()): ?>
        </div>
        <?php endif ?>
    </td>

Can this code be combined to create a link to the frontend from the product name, and a link to the product backend from the SKU?

We would ideally like to create a small module or file to override the default configuration in Magento so the code is not overwritten in future updates.

Answer 1

You can get the url for frontend like this:

$_pullProduct = Mage::getModel('catalog/product')->load($_item->getProductId());
if ($_pullProduct->getId()) { //if the product still exists
    $url = $_pullProduct->getProductUrl();
}
else {
    $url = false; //product does not exist anymore
}

For backend try this

$_pullProduct = Mage::getModel('catalog/product')->load($_item->getProductId());
if ($_pullProduct->getId()) { //if the product still exists
    $url = Mage::helper('adminhtml')->getUrl('adminhtml/catalog_product/edit', array('id'=>$_pullProduct->getId()));
}
else {
    $url = false; //product does not exist anymore
}

Note:
The backend url works only if you call this code from the backend or if you disable the session key in url (but you shouldn't do that).