public function render(Varien_Object $row) { $supplierHistoryId = $row->getSupplierHistoryId(); // $url = $this->getUrl('inventorypurchasingadmin/adminhtml_supplier/showhistory'); return '<p style="text-align:center"><a name="url" href="javascript:void(0)" onclick="showhistory(' . $supplierHistoryId . ')">' . Mage::helper('inventorypurchasing')->__('View') . '</a></p>'; // <script type="text/javascript"> // function showhistory(supplierHistoryId){ // var supplierHistoryId = supplierHistoryId ; // var url = "'.$url.'supplierHistoryId/"+supplierHistoryId ; // TINY.box.show(url,1, 800, 400, 1); // } // </script> }
public function render(Varien_Object $row) { $supplierHistoryId = $row->getSupplierHistoryId(); $resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $sql = 'SELECT distinct(`field_name`) from ' . $resource->getTableName("erp_inventory_supplier_history_content") . ' WHERE (supplier_history_id = ' . $supplierHistoryId . ')'; $results = $readConnection->fetchAll($sql); $content = ''; foreach ($results as $result) { $content .= $result['field_name'] . '<br />'; } return $content; }