Yet Another Programmer's Blog

How to get payment method in Magento?

October 20, 2011 by blastar·0 Comments

Just call:

$payment = $order->getPayment()->getMethodInstance()->getTitle();

How to get country name from country ID in Magento?

October 20, 2011 by blastar·2 Comments

This one is quite simple:

$countryName = Mage::getModel(’directory/country’)->load($country_id)->getName();

How to fix broken serialized string in php?

October 18, 2011 by blastar·2 Comments

From time to time previously serialized array will get broken. The most common problem occurs when string length is invalid so instead of

a:2:{i:758;s:4:"test";i:759;s:4:"test";}

1	a:2:{i:758;s:4:"test";i:759;s:4:"test";}

you have

a:2:{i:758;s:4:"test";i:759;s:9:"test";}

1	a:2:{i:758;s:4:"test";i:759;s:9:"test";}

becouse someone edited something directly in db, in this case to make php unserialize() function to work again, just do this magic:

$data = html_entity_decode($data, ENT_QUOTES, 'UTF-8');
$data = preg_replace('!s:(\d+):&quot;(.*?)&quot;;!e', &quot;'s:'.strlen('$2').':\&quot;$2\&quot;;'&quot;, $data );
$data = unserialize($data);

$data = html_entity_decode($data, ENT_QUOTES, 'UTF-8');

$data = preg_replace('!s:(\d+):"(.*?)";!e', "'s:'.strlen('$2').':\"$2\";'", $data );

$data = unserialize($data);

and you will get all strings lenths to be fixed again.

iOS throws: “sgx error: background gpu access not permitted”

October 11, 2011 by blastar·0 Comments

Well, this one can be really painful. But solution is simple, just make sure you are stopping every OpenGL AND sound activity in applicationWillResignActive function, not in applicationDidEnterBackground (becouse it’s too late, app is already in background and no OpenGL/Sound is allowed, you can add playing sounds in background into plist but OpenGL won’t be allowed anyway).

Sorting custom collection in Magento

October 9, 2011 by blastar·5 Comments

It seems to be trivial, but it’s not. If you want to use custom table and custom model, and sort collection by one of your table’s column, you can’t just use addAttributeToSort as you do with native Magento collection (like “catalog/product”). Instead of this, you should use setOrder, so your code should look like this:

$items = Mage::getModel('module/model')
         ->getCollection()
         ->setOrder('date_added', 'DESC')
         ->addFieldToFilter('category_id', array('eq' => $category_id))
         ->setPageSize($pageSize)
         ->setCurPage($currentPage);

$items = Mage::getModel('module/model')

->getCollection()

->setOrder('date_added', 'DESC')

->addFieldToFilter('category_id', array('eq' => $category_id))

->setPageSize($pageSize)

->setCurPage($currentPage);

How to check if product is in stock in Magento?

October 1, 2011 by blastar·0 Comments

Well, that is pretty simple but in case someone will need this, just:

$product = Mage::getModel('catalog/product')->load(123);
$inStock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($product)->getIsInStock();

1 2	$product = Mage::getModel('catalog/product')->load(123); $inStock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($product)->getIsInStock();

How to create Magento shipment programmaticaly?

September 8, 2011 by blastar·0 Comments

In case someone will need this, it’s quite simple:

$order = Mage::getModel('sales/order')->load( 1234 );
$shipment = Mage::getModel('sales/service_order', $order)->prepareShipment(array());
$shipment->register();
$shipment->getOrder()->setCustomerNoteNotify(false);
$shipment->getOrder()->setIsInProcess(true);
$transactionSave = Mage::getModel('core/resource_transaction')->addObject($shipment)->addObject($shipment->getOrder())->save();

$order = Mage::getModel('sales/order')->load( 1234 );

$shipment = Mage::getModel('sales/service_order', $order)->prepareShipment(array());

$shipment->register();

$shipment->getOrder()->setCustomerNoteNotify(false);

$shipment->getOrder()->setIsInProcess(true);

$transactionSave = Mage::getModel('core/resource_transaction')->addObject($shipment)->addObject($shipment->getOrder())->save();

Magento FACT Finder export

August 24, 2011 by blastar·0 Comments

Preparing such export is quite easy, so let’s begin with adding new button in products listing:

in app/code/core/Mage/Adminhtml/Block/Catalog/Product.php in _prepareLayout() function add such code:

$this->_addButton('export_fact', array(
    'label'   => Mage::helper('catalog')->__('FACT-Finder'),
    'onclick' => "setLocation('{$this->getUrl('*/*/exportfact')}')",
    'class'   => 'add'
));

$this->_addButton('export_fact', array(

'label' => Mage::helper('catalog')->__('FACT-Finder'),

'onclick' => "setLocation('{$this->getUrl('*/*/exportfact')}')",

'class' => 'add'

));

then in app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php add new function:

public function exportfactAction()
{
    $productCollection = Mage::getModel('catalog/product')->getCollection();

    $csv = '"ProductID";"ProductName";"Description";"Price"'."\n";

    foreach ($productCollection as $item)
    {
        $data = $item->getData();

        $product = Mage::getModel('catalog/product')->load($data['entity_id']);

        $csv.= '"'.sprintf("%09d", $product->getId()).'";"'.$product->getName().'";"'. strip_tags($product->getShortDescription() ).'";"'.sprintf("%.2f", $product->getPrice()).'"'."\n";
    }
    $this->_prepareDownloadResponse('fact.csv', $csv);
}

public function exportfactAction()

{

$productCollection = Mage::getModel('catalog/product')->getCollection();

$csv = '"ProductID";"ProductName";"Description";"Price"'."\n";

foreach ($productCollection as $item)

{

$data = $item->getData();

$product = Mage::getModel('catalog/product')->load($data['entity_id']);

$csv.= '"'.sprintf("%09d", $product->getId()).'";"'.$product->getName().'";"'. strip_tags($product->getShortDescription() ).'";"'.sprintf("%.2f", $product->getPrice()).'"'."\n";

}

$this->_prepareDownloadResponse('fact.csv', $csv);

}

and thats all. You will get new button with export ability.

How to sort Magento products by date added as default

July 29, 2011 by blastar·9 Comments

Today I had to change Magento default products list sorting to sort by product’s date. In fact we don’t need to sort by date, just by entity_id which is product ID in Magento world. To accomplish this, we need to edit /app/code/core/Mage/Catalog/Block/Product/List.php

You have to find _beforeToHtml() function and change some things inside. First we need to define all available sorting options:

$orders = array('entity_id' => $this->__('Newest'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );

1	$orders = array('entity_id' => $this->__('Newest'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );

then remove all getters of default sorting and order, and put those:

$toolbar->setAvailableOrders($orders);
$toolbar->setDefaultOrder('entity_id');
$toolbar->setDefaultDirection('desc');

$toolbar->setAvailableOrders($orders);

$toolbar->setDefaultOrder('entity_id');

$toolbar->setDefaultDirection('desc');

so finally your _beforeToHtml() should looks like this one:

protected function _beforeToHtml()
{

    $toolbar = $this->getToolbarBlock();

    // called prepare sortable parameters
    $collection = $this->_getProductCollection();

    // use sortable parameters
    $orders = array('entity_id' => $this->__('Newest'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );
    $toolbar->setAvailableOrders($orders);

    $toolbar->setDefaultOrder('entity_id');

    $toolbar->setDefaultDirection('desc');

    if ($modes = $this->getModes()) {
        $toolbar->setModes($modes);
    }

    // set collection to tollbar and apply sort
    $toolbar->setCollection($collection);

    $this->setChild('toolbar', $toolbar);
    Mage::dispatchEvent('catalog_block_product_list_collection', array(
        'collection'=>$this->_getProductCollection(),
    ));

    $this->_getProductCollection()->load();
    Mage::getModel('review/review')->appendSummary($this->_getProductCollection());
    return parent::_beforeToHtml();
}

protected function _beforeToHtml()

{

$toolbar = $this->getToolbarBlock();

// called prepare sortable parameters

$collection = $this->_getProductCollection();

// use sortable parameters

$orders = array('entity_id' => $this->__('Newest'), 'name' => $this->__('Name'), 'price' => $this->__('Price') );

$toolbar->setAvailableOrders($orders);

$toolbar->setDefaultOrder('entity_id');

$toolbar->setDefaultDirection('desc');

if ($modes = $this->getModes()) {

$toolbar->setModes($modes);

}

// set collection to tollbar and apply sort

$toolbar->setCollection($collection);

$this->setChild('toolbar', $toolbar);

Mage::dispatchEvent('catalog_block_product_list_collection', array(

'collection'=>$this->_getProductCollection(),

));

$this->_getProductCollection()->load();

Mage::getModel('review/review')->appendSummary($this->_getProductCollection());

return parent::_beforeToHtml();

}

How to get Magento categories with full paths

July 24, 2011 by blastar·9 Comments

Maybe someone will need it, so here we go with code:

echo "<pre>";
$category = Mage::getModel('catalog/category');
$tree = $category->getTreeModel();
$tree->load();

$ids = $tree->getCollection()->getAllIds();
$categories = array();
if ($ids)
{
    foreach ($ids as $id)
    {
        $category->load($id);
        $categories[$id]['name'] = $category->getName();
        $categories[$id]['path'] = $category->getPath();
    }
    foreach ($ids as $id)
    {
        $path = explode('/', $categories[$id]['path']);
        $string = '';
        foreach ($path as $pathId)
        {
            $string.= $categories[$pathId]['name'] . ' > ';
            $cnt++;
        }
        $string.= ';' . $id . "\n";

        echo $string;
    }
}

echo "<pre>";

$category = Mage::getModel('catalog/category');

$tree = $category->getTreeModel();

$tree->load();

$ids = $tree->getCollection()->getAllIds();

$categories = array();

if ($ids)

{

foreach ($ids as $id)

{

$category->load($id);

$categories[$id]['name'] = $category->getName();

$categories[$id]['path'] = $category->getPath();

}

foreach ($ids as $id)

{

$path = explode('/', $categories[$id]['path']);

$string = '';

foreach ($path as $pathId)

{

$string.= $categories[$pathId]['name'] . ' > ';

$cnt++;

}

$string.= ';' . $id . "\n";

echo $string;

}

the snippet above will give you such output:

root category 1 ; 1
root category 1 > subcategory 1 ; 2
root category 1 > subcategory 1 > subsubcategory 1 ; 3
root category 1 > subcategory 1 > subsubcategory 2 ; 4
root category 1 > subcategory 2 ; 5
root category 1 > subcategory 2 > subsubcategory 1 ; 6