public function prepareForFrontend($data) { if (empty($data)) { return $data; } list($code, $id) = explode('/', $data); if ($code == 'product') { // TODO: Wirklich so laden? $product = Mage::getModel('catalog/product'); $product->load($id); return $product->getProductUrl(); } else { if ($code == 'category') { // TODO: Wirklich so laden? /** @var $product Mage_Catalog_Model_Category */ $category = Mage::getModel('catalog/category'); $category->load($id); return $category->getUrl(); } else { if (is_numeric($data)) { return Mage::Helper('cms/page')->getPageUrl($data); } } } if (substr($data, 0, 4) == 'http' || substr($data, 0, 1) == '.' || substr($data, 0, 1) == '/') { // do not touch http or relative links return $data; } return Mage::getUrl($data); }
public function render(Varien_Object $row) { $product_id = $row->getEntityId(); if ($product_id) { $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsWarehouse(); } $warehouse = $requestData['warehouse_select']; $gettime = Mage::Helper('inventoryreports')->getTimeSelected($requestData); $datefrom = $gettime['date_from']; $dateto = $gettime['date_to']; $warehouse_product = Mage::getModel('inventoryplus/warehouse_product')->getCollection()->addFieldToFilter('warehouse_id', $warehouse); $supplyneeds = array(); $total_supplyneeds = 0; $method = Mage::getStoreConfig('inventory/supplyneed/supplyneeds_method'); if ($datefrom && $dateto && $method == 2 && strtotime($datefrom) <= strtotime($dateto)) { $max_needs = Mage::helper('inventorysupplyneeds')->calMaxAverage($product_id, $datefrom, $dateto, $warehouse); } elseif ($datefrom && $dateto && $method == 1 && strtotime($datefrom) <= strtotime($dateto)) { $max_needs = Mage::helper('inventorysupplyneeds')->calMaxExponential($product_id, $datefrom, $dateto, $warehouse); } else { $max_needs = 0; } if ($max_needs > 0) { $supplyneeds[$product_id] = $max_needs; $total_supplyneeds += $max_needs; } } if ($total_supplyneeds == 0) { return '0'; } else { return $total_supplyneeds; } }
protected function _prepareCollection() { $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsWarehouse(); } $gettime = Mage::Helper('inventoryreports')->getTimeSelected($requestData); $collection = Mage::getModel('inventoryphysicalstocktaking/physicalstocktaking_product')->getCollection(); /* Get product name and sku from catalog, because physicalstocktaking_product does not have them */ if ($storeId = $this->getRequest()->getParam('store', 0)) { $collection->addStoreFilter($storeId); } $productAttributes = array('product_name' => 'name'); foreach ($productAttributes as $alias => $attributeCode) { $tableAlias = $attributeCode . '_table'; $attribute = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $attributeCode); $collection->getSelect()->joinLeft(array($tableAlias => $attribute->getBackendTable()), "main_table.product_id = {$tableAlias}.entity_id AND {$tableAlias}.attribute_id={$attribute->getId()}", array($alias => 'value')); } $collection->join('catalog/product', 'product_id=`catalog/product`.entity_id', array('product_sku' => 'sku')); /* Endl get product name and sku from catalog */ /* Join physicalstocktaking to get created_at */ $collection->getSelect()->joinLeft(array('physicalstocktaking' => $collection->getTable('inventoryphysicalstocktaking/physicalstocktaking')), "main_table.physicalstocktaking_id = physicalstocktaking.physicalstocktaking_id", array('created_at', 'warehouse_id')); /* Endl join physicalstocktaking to get created_at */ $collection->getSelect()->columns(array('difference' => new Zend_Db_Expr("(adjust_qty - old_qty)"))); $collection->getSelect()->where("physicalstocktaking.created_at BETWEEN '" . $gettime['date_from'] . "' AND '" . $gettime['date_to'] . "'"); if (isset($requestData['warehouse_select']) && $requestData['warehouse_select']) { $warehouse_id = $requestData['warehouse_select']; $collection->getSelect()->where("physicalstocktaking.warehouse_id = '{$warehouse_id}'"); } $this->setCollection($collection); $this->_prepareTotals('adjust_qty,old_qty,difference'); return parent::_prepareCollection(); }
protected function _prepareForm() { $counrtries = Mage::Helper('stores')->getCountryCollection(); $form = new Varien_Data_Form(); $stores_id = $this->getRequest()->getParam('id'); $fieldset = $form->addFieldset('general', array('legend' => Mage::helper('core')->__('General Settings'))); $wysiwygConfig = Mage::getSingleton('cms/wysiwyg_config')->getConfig(array('tab_id' => 'page_tabs')); $formData = Mage::getModel('stores/state')->getStoreData($stores_id); $fieldset->addField('title', 'text', array('label' => Mage::helper('core')->__('Store Name'), 'title' => Mage::helper('core')->__('Store Name'), 'name' => 'title', 'width' => '50px', 'required' => true)); $fieldset->addField('zip_code', 'text', array('label' => Mage::helper('core')->__('Zip Code'), 'title' => Mage::helper('core')->__('Zip Code'), 'name' => 'zip_code', 'style' => 'width:50px;', 'required' => false)); $fieldset->addField('country', 'select', array('label' => Mage::helper('core')->__('Country'), 'title' => Mage::helper('core')->__('Country'), 'options' => $counrtries, 'name' => 'country', 'style' => 'width:250px;', 'required' => true)); $fieldset->addField('state', 'text', array('label' => Mage::helper('core')->__('State (Full Name)'), 'title' => Mage::helper('core')->__('State (Full Name)'), 'name' => 'state', 'style' => 'width:250px;', 'required' => false)); $fieldset->addField('city', 'text', array('label' => Mage::helper('core')->__('City'), 'title' => Mage::helper('core')->__('City'), 'name' => 'city', 'style' => 'width:250px;', 'required' => true)); $fieldset->addField('address', 'text', array('label' => Mage::helper('core')->__('Address'), 'title' => Mage::helper('core')->__('Address'), 'name' => 'address', 'style' => 'width:250px;', 'required' => true)); $fieldset->addField('is_all_products', 'checkbox', array('label' => Mage::helper('core')->__('Use All Products from WebSite Store'), 'title' => Mage::helper('core')->__('Use All Products from WebSite Store'), 'name' => 'is_all_products', 'checked' => $formData['is_all_products'] == 1 ? true : false, 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('phone', 'text', array('label' => Mage::helper('core')->__('Phone'), 'title' => Mage::helper('core')->__('Phone'), 'name' => 'phone', 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('fax', 'text', array('label' => Mage::helper('core')->__('Fax'), 'title' => Mage::helper('core')->__('Fax'), 'name' => 'fax', 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('picture_desc', 'textarea', array('label' => Mage::helper('core')->__('Description for Store\'s Photo'), 'title' => Mage::helper('core')->__('Description for Store\'s Photo'), 'name' => 'picture_desc', 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('relatlng', 'checkbox', array('label' => Mage::helper('core')->__('Update Lat/Lng after Save'), 'title' => Mage::helper('core')->__('Update Lat/Lng after Save'), 'name' => 'relatlng', 'required' => false, 'checked' => 'checked', 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('lng', 'text', array('label' => Mage::helper('core')->__('Latitude'), 'title' => Mage::helper('core')->__('Latitude'), 'name' => 'lng', 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $fieldset->addField('lat', 'text', array('label' => Mage::helper('core')->__('Longitude'), 'title' => Mage::helper('core')->__('Longitude'), 'name' => 'lat', 'required' => false, 'config' => Mage::getSingleton('cms/wysiwyg_config')->getConfig())); $formData['desc'] = unserialize($formData['desc']); $form->addValues($formData); $form->setFieldNameSuffix('storeform'); $this->setForm($form); }
/** * Sets parameters for tempalte * * @return Celebros_Conversionpro_Block_Analytics_View */ protected function _prepareLayout() { //running simulated search, to have the log handle down the page. //Mage::helper('conversionpro')->getCurrentLayer()->getProductCollection()->getFacetedData(''); $this->setCustomerId(Mage::getStoreConfig('conversionpro/anlx_settings/cid')); $this->setHost(Mage::getStoreConfig('conversionpro/anlx_settings/host')); $product = $this->getProduct(); //Set product click tracking params if (isset($product)) { $this->setProductSku($product->getSku()); $this->setProductName(str_replace("'", "\\'", $product->getName())); $this->setProductPrice($product->getFinalPrice()); $webSessionId = isset($_SESSION['core']['visitor_data']['session_id']) ? $_SESSION['core']['visitor_data']['session_id'] : session_id(); $this->setWebsessionId($webSessionId); } else { $pageReferrer = Mage::getModel('core/url')->getBaseUrl() . $_SERVER['PHP_SELF']; $this->setPageReferrer($pageReferrer); //$this->setQwiserSearchSessionId(Mage::getSingleton('conversionpro/session')->getSearchSessionId()); $this->setQwiserSearchSessionId($this->_generateGUID()); $webSessionId = isset($_SESSION['core']['visitor_data']['session_id']) ? $_SESSION['core']['visitor_data']['session_id'] : session_id(); $this->setWebsessionId($webSessionId); if (Mage::Helper('conversionpro')->hasSearchResults()) { $this->setQwiserSearchLogHandle(Mage::Helper('conversionpro')->getSearchResults()->GetLogHandle()); } } return parent::_prepareLayout(); }
/** * 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); } }
/** * Get parameters used for build add product to compare list urls * * @param Mage_Catalog_Model_Product $product * @return array */ protected function _getUrlParams($product) { if (key_exists(Mage::Helper('salesperson/mapping')->getMapping('id'), $product->Field)) { $productId = $product->Field[Mage::Helper('salesperson/mapping')->getMapping('id')]; } return array('product' => $productId, Mage_Core_Controller_Front_Action::PARAM_NAME_URL_ENCODED => $this->getEncodedUrl()); }
protected function _prepareCollection() { $series = array(); $total_data = array(); $warehouse_name = array(); $productIds = array(); $difference = array(); $phyids = ''; $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsWarehouse(); } $gettime = Mage::Helper('inventoryreports')->getTimeSelected($requestData); $resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $installer = Mage::getModel('core/resource'); if ($requestData['warehouse_select']) { $warehouse_collection = Mage::getModel('inventoryplus/warehouse')->getCollection(); $warehouse_id = $requestData['warehouse_select']; $query = 'SELECT DISTINCT p.product_id,t.physicalstocktaking_id FROM ' . $installer->getTableName("erp_inventory_physicalstocktaking t") . ' LEFT JOIN ' . $installer->getTableName("erp_inventory_physicalstocktaking_product p") . ' ON t.physicalstocktaking_id = p.physicalstocktaking_id WHERE t.status > 0 AND t.warehouse_id = "' . $warehouse_id . '" AND t.created_at BETWEEN "' . $gettime['date_from'] . '" AND "' . $gettime['date_to'] . '" '; $results = $readConnection->fetchAll($query); if ($results) { foreach ($results as $value) { $productIds[] = $value['product_id']; if ($phyids == '') { $phyids = "('" . $value['physicalstocktaking_id'] . "'"; } else { $phyids .= ','; $phyids .= "'" . $value['physicalstocktaking_id'] . "'"; } } $phyids .= ")"; } else { $phyids = "('0')"; } $productIds = Mage::helper('inventoryreports')->checkProductInWarehouse($productIds, $warehouse_id); $collection = Mage::getModel('catalog/product')->getCollection()->addFieldToFilter('entity_id', array('in' => $productIds)); $collection->joinField('old_qty', 'inventoryphysicalstocktaking/physicalstocktaking_product', 'old_qty', 'product_id=entity_id', '{{table}}.old_qty IS NOT NULL AND {{table}}.old_qty > 0 AND {{table}}.physicalstocktaking_id IN ' . $phyids, 'left'); $collection->joinField('adjust_qty', 'inventoryphysicalstocktaking/physicalstocktaking_product', 'adjust_qty', 'product_id=entity_id', '{{table}}.adjust_qty IS NOT NULL AND {{table}}.adjust_qty > 0 AND {{table}}.physicalstocktaking_id IN ' . $phyids, 'left'); $collection->getSelect()->columns(array('sum_old_qty' => new Zend_Db_Expr("SUM(at_old_qty.old_qty)"))); $collection->getSelect()->columns(array('sum_adjust_qty' => new Zend_Db_Expr("SUM(at_adjust_qty.adjust_qty)"))); $collection->getSelect()->columns(array('difference' => new Zend_Db_Expr("SUM(at_adjust_qty.adjust_qty) - SUM(at_old_qty.old_qty)"))); // $collection->getSelect()->columns(array('name' => new Zend_Db_Expr("e.name"))); $collection->getSelect()->group('e.entity_id'); } Mage::getSingleton('core/resource_iterator')->walk($collection->addAttributeToSelect('*')->getSelect(), array(array($this, 'collectionCallback')), array()); $filterCollection = new Varien_Data_Collection(); for ($i = 0; $i < count($this->_arr); $i++) { $filterCollection->addItem($this->_arr[$i]); } $this->setCollection($filterCollection); $this->_prepareTotals('sum_adjust_qty,sum_old_qty,difference'); return parent::_prepareCollection(); }
/** * Clears the images on the CDN and the local cache. * * @return string */ public function clearCache() { parent::clearCache(); $cds = Mage::Helper('imagecdn')->factory(); if ($cds->useCdn()) { $cds->clearCache(); } }
public function getMenuItemUrl($menuItem) { if (!empty($menuItem->url)) { return $menuItem->url; } else { /* @var $page Mage_Cms_Model_Page */ return Mage::Helper('cms/page')->getPageUrl($menuItem->cms_page_id); } }
/** * Static since a store config exception (caused by a module config error) cannot call magento's model objects. * If a store config exception occurs, the exception class logs it drect. * * @param type $e */ public static function pushEvent($e, $setAppName = true) { if (extension_loaded('newrelic')) { $message = $e->getMessage(); $message = empty($message) ? get_class($e) : $message; if ($setAppName) { Mage::Helper('newrelic')->setAppName(); } newrelic_notice_error($message, $e); } }
/** * Record a log event to new relic * * @param type $event * @return type */ public function recordEvent($event) { if (extension_loaded('newrelic')) { if (Mage::getStoreConfig('newrelic/settings/record_system_log') && !Mage::helper('newrelic')->ignoreMessage($event['message'], 'system_log')) { if ($event['priorityName'] == 'DEBUG' && Mage::getStoreConfig('newrelic/settings/system_log_ignore_debug')) { return; } Mage::Helper('newrelic')->setAppName(); newrelic_notice_error($this->_eventType . ': [' . $event['priorityName'] . '] ' . $event['message']); } } }
public function getAnlxSearchResultFunction() { if (Mage::getStoreConfig('salesperson/anlx_settings/dc') == "" || Mage::getStoreConfig('salesperson/anlx_settings/cid') == "") { return ""; } /*$observer = array('ssid' => Mage::Helper('salesperson')->getSalespersonApi()->results->SearchInformation->SessionId, 'logHandle' => Mage::Helper('salesperson')->getSalespersonApi()->results->GetLogHandle()); Mage::getModel('salesperson/observer')->sendResultAnlxInfo($observer);*/ $dca = Mage::getStoreConfig('salesperson/anlx_settings/dc'); $cid = Mage::getStoreConfig('salesperson/anlx_settings/cid'); $results = Mage::Helper('salesperson')->getSalespersonApi()->results; $sessionId = $this->_getSession()->getSessionId(); return Mage::getModel('salesperson/api_anlx_analyticsFunctions', array("G_DATA_COLLECTOR_ADDRESS" => $dca, "G_CUSTOMER_ID" => $cid, "G_CUSTOMER_NAME" => $cid, "G_PUBLIC_KEY" => ""))->Celebros_Analytics_SearchResults($results->SearchInformation->SessionId, $results->GetLogHandle(), $sessionId, '1', $sessionId, isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '', (bool) Mage::getStoreConfig('salesperson/anlx_settings/protocol_connection'), true); }
public function setOrderId() { $active = Mage::Helper('customorderid/data')->custom_order_id_active(); $OrderEntityType = Mage::getModel('eav/entity_type')->load(self::SALES_ORDER, 'entity_type_code')->getData(); $invoiceEntityType = Mage::getModel('eav/entity_type')->load(self::SALES_INVOICE, 'entity_type_code')->getData(); $shipmentEntityType = Mage::getModel('eav/entity_type')->load(self::SALES_SHIPMENT, 'entity_type_code')->getData(); $creditmemoEntityType = Mage::getModel('eav/entity_type')->load(self::SALES_CREDITMEMO, 'entity_type_code')->getData(); $orderEnable = Mage::Helper('customorderid/data')->custom_order_enable(); $invoiceEnable = Mage::Helper('customorderid/data')->custom_invoice_enable(); $shippingEnable = Mage::Helper('customorderid/data')->custom_shipping_enable(); $creditmemoEnable = Mage::Helper('customorderid/data')->custom_creditmemo_enable(); if ($active) { //** Sales Order New Id if ($orderEnable) { $orderIdNew = Mage::Helper('customorderid/customorderid')->order(); $this->newOrderIdSet($orderIdNew, $OrderEntityType['entity_type_id']); } else { $this->newOrderIdSet(self::SALES_DEFAULT_ID, $OrderEntityType['entity_type_id']); } //** Invoice New Order Id if ($invoiceEnable) { $invoiceIdNew = Mage::Helper('customorderid/customorderid')->invoice(); $this->newOrderIdSet($invoiceIdNew, $invoiceEntityType['entity_type_id']); } else { $this->newOrderIdSet(self::SALES_DEFAULT_ID, $invoiceEntityType['entity_type_id']); } //** Shipment New Order Id if ($shippingEnable) { $shipmentNew = Mage::Helper('customorderid/customorderid')->shipment(); $this->newOrderIdSet($shipmentNew, $shipmentEntityType['entity_type_id']); } else { $this->newOrderIdSet(self::SALES_DEFAULT_ID, $shipmentEntityType['entity_type_id']); } //** CreditMemo New Order Id if ($creditmemoEnable) { $creditMemoIdNew = Mage::Helper('customorderid/customorderid')->creditmemo(); $this->newOrderIdSet($creditMemoIdNew, $creditmemoEntityType['entity_type_id']); } else { $this->newOrderIdSet(self::SALES_DEFAULT_ID, $creditmemoEntityType['entity_type_id']); } // $updateNewOrderId = Mage::getModel('eav/entity_store')->load($OrderEntityType['entity_type_id'], 'entity_type_id')->addData(array('increment_last_id'=> $orderIdNew))->save(); // $OrderEntityStore = Mage::getModel('eav/entity_store')->load($invoiceEntityType['entity_type_id'], 'entity_type_id')->addData(array('increment_last_id'=> $invoiceIdNew))->save(); // $OrderEntityStore = Mage::getModel('eav/entity_store')->load($shipmentEntityType['entity_type_id'], 'entity_type_id')->addData(array('increment_last_id'=> $shipmentNew))->save(); // $OrderEntityStore = Mage::getModel('eav/entity_store')->load($creditmemoEntityType['entity_type_id'], 'entity_type_id')->addData(array('increment_last_id'=> $creditMemoIdNew))->save(); } else { $this->newOrderIdSet(self::SALES_DEFAULT_ID, $OrderEntityType['entity_type_id']); $this->newOrderIdSet(self::SALES_DEFAULT_ID, $invoiceEntityType['entity_type_id']); $this->newOrderIdSet(self::SALES_DEFAULT_ID, $shipmentEntityType['entity_type_id']); $this->newOrderIdSet(self::SALES_DEFAULT_ID, $creditmemoEntityType['entity_type_id']); } }
public function getFullTaxInfo() { $taxClassAmount = Mage::helper('tax')->getCalculatedTaxes($this->getOrder()); if (!empty($taxClassAmount)) { $shippingTax = Mage::helper('tax')->getShippingTax($this->getOrder()); $taxClassAmount = array_merge($shippingTax, $taxClassAmount); $i = 0; $len = count($taxClassAmount); foreach ($taxClassAmount as $tax) { $tableHtmlPseudo = ''; $taxTitle = Mage::Helper('core/string')->cleanString($tax['title']); $taxTitle = 'tax_' . preg_replace("[^A-Za-z0-9]", "", $taxTitle); $taxTitle = strtolower($taxTitle); $percent = $tax['percent'] ? ' (' . floatval($tax['percent']) . '%)' : ''; $tableHtmlPseudo .= '<tr>'; $tableHtmlPseudo .= '<td><span>' . $tax['title'] . ' ' . $percent . '</span></td>'; $tableHtmlPseudo .= '<td><span>' . $this->getAmountPrefix() . $this->getOrder()->formatPriceTxt($tax['tax_amount']) . '</span></td>'; $tableHtmlPseudo .= '</tr>'; if ($i++ == 0) { $tableHtml = '<table class="table-rates-tax"><tbody>'; } $tableHtml .= $tableHtmlPseudo; if ($i == $len) { $tableHtml .= '</tbody></table>'; } $tax_info[] = array($taxTitle => array('value' => $this->getAmountPrefix() . $this->getOrder()->formatPriceTxt($tax['tax_amount']), 'label' => Mage::helper('tax')->__($tax['title']) . $percent . ':'), 'pseudotaxtable_data' => array('value' => $tableHtmlPseudo, 'label' => Mage::helper('tax')->__($rate['title']) . $percent . ':'), 'taxtable_data' => array('value' => $tableHtml, 'label' => Mage::helper('tax')->__($rate['title']) . $percent . ':')); $taxClassAmount = $tax_info; } } else { $rates = Mage::getResourceModel('sales/order_tax_collection')->loadByOrder($this->getOrder())->toArray(); $fullInfo = Mage::getSingleton('tax/calculation')->reproduceProcess($rates['items']); $tax_info = array(); if ($fullInfo) { foreach ($fullInfo as $info) { if (isset($info['hidden']) && $info['hidden']) { continue; } $_amount = $info['amount']; foreach ($info['rates'] as $rate) { $percent = $rate['percent'] ? ' (' . $rate['percent'] . '%)' : ''; $taxTitle = Mage::Helper('core/string')->cleanString($rate['title']); $taxTitle = 'tax_' . preg_replace("[^A-Za-z0-9]", "", $taxTitle); $taxTitle = strtolower($taxTitle); $tax_info[] = array($taxTitle => array('value' => $this->getAmountPrefix() . $this->getOrder()->formatPriceTxt($_amount), 'label' => Mage::helper('tax')->__($rate['title']) . $percent . ':')); } } } $taxClassAmount = $tax_info; } return $taxClassAmount; }
protected function _prepareColumns() { $configModel = Mage::getModel('utils/config'); $carriersModel = Mage::getModel('utils/carriers'); $this->addColumn("id", array("header" => Mage::helper("labels")->__("ID"), "align" => "right", "width" => "50px", "index" => "id")); $this->addColumn("carrier_id", array("header" => Mage::helper("labels")->__("Carrier Name"), "align" => "left", "index" => "carrier_id", "type" => "options", "options" => $configModel->toOptions($carriersModel->getCollection()->load(), array('id' => 'description')))); $this->addColumn("prefix", array("header" => Mage::helper("labels")->__("Prefix"), "align" => "left", "index" => "prefix")); $this->addColumn("suffix", array("header" => Mage::helper("labels")->__("Suffix"), "align" => "left", "index" => "suffix")); $this->addColumn("begin_code", array("header" => Mage::helper("labels")->__("Begin Code"), "align" => "left", "index" => "begin_code")); $this->addColumn("end_code", array("header" => Mage::helper("labels")->__("End Code"), "align" => "left", "index" => "end_code")); $this->addColumn("alarm", array("header" => Mage::helper("labels")->__("Alarm"), "align" => "left", "index" => "alarm")); $this->addColumn("enabled", array("header" => Mage::helper("labels")->__("Enabled"), "align" => "left", "index" => "enabled", "type" => "options", "options" => Mage::Helper('labels')->getYesNo())); return parent::_prepareColumns(); }
public function handle($_vars) { if (!$_vars) { Mage::helper("icecore")->log("No Postback vars"); die("ICEPAY postback page installed correctly."); } $this->_post = $_vars; if ($_vars['Status'] == Icepay_IceCore_Model_Config::STATUS_VERSION_CHECK) { $this->outputVersion($this->validateVersion()); } Mage::helper("icecore")->log(serialize($_vars)); $this->order = $this->orderModel->loadByIncrementId($_vars['OrderID']); $icepayTransaction = $this->sqlModel->loadPaymentByID($this->order->getRealOrderId()); $this->storeID = $icepayTransaction["store_id"]; $transActionID = $this->saveTransaction($_vars); $doSpecialActions = false; if ($_vars['Status'] == Icepay_IceCore_Model_Config::STATUS_AUTH) { if (Mage::helper('icecore')->isModuleInstalled('Icepay_AutoCapture')) { if (Mage::Helper('icepay_autocapture')->isAutoCaptureActive($this->storeID)) { $_vars['Status'] = Icepay_IceCore_Model_Config::STATUS_SUCCESS; } } } if ($this->canUpdateBasedOnIcepayTable($icepayTransaction['status'], $_vars['Status'])) { /* creating the invoice causes major overhead! Status should to be updated and saved first */ if ($_vars['Status'] == Icepay_IceCore_Model_Config::STATUS_SUCCESS) { $doSpecialActions = true; } // Update ICEPAY transaction info $newData = $icepayTransaction; $newData['update_time'] = now(); $newData['status'] = $_vars['Status']; $newData['transaction_id'] = $_vars['PaymentID']; $this->sqlModel->changeStatus($newData); // Update order status if ($_vars['Status'] == Icepay_IceCore_Model_Config::STATUS_ERROR) { $this->order->cancel(); } else { $this->order->setState($this->getMagentoState($_vars['Status']), $this->getMagentoStatus($_vars['Status']), Mage::helper('icecore')->__('Status of order changed'), true); } } $this->order->save(); $this->sendMail($icepayTransaction['status'], $_vars['Status']); if ($doSpecialActions) { $extraMsg = $this->specialActions($_vars['Status'], $transActionID); $this->order->setState($this->getMagentoState($_vars['Status']), $this->getMagentoStatus($_vars['Status']), $extraMsg, false); $this->order->save(); } }
/** * prepare columns for this grid * * @return Magestore_Inventory_Block_Adminhtml_Inventory_Grid */ protected function _prepareColumns() { $filterData = new Varien_Object(); $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsSupplier(); } $this->addColumn('name', array('header' => Mage::helper('sales')->__('Product Name'), 'align' => 'left', 'index' => 'name')); $this->addColumn('total_ordered', array('header' => Mage::helper('sales')->__('Total Ordered'), 'align' => 'right', 'index' => 'total_ordered', 'width' => '100px', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterTotalCallback'))); $this->addColumn('total_canceled', array('header' => Mage::helper('sales')->__('Total Canceled'), 'align' => 'right', 'index' => 'total_canceled', 'width' => '100px', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterTotalCallback'))); $this->addColumn('total_refunded', array('header' => Mage::helper('sales')->__('Total Refunded'), 'align' => 'right', 'index' => 'total_refunded', 'width' => '100px', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterTotalCallback'))); $this->addColumn('total_sold', array('header' => Mage::helper('sales')->__('Total Sold'), 'align' => 'right', 'index' => 'total_sold', 'width' => '100px', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterTotalCallback'))); // $this->addExportType('*/*/exportCsv', Mage::helper('inventoryreports')->__('CSV')); // $this->addExportType('*/*/exportXml', Mage::helper('inventoryreports')->__('XML')); return parent::_prepareColumns(); }
/** * Hijacks the normal GD2 save method to add ImageCDN hooks. Fails back to parent method * as appropriate. * * @param string $destination * @param string $newName * @return none */ public function save($destination = null, $newName = null) { $cds = Mage::Helper('imagecdn')->factory(); $compression = Mage::getStoreConfig('imagecdn/general/compression'); if ($cds->useCdn()) { $temp = tempnam(sys_get_temp_dir(), 'cds'); parent::save($temp); //Compress images? if ($this->_fileType == IMAGETYPE_JPEG && $compression > 0) { $convert = round((9 - $compression) * (100 / 8)); //convert to imagejpeg's scale call_user_func('imagejpeg', $this->_imageHandler, $temp, $convert); } elseif ($this->_fileType == IMAGETYPE_PNG && $compression > 0) { $convert = round(($compression - 1) * (9 / 8)); //convert to imagepng's scale call_user_func('imagepng', $this->_imageHandler, $temp, $convert); } $filename = !isset($destination) ? $this->_fileName : $destination; if (isset($destination) && isset($newName)) { $filename = $destination . "/" . $filename; } elseif (isset($destination) && !isset($newName)) { $info = pathinfo($destination); $filename = $destination; $destination = $info['dirname']; } elseif (!isset($destination) && isset($newName)) { $filename = $this->_fileSrcPath . "/" . $newName; } else { $filename = $this->_fileSrcPath . $this->_fileSrcName; } if ($cds->save($filename, $temp)) { @unlink($temp); } else { if (!is_writable($destination)) { try { $io = new Varien_Io_File(); $io->mkdir($destination); } catch (Exception $e) { throw new Exception("Unable to write file into directory '{$destinationDir}'. Access forbidden."); } } @rename($temp, $filename); @chmod($filename, 0644); } } else { return parent::save($destination, $newName); } }
protected function _prepareForm() { $_fb05a43927cff438da7fdbd15552ff3227bd4b96 = new Varien_Data_Form(); $this->setForm($_fb05a43927cff438da7fdbd15552ff3227bd4b96); $_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c = Mage::registry('current_customer'); $_780559c4efd84bf65288edb8394a43a3aa300846 = $_fb05a43927cff438da7fdbd15552ff3227bd4b96->addFieldset('subloginconfiguration', array('legend' => Mage::helper('sublogin')->__('Sublogin Configuration'))); $_fb05a43927cff438da7fdbd15552ff3227bd4b96->setHtmlIdPrefix('_subloginconfiguration'); $_fb05a43927cff438da7fdbd15552ff3227bd4b96->setFieldNameSuffix('subloginconfiguration'); $_780559c4efd84bf65288edb8394a43a3aa300846->addField('can_create_sublogins', 'select', array('label' => Mage::helper('sublogin')->__('Can create sublogins'), 'after_element_html' => '<br />' . Mage::helper('sublogin')->__('If allowed, customer can create sublogins in frontend area'), 'name' => 'can_create_sublogins', 'values' => Mage::getModel('adminhtml/system_config_source_yesno')->toOptionArray())); if (Mage::getStoreConfig('sublogin/projects/project266_active')) { $_780559c4efd84bf65288edb8394a43a3aa300846->addField('max_number_sublogins', 'text', array('label' => Mage::helper('sublogin')->__('Max. number of sublogins'), 'after_element_html' => Mage::helper('sublogin')->__('Configure the max. amount of sublogins the customer can create. 0 is unlimited.'), 'name' => 'max_number_sublogins', 'readonly' => true)); } else { $_780559c4efd84bf65288edb8394a43a3aa300846->addField('max_number_sublogins', 'text', array('label' => Mage::helper('sublogin')->__('Max. number of sublogins'), 'after_element_html' => Mage::helper('sublogin')->__('Configure the max. amount of sublogins the customer can create. 0 is unlimited.'), 'name' => 'max_number_sublogins')); } $_64af779d81eb451f44e50893e14780ab31bf8125 = $_fb05a43927cff438da7fdbd15552ff3227bd4b96->addFieldset('sublogin', array('legend' => Mage::helper('sublogin')->__('Sublogins'))); $_fb05a43927cff438da7fdbd15552ff3227bd4b96->setHtmlIdPrefix('_sublogin'); $_fb05a43927cff438da7fdbd15552ff3227bd4b96->setFieldNameSuffix('sublogin'); $_64af779d81eb451f44e50893e14780ab31bf8125->addField('sublogins', 'text', array('name' => 'sublogins')); $_2ecc41b28041667049b648881d5ff17111568699 = $_fb05a43927cff438da7fdbd15552ff3227bd4b96->getElement('sublogins')->getName(); $_2289f66a254ac0ee1bb00efbd40a49e3e810d1f2 = $_fb05a43927cff438da7fdbd15552ff3227bd4b96->getElement('sublogins')->getHtmlId(); $_168f685b62f9bec4ef848eff88e14ca431705084 = <<<EOH <div style="width:100px"> <img style="margin-top:1px;float:right" id="{$_2289f66a254ac0ee1bb00efbd40a49e3e810d1f2}_row_{{index}}_expire_date_trig" src="{$this->getSkinUrl('images/grid-cal.gif')}" /> <input rel="{{index}}" class="input-text" type="text" value="{{expire_date}}" name="{$_2ecc41b28041667049b648881d5ff17111568699}[{{index}}][expire_date]" id="{$_2289f66a254ac0ee1bb00efbd40a49e3e810d1f2}_row_{{index}}_expire_date" readonly="readonly" style="width:70px" /> </div> EOH; $_d2389373c4d226ef389a44a6ea431427c26dd7a9 = Mage::Helper('sublogin')->getGridFields($_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c, $_168f685b62f9bec4ef848eff88e14ca431705084); if (Mage::getStoreConfig('sublogin/general/edit_in_grid', $_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->getStoreId())) { $_205d95c001c842f933e3b55fa4e902d5d2fdd0af = Mage::getModel('sublogin/sublogin')->getCollection()->addFieldToFilter('entity_id', $_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->getId())->addOrder('id', 'ASC'); $_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->setSublogins($_205d95c001c842f933e3b55fa4e902d5d2fdd0af->getItems()); $_fb05a43927cff438da7fdbd15552ff3227bd4b96->getElement('sublogins')->setRenderer(Mage::getSingleton('core/layout')->createBlock('sublogin/tableinput')->addAfterJs('mageb2b/sublogin/form.js')->setDisplay(array('idfield' => 'id', 'addbutton' => $this->__('Add'), 'fields' => $_d2389373c4d226ef389a44a6ea431427c26dd7a9))); } else { $_fb05a43927cff438da7fdbd15552ff3227bd4b96->getElement('sublogins')->setRenderer(Mage::getSingleton('core/layout')->createBlock('sublogin/customer_edit_tab_sublogin_gridContainer')); } if (!$_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->getId()) { $_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->setData('can_create_sublogins', 1); } $_fb05a43927cff438da7fdbd15552ff3227bd4b96->setValues($_b803c43bc8b3ef64b7d19b78f670cdbd11dacf8c->getData()); $this->setForm($_fb05a43927cff438da7fdbd15552ff3227bd4b96); return $this; }
public function collect(Mage_Sales_Model_Quote_Address $address) { parent::collect($address); $this->_setAmount(0); $this->_setBaseAmount(0); $quote = $address->getQuote(); $val = Mage::Helper('adyen')->isPaymentFeeEnabled($quote); if ($address->getAllItems() && $val) { $currentAmount = $address->getPaymentFeeAmount(); $fee = Mage::Helper('adyen')->getPaymentFeeAmount($quote); $balance = $fee - $currentAmount; $address->setPaymentFeeAmount($address->getQuote()->getStore()->convertPrice($balance)); $address->setBasePaymentFeeAmount($balance); $address->setGrandTotal($address->getGrandTotal() + $address->getPaymentFeeAmount()); $address->setBaseGrandTotal($address->getBaseGrandTotal() + $address->getBasePaymentFeeAmount()); } return $this; }
/** * prepare columns for this grid * * @return Magestore_Inventory_Block_Adminhtml_Inventory_Grid */ protected function _prepareColumns() { $filterData = new Varien_Object(); $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsSupplier(); } if ($supplierId = $requestData['supplier_select']) { $this->addColumn('product_name', array('header' => Mage::helper('inventoryreports')->__('Product Name'), 'align' => 'left', 'index' => 'product_name', 'filter_condition_callback' => array($this, '_filterProductNameCallback'))); $this->addColumn('total_inventory', array('header' => Mage::helper('inventoryreports')->__('Total Qty Purchased'), 'align' => 'right', 'index' => 'total_inventory', 'type' => 'number', 'width' => '100px', 'filter_condition_callback' => array($this, '_filterTotalInventoryCallback'), 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbysupplier_renderer_inventory')); } else { $this->addColumn('supplier_name', array('header' => Mage::helper('inventoryreports')->__('Supplier name'), 'align' => 'left', 'index' => 'supplier_name')); $this->addColumn('total_inventory', array('header' => Mage::helper('inventoryreports')->__('Inventory by Supplier'), 'align' => 'right', 'index' => 'total_inventory', 'type' => 'number', 'width' => '100px', 'filter_condition_callback' => array($this, '_filterTotalInventoryCallback'), 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbysupplier_renderer_inventory')); } // $this->addExportType('*/*/exportCsv', Mage::helper('inventoryreports')->__('CSV')); // $this->addExportType('*/*/exportXml', Mage::helper('inventoryreports')->__('XML')); return parent::_prepareColumns(); }
/** * Retrieve url for adding product to wishlist with params * * @param Celebros_Salesperson_Model_Api_QwiserProduct|Mage_Wishlist_Model_Item $product * @param array $param * @return string|boolean */ public function getAddUrlWithParams($item, array $params = array()) { //Mage::log("wishlist"); $productId = null; if ($item instanceof Celebros_Salesperson_Model_Api_QwiserProduct) { if (key_exists(Mage::Helper('salesperson/mapping')->getMapping('id'), $item->Field)) { $productId = $item->Field[Mage::Helper('salesperson/mapping')->getMapping('id')]; } } if ($item instanceof Mage_Wishlist_Model_Item) { $productId = $item->getProductId(); } if ($productId) { $params['product'] = $productId; return $this->_getUrlStore($item)->getUrl('wishlist/index/add', $params); } return false; }
/** * Provides the URL to the image on the CDN or fails back to the parent method as appropriate * * @return string */ public function getImageUrl() { $path = false; if ($image = $this->getImage()) { $path = Mage::getBaseDir('media') . '/catalog/category/' . $image; } $cds = Mage::Helper('imagecdn')->factory(); if ($path && $cds->useCdn()) { $fileExists = $cds->fileExists($path); if (!$fileExists) { $cds->save($path, $path); } $url = $cds->getUrl($path); if ($url) { return $url; } } return parent::getImageUrl(); }
/** * Retrieve url for add product to cart * * @param Mage_Catalog_Model_Product $product * @return string */ public function getAddUrl($product, $additional = array()) { $continueUrl = Mage::helper('core')->urlEncode($this->getCurrentUrl()); $urlParamName = Mage_Core_Controller_Front_Action::PARAM_NAME_URL_ENCODED; if (key_exists(Mage::Helper('salesperson/mapping')->getMapping('id'), $product->Field)) { $routeParams = array($urlParamName => $continueUrl, 'product' => $product->Field[Mage::Helper('salesperson/mapping')->getMapping('id')]); } if (!empty($additional)) { $routeParams = array_merge($routeParams, $additional); } // if ($product->hasUrlDataObject()) { // $routeParams['_store'] = $product->getUrlDataObject()->getStoreId(); // $routeParams['_store_to_url'] = true; // } if ($this->_getRequest()->getRouteName() == 'checkout' && $this->_getRequest()->getControllerName() == 'cart') { $routeParams['in_cart'] = 1; } return $this->_getUrl('checkout/cart/add', $routeParams); }
protected function _prepareForm() { $form = new Varien_Data_Form(array('id' => 'edit_form', 'action' => $this->getUrl('*/*/save'), 'method' => 'post', 'enctype' => 'multipart/form-data')); $categoryId = (int) $this->getRequest()->getParam('id'); if ($categoryId <= 0) { return parent::_prepareForm(); } $kwixoCategoryMapping = Mage::getModel('ops/kwixo_category_mapping')->loadByCategoryId($categoryId); $storeId = (int) $this->getRequest()->getParam('store'); $fieldset = $form->addFieldset('ops_form', array('legend' => Mage::helper('ops/data')->__('Categories configuration'))); $fieldset->addField('storeId', 'hidden', array('required' => true, 'name' => 'storeId', 'value' => $storeId)); $fieldset->addField('id', 'hidden', array('required' => false, 'name' => 'id', 'value' => $kwixoCategoryMapping->getId())); $fieldset->addField('category_id', 'hidden', array('required' => true, 'name' => 'category_id', 'value' => $categoryId)); $fieldset->addField('kwixoCategory_id', 'select', array('label' => Mage::Helper('ops/data')->__('Kwixo category'), 'class' => 'required-entry', 'required' => true, 'name' => 'kwixoCategory_id', 'value' => $kwixoCategoryMapping->getKwixoCategoryId(), 'values' => Mage::getModel('ops/source_kwixo_productCategories')->toOptionArray())); $fieldset->addField('applysubcat', 'checkbox', array('label' => Mage::Helper('ops/data')->__('Apply to sub-categories'), 'name' => 'applysubcat')); $form->setUseContainer(true); $this->setForm($form); return parent::_prepareForm(); }
/** * prepare columns for this grid * * @return Magestore_Inventory_Block_Adminhtml_Inventory_Grid */ protected function _prepareColumns() { $filterData = new Varien_Object(); $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::Helper('inventoryreports')->getDefaultOptionsWarehouse(); } $warehouseId = $requestData['warehouse_select']; if (!$warehouseId) { //die; // $this->addColumn('warehouse_name', array('header' => Mage::helper('inventoryreports')->__('Warehouse Name'), 'align' => 'left', 'index' => 'warehouse_name')); $this->addColumn('total_product', array('header' => Mage::helper('inventoryreports')->__('Total No. of Products'), 'align' => 'right', 'index' => 'total_product', 'type' => 'number', 'width' => '100px', 'filter_condition_callback' => array($this, '_filterCallback'))); } else { $this->addColumn('name', array('header' => Mage::helper('inventoryreports')->__('Product Name'), 'align' => 'left', 'index' => 'name', 'filter_condition_callback' => array($this, '_filterCallback'))); $this->addColumn('product_id', array('header' => Mage::helper('inventoryreports')->__('Image'), 'align' => 'right', 'index' => 'product_id', 'type' => 'number', 'width' => '100px', 'filter' => false, 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbywarehouse_renderer_productimage')); } // $this->addExportType('*/*/exportCsv', Mage::helper('inventoryreports')->__('CSV')); // $this->addExportType('*/*/exportXml', Mage::helper('inventoryreports')->__('XML')); return parent::_prepareColumns(); }
protected function _prepareCollection() { $filterData = new Varien_Object(); $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); $gettime = Mage::Helper('inventoryreports')->getTimeSelected($requestData); if (!$requestData['warehouse_select']) { //All warehouses $installer = Mage::getModel('core/resource'); $collection = Mage::getModel('inventoryplus/warehouse_shipment')->getCollection(); $collection->getSelect()->joinLeft(array('order' => $installer->getTableName('sales_flat_order')), 'main_table.order_id = order.entity_id', array('count(distinct main_table.order_id) as total_order', 'main_table.warehouse_name'))->where('order.created_at BETWEEN "' . $gettime['date_from'] . '" and "' . $gettime['date_to'] . '" AND main_table.warehouse_id > 0 ')->group('main_table.warehouse_id'); } else { //Warehouse selected $installer = Mage::getModel('core/resource'); $collection = Mage::getModel('inventoryplus/warehouse_shipment')->getCollection(); $collection->getSelect()->distinct(true)->joinLeft(array('order' => $installer->getTableName('sales_flat_order')), 'main_table.order_id = order.entity_id', array('order.increment_id', 'order.created_at', 'order.base_grand_total', 'order.grand_total'))->joinLeft(array('item' => $installer->getTableName('sales_flat_order_item')), 'order.entity_id = item.order_id', array('sum(item.qty_ordered) as qty_order', 'sum(item.qty_shipped) as qty_ship', 'sum(item.qty_refunded) as qty_refund'))->where('main_table.warehouse_id = ' . $requestData['warehouse_select'] . ' AND order.created_at BETWEEN "' . $gettime['date_from'] . '" and "' . $gettime['date_to'] . '"')->group('main_table.order_id'); } //Zend_Debug::Dump($collection->getSelect()->__toString());die(); $this->setCollection($collection); return parent::_prepareCollection(); }
/** * Get all config data to pass to javascript (array) and jsonencode. * * @return mixed */ public function getConfig() { $center = explode(",", Mage::Helper('dpd')->getGoogleMapsCenter()); $this->_configArray["saveParcelUrl"] = $this->getUrl('dpd/ajax/saveparcel', array('_secure' => true)); $this->_configArray["invalidateParcelUrl"] = $this->getUrl('dpd/ajax/invalidateparcel', array('_secure' => true)); $this->_configArray["windowParcelUrl"] = $this->getUrl('dpd/ajax/windowindex', array('_secure' => true)); $this->_configArray["ParcelUrl"] = $this->getUrl('dpd/ajax/index', array('_secure' => true)); $this->_configArray["gmapsCenterlat"] = $center[0]; $this->_configArray["gmapsCenterlng"] = $center[1]; $this->_configArray["gmapsHeight"] = Mage::getStoreConfig('carriers/dpdparcelshops/google_maps_height') . 'px'; $this->_configArray["loadingmessage"] = '<span class="message">' . $this->__('Loading DPD parcelshop map based on your address...') . '</span>'; $this->_configArray["gmapsWidth"] = Mage::getStoreConfig('carriers/dpdparcelshops/google_maps_width') . 'px'; $this->_configArray["gmapsIcon"] = Mage::getDesign()->getSkinUrl('images/dpd/icon_parcelshop.png'); $this->_configArray["gmapsIconShadow"] = Mage::getDesign()->getSkinUrl('images/dpd/icon_parcelshop_shadow.png'); $this->_configArray["gmapsCustomIcon"] = Mage::getStoreConfig('carriers/dpdparcelshops/google_maps_icon') ? Mage::getBaseUrl('media') . "dpd/" . Mage::getStoreConfig('carriers/dpdparcelshops/google_maps_icon') : ""; $this->_configArray["gmapsDisplay"] = (bool) Mage::getStoreConfig('carriers/dpdparcelshops/google_maps_display'); $this->_configArray["loaderimage"] = $this->getSkinUrl('images/dpd/ajax-loader.gif'); $this->_configArray["freeShippingOnCustom"] = (bool) Mage::getStoreConfig('carriers/dpdparcelshops/custom_parcelshops_free_shipping'); return Mage::helper('core')->jsonEncode($this->_configArray); }
protected function _prepareCollection() { $resource = Mage::getModel('core/resource'); $filterData = new Varien_Object(); $requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter')); if (empty($requestData)) { $requestData = Mage::helper('inventoryreports')->getDefaultOptionsWarehouse(); } $gettime = Mage::Helper('inventoryreports')->getTimeSelected($requestData); if (!$requestData['warehouse_select']) { //All Warehouses $collection = Mage::getModel('inventorywarehouse/sendstock')->getCollection()->addFieldToFilter('status', 1); $collection->getSelect()->columns('SUM(total_products) AS total_sent')->where('created_at BETWEEN "' . $gettime['date_from'] . '" and "' . $gettime['date_to'] . '"')->group('warehouse_name_from'); } else { // WAREHOUSE SELECTED $collection = Mage::getModel('inventorywarehouse/sendstock_product')->getCollection(); $collection->getSelect()->join(array('sendstock' => $resource->getTableName('erp_inventory_warehouse_sendstock')), 'sendstock.warehouse_sendstock_id = main_table.warehouse_sendstock_id', array('main_table.product_name', 'sum(main_table.qty) as total_sent', 'sendstock.created_at', 'main_table.product_name'))->where('sendstock.status = 1 and sendstock.warehouse_id_from = ' . $requestData['warehouse_select'] . ' and sendstock.created_at BETWEEN "' . $gettime['date_from'] . '" and "' . $gettime['date_to'] . '"')->group('main_table.product_id'); } $this->setCollection($collection); return parent::_prepareCollection(); }