static public function getAttributes($id_lang, $notNull = false)
{
  $result=Db::getInstance()->ExecuteS('
  SELECT ag.*, agl.*, a.`id_attribute`, al.`name`, agl.`name` AS `attribute_group`
  FROM `'._DB_PREFIX_.'attribute_group` ag
  LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = '.intval($id_lang).')
  LEFT JOIN `'._DB_PREFIX_.'attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group`
  LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = '.intval($id_lang).')
  '.($notNull ? 'WHERE a.`id_attribute` IS NOT NULL AND al.`name` IS NOT NULL' : '').'
  ORDER BY agl.`name` ASC, al.`name` ASC');
  
        foreach ($result AS &$row)
        {
            $row['name'] = Category::hideCategoryPosition($row['name']);
        }  
return $result;
}

public function getAttributeCombinaisons($id_lang)
    {
        $result=Db::getInstance()->ExecuteS('
        SELECT pa.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, pa.`unity_price_impact`
        FROM `'._DB_PREFIX_.'product_attribute` pa
        LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
        LEFT JOIN `'._DB_PREFIX_.'attribute` a ON a.`id_attribute` = pac.`id_attribute`
        LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
        LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = '.intval($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = '.intval($id_lang).')
        WHERE pa.`id_product` = '.intval($this->id).'
        ORDER BY pa.`id_product_attribute`');
        foreach ($result AS &$row)
        {
            $row['attribute_name'] = Category::hideCategoryPosition($row['attribute_name']);
        }  
return $result;
}

static public function getProductsProperties($id_lang, $query_result)
    {
        $resultsArray = array();
        foreach ($query_result AS $row)
            if ($row2 = Product::getProductProperties($id_lang, $row))
                $resultsArray[] = $row2;
        return $resultsArray;
    }

    /*
    * Select all features for a given language
    *
    * @param $id_lang Language id
    * @return array Array with feature's data
    */
/*     MODIF DE STRATIC PUBLIC FUNCTION
    static public function getFrontFeaturesStatic($id_lang, $id_product)
    {
        return Db::getInstance()->ExecuteS('
        SELECT name, value, pf.id_feature
        FROM '._DB_PREFIX_.'feature_product pf
        LEFT JOIN '._DB_PREFIX_.'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '.intval($id_lang).')
        LEFT JOIN '._DB_PREFIX_.'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '.intval($id_lang).')
        WHERE pf.id_product = '.intval($id_product));
    }
    */
/* MODIF ON TRIE LES CARACTERISTISQUES PERSO via 01; 02; 03, etc. */
static public function getFrontFeaturesStatic($id_lang, $id_product)
    {
        $result=Db::getInstance()->ExecuteS('
        SELECT name, value, pf.id_feature
        FROM '._DB_PREFIX_.'feature_product pf
        LEFT JOIN '._DB_PREFIX_.'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '.intval($id_lang).')
        LEFT JOIN '._DB_PREFIX_.'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '.intval($id_lang).')
        WHERE pf.id_product = '.intval($id_product).' order by name');

       $resultsArray = array();
        foreach ($result AS $row)
        {
            $row['name'] = product::hideFeaturePosition($row['name']);
            $resultsArray[] = $row;
        }
        return $resultsArray;
    }


    static public function hideFeaturePosition($name)
    {
        return preg_replace('/^[0-9]+\./', '', $name);
    }
/* FIN MODIF */
    public function getFrontFeatures($id_lang)
    {
        return self::getFrontFeaturesStatic($id_lang, $this->id);
    }

    static public function getAttachmentsStatic($id_lang, $id_product)
    {
        return Db::getInstance()->ExecuteS('
        SELECT *
        FROM '._DB_PREFIX_.'product_attachment pa
        LEFT JOIN '._DB_PREFIX_.'attachment a ON a.id_attachment = pa.id_attachment
        LEFT JOIN '._DB_PREFIX_.'attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = '.intval($id_lang).')
        WHERE pa.id_product = '.intval($id_product));
    }

    public function getAttachments($id_lang)
    {
        return self::getAttachmentsStatic($id_lang, $this->id);
    }

    /*
    ** Customization management
    */