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; }