ecshop实现商品品牌无限制级分类

2,465次阅读
一条评论
分类代码:
//jimphei's code
function brandcat_list($cat_id = 0, $selected = 0, $re_type = true)
{
	$result=array();

    static $res = NULL;
  if (isset($_POST['brand_name']))
  {
	  if(strtoupper(EC_CHARSET) == 'GBK')
	  {
		  $keyword = iconv("UTF-8", "gb2312", $_POST['brand_name']);
	  }
	  else
	  {
		  $keyword = $_POST['brand_name'];
	  }
	  $sql = "SELECT * FROM ".$GLOBALS['ecs']->table('brand')." WHERE brand_name like '%{$keyword}%' ORDER BY sort_order ASC";
  }
  else
  {
	  $sql = "SELECT * FROM ".$GLOBALS['ecs']->table('brand')." where parent_id=$cat_id ORDER BY sort_order ASC";
  }
  $res=$GLOBALS['db']->query($sql);
  
  while($row=$GLOBALS['db']->fetchRow($res))
  {
	  //print_r($row);
	  $brand_logo = empty($row['brand_logo']) ? '' :
            'ecshop实现商品品牌无限制级分类';
        $site_url   = empty($row['site_url']) ? 'N/A' : ''.$row['site_url'].'';
        $row['brand_logo'] = $brand_logo;
        $row['site_url']   = $site_url;
		for($i=0;$i<$row['level'];$i++)
		{
			$row['margin'].='    ';
		}
		$result[]=$row;
		//$result[]['child']=
  }
  
  foreach($result as $k=>$v)
  {
	  $result[$k]['child']=brandcat_list($v['brand_id']);
  }
  
  if($re_type)
  {
	  $options='';
	  $pid='';
	  foreach($result as $k=>$v)
	  {
		  $pid=$v['brand_id'];
		  if($selected==$v['brand_id'])
		  {
			  $selected='selected="selected"';
		  }
		  if($v['brand_id']==$pid)
		  {
			   $options.=''; 
		  }
		  $options.=''; 
	  }
  }
  return $result;
									  
}

//jimphei's code
function list_arr($arr)
{
	$result=array();
	foreach($arr as $k=>$v)
	{
		
		$row['brand_id']=$v['brand_id'];
		$row['brand_name']=$v['brand_name'];
		$row['brand_logo']=$v['brand_logo'];
		$row['site_url']=$v['site_url'];
		$row['margin']=$v['margin'];
		$row['parent_id']=$v['parent_id'];
		$row['level']=$v['level'];
		$row['brand_desc']=$v['brand_desc'];
		$row['is_show']=$v['is_show'];
		$row['sort_order']=$v['sort_order'];
		$result[]=$row;
		if(!empty($v['child']))
		{
			$result=array_merge($result,list_arr($v['child']));
		}
	}
	return $result;
}
//jimhei's code
function get_brand_optons($selected=0,$arr)
{
	$result='';
	foreach($arr as $k=>$v)
	{
		$sel='';
		if($selected==$v['brand_id'])
		{
			$sel="selected=\"selected\"";
		}
		$result.="";
		if(!empty($v['child']))
		{
			$result.=get_brand_optons($selected,$v['child']);
		}
	}
	return $result;
}
正文完
 

公众号

评论(一条评论)