Opened 17 months ago

Closed 10 months ago

Last modified 10 months ago

#1836 closed Neues Feature (fixed)

CrossSelling-Gruppen Sortierung nutzen

Reported by: Karsta Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.6.0
Component: Shop Version: 2.0.5.1

Description (last modified by Tomcraft)

In der Datei admin/cross_sell_groups.php sind noch asbach uralte xtc Relikte drin.
So wurde wohl vor langer Zeit für die cross_sell_groups.php die order_status.php kopiert und diese Zeile nicht korrekt angepasst:
$contents[] = array('text' => '<br /><b>' . $oInfo->orders_status_name . '</b>');

Außerdem wird in der Datenbank eine Sortierung eingetragen, die man leider nicht nutzen kann, da das Inputfeld dafür fehlt.
Ich hänge hier mal die korrigierte Datei admin/cross_sell_groups.php mit ran.

Wenn man nun die Sortierung der Gruppen auch im Frontend nutzen möchte, was ich für sinnvoll halte, muss dafür allerdings noch die Sortierung für Crossellinggruppennamen auch in die Datei includes/classes/products.php mit eingegeben werden.

SUCHEN:

      $cross_sells_query = xtDBquery("SELECT px.products_xsell_grp_name_id,
                                             pxg.groupname
                                        FROM ".TABLE_PRODUCTS_XSELL." px
                                   LEFT JOIN ".TABLE_PRODUCTS_XSELL_GROUPS." pxg
                                             ON px.products_xsell_grp_name_id = pxg.products_xsell_grp_name_id
                                                AND pxg.language_id = '".(int)$_SESSION['languages_id']."'
                                       WHERE px.products_id = '".(int)$pID."'
                                    GROUP BY px.products_xsell_grp_name_id");

ERSETZEN:

      $cross_sells_query = xtDBquery("SELECT px.products_xsell_grp_name_id,
                                             pxg.groupname
                                        FROM ".TABLE_PRODUCTS_XSELL." px
                                   LEFT JOIN ".TABLE_PRODUCTS_XSELL_GROUPS." pxg
                                             ON px.products_xsell_grp_name_id = pxg.products_xsell_grp_name_id
                                                AND pxg.language_id = '".(int)$_SESSION['languages_id']."'
                                       WHERE px.products_id = '".(int)$pID."'
                                    GROUP BY px.products_xsell_grp_name_id
									ORDER BY pxg.xsell_sort_order
									");

Attachments (1)

cross_sell_groups.php (14.6 KB) - added by anonymous 17 months ago.

Download all attachments as: .zip

Change History (10)

Changed 17 months ago by anonymous

comment:1 Changed 17 months ago by Tomcraft

  • Description modified (diff)

comment:2 Changed 16 months ago by GTB

  • Milestone changed from modified-shop-2.0.5.2 to modified-shop-2.0.6.0

comment:3 Changed 16 months ago by Tomcraft

  • Component changed from Admin to Shop

comment:4 Changed 10 months ago by karsta

Und dann sollte natürlich noch folgendes für die Sortierung der CrossSellingGruppen? in die Datei includes/classes/product.php (Zeile:390) eingefügt werden:

ORDER BY pxg.xsell_sort_order ASC

comment:5 Changed 10 months ago by anonymous

Sorry, nach Zeile 373

GROUP BY px.products_xsell_grp_name_id
ORDER BY pxg.xsell_sort_order ASC");

comment:6 Changed 10 months ago by Tomcraft

  • Milestone changed from modified-shop-2.0.7.0 to modified-shop-2.0.6.0
  • Type changed from Bug/Fehler to Neues Feature

comment:7 Changed 10 months ago by GTB

  • Resolution set to fixed
  • Status changed from new to closed

In 13117:

fix #1836 - add sort order for xsell groups

comment:8 Changed 10 months ago by GTB

In 13118:

fix #1836 - add sort order for xsell groups

comment:9 Changed 10 months ago by GTB

In 13119:

fix #1836 - add sort order for xsell groups

Add Comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.