CodersKick – Coders Paradise

Magento-Get Page type

By saurabh | December 4, 2013

<?php
 $pageIdentifier = Mage::app()->getFrontController()->getAction()->getFullActionName();
?>

<?php

$pageIdentifier = Mage::app()->getFrontController()->getAction()->getFullActionName();

Magento getting a products rewritten URL

By saurabh | December 4, 2013

Magento getting a products rewritten URL To get the request path of a single product you can do this:

<?php
$oProduct = Mage::getModel('catalog/product')->load($productId);
var_dump(
    $oProduct->getUrlPath()
);

To get the target path, you can use this:

$oProduct = Mage::getModel('catalog/product')->load($productId);
$oRewrite = Mage::getModel('core/url_rewrite')->loadByRequestPath(
    $oProduct->getUrlPath()
);
var_dump(
    $oRewrite->getTargetPath()
); ?>

<?php

$oProduct = Mage::getModel('catalog/product')->load($productId);

var_dump(

$oProduct->getUrlPath()

);

To get the target path, you can use this:

$oProduct = Mage::getModel('catalog/product')->load($productId);

$oRewrite = Mage::getModel('core/url_rewrite')->loadByRequestPath(

$oProduct->getUrlPath()

);

var_dump(

$oRewrite->getTargetPath()

); ?>

Similarly Request path by Id Path

 <?php $oProduct = Mage::getModel('catalog/product')->load($_product->getId());            
                    $oRewrite = Mage::getModel('core/url_rewrite')->loadByIdPath($oProduct->getCanonicalUrl());
                    $pageIdentifier = Mage::app()->getFrontController()->getAction()->getFullActionName();
                    if($pageIdentifier=='catalogsearch_result_index'){?>

<?php $oProduct = Mage::getModel('catalog/product')->load($_product->getId());

$oRewrite = Mage::getModel('core/url_rewrite')->loadByIdPath($oProduct->getCanonicalUrl());

$pageIdentifier = Mage::app()->getFrontController()->getAction()->getFullActionName();

if($pageIdentifier=='catalogsearch_result_index'){?>

Mysql-Available Joins in Mysql

The following joins are completely supported by MySQL and can be used with all available MySQL versions provided by web hosting companies. INNER JOIN / JOIN CROSS JOIN OUTER JOIN LEFT OUTER JOIN / LEFT JOIN RIGHT OUTER JOIN / RIGHT JOIN STRAIGHT JOIN NATURAL JOIN

Magento-Get un-associated attribues value in

By saurabh | November 1, 2013


<?php 
$attributes = Mage::getSingleton('eav/config')
    ->getEntityType(Mage_Catalog_Model_Product::ENTITY)->getAttributeCollection();
foreach ($attributes as $attr) {
    /* @var $attr Mage_Eav_Model_Entity_Attribute */
    // get the store label value
             $label = $attr->getFrontendLabel();
             $label = $attr->getAttributeCode();
             $label = $attr->getDefaultValue();    
}
?>

<?php

$attributes = Mage::getSingleton('eav/config')

->getEntityType(Mage_Catalog_Model_Product::ENTITY)->getAttributeCollection();

foreach ($attributes as $attr) {

/* @var $attr Mage_Eav_Model_Entity_Attribute */

// get the store label value

$label = $attr->getFrontendLabel();

$label = $attr->getAttributeCode();

$label = $attr->getDefaultValue();

}

Magento-Custom email when order status changed

By saurabh | October 23, 2013

Create a file /app/etc/modules/Namespace_Custmail.xml with following content:

<config>
    <modules>
        <Namespace_Custmail>
            <active>true</active>
community
        </Namespace_Custmail>
    </modules>
</config>

<Namespace_Custmail>

community

</Namespace_Custmail>

</modules>

</config>

Create file /app/code/community/Namespace/Custmail/etc/config.xml with following content:

<config>
    <modules>
        <Namespace_Custmail>
            <version>1.0.0</version>
        </Namespace_Custmail>
    </modules>
 
    <global>
        <models>
            <custmail>
                <class>Namespace_Custmail</class>
            </custmail>
        </models>
        <events>
            <sales_order_save_commit_after>
                <observers>
                    <mail_status_change>
                        <type>singleton</type>
                        <class>custmail/observer</class>
                        <method>invoicedStatusChange</method>
                    </mail_status_change>
                </observers>
            </sales_order_save_commit_after>
        </events>
        <template>
            <email>
                <custom_order_tpl module="Namespace_Custmail">
                    <label>Status Mail Invoice</label>
                    <file>statusmail_processing.html</file>
                    <type>html</type>
                </custom_order_tpl>
            </email>
        </template>
    </global>
</config>

<Namespace_Custmail>

</Namespace_Custmail>

</modules>

<class>Namespace_Custmail</class>

</custmail>

</models>

<sales_order_save_commit_after>

<mail_status_change>

<type>singleton</type>

<class>custmail/observer</class>

<method>invoicedStatusChange</method>

</mail_status_change>

</observers>

</sales_order_save_commit_after>

</events>

<email>

<custom_order_tpl module="Namespace_Custmail">

<label>Status Mail Invoice</label>

<file>statusmail_processing.html</file>

</custom_order_tpl>

</email>

</template>

</global>

</config>

Create file /app/code/community/Namespace/Custmail/Model/Observer.php with following content:

<?php 
class Namespace_Custmail_Model_Observer
{
    public function invoicedStatusChange($event)
    {
        $order = $event->getOrder();
        $orderStatus = $order->getStatus();
        if ($order->getState() == Mage_Sales_Model_Order::STATE_CANCELED)
            $this->_sendStatusMail($order);
    }
 
    private  function _sendStatusMail($order)
    {
        $emailTemplate  = Mage::getModel('core/email_template');
 
        $emailTemplate->loadDefault('custom_order_tpl');
        $emailTemplate->setTemplateSubject('Your order was holded');
 
        // Get General email address (Admin->Configuration->General->Store Email Addresses)
        $salesData['email'] = Mage::getStoreConfig('trans_email/ident_general/email');
        $salesData['name'] = Mage::getStoreConfig('trans_email/ident_general/name');
 
        $emailTemplate->setSenderName($salesData['name']);
        $emailTemplate->setSenderEmail($salesData['email']);
 
        $emailTemplateVariables['username']  = $order->getCustomerFirstname() . ' ' . $order->getCustomerLastname();
        $emailTemplateVariables['order_id'] = $order->getIncrementId();
        $emailTemplateVariables['store_name'] = $order->getStoreName();
        $emailTemplateVariables['store_url'] = Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);
        $emailTemplate->send($order->getCustomerEmail(), $order->getStoreName(), $emailTemplateVariables);
    }
}?>

<?php

class Namespace_Custmail_Model_Observer

{

public function invoicedStatusChange($event)

{

$order = $event->getOrder();

$orderStatus = $order->getStatus();

if ($order->getState() == Mage_Sales_Model_Order::STATE_CANCELED)

$this->_sendStatusMail($order);

}

private function _sendStatusMail($order)

{

$emailTemplate = Mage::getModel('core/email_template');

$emailTemplate->loadDefault('custom_order_tpl');

$emailTemplate->setTemplateSubject('Your order was holded');

// Get General email address (Admin->Configuration->General->Store Email Addresses)

$salesData['email'] = Mage::getStoreConfig('trans_email/ident_general/email');

$salesData['name'] = Mage::getStoreConfig('trans_email/ident_general/name');

$emailTemplate->setSenderName($salesData['name']);

$emailTemplate->setSenderEmail($salesData['email']);

$emailTemplateVariables['username'] = $order->getCustomerFirstname() . ' ' . $order->getCustomerLastname();

$emailTemplateVariables['order_id'] = $order->getIncrementId();

$emailTemplateVariables['store_name'] = $order->getStoreName();

$emailTemplateVariables['store_url'] = Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);

$emailTemplate->send($order->getCustomerEmail(), $order->getStoreName(), $emailTemplateVariables);

}

}?>

/app/locale/en_US/template/email/statusmail_processing.html

<div>
	<h1>Dear {{var username}}</h1>
	<p>Your order #{{var order_id}} was canceled for some reasons… </p>
	<div>{{var storename}} ({{var store_url}})</div>
</div>

<div>

<h1>Dear {{var username}}</h1>

<p>Your order #{{var order_id}} was canceled for some reasons… </p>

<div>{{var storename}} ({{var store_url}})</div>

</div>

Jquery:Add days in date

By saurabh | October 16, 2013

<code> <script><br /> $(“#x_days”).change(function(){<br /> /* DefaultDateFormat defined in config.php */<br /> ;<br /> var mDate =new Date(2013, 10, 16);<br /> var numberOfDaysToAdd=this.value;<br /> var tomorrow = new Date();<br /> var p =new Date(tomorrow.setDate(mDate.getDate()+parseInt(numberOfDaysToAdd)));<br /> var formated_date=p.getDate()+’/’+(p.getMonth()+1)+’/’+p.getFullYear();<br /> alert(formated_date);<br /> });<br /> <script><br /> </code></p> </script></code>

Jquery:Get selected text of dropdown

By saurabh | September 25, 2013

cb("#shipping-address-select").change(function(){
   txt=cb("#shipping-address-select option:selected").text();
   alert(txt);
});

cb("#shipping-address-select").change(function(){

txt=cb("#shipping-address-select option:selected").text();

alert(txt);

});

MySQL-Select Second highest Salary

By saurabh | September 23, 2013

SELECT salary FROM employee as emp WHERE (2-1) = (SELECT count(*) FROM 
employee as emp2 WHERE emp2.salary > emp.salary)

(OR)

SELECT max(salary) as salary FROM employee WHERE salary < (SELECT max(salary) FROM employee)

(OR)

SELECT salary FROM employee ORDER BY salary DESC LIMIT 1,1

SELECT salary FROM employee as emp WHERE (2-1) = (SELECT count(*) FROM

employee as emp2 WHERE emp2.salary > emp.salary)

(OR)

SELECT max(salary) as salary FROM employee WHERE salary < (SELECT max(salary) FROM employee)

(OR)

SELECT salary FROM employee ORDER BY salary DESC LIMIT 1,1

Magento-Get store/transnational email Addresses

By saurabh | September 17, 2013

General Contact /*Name of Sender */

Mage::getStoreConfig('trans_email/ident_general/name');

1	Mage::getStoreConfig('trans_email/ident_general/name');

/* Email of Sender */

Mage::getStoreConfig('trans_email/ident_general/email');

1	Mage::getStoreConfig('trans_email/ident_general/email');

Sales Representative /*Name of Sender */

Mage::getStoreConfig('trans_email/ident_sales/name');

1	Mage::getStoreConfig('trans_email/ident_sales/name');

/* Email of Sender */

Mage::getStoreConfig('trans_email/ident_sales/email');

1	Mage::getStoreConfig('trans_email/ident_sales/email');

Customer Support /*Name of Sender */

Mage::getStoreConfig('trans_email/ident_support/name');

1	Mage::getStoreConfig('trans_email/ident_support/name');

/* Email of Sender */

Mage::getStoreConfig('trans_email/ident_support/email');

1	Mage::getStoreConfig('trans_email/ident_support/email');

Custom Email 1 /*Name of Sender */

Mage::getStoreConfig('trans_email/ident_custom1/name');

1	Mage::getStoreConfig('trans_email/ident_custom1/name');

/* Email of Sender */

Mage::getStoreConfig('trans_email/ident_custom1/email');

1	Mage::getStoreConfig('trans_email/ident_custom1/email');

Custom Email …

+ Read More

Magento-Add extra fields in Customer registration

By saurabh | September 11, 2013

Open your register.phtml file in magento. if you want to add such as office address fields in your form then insert this line

<div class="field">
                    <label for="offaddress" class="required"><em>*</em><?php echo Mage::helper('contacts')->__('Office Address') ?></label>
                    <div class="input-box">
                        <input name="offaddress" id="offaddress" title="<?php echo Mage::helper('contacts')->__('Office Address') ?>" value="<?php echo $this->escapeHtml($this->getFormData()->getOffaddress()) ?>" class="input-text required-entry" type="text" />
					</div>
            </div>

<label for="offaddress" class="required"><em>*</em><?php echo Mage::helper('contacts')->__('Office Address') ?></label>

<input name="offaddress" id="offaddress" title="<?php echo Mage::helper('contacts')->__('Office Address') ?>" value="<?php echo $this->escapeHtml($this->getFormData()->getOffaddress()) ?>" class="input-text required-entry" type="text" />

</div>

Now to retrieve this field in my account page

<li>
            <label for="offaddress" class="required"><em>*</em><?php echo $this->__('Office Address') ?></label>
            <div class="input-box">
               <input type="text" name="offaddress" id="offaddress" value="<?php echo $this->htmlEscape($this->getCustomer()->getOffaddress()) ?>" title="<?php echo $this->__('Office Address') ?>" class="input-text required-entry validate-email" />
            </div>
        </li>

<li>

<label for="offaddress" class="required"><em>*</em><?php echo $this->__('Office Address') ?></label>

<input type="text" name="offaddress" id="offaddress" value="<?php echo $this->htmlEscape($this->getCustomer()->getOffaddress()) ?>" title="<?php echo $this->__('Office Address') ?>" class="input-text required-entry validate-email" />

</div>

</li>

Now the final step is to create that type of attribute in database for this run this script once in your …

+ Read More