Products with its Combinations Display in Admin

[vjy.kumavat]

Hi all,

 

Can you help to solve my problem regarding Display product combination in admin panel controller ?

 

I did some code for this but in my controller page

 

$this->_select = 'a.id_customer, ml.customer_email, pl.name, GROUP_CONCAT( DISTINCT al.name ) AS product_combination';

$this->_join = 'JOIN '._DB_PREFIX_.'mailalert_customer_oos ml ON (a.id_customer = ml.id_customer)

JOIN '._DB_PREFIX_.'product_lang pl ON (pl.id_product = ml.id_product)

JOIN '._DB_PREFIX_.'product_attribute_combination pac ON (ml.id_product_attribute = pac.id_product_attribute)

JOIN '._DB_PREFIX_.'attribute_lang al ON (pac.id_attribute = al.id_attribute)';

$this->_groupBy = 'ml.id_product_attribute';

 

 

      $this->fields_list = array(

            'id_customer' => array(

                'title' => $this->l('ID'),

                'align' => 'text-center',

                'class' => 'fixed-width-xs',

'filter_key' => 'a!id_customer',

            ),

            'customer_email' => array(

                'title' => $this->l('Customer Email'),

'align' => 'text-center',

                'class' => 'fixed-width-xs',

'filter_key' => 'ml!customer_email',

            ),

            'name' => array(

                'title' => $this->l('Product Name'),

                'align' => 'text-center',

                'filter_key' => 'pl!name',

            ),

           'product_combination' => array(

                'title' => $this->l('Customer'),

                'havingFilter' => true,

'filter_key' => 'al!product_combination',

            )

        );

 

it shows me only one record,

What can i need to with above code 

please help me