public function render(Varien_Object $row)
{
$collection = Mage::getModel('catalog/product')->getCollection();
$model = Mage::getModel('catalog/product')->load($row->getProductId());
$product = Mage::getModel('catalog/product')->loadByAttribute('entity_id', $row->getProductId())->getName();
return $product;
}
public function refreshDeal(Varien_Object $_deal)
{
//verify if product is enabled for at least one website
$productStatus = 2;
$storeIds = explode(',', $_deal->getStores());
foreach ($storeIds as $storeId) {
$product = Mage::getModel('catalog/product')->setStoreId($storeId)->load($_deal->getProductId());
if ($product->getStatus() == 1) {
$productStatus = 1;
break;
}
}
//verify if product is in stock and if deal qty is higher than 0
$product = Mage::getModel('catalog/product')->load($_deal->getProductId());
$stockItem = $product->getStockItem();
$inStock = $stockItem->getIsInStock() ? true : false;
if ($attributesArray = $this->checkDealStatus($_deal, $productStatus, $inStock, $product->getTypeId())) {
if ($attributesArray['disable_product']) {
//foreach ($storeIds as $storeId) {
if (Mage::helper('multipledeals')->getMagentoVersion() >= 1324) {
Mage::getSingleton('catalog/product_action')->updateAttributes(array($product->getId()), array('status' => 2), 0);
} else {
Mage::getModel('catalog/product_status')->updateProductStatus($product->getId(), 0, 2);
}
//}
}
$_deal->setStatus($attributesArray['status'])->save();
Mage::app()->getCacheInstance()->cleanType('collections');
if (Mage::getConfig()->getModuleConfig('Enterprise_Enterprise')) {
Mage::getSingleton('enterprise_pagecache/cache')->getCacheInstance()->cleanType('full_page');
}
}
}
/**
* Return the product named URL
*
* @param Varien_Object $row
* @return string
*/
public function render(Varien_Object $row)
{
if ($row->getProductId()) {
$url = Mage::getModel('adminhtml/url')->getUrl('*/catalog_product/edit', array('id' => $row->getProductId()));
return sprintf('<a href="%s">%s</a>', $url, $row->getProductName());
}
return 'NA';
}
public function render(Varien_Object $row)
{
$product_id = $row->getProductId();
return '
<p style="text-align:center"><input type="text" name="qty_' . $row->getProductId() . '" id="qty_' . $row->getProductId() . '" size="15" style="text-align:center" onchange="supplyNeedsGrid.logChange(this.name,\'\')"/></p>
<p style="text-align:center">
<button type="button" name="maxButton" size="7" onclick="calMax(' . $product_id . ')">Auto Fill</button>
</p>
';
}
public function render(Varien_Object $row)
{
$productId = $row->getProductId();
$stockHistoryUrl = $this->getUrl('inventoryreportsadmin/adminhtml_product/chart', array('id' => $productId));
$html = "<a href='' onclick='window.open( " . "\"" . $stockHistoryUrl . "\"" . "," . "\"" . $this->__('Inventory History') . "\"" . "," . "\"" . 'scrollbars=yes, resizable=yes, width=520, height=540, top=50, left=300' . "\"" . "); " . "return false;' target='_blank'>" . $this->__('Inventory History') . '</a> <br/>';
return $html;
}
/**
* Renders grid column
*
* @param Varien_Object $row
* @return string
*/
public function render(Varien_Object $row)
{
$value = '';
if ($barcodeProducts = Mage::getModel('admin/session')->getData('barcode_product_import')) {
foreach ($barcodeProducts as $barcodeProduct) {
if ($barcodeProduct['PRODUCT_ID'] == $row->getProductId()) {
if (isset($barcodeProduct['BARCODE']) && $barcodeProduct['BARCODE']) {
$value = $barcodeProduct['BARCODE'];
}
}
}
}
$checked = 'checked="checked"';
if ($value) {
$checked = '';
}
$html = Mage::helper('inventorybarcode')->__('Auto') . ': <input onclick="setBarcodeAuto(this,\'barcode-' . $row->getId() . '\')" type="checkbox" name="barcode_auto" ' . $checked . ' value="">';
$html .= '<input type="text" ';
$html .= 'id="barcode-' . $row->getId() . '" ';
$html .= 'name="' . $this->getColumn()->getId() . '" ';
$html .= 'value="' . $value . '"';
$html .= 'class="input-text' . $this->getColumn()->getInlineCss() . '" readonly />';
// $html .= '<p class="note" id="note_barcode"><span>'.Mage::helper('inventory')->__('Just [A-Z][a-z][0-9] are allowed').'</span></p>';
return $html;
}
/**
* Prepares and render result of composite product configuration request
*
* $configureResult holds either:
* - 'ok' = true, and 'product_id', 'buy_request', 'current_store_id', 'current_customer' or 'current_customer_id'
* - 'error' = true, and 'message' to show
*
* @param Mage_Adminhtml_Controller_Action $controller
* @param Varien_Object $configureResult
* @return Mage_Adminhtml_Helper_Catalog_Product_Composite
*/
public function renderConfigureResult($controller, Varien_Object $configureResult)
{
try {
if (!$configureResult->getOk()) {
Mage::throwException($configureResult->getMessage());
}
$currentStoreId = (int) $configureResult->getCurrentStoreId();
if (!$currentStoreId) {
$currentStoreId = Mage::app()->getStore()->getId();
}
$product = Mage::getModel('catalog/product')->setStoreId($currentStoreId)->load($configureResult->getProductId());
if (!$product->getId()) {
Mage::throwException($this->__('Product is not loaded.'));
}
Mage::register('current_product', $product);
Mage::register('product', $product);
// Prepare buy request values
$buyRequest = $configureResult->getBuyRequest();
if ($buyRequest) {
Mage::helper('catalog/product')->prepareProductOptions($product, $buyRequest);
}
$isOk = true;
$productType = $product->getTypeId();
} catch (Exception $e) {
$isOk = false;
$productType = null;
Mage::register('composite_configure_result_error_message', $e->getMessage());
}
$this->_initConfigureResultLayout($controller, $isOk, $productType);
$controller->renderLayout();
}
public function render(Varien_Object $row)
{
$columnName = $this->getColumn()->getName();
$columnName = explode('_', $columnName);
if ($columnName[1]) {
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$installer = Mage::getModel('core/resource');
$warehouseId = $columnName[1];
$purchase_order_id = $this->getRequest()->getParam('id');
$sql = 'SELECT qty_delivery from ' . $installer->getTableName("erp_inventory_delivery_warehouse") . ' WHERE (purchase_order_id = ' . $purchase_order_id . ') AND (product_id = ' . $row->getProductId() . ') AND (warehouse_id = ' . $warehouseId . ') AND (sametime = ' . $row->getSametime() . ')';
$results = $readConnection->fetchAll($sql);
$haveDelivery = 0;
foreach ($results as $result) {
if ($result['qty_delivery']) {
$haveDelivery = 1;
echo $result['qty_delivery'];
}
}
if ($haveDelivery == '0') {
echo 0;
}
} else {
parent::render($row);
}
}
public function validate(Varien_Object $object)
{
$product = Mage::getModel('catalog/product')->setStoreId($object->getStoreId())->load($object->getProductId());
$this->_entityAttributeValues[$product->getId()][$product->getStoreId()] = $product->getData($this->getAttribute());
// Required since 1.8.0.0 // Old: $this->getValue() //
#var_dump($this->getAttribute(), $product->getData($this->getAttribute()), parent::validateAttribute($product));
return parent::validate($product);
}
public function render(Varien_Object $row)
{
$img_valid = '';
if ((int) $row->getQtyOrdered() === (int) $row->getQtyShipped()) {
$img_valid = '<img src="' . $this->getSkinUrl('sm/images/barcode_success.gif') . '" width="16px" height="16px" alt="Valid" />';
}
return '<div id="qty-valid-' . $row->getProductId() . '" style="text-align:center;">' . $img_valid . '</div>';
}
public function render(Varien_Object $row)
{
if ($row->getParentItemId()) {
$product = Mage::getModel('sales/order_item')->load($row->getParentItemId());
} else {
$product = Mage::getModel('sales/order_item')->load($row->getItemId());
}
return '<div id="qty-shipped-' . $row->getProductId() . '" style="text-align:center;">' . intval($product->getQtyShipped()) . '</div>';
}
public function render(Varien_Object $row)
{
$product_id = $row->getProductId();
$product = Mage::getModel('catalog/product')->load($product_id);
if ($product->getId()) {
return $product->getName();
} else {
return $row->getProductName();
}
}
public function render(Varien_Object $row)
{
$productId = $row->getProductId();
$product = Mage::getModel('catalog/product')->load($productId);
if (!$product->getId()) {
return $row->getProductName() . '<br/><p class="item-msg error">* This product is not in stock!</p>';
} else {
return parent::render($row);
}
}
/**
* Validate Product Rule Condition
*
* @param Varien_Object $object
*
* @return bool
*/
public function validate(Varien_Object $object)
{
/** @var Mage_Catalog_Model_Product $product */
$product = $object->getProduct();
if (!$product instanceof Mage_Catalog_Model_Product) {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
$product->setQuoteItemQty($object->getQty())->setQuoteItemPrice($object->getPrice())->setQuoteItemRowTotal($object->getBaseRowTotal());
return parent::validate($product);
}
/**
* Validate Product Rule Condition
*
* @param Varien_Object $object
*
* @return bool
*/
public function validate(Varien_Object $object)
{
$product = false;
if ($object->getProduct() instanceof Mage_Catalog_Model_Product && $object->getData($this->getAttribute()) !== null) {
$product = $object->getProduct();
} else {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
$product->setQuoteItemQty($object->getQty())->setQuoteItemPrice($object->getPrice())->setQuoteItemRowTotal($object->getBaseRowTotal());
return parent::validate($product);
}
public function render(Varien_Object $row)
{
$request = Mage::getModel('rma/request')->getCollection()->addFieldToFilter('main_table.status', array('neq' => SM_RMA_Model_Request::STATUS_PENDING_APPROVAL));
$request->getSelect()->join(array('items' => 'sm_rma_items'), 'items.rma_id=main_table.id')->where('items.item_id=' . $row->getId());
$qty_returned = 0;
if ($request->getSize()) {
foreach ($request as $value) {
$qty_returned += intval($value->getQtyToReturn());
}
}
return '<div id="qty-returned-' . $row->getProductId() . '" style="text-align:center;">' . $qty_returned . '</div>';
}
public function render(Varien_Object $row)
{
$str = '';
$productId = $row->getProductId();
$product = Mage::getModel('catalog/product')->load($productId);
if (!$productId) {
$str = 'There is not product available !';
} else {
$str .= '<a href="' . $this->getUrl('adminhtml/catalog_product/edit', array('id' => $product->getEntityId())) . '">' . $product->getName() . '</a></br>';
}
return $str;
}
public function render(Varien_Object $row)
{
$dealId = $row->getProductId();
$str = '';
$deal = Mage::getModel('dailydeal/dailydeal')->load($dealId);
if (!$dealId) {
$str = $this->__('There is no daily deal available!');
} else {
$str .= '<a href="' . $this->getUrl('dailydealadmin/adminhtml_dailydeal/edit/', array('id' => $dealId)) . '">' . $deal->getTitle() . '</a></br>';
}
return $str;
}
public function render(Varien_Object $row)
{
$columnName = $this->getColumn()->getName();
$columnName = explode('_', $columnName);
if ($columnName[1]) {
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$installer = Mage::getModel('core/resource');
$warehouseId = $columnName[1];
$purchase_order_id = $this->getRequest()->getParam('id');
if ($row->getProductId()) {
$producId = $row->getProductId();
} else {
$producId = $row->getEntityId();
}
$sql = 'SELECT `qty_order` from ' . $installer->getTableName("erp_inventory_purchase_order_product_warehouse") . ' WHERE (purchase_order_id = ' . $purchase_order_id . ') AND (product_id = ' . $producId . ') AND (warehouse_id = ' . $warehouseId . ')';
$results = $readConnection->fetchAll($sql);
if (count($results) > 0) {
foreach ($results as $result) {
if (!array_key_exists('qty_order', $result) || array_key_exists('qty_order', $result) && !$result['qty_order']) {
$result['qty_order'] = 0;
}
if ($this->getColumn()->getEditable()) {
echo $result['qty_order'] . '<input name="warehouse_' . $warehouseId . '" class="input-text" type="text" value="' . $result['qty_order'] . '"/>';
} else {
echo $result['qty_order'];
}
}
} else {
$result['qty_order'] = 0;
if ($this->getColumn()->getEditable()) {
echo $result['qty_order'] . '<input name="warehouse_' . $warehouseId . '" class="input-text" type="text" value="' . $result['qty_order'] . '"/>';
} else {
echo $result['qty_order'];
}
}
} else {
parent::render($row);
}
}
/**
* Validate Product Rule Condition
*
* @param Varien_Object $object
* @return bool
*/
public function validate(Varien_Object $object)
{
$product = false;
if ($object->getProduct() instanceof Mage_Catalog_Model_Product) {
$product = $object->getProduct();
} else {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
$product->setQuoteItemSku($object->getSku());
//$newObject = new Varien_Object();
$object->setProduct($product);
return parent::validate($object);
}
public function render(Varien_Object $row)
{
$status = $row->getStatus();
$productId = $row->getProductId();
$url = Mage::helper('adminhtml')->getUrl('adminhtml/catalog_product/edit', array('id' => $productId, 'tab' => 'product_info_tabs_group_49', 'deal' => 1));
if ($status == 3) {
$label = Mage::helper('adminhtml')->__('Add new');
} else {
$label = Mage::helper('adminhtml')->__('Edit');
}
$html = '<a href="' . $url . '">' . $label . '</a>';
return $html;
}
public function render(Varien_Object $row)
{
$html = '';
//require info process
$product_id = $row->getProductId();
$data = Mage::helper('inventorysupplyneeds')->processFilterData();
$dateto = $data['date_to'];
$datefrom = $data['date_from'];
$warehouse = $data['warehouse'];
$outstock_date = Mage::helper('inventorysupplyneeds')->getOutstockDate($product_id, $datefrom, $dateto, $warehouse, $row);
$html .= '<span>' . $outstock_date . '</span>';
return $html;
}
public function render(Varien_Object $row)
{
$productId = $row->getProductId();
$filter = $this->getRequest()->getParam('top_filter');
$helperClass = Mage::helper('inventorysupplyneeds');
$helperClass->setTopFilter($filter);
$warehouseSelected = $helperClass->getWarehouseSelected();
$warehouseSelectedStr = implode(',', $warehouseSelected);
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$sql = 'SELECT IFNULL(SUM(`qty_order` - `qty_received` + `qty_returned`),0) as in_po from ' . $resource->getTableName("inventorypurchasing/purchaseorder_productwarehouse") . ' WHERE (warehouse_id IN (' . $warehouseSelectedStr . ')) AND product_id = ' . $productId;
$results = $readConnection->fetchAll($sql);
return $results[0]['in_po'];
}
/**
* Validate Product Rule Condition
*
* @param Varien_Object $object
*
* @return bool
*/
public function validate(Varien_Object $object)
{
/** @var Mage_Catalog_Model_Product $product */
$product = $object->getProduct();
if (!$product instanceof Mage_Catalog_Model_Product) {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
$product->setQuoteItemQty($object->getQty())->setQuoteItemPrice($object->getPrice())->setQuoteItemRowTotal($object->getBaseRowTotal());
$valid = parent::validate($product);
if (!$valid && $product->getTypeId() == Mage_Catalog_Model_Product_Type_Configurable::TYPE_CODE) {
$children = $object->getChildren();
$valid = $children && $this->validate($children[0]);
}
return $valid;
}
/**
* Validate Product Rule Condition
*
* @param Varien_Object $object
* @return bool
*/
public function validate(Varien_Object $object)
{
$op = $this->getOperator();
$product = false;
if ($object->getProduct() instanceof Mage_Catalog_Model_Product) {
$product = $object->getProduct();
} else {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
$product->setQuoteItemQty($object->getQty())->setQuoteItemPrice($object->getPrice())->setQuoteItemRowTotal($object->getBaseRowTotal());
if (!$product->getData($this->getAttribute()) && ($op != '==' || $op != '!=') && $this->getAttribute() != 'category_ids') {
return false;
}
return parent::validate($product);
}
public function render(Varien_Object $row)
{
if ($row->getEntityId()) {
$id = $row->getEntityId();
} else {
$id = $row->getProductId();
}
$html = '';
$_product = Mage::getModel('catalog/product')->load($id);
try {
$src1 = Mage::helper('catalog/image')->init($_product, 'image')->resize(90);
$html .= '<img src="' . $src1->__toString() . '" />';
} catch (Exception $e) {
}
return $html;
}
public function validate(Varien_Object $object)
{
if ($vendorId = $this->getRule()->getData('vendor_id')) {
$product = false;
if ($object->getProduct() instanceof Mage_Catalog_Model_Product) {
$product = $object->getProduct();
if (!$product || !$product->getData('sm_product_vendor_id')) {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
if ($product->getData('sm_product_vendor_id') != $vendorId) {
return false;
}
}
}
return parent::validate($object);
}
/**
* @param Varien_Object $object
* @return bool
*/
public function validate(Varien_Object $object)
{
// check product type
if ($this->getAttribute() == 'product_type') {
if ($object->getProduct() instanceof Mage_Catalog_Model_Product) {
$product = $object->getProduct();
} else {
$product = Mage::getModel('catalog/product')->load($object->getProductId());
}
if ($product->getTypeId() == $this->getValue()) {
return true;
} else {
return false;
}
}
return parent::validate($object);
}
public function render(Varien_Object $row)
{
//get row order ids
if ($row->getAction()) {
return;
}
$orderIds = $row->getAllOrderId();
$filter = 'orderids=' . $orderIds;
$filter = base64_encode($filter);
$orderUrl = Mage::helper("adminhtml")->getUrl('adminhtml/inr_sales/orders', array('top_filter' => $filter, "_secure" => Mage::app()->getStore()->isCurrentlySecure()));
$html = "<a href='' onclick='window.open( " . "\"" . $orderUrl . "\"" . "," . "\"" . $this->__('_blank') . "\"" . "," . "\"" . 'scrollbars=yes, resizable=yes, width=1000, height=600, top=50, left=300' . "\"" . "); return false;' target='_blank'>" . $this->__('View Orders List') . "</a>";
if ($this->getColumn()->getGrid()->isSalesSKUReport()) {
$productId = $row->getProductId();
$stockHistoryUrl = $this->getUrl('adminhtml/inr_product/chart', array('id' => $productId));
$html = "<a href='' onclick='window.open( " . "\"" . $stockHistoryUrl . "\"" . "," . "\"" . $this->__('Stock History') . "\"" . "," . "\"" . 'scrollbars=yes, resizable=yes, width=520, height=540, top=50, left=300' . "\"" . "); " . "return false;' target='_blank'>" . $this->__('Stock History') . '</a> <br/>' . $html;
}
return $html;
}
public function render(Varien_Object $row)
{
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$product_id = $row->getProductId();
$supplier_products = $readConnection->fetchAll("SELECT `supplier_id`,`cost` FROM `" . $resource->getTableName('inventorypurchasing/supplier_product') . "` WHERE (product_id = {$product_id})");
$strings = array();
foreach ($supplier_products as $supplier_product) {
$supplier_id = $supplier_product['supplier_id'];
$cost = (double) $supplier_product['cost'];
$supplier_name = $readConnection->fetchAll("SELECT `supplier_name` FROM `" . $resource->getTableName('inventorypurchasing/supplier') . "` WHERE (supplier_id = {$supplier_id})");
$name = $supplier_name[0]['supplier_name'];
$url = Mage::helper('adminhtml')->getUrl('inventorypurchasingadmin/adminhtml_supplier/edit', array('id' => $supplier_id));
$string = "<a href=" . $url . ">" . $name . "</a> - Cost price: \$" . round($cost, 2);
$strings[] = $string;
}
$supplier_string = implode('<br/>', $strings);
return $supplier_string;
}
