При указании includeThumbs вылезает "дубль" товара
Вызов такой:
Ситуацию воспроизвел на тестовом сайте:
[[!mFilter2?
&limit=`0`
&parents=`0`
&element=`msProducts`
&filters=`
ms|price:number,
ms|old_price:boolean
`
&showLog=`1`
&tpls=`tpl.msProducts.row`
&includeThumbs=`240x180`
&class=`msProduct`
&tplOuter=`tpl.mFilter2.outer`
&tplFilter.outer.ms|price=`tpl.mFilter2.filter.slider`
&tplFilter.row.ms|price=`tpl.mFilter2.filter.number`
]]
При перемещении порядка фото в галерее товара, на странице категории выводится два одинаковых товара s7797.h7.modhost.pro/index.php?id=4. Если в сниппете msProducts убрать строку 54 $groupby[] = "`{$thumb}`.url";
, то все выводится нормально. Ситуацию воспроизвел на тестовом сайте:
s7797.h7.modhost.pro/manager/
s7797
LF6bxblDvgZi
Комментарии: 4
Лог
0.0024860: pdoTools loaded.
0.0000570: Conditions prepared
0.0000150: xPDO query object created
0.0000570: leftJoined msProductData as Data
0.0000379: leftJoined msVendor as Vendor
0.0000372: leftJoined msProductFile as 240x180
0.0000010: Grouped by msProduct.id, `240x180`.url
0.0000172: Added selection of msProduct: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000081: Added selection of msProductData: `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`
0.0000060: Added selection of msVendor: `name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`
0.0000041: Added selection of msProductFile: url as `240x180`
0.0000091: Processed additional conditions
0.0000639: Added where condition: class_key=msProduct, msProduct.id:IN(5,5,6), msProduct.published=1, msProduct.deleted=0
0.0000200: Sorted by msProduct.id, ASC
0.0001140: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`link_attributes`, `msProduct`.`published`, `msProduct`.`pub_date`, `msProduct`.`unpub_date`, `msProduct`.`parent`, `msProduct`.`isfolder`, `msProduct`.`introtext`, `msProduct`.`richtext`, `msProduct`.`template`, `msProduct`.`menuindex`, `msProduct`.`searchable`, `msProduct`.`cacheable`, `msProduct`.`createdby`, `msProduct`.`createdon`, `msProduct`.`editedby`, `msProduct`.`editedon`, `msProduct`.`deleted`, `msProduct`.`deletedon`, `msProduct`.`deletedby`, `msProduct`.`publishedon`, `msProduct`.`publishedby`, `msProduct`.`menutitle`, `msProduct`.`donthit`, `msProduct`.`privateweb`, `msProduct`.`privatemgr`, `msProduct`.`content_dispo`, `msProduct`.`hidemenu`, `msProduct`.`class_key`, `msProduct`.`context_key`, `msProduct`.`content_type`, `msProduct`.`uri`, `msProduct`.`uri_override`, `msProduct`.`hide_children_in_tree`, `msProduct`.`show_in_tree`, `msProduct`.`properties`, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties`, `240x180`.url as `240x180` FROM `cHJJ22EjWdO5_site_content` AS `msProduct` LEFT JOIN `cHJJ22EjWdO5_ms2_products` `Data` ON `msProduct`.`id` = `Data`.`id` LEFT JOIN `cHJJ22EjWdO5_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `cHJJ22EjWdO5_ms2_product_files` `240x180` ON `240x180`.product_id = msProduct.id AND `240x180`.rank = 0 AND `240x180`.path LIKE '%/240x180/%' WHERE ( `msProduct`.`class_key` = 'msProduct' AND `msProduct`.`id` IN (5,5,6) AND `msProduct`.`published` = 1 AND `msProduct`.`deleted` = 0 ) GROUP BY msProduct.id, `240x180`.url ORDER BY msProduct.id ASC "
0.0004880: SQL executed
0.0000429: Total rows: 3
0.0000131: Rows fetched
0.0000200: Returning raw data
0.0005660: Checked the active modifiers
0.0018320: Loaded "modChunk" with name "tpl.msProducts.row"
0.0054190: Compiled Fenom chunk with name "modchunk/2"
0.0015728: Time to load products options
0.0317070: Total time
6 291 456: Memory usage
&groupby=`msProduct.id`
Не выходит, получается, что к массиву groupby в msProducts добавляется еще один элемент.
Это баг сортировки картинок, будет исправлен в новой версии miniShop2.
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.