Magento - Tips and Tricks

Download the module from following URL
https://support.ebs.in/app/index.php?/default_import/Knowledgebase/Article/View/226/7/magento-15-ebs-integrationkit-ver-25

Copy the folder Secureebs to magento\app\code\core\Mage\
Copy the file Mage_Secureebs.xml to magento\app\etc\modules\
Copy the folder secureebs to magento\app\design\frontend\base\default\template\
Add the file Mode.php inside magento\app\code\core\Mage\Adminhtml\Model\System\Config\Source\
Enter your Account Id , Secret Key and select the Mode from the EBS Payment Method control panel & Enable it.

Also we can add extra filed in Redirect.php

Posted by Bhoopendra Dwivedi at 3:22 AM 9 comments

Labels: Magento, Payment Gateway

Consider module Bd_Demo and model Test, then
Create System.xml in your module demo/etc
<?xml version="1.0"?>
<config>
<tabs>
<demo module="demo" translate="label">
<label>Tab name</label>
<sort_order>100</sort_order>
</demo>
</tabs>
<sections>
<demosection module="demo" translate="label">
<label>Settings</label>
<tab>demo</tab>
<frontend_type>text</frontend_type>
<sort_order>1000</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<groups>
<demogroup translate="label">
<label>External Datatbase</label>
<frontend_type>text</frontend_type>
<sort_order>100</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!-- New fields go here -->
<demofield translate="label comment">
<label>Test Name</label>
<comment>
<![CDATA[This text appears just beneath the field with a small arrow.
<span class="notice">It can contain HTML formatting too!</span>]]>
</comment>
<frontend_type>text</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</demofield>

</fields>
</demogroup>
</groups>
</demosection>
</sections>
</config>

Then Define ACL in config.xml
<config>
<adminhtml>
<acl>
<resources>
<all>
<title>Allow Everything</title>
</all>
<admin>
<children>
<system>
<children>
<config>
<children>
<demosection>
<title>Demo name</title>
<children>
<demogroup>
<title>Settings</title>
<sort_order>1</sort_order>
</demogroup>

</children>
</<demosection>
</children>
</config>
</children>
</system>
</children>
</admin>
</resources>
</acl>
</adminhtml>
</config>

Also we access the value of this filed as
Mage::getStoreConfig('demosection/demogroup/demofield ');

Also we can define the default value of this filed in config.xml
<config>
<default>
<demosection>
<demogroup>
<model>demo/test</model>
<demofield>Default Value</demofield>
</demogroup>
</demosection>
</default>
</config>

Posted by Bhoopendra Dwivedi at 6:51 AM 1 comments

Labels: Magento

Consider module Bd_Demo and model Test

Add following lines in _prepareMassaction() method of admin grid file
protected function _prepareMassaction()
{
$this->setMassactionIdField('id');
$this->getMassactionBlock()->setFormFieldName('test');
$this->getMassactionBlock()->addItem('delete', array(
'label' => Mage::helper('demo')->__('Delete'),
'url' => $this->getUrl('*/*/massDelete'),
'confirm' => Mage::helper('demo')->__('Are you sure?')
));

return $this;
}

And following method in admin controller
public function massDeleteAction()
{
$webIds = $this->getRequest()->getParam('test');
if(!is_array($webIds)) {
Mage::getSingleton('adminhtml/session')->addError(Mage::helper('adminhtml')->__('Please select item(s)'));
} else {
try {
foreach ($webIds as $webId) {
$web = Mage::getModel('demo/test')->load($webId);
$web->delete();
}
Mage::getSingleton('adminhtml/session')->addSuccess(
Mage::helper('adminhtml')->__(
'Total of %d record(s) were successfully deleted', count($webIds)
)
);
} catch (Exception $e) {
Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
}
}
$this->_redirect('*/*/index');
}

Posted by Bhoopendra Dwivedi at 1:28 AM 0 comments

Labels: Magento, Magento Admin Grid

Consider module Bd_Demo and model Test, then
Add following lines in _prepareColumns() method of admin grid file
$this->addExportType('*/*/exportCsv', Mage::helper('demo')->__('CSV'));
$this->addExportType('*/*/exportXml', Mage::helper('demo')->__('XML'));

And add following methods in admin controller
public function exportCsvAction()
{
$fileName = 'test.csv';
$content = $this->getLayout()->createBlock('demo/adminhtml_test_grid')
->getCsv();

$this->_sendUploadResponse($fileName, $content);
}

public function exportXmlAction()
{
$fileName = 'test.xml';
$content = $this->getLayout()->createBlock('demo/adminhtml_test_grid')
->getXml();

$this->_sendUploadResponse($fileName, $content);
}

protected function _sendUploadResponse($fileName, $content, $contentType='application/octet-stream')
{
$response = $this->getResponse();
$response->setHeader('HTTP/1.1 200 OK','');
$response->setHeader('Pragma', 'public', true);
$response->setHeader('Cache-Control', 'must-revalidate, post-check=0, pre-check=0', true);
$response->setHeader('Content-Disposition', 'attachment; filename='.$fileName);
$response->setHeader('Last-Modified', date('r'));
$response->setHeader('Accept-Ranges', 'bytes');
$response->setHeader('Content-Length', strlen($content));
$response->setHeader('Content-type', $contentType);
$response->setBody($content);
$response->sendResponse();
die;
}

Posted by Bhoopendra Dwivedi at 1:07 AM 5 comments

Labels: Magento, Magento Admin Grid

Consider module 'Bd_Demo' and Model 'Test'
Edit Grid Container File Test.php
public function __construct()
{
$this->_controller = 'adminhtml_test';
$this->_blockGroup = 'test';
$this->_headerText = Mage::helper('demo')->__('Test Manager');
$this->_addButtonLabel = Mage::helper('demo')->__('Add Test');


$this->_addButton('button1', array(
'label' => Mage::helper('demo')->__('Button Label1'),
'onclick' => "setLocation('".$this->getUrl('*/*/button1')."')",

));

$this->_removeButton('add'); // remove Add test button

parent::__construct();
}

Note : button1Action() method must be in admin controller

Posted by Bhoopendra Dwivedi at 12:57 AM 2 comments

Labels: Magento, Magento Admin Grid

Searching/paging and other operations to all work in admin grid using ajax, is built in functionality, only follow following step
In constructor of Grid.php file, add following lines
$this->setSaveParametersInSession(true);
$this->setUseAjax(true);

And in Grid.php add the function
public function getGridUrl()
{
return $this->getUrl('*/*/grid', array('_current'=>true));
}

And in your ControllerNameContrller.php add the action
public function gridAction()
{
$this->loadLayout();
$this->getResponse()->setBody(
$this->getLayout()->createBlock('modulename/adminhtml_modelname_grid')->toHtml()
);
}

Posted by Bhoopendra Dwivedi at 12:37 AM 1 comments

Labels: Magento, Magento Admin Grid

Add the following code to your config.xml under global tag

Consider Bd_test module

<global>

<resources>

<test_write>

<connection>

<use>test_database</use>

</connection>

</test_write>

<test_read>

<connection>

<use>test_database</use>

</connection>

</test_read>

<test_setup>

<connection>

<use>core_setup</use>

</connection>

</test_setup>

<test_database>

<connection>

<host><![CDATA[localhost]]></host>

<username><![CDATA[db_username]]></username>

<password><![CDATA[db_password]]></password>

<dbname><![CDATA[db_name]]></dbname>

<model>mysql4</model>

<type>pdo_mysql</type>

<active>1</active>

</connection>

</test_database>

</resources>

</global>


Get data

$resource = Mage::getSingleton('core/resource');

$conn = $resource->getConnection('test_read');

$results = $conn->query('SELECT * FROM TableName');

print_r($results)

Posted by Bhoopendra Dwivedi at 11:55 AM 2 comments

Labels: Magento

Override folowing file code/core/Mage/Paypal/Model/Standard.php and Replace following code
protected $_canUseForMultishipping = flase; with protected $_canUseForMultishipping = true;

Posted by Bhoopendra Dwivedi at 9:30 AM 1 comments

Labels: Magento

Rename product folder( media/catalog/product) to any name (like custom_product)

You need to change from all media path ‘product’ to ‘products’ to below listed files.

file_exists(Mage::getBaseDir('media').DS.'catalog'.DS.'product'.DS.$size.DS.$image)
to
file_exists(Mage::getBaseDir('media').DS.'catalog'.DS.'custom_product '.DS.$size.DS.$image)

Replace following code 'catalog/product/' to 'catalog/custom_product/' in following files
Product/Attribute/Frontend/Image.php
Product/Attribute/Media/Image.php
Product/Image.php
Product/Media/Config.php
Entity/Product/Attribute/Frontend/Image.php

Posted by Bhoopendra Dwivedi at 9:05 AM 0 comments

Labels: Magento

Override following file /app/Local/Mage/Catalog/Helper/Image.php
and add following code
public function base64_encode_image ($filename=string) {
if ($filename) {

$forFiletype = explode('.',$ filename);
$forFiletype = array_reverse($forFiletype);
$filetype = $forFiletype[0];
if(strtoupper($filetype) == 'JPG')
{
$filetype = 'jpeg';
}
$base64image = '';
$changeFilePath = explode(‘cache’,$filename);
$changeFilePath = Mage::getBaseDir(). DS. ‘media’. DS. ‘catalog’.DS.’products’.DS.’cache’.$changeFilePath[1];
$imgbinary = fread(fopen($changeFilePath, “r”), filesize($changeFilePath));
return ‘data:image/’ . $filetype . ‘;base64,’ . base64_encode($imgbinary);
}
}

Now use in /app/design/catalog/product/list.phtml as
$this->helper('catalog/image')->init($_product, 'small_image')->resize(193,250);
$base64image = $this->helper('catalog/image')->base64_encode_image($product_image,$filetype);
<img src="<?php echo $this->getSkinUrl('images/spacer.png'); ?>" width="193" height="250" alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" style="background:url(<?php echo $base64image;?>) no-repeat;"/>

Posted by Bhoopendra Dwivedi at 8:54 AM 0 comments

Labels: Magento

Add ‘filter_index’=>’main_table.column_name’ in $this->addColumn() function

Posted by Bhoopendra Dwivedi at 8:29 AM 0 comments

Labels: Magento

Use columns() method in collection as
$collection->getSelect()->columns(new Zend_Db_Expr("[expression or any myql sub query] as custom_column"));

For example:

Consider Bd_Test module and override _prepareCollection() method in admin grid

protected function _prepareCollection()
{
$collection = Mage::getModel('test/test')->getCollection();

$collection->getSelect()->columns(new Zend_Db_Expr("if((SELECT count(*) FROM table_name as table_alias WHERE table_alias.column > main_alias. column ) , 'NO', 'YES') as custom_column"));
// echo $collection->getSelect();
$this->setCollection($collection);
return parent::_prepareCollection();
}

Posted by Bhoopendra Dwivedi at 8:19 AM 0 comments

Labels: Magento

Add following script in any template file

<div id="google_translate_element"></div><script>
function googleTranslateElementInit() {
new google.translate.TranslateElement({
pageLanguage: 'en'
}, 'google_translate_element');
}
</script><script src="http://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>

Posted by Bhoopendra Dwivedi at 12:31 PM 0 comments

Labels: Google, Javascript, Magento

Sample text:

Posted by Bhoopendra Dwivedi at 4:46 AM 2 comments

Labels: Javascript