$news_categories_query = tep_db_query("select nc.news_categories_id, nc.sort_order, nc.news_categories_name, nc.parent_id, nc.date_added, nc.icon from " . TABLE_NEWS_CATEGORIES . " nc where nc.news_categories_name like '%" . tep_db_input($search) . "%' order by nc.sort_order, nc.news_categories_name"); } else { $news_categories_query = tep_db_query("select nc.news_categories_id, nc.sort_order, nc.news_categories_name, nc.parent_id, nc.date_added, nc.icon from " . TABLE_NEWS_CATEGORIES . " nc where nc.parent_id = '" . (int) $current_news_categories_id . "' order by nc.sort_order, nc.news_categories_name"); } while ($news_categories = tep_db_fetch_array($news_categories_query)) { $news_categories_count++; $rows++; // Get parent_id for subnews if search if (isset($HTTP_GET_VARS['search'])) { $cPath = $news_categories['parent_id']; } if ((!isset($HTTP_GET_VARS['cID']) && !isset($HTTP_GET_VARS['nID']) || isset($HTTP_GET_VARS['cID']) && $HTTP_GET_VARS['cID'] == $news_categories['news_categories_id']) && !isset($cInfo) && substr($action, 0, 3) != 'new') { //get category con $news_categories_childs = array('childs_count' => tep_childs_in_news_categories_count($news_categories['news_categories_id'])); //lay cac news thuoc category $news = array('news_count' => tep_news_in_news_categories_count($news_categories['news_categories_id'])); $cInfo_array = array_merge($news_categories, $news_categories_childs, $news); $cInfo = new objectInfo($cInfo_array); } if (isset($cInfo) && is_object($cInfo) && $news_categories['news_categories_id'] == $cInfo->news_categories_id) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_NEWS, tep_get_news_categories_path($news_categories['news_categories_id'])) . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_NEWS, 'cPath=' . $cPath . '&cID=' . $news_categories['news_categories_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_NEWS, tep_get_news_categories_path($news_categories['news_categories_id'])) . '">' . tep_image(DIR_WS_ICONS . 'folder.gif', ICON_FOLDER) . '</a> <b>' . $news_categories['news_categories_name'] . '</b>'; ?> </td> <td class="dataTableContent" align="center"> </td> <td class="dataTableContent" align="right"><?php
function tep_news_in_news_categories_count($categories_id, $include_deactivated = false) { $products_count = 0; if ($include_deactivated) { $products_query = tep_db_query("select count(*) as total from " . TABLE_NEWS . " n where n.news_categories_id = '" . (int) $categories_id . "'"); } else { $products_query = tep_db_query("select count(*) as total from " . TABLE_NEWS . " n where n.news_status = '1' and n.news_categories_id = '" . (int) $categories_id . "'"); } $products = tep_db_fetch_array($products_query); $products_count += $products['total']; $childs_query = tep_db_query("select news_categories_id from " . TABLE_NEWS_CATEGORIES . " where parent_id = '" . (int) $categories_id . "'"); if (tep_db_num_rows($childs_query)) { while ($childs = tep_db_fetch_array($childs_query)) { $products_count += tep_news_in_news_categories_count($childs['news_categories_id'], $include_deactivated); } } return $products_count; }