Images Grid: Adding a field from image_lang table (editable)

Prerequisites:

- Store Commander version 2014-03-12 (minimum)
- SC Grids Editor Pro Add-on - version 1.0 (minimum)
- The field needs to exist in your database
- The field needs to exist in PrestaShop Product Class to be used in your Front Office templates (optional) 

Target:

We would like to add the field 'specific action' stored in ps_image_lang table

Setup:

To add the field to the list of available fields for your images grids, click on the  in the 'Add a field' panel and enter the following information:

What is the field ID?: specific_action (should be exactly the name as it is in the database).

• SC creates the field, you now need to populate the grid with:

Field name: Specific Action

Table: enter: special

Type: editable

• From the Advanced Properties panel:

return ' , il.specific_action';

idx_specific_action = prop_tb._imagesGrid.getColIndexById('specific_action');
if (stage == 2) {
    if (cInd == idx_specific_action) {
        $.post("index.php?ajax=1&act=cat_image_update&action=update&id_lang=" + SC_ID_LANG + "&" + new Date().getTime(), {
            'id_product': lastProductSelID,
            col: 'specific_action',
            val: nValue.replace(/#/g, ''),
            'list_id_image': prop_tb._imagesGrid.getSelectedRowId()
        }, function (data) {
        });
    }
}

if ($col == 'specific_action') {
    $sql = "UPDATE " . _DB_PREFIX_ . "image_lang SET specific_action = " . pSQL($val) . " WHERE id_image=" . intval($id_image) . " AND id_lang =" . intval($id_lang) . "";
    Db::getInstance()->Execute($sql);
}

• Exit the editing window and add the field to your grids