Latest product by creation date in magento 

<?php 
$todayDate  = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
$collection = Mage::getModel('catalog/product')
                    ->getCollection()                    
                    ->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', 'desc')
                    ->addAttributeToSort('created_at', 'desc');

Comments

Post a Comment

Popular posts from this blog

Category Name with Products in Cart Page Magento

Modify Your Cart.phtml <div class="cart">     <div class="page-title title-buttons">         <h1><?php echo $this->__('Shopping Cart') ?></h1>         <?php if(!$this->hasError()): ?>         <ul class="checkout-types">         <?php foreach ($this->getMethods('top_methods') as $method): ?>             <?php if ($methodHtml = $this->getMethodHtml($method)): ?>             <li><?php echo $methodHtml; ?></li>             <?php endif; ?>         <?php endforeach; ?>         </ul>         <?php endif; ?>     </div>     <?php echo $this->getMessagesBlock()->getGroupedHtml() ?>   ...
Read more

Safe name of a file by php

 function filename_safe($filename) {     $temp = $filename;      // Lower case     $temp = strtolower($temp);         // Replace spaces with a "_"     $temp = str_replace(" ", "_", $temp);         // Loop through string     $result = "";     for ($i=0; $i<strlen($temp); $i++) {     if (preg_match("([0-9]|[a-z]|_)", $temp[$i])) {     $result = $result . $temp[$i];     }     }     // Return filename     return $result;     }         function safe_filename ($filename) {     $search = array(     // Definition of German Umlauts START     "/ß/",     "/ä/","/Ä/",     "/ö/","/Ö/",     "/ü/","/Ü/",     // Definition of German Umlauts ENDE     "([^[:alnum:]_])" // Disallow: Not alphanumeric...
Read more

Sort Products by popularity count in Magento

Advance shorting option for category/list page in magento Note: Please Make  folder structure app/code/local  and place all files in same structure in this folder ,If you make changes in core files its your risk.please make proper backup for core files if you modify that . Step -1. For Advance shorting option you have to create new collection by overriding Collection class. Overrride the collection class(/app/code/core/Mage/Catalog/Model/Resource/Product/collection.php and create a new function <?php   public function sortByReview ( $dir ){ $table = $this -> getTable ( 'review/review' ); $entity_code_id = Mage :: getModel ( 'review/review' ) -> getEntityIdByCode (Mage_Rating_Model_Rating :: ENTITY_PRODUCT_CODE );    $cond = $this -> getConnection () -> quoteInto ( 't2.entity_pk_value = e.entity_id and ' , '' ) . $this -> getConnection () -> quoteInto ( 't2.entity_id = ? ' , $entity_code_id );    $this -...
Read more