} else {
$catIds[$page_uid][] = $shopRecord;
}
}
}
foreach ($catIds as $page_uid => $catIdsToAdd) {
foreach ($catIdsToAdd as $foreign_cat_id) {
if ($foreign_cat_id > 0) {
$insertArray = array();
$insertArray['categories_id'] = $reflector_cattree[$foreign_cat_id];
$insertArray['foreign_categories_id'] = $foreign_cat_id;
$insertArray['page_uid'] = $this->showCatalogFromPage;
$insertArray['foreign_page_uid'] = $page_uid;
$query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_categories_to_categories', $insertArray);
$res = $GLOBALS['TYPO3_DB']->sql_query($query);
$has_products = mslib_fe::getProducts('', $catid);
if (count($has_products)) {
foreach ($has_products as $product_id => $product_data) {
$updateArray = array();
$updateArray['categories_id'] = $foreign_cat_id;
$updateArray['products_id'] = $product_id;
$updateArray['sort_order'] = time();
$updateArray['page_uid'] = $page_uid;
$updateArray['related_to'] = $reflector_cattree[$foreign_cat_id];
// create categories tree linking
tx_mslib_catalog::linkCategoriesTreeToProduct($product_id, $foreign_cat_id, $updateArray);
}
}
}
}
}
public function getSitemap($categories_id, $array = array(), $include_disabled_categories = 0, $include_products = 1)
{
$str = "SELECT * from tx_multishop_categories c, tx_multishop_categories_description cd where c.page_uid='" . $this->showCatalogFromPage . "' ";
if (!$include_disabled_categories) {
$str .= "and c.status=1 ";
}
$str .= "and c.parent_id='" . $categories_id . "' and cd.language_id='" . $this->sys_language_uid . "' and c.categories_id=cd.categories_id order by c.sort_order";
$qry = $GLOBALS['TYPO3_DB']->sql_query($str);
if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry)) {
// cats
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry)) {
$array['subs'][] = mslib_fe::getSitemap($row['categories_id'], $row, $include_disabled_categories, $include_products);
}
} else {
if ($include_products) {
// products
$products = mslib_fe::getProducts('', $categories_id);
if (is_array($products)) {
if (!count($array)) {
// starting point doesnt have subcats, but products instead.
$array['subs'][0]['products'] = $products;
} else {
$array['products'] = $products;
}
}
}
}
return $array;
}
