get_setting('OrderComponentID'); $site_id = (int)$netshop->get_catalogue_id(); $sql = "SELECT `Item_ID`, `Item_Type` FROM `Netshop_OrderGoods` AS `a` JOIN `Message{$order_table}` AS `b` ON (`a`.`Order_Component_ID`={$order_table} AND `a`.`Order_ID`=`b`.`Message_ID`) WHERE `Catalogue_ID` = $site_id ORDER BY `Order_ID` DESC LIMIT 10"; $rows = (array)nc_db()->get_results($sql, ARRAY_A); $goods = new nc_netshop_item_collection(); $goods->set_index_property('_ItemKey'); // обеспечит уникальность товаров в коллекции foreach ($rows as $row) { try { $item = nc_netshop_item::by_id($row['Item_Type'], $row['Item_ID']); if (!$item['Sub_Class_ID']) { throw new Exception(''); } // seems that the item data is missing if ($item->has_parent()) { $item = $item['_Parent']; } $goods->add($item); } catch (Exception $e) {} } if (count($goods)) { echo '
'; }