February 2013 – CodersKick

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

By saurabh | February 27, 2013

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

<?php
// input is $_product and result is iterating child products
$conf = Mage::getModel('catalog/product_type_configurable')->setProduct($_product);
$col = $conf->getUsedProductCollection()->addAttributeToSelect('*')->addFilterByRequiredOptions();
foreach($col as $simple_product){
    var_dump($simple_product->getId());
}
?>

<?php

// input is $_product and result is iterating child products

$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 Configurable product’s Child products

By saurabh | February 27, 2013

Get Configurable product’s Child products

<?php
// input is $_product and result is iterating child products
$childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null, $product);
?>

<?php

// input is $_product and result is iterating child products

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

Load category by id

By saurabh | February 27, 2013

Load category by id

<?php
$_category = Mage::getModel('catalog/category')->load(89);
$_category_url = $_category->getUrl();
?>

<?php

$_category = Mage::getModel('catalog/category')->load(89);

$_category_url = $_category->getUrl();

Magento-Clear cache/reindex

By saurabh | February 27, 2013

Clear cache/reindex

<?php
// clear cache
Mage::app()->removeCache('catalog_rules_dirty');
// reindex prices
Mage::getModel('index/process')->load(2)->reindexEverything();
/*
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
*/
?>

<?php

// clear cache

Mage::app()->removeCache('catalog_rules_dirty');

// reindex prices

Mage::getModel('index/process')->load(2)->reindexEverything();

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- recently sold Products from the store

By saurabh | February 27, 2013

Get Rectally products in magento, on any page

function getRecently_Sold_Items()
    {
        $storeID = Mage::app()->getStore()->getId();
        $items_Collection = Mage::getResourceModel('sales/order_item_collection') 
                            ->join('order', 'order_id=entity_id') 
                            ->addFieldToFilter('main_table.store_id', array('eq'=>$storeID))
                            ->setOrder('main_table.created_at','desc') 
                            ->setPageSize(20);// this sets limit on collection
        $items_Collection ->getSelect()->group(`main_table`.'product_id');
        $products = array();        
        if(sizeof($items_Collection)>0)
        {
            foreach ($items_Collection as $item) {
                $product = Mage::getModel('catalog/product')->load($item->getProductId());
                $products[] = $product; 
            }    
        } 
        
        return $products;     
            
    }

function getRecently_Sold_Items()

{

$storeID = Mage::app()->getStore()->getId();

$items_Collection = Mage::getResourceModel('sales/order_item_collection')

->join('order', 'order_id=entity_id')

->addFieldToFilter('main_table.store_id', array('eq'=>$storeID))

->setOrder('main_table.created_at','desc')

->setPageSize(20);// this sets limit on collection

$items_Collection ->getSelect()->group(`main_table`.'product_id');

$products = array();

if(sizeof($items_Collection)>0)

{

foreach ($items_Collection as $item) {

$product = Mage::getModel('catalog/product')->load($item->getProductId());

$products[] = $product;

}

return $products;

}

Magento-Remove required from address fields in customer registration form

By saurabh | February 20, 2013

<?php
$t1 = Mage::getModel('eav/entity_attribute')
           ->loadByCode('customer_address', 'city')
           ->setIsRequired(false)
           ->save();
$t2 = Mage::getModel('eav/entity_attribute')
           ->loadByCode('customer_address', 'postcode')
           ->setIsRequired(false)
           ->save();
$t3 = Mage::getModel('eav/entity_attribute')
           ->loadByCode('customer_address', 'street')
           ->setIsRequired(false)
           ->save();
$t4 = Mage::getModel('eav/entity_attribute')
           ->loadByCode('customer_address', 'country_id')
           ->setIsRequired(false)
           ->save();

<?php

$t1 = Mage::getModel('eav/entity_attribute')

->loadByCode('customer_address', 'city')

->setIsRequired(false)

->save();

$t2 = Mage::getModel('eav/entity_attribute')

->loadByCode('customer_address', 'postcode')

->setIsRequired(false)

->save();

$t3 = Mage::getModel('eav/entity_attribute')

->loadByCode('customer_address', 'street')

->setIsRequired(false)

->save();

$t4 = Mage::getModel('eav/entity_attribute')

->loadByCode('customer_address', 'country_id')

->setIsRequired(false)

->save();

Understand mouse event in jquery

By saurabh | February 16, 2013

Understand mouse event in jquery ————————————————

<script>
var s=jQuery.noConflict();
    s(document).ready(function(){ // This sets the opacity of the thumbs to fade down to 60% when the page loads
s(".quickshop").fadeTo("slow", 0.3);
s(".quickover").fadeTo("slow", 0.6);
s(".quickshop").hover(function(){
s(".quickshop").fadeTo("slow", 1.0);
s(".quickover").fadeTo("slow", 1.0);
// This sets the opacity to 100% on hover
},function(){
s(".quickshop").fadeTo("slow", 0.3);
s(".quickover").fadeTo("slow", 0.6); // This sets the opacity back to 60% on mouseout
});
});
</script>

var s=jQuery.noConflict();

s(document).ready(function(){ // This sets the opacity of the thumbs to fade down to 60% when the page loads

s(".quickshop").fadeTo("slow", 0.3);

s(".quickover").fadeTo("slow", 0.6);

s(".quickshop").hover(function(){

s(".quickshop").fadeTo("slow", 1.0);

s(".quickover").fadeTo("slow", 1.0);

// This sets the opacity to 100% on hover

},function(){

s(".quickshop").fadeTo("slow", 0.3);

s(".quickover").fadeTo("slow", 0.6); // This sets the opacity back to 60% on mouseout

});

</script>

Compare two date in php

By saurabh | February 16, 2013

Compare two date ————————–

$exp_date = "2006-01-16";
 $todays_date = date("Y-m-d");
 $today = strtotime($todays_date);
 $expiration_date = strtotime($exp_date);
   if ($expiration_date > $today) { 
     $valid = "yes";
     } else { 
        $valid = "no"; 
    }

$exp_date = "2006-01-16";

$todays_date = date("Y-m-d");

$today = strtotime($todays_date);

$expiration_date = strtotime($exp_date);

if ($expiration_date > $today) {

$valid = "yes";

} else {

$valid = "no";

}

Magento-Load product collection with all attributes by given category id

By saurabh | February 16, 2013

I find that if we simply load category by id ,and try to get product collection ,result array does not contains all attributes . For this we can use “addAttributeToSelect(‘*’);” which return collection with all attributes .:)

<?php
$category = new Mage_Catalog_Model_Category();
  $category->load(112); //112 is cat id
  $_productCollection = $category->getProductCollection();
    $_productCollection->addAttributeToSelect('*');
?>

<?php

$category = new Mage_Catalog_Model_Category();

$category->load(112); //112 is cat id

$_productCollection = $category->getProductCollection();

$_productCollection->addAttributeToSelect('*');

Magento-Load product and category by name,sku and id

By saurabh | February 16, 2013

    <?php 

 // Load by name

    $_category = Mage::getModel('catalog/category')->loadByAttribute('name', 'category_Name');
    $_product = Mage::getModel('catalog/product')->loadByAttribute('name', 'Product_name');
 
 // Load by SKU

    $_product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'your Sku');
    
//Load by ID

    $_product = Mage::getModel('catalog/product')->load($productID);
    $_category = Mage::getModel('catalog/category')->load($category);
?>

<?php

// Load by name

$_category = Mage::getModel('catalog/category')->loadByAttribute('name', 'category_Name');

$_product = Mage::getModel('catalog/product')->loadByAttribute('name', 'Product_name');

// Load by SKU

$_product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'your Sku');

//Load by ID

$_product = Mage::getModel('catalog/product')->load($productID);

$_category = Mage::getModel('catalog/category')->load($category);