Jump to content

[risolto] Ordine delle features (funzioni)


Recommended Posts

Ciao
ho la versione 1.0
quando inserisco delle features si visualizzano in un ordine: es. A B C

mentre quando le seleziono dalla finestra del prodotto (features) si visualizzano al contrario: C B A

come mai ?? mi potreste dire come risolvere questo problema ? o devo inserirle ogni volta al contrario ???

Link to comment
Share on other sites

La modifica riguarda una sola funzione del file classes/Product.php (provo a incollarla qui va bene per la versione 1.0)

   /*
   * Select all features for a given language
   *
   * @param $id_lang Language id
   * @return array Array with feature's data
   * VV001 aggiunto ORDER BY name
   * VV001 aggiunto leva prefisso
   */
   static public function getFrontFeaturesStatic($id_lang, $id_product)
   {

       /* ORIGINAL FUNCTION:
       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));
       */

       $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`');

       /* Modify SQL result */
       $resultsArray = array();
       foreach ($result AS $row)
       {
           $row['name'] = preg_replace('/^[0-9]+\./', '', $row['name']);
           $resultsArray[] = $row;
       }
       return $resultsArray;

   }

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...