Gsyfuy

I built a module to display a variation of the customer grid in the admin that shows select customer attributes and allows for some of them to be editable on the grid. There is also an action column that uses a button to save the updated values on the row. The reason to have individual buttons per row instead of a massaction save is to minimize mistakes that might happen when working with a large grid. This way the user has to pay attention and updates only affect one customer at a time.

I need some guidance on how to actually code the Update button to save just the values of one row. Is it wrapping the row in a form container and treat the row as form and doing a submit? Or passing the input values via Javascript to the button for an onClick function?

Here is what the grid looks like:

This is the Grid.php file:

<?php

class Custom_WholesaleSetup_Block_Adminhtml_Wholesalesetup_Grid extends Mage_Adminhtml_Block_Widget_Grid {



    /**

     * Custom_WholesaleSetup_Block_Adminhtml_Wholesalesetup_Grid constructor.

     */



    public function __construct()

    {

        parent::__construct();

        $this->setId('wholesalesetupGrid'); // set’s the ID of our grid

        $this->setDefaultSort('customer_since'); // sorting column to use in our grid

        $this->setDefaultDir('DESC'); // sorting order

        $this->setSaveParametersInSession(true); // sets your grid operations in session

        $this->setUseAjax(true);

    }



    protected function _prepareCollection()

    {

        $collection = Mage::getResourceModel('customer/customer_collection')

            ->addNameToSelect()

            ->addAttributeToSelect('email')

            ->addAttributeToFilter('group_id', array('in' => array(5)))

            ->addAttributeToSelect('customer_number')

            ->addAttributeToSelect('aa_new_wholesale_account');

        $this->setCollection($collection);

        return parent::_prepareCollection();

    }



    protected function _prepareColumns()

    {

        $this->addColumn('entity_id', array(

            'header'    => Mage::helper('wholesalesetup')->__('ID'),

            'width'     => '50px',

            'index'     => 'entity_id',

            'type'      => 'number'

        ));



        $this->addColumn('customer_since', array(

            'header'    => Mage::helper('wholesalesetup')->__('Registered Date'),

            'type'      => 'datetime',

            'align'     => 'left',

            'index'     => 'created_at',

            'gmtoffset' => true,

            'width'     => '200px'

        ));



        $this->addColumn('name', array(

            'header'    => Mage::helper('wholesalesetup')->__('Name'),

            'index'     => 'name'

        ));



        $this->addColumn('email', array(

            'header'    =>  Mage::helper('wholesalesetup')->__('Email'),

            'align'     =>  'left',

            'index'     =>  'email'

        ));



        $groups = Mage::getResourceModel('customer/group_collection')

            ->addFieldToFilter('customer_group_id', array('gt'=> 0))

            ->load()

            ->toOptionHash();



        $this->addColumn('group_id', array(

            'header'    =>  Mage::helper('wholesalesetup')->__('Customer Group'),

            'width'     =>  '100px',

            'index'     =>  'group_id',

            'renderer'  =>  new Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Dropdown,

            'type'      =>  'options',

            'options'   =>  $groups

        ));



        $this->addColumn('customer_number', array(

            'header'    => Mage::helper('wholesalesetup')->__('Customer Number'),

            'width'     => '50px',

            'index'     => 'customer_number',

            'type'      => 'input',

            'renderer'  => new Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Inline

        ));



        $attribute = Mage::getModel('eav/config')->getAttribute('customer','aa_new_wholesale_account');

        $options = $attribute->getSource()->getAllOptions(false);

        $values = array();

        foreach ($options as $option){

            $values[$option['value']] = $option['label'];

        }



        $this->addColumn('aa_new_wholesale_account', array(

            'header'    =>  Mage::helper('wholesalesetup')->__('New Wholesale Account?'),

            'width'     =>  '155px',

            'index'     =>  'aa_new_wholesale_account',

            'renderer'  =>  new Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Dropdown,

            'type'      =>  'options',

            'options'   =>  $values

        ));



        $this->addColumn('action', array(

            'header'    =>  Mage::helper('wholesalesetup')->__(''),

            'width'     =>  '100px',

            'index'     =>  'update',

            'renderer'  =>  new Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Button,

            'type'      =>  'action',

            'filter'    =>  false,

            'sortable'  =>  false,

            'align'     =>  'center'

        ));



        $this->addExportType('*/*/exportCsv', Mage::helper('wholesalesetup')->__('CSV'));

        $this->addExportType('*/*/exportXml', Mage::helper('wholesalesetup')->__('Excel XML'));



        return parent::_prepareColumns();

    }



}

Here is the code for the dropdown renderer:

<?php

class Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Dropdown extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Select {



    public function render(Varien_Object $row)

    {

        $name = $this->getColumn()->getName() ? $this->getColumn()->getName() : $this->getColumn()->getId();

        $html = '<select style="width: 155px;" name="' . $this->escapeHtml($name) . '" ' . $this->getColumn()->getValidateClass() . '>';

        $value = $row->getData($this->getColumn()->getIndex());

        if ($name == "aa_new_wholesale_account") {

            $html .= '<option value="0"></option>';

        }

        foreach ($this->getColumn()->getOptions() as $val => $label){

            $selected = ( ($val == $value && (!is_null($value))) ? ' selected="selected"' : '' );

            $html .= '<option value="' . $this->escapeHtml($val) . '"' . $selected . '>';

            $html .= $this->escapeHtml($label) . '</option>';

        }        

        $html .= '</select>';

        return $html;

    }



}

Here is the code for the text field input:

<?php

class Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Inline extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Input {



    public function render(Varien_Object $row)

    {

        $html = parent::render($row);

        return $html;

    }



}

Here is the code for the button (so far):

<?php

class Custom_WholesaleSetup_Block_Adminhtml_Widget_Grid_Column_Renderer_Button extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract {



    public function render(Varien_Object $row)

    {

        $html .= '<button onclick="updateCust('')"> . Mage::helper('wholesalesetup')->__('Update') . '</button>';

        return $html;

    }



}