Skip to main content

Display new arrivals by category in Magento

Some times clients demand to show new arrivals product on home page or product listing page in magento store. Then its very easy to show that
For this load product collection and apply these filters


<?php 
/*Find the current date */ 
 $todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); 
/*Making collection of new arrivals*/
 $_productCollection = Mage::getModel('catalog/product')->getCollection()   
                ->addAttributeToSelect('*')
                ->setStoreId($storeId)
                ->addStoreFilter($storeId)
                ->addCategoryFilter($category)
                ->addAttributeToFilter('news_from_date', array('date' => true, 'to' => $todayDate))
                ->addAttributeToFilter('news_to_date', array('or'=> array(
               0 => array('date' => true, 'from' => $todayDate),
               1 => array('is' => new Zend_Db_Expr('null')))
           ), 'left')
            ->addAttributeToSort('news_from_date', $this->getRequest()->getParam('dir'));
?>
Labels:

Comments

Post a Comment

Popular posts from this blog

How to add tab in Customer Information in Magento Admin

Step 1) Override the file /app/code/core/Mage/Adminhtml/Block/Customer/Edit/Tabs.php, Inside _beforeToHtml() method, add the following code: $ this -> addTab ( 'Custom' , array (      'label'   = > Mage :: helper ( 'customer' ) -> __ ( 'Custom' ) ,      'class'   = >     'ajax' ,      'url'     = >     $ this -> getUrl ( '*/*/custom' , array ( '_current' = > true ) ) , ) ) ; Step 2)  Override the file /app/code/core/Mage/Adminhtml/controllers/CustomerController.php, Add the following code: public function customAction() { $this->_initCustomer(); $this->getResponse()->setBody( Mage::app()->getLayout()->createBlock('core/template')->setTemplate('custom/customer/tab/custom.phtml')->setCustomerId(Mage::registry('current_customer')->getId())         ->setUseAjax(true)-...
Post a Comment
Read more

get directory paths, get Base URLs, get URLs in static block, get secure URL in Magento

1) Get Directory paths  Mage::getBaseDir()  //output : /var/www/html/magento Mage::getBaseDir('app')  //output : /var/www/html/magento/app Mage::getBaseDir('media') //output : /var/www/html/magento/media Mage::getBaseDir(‘design’) => Get design directory path Mage::getBaseDir(‘code’) => Gives code directory file path Mage::getBaseDir(‘lib’) => Gives lib directory file path Mage::getBaseDir(‘skin’) => Gives skin directory file path Mage::getBaseDir(‘var’) => Gives var directory file path Mage::getBaseDir(‘cache’) => Gives cache directory file path Mage::getBaseDir(‘log’) => Gives log directory file path       2) Get Base URL  Mage::getBaseUrl() => Get base url path e.g. http://yourwebsite.com/  Mage::getBaseUrl('media') => Get MEDIA folder path e.g. http://yourwebsite.com/media/  Mage::getBaseUrl('js') => Get JS folder path e.g. http://yourwebsite.com/js/  Mage::getBaseUrl('skin') => Get...
1 comment
Read more

change precision of price in magento

By default Magento show price with two decimal points like Rs. 25.00 , if you want to change the precision of  Price then  In line 62 in /lib/zend/Currency.php you can change the precision for all  prices in your shop. <?php protected $_options = array( 'position' => self::STANDARD, // position for the currency sign 'script' => null, // script for output 'format' => null, // locale for numeric output 'display' => self::NO_SYMBOL, // currency detail to show 'precision' => 0, // precision for currency 'name' => null, // name for this currency 'currency' => null, // 3 lettered international abbreviation 'symbol' => null // currency symbol ); and /app/code/core/Mage/Core/Model/Store.php Change the roundPrice function to: public function r...
Post a Comment
Read more