/** * 获得资源的标签 * * $res_id single id or an array of id * $res_type * * return Array multi - res_id=>tags; single - tag * */ public function &tagsByRes($res_id, $res_type) { $resTable = $this->resTable($res_type); if (is_array($res_id)) { $sql = 'select r.res_id,t.id,t.title'; $sql .= " from xxt_tag t,{$resTable} r"; $sql .= ' where t.id=r.tag_id'; $sql .= " and r.res_id in (" . implode(',', $res_id) . ")"; $sql .= ' order by r.res_id'; if ($rels = parent::query_objs($sql)) { foreach ($rels as $rel) { $result[$rel->res_id][] = array('id' => $rel->id, 'title' => $rel->title); } } } else { $sql = 'select t.id,t.title'; $sql .= " from xxt_tag t,{$resTable} r"; $sql .= ' where t.id=r.tag_id'; $sql .= " and r.res_id='{$res_id}'"; $result = parent::query_objs($sql); } !isset($result) && ($result = array()); return $result; }