Add a Custom Column in `sales_flat_order_grid` by Layout Update

<layout version="0.1.0">
    <add_order_grid_column_handle>
        <reference name="sales_order.grid">
            <action method="addColumnAfter">
                <columnId>skus</columnId>
                <arguments module="extendedsales" translate="header">
                    <header>SKUs</header>
                    <index>skus</index>
                </arguments>
                <after>status</after>
            </action>
        </reference>
    </add_order_grid_column_handle>

    <!-- Grid Reset -->
    <adminhtml_sales_order_index>
        <update handle="add_order_grid_column_handle" />
    </adminhtml_sales_order_index>

    <!-- Grid Filter -->
    <adminhtml_sales_order_grid>
        <update handle="add_order_grid_column_handle" />
    </adminhtml_sales_order_grid>
</layout>

Join a Column in Another Table with Observer

to do

magento.stackexchange.com

kiatng

Say thanks

Last edit

8 months ago

kiatng

validation.js

/*
* Really easy field validation with Prototype
* http://tetlaw.id.au/view/javascript/really-easy-field-validation
* Andrew Tetlaw
* Version 1.5.4.1 (2007-01-05)
*
* Copyright (c) 2007 Andrew Tetlaw
* Permission is hereby granted, free of c...

Form Field

A sample of different options to add field in Mage_Adminhtml_Block_Widget_Form

Ref Varien_Data_Form_Element_Abstract lib\Varien\Data\Form\Element\Abstract.php

Add Suffix to Element Names

$form = new Varien_Data_Form(['field_name_...

Add Custom API

Define the API in the custom module app\code\local\{vendor}\{module}\etc\api.xml:

<config>
    <api>
        <resources>
            <member translate="title" module="benefit">
                <model>benefit/api_member</model>
          ...

How to use cache in OpenMage / Magento 1.x to speed things up

Mechanism: cache in model

First, save the cache

// app\code\core\Mage\Core\Model\App.php Mage_Core_Model_App
/**
 * Saving cache data
 *
 * @param   mixed $data
 * @param   string $id
 * @param   array $tags
 * @param null|false|int ...

addExpressionFieldToSelect and GROUP BY

$t1 = Mage::getResourceModel('accountpayment/ledger_collection')
          ->addExpressionFieldToSelect('maxid', 'MAX({{id}})', 'id');
$t1->getSelect()->group(array('owner_id', 'name'));
$result['t1'] = $t1->getSelect()->__toString();

...

Add new input type in product custom options

custom module productcoption
config.xml

<config>
    <modules>
        <Somemod_ProductCoption>
            <version>0.0.1</version>
        </Somemod_ProductCoption>
    </modules>
    <global> 
        <resources>
            <productcopti...

Adminhtml JSON Response Body

HTML

public function visibleProductsAction()
{
    $this->getResponse()->setBody(
        $this->getLayout()->createBlock('module/adminhtml_block_type')->toHtml()
    );
}

Generic Block:

$block = $this->getLayout()->createBloc...

Posted by kiatng to OpenMage (2023-09-27 13:25)

Add A Grid Column by Layout Update and Observer

Add a Custom Column in sales_flat_order_grid by Layout Update

Join a Column in Another Table with Observer

Related cards:

Column Types

Add Suffix to Element Names

Mechanism: cache in model

First, save the cache

Adding Another Table to the Query with JOIN

HTML

Add a Custom Column in `sales_flat_order_grid` by Layout Update