/** * Retourne le du produit courant * * @return unknown */ public function getProduct() { if ($this->_product == null) { $this->_product = mage::getModel('catalog/product')->load($this->_productId); } return $this->_product; }
/** * check password * */ private function checkPassword() { $password = $this->getRequest()->getParam('password'); if ($password != mage::getStoreConfig('clientcomputer/general/password')) { die('Access denied'); } }
/** * Function to update waybill if order tracking is of Delhivery Lastmile */ public function sales_shipment_add_tracking($observer) { $track = $observer->getEvent()->getTrack(); $order = $track->getShipment()->getOrder(); $shippingMethod = $order->getShippingMethod(); // String in format of 'carrier_method' if (!$shippingMethod) { return; } // Process only Delhivery Lastmile methods if ($track->getCarrierCode() != 'dlastmile') { return; } //mage::log($track->getNumber()); //mage::log($track->getCarrierCode()); $model = Mage::getModel('lastmile/lastmile'); $awbobj = $model->loadByAwb($track->getNumber()); $data = array(); $status = 'Assigned'; $data['state'] = 1; $data['status'] = "Assigned"; $data['orderid'] = $order->getId(); $data['shipment_to'] = $order->getShippingAddress()->getName(); $data['shipment_id'] = $track->getShipment()->getIncrementId(); mage::log($data); $model->setData($data); $model->setId($awbobj); $model->save(); return; }
protected function _prepareForm() { $model = mage::registry('pdfgenerator_template'); $form = new Varien_Data_Form(); $fieldset = $form->addFieldset('general_fieldset', array('legend' => Mage::helper('pdfgenerator')->__('Template Information'), 'class' => 'fieldset')); $fieldset->addField('orig_template_variables', 'hidden', array('name' => 'orig_template_variables')); $fieldset->addField('variables', 'hidden', array('name' => 'variables', 'value' => Zend_Json::encode($this->getVariables()))); $fieldset->addField('template_variables', 'hidden', array('name' => 'template_variables')); /* * We will use this when needed. */ $insertVariableButton = $this->getLayout()->createBlock('adminhtml/widget_button', '', array('type' => 'button', 'label' => Mage::helper('pdfgenerator')->__('Insert Variable...'), 'onclick' => 'MagentovariablePlugin.loadChooser(\'' . $this->getVariablesWysiwygActionUrl() . '\', \'pdft_filename\');')); $fieldset->addField('insert_variable', 'note', array('text' => $insertVariableButton->toHtml())); $fieldset->addField('pdft_filename', 'text', array('name' => 'pdft_filename', 'label' => Mage::helper('pdfgenerator')->__('File Name'), 'required' => true)); $fieldset->addField('pdftp_format', 'select', array('label' => Mage::helper('pdfgenerator')->__('Page format'), 'title' => Mage::helper('pdfgenerator')->__('Page format'), 'name' => 'pdftp_format', 'required' => true, 'options' => array('5' => Mage::helper('pdfgenerator')->__('Legal'), '4' => Mage::helper('pdfgenerator')->__('Letter'), '3' => Mage::helper('pdfgenerator')->__('A6'), '2' => Mage::helper('pdfgenerator')->__('A5'), '1' => Mage::helper('pdfgenerator')->__('A3'), '0' => Mage::helper('pdfgenerator')->__('A4')))); $fieldset->addField('pdftc_customchek', 'select', array('label' => Mage::helper('pdfgenerator')->__('Custom format'), 'name' => 'pdftc_customchek', 'options' => array('1' => Mage::helper('pdfgenerator')->__('Yes'), '0' => Mage::helper('pdfgenerator')->__('No')), 'onclick' => "", 'onchange' => "", 'disabled' => false)); $fieldset->addField('pdft_customwidth', 'text', array('name' => 'pdft_customwidth', 'class' => 'validate-zero-or-greater', 'label' => Mage::helper('pdfgenerator')->__('Width (mm)'), 'required' => false)); $fieldset->addField('pdft_customheight', 'text', array('name' => 'pdft_customheight', 'class' => 'validate-zero-or-greater', 'label' => Mage::helper('pdfgenerator')->__('Height (mm)'), 'required' => false)); $fieldset->addField('pdft_orientation', 'select', array('label' => Mage::helper('pdfgenerator')->__('Page orientation'), 'title' => Mage::helper('pdfgenerator')->__('Page orientation'), 'name' => 'pdft_orientation', 'required' => true, 'options' => array('portrait' => Mage::helper('pdfgenerator')->__('Portrait'), 'landscape' => Mage::helper('pdfgenerator')->__('Landscape')))); $fieldset->addField('pdftm_top', 'text', array('name' => 'pdftm_top', 'class' => 'validate-greater-than-zero', 'label' => Mage::helper('pdfgenerator')->__('Top (mm)'), 'required' => true)); $fieldset->addField('pdftm_bottom', 'text', array('name' => 'pdftm_bottom', 'class' => 'validate-greater-than-zero', 'label' => Mage::helper('pdfgenerator')->__('Bottom (mm)'), 'required' => true)); $fieldset->addField('pdftm_left', 'text', array('name' => 'pdftm_left', 'class' => 'validate-greater-than-zero', 'label' => Mage::helper('pdfgenerator')->__('Left (mm)'), 'required' => true)); $fieldset->addField('pdftm_right', 'text', array('name' => 'pdftm_right', 'class' => 'validate-greater-than-zero', 'label' => Mage::helper('pdfgenerator')->__('Right (mm)'), 'required' => true)); $form->setValues($model->getData()); $this->setForm($form); return parent::_prepareForm(); }
public function render(Varien_Object $row) { //retrieve information $productId = $this->getColumn()->getproduct_id(); $collection = mage::getModel('sales/order_item')->getCollection()->addFieldToFilter('order_id', $row->getId())->addFieldToFilter('product_id', $productId); //return value $retour = 0; switch ($this->getColumn()->getfield_name()) { case 'ordered_qty': foreach ($collection as $item) { $retour += (int) $item->getqty_ordered(); } break; case 'shipped_qty': foreach ($collection as $item) { $retour += (int) $item->getRealShippedQty(); } break; case 'remaining_qty': foreach ($collection as $item) { $retour += $item->getRemainToShipQty(); } break; case 'reserved_qty': foreach ($collection as $item) { $retour += (int) $item->getreserved_qty(); } break; } if ($retour == '') { $retour = '0'; } return $retour; }
/** * Load product collection Id(s) * */ public function load() { //Charge les commandes fournisseur $this->_collection = mage::getModel('Purchase/SupplyNeeds')->getCollection()->setOrder('sn_id', 'asc'); //Affiche le nombre de commande chargée $this->addException(Mage::helper('dataflow')->__('Loaded %s rows', $this->_collection->getSize()), Mage_Dataflow_Model_Convert_Exception::NOTICE); }
/** * Retourne le produit concerné * * @param unknown_type $value */ public function getProduct() { if ($this->_product == null) { $this->_product = mage::getModel('catalog/product')->load($this->getRequest()->getParam('product_id')); } return $this->_product; }
protected function _getLevels() { if (!$this->_levels) { $this->_levels = mage::getModel('ebayenterprise_magelog/system_config_source_log_levels'); } return $this->_levels; }
/** * Return rewrite class info * * @return unknown */ public function getRewriteClassesInformation() { if ($this->_rewriteClassesInformation == null) { $this->_rewriteClassesInformation = array(); $t = explode(',', $this->getec_rewrite_classes()); foreach ($t as $class) { //collect main information $class = trim($class); $classArray = array(); $classArray['class'] = $class; $classInfo = explode('_', $class); $classArray['editor'] = trim($classInfo[0]); $classArray['module'] = trim($classInfo[1]); //collect config.xml file path $classArray['config_file_path'] = mage::helper('ExtensionConflict/Extension')->getConfigFilePath($classArray['editor'], $classArray['module']); //collect class path $classArray['class_path'] = mage::helper('ExtensionConflict/Extension')->getClassPath($class); //collect class declaration $classArray['class_declaration'] = mage::helper('ExtensionConflict/Extension')->getClassDeclaration($class); //collect new class declaration $classArray['new_class_declaration'] = 'class ' . $class . ' extends '; $this->_rewriteClassesInformation[] = $classArray; } } return $this->_rewriteClassesInformation; }
public function getOrder() { if ($this->_order == null) { $this->_order = mage::getModel('Purchase/Order')->load($this->getRequest()->getParam('po_num')); } return $this->_order; }
/** * Refresh list * */ public function RefreshList() { //truncate table Mage::getResourceModel('ExtensionConflict/ExtensionConflict')->TruncateTable(); //retrieve all config.xml $tConfigFiles = $this->getConfigFilesList(); //parse all config.xml $rewrites = array(); foreach ($tConfigFiles as $configFile) { $rewrites = $this->getRewriteForFile($configFile, $rewrites); } //insert in database foreach ($rewrites as $key => $value) { $t = explode('/', $key); $moduleName = $t[0]; $className = $t[1]; $record = mage::getModel('ExtensionConflict/ExtensionConflict'); $record->setec_core_module($moduleName); $record->setec_core_class($className); $rewriteClasses = join(', ', $value); $record->setec_rewrite_classes($rewriteClasses); if (count($value) > 1) { $record->setec_is_conflict(1); } $record->save(); } }
public function addAction() { $response = array(); if (!Mage::getStoreConfigFlag('wishlist/general/active')) { $response['status'] = 'ERROR'; $response['message'] = $this->__('Wishlist Has Been Disabled By Admin'); } if (!Mage::getSingleton('customer/session')->isLoggedIn()) { $response['status'] = 'ERROR'; $response['message'] = $this->__('Please Login First'); } if (empty($response)) { $session = Mage::getSingleton('customer/session'); $wishlist = $this->_getWishlist(); if (!$wishlist) { $response['status'] = 'ERROR'; $response['message'] = $this->__('Unable to Create Wishlist'); } else { $productId = (int) $this->getRequest()->getParam('product'); if (!$productId) { $response['status'] = 'ERROR'; $response['message'] = $this->__('Product Not Found'); } else { $product = Mage::getModel('catalog/product')->load($productId); if (!$product->getId() || !$product->isVisibleInCatalog()) { $response['status'] = 'ERROR'; $response['message'] = $this->__('Cannot specify product.'); } else { try { $requestParams = $this->getRequest()->getParams(); $buyRequest = new Varien_Object($requestParams); $result = $wishlist->addNewItem($product, $buyRequest); if (is_string($result)) { Mage::throwException($result); } $wishlist->save(); Mage::dispatchEvent('wishlist_add_product', array('wishlist' => $wishlist, 'product' => $product, 'item' => $result)); Mage::helper('wishlist')->calculate(); $message = $this->__('%1$s has been added to your wishlist.', $product->getName()); $response['status'] = 'SUCCESS'; $response['message'] = $message; Mage::unregister('wishlist'); $this->loadLayout(); $response['toplink'] = $this->getLayout()->getBlock('top.links')->toHtml(); $response['sidebar'] = $this->getLayout()->getBlock('wishlist_sidebar')->toHtml(); } catch (Mage_Core_Exception $e) { $response['status'] = 'ERROR'; $response['message'] = $this->__('An error occurred while adding item to wishlist: %s', $e->getMessage()); } catch (Exception $e) { mage::log($e->getMessage()); $response['status'] = 'ERROR'; $response['message'] = $this->__('An error occurred while adding item to wishlist.'); } } } } } $this->_sendJson($response); return; }
/** * Set stocks updated to 1 for canceled orders * */ public function cleanCanceledOrders() { $collection = mage::getModel('sales/order')->getCollection()->addFieldToFilter('stocks_updated', 0)->addAttributeToFilter('status', 'canceled'); foreach ($collection as $order) { $order->setstocks_updated(1)->save(); } }
public function render(Varien_Object $row) { //recupere les infos $orderItem = $row; $value = $orderItem->getreserved_qty(); //recupere le produit $product = mage::getModel('catalog/product')->load($orderItem->getproduct_id()); //si le produit ne gere pas les stocks if ($product->getStockItem()->getManageStock()) { if ($orderItem->getqty_ordered() - $orderItem->getRealShippedQty() == 0) { $retour = $this->__('Shipped'); } else { //si la qté est suffisante pour réserver ou déja réservé if ($product->CanReserveQty($orderItem->getqty_ordered()) || $value == $orderItem->getqty_ordered()) { if ($value > 0) { $checked = " checked "; } else { $checked = ""; } $retour = "<input type=\"checkbox\" name=\"qty_reserved_" . $orderItem->getId() . "\" values=\"1\" {$checked}>"; } else { $retour = "<font color=\"red\">" . $this->__('Stock Insufficient') . "</font>"; } } } else { $retour = "<font color=\"red\">" . $this->__('No Stock Management') . "</font>"; } //retourne return $retour; }
public function GetOrderPaymentValidatedAttributeId() { if ($this->_OrderPaymentValidatedAttributeId == null) { $this->_OrderPaymentValidatedAttributeId = mage::getModel('eav/entity_attribute')->loadByCode('order', 'payment_validated')->getId(); } return $this->_OrderPaymentValidatedAttributeId; }
/** * Return real shipped qty for an item * Welcome in magento..... * * @param unknown_type $item */ public function getRealShippedQtyForItem($item) { //init vars $qty = $item->getQty(); $orderItem = $item->getOrderItem(); $orderItemParentId = $orderItem->getparent_item_id(); //define if we have to multiply qty by parent qty $mustMultiplyByParentQty = false; if ($orderItemParentId > 0) { $parentOrderItem = mage::getmodel('sales/order_item')->load($orderItemParentId); if ($parentOrderItem->getId()) { //if shipped together if ($parentOrderItem->getproduct_type() == 'bundle' && !$parentOrderItem->isShipSeparately()) { $mustMultiplyByParentQty = true; $qty = $orderItem->getqty_ordered() / $parentOrderItem->getqty_ordered(); } } } //if multiply by parent qty if ($mustMultiplyByParentQty) { $parentShipmentItem = null; foreach ($item->getShipment()->getAllItems() as $ShipmentItem) { if ($ShipmentItem->getorder_item_id() == $orderItemParentId) { $parentShipmentItem = $ShipmentItem; } } if ($parentShipmentItem) { $qty = $qty * $parentShipmentItem->getQty(); } } return $qty; }
public function changeQty($observer) { $event = $observer->getEvent(); // $observer->getData(); // $quoteItem = $observer->getQuoteItem(); $model = Mage::getModel('itdelight_first/quantity'); $model->getCollection(); // Zend_Debug::dump($observer); // die; // $observer->getData('cart')->getData(); // $observer->getData('cart')->getData('quote')->setData(array('cart_qty'=>'20')); // $_POST['qty'] = "4"; // Zend_Debug::dump($_POST); // $quoteItem = $observer->getEvent()->getQuoteItem()->setQty('15'); try { $quoteItem = $observer->getQuoteItem(); if (is_null($quoteItem->getParentItem())) { $qty_my = $quoteItem->getQty(); $qty = $qty_my * 2; $quoteItem->setQty($qty); $quoteItem->setQtyToAdd($qty); } else { $qty_my = $quoteItem->getParentItem()->getQty(); $qty = $qty_my * 2; $quoteItem->getParentItem()->setQty($qty); $quoteItem->getParentItem()->setQtyToAdd($qty); } } catch (Exception $e) { mage::logException($e); } }
/** * Hook to record all fron controller events * @param Varien_Event_Observer $observer */ public function controller_action_predispatch(Varien_Event_Observer $observer) { try { if (extension_loaded('newrelic')) { $controllerAction = $observer->getControllerAction(); $request = $controllerAction->getRequest(); $controllerName = explode("_", $request->getControllerName()); if (Mage::getStoreConfig('newrelic/settings/ignore_admin_routes') && $request->getRouteName() == 'adminhtml' || $request->getModuleName() == 'admin' || in_array('adminhtml', $controllerName)) { Mage::Helper('newrelic')->setAppName(false); newrelic_ignore_transaction(); newrelic_ignore_apdex(); return $this; } if (mage::helper('newrelic')->ignoreModule($request->getModuleName()) === true) { Mage::Helper('newrelic')->setAppName(false); newrelic_ignore_transaction(); newrelic_ignore_apdex(); return $this; } if (Mage::getStoreConfig('newrelic/settings/named_transactions')) { $route = $request->getRouteName() . '/' . $request->getControllerName() . '/' . $request->getActionName(); if (Mage::getStoreConfig('newrelic/settings/add_module_to_named_transactions')) { $route .= ' (module: ' . $request->getModuleName() . ')'; } newrelic_name_transaction($route); Mage::Helper('newrelic')->setAppName(true); return $this; } } } catch (Exception $e) { mage::logException($e); } }
/** * * * @return Mage_Catalog_Model_Product */ public function getSupplier() { if ($this->_supplier == null) { $this->_supplier = mage::getModel('Purchase/Supplier')->load($this->getRequest()->getParam('sup_id')); } return $this->_supplier; }
/** * Load product collection Id(s) * */ public function load() { //Charge les commandes fournisseur $this->_collection = mage::getModel('Orderpreparation/ordertoprepareitem')->getCollection()->join('sales/order_item', 'order_item_id=item_id'); //Affiche le nombre de commande chargée $this->addException(Mage::helper('dataflow')->__('Loaded %s rows', $this->_collection->getSize()), Mage_Dataflow_Model_Convert_Exception::NOTICE); }
/** * Load product collection Id(s) * */ public function load() { //Charge les commandes fournisseur $this->_collection = mage::getModel('Purchase/OrderProduct')->getCollection()->join('catalog/product', 'pop_product_id=entity_id')->setOrder('pop_order_num', 'asc'); //Affiche le nombre de commande chargée $this->addException(Mage::helper('dataflow')->__('Loaded %s rows', $this->_collection->getSize()), Mage_Dataflow_Model_Convert_Exception::NOTICE); }
public function getGroup() { if ($this->_group == null) { $this->_group = mage::getResourceModel('BackgroundTask/Taskgroup')->loadByGroupCode($this->_groupCode); } return $this->_group; }
/** * Return shipping delay for carrier * */ public function getShippingDelayForCarrier($ShippingMethod, $Country) { $return = Mage::getStoreConfig('planning/delivery/default_shipping_delay'); //define carrier $Carrier = ''; $t = explode('_', $ShippingMethod); if (count($t) > 0) { $Carrier = $t[0]; } //load shipping delay for carrier $item = mage::getModel('Purchase/ShippingDelay')->load($Carrier, 'psd_carrier'); if ($item->getId()) { $return = $item->getpsd_default(); //check in exceptions if ($item->getpsd_exceptions() != '') { $exceptions = explode(',', $item->getpsd_exceptions()); for ($i = 0; $i < count($exceptions); $i++) { $values = explode(':', $exceptions[$i]); if (count($values) == 2) { if ($Country == $values[0]) { $return = $values[1]; } } } } } return $return; }
/** * Retourne le dernier prix d'achat sans frais d'approche pour un produit * * @param unknown_type $ProductId */ public function GetLastPriceWithoutFees($ProductId) { $sql = 'select pop_price_ht_base from ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'purchase_order_product, ' . mage::getModel('Purchase/Constant')->getTablePrefix() . 'purchase_order where pop_order_num = po_num and po_status = \'' . MDN_Purchase_Model_Order::STATUS_COMPLETE . '\' and pop_price_ht_base > 0 and pop_product_id = ' . $ProductId . ' order by po_num DESC LIMIT 1'; $retour = mage::getResourceModel('sales/order_item_collection')->getConnection()->fetchOne($sql); $retour = number_format($retour, 2); return $retour; }
protected function _prepareForm() { $form = new Varien_Data_Form(); $this->setForm($form); $fieldset = $form->addFieldset('abrands_form', array('legend' => Mage::helper('abrands')->__('Item information'))); $attribute = Mage::getModel('eav/entity_attribute')->getCollection()->addFieldToFilter('attribute_code', Mage::getStoreConfig('mpanel/catalog/brands')); $code = array(); foreach ($attribute as $item) { $code[$item->getAttributeCode()] = $item->getFrontendLabel(); } $fieldset->addfield('name_attr', 'select', array('label' => mage::helper('abrands')->__('Attribute'), 'name' => 'name_attr', 'values' => $code, 'onchange' => 'showOptions()')); $fieldset->addfield('option_id', 'select', array('label' => mage::helper('abrands')->__('Option'), 'name' => 'option_id', 'values' => '', 'onchange' => 'getOptionText()')); $fieldset->addfield('title', 'hidden', array('name' => 'title')); $fieldset->addField('filename', 'file', array('label' => Mage::helper('abrands')->__('File'), 'required' => false, 'name' => 'filename')); $fieldset->addField('content', 'text', array('name' => 'content', 'label' => Mage::helper('abrands')->__('Link'), 'title' => Mage::helper('abrands')->__('Link'), 'required' => false)); $fieldset->addField('status', 'select', array('label' => Mage::helper('abrands')->__('Status'), 'name' => 'status', 'values' => array(array('value' => 1, 'label' => Mage::helper('abrands')->__('Enabled')), array('value' => 2, 'label' => Mage::helper('abrands')->__('Disabled'))))); /* $fieldset->addField('content', 'editor', array( 'name' => 'content', 'label' => Mage::helper('abrands')->__('Content'), 'title' => Mage::helper('abrands')->__('Content'), 'style' => 'width:700px; height:500px;', 'wysiwyg' => false, 'required' => true, )); */ if (Mage::getSingleton('adminhtml/session')->getAbrandsData()) { $form->setValues(Mage::getSingleton('adminhtml/session')->getAbrandsData()); Mage::getSingleton('adminhtml/session')->setAbrandsData(null); } elseif (Mage::registry('abrands_data')) { $form->setValues(Mage::registry('abrands_data')->getData()); } return parent::_prepareForm(); }
/** * Add fields to form and create template info form * * @return Mage_Adminhtml_Block_Widget_Form */ protected function _prepareForm() { $model = mage::registry('pdfgenerator_template'); $form = new Varien_Data_Form(); $fieldset = $form->addFieldset('general_fieldset', array('legend' => Mage::helper('pdfgenerator')->__('Template Information'), 'class' => 'fieldset')); $fieldset->addField('pdftemplate_name', 'text', array('name' => 'pdftemplate_name', 'label' => Mage::helper('pdfgenerator')->__('Template Name'), 'required' => true)); $fieldset->addField('pdftemplate_desc', 'text', array('name' => 'pdftemplate_desc', 'label' => Mage::helper('pdfgenerator')->__('Template Description'), 'required' => false)); if ($model->getPdftemplateId()) { $fieldset->addField('pdftemplate_id', 'hidden', array('name' => 'pdftemplate_id')); } if (!Mage::app()->isSingleStoreMode()) { $field = $fieldset->addField('template_store_id', 'select', array('name' => 'template_store_id', 'label' => Mage::helper('cms')->__('Store View'), 'title' => Mage::helper('cms')->__('Store View'), 'required' => true, 'values' => Mage::getSingleton('adminhtml/system_store')->getStoreValuesForForm(false, true))); $renderer = $this->getLayout()->createBlock('adminhtml/store_switcher_form_renderer_fieldset_element'); $field->setRenderer($renderer); } else { $fieldset->addField('template_store_id', 'hidden', array('name' => 'template_store_id', 'value' => Mage::app()->getStore(true)->getId())); $model->setStoreId(Mage::app()->getStore(true)->getId()); } $fieldset->addField('pdft_is_active', 'select', array('label' => Mage::helper('cms')->__('Status'), 'title' => Mage::helper('cms')->__('Status'), 'name' => 'pdft_is_active', 'required' => true, 'options' => array('1' => Mage::helper('cms')->__('Enabled'), '0' => Mage::helper('cms')->__('Disabled')))); $fieldset->addField('pdft_default', 'select', array('label' => Mage::helper('pdfgenerator')->__('Default'), 'title' => Mage::helper('pdfgenerator')->__('Default'), 'name' => 'pdft_default', 'required' => false, 'options' => array('1' => Mage::helper('cms')->__('Yes'), '0' => Mage::helper('cms')->__('No')), 'class' => 'disabled', 'disabled' => true, 'readonly' => 'readonly', 'permission' => 'readonly')); if ($this->getThePdfType()) { $fieldset->addField('pdft_type', 'select', array('label' => Mage::helper('pdfgenerator')->__('Type'), 'title' => Mage::helper('pdfgenerator')->__('Type'), 'name' => 'pdft_type', 'options' => array('1' => $this->getThePdfType()), 'value' => 1, 'required' => true, 'readonly' => true)); } $form->setValues($model->getData()); $this->setForm($form); return parent::_prepareForm(); }
/** * Method to calculate order weight depending of configuration * * @param unknown_type $order */ public function calculateOrderWeight($products) { $retour = 0; //If calculation is enabled if (mage::getStoreConfig('orderpreparation/order_weight_calculation/enable')) { //compute bulk product weight for ($i = 0; $i < count($products); $i++) { $productId = $products[$i]['product_id']; $product = mage::getModel('catalog/product')->load($productId); if ($product->getId()) { $qty = $products[$i]['qty']; $retour += $product->getWeight() * $qty; } } //Add additional weight $methodValue = mage::getStoreConfig('orderpreparation/order_weight_calculation/additional_weight_value'); switch (mage::getStoreConfig('orderpreparation/order_weight_calculation/additional_weight_method')) { case MDN_Orderpreparation_Model_OrderWeightCalculation::METHOD_ADD_FIX_WEIGHT: $retour += $methodValue; break; case MDN_Orderpreparation_Model_OrderWeightCalculation::METHOD_ADD_FIX_WEIGHT_PER_PRODUCT: for ($i = 0; $i < count($products); $i++) { $qty = $products[$i]['qty']; $retour += $qty * $methodValue; } break; case MDN_Orderpreparation_Model_OrderWeightCalculation::METHOD_ADD_PERCENT: $retour += $retour / 100 * $methodValue; break; } } return $retour; }
/** * Load product collection Id(s) * */ public function load() { $nameAttributeId = mage::getModel('Purchase/Constant')->GetProductNameAttributeId(); $this->_collection = mage::getModel('Purchase/StockMovement')->getCollection()->setOrder('sm_date', 'asc')->join('catalog/product', 'sm_product_id=entity_id'); //Affiche le nombre de commande chargée $this->addException(Mage::helper('dataflow')->__('Loaded %s rows', $this->_collection->getSize()), Mage_Dataflow_Model_Convert_Exception::NOTICE); }
/** * Charge la collection * * @return unknown */ protected function _prepareCollection() { //Charge la collection $collection = Mage::getModel('Purchase/StockMovement')->getCollection()->join('Purchase/CatalogProduct', 'sm_product_id=`Purchase/CatalogProduct`.entity_id')->join('Purchase/CatalogProductVarchar', 'sm_product_id=`Purchase/CatalogProductVarchar`.entity_id and store_id=0 and attribute_id = ' . mage::getModel('Purchase/Constant')->GetProductNameAttributeId()); $this->setCollection($collection); return parent::_prepareCollection(); }
/** * Retourne les taches pour une entité * * @param unknown_type $EntityType * @param unknown_type $EntityId */ public function getTasksForEntity($EntityType, $EntityId, $Mode) { //Rajoute les filtres if ($EntityId != null) { $this->getSelect()->where('ot_entity_id=?', $EntityId); } if ($EntityType != null) { $this->getSelect()->where('ot_entity_type=?', $EntityType); } //ajoute les relations pour afficher le nom des utilisateurs (author & target) $this->getSelect()->join(array('user_author' => $this->getTable('admin/user')), '`user_author`.user_id=`main_table`.ot_author_user', array('user_author.username' => 'username')); $this->getSelect()->joinLeft(array('user_target' => $this->getTable('admin/user')), '`user_target`.user_id=`main_table`.ot_target_user', array('user_target.username' => 'username')); $this->getSelect()->joinLeft(array('tbl_category' => $this->getTable('Organizer/TaskCategory')), '`tbl_category`.otc_id=`main_table`.ot_category', array('tbl_category.otc_name' => 'otc_name')); switch ($Mode) { case 'late': $this->getSelect()->where('ot_finished=?', 0); $this->getSelect()->where('ot_deadline<=?', date('Y-m-d')); $this->getSelect()->where('ot_target_user is NULL or ot_target_user=?', mage::helper('Organizer')->getCurrentUserId()); break; case 'notification': $this->getSelect()->where('ot_notification_read=?', 0); $this->getSelect()->where('ot_notify_date<=?', date('Y-m-d')); $this->getSelect()->where('ot_target_user is NULL or ot_target_user=?', mage::helper('Organizer')->getCurrentUserId()); break; case 'mine': $this->getSelect()->where('ot_target_user='******'Organizer')->getCurrentUserId() . ' or ot_author_user='******'Organizer')->getCurrentUserId()); break; } return $this; }