Retrieve info from additional field to product list

DeividasJJ Published at Dev

DeividasJJ

I'm using this free module sample to add new video url field to the product. Everything works fine, I can see new data in product.tpl, but I cant get data to product-list.tpl what is very important to me, I want to add play button to each product. I found that for this purpose I have to use hookActionProductListOverride function but no luck with that. Anyone can help me?

public function hookDisplayAdminProductsExtra($params) {
    $id_product = Tools::getValue('id_product');
    $sampleObj = Belvg_Sample::loadByIdProduct($id_product);
    if(!empty($sampleObj) && isset($sampleObj->id)){
        $this->context->smarty->assign(array(
            'belvg_textarea' => $sampleObj->textarea,
        ));
    }

    return $this->display(__FILE__, 'views/admin/sample.tpl');
}

public function hookActionProductUpdate($params) {
    $id_product = Tools::getValue('id_product');
    $sampleObj = Belvg_Sample::loadByIdProduct($id_product);
    $sampleObj->textarea = Tools::getValue('belvg_sample');
    $sampleObj->id_product = $id_product;

    if(!empty($sampleObj) && isset($sampleObj->id)){
        $sampleObj->update();
    } else {
        $sampleObj->add();
    }
}

public function hookDisplayFooterProduct($params) {
    $id_product = Tools::getValue('id_product');
    $sampleObj = Belvg_Sample::loadByIdProduct($id_product);
    if(!empty($sampleObj) && isset($sampleObj->id)){
        $this->context->smarty->assign(array(
            'belvg_textarea' => $sampleObj->textarea,
        ));
    }

    echo $sampleObj->textarea;
}

eapo

Wasn't easy to solve this and can be less ugly, but in my case working like a charm.

After lot of hours spent with the Belvg's module I've used this module, almost the same with same problem, but with language support and more flexibility: http://nemops.com/prestashop-products-new-tabs-fields

Needed to add multiple custom fields, so it's more detailed as the original questions requires:

    // adding more fields
    $sql = 'ALTER TABLE ' . _DB_PREFIX_ . 'product_lang ADD `custom_field1`, `custom_field2` TEXT NOT NULL';
    ...

    // adding argument for the getCustomField() and multiply lines
    $this->context->smarty->assign(array(
        'custom_field1' => $this->getCustomField('custom_field1',(int)Tools::getValue('id_product')),
        'custom_field2' => $this->getCustomField('custom_field2',(int)Tools::getValue('id_product')),
    ...

    // expanding the actionProductUpdatea hook
        if(!Db::getInstance()->update('product_lang', array('custom_field1'=> pSQL(Tools::getValue('custom_field1_'.$lang['id_lang'])),'custom_field2'=> pSQL(Tools::getValue('custom_field2_'.$lang['id_lang']))) ,'id_lang = ' . $lang['id_lang'] .' AND id_product = ' .$id_product ))
    ...

    // this is the missing part!
    // upgrading the getCustomField() function to accept multiple custom fields and registering global vars
public function getCustomField($getKey,$id_product)
{
    $result = Db::getInstance()->ExecuteS('SELECT '.$getKey.', id_lang FROM '._DB_PREFIX_.'product_lang WHERE id_product = ' . (int)$id_product);

    if(!$result)
        return array();

    foreach ($result as $field) {
        $val=$field[$getKey];
        $fields[$field['id_lang']] = $val;
        if(!empty($val)){
            !Configuration::updateValue($getKey, $val);
        }
    }
    return $fields;
}

Calling the $custom_field1 and $custom_field2 in every .tpl working fine like this:

    {if $custom_field1}
        {if isset($custom_field1) && $custom_field1}
            <div>{$custom_field1}</div>
    {/if}
    {if $custom_field2}
        {if isset($custom_field2) && $custom_field2}
            <div>{$custom_field2}</div>
    {/if}

Hope someone also need this. Thank You!

Collected from the Internet

Please contact [email protected] to delete if infringement.