Grid Model – How to Change Value from Specific Collection

gridmodel

I can get from collection "sales/order" customer ids, but when customer is unregistered, value is "null". What can I do to show in grid which customer is registered, with filter "true" or "false". My code:

    protected function _prepareCollection()
    {    
        $collection = Mage::getModel('sales/order')->getCollection()
                        ->addAttributeToSelect('customer_id');
                foreach($collection as $coll)
                {
                    if ($coll['customer_id'] != '')
                    {
                        $coll['customer_id'] = 'yes';
                    }else{
                        $coll['customer_id'] = 'no';
                    }
                }
    ...

    protected function _prepareColumns()
    {
        $this->addColumn("customer_id", array(
                "header" => Mage::helper("mymodule")->__("Registered"),
                'type' => 'options',
                'options' => array(
                        'yes' => 'True',
                        'no' => 'False'
                    ),
                "index" => "customer_id",
            ));
     ...

This option was destroy grid filter. Is any better solution?

Best Answer

Instead of trying to force a display value based on customer id (which is pre-maturley loading the collection, having the result that your filters are not applied) you could instead add a new row to the grid based on customer_is_guest.

Something like this maybe.

protected function _prepareCollection()
{    
    $collection = Mage::getModel('sales/order')->getCollection()
                    ->addAttributeToSelect('customer_is_guest');
...

protected function _prepareColumns()
{
    $this->addColumn("customer_is_guest", array(
            "header" => Mage::helper("mymodule")->__("Is Guest"),
            'type' => 'options',
            'options' => array(
                    'yes' => 'True',
                    'no' => 'False'
                ),
            "index" => "customer_is_guest",
        ));
 ...

Related Solutions

How to Add Filterable ‘Manage Stock’ Column to Catalog Admin Grid

Try replacing the line

 $collection->addAttributeToSelect('manage_stock');

with

        $collection->joinField('manage_stock',
            'cataloginventory/stock_item',
            'manage_stock',
            'product_id=entity_id',
            '{{table}}.stock_id=1',
            'left');

Your _prepareColumns function should look like this

protected function _prepareColumns(){
    $this->addColumn('manage_stock', array(
           'header'=> Mage::helper('catalog')->__('Manage Stock'),
           'index' => 'manage_stock',
           'type'  => 'options',
           'options' => array (
                           '0' =>  Mage::helper('core')->__('No'), 
                           '1' =>  Mage::helper('core')->__('Yes'),
                        )
    ));
    return parent::_prepareColumns();
}

Magento – How to get attribute value from order item by SQL

I have solved it by changing the addOrderedQty() function:

public function addOrderedQty($from = '', $to = '')
{
    $adapter              = $this->getConnection();
    $compositeTypeIds     = Mage::getSingleton('catalog/product_type')->getCompositeTypes();
    $orderTableAliasName  = $adapter->quoteIdentifier('order');

    $orderJoinCondition   = array(
        $orderTableAliasName . '.entity_id = order_items.order_id',
        $adapter->quoteInto("{$orderTableAliasName}.state <> ?", Mage_Sales_Model_Order::STATE_CANCELED),

    );

    $productJoinCondition = array(
        $adapter->quoteInto('(e.type_id NOT IN (?))', $compositeTypeIds),
        'e.entity_id = order_items.product_id',
        $adapter->quoteInto('e.entity_type_id = ?', $this->getProductEntityTypeId())
    );

    if ($from != '' && $to != '') {
        $fieldName            = $orderTableAliasName . '.created_at';
        $orderJoinCondition[] = $this->_prepareBetweenSql($fieldName, $from, $to);
    }

    $this->getSelect()->reset()
        ->from(
            array('order_items' => $this->getTable('sales/order_item')),
            array(
                'ordered_qty' => 'SUM(order_items.qty_ordered)',
                'order_items_name' => 'order_items.name',
                'total_price' => '(order_items.qty_ordered * order_items.price)',
                'total_profit' => '(order_items.qty_ordered * order_items.price) - (order_items.qty_ordered * order_items.base_cost)'
            ))
        ->joinInner(
            array('order' => $this->getTable('sales/order')),
            implode(' AND ', $orderJoinCondition),
            array())
        ->joinLeft(
            array('e' => $this->getProductEntityTableName()),
            implode(' AND ', $productJoinCondition),
            array(
                'entity_id' => 'order_items.product_id',
                'entity_type_id' => 'e.entity_type_id',
                'attribute_set_id' => 'e.attribute_set_id',
                'type_id' => 'e.type_id',
                'sku' => 'e.sku',
                'has_options' => 'e.has_options',
                'required_options' => 'e.required_options',
                'created_at' => 'e.created_at',
                'updated_at' => 'e.updated_at'
            ))
        ->where('parent_item_id IS NULL')
        ->group('order_items.product_id')
        ->having('SUM(order_items.qty_ordered) > ?', 0);
    return $this;
}

Best Answer

Related Solutions

How to Add Filterable ‘Manage Stock’ Column to Catalog Admin Grid

Magento – How to get attribute value from order item by SQL

Related Topic