public static function myContracts() { $user_id = Yii::app()->user->id; $concat = new CDbExpression('concat("合同编号:",id," ",name) as name'); $contracts = Yii::app()->db->createCommand()->select(array('id', $concat))->from('groupon_contract')->where('create_id=:uid', array(':uid' => $user_id))->queryAll(); $contracts = A::map($contracts, 'id', 'name'); return $contracts; }
/** * 根据父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; }