function getCateArray($cate_type, $pid) { if ($cate_type == 0) { $table_name = DB_PREFIX . 'deal_cate'; } else { if ($cate_type == 1) { $table_name = DB_PREFIX . 'shop_cate'; } else { if ($cate_type == 2) { $table_name = DB_PREFIX . 'event_cate'; } } } if ($cate_type == 2) { $sql = "select id,name,0 as pid, '' as py, '' as icon, 0 as has_child from " . $table_name . " where is_effect =1 "; //echo $sql ;exit; $tree_list = $GLOBALS['db']->getAll($sql); } else { $sql = "select id,name,pid,uname as py, '' as icon from " . $table_name . " where is_effect =1 and is_delete =0 and pid = " . $pid; $list = $GLOBALS['db']->getAll($sql); foreach ($list as $k => $v) { $count = intval($GLOBALS['db']->getOne("select count(*) from " . $table_name . " where is_effect =1 and is_delete =0 and pid = " . $v['id'])); if ($count > 0) { $list[$k]['has_child'] = 1; } else { $list[$k]['has_child'] = 0; } } $tree_list = m_toTree($list, "id", "pid", "child"); } if ($pid == 0) { $all = array(); $all[] = array("id" => 0, "name" => "全部分类", pid => 0, py => "", icon => "", has_child => 0); $tree_list = array_merge($all, $tree_list); return $tree_list; } else { return $tree_list; } }
function getCatalogArraySearch() { $list = $GLOBALS['cache']->get("m_CATELISTSEARCH"); if ($list === false) { $sql = "select id,name,pid,uname as py,icon from " . DB_PREFIX . "deal_cate"; $list = $GLOBALS['db']->getAll($sql); foreach ($list as $k => $v) { $count = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_cate where pid = " . $v['id'])); if ($count > 0) { $list[$k]['has_child'] = 1; $child = new m_child("deal_cate"); $ids = $child->getChildIds($v['id'], $pk_str = 'id', $pid_str = 'pid'); $ids[] = 0; $child_list = $GLOBALS['db']->getAll("select id,name,pid,uname as py from " . DB_PREFIX . "deal_cate where id in (" . implode(",", $ids) . ")"); foreach ($child_list as $kk => $vv) { $count = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_cate where pid = " . $vv['id'])); if ($count > 0) { $child_list[$kk]['has_child'] = 1; } else { $child_list[$kk]['has_child'] = 0; } } $list[$k]['child'] = m_toTree($child_list, "id", "pid", "child"); } else { $list[$k]['has_child'] = 0; } } $GLOBALS['cache']->set("m_CATELISTSEARCH", $list); } return $list; }