To create a support ticket, start a search
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:
SQLSelectDataSelect :
return ' , il.specific_action ';
Gris JS on EditCell :
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){});
}
}
onAfterUpdateSQL :
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