/**
* 根据父ID和等级获取对应的分类信息
* @param int $pid
* @param int $level
* @return array
*/
public static function getCates($pid = 0, $level = self::LEVEL_ONE)
{
$query = new Query(Yii::app()->db);
$query->from('groupon_cates');
$query->select('id,name');
$query->andWhere('pid=:pid AND level=:level', array(':pid' => $pid, ':level' => $level));
$cates = $query->queryAll();
if (!empty($cates)) {
$cates = A::map($cates, 'id', 'name');
}
return $cates;
}
/**
* 获取子市区的键值对列表
* @param int/null $pid 父ID
* @param int $grade 等级
* @return array
*/
public static function getAreas($pid = null, $grade = self::GRADE_PROVINCE)
{
$key = 'arealist_' . $grade . '_' . $pid;
$areas = Yii::app()->cache->get($key);
// dump($areas);
if ($areas === false) {
$query = new Query(Yii::app()->db);
$query->select('id,name');
$query->from('area');
if ($pid == null) {
$query->andWhere('parent_id is null');
} else {
$query->andWhere('parent_id=:pid', array(':pid' => $pid));
}
$areas = $query->queryAll();
if (!empty($areas)) {
$areas = A::map($areas, 'id', 'name');
}
Yii::app()->cache->set($key, $areas, 60 * 60 * 24);
}
// dump($areas);
return $areas;
}
