Wednesday 28 May 2014

Magento Reindex Programmatically

for($i=1;$i<=9;$i++){
    Mage::getModel('index/process')->load($i)->reindexEverything();
 }

 // where I is

 1 = Product Attributes
 2 = Product Attributes
 3 = Catalog URL Rewrites
 4 = Product Flat Data
 5 = Category Flat Data
 6 = Category Products
 7 = Catalog Search Index
 8 = Tag Aggregation Data
 9 = Stock Status

Magento Clear Cache Programmatically

Mage::app()->cleanCache();

Magento Get Configurable product’s Child products

$_product = Mage::getModel('catalog/product')->load(108);
 $childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null, $_product);

Magento Get Configurable product’s Children’s (simple product) custom attributes

$_product = Mage::getModel('catalog/product')->load(1);
 $conf = Mage::getModel('catalog/product_type_configurable')->setProduct($_product);
 $col = $conf->getUsedProductCollection()->addAttributeToSelect('*')->addFilterByRequiredOptions();
 foreach($col as $simple_product){
     var_dump($simple_product->getId());
 }

Magento Get all Orders Collection Between Two Dates

/* Format our dates */

$fromDate = date('Y-m-d H:i:s', strtotime($fromDate));
$toDate = date('Y-m-d H:i:s', strtotime($toDate));

/* Get the collection */

$orders = Mage::getModel('sales/order')->getCollection()
    ->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate))
    ->addAttributeToFilter('status', array('eq' => Mage_Sales_Model_Order::STATE_COMPLETE));

Magento Sort Category And Sub-category in Alphabetically Order.

Hello all now you can sort category and its sub-categories in alphabetically order without changes in core file.
copy and past following code in any phtml file.


<?php
$cats = Mage::getModel('catalog/category')->load(2)->getChildren();
$catIds = explode(',', $cats);
$categories = array();
$subCategories = array();
foreach ($catIds as $catId) {
    $category = Mage::getModel('catalog/category')->load($catId);
    $categories[$category->getName()] = $category->getUrl();

    $subcats = Mage::getModel('catalog/category')->load($catId)->getChildren();
    $subcatIds = explode(',', $subcats);
    if ($subcats) {
        foreach ($subcatIds as $subcatId) {
            $subCategory = Mage::getModel('catalog/category')->load($subcatId);
            $subCategories[$category->getName()][$subCategory->getName()] = $subCategory->getUrl();
        }
        ksort($subCategories[$category->getName()], SORT_STRING);
    }
}
ksort($categories, SORT_STRING);
?>                               
<div id="leftmenu" class="block block-nav">
<div class="block-title"><strong><span>Kunstnerartikler</span></strong></div>
<div class="block-content">
     <ul>
    <?php foreach ($categories as $name => $url): ?>
     <li>
         <?php $_category = Mage::getModel('catalog/category')->loadByAttribute('name',$name); ?>
         <?php if($_category->getChildren()) { ?>
          <div class="navhead"><p class="cursor"><?php echo $name; ?> </div>
         <?php }  else { ?>
          <div class="navhead2"><p>
          <a href="<?php echo $url; ?>"><?php echo $name; ?></a>
              </p>
          </div>
         <?php } ?>
         <?php foreach ($subCategories as $key => $values) { if($name == $key) { echo '';  ?>
         <div class="navcontent">
        <ul>
       <?php foreach($values as $subName => $subUrl) { ?>
    <li class="menusub lige"><strong>&bull;
        <a href="<?php echo $subUrl ?>" >
            <?php echo $subName; ?>
        </a>
        </strong>
    </li>
        <?php }
        ?>        </ul>
      </div> <?php
        echo ""; } } ?>
     </li>
    <?php endforeach; ?>
     </ul>
    </div>
</div>

Magento Add Images to Product Attribute Options.

Hello all you can download module for adding images in product attribute in following link.

https://github.com/aligent/magento-attribute-option-image