<?php
/**
  * Copyright ETS Software Technology Co., Ltd
 *
 * NOTICE OF LICENSE
 *
 * This file is not open source! Each license that you purchased is only available for 1 website only.
 * If you want to use this file on more websites (or projects), you need to purchase additional licenses.
 * You are not allowed to redistribute, resell, lease, license, sub-license or offer our resources to any third party.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future.
 *
 * @author ETS Software Technology Co., Ltd
 * @copyright  ETS Software Technology Co., Ltd
 * @license    Valid for 1 website (or project) for each purchase of license
 */

if (!defined('_PS_VERSION_')) { exit; }

function add_group_attribute_position()
{
    $groups = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'attribute_group`');
    $pos = 0;
    if (is_array($groups) && count($groups)) {
        $query = '';
        foreach ($groups as $group) {
            $query .= 'UPDATE `' . _DB_PREFIX_ . 'attribute_group` SET `position` = ' . $pos++ . ' WHERE `id_attribute_group` = ' . (int)$group['id_attribute_group'] . ';';
        }
        if ($query)
            Db::getInstance()->execute($query);
    }
}
