/**
  * 獲得樹(shù)狀數(shù)據(jù)
  * @param $data 數(shù)據(jù)
  * @param $title    數(shù)據(jù)庫(kù)中字段名
  * @param string $fieldPri  數(shù)據(jù)庫(kù)中主鍵id
  * @param string $fieldPid  數(shù)據(jù)庫(kù)中父id
  * @return array
  */
 static public function tree($data, $title, $fieldPri = 'cid', $fieldPid = 'pid')
 {
  if (!is_array($data) || empty($data))
   return array();
  $arr = Data::channelList($data);
  foreach ($arr as $k => $v) {
   $str = "";
   if ($v['_level'] > 2) {
    for ($i = 1; $i < $v['_level'] - 1; $i++) {
     $str .= "│ ";
    }
   }
   if ($v['_level'] != 1) {
    $t = $title ? $v[$title] : "";
    if (isset($arr[$k + 1]) && $arr[$k + 1]['_level'] >= $arr[$k]['_level']) {
     $arr[$k]['_name'] = $str . "├─ " . $v['_html'] . $t;
    } else {
     $arr[$k]['_name'] = $str . "└─ " . $v['_html'] . $t;
    }
   } else {
    $arr[$k]['_name'] = $v[$title];
   }
  }
  //設(shè)置主鍵為$fieldPri
  $data = array();
  foreach ($arr as $d) {
   $data[$d[$fieldPri]] = $d;
  }
  return $data;
 }

/**
  * 獲得所有子欄目
  * @param $data 欄目數(shù)據(jù)
  * @param int $pid 操作的欄目
  * @param string $html 欄目名前字符
  * @param string $fieldPri 表主鍵
  * @param string $fieldPid 父id
  * @param int $level 等級(jí)
  * @return array
  */
 static public function channelList($data, $pid = 0, $html = " ", $fieldPri = 'cid', $fieldPid = 'pid', $level = 1)
 {
  $data = self::_channelList($data, $pid, $html, $fieldPri, $fieldPid, $level);
  if (empty($data))
   return $data;
 
  foreach ($data as $n => $m) {
   if ($m['_level'] == 1)
    continue;//結(jié)束單次循環(huán)
   $data[$n]['_first'] = false;
   $data[$n]['_end'] = false;
   if (!isset($data[$n - 1]) || $data[$n - 1]['_level'] != $m['_level']) {
    $data[$n]['_first'] = true; 
   }
   if (isset($data[$n + 1]) && $data[$n]['_level'] > $data[$n + 1]['_level']) {
    $data[$n]['_end'] = true;
   }
  }
  //更新key為欄目主鍵
  $category=array();
  foreach($data as $d){
   $category[$d[$fieldPri]]=$d;
  }
  return $category;
 }

//只供channelList方法使用
 
 /**
  * 獲得所有子欄目
  * @param $data 欄目數(shù)據(jù)
  * @param int $pid 操作的欄目
  * @param string $html 欄目名前字符
  * @param string $fieldPri 表主鍵
  * @param string $fieldPid 父id
  * @param int $level 等級(jí)
  * @return array
  */
 static private function _channelList($data, $pid = 0, $html = " ", $fieldPri = 'cid', $fieldPid = 'pid', $level = 1)
 {
  if (empty($data))
   return array();
  $arr = array();
 
  foreach ($data as $v) {
   $id = $v[$fieldPri];
   if ($v[$fieldPid] == $pid) {
    $v['_level'] = $level;
    $v['_html'] = str_repeat($html, $level - 1);
    $arr[] = $v;
 
    $tmp = self::_channelList($data, $id, $html, $fieldPri, $fieldPid, $level + 1);
    $arr = array_merge($arr, $tmp);//array_merge把兩個(gè)數(shù)組整合為一個(gè)數(shù)組
   }
  }
  return $arr;
 }